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

Thursday, December 10, 2015

Capital Needs Analysis Report - Bradley Westwood

Executive Summary

The business that I built my project for has asked not to be
named, but it is a large non-profit organization. Each year this business does
what it calls a capital needs analysis. Basically there is a schedule of when
all of their capital assets should wear out and each year they inspect a
portion of their capital assets and determine which ones need to be replaced.
Based on that inspection they create different projects for each capital asset
that they are going to replace based on that year’s inspection. My program
allows them to track the budget and expenditures in each of these projects as
well add new projects for assets that need to be replaced, but that were not
included in the original budget.

http://files.gove.net/shares/files/15f/bmwpara/writeup.pdf

http://files.gove.net/shares/files/15f/bmwpara/Westwood_Bradley.xlsm

Note: All project names have been changed and all dollar figures have been replaced by randomly generated numbers.