Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to Generate S-curve

86 replies [Last post]
Cecil Soliva
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 17 Apr 2004
Posts: 20
In P6 there’s a lot of Report Templates ready to use. In my system S-Curve Report has been ommitted. I would like to ask how to generate an S-Curve showing in percentage by exporting it in excel.

Cecil

Replies

Hamed Eysavand
User offline. Last seen 9 years 43 weeks ago. Offline
Joined: 28 May 2014
Posts: 4
Groups: None
Hey Can anyone kindly send me the steps to make s-curve percentage in P6? My e-mail is: hamedesavand@yahoo.com Thanks.
Gary Whitehead
User offline. Last seen 4 years 46 weeks ago. Offline

Arnold,

 

I am aware it has been 4 or 5 years since you posted on this thread, yet you are still getting requests for you to email.

Could you please advise if you are still sending this stuff out? If not, i shall lock the thread closed.

 

Thanks,

 

Gary

Riyaz Shaik
User offline. Last seen 8 years 28 weeks ago. Offline
Joined: 18 May 2014
Posts: 3
Groups: None

Dear Mr. Arnold,

Can you please share with me the procedure of Generating S curve in P6.

My Email ID: riyaz.ssits@gmail.com.

Iam new to primavera and I want to generate S curve using pimavera for below scenarion.

Every year we will have many projects(Mechanical,civil,Instrument,etc) and we have to complete the projects on time.Below are the major milestones for each project.

1)Finalizing the scope of work

2)Creating PR

3)Awarding PO

4)Kick off meeting

5)DEP Approval

6)Equipment or Material Delivery

7)Construction

8)Punch list clearnace and System Handover

9)Depreciation and Closeout.

I have to track the completion status of each milestone with respect to time(duration) and I have to report the status of all ongoing projects to our Management.

Please let me know how I can generate S curve by assigning weightage to each milestone with respect to duration of milestone completion.

Your kind support will be highly appreciated.

Thanks in Advance....

Regards,

arvin pura
User offline. Last seen 9 years 6 weeks ago. Offline
Joined: 17 Mar 2014
Posts: 8

Hi Arnold,

Can you please send me a copy of the step on how to generate S-curve in P6.

thank you.

Arvin

Adolfo Caccialanza
User offline. Last seen 4 years 45 weeks ago. Offline
Joined: 3 Oct 2009
Posts: 14
Groups: None

The best solution for Progress Curves Early & late is at this site:

 

http://www.cla-it.eu/TMSDetails-general.html

 

Best regards

Mohd Hafiz Muhamed
User offline. Last seen 8 years 7 weeks ago. Offline
Joined: 7 Jul 2012
Posts: 5
Groups: None

Hi Arnold,

I would appreciate if you could send me the step. mohdhafizmuhamed@hotmail.com

 

TQ

Anning Sofi
User offline. Last seen 5 years 37 weeks ago. Offline
Joined: 22 Jan 2012
Posts: 89
Groups: None

P6 will not directly export %ages per time (x-axis) to excel and generate the s-curve from there.

The first post of Arnold is telling you how to export resources; but this is for resource loading per activity only.

P6 will only give you the resource allocation per time (month/week/year) per resource or group or resources, and this will be the basis of you S-curve in excel;

The resource allocation per time is generated thru the reports, or thru the resource assignments tab feature of P6

Jenny Ingco
User offline. Last seen 2 years 28 weeks ago. Offline
Joined: 9 Jan 2012
Posts: 116

Dear All,

Would you send me procedure on how to do S-Curve in P6 on my email hanson_ca76@yahoo.com?

I'd be thankful.

Regards.

Hilal Hallani
User offline. Last seen 12 years 5 weeks ago. Offline
Joined: 3 Nov 2011
Posts: 16
Groups: GPC Qatar

Arnold,

just trying to minimise these irelevent replies re emailing the steps for s-curve from p6. Is it possible if you just copy paste the steps in this post, or maybe its too big??

Regards

Hilal Hallani
User offline. Last seen 12 years 5 weeks ago. Offline
Joined: 3 Nov 2011
Posts: 16
Groups: GPC Qatar

