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.

Linking PP dates in an excel doc

3 replies [Last post]
Christine P
User offline. Last seen 9 years 23 weeks ago. Offline
Joined: 27 Apr 2009
Posts: 42
Groups: None

Hi all

Im creating a Master Iinformation Release Schedule in excel.  The dates are subject to change so rather than having to change them every time in the excel document, is there any way of linking the dates in the excel document to the dates in the Powerproject file, so that each time the PP dates are changed the MIRS is updated automatically please?

Replies

Andrew Willard
User offline. Last seen 11 years 36 weeks ago. Offline
Joined: 9 Dec 2009
Posts: 35

Hi Christine,

 

I would normally do this by using tabular reports. A report is created in the same format as the report you want. One click is then all that is need to update the report each time. If you want more information or help on this please let me know.

 

Regards

 

Andrew

Christine P
User offline. Last seen 9 years 23 weeks ago. Offline
Joined: 27 Apr 2009
Posts: 42
Groups: None

Hi Mike

ah well - copy & paste it is

thanks for the reply :)

Mike Testro
User offline. Last seen 1 week 4 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418

Hi Christine

I do not know of any link available between cells in the Powerproject spreadsheet and Excell.

You can however copy / paste from any Power Project column into Excell columns.

The problem is that the time values come with it so you have convert it to date numbers.

If you want your date in say Column C then paste the dates into column E

In Column D type =left(d#,10) and that will lift out the pure date data

In column C type =value(d#) and then format it to the date type you want.

Whenever you copy paste date columns back into excell Col E the dates will format correctly.

Make absolutely sure that your powerproject data lines up exactly with you spreadseet columns or your dates will be all over the place.

Best regards

Mike Testro