Create a reference that survives every handoff
Assign one stable line or reel ID and use it in the inventory, photo filenames, and document names. Record the manufacturer, part number, full specification, reel count, continuous length per reel, quantity basis, and condition under that ID. Identical products may be grouped only if the individual lengths and condition differences remain visible.
Hartford’s Capital Improvement Plan is a multi-year plan for capital needs benefiting residents, with proposals from multiple city departments and review by staff, the Mayor, Council and public comment. This planning fact is limited city context; it does not identify a seller’s material, site, or release authority.
- Line or reel ID used in each filename and document.
- Manufacturer, part number, specification, and reel count.
- Length per reel with measured, documented, or estimated basis.
Separate sites before you total the lot
Create a separate site field for every warehouse, yard, or project location. For each site, list the release authority, access restrictions, available loading resources, and which reel IDs are stored there. A shared contact does not make locations interchangeable: access, availability, and condition can differ from one site to another.
This division is useful even when the material will be offered as one lot. It allows the proposed grouping to remain clear without concealing which rows are subject to a different authorization or a different loading constraint.
- Storage location and reel IDs at that location.
- Release authority and any pending status.
- Access limits and actual loading resources by site.
Preserve individual quantities and evidence
A grand total can hide a short partial reel, a condition difference, or an estimated quantity. Keep one row per reel or continuous piece, then add a grouping column if certain rows are offered together. Match the tag, jacket-print, overview, and condition photos to the same reference rather than using one representative photo for every location.
For large reels, provide available dimensions and state whether any weight is gross, net, documented, estimated, or unknown. These fields support a practical review without converting a warehouse total into claims about the contents of each reel.
- Photo filenames beginning with the matching line or reel ID.
- Condition and footage retained per reel, not only by group.
- Dimensions and stated weight basis for large reels when available.
Use an explicit row for incomplete information
Unknown authority, unknown weight basis, or an estimated balance should remain visible in the same record as the reel and site. That lets a seller correct the particular gap instead of reopening the entire lot. It also prevents a line stored at one location from being assumed releasable because a different location has complete documentation.
Illustrative fictional records: BL-HFD-A01 | matching product recorded | 500 ft documented | Site A; BL-HFD-B02 | same product | 90 ft estimated | Site B; release authority unknown; gross weight basis unknown. They are fictional formatting examples, not purchased lots. The common mistake is a grand footage total with one photo; resolve it with row-level references, site separation, and matched evidence.
- Unknown values labeled in the affected row.
- Proposed lot grouping separated from physical storage site.
- One representative photo never substitutes for unmatched reels.
