Resource allocation for project Manager Dashboard in Excel
- or -
Post a project like this3111
$$$
- Posted:
- Proposals: 2
- Remote
- #918355
- Awarded
Description
Experience Level: Expert
Industry: Business
Description of excel work: Dashboard and Conditional formatting. Dashboard will be created for resource allocation for PM's to tasks. Showing how much allocation is left and when until for each PM. showing Red when allocation is not 100% for the PM. Warning signs when a new project is up and coming and there are no resources for this etc. So to show each of the scenarios.
Design and target audience: dashboard, resource allocation dashboard, excel, conditional formating
Extra notes: I have inherited a template for different Project Manager with % allocations against the different projects they are working on. What I need is a dashboard showing the project end date for all the resources, if they are under/over allocation. When new projects are up and coming and who can fulfil these – these would be the people whose projects are coming to an end and would have some time etc. I have uploaded the excel template.
So if a project for Nov-15 needs 100% allocation of a PM - this could be two different project managers who have 50% time each in Nov-15. The exact requirements can be handled via email. A template is attached and help need for front page and colour coding and advice appreciated ;-)
This is a spread sheet for maximum 12 Project managers - so the volume is not high at all!
It's not a complex piece of work but it requires Great Excel experience and someone who can create dashboards.
Thanks
Any help is greatly appreciated – I really appreciate your help and your expertise and ideas.
Thanks
Amarjit
Description of excel work: Dashboard and Conditional formatting. Dashboard will be created for resource allocation for PM's to tasks. Showing how much allocation is left and when until for each PM. showing Red when allocation is not 100% for the PM. Warning signs when a new project is up and coming and there are no resources for this etc. So to show each of the scenarios.
Design and target audience: dashboard, resource allocation dashboard, excel, conditional formating
Extra notes: I have inherited a template for different Project Manager with % allocations against the different projects they are working on. What I need is a dashboard showing the project end date for all the resources, if they are under/over allocation. When new projects are up and coming and who can fulfil these – these would be the people whose projects are coming to an end and would have some time etc. I have uploaded the excel template.
So if a project for Nov-15 needs 100% allocation of a PM - this could be two different project managers who have 50% time each in Nov-15. The exact requirements can be handled via email. A template is attached and help need for front page and colour coding and advice appreciated ;-)
This is a spread sheet for maximum 12 Project managers - so the volume is not high at all!
It's not a complex piece of work but it requires Great Excel experience and someone who can create dashboards.
Thanks
Any help is greatly appreciated – I really appreciate your help and your expertise and ideas.
Thanks
Amarjit
Amarjit T.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
9 Nov 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies