We are currently moving to Solid Works from another 3D system and I need to set up our sheet metal flat pattern calculations based on our shop standards. I've been told to utilize the "bend_calculation.xls" spreadsheet (below) to input our formula for calculation. I've tried a few different ways and it doesn't seem to be using my formula at all. Or it errors out when I try another method of input. In our old system we had a field for the formula in the file template. Then all we had to do was input the material thickness and ID Bend radius into the model and our formula picked up the bend angle(s) and used the formula to calculate our flat pattern.

Our Formula: I have spelled out the variables for clarity

((.0078*Thickness)+(.0174*ID Bend Radius))*Angle

Does anyone know how to set up this spreadsheet to utilize our formula? I'm not understanding the use of the German character for aperture angle and how to utilize it since I really don't see it used in the example formula. Unless it's the standard "b" character.

Thanks,

Ryan

Budde Sheet Metal Works, Inc.

Hi Ryan,

I recently had a similar issue setting up a table. Here is an explainer that should help you get set up:

s = material thickness

r = internal bend radius

b = Internal angle of bend (supplementary angle to the bent thru angle), for your calculation you'll want to subtract this from 180.

v = amount to be added (or subtracted if negative) from the length to the virtual sharp. This translates to bend deduct, which is directly related to the bend allowance which is what your formula calculates.

To find the bend deduct you'll use the formula: B.D. = 2(s+r)(tan((180-b)/2)) – B.A.

B.D. = bend deduct, B.A. = bend allowance (a.k.a. your formula)

assuming you want to use the same calculation for all bend angles, the spreadsheet should read: