The other variables should be able to enter straight up. You would probably need a lookup table to get the K values (maybe this is where you would use a dropdown list). If this is the correct formula, this should be fairly straightforward to put into Excel. I know nothing more about this, or even if this is the calculation you are looking for. Where BA is bend allowance, A is bend angle in radians, R is bend radius in meters, T is material thickness in meters, and K is a material specific "fudge factor". I put "sheet metal bend allowance" into my favorite internet search engine and (among other pages) found this page ( ) with a relatively simple equation for bend allowance. If this is more of an engineering question, I'm not sure that we have any ME's on the board who can help with the engineering. If you already know the formula(s) for bend radius, help us understanding the engineering calculation, and we should be able to help you put that calculation into Excel. How much of your question is engineering (how does anyone anywhere using any programming language or pencil and slide rule calculate bend allowance), and how much is Excel specific (how does one enter the formula(s) for bend allowance into Excel)? I think Excel can do most engineering calculations (even if it is not always the best tool for the job).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |