The Stock Reconciliation Sheet holds the summary data that will be copied over to the detail sheets. The steps below are explained using a completed Stock Reconciliation.
Seeing the finished sheet helps you know what to expect from the function. The steps following each section will take you back to how to activate the calculation or connect to data in another location on the worksheet.
Stock Class 

Type the name to identify your stock REQUIRED, the first 4 characters must be unique from row to row for Agrimaster to keep the data separate 
Open No. 

Type the number of sheep you are starting with 
Subtotal Opening Numbers
Agrimaster calculates subtotals for consecutive rows of numbers (no blanks rows). Insert a blank row before the next group of numbers to create another set of subtotals. Agrimaster displays subtotals as bold, red text. Subtotals have to be started from the Stock Class column.
1. Click in the blank box underneath the last Stock Class you entered
2. Type + the Stock Class and the word Totals (for example: +Ewe Totals)
3. Press Enter
Agrimaster will calculate subtotals for any consecutive numbers above
Subtotals are displayed bold and red
4. Continue typing Stock Class data and add subtotals, if appropriate
Calculate Natural Increase (Estimated Births)
Nat. Inc. F5 

Press F5 to start a calculation based on the number of ewes and estimated birth rate 
1. Go to the Lambs row and click into the blank Natural Increase box
2. Press F5
3. At the Enter Link window, click on
· Select Source Worksheet – click Stock Reconciliation
· Select Source Column – click Open No.
· Select Source Row – click +Ewe
· Select Adjustment – click Percentage of
· Adjust by – type the number that approximates your flock’s birth rate (85% in this example)
4. Note Agrimaster changes the box colour to yellow and calculates a number
5. Click on the green tick to OK the selection
Worksheet Colour Coding
Agrimaster colour codes the boxes and text in your worksheet as you enter your data:
· White boxes – type text or numbers into these boxes
· Light grey boxes – type data or convert to data calculated by Agrimaster
· Yellow boxes – data calculated by Agrimaster, such as a percentage of a number
· Bold, red text – Agrimaster calculates subtotals of the rows above with no blanks
Buy, Sell and Loss
Buy No. 

Type the number to be purchased for this class of stock 
Sell No. 

Type the number to be sold for this class of stock 
Losses F5 

Press F5 to calculate the estimated number lost by stock class 
Calculate Losses
Estimate the number of stock you lose to natural causes using the Losses column
1. Click into a blank box in the Losses F5 column
2. Press F5
In this example, 2% of the Wether Hoggets are lost each season
3. At the Enter Link window, click on
· Select Source Worksheet  Stock Reconciliation
· Select Source Column  Open No
· Select Source Row  Same ROW
· Select Adjustment  Percentage
· Adjust by  type 2
4. Click on the green tick to OK the selections
Copy Calculation
Copy the same calculation to the next box down, as long as there are no blank boxes or different calculations. As an example, the Stock Class losses are estimated 2% for all rows.
1. Click into Losses for 4 Yr Ewes and press F5
2. Complete the losses calculation using the steps in Calculate Losses, above
3. Right click into the Losses box for 3 Yr Ewes
Agrimaster will duplicate the calculation from the box immediately above
4. Repeat the right click into the Losses box for the 2 Yr Ewes
Agrimaster will duplicate the calculation from the box immediately above
Track Ageing Sheep
Each season the stock becomes a year older. Transfer your sheep from one age group to the next age group at the end of the season.
Before Transfers 

The number of stock before the stock is transferred to the next age group Agrimaster calculates the number of stock left after sales and losses. The total is Open No. + Buy No. – Sell No. – Losses. 
Trans. Out F5 

The number of stock you want to have included in the transfer Recommended, press F5 and link to the Before Transfers Alternatively, type a number 
Trans In F5 

The number of stock coming into this age group Recommended, press F5 and link to the Trans. Out for the younger year. This moves the stock up 1 year Each box must be calculated using F5 and the right click Duplicate function does not work on this function. Note that the 2 Yr Ewes come from the Ewe Hoggets 
Close No. 

Agrimaster calculates the number of stock at the end of the season 
Estimate Shearing Numbers
Shearing Number F5 

Recommended, press F5 and calculate the number of sheep Optional, type a number of sheep Used for planning the shearing costs and wool income in the Wool Sales and Crutching detail worksheets 
There are multiple options for summarizing the shearing numbers depending on your business
a) Press F5 and choose the number of sheep from Open No. (beginning of season) or Close No. (end of season)
b) Press F5 and calculate a number as a percentage to estimate numbers less losses
d) Press F3 to use the calculator to input a static number
In the example, the sheep will be sheared before being sold. The numbers from Sell No + Before Transfers are added and typed into Shearing Number F5.
Estimate Winter Sheep
Winter Number F5 

Type the number of sheep you expect to graze over the winter Alternatively, press F5 and link to Close No (end of season) or calculate a percentage of your flock 
Winter Grazed Ha 

Type the number to total hectares for all Stock Classes at the bottom of the list 


Use the Winter Number F5 and the total, in red at the top of the column, to decide how many sheep to carry through the winter Agrimaster will copy the Winter Number and Save Stock Worksheet GroupClick on the green tick to save the Worksheets after data entry is complete

Comments