how does Project calculate summary progress

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Order of details under Resource in Who does What Report I am a very new user of Project 2003 and am trying to edit the Who does What report. I want to sort the detail under each Resource so that each person can see a list of their tasks in Start Date order. I have tried editing the report but nothing seems to generate the list under each resource in this way. If I canâ??t do this via the report editing options, is there a way round this? I tried exporting the data to Excel but then all the Tasks and Resource names ended up in the same column so I would still have to do further editing every time I need a new report when the plan changes. Would really appreciate some help. -- Margaret als Tag: how does Project calculate summary progress Tag: 84853
  - 2
    - Network Diagram Can I generate a network diagram and export it to VIsio? -- Debra H. Tag: how does Project calculate summary progress Tag: 84849
  - 3
    - Added Calculated Fields to the Roll-Up tasks How do I add calculated fields to calculate at the roll-up level? I want the same equation that is used on a parent's children to be performed on the parent. Is this possible? The formula is extensive and contains nest if/thens, I don't believe this will be a problem, however I am drawing a blank as to where the roll-up tasks would be flagged? I know I could use a flag, however this would become cumbersome. Microsoft has already used some sort of flag to make the roll-ups become bold, therefore I believe what I am looking for to be possible. Please help, -- Thanks, KG Tag: how does Project calculate summary progress Tag: 84842
  - 4
    - Work schedule progress question I have a question about how I should display the following data in project. I will do this in picture form as it is much easier to understand this way. Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4h 4h Task1 ------------ 5h 5h 5h Task2 ----------------- 4h 4h 4h 4h 4h 4h Task3 ---------------------------------- 2h 2h 2h 2h 2h Task4 ------------------------------ 1h 1h 1h Task5 ----------------- Cum 4h 13h 22h 31h 35h 41h 47h 53h 57h 60h hrs All these task are subtasks to a summary grouping. For example Task 4 is scheduled from the beginning of week 6 to the end of week 10 and has 5 hrs scheduled for each week. Thus the hours are scheduled linearly over each of the tasks but not over all the tasks combined. If I have completed 30 out of the 60 hrs I want to show a summary progress bar which runs from the beginning of week 1 to almost to the end of week 4. If I have completed 53 of the 60 hrs I want the bar to run from the beginning of week 1 to the end of week 8. I have no idea how to do this. Is this % complete, % work complete, physical % complete, BCWS, BCWP? Please help. Also, this is an example case. The real data is 10,000 rows of historical data grouped into many different outline levels. Also, I know project can do lots of things like change durations, hours, and all that, but I don't want to do that. I just want to show what I indicated above for all my summary progress bars. Tag: how does Project calculate summary progress Tag: 84837
  - 5
    - How to ask for updates in MS project I am managing a project and there is a lot of participants involved in the project. I do not have Project server and because the sensitivity of the busines where I am involved I could not post my project on the web. How can I electronically request to the project participants (resources) for an update of a task via e-mail. Is there is way to do it with the project standard program Thanks Jorge Perez Tag: how does Project calculate summary progress Tag: 84828
  - 6
    - where can I find a manual for Project 2003 Is there a place I can download the manual for P20ject 2003. Tag: how does Project calculate summary progress Tag: 84827
  - 7
    - BCWS is zero for the summary task after SP1 upgrade I installed Project 2003 SP1, and not the BCWS for the summary task is zero. BCWP and Baseline Cost appear to have the correct numbers. Any suggestions? Tag: how does Project calculate summary progress Tag: 84826
  - 8
    - MS Project 2002 says installation is complete but not installed MS project 2002 starts istalled but doesn't complete. I have installation log files if that helps. Thanks Tag: how does Project calculate summary progress Tag: 84825
  - 9
    - Generation Cube When generation cube an error (-2147221411), any one help me? Tag: how does Project calculate summary progress Tag: 84822
  - 10
    - How do I change cells with #### in Project? For some reason some of my duration, start date and finish date cells say "####" and I cannot change the information in these cells? Does anyone know why this happens and/or how to fix it? Thanks, Jenna Tag: how does Project calculate summary progress Tag: 84820
  - 11
    - Tasks that are dependent not changing start dates My setup is that I have many fairly small projects. The tasks are of short duration 1-4 hours normally. If task #1 doesn't get started (For example it was scheduled to start yesterday, I want the next task to be listed as starting tommorrow not today as was originally scheduled. I won't necessarily be opening that project or myslef even know that the task got started late, but I don't want the next person in line thinking they have a task starting today when the task above them didn't get done. I don't want it to show up in their tasks. I have current projects set to 1 day. I have set my dependencies up FS and added a day lag time. It doesn't seem to recalculate until I enter something into the task above, but I want it to keep moving the dates if it doesn't get started. -- Peg Smith Tag: how does Project calculate summary progress Tag: 84819
  - 12
    - projected cost When I go to "report" in the view menu and select the "cost" option, and subsequently "budget", I see the five columns. I understand where the "total cost" statistic comes from, but I don't understand the "projected cost". How is it calculated and where in the program? Don Quijote de Nicaragua. Tag: how does Project calculate summary progress Tag: 84817
  - 13
    - Strikethrough a word Hello there, When I complete a task, I would like to put a line through it, but keep it visible. I'm sure that I've seen this before in a project plan. Basically I would like to strikethrough the font, just like you can do in Word. Tag: how does Project calculate summary progress Tag: 84813
  - 14
    - complete through Also what does complete through measure Tag: how does Project calculate summary progress Tag: 84811
  - 15
    - summary progress In the tracking gantt view, what is the summary progress bar showing. In other words what is summary progress? Is it % complete, % work complete, or something else. Tag: how does Project calculate summary progress Tag: 84810
  - 16
    - Gannt Chart Question Currently I'm using a split screen to view the resource sheet and a gannt chart. as I click on each specific resource, the gannt chart displays the tasks the respective resource is working on. So far so good... Now, when right clicking in the open area in the gannt chart, and then going to bar styles > text - the field under the 'right' row is displayed as resource names. Is there any way to simply show the name of the resource that I'm clicking on in the resource sheet above and his respective percentage allocation instead of *all* resources assigned to the tasks being shown? Tag: how does Project calculate summary progress Tag: 84809
  - 17
    - Schedule Progress I am trying to show schedule progress on a summary bar. For example if I have 60 hours of work to do over a ten week period, and 30 of these hours are scheduled to be done in the first four weeks, and I have completed 30 hours I want my summary progress bar to be 40% of the total summary bar rather than 50%. Consequently if 30 hours were scheduled over the first nine weeks and the remaining 30 hours were scheduled for week ten, I would want to show the progress bar as 90% of the total summary bar rather than 50. I thought I could use a summary progress bar which starts at [start] and ends at [% complete] to do this, but it doesn't look right. Any help would be aprreciated Tag: how does Project calculate summary progress Tag: 84807
  - 18
    - book pubishing process I tried to post this question a few mins ago but I am not sure whether I have managed or not. If this is appears to be a copy I am sorry. I would like to track my resources in the period of several books pubishing. I am entering the book's name as the task and the works to be done during the process as ubtasks and assign resources for each subtask. For ex: I have editors, graphic designers etc.. I would like to enter the total number of pages for each book as the target work to be done and would like to ask from each of my resource to enter the number of pages the have edited that day. Is this possible? Can anyody help me? Tag: how does Project calculate summary progress Tag: 84800
  - 19
    - leveling Ressoueces (with different units) Hi... Yesterday i sent a Question about leveling the resources. But i think, i could not explain it good. Let me write it a different way.. I have a task (8 hours). The unit of the resource is %25 So i have: 8-9 9-10 10-11 11-12 13-14..... 0,25h 0,25h 0,25h 0,25h 0,25 h is there aynway to do it so (without making the unit %100)): 8-9 9-10 10-11 11-12 13-14..... 1h 1h 0 0 Tag: how does Project calculate summary progress Tag: 84792
  - 20
    - display total resource graph for project I want to show summary of total resource used on project as abar graph and also for key tasks rather than scroll through individual graphs for each resource. Tag: how does Project calculate summary progress Tag: 84791
  - 21
    - How do I measure actual progress % versus planned progress % I am trying to report against my project. I can't find a way of showing the progress which SHOULD have been made according to the plan. I want to show, by project phase, % of activity which was planned to have completed and % of activity which has actually completed. Can anyone help ? Tag: how does Project calculate summary progress Tag: 84787
  - 22
    - Track Estimated vs Actual work Im trying to track my Estimated vs Actual work. when I enter the Actual Work the Estiamted Work moves with that and therefore the whole schedule moves. I want to be able to track my original estimates for reporting and learning purposes so if I enter Actuals I dont want the Estimates to change. Is there a way to stop the estimates changing or a better way to do this? Tag: how does Project calculate summary progress Tag: 84785
  - 23
    - Task Creation Guidelines Looking for a concise, possibly bulleted list of considerations when including a task in the project schedule. Envisioning guidelines to: naming/describing the task, duration (e.g. 8/80 rule), establishing dependencies, assigning resources. I realize there are probably volumes written on any one of these characteristics, but I was hoping to maybe get directed to a single, simple source if one exists. The audience is for the most part, beginner to intermediate level Project users. Tag: how does Project calculate summary progress Tag: 84776
  - 24
    - Query - What if? Hello folks, Is there a function in Microsoft Project to ask the question "What if?" (i.e. duration of several tasks changes/delays) and the program automatically responds (somehow)? This would be in lieu of actually making adjustments to the schedule and seeing what happens to the schedule! I don't think there is but I thought I would ask. Thanks in advance! AJ Tag: how does Project calculate summary progress Tag: 84774
  - 25
    - Task Creation Guidelines Looking for a concise, possibly bulleted list of considerations when including a task in the project schedule. Envisioning guidelines to: naming/describing the task, duration (e.g. 8/80 rule), establishing dependencies, assigning resources. I realize there are probably volumes written on any one of these characteristics, but I was hoping to maybe get directed to a single, simple source if one exists. The audience is for the most part, beginner to intermediate level Project users. Tag: how does Project calculate summary progress Tag: 84773
