What-If Scenario Tables in Excel
Test assumptions systematically.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Help me set up scenario analysis. Model description and the cells that drive it: [MODEL_INPUTS]. Output I care about: [OUTPUT]. Ranges for each input: [INPUT_RANGES]. Explain three techniques: a scenario table with named cases, a one-variable data table, and a two-variable data table, and show the steps to build each for my model. Include a layout for an assumptions sheet that keeps all inputs in one place with notes and sources, and a rule that outputs never contain typed numbers. Provide a method for a tornado-style ranking of which inputs matter most by changing each one by the same percentage. Add a reminder to document scenarios and to avoid presenting a single scenario as a forecast. Add a section for documenting each scenario with a name, owner and date, and a short template for presenting results that shows the assumption set next to the outcome. Add a short list of common errors, such as inputs hard-coded inside formulas, circular references, and tables that do not recalculate because calculation is set to manual.
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.