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

RaceNo | Date | [NAME] | Trainer | Track | nor | AE | Now | Profit | [NAME]
1-00 | 16/2/2023 | Less Legacy (GB) | [NAME] | NEWCASTLE (GB) | 52.00 | 2.22 | 0.17 | 91 | [NAME]
1-00 | 16/2/2023 | Millarville (IRE) | [NAME] | NEWCASTLE (GB) | 64.00 | 2.09 | 0.27 | 351.75 | TrainType of Race
1-00 | 16/2/2023 | [NAME] (IRE) | [NAME] | NEWCASTLE (GB) | 32.00 | 2.42 | 0.19 | 18.5 | [NAME]
1-00 | 16/2/2023 | [NAME] (IRE) | [NAME] | NEWCASTLE (GB) | 190.00 | 1.52 | 0.17 | 118.95 | Train Jockey
1-00 | 16/2/2023 | [NAME] (FR) | [NAME] | NEWCASTLE (GB) | 83.00 | 1.48 | 0.2 | 26.98 | Trainer Dist
1-00 | 16/2/2023 | Sheriff Garrett (IRE) | [NAME] | NEWCASTLE (GB) | 32.00 | 1.47 | 0.19 | 41 | [NAME]
1-00 | 16/2/2023 | Sheriff Garrett (IRE) | [NAME] | NEWCASTLE (GB) | 33.00 | 2.22 | 0.24 | 32.13 | ClassDropwin
1-15 | 16/2/2023 | [NAME] (FR) | [NAME] | SANDOWN (GB) | 275.00 | 1.23 | 0.19 | 36.96 | [NAME]
1-15 | 16/2/2023 | Gingerbred (GB) | [NAME] | SANDOWN (GB) | 116.00 | 1.26 | 0.2 | 21.86 | Trainer Dist
1-15 | 16/2/2023 | [NAME] (IRE) | [NAME] | SANDOWN (GB) | 44.00 | 3.31 | 0.23 | 50 | TrainType of Race
1-15 | 16/2/2023 | [NAME] (IRE) | [NAME] | SANDOWN (GB) | 64.00 | 2.82 | 0.17 | 47.5 | Last 2 runs from
1-15 | 16/2/2023 | Swinging London (IRE) | Olly Murphy | SANDOWN (GB) | 72.00 | 1.46 | 0.21 | 6.14 | [NAME]
1-25 | 16/2/2023 | Tune The Chello (IRE) | [NAME] | LEICESTER (GB) | 47.00 | 1.44 | 0.17 | 14.75 | Trainer  Course_1
1-35 | 16/2/2023 | Arthurs Quay (IRE) | [NAME] | NEWCASTLE (GB) | 46.00 | 1.65 | 0.17 | 44.93 | [NAME]
1-35 | 16/2/2023 | Arthurs Quay (IRE) | [NAME] | NEWCASTLE (GB) | 77.00 | 1.29 | 0.25 | 33.36 | Trainer Since Win
1-50 | 16/2/2023 | Bun Doran (IRE) | [NAME] | SANDOWN (GB) | 297.00 | 1.21 | 0.18 | 32.21 | ClassDrop
2-05 | 17/2/2023 | [NAME] (IRE) | Rebecca Menzies | KELSO (GB) | 73.00 | 1.25 | 0.19 | 21.01 | ClassDropwin
2-05 | 17/2/2023 | Five Dollar Fine (IRE) | [NAME] | KELSO (GB) | 30.00 | 1.70 | 0.27 | 6.88 | ClassDrop
2-05 | 17/2/2023 | Five Dollar Fine (IRE) | [NAME] | KELSO (GB) | 48.00 | 1.44 | 0.23 | 7.46 | [NAME]
2-05 | 17/2/2023 | [NAME] (GB) | Iain Jardine | KELSO (GB) | 36.00 | 1.53 | 0.28 | 4.51 | [NAME]
2-05 | 17/2/2023 | [NAME] (GB) | Iain Jardine | KELSO (GB) | 46.00 | 1.49 | 0.17 | 7.25 | 1st start Hcap
2-05 | 17/2/2023 | [NAME] (GB) | Iain Jardine | KELSO (GB) | 90.00 | 1.28 | 0.17 | 15.26 | [NAME]
2-05 | 17/2/2023 | [NAME] (IRE) | [NAME] | KELSO (GB) | 33.00 | 1.85 | 0.18 | 6.25 | Trainer  Course_1
2-05 | 17/2/2023 | [NAME] (IRE) | [NAME] | KELSO (GB) | 137.00 | 1.37 | 0.22 | 26.03 | Trainer Class today
2-35 | 16/2/2023 | [NAME] (IRE) | [NAME] | LEICESTER (GB) | 40.00 | 1.42 | 0.3 | 4.75 | [NAME]
2-35 | 16/2/2023 | [NAME] (IRE) | [NAME] | LEICESTER (GB) | 45.00 | 1.70 | 0.36 | 23.62 | Last 2 runs from
2-35 | 16/2/2023 | [NAME] (IRE) | [NAME] | LEICESTER (GB) | 102.00 | 1.23 | 0.19 | 7.78 | ClassDropwin
2-35 | 16/2/2023 | [NAME] (IRE) | [NAME] | LEICESTER (GB) | 181.00 | 1.31 | 0.23 | 38.02 | Trainer Since Win
2-35 | 16/2/2023 | Elmount (IRE) | [NAME] | LEICESTER (GB) | 27.00 | 1.37 | 0.19 | 8.25 | ClassDropwin
2-35 | 16/2/2023 | Letsbe Avenue (IRE) | [NAME] | LEICESTER (GB) | 27.00 | 1.77 | 0.19 | 4.25 | Trainer Since Win
2-45 | 16/2/2023 | Antey (GER) | [NAME] | NEWCASTLE (GB) | 43.00 | 1.36 | 0.16 | 18.75 | ClassDrop
2-45 | 16/2/2023 | Lake Takapuna (IRE) | [NAME] | NEWCASTLE (GB) | 182.00 | 1.24 | 0.22 | 37.42 | [NAME]
2-45 | 16/2/2023 | Relkadam (FR) | [NAME] | NEWCASTLE (GB) | 31.00 | 1.55 | 0.16 | 8.75 | Trainer  Course_1
2-45 | 16/2/2023 | Relkadam (FR) | [NAME] | NEWCASTLE (GB) | 32.00 | 1.47 | 0.19 | 41 | [NAME]
2-45 | 16/2/2023 | Relkadam (FR) | [NAME] | NEWCASTLE (GB) | 33.00 | 2.22 | 0.24 | 32.13 | ClassDropwin
2-45 | 16/2/2023 | Whodini (IRE) | Oliver Greenall & Josh Gu | NEWCASTLE (GB) | 49.00 | 1.45 | 0.29 | 15.11 | Train Jockey
3-05 | 17/2/2023 | [NAME] (IRE) | [NAME] | KELSO (GB) | 46.00 | 1.32 | 0.17 | 11.33 | ClassDrop
3-05 | 17/2/2023 | Dubai Days (IRE) | N W Alexander | KELSO (GB) | 49.00 | 1.67 | 0.2 | 33.13 | ClassDrop
3-05 | 17/2/2023 | Dubai Days (IRE) | N W Alexander | KELSO (GB) | 78.00 | 2.01 | 0.26 | 91.13 | ClassDropwin
3-05 | 17/2/2023 | [NAME] (FR) | N W Alexander | KELSO (GB) | 99.00 | 1.44 | 0.16 | 24.16 | Trainer Dist
3-10 | 16/2/2023 | Cloudy Wednesday (IRE) | [NAME] | LEICESTER (GB) | 31.00 | 1.39 | 0.23 | 2.78 | Trainer Since Win
3-10 | 16/2/2023 | Dogem By Design (IRE) | [NAME] | LEICESTER (GB) | 31.00 | 2.14 | 0.23 | 12.25 | ClassDrop
3-10 | 16/2/2023 | Dogem By Design (IRE) | [NAME] | LEICESTER (GB) | 36.00 | 1.51 | 0.17 | 2.63 | Trainer Class today
3-10 | 16/2/2023 | Heron Creek (IRE) | Dr [NAME] | LEICESTER (GB) | 203.00 | 1.27 | 0.17 | 32.21 | [NAME]
3-10 | 16/2/2023 | Moot Court (IRE) | Fergal OBrien | LEICESTER (GB) | 63.00 | 1.27 | 0.24 | 42.76 | [NAME]
3-10 | 16/2/2023 | Moot Court (IRE) | Fergal OBrien | LEICESTER (GB) | 177.00 | 1.36 | 0.21 | 30.82 | 2nd start Hcap
3-20 | 16/2/2023 | Lone Star (GB) | [NAME] | NEWCASTLE (GB) | 91.00 | 1.48 | 0.18 | 8.33 | [NAME]
3-20 | 16/2/2023 | Lone Star (GB) | [NAME] | NEWCASTLE (GB) | 185.00 | 1.24 | 0.17 | 4.48 | Won Prev at Course
3-35 | 17/2/2023 | Dancewiththewind (IRE) | [NAME] | KELSO (GB) | 64.00 | 2.09 | 0.27 | 351.75 | TrainType of Race
3-35 | 17/2/2023 | Ginger Mail (FR) | N W Alexander | KELSO (GB) | 40.00 | 1.70 | 0.25 | 21.25 | Train Jockey
3-35 | 17/2/2023 | Ginger Mail (FR) | N W Alexander | KELSO (GB) | 69.00 | 1.34 | 0.19 | 20.33 | Trainer Dist
3-35 | 17/2/2023 | Ginger Mail (FR) | N W Alexander | KELSO (GB) | 135.00 | 1.56 | 0.22 | 32.26 | Same time last year
3-35 | 17/2/2023 | West Cork (GB) | [NAME] | KELSO (GB) | 46.00 | 1.52 | 0.2 | 4.26 | Trainer  Course_1
3-35 | 17/2/2023 | West Cork (GB) | [NAME] | KELSO (GB) | 358.00 | 1.39 | 0.18 | 9.59 | [NAME]
3-45 | 16/2/2023 | Dreamsundermyfeet (IRE) | [NAME] | LEICESTER (GB) | 30.00 | 1.67 | 0.2 | 6.75 | [NAME]
3-45 | 16/2/2023 | Dreamsundermyfeet (IRE) | [NAME] | LEICESTER (GB) | 49.00 | 1.66 | 0.16 | 28.38 | Trainer Since Win
3-45 | 16/2/2023 | Dreamsundermyfeet (IRE) | [NAME] | LEICESTER (GB) | 74.00 | 1.32 | 0.16 | 14.75 | ClassDropwin
3-45 | 16/2/2023 | Dreamsundermyfeet (IRE) | [NAME] | LEICESTER (GB) | 215.00 | 1.46 | 0.19 | 10.21 | ClassDrop
3-45 | 16/2/2023 | [NAME] (GB) | Fergal OBrien | LEICESTER (GB) | 63.00 | 1.27 | 0.24 | 42.76 | [NAME]
3-45 | 16/2/2023 | [NAME] (GB) | Fergal OBrien | LEICESTER (GB) | 169.00 | 1.27 | 0.21 | 30.26 | Trainer Class today
3-45 | 16/2/2023 | [NAME] (FR) | [NAME] | LEICESTER (GB) | 81.00 | 1.72 | 0.17 | 15.5 | Trainer Since Win
3-55 | 16/2/2023 | Court At Slip (IRE) | [NAME] | NEWCASTLE (GB) | 32.00 | 1.47 | 0.19 | 41 | [NAME]
3-55 | 16/2/2023 | Dragonfruit (GB) | Oliver Greenall & Josh Gu | NEWCASTLE (GB) | 49.00 | 1.45 | 0.29 | 15.11 | Train Jockey
3-55 | 16/2/2023 | Follow Your Arrow (FR) | [NAME] | NEWCASTLE (GB) | 47.00 | 1.71 | 0.21 | 18.75 | ClassDropwin
3-55 | 16/2/2023 | Follow Your Arrow (FR) | [NAME] | NEWCASTLE (GB) | 65.00 | 1.45 | 0.17 | 0.5 | ClassDrop
4-05 | 17/2/2023 | [NAME] (FR) | [NAME] | KELSO (GB) | 25.00 | 1.54 | 0.2 | 27 | Trainer  Course_1
4-05 | 17/2/2023 | [NAME] (IRE) | N W Alexander | KELSO (GB) | 27.00 | 1.26 | 0.22 | 43 | Train Jockey
4-05 | 17/2/2023 | [NAME] (IRE) | N W Alexander | KELSO (GB) | 212.00 | 1.38 | 0.17 | 107.1 | ClassDrop
4-10 | 16/2/2023 | I See You Well (FR) | [NAME] | SANDOWN (GB) | 77.00 | 1.69 | 0.19 | 46.25 | Trainer Dist
4-10 | 16/2/2023 | [NAME] (IRE) | [NAME] | SANDOWN (GB) | 33.00 | 1.91 | 0.24 | 6.75 | Trainer  Course_1
4-10 | 16/2/2023 | Zhiguli (IRE) | [NAME] | SANDOWN (GB) | 32.00 | 2.12 | 0.22 | 6.58 | Train Jockey
4-30 | 16/2/2023 | Bulls Aye (IRE) | Iain Jardine | NEWCASTLE (GB) | 59.00 | 1.21 | 0.17 | 2.13 | Trainer Dist
4-30 | 16/2/2023 | Ivetwiggedit (GB) | [NAME] | NEWCASTLE (GB) | 76.00 | 1.23 | 0.22 | 4.27 | ClassDropwin
4-30 | 16/2/2023 | Ivetwiggedit (GB) | [NAME] | NEWCASTLE (GB) | 78.00 | 1.27 | 0.19 | 17.6 | 2nd start Hcap
4-30 | 16/2/2023 | Ivetwiggedit (GB) | [NAME] | NEWCASTLE (GB) | 131.00 | 1.48 | 0.26 | 38.27 | ClassDrop
4-30 | 16/2/2023 | Ivetwiggedit (GB) | [NAME] | NEWCASTLE (GB) | 876.00 | 1.29 | 0.21 | 130.44 | TrainType of Race
4-30 | 16/2/2023 | Licit (IRE) | [NAME] | NEWCASTLE (GB) | 31.00 | 1.55 | 0.16 | 8.75 | Trainer  Course_1
4-30 | 16/2/2023 | Licit (IRE) | [NAME] | NEWCASTLE (GB) | 32.00 | 1.47 | 0.19 | 41 | [NAME]
4-30 | 16/2/2023 | Oakmont (FR) | [NAME] | NEWCASTLE (GB) | 32.00 | 2.42 | 0.19 | 18.5 | [NAME]
4-45 | 16/2/2023 | [NAME] (GB) | [NAME] | SANDOWN (GB) | 35.00 | 1.27 | 0.17 | 22 | [NAME]
4-45 | 16/2/2023 | Equinus (IRE) | [NAME] | SANDOWN (GB) | 117.00 | 1.23 | 0.21 | 14.18 | [NAME]
4-45 | 16/2/2023 | [NAME] (FR) | [NAME] | SANDOWN (GB) | 89.00 | 1.37 | 0.19 | 5.55 | Train Jockey
4-45 | 16/2/2023 | Spanish Present (IRE) | [NAME] | SANDOWN (GB) | 99.00 | 1.35 | 0.26 | 46.01 | Train Jockey
4-45 | 16/2/2023 | Spanish Present (IRE) | [NAME] | SANDOWN (GB) | 123.00 | 1.32 | 0.19 | 13.93 | ClassDropwin
4-45 | 16/2/2023 | Sporting [NAME] (IRE) | [NAME] | SANDOWN (GB) | 265.00 | 1.31 | 0.2 | 53.9 | Train Jockey
_[NAME]_