Why one-row-per-reel matters
A single headline footage total often hides critical differences: reel lengths versus continuous pieces, conductor metal, marked voltage and whether quantities are documented or estimated. When multiple storage sites or yards are involved, reviewers cannot rely on a grand total to locate a specific reel or confirm condition.
Following the 'Build one row per reel or continuous piece' step ensures each line has a stable ID and the essential technical fields reviewers use to match photos, weight basis and release authority.
Michigan EGLE reports a $32 million FY2023 BWL Drinking Water State Revolving Fund award supporting a new water tower, treatment-plant upgrades, new wells and water-main replacement in Lansing-area service districts. That is limited local context for records divided by work scope or location; it does not identify an available lot or replace a reel-by-reel record.
- Assign a stable line/reel ID for every reel or continuous run.
- Record manufacturer/part number, designation, conductor metal and size, and marked voltage.
- Include length per reel and indicate whether footage is measured or estimated.
Group by physical location and preserve site differences
Separate entries by site to preserve storage history, access rules and loading limitations. A reel in an indoor warehouse with forklift access may be reviewable very differently than a reel in an open yard with limited access hours or different loading equipment.
Use the 'Group by physical location' step to attach a site name/identifier, storage history notes, any access restrictions and a site-specific condition summary to every line.
- List site name/identifier and precise location for each line.
- Document storage history (indoors, outdoors, covered, exposed) per site.
- Note access restrictions or required contacts required for inspection or pickup.
Make photos and files auditable and tied to lines
Photos and documents are only useful when they can be tied back to the line ID. Filenames and document links should embed the line/reel ID and show tag printing, jacket markings, an overview of the reel, and any damage closeups.
The 'Make photos and files auditable' instruction requires a tag photo, jacket photo, overview photo and damage photo (if present) for each line, plus document links for certificates, project manifests or delivery records where available.
- Use line IDs in filenames and photo metadata where possible.
- Include at least one overview and one closeup per reel; mark any inconsistencies.
- Link to paperwork that supports the recorded lengths and release authority.
Capture release and loading facts before discussing terms
Identify who can authorize sale and record loading equipment, dimensions and weight basis. These facts let a reviewer judge whether a specific reel is serviceable for transport and whether additional arrangements are needed to access or load the material.
The 'Add release and loading facts' step asks you to list the release authority, available loading equipment, gross/net/estimated weight and any seller timetable that might affect availability.
- Record named release authority and best contact method for each site.
- Describe available loading equipment (e.g., forklift, crane) and any dimensional limits.
- Provide estimated gross or net weight per reel if scales are not available.
What to do with unknown or incomplete inventory
If a reel's conductor metal, exact footage, or manufacturer markings are unknown, mark those fields explicitly as 'unknown' and indicate how the value was estimated (visual estimate, reel tag partial, project manifest reference). Do not compress unknowns into a single grand footage total; instead flag lines with estimated values and include corresponding photos and a damage or uncertainty photo.
When site-level details are incomplete, leave site-specific fields blank but attach a clear note describing what's missing and the next steps needed to resolve it (on-site measurement, tag re-inspection, or contact confirmation). This transparency permits a reviewer to decide whether to request inspection, accept estimated footage with conditions, or exclude a line from a lot.
- Label estimated values clearly and attach the photo or document that supports the estimate.
- If release authority is unclear, provide the last known contact and an explanation of the uncertainty.
- For mixed-condition lots, indicate which reels are documented and which require inspection.
Illustrative record and common mistake to avoid
Mistake to avoid: sending one grand-total footage figure for a multi-site lot, with photos and release contacts that cannot be matched to individual reels. That prevents transparent review and often stalls any lot discussion.
Illustrative record (example only): BL-LAN-01 and BL-LAN-02 are recorded as separate lines. BL-LAN-01 has a confirmed conductor metal and documented 500 ft, stored in Site A warehouse with a named release contact and forklift access. BL-LAN-02 is an estimated 90 ft reel at Site B yard with a different release contact and open-yard access hours. Photos and load notes are referenced per line. Use this structure when preparing your own records.
- Do not submit a single footage total for multiple sites.
- Supply separate photos and contacts for each line ID.
- Attach a seller timetable and loading notes per site before requesting terms.
