BILL OF MATERIALS¦ TITLE

Try this:

1) Open the BOM template in excel.

2) Insert new columns (How many ?)

Note: Be sure your columns are on the inside left of $END column.

3) Highlight the 4 default columns RMB on the columns and chose "Hide"

4) Click in the cell that you plan to add your own custom columns.

5) If you look at the upper left corner (lower of the toolbars) there is a box that tells you the cell name
Ex: You pick cell "E1" this box says "E1"

6) After you pick the cell you want click and have found the above mentioned box. Then type a name in this box for a new name for this cell.
Note: The name can ***NOT*** have spaces in it. Although this is legal "No_Name".

7) You don't have to add text in these cells, just make sure the names are right.

8) Save the worksheet under a new name and that's it.

You have now added a new name to these cells, and if you have these same names in your part or assembly it will show up in the BOM.

If you or anyone that reads this, need an example let me know,

I hope this helps, Scott Baugh, CSWP
George Koch Sons,LLC
Evansville, IN 47714
sjb@kochllc.com

I found these two rules to not read very well. So I tried updating them.

3) Highlight the 4 default columns or the columns that you need too & RMB on the and chose "Hide"

6) After you pick the cell you want....click on Insert\Name\Define. Then type in a new name and click add or use an existing name for this cell.

Note: The name can ***NOT*** have spaces in it. Although this is legal "No_Name".

Scott Baugh, CSWP
George Koch Sons,LLC
Evansville, IN 47714
sjb@kochllc.com

What I want is to hide just the title like this:
________
Part No
105

________
105

s-)

Oh Ok!

That's alot easier than what I did before. ;-)

Try this instead:

1) Go to where you installed your copy of SW
EX: C:\Program Files\SW01\Lang\English\bomtemp.xls

2) Make a copy of this file "bomtemp.xls" and rename it to something that you will know.

3) Once you have renamed it, open it in Excel

4) Go to where Part No. is and delete it. Do this for all of them if you want.

***NOTE***: Just don't delete "$END"

5) I don't think you will be able to get rid of that space above the 105.
EX:
________
Part No
105

_________
_________
105


I hope that helps, Scott Baugh, CSWP
George Koch Sons,LLC
Evansville, IN 47714
sjb@kochllc.com