It's nothing fancy and im probably over complicating work for myself but my thought is to import data from dat files into a spreadsheet to keep track of the following
1. Which roms i have in my set
2. Which roms im excluding from my set
I try to only have 1 rom per game but cant just select US or Europe roms since some were released exclusively in only one region so I was going through each set and selecting which roms to keep.
The problem occurs when a new dat file is released, how do I know what new games were added. Depending on the system, the miss list would be very large due to me only keeping one rom per game so it would be hard to identify what new games were added.
So my plan was to export the data to a table in a spreadsheet use a compare function to look at the crc32 values and indicate any new games that aren't already listed in the previous dat file.