Create a stable reference for every reel
Assign one short inventory reference to each reel, continuous piece, or genuinely identical set and repeat it in the spreadsheet, image filenames, and correspondence. Beside that reference, record manufacturer, part number, readable marking, and current condition remarks. A reference is useful only if the same code lets another person find the physical reel and its supporting photo.
Do not use a single warehouse image as evidence for dozens of reels with different markings or conditions. The likely mistake in a bulk lot is substituting one representative reel for a complete record. The practical correction is a row and matching photo set for every distinct item.
- Inventory reference
- Manufacturer and part number when available
- Photo filename with the same reference
- Visible-condition remark
Retain per-reel footage rather than one grand total
For every reference, state the number of reels, the continuous length on that reel or piece, and the basis for the figure: documented, measured, estimated, or unknown. Identical products can be grouped for specification purposes, but different remaining lengths should stay visible. Two short lengths are not the same inventory record as one continuous length with the same aggregate footage.
If a tag reflects original footage rather than a current balance, note that difference. When the seller lacks a reliable length, label it unknown or estimated and retain the reel reference for follow-up rather than inventing precision.
- Reel count
- Continuous footage per reel
- Documented, measured, estimated, or unknown basis
- Original versus current quantity note
Separate site groups and release contacts
Keep yards, warehouses, and project locations in separate site groups even if an identical product appears at each. Record the actual storage location or a clear seller-supplied location description, access restrictions, and the contact able to discuss release. State whether the site groups are intended to be considered together or as distinct offered groups.
This is traceability, not a transport commitment. Site information lets the parties discuss practical scope for the actual lot without assuming a collection method, timing, or that every site will be included.
- Site group
- Storage location description
- Access restrictions
- Release contact
- Offered together or separately
Add handling facts as facts, not promises
For large reels, include documented diameter and flange width, the stated weight basis—gross, net, estimated, or unknown—and the loading resources actually available at the location. Add any gate, equipment, or access limits that the seller already knows. Do not convert those entries into a promise about freight, pickup, or a schedule.
Where a dimension or weight is unavailable, say so. A candid unknown tied to a reel reference is more usable than transferring another reel’s dimensions or presenting gross loaded-reel weight as cable weight.
- Reel diameter and flange width
- Gross, net, estimated, or unknown weight basis
- Available loading resource
- Site restriction
Use local context without turning it into inventory evidence
The South Dakota Governor's Office of Economic Development reports that a new 700-acre Black Hills industrial park is open and that Rapid City continues to review and develop sites as industry grows. That is limited context for organizing a potentially project-scale inventory; it does not identify a cable lot, confirm access to a site, or indicate any transaction.
Illustrative inventory example—not a purchased lot: BL-RC-01 is a fictional Site A reel with 500 ft documented, while BL-RC-02 is a fictional Site B reel of the same product with 90 ft estimated. Both retain their own photo references; the loaded-reel weight basis is unknown. The example shows why a site group and per-reel register are necessary.
- One row and photo reference per reel
- Site group retained even for matching products
- Unknown handling fields stated explicitly