Arnold,

just trying to minimise these irelevent replies re emailing the steps for s-curve from p6. Is it possible if you just copy paste the steps in this post, or maybe its too big??

Regards

Zeina Abou Jaoude
User offline. Last seen 12 years 11 weeks ago. Offline
Joined: 26 Jan 2012
Posts: 2
Groups: None

Hey,

Can you please send me the file on how to generate S-Curve in P6 on my email ze_jaoude@hotmail.com ?

I'd be thankful.

Regards.

ahmad syahidan mu...
User offline. Last seen 8 years 25 weeks ago. Offline
Joined: 25 Jan 2012
Posts: 2
Groups: GPC Malaysia

Hi Arnold,


Would you mind to send me too a copy of how to produe S-curve in P6 to syahidan@i-ras.com


thank you

marjoe luares
User offline. Last seen 12 years 14 weeks ago. Offline
Joined: 15 Sep 2011
Posts: 2
Groups: None
Dear Arnold,

Can u send me how to make s-curve (%) in P6 also?
My address: marjoe_092677@yahoo.com

Thank, Marjoe
mukunda y
User offline. Last seen 10 years 31 weeks ago. Offline
Joined: 12 Nov 2008
Posts: 97
Groups: None

Radha Krsihnan .

In P6 Planned % = schedule % Complete.

Radha Krishnan
User offline. Last seen 12 years 16 weeks ago. Offline
Joined: 12 Sep 2011
Posts: 3
Groups: None

Hai 

 

How to insert the Planned Progress % Column & Actual Progress % column in P6

Marina Azhari
User offline. Last seen 12 years 42 weeks ago. Offline
Joined: 27 Jun 2011
Posts: 3
Groups: None

Hye.

Can anyone kindly send me the steps to make s-curve percentage in P6?

My e-mail is: aki_jr9802@yahoo.com

 

Thanks.


Best regards, Marina  

mimoune djouallah
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388

 

Dear Planners.

i just uploaded a Excel template for how to generate.

Dynamic S curve.( planned and earned)
Dynamic Summary Progress report.
Dynamic Detailed Progress report.

https://www.box.net/s/ryfxdtnnyhz7qpufgp5l

for the planned value either you import directly from P6, or generate it using the early start and OD, but it is a very simplistic approach, as it suppose the distribution is linear and there is no holidays in the duration of the activity.

in the budget, put whatever you have either manhours or cost, or just value to map your weightage.

the progress is weekly based, you just put the value of the cumulative physical progress in %

and sorry for the hideous Histograms, i am trying to figure out how to change the setting in Excel chart.

hope this help
mimoune

Marwin U
User offline. Last seen 12 years 29 weeks ago. Offline
Joined: 9 Dec 2009
Posts: 7

Sir Raymund,

 

How to show two curves same as in P3 comparing baseline curve and actual, also the remaining curve as a continuation of the actual?

Deepak Gowda
User offline. Last seen 12 years 39 weeks ago. Offline
Joined: 13 Jun 2011
Posts: 13
Groups: None

Guys,

Can any one send me the procedure to create S-Curves using details from primavera P6.

Thanks for the help. My Id    deepak.kattemane@gmail.com

 

Kind Regards,

 

Deepak

 

deepak.kattemane@gmail.com

Raymund de Laza
User offline. Last seen 31 weeks 1 day ago. Offline
Joined: 23 Nov 2009
Posts: 762

I hope this will help other who didn't get the email.

1. Select View>>>Show on Bottom>>> Resource Profile

2. On top of the Bottom right pane select display>> uncheck Show All Projects

3. On the Bottom Right pane>> right click>> Resource Usage Profle Option...

4. Data Tab>> On Display>> Check the check box for Cost >>Check Budgeted under Cumulative>> Apply>>OK

5. On the Bottom left pane>> Select the individual resource you want to show the curve or select all resources to show the Curve of the entire project.

6. Adjust the timescale to show the interval of Time as required. By day.. week.. month .. quarterly.. yearly.. etc..

6. Good Luck!!!

 

