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 06-21-2020, 09:11 AM   #331
gandalf380
Grade 1
 
gandalf380's Avatar
 
Join Date: Feb 2006
Location: central islip ny
Posts: 775
The hash marks in a column usually indicate that the column width is not wide enough. AdJust the width of those columns. The main problem seems to be the row labeled count. What is the formula shown in one of those cells. Either it is missing or it’s incorrect.
__________________
Check out my daily picks for the Saratoga Special
http://www.thisishorseracing.com
gandalf380 is offline   Reply With Quote
Old 06-21-2020, 11:55 AM   #332
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Huntsville, Ontario, Canada
Posts: 7,723
As Charlie says, the formula in the Count row is not counting correctly (=0 ). The other row formulas divide by Count, thus divide by 0, and return an error, columns not wide enough to show the #Div/0 error message.

If you know Excel to fix those count formulas, that will do it. Otherwise, just email it to me and I can fix it up for you, no worries.

Ted
__________________

R
DSS -
Racing Decision Support System™
Ted Craven is offline   Reply With Quote
Old 06-21-2020, 05:07 PM   #333
57viking
AlwNW1X
 
Join Date: Jun 2020
Posts: 5
Exporting data

When I export the data . it says to post it in Template 5 . The latest version I have is 4 . There are extra columns that are not in template 4.( EM to EO) One looks like Bris PP ratings.
57viking is offline   Reply With Quote
Old 06-21-2020, 11:23 PM   #334
sdahl
Grade 3
 
Join Date: Feb 2006
Location: Edmonton, Canada
Posts: 69
I discovered the problem. After I copied the information I clicked on "insert copied cells" like I saw in a video that Richie did about exporting data. I tried just hitting paste and everything worked. Thanks
sdahl is offline   Reply With Quote
Old 06-22-2020, 05:18 AM   #335
gandalf380
Grade 1
 
gandalf380's Avatar
 
Join Date: Feb 2006
Location: central islip ny
Posts: 775
Quote:
Originally Posted by 57viking View Post
When I export the data . it says to post it in Template 5 . The latest version I have is 4 . There are extra columns that are not in template 4.( EM to EO) One looks like Bris PP ratings.
The following was posted by Ted in an earlier post.

The latest Export Template distributed in the last update (V2.1.049.11) is MasterTemplate4.xlsx. This template ends at Col EL which is Tote Tx2 rank # (aka P/W ratio). Some few folks might have a MasterTemplate5 which adds several newer data points including BRIS Prime Power and ProfitLine.

However, this template does not populate correctly by the current data export routine, omits data points at the end and garbles a few of them. I will replace it with MasterTemplate6 as soon as I am able to complete and test the correct export order of those last several data items.

Meanwhile, V2.1.049.11 DOES export BRIS Prime Power and its rank as the final 2 data points in the Excel Export routine (Cols ER and ES in the export file). You could modify MasterTemplate4 to add 7 new columns to the right of the last one (Col EL) so the new final Column would be Col ES.

Then when you import from the Excel export files to your modified MasterTemplate4.5 (whatever), BPP will appear in Col ER and BPP rank# in Col ES. And ProfitLine Odds will appear in Col EM.
__________________
Check out my daily picks for the Saratoga Special
http://www.thisishorseracing.com
gandalf380 is offline   Reply With Quote
Old 06-22-2020, 01:04 PM   #336
57viking
AlwNW1X
 
Join Date: Jun 2020
Posts: 5
Thanks , very helpful.
57viking 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


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

All times are GMT -4. The time now is 11:55 PM.