<div dir="ltr"><img width="0" height="0" class="mailtrack-img" alt="" style="display:flex" src="https://mailtrack.io/trace/mail/edcad1c8e9db3a9a4c49ca006df6d56cc2007009.png?u=1035275"><div></div>Same here Lindsay. This is the first post I've seen since I made an enquiry about par times a month or so ago. <br><br><br><div class="mt-signature">
<table border="0" cellpadding="8" cellspacing="0" style="user-select: none;">
<tbody><tr>
<td>
<a href="https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&" class="" style="text-decoration:none">
<img src="https://s3.amazonaws.com/mailtrack-signature/sender_notified.gif" alt="Mailtrack" class="" width="32" height="32">
</a>
</td>
<td>
<span style="color:#777">Sender notified by</span> <br>
<a href="https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&" class="mt-install" style="color:#4374f7">Mailtrack</a>
<span style="color:transparent;font-size:0">18/07/18, 20:40:19</span>
</td>
<td>
</td>
</tr>
</tbody></table>
</div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Jul 18, 2018 at 8:29 PM <<a href="mailto:racing-request@ausrace.com">racing-request@ausrace.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Racing mailing list submissions to<br>
<a href="mailto:racing@ausrace.com" target="_blank">racing@ausrace.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://ausrace.com/mailman/listinfo/racing_ausrace.com" rel="noreferrer" target="_blank">http://ausrace.com/mailman/listinfo/racing_ausrace.com</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:racing-request@ausrace.com" target="_blank">racing-request@ausrace.com</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:racing-owner@ausrace.com" target="_blank">racing-owner@ausrace.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Racing digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Excel problem - help requested (Tony Moffat)<br>
2. Re: Excel problem - help requested (Race Stats)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 18 Jul 2018 13:51:58 +0800<br>
From: "Tony Moffat" <<a href="mailto:tonymoffat@bigpond.com" target="_blank">tonymoffat@bigpond.com</a>><br>
To: <<a href="mailto:racing@ausrace.com" target="_blank">racing@ausrace.com</a>><br>
Subject: [AusRace] Excel problem - help requested<br>
Message-ID: <000001d41e5b$71aff080$550fd180$@<a href="http://bigpond.com" rel="noreferrer" target="_blank">bigpond.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
Sorted - thanks<br>
<br>
I used =SUMPRODUCT((A1>A$1:A$24)/COUNTIF(A$1:A$24,A$1:A$24))+1<br>
This sorts out as least to large, to reverse that change > to <<br>
<br>
This allows you to view all the ranked numbers, as in 1, 222, 33,<br>
4444,5<br>
<br>
Cheers<br>
<br>
Tony<br>
<br>
<br>
Re-send<br>
<br>
<br>
<br>
<br>
From: Tony Moffat [mailto:<a href="mailto:tonymoffat" target="_blank">tonymoffat</a> at <a href="http://bigpond.com" rel="noreferrer" target="_blank">bigpond.com</a><br>
<<a href="http://ausrace.com/mailman/listinfo/racing_ausrace.com" rel="noreferrer" target="_blank">http://ausrace.com/mailman/listinfo/racing_ausrace.com</a>> ] <br>
Sent: Thursday, July 12, 2018 8:29 PM<br>
To: 'AusRace Racing Discussion List' <racing at <a href="http://ausrace.com" rel="noreferrer" target="_blank">ausrace.com</a><br>
<<a href="http://ausrace.com/mailman/listinfo/racing_ausrace.com" rel="noreferrer" target="_blank">http://ausrace.com/mailman/listinfo/racing_ausrace.com</a>> ><br>
Subject: Excel problem - help requested<br>
<br>
<br>
<br>
1533657143 -this is the ten run past form for Havasay (horse 6) in the<br>
Ramornie recently. Those numbers represent the horses performance in<br>
the class of race leading up to this run so may not accurately reflect<br>
its performance in real time - the runs are ranked against other<br>
runners in this race. This is a horizontal component<br>
<br>
<br>
<br>
744723477272776777777777 is the comparison for all runners on their<br>
lead up race before the Ramornie - this is a vertical component.<br>
Havasay is the 6th horse in (the 3 here).<br>
<br>
<br>
<br>
The problem occurring more often now is that the vertical component is<br>
not ranking runners as 1 (1st here) - essentially the runner above<br>
Havasay should be ranked 1 - it shows a two.<br>
<br>
<br>
<br>
I am using the following to obtain the vertical component<br>
=SUMPRODUCT((U65>$L$60:$L$83)/COUNTIF($L$60:$L$83,$L$60:$L$83))+1.<br>
<br>
<br>
<br>
Could a excel savvy user review this and advise how to ensure the<br>
vertical rankings appear as they should, 1 out to 9 most often,<br>
although the poor form horses and the non-runners are shown as 7 in<br>
this example.<br>
<br>
<br>
<br>
It does apply the correct ranking most times, except if there is no<br>
1st in the list it does not apply a first (a 1) to a runner.<br>
<br>
<br>
<br>
The array is 10 columns wide and 24 rows deep.<br>
<br>
<br>
<br>
Cheers<br>
<br>
<br>
<br>
Tony<br>
<br>
<br>
<br>
<br>
<br>
---<br>
This email has been checked for viruses by AVG.<br>
<a href="https://www.avg.com" rel="noreferrer" target="_blank">https://www.avg.com</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://ausrace.com/pipermail/racing_ausrace.com/attachments/20180718/33f5034c/attachment-0001.html" rel="noreferrer" target="_blank">http://ausrace.com/pipermail/racing_ausrace.com/attachments/20180718/33f5034c/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 18 Jul 2018 10:28:48 +0000<br>
From: Race Stats <<a href="mailto:RaceStats@hotmail.com" target="_blank">RaceStats@hotmail.com</a>><br>
To: AusRace Racing Discussion List <<a href="mailto:racing@ausrace.com" target="_blank">racing@ausrace.com</a>><br>
Subject: Re: [AusRace] Excel problem - help requested<br>
Message-ID:<br>
<<a href="mailto:MEAPR01MB32051434B6A5484C8BBE2488BB530@MEAPR01MB3205.ausprd01.prod.outlook.com" target="_blank">MEAPR01MB32051434B6A5484C8BBE2488BB530@MEAPR01MB3205.ausprd01.prod.outlook.com</a>><br>
<br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
Hi Tony glad you got it sorted, but for some odd reason I never received your original email, only your reply!<br>
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.<br>
It all started when the emails started coming through as Digest rather than individually.<br>
Lindsay.<br>
<br>
From: Racing [mailto:<a href="mailto:racing-bounces@ausrace.com" target="_blank">racing-bounces@ausrace.com</a>] On Behalf Of Tony Moffat<br>
Sent: Wednesday, 18 July 2018 3:52 PM<br>
To: <a href="mailto:racing@ausrace.com" target="_blank">racing@ausrace.com</a><br>
Subject: [AusRace] Excel problem - help requested<br>
<br>
<br>
Sorted - thanks<br>
<br>
<br>
<br>
I used =SUMPRODUCT((A1>A$1:A$24)/COUNTIF(A$1:A$24,A$1:A$24))+1<br>
<br>
This sorts out as least to large, to reverse that change > to <<br>
<br>
<br>
<br>
This allows you to view all the ranked numbers, as in 1, 222, 33, 4444,5<br>
<br>
<br>
<br>
Cheers<br>
<br>
<br>
<br>
Tony<br>
<br>
<br>
<br>
<br>
<br>
Re-send<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
From: Tony Moffat [mailto:<a href="mailto:tonymoffat" target="_blank">tonymoffat</a> at <a href="http://bigpond.com" rel="noreferrer" target="_blank">bigpond.com</a><<a href="http://ausrace.com/mailman/listinfo/racing_ausrace.com" rel="noreferrer" target="_blank">http://ausrace.com/mailman/listinfo/racing_ausrace.com</a>>]<br>
<br>
Sent: Thursday, July 12, 2018 8:29 PM<br>
<br>
To: 'AusRace Racing Discussion List' <racing at <a href="http://ausrace.com" rel="noreferrer" target="_blank">ausrace.com</a><<a href="http://ausrace.com/mailman/listinfo/racing_ausrace.com" rel="noreferrer" target="_blank">http://ausrace.com/mailman/listinfo/racing_ausrace.com</a>>><br>
<br>
Subject: Excel problem - help requested<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
1533657143 -this is the ten run past form for Havasay (horse 6) in the<br>
<br>
Ramornie recently. Those numbers represent the horses performance in<br>
<br>
the class of race leading up to this run so may not accurately reflect<br>
<br>
its performance in real time - the runs are ranked against other<br>
<br>
runners in this race. This is a horizontal component<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
744723477272776777777777 is the comparison for all runners on their<br>
<br>
lead up race before the Ramornie - this is a vertical component.<br>
<br>
Havasay is the 6th horse in (the 3 here).<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
The problem occurring more often now is that the vertical component is<br>
<br>
not ranking runners as 1 (1st here) - essentially the runner above<br>
<br>
Havasay should be ranked 1 - it shows a two.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
I am using the following to obtain the vertical component<br>
<br>
=SUMPRODUCT((U65>$L$60:$L$83)/COUNTIF($L$60:$L$83,$L$60:$L$83))+1.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Could a excel savvy user review this and advise how to ensure the<br>
<br>
vertical rankings appear as they should, 1 out to 9 most often,<br>
<br>
although the poor form horses and the non-runners are shown as 7 in<br>
<br>
this example.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
It does apply the correct ranking most times, except if there is no<br>
<br>
1st in the list it does not apply a first (a 1) to a runner.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
The array is 10 columns wide and 24 rows deep.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Cheers<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Tony<br>
<br>
<br>
________________________________<br>
[AVG logo]<<a href="https://www.avg.com/internet-security" rel="noreferrer" target="_blank">https://www.avg.com/internet-security</a>><br>
<br>
<br>
This email has been checked for viruses by AVG antivirus software.<br>
<a href="http://www.avg.com" rel="noreferrer" target="_blank">www.avg.com</a><<a href="https://www.avg.com/internet-security" rel="noreferrer" target="_blank">https://www.avg.com/internet-security</a>><br>
<br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://ausrace.com/pipermail/racing_ausrace.com/attachments/20180718/75a64521/attachment.html" rel="noreferrer" target="_blank">http://ausrace.com/pipermail/racing_ausrace.com/attachments/20180718/75a64521/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Racing mailing list<br>
<a href="mailto:Racing@ausrace.com" target="_blank">Racing@ausrace.com</a><br>
<a href="http://ausrace.com/mailman/listinfo/racing_ausrace.com" rel="noreferrer" target="_blank">http://ausrace.com/mailman/listinfo/racing_ausrace.com</a><br>
<br>
<br>
------------------------------<br>
<br>
End of Racing Digest, Vol 19, Issue 2<br>
*************************************<br>
</blockquote></div>