Define the offered scope before totaling the lot
A multi-site inventory is not one uniform pile. Begin by deciding which storage locations and which line items are actually being presented together. Use a location group for each warehouse, yard, or project storage area, then state whether that group is included, reserved, or awaiting release. This prevents a large total from hiding a reel that is not part of the offered scope.
The seller decision is whether another reviewer can trace every listed piece to a specific site and current release status. That is different from merely making a generic bulk inventory: the page is for reconciling several locations into one auditable offer without treating the grand total as the evidence.
- Create a location group for each actual storage site.
- State whether each group is included, excluded, or release-pending.
- Use a total only as a summary of visible individual lines.
Use one stable ID across files and sites
Assign a unique reference to every reel or continuous piece, such as BL-WVC-01, and use it unchanged in the spreadsheet, photo filenames, and existing documents. If identical reels are counted as a group, retain an identifier for each physical reel as well as the group description. A site name alone is not an item identifier.
The product description should remain on the same line as the reference. Copy readable manufacturer, part number, or jacket information where available, and state unknown rather than assuming that a neighboring reel shares the same construction. The stable ID is what joins the evidence; it is not a claim about the product.
- Line or reel ID.
- Product description and readable marking reference.
- Photo filenames using the same ID.
- Storage site and offered-group field.
Keep quantity and condition on the individual line
For each reel or continuous piece, record reel count, continuous length, quantity basis, and condition. Mark footage as measured, documented, estimated, or unknown. A combined number can be useful after the rows are complete, but it cannot convert several short pieces into a single continuous length or make an estimate documented.
If material at one site has different condition or construction from material at another, do not combine them to make a cleaner total. Preserve the difference and let the buying review consider the actual record. This also keeps a partially used reel from being represented by an original shipping quantity.
- Reel count and continuous length.
- Quantity basis: measured, documented, estimated, or unknown.
- Condition class for that physical line.
- Separate rows for unlike specifications or incomplete pieces.
Record access and release as site facts
Add the seller-known access constraint, loading resource, and release authority or status to each site group. Examples include a gated access limitation, a dock or forklift that the seller says is available, or a role that must authorize the release. These are planning facts, not an agreement about transport, handling, timing, or cost.
If one reel is reserved or a second location is not yet cleared, leave that status in its own row. Do not add it to the available amount and explain it later in an email. Keeping the hold visible makes the scope of the inquiry understandable without claiming a transaction is already arranged.
- Storage site.
- Access constraint.
- Seller-known loading resource.
- Release authority or current status.
- Excluded or reserved line note.
Reconcile photo evidence and incomplete rows
Photograph the tag or readable marking, a reel overview, and the site context where practical. Use filenames that contain the line ID, then place those filenames in the matching spreadsheet row. If a photo is missing, say so. If footage is estimated, state the estimate basis and retain the line instead of silently folding it into a confirmed total.
Unknown information is useful when it is localized. For example, a row can say that the reel is at Site B, footage is estimated, the tag photo is pending, and release is pending. That record gives a reviewer a focused follow-up path without forcing other sites to inherit the uncertainty.
- Tag or marking image.
- Overview image.
- Photo filename matched to line ID.
- Unknown or estimate note tied to one line.
Limited West Valley City location context
The city economic-development site says West Valley City grew from 72,000 to 133,000 residents and from 17,363 to 22,880 acres in just over 30 years of incorporation, and describes utility-connection assistance for businesses.
That is limited city background for recording the actual storage location and access facts supplied by a seller. It does not show that any cable belongs to a city project, that a particular site is available, or that a transport arrangement exists.
Illustrative multi-site register and correction
Illustrative inventory example—not a purchased lot: BL-WVC-01 is recorded as 500 feet documented at Warehouse A with matching tag and overview photos. BL-WVC-02 is recorded as 90 feet estimated at Yard B, with release pending. The record is fictional; its purpose is to show that a grand total must remain traceable to its individual lines.
The common mistake is listing 3,000 feet as one available lot when that figure includes short pieces at two sites and a reserved reel. Correct it by preserving one row per reel or continuous piece, keeping the site and release field visible, and summing only the rows actually included in the offer.
- Fictional line A: BL-WVC-01; 500 feet documented; Warehouse A.
- Fictional line B: BL-WVC-02; 90 feet estimated; Yard B; release pending.
- Photo references: BL-WVC-01-tag.jpg and BL-WVC-02-overview.jpg.
- Correction: show inclusion and release state before publishing a total.
