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

RDSS 2.1 Racing Decision Support System - The NEW Version!

Reply
 
Thread Tools Display Modes
Old 01-20-2018, 11:29 AM   #1
Bill V.
The egg man
 
Bill V.'s Avatar
 
Join Date: Jul 2008
Location: Carlsbad, California
Posts: 9,070
I love the New modeling Template(4)

I just recorded my 1000th race on my Win model, I have slightly less, like 960
place and show horse, This is probably do to FTS's, deadheats ,entrys and
unfortunately a few short fields. Yet like they say in the Del Mar jingle
"There is a smile on every face, and a winner in every race where the surf meets the turf at Del Mar " My win model always has the most races .

Its great to see the percentages of the top rated horse and then the 2nd 3rd and 4th and lots of other percentage calculations.

I only have 1000 races coming from 8600 pacelines
No where near FTL's hundreds and thousands of lines and races,
Yet I still find the template very fun to poke around,
Lets say I have a race with like a 9 year old , with just a few clicks
I can sort the 8600 pace lines and see what percentage of horses 9 years old
or older have won.

Or what is the average Sartin speed rating for all 1000 winners - Its 83.5 by the way,

Playing around with my models from RDSS really helped me pass the time while I was in recovery.


Anyway I thank Ted for this great feature of RDSS
I know Ted puts lots of work and time into this feature
Bless
Bill
Bill V. is offline   Reply With Quote
Old 01-20-2018, 12:59 PM   #2
mick
Abiding Student
 
mick's Avatar
 
Join Date: May 2016
Location: Nashville
Posts: 546
Thumbs up

Bill, I agree with you and I would like to thank Ted, too.
__________________
mick

"May you always have a clean shirt, a clear conscience, and enough coins in your pocket to buy a pint!"
- An Irish acquaintance in a Dublin pub

Illustrated Glossary
mick is offline   Reply With Quote
Old 01-21-2018, 02:25 AM   #3
smitty73
AlwNW1X
 
Join Date: Mar 2013
Posts: 13
Ditto that! Thanks Ted...
Smitty73
smitty73 is offline   Reply With Quote
Old 02-03-2018, 10:42 PM   #4
Mr.Pagine
Happy Punting
 
Join Date: Feb 2006
Location: Toronto, Ontario
Posts: 327
What are we talking about....

Whatever it is.... thanks Ted.

Jon
Mr.Pagine is offline   Reply With Quote
Old 01-21-2019, 11:53 PM   #5
pilot
Grade 2
 
Join Date: Dec 2005
Posts: 80
Hi , I would like thank everyone for their insight using the model. I am just starting back with RDSS after taking a break from racing. My question is when I am adding races to my model, how do I move the stats lower so I can add more models. I hope that makes sense.

Thank

Wayne
pilot is offline   Reply With Quote
Old 01-22-2019, 12:39 AM   #6
pilot
Grade 2
 
Join Date: Dec 2005
Posts: 80
I was able to highlight the ratings, from the far left row with a number in it. Then right click on insert and that moved them down quite a bit. I was adding to model from yesterday and I have 2 new races from today but the count is still the same. What am I doing wrong.

Thanks

Wayne
pilot is offline   Reply With Quote
Old 01-22-2019, 04:41 PM   #7
DaveEdwards
Grade 1
 
DaveEdwards's Avatar
 
Join Date: Nov 2008
Location: England
Posts: 408
Hi Wayne,

I have taken a look at the spreadsheet and if I'm reading your issue correctly it should be easy to overcome.

It all depends where you insert the lines on whether or not the formula at the bottom of the sheet automatically amend themselves to take account of the extra lines.

If you go into Q25 you will see the following formula
=COUNTIF(Q3:Q20,"=3") / Q22 * 100

Now if you insert the additional lines right at the bottom, presuming you've filled 20 lines and don't want to alter anything you'd click over the number 21 and on the left hand side and drag down a few lines thereby highlighting a few lines across the sheet. The next step would be to right click and insert lines. The problem is that by doing it right at the bottom, you are beyond the range of the formula, that is from rows 3 to 20. Excel assumes you are doing something different now.


The solution is to start with a new blank template. Go to the number 5 for instance on the LHS, hold down the left button and drag down a few numbers. Now right click again to insert rows.


As this has been done in the middle of the range used for the COUNTIF process Excel automatically updates the formula in the cells below.


Summary if you don't care about the details, get a blank template and add extra lines, but always be sure that it is within the range currently specified. In this case 3 and 20. Once you've set up this new version, just copy and paste your data into the new one and you should be good to go.
DaveEdwards is offline   Reply With Quote
Old 01-22-2019, 07:21 PM   #8
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Huntsville, Ontario, Canada
Posts: 7,324
I think Dave has it right. In short, insert your new lines at the bottom, not at the top, yet still above the Stats section. That retains the beginning of the cell range starting at the original top-most row and extends/modifies the end of the range to the new bottom-most row created by the insertion of the rows being inserted from the export file. Then your COUNT and all other columns based on knowing the COUNT stays up to date with newly added rows of data.



Ted
__________________

R
DSS -
Racing Decision Support System™ Follow on Twitter @SartinMethod
Ted Craven is offline   Reply With Quote
Old 01-23-2019, 01:47 AM   #9
Bill Lyster
Grade 1
 
Bill Lyster's Avatar
 
Join Date: Feb 2006
Location: Escondido CA just 25 minutes from where the turf meets the surf - "...at Del Mar"
Posts: 2,075
Or you could add them anywhere in the middle of the data and resort by any way you chose, date, race number, distance, sex, surface, etc.

But be advised, the further the breakdown of data, the fewer data points in each set, so you might have a months worth of data at SA, for example, but only have 4 or 5 six furlong races for 4+ yo fillies and mares.

So far at SA the best factors over all races on dirt are V/dc and Final Odds - with both being in the low to hi 80% range for the top 4 choices. No other single factor over ALL races comes close.

On turf these two factors over all distances and sexes still lead but with slightly less percentages for the top four.

The most predictable races are at 7 furlongs where several factors limit the winner to the top two in those categories.

When I get back from Australia I will post my SA findings since opening day. You will see how few races in each category have a representative number of races.

Until then,

Bill
Bill Lyster is offline   Reply With Quote
Old 01-23-2019, 01:48 AM   #10
pilot
Grade 2
 
Join Date: Dec 2005
Posts: 80
Thank you Dave and Ted, I am placing my new race above the stats and it still not add it to it.
Attached Images
 
pilot 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 Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Modeling Giahorse Sartin Methodology Handicapping 101 (102 ...) 17 11-10-2013 12:35 PM
Advanced Excel Spreadsheet for Modeling Dallas4lr RDSS2 / FAQ's 0 09-22-2012 01:19 PM
MODELING - Does it matter? For The Lead Previous 'Handicapping Discussion' Forum 21 01-29-2012 02:43 PM
You got to LOVE TURFWAY PARK tfm Previous 'Handicapping Discussion' Forum 9 12-20-2008 07:11 AM


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

All times are GMT -4. The time now is 10:49 PM.