Assign a stable reference to every reel and site
A multi-reel inventory becomes hard to review when a single grand total covers different specifications, conditions and storage locations. Give each reel, or a genuinely identical group, a stable line reference. Use that reference in the spreadsheet, image filenames and any record you attach, while retaining the continuous footage for each physical reel.
Group inventory by actual storage site before grouping it by total quantity. State which lines are offered together, the address or ZIP kept in the inquiry record, the site-specific release contact and the access constraints. A warehouse, yard and project location should not be treated as one location merely because they are under one seller.
- Line or reel reference used in every file
- Manufacturer, part number and specification
- Storage-site group and included lines
- Site release contact and access restriction
Show the basis for footage, weight and handling details
For every reel, identify whether the footage is measured, documented or estimated. Keep a reel’s continuous length visible instead of converting several pieces into one notional length. If weight is included, state whether it is gross loaded-reel weight, cable weight, conductor weight or unknown; these are different facts.
Record reel dimensions and the loading equipment that is actually available at that site. Where a dimension or weight is unknown, say unknown. This gives a realistic description of the seller’s inventory without treating a handling discussion as a commitment to collect or move the cable.
- Per-reel footage and quantity basis
- Gross, cable, conductor or unknown weight basis
- Reel dimensions where available
- Available loading equipment and constraints
Close the photo and release loop line by line
Match a readable tag, jacket-printing image, reel overview and any visible-condition note to the same line reference. One pristine reel image cannot document every item in a mixed lot. If a line has an unreadable label or a condition exception, record it against that line instead of letting a representative photo hide the difference.
Add the person or role that can authorize release, the requested timetable if known and the site-access notes. If authority, footage or location grouping is still unresolved, keep it marked unknown or pending. The goal is a clear line-item inquiry, not an assumption that the entire lot can be released together.
- Tag, jacket-print and overview photos matched to the line
- Visible condition note for each exception
- Release authority for each site group
- Unknown or pending fields stated explicitly
Use Orange access context without promising movement
The City of Orange describes the city as centrally located in Orange County with access to highways, airports and ports.
That local context makes seller-supplied location, access and loading fields relevant to a multi-site record. It does not promise trucking, establish a pickup route or prove that a cable lot is available. Each storage group still needs its own documented inventory and authority to release it.
- Keep site logistics as seller-supplied facts
- Do not turn access context into a transport commitment
Replace the grand total with a workable lot record
The specific mistake is using one grand total for several sites and one intact reel photograph as evidence for the entire inventory. Correct it by splitting the list by site and line reference, preserving every continuous length and attaching a distinct record for each different specification or disclosed exception.
Illustrative inventory record: BL-OR-01 at Site A has one reel with 500 ft documented; BL-OR-02 at Site B has one reel with 90 ft estimated. Both use matching product-designation records, but the conductor-weight field is unknown and the access notes are separate. This fictional record demonstrates why site grouping and quantity basis matter.
- BL-OR-01: Site A, one reel, 500 ft documented
- BL-OR-02: Site B, one reel, 90 ft estimated
- Conductor weight: unknown; separate access and release notes
