◆ Excel · track

Operational Reconciliation

Reconcile the FieldNotes control list with the AerialControls list to identify mismatches: use a lookup to match point…

2heights

18tasks

9roles do it

The same job, four heights

do it · improve it · decide · become

AExecute — “help me do it”Reconcile the FieldNotes control list with the AerialControls list to identify mismatches: use…+

Reconcile the FieldNotes control list with the AerialControls list to identify mismatches: use a lookup to match point IDs and report rows where coordinates differ by more than 0.5 m or the ID is missing in one list.

when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

BImprove — “do it better”Before I hand this to the QC engineer, prepare a reconciliation report they will trust: show…+

Before I hand this to the QC engineer, prepare a reconciliation report they will trust: show side-by-side coordinates, calculated delta in meters, color-highlight deltas above threshold, add a suggested action column (accept, survey, correct), and include the raw source filenames and timestamps for traceability.

when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

8 of them

Reconcile two lists of control points from field notes and aerial photogrammetry to identify mismatches that need correction.

Reconcile two delivery manifests to find which shipments still need to be charged to the project budget.

Reconcile two lists of invasive-species reports from contractors and volunteers to create one agreed incident log.

Reconcile two lists of exhibits so we can confirm every evidence item was logged and nothing is missing.

Reconcile two lists of exhibits—one from counsel and one from the court clerk—to find missing or duplicate items before trial.

Reconcile two lists of removed and returned files to show which items are still outstanding.

Reconcile two lists of orders and shipments to find missing deliveries that could delay invoicing and upset customers.

Reconcile two lists of appointments and transportation logs so I can confirm the client actually attended.

Who does this

9 roles

Construction ManagerLegal AdvisorSales ExecutiveTransportation PlannerCartographerHabitat Restoration WorkerLegal AssistantRecords ClerkSocial Worker

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.