Consulting

Results 1 to 3 of 3

Thread: Question / Challenge - Lorenz Cipher Excel

  1. #1
    VBAX Tutor
    Joined
    Mar 2010
    Posts
    287
    Location

    Question Question / Challenge - Lorenz Cipher Excel

    Hi...does anybody have (or accept the challenge of producing) a Lorenz Cipher machine (SZ40). The WWII German Army cipher machine. Would be nice to get a fully working simulation as it would help my studies of cryptography.

    There are several articles on wikipedia, with one dedicated to the breaking of the Lorenze Cipher. The output is then produced in

    Lorenz SZ40 http://en.wikipedia.org/wiki/Lorenz_SZ40/42

    Cryptanalysis of the Lorenz Cipher http://en.wikipedia.org/wiki/Cryptan..._Lorenz_cipher

    It uses XOR encryption with added layers of complexity. The below macro code is useful for basic XOR encryption.

    http://www.mediafire.com/?3ba2ta92lfqhfg7

    The output should be in the original format ITA2 http://en.wikipedia.org/wiki/Baudot_code#ITA2 with a formula / lookup table to convert this into plaintext?

    This would be a fun challenge

    NOTE : Would also be interested in any example of cryptography or cipher usage in excel (enigma, blowfish) etc and reverse engineering / decoding tools.

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,728
    Location
    I think this was answered in the cross-post

    http://www.mrexcel.com/forum/showthread.php?p=3125156

    Paul

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,060
    Location
    theta, please do not cross post without also posting the link to the other forum/s.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •