|
|
05-30-2020, 07:16 PM
|
#16
|
Registered User
Join Date: Nov 2005
Location: Calabash NC
Posts: 381
|
Quote:
Originally Posted by 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.
|
|
|
|
06-02-2020, 07:27 PM
|
#17
|
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
|
|
|
06-02-2020, 11:26 PM
|
#18
|
Apple 2GS Wiz
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.
|
|
|
06-02-2020, 11:53 PM
|
#19
|
Apple 2GS Wiz
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
|
|
|
06-04-2020, 11:41 AM
|
#20
|
Apple 2GS Wiz
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
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
06-10-2020, 06:06 PM
|
#21
|
Apple 2GS Wiz
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
|
|
|
06-15-2020, 08:23 AM
|
#22
|
Apple 2GS Wiz
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.
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
|
|
|
06-24-2020, 10:17 AM
|
#23
|
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?
|
|
|
06-24-2020, 05:40 PM
|
#24
|
Apple 2GS Wiz
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
|
|
|
06-25-2020, 03:35 PM
|
#25
|
Apple 2GS Wiz
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
__________________
.
.
.The only sure thing about luck is that it will change.
Bret Harte
Last edited by Ray2000; 06-25-2020 at 03:39 PM.
|
|
|
06-26-2020, 12:36 PM
|
#26
|
Apple 2GS Wiz
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
|
|
|
06-26-2020, 05:58 PM
|
#27
|
Apple 2GS Wiz
Join Date: Jan 2008
Location: Clarion, Pa
Posts: 8,478
|
Quote:
Originally Posted by Ray2000
...
...
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
|
|
|
06-26-2020, 07:35 PM
|
#28
|
Registered User
Join Date: Dec 2017
Posts: 185
|
Isn't Brower the one who makes the morning line?
|
|
|
06-26-2020, 09:49 PM
|
#29
|
Registered User
Join Date: Dec 2017
Posts: 185
|
Nice one in the 7th Ray! $17.2
|
|
|
06-26-2020, 10:39 PM
|
#30
|
Apple 2GS Wiz
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.
|
|
|
|
|
Thread Tools |
|
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
HTML code is Off
|
|
|
|
|