Hi guys
I am trying to find a formula to calculate the total size from a to b with the curve being in cluded in the total
![]()
Last edited by stephen1000; 02-25-2009 at 10:07 AM.
This can be done in Excel (because you can do most anything) but it requires a fair amount of computational geometry -- stuff that is already built in to any CAD program. Or Visio.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
This page explains about bend allowances.
http://www.mlevel3.com/BCIT/Bend%20Layout.htm
The formula appears quite straightforward but you will need to create a lookup table for the K-factor values.
Hi Steven , Try your amended File.
Its a bit messy,at the moment, but it can all be cleaned up.There's your worked example with calculations and a Command button to automate the answer from data in "A2 to F2".
See what you think for starters.
Regards Mick
Hi Steven,
I should continue this, on this thread.
Attached is an example.
Your thoughts.
Regards Mick
Last edited by MickG; 02-20-2009 at 01:09 PM.
Hi Mick, its looking very nice
the bay needs to have the option of entering the amount of facets ie 3, 4, 5, 6, 7, 8 ,9
we dont really need a drawing, but if this can be acheived that would be great.
the angles need to be inputted seperatly, as these can differ as you go round.
also the radius changes from track / pole chosen, probably done through table and lookup or index
the radius is taken from the center of the track or pole.
Cheers
stephen![]()
Hi,Steven.
Please confirm, if you have for example 9 Facets, will the Facet lengths for one side of the bay be the same as the other i.e. If the Facets are the same then a 9 Facet Bay would only need 5 Dimensions for the Facet lengths.
Regards Mick
Hi Stephen, Sorry about the misspelling !!
I have added a couple of examples.
Is this what you want.??
Any thoughts.
What's this about a Back bend, Have you got some dimentional details.
Regards Mick
Here's another approach with a little different interface.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Mick, Shg
you guys are amazing,
what I am looking for is a box or drop down that has 1,2,3,4,5,6,7,8,9 once thats chosen you then enter the info in the amount of boxes,
ie 3 facet bay 1,2,3
5 facet bay 1,2,3,4,5
regards
stephen
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks