Posted on 03/30/2008 1:47:47 PM PDT by jsh3180
I'm looking for someone who may know how to enter a mathematical formula into a MS Excel spreadsheet. I am a general contractor, the formula is for determining the radius of an arc depending on the distance between two points, with the height of the arc remaining constant.
The formula is:
r = (m)(m) + .25 (c) (c)
over (divided by)
2(m)
r is radius, m is the height of the arc, and c is the distance between the two points.
I have no problem doing this all with a calculator, but it is time consuming and I have a couple of dozen different calculations to make, SO, if I could figure out how to enter this into Excel with m and c measurements, and have Excel do the calcs automatically, it would make life a lot easier and save me a lot of time!!
Thanks so much if anyone can help.
=((m*m)+.25*c*c)/2*m
wow, that’s fast service. Di I enter my m and c in two seperate columns and put the formula in a third column?? I use Excel an awful lot for estimating jobs, but that is basically simple multiplication and addition, I’ve never tried one like this before.
Put this formula in cell B5:
=((B1)*(B1))+0.25*((B2)*(B2))/2*(B1)
Yeah, you’d want to reference different cells for “m” and “c”.
radius = =((A1*A1)+(0.25*B1*B1))/2
Where cell A1 contains height of arc (m)
cell B1 contains distance between points (c)
Example spreadsheet file at:
http://download.yousendit.com/5578222A19491B57
Excellent!!!!! a picture is worth a thousand words. Thank you.
I forgot the multplier in the divisor - disregard mine
Ping me if you ever need any help...be glad to try...:)
Can’t help you with the specific formula, but have you checked out the fx (function) part of Excel? There are a lot of formulas (financial, statistical, ect) already created and ready to use. Maybe what you need will be there?
Hope this helped.
If you had a Mac, you wouldn’t have run into this problem. /sarcasm :O)
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.