◆ Excel · report

Parts List Verification

Reconcile the factory parts list against our bill of materials by placing factory list in column A and BOM in column D…

2heights
2tasks
1roles do it
See the prompt↓More report workflows

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Reconcile the factory parts list against our bill of materials by placing factory list in…+
Reconcile the factory parts list against our bill of materials by placing factory list in column A and BOM in column D, remove duplicates on each list, run a two-list reconciliation to mark missing or duplicated line items, and highlight any discrepancies before ordering.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Before procurement submits purchase orders, make reconciliation obvious to the sourcing…+
Before procurement submits purchase orders, make reconciliation obvious to the sourcing lead—standardize part number formats, remove duplicates, produce a three-column report: in-factory-only, in-BOM-only, and matched with counts, and add filters so the buyer can quickly isolate missing high-cost items.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

1 of them
Reconcile the factory parts list against our bill of materials to find missing or duplicated line items before ordering.

Who does this

1 roles
Industrial Designer

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.