- Next
  - 1
    - How do I change task duration in the Project 2003 template "Commercial Construction-1"? I have saved the file to a different name, so I can edit it for my own use. Most of the tasks are not relevant for my work, but I can use them to base my own project on. How do I unlock these fields so I can put in my own dates? When I try to change the dates or duration they are always grayed out. -- Thank you Tag: how does Project calculate summary progress Tag: 84772
  - 2
    - Deleted a filter, used by a view, and now cannot open the file Hello, I recently deleted a "filter" that was used by a "view". Apparantly that must have been the default view because now when I try to open the file I get the following error message: _____________________________ The filter "V - DDI - ALL - NOHLT" cannot be found You tried to display a view or use an import/export map that references a filter that is not available. - If you are trying to use a view, specify a different filter for the view - If you are exporting with a map, the export will continue without the application of a filter. _______________________________ Then, when I click "OK" or even if I just click on the "X" in the upper right hand corner I get the send error report message. Once that message comes up the application hangs until I click either the "Send Error Report" or "Don't Send" buttons. My problem is that I can't get into the file to fix the filter/view problem. Any suggestions????? Thanks in advance for your help :) Justine Tag: how does Project calculate summary progress Tag: 84766
  - 3
    - Multiple Resources & Resource Calendar I have three resources that must meet to discuss as situation. I assigned all three resources to the one task. However, one of the three will be absent on specific date so I updated that resource's calendar accordingly. When Project 2002 Professional determines the start/finish dates, it uses the day the one resource is absent. If remove the available resources, it does not schedule on that day. Is there a way (other that updating each resource's calendar to say they aren't available even though two are) to tell Project that all three resources must be present and thus, not to schedule the day the one resource is absent? -- Thank you, Michael Tag: how does Project calculate summary progress Tag: 84764
  - 4
    - Level by priority Is there any way to make project level by priority first, then by task duration? "Priority, Standard" does not seem to do it- my short, high priority tasks are still being delayed by lengthy low-priority ones. I don't want to use the do not level setting because not all of these high-priority tasks are of the same importance. Thanks for any help. Peter Tag: how does Project calculate summary progress Tag: 84758
  - 5
    - Resource graphs I want to display graph showing aggregated resources asigned to project, rather than separate graphs for each resource. If possible subset showing resources by task and groups of resources Tag: how does Project calculate summary progress Tag: 84755
  - 6
    - Print preview screen is greyed out. Can only print to the default printer on preview screen can't change to another printer selection is greyed out. Everything else works fine when printing File->Print and you can select printers that way, but not from preview screen. I reinstalled project, haven't installed SR-1 for it yet but going to.. Does anybody have any other ideas? (using 2000 Project) Thanks in adavance Tag: how does Project calculate summary progress Tag: 84754
  - 7
    - Project Ownership I know how to edit the ownership of a Project in Web Access and I also know how to change the ownership in Project Pro. Is there a way that when the ownership is changed in Project Pro that the ownership in Web Access is automatically changed so that you don't have to go through those steps in both places? -- DMW Tag: how does Project calculate summary progress Tag: 84750
  - 8
    - View Specific Date Range I have a 5-year project schedule. My boss needs a way to view only a 3-month period (July 1, 2005 - September 30, 2005). I know I can print a specific date range and filter a view for start date ranges. However, I haven't been able to figure out how to view a range where I have all tasks which start during the period and may finish after the end date (of the desired view). I would need for Project to slice the gantt chart on the desired end date. Example: Task A starts on 7/15/2005 and ends 6/1/2006. I want the gantt chart to only show 7/15/2005 through 9/30/2005 (for now) and keep the rest hidden. Thanks for any input. RC Tag: how does Project calculate summary progress Tag: 84744
  - 9
    - How do I export Resource/Project/%Allocated data from Project? I'd like to export Resource by Project by %Allocated data from Project to Excel. Any ideas? Tag: how does Project calculate summary progress Tag: 84743
  - 10
    - inserting subprojects Is there any way when inserting subprojects into the master schedule, that the number sequence can be consectutive? Or is each subproject inserted starts from 1? Tag: how does Project calculate summary progress Tag: 84733
  - 11
    - level ressources with different units Hello.. there are two parallel tasks. They have the same ressource with diffrent units. For example: task1 Ressource1(%25) task2 Ressource1(%100). when i try to level them automatic, one of the tasks will be done after the other. But i want that they go parallel.. Any idea? thx... Tag: how does Project calculate summary progress Tag: 84731
  - 12
    - How can I have task data adjusted to wrap in Printing? In Project 2000 it is easy to get data to wrap on screen, but can this then be printed. It seems to just print as one line and lop off what is too long for the field width. If the width is adjusted to print as one line, then the text is too long. I have cut down the task description to the bare minimum already! Tag: how does Project calculate summary progress Tag: 84730
  - 13
    - How to Convert a group of selected tasks in mpp to pdf? I want to convert a group of selected tasks in .mpp file to pdf file, could any body please help me? Thank you in advance Tag: how does Project calculate summary progress Tag: 84729
  - 14
    - How to Convert a group of selected tasks in mpp to pdf? I want to convert a group of selected tasks in .mpp file to pdf file, could any body please help me? Thank you in advance Tag: how does Project calculate summary progress Tag: 84726
  - 15
    - PWA - Project (Group) Web Sites We are using MS Project 2003 & Project Server; Is it possible to have many projects link to a single 'Share Point Services' web address...?? My reason for this is that we have project managers who manage several concurrent projects (ie a group of similar projects, for example ~ 'subsea equipment projects' and 'surface equipment projects'), and our intention is to have a website for a group of projects. I cant see how to do this from the Manage Windows SharePoint Services page. Any advice would be appreciated, Kevin, Perth, Western Australia Tag: how does Project calculate summary progress Tag: 84725
  - 16
    - Export Summary Tasks to Excel When I export from MSPrj2K to Excel the Summary activities are not included. I have checked the Show Summary box in the filter as well as on the Tools/Options/View tab. How do I get the related Summary lines to export? Thanks Tag: how does Project calculate summary progress Tag: 84723
  - 17
    - How to resolve a gap in task ID numbering I have a Project 2003 schedule that's been published to Project Server. In Project, the task IDs have a gap, like this: 1 2 3 8 9 Tasks 4 through 7 are not shown. The schedule has no filtering, sorting, or grouping applied. I've tried resorting by ID but with no luck. The missing tasks 4 through 7 are simply nowhere to be found in Project. I mentioned that this schedule has been published to Project Server. There, can see the mystery tasks 4 through 7 in the Project Center view. Back in Project, I'd like to show the missing tasks 4 through 7, delete them, and have Project correctly renumber the remaining tasks. Any suggestions on how to accomplish this? Thanks, Carlchat Tag: how does Project calculate summary progress Tag: 84720
  - 18
    - Percent complete not rolling up to 100% - Project 2003 When I set all the subtasks to 100%, the summary task only show 99%. I can't change the summary task % to 100 - it goes back to 99%. I can't get the tasks to show complete and it is messing up my completed tasks report and driving me nuts. Everyone else on the project has Project 2003, and no one else is having the problem. To make it worse, when they try to fix my file for me, it doesn't work, but their files do. Tag: how does Project calculate summary progress Tag: 84716
  - 19
    - Import/export resource usage data from Project to/fro Excel? Help I want to manage Resources by Project by Month with % Allocated in Excel and then to load the data into Project. I want the spreadsheet to look like the "Resource Usage" view. I can't find a map to make this work. Any advice? Tag: how does Project calculate summary progress Tag: 84712
  - 20
    - Custom Indicators I would like tag certain tasks in my project by entering information in custom text fields (text1, text2 etc.) and have a custom indicator displayed in the indicators column that identifies the tasks that I tagged so. How do I do that? Tag: how does Project calculate summary progress Tag: 84708
  - 21
    - % Complete not updating to Web Access If PM updates the % complete in the project plan, without changing the total work hours, the percent is not updated in the Tasks view for the resources on the web. We tried publishing all information, and republishing al assignments, to no avail. Under collaboration options we also tried both options for 'Publish and new changed assignments' We need to do this because we are just getting started with Project Server and Web Access, and the PMs wanted to just update the hundreds of already started and completed tasks on ongoing projects, rather than have all the resources enter all that actual time. Any help is appreciated. Tag: how does Project calculate summary progress Tag: 84700
  - 22
    - Duration changes with multiple resources I have a project whose tasks total 600 hours. Of the 600 hours there are tasks and sub-tasks. If I add multiple resources (let's say 3 resources) for each task, the duration for each task shows 1/3 of the time of the total task. (i.e. a task estimated at 30 hours will show a duration of 10 hours after adding 3 resources at 100%). Project will also pull in the finish dates reflecting 10 hours of work instead of 30 (which is fine). How can I get Project to continue to reflect the actual total number of hours of effort (in this case 600) with multiple resources performing each task? My objective is to show that the project requires 600 hours of effort, but will not require 600 consecutive hours for completion. Thanks. Tag: how does Project calculate summary progress Tag: 84695
  - 23
    - Microsoft Projects How can I fill in the boxes in a row with color? Tag: how does Project calculate summary progress Tag: 84694
  - 24
    - One more - Using Resources One more quick one.... I am developing an earlier plan that now has some expired resources - how can I remove them - I can delete thier names from the Resources listing but the entries stay (there just blank) Cheers Tag: how does Project calculate summary progress Tag: 84690
  - 25
    - Graphical Indicators I am using Microsfot Project 2000 - one of the fields I use folows the ROYG philosophy for Project managemnet (Red, Orange, Yellow and green) - I convert this to graphical indicators - unfortunatly MSP2k does not have an Orange indicator - does anyone know how to add new indicators or edit existing ones? Tag: how does Project calculate summary progress Tag: 84687

Also if anyone has any further comments on the "Work schedule progress
question" post below it would be greatly appreciated

Top

Re: how does Project calculate summary progress by John

John
Sat Jun 04 16:02:20 CDT 2005

In article <24E1D9E3-8E13-4661-8C11-E69B58881E94@microsoft.com>,
Tomcat <Tomcat@discussions.microsoft.com> wrote:

> Also if anyone has any further comments on the "Work schedule progress
> question" post below it would be greatly appreciated

Tomcat,
This question has been answered multiple times in the past. The short of
it is as follows:

Summary Line percent complete = (sum of subtask Actual Durations) / (sum
of subtask Durations) x 100%.

Note that subtasks are actual performance tasks. Using duration values
of other Summary lines does not work in the equation.

Hope this helps.
John

Top