Skip to main content
← Resources

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. 1. Fix the source

    Decide which record is authoritative — normally the data, not the document.

  2. 2. Count

    Holes, depths, samples and tests by type, in each deliverable.

  3. 3. Trace differences

    Every mismatch is traced to a specific record and a reason: missing, duplicated, renamed or edited.

  4. 4. Correct and regenerate

    Correct the source record, then regenerate the tables, logs and file rather than editing each by hand.

  5. 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.