{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Лист1","Лист2","1","2","3","4","5","6","7","8","Лист3","Лист4","Лист5","Лист6"],"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":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["однажды в студеную зимнюю пору я из лесу вышел был сильный мороз",null,null,null,null,null,null,null,null,{"$f":"LEN(A1)","v":64},null,25]
["гляжу, поднимается медленно в гору лошадка, везущая хворосту воз",null,null,null,null,null,null,null,null,{"$f":"LEN(A2)","v":64},null,24]
["около леса, как в мягкой постели выспаться можно-покой и простор",null,null,null,null,null,null,null,null,64,null,22]
["листья поблекнуть ещё не успели, желты и свежи, лежат, как ковёр",null,null,null,null,null,null,null,null,64,null,22]
["мы, надрывавшись под зноем, под холодом, с вечно согнутой спиной",null,null,null,null,null,null,null,null,64,null,24]
["жили в землянке, боролися с голодом мёрзли и мокли болели цингой",null,null,null,null,null,null,null,null,64,null,21]
["да не робей - за отчизну любезную вынес достаточно русский народ!",null,null,null,null,null,null,null,null,65,null,22]
["вынес и эту дорогу железную, вынесет всё, что господь ни пошлет!",null,null,null,null,null,null,null,null,64,null,25]
[]
[]
["1) Подсчитать частоты символов"]
["2) Отсортировать их по частоте, если совпадает-по алфавиту(знаки после букв)"]
["3) Построить дерево Шеннона-Фано, записав в таблицу коды символов"]
["4) Вычислить произведения частоты каждого символа на длину его кода"]
["5) Найти сумму этих произведений (общую длину кода)"]
["6) Построить дерево Хаффмана, записав в таблицу коды символов"]
["7) Вычислить произведения частоты каждого символа на длину его кода"]
["8) Найти сумму этих произведений"]

{"sheet":"Лист2","index":1,"n_rows":30,"n_cols":72,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,0,null,null,1,null,null,null,null,0,null,null,1,null,null,null,null,0,null,null,1,null,null,null,null,0,null,null,1,null,0,1,null,null,null,null,0,null,null,1,null,null,null,0,null,null,1,null,0,1,null,null,null,null,0,null,null,1,null,0,1,null,0,1]
[" sp",11,"000",{"$f":"LEN(C2)*B2","v":33},null,"sp",11,4,"л",null,"sp",11,null,"sp",11,4,"у",null,"sp",11,null,"sp",11,2,"в",null,"в",2,null,"в",2,2,"р",null,"р","ь",null,"у",4,null,"у",4,3,"д",null,"у",4,"у",4,3,"с",null,"с","ш",null,"д",3,null,"д",3,3,"з",null,"д","й",null,"з","ж"]
["л",4,"1000",{"$f":"LEN(C3)*B3","v":16},null,"у",4,4,"н",null,"у",4,null,"в",2,3,"д",null,"в",2,null,null,null,2,"р",null,"р",2,null,null,null,1,"ь",null,null,null,null,"д",3,null,"с",3,3,"з",null,"с",3,null,null,1,"ш",null,null,null,null,"з",3,null,"й",1,1,"ж"]
["н",4,"1100",16,null,"д",3,4,"о",null,"д",3,null,"р",2,3,"з",null,"р",2,null,null,null,1,"ь",null,"ь",1,null,null,null,null,null,null,null,null,null,"з",3,null,"ш",1,1,"ж",null,"ш",1,null,null,null,null,null,null,null,null,"ж",1]
["о",4,"1110",16,null,"з",3,4,"ы",null,"з",3,null,"ь",1,3,"с",null,"ь",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"с",3,null,null,null,1,"й",null,null,null,null,null,null,null,null,null,null,null,"й",1]
["у",4,"0100",16,null,"с",3,3,"е",null,"с",3,null,null,null,1,"ж",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ж",1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AW2:AW5)","v":4},{"$f":"SUM(AX2:AX5)","v":4}]
["ы",4,"1010",16,null,"в",2,3,"и",null,"в",2,null,null,null,1,"й",null,null,null,null,null,{"$f":"SUM(W2:W6)","v":11},{"$f":"SUM(X2:X6)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,"й",1]
["д",3,"01100",15,null,"р",2,3,"ю",null,"р",2,null,null,null,1,"ш",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ш",1,null,null,{"$f":"SUM(AP2:AP7)","v":8},{"$f":"SUM(AQ2:AQ7)","v":8}]
["е",3,"10110",15,null,"ж",1,2,"м",null,"ж",1]
["з",3,"01110",15,null,"й",1,1,"а",null,"й",1]
["и",3,"11110",15,null,"ш",1,1,"б",null,"ш",1]
["с",3,"0100",12,null,"ь",1,1,"п",null,"ь",1]
["ю",3,"11010",15,null,null,null,1,"т"]
["в",2,"0010",8,null,null,null,1,"я",null,null,null,null,null,{"$f":"SUM(O2:O13)","v":16},{"$f":"SUM(P2:P13)","v":16}]
["м",2,"10010",10]
["р",2,"00110",10,null,null,{"$f":"SUM(G2:G15)","v":32},{"$f":"SUM(H2:H15)","v":32},null,null,null,null,null,0,null,null,1,null,null,null,null,0,null,null,1,null,null,null,null,0,null,null,1,null,null,null,null,0,null,null,1,null,0,1,null,0,null,null,1,null,0,1,null,null,null,null,0,null,null,1,null,0,1,null,0,1,null,0,1,null,0,1]
["а",1,"100110",6,null,null,null,null,null,null,"л",4,null,"л",4,4,"н",null,"л",4,null,"л",4,4,"ы",null,"л",4,null,"л",4,2,"м",null,"м",2,null,"м",2,1,"а",null,"а","б",null,"ы",4,3,"е",null,"е","я",null,"н",4,null,"н",4,4,"о",null,"н","ю",null,"ю","п",null,"о","и",null,"и","т"]
["б",1,"100111",6,null,null,null,null,null,null,"н",4,null,"ы",4,4,"о",null,"ы",4,null,"м",2,3,"е",null,"м",2,null,null,null,1,"а",null,"а",1,null,null,null,1,"б",null,null,null,null,null,null,1,"я",null,null,null,null,"о",4,null,"ю",3,3,"и",null,null,"п",null,null,null,null,null,"т"]
["ж",1,"01111",5,null,null,null,null,null,null,"о",4,null,"е",3,3,"и",null,"е",3,null,"а",1,1,"я",null,"а",1,null,null,null,1,"б",null,"б",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"и",3,null,"п",1,1,"т"]
["й",1,"01101",5,null,null,null,null,null,null,"ы",4,null,"м",2,3,"ю",null,"м",2,null,"б",1,null,null,null,"б",1,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,"ю",3]
["п",1,"11011",5,null,null,null,null,null,null,"е",3,null,"а",1,1,"п",null,"а",1,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,null,null,"п",1]
["т",1,"11111",5,null,null,null,null,null,null,"и",3,null,"б",1,1,"т",null,"б",1,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,null,null,"т",1]
["ш",1,"01011",5,null,null,null,null,null,null,"ю",3,null,"я",1,null,null,null,"я",1]
["ь",1,"00111",5,null,null,null,null,null,null,"м",2,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W17:W23)","v":8},{"$f":"SUM(X17:X23)","v":8}]
["я",1,"10111",5,null,null,null,null,null,null,"а",1]
[null,null,null,{"$f":"SUM(D2:D25)","v":275},null,null,null,null,null,null,"б",1]
[null,null,null,null,null,null,null,null,null,null,"п",1]
[null,null,null,null,null,null,null,null,null,null,"т",1]
[null,null,null,null,null,null,null,null,null,null,"я",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O17:O29)","v":16},{"$f":"SUM(P17:P29)","v":16}]

{"sheet":"1","index":2,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[" ",11," ","000",3,11,{"$f":"E1*F1","v":33},"100",{"$f":"LEN(H1)*F1","v":33},null,"N=",64,"Iх=",{"$f":"CEILING(L1*LOG(L2,2),1)","v":294}]
["л",4,"м","0010",4,2,{"$f":"E2*F2","v":8},"0000",{"$f":"LEN(H2)*F2","v":8},null,"M=",24,"Iш=",{"$f":"CEILING(11*LOG(64/11,2)+20*LOG(64/4,2)+18*LOG(64/3,2)+6*LOG(64/2,2)+9*LOG(64,2),1)","v":272}]
["н",4,"у","0100",4,4,16,"0001",16]
["о",4,"л","1000",4,4,16,"0010",16]
["у",4,"ы","1010",4,4,16,"0011",16]
["ы",4,"н","1100",4,4,16,"1010",16]
["д",3,"о","1110",4,4,16,"10110",20]
["з",3,"р","00110",5,2,10,"10111",10]
["и",3,"ь","00111",5,1,5,"0100",4]
["с",3,"ю","01010",5,3,15,"0101",12]
["ю",3,"ш","01011",5,1,5,"0110",4]
["в",2,"д","01100",5,3,15,"0111",12]
["е",2,"й","01101",5,1,5,"11000",5]
["м",2,"и","01110",5,3,15,"11001",15]
["р",2,"ж","01111",5,1,5,"11010",5]
["ё",1,"е","10010",5,2,10,"11011",10]
["а",1,"з","10110",5,3,15,"111000",18]
["б",1,"т","10111",5,1,5,"111001",6]
["ж",1,"в","11010",5,2,10,"111010",12]
["й",1,"с","11110",5,3,15,"111011",18]
["п",1,"я",11111,5,1,5,"111100",6]
["т",1,"ё","100110",6,1,6,"111101",6]
["ш",1,"п","100111",6,1,6,"111110",6]
["ь",1,"а","110110",6,1,6,"111111",6]
["я",1,"б",110111,6,1,{"$f":"SUM(G1:G24)","v":274},null,{"$f":"SUM(I1:I24)","v":280}]

{"sheet":"2","index":3,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[" ",8," ","000",3,8,{"$f":"E1*F1","v":24},"000",{"$f":"LEN(H1)*F1","v":24},null,"N=",64,"Iх=",{"$f":"CEILING(L1*LOG(L2,2),1)","v":294}]
["о",7,"о","1000",4,7,{"$f":"E2*F2","v":28},"010",{"$f":"LEN(H2)*F2","v":21},null,"M=",24,"Iш=",{"$f":"CEILING(8*LOG(64/8,2)+7*LOG(64/7,2)+16*LOG(64/4,2)+12*LOG(64/3)+14*LOG(64/2,2)+7*LOG(64,2),1)","v":239}]
["а",4,"а","1100",4,4,16,"0010",16]
["в",4,"в","0100",4,4,16,"0011",16]
["е",4,"е","1110",4,4,16,"1000",16]
["у",4,"у","0110",4,4,16,"1001",16]
["д",3,"д","10100",5,3,15,"0110",12]
["л",3,"л","01110",5,3,15,"0111",12]
["н",3,"н","11110",5,3,15,"10100",15]
["я",3,"я","00100",5,3,15,"10101",15]
[",",2,",","10110",5,2,10,"11000",10]
["г",2,"г","00110",5,2,10,"11001",10]
["з",2,"з","11010",5,2,10,"11010",10]
["м",2,"м","01010",5,2,10,"11011",10]
["р",2,"р","10111",5,2,10,"11100",10]
["с",2,"с","01011",5,2,10,"11101",10]
["т",2,"т","11011",5,2,10,"101100",12]
["ж",1,"ж","001110",6,1,6,"101101",6]
["и",1,"и","001111",6,1,6,"101110",6]
["к",1,"к","10101",5,1,5,"101111",6]
["п",1,"п","1001",4,1,4,"111100",6]
["х",1,"х","00101",5,1,5,"111101",6]
["ш",1,"ш","01111",5,1,5,"111110",6]
["щ",1,"щ","11111",5,1,5,"111111",6]
[null,{"$f":"SUM(B1:B24)","v":64},null,null,null,{"$f":"SUM(F1:F24)","v":64},{"$f":"SUM(G1:G24)","v":282},null,{"$f":"SUM(I1:I24)","v":277}]

{"sheet":"3","index":4,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["о",11,"о","000",3,11,{"$f":"E1*F1","v":33},"000",{"$f":"LEN(H1)*F1","v":33},null,"N=",64,"Iх=",{"$f":"CEILING(L1*LOG(L2,2),1)","v":286}]
[" ",9," ","100",3,9,{"$f":"E2*F2","v":27},"010",{"$f":"LEN(H2)*F2","v":27},null,"M=",22,"Iш=",{"$f":"CEILING(11*LOG(64/11,2)+9*LOG(64/9,2)+10*LOG(64/5,2)+4*LOG(64/4,2)+9*LOG(64/3,2)+14*LOG(64/2,2)+7*LOG(64,2),1)","v":258}]
["к",5,"к","1100",4,5,20,"0010",20]
["с",5,"с","0100",4,5,20,"0011",20]
["п",4,"п","1110",4,4,16,"1000",16]
["а",3,"а","01100",5,3,15,"1001",12]
["л",3,"л","11110",5,3,15,"1100",12]
["т",3,"т","01110",5,3,15,"1101",12]
["в",2,"в","10100",5,2,10,"01100",10]
["е",2,"е","01010",5,2,10,"01101",10]
["и",2,"и","10110",5,2,10,"01110",10]
["й",2,"й","0010",4,2,8,"01111",10]
["м",2,"м","11010",5,2,10,"10100",10]
["р",2,"р","00110",5,2,10,"10101",10]
["я",2,"я","10111",5,2,10,"11100",10]
[",",1,"-","01101",5,1,5,"11101",5]
["-",1,",","01111",5,1,5,"11110",5]
["г",1,"г","11011",5,1,5,"11111",5]
["ж",1,"ж","11111",5,1,5,"101100",6]
["н",1,"н","01011",5,1,5,"101101",6]
["ы",1,"ы","00111",5,1,5,"101110",6]
["ь",1,"ь","10101",5,1,5,"101111",6]
[null,{"$f":"SUM(B1:B22)","v":64},null,null,null,{"$f":"SUM(F1:F22)","v":64},{"$f":"SUM(G1:G22)","v":264},null,{"$f":"SUM(I1:I22)","v":261}]

{"sheet":"4","index":5,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[" ",10," ","000",3,10,{"$f":"E1*F1","v":30},"000",{"$f":"LEN(H1)*F1","v":30},null,"N=",64,"Iх=",{"$f":"CEILING(L1*LOG(L2,2),1)","v":282}]
["е",7,"и","0100",4,4,{"$f":"E2*F2","v":16},"001",{"$f":"LEN(H2)*F2","v":12},null,"M=",21,"Iш=",{"$f":"CEILING(10*LOG(64/10,2)+9*LOG(64/9,2)+5*LOG(64/5,2)+12*LOG(64/4,2)+9*LOG(64/3,2)+14*LOG(64/2,2)+5*LOG(64,2),1)","v":259}]
["л",5,"т","0110",4,4,16,"0100",16]
["и",4,"е","1000",4,7,28,"0101",28]
["к",4,"ы","1001",4,1,4,"0110",4]
["т",4,"л","1100",4,5,20,"0111",20]
[",",3,"к","1110",4,4,16,"1000",16]
["ж",3,"с","1111",4,3,12,"1001",12]
["с",3,"ё","00100",5,2,10,"1010",8]
["ё",2,"р","00101",5,1,5,"11000",5]
["а",2,"о","00110",5,2,10,"11001",10]
["в",2,"б","00111",5,1,5,"11010",5]
["н",2,"в","01010",5,2,10,"11011",10]
["о",2,"у","01011",5,2,10,"11100",10]
["п",2,"ж","01110",5,3,15,"11101",15]
["у",2,"я","01111",5,1,5,"10110",5]
["ь",2,",","10100",5,3,15,"10111",15]
["б",1,"щ","10101",5,1,5,"111100",6]
["р",1,"а","10110",5,2,10,"111101",12]
["щ",1,"н","10111",5,2,10,"111110",12]
["ы",1,"п","11010",5,2,10,"111111",12]
["я",1,"ь","11011",5,2,{"$f":"SUM(G1:G21)","v":262},"111101",{"$f":"SUM(I1:I21)","v":263}]
[null,null,null,null,null,2]
[null,null,null,null,null,1]
[null,null,null,null,null,1]

{"sheet":"5","index":6,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["о",10,"о","000",3,10,{"$f":"E1*F1","v":30},"000",{"$f":"LEN(H1)*F1","v":30},null,"N=",64,"Iх=",{"$f":"CEILING(L1*LOG(L2,2),1)","v":294}]
[" ",9," ","100",3,9,{"$f":"E2*F2","v":27},"001",{"$f":"LEN(H2)*F2","v":27},null,"M=",24,"Iш=",{"$f":"CEILING(10*LOG(64/10,2)+9*LOG(64/9,2)+5*LOG(64/5,2)+8*LOG(64/4,2)+12*LOG(64/3,2)+10*LOG(64/2,2)+10*LOG(64,2),1)","v":266}]
["н",5,"н","1100",4,5,20,"0100",20]
["д",4,"д","0100",4,4,16,"0101",16]
["с",4,"с","0110",4,4,16,"0110",16]
[",",3,",","11100",5,3,15,"1000",12]
["в",3,"в","11110",5,3,15,"1001",12]
["м",3,"м","01110",5,3,15,"1010",12]
["п",3,"п","1010",4,3,12,"1011",12]
["а",2,"а","00100",5,2,10,"01110",10]
["е",2,"е","01010",5,2,10,"01111",10]
["и",2,"и","11010",5,2,10,"11000",10]
["й",2,"й","10110",5,2,10,"11001",10]
["ы",2,"ы","00110",5,2,10,"11010",10]
["г",1,"г","010110",6,1,6,"110110",6]
["з",1,"з","11111",5,1,5,"110111",6]
["л",1,"л","11101",5,1,5,"111000",6]
["р",1,"р","010111",6,1,6,"111001",6]
["т",1,"т","00111",5,1,5,"111010",6]
["у",1,"у","101110",6,1,6,"111011",6]
["х",1,"х","101111",6,1,6,"111100",6]
["ч",1,"ч","00101",5,1,5,"111101",6]
["ш",1,"ш","01111",5,1,5,"111110",6]
["ь",1,"ь","11011",5,1,5,"111111",6]
[null,{"$f":"SUM(B1:B24)","v":64},null,null,null,{"$f":"SUM(F1:F24)","v":64},{"$f":"SUM(G1:G24)","v":270},null,{"$f":"SUM(I1:I24)","v":267}]

{"sheet":"6","index":7,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[" ",10," ","000",3,10,{"$f":"E1*F1","v":30},"000",{"$f":"LEN(H1)*F1","v":30},null,"N=",64,"Iх=",{"$f":"CEILING(L1*LOG(L2,2),1)","v":282}]
["и",8,"о","010",3,8,{"$f":"E2*F2","v":24},"001",{"$f":"LEN(H2)*F2","v":24},null,"M=",21,"Iш=",{"$f":"CEILING(10*LOG(64/10,2)+24*LOG(64/8,2)+8*LOG(64/4,2)+16*LOG(64/2,2)+6*LOG(64,2),1)","v":247}]
["л",8,"и","100",3,8,24,"010",24]
["о",8,"л","110",3,8,24,"011",24]
["м",4,"м","1110",4,4,16,"1000",16]
["е",3,"г","00100",5,2,10,"1001",8]
["б",2,"д","00101",5,1,5,"1010",4]
["г",2,"р","00110",5,2,10,"10110",10]
["з",2,"в","00111",5,1,5,"10111",5,null,{"$f":"3*LOG(64/3,2)","v":13.245112497836532}]
["к",2,"е","01100",5,3,15,"11000",15]
["н",2,"ц","01101",5,1,5,"11001",5]
["р",2,"к","01110",5,2,10,"11010",10]
["с",2,"я","01111",5,2,10,"11011",10]
["я",2,"б","10100",5,2,10,"11100",10]
[",",1,"з","10110",5,2,10,"111010",12]
["ё",1,"н","10111",5,2,10,"111011",12]
["в",1,"с","11110",5,2,10,"111100",12]
["д",1,"ё","101010",6,1,6,"111101",6]
["ж",1,"ж","101011",6,1,6,"111110",6]
["й",1,",","111110",6,1,6,"111111",6]
["ц",1,"й","111111",6,1,6,"111112",6]
[null,null,null,null,null,{"$f":"SUM(F1:F21)","v":64},{"$f":"SUM(G1:G21)","v":252},null,{"$f":"SUM(I1:I21)","v":255}]

{"sheet":"7","index":8,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[" ",9," ","000",3,9,{"$f":"E1*F1","v":27},"100",{"$f":"LEN(H1)*F1","v":27},null,"N=",64,"Iх=",{"$f":"CEILING(L1*LOG(L2,2),1)","v":282}]
["н",6,"н","1000",4,6,{"$f":"E2*F2","v":24},"1010",{"$f":"LEN(H2)*F2","v":24},null,"M=",21,"Iш=",{"$f":"CEILING(9*LOG(64/9,2)+12*LOG(64/6,2)+12*LOG(64/4,2)+15*LOG(64/3,2)+12*LOG(64/2,2)+4*LOG(64,2),1)","v":265}]
["о",6,"о","1100",4,6,24,"1011",24]
["а",4,"а","0100",4,4,16,"0000",16]
["е",4,"е","1110",4,4,16,"0001",16]
["с",4,"с","0110",4,4,16,"0010",16]
["д",3,"д","1010",4,3,12,"0011",12]
["з",3,"з","01110",5,3,15,"0100",12]
["р",3,"р","10110",5,3,15,"0101",12]
["т",3,"т","0010",4,3,12,"0110",12]
["у",3,"у","11110",5,3,15,"0111",12]
["!",2,"!","01010",5,2,10,"11000",10]
["б",2,"б","00110",5,2,10,"11001",10]
["и",2,"и","10111",5,2,10,"11010",10]
["й",2,"й","1101",4,2,8,"11011",10]
["ч",2,"ч","01011",5,2,10,"11100",10]
["ю",2,"ю","00111",5,2,10,"11101",10]
["в",1,"в","10010",5,1,5,"111100",6]
["к",1,"к","10011",5,1,5,"111101",6]
["л",1,"л","11111",5,1,5,"111110",6]
["ы",1,"ы","01111",5,1,5,"111111",6]
[null,{"$f":"SUM(B1:B21)","v":64},null,null,null,{"$f":"SUM(F1:F21)","v":64},{"$f":"SUM(G1:G21)","v":270},null,{"$f":"SUM(I1:I21)","v":267}]

{"sheet":"8","index":9,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[" ",10," ","000",3,10,{"$f":"E1*F1","v":30},"100",{"$f":"LEN(H1)*F1","v":30},null,"N=",64,"Iх=",{"$f":"CEILING(L1*LOG(L2,2),1)","v":298}]
["е",6,"е","1000",4,6,{"$f":"E2*F2","v":24},"000",{"$f":"LEN(H2)*F2","v":18},null,"M=",25,"Iш=",{"$f":"CEILING(10*LOG(64/10,2)+12*LOG(64/6,2)+12*LOG(64/4,2)+6*LOG(64/3,2)+14*LOG(64/2,2)+10*LOG(64,2),1)","v":273}]
["о",6,"о","1100",4,6,24,"001",18]
["н",4,"н","0100",4,4,16,"0100",16]
["с",4,"с","1110",4,4,16,"0101",16]
["т",4,"т","0110",4,4,16,"1010",16]
["в",3,"в","10100",5,3,15,"10110",15]
["у",3,"у","01110",5,3,15,"10111",15]
[",",2,",","10110",5,2,10,"01100",10]
["г",2,"г","11110",5,2,10,"01101",10]
["д",2,"д","00100",5,2,10,"01110",10]
["и",2,"и","01010",5,2,10,"01111",10]
["л",2,"л","10111",5,2,10,"11000",10]
["п",2,"п","11111",5,2,10,"11001",10]
["ы",2,"ы","00110",5,2,10,"11010",10]
["!",1,"!","010110",6,1,6,"110110",6]
["ё",1,"ё","10010",5,1,5,"110111",6]
["ж",1,"ж","10011",5,1,5,"111000",6]
["з",1,"з","010111",6,1,6,"111001",6]
["р",1,"р","00111",5,1,5,"111010",6]
["ч",1,"ч","11010",5,1,5,"111011",6]
["ш",1,"ш","11011",5,1,5,"111100",6]
["ь",1,"ь","00101",5,1,5,"111101",6]
["э",1,"э","01111",5,1,5,"111110",6]
["ю",1,"ю","10101",5,1,5,"111111",6]
[null,{"$f":"SUM(B1:B25)","v":64},null,null,null,{"$f":"SUM(F1:F25)","v":64},{"$f":"SUM(G1:G25)","v":278},null,{"$f":"SUM(I1:I25)","v":274}]

{"sheet":"Лист3","index":10,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["-"]
[" "]
["!"]
[","]
["а"]
["б"]
["в"]
["г"]
["д"]
["е"]
["ё"]
["ж"]
["з"]
["и"]
["й"]
["к"]
["л"]
["м"]
["н"]
["о"]
["п"]
["р"]
["с"]
["т"]
["у"]
["х"]
["ц"]
["ч"]
["ш"]
["щ"]
["ы"]
["ь"]
["э"]
["ю"]
["я"]

{"sheet":"Лист4","index":11,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,18,0,19],[0,21,0,22],[0,0,0,1],[0,3,0,4],[0,6,0,7],[0,9,0,10],[0,12,0,13],[0,15,0,16]]}
[1,null,null,2,null,null,3,null,null,4,null,null,5,null,null,6,null,null,7,null,null,8]
[" ",11,null," ",8,null,"о",11,null," ",10,null,"о",10,null," ",10,null," ",9,null," ",10]
["л",4,null,"о",7,null," ",9,null,"е",7,null," ",9,null,"и",8,null,"н",6,null,"е",6]
["н",4,null,"а",4,null,"к",5,null,"л",5,null,"н",5,null,"л",8,null,"о",6,null,"о",6]
["о",4,null,"в",4,null,"с",5,null,"и",4,null,"д",4,null,"о",8,null,"а",4,null,"н",4]
["у",4,null,"е",4,null,"п",4,null,"к",4,null,"с",4,null,"м",4,null,"е",4,null,"с",4]
["ы",4,null,"у",4,null,"а",3,null,"т",4,null,",",3,null,"е",3,null,"с",4,null,"т",4]
["д",3,null,"д",3,null,"л",3,null,",",3,null,"в",3,null,"б",2,null,"д",3,null,"в",3]
["з",3,null,"л",3,null,"т",3,null,"ж",3,null,"м",3,null,"г",2,null,"з",3,null,"у",3]
["и",3,null,"н",3,null,"в",2,null,"с",3,null,"п",3,null,"з",2,null,"р",3,null,",",2]
["с",3,null,"я",3,null,"е",2,null,"а",2,null,"а",2,null,"к",2,null,"т",3,null,"г",2]
["ю",3,null,",",2,null,"и",2,null,"в",2,null,"е",2,null,"н",2,null,"у",3,null,"д",2]
["в",2,null,"г",2,null,"й",2,null,"ё",2,null,"и",2,null,"р",2,null,"!",2,null,"и",2]
["е",2,null,"з",2,null,"м",2,null,"н",2,null,"й",2,null,"с",2,null,"б",2,null,"л",2]
["м",2,null,"м",2,null,"р",2,null,"о",2,null,"ы",2,null,"я",2,null,"и",2,null,"п",2]
["р",2,null,"р",2,null,"я",2,null,"п",2,null,"г",1,null,",",1,null,"й",2,null,"ы",2]
["а",1,null,"с",2,null,",",1,null,"у",2,null,"з",1,null,"в",1,null,"ч",2,null,"!",1]
["б",1,null,"т",2,null,"-",1,null,"ь",2,null,"л",1,null,"д",1,null,"ю",2,null,"ё",1]
["ё",1,null,"ж",1,null,"г",1,null,"б",1,null,"р",1,null,"ё",1,null,"в",1,null,"ж",1]
["ж",1,null,"и",1,null,"ж",1,null,"р",1,null,"т",1,null,"ж",1,null,"к",1,null,"з",1]
["й",1,null,"к",1,null,"н",1,null,"щ",1,null,"у",1,null,"й",1,null,"л",1,null,"р",1]
["п",1,null,"п",1,null,"ы",1,null,"ы",1,null,"х",1,null,"ц",1,null,"ы",1,null,"ч",1]
["т",1,null,"х",1,null,"ь",1,null,"я",1,null,"ч",1,null,null,null,null,null,null,null,"ш",1]
["ш",1,null,"ш",1,null,null,null,null,null,null,null,"ш",1,null,null,null,null,null,null,null,"ь",1]
["ь",1,null,"щ",1,null,null,null,null,null,null,null,"ь",1,null,null,null,null,null,null,null,"э",1]
["я",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ю",1]

{"sheet":"Лист5","index":12,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[2]
[" ",8,"000",24]
["о",7,"010",21]
["а",4,"0010",16]
["в",4,"0011",16]
["е",4,"1000",16]
["у",4,"1001",16]
["д",3,"0110",12]
["л",3,"0111",12]
["н",3,"10100",15]
["я",3,"10101",15]
[",",2,"11000",10]
["г",2,"11001",10]
["з",2,"11010",10]
["м",2,"11011",10]
["р",2,"11100",10]
["с",2,"11101",10]
["т",2,"101100",12]
["ж",1,"101101",6]
["и",1,"101110",6]
["к",1,"101111",6]
["п",1,"111100",6]
["х",1,"111101",6]
["ш",1,"111110",6]
["щ",1,"111111",6]
[null,null,null,{"$f":"SUM(D2:D25)","v":277}]

{"sheet":"Лист6","index":13,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[3]
["о",11,"00",22]
[" ",9,"100",27]
["к",5,"1100",20]
["с",5,"1101",20]
["п",4,"0100",16]
["а",3,"0101",12]
["л",3,"11100",15]
["т",3,"11101",15]
["в",2,"10100",10]
["е",2,"10101",10]
["и",2,"01100",10]
["й",2,"01101",10]
["м",2,"01110",10]
["р",2,"01111",10]
["я",2,"111100",12]
[",",1,"111101",6]
["-",1,"111110",6]
["г",1,"111111",6]
["ж",1,"101100",6]
["н",1,"101101",6]
["ы",1,"101110",6]
["ь",1,"101111",6]
[null,null,null,{"$f":"SUM(D2:D23)","v":261}]