Examples
Examples
Try the starting example
- Bookings [ID,service ISO date,old price currency,new price currency,honor old boolean]; enter JSON (USD)
- [["A","2026-11-01",50,55,true],["B","2026-11-10",70,80,false]]
- Price effective date (ISO date)
- 2026-11-05
- Communication list [booking,applied price,difference] (JSON) (USD)
- [["B",80,10]]
- Total affected booking price increase (USD)
- $10.00
Try another scenario
- Bookings [ID,service ISO date,old price currency,new price currency,honor old boolean]; enter JSON (USD)
- [["A","2026-11-07",50,60,false],["B","2026-11-10",70,85,true]]
- Price effective date (ISO date)
- 2026-11-05
- Communication list [booking,applied price,difference] (JSON) (USD)
- [["A",60,10]]
- Total affected booking price increase (USD)
- $10.00
Calculation method
Calculation method
Communication list [booking,applied price,difference] (JSON) (USD)
Affected if service date>=effective and not honored; output only affected rows with new price and new−old difference.
Total affected booking price increase (USD)
Sum new−old prices for affected bookings.
Symbols and units
- a
- Bookings [ID,service ISO date,old price currency,new price currency,honor old boolean]; enter JSON (USD)
- b
- Price effective date (ISO date)
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
- Existing booking price honors are explicitly entered; effective date compared with service date, without consent or communication delivery. 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.