Build one traceable row for each reel or matching group
Give every reel, or only a truly matching group, a stable line reference. Use that same ID in the inventory, photo filenames, readable label image, and document file. Add manufacturer or part number, specification, storage site, and condition to the row so a reviewer can trace the material without relying on a grand total.
Do not group reels solely because they appear similar. Different markings, remaining lengths, damage, or locations require separate lines. The task is not to make the spreadsheet short; it is to make each offered piece understandable.
- Line/reel ID and matching photo filename
- Manufacturer/part number and specification
- Storage site and visible condition
Retain per-reel quantities across every site
Record reel count, length per reel, continuous piece status, and quantity basis for each specification. State measured, documented, estimated, or unknown rather than blending values into a confidence-free total. Keep cut lengths separate from reels, even when their total footage appears convenient.
For multi-site stock, site grouping and specification grouping solve different problems. A buyer needs to see both: which product is on the line and where the physical reel is held. Reusing a reference ID makes photos and quantity notes usable across those groups.
- Reel count and length per reel
- Quantity basis and cut-length status
- Site grouping separate from specification grouping
Keep physical condition and location differences visible
Separate unused stock, previously used cable, and recovery-only material even when a product description matches. Record storage history, visible damage, access limits, and the item’s location with its reel reference. A clean photo from one site should not represent material stored elsewhere.
When an item has no readable tag, keep it in its own row with manufacturer or part number marked unknown. Attach the available overview and label photos, state the limitation, and do not let the unknown item inflate the specification of a labeled group.
- Unused, previously used, or recovery-only status
- Storage history and visible damage
- Access limits and explicit unknown label status
Match each site to its release and loading record
For every storage site, list the release contact or role, available loading resources, dimensions, weight basis, and known timetable. If two sites have different authorities, preserve that difference even when the cable markings match. These facts are planning records, not promises about movement or who will provide services.
The common mistake is a single grand-total footage figure that combines reels and sites until the photos and release contacts cannot be matched. Resolve it by keeping one row per reel or continuous piece and repeating the same identifier in all evidence.
- Release contact and site-specific authority
- Loading resources, dimensions, and gross/net/estimated weight
- Known timetable or explicit pending status
Use local context without assuming an inventory source
The City’s Buick City announcement describes a planned 275,000-square-foot industrial building within redevelopment expected to reach up to 3.5 million square feet and $300 million in capital investment. It is Flint redevelopment context only; it does not show that a multi-reel cable lot exists or is associated with that development.
Illustrative record only — not a purchased Flint lot: BL-FL-01 at Site A, one reel, 500 ft documented; BL-FL-02 at Site B, one reel, 90 ft estimated; matching product recorded; conditions retained by site; separate contacts; authority pending. The two entries are not turned into a single 590-ft, single-site line.
- Use one reference per reel or continuous piece
- Retain different sites and authorities in the inventory
- Email a line-item file and label photos to saleselectricalbuyers@gmail.com
