Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Report Viewer Help Doc

Home Register
Log In
By Report Viewer Help Doc
SILVER01HDW
9/11/2015
10:53:22 PM
Jeff -

Is there an updated doc available or am I missing something regarding the report viewer for the Silver version I'm using. The examples on the document I'm reading look much different and I'm having a hard time following along to understand the report viewer.

Suggestions?

Thanks,

KP

Reply
jeff
9/12/2015
10:49:37 AM
I agree - the Reading The Reports Help Doc is out of date and does not contain screenshots of the Silver HTML Reports.

That said, if you can bear with me (it may take a bit depending on how my race day shakes out) I'll log into the program as a Silver user - generate some html reports for today's stakes race at Belmont (SAT 09-12-2015 R9) - upload .html files to the JCapper server - and then come back to this thread and post descriptions of what's displayed on the reports.


-jp

.


Reply
jeff
9/12/2015
11:44:12 AM
Silver HTML Report - Playlist File Mode

Link to Silver HTML Report for BEL 09-12-2015 R9:
http://www.JCapper.com/Messageboard/Reports/BEL09122015_PL_R9.html

The following "Key" contains column headers as they appear (left to right) on the report along with the factor displayed in each column:


------------- --------------------------------------------------------------------------------------
Column Header Factor
------------- --------------------------------------------------------------------------------------
PP Saddle cloth number/ betting interest identifier
Name Name of horse
------------- --------------------------------------------------------------------------------------
UProb UPRMLProb = a probability estimate generated using SilverRating and morning line odds
OL Odds Line = ((1/UPRMLProb) - 1)
------------- --------------------------------------------------------------------------------------
CPace CPace numeric value (rank in parenthesis)
EaCN EarlyConsensus numeric value (rank in parenthesis)
E1(gray) CompoundE1 numeric value (rank in parenthesis)
E2(gray) CompoundE2 numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
TP TPace rank - click to see numeric value
SP SustainedPace rank - click to see numeric value
AP(gray) CompoundAP rank - click to see numeric value
SP(gray) CompoundSP rank - click to see numeric value
------------- --------------------------------------------------------------------------------------
PAL Pace Adjustsed Late rank - click to see numeric value
L3 Late Pace rank best of last 3 - click to see numeric value
CL CompoundLate rank - click to see numeric value
TT Compound Turn Time rank - click to see numeric value
------------- --------------------------------------------------------------------------------------
WFig Weighted Figure numeric value (rank in parenthesis)
Style HDW Run Style - with tic mark and ALT QSpeedPoints
PctE PercentEarly numeric value (rank in parenthesis)
PFit CompoundPaceFit numeric value (rank in parenthesis)
LSlnt Late Slant Fig numeric value (rank in parenthesis)
HType HorseType
------------- --------------------------------------------------------------------------------------
MLOR5 Morning Line Odds divided by UPRMLProb Odds Line
QSP QSpeedPoints (rank in parenthesis)
PED HDW Distance Pedigree Rating (rank in parenthesis)
DT Distance Shift
------------- --------------------------------------------------------------------------------------
AFR Advanced Form Rating numeric value (rank in parenthesis)
CFA Competitive Figure Ability numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
Form FormRating numeric value (rank in parenthesis)
WoBr Workout Brilliance numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
SOR Race Strength rank - click to see numeric value
PSR HDW Projected Speed Rating rank - click to see numeric value
------------- --------------------------------------------------------------------------------------
PwrCN PowerConsensus numeric value (rank in parenthesis)
UPR/Silver Silver Rating numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
ML Morning Line Odds
Rec Recent Activity Days Last Start
T Grade for Trainer (IGNORE THIS! It's out of date!)
------------- --------------------------------------------------------------------------------------
Jockey Jockey Name
Trainer Trainer Name
------------- --------------------------------------------------------------------------------------



Note: SQL Mode Silver HTML Report to follow.



-jp

.




Reply
jeff
9/12/2015
1:33:11 PM
Silver HTML Report - SQL Mode

About SQL Mode HTML Reports:

Unlike the report layout of the playlist file mode html report (which is "canned" or "hard coded" into the program) - the SQL Mode HTML Report Layout can be customized by the user.

The Silver SQL Mode HTML Report displayed at the link presented below does contain one added customization:

Prior to generating the report, I brought up the Factor Setup Tool. On Screen Two I removed JPRMLProb from slot #01 and replaced it with UPRMLProb.

I did this because JPR is not supported in JCapper Silver. In JCapper Silver SilverRating is the supported power rating and SilverRating and UPR are one and the same thing.

From there, while still on Screen Two I hit the Save button and kept hitting the Next button until I came to the Deatil Screen.

Then, in the Detail Screen I highlighted slot 01 in Column1 on the report layout and changed the column header text from JPRProb to UPRProb and hit the Save button.

At that point (with the one customization I wanted to do for this post out of the way) I x-ed out of the Factor Setup Tool, used Scratch Bot to parse the XML, verified that there were a few early scratches for BEL, and went into the User Sys Defs Screen where I checked the box to operate JCapper in SQL Mode, hit the Save button, x-ed out of the User Sys Defs Screen - and ran a SQL Mode Calc Races for BEL R9 to generate the linked to report.

Screenshots:
here
-and-
here

Note: Here's a link to a 4 part web tutorial that covers the Factor Setup Tool in more depth than what I posted above:
http://www.jcapper.com/Article_AddJRating.html

Okay, with that bit of background info out of the way, here's a link to a Silver HTML Report for BEL 09-12-2015 R9:
http://www.JCapper.com/Messageboard/Reports/BEL09122015_SQL_R9.html

The following "Key" contains column headers as they appear (left to right) on the report along with the factor displayed in each column:


------------- --------------------------------------------------------------------------------------
Column Header Factor
------------- --------------------------------------------------------------------------------------
PP Saddle cloth number/ betting interest identifier
Name Name of horse
------------- --------------------------------------------------------------------------------------
UPRProb UPRMLProb = a probability estimate generated using SilverRating and morning line odds
OL Odds Line = ((1/UPRMLProb) - 1)
ML Morning Line Odds (rank in parenthesis)
MLOR3 Morning Line Odds divided by UPRProb Odds Line (I really should have changed the
column header text for this from MLOR3 to MLOR5 before posting.)
------------- --------------------------------------------------------------------------------------
CPace CPace numeric value (rank in parenthesis)
PMI PMI num val (rank in parenthesis) shown as 0's because PMI not supported in Silver
Silver users would use the Setup Tool to display an alternate factor in this slot

PFit CompoundPaceFit numeric value (rank in parenthesis)
EaCN EarlyConsensus numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
AFR Advanced Form Rating numeric value (rank in parenthesis)
Form Form Rating numeric value (rank in parenthesis)
WBrill Workout Brilliance numeric value (rank in parenthesis)
FmCn Form Consensus numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
WFig Weigthed Figure numeric value (rank in parenthesis)
TPace TPace numeric value (rank in parenthesis)
CFA CFA numeric value (rank in parenthesis)
FgCn Fig Consensus numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
PAL Pace Adjustsed Late rank - click to see numeric value
L3 Late Pace rank best of last 3 - click to see numeric value
CpLt CompoundLate rank - click to see numeric value
LtCn Late Consensus rank - click to see numeric value
------------- --------------------------------------------------------------------------------------
Rstr Race Strength numeric value (rank in parenthesis)
Ped HDW Distance Pedigree Rating rank - click to see numeric value
PCls PClass numeric value (rank in parenthesis)
ClCn Class Consensus numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
OP OptPts num val (rank in parenthesis) shown as 0's because OptPts not supported in Silver
Silver users would use Setup Tool to display an alternate factor in this slot

Stg Stage Readiness - shown as 0's because factor not supported in Silver
Silver users would use Setup Tool to display an alternate factor in this slot

RC RouteCycle (1=yes 0=no)
CRun CantRunXFormAttribute (0=clean 1=dirty 2=cantrun)
------------- --------------------------------------------------------------------------------------
RStyle HDW RunStyle (upper/lower case with tic marks)
QSpd QSpeedPoints
Yrs AgeOfHorse
Sex Sex of horse
------------- --------------------------------------------------------------------------------------
FCyc JCapper Form Cycle (1-8)
Rec Recent Activity Days Last Start
Wo Recent Activity Days Last Work
DT Distance Shift
------------- --------------------------------------------------------------------------------------
JPR JPR num val (rank in parenthesis) shown as 0's because JPR not supported in Silver
Silver users should use Setup Tool to display an alternate factor in this slot

UPR SilverRating numeric value (rank in parenthesis)

ALC Alchemy num val (rank in parenthesis) shown as 0's factor not supported in Silver
Silver users should use Setup Tool to display an alternate factor in this slot

PwCn Power Consensus numeric value (rank in parenthesis)
------------- --------------------------------------------------------------------------------------
CXN Connection Rating rank - click to see numeric value
Jky Rider Win Pct
TNR Trainer Win Pct
Drv Drive Type
------------- --------------------------------------------------------------------------------------
Sire Name of Sire
Rider Jockey Name
Trainer Trainer Name
Dam Name of Dam
------------- --------------------------------------------------------------------------------------






-jp

.


Reply
SILVER01HDW
9/13/2015
2:38:08 PM
Jeff,

Really appreciate you taking the time to post this.

KP

Reply
Reply

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