Examples
Examples
Try the starting example
- Supplied service items JSON [part ID,required quantity,units per package,package price currency] (USD)
- [["filter",1,1,12],["washer",2,5,5],["fluid L",3.2,1,10]]
- Purchase table [part,packages,excess quantity,cost currency] (USD)
- [["filter",1,0,12],["washer",1,3,5],["fluid L",4,0.8,40]]
- Total parts basket (USD)
- $57.00
Try another scenario
- Supplied service items JSON [part ID,required quantity,units per package,package price currency] (USD)
- [["filter",1,1,12],["washer",4,5,5],["fluid L",4.2,1,10]]
- Purchase table [part,packages,excess quantity,cost currency] (USD)
- [["filter",1,0,12],["washer",1,1,5],["fluid L",5,0.8,50]]
- Total parts basket (USD)
- $67.00
Calculation method
Calculation method
Purchase table [part,packages,excess quantity,cost currency] (USD)
For each supplied compatible item: packages=ceil(required/packageQty), excess=packages*packageQty-required, cost=packages*price.
Total parts basket (USD)
Sum item purchase costs.
Symbols and units
- a
- Supplied service items JSON [part ID,required quantity,units per package,package price 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”.
Assumptions & limits
Assumptions & limits
- One explicitly compatible package option per part, no automated model fit or fluid/specification lookup. Quantities remain in row-specific units; no cross-part substitutions. Supported limits: 1..100 unique item/unit IDs; required>=0; packageQty>0; price>=0.
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.