Read the jacket before sorting the inventory
Begin with a readable cable legend. Capture TC, TC-ER, PLTC, or any other printed designation exactly as it appears, along with manufacturer, part number when present, and voltage marking. The place where a cable was stored or routed may explain its history, but it does not establish the cable type.
If a legend is faded, photograph the best available sections and mark the designation unreadable or unknown. Keep that reel separate from positively identified material. An accurate uncertainty record is more useful than classifying a line from its location, color, or appearance.
- Transcribe the full visible jacket legend, not only the largest number.
- Use the reel or line reference in every related photograph.
- Mark unreadable printing as unknown rather than assigning a presumed type.
Split multi-conductor variants before totaling footage
Control and tray cable should be separated when conductor count, pair count, gauge, shielding, jacket, or printed designation differs. These distinctions can matter even when two reels have the same outside diameter or come from the same storage area. Create a line for each verified construction rather than calling an entire group one generic tray-cable item.
For partial reels and cut lengths, record the remaining continuous footage and its quantity basis. A collection of shorter pieces is not one continuous length. If fitted ends or visible jacket damage differ, retain those condition differences with the matching line.
- Keep conductor count, pair count, gauge, shielding, and jacket in separate fields.
- Separate full reels, partial reels, and cut lengths.
- Label length as measured, documented, or estimated.
- Record fitted ends and visible damage without assuming their effect.
Separate source history from product identity
An entry can state whether cable is uninstalled maintenance stock, project overrun, or removed material, but that history should not replace the printed product record. Keep source history, unused or removed status, location, and release authority as their own fields. This makes it possible to compare the actual cable construction without hiding its condition or availability context.
When a line’s release contact is unresolved, preserve the rest of the record and label that gap plainly. The inventory can still identify what needs follow-up without implying that every identified reel is ready for release.
- Use separate fields for source history and printed type.
- State unused or removed status for each line.
- Keep location and release authority attached to the matching cable reference.
Document unclear legends as a deliberate category
A useful unknown line still includes a reference, accessible photographs, continuous length, quantity basis, fitted-end note, visible condition, source history, and location. It simply does not pretend to know the printed type, shield, or pair count. This prevents a missing legend from being smoothed over by a nearby reel’s data.
The specific mistake to avoid is calling every cable found in a tray Type TC or combining similar reels despite different conductor or shielding arrangements. The practical fix is to rely on actual markings and matching records, then isolate lines whose markings cannot be confirmed.
- Create an unknown field for each missing construction fact.
- Do not use a neighboring reel’s paperwork for an unverified line.
- Keep uncertain reels out of otherwise matching groups.
Use a fictional control-cable line to test the worksheet
Illustrative inventory example—not a purchased lot: fictional CT-LS-02 shows a TC-ER marking, 12 conductors at 16 AWG, 240 ft measured, fitted ends present, shielding unknown, and release contact unknown. The example is intentionally mixed: it distinguishes supported marking and measurement facts from fields that need follow-up.
The plan reports that 49.5% of Lee's Summit jobs in 2017 were in sectors projected for quick growth, including construction, transportation and warehousing, professional/scientific/technical services, education, health care, and hospitality/food service. This is limited local context for the possibility of project, warehouse, or facility inventory; it is not evidence that a specific Lee’s Summit cable lot exists or that Industrial Wire Buyer has handled one.
- Use a fictional record only as a worksheet model, never as evidence about actual inventory.
- Keep the local-context statement separate from the material’s actual markings.
