Assign resources

You can assign resources to operations in a process structure or to work areas in a plant structure.

Procedure

1. If necessary, import the resources into the database.

Header1

Item

Item

ItemID

Header2

Item

Item

 

Header3

Item

Item

 

Title

Root

Sub

ID

 

Milling Tool Assembly

 

res_tool_mill_001

   

Holder

 

   

Cutter

 

   

Insert

 

 

Twist Drilling Tool

 

res_tool_drill_001

   

Holder HSK63

 

   

Twist Drill

 

 

Spot Drilling Tool

 

res_tool_drill_002

   

Machine Adapter

 

   

Spot Drill

 

 

EcoMill 350 Siemens 802C

 

res_machine_001

2. Create a Microsoft Excel spreadsheet that includes a column with the following keywords:

Add the Relation keyword to the Header1 row.

Add the Resource keyword to the Header2 row.

In the Header3 row, type the occurrence type of the resource, for example, Tool or Resource.

3. Assign these resources operations in the process structure as follows.

Header1

Item

Item

Description

Relation

Header2

Process

OP

 

Resource

Header3

Process

OP

 

Tool

Title

Process

Operation

Description

Resource

 

Proc_Root

     

   

OP10

Rough Milling

res_tool_mill_001

   

OP20

Heat Treatment

 

   

OP30

Finishing

MachineTool~ res_machine_001

   

OP40

Washing

 

   

OP50

Drilling

res_tool_drill_001; res_tool_drill_002

   

OP50

Inspection

 

Importing this sheet results in the following structure. There are several points to note about this structure:

The Relation column must contain the item IDs (not the names) of the resources or work areas.

Resources that are classified in the database are indicated as such in the structure by the classified symbol . The import utility can assign both classified and nonclassified resources.

The resources must already exist in the database.

You can assign multiple resources to a single BOM line by separating them with a semicolon.

You can specify an occurrence type in Header3 of the Relation column that is then used for all the relations. If, however, you enter an occurrence type in the cells of the relation column (designated by occurrence type~item ID), this occurrence type is used instead of the one in Header3. In the preceding example, for res_machine_001, the MachineTool occurrence type is used instead of the default Tool.