Assign a stable reference before grouping anything
Give each reel or continuous piece a line ID and use it in the spreadsheet, photo filenames, and any document folder. Record manufacturer, part number, product designation, and the image that shows the readable tag or jacket. Reels may be grouped only after the record shows they genuinely share the same product and the same relevant condition facts.
A warehouse overview can supply context, but it cannot replace the line-level identification. The goal is a path from row to reel to photo, not a visually impressive total.
- Line or reel ID
- Photo filename matched to the line
- Manufacturer, part number, and product designation
Retain quantity on every reel or piece
For each row, record conductor metal, size, count, marked voltage, condition, and continuous length. Then label the quantity basis as measured, documented, or estimated. Do not replace per-reel figures with a grand total because a total cannot show which reel has a partial length, different condition, or missing marking.
Keep gross, net, and estimated weight labels beside the value they qualify. A loaded reel figure should not be converted into a conductor-content claim.
- Metal, size, count, and marked voltage
- Continuous length and quantity basis
- Condition and separate weight basis
Group locations and release contacts deliberately
Create a site group for each warehouse, yard, or project location. Identify the rows included at that site, the release-authority role, access restrictions, and any difference in loading resources. Similar cable at separate locations still needs separate access and release facts.
The City describes Brockton as having three commuter rail stops, extensive bus networks and major highway access. That general transport context does not state anything about a seller's gate, loading condition, collection schedule, or lot terms; those must be recorded for the actual storage site.
- Physical storage location
- Site-group name and included line IDs
- Release-authority role and access restriction
Record handling facts without offering a logistics promise
Where known, add reel dimensions, whether the weight is gross, net, or estimated, available loading equipment, and the seller's requested timetable. These are practical facts that help frame a lot-specific discussion. They do not mean a truck, crane, or collection time has been agreed.
If a site cannot confirm a loading detail, record it as unknown and identify the person or document needed to resolve it. Do not copy a handling fact from one site group to another.
- Reel dimensions
- Weight value with stated basis
- Available loading equipment and site-specific limitation
Repair the single-total mistake
The recurring mistake is one footage or weight total for multiple reels and sites, supported by one representative photo. The repair is one row per reel or continuous piece, a matched photo reference, site grouping, and an explicit quantity basis. This keeps the distinct material and release decisions visible.
For a genuinely identical subset at one site, the group can retain a shared product description, but the row must still disclose reel count, length basis, condition differences, and the photo used for that subset.
- Do not use one photo as proof for every reel
- Keep site groups separate
- Do not hide estimated footage inside a total
Model unknowns in a fictional multi-site record
Fictional example only—not a purchased lot: BL-BRK-05-A at Site A, one reel, 500 ft documented; BL-BRK-05-B at Site B, one reel, 90 ft estimated; gross loaded-reel weight documented; separate site contacts; loading limits pending. The two rows do not become one quantity simply because their product description may match.
When a release contact or loading restriction is incomplete, retain the line and mark the field pending. Add the next information source, such as a site manager or storage record, rather than filling the cell with an assumption.
- References: BL-BRK-05-A and BL-BRK-05-B
- Site A: 500 ft documented; Site B: 90 ft estimated
- Loading limits: pending
