1.0 Take input (City name) from the user. The city where the user wants to buy a home.

2.0 It opens the browser and types in the name of the city provided on Zillow.com and performs filtration.

3.0 Scrapes the data indicated and stores them in an Excel file.

4.0 Add new columns to the Excel file and calculate the price per square foot of the house. 

5.0 Fill in all the newly added columns by predefined conditions using delimiters in Excel and short the column.