Box List Item Count per Linear Metre Estimate Calculator
Expand heterogeneous counted box-list inventory and measured widths to actual item density per linear metre; not a fixed box conversion or universal item density.
Description
A box-list inventory represents both counted items and occupied shelf width.
A box-list inventory represents both counted items and occupied shelf width. Different box types need separate representation weights.
Expand heterogeneous counted box-list inventory and measured widths to actual item density per linear metre; not a fixed box conversion or universal item density.
When to use Box List Item Count per Linear Metre Estimate Calculator
Use this tool to expand heterogeneous counted box-list inventory and measured widths to actual item density per linear metre; not a fixed box conversion or universal item density.
Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
How to use Box List Item Count per Linear Metre Estimate Calculator and understand its results
- Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
- Enter inventoriedItemCountsByBox, measuredOccupiedBoxWidthsM, representedBoxCounts using the field table and calculation rules, then run the tool.
- Read totalRepresentedInventoryItems, totalRepresentedLinearMetres, inventoryItemsPerLinearMetre. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| inventoriedItemCountsByBox | Inventoried item counts by box | list of number | Required |
| measuredOccupiedBoxWidthsM | Measured occupied box widths m | list of number | Required |
| representedBoxCounts | Represented box counts | list of number | Required |
Align nonnegative integer item and represented-box counts with positive widths. Require positive total represented length. Return total items, length and pooled density.1
Paired lists must be nonempty and have equal lengths.
items/meter = Σ items per box × represented boxes/Σ width × represented boxes Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| totalRepresentedInventoryItems | Total represented inventory items | number |
| totalRepresentedLinearMetres | Total represented linear metres | number |
| inventoryItemsPerLinearMetre | Inventory items per linear metre | number |
{
"input": {
"inventoriedItemCountsByBox": [
10,
30
],
"measuredOccupiedBoxWidthsM": [
0.2,
0.3
],
"representedBoxCounts": [
1,
2
]
},
"output": {
"totalRepresentedInventoryItems": 70,
"totalRepresentedLinearMetres": 0.8,
"inventoryItemsPerLinearMetre": 87.5
}
}Limitations and assumptions
No fixed box conversion or universal storage density is supplied.
Numbers and computed results must be finite; overflow produces an error. Numeric lists are limited to 100,000 entries; the rules above may require smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.
Alternative or Complementary methods
Use Collection Storage Occupancy Percent Fill Rate Calculator: Keep occupied/usable/blocked storage slot inventories and unequal store denominators separate; physical empty slots are not all usable conservation capacity. For a complementary task, use Catalogue Record Completeness Field Counter: Audit caller-required catalogue fields across aligned records, distinguishing complete records from pooled field coverage; actual schema/presence criteria are caller established.
References
Similar or alternative tools
- Collection Storage Occupancy Percent Fill Rate Calculator
Keep occupied/usable/blocked storage slot inventories and unequal store denominators separate; physical empty slots are not all usable conservation capacity.
- Catalogue Record Completeness Field Counter
Audit caller-required catalogue fields across aligned records, distinguishing complete records from pooled field coverage; actual schema/presence criteria are caller established.