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-30-2020, 07:16 PM   #16
Postime
Registered User
 
Postime's Avatar
 
Join Date: Nov 2005
Location: Calabash NC
Posts: 381
Quote:
Originally Posted by Ray2000 View Post
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.


Postime is offline   Reply With Quote Reply
Old 06-02-2020, 07:27 PM   #17
eztowing
Registered User
 
Join Date: May 2017
Posts: 19
help

hello Ray, I don't think i"m stupid but I must be doing something wrong..I downloaded the spreadsheet, I downloaded the PDF viewer, I downloaded the free Trackmaster program pages..now what?? how do I use the program?? How do I download the races onto the spreadsheet?? Looking at the sample from Scioto on Friday I can't change the info other than the one race, how do I look at the other races?? Any help would be appreciated, Thank You
eztowing is offline   Reply With Quote Reply
Old 06-02-2020, 11:26 PM   #18
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
eztowing


After opening the spreadsheet with MS Office Excel, You should see the Main sheet (Northfield Friday) showing race 11. To change the race, select (click on) the button next to the desired race 12, 13, 14, located in the center between the chart and the graph.

To change to a new or different program, click on the green square button "Load Card" at the top left of the sheet.
This will bring up a "File Dialog Window" where you navigate to where you have the program file you want.


Select the file and then open (or double click). Assuming you have the pdf reader installed and the hot key set to Control 6 (^6), the new race card should load in from there. You can now use the center buttons to select which race you want to see.


