A Spreadsheet Can Look Full and Still Be Missing What Matters
Published on: September 9, 2026
A spreadsheet can look full and still be missing what matters.
I call this the fallacy of fullness. You open the master sheet and it's dense: hundreds of rows, dates, names, coordinates. It feels like the project is well documented. But a full-looking sheet can still be missing farms, monitoring visits, or the evidence that ties a record to reality.
When I look at restoration project data, I run four tests, in order: Exhaustive, Complete, Correct, Current.
This is my working framework for looking past the appearance of a well-documented project. Each test asks a different question about the records and the operation behind them.
1. Exhaustive
Is there one record for every farm, site, and activity in scope?
Whole records are missing
| Expected site | Species in register | Trees planted |
|---|---|---|
| S-02 | Cordia alliodora | 490 |
| S-03 | Cedrela odorata | 525 |
| S-04 | No record | No record |
| S-05 | Inga edulis | 595 |
24 sites expected; 22 recorded. S-04 and S-17 are missing.
The sheet cannot answer that by itself. You need the denominator: the list of what should exist. Hundreds of precise records can still omit a few sites.
A monitoring log can be thorough about the places someone visited and silent about the ones no one did. Looking only at the existing rows will not reveal that absence. First establish which sites and visits belong in the review, then compare that expected set with the records you have.
If the expected set is unclear, that is a useful gap to identify before drawing conclusions about coverage.
2. Complete
For the records that exist, are the critical fields filled in?
Existing rows, empty cells
| Site | Species | Planted on |
|---|---|---|
| S-07 | Cedrela odorata | 08 Jun 2025 |
| S-08 | Missing species | 09 Jun 2025 |
| S-12 | Vochysia guatemalensis | Missing date |
Recover the species for S-08 and the planting date for S-12.
At scale, blank fields are normal, not a scandal. The question is which missing information matters to the project. A record may exist for every site while some of those records lack the details needed to understand the work.
Start with the critical fields. Make their purpose clear, identify where the information is missing, and decide what is worth recovering. Filling every possible field would demand time and effort that a team may need elsewhere.
This is why the first two tests remain separate. A complete record tells you about the information within that record. It cannot tell you whether another site is missing from the dataset entirely.
3. Correct
Do the values belong where they claim to?
A contract linked to the wrong farmer passes the first two tests and is still wrong. The farmer has a record, the attachment is present, and the sheet looks complete. The relationship between the evidence and the person is incorrect.
The wrong farmer’s contract
| Site | Farmer | Contract |
|---|---|---|
| S-09 | F-09 | AGR-F-11 |
| S-11 | F-11 | AGR-F-11 |
| Contract | Named farmer |
|---|---|
| AGR-F-11 | F-11 |
The contract names F-11, but S-09 belongs to F-09.
That example is a reminder to check more than whether a field contains something. The value or document needs to represent the right person, property, place, or activity.
Keep the evidence connected to the record so the relationship can be checked. When it is uncertain, identify what still needs verification rather than treating a filled field as a resolved question.
4. Current
“We planted trees here” is a statement about the past. “Those trees are living” is a claim about now, and its evidence changes over time.
Accurate then. Useful now?
| Site | Last visit | Next decision |
|---|---|---|
| S-05 | 06 Aug 2026 | Sep 2026 |
| S-06 | 07 Jul 2025 | Sep 2026 |
| S-19 | 20 Jul 2025 | Sep 2026 |
Revisit S-06 and S-19 before planning September maintenance.
Farms change hands. Nursery stock moves. A record that accurately described a situation when it was collected may no longer answer the question the team is asking today.
Historical records remain valuable. A planting date does not lose its meaning because time has passed. But a claim about current condition needs evidence from a time appropriate to that claim.
For planting work, this is the connection between the original activity and its follow-up: where, what happened, when, and what is true now.
The goal is not perfect data
Nobody has the people, time, energy, and budget for that.
Start with the fields that matter to your project and weigh each gap against what closing it costs. Some missing information will affect an immediate decision. Other gaps may be less urgent or expensive to resolve. The assessment should help the team make that choice.
The data you already have is valuable. A visible gap tells you where to improve next. It may point to a record that needs correcting, a missed visit, or a change in how the team captures information during the next round of work.
The payoff is timing. A missing monitoring visit you can see mid-season is something a team can still go fix. The same gap found at reporting time is only an explanation.