Raymund

Irfan Khan
User offline. Last seen 10 weeks 4 days ago. Offline
Joined: 19 Jul 2009
Posts: 138

Dear Arnold,

 

pls send me copy of this here : irfan_kn2006@hotmail.com

 

 

thanks,,,,,,,,,,,,,,,,,,

ahmet k.
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 6 Jan 2011
Posts: 5
Groups: None

Hi Arnold,

i need also this step by step guide to generate S-curve.. Can you pls send me that document too ?  Thanks..

kochanahm@yahoo.com

Shah. HB
User offline. Last seen 18 weeks 2 days ago. Offline
Joined: 25 Nov 2008
Posts: 773

Please send to shahul16.mep@gmail.com

Many thanks

Shahul

Naveen Kumar
User offline. Last seen 13 years 15 weeks ago. Offline
Joined: 2 Dec 2010
Posts: 2
Groups: None
Hi Arnold,

Can you send me the steps to make s-curve percentage in P6?

My e-mail is: vmnaveenkumar@yahoo.com

Best regards, Naveen.  
jorge santos
User offline. Last seen 10 years 11 weeks ago. Offline
Joined: 10 Jul 2008
Posts: 13

hi arnold,

i have the same problem in p5, i dont how to generate s-curve and dont know how to export in excel.

could u pls. send me the steps.

my email add...jic077c18@yahoo.com

tnx in advance

jorge

Jia Qian
User offline. Last seen 4 years 15 weeks ago. Offline
Joined: 14 Dec 2010
Posts: 5
Groups: None

Dear planers,

I am a new scheduler and work for worleyparsons. Could anyone send me the steps how to generate a S-Curve in P6? My email is: qianjiaqian@hotmail.com

 

thanks a lot!

 

Jia

kamesh avasarala
User offline. Last seen 3 years 44 weeks ago. Offline

dear arnold,

i need the step.. could you pls email to me..
 

avasarala15@gmail.com

avasarala15@yahoo.com

Tanveer Ahmad Niazi
User offline. Last seen 6 years 4 weeks ago. Offline
Joined: 15 Dec 2005
Posts: 151
Groups: GPC Qatar

Hi Rafael

I don’t have much knowledge of computer setting but have but am receiving mails contain a same word in the beginning or in the middle from different senders. I made a filter with [if the “Subject” “contains” ----- sent to folder ------]. Now all of such mails are coming in to my new folder. This is because some time these mail are from my contacts also that I don’t want the server to block.  This may help you.

Thanx

Tanveer Ahmad Niazi
User offline. Last seen 6 years 4 weeks ago. Offline
Joined: 15 Dec 2005
Posts: 151
Groups: GPC Qatar

Hi

Cecil Soliva

Sony Lei

Mina Arsal

Arnold Puy and

Stewart Krieger

It would be very much appreciated if you send me either the step of how to make S-curve in P6, tanveeraniazi@yahoo.com

Thanx

Sony Lei
User offline. Last seen 8 years 31 weeks ago. Offline
Joined: 16 Dec 2010
Posts: 5
Groups: None

Hi Arnold,

very accidental found this useful topic,

I am very happy if you can share your steps for generating S-curve form P6 to Excel throu my email l_haison@yahoo.com

Thanks & regards

Mina Arsal
User offline. Last seen 7 years 22 weeks ago. Offline
Joined: 15 Sep 2008
Posts: 15
Groups: None
Hi Arnold,

Could you pls forward a copy of how to generate s-curve in p6:
mina.arsal@gmail.com
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Guys,

Already sent.

Stewart Krieger
User offline. Last seen 2 years 45 weeks ago. Offline
Joined: 1 Oct 2008
Posts: 3
Groups: None
you will be very much appreciated if you send me the step of making S-curve in P6, my e-mail address is shj.krieger@mindef.nl
Rafael Davila
User offline. Last seen 13 hours 31 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Can any of the moderators lock this thread as to stop annoying “e-mail me” messages? Every time someone posts a request for the file I receive an e-mail message for each posting, I cannot find a way to stop these annoying e-mails.

