Hi - I require an Excel 2010 Dashboard creating (must also work on Excel Mac 2011).
This is a fairly blank canvas - I have attached an Excel file you can use as a template, it has a few worksheets which I will eventually populate with data, data includes dsProgrammeStatus, dsRisks, dsIssues, dsChangeControl. The master Worksheet which should hold the dashboard is called Dashboard.
Quite simplay I require the Dashboard page to be an extremely clean, easy to read, impressive dashboard linked to the "ds" prefixed worksheets and include (from the top):
- A dynamic table displaying the Programme Status (Programme Name, Status), the status should be coloured accordingly depending on the RAG value
- To the right of the table there needs to be a pie chart showing the number of Programmes in each RAG status
- Below the above - A Risks matrix. The attached example already has something in place.
- To the right of the matrix a dynamic table with the top 10 Risks should be shown (the top 10 is based on Severity score). Note - The fact that the Matrix has different column widths shouldn't effect the table next to it or below.
- A dynamic Issues table, top 10
- Next to which a Issue horizontal bar showing Issue Age. x axis less than one week, less than one month, more than 1 month, more than 2 months, more than 6 months. Y axis: number of issues
- Finally a Change Control vertical bar chart showing the number of changes per Programme
A strong use of colour should be used where necessary.
The ds worksheets will be populated by the client when necessary and all of the charts, tables etc. should then automatically update.
Please forward me a working example in order to be chosen - a quick turnaround is required (2 days max). If you can supply a semi working example straight away you will probably be awarded the project :)
Thanks
Hi, as manegement accountant and business intelligence consultant with many years of experience in Excel and data analysis I´m the perfect match for your project. Please find my fully functional sample meeting half the requirements in my PM. Kind regards, Nico Vondegracht
Team of vba experts , we will finish this work in 12 hours , please see pm for more detail , i have gone through you job posting and ready to start work !!!
I am a MS Excel expert and have over 15 years experience programming in VBA. I have constructed several dashboards for various industries over the years. If you are looking for a quality dashboard that has been debugged properly then we should continue the conversation. In addition, I am a fantastic project communicator which ensures the project tasks constantly aligns to your project objective.
Sending you a sample dashboard with interactive "quadrant" graph, "speedo" dials and grid. This will let you decide for yourself whether I can provide what you want.
Happy to work under a Confidentiality and Non-Disclosure Agreement if needed, starting as soon as you pay the Retainer Milestone into the site.
More details on the Private Message Board.
Bob Allen-Turl
Hello,
I am a Microsoft Trainer and MOS Expert. I would like to send you an example of template I just used for another client. I have tons of experience creating custom reports and templates from scratch. More notes can be found in your private messages.
Thanks.