View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Calculate Angle and Length in Triangle

Looks like you are well on the right track. I haven't looked closely at your
slightly modified formulas but all your results appear same as Dana's &
mine, so I assume all OK.

Regards,
Peter T


"Cathy" wrote in message
...
I thank you both for your all this

Your formula is perfect. I just had difficulty relating your references to
A,a,B,b,C and c.

Again I realise this is probably due to a mistake in my discription. All
this trig stuff is all slowly coming back to me.

What I should have said was
Line1 = b = AC = 20° from 0° = 35 meters
Line2 = c = AB = 45° from 0° = 30 meters
Line3 = a = CB = ?° from 0° = ? Meters
(I simply forgot that side "a" would be opposite to corner "A" :)

Going by the above then
A = BAC = 45° - 20° = 25°

A=ACOS((b^2+c^2-a^2)/(2*b*c))*180/PI()

I already have A. It is 25°

or as you want internal Angle-B
B=ACOS((a^2+c^2-a^2)/(2*a*c))*180/PI()

?Should this not read:
B=ACOS((a^2+c^2-b^2)/(2*a*c))*180/PI()

Is the following therefore correct?
A°=BAC=25°
B°=ABC=ACOS((a^2+c^2-b^2)/(2*a*c))*180/PI() = 96.63893451
C°=ACB=ACOS((b^2+a^2-c^2)/(2*a*b))*180/PI() = 58.36374786

And modelling by previous spreadsheet
# A B C
1 Side Direction Length
2 Line1 20 35
3 Line2 45 30
4 Line3 ? ?

The formula for B4 is:
=180-(ACOS((C4^2+C2^2-C3^2)/(2*C4*C2))*180/PI())+B2
= 141.6362521°

and Formula for C4 is:
=ROUND(SQRT(C2^2+C3^2-2*C2*C3*COS((B3-B2)*PI()/180)),2)
=14.89139507 meters

I have just realised another mistake in my original example, i.e. the

angle
of c should have been in the opposite direction. I should be able to work
that out myself and correct what I am trying to achieve.

Thank you so much for all your help.

Kind regards
C