% Complete based on number of tasks completed.....

[MA]

im trying to change the formula for the % complete or make a customized field
to calculate % complete of a project based on the number of completed tasks
in that project. For example
Task1
Subtask1
Subtask2
Task2
Subtask1
Subtask2
Now given a format like that I ud like % complete to compute so that each
task contitutes of the total percentage in the project, in this case Task1 +
Task2 = 100, so if task one is complete the project shud stand at 50% so that
if there is any change in the time taken for the particular task the total
percentage complete is not affected.
Tha Subtasks shud be a part of the Tasks and the percentage of the Tasks
completed shud be calculated from the Subtasks completion. So that if
Subtask1 is complete then Task1 should stand at 50 percent.
I hope its clear what Im trying to accomplish. Any suggestions as to how i
might go abt doing this will be highly appreciated. I have to solve this in 3
days time and i must add that Im a novice at using this software.
Thanks in advance.

 

[John]

im trying to change the formula for the % complete or make a customized field
to calculate % complete of a project based on the number of completed tasks
in that project. For example
Task1
Subtask1
Subtask2
Task2
Subtask1
Subtask2
Now given a format like that I ud like % complete to compute so that each
task contitutes of the total percentage in the project, in this case Task1 +
Task2 = 100, so if task one is complete the project shud stand at 50% so that
if there is any change in the time taken for the particular task the total
percentage complete is not affected.
Tha Subtasks shud be a part of the Tasks and the percentage of the Tasks
completed shud be calculated from the Subtasks completion. So that if
Subtask1 is complete then Task1 should stand at 50 percent.
I hope its clear what Im trying to accomplish. Any suggestions as to how i
might go abt doing this will be highly appreciated. I have to solve this in 3
days time and i must add that Im a novice at using this software.
Thanks in advance.

MA,
I would try the following:
1. Go to Tools/Customize/Fields
2. Select a number field in the type selection box. By default Number1
will be highlighted.
3. For Custom attributes hit the "Formula" button.
4. When the formula window appears enter "1", ( but without the
quotation marks), and hit "OK".
5. Then select "Rollup" and then "Sum" for Calculation for task and
group summary rows for Number1.
6. Use a similar process for the Number2 spare field except leave the
Custom attributes at "none".
7. Select a text field in the type box. Text1 will be highlighted.
8. Hit the "Formula" button for Custom attributes.
7. Enter the following formula and then hit "OK":
format([Number2]/[Number1],"##.0%")
8. Then select "Use formula" for the Calculation for task and group
summary rows for Text1
9. Hit "OK"

That process will set up the necessary custom fields. Now to display
them, do the following:
10. Select the column where you want the fields to show on your view and
hit the right mouse button.
11. Select "Insert column".
12. In the Column Definition window, select Number1 and hit "OK". You
can give the added column a new title if desired. For example, the
Number 2 column might be "ST % Comp" for, "subtask % complete".
13. Use the same process to add the Text1 column.

You are all set. Enter the decimal value into the Number1 column for
each subtask. At the summary line level the Text1 field will show your
desired % Complete.

Hope this helps.
John
Project MVP

 

[Steve House [MVP]]

Gotta ask - what if task 1 will take 3 days and task 2 will take 3 weeks?
Would it really be accurate to say the project is half done when task 1 is
finished and task 2 has not yet started? Seems Project's regular way of
computing % Complete which would come up with about 15% would be a far more
reliable indicator of progress from the viewpoint of managing the work.