Build a traceable row for every physical item
A bulk lot becomes difficult to review when a single total hides different reel lengths, specifications, storage sites, or access contacts. Assign each reel or continuous piece a stable reference. Use that reference in the inventory, photo filenames, documents, and the matching-specification group field. A group may share a designation, but each physical reel still needs its own record for footage and location.
Record manufacturer or part number when available, reel count, footage per reel, and the measured, documented, estimated, or unknown quantity basis. Add condition, dimensions, gross, net, estimated, or unknown weight, and any site access limitations. These fields make a multi-location file usable without suggesting that every reel has one condition or that transport has been arranged.
- Assign one reel or line ID to every physical item.
- Repeat the same ID in the photo filename and document reference.
- State footage per reel with its quantity basis.
- Keep specifications, condition, dimensions, and weight basis on the item line.
Keep locations and release contacts separate
Group rows by actual storage site, but do not collapse their release details. For each location, record the owner or custodian, the person who can authorize release, access restrictions, and available loading information where known. A photograph from one yard should not stand in for a reel stored somewhere else, even where the product marking appears similar.
If a field is unknown, put unknown in the worksheet and describe the evidence that is available. A missing release contact, an estimated footage figure, or an unconfirmed loading resource is a real distinction. Leaving it blank or assuming it applies across sites creates the very ambiguity this multi-reel task is designed to resolve.
- Name the actual storage site for each reel.
- Record site-specific condition and access limits.
- Identify owner or custodian and release contact separately.
- Label unavailable loading information or documentation as unknown.
Use Quincy project context only to organize records
Quincy’s Engineering Department oversees Public Works infrastructure projects and coordinates with the Building, Zoning, Planning, Conservation and other municipal departments and agencies. That is relevant only as a reminder that a project-related lot may have more than one record holder or location. It does not prove a multi-reel lot exists, identify its cable specifications, or give the buyer authorization to move material. The seller’s row-level inventory and release contacts remain the evidence that connects a physical reel to a site.
Where documents mention a project or department, capture that reference in the document field beside the exact reel ID. Keep the project reference distinct from ownership and release authority. This lets a seller follow a practical paper trail while avoiding a broad claim that city activity establishes the contents or availability of the offered lot.
- Use project or department names as document references only.
- Match every reference to a specific reel or piece.
- Do not use one representative photo for multiple sites.
- Keep ownership and authorization fields separate from project context.
Worked multi-site record and the one-total mistake
Illustrative example—not a purchased lot: references BL-Q-07A and BL-Q-07B; matching product designation recorded; Site A has one reel with 500 ft documented; Site B has one reel with 90 ft estimated; photos are BL-Q-07A_tag.jpg and BL-Q-07B_tag.jpg; site-specific loading resources unknown. It demonstrates one record per reel rather than one grand-total figure.
The frequent mistake is using a single total and one representative photo for reels with different sites and quantity bases. Correct it by retaining a separate row, photo set, condition note, and release contact for each item. If reels later prove identical and co-located, the specification group can connect them without deleting the facts that make each physical item traceable.
- References: BL-Q-07A and BL-Q-07B (illustrative only).
- Site A: one reel, 500 ft documented.
- Site B: one reel, 90 ft estimated.
- Access: site-specific loading resources unknown.
