Data Verification - Compare 2 files Month-over-Month to see differences

Open the two spreadsheets

Count the number of used cells in each

Count the number of rows and columns in each

Check if file has the same number of fields

Check the totals of each column

Check unique record counts

Check max/minimum/average/std dev/etc

Check other statistics (ex. benfords law;randomness;streak analysis)

Check if files are the same

Create the output data within file

Find where there may be issues

Drill-down to find causes

Open a new spreadsheet

Levels of difficulty

one sheet per file

Hard coded file entry

Run Button on sheet

Output in same file

Medium

Basic Error handling

Output in new file

Advanced

Service that accepts 2 files are returns the differences