Build a stable reference system before adding totals
Multi-site cable inventory becomes unreliable when a spreadsheet carries one grand footage number while reels sit in different buildings, yards or storage areas. Assign each reel, continuous piece or truly identical group a stable reference. Use that reference in the spreadsheet, photo filename and any attached document.
The most common bulk-lot mistake is a single total that hides lengths, condition, release contact and loading differences. Correct it with one row per reel or continuous piece. If a group is used, document why the reels genuinely match and preserve the quantity for each member.
- Line or reel reference.
- Photo filename and document reference.
- Grouping rule for truly identical reels.
- One row per reel or continuous piece.
Keep specification and quantity at reel level
Every row should carry manufacturer, part number, designation, metal, size, conductor count, rating and per-reel continuous length as known. A broad “mixed cable” description can be used for an unknown line, but it should not erase the detailed entries that are available.
Use a quantity-basis field for each footage and a separate weight-basis field where weight is recorded. Measured, documented and estimated values are all workable when labeled. A grand total may be added for orientation, but it cannot replace the itemized record that shows whether one long reel or many short pieces are present.
- Manufacturer and part number.
- Designation, metal, size, count and rating.
- Per-reel continuous length.
- Measured, documented or estimated quantity and weight basis.
Retain site-specific release and access facts
For each storage site, retain the condition, release contact, known dimensions or weight basis, loading resources and access limitations. The same cable specification at two sites may have different approval and handling facts. Do not treat a contact at Site A as authority for Site B without a record that it is.
If a site contact or approval is unresolved, mark that row pending and say what is known. This supports a buying review without asserting that all material can move together or that a particular logistics arrangement has been agreed.
- Site and condition.
- Release contact or pending approval.
- Dimensions or weight basis.
- Known loading resources and access limits.
Place the local facts in their limited role
Lexington says its public infrastructure incentive program supports private-sector projects within the Lexington Urban Service Boundary. The fact can provide background for a private-project or redevelopment context, but it does not establish that a seller has a distributed lot, owns the material or has authority at multiple sites.
The Kentucky Cabinet for Economic Development reported SRC of Lexington planned a $15.3 million Fayette County expansion with nearly 180,000 square feet and 60 new jobs. That verified report is likewise context for a closeout scenario, not evidence of SRC inventory, a customer relationship or a particular multi-site cable lot.
- Local facts are context, not lot evidence.
- No inventory attributed to named organizations.
- Seller records control each listed reel.
Worked record for two different storage sites
An illustrative inventory example—not a purchased lot: BL-LX-01; Illustrative Site A; one reel, 500 ft documented; photo BL-LX-01-A; release contact pending. A second row is BL-LX-02; Illustrative Site B; one reel, 90 ft estimated; photo BL-LX-02-A; approval pending. The records are intentionally not merged into one 590 ft line.
This task differs from project-surplus release because its decision is auditability across locations, not whether one project’s reels are cleared. It differs from industrial closeout because the core problem is reference, photo and site reconciliation, not the construction history of a facility cable assembly.
- Reference: BL-LX-01.
- Site: Illustrative Site A.
- Quantity: one reel, 500 ft documented.
- Second line: BL-LX-02; Illustrative Site B; one reel, 90 ft estimated.
