Use one stable key for each physical item
Assign a line or reel reference before combining spreadsheets, photographs, or warehouse notes. Use that same key in the inventory row, photo filenames, any documents, and the storage-site field. A representative photo and one aggregate footage number cannot establish which reel carries a particular construction or condition.
For each keyed item, record manufacturer or part number, cable designation, conductor metal and size, reel count, and footage per reel. Keep an identified reel separate from an unknown or differently marked item even when both are stored on the same site.
- Stable line or reel reference
- Photo filename and document reference using that key
- Manufacturer, designation, conductor metal, and size
- Per-reel footage and reel count
Preserve differences across sites and conditions
Group products only when their construction and condition genuinely match. Record one site or location per line, along with unused, removed, partial-reel, or other history. State whether footage is measured, documented, or estimated and note visible damage. This prevents a grand total from hiding one short partial reel or a differently stored cable.
The typical mistake is one total-footage field and a single representative image for multiple reels and locations. Resolve it with one row per reel or continuous piece, matching every image to the same reference and retaining each site, specification, and condition difference.
- Site or storage location per keyed line
- Condition and history per reel or piece
- Measured, documented, or estimated footage basis
- Visible damage recorded separately from the specification
Add release and access information at the line level
Identify the release authority, access restrictions, dimensions, weight basis, and observed loading resources for each site or reel group. Use gross, net, or unknown to describe any weight; a loaded reel figure should not be relabeled as cable or conductor weight. Do not assume that a shared warehouse contact can authorize release for every location.
When authority, dimensions, or equipment availability are incomplete, flag the field unknown and retain a reference to the warehouse note or contact that may resolve it. This creates a workable next-step record without treating an incomplete lot as fully released.
- Release authority or pending status
- Access restrictions by site
- Dimensions and gross, net, or unknown weight basis
- Observed loading resources and their location
Illustrative multi-site inventory record
Illustrative inventory example—not a purchased lot: BL-CNX-06A and BL-CNX-06B are matching-product entries at separate sites. Site A has one reel with 500 ft documented; Site B has one partial reel with 90 ft estimated. Each site’s authority remains to be confirmed. This fictional record keeps the two quantities and conditions visible instead of combining them.
A photo such as BL-CNX-06B_label.jpg belongs only to the B line. If its label, footage, or condition differs from A, retain the difference even if both entries began in one warehouse export.
- References: BL-CNX-06A and BL-CNX-06B
- Site A: one reel, 500 ft documented
- Site B: partial reel, 90 ft estimated
- Release: each site authority to be confirmed
Use Conroe project categories only as background
Conroe's capital-improvement page groups projects into water, sewer, street and drainage, facility, signal and grant projects. Those categories can help label a project-context group in a large inventory, but they do not identify a cable’s specification, prove an offered lot exists, or replace its line-by-line release record.
