{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["AlbamAtbaš","CEZAROVA SIFRA","Cezarova sifraII","Pouzitie dvoch abecied","Transpozícia_suradnice","TranspozíciaII","Transpozícia_III","Vigener_princíp","Vigener","frekvencia znakov","Freq","RSA"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":1,"defined_names":3,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AlbamAtbaš","index":0,"n_rows":26,"n_cols":60,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,16,0,28],[0,2,0,14],[14,2,14,14],[14,16,14,28],[19,0,19,1]]}
[null,null,"Albam\nAlbam\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"Atbaš"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z",null,null,"AÁÄBCČDĎEÉFGHIÍJKLĹĽMNŇOÓÔPQRŔSŠTŤUÚVWXYÝZŽŽZÝYXWVÚUŤTŠSŔRQPÔÓOŇNMĽĹLKJÍIHGFÉEĎDČCBÄÁÄ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z","Y","X","W","V","U","T","S","R","Q","P","O","N","M","L","K","J","I","H","G","F","E","D","C","B","A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ALBAM",null,null,null,null,null,null,null,null,null,null,null,null,null,"ATBAŠ"]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M",null,"A","B","C","D","E","F","G","H","I","J","K","L","M"]
[null,null,"N","O","P","Q","R","S","T","U","V","W","X","Y","Z",null,"Z","Y","X","W","V","U","T","S","R","Q","P","O","N"]
[]
[]
["Otvorený text",null,"U","T","E","K","Z","E","G","Y","P","T","A","P","R","I","N","O","V","E","M","E","S","I","A","C","A","M","O","J","Z","I","S"]
[null,"ALBAM","H","G","R","X","M","R","T","L","C","G","N","C","E","V","A","B","I","R","Z","R","F","V","N","P","N","Z","B","W","M","V","F"]
[null,"ATBAŠ","F","G","V","P","A","V","T","B","K","G","Z","K","I","R","M","L","E","V","N","V","H","R","Z","X","Z","N","L","Q","A","R","H"]
[]
[null,null,"Desifrujte text:"]
["Úloha",null,"P","R","E","K","R","O","C","T","E","J","O","R","D","A","N","J","O","S","U","E"]
[null,null,"C","E","R","X","E","B","P","G","R","W","B","E","Q","N","A","W","B","F","H","R"]

