Apartment Comparison Tool

For the past 4 years, my wife and I have been managing a condo here in Provo.  One of the challenges we face every year is deciding what is the appropriate rent and security deposit to charge our students for the upcoming year. Historically, we have had to log onto the BYU Off campus Housing Portal, search through the different listings, look up each listing’s individual information, and then see how that apartment compares to our apartment. This process not only takes several hours, but it is extremely tedious.

This semester as I prepared to go through this process once again, I realized this was the perfect opportunity to automate something using VBA to try and save time.  I created the Provo Apartment Comp Tool to help automate and simply the comparison process.  The tool logs onto the BYU web portal, navigates to the listings page,  searches for listings that meet the correct criteria, pulls the data into excel, and then re-formats the data in a simple and easy to view comparison page.






Writeup: http://files.gove.net/shares/files/14w/pflclub/Final_Project_Writeup.pdf
Rental Comparison Tool: http://files.gove.net/shares/files/14w/pflclub/RentalCompTool.xlsm