Make one stable reference do the organizing
Assign a stable line or reel ID before assembling files. Repeat that ID in the spreadsheet, photo filenames, document captions, and site notes so another reviewer can connect a specification to the physical item. A multi-reel summary can be added after the line records are complete, but it should not replace them.
The central bulk-lot mistake is a single total footage figure that hides different lengths, storage sites, conditions, and image evidence. The resolution is an auditable row for each reel or continuous piece. It preserves the detail a buyer needs without pretending that all material in one yard or list is the same product.
- Use the same reference on the inventory row, each image, and related file.
- Give every reel or continuous piece its own line.
- Treat the grand total as a summary, not the evidence record.
Preserve specification differences within the lot
For each line record manufacturer, part number, designation, conductor metal, size or conductor count, marked rating, and continuous length. Group only truly matching material, and still keep the count and length of each reel visible. If a marking is unreadable, describe the visible text and mark the missing field unknown rather than applying a clearer reel’s specification to it.
The quantity needs its own basis: measured, documented, or estimated. A 500-foot documented reel and a 90-foot estimated remainder should remain separate even if their general product labels match. This lets the lot be reviewed as it exists rather than as an optimistic aggregate.
- Record specification fields exactly where visible.
- State measured, documented, or estimated beside each quantity.
- Do not use one representative reel as evidence for unlike items.
Separate sites, conditions, and release contacts
A warehouse, yard, or project location can have different access, condition, and release requirements. Put the storage site, condition category, any known history, and release contact on the matching line. Keep uninstalled stock, previously used material, and mixed recovery-only pieces distinct even when they appear in the same general lot.
Include known dimensions, gross or net weight basis, available loading resources, and access restrictions as seller-record facts. If a handling field is unknown, say so. These details help define the lot for discussion and do not make a commitment about transport or a handling plan.
- Use a separate site field instead of a combined location total.
- Keep condition categories with their individual references.
- State dimensions, weight basis, and access limits only as known facts.
Denver corridor context is not a lot source
Denver DOTI describes the Buchtel Boulevard and Evans intersection work as a two-mile corridor scope with protected bike lanes, sidewalks, crossings and reconstruction of five intersections.
This city fact does not identify public-project stock, a seller, or a buyer relationship. It is relevant only to the documentation lesson: a multi-location or project-related seller should make their own reel, site, and release records auditable instead of using corridor scope as proof of what material is available.
- Project scope does not replace a line-item inventory.
- Tie site and release details to the actual inventory reference.
Worked multi-site bulk record
Illustrative inventory example—not a purchased lot: BL-DEN-06A and BL-DEN-06B are recorded as matching product only after their own designations are documented. Site A has one reel at 500 feet documented; Site B has one reel at 90 feet estimated. The example is fictional and keeps site, quantity basis, and condition as separate fields.
A final pre-inquiry review should confirm that each image filename, document reference, specification, quantity, storage site, condition, and release contact points back to the same ID. If one site lacks records or access details, retain that gap with the relevant line rather than allowing the better-documented site to stand in for it.
- Example references: BL-DEN-06A and BL-DEN-06B.
- Fictional quantities: 500 ft documented and 90 ft estimated.
- Site and condition remain separate even for matching product.
