Give each reel or piece a traceable line ID
The city lists seven industrial park areas: Tonquish Subdivisions 1 and 2, Westland Commerce Park, Westland Commerce Park South, Ford-Hix Industrial Park, Railway Industrial Park and Cherry Hill Industrial Park. That source can help a seller describe an actual storage-area context, but it does not establish that any cable is available in a listed area. For a genuine closeout, create a line ID for each reel or continuous piece and reuse it in the spreadsheet, photo filenames, and documents.
A multi-site list is manageable when the reference stays stable. Do not use a single generic lot label for inventory with different reels, conditions, or access paths.
- Line or reel ID
- Photo filenames matching the line ID
- Document reference and storage group
Keep product and quantity fields at line level
For each line, record manufacturer, part number, designation, stated metal, size, conductor count, marked rating, reel count, and per-reel length. Group only truly identical material, and retain the per-reel quantity rather than converting several short pieces into one long continuous length.
Use measured, documented, or estimated as the quantity basis. When a length is an estimate, keep the estimate with the individual line instead of allowing it to disappear inside an aggregate total.
- Manufacturer and part number
- Designation, metal, size, count, and rating
- Reel count and per-reel length
Split condition groups before adding totals
Separate uninstalled stock, removed cable, and recovery-only pieces into distinct groups. Within each group, note service history, visible damage, and the quantity basis. A grand total that combines those conditions obscures the information a seller has available.
If history or identification is unknown, make a separate row with that uncertainty. A closeout can still be reviewed line by line without forcing every item into a favorable or uniform description.
- Condition group
- Service history
- Visible damage
- Unknown fields identified on their own line
Map each site and its release path
For every storage group, record actual site or storage area, owner, release authority, loading resources, access limits, and any seller-requested timetable. These details support a practical conversation about the inventory but do not promise a collection method, schedule, or transport term.
Where owner approval is pending, state that in the line or site group. A reel with complete markings but incomplete release authority should not be counted as fully cleared inventory.
- Site or storage area
- Owner and release authority
- Loading resources and access limits
Correct a grand-total record with a fictional example
Illustrative example—not a purchased lot: fictional line BL-01 is one reel with 500 documented feet at Site A; fictional line BL-02 is a separate reel of the same product with 90 estimated feet at Site B. The condition group and release status stay attached to each line, not only to a total row.
The central mistake is a single grand-total footage figure that hides different lengths, conditions, and storage sites. Correct it by creating one row per reel or piece, preserving the site and specification group, and matching each row to photos and its quantity basis.
