Calculations

[Angela]

Can someone tell me if there is a formula I can use to put
into a project file that will calculate % complete of my
baseline schedule dates? What I would like to have is my
% compelte column for current schedule, and a column that
shows where my % complete would be if I had stuck to my
baseline.

Thanks,
Angela

 

[JackD]

The earned value fields should give you this.
Budgeted Cost of Work Performed (BCWP) is the first part. From that the SPI
(schedule performance index) is calculated automatically.
Go to project help and read about "Earned Value".
If that doesn't sound like what you want, then yes, there is a way using
some visual basic code to figure this out.
-Jack

 

[Angela]

Unfortunately "the powers that be" do not want to see the
SV% or the SPI. They would like a "black & white" straight
forward column that contains Planned % Complete right next
to the % Complete column. I am not familiar with VB, so
is there anyone that can help.

Thanks,
Angela

 

[JackD]

To start, can you tell us how planned % complete would be calculated?
Based on duration? work? From which baseline? What about tasks without a
baseline? Any limitations on the tasks which should have this number? Should
it be calculated based on current date or from status date (I recommend
status date)? Any other conditions that the calculation needs to take into
account?

If you can supply answers to those questions then writing the code is fairly
straight forward.

-Jack

 

[Angela]

Planned % complete based on duration with all items having
a baseline. No limitations I know of, and it should be
calculated based on status date.

Thanks for the help,
Angela