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

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-25 | 2023-02-16 00:00:00 | Voice Of Calm (GB) | 7 | 157 | 0.67 | LEICESTER (GB) | Chase | 70 | [NAME] | 2 | 15 | 0.83 | 0 | 0 | 0.5679026
1-25 | 2023-02-16 00:00:00 | Tune The Chello (IRE) | 8 | 156 | 1.25 | LEICESTER (GB) | Chase | 58 | [NAME] | 2 | 15 | 1.06 | 1 | 0 | 0.1533268
1-35 | 2023-02-16 00:00:00 | Fusain (FR) | 8 | 145 | 7 | NEWCASTLE (GB) | Chase | 52 | [NAME] | 2 | 11 | 2.06 | 0 | 0 | 0.3759019
1-35 | 2023-02-16 00:00:00 | [NAME]'s Quay (IRE) | 9 | 156 | 1.75 | NEWCASTLE (GB) | Chase | 18 | [NAME] | 2 | 13 | 0.7 | 2 | 0 | 0.3506324
1-50 | 2023-02-16 00:00:00 | [NAME] (IRE) | 6 | 160 | 1.75 | SANDOWN (GB) | Chase | 40 | [NAME] | 5 | 15 | 0.98 | 0 | 0 | 0.246333
1-50 | 2023-02-16 00:00:00 | Bun Doran (IRE) | 12 | 161 | 6.5 | SANDOWN (GB) | Chase | 33 | [NAME] | 5 | 9 | 0 | 1 | 0 | 0.2417379
1-50 | 2023-02-16 00:00:00 | [NAME] (GB) | 8 | 162 | 4.5 | SANDOWN (GB) | Chase | 19 | [NAME] | 5 | 15 | 1.42 | 0 | 0 | 0.2321923
1-50 | 2023-02-16 00:00:00 | Real Stone (GB) | 8 | 156 | 4 | SANDOWN (GB) | Chase | 24 | [NAME] | 5 | 15 | 0.66 | 0 | 0 | 0.2080866
1-50 | 2023-02-16 00:00:00 | [NAME] (FR) | 8 | 168 | 3 | SANDOWN (GB) | Chase | 16 | [NAME] | 5 | 15 | 0.89 | 0 | 0 | 0.1953368
2-35 | 2023-02-16 00:00:00 | Sabbathical (FR) | 8 | 165 | 14 | LEICESTER (GB) | Chase | 24 | [NAME] | 7 | 15 | 0.59 | 0 | 0 | 0.1750098
2-35 | 2023-02-16 00:00:00 | Line Of Descent (IRE) | 5 | 155 | 2.25 | LEICESTER (GB) | Chase | 14 | [NAME] | 7 | 15 | 0.32 | 0 | 0 | 0.1679878
2-35 | 2023-02-16 00:00:00 | [NAME] (IRE) | 7 | 169 | 6 | LEICESTER (GB) | Chase | 305 | [NAME] | 7 | 15 | 1.06 | 0 | 1 | 0.1327195
2-35 | 2023-02-16 00:00:00 | Go As You Please (IRE) | 10 | 155 | 16 | LEICESTER (GB) | Chase | 84 | [NAME] | 7 | 9 | 0 | 0 | 1 | 0.1230048
2-35 | 2023-02-16 00:00:00 | Elmount (IRE) | 7 | 164 | 6 | LEICESTER (GB) | Chase | 19 | [NAME] | 7 | 15 | 1.24 | 1 | 0 | 0.1068199
2-35 | 2023-02-16 00:00:00 | [NAME] (IRE) | 9 | 159 | 2.75 | LEICESTER (GB) | Chase | 14 | [NAME] | 7 | 15 | 1.65 | 4 | 0 | 0.08499753
2-35 | 2023-02-16 00:00:00 | Letsbe Avenue (IRE) | 8 | 148 | 4.5 | LEICESTER (GB) | Chase | 9 | [NAME] | 7 | 7 | 0.91 | 1 | 0 | 0.08232835
2-45 | 2023-02-16 00:00:00 | Relkadam (FR) | 9 | 146 | 10 | NEWCASTLE (GB) | Chase | 22 | [NAME] | 8 | 15 | 1.57 | 3 | 0 | 0.1734957
2-45 | 2023-02-16 00:00:00 | Lake Takapuna (IRE) | 12 | 169 | 5 | NEWCASTLE (GB) | Chase | 15 | [NAME] | 8 | 10 | 0.61 | 1 | 0 | 0.158132
2-45 | 2023-02-16 00:00:00 | Whodini (IRE) | 6 | 160 | 2.5 | NEWCASTLE (GB) | Chase | 86 | Oliver Greenall & Josh Gu | 8 | 15 | 1.22 | 1 | 0 | 0.1080754
2-45 | 2023-02-16 00:00:00 | Antey (GER) | 10 | 169 | 20 | NEWCASTLE (GB) | Chase | 46 | [NAME] | 8 | 15 | 0.98 | 1 | 0 | 0.1062018
2-45 | 2023-02-16 00:00:00 | [NAME] (FR) | 5 | 155 | 33 | NEWCASTLE (GB) | Chase | 52 | [NAME] | 8 | 15 | 1.31 | 0 | 0 | 0.086292
2-45 | 2023-02-16 00:00:00 | Blue Hawaii (IRE) | 8 | 165 | 4 | NEWCASTLE (GB) | Chase | 18 | Tjade Collier | 8 | 5 | 1.47 | 0 | 0 | 0.08588195
2-45 | 2023-02-16 00:00:00 | Fourth Of July (IRE) | 8 | 142 | 12 | NEWCASTLE (GB) | Chase | 16 | [NAME] | 8 | 10 | 0 | 0 | 0 | 0.0736059
2-45 | 2023-02-16 00:00:00 | Six One Nine (IRE) | 8 | 144 | 8 | NEWCASTLE (GB) | Chase | 52 | [NAME] | 8 | 7 | 0.91 | 0 | 1 | 0.06000668
3-10 | 2023-02-16 00:00:00 | [NAME] (GB) | 8 | 157 | 7 | LEICESTER (GB) | Chase | 13 | [NAME] | 7 | 8 | 1 | 0 | 0 | 0.1893731
3-10 | 2023-02-16 00:00:00 | Cloudy Wednesday (IRE) | 7 | 151 | 1.63 | LEICESTER (GB) | Chase | 14 | [NAME] | 7 | 5 | 0.81 | 1 | 0 | 0.127733
3-10 | 2023-02-16 00:00:00 | [NAME] (IRE) | 6 | 145 | 1.75 | LEICESTER (GB) | Chase | 14 | [NAME] | 7 | 15 | 1.23 | 0 | 0 | 0.1272497
3-10 | 2023-02-16 00:00:00 | Moot Court (IRE) | 8 | 168 | 8 | LEICESTER (GB) | Chase | 317 | [NAME] | 7 | 15 | 1.3 | 2 | 0 | 0.1108709
3-10 | 2023-02-16 00:00:00 | Dogem By Design (IRE) | 6 | 142 | 20 | LEICESTER (GB) | Chase | 8 | [NAME] | 7 | 8 | 1.04 | 2 | 1 | 0.06797686
3-10 | 2023-02-16 00:00:00 | C'est Quelqu'un (FR) | 6 | 156 | 20 | LEICESTER (GB) | Chase | 18 | [NAME] | 7 | 7 | 0.46 | 0 | 0 | 0.06166309
3-10 | 2023-02-16 00:00:00 | Heron Creek (IRE) | 6 | 144 | 9 | LEICESTER (GB) | Chase | 17 | Dr [NAME] | 7 | 15 | 1.01 | 1 | 0 | 0.04670799
3-45 | 2023-02-16 00:00:00 | [NAME] (GB) | 8 | 168 | 1.38 | LEICESTER (GB) | Chase | 15 | [NAME] | 4 | 15 | 1.3 | 2 | 0 | 0.3371127
3-45 | 2023-02-16 00:00:00 | Dreamsundermyfeet (IRE) | 8 | 168 | 2.5 | LEICESTER (GB) | Chase | 13 | [NAME] | 4 | 15 | 1.65 | 4 | 0 | 0.2362312
3-45 | 2023-02-16 00:00:00 | The Boat (IRE) | 7 | 147 | 7 | LEICESTER (GB) | Chase | 24 | [NAME] | 4 | 15 | 0.59 | 0 | 0 | 0.1626244
3-45 | 2023-02-16 00:00:00 | [NAME] (FR) | 5 | 163 | 5 | LEICESTER (GB) | Chase | 121 | [NAME] | 4 | 15 | 1.23 | 1 | 0 | 0.1455531
3-55 | 2023-02-16 00:00:00 | Dragonfruit (GB) | 8 | 165 | 11 | NEWCASTLE (GB) | Chase | 18 | Oliver Greenall & Josh Gu | 7 | 15 | 1.22 | 1 | 0 | 0.2285139
3-55 | 2023-02-16 00:00:00 | Follow Your Arrow (FR) | 7 | 161 | 12 | NEWCASTLE (GB) | Chase | 13 | [NAME] | 7 | 6 | 0.55 | 2 | 0 | 0.2283752
3-55 | 2023-02-16 00:00:00 | Loughermore (IRE) | 9 | 148 | 6.5 | NEWCASTLE (GB) | Chase | 21 | [NAME] | 7 | 2 | 1.92 | 0 | 2 | 0.1753055
3-55 | 2023-02-16 00:00:00 | Return Fire (IRE) | 7 | 165 | 6 | NEWCASTLE (GB) | Chase | 21 | [NAME] | 7 | 15 | 0.98 | 0 | 0 | 0.1656384
3-55 | 2023-02-16 00:00:00 | Court At Slip (IRE) | 6 | 161 | 8 | NEWCASTLE (GB) | Chase | 21 | [NAME] | 7 | 15 | 1.57 | 1 | 0 | 0.1174976
3-55 | 2023-02-16 00:00:00 | Flying Verse (GB) | 11 | 165 | 5.5 | NEWCASTLE (GB) | Chase | 18 | [NAME] | 7 | 12 | 1.57 | 0 | 1 | 0.1054675
3-55 | 2023-02-16 00:00:00 | [NAME] (IRE) | 10 | 169 | 6 | NEWCASTLE (GB) | Chase | 22 | [NAME] | 7 | 8 | 0.41 | 0 | 1 | 0.08549142
4-10 | 2023-02-16 00:00:00 | [NAME] (IRE) | 9 | 159 | 10 | SANDOWN (GB) | Chase | 56 | [NAME] | 7 | 15 | 1.15 | 1 | 0 | 0.1845036
4-10 | 2023-02-16 00:00:00 | [NAME] (IRE) | 7 | 169 | 3 | SANDOWN (GB) | Chase | 46 | [NAME] | 7 | 15 | 0.46 | 0 | 0 | 0.1768314
4-10 | 2023-02-16 00:00:00 | Zhiguli (IRE) | 8 | 167 | 7 | SANDOWN (GB) | Chase | 33 | [NAME] | 7 | 15 | 1.54 | 1 | 0 | 0.1740104
4-10 | 2023-02-16 00:00:00 | I See You Well (FR) | 10 | 164 | 10 | SANDOWN (GB) | Chase | 45 | [NAME] | 7 | 15 | 0 | 1 | 0 | 0.1620881
4-10 | 2023-02-16 00:00:00 | Your Own Story (IRE) | 7 | 155 | 5.5 | SANDOWN (GB) | Chase | 19 | [NAME] | 7 | 15 | 0.98 | 0 | 0 | 0.12798
4-10 | 2023-02-16 00:00:00 | Stumptown (IRE) | 6 | 163 | 1.5 | SANDOWN (GB) | Chase | 25 | [NAME] | 7 | 15 | 0.93 | 0 | 0 | 0.1168368
4-10 | 2023-02-16 00:00:00 | [NAME] (FR) | 10 | 165 | 14 | SANDOWN (GB) | Chase | 75 | [NAME] | 7 | 7 | 0.46 | 0 | 0 | 0.08391559
3-05 | 2023-02-17 00:00:00 | Dubai Days (IRE) | 9 | 143 | 0 | KELSO (GB) | Chase | 16 | N W Alexander | 4 | 15 | 1.41 | 2 | 0 | 0.2442528
3-05 | 2023-02-17 00:00:00 | [NAME] (IRE) | 8 | 150 | 0 | KELSO (GB) | Chase | 13 | [NAME] | 4 | 10 | 0.3 | 1 | 0 | 0.2375244
3-05 | 2023-02-17 00:00:00 | [NAME] (FR) | 9 | 158 | 0 | KELSO (GB) | Chase | 20 | N W Alexander | 4 | 15 | 1.41 | 1 | 0 | 0.1731088
3-05 | 2023-02-17 00:00:00 | Minella Drama (IRE) | 8 | 168 | 0 | KELSO (GB) | Chase | 47 | [NAME] | 4 | 15 | 1.06 | 0 | 0 | 0.1512092
4-05 | 2023-02-17 00:00:00 | [NAME] (IRE) | 7 | 151 | 0 | KELSO (GB) | Chase | 50 | N W Alexander | 5 | 15 | 1.41 | 2 | 0 | 0.2972711
4-05 | 2023-02-17 00:00:00 | [NAME] (FR) | 8 | 164 | 0 | KELSO (GB) | Chase | 105 | [NAME] | 5 | 15 | 0.89 | 1 | 0 | 0.2528226
4-05 | 2023-02-17 00:00:00 | Latitude (IRE) | 7 | 156 | 0 | KELSO (GB) | Chase | 73 | [NAME] | 5 | 6 | 0.82 | 0 | 0 | 0.2504495
4-05 | 2023-02-17 00:00:00 | Hold The Note (IRE) | 9 | 146 | 0 | KELSO (GB) | Chase | 20 | Ewan Whillans | 5 | 11 | 0.48 | 0 | 0 | 0.1189444
4-05 | 2023-02-17 00:00:00 | Domandlouis (IRE) | 6 | 145 | 0 | KELSO (GB) | Chase | 75 | [NAME] | 5 | 15 | 0.98 | 0 | 0 | 0.07750309