I use solidworks for sheetmetal work and would like a way to extract the thickness and perimeter of parts that are drawn for use in quotes/shop drawings. We had been simply measuring and entering by hand but that takes a while. So in the design tables I have been inserting properties by saying something like:

$PRP@Volume

"SW-Volume@@A-9-002-007@A-9-002-007.SLDPRT"

and combining this with the thickness and surface area I should be able to come to flat area and perimeter as well. However since the data is entered into excel in a strange (text) form, it only returns errors when I try to manipulate it like ="I3/J3", and I can't seem to find a suggestion on this anywhere. Also I am using sw2007.

Thank you ahead of time for your help!

Welcome to the forum.

Attached is a SW2009 Part File (zipped) that may help you.

I have used the same formula you mention above for volume.

=""""&"SW-Volume@@"&A3&"@Plate.SLDPRT"&""""

In the Drive Table I have also included a 2nd Volume (Calculated) (a*b*c) as a check. There is a note on the part that will update as configurations are changed.

I am not sure if this will answer all your questions, but may help to get you pointed in the correct direction.

Regards,