Reconcile what remains before you list it
Start with the reels that are physically present, not the quantity on the original purchase order. Give each reel a stable reference, then record manufacturer, part number, complete designation, current continuous length, and whether the length is measured, documented, or estimated. A project remainder may include full reels, partial reels, and cut lengths; keep those forms separate even when they came from one order.
The common failure is carrying an invoice total into a sale list after a scope change. A current-balance row fixes that problem: mark a missing reel as missing, identify any reel reserved for another use, and leave an estimate visibly labeled. This gives the reviewer a usable inventory instead of an optimistic historical total.
- Use one reference that appears on the reel record, photo filenames, and inventory row.
- State measured, documented, or estimated beside every remaining length.
- Keep full reels, partial reels, coils, and cut lengths on distinct lines.
Separate matching cable instead of averaging it
Group reels only when their printed product designation, conductor metal, size, insulation or jacket, and condition genuinely match. A sum of short pieces is not the same thing as one continuous reel, and a matching part number does not make two different remaining lengths interchangeable. Put the continuous length on each reel line before calculating any group total.
If a tag is missing or jacket print is partly unreadable, record the observed text and call the uncertain field unknown. A packing list can be attached as supporting context, but it should not silently replace the physical identification. That distinction lets a seller submit incomplete inventory honestly without turning a guess into a specification.
- Transcribe the readable jacket legend and part number.
- Record conductor metal, AWG or kcmil size, and insulation or jacket on each specification line.
- Mark identification as unknown when the physical reel cannot support the field.
Keep release status separate from cable identity
A reel can be accurately identified and still not be available to sell. Add an ownership field, the person or role able to authorize release, an approval status, and the storage location to every current-balance row. Use available, reserved, or approval-pending as status labels only when the seller has support for that label.
Do not convert a pending internal approval into an available quantity. If the availability date is not known, say unknown and describe the limiting condition briefly. This preserves the difference between a documented cable reel and a reel that is actually ready for a lot-specific purchasing conversation.
- Name the release authority or record the role as unknown.
- Keep reserved and approval-pending rows out of the available subtotal.
- Note the site location and any documented availability constraint.
Make the photograph set follow the inventory
Use the reel reference in the filenames for a tag photo, readable jacket printing, a reel overview, and a condition view. The photos should show what the row says, not a clean sample from elsewhere in the lot. Note storage exposure and visible packaging or flange issues in the same row so the physical record stays connected to the evidence.
A workable fictional record would read: OV-CY-01; manufacturer and part number from reel tag, exact value unknown; two reels with 300 ft documented and 180 ft estimated; uninstalled condition; release pending. It is an example of record structure, not an actual Cheyenne lot. The important part is that its quantity basis and release status are visible rather than assumed.
- Match every photo filename to the reel reference.
- Include a tag, jacket-print, overview, and condition image where available.
- Describe missing photos or unreadable markings as a gap, not a confirmation.
Use local project context without treating it as inventory proof
The public project list does not identify the offered cable reel: The City of Cheyenne Board of Public Utilities page lists active water-main replacement, rehabilitation and installation projects on E 19th Street, South Cheyenne Avenues and Dell Range Boulevard. It can explain why a contractor needs to reconcile project remainder records, but it cannot show that any material is for sale. For a Cheyenne inquiry, use the project reference only as background and let the reel markings, current balance, and release record establish the offered inventory.
When the list is ready, send the line-item inventory and photos to saleselectricalbuyers@gmail.com and include a reachable seller contact. The review concerns the documented lot; do not merge an old project quantity with a current release decision simply because both have the same project name.
- Use project names as context, not as cable specifications.
- Keep a release record with the same reference as the reel record.
- Send the current inventory, not only a purchase-order export.
