Spreadsheet: 818288d1676707244-power-query-calculations-countif-jumpshcaps
Sheet: HH

RaceNo | Date | [NAME] | Age | Weight | sp | Track | Type of Race | [NAME] | Trainer | Nor_1 | TF NoQ | TF AE | TPos | TNeg | Network | Rank | Round | Top Rated | Top Rated2
1-00 | 2023-02-16 00:00:00 | Les's Legacy (GB) | 6 | 151 | 7 | NEWCASTLE (GB) | Hurdle | 44 | [NAME] | 6 | 10 | 0.87 | 1 | 1 | 0.2806097
1-00 | 2023-02-16 00:00:00 | Sheriff Garrett (IRE) | 9 | 162 | 10 | NEWCASTLE (GB) | Hurdle | 12 | [NAME] | 6 | 15 | 1.57 | 2 | 0 | 0.2503965
1-00 | 2023-02-16 00:00:00 | Clear White Light (GB) | 7 | 168 | 3.5 | NEWCASTLE (GB) | Hurdle | 10 | [NAME] | 6 | 7 | 1.89 | 0 | 0 | 0.2358094
1-00 | 2023-02-16 00:00:00 | [NAME] (IRE) | 7 | 165 | 9 | NEWCASTLE (GB) | Hurdle | 35 | [NAME] | 6 | 8 | 0.95 | 2 | 0 | 0.2234077
1-00 | 2023-02-16 00:00:00 | Millarville (IRE) | 10 | 160 | 6.5 | NEWCASTLE (GB) | Hurdle | 49 | [NAME] | 6 | 4 | 0.97 | 1 | 0 | 0.1324148
1-00 | 2023-02-16 00:00:00 | [NAME] (FR) | 8 | 155 | 25 | NEWCASTLE (GB) | Hurdle | 37 | [NAME] | 6 | 10 | 0.61 | 1 | 1 | 0.06765804
1-15 | 2023-02-16 00:00:00 | [NAME] (GB) | 4 | 142 | 2.75 | SANDOWN (GB) | Hurdle | 11 | [NAME] | 10 | 14 | 1.54 | 0 | 0 | 0.3602946
1-15 | 2023-02-16 00:00:00 | Gingerbred (GB) | 5 | 157 | 4.5 | SANDOWN (GB) | Hurdle | 15 | [NAME] | 10 | 15 | 1.15 | 1 | 0 | 0.1238677
1-15 | 2023-02-16 00:00:00 | Jilaijone (FR) | 4 | 153 | 6 | SANDOWN (GB) | Hurdle | 17 | [NAME] | 10 | 15 | 1.23 | 0 | 0 | 0.1221822
1-15 | 2023-02-16 00:00:00 | [NAME] (FR) | 5 | 162 | 5.5 | SANDOWN (GB) | Hurdle | 57 | [NAME] | 10 | 15 | 0.89 | 1 | 0 | 0.116855
1-15 | 2023-02-16 00:00:00 | [NAME] (GB) | 6 | 163 | 4 | SANDOWN (GB) | Hurdle | 46 | [NAME] | 10 | 3 | 0 | 0 | 0 | 0.08989528
1-15 | 2023-02-16 00:00:00 | [NAME]'s The One (GB) | 6 | 154 | 14 | SANDOWN (GB) | Hurdle | 19 | [NAME] | 10 | 4 | 0 | 0 | 0 | 0.08324051
1-15 | 2023-02-16 00:00:00 | Swinging London (IRE) | 5 | 164 | 20 | SANDOWN (GB) | Hurdle | 52 | Olly Murphy | 10 | 15 | 1.44 | 1 | 0 | 0.08179271
1-15 | 2023-02-16 00:00:00 | Kannapolis (IRE) | 8 | 160 | 33 | SANDOWN (GB) | Hurdle | 37 | Toby Lawes | 10 | 3 | 1.27 | 0 | 0 | 0.07081607
1-15 | 2023-02-16 00:00:00 | Ferdinand Star (GB) | 6 | 152 | 40 | SANDOWN (GB) | Hurdle | 14 | [NAME] | 10 | 15 | 1.23 | 0 | 0 | 0.05994707
1-15 | 2023-02-16 00:00:00 | [NAME] (IRE) | 8 | 156 | 20 | SANDOWN (GB) | Hurdle | 19 | [NAME] | 10 | 6 | 0.72 | 2 | 0 | 0.02535373
3-20 | 2023-02-16 00:00:00 | Lone Star (GB) | 6 | 156 | 1.5 | NEWCASTLE (GB) | Hurdle | 2 | [NAME] | 7 | 15 | 1.04 | 2 | 0 | 0.3250499
3-20 | 2023-02-16 00:00:00 | Aazza (IRE) | 7 | 167 | 3 | NEWCASTLE (GB) | Hurdle | 37 | [NAME] | 7 | 8 | 0.41 | 0 | 0 | 0.1942151
3-20 | 2023-02-16 00:00:00 | Silver Coin (IRE) | 6 | 148 | 33 | NEWCASTLE (GB) | Hurdle | 117 | [NAME] | 7 | 5 | 1.73 | 0 | 0 | 0.1282324
3-20 | 2023-02-16 00:00:00 | Noble Affair (IRE) | 7 | 156 | 50 | NEWCASTLE (GB) | Hurdle | 111 | [NAME] | 7 | 0 | 0 | 0 | 2 | 0.1192373
3-20 | 2023-02-16 00:00:00 | Fiadh (IRE) | 7 | 155 | 25 | NEWCASTLE (GB) | Hurdle | 21 | [NAME] | 7 | 7 | 0.91 | 0 | 2 | 0.1109071
3-20 | 2023-02-16 00:00:00 | Shesupincourt (GB) | 6 | 144 | 8 | NEWCASTLE (GB) | Hurdle | 14 | [NAME] | 7 | 8 | 1.04 | 0 | 1 | 0.0952571
3-20 | 2023-02-16 00:00:00 | Nairobi Girl (IRE) | 7 | 142 | 100 | NEWCASTLE (GB) | Hurdle | 38 | [NAME] | 7 | 4 | 0 | 0 | 1 | 0.03668991
4-30 | 2023-02-16 00:00:00 | Ivetwiggedit (GB) | 6 | 142 | 0.73 | NEWCASTLE (GB) | Hurdle | 7 | [NAME] | 10 | 15 | 1.39 | 4 | 0 | 0.422619
4-30 | 2023-02-16 00:00:00 | Burrows Hall (FR) | 6 | 158 | 9 | NEWCASTLE (GB) | Hurdle | 20 | [NAME] | 10 | 15 | 1.2 | 0 | 0 | 0.1710248
4-30 | 2023-02-16 00:00:00 | Bebside Banter (IRE) | 6 | 146 | 8 | NEWCASTLE (GB) | Hurdle | 44 | [NAME] | 10 | 7 | 0.91 | 0 | 0 | 0.1114977
4-30 | 2023-02-16 00:00:00 | [NAME] (IRE) | 6 | 149 | 33 | NEWCASTLE (GB) | Hurdle | 22 | [NAME] | 10 | 1 | 0 | 0 | 0 | 0.1060887
4-30 | 2023-02-16 00:00:00 | Oakmont (FR) | 10 | 159 | 20 | NEWCASTLE (GB) | Hurdle | 98 | [NAME] | 10 | 8 | 0.95 | 1 | 0 | 0.1024911
4-30 | 2023-02-16 00:00:00 | Hungry Tiger (IRE) | 9 | 163 | 20 | NEWCASTLE (GB) | Hurdle | 80 | [NAME] | 10 | 6 | 0.55 | 0 | 1 | 0.0920637
4-30 | 2023-02-16 00:00:00 | Bulls Aye (IRE) | 5 | 142 | 40 | NEWCASTLE (GB) | Hurdle | 44 | Iain Jardine | 10 | 15 | 0.97 | 1 | 1 | 0.09084055
4-30 | 2023-02-16 00:00:00 | Fazayte (FR) | 8 | 168 | 10 | NEWCASTLE (GB) | Hurdle | 19 | [NAME] | 10 | 8 | 1.04 | 0 | 0 | 0.08713594
4-30 | 2023-02-16 00:00:00 | Something Golden (IRE) | 7 | 156 | 25 | NEWCASTLE (GB) | Hurdle | 16 | Iain Jardine | 10 | 15 | 0.97 | 0 | 1 | 0.05640346
4-30 | 2023-02-16 00:00:00 | Licit (IRE) | 6 | 153 | 25 | NEWCASTLE (GB) | Hurdle | 22 | [NAME] | 10 | 15 | 1.57 | 2 | 0 | 0.03511426
4-45 | 2023-02-16 00:00:00 | Inneston (FR) | 5 | 158 | 6.5 | SANDOWN (GB) | Hurdle | 18 | [NAME] | 11 | 15 | 1.54 | 0 | 0 | 0.252974
4-45 | 2023-02-16 00:00:00 | Equinus (IRE) | 5 | 167 | 4 | SANDOWN (GB) | Hurdle | 24 | [NAME] | 11 | 15 | 0.46 | 1 | 0 | 0.2303739
4-45 | 2023-02-16 00:00:00 | [NAME] (GB) | 6 | 166 | 8 | SANDOWN (GB) | Hurdle | 41 | [NAME] | 11 | 15 | 1.4 | 1 | 0 | 0.199989
4-45 | 2023-02-16 00:00:00 | Twin Power (IRE) | 6 | 160 | 5 | SANDOWN (GB) | Hurdle | 12 | [NAME] | 11 | 15 | 0.89 | 0 | 0 | 0.1670073
4-45 | 2023-02-16 00:00:00 | Amrons Sage (IRE) | 6 | 162 | 4 | SANDOWN (GB) | Hurdle | 58 | [NAME] | 11 | 15 | 1.12 | 0 | 0 | 0.1553507
4-45 | 2023-02-16 00:00:00 | Spanish Present (IRE) | 7 | 164 | 14 | SANDOWN (GB) | Hurdle | 52 | [NAME] | 11 | 15 | 1.65 | 2 | 0 | 0.1159454
4-45 | 2023-02-16 00:00:00 | Missed Tee (IRE) | 6 | 160 | 6.5 | SANDOWN (GB) | Hurdle | 31 | [NAME] | 11 | 15 | 0.66 | 0 | 0 | 0.1112067
4-45 | 2023-02-16 00:00:00 | Gaelic Park (IRE) | 7 | 166 | 9 | SANDOWN (GB) | Hurdle | 20 | [NAME] | 11 | 15 | 0.57 | 0 | 0 | 0.09613559
4-45 | 2023-02-16 00:00:00 | [NAME] (FR) | 6 | 156 | 25 | SANDOWN (GB) | Hurdle | 57 | [NAME] | 11 | 8 | 1.18 | 0 | 6 | 0.07857156
4-45 | 2023-02-16 00:00:00 | Sporting [NAME] (IRE) | 6 | 164 | 16 | SANDOWN (GB) | Hurdle | 37 | [NAME] | 11 | 15 | 0.96 | 1 | 0 | 0.07770017
4-45 | 2023-02-16 00:00:00 | [NAME] (FR) | 5 | 163 | 20 | SANDOWN (GB) | Hurdle | 52 | [NAME] | 11 | 9 | 0.37 | 1 | 0 | 0.07084978
2-05 | 2023-02-17 00:00:00 | [NAME] (GB) | 5 | 147 | 0 | KELSO (GB) | Hurdle | 80 | [NAME] | 11 | 2 | 2 | 0 | 0 | 0.1943034
2-05 | 2023-02-17 00:00:00 | [NAME] (IRE) | 6 | 166 | 0 | KELSO (GB) | Hurdle | 21 | Rebecca Menzies | 11 | 15 | 0.83 | 1 | 0 | 0.1505129
2-05 | 2023-02-17 00:00:00 | Fortcanyon (IRE) | 7 | 153 | 0 | KELSO (GB) | Hurdle | 17 | [NAME] | 11 | 11 | 1.78 | 0 | 1 | 0.1339599
2-05 | 2023-02-17 00:00:00 | [NAME] (IRE) | 7 | 170 | 0 | KELSO (GB) | Hurdle | 41 | [NAME] | 11 | 14 | 1.54 | 2 | 0 | 0.1324972
2-05 | 2023-02-17 00:00:00 | Five Dollar Fine (IRE) | 8 | 163 | 0 | KELSO (GB) | Hurdle | 17 | [NAME] | 11 | 4 | 1.9 | 2 | 0 | 0.1272323
2-05 | 2023-02-17 00:00:00 | Lock [NAME] (GB) | 7 | 167 | 0 | KELSO (GB) | Hurdle | 47 | [NAME] | 11 | 3 | 0.95 | 0 | 0 | 0.104757
2-05 | 2023-02-17 00:00:00 | [NAME] (GB) | 5 | 167 | 0 | KELSO (GB) | Hurdle | 14 | Iain Jardine | 11 | 15 | 0.97 | 3 | 0 | 0.09067109
2-05 | 2023-02-17 00:00:00 | Pipers Cross (IRE) | 6 | 145 | 0 | KELSO (GB) | Hurdle | 17 | [NAME] | 11 | 11 | 1.78 | 0 | 2 | 0.08101434
2-05 | 2023-02-17 00:00:00 | Shantou Moon (IRE) | 6 | 143 | 0 | KELSO (GB) | Hurdle | 22 | [NAME] | 11 | 3 | 0 | 0 | 0 | 0.05177447
2-05 | 2023-02-17 00:00:00 | Goodoldbill (GB) | 7 | 145 | 0 | KELSO (GB) | Hurdle | 33 | [NAME] | 11 | 0 | 0 | 0 | 2 | 0.04904562
2-05 | 2023-02-17 00:00:00 | How Much (IRE) | 5 | 148 | 0 | KELSO (GB) | Hurdle | 34 | [NAME] | 11 | 15 | 1.57 | 0 | 1 | 0.04080254
3-35 | 2023-02-17 00:00:00 | Dancewiththewind (IRE) | 8 | 142 | 0 | KELSO (GB) | Hurdle | 53 | [NAME] | 5 | 4 | 0.97 | 1 | 0 | 0.2264883
3-35 | 2023-02-17 00:00:00 | Thereisnodoubt (IRE) | 10 | 153 | 0 | KELSO (GB) | Hurdle | 33 | [NAME] | 5 | 15 | 0.98 | 0 | 0 | 0.2100911
3-35 | 2023-02-17 00:00:00 | West Cork (GB) | 9 | 168 | 0 | KELSO (GB) | Hurdle | 21 | [NAME] | 5 | 15 | 0.66 | 2 | 0 | 0.2026064
3-35 | 2023-02-17 00:00:00 | Ginger Mail (FR) | 7 | 144 | 0 | KELSO (GB) | Hurdle | 47 | N W Alexander | 5 | 15 | 1.41 | 4 | 0 | 0.1584536
3-35 | 2023-02-17 00:00:00 | Barrichello (GB) | 7 | 158 | 0 | KELSO (GB) | Hurdle | 20 | [NAME] | 5 | 15 | 1.06 | 0 | 0 | 0.11599