Reconcile an order record to physical reels
Start with the inventory export, purchase order, or project list, but treat it as history rather than the offered quantity. Walk the stated storage area and assign a stable reel ID to every full reel, partial reel, box, and separate continuous piece. Put the original ordered quantity beside a current physical-balance field so a reviewer can see what changed.
For each discrepancy, name the inventory line or order reference, record the manufacturer and part number when visible, and state the current storage site. A reel that cannot be located, a return awaiting credit, or a line reserved for another job belongs in a discrepancy note rather than in available footage.
- Keep original order footage and present balance in separate columns.
- Give partial reels and cut lengths their own records.
- Match tag and jacket photos to the same reel ID.
Make release status a field, not an assumption
For every record, use a clear availability status such as available, reserved, pending return, or release pending. Add the person or role with authority to release the cable and a reference to the supporting release note when one exists. Do not count a reel as saleable simply because it remains on an old inventory report.
If an approval is incomplete, retain the reel in the list but mark it pending and leave its status visible. This preserves the inquiry without representing a pending line as current surplus. It also lets the seller update one row when the actual release decision is documented.
- Availability status
- Reservation or return status
- Release authority and release-note reference
- Current storage site
Use footage with an honest basis
Record continuous footage per reel, not only an aggregate total. Say whether the amount is measured, documented from a current record, or estimated; do not turn several short pieces into one continuous length. Where a reel tag shows its original amount, retain that tag value as identification evidence and identify the remaining quantity separately.
A useful photo set includes the reel ID, readable tag or jacket printing, and an overview that can be matched to the spreadsheet row. Group only lines with the same designation and condition. If product markings or footage are unavailable, label the missing field unknown and explain what record would resolve it.
- Reel ID
- Continuous footage
- Measured, documented, or estimated basis
- Photo filename and matching-group rationale
Lakeville context and a worked record
Lakeville identifies its 2026-2030 Capital Improvement Plan as a long-range framework for infrastructure needs, development objectives, projects and equipment acquisitions. That local planning statement is only context for carefully reconciling project-related records; it does not indicate that any cable from a city project is offered or that a buyer has a relationship with the city.
Illustrative fictional record—not a purchased lot: OV-LV-07; designation and part number transcribed from tag; Reel A, 300 ft documented, available; Reel B, 180 ft estimated, release pending. The likely error is reporting both reels as the invoice total. The correction is a current-balance column tied to the two physical reel IDs and their different release states.
- Keep a pending reel visible but outside the available balance.
- Use project context only as background, never as a cable specification.
