Give every piece a stable place in the inventory
Assign one reference to each reel or continuous piece and repeat it in the spreadsheet, photo filenames, and supporting records. Include manufacturer, part number, product designation, and the actual storage site. Group items only when the specification, condition, and site facts are genuinely the same; a broad total hides the differences that need review.
Use separate rows for distinct continuous lengths. A 500 ft documented reel at one site and a 90 ft estimated reel at another should remain two lines even if the product code matches. The same principle applies to mixed condition, different storage exposure, or different release contacts.
- Line or reel ID in every file name.
- Product designation and part number.
- Actual storage site for each row.
Keep quantity and handling facts per reel
Record per-reel footage, reel count, and whether each quantity is measured, documented, estimated, or unknown. Add weight only with its basis and dimensions when known. Do not use a grand total to imply that several cut lengths are one continuous run or that gross reel weight is cable weight.
Pair each record with a tag, jacket-printing, reel-overview, and condition photo where available. If a reel has no readable tag or its dimensions are unknown, retain that unknown. The inventory remains useful when the uncertainty is attached to the proper line rather than hidden inside the lot total.
- Per-reel footage and quantity basis.
- Weight basis and dimensions if known.
- Tag, jacket, reel, and condition photo references.
Separate site condition from seller-side logistics
Add fields for condition, known history, storage exposure, release contact, access limits, and available loading information at each site. A material list may cover more than one warehouse or yard, and one contact or forklift note should not automatically be applied to every location.
The fictional record BL-MPL-08 has BL-01, a matching product with 500 ft documented at Site A, and BL-02, the same product with 90 ft estimated at Site B; loading resources are unknown and authority is to be identified. It is an illustrative fictional inventory record—not a purchased lot. It demonstrates the correction for a single opaque total.
- Site-specific release contact.
- Access limitation and loading information.
- Condition and storage exposure per row.
Use metro context only to frame the record task
Metropolitan Council Environmental Services says it treats wastewater for 111 cities and townships and operates 634 miles of regional sanitary sewers, 231 metering stations, 60 lift stations and nine treatment facilities. This is regional context for keeping multi-site cable records organized; it does not identify stock at any facility, local demand, or a seller relationship.
Provide the actual storage sites privately with the bulk inventory and identify seller-side release contacts. Industrial Wire Buyer buys surplus wire and cable nationwide, while the practical scope of any particular bulk lot is determined from its line-level material, condition, access, and documentation—not from the city context.
- Actual site or ZIP.
- Seller-side release contact.
- Access and loading information described as known or unknown.
