TargetTalk

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

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

Thank you, that's great, sadly I may have to get my A-Level Maths daughter to explain how it's working :)

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.

Thanks, much appreciated

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".

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.