Performance % Complete Vs Schedule % Complete

Gents,

In P6V7 ,Is it possible to show Schedule % Complete and Performance % Complete Values the same in the columns of a Revised Schedule before saving a copy for a new baseline?,Planned dates = Actual dates and Planned Progress = Actual Progress in a Revised Schedule thus making Planned S-Curve = Actual S-Curve prior to Updating and scheduling the new baseline.

MNT

You are going to produce the chart in excel anyway.

An alternative to Arnolds report, and maybe a quicker way, is to use the Assignments Tab at the Left column.

Use your filters, define your layout. At ther right side of the screen is the time scale; rightclick on the right side to define your spreadsheet fields. P6 will show the assignments as per timeframe chosen.

Copy the data, and paste in excel

Generate your S-curves in excel.

Before you exit the Assignment window, save it as a Layout so you can use it next time.

Jerome,

Thank you sir, actualy thats what im doing I hjust want to confirm if it is avialble in report tabs because maybe we can still edit it..

Thank you,

Jun

jun,

s-curve is not available in p6 reports. u can directly generate/print it from activity usage profile or resource usage profile.

mnt,

schedule % complete = planned value divided by budget at completion

performance % complete = earned value divided by budget at completion

earned value & planned value can be seen p6 activity usage spreadsheet, but u have to use the weightage as cost of a dummy resource assigned to activity rather than encoding it as an expense item.

   ex. input a resource named "Cost". select material type & calculate cost from units.

        assign the resource to activities and in the resource tab>budgeted units, enter the weightage u want to use

after the input the weightage will appear in the budgted cost column in the activity table.

you an now open the activity usage spreadsheet or the resource usage spreadsheet to view the planned values (as weightage) and the earned values (as weightage). You can copy and paste it to excel. Just calculate for the  schedule & performance % complete.

i hope this help.

jerome

ANY ONE KNOWS HOW TO MAKE REPORTS TO SHOW THE S-CURVE GRAPHS IN THE REPORT TABS.

tHANK YOU.

Dear francis

When using the method mentioned in your post and update schedule to generate actual S curve based on dummy resource i get tow deffent vallues for actul resource consuming on activities one for early dates and other for late dates it means i have tow actul curves and it is not logic please advise me about this matter

Hi Alexander,



In order to produce or create Schedule % Complete" in Report:



1. Go to Reports

2. Add a new report select Next.

3. In Select Subject Area, mark "Time Distributed Data" and select "Activities", then Next.

4. In Configure Selected Subject Areas, Select (e.g. Columns, Group & Sort, and Filter). It depends on your needs. Then select Next.

5. In Date Options, select "Timescale" Date Interval = Month, mark the check box next to "Calculate Average" and put the Total Amount divide it with 100. (i.e. Total Amount = 500,000/100 equals to 5,000). Select OK.

6. Select Time Interval Fields, in "Available Options" select "Time Interval" --> BL Project Total Cost (If your schedule is cost loaded, if not try labor units) then select OK.

7. Mark the check box next to "Show Time Intervals" then Next.

8. In Report Title, rename it with "Schedule % Complete" then Next.

9. Next

10. Save Report then Finish.



Now, Run the Report by clicking the green color "Arrow" located at the right corner of your monitor.



In Run Report, select ASCII "Field Delimiter" (’), "Text Qualifier" (").



In Output File, select the location where you want to save your file .csv and mark the "View file when done" and select OK. This will open the MS Excel Sheet with the corresponding data.



Hope this helps.



Regards,



Arnold

Alex,



You could easily do this by making use of the Resource Usage Spreadsheet in the activity and bar chart view. For baseline all the budgeted values will be distributed against the time line where as , and the actual and remaining values could be obtained for the Statused Schedule.



From the above values , you could easily make a profile making use of the spreadsheet.



Cheers

Alex,



Dummy Resource assignment would not prolong your project (to avoid beefing up the budgeted quantity using Units/Day could be changed to 1hrs/day which would correctly assign the duration of every activity.



As you pointed out , I afraid we are prolonging any duration here by using this method , rather Primavera calculates this data as a percentage or a ratio hence duration got no impact due to this resource assignment.



Other effective method (bit tedious but result oriented) could be-



Assign your baseline schedule with resources for every activity and these budgeted quantities could be used for getting a baseline profile and on updating you will be able to generate month wise Performance and Scheduled %s.



Cheers

Alex,



I suggest you to assign a dummy(non labour/non material) resource and assign it a default Units/Time as 1. This Resource could be termed as Units per Time Period as it takes up the individual activities original duration as the budgeted quantity.



Any resource allocation you need to do before statusing the program as Primavera doesn’t assign resource to an updated activity.



You can now generate Schedule and Performance % distribution graph against the baseline month wise and on updating the same profile could be repeated for statused Schedule.



I hope this will help you to overcome your bump!!!



Cheers,



Francis Moyalan Varghese