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 /download file C.O.W or download the file Block-Sheet-Template.xlsx

2. Enter block details:

Client

Ensure

matches C.O.W

this matches the name for your client in Tātou Office

Costing Code

Optional - Overwrites

Overwrites Location and Client costing codes (optional)

Vineyard

Ensure

matches C.O.W

this matches the name for the vineyard in Tātou Office

RAPID No.

Optional

(optional)

Block name

Appropriate

A reference for Field employees to understand

/reference

where the job is located

Block code

Ensure

matches C.O.W eg

this matches the block code in Tātou Office,
e.g. ClientID-LocationID-BlockID

Block size (ha)

Optional

(optional)

Variety

Optional

(optional)

Total plants

Uses the formula =SUM

of plant column

to sum the total number of plants

Total dead plants

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

column

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?

54. Save the file with a filename to match that matches the block code above eg. eg, e.g. ClientID-LocationID-BlockID

...

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