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.

Removing a resource from multiple activities

6 replies [Last post]
Thu, 2005-10-13 12:11
Yves Trudel
User offline. Last seen 17 years 16 weeks ago. Offline
Joined: 30 Jul 2005
Posts: 33
Groups: None
Hello all,
Is there a way to remove quickly a resource from multiple activities where you have more than one resource?
For example I have 10 activities related to construction. Each of them has Carpenter + mason. I want to remove all masons from all the 10 activities, but keep the carpenter, with their specific hours.
Thanks in advance

Yves Trudel
Top

Replies

Mon, 2005-10-17 07:09
#1
Yves Trudel
User offline. Last seen 17 years 16 weeks ago. Offline
Joined: 30 Jul 2005
Posts: 33
Groups: None
To Christian:
Yes I had another filter key to make sure only the masons in one specific area were deleted.
Thanks for the thought!
To Brennan:
That looks all new to me; I will have to do some homework!
Tell me: is there any major difference in your solution if I use Excel?
Thanks again!

Yves
Top
Fri, 2005-10-14 23:36
#2
Brennan Westworth
User offline. Last seen 6 years 51 weeks ago. Offline
Joined: 23 Feb 2003
Posts: 150
Groups: None
another way is to use import / export

// from P3 Help File
Delete data in Lotus 1-2-3 or dBASE

Follow these steps to delete the activity ID, resource name or designator, cost account, or relationship type from a spreadsheet or dBASE file;
delete or modify all other types of data directly.

1 Export the data to be deleted from P3.

2 Create a new column in Lotus 1-2-3 or add a new field in dBASE.

The column or field width must be at least one character. The specific location in the file is unimportant.
3 Name the range Delete using the Range Name command in Lotus 1-2-3, or name the field Delete in dBASE.
The field must be designated as a text range name in Lotus 1-2-3 and as a character field in dBASE.
4 Specify the one-character code in the newly added column or field to delete specific activity data. Leave the cell or field blank for any activities
that are unchanged or that contain new or updated data.

A - deletes all data for that activity ID.
R - deletes resources for that activity ID.
L - deletes log records for that activity ID.
S - deletes the relationship for that activity ID.

5 Add any new data to replace the deleted data items.
To add or delete relationship types, the activity ID, successor, and relationship type must also exist in the file. Change the relationship lag only
if a lag value not equal to zero already exists.

See also

Update data in Lotus 1-2-3 or dBASE for Import

//

in your case you would:
1 export activity ID and resource
2 add a column titled DELETE, if using dbf dont forget to redefine your database area in excel (insert>name>define)
3 place an R in this column next to all the resources you wish to remove
4 import the file back to P3

best to trial this on a copy of your schedule to make sure you have got it right.
Top
Thu, 2005-10-13 23:55
#3
Christian Adrian ...
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 3 Jun 2003
Posts: 193
Groups: None
Hello Yves

This is correct:

IF RES = "MASON"
THEN RES = " "

But for some reason using this specs. in the global change could also affect your entire project with task using same resource (e.g. if you have 20 activities all having carpenter + mason but you only need to remove the MASON in the 10 activities). Might I suggest that you also try to create filter which defines only those particular activity that you need to remove that type of resource..

Just an additional thought..

Cheers!

Christian
Top
Thu, 2005-10-13 13:03
#4
Yves Trudel
User offline. Last seen 17 years 16 weeks ago. Offline
Joined: 30 Jul 2005
Posts: 33
Groups: None
Thank you both!
I used the statement:
IF RES = "MASON"
THEN RES = " "
And it worked fine
Thank you again

Yves
Top
Thu, 2005-10-13 12:34
#5
MK TSE
User offline. Last seen 3 years 47 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Alternative, filter by RES EQ Carpenter & RES EQ Mason
On layout, activities grouped by Resource and add a column "Resource".
Then clear the colunm field with Mason filled.
Top
Thu, 2005-10-13 12:28
#6
Raja Izat Raja Ib...
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 2 Jun 2005
Posts: 299
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Try this
IF | RES EQ "CARPENTER"
IF | RESP EQ "MASON"
THEN |RESP EQ "GAP"
Trial Run see what its look like
Top