AnsweredAssumed Answered

Inserting Formulas/Equations in Custom Property Tab Builder - Custom Tab

Question asked by John Stoltzfus on Aug 14, 2018
Latest reply on Jan 15, 2019 by Matt Peneguy

Here we use an Excel Spreadsheet to calculate our Cutlist and the information is inserted manually.  What I suggested we try to do is create a Part Template file and use the Custom Properties that are already in SolidWorks rather then having someone retype Descriptions, Part and Assembly information.  Plus use the Bounding Box information to update our Cutlist accordingly, so that when we choose certain custom properties that the length and thicknesses are calculated automatically.  All of our Panels are processed in our Rogh Mill, where they cut the boards to length and rip the boards to width, run them through a Glueing Machine and then they put them in a Clamp Carrier to dry.  To process the order they need the finish size of the panel and they add 1/2" to the width and 3/4" to the length, so the Cut List spreadsheet was supposed to take the inserted size and calculate the final cut size to our Mill Department, plus panels need to be a little thicker for final sanding.

 

We do have (9) Part ID designations and depending on the choice it could change the final thickness, width and length, plus we take the Bounding Box thickness and add 1/4" and then divide then total by 1/4" and round up one, this tells the Mill Dept which Quarter Size of Lumber they need to start with.

 

So my question is...

 

Can I setup a Part Template file with all those formulas in the Custom Tab in the Custom Properties - see the attached Sample Part, (check the Custom Properties) and the Excel Spreadsheet that the one gut was putting together here.  The spreadsheet needs additional work to fully function, but the formulas are there....

 

Attached is a sample part, the excel spreadsheet and the Custom Property Tab Builder file that I use.

 

Thank you in advance for taking a look..

Outcomes