It can be with a note reminding PP members they can still ask for the file by contacting the person through PP messaging system. Don’t delete the thread; leave the option open for those who want the file.

Please.

Again I un-clicked the e-mail me option on this screen, to give it a last chance. It would be unfair if I have to change my e-mail on the PP database to a fictitious as to avoid these e-mails, this will rule me out of the PP messaging service.

Best regards,
Rafael

Thanks anyway It was not just this thread, after posting in many threads this started to happen in more and more threads until it became intolerable. I had no other opton than to change my e-mail in the PP database to a fictitious one, ruling me out of the messaging service and of the notice from postings on threads of my interest.
Jhorbam Baena Orozco
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 14 Sep 2009
Posts: 75
Groups: None
I Arnold...I’m reading this post and I need the information about how generate the S-Curve in P6...please can you send me to my e-mail?...jhorbam @ gmail . com....THANKS MAN.
Rafael Davila
User offline. Last seen 13 hours 31 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Sorry

Just trying to stop e-mail me every time someone ask for a copy, is kind of annoying.

I just uncliked the e-mail me box, getting to this window is the only way I know to get into the option, hope this time works as I tried before and did not worked. Is a kind of a life sentence from various threads, is not just this one.

If someone knows how to stop it please let me know how I will appreciate it very much.

For months I have been dealing with this but as more and more threads start to show the "send me a copy" behavior it has become too much.

For the record I just double checked I unchecked the E-mail me selection box on this screen.

Best regards,
Rafael

Mesdward Teniozo
User offline. Last seen 11 years 48 weeks ago. Offline
Joined: 5 Mar 2009
Posts: 12
Dear Arnold,

is there any way or step i could present a bar chart with s-curve in P6. Could you send me a step-by-step guide how to prepare this.

Cheers.
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147

You’re welcome guys.

Mesdward Teniozo
User offline. Last seen 11 years 48 weeks ago. Offline
Joined: 5 Mar 2009
Posts: 12
Thank you Arnold.
Cheers
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Guys,

Already sent.

Mesdward Teniozo
User offline. Last seen 11 years 48 weeks ago. Offline
Joined: 5 Mar 2009
Posts: 12
Dear All,

I’m calling all who has the copy of how to generate S-Curve in P6 to kindly send me also a copy for my reference in my email address - mesdward@gmail.com
Rafael Davila
User offline. Last seen 13 hours 31 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
By the way even as an Enterprise Tool P6 is not so good, is full of bugs and missing many of the functionality that was available in enterprise software of the 60’s and 70’s. Like ARTEMIS for example.
Rafael Davila
User offline. Last seen 13 hours 31 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Raviraj Bhedase

Yes you got it right, your call is appropriate, I do appreciate a lot all our members no matter what software they do use. I even consider P6 the suitable tool when you need an Enterprise application, like when you are a Utility Co. but from P3e to P6 the software is no good for the average construction contractor, is a monster.

Primavera started getting everywhere long ago, it even took over PMI, just look at their definition of Time Impact Analysis and you will read about "Fragents" only available in P3 and maybe absent in P6. These and many similar specs were written by the servants of Primavera who have vested interest in their products and do not care about the American spirit for free enterprise.

The problem is that this thing is taking over where it is not the appropriate tool. My fear is that eventually Government Agencies will require you to use it.

I always thought that universities should develop open source software that would be available free to be used in government jobs, to satisfy government needs, that can be modified by any developer. Then these modifications could be tested and certified to be used as a substitute in these jobs.

Best regards
Rafael
A D
User offline. Last seen 3 years 23 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Calm Down Rafael,

Dont mix ur oracle merger thread with this. Getting S-Curve in P6 is very easy. Its the people who dont want to take pain or otherwise they dont have time to get things in detail.

But i do agree with ur opinion abt P6/Oracle.

Cheers,
Rafael Davila
User offline. Last seen 13 hours 31 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
It would be easier if you buy at a Flea Market some 20 years old software that can do this at the click of the mouse.

If you want to get rid of the mouse then P3 DOS version might be a bargain.

