Rebuild one recurring spreadsheet task on a copy, with assistant-written formulas, plain comments and a check cell against a trusted total.
?? Your Monday report takes two hours by hand. What should you do first? Paste the whole file into an assistant and ask it to redo the report + Copy the file, then time this week's run by hand Start writing formulas into the file people use => Using a copy means nothing you try can affect a report someone's waiting for. The timed run is your baseline, the number the new sheet has to beat.
---
That might be a monthly report, a reconciliation or a clean-up you redo with every export. It should come round again, and you should know what the right result is.
[[big 120 min | your baseline: one run took 125 minutes, the next 115]]
---
[[flow Your columns and the result you want | A formula, each part explained | Test it on a known week]]
``` G2 =SUMIFS($D:$D,$B:$B,F2,$C:$C,"Paid") ```
On one month's export, this adds D where B matches F2 and C says Paid.
Comment: "Total paid orders for this region."
---
?# Your request to the assistant My sheet has {what's in each column}. I need {the result, in plain words}. Write the formula, explain each part in one line, and give me a one-line comment for it. Then add a check cell: OK if it matches {a total I trust}, CHECK if not.
---
[[flow Four regions added up: S$48,240 | All paid orders, any region: S$48,620 | Check: CHECK]]
The two totals should match. If they differ by more than a dollar, the cell shows CHECK where everyone can see it.
---
``` G7 =SUMIFS($D:$D,$C:$C,"Paid") G1 =IF(ABS(SUM(G2:G5)-G7)<=1,"OK","CHECK") ```
G7 adds every paid order, any region. G1 compares it with the four regions in G2:G5 and allows a dollar either way.
Comment on G1: "OK when the regions add up to all paid orders."
---
[[doc statement | Order 1041, North S$420 | Order 1042, East S$1,150 | Order 1043, South S$275 | Order 1044, Nort S$380 (1) | 1: "Nort" matches no region | find 1]]
Your old filter missed it too. Fix the spelling, then add a check for regions that aren't on your list.
---
``` G8 =COUNTA($B$2:$B$500)-SUMPRODUCT(COUNTIF($B$2:$B$500,$F$2:$F$5)) ```
Counts the filled region cells, minus the ones that match a region in F2:F5. Anything above 0 is a typo like "Nort".
Comment: "Rows with a region not on the list. Should be 0."
---
Keep the old way going until the new sheet runs cleanly once or twice, and time each run.
[[sum The rebuild took 90 minutes. A run now takes 45, against your 120. After how many runs have you saved more than the 90? | 2 | 1 => One run saves 120 - 45 = 75 minutes, still short of 90. | 75 => That's the saving per run. How many runs pass 90? | => Each run saves 120 - 45 = 75 minutes. Two save 150, past the 90.]]
---
?= Build your summary of the rebuild Rebuild a task that repeats and has an answer you already know | Rebuild the longest task, even if it only runs once Work on a copy and test each formula on a week you know | Trust a formula once the assistant has explained it A check cell compares your result with a total you trust | A check cell proves every formula in the sheet is right Keep the rebuild time separate from the time per run | Add the rebuild time to the first run
Make a copy of a report you run every week or month, send your assistant the request you just built, and add the formula, comment and check cell it gives you.
Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).