Find pricing data on a web site, average all prices and put into a spread sheet

Closed - This job posting has been filled and work has been completed.

Job Description

I need for you to go to this web site, http://average-apartment-rent.realtor.org/ and get the price of the highest listed 2 bedroom apartment for each zip code in the city listed on the spread sheet that I've attached here. All zip codes are in the U.S. state of Georgia. After you have the prices, I need for you to average all of the prices for all of the zip codes for each city, and put the average in the spread sheet. I have done the first three cities for you so you can see what I want and also see how I computed the average 2 bedroom rental price. Use the same formula that I did to compute the average 2 bedroom rental price. I need this completed 24 hours after you accept the contract.

Open Attachment