Faster, better and cheaper.
mohamed ibrahim m...
User offline. Last seen 7 years 42 weeks ago. Offline
Joined: 29 Aug 2009
Posts: 3
Groups: GPC Qatar
Hi Arnold,


Would you mind to send me too a copy of how to produe S-curve in P6 to ifnizar@gmail.com

thank you
Mesdward Teniozo
User offline. Last seen 11 years 48 weeks ago. Offline
Joined: 5 Mar 2009
Posts: 12
Hi Arnold,

Would you mind to send me a copy how to produe S-curve in P6 in mesdward@gmail.com

Cheers
wungyea lee
User offline. Last seen 14 years 19 weeks ago. Offline
Joined: 23 Dec 2005
Posts: 14
Thank you, Arnold, it works great, you are a great help. but it is a pity that this kind of problem exists in this costly package




Lee wungyea
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Wungyea,

Yes, that’s correct. However, there is a workaround to play with the 6 digits or more than. In order to do that, try the following:

1. Let say you have 10 digits (e.g. 1234567890).
2. In this case, you can only have the 6 digits as a whole number but you can have as many numbers with decimals places (e.g. 123456.7890).
3. In order to convert the decimal into whole number, you need to delete the period/dot (.) using (<-) backspace or delete on your keyboard.
4. Just simply point your cursor in between the 6 & 7 numbers and delete the point/dot using the No. 3 step. The result 9e.g. from 123456.7890 to 1234567890).

Try this and let us know.

Regards,

Arnold
wungyea lee
User offline. Last seen 14 years 19 weeks ago. Offline
Joined: 23 Dec 2005
Posts: 14
Arnold ,
I have a question if you could help.
In using your recommendation method to generate S curve, I fould that the "Divided interval totals by" can just accept 6 digits and no more , is there any setting I forget?
abdelrahman abdel...
User offline. Last seen 10 years 42 weeks ago. Offline
Joined: 11 Aug 2009
Posts: 4



Could you please send it to me,

my email id is: abdelrahman_mahmoud1984@yahoo.com

with thanks & regards,

Abdelrahman
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147

Already sent.

Aravinth Kumar
User offline. Last seen 11 years 5 weeks ago. Offline
Joined: 11 Mar 2009
Posts: 8
Dear Arnold,

can i too get the copy of the steps..

pls email me to varavinthkumar@gmail.com

thanks,
aravinth
DURGESH NARAYAN M...
User offline. Last seen 12 years 26 weeks ago. Offline
Joined: 8 Apr 2007
Posts: 9
Groups: None
my email id is durgesh.etappd@gmail.com
DURGESH NARAYAN M...
User offline. Last seen 12 years 26 weeks ago. Offline
Joined: 8 Apr 2007
Posts: 9
Groups: None
Guys i am also struggling with S-curve from P6.if any one can send me the steps to workout s-curve in P6.

Regards

Durgesh N. Mishra
ismail khan
User offline. Last seen 13 years 36 weeks ago. Offline
Joined: 9 Nov 2008
Posts: 21
Groups: None
Could you please send it to me,

my email id is: mflismail@gmail.com

with thanks & regards,

Ismail
Anbin Ponnith
User offline. Last seen 8 years 5 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Could you please send it to me,

my email id is: anbin.ponnith@hotmail.com


with thanks & regards,

Anbin Ponnith
wungyea lee
User offline. Last seen 14 years 19 weeks ago. Offline
Joined: 23 Dec 2005
Posts: 14
Arnold,Thank for your kindly response,


Lee wungyea
Ruel Camaquin
User offline. Last seen 3 years 31 weeks ago. Offline
Joined: 16 Nov 2008
Posts: 100
Arnold,

Thank you very much, this is very useful...

Cheers!

Ruel
MOHAMMED SHAHABUDDIN
User offline. Last seen 13 years 17 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 5
Please send me the steps to my email ID

shahab.PCM@gmail.com.

Regards,
Reza Heydari
User offline. Last seen 6 years 21 weeks ago. Offline
Joined: 30 May 2008
Posts: 9
Groups: None

thanks a million Arnold!
It’s very useful for me.
Reza
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi All,

