Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2016, 04:35 AM
Soundstorm Soundstorm is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Novice
Resource availability graph
 
Join Date: Jan 2016
Posts: 4
Soundstorm is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-25-2016, 01:13 PM
JulieS JulieS is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 01-26-2016, 08:07 AM
Soundstorm Soundstorm is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Novice
Resource availability graph
 
Join Date: Jan 2016
Posts: 4
Soundstorm is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 01-26-2016, 08:29 AM
JulieS JulieS is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #5  
Old 01-27-2016, 01:19 AM
Soundstorm Soundstorm is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Novice
Resource availability graph
 
Join Date: Jan 2016
Posts: 4
Soundstorm is on a distinguished road
Default

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?

Reply With Quote
  #6  
Old 01-27-2016, 09:02 AM
JulieS JulieS is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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?
Attached Images
File Type: jpg timescale.jpg (109.7 KB, 13 views)
File Type: jpg ru.jpg (69.9 KB, 13 views)
Reply With Quote
  #7  
Old 01-28-2016, 12:23 AM
Soundstorm Soundstorm is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Novice
Resource availability graph
 
Join Date: Jan 2016
Posts: 4
Soundstorm is on a distinguished road
Default

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.
Reply With Quote
  #8  
Old 01-28-2016, 08:07 AM
JulieS JulieS is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Great. Glad you have it sorted.
Reply With Quote
Reply

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
Resource availability graph 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft