Make site boundaries part of the inventory
Assign a stable reference to each reel or genuinely matching group, such as BL-01. Use that reference in the spreadsheet, photo filenames, and supporting documents. Record the actual storage site on every row; identical product at two sites remains two location records because access and authority may differ.
The common mistake is a grand total that hides where the reels sit and who can release them. Start with a per-line count and per-reel continuous length. State whether each quantity is measured, documented, or estimated so a buyer can distinguish a firm record from a preliminary inventory.
- Line or reel reference used in every file
- Storage site per line
- Per-reel length with its quantity basis
Group only when the facts actually match
Reels may share a manufacturer but differ in designation, conductor metal and size, marked voltage, current length, condition, or storage exposure. Keep those differences in separate rows. Grouping is appropriate only when the product record, per-reel length, condition, site, and release authority are genuinely the same.
Record part number when available and preserve readable jacket printing even for a group. If one reel’s tag is missing or its footage is only estimated, do not let a stronger record for another reel overwrite that uncertainty. Give the incomplete reel a distinct line or an explicitly provisional subgroup.
- Manufacturer, part number, designation, metal and size
- Marked voltage and per-reel length
- Condition and storage exposure kept with the group
Build a photo and document trail a reviewer can follow
Name files with the line reference, such as BL-01-label or BL-01-overview. Add each filename to the inventory row with any packing list, invoice, or data-sheet reference that applies to the same line. A loose image set cannot show which photo supports which quantity or specification.
The city lists Smallwood Plaza as a three-story mixed-use project on Historic Main Street with 4,000 square feet of commercial leasing space and nine residential units. This is local commercial-closeout context only; it does not identify a cable lot at that project or establish a buying relationship, inventory, or demand.
- Photo filename matched to line reference
- Document link or record reference
- Separate note for unreadable tags or unknown facts
Keep release and loading facts site-specific
For each site, list the owner or release authority, access restrictions, known loading resources, reel dimensions, and gross, net, or estimated weight basis. A forklift or dock noted at one location should not be assumed available at another. If access is unconfirmed, mark it unknown and keep it visible.
State the seller’s requested timetable beside the site record. This supports a practical discussion without promising a collection method or date. A multi-site submission is strongest when every site has its own authorization and access facts rather than one generic logistics note.
- Release authority per site
- Access restrictions and loading resources
- Dimensions and weight basis for each large reel
Illustrative multi-site reconciliation
Illustrative fictional record—not a purchased lot: BL-01; matching product; 500 ft documented; Site A. BL-02; same product; 90 ft estimated; Site B. Separate authority per site; condition unknown until photographed. The example intentionally preserves different sites and different quantity bases rather than adding them into one total.
The resolution is a traceable multi-site ledger. This differs from the project-overrun page, which decides whether stock is physically available and release-ready for a project, and from the industrial closeout page, which focuses on cable construction and use history.
- Do not add cross-site footage until each line remains visible.
- Leave site-specific unknowns on their own line.
