Give every reel or piece a stable reference
Create one row per reel or continuous piece, even where products look identical. Assign a line or reel ID and repeat it in the spreadsheet, photo filenames, product documents, and site notes. This is the only reliable way to show which tag, cable marking, and condition image belongs to which physical item.
Capture manufacturer or part number, cable designation, metal, size, count, marked voltage, footage per reel, and the basis for the footage. An inventory total can appear as a summary, but it should never replace the individual references that make the total checkable.
- Stable line or reel ID across all records.
- Specification and continuous-footage fields per reel.
- Measured, documented, estimated, or unknown quantity basis.
Match photos and documents to the line
Use filenames that include the inventory reference, such as BL-LAW-01-tag.jpg or BL-LAW-01-overview.jpg. Keep the product record and photo references in the same row. One clear image of an undamaged reel does not document different reels, and a data sheet should not be used for an item whose part number does not match.
Where a photo, document, or marking is missing, identify the gap at the line level. A separate “notes/unknowns” column is better than attaching an unlabeled image to the complete lot. It preserves usable evidence without implying that all reels share the same condition or specification.
- Photo references and document references linked to one line ID.
- A notes/unknowns field for missing images or records.
- No representative image used as proof for an entire mixed lot.
Keep site and condition differences visible
Group rows by actual storage location, then state condition or history, visible damage, weight or dimensions, and site restrictions for each group. A reel in a warehouse may have different access, condition, and release facts from a similar reel in a yard or project storage area. Do not let one grand total hide those distinctions.
Illustrative inventory record—not a purchased lot: BL-LAW-01; Site A, one reel, 500 ft documented; Site B, one reel, 90 ft estimated; matching product recorded; separate site contacts; loading resources unknown. The two reels remain separate even when their product fields match.
- Storage site and condition/history per line or location group.
- Visible damage, weight or dimensions, and site restrictions stated separately.
- Unknown loading resources visibly marked as unknown.
Record authority and access at each site
Identify the release contact and ownership authority for every storage site, along with available loading equipment, gate or escort limits, and the seller’s requested timetable. These details let a buyer understand who can release each group and what access facts still need confirmation.
Do not turn a site description into a commitment about transport, price, payment, pickup, or acceptance. The goal is a truthful line-by-line record that supports a later lot-specific discussion, not a generic logistics promise.
- Release contact and ownership authority by site.
- Loading equipment, gate or escort limits, and requested timetable.
- Unknown access facts named instead of assumed.
Use Lawrence access information proportionately
The city lists highway access from Routes 93 and 495, MBTA commuter rail and active freight lines as Lawrence accessibility resources. That context may help explain why a seller includes actual site access and loading restrictions, but it is not a promise of collection or a statement about any specific bulk lot.
Before submitting, check that every line can be traced to its photos, documents, location, and authority information. If a reel cannot be matched, leave it in a separate unresolved group rather than rolling it into an otherwise documented total.
- Treat city access facts as context, not a transport term.
- Keep unmatched reels out of an asserted fully documented subtotal.
