Your business · Practical guide
Turn spreadsheet data into a checked report
Use a general assistant to plan calculations and explain a small dataset, then verify every number in your spreadsheet.
Before you start
- Make a copy of the spreadsheet and work on the copy. Remove names, identifiers, and confidential columns before pasting a small table.
- State what a row represents, the units, time period, and which statuses count. Keep unknown values distinct from zero.
- Calculate one simple subtotal yourself and keep it as a reference check. Use your existing spreadsheet software to run formulas.
- Keep the original data and filters visible. These starting workflows use pasted text; they do not require a file upload, connected app, or paid analysis feature.
When this helps
Useful for a small descriptive report, calculation plan, or explanation of an anonymized table. A general assistant can help reason through the work; your spreadsheet remains the place to reproduce and verify the numbers.
This prepares a draft. You review and take the final action.
Some setup and iteration · See the work involved
- Setup
- Prepare an anonymized sample and a spreadsheet copy.
- Your work
- Define counts and exclusions; run and reconcile formulas yourself.
- Iteration
- Resolve missing values and mismatched totals before writing the final report.
- Maintenance
- Keep the formula ranges and definitions current for each reporting period.
- Small descriptive dataset using pasted text.
- No upload, paid analysis feature, or onsite model call required.
An editorial estimate for this task, based on documented requirements. Your experience can differ.
Opening the brief builder…
Use your chosen tool
- Paste a small anonymized sample, define the rows and units, and ask one report question.
- Ask the assistant for a calculation plan and formulas suited to your spreadsheet software. Resolve missing definitions first.
- Run the formulas or a pivot table in a copy of the spreadsheet. Compare totals with a manually checked subset.
- Reconcile the result table against filtered row counts, dates, and missing values. Correct formulas before polishing the prose.
- Use the verified totals to revise the draft, keeping observations separate from possible explanations.
- Share only the report you have reviewed, with its period, definitions, exclusions, and limitations.
An illustrative example
Written to show the intended shape of a result; this is not a measured tool test.
Starting material
Fictional confirmed bookings: last week Repair 8 and Workshop 2; this week Repair 6 and Workshop 6. Equal-length weeks. Report service counts and overall percentage change; no causes supplied.
A useful draft
Illustrative checked summary: total bookings rose from 10 to 12, an increase of 2/10 = 20%. Repair fell from 8 to 6; Workshop rose from 2 to 6. The data does not explain why. These small totals are human-written reference arithmetic, not output from an assistant trial.
Check before using it
- Does every result use the correct row unit, period, filter, and status definition?
- Do grouped totals reconcile with the independently calculated overall total?
- Are missing values, duplicates, cancelled records, and zero denominators handled explicitly?
- Are percentages based on the right numerator and denominator, with consistent rounding?
- Are the formulas valid for your spreadsheet software and actually run on the intended range?
- Does the prose describe the observed change without inventing a reason or overstating a small sample?
If it needs work
- Show the row counts and intermediate totals behind this number. I cannot reconcile it with my spreadsheet.
- Blanks mean unknown, not zero. Recalculate or mark the result incomplete; do not fill values without a stated rule.
- Use Excel formulas for this version and explain the exact range and filters. Mark calculations unverified until I run them.
- Remove the suggested cause of the change. Report only the observed values and the data needed to investigate why.
The simpler alternative
Use a pivot table or SUMIFS/COUNTIFS with the correct filters, then write three sentences from the verified totals. For a tiny table, a manual subtotal may be faster.
When a specialist product may be worthwhile
Consider an analyst or approved reporting tool for large datasets, recurring dashboards, statistical claims, confidential records, or decisions that need an auditable calculation pipeline.
Sources and review
Documentation reviewed 2026-09-30. Plan limits and interfaces can change. How we prepare these guides.