Spreadsheet: 801286d1666164124-formulate-unorganised-data-into-organised-one-portal-data1_v2
Sheet: Original Data

Big Bash League
28 Jan 2022 - Play Offs |  |  |  | 1 | 2
 |  |  |  |  |  |  | 0
16:40:00 | [NAME] - Sydney Sixers |  | 171:92 | 1.45 | 2.82 |  | [NAME] - Sydney Sixers
26 Jan 2022 - Play Offs |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:25:00 | [NAME] |  | 170:167 | 2.2 | 1.69 |  | [NAME]
21 Jan 2022 - Play Offs |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - [NAME] |  | 188:166 | 1.76 | 2.05 |  | Adelaide Strikers - [NAME]
2022-01-19 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:50:00 | [NAME] |  | 273:167 | 1.75 | 2.06 |  | [NAME]
13:10:00 | [NAME] Melbourne Renegades |  | 170:169 | 1.34 | 3.2 |  | [NAME] Melbourne Renegades
10:05:00 | [NAME] |  | 151:178 | 2.27 | 1.62 |  | [NAME]
2022-01-18 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - Melbourne Renegades |  | 182:176 | 1.44 | 2.78 |  | [NAME] - Melbourne Renegades
2022-01-17 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
17:15:00 | [NAME] |  | 155:156 | 2.65 | 1.48 |  | [NAME]
14:05:00 | Adelaide Strikers - Sydney Sixers |  | 165:161 | 2.42 | 1.56 |  | Adelaide Strikers - Sydney Sixers
2022-01-16 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 150:149 | 1.56 | 2.43 |  | [NAME]
2022-01-15 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
15:40:00 | [NAME] |  | 197:137 | 2.06 | 1.77 |  | [NAME]
07:40:00 | Adelaide Strikers - Melbourne Stars |  | 155:132 | 2.49 | 1.54 |  | Adelaide Strikers - Melbourne Stars
2022-01-14 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
07:40:00 | Adelaide Strikers - Perth Scorchers |  | 130:127 | 2.43 | 1.56 |  | Adelaide Strikers - Perth Scorchers
2022-01-13 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:35:00 | [NAME] - Melbourne Stars |  | 122:123 | 2.35 | 1.57 |  | [NAME] - Melbourne Stars
12:45:00 | [NAME][NAME] |  | 168:177 | 1.68 | 2.19 |  | [NAME][NAME]
2022-01-12 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 90:161 | 1.83 | 1.98 |  | [NAME]
2022-01-11 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - [NAME] |  | 105:150 | 2.11 | 1.73 |  | [NAME] - [NAME]
11:10:00 | [NAME] - Melbourne Stars |  | 196:149 | 1.97 | 1.78 |  | [NAME] - Melbourne Stars
2022-01-10 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 140:139 | 1.71 | 2.15 |  | [NAME]
11:10:00 | [NAME][NAME] |  | 139:140 | 2.3 | 1.62 |  | [NAME][NAME]
2022-01-09 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME][NAME] |  | 151:152 | 1.89 | 1.93 |  | [NAME][NAME]
2022-01-08 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
17:30:00 | [NAME][NAME] |  | 144:145 | 4.28 | 1.23 |  | [NAME][NAME]
15:05:00 | [NAME] - [NAME] |  | 80:209 | 2.12 | 1.73 |  | [NAME] - [NAME]
2022-01-06 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
18:15:00 | [NAME][NAME] |  | 133:137 | 2.06 | 1.77 |  | [NAME][NAME]
15:05:00 | Melbourne Renegades - Brisbane Heat |  | 129:128 | 1.25 | 4.01 |  | Melbourne Renegades - Brisbane Heat
2022-01-05 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - [NAME] |  | 129:126 | 2.15 | 1.71 |  | Adelaide Strikers - [NAME]
2022-01-04 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - Sydney Sixers |  | 143:133 | 2.17 | 1.68 |  | [NAME] - Sydney Sixers
2022-01-03 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME]Melbourne Renegades |  | 126:129 | 2.76 | 1.44 |  | [NAME]Melbourne Renegades
2022-01-02 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 172:144 | 1.85 | 1.97 |  | [NAME]
12:30:00 | [NAME] |  | 130:180 | 3.03 | 1.4 |  | [NAME]
2022-01-01 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:30:00 | [NAME] |  | abn. | 1.4 | 2.99 |  | [NAME]
13:00:00 | [NAME] |  | 136:150 | 1.53 | 2.5 |  | [NAME]
2021-12-31 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - [NAME] |  | 165:187 | 1.72 | 2.1 |  | Adelaide Strikers - [NAME]
2021-12-29 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - [NAME] |  | 121:206 | 2.22 | 1.67 |  | [NAME] - [NAME]
15:05:00 | [NAME] |  | 106:105 | 1.59 | 2.36 |  | [NAME]
2021-12-28 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 200:166 | 2.35 | 1.59 |  | [NAME]
2021-12-27 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
18:05:00 | [NAME]Melbourne Stars |  | 187:207 | 2.21 | 1.66 |  | [NAME]Melbourne Stars
15:05:00 | [NAME] - Adelaide Strikers |  | 176:175 | 1.61 | 2.27 |  | [NAME] - Adelaide Strikers
2021-12-26 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
18:15:00 | [NAME] - Melbourne Renegades |  | 152:151 | 1.43 | 2.86 |  | [NAME] - Melbourne Renegades
15:05:00 | [NAME] |  | 142:168 | 1.89 | 1.93 |  | [NAME]
2021-12-24 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
12:30:00 | [NAME] - Melbourne Stars |  | 180:156 | 2.15 | 1.7 |  | [NAME] - Melbourne Stars
2021-12-23 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - Brisbane Heat |  | 169:208 | 1.66 | 2.22 |  | Adelaide Strikers - Brisbane Heat
[NAME] |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:40:00 | [NAME] |  | 188:161 | 2.1 | 1.74 |  | [NAME]
04 Feb 2021 - Play Offs |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:40:00 | [NAME] |  | 189:150 | 1.79 | 1.94 |  | [NAME]
31 Jan 2021 - Play Offs |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 162:158 | 2.09 | 1.72 |  | [NAME]
30 Jan 2021 - Play Offs |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 168:167 | 2.02 | 1.79 |  | [NAME]
29 Jan 2021 - Play Offs |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 131:130 | 1.79 | 2.02 |  | [NAME]
2021-01-26 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:30:00 | [NAME] |  | 177:180 | 1.94 | 1.86 |  | [NAME]
12:50:00 | Melbourne Renegades - [NAME] |  | 150:139 | 2.42 | 1.55 |  | Melbourne Renegades - [NAME]
09:30:00 | [NAME] |  | 181:175 | 2.27 | 1.63 |  | [NAME]
2021-01-25 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - [NAME] |  | 115:116 | 2.34 | 1.67 |  | Adelaide Strikers - [NAME]
2021-01-24 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME][NAME] |  | 181:188 | 1.74 | 2.09 |  | [NAME][NAME]
13:05:00 | [NAME] |  | 153:159 | 1.73 | 2.1 |  | [NAME]
2021-01-23 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 171:182 | 2.04 | 1.76 |  | [NAME]
13:05:00 | [NAME] - Brisbane Heat |  | 147:173 | 2.16 | 1.69 |  | [NAME] - Brisbane Heat
2021-01-22 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME][NAME] |  | 186:232 | 1.79 | 2.01 |  | [NAME][NAME]
13:05:00 | [NAME] |  | 157:179 | 2.04 | 1.77 |  | [NAME]
2021-01-21 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - Brisbane Heat |  | 197:115 | 2.01 | 1.77 |  | Adelaide Strikers - Brisbane Heat
2021-01-20 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Melbourne Renegades - Melbourne Stars |  | 160:158 | 2.54 | 1.51 |  | Melbourne Renegades - Melbourne Stars
2021-01-19 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 174:115 | 1.67 | 2.2 |  | [NAME]
2021-01-18 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME][NAME] |  | 177:181 | 1.73 | 2.1 |  | [NAME][NAME]
2021-01-17 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 153:150 | 1.51 | 2.55 |  | [NAME]
2021-01-16 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
15:40:00 | [NAME] |  | 164:163 | 2.03 | 1.78 |  | [NAME]
2021-01-15 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 179:68 | 1.64 | 2.24 |  | [NAME]
2021-01-14 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 150:149 | 1.65 | 2.25 |  | [NAME]
2021-01-13 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 166:132 | 1.71 | 2.13 |  | [NAME]
2021-01-12 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - [NAME] |  | 140:139 | 1.7 | 2.14 |  | [NAME] - [NAME]
2021-01-11 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - Melbourne Stars |  | 150:149 | 1.96 | 1.83 |  | Adelaide Strikers - Melbourne Stars
2021-01-10 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 152:148 | 2.02 | 1.79 |  | [NAME]
2021-01-09 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - [NAME] |  | 185:168 | 1.71 | 2.13 |  | [NAME] - [NAME]
2021-01-08 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
15:10:00 | Adelaide Strikers - Melbourne Renegades |  | 177:178 | 1.59 | 2.34 |  | Adelaide Strikers - Melbourne Renegades
2021-01-07 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
18:20:00 | [NAME] |  | [NAME] | 2.14 | 1.7 |  | [NAME]
15:10:00 | [NAME][NAME] |  | 128:167 | 1.88 | 1.93 |  | [NAME][NAME]
2021-01-06 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - Sydney Sixers |  | 183:97 | 1.75 | 2.07 |  | [NAME] - Sydney Sixers
2021-01-05 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Melbourne Renegades - Adelaide Strikers |  | 111:171 | 2.27 | 1.63 |  | Melbourne Renegades - Adelaide Strikers
2021-01-04 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 175:174 | 2.13 | 1.73 |  | [NAME]
13:05:00 | [NAME] |  | 183:173 | 2 | 1.8 |  | [NAME]
2021-01-03 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - [NAME] |  | 150:151 | 2.02 | 1.82 |  | Adelaide Strikers - [NAME]
13:05:00 | [NAME] - Melbourne Renegades |  | 185:89 | 1.68 | 2.19 |  | [NAME] - Melbourne Renegades
2021-01-02 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
17:15:00 | [NAME] |  | 171:165 | 2.13 | 1.7 |  | [NAME]
14:05:00 | [NAME] - Melbourne Stars |  | 164:143 | 1.87 | 1.92 |  | [NAME] - Melbourne Stars
2021-01-01 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - [NAME] |  | 166:117 | 2.21 | 1.66 |  | [NAME] - [NAME]
2020-12-31 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | Adelaide Strikers - [NAME] |  | 146:147 | 1.92 | 1.86 |  | Adelaide Strikers - [NAME]
2020-12-30 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] - Brisbane Heat |  | 150:149 | 1.75 | 2.1 |  | [NAME] - Brisbane Heat
2020-12-29 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 219:144 | 1.97 | 1.83 |  | [NAME]
15:10:00 | [NAME] - [NAME] |  | 168:169 | 2.16 | 1.69 |  | [NAME] - [NAME]
2020-12-28 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 94:165 | 1.62 | 2.28 |  | [NAME]
2020-12-27 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 152:148 | 2.54 | 1.52 |  | [NAME]
2020-12-26 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
18:20:00 | [NAME] |  | 194:193 | 1.87 | 1.92 |  | [NAME]
15:10:00 | [NAME] Melbourne Renegades |  | 209:80 | 1.99 | 1.81 |  | [NAME] Melbourne Renegades
2020-12-23 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 148:150 | 2.04 | 1.76 |  | [NAME]
2020-12-22 00:00:00 |  |  |  | 1 | 2 |  | 0
 |  |  |  |  |  |  | 0
16:15:00 | [NAME] |  | 156:152 | 2.04 | 1.78 |  | [NAME]