Give every physical item a stable reference
Assign an inventory reference to every reel or continuous piece and use it in the spreadsheet, photo filenames, and any supporting record. Record manufacturer, part number, designation, condition, and storage location on the same row. If two items look similar but are stored at different sites or have different histories, their rows should remain distinct.
For genuinely matching products, a group can share a specification description while preserving the individual reel references and quantities. This makes it possible to trace a label image or release field back to the physical inventory.
- Stable line or reel ID in every file and photo name.
- Product designation and condition on the same row as the site.
- Separate rows for physically distinct reels or continuous pieces.
Keep footage and weight bases honest
List reel count and continuous length for each row, then label the quantity as measured, documented, estimated, or unknown. A lot total can be included as a summary only after the component rows remain visible. Do not imply that separate short pieces form one continuous length.
Record gross, net, or unknown weight with a note explaining whether the figure includes a reel, packaging, hardware, or cable only. If the basis is unknown, say unknown. This prevents a loaded-reel number from being mistaken for a material-only weight.
- Per-reel length and quantity basis.
- Gross, net, or unknown weight basis.
- Dimensions when they are available for large reels.
Group sites by their actual release record
For a multi-site lot, group the rows by actual storage location and record who can authorize release at that site, known access limits, and available loading resources. State whether the inventory is offered as one grouping or defined subgroups. Do not carry a Site A release contact into a Site B row simply because the product designation matches.
If a site detail is pending, identify it as pending next to the affected rows. A clear site matrix prevents an inventory sheet from implying that every reel has identical availability or handling conditions.
- Actual site or storage-location field.
- Release authority, access limits, and loading resources by site.
- Lot grouping stated without assuming identical terms across sites.
Use port facts only as local inventory context
Port NOLA facilities include 40 berths, 20 million square feet of cargo-handling area and more than 3.1 million square feet of covered storage area. That fact gives broad New Orleans cargo and storage context, but it does not identify a cable lot, establish a material location, or provide a release or handling arrangement for any seller.
For a bulk cable inquiry, the useful facts are still the seller’s actual item IDs, locations, quantities, condition notes, and release records. The local source does not replace the row-by-row evidence.
- Treat regional storage facts as context only.
- Use actual inventory and release records for the lot.
Correct the grand-total inventory mistake
Illustrative inventory example—not a purchased lot: NO-BL-FICT-A01 has 500 ft documented at fictional Site A, while NO-BL-FICT-A02 has 90 ft estimated at fictional Site B. The A01 entry is a gross loaded-reel weight, with conductor weight unknown. Each fictional row has its own release field. This is a format example, not a New Orleans transaction.
The mistake is hiding unlike items and sites in one grand-total footage figure or relabeling loaded-reel weight. The correction is one row per physical item, a visible basis beside each quantity, and release details that remain tied to the actual site.
- Do not aggregate unlike sites and quantity bases.
- Keep per-reel records visible below any summary.
- State the actual basis of every weight.
