+ Reply to Thread
Results 1 to 3 of 3

Sheet metal bend deduction formula

Hybrid View

  1. #1
    Registered User
    Join Date
    02-28-2023
    Location
    Lancashire, England
    MS-Off Ver
    365
    Posts
    3

    Sheet metal bend deduction formula

    Hello could someone please help with a formula? I'm trying to work out the bend deduction for sheet metal parts. I have the formula but I just don't know how to input it into excel. I've attached the formula here

    Screenshot 2023-02-28 094355.png

    BA ? Bend allowance
    θ ? Bend angle in radians or degrees
    r ? Inside radius;
    T ? Material thickness.

    Here is my current try =2*(M3+M5)*TAN(M2/2)-L13

    M3=Radius
    M5-Thickness
    M2= Angle
    L13= Bend Allowance

    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,180

    Re: Sheet metal bend deduction formula

    Try

    =2*(M3+M5)*TAN((M2*PI()/180)/2)-L13

    M2 is angle in DEGREES
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    02-28-2023
    Location
    Lancashire, England
    MS-Off Ver
    365
    Posts
    3

    Re: Sheet metal bend deduction formula

    Thats done the trick, I must not have had the angle in degree's. Thanks for that

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. making a bend allowance calculator
    By Tony Molloy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2023, 06:07 AM
  2. Metal sheet needed calculator
    By razmas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2016, 04:03 PM
  3. Formula for deduction of minutes late time in and out
    By ismj11 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-28-2015, 10:42 PM
  4. [SOLVED] Sheet Metal Gauge Calculator
    By English Rob in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-23-2015, 02:09 PM
  5. [SOLVED] Finding if multiple bends then subtracting bend deductions.
    By Jettero2112 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2014, 04:16 PM
  6. Payroll Deduction Sheet
    By justinnelson in forum Excel General
    Replies: 1
    Last Post: 11-23-2010, 03:46 AM
  7. How do I download a personal blank wage deduction sheet
    By bruno in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-12-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1