View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Cathy[_2_] Cathy[_2_] is offline
external usenet poster
 
Posts: 24
Default Calculate Angle and Length in Triangle

Sorry if I am confusing things by not explaining 100%

This is very usefull to me as my head is hurting going through Trig websites
trying to remember everything again.

Okay let me try again from scratch

# A B C
1 Side Direction Length
2 Line1 20 35
3 Line2 45 30
4 Line3 ? ?

Three lines form a triangle. Lets call it Triangle ABC with these letters on
each of the corners
(it is not a right Triangle)
Line1 = a = AB
Line2 = b = BC
Line3 = c = CA

Line1 starts at position 0.0
Line1 is angled at 20 degrees from 0 (0 being horizontal)
Line1 is 35 meters long

Line2 starts at position 0.0 also
Line2 is angled at 45 degrees from 0
Line2 is 30 meters long

The difference in angle between Line1 and Line2 is therefore 25 degrees

Line3 completes the Triangle
Need to calculate angle from 0
Need to calculate length

Therefore using Daves Example the angle of side1 would be 25

If you had:
# A B C
1 Angle Length
2 Side1 25 35
3 Side2 ? 30
4 Side3 ? ?


And therefore I have to calculate three values
If formulas for these three can be provided, then I will be very happy.

Hope this makes a little more sense now. (Wish I could draw it as I see it
in text)

TIA
C