Build a line record that survives a second look
A large cable lot becomes confusing when one grand total hides different products, damaged reels, and storage sites. Give each reel or continuous piece a stable line reference and use the same reference in the inventory, photo filenames, and related files. If several reels are genuinely identical, say how many there are and retain the per-reel footage basis rather than replacing it with a single lot figure.
The characteristic mistake is using one clean reel photo and a combined footage total for a mixed lot held at several locations. Resolve it with one line per reel or continuous piece, then keep specification, condition, site, and release facts tied to that line. A total can be added as a summary, not as a substitute for the detail.
- Stable line or reel reference for every inventory row.
- Manufacturer, part number, designation, metal, size, count, and rating when known.
- One line per reel or continuous piece before creating a lot summary.
Make photos and documents answerable to the inventory
Use the line reference in every filename and note what the image shows: tag, jacket print, spool face, accessible end, or visible condition. A spreadsheet should contain the matching filenames so someone can move from a row to its evidence without guessing. One representative photo cannot establish the markings or condition of a different reel at another site.
A document belongs with a line only when it identifies that reel or product record. If a file supports a group of truly identical reels, state the group and retain individual references. If the relationship is uncertain, record it as an unmatched document rather than using it to make all rows look complete.
- Photo filenames that include the exact line reference.
- Tag, jacket-print, overview, and condition views for the related reel.
- Document link or an explicit unmatched-document note.
Separate quantity, condition, and unknowns by reel
For each line, record continuous footage and label it documented, measured, or estimated. Add reel count, visible damage, material history, dimensions, and any weight with its stated basis. A gross loaded-reel weight is not the same as a cable or conductor weight, so identify it as gross when that is what the record shows.
Unknown footage does not require a fictional precision. Preserve the visible label, note the limitation, state the estimate method if there is one, and keep the line separate from reels with documented lengths. This is more useful than spreading an aggregate total across individual reels without evidence.
- Continuous footage per reel and documented, measured, or estimated basis.
- Visible condition and known material-history status.
- Gross, net, or estimated weight basis and reel dimensions when available.
Treat each storage site as part of the inventory
Group rows by actual storage site and retain site-specific gate, dock, loading-equipment, and access information with the reels held there. Name the person or role authorized to release each group, or mark the authority unknown. When ownership or authority differs across sites, do not collapse those differences under one lot-level contact.
Site facts describe the seller’s known constraints; they do not promise a collection method, schedule, or purchasing result. If a constraint still needs confirmation, mark it clearly. A line-by-line location record helps prevent the wrong reel from being associated with the wrong access or release information.
- Storage site and access restriction for each line group.
- Release authority or unknown status tied to that site.
- Gate, dock, and available-equipment facts where known.
Apply local context only as a prompt for actual access details
The City of Irvine mobility page describes travel by bike or e-bike, on foot, bus and train, and identifies an extensive network of open spaces, protected bikeways and safe school routes.
That citywide mobility description does not tell a buyer how a particular cable lot is stored or accessed. Its limited relevance is a reminder to record the actual site constraints for each Irvine inventory line rather than assume that a city-level transportation description answers a reel-specific access question.
- Illustrative inventory example—not a purchased lot: BL-IRV-01.
- Specification: matching product recorded; one reel, 500 ft documented.
- Site: Site A; loading equipment unknown.
- Second line: BL-IRV-02; same product, 90 ft estimated, Site B.
