Make the site key part of every inventory reference
Assign each reel or continuous piece a reference with both a line number and a site key, such as WH1-014 or YD2-007. Use that same reference in the inventory, photo filenames, document folder, and release-contact column. A line that moves between locations should receive an updated location field rather than inheriting a prior site’s access or authority information.
List manufacturer, part number, complete readable designation, condition category, and continuous footage for the specific item. The site key does not replace the product record; it makes it possible to see which product evidence belongs to which location when several groups are later reviewed together.
- Line and site key repeated in every record
- Manufacturer, part number, and complete designation per item
- Continuous footage with measured, documented, estimated, or unknown basis
- Condition category held at the same line level
Use a photo matrix instead of representative images
For each inventory line, name the available tag, jacket, overview, and condition photos. Do not use one attractive reel image as a proxy for an entire warehouse or yard. If a photo is pending, mark it pending on that line; if a jacket marking cannot be read, record unknown rather than importing a neighbor reel’s details.
FDOT lists the S.R. 838/Sunrise Boulevard rehabilitation in Broward County as a 0.80-mile project with an estimated $43.2 million cost, including mechanical and electrical bridge components and LED street-light upgrades. That public project description is local context only and cannot identify the type, ownership, availability, or condition of a cable lot offered for review.
- Tag, jacket, overview, and condition image status for each line
- Photo filenames begin with the matching line and site key
- Pending or unreadable evidence remains visible
- No product field is borrowed from a neighboring reel
Map release authority and access by location
A multi-site lot can have different owners, release contacts, credential rules, storage restrictions, and loading equipment at each location. Put these facts in a site table, then reference the table from every affected line. A valid release contact for one warehouse does not establish authority for a second warehouse or a project storage area.
Record whether approval is documented, pending, unknown, or not required according to the seller’s records. Keep material with pending authority in the matrix but separate it from lines whose release path is recorded. State access limitations and available loading equipment as facts about the site, without turning them into terms for a move.
- Site address or internal location reference
- Release authority and approval status per site
- Access restrictions, credentials, and available loading equipment
- Seller-requested release window separated from approval status
Aggregate only after the evidence survives the join
A grand total is useful only after every row retains its individual footage, product evidence, site key, and release status. Add a summary by specification or site if helpful, but keep the source lines available. Do not turn several short continuous pieces into one long length or merge condition categories just to make the lot appear simpler.
The final package should contain the site-keyed inventory, photo matrix, site table, and a short discrepancy list. The discrepancy list calls out unknown footage, missing photos, unmatched designations, or pending release authority. It gives a reviewer an actionable follow-up list without concealing incomplete parts of a larger lot.
- Summary totals trace back to retained line items
- Continuous lengths remain individual even within a shared specification
- Site-specific release status remains visible in every summary
- Discrepancy list captures unknowns and pending evidence
Worked multi-site matrix example
Illustrative inventory example—not a purchased lot. Line WH1-014 shows 500 feet documented on a reel with tag, jacket, and overview photos; its warehouse release authority is recorded. Line YD2-007 is a different location with 90 feet estimated, a pending jacket photo, and unknown release authority. Both lines may be counted in the working inventory, but only their separate facts describe the lot honestly.
The matrix summary does not report 590 feet as one continuous available run. It reports two distinct pieces with different quantity bases, evidence completeness, and release paths. That is the resolution to the common bulk-lot mistake of submitting a total and a representative photo while hiding multi-site differences.
- WH1-014: 500 ft documented; tag, jacket, and overview photos available
- YD2-007: 90 ft estimated; jacket photo pending
- Warehouse authority: recorded; yard authority: unknown
- Summary: two distinct pieces, not one continuous 590-foot run
