Can someone simplyfy this?
A slight change reduces the number of Trig functions from 6 to 4.
In Radians:
Function Find_x(a, b, f, p)
Dim x As Double
Dim t As Double
Dim j As Long
x = 0
t = 1
Do While x < t
t = x
x = x + (a + (b - f) * Tan(x) - p * Cos(x)) / _
(f - b + a * Tan(x) - 2 * p * Sin(x))
Loop
Find_x = x
End Function
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"Dana DeLouis" wrote in message
...
Would this work for you? It returns an answer in Degrees:
This needed about 4 loops. (I used 'x for your angle)
7.51240351575601
Sub TestiT()
Dim a, b, f, p
a = 1430
b = 1651
f = 7984
p = 600
Debug.Print Find_x(a, b, f, p)
End Sub
<snip
|