Examples
Examples
Try the starting example
- JSON Penetrations [ID,diameter mm,integer quantity]
- [["A",80,2],["B",120,2]]
- JSON Products [ID,inclusive minimum mm,inclusive maximum mm,stock count]
- [["small",50,100,3],["large",90,150,1]]
- Compatible instance assignments
- [["A#1","small"],["A#2","small"],["B#1","large"]]
- Unassigned penetration instance IDs
- ["B#2"]
- Allocated product quantities
- [["small",2],["large",1]]
Try another scenario
- JSON Penetrations [ID,diameter mm,integer quantity]
- [["A",80,2],["B",120,2]]
- JSON Products [ID,inclusive minimum mm,inclusive maximum mm,stock count]
- [["small",50,100,3],["large",90,150,2]]
- Compatible instance assignments
- [["A#1","small"],["A#2","small"],["B#1","large"],["B#2","large"]]
- Unassigned penetration instance IDs
- []
- Allocated product quantities
- [["small",2],["large",2]]
Calculation method
Calculation method
Compatible instance assignments
Expand penetration quantities and exact matching by inclusive product diameter ranges and stock capacity.
Unassigned penetration instance IDs
Maximum-matching shortages.
Allocated product quantities
Count assigned instances by product ID.
Symbols and units
- a
- JSON Penetrations [ID,diameter mm,integer quantity]
- b
- JSON Products [ID,inclusive minimum mm,inclusive maximum mm,stock count]
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
- Entered product diameter ranges and compatibility are authoritative inputs; diameter fit alone does not certify fire, water or system performance. Supported limits: At most 100 penetration instances and 200 total product stock seats.
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.