Create a stable line item before making a grand total
Give each reel or truly identical group a line ID that appears in the spreadsheet, tag photographs, and supporting files. Record manufacturer, part number, cable designation, metal and size, conductor count, rating, per-reel footage, and the quantity basis. A total footage number by itself hides differences that affect the actual inventory record.
When a field is unknown, put unknown on that line rather than forcing a uniform description across the lot. A bulk submission is easier to understand when each physical item remains traceable.
- Line or reel ID
- Manufacturer and part number
- Designation, metal, size, and rating
- Per-reel footage and quantity basis
- Photo reference
Group matching inventory by its actual storage site
Use a site field for every line. Keep warehouse, yard, and other storage locations as separate groups, even if products appear to match. Within each site, record condition, release authority, access limits, dimensions, documented weight basis, and available loading information.
This page addresses a multi-site control problem, not an overrun ledger for one project. A line may be technically identical to another line but still require a separate site and release record.
- Storage location
- Condition
- Owner or release authority
- Access limits
- Dimensions and weight basis
- Loading information
Use photo and quantity references that do not drift
Name photographs with the same line ID used in the inventory. A tag image, jacket-print image, whole-reel view, and condition image can be mapped to the exact item. Keep estimated footage clearly marked and do not combine an estimated partial reel with a documented full reel just to reach a lot total.
If a forklift, dimension, weight, or release contact is not known, label it unknown. Documentation of an unknown is a better handoff than a guessed logistics statement.
- Tag and jacket photo
- Whole-reel or piece photo
- Condition photo
- Measured, documented, or estimated footage
Lancaster access context is not a freight commitment
The city economic-development page says Lancaster sits at the intersection of Interstate 14 and State Route 138, with same-day access to Los Angeles, Orange County, San Diego, Northern California and Arizona.
That geographic statement can make precise site, access, and loading information useful in a Lancaster inquiry. It does not promise pickup, freight, timing, or a transport method; those details remain specific to the actual inventory and any later agreement.
Worked multi-site file: fictional, not a purchased lot
Illustrative inventory example—not a purchased lot: BL-LA-01 records a matching product, 500 ft documented, and Site A. BL-LA-02 records the same product, 90 ft estimated, and Site B. Their tag photos are named BL-LA-01-tag and BL-LA-02-tag; forklift availability is unknown and dimensions are pending.
The likely mistake is using one aggregate footage number for reels at different sites or with different specifications. Correct it by using one row per reel or continuous piece, preserving site groups and explicit unknowns.
- BL-LA-01: 500 ft documented; Site A
- BL-LA-02: 90 ft estimated; Site B
- Handling: forklift availability unknown; dimensions pending
