Indented BOM
Indented BOM
(OP)
Howdy all,
Does anyone have a macro or program that will indent a bom for use in an excel spreadsheet.
Let me clarify: One that is better than the "less than usable" indented bom that comes in solidworks. The solidworks indented bom shows sub-assemblies of sub-assemblies with out any way of knowing the assembly order. For example, I would like to see:
1.0
1.01
1.02
1.02.01
1.02.02
2.0
3.0
...
Instead, solidworks only shows the top level number and clusters all parts and sub assemblies under the top level item number.
Thanks,
Jay
Does anyone have a macro or program that will indent a bom for use in an excel spreadsheet.
Let me clarify: One that is better than the "less than usable" indented bom that comes in solidworks. The solidworks indented bom shows sub-assemblies of sub-assemblies with out any way of knowing the assembly order. For example, I would like to see:
1.0
1.01
1.02
1.02.01
1.02.02
2.0
3.0
...
Instead, solidworks only shows the top level number and clusters all parts and sub assemblies under the top level item number.
Thanks,
Jay






RE: Indented BOM
Chris
Sr. Mechanical Designer, CAD
SolidWorks 05 SP3.1 / PDMWorks 05
ctopher's home site (updated 06-21-05)
FAQ559-1100
FAQ559-716
RE: Indented BOM
I would prefer it function this way:
Assy1
>Sub1
>>> SubSub1
>>> SubSub2
>>>>> SubSubSub1
>>>>>>> PartA
>>>>>>> PartB
>>> SubSub3
>Sub2
I have found no way of doing this though so if anybody knows I would appreciate it.
RE: Indented BOM
Your are correct, thanks for the reply. If I find something, I will pass it on.
-Jay
RE: Indented BOM
Helpful SW websites every user should be aware of FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: Indented BOM
-Jay
RE: Indented BOM
RE: Indented BOM
I agree, I have been in the engineering profession since 1998 and every department/company that I have worked for uses the Indedted BOM style that you and I are using. It just seems to make sense that the BOM should identify the assemblies, sub-assemblies and parts as they are built. After all isn't that one of SW selling points. The software allows the engineers, designers and drafting crews to generate projects as they really are generated. I am guessing that other companies buy all the components listed on the top level bom and then give the shop hands a set of drawings and a box of nuts, bolts, parts, hoses, etc and tells them to put the thing together.
I guess we all have our different opinions of how projects and BOS's should be handled.
Catch ya.
-Jay
RE: Indented BOM
Just my $0.02.
RE: Indented BOM
Thanks for the extra info. We have just purchased a new server and I.T. is settng the machine up. Early next month I will be installing and implementing PDM works for my department. I will be the administrator and am currently trying to get as much info as possible. Will PDMworks generate an indented BOM in the fassion that I am needing? I understand that the data will reflect the latest checked-in assembly.
Thanks,
Jay
RE: Indented BOM
RE: Indented BOM
The BOM's that I have output from PDMWorks are indented, plus they have level numbers. You can only output to TXT or CSV files, though, so the indenting may not help very much.
RE: Indented BOM
Here's where that theory fails for me. I have some purchased parts that consist of several components. The part has a part # in our system, but each individual piece of it does not.
For all normal purposes, I would make this as one solid part and it would work fine, but there are times that it needs to stay as it's own subassembly and therefore causes havoc in my boms.
A trailer landing gear is a perfect example of this. The gear assembly is one part #, but it obviously consists of a handle, crankshaft, foot, fittings, etc. I can't make a dumb part out of the things because I need them to still function somewhat.
A parts only BOM will list every spring in this landing gear, which I don't need. And really a top level only or indented bom(no matter how it's indented) really don't work right for me without a lot of *exclude from bom and *don't show child components and silly modifications I wish I didn't have to make.
RE: Indented BOM
RE: Indented BOM
Flores
RE: Indented BOM
RE: Indented BOM
Check the screenshot below I took from a Solidworks BOM. There is an option after you check "indented assemblies" labeled "show numbering". I don't think this button was there before, but it does the trick the way I want it. You can also selectively expand / collapse individual subassemblies from the BOM Contents tab.
That's worth upgrading alone for me.
htt
RE: Indented BOM
Helpful SW websites every user should be aware of FAQ559-520
How to get answers to your SW questions FAQ559-1091