Spreadsheet: 178552d1346841561-aggregation-of-annual-rainfall-daily-data-to-2-day-and-3-day-without-crossing-next-year-aggregation-sample
Sheet: Sheet1

DATE | RR | year | two day
19410101 | 0
19410102 | 0
19410103 | 138
19410104 | 10
19410105 | 0
19410106 | 0
19410107 | 0
19410108 | 0
19410109 | 0
19410110 | 0
19410111 | 0
19410112 | 0
19410113 | 57
19410114 | 18
19410115 | 22
19410116 | 11
19410117 | 39
19410118 | 235
19410119 | 110
19410120 | 2
19410121 | 4
19410122 | 13
19410123 | 38
19410124 | 34
19410125 | 2
19410126 | 153
19410127 | 128
19410128 | 96
19410129 | 158
19410130 | 5
19410131 | 22
19410201 | 141
19410202 | 2
19410203 | 0
19410204 | 391
19410205 | 14
19410206 | 71
19410207 | 40
19410208 | 60
19410209 | 12
19410210 | 0
19410211 | 198
19410212 | 18
19410213 | 247
19410214 | 10
19410215 | 0
19410216 | 132
19410217 | 65
19410218 | 25
19410219 | 32
19410220 | 108
19410221 | 130
19410222 | 11
19410223 | 38
19410224 | 8
19410225 | 5
19410226 | 235
19410227 | 76
19410228 | 56
19410301 | 113
19410302 | 21
19410303 | 48
19410304 | 9
19410305 | 4
19410306 | 2
19410307 | 1
19410308 | 2
19410309 | 0
19410310 | 3
19410311 | 33
19410312 | 1
19410313 | 0
19410314 | 0
19410315 | 0
19410316 | 0
19410317 | 53
19410318 | 12
19410319 | 0
19410320 | 0
19410321 | 14
19410322 | 7
19410323 | 111
19410324 | 58
19410325 | 69
19410326 | 87
19410327 | 5
19410328 | 101
19410329 | 0
19410330 | 293
19410331 | 34
19410401 | 87
19410402 | 47
19410403 | 10
19410404 | 0
19410405 | 0
19410406 | 0
19410407 | 5
19410408 | 5
19410409 | 7
19410410 | 0
19410411 | 8
19410412 | 4
19410413 | 103
19410414 | 0
19410415 | 2
19410416 | 88
19410417 | 19
19410418 | 86
19410419 | 37
19410420 | 25
19410421 | 1
19410422 | 3
19410423 | 0
19410424 | 0
19410425 | 0
19410426 | 0
19410427 | 0
19410428 | 0
19410429 | 0
19410430 | 0
19410501 | 0
19410502 | 0
19410503 | 0
19410504 | 0
19410505 | 0
19410506 | 0
19410507 | 0
19410508 | 0
19410509 | 4
19410510 | 0
19410511 | 0
19410512 | 0
19410513 | 28
19410514 | 0
19410515 | 2
19410516 | 3
19410517 | 45
19410518 | 7
19410519 | 0
19410520 | 82
19410521 | 19
19410522 | 270
19410523 | 39
19410524 | 176
19410525 | 23
19410526 | 60
19410527 | 28
19410528 | 36
19410529 | 2
19410530 | 9
19410531 | 1
19410601 | 0
19410602 | 0
19410603 | 37
19410604 | 4
19410605 | 10
19410606 | 0
19410607 | 1
19410608 | 4
19410609 | 0
19410610 | 0
19410611 | 4
19410612 | 0
19410613 | 6
19410614 | 7
19410615 | 3
19410616 | 6
19410617 | 10
19410618 | 1
19410619 | 1
19410620 | 4
19410621 | 6
19410622 | 43
19410623 | 0
19410624 | 55
19410625 | 5
19410626 | 0
19410627 | 2
19410628 | 0
19410629 | 1
19410630 | 3
19410701 | 0
19410702 | 98
19410703 | 1
19410704 | 53
19410705 | 1
19410706 | 221
19410707 | 0
19410708 | 18
19410709 | 72
19410710 | 115
19410711 | 0
19410712 | 0
19410713 | 0
19410714 | 8
19410715 | 3
19410716 | 25
19410717 | 2
19410718 | 78
19410719 | 0
19410720 | 0
19410721 | 0
19410722 | 0
19410723 | 0
19410724 | 65
19410725 | 1
19410726 | 2
19410727 | 8
19410728 | 14
19410729 | 6
19410730 | 7
19410731 | 0
19410801 | 0
19410802 | 0
19410803 | 84
19410804 | 8
19410805 | 18
19410806 | 75
19410807 | 228
19410808 | 107
19410809 | 22
19410810 | 31
19410811 | 9
19410812 | 37
19410813 | 9
19410814 | 2
19410815 | 2
19410816 | 85
19410817 | 5
19410818 | 34
19410819 | 9
19410820 | 17
19410821 | 1
19410822 | 0
19410823 | 1
19410824 | 2
19410825 | 13
19410826 | 108
19410827 | 88
19410828 | 13
19410829 | 0
19410830 | 2
19410831 | 2
19410901 | 50
19410902 | 0
19410903 | 0
19410904 | 4
19410905 | 28
19410906 | 2
19410907 | 6
19410908 | 2
19410909 | 1
19410910 | 0
19410911 | 1
19410912 | 1
19410913 | 3
19410914 | 0
19410915 | 0
19410916 | 0
19410917 | 0
19410918 | 2
19410919 | 0
19410920 | 0
19410921 | 0
19410922 | 0
19410923 | 36
19410924 | 39
19410925 | 316
19410926 | 5
19410927 | 87
19410928 | 113
19410929 | 69
19410930 | 0
19411001 | 0
19411002 | 2
19411003 | 0
19411004 | 0
19411005 | 0
19411006 | 17
19411007 | 41
19411008 | 98
19411009 | 87
19411010 | 55
19411011 | 0
19411012 | 270
19411013 | 33
19411014 | 13
19411015 | 51
19411016 | 10
19411017 | 64
19411018 | 47
19411019 | 7
19411020 | 0
19411021 | 1
19411022 | 1
19411023 | 0
19411024 | 1
19411025 | 0
19411026 | 0
19411027 | 0
19411028 | 2
19411029 | 12
19411030 | 60
19411031 | 10
19411101 | 1
19411102 | 0
19411103 | 0
19411104 | 0
19411105 | 6
19411106 | 9
19411107 | 2
19411108 | 337
19411109 | 453
19411110 | 125
19411111 | 11
19411112 | 0
19411113 | 39
19411114 | 1
19411115 | 110
19411116 | 168
19411117 | 45
19411118 | 1
19411119 | 29
19411120 | 58
19411121 | 204
19411122 | 58
19411123 | 159
19411124 | 77
19411125 | 3
19411126 | 299
19411127 | 25
19411128 | 1
19411129 | 2
19411130 | 144
19411201 | 22
19411202 | 0
19411203 | 14
19411204 | 185
19411205 | 60
19411206 | 99
19411207 | 14
19411208 | 10
19411209 | 17
19411210 | 48
19411211 | 18
19411212 | 23
19411213 | 187
19411214 | 116
19411215 | 17
19411216 | 20
19411217 | 0
19411218 | 9
19411219 | 22
19411220 | 3
19411221 | 8
19411222 | 0
19411223 | 2
19411224 | 0
19411225 | 8
19411226 | 10
19411227 | 24
19411228 | 0
19411229 | 0
19411230 | 0
19411231 | 1
19420101 | 16
19420102 | 151
19420103 | 63
19420104 | 34
19420105 | 8
19420106 | 9
19420107 | 4
19420108 | 13
19420109 | 11
19420110 | 1
19420111 | 208
19420112 | 156
19420113 | 109
19420114 | 36
19420115 | 305
19420116 | 1
19420117 | 81
19420118 | 220
19420119 | 73
19420120 | 18
19420121 | 267
19420122 | 276
19420123 | 27
19420124 | 40
19420125 | 16
19420126 | 86
19420127 | 65
19420128 | 60
19420129 | 43
19420130 | 8
19420131 | 21
19420201 | 7
19420202 | 4
19420203 | 3
19420204 | 0
19420205 | 10
19420206 | 11
19420207 | 0
19420208 | 2
19420209 | 8
19420210 | 6
19420211 | 14
19420212 | 54
19420213 | 0
19420214 | 0
19420215 | 0
19420216 | 0
19420217 | 0
19420218 | 0
19420219 | 0
19420220 | 0
19420221 | 0
19420222 | 1
19420223 | 1
19420224 | 6
19420225 | 6
19420226 | 43
19420227 | 179
19420228 | 94
19420301 | 15
19420302 | 240
19420303 | 60
19420304 | 79
19420305 | 4
19420306 | 1
19420307 | 160
19420308 | 73
19420309 | 5
19420310 | 83
19420311 | 71
19420312 | 0
19420313 | 35
19420314 | 51
19420315 | 193
19420316 | 26
19420317 | 2
19420318 | 27
19420319 | 6
19420320 | 0
19420321 | 0
19420322 | 0
19420323 | 1
19420324 | 0
19420325 | 0
19420326 | 0
19420327 | 0
19420328 | 2
19420329 | 88
19420330 | 156
19420331 | 117
19420401 | 4
19420402 | 118
19420403 | 60
19420404 | 162
19420405 | 127
19420406 | 124
19420407 | 33
19420408 | 119
19420409 | 14
19420410 | 5
19420411 | 76
19420412 | 73
19420413 | 0
19420414 | 0
19420415 | 0
19420416 | 0
19420417 | 0
19420418 | 2
19420419 | 0
19420420 | 0
19420421 | 3
19420422 | 0
19420423 | 2
19420424 | 0
19420425 | 0
19420426 | 0
19420427 | 0
19420428 | 0
19420429 | 10
19420430 | 0
19420501 | 0
19420502 | 0
19420503 | 0
19420504 | 0
19420505 | 0
19420506 | 0
19420507 | 27
19420508 | 1
19420509 | 0
19420510 | 13
19420511 | 9
19420512 | 65
19420513 | 0
19420514 | 85
19420515 | 64
19420516 | 4
19420517 | 29
19420518 | 64
19420519 | 6
19420520 | 118
19420521 | 40
19420522 | 233
19420523 | 11
19420524 | 109
19420525 | 110
19420526 | 150
19420527 | 121
19420528 | 17
19420529 | 46
19420530 | 0
19420531 | 14
19420601 | 2
19420602 | 0
19420603 | 0
19420604 | 0
19420605 | 0
19420606 | 0
19420607 | 0
19420608 | 2
19420609 | 7
19420610 | 0
19420611 | 0
19420612 | 11
19420613 | 9
19420614 | 37
19420615 | 10
19420616 | 1
19420617 | 7
19420618 | 0
19420619 | 0
19420620 | 0
19420621 | 15
19420622 | 0
19420623 | 1
19420624 | 0
19420625 | 0
19420626 | 0
19420627 | 27
19420628 | 6
19420629 | 0
19420630 | 0
19420701 | 0
19420702 | 153
19420703 | 17
19420704 | 38
19420705 | 46
19420706 | 36
19420707 | 24
19420708 | 2
19420709 | 4
19420710 | 16
19420711 | 17
19420712 | 67
19420713 | 4
19420714 | 1
19420715 | 6
19420716 | 5
19420717 | 1
19420718 | 1
19420719 | 2
19420720 | 1
19420721 | 4
19420722 | 4
19420723 | 33
19420724 | 38
19420725 | 8
19420726 | 90
19420727 | 1
19420728 | 56
19420729 | 1
19420730 | 5
19420731 | 62
19420801 | 43
19420802 | 5
19420803 | 0
19420804 | 0
19420805 | 0
19420806 | 69
19420807 | 180
19420808 | 11
19420809 | 83
19420810 | 18
19420811 | 32
19420812 | 25
19420813 | 1
19420814 | 63
19420815 | 4
19420816 | 0
19420817 | 6
19420818 | 203
19420819 | 20
19420820 | 49
19420821 | 68
19420822 | 1
19420823 | 44
19420824 | 142
19420825 | 6
19420826 | 0
19420827 | 1
19420828 | 56
19420829 | 5
19420830 | 2
19420831 | 22
19420901 | 35
19420902 | 82
19420903 | 26
19420904 | 184
19420905 | 5
19420906 | 5
19420907 | 37
19420908 | 15
19420909 | 1
19420910 | 0
19420911 | 0
19420912 | 0
19420913 | 0
19420914 | 1
19420915 | 9
19420916 | 6
19420917 | 8
19420918 | 10
19420919 | 34
19420920 | 76
19420921 | 28
19420922 | 9
19420923 | 127
19420924 | 22
19420925 | 15
19420926 | 137
19420927 | 31
19420928 | 25
19420929 | 125
19420930 | 48
19421001 | 1
19421002 | 1
19421003 | 4
19421004 | 89
19421005 | 0
19421006 | 0
19421007 | 48
19421008 | 9
19421009 | 77
19421010 | 2
19421011 | 32
19421012 | 1
19421013 | 66
19421014 | 11
19421015 | 0
19421016 | 17
19421017 | 3
19421018 | 0
19421019 | 111
19421020 | 48
19421021 | 24
19421022 | 45
19421023 | 55
19421024 | 56
19421025 | 32
19421026 | 41
19421027 | 9
19421028 | 0
19421029 | 0
19421030 | 0
19421031 | 0
19421101 | 0
19421102 | 0
19421103 | 0
19421104 | 21
19421105 | 4
19421106 | 72
19421107 | 7
19421108 | 0
19421109 | 102
19421110 | 0
19421111 | 14
19421112 | 47
19421113 | 1
19421114 | 1
19421115 | 0
19421116 | 0
19421117 | 0
19421118 | 0
19421119 | 0
19421120 | 0
19421121 | 0
19421122 | 0
19421123 | 0
19421124 | 0
19421125 | 0
19421126 | 0
19421127 | 0
19421128 | 4
19421129 | 8
19421130 | 27
19421201 | 0
19421202 | 25
19421203 | 7
19421204 | 113
19421205 | 10
19421206 | 13
19421207 | 33
19421208 | 53
19421209 | 145
19421210 | 118
19421211 | 6
19421212 | 164
19421213 | 15
19421214 | 71
19421215 | 169
19421216 | 81
19421217 | 13
19421218 | 138
19421219 | 0
19421220 | 150
19421221 | 11
19421222 | 1
19421223 | 109
19421224 | 0
19421225 | 20
19421226 | 26
19421227 | 19
19421228 | 37
19421229 | 12
19421230 | 48
19421231 | 37
19430101 | 25
19430102 | 5
19430103 | 112
19430104 | 39
19430105 | 62
19430106 | 24