Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lloyd
 
Posts: n/a
Default Formulas used in Diemaking

Is there anyone who is taking a course in diemaking or a diemaker that has
some excel formulas for determinining the estimated flat-blank lengths when
bending metal?
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Give us the formulas in math form and maybe we can help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lloyd" wrote in message
...
Is there anyone who is taking a course in diemaking or a diemaker that has
some excel formulas for determinining the estimated flat-blank lengths
when
bending metal?



  #3   Report Post  
Lloyd
 
Posts: n/a
Default

Bernard:

Thanks for the reply and offer. The formulas are lengthy and detailed.
Will this forum accept lengthy replies, or are there another email address
which I can send the formulas?

I will try it anyway. This is quoted from the book.

Estimating Flat-Blank Lenghts.

When a given piece part is produced by bending, the length of its required
workpiece "in the flat" is the same as the length of its neutral plane.
Estimating the required flat workpiece length is a matter of determining the
theoretical length of the neutral plane. To determine the theoretical length
it is necessary to calculate the bend allowance "A" for each bend. The
estimated blank length will then be the sum of the lengths "L" of the bend
legs and the allowances. Then, where "B" is the length of the flat blank; B=
L1 + A + L2, etc.

To find "A"

A = (R+C)0.01745N

Distance "C" from the inner surface to the neutral plane is a variable
factor depending largely upon the ratio of the stock thickness "T" to the
bend radius "R". Optimum value for "C" can be considered to be:

Where R < 2T then C=0.33T
R=2T to 4T then C=0.4T
RT then C=0.5T

Thus, for any bend angle

Where

R<2T A=(R+0.33T)0.01745N
R=2T to 4T A=(R+0.4T)0.01745N
R4T A=(R+0.5T)0.01745N

Example 1.

T = 0.030
L1 = 1
L2 = 2
L3 = 1.25
R1 = 0.18
N1 = 90
R2 = 0.09
N2 = 45

Then:

A1 = (0.18 + 0.015) 90(0.01745)
= (0.195) 1.5705
= 0.306

A2 = (0.09 + 0.012) 45(0.01745)
= (0.102) 0.785
= 0.080

Since B = L1+A1+L2+A2+L3
= 1 + 0.306 + 2 + 0.080 + 1.25
= 4.636

There can be a variable amount of bends to any flat blank.

I cannot define a formula to find "C"

Any help would be appreciated.

Lloyd



"Bernard Liengme" wrote:

Give us the formulas in math form and maybe we can help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lloyd" wrote in message
...
Is there anyone who is taking a course in diemaking or a diemaker that has
some excel formulas for determinining the estimated flat-blank lengths
when
bending metal?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with named formula's nathan Excel Worksheet Functions 0 January 21st 05 04:07 PM
Formulas Stan Excel Worksheet Functions 3 January 21st 05 02:58 PM
How to make Excel run limited number of formulas on a given worksh John Excel Discussion (Misc queries) 0 January 12th 05 04:29 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 05:22 PM


All times are GMT +1. The time now is 04:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"