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