Set the boundary of stock being offered
Give every inventory line an availability status before adding it to the inquiry: offered, retained, reserved, awaiting return, or pending internal approval. Add a short reason for the surplus, such as project overrun or warehouse closeout, without treating that reason as proof that the material can be released.
A line with unresolved approval can remain visible, but it should not be blended into the offered subtotal. Naming the boundary lets a reviewer distinguish a current surplus balance from material that is still committed elsewhere.
- Availability status
- Reason for excess inventory
- Reservation or return status
- Release-approval status
Match records to the physical reels
Use an inventory reference that appears on the spreadsheet, reel tag image, and jacket photo. Keep full reels, partial reels, coils, and cut pieces in separate rows even when they began on the same purchase record. The physical match, not an invoice total, anchors the present inventory.
If a purchase record cannot be tied to a visible item, note it as unmatched. Do not use a familiar manufacturer name or an old order description to fill missing reel markings. Unknown identifiers remain useful when clearly labeled as unknown.
- Inventory reference
- Manufacturer and part number if readable
- Physical reel or piece condition
- Matching tag and jacket-photo filenames
Report the current balance rather than original footage
For each offered line, enter remaining continuous length and state whether it was measured, documented on the reel, or estimated. The original footage can remain in a reference column, but it should not replace the current balance after partial use or a warehouse move.
Record reel count alongside the length basis. If two similar reels have different evidence quality, make two rows. This avoids a grand total that masks an estimated balance or a missing physical confirmation.
- Reel ID
- Current continuous length
- Measured, documented, or estimated basis
- Reel count and any physical-match issue
Use the city reference only as seller context
The City of Chula Vista says the Otay Valley Parcel within the Otay Ranch planning area contains 9,449 acres; its 2013 amendments also enabled additional acreage for a University and Innovation District planning area. It can help explain why a seller describes a project-overrun source, but it does not show that any wire or cable remains, belongs to the seller, or is authorized for release.
For each actual line, add ownership, storage site, access limits, and available loading information. Keep those fields with the current balance so a project label never substitutes for a release check or a physical inventory reconciliation.
- Owner or release authority
- Storage location
- Access or gate limitations
- Available loading information
