Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch
or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 102 watchers
SPR
Apr 2022
11:03am, 11 Apr 2022
36,617 posts
  • Quote
  • Pin
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
  • Quote
  • Pin
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.
SPR
Apr 2022
2:10pm, 11 Apr 2022
36,620 posts
  • Quote
  • Pin
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
  • Quote
  • Pin
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.
SPR
Apr 2022
2:20pm, 11 Apr 2022
36,621 posts
  • Quote
  • Pin
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.
SPR
Apr 2022
2:20pm, 11 Apr 2022
36,622 posts
  • Quote
  • Pin
SPR
XC league has 4 races.
Apr 2022
2:21pm, 11 Apr 2022
20,502 posts
  • Quote
  • Pin
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.
JCB
Apr 2022
2:26pm, 11 Apr 2022
3,198 posts
  • Quote
  • Pin
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
  • Quote
  • Pin
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
  • Quote
  • Pin
GregP
Oh what a good question. I shall await the hive wisdom with interest.

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work

Report This Content

You can report any content you believe to be unsafe. Please let me know why you believe this content is unsafe by choosing a category below.



Thank you for your report. The content will be assessed as soon as possible.










Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,492 Fetchies!
Already a Fetchie? Sign in here