Developing Resource Curve/Progress Curve from P6 Data Using Report Wizard
if you want to get the detailed S curve report and histogram , you have to export it into excel. It is done with a few clicks using Report Wizard. Report Wizard helps you save your time by creating resource allocation reports for each type of histogram/s curve.
Step to create time based histogram and S-curve
Open the selected project.
Go to Tools > Report, when you at there, you will see All Reports layout showing all the reports.
Look for Report Group: Resource Usage to organize to the newly added report to group in resource usage group so that you can find this report easily when you need.
Right click > Add > New Report > Next > Select the “Resources” in the Subject Area box > Select Time Distributed Data check box to see the project data over time frame and click Next .
To configure selected subject areas for the required data, select the Resource Name in the columns box, Add filter for current project’s resource as shown in figure below.
You will find Timescale tag and Time Interval Fields tag in the Date Options window upon completion of step 5. Select Show Time Intervals and Show Total check boxes to display project data over period and all time respectively.
In Timescale tag, set the time scale start as PS-Earliest Project Start, time scale finish as PF-Latest Project Finish, date intervals as week (select day, month as desired).
Review Resource Loading
To review manpower loading, select “Calculate Average “ option in Timescale tag to calculate manpower allocation per period. Select Budgeted Unit (to display planned data) and Remaining Early Unit (to produce forecast data) in Time Interval Fields tag.
Name the Report Title and click “Next” and save it.
Go to Run report > Select ASCII Text file > Select Field Delimiter and Text Qualifier , and choose the output file location to export P6 data to excel as shown in figure below.
Finally, the exported manpower loading data would be looks like this. Planned and forecast data are the same in this post as project hasn’t been scheduled.
Now, you can produce the desired resource histogram chart in excel.
Review Progress Curve
You can also export P6 data to make progress S curve using this method.
Create the new report by following all the steps in "Step to create time based histogram and S-curve".
Leave “Calculate Average” check box as blank (i.e. do not select it). As a result you will get resource hours data.
Actual progress data would be produced when the actual works are begun. To display actual progress data, add Actual Units to Time Interval Fields tag.
Run the report using step -3 in "Review Resource Loading " and export it to excel. The exported data is man hour unit.
Calculate the periodic progress from the periodic hours divided by total project hours.
Once progress calculation is done in excel, insert S curve chart to view the progress curve.