Give every reel a reference before building totals
A grand-total footage figure cannot show which reel is at which site, whether it is a full reel or a cut length, or which photograph documents it. Assign a stable line or reel ID to every reel or continuous piece, then use that ID in the spreadsheet, photo filename, and site list. Record manufacturer or part number, designation, continuous length, and quantity basis on the same line.
This is different from a project-order reconciliation: the first concern here is not what an old order says, but whether each physical item can be located and handled as a distinct record. Matching specifications can be grouped for description, but their individual location and length should remain visible.
- Use a reel ID consistently across inventory, photographs, and site notes.
- Record designation, continuous length, and quantity basis for each physical item.
- Keep full reels, partial reels, and cut lengths separate from any lot total.
Group records by the real storage site
Create a site label for each warehouse, yard, or river-adjacent location and attach it to every reel row. State whether the inventory is presented as defined site lots or a proposed combined lot. Keep the address or clear location description, the site contact, and the release-authority role alongside that group rather than relying on one generic contact for all locations.
The Port identifies the Allegheny, Monongahela and Ohio rivers and says the Ohio forms where the Allegheny and Monongahela meet downtown Pittsburgh.
This geographic fact is useful only as limited context for accurate site grouping. It does not establish a Port relationship, a route, a river shipment, or a particular seller location. The actual site description, access limits, and authorization record still need to come from the seller.
- Use a separate site label for each warehouse, yard, or river-adjacent location.
- State whether reels are offered as defined site lots or one combined lot.
- Attach a site contact and release-authority role to each group.
Separate gross reel weight from cable quantity
For each reel, record flange diameter, flange width, and the basis of any weight. Gross loaded-reel weight includes the reel and may not equal cable-only weight; if the basis is unknown, say unknown. Do not apply a single gross figure to inventory stored at different sites or use one reel’s measurement to describe the group.
Use continuous footage and the quantity basis with the weight field. For example, a documented 500-foot reel at Site A and an estimated 90-foot reel at Site B remain different records even if the products look similar. This resolves the common mistake of treating multiple locations as one undefined quantity and one handling profile.
- Record diameter and flange width per reel when available.
- Label weight gross loaded-reel, cable-only, estimated, or unknown.
- Keep documented and estimated footage attached to their individual site rows.
Describe access and release limits by site
List the loading equipment the seller knows is available at each site, plus clearance, gate, escort, access-hour, or other constraints that can affect handling. Identify the person or role that can authorize release there. Do not assume that a site with a forklift has capacity for every reel, or that authorization at one yard applies to another location.
When a site fact is missing, mark it on the affected reel row and provide the site contact who may clarify it. The workable resolution is not to hide the gap in a consolidated total; it is to preserve a site-specific unknown and request the relevant factual record during the purchasing discussion.
- List known loading equipment and the limits that apply at that site.
- Record clearance, gate, escort, and access-hour restrictions when known.
- Identify release authority separately for every storage location.
Worked fictional multi-site record
This fictional inventory record demonstrates a mixed-evidence multi-site list. It is not a purchased lot, a statement of available local inventory, or a commitment to move material. The example deliberately keeps an unknown gross weight and an unknown Site B release authority visible.
For a real inquiry, replace the sample labels with the seller’s own site records and make a separate row for every reel or continuous piece. If conductor metal, loading equipment, or release authority has not been confirmed, leave it unknown instead of inheriting a value from another site.
- Reference: BL-PGH-01 / BL-PGH-02
- Product: matching product recorded; conductor metal confirmed on BL-PGH-01 only.
- Quantity: 500 ft documented at Site A; 90 ft estimated at Site B.
- Weight: gross loaded-reel weight unknown.
- Access: Site B loading equipment and release authority unknown.
