Cryptography and Cryptanalysis in MS EXCEL

Deyan Mihaylov
University of Economics – Varna

https://doi.org/10.53656/math2022-1-4-kri

Abstract. This paper provides implementations of three well-known ciphers –Caesar Cipher, Vigenere Cipher and Hill Cipher in Microsoft Excel. It is shown howthe ciphers can be broken by using Brute-force Attack, Frequency Analysis Attack and Known-plaintext Attack. For the purpose of the cryptanalysis the relative occurrence frequencies of the letters and the index of coincidence (κ ) in Bulgarian language are determined. The classical Frequency Analysis Attack is modified using the cross-correlation between frequencies of letters in the natural language and the cipher text. Modular matrix operations in MS Excel are shown.
Keywords: cryptanalysis; MS Excel

Свързани статии:

Innovative Teaching Methods in the Electronic Environment On the Sound, Produced by a Coin, Rolling In A Balloon Project-based Learning for Social-emotional and Technological Skills through the Skills for Innovation Program Basic Requirements for Characteristics of the Korean Language e-Textbook