Build a line item that survives review
Assign every reel or continuous piece a stable line ID. Use it in the spreadsheet, photo filenames, reel tag, and any supporting document. Record manufacturer, part number, complete designation, conductor material, size, marked rating, and condition when known. Group matching inventory only after those underlying fields actually match.
The bulk-lot error is substituting one grand-total footage figure for the reel-level record. A total may be useful as a summary, but it cannot replace the individual references that reveal different specifications and lengths. Keep unknown lines in the inventory rather than forcing them into a matching group.
- Use a distinct line or reel ID for every physical reel or continuous piece.
- Match photo filenames to that ID.
- Keep manufacturer, part number, designation, and condition on the line item.
Keep quantities at the reel level
List reel count and continuous footage per line, then state whether each quantity is measured, documented, or estimated. Do the same for weight: identify gross, net, cable-only, or unknown weight rather than allowing a handling estimate to become a product claim.
A reel with 500 documented feet at one site and a reel with 90 estimated feet at another are two facts, not 590 confirmed feet in one place. Preserve the difference even if the products appear to match. This keeps a later lot discussion tied to the actual physical inventory.
- State footage and its basis for each reel.
- Keep reel count separate from aggregate footage.
- Label every weight gross, net, cable-only, estimated, or unknown.
Keep sites, release roles, and access limits on the same row
For multi-site inventory, put the storage site, condition, release authority role, dimensions, and loading or access limits beside the corresponding line reference. One contact or access note for the entire list can be misleading when reels are stored in different buildings, yards, or warehouses.
Describe actual handling information without presuming a pickup method. If a reel is on an upper rack, behind a controlled gate, or in a narrow room, record that constraint. The page is about making a bulk submission auditable, not promising transport or removal.
- Identify storage site and release role for each reel or site group.
- Record known dimensions and access limits for larger reels.
- Keep site conditions separate from product specifications.
Use local planning information only as file context
San Ramon’s Capital Improvement Program is a comprehensive five-year plan that identifies project priorities, financing method, costs and revenues and guides annual capital budgeting.
That fact may help a contractor or supplier organize a real project file and release sequence, but it does not identify an offered cable lot, establish a City transaction, or make the City a buyer. The evidence that matters for this page is the seller’s own line-item inventory, location record, and release authority.
- Use actual project records only when they match the listed inventory.
- Do not use a civic planning reference as a substitute for reel-level evidence.
Model a two-site record without hiding the limitation
Illustrative inventory example—not a purchased lot: references BL-SR-01 and BL-SR-02; product: matching product recorded, full designation on tag; quantity: Site A, one reel, 500 ft documented; Site B, one reel, 90 ft estimated; release: different site contacts, loading limits pending. The two rows remain distinct even though the product field matches.
For missing access, weight, or release information, say “unknown” or “pending” on the affected row. Attach the reel and tag photographs under the same line ID. This lets a reviewer identify the next question without assuming that an unresolved site detail applies to every reel in the submission.
- Keep each site and line ID visible in the example file.
- Mark loading limits and release details pending when not confirmed.
- Do not merge documented and estimated footage into a single continuous length.
