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

4 replies [Last post]
Tue, 2019-03-12 20:53
Larry Cahn
User offline. Last seen 5 years 5 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!

Top

Replies

Mon, 2019-03-25 12:16
#1
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

Santosh has the solution

Top
Sat, 2019-03-23 11:02
#2
Santosh Bhat
User offline. Last seen 1 year 2 weeks ago. Offline
Joined: 15 Apr 2005
Posts: 381
Groups: Civil Engineering
  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
Top
Fri, 2019-03-22 18:46
#3
Johannes Vandenberg
User offline. Last seen 8 weeks 6 days ago. Offline
Joined: 21 Jan 2010
Posts: 234
Groups: Building Information Modelling, Petro-Chem / Oil & Gas

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

Top
Fri, 2019-03-22 15:20
#4
PT Thomas
User offline. Last seen 5 years 2 weeks 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

Top