I'm not sure how great a creation it is but I've written an EquiSim FV that will give you Beyer Speed Figs. Before you get to excited the numbers are "Raw" numbers that are produced from the chart in Andy Beyer's book not the "Projected" numbers that you find now in the Daily Racing Form. The number is strictly based on the horse's final time. I have written a second formula that will use the DRF track variant in the exact way that Tom Hambleton does when he adjusts his TPR numbers to adjust the "Raw" Beyer number.If you use them one mental adjustment will need to be used. Because the formula cannot tell the difference between 1 turn and 2 turn mile races you need to subtract 9 points from the rating from a known 1 turn mile race.

Raw Beyer formula

#GREATER($ppDistFurs, 4.4) * #LESSER($ppDistFurs, 7.8) *
(127-ROUND(ROUND(($ppHFinalTime-(68.6-((6-$ppDistFurs)*12.4)))*
5)*((1/(95.6-((8-$ppDistFurs)*13)))*200))) +

#GREATER($ppDistFurs, 7.9) * #LESSER($ppDistFurs, 10.1) *
(133-ROUND(ROUND(($ppHFinalTime-(100.4-((8.5-$ppDistFurs)*13)))*
5)*((1/(122-((10-$ppDistFurs)*13)))*200)))

If you would prefer not to roll your own FV I'll send you the one I wrote.

This message has been edited. Last edited by: Keith,

Here's the formula for the adjusted Beyer Fig using the DRF track variant.

#GREATER($ppDistFurs, 4.4) * #LESSER($ppDistFurs, 7.8) *
(127-ROUND(ROUND(($ppHFinalTime-(68.6-((6-$ppDistFurs)*12.4)))*
5)*((1/(95.6-((8-$ppDistFurs)*13)))*200))+ROUND((($ppDrfVar-17)/2)*((1/(95.6-((8-$ppDistFurs)*13)))*200))) +

#GREATER($ppDistFurs, 7.9) * #LESSER($ppDistFurs, 10.1) *
(133-ROUND(ROUND(($ppHFinalTime-(100.4-((8.5-$ppDistFurs)*13)))*
5)*((1/(122-((10-$ppDistFurs)*13)))*200))+ROUND((($ppDrfVar-17)/2)*((1/(122-((10-$ppDistFurs)*13)))*200)))

The Beyer chart also allows you to create a Beyer rating for the Horse's Mid Pace.

Here's the formula for Horse Pace

#GREATER($ppDistFurs, 4.4)*#LESSER($ppDistFURS, 7.8)
*ROUND(1+((244-($ppHFract4*5)-(($ppDRFVar-17)/2*.65))*5.5))+

#GREATER($ppDistFurs, 7.9)* #LESSER($ppDistFurs, 10.1) *
ROUND(3+((387-($ppHFract6*5)-(($ppDRFVar-17)/2*.6))*2.8))

If you also want a Beyer Race Pace rating (The pace of the horse on the lead at the Mid Pace point)here's the formula for

Race Pace



#GREATER($ppDistFurs, 4.4)*#LESSER($ppDistFURS, 7.8)
*ROUND(1+((244-($ppFractTwo*5)-(($ppDRFVar-17)/2*.65))*5.5))+

#GREATER($ppDistFurs, 7.9)* #LESSER($ppDistFurs, 8.8) *
ROUND(3+((387-($ppFractThree*5)-(($ppDRFVar-17)/2*.6))*2.8))+

#GREATER($ppDistFurs, 8.9)* #LESSER($ppDistFurs, 10.1) *
ROUND(3+((387-($ppFractTwo*5)-(($ppDRFVar-17)/2*.6))*2.8))

I create a CJ Fig like Pace/Pace rating by multiplying the Horse Pace times 2 and then subtracting the Race Pace from it. By just using each horse's last two races I've gotten some nice longshots using this.

Hi K
Thanks very much. A lot of work here.
Jerry

Hi Keith and Jerry.

Nice work Keith! Thanks for sharing.

Merry Christmas, and best holiday wishes to you guys, and the rest of the ES family.

W

Hi Win
As they say on Stargate,
Back AtChay
Jerry

Win you know I couldn't have figured out how to connect all those numbers together without a little help from you.

Merry Christmas to all my fellow EquiSim users.

Keith