Spreadsheet: 38386d1236554335-referencing-weekly-data-from-large-raw-data-set-reference-1
Sheet: Month

 |  | Lookup Table
 | 1 | January
 | 2 | February
 | 3 | March
 | 4 | April
 | 5 | May
 | 6 | June
 | 7 | July
 | 8 | August
 | 9 | September
 | 10 | October
 | 11 | November
 | 12 | December
 |  |  | 2
 |  |  |  | Month | February
 |  |  |  |  | 1900-01-01 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
 |  |  |  | 2008-02-01 00:00:00 | 32 | 34 | 32 | 33 | 35 | 32 | 34 | 34 | 33 | 34 | 33 | 43 | 121 | 119 | 126 | 133 | 141 | 146 | 156 | 158 | 164 | 162 | 163 | 163 | 162 | 159 | 160 | 156 | 160 | 157 | 156 | 150 | 150 | 145 | 143 | 136 | 134 | 134 | 119 | 90 | 91 | 87 | 76 | 47 | 36 | 36 | 32 | 33
 |  |  |  | 2008-02-02 00:00:00 | 33 | 33 | 34 | 33 | 33 | 34 | 32 | 34 | 33 | 37 | 38 | 37 | 58 | 51 | 54 | 54 | 56 | 58 | 56 | 54 | 56 | 57 | 64 | 70 | 77 | 79 | 77 | 77 | 78 | 77 | 78 | 78 | 71 | 47 | 46 | 45 | 45 | 45 | 46 | 44 | 45 | 46 | 44 | 43 | 35 | 33 | 34 | 34
 |  |  |  | 2008-02-03 00:00:00 | 33 | 34 | 33 | 34 | 34 | 33 | 34 | 32 | 34 | 34 | 33 | 34 | 53 | 46 | 46 | 45 | 46 | 45 | 45 | 46 | 46 | 44 | 46 | 45 | 46 | 45 | 46 | 45 | 47 | 47 | 45 | 45 | 45 | 45 | 43 | 44 | 45 | 43 | 45 | 44 | 45 | 44 | 45 | 43 | 34 | 32 | 32 | 34
 |  |  |  | 2008-02-04 00:00:00 | 32 | 33 | 32 | 32 | 34 | 32 | 33 | 32 | 34 | 33 | 32 | 55 | 116 | 118 | 126 | 135 | 138 | 145 | 158 | 162 | 161 | 161 | 164 | 161 | 158 | 160 | 160 | 162 | 155 | 153 | 154 | 153 | 152 | 147 | 143 | 137 | 134 | 132 | 118 | 90 | 98 | 92 | 80 | 49 | 35 | 33 | 35 | 34
 |  |  |  | 2008-02-05 00:00:00 | 32 | 34 | 32 | 34 | 33 | 32 | 33 | 34 | 33 | 33 | 34 | 42 | 119 | 120 | 123 | 130 | 140 | 148 | 156 | 162 | 163 | 161 | 163 | 159 | 161 | 163 | 163 | 161 | 165 | 163 | 161 | 162 | 161 | 159 | 154 | 146 | 142 | 138 | 123 | 89 | 90 | 90 | 81 | 59 | 44 | 41 | 39 | 40
 |  |  |  | 2008-02-06 00:00:00 | 39 | 40 | 41 | 41 | 40 | 41 | 41 | 40 | 41 | 41 | 41 | 46 | 124 | 122 | 125 | 131 | 147 | 144 | 160 | 167 | 168 | 165 | 162 | 163 | 161 | 164 | 160 | 161 | 160 | 163 | 162 | 162 | 160 | 159 | 156 | 146 | 147 | 140 | 128 | 93 | 91 | 89 | 88 | 61 | 41 | 40 | 40 | 40
 |  |  |  | 2008-02-07 00:00:00 | 40 | 40 | 40 | 41 | 40 | 40 | 40 | 41 | 40 | 40 | 40 | 47 | 125 | 129 | 132 | 137 | 148 | 154 | 162 | 170 | 167 | 165 | 162 | 162 | 166 | 164 | 162 | 156 | 165 | 157 | 157 | 153 | 152 | 148 | 146 | 140 | 138 | 134 | 117 | 87 | 94 | 88 | 78 | 51 | 40 | 39 | 41 | 39
 |  |  |  | 2008-02-08 00:00:00 | 38 | 39 | 39 | 39 | 39 | 39 | 40 | 39 | 40 | 39 | 39 | 50 | 125 | 128 | 132 | 136 | 145 | 154 | 160 | 163 | 164 | 167 | 166 | 163 | 160 | 162 | 159 | 157 | 163 | 154 | 157 | 152 | 149 | 148 | 146 | 138 | 136 | 132 | 118 | 84 | 83 | 82 | 77 | 54 | 45 | 36 | 35 | 34
 |  |  |  | 2008-02-09 00:00:00 | 34 | 35 | 34 | 35 | 36 | 35 | 34 | 34 | 35 | 35 | 34 | 35 | 55 | 48 | 48 | 49 | 49 | 50 | 51 | 58 | 61 | 65 | 67 | 68 | 69 | 68 | 71 | 70 | 71 | 70 | 70 | 67 | 47 | 47 | 45 | 45 | 45 | 45 | 44 | 45 | 44 | 45 | 44 | 44 | 33 | 33 | 33 | 33
 |  |  |  | 2008-02-10 00:00:00 | 32 | 33 | 34 | 32 | 33 | 33 | 33 | 32 | 34 | 32 | 33 | 34 | 52 | 46 | 47 | 51 | 52 | 49 | 52 | 52 | 52 | 52 | 52 | 53 | 52 | 53 | 51 | 53 | 54 | 54 | 49 | 48 | 46 | 45 | 46 | 45 | 44 | 45 | 45 | 45 | 46 | 45 | 44 | 44 | 33 | 35 | 33 | 34
 |  |  |  | 2008-02-11 00:00:00 | 33 | 32 | 33 | 34 | 33 | 34 | 33 | 33 | 34 | 32 | 34 | 56 | 120 | 114 | 125 | 132 | 142 | 145 | 152 | 159 | 161 | 158 | 157 | 163 | 158 | 159 | 158 | 159 | 159 | 159 | 153 | 153 | 151 | 148 | 147 | 142 | 138 | 135 | 119 | 91 | 91 | 89 | 77 | 48 | 35 | 35 | 34 | 34
 |  |  |  | 2008-02-12 00:00:00 | 34 | 34 | 34 | 34 | 34 | 36 | 33 | 36 | 34 | 34 | 35 | 50 | 112 | 121 | 129 | 134 | 148 | 151 | 162 | 167 | 165 | 167 | 166 | 163 | 164 | 163 | 161 | 161 | 160 | 165 | 167 | 166 | 163 | 158 | 161 | 153 | 153 | 149 | 143 | 138 | 136 | 133 | 128 | 111 | 47 | 35 | 35 | 35
 |  |  |  | 2008-02-13 00:00:00 | 34 | 35 | 35 | 34 | 35 | 35 | 36 | 35 | 35 | 34 | 36 | 51 | 129 | 127 | 133 | 134 | 150 | 152 | 161 | 165 | 163 | 162 | 167 | 166 | 168 | 166 | 165 | 166 | 156 | 158 | 159 | 158 | 159 | 154 | 155 | 146 | 143 | 128 | 95 | 90 | 89 | 87 | 88 | 74 | 38 | 35 | 35 | 36
 |  |  |  | 2008-02-14 00:00:00 | 35 | 34 | 36 | 34 | 35 | 35 | 36 | 35 | 34 | 36 | 34 | 53 | 130 | 125 | 134 | 140 | 146 | 156 | 164 | 168 | 166 | 163 | 164 | 164 | 157 | 158 | 159 | 157 | 157 | 162 | 160 | 157 | 156 | 156 | 158 | 149 | 143 | 132 | 95 | 91 | 91 | 92 | 86 | 62 | 38 | 36 | 38 | 35
 |  |  |  | 2008-02-15 00:00:00 | 36 | 36 | 37 | 36 | 35 | 37 | 36 | 38 | 35 | 38 | 36 | 46 | 129 | 124 | 133 | 138 | 141 | 148 | 155 | 161 | 157 | 161 | 156 | 154 | 152 | 150 | 147 | 146 | 150 | 153 | 152 | 152 | 148 | 151 | 147 | 141 | 139 | 128 | 96 | 92 | 91 | 89 | 86 | 72 | 47 | 47 | 41 | 39
 |  |  |  | 2008-02-16 00:00:00 | 39 | 41 | 38 | 41 | 41 | 39 | 39 | 40 | 39 | 40 | 40 | 39 | 60 | 53 | 60 | 58 | 61 | 63 | 62 | 63 | 61 | 60 | 62 | 61 | 60 | 60 | 59 | 60 | 61 | 59 | 60 | 59 | 58 | 58 | 49 | 45 | 47 | 44 | 49 | 50 | 50 | 51 | 49 | 49 | 39 | 39 | 38 | 39
 |  |  |  | 2008-02-17 00:00:00 | 38 | 37 | 40 | 38 | 39 | 38 | 39 | 39 | 38 | 39 | 39 | 38 | 59 | 56 | 59 | 58 | 58 | 57 | 59 | 53 | 53 | 48 | 51 | 52 | 53 | 51 | 50 | 49 | 50 | 50 | 51 | 46 | 45 | 46 | 46 | 45 | 45 | 44 | 45 | 46 | 45 | 45 | 45 | 43 | 34 | 34 | 37 | 39
 |  |  |  | 2008-02-18 00:00:00 | 37 | 39 | 38 | 38 | 38 | 39 | 38 | 39 | 38 | 39 | 39 | 51 | 116 | 123 | 128 | 137 | 151 | 156 | 158 | 163 | 166 | 169 | 168 | 165 | 166 | 165 | 163 | 161 | 166 | 164 | 162 | 160 | 159 | 158 | 155 | 147 | 145 | 132 | 96 | 94 | 93 | 91 | 84 | 50 | 37 | 36 | 36 | 35
 |  |  |  | 2008-02-19 00:00:00 | 34 | 36 | 35 | 36 | 36 | 36 | 35 | 36 | 36 | 36 | 36 | 55 | 118 | 119 | 127 | 146 | 157 | 161 | 169 | 170 | 169 | 168 | 168 | 168 | 166 | 168 | 169 | 165 | 165 | 165 | 163 | 164 | 162 | 157 | 152 | 145 | 140 | 128 | 99 | 96 | 92 | 92 | 78 | 45 | 35 | 34 | 36 | 36
 |  |  |  | 2008-02-20 00:00:00 | 34 | 34 | 35 | 34 | 36 | 34 | 35 | 35 | 35 | 35 | 35 | 52 | 123 | 121 | 129 | 142 | 152 | 155 | 163 | 167 | 165 | 162 | 163 | 163 | 163 | 164 | 163 | 158 | 159 | 158 | 157 | 155 | 154 | 153 | 151 | 144 | 144 | 128 | 97 | 92 | 91 | 90 | 88 | 62 | 42 | 42 | 40 | 42
 |  |  |  | 2008-02-21 00:00:00 | 40 | 41 | 40 | 41 | 41 | 41 | 41 | 43 | 41 | 41 | 42 | 59 | 133 | 124 | 129 | 135 | 147 | 149 | 158 | 161 | 164 | 165 | 164 | 169 | 164 | 163 | 162 | 157 | 164 | 161 | 161 | 155 | 154 | 150 | 145 | 140 | 136 | 123 | 91 | 92 | 92 | 88 | 72 | 43 | 35 | 35 | 35 | 35
 |  |  |  | 2008-02-22 00:00:00 | 33 | 35 | 33 | 35 | 34 | 34 | 35 | 34 | 35 | 34 | 34 | 49 | 120 | 125 | 129 | 136 | 147 | 154 | 159 | 165 | 163 | 162 | 161 | 160 | 160 | 157 | 159 | 151 | 156 | 157 | 159 | 161 | 155 | 150 | 148 | 141 | 140 | 124 | 92 | 88 | 85 | 83 | 73 | 54 | 42 | 40 | 39 | 40
 |  |  |  | 2008-02-23 00:00:00 | 38 | 40 | 38 | 40 | 39 | 38 | 40 | 39 | 39 | 39 | 38 | 39 | 59 | 52 | 47 | 47 | 53 | 55 | 55 | 58 | 66 | 67 | 65 | 68 | 70 | 70 | 68 | 68 | 66 | 67 | 66 | 67 | 65 | 58 | 46 | 45 | 46 | 45 | 46 | 46 | 45 | 45 | 46 | 43 | 34 | 34 | 34 | 33
 |  |  |  | 2008-02-24 00:00:00 | 33 | 34 | 34 | 34 | 33 | 33 | 34 | 33 | 33 | 34 | 34 | 33 | 54 | 47 | 46 | 47 | 46 | 47 | 45 | 46 | 46 | 45 | 45 | 45 | 45 | 47 | 46 | 46 | 48 | 46 | 48 | 45 | 46 | 46 | 46 | 44 | 46 | 45 | 45 | 45 | 44 | 45 | 44 | 44 | 34 | 34 | 33 | 34
 |  |  |  | 2008-02-25 00:00:00 | 33 | 33 | 33 | 34 | 33 | 35 | 33 | 34 | 33 | 34 | 34 | 61 | 123 | 118 | 125 | 138 | 149 | 148 | 158 | 159 | 163 | 159 | 159 | 161 | 155 | 156 | 153 | 151 | 153 | 158 | 155 | 154 | 152 | 149 | 146 | 138 | 138 | 125 | 92 | 92 | 91 | 87 | 81 | 52 | 35 | 34 | 34 | 34
 |  |  |  | 2008-02-26 00:00:00 | 33 | 33 | 35 | 33 | 34 | 34 | 34 | 33 | 34 | 34 | 34 | 45 | 110 | 119 | 124 | 135 | 151 | 154 | 161 | 167 | 168 | 167 | 162 | 163 | 162 | 158 | 160 | 162 | 164 | 166 | 164 | 163 | 162 | 156 | 154 | 147 | 143 | 128 | 93 | 90 | 89 | 86 | 86 | 59 | 35 | 34 | 34 | 34
 |  |  |  | 2008-02-27 00:00:00 | 34 | 34 | 33 | 34 | 34 | 34 | 34 | 34 | 34 | 34 | 34 | 53 | 132 | 130 | 133 | 140 | 151 | 154 | 159 | 166 | 168 | 166 | 166 | 159 | 162 | 159 | 161 | 160 | 165 | 161 | 162 | 161 | 158 | 157 | 152 | 146 | 142 | 125 | 88 | 85 | 84 | 86 | 77 | 61 | 36 | 35 | 35 | 34
 |  |  |  | 2008-02-28 00:00:00 | 34 | 34 | 34 | 35 | 34 | 34 | 35 | 34 | 34 | 34 | 35 | 45 | 115 | 129 | 129 | 134 | 140 | 149 | 154 | 162 | 164 | 163 | 163 | 164 | 162 | 164 | 162 | 156 | 160 | 158 | 159 | 162 | 159 | 159 | 155 | 146 | 144 | 130 | 96 | 92 | 92 | 85 | 81 | 67 | 46 | 39 | 35 | 36
 |  |  |  | 2008-02-29 00:00:00 | 34 | 35 | 35 | 34 | 35 | 34 | 35 | 34 | 35 | 35 | 34 | 44 | 132 | 132 | 133 | 134 | 143 | 154 | 160 | 160 | 160 | 161 | 159 | 160 | 158 | 157 | 162 | 156 | 157 | 157 | 156 | 157 | 158 | 152 | 155 | 144 | 146 | 127 | 96 | 93 | 91 | 88 | 85 | 61 | 39 | 37 | 36 | 37