Build a lot map before combining inventory
A multi-site cable lot is not one uniform inventory merely because it appears on one spreadsheet. Start by grouping the list by actual storage site, then assign a stable line or reel ID to every reel and continuous cable piece. Carry that ID into the inventory, photo filenames, storage map, and related documents so that a condition note from one location cannot be mistaken for evidence about another.
For each site group, record the storage location or origin area, the business or person controlling the material, the release contact, and any access or site restriction already known. If a site or authority is not confirmed, leave it pending instead of moving it into a general notes cell.
- Create one stable line or reel ID for each reel or continuous piece.
- Record storage location, origin area, ownership status, release contact, and site restrictions by site group.
- Use the same ID in the spreadsheet, photo filenames, storage map, and document references.
Retain per-reel quantity and condition
Do not use a combined footage figure for reels with different lengths, conditions, or specifications. Each row should show the manufacturer and part number where available, continuous length, full or partial status, condition note, and the quantity basis: measured, documented, estimated, or unknown. A matching-specification group can be named for genuinely identical reels, but it should not erase per-reel lengths or exceptions.
Keep a documented full reel separate from a partial reel with an estimated remainder. Likewise, distinguish an intact reel at one site from a reel with visible jacket damage at another. This makes the bulk package easier to review without treating a total as one continuous cable length.
- List reel count and length per reel rather than only aggregate footage.
- State whether each length is measured, documented, estimated, or unknown.
- Keep full or partial status and visible condition connected to the individual reel.
Add access facts without assuming a move
For each location, note dock or ground access, available handling equipment, trailer constraints, reel dimensions, and whether any weight is documented or estimated. These are planning facts supplied by the seller; they do not establish a transport arrangement. If one warehouse has a dock and another location has unconfirmed access, keep that difference visible rather than reporting “dock access” for the whole lot.
A local logistics context can help explain why a clear site record matters. The Columbus Region also describes a cargo-dedicated airport, foreign-trade-zone access, intermodal terminals, and rail corridors. That fact does not determine how a particular cable lot can be handled, so the actual site access, reel dimensions, and restrictions remain the relevant submission details.
- Record access type, available loading equipment, trailer constraints, reel dimensions, and weight basis for the applicable site.
- Mark unconfirmed access or equipment as unknown or pending confirmation.
- Do not treat regional logistics context as a transport promise for a specific lot.
Send evidence that stays matched
For every line, link the inventory row to a tag image, jacket-marking image, reel overview, and any exception note using the same ID. The overview is useful for condition and location context, but it does not replace readable markings or a quantity basis. Where several reels have the same product designation, retain a separate reference for each physical reel before creating a group summary.
When an image or document is missing, say what is absent and why. A note such as “length estimated; jacket photo pending” is more useful than a blank field because it preserves the open question with the correct reel and site.
- Match inventory file, tag photo, jacket photo, overview photo, and exception notes to the same line ID.
- Use a document or image filename that includes the line or reel ID.
- Describe missing evidence per line instead of assuming one image represents every reel.
Replace the misleading grand total
The characteristic mistake in a multi-site lot is one total footage figure and one warehouse picture for reels that differ by site, length, condition, and release authority. That format makes it impossible to tell which evidence belongs to which piece. The correction is a one-row-per-reel or continuous-piece ledger, grouped by site and accompanied by an explicit access and authority field.
The fictional record below illustrates the format only; it is not a record of a purchased or actual lot. One site has a documented length and dock access, while the other has an estimated length and unconfirmed access. Retaining those differences is more credible than creating a single, polished total.
- Mistake: combining separate sites and reels into one grand-total footage entry.
- Resolution: preserve reel-level rows, site grouping, release contacts, and location-specific access facts.
- Use an exception note wherever a length, site detail, or authority remains unconfirmed.
