Build a current-balance sheet, not an order summary
Start with the purchase order or inventory export only as a locator. Walk the material and give every physical reel, coil, or defined cut length a row. Keep the original ordered footage in a reference column and record a separate current figure with its basis: measured, tag-supported, or estimated. A 1,000-foot order that now has two partial reels is not a 1,000-foot offering.
For each row, pair the inventory-line ID with a reel ID, product designation, current continuous length, condition, and photo filename. A reel that cannot be found belongs in an unresolved list rather than the available total. This preserves a useful offer list without letting historical purchasing data stand in for a physical count.
- Use one stable reel ID in the sheet, photo filenames, and any release record.
- Label footage as measured, documented, or estimated instead of presenting one assumed number.
- Keep a separate unresolved status for a missing tag, missing reel, or unconfirmed balance.
Separate availability from release status
A current balance is not enough when some cable is reserved for a return, a later project phase, or an internal decision. Split the worksheet into available, reserved, pending release, and not located rows. Do not fold pending rows into the available footage total. The seller decision on this page is whether a named reel and continuous length are both present and authorized for a sale discussion.
Also split full reels, partial reels, cut lengths, and mixed short pieces into their own rows. The continuous length of a partial reel is different from the sum of several pieces. Describe whether material is unissued stock, previously in service, or of unknown history without using one condition label for the whole project.
- Record the owner or controller shown in your records for each release group.
- Name the role that can authorize release; use pending when that approval is not yet documented.
- Keep reserved footage visible but outside the offered-total calculation.
Make the photo packet prove the worksheet rows
Photograph a readable reel tag or jacket legend, an overall view, and any visible condition difference for each specification. File names should repeat the reel ID rather than a generic camera sequence. If one image documents more than one identical reel, say which reels it covers; do not let a photo of one reel silently describe the rest of the group.
Add storage location, access limits, available loading information, and a contact for release questions to the same row or site tab. Those practical facts help frame a lot-specific discussion. They do not mean movement, timing, or terms have been agreed.
- Match every listed reel to at least one photo reference or mark the photo unavailable.
- Show cut ends and partial-reel labels where safely accessible.
- State unknown access or loading facts as unknown rather than assuming a handling method.
Use Mission Viejo project context carefully
The city’s Capital Improvement Program has four categories: General Infrastructure; Roadway Rehabilitation; Transportation Systems/Traffic Capacity; and Parks, Recreation, and Municipal Facilities. If a seller uses a project category to explain why cable remained, it can be a helpful origin note alongside the actual reel record. It does not show that any particular material is available, owned by the seller, or approved for release.
A simple origin field such as “project closeout” or “commercial overrun” is enough when it is truthful. The next useful evidence is still the reel-by-reel balance and release status, not a broad statement about local work.
- Use project context as background, not as a cable specification.
- Do not substitute a corridor or facility name for product markings.
- Keep the release record tied to the actual storage location.
Worked reconciliation record and unknowns
Illustrative inventory example—not a purchased lot: Reel MV-OV-07 is listed as a fictional surplus power-cable reel with 300 feet documented from a remaining-length tag. A second reel, MV-OV-08, has 180 feet documented. The original order total is retained only as background; neither row is included in an available total while release is pending.
If the tag on MV-OV-07 cannot be read or the releaser is not known, leave current footage or release status as unknown. Add the last record you have and state the next confirmation needed. That is more actionable than overstating the total or creating a false release assumption.
- Example status: unissued stock; release pending.
- Example quantity basis: documented remaining-length tag.
- Example next step: confirm the releaser and photograph the tag again.
