Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I get gantt charts to reflect non-working days for part-time workers?

332 views
Skip to first unread message

Simon Cropper

unread,
Jan 28, 1999, 3:00:00 AM1/28/99
to
I am trying to get the gantt chart to reflect the actuals days worked on a
project by each worker rather than have a bar extending from the start date
to the end date. If all workers work according to the standard calender you
can tell MS Project to draw non-working days (weekends and holidays) in
front of the bars on a gantt chart for one resource calender but what if
different workers work different days. If a part-time employee works
Monday, Wednesday and Friday, project will extend a bar from Monday to
Friday the same as a full time employee working on the task all week.

What I would like to do is have a diagram, that I can give to my clients at
the start of a project, that illustrates (using bars) the days each worker
is spending on each task.

I have tried to find a way of superimposing multiple calenders onto one
gantt chart but there does not appear to be any options available in the
menus. Are there Visual Basic routines in existence that can do this?
Another possible solution I was thinking about was to allocate a resource's
non-working time to a reaccurring task and then use the tracking gantt
chart. Messy, especially since I already have separate calenders for each
resource.

Has anyone else come across this problem? How did you solve it?

Thanks Simon

Simon Cropper (Principal Consultant)
Botanicus Australia Pty Ltd
scro...@botanicus-aust.com.au

Simon Cropper

unread,
Jan 28, 1999, 3:00:00 AM1/28/99
to

Simon Cropper

unread,
Jan 28, 1999, 3:00:00 AM1/28/99
to

Jim Stuart

unread,
Jan 29, 1999, 3:00:00 AM1/29/99
to
Try this in a test project.

Create a task of 40 Hours 'Work' with a 'Duration' of 5 days. Assign a
resource to this task.

Go to the Resource sheet view, you should see that resource at 8 hrs per day
for five days in a row. Now place your cursor in the date block for a day
the employee will not work (say day two in this exercise) and enter zero
(0). Next go to day 4 and enter zero. Now move to beyond day 5 of the task
(say day seven) and enter 8 hours and at day 9 enter 8 hours.

You should be back to 40 hours total work, but split across more than the
original five days. Now go back to the Gant Chart view. What you should see
is what appears to be a spilt task only with multiple splits, one piece of
the bar for each day worked.

Hope this helps
Jim Stuart

Steve House

unread,
Jan 30, 1999, 3:00:00 AM1/30/99
to
The Gantt chart bars indicate when a task starts and is finished, not the
work involved to complete it. You could use the split task option to create
a display such as you describe, showing the intervening non-working days on
a task, but why? It only gives you a distorted chart. Remember to use the
work contour so the work performed each day is an accurate reflection of
when things are actually getting worked on.

To reiterate, the Gantt chart bar is intended to reflect the calendar dates
a task begins and ends, not what happens in between.


Simon Cropper <scro...@ozemail.com.au> wrote in message
news:01be4a83$ad1bbd00$LocalHost@simon-cropper...


>I am trying to get the gantt chart to reflect the actuals days worked on a
>project by each worker rather than have a bar extending from the start date
>to the end date. If all workers work according to the standard calender you
>can tell MS Project to draw non-working days (weekends and holidays) in
>front of the bars on a gantt chart for one resource calender but what if
>different workers work different days. If a part-time employee works
>Monday, Wednesday and Friday, project will extend a bar from Monday to
>Friday the same as a full time employee working on the task all week.
>

@botanicus-aust.com.au

0 new messages