Take a look at the Model worksheet (e.g. DMR.xls). The Master Template layout provided has a few interesting features.
It has a horizontal and a vertical splitbar, so you can always keep the headers visible (horizontal) and so you can scroll to see distant parts of the worksheet on the right (vertical). The template provided has only 1 Tab (renamed to DMR), but you may wish to create several Tabs to organize data for the track: for example one Tab for each distance and surface, or group together similar distances. Or you can put all lines in one Tab and sort and group them by distance, surface, race type.
At the bottom, between the 2 dark horizontal lines, are an initial set of formulas which apply to all the data above the formula section. You can use these formulas or create your own. Provided are Max, Min, Average and Percentage of ranks #1 and #2. When that percentage exceeds 61%, the cell shows RED, meaning it may be an interesting factor.
Factors with Rank #1 and Rank #2 are highlighted in
RED and
GREEN respectively.
If you get too much data in the section above the formula section (i.e. some of it is too old), simply highlight the rows you wish to remove, Cut them (Ctrl-X, or right-click and Cut), and place them below the formula section. That way, you retain the data, but they no longer figure in the formulas you may be applying to more current data.
Scroll along the worksheet and familiarize yourself with the columns and the groups. Everything is there from the various Analysis screens (omitting some readouts which appear twice or more, or are redundant to other readouts). In general, the worksheet contains mostly ranks, as the compuond factors actual values are generally not standardized, or interesting. At the far right of the worksheet, the actual adjusted PoH and PoR velocities are shown, along with Adjusted Call Times, running positions and Beaten Lengths for those who wish to make their own calculations, or to tinker (beware spending too much time tinkering...). Check the
Early/Late Difference Column (
BF). The Min/Max and Average formulas at the bottom can help to establish what the normal E/L range for the surface and distance is. Consider adding a
Median formula for this factor, and consider discarding Min and Max values which are
way outside of the central Mean (average) or Median distribution.
Note about
E/L Difference Rank (column
BG): this E/L rank does
not appear in RDSS currently and I am not adding it in until a later version, but I made a place for you to track it if you wish, by recording it manually. If the Winner was the
Earliest of the E/L early (RED) sticks, he would be rank #1. The 2nd Earliest would be rank #2, etc. Similarly, if the Winner (e.g. in a route) is the most Late, you would record it as rank -1 (negative, to correspond to how Early E/L values are positive, and Late E/Ls are negative), rank -2 for 2nd most Late, etc. Scanning the E/L rank column may eventually indicate to you, for example, that the Top 2 Early ranks win an interesting percentage of the time for a (e.g. sprint) distance, or win at net positive ROI mutuels, perhaps if their corresponding Total Energy (and perhaps BL/BL) happens to be also ranked low. There are other ways to record E/L ranks, but this use of negative ranks for Late and positive ranks for Early is the way I propose to do this within RDSS in future.
If there is too much information for you (
and there is!) you can hide the columns you tend not to use by using Excel's Hide Columns feature (right-click on a group of columns and choose Hide, and check Help to Unhide!).
As long as you maintain the same contiguous column specs and data type as supplied by the RDSS export file, you can import to your model regardless of what columns you Hide or what
extra columns (at the end) or Header changes, or extra formulas, or distinct sections within a worksheet you may create. You can make your own Template file, add macros or VBA code to manipulate the incoming data from the export file however you want.
Addendum:
Richie has made a short tutorial video showing how to do the whole export, copy and paste routine described above:
http://www.SartinMethodology.com/med...xcelModels.wmv (
Tip: you can create new, blank model files for a track by opening the MasterTemplate then
Save As a new Excel file, named for your track).