calculating tied scores accounting for Inner 10s

If you wish to make a donation to this forum's operation , it would be greatly appreciated.
https://www.paypal.com/paypalme/targettalk?yours=true

Moderators: pilkguns, m1963, David Levene, Spencer, Richard H

Forum rules
If you wish to make a donation to this forum's operation , it would be greatly appreciated.
https://www.paypal.com/paypalme/targettalk?yours=true
Post Reply
martynB
Posts: 9
Joined: Thu Jan 11, 2018 7:33 am

calculating tied scores accounting for Inner 10s

Post by martynB »

I'm working on score recording solution for a postal competition that is currently based on a spreadsheet, I will move this to a proper application when I have time but in the meantime, I need to work out how to calculate ranking on the combination of shots scored and Inner 10 count to separate ties.

I can do this easily with code in an application but in the short term, I need to get this working.

Does anyone have an example spreadsheet where the have this working that they could share, please?

Thanks in advance

Martyn
David Levene
Posts: 5617
Joined: Mon Mar 01, 2004 12:49 pm
Location: Ruislip, UK

Re: calculating tied scores accounting for Inner 10s

Post by David Levene »

The attached file ranks athletes by:-

Total
Inner tens
Shots 51-60
Shots 41-50
Shots 31-40
Shots 21-30
Shots 11-20
Shots 1-10

It then gives the rank in column M.

Hope this helps
Attachments
AutoRank.xls
(41.5 KiB) Downloaded 209 times
martynB
Posts: 9
Joined: Thu Jan 11, 2018 7:33 am

Re: calculating tied scores accounting for Inner 10s

Post by martynB »

Thank you, that's great, sadly I may have to get my A-Level Maths daughter to explain how it's working :)
David Levene
Posts: 5617
Joined: Mon Mar 01, 2004 12:49 pm
Location: Ruislip, UK

Re: calculating tied scores accounting for Inner 10s

Post by David Levene »

You might also like this attached file.

It also adds second name and initial ti the ranking list, allowing you to just sort on column L.

This allow you to sort an initial list in alphabetical order and then enter the scores as they come in. Names with scores will be ranked as before but those without scores will be listed alphabetically at the bottom.
Attachments
AutoRankandName.xls
(42.5 KiB) Downloaded 74 times
martynB
Posts: 9
Joined: Thu Jan 11, 2018 7:33 am

Re: calculating tied scores accounting for Inner 10s

Post by martynB »

Thanks, much appreciated
David Levene
Posts: 5617
Joined: Mon Mar 01, 2004 12:49 pm
Location: Ruislip, UK

Re: calculating tied scores accounting for Inner 10s

Post by David Levene »

Just another tip, when you enter the number of inner tens, just put in the number. The spreadsheet is formatted to put in the "X".
spektr
Posts: 887
Joined: Mon Jan 21, 2013 9:53 pm

Re: calculating tied scores accounting for Inner 10s

Post by spektr »

I know inner tens is the gold standard but I really wish the score was decided by running the scores in reverse order. lowest scored shot loses a tiebreak.
Post Reply