Assign IDs that survive the whole review
Give every reel or continuous piece a stable ID before making a grand total. Use the same ID in the spreadsheet, photo filename, tag image, and storage-site grouping. Even drums with the same manufacturer part number need individual references when their lengths, condition, or site access differ.
A label that cannot be read should become an unknown line with its own photographs, not a guessed part number. The goal is a map from a claimed quantity to a specific physical item, so a reviewer can see where the record is strong and where it needs more evidence.
- Line or reel ID
- Manufacturer and part number when readable
- Full designation
- Photo references that match the line
Keep per-reel length separate from the total
Record feet per reel or continuous piece and state whether the number is measured, documented, or estimated. A total of 1,000 feet on five reels does not tell a buyer whether it is five usable lengths or one long length plus four short remnants. Preserve the individual quantities before showing any summary.
Include condition in the same row. If one reel has damaged packaging or a missing tag, do not let the condition of a cleaner reel stand in for it. This protects the integrity of the lot record without promising that every item will be treated the same.
- Reel count
- Feet per reel
- Measured, documented, or estimated basis
- Visible condition
Map location, release, and loading facts separately
Group the rows by their actual storage site and list the authorized release contact, reel dimensions, gross-weight basis, and known loading access. A site description is useful only when it corresponds to the reels stored there. Do not use a single contact or a single loading note for a different location unless the seller has confirmed it applies.
If a contact, weight basis, or loading detail is unknown, write unknown. That is more useful than assuming equipment is available or that a release authority covers all sites. The page concerns factual coordination; transport, timing, and commercial terms remain lot-specific discussions.
- Storage location
- Release authority
- Reel dimensions and gross-weight basis
- Known loading access or explicit unknown
Correct the grand-total mistake with a site map
The common error is one total footage number that hides different specifications and locations. Resolve it by keeping one row per reel or continuous piece, then add a site grouping that lists the IDs at that location. A seller can still submit one inquiry, but the evidence remains usable at the item level.
For example, do not combine an estimated 90-foot partial reel from one storage site with a documented 500-foot reel from another and call both a single 590-foot line. Their quantity basis, photos, and release details remain separate even if the product designation later proves to match.
Show an illustrative—not purchased—multi-site record
A fictional format could list Site A, BL-BIL-01, matching product, 500 feet documented; Site B, BL-BIL-02, same product, 90 feet estimated; and access, loading equipment and authorized contact unknown. It makes the unresolved logistics visible without pretending it describes a real Billings lot.
When a seller lacks a label or access note, add a short missing-evidence field rather than inserting a workaround. The next task is then clear: obtain the tag photo, confirm the contact, or record the site constraint against the relevant reel.
Keep public-works context within its evidence scope
Billings Public Works publishes official utility, construction-project, transportation and water-related service information, including a 2025 water consumer-confidence report and construction notices.
That fact supports a limited infrastructure-related documentation context only. It does not say that a public project has cable available, identify a local lot, or establish any purchase arrangement. The seller’s own line-item records remain the source for the material and location.
