Why per-reel detail matters for large lots
Large lots that span multiple warehouses, yards or units often list one grand total that hides differences in reel length, condition, storage address and release authority. That single-line approach forces reviewers to request clarifying submissions, slows decision cycles and increases the likelihood of missed site or access constraints.
The goal of per-reel detail is not to make a policy statement but to enable precise, auditable matching: a reviewer should be able to point at one spreadsheet row and find a matching photo, a matching document and a matching storage grouping without asking for more data.
The official ONT HUB page says the project includes nine warehouses totaling 4.3 million square feet, ranging from 200,000 to 930,000 square feet each. That specific project is local context for a reel-by-reel record when a seller’s lot spans units; it does not identify any seller property, cable inventory, or buying commitment.
- Assign an inventory reference that appears in the spreadsheet, every related photo filename and each supporting document.
- Record manufacturer, part number, material, size, rating, reel count and footage per reel—do not collapse these into a single aggregate footage field.
- Maintain separate groups for different storage addresses or ZIP codes so availability and release status are clear.
Practical steps to create stable line references
Follow the supplied step checklist: assign one reference per reel or continuous piece and reuse it in the spreadsheet, photos and supporting files. Make the reference persistent—do not change it between documents—and show it on any PDF labeling or inventory photo where the reel is visible.
In the photo filenames, begin with the inventory reference so filenames look like BL-ONT-01_photo01.jpg, BL-ONT-02_photo01.jpg, etc. In supporting documents, include the same reference in the header or a searchable field so an independent reviewer can reconcile records quickly.
- Evidence fields to include with each line: inventory reference, photo filenames, document filenames, reel or piece identity.
- If a piece is continuous cable removed from a reel, treat it the same as a single reel and assign it a reference and per-piece footage.
Recording specification and quantity differences
Record full product data for each reel or continuous piece: manufacturer, part number, designation, conductor metal, AWG or size, voltage or rating, reel count and footage per reel. A single grand-total footage number is insufficient for reconciliation because it masks reels with shorter footage or different condition.
If footage on a reel is estimated rather than measured, mark it clearly as 'estimated' and provide a rationale for the estimate. That preserves honest transparency and signals to reviewers which lines may require inspection or verification prior to release discussions.
- Evidence fields to include: specification, reel count, per-reel length, quantity basis, condition.
- Flag estimated lengths explicitly and attach the method or photo evidence used to estimate.
Group by actual storage site and state release status
Keep items physically grouped by the site where they are stored. If reels are in different warehouses, yards, or fenced units, list each group separately with storage address or ZIP, site grouping label, and a release status field stating whether approval is granted, pending, or restricted.
For each site grouping include an ownership authority or point of contact and any documentation that supports who can authorize release. This avoids the common ambiguity where one contact is listed but actual release authority sits with another party.
- Evidence fields to include: storage address or ZIP, site grouping, release status, ownership authority.
- When release is pending, mark which approvals remain outstanding and what documentation is expected to clear the item for pickup.
Document practical access and loading conditions
State gate, security, appointment rules, dock or loading equipment and a requested timetable. Treat trucking arrangements as a term to confirm; specify whether the site requires appointment windows, whether forklifts or cranes are needed, and whether loading equipment is available on site or must be supplied by the collector.
If appointment requirements or loading equipment availability are unknown, note that explicitly and identify who should be contacted to confirm. That reduces surprises during release and prevents assuming on-site resources that do not exist.
- Evidence fields to include: access restrictions, loading resources, requested timetable, site contact.
- If appointment scheduling is required, provide the range of acceptable dates and the process to request a slot.
How to handle unknown or incomplete inventory
When inventory is incomplete, be explicit: create a row per reel with what is known and use standardized notes for unknowns (for example, 'footage: estimated' or 'forklift availability: unknown'). Do not merge known and unknown reels into a single aggregate entry.
Flag any release or access gaps before scheduling movement. If the owner cannot confirm release authority or access details, mark those rows as 'release pending' or 'access unknown' so potential collectors can make an informed pre-site plan.
- Provide the minimal verifiable facts per reel and highlight unknown attributes rather than hiding them in totals.
- Include contact fields for the person who can confirm missing items so reviewers can request targeted follow-up.
