Give every reel or truly identical group a stable ID
Assign a stable line or reel ID before making a spreadsheet or taking photographs. Use the same ID in the inventory, photo filename, and supporting document reference. A genuinely identical group may share one ID only when the products, condition, quantity basis, and storage site are the same; otherwise retain one row per reel or continuous piece.
This prevents a clean photograph from standing in for a different reel elsewhere in the lot. If a document or image cannot be matched to a line, retain it as unassigned rather than attaching it to the closest-looking item.
- Line or reel ID, photo filename, document reference, and storage site.
- One row per reel or continuous piece unless the group is truly identical.
- Unassigned documents clearly marked instead of guessed onto a line.
Keep specification differences and unknowns on the row
For each reel, record manufacturer, part number, designation, conductor metal, size, conductor count, marked voltage, and continuous length. Do not merge different part numbers, voltages, or condition histories just because jackets appear similar. A large lot can still be easy to review when those differences remain visible in the line items.
When printing is illegible, state that it is illegible, attach the image, and identify the basis of any estimate. Do not convert an unknown product field into a lot-wide description based on one well-labeled reel.
- Manufacturer, part number, designation, metal, size, and conductor count.
- Marked voltage and continuous length on each line.
- Unknown fields and the evidence available for them.
Preserve quantity and weight basis per reel
Record reel count, length per reel, and whether length is measured, documented, or estimated. Keep gross loaded-reel weight separate from any cable or conductor weight, and state the basis for every weight figure. Add dimensions when available so the inventory retains the handling facts associated with the correct physical reel.
A grand total can be a useful summary after the rows are complete, but it must not replace per-reel continuous lengths. Short pieces at one site should remain visible even where the overall lot also contains long reels.
- Reel count, length per reel, and length basis.
- Weight, weight basis, and dimensions.
- A summary total only after individual rows remain available.
Group sites without hiding access or release differences
Keep storage site, condition, access restrictions, available loading resources, release contact, and lot grouping as separate fields. State whether the seller is offering one combined lot or defined site groups. This allows a reviewer to see when otherwise similar cable has different access or release paths.
If a release contact is unknown, say so and retain the site’s available administrative information. Do not merge locations merely to simplify the spreadsheet, and do not let an available contact for Site A imply release authority for Site B.
- Site and lot grouping.
- Condition and access restrictions.
- Available loading information and release contact or unknown status.
Use regional context narrowly and keep the example fictional
The Dover/Kent County MPO is the federally designated agency coordinating transportation planning and programming in Kent County. That planning role is local context for why a seller should record site access precisely; it is not a transport commitment, proof of a route, or evidence that a particular wire or cable lot is available.
Illustrative inventory example—not a purchased lot: BL-DV-05 and BL-DV-06 are fictional lines for matching product records at Site A and Site B. BL-DV-05 has one reel at 500 ft documented; BL-DV-06 has one reel at 90 ft estimated; release authority is unknown. The two lines stay separate despite sharing a product description.
- Fictional references: BL-DV-05 and BL-DV-06.
- Site A: one reel, 500 ft documented; Site B: one reel, 90 ft estimated.
- Release authority: unknown.
