Toolbox4Planning: Tutorial-How to generate S curve/histogram from Primavera, P6

Go to>> Tutorial-How to generate S curve/histogram from Primavera, P6 - Part I

To View Cum Budgeted Units and Actual Units Columns in Spreadsheet Fields

1. Click on the layout area and select Resource Usage Spreadsheet as shown in figure below.

2. After Resource Usage Spreadsheet window is opened, you will see resource usage spreadsheet field area (i.e blue shading area). See figure below.

3. Point the mouse to anywhere on the resource usage spreadsheet field area or click on Display button to view the desired columns . Go to Spreadsheet Fields >> Customize as shown in figure below.

4. Then you will see the spreadsheet field window showing Available Options and Selected options. Remaining Units (Remaining) is shown in selected options field by default. It is used when the remaining percent complete or remaining man hour data are analyzed. For now, select Remaining Units and hide it by clicking backward field.

Click the forward arrow button to select Cum Actual Units and Cum Budgeted Units as shown in figure below.
In case you wish to view Early Curve and Late Curve , then select the Cum Remaining Early Units and Cum Remaining Late Units.

5. Finally, you will see the resource usage spreadsheet field showing Cum “budgeted units and actual units” fields and data that can be exported to Excel Spreadsheet by copy and paste option.

Group/Organize the Column Data

Things that we should have done before export P6 data to excel are resource grouping and time scale format. Resource grouping represents what you want to report or analyze. Group the resource as total when you want to see overall summary data only. To view Group and Sort window, go to View >> Group and Sort by >> Customize. In Group and Sort window, mark on Show Grand Totals and Show Summaries Only to see overall summary data. See figure below.

Set the Timescale format

You may change the time scale format when you are preparing to export spreadsheet data. The exported P6 data would be displayed as weekly if the date interval is set to month/week. To see this changes, click the display button on the spreadsheet field area. Go to Timescale and you will see Timescale window >> set to Calendar in the date format type box and Month/Week in the date interval box.