/
Convert block sheets

Convert block sheets

Owned by Joshua Short (Unlicensed)
Last updated: May 08, 2023 by James Barnsley
1 min read

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,
e.g. ClientID-LocationID-BlockID

Block size (ha)

(optional)

Variety

(optional)

Total plants

Uses the formula =SUM to sum the total number of plants

Total dead plants

Uses the formula =SUM to sum the total number of dead plants

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