Copy information from [login to view URL] and [login to view URL] for specified cars and input data in a spreadsheet. See details for more info.
## Deliverables
For each of the following cars, you need to enter the data for the 5 cheapest options that are within 75 miles of ZIP Code 08817, and the 3 cheapest options in the whole USA (So 8 entries per car). There are 22 cars, so there should be a total of 176 rows in the Excel Table.
1. Audi TT 2008-2012 Certified, Navigation
2. Audi TT 2008-2012 Used, Navigation
3. Audi A5 2008-2012 Certified, Navigation
4. Audi A5 2008-2012 Used, Navigation
5. Audi S5 2008-2012 Certified, Navigation
6. Audi S5 2008-2012 Used, Navigation
7. Audi Q5 2008-2012 Certified, Navigation
8. Audi Q5 2008-2012 Used, Navigation
9. BMW 3 Series, 2008-2012, Certified, Navigation
10. BMW 3 Series, 2008-2012, Used, Navigation
11. BMW 5 Series, 2008-2012, Certified, Navigation
12. BMW 5 Series, 2008-2012, Used, Navigation
13. Ford Mustang 2009-2012, Used, Navigation
14. Infinity G Models 2008-2012, Used, Navigation
15. Nissan 350Z 2008-2012, Certified
16. Nissan 350Z 2008-2012, Used
17. Nissan 370Z 2008-2012, Certified
18. Nissan 370Z 2008-2012, Used
19. Porsche Cayenne 2008-2012, Certified
20. Porsche Cayenne 2008-2012, Used
21. Porsche Caymen 2008-2012, Certified
22. Porsche Caymen 2008-2012, Used
For each of these cars, the following details are required (see attached table - These will be the columns of the table)
* Make
* Model
* Certified (Y/N)
* Year
* Mileage
* Price
* Miles from ZIP 08817
* Exterior Color
* Interior Color
* Body Style
* Seller Name
* Bluetooth (Y/N)
* Navigation (Y/N)
* Keyless Entry (Y/N)
* Leather Seats (Y/N)
* URL to Page
Notes:
1. Note that when I say cheapest, start with cars that are priced at more than $5000 (so don't put a row in the excel table if the car's price is less than $5000) .
2. See attached file (How To [login to view URL]) for example of screenshots on the searched
1. You can go to "expanded search options" to select Navigation as an option
2. In section "Which cars are you interested in?", you can choose "Certified Cars" or "Used Cars"
3. In section "Where will you look", you will first need to search within 75 miles of Zip Code 08817, and then go back and search for Any Distance of 08817
4. In section "What makes and models would you like to see?", you will need to select the car model and make. You will need to do the searches for 1 Model at a time so that you can easily get the results for only the model selected.
5. In section "How much do you plan to spend", you need to enter $5000 as the Minimum Price
6. In section "Choose your Specifications", you need to choose:
1. Transmission = Automatic
7. In "What features are you looking for" section, you need to check "Navigation" if needed for that specific Model.
8. In "Sort By", choose "Price - Low to High"
3. Attached is also the Excel document with the column names needed. Please fill in this document
Thanks!
Karim T