Give every reel a usable identity
Create a stable reel or line ID for every reel and every separate continuous piece. Repeat that ID in the spreadsheet, on photo filenames, in supporting documents, and beside the storage site. This prevents a broad warehouse photo or an aggregate total from standing in for items with different lengths or products.
For each row, capture manufacturer or part number, designation, conductor metal, size, rating, reel count, and per-reel continuous length. Group only truly matching product records; keep a matching part number on separate rows when length, condition, site, or documentation differs.
State quantity and weight bases without conversion
Label footage as measured, documented, or estimated. If weight is available, state whether it is gross loaded-reel, cable-only, net, or unknown. Reel dimensions belong beside that quantity information when they are known, because a large reel and a small coil should not be represented by the same handling assumption.
One grand-total footage number is the most common inventory mistake in a dispersed lot. Replace it with per-reel length and basis, then retain any unknown as an explicit field rather than allocating the total across reels without evidence.
Map sites without assuming movement
Use a site ID and a private storage address or ZIP for each inventory row. Record access restrictions, available loading equipment, and the release contact at that site. If a contact or access detail is not yet known, mark it unknown; that is better than assigning a different site’s information to the reel.
This is a multi-site traceability task, not a promise about pickup arrangements. The goal is to make the offered inventory understandable before any lot-specific handling discussion.
Illustrative multi-site record
Illustrative inventory example—not a purchased lot: BL-CAR-01, matching product, Site A, 500 ft documented; BL-CAR-02, same product, Site B, 90 ft estimated; gross loaded-reel weight unknown; release contact to be identified. The two lines stay separate because their location and footage basis differ.
For an actual worksheet, add the product marking, photo filename, dimensions, condition, document reference, access note, and release contact to each line. A label such as “unknown” is appropriate when a field cannot yet be verified.
Carmel access context
The City of Carmel says its transportation network includes more than 155 roundabouts.
This is local transportation context only, not a route plan or a statement that a particular site can be accessed. It is a reminder to record actual seller-reported site restrictions, dimensions, and loading resources for each stored reel. Submit the organized inventory with matching photos so a bulk buying review can distinguish one reel and site from another.
