How to Generate S-curve

Submitted by Cecil Soliva on
Oracle Primavera - PM6

Member for

18 years 7 months
Member for 18 years 7 months
Submitted by DURGESH NARAYA… on Tue, 2009-08-25 07:24
Permalink

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

Member for

19 years 10 months
Member for 19 years 10 months
Submitted by wungyea lee on Tue, 2009-08-18 09:53
Permalink

Arnold,Thank for your kindly response,





Lee wungyea

Member for

16 years 11 months
Member for 17 years
Submitted by Ruel Camaquin on Mon, 2009-08-17 21:37
Permalink

Arnold,



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



Cheers!



Ruel

Member for

17 years 5 months
Member for 17 years 5 months
Submitted by Reza Heydari on Mon, 2009-08-17 09:05
Permalink



thanks a million Arnold!

It’s very useful for me.

Reza

Member for

18 years 6 months
Member for 18 years 6 months
Submitted by Arnold Puy on Mon, 2009-08-17 07:55
Permalink

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

Member for

18 years 8 months
Member for 18 years 8 months
Submitted by nicknu on Mon, 2009-08-17 07:03
Permalink

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

Member for

23 years 7 months
Member for 23 years 8 months
Submitted by Bahari Sulaiman on Sat, 2009-08-15 21:15
Permalink

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.

Member for

18 years 5 months
Member for 18 years 6 months
Submitted by Antonio Teixeira on Thu, 2009-08-06 13:49
Permalink

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.

Member for

18 years 6 months
Member for 18 years 6 months
Submitted by Arnold Puy on Tue, 2009-08-04 02:08
Permalink

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

Member for

21 years 6 months
Member for 21 years 7 months
Submitted by Cecil Soliva on Tue, 2009-08-04 01:44
Permalink

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

Member for

18 years 6 months
Member for 18 years 6 months
Submitted by Arnold Puy on Mon, 2009-08-03 10:32
Permalink

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

Member for

18 years 6 months
Member for 18 years 6 months
Submitted by Arnold Puy on Mon, 2009-08-03 10:04
Permalink

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

Member for

21 years 6 months
Member for 21 years 7 months
Submitted by Cecil Soliva on Mon, 2009-08-03 09:49
Permalink

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

Member for

18 years 6 months
Member for 18 years 6 months
Submitted by Arnold Puy on Mon, 2009-08-03 09:14
Permalink

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

Member for

21 years 6 months
Member for 21 years 7 months
Submitted by Cecil Soliva on Mon, 2009-08-03 08:53
Permalink

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


Member for

18 years 6 months
Member for 18 years 6 months
Submitted by Arnold Puy on Mon, 2009-08-03 08:26
Permalink

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


Member for

21 years 6 months
Member for 21 years 7 months
Submitted by Cecil Soliva on Mon, 2009-08-03 07:51
Permalink

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.

Member for

18 years 6 months
Member for 18 years 6 months
Submitted by Arnold Puy on Mon, 2009-08-03 06:58
Permalink

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