Turn a grand total into traceable lines
A large lot becomes difficult to review when one footage total combines several reels, conditions, or locations. Give each reel or truly identical group a stable line ID. Repeat the ID in photo filenames and supporting documents so a reviewer can follow a line from spreadsheet to reel without guessing which image belongs to it.
The focused decision is whether every offered line can be matched to its reel, photos, storage site, quantity basis, and release authority. It is not a page about why stock became excess or how to identify a particular cable family; those are different seller tasks.
- Stable line or reel ID
- Photo filename and document reference
- Storage site for every offered line
Keep the quantity basis beside every reel
Retain continuous length per reel, reel count, and the basis of each number. Use documented, measured, or estimated rather than presenting all figures with the same certainty. If matching reels may be grouped, preserve the length per reel so the total can be reconstructed.
The specific mistake is using one grand-total footage figure for reels at different locations and with different conditions. Correct it by using a row per reel or continuous piece, retaining site and specification differences, and labeling every quantity basis.
- Specification and reel count
- Length per reel
- Measured, documented, or estimated quantity basis
Separate sites, conditions, and authority
A list spanning multiple locations needs a site field even where the product appears identical. Keep maintenance stock, cable with prior service, and mixed pieces on separate lines. Record access restrictions, reel dimensions, known weight basis, and available loading information as site facts, not as assumed transport arrangements.
Name the person or role that can authorize release, or state that it is unknown. A site contact who can point out reels is not necessarily the person authorized to offer them. Keeping that distinction visible prevents a well-organized inventory from suggesting a transaction that has not been authorized.
- Site or location
- Condition and service-history note
- Release authority
- Access restriction and loading information
Resolve incomplete line items without losing the lot map
Do not drop an uncertain reel into a catch-all total. Give it a line ID, its actual site, a photo reference, and an explicit unknown or estimated field. This lets the full inventory remain useful while showing exactly which lines need a better tag, a quantity check, or release confirmation.
Illustrative inventory example—not an actual or purchased O'Fallon lot: BL-OF-01 is 500 ft documented at Site A; BL-OF-02 is 90 ft estimated at Site B; both have matching product markings, but the authorized releaser for Site B is unknown. The example remains two lines because location, evidence basis, and authority differ.
- BL-OF-01: documented quantity at Site A
- BL-OF-02: estimated quantity at Site B
- Unknown release authority stays visible
Use the city fact as context, not as a lot claim
O'Fallon Engineering reviews commercial plans, issues utility-excavation permits and works on wastewater, stormwater and drinking-water issues.
This provides local project context only. It does not establish a cable type, an available inventory, or an agreement to handle multiple sites together. For a bulk inquiry, the practical value is a reel-by-reel map with the actual site and evidence attached to each line.
- Do not infer product type from project setting
- Do not merge locations to simplify the total
- Keep the actual offered boundary visible
