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.

Resource Dictionary & Crtitical Path

10 replies [Last post]
Thu, 2002-02-28 08:01
Ulkutan Cimen
User offline. Last seen 10 years 12 weeks ago. Offline
Joined: 30 May 2001
Posts: 21
Groups: Petro-Chem / Oil & Gas
Hello I've had two problems in P3 that I couldn't resolve. Maybe someone knows if there's a way: 1 - Can I import a resource dictionary to a P3 project from a spreadsheet? (I know I can import resource data and it will fill the resource dictionary with the resource names, but the units, costs and limits won't be filled) 2 - How do I filter the activities on the critical path when critical path is defined as the longest path? Thanks in advance for the replies.
Top

Replies

Mon, 2013-02-11 10:56
#1
Hussain Hussain
User offline. Last seen 10 years 38 weeks ago. Offline
Joined: 12 Jan 2013
Posts: 3
Groups: None

Hi All,

I would like to write Quality and Safety Policies for my company. Therfore, Should I or my company be ISO certified to write and implement such policies??? Please advise.

Your response highly appreciated.

Top
Mon, 2013-02-11 07:45
#2
Sivasankari Thiya...
User offline. Last seen 2 years 17 weeks ago. Offline
Joined: 9 Feb 2013
Posts: 5
Groups: Civil Engineering, GPC Malaysia, GPC Qatar, Planning, Claims & Contracting, Women in Planning & Scheduling (WiPS)

I WANT TO KNOW HOW TO LEVEL RESOURSE IN PRIMAVERA P6

Top
Fri, 2002-03-15 11:13
#3
Ali Hamouda
User offline. Last seen 7 years 49 weeks ago. Offline
Joined: 3 Feb 2002
Posts: 109
Groups: None
Hi Mr.Collen I am facing troubles in excel sheets utility working with p3.( I doubt may be the files are old). If you can send for me these files,It will be good help from you. thanks Ali ----------------------------
Top
Fri, 2002-03-01 06:31
#4
Ali Hamouda
User offline. Last seen 7 years 49 weeks ago. Offline
Joined: 3 Feb 2002
Posts: 109
Groups: None
Hi, 1-the solution of the first problem is: if you go to tools and Update data dictionary, you will find all the items that are built in the data base of P3, including cost and unit and any other Item,you have to use the standard names that built in the P3 for the cost and units. to do that you have to export a standard file with the standard names first then fill in the form and then import the file with it is new data to p3. other wise you can make custom data Item by with the fields cost,unit..etc. 2- the second problem, when you go to filter there is an option to add filter over filter,there's three option append , add and replace. Best Luck Ali ---------------------------------------
Top
Fri, 2002-03-01 04:58
#5
Ulkutan Cimen
User offline. Last seen 10 years 12 weeks ago. Offline
Joined: 30 May 2001
Posts: 21
Groups: Petro-Chem / Oil & Gas
Cheers for all the quick replies. Tomas, that Longest Path criteria in the filter specification answers me, thank you, I have just missed it, it seems. Jeff and Colin, thanks for letting me know about those macros. I use P3 v 2.0b, it still has project.xls in it. I am working on it, my first few trials were unsuccessful. I may contact you if necessary. Daryl, I am not a very good at Access yet so I will keep your reply for future reference. And Reynaldo, I've got a bit too many resources in my current project, I was trying to avoid the time I would consume to build the resource dictionary. Thanks for your concern.
Top
Fri, 2002-03-01 04:31
#6
Colin Cropley
User offline. Last seen 5 years 48 weeks ago. Offline
Joined: 1 Feb 2002
Posts: 57
Groups: None
On the P3 3.1 CD, there is a folder called \UTILS\Excel. In that folder, there are two files: PROJECT.XLS & ProjectMod.XLS. These are macro driven and access the underlying P3 database to enable the user to manipulate and add to the various P3 dictionaries in Excel and put them back into the P3 project. If you do not have the 3.1 CD, send me an email and I can email the file to you. Regarding the critical path filter question, if you sort by TF, you will get the most critical activities first, usually all part of the one critical path. If you have mixed calendars and thus the TF changes through the longest path, you will get fragments of the path with different TF values, corresponding to the different calendar activities. You will then have to check the dependencies to see how the path links between the various mixed calendar activities. Grouping by calendar may help work this out. Regards Colin Cropley
Top
Fri, 2002-03-01 07:23
#7
Daryl Walcroft
User offline. Last seen 14 years 1 week ago. Offline
Joined: 4 Feb 2002
Posts: 26
Groups: None
There are some very good Excel macros out there that allow a relatively seamless interface between Excel and Primavera. However, I find the best results are obtained using and ODBC link from Access, This type of link allows all information held in the BTRIEVE database to be dynamically updated through MS Access. E-mail me if you want more details.
Top
Fri, 2002-03-01 02:03
#8
Reynaldo Durana
User offline. Last seen 18 years 23 weeks ago. Offline
Joined: 16 Oct 2001
Posts: 3
Groups: Petro-Chem / Oil & Gas
I think you can not import resource dictionary in P3 from spreadsheet including the Price/Unit & limits.but for me you can just input manually the price/unit & limits for every resource name & it is not time consuming operation because in a project usually we don’t have so many resource name to be loaded in P3 or if you have similar project before you can transfer the resource dictionary to the new project & edit if there’s some inconsistency. Your question #2 about filtering the longest path it was replied already.
Top
Thu, 2002-02-28 10:26
#9
Tomas Rivera
User offline. Last seen 5 years 4 weeks ago. Offline
Joined: 2 May 2001
Posts: 139
Groups: None
Hi Ulku: Regarding your question number 2. In the Filter Specification window, you can choose a schedule parameter called "longest path". I hope this was your question. Tomas Rivera
Top
Thu, 2002-02-28 08:09
#10
Jeff Williamson
User offline. Last seen 22 years 44 weeks ago. Offline
Joined: 26 Jun 2001
Posts: 3
Groups: None
On the P3 CD you will find a excel macro that can populate the resource dictionary. Look for "project.xls". I would suggest doing a few test runs before doing it for real.
Top