How to convert a block sheet so it's ready to upload to a location.
Instructions
1. Copy or download the file Block-Sheet-Template.xlsx
2. Enter block details:
Client | Ensure this matches the name for your client in Tātou Office |
Costing Code | Overwrites Location and Client costing codes (optional) |
Vineyard | Ensure this matches the name for the vineyard in Tātou Office |
RAPID No. | (optional) |
Block name | A reference for Field employees to understand where the job is located |
Block code | Ensure this matches the block code in Tātou Office, |
Block size (ha) | (optional) |
Variety | (optional) |
Total plants | Uses the formula |
Total dead plants | Uses the formula |
3. Enter block data:
Copy across row numbers
Copy across plant numbers
Copy across dead plant numbers (if available)
Double check the following:
Are calculations correct?
Are there additional spaces before or in between numbers?
Are there blanks cells where numbers should be?
If a row has 0 plants, ensure 0 is entered instead of leaving it blank.
If no row number—why not?
4. Save the file with a filename that matches the block code, e.g. ClientID-LocationID-BlockID
Related articles
0 Comments