Assign a reference that follows each physical item
Give every reel or continuous piece a stable line reference before grouping anything. Repeat that reference in the spreadsheet, photo filenames, supporting documents, and location tab. Products may be grouped only after the seller has confirmed that the complete designation, condition, location, and quantity basis are genuinely the same.
Whittier Public Works comprises eight divisions: Streets, Water, Solid Waste Disposal, Customer Service, Engineering, Fleet, Civic Center Maintenance and Sewer. That city fact provides limited context for why a large organization may have multiple custodians or records; it does not establish an offered lot, a city relationship, or a buyer transaction.
- Use one reference for every reel or continuous piece.
- Put the reference in the spreadsheet, photo filenames, and document names.
- Group only lines that remain identical in product, condition, location, and quantity basis.
Preserve per-reel quantity before the grand total
List continuous length, reel count, and whether the quantity is measured, documented, estimated, or unknown for each reference. A grand total may be useful as a summary, but it must not replace the per-reel record. A 500-foot documented reel and a 90-foot estimated reel are not interchangeable simply because both appear in the same inquiry.
Keep product differences visible as well. A mixed lot becomes reviewable when the total can be traced back to distinct rows, not when every item is reduced to a single footage number.
- Record per-reel length and reel count on each line.
- State the quantity basis beside the corresponding number.
- Retain the aggregate total only as a summary of traceable rows.
Keep sites, condition, and release contacts distinct
Build site-level groups around the actual storage location, then preserve condition and release contact for each line. Do not assume a contact at one yard can authorize material at another. Separate uninstalled stock, removed cable, and recovery-only material even when the specification happens to match.
If site access or release authority is unresolved, mark the line pending. That makes the uncertainty actionable and prevents one clear site from being used as proof for the rest of a multi-site list.
- Record site or location, condition history, release contact, and access limits per line.
- Mark a pending release contact rather than assuming authority across sites.
- Keep different conditions and material histories in separate rows.
Add handling facts without booking a move
Record reel dimensions, gross, net, or estimated weight basis, available loading resources, access restrictions, and a seller timetable for each site. These are facts a reviewer can use to understand scope. They do not select a collection method or create a transport arrangement.
When dimensions or weights are estimates, identify the basis and keep the estimate with the reference. A broad warehouse description is not enough for a reviewer to connect a handling constraint to a specific reel.
- Include dimensions and weight basis for each large reel.
- Describe access limits and seller-reported loading resources by site.
- State a seller timetable as a constraint, not as a promised collection date.
Use a fictional two-site mapping example
A fictional example uses WB-WH-BL-01 for a matching product with 500 feet documented at Site A and WB-WH-BL-02 for the same product with 90 feet estimated at Site B. The photos remain BL-01-tag.jpg and BL-02-tag.jpg, and Site B release authority is pending. The example is not a purchased lot; it demonstrates why a grand total must stay traceable.
Prepare the actual inventory in that same reference-led format before sending it for review. The result is a concrete list that can be discussed line by line without pretending every site has the same material or authority.
- Keep the fictional example separate from actual seller inventory.
- Use a different photo mapping for each reference.
- Do not turn an unresolved site release into an available-line claim.
