Examples
Examples
Try the starting example
- Stock [units,litres/unit,eligible boolean,ready minute,latest pickup minute]; enter JSON
- [[20,0.5,true,30,90],[10,1,false,0,90],[15,0.4,true,60,120]]
- Pickup time (minute)
- 60
- Vehicle usable volume (litres)
- 10
- Eligible prepared volume (litres)
- 16
- Whole vehicle trips (count)
- 2
- Excluded or unavailable row numbers (JSON)
- [2]
Try another scenario
- Stock [units,litres/unit,eligible boolean,ready minute,latest pickup minute]; enter JSON
- [[25,0.5,true,20,80],[20,0.4,true,40,100]]
- Pickup time (minute)
- 90
- Vehicle usable volume (litres)
- 12
- Eligible prepared volume (litres)
- 8
- Whole vehicle trips (count)
- 1
- Excluded or unavailable row numbers (JSON)
- [1]
Calculation method
Calculation method
Eligible prepared volume (litres)
Sum units×litres/unit for eligible rows whose window includes pickup time.
Whole vehicle trips (count)
ceil(eligible volume/vehicle usable volume).
Excluded or unavailable row numbers (JSON)
Rows ineligible or outside ready/latest pickup window.
Symbols and units
- a
- Stock [units,litres/unit,eligible boolean,ready minute,latest pickup minute]; enter JSON
- b
- Pickup time (minute)
- c
- Vehicle usable volume (litres)
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
- User-confirmed donation eligibility and pickup availability; volume planning only. 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.