Give every reel and photograph one shared reference
Assign a stable line or reel ID before assembling the spreadsheet. Use that reference in the inventory row, photo filenames, product records, and site notes. The row should identify manufacturer, part number, cable designation, storage site, and any photo that shows the tag, jacket printing, overall reel, or an exception condition.
A large lot becomes reviewable when the evidence points back to a particular reel or a genuinely identical documented group. One attractive photograph cannot stand in for an entire offer when other reels have different tags, lengths, or condition notes.
- Use the same line ID in the spreadsheet and every image filename.
- Record manufacturer and part number beside the reference.
- Add an exception photo when a reel differs from its group.
Retain per-reel quantity and condition differences
Report footage per reel and label each quantity as documented, measured, estimated, or unknown. Keep a full reel, a partial reel, and a short continuous piece distinguishable even if the product designation matches. Add a condition field and preserve unknowns instead of using a single grand-total footage number to summarize unlike items.
Grouping is appropriate only after the record shows genuine identity. If several reels share a product record but have different footage or storage exposure, retain those fields per reel. The reviewer then sees the actual composition of the offer without assuming uniformity.
- Keep footage basis beside the reel ID.
- Record condition and visible differences per reel or documented group.
- Do not convert an aggregate total into an asserted continuous length.
Map sites and release contacts separately
Group rows by actual warehouse, yard, or project location. For each site, identify the address or ZIP for the inquiry, site-specific line references, owner or seller entity, release authority, and any known release timetable. A multi-site offer should not use one generic release contact if the authority differs by location.
If an authority is not known, mark it unknown until confirmed and keep the relevant lines identifiable. That allows the material record to be prepared while the seller resolves ownership or release questions, without representing that every site is immediately available.
- Use one site field and one release contact field for each location.
- Keep site-specific inventory references together.
- Separate confirmed availability from approval-pending lines.
Describe access as a site fact, not a promise
For substantial reels, record dimensions, gross or net weight basis, access restrictions, surface conditions, overhead limits, and loading resources that are actually available on site. These facts support a practical lot discussion, but they do not mean that a particular truck, crane, forklift, or collection method has been agreed.
Augusta says it installs and maintains hundreds of miles of roads, water and sewer lines and manages traffic lights, control systems, stormwater/drainage, hydrants and traffic signs. This public-infrastructure description is relevant only as local context for careful multi-reel documentation. It does not indicate a public-project lot, city ownership, a logistics arrangement, or availability of cable.
- State weight basis and any estimate method.
- Note gate, clearance, surface, or scheduling limitations when known.
- Describe available on-site equipment without characterizing it as included service.
Illustrative line-to-site mapping record
Illustrative inventory example—not a purchased lot: BL-AUG-01 is a fictional Site A reel with 500 ft documented, while BL-AUG-02 is a fictional Site B reel of the same product with 90 ft estimated. Their tag and overview images carry different filenames, and Site B release authority is marked unknown until confirmed.
This example shows why a bulk offer needs both a line-level record and a site-level record. A seller can replace the fictional references with actual photos, product information, access facts, and release contacts without pretending that a single lot total explains every reel.
- Fictional lines: BL-AUG-01 and BL-AUG-02.
- Quantity basis differs: 500 ft documented and 90 ft estimated.
- Site B release authority: unknown until confirmed.
