How to Generate S-curve

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

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.

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

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

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

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

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

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

Dear Arnold,

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

Thank, Junior

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

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

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,

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

Hi Arnold,

Can i also get a copy of the steps?

My email :heydari.reza@gmail.com

With Regards,

Reza

Hi Arnold,

Can you email me the steps?

My email: wmamran@gmail.com

Regards
Amran

Hi Arnold,

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

Cheers

Chandar

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

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.

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

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

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

thanks a million Arnold!
It’s very useful for me.
Reza

Please send me the steps to my email ID

shahab.PCM@gmail.com.

Regards,

Arnold,

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

Cheers!

Ruel

Arnold,Thank for your kindly response,


Lee wungyea

Could you please send it to me,

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


with thanks & regards,

Anbin Ponnith

Could you please send it to me,

my email id is: mflismail@gmail.com

with thanks & regards,

Ismail

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

my email id is durgesh.etappd@gmail.com

dear arnold,

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

hanisurayaz@gmail.com

Dear Arnold,

can i too get the copy of the steps..

pls email me to varavinthkumar@gmail.com

thanks,
aravinth

Already sent.

Could you please send it to me,

my email id is: abdelrahman_mahmoud1984@yahoo.com

with thanks & regards,

Abdelrahman

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?

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

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

Hi Arnold,

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

Cheers

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

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.

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,

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

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.

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

Guys,

Already sent.

Thank you Arnold.
Cheers

You’re welcome guys.

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.

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

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.

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.