DMR 2017 Leading up to the Breeders Cup -- Dirt -- query start: 11/1/2019 9:37:07 AM query end: 11/1/2019 9:37:08 AM elapsed time: 1 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2_sav-CURR-10302019.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE TRACK='DMR' AND INTSURFACE=1 AND [DATE] >= #07-19-2017# AND [DATE] <= #11-02-2017# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 2868.80 2776.40 2682.20 Bet -3376.00 -3376.00 -3376.00 ----------------------------------------------------- P/L -507.20 -599.60 -693.80 Wins 207 414 616 Plays 1688 1688 1688 PCT .1226 .2453 .3649 ROI 0.8498 0.8224 0.7945 Avg Mut 13.86 6.71 4.35 By: SQL-F18 Rank (Compound AP) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -148.00 444.00 0.6667 39 222 .1757 1.4326 7.59 2 -14.80 444.00 0.9667 39 222 .1757 1.4326 11.01 <-- 3 -28.20 472.00 0.9403 40 236 .1695 1.3821 11.10 <-- 4 84.20 460.00 1.1830 30 230 .1304 1.0636 18.14 <-- 5 -148.20 434.00 0.6585 21 217 .0968 0.7892 13.61 6 -102.00 402.00 0.7463 17 201 .0846 0.6897 17.65 7 -86.80 284.00 0.6944 10 142 .0704 0.5743 19.72 8 3.60 194.00 1.0186 5 97 .0515 0.4203 39.52 9 37.00 138.00 1.2681 6 69 .0870 0.7091 29.17 10 -72.00 72.00 0.0000 0 36 .0000 0.0000 0.00 11 -26.00 26.00 0.0000 0 13 .0000 0.0000 0.00 12 -6.00 6.00 0.0000 0 3 .0000 0.0000 0.00 By: SQL-F19 Rank (Early Consensus) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -129.80 436.00 0.7023 39 218 .1789 1.4588 7.85 2 -116.20 426.00 0.7272 28 213 .1315 1.0720 11.06 3 110.20 412.00 1.2675 38 206 .1845 1.5042 13.74 <-- 4 -166.40 410.00 0.5941 19 205 .0927 0.7558 12.82 5 -36.60 416.00 0.9120 26 208 .1250 1.0193 14.59 6 27.40 374.00 1.0733 19 187 .1016 0.8285 21.13 7 -43.00 328.00 0.8689 15 164 .0915 0.7458 19.00 8 -44.20 248.00 0.8218 11 124 .0887 0.7234 18.53 9 -9.40 184.00 0.9489 10 92 .1087 0.8864 17.46 10 -67.20 110.00 0.3891 2 55 .0364 0.2965 21.40 11 -20.00 20.00 0.0000 0 10 .0000 0.0000 0.00 12 -12.00 12.00 0.0000 0 6 .0000 0.0000 0.00 By: SQL-F20 Rank (CPace) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -71.60 414.00 0.8271 40 207 .1932 1.5758 8.56 2 -20.60 416.00 0.9505 38 208 .1827 1.4898 10.41 3 -173.60 414.00 0.5807 22 207 .1063 0.8667 10.93 4 42.20 414.00 1.1019 29 207 .1401 1.1424 15.73 5 -164.80 412.00 0.6000 20 206 .0971 0.7917 12.36 6 44.40 380.00 1.1168 18 190 .0947 0.7725 23.58 7 26.40 332.00 1.0795 19 166 .1145 0.9334 18.86 8 -144.40 258.00 0.4403 10 129 .0775 0.6321 11.36 9 54.80 194.00 1.2825 9 97 .0928 0.7566 27.64 10 -64.00 106.00 0.3962 2 53 .0377 0.3077 21.00 11 -24.00 24.00 0.0000 0 12 .0000 0.0000 0.00 12 -12.00 12.00 0.0000 0 6 .0000 0.0000 0.00 By: SQL-F15 Rank (HDW Distance Pedigree) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -25.40 426.00 0.9404 32 213 .1502 1.2251 12.52 2 161.20 412.00 1.3913 34 206 .1650 1.3459 16.86 3 -74.40 426.00 0.8254 31 213 .1455 1.1868 11.34 4 -163.60 406.00 0.5970 24 203 .1182 0.9641 10.10 5 -193.00 410.00 0.5293 20 205 .0976 0.7956 10.85 6 -6.40 386.00 0.9834 28 193 .1451 1.1830 13.56 7 132.40 314.00 1.4217 22 157 .1401 1.1427 20.29 8 -97.00 264.00 0.6326 7 132 .0530 0.4324 23.86 9 -117.80 192.00 0.3865 7 96 .0729 0.5946 10.60 10 -87.20 104.00 0.1615 2 52 .0385 0.3136 8.40 11 -24.00 24.00 0.0000 0 12 .0000 0.0000 0.00 12 -12.00 12.00 0.0000 0 6 .0000 0.0000 0.00 By: SQL-F22 Rank (Late Consensus) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -20.00 498.00 0.9598 46 249 .1847 1.5065 10.39 <-- 2 -165.20 448.00 0.6313 30 224 .1339 1.0921 9.43 3 4.60 532.00 1.0086 39 266 .1466 1.1956 13.76 4 35.40 424.00 1.0835 26 212 .1226 1.0001 17.67 5 -114.00 416.00 0.7260 19 208 .0913 0.7449 15.89 6 -58.60 346.00 0.8306 19 173 .1098 0.8956 15.13 7 -51.20 266.00 0.8075 12 133 .0902 0.7358 17.90 8 -68.00 174.00 0.6092 4 87 .0460 0.3749 26.50 9 -77.40 164.00 0.5280 6 82 .0732 0.5967 14.43 10 -27.40 74.00 0.6297 3 37 .0811 0.6612 15.53 11 46.60 22.00 3.1182 3 11 .2727 2.2240 22.87 12 -12.00 12.00 0.0000 0 6 .0000 0.0000 0.00