Brief methodology for undertaking QSRA/QCRA.Is project control a department or something else? - By, Dr Dimitris Antoniadis.Structure of the project control department - By, Dr Dimitris Antoniadis.The basic project control supporting documentation - By, Dr Dimitris Antoniadis.There are different ways of developing S-curves in Excel but this method works well in many project circumstances. With this new P6 Resource S-curve, now your project manager can easily tell you there is something wrong with resource assignment and some leveling should be done on resources to achieve a better distributed resource S-curve. The following curve which is the final curve is the result of doing some exercises with those features: In that chart you can change the color of curves, add title to curve, add table to curve. In Excel 2007, when you select a chart, a “chart tool” tab will appear on the top right hand side of toolbar. Now you have a resource S-curve which still needs some modification: Right-click on the right-hand vertical axis and select “Format Axis” in the dialogue box go to Axis options and change the second value from the top of form to 1.00. Step 9 – Adjust the Right-hand Vertical Axis In the “change series chart type” box, select “2-D Column” chart. Right-click on the monthly interval man hour curve (ie:the blue curve) and then select the “change series chart type”. Step 8 – Change the data type to a “2-D Column” chart In the” format Data series” box select the “Cum Progress” as the secondary curve (it means that this s-curve values are shown on the right hand axis) Right-click on the curves and select “Format Data Series”. Step 7 – Select a Primary and Secondary S-Curve Now we should modify this s-curve, so we go step by step: Select all the dates as the label range for the horizontal axis and hit “OK” on dialogue box and then on the “select Data Source” box. To do that on the “select source data” box and under the “Horizontal Axis label”, hit the edit button and you will see a similar dialogue box as the above dialogue boxes: The last source definition is for the dates which result in our X axis. The row that shows interval man hour for each month We should do it 3 times to define all the sources for our final S-curve. In this box define all the sources one by one. Remove all the predefined sources and then hit the “Add” button. Right-click on the curves that Excel generated by default, which is not the curve that we want, and choose “Select Data”. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |