How to use the Spreadsheet Sensitivity Analysis Generator.
Sensitivity analysis changes selected assumptions while holding the rest of the model consistent. Define the output formula and plausible ranges before building scenarios.
Make the workflow fit your task.
Define the model, baseline inputs and outcome first. Change one input at a time for a simple sensitivity table, keeping other assumptions fixed. Show units, tested ranges and calculated results; use separate scenarios when several assumptions change together.
- What you provide
- Model inputs, output formula and scenario ranges.
- What you get
- What-if table structure and deterministic recalculation instructions.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Profit equals price minus $25 cost; test prices $35, $40 and $45.
Completed example
Scenario profits: $10, $15 and $20 per unit, assuming the same supplied unit cost.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Does sensitivity analysis predict which future outcome will happen?
It shows how the model responds to assumed inputs. It does not establish probabilities or forecast accuracy.
Why do several inputs appear to change in a one-variable analysis?
Check linked formulas and dependent assumptions. State whether those relationships are part of the model or should be held fixed.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