Examples
Examples
Try the starting example
- JSON Measured items [ID,cumulative completed units,contract currency per unit,previously valued currency] (USD)
- [["A",100,20,1200],["B",50,30,1000]]
- Cumulative earned valuation (USD)
- $3,500.00
- Current-period earned valuation (USD)
- $1,300.00
- Valuation by item (USD)
- [["A",800],["B",500]]
Try another scenario
- JSON Measured items [ID,cumulative completed units,contract currency per unit,previously valued currency] (USD)
- [["A",120,20,1200],["B",60,30,1000]]
- Cumulative earned valuation (USD)
- $4,200.00
- Current-period earned valuation (USD)
- $2,000.00
- Valuation by item (USD)
- [["A",1200],["B",800]]
Calculation method
Calculation method
Cumulative earned valuation (USD)
sum(r[1]*r[2] for r in a)
Current-period earned valuation (USD)
sum(r[1]*r[2]-r[3] for r in a)
Valuation by item (USD)
J([[r[0],r[1]*r[2]-r[3]] for r in a])
Symbols and units
- a
- JSON Measured items [ID,cumulative completed units,contract currency per unit,previously valued currency] (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
- Measured quantities and agreed rates supplied; cumulative less previous valuation may be negative for correction. No contractual entitlement determination. 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.