Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-09-2012, 01:37 PM
ketanco ketanco is offline Calculating earned value Windows 7 64bit Calculating earned value Office 2007
Expert
Calculating earned value
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default Calculating earned value

Hello,
How do you calculate the earned value of the activities?
Here is what I did before the job started months ago:
I had entered the total costs of activities, so I have a lump sum cost for activities. I then went to task usage tab and I have the costs and cumulative cost rows displayed against dates there so I was able to see the planned and cumulative planned values. I even pasted the dates and values as two rows into excel and made a nice S-Curve…


But how about actual earned values versus the dates now, based on the current progress? We are in the middle of the job now and there are finished activities, there are activities between 0-100 % and there are activities has not started yet. They asked me for instance to give the earned value in July, based on progress (as I said, lump sum costs for activities were already entered before)

Does the task usage column distribute costs against current start and finish dates (i.e. start and finish columns)? If so, the distribution I made months ago before job started and when I saved my baseline has gone now and what I am seeing is the earned value? Is that the case? (because I see costs vs current start and finish dates now by default I believe)

Note: I never updated any costs or entered actual costs. All I am after is to calculate the earned values, not actuals.
Thanks in advance and sorry for the long question
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Profits? MarkL Project 1 06-12-2012 07:19 AM
Calculating earned value calculating duration ketanco Project 5 12-15-2011 07:15 PM
Calculating earned value Calculating dates Daria11 Word VBA 1 06-08-2011 06:54 PM
Calculating earned value How to apply budget for earned value analysis ttorneby Project 2 06-03-2010 04:52 PM
Good commission to be earned for writing some office questions iqnetsys Office 0 02-23-2009 05:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft