Create stable line IDs before grouping the lot
Assign one ID to every reel or continuous piece and reuse it in the inventory, photo filenames, and supporting records. Add manufacturer, part number, cable designation, and the actual specification where known. A stable ID lets another reviewer trace one record from the spreadsheet to the physical material.
The City says Clear Lake needs phased wastewater, stormwater, electrical and water infrastructure extensions; Phase 1 is described as serving 340 acres of industrial land and 50 acres of Bethel School District land. The statement supplies limited city context for a seller organizing construction-related or industrial inventory; it does not identify cable at the project or imply that material is offered.
- Use one reel or piece ID per inventory row.
- Repeat that ID in photo filenames and document references.
- Mark missing product details as unknown rather than collapsing them into a grand total.
Keep quantity evidence at the reel level
For each row, record reel count, per-reel continuous length, and the quantity basis: measured, documented, or estimated. Preserve specification and condition even when several reels look alike. A thousand feet split across many short pieces is not the same record as one continuous thousand-foot reel.
If products are genuinely identical, a group can still show each reel reference and length. Do not let grouping erase a short partial reel, different jacket marking, or an unknown quantity basis.
- State the continuous length for each reel.
- Keep reel count separate from aggregate footage.
- Retain a measured, documented, or estimated label.
Separate storage sites and condition histories
Group rows by actual warehouse, yard, or project location, then state whether material is uninstalled, previously used, or recovery-only. Add storage history and visible damage to the specific reel row or defined group. This gives the lot a workable map without pretending every reel has the same history.
Where a site or condition field is unknown, record the gap and a contact able to clarify it. Do not substitute a wide inventory photo for a reel-level condition or location record.
- Record actual storage site by row or defined group.
- Keep condition and storage history visible.
- State visible damage only for the reel or group shown.
Document release and loading as open facts
Identify the release authority, available loading resources, access restrictions, dimensions or weight basis, and any line that remains reserved. A bulk list can include several contacts, provided each contact is attached to the site or group they can address.
These seller facts support a practical review of the defined lot. They do not establish a collection method, timing, or commercial terms. If the authority or equipment is unknown, use an explicit unknown field.
- State release authority for each site or group.
- List available loading resources only when known.
- Flag reserved or unavailable lines separately.
Define the lot with a fictional two-site example
Illustrative record—not a purchased lot: BL-EUG-01; one matching reel; 500 ft documented; Site A. BL-EUG-02; same product; 90 ft estimated; Site B. Site A release authorized; Site B approval unknown; gross weight basis not documented. The example keeps two pieces from becoming one invented total.
The common mistake is a single grand-total footage figure that hides different reels and sites. Resolve it by using one row per reel or continuous piece, retaining site, condition, specification, and approval differences even when the lot will later be discussed as a group.
- Example field: 500 ft documented at Site A.
- Example field: 90 ft estimated at Site B.
- Example field: Site B approval unknown.
