Tube bend excel spreadsheet for calculation
	Post Reply		Forum

Posted by: ghamm71 ® 10/30/2008, 14:39:38 Author Profile eMail author Edit

I am looking for a spreadsheat to calculate the flat pattern of tubing. We use 1/8, 1/4 and 3/8 tubing. We model our tubing as built. Manufacutring likes a flat pattern to mark bend lines, does anyone have an excel spreadsheet already made up to do so, with bend allowances, and bend deductions, ect. Thanks- Removed email from message - Administrator Modified by Administrator at Thu, Oct 30, 2008, 14:52:44

Post Reply Tell a Friend (must be logged in) Alert Admin About Post

View All

Previous | Next | Current page

Replies to this message

Re: Tube bend excel spreadsheet for calculation
Re: Tube bend excel spreadsheet for calculation -- ghamm71	Post Reply	Top of thread	Forum

Posted by: ellesse ® 11/11/2008, 11:06:30 Author Profile eMail author Edit

If your tubing is based on those 3 sizes,Im assuming these are your material thicknesses not the actual tubing diameters, then I would suggest using AutoCad and draw the profile/section of the tubes.Using the mean line which is 0.6 of the outer profile this will give you a good result,you can use a calculation sheet for this also but these calcs (as is ACAD) are not 100% accurate and the overall Dia is the key dimension and it all depends on your tolerances.You would be better off completely, to get accurate Bend Allowances and Deductions from actual material tests and these tests can be added to a spreadsheet for future bending.As for the fold lines, again for accuracy, these are only a visual aid and shouldn't be deemed as exact, your machinery should calculate the exact fold line unless you are using manual rollers.Test set ups are the best option if you have tight tolerances of less than 0.5mm anything above you will be ok to use ACAD or a calc sheet.If you havent ACAD just use this calc as a rule of thumb (Diameter x 3.14 x 0.6)3.14 is known as Pi and will never change either will the 0.6.3D packages such as Solidworks and Pro Engineer are another option for design and calculation but are expensive.Hope this helps Modified by ellesse at Tue, Nov 11, 2008, 11:15:12

Post Reply Tell a Friend (must be logged in) Alert Admin About Post

Where am I? Original Top of thread

Previous |   | Current page