Give every reel or group a stable reference
Assign an identifier to every reel, continuous piece, or genuinely identical group, then use the same identifier in the inventory, image filenames, and supporting records. A stable reference is the bridge between a broad list and the physical material, especially when several people prepare different parts of the submission.
Do not reuse one reference for two different locations or conditions. If two matching products are stored separately, give each its own line and its own site field. This makes it possible to understand the inventory without asking which photo or release contact belongs to which reel.
- Line or reel reference
- Photo filenames containing the same reference
- Document reference associated with that line
- One distinct reference for each site-held item
Retain real product and quantity differences
For each reference, record manufacturer, part number or designation, conductor material, size, rating, condition, and continuous length. Label footage measured, documented, or estimated. Do not collapse unlike reels into a total just because they are stored under the same roof or were purchased for the same project.
A group can be shown as one lot after the underlying lines remain visible. The buyer needs to see whether a total consists of a few matching full reels, partial reels with different footage, or an assortment whose specifications are still unknown.
- Manufacturer and readable product designation
- Material, size, and marked rating when known
- Per-reel continuous length and quantity basis
- Condition and any unknown product fields
Keep site controls with the correct line
For each storage site, retain the site reference, access restriction, available loading equipment, contact role, and release-authority role. These facts can differ even where product identity is the same. A general warehouse note is not enough for a multi-site inventory if it hides which reels can be accessed or released.
Birmingham IEO says it manages city-owned properties, oversees industrial parks, supports workforce grants and conducts economic impact analyses. This is only context for why a portfolio may include property or commercial records; it does not identify a cable lot or establish a business relationship. The needed evidence remains specific to the seller’s actual locations and reels.
- Storage-site reference
- On-site contact role
- Access constraint and available loading equipment
- Release-authority role for the item at that site
State lot scope and unresolved rows
Explain whether the seller wants the documented lines considered as one lot or in defined groups. Then mark anything reserved, unknown, or awaiting release separately. A buyer can assess known lines without assuming that every line in the original spreadsheet is included in the request.
Where photos or a length are pending, use an explicit status and name the follow-up evidence. Do not make a grand total do the work of a line-item record; it cannot show which information applies to which physical reel.
- One-lot or defined-group scope
- Availability and reservation status
- Photo, quantity, or identity unknowns
- Requested schedule stated only as a preference for discussion
Test the method with a fictional two-site record
A fictional list could show BL-BHM-01: matching product recorded; one reel, 500 feet documented; Site A. A second row could show BL-BHM-02: same product; 90 feet estimated; Site B. These are illustrative inventory rows, not purchased Birmingham lots, and the separate references prevent the second site from disappearing into a grand total.
The error is a single footage figure that hides different specifications, sites, evidence sets, and authorization status. Correct it by preserving a row per reel or continuous piece, retaining site grouping, and linking every photo and release reference before movement is discussed.
- Illustrative records only — not purchased Birmingham lots
- BL-BHM-01: 500 ft documented; Site A
- BL-BHM-02: 90 ft estimated; Site B
- Each line retains its own photo and release reference
