Give every reel and site a stable reference
Build the list one physical reel or continuous piece at a time. Give it a line or reel ID, then add a site ID, photo filenames, and document references. Use the same ID on the spreadsheet, image files, and any supporting record. A large total without these links cannot show which photograph or document applies to which item.
If several reels are genuinely identical, retain their individual IDs beneath the shared specification group. The group helps sort the list, but it does not replace the evidence trail for each reel.
- Use one line or reel ID per physical item.
- Include a site ID in every row.
- Use the same reference in photo filenames and document names.
Keep quantities at the reel level
Record specification, reel count, length per reel, quantity basis, and condition on each line. State whether footage is measured, documented, estimated, or unknown. A total of 590 feet can mean one continuous reel, two different reels, or many pieces; those are not interchangeable descriptions for a purchasing review.
Do not let a clean photo of one reel stand in for the whole group. When a quantity is estimated, retain the estimate beside the affected reel and state why the underlying record is incomplete.
- List length per reel instead of only aggregate footage.
- State measured, documented, estimated, or unknown for each quantity.
- Keep different condition states as separate rows.
Separate storage groups and release contacts
Group the lines by their actual storage site and identify ownership, release authority, and site restrictions for that group. Multiple sites can appear in one inquiry, but one aggregate total should not hide different access rules or pending release contacts. If authority is unresolved, mark the field unknown and identify the record or contact needed to resolve it.
This workflow is distinct from cable classification: the primary decision here is whether a reviewer can connect every reel to its site, evidence, and handling facts. Product differences should still remain visible in their own specification fields.
- Do not merge different sites into one inventory line.
- Identify release authority for each site group.
- List site restrictions beside the affected reels.
Describe handling constraints without assuming a method
The City of Federal Way describes the city as between Seattle and Tacoma, with direct access to Interstate 5, proximity to Seattle-Tacoma International Airport and the Ports of Seattle and Tacoma, and access to State Route 18 and regional transit. That city context makes the seller’s actual storage and access record relevant, but it is not a transport commitment or a statement about a particular lot.
For every large reel, supply dimensions, gross, net, or unknown weight basis, access limitations, available loading equipment, and the seller’s timetable. If any field is unknown, say what is unknown rather than estimating a capability or a movement plan.
- State diameter, width, and core dimensions when known.
- Label weight as gross, net, estimated, or unknown.
- Describe access limits and available loading resources.
Worked format for a two-site inventory
Illustrative only — not a purchased lot: FW-BL-01 and FW-BL-02 have a matching product designation recorded. Site A has one reel with 500 feet documented; Site B has one reel with 90 feet estimated. Dimensions are known and loading equipment is to be confirmed. The two site records should remain separate even if they are discussed in one inquiry.
The mistake to avoid is presenting one grand footage figure with one good photograph. The fix is one row per reel or piece, matched evidence, a site group, and a plain statement of any unresolved handling detail.
- Site A: 500 ft documented.
- Site B: 90 ft estimated.
- Handling: loading equipment to be confirmed.
