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

Friday, December 11, 2009

BOb Transaction Report Analysis Project

Executive Summary:

Brigham Young University is a private university located in Provo, Utah owned by the Church of Jesus Christ of Latter-day Saints. The university uses an accounting information application called Business Objects for its budgeting and financial reporting processes. One of the reports that can be generated by Business Objects is called the transaction report. This report gives a detailed list of a specific department’s transactions (revenues/expenses) for a given period. The purpose of my VBA final project is to develop a VBA application that can take data from several of these reports, perform a few basic analytical procedures, and provide useful information for the user to better understand their department’s processes and costs.

To complete this project, I had to overcome several VBA hurdles. The first of these was getting VBA to look into the correct folder where the user’s business objects transaction reports were stored, open these reports, and copy the required data to my own spreadsheet. This data was then sorted, checked for duplicates, and formatted for use. In a form, the user then selects the periods and accounts for which they want to perform the analysis. My application takes these selections, creates an additional worksheet for each selected account and then includes and formats the data for the periods that the user selected. These spreadsheets are then formatted to give the visual and numerical results of the analysis. Each time the spreadsheet is opened, the user has the option to keep the existing data, or begin another analysis.

Full Write Up

Project File

Auxiliary Source Files (Extract the folder from this zipped file so you can use it when running the main project file)

Flash Video Example (Watch this to see an example of how the application runs)

1 comment:

  1. When using the file to see how it works, note that the auxiliary source data has been dummied up, so it may not reflect what an actual departments costs may look like.

    Also, please note that the application takes a few minutes to run.


Blog Archive