Assign one reference before building the total
Give each reel or continuous piece a stable line ID. Use the same ID in the spreadsheet, the photo filenames, and any document names. Include the storage site and a specification group on the row so the buyer can distinguish two similar products that happen to be kept at different locations.
A bulk inventory becomes confusing when a photo or aggregate footage figure cannot be tied back to a physical item. Start with the individual references and create summaries afterward. This controls a multisite lot without pretending every reel has the same condition, construction, or release path.
- Line or reel ID
- Photo filename
- Storage site
- Specification group
Retain product and quantity differences
For each row, record manufacturer, part number, designation, metal, size, conductor count, marked voltage, and continuous footage when known. State whether the footage is measured, documented, or estimated. Group reels only after those fields match; even then, keep each reel’s quantity and its storage site visible.
Do not convert several short pieces into one continuous run or use one reel photo as documentation for a different specification. A large total may be helpful as a summary, but it cannot replace the rows that show what the total contains. Items whose identity or footage is incomplete should have their own unknown fields and photo references.
- Manufacturer and part number
- Designation, metal, size, count, and voltage
- Per-reel footage and basis
- Condition by individual row
Keep site access and release groups separate
A warehouse, plant, and yard can have different access limits, loading equipment, and people who control release. Use a release-authority field for each site and state whether the material is being presented as one group or as defined site groups. If that decision is not settled, mark the grouping and authority as pending rather than implying that every item can be released together.
The fictional example is deliberately simple: BL-DAV-01 at Site A has one reel with 500 feet documented, while BL-DAV-02 at Site B has one reel with 90 feet estimated. It is not a purchased lot. The example shows why the same product label does not erase a difference in site, quantity basis, or release contact.
- Site or facility type
- Loading limits
- Site restrictions
- Release authority and intended lot grouping
Correct the grand-total error
The error to avoid is using one grand-total footage number for reels at different sites. Replace it with one row per reel or continuous piece, preserve the site grouping, and make photo-to-line matching auditable. If the original total included unknown footage, do not distribute that uncertainty across the known rows; preserve it as an unknown on the affected reel.
The Iowa Economic Development Authority lists the Eastern Iowa Industrial Center as a 346.1-acre certified site with 12.0 available acres, light-industrial zoning and a location on Interstate 80. That is documented industrial-area context, not proof that a seller’s lot is at the site or that different sites can be treated as one load. The practical lesson is to record the actual location, access limits, and release authority per group.
- One row per reel or continuous piece
- Photo-to-line match checked
- Unknown footage not absorbed into total
- Actual site details per group
Send a controlled inventory package
Email the spreadsheet, matching images, site grouping, and contact information to saleselectricalbuyers@gmail.com. A useful submission includes the material record and the operational record together: what each reel is, where it is stored, who can release it, and what access limits apply. Do not assume that a combined list settles how separate sites will be handled.
This workflow is intentionally different from a surplus-balance reconciliation. The surplus page asks whether stock is currently available. This bulk-lot page assumes the seller must make a mixed, potentially multisite record auditable once the inventory is being presented for a buying review.
- Spreadsheet file named with inventory date
- Photo folder uses matching IDs
- Site contacts and access notes
- Unknowns and pending authorizations retained
