Build a stable multi-reel inventory
A large cable lot can span warehouses, yards, or project storage areas. Assign one inventory reference per reel or genuinely identical group and reuse it in the spreadsheet, photo filenames, and supporting documents. A grand total alone hides different lengths, conditions, locations, and release contacts.
Keep a reel ID, document link, and photo reference on the same row. If a field cannot be confirmed, record unknown rather than copying details from the closest reel.
- Inventory reference.
- Reel ID.
- Photo filenames.
- Document links.
Retain line-level specifications
For each reel or matched group, record manufacturer, part number, designation, conductor metal, size or rating, count, footage per reel, and quantity basis. A mixed lot can contain multiple material families, but the record remains useful only when each specification stays visible.
This is not the project-overrun balance workflow. Here the decision is whether another reviewer can trace every row to its physical reel, evidence, actual site, condition, and release authority across a coordinated lot.
- Manufacturer and part number.
- Designation, metal, and size or rating.
- Count and footage per reel.
- Measured, documented, or estimated quantity basis.
Separate actual sites and practical constraints
Group rows by their real warehouse, yard, or project location. Record access limits, available loading resources, condition differences, and site grouping rather than treating several addresses as one location. Site details provide the context for a later conversation without implying a collection method.
State whether the lot is offered together or in defined groups, then record ownership, release authority, and requested timetable. If a contact or loading detail is not known, mark it unknown on the relevant site group.
- Storage location and site grouping.
- Access limits.
- Loading resources.
- Condition, offering scope, ownership, and release authority.
Replace a grand total with a fictional audit trail
The likely mistake is one grand-total footage figure that hides different reel lengths, storage sites, and specifications. Resolve it with one row per reel or continuous piece, matched photos, site grouping, and a stated quantity basis.
Illustrative inventory example—not a purchased lot: BL-BTH-07A is one reel at Site A with 500 ft documented; BL-BTH-07B is one reel at Site B with 90 ft estimated; Site B loading restriction unknown; authority contact pending. The two rows remain distinct even if their product designation matches.
- One row per reel or continuous piece.
- Photos linked to that row.
- Separate site group for each actual location.
Limit local context to its source-supported role
LVEDC lists global and national employers in the Lehigh Valley and provides a site-finding resource covering industrial, office, land and retail properties in Lehigh and Northampton counties. It supports only a general regional commercial-property context; it does not identify a customer, establish a multi-site lot, or promise an outcome for any inventory.
Email the reconciled spreadsheet and matching photos to saleselectricalbuyers@gmail.com, or call +1 (614) 715-3047 to discuss the defined lot. Keep unknown site or authority details visible instead of collapsing them into the total.
- For a bulk lot, traceability per reel and per site is more valuable than a single aggregate number.
