Map sites before combining the inventory
A regional cable list can conceal different products, lengths, owners and loading constraints when all locations are rolled into one number. Make each storage site a separate sub-lot, then assign a line or reel reference within that site. The same product at two locations is still two records when release authority, access or condition differs.
Washington County states that Fayetteville is part of the Fayetteville-Springdale-Rogers Metropolitan Statistical Area and identifies Walmart Stores, Tyson Foods and JB Hunt Transport Services as regional employers. This supports a regional organizing frame only; the named employers are not represented as customers, inventory owners or participants in any cable transaction.
- Name the physical storage site for each line before calculating a total.
- Give one stable reference to each reel or genuinely matching group.
- Keep different owners or release authorities in separate site records.
Use a stable line reference across evidence
Create a reference such as NW-01 for each reel or defined group and repeat it in the inventory, photo filenames and existing documents. Record manufacturer and part number when present, full designation, reel count and continuous footage per reel. A photo set becomes useful only when it can be matched to the same line that carries the quantity and site information.
Where a tag is missing, use the reference to preserve the uncertainty rather than inventing a product identity. Photograph the available evidence, write specification details pending, and keep that line apart from documented material. Do not use one well-labeled reel as proof that every similar-looking reel at another site is identical.
- Use the same reference in the spreadsheet, photo filenames and documents.
- Record designation, reel count, per-reel footage and quantity basis.
- Label an unidentified line as specification details pending.
Preserve quantity and condition differences
List measured, documented and estimated footage distinctly for each reel. Do not transform several short pieces into a single continuous length or let a grand total hide partial reels. If a weight is available, identify whether it is gross loaded-reel, cable-only or estimated; it is not a substitute for footage or cable identity.
Add condition notes and photo references at the line level. A reel stored indoors may have a different history from a similar reel outdoors, and a damaged flange at one site does not describe the other site. The purpose is a legible lot map, not a claim that every line is in the same condition.
- State a quantity basis for every footage figure.
- Keep continuous pieces and short cut pieces on separate lines.
- Identify gross, net or estimated weight whenever weight is included.
Build a site-by-site release matrix
For each site, record ownership, the individual or role able to authorize release, which line references are included, available loading resources, access limits and the seller’s requested timetable. A combined inquiry can still carry several separate release statuses. Do not assume a contact at Site A can authorize material at Site B.
If one site has pending approval or no confirmed loading information, leave that status with its associated lines. The inventory can show both documented and unresolved sub-lots without presenting the whole regional offering as immediately available. This is more actionable than a single regional total with no location or authority attached.
- Map each line reference to one storage site.
- List ownership and release authority separately for each site.
- Mark requested timing, access limits and loading resources as site-specific facts.
Correct the grand-total mistake with two lines
The common mistake is a Northwest Arkansas footage or weight total that masks short pieces, nonmatching specifications and different sites. Correct it with one row per reel or continuous piece, plus a site label and a clear quantity basis. Unknown identity or release fields should remain visible instead of being carried into the total as though they were confirmed.
Illustrative inventory example—not a purchased lot: NW-01 is one reel with a matching product record, 500 ft documented at Site A and release authority unknown. NW-02 is a claimed matching product with 90 ft estimated at Site B and its specification details pending. The two lines belong in one inquiry only after their site, product and authority facts remain distinct.
- Do not use a region-wide total as the only quantity field.
- Keep a pending release line outside any confirmed sub-lot count.
- Use the same reference in every related photo and document.
