Can Percent Complete be Quantities?

A
Andrew W 👤 Member for 21 years 7 months
C
Conrado Fajarillo 👤 Member for 21 years 7 months

Yes you can, but this is somewhat tricky.



1.Input the quantity on the Actual To Date in the Resources

2.Do global change

RCPT = QTD/BQ (Resource Percent Complete)

RCPT = RCPT*100 (Value in Percent Complete)

PCT = RCPT (Equate Percent Complete to Resource Percent Complete)

3.Earned Value will be directly calculated.

C
Conrado Fajarillo 👤 Member for 21 years 7 months

Yes you can, but this is somewhat tricky.



1.Input the quantity on the Actual To Date in the Resources

2.Do global change

RCPT = QTD/BQ (Resource Percent Complete)

RCPT = RCPT*100 (to make value in Percentage)

PCT = RCPT (Equate Percent Complete to Resource Percent Complete)

3.Earned Value will be automatically calculated.

A
Andrew W 👤 Member for 21 years 7 months

Bends & Welds were only simple examples so that non-petro-chemical people could understand the problem without getting into complexities.

B
Bernard Ertl 👤 Member for 23 years 6 months

Andrew,



How are you planning the work? Ie. Are you planning a separate, detailed task for each bend, weld, etc. or are you planning one higher level "summarized" task that encompasses multiple bends, welds, etc.?



If the former, perhaps there is some mechanism for tagging/summarizing the number of tasks complete vs. in progress? We have a feature for doing this in our ATC Professional system (which also shows the breakdown of effort/manhours for the tasks), but I don’t know how this might be done in P3 or P3e.



If the latter, I question the validity of the process unless you are assured that all bends, welds, etc. require equal effort. Executing (2) 30" welds on an overhead line should require much more effort than (4) 4" welds on the ground. Then of course, different metallurgies can compound the problem, so I’m trying to see where knowing that 2/10 welds are complete versus 4/10 welds complete would really offer you a meaningful metric.



Bernard Ertl

InterPlan Systems - ATC Professional Shutdown / Turnaround Management System

S
Shahzad Munawar 👤 Member for 22 years 11 months

Question is" Can Percent complete be quantities"



The answer is that measurement of Physical progress covers your quantity completion aspect. So based on this your qunatities completion can easily be determined.


A
Andrew W 👤 Member for 21 years 7 months

Thanks Kevin.



Yes it might have some limitations but its a great start. It might even address some of the issues I had when using a non-labour resource.

K
Kevin Button 👤 Member for 22 years 11 months

Andrew



I’ll have another go at this...



If you were thinking of User Defined fields for "Total Qty" and "Qty Complete" you might be able to achieve what you want using Global Change. Make the activity % complete type Physical and create a global change with the criteria as follows:



If Total Qty is greater than 0 AND Activity Status is not equal to Completed

Then

Physical % Complete = Qty Complete / Total Qty

Physical % Complete = Physical % Complete * 100



I found that doing this it is possible for an activity to be 120% complete when it doesn’t yet have an actual start date, so you will need to make sure you have a few checks in place.



KB

A
Andrew W 👤 Member for 21 years 7 months

Thanks guys.



Firstly my subject was meant to say "Can Percent Complete be calculated from Quantities?" Ooops. But my post should have explained the situation clearly enough.



Kevin, if I understand you correctly, this concept had been suggested to me but would require the use of non-labour units to differentiate physical qty (non-labour) from hours (labour). I was not keen on using a separate resource.



Alex, I gather that the SDK is suitable only for import/export. I thought it may be suitable for adding custom functionality. I gather customisation is done using an API. Is there a good source of info on either/both of these tools.



David, I have no experience with P3. Only Suretrack. My requirements are not based on any application but rather a process external to planning software that we have been using for years. I wish to incorporate the two processes.

D
David Kelly 👤 Member for 21 years 7 months

Somewhat surprised to see "[Uncalled-for snide comment deleted by Moderator.]" at the start of my reply to this post. As I have just joined the forum, I am not sure of the "rules" I was trying to relate the poster’s experience of P3e arithmetic to his possible experience of P3 3.1.



I am confused.

A
Alex Wong 👤 Member for 23 years 4 months

Andrew,



Well SDK can import almost anything to P3e including update resources.



Its simple, I had set up a excel spreadsheet to not only automatic insert project and activities but also loading and changing resource which linked with our progress database. Its very good. Or using API you can even do it in web.



Alex

D
David Kelly 👤 Member for 21 years 7 months

[Uncalled-for snide comment deleted by Moderator.] If you pose the question as "can I have the same as "Tools:options:Summarization:Resource units" The answer is NO.



There is no option to have % complete as Earned Units/ Budgeted units * 100.


K
Kevin Button 👤 Member for 22 years 11 months

Make your % complete type Units. When you update actual units your activity % complete becomes Actual Units / Forecast Total Units.

A
Andrew W 👤 Member for 21 years 7 months

Thanks for your reply, however, I am familiar with both concepts.



In order for us to enter % Complete, we need to calculate the Percent Complete (as Qty Complete/Total Qty) rather than just estimate it. An example would be to enter a Total Qty of 380 when planning and then say a Qty Complete of 26 when updating progress. I then want P3 to calculate the percent complete (6.8%) from these figures and then update the Activity % Complete with the calculated value.



I was thinking of User Defined fields for "Total Qty" and "Qty Complete" and use the SDK to perform the calculation and update the Activity % Complete. Can this be done with the SDK?



Steps are not ideal for our application.

A
Alex Wong 👤 Member for 23 years 4 months

Yes you can you quantity to measure activity progress

You have to load the activity with the physical resource then progress it with physical quantity and relate it with your activity physical %



or use steps which is also very simple to measure physical % with quantity especially with multipule items


Forum Sponsor

Top Posters

sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
James Williams
74 posts