Assign one stable reference before combining inventory files
Use one line or reel ID for each reel or genuinely identical group. Repeat that reference in the inventory sheet, photo filenames, and any supporting product records. Include manufacturer, part number, and the available product designation so a reviewer can tell whether a group is truly identical or only stored in the same place.
A filename and a spreadsheet row should point to the same material without interpretation. If a record is unavailable, leave its field unknown and retain the reference. The purpose is traceability across a large lot, not a polished aggregate description.
- Line or reel ID
- Manufacturer and part number
- Photo filename and document reference
Preserve per-reel quantity and condition
Record reel count, continuous footage per reel, full or partial status, condition, and whether footage is measured, documented, or estimated. Do not replace the individual entries with a grand total; two reels with the same product can have different remaining lengths and different condition evidence.
When grouping truly identical reels, keep the number of reels and the footage for each reel visible. An estimate remains an estimate even if it is added to documented footage. This task differs from the surplus page because it coordinates the lot across multiple lines and locations, rather than reconciling an old order to its current balance.
- Continuous footage for each reel or piece
- Full or partial status
- Quantity basis and observed condition
Separate actual storage sites and release contacts
Group the inventory by the actual warehouse, yard, or project location rather than using Queen Creek as the only location field. For every site, provide a site contact, release authority, access limits, and ownership information when known. A person who can provide access is not necessarily the person who can authorize release, so those records should not be merged.
If sites have different access hours or equipment, attach those facts to the relevant site group. This lets the seller show the true boundaries of a multi-site lot without implying any particular movement arrangement.
- Storage site and site contact
- Release authority and ownership
- Access limits and available loading equipment
Report dimensions and loading facts as seller information
Large reels are easier to understand when their dimensions and gross, net, or estimated weight basis are recorded per line or site group. State what loading equipment is available and any access restriction the seller already knows. These fields describe the material setting; they do not commit either party to a transport or handling plan.
Illustrative example only—not a purchased or actual Queen Creek lot: BL-QC-01, one matching-product reel, 500 feet documented, Site A; BL-QC-02, same product, 90 feet estimated, Site B; photos named BL-QC-01 and BL-QC-02; release authority and loading resources recorded separately by site. The record keeps the two quantities and locations from becoming one undifferentiated total.
Local development context cannot substitute for lot evidence
The Town's industrial site-selection materials describe 3,500 acres of State Land available for development, sites ranging from 10 to 1,600 acres, and nearly 350,000 square feet of existing speculative space.
That city development description helps explain why site-level location and access fields may matter in a commercial setting. It does not indicate that any particular location has wire or cable, establish a seller’s ownership, or show that a lot is ready for release. The stable line reference, per-reel facts, and site-specific authority remain the evidence for this page.
