Build one inventory line that can be found again
Assign a stable reference to every reel or truly identical group, such as BL-FRED-A01, and use it in the spreadsheet, photo filenames, and supporting files. One row should identify the manufacturer or part number, cable designation, conductor metal, size or rating, reel count, and remaining footage for that specific item or supported identical group.
A grand total can be supplied as a summary, but it should not replace line-level quantities. If a group is used, preserve the number of reels and per-reel footage so the summary does not make different continuous lengths look alike.
- Line or reel reference
- Manufacturer or part number
- Designation, metal, and size or rating
- Reel count and per-reel footage
- Measured, documented, estimated, or unknown quantity basis
Keep storage sites separate even when products match
Record a site code or storage location, condition, access limits, and release contact for every line. Two matching reels may need separate entries if one is in a warehouse bay and another is at a project storage point with a different contact or access rule. Site grouping is the material decision on this page, not a cosmetic column in a spreadsheet.
If a release contact is not known, write pending contact instead of assigning the warehouse contact by assumption. The seller can still describe the item while making clear that authority remains unresolved for that location.
- Storage site or site code
- Condition at that site
- Access limits
- Release contact or pending-contact note
- Defined lot group if applicable
Make the photo set prove the spreadsheet reference
Name photos and supporting documents with the same line reference used in the inventory. For a representative record, include the tag or jacket legend, reel overview, and visible condition. Preserve differences between reels; one clean reel photo should not stand in for another reel with a different quantity, site, or condition note.
Made in Frederick describes Frederick County as having access to major metropolitan areas, highways, railroads and ports and a growing talent pool. This is limited local context for why access and site notes can matter to a commercial inventory record, not a claim that a route, carrier, or freight arrangement is available for a seller’s lot.
- Photo filename beginning with the line reference
- Supporting file under the same reference
- Tag or jacket view
- Reel overview and visible-condition view
Describe dimensions and loading facts as facts
For each large reel or site group, record dimensions, the actual weight basis, reported loading equipment, staging constraints, and the seller’s requested timetable. State whether a weight is gross loaded-reel, net cable, estimated, or unknown. A dimension or forklift note is useful evidence, but it does not allocate handling duties or establish transport terms.
Where a value is incomplete, keep it incomplete. For example, an estimated reel diameter can be labeled estimated while the footprint or access lane is still unknown. That is better than blending assumptions into a single handling note.
- Dimensions and unit
- Gross, net, estimated, or unknown weight basis
- Reported loading equipment
- Staging constraints
- Requested timetable
Replace the grand total with a usable site map
The core error is using one grand-total footage figure for reels held at different locations, under different conditions, and with different release contacts. Correct it with one row per reel or continuous piece, defined site groups, evidence-linked photos, and clear authority fields.
Illustrative fictional record—not a purchased lot: BL-FRED-A01, 500 ft documented in warehouse bay 2; BL-FRED-B01, same product, 90 ft estimated at a second site; gross loaded-reel weight unknown; release contact pending for the second site. It shows why a shared product name cannot replace site-level records.
- One row per reel or continuous piece
- Site grouping retained in the export
- No assumed release contact
- Weight basis stated plainly
