+ Reply to Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 34
  1. #1
    Valued Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    calculating the radius of a curve

    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

    Attached Files Attached Files
    Last edited by stephen1000; 02-25-2009 at 10:07 AM.

  2. #2
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,126

    Re: need help calculating the radius of a curve

    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

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,932

    Re: need help calculating the radius of a curve

    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.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Valued Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Smile Re: need help calculating the radius of a curve

    Quote Originally Posted by Andy Pope View Post
    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 Andy,

    thanks for that, a bit over my head; I am trying to make life easier for staff around me to work out track sizes thus speed up production.

    Any chance of helping me out on this one

  5. #5
    Valued Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Re: need help calculating the radius of a curve

    Quote Originally Posted by shg View Post
    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.
    Hi Shg,

    I am building a quoting system, I appreciate that their are cad programs and such, but I am building this to be converted into a web based system.

    Any help would be much appreciated

    stephen

  6. #6
    Valued Forum Contributor MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    873

    Re: calculating the radius of a curve

    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
    Attached Files Attached Files

  7. #7
    Valued Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Re: calculating the radius of a curve

    Quote Originally Posted by MickG View Post
    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 Mike,

    I am gob Smacked WOW

    Thats amazing

    cheers

  8. #8
    Valued Forum Contributor MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    873

    Re: calculating the radius of a curve

    Hi Steven,
    I should continue this, on this thread.
    Attached is an example.
    Your thoughts.
    Regards Mick
    Attached Files Attached Files
    Last edited by MickG; 02-20-2009 at 01:09 PM.

  9. #9
    Valued Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Smile Re: calculating the radius of a curve

    Quote Originally Posted by MickG View Post
    Hi Steven,
    I should continue this, on this thread.
    Attached is an example.
    Your thoughts.
    Regards Mick

    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
    Attached Files Attached Files

  10. #10
    Valued Forum Contributor MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    873

    Re: calculating the radius of a curve

    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

  11. #11
    Valued Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Re: calculating the radius of a curve

    Quote Originally Posted by MickG View Post
    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 Mick

    attached is a pdf
    Attached Files Attached Files

  12. #12
    Valued Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Re: calculating the radius of a curve

    Quote Originally Posted by stephen1000 View Post
    Hi Mick

    attached is a pdf
    All facets could be different, never done a 9 facets bay, but could in the future.

  13. #13
    Valued Forum Contributor MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    873

    Re: calculating the radius of a curve

    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
    Attached Files Attached Files

  14. #14
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,126

    Re: calculating the radius of a curve

    Here's another approach with a little different interface.
    Attached Files Attached Files
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

  15. #15
    Valued Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Re: calculating the radius of a curve

    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

Thread Information

Users Browsing this Thread

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

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.2.0