Map the lot before you add a total
A multi-site cable lot has two separate questions: what each reel contains and where it can be released. Start with a site code such as SB-A or SB-B, then assign every reel or continuous piece a line ID that never changes. A total belongs at the bottom of the list, after the site and reel rows are complete.
Do not let a warehouse total stand in for a physical inventory. A row can be present, reserved, missing, or awaiting confirmation. Record that status beside the reel ID so the inquiry distinguishes a reel that is merely listed from one that is available for a release discussion.
- Use one stable line ID for one reel or one continuous piece.
- Keep the site code, material description, and current availability on the same row.
- Show an aggregate total only as the sum of identified rows.
Build a site-and-reel handoff sheet
For each row, pair the reel ID with manufacturer, readable part number or jacket designation, reel count, and continuous footage. Use the ID in photo filenames as well: a label image, a jacket-print image, and a reel overview should all lead back to the same row. If two reels look alike but have different markings, give them different rows.
Add a short site panel for every location: storage area, person or role that can confirm release, gate or appointment constraints, and any access limitation. This is a release record, not a promise that a vehicle, crew, or handling method has been arranged.
- Reel ID and matching photo filenames.
- Manufacturer, part number or complete readable designation.
- Site code, release contact role, and access limitation.
- Current availability: available, reserved, missing, or pending.
Keep quantity and weight bases separate
List footage per reel and label its basis as measured, documented, estimated, or unknown. A lot may contain one documented full reel and another partial reel with an estimate; those are not interchangeable quantities. Keep cut lengths on their own rows rather than adding them to a reel balance.
Treat every weight the same way. A scale figure may be gross loaded-reel weight, cable-only weight, net weight, or unknown. Wood, steel, packaging, and cable construction make a loaded-reel figure different from conductor content, so report the observed basis without converting it.
- Continuous footage per reel and its quantity basis.
- Reel count and condition noted independently from footage.
- Weight value plus gross, net, cable-only, or unknown basis.
- Separate rows for partial reels and loose continuous pieces.
Make access facts usable without presuming movement
Describe only the facts the site can support: reel diameter and width if known, reported loaded-reel weight basis, indoor or outdoor position, gate limits, appointment requirements, and equipment reportedly available. Tie each fact to its site code. A fork truck at SB-A says nothing about a reel held at SB-B.
When a fact is missing, state it as unknown and name the record that could resolve it, such as a reel tag photo, a scale record, or a site contact. This makes follow-up targeted and avoids inventing a handling plan from a combined lot total.
- Dimensions and weight basis for large reels when known.
- Gate, appointment, and vehicle restrictions by site.
- Reported loading equipment and the role that controls it.
- Unknown field plus the record needed to clarify it.
San Bernardino context and a worked lot record
San Bernardino County describes the county as a national leader in logistics, distribution and shipping. That is regional context for a warehouse-style, multi-location record; it does not identify a seller, prove any cable is available, or establish a purchase decision.
Illustrative fictional record—not a purchased lot: BL-SB-04 is an identified cable reel at site SB-A with 500 ft documented; BL-SB-05 is at site SB-B with 90 ft estimated. Both retain their own photos, release contact role, and weight basis. If cable-only weight is unknown, the sheet says so rather than spreading one scale figure across both reels.
- BL-SB-04: site SB-A, 500 ft documented, photo set matched.
- BL-SB-05: site SB-B, 90 ft estimated, release confirmation pending.
- Weight: gross loaded-reel for one row; cable-only weight unknown for the other.
