Removing a resource from multiple activities

Try this
IF | RES EQ "CARPENTER"
IF | RESP EQ "MASON"
THEN |RESP EQ "GAP"
Trial Run see what its look like

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.

Thank you both!
I used the statement:
IF RES = "MASON"
THEN RES = " "
And it worked fine
Thank you again

Yves

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

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.

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