Build one traceable line for each reel
Assign a stable line or reel ID to every continuous reel or cable piece. Use that same ID in the spreadsheet, photo filenames and document names. Record manufacturer, part number, condition, reel count and continuous footage per reel. A grand total can be added as a convenience, but it cannot replace the individual rows that explain what the total contains.
Matching products may be grouped only where their identification, condition, length basis and storage site are truly the same. If one reel is estimated or has a different condition, give it its own line. This protects the evidence trail when another person reviews the lot.
- Use the same line ID in inventory, photos and documents.
- Keep per-reel footage and quantity basis visible.
- Separate reels when condition, length or site differs.
Map locations without merging the inventories
Create a site group for each actual warehouse, yard or project storage point. Under that group, list the reels physically present there and the access restrictions, known reel dimensions, weight basis and loading information. Do not assume that a contact at one site can authorize a release from another.
Murfreesboro is the county seat of Rutherford County, about 35 miles southeast of Nashville, and is included in the Nashville Metropolitan Statistical Area. That is limited location context for asking where a reel is stored and what access exists; it does not imply a local buyer facility, a route or a transaction.
- Group rows by actual storage location.
- Record site-specific access limits and loading equipment when known.
- Keep reel dimensions and weight basis with the site record.
Define the offered scope and release contact
Name the authorized seller or release contact for each site or offered group, and describe the lot scope in the same record. If approval is pending, say so. A named contact is not an assurance that a material transfer has been approved; it is the information needed to ask the right release question for the correct reel.
Include a requested timetable if the seller has one, but keep it separate from the inventory description. Site restrictions, offered groups and authority can change independently of the cable specification, so they should not be hidden in a grand-total note.
- Record release authority and lot scope per site or group.
- State site restrictions and requested timetable plainly.
- Keep pending approval out of the available scope.
Treat unknowns as a routing list
If exact weights, dimensions, loading equipment or access details are not available, mark each field unknown and identify the reel or site affected. Do not fill gaps with a typical value. An explicit unknown lets a seller prioritize which records or photos would make the multi-site handoff clearer.
Illustrative inventory example—not a purchased lot: BL-MB-01 is one matching reel with 500 ft documented at Site A; BL-MB-02 is a separate reel with 90 ft estimated at Site B. Loading equipment and restrictions are unknown until the seller confirms them. The two entries remain separate even when the product is the same.
- Mark unknown site fields by reel or location.
- Keep estimated footage distinct from documented footage.
- Do not convert a combined total into one continuous length.
