Work Effort / Enterprise Duration

[Ryan]

In a custom field, Enterprise Duration Fields, what formula can be written to
provide "resume date minus todays date" while taking into account
weekends and holidays, etc.

im trying to create a variance field between how much work has been
completed vs how much work SHOULD have completed, without using any baseline
fields.

This is, of course, in the thick client.

Ryan

 

[Dale Howard [MVP]]

Ryan --

In the future, please post your Project Server questions in the
microsoft.public.project.server newsgroup, as this newsgroup is devoted to
the Microsoft Project desktop application only. To answer your question,
you might try the following formula in a custom enterprise task Duration
field:

IIf([Resume]=ProjDateValue("NA"),0,ProjDateDiff([Resume],[Current
Date],"Standard"))

The above formula assumes that you are using the Standard calendar as the
Project Calendar for all projects (click Project - Project Information to
set it). The formula also traps an error caused by an NA value in the
Resume field when a task has not yet started. Hope this helps.

 

[Ryan]

Awesome! This Project is looking fantastic. I was going to post this
addition in Project Server Forums, but I figured it would be more helpful if
you had your previous answer to refer to..

Keeping the existing rules in the provided formula, I want to set a custom
field to a "5d" (or any value i wish) for tasks that should have started "2d"
ago and have no %Complete /actual hours. (NA in the Resume Field)

I hope thats not too confusing..

I want to identify, by a high variance, tasks that have started but have no
%Complete associated with time. (Actual Hours)

Ryan :-D

Ryan --

In the future, please post your Project Server questions in the
microsoft.public.project.server newsgroup, as this newsgroup is devoted to
the Microsoft Project desktop application only. To answer your question,
you might try the following formula in a custom enterprise task Duration
field:

IIf([Resume]=ProjDateValue("NA"),0,ProjDateDiff([Resume],[Current
Date],"Standard"))

The above formula assumes that you are using the Standard calendar as the
Project Calendar for all projects (click Project - Project Information to
set it). The formula also traps an error caused by an NA value in the
Resume field when a task has not yet started. Hope this helps.

In a custom field, Enterprise Duration Fields, what formula can be written
to
provide "resume date minus todays date" while taking into account
weekends and holidays, etc.

im trying to create a variance field between how much work has been
completed vs how much work SHOULD have completed, without using any
baseline
fields.

This is, of course, in the thick client.

Ryan

 

[Dale Howard [MVP]]

Ryan --

How about you try writing the formula based on the formula I gave you, and
then post your trial formula if you can't get it to work? I want to make
you independent rather than dependent.

Awesome! This Project is looking fantastic. I was going to post this
addition in Project Server Forums, but I figured it would be more helpful
if
you had your previous answer to refer to..

Keeping the existing rules in the provided formula, I want to set a custom
field to a "5d" (or any value i wish) for tasks that should have started
"2d"
ago and have no %Complete /actual hours. (NA in the Resume Field)

I hope thats not too confusing..

I want to identify, by a high variance, tasks that have started but have
no
%Complete associated with time. (Actual Hours)

Ryan :-D

Ryan --

In the future, please post your Project Server questions in the
microsoft.public.project.server newsgroup, as this newsgroup is devoted
to
the Microsoft Project desktop application only. To answer your question,
you might try the following formula in a custom enterprise task Duration
field:

IIf([Resume]=ProjDateValue("NA"),0,ProjDateDiff([Resume],[Current
Date],"Standard"))

The above formula assumes that you are using the Standard calendar as the
Project Calendar for all projects (click Project - Project Information to
set it). The formula also traps an error caused by an NA value in the
Resume field when a task has not yet started. Hope this helps.

In a custom field, Enterprise Duration Fields, what formula can be
written
to
provide "resume date minus todays date" while taking into account
weekends and holidays, etc.

im trying to create a variance field between how much work has been
completed vs how much work SHOULD have completed, without using any
baseline
fields.

This is, of course, in the thick client.

Ryan