God says...
forgive duty Beginning wide talented tame swollen vagrant
us expenses floods Insomuch carcase arranged voluptuous
Gutenberg holiness Colorado picture Behold vex to boasting
converted English perpetual fence mode deliverest ignorance
Holy although exposed subjection beg kingdom why pitch
settled examined Praetorian purposing Each prohibition
affrighted posted ambition Tully truth approached feareth
drove breadth womanish apparent
God says...
C:\LoseThos\www.losethos.com\text\words\AUGUST.TXT
essence, yea lastly how inseparable a distinction there is,
and yet a distinction. Surely a man hath it before him; let him look
into himself, and see, and tell me. But when he discovers and can
say any thing of these, let him not therefore think that he has
found that which is above these Unchangeable, which Is unchangeably,
and Knows unchangeably, and Wills unchangeably; and whether because of
these three, there is in God also a Trinity, or whether all three be
in Each, so that the three belong
From a quick look (so I may be mistaken), the "Enigma" worksheet has everything it needs to encode a single letter using worksheet formulae.
The VBA just loops through the input text, feeding it into the worksheet character by character and incrementing the step counts, which are referred to by the worksheet formulae. It also looks up the initial rotor positions from the "Settings" table from the "keys" on the main interface worksheet.
That's for encryption - there are another 30 lines of code for decryption which I haven't looked at. It looks hand-coded rather than recorded, but most of the VBA is either incrementing counters or calling worksheet functions, so the VBA isn't doing the heavy lifting.
Your friend may not call himself a programmer but I do Excel/VBA work as part of my job, along with more hacker-approved languages, and I'm very impressed. One of us indeed!
Whoa...that's awesome. Definitely a programmer. I don't care what you think of VBA...it is a great tool. I've seen some truly impressive programs written in it.
He may not be a programmer by day, but he certainly has the mentality of one. This definitely is not the kind of macro that can be recorded and works immediately. For someone who is a "non-programmer" it's pretty impressive to figure out how to use nested loops for such an obscure task. How has nobody mentioned how cool this is?!
VBA is an awesome tool. It has saved me hundreds of hours of tedious calculations and copy/pasting sessions.
if you haven't read The Code Book by Simon Singh (as I recommended), you'll be surprisingly pleased by its depth. Everyone loves it. It was the book that inspired that spreadsheet; it clearly contains enough info to go and try and implement an Engima machine :) It also covers Lorenz (http://en.wikipedia.org/wiki/Lorenz_cipher) and such. It covers lots of both older and newer systems too, and even has a puzzles section.
If you want more of the human side, "Code Breakers: The Inside Story of Bletchley Park" is a dry non-technical memoirs by a those who were actually there.
Thanks for everyone shabble, fduran and willvarfar's responses; I didn't realize The Code Book's depth and am really excited to see the positive responses here.
Apart from Singh's incredibly famous one, I also quite enjoyed _Colossus: The secrets of Bletchley Park_[1] for technical history.
The autobiography of Leo Marks: _Between Silk & Cyanide_[2] was a good (although I suspect quite heavily dramatised & exaggerated) read about the more human elements and flaws of pen & paper crypto used by the allied resistance groups.
Not a book, but if you're interested in codes and codebreaking, it's worth a trip to the "National Cryptologic Museum", located right outside the NSA headquarters at Ft. Meade, Maryland (between Baltimore and DC). It's a relatively small place that's open daily and seems to be a labor of love by retired NSA codebreakers.
The museum has a four-rotor Enigma machine, which is about the size of a typewriter. It is packed into a wooden case and deployable into the field.
The museum also has a "Bombe", the Enigma codebreaking machine devised originally by Polish mathematicians, and improved by Alan Turing and others, and fabricated in quantity by the British and the Americans during the war. This an electromechanical device the size of several refrigerators.
So nice to see them both together. Of course, I have today's simple and compact encryption technology in my phone, and right across the parking lot from the museum, there is an acreage of computers (Ft. Meade) which is probably able to decrypt what I send, if desired. Same as it ever was.
Not really; I've never done any cryptography so I wouldn't know if I liked it. I thought I'd see if I liked it by learning about it for a WW2 class. Thanks for the suggestion, though.
What's the threshold for being considered a programmer, really? For example, I don't consider myself one, even though I have created scripts in PowerShell and Bash.
27 comments
[ 3.9 ms ] story [ 78.8 ms ] threadGod says... C:\LoseThos\www.losethos.com\text\words\AUGUST.TXT
essence, yea lastly how inseparable a distinction there is, and yet a distinction. Surely a man hath it before him; let him look into himself, and see, and tell me. But when he discovers and can say any thing of these, let him not therefore think that he has found that which is above these Unchangeable, which Is unchangeably, and Knows unchangeably, and Wills unchangeably; and whether because of these three, there is in God also a Trinity, or whether all three be in Each, so that the three belong
The VBA just loops through the input text, feeding it into the worksheet character by character and incrementing the step counts, which are referred to by the worksheet formulae. It also looks up the initial rotor positions from the "Settings" table from the "keys" on the main interface worksheet.
That's for encryption - there are another 30 lines of code for decryption which I haven't looked at. It looks hand-coded rather than recorded, but most of the VBA is either incrementing counters or calling worksheet functions, so the VBA isn't doing the heavy lifting.
Your friend may not call himself a programmer but I do Excel/VBA work as part of my job, along with more hacker-approved languages, and I'm very impressed. One of us indeed!
Reminds me of http://news.ycombinator.com/item?id=3374431
VBA is an awesome tool. It has saved me hundreds of hours of tedious calculations and copy/pasting sessions.
"Alan Turing: The Enigma" http://www.amazon.com/Alan-Turing-Enigma-Andrew-Hodges/dp/08... , supposedly the best biography of Turing, I enjoyed it. There's quite a bit on his work on the Enigma but not technical.
if you haven't read The Code Book by Simon Singh (as I recommended), you'll be surprisingly pleased by its depth. Everyone loves it. It was the book that inspired that spreadsheet; it clearly contains enough info to go and try and implement an Engima machine :) It also covers Lorenz (http://en.wikipedia.org/wiki/Lorenz_cipher) and such. It covers lots of both older and newer systems too, and even has a puzzles section.
If you want more of the human side, "Code Breakers: The Inside Story of Bletchley Park" is a dry non-technical memoirs by a those who were actually there.
I would like to know more about Dilly's attacks on Spanish Enigma - http://www.schneier.com/blog/archives/2012/03/rare_spanish_e... - anyone know a book with any detail? Anything on his earlier work too, even?
The autobiography of Leo Marks: _Between Silk & Cyanide_[2] was a good (although I suspect quite heavily dramatised & exaggerated) read about the more human elements and flaws of pen & paper crypto used by the allied resistance groups.
[1] http://www.amazon.co.uk/Colossus-secrets-Bletchley-code-brea...
[2] http://www.amazon.com/Between-Silk-Cyanide-Codemakers-1941-1...
The museum has a four-rotor Enigma machine, which is about the size of a typewriter. It is packed into a wooden case and deployable into the field.
The museum also has a "Bombe", the Enigma codebreaking machine devised originally by Polish mathematicians, and improved by Alan Turing and others, and fabricated in quantity by the British and the Americans during the war. This an electromechanical device the size of several refrigerators.
So nice to see them both together. Of course, I have today's simple and compact encryption technology in my phone, and right across the parking lot from the museum, there is an acreage of computers (Ft. Meade) which is probably able to decrypt what I send, if desired. Same as it ever was.