Give every piece a handoff key
Create one stable line or reel ID and use it in the inventory sheet, image filenames, document notes, and site group. A handoff key lets a second reviewer confirm which image and which storage location belong to a specific reel. Include the readable manufacturer or part number when available, but do not use that information to merge physically different pieces automatically.
For mixed inventory, a line key is more useful than a polished summary. It provides a place to record the cable designation, condition note, site group, and any documentation reference without confusing one reel with a similar item across town.
- Line or reel ID
- Photo filename
- Readable manufacturer or part number
- Cable designation or unknown status
- Site group
Keep quantity basis beside each reel
Report footage per reel or continuous piece and identify whether the figure is measured, documented, or estimated. Add reel count, dimensions, and any gross, net, or unknown weight basis at the same line level. A grand total can be kept for internal planning, but it should not replace the rows that reveal how much is actually continuous and where it sits.
Do not create a single implied length by adding separate cut pieces or partial reels. When an estimate is the best available value, label it clearly and preserve the reason for the estimate. This prevents a representative reel from silently becoming evidence for a larger mixed total.
- Continuous footage per reel or piece
- Measured, documented, or estimated basis
- Reel count
- Dimensions
- Gross, net, or unknown weight basis
Treat each storage location as an inventory boundary
Use a separate site group for every warehouse, yard, or project location. State the address or ZIP through the inquiry process, access restrictions, available loading information, and site-specific condition differences. Keep the material at one site distinct even when it shares a part number with material at another site.
This avoids the most common multi-site mistake: a single total and one representative photo are used for reels that have different access, condition, and release circumstances. The site field should remain with the item row, not only in a cover note.
- Storage site or ZIP
- Access restriction
- Available loading information
- Site-specific condition note
- Photo and line references
Make release scope visible before grouping the lot
State whether the inventory is proposed as one group or defined groups, then identify the owner or role able to authorize release for each site. A seller may also record a requested release window, but that request does not establish transport, price, inspection, payment, or collection terms. Those remain lot-specific discussions after the records are reviewed.
If authority differs by site, do not combine the reels into one release-ready total. Mark the relevant rows pending authority and state what confirmation remains. This retains a workable handoff even when one portion of a large lot is ready and another is not.
- Lot grouping
- Ownership or release-authority status
- Requested release window if known
- Transport discussion status
- Pending confirmation note
Use local route context without assuming movement
The City of Greeley highlights a strategic location near major transportation routes and Denver and says the city supports business expansion. For a multi-site record, that is limited context for explaining why precise access and site grouping matter; it does not promise trucking, pickup, freight terms, or any outcome for a specific lot.
The practical action remains local to the record: connect each reel to its own quantity basis, photo set, site group, access note, and release authority so a reviewer can understand the lot without guessing.
