Reconcile the releasable balance first
An invoice, purchase order, or warehouse export can identify an original order, but it does not prove what is available today. Build one current row for each physical reel or continuous length. Carry the original reference into that row, then record whether the item is full, partial, cutoff, retained, reserved, missing, or pending release. Keep the current footage next to the basis for it: measured, documented, estimated, or unknown.
WVDOT reports that its Charleston Metro Projects program includes more than 50 planned and active bridge projects focused on rehabilitating and replacing aging bridges, with maps, schedules and traffic-management information. That is context for a clearly labeled changed-scope or project-overrun scenario only; a project name never establishes that cable is available or that it may be sold.
- Stable inventory line or purchase-record reference
- Manufacturer, part number, and complete readable designation
- Current footage for each reel and its measured, documented, estimated, or unknown basis
- Physical status: full, partial, cutoff, retained, reserved, missing, or pending release
Tie every claim to the physical reel
Give the reel a durable line ID and use that same ID in the spreadsheet, photo filenames, and any supporting files. Photograph the reel tag, a legible stretch of jacket printing, and an overall view. If the record and the reel disagree, preserve both descriptions rather than silently choosing one. A label discrepancy is useful information because it tells the reviewer which field needs a matching document or a conservative unknown label.
Do not turn a group total into a single continuous length. Two partial reels can share a product designation yet have different balances, condition, or release status. Keep their individual reel IDs and footage visible even when a summary row is helpful.
- Reel ID that matches the inventory row
- Photo references for tag, jacket legend, and overall condition
- Exact designation transcribed from the physical item or matching record
- Visible condition and any label discrepancy
Separate availability from release authority
A reel can be physically present while still reserved for another job or awaiting an internal release. Record the owner or authorized seller, the current approval status, the reserved or retained flag, the storage site, and any seller-stated release window. Those fields make the inquiry practical without representing that a move, collection date, or purchase has been agreed.
For a closeout containing both available and pending items, make two groups. The available group should identify the evidence that supports current status. The pending group should remain visible, with the missing approval stated plainly, rather than being folded into a headline quantity.
- Owner or release authority and role
- Approval status and reserved or retained flag
- Storage site and known access restrictions
- Seller-stated release timetable, if one exists
Keep incomplete balances honest
If a reel cannot be accessed, report the last known figure as historical context, not current availability. Mark the current balance as not inspected, estimated, or unknown and explain what supports that label. If only the original tag is available, it can identify the reel but it is not proof that all original footage remains.
The inventory mistake to avoid is presenting original invoice footage as the quantity available now while treating partial or reserved reels as full. The workable correction is a current balance per reel with an evidence basis and a separate approval status. This preserves useful possibilities without overstating the lot.
- Use not inspected when physical reconciliation has not occurred
- Keep historical invoice footage in a separate, labeled column
- Explain the source of every estimate
- Do not merge uncertain reels into a releasable total
Illustrative current-balance record
The following is an illustrative fictional record—not a purchased lot. It shows how a seller can make a partial balance and a pending release visible in one line without treating either as a confirmed transaction.
A real record should use the seller’s own reel tag, photo references, storage information, and approval details. If a field cannot be supported, retain the field and mark it unknown or pending instead of filling it from an old order.
- Line: OV-CHAR-07
- Product: project-overrun feeder cable; part number on reel tag
- Current balance: 2 reels; 300 ft documented and 180 ft estimated
- Status: uninstalled; release approval pending
