Turn a multi-site total into traceable line items
A grand total for several yards or warehouses hides the differences that determine whether a line can be reviewed. Give each reel or continuous piece a stable line ID and use it in the spreadsheet, photo filenames, and supporting documents. Record manufacturer, part number, complete designation, current length, quantity basis, condition, and storage site alongside the ID.
The recurring mistake is one total-footage row with one contact for the entire inventory. Correct it by splitting the record at the physical reel or continuous-piece level. If several reels are genuinely identical, they can be grouped only when their construction, current length, condition, site, and release status are all the same.
- Use one ID across the inventory row, photographs, and documents.
- Keep a line per reel or continuous piece when footage, site, or condition differs.
- Do not make one pristine reel stand in for a mixed group.
Preserve each quantity and condition basis
Record reel count and continuous length per reel rather than only aggregate footage. Identify every figure as measured, documented, or estimated. Keep gross, net, and unknown weight separate, and record the reason for an estimate when one is used. That lets a reviewer understand whether two shorter pieces have been incorrectly presented as one long length.
Document condition for the particular line with tag, jacket, reel, and accessible-end photos. If a tag is missing, retain a photo showing the missing tag and mark the designation unknown. Do not combine unidentified pieces with documented reels just to make the total look more complete.
- Report current continuous length, not merely original reel footage.
- State whether each number is measured, documented, or estimated.
- Keep unknown designation or condition on a distinct inventory line.
Separate sites, access facts, and authority
Group the line list by actual storage location. For each group, note the site or ZIP, reel dimensions, available loading equipment, access restrictions, and site-specific handling notes. These are planning details, not a commitment to a collection method. If one yard has a forklift and another has limited access, preserve that difference in the inventory.
Then identify ownership, availability status, and the person or role that can release each group. A single coordinator may receive the inquiry, but release authority can vary among locations. Mark a line reserved, retained, installed, or unknown when that is the documented status rather than treating every line in a spreadsheet as available.
- One location group needs its own access and loading information.
- Record ownership and release authority at the group or line level.
- Separate available material from reserved, retained, or unknown-status lines.
Keep the Bend road fact in proper scope
Deschutes County states that its Road Department is responsible for a 900-mile county road system and services including maintenance, snow and ice control, bridges, signing, engineering and capital projects. This is public-agency context, not evidence that the County has cable to sell, that a particular project has surplus material, or that Industrial Wire Buyer has any relationship with the County.
It is relevant only as a reminder that a contractor or public-works-adjacent seller may need to keep sites, access restrictions, and release contacts distinct. The buying decision still rests on the submitted line items and their actual material, quantity, condition, and authority records.
Replace the collapsed lot with a fictional site grid
A better submission shows the difference between lines rather than hiding it in a total. In the fictional example below, the second item remains estimated and its tag is pending; it is not allowed to borrow the first item’s product record. The unknown release information also stays visible for each site.
Before sending a multi-site inquiry, compare every photo filename with the inventory ID, confirm that each location has an access note, and identify which lines are actually available. Those checks create a workable purchasing record without assuming a transaction or transport arrangement.
- Illustrative fictional inventory example—not an actual or purchased Bend lot.
- BL-BEND-EX01: matching designation recorded; 500 ft documented; hypothetical Site A.
- BL-BEND-EX02: tag pending; 90 ft estimated; hypothetical Site B.
- Release and loading resources: unknown for Site B; recorded separately from Site A.
