Welcome to the Excel Inn

Welcome back to George vs the Listener Crossword.  If this is the first post you’re seeing, you need to see more posts… and my little bit on Pointer’s from last week should be right below this.

Numberword time! First numerical of the year and it is Botox.  The Listener Crossword site tells me that Botox is a hybrid of Artix (who we had not that long ago with a puzzle I didn’t get), and Shark who we last saw under the guise of Handyman last year. Pseudonyms abounding! Neither of them have set a numerical Listener that I know of.

I have no shame, dear readers. I saw the sheer number of numerical clues, that all the numbers 1-26 were used, and that there were several letters in many of the clues, and a few of them had two equations that worked out to the same value, and went straight to Excel to make a spreadsheet.

Now of course this doesn’t take all the logic out of the equation… it was still a hunt and peck around the grid. I made some notes of what was divisible by what, but with the number of linked clues that had to be solved together, I really needed that sheet that populated multiple entries when I tried a new combination of numbers.

I do remember wondering if I’d ever figure out which letter was 1… and that was a stroke of genius on the setters part by only having 1 (which I think was W) appearing in only 1 clue.

OK… now what.  32 cells stay as numbers (out of 66).  For the rest, there’s a cipher, where each number stands for 1-3 letters… Both end columns are the same…  the columns might be a key here – I see a column with 1111 and 2222… but 3334 and 4445.  Huh?  Next to those is 4321 three times.  Maybe the cipher will helps… it sounds like we should arrange the letters we just solved for in order, and use the second digit.

I tried that, and got nothing from the title.

What if isn’t the order of the letters in the answers, but just the normal ordering of letters?  That would probably have made the grid construction easier, right, if you didn’t have to come up with a code and the method of clueing letters together.  That looks more promising – REJOB could become HOTEL.

Aaaah… the identical columns are STAIRS.  There’s the RECEPTION at the bottom, a PENTHOUSE at the top and a LIFT in the middle.

I guess there’s no room 13? In the US that used to be a big thing, but I don’t recall the number 13 being left off of room numbers lately.  I’m traveling next week, I’ll check… though I am going to New Orleans, and if anywhere is going to be a superstitious hotel town, New Orleans sounds like a good option. Anyhoo – we have a grid!

My working grid for Listener 4490, REJOB (or HOTEL) by Botox

This wasn’t too bad – I did this all in one long, three hour session. About half an hour to write the Excel code, about another two hours fiddling with the numbers to make them fit, and not too long head-scratching about the cipher.

The last few years I’ve made a mess of the first numerical, but this time I think I’ve cracked it!  Victory to George.

Game over:  100% completion.

Feel free to tell me that Excel is far worse than anything else I regularly do, and see you next week when Dysart describes me in puzzle form.

Advertisements