Assign traceable line IDs before totaling
Give each reel or truly identical group a line ID that appears in the inventory, photo filenames and supporting files. The line should carry manufacturer, designation, conductor metal, size, rating, reel count and continuous footage per reel. A total may be shown after the reel-level facts remain visible, not instead of them.
If an item is only partly identified, keep it in an unknown line with its own photographs. Do not use one clearly marked reel as proof that every nearby reel shares the same construction.
- Stable line ID and reel ID.
- Manufacturer, designation, metal, size and marked rating.
- Reel count plus continuous footage per reel.
- Photo and document filename tied to the same line.
Split site, condition and release authority
A mixed lot may be stored at more than one yard, warehouse or project location. Record the storage site for every line and keep unused stock, cable formerly in service and recovery-only pieces distinct. The condition and service-history field should travel with the individual reel rather than the grand total.
Identify the release authority for each site. A single spreadsheet can cover more than one location when that distinction is retained; it should not imply that every site uses the same access rules or release contact.
- Storage site for every reel.
- Condition and history kept per line.
- Separate unused stock, former-service cable and recovery-only pieces.
- Release authority associated with the relevant site.
Describe handling facts without assuming movement
For larger reels, record available dimensions, whether weight is gross, net or unknown, access limits and any seller-provided loading resources. Put a seller timetable in the record if one exists. These operational facts help describe the lot and prevent a heavy reel at one site from being hidden inside a general total.
If a weight includes a reel, packaging or hub, label it as gross loaded-reel weight. Do not convert it to conductor content. If exact footage is unavailable, flag the estimate and state the basis used.
- Dimensions and documented or estimated weight basis.
- Access limitations and available loading resources.
- Seller timetable, if known, recorded as seller information.
- Estimated footage identified separately from measured footage.
Bowling Green context, used narrowly
BGMU reports approximately 32,000 electric customers and 360 miles of electric distribution lines, including 68 miles underground and 292 miles overhead. This is local utility-system context for keeping infrastructure-related reels traceable. It does not indicate that BGMU inventory is available, that BGMU is a seller, or that Industrial Wire Buyer has handled its material.
Worked fictional bulk-lot record
Illustrative inventory example—not an actual or purchased lot: BL-BG-01 is a matching product with 500 documented feet at Site A. BL-BG-02 is listed separately as the same product with 90 estimated feet at Site B. The record labels the reported weight as gross loaded-reel weight and leaves conductor weight unknown.
The two lines can be sent in one inquiry, but their different locations and quantity bases remain visible. Add the release contact, photos and handling details for each line before a lot discussion; do not rely on the combined 590-foot figure alone.
- BL-BG-01: 500 documented feet at Site A.
- BL-BG-02: 90 estimated feet at Site B.
- Weight basis: gross loaded-reel; conductor weight unknown.
- Photos, release contact and access details stay with each line.
