Build a row that survives a multi-site handoff
Assign a stable line or reel ID before grouping anything. Use that ID in the inventory, photo filenames, and supporting documents. Each row should retain manufacturer, part number, specification match, reel count, continuous length, quantity basis, and condition. A combined total can be added later, but it cannot replace the records that explain which reel is where.
This task is most useful when the same product appears at more than one site. Two reels with matching jacket print can still have different footage, visible condition, access restrictions, and release contacts. Keeping them distinct avoids an inquiry that appears complete only because its differences were hidden in an aggregate.
- Use one permanent ID for each reel or continuous piece.
- Retain specification, footage, quantity basis, condition, and site on each line.
- Group matching products only after their reel-level records remain visible.
Keep quantities per reel before calculating totals
Record a continuous length for each reel and label it measured, documented, estimated, or unknown. A total of 1,000 feet split across ten partial reels is not the same as one 1,000-foot length. Keep the reel count and per-reel length available even where an internal spreadsheet also uses a site or lot total.
If one reel lacks a readable tag or a measured balance, do not assign the best documented neighboring reel’s quantity to it. Give the uncertain reel its own row and state what evidence is missing. That lets a buyer understand both the confirmed inventory and the portion that needs a closer review.
- Show reel count and continuous length per reel rather than only total footage.
- Label every quantity as measured, documented, estimated, or unknown.
- Keep uncertain reels out of a claimed documented aggregate.
Make the photo set prove the line reference
For each inventory line, pair a readable tag or jacket image with a reel overview and a file name that includes the line ID. Where site context matters, add an image that shows the actual storage area without substituting it for a product identifier. A single representative image should not be used for reels that have different labels, conditions, or sites.
Use the caption or inventory note to explain whether a photo supports a documented tag, a visual condition observation, or an estimate. This avoids the common error of treating a broad warehouse image as evidence for every reel’s length and specification.
- Use the inventory ID at the start of the photo filename.
- Capture a tag or jacket legend and a reel overview for the same line.
- State when a photo documents an estimate rather than a direct identifier.
Separate sites, authority, and access constraints
Group lines by actual storage site and identify the business role that can authorize release for each group. Then record site restrictions, dimensions, gross or net weight basis, access, and available loading resources. These facts allow an accurate lot discussion without treating a yard description as a transport commitment.
Local context: Columbia Public Works designs, builds, operates and maintains streets, bridges, sidewalks and parking infrastructure and oversees public transit; its page also describes a four-mile I-70 Business Loop corridor safety audit. This public description does not identify cable stock, sellers, or demand; it is limited context for why a contractor or public-works inventory needs site-specific records rather than one city-wide total.
- Use a site group and storage location field for every line.
- Keep release authority and access restrictions specific to the actual site.
- State dimensions and a weight basis per reel or package when known.
Handle unresolved lines without concealing them
A multi-site file can still be useful when a reel has unknown length, missing manufacturer information, or an unresolved release contact. Keep the row, label the missing field, attach the available photo, and say what could resolve it. Do not merge unknown reels into a site total simply to simplify the list.
This page differs from surplus release reconciliation because its organizing decision is traceability across multiple locations, not whether a project balance is currently available. It differs from industrial and metal-specific pages because it can manage mixed cable families without pretending that one construction record covers the whole lot.
- Create a discrete row for an unknown reel rather than hiding it in the total.
- Record the evidence gap and the next record or photo that could resolve it.
- Preserve separate site groups until each reel and authority can be matched.
