Give every reel a stable inventory reference
Start with a short line or reel ID and reuse it in the spreadsheet, photograph filenames, product documents, and site notes. A reel may share a row only with physically co-located material that has the same documented specification, condition, release status, and quantity basis. “Similar” is not a sufficient grouping rule.
For each row, record manufacturer, part number, complete designation, conductor metal, size, rating, reel count, and continuous footage per reel. If a tag is unreadable or a dimension has not been captured, label that field unknown rather than replacing it with a lot average.
- Use the same reel ID in the spreadsheet and photo filenames.
- Preserve per-reel footage and quantity basis.
- Group only documented matching reels that share location and release status.
Keep actual storage sites visible
A broad lot may be spread across more than one warehouse, yard, or project area. Give each row a storage site or ZIP and make clear whether it is offered as one defined group or as separate sublots. Keep ownership and the release-authority role visible for each site rather than assuming one contact controls every reel.
South Gate’s official business page describes the city as centrally located, with downtown Los Angeles, Los Angeles International Airport, and the Ports of Los Angeles and Long Beach within a 20-mile radius, connected by major roads and rail. That regional statement is only a reason to make the actual site and access record precise; it does not promise a route, collection, or buyer location.
- Record actual storage site or ZIP for every inventory row.
- State whether the inventory is one offered group or defined sublots.
- Name the release-authority role for the site holding each reel.
Add handling facts without turning them into terms
For large reels, record dimensions, gross, net, or estimated weight basis, access restrictions, and loading equipment actually available at the site. A documented weight and a gross loaded-reel estimate are not interchangeable. Include the seller’s preferred timetable as a fact about availability, not as an assumed collection commitment.
The likely error is a grand total with one representative photograph and no way to see which reel requires which handling. The fix is a row-level record: match each image, dimension, weight basis, and access note to the same reel ID and storage site.
- State whether a weight is gross, net, estimated, or unknown.
- Record available loading equipment as a site fact.
- Keep access limits and requested timetable on the matching site row.
Resolve incomplete rows instead of averaging them away
If footage is estimated, note that on the exact reel row and explain the basis in a short note. If the reel is at another site, list the last confirmed site and the contact role that controls access. If photos show a damaged flange or an unreadable tag, attach them to the same reference rather than using a better reel as a stand-in.
The objective is not a perfect spreadsheet before inquiry. It is a reviewable one: known product facts, explicit unknowns, and a practical path to resolve the few details that matter for each identified reel.
- Mark estimated footage and unknown fields on the individual row.
- Retain photos of unreadable tags or visible condition differences.
- Do not calculate a lot average to hide a missing reel record.
Illustrative multi-reel record
This is an illustrative fictional example—not a purchased lot. It shows why two superficially matching reels still need separate rows when footage, site, or release contact differ.
Line BL-SG-01: matching product designation; 500 ft documented; Site A; dimensions pending. Line BL-SG-02: same product designation; 90 ft estimated; Site B; release contact differs. The two records can be discussed together, but their quantities and site facts remain visible.
- Line BL-SG-01: 500 ft documented; Site A.
- Line BL-SG-02: 90 ft estimated; Site B.
- Handling: dimensions pending.
- Release: contact differs by site.
