Todays Job Posting!

We have the outline and concept for a spreadsheet that we would like to be automated. Said spreadsheet will pull data from the google analytics API and display the results in a series of "Dashboard" style worksheets and some detail level worksheets.

A few requirements.

1) The process to collect and report the data must be completely Automated. The data from Analytics needs to be pulled from Google Via the API/XML Feed. I would assume that some sort of automated cron with an application that pulls the data and pushes it into a database would be the easiest solution. mySQL or SQL Server 2005 is the preferred database in this case. The application/script could be written in any language or run on any server. I would guess it is possible to contain this all in excel as well. The developer would have creative control on the best way to make this happen.

2) While in general the data requested is not to horribly difficult to do (standard web analytics) the presentation of the dashboard worksheets must be "Executive Friendly" which means the reports will be going to Board Of Directors, CEO Ect Ect no the ideal fit for this project would know the ins and outs of doing things like micro charts and slick dashboard design.

We are doing this as a fixed price please bid the time and your cost as accurately as you can. 

If you have examples of previous excel work that you would feel is relevant to this. Then please tell me in your response.

Ignore the Budget we have posted. Bid what you feel is accurate. This project should not take more than a week.