Cryptography and Cryptanalysis in MS EXCEL Cover Image
  • Price 4.50 €

Криптография и криптоанализ с MS EXCEL
Cryptography and Cryptanalysis in MS EXCEL

Author(s): Deyan Mihaylov
Subject(s): Social Sciences, Economy, Education, Business Economy / Management, School education, Adult Education, Higher Education , History of Education, Financial Markets, ICT Information and Communications Technologies, Distance learning / e-learning, Pedagogy
Published by: Национално издателство за образование и наука „Аз-буки“
Keywords: cryptanalysis; MS Excel

Summary/Abstract: This paper provides implementations of three well-known ciphers – Caesar Cipher, Vigenere Cipher and Hill Cipher in Microsoft Excel. It is shown how the 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.

  • Issue Year: 65/2022
  • Issue No: 1
  • Page Range: 53-71
  • Page Count: 19
  • Language: Bulgarian