{"sheet":"CEZAROVA SIFRA","index":1,"n_rows":51,"n_cols":33,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C"]
[]
[]
[]
[null,"G","Q","H","V","Y","H","F","H","U","E","X","G","H","P","Q","D","U","D","Q","G","H","V","N","O","H","R","S","D","W","U","R","X"]
[]
[null,"D","N","E","S","V","E","C","E","R","B","U","D","E","M","N","A","R","A","N","D","E","S","K","L","E","O","P","A","T","R","O","U"]
[]
[]
[]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
["Wingdings","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B"]
["Symbol","F","P","U","X","G","E","G","T","D","W","F","G","O","P","C","T","C","P","F","G"]
["Wingdings3","F","P","U","X","G","E","G","T","D","W","F","G","O","P","C","T","C","P","F","G"]
["Vivaldi","F","P","U","X","G","E","G","T","D","W","F","G","O","P","C","T","C","P","F","G"]
["Bookshelf Symbol 7","F","P","U","X","G","E","G","T","D","W","F","G","O","P","C","T","C","P","F","G"]
["MS Reference Specialty","F","P","U","XI","G","E","G","T","D","W","F","G","O","P","C","T","C","P","F","G"]
["Bookdings","F","P","U","XII","G","E","G","T","D","W","F","G","O","P","C","T","C","P","F","G"]
[null,"F","P","U","XII","G","E","G","T","D","W","F","G","O","P","C","T","C","P","F","G"]
[null,"F","P","U","XII","G","E","G","T","D","W","F","G","O","P","C","T","C","P","F","G"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,{"$f":"CODE(B43)","v":65},{"$f":"CODE(C43)","v":66},67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,{"$f":"DEC2HEX(B44)","v":"41"},{"$f":"DEC2HEX(C44)","v":"42"},"43","44","45","46","47","48","49","4A","4B","4C","4D","4E","4F","50","51","52","53","54","55","56","57","58","59","5A"]
[null,{"$f":"DEC2OCT(B44)","v":"101"},{"$f":"DEC2OCT(C44)","v":"102"},"103","104","105","106","107","110","111","112","113","114","115","116","117","120","121","122","123","124","125","126","127","130","131","132"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]

{"sheet":"Cezarova sifraII","index":2,"n_rows":16,"n_cols":34,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,17],[0,0,0,17],[15,0,15,1],[13,0,13,1],[6,0,6,1],[9,0,9,1],[7,2,7,21],[9,2,9,21],[10,0,10,1]]}
["Césarova substitucná šifra"]
["Vytvorte  v programe Excel pomocou textových funkcií šifrovací a dešifrovací stroj, ktorý realizuje Cézarovu šifru posunom abecedy o n pozícii. Šifrovanie a dešifrovanie:\nDo prvého riadku tabuľky zapíšte otvorený text, v druhom riadku bude bunka s posunom, do tretieho riadku vložte funkciu, ktorá hodnotu znaku v tabuľke ASCII posunie o n- pozícii a vzorec nakopírujeme do ostatných buniek(šifrovaný text ), v štvrtom riadku použijete funkciu na kontrolu, ktorá hodnotu v treťom riadku znovu dešifruje.\nDešifrovací stroj\nV druhej tabuľke do prvého riadku vložte  šifrovaný text,  ktorý nájdete v súbore šifra.txt, do  druhého riadku vložte hodnotu n  (posunutie ) a do tretieho vložte funkciu, ktorá  zobrazí dešifrovaný text. \nMeňte hodnotu n dovtedy, kým text bude mať zmysel. \nDešifrovaný text odovzdajte vyučujúcemu"]
[]
[]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Šifrovanie",null,"D","N","E","S","V","E","C","E","R","B","U","D","E","M","N","A","R","A","N","D","E","S","K","L","E","O","P","A","T","R","O","U"]
["Kľúč",3,"Otvorený text"]
[null,null,{"$f":"CHAR(CODE(C7)+$B$8)","v":"G"},"Q","H","V","Y","H","F","H","U","E","X","G","H","P","Q","D","U","D","Q","G","H","V","N","O","H","R","S","D","W","U","R","X"]
["Dešifrovanie",null,"Zašifrovaný text"]
["Kontrola",null,{"$f":"CHAR(CODE(C9)-$B$8)","v":"D"},{"$f":"CHAR(CODE(D9)-$B$8)","v":"N"},"E","S","V","E","C","E","R","B","U","D","E","M","N","A","R","A","N","D","E","S","K","L","E","O","P","A","T","R","O","U"]
[]
[]
["Tex na dešifrovanie",null,"G","Q","H","V","Y","H","F","H","U","E","X","G","H"]
["Kľúč",3]
["Dešifrovaný text",null,{"$f":"CHAR(CODE(C14)-$B$15)","v":"D"},{"$f":"CHAR(CODE(D14)-$B$15)","v":"N"},"E","S","V","E","C","E","R","B","U","D","E"]

