Give every distribution reel its own identity
Assign one stable reference to each reel before combining anything in a spreadsheet. Use that reference on the reel tag photograph, a readable jacket-marking photograph, and a whole-reel image. Record the manufacturer or part number when visible, the full product designation, and the file names that support those entries. A project code may remain as background, but it cannot replace the cable identity.
This first step prevents a broad line such as “underground project cable” from hiding unlike reels. If two reels have a different jacket legend, conductor size, marked voltage, or configuration, keep them on separate lines even when they came from the same project or storage rack.
- Use one reel reference in the inventory and photo names.
- Copy the complete readable jacket legend rather than a shortened product nickname.
- Mark a missing tag or unreadable printing as unknown.
Separate construction from the project label
The City’s infrastructure-projects page lists work across stormwater, potable water, wastewater and transportation infrastructure. That city context can explain why a seller has project-related reels, but it does not identify their construction or establish that a particular lot is available. The seller record still needs the marked voltage, conductor metal and size, plus any neutral, shield, or configuration detail that is actually shown.
Transcribe those fields from the offered reel or from a document that can be matched to its reference. Do not use a specification from a neighboring reel to fill a gap. When a neutral or shield detail is not visible, enter “unknown” and retain the photo or record that shows the limit of the available information.
- Marked voltage and conductor metal.
- AWG or kcmil as printed or documented.
- Neutral, shield, or configuration only when tied to the listed reel.
- Source for each field: photograph, tag, or matching record.
Reconcile current footage instead of order footage
List the continuous length on each reel and state whether it is measured, documented on a matching tag, or estimated. Also list the count of genuinely matching reels. The original order amount can be useful history, but it is not automatically the current balance after project use, transfers, or partial consumption.
When an inventory export and the physical reels disagree, keep both figures visible and add a discrepancy note. A seller who has three partial reels should not report their combined footage as one continuous length. This preserves the quantity distinction needed for a material buying discussion.
- Continuous footage per reel.
- Measured, documented, or estimated quantity basis.
- Current reel count and any original-versus-current discrepancy.
- Separate lines for partial reels with different markings.
Describe condition and handoff limits without assumptions
Record visible end protection, exposed ends, storage exposure, reel dimensions, and whether a reported weight is gross, net, or unknown. Include only observed access facts: the storage location, available loading resources, and restrictions such as a controlled yard or blocked aisle. Those facts help frame a possible lot discussion; they do not commit either party to transport or removal.
If the cable was outdoors, say what is known about cover, moisture, or packaging rather than characterizing its electrical condition. If access or a weight basis cannot be confirmed, label it unknown and identify the record or site contact that may clarify it later.
- End protection and visible jacket or packaging condition.
- Storage exposure and known limitations.
- Dimensions and stated weight basis.
- Release authority, loading resources, and access restrictions.
Use a candid record when information is incomplete
Illustrative fictional inventory record—not a purchased lot: reel UD-SP-04; distribution-cable jacket marking photographed; neutral configuration unknown; 580 ft continuous, documented; uninstalled warehouse reel; gross weight includes packaging; seller authorization pending. This shows that a usable entry can preserve a known marking and quantity while keeping unanswered fields visible.
The likely error is carrying one project label and original order total across reels with different ratings or neutral configurations. Correct it by splitting the record by reel reference, retaining the current continuous length for each, and marking unsupported construction or quantity as unknown or estimated rather than guessed.
- Fictional record fields: reel reference, designation, quantity basis, condition, and release status.
- Do not merge unlike reels merely to create one larger footage total.
