Give every reel or true match a stable reference
Assign a line or reel reference that appears in the inventory file, photo filenames and supporting records. Use one line per reel or continuous piece unless a group is truly identical in product, quantity basis, condition and location. This creates a practical map of the lot rather than a collection of unrelated photographs.
A common inventory mistake is using one grand total and a representative image for material stored in several places. That hides shorter pieces, changed condition and location-specific release issues. A stable reference makes every difference available for review without claiming that the whole lot is uniform.
- Line or reel reference repeated in the spreadsheet, photo filenames and documents
- One row per reel or continuous piece unless the group is genuinely identical
- A grouping rule that states why items can share a line
Keep specification differences in their own rows
For each line, copy the manufacturer, part number, designation, conductor metal, size, conductor count and marked voltage when known. Do not merge a different construction into a nearby line merely because the reels look alike or are stored in the same building. If a marking cannot be read, make that uncertainty part of the row.
Add reel count, continuous footage per reel or piece, quantity basis, dimensions and weight basis where available. Keep gross, net and unknown weight categories separate so a loaded reel or packaging is not represented as cable-only weight.
- Manufacturer, part number, designation, metal, size, conductor count and voltage
- Reel count and continuous footage per reel or piece with quantity basis
- Dimensions and gross, net or unknown weight basis when available
Group the list by the real storage location
Create separate site groups for warehouses, yards and project sites, even when the product designation matches. Each group should identify current condition, the owner or contact, and the person or role that can authorize release. A site label is not a substitute for a release contact, and one contact should not be treated as authority for material stored elsewhere.
The focused decision here is whether every line can remain linked to its physical site. It differs from a single project-overrun balance: the core problem is preserving location and evidence separation across a mixed inquiry, not reconciling one project’s purchase order.
- Storage site, condition and site-specific contact
- Owner or release authority for the relevant group
- Separate rows when identical-looking material has different locations or condition
Record access facts and unknowns without assumptions
For each site, document access limits, gate or appointment requirements, available loading equipment and the seller’s stated timetable. These are inventory facts that help frame a later handling discussion; they do not establish an agreed transport arrangement. Keep a missing detail visible instead of copying it from another site.
When an item lacks a document, quantity or release contact, keep its stable reference and state what is unknown and why. A partial inventory can still be useful if the source and uncertainty are clear. Do not inflate totals or group unknown material with documented reels just to simplify the list.
- Access limits, appointment requirement and known loading equipment by site
- Seller timetable stated as a site fact, not a transport promise
- Unknown quantity, document or release field carried on the applicable line
Kennewick context and a fictional multi-site record
The Port of Kennewick says its mission supports new business, industry and jobs and includes roads, rail, airport and navigation improvements. That is limited local context for recording site and access information; it does not identify Port-held material, prove a cable project or establish a purchase history.
A fictional two-line record can keep the boundary clear: BL-KNW-01 is one documented 500 ft reel at Site A; BL-KNW-02 is one estimated 90 ft reel at Site B. Each line needs its own condition photo and release contact. The records are illustrative only and are not a purchased lot.
- Fictional line BL-KNW-01: one reel, 500 ft documented, Site A
- Fictional line BL-KNW-02: one reel, 90 ft estimated, Site B
- Condition photos and release contacts remain line- and site-specific
