Describing multiple BOM lines in one row

You can expand the types of definitions you assign to the imported objects by adding another header row to the Microsoft Excel file. This allows you to create, for example, several objects in one row and overwrite values that already exist with new values.

Header1	Item	Item	Item	Description	Description
Header2	Process	Process	OP
Header3	Process	Process	NCMachining
Header4	Root	Proc	Op	ALL	Op
Title	Root	Proc. Name	Op. Name	Description	Overwrite Description
	Process-Root			New Process
		sub_process1	OP01	New Sub-process1	Read
			OP02		Get and place cable
			OP03		Record lot control
			OP04		Get from printer and place on carrier
		sub_process2	OP05	New Sub-process2	Get sign and place on carrier
			OP06		Set model switch
			OP07		Remove beam from cart
		sub_process3	OP08	New Sub-process3	Lock both sides and latch in place
		sub_process4	OP09	New Sub-process4	Get wire harness and position

The Header4 row allows you to overwrite values for columns that exist twice. In the example, there are two Description columns. But if you look at the row containing sub_process1, you see that there are also two objects in the same row (sub_process1 and OP01). The utility sees that there are two description columns. It assigns the description contained in the ALL column (this is a case-sensitive keyword) to everything except for that which is contained in the Op column (this is a reference to the first column named Op). The utility assigns the description in the first column (the one designated by ALL) to every object that it imports. It then looks at the second column and sees that this is a special description for all objects contained in the Op column. Importing the Excel file results in the following structure.

You can now specify two different descriptions for two different objects in one line of the Microsoft Excel file.