I'll be going in to the puzzles tomorrow "cold", but this test looks like it has a lot more to offer to more modest solvers - like me! - than previous years' tests do. If you've ever been attracted to the thought of taking part, this year looks like a really good one to try, even if it's your first one. Let Really Smart Guys, a lovely near-live blog written at the 2008 World Puzzle Championship, inspire you! Conversely, if you're frustrated by the annual puzzle championship schedule for national-class solvers apparently being one event long, the monthly-ish Oguz Atay Puzzle Contest is similarly very fine; I enjoyed stinking the place up in its fourth edition.
2. The World Series of Poker is in progress at the moment; in fact, it's about half-way through. Numbers are similar to those from last year; some tournaments are attracting more players than last year, some slightly fewer. My gut feeling is that it bodes well for the main event; while I haven't seen anyone quote an over/under for entrance figures and I'm not sure how the online qualifier numbers compare to last year's, I'd guess at about 7,000 - a little more than last year's 6,844 but below 2006's 8,773. The big story so far is that Phil Ivey has won two tournaments in the first half of the event; Brock Parker won two short-handed ("6-max") tournaments in quick succession and Ville Wahlbeck has impressed by so far taking first, second and third places in three of the five $10,000-buyin events he has so far entered.
3. Many people have observed the phonetic similarity of the name Johnny Marr, who plays guitar (for the Smiths, as it happens), to the French phrase "j'en ai marre", often translated "I'm fed up". However, "j'en ai marre" is just a sentence fragment; you would use it in the context "j'en ai marre de ((quelque chose))", or "I'm fed up with ((something))". There is a lovely bit of British English slang, "mardy", which could be translated as "fed up" in a similar way. (A BBC h2g2 author has more.) Accordingly, it's got me wondering whether the phonetically similar "marre de" and "mardy" might have some sort of linguistic link. Etymology or coincidence? (Or, alternately, perhaps someone doesn't like Tuesdays...)
4. Here is an Excel question. Suppose I have a table like so:
Day Rain Temp Mon 14 8 Tue 19 10 Wed 12 10 Thu 22 13 Fri 11 12and I'm looking to try to find the average Temp on days when there was more than 13 units of Rain. How would you do this? My approach, which doesn't seem to work (in Excel 2000 on a PC), is to create another column at the right-hand end where the cell is empty if there was no more than 13 units of Rain or contains the Temp value if there were more than 13 units of rain, like so:
Day Rain Temp AltTemp Mon 14 8 8 Tue 19 10 10 Wed 12 10 (empty cell) Thu 22 13 13 Fri 11 12 (empty cell)...whereby taking an average of the new right-hand column will give me the answer I need. Furthermore, should the rain value on Tuesday turn out to have been 9 instead of 19, changing the 19 to 9 should change the AltTemp from 10 to (empty cell), and so the average AltTemp should change from being calculated based on three figures to being based on only two.
Trouble is, I can't come up with a function I want to get this. I have tried something like =IF(B2>13,C2,#N/A) or =IF(B2>13,C2,#NULL!) - and so on for the remaining rows - but the average of a series which includes some numbers and some #N/As (or some #NULL!s) is #N/A, where I just want to skip over the cells with the #N/As in when performing the average. Can't help feeling this is going to be a really easy question for someone who knows better than me, but I've been working on this on the night shifts so haven't had anyone to ask and I haven't been able to work it out from the help. Accordingly, is it clear what I want - and, if so, how do I do it, please?
Please redirect any comments here, using OpenID and/or (identified, if you'd be so kind) anonymous posting as necessary. Thank you!