# How to reconcile a factual report against its geotechnical data

> A method for making the factual report, borehole logs, laboratory sheets and AGS file agree: one source, counted totals, traced exceptions and a final cross-check before issue.

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

## FAQ

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