To make a copy of an individual worksheet you will need to:
- Start at the Home Page
- Click Budget
- Click Full Budget
- Click Worksheet
- Click Copy or Rename
- Select Copy Worksheet Group option
- Select the worksheet that you want to copy
- Enter a new name for the copied worksheet so you distinguish between the old and the new worksheets
- Click the Green Tick
Repeat for each worksheet for which you want to create ‘What If’ scenario’s.
To copy a Full Budget and all the worksheets and Grain Income Calculators, you will need to:
- Start at the HOME PAGE
- Click BUDGET
- Click FULL BUDGET
- Click COPY BUDGET
Options – You can choose to shift dates forward 1 year if full budget is to be used for a future year. Choose copy attached worksheets to also copy all worksheets attached to this budget.
To see what worksheets are attached to a budget, go to CHANGE BUDGET SETUP and view which worksheets have been selected to be included on the new budget.
Prefix & Suffix
Copied worksheets and Grain Income sets have to be renamed as well. Instead of separately naming all worksheets and Grain Income Calculator sets, you can choose to add text to either end of the existing name i.e. a prefix will be added to the beginning and a suffix will be added to the end. (e.g. Prefix: Plan B Cropping 19/20 or Suffix: Cropping 19/20 Copy)
We strongly recommend you rename your worksheets after you have copied a year forward and if you used either a prefix or suffix, because you will otherwise end up with worksheet names that don’t make much sense