[AusRace] Racing Digest, Vol 19, Issue 2

Wed Jul 18 20:41:00 AEST 2018

Same here Lindsay. This is the first post I've seen since I made an enquiry
about par times a month or so ago.

[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
Sender
notified by
Mailtrack
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
18/07/18,
20:40:19

On Wed, Jul 18, 2018 at 8:29 PM <racing-request at ausrace.com> wrote:

> Send Racing mailing list submissions to
>         racing at ausrace.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://ausrace.com/mailman/listinfo/racing_ausrace.com
> or, via email, send a message with subject or body 'help' to
>         racing-request at ausrace.com
>
> You can reach the person managing the list at
>         racing-owner at ausrace.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Racing digest..."
>
>
> Today's Topics:
>
>    1. Excel problem - help requested (Tony Moffat)
>    2. Re: Excel problem - help requested (Race Stats)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 18 Jul 2018 13:51:58 +0800
> From: "Tony Moffat" <tonymoffat at bigpond.com>
> To: <racing at ausrace.com>
> Subject: [AusRace] Excel problem - help requested
> Message-ID: <000001d41e5b$71aff080$550fd180$@bigpond.com>
> Content-Type: text/plain; charset="us-ascii"
>
> 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
>
>
>
>
>
> ---
> 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/20180718/33f5034c/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Wed, 18 Jul 2018 10:28:48 +0000
> From: Race Stats <RaceStats at hotmail.com>
> To: AusRace Racing Discussion List <racing at ausrace.com>
> Subject: Re: [AusRace] Excel problem - help requested
> Message-ID:
>         <
> MEAPR01MB32051434B6A5484C8BBE2488BB530 at MEAPR01MB3205.ausprd01.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="us-ascii"
>
> 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
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Racing mailing list
> Racing at ausrace.com
> http://ausrace.com/mailman/listinfo/racing_ausrace.com
>
>
> ------------------------------
>
> End of Racing Digest, Vol 19, Issue 2
> *************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ausrace.com/pipermail/racing_ausrace.com/attachments/20180718/933b2250/attachment.html>