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.

Importing Excel Dates to P5

4 replies [Last post]
Thu, 2008-01-10 02:25
Kylie Ferguson
User offline. Last seen 12 years 16 weeks ago. Offline
Joined: 20 Dec 2007
Posts: 6
Groups: Petro-Chem / Oil & Gas
I am having problems when importing dates from an excel spreadsheet into P5. The dates are coming across on the data date, even though the activity dates are in the future. Does anyone know how to hold the dates so they come across as per those in excel ?
Top

Replies

Mon, 2008-01-14 18:12
#1
Kylie Ferguson
User offline. Last seen 12 years 16 weeks ago. Offline
Joined: 20 Dec 2007
Posts: 6
Groups: Petro-Chem / Oil & Gas
That’s correct.
Top
Thu, 2008-01-10 21:56
#2
Sandy Matheson
User offline. Last seen 11 years 1 week ago. Offline
Joined: 22 Sep 2004
Posts: 57
Groups: Petro-Chem / Oil & Gas
So you are not using logic relationships to determine start dates?
Top
Thu, 2008-01-10 21:02
#3
Kylie Ferguson
User offline. Last seen 12 years 16 weeks ago. Offline
Joined: 20 Dec 2007
Posts: 6
Groups: Petro-Chem / Oil & Gas
Thanks Mark for your advice. I have in fact fixed the problem, this is how. Export the project with a primary constraint & primary constraint date field. Enter the dates in the excel spreadsheet into the primary constraint date column and enter a Start On constraint in the constraint column. When you import, the dates come across in the constraint field, hit schedule and the start dates are then reflected as per the constraint dates.
Top
Thu, 2008-01-10 05:52
#4
Mark Chapman
User offline. Last seen 8 years 27 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
I don’t use this facility but I suspect the key thing here is to ensure you have the correct durations and logic then let the software calculate the dates remembering you need to configure a calendar too and this where discrepancies can occur.
Top