Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Contests + Other Interesting Racing Topics > Harness Racing


Reply
 
Thread Tools Rate Thread
Old 05-20-2020, 06:30 PM   #1
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
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
Ray2000 is offline   Reply With Quote Reply
Old 05-20-2020, 06:35 PM   #2
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
Needed to ZIP the attachment


You will need to extract the zipped file befor using.
Attached Files
File Type: zip AnalysisTMFactors.zip (159.9 KB, 38 views)
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte

Last edited by Ray2000; 05-20-2020 at 06:38 PM.
Ray2000 is offline   Reply With Quote Reply
Old 05-20-2020, 07:07 PM   #3
Postime
Registered User
 
Postime's Avatar
 
Join Date: Nov 2005
Location: Calabash NC
Posts: 308
Rep Power: 15 Postime is on a distinguished road
Thank You as always, great job.
Postime is offline   Reply With Quote Reply
Old 05-22-2020, 10:19 AM   #4
bobbyb
Registered User
 
bobbyb's Avatar
 
Join Date: Jan 2003
Location: WC N.of Wa.
Posts: 870
Rep Power: 18 bobbyb will become famous soon enough
Thank you Ray. Your effort is very much appreciated.

bobby
bobbyb is offline   Reply With Quote Reply
Old 05-23-2020, 11:14 AM   #5
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
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
Attached Files
File Type: zip AnalysisTMFactorsV2.zip (162.6 KB, 20 views)
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte

Last edited by Ray2000; 05-23-2020 at 11:16 AM.
Ray2000 is offline   Reply With Quote Reply
Old 05-23-2020, 09:43 PM   #6
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
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
Ray2000 is offline   Reply With Quote Reply
Old 05-25-2020, 05:21 AM   #7
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
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
Ray2000 is offline   Reply With Quote Reply
Old 05-25-2020, 10:06 AM   #8
Longshot6977
Registered User
 
Longshot6977's Avatar
 
Join Date: Feb 2013
Location: Central New Jersey
Posts: 1,362
Rep Power: 10 Longshot6977 has a spectacular aura aboutLongshot6977 has a spectacular aura about
New spreadsheet looks great Ray! Any plans for a 'Trip' factor like the last spreadsheet?
Longshot6977 is offline   Reply With Quote Reply
Old 05-25-2020, 10:59 AM   #9
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
Quote:
Originally Posted by Longshot6977 View Post
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
Ray2000 is offline   Reply With Quote Reply
Old 05-29-2020, 03:51 PM   #10
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
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
Attached Files
File Type: zip AnalysisTMFactorsV3.zip (157.2 KB, 18 views)
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
Old 05-30-2020, 10:11 AM   #11
Longshot6977
Registered User
 
Longshot6977's Avatar
 
Join Date: Feb 2013
Location: Central New Jersey
Posts: 1,362
Rep Power: 10 Longshot6977 has a spectacular aura aboutLongshot6977 has a spectacular aura about
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.
Longshot6977 is offline   Reply With Quote Reply
Old 05-30-2020, 11:47 AM   #12
Postime
Registered User
 
Postime's Avatar
 
Join Date: Nov 2005
Location: Calabash NC
Posts: 308
Rep Power: 15 Postime is on a distinguished road
Hey Ray,
Any plans to expand sheet to handicap the complete card?
Postime is offline   Reply With Quote Reply
Old 05-30-2020, 11:54 AM   #13
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
Quote:
Originally Posted by Longshot6977 View Post
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
Ray2000 is offline   Reply With Quote Reply
Old 05-30-2020, 03:14 PM   #14
Longshot6977
Registered User
 
Longshot6977's Avatar
 
Join Date: Feb 2013
Location: Central New Jersey
Posts: 1,362
Rep Power: 10 Longshot6977 has a spectacular aura aboutLongshot6977 has a spectacular aura about
Quote:
Originally Posted by Postime View Post
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.
Longshot6977 is offline   Reply With Quote Reply
Old 05-30-2020, 03:28 PM   #15
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,031
Rep Power: 26 Ray2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to allRay2000 is a name known to all
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
Ray2000 is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
» Current Polls
Which factor contributes most to hot/cold jockeys?
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 07:19 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Copyright 1999 - 2020 -- PaceAdvantage.Com -- All Rights Reserved -- Best Viewed in a modern browser @ 1280x720 Resolution Or Higher
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.