Give every reel a stable line ID
Assign a reference to every reel or genuinely identical group, then use that same reference in the spreadsheet, photo filenames, and documents. Do not group partial reels with different footage just because their part numbers match. A stable reference makes a multi-reel lot auditable without relying on one representative photograph.
For local context, The City of Ankeny Economic Development Department works with the Greater Des Moines Partnership to attract new businesses and help existing businesses prosper and expand. That fact does not prove a local stock source or buyer activity; it only gives limited commercial context while the page remains focused on seller-controlled line records.
- Line or reel ID
- Manufacturer and part number
- Photo filename
- Document reference
Build a per-line specification record
For each line, transcribe complete markings, conductor material, size, count, marked rating, condition, and remaining continuous length. State whether the quantity is measured, documented, estimated, or unknown. A grand total may be useful as a summary, but it must not erase the facts that distinguish one reel from another.
Keep identified stock, removed material, and recovery-only pieces in distinct categories. Do not use a material family name as a substitute for a complete construction record.
- Complete markings
- Metal, size, count, and rating
- Condition category
- Per-reel length and quantity basis
Map each line to its actual site
Group lines by the warehouse, yard, or project storage site where they are actually held. For every site, retain access limits, available loading resources, release contact, and seller timetable. A lot can be one commercial discussion while still needing separate site facts for the individual lines.
If a release contact is unknown, write unknown and identify the responsible role or next internal step only when the seller knows it. Do not imply that one contact or one set of access conditions applies to all sites.
- Storage site
- Access limits
- Available loading resources
- Release contact and seller timetable
Define scope and leave gaps visible
State whether the inventory is offered as one defined group or as described sublots. Keep ownership or authorization limits visible, and separate any line whose condition or identification is incomplete. Unknowns should stay on their own record rather than being averaged into identified stock.
Illustrative inventory example—not a purchased lot: BL-AK-01, matching product, one reel, 500 ft documented, Site A; BL-AK-02, same product, one partial reel, 90 ft estimated, Site B; line 1 uninstalled and line 2 has visible flange damage; different release contacts with loading resources recorded by site. The example illustrates the site-level control point, not an actual purchase.
- Lot or sublot scope
- Ownership or authorization
- Condition category
- Per-reel length retained in every group
