Cardinal Richelieu Posted January 30, 2018 Author Share Posted January 30, 2018 13 hours ago, BigBo10 said: Monday and Tuesday links both take me to the same quiz. Anyone got the Monday link? https://www.theaustralian.com.au/news/mind-games/quiz?quizId=8683 If you finish the quiz, you get to take the quiz from another day. Bit of a PITA, but I fear @Bully Wee Villa's idea would be a nightmare to administer. 4 for today. Which normally I'd be a bit miffed at, but I didn't know any of them, so by rights I should only have got 2.5. 0 Quote Link to comment Share on other sites More sharing options...
NJ2 Posted January 30, 2018 Share Posted January 30, 2018 A fair 5 for Tuesday. Knew 2, confident on one other. Guesswork for the rest. First season back with the big boys isn’t going well [emoji17]. Link for anyone else that has bother with it using the app... https://www.theaustralian.com.au/news/mind-games/quiz 0 Quote Link to comment Share on other sites More sharing options...
Leeds Saint Posted January 30, 2018 Share Posted January 30, 2018 4 for Tuesday, and lucky to get that. 0 Quote Link to comment Share on other sites More sharing options...
Bully Wee Villa Posted January 30, 2018 Share Posted January 30, 2018 [mention=31670]Bully Wee Villa[/mention]'s idea would be a nightmare to administer. Bored at work so worked this out... Where B2 to F2 are a player's scores from Monday to Friday, formula required is... =IF(COUNT(B2:F2)<5,SUM(B2:F2),(SUM(B2:F2)-(MIN(B2:F2)))) 3 Quote Link to comment Share on other sites More sharing options...
Bully Wee Villa Posted January 30, 2018 Share Posted January 30, 2018 Not sure why the whole thing doesn't show on the app... 0 Quote Link to comment Share on other sites More sharing options...
Cardinal Richelieu Posted January 30, 2018 Author Share Posted January 30, 2018 28 minutes ago, Bully Wee Villa said: Bored at work so worked this out... Where B2 to F2 are a player's scores from Monday to Friday, formula required is... =IF(COUNT(B2:F2)<5,SUM(B2:F2),(SUM(B2:F2)-(MIN(B2:F2)))) Heh. Can't believe it works (that's not a slight on you btw) ... What does anyone else feel about this? 0 Quote Link to comment Share on other sites More sharing options...
welshbairn Posted January 30, 2018 Share Posted January 30, 2018 11 minutes ago, Cardinal Richelieu said: Heh. Can't believe it works (that's not a slight on you btw) ... What does anyone else feel about this? Why not, if it works? 0 Quote Link to comment Share on other sites More sharing options...
NJ2 Posted January 30, 2018 Share Posted January 30, 2018 If you miss a day, “nae points p***k!”Unless I miss a day then it’s best out of 4. I’m not worried either way. 0 Quote Link to comment Share on other sites More sharing options...
welshbairn Posted January 30, 2018 Share Posted January 30, 2018 2 minutes ago, NJ2 said: If you miss a day, “nae points p***k!” Unless I miss a day then it’s best out of 4. I’m not worried either way. I like the idea of dropping your worst score if you do the 5. 0 Quote Link to comment Share on other sites More sharing options...
NJ2 Posted January 30, 2018 Share Posted January 30, 2018 I like the idea of dropping your worst score if you do the 5. Drop your worst score but you get a bonus point if you do all 5?I’m just trying to make this difficult now [emoji3] 0 Quote Link to comment Share on other sites More sharing options...
Cardinal Richelieu Posted January 30, 2018 Author Share Posted January 30, 2018 The only slight issue would be that there would be more ties if we're only doing a 4 day week. But wait... the 5th score could be used as a tie-breaker (a bit like they do in the Quest quizzing 'hing) ... so if you got 7,6,5,4,3 for the week, your score would be 22.3 ... if you missed a day, your score would be 22.0. @Bully Wee Villa ... any idea how the f**k you'd do that in Excel / Google Shits? 0 Quote Link to comment Share on other sites More sharing options...
Bully Wee Villa Posted January 30, 2018 Share Posted January 30, 2018 So you basically want it to add on one-tenth of your best score of the week? =(IF(COUNT(B2:F2)<5,SUM(B2:F2),(SUM(B2:F2)-(MIN(B2:F2)))))+((MAX(B2:F2))/10) Only problem is it adds a whole "1" if someone gets a 10/10. 0 Quote Link to comment Share on other sites More sharing options...
Cardinal Richelieu Posted January 30, 2018 Author Share Posted January 30, 2018 4 minutes ago, Bully Wee Villa said: So you basically want it to add on one-tenth of your best score of the week? =(IF(COUNT(B2:F2)<5,SUM(B2:F2),(SUM(B2:F2)-(MIN(B2:F2)))))+((MAX(B2:F2))/10) Only problem is it adds a whole "1" if someone gets a 10/10. No, I'd like to add one-tenth of the worst score for the week please Statto! 0 Quote Link to comment Share on other sites More sharing options...
welshbairn Posted January 30, 2018 Share Posted January 30, 2018 =(IF(COUNT(B2:F2)<5,SUM(B2:F2),(SUM(B2:F2)-(MIN(B2:F2)))))+((MIN(B2:F2))/10) ? 0 Quote Link to comment Share on other sites More sharing options...
Bully Wee Villa Posted January 30, 2018 Share Posted January 30, 2018 (edited) Oh, in that case just change the last MAX to a MIN! Edit: as Welshbairn said. Edited January 30, 2018 by Bully Wee Villa 0 Quote Link to comment Share on other sites More sharing options...
Cardinal Richelieu Posted January 30, 2018 Author Share Posted January 30, 2018 Cheers lads. I don't feel like I should be using my brain on a day off. Okay, we'll give it a shot this week. League tables will follow tomorrow. 0 Quote Link to comment Share on other sites More sharing options...
welshbairn Posted January 30, 2018 Share Posted January 30, 2018 9 minutes ago, Bully Wee Villa said: Oh, in that case just change the last MAX to a MIN! Edit: as Welshbairn said. Fucking genius me. Mainly I like all the pretty brackets. 1 Quote Link to comment Share on other sites More sharing options...
Bully Wee Villa Posted January 30, 2018 Share Posted January 30, 2018 There's probably a few superfluous brackets there... but it seems to work! 0 Quote Link to comment Share on other sites More sharing options...
Audaces Fortuna Juvat Posted January 30, 2018 Share Posted January 30, 2018 Knew four and scored four for Tuesday. Last night's winning European excursion has had a deleterious effect on the boys, 1 Quote Link to comment Share on other sites More sharing options...
dee_62 Posted January 30, 2018 Share Posted January 30, 2018 knew 2 and scored another average 5/10 for Tuesday. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.