Use the top right drop down menu (it's set on TM Post Bias) to change to the factor you want shown in the graph.


Let me know if you have any questions.
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte

Last edited by Ray2000; 06-02-2020 at 11:33 PM.
Ray2000 is offline   Reply With Quote Reply
Old 06-02-2020, 11:53 PM   #19
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
Too late to edit

I should have mentioned you need to have Macros enabled in Excel,
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
Old 06-04-2020, 11:41 AM   #20
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
Update

Latest update

Can now do 14 Races instead of 12

Trapped errors caused by these chars
À,Á,Â,Ã,Ä,Å,Æ and the upsidedown ¿ .

Added a sheet "PlayList" to save Top 3 rated horses in each race.

Has BigM Friday loaded
Attached Files
File Type: zip AnalysisTMFactorsV4.zip (332.2 KB, 25 views)
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
Old 06-10-2020, 06:06 PM   #21
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
Early performance

[
Code:
        Impact Settings
TM Post Bias      4
Driver UDR        3
Trainer UTR       2
Early Speed       3
TM Power          2
TM Pace           1
TM Speed          2
TM Class          1
Earn Last5        2
2yr Wins          1
123 races BigM, Northfield, Scioto, Hawthorn, Buffalo
$246 Bet Win or Place
$142.70 Win return....0.58 ROI
$199.00 Place return..0.81 ROI

I'm going to blame this horrible performance on the new normal come back.
Many overbet faves, paying Odds-on
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
Old 06-15-2020, 08:23 AM   #22
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
Latest update

Catches more errors
Only uses pplines for distances of 1 mile.
Includes Trip Horse
....Trip horse is shown but no bonus is applied to final ratings. Needs further testing.

Slow pace for 0, 1 or 2 early speed horses
Fast pace for 3 or more
Trip goes to best leaver when there's 1 or 2 leavers.
Trip goes to best closer when there's 0 or 3 or more leavers.

Leaver must have an average of 2 length make up from post to half call over last shown pplines.
Attached Files
File Type: zip AnalysisTMFactorsV5.zip (189.5 KB, 10 views)
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
Old 06-24-2020, 10:17 AM   #23
cougara
Registered User
 
Join Date: Feb 2014
Posts: 3
This is fantastic! Thank you for sharing.

I have access to free condensed PPs that I would like to be able to import. I started peeking at the code to see how I could possibly change it to make it work -- would the GetFactors macro be the place I'd need to make the most changes in regard to how the data gets brought in?
cougara is offline   Reply With Quote Reply
Old 06-24-2020, 05:40 PM   #24
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
cougara


The top of module1 has the macro 'LoadSingleCard' which gets the filepath/filename that the user wants then does a shell call to the pdf reader to open that file, copy and paste all content into sheet "Program".

The next Macro "GetFactors" does the work of finding the right data numbers for the right race, and putting those numbers into a 10 x 12 array which then gets copied to sheet "Constants" where workbook functions 'take over' to do most number crunching.

A problem you'll have is I have a hodge-podge system of mixing macro execution with sheet functions so certain sheet ranges can't be moved without changing the code that's looking for specific cells. It's poor coding I know but I was doing a quick and dirty method to see if it could be done at all.

For instance, the start row for each race is stored in a cell on sheet 'Constants' instead of using macro variables.

If you need any specific help, post here or PM me.
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
Old 06-25-2020, 03:35 PM   #25
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
Latest update

Latest version attached.

1. Shows Horse Name & ML in Comments for each entry. Same for Driver / Trainer names.

2. Adds Minimum Acceptable Odds (MAO) to top 4 rated horses.

3. Has an optional run Batch on sheet playlist.






Today's Hoosier Pick4 and Jackpot races are loaded.
Strange pick in Race 4 ....Zaza Boy Mo line 8/1
Top TM Power, best earnings
Has him at Even money MOA after the Qualifier

HOP R3. . 4 5 6. . CRAFTY ACE® 2/1 -- John De Long Grn-O Go Jeff Brewer
HOP R4. . 8 5 6. . ZAZA BOY 8/1 -- Peter Wrenn Rodney Lorenzo
HOP R5. . 5 7 3. . CINNAMON BEACH® 5/1 -- Charlie Conrad Grn-Tn-Wh Bonnie Mattingly
HOP R6. . 5 4 7. . CLASSIC COUNTRY® $25000 4/1 -- Trace Tetrick Erv Miller
HOP R14. . 5 10 4. . GENIE ROCKWELL® $10000 5/2 -- Marlin Fry (P) Blu James Yoder


GLA
Attached Files
File Type: zip AnalysisTMFactorsV6.zip (221.1 KB, 9 views)
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte

Last edited by Ray2000; 06-25-2020 at 03:39 PM.
Ray2000 is offline   Reply With Quote Reply
Old 06-26-2020, 12:36 PM   #26
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
In the last update, when I put in the MAO for each pick, a cell on Sheet "Playlist" got messed up.

You can ignore it or delete cell "I1" on sheet 'Playlist' then paste in this formula.
=B1&" R"&C1&". . "&D1&" "&E1&" "&F1&". . "&Main!S17&" -- "&PROPER(Main!S18)
I'll fix it in the next update.




Tonight's Selections


HAW R12. . 9 8 1. . TRASHYTONGUETALKER 5/2 -- Casey Leonard Rd/W/Ryl Bl Terry Leonard
HAW R13. . 5 2 7. . THOUGHT PROVOKING 4/1 -- Casey Leonard Rd/W/Ryl Bl Eugene Gilerman
HAW R14. . 5 3 6. . GABE HENRY® 7/1 -- Juan Franco Nelson Willis
HAW R15. . 10 2 4. . DINKY DUNE® 4/1 -- Kyle Wilfong Red-Wh Dane May

HOP R14. . 5 3 7. . ROCK IDOL® $20000 4/1 -- Trace Tetrick Brian Brown

M R4. . 8 7 9. . DASHBOARD 3/1 -- Dexter Dunn Besim Odza
M R5. . 7 5 8. . HELLO TOMORROW $380000 4/1 -- Tim Tetrick Per Engblom
M R6. . 6 2 4. . ALEXIS'S BEACH $200000 7/2 -- Tim Tetrick Brett Pelling
M R7. . 5 2 6. . AB'SATTITUDEXPRESS® 8/1 -- Yannick Gingras Grn-Wh-Go Lucas Wallin
M R8. . 5 3 7. . BRONSKIMACKENZIE 10/1 -- Dexter Dunn Tahnee Camilleri
M R9. . 2 6 8. . EUROBOND †Â 8/1 -- David Miller Go Nancy Takter

__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
Old 06-26-2020, 05:58 PM   #27
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
Quote:
Originally Posted by Ray2000 View Post
...
...
M R7. . 5 2 6. . AB'SATTITUDEXPRESS® 8/1 -- Yannick Gingras Lucas Wallin
M R8. . 5 3 7. . BRONSKIMACKENZIE 10/1 -- Dexter Dunn Tahnee Camilleri

I thought I found a bet at decent odds with these 2 but it must be horrible Morning Lines.

Dave Brower has both of them picked to win.

Gonna bet'm if I can get 3/1

GLA
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Ray2000 is offline   Reply With Quote Reply
Old 06-26-2020, 07:35 PM   #28
Bogo
Registered User
 
Join Date: Dec 2017
Posts: 185
Isn't Brower the one who makes the morning line?
Bogo is offline   Reply With Quote Reply
Old 06-26-2020, 09:49 PM   #29
Bogo
Registered User
 
Join Date: Dec 2017
Posts: 185
Nice one in the 7th Ray! $17.2
Bogo is offline   Reply With Quote Reply
Old 06-26-2020, 10:39 PM   #30
Ray2000
Apple 2GS Wiz
 
Ray2000's Avatar
 
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
thanks, bogo

I'm not sure who does the morning line but it was spot on this time
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte

Last edited by Ray2000; 06-26-2020 at 10:40 PM.
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
Powered by vBadvanced CMPS v3.2.3

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


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
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.