Build a lot map before combining totals
A bulk inquiry becomes difficult to assess when one total merges unlike reels, cut lengths, and storage sites. Start with a stable reference for each physical reel or a genuinely inseparable group. Use that reference in the inventory worksheet, image filenames, and supporting records so every stated quantity can be traced to an actual item.
Keep product identity beside the reference: manufacturer, part number, complete visible marking, conductor material, size, and rating when known. The decision is not whether every item is fully documented. It is whether the record shows which fields are known for that specific piece and which remain unresolved.
- Assign one stable reference per reel or inseparable group.
- Match the reference to every photo and document filename.
- Do not use a warehouse total as the only inventory reference.
Retain reel-level footage and quantity basis
List continuous footage for every reel or piece and label it measured, documented, estimated, or unknown. A grand total may be useful as a summary, but it cannot replace a reel-level record: several short pieces are not the same inventory as one long continuous length.
A frequent mistake is copying a shipment total after reels were used, split, or moved. Keep the historical total in a separate source field and enter the current balance beside the reel ID. If footage is estimated, describe its basis instead of presenting it as a precise measurement.
- Record reel count and continuous footage per reference.
- Label each footage figure by its evidence basis.
- Separate full reels, partial reels, and cut lengths.
Split the lot by actual storage site
For a split lot, assign each warehouse, yard, or project storage point a site code and repeat it on every relevant row. State the observed storage setting, condition category, and business role that can discuss release. Material at two addresses should not appear as if it were staged together.
Describe site facts rather than presumed handling: gate restrictions, trailer limitations, reel dimensions, documented or unknown weight basis, and equipment visibly available. These details support a later lot discussion, but they do not establish freight, pickup, or timing.
- Use a site code for each physical location.
- State gross, cable-only, net, or unknown for every weight.
- List access limits and observed loading resources by site.
Keep incomplete lines visible and separate
Do not delete a reel because its tag is missing. Create an unknown line with its reference, photographs, observable condition, site code, and the missing fields named plainly. A visible unknown is more useful than assigning the product details of a neighboring reel to it.
When a related document cannot yet be matched, record its filename as unlinked rather than attaching it to a row. That distinction prevents a similar-looking reel or a general warehouse record from becoming false support for a particular quantity or specification.
- Use unknown as a field value instead of an unexplained blank.
- Keep unlinked documents apart from matched reel records.
- Mark release-contact status pending when it is not confirmed.
Check the handoff with a fictional record
Illustrative fictional inventory record—not a purchased lot: BL-LR-01 is a documented 500-foot reel at Site A; BL-LR-02 is a 90-foot estimated reel at Site B. Each has its own reference, photo set, condition note, and release-contact status. A worksheet may total them, but should not imply they are one 590-foot continuous piece.
The specific mistake is presenting aggregate footage and a loaded-reel scale reading as one uniform cable item. The workable resolution is a row for each reel, a stated quantity and weight basis, and separate site and authority fields before the information is sent for buying review.
- Check that every photo filename begins with the reel reference.
- Keep gross loaded-reel weight distinct from conductor weight.
- Leave pending authority visible on the item row.
