Make the inventory line the center of the bulk lot
Give each reel or continuous piece a stable line and reel ID. Record manufacturer, part number, cable designation, conductor material, size, storage location, and condition on that line. Group only genuinely matching products, and keep the underlying reel references so a reviewer can still identify the items within a group.
A grand-total footage number cannot show whether the total is one long reel, several partial reels, or a mixture of specifications. Record reel count and continuous footage per reel, along with a measured, documented, or estimated quantity basis. This makes the bulk list useful before anyone discusses movement of the material.
- Use stable line ID and reel ID in the spreadsheet, photo filenames, and release notes.
- Record manufacturer, part number, material designation, and storage location for every line.
- Show reel count, footage per reel, full or partial status, and quantity basis.
Keep multiple sites and conditions distinct
A bulk lot may be one inquiry while still containing items at different yards, warehouses, or project areas. Keep those locations on separate lines, even when the part number matches. Record whether material is uninstalled, removed, or recovery-only and note storage history and visible condition for the actual site where that reel is held.
The City of Citrus Heights says it is in the heart of the Sacramento region and has over 5.3 million square feet of commercial space. That local commercial context helps explain why an inventory might be organized across more than one commercial storage area, but it does not identify a facility, a cable lot, or a customer.
- Do not combine Site A and Site B items into one row solely because their part number matches.
- Keep condition, storage history, and release group with the physical location.
- Separate uninstalled, removed, and recovery-only lines in the inventory.
Connect photos and documents to the correct reel
Use the same stable reference in the inventory sheet, image filenames, and any supporting document. For each line, capture a readable tag or jacket legend, an overall reel view, and relevant visible condition. One attractive reel image is not proof for all material in a mixed bulk lot; preserve differences with line-matched photographs.
Where an identifier is missing, assign a temporary reference and label it temporary. State what is unknown, such as footage or release authority, and identify the record or site contact that may resolve it. That approach lets a reviewer focus on the unresolved lines without obscuring the documented portion of the lot.
- Match photo reference, reel ID, and spreadsheet line exactly.
- List document ID and its matching basis when a record supports a particular item.
- Mark temporary identifiers and unknown fields rather than inventing a match.
Record release and loading facts by site
For each storage location, identify the authority able to release the listed items, dimensions, weight basis, loading equipment known to be available, and access restrictions. A forklift noted at one site should not be assumed to be available at another. Treat these as planning details that help describe the lot rather than as a promise about a move.
If access windows, gate limits, escorts, or documentation requirements are not known, record them as unknown or pending with the site contact. Separating these practical facts by site prevents a single general note from making a multi-location lot appear simpler than it is.
- Record release authority, dimensions, gross, net, or estimated weight basis, and loading equipment per site.
- List gates, hours, escort needs, and other access restrictions with the affected location.
- Keep planning details separate from any lot-specific transport agreement.
Replace the one-photo grand-total error
The error to avoid is advertising a mixed, multi-site lot with one grand-total footage figure and one warehouse photograph. That record cannot show what is at each location, which condition applies, or who can release a particular reel. Correct it with one row per reel or continuous piece and photo-matched stable IDs, preserving location and release differences.
Illustrative fictional inventory record—not a purchased lot: BL-CH-01; line 1 is one matching reel with 500 ft documented at Site A; line 2 is the same product with 90 ft estimated at Site B; release authority and loading equipment are recorded separately by site. The example shows why equal product identity does not erase a location difference.
- Mistake: one grand total and one photo stand in for a mixed multi-site lot.
- Resolution: retain per-reel lines, site-level release records, and photo-matched IDs.
- State estimated footage and unknown access details without turning them into fixed terms.
