Build a lot map before adding totals
A bulk list is useful when another person can locate every line. Assign a stable ID to each reel or continuous piece and repeat it in the spreadsheet, photo filenames, supporting documents, and site notes. Record manufacturer, part number, visible designation, condition, and the storage-site group on the same row.
Do not let a grand-total footage or weight figure replace the rows beneath it. Retain each reel count and continuous length, then label the basis as measured, documented, or estimated. Identical part numbers may share a product description, but separate reels still need their own references when their locations, condition, or quantities differ.
Separate site access from material identity
Group each row by the actual warehouse, yard, or project location. Record the seller’s release authority, ownership status, access limits, available loading resources, known dimensions, and whether a reported weight is gross, net, or unknown. These are planning facts supplied by the seller, not an arrangement for transport.
If two sites have the same product, do not merge them just because the cable looks alike. A row-level site group makes it possible to preserve different gate restrictions, reel dimensions, photo sets, and quantity bases. Unknown weight or access details can remain blank only if they are explicitly marked unknown rather than silently replaced with a total.
Use the local access fact within its limits
The Iowa Economic Development Authority lists Southbridge transportation access as four-lane highway, rail, air within 20 miles and barge within 5 miles; it also describes two I-29 interchanges and a three-track Union Pacific drop-and-pull yard.
The transportation description explains why seller-supplied location, dimensions, loading, and release fields can be practical for a large reel inventory. It is not a statement that any specific cable is at Southbridge, that a local buyer facility exists, or that a particular freight or collection arrangement is included. The inventory still needs site-level facts from the seller.
Correct the representative-photo mistake
A frequent bulk-lot error is using one representative photograph and one aggregate number for reels with different markings, conditions, or sites. Resolve it with a row for every reel or continuous piece, a photo filename that repeats the row ID, and a short note whenever a photo shows only one variant.
For incomplete inventories, preserve the unknown rather than force a match. A line can say “length estimated,” “weight basis unknown,” or “release contact to be confirmed.” That record is more actionable than a polished total because the remaining question is attached to the exact reel and location.
Worked example: two sites, two records
Illustrative fictional record only — not a purchased lot: BL-SC-01, matching product, 500 ft documented, Site A, photo A01-tag.jpg; BL-SC-02, same stated product, 90 ft estimated, Site B, photo B02-tag.jpg; weight basis gross loaded reel unknown. The example keeps matching product language from hiding different quantities and locations.
A real bulk inquiry can use a similar table, with the actual storage site and authority fields added to each line. The resolution is not to infer missing dimensions or promise handling; it is to show what is known and identify the site-specific questions that remain.
