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 10, 2010

Analytic Hierarchy Automated Decision Making Process


The first semester of my graduate program in Public Administration I took a Decision Analysis class that used Excel as it’s primary tool to teach us how to make informed future decisions using what is called the Analytic Hierarchy model.  The model involves entering in the alternatives and objectives you have for a decision, then comparing both the alternatives to each other and the objectives to each other to see why objectives are more important and which alternatives are more desirable when compared.  With that information and through a bunch of formulas, a summary page is created that shows which alternative wins most often in a series of trials.  It is rather tedious to recreate all of these formulas and tables each time you want to make a decision, so I created a VBA project that automates the process.  Using a series of buttons, user forms, and input boxes, I take you through the process of entering in the pertinent data and then Excel automatically crunches the numbers and comes up with a summary page.  


 

No comments:

Post a Comment

Blog Archive