University Student VBA Projects

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 6, 2012

Heat&Mass, Game and Model


Executive Summary
Part one of my project is a program that will calculate the heat balance on a piece of squared metal. The upper and lower edges of the metal will have a constant temperature of 0, while the left and right edges of the metal stays at the temperature of 100. User will give the width and the length of the metal, while my VBA code will compute the steady state temperature distribution. A steady state means every slot on the metal, excluding the edges, should have a temperature that’s the average of the four slots around it. 
Part two of my project is a program that intends to resemble a plinko game. The plinko board consists of 9 input slots and 9 output slots. The input slots (0-8) represent the starting location of the chip, while the output slots represent the amount of money you win for each chip. There are also 12 rows of pegs, with the top row having 9 pegs, and the bottom row having 8 pegs. The chip will randomly turn to right or left when it hits the pegs.
 Part three of my project is inspired by the difficulty that BUS M 401 students have been facing when first start building financial models in excel. The requirement from the teacher was to forecast the future performance of a company according to the current year’s income statistics. The model has to be interactive and interconnected, meaning the whole model should change when one assumption input is changed. This program will build a simple model, using one year’s income statement and three assumptions. It will be beneficial for students, because this program offers a quick way for students to see how the change in assumption will affect evaluation of the company. 

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Blog Archive