Re: BCWP and BCWS

Hi Anna,

Were you able to add the Tasks to Row labels in Excel? Were you able
to view the Task properties?

Julie

"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8DF52B1F-2520-4046-BE22-5DFB3075D022@xxxxxxxxxxxxxxxx
I was working on MS Project 2007 and trying to convert the
information that
you gave me into Excel 2003. I found out yesterday that I needed
Excel 2007
in order to pull that information you gave me (Actual Cost, Task AC,
etc) to
pull into the Field Picker List. Excel 2007 was installed in my
computer
yesterday then it seemed to work. I was able to get the field picker
list and
the pivot table. Then I followed the steps that you gave me again.

When I got to the part where you said to right click on any task and
choose
show menu, I didn't have that option. The option that I got was to
add to
Report Filter, add to ROW Labels and Add to Column Labels.

So I called on a co-worker for support.

"JulieS" wrote:

Hello Anna,

We'll I've got to say you've lost me. I don't understand "the data
is
set up in the database and stored in temporary tables." Did you
save
the cube data to Access?

Where did you discover that Excel 2007 may not be set-up correctly?
Can you be more specific? I'm not aware that there are excel
specific
settings that you need to set.

When you followed the directions below, what happened?

Julie

"Anna" <Anna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:17F7E184-3302-4963-9D7C-D7DBAC81B3A7@xxxxxxxxxxxxxxxx
Hi Julie,

The data is set up in the database and stored in temporary
tables. I
found
out that either the OLAP cube or Excel 2007 may not be set-up
correctly in
order to read the values in the visual earned value over time
report
through
the last steps that you provided me.

By any chance, do you know or does someone else know what my
excel
settings
should be set to or how the cube should read in order to read the
values by
editing the report and inserting Actual Costs, Tacks AC, Task
CPI,
Task
Earned Value, Task Planned value, Task SPI? Please let me know.

"JulieS" wrote:

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,


.

Loading