Spreadsheet: 84206d1284202998-conditional-formatting-problem-a-true-north-finder1
Sheet: EoT table

 | Equation of time (EoT)
 |  |  |  | minus = slow
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
DAY | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec |  |  |  |  | DAY | sec | sec | sec | sec | sec | sec | sec | sec | sec | sec | sec | sec |  | DAY | sec | sec | sec | sec | sec | sec | sec | sec | sec | sec | sec | sec
1 | -3 | -12 | -13 | -33 | -12 | -34 | -4 | -8 | 2 | 51 | 2 | 25 | -3 | -33 | -6 | -16 | 0 | -12 | 10 | 5 | 16 | 20 | 11 | 11 |  |  |  |  | 1 | -192 | -813 | -754 | -248 | 171 | 145 | -213 | -376 | -12 | 605 | 980 | 671 |  | 1 | 28 | 8 | -11 | -18 | -8 | 9 | 12 | -3 | -19 | -19 | -2 | 22
2 | -3 | -40 | -13 | -41 | -12 | -23 | -3 | -50 | 2 | 59 | 2 | 16 | -3 | -45 | -6 | -13 | 0 | 7 | 10 | 24 | 16 | 22 | 10 | 49 |  |  |  |  | 2 | -220 | -821 | -743 | -230 | 179 | 136 | -225 | -373 | 7 | 624 | 982 | 649 |  | 2 | 28 | 7 | -12 | -18 | -7 | 10 | 12 | -4 | -19 | -19 | -1 | 23
3 | -4 | -8 | -13 | -48 | -12 | -11 | -3 | -32 | 3 | 6 | 2 | 6 | -3 | -57 | -6 | -9 | 0 | 26 | 10 | 43 | 16 | 23 | 10 | 26 |  |  |  |  | 3 | -248 | -828 | -731 | -212 | 186 | 126 | -237 | -369 | 26 | 643 | 983 | 626 |  | 3 | 28 | 7 | -13 | -18 | -6 | 10 | 11 | -5 | -19 | -19 | 0 | 24
4 | -4 | -36 | -13 | -55 | -11 | -58 | -3 | -14 | 3 | 12 | 1 | 56 | -4 | -8 | -6 | -4 | 0 | 45 | 11 | 2 | 16 | 23 | 10 | 2 |  |  |  |  | 4 | -276 | -835 | -718 | -194 | 192 | 116 | -248 | -364 | 45 | 662 | 983 | 602 |  | 4 | 27 | 6 | -13 | -17 | -6 | 10 | 11 | -5 | -20 | -18 | 1 | 24
5 | -5 | -3 | -14 | -1 | -11 | -45 | -2 | -57 | 3 | 18 | 1 | 46 | -4 | -19 | -5 | -59 | 1 | 5 | 11 | 20 | 16 | 22 | 9 | 38 |  |  |  |  | 5 | -303 | -841 | -705 | -177 | 198 | 106 | -259 | -359 | 65 | 680 | 982 | 578 |  | 5 | 27 | 5 | -14 | -17 | -5 | 10 | 10 | -6 | -20 | -18 | 2 | 25
6 | -5 | -30 | -14 | -6 | -11 | -31 | -2 | -40 | 3 | 23 | 1 | 36 | -4 | -29 | -5 | -53 | 1 | 25 | 11 | 38 | 16 | 20 | 9 | 13 |  |  |  |  | 6 | -330 | -846 | -691 | -160 | 203 | 96 | -269 | -353 | 85 | 698 | 980 | 553 |  | 6 | 27 | 4 | -14 | -17 | -4 | 11 | 10 | -7 | -20 | -18 | 2 | 25
7 | -5 | -57 | -14 | -10 | -11 | -17 | -2 | -23 | 3 | 27 | 1 | 25 | -4 | -39 | -5 | -46 | 1 | 45 | 11 | 56 | 16 | 18 | 8 | 48 |  |  |  |  | 7 | -357 | -850 | -677 | -143 | 207 | 85 | -279 | -346 | 105 | 716 | 978 | 528 |  | 7 | 26 | 4 | -14 | -17 | -4 | 11 | 10 | -7 | -20 | -17 | 3 | 26
8 | -6 | -23 | -14 | -14 | -11 | -3 | -2 | -6 | 3 | 31 | 1 | 14 | -4 | -49 | -5 | -39 | 2 | 5 | 12 | 13 | 16 | 15 | 8 | 22 |  |  |  |  | 8 | -383 | -854 | -663 | -126 | 211 | 74 | -289 | -339 | 125 | 733 | 975 | 502 |  | 8 | 26 | 2 | -15 | -17 | -4 | 11 | 9 | -8 | -21 | -17 | 4 | 26
9 | -6 | -49 | -14 | -16 | -10 | -48 | -1 | -49 | 3 | 35 | 1 | 3 | -4 | -58 | -5 | -31 | 2 | 26 | 12 | 30 | 16 | 11 | 7 | 56 |  |  |  |  | 9 | -409 | -856 | -648 | -109 | 215 | 63 | -298 | -331 | 146 | 750 | 971 | 476 |  | 9 | 25 | 2 | -15 | -17 | -3 | 12 | 9 | -8 | -21 | -16 | 5 | 27
10 | -7 | -14 | -14 | -18 | -10 | -33 | -1 | -32 | 3 | 38 | 0 | 51 | -5 | -7 | -5 | -23 | 2 | 47 | 12 | 46 | 16 | 6 | 7 | 29 |  |  |  |  | 10 | -434 | -858 | -633 | -92 | 218 | 51 | -307 | -323 | 167 | 766 | 966 | 449 |  | 10 | 24 | 1 | -15 | -16 | -2 | 12 | 9 | -9 | -21 | -16 | 6 | 27
11 | -7 | -38 | -14 | -19 | -10 | -18 | -1 | -16 | 3 | 40 | 0 | 39 | -5 | -16 | -5 | -14 | 3 | 8 | 13 | 2 | 16 | 0 | 7 | 2 |  |  |  |  | 11 | -458 | -859 | -618 | -76 | 220 | 39 | -316 | -314 | 188 | 782 | 960 | 422 |  | 11 | 24 | 1 | -16 | -16 | -2 | 12 | 8 | -9 | -21 | -16 | 7 | 28
12 | -8 | -2 | -14 | -20 | -10 | -2 | -1 | 0 | 3 | 42 | 0 | 27 | -5 | -24 | -5 | -5 | 3 | 29 | 13 | 18 | 15 | 53 | 6 | 34 |  |  |  |  | 12 | -482 | -860 | -602 | -60 | 222 | 27 | -324 | -305 | 209 | 798 | 953 | 394 |  | 12 | 23 | -1 | -16 | -16 | -2 | 12 | 8 | -10 | -21 | -15 | 7 | 28
13 | -8 | -25 | -14 | -19 | -9 | -46 | 0 | -44 | 3 | 44 | 0 | 15 | -5 | -32 | -4 | -55 | 3 | 50 | 13 | 33 | 15 | 46 | 6 | 6 |  |  |  |  | 13 | -505 | -859 | -586 | -44 | 224 | 15 | -332 | -295 | 230 | 813 | 946 | 366 |  | 13 | 23 | -1 | -16 | -15 | 0 | 12 | 7 | -11 | -21 | -14 | 9 | 28
14 | -8 | -48 | -14 | -18 | -9 | -30 | 0 | -29 | 3 | 44 | 0 | 3 | -5 | -39 | -4 | -44 | 4 | 11 | 13 | 47 | 15 | 37 | 5 | 38 |  |  |  |  | 14 | -528 | -858 | -570 | -29 | 224 | 3 | -339 | -284 | 251 | 827 | 937 | 338 |  | 14 | 22 | -2 | -17 | -15 | 0 | 13 | 7 | -11 | -21 | -14 | 9 | 29
15 | -9 | -10 | -14 | -16 | -9 | -13 | 0 | -14 | 3 | 44 | 0 | -10 | -5 | -46 | -4 | -33 | 4 | 32 | 14 | 1 | 15 | 28 | 5 | 9 |  |  |  |  | 15 | -550 | -856 | -553 | -14 | 224 | -10 | -346 | -273 | 272 | 841 | 928 | 309 |  | 15 | 22 | -3 | -17 | -15 | 0 | 13 | 6 | -12 | -21 | -13 | 10 | 29
16 | -9 | -32 | -14 | -13 | -8 | -56 | 0 | 1 | 3 | 44 | 0 | -23 | -5 | -52 | -4 | -21 | 4 | 53 | 14 | 14 | 15 | 18 | 4 | 40 |  |  |  |  | 16 | -572 | -853 | -536 | 1 | 224 | -23 | -352 | -261 | 293 | 854 | 918 | 280 |  | 16 | 20 | -3 | -17 | -14 | 1 | 13 | 6 | -12 | -21 | -13 | 11 | 29
17 | -9 | -52 | -14 | -10 | -8 | -39 | 0 | 15 | 3 | 43 | 0 | -36 | -5 | -58 | -4 | -9 | 5 | 14 | 14 | 27 | 15 | 7 | 4 | 11 |  |  |  |  | 17 | -592 | -850 | -519 | 15 | 223 | -36 | -358 | -249 | 314 | 867 | 907 | 251 |  | 17 | 20 | -4 | -17 | -14 | 2 | 13 | 5 | -12 | -21 | -12 | 11 | 29
18 | -10 | -12 | -14 | -6 | -8 | -22 | 0 | 29 | 3 | 41 | 0 | -49 | -6 | -3 | -3 | -57 | 5 | 35 | 14 | 39 | 14 | 56 | 3 | 42 |  |  |  |  | 18 | -612 | -846 | -502 | 29 | 221 | -49 | -363 | -237 | 335 | 879 | 896 | 222 |  | 18 | 20 | -5 | -18 | -14 | 2 | 13 | 5 | -13 | -21 | -12 | 13 | 29
19 | -10 | -32 | -14 | -1 | -8 | -4 | 0 | 43 | 3 | 39 | -1 | -2 | -6 | -8 | -3 | -44 | 5 | 56 | 14 | 51 | 14 | 43 | 3 | 13 |  |  |  |  | 19 | -632 | -841 | -484 | 43 | 219 | -62 | -368 | -224 | 356 | 891 | 883 | 193 |  | 19 | 18 | -6 | -18 | -13 | 2 | 13 | 4 | -14 | -22 | -11 | 13 | 30
20 | -10 | -50 | -13 | -55 | -7 | -46 | 0 | 56 | 3 | 37 | -1 | -15 | -6 | -12 | -3 | -30 | 6 | 18 | 15 | 2 | 14 | 30 | 2 | 43 |  |  |  |  | 20 | -650 | -835 | -466 | 56 | 217 | -75 | -372 | -210 | 378 | 902 | 870 | 163 |  | 20 | 18 | -6 | -18 | -4 | 3 | 13 | 3 | -14 | -22 | -10 | 14 | 30
21 | -11 | -8 | -13 | -49 | -7 | -28 | 1 | 0 | 3 | 34 | -1 | -28 | -6 | -15 | -3 | -16 | 6 | 40 | 15 | 12 | 14 | 16 | 2 | 13 |  |  |  |  | 21 | -668 | -829 | -448 | 60 | 214 | -88 | -375 | -196 | 400 | 912 | 856 | 133 |  | 21 | 17 | -7 | -18 | -21 | 4 | 13 | 3 | -15 | -21 | -10 | 15 | 30
22 | -11 | -25 | -13 | -42 | -7 | -10 | 1 | 21 | 3 | 30 | -1 | -41 | -6 | -18 | -3 | -1 | 7 | 1 | 15 | 22 | 14 | 1 | 1 | 43 |  |  |  |  | 22 | -685 | -822 | -430 | 81 | 210 | -101 | -378 | -181 | 421 | 922 | 841 | 103 |  | 22 | 16 | -7 | -18 | -12 | 6 | 13 | 2 | -15 | -21 | -9 | 16 | 30
23 | -11 | -41 | -13 | -35 | -6 | -52 | 1 | 33 | 3 | 24 | -1 | -54 | -6 | -20 | -2 | -46 | 7 | 22 | 15 | 31 | 13 | 45 | 1 | 13 |  |  |  |  | 23 | -701 | -815 | -412 | 93 | 204 | -114 | -380 | -166 | 442 | 931 | 825 | 73 |  | 23 | 16 | -8 | -18 | -12 | 3 | 13 | 2 | -16 | -21 | -9 | 17 | 30
24 | -11 | -57 | -13 | -27 | -6 | -34 | 1 | 45 | 3 | 21 | -2 | -7 | -6 | -22 | -2 | -30 | 7 | 43 | 15 | 40 | 13 | 28 | 0 | 43 |  |  |  |  | 24 | -717 | -807 | -394 | 105 | 201 | -127 | -382 | -150 | 463 | 940 | 808 | 43 |  | 24 | 15 | -9 | -18 | -11 | 5 | 13 | 2 | -16 | -21 | -7 | 17 | 30
25 | -12 | -12 | -13 | -18 | -6 | -16 | 1 | 56 | 3 | 16 | -2 | -20 | -6 | -24 | -2 | -14 | 8 | 4 | 15 | 47 | 13 | 11 | 0 | 13 |  |  |  |  | 25 | -732 | -798 | -376 | 116 | 196 | -140 | -384 | -134 | 484 | 947 | 791 | 13 |  | 25 | 14 | -9 | -18 | -10 | 6 | 13 | 1 | -16 | -21 | -7 | 18 | 30
26 | -12 | -26 | -13 | -9 | -5 | -58 | 2 | 6 | 3 | 10 | -2 | -33 | -6 | -25 | -1 | -58 | 8 | 25 | 15 | 54 | 12 | 53 | 0 | -17 |  |  |  |  | 26 | -746 | -789 | -358 | 126 | 190 | -153 | -385 | -118 | 505 | 954 | 773 | -17 |  | 26 | 13 | -10 | -18 | -10 | 7 | 12 | 0 | -17 | -21 | -7 | 19 | 30
27 | -12 | -39 | -12 | -59 | -5 | -40 | 2 | 16 | 3 | 3 | -2 | -45 | -6 | -25 | -1 | -41 | 8 | 46 | 16 | 1 | 12 | 34 | 0 | -47 |  |  |  |  | 27 | -759 | -779 | -340 | 136 | 183 | -165 | -385 | -101 | 526 | 961 | 754 | -47 |  | 27 | 12 | -11 | -19 | -10 | 7 | 12 | -1 | -17 | -20 | -5 | 20 | 29
28 | -12 | -51 | -12 | -48 | -5 | -21 | 2 | 26 | 2 | 56 | -2 | -57 | -6 | -24 | -1 | -24 | 9 | 6 | 16 | 6 | 12 | 14 | -1 | -16 |  |  |  |  | 28 | -771 | -768 | -321 | 146 | 176 | -177 | -384 | -84 | 546 | 966 | 734 | -76 |  | 28 | 12 | -6 | -19 | -9 | 7 | 12 | -1 | -17 | -20 | -5 | 20 | 29
29 | -13 | -3 | -12 | -42 | -5 | -2 | 2 | 35 | 2 | 49 | -3 | -9 | -6 | -23 | -1 | -7 | 9 | 26 | 16 | 11 | 11 | 54 | -1 | -45 |  |  |  |  | 29 | -783 | -762 | -302 | 155 | 169 | -189 | -383 | -67 | 566 | 971 | 714 | -105 |  | 29 | 11 | #N/A | -18 | -8 | 8 | 12 | -2 | -18 | -20 | -4 | 21 | 29
30 | -13 | -14 | x | X | -4 | -44 | 2 | 43 | 2 | 41 | -3 | -21 | -6 | -21 | 0 | -49 | 9 | 46 | 16 | 15 | 11 | 33 | -2 | -14 |  |  |  |  | 30 | -794 | X | -284 | 163 | 161 | -201 | -381 | -49 | 586 | 975 | 693 | -134 |  | 30 | 10 | #N/A | -18 | #N/A | 8 | #N/A | -2 | -18 | #N/A | -3 | #N/A | 29
31 | -13 | -24 | x | X | -4 | -26 | x | x | 2 | 33 | x | x | -6 | -19 | 0 | -31 | X | x | 16 | 18 | x | x | -2 | -43 |  |  |  |  | 31 | -804 | X | -266 | X | 153 | X | -379 | -31 | X | 978 | X | -163 |  | 31 | -804 | #N/A | -266 | #N/A | 153 | #N/A | -379 | -31 | #N/A | 978 | #N/A | -163
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is for checking only
 |  |  | this table is copied from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | it shows the pattern of the day to day difference
 |  |  | Sundials their theory and construction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Converts table on the left into seconds |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Of EoT table
 |  |  | [NAME]
 |  |  | page 205
 |  | CAUTION: some almanacs show the equation of time with opposite signs to those used here. To
 |  | a dialist, a minus means the sun is running fast and needs the minus to "slow it down". To an
 |  | astronomer, a minus means the sun is "slow" or "minus" and thus needs a plus to correct it.
 |  | Neither is right, neither is wrong, it is just that astronomers and dialists have different
 |  | perspectives.
 |  |  | For your [NAME] true, add a dozen and two. |  |  |  |  |  |  | dial is slow
 |  |  |  |  |  |  |  |  |  | clock is fast
 |  |  | The above is opposite to the poem