- Harness Racing
( http://www.paceadvantage.com/forum/forumdisplay.php?f=41)
| Ray2000 |
05-20-2020 06:30 PM |
Excel Spread sheet for Harness Factor Ratings
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 |
05-20-2020 06:35 PM |
1 Attachment(s)
Needed to ZIP the attachment
You will need to extract the zipped file befor using.
|
| Postime |
05-20-2020 07:07 PM |
Thank You as always, great job.:coffee:
|
| bobbyb |
05-22-2020 10:19 AM |
Thank you Ray. Your effort is very much appreciated.
bobby
|
| Ray2000 |
05-23-2020 11:14 AM |
Update
1 Attachment(s)
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 |
05-23-2020 09:43 PM |
Pick 5
5/7/9/4/8 paid $2,200 for 50c
1 leg short...:mad:
|
| Ray2000 |
05-25-2020 05:21 AM |
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 |
05-25-2020 10:06 AM |
New spreadsheet looks great Ray! Any plans for a 'Trip' factor like the last spreadsheet?
|
| Ray2000 |
05-25-2020 10:59 AM |
Quote:
Originally Posted by Longshot6977
(Post 2607620)
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 |
05-29-2020 03:51 PM |
Update
1 Attachment(s)
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. :coffee:
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 |
05-30-2020 10:11 AM |
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 |
05-30-2020 11:47 AM |
Hey Ray,
Any plans to expand sheet to handicap the complete card?
|
| Ray2000 |
05-30-2020 11:54 AM |
Quote:
Originally Posted by Longshot6977
(Post 2610398)
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 |
05-30-2020 03:14 PM |
Quote:
Originally Posted by Postime
(Post 2610444)
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 |
05-30-2020 03:28 PM |
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. :)
|
| All times are GMT -4. The time now is 02:12 AM. |
|
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
|
|
