Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Copying Resource

8 replies [Last post]
Tue, 2010-06-29 02:10
CHANDRA SEKAR THA...
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 13 Aug 2007
Posts: 21
Groups: None
I have assigned a resource with BQ for a group of activities. Now i want to split up that resource in to 2 resources
for e.g assigned resource = Manhour
proposed resources = Manhour Skilled (60% of assigned BQ of Manhour)& Manhour UnSkilled (40% of assigned BQ of Manhour). Please advice.
Top

Replies

Sun, 2010-07-04 08:29
#1
CHANDRA SEKAR THA...
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 13 Aug 2007
Posts: 21
Groups: None
Mr.Rodel,
Thanks a lot
Top
Thu, 2010-07-01 09:33
#2
Rodel Marasigan
User offline. Last seen 12 weeks 4 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Chandra,
SDK is can be selected when installing Primavera. If the first installation is not selected then Primavera allows you to modify selection and you can install only those not selected when installation was done. SDK sample is also available in Primavera CD.
Top
Thu, 2010-07-01 09:28
#3
CHANDRA SEKAR THA...
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 13 Aug 2007
Posts: 21
Groups: None
Mr.Rodel,
Thanks for your reply. Where can I get SDK? Please be noted that I am using legal version of P6 version 7. Please advice & if possible send me a link.
Thanks in advance.
Top
Thu, 2010-07-01 09:23
#4
Rodel Marasigan
User offline. Last seen 12 weeks 4 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Chandra,
If you have 10 resources and only A5 needs to split then you need to use export to excel. Using Global change is not possible because it has different row in the table. If you know how to use SDK then it is easier to transfer resource data from different row on resource assignment table.
Top
Thu, 2010-07-01 09:14
#5
CHANDRA SEKAR THA...
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 13 Aug 2007
Posts: 21
Groups: None
Mr.Rodel,
Thanks for your reply.
• Actually I have 10 resources in my schedule, namely A1, A2…....... A10.
• Most of the activities have more than 5 resources. Budgeted Quantities are assigned in all the resources.
• For example: Activity B1000 has 5 resources namely A1, A2, A3, A4 & A5 and their BQ’s are 100, 150, 200, 300 & 500 respectively.
• Now I need to split the resource A5 into two resources. That means I have to introduce two more new resources namely B1 & B2 and the BQ’s to be split as 60% & 40% respectively.
• So as you informed I have defined a UDF namely “Q1” and by global change I have copied the BQ of A5 into Q1.
• How can I transfer the Q1 to the BQ of B1 & B2. I tried and couldn’t, because the Q1 of A5 is same as the BQ of A5 and the BQ of B1 & B2 is same as BQ of B1 & B2 (that is “0”)- Please refer the “print screen”.
• I have some problems in importing & exporting, please advise me to how to do it in P6.

Thanks in advance.
Top
Thu, 2010-07-01 08:11
#6
Rodel Marasigan
User offline. Last seen 12 weeks 4 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Chandra,
To use Global change follow criteria stated below:
Select Subject Criteria:
Activity Resource Assignment
If
Where:
Resource ID Name equal [Pick the original resource]
Then:
Budgeted Labor Unit = Budgeted Labor Unit * 0.6
Else
Budgeted Labor Unit = Budgeted Labor Unit * 0.4

Note: If the new resource budgeted Labor Unit is not correct use export to excel with UDF define and use UDF value to calculate new resource labor unit and import it back.


Top
Thu, 2010-07-01 00:56
#7
CHANDRA SEKAR THA...
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 13 Aug 2007
Posts: 21
Groups: None
Mr. Rodel

Thanks for your solution and as you suggested, we have defined Activity Resource Assignment UDF and transferred Budgeted labor units by global change. Then i have defined a new resource but i dont know how to transfer that UFD to resource(BQ) by globle change. Please advice.

Thanks in advance.
Top
Tue, 2010-06-29 08:23
#8
Rodel Marasigan
User offline. Last seen 12 weeks 4 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Chandra,
Define a new nonlabor resource. Then select all activities with previous assigned labor resource and highlight (You can use filter to make it easier to select) then click resource assignment icon on the right and select the new nonlabor created.
Export to Excel spreadsheet using resource assignment with the minimum following Fields: Activity ID, Activity Status, Resource Id, Roles ID, Cost Account, Budgeted Units, Remaining Units, At completion units. After exporting populate data base on the BOQ proportion mention then import back.

Alternatively you can define Activity Resource Assignment UDF and use global change to transfer Budgeted labor units and global change again using UDF define * factor that you mentioned.
Top