If you require PCT in decimals, I assume that your progress is based on cost. If so, just get the earned value and divide it by either the original total budget or by the EAC (estimate at completion). This way, you can get the PCT at any number of decimal places.
I would like to try your tool. If I find it useful, I’ll recommed it to the other planners I know here. Please send it to me on vishbin@gmail.com
Secondly, Shahzad, the discussion here is for generating the progress in 2 decimals as it is the requirement for the project I’m working on. I wouldn’t be asking if it wasn’t!
Thanks & Rgds,
Vishwas
Member for
20 years 8 months
Member for20 years8 months
Submitted by Sukumaran Suba… on Wed, 2005-05-04 04:32
Tool was written to allow customer in defence to update WBS % completes quickly and accurately. They would organize by WBS (total at top) and then key the summarized % complete from the organized band into the WBS activity normally immediately below as layout is also sorted by early start. Since schedule is 20,000+ activities this was time consuming and error prone so we wrote the tool to automate this process.
Vishwas B’s original post details why he wants two decimals and since we have a tool that already does the calculations and updates it would be very simple to store the result in a custom data item field to two decimals.
I agree that rounding % complete to a whole number is what P3 provides and is usually sufficient. In fact when we update the WBS activity % complete that is what is displayed.
Member for
22 years 4 months
Member for22 years4 months
Submitted by Shahzad Munawar on Tue, 2005-05-03 10:21
We have a software tool that operates as an add-in to P3 and re-calculates the % complete on WBS activity types based on the Summarization Option (duration/resource/cost). It would be very simple to store the result in a custom data item field to two decimals.
Member for
22 years 5 monthsRE: % Complete in Decimals
Hello Vishwas,
Agree with Jorge & others too... why not export the value in excel? you can customize in a much better presentation too...
Cheers!
Christian
Member for
20 years 1 monthRE: % Complete in Decimals
or
aymaneleish@yahoo.com
Member for
20 years 1 monthRE: % Complete in Decimals
Hi frank
I am waiting for your softwar
at aymaneleish@hotmail.com
thanks
Member for
22 years 4 monthsRE: % Complete in Decimals
If you require PCT in decimals, I assume that your progress is based on cost. If so, just get the earned value and divide it by either the original total budget or by the EAC (estimate at completion). This way, you can get the PCT at any number of decimal places.
Simple, right?
Best regards,
Jorge
Member for
20 years 1 monthRE: % Complete in Decimals
Frank, you are welcome to post your tool (as an attachment) for all to use in our templates / files forum.
Stacy
Participate at the Project Management Knowledge Base!
Member for
20 years 1 monthRE: % Complete in Decimals
hi frank
i will be very greatfull if u can send me this softwar that help me to get 2decimals in %compelete summarization
tanks
aymaneleish@hotmail.com
Member for
21 years 8 monthsRE: % Complete in Decimals
I would appreciate if u can send to me tooo,
cheers
Planner Frijo
Member for
20 years 8 monthsRE: % Complete in Decimals
Good Morning Frank,
Still havent received the software tool. Appreciate if you could forward to all the requested planners for our review.
Regards.
Member for
22 years 8 monthsRE: % Complete in Decimals
Frank
I can see you becomes the favour of the week. :-)
BTW I would like to ask the real needs of having 2 decimals place in a project plan??
Is a schedule a preceision tool?
What is the benefits of having 0.01% complete. How accurate is the original individual activities % estimate.
And how accurate you want to get in the summary of these % estimate?
Thanks in advance
Member for
20 years 7 monthsRE: % Complete in Decimals
Pls add me in the list too Frank, email id - rsunilr1@yahoo.co.in
Thanks and Cheers
Sunil
Member for
24 years 4 monthsRE: % Complete in Decimals
Dear Frank,
Can you please send the tool to my address also - bharathanin@yahoo.com
Thanking you in anticipation
Bharath Kumar J
Member for
21 years 9 monthsRE: % Complete in Decimals
Frank,
I would like to try your tool. If I find it useful, I’ll recommed it to the other planners I know here. Please send it to me on irshath@rediffmail.com
Also the current project progress which I’m working on requirement is in 2 decimals .
Thanks & Rgds,
Irshath
Member for
21 years 5 monthsRE: % Complete in Decimals
me too. I would like to try that one. can u send it to me also, rolynjalea@yahoo.com
Member for
21 years 6 monthsRE: % Complete in Decimals
Frank,
I would like to try your tool. If I find it useful, I’ll recommed it to the other planners I know here. Please send it to me on vishbin@gmail.com
Secondly, Shahzad, the discussion here is for generating the progress in 2 decimals as it is the requirement for the project I’m working on. I wouldn’t be asking if it wasn’t!
Thanks & Rgds,
Vishwas
Member for
20 years 8 monthsRE: % Complete in Decimals
Hi Frank,
I would like to try the software tool. Could you e-mail it to my address "sukumaransubaramaniyan@yahoo.co.uk" when you forward to Daya.
It might be usefull in my future when I do a weekly report for my client.
Regards.
Member for
22 years 7 monthsRE: % Complete in Decimals
Dear Frank,
I would like to receive your software tool, hence please forward it to my email id plannerdaya@yahoo.com
Cheers!!!
Daya
Member for
24 years 6 monthsRE: % Complete in Decimals
Shahzad,
Tool was written to allow customer in defence to update WBS % completes quickly and accurately. They would organize by WBS (total at top) and then key the summarized % complete from the organized band into the WBS activity normally immediately below as layout is also sorted by early start. Since schedule is 20,000+ activities this was time consuming and error prone so we wrote the tool to automate this process.
Vishwas B’s original post details why he wants two decimals and since we have a tool that already does the calculations and updates it would be very simple to store the result in a custom data item field to two decimals.
I agree that rounding % complete to a whole number is what P3 provides and is usually sufficient. In fact when we update the WBS activity % complete that is what is displayed.
Member for
22 years 4 monthsRE: % Complete in Decimals
Hi frank
By your given option, it is determined that without usage of software tool, progress in decimal cannot be ascertained in P3 itself.
Moreover what is its main effect if we take into account the progress in decimal? for precision purpose or any other
Common practice is that progress is usually measured in rounded figure.
Member for
24 years 6 monthsRE: % Complete in Decimals
We have a software tool that operates as an add-in to P3 and re-calculates the % complete on WBS activity types based on the Summarization Option (duration/resource/cost). It would be very simple to store the result in a custom data item field to two decimals.
Contact frankb@ecspl.com.au if you are interested.
Member for
20 years 7 monthsRE: % Complete in Decimals
Can you have a more granular grouping of your activities and montor their % complete, instead of the one at the high level?