Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

I have questions about the Parts Lists/BOM's from the assembly and excel

4 REPLIES 4
SOLVED
Reply
Message 1 of 5
to_schroeder
425 Views, 4 Replies

I have questions about the Parts Lists/BOM's from the assembly and excel

to_schroeder
Contributor
Contributor

So. First off: im german, sry for my broken english.

 

1. What *exactly* is excluded in the Parts Only list except the parts i have set to reference? Only the .iam's? I think it might be more. Because i have exported both lists. Parts only and Structured to an excel table. For the structured list i have then in excel deleted all duplicates with the criteria of the filename. So now i should have each file once, even though i have used it in different sub-assemblies. Now i have more positions then i have in the Parts Only list (ofcourse i subtracted the number of .iam's  i have). Why do i have still more positions from the structured list than in the parts only list?

 

2. When i exported the structured list i have then summed all instances of each part using the sumif function. But when i compare it with the parts only list, there are some positions which have the wrong number on instances of the part. Why/how is that possible?

 


i would love to attach the iam here, but i doubt that my boss would be ok with it. you know, data protction and copyright and stuff.

0 Likes

I have questions about the Parts Lists/BOM's from the assembly and excel

So. First off: im german, sry for my broken english.

 

1. What *exactly* is excluded in the Parts Only list except the parts i have set to reference? Only the .iam's? I think it might be more. Because i have exported both lists. Parts only and Structured to an excel table. For the structured list i have then in excel deleted all duplicates with the criteria of the filename. So now i should have each file once, even though i have used it in different sub-assemblies. Now i have more positions then i have in the Parts Only list (ofcourse i subtracted the number of .iam's  i have). Why do i have still more positions from the structured list than in the parts only list?

 

2. When i exported the structured list i have then summed all instances of each part using the sumif function. But when i compare it with the parts only list, there are some positions which have the wrong number on instances of the part. Why/how is that possible?

 


i would love to attach the iam here, but i doubt that my boss would be ok with it. you know, data protction and copyright and stuff.

Labels (4)
4 REPLIES 4
Message 2 of 5
CCarreiras
in reply to: to_schroeder

CCarreiras
Mentor
Mentor

Hi!

 

That will depend on the parts and subassembly status for BOM Structure.
Example: in a part, phantom or reference, will have the same result, but in a subassembly, not.

CCarreiras_0-1690535288360.png

Also, suppress components can be counted, or not.

CCarreiras_1-1690535359375.png

 

CCarreiras

EESignature

Hi!

 

That will depend on the parts and subassembly status for BOM Structure.
Example: in a part, phantom or reference, will have the same result, but in a subassembly, not.

CCarreiras_0-1690535288360.png

Also, suppress components can be counted, or not.

CCarreiras_1-1690535359375.png

 

CCarreiras

EESignature

Message 3 of 5
to_schroeder
in reply to: CCarreiras

to_schroeder
Contributor
Contributor

can you tell me what phantom assemblies are really for?

as i have understood it they are for repeating patterns (very basic example a certain nut combined with a bolt) that i can place so i dont have to make the constraints again and again. but in the final bom they will be shown as though i have placed them individually.

am i correct?

0 Likes

can you tell me what phantom assemblies are really for?

as i have understood it they are for repeating patterns (very basic example a certain nut combined with a bolt) that i can place so i dont have to make the constraints again and again. but in the final bom they will be shown as though i have placed them individually.

am i correct?

Message 4 of 5
to_schroeder
in reply to: CCarreiras

to_schroeder
Contributor
Contributor

also:

 

i have only one phantom assembly. the rest are just normal parts or subassemblies. this doesnt add up

0 Likes

also:

 

i have only one phantom assembly. the rest are just normal parts or subassemblies. this doesnt add up

Message 5 of 5
CCarreiras
in reply to: to_schroeder

CCarreiras
Mentor
Mentor
Accepted solution

Correct!

Phantom: the sub-assembly will not be counted in the part list, but the parts are counted.

Ex: if you use Bolt Connection or Frame Generator (those are special components, but still sub-assemblies), the parts will be in the part list, but not the subassembly. This phantom status is set automatically for these cases, but in a normal sub-assembly, you can force them to have equal status.
It's like: the sub-assembly is reference, but not the parts within the sub-assemble, those have normal status and will be counted.

 

Reference: Neder the sub-assembly and parts will appear in the part list. They are all references.

Patterns are a different case, since you are replicating parts, it will count each repetition.
But if you create a pattern of a Phantom or Reference sub-assembly, the behavior should be similar as the single inicial component (before patterning).

CCarreiras

EESignature

Correct!

Phantom: the sub-assembly will not be counted in the part list, but the parts are counted.

Ex: if you use Bolt Connection or Frame Generator (those are special components, but still sub-assemblies), the parts will be in the part list, but not the subassembly. This phantom status is set automatically for these cases, but in a normal sub-assembly, you can force them to have equal status.
It's like: the sub-assembly is reference, but not the parts within the sub-assemble, those have normal status and will be counted.

 

Reference: Neder the sub-assembly and parts will appear in the part list. They are all references.

Patterns are a different case, since you are replicating parts, it will count each repetition.
But if you create a pattern of a Phantom or Reference sub-assembly, the behavior should be similar as the single inicial component (before patterning).

CCarreiras

EESignature

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report