Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 export for Budgeted Units Early & Late by month for S-Curves in Excel

In the Open Standard
Nicolas BergerMember for 20 years 4 months
Created
7
2
0

Hi to All,

I am trying to do on P6 (V7) what I used to do when I was working on P3 a several years ago.

I used to generate my S-Curves on Excel from P3 by computing a Tabular Report displayed the following way :

TimeEarly startLate StartEarly FinishLate Finish
Month 1Budgeted UnitsBudgeted UnitsBudgeted UnitsBudgeted Units
Month 2Budgeted UnitsBudgeted UnitsBudgeted UnitsBudgeted Units

It was extremely useful and very easy to generate Early & Late Curves as well as forecast curves.

What I see today from P6, is only a way to export to Excel, the distribution budgeted units on a singular date but not Early and Late dates

 

How can I do that ?

 

Thanks very much in advance Planning Community

 

NB

Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Berker Colakoglu ·
    #1

    Hi,On the assignments page ,

    Hi,

    On the assignments page , at the distribution side, you can click display then go spreedshield fields then customize and you can find remaining early and late units under time interval/units and you can add them to your distribution layout.

    So the distribution rows will be early and late units.

    Regards,

    Berker

    Report
  2. 0
    Nicolas Berger ·
    #2

    That's great thanks so

    That's great thanks so much.

     

    very helpful !

    Report
  3. 0
    Mark Anthony Amores ·
    #3

    f

    f

    Report
  4. 0
    Mark Anthony Amores ·
    #4

    Hi all,I have some problems

    Hi all,

    I have some problems with deriving reports on cash flow. I cant run tabulated reports on cash flow showing

    early and late cost. I have modified on the Reports Editor but still it doesnt work out.

    Can anyone please help me how to extract those reports? I am using Primavera P6 version.

     

     

    Thanks,

    Mark

    Report
  5. 0
    Nicolas Berger ·
    #5

    I go back to this topic since

    I go back to this topic since indeed I finally succeeded to display on P6 the right columns and Rows but I can't make any copy/paste into Excel then.

    Does anyone have an idea how to copy/paste those kind of values in the 'Resource Usage Spreadsheet' or 'Activity Usage Spreadsheet' ?

     

    Thanks,

    NB

    Report
  6. 0
    Berker Colakoglu ·
    #6

    You can not copy and paste

    You can not copy and paste from resource usage spreadsheet ,try from Project/Resource assignments .

    Report
  7. 0
    Nicolas Berger ·
    #7

    That's it great thanks !

    That's it great thanks !

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?