Give each reel a durable inventory reference
Create a short reference for every reel or genuinely identical, co-located group and use it in the spreadsheet, photo filenames and storage entry. Record the factory reel ID if present; if you assign an internal reference, identify it as an internal record rather than a manufacturer number.
Match the reference to manufacturer, part number, cable designation and visible condition. Do not group reels simply because they sit in the same warehouse. Their footage, product markings, condition or quantity basis can differ even when the outside view looks similar.
- Inventory reference and reel ID
- Manufacturer, part number and cable designation
- Photo filenames using the same reference
- Storage site matched to the line
Preserve per-reel quantity and weight basis
Use one row for each continuous piece or reel. Enter footage per reel and identify it as measured, documented or estimated. State full or partial status. When footage is unknown, leave it unknown rather than adding it to a combined total.
Keep gross loaded-reel weight, net or cable-only weight and an estimate in distinct fields. Weight is a handling fact with a stated basis; it should not replace the cable specification or the reel-by-reel footage record.
- Reel count and continuous footage per reel
- Measured, documented or estimated quantity basis
- Full or partial status
- Gross, net or cable-only weight basis
Map separate sites without promising movement
For each location, record an address or private reference, access limits, available loading resources and the person or role able to authorize release. Keep site notes attached to the reel line so one location’s equipment or authority is not assumed for another.
The Port page says facilities serve container, bulk, breakbulk and roll-on/roll-off operations and have direct interstate access to I-95 and I-40 plus daily CSX service. This is only Wilmington logistics context for describing access; it does not prove that a particular reel was port-handled or determine transport terms.
- Site or private location reference
- Access limits
- Available loading resources
- Release authority or pending status
Expose estimates in a fictional worksheet row
A fictional worksheet can show the needed separation: “BL-WI-01; Site A; one matching reel; 500 ft documented; gross loaded-reel weight unknown” and “BL-WI-02; Site B; one similar reel; 90 ft estimated; release authority pending.” These are illustrative entries, not actual lots.
The mistake is a single grand-total footage figure for reels at different sites and with different evidence bases. Correct it by retaining one row per reel, matching photos to that row and leaving pending facts visible for follow-up.
- Fictional row identifiers
- Per-reel footage and basis
- Separate site entries
- Explicit pending or unknown fields
