Give every reel a stable identity before grouping it
Assign a line or reel ID to each reel or continuous piece, then repeat that ID in the spreadsheet, photo filenames, tag images, and document list. Group only products that genuinely share a complete designation and condition basis. A grand-total footage figure cannot show whether a long reel, a partial reel, and a short cut length are interchangeable, so preserve the row-level record.
Boca Raton's iSIP program describes new water mains and meters, sewer force mains, stormwater upgrades, sidewalks and resurfaced roads as infrastructure improvements. That city fact supplies limited context for a project-handoff example; it does not state that cable is part of those improvements or that any project inventory is available.
- Use one reference for the reel, the photo set, and any supporting record.
- Group only matching products, not merely reels stored beside one another.
- Retain a separate row for each continuous piece with a different quantity basis.
Keep footage, dimensions, and weight bases distinct
Record the number of reels and continuous footage per reel, with each footage value labeled measured, documented, or estimated. Add dimensions and any known weight, but name the basis: gross loaded-reel weight, cable-only weight, or another documented basis. A loaded wooden reel is not the same thing as cable or conductor weight, and an estimate should remain an estimate.
When a lot has several similar reels, do not repeat one tag or one weight across every line unless the record actually covers all of them. An inventory can be concise while preserving the facts that differ. The goal is a usable handoff table, not a more impressive aggregate number.
- State footage per reel instead of only aggregate footage.
- Label every quantity measured, documented, or estimated.
- Identify gross weight separately from cable-only or conductor weight.
Separate sites, release contacts, and access limits
A bulk inquiry may cover more than one warehouse, yard, or project storage point. Keep those site groups separate and show which reel IDs are at each location. Record the relevant release contact, any site access restriction, and known loading resources for that group rather than assuming one person or arrangement covers the whole list.
This is the core distinction from a standard surplus list: the seller task is multi-reel, multi-site traceability. If Site A has documented reel footage and Site B has estimated footage, make that difference visible. If a release contact is pending at one site, do not let another site’s contact stand in for it.
- Include storage site and release authority with each site group.
- Note access restrictions and known loading resources separately.
- Do not collapse several sites into one availability or footage total.
Turn unknown handling facts into explicit follow-up items
If a reel’s dimensions, weight basis, release authority, or access detail is not documented, enter unknown or pending and explain what evidence could resolve it. For example, a site may need a flange measurement, a warehouse contact, or a current tag photo. This is more useful than copying an assumed value from another reel or using the lot’s heaviest recorded item for every line.
Match photos to line IDs: capture readable marking, reel overview, visible condition, and location context as permitted. A site-wide image may explain storage grouping, but it does not replace a tag or jacket image for an individual product.
- Write the missing field and the evidence needed to settle it.
- Keep a location image separate from identification photos.
- Do not use one reel’s data as proof for a different line.
Use a fictional multi-site handoff record
The mistake in a large lot is collapsing several sites and reel lengths into one total with one assumed handling arrangement. The remedy is one row per reel or continuous piece, site grouping, and a clearly stated basis for each quantity and handling detail. This preserves the factual differences a purchaser needs to discuss the actual lot.
Illustrative only—not a purchased Boca Raton lot: BL-BR-01 is a matching product with 500 feet documented at Site A; BL-BR-02 is a matching product with 90 feet estimated at Site B. The gross loaded-reel weight is unknown, and the release contact differs by site with authorization pending. That record makes the uncertainty concrete without inventing missing site facts.
- Mistake: combined footage and one assumed site arrangement.
- Resolution: reel-level rows plus site-level release and access facts.
- Keep unknown weight and authorization fields visibly unresolved.
