#2>>>each horses output to show the average E-Speed,average finish position with earnings per start, rating for each category at the end of each factor based on 1 to 10 and 10 being the best add all 3 ratings for total. higher e-speed is better,lower finish is better,higher eaning is higher is better. Summary of Total Ratings pdf file spreadsheet compact

 

E-Speed,average finish position with earnings per start ratings based on scale of 1 to 10 with 10 being the best put summary of total ratings for each horse in compact

 

To calculate the Performance Rating (PR) for each horse using the provided equation, we need to normalize the E-Speed Figure (ES) and Earnings per Start (E) to a 10-point scale, and inversely scale the Average Finish Position (AF). Let's calculate the PR for each horse:  EXAMPLE

 

Equation

PR = (ES × 0.4) + (AF × 0.2) + (E × 0.4) where:

• PR = Performance Rating (0-10 scale)
• ES = E-Speed Figure (normalized to 10)
• AF = Average Finish Position (inversely scaled, where lower finish = higher score)
• E = Earnings per Start (normalized to 10)

Example Calculation for Mon Petit Chou

• ES: 88 ÷ 10 = 8.8
• AF: (12 - 4) ÷ 1.2 = 6.67
• E: $6,970 ÷ $700 = 9.96

PR = (8.8 × 0.4) + (6.67 × 0.3) + (9.96 × 0.3)
= 3.52 + 2.00 + 2.99
= 8.51 out of 10

after the rating from equation next to number post  the last-3 e-speed and do avg for last-3 e-speed put in order of Performance Rating

===================================

then calculate the Performance Rating (PR) for a sample horse. PR = (ES × 0.3) + (AF × 0.2) + (E × 0.2) + (JT × 0.1) + (TP × 0.1) + (RC × 0.1) base on 0 to 10 and 10 being the best