I treated a row as a duplicate when asset, zone, state and check date agreed. The duplicate log records the removed input ID next to the retained one.
Two locations for the same asset
For two asset IDs the source gave different zones. I retained both rows for each asset in Zone conflicts, with the original IDs and check dates, so the location can be confirmed against the operational record.
Final register
The workbook accounts for all 78 inputs across 60 released records, 14 duplicates and four rows on hold. A control checks that the three dispositions reconcile to the source.


Asset register and the two unresolved asset locations, each linked back to its input records.
0 likes · 0 views · Nov 17, 2026
Reconciled 78 asset records into 60 released entries and 14 confirmed duplicates. Four rows for two conflicting asset locations are held for review.