Dear Sir/Madam,
I can give you a simple solution for this modeling task. there will be a one excel model which have two tabs call "data entry" and "Dash Broad". what you have to do is just paste data in to the data entry tab and press a button call "update", then the reports will be generated in the "Dash Broad" tab. I can develop all the information you wanted here and provide a filters to filter your data. so you can easily use the model by yourself.;-)
you can visit my profile to see my qualifications, experience and ratings, and if you are comfortable, I am ready to start this task.
I assure you that I will go beyond your expectations.
I look forward to hearing from you,
Best regards,
Priyal