Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Class Shift (Par vs Race Strength) UDM

Home Register
Log In
By Class Shift (Par vs Race Strength) UDM
jeff
6/3/2017
2:52:24 AM		From the email inbox:

--quote:
"Hi Jeff!

I love the program. I'm very happy with it! Having lots of fun exploring the program. I made the $97 back the first day I used it!

I'm having problems trying to make this UDM. I have made several with no problems but this one is under the filter factor list. So it's the first one like this that I have tried to create.

Class Shift (Par vs Race Strength) ­ This number represents a change in class based on the difference between the Standard Race Strength of a horse's most recent race and the data vendor generated (HDW or Brisnet) Par for the Level of today's race. When Race Strength is higher than Par for the Level, Class Shift (Par vs Race Strength) will have a positive number and the horse will be dropping in class. When Race strength is lower than Par for the Level, Class Shift (Par vs Race Strength) will have a negative number and the horse can be thought of as rising in class (or facing tougher competition today.)

I'm just trying to show the horse's with the positive numbers. Every time I try to create the UDM all the horses end up being listed.

Maybe I just need to be able to see the positive numbers on the report?

Any help that you could offer would be greatly appreciated! :)

Thanks!
Tom"
--end quote



Hi Tom,

You mentioned filters in your email. Based on that let's do playlist file mode first.

BASIC OPERATING INSTRUCTIONS for adding Class Shift (Par vs Race Strength) to a playlist file mode UDM:
  1. On the Modify Screen of the UDM Wizard select Filters from the Factors drop down.

    This will cause the buttons for the Dynamic and Preset Filter Tools to appear.

  2. Click the Dynamic Filter Tool button to launch the Dynamic Filter Tool.

    On the Dynamic Filter Tool:

    1. Select Class Shift (Par vs Race Strength) as your Factor.

    2. Select All Classes and Ages as your Context.

    3. Select MIN (min positive value) as your Behavior.

    4. Select 0 as your numeric value.
      --or alternately, select Prompt for Value and key 0 as your min positive value when prompted by the interface.
      --Note that as you are performing these steps the filter tool is building your filter code and displaying it in the little preview window.

    5. Click the ADD FILTER button to paste the filter code from the little preview window to the big preview window.

    6. Double check your work and click the SAVE AND CLOSE button. This will close the Filter Tool, write the filter code(s) displayed in the big preview window to the filter codes field on the Modify Screen of the UDM Wizard and Save the UDM Definition to the Profile and Profile2 tables.



    3. That's It!

    At this point Class Shift (Par vs Race Strength) with a min postive value of 0 has been added to the UDM Definition.

    --The following screenshot shows the Dynamic Filter Tool just before clicking the SAVE
    AND CLOSE button:
    Class Shift (Par vs Race Strength) in the Dynamic Filter Tool




    --The following screenshot shows the Modify Screen of the UDM Wizard just after clicking
    the SAVE AND CLOSE button:
    Class Shift (Par vs Race Strength) in the Dynamic Filter Tool

    --Note that the filter code ")ALL)MIN0" (without the quotes) appears in the special filter codes field and is now part of the UDM Definition.

    --Also note that it is the filter code itself that provides the instructions to the software. And that the Dynamic Filter Tool is just an interface that let's you build the filter code and add it to the UDM Definition in a (semi) intuitive way.

    -- And that if you understood the meaning behind the symbols that makeup the filter codes: You could have bypassed the Dynamic Filter Tool - and simply keyed the filter code ")ALL)MIN0" (without the quotes) into the special filters field and hit the Save button. (And you would have accomplished the objective.)



    -jp

    .

    ~Edited by: jeff  on:  6/3/2017  at:  2:52:24 AM~

    Reply
jeff
6/1/2017
1:13:20 PM		Ok. Now SQL Mode... which is actually much easier.

There's a column in the StarterHistory table named CLSHIFT2 and during db builds that's the field that gets populated with numeric value for Class Shift (Par vs Race Strength.)

To add Class Shift (Par vs Race Strength) to a SQL Mode UDM:

Simply add a line to the sql expression driving the UDM definition - like this:

AND CLSHIFT2 >= 0

Note that (in both playlist file mode and SQL Mode) you are by no means limited to positive values.

Depending on the situation - you could do something like this:

AND CLSHIFT2 >= -15

Or again, depending on the situation - something like this:

AND CLSHIFT2 BETWEEN -4 AND 7


-jp

.

Reply
Reply
Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com