Quote:
Originally Posted by DavidLJ
Dave - Using your formula “NewSpan := 2 * atan(tan(EquatorialSpan/2)/cos(Declination))” in a speadsheet I get the following results for an entered EquatorialSpan of 30 seconds (i.e. 0.008333 hours) :
Latitude in Declination : Formula result (rounded to 3 decimal places)
0º : 0.008
30º : 0.054
60º : - 0.009
80º : - 0.076
85º : - 0.009
89º : 0.016
90º : - 0.019
There seem to be both positive and negative results. I realise that atan, tan and cos work with radians but I don't quite see how I can relate the formula's results to the required output values.
|
You have a unit conversion problem... you're passing your angles in units of degrees to the atan/tan/cos functions, but it's expecting them in units of radians.
Try converting your equatorial span and declination inputs into radians first:
radians = degrees / 180 * PI()
i.e. for every 180 degrees there are Pi (3.14159...) radians.
You then apply my formula using radians as inputs, and you'll get an answer in radians. Convert the radians back to arc seconds this way:
arcsecs = radians / PI() * 180 * 60 * 60
i.e. for every Pi radians, there are 180 degrees; for every degree, there are 60 arc mins; for every arc min, there are 60 arc seconds.
Once you get the conversions right, you'll find that my formula gives the same values as your reference answers
Edit: Here's a worked example just to clarify things.
Equatorial Span = 30 arc sec
= 30/60/60 degrees
= 30/60/60/180*PI radians
= 0.00014544 radians
Declination = 85 degrees
= 85/180*PI radians
= 1.48352986 radians
RA Span at DEC 85 = 2 * atan(tan(EquatorialSpan/2)/cos(Declination))
= 2 * atan(tan(0.00014544/2)/cos(1.48352986))
= 0.001668736 radians
= 0.001668736/PI*180 degrees
= 0.0956 degrees
= 0.0956*60 arc mins
= 5.74 arc mins (as per your reference value)
Hope this helps!