|
|
05-20-2020, 06:30 PM
|
#1
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
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.
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
05-20-2020, 06:35 PM
|
#2
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
Needed to ZIP the attachment
You will need to extract the zipped file befor using.
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Last edited by Ray2000; 05-20-2020 at 06:38 PM.
|
|
|
05-20-2020, 07:07 PM
|
#3
|
Registered User
Join Date: Nov 2005
Location: Calabash NC
Posts: 382
|
Thank You as always, great job.
|
|
|
05-22-2020, 10:19 AM
|
#4
|
Registered User
Join Date: Jan 2003
Location: WC N.of Wa.
Posts: 1,094
|
Thank you Ray. Your effort is very much appreciated.
bobby
|
|
|
05-23-2020, 11:14 AM
|
#5
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
Update
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
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Last edited by Ray2000; 05-23-2020 at 11:16 AM.
|
|
|
05-23-2020, 09:43 PM
|
#6
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
Pick 5
5/7/9/4/8 paid $2,200 for 50c
1 leg short...
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
05-25-2020, 05:21 AM
|
#7
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
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
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
05-25-2020, 10:06 AM
|
#8
|
Registered User
Join Date: Feb 2013
Location: Central New Jersey
Posts: 1,467
|
New spreadsheet looks great Ray! Any plans for a 'Trip' factor like the last spreadsheet?
|
|
|
05-25-2020, 10:59 AM
|
#9
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
Quote:
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.
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
05-29-2020, 03:51 PM
|
#10
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
Update
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
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
05-30-2020, 10:11 AM
|
#11
|
Registered User
Join Date: Feb 2013
Location: Central New Jersey
Posts: 1,467
|
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.
|
|
|
05-30-2020, 11:47 AM
|
#12
|
Registered User
Join Date: Nov 2005
Location: Calabash NC
Posts: 382
|
Hey Ray,
Any plans to expand sheet to handicap the complete card?
|
|
|
05-30-2020, 11:54 AM
|
#13
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
Quote:
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.
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
05-30-2020, 03:14 PM
|
#14
|
Registered User
Join Date: Feb 2013
Location: Central New Jersey
Posts: 1,467
|
Quote:
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.
|
|
|
05-30-2020, 03:28 PM
|
#15
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
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.
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|