Data & spreadsheets 5
Spreadsheet formulas, data cleanup and analysis prompts with checked output.
- Pivot table rows, columns, values: get the layout from AI
Turn a question and a few sample rows into a pivot layout plus a cleanup list, and see why the suggested SUMIFS check can agree with a wrong pivot.
claude-sonnet-5-5 · run 2026-10-20 (run with Claude, not ChatGPT) · recheck in Python 3 - Diagnose an Excel #SPILL! error with AI
When #SPILL! shows up although the cells below look empty, describe the sheet to Claude to narrow the cause, then find the invisible blocker yourself with LEN.
claude-sonnet-5-5 · run 2026-10-20 · Excel behavior per Microsoft 365 documentation (Excel not run) - Excel dates stored as text: get an AI formula and test it
Get one AI formula that turns 2026.03.05, 20260325 and 7/8/2026 into real dates, then test it on 30 expected values and impossible dates like month 13.
gemini-3.8-flash · 2026-10-20 run · checked with Python formulas 1.3.4 - SUMIFS date range criteria: have AI write it, then verify it
Get a SUMIFS for one month, one region, returns excluded, then check it against a 60-row test sheet with boundary-day rows. Includes what causes 0 and #VALUE!.
claude-sonnet-5-5 · run 2026-10-20 · formulas evaluated with Python formulas 1.3.4 (Excel not run) - Find why VLOOKUP returns #N/A with AI, then prove it in cells
A visible code still gives VLOOKUP #N/A? Give an AI the formula and a few rows, get test formulas back, and prove each cause in cells until #N/A count is 0.
claude-sonnet-5-5 (ChatGPT could not be run, so Claude was used) · run 2026-10-20