Assign a reference that travels with the reel
Use one stable reference for each reel or genuinely matching group. Repeat it in the spreadsheet, photo filenames, product records, and release notes. The reference is the bridge between a visible reel and its line item; without it, a large inventory can become impossible to audit.
Record manufacturer, part number, and readable designation beside the reference. If a line has no legible marking, identify that uncertainty on the same line rather than placing its photo under an identified product group.
- Fields: line/reel reference, photo filename, manufacturer/part number, and designation.
- Use the same reference in every supporting file name.
Preserve per-reel quantity and condition
Keep the continuous footage, reel count, quantity basis, and condition visible for each row. Matching products may be presented as a group only when their product record, condition, location, release path, and quantities genuinely support the grouping. A single total does not show whether one reel is partial or stored elsewhere.
Mark footage measured, documented, or estimated and explain the basis when it is estimated. Keep an unconfirmed or mixed line in the inventory, but do not let it inherit a neighboring reel’s quantity or condition.
- Fields: continuous footage, reel count, measured/documented/estimated, and condition.
- Use one row per reel or continuous piece when material differs.
Separate actual sites and release paths
Group the records by the physical warehouse, yard, or other actual storage location. For every line, state the release authority and whether approval is authorized, pending, or unknown. A multi-site inquiry is clearer when each reel can be followed to a site and an authority without assuming that another site’s contact covers it.
Do not substitute a broad city reference for a storage record. The location field should describe the seller’s actual site in the inquiry, and any access limits should remain with the same rows as the stored material.
- Fields: storage location, release authority, approval status, and access/timetable.
- Keep pending authorization visible rather than burying it in an aggregate note.
Add practical loading information without promises
For each site or reel group, provide known dimensions, a stated weight basis, available loading equipment, and access limits. These seller facts help define the material situation; they do not promise freight, pickup, timing, inspection, or acceptance. Say unknown if a dimension or weight basis has not been documented.
Fictional inventory record—not a purchased lot: BL-KCK-01; matching product; one reel, 500 ft documented; Site A; photo BL-KCK-01_tag.jpg. A separate BL-KCK-02 record shows one reel, 90 ft estimated, Site B, and its own photo. The two rows are not a single 590-ft continuous line.
- Fields: dimensions, weight basis, loading equipment, and access/timetable.
- Tie each overview and tag image to its stable line reference.
Kansas City context supports questions, not claims
The Unified Government says KCK is home to production facilities, warehouses and distribution centers and emphasizes shipping raw materials and finished goods from the nation’s heartland.
That local context makes site-level storage and line matching useful questions. It does not identify any seller, prove that stock is available, or change the need to document every reel’s actual material, condition, location, and release status.
