Reconcile four sets of records
Background:
I had a set of handwritten data. I had four seperate people (coders) enter the information from the handwritten pages into a spreadsheet. As expected, the data should be roughly the same but is not due to different intrepretations of the hand-written data. This is the input.
The deliverable I seek is a spread sheet containing a single set of data for two types of criteria:
1)records that were common to all four coders
2)records that were not common to all four coders (thus four seperate spreadsheets)
The records can be indexed by the three fields:
Field1
Field2
Field3
Open the attached folder and refer to the "read me" and "Merge smaple snapshot" for an example of the project.
See notes under deliverables for more details.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
+++++++++++++++++++++++++++++++++++++++
The finished product should be an excel workbook (.xls) containing five tabs: Common records, and then unmatched records by coder. Do not send the spreadsheet back in .xlsx (Excel 2007) format. No not use any special formating like merged cells, bold formatting, borders, and the like please.
++++++++++++++++++++++++++++++++++++++++
## Platform
excel