
Decoding with Excel
October 16, 2009 - 5:44pm
I noticed that several people have said that they have used Excel to decode the latest from the watchmaker. I understand it has to be read vertically. I am not very familiar with Excel. Would I manually type in one character at a time per cell or is there an easier way to set it up in Excel?
Thanks!
October 16, 2009 - 6:56pm
#2
I hope you are coming on Sunday Kim, I am definately not into this decoding thing and am doing the basic coattail thing here, I hope that I have helped enough people on other things to rate that, lol, so I will ask for word clues to get me there, dont want the answer, just the road map. Micci
October 16, 2009 - 7:53pm
#3
I'll be there Sunday! And you know I can give an obscure hint quicker than I could ever give a direct answer to anything. :)
October 16, 2009 - 8:08pm
#4
It occurred to me that decoding this vertical code thing would be a cinch if all of the letters were the same width. We could then use Shilfiell's idea of using a postcard to cross out columns ala last Saturday's crossword puzzle's diagonal clue. I thought there was a block-type font that had this feature, but I couldn't find it.
There's gotta be some fast way to decode it. The Watchmaker's post came out at, what, 9 p.m. and some people had the achievement by 7 or 8 a.m. the next morning when I logged in.
October 17, 2009 - 2:07am
#5
No, Shilfiell has the fastest method to geting to the point of being able to read this. I had it solved before I went to bed that night.
October 17, 2009 - 10:56pm
#6
Conditional formating in Excel can also be useful for spotting letter patterns
October 18, 2009 - 12:37am
#7
Kim,
Thanks for the nice, clear direction on how to import the document into excel. I made my way through it and got the achievement!!
Thanks again.










I took the easy way out...save all the text in a Word or other editor in Text-only .txt format, then open that document in Excel. When it asks about importing the text document, say you want it fixed-width and click next, then on the next screen click the top of every column to set the cell size one character wide. Click all 50-something columns and then click Finish, and viola!