NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Declination worksheet
From: Dan Allen
Date: 2004 May 19, 13:20 -0700
From: Dan Allen
Date: 2004 May 19, 13:20 -0700
Put the remainder of this file into a file named Declination.slk and you will have my spreadsheet for estimating declinations. It should be able to be opened by Excel (Mac or Windows), Lotus, etc. -- Everything below but not including this line is the SYLK file -- ID;PWXL;N;E P;PGeneral P;P0 P;P0.00 P;P#,##0 P;P#,##0.00 P;P#,##0_);;\(#,##0\) P;P#,##0_);;[Red]\(#,##0\) P;P#,##0.00_);;\(#,##0.00\) P;P#,##0.00_);;[Red]\(#,##0.00\) P;P"$"#,##0_);;\("$"#,##0\) P;P"$"#,##0_);;[Red]\("$"#,##0\) P;P"$"#,##0.00_);;\("$"#,##0.00\) P;P"$"#,##0.00_);;[Red]\("$"#,##0.00\) P;P0% P;P0.00% P;P0.00E+00 P;P##0.0E+0 P;P#\ ?/? P;P#\ ??/?? P;Pm/d/yyyy P;Pd\-mmm\-yy P;Pd\-mmm P;Pmmm\-yy P;Ph:mm\ AM/PM P;Ph:mm:ss\ AM/PM P;Ph:mm P;Ph:mm:ss P;Pm/d/yyyy\ h:mm P;Pmm:ss P;Pmm:ss.0 P;P@ P;P[h]:mm:ss P;P_("$"* #,##0_);;_("$"* \(#,##0\);;_("$"* "-"_);;_(@_) P;P_(* #,##0_);;_(* \(#,##0\);;_(* "-"_);;_(@_) P;P_("$"* #,##0.00_);;_("$"* \(#,##0.00\);;_("$"* "-"??_);;_(@_) P;P_(* #,##0.00_);;_(* \(#,##0.00\);;_(* "-"??_);;_(@_) P;P0.000 P;FTahoma;M160 P;FTahoma;M160 P;FTahoma;M160 P;FTahoma;M160 P;ETahoma;M160 P;ETahoma;M160 P;ETahoma;M160;SB F;P0;DG0G8;M210 B;Y74;X5;D0 0 73 4 O;L;D;V0;K47;G100 0.001 F;W1 1 6 F;W2 2 13 F;W3 3 19 F;W4 4 9 F;W5 5 32 F;W6 256 9 F;P36;FF3G;C2 F;P36;FF3G;C3 F;P36;FF3G;C5 F;P0;FG0C;SDM7;R1 C;Y1;X1;K"Angle" F;P36;FF3C;X2 C;K"Sin(Angle)" F;P36;FF3C;X3 C;K"Approx Declination" C;X4;K"Date" F;P36;FF3C;X5 C;K"Actual Declinations at 0000 GMT" C;Y2;X1;K0 C;X2;K0;ESIN(3.14159265358979/180*RC[-1]) C;X3;K0;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38066 C;X5;K-0.111 C;Y3;X1;K5 C;X2;K0.0871557427476581;ESIN(3.14159265358979/180*RC[-1]) C;X3;K2.04293061000511;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38071.0728083333;ER[-1]C+5*365.2422/360 C;X5;K1.86 C;Y4;X1;K10 C;X2;K0.17364817766693;ESIN(3.14159265358979/180*RC[-1]) C;X3;K4.07031328451284;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38076.1456166667;ER[-1]C+5*365.2422/360 C;X5;K3.816 C;Y5;X1;K15 C;X2;K0.258819045102521;ESIN(3.14159265358979/180*RC[-1]) C;X3;K6.06671841720308;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38081.218425;ER[-1]C+5*365.2422/360 C;Y6;X1;K20 C;X2;K0.342020143325668;ESIN(3.14159265358979/180*RC[-1]) C;X3;K8.01695215955367;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38086.2912333333;ER[-1]C+5*365.2422/360 C;X5;K7.608 C;Y7;X1;K25 C;X2;K0.422618261740699;ESIN(3.14159265358979/180*RC[-1]) C;X3;K9.90617205520198;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38091.3640416667;ER[-1]C+5*365.2422/360 C;Y8;X1;K30 C;X2;K0.5;ESIN(3.14159265358979/180*RC[-1]) C;X3;K11.72;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38096.43685;ER[-1]C+5*365.2422/360 C;X5;K11.203 C;Y9;X1;K35 C;X2;K0.573576436351046;ESIN(3.14159265358979/180*RC[-1]) C;X3;K13.4446316680685;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38101.5096583333;ER[-1]C+5*365.2422/360 C;Y10;X1;K40 C;X2;K0.642787609686539;ESIN(3.14159265358979/180*RC[-1]) C;X3;K15.0669415710525;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38106.5824666666;ER[-1]C+5*365.2422/360 C;X5;K14.49 C;Y11;X1;K45 C;X2;K0.707106781186547;ESIN(3.14159265358979/180*RC[-1]) C;X3;K16.5745829510127;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38111.655275;ER[-1]C+5*365.2422/360 C;Y12;X1;K50 C;X2;K0.766044443118977;ESIN(3.14159265358979/180*RC[-1]) C;X3;K17.9560817467088;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38116.7280833333;ER[-1]C+5*365.2422/360 C;X5;K17.38 C;Y13;X1;K55 C;X2;K0.819152044288991;ESIN(3.14159265358979/180*RC[-1]) C;X3;K19.200923918134;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38121.8008916666;ER[-1]C+5*365.2422/360 C;Y14;X1;K60 C;X2;K0.866025403784438;ESIN(3.14159265358979/180*RC[-1]) C;X3;K20.2996354647072;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38126.8737;ER[-1]C+5*365.2422/360 C;X5;K19.786 C;Y15;X1;K65 C;X2;K0.906307787036649;ESIN(3.14159265358979/180*RC[-1]) C;X3;K21.2438545281391;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38131.9465083333;ER[-1]C+5*365.2422/360 C;Y16;X1;K70 C;X2;K0.939692620785908;ESIN(3.14159265358979/180*RC[-1]) C;X3;K22.0263950312217;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38137.0193166666;ER[-1]C+5*365.2422/360 C;X5;K21.783 C;Y17;X1;K75 C;X2;K0.965925826289068;ESIN(3.14159265358979/180*RC[-1]) C;X3;K22.6413013682158;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38142.092125;ER[-1]C+5*365.2422/360 C;Y18;X1;K80 C;X2;K0.984807753012208;ESIN(3.14159265358979/180*RC[-1]) C;X3;K23.0838937306062;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38147.1649333333;ER[-1]C+5*365.2422/360 C;X5;K22.939 C;Y19;X1;K85 C;X2;K0.996194698091745;ESIN(3.14159265358979/180*RC[-1]) C;X3;K23.3508037232705;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38152.2377416666;ER[-1]C+5*365.2422/360 C;Y20;X1;K90 C;X2;K1;ESIN(3.14159265358979/180*RC[-1]) C;X3;K23.44;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38157.31055;ER[-1]C+5*365.2422/360 C;X5;K23.425 C;Y21;X1;K95 C;X2;K0.996194698091746;ESIN(3.14159265358979/180*RC[-1]) C;X3;K23.3508037232705;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38162.3833583333;ER[-1]C+5*365.2422/360 C;Y22;X1;K100 C;X2;K0.984807753012208;ESIN(3.14159265358979/180*RC[-1]) C;X3;K23.0838937306062;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38167.4561666666;ER[-1]C+5*365.2422/360 C;Y23;X1;K105 C;X2;K0.965925826289069;ESIN(3.14159265358979/180*RC[-1]) C;X3;K22.6413013682158;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38172.5289749999;ER[-1]C+5*365.2422/360 C;Y24;X1;K110 C;X2;K0.939692620785909;ESIN(3.14159265358979/180*RC[-1]) C;X3;K22.0263950312217;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38177.6017833333;ER[-1]C+5*365.2422/360 C;Y25;X1;K115 C;X2;K0.906307787036651;ESIN(3.14159265358979/180*RC[-1]) C;X3;K21.2438545281391;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38182.6745916666;ER[-1]C+5*365.2422/360 C;Y26;X1;K120 C;X2;K0.86602540378444;ESIN(3.14159265358979/180*RC[-1]) C;X3;K20.2996354647073;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38187.7473999999;ER[-1]C+5*365.2422/360 C;Y27;X1;K125 C;X2;K0.819152044288993;ESIN(3.14159265358979/180*RC[-1]) C;X3;K19.200923918134;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38192.8202083333;ER[-1]C+5*365.2422/360 C;Y28;X1;K130 C;X2;K0.766044443118979;ESIN(3.14159265358979/180*RC[-1]) C;X3;K17.9560817467089;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38197.8930166666;ER[-1]C+5*365.2422/360 C;Y29;X1;K135 C;X2;K0.707106781186549;ESIN(3.14159265358979/180*RC[-1]) C;X3;K16.5745829510127;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38202.9658249999;ER[-1]C+5*365.2422/360 C;Y30;X1;K140 C;X2;K0.642787609686541;ESIN(3.14159265358979/180*RC[-1]) C;X3;K15.0669415710525;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38208.0386333333;ER[-1]C+5*365.2422/360 C;Y31;X1;K145 C;X2;K0.573576436351048;ESIN(3.14159265358979/180*RC[-1]) C;X3;K13.4446316680686;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38213.1114416666;ER[-1]C+5*365.2422/360 C;Y32;X1;K150 C;X2;K0.500000000000002;ESIN(3.14159265358979/180*RC[-1]) C;X3;K11.7200000000001;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38218.1842499999;ER[-1]C+5*365.2422/360 C;Y33;X1;K155 C;X2;K0.422618261740702;ESIN(3.14159265358979/180*RC[-1]) C;X3;K9.90617205520205;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38223.2570583332;ER[-1]C+5*365.2422/360 C;Y34;X1;K160 C;X2;K0.342020143325671;ESIN(3.14159265358979/180*RC[-1]) C;X3;K8.01695215955374;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38228.3298666665;ER[-1]C+5*365.2422/360 C;Y35;X1;K165 C;X2;K0.258819045102524;ESIN(3.14159265358979/180*RC[-1]) C;X3;K6.06671841720315;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38233.4026749999;ER[-1]C+5*365.2422/360 C;Y36;X1;K170 C;X2;K0.173648177666933;ESIN(3.14159265358979/180*RC[-1]) C;X3;K4.07031328451292;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38238.4754833332;ER[-1]C+5*365.2422/360 C;Y37;X1;K175 C;X2;K0.0871557427476613;ESIN(3.14159265358979/180*RC[-1]) C;X3;K2.04293061000518;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38243.5482916666;ER[-1]C+5*365.2422/360 C;Y38;X1;K180 C;X2;K3.2311393144413E-15;ESIN(3.14159265358979/180*RC[-1]) C;X3;K7.57379055305041E-14;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38248.6210999999;ER[-1]C+5*365.2422/360 C;X5;K1.83 C;Y39;X1;K185 C;X2;K-0.0871557427476548;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-2.04293061000503;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38253.6939083332;ER[-1]C+5*365.2422/360 C;X5;K-0.106 C;Y40;X1;K190 C;X2;K-0.173648177666927;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-4.07031328451277;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38258.7667166666;ER[-1]C+5*365.2422/360 C;Y41;X1;K195 C;X2;K-0.258819045102517;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-6.06671841720301;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38263.8395249999;ER[-1]C+5*365.2422/360 C;Y42;X1;K200 C;X2;K-0.342020143325665;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-8.0169521595536;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38268.9123333332;ER[-1]C+5*365.2422/360 C;Y43;X1;K205 C;X2;K-0.422618261740696;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-9.90617205520192;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38273.9851416666;ER[-1]C+5*365.2422/360 C;Y44;X1;K210 C;X2;K-0.499999999999997;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-11.7199999999999;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38279.0579499999;ER[-1]C+5*365.2422/360 C;Y45;X1;K215 C;X2;K-0.573576436351043;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-13.4446316680684;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38284.1307583332;ER[-1]C+5*365.2422/360 C;Y46;X1;K220 C;X2;K-0.642787609686536;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-15.0669415710524;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38289.2035666665;ER[-1]C+5*365.2422/360 C;Y47;X1;K225 C;X2;K-0.707106781186545;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-16.5745829510126;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38294.2763749999;ER[-1]C+5*365.2422/360 C;Y48;X1;K230 C;X2;K-0.766044443118976;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-17.9560817467088;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38299.3491833332;ER[-1]C+5*365.2422/360 C;Y49;X1;K235 C;X2;K-0.81915204428899;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-19.2009239181339;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38304.4219916665;ER[-1]C+5*365.2422/360 C;Y50;X1;K240 C;X2;K-0.866025403784437;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-20.2996354647072;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38309.4947999999;ER[-1]C+5*365.2422/360 C;Y51;X1;K245 C;X2;K-0.906307787036648;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-21.243854528139;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38314.5676083332;ER[-1]C+5*365.2422/360 C;Y52;X1;K250 C;X2;K-0.939692620785907;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-22.0263950312217;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38319.6404166665;ER[-1]C+5*365.2422/360 C;Y53;X1;K255 C;X2;K-0.965925826289067;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-22.6413013682157;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38324.7132249999;ER[-1]C+5*365.2422/360 C;Y54;X1;K260 C;X2;K-0.984807753012207;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-23.0838937306061;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38329.7860333332;ER[-1]C+5*365.2422/360 C;Y55;X1;K265 C;X2;K-0.996194698091745;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-23.3508037232705;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38334.8588416665;ER[-1]C+5*365.2422/360 C;Y56;X1;K270 C;X2;K-1;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-23.44;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38339.9316499999;ER[-1]C+5*365.2422/360 C;Y57;X1;K275 C;X2;K-0.996194698091746;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-23.3508037232705;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38345.0044583332;ER[-1]C+5*365.2422/360 C;Y58;X1;K280 C;X2;K-0.984807753012209;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-23.0838937306062;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38350.0772666665;ER[-1]C+5*365.2422/360 C;Y59;X1;K285 C;X2;K-0.96592582628907;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-22.6413013682158;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38355.1500749998;ER[-1]C+5*365.2422/360 C;Y60;X1;K290 C;X2;K-0.93969262078591;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-22.0263950312217;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38360.2228833332;ER[-1]C+5*365.2422/360 C;Y61;X1;K295 C;X2;K-0.906307787036652;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-21.2438545281391;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38365.2956916665;ER[-1]C+5*365.2422/360 C;Y62;X1;K300 C;X2;K-0.866025403784441;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-20.2996354647073;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38370.3684999998;ER[-1]C+5*365.2422/360 C;Y63;X1;K305 C;X2;K-0.819152044288995;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-19.200923918134;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38375.4413083332;ER[-1]C+5*365.2422/360 C;Y64;X1;K310 C;X2;K-0.766044443118982;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-17.9560817467089;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38380.5141166665;ER[-1]C+5*365.2422/360 C;Y65;X1;K315 C;X2;K-0.707106781186551;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-16.5745829510128;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38385.5869249998;ER[-1]C+5*365.2422/360 C;Y66;X1;K320 C;X2;K-0.642787609686544;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-15.0669415710526;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38390.6597333331;ER[-1]C+5*365.2422/360 C;Y67;X1;K325 C;X2;K-0.573576436351051;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-13.4446316680686;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38395.7325416665;ER[-1]C+5*365.2422/360 C;Y68;X1;K330 C;X2;K-0.500000000000005;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-11.7200000000001;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38400.8053499998;ER[-1]C+5*365.2422/360 C;Y69;X1;K335 C;X2;K-0.422618261740705;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-9.90617205520212;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38405.8781583332;ER[-1]C+5*365.2422/360 C;Y70;X1;K340 C;X2;K-0.342020143325674;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-8.01695215955381;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38410.9509666665;ER[-1]C+5*365.2422/360 C;Y71;X1;K345 C;X2;K-0.258819045102527;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-6.06671841720323;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38416.0237749998;ER[-1]C+5*365.2422/360 C;Y72;X1;K350 C;X2;K-0.173648177666937;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-4.07031328451299;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38421.0965833331;ER[-1]C+5*365.2422/360 C;Y73;X1;K355 C;X2;K-0.0871557427476645;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-2.04293061000526;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38426.1693916665;ER[-1]C+5*365.2422/360 C;Y74;X1;K360 C;X2;K-6.4622786288826E-15;ESIN(3.14159265358979/180*RC[-1]) C;X3;K-1.51475811061008E-13;ERC[-1]*23.44 F;P20;FG0G;X4 C;K38431.2421999998;ER[-1]C+5*365.2422/360 E