Removing a resource from multiple activities

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.

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

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.

Try this

IF | RES EQ "CARPENTER"

IF | RESP EQ "MASON"

THEN |RESP EQ "GAP"

Trial Run see what its look like