Build the inventory around stable line references
Assign each reel or genuinely identical group a reference that appears in the inventory, photo filenames, and source documents. Record manufacturer, part number, product designation, condition or history, continuous length, reel count, and a measured, documented, or estimated basis. A grand total can be added for internal orientation, but it cannot replace the line-level record.
Use a separate line whenever a product, quantity basis, condition, or location changes. This is especially important where a list contains several cable families or different storage sites. The reviewer should be able to start with any row and find the physical item and its evidence without relying on a nearby reel.
- Use one reference across list, photographs, and records.
- Retain continuous length and quantity basis per line.
- Do not replace varied rows with a single footage total.
Separate product grouping from site grouping
First identify product and physical differences, then record the storage site for each line. Two reels at different sites may have matching specifications but different access, release contacts, or quantities. Two reels at one site may look alike but have different markings, condition, or continuous length. Both distinctions need to survive in the submitted list.
Record unused stock, previously in-service cable, and unidentified material as different histories when known. Keep mixed or incomplete lines visible instead of forcing them into a confirmed product group. This supports an actionable lot review while making the uncertainty clear.
- Keep product designation, condition or history, and storage site as separate fields.
- Group only genuinely matching items.
- Give incomplete items their own references.
Make the photo set function as a row-level audit trail
Use the site code and reel reference in filenames for readable tag, jacket-marking, overview, and condition photographs. A photo of one clean reel should not be used as evidence for every reel in a bulk lot. If an image supports a group, name every reference in the group and ensure the documented fields truly match.
Attach existing records to the same line they support. When a length is estimated or a marking is incomplete, put that limitation in the row and, where useful, in the photo caption. The objective is not a polished presentation; it is a map from a claimed field to its supporting item.
- Match filenames to both site code and reel reference.
- Use tag, jacket, overview, and relevant condition views.
- Label estimated quantities and incomplete markings.
Keep release and access facts at the site level
For every site, record the person or role that can authorize release, access limits, available loading resources, and any seller timetable that is already known. Then point each inventory row to that site record. If authority differs by reel or group, preserve the difference rather than assigning one contact to the entire lot.
Racine County’s official business directory includes a “Manufacturing, Wholesale, & Distribution” category and says it is currently accepting businesses located within Racine County. This only supplies local context for how a seller might organize manufacturer, wholesaler, or distributor records; it does not identify actual bulk inventory, a buyer, or an arranged transaction.
- Record release authority, access restrictions, and known loading resources per site.
- Point each inventory line to its storage-site record.
- Mark unknown authority or access facts explicitly.
Repair a grand-total spreadsheet with a line-item audit
Illustrative inventory example—not a purchased lot: BL-RC-01 is at Site A with 500 ft documented; BL-RC-02 is at Site B with 90 ft estimated. Both have their own tag, jacket, and overview images, even if they share a product marking. The two rows retain distinct site and quantity-basis fields instead of being presented as one 590-ft reel.
If a source spreadsheet contains only an aggregate total, create a provisional row for every physical reel or continuous piece and mark absent facts unknown. Add references and photos before grouping items. This turns an ambiguous bulk list into a practical review record without promising an outcome for the lot.
- Example line: BL-RC-01, Site A, 500 ft documented.
- Example line: BL-RC-02, Site B, 90 ft estimated.
- Every line has matching tag, jacket, and overview images.
