Reconcile the historical record with the reel in front of you
A purchase order, invoice, or original reel label can explain what was supplied, but it does not establish today’s available balance. Match each inventory line to the physical reel or piece at the stated storage site. Record the inventory line ID, manufacturer or part number, current footage per reel, and whether the quantity is measured, documented, or estimated.
When a reel is missing, reserved, partly consumed, or returned to another project, show that condition in the record. Retain the historical number as context, but do not put it in the offered-balance field. The seller decision is which identified material is actually available, not how much was originally ordered.
- Use separate historical-quantity and current-balance fields.
- Tie each current-balance figure to a reel reference.
- Flag missing, reserved, or pending-approval items instead of adding them to the available total.
Make release state visible on every offered line
A full reel, partial reel, cut length, reserved item, and pending-approval item should not share the same status. Record condition or status, remaining continuous length, release authority, and any pending approval or reservation. This exposes whether the lot is currently eligible for a purchasing conversation or still needs an internal decision.
If release authority is unknown, state which person, role, or internal record must confirm it. Do not assume that the person who can show an item can authorize its sale or release. That distinction is particularly useful for warehouse balances that have moved between project, return, and surplus lists.
Match tags, photos, and discrepancies to the same record
Use a stable reel reference in the spreadsheet and all photo filenames. Capture the tag, readable jacket text, and an overview that shows the reel’s present state. Record the complete designation when available, and note visible discrepancies between the tag’s original footage and the current balance rather than silently choosing one value.
A line with unreadable marking can still be listed as unknown. It should remain separate until a tag, product record, or clearer image supports the missing field. This preserves a seller’s evidence while avoiding an assumption that an old project label settles what remains today.
State access facts without turning them into transaction terms
For the material that is actually offered, record storage location, gate or site rules, available forklift or crane information, and the seller’s requested release timetable if one exists. These facts let a reviewer understand constraints while leaving any movement and other lot terms for a specific later agreement.
The Cicero Connections Plan provides a 20-year vision for transportation and development enhancements, including improved access to CTA and Pace buses, the Cicero Metra station, and CTA Pink Line stations at Cicero and 54th/Cermak. It is planning context for a hypothetical project closeout only, not evidence of an actual transit-related reel, local buyer relationship, or available inventory.
Use a current-balance example instead of an old invoice total
The recurring mistake is presenting an old project invoice or reel label as the current quantity while reserved and available stock are combined. The correction is a current-balance column tied to each reel, with the original quantity retained only as historical context and the approval or reservation state shown on the same record.
Illustrative fictional record—not a purchased lot: reelRef OV-CIC-01; designation “manufacturer and part number on tag; exact designation pending transcription”; quantity “2 partial reels; 300 ft documented and 180 ft estimated”; status “uninstalled project overrun; release pending.” The example gives separate quantity bases and signals that release is not assumed.
- Mistake: historical footage is presented as available balance.
- Resolution: per-reel current balance, quantity basis, and explicit release state.
