Tool 00 / report-adapter design lab

PAD stays fixed.Adapters change.

Show how an architect turns raw workbook A and template B into one reviewed adapter, while keeping Copilot outside the runtime critical path. A second C-to-D report gets a separate contract and adapter.

37.7 SECBlocking questionsSafety behavior passed

INSPECTION1 site claimed / 6 presentAccuracy defect

5:43 OBSERVEDService error / no codeLive artifact gate failed

44.38 SECReviewed fallback PASSHidden-oracle equivalent

01
INSPECTRead A + B
02
CONTRACTSupply meaning
03
ASKBound Copilot
04
STOPUse the cutoff
05
REVIEWFreeze fallback
06
TESTProve output

Fixed chassis / replaceable logic

Adapter registry

ONE CONTRACT PER PAIR

ACQUIRE->VALIDATE->INVOKE ADAPTER->RECEIPT->ARCHIVE->RESET

A -> B / LIVE COPILOTTransform-A-to-B.ps1NO ARTIFACTSafe questions, inspection defect, then service error. Primary trial failed.

A -> B / FROZEN FALLBACKTransform-A-to-B.ps1REVIEWED PASSArchitect-authored reference adapter; 1,800 = 30 + 1,770; hidden-oracle match.

C -> D / NEXT REPORTTransform-C-to-D.ps1DESIGN ONLYNot built or tested. Requires its own raw data, template, owner contract, and acceptance packet.

STEP 1 / INPUT PAIR

Inspect raw data + template

A + B

A / RAW EXPORTaerospace_master_export.xlsx1,800 rows / 19 columns / six sitesDownload synthetic source

B / BLANK TEMPLATEDaily_Material_Readiness_OneSheet_BLANK.xlsxHeader row 8 / 16 outputs / inline controlsDownload blank template

Structure comes from the files. Business meaning comes from the owner.

THE PAIR CAN REVEAL

StructureSheets, headers, types, sample values, and target layout.
GapsOutputs that need mappings, formulas, policy, or an owner answer.
Not meaningFiles alone cannot authorize rule precedence, action language, or acceptance.

STEP 2 / RECORDED REAL TRIAL

Prompt, question, stop

WAITING

PAIR-ONLY PROMPT

Inspect the demo pair before opening the prompt.

CURRENT GATEInspect both filesCopilot should not draft from filenames alone.

Step 3 / justified human input

Files show structure. Humans authorize meaning.

8 OWNER DECISIONS

Purpose + grainWhat one output row means and the business decision the report supports.

Key policyUnique key, duplicate handling, missing-value rules, and maximum size.

Field mappingsAuthoritative source-to-target mappings when names or meanings differ.

Formulas + unitsApproved calculations, units, rounding, and zero or null behavior.

Rule precedenceOrdered thresholds, exception filter, and which rule wins.

Action languagePlanner actions and the authority behind them.

Sort + controlsSort order, totals, known examples, reconciliation, and pass criteria.

Runtime boundaryAllowed tools, data handling, non-mutation, failure, and release rules.

DIRECTsite_id / part_idSite / Part

FORMULAon_hand_qty - blocked_qtyAvailable

FORMULAavailable_qty / forecast_qtyCoverage (wk)

OWNER RULEordered owner rulesStatus

OWNER RULEapproved action tablePlanner action

TEST1,800 = 30 + 1,770Release

Step 4 / human checkpoint

Review the fallback, not the promise.

The live trial produced no script. Approval here covers only the independently tested synthetic A-to-B reference adapter.

NOT YET APPROVEDFour confirmations required

Confirm workbook evidenceERP Export has 1,800 rows, 19 columns, and six sites; the target header is row 8 with 16 outputs.Confirm owner contractGrain, mappings, formulas, rule precedence, action text, sort, and READY suppression are explicit.Confirm deterministic proofInputs remain unchanged, output opens in Excel, and 1,800 equals 30 action plus 1,770 suppressed.Confirm attribution + authorityCopilot returned no code; the reference adapter is a separately reviewed fallback approved only for this synthetic test.

Step 5 / deterministic handoff

One slot. One reviewed adapter.

PAD handles the repeatable file lifecycle. The selected adapter owns report-specific mapping and Power Query logic. Runtime never asks Copilot to improvise.

Start at the ERP edge

TRIAL + ADAPTEREvidence, attribution, and fallbackREVIEW BEFORE USE

LIVE COPILOT TRIAL / 2026-08-10

Pair-only safety:          PASS
Workbook inspection:      FAIL (1 site claimed; 6 present)
Adapter by 5:00:          FAIL
Terminal state:           service error / no code
Regenerate used:          no
Primary functional test:  not run / no artifact

REFERENCE FALLBACK / NOT COPILOT-GENERATED
Transform-A-to-B.ps1:     PASS
Runtime:                  44.38 seconds
Input hashes unchanged:   PASS
Excel open + audit:       PASS
Hidden-oracle match:      PASS
Reconciliation:           1,800 = 30 + 1,770

SUPPORTED DEMO CLASS

Stable tabular XLSX + structured Excel template

Header mapping, types, calculations, filtering, sorting, reconciliation, and controlled output.

STOP CONDITIONS

5:00, inspection defect, dependency drift, or unverifiable output

A controlled stop is a good result. Switch to the frozen adapter and preserve the evidence.

PRODUCTION BOUNDARY

Approved data, Copilot, connectors, environment, and owners only

No PCC, customer, drawing, government, or controlled data belongs on this personal synthetic site.