ACWP in Earned Value Over Time is called AC and doesn't work

[andrewandrew]

I've concluded after playing around with it, double-checking that I have SP1,
and combing this newsgroup that the field ACWP is called AC in the Earned
Value Over Time Visual Report for MSP 2007, and that it doesn't work. If
anyone has any other thoughts please let me know, otherwise I'm going to use
a workaround.

Thanks!

 

[JulieS]

Hi Andrewandrew,

Yes, AC is ACWP. In a very quick test, I show AC in the Visual
Report. I have SP-1 as well as the Infrastructure update installed.

Do you have work resources with costs assigned to the task?
Are you tracking progress by entering Actual Work or Actual
Duration?

If you apply the Earned Value to your Gantt chart do you see AC
(ACWP) in the table?

Julie

 

[andrewandrew]

JulieS,

I'm glad you replied, if I recall correctly you had run some of the tests in
previous posts I was researching. Here's the case, with SP1 installed:

Single task, 10d dur, one resource at 100%, resource rate is $10d/hour, set
start date to last sunday, set status date to current sunday. Task runs on
default Standard calendar, so starts last monday and finishes this Friday.
Save a baseline, hit Update as Scheduled (which is 50%). If I run the Earned
Value Over Time report now, AC will display correct values. HOWEVER:

If I switch to the Task Usage view and run the report, it shows AC as zero.
And even if I switch back to the Gantt Chart it shows as zero. As far as I
can see it will ever after display zero AC in the Visual Report, even though
ACWP is calculating correctly in the usage view. I've restart, tried
reinstalling SP1, no luck! So I'm going with a workaround, especially since I
saw two other people in this forum have the same or similar problem, with no
resolution posted.

Please check it out and let me know if I'm missing something!

Thanks!

Andrew

 

[JulieS]

Hello Andrew,

My comments are inline.

JulieS,

I'm glad you replied, if I recall correctly you had run some of
the tests in
previous posts I was researching. Here's the case, with SP1
installed:

Single task, 10d dur, one resource at 100%, resource rate is
$10d/hour, set
start date to last sunday, set status date to current sunday. Task
runs on
default Standard calendar, so starts last monday and finishes this
Friday.
Save a baseline, hit Update as Scheduled (which is 50%). If I run
the Earned
Value Over Time report now, AC will display correct values.

[Julie] Okay, given your scenario I see the following values when I
look at the Earned Value table:
BCWS (PV): $400
BCWP (EV): $400
ACWP(AC): $400
SV: $0
CV: $0
EAC: $800.00
BAC: $800
VAC: $0

When I run the Earned Value over time (setting the level of detail
to days) I see the value on day 27 is $400 which matches the value
precisely.

HOWEVER:

If I switch to the Task Usage view and run the report, it shows AC
as zero.

[Julie] I'm not seeing this. I've run the report in the Gantt
view, the Task Usage view and I still see the same data. I've saved
the file, closed, re-opened -- I still see AC as expected in both
the Visual Report as well as the tables as well as ACWP in the Task
Usage view (timescaled).

You said you have SP-1 installed, however do you have the
infrastructure update installed?

Please see:
http://www.microsoft.com/downloads/...b8-0425-4ba4-bece-7664b8f49d12&displaylang=en

And even if I switch back to the Gantt Chart it shows as zero. As
far as I
can see it will ever after display zero AC in the Visual Report,
even though
ACWP is calculating correctly in the usage view. I've restart,
tried
reinstalling SP1, no luck! So I'm going with a workaround,
especially since I
saw two other people in this forum have the same or similar
problem, with no
resolution posted.

Please check it out and let me know if I'm missing something!

[Julie] See if you have the Infrastructure update installed (see
link above). If not, install and test again. Let us know how you
get along.

Julie