Building Permit Reclassification

We need a solution (app, batch routine, script, or VB program) that will:
1. Import an Excel spreadsheet.
2. Perform a few defined data quality checks on the imported data.
3. Perform a data modification using a provided MS Access lookup table.
4. Export the modified data to an Excel spreadsheet.

Outline of Workflow for Permit Reclassification Application:

It is anticipated that the overall workflow of the permit reclassification application would be as follows:

1. We obtain the three permit reports from a municipality and copy these reports to a particular
network storage location.
2. Using the Permit Reclassification Application (e.g., the “Application”) import routine, We select the
Municipality and select from one of the three input types. The application then imports the Excel
spreadsheet.
3. The application performs the data quality checks as defined in the above section “Data Quality
Checks Needed by Application”. The application provides to the user a list of exceptions if any are
found.
4. The application then reclassifies the permits and then exports the permits to an Excel spreadsheet.
The application creates a standardized file name containing the date and time for the output
spreadsheet. Ideally, for any date fields, the application would be able to set in the Excel
spreadsheet the date fields as an Excel “Date” data type.