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

Wednesday, April 11, 2012

Underwater Audio

Executive Summary 

Description of the Business
Underwater Audio is a business which waterproofs iPod Shuffles. Their main activity is buying the iPods themselves and waterproofing them (though an option to send in your iPod is available) then selling those with waterproof headphones. They sell their products in retail stores, on their own website, and through amazon. In order to determine their profit we must consider their costs. Their main cost is advertising - they spend money on Facebook, Google, and Amazon. All their current cash is also in differing locations. Namely their bank of choice, MyAccountAccess, Amazon, and Paypal.  

Overview of the System We Built
This excel file uses Professor Gove’s internet scrapper to login to all necessary accounts (listed in the previous paragraph), go to the current day, and download the current day’s data in each account to their respective tabs. All of the sites involve a login, and many have security features. The essential data to provide in analysis is then both found (providing flexibility for the data to move around a bit) and copied to one tab. Which is then inputted into the massive worksheet which contains all of the data. A graph has been made which is both flexible and dynamic this was made using extensive research and involves named ranges. The graph also can compare whichever of the fields you choose giving a R2 value -- this allows for actual correlations to be found and business decisions to be made.

Links for files:


  1. Get daily ideas and methods for making $1,000s per day FROM HOME for FREE.

  2. You might be qualified to get a free $1,000 Amazon Gift Card.


Blog Archive