Activities
Lineage means the recorded chain of origins: which stock contributed to an output, and what was later produced from that stock. Use this view when you want to answer “where did this come from?” or “what else came from the same source?”
Each row joins one source to one output through a production activity. An activity with several sources has several rows, so first read the connections rather than treating every displayed row as another quantity produced.
Click the search box in B4 and choose or type the complete Stock number or posted Activity number you want to follow. The list offers stock and activities already accepted on Post entries. Clear B4 to see all recorded connections.
After changing the search, click View results → beside the connection count to bring the matching rows into view. This is useful if you had scrolled down before searching. The link keeps the number you chose.
The view shows one step at a time rather than drawing the whole chain as a diagram. It fills itself from your production entries, so read the displayed rows without typing over them. A shared origin can help you decide what to investigate; it does not establish the condition of the related stock.
Use View Current Stock → to check the present quantities and locations of the stock you traced. To record a different production event, Next production entry → opens the next unused production row. Return to its original row if you are finishing an activity already started.
This is the reference for the work that connected the source and output. When the same activity number appears on several rows, read those rows together: they represent one production event with several contributing sources. You can use the reference to return to the corresponding Produce or harvest entry.
This is the date entered for the production or harvest activity. It tells you when that output was produced, rather than when you opened Lineage or searched for it. Read the date alongside the activity number when distinguishing repeated outputs from the same continuing source.
This identifies what the activity produced. Search for that number here to follow its other source or output connections. To find out how much of it remains, where it is or whether it is ready for use, open Current Stock using that same number. Moving the same stock later keeps its number; producing a separate output gives that output a new one.
This is the quantity produced by the whole activity. Where several sources contributed, the same output amount may be repeated beside each source so that every connection can be understood on its own. Those repeats are descriptions of the same output, not additional production. For quantities, read Current Stock or Activity summary rather than adding these repeated amounts together.
This unit belongs to Quantity produced and tells you what that amount measures. Read Source unit separately for the amount taken from the source. The numbers can describe different things and should not be added or subtracted as though they use the same measure.
This is one item or lot the output came from. If several sources contributed, each has a row. Search a source number to see where that source came from or what else was produced from it.
These entries describe what contributed to production. They do not record every specialised relationship a farm might need, so read them as an origin trail rather than assuming extra meanings that were never entered.
This is the amount removed from this particular source in the activity. Read it with Source unit to understand the measurement. A value of 0 means none of that source’s tracked quantity was consumed; the output quantity is recorded separately.
A continuing source can also show a positive Quantity used when some of its measured contents were taken while the source remained for later work. Read the actual quantity rather than assuming that every continuing source must show zero.
Read this label with Quantity used to understand the amount taken from that source. It can differ from the output’s Unit. Keep each number with its own unit when following the trail; the spreadsheet does not convert between them.