Re: % Work Complete 'Variance'
- From: Shahriar Nour Khondokar <ShahriarNourKhondokar@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 May 2009 04:00:01 -0700
Andrew and Jim thanks very much to both of you for your. You don't know how
much i appreciate this help.
Andrew:
The first time u suggested using the custom formula i was actually looking
for a built in column such as '% Work Complete' that will serve my purpose.
But seems like it does not exist. So, I have decided to use Projects EVM
functionalities and the advantages it will provide like u have described.
Jim:
Following you suggestions i have have started using the 'Physical % Complete'.
For this purpose in new project plans i am assigning Standard Rate of $1 for
all resources and assigning those resources to all tasks. After that i have
saved a baseline and from Tools > Options > Calculations, i have changed the
'Default Task EVM' to 'Physical % Complete'.
From then on, for tasks that are 100 % complete, i am setting their'Physical % Complete' to 100%.
Will you please confirm that the right process has been followed (to solve
the problem this post is about)?
....
I have another question:
What do i do for projects that already have a baseline created and Actual
values (Work, Start/Finish dates) entered?
To answer this question I downloaded the white papers from your blog
regarding % Complete and came to conclusion that if i entered the Baseline
Work value in the corresponding Baseline Cost column (after assigning $1
standard rate to resources), i will be set up to solve the problem i was
discussing at the beginning of the post.
Do you agree?
"Andrew Lavinsky" wrote:
I think we're all pretty close. The question is whether you want to use
Project's native EVMS functionality with its reporting and timephased
tracking - or create a custom field which doesn't tie into the out of the box
reports, and wouldn't be timephased.
If you assign the $1/hr resource rate, you could use EVMS easily.
If not, I still think you could achieve the goal with a custom formula of
"([% Work Complete] X [Baseline Work])/60." If you are updating actual and
remaining work regularly, that will get you the number you seek.
Shahriar - why would that not work?
-A
.
- References:
- % Work Complete 'Variance'
- From: Shahriar Nour Khondokar
- Re: % Work Complete 'Variance'
- From: Shahriar Nour Khondokar
- Re: % Work Complete 'Variance'
- From: Shahriar Nour Khondokar
- Re: % Work Complete 'Variance'
- From: Jim Aksel
- Re: % Work Complete 'Variance'
- From: Shahriar Nour Khondokar
- Re: % Work Complete 'Variance'
- From: Jim Aksel
- Re: % Work Complete 'Variance'
- From: Andrew Lavinsky
- % Work Complete 'Variance'
- Prev by Date: Re: Installing a Macro
- Next by Date: Re: Is it somehow possible to automatically resize rows in Project
- Previous by thread: Re: % Work Complete 'Variance'
- Next by thread: Security on Resource pool
- Index(es):
Relevant Pages
|