Guide / Reporting
How to reconcile a factual report against its geotechnical data
Short answer
Reconcile by counting, not reading: compare hole, sample and test totals between the report tables, the logs, the laboratory sheets and the AGS file; trace every difference to a source record; fix the source, regenerate, then re-count.
Why reports and data drift
Report tables, logs and lab sheets are often edited separately after the data is exported. Each edit is reasonable; together they produce a report that no longer matches its own AGS file.
A reconciliation method
1. Fix the source
Decide which record is authoritative — normally the data, not the document.
2. Count
Holes, depths, samples and tests by type, in each deliverable.
3. Trace differences
Every mismatch is traced to a specific record and a reason: missing, duplicated, renamed or edited.
4. Correct and regenerate
Correct the source record, then regenerate the tables, logs and file rather than editing each by hand.
5. Re-count and sign off
Repeat the counts. The responsible engineer signs off the reconciled set.
How G& helps
In G&, logs, laboratory outputs and the AGS file are generated from the same governed record, so the counts agree by construction and every change is traced. Narrative interpretation remains the engineer's.
Questions
- Which should win, the report or the data?
- Normally the data. Correct the record and regenerate the document.
- Does G& write the factual report narrative?
- No. G& generates data-driven outputs; the engineer remains responsible for the report.