Create one traceable line per reel
For a large lot, begin with a reel or line ID that appears in the spreadsheet and photo filenames. One identifier should lead a reviewer to one physical reel or one stated continuous piece. If a site has several matching reels, retain the reel count and the footage for each reel or clearly identify the matching group.
This task is not a generic quantity summary. It is a handoff record that lets the item, its record, and its storage location remain connected when a lot spans yards, warehouses, or project locations.
- Reel or line ID used in files and inventory
- Product designation or an explicit unknown
- Photo filename and storage contact
Map location and release before grouping sites
Put the exact seller-provided storage site beside every line, even if several sites are discussed in one inquiry. Identify whether material is offered as one coordinated group or as separate site groups, then record the authority that can approve each release. A grand total cannot tell a reviewer which location controls a particular reel.
If access facts differ by site, keep them with the local line. Gate limits, dock conditions, operating restrictions, and the availability of loading equipment are reported conditions, not an assumption about who will move the material.
- Site and storage contact
- Lot grouping: coordinated or site-specific
- Release authority and seller-reported site restrictions
Separate footage evidence from the lot total
Record continuous footage for each reel and label it measured, documented, or estimated. Preserve the actual basis for an estimate, such as a tag balance or a visual winding estimate. It is fine to provide a total afterward, but the per-reel values must remain visible so short pieces are not mistaken for one long run.
The common error is a single statement such as “2,000 feet” for material at several locations. The workable correction is a row for each reel or continuous piece, with the specification match and quantity basis attached.
- Continuous footage per reel
- Measured, documented, or estimated quantity basis
- Reel count and specification match
Label dimensions and weights by their real basis
For each large reel, state dimensions and any known weight with its basis. A gross loaded-reel number can include the reel, blocking, packaging, and cable; it is not automatically cable-only or conductor weight. If the basis is unavailable, mark it unknown rather than converting it into a more specific claim.
Include the reported loading equipment and access limits on the same line. This records practical facts for discussion without promising a collection method, a vehicle type, or a transport arrangement.
- Dimensions with source or estimate basis
- Gross loaded-reel, net cable-only, or unknown weight label
- Gate or loading limits and equipment available
Keep city transportation context proportionate
The city’s Transportation and Mobility Services says it plans, operates and maintains a safe and efficient transportation system for people, goods and services. That city function is relevant only as context for documenting seller-reported access and loading constraints; it is not evidence that a buyer will provide transport or that a site has a particular capability.
The actionable record still comes from the seller: reel dimensions, exact site, release contact, access limit, and the actual grouping of the offered material.
- Use actual site facts rather than a city-level assumption
- Keep transport discussion lot-specific
Illustrative multisite reel log
Illustrative fictional inventory example—not an actual lot: BL-GP-A is one reel at Site A with 500 feet documented; BL-GP-B is one reel at Site B with 90 feet estimated. The product designation is recorded for each line, while dimensions and gross loaded-reel weight are unknown.
The purpose is to show the distinction between two site records, not to report inventory. A real submission should replace the example with the seller’s actual reference IDs, locations, source files, and release contacts.
- BL-GP-A: Site A, 500 feet documented
- BL-GP-B: Site B, 90 feet estimated
- Dimensions and gross loaded-reel weight: unknown
