Lemonade Posted December 4, 2016 Author Report Share Posted December 4, 2016 This is how it works: I pick the name from a list, and put in the age, Ys and Ns, and it calculates the points automatically. Then VLOOKUPs assign the points to each user, doubling the points for a joker: Then finally a Pivot Table calculates the leaderboard And yes I use a knock off version of Excel. 1 Quote Link to comment Share on other sites More sharing options...
kirsten Posted December 5, 2016 Report Share Posted December 5, 2016 I've never felt more excited by a spreadsheet. 1 Quote Link to comment Share on other sites More sharing options...
Lemonade Posted December 5, 2016 Author Report Share Posted December 5, 2016 (edited) 45 minutes ago, kirsten said: I've never felt more excited by a spreadsheet. If you took that spreadsheet and made it about ATMs, it's pretty much what I do for a living. Are you jealous? I bet you're jealous. Edited December 5, 2016 by Lemonade Quote Link to comment Share on other sites More sharing options...
MattJimF Posted December 6, 2016 Report Share Posted December 6, 2016 Peter Vaughan has had his Porridge - http://www.bbc.co.uk/news/entertainment-arts-38225796 1 Quote Link to comment Share on other sites More sharing options...
Mr Owl PhD Posted December 8, 2016 Report Share Posted December 8, 2016 Greg 'Late': http://www.bbc.co.uk/news/entertainment-arts-38251936 Quote Link to comment Share on other sites More sharing options...
Mr Owl PhD Posted December 8, 2016 Report Share Posted December 8, 2016 John Glenn returns to the heavens: http://www.bbc.co.uk/news/world-us-canada-38257445 Quote Link to comment Share on other sites More sharing options...
Mr Owl PhD Posted December 10, 2016 Report Share Posted December 10, 2016 AA ill: https://www.theguardian.com/media/2016/dec/10/aa-gill-dies-weeks-after-revealing-he-had-cancer-in-restaurant-review-sunday-times Quote Link to comment Share on other sites More sharing options...
scottyboy Posted December 11, 2016 Report Share Posted December 11, 2016 Sad about that one. Largely because he'd signed on for my 2017 squad. Quote Link to comment Share on other sites More sharing options...
Lemonade Posted December 11, 2016 Author Report Share Posted December 11, 2016 2 of my 2017 squad have died recently. Bustard. Quote Link to comment Share on other sites More sharing options...
Delboy1969 Posted December 11, 2016 Report Share Posted December 11, 2016 Still time for another biggie or two to pop their clogs before the curtain falls on what has been a 'superb' year for celebrity snuffing. Have to be disappointed I only got two so far this year though. Quote Link to comment Share on other sites More sharing options...
Lemonade Posted December 11, 2016 Author Report Share Posted December 11, 2016 (edited) 7 hours ago, Lemonade said: 2 of my 2017 squad have died recently. Bustard. My phone recently deleted all my added words from out if it's dictionary. Bye bye swear words. Edited December 11, 2016 by Lemonade Quote Link to comment Share on other sites More sharing options...
kirsten Posted December 12, 2016 Report Share Posted December 12, 2016 On 12/10/2016 at 10:39 AM, Mr Owl PhD said: AA ill: https://www.theguardian.com/media/2016/dec/10/aa-gill-dies-weeks-after-revealing-he-had-cancer-in-restaurant-review-sunday-times I didn't realise he'd died! I wondered why everybody liked him all of a sudden and were posting articles of his 'best quotes'. Yeugh. Quote Link to comment Share on other sites More sharing options...
Lemonade Posted December 12, 2016 Author Report Share Posted December 12, 2016 The outlook is bleak for Ian McCaskill. https://t.co/pUff6MOCLY Quote Link to comment Share on other sites More sharing options...
Adam Easy Wishes Posted December 14, 2016 Report Share Posted December 14, 2016 Ian McCasket 2 Quote Link to comment Share on other sites More sharing options...
MattJimF Posted December 17, 2016 Report Share Posted December 17, 2016 Henry Heimlich has choked it - http://www.bbc.co.uk/news/world-us-canada-38351903 Quote Link to comment Share on other sites More sharing options...
Lemonade Posted December 18, 2016 Author Report Share Posted December 18, 2016 (edited) Zsashes to ashes. Zsa Zsa Gabor kicks the bucket. Should be some points. Edited December 18, 2016 by Lemonade Quote Link to comment Share on other sites More sharing options...
Mr Owl PhD Posted December 18, 2016 Report Share Posted December 18, 2016 Zsa Zsa no more: http://www.bbc.co.uk/news/entertainment-arts-38360302 Quote Link to comment Share on other sites More sharing options...
Skubbs Posted December 18, 2016 Report Share Posted December 18, 2016 I'm a horrible person, I came here within minutes of finding out... I think she's still on my list, after all this time. Quote Link to comment Share on other sites More sharing options...
Lemonade Posted December 18, 2016 Author Report Share Posted December 18, 2016 27 minutes ago, Scubby said: I'm a horrible person, I came here within minutes of finding out... I think she's still on my list, after all this time. Fucking everybody had her except me. I might be the only person who finishes the year with 0 points Quote Link to comment Share on other sites More sharing options...
kirsten Posted December 19, 2016 Report Share Posted December 19, 2016 Shit! I missed her off my list this year! Quote Link to comment Share on other sites More sharing options...
scottyboy Posted December 20, 2016 Report Share Posted December 20, 2016 I had her on my list 1 year but took her off; partly because it seemed like she'd live forever (like the King of Thailand...) and partly because I'd only heard of her because of this thread. Just glad Bigsby didn't have her either! 1 Quote Link to comment Share on other sites More sharing options...
ca_gere Posted December 20, 2016 Report Share Posted December 20, 2016 I only know her really from the Big Breakfast. She did a stint in the Vanessa Feltz role doing interviews on the bed. Or maybe she was just interviewed on it once. Alan thicke died the other day. Doubt anyone had him. Quote Link to comment Share on other sites More sharing options...
Bigsby Posted December 20, 2016 Report Share Posted December 20, 2016 Dusty Anderson died. http://nemonews.net/2016/10/19/dusty-anderson/ I had Dusty Anderson on my list. Dusty Anderson died of an accident. Quote Link to comment Share on other sites More sharing options...
Bigsby Posted December 20, 2016 Report Share Posted December 20, 2016 7 hours ago, ca_gere said: Alan thicke died the other day. Doubt anyone had him. RIP. Love Blurred Lines. 1 Quote Link to comment Share on other sites More sharing options...
Lemonade Posted December 24, 2016 Author Report Share Posted December 24, 2016 Coffin all over the world. RIP Rick Parfitt. http://news.sky.com/story/status-quo-guitarist-rick-parfitt-dies-in-hospital-in-spain-10707246 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.