Spreadsheet: 265374d1379234124-want-convert-time-from-1217-50-into-12-17-30-find-true-north
Sheet: calculate

 |  | NOON TRANSIT FOR THE YEAR BUT FOR ANY GIVEN LOCATION |  |  |  |  |  |  | copied from illustrating shadows
 |  | NOON TRANSIT FOR A SPECIFIED LOCATION |  |  |  |  | hhmm.m
 |  | Longitude of design dial: |  |  | 96.63 | Longitude of standard time: |  |  | 90 |  | Diff in degrees: |  | mins:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  | BLACK | time is at or after legal noon standard time [no summer time correction] |  |  |  |  |  |  |  | If a leap year then after February
 |  |  | BLUE | before legal noon  standard time [no summer time correction] |  |  |  |  |  |  |  | 28 use the next day's value
 |  | EOT is the mid fit for four years of astronomical EOT data
 |  | Two digits are shown not for accuracy but to avoid the formula showing hh60 when in fact it is stored as hh59.9xxx
 |  |  |  | BELOW ARE INTERMEDIATE DATA
 |  |  |  | DO NOT ALTER ANYTHING BELOW
 |  | NOON TRANSIT FOR LOCATION |  |  |  |  |  |  |  |  | hhmm.m
 |  | Latitude of design dial: |  |  |  | Longitude of design dial: |  |  |  |  | Diff in degrees: |  | mins:
 |  |  | 1
 |  |  |  |  |  |  |  |  | For leap years and after Feb 28, use next day's correction
 |  | EOT as 1200 + EOT in hh.hhhh |  |  |  | plus d/long in hh
 |  | EOT as 1200 + EOT in hh.hhhh
 |  | noon + EOT for mid point of astronomical EOT for the 2008, 2009, 2010, 2011 years |  |  |  |  |  |  |  |  | hhh.hhhh
 |  | Mid point of astronomical EOT for the 2008, 2009, 2010, 2011 years |  |  |  |  |  |  | mm.mm
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jly | Aug | Sep | Oct | Nov | Dec
 |  | 1 | 3.312297673372835 | 13.31707364205821 | 12.27332069330317 | 4.0149902225829 | -2.500764199351054 | -2.154669517229916 | 3.447044436042367 | 6.219501112036398 | 0.1174700126848604 | -10.07854847564388 | -16.26265803444275 | -11.10563773569719
 |  | 2 | 3.782362435848851 | 13.39736678918085 | 12.1553278574101 | 3.437056962640168 | -2.572319696908835 | -2.062839464709392 | 3.562657250968474 | 6.182151810398024 | -0.07229053187471746 | -10.27303867832383 | -16.27844608333285 | -10.48018659782494
 |  | 3 | 4.246919244578127 | 13.46942830381314 | 12.03238534131751 | 3.260370561201815 | -3.038481701158374 | -1.567163105528558 | 4.075564356225459 | 6.138730093360906 | -0.2649082680177515 | -10.46459953766518 | -16.28605670684271 | -10.24851475176784
 |  | 4 | 4.705472819629518 | 13.53326920100975 | 11.50468508523824 | 3.085116595532972 | -3.09918646432345 | -1.467812194958494 | 4.185555928059819 | 6.089251856708417 | -0.4602143556309681 | -11.05302503136752 | -16.28540560721457 | -10.01085315309658
 |  | 5 | 5.157538314649269 | 13.58891065315967 | 11.37242135535598 | 2.511478568945981 | -3.15437686001193 | -1.364964802731027 | 4.292426741160104 | 6.03374049167831 | -1.058037520114703 | -11.23810941716278 | -16.2764171255709 | -9.367441990981272
 |  | 6 | 5.602642068583375 | 14.036383782533 | 11.23579050250421 | 2.339637808388159 | -3.204002546394846 | -1.258805056828058 | 4.395976496918344 | 5.572226746657007 | -1.258204157516801 | -11.41964739360158 | -16.25902452257177 | -9.11853035723905
 |  | 7 | 6.040322328929542 | 14.07572943973285 | 11.0949907291595 | 2.169773359241104 | -3.248020124103681 | -1.149522872277294 | 4.496010139144277 | 5.50474858010182 | -1.460538434249786 | -11.59743427031965 | -16.23317024921139 | -8.464375893691887
 |  | 8 | 6.470129944851113 | 14.10699796908181 | 10.55022186486803 | 2.002061876952608 | -3.286393288054188 | -1.037313665444514 | 4.592338156623414 | 5.431351005509831 | -2.064862381631408 | -12.17126614800987 | -16.1988062066412 | -8.205244418552152
 |  | 9 | 6.891629028590123 | 14.13024896198022 | 10.40168515022073 | 1.43667751518432 | -3.319092972440857 | -0.522378054461341 | 5.084776871683898 | 5.352085929253606 | -2.270995985594426 | -12.34094010815546 | -16.1558939939189 | -7.541409532632407
 |  | 10 | 7.304397583769946 | 14.14555099928398 | 10.24958302942722 | 1.273791810195222 | -3.346097488123369 | -0.4049215464078811 | 5.173148714276922 | 5.267011982103362 | -2.478757271876493 | -12.5062544126554 | -16.10440514260774 | -7.27315220628983
 |  | 11 | 7.70802809931497 | 14.15298138376873 | 10.0941189514445 | 1.113573561212857 | -3.367392651639899 | -0.2851542119367003 | 5.257282480912414 | 5.176194345279147 | -3.087962387127895 | -13.06700871330063 | -16.04432133716373 | -7.000760347988162
 |  | 12 | 8.102128107703704 | 14.1526258637504 | 9.535497179637472 | 0.5561887065887179 | -3.382971905093989 | -0.1632903481119891 | 5.337013577969173 | 5.079704571836744 | -3.298425676328101 | -13.22300427106514 | -15.57563462007842 | -6.324528355549881
 |  | 13 | 8.486320706548018 | 14.14457834893492 | 9.373922609802605 | 0.4018001955867557 | -3.392836426167117 | -0.03954813023747507 | 5.412184248923444 | 4.577620404240763 | -3.509959757033577 | -13.37404418510582 | -15.49834758077984 | -6.044756651097988
 |  | 14 | 8.86024504257887 | 14.12894061955138 | 9.209600596432615 | 0.2505678557087589 | -3.396995227534938 | 0.08585074650190602 | 5.482643785076679 | 4.470025588894075 | -4.122375590919666 | -13.5199336312768 | -15.4124735273244 | -5.361751200861039
 |  | 15 | 9.22355675715374 | 14.10582202985159 | 9.042736786961793 | 0.1026482554693293 | -3.395465244980299 | 0.2126814346662144 | 5.548248719474837 | 4.357009688445324 | -4.335482553166442 | -14.06048010992131 | -15.31803663996101 | -5.075823021009452
 |  | 16 | 9.575928392700789 | 14.07533920699764 | 8.47353696376875 | -0.04180543735500551 | -3.388271413523768 | 0.3407163105991283 | 6.008863003737775 | 4.238667892643494 | -4.549088500254132 | -14.19549370266984 | -15.21507210568633 | -4.387287670734306
 |  | 17 | 9.917049759482332 | 14.03761574639118 | 8.3022068935902 | -0.1826436020033268 | -3.375446730918511 | 0.4697253578585288 | 6.064358167582085 | 4.115100828481154 | -5.162999836762141 | -14.32478733783023 | -15.10362623296921 | -4.09646473384598
 |  | 18 | 10.24662826230405 | 13.59278190443137 | 8.128952184047618 | -0.3197203154148738 | -3.357032307895304 | 0.5994765571413548 | 6.114613460916159 | 3.586414370382975 | -5.377021581741558 | -14.44817706399352 | -14.58375654585322 | -3.403677290220995
 |  | 19 | 10.564389186892 | 13.54097428970689 | 7.55397814685144 | -0.4528935071965588 | -3.333077404560234 | 1.129736281616998 | 6.159515978399535 | 3.452719451092916 | -5.590957435320968 | -14.5654823313324 | -14.45553185674208 | -3.109251378431635
 |  | 20 | 10.87007594580448 | 13.4823355535587 | 7.377489667310141 | -0.5820251186846886 | -3.303639452421552 | 1.260269696693722 | 6.198960766485446 | 3.314131873976588 | -6.204609846142565 | -15.076526280093 | -14.31903231719504 | -2.413515450951242
 |  | 21 | 11.16345028385633 | 13.41701408095729 | 7.199691079676658 | -1.106981265867932 | -3.268784061521234 | 1.390841163163789 | 6.232850912949911 | 3.170772127326865 | -6.417780080310472 | -15.18113603562487 | -14.17434944614333 | -2.116799823303007
 |  | 22 | 11.44429244317502 | 13.3451636825655 | 7.020786047859673 | -1.227632405877988 | -3.22858501222496 | 1.521214642634452 | 6.261097619074762 | 3.022765201298007 | -7.030268292445597 | -15.27914300932381 | -14.02158613500305 | -1.419436118636367
 |  | 23 | 11.71240128817915 | 13.26694328883134 | 6.440977451007691 | -1.343853506716415 | -3.183124231261792 | 2.051154104217483 | 6.283620254597191 | 2.47024040798734 | -7.241873599518289 | -15.37038320477666 | -13.46085662922149 | -1.121756709139675
 |  | 24 | 11.96759439083109 | 13.18251664694128 | 6.260467273446869 | -1.455524219841196 | -3.132491751641793 | 2.18042393135801 | 6.30034639569936 | 2.31333120519526 | -7.452394158098141 | -15.4546975283186 | -13.2922864858947 | -0.4240941557351668
 |  | 25 | 12.20970807667179 | 13.09205202136734 | 6.079456498438593 | -1.562529055191796 | -3.076785656156606 | 2.308789327756716 | 6.311211846309765 | 2.15217502431772 | -8.06162724563265 | -15.53193210322071 | -13.11601250711805 | -0.1267806475209308
 |  | 26 | 12.43859743228734 | 12.59572189872748 | 5.498145005228618 | -2.064757558178619 | -3.016112004210712 | 2.436016721285426 | 6.316160643069827 | 1.586913102791926 | -8.269369346393416 | -16.00193858661297 | -12.53218264886648 | 0.1698525575446597
 |  | 27 | 12.6541362749209 | 12.49370269763824 | 5.316731468784108 | -2.162104488127095 | -2.550584741771047 | 2.561874164837543 | 6.315145044358321 | 1.41769032142357 | -8.475416242666807 | -16.06457448826467 | -12.34095590522831 | 0.4654756893450075
 |  | 28 | 12.85621708512275 | 12.38617448414396 | 5.135413261748788 | -2.25446999763563 | -2.480325594321971 | 3.086131733039745 | 6.30812550383904 | 1.244655046969302 | -9.079563111777434 | -16.11970349027284 | -12.14250216793974 | 1.159761018151101
 |  | 29 | 13.04475090337321 |  | 4.554386357975543 | -2.341759812264756 | -2.405463942732334 | 3.20856191380618 | 6.295070629022106 | 1.067958980175194 | -9.281604629512547 | -16.16719576667058 | -11.53700206122245 | 1.4523834016899
 |  | 30 | 13.21966719175474 |  | 4.373845237131265 | -2.423885409927988 | -2.326136682009335 | 3.328939993691952 | 6.275957125391217 | 0.487757009525564 | -9.481335080438445 | -16.20692830194161 | -11.32464675200286 | 2.143020825239871
 |  | 31 | 13.38091366184964 |  | 4.193982789799366 |  | -2.242488063016574 |  | 6.250769726697373 | 0.3042070708157572 |  | -16.23878520741267 |  | 2.431354933427202