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

Housing/Apartment Search

Executive Summary:
The main purpose of the project is to make it easier for the students to find the available housings, who are looking for one. The excel goes through the KSL and Craigslist web site to gather the available rooms/housings available after it captures the required features the user inputs in the user form. The web query results obtained from KSL is written in the “KSL” sheet, and results obtained from Craigslist in the “Craigslist” sheet.  The results are then filtered to match the exact location and the exact number of bedrooms the user enters in the user form. The filtered results are then written in the sheet “result”. If the user enters “any” for the number of beds and baths, then the excel checks only for the exact location and brings up every available housings/ apartments available in that location. The top of the “result” sheet is filled with the city, zip code, number of beds, number of baths, maximum price, and minimum price, the user enters in the user form. The total number of results obtained is recorded as well in the “result” worksheet.

No comments:

Post a Comment

Blog Archive