Pace and Cap - Sartin Methodology & The Match Up - View Single Post - Release Notes

Ted Craven · 03-09-2009, 05:55 PM

This version adds an Export to Excel feature, enabling you to send all Analysis data from RDSS to an Excel 2003 (XLS) format file. What you do with this Excel file is up to you! There is a Master Template XLS file provided which you can use as a template to create Excel model worksheets for each track you work. The file exported by RDSS contains one row for each paceline in your Analysis screens (e.g. 5 lines/horses = 5 rows in the Excel file). With just a few keystrokes, you can Copy and Paste the line for the race Winner (or the Place horse) into your model worksheet. There are a few example formulas supplied to show Min, Max Average and % of rank #1s and #2 for any ranked Factor. Of course you can add your own formulas, formatting, sorting, grouping, graphs, multiple Tabs, etc to your own worksheet - RDSS's job is to provide you with a file of data to plug into it. If you don't use Excel, you can have RDSS create a CSV (Comma Separated Value) format file, usable by most other spreadsheet programs. Let's get started!

As usual, you can download the latest RDSS version here: www.PaceandCap.com/rdssdownload (you have to be registered for RDSS)

What this is NOT

Models are not the magic bullet to finally making money using Sartin Methodology tools (e.g. RDSS)! The matchup of horses' running styles and typical energy disbursement abilities and patterns in a given race often supersede the energy demands of a track, distance, surface (and accounts for a certain percentage of the variance when a strong factor sometimes does not apply). You don't have to begin using a model if the Matchup alone is working well enough for you. But knowing which factors are strong either recently or persistently on a given surface and distance, or what their range of values are (for example the Early/Late range) helps at minimum to identify non-contenders, and weaknesses in public favourites.

This new Export to Excel feature is not intended as a Wager Decision Form, or a wager tracking mechanism. It's intended to provide the input data on RDSS Factors, ranks ranges of values, which may be more or less impactful at certain tracks, distances, surfaces or for certain classes of races, for example Maidens versus Non-Maidens, young horses versus older horses, etc. You can certainly merge your wager tracking with your factor modeling if you want to: you'll have to organize a worksheet where you can sort and group across track and date (i.e. by wager).

This is not a track profile maker, where you track how Winners run from Result Charts. The RDSS output file comes from Past Performance lines you select and place in the Analysis section (presumably using a consistent paceline selection strategy).

This is also not intended to be the end-product of RDSS Modelling capabilities. A full, built-in modeller (and profile maker, and wager bookkeeping) will be an integral part of the upcoming (and largely rewritten) RDSS Version 0.99, later this Autumn. You will be able to slice and dice model information how ever you want, and also keep track of your wagers and mutuel results (more than you really need, actually), without relying on Excel for anything. This current Export to Excel feature is simply a stop-gap until then. If you don't know how to use Excel, no worries: in the meantime, just continue using pen and paper, or whatever software tools you might currently be using (try the CSV file export, though).

What's Provided

When you install RDSS Version 0.98.8, you get a new sub-folder within your RDSS folder: Models. I suggest you make a shortcut on your Desktop (using Windows Explorer) to this new Models folder for easy access. In the Models folder are initially 2 files: MasterTemplate.xls and DMR20090725-03.xls. If you want RDSS to create export files is CSV format, make another sub-folder within the Models folder named CSV, and look there for the CSV files.

DMR20090725-03.xls is an example of an Excel file exported by RDSS. MasterTemplate.xls is an example of a file you can make copies of to make Excel worksheets (e.g. one for each track) into which you copy (for example) the Winner's data from the exported file. The MasterTemplate contains 1 Tab (1 worksheet) named 'MasterTemplate', per the file name. Before you start to add data from RDSS, you may want to rename this to the name of the Track (e.g. DMR in our example), and you may wish to add several new tabbed worksheets with the same MasterTemplate format - one for each common distance and surface (right-click the MasterTemplate tab and choose Move or Copy, then check 'Create Copy').

How to Get Data from RDSS into the Model Worksheet

(Note: the Excel screen shots below are taken from Excel 2007, but earlier versions of Excel should appear pretty similarly).

1. Work a race the way you normally do: select pacelines to place in the Analysis section to evaluate and decide if a wager is possible. Keep as many pacelines as you normally do (e.g. 5)

