How do you get inverse Tangent, Inverse Cosine, & Inverse Sine in Excel 2003?
Say for instance I want a cell to autmatically calculate the angle for a common rafter with a pitch of 5/12. Since 12 is the standard run, a cell only need the rise of 5 entered but what’s the formula to enter in the cell to get me 22.61986495° ?
I know how to do this on a calculator, I just want to see it done in Excel.
7g
Join some of the most experienced and recognized building professionals for two days of presentations, panel discussions, networking, and more.
"I have learned so much thanks to the searchable articles on the FHB website. I can confidently say that I expect to be a life-long subscriber." - M.K.
Dig into cutting-edge approaches and decades of proven solutions with total access to our experts and tradespeople.
Start Free Trial NowGet instant access to the latest developments in green building, research, and reports from the field.
Start Free Trial Now
Replies
inverse sine = arcsine = asin in excel; acos and atan, i think
but i think the result is in radians, so you have to convert to degrees from that.
i think
thanks Harry,
I've never thought of inv. Tan as arctan but you gave the clue to lead me to http://en.wikipedia.org/wiki/Arc_tangent which gave me a better (although not completely clear) understanding. Maybe I was taught about arc tan, arcsin, arccos way back in the way-backs but inv. tan, etc. overwrote it all. Now I kinda see the logic to ATAN, ACOS, ASIN.
=degrees(atan(5/12))
cell contents=DEGREES(ATAN(---your rise dived by run---))
thanks guys, I'll give that a try
i need more detail, i been trying to figure this for the last year. need examples
This is the function.
Here it is.
weird, for some reason I couldn't get it to work but then closed and reopened the sheet and it works great.
find the wiki link I posted, might help make it click for you
ASIN = inverse SineACOS = inverse CosineATAN = inverse Tan
=(ASIN(opp/hyp))=(ACOS(adj/hyp))=(ATAN(opp/adj))
Arcsine, arccosine and arctangent are the correct descriptions of the "inverse" trig functions. Angles are correctly measured in radians, the ratio of the arc length/radius.
View Image
We are actually calculating the arc length if given the sine, or the arc length if given the cosine, or the arc length if given the tangent, as the case may be. The arc in question is for a circle of unit radius. However, if the radius does not equal one the radian measure of the angle is unaffected since the radius and arc length increase proportionally with respect to one another.
Joe Bartok
Edited 2/14/2009 10:42 am ET by JoeBartok
Edited 2/14/2009 10:42 am ET by JoeBartok
Doing transfer functions for shielded cables among other tasks requires hyperbolic trig functions of complex numbers.
Do you know a way in excell to do that except for multiple columns, then taking the square root of sums of squares and doing the hperpolic functions on those products.?
Matlab and Mathcad exell aint....
Junkhound, this is something I haven't considered. I have an online Complex Number Calculator but it won't crunch trig functions.
For imaginary numbers, i ...
cosh (ix) = cos x
sinh (ix) = i sin x
Wikipedia article ... Hyperbolic function
For a complex number, z ...
cosh(z) = cos(iz)
sinh(z) = – i cos(iz)
Complex Hyperbolic Functions
The only way other than using the trigonometric relations (that I can see) is to have a series of cells calc the real and imaginary terms based on the exponential function ... e.
Joe Bartok
Edited 2/14/2009 1:04 pm ET by JoeBartok
Junkhound, as usual on a Saturday I am running out of Internet time (just when someone post a really interesting question ... also as usual). Nor do I have time to scan my math notes to show the derivation of the formula in the image below.
If you elect to use the exponential function based formulas for your worksheet you will find the relationship useful. This is the formulation I used in my web-based calculator to raise a complex base to a complex exponent.
Since your base is e + 0i, r = 1 and theta = zero, dramatically simplifying the formula.
Real Compnent = e ^ a × cos b
Imaginary Component = i(e ^ a × sin b)
You can use my online calculator to check the powers of (e + 0i)^(a + bi) against the values returned by your spreadsheet.
Hope this helps you out ...
Joe Bartok
Edited 2/14/2009 2:18 pm ET by JoeBartok
Edited 2/14/2009 2:36 pm ET by JoeBartok
Edited 2/14/2009 2:50 pm ET by JoeBartok
Another way to express the hyperbolic functions of complex numbers. This looks like the easiest way to go with your Excel formulations ...
cosh (a + bi) = cosh a cos b + i sinh a sin b
sinh (a + bi) = sinh a cos b + i cosh a sin b
Joe Bartok
sinh (a + bi) = sinh a cos b + i cosh a sin b
Even with those, to be able to reduce to amplitude and phase the spreadsheet needs a few more columns to do the vector sums.
Probably wont need to do that stuff if I ever retire, the programs that do do it all are probably beyond what I'd want to spend for a 'hobby'/ <G>
You can get old versions of MathCad on eBay, quite inexpensively.
Here is a quick worksheet using the relations ...
cosh (a + bi) = cosh a cos b + i sinh a sin b
sinh (a + bi) = sinh a cos b + i cosh a sin b
I tested the results against cosh ix and sinh ix formulas based on powers of e produced by my Complex Number Calculator and both methods agree dead on. The formulas in the images below are from Wikipedia ... Hyperbolic Functions
View Image
View ImageJoe Bartok
To convert radians to angles you either multiple by Pi/180 or 180/Pi. I can't recall which one it is...
<To convert radians to angles you either multiple by Pi/180 or 180/Pi. I can't recall which one it is...>
Multiply radians by 180/pi to get degrees.
Used to ask my mom when a little kid after reading it somewhere without understanding, that how come if there were 2 pie raisins in a circle, she only put in one box.
Guess it was 'cause we wuz poor, the box with the recipe on the back said use two boxes!
One bad thing about being cheap, even now can NEVER get DW to put 2 bags of chips in a CC cookie recipe, even though the bags are only 12 or even just 10 oz now, used to be 16 oz.
Live cheap, live long. I don't suppose the bank is beating on your door for mortgage, car, or boat payments. You can credit your mother for not spoiling you. Reward yourself with a chocolate chip cookie.
junkhound
even now can NEVER get DW to put 2 bags of chips in a CC cookie recipe
You could try making the cookies yourself.
Nah maybe that's a crazy idea.
My problem is I like the cookie dough too much. LOL
Rich
You could try making the cookies yourself.
Only problem with that is then I get the " aren't you fat enough without making those 'fat pills' " <G>
DW used to go to teachers conferences when the boys were teens, did the boys an' I ever pig out then, first thing was to make 6 chocolate merangue pies and 3 bag CC cookies, ate'm all before DW got back home, but forgot to do the dishes in time one year, but that's another story.......
As for ---- My problem is I like the cookie dough too much. LOL -- Since about the mid 70's when a friend of DW's had salmonela from eating uncooked eggs, I take even a lick on the beaters and get a salmonela lecture...
Signed: 'Junior cook of tomorrow, IL state fair, 1957' - still got the trophy......and probably a few dimes yet from the few dolars prizes!
junkhound
ROFLOL
I miss judged you.
I thought you were going to tell me you couldn't boil water.
Rich
You guys should have FHB do an article on their next issue on this topic. Have the resident genius Mike Gurten (I know its spelled wrong) do the article
Okay, since you seem to be well versed in excell; do you know how to do a Heaviside Function in it?
No idea. I Googled Heaviside Step Function and can honestly say I haven't a ****** clue what the article is about.
If it's the integral that is causing headaches (there's no quick-and-dirty Excel function for this that I am aware of) I do have a couple of suggestions. Simpson's Rule. Or expand the function into a convergent series and integrate term by term.
Joe Bartok
Basically the Heaviside function has a value of zero, below the threshold, and a real value above the threshold.
I.E. y=0 for x<3, and y=4 for x>=3, would be written as H(3,4).
It is useful for generating shear and moment diagrams for structures. You use the Heaviside function to add in the point loads as you work across the structure, calculating the shear loads.
We learned how to do it in Mathcad when I was in college, but I can't justify the cost of Mathcad, to analyze the couple of simple four stringer bridges I design each year.
A couple of nested "IF" operators will return the definition of the Heaviside Step Function in the image at the top of the page:
0 when x < 0
.5 when x = 0
1 when x > 0
The formula is ... =IF(A1<0,0,(IF(A1=0,0.5,1)))Joe Bartok
Forgot to attach the worksheet.Joe Bartok
john
I think it is great to make your own worksheets.
But for those of us who don't understand trig there is Joe Fusco's roof cutting worksheet.
http://www.josephfusco.org/Calculators/Simple%20Roof%20Calculator.html
Rich