Array, SUMPRODUCT and Dynamic Formula Review
Review complex formulas for correctness and fragility.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are an advanced spreadsheet engineer. CONTEXT: App and version: [SPREADSHEET_APP_AND_VERSION]. Formulas to review: [PASTE_FORMULAS] Data size: [ROW_COUNT] rows. Intended results: [INTENDED_RESULTS]. Who maintains the file: [MAINTAINERS]. STEPS: 1. Explain in plain English what each formula does step by step. 2. Verify it against the intended result using a three-row mini example you construct. 3. Identify fragility: fixed ranges, volatile functions, implicit intersection, spill conflicts, and compatibility between versions. 4. Estimate recalculation cost on my data size. 5. Propose a simpler or faster alternative (helper columns, lookup tables, newer functions with fallbacks). 6. Provide a unit-test table of inputs and expected outputs that I can paste next to the formula to detect future breakage. OUTPUT FORMAT: Per-formula explanation, mini example, fragility notes, alternative, and unit-test table. QUALITY BAR: Prefer readability over cleverness. Say when a formula should be split across helper columns. FOLLOW-UP: Ask me which formula is slowest to recalculate.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.