Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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

3 replies [Last post]
Larry Cahn
User offline. Last seen 5 years 2 weeks 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 3 days 13 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

a lot depends on the version of P6 if yuo have 16.1 or above use Toms approach

Santosh's approach will work with any version of p6

Santosh Bhat
User offline. Last seen 51 weeks 1 day ago. Offline
Joined: 15 Apr 2005
Posts: 381

Tom pretty much explains the two options available. To elaborate a little further on the second option to export to XLS.

 

Have the project in question open in P6. Select FILE>EXPORT and select the XLS option. Then in the next screen tick both the Activities and Activity Relationship options. You will then be asked to select a destination for the exported file and an export template option. Even the default export template will provide the infromation you require.

 

The resulting XLS export will containt the tabs that Tom refers to.

Tom Boyle
User offline. Last seen 4 days 8 hours ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

Larry,

If you have P6 release 16.1 or later, then the Detailed Predecessors and Detailed Successors fields will include the lags (and relationship types).  Just include those fields in your activities export and you're good.

If you are working from an earlier P6 release, then any export will have activities and relationships in separate tabs in Excel.  Then you will need to make some formulas (or macro) in the activities/tasks tab to look-up and concatenate all the relationships for each activity - from the other table.

Good luck, tom