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