Input-Driven Models: Inputs vs Calculations
All lessons
- Input-Driven Models: Inputs vs CalculationsFree
- Scenario Selector: Base, Best and Worst with CHOOSE and INDEX Pro
- One-Variable Data Table, Built with Formulas Pro
- Two-Variable Data Table with Mixed References Pro
- Goal Seek by Hand: Bisection Table vs the Algebraic Solution Pro
- Break-Even and Target Profit: Solve Instead of Seek Pro
- Tornado Sensitivity: Which Driver Moves Profit Most? Pro
- Monte-Carlo-Style Scenarios: Expected Value and the Chance of a Loss Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Read first
Conventions that make models what-if ready
- One input, one cell: the price appears once, everything else refers to it.
- Mark inputs visibly (in banking: blue font; in Tabellab labs: the yellow cells you type into).
- Put the unit in the label (USD, units, %).
- Calculations flow top to bottom, without circular references.
Loading the spreadsheet…