Build a traceable row for every reel
Start a line-item inventory before calculating a grand total. Give each reel or continuous piece a stable line ID, then use that ID on the spreadsheet, photo filenames, and any product document. Record manufacturer, part number, product designation, and condition for that individual line. Group reels only after confirming that the product and evidence are genuinely the same.
A row is not merely an accounting device. It lets a reviewer see whether a photo, quantity, and release contact describe the same object. If a site has a mixed pallet or a reel with a faded tag, keep it as its own line and label the affected fields unknown. A general warehouse photograph cannot stand in for the evidence attached to each listed reel.
- Use the same line ID on the list and image filenames.
- Do not reuse an ID for reels at different locations.
- Keep unknown products on separate rows.
Preserve quantity and weight bases by reel
For each line, state reel count, continuous length per reel, and whether the length is measured, documented, estimated, or unknown. Do not turn several short pieces into a single continuous length. If a weight is available, identify whether it is gross or another stated basis, and do not treat it as a substitute for footage or a verified conductor amount.
When a length is estimated, note the method and keep the estimate visible rather than rounding it into a documented total. A bulk lot can still be described clearly with incomplete information when the uncertainty is attached to the correct row. This is especially important when partial reels are stored beside full reels with similar labels.
- Record per-reel footage before any lot total.
- Label every quantity measured, documented, estimated, or unknown.
- Keep gross weight distinct from cable length and composition.
Separate site access from release authority
Create a site group for each actual storage location or ZIP, then record which lines are offered together. Add the release contact or responsible role, access restrictions, reel dimensions, available loading equipment, and handling notes. A contact who can describe a dock is not necessarily the person who can release the cable, so retain those facts as distinct fields.
Describe what is known: gate restrictions, rack position, a dock, a forklift available to the owner, or an unknown loading arrangement. Do not turn these details into a transport promise. They allow the buying conversation to address the actual lot after product, quantity, and release status have been made clear.
- List storage site or ZIP and site group for every line.
- Identify release role separately from loading-contact details.
- Record access restrictions and reel dimensions as observed facts.
Use commercial-district names only as a locator
The city identifies City Center, Ridgeline and Lakeshore as commercial districts and says business districts have high-speed data, three-phase power, natural gas, and city water, stormwater and sewer utilities.
That information can help a seller name a general district or utility context, but it does not establish a cable specification, a reel quantity, access permission, or a known lot. A site name belongs in the location field alongside the actual storage facts. Each cable line still needs its own identification, current quantity basis, offered group, and release contact.
- Use the actual storage site or ZIP in the inquiry.
- Keep location context separate from product identification.
- State when combined release across sites is not confirmed.
Worked distributed-lot record
Illustrative example only—not a purchased South Burlington lot: BL-SB-01 is a documented 500 ft reel at Site A with a matching tag photo. BL-SB-02 is an estimated 90 ft partial reel at Site B with a separate photo reference. Both lines include their own product fields, site group, and release contact; combined release is shown as not confirmed.
The mistake would be reporting 590 ft with one image and one location. The correction is to retain the two rows, the two site facts, and their different quantity bases. The record does not promise that the lines will move together; it simply gives the seller and reviewer a workable basis for discussing the inventory.
- Line IDs: BL-SB-01 and BL-SB-02.
- Quantities: 500 ft documented at Site A; 90 ft estimated at Site B.
- Photo files: BL-SB-01-tag.jpg and BL-SB-02-tag.jpg.
- Release: two contacts; combined release not confirmed.
