Create one reference system for the whole lot
Assign a stable line or reel ID to every reel and continuous piece, then use that same ID in the inventory, document names, and photo filenames. A single grand-total row and one representative image cannot show whether the listed material is actually the same product, at the same place, or under the same release authority.
If several reels are truly identical and stored together, a grouping rule may be useful, but retain each physical reel reference and its individual quantity. The rule should state why the products were grouped rather than hiding a difference in length, condition, or site.
- Use the same reel ID in the spreadsheet, photo filename, and supporting document name.
- Give every continuous piece its own reference.
- Write a grouping rule before combining matching reels.
Make the line record specific enough to compare
Each line should preserve the complete designation, conductor metal, size or count, marked rating when available, remaining continuous length, and quantity basis. Keep unknown fields visible instead of forcing an item into the nearest category. A total can be calculated later; first, the record has to show what each number represents.
Record footage as measured, documented, estimated, or unknown. Likewise, label any weight as gross, net, or estimated and state what it includes. This prevents one well-documented reel from becoming an unsupported proxy for every line in a large inventory.
- Record product designation, metal, size or count, and marked rating.
- Show continuous footage per reel with its quantity basis.
- Keep unknown specifications and uncertain quantities visible.
Group storage and condition by actual site
Separate warehouse, yard, and project-site inventory into actual site groups. Within each group, describe indoor or outdoor storage, visible condition differences, access limits, and the person or role that can authorize release. Identical product codes do not erase a difference in storage exposure or site control.
This site-by-site organization makes the handling discussion practical without presenting it as already settled. If loading equipment is not known, record it as unknown. If a reel can only be released after a separate approval, keep that status with the specific site group rather than with the entire lot.
- State storage site, exposure, condition notes, and access limits per group.
- List ownership and release authority for the relevant site.
- Record available loading resources or mark them unknown.
Local project context does not turn into inventory
Broomfield Public Works maintains more than 287 miles of roadway, traffic signals, bridges and guardrails and administers capital improvement projects involving municipal buildings, streets, water and sewer facilities. That documented city activity is only context for a hypothetical contractor or public-project inventory discussion; it does not show municipal ownership of cable, an available lot, or a buyer relationship.
For a Broomfield seller, the useful proof is still the line-to-reel mapping, site grouping, current quantity, and release authority. Local context cannot replace an inventory list or resolve a difference between conditions at two storage sites.
- Keep city context separate from ownership records.
- Match every photo to its reel and storage site.
- Retain site-specific release restrictions in the line or group record.
Worked multi-site mapping record
Illustrative fictional record—not a purchased lot: BL-BR-01 is one fictional reel at Site A with 500 ft documented and photo BL-BR-01-tag.jpg; BL-BR-02 is a separate fictional reel at Site B with 90 ft estimated and photo BL-BR-02-tag.jpg. The sample uses the same fictional designation for both but does not merge their quantities or site conditions.
This layout fixes the faulty large-lot record that offers one footage number and one clean photo for material from multiple locations. A real seller should retain one line per reel or continuous piece, connect it to the correct photos, and expose the specific access and release facts for that site.
- Example Site A quantity: 500 ft documented.
- Example Site B quantity: 90 ft estimated.
- Example photo mapping: one tag filename for each fictional reel.
