Spreadsheet: 801826d1666396287-formulate-unorganised-data-into-organised-one-portal-data1_v3-tms
Sheet: Original Data

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