Pace and Cap  - Sartin Methodology & The Match Up

Pace and Cap - Sartin Methodology & The Match Up (http://paceandcap.com/forums/index.php)
-   RDSS 2.2 (and previous versions) (http://paceandcap.com/forums/forumdisplay.php?f=149)
-   -   I love the New modeling Template(4) (http://paceandcap.com/forums/showthread.php?t=11439)

Bill V. 01-20-2018 11:29 AM

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

mick 01-20-2018 12:59 PM

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

smitty73 01-21-2018 02:25 AM

Ditto that! Thanks Ted...
Smitty73

Mr.Pagine 02-03-2018 10:42 PM

What are we talking about....
 
Whatever it is.... thanks Ted.

Jon

pilot 01-21-2019 11:53 PM

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 01-22-2019 12:39 AM

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

DaveEdwards 01-22-2019 04:41 PM

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.

Ted Craven 01-22-2019 07:21 PM

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

Bill Lyster 01-23-2019 01:47 AM

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

pilot 01-23-2019 01:48 AM

1 Attachment(s)
Thank you Dave and Ted, I am placing my new race above the stats and it still not add it to it.


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

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