[AusRace] Excel problem - help requested

[Race Stats]

Hi Tony glad you got it sorted, but for some odd reason I never received your original email, only your reply!
I'm sure I've missed quite a few emails, I think there is a bug in the list somewhere as I replied to the conversation about times and never got any notification or further conversations.
It all started when the emails started coming through as Digest rather than individually.
Lindsay.

From: Racing [mailto:racing-bounces at ausrace.com] On Behalf Of Tony Moffat
Sent: Wednesday, 18 July 2018 3:52 PM
To: racing at ausrace.com
Subject: [AusRace] Excel problem - help requested


Sorted - thanks



I used =SUMPRODUCT((A1>A$1:A$24)/COUNTIF(A$1:A$24,A$1:A$24))+1

This sorts out as least to large, to reverse that change > to <



This allows you to view all the ranked numbers, as in 1, 222, 33, 4444,5



Cheers



Tony





Re-send









From: Tony Moffat [mailto:tonymoffat at bigpond.com<http://ausrace.com/mailman/listinfo/racing_ausrace.com>]

Sent: Thursday, July 12, 2018 8:29 PM

To: 'AusRace Racing Discussion List' <racing at ausrace.com<http://ausrace.com/mailman/listinfo/racing_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


________________________________
[AVG logo]<https://www.avg.com/internet-security>


This email has been checked for viruses by AVG antivirus software.
www.avg.com<https://www.avg.com/internet-security>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ausrace.com/pipermail/racing_ausrace.com/attachments/20180718/75a64521/attachment.html>