#1
|
|||
|
|||
Resource availability graph
Hi all
I'm quite new to Project, but have used it for simple things in the past, so finding all features isn't that hard. I do have an issue I can't seem to find a solution for. Let me sketch our situation. In our organisation, we have 3 types of projects/tasks: 1. long therm projects (~1 year of work) 2. short therm project (few days work, only a couple of people involved) 3. repair projects The first type is actually the only type we can plan in advance. The 2 others (especially the last one) mostly have a higher priority, and are announced only a few days/weeks in before their deadline. For that reason, we don't use full time workload when we are planning the long therm projects. Depending on the type of resource, we specify between 25% and 75% workload, and also take that into account when specifying the duration of the tasks within the project. When we receive new short therm and repair projects, we would like to have an overview of when we have resources available. That way we can see were a certain resource still has workload available to perform that task. For example: The long therm project has a task(1) with a duration of 2 weeks, 2 resources working on it, one at 50%, the other at 25%. We receive a task(2) that will take 2 days to complete by 1 resource. It has to be done in week 2 by one of the resources working on the task in the long term project. We also receive a task(3) that will take 0.5 day and needs both resources. It also has to be done in week 2. We would then need to have an overview that shows a calendar/graph of all resources in week 2. This would then show that resource 1 is 50% available, and resource 2 is 75% available. We then have a choice of how we can assign the resources to these 2 new tasks. A: Resource 1 does task(3), resource 2 does task(2) and task(3). B: Resource 1 does task(2) and task(3). Leaving resource 2 available for other unexpected work. To make these decisions, we need to have an overview of all resources. It should also show the availability, not their workload in the long therm project. Is something like this possible? Cheers Tom |
#2
|
|||
|
|||
You have a couple of options - the best I can suggest is the Resource Usage view zoomed out to show weeks. Then add Remaining Availability to the timescaled portion (right hand side) of the view. That will show you on a weekly basis how many available hours that resources has based upon their max units and work already assigned.
|
#3
|
|||
|
|||
Thanks Julie
This seems like a possible solution. Although I'd like to see daily numbers, not weekly/monthly. How can I keep seeing daily numbers when zooming out? Is it also possible to show coloured cells in that table? Similar to like what you can do in Excel? 2h = red, 4h = orange, 6h= green, 8h = white Cheers Tom |
#4
|
|||
|
|||
You certainly can zoom in to see daily numbers, but not while showing a weekly time scale.
Regarding the colors - no sorry. You can color all assignment rows a different color - but not individual cells. |
#5
|
|||
|
|||
Is there no possibility to show date scale, when zooming out? I can't see any reason not to, as there is still enough space to show the data.
Also, in the resource usage, it shows all the tasks of each resource. Can this be collapsed so I only see a list with resource names? |
#6
|
|||
|
|||
You can change the labels that appear in the timescale by right clicking at the top of the Gantt chart in the timescale area and selecting Timescale from the shortcut menu. The set the label as desired.
Regarding the Resource Usage view - there is something amiss. You should see triangles to the left of each resource's name allow you to collapse the assignments up to just show summary data for the resource. Do you have a filter applied in the second screen shot? |
#7
|
|||
|
|||
I found that by adjusting the size in the Timescale options, I can view up to 10 weeks while still showing the available time per day (in a readable font size).
I didn't show 2 screenshots. It was 1 screenshot where the Gant chart was the main view, and the Resource Usage was the detailed view. But when I tried the other way round, I can indeed collapse the resources. Seems like you can't collapse items in the details view. |
#8
|
|||
|
|||
Great. Glad you have it sorted.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to use Resource Graph to show task percentge | mr_stone | Project | 3 | 12-02-2015 08:54 AM |
Reds, but there still availability???? | patrickd123 | Project | 3 | 04-24-2015 01:30 PM |
column clustered bar graph with a line graph as secondary axis | Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
Priority of line graph vs bar graph in terms of front to back positioning on a chart | DavePPointuser | PowerPoint | 1 | 04-30-2014 10:57 AM |
Visualisation of resource availability | Antares | Project | 1 | 08-22-2011 02:36 AM |