{"sheet":"Pouzitie dvoch abecied","index":3,"n_rows":31,"n_cols":28,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,26]]}
[null,"Použitie dvoch abecied"]
[]
[]
["Otvorená abeceda","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
["Šifrová abeceda 1","F","Z","B","V","K","I","X","A","Y","M","E","P","L","S","D","H","J","O","R","G","N","Q","C","U","T","W"]
["Šifrová abeceda 2","G","O","X","B","F","W","T","H","Q","I","L","A","P","Z","J","D","E","S","V","Y","C","R","K","U","H","N"]
["Dnesveceroosemnulautok","d","n","e","s","v","e","c","e","r","o","o","s","e","m","n","u","l","a","u","t","o","k"]
[]
[null,12]
[null,"v","z","k","v","q","f","b","f","o","j","d","v","k","p","s","c","p","g","n","y","d","l"]
[]
[]
[null,"v","z","k","v","q","f","b","f","o","j","d","v","k","p","s","c","p","g","n","y","d","l","c","x",7,2]
["Veľké písmena",{"$f":"UPPER(B13)","v":"V"},{"$f":"UPPER(C13)","v":"Z"},"K","V","Q","F","B","F","O","J","D","V","K","P","S","C","P","G","N","Y","D","L","C","X","7","2"]
[]
["Prevod do ASCII",{"$f":"CODE(B14)","v":86},{"$f":"CODE(C14)","v":90},75,86,81,70,66,70,79,74,68,86,75,80,83,67,80,71,78,89,68,76,67,88,55,50]
[]
["Prevod do HEX",{"$f":"DEC2HEX(B16)","v":"56"},{"$f":"DEC2HEX(C16)","v":"5A"},"4B","56","51","46","42","46","4F","4A","44","56","4B","50","53","43","50","47","4E","59","44","4C","43","58","37","32"]
[]
[]
[null,"56","5A","4B","56","51","46","42","46","4F","4A","44","56","4B","50","53","43","50","47","4E","59","44","4C","43","58","37","32"]
[null,{"$f":"HEX2BIN(B21)","v":"1010110"},{"$f":"HEX2BIN(C21)","v":"1011010"},"1001011","1010110","1010001","1000110","1000010","1000110","1001111","1001010","1000100","1010110","1001011","1010000","1010011","1000011","1010000","1000111","1001110","1011001","1000100","1001100","1000011","1011000","110111","110010"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"MOD(B16,64)","v":22},{"$f":"MOD(C16,64)","v":26},11,22,17,6,2,6,15,10,4,22,11,16,19,3,16,7,14,25,4,12,3,24,55,50,0]

{"sheet":"Transpozícia_suradnice","index":4,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,8,0,23]]}
[null,null,null,null,null,null,null,null,"Transpozícia - súradnice"]
[]
[null,null,1,2,3,4,5,null,"VIEMZENICNEVIEM","V","I","E","M","Z","E","N","I","C","N","E","V","I","E","M"]
[null,"A","a","b","c","d","e",null,"2E4D3B2C5A4B4D3A4B5A2E4D5A3B","2E","4D","5A","3B","2C","5A","4B","4D","3A","4B","5A","2E","4D","5A","3B"]
[null,"B","k","l","m","n","o"]
[null,"C","p","z","r","s","t"]
[null,"D","f","g","h","i","j"]
[null,"E","u","v","w","x","y"]

{"sheet":"TranspozíciaII","index":5,"n_rows":33,"n_cols":26,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,2,0,11],[20,2,20,11]]}
[null,null,"Rail Fence šifra"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"B",null,null,null,"S",null,null,null,"A",null,null,null,"M"]
[null,null,null,"O",null,"I",null,"M",null,"N",null,"F",null,"L",null,"E"]
[null,null,null,null,"L",null,null,null,"E",null,null,null,"I"]
[]
[]
[null,null,"B","S","A","M","O","I","M","N","F","L","E","L","E","I"]
[]
[null,null,"ROUTE Šifra"]
[]
[]
[]
[]
[]
[]
[null,null,"B","S","D","E","R","O"]
[null,null,"O","T","H","N","A","V"]
[null,null,"L","E","A","I","D","I"]
[null,null,"I","O","L","Z","C","A"]
[]
[null,null,"B","S","D","E","R","O","O","T","H","N","A","V","L","E","A","I","D","I","I","O","L","Z","C","A"]

{"sheet":"Transpozícia_III","index":6,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,3],[8,1,8,3],[8,4,8,8],[0,1,0,3],[0,4,0,8],[18,3,18,8],[17,4,17,8],[17,1,17,3]]}
[null,"Otvorený text",null,null,"DNES VECER PRILETI UFO Z MARSU"]
[]
[null,null,null,"D","E","R","I","M"]
[null,null,null,"N","C","I","U","A"]
[null,null,null,"E","E","L","F","R"]
[null,null,null,"S","R","E","O","S"]
[null,null,null,"V","P","T","Z","U"]
[]
[null,"Zašifrovaný text",null,null,{"$f":"CONCATENATE(D3,E3,F3,G3,H3,D4,E4,F4,G4,H4,D5,E5,F5,G5,H5,D6,E6,F6,G6,H6,D7,E7,F7,G7,H7)","v":"DERIMNCIUAEELFRSREOSVPTZU"}]
[]
[]
[null,null,null,"D","N","E","S","B"]
[null,null,null,"Z","I","N","F","U"]
[null,null,null,"A","TI","KY","O","D"]
[null,null,null,"K","A","M","R","E"]
[null,null,null,"M","O","S","I","P"]
[]
[null,"Otvorený text",null,null,"DNES BUDE PISOMKA  Z INFORMATIKY"]
[]
[null,"Zašifrovaný text",null,null,{"$f":"CONCATENATE(D12,D13,D14,D15,D16,E12,E13,E14,E15,E16,F12,F13,F14,F15,F16,G12,G13,G14,G15,G16,H12,H13,H14,H15,H16)","v":"DZAKMNITIAOENKYMSSFORIBUDEP"}]

