Make the inventory line—not the grand total—the unit of review
A broad total for footage or weight can conceal where each reel is stored, whether it is identified, and whether its quantity is measured or estimated. Start with one line for each reel or continuous piece. A group may share one line only when the specification, condition, location, and quantity basis are genuinely the same. Otherwise, keeping differences visible is more useful than a shorter spreadsheet.
Cambridge’s Economic Development Division maintains a listing and map of companies working in life sciences, high tech and clean energy; the city cautions that the listing is not comprehensive. That fact may help a seller orient an internal contact list, but it is not evidence of a particular inventory, an identified customer, or local purchasing demand. The working evidence is the seller’s own per-reel and per-site list.
- One reference for each reel or continuous piece.
- Manufacturer, part number, and complete readable designation.
- Per-line length and measured, documented, or estimated basis.
- Separate line when condition, site, or specification differs.
Use one reference across the spreadsheet, photos, and records
Assign a stable line or reel ID before collecting images. Put that ID at the start of every filename and repeat it in the inventory record and any supporting document note. A good minimum photo set for a line includes a reel overview, a readable tag or jacket legend, and images of condition differences that belong to that line. Do not let one clear tag stand in for several unshown reels.
When a group of matching reels shares a reference, record the count and retain a way to identify each individual reel if one has different footage, packaging, or damage. The purpose is traceability: a reviewer should be able to begin with a row and find the related images without guessing which storage group they represent.
- Stable line or reel ID.
- Photo filenames that start with that ID.
- Record reference for any existing inventory or product document.
- Separate photo and condition note for an exception within a group.
Preserve quantity and condition at the reel level
For each line, list the reel count, the continuous length for each reel or piece, and the basis for that quantity. A total of several short lengths is not the same as one uninterrupted length. If only weight is available, identify it as gross, net, or unknown and do not convert it to footage without a documented basis. Keep material type and visible condition on the same line as the quantity.
Split identified uninstalled stock, previously used material, incomplete lines, and mixed pieces into distinct groups. This prevents an intact reel from giving an inaccurate impression of a different item. It also means that unknowns remain useful: an unknown jacket designation can stay in the list if the photo reference, quantity basis, and storage location are still known.
- Reel count and continuous length per reel.
- Measured, documented, or estimated quantity basis.
- Gross, net, or unknown weight basis where weight is reported.
- Material type, history status, and visible condition note.
Keep site access and release authority attached to each group
When inventory is stored at more than one location, do not collapse sites into a single access note. Group lines by their actual storage site and include the site-specific release contact, access limitation, available loading resource, and whether the material is offered as one lot or defined groups. An internal contact at one address may not be authorized to release material at another.
The City of Cambridge says its Top 25 Employer information is collected from Cambridge employers, updated annually, and reflects employment within the city. That public information does not provide current release authority for any cable. A seller should instead document the owner and the authorized release contact for the exact inventory line or site group.
- Actual storage site for each line or site group.
- Site-specific access limitations and available loading resource.
- Owner and authorized release contact.
- One-lot or defined-group status for the inventory.
Handle incomplete data without rebuilding the whole lot
A large inventory is often assembled from warehouse exports, photos, and contacts held by different teams. Start with the best source for each line and show its basis. If one reel moves, gains a better tag photo, or receives a clarified release contact, update that line rather than rewriting the entire lot total. This keeps the audit trail intact and avoids turning a local correction into an unsupported estimate for every item.
The fictional example below demonstrates the format: two site lines retain different lengths, quantity bases, and authority status. It is not a purchased lot or a claim about actual material in Cambridge. The goal is to show the way unknowns and documented facts can coexist without being hidden in a grand total.
- Illustrative references: BL-CAM-04A and BL-CAM-04B.
- Illustrative quantity: Site A, 500 ft documented; Site B, 90 ft estimated.
- Illustrative condition: fictional mixed inventory; one history field unknown.
- Illustrative release: site-specific authority unknown.
