Planned Value Cost is not matching with spread sheet value

Member for

16 years 3 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. 

Member for

11 years 3 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.

Member for

16 years 10 months

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

I mean may you are showing WBS level

Member for

12 years 8 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

Member for

12 years 8 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..

Member for

16 years 3 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