Build one traceable line per piece
Assign each reel or continuous piece a stable ID. Use that same ID in the inventory, image filename, and document filename so a reviewer can connect a label photo to the right amount of cable. A group identifier may organize matching reels, but it should not replace individual lines when their quantities or conditions differ.
Record the complete readable designation, conductor metal and size, any marked rating, reel count, continuous footage, and quantity basis. Write measured, documented, or estimated next to each length.
- Line or reel ID
- Matching photo filename
- Document filename
- Group identifier
Keep real storage sites separate
Create a section of the inventory for each warehouse, yard, or other actual storage site. For each group, list access restrictions, available loading resources, and the site release authority. These fields describe the seller’s information; they do not promise a collection method or schedule.
If a lot has identical product at two sites, keep the references and quantities separate. That prevents a combined total from suggesting one location or one release contact governs both groups.
- Actual storage location
- Access restrictions
- Available loading resources
- Site release authority
Preserve condition and quantity differences
Use a tag photo, jacket photo, overview, and visible-condition photo that match the actual line. Mark unused, removed, and recovery-only material separately rather than borrowing the best reel’s condition for the rest of the lot.
For a partially known line, keep it visible with unknown fields. A documented 500-foot reel and a 90-foot estimate are not interchangeable quantities, even if their labels match.
- Condition category
- Damage or storage note
- Continuous footage
- Quantity basis
A Roswell fact with limited relevance
Roswell’s Transportation Master Plan was first established in 2006, received a 2023 update, and has a planning horizon through 2050. The fact can explain why a seller may have a project-related closeout, but it does not identify a city-owned lot or establish buyer demand. The inventory still needs its own site, condition, quantity, and release evidence.
Do not use a project name in place of an item record. The practical seller decision is whether another reviewer can trace each offered piece from its spreadsheet line to its physical location and its release contact.
Worked multi-site example
Illustrative fictional bulk record—not a purchased lot: BL-RW-01 is a hypothetical matching product with 500 ft documented at fictional Site A; BL-RW-02 is the same hypothetical product with 90 ft estimated at fictional Site B. Fictional image names are BL-RW-01-tag.jpg and BL-RW-02-overview.jpg; separate site authorizers are unknown.
The error to avoid is submitting one grand-total footage number. Preserve each row and site group, flag estimates, and leave an authorizer unknown until the seller can document who controls release.
- Fictional example only
- One row per reel or piece
- Site groups stay separate
- Unknown authorizer remains visible
