Why line-level records matter for multi-site lots
Large industrial inventories often combine different specifications, reel lengths and storage sites under a single total. That single grand-total figure obscures important differences a buyer or reviewer needs to evaluate: manufacturer or part number, conductor metal, actual continuous length per reel, site-specific access and who can authorize release. For multi-site lots in the Tulsa area, preserving that line-level identity keeps logistics and compliance questions separated instead of buried under a single label.
When you provide one row per reel or continuous piece, reviewers can trace every quantity back to a photograph, a tag and a document. That prevents the mistake identified in the brief — where a single grand-total footage figure and a shipping label hide different reel lengths, locations and release authorities — and makes negotiation and scheduling practical.
The Oklahoma Department of Commerce describes the Port of Catoosa as the head of navigation for the McClellan-Kerr Arkansas River Navigation System and reports a 500-acre waterfront terminal area plus more than 1,500 acres of general industrial area. That is context for retaining site and handling fields on a large industrial inventory; it does not mean a port will accept the cable or that transport has been arranged.
- Avoid a single aggregate footage figure when reels differ by size, product or site.
- Maintain evidence that ties each line to photographs and documents.
- Label which site holds each reel and who is authorized to release it.
Step 1 — Assign stable line references
Give every reel or genuinely identical group a stable reference that appears in your spreadsheet, each photograph filename and any supporting documents. Use an ID format that includes site shorthand and a sequence, for example BL-TUL-A01. Record whether a line is a single continuous reel or part of a matching group and include the matching-group rule used to group identical reels.
Required evidence fields for this step are line/reel ID, photo filename, document filename and the matching-group rule. If some reels are undocumented, mark their lengths as estimated and flag the estimation method so reviewers know how to treat that line.
- Include the line/reel ID on the physical tag (photo) and in the spreadsheet.
- Attach photo filenames next to each line in the list.
- State grouping rules for identical reels (same part number, same length, same condition).
Step 2 — Preserve product differences
Record manufacturer, part number, full designation, conductor metal, size/count, rating and each per-reel continuous length. Do not collapse unlike reels into a single total even if they share a general product family. The required evidence fields here are manufacturer/part number, designation, metal, size/count, rating and per-reel length.
If a reel’s per-reel length is unknown, mark it as estimated, document how the estimate was made (tag, serial, drum markings, tape measure), and include that note as part of the record. This preserves transparency and prevents mismatched expectations during review.
- List full designation and part numbers next to each line ID.
- Note conductor metal and size/count explicitly for each reel.
- Flag estimated lengths and describe the estimation method.
Step 3 — Group by actual site and release authority
Separate Tulsa-area storage locations and identify condition, access limits and the party authorized to release each group. Include site address or ZIP and any access restrictions. The required evidence fields are site address or ZIP, condition, access restrictions, release contact and release authority.
Make release authority explicit for each site grouping. If a site has its own authorized release contact, record the person or department and the documentation that establishes their authority. If the release authority is unknown, flag that line and record who to contact to confirm. This prevents the common mistake where one shipping label hides different release authorities.
- Create separate site groups in the spreadsheet with the site address or ZIP.
- Document any access or staging limits for each site.
- Name the release contact and the document that verifies their authority.
Step 4 — Add handling and loading evidence
Report reel dimensions, gross or net weight basis, available loading resources and a seller timetable as facts to discuss — not as a booked transport plan. Provide dimensions and a weight basis (gross loaded-reel estimate or net conductor weight if known), loading equipment available at the site and any staging limits. Required evidence fields include dimensions, weight basis, loading equipment, staging limits and seller timetable.
If you don’t know exact weights, provide consistent gross estimates and state the basis (visual estimate, label, scale reading). If loading equipment is limited at a site, record whether a forklift with a particular capacity or a crane is available and any staging constraints that affect loading times or access.
- State dimensions and whether the weight is gross or net estimate.
- List loading equipment that will be present or required for discussion.
- Provide a realistic seller timetable for making reels available for inspection or release.
Handling incomplete or unknown inventory details
Be honest about unknowns. If a length, weight or release authority cannot be confirmed immediately, mark it as estimated or unknown and include the method you used to reach that estimate. Use the seller timetable field to say when you will confirm missing evidence. Unknowns should not be collapsed into a single grand total; instead they should be labeled so a reviewer can prioritize verification steps.
For example, mark a reel as 'estimated 90 ft; measurement by tape, photo dated 2025-03-01' or 'release authority pending: site supervisor to confirm by 2025-03-05'. Those concrete follow-up commitments reduce ambiguity and reflect the resolution: use one row per reel and label every quantity and handling field by its evidence basis.
- Label unknowns as 'estimated' or 'pending' and document the estimation method.
- Commit to a clear date or step in the seller timetable to confirm missing fields.
- Do not aggregate unknowns into a single footage total; keep one row per reel.
