REVIEWING A TREE SPREADSHEET BEFORE REUSE

Clean a working copy without losing the meaning of the source record. Identify inconsistent IDs, units, dates and evidence references, and keep a log of approved changes rather than silently normalising everything.

Project/site:
Prepared by/date:
Version:

Source version
Identify the unmodified original schedule.
Notes:

Issue type
Describe the inconsistency found in a column.
Notes:

Affected records
List the tree IDs or rows involved.
Notes:

Approved change
State how the problem will be resolved.
Notes:

Review evidence
Keep source notes and the check result.
Notes:

CHECKS
[ ] Treat blanks differently from confirmed zero values.
[ ] Check text identifiers and date interpretation before saving a CSV.
[ ] Review affected exports after an approved correction.

Outstanding questions:
Source references:
Review and next action:

Scope: Cleaning does not validate professional conclusions or create missing observations; unresolved values remain explicit.

This is a general worksheet, not an automated application feature.
https://canopyapp.app/resources/tree-spreadsheet-data-cleaning