Averaging Internal Fractions

[coachv30]

Originally Posted by iwearpurple

Here is a formula that I have used to address this issue. There may be simpler formulas, but this is what I have used for many years

Lets call the cell with your IF1 "C2"

=((C2-INT(C2))*2+INT(C2)

So if cell C2 is 22.1, this formula (placed in another cell) will return 22.2.

Suppose I'm adjusting it already manually before I enter it? For example, the actual fraction is 23 2/5 seconds. This horse lost 4 lengths from call to call. I would enter the internal fraction as 24.1 instead of a 23.6 (using 1/5 second for every length gained / lost). Since I'm doing it consistently for every fraction of every runner, doesn't it become relative?

I realize that EXCEL is not recognizing that I am using 1/5 seconds and therefore returning averages with decimals higher than (.4). But to me, a 23.6 is the same as a 24.1. Am I still incorrect here.

BTW...I appreciate this conversation

[iwearpurple]

Originally Posted by coachv30

Suppose I'm adjusting it already manually before I enter it? For example, the actual fraction is 23 2/5 seconds. This horse lost 4 lengths from call to call. I would enter the internal fraction as 24.1 instead of a 23.6 (using 1/5 second for every length gained / lost). Since I'm doing it consistently for every fraction of every runner, doesn't it become relative?

I realize that EXCEL is not recognizing that I am using 1/5 seconds and therefore returning averages with decimals higher than (.4). But to me, a 23.6 is the same as a 24.1. Am I still incorrect here.

BTW...I appreciate this conversation

If you manually calculate the 23 2/5 and recognize the 4 lengths behind as 24.1, that should work. However, if you enter 23.6 it will calculate your average incorrectly.

[coachv30]

Originally Posted by iwearpurple

If you manually calculate the 23 2/5 and recognize the 4 lengths behind as 24.1, that should work. However, if you enter 23.6 it will calculate your average incorrectly.

No...I convert it in my head to 24.1 and then enter it.

[coachv30]

CTOWN 5

This is a 4.5 furlong race. I only used two calls here. Therefore, the last 1/16th is not accounted for. anyways....

$5 WIN 7

$1 EX- 5,7 / ALL

$1 TRI- 5,7 / 1,4,5,7 / ALL

[iwearpurple]

Originally Posted by coachv30

No...I convert it in my head to 24.1 and then enter it.

That's what I meant, I worded it incorrectly. You are correct.

[coachv30]

EVANGELINE 6

$10 W/P- 8
$5 P/S-9

$1 EX- 8,9 / 4,8,9,10,11

$1 TRI- 8,10 / 4,8,9,10 / 4,8,9,10,11

[coachv30]

EVANGELINE 7

$$10 WP 8

$1 EX BOX- 8,10 / 1,7,8,9,10

$1 TRI- 7,8 / 1,7,8,10 / 1,7,8,9,10

[coachv30]

No charts available right now...

Gulfstream 5

Best overall average- 7
Best average final fraction- 2
Best final fraction last out- 2,4,5
Best final fraction out of the 3 races-6
Best race average- 7
Best average early fraction-7

Consesus- 7-2-4-6

Gulfstream 6

Best overall average-8
Best average final fraction- 3
Best final fraction last out- 3
Best final fraction in the 3 races- 3
Best race average- 7
Best average early fraction- 7

Consensus- 3-8-7

[coachv30]

Originally Posted by coachv30

No charts available right now...

Gulfstream 5

Best overall average- 7
Best average final fraction- 2
Best final fraction last out- 2,4,5
Best final fraction out of the 3 races-6
Best race average- 7
Best average early fraction-7

Consesus- 7-2-4-6

Gulfstream 6

Best overall average-8
Best average final fraction- 3
Best final fraction last out- 3
Best final fraction in the 3 races- 3
Best race average- 7
Best average early fraction- 7

Consensus- 3-8-7

RACE 5

Finished

$1.00 Payoffs

$17.20
$77.90
$379.50
$1387.30

RACE 6

[Andrick]

Originally Posted by coachv30

Has anyone played around with averaging out internal fractions? I was thinking about experimenting with what I will call vertical and horizontal averages.

I am going to record the IFs from the 3 most recent races at todays distance. For 6 furlongs, i will use 1st Q, 1st Q to 2nd q, and 2nd Q to finish. My excel program will average out all the calls to get an average fraction- horizontal analysis. It will also average out each call point of the 3 races to get an E, M, and L average- vertical analysis.

I will also have an overall average for all fractions recorded from the 3 races. How I will use this info is still to be determined.

Any thoughts?

I've tried something very similar in the past and it can work well, although the danger is that your treating all the horses the same regardless of what stage in their careers they're at. I found more success by weighing it towards recency when it comes to young horses who are still developing and also for older horses who have seen better days.

[coachv30]

I am only going back within this year to use races. If there are too many horses without 3 at or near the distance in the past year, then I am skipping the race.

I'm anxious to see how this does at Mahoning Valley where a lot of the races are 6f and 1 mile.