{"sheet":"Vigener_princíp","index":7,"n_rows":34,"n_cols":27,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,14],[2,0,4,0],[1,1,1,26],[2,1,4,9]]}
[null,"Vigenérova šifra - Le chiffre indéchiffrable"]
[null,"Zašifrujte pomocou Vegenérovej šifry zprávu: UTOK ZACNITEOPATNULA, Heslo: DOVOLENKA "]
["Princíp:","Vigenerova šifra je substitučná šifra, pretože sa každý znak správy nahradí  iným znakom (ktorý leží v priesečníku riadka znaku kľúča a stĺpca znaku správy). Kľúč má byť dostatočne dlhý. Ak je kratší ako  správa, opakujú sa jeho znaky. "]
[]
[]
["TEXT","U","T","O","K","Z","A","C","N","E","M","E"]
["HESLO","D","O","V","O","L","E","N","K","A","D","O"]
["SIFRA","X","H","J","Y"]
["a","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A"]
[null,"C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B"]
["d","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C"]
[null,"E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D"]
["e","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E"]
[null,"G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F"]
[null,"H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G"]
[null,"I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H"]
[null,"J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I"]
["k","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J"]
["l","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K"]
[null,"M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L"]
["n","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M"]
["o","O","P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N"]
[null,"P","Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O"]
[null,"Q","R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P"]
[null,"R","S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q"]
[null,"S","T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R"]
[null,"T","U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S"]
[null,"U","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T"]
["v","V","W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U"]
[null,"W","X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V"]
[null,"X","Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W"]
[null,"Y","Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X"]
[null,"Z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y"]

