As-Built Reconciliation
Worksheet (Excel)

An as-built reconciliation worksheet tracks the drift between the AFC (Approved For Construction) revision of every engineering document and the final AB (As-Built) revision delivered at handover. It records every red-line change picked up during construction: routing changes, equipment substitutions, tag renames, instrument additions, sizing changes, material substitutions. Each change is traced back to its source (field walk-down, Management of Change record, vendor drawing, construction pack), verified in the field, and accepted by the owner before final as-built handover. Owner-operators require it for every CFIHOS handover dossier.

Standard columns: document number, document type (P&ID, line list, equipment list, SLD, loop diagram, layout), AFC and AB revisions with issue dates, red-line source, change description, affected tag, discipline, change type (routing, sizing, material, tag rename, equipment substitution, instrument addition or deletion), MoC reference, field verification status with verifier and date, drift impact on downstream artifacts (CFIHOS Class 5 tag entity, hydrotest pack, MC certificate, HAZOP node), downstream update required, owner acceptance. The columns drive the audit trail the owner-operator demands before signing the AB handover.

Pathnovo, an engineering document intelligence platform, auto-reconciles AFC to AB drift in 2 weeks. It ingests the AFC revision set, the construction MoC log, the field walk-down red-lines, and the proposed AB revision set, then diffs every P&ID, line list, equipment list, and SLD page by page and tag by tag. Drift is classified by change type, downstream impact is computed across the CFIHOS Class 5 tag space, and an exception report flags red-lines that were never propagated to the AB revision. See the as-built documentation workflow.

IFC (Issued For Construction) is the first construction-grade revision issued by engineering for field execution. AFC (Approved For Construction) is the IFC after construction-side review and approval, sometimes the same revision with sign-off. AB (As-Built) is the final revision after construction completion, updated to reflect every red-line picked up during construction. Owner-operators reject AB packages that have not closed the AFC-to-AB drift, the reconciliation worksheet is the evidence the EPC submits to prove the closure. See the document status reference.

Every construction-phase MoC must be reflected in the AB revision of the affected documents. The reconciliation worksheet ties each MoC to the AB document it updated, the affected tags, and the downstream impact (HAZOP node revisit, hydrotest pack regeneration, datasheet update, SIS logic update). Owner-operators audit the MoC-to-AB linkage during handover acceptance, gaps in the linkage are the most common cause of AB rejection. See the Management of Change standard reference.

For Indian PSU brownfield work under MoPNG and PNGRB jurisdiction, the as-built reconciliation worksheet additionally tracks the impact on OISD 118 inter-distance compliance (when equipment is moved or added), PESO Form XIV and XV pressure equipment registers (when pressure equipment is substituted), and IBR Form IV records (when boiler-side pressure equipment changes). The template optional columns capture OISD clause and PESO and IBR form references. See the OISD 118 compliance workflow and the PESO compliance workflow.

Once AB acceptance is signed, the reconciled tag and equipment data flows into the owner-operator's maintenance and asset systems. SAP PM equipment master and IBM Maximo asset register are bootstrapped from the CFIHOS Class 5 tag entities, the AB revision is the source of truth. Drift in the worksheet (tag rename, equipment substitution) drives equipment master updates in SAP PM and Maximo, missed drift means the maintenance system runs against ghost tags. See the engineering handover workflow for the full pipeline.