Duration

[Duncan]

I am fairly certain I have done this before, but I am really drawing a blank
for some reason....

MS Project 2003 (SP2)

I need to show a colum that shows days planned to be worked on a set of
tasks - not the calendar time it is going to take to complete it.

For example:

There are 3 tasks in a group of tasks. They each take 2 days to complete.
BUT... the third tasks is delayed to start 5 weeks hence due to a
predecessor. I want a column that shows "6 days" - the actual work planned
to be executed on a task - not "31 days" since the 5 week delay gets included
in the task summary row.

A wrinkle in this would be if two of the three tasks were occuring on the
same days - could I show 6 days or 4 days or both?

I went through a bunch of the columns that I could insert, but nothing
seemed to work.

I may be overthinking this and it may be simple, but I am at a loss....

Thanks!

 

[Jan De Messemaeker]

Hi,

You are confusing Work with Duration.
Project will add up work the way you want - you yourself use the expression
Work, but not Duration.
There are two ways to solve your problem.
First, you assign a resoruce to each task, in such a way that now Prpoejct
can calculate Work - and give you the sum on a summary task.

Or, you absolutely want the sum of the durations. Then customize a Durationx
field as follows
Formula: =[Duration]
Rule for summary tasks: Rollup, Sum
This fielmd will now behave as you wnt it to.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Duncan]

Thanks very much. It worked...

I now have a SUM of the WORK being done during the DURATION of the grouped
task.

Any idea on how I would accomplsh the wrinkle as I described below:

Tasks that are occuring over the same days...

Task 1 - 5 days in week 1
Task 2 - 10 days in week 6
Task 3 - 5 days in week 1

The DURATION shows 30 days (since the tasks are grouped).
The new SUM formula above shows 20 days.
What I want to see as another custom column is 15 days - essentially showing
that work is only happening over 15 of those days.

Thanks....

Hi,

You are confusing Work with Duration.
Project will add up work the way you want - you yourself use the expression
Work, but not Duration.
There are two ways to solve your problem.
First, you assign a resoruce to each task, in such a way that now Prpoejct
can calculate Work - and give you the sum on a summary task.

Or, you absolutely want the sum of the durations. Then customize a Durationx
field as follows
Formula: =[Duration]
Rule for summary tasks: Rollup, Sum
This fielmd will now behave as you wnt it to.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

I am fairly certain I have done this before, but I am really drawing a
blank
for some reason....

MS Project 2003 (SP2)

I need to show a colum that shows days planned to be worked on a set of
tasks - not the calendar time it is going to take to complete it.

For example:

There are 3 tasks in a group of tasks. They each take 2 days to complete.
BUT... the third tasks is delayed to start 5 weeks hence due to a
predecessor. I want a column that shows "6 days" - the actual work
planned
to be executed on a task - not "31 days" since the 5 week delay gets
included
in the task summary row.

A wrinkle in this would be if two of the three tasks were occuring on the
same days - could I show 6 days or 4 days or both?

I went through a bunch of the columns that I could insert, but nothing
seemed to work.

I may be overthinking this and it may be simple, but I am at a loss....

Thanks!

 

[Jan De Messemaeker]

Hi,

Can you trry to be precise? How do I understand 10 days inWeek 6?
And if I write a VBA procedure (macro if you like), can you implement it?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Thanks very much. It worked...

I now have a SUM of the WORK being done during the DURATION of the grouped
task.

Any idea on how I would accomplsh the wrinkle as I described below:

Tasks that are occuring over the same days...

Task 1 - 5 days in week 1
Task 2 - 10 days in week 6
Task 3 - 5 days in week 1

The DURATION shows 30 days (since the tasks are grouped).
The new SUM formula above shows 20 days.
What I want to see as another custom column is 15 days - essentially
showing
that work is only happening over 15 of those days.

Thanks....

Hi,

You are confusing Work with Duration.
Project will add up work the way you want - you yourself use the
expression
Work, but not Duration.
There are two ways to solve your problem.
First, you assign a resoruce to each task, in such a way that now
Prpoejct
can calculate Work - and give you the sum on a summary task.

Or, you absolutely want the sum of the durations. Then customize a
Durationx
field as follows
Formula: =[Duration]
Rule for summary tasks: Rollup, Sum
This fielmd will now behave as you wnt it to.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

I am fairly certain I have done this before, but I am really drawing a
blank
for some reason....

MS Project 2003 (SP2)

I need to show a colum that shows days planned to be worked on a set of
tasks - not the calendar time it is going to take to complete it.

For example:

There are 3 tasks in a group of tasks. They each take 2 days to
complete.
BUT... the third tasks is delayed to start 5 weeks hence due to a
predecessor. I want a column that shows "6 days" - the actual work
planned
to be executed on a task - not "31 days" since the 5 week delay gets
included
in the task summary row.

A wrinkle in this would be if two of the three tasks were occuring on
the
same days - could I show 6 days or 4 days or both?

I went through a bunch of the columns that I could insert, but nothing
seemed to work.

I may be overthinking this and it may be simple, but I am at a loss....

Thanks!

 

[Duncan]

Sorry... 10 days in Week 6 was a poor example.

Task 1 - 5 days in week 1
Task 2 - 2 days in week 6
Task 3 - 5 days in week 1

The DURATION shows 30 days (since the tasks are grouped).

The new SUM formula above shows 12 days.

