View Single Post
Old 09-24-2024, 02:46 AM   #3
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Nanaimo, British Columbia, Canada
Posts: 9,264
Here is an update to RDSS with the Leverage/Pace module:

[please see the latest version further below]

This update is about a three-quarters-way deposit on the Excel export - modelling upgrade, which alas is not quite ready.

Included items:

1. The Pace Bias readouts are more or less reversed from previously: Late is BLUE, Early is RED, Neutral is PURPLE. The points system and bias interpretation is unchanged.

2. Pace Bias readout on the Rx and NewPace screens is as on the Leverage/Pace screen: the coloured bias number (according to bias groups) on a white background. This display will eventually be on all Analysis screens.

3. When you assemble races, the Pace Bias now shows on the Card Summary screen. Eventually this will load immediately, but right now - like with the FTS count - you have to assemble first.

4. The NewPace screen is now automatically sorted according to the Pace Bias - sort by Low-range when Late/Pressured; sort by High-range otherwise (Neutral or Early/Unpressured). You can always re-sort by whatever you like on NP, but these are the new defaults: no need to sort during KEY interpretation process.

5. The KEY Contender value now exports for use in Excel models (value=11 in Contender Group+ Col EE)

6. You can select a KEY horse from the KEY Contenders by clicking on one of the BLUE arrows (KEYs) - which changes to a RED arrow. This marks a Selected KEY. This will Export to Excel with value=15 in Contender Group+ Col EE.

These export values for KEY Contenders (11) and Selected KEY (15) are in service of having data in the Excel database to eventually filter and analyze races by these choices.

7. There is a new Excel Template file in the \Models\ folder: Model.Database.2024.xlsx This template is not quite ready for prime-time but has the columns corrected for the layout of the Excel export created by RDSS. There will be numerous examples of customized sheets which answer various kinds of specific questions - presumably including every kind of customized sheet layout we are currently working with.

Again - more to follow soon on the Export module - but for now, you can import your exported Excel files into a copy of this new template and put ALL ROWS (not just 1st and 2nd place finishers) into the first Data sheet. The subsequent sheets will simply filter and sort from the entire row population of the Data sheet (the 'database').

If you want to continue using the existing MasterTemplate6 until the new template file is working - feel free - it should all be portable.

8. The Export Data button on the (for now) Rx and Leverage/Pace screens replaces the previous Export Icon. One major difference - now when you export a single race, the export is also placed in the Cache (as well as where it has always been in the Models folder). On the Card Summary screen, you will see an Export button at the far right with check-marks by the races you have marked for Export. At any point, you will be able (soon, not in this release ) to export ALL marked races at once into one big export file for the whole day (or many races/multiple tracks on the My Races screen). You can then import all these races at once into the Master Template file, rather than many individual races. RDSS will offer to open both the export sheet and the Master Template Excel sheet to make it even easier to add data to your Excel data models. (Eventually, RDSS will just add the exported data to the Master Template by itself - no copying required).

For now - you need to use the existing method to get data into your Excel models. Next RDSS update will bring all these new model options, along with various examples of model layouts. I am working with as many different layouts of sheets you all have sent me to make this new system accommodate what we have been working with all along - only better (hopefully!)

Good luck - feedback welcomed!

Ted
__________________

R
DSS -
Racing Decision Support System™

Last edited by Ted Craven; 10-08-2024 at 05:09 PM.
Ted Craven is offline