Give every reel or matching group a stable line ID
Assign a stable ID to each reel or genuinely matching group, then use that same ID in the spreadsheet, image filenames, and supporting documents. Record whether a group is fully matched, partly matched, or unverified; one warehouse overview cannot identify all the reels it contains.
OCCC publishes 174 total loading-dock slips and 6,227 parking spaces across its buildings, and notes Convention Way was temporarily closed for the expansion project. Those published facts illustrate why actual site access should be recorded rather than presumed; they do not describe access at a seller location or promise transport.
- Use the same line ID on labels, photographs, and documents.
- State matching-spec status as verified, partial, or unknown.
Preserve per-reel construction and quantity
For every line, record manufacturer, part number, construction, conductor metal, size, marked voltage, reel count, continuous footage, and the basis for the footage. Do not turn several short pieces into one continuous length or replace per-reel quantities with a single aggregate figure.
Keep measured, documented, estimated, and unknown values distinct. A matching product name alone does not make reels interchangeable when footage, condition, or storage history differs.
- Keep a separate per-reel footage field.
- Record the source or basis of every quantity.
Map actual sites and condition groups
Group lines by their real storage site and identify condition, storage history, owner, and release status for that site. Two reels with the same product number belong on separate lines if they have different site contacts, condition, or available evidence.
Use a site code when a full address should remain private at the inquiry stage, then state the relevant city or ZIP, access limitations, and the contact who can clarify site rules. Do not assume that a site shown in a photo is authorized to release every listed reel.
- Separate unused stock, cable with prior service history, and recovery-only material.
- Keep site code, owner, release status, and condition on each line.
Describe access and handling facts without assumptions
For each site, list reel dimensions, gross, net, or estimated weight basis, dock or gate limits, available loading equipment, appointment or security rules, and release authority. These facts support a practical buying discussion but do not create a transport commitment.
A gross loaded-reel weight includes more than conductor content. Keep it labeled as gross, state the source of the number, and leave cable or conductor weight unknown when it has not been documented.
- List gate, dock, appointment, and equipment facts only when known.
- Record gross, net, and estimated weights in separate fields.
Fix a grand-total release map
The bad record is one grand-total footage figure and one warehouse image for reels held at different sites with different specifications and different release contacts. A reviewer cannot determine which quantity, condition, or access rule applies to a particular reel.
Illustrative inventory example—not a purchased lot: BL-ORL-01 is a matching product with 500 ft documented at Site A; BL-ORL-02 is the same product with 90 ft estimated at Site B with an appointment noted; BL-ORL-03 has a different jacket designation, 240 ft documented, and release approval pending. This fictional map shows why every line needs its own evidence.
- Keep pending access or approval visible instead of assuming it will be resolved.
- Use one row per reel or continuous piece whenever the evidence differs.
