Give every physical reel a stable identity
Assign one inventory reference to each reel or to a genuinely identical group that is stored together. Use that same reference in the spreadsheet, reel photograph filename, product record, and site field. Include manufacturer, part number, specification, reel count, and the current length for the physical item—not merely what an old export says was purchased.
A multi-site decision becomes workable when a reviewer can begin at any row and trace it to one reel and one location. If the same part number appears at two sites, use separate lines with separate references or a clear location suffix. Do not use a single warehouse photo as evidence for all of them.
- Inventory reference and matching photo filename
- Manufacturer, part number, and specification
- Reel count, current length, and storage-site field
Reconcile current footage before making a total
Compare the inventory export, purchase record, or prior count with what is physically present. Record length per reel and label it measured, documented, or estimated. Keep reserved, missing, or pending-release reels visible as separate flagged lines rather than rolling them into the offered total.
The common mistake is presenting original footage and one combined total as current multi-site stock. Correct it by retaining the original figure as background, entering the current per-reel balance, and explaining any variance. An unknown or estimated length is useful information when it is identified as such.
- Current versus original quantity
- Length per reel with measured, documented, or estimated basis
- Release status for reserved or pending lines
Keep weight basis with the reel it describes
For each line, label the weight as gross loaded-reel, cable-only, net conductor, or unknown, and retain the scale or document source when one exists. A total that includes wood, steel, packaging, and cable should not be described as conductor weight. Dimensions can sit beside the weight record when they are known.
If a site has only an aggregate loading record, do not divide it among reels as though each result were measured. Leave the per-reel weight basis unknown and say what record is available. This prevents a grand total from creating false precision in a purchasing discussion.
- Weight value and stated basis
- Scale or document source when available
- Reel or packaging inclusion and dimensions
Separate sites, access limits, and release authority
Avondale site-selection materials state that the city is situated at Interstate 10 and Loop 101, with direct access to Sky Harbor Airport, Union Pacific Railroad and major freight corridors; they also describe shovel-ready sites with utilities and fiber connectivity.
That transportation-and-site context does not establish a particular cable lot, route, or transport arrangement. Its limited relevance is practical: a seller with reels at more than one actual storage site should state each site’s access restrictions, loading equipment, release authority, and requested timetable instead of treating the locations as interchangeable.
- Actual storage site for each reference
- Seller-reported access limits and loading equipment
- Site authority and requested release timetable
Illustrative two-site reconciliation
Illustrative inventory example—not a purchased lot: BL-AZ-01 is listed as the same part number with 500 ft documented at Site A; BL-AZ-02 is listed separately with 90 ft estimated at Site B. Both lines carry matching photo filenames, while the gross loaded-reel weight is unknown and Site B authorization is pending.
The example is intentionally not collapsed into 590 ft or a guessed weight. An actual submission can follow that pattern by keeping each reference, quantity basis, site, and release state visible until the seller has better evidence.
- BL-AZ-01: 500 ft documented at Site A
- BL-AZ-02: 90 ft estimated at Site B
- Gross loaded-reel weight unknown; Site B authorization pending
