[AusRace] Excel problem - help requested

[Tony Moffat]

Re-send

 

From: Tony Moffat [mailto:tonymoffat at bigpond.com] 
Sent: Thursday, July 12, 2018 8:29 PM
To: 'AusRace Racing Discussion List' <racing at ausrace.com>
Subject: Excel problem - help requested

 

1533657143 -this is the ten run past form for Havasay (horse 6) in the
Ramornie recently. Those numbers represent the horses performance in
the class of race leading up to this run so may not accurately reflect
its performance in real time - the runs are ranked against other
runners in this race. This is a horizontal component

 

744723477272776777777777 is the comparison for all runners on their
lead up race before the Ramornie - this is a vertical component.
Havasay is the 6th horse in (the 3 here).

 

The problem occurring more often now is that the vertical component is
not ranking runners as 1 (1st here) - essentially the runner above
Havasay should be ranked 1 - it shows a two.

 

I am using the following to obtain the vertical component
=SUMPRODUCT((U65>$L$60:$L$83)/COUNTIF($L$60:$L$83,$L$60:$L$83))+1.

 

Could a excel savvy user review this and advise how to ensure the
vertical rankings appear as they should, 1 out to 9 most often,
although the poor form horses and the non-runners are shown as 7 in
this example.

 

It does apply the correct ranking most times, except if there is no
1st in the list it does not apply a first (a 1) to a runner.

 

The array is 10 columns wide and 24 rows deep.

 

Cheers

 

Tony

 

 

 



---
This email has been checked for viruses by AVG.
https://www.avg.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ausrace.com/pipermail/racing_ausrace.com/attachments/20180712/e03dda33/attachment.html>