What I want to see as another custom column is 7 days - essentially showing
that work is planned to happen over 7 of those calendar days.

If I can apply a VBA procedure to a custom column, then Yes, that would be
great. I need to be able to display/print the column.

Thanks....

Hi,

Can you trry to be precise? How do I understand 10 days inWeek 6?
And if I write a VBA procedure (macro if you like), can you implement it?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Thanks very much. It worked...

I now have a SUM of the WORK being done during the DURATION of the grouped
task.

Any idea on how I would accomplsh the wrinkle as I described below:

Tasks that are occuring over the same days...

Task 1 - 5 days in week 1
Task 2 - 10 days in week 6
Task 3 - 5 days in week 1

The DURATION shows 30 days (since the tasks are grouped).
The new SUM formula above shows 20 days.
What I want to see as another custom column is 15 days - essentially
showing
that work is only happening over 15 of those days.

Thanks....

Hi,

You are confusing Work with Duration.
Project will add up work the way you want - you yourself use the
expression
Work, but not Duration.
There are two ways to solve your problem.
First, you assign a resoruce to each task, in such a way that now
Prpoejct
can calculate Work - and give you the sum on a summary task.

Or, you absolutely want the sum of the durations. Then customize a
Durationx
field as follows
Formula: =[Duration]
Rule for summary tasks: Rollup, Sum
This fielmd will now behave as you wnt it to.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
I am fairly certain I have done this before, but I am really drawing a
blank
for some reason....

MS Project 2003 (SP2)

I need to show a colum that shows days planned to be worked on a set of
tasks - not the calendar time it is going to take to complete it.

For example:

There are 3 tasks in a group of tasks. They each take 2 days to
complete.
BUT... the third tasks is delayed to start 5 weeks hence due to a
predecessor. I want a column that shows "6 days" - the actual work
planned
to be executed on a task - not "31 days" since the 5 week delay gets
included
in the task summary row.

A wrinkle in this would be if two of the three tasks were occuring on
the
same days - could I show 6 days or 4 days or both?

I went through a bunch of the columns that I could insert, but nothing
seemed to work.

I may be overthinking this and it may be simple, but I am at a loss....

Thanks!

 

[Jan De Messemaeker]

Hi,

Your reply didn't comfort me... VBA procedures are entered through the VB
Editor.
There is a topic on how to enter code in Jack Dahlgren's website
www.masamiki.com

And here is some code:

Sub DaysAtWork()
Dim Job as task
dim TSVS as timescalevalues
dim tsv as timescalevalue
for each job in activeproject.tasks
if not job is nothing then
set tsvs=job.timescaledata (StartDate:=job.start, EndDate:=job.finish, Type
:= pjTaskTimescaledWork, TimeScaleUnit := pjTimescaleDays])
job.number1=0
for each tsv in tsvs
if val(tsv)>0 then job.number1=job.number1+1
next tsv
end if 'nothing
next job
end sub

After running that Number1 field will contain what you need.

Hope this helps,







--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Sorry... 10 days in Week 6 was a poor example.

Task 1 - 5 days in week 1
Task 2 - 2 days in week 6
Task 3 - 5 days in week 1

The DURATION shows 30 days (since the tasks are grouped).

The new SUM formula above shows 12 days.

What I want to see as another custom column is 7 days - essentially
showing
that work is planned to happen over 7 of those calendar days.

If I can apply a VBA procedure to a custom column, then Yes, that would be
great. I need to be able to display/print the column.

Thanks....

Hi,

Can you trry to be precise? How do I understand 10 days inWeek 6?
And if I write a VBA procedure (macro if you like), can you implement it?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Thanks very much. It worked...

I now have a SUM of the WORK being done during the DURATION of the
grouped
task.

Any idea on how I would accomplsh the wrinkle as I described below:

Tasks that are occuring over the same days...

Task 1 - 5 days in week 1
Task 2 - 10 days in week 6
Task 3 - 5 days in week 1

The DURATION shows 30 days (since the tasks are grouped).
The new SUM formula above shows 20 days.
What I want to see as another custom column is 15 days - essentially
showing
that work is only happening over 15 of those days.

Thanks....

:


Hi,

You are confusing Work with Duration.
Project will add up work the way you want - you yourself use the
expression
Work, but not Duration.
There are two ways to solve your problem.
First, you assign a resoruce to each task, in such a way that now
Prpoejct
can calculate Work - and give you the sum on a summary task.

Or, you absolutely want the sum of the durations. Then customize a
Durationx
field as follows
Formula: =[Duration]
Rule for summary tasks: Rollup, Sum
This fielmd will now behave as you wnt it to.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
I am fairly certain I have done this before, but I am really drawing
a
blank
for some reason....

MS Project 2003 (SP2)

I need to show a colum that shows days planned to be worked on a set
of
tasks - not the calendar time it is going to take to complete it.

For example:

There are 3 tasks in a group of tasks. They each take 2 days to
complete.
BUT... the third tasks is delayed to start 5 weeks hence due to a
predecessor. I want a column that shows "6 days" - the actual work
planned
to be executed on a task - not "31 days" since the 5 week delay gets
included
in the task summary row.

A wrinkle in this would be if two of the three tasks were occuring
on
the
same days - could I show 6 days or 4 days or both?

I went through a bunch of the columns that I could insert, but
nothing
seemed to work.

I may be overthinking this and it may be simple, but I am at a
loss....

Thanks!