Use one reference system across every site
Give each reel or continuous piece a stable inventory reference. Use that same reference in the spreadsheet row, image file name, tag scan, and document note. A group may share a reference only when the seller can explain why its specifications, quantities, and location are genuinely the same.
A single total footage number does not identify the reels behind it. Keeping references stable makes it possible to see whether a label, photograph, and stated length belong to the same item even when the collection is being presented in one inquiry.
- Line or reel reference
- Photo file names with that reference
- Document reference and grouping rule
Preserve product and quantity differences
For each line, record manufacturer, part number, full designation, conductor metal, size and count, marked voltage, and continuous footage. Label footage measured, documented, estimated, or unknown. Matching manufacturer names alone are not enough to combine reels with different constructions or lengths.
Keep unknown products in the inventory instead of forcing them into an assumed category. Their rows can state the available photos, partial markings, and the next record needed for identification. That is more useful than hiding them inside a generic mixed-lot total.
- Manufacturer and part number
- Full designation and marked voltage
- Metal, size, count, and per-reel footage
Separate site, history, and access facts
Group lines by actual storage location and maintain condition history per reel: uninstalled stock, previously used material, or history unknown. Add storage exposure, ownership, available loading equipment, and access restrictions separately. A reel at one site should not inherit the access or condition facts of another.
Madison County Public Works regulates commercial site development in unincorporated Madison County, and most commercial developments require an approved Commercial Site Plan for a building permit. That fact supports careful site and release documentation, but it does not show that any cable lot is at a regulated site or can be moved.
- Physical site for each inventory line
- Condition history and storage exposure
- Owner, release contact, and access restriction
Keep unknowns usable in a large export
Retain a row when a tag, length, or condition field is incomplete. Mark that field unknown or estimated and state the evidence basis, such as a partial tag image or an inventory export. Do not replace an unknown per-reel figure with a site-wide total.
A simple confidence note can say what needs confirmation: tag photo, measured length, or release contact. The point is not to create a scoring system; it is to let the buying team see which questions belong to which reel and site.
- Unknown or estimated field marked plainly
- Evidence basis named for each estimate
- Specific next record needed for a gap
Fix the grand-total bulk-lot record
The common mistake is using one warehouse photograph and one grand-total footage count for reels at different sites. Correct it with one row per reel or continuous piece, photographs matched by reference, and separate site, condition, and release fields.
Illustrative inventory example—not a purchased lot: BL-HSV-07A at Site A, one reel, 500 ft documented, uninstalled; BL-HSV-07B at Site B, one reel, 90 ft estimated, condition history incomplete; separate release contacts; loading resources unknown. It is a fictional record format, not a purchased lot.
- One row per reel or continuous piece
- Separate site and release records
- Weight basis and dimensions when known
