Why one-row grand totals fail
A single grand-total footage figure can hide critical differences: reel lengths, partial reels, different specifications and different release authorities. That ambiguity prevents a reviewer from confirming identity and access for each piece. For multisite closeouts, totals are useful only as a summary; every reel or continuous piece needs its own ground-level line so the lot can be reconciled to photos and documents.
Follow the seller problem and resolution: preserve one row per reel or continuous piece, keep site grouping explicit, and attach photo and document references that map directly to each line.
- Totals supplement, do not replace, per-reel lines
- Every line must point to photo filenames and document references
- Site grouping must remain visible even for identical specifications
Step 1 — Assign stable references
Give each reel or truly identical group a stable reference used consistently across the spreadsheet, photos and supporting documents. Use the same reference in the label, in photo filenames, and in any supporting paperwork so a reviewer can match records to images and to the physical reel.
Required evidence fields for this step: reel/line reference, photo filenames, document references.
- Create short opaque references (example: BL-T-07A) and use them everywhere
- Include the reference in each photo filename (example: BL-T-07A_front.jpg)
- List the document reference that shows origin, purchase order, or inventory record
Step 2 — Retain per-reel quantities and bases
Record specification, reel count and continuous length for every reel; keep measured, documented and estimated bases distinct. A measured length or a documented manufacturer length is more reliable than an estimated footage figure; when an estimate is used, mark it explicitly in the quantity basis field.
Required evidence fields for this step: manufacturer/part number, designation, reel count, length per reel, quantity basis.
- Use one spreadsheet row per reel or continuous piece with fields for designation and manufacturer/part number
- Record length per reel and mark whether it is documented, measured, or estimated
- Keep partial reels as separate lines with their condition described
Step 3 — Group by real location and preserve release authority
Keep storage location, condition and release contact visible even when product specifications match. If identical reels exist at separate sites, list them on separate rows and show the associated storage site, condition and release authority. This prevents confusion over who can approve release, where the reel is located, and what loading resources may be required.
Required evidence fields for this step: storage site, condition, release authority, ownership.
- List the physical site name and descriptive location information for each reel row
- Note ownership and whether release authority is known or unknown
- Describe condition succinctly (uninstalled, partial reel, packaging damaged) and link to the matching photo filenames
Step 4 — Describe practical access without booking movement
Provide address/ZIP privately through the inquiry channel, and include access restrictions, loading resources and the requested timetable. Do not use the checklist as a pickup order; this information is to allow reviewers to assess feasibility and to flag access constraints before any movement is discussed. Required evidence fields: location, access limits, loading resources, requested timetable.
If details are unknown or incomplete, mark them clearly in the spreadsheet and attach a contact for follow-up so reviewers know where the gaps are and who can confirm access or loading equipment.
- Indicate truck access limitations, gate hours, liftgate or forklift availability as separate evidence fields
- Provide a requested timetable window rather than a commitment
- When in doubt, state 'approval status unknown' and provide the release contact for confirmation
Illustrative record and how to use it
Use the illustrative example exactly as a template to create a reconciled spreadsheet. The example demonstrates two distinct reels with identical product designation but different sites, conditions and release contacts; totals are supplemental.
Treat the example as a record structure, not a purchased lot. The example fields are: line 1 — BL-T-07A; matching product; Site A; 1 reel, 500 ft documented; line 2 — BL-T-07B; same product; Site B; 1 reel, 90 ft estimated; condition — A uninstalled; B partial reel with damaged packaging; release — different release contacts; approval status unknown.
- Preserve the separate lines and photo references when you create your file
- Use totals only to summarize; do not collapse per-reel detail into a single ambiguous figure
Local context is not lot evidence
Adams County says its capital-improvement team supports roadway, bridge, traffic and drainage projects from concept through delivery, and that RTD serves the Denver region including Adams County.
This is regional movement-planning context only; it does not identify inventory, guarantee transport, or establish the terms for any multi-site lot.
- Keep local context separate from the reel or line-item evidence.
- Provide the actual storage, release and access facts for the offered inventory.
