Re: Anticipated Finish Variance
- From: "Rod Gill" <rodATproject-systemsDOTcoDOTnz>
- Date: Fri, 6 Feb 2009 13:30:26 +1300
Hi,
If I create a Task that finishes on Dec 5 '08 and save the baseline for it then delay it to finish on Feb 6 the Finish variance = 45d which is 45 working days based on the Project calendar.
When you update % complete, make sure you delay any incomplete work to the date it will restart. With a baseline the finish variance should calculate as you go, no need to wait for an actual finish date.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
"Luca" <Luca@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:166EB14C-14C2-4683-8FA1-00862A1FF0AF@xxxxxxxxxxxxxxxx
Hi There,
A client has asked if an anticipated finish var. column could be added to
show how late (or early) a task is anticipated to finish, i.e 10days, -2days
etc.
He has said that the anticipated date is to be calculated using the overall
duration of the task, multiplied by by the %complete plus the current delay,
i.e task goes for 29 days and 90% complete, therefore = 3 days left to
complete plus current delay which is current date (say 06/02/09) less
programme finish date (say 05/12/08) = 64 days behind schedule (3 + 61). So
in the anticipated column you would have in there -64 days.
I have a Finish Var column but obviously that shows '0' until I insert an
actual finish date so then the programme can compare the planned finish date
to the actual finish date and establish the difference.
Can someone please explain if you can have an anticipated finish var. column
and how I can set up the formula so it reflects what I have explained above.
Many Thanks - Luca
.
- Follow-Ups:
- Re: Anticipated Finish Variance
- From: Luca
- Re: Anticipated Finish Variance
- References:
- Anticipated Finish Variance
- From: Luca
- Anticipated Finish Variance
- Prev by Date: Re: Mouse over definitions
- Next by Date: Re: Task cannot be modified in any way???
- Previous by thread: Anticipated Finish Variance
- Next by thread: Re: Anticipated Finish Variance
- Index(es):
Relevant Pages
|