ChatGPT / ChatGPT Files & Deliverables
ChatGPT: reconcile spreadsheet totals with an explicit rule
Provide small exports for expected and received equipment. Define whether the matching key is asset ID, serial number or purchase line.
Environment and inputs: ChatGPT user guide · Feature and source access depend on the active account, app and organization settings. Optional file or app steps have a text-excerpt fallback. No fixed model version, price or usage quota is assumed.
What you will make
A practical ChatGPT guide to reconcile spreadsheet totals with an explicit rule. Use the sample input and prompt, then check the result. Use a fictional small-office IT team as the practice setting. Keep the approved facts in a clearly labeled source block.
Prepare the source and scope
Provide small exports for expected and received equipment. Define whether the matching key is asset ID, serial number or purchase line. Open the ChatGPT app or website and start a focused conversation for this exercise.
Try this prompt
In ChatGPT, provide the prepared input, then send the following request. For real work, replace fictional details with approved facts.
Compare these two tables by asset ID. Report missing, unexpected and conflicting records. Preserve original rows and explain duplicate-key handling.Review the result
Manually reconcile a few matching and unmatched records and compare the grand totals by category. Record each correction and its supporting source.
If the answer is wrong or incomplete
Matching on a display name can merge different assets. Confirm that your selected key is actually unique. For recurring work, keep the active source list with the project brief; for a one-off task, supply just the relevant excerpt.
Practice and completion check
Repeat with one incomplete input. Check the answer against the review criteria, remove unsupported claims and save the prompt with its source version. This workflow has not been verified in a customer deployment.