RE: SPI and Resource Graph Assistance Required

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

First, God Bless You for using Physical%Complete. IMHO it is the only way to
do it.
Excellent post!

Observations: SPI=BCWP/BCWS and it will be 0 if BCWS is 0 during the
period. That's not "stupid project", we have to go back much further than
that and blame the guy who invented x/0=infinity.

What you seek is an SPI>1. On the individual task line it will show 0.
However, at the rolled up level you are collecting BCWP. Since you will have
BCWS from other tasks during that "early" time frame, your rolled up SPI does
give you credit for the early completion of that work as long as there is
cummulative BCWS elsewhere. For the early tasks, you are enterring the real
start date in [Actual Start]?

For your next question, I think I am missing something. If I use an "Actual
Start" date and key it into [Actual Start], the Resource Usage view does move
the work to the earlier date so I am not showing the work in the baseline
period. I think what I said addresses your issue?
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project



"chris.read-smith@xxxxxxxxxxxxxxxxxxx" wrote:

Can anyone help me.

I am currently using a EPM 2003 solution at work. I have created our
plans using an earned value based off the physical % complete, which
IS what I require in the industry I work in. My plan is broken down
into stages, each stage representing a different set of tasks that is
required to do the job. On a weekly basis, I imput 'actual hours'
into my project plans and track progress and slippage from this. I
create my own reports using different views in MSP to show PV, EV,
ACWP, SV, SV%, CV, CV%, BAC, EAC, VAC, CPI & SPI. I also run off
filtered views (As MSP's built in Reports are useless) showing tasks
that should have started and tasks that should have finished. I also
run off reports showing upcoming milestones in the next month as well
as any incomplete milestones that are not complete. I create my own
SPI and CPI graphs in excel to see the trend on a week by week state
as well as convert my PV & EV into hours and run a report on this
too. So, I run alot of reports that do work and do drive the plans in
the direction I need them to go. All up its about a 26 page report
cover about 8 different plans.

However, what I have found is this. In my plan, for example, a stage
may not be planned to commence for about a month. Infact, the stage
is complete. All the work is done on this, yet we have not had this
schedule to start for a month. (The workers had worked a bit longer
and got the job done). THe problem is, because the first task in this
stage isnt planned to have started, its SPI is taking the EV and
dividing it by 0 resulting in 0 as the SPI.

I feel that in a case like this, yes, you are ahead of schedule in
that stage yet because your PV is $0.00 you SPI doesnt reflect this.
(I do realise that when this status date finally reaches the stage
then the SPI will shoot through the roof) but for now, the SPI stays
at '0'. Stupid Project!!!!

This leads into my next question. Because this work was done ahead of
schedule. How do I get a resource view to show that less work is now
required for the time that, that work was meant to have been done.
Because, really, the standard 'Resource Graph's' in project.. The
peak units, the work and all the other views in 'Format >Details' dont
reflect this. Is there a view that you can see that recoginses that
this work has been done ahead of schedule and not as much work has to
be done now for that scheduled time?

Also, each week, I run a filter that shows, "Tasks that should have
finished and havent finished". This is a good view to have. Yet it
is only as good as a resource tool that can assist it. I have heard
Primavera can do what im trying to think of but what I need is, a
resouce graph that shows me, how many men I need to complete the
unfinished work. Or do you have to keep 'rescheduling this incomplete
work' in "Update Project", reschedule the work and then look at your
resource graph. If this is the only solution this has good points and
bad points. Good being, it will paint a true picture of the work that
is required by rescheduling any incomplete work ahead of the status
date yet bad as you dont want your workers to realise that you can
just reschedule your plans anytime you dont complete a job?

Any suggestions.

Many Thanks

Chris


.

Relevant Pages

  • SPI and Resource Graph Assistance Required
    ... into my project plans and track progress and slippage from this. ... create my own reports using different views in MSP to show PV, EV, ... SPI and CPI graphs in excel to see the trend on a week by week state ... schedule to start for a month. ...
    (microsoft.public.project)
  • Re: SPI and Resource Graph Assistance Required
    ... You can have admin tasks in PWA, so you would book your 7.5h for the ... BCWS from other tasks during that "early" time frame, your rolled up SPI ... into my project plans and track progress and slippage from this. ... create my own reports using different views in MSP to show PV, EV, ...
    (microsoft.public.project)
  • Re: SPI and Resource Graph Assistance Required
    ... BCWS from other tasks during that "early" time frame, your rolled up SPI does ... into my project plans and track progress and slippage from this. ... create my own reports using different views in MSP to show PV, EV, ... This is something the business has been ...
    (microsoft.public.project)
  • Do-Nothing Democrats Force United Airlines to Ground Dozens of Jetliners to Save Fuel
    ... Reports: United Airlines to Ground Dozens of Jetliners to Save Fuel ... United Airlines plans to ground dozens of its least ... plan in mid-May as the Chicago-based airline cooled to a potential ...
    (alt.politics)
  • Re: Why Doesnt the press identify the 6 plotters as Muslims?
    ... I'm afraid that you're uninformed about their plans. ... "All of the news reports I've seen identified them as Muslim ... able to pull off an attack. ... That isn't to minimize the intent of what they had planned. ...
    (rec.sport.golf)