Planned Value Cost is not matching with spread sheet value

Dear friends,

I found very pecular problem. I am using P6v7, in my baseline schduele (resouce loaded, fixed budget) Planned value is showing as 122,757,666 for the DD is 22.apr.2017 but for the same date if you see cum.BL project total cost in Activity Usage Spreadsheet it is showing 128,811,923....

Kindly suggest me why this difference is comibg..

And also tell me tge default setting for CALCULaTIONS in Project details

Z
Zoltan Palffy 👤 Member for 16 years 10 months

time setting can certainy do that it can make a 1 day activity same 2 days EVERYTHING behing the scene works off of times. Make sure that data date TIME is correct 8:00 am or the earlies times in your calendar. All start milestones constraint dates should start at 8:00 AM or the earlies times in your calendar an finish milestones should finish on 5:00 pm or the latest hour of all of your calendars. Also turn on the decimal places for your durations and make sure that ALL remaining durations are in whole  numbers not in fractions of a day. 

F
Folahan Adebayo 👤 Member for 11 years 10 months

I just solved the same issue now. The problem was caused by nothing other than time settings. 

Just go to Edit-User preferences- Dates and select 24-hour time. Then press F9 and change your DD time to 23:00 and reschedule.

Voila that fixed the same issue for me.

A
Amro Ahmed 👤 Member for 17 years 5 months

Are you sure that you are sorting and grouping Spreadsheet by total.

I mean may you are showing WBS level

P
PRASAD KUKUNURI 👤 Member for 13 years 3 months

Dear Zoltan,

Thanku for the reply, this schedule was last week revised and updating by my collegue with out checking the boxes which u said. Suddenly he left the company and handed over to me. But i observed these check boxes i checked the boxes but still the Planned cost is showing different values in Spread sheet (below) and Activity table (above). Not knowing how to make them equal

P
PRASAD KUKUNURI 👤 Member for 13 years 3 months

Thanku for the reply, this schedule was last week revised and updating by my collegue with out checking the boxes which u said. Suddenly he left the company and handed over to me. But i observed these check boxes i checked the boxes but still the Planned cost is showing different values in Spread sheet (below) and Activity table (above). Not knowing how to make them equal..

Z
Zoltan Palffy 👤 Member for 16 years 10 months

got to the calculations tab and make sure that under Resource Assignments that when updating actual units or costs that Subtract Actual from At Completion IS CHECKED.

Also make sure that Recalculate Actual Units costs and Costs when duration % complete changes IS CHECKED

Also make sure that Link Actual and Actual This Period Units and Cost IS CHECKED

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts