Step 6 – Defining the S-Curve’s Resources For this tutorial purpose we’ll select the Line chart. To graph any curve we should go to Insert Section of Excel and then choose a chart type in charts tab. You can see the formula in the Excel file attached to this tutorial. To calculate interval progress and cumulative progress, just divide the value for each month (man hour needed for each month) by the total value (the summation of all man hours). Step 4 – Calculate the Progress Percentage All we need is to use some formula to calculate the percentage progress for each month in our table. Now we have all the tools to paint a perfect picture of our project resources. Step 3 – Copy and paste the needed data in separate sheetĬopy the data to separate worksheet. So we just copy and paste these two rows and the date row to another sheet to have more space doing our job. They have the information needed for each month.
To draw resource curves, what we need is the two highlighted rows which are the cumulative total and the incremental total.
You can modify the primary sheet for better graphical features. Step 1 – Export Primavera P6 Resource Assignments to Excelįollowing the steps from our previous tutorial, you now have all the resources and assignments in an Excel sheet. Excel Spreadsheet (Excel 2007+): P6_Scurve_Example.xlsx – 1.5Mb
0 kommentar(er)
