These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, December 10, 2014

Brevium Insurance Code VBA Script

Executive Summary

Brevium Inc. is a software company that provides doctors with software to reactivate lost patients, to keep track of patients due for appointments, etc. Currently Brevium only serves a small number of specialized doctors, including ophthalmologists and dermatologists, but management would like to add the ability for Brevium software to be able to serve more types of specialties. Part of this expansion includes adding more insurance codes to our software. A consultant has been hired to provide us insurance codes. The codes are changed into regex form and put into our database. Now the test team has been given the responsibility to test to make sure that all the codes in the database are in the spreadsheet and vice versa. Also all codes need to be verified to be sure they apply to the specialty we are working with and any missing codes need to be added. The VBA script I created has been helping use look through all the codes to see which are missing, which are extra, and which have errors in them. 

No comments:

Post a Comment

Blog Archive