The HR tab in the Hospital.xlsx file contains the employee records downloaded from the personnel database of
Question:
"The HR tab in the Hospital.xlsx file contains the employee records downloaded from the personnel database of a fictitious hospital. Data is required in all fields except Address 2 and Phone. If a phone number is entered it must adhere to the 999-999-9999 format. At least 100 data errors exist in this file.
On the Errors tab in the Hospital.xlsx file, document each error by identifying the location of the error (ID Number), the type of error (omission, range, data entry, etc.), and the correct information if known. You receive one point for each error identified. Extra credit is available.
An additional file named Zipcode.xlsx is available as a reference. Both files are located in the Database file section in Blackboard."
In this VBA assignment, you will use Excel and VBA functions to create a program to grade the BBM325 data validation assignment.
The Errors tab in the Hospital.xlsx file contains one student's submission of the BBM325 assignment.
The Answers tab in the Hospital.xlsx file is the answer key for the BBM325 assignment and contains identified errors. However, not all the records with errors on the HR tab in Hospital.xlsx are identified.
Your solution must have the following minimum functionality:
- Identify the records that appear on the Error tab and appear on the Answer tab.
- Identify the records that appear on the Error tab that do not appear on the Answer tab.
- Append missing legitimate error records to the Answer tab.
- Grade the assignment (the number of unique errors records identified).
- After completion of the grading, have the ability to run the program again on a new submission, rerun the current submission, or exit the program.
https://drive.google.com/drive/folders/1TELaiurIGcmphnBvQ4QOohxDhSB1G2nw?usp=sharing
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe