Build one reconcilable record for every reel
A large total can conceal different part numbers, conditions, continuous lengths, and locations. Assign each reel or piece a stable ID, then use it in the inventory, photo filenames, and supporting records. Group only reels with the same documented product and condition; otherwise preserve separate rows so a reader can compare the actual items offered.
For every row, record manufacturer or part number when readable, full designation, reel count, footage per reel, and the basis of each quantity. Measured, documented, and estimated footage are not interchangeable. A grand total can be added as a summary, but it should not replace the reel-level information that makes the total meaningful.
- Use one row per reel or genuinely identical documented group.
- Match the row ID to each tag, jacket, condition, and overview photo.
- Keep reel count, footage per reel, and quantity basis in separate columns.
Split the lot by site, condition, and access
After the reel records are built, add the actual storage ZIP, condition, dimensions or known weight basis, access constraints, and available loading information. Reels at different locations should remain separate even when they share a part number. A site distinction matters because a product record does not describe a gate rule, dock constraint, or the authority that controls that specific stock.
The likely mistake is one grand total for two sites, one favorable reel photo used for unlike products, and no release contact. Correct it by making the differences visible: one row and photo set per reel or identical group, one site field, and one release status. Unknown access or handling details should be written as unknown rather than left to implication.
- Add actual storage ZIP rather than a civic or mailing address.
- Describe access and equipment as available facts, not handling commitments.
- Keep unused, partial, and cable no longer in service in distinct condition groups.
Make the release chain part of the inventory
For every offered group, identify the owner, authorized releaser, approval status, and whether the group is offered with other lines or separately. A person who can provide a site address may not be authorized to transfer the material. If approval is pending, say that in the same row rather than treating the reel as fully available.
This release record is the distinctive task of a multi-reel package. It keeps a buyer from confusing a physical inventory count with a completed release decision. Transport, inspection, and other terms remain specific to the actual reviewed material and are not established by a spreadsheet alone.
- Use separate fields for owner, authorized releaser, approval status, and lot grouping.
- State a seller timetable only when it is known; do not substitute an assumed collection date.
- Preserve pending approval as a visible inventory fact.
Use a fictional package row to find omissions
Illustrative inventory example—not a purchased lot: BL-KS-01 is a documented 500 ft reel at Site A with a matching tag photo and authorization recorded. BL-KS-02 is a 90 ft estimated reel at Site B with its own photo, part-number field unknown, and approval pending. The two lines are not presented as one uniform product or one release condition.
A real worksheet can follow this structure: line or reel ID, product marking, photo references, reel count, per-reel footage and basis, condition, storage ZIP, access, dimensions or weight basis, owner, authorized releaser, approval status, and lot grouping. Attach records by ID so one file cannot accidentally stand in for a different reel.
- Example line A: documented footage and recorded authorization.
- Example line B: estimated footage, unknown part number, approval pending.
- Keep photo filenames specific to the individual line.
Do not treat a public address as storage evidence
The Osceola County Economic Development Department lists its address as 1 Courthouse Square, Suite 4400, Kissimmee, Florida 34741.
That published civic address is not a cable-storage address, release contact, or handling location. For a multi-reel inquiry, the seller should provide the actual storage ZIP and the correct releaser for each offered group. This distinction is practical because public contact information cannot reconcile a physical inventory package.
- Use the real storage record for every reel group.
- Keep public organization addresses out of the lot-location field unless they are the actual storage site.
