Start with a physical balance
Use the purchase order or inventory export only as a starting reference. Walk the reels or packages that are actually offered, assign each one a line ID, and compare the original quantity with the current balance. A full reel, a partial reel and several cut pieces should remain separate records even if the part number is the same.
For each discrepancy, retain both the older record and the present basis: documented footage, measured footage or estimate. This is a reconciliation task, not a reason to inflate a balance. A line that cannot be found, has been reserved, or is still awaiting internal approval belongs in its own status rather than in the available total.
- Record inventory reference, manufacturer and part number.
- State current footage as documented, measured or estimated.
- Keep storage location and photo reference with the same line ID.
Split availability from release authority
Create a release-status field with plain values such as available for discussion, reserved, approval pending or not yet located. Name the person or role that can authorize a release, but do not treat a warehouse contact or an old order as proof that stock may be sold. Note known site restrictions beside the affected line.
A seller can include full and partial reels in one inquiry when the records stay reel-specific. Continuous footage matters: two short lengths should not be represented as one longer length. If a reel count is known but the remaining footage is not, record that uncertainty and the method proposed to clarify it.
- Separate full reels, partial reels and cut lengths.
- Flag reservation or approval-pending status per line.
- List authorized seller, site restrictions and requested release date when known.
Match documents, tags and photographs
Give image files the same line ID used in the spreadsheet. Capture the reel tag and readable jacket printing, then note the related document reference. The practical goal is traceability: a reviewer should be able to move from a listed balance to the particular reel and its supporting record without guessing which photograph applies.
Murfreesboro 2035 was approved in 2017 as a long-range plan covering transportation, land use, public facilities and economic development, with a focus on population growth and infrastructure. That is limited local context, not evidence of an offered lot; for a project change, the physical reel balance and release record remain the relevant seller evidence.
- Use stable line IDs in the sheet and photo filenames.
- Transcribe tag or jacket printing instead of a project nickname.
- Attach each document reference to its matching inventory line.
Handle missing evidence without creating availability
When a tag is unreadable or footage has not been confirmed, write unknown or estimated rather than carrying the old quantity forward. Explain the estimate basis, such as a recorded balance or a visual approximation, and leave the release status pending until the correct authority is known. This makes follow-up specific instead of reopening the entire list.
Illustrative inventory example—not a purchased lot: line OV-MB-01 is project-overrun feeder cable with the part number copied from its tag. One reel has 300 ft documented and one partial reel has 180 ft estimated; the record says uninstalled stock and release pending. The example does not say either reel is accepted or ready to move.
- Keep original-record quantity separate from current balance.
- Label unknown footage and unknown authority explicitly.
- Do not combine pending lines into the offered total.
