Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, this is my first time posting so hopefully I provide the right information to get help on an area I need to improve, and that's DAX coding.
I have a report based on horse racing and one measure I want to include is for each race and for each horse how much weight is it carrying above the minimum. So for example Horse A carrying weight is 57.5, Horse B 56.0, Horse C 55.0 and Horse D is 52.5. I want a column that will show the weight being carried above the minimum weight for the selected race. So based on the above it should show Horse A 5.0, Horse B 3.5, Horse C 2.5 and Horse D 0 (as this is the lowest weighted horse).
I've tried a few things around DAX code but get the same weight the horse already shows as carrying or all show 0, very frustrating.
Any help is much appreciated.
Thanks
Brendan
Solved! Go to Solution.
I'm trying to add a new measure to the table 'Race Data#1' but get the following message:
The column 'Neurals Mstr[Race No.]' either doesn't exist or doesn't have a relationship to any table available in the current context.
The two tables 'Race Data#1' and 'Neurals Mstr' have a relationship based on horse name as that is common in both. I also have date as common in both tables. I'm wondering if that is what is causing the error message as the DAX is about Race No. and Carry Weight which are not used as the relationship connector?
Thanks
Don't add the column within Power Query! You should be adding that column to your table within DAX.
Cheers
Hi Jos, I finally got it!!! I added the column BUT it returns all 0s in the column for weight above the minimum.
Ok, for starters this isn't a measure, it's a calculated column. And the error you're getting suggests to me that you're attempting to put the calculated column I provided in the wrong table. I suggest you go back to post #10 in this thread and check very carefully the information you posted, especially the table names.
Regards
Hi Jos,
Sorry to bother you but had an update. The first table after ALLEXECPT was 'neural mstr' but changed it to 'All Data#1'. Doing this (as per below) now produces data.
WRONG
Do you have any idea why the second table shows the minimum weight incorrectly?
Thanks
I'm afraid I wouldn't be able to tell you unless I saw the precise data from the two tables as well as the exact version of the formula you are using. If the real table data is too big to give here, then you'll have to create reduced versions which exhibit the issue you're having.
Regards
Happy to provide the datasets but can I forward the excel attachments?
Can you not just paste small versions of your tables which give the incorrect results you describe?
Regards
Hi Jos,
Is the model screenshot of any use? I can share the neural mstr workbook dataset details but struggling to figure out how to show the Race Data#1 dataset. I get this in an excel workbook but make transformations using power query and don't have power bi pro so can't figure out how i can share it.
I don't think the relationship is the issue here. And I'm still not sure why you can't just create two small, mocked-up versions of your tables which exhibit incorrect results similar to the ones you are experiencing in your real workbook.
Regards
Hi, I've managed to make a sample set for one of the races that are showing as incorrect. To follow is the current output in Power BI and then the two datasets used for the output.
NEURAL MSTR dataset
Horse No. | Horse | Jockey | Barrier | Trainer | Weight Performance (algo) | Career Performance Assessment (based on weight/class algo) | Current Form (measured by class/weight algo) | Revolutionary Time Assessment (adjust algo) | Jockey Ability (algo) | Trainer Ability (algo) | Jockey/Trainer Combination (algo) | Barrier Position (algo) | Wet Track Performance (algo) | Course Suitability (algo) | Distance Suitable (algo) | Prizemoney Earned (algo) | Days since Last Run (algo) | HCP | Neural Rating | Price Rating | Race No. | Course | Date | Race Time | Race Name | Distance | Class | Prize Money | Starters | Track Conditions |
5 | SOLAR APEX | TOMMY BERRY | 6 | CHRIS WALLER | 57.5 | 11 | 17 | 5 | 20 | 28 | 20 | 15 | 0 | 8 | 25 | 21 | 15 | 0 | 184.5 | $3.70 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
7 | FORTIFIED | BROCK RYAN | 5 | CHRIS WALLER | 55.5 | 29 | 20 | 14 | 5 | 28 | 8 | 13 | 0 | 12 | 13 | 21 | 20 | 0 | 182 | $4.40 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
2 | MIGHTYBEEL | HUGH BOWMAN | 8 | CHRIS WALLER | 59.5 | 11 | 15 | 7 | 18 | 28 | 8 | 11 | 0 | 26 | 15 | 22 | 18 | 0 | 177.5 | $5.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
4 | MARGIE BEE | JOSH PARR | 2 | KRISTEN BUCHANAN | 57.5 | 5 | 13 | 13 | 10 | 33 | 3 | 12 | 0 | 11 | 20 | 14 | 16 | 0 | 149 | $7.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
6 | LORD ARDMORE | LEE MAGORRIAN | 1 | CHRIS WALLER | 57.5 | 24 | 1 | 1 | 10 | 28 | 10 | 13 | 0 | 12 | 12 | 12 | 20 | 0 | 142.5 | $8.50 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
8 | DINADO | JASON COLLETT | 4 | R & M FREEDMAN | 54 | 4 | 16 | 8 | 10 | 8 | 3 | 15 | 0 | 12 | 10 | 13 | 20 | 0 | 118 | $12.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
3 | PROMPT PRODIGY | GLYN SCHOFIELD | 3 | EDWARD CUMMINGS | 59 | 5 | 1 | 1 | 3 | 10 | 8 | 14 | 0 | 16 | 12 | 14 | 13 | 0 | 96 | $16.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
9 | APACHE BELLE | KATHY O'HARA | 7 | WAYNE SEELIN | 52 | 4 | 9 | 1 | 3 | 3 | 3 | 9 | 0 | 4 | 4 | 8 | 18 | 0 | 64.5 | $31.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
1 | MILK MAN | JENNY DUGGAN | - | MATTHEW SMITH | 61 | 11 | 21 | 1 | 5 | 10 | 15 | 10 | 29 | 13 | 4 | 18 | 16 | 0 | scr | scr | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 8 | Good |
RACE DATA#1 dataset
Horse No. | Horse | Weight | Recent Form | Barrier | BP Adj | Jockey | Jockey Allowance | Trainer | Age | Sex | Jockey Rating | Trainer Rating | Runs Since Last Win | Days Since Last Run | Weight Change | Distance Change | Average Prizemoney - Career | Average Prizemoney - Last 12m | Highest Winning Weight | Degree of Difficulity | Jockey & Horse Wins | Jockey & Horse Places | Jockey & Horse Starts | Jockey & Horse Win% | Jockey & Horse Place% | Career Wins | Career Places | Career Starts | Career Win% | Career Place% | Career Last 12m Wins | Career Last 12m Places | Career Last 12m Starts | Career Last 12m - Win% | Career Last 12m - Place% | Course Wins | Course Place | Course Starts | Date | Carry Weight | Career | Weight above Minimum | Minimum weight should be |
2 | MIGHTYBEEL | 59.5 | 4x411 | 8 | 7 | H BOWMAN | C WALLER | 4 | G | 2.5 | 4.3 | 0 | 10 | -1.0 | 100 | $10,245 | $11,278 | 60.5 | 2.5 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 9 | 33 | 56 | 3 | 2 | 8 | 38 | 62 | 1 | 0 | 1 | 30-Oct-21 | 59.5 | 3-2-9 | 8 | 7.5 | |
3 | PROMPT PRODIGY | 59.0 | 0x798 | 3 | 8 | G SCHOFIELD | EDWARD CUMMINGS | 4 | H | 1.9 | 2.6 | 7 | 28 | 4.0 | 300 | $6,477 | $6,889 | 57.5 | 6.0 | 0 | 0 | 1 | 0 | 0 | 1 | 5 | 14 | 7 | 43 | 1 | 4 | 12 | 8 | 42 | 0 | 1 | 1 | 30-Oct-21 | 59 | 1-5-14 | 7.5 | 7 | |
4 | MARGIE BEE | 57.5 | 03162 | 2 | 2 | J PARR | K BUCHANAN | 6 | M | 2.5 | 3.0 | 2 | 15 | -1.5 | 300 | $6,469 | $8,622 | 58.5 | 2.0 | 0 | 0 | 1 | 0 | 0 | 8 | 13 | 43 | 19 | 49 | 4 | 7 | 19 | 21 | 58 | 0 | 0 | 1 | 30-Oct-21 | 57.5 | 8-13-43 | 6 | 5.5 | |
5 | SOLAR APEX | 57.5 | 0x113 | 6 | 5 | TOMMY BERRY | C WALLER | 4 | G | 4.3 | 4.3 | 1 | 21 | 0.5 | -100 | $9,668 | $10,681 | 59.0 | 0.5 | 0 | 3 | 3 | 0 | 100 | 3 | 8 | 13 | 23 | 85 | 3 | 6 | 11 | 27 | 82 | 0 | 1 | 1 | 30-Oct-21 | 57.5 | 3-8-13 | 6 | 5.5 | |
6 | LORD ARDMORE | 57.5 | 90x57 | 1 | 1 | L MAGORRIAN | C WALLER | 4 | G | 2.5 | 4.3 | 8 | 7 | -0.5 | 300 | $5,422 | $6,720 | 56.0 | 3.0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 11 | 9 | 18 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 30-Oct-21 | 57.5 | 1-1-11 | 6 | 5.5 | |
7 | FORTIFIED | 55.5 | 81663 | 5 | 4 | BROCK RYAN | 2 | C WALLER | 4 | G | 2.2 | 4.3 | 3 | 3 | -4.0 | 0 | $9,554 | $9,554 | 59.0 | -1.0 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 12 | 33 | 58 | 4 | 3 | 12 | 33 | 58 | 0 | 0 | 0 | 30-Oct-21 | 53.5 | 4-3-12 | 2 | 1.5 |
8 | DINADO | 54.0 | 55821 | 4 | 3 | J R COLLETT | R & M FREEDMAN | 5 | M | 2.9 | 3.3 | 0 | 7 | -1.0 | 300 | $5,825 | $6,812 | 55.5 | 1.0 | 0 | 0 | 0 | 0 | 0 | 4 | 5 | 23 | 17 | 39 | 2 | 3 | 14 | 14 | 36 | 0 | 0 | 0 | 30-Oct-21 | 54 | 4-5-23 | 2.5 | 2 | |
9 | APACHE BELLE | 52.0 | 15345 | 7 | 6 | MS K O'HARA | W SEELIN | 6 | M | 1.8 | 2.5 | 4 | 10 | -5.0 | 350 | $3,756 | $5,230 | 59.5 | 2.5 | 0 | 1 | 4 | 0 | 25 | 7 | 9 | 38 | 18 | 42 | 4 | 4 | 16 | 25 | 50 | 0 | 0 | 1 | 30-Oct-21 | 52 | 7-9-38 | 0.5 | 0 |
Hopefully this all helps. The last column in the Race Data#1 dataset is what i've added to show what the output should be. Again thanks for the help.
Ok, thanks. I've just taken those two tables, imported them into a completely new, blank report, then entered a Calculated Column within the Race Data#1 table with precisely the same formula as I gave in post #11 and I get precisely the same results as your Minimum weight should be column. I have no idea how you've ended up with the results in the Weight above Minimum column.
Regards
RACE DATA#1 (race 4)
1 | BAROSSA ROSA | 61.0 | 0x310 | 15 | 15 | J DUGGAN | 2 | T BARTLEY | 4 | M | 2.9 | 2.6 | 1 | 14 | 4.0 | 100 | $12,533 | $14,429 | 58.0 | 0.5 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 11 | 27 | 64 | 3 | 3 | 9 | 33 | 67 | 1 | 0 | 1 | 30-Oct-21 | 59 | 3-4-11 | 7.5 | 7.5 |
2 | DALAALAAT | 60.0 | 28x14 | 14 | 14 | L MAGORRIAN | NATHAN DOYLE | 5 | G | 2.8 | 2.5 | 1 | 35 | 2.0 | 200 | $8,039 | $10,269 | 58.5 | 1.0 | 1 | 0 | 2 | 50 | 50 | 3 | 5 | 14 | 21 | 57 | 2 | 2 | 8 | 25 | 50 | 0 | 0 | 1 | 30-Oct-21 | 60 | 3-5-14 | 8.5 | 8.5 | |
3 | TAMPERING | 60.0 | x1143 | 8 | 8 | J BYRNE | K PARKER | 5 | G | 4.2 | 2.6 | 2 | 42 | 4.0 | -100 | $7,137 | $8,146 | 58.5 | 1.0 | 0 | 0 | 0 | 0 | 0 | 5 | 6 | 26 | 19 | 42 | 2 | 1 | 13 | 15 | 23 | 0 | 0 | 1 | 30-Oct-21 | 60 | 5-6-26 | 8.5 | 8.5 | |
4 | DIFFERENT STROKES | 59.5 | 21211 | 1 | 1 | H BOWMAN | K WAUGH | 4 | G | 2.7 | 1.3 | 0 | 21 | 3.5 | 100 | $17,232 | $17,232 | 59.0 | 0.0 | 2 | 0 | 2 | 100 | 100 | 3 | 3 | 6 | 50 | 100 | 3 | 3 | 6 | 50 | 100 | 0 | 0 | 0 | 30-Oct-21 | 59.5 | 3-3-6 | 8 | 8 | |
5 | GRACE BAY | 58.5 | 39x15 | 13 | 13 | J PARR | CLAIRE LEVER | 5 | M | 2.5 | 1.9 | 1 | 10 | -0.5 | 200 | $8,221 | $10,252 | 61.0 | 1.0 | 0 | 0 | 0 | 0 | 0 | 5 | 3 | 13 | 38 | 62 | 4 | 2 | 9 | 44 | 67 | 0 | 0 | 0 | 30-Oct-21 | 58.5 | 5-3-13 | 7 | 7 | |
6 | HIGHLY DESIRED | 58.5 | 437x1 | 7 | 7 | MS K O'HARA | CLAIRE LEVER | 7 | G | 1.7 | 1.9 | 0 | 21 | 0.5 | 200 | $5,750 | $6,304 | 62.0 | -1.0 | 0 | 0 | 0 | 0 | 0 | 7 | 8 | 32 | 22 | 47 | 1 | 1 | 5 | 20 | 40 | 0 | 0 | 0 | 30-Oct-21 | 58.5 | 7-8-32 | 7 | 7 | |
7 | REBEL RAMA | 58.0 | 319x1 | 2 | 2 | R DOLAN | M CONNERS | 4 | M | 2.5 | 1.9 | 0 | 17 | 0.0 | 100 | $9,731 | $12,304 | 58.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 13 | 23 | 46 | 3 | 3 | 10 | 30 | 60 | 1 | 0 | 1 | 30-Oct-21 | 58 | 3-3-13 | 6.5 | 6.5 | |
8 | CREAM RISES | 58.0 | 14x80 | 16 | 16 | N RAWILLER | K GAVENLOCK | 4 | G | 3.5 | 1.8 | 3 | 21 | 2.0 | 100 | $8,296 | $8,296 | 59.0 | 4.0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 5 | 40 | 40 | 2 | 0 | 5 | 40 | 40 | 0 | 0 | 0 | 30-Oct-21 | 58 | 2-0-5 | 6.5 | 6.5 | |
9 | TOO GOOD TO BE TRU | 58.0 | 724x7 | 11 | 11 | A ADKINS | D LANE | 4 | G | 1.8 | 2.4 | 5 | 21 | 2.0 | 100 | $6,558 | $6,558 | 57.5 | 6.0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 10 | 30 | 50 | 3 | 2 | 10 | 30 | 50 | 0 | 0 | 1 | 30-Oct-21 | 58 | 3-2-10 | 6.5 | 6.5 | |
10 | SUNBORN | 57.5 | 51313 | 20 | - | G SCHOFIELD | EDWARD CUMMINGS | 4 | M | 2.5 | 2.6 | 1 | 38 | 1.5 | -100 | $10,640 | $7,747 | 58.5 | 4.0 | 1 | 0 | 4 | 25 | 25 | 3 | 2 | 13 | 23 | 38 | 2 | 2 | 6 | 33 | 67 | 0 | 0 | 3 | 30-Oct-21 | 57.5 | 3-2-13 | |||
11 | DARALINA BELLE | 57.0 | 1112 | 6 | 6 | TIM CLARK | M SMITH | 4 | M | 2.4 | 2.8 | 1 | 17 | -1.0 | 100 | $11,448 | $11,448 | 58.0 | -0.5 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 75 | 100 | 3 | 1 | 4 | 75 | 100 | 0 | 0 | 0 | 30-Oct-21 | 57 | 3-1-4 | 5.5 | 5.5 | |
12 | CONRAD | 55.5 | 17x13 | 9 | 9 | ALYSHA COLLETT | K WAUGH | 3 | G | 3.0 | 1.3 | 1 | 10 | -5.0 | 100 | $11,293 | $11,293 | 57.5 | 3.0 | 0 | 1 | 1 | 0 | 100 | 2 | 2 | 5 | 40 | 80 | 2 | 2 | 5 | 40 | 80 | 0 | 0 | 1 | 30-Oct-21 | 55.5 | 2-2-5 | 4 | 4 | |
13 | ALL MACHIAVELLIAN | 55.0 | 31101 | 21 | - | J FORD | G HICKMAN | 3 | G | 2.8 | 2.9 | 0 | 14 | -3.0 | -100 | $9,153 | $9,153 | 58.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 6 | 50 | 67 | 3 | 1 | 6 | 50 | 67 | 0 | 0 | 1 | 30-Oct-21 | 55 | 3-1-6 | |||
14 | KOBESTAR | 55.0 | 39x21 | 18 | 18 | TOMMY BERRY | R & L PRICE | 4 | G | 4.4 | 1.9 | 0 | 23 | -4.0 | 300 | $4,563 | $6,348 | 59.0 | 2.5 | 2 | 0 | 2 | 100 | 100 | 2 | 3 | 15 | 13 | 33 | 2 | 3 | 9 | 22 | 56 | 0 | 0 | 1 | 30-Oct-21 | 55 | 2-3-15 | 3.5 | 3.5 | |
15 | DUFRESNE | 54.5 | 26216 | 5 | 5 | TYLER SCHILLER | 3 | A CUMMINGS | 3 | G | 2.8 | 2.9 | 1 | 7 | -2.5 | -100 | $10,365 | $10,365 | 57.5 | -4.5 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 5 | 20 | 60 | 1 | 2 | 5 | 20 | 60 | 1 | 0 | 1 | 30-Oct-21 | 51.5 | 1-2-5 | 0 | 0 |
16 | KISS SUM | 54.0 | 1x165 | 4 | 4 | J R COLLETT | T BARTLEY | 3 | G | 1.8 | 2.6 | 2 | 10 | -3.5 | 100 | $6,237 | $6,237 | 57.5 | 4.0 | 1 | 0 | 3 | 33 | 33 | 2 | 1 | 6 | 33 | 50 | 2 | 1 | 6 | 33 | 50 | 0 | 0 | 1 | 30-Oct-21 | 54 | 2-1-6 | 2.5 | 2.5 | |
17 | DIVINE BREATH | 53.5 | 29x22 | 10 | 10 | BROCK RYAN | 2 | T BATEUP | 4 | M | 2.2 | 1.9 | 5 | 21 | 1.5 | 100 | $6,523 | $7,683 | 55.5 | 0.5 | 0 | 1 | 1 | 0 | 100 | 1 | 5 | 8 | 12 | 75 | 1 | 3 | 6 | 17 | 67 | 0 | 0 | 0 | 30-Oct-21 | 51.5 | 1-5-8 | 0 | 0 |
18 | VERBEK | 53.0 | 6x223 | 3 | 3 | JEAN VAN OVERMEIRE | R & L PRICE | 3 | G | 1.6 | 1.9 | 0 | 10 | -3.5 | 100 | $6,859 | $6,859 | - | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 0 | 75 | 0 | 6 | 8 | 0 | 75 | 0 | 0 | 1 | 30-Oct-21 | 53 | 0-6-8 | 1.5 | 1.5 | |
19 | CANYONERO | 61.0 | 13413 | 19 | 19 | RICHARD LITT | 6 | G | - | 2.5 | 1 | 14 | 5.0 | 100 | $7,184 | $8,511 | 60.0 | 2.5 | 0 | 0 | 0 | 0 | 0 | 6 | 19 | 44 | 14 | 57 | 3 | 4 | 15 | 20 | 47 | 0 | 1 | 1 | 30-Oct-21 | 61 | 6-19-44 | ||||
20 | CAESARS PALACE | 57.5 | 05x31 | 12 | 12 | BRODIE LOY | A CUMMINGS | 4 | G | 2.0 | 2.9 | 0 | 9 | -2.5 | 0 | $5,412 | $6,851 | 60.0 | 3.0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 13 | 23 | 46 | 3 | 2 | 9 | 33 | 56 | 0 | 0 | 1 | 30-Oct-21 | 57.5 | 3-3-13 | 6 | 6 | |
21 | DOM TYCOON | 56.5 | 14115 | 17 | 17 | PETER ROBL | 4 | G | - | 2.3 | 1 | 10 | -1.0 | -50 | $4,785 | $5,037 | 59.0 | 1.5 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 16 | 25 | 50 | 4 | 4 | 15 | 27 | 53 | 0 | 0 | 0 | 30-Oct-21 | 56.5 | 4-4-16 | 5 | 5 | ||
22 | HEZA GENTLEMAN | 57.0 | 11839 | 22 | 20 | M & D KEARNEY | 5 | G | - | 2.4 | 3 | 14 | 5.0 | 100 | $3,415 | $4,607 | 55.0 | 2.0 | 0 | 0 | 0 | 0 | 0 | 4 | 9 | 35 | 11 | 37 | 2 | 5 | 15 | 13 | 47 | 0 | 0 | 0 | 30-Oct-21 | 57 | 4-9-35 |
RACE DATA#1 (race 3)
1 | BRANDERS RULE | 60.0 | 7x161 | 18 | - | JACK MARTIN | MITCHELL BEER | 4 | G | 1.8 | 1.7 | 0 | 22 | -1.5 | 25 | $6,015 | $6,515 | 61.5 | 1.5 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 8 | 38 | 38 | 2 | 0 | 4 | 50 | 50 | 0 | 0 | 0 | 30-Oct-21 | 60 | 3-0-8 | |||
2 | ICE IN VANCOUVER | 60.0 | 173x0 | 2 | 2 | TYLER SCHILLER | 3 | C MORGAN | 4 | G | 2.4 | 3.6 | 3 | 14 | 5.0 | 0 | $10,614 | $11,506 | 61.0 | -2.0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 7 | 43 | 57 | 1 | 1 | 4 | 25 | 50 | 0 | 0 | 0 | 30-Oct-21 | 57 | 3-1-7 | 5 | 4 |
3 | CASINO KID | 58.0 | 212x6 | 11 | 11 | ALYSHA COLLETT | J BOWEN | 4 | G | 2.8 | 2.0 | 2 | 14 | 0.5 | 100 | $6,716 | $8,393 | 58.0 | 1.0 | 0 | 0 | 0 | 0 | 0 | 3 | 7 | 17 | 18 | 59 | 2 | 4 | 10 | 20 | 60 | 0 | 0 | 1 | 30-Oct-21 | 58 | 3-7-17 | 6 | 5 | |
4 | CEASEFIRE | 58.0 | 17x10 | 3 | 3 | R DOLAN | P MESSARA | 4 | G | 2.3 | 2.4 | 1 | 14 | 3.0 | 0 | $10,161 | $10,161 | 59.5 | -1.5 | 0 | 0 | 1 | 0 | 0 | 3 | 0 | 5 | 60 | 60 | 3 | 0 | 5 | 60 | 60 | 0 | 0 | 0 | 30-Oct-21 | 58 | 3-0-5 | 6 | 5 | |
5 | PRIVATE AGENT | 57.0 | 2x331 | 14 | 14 | BRODIE LOY | K GOLDMAN | 4 | G | 2.9 | 1.5 | 0 | 14 | -2.5 | 0 | $7,163 | $8,227 | 59.5 | 0.5 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 6 | 33 | 83 | 1 | 2 | 3 | 33 | 100 | 0 | 0 | 0 | 30-Oct-21 | 57 | 2-3-6 | 5 | 4 | |
6 | BLOW DART | 56.5 | 18x13 | 10 | 10 | TIM CLARK | B THOMPSON | 3 | G | 3.5 | 1.5 | 1 | 14 | 1.0 | 100 | $9,240 | $9,240 | 59.0 | -0.5 | 0 | 1 | 1 | 0 | 100 | 3 | 2 | 6 | 50 | 83 | 3 | 2 | 6 | 50 | 83 | 0 | 0 | 1 | 30-Oct-21 | 56.5 | 3-2-6 | 4.5 | 3.5 | |
7 | BELLASTAR | 56.5 | 528x0 | 6 | 6 | A ADKINS | COLT PROSSER | 6 | M | 1.5 | 1.7 | 11 | 14 | 0.5 | 100 | $5,205 | $4,467 | 58.0 | 6.0 | 0 | 0 | 0 | 0 | 0 | 3 | 6 | 22 | 14 | 41 | 0 | 2 | 6 | 0 | 33 | 0 | 0 | 1 | 30-Oct-21 | 56.5 | 3-6-22 | 4.5 | 3.5 | |
8 | TEJORI | 56.0 | 280x5 | 1 | 1 | TOMMY BERRY | N OLIVE | 5 | M | 4.2 | 1.8 | 8 | 10 | 1.0 | 200 | $7,646 | $3,890 | 57.5 | 5.0 | 0 | 1 | 2 | 0 | 50 | 3 | 3 | 12 | 25 | 50 | 0 | 2 | 5 | 0 | 40 | 0 | 0 | 0 | 30-Oct-21 | 56 | 3-3-12 | 4 | 3 | |
9 | BRAVE ENOUGH | 56.0 | 5x351 | 7 | 7 | J DUGGAN | 2 | C MORGAN | 5 | G | 2.4 | 3.6 | 0 | 8 | -3.0 | 100 | $4,401 | $3,509 | 59.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 16 | 19 | 38 | 1 | 2 | 8 | 12 | 38 | 0 | 0 | 0 | 30-Oct-21 | 54 | 3-3-16 | 2 | 1 |
10 | CHEVCONI | 55.5 | 65x11 | 9 | 9 | J PARR | G WILLIAMS | 5 | G | 3.6 | 2.6 | 0 | 15 | -2.0 | -8 | $5,666 | $5,338 | 59.0 | 1.0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 8 | 38 | 50 | 2 | 0 | 6 | 33 | 33 | 0 | 0 | 0 | 30-Oct-21 | 55.5 | 3-1-8 | |||
11 | BEAN HOT | 55.0 | 51x31 | 4 | 4 | L MAGORRIAN | BRETT ROBB | 4 | G | 2.7 | 2.8 | 0 | 20 | -2.0 | 100 | $6,955 | $6,955 | 58.5 | -0.5 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 8 | 38 | 75 | 3 | 3 | 8 | 38 | 75 | 0 | 0 | 0 | 30-Oct-21 | 55 | 3-3-8 | 3 | 2 | |
12 | CLOUD FACTORY | 55.0 | 5441x | 5 | 5 | MS K O'HARA | S EDWARDS | 5 | G | 2.3 | 2.0 | 0 | 349 | 0.0 | -200 | $4,347 | $6,150 | 59.0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 12 | 25 | 33 | 1 | 0 | 2 | 50 | 50 | 0 | 1 | 1 | 30-Oct-21 | 55 | 3-1-12 | 3 | 2 | ||
13 | KING'S TRUST | 55.0 | 030x8 | 17 | 16 | BROCK RYAN | 2 | T ROBINSON | 6 | G | 3.4 | 3.2 | 10 | 14 | 0.5 | 100 | $5,886 | $5,908 | 56.5 | 4.0 | 0 | 0 | 2 | 0 | 0 | 2 | 4 | 19 | 11 | 32 | 1 | 2 | 12 | 8 | 25 | 0 | 1 | 4 | 30-Oct-21 | 53 | 2-4-19 | 1 | 0 |
14 | SHELBY SIXTYSIX | 55.0 | 4x703 | 15 | 15 | J R COLLETT | D J WILLIAMS | 5 | G | 2.8 | 1.8 | 7 | 14 | -5.0 | 0 | $4,880 | $2,675 | 58.5 | 0.0 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 11 | 18 | 64 | 0 | 3 | 6 | 0 | 50 | 0 | 0 | 1 | 30-Oct-21 | 55 | 2-5-11 | |||
15 | ALL FORMIDABLE | 54.5 | 21041 | 8 | 8 | J INNES JNR | K DRYDEN | 4 | G | 2.6 | 1.7 | 0 | 8 | -3.5 | 0 | $5,117 | $5,117 | 58.0 | 2.5 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 6 | 33 | 50 | 2 | 1 | 6 | 33 | 50 | 0 | 0 | 0 | 30-Oct-21 | 54.5 | 2-1-6 | 2.5 | 1.5 | |
16 | TESTATOR SILENS | 54.5 | 1x1 | 13 | 13 | JEAN VAN OVERMEIRE | LUKE CLARKE | 4 | G | 1.8 | 2.1 | 0 | 42 | -4.5 | 200 | $11,740 | $11,740 | 59.0 | 0.5 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 100 | 100 | 2 | 0 | 2 | 100 | 100 | 0 | 0 | 0 | 30-Oct-21 | 54.5 | 2-0-2 | 2.5 | 1.5 | |
17 | THE SNOOPERSTAR | 54.5 | 2040x | 16 | - | MARK SCHMETZER | 5 | G | - | 2.5 | 11 | 154 | -1.0 | -200 | $3,265 | $1,833 | 59.0 | 0 | 0 | 0 | 0 | 0 | 3 | 6 | 25 | 12 | 36 | 0 | 2 | 9 | 0 | 22 | 0 | 0 | 3 | 30-Oct-21 | 54.5 | 3-6-25 | |||||
18 | RAPIDITY | 54.0 | x1413 | 12 | 12 | J FORD | JAMIE STEWART | 6 | M | 1.7 | 2.4 | 1 | 41 | -2.0 | -200 | $3,359 | $4,623 | 58.0 | 1.0 | 0 | 1 | 1 | 0 | 100 | 3 | 6 | 19 | 16 | 47 | 2 | 4 | 9 | 22 | 67 | 0 | 0 | 0 | 30-Oct-21 | 54 | 3-6-19 |
RACE DATA#1 (Race 1-2)
Horse No. | Horse | Weight | Recent Form | Barrier | BP Adj | Jockey | Jockey Allowance | Trainer | Age | Sex | Jockey Rating | Trainer Rating | Runs Since Last Win | Days Since Last Run | Weight Change | Distance Change | Average Prizemoney - Career | Average Prizemoney - Last 12m | Highest Winning Weight | Degree of Difficulity | Jockey & Horse Wins | Jockey & Horse Places | Jockey & Horse Starts | Jockey & Horse Win% | Jockey & Horse Place% | Career Wins | Career Places | Career Starts | Career Win% | Career Place% | Career Last 12m Wins | Career Last 12m Places | Career Last 12m Starts | Career Last 12m - Win% | Career Last 12m - Place% | Course Wins | Course Place | Course Starts | Date | Carry Weight | Career | Weight above Minimum | Minimum weight should be |
1 | GEORGIE'S PRIDE | 61.0 | 19x33 | 2 | 2 | J BYRNE | D FORSTER | 4 | M | 4.1 | 3.2 | 3 | 14 | 7.0 | 0 | $15,579 | $21,950 | 59.0 | 3.5 | 4 | 3 | 8 | 50 | 88 | 6 | 4 | 14 | 43 | 71 | 5 | 3 | 9 | 56 | 89 | 0 | 0 | 0 | 30-Oct-21 | 61 | 6-4-14 | 10 | 8 | |
2 | KATALIN | 59.0 | 0x15x | 3 | 3 | N RAWILLER | JAMES CUMMINGS | 5 | M | 4.4 | 3.7 | 1 | 133 | 0.0 | -100 | $11,669 | $13,638 | 58.0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 6 | 50 | 50 | 1 | 0 | 2 | 50 | 50 | 0 | 0 | 1 | 30-Oct-21 | 59 | 3-0-6 | 8 | 6 | ||
3 | SELBUROSE | 59.0 | 03221 | 7 | 7 | H BOWMAN | C WALLER | 4 | M | 3.5 | 4.1 | 0 | 56 | 2.5 | 100 | $13,654 | $16,675 | 57.5 | 0.0 | 0 | 0 | 0 | 0 | 0 | 3 | 6 | 14 | 21 | 64 | 3 | 3 | 10 | 30 | 60 | 0 | 0 | 1 | 30-Oct-21 | 59 | 3-6-14 | 8 | 6 | |
4 | SELEQUE | 57.0 | 1244x | 4 | 4 | TOMMY BERRY | C WALLER | 4 | M | 4.2 | 4.1 | 3 | 66 | -2.5 | -50 | $8,612 | $10,605 | 59.0 | 1 | 1 | 4 | 25 | 50 | 3 | 5 | 12 | 25 | 67 | 3 | 2 | 8 | 38 | 62 | 0 | 0 | 0 | 30-Oct-21 | 57 | 3-5-12 | ||||
5 | JUST FIELD | 56.5 | 22905 | 1 | 1 | J PARR | D LANE | 5 | M | 3.6 | 2.6 | 9 | 21 | 1.5 | 200 | $6,728 | $7,218 | 59.5 | 3.5 | 0 | 2 | 3 | 0 | 67 | 3 | 5 | 22 | 14 | 36 | 1 | 2 | 11 | 9 | 27 | 0 | 1 | 2 | 30-Oct-21 | 56.5 | 3-5-22 | 5.5 | 3.5 | |
6 | NEWSREADER | 56.5 | 1x0x8 | 5 | 5 | TIM CLARK | J O'SHEA | 4 | M | 3.5 | 4.3 | 2 | 26 | 0.5 | 0 | $20,221 | $34,325 | 55.5 | 5.5 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 10 | 20 | 50 | 2 | 0 | 5 | 40 | 40 | 0 | 0 | 2 | 30-Oct-21 | 56.5 | 2-3-10 | 5.5 | 3.5 | |
7 | BOWERY BREEZE | 56.5 | 26825 | 8 | 8 | MS K O'HARA | P & M CAVE | 5 | M | 2.3 | 1.9 | 5 | 14 | 2.0 | -200 | $8,876 | $11,400 | 56.5 | 2.0 | 3 | 3 | 13 | 23 | 46 | 4 | 7 | 24 | 17 | 46 | 2 | 3 | 13 | 15 | 38 | 0 | 0 | 0 | 30-Oct-21 | 56.5 | 4-7-24 | 5.5 | 3.5 | |
8 | LADY BROOK | 56.0 | 4x125 | 6 | 6 | TYLER SCHILLER | 3 | J PRIDE | 5 | M | 2.4 | 3.5 | 2 | 17 | -4.0 | 100 | $7,142 | $7,279 | 60.0 | 5.0 | 2 | 0 | 3 | 67 | 67 | 5 | 5 | 14 | 36 | 71 | 3 | 3 | 10 | 30 | 60 | 0 | 0 | 0 | 30-Oct-21 | 53 | 5-5-14 | 2 | 0 |
9 | ZOROCAT | 56.0 | 21374 | 9 | 9 | J R COLLETT | D LANE | 4 | M | 2.8 | 2.6 | 3 | 17 | 0.5 | 0 | $10,595 | $13,039 | 56.5 | 6.0 | 1 | 1 | 3 | 33 | 67 | 3 | 7 | 15 | 20 | 67 | 2 | 5 | 10 | 20 | 70 | 0 | 1 | 2 | 30-Oct-21 | 56 | 3-7-15 | |||
1 | MILK MAN | 61.0 | 40231 | 9 | - | J DUGGAN | M SMITH | 7 | G | 2.5 | 2.1 | 0 | 17 | 3.0 | 300 | $8,599 | $5,891 | 58.0 | 1.0 | 1 | 0 | 1 | 100 | 100 | 4 | 10 | 30 | 13 | 47 | 1 | 3 | 11 | 9 | 36 | 0 | 0 | 4 | 30-Oct-21 | 61 | 4-10-30 | |||
2 | MIGHTYBEEL | 59.5 | 4x411 | 8 | 7 | H BOWMAN | C WALLER | 4 | G | 2.5 | 4.3 | 0 | 10 | -1.0 | 100 | $10,245 | $11,278 | 60.5 | 2.5 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 9 | 33 | 56 | 3 | 2 | 8 | 38 | 62 | 1 | 0 | 1 | 30-Oct-21 | 59.5 | 3-2-9 | 7.5 | 7.5 | |
3 | PROMPT PRODIGY | 59.0 | 0x798 | 3 | - | G SCHOFIELD | EDWARD CUMMINGS | 4 | H | 1.9 | 2.6 | 7 | 28 | 4.0 | 300 | $6,477 | $6,889 | 57.5 | 6.0 | 0 | 0 | 1 | 0 | 0 | 1 | 5 | 14 | 7 | 43 | 1 | 4 | 12 | 8 | 42 | 0 | 1 | 1 | 30-Oct-21 | 59 | 1-5-14 | |||
4 | MARGIE BEE | 57.5 | 03162 | 2 | 2 | J PARR | K BUCHANAN | 6 | M | 2.5 | 3.0 | 2 | 15 | -1.5 | 300 | $6,469 | $8,622 | 58.5 | 2.0 | 0 | 0 | 1 | 0 | 0 | 8 | 13 | 43 | 19 | 49 | 4 | 7 | 19 | 21 | 58 | 0 | 0 | 1 | 30-Oct-21 | 57.5 | 8-13-43 | 5.5 | 5.5 | |
5 | SOLAR APEX | 57.5 | 0x113 | 6 | 5 | TOMMY BERRY | C WALLER | 4 | G | 4.3 | 4.3 | 1 | 21 | 0.5 | -100 | $9,668 | $10,681 | 59.0 | 0.5 | 0 | 3 | 3 | 0 | 100 | 3 | 8 | 13 | 23 | 85 | 3 | 6 | 11 | 27 | 82 | 0 | 1 | 1 | 30-Oct-21 | 57.5 | 3-8-13 | 5.5 | 5.5 | |
6 | LORD ARDMORE | 57.5 | 90x57 | 1 | 1 | L MAGORRIAN | C WALLER | 4 | G | 2.5 | 4.3 | 8 | 7 | -0.5 | 300 | $5,422 | $6,720 | 56.0 | 3.0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 11 | 9 | 18 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 30-Oct-21 | 57.5 | 1-1-11 | 5.5 | 5.5 | |
7 | FORTIFIED | 55.5 | 81663 | 5 | 4 | BROCK RYAN | 2 | C WALLER | 4 | G | 2.2 | 4.3 | 3 | 3 | -4.0 | 0 | $9,554 | $9,554 | 59.0 | -1.0 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 12 | 33 | 58 | 4 | 3 | 12 | 33 | 58 | 0 | 0 | 0 | 30-Oct-21 | 53.5 | 4-3-12 | ||
8 | DINADO | 54.0 | 55821 | 4 | 3 | J R COLLETT | R & M FREEDMAN | 5 | M | 2.9 | 3.3 | 0 | 7 | -1.0 | 300 | $5,825 | $6,812 | 55.5 | 1.0 | 0 | 0 | 0 | 0 | 0 | 4 | 5 | 23 | 17 | 39 | 2 | 3 | 14 | 14 | 36 | 0 | 0 | 0 | 30-Oct-21 | 54 | 4-5-23 | 2 | 2 | |
9 | APACHE BELLE | 52.0 | 15345 | 7 | 6 | MS K O'HARA | W SEELIN | 6 | M | 1.8 | 2.5 | 4 | 10 | -5.0 | 350 | $3,756 | $5,230 | 59.5 | 2.5 | 0 | 1 | 4 | 0 | 25 | 7 | 9 | 38 | 18 | 42 | 4 | 4 | 16 | 25 | 50 | 0 | 0 | 1 | 30-Oct-21 | 52 | 7-9-38 | 0 | 0 |
NEURAL MSTR
3 | TAMPERING | JIM BYRNE | 8 | KERRY PARKER | 60 | 11 | 22 | 113 | 23 | 8 | 8 | 10 | 0 | 6 | 4 | 9 | 10 | 0 | 222.5 | $4.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
15 | DUFRESNE | TYLER SCHILLER | 5 | ANTHONY CUMMINGS | 54.5 | 81 | 34 | 10 | 5 | 5 | 8 | 12 | 0 | 10 | 6 | 13 | 20 | 0 | 203.5 | $5.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
4 | DIFFERENT STROKES | HUGH BOWMAN | 1 | KIM WAUGH | 59.5 | 13 | 27 | 14 | 18 | 10 | 18 | 15 | 0 | 5 | 6 | 22 | 15 | 0 | 162 | $7.50 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
14 | KOBESTAR | TOMMY BERRY | 18 | R & L PRICE | 55 | 6 | 5 | 76 | 20 | 3 | 18 | 6 | 0 | 2 | 5 | 6 | 14 | 0 | 160 | $8.50 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
1 | BAROSSA ROSA | JENNY DUGGAN | 15 | TRACEY BARTLEY | 61 | 11 | 23 | 1 | 5 | 28 | 8 | 5 | 0 | 10 | 5 | 16 | 16 | 0 | 127 | $12.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
2 | DALAALAAT | LEE MAGORRIAN | 14 | NATHAN DOYLE | 60 | 10 | 20 | 1 | 10 | 30 | 10 | 9 | 0 | 8 | 5 | 10 | 11 | 0 | 124 | $14.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
16 | KISS SUM | JASON COLLETT | 4 | TRACEY BARTLEY | 54 | 8 | 5 | 1 | 15 | 28 | 15 | 13 | 0 | 4 | 5 | 8 | 18 | 0 | 119.5 | $17.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
11 | DARALINA BELLE | TIM CLARK | 6 | MATTHEW SMITH | 57 | 12 | 22 | 1 | 10 | 10 | 10 | 12 | 0 | 5 | 5 | 15 | 16 | 0 | 118 | $21.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
7 | REBEL RAMA | ROBBIE DOLAN | 2 | MARC CONNERS | 58 | 20 | 22 | 1 | 3 | 3 | 8 | 14 | 0 | 8 | 5 | 12 | 16 | 0 | 110.5 | $26.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
5 | GRACE BAY | JOSH PARR | 13 | CLAIRE LEVER | 58.5 | 10 | 12 | 1 | 10 | 23 | 8 | 8 | 0 | 5 | 5 | 10 | 18 | 0 | 109 | $31.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
6 | HIGHLY DESIRED | KATHY O'HARA | 7 | CLAIRE LEVER | 58.5 | 12 | 22 | 1 | 3 | 23 | 3 | 11 | 0 | 5 | 5 | 7 | 15 | 0 | 105.5 | $41.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
12 | CONRAD | ALYSHA COLLETT | 9 | KIM WAUGH | 55.5 | 13 | 8 | 1 | 10 | 10 | 10 | 10 | 0 | 4 | 5 | 14 | 18 | 0 | 103 | $41.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
20 | CAESARS PALACE | BRODIE LOY | 12 | ANTHONY CUMMINGS | 57.5 | 7 | 7 | 7 | 15 | 5 | 8 | 7 | 0 | 4 | 6 | 7 | 18 | 0 | 90.5 | $61.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
8 | CREAM RISES | NASH RAWILLER | 16 | KYLIE GAVENLOCK | 58 | 8 | 5 | 1 | 20 | 3 | 5 | 9 | 0 | 5 | 5 | 11 | 15 | 0 | 86.5 | $81.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
21 | DOM TYCOON | JAY FORD | 17 | PETER ROBL | 56.5 | 7 | 7 | 7 | 3 | 15 | 8 | 3 | 0 | 5 | 5 | 6 | 18 | 0 | 83 | $81.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
9 | TOO GOOD TO BE TRU | ANDREW ADKINS | 11 | DAMIEN LANE | 58 | 7 | 5 | 14 | 3 | 3 | 3 | 9 | 0 | 7 | 6 | 8 | 15 | 0 | 78.5 | $101.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
18 | VERBEK | JEAN VAN OVERMEIRE | 3 | R & L PRICE | 53 | 11 | 12 | 2 | 3 | 3 | 3 | 12 | 0 | 2 | 5 | 9 | 18 | 0 | 78.5 | $101.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
17 | DIVINE BREATH | BROCK RYAN | 10 | THERESA BATEUP | 53.5 | 10 | 2 | 1 | 5 | 3 | 13 | 9 | 0 | 5 | 5 | 8 | 15 | 0 | 75 | $201.00 | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
10 | SUNBORN | GLYN SCHOFIELD | - | EDWARD CUMMINGS | 57.5 | 6 | 7 | 1 | 5 | 10 | 7.5 | 0 | 2 | 2 | 5 | 14 | 10 | 0 | scr | scr | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
13 | ALL MACHIAVELLIAN | JAY FORD | - | GREGORY HICKMAN | 55 | 13 | 17 | 1 | 2.5 | 10 | 7.5 | 0 | 1 | 4 | 5 | 12 | 16 | 0 | scr | scr | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
19 | CANYONERO | - | RICHARD LITT | 61 | 8 | 17 | 56 | 7.5 | 2.5 | 7.5 | 8 | 10 | 5 | 5 | 9 | 16 | 0 | scr | scr | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good | |
22 | HEZA GENTLEMAN | - | M & D KEARNEY | 57 | 6 | 6 | 6 | 7.5 | 2.5 | 7.5 | 0 | 8 | 5 | 5 | 4 | 16 | 0 | scr | scr | 4 | Rosehill | 30-Oct-21 | 14:40 | THE FOUR PILLARS (BM68) | 1500m | 3U BM68 | AUD $700,000 | 18 | Good |
NEURAL MSTR (races 1-3)
Horse No. | Horse | Jockey | Barrier | Trainer | Weight Performance (algo) | Career Performance Assessment (based on weight/class algo) | Current Form (measured by class/weight algo) | Revolutionary Time Assessment (adjust algo) | Jockey Ability (algo) | Trainer Ability (algo) | Jockey/Trainer Combination (algo) | Barrier Position (algo) | Wet Track Performance (algo) | Course Suitability (algo) | Distance Suitable (algo) | Prizemoney Earned (algo) | Days since Last Run (algo) | HCP | Neural Rating | Price Rating | Race No. | Course | Date | Race Time | Race Name | Distance | Class | Prize Money | Starters | Track Conditions |
1 | GEORGIE'S PRIDE | JIM BYRNE | 2 | DESLEIGH FORSTER | 61 | 32 | 29 | 10 | 23 | 18 | 23 | 14 | 0 | 13 | 21 | 17 | 16 | 0 | 214.5 | $3.00 | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
3 | SELBUROSE | HUGH BOWMAN | 6 (7) | CHRIS WALLER | 59 | 16 | 1 | 44 | 18 | 28 | 8 | 11 | 0 | 5 | 20 | 15 | 6 | 0 | 170.5 | $4.40 | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
6 | NEWSREADER | TIM CLARK | 4 (5) | JOHN O'SHEA | 56.5 | 16 | 2 | 22 | 10 | 23 | 8 | 13 | 0 | 11 | 10 | 22 | 14 | 0 | 150 | $5.50 | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
7 | BOWERY BREEZE | KATHY O'HARA | 7 (8) | P & M CAVE | 56.5 | 12 | 27 | 18 | 3 | 8 | 5 | 10 | 0 | 13 | 19 | 10 | 16 | 0 | 140 | $7.00 | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
5 | JUST FIELD | JOSH PARR | 1 | DAMIEN LANE | 56.5 | 16 | 23 | 6 | 10 | 3 | 3 | 15 | 0 | 17 | 8 | 7 | 15 | 0 | 122 | $9.00 | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
8 | LADY BROOK | TYLER SCHILLER | 5 (6) | JOSEPH PRIDE | 56 | 5 | 12 | 5 | 5 | 18 | 5 | 12 | 0 | 13 | 14 | 8 | 16 | 0 | 112.5 | $12.00 | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
2 | KATALIN | NASH RAWILLER | 3 | JAMES CUMMINGS | 59 | 5 | 1 | 1 | 20 | 23 | 10 | 14 | 0 | 17 | 3 | 13 | 1 | 0 | 107.5 | $14.00 | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
4 | SELEQUE | TOMMY BERRY | - | CHRIS WALLER | 57 | 8 | 1 | 7 | 20 | 27.5 | 20 | 13 | 13 | 13 | 7 | 9 | 4 | 0 | scr | scr | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
9 | ZOROCAT | JASON COLLETT | - | DAMIEN LANE | 56 | 5 | 21 | 4 | 15 | 2.5 | 2.5 | 10 | 14 | 15 | 13 | 12 | 16 | 0 | scr | scr | 1 | Rosehill | 30-Oct-21 | 12:40 | THE AGENCY REAL ESTATE (BM78) | 1200m | 3UFM BM78 | AUD $130,000 | 7 | Good |
5 | SOLAR APEX | TOMMY BERRY | 4 (6) | CHRIS WALLER | 57.5 | 11 | 17 | 5 | 20 | 28 | 20 | 15 | 0 | 8 | 25 | 21 | 15 | 0 | 184.5 | $3.10 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
2 | MIGHTYBEEL | HUGH BOWMAN | 6 (8) | CHRIS WALLER | 59.5 | 11 | 15 | 7 | 18 | 28 | 8 | 15 | 0 | 26 | 15 | 22 | 18 | 0 | 181.5 | $3.70 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
4 | MARGIE BEE | JOSH PARR | 2 | KRISTEN BUCHANAN | 57.5 | 5 | 13 | 13 | 10 | 33 | 3 | 12 | 0 | 11 | 20 | 14 | 16 | 0 | 149 | $5.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
6 | LORD ARDMORE | LEE MAGORRIAN | 1 | CHRIS WALLER | 57.5 | 24 | 1 | 1 | 10 | 28 | 8 | 13 | 0 | 12 | 12 | 12 | 20 | 0 | 140 | $6.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
8 | DINADO | JASON COLLETT | 3 (4) | R & M FREEDMAN | 54 | 4 | 16 | 8 | 15 | 8 | 3 | 14 | 0 | 12 | 10 | 13 | 20 | 0 | 122 | $8.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
9 | APACHE BELLE | KATHY O'HARA | 5 (7) | WAYNE SEELIN | 52 | 4 | 9 | 1 | 3 | 3 | 3 | 13 | 0 | 4 | 4 | 8 | 18 | 0 | 68.5 | $17.00 | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
1 | MILK MAN | JENNY DUGGAN | - | MATTHEW SMITH | 61 | 11 | 21 | 1 | 5 | 10 | 15 | 10 | 29 | 13 | 4 | 18 | 16 | 0 | scr | scr | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
3 | PROMPT PRODIGY | GLYN SCHOFIELD | - | EDWARD CUMMINGS | 59 | 5 | 1 | 1 | 5 | 10 | 7.5 | 14 | 17 | 16 | 12 | 14 | 13 | 0 | scr | scr | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
7 | FORTIFIED | BROCK RYAN | - | CHRIS WALLER | 55.5 | 29 | 20 | 14 | 5 | 27.5 | 7.5 | 13 | 8 | 12 | 13 | 21 | 20 | 0 | scr | scr | 2 | Rosehill | 30-Oct-21 | 13:20 | FUJITSU GENERAL (BM78) | 1900m | 3U BM78 | AUD $130,000 | 6 | Good |
11 | BEAN HOT | LEE MAGORRIAN | 4 | BRETT ROBB | 55 | 7 | 17 | 48 | 10 | 30 | 8 | 13 | 0 | 6 | 2 | 13 | 15 | 0 | 168.5 | $4.20 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
2 | ICE IN VANCOUVER | TYLER SCHILLER | 2 | CODY MORGAN | 60 | 46 | 26 | 7 | 5 | 5 | 8 | 14 | 0 | 6 | 8 | 20 | 16 | 0 | 160.5 | $5.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
3 | CASINO KID | ALYSHA COLLETT | 10 (11) | JAN BOWEN | 58 | 7 | 15 | 58 | 10 | 8 | 8 | 10 | 0 | 6 | 4 | 13 | 16 | 0 | 154 | $6.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
4 | CEASEFIRE | ROBBIE DOLAN | 3 | PAUL MESSARA | 58 | 23 | 22 | 5 | 3 | 23 | 15 | 14 | 0 | 6 | 6 | 19 | 16 | 0 | 151 | $7.50 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
6 | BLOW DART | TIM CLARK | 9 (10) | BRETT THOMPSON | 56.5 | 30 | 20 | 1 | 10 | 3 | 8 | 10 | 0 | 5 | 6 | 17 | 16 | 0 | 125 | $10.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
8 | TEJORI | TOMMY BERRY | 1 | NICK OLIVE | 56 | 6 | 2 | 3 | 20 | 10 | 3 | 15 | 0 | 6 | 9 | 14 | 18 | 0 | 105.5 | $14.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
9 | BRAVE ENOUGH | JENNY DUGGAN | 7 | CODY MORGAN | 56 | 7 | 14 | 6 | 5 | 5 | 8 | 10 | 0 | 6 | 11 | 8 | 20 | 0 | 99.5 | $17.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
16 | TESTATOR SILENS | JEAN VAN OVERMEIRE | 11 (13) | LUKE CLARKE | 54.5 | 6 | 10 | 1 | 3 | 15 | 8 | 10 | 0 | 6 | 6 | 22 | 10 | 0 | 96 | $20.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
5 | PRIVATE AGENT | BRODIE LOY | 12 (14) | KURT GOLDMAN | 57 | 6 | 13 | 8 | 15 | 3 | 3 | 7 | 0 | 6 | 6 | 13 | 16 | 0 | 95 | $26.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
15 | ALL FORMIDABLE | JAMES P INNES | 8 | KEITH DRYDEN | 54.5 | 5 | 4 | 9 | 5 | 13 | 8 | 9 | 0 | 6 | 3 | 10 | 20 | 0 | 91 | $31.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
12 | CLOUD FACTORY | KATHY O'HARA | 5 | STEPHEN EDWARDS | 55 | 3 | 0 | 1 | 3 | 30 | 8 | 12 | 0 | 8 | 3 | 8 | 1 | 0 | 76 | $41.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
7 | BELLASTAR | ANDREW ADKINS | 6 | COLT PROSSER | 56.5 | 5 | 1 | 5 | 3 | 3 | 8 | 11 | 0 | 5 | 10 | 10 | 16 | 0 | 75.5 | $41.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
13 | KING'S TRUST | BROCK RYAN | 13 (17) | TERRY ROBINSON | 55 | 5 | 4 | 5 | 5 | 3 | 3 | 7 | 0 | 8 | 6 | 11 | 16 | 0 | 72 | $61.00 | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
1 | BRANDERS RULE | JACK MARTIN | - | MITCHELL BEER | 60 | 6 | 10 | 4 | 5 | 10 | 2.5 | 5 | 7 | 6 | 6 | 11 | 14 | 0 | scr | scr | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
10 | CHEVCONI | JOSH PARR | - | GAYNA WILLIAMS | 55.5 | 6 | 12 | 1 | 10 | 25 | 7.5 | 10 | 7 | 6 | 9 | 11 | 16 | 0 | scr | scr | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
14 | SHELBY SIXTYSIX | JASON COLLETT | - | DANNY WILLIAMS | 55 | 6 | 2 | 8 | 15 | 2.5 | 5 | 5 | 7 | 7 | 9 | 9 | 16 | 0 | scr | scr | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
17 | THE SNOOPERSTAR | - | MARK SCHMETZER | 54.5 | 4 | 1 | 9 | 7.5 | 30 | 7.5 | 5 | 7 | 6 | 5 | 6 | 1 | 0 | scr | scr | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good | |
18 | RAPIDITY | JAY FORD | - | JAMIE STEWART | 54 | 5 | 12 | 7 | 2.5 | 17.5 | 7.5 | 7 | 7 | 6 | 5 | 6 | 10 | 0 | scr | scr | 3 | Rosehill | 30-Oct-21 | 14:00 | TAB HIGHWAY HCP (C3) | 1200m | 3U CL3 | AUD $100,000 | 13 | Good |
Hi, That's strange but it was only one race and today it is showing correctly for me as well. I have expanded the datasets to show 4 races. Two look to be right and two are wrong. When I import the datasets into Power BI for the 'Neurals Mstr' data you will see some horses have a "scr" in their row which means that horse is scratched from the race and not running so I filter them out of the data. These same horses show in the Race Data#1 dataset as well but I use the Neural Mstr dataset for horse name. Anyway here is a wider set of data and current output. Hopefully, you can see the issue I'm referring to but for the two races that are incorrect it looks like it is due to the horse with the lowest weight isn't showing as 0.
Due to size limits reply in a few messages sorry
But do you have a single table for RACE DATA#1? Or is it split into several tables, as in your latest pasted examples?
Regards
Hi, yes single table. I had to split it like that due to size as it was to big and wouldn't let me send the message as one, hence why i broke it up. Sorry about that.
Hi, yes single table. I had to split it like that due to size as it was to big and wouldn't let me send the message as one, hence why i broke it up. Sorry about that.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |