Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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)

...

Note

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?

...

  • Match template Text style, size, alignment etc
  • Delete excess rows and columns To prevent issues when printing

...

4. Save the file with a filename that matches the block code, e.g. ClientID-LocationID-BlockID

Related articles

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@957
showSpacefalse
sortmodified
typepage
reversetrue
typelabelspageofficeapp setup
cqllabel in ( "officeapp" , "setup" ) and type = "page" and space = "KB"labelsofficeapp setup
Page Properties
hiddentrue


Related issues