Build one auditable line for every reel
Use one stable reference in the spreadsheet, photo filename, and correspondence for every reel or continuous piece. Record manufacturer, part number, complete designation, condition, and per-reel footage with a measured, documented, or estimated basis. Group only products that are genuinely identical, while preserving each reel’s reference and length.
The Michigan Economic Development Corporation reported a Dearborn Wagner Place plan involving 12 west-downtown parcels, a $60 million Ford Land Development investment and a long-term plan for as many as 600 Ford employees at the site. That reported redevelopment history is local context for keeping inventory and release groups precise; it does not identify cable at the site or any transaction.
- Line or reel ID
- Manufacturer, part number, and complete designation
- Continuous length and quantity basis
- Condition and matching photo filename
Do not replace reel evidence with a grand total
A total footage figure may be useful as a summary, but it cannot replace the number of reels, the length of each continuous piece, or differences in specification. One photo also cannot document several different reels. Match photographs to the line reference and retain condition differences, missing labels, and unknown fields beside the right item.
For a lot that includes several matching reels, list the reels separately first and add a group total only as a second line of explanation. This protects the usable-length distinction between, for example, one documented full reel and one shorter estimated reel.
- Reel count
- Continuous length per reel
- Measured, documented, or estimated status
- Photo and document references
Map sites and release scope separately
When material is stored at more than one location, identify the site for each line rather than treating the city as one warehouse. Record the site contact, access restrictions, available loading resources, known dimensions or weight basis, and the role that can authorize release. Keep different authorization paths visible even if the material may eventually be discussed together.
State whether the inventory is offered as one defined group or as separate sublots. If release authority is pending, label it pending. This is a practical seller decision about what can be offered, not a promise that trucking, handling, or timing has been agreed.
- Storage location and site contact
- Access restriction and available loading resources
- Dimensions and weight basis
- Lot grouping and release authority
Repair the one-photo, one-total listing
The mistake is using one grand-total footage figure and one photograph for reels with different specifications or sites. Repair it with one row per reel or continuous piece, a matching photo reference, and separate site, condition, and specification fields. Estimated footage should stay marked as estimated rather than being added to a documented figure as though both were equally certain.
If an item is incomplete, keep its stable reference and describe the missing field. A known next contact or pending authorization can be listed as pending without turning uncertainty into a firm release statement.
- No pooled footage without per-reel rows.
- No shared photograph for different specifications.
- Unknown release authority stays pending.
Use a fictional two-site lot record
Illustrative inventory example—not a purchased lot: BL-D-01 is one matching product reel with 500 feet documented at Site A. BL-D-02 is a second reel of the same product with 90 feet estimated at Site B. Their photo filenames match their references, and Site B release authority is not yet confirmed.
This illustration shows why a sum alone is not enough. A real submission should identify its own site contacts and access facts and should not carry an unconfirmed authority from one location to another.
- Line 1: BL-D-01; 1 reel, 500 ft documented; Site A
- Line 2: BL-D-02; 1 reel, 90 ft estimated; Site B
- Photos: filenames match line references
- Release: Site B authority pending
