{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"1","index":0,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,9,2,21],[8,8,8,12],[9,8,9,12],[7,8,7,13],[18,8,18,19]]}
["Символ","Частота (f)","Код Фано","Всего для символа","Код Хаффмана","Всего для символа","По Шеннону","N=",{"$f":"LEN(J3)","v":0},"M=",{"$f":"COUNTIF(B2:B42,\">0\")","v":0},"Iш=",{"$f":"ROUNDUP(SUM(G2:G42),0)","v":0},"Iх=",{"$f":"I1*ROUNDUP(LOG(K1,2),0)","v":{"$error":"#NUM!"}}]
["а",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A2,))","v":0},null,{"$f":"$B2*LEN(C2)","v":0},null,{"$f":"$B2*LEN(E2)","v":0},{"$f":"IF(B2>0,B2*LOG($I$1/B2,2),0)","v":0}]
["м",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A3,))","v":0},null,{"$f":"$B3*LEN(C3)","v":0},null,{"$f":"$B3*LEN(E3)","v":0},{"$f":"IF(B3>0,B3*LOG($I$1/B3,2),0)","v":0},null,"Текст:"]
[" ",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A4,))","v":0},null,0,null,0,0]
["л",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A5,))","v":0},null,0,null,0,0]
["р",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A6,))","v":0},null,0,null,0,0]
["у",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A7,))","v":0},null,0,null,0,0]
["ы",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A8,))","v":0},null,0,null,0,0,null,"Ответ:"]
["-",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A9,))","v":0},null,0,null,0,0,null,"1)Метод Шеннона-Фано:",null,null,null,null,{"$f":"SUM(D2:D42)","v":0}]
["!",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A10,))","v":0},null,0,null,0,0,null,"2)Метод Хаффмана:",null,null,null,null,{"$f":"SUM(F2:F42)","v":0}]
[",",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A11,))","v":0},null,0,null,0,0]
[".",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A12,))","v":0},null,0,null,0,0]
[":",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A13,))","v":0},null,0,null,0,0,null,"1) Записать текст в ячейку J3"]
[";",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A14,))","v":0},null,0,null,0,0,null,"2)Нажать кнопку \"Сортировка\""]
["?",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A15,))","v":0},null,0,null,0,0,null,"3)Для полученного столбца B построить дерево Шеннона-Фано"]
["б",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A16,))","v":0},null,0,null,0,0,null,"4)Переписать полученные с помощью этого дерева коды символов в столбец C"]
["в",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A17,))","v":0},null,0,null,0,0,null,"5)Построить дерево Хаффмана"]
["г",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A18,))","v":0},null,0,null,0,0,null,"6)Переписать полученные с помощью этого дерева коды символов в столбец E"]
["д",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A19,))","v":0},null,0,null,0,0,null,"Все коды следует формировать от корня к листьям!!!"]
["е",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A20,))","v":0},null,0,null,0,0]
["ё",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A21,))","v":0},null,0,null,0,0]
["ж",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A22,))","v":0},null,0,null,0,0]
["з",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A23,))","v":0},null,0,null,0,0]
["и",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A24,))","v":0},null,0,null,0,0]
["й",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A25,))","v":0},null,0,null,0,0]
["к",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A26,))","v":0},null,0,null,0,0]
["н",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A27,))","v":0},null,0,null,0,0]
["о",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A28,))","v":0},null,0,null,0,0]
["п",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A29,))","v":0},null,0,null,0,0]
["с",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A30,))","v":0},null,0,null,0,0]
["т",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A31,))","v":0},null,0,null,0,0]
["ф",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A32,))","v":0},null,0,null,0,0]
["х",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A33,))","v":0},null,0,null,0,0]
["ц",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A34,))","v":0},null,0,null,0,0]
["ч",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A35,))","v":0},null,0,null,0,0]
["ш",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A36,))","v":0},null,0,null,0,0]
["щ",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A37,))","v":0},null,0,null,0,0]
["ъ",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A38,))","v":0},null,0,null,0,0]
["ь",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A39,))","v":0},null,0,null,0,0]
["э",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A40,))","v":0},null,0,null,0,0]
["ю",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A41,))","v":0},null,0,null,0,0]
["я",{"$f":"$I$1-LEN(SUBSTITUTE($J$3,A42,))","v":0},null,0,null,0,0]