◆ 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
See the prompt↓More track workflows

The same job, four prompts

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.

How to do it

the tool · the steps · what to avoid
The tool
Tables

Excel Tables organize and manage related data, making it easier to sort, filter, and analyze information for various business functions.

  1. 1

    Select a cell within your data, or select the range of cells you wish to include.

    Best practiceActivate any cell in your data, and Excel will intelligently set the boundaries for the table.

  2. 2

    On the Home tab, select Format as Table.

  3. 3

    Alternatively, on the Insert tab, in the Tables group, click Table.

  4. 4

    Choose a style for your table from the gallery.

  5. 5

    In the Create Table dialog box, set or confirm your cell range.

  6. 6

    Mark the checkbox next to My table has headers if your first row contains column names.

  7. 7

    Click OK to create the table.

Once your data is in a Table, you can easily add it to a Data Model by clicking Table Tools Design > Power Pivot > Add to Data Model.

Yes, Excel Tables can be created and manipulated programmatically using VBA or Office Scripts for automation.

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.