Use a stable reference for every physical item
A large lot becomes difficult to review when a grand total and one representative photograph stand in for several different reels. Assign a line or reel reference to each physical reel or continuous piece, and use the same reference in the spreadsheet, image filenames, and attached records.
Group items only when the designation, condition, quantity basis, and storage context are truly the same. Otherwise, the group hides the very distinctions a buyer needs to see. A concise reference system makes a large list more usable without turning unlike material into one product.
- Line or reel reference
- Manufacturer, part number, and designation
- Photo reference tied to the same line
- Clear definition of any genuine group
Keep quantity and condition at the reel level
Report reel count and continuous footage for each line, and label every quantity measured, documented, or estimated. A total of several short pieces is not the same as one continuous length. Separate full reels, partial reels, cut pieces, and mixed groups before you calculate a total.
Record condition and a gross, net, or estimated weight basis where weight is relevant. If footage is unknown, leave it unknown and state the available evidence. Do not use one tag or one reel condition as proof for stock in another location.
- Per-reel footage and quantity basis
- Condition and weight basis
- Full, partial, cut, or mixed status
- Distinct line for unknown footage or condition
Map the list to actual storage and release paths
Keep each warehouse, yard, or project location separate in the inventory. For every site group, record the location identifier, access limits, loading equipment, owner or release authority, security or escort rules, and any known seller timetable. Those facts show what still needs coordination without assuming it has been arranged.
A multi-site inquiry can still be useful, but it should say whether the sites are offered as one defined group or separate groups. If a release contact is missing at one location, flag that line instead of assuming a contact from another site can authorize it.
- Storage site and lot grouping
- Access limits and known loading equipment
- Owner or release authority
- Security rules and seller timetable
Use waterfront context carefully and keep the example fictional
The City of Richmond says the Port of Richmond provides direct waterfront access and is a key deep-water harbor handling vehicles, bulk cargo and petroleum. This city fact is limited context for documenting a storage setting; it does not establish a waterfront lot, seller relationship, or transport commitment.
A fictional two-line record might show BL-R-01 at Site A with 500 feet documented and BL-R-02 at Site B with 90 feet estimated, each with its own photo and release contact. The deliberate difference between lines is the point: a grand total would hide both site and quantity differences. It is illustrative only and not a purchased Richmond lot.
- Fictional references: BL-R-01 and BL-R-02—not purchased Richmond lots
- Site A: 500 ft documented; Site B: 90 ft estimated
- Two photo references and two release contacts
