Re: BCWP and BCWS

Thanks Anna. Let us know how things progress.

Julie

"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:96A32D26-9AE0-44C2-86D5-1A6BFFBC52D7@xxxxxxxxxxxxxxxx
Julie,

I will be out of the office all day tomorrow. I will work on this
over the
weekend and let you know. I really appreciate you taking the time to
work on
this for me. You are a true asset!

"JulieS" wrote:

Hi Anna,

I was able to get Task Earned Value information from the Earned
Value
Over Time Visual Reports but it requires a bit of tweaking.

To recap:
You have fixed costs added to tasks
You have resources without costs assigned to tasks
You've saved a baseline
You've entered a status date
You've tracked data through the status date.

Choose Report > Visual Reports.
Single click Earned Value over Time Report
Set the appropriate usage data (weeks may be appropriate for the
tracking level)
Click the Edit Template Button to open the Field Picker
Click the Remove All button to remove all fields from the Selected
Fields List

Add back:

Actual Cost
Task AC (which is ACWP)
Task Earned Value (which is BCWP)
Task Planned Value (which is BCWS)
Task SPI (Schedule Performance Index)
Task CPI (Cost Performance Index)

You can also add Task SV, Task SV%, Task CV, Task CV%, Task TCPI as
you wish

Click the Edit Template button to close the field Picker and
generate
the report.

Once in Excel, add the Actual Cost to the Sum Values.
Move the Tasks from the Report Filter to the Row Labels
Click the + to expand and see all tasks
Right click on any task name and from the shortcut menu choose
"Show
Properties in Report". In the list of properties should be all of
the
Task Earned Valued information you added. Choose "Show All
Properties" to add all.

The data in the report should match the timescaled earned value
data
you see in the Task Usage view at the task row as of the status
date.

You can of course, also just print the Task Usage view with the
additional fields added. If you users do not need the data to
manipulate, I'd most likely just print the Task Usage view with the
fields you'd like added to the right side.

I hope this helps. Let us know how you get along.

Julie
Project MVP

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

"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7AF43099-7E72-4896-A243-33C331DFB840@xxxxxxxxxxxxxxxx
I did some reading of past comments and saw resources that were
assigned need
a value in it even $1/hr would work. I tried that and it didn't
work.

I'll wait and see what you come up with. In the mean time I will
contnue to
try out your suggestion to see if that will fix the problem.


"JulieS" wrote:

Hi Anna,

Sorry for the delay in replying. I haven't had a great deal of
time
to experiment, but I believe the reason you are not seeing
values
is
because your resources do not have any costs associated with
them.
You are using solely fixed costs and as such, your assignments
do
not
have costs associated.

If you view the Resource Usage view and show BCWS, BWCP, ACWP in
the
timescaled portion (left side) you'll see zeros. I can't
experiment
right now, but you may be able to get what you want by modifying
one
of the task reports to add those fields.

I'll work on this later and see what I can come up with and post
back

Julie

"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:13A68367-0C50-41F8-8773-C550EF4DAD40@xxxxxxxxxxxxxxxx
Thanks to all of you, all Fields are adding up correctly! You
have
no clue as
to how happy I am right now because I have been battling this
for
weeks all
on my own. Talk about stubborn! I just have one small problem
....

Now that everything is adding up correctly, when I try to
generate
an earned
value over time report by going to reports/visual
reports/excel/earned value
over time report/view, then clicking on Assignment Usage with
EV
tab, I am
receiving 0 values. If I double click the Q2 it will drop down
the
weeks. If
I double click the items listed under type in the Pivot table
field
list, the
only value showing is under costs.

How do you get the values to read under the planned, earned
and
actuals
columns.

P.S. I'm working in MS Project 2007 and the service pack is
installed.


"Anna" wrote:

Thanks! I will try it out and let everyone know.

"Rod Gill" wrote:

As Julie said % complete is not accurate. I would go
further
and
say that
earned value reporting when you only use % complete is not
all
all accurate
and will likely be misleading. The only way to get accurate
earned value
reports is by accurate scheduling of resources and actual
hours
per day
updating (usually via a time*** system).

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E016E7EC-6013-40FC-BA77-CDA2D9833A2E@xxxxxxxxxxxxxxxx
Awesome! I will play around with this tomorrow and see
how
everything
works
out. I really appreciate all your help and suggestions.
I'll
let you know
how
it all worked out. Thanks again and take care.

"JulieS" wrote:

Hi Anna,

Yes. By using actual and remaining duration, Project
calculates %
complete.
Percent complete = actual duration/duration * 100

From help:
"If you type a value in the % Complete field, Project
automatically
calculates actual duration and remaining duration.
Likewise,
entering
a value in the Actual Duration or Remaining Duration
field
automatically recalculates the other fields."

Julie


"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2D122A23-7B16-4799-8CCF-2CB33386C710@xxxxxxxxxxxxxxxx
If I go with tracking actual against remaining
durations,
do
I still
keep the
Earned Value Method = % Complete in the field like
Andrew
suggested?
Does
Project automatically calculate acutual and remaining
durations?

"JulieS" wrote:

Hi Anna,

Don't worry about asking questions, that's what the
newsgroup is
here
for :-)

No you shouldn't save a new baseline. You should be
able
to run
the
report with the existing baseline.

Just a quick comment on % complete. Most of the
regular
posters
here
do not recommend % complete as a method of tracking.
I
suggest
tracking actual and remaining duration which will
calculate
and
update
% complete. For most people it's more accurate than
%
complete.

I hope this helps.
Julie
Project MVP



"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:8CF46B0D-B0AC-4A24-AD55-DDFB39F87582@xxxxxxxxxxxxxxxx
I hope this is the last question. Each week I will
go
in
and track
the
progress by entering % complete, do I need to save
the
baseline
to a
new
baseline every week and will this generate an
Earned
Value Over
Time
Report
through visual reports?

"JulieS" wrote:

Hi Anna,

Yes, I do mean a standard rate. If you use fixed
costs
as
Andrew
suggests it should also work. Assign the fixed
costs,
save a
baseline
and it should populate BAC (baseline cost).

Julie

"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:286298CE-246B-40A1-9024-68CF4F6DCFB3@xxxxxxxxxxxxxxxx
Hi Julie,

Yes, Resources were loaded. What do you mean by
standard
rates?
If
it's an
hourly rate that I need to include for a
resource,
then it's
no
good
because
all that is provided to me is a lump sum cost
from
the
contractor
for that
task.

Thats why I assumed that I had to put the lump
sum
in
the BAC
field.



"JulieS" wrote:

Hello Anna,

Pardon me for bumping in. In order for Project
to
calculate
BCWP


.