SPI calculation..Urgent


I

invincible

I am trying to calculate the SPI for all possible cases using
Microsoft Project 2007.
The SPI calculation is working fine for the cases in which BCWP < BCWS
i.e. when SPI
is less than one..But for the cases in which BCWP > BCWS it is giving
the SPI as 1 and not greater than one..On close inspection i found
that in the resource usage table , watever extra work has been done on
a day is shifted to the next day..Thus if im setting my status date to
the current date , it is giving SPI equal to one..I hope u get my
problem!!

Is this a bug in MS Project?? If not what is the way out of it??

Thanking you in advance.

Cheers,
Shishir.
 
Ad

Advertisements

I

invincible

How are you updating your assignments? If a day has more than the planned
amount of work doesSPIcalculate as you expect?

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

---------------------------------------------------------------------------­-------------------------









- Show quoted text -
Hi Rod ,
Thanks for the reply..
Well if im entering the amount of actual work greater than the planned
work , this extra work for some unknown reason is shifting to the next
day..as a result the SPI is always turning out to be one..

Cheers.
 
R

Rod Gill

How are you entering the actual work? If you are entering it in actual work
column then Project assumes max units each day and if that matches baseline
work for day SPI should be 1. For accuracy you need to enter actual hours in
actual work row of a Usage View, then extra hours for the day stick and SPI
would be >1.

So how are you updating Project, what are you entering where?

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------


How are you updating your assignments? If a day has more than the planned
amount of work doesSPIcalculate as you expect?

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

---------------------------------------------------------------------------­-------------------------









- Show quoted text -
Hi Rod ,
Thanks for the reply..
Well if im entering the amount of actual work greater than the planned
work , this extra work for some unknown reason is shifting to the next
day..as a result the SPI is always turning out to be one..

Cheers.
 
R

Richard ORENGO

Hi,
I have the same problem to have the SPI value greater than 1. I enter actual work in "% achieved column".
I have defined 2 tasks beginning at T0, duration of 10 days each and defined baseline at T0.
At "status date" = "T0 + 5 days", % achieved work for each task is 75% (entered in the %achieved column).
The Work Performed at "T0+5days" is 75%.
The Work Planned at "T0+5days" is 50%.
But (BCWP = BCWS) and so the SPI is always egual to 1. Please, could you explain me ?
 
Ad

Advertisements

R

Richard ORENGO

Hi,
I have the same problem to have the SPI value greater than 1. I enter actual work in "% achieved column".
I have defined 2 tasks beginning at T0, duration of 10 days each and defined baseline at T0.
At "status date" = "T0 + 5 days", % achieved work for each task is 75% (entered in the %achieved column).
The Work Performed at "T0+5days" is 75%.
The Work Planned at "T0+5days" is 50%.
But (BCWP = BCWS) and so the SPI is always egual to 1. Please, could you explain me ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top