×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

BOM template equation

BOM template equation

BOM template equation

(OP)
Hallo all,

Nice to join your nice community.

I have a CUSTOM PORPERTY named ACTUAL MASS where I write actual mass of the part. The assembly has also such CUSTOM PROPERTY, but to get its value I must sum ACTUAL MASSES of all parts in the assembly. To automate this I want to make table bases BOM something like in the attachment (please check it). I want to make an equation which would calculate total mass of the assembly from the BOM table. This is not all; I want to save this equation in BOM template that i would not have to rewrite the equation each time. So far I could manage to save equation in template if it was created while all column of table was selected, otherwise (if only cell is selected) equation is not saved at all). Even saved equation while column is selected does not give any sense, because only "IF" logic command is allowed, and I do not see any use of it in my case.

Any ideas on this matter?

Many thanks in advance
     

RE: BOM template equation

Out of curiosity, why are you using a custom property for the actual mass rather than just assigning the actual mass to the parts using the mass properties options?

Eric

RE: BOM template equation

(OP)
Dear CorBlimeyLimey,

thanks for the link, but would you think i would waste your valuable time if I would not have checked what help does say about it? You see I ca not save the equation in the template. I easily mamaged to form eqation in the cell that would calculate what i need. But it is active only in that table not in the template.

RE: BOM template equation

(OP)
Dear EEnd,

thanks for idea in mass properties, didn't know that I can do such a thing. This is a useful hint in the future. But in my case I prefer to have theoretical solidworks mass intact. You see I am a designer in the sanitary faucet (bath, kitchen)field. Our company deals with casted or machined brass parts, where the main criteria for calculation cost is mass. Before prototype I need to give at least theoretical (solidworks mass) mass for supply dep. that they could find best price subcontractor. When prototype is manufactured and approved we start mass production and in agreement we write actual product mass. When comes to mass production each gram counts. So I need different masses in different product development stages.

I would like to hear your opinion about that. Maybe you will give new useful ideas  :].   
 

RE: BOM template equation

Whoa, Gytis!  CBL is offering suggestions to help, not to criticize!

I'm scratching my head wondering why you are having trouble.  If you want the accurate total mass of the assembly you do not have to do anything special except make sure you set the material for each part.  You can then select the mass properties in the assembly file to see the value.  In our drawings we setup our titleblocks to reference this mass property so the total weight of the assembly is displayed.  The property is "SW-Mass@Assembly Filename.SLDASM".

Maybe I'm missing something from your original post, but you don't have to go to all that trouble to get the mass of an assembly.

- - -Updraft

RE: BOM template equation

Do you consider the "as cast" mass or the "as designed" mass? Your foundry mass will not equal your designed part mass due to sprues, flash, tooling points, and post machining.
To get foundry mass you will need to do a configuration of each part. Then do assembly configs of as designed and as cast then you have it as an assembly property.

--
Hardie "Crashj" Johnson
SW 2010 SP 4.0
HP Pavillion Elite HPE
W7 Pro, Nvidia Quaddro FX580

 

RE: BOM template equation

(OP)
Thank you all for your time and kind will to help. All your post were very useful.

Good luck to you all :]!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources