REO Pricing Heatmap Editor

Cancelled

Job Description

Download and Update the Adobe Illustrator (AI) file, that we call a "heatmap".
https://docs.google.com/open?id=0B-5fEGzbemRvdm9rY1JvNldJTVk
(You may need to be logged into a google account in order to view this. If you don't have one, create one for free).

1) The colors of the states and the colors of the lettering/numbering must be changed to match what is found in the "State Color / Lettering color" column on the spreadsheet linked below.

2) The numbers themselves must be updated on the heatmap to match the numbers from the "REO" column of the linked spreadsheet below. If there is no number in that column, then there should be no number in the state. However, the state code should remain.

3) The font and size should remain unchanged. You may only change the color, not the size or the style.

4) Change the date in the upper right corner to the date in the name of the .xls spreadsheet. For example: 11/27/2012

5) Exceptions to the colors specified in the spreadsheet are:
a) For small states with letters and numbers over the "grey ocean", where the spreadsheet calls for grey lettering, use WHITE lettering instead.

6) Know the USA state layouts. For example, MI, VA and NY all have 2 "pieces" on the AI heatmap, so when you change the color of the main body of the state, you have to also change the color of that state's "small piece". See the examples here:
https://docs.google.com/open?id=0B-5fEGzbemRvQWRBb3FFcktLejg
https://docs.google.com/open?id=0B-5fEGzbemRvRXNURlpZUU5JS0U
https://docs.google.com/open?id=0B-5fEGzbemRvZFk4TFFySS00a2c

-----------------------------------------------------------------------

The spreadsheet link is here:
https://docs.google.com/open?id=0B-5fEGzbemRvZk82MjFMQ0U4SnM
(You may need to be logged into a google account in order to view this. If you don't have one, create one for free).

The final product should be delivered as an editable AI file.

This project must be completed within 4 hours after being hired. If I hire you and is not completed in that timeframe, unfortunately, I will have to end the contract without payment.

Thanks, and good luck!
-AJ

Other open jobs by this client