Recalculate a pricing model
A quote built from formulas in one HyperFormula engine, with no grid. Change an input and only the cells it reaches recalculate; those whose values change light up in order, timed in your browser.
5 stepsWatch a quote recalculate as its inputs and formulas change. Click or type into any card to take over.
Nothing recalculated yet
Change an input, and the cells whose values change light up in order.
6 formulas, 1 built-in function (XLOOKUP), 12 named expressions. Timed around setCellContents, in your browser.
Inputs
PriceEUR
Quantityunits
TaxRate%
EurUsdUSD per EUR
Volume discount
TierFrom, TierRate| From | Discount |
|---|---|
| 1 unitapplies | % |
| 50 units | % |
| 100 units | % |
| 250 units | % |
| 500 units | % |
Formulas
Subtotal€480.00
Discount€0.00
Net€480.00
Tax€110.40
Total€590.40
Total in USD$637.65
Make every data point count. Turn millions of them into actionable wisdom.
Let’s make it easier.
Smoother. Faster. All Handsontable.