|
Apr 2022
11:03am, 11 Apr 2022
36,617 posts
|
SPR
You probably want a sortable table that shows number of completed races, score for completed races (max 5 and maybe include penalty where guaranteed), score counted as 5 races, and average per race (max 5 and maybe include penalty where guaranteed).
The person with the best average across the races will win so it gives people a chance to see where they lie. Totals allow people to see what they need to beat. The total over 4 is fairly meaningless.
|
|
Apr 2022
1:54pm, 11 Apr 2022
20,501 posts
|
flanker
I'd take the approach of showing the total score across all events.
Use up to the best 5 scores per runner, applying the 500 for any event missed to make the count of scores per runner the lesser of 5 or the number of completed events.
That way every competitor will know where they stand at that point in time: if you after 3 events you win all 3 you'll have a score of three, and if you only attend one of those you'll have 1000 + your position score for the one you attended.
|
|
Apr 2022
2:10pm, 11 Apr 2022
36,620 posts
|
SPR
I guess the issue is how do you ensure people can compete with others using the league table, hence my suggestion of multiple columns rather than just one total based on a specific criteria.
|
|
Apr 2022
2:13pm, 11 Apr 2022
17,640 posts
|
larkim
Clearly no ideal way to do it! It's simple enough once you've got your head around it whichever way is applied, but it does make the table pretty dynamic when the final race outcomes are published with some big losers and some big winners.
|
|
Apr 2022
2:20pm, 11 Apr 2022
36,621 posts
|
SPR
The average per race will let people know who they may be competing with. With the fact people can miss races, the league table doesn't really exist in until the end.
I'm sure my XC league does a based on 3 race and possibly 2 race version for individuals so people can see where things stand. Can't remember the criteria for individual XC winner as not something I anywhere close to.
|
|
Apr 2022
2:20pm, 11 Apr 2022
36,622 posts
|
SPR
XC league has 4 races.
|
|
Apr 2022
2:21pm, 11 Apr 2022
20,502 posts
|
flanker
I get where you're coming from, but not sure it's worth the effort.
99% of people won't be prepared to work out the scenarios of who might turns up at the remaining races, which scores/penalties might be dropped as a consequence, and therefore how many places they need to beat them by (which is almost possible to plan anyway, as it depends on the unknown variables of the runners who'd need to be in between you). I think most people would be happy with "jim and bob have the next two highest scores, I need to try and beat them both"
I guess knowing the number of scoring races per runner might be useful, as then you'd know who might be likely to replace a penalty with a score and make a big jump. Maybe I'm one of the 1%!
You can slice it so many way. Maybe a table showing the current scores, and access to a spreadsheet with the result data so someone who wants to can play with it themselves.
|
|
Apr 2022
2:26pm, 11 Apr 2022
3,198 posts
|
JCB
I’d probably have a column for ‘Best 5 scores’ as well as ‘Total score’ so that they can both be used. Along with columns for the individual race scores.
|
|
Apr 2022
3:05pm, 28 Apr 2022
9,070 posts
|
GordonG
Hi all
bit of a basic question (hopefully!).
on a large spreadsheet, where one column has been filtered, what's the quickest way of seeing which column has been filtered? I know that the filtered column will have the little filter icon on it, and I know there is a button to remove all filters. But on a very (very) large spreadsheet, if i want to see which column has been filtered would the only way to find the filtered column be to scroll across the page until I see the symbol? Or is there a shortcut/obvious clue I'm missing?
ta
|
|
Apr 2022
3:06pm, 28 Apr 2022
134,973 posts
|
GregP
Oh what a good question. I shall await the hive wisdom with interest.
|
Excel skills test
Mar 2019