Dear Sir
This project seems interesting and doable based on my past experience with this type of problem.
THE SOLUTION:
============
I have done in the past +50 dinamyc dashboards so I can easily do this project. I will use VBA macros to populate the data you need for the associated graphs / tables.
I can start working on a FREE SAMPLE. Just send me a message here on Freelancer.com with more details / files.
Thanks
ABOUT TABLASSUS SOFTWARE:
==========================
I've been working on this kind of work on the past 8 years (handling complex data in excel files). In my actual work I deal with complex data structures (using excel) so achieving your goal shouldn't be a problem.
I have +20 years of programming experience being highly skilled in Visual Basic (VB or VBA for applications).
I have a daily job on a worldwide well know corporation (Bureau Veritas) as programmer / consultant. I also teach Physics, Math and chemistry.
I also excel at Math, Statistics and genetic algorithms applied to computation.
I have Skype / MSN in case you need to schedule up a meeting. I have excellent communications skills / english language background.
Even so, it seems a very nice and challeging project.
Feel free to ask for more details / information
Looking forward to hear from you and start this interesting project.
Best regards
Filipe Francisco , VB Expert
==============================
Tablassus Software
"Simple solutions for complex problems"