Use a stable line ID as the inventory backbone
Assign one line or reel ID to every reel or continuous piece, then use it in the spreadsheet, photo filenames, and supporting files. Record manufacturer, part number, complete designation, conductor metal, size, count, marked rating, condition, and remaining footage. Group only items whose documentation actually shows the same specification.
Do not use one grand total of footage or weight to represent different products. A record with separate rows gives the reviewer a way to see which quantity belongs to which construction, and it lets unknown fields remain attached to the correct item.
- One line or reel ID reused across files
- Manufacturer, part number, and complete designation
- Conductor construction and marked rating
- Per-item footage, condition, and quantity basis
Match photos and quantity evidence to every row
For each distinct line, capture a tag image, jacket image, reel overview, and any visible damage view where available. Put the line ID in the filename. A wide warehouse photograph can show context, but it should not stand in for a readable label or a condition record for each reel.
State whether footage is measured, documented, or estimated. If a weight is available, identify the basis and keep loaded-reel, cable, and conductor assumptions distinct. If weight is not supplied, leave it unknown rather than calculating metal content from a photograph or cable length.
- Tag, jacket, overview, and damage images tied to the line ID
- Measured, documented, or estimated quantity basis
- Weight basis stated or left unknown
- Photo-pending rows remain visible
Separate site groups and release contacts
The city’s Department of Public Services says it is responsible for roads and roadways, watermains and sanitary sewers, rubbish removal and recycling, public buildings, cemeteries and private site-plan review.
That municipal responsibility is context for documenting practical site and release facts; it does not identify a City-owned cable lot. For each seller-controlled site group, state the location or ZIP, access restrictions, available loading information, and the person authorized to release the specific rows stored there.
Do not assign one person as the authority for a multi-site lot unless that person controls every listed group. Keep separate site group and authorization fields beside the corresponding line IDs, particularly when material is stored in different yards, warehouses, or project locations.
- Site group and storage location or ZIP
- Release authority matched to the applicable lines
- Access restrictions and available loading information
- No implied common authority across separate sites
Define the offered scope and keep uncertainty useful
State whether the seller is offering one complete lot or defined groups. Add any pending approval and a seller-requested timetable as inventory notes, not as an arranged collection plan. This lets the review distinguish a single available group from a spreadsheet that still has unresolved ownership or access issues.
When markings are unreadable, a photo is pending, condition is unknown, or access prevents inspection, preserve that status in the row. Explain the constraint and the available next evidence rather than forcing the item into a guessed material family or assuming that a photo from another reel applies.
- One-lot or defined-group scope
- Pending approval and requested timetable
- Unknown markings, condition, or photo status
- Access limitation and next evidence note
Worked multi-site record and correction
Illustrative fictional inventory example—not a purchased lot: BL-FH-01 is one reel with 500 ft documented at Site A and tag photo BL-FH-01. BL-FH-02 is a related product family with 90 ft estimated at Site B and a jacket photo pending. The lines remain separate because the second record has different site facts, a different quantity basis, and incomplete photo evidence.
The correction to a grand-total list is one row per reel or continuous piece, with its own specification, footage basis, condition, site group, and release authority. Unknown fields are not failures; they are a precise way to show what cannot yet be matched.
- BL-FH-01: documented footage and tag photo
- BL-FH-02: estimated footage and pending jacket image
- Different sites and authorizers remain visible
- No inferred conductor weight or condition
