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.

 

 

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

 

 

 

 

 

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