Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-28-2011, 06:32 AM
abw1987 abw1987 is offline Planned Versus Actual Completion Windows 7 32bit Planned Versus Actual Completion Office 2010 32bit
Novice
Planned Versus Actual Completion
 
Join Date: Sep 2011
Location: Boston
Posts: 7
abw1987 is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Welcome to the forum.
Thanks!

Quote:
Originally Posted by OTPM View Post
First of all when you have task A as 5 days and task b as 10 days, and then mark task A as 100% complete the summary task DOES show 33% and NOT 50%, so not sure what your confusion is here.
Right. This is true of the standard % Complete field, but for a custom Text field I'm not sure how to do this. I want to be able to manually enter task completion percentages in the Text field, and have those values roll up to the summary tasks. However I don't want the values in this field to automatically update whenever I change the project Status Date. So a summary task percentage should be based solely on the manually-entered percentages, and the overall durations, of the tasks below it.

Quote:
Originally Posted by OTPM View Post
Second can you post what you have done so far so we can have a look in more detail.
Absolutely. Though I can't post the project plan I am working with (confidential), I have attached an example. In this example, you will notice two columns:
  • % Complete (Planned):
    This is just the standard % Complete field, which updates automatically whenever I go to Update Project and pick a new Status Date. This functions just how I would like it to. The current status date in the Project Plan is 9/30, so the tasks' % Complete values are automatically updated accordingly.
  • % Complete (Actual):
    This is a Text field, in which I have manually entered percentages at the task level. (As you can see, we are behind on Example Task 2.) I would like the percentages to roll up to the summary task. Is there a better field that would accomplish this? I want to make sure it doesn't automatically update the percentages whenever I go to Update Project and pick a new Status Date.
Does that all make sense?

Thanks!
Attached Files
File Type: zip ExampleProject.zip (24.6 KB, 76 views)

Last edited by abw1987; 09-28-2011 at 06:53 AM. Reason: Clarity
Reply With Quote
 

Tags
actual, completion, planned



Similar Threads
Thread Thread Starter Forum Replies Last Post
Baseline versus actual data Plas Project 1 12-16-2015 09:35 AM
Very simple / STUPID question about actual vs. planned hours sam-sam Project 0 12-07-2010 02:55 PM
How can I change the colors of cells automatically based on Job Completion? Learner7 Excel 0 07-06-2010 10:47 PM
MS Project able to import actual start and or actual finish date from Excel? mhacker Project 0 04-26-2010 11:29 AM
Planned Versus Actual Completion auto data completion Albatross Word 1 02-11-2010 11:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:31 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