Examples
Examples
Try the starting example
- Purchases [currency amount,eligible boolean]; enter JSON (USD)
- [[1000,true],[500,true],[200,false]]
- All-in rebate tiers [minimum eligible spend currency,rate fraction]; enter JSON (USD)
- [[0,0],[1000,0.02],[2000,0.03]]
- Rebate already received (USD)
- 20
- Eligible spend (USD)
- $1,500.00
- Earned rebate (USD)
- $30.00
- Rebate reconciliation balance (USD)
- $10.00
Try another scenario
- Purchases [currency amount,eligible boolean]; enter JSON (USD)
- [[1500,true],[800,true],[100,false]]
- All-in rebate tiers [minimum eligible spend currency,rate fraction]; enter JSON (USD)
- [[0,0],[1000,0.02],[2000,0.04]]
- Rebate already received (USD)
- 40
- Eligible spend (USD)
- $2,300.00
- Earned rebate (USD)
- $92.00
- Rebate reconciliation balance (USD)
- $52.00
Calculation method
Calculation method
Eligible spend (USD)
Sum eligible purchases.
Earned rebate (USD)
Eligible spend×rate at highest reached minimum; thresholds ascending and starting at zero.
Rebate reconciliation balance (USD)
Earned rebate−received.
Symbols and units
- a
- Purchases [currency amount,eligible boolean]; enter JSON (USD)
- b
- All-in rebate tiers [minimum eligible spend currency,rate fraction]; enter JSON (USD)
- c
- Rebate already received (USD)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- All-in rebate tiers: highest eligible spend threshold reached sets rate on all eligible spend; exclusions already user-marked. Supported limits: All numeric inputs and computed intermediates must remain finite. Supported numeric input magnitude is zero or 1e-12 through 1e12 in absolute value; reject values outside this bounded range. All lists/JSON record tables are limited to 100 records unless a stricter bound is stated; reject malformed record arity and wrong member types. All numeric values must be finite. Lists contain at most 100 records; required lists must be nonempty. Rates, probabilities and fractions are entered as fractions, not percentages; fractions must be between 0 and 1. Use a single consistent user-selected currency for all amounts; no exchange-rate conversion.
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.