calculating tied scores accounting for Inner 10s

[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]

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

[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]

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.

[martynB]

Thanks, much appreciated

[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]

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.