Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel General » [SOLVED] calculating the radius of a curve
Seo Services company Manchester

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
Page 1 of 3 1 2 3
  #1  
Old 02-19-2009, 08:13 AM
stephen1000 stephen1000 is offline
Valued Forum Contributor
  
Join Date: 28 Nov 2008
Location: Norfolk UK
MS Office Version:2007
Posts: 221
stephen1000 Has established their mark in the community
calculating the radius of a curve

Please Register to Remove these Ads

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
File Type: xls bay windows1.xls (65.5 KB, 32 views)
Last edited by stephen1000; 02-25-2009 at 09:07 AM.
Reply With Quote
  #2  
Old 02-19-2009, 10:05 AM
shg's Avatar
shg shg is offline
Forum Guru
  
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 22,049
shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute
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.
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote
  #3  
Old 02-19-2009, 10:19 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
  
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 8,218
Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay Andy Pope makes giving solutions look like childsplay
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
Reply With Quote
  #4  
Old 02-19-2009, 11:22 AM
stephen1000 stephen1000 is offline
Valued Forum Contributor
  
Join Date: 28 Nov 2008
Location: Norfolk UK
MS Office Version:2007
Posts: 221
stephen1000 Has established their mark in the community
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
Reply With Quote
  #5  
Old 02-19-2009, 11:24 AM
stephen1000 stephen1000 is offline
Valued Forum Contributor
  
Join Date: 28 Nov 2008
Location: Norfolk UK
MS Office Version:2007
Posts: 221
stephen1000 Has established their mark in the community
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
Reply With Quote
  #6  
Old 02-19-2009, 02:08 PM
MickG's Avatar
MickG MickG is offline
Valued Forum Contributor
  
Join Date: 23 Nov 2007
Location: Banbury,Oxfordshire
Posts: 762
MickG is attaining expert status MickG is attaining expert status
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
File Type: xls bay windows1.xls (93.0 KB, 27 views)
Reply With Quote
  #7  
Old 02-19-2009, 02:42 PM
stephen1000 stephen1000 is offline
Valued Forum Contributor
  
Join Date: 28 Nov 2008
Location: Norfolk UK
MS Office Version:2007
Posts: 221
stephen1000 Has established their mark in the community
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
Reply With Quote
  #8  
Old 02-20-2009, 10:12 AM
MickG's Avatar
MickG MickG is offline
Valued Forum Contributor
  
Join Date: 23 Nov 2007
Location: Banbury,Oxfordshire
Posts: 762
MickG is attaining expert status MickG is attaining expert status
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
File Type: xls BayWindows (Win1).xls (36.0 KB, 11 views)
Last edited by MickG; 02-20-2009 at 12:09 PM.
Reply With Quote
  #9  
Old 02-20-2009, 02:54 PM
stephen1000 stephen1000 is offline
Valued Forum Contributor
  
Join Date: 28 Nov 2008
Location: Norfolk UK
MS Office Version:2007
Posts: 221
stephen1000 Has established their mark in the community
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
File Type: xls Copy of BayWindows (Win1)A.xls (73.0 KB, 8 views)
Reply With Quote
  #10  
Old 02-21-2009, 06:39 AM
MickG's Avatar
MickG MickG is offline
Valued Forum Contributor
  
Join Date: 23 Nov 2007
Location: Banbury,Oxfordshire
Posts: 762
MickG is attaining expert status MickG is attaining expert status
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
Reply With Quote
  #11  
Old 02-21-2009, 07:03 AM
stephen1000 stephen1000 is offline
Valued Forum Contributor
  
Join Date: 28 Nov 2008
Location: Norfolk UK
MS Office Version:2007
Posts: 221
stephen1000 Has established their mark in the community
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
File Type: pdf 3 facet 2 angles.pdf (41.5 KB, 10 views)
Reply With Quote
  #12  
Old 02-21-2009, 07:07 AM
stephen1000 stephen1000 is offline
Valued Forum Contributor
  
Join Date: 28 Nov 2008
Location: Norfolk UK
MS Office Version:2007
Posts: 221
stephen1000 Has established their mark in the community
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.
Reply With Quote
  #13  
Old 02-21-2009, 01:52 PM
MickG's Avatar
MickG MickG is offline
Valued Forum Contributor
  
Join Date: 23 Nov 2007
Location: Banbury,Oxfordshire
Posts: 762
MickG is attaining expert status MickG is attaining expert status
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
File Type: xls BayWindows (Win1).xls (79.0 KB, 13 views)
Reply With Quote
  #14  
Old 02-21-2009, 07:31 PM
shg's Avatar
shg shg is offline
Forum Guru
  
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 22,049
shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute shg has a reputation beyond repute
Re: calculating the radius of a curve
Here's another approach with a little different interface.
Attached Files
File Type: xls 672617 - Track Length.xls (77.0 KB, 23 views)
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote
  #15  
Old 02-22-2009, 05:51 AM
stephen1000 stephen1000 is offline
Valued Forum Contributor
  
Join Date: 28 Nov 2008
Location: Norfolk UK
MS Office Version:2007
Posts: 221
stephen1000 Has established their mark in the community
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
Reply With Quote


Reply
Page 1 of 3 1 2 3

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Contact Us - ExcelTip.com - Archive - Top