Give each cable reel a durable reference
Create one reference for every reel or truly identical group at the same site. Use the same reference in the spreadsheet, photo filenames, product records, and follow-up messages. The line should contain manufacturer, part number, readable designation, conductor information when known, and a short condition note.
Do not assign one pristine reel photo or one part number to several reels without matching evidence. If a reel lacks a tag, give it a temporary ID and record tag missing. That is more useful than absorbing it into a general total where its construction and length disappear.
- Line or reel ID
- Manufacturer and part number
- Readable designation or unknown
- Tag and condition status
Retain quantity evidence one reel at a time
Record reel count and remaining continuous footage per reel. Mark the quantity basis as measured, documented, estimated, or unknown. A lot can have an aggregate total for orientation, but the underlying rows must show how the total was constructed and which pieces are not continuous.
A partially used reel and a bin of cut lengths need different entries. Keep a short piece from being mistaken for a long run by listing it as its own continuous piece or mixed-piece record. The likely mistake is a single footage total that masks different specifications and evidence quality.
- Per-reel length
- Measured, documented, estimated, or unknown basis
- Full, partial, or cut-piece condition
Keep sites and release contacts attached to the line
Separate records by actual storage site rather than assuming every reel sits at one address. For each site, note the seller-supplied location description, access limitations, loading resources, and the role that can authorize material release. A cable line stored at Site A should not inherit Site B’s access facts or contact.
If the site of a reel is not yet confirmed, write site unknown and attach the latest image or record that identifies it. This creates a targeted follow-up instead of an unsupported assumption about where the cable can be accessed.
- Storage site or site unknown
- Access limitations
- Loading resources
- Site-specific release contact
Build an auditable photo and document set
For each reference, link an overview image, a tag or jacket-marking image, and relevant condition images. Match any product document to the reel it actually describes. A document for a similar cable should be listed as unmatched rather than used to complete a different line.
The working resolution is simple: one row per reel or continuous piece, with images and documents attached to the same stable ID. That approach lets a buyer see which specifications, quantities, sites, and release records have support without promising any transaction outcome.
- Photo filenames
- Tag and jacket-printing status
- Visible condition
- Document reference and scope
State the local access fact with the right limit
The city says Plantation has access to all major highways and is a 15-minute drive to Fort Lauderdale-Hollywood International Airport and Port Everglades. This is location context, not a promise about freight, collection, or route planning. Its practical relevance is that a seller should still specify the actual site, reel dimensions if known, access constraints, and available loading resources for the cable in question.
An illustrative fictional record can show BL-P01 as one documented 500 ft reel at Site A and BL-P02 as the same product with 90 ft estimated at Site B. It is not an actual or purchased Plantation lot. The two rows stay separate because quantity basis and site evidence differ.
- Illustrative line: BL-P01
- One reel: 500 ft documented
- Second line: BL-P02, 90 ft estimated
- Site A and Site B kept separate
