Go Back   Pace and Cap - Sartin Methodology & The Match Up > General Discussion
Mark Forums Read
Google Site Search Get RDSS Sartin Library RDSS FAQs Conduct Register Site FAQ Members List Search Today's Posts

General Discussion General Horse Racing Discussion

Reply
 
Thread Tools Display Modes
Old 09-28-2019, 03:52 PM   #11
Lt1
Grade 1
 
Lt1's Avatar
 
Join Date: Apr 2012
Location: Valley Stream NY
Posts: 9,034
Since I play only 1 track a day it's good old pen and paper for me. In less then 2 mins I have my win/place models for each dist & surface updated. I have real time info to see if there are changes going on that may cause me to alter my planned bets.
Tim
__________________
Trust but verify
Lt1 is offline   Reply With Quote
Old 10-27-2019, 09:58 AM   #12
Dorianmode
always learning
 
Dorianmode's Avatar
 
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
Here is an updated profile (thanks Bill V for the huge data file of races) with the data at the top and filters applied to every column so you can keep all your races in one file, and use as many filters as you want, or in whatever way you want. Filtered data in Excel can be tricky. I used the subtotal functionality to get the same percent results that Ted set up in the formulas for the profiles without filters, and did some testing. If you notice something is amiss, please let me know. Thanks.
Attached Files
File Type: xlsx Filterable profile with data at top Bill V data.xlsx (1.84 MB, 565 views)

Last edited by Dorianmode; 10-27-2019 at 10:01 AM.
Dorianmode is offline   Reply With Quote
Old 11-01-2019, 03:04 AM   #13
DaveEdwards
Grade 1
 
DaveEdwards's Avatar
 
Join Date: Nov 2008
Location: England
Posts: 489
I think there is a lot to be said for Tim's pen and paper approach. When you manually process data it gives you time to think about things, even subconsciously.
That said, I do use excel myself for record purposes.

If anyone needs a grounding in how to use Excel, there is a really excellent resource to dip into. Go to youtube and search for Excel Is Fun.

A guy has posted thousands of instructional videos. They are easy to follow along with. The problem with something like Excel is that it is such a complex application that can do a multitude of things. Often you are in the position of "not knowing what you don't know" and it is hard to know where to start your search.

An approach I have found useful is searching for your problem in google. You can usually find what you need. After that, check out the Excel Is Fun channel for an instructional video.

I have used it to find things for work etc and always found what I needed.
DaveEdwards is offline   Reply With Quote
Old 08-22-2020, 12:18 PM   #14
Dorianmode
always learning
 
Dorianmode's Avatar
 
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
One possible use of the files I posted above, is the use of the "Max" function to confirm your contenders. Filter the races to the type of race, (possibly filter the track), and other things you want to filter out, and look through the data in the "Max" row. You will see some calculated functions to be in the "max" function of 4 or less, or whatever your want (5 ?) You could use these functions in which the winner is 4 (or less, or your choice) to confirm (or find) your contenders. Just an idea. Works for me.
Dorianmode is offline   Reply With Quote
Old 08-24-2020, 11:24 AM   #15
mnl97
Broke Down
 
Join Date: May 2019
Location: Northeast Texas
Posts: 38
One thing I didn't like about the original excel spreadsheet was the the count and %rank figures did not change when using a filter. If I filtered by 6 furlong races only, the count and and rank % still showed all races. I changed the formulas to where they only represented the filtered data. In other words what you see after filtering is what is reflected in the formula's. It was easy to modify the count formula using the subtotal function. The rank % formula is much more complicated. I'm attaching my current spreadsheet for Saratoga. Its been a work in progress. The advantage of using the new formulas is that you can put all race data on one spreadsheet and then use the filter function to separate out distance, surface, etc.

I've also added sort of a front end table that only shows data of which I'm interested. Plus I have a place to document the stats of the winning horse as well as a place to record wagers. I enter the export data for the winning horse only and the use a copy formula in the front table.

This is a work in progress. I've BEEN changing the spreadsheet as I learn more about RDSS.

I'm looking forward to this thread. I'm sure I can learn alot from you guys in using excel but also in handicapping / wagercapping.
Attached Files
File Type: xlsx SAR MODEL.xlsx (488.0 KB, 380 views)
mnl97 is offline   Reply With Quote
Old 08-24-2020, 07:20 PM   #16
Dorianmode
always learning
 
Dorianmode's Avatar
 
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
I wonder if you didn't click on "enable editing". When I filter to 6F races (only) it changes from 1667 to 338 races. Maybe you weren't talking about this spreadsheet ? Anyhow, glad you're involved and knowledgeable about Excel.
Dorianmode is offline   Reply With Quote
Old 08-25-2020, 05:12 PM   #17
mnl97
Broke Down
 
Join Date: May 2019
Location: Northeast Texas
Posts: 38
I was talking about the template provided initially... Your template has the rank formulas that work properly. Where did you get your current template. I struggled for months to figure out =(SUMPRODUCT(SUBTOTAL(3,OFFSET(W18:W1751,ROW(W18:W1751)-MIN(ROW(W18:W1751)),,1))*(W18:W1751=4)))/W3*100. You had it all along.
mnl97 is offline   Reply With Quote
Old 08-28-2020, 09:25 PM   #18
Dorianmode
always learning
 
Dorianmode's Avatar
 
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
Quote:
Originally Posted by mnl97 View Post
I was talking about the template provided initially... Your template has the rank formulas that work properly. Where did you get your current template. I struggled for months to figure out =(SUMPRODUCT(SUBTOTAL(3,OFFSET(W18:W1751,ROW(W18:W1751)-MIN(ROW(W18:W1751)),,1))*(W18:W1751=4)))/W3*100. You had it all along.
I wish I could honestly say where I got it.
Either I found it myself, researching the subject in on-line excel posts, OR one of the nurse specialists where I work had it in one of our QA spreadsheets. It's a "clunky" (non-elegant) solution, but it works. I've been on the lookout for a simpler solution.

Glad you found it useful.

Last edited by Dorianmode; 08-28-2020 at 09:31 PM.
Dorianmode is offline   Reply With Quote
Old 09-28-2020, 12:46 PM   #19
Dorianmode
always learning
 
Dorianmode's Avatar
 
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
I think there must be a way to be able to add the filtering formula, (used above) for the Excel "Small" function read outs. Right now, in the sample above, that doesn't work. I'll have to play with the SUMPRODUCT functionality, and see if I can get it to work.

Meanwhile, I came across this very helpful list of formulas, and explanations, for use in Excel.
https://exceljet.net/formulas
Dorianmode is offline   Reply With Quote
Old 10-07-2020, 06:10 PM   #20
Dorianmode
always learning
 
Dorianmode's Avatar
 
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
Have you ever run a regression analysis ?
Do you know what they actuaklly are ?
Dorianmode is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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 On

Forum Jump


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.

All times are GMT -4. The time now is 11:57 AM.