|
Google Site Search | Get RDSS | Sartin Library | RDSS FAQs | Conduct | Register | Site FAQ | Members List | Today's Posts | Search |
General Discussion General Horse Racing Discussion |
|
Thread Tools | Display Modes |
09-28-2019, 03:52 PM | #11 |
Grade 1
Join Date: Apr 2012
Location: Valley Stream NY
Posts: 9,188
|
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 |
10-27-2019, 09:58 AM | #12 |
always learning
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.
Last edited by Dorianmode; 10-27-2019 at 10:01 AM. |
11-01-2019, 03:04 AM | #13 |
Grade 1
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. |
08-22-2020, 12:18 PM | #14 |
always learning
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.
|
08-24-2020, 11:24 AM | #15 |
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. |
08-24-2020, 07:20 PM | #16 |
always learning
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.
|
08-25-2020, 05:12 PM | #17 |
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.
|
08-28-2020, 09:25 PM | #18 | |
always learning
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
|
Quote:
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. |
|
09-28-2020, 12:46 PM | #19 |
always learning
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 |
10-07-2020, 06:10 PM | #20 |
always learning
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 ? |
|
|