Way to illustrate resource gaps over several tasks in time period

[Dan777]

Is there a way to graphically represent resource gaps when identifying tasks
over a time period...given the tasks and functional requirements are known
and a pre-determined resource pool is available?

 

[JulieS]

Hi Dan777,

Could you describe more fully what you mean by resource gaps?

Are you looking to demonstrate that you don't have enough resources
to do the tasks in the time period required?

Or, are you saying that you have work on a task which starts, stops,
restarts, stops, restarts, etc. and you want to show that stop/start
in the Gantt chart?

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Dan777]

Hello JulieS,

Your first assessment was correct. I'm looking to graphically demonstrate
(should it be the case) that I do not have enough resources over a given time
period (say 90 days) with a specified number of tasks (knowing the
requirements/bodies needed).

This could take the form of a bar graph, etc. Something useful for
managment or HR to assess a need for hiring and addressing staff concerns
over a period.

 

[JulieS]

Hi Dan,

Great, thanks for the clarification. Depending upon what version of
Project you have (2003 and earlier or 2007) you can either export
the information to Excel and then create a custom graph in excel or
create an Excel Pivot table with graph.

If you are using Project 2003 or earlier, I suggest running the
Analyze Timescaled data in Excel option from the Analysis toolbar.
View the Resource Usage view and click the button from the Analysis
toolbar. The wizard will step you through the export. I'd suggest
exporting Work (scheduled hours) and Overallocation (number of hours
above max units and calendar). You can then create the graph to
your liking in Excel.

If you are using Project 2007, try the Visual Reports and see if the
Resource Availability Report shows what you need. It will create an
Excel Pivot chart and you can graph as needed.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project