Excel Spread sheet for Harness Factor Ratings

[Ray2000]

TrackMaster, in combination with USTA Strategic Wagering Promo has free program race sheets for some Pic 4 and Pic 5 races. This attached spreadsheet can use them like the sheet I posted for Mohawk programs.
It can also work for complete, purchased Platinum programs as well, ....any track.

The free pages are found here.
http://handicapping.ustrotting.com/index.cfm

This sheet is in early stage of development. I have error checking turned on and it will be several weeks before the races have error-free usable data so just ignore the error alerts.
I'm posting it early to get feed back on problems or comments.

Friday's Scioto Pick 5 is loaded. Read the help section on the lower rows to see how to set up the required PDF reader if you want to load other programs.

[Ray2000]

Needed to ZIP the attachment


You will need to extract the zipped file befor using.

[Postime]

Thank You as always, great job.

[bobbyb]

Thank you Ray. Your effort is very much appreciated.

bobby

[Ray2000]

Thanks Postime & bobbyb

An updated SpreadSheet is attached.
I trapped some Divide by 0 errors and changed Impacts to closely resemble the best settings I've found for Mohawk.
I have 2 years of Mohawk Programs and results, but with TrackMaster USA Programs I'm flying blind.


Oddly enough the sheet won't work with the complete program found at Scioto's site, It's a platinum TM program but copy not allowed and I'm too cheap to buy one at TM to check.


Factor Impacts
TM Post Bias....5
Driver UDR......2
Trainer UTR.....3
Early Speed.....4
TM Power........1
TM Pace.........1
TM Speed........1
TM Class........1
Earn Last5......1
2yr Wins........2

Tonight's SpeadSheet Picks for Pick 5 at Scioto
I'll go with the top 2 in each race for a $16.00 ticket.
R5.. 1,5,6,9
R6.. 6,1,5,3
R7.. 9,5,10,3
R8.. 4,5,1,9
R9.. 8,1,10,5

Good Luck All

[Ray2000]

Pick 5

5/7/9/4/8 paid $2,200 for 50c

1 leg short...

[Ray2000]

Northfield Opens tomorrow !


Spreadsheet Picks



Mon 5/25 Scd
Race 5 1,5,4
Race 6 5,1,2
Race 7 5,10,4
Race 8 5,8,1
Race 9 5,3,2

Tue 5/26 Nfld
Race 11 1,8,6
Race 12 2,1,8
Race 13 2,4,3
Race 14 2,1,4

Wed 5/27 Nfld
Race 11 2,5,3
Race 12 3,1,4
Race 13 9,5,3
Race 14 6,2,3

[Longshot6977]

New spreadsheet looks great Ray! Any plans for a 'Trip' factor like the last spreadsheet?

[Ray2000]

Originally Posted by Longshot6977

New spreadsheet looks great Ray! Any plans for a 'Trip' factor like the last spreadsheet?

Thanks Longshot6977

It would not be that hard. The data is already gathered in the Early Speed Factor.

The Early speed factor uses the average call difference from gate to the half pole, last 5 starts.

The Trip Factor bonus is set by the number of Leavers in the race (best Early Speeds) and then:

No leavers or 3 or 4 or more means the bonus goes to the closer with the best speed.
1 or 2 leavers gives the bonus to the fastest leaver.

[Ray2000]

Small changes to Spreadsheet
1. Color bar formatting.
2. Added table showing Program values. (Scroll down)
3. Top 3 Picks shown next to Race selector for copying.

I'm working on trip bonus.

Northfield Friday 5/29 Late Pick 4 is loaded.
New Impact values to boost Post, TM Speed and Gate Leave factors.




NFLD Late P4 play tonite is

Race 11. . 3,1
Race 12. . 9,2,1
Race 13. . 5
Race 14. . 4,6

GLA

[Longshot6977]

The new spreadsheet looks great Ray. I like the formatting colors too. I'm sure after I use the sheet many times, I can figure this out, but I'll ask now. Can you tell us the cutoff values you used to change a color from dark green to lighter green to light yellow to etc? And also for the right hand column (Ratings with Impacts).

I ask because I see a light green 11% as well as a yellow 11% on the sample sheet. Thanks.

[Postime]

Hey Ray,
Any plans to expand sheet to handicap the complete card?

[Ray2000]

Originally Posted by Longshot6977

The new spreadsheet looks great Ray. I like the formatting colors too. I'm sure after I use the sheet many times, I can figure this out, but I'll ask now. Can you tell us the cutoff values you used to change a color from dark green to lighter green to light yellow to etc? And also for the right hand column (Ratings with Impacts).

I ask because I see a light green 11% as well as a yellow 11% on the sample sheet. Thanks.

I used the default setting for Excel's 3 color scale.

Here is Microsoft's explanation for this scale.

• Explanation: by default, for 3-Color scales, Excel calculates the 50th percentile (also known as median, middle value or midpoint). The cell that holds the minimum value is colored red.
• The cell that holds the median is colored yellow,
• and the cell that holds the maximum value is colored green. All other cells are colored proportionally.

Each factor has it's own color scale so what is light green in one factor may be a different shade of green in another factor's scale.
It's possible to set up your own scale rules but I never tried that.

[Longshot6977]

Originally Posted by Postime

Hey Ray,
Any plans to expand sheet to handicap the complete card?

I think he answered that in the original post #1. Yes, it can.

[Ray2000]

Yes, it will work with the full Platinum program, the one which has the TM file name ending with..... 'x.pdf'

But I wasn't thinking "Northfield" when I started writing it so it only shows the first 12 races.
I'll expand it to show the late races for that track later, just needs more option buttons, the data is being read in.


Why they do 16 race cards is beyond my bedtime anyway.