Quality Control check

[Tom]

CAn someone with a database let me know how many starts at Aqueduct since it opened for the fall meet in 2010 until Friday, for

Ryan Curatolo
Rajiv Murtagh

I'm testing a semi-automatic pace report and just want to make sure my data is good coming out of it.

[Jeff P]

Fall meet from a year ago (2010?)... or by chance do you really want rider stats from the current fall (2011) meet?

-jp

.

[BillW]

CAn someone with a database let me know how many starts at Aqueduct since it opened for the fall meet in 2010 until Friday, for

Ryan Curatolo
Rajiv Murtagh

I'm testing a semi-automatic pace report and just want to make sure my data is good coming out of it.

Your spellchecker broke :D

Rajiv Maragh

[BillW]

I show 126 for Maragh and 172 for Curatolo. This is mounts finished (as opposed to mounts named on)

[Tom]

Fall meet from a year ago (2010?)... or by chance do you really want rider stats from the current fall (2011) meet?

-jp

.

Last year, November, when they came back from Belmont until the present weekend.

Oh, and I need Maragh, not Murtagh! :rolleyes::D

[BillW]

I show 126 for Maragh and 172 for Curatolo. This is mounts finished (as opposed to mounts named on)

Upon further review 125 for Maragh and 171 for Curatolo :blush:

[Jeff P]

I have calendar year 2010 and calendar year 2011 in separate database files. So I had to run two queries, one for each year, to get rider stats for the time period requested.

Here's what I have:

First, 2010... Opening day 11/5/2010 through 12/31/2011:

query start: 12/19/2011 9:01:57 AM
query end: 12/19/2011 9:01:57 AM
elapsed time: 0 seconds

Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2_2010.mdb
999 Divisor Odds Cap: None

SQL: SELECT * FROM STARTERHISTORY
WHERE TRACK='AQU'
AND [YEAR]=2010
AND [DATE] >= 40487
AND INSTR('CURATOLO RYAN-MARAGH RAJIV', RIDER) > 0


Data Summary Win Place Show
Mutuel Totals 100.30 132.80 107.20
Bet -128.00 -128.00 -128.00
Gain -27.70 4.80 -20.80

Wins 6 19 26
Plays 64 64 64
PCT .0938 .2969 .4063

ROI 0.7836 1.0375 0.8375
Avg Mut 16.72 6.99 4.12


************************************************** **************************************
BY RIDER sorted by wins Run Date: 12/19/2011 9:01:57 AM
************************************************** **************************************
WIN WIN WIN PLACE PLACE
UDM PLAYS WINS PCT IMPACT ROI PLACES PCT ROI
************************************************** **************************************
MARAGH RAJIV 64 6 0.0938 1.0005 0.7836 19 0.2969 1.0375
************************************************** **************************************
1 Riders from file: StarterHistory Table
************************************************** **************************************






Next, calendar year 2011 - through Fri 12/16/2011:

query start: 12/19/2011 9:12:08 AM
query end: 12/19/2011 9:12:08 AM
elapsed time: 0 seconds

Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor Odds Cap: None

SQL: SELECT * FROM STARTERHISTORY
WHERE TRACK='AQU'
AND [YEAR]=2011
AND [DATE] <= 40893
AND INSTR('CURATOLO RYAN-MARAGH RAJIV', RIDER) > 0


Data Summary Win Place Show
Mutuel Totals 316.20 355.10 376.40
Bet -440.00 -440.00 -440.00
Gain -123.80 -84.90 -63.60

Wins 30 66 98
Plays 220 220 220
PCT .1364 .3000 .4455

ROI 0.7186 0.8070 0.8555
Avg Mut 10.54 5.38 3.84


************************************************** **************************************
BY RIDER sorted by wins Run Date: 12/19/2011 9:12:08 AM
************************************************** **************************************
WIN WIN WIN PLACE PLACE
UDM PLAYS WINS PCT IMPACT ROI PLACES PCT ROI
************************************************** **************************************
CURATOLO RYAN 165 22 0.1333 0.9775 0.6312 52 0.3152 0.8461
MARAGH RAJIV 55 8 0.1455 1.067 0.9809 14 0.2545 0.69
************************************************** **************************************
2 Riders from file: StarterHistory Table
************************************************** **************************************


Let me know if that helps.


-jp

.

[Tom]

Glad I asked - not even close!
Back to the querys to see where I went wrong.

Thanks, guys...I had 64 starts for Ryan and 74 for Rajiv.
I must have a filter on somewhere.
Obviously, not in my head! :D