2. On the Bottom Line/Betting Line screen, you will see a new button 'Export to Excel' (and not the Export button on the Original or Adjusted screens). Click on this button to create an Excel (and optionally a CSV) export file for the current race on the new Rdss\Models folder. The message box tells you if the export succeeded and where the files were placed.

If you are connected to the RDSS toteboard, tote information is included. If the race is Official, the mutuels are also included and the Top 3 finishers are identified as W, P, S. Otherwise this information is left blank. The exported data is sorted according to the BL/BL screen.

3. Now switch to your Rdss\Models folder (use your new Desktop shortcut). If you have not yet made a copy of the MasterTemplate.xls file for your current track, make a copy of it and rename it, for example, DMR.xls (don't keep models in the MasterTemplate file!). Keep all your model files in the Models folder. Open the DMR.xls worksheet file. Now look for the export file you just created (e.g. DMR0725-03.xls - the sample export file) and open it also by double-clicking it. You now have your export file and your model file both open in Excel.

4. In the DMR0725-03.xls file, right-click along the left edge of the worksheet on the row for the Winner (look for the W in the Results column, or just look at the Horse Name). With that row highlighted, choose Copy (or simply highlight the row and use Ctrl-C to copy it).

5. Now switch to the model worksheet (e.g. DMR.xls). Find the first blank row (row 3, initially) and right-click on the rows identifier (along the left-hand edge of the worksheet). Choose Paste Special (not Paste), then choose Values from the Paste Special dialog which pops-up, then click OK.

6. The copied row (for the Winner) from the Excel worksheet exported from RDSS now appears in your DMR model sheet, and all the data Values are formatted according to the layout of the Master Template (hence the Paste Special | Values choices).

Congratulations - you now have 1 entry in your DMR Model! Take less than 60 seconds for each race you work from now on and store the Winner's line in a Model file. Soon enough, you will have an abundance of information on, generally (i.e. subject to Matchup considerations) what it takes to be in Win contention at the different tracks, surfaces and distances you work.

(continued next post...)
...

03-09-2009, 05:55 PM	#1
Ted Craven Grade 1 Join Date: Jun 2005 Location: Nanaimo, British Columbia, Canada Posts: 8,853	Release Notes - Version 0.98.8 This version adds an Export to Excel feature, enabling you to send all Analysis data from RDSS to an Excel 2003 (XLS) format file. What you do with this Excel file is up to you! There is a Master Template XLS file provided which you can use as a template to create Excel model worksheets for each track you work. The file exported by RDSS contains one row for each paceline in your Analysis screens (e.g. 5 lines/horses = 5 rows in the Excel file). With just a few keystrokes, you can Copy and Paste the line for the race Winner (or the Place horse) into your model worksheet. There are a few example formulas supplied to show Min, Max Average and % of rank #1s and #2 for any ranked Factor. Of course you can add your own formulas, formatting, sorting, grouping, graphs, multiple Tabs, etc to your own worksheet - RDSS's job is to provide you with a file of data to plug into it. If you don't use Excel, you can have RDSS create a CSV (Comma Separated Value) format file, usable by most other spreadsheet programs. Let's get started! As usual, you can download the latest RDSS version here: www.PaceandCap.com/rdssdownload (you have to be registered for RDSS) What this is NOT Models are not the magic bullet to finally making money using Sartin Methodology tools (e.g. RDSS)! The matchup of horses' running styles and typical energy disbursement abilities and patterns in a given race often supersede the energy demands of a track, distance, surface (and accounts for a certain percentage of the variance when a strong factor sometimes does not apply). You don't have to begin using a model if the Matchup alone is working well enough for you. But knowing which factors are strong either recently or persistently on a given surface and distance, or what their range of values are (for example the Early/Late range) helps at minimum to identify non-contenders, and weaknesses in public favourites. This new Export to Excel feature is not intended as a Wager Decision Form, or a wager tracking mechanism. It's intended to provide the input data on RDSS Factors, ranks ranges of values, which may be more or less impactful at certain tracks, distances, surfaces or for certain classes of races, for example Maidens versus Non-Maidens, young horses versus older horses, etc. You can certainly merge your wager tracking with your factor modeling if you want to: you'll have to organize a worksheet where you can sort and group across track and date (i.e. by wager). This is not a track profile maker, where you track how Winners run from Result Charts. The RDSS output file comes from Past Performance lines you select and place in the Analysis section (presumably using a consistent paceline selection strategy). This is also not intended to be the end-product of RDSS Modelling capabilities. A full, built-in modeller (and profile maker, and wager bookkeeping) will be an integral part of the upcoming (and largely rewritten) RDSS Version 0.99, later this Autumn. You will be able to slice and dice model information how ever you want, and also keep track of your wagers and mutuel results (more than you really need, actually), without relying on Excel for anything. This current Export to Excel feature is simply a stop-gap until then. If you don't know how to use Excel, no worries: in the meantime, just continue using pen and paper, or whatever software tools you might currently be using (try the CSV file export, though). What's Provided When you install RDSS Version 0.98.8, you get a new sub-folder within your RDSS folder: Models. I suggest you make a shortcut on your Desktop (using Windows Explorer) to this new Models folder for easy access. In the Models folder are initially 2 files: MasterTemplate.xls and DMR20090725-03.xls. If you want RDSS to create export files is CSV format, make another sub-folder within the Models folder named CSV, and look there for the CSV files. DMR20090725-03.xls is an example of an Excel file exported by RDSS. MasterTemplate.xls is an example of a file you can make copies of to make Excel worksheets (e.g. one for each track) into which you copy (for example) the Winner's data from the exported file. The MasterTemplate contains 1 Tab (1 worksheet) named 'MasterTemplate', per the file name. Before you start to add data from RDSS, you may want to rename this to the name of the Track (e.g. DMR in our example), and you may wish to add several new tabbed worksheets with the same MasterTemplate format - one for each common distance and surface (right-click the MasterTemplate tab and choose Move or Copy, then check 'Create Copy'). How to Get Data from RDSS into the Model Worksheet (Note: the Excel screen shots below are taken from Excel 2007, but earlier versions of Excel should appear pretty similarly). 1. Work a race the way you normally do: select pacelines to place in the Analysis section to evaluate and decide if a wager is possible. Keep as many pacelines as you normally do (e.g. 5) 2. On the Bottom Line/Betting Line screen, you will see a new button 'Export to Excel' (and not the Export button on the Original or Adjusted screens). Click on this button to create an Excel (and optionally a CSV) export file for the current race on the new Rdss\Models folder. The message box tells you if the export succeeded and where the files were placed. If you are connected to the RDSS toteboard, tote information is included. If the race is Official, the mutuels are also included and the Top 3 finishers are identified as W, P, S. Otherwise this information is left blank. The exported data is sorted according to the BL/BL screen. 3. Now switch to your Rdss\Models folder (use your new Desktop shortcut). If you have not yet made a copy of the MasterTemplate.xls file for your current track, make a copy of it and rename it, for example, DMR.xls (don't keep models in the MasterTemplate file!). Keep all your model files in the Models folder. Open the DMR.xls worksheet file. Now look for the export file you just created (e.g. DMR0725-03.xls - the sample export file) and open it also by double-clicking it. You now have your export file and your model file both open in Excel. 4. In the DMR0725-03.xls file, right-click along the left edge of the worksheet on the row for the Winner (look for the W in the Results column, or just look at the Horse Name). With that row highlighted, choose Copy (or simply highlight the row and use Ctrl-C to copy it). 5. Now switch to the model worksheet (e.g. DMR.xls). Find the first blank row (row 3, initially) and right-click on the rows identifier (along the left-hand edge of the worksheet). Choose Paste Special (not Paste), then choose Values from the Paste Special dialog which pops-up, then click OK. 6. The copied row (for the Winner) from the Excel worksheet exported from RDSS now appears in your DMR model sheet, and all the data Values are formatted according to the layout of the Master Template (hence the Paste Special \| Values choices). Congratulations - you now have 1 entry in your DMR Model! Take less than 60 seconds for each race you work from now on and store the Winner's line in a Model file. Soon enough, you will have an abundance of information on, generally (i.e. subject to Matchup considerations) what it takes to be in Win contention at the different tracks, surfaces and distances you work. (continued next post...) ... __________________ RDSS - Racing Decision Support System™ Last edited by Ted Craven; 07-28-2009 at 09:44 PM.