Hi Rafael,

I tried to create the S-Curve sample using the pdf file you have attached here. I did get everything exactly same until selecting Columns, Group & Sort & filter. But then after I don’t get that date options where I can select the time frame and time interval fields. I am straight away getting name he resource and finish. If I run that report it will only give me name of the resources but not the data as I can’t assign fields for this report. I am using P6 V7. Can you please tell me if there is anything different I need to do or any other way I can assign these two missing fields to my report to complete?

Thanks

Nilkamal

I used Spider Project to demonstrate the use and interpretation of Cumulative or S Curves, the principles remain the same for all jobs no matter what software.

The S Curves are generated directly by Spider Project.

The risk charts are also from Spider Project, these are runs that represent true risk from the original schedule, not like with other software that import from a different software/version whose resource leveling and other functionalities such as use lag calendars, use of constraints and a few others are implemented differently, not all inconsistencies can be fixed by changing a few software options as some vendors will suggest.

I do not use P6 but using Google found the following links that shows a way to generate the data for creating S Curves.

http://primaverarena.com/wp-content/uploads/2010/05/S-curve-creation-for-P6.pdf

The following links provides some tutorials that might be of interest and perhaps showing a different approach.

http://www.toolboxforplanning.com/p/tutorials.html

http://www.toolboxforplanning.com/2010/10/excel-2003-tutorial-creating-progress-s_16.html

You can download their template or a modified version I just created to include early and late banana curves from the following link.

http://www.mediafire.com/download.php?ekc33bya2nd44e4

Good luck,

Rafael

I see you are running the Graphs outside of P6 , in Risk Analysis? how did you manage to do this

Question

1. To set the baseline curve , i took the units as allocated in the resources , man-hours , and they were assigned at WBS Level , in a Level of Effort Activity ,

2. This was exported to Excel and we produced a Planned Curve, but this is the "early” start dates, need to know how to get the late Curve, so that I can form the ‘Californian” banana curve

3. We then track the Volumes done in a separate spread sheet that is aligned to the Activities in the Program,  

4. We get the summary Physical Percentage Complete from this and place this number into the Columns in P6 , now to calculate Performance Percentage Complete we reduce the Remaining Duration or extend it to ensure that Performance percentage and Physical match as closely as possible

5. once the above is done , we open the resource window at the bottom and ensure that the RD in the activity window equals the RD in the Resource

6. We then filter for the resources and “dump this out into excel and use the Actual to Date as Earned and the remaining as the Forecast

I am not sure how accurate this is as if your manipulate the RD in the resource tab , will it recalculate the Actual Hours , if so , its seem to be unstable in reporting  

Any Comments