Examples
Examples
Try the starting example
- JSON Employees [ID,eligible trips,supplied currency per trip,period cap currency] (USD)
- [["A",20,5,80],["B",12,6,100]]
- Reimbursement by employee (USD)
- [["A",80],["B",72]]
- Total reimbursement (USD)
- $152.00
- Above-cap amount (USD)
- $20.00
Try another scenario
- JSON Employees [ID,eligible trips,supplied currency per trip,period cap currency] (USD)
- [["A",25,5,80],["B",20,6,100]]
- Reimbursement by employee (USD)
- [["A",80],["B",100]]
- Total reimbursement (USD)
- $180.00
- Above-cap amount (USD)
- $65.00
Calculation method
Calculation method
Reimbursement by employee (USD)
J([[r[0],min(r[1]*r[2],r[3])] for r in a])
Total reimbursement (USD)
sum(min(r[1]*r[2],r[3]) for r in a)
Above-cap amount (USD)
sum(max(0,r[1]*r[2]-r[3]) for r in a)
Symbols and units
- a
- JSON Employees [ID,eligible trips,supplied currency per trip,period cap 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
- Eligible trip counts and reimbursement rates/caps are supplied policy inputs, not statutory defaults. 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.