Give every reel a stable inventory reference
Assign a stable reference to every reel or continuous piece and repeat it in the inventory, filenames, photographs, and attached records. A simple site prefix plus reel number is enough. Place manufacturer, part number, complete product designation, and photo-file references in the same row so another person can match the stated material to the evidence without relying on a grand total.
Group only items that genuinely match on their documented specification. A shared warehouse, project, or product family name is not enough to make two reels one line. Differences should remain visible before the list crosses site boundaries.
- Reel or line reference.
- Manufacturer and part number.
- Complete designation.
- Photo and file references using the same identifier.
Keep quantity at the reel level
Record reel count and continuous footage per reel, with the basis for each number: measured, documented, or estimated. Preserve condition and weight basis in the same row. A grand-total footage number can hide that one site holds a full reel while another holds a short partial piece with different markings.
If a reel has only an estimate, say why it is estimated. Do not turn several cut pieces into one continuous length or use a gross reel weight as a substitute for footage. Those choices make a large list look simpler but make the actual seller task less clear.
- Reel count and length per reel.
- Measured, documented, or estimated quantity basis.
- Condition note per reel.
- Weight basis kept separate from length.
Draw the site and lot boundaries
Group the inventory by the physical site where it sits. For each group, record the storage site, owner, release contact, access restrictions, and existing loading resources. Then state whether the items form one offered lot or defined product or site groups. This prevents a buyer from treating a multi-location spreadsheet as though all rows have the same access and approval status.
The City of St. George says it has invested in transportation networks, utilities and telecommunications, and identifies St. George Regional Airport as Utah's largest regional airport. That is limited local infrastructure context; the inventory still needs its own site-level evidence and no movement arrangement is implied.
- Storage site for each group.
- Ownership and release contact.
- Access restrictions and existing loading resources.
- One-lot or defined-group boundary statement.
Keep excluded, reserved, and unknown lines visible
Add an included, excluded, reserved, or unknown status to each row. If an owner has not yet approved release, retain the line in the spreadsheet for context but do not count it within the stated offered boundary. A seller timetable can explain when an answer may be available without implying a decision or a collection date.
This discipline is especially useful when one inventory export covers several warehouses or project sites. It allows an inquiry to show the full picture while still identifying which specific records can be discussed as current material.
- Included or excluded status.
- Reserved or release-pending status.
- Unknown field note.
- Seller timetable for pending information.
Worked record and the grand-total error
A fictional two-site entry could read “BL-SG-05A: Site A, one reel, 500 ft documented; BL-SG-05B: Site B, one reel, 90 ft estimated; different release contacts; availability pending.” It is an illustrative record, not a purchased lot. It retains the per-reel quantity and the separate decision path for each location.
The error is using one total footage figure to conceal different sites, lengths, specifications, and approval status. Correct it with one row per reel or continuous piece, exact site grouping, and an explicit boundary for what is presently offered.
- Example references: BL-SG-05A and BL-SG-05B.
- Site A: 500 ft documented; Site B: 90 ft estimated.
- Different release contacts and availability pending.
