Follow

Sheep Reconciliation Worksheet

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

Age and gender are used in this example. Type a name that matches how you do business.

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

c)    Type a number

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
Winter Grazed Ha into the Stocking Rate detail worksheet
  

Save Stock Worksheet Group 

Click on the green tick to save the Worksheets after data entry is complete 



 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments