Give every reel a stable line reference
Use the same reference in the inventory, photo filenames, and any record you attach. Capture manufacturer, part number, complete designation, conductor metal, AWG or kcmil size, conductor count, marked voltage, and current length per reel. Group products only when the product identity and the quantity basis are genuinely the same.
A bulk worksheet is not a reason to hide an unknown line. Give an unlabeled reel its own reference, show the available images, and mark missing fields unknown. That lets the rest of the lot remain organized without assigning the unidentified piece a borrowed specification.
Keep sites, lengths, and weight bases separate
List warehouse, yard, campus, or project storage sites separately, even when a product number repeats. For each reel, state whether footage is measured, documented, or estimated, and whether a reported weight is gross loaded-reel, cable-only, net, or unknown. A loaded wooden reel is not a conductor-weight figure.
Boulder’s Comprehensive Plan says industrial areas support manufacturing, processing, services, warehousing and distribution, and facilities areas include utility operations and research campuses. That city context supports a practical site grouping for a seller’s list; it does not indicate that a particular location contains inventory or that the buyer has activity there.
Make the image set audit the worksheet
For each material group, include a readable tag or jacket legend, a reel overview, and an image of relevant condition differences. The filenames should contain the same line reference used in the worksheet. If two reels share an exact product but have different footage, condition, or site, retain distinct rows rather than letting one favorable image stand for both.
Add known reel dimensions, access restrictions, available loading resources, and requested timetable by site. These facts support a lot-specific logistics discussion and prevent an inventory table from being mistaken for a transport arrangement. Unknown dimensions or handling facts should be labeled rather than assumed.
Repair the grand-total inventory mistake
The core mistake is one aggregate footage or weight that conceals different products, lengths, sites, or conditions. The workable correction is one row per reel or continuous piece, with roll-up totals calculated only after the individual lines are clear. This makes it possible to discuss a mixed commercial lot without claiming that every reel has the same specification or handling requirements.
Illustrative inventory example—not a purchased lot: BL-BD-21, matching cable designation documented, 500 ft at Site A and 90 ft at Site B on separate references; gross loaded-reel weight reported; conductor weight unknown. The record is intentionally split because site and quantity basis are separate facts.
- Keep gross, cable-only, net, and unknown weights distinct
- Retain a site field for every reel or piece
- Use per-reel footage before calculating any total
