Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Planned Value Cost is not matching with spread sheet value

In the Open Standard
Prasad KukunuriMember for 13 years 7 months
Created
6
2
0
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
Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    got to the calculations tab

    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

    Report
  2. 0
    Prasad Kukunuri ·
    #2

    Thanku for the reply, this

    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..
    Report
  3. 0
    Prasad Kukunuri ·
    #3

    Dear Zoltan, Thanku for the

    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
    Report
  4. 0
    Amro Ahmed ·
    #4

    Are you sure that you are

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

    I mean may you are showing WBS level

    Report
  5. 0
    Folahan Adebayo ·
    #5

    I just solved the same issue

    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.

    Report
  6. 0
    Zoltan Palffy ·
    #6

    time setting can certainy do

    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. 

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?