Give every physical reel a stable identity
Create a line ID for each reel or for a genuinely identical group kept at the same site under the same release contact. Use that ID in the spreadsheet, file names, tag photos, and any existing records. A consistent reference lets a reviewer distinguish two reels that share a part number but differ in length, condition, or location.
Do not make a location name do the work of a reel ID. A warehouse row, a yard label, or a broad project reference can cover several products. Where the tag is missing, retain the line ID, photograph the visible cable and reel, and mark manufacturer or part number unknown.
Keep quantity on the reel line
For every line, show reel count, continuous length per reel, and the basis of that quantity: measured, documented, or estimated. If a lot contains three partial reels, record three entries or a clearly explained grouped entry; do not convert them into one continuous run. If weight is available, say whether it is gross loaded-reel, net cable, or unknown.
The predictable inventory mistake is reporting one aggregate footage total with one representative photograph. Correct it by keeping each physical balance visible. A single total can remain as a summary, but it cannot replace reel-by-reel quantities and condition notes.
- Line or reel ID
- Reel count and continuous footage per reel
- Measured, documented, or estimated quantity basis
- Gross, net, or unknown weight basis
Map sites and photo references
Group the record by actual storage site and add a site field to every reel line. For each site, identify access limits, gate requirements, available loading information, and the person who can discuss release. Photo filenames should include the line ID so a tag close-up, reel overview, and visible condition image can be checked against the same item.
When a detail is incomplete, preserve the uncertainty in the row. For example, a line can say “release contact: pending” or “weight: gross basis unknown.” Leaving the column blank encourages a reviewer to treat different reels as interchangeable when they are not.
Use local access context without treating it as logistics
The Port says it is 106 river miles from the Pacific Ocean, with I-5 two miles away, I-84 ten miles away, and direct BNSF and Union Pacific rail service. That location fact is relevant only to asking a Vancouver seller for accurate site and access information on a large lot; it is not a transport, route, or collection commitment.
Describe the material’s actual dimensions, gate limits, and on-site equipment only when known. Keep those site facts separate from the product record and from the commercial discussion. The record should make it possible to ask focused follow-up questions for a particular reel and site rather than treating the whole lot as a single pile.
