Waltons ThreadLord
Well if I had to make a suggestion, it would be to pare down the list to only people who actually post here. Seems like it would save you some time, and maybe be more interesting for the regulars. Damaris with her mod powers (and I think Baboon too) can tell us the last time any user actually visited the forum.
The number of players doesn't impact the time it takes me - I copy and paste a report of all runners into Excel and let lookup functions do the rest. What would help more would be to prune the membership list of this User Group. There are over 700 members and I wager half haven't checked in here for more than a year.
5k 23:48.45 (3/22); 4M 31:26 (2/22); 5M 38:55 (11/23); 10k 49:24 (10/22); 10M 1:29:33 (2/24); Half 1:48:32 (10/22); Marathon 4:29:58 (11/23)Upcoming races: Running is Back 10k, 5/12; Greta's Run 5k, 5/19
delicate flower
Do you know whether the date you're seeing is when they were actually in B&B, or just on RA (e.g. to log)?
That I do not know. The column header just reads "Access Time."
<3
Former Bad Ass
It's when they last accessed the group. I think Eric told me this years ago.
Damaris
Would a private group work, similar to how teams set ones up in the other game?
Yes, but is it worth it and would that make it harder for other people to discover the game and join in? We're talking about once/week I have to hold my mouse button down for 2 minutes while the screen scrolls to select a list of 922 people so I can copy it to paste into Excel. If someone knows a quicker way to select the list without selecting the whole screen, please let me know. It's mostly an annoyance factor since over 600 come up as "NA" for miles run (and every so often my finger slips and I have to start scrolling again) so I know I'm spending a lot of time on a list full of people who are long gone. (And another 258 are 0:00 time, though sometimes that's people in the game with a zero week.)
I'd think that'd work perfectly - Fred (or anyone) creates that group, post the name of it here, everyone who wants to be in the game join that group, and Fred use that user list for generating the results. Although that's just one more thing to do, and IDK whether people care enough.
Dave
Well, with the current system, we can include anyone we like, without asking them....
But sure, a separate group would speed things up at the risk of excluding people who don't check in often enough to notice the switch.
LOL, I should want to keep some of them in, they're all that's keeping me out of last place.
Week 23 - wcrunner2 making some room, Wolvmar and BerthaSlayer neck and neck. A tie between Onemile and sdWhiskers. HCK and Fredford tied on miles, but consistency putting HCK in front.
HCK’s std dev is pretty impressive, this deep into the year.
UM 45 Ohio 23
I'm sinking like a rock with no end in sight
Yes, indeed it is.
If I ever take a rest week, I'll spread it across two game weeks. A zero week can really torpedo the StdDev score.
Week 24. Some changes in the mid-pack standings.
To comments about HCK's consistency: 16 of 24 weeks have had between 27.1 and 28.6 miles - that's 2/3 of the time within a 1½ mile range, and that's how you get the 100 points for most consistent runner.
Week 25 - We're about half way through the year and I'm recalling the discussion about using history vs. a minimum goal. I'm beginning to wonder whether history might have been the right way to go after all (and some people said that back in January). Had we used the history formula for Dan, he'd have 209 points, which at week 25 means being a bit behind the 3-year average. To paraphrase Bill Parcells, you are what your record says you are. If someone has a breakout year, or a bounce back year, they'll do well in this game in the short run, but in the long run the game will catch up. Just some Monday morning ruminations on a humid, cloudy day when rain is threatening.
It would definitely account for any bad years or great years. Thanks!