Build a reel-level roster before making totals
Give every reel or continuous piece a stable line ID and use it in the inventory and photo filenames. Record product group, manufacturer or part number, designation, conductor metal, size, marked rating when known, reel count, and per-reel continuous length. Group items only when the specification and evidence genuinely match.
A total can appear as a summary after the underlying rows are complete, but it should not replace them. If an item lacks a readable label, retain it on its own unknown line rather than using a nearby reel as a proxy for the entire group.
- Line/reel ID
- product group
- photo filename
- manufacturer/part number
- designation
- metal/size/rating
Keep quantity basis with each physical line
Record per-reel footage as measured, documented, estimated, or unknown. A documented 500-foot reel and an estimated 90-foot reel remain different records even when they have a similar product designation. Do not convert several short lengths into a single continuous length just to simplify the spreadsheet.
Use current quantities, not an unexplained original inventory total. When a quantity comes from a tag, packing list, or count, describe that basis. When it is an estimate, identify the reason and keep the estimate visibly separate from documented lines.
- Reel count
- per-reel length
- quantity basis
- current record source
Preserve the site and release differences
A multi-site lot needs site or storage location, condition, access restrictions, and a release contact on each line or site group. The same product at two locations may have different condition records or different people able to authorize release. Do not collapse those differences into one generic location field.
Describe actual access limitations and available loading equipment in neutral terms. If release authority is not yet known, say so. The point is a workable seller packet, not an implied promise that a particular transport or handling arrangement is included.
- Site/storage location
- condition
- access restrictions
- release contact
- loading equipment
Add dimensions and weight without overstating them
For large reels, record available dimensions and a gross, net, estimated, or unknown weight basis. A gross figure should identify whether reel and packaging are included. These handling facts belong with the individual line because a large reel at one site may differ substantially from the same cable family at another.
Add the seller’s site timetable only when known and treat it as a planning field. It does not determine the terms of a transaction. Unknown dimensions, weight, or access can remain unknown while the more complete lines are presented accurately.
- Dimensions
- gross/net weight basis
- loading equipment
- site timetable
Use local context and correct the grand-total mistake
The City says its business resources include maps, parking, commuting resources and environmental considerations, plus building resources for property and commercial-land development. This public resource description is limited local context for recording a seller’s actual storage and access details; it does not identify inventory, customers, or a Redmond purchasing history.
The common mistake is one grand-total footage figure that hides separate reels and sites. The correction is one row per reel or continuous piece with a quantity basis and site grouping. Illustrative fictional inventory record—not a purchased lot: BL-01; one reel; 500 ft documented; Site A. BL-02; same product family; 90 ft estimated; Site B. Separate site contacts; authorization not yet confirmed.
- Do not merge Site A and Site B into one footage line.
- Label each site’s release contact and quantity basis.
