Asset Register Cleanup and Duplicate Review by Sam ZeninAsset Register Cleanup and Duplicate Review by Sam Zenin

Asset Register Cleanup and Duplicate Review

Portfolio project
Sam Zenin
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.
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.

Tags