soildworks export part name, mass and x,y,z CM from assembly to excel file 1

[markopolo85]

Hello,



I'm trying to source a macro that will locate the centre of mass/gravity of all components within an assembly relative to a specific point (i.e. the assembly origin) and export both the part name, mass and x,y,z coordinates to an excel file.


Effectively I'm trying to incorporate the parametric capabilities of solidworks to iteratively optimise the structural configuration of an assembly. However, at this stage I'd just like to avoid clicking on and recording the position and mass of each component within what is a fairly large and complex assembly.



Would really appreciate help with this. Thank you in advance.



Mark,

 

[AnnaWood]

SolidWorks 2013 has some new Center of Mass functionality.

http://www.youtube.com/watch?v=dK1dFHCwJyg

http://blogs.solidworks.com/solidworksblog/2012/08/solidworks-2013-sneak-peek-center-of-mass.html

Cheers,

Anna Wood
SW2012 SP4, Windows 7 x64

http://www.renderbay.com

http://www.solidmuse.com

http://www.phxswug.com

 

[markopolo85]

That would be great but unfortunately I'm only running 2012, any thoughts/macros with this version?

Mark

 

[Gupta65]

Check this macro by Tobin:

https://forum.solidworks.com/message/215433#215433

And check this post on how to use it:

https://forum.solidworks.com/message/330593#330593

Deepak Gupta
CSWE, CSWP, CSDA
SW 2012 SP5.0 & 2013 SP 1.0 EV
Boxer's SolidWorks™ Blog
SolidWorks™ Rendering Contest

 

[markopolo85]

Ha! Indeed, although I'm Mark Thompson, great investigative work tho! Just added a reply to Deepak's last comment outlining how I'm looking to extend this functionality further. I'm going to have a stab at it but unfortunately I'm no programmer...

Any feedback/input would be appreciated.

Thank you in advance.

Mark.