{"sheet":"Vigener","index":8,"n_rows":15,"n_cols":70,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,5,2,6],[4,1,4,14],[0,1,0,14],[14,1,14,39]]}
[null,"Vigenérova šifra - Le chiffre indéchiffrable"]
[]
[null,null,"Šifruj 1",null,null,"Dešifruj -1",null,1,null,"Šifrovanie",{"$f":"LEN(B9)","v":39},"znakov",null,"Dĺžka kľúča=",{"$f":"A6","v":9}]
["Stlpec",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69]
["Kľúč","dovolenka"]
[{"$f":"LEN($B$5)","v":9},{"$f":"REPT($B$5,70/A6+1)","v":"dovolenkadovolenkadovolenkadovolenkadovolenkadovolenkadovolenkadovolenka"}]
["Rozvoj",{"$f":"UPPER(MID($B$6,B$4,1))","v":"D"},{"$f":"UPPER(MID($B$6,C$4,1))","v":"O"},{"$f":"UPPER(MID($B$6,D4,1))","v":"V"},{"$f":"UPPER(MID($B$6,E4,1))","v":"O"},"L","E","N","K","A","D","O","V","O","L","E","N","K","A","D","O","V","O","L","E","N","K","A","D","O","V","O","L","E","N","K","A","D","O","V","O","L","E","N","K","A","D","O","V","O","L","E","N","K","A","D","O","V","O","L","E","N","K","A","D","O","V","O",{"$f":"UPPER(MID($B$6,BQ4,1))","v":"L"},"E"]
["KÓD ASCII",{"$f":"CODE(B7)","v":68},{"$f":"CODE(C7)","v":79},86,79,76,69,78,75,65,68,79,86,79,76,{"$f":"CODE(P7)","v":69},78,75,65,68,79,86,79,76,69,78,75,65,68,79,86,79,76,69,78,75,65,68,79,86,79,76,69,78,75,65,68,79,86,79,76,69,78,75,65,68,79,86,79,76,69,78,75,65,68,79,{"$f":"CODE(BO7)","v":86},79,76,69]
["Otvorený text","utokzacnemeranopatnulanakotetristodesat"]
["Rozvoj",{"$f":"UPPER(MID($B$9,B4,1))","v":"U"},{"$f":"UPPER(MID($B$9,C4,1))","v":"T"},"O","K","Z","A","C","N","E","M","E","R","A","N","O","P","A","T","N","U","L","A","N","A","K","O","T","E","T","R","I","S","T","O","D","E","S","A","T","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"UPPER(MID($B$9,BO4,1))","v":""},"","",""]
["KÓD ASCII",{"$f":"CODE(B10)","v":85},{"$f":"CODE(C10)","v":84},79,75,90,65,67,78,69,77,69,82,65,78,79,80,65,84,78,85,76,65,78,65,75,79,84,69,84,82,73,83,84,79,68,69,83,65,84,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"CODE(BO10)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Šifra",{"$f":"MOD(B11+$H$3*B8,26)+65","v":88},{"$f":"MOD(C11+$H$3*C8,26)+65","v":72},74,89,75,69,80,88,69,80,83,77,79,89,83,67,75,84,81,73,71,79,89,69,88,89,84,72,72,77,87,68,88,66,78,69,86,79,79,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"MOD(BO11+$H$3*BO8,26)+65","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Znaky",{"$f":"CHAR(B12)","v":"X"},{"$f":"CHAR(C12)","v":"H"},"J","Y","K","E","P","X","E","P","S","M","O","Y","S","C","K","T","Q","I","G","O","Y","E","X","Y","T","H","H","M","W","D","X","B","N","E","V","O","O",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"CHAR(BO12)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"X","H","J","Y","K","E","P","X","E","P","S","M","O","Y","S","C","K","T","Q","I","G","O","Y","E","X","Y","T","H","H","M","W","D","X","B","N","E","V","O","O",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Odošli",{"$f":"CONCATENATE(B13,C13,D13,E13,F13,G13,H13,I13,J13,K13,L13,M13,N13,O13,P13,Q13,R13,S13,T13,U13,V13,W13,X13,Y13,Z13,AA13,AB13,AC13,AD13,AE13,AF13,AG13,AH13,AI13,AJ13,AK13,AL13,AM13,AN13)","v":"XHJYKEPXEPSMOYSCKTQIGOYEXYTHHMWDXBNEVOO"}]

{"sheet":"frekvencia znakov","index":9,"n_rows":58,"n_cols":19,"rows_kept":58,"cut":false,"hidden":false,"merged":[[28,5,28,8]]}
["Jazyk","slovenčina","angličtina","nemčina"]
["A",11.4,8.1999999999999993,6.5]
["B",2,1.5,1.9]
["C",3.5,2.8,3.1]
["D",3.6,4.3,5.0999999999999996]
["E",8.1,12.7,17.399999999999999]
["F",0.1,2.2000000000000002,1.7]
["G",0.2,2,3]
["H",2.4,6.1,4.8]
["I",7.4,7,7.6]
["J",2,0.2,0.3]
["K",4,0.8,1.2]
["L",4.9000000000000004,4,3.4]
["M",3.2,2.4,2.5]
["N",5.5,6.7,9.8000000000000007]
["O",9.8000000000000007,7.5,2.5]
["P",3.1,1.9,0.8]
["Q",0,0.1,0.1]
["R",4.3,6,7]
["S",5.3,6.3,7.3]
["T",5,9.1,6.2]
["U",3.4,2.8,4.4000000000000004]
["V",4.7,1,0.7]
["W",0,2.4,1.9]
["X",0,0.2,0.1]
["Y",2.5,0.2,0.1]
["Z",3.5,0.1,1.1000000000000001]
["zdroj",1,2,3]
[null,null,null,null,null,"Frekvencia znakov"]
[]
["Jazyk","slovenčina","angličtina","nemčina",null,"Jazyk","slovenčina","angličtina","nemčina",null,"Jazyk","slovenčina","angličtina","nemčina",null,"Jazyk","slovenčina","angličtina","nemčina"]
["A",11.4,8.1999999999999993,6.5,null,"A",11.4,8.1999999999999993,6.5,null,"E",8.1,12.7,17.399999999999999,null,"E",8.1,12.7,17.399999999999999]
["B",2,1.5,1.9,null,"O",9.8000000000000007,7.5,2.5,null,"T",5,9.1,6.2,null,"N",5.5,6.7,9.8000000000000007]
["C",3.5,2.8,3.1,null,"E",8.1,12.7,17.399999999999999,null,"A",11.4,8.1999999999999993,6.5,null,"I",7.4,7,7.6]
["D",3.6,4.3,5.0999999999999996,null,"I",7.4,7,7.6,null,"O",9.8000000000000007,7.5,2.5,null,"S",5.3,6.3,7.3]
["E",8.1,12.7,17.399999999999999,null,"N",5.5,6.7,9.8000000000000007,null,"I",7.4,7,7.6,null,"R",4.3,6,7]
["F",0.1,2.2000000000000002,1.7,null,"S",5.3,6.3,7.3,null,"N",5.5,6.7,9.8000000000000007,null,"A",11.4,8.1999999999999993,6.5]
["G",0.2,2,3,null,"T",5,9.1,6.2,null,"S",5.3,6.3,7.3,null,"T",5,9.1,6.2]
["H",2.4,6.1,4.8,null,"L",4.9000000000000004,4,3.4,null,"H",2.4,6.1,4.8,null,"D",3.6,4.3,5.0999999999999996]
["I",7.4,7,7.6,null,"V",4.7,1,0.7,null,"R",4.3,6,7,null,"H",2.4,6.1,4.8]
["J",2,0.2,0.3,null,"R",4.3,6,7,null,"D",3.6,4.3,5.0999999999999996,null,"U",3.4,2.8,4.4000000000000004]
["K",4,0.8,1.2,null,"K",4,0.8,1.2,null,"L",4.9000000000000004,4,3.4,null,"L",4.9000000000000004,4,3.4]
["L",4.9000000000000004,4,3.4,null,"D",3.6,4.3,5.0999999999999996,null,"C",3.5,2.8,3.1,null,"C",3.5,2.8,3.1]
["M",3.2,2.4,2.5,null,"C",3.5,2.8,3.1,null,"U",3.4,2.8,4.4000000000000004,null,"G",0.2,2,3]
["N",5.5,6.7,9.8000000000000007,null,"Z",3.5,0.1,1.1000000000000001,null,"M",3.2,2.4,2.5,null,"M",3.2,2.4,2.5]
["O",9.8000000000000007,7.5,2.5,null,"U",3.4,2.8,4.4000000000000004,null,"W",0,2.4,1.9,null,"O",9.8000000000000007,7.5,2.5]
["P",3.1,1.9,0.8,null,"M",3.2,2.4,2.5,null,"F",0.1,2.2000000000000002,1.7,null,"B",2,1.5,1.9]
["Q",0,0.1,0.1,null,"P",3.1,1.9,0.8,null,"G",0.2,2,3,null,"W",0,2.4,1.9]
["R",4.3,6,7,null,"Y",2.5,0.2,0.1,null,"P",3.1,1.9,0.8,null,"F",0.1,2.2000000000000002,1.7]
["S",5.3,6.3,7.3,null,"H",2.4,6.1,4.8,null,"B",2,1.5,1.9,null,"K",4,0.8,1.2]
["T",5,9.1,6.2,null,"B",2,1.5,1.9,null,"V",4.7,1,0.7,null,"Z",3.5,0.1,1.1000000000000001]
["U",3.4,2.8,4.4000000000000004,null,"J",2,0.2,0.3,null,"K",4,0.8,1.2,null,"P",3.1,1.9,0.8]
["V",4.7,1,0.7,null,"G",0.2,2,3,null,"J",2,0.2,0.3,null,"V",4.7,1,0.7]
["W",0,2.4,1.9,null,"F",0.1,2.2000000000000002,1.7,null,"X",0,0.2,0.1,null,"J",2,0.2,0.3]
["X",0,0.2,0.1,null,"Q",0,0.1,0.1,null,"Y",2.5,0.2,0.1,null,"Q",0,0.1,0.1]
["Y",2.5,0.2,0.1,null,"W",0,2.4,1.9,null,"Q",0,0.1,0.1,null,"X",0,0.2,0.1]
["Z",3.5,0.1,1.1000000000000001,null,"X",0,0.2,0.1,null,"Z",3.5,0.1,1.1000000000000001,null,"Y",2.5,0.2,0.1]
["zdroj",1,2,3,null,"zdroj",1,2,3,null,"zdroj",1,2,3,null,"zdroj",1,2,3]

{"sheet":"Freq","index":10,"n_rows":31,"n_cols":32,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Znak","Počet","Frekv.%",null,"Slovenčina %"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",5,0.17088174982911825,"A",10.88,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",61,2.0847573479152426,"B",9.39,"O"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",132,4.511278195488722,"C",8.49,"E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",104,3.5543403964456597,"D",6.17,"S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",177,6.0492139439507859,"E",5.99,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",148,5.0580997949419002,"F",5.79,"I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G",95,3.2467532467532467,"G",5.76,"T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",212,7.2453861927546139,"H",4.74,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I",97,3.315105946684894,"I",4.63,"V"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",0,0,"J",4.41,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",127,4.3403964456596036,"K",3.99,"K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",164,5.6049213943950784,"L",3.79,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",28,0.9569377990430622,"M",3.61,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",195,6.6643882433356119,"N",3.58,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O",100,3.4176349965823651,"O",3.13,"U"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P",132,4.511278195488722,"P",3.03,"P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q",79,2.6999316473000685,"Q",3,"Z"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",70,2.3923444976076556,"R",2.7,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",229,7.826384142173616,"S",2.5099999999999998,"H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T",95,3.2467532467532467,"T",2.19,"J"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U",100,3.4176349965823651,"U",1.81,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V",62,2.1189336978810664,"V",0.21,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W",44,1.5037593984962405,"W",0.2,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",183,6.2542720437457282,"X",0.01,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",192,6.5618591934381412,"Y",0.01,"Q"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z",79,2.6999316473000685,"Z",0.01,"W"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AB4:AB30)","v":2910}]

{"sheet":"RSA","index":11,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,9,0,10],[1,3,1,4],[5,4,5,6]]}
["ALGORITMUS RSA"]
[]
["Výpočet šifrovacieho exponentu:",null,null,null,null,null,null,"Rozklad na prvočísla:"]
[null,"p=",31,null,"(p-1)*(q-1)=",{"$f":"(1-C4)*(1-C5)","v":1500},null,2,2,3,5,5,5,1]
[null,"q=",51]
[null,"N=p.q",{"$f":"C4*C5","v":1581},null,"Proces šifrovania"]
[null,"s=",7,null,"x","y=xs mod N"]
["Výpočet dešifrovacieho exponentu:",null,null,null,10,{"$f":"MOD(E8^$C$7,$C$6)","v":175}]
[]
[]
[null,"t=",643]
["i","t","Kontrola",null,"Pozn. Proces dešifrovania tu nebol uplatnení."]
[1,{"$f":"(A13*$F$4+1)/$C$7","v":214.42857142857142},{"$f":"IF(ABS(INT(B13)-B13)<0.001,\"OK\",\"\")","v":""},null,"Vzorec na dešifrovanie je x=yt mod N, ale ak "]
[2,428.71428571428572,{"$f":"IF(ABS(INT(B14)-B14)<0.001,\"OK\",\"\")","v":""},null,"vyjde t len trochu vetšie, MS Excel z neho nedokáže "]
[3,643,"OK",null,"spočítat MOD, proto treba volit prvočísla radovo večšie v desiatkách a vyšie"]
[4,857.28571428571433,""]
[5,1071.5714285714287,""]
[6,1285.8571428571429,""]
[7,1500.1428571428571,""]
[8,1714.4285714285713,""]
[9,1928.7142857142858,""]
[10,2143,"OK"]
[11,2357.2857142857142,""]
[12,2571.5714285714284,""]
[13,2785.8571428571427,""]
[14,3000.1428571428573,""]