Sorry for the late reply. I was too busy for the past 1 week. I will send you the copy however, we are talking about on how to show the % in P6 instead in Excel sheet and not how to generate S-Curve into Excel.

If you need this steps then give me time.

Regards,

Arnold
Nicola Sykes
User offline. Last seen 12 years 44 weeks ago. Offline
Joined: 20 Feb 2007
Posts: 9
Groups: None
Dear all,

I know your not supposed to post these sort of posts on here, but generating s- curve is something i have been struggling with. Could anyone possibly send me a copy of the steps?

I would really appreciate it.

Many thanks

Nicola
nicknu@msn.com
Ruel Camaquin
User offline. Last seen 3 years 31 weeks ago. Offline
Joined: 16 Nov 2008
Posts: 100
Dear All,

Just like to know if somebody has already recieved the copy of the steps in generating s-curve? If so, kindly forward it to camaquin_rj@yahoo.com.ph or rcamaquin@eeblackph.com.

Thanks & Cheers!

Ruel
Bahari Sulaiman
User offline. Last seen 7 years 48 weeks ago. Offline
Joined: 16 Mar 2002
Posts: 15
Despite the steps in P6, I guess one needs to understand the algorithm of generating the S-Curve so that it can be tailored to certain requirements.
wungyea lee
User offline. Last seen 14 years 19 weeks ago. Offline
Joined: 23 Dec 2005
Posts: 14
you will be very much appreciated if you send me the step of making S-curve in P6, my e-mail address is wungyea@mail.nsysu.edu.tw
Muhammad Salman
User offline. Last seen 13 years 1 week ago. Offline
Joined: 16 Sep 2008
Posts: 3
Hi Arnold,

Can you email the steps to me too at engrsarshad@gmail.com
Thanks ad have a good day.

Cheers

Salman
Barry Fullarton
User offline. Last seen 10 years 25 weeks ago. Offline
Joined: 27 Aug 2008
Posts: 101
Groups: None
sorry , i still dont have this and cant seem to understand and grasp how this can be done ?

Ir. P. Jaya Chandar
User offline. Last seen 11 years 13 weeks ago. Offline
Joined: 13 Apr 2009
Posts: 14
Hi Arnold,

Can you email the steps to me too at chandar70@gmail.com
Thanks ad have a good day.

Cheers

Chandar
amran mustapha
User offline. Last seen 7 years 3 weeks ago. Offline
Joined: 11 Jul 2007
Posts: 3
Groups: GPC Malaysia
Hi Arnold,

Can you email me the steps?

My email: wmamran@gmail.com

Regards
Amran
Reza Heydari
User offline. Last seen 6 years 21 weeks ago. Offline
Joined: 30 May 2008
Posts: 9
Groups: None
Hi Arnold,

Can i also get a copy of the steps?

My email :heydari.reza@gmail.com

With Regards,

Reza

Ruel Camaquin
User offline. Last seen 3 years 31 weeks ago. Offline
Joined: 16 Nov 2008
Posts: 100
Arnold,

Can i also get a copy of the steps?

My email add: rcamaquin@eeblackph.com and/or camaquin_rj@yahoo.com.ph

Many thanks!

Cheers!

Ruel
Antonio Teixeira
User offline. Last seen 11 years 13 weeks ago. Offline
Joined: 19 May 2007
Posts: 6
Groups: None
Arnold, good afternoon!!

Can you send me the steps to make s-curve percentage in P6?

My e-mail is: ateixeir@msn.com

Best regards, Junior from Brazil.
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Cecil,

Good day! Just wait till tomorrow, I need to finish my monthly report & I am still reviewing the recovery plan of the contractor.

Regards,

Arnold
Cecil Soliva
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 17 Apr 2004
Posts: 20
Arnold, Good Day!!

Here’s my email address: cesolus@yahoo.com and I’m glad that you share your brilliant mind to all the planners in the world.

Thank you and more power..

Cecil
Antonio Teixeira
User offline. Last seen 11 years 13 weeks ago. Offline
Joined: 19 May 2007
Posts: 6
Groups: None
Dear Arnold,

