Start with locations, not a grand total
Create a site code for every actual storage location, then give each reel or truly identical group its own line reference within that site. Record the site or ZIP, storage area, reel count, continuous footage per reel, and quantity basis. A combined footage total may be useful as a summary, but it should not replace the underlying rows that show which cable is at each site.
Sarasota County's capital-projects department describes responsibility for design and construction of county capital infrastructure and maintains a monthly-updated map of projects under design or construction. That county-area context may help a seller preserve project references or access notes, but it does not establish what cable is stored at a site or that a lot is available.
- Assign a site code and a separate reel or line ID before totaling footage.
- Record storage area, continuous footage per reel, and the quantity basis for each row.
- Use project context as a reference, not as proof of inventory or release.
Keep product identity matched to the physical item
For every row, record manufacturer and part number when available, readable cable designation, condition, and a photo filename that includes the same line or reel ID. Use individual rows for different specifications, footage, or condition even if the reels are stored at the same site. A grand total should never cause a seller to lose the association between a photograph and the cable it documents.
When several reels appear identical, group them only if the seller can support the same product designation, condition, footage per reel, and site. If one of those fields differs, give that reel its own row. This preserves the differences a buyer needs to review rather than concealing them inside a bulk count.
- Match the line or reel ID to the photo filename and product fields.
- Group reels only when specification, condition, per-reel footage, and site match.
- Keep a different product or condition on its own row.
Document access and release site by site
Add a release contact or authorized role to each site group, not just one name at the bottom of a multi-site spreadsheet. Describe the staging area, access restrictions, available loading resources, and known reel dimensions or weight basis for the items at that location. These details should stay linked to the relevant rows because one warehouse's access facts may not apply to another yard.
State whether a weight is documented, gross, net, or estimated, and never turn a loaded-reel figure into a cable-only weight. If dimensions, release authority, or loading information are not yet known, mark the field unknown and identify the next record or contact that can clarify it.
- List the authorized release contact or role for each storage site.
- Record access facts, available equipment, and handling constraints by site.
- Label gross, net, documented, estimated, and unknown weights accurately.
Use a fictional two-site inventory check
Illustrative inventory example—not a purchased lot: line NP-BL-01, Site A, one reel, 500 ft documented, matching product recorded from tag; line NP-BL-02, Site B, one reel, 90 ft estimated, product match pending; condition unconfirmed; separate release contacts required. The two lines remain separate even if a later summary adds their footage.
This layout exposes the information that is often lost in a multi-site submission: which photo belongs to which reel, whether a quantity is estimated, where the item is staged, and who can release it. Unknown information is useful when it is assigned to the right row; it is not a reason to replace the details with one total.
- Keep site, line ID, product status, footage basis, condition, and release information together.
- Use a temporary reel ID when a tag is not yet readable.
- Update the same row when new facts arrive instead of creating an unlinked replacement.
Fix the multi-site total error before requesting review
The specific mistake is applying one grand-total footage figure to multiple specifications, lengths, and storage sites. The resolution is one row per reel or continuous piece, site grouping, matched photo references, and aggregation only after the component rows remain visible. This keeps a mixed commercial lot reviewable without pretending all material is interchangeable.
Email the inventory and photo set to saleselectricalbuyers@gmail.com for a buying review. Include the exact locations, known access limits, and the seller's release contacts. Those facts support discussion of the specific lot but do not create an offer, a transport commitment, or an assumed handling method.
- Repair a grand-total submission by rebuilding the reel-level site rows.
- Retain photo references and footage basis with every corrected row.
- Provide actual site and release facts with the submitted inventory.
