View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default Calculate Angle and Length in Triangle

Line1 starts at position 0.0
Line2 starts at position 0.0


Need to calculate angle from 0


Sure sounds like Vectors:

Length: 14.891395073096243

Angle (Depending on which direction):
141.6356275088955
or: -38.364372491104476

--
Dana DeLouis


"Cathy" wrote in message
...
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