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

RaceNo | Date | [NAME] | sp | Track | Nor | Network(1)
1-00 | 2023-02-16 00:00:00 | Clear White Light (GB) | 3.5 | NEWCASTLE (GB) | 6 | 0.20107
1-00 | 2023-02-16 00:00:00 | [NAME] (FR) | 25 | NEWCASTLE (GB) | 6 | 0.1707229
1-00 | 2023-02-16 00:00:00 | Sheriff Garrett (IRE) | 10 | NEWCASTLE (GB) | 6 | 0.1519682
1-00 | 2023-02-16 00:00:00 | Les's Legacy (GB) | 7 | NEWCASTLE (GB) | 6 | 0.1302144
1-00 | 2023-02-16 00:00:00 | [NAME] (IRE) | 9 | NEWCASTLE (GB) | 6 | 0.1100986
1-00 | 2023-02-16 00:00:00 | Millarville (IRE) | 6.5 | NEWCASTLE (GB) | 6 | 0.1017983
1-15 | 2023-02-16 00:00:00 | Jilaijone (FR) | 6 | SANDOWN (GB) | 10 | 0.2790798
1-15 | 2023-02-16 00:00:00 | [NAME] (FR) | 5.5 | SANDOWN (GB) | 10 | 0.213046
1-15 | 2023-02-16 00:00:00 | Gingerbred (GB) | 4.5 | SANDOWN (GB) | 10 | 0.1790465
1-15 | 2023-02-16 00:00:00 | Kannapolis (IRE) | 33 | SANDOWN (GB) | 10 | 0.1478143
1-15 | 2023-02-16 00:00:00 | [NAME] (IRE) | 20 | SANDOWN (GB) | 10 | 0.115639
1-15 | 2023-02-16 00:00:00 | [NAME] (GB) | 2.75 | SANDOWN (GB) | 10 | 0.1038052
1-15 | 2023-02-16 00:00:00 | Swinging London (IRE) | 20 | SANDOWN (GB) | 10 | 0.08683117
1-15 | 2023-02-16 00:00:00 | [NAME]'s The One (GB) | 14 | SANDOWN (GB) | 10 | 0.06565101
1-15 | 2023-02-16 00:00:00 | [NAME] (GB) | 4 | SANDOWN (GB) | 10 | 0.06292205
1-15 | 2023-02-16 00:00:00 | Ferdinand Star (GB) | 40 | SANDOWN (GB) | 10 | 0
1-25 | 2023-02-16 00:00:00 | Voice Of Calm (GB) | 0.67 | LEICESTER (GB) | 2 | 0.221091
1-25 | 2023-02-16 00:00:00 | Tune The Chello (IRE) | 1.25 | LEICESTER (GB) | 2 | 0.2060365
1-35 | 2023-02-16 00:00:00 | [NAME]'s Quay (IRE) | 1.75 | NEWCASTLE (GB) | 2 | 0.2220131
1-35 | 2023-02-16 00:00:00 | Fusain (FR) | 7 | NEWCASTLE (GB) | 2 | 0.1878532
1-50 | 2023-02-16 00:00:00 | [NAME] (FR) | 3 | SANDOWN (GB) | 5 | 0.3111999
1-50 | 2023-02-16 00:00:00 | Real Stone (GB) | 4 | SANDOWN (GB) | 5 | 0.3053021
1-50 | 2023-02-16 00:00:00 | [NAME] (IRE) | 1.75 | SANDOWN (GB) | 5 | 0.2361981
1-50 | 2023-02-16 00:00:00 | Bun Doran (IRE) | 6.5 | SANDOWN (GB) | 5 | 0.222886
1-50 | 2023-02-16 00:00:00 | [NAME] (GB) | 4.5 | SANDOWN (GB) | 5 | 0.1336187
2-35 | 2023-02-16 00:00:00 | [NAME] (IRE) | 2.75 | LEICESTER (GB) | 7 | 0.2374975
2-35 | 2023-02-16 00:00:00 | [NAME] (IRE) | 6 | LEICESTER (GB) | 7 | 0.2100968
2-35 | 2023-02-16 00:00:00 | Go As You Please (IRE) | 16 | LEICESTER (GB) | 7 | 0.06478464
2-35 | 2023-02-16 00:00:00 | Line Of Descent (IRE) | 2.25 | LEICESTER (GB) | 7 | 0.0611964
2-35 | 2023-02-16 00:00:00 | Letsbe Avenue (IRE) | 4.5 | LEICESTER (GB) | 7 | 0.02922658
2-35 | 2023-02-16 00:00:00 | Elmount (IRE) | 6 | LEICESTER (GB) | 7 | 0.01263645
2-35 | 2023-02-16 00:00:00 | Sabbathical (FR) | 14 | LEICESTER (GB) | 7 | 0
2-45 | 2023-02-16 00:00:00 | Lake Takapuna (IRE) | 5 | NEWCASTLE (GB) | 8 | 0.227362
2-45 | 2023-02-16 00:00:00 | Six One Nine (IRE) | 8 | NEWCASTLE (GB) | 8 | 0.1395879
2-45 | 2023-02-16 00:00:00 | Blue Hawaii (IRE) | 4 | NEWCASTLE (GB) | 8 | 0.1165465
2-45 | 2023-02-16 00:00:00 | Whodini (IRE) | 2.5 | NEWCASTLE (GB) | 8 | 0.1011564
2-45 | 2023-02-16 00:00:00 | Relkadam (FR) | 10 | NEWCASTLE (GB) | 8 | 0.09104169
2-45 | 2023-02-16 00:00:00 | Fourth Of July (IRE) | 12 | NEWCASTLE (GB) | 8 | 0.05302145
2-45 | 2023-02-16 00:00:00 | Antey (GER) | 20 | NEWCASTLE (GB) | 8 | 0.04639416
2-45 | 2023-02-16 00:00:00 | [NAME] (FR) | 33 | NEWCASTLE (GB) | 8 | 0.03737704
3-10 | 2023-02-16 00:00:00 | Heron Creek (IRE) | 9 | LEICESTER (GB) | 7 | 0.1793382
3-10 | 2023-02-16 00:00:00 | [NAME] (IRE) | 1.75 | LEICESTER (GB) | 7 | 0.1761043
3-10 | 2023-02-16 00:00:00 | Dogem By Design (IRE) | 20 | LEICESTER (GB) | 7 | 0.1016502
3-10 | 2023-02-16 00:00:00 | Moot Court (IRE) | 8 | LEICESTER (GB) | 7 | 0.1008902
3-10 | 2023-02-16 00:00:00 | Cloudy Wednesday (IRE) | 1.63 | LEICESTER (GB) | 7 | 0.05647638
3-10 | 2023-02-16 00:00:00 | [NAME] (GB) | 7 | LEICESTER (GB) | 7 | 0.04941442
3-10 | 2023-02-16 00:00:00 | C'est Quelqu'un (FR) | 20 | LEICESTER (GB) | 7 | 0.02016539
3-20 | 2023-02-16 00:00:00 | Aazza (IRE) | 3 | NEWCASTLE (GB) | 7 | 0.1997789
3-20 | 2023-02-16 00:00:00 | Lone Star (GB) | 1.5 | NEWCASTLE (GB) | 7 | 0.1833442
3-20 | 2023-02-16 00:00:00 | Noble Affair (IRE) | 50 | NEWCASTLE (GB) | 7 | 0.1297693
3-20 | 2023-02-16 00:00:00 | Silver Coin (IRE) | 33 | NEWCASTLE (GB) | 7 | 0.1193746
3-20 | 2023-02-16 00:00:00 | Nairobi Girl (IRE) | 100 | NEWCASTLE (GB) | 7 | 0.09793746
3-20 | 2023-02-16 00:00:00 | Shesupincourt (GB) | 8 | NEWCASTLE (GB) | 7 | 0.0883904
3-20 | 2023-02-16 00:00:00 | Fiadh (IRE) | 25 | NEWCASTLE (GB) | 7 | 0.08389366
3-45 | 2023-02-16 00:00:00 | Dreamsundermyfeet (IRE) | 2.5 | LEICESTER (GB) | 4 | 0.2774749
3-45 | 2023-02-16 00:00:00 | [NAME] (GB) | 1.38 | LEICESTER (GB) | 4 | 0.2425193
3-45 | 2023-02-16 00:00:00 | The Boat (IRE) | 7 | LEICESTER (GB) | 4 | 0.182024
3-45 | 2023-02-16 00:00:00 | [NAME] (FR) | 5 | LEICESTER (GB) | 4 | 0.03634147
3-55 | 2023-02-16 00:00:00 | Follow Your Arrow (FR) | 12 | NEWCASTLE (GB) | 7 | 0.2019238
3-55 | 2023-02-16 00:00:00 | [NAME] (IRE) | 6 | NEWCASTLE (GB) | 7 | 0.1760421
3-55 | 2023-02-16 00:00:00 | Dragonfruit (GB) | 11 | NEWCASTLE (GB) | 7 | 0.1523857
3-55 | 2023-02-16 00:00:00 | Court At Slip (IRE) | 8 | NEWCASTLE (GB) | 7 | 0.07481617
3-55 | 2023-02-16 00:00:00 | Loughermore (IRE) | 6.5 | NEWCASTLE (GB) | 7 | 0.04974471
3-55 | 2023-02-16 00:00:00 | Return Fire (IRE) | 6 | NEWCASTLE (GB) | 7 | 0.03925557
3-55 | 2023-02-16 00:00:00 | Flying Verse (GB) | 5.5 | NEWCASTLE (GB) | 7 | 0.02559323
4-10 | 2023-02-16 00:00:00 | Your Own Story (IRE) | 5.5 | SANDOWN (GB) | 7 | 0.1909509
4-10 | 2023-02-16 00:00:00 | [NAME] (IRE) | 3 | SANDOWN (GB) | 7 | 0.1587978
4-10 | 2023-02-16 00:00:00 | I See You Well (FR) | 10 | SANDOWN (GB) | 7 | 0.1284352
4-10 | 2023-02-16 00:00:00 | Zhiguli (IRE) | 7 | SANDOWN (GB) | 7 | 0.09945476
4-10 | 2023-02-16 00:00:00 | [NAME] (FR) | 14 | SANDOWN (GB) | 7 | 0.09858276
4-10 | 2023-02-16 00:00:00 | Stumptown (IRE) | 1.5 | SANDOWN (GB) | 7 | 0.08457126
4-10 | 2023-02-16 00:00:00 | [NAME] (IRE) | 10 | SANDOWN (GB) | 7 | 0.08415531
4-30 | 2023-02-16 00:00:00 | Ivetwiggedit (GB) | 0.73 | NEWCASTLE (GB) | 10 | 0.2069745
4-30 | 2023-02-16 00:00:00 | Burrows Hall (FR) | 9 | NEWCASTLE (GB) | 10 | 0.1693199
4-30 | 2023-02-16 00:00:00 | Bebside Banter (IRE) | 8 | NEWCASTLE (GB) | 10 | 0.1182783
4-30 | 2023-02-16 00:00:00 | Hungry Tiger (IRE) | 20 | NEWCASTLE (GB) | 10 | 0.08425081
4-30 | 2023-02-16 00:00:00 | Licit (IRE) | 25 | NEWCASTLE (GB) | 10 | 0.07791487
4-30 | 2023-02-16 00:00:00 | Bulls Aye (IRE) | 40 | NEWCASTLE (GB) | 10 | 0.04294929
4-30 | 2023-02-16 00:00:00 | Oakmont (FR) | 20 | NEWCASTLE (GB) | 10 | 0.04273282
4-30 | 2023-02-16 00:00:00 | Something Golden (IRE) | 25 | NEWCASTLE (GB) | 10 | 0.03286253
4-30 | 2023-02-16 00:00:00 | [NAME] (IRE) | 33 | NEWCASTLE (GB) | 10 | 0.0295699
4-30 | 2023-02-16 00:00:00 | Fazayte (FR) | 10 | NEWCASTLE (GB) | 10 | 0.01199381
4-45 | 2023-02-16 00:00:00 | Twin Power (IRE) | 5 | SANDOWN (GB) | 11 | 0.3304297
4-45 | 2023-02-16 00:00:00 | Missed Tee (IRE) | 6.5 | SANDOWN (GB) | 11 | 0.2681539
4-45 | 2023-02-16 00:00:00 | Gaelic Park (IRE) | 9 | SANDOWN (GB) | 11 | 0.1910177
4-45 | 2023-02-16 00:00:00 | Equinus (IRE) | 4 | SANDOWN (GB) | 11 | 0.1769398
4-45 | 2023-02-16 00:00:00 | [NAME] (GB) | 8 | SANDOWN (GB) | 11 | 0.1608136
4-45 | 2023-02-16 00:00:00 | Inneston (FR) | 6.5 | SANDOWN (GB) | 11 | 0.1578124
4-45 | 2023-02-16 00:00:00 | Amrons Sage (IRE) | 4 | SANDOWN (GB) | 11 | 0.1560618
4-45 | 2023-02-16 00:00:00 | Sporting [NAME] (IRE) | 16 | SANDOWN (GB) | 11 | 0.1001231
4-45 | 2023-02-16 00:00:00 | [NAME] (FR) | 20 | SANDOWN (GB) | 11 | 0.05623325
4-45 | 2023-02-16 00:00:00 | Spanish Present (IRE) | 14 | SANDOWN (GB) | 11 | 0.02045812
4-45 | 2023-02-16 00:00:00 | [NAME] (FR) | 25 | SANDOWN (GB) | 11 | 0
2-05 | 2023-02-17 00:00:00 | Five Dollar Fine (IRE) | 0 | KELSO (GB) | 11 | 0.1589383
2-05 | 2023-02-17 00:00:00 | [NAME] (GB) | 0 | KELSO (GB) | 11 | 0.1436308
2-05 | 2023-02-17 00:00:00 | [NAME] (IRE) | 0 | KELSO (GB) | 11 | 0.1347093
2-05 | 2023-02-17 00:00:00 | [NAME] (IRE) | 0 | KELSO (GB) | 11 | 0.1124749
2-05 | 2023-02-17 00:00:00 | How Much (IRE) | 0 | KELSO (GB) | 11 | 0.08010171
2-05 | 2023-02-17 00:00:00 | Lock [NAME] (GB) | 0 | KELSO (GB) | 11 | 0.05175823
2-05 | 2023-02-17 00:00:00 | Shantou Moon (IRE) | 0 | KELSO (GB) | 11 | 0.04170085
2-05 | 2023-02-17 00:00:00 | Goodoldbill (GB) | 0 | KELSO (GB) | 11 | 0.04106597
2-05 | 2023-02-17 00:00:00 | Pipers Cross (IRE) | 0 | KELSO (GB) | 11 | 0.0381566
2-05 | 2023-02-17 00:00:00 | [NAME] (GB) | 0 | KELSO (GB) | 11 | 0.03231754
2-05 | 2023-02-17 00:00:00 | Fortcanyon (IRE) | 0 | KELSO (GB) | 11 | 0.006134836
3-05 | 2023-02-17 00:00:00 | Minella Drama (IRE) | 0 | KELSO (GB) | 4 | 0.2881283
3-05 | 2023-02-17 00:00:00 | Dubai Days (IRE) | 0 | KELSO (GB) | 4 | 0.2812858
3-05 | 2023-02-17 00:00:00 | [NAME] (FR) | 0 | KELSO (GB) | 4 | 0.2323771
3-05 | 2023-02-17 00:00:00 | [NAME] (IRE) | 0 | KELSO (GB) | 4 | 0.1764861
3-35 | 2023-02-17 00:00:00 | Thereisnodoubt (IRE) | 0 | KELSO (GB) | 5 | 0.2731318
3-35 | 2023-02-17 00:00:00 | Barrichello (GB) | 0 | KELSO (GB) | 5 | 0.2395091
3-35 | 2023-02-17 00:00:00 | Dancewiththewind (IRE) | 0 | KELSO (GB) | 5 | 0.1682336
3-35 | 2023-02-17 00:00:00 | Ginger Mail (FR) | 0 | KELSO (GB) | 5 | 0.1499213
3-35 | 2023-02-17 00:00:00 | West Cork (GB) | 0 | KELSO (GB) | 5 | 0.1311948
4-05 | 2023-02-17 00:00:00 | [NAME] (IRE) | 0 | KELSO (GB) | 5 | 0.2653332
4-05 | 2023-02-17 00:00:00 | Domandlouis (IRE) | 0 | KELSO (GB) | 5 | 0.2257668
4-05 | 2023-02-17 00:00:00 | Hold The Note (IRE) | 0 | KELSO (GB) | 5 | 0.1584531
4-05 | 2023-02-17 00:00:00 | [NAME] (FR) | 0 | KELSO (GB) | 5 | 0.08092738
4-05 | 2023-02-17 00:00:00 | Latitude (IRE) | 0 | KELSO (GB) | 5 | 0.07578892