{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Лист1","Рис. 4","Лист2","Лист3","Лист4","Рис. 7","Рис. 8"],"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":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Эта рабочая книга содержит ряд полезных функций рабочего листа:"]
["IsBold",{"$f":"isbold(A2)","v":true},null,null,null,null,null,{"$f":"MAXALLSHEETS(J2)","v":15},null,5]
["IsBold",{"$f":"isbold(A3)","v":false},"условное форматирование"]
["IsItalic",{"$f":"isitalic(A4)","v":true}]
["AllBold",{"$f":"Allbold(A5)","v":false}]
["FillColor",{"$f":"fillcolor(A6)","v":20}]
["SayIt",{"$f":"IF(C7=7,sayit(\"Значение ячейки C6 равно семи\"))","v":"Значение ячейки C6 равно семи"},{"$f":"RANDBETWEEN(1,10)","v":7}]
["LastSaved",{"$f":"lastsaved()","v":"2017-03-28T16:30:15"}]
["LastPrinted",{"$f":"lastprinted()","v":"2006-08-24T22:27:14"}]
["SheetName",{"$f":"sheetname(A1)","v":"Лист1"}]
["WorkbookName",{"$f":"workbookname(A1)","v":"Функции рабочих листов.xlsm"}]
["AppName",{"$f":"appname(A1)","v":"Microsoft Excel"}]
["CountBetween",{"$f":"countbetween(A17:A27,2,5)","v":5},{"$f":"countbetween(A17:A27,5,2)","v":5}]
["LastInColumn",{"$f":"lastincolumn(E1)","v":999}]
["LastInRow",{"$f":"lastinrow(A17)","v":999}]
[]
[0,null,null,null,999]
[1]
[2]
[4]
[3]
[2]
[6]
[8]
[9]
[10]
[3]
["IsLike",{"$f":"ISLIKE(A1,\"*workbook*\")","v":false}]
["ExtractElement",{"$f":"extractelement(\"123-456-789\",2,\"-\")","v":"456"}]
["ExtractElement2",{"$f":"extractelement2(\"123-456-789\",2,\"-\")","v":"456"}]
["SpellDollars",{"$f":"spelldollars(B33)","v":"Пять и 20/100 долларов"}]
["StatFunction",{"$f":"StatFunction($A$33:$A$37,C32)","v":26},"СУММ"]
[5,{"$f":"StatFunction($A$33:$A$37,C33)","v":5.2},"СРЗНАЧ"]
[4,4,"МЕДИАНА"]
[11,3,"МОДА"]
[3,{"$f":"StatFunction($A$33:$A$37,C36)","v":5},"СЧЁТ"]
[3,11,"МАКС"]
[null,3,"МИН"]
[null,11.200000000000003,"ДИСП"]
[null,3.3466401061363027,"СТАНДОТКЛОН"]
["SheetOffset",{"$f":"SheetOffset(2,A1)","v":123}]
["MaxAllSheets",{"$f":"MAXALLSHEETS((A1))","v":246}]
["RandomIntegers",{"$f":"RandomIntegers()","v":4}]
[null,2]
[null,3]
[null,1]
["RangeRandomize",{"$f":"RangeRandomize(A33:A37)","v":3}]
[null,3]
[null,4]
[null,5]
[null,11]

{"sheet":"Рис. 4","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[23.45,{"$f":"spelldollars(A1)","v":"Двадцать-Три и 45/100 долларов"}]
[32,{"$f":"spelldollars(A2)","v":"Тридцать-Два и 00/100 долларов"},null,null,null,null,null,null,7]
[37.56,"Тридцать-Семь и 56/100 долларов"]
[-32,"(Тридцать-Два и 00/100 долларов)"]
[-26.44,"(Двадцать-Шесть и 44/100 долларов)"]
[1.8754,"Один и 88/100 долларов"]
[1000000,"Один Миллион и 00/100 долларов"]
[1000000000,"Один Миллиард и 00/100 долларов"]

{"sheet":"Лист2","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"SheetOffset(1,A1)/2","v":123}]
[null,null,null,null,null,null,null,null,null,9]

{"sheet":"Лист3","index":3,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[246]
[null,null,null,null,null,null,null,null,null,11]

{"sheet":"Лист4","index":4,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Title"]
["Subject",null,null,null,null,null,null,null,null,15]
["Author"]
["Keywords"]
["Comments"]
["Template"]
["Last author"]
["Revision number"]
["Application name"]
["Last print date"]
["Creation date"]
["Last save time"]
["Total editing time"]
["Number of pages"]
["Number of words"]
["Number of characters"]
["Security"]
["Category"]
["Format"]
["Manager"]
["Company"]
["Number of bytes"]
["Number of lines"]
["Number of paragraphs"]
["Number of slides"]
["Number of notes"]
["Number of hidden Slides"]
["Number of multimedia clips"]
["Hyperlink base"]
["Number of characters (with spaces)"]
["Content type"]
["Content status"]
["Language"]
["Document version"]

{"sheet":"Рис. 7","index":5,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RandomIntegers()","v":23},null,null,null,null,null,{"$f":"SMALL($A$1:$A$35,ROW())","v":1}]
[35,null,null,null,null,null,{"$f":"SMALL($A$1:$A$35,ROW())","v":2}]
[8,null,null,null,null,null,3]
[30,null,null,null,null,null,4]
[25,null,null,null,null,null,5]
[15,null,null,null,null,null,6]
[22,null,null,null,null,null,7]
[21,null,null,null,null,null,8]
[4,null,null,null,null,null,9]
[27,null,null,null,null,null,10]
[20,null,null,null,null,null,11]
[6,null,null,null,null,null,12]
[9,null,null,null,null,null,13]
[13,null,null,null,null,null,14]
[29,null,null,null,null,null,15]
[17,null,null,null,null,null,16]
[5,null,null,null,null,null,17]
[14,null,null,null,null,null,18]
[24,null,null,null,null,null,19]
[12,null,null,null,null,null,20]
[10,null,null,null,null,null,21]
[26,null,null,null,null,null,22]
[33,null,null,null,null,null,23]
[16,null,null,null,null,null,24]
[1,null,null,null,null,null,25]
[18,null,null,null,null,null,26]
[31,null,null,null,null,null,27]
[7,null,null,null,null,null,28]
[2,null,null,null,null,null,29]
[32,null,null,null,null,null,30]
[34,null,null,null,null,null,31]
[11,null,null,null,null,null,32]
[28,null,null,null,null,null,33]
[19,null,null,null,null,null,34]
[3,null,null,null,null,null,35]

{"sheet":"Рис. 8","index":6,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Алфавитный порядок","Случайный порядок"]
["Гиппопотам",{"$f":"RangeRandomize(A2:A13)","v":"Игуана"}]
["Жираф","Гиппопотам"]
["Игуана","Жираф"]
["Кенгуру","Лемур"]
["Кошка","Слон"]
["Лев","Лисица"]
["Лемур","Кошка"]
["Лисица","Лев"]
["Павиан","Кенгуру"]
["Попугай","Павиан"]
["Слон","Попугай"]
["Собака","Собака"]