Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Average

Home Register
Log In
By Average
CalvinJ
8/24/2020
5:26:04 AM
Is there a way to obtain a average of the 4 power numbers on the HTLM report ( i.e. JPR-UPR-ALC-POW CON)? To view the average in the HTML report?

~Edited by: CalvinJ on: 8/22/2020 at: 10:56:44 PM~

~Edited by: CalvinJ  on:  8/24/2020  at:  5:26:04 AM~

Reply
jeff
8/29/2020
11:03:39 AM
Sorry for not seeing this sooner.

In JCapper Platinum UPR Tools you can create factors using other factors as inputs.

You can do this using a number of Behaviors - including Behaviors that cause the factor you are creating to be a weighted average of other factors.

Screenshot, here.

However, before you can do that - you need to understand the Event Chain Hierarchy.

This is the UPR Tools Event Chain Hierarchy supported in the latest published version (07-08-2020) of the JCapper Platinum Main Module:
--------------------------------------------------
POS GROUPNAME FACTOR
--- -------------- ------------------------------
0 na Standard factors like CPace,
LateConsensus, and WoBrill
--------------------------------------------------
1 DEFAULT JPR
--------------------------------------------------
2 USERFACTOR1 USERFACTOR1
--------------------------------------------------
3 USERFACTOR2 USERFACTOR2
--------------------------------------------------
4 USERFACTOR3 USERFACTOR3
--------------------------------------------------
5 USERFACTOR4 USERFACTOR4
--------------------------------------------------
6 na Containerless Prob Expressions
--------------------------------------------------
7 USERFACTOR5 USERFACTOR5
--------------------------------------------------
8 USERFACTOR6 USERFACTOR6
--------------------------------------------------
9 USERFACTOR7 USERFACTOR7
--------------------------------------------------
10 USERFACTOR8 USERFACTOR8
--------------------------------------------------
11 ALCHEMY ALCHEMY (User Defined)
--------------------------------------------------
13 PRATING PRATING (User Defined)
--------------------------------------------------
14 QRATING QRATING (User Defined)
--------------------------------------------------
15 USER DEFINED UPR
--------------------------------------------------
16 UPRMLPROB UPRMLPROB (User Defined)
--------------------------------------------------
17 UPROPINIONPROB UPROPINIONPROB (User Defined)
--------------------------------------------------
18 na Factors based on UPR like
PowerConsensus, HDW_PScore,
--------------------------------------------------


The concept behnd this is actually pretty simple.

When you click the Calc Races button - logic in the program performs number crunching in a predefined order.

That predefined order is called the Event Chain Hierarchy.

Factors with lower positions in the Event Chain Hierarchy are calculated first.

Factors with higher positions in the Event Chain Hierarchy are calculated next.

Logic in the program works its way upward through the Event Chain Hierarchy - until number crunching has been performed for every factor in the event chain.

This has implications when you are creating factors in UPR Tools.

When you are creating a GroupName - all factors used as inputs for that GroupName must have a lower position in the Event Chain Hierarchy than the factor you are creating.

For example, if you are creating USERFACTOR1:

You can use factors like CPace, WoBrill, and JPR as inputs - because they have lower positions in the Event Chain Hierarchy than the factor you are creating (UserFactor1.)

But you cannot use factors with higher positions in the Event Chain Hierarchy such as UserFactors 2 through 8 or UPR - because they do not exist (have not yet been calculated) at the point in time in the event chain when UserFactor1 is being calculated.

Read the above three paragraphs again. (They apply to every user defined factor you can create in UPR Tools.)

You asked: "Is there a way to obtain a average of the 4 power numbers on the HTLM report ( i.e. JPR-UPR-ALC-POW CON)? To view the average in the HTML report?"

The short answer is no. (At least not in the current program.)

Doing that in the current program would involve using PowerConsensus as an input - which would 'break' the Event Chain Hierarchy.

PowerConsensus uses UPR as an input and is one of the very last factors calculated in the event chain.


However, if you do not currently have a GroupName for UPR, you could create a weighted average from any factors having lower positions in the Event Chain Hierarchy than UPR - including JPR, Alchemy, PRating, QRating, etc. - and from there display UPR on your SQL Html Report.

Hope I managed to type most of that out in a way that makes sense,


-jp

.


Reply
CalvinJ
8/29/2020
10:31:50 PM
Hi Jeff

Of course, I've been averaging them myself, for purposes of evaluation, which is very simple. But I thought if I could automate the process, things would go faster. But this is cool stuff, but maybe kinda, "dangerous", for this "peahead"!! If I tried to make this work, I'd probably ruin my default/JPR #. Thanks so much for education on the working of the UPR, though.

I'll need a little more confidence in working with this process before I try anything "fancy". Thanks so much!!



Reply
Reply

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