If I can't post the data here, I set up a link to it. — Tom

Sure.
What format do you want to post it in?

Worksheet or PDF file?
Click the Upload file button.
(Let me know if it doesn't appear on your toolbar.)

Graphics?
Just drag & drop.

OK, the attached spreadsheet is my model for FL race track in beautiful downtown Farmington. The data comes right off the 7 columns at the bottom of the BRIS ULTIMATE PPs, Speed last race, back speed, current class, average competitive level, prime power, early pace last race and late pace last race. I also added the E/L rankings 0r the place horse as well, out of curiosity.

The numbers were taken as is, no substitutes, no influence from me. The summary box in the upper right corner is the "7-4-1" scoring for each column. Field size is included so I can look at small and large fields.

Next step is break it down by sprint-route, and make Reynolds fields.

Maybe some column heading descriptions?

SRL SPEES LAST RACE
SRB BACK SPEED
CCL CURRENT CLASS LEVEL
ACL AVERAGE COMP LEVEL
PP PRIME POWER
E EARLY PACE LAST RACE
L LATE PACE LAST RACE
E EP LAST, PLACE HORSE
L LP LAST, PLACE
PAY WIMN PAYOFF
NH NUMBER OF HORSES

Thank you.

Thanks Tom- can't wait to dig into this

I have enough races at Belmont to post after this weekend.
Some interest stuff going on there.

I look forward to hearing about it.

I use most all races, unless it is a MSW with mostly FTS, but if there are 4 horses, I use it. That's why I put notes for MSW 2yos, so I can filter them out.

I thought this was most interesting so I went back and reviewed WHAT WINS - Dave Schwartz and worked up the attached for the spring meet at Keeneland. I am not to the point where I could actually use this data but I thought that some one else might have an insight or three and would share.

Most headings I hope are self explanatory but if not.... (the _# is just to help keep me straight in the code, it's not relavent to much of anything else)

TRK_1 track name
DATE_2 date of race
RACE_3 race number
ML_10 morning line odds
FINSH_15 finish
PT_ODDS_16 post time odds
WIN_17 win payoff
PLACE_18 place payoff
SHOW_19 show playoff
ML_RANK_20 morning line odds rank
PT_RANK_21 post time odds rank
PRIMEP_RANK_22 prime power rank
EP_RANK_23 early pace (my version) rank
LP_RANK_24 late pace (my version) rank
SAR_RANK_25 some combination of Sartin fps numbers (I would have to look closely to see the computations)
B_365_RANK_26 best speed in 365 days rank
BL2_RANK_27 best of last two speeds rank
TR/JO_RANK_28 combined trainer jockey win percentage rank
LRS_RANK_29 last race speed rank

This looks like good work, Steven! :clap: :clap:

It was work like this that allowed me to turn everything right side up a couple of months ago.

Much of that development was the result of working with a couple of other guys. I just cannot emphasize enough how important collaboration is.

Aside from splitting the workload, it also provides a different POV; different ideas.

Of course, Steven, our paths have crossed before. I know your work is top notch.

(Could use an extra 500 columns, maybe. LOL)
(Dang, was that my BIG DATA outlook showing through?)

Good work.
It does dominate.

BTW... Tried to straighten out your columns a little with code tags.
Will have to get some vids & screenshots going for how to use those.

Basically, write it in a text editor that lets you use COURIER (a fixed-width font), then paste it in. Finally, wrap that in "code tags." (The 5th icon from the left that looks like <>)

Thank you Dave, that's very kind of you.

This is (as well as I am) still a work in progress and I hope to add to the What Wins program/spreadsheet as I go along. I'm all for massive amounts of data, I'm just not sure what would be worth putting in there. I have added Quirin Early Speed points and I'm looking for other factors to add. I don't think I'll ever get to 500 but I am already set up for about 100 (I just need factors). Anybody got something they want to look at (low level type factor, best speed at distance or track for example would be okay. Nothing that involves too many calculations)?

Highest QES points percentage (of field total) might be interesting.

How much of an advantage ( in percentage) is needed to produce a profitable play.

Highest QES points percentage (of field total) might be interesting. — Zayonce William

Surprisingly, that is a very disappointing factor.
Check out the Early Speed series, if you haven't already.

How much of an advantage ( in percentage) is needed to produce a profitable play. — Zayonce William

You have to see it from an "out-perform the tote board" point of view.
If you've not read this book, Percentages & Probabilities, there is a lot in it like that.

What's Winning at GPX 2021 Dirt Sprints

If you have any questions on anything, please let me know

Here's a factor that I'd like to see stats on.
Number or percentage of wins and or "good" races in past 12 ,excluding "irrelevant" races and races prior to a 90 day layoff and including/excluding QES or Speed rating rank.A high percentage ( 80% or better) has been 1 of my tools but knowing the actual long term win % would i be helpful .

If these stats are already included in "Percentages and probabilities " please advise, I'll order a copy.

If these stats are already included in "Percentages and probabilities " please advise, I'll order a copy. — Zayonce William

Good races and some other stuff are in PAST 10 and a bunch of items in LAST 90 DAYS are included.
There are HUNDREDS of factors.

There are also those SAME HUNDREDS of factors (data tables) spread across 25 different kinds of races. Over 1,300 extra pages!

Buy it here.

• Allowances Sprints & Routes
• Claiming Sprints & Routes (including N2L)
• Graded Sprints, Routes, Turf
• Maidens, etc.
• Young Horses
• Marathons

Thank-you Dave!

Zayonce, can you explain this mathmatically? I have to program this all in and I don't really follow what you're asking.

Thanks Steven.
What Im curious about is a win percentage for entries which have a minimun of 3 good races in their last 10 with at least 1 win and boast the highest percentage of good races in the field . The other factors are finetuning( eliminating irrelevant races and races prior to a 90 day layoff.)

How would you define a good race?

[b[/b]

The. Quirin definition...witin 2 lengths in a sprint or 3 lengths in a route. Steven

Or 3rd

So we're saying a good race is:

Within 90 days
and
(Horse was first
or
Horse finished second
or
Horse finished third
or
Horse was within 2 in a sprint
or
Horse was within 3 in a route)

Am I right on the finished second/third?

How would you define a good race? — Steven

Standard definition is from Dr. William Quirin (found in Percentages & Probabilities.)

Steven, you need not limit it to 90 days. Just dont go back beyond a 90 day layoff