Build a lot index before totaling anything
The regional transportation source lists I-64, I-69 and U.S. 41 as highways serving the Evansville Region, with I-64 access toward Louisville and St. Louis and U.S. 41 extending north toward Chicago and south toward Miami. That roadway context is relevant only because actual storage, access, and loading facts should stay with the correct line; it is not a transport promise. Begin a multi-reel list with one stable ID for each reel or continuous piece, even when several products appear identical.
Reuse the same ID in the inventory row, image filename, and any supporting document name. A grand total without those cross-references creates the most common bulk-lot failure: photos, weights, and specifications can no longer be connected to a particular reel. Keep the line stable if the lot is later sorted by site or material.
- Unique line or reel ID
- Matching photo filename
- Matching document filename where available
Preserve per-reel quantities and weight bases
Record the reel count and continuous footage for each line, even when product designations match. Label footage measured, documented, or estimated. A lot total may be useful for orientation, but it must not replace the per-reel lengths that explain what the total contains.
List any dimension and weight with its basis. Gross loaded-reel weight, net cable weight, and an estimate answer different questions, so do not exchange them. If a reel is missing a weight or dimension, say unknown. The goal is a traceable coordination sheet, not a derived conductor-content claim.
- Reel count and footage per reel
- Measured, documented, or estimated quantity basis
- Gross, net, or estimated weight basis
Group lines by the place they are stored
For a lot at more than one location, identify the actual storage site on every row and name the owner or release contact for that site. Preserve site grouping when a spreadsheet is exported or photos are shared. A photo of one yard or warehouse should not be treated as evidence for a reel stored elsewhere.
State access restrictions, any known loading equipment, and the seller’s availability or release timetable as observed. Those facts enable a practical lot discussion without assuming that any particular movement method has been agreed. Unknown access details should be left open rather than inferred from the regional route map.
- Storage site
- Owner or release contact
- Access restriction and available loading resource
Correct the grand-total inventory mistake
The specific mistake in a bulk inquiry is a single footage and weight total for several sites, with photographs that cannot be tied to individual reels. The remedy is one row per reel or continuous piece, matched references across files, site grouping, and a clearly labeled weight basis for every line.
Do not use a clean image from one reel as proof for a set of different reels. Retain variations in packaging, fitted ends, visible jacket condition, and quantities. If a specification is still unknown, put that uncertainty in the relevant row instead of grouping the item into a product category by appearance.
- One row per reel or continuous piece
- Photo reference matched to row ID
- Condition differences retained by line
Use a fictional coordination row
Illustrative inventory example—not a purchased lot: BL-EV-01 is one reel with 500 ft documented, stored at “Site A; exact address unknown.” Its product designation is recorded, its weight is listed as “gross loaded-reel weight; basis documented,” and its photo is BL-EV-01-tag.jpg. The example shows a usable record without inventing a net cable weight or release contact.
Before sending the lot, search the sheet for duplicated IDs, photo filenames that do not match rows, and totals that conceal different sites. This page is not the place to reconcile an old project order or establish detailed medium-voltage specifications; it is the handoff that keeps a multi-reel, multi-location inventory traceable.
- Example line: BL-EV-01
- Site: exact address unknown
- Photo: BL-EV-01-tag.jpg
