Build a reel index before totaling the lot
Give every reel a stable ID and carry that ID into the spreadsheet, photo filenames, tag images, and condition notes. Group only truly identical products, and preserve a per-reel entry when footage, condition, or storage point differs. An inventory reference is more useful than a warehouse-wide number that cannot be traced back to a reel.
The City says four interstate highways run through High Point: I-40, I-73, I-74 and I-85. That is limited local context for recording the actual storage and access details of a commercial lot; it is not a promise about freight, pickup, or route planning.
- Inventory ID
- Photo filenames tied to the ID
- Manufacturer and part number
- Storage location or ZIP
Keep per-reel footage and weight basis visible
Record reel count and continuous footage per reel, then label each figure measured, documented, or estimated. A total of 590 feet split between a 500-foot reel and a 90-foot partial reel is not the same inventory as one continuous 590-foot reel.
When a weight is supplied, state whether it is a gross loaded-reel figure, cable-only figure, or estimate. Do not use a combined site weight as if it describes each reel or proves conductor content.
- Reel count
- Footage per reel
- Quantity basis
- Gross loaded-reel weight basis
Group sites without erasing access differences
If material sits at more than one warehouse or staging point, keep each site group distinct. Include the site or ZIP, the release-contact role, dock or ground-level access, restrictions, and equipment that the seller says is available. State a requested timetable if one exists, but do not assume movement arrangements from an inquiry.
A photo set should reveal the whole reel, readable tag, jacket legend, and any condition issue for the same inventory reference. One clean reel image should not stand in for a mixed group.
- Site or ZIP
- Release-contact role
- Loading restrictions
- Available site equipment
Worked record: two sites are not one anonymous total
A fictional record uses BL-HP-01 and BL-HP-02 for the same recorded product designation. Site A has one reel at 500 feet documented; Site B has one reel at 90 feet estimated. The record also keeps the dock note and release contact visible. It is an illustrative inventory example, not a purchased lot.
The likely mistake is combining different sites, specifications, and weight bases into one grand total. Resolve it by preserving separate reel lines, site access fields, and the evidence basis for every number.
- One row per reel or continuous piece
- Separate site details
- Do not hide estimates in the total
