Lag and Original Duration

L
Larry Cahn 👤 Member for 8 years 6 months

I need to have an excel spreadsheet that lists all activities original duraion as well as lags.

I've tried numerous was of P6 exporting to excel, filtering/formatting within P6 to copy and paste in excel, but am unable to find a way to get both the original durations and lags on one spreadsheet.

Does anyone have any ideas? Thanks!

S
Santosh Bhat 👤 Member for 21 years 1 month
  1. Open the project
  2. Select FILE>EXPORT>XLS
  3. Select both Activities and Activity Relationships
  4. The default Export template should be sufficient for what you need
  5. Select a locaiton to export the XLS file to
  6. Open the XLS file
  7. There is one tab for the activity infomration where you'll find duraton
  8. There is a second tab that lists all Relationships inlcuding lags
  9. Use VLOOUP to match the predecessor ID in the relationships tab to the duration in the activity tab
J
Johannes Vandenberg 👤 Member for 16 years 4 months

Hi Larry

You can use the 'Reports' feature for all the relationships in the schedule. Also the lags.

Go to Tools < reports and then select report AD-02 activity relationships.

Regards Johannes

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts