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

Tuesday, December 4, 2012

Automated Project Setup (APS)

APS is a user form designed to add a level of automation to the new research project setup process at BYU’s Grants & Contracts Accounting (GCA). GCA is responsible for handling the accounting for private and federal research grants. Prior to APS, once a new grant or contract was formed, GCA manually added each project to its various tracking mechanisms. Similar data was input into multiple spreadsheets and templates. To improve accuracy and eliminate the need for manual duplicate entries of identical data, this form accepts all data required and inputs the data into the appropriate excel files.  Additionally, the form is capable of sending emails to notify individuals responsible for new research grants that their projects have been setup.


No comments:

Post a Comment

Blog Archive