Can u send me how to make s-curve (%) in P6 also?
My address: ateixeir@msn.com

Thank, Junior
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Barry,

Yes, it will give you the Schedule % Complete depends on your Activity’s Baseline Duration has been completed and computed based on where the current data date falls.

You can export the percentage value to excel using "Activities" as your Export Type. However, you cannot modify this percent in Excel as well as in P6.

Regards,

Arnold
Barry Fullarton
User offline. Last seen 10 years 25 weeks ago. Offline
Joined: 27 Aug 2008
Posts: 101
Groups: None
Hi Arnold

this looks like it can really help, question?

1. If I export the resources, ithen in the export I should see the Planned % ( type? )
\2. Then there will be teh actual to date
3. I understand the Chart wizard

My question is that will the export give me the Total Target Planned % Progress ,

this is is updated by the update progress at every cycle update
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Cecil,

I am sorry but I cannot find it. I am using P6.2.1 I tried to search in my colleague’s computer he is using P6.0 but unfortunately it is also not there.

You can create S-Curve in your P6 by percentage. Send me your email address and I will send you the steps.

Regards,

Arnold
Cecil Soliva
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 17 Apr 2004
Posts: 20
Yes, Arnold I’ve done that manually in excel file. In P6, in Display Reports Templates; you can find R031- S Curve Generation (Actual Units)as I read it in my manual but unfortunately I can’t find it in my program, I am thinking it was deleted. If you can find it in yours, eventually you can help me by just clicking at the wizard option at the right side of the Reports window, then click next you can view selected subject areas and columns. I just wanted to know what is specific options involve in that field to create S-Curve by percentage wise..not in units nor in cost, because by simply clicking on this reports it will show you in Weekly or Monthly S-Curve with corresponding Spread Sheet in excel..or in P6 Preview or in HTML File.

thank you,

Cecil
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Cecil,

You are welcome. Anyhow, where do you want to show your S-Curve, in Excel Spreadsheet or P6 Windows?

Because if you are working with Excel sheet you need to create a "Chart Wizard" utilizing the actual & planned values you had exported from P6.

If you are working with P6, then simply go to View --> Show on Bottom --> Resource Usage Profile or Activity Usage Profile as well as you can go to "Tracking" located at the left corner of your monitor.

Let us know if you have done this.

Regards,

Arnold
Cecil Soliva
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 17 Apr 2004
Posts: 20
Thanks Arnold for your generosity..You are right it shows the right way what you have stated in below thread. I’ve done it but S-curve doesn’t shows. In what options do I have to select in column tab so that s-curve will be generated along with the spread sheet.

regards,

cecil

Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Cecil,

If I understood your question correctly, You want to export the actual & planned value from P6 to Excel spreadsheet?

If this is what you want then the steps below will works. If not then, you must cite an example.

Regards,

Arnold

Cecil Soliva
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 17 Apr 2004
Posts: 20
thank you Arnold it helps me, but what I wanted to know is how to export in excel showing Actual VS Planned Percentage in spread sheet and in Graph automatically.
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Cecil,

Welcome to Planning Planet.

Follow the following steps.

1. Go to File --> Export
2. In Export Format, Select Spreadsheet-(XLS) then NEXT
3. In Export Type, Tick Resource Assignment then NEXT
4. In Project to Export, tick the Export Box then NEXT
5. In Select Template, select ADD, rename the template for future use.
5.1. In Column tab, select the available option you wanted to export.
5.2. In Filter tab, add a new filter and select only resource you wanted to export.
5.3. In Sort tab, you can sort by activity, resource & etc...When done select OK then NEXT
6. In Select XLS File, select the radio button and save/open the file into drive C or whatever, then NEXT
7. Then Select FINISH.

Hope this helps.

Regards,

Arnold
Suraya Hani Hussin
User offline. Last seen 7 years 35 weeks ago. Offline
Joined: 25 Jan 2006
Posts: 12
Groups: GPC Malaysia
dear arnold,

i need the step.. could you pls email to me..

hanisurayaz@gmail.com