How to put PastureKey data into the Excel Forage Budgeting Spreadsheet
1) Open Excel Forage Budgeting Template provided to you. Please contact support@cibolabs.com.au or download a copy through the link below:
2) Go to your delivery folder and open the excel file provided (name of this file will look like: 'CIBO####-Propertyname-Paddocks-ClientSurname')
3) Copy and paste the following information from your CSV file to your budgeting spreadsheet (starting from the first blank row available):
- Title (these are your paddock names)
- Cibo_ha (these are your paddock areas)
- Cibo_tsdm_15_'date' (This is your 15 day median estimate of pasture biomass for your paddocks). Paste this into the column labelled 'Start Yield from Cibo CSV TSDM15'
4) Change start date/end date for your budget
5) Set your desired UR (we recommend 30%)
6) Delete any blank rows down the bottom of the spreadsheet