Forum Sponsor:

Oracle Construction and Engineering (formerly Primavera) is transforming the world by helping organizations plan, build, and operate critical assets with on-premise and cloud-based project portfolio management solutions.  Learn more about Oracle Construction and Engineering...

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Lag and Original Duration

4 replies [Last post]
Larry Cahn
User offline. Last seen 9 weeks 6 days ago. Offline
Joined: 28 Nov 2017
Posts: 7
Groups: None

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!

Replies

Zoltan Palffy
User offline. Last seen 9 hours 16 min ago. Offline
Joined: 13 Jul 2009
Posts: 2258
Groups: None

Santosh has the solution

Santosh Bhat
User is online Online
Joined: 15 Apr 2005
Posts: 191
  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
Johannes Vandenberg
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 21 Jan 2010
Posts: 214

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

PT Thomas
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 18 May 2018
Posts: 9
Groups: None

Export to MS project and add column for successor or predecessor you fill get lag and original duration in one sheet