Reconcile the record with the reels
Start with the purchase order, warehouse export, or closeout list, then compare every listed line with the physical reels and coils you intend to offer. The document may show what was originally ordered, while the current inventory may include partial reels, material reserved for another use, or stock awaiting an internal release decision.
Create a current-balance column beside the original quantity. A line is useful when it identifies the item, states whether the balance is measured, documented, or estimated, and makes the release status visible. Do not convert an old total into a current available quantity without a reel-level check.
- Inventory line ID and original quantity
- Current balance with measured, documented, or estimated basis
- Release status for each offered reel
Keep full and partial lengths separate
Use one row for each reel, coil, cutoff, or continuous piece. Record the reel reference, the remaining continuous length, condition, and the evidence behind the length. A 300-foot documented balance and a 180-foot estimate should remain separate even when both came from the same original line.
The likely error is presenting invoice footage as if it were still available while a partial reel or a pending line is hidden in the total. The workable correction is to preserve the difference between original quantity, current balance, and any line not yet authorized for release.
- Reel reference
- Continuous length per reel
- Condition and quantity basis
Connect the spreadsheet to visible evidence
Give each reel a stable ID and use it in the spreadsheet and photo filenames. Capture the reel tag, readable jacket printing, a full-reel view, and any visible condition issue. If a tag is missing or text cannot be read, say so on that line rather than borrowing a specification from another reel.
Miami-Dade Public Works describes county transportation work across roads, bridges, canals, sidewalks, traffic signals and roadway improvements. That county context is only a reason to keep changed-scope or overrun records traceable; it does not identify a seller, a project, or an available cable lot.
- Photo reference tied to reel ID
- Readable designation or explicit unreadable-label note
- Storage exposure and visible condition note
Separate release questions from quantity questions
For each row, identify the person or role that can authorize the sale and note whether approval is confirmed, pending, or unknown. Include the actual storage location and access constraints that affect a later discussion. An old order document does not itself establish authority to release the material.
When an approver has not acted, leave the inventory line in the list but label it pending. This lets the purchasing discussion distinguish physical material from material that may not yet be offered, without assuming timing, acceptance, transport, or any transaction term.
- Release contact or role
- Authorization status
- Storage location and access restrictions
Use a fictional row as a quality check
A clear illustrative row might read: OV-MB-04; project-overrun feeder cable, designation on reel tag; two reels, 300 feet documented and 180 feet estimated; uninstalled; one reel pending release approval. This is a fictional record, not a purchased lot and not an indication that a particular configuration will be accepted.
Before submitting a list, scan for lines where the stated current amount is really the original order amount, where photos cannot be matched to a reel, or where release is assumed. Correcting those three gaps is more useful than adding a broad project narrative.
- Example reference: OV-MB-04
- One length basis for each reel
- Pending release shown as pending
