Re: Actual % complete versus Planned % complete
- From: van_der_veen_eric@xxxxxxxxxxx
- Date: Wed, 16 Jan 2008 09:45:21 -0800 (PST)
On 16 jan, 16:46, Jim Aksel <JimAk...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
To properly status the schedule, first establish a [Status Date]under
Project/Project Information.... Verify all tasks with [Start]<[Status Date]
have a %Complete > 0. Also, for all tasks with [Finish]<[Status Date] they
should be 100%, if they are not 100% complete, extend the task to the right
of the [Status Date]. Move tasks with 0% Complete to the right of the [Status
Date]. There also can be no tasks with [Actual Start] or [Actual Finish]
greater than the [Status Date]. This is proper schedule preparation.
If you have properly costed resources assigned to your schedule, a status
date, and a baseline, then you should insert the Schedule Performance Index
[SPI] column. The [SPI] measures what you have actually accomplished divided
by what you scheduled to accomplish as your baseline -- a measure of 1.00
would be on schedule. SPI>1 ahead, SPI<1 behind. Explore Earned Value in
the help for more information.
Another choice, insert the [Status] column. [Status] will tell you if the
task is "complete", "future task", "late", "on schedule." Please note
[status] considers ahead of schedule to be "on schedule"
A formula can be applied to calculate the %Complete where you should be as
of the status date. The formula must address times when [Status] is (1) Prior
to [Start], (2)during the duration of a task, and, (3) after [Finish]. The
following formula can be applied to a spare column such as [Text1]:
str(IIf([Status Date]<[Start],"0",IIf([Status
Date]>[Finish],"1",ProjDateDiff([Start],[Status Date])/[Duration]))*100)+"%"
The formula can be used to compare with the %Complete field which is also a
duration based calculation.
--
If this post was helpful, please consider rating it.
Jim
Visithttp://project.mvps.org/for FAQs and more information
about Microsoft Project
"van_der_veen_e...@xxxxxxxxxxx" wrote:
Hello,
When you add the column "% complete" in MS Project, you can enter the
actual % complete. I would like to add a column, that shows the
"planned % complete". This must be calculated automatically by the
start date, the duration and the date today.
Example:
The start date of a Task is January the first. The duration is 20 days
(work and none-working), so the end date is the 20 of January. I would
add a column, that shows the "planned % complete". So suppose it is
the 10th of January today, the "planned % complete" must be 50%
automatically calculated. On the 15th of January this cell must show
the value 75% etcetera.
Is there a (simple) solution to my problem?
And if there is, what is it?
Kind Regards,
Eric- Tekst uit oorspronkelijk bericht niet weergeven -
- Tekst uit oorspronkelijk bericht weergeven -
You guys are great!
It works perfectly.
Can I reduce the number of decimals?
Now I get for instance 33,333333333%. I prefere to see 33%.
Thanks in advance!
Kind regards,
Eric
.
- Follow-Ups:
- Re: Actual % complete versus Planned % complete
- From: Jim Aksel
- Re: Actual % complete versus Planned % complete
- References:
- Actual % complete versus Planned % complete
- From: van_der_veen_eric
- RE: Actual % complete versus Planned % complete
- From: Jim Aksel
- Actual % complete versus Planned % complete
- Prev by Date: Re: Actual % complete versus Planned % complete
- Next by Date: Re: statistical graph showing percentages
- Previous by thread: Re: Actual % complete versus Planned % complete
- Next by thread: Re: Actual % complete versus Planned % complete
- Index(es):
Relevant Pages
|
