Create a map from each inventory line to each physical site
Assign a stable line or reel reference before compiling a multi-site list. Reuse that reference in the spreadsheet, photo filenames, documents, and location notes. Group products only when the manufacturer, designation, condition, and quantity evidence actually match; otherwise, preserve separate rows even if the reels are stored at the same yard or warehouse.
Johns Creek's strategic priorities include economic development and transportation/connectivity; the city reports multiple transportation projects under construction or scheduled for completion and a Traffic Control Center update. This is limited city context for contractor or facilities examples, not proof of a local lot, a transportation service, buyer demand, or a transaction.
- Use one stable line reference in every inventory and photo file.
- List the actual storage site or seller-provided location beside each line.
- Keep different product designations and condition categories separate.
Show what is in the lot without using one representative reel
For every distinct line, capture the manufacturer, part number, readable cable designation, conductor information when known, and remaining continuous footage. Photograph the tag, jacket printing, reel overview, and visible condition under the same reference. One well-labeled reel cannot represent unphotographed reels with different specifications or storage conditions.
If a line is unidentified, make it an explicit unknown line. Add the available images and explain whether the missing detail is the designation, footage, condition, or location. That is more useful than forcing an uncertain item into a broader aggregate.
- Match tag and jacket photos to the exact line reference.
- Record continuous footage per reel before showing any aggregate total.
- Keep unidentified items visible as their own inventory lines.
Separate quantity, condition, and site differences
State the reel count, per-reel footage, and quantity basis for every site group. Label any weight as gross, net, or estimated, and keep dimensions separate from footage. A total spanning several sites must remain visibly an aggregate; it is not one continuous length or one uniform product.
Use condition fields to separate uninstalled stock, cable with known service history, and unknown-history material. Add storage exposure and visible damage notes to the appropriate line. Do not allow a dry, indoor reel at one site to stand in for cable stored elsewhere.
- Use measured, documented, or estimated for each footage figure.
- Label weight basis without equating it to conductor content.
- Keep site-specific condition notes and photographs with the relevant row.
Build a site-by-site release matrix
For each location, record the seller-reported owner, person or role able to authorize release, access limitations, and available loading information. These fields give the buyer a practical record for discussion, but do not promise a collection method, schedule, or site service.
When one contact can discuss inventory but another organization controls access, note that split. If release authority or access information is incomplete, mark it unknown and specify what seller-provided information is still needed instead of treating the entire lot as ready.
- Keep release authority connected to the correct storage site.
- State access limitations as supplied by the seller.
- Mark incomplete location or release details unknown.
Worked multi-site inventory record
Illustrative inventory example—not a purchased lot: JC-BL-01 is one documented 500-foot reel at Site A; JC-BL-02 is a separate 90-foot estimated reel at Site B, with its own photo references and release contact pending. This fictional example shows why matching product wording alone does not justify a shared quantity or shared access record.
The finished inventory should let a reviewer open any line, find its images, understand its quantity basis and condition, and see which location controls its release. That is the operational distinction this page addresses, rather than a generic instruction to list a large lot.
- Example line JC-BL-01: one reel, 500 feet documented, Site A.
- Example line JC-BL-02: one reel, 90 feet estimated, Site B.
- Example unknown: Site B release contact pending.
