Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P6 16.1: Planned Value Cost Activity Table =/= Cum PVC Activity Usage Spreadsheet

3 replies [Last post]
Bian Mutang Tagal
User offline. Last seen 21 hours 17 sec ago. Offline
Joined: 12 Jun 2014
Posts: 10

Hi all,

I am facing an issue that has me stumped - 

When I have baseline A assigned to a progressed schedule, I am unable to get the Planned Value Cost column in my Activity Table (LHS) to match with the Cum Planned Value Cost column in the Activity Usage Spreadsheet (RHS) at any given data date. This is an issue because our financial and physical S-Curves in Excel were created using the Cum Planned Value Cost values from the Activity Usage Spreasheet (RHS). Normally in our reports we submit both the curves and the P6 activity table printout which includes schedule % complete. So as you can imagine, the schedule % complete differs for the curve and P6 activity table.

Even more perplexing is that the LHS and RHS costs match when the schedule is imported to a SQLite database, but differs in an SQL database (non-server). This behavior is consistent across different machines.

Has anyone encountered this issue before and what are possible ways to resolve it?

 

Thanks,

Replies

Zoltan Palffy
User offline. Last seen 23 hours 17 min ago. Offline
Joined: 13 Jul 2009
Posts: 2735
Groups: None

thats should work

run this global change 

if

where (leave this blank)

Then 

Planned start = start

and Planned finish = finish

Bian Mutang Tagal
User offline. Last seen 21 hours 17 sec ago. Offline
Joined: 12 Jun 2014
Posts: 10

Hi Zoltan,

Under Admin Preferences>Earned value calculation>When calculating earned value from a baseline use:

  • At Completion values with current dates
  • Budgeted values with current dates
  • Budgeted values with planned dates <--- I am using this option for both SQLite and SQL

 

Thanks,

BT

Zoltan Palffy
User offline. Last seen 23 hours 17 min ago. Offline
Joined: 13 Jul 2009
Posts: 2735
Groups: None

under admin preferences calculate earned vauye what are your settings ?