Create a master row for every reel
Give every reel or continuous piece a stable line reference and use it in the spreadsheet, photo filenames, and supporting records. A product-group column can show matching make and model, but it should not replace the individual line where footage, condition, or storage location differs.
Start with manufacturer and part number, full designation, conductor metal and size, marked voltage, per-reel length, and quantity basis. This makes the list usable when an apparent duplicate has a different label or remaining amount.
- Stable line reference
- Photo filename matched to that reference
- Complete product marking
- Per-reel continuous length and basis
Keep totals subordinate to the evidence
A grand total may be useful as a summary, but it should be calculated from separate line entries. Mark each length as measured, documented, or estimated. Do not combine cut pieces into a claimed continuous run or use a loaded-reel weight as a substitute for a line-level quantity.
If a reel has no readable tag, leave the designation unknown and retain its own row. A clear unknown is preferable to copying a neighboring reel’s construction into the total.
Map condition and release by site
Group the rows by the actual warehouse, yard, or other storage site. For each group, state condition status, known storage exposure, visible damage, the release contact, access restrictions, and available loading resources. A clean reel in one location does not describe material held at another location.
Keep unused material, cable previously in service, and unidentified mixed pieces in separate groups. This produces a more truthful inventory than applying one condition sentence to an entire multi-site lot.
Use local context only to clarify site facts
Columbia Economic Development says Columbia has a central location with a network of four interstates and that the Port of Charleston is less than two hours away. For a Columbia seller, the fact is relevant to documenting the actual storage location and handling limits for each site, not to estimating demand, value, or a transport outcome for the lot.
Add reel dimensions and the stated basis for any known weight, then describe dock, forklift, crane, clearance, or gate limitations as facts. If a site contact or equipment detail is unknown, mark that row or site group unknown rather than merging it into the confirmed portion.
Repair the representative-photo problem
The common mistake is one total figure plus a single clean reel photograph for several sites. Correct it by attaching at least a reel overview and a marking image to the matching line reference, and by noting where that line is stored.
A fictional record can show the format: BL-COL-A1; 500 feet documented; Warehouse A; marked product recorded; release contact listed. A separate BL-COL-B1 row may show 90 feet estimated; Yard B; forklift availability unknown. These are not actual lots; they demonstrate why site facts cannot be pooled.
