Adding activities

You can add activities to an operation by adding rows in the Microsoft Excel sheet for these activities. In addition, you can add a Time column to enter the duration time for each activity.

Header1	Item	Item	Item	Description	Activity	Activity	Activity	Activity	Activity
Header2	Process	OP	Activity		Description	Time	Unittime	Frequency	Category
Header3	Process	OP	Activity
Title	Proc	Oper	Activity	Desc	Act-Desc	Time	Unit-time	Frequency	Category
	Act-Process
		OP10		Operation10
		OP20		Operation20
			Act1		activity 1	6	6	1	VA
			Act2		activity 2	10	10	2	VA
			Act3		activity 3	3	3	3	NVA
		OP30		Operation30
		OP40		Operation40
			Act4		activity 4	2	2	3	VA
			Act5		activity 5	4	4	2	NVA
		OP50		Operation50
		OP60		Operation60
		OP70		Operation70

You must place activities on separate rows. These activities then appear in Manufacturing Process Planner as follows.

Creating the PERT sequence on import

During import, the tcexcel_import utility can create the PERT sequence on the structures. The sequence is based on the hierarchy as listed in the template.

Example:

Create the following in the import template.

After importing, the following PERT sequence is created.

Importing the frequency of an activity

When importing plant structures, the tcexcel_import utility can also populate the frequency.

Note

The frequencies are numeric values.

Importing the category of an activity

When importing plant structures, the tcexcel_import utility can also populate the category.

Note

The category values are based on an existing (OOTB) LOV.

Importing the unit time of an activity

You can also use the tcexcel_import utility to populate the unit time of the imported plant structure, as shown in the Activities view above.

To do so, create the following in the import template.

• Header1 Activity

• Header2 Unittime

Note

The unit times are numeric values.