Examples
Examples
Try the starting example
- Trip loads JSON [ID,cargo kg,cargo m³,usable mass capacity kg,usable volume capacity m³]
- [["T1",500,4,1000,5],["T2",800,3,1000,5]]
- Trip utilization [ID,mass %,volume %,binding dimension]
- [["T1",50,80,"Volume"],["T2",80,60,"Mass"]]
- Capacity-weighted mass utilization (%)
- 65
- Capacity-weighted volume utilization (%)
- 70
- Trips above either supplied capacity
- 0
Try another scenario
- Trip loads JSON [ID,cargo kg,cargo m³,usable mass capacity kg,usable volume capacity m³]
- [["T1",500,4,1000,5],["T2",1100,3,1000,5]]
- Trip utilization [ID,mass %,volume %,binding dimension]
- [["T1",50,80,"Volume"],["T2",110,60,"Mass"]]
- Capacity-weighted mass utilization (%)
- 80
- Capacity-weighted volume utilization (%)
- 70
- Trips above either supplied capacity
- 1
Calculation method
Calculation method
Trip utilization [ID,mass %,volume %,binding dimension]
mass%=100*kg/kgCapacity; volume%=100*m3/m3Capacity; identify larger percentage or Both.
Capacity-weighted mass utilization (%)
100*sum(cargoKg)/sum(massCapacity).
Capacity-weighted volume utilization (%)
100*sum(cargoM3)/sum(volumeCapacity).
Trips above either supplied capacity
Count rows with cargoKg>massCapacity or cargoM3>volumeCapacity.
Symbols and units
- a
- Trip loads JSON [ID,cargo kg,cargo m³,usable mass capacity kg,usable volume capacity m³]
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
- Separate mass and volume ratios; do not add percentages. Supplied usable capacities are not inferred from vehicle ratings; ignores axle loads, shape, securement and legal capacity. Supported limits: 1..1000 unique trips; cargo>=0; capacities>0; overload inputs allowed and explicitly flagged.
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.