Assign one reference before building the spreadsheet
Give every reel, continuous piece, or genuinely identical group a stable line or reel ID. Use that same ID in the inventory sheet, the tag photograph, the jacket-print photograph, and the overview image. Record manufacturer, part number, complete designation, conductor information, and condition on the line where the material is actually stored.
A large figure at the top of a spreadsheet can be useful as a summary, but it is not the evidence record. A reviewer should be able to start at one line and find the exact photos and product facts for that portion of the proposed lot.
- Line or reel ID repeated in spreadsheet and filenames
- Manufacturer, part number, and complete designation per line
- Tag, jacket-print, overview, and condition images matched to that line
Preserve per-reel quantity and condition
Record reel count, per-reel footage, and whether each quantity is measured, documented, or estimated. Do not add separate continuous lengths together and describe the result as one long piece. If matching reels have different footage or condition, each should receive its own row even when the product designation is the same.
Group only reels that are genuinely identical in product, per-reel quantity, and condition. Keep a separate field for cut or continuous status so a smaller piece is not hidden inside a total that appears more uniform than the underlying inventory.
- Per-reel footage and quantity basis
- Reel count only for genuinely identical lines
- Condition and continuous-length status kept at reel level
Keep sites and release contacts separate
For every line, record the storage site, owner, release authority, site restriction, and whether the item is included in the full lot or a defined group. One seller may present several locations in one inquiry, but the individual site facts should remain visible. If approval is unknown at one site, flag that line rather than transferring another location’s release status to it.
A staging area, warehouse, or campus building name is not enough by itself. Pair it with the line ID and evidence files so a location reference does not replace product, quantity, and authorization details.
- Storage site, owner, and release authority per line
- Site restriction and defined lot grouping
- Approval gap clearly marked as unknown or pending
Describe handling facts without assuming movement
For large reels, add dimensions, documented gross or net weight, or an explicit unknown weight basis. State the loading equipment that is available at the site and any access limits that the seller knows. A preferred timetable belongs in the seller’s notes, not as a conclusion about a future collection arrangement.
These facts help make a bulk package understandable while keeping it focused on the actual inventory. They do not turn the listing into a promise that a particular mixed lot will be purchased or moved.
- Reel dimensions and gross, net, or unknown weight basis
- Available loading equipment as a site fact
- Access limits and seller timetable kept with the applicable site
Use local project references carefully
Champaign County First identifies local infrastructure priorities including Windsor Road, Olympian Drive, North Lincoln Avenue, the I-57/I-74 interchange, the I-57 Windsor Road Bridge, Kickapoo Rail Trail and the Mahomet Aquifer. A seller may use an actual project reference to explain why storage records are separated, but the named priorities do not prove that a cable lot exists or belongs in this inquiry.
This fictional worksheet example shows the needed detail: CH-BL-01, matching product, 500 ft documented, Site A; CH-BL-02, same product, 90 ft estimated, Site B; CH-BL-03, a different conductor metal, two reels, Site B; separate release contacts, approval status unknown. It is an illustrative inventory example, not a purchased lot.
- CH-BL-01: 500 ft documented at Site A
- CH-BL-02: 90 ft estimated at Site B
- CH-BL-03: different conductor metal and separate release status
