Decoding with Excel

7 replies [Last post]
johnnysgirl
User offline. Last seen 3 years 22 weeks ago. Offline
Joined: 09/05/2009

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!

shilfiell's picture
shilfiell
User offline. Last seen 2 years 45 weeks ago. Offline
Joined: 09/09/2009

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!

angelwings777mp's picture
angelwings777mp
User offline. Last seen 3 years 25 weeks ago. Offline
Joined: 09/05/2009

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

shilfiell's picture
shilfiell
User offline. Last seen 2 years 45 weeks ago. Offline
Joined: 09/09/2009

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. :)

delos's picture
delos
User offline. Last seen 3 years 24 weeks ago. Offline
Joined: 10/03/2009

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.

jfilion's picture
jfilion
User offline. Last seen 31 weeks 6 days ago. Offline
Joined: 09/14/2009

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.

dtrabjohns's picture
dtrabjohns
User offline. Last seen 3 years 33 weeks ago. Offline
Joined: 09/11/2009

Conditional formating in Excel can also be useful for spotting letter patterns

johnnysgirl
User offline. Last seen 3 years 22 weeks ago. Offline
Joined: 09/05/2009

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.

Recent Achievements

Auld Lang Syne
Complete the Easy Holiday Bonus Slider
Earned by: mcandrews5
1 year ago
Bring on the New Year!
Complete the OMG Holiday Bonus Slider
Earned by: Vickie P
3 years ago
Party Like It's 2010
Complete the Medium Holiday Bonus Slider
Earned by: barbandkent
3 years ago