Make one stable inventory line for each reel or piece
Use one line or reel ID for each reel or continuous piece, and repeat that identifier in the spreadsheet, photo filenames, documents, and site notes. Record manufacturer, part number, cable designation, and the material fields visible on the item. Group reels only when the specification and condition record genuinely match.
This record solves a bulk-lot problem that a total footage figure cannot: another reviewer can trace each item from a photo to its product description and location. Unknown products may remain on the list, but they should have their own references and unknown fields rather than being absorbed into a generic total.
- Use a stable line or reel ID, manufacturer, part number, designation, and photo filename on every row.
- Keep unknown material on a separately identified line rather than assigning a guessed specification.
Preserve per-reel footage and condition differences
Record continuous footage, reel count, and whether the figure is measured, documented, or estimated for each line. Keep identified stock, previously used material, and recovery-only pieces in separate condition categories. A grand total can summarize the list, but it cannot replace the line-level quantity and condition evidence.
Use a clear weight basis where any weight is provided. Gross, net, cable-only, loaded-reel, and estimated weights describe different things. Stating the basis prevents a heavy reel or mixed line from being misread as a material-content statement.
- Record continuous footage, reel count, quantity basis, condition category, and weight basis per line.
- Do not merge different continuous lengths merely to create a larger lot total.
Attach each row to the correct storage site
Keep storage site or ZIP, access restrictions, available loading information, dimensions, and storage condition with the rows for that location. Do not apply one warehouse description to reels split across yards, facilities, or project storage areas. Site information is part of the evidence map, not a statement that movement has been arranged.
Sugar Land is described by its official economic-development office as 22 miles southwest of downtown Houston and the Texas Medical Center, with access via U.S. 59, Highway 6, U.S. 90A and the Grand Parkway. That is useful only as a prompt to report the actual site entrance and access limits for a particular record; it does not establish a route, a trucking commitment, or an available lot.
- Include site or ZIP, access restrictions, loading information, dimensions, and storage condition on the relevant rows.
- State an unknown location or handling detail as pending instead of applying another site’s facts.
Separate offered groups from release authority
State which line items are being offered together, the owner, the release authority at each site, and any pending approval. A multi-site list can be one purchasing inquiry while still retaining different release records. Do not mark a group ready simply because one site has an approval if another site remains unresolved.
A requested timetable is useful seller context, but it is not a movement booking. Trucker arrangements, access, and other lot terms are addressed only after the actual inventory and release facts are reviewed.
- Keep offered group, owner, release authority, requested timetable, and pending approval on the relevant site rows.
- Identify a separate release contact for a second site when applicable.
Repair the one-total and one-photo mistake
The mistake is using one grand-total footage figure and one warehouse photo for reels with different specifications, conditions, or sites. The resolution is a row-per-reel inventory, photo filenames that repeat the row ID, and an explicit site and release record for every line. This makes incomplete rows visible without pretending they are complete.
Illustrative fictional record — not a purchased lot: SL-BL-01; example matching product; 500 ft documented; Site A; release approved. SL-BL-02; same product; 90 ft estimated; Site B; owner confirmation pending; dimensions and loading information to be documented. The two rows demonstrate why a combined total would hide a decision-critical difference.
