--1. ALL TRACKS: query start: 6/27/2022 9:55:13 AM query end: 6/27/2022 9:56:01 AM elapsed time: 48 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE [DATE] >= #01-01-2022# AND [DATE] <= #06-26-2022# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 176553.30 175045.80 173941.00 Bet -233810.00 -233810.00 -233810.00 ----------------------------------------------------- P/L -57256.70 -58764.20 -59869.00 Wins 16266 32324 46664 Plays 116905 116905 116905 PCT .1391 .2765 .3992 ROI 0.7551 0.7487 0.7439 Avg Mut 10.85 5.42 3.73 By: SQL-F17 Rank (_RDR_CX10-SURF-DIST-120) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -6230.10 32292.00 0.8071 3210 16146 .1988 1.4289 8.12 2 -7759.80 32398.00 0.7605 2970 16199 .1833 1.3177 8.30 3 -5696.20 32516.00 0.8248 2815 16258 .1731 1.2444 9.53 4 -7528.80 32144.00 0.7658 2253 16072 .1402 1.0075 10.93 5 -6942.90 31120.00 0.7769 1930 15560 .1240 0.8915 12.53 6 -8117.20 27476.00 0.7046 1393 13738 .1014 0.7288 13.90 7 -6294.90 19644.00 0.6796 838 9822 .0853 0.6132 15.93 8 -4142.40 12332.00 0.6641 453 6166 .0735 0.5280 18.08 9 -2708.70 7240.00 0.6259 213 3620 .0588 0.4229 21.27 10 -863.30 4014.00 0.7849 119 2007 .0593 0.4261 26.48 <-- 11 -700.50 1756.00 0.6011 52 878 .0592 0.4257 20.30 12 -365.60 800.00 0.5430 18 400 .0450 0.3234 24.13 13 -39.90 48.00 0.1688 1 24 .0417 0.2995 8.10 14 -18.00 18.00 0.0000 0 9 .0000 0.0000 0.00 15 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.00 16 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.00 17 -2.00 2.00 0.0000 0 1 .0000 0.0000 0.00 18 161.60 2.00 81.8000 1 1 1.0000 7.1871 163.60 <-- 19 -4.00 4.00 0.0000 0 2 .0000 0.0000 0.00 --2. MTH-GGX-SAX-LRC-LAX-PLN-WOX where limited whip rules are in effect: query start: 6/27/2022 9:54:17 AM query end: 6/27/2022 9:54:23 AM elapsed time: 6 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE INSTR('MTH-GGX-SAX-LRC-LAX-PLN-WOX', TRACK) > 0 AND [DATE] >= #01-01-2022# AND [DATE] <= #06-26-2022# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 20915.50 21011.40 20624.80 Bet -27692.00 -27692.00 -27692.00 ----------------------------------------------------- P/L -6776.50 -6680.60 -7067.20 Wins 2004 3979 5719 Plays 13846 13846 13846 PCT .1447 .2874 .4130 ROI 0.7553 0.7588 0.7448 Avg Mut 10.44 5.28 3.61 By: SQL-F17 Rank (_RDR_CX10-SURF-DIST-120) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -843.20 4004.00 0.7894 424 2002 .2118 1.4633 7.45 2 -1166.50 3992.00 0.7078 357 1996 .1789 1.2358 7.91 3 -655.40 4004.00 0.8363 346 2002 .1728 1.1941 9.68 4 -909.50 3976.00 0.7713 273 1988 .1373 0.9488 11.23 5 -826.20 3836.00 0.7846 262 1918 .1366 0.9438 11.49 6 -1171.30 3238.00 0.6383 154 1619 .0951 0.6572 13.42 7 -607.20 2160.00 0.7189 91 1080 .0843 0.5822 17.06 8 -324.80 1258.00 0.7418 57 629 .0906 0.6261 16.37 <-- 9 -174.10 684.00 0.7455 22 342 .0643 0.4445 23.18 10 -33.80 344.00 0.9017 12 172 .0698 0.4820 25.85 <-- 11 -10.50 142.00 0.9261 6 71 .0845 0.5839 21.92 12 -48.00 48.00 0.0000 0 24 .0000 0.0000 0.00 13 -6.00 6.00 0.0000 0 3 .0000 0.0000 0.00 14 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 15 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 16 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 17 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 18 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 19 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 --3. SHIPPING FROM MTH-GGX-SAX-LRC-LAX-PLN-WOX where limited whip rules are in effect to a track other than MTH-GGX-SAX-LRC-LAX-PLN-WOX that has no limited whip rules: query start: 6/27/2022 9:41:30 AM query end: 6/27/2022 9:41:34 AM elapsed time: 4 seconds query start: 6/27/2022 9:46:51 AM query end: 6/27/2022 9:46:53 AM elapsed time: 2 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE INSTR('MTH-GGX-SAX-LRC-LAX-PLN-WOX', TRACKLAST) > 0 AND NOT INSTR('MTH-GGX-SAX-LRC-LAX-PLN-WOX', TRACK) > 0 AND NOT STARTSLIFETIME=0 AND [DATE] >= #01-01-2022# AND [DATE] <= #06-26-2022# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 1424.90 1540.70 1576.90 Bet -2284.00 -2284.00 -2284.00 ----------------------------------------------------- P/L -859.10 -743.30 -707.10 Wins 168 314 447 Plays 1142 1142 1142 PCT .1471 .2750 .3914 ROI 0.6239 0.6746 0.6904 Avg Mut 8.48 4.91 3.53 By: SQL-F17 Rank (_RDR_CX10-SURF-DIST-120) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 -65.00 384.00 0.8307 47 192 .2448 1.6640 6.79 2 -102.50 346.00 0.7038 33 173 .1908 1.2967 7.38 3 -145.60 298.00 0.5114 22 149 .1477 1.0037 6.93 4 -55.80 292.00 0.8089 19 146 .1301 0.8846 12.43 5 -173.30 266.00 0.3485 13 133 .0977 0.6644 7.13 6 -122.70 248.00 0.5052 15 124 .1210 0.8223 8.35 <-- 7 -54.60 182.00 0.7000 14 91 .1538 1.0458 9.10 <-- 8 -85.20 124.00 0.3129 3 62 .0484 0.3289 12.93 9 -68.00 68.00 0.0000 0 34 .0000 0.0000 0.00 10 45.60 44.00 2.0364 2 22 .0909 0.6180 44.80 11 -16.00 16.00 0.0000 0 8 .0000 0.0000 0.00 12 -12.00 12.00 0.0000 0 6 .0000 0.0000 0.00 13 -4.00 4.00 0.0000 0 2 .0000 0.0000 0.00 14 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 15 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 16 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 17 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 18 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 19 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 --4. SHIPPING TO MTH-GGX-SAX-LRC-LAX-PLN-WOX where limited whip rules are in effect from a track other than MTH-GGX-SAX-LRC-LAX-PLN-WOX with no limited whip rules: query start: 6/27/2022 9:48:57 AM query end: 6/27/2022 9:49:02 AM elapsed time: 5 seconds Data Window Settings: Connected to: C:\JCapper\exe\JCapper2.mdb 999 Divisor Odds Cap: None SQL UDM Plays Report: Hide SQL: SELECT * FROM STARTERHISTORY WHERE INSTR('MTH-GGX-SAX-LRC-LAX-PLN-WOX', TRACK) > 0 AND NOT INSTR('MTH-GGX-SAX-LRC-LAX-PLN-WOX', TRACKLAST) > 0 AND NOT STARTSLIFETIME=0 AND [DATE] >= #01-01-2022# AND [DATE] <= #06-26-2022# ORDER BY [DATE], TRACK, RACE Data Summary Win Place Show ----------------------------------------------------- Mutuel Totals 2887.20 3014.30 2917.20 Bet -3838.00 -3838.00 -3838.00 ----------------------------------------------------- P/L -950.80 -823.70 -920.80 Wins 304 575 805 Plays 1919 1919 1919 PCT .1584 .2996 .4195 ROI 0.7523 0.7854 0.7601 Avg Mut 9.50 5.24 3.62 By: SQL-F17 Rank (_RDR_CX10-SURF-DIST-120) Rank P/L Bet Roi Wins Plays Pct Impact AvgMut ---------------------------------------------------------------------------------- 1 8.00 566.00 1.0141 78 283 .2756 1.7398 7.36 2 -99.60 554.00 0.8202 55 277 .1986 1.2534 8.26 3 -184.30 574.00 0.6789 48 287 .1672 1.0557 8.12 4 -129.50 550.00 0.7645 35 275 .1273 0.8034 12.01 5 -140.10 524.00 0.7326 35 262 .1336 0.8433 10.97 <-- 6 -141.30 394.00 0.6414 24 197 .1218 0.7690 10.53 7 -138.00 316.00 0.5633 11 158 .0696 0.4395 16.18 8 -12.20 182.00 0.9330 11 91 .1209 0.7630 15.44 <-- 9 -66.00 104.00 0.3654 5 52 .0962 0.6070 7.60 10 -25.80 52.00 0.5038 2 26 .0769 0.4856 13.10 11 -16.00 16.00 0.0000 0 8 .0000 0.0000 0.00 12 -6.00 6.00 0.0000 0 3 .0000 0.0000 0.00 13 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 14 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 15 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 16 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 17 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 18 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 19 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00