Sort by the printed designation, not the storage tray
The first split is the actual jacket marking. Transcribe a readable TC, TC-ER, PLTC, or other designation exactly as shown, together with the manufacturer and part number when present. A cable found in a tray is not automatically a Type TC product, and a storage location is not proof of construction.
The City of Auburn says its diversified industrial base includes 43 small-to-medium technology-based, value-added manufacturing firms employing nearly 4,400 people across markets including aerospace, automotive, construction, defense, electronics, energy and industrial. That is limited context for a hypothetical controls inventory, not a statement about any local cable, facility, or buyer relationship.
- Exact printed designation
- Manufacturer and part number when readable
- One reel ID for each physical reel
- A separate unknown-designation line when printing cannot be read
Split the construction variants that look alike
Create a separate line when conductor count, pair count, gauge, shielding, or jacket differs. Similar reels can share color, diameter, or a shelf location while carrying different control-cable constructions. The inventory should let a reviewer see the variant without recalculating it from a mixed total.
Keep pair count and conductor count distinct. If a reel appears to have shielding but the record does not support the type, use an unknown shielding field rather than calling it foil or braid. The practical task is correct sorting, not completing a technical description from appearance.
- Conductor count
- Pair count
- Gauge
- Shielding status and documented type
- Jacket differences kept on their own lines
Preserve a reel-to-photo trail
Use the same reel ID in the inventory row, tag photograph, jacket-marking image, and whole-reel photo. This prevents a clear marking on one reel from being treated as documentation for another. Note fitted ends and visible condition on the same record so a construction variant does not lose its physical context.
Record each continuous length and whether it is measured, documented, or estimated. Do not roll several different partial reels into one total simply because they share a broad control-cable label. A reel-specific schedule makes both the construction split and the quantity basis easy to inspect.
- Reel ID repeated in every file name
- Jacket and tag photos matched to the same ID
- Fitted-end and condition notes
- Continuous length with a stated quantity basis
Use uncertainty to stop a misleading aggregate
The frequent mistake is to label all cable found in a tray as Type TC and combine it into one total. Instead, use actual jacket and manufacturer records, separate uncertain lines, and retain each reel’s construction and length. That approach makes the unverified items visible without changing their description into a confirmed one.
If a marking is cut away or unreadable, photograph the remaining evidence and create an uncertain line with its reel ID. Do not transfer conductor count, shielding, or part number from the best-marked reel in the group. Unknown fields are a workable result when the physical evidence is incomplete.
- Never classify by storage location alone
- Do not merge uncertain reels into a confirmed specification
- Mark each unsupported field as unknown
Build a row that exposes the real grouping decision
A clearly fictional example is: line CT-AU-031; marking “TC-ER photographed”; construction “12 conductors, 16 AWG; shielding unknown”; quantity “240 ft measured; removed with fitted ends.” This is not a purchased Auburn lot. The example keeps a verified designation, a specific construction observation, an unknown shield field, and one continuous length together.
Before sending a control or tray cable list, compare each reel against the other rows. Group only reels with matching documented designation and construction fields. The seller decision is whether two reels genuinely share a specification; it is not whether they happened to be stored in the same tray.
- Group only matching documented variants
- Retain a separate row for each uncertain reel
- State the footage basis for every reel
