Resource Non-working time

[DamianJR]

Hi,

I'm currently a very basic user of this software and need help with the creation of a Forward Resource Prog.

Basically I have approx 15 individuals to which various projects/tasks are assigned.
I need to be able to view all of these individuals and their assigned tasks in a single Gantt chart. It's my intention to have the individual’s name under which their tasks will be indented.
The problem is that I need the Gnatt Chart to show holiday periods for each individual in order that I can see when they are on leave and how this affects the projects they are currently assigned.
I know that you can assign each task with a resource and that the software will extend the period allocated by the number of non-working days that fall within that period, but it only extends the bar rather than automatically split the bar or shade the chart with non-working time which is really what I need it to do.
I'm currently using the 2000 edition of Microsoft Project

Any help anyone can give would be much appreciated.

Regards

Damian

 

[PDQBach]

Can't be done on the View | Gantt display. (Well, it "sorta" can but you'll need to do some VBA and run the macro each time.)

The closest you can come is to create a Summary task "Vacations". Underneath you'll have tasks like "Bob's Vacation" task with a Must Start On constraint and assign Bob; "Mary's vacation" and assign Mary.

Then, one at a time, filter on each Resource and print out the display. You might find it useful to Tools | Options | View-tab and clear the box next to "Show summary tasks".

 

[DamianJR]

Thanks PDQBach.

I've done a bit of Excel VBA before with help from another forum but i guess this is going to be quite an excercise so i guess that't that then.

Oh well.

Damian

 

[PDQBach]

Sorry about that. The Excel data model is much, much simpler compared to the Project one. Maybe you should just export (or copy & paste) from Project into Excel and write a trivial macro to propagate a formula using the REPT function to create the bars there.