Examples
Examples
Try the starting example
- JSON Roles [ID,period cost currency,committed-or-exempt flag 0/1] (USD)
- [["A",20000,1],["B",15000,0],["C",10000,0]]
- Committed/exempt cost (USD)
- $20,000.00
- Avoidable scenario cost (USD)
- $25,000.00
- Retained role IDs
- ["A"]
Try another scenario
- JSON Roles [ID,period cost currency,committed-or-exempt flag 0/1] (USD)
- [["A",20000,1],["B",15000,1],["C",10000,0]]
- Committed/exempt cost (USD)
- $35,000.00
- Avoidable scenario cost (USD)
- $10,000.00
- Retained role IDs
- ["A","B"]
Calculation method
Calculation method
Committed/exempt cost (USD)
sum(r[1] for r in a if r[2]==1)
Avoidable scenario cost (USD)
sum(r[1] for r in a if r[2]==0)
Retained role IDs
J([r[0] for r in a if r[2]==1])
Symbols and units
- a
- JSON Roles [ID,period cost currency,committed-or-exempt flag 0/1] (USD)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Calculation steps and notation
sum(list) adds all entries in the list.
Assumptions & limits
Assumptions & limits
- All role costs are precomputed over a common freeze horizon from the supplied stop date. Committed/exempt flags are supplied contractual assumptions. Supported limits: All numeric inputs must be finite. Only the explicitly described mathematical scenario is supported.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.