Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-21-2011, 11:45 AM
Carlos Maximo Carlos Maximo is offline % Complete (Actual) vs % Complete (Should) Windows XP % Complete (Actual) vs % Complete (Should) Office 2003
Novice
% Complete (Actual) vs % Complete (Should)
 
Join Date: Nov 2011
Posts: 4
Carlos Maximo is on a distinguished road
Default % Complete (Actual) vs % Complete (Should)

Hello, first post in this forum;
I'd like to know how I can compare what is already done vs what is suppose to be done.....Do I need to set a formula in a column? Or is there a direct way to do this...?

Thanks!

Carlos
Reply With Quote
  #2  
Old 12-04-2011, 08:56 AM
JulieS JulieS is offline % Complete (Actual) vs % Complete (Should) Windows 7 64bit % Complete (Actual) vs % Complete (Should) Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Carlos,
Earned Value Analysis (built into Project 2003) allows you to review this information by comparing planned work (Budgeted Cost of Work Scheduled or BCWS) against actual work (Actual Cost of Work Performed or ACWP) and amount earned or Budgeted Cost of Work Performed.
There is pretty good help in Project for earned value data. Be aware however, that in order to calculate earned value data, you have to have the following:
Resources with standard rates (many use $1 or local currency)
Resources assigned to tasks to generate work
Baseline saved
Updated status date.

Even without the complications of earned value, if you have saved a baseline you can easily see:
* when you had planned on starting each task (Baseline Start),
* when you had planned on finishing the task (Baseline Finish),
* what your estimated duration was (Baseline Duration),
* how much work you estimated (Baseline Work) and
* what your initial cost estimate was (Baseline Cost).

If you track actuals, Project will also automatically calculate Start Variance, Finish Variance, Work Variance, Duration Variance, and Cost Variance by comparing baseline data against actuals.

I hope this helps.

Julie
Reply With Quote
  #3  
Old 12-06-2011, 08:55 AM
Carlos Maximo Carlos Maximo is offline % Complete (Actual) vs % Complete (Should) Windows XP % Complete (Actual) vs % Complete (Should) Office 2003
Novice
% Complete (Actual) vs % Complete (Should)
 
Join Date: Nov 2011
Posts: 4
Carlos Maximo is on a distinguished road
Default Thanks Julie..!

I'll start working on your recomendations, seems there is still some work to do
Reply With Quote
  #4  
Old 12-06-2011, 12:01 PM
JulieS JulieS is offline % Complete (Actual) vs % Complete (Should) Windows 7 64bit % Complete (Actual) vs % Complete (Should) Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

A project manager's work is never done.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem to complete creation of new e-mail account Momentum Outlook 0 03-31-2011 02:31 PM
% Complete (Actual) vs % Complete (Should) Complete beginner needs some help. Biofodder Word VBA 1 03-14-2011 01:49 AM
Advancing Slide After Animation is complete scottv1001 PowerPoint 0 10-06-2010 02:46 PM
Creating Forms for users to complete dalaurienzo Word 1 07-19-2010 04:12 PM
Using Office to complete and print Forms. eJames Office 2 01-08-2010 08:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:39 AM.


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