Build a line-item map before adding totals
Start with one inventory row for each reel or continuous piece, or for a group that is genuinely identical in product, quantity basis, condition, and location. Give it a stable ID and record the complete specification, reel count, individual remaining length, condition, and whether the length is measured, documented, or estimated.
A grand total can appear at the bottom for orientation, but it should not replace the rows that create it. One thousand feet across several short pieces and sites is not the same record as one thousand feet on a single identified reel. Preserve the pieces so the reviewer can see where the quantity and handling questions actually belong.
- Use one row per reel or continuous piece unless all material facts match.
- Keep a quantity-basis field beside every length.
- Record complete product details instead of a generic wire label.
Make the photo set follow the same identifiers
Use the inventory ID in each filename and list those names on the matching row. A practical image set includes the tag or jacket printing, a whole-reel view, visible condition, and the storage context needed to distinguish similar-looking reels. A warehouse overview can provide context, but it should not stand in for line-level identification.
If one image represents several reels, state exactly which ones and only where their material details truly match. Do not use a clear tag from one reel as evidence for a neighboring reel with an unreadable label. That shortcut is a frequent source of mismatched quantity and specification records.
- Use the same ID in the spreadsheet and every filename.
- Show tag or jacket printing, whole reel, and visible condition.
- Identify image coverage that is representative rather than reel-specific.
Keep sites and release authority separate
Group rows by actual storage site, even when one organization controls more than one place. For each group, state the location description, who owns or controls the offered material, who can authorize release, and whether the lot is offered together or as defined sublots. This prevents a list from silently treating separate locations as one accessible inventory.
If authority is unresolved, mark it as unresolved rather than naming a person who merely has access to the area. The buyer can then understand that the material record is complete enough to review while release confirmation remains a separate condition to be addressed before any movement discussion.
- Name each site and its associated line IDs.
- Record ownership or release authority per site group.
- State whether the inquiry is one lot or defined sublots.
Describe handling constraints without assuming transport
For every large reel or site group, provide known dimensions, whether a weight is gross, net, or unknown, available loading resources, gate or security procedures, and physical access constraints. These fields describe the setting; they do not commit either party to a carrier, equipment, or transport plan.
When a field is unknown, make that useful by naming the verification needed. For example, note that loading equipment availability is unknown and identify the site contact who must confirm it. Do not invent a weight from reel size or treat a site address as proof that access has been cleared.
- State gross, net, or unknown for every weight figure.
- List known dimensions and site restrictions.
- Mark unavailable loading information and the confirmation needed.
Use infrastructure context carefully and show the correction
Johnson County Public Works states that it designs, constructs and maintains road and bridge infrastructure in the unincorporated area and administers the Stormwater Management Program and County Assistance Road System. That fact supplies only local public-infrastructure context for a hypothetical changed-scope inventory; it does not say that any county material is offered, identify product construction, or establish authorization to sell.
An illustrative record could show OP-BL-01 at Site A with 500 feet documented and OP-BL-02 at Site B with 90 feet estimated, each with its own image names, while loading equipment availability remains unknown. This is not a purchased lot. It corrects the common mistake of reporting a single 590-foot total without showing which reel is where, how the quantity was established, or who controls release.
- Keep unknown access information visible instead of turning it into a transport assumption.
- Restore line-level and site-level details before submitting a bulk-lot inquiry.
