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...
Bully Wee Villa Posted January 30, 2018 Share Posted January 30, 2018 Just re-read previous post and saw that you only want to add on the .3 type scores if someone has submitted all five scores, and not for those who submitted less than five? If so... =(IF(COUNT(B2:F2)<5,(SUM(B2:F2)),((SUM(B2:F2)-(MIN(B2:F2))))+((MIN(B2:F2)/10))) You can never have too many brackets. 0 Quote Link to comment Share on other sites More sharing options...
SlipperyP Posted January 30, 2018 Share Posted January 30, 2018 Can I call horseshite here?If you cant take 2 minutes put of one day to take the quiz. f**k yi. Zero points. 0 Quote Link to comment Share on other sites More sharing options...
BigBo10 Posted January 30, 2018 Share Posted January 30, 2018 Monday link and Tuesday link still the same so bollocks to Monday. 0 Quote Link to comment Share on other sites More sharing options...
Cardinal Richelieu Posted January 30, 2018 Author Share Posted January 30, 2018 2 hours ago, SlipperyP said: Can I call horseshite here? If you cant take 2 minutes put of one day to take the quiz. f**k yi. Zero points. Happy to take counsel from others. It would be a shame for such a cracking formula to go to waste though. Sorry BigBo btw. I've let you down 0 Quote Link to comment Share on other sites More sharing options...
welshbairn Posted January 30, 2018 Share Posted January 30, 2018 (edited) 1 hour ago, BigBo10 said: Monday link and Tuesday link still the same so bollocks to Monday. Did you try the Cardinal's link? Works for me. https://www.theaustralian.com.au/news/mind-games/quiz?quizId=8683 Edited January 30, 2018 by welshbairn 0 Quote Link to comment Share on other sites More sharing options...
welshbairn Posted January 30, 2018 Share Posted January 30, 2018 Here's Wednesday . Got a dull 4/10. 0 Quote Link to comment Share on other sites More sharing options...
welshbairn Posted January 30, 2018 Share Posted January 30, 2018 By the way I think I've cracked the URL code. This season https://www.theaustralian.com.au/news/mind-games/quiz?quizId=8683 Mondayhttps://www.theaustralian.com.au/news/mind-games/quiz?quizId=8693 Tuesdayhttps://www.theaustralian.com.au/news/mind-games/quiz?quizId=8703 Wednesdayhttps://www.theaustralian.com.au/news/mind-games/quiz?quizId=8713 Thursdayhttps://www.theaustralian.com.au/news/mind-games/quiz?quizId=8723 Friday Next season https://www.theaustralian.com.au/news/mind-games/quiz?quizId=8733 Mondayhttps://www.theaustralian.com.au/news/mind-games/quiz?quizId=8743 Tuesdayhttps://www.theaustralian.com.au/news/mind-games/quiz?quizId=8753 Wednesdayhttps://www.theaustralian.com.au/news/mind-games/quiz?quizId=8763 Thursday https://www.theaustralian.com.au/news/mind-games/quiz?quizId=8773 Friday 7 Quote Link to comment Share on other sites More sharing options...
The Captain Posted January 30, 2018 Share Posted January 30, 2018 Despite my best endeavours the lads triumphed in a tough away fixture. Bound to be a reaction given the amount of beer consumption for a Monday. Awful 3 for Tuesday and a deeply average 5 for Wednesday. 1 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.