Follow

Worksheet Tools

mceclip0.png

Move Worksheet Line

 Use these two icons to move a worksheet line up or down, relative to lines surrounding it. Click the grey numbered line first. 
mceclip0.png

Insert Line

Use this icon to insert a new blank line into the worksheet. You must click the grey numbered line first.
mceclip1.png

Delete 

Use this icon to delete the highlighted line. You must click the grey numbered line first.
mceclip2.png

Copy & Paste 

Use these icons to copy or paste a line of data within the worksheet.
mceclip3.png

Reports 

Click here to produce input and production reports on this and other worksheets.
mceclip4.png

Help  

Click here for help entering data into the worksheet.
mceclip5.png

Worksheet Calculator On/Off

Here you are able to turn the worksheet calculator on or off.  This means you can calculate a set area only if you wish to do so.
mceclip6.png

Sub Total 

This allows you to give a total of several lines in the worksheet (e.g. + Ewes Total).
mceclip7.png

Open Another Worksheet Group 

This allows you to have direct access to other Enterprise and Assets & Liabilities worksheets. Up to four sets of worksheets can be open at once. Those open will have a #.
mceclip8.png

Open Another Budget 

Allows you access to other budgets in this file.
mceclip9.png

Link 

The grey headings with F5 in the heading text allow you to insert a Formula into the grey areas of the worksheets. This will link data from other worksheets.
mceclip10.png

Cost List 

This is used to determine the cost of a particular action on the farm. An example would be how to calculate the number of Wool Packs required for shearing.
mceclip11.png

Printer 

This icon allows you to print the worksheet data that you have entered (should only be used for quick un-formatted reports).
mceclip12.png

Save 

By clicking this icon or pressing F10, it will save your data. Do this every few minutes or so and prior to closing your Budget or Worksheet. 
mceclip13.png

Month Distribution 

Press F5 or click this icon to select the month or months for data to be distributed directly to the budget. It will distribute data into receipts or payments, the bank account and the value.
mceclip14.png

Here you can change the month distribution from the same code for all lines (red) to a different code for each line (black). 
mceclip15.png

 This allows you to attach relevant grain income calculator sets to this worksheet and edit if necessary.  
mceclip16.png

These keys (each half of the square brackets) copy the information from the cell above. Once you have entered information into a cell, press either of these keys in a later line in the same column and the information will be repeated. You can also use your right-click button on your mouse to copy the line above. 
mceclip17.png

 

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

Comments