Spreadsheet: 104578d1302123991-count-consecutive-repeating-numbers-in-one-column-sample12
Sheet: Sheet1

 |  |  |  |  | Artificial Data | Artifical Delta -1 | Actual Data Change Increase/Decrease |  | 1 | 2 |  | "Runs" |  | Decreases |  | Increases
 |  |  |  | 1 | 9
 |  |  |  | 2 | 10 | 1
 |  |  |  | 3 | 4 | -6 |  |  |  |  |  | 2
 |  |  |  | 4 | 15 | 11 |  |  |  |  |  | 3
 |  |  |  | 5 | 6 | -9
 |  |  |  | 6 | 4 | -2
 |  |  |  | 7 | 3 | -1
 |  |  |  | 8 | 13 | 10
 |  |  |  | 9 | 12 | -1
 |  |  |  | 10 | 1 | -11
 |  |  |  | 11 | 3 | 2
 |  |  |  | 12 | 4 | 1
 |  |  |  | 13 | 15 | 11
 |  |  |  | 14 | 13 | -2
 |  |  |  | 15 | 1 | -12
 |  |  |  | 16 | 4 | 3
 |  |  |  | 17 | 8 | 4
 |  |  |  | 18 | 13 | 5
 |  |  |  | 19 | 4 | -9
 |  |  |  | 20 | 2 | -2
 |  |  |  | 21 | 12 | 10
 |  |  |  | 22 | 9 | -3
 |  |  |  | 23 | 12 | 3
 |  |  |  | 24 | 1 | -11
 |  |  |  | 25 | 4 | 3
 |  |  |  | 26 | 14 | 10
 |  |  |  | 27 | 1 | -13
 |  |  |  | 28 | 15 | 14
 |  |  |  | 29 | 6 | -9
 |  |  |  | 30 | 11 | 5
 |  |  |  | 31 | 12 | 1
 |  |  |  | 32 | 8 | -4
 |  |  |  | 33 | 14 | 6
 |  |  |  | 34 | 11 | -3
 |  |  |  | 35 | 2 | -9
 |  |  |  | 36 | 15 | 13
 |  |  |  | 37 | 11 | -4
 |  |  |  | 38 | 8 | -3
 |  |  |  | 39 | 4 | -4
 |  |  |  | 40 | 8 | 4
 |  |  |  | 41 | 15 | 7
 |  |  |  | 42 | 14 | -1
 |  |  |  | 43 | 12 | -2
 |  |  |  | 44 | 5 | -7
 |  |  |  | 45 | 12 | 7
 |  |  |  | 46 | 10 | -2
 |  |  |  | 47 | 9 | -1
 |  |  |  | 48 | 15 | 6
 |  |  |  | 49 | 12 | -3
 |  |  |  | 50 | 13 | 1
 |  |  |  | 51 | 2 | -11
 |  |  |  | 52 | 6 | 4
 |  |  |  | 53 | 13 | 7
 |  |  |  | 54 | 9 | -4
 |  |  |  | 55 | 5 | -4
 |  |  |  | 56 | 15 | 10
 |  |  |  | 57 | 11 | -4
 |  |  |  | 58 | 14 | 3
 |  |  |  | 59 | 11 | -3
 |  |  |  | 60 | 1 | -10
 |  |  |  | 61 | 7 | 6
 |  |  |  | 62 | 5 | -2
 |  |  |  | 63 | 6 | 1
 |  |  |  | 64 | 14 | 8
 |  |  |  | 65 | 8 | -6
 |  |  |  | 66 | 2 | -6
 |  |  |  | 67 | 4 | 2
 |  |  |  | 68 | 5 | 1
 |  |  |  | 69 | 8 | 3
 |  |  |  | 70 | 13 | 5
 |  |  |  | 71 | 2 | -11
 |  |  |  | 72 | 1 | -1
 |  |  |  | 73 | 8 | 7
 |  |  |  | 74 | 12 | 4
 |  |  |  | 75 | 6 | -6
 |  |  |  | 76 | 9 | 3
 |  |  |  | 77 | 15 | 6
 |  |  |  | 78 | 10 | -5
 |  |  |  | 79 | 8 | -2
 |  |  |  | 80 | 9 | 1
 |  |  |  | 81 | 3 | -6
 |  |  |  | 82 | 2 | -1
 |  |  |  | 83 | 9 | 7
 |  |  |  | 84 | 10 | 1
 |  |  |  | 85 | 15 | 5
 |  |  |  | 86 | 10 | -5
 |  |  |  | 87 | 6 | -4
 |  |  |  | 88 | 11 | 5
 |  |  |  | 89 | 2 | -9
 |  |  |  | 90 | 1 | -1
 |  |  |  | 91 | 12 | 11
 |  |  |  | 92 | 9 | -3
 |  |  |  | 93 | 12 | 3
 |  |  |  | 94 | 1 | -11
 |  |  |  | 95 | 8 | 7
 |  |  |  | 96 | 15 | 7
 |  |  |  | 97 | 2 | -13
 |  |  |  | 98 | 8 | 6
 |  |  |  | 99 | 9 | 1
 |  |  |  | 100 | 15 | 6
 |  |  |  | 101 | 14 | -1
 |  |  |  | 102 | 12 | -2
 |  |  |  | 103 | 8 | -4
 |  |  |  | 104 | 10 | 2
 |  |  |  | 105 | 2 | -8
 |  |  |  | 106 | 13 | 11
 |  |  |  | 107 | 1 | -12
 |  |  |  | 108 | 6 | 5
 |  |  |  | 109 | 2 | -4
 |  |  |  | 110 | 9 | 7
 |  |  |  | 111 | 3 | -6
 |  |  |  | 112 | 7 | 4
 |  |  |  | 113 | 1 | -6
 |  |  |  | 114 | 4 | 3
 |  |  |  | 115 | 14 | 10
 |  |  |  | 116 | 8 | -6
 |  |  |  | 117 | 9 | 1
 |  |  |  | 118 | 2 | -7
 |  |  |  | 119 | 8 | 6
 |  |  |  | 120 | 12 | 4
 |  |  |  | 121 | 10 | -2
 |  |  |  | 122 | 1 | -9
 |  |  |  | 123 | 11 | 10
 |  |  |  | 124 | 14 | 3
 |  |  |  | 125 | 12 | -2
 |  |  |  | 126 | 1 | -11
 |  |  |  | 127 | 14 | 13
 |  |  |  | 128 | 4 | -10
 |  |  |  | 129 | 11 | 7
 |  |  |  | 130 | 2 | -9
 |  |  |  | 131 | 9 | 7
 |  |  |  | 132 | 8 | -1
 |  |  |  | 133 | 13 | 5
 |  |  |  | 134 | 9 | -4
 |  |  |  | 135 | 5 | -4
 |  |  |  | 136 | 11 | 6
 |  |  |  | 137 | 12 | 1
 |  |  |  | 138 | 6 | -6
 |  |  |  | 139 | 9 | 3
 |  |  |  | 140 | 5 | -4
 |  |  |  | 141 | 11 | 6
 |  |  |  | 142 | 9 | -2
 |  |  |  | 143 | 3 | -6
 |  |  |  | 144 | 4 | 1
 |  |  |  | 145 | 12 | 8
 |  |  |  | 146 | 13 | 1
 |  |  |  | 147 | 6 | -7
 |  |  |  | 148 | 5 | -1
 |  |  |  | 149 | 15 | 10
 |  |  |  | 150 | 2 | -13
 |  |  |  | 151 | 14 | 12
 |  |  |  | 152 | 1 | -13
 |  |  |  | 153 | 6 | 5
 |  |  |  | 154 | 5 | -1
 |  |  |  | 155 | 11 | 6
 |  |  |  | 156 | 5 | -6
 |  |  |  | 157 | 4 | -1
 |  |  |  | 158 | 8 | 4
 |  |  |  | 159 | 6 | -2
 |  |  |  | 160 | 2 | -4
 |  |  |  | 161 | 5 | 3
 |  |  |  | 162 | 9 | 4
 |  |  |  | 163 | 3 | -6
 |  |  |  | 164 | 1 | -2
 |  |  |  | 165 | 11 | 10
 |  |  |  | 166 | 6 | -5
 |  |  |  | 167 | 11 | 5
 |  |  |  | 168 | 7 | -4
 |  |  |  | 169 | 9 | 2
 |  |  |  | 170 | 3 | -6
 |  |  |  | 171 | 15 | 12
 |  |  |  | 172 | 10 | -5
 |  |  |  | 173 | 12 | 2
 |  |  |  | 174 | 3 | -9
 |  |  |  | 175 | 7 | 4
 |  |  |  | 176 | 6 | -1
 |  |  |  | 177 | 13 | 7
 |  |  |  | 178 | 3 | -10
 |  |  |  | 179 | 1 | -2
 |  |  |  | 180 | 6 | 5
 |  |  |  | 181 | 1 | -5
 |  |  |  | 182 | 9 | 8
 |  |  |  | 183 | 7 | -2
 |  |  |  | 184 | 1 | -6
 |  |  |  | 185 | 6 | 5
 |  |  |  | 186 | 5 | -1
 |  |  |  | 187 | 8 | 3
 |  |  |  | 188 | 12 | 4
 |  |  |  | 189 | 5 | -7
 |  |  |  | 190 | 6 | 1
 |  |  |  | 191 | 8 | 2
 |  |  |  | 192 | 10 | 2
 |  |  |  | 193 | 14 | 4
 |  |  |  | 194 | 13 | -1
 |  |  |  | 195 | 15 | 2
 |  |  |  | 196 | 10 | -5
 |  |  |  | 197 | 11 | 1
 |  |  |  | 198 | 1 | -10
 |  |  |  | 199 | 2 | 1
 |  |  |  | 200 | 6 | 4