{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["сводная таблица"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"сводная таблица","index":0,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,11,4,11],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,8],[3,9,4,9],[3,10,4,10]]}
[]
[]
[null,null,null,null,null,"сентябрь",2014]
[null,null,"дата","Дежурный №1","Пом. Дежурного",null,null,null,null,"ответственные","Дежурный №2","Пом.Дежурного"]
[null,null,null,null,null,3,4,5,5,null,null,null,null,null,null,"дежурный №1","Ранг","список фамилий дежурных",null,"Дежурный №2","Ранг","Список фамилий дежурных",null,null,"январь",{"$f":"TODAY()","v":"2014-09-14"},2014]
[null,null,"1\n",{"$f":"IF(R11=0,R8,R11)","v":"Дрочер"},null,null,null,null,null,null,{"$f":"INDEX($V$6:$V$35,U6)","v":"DFBGFH"},null,null,null,null,{"$f":"RAND()","v":0.85612706656486914},{"$f":"RANK(P6,$P$6:$P$35)","v":5},"Ветеран",null,{"$f":"RAND()","v":0.76640703113917064},{"$f":"RANK(T6,$T$6:$T$35)","v":9},"QWER",null,null,"февраль",{"$f":"MONTH(Z5)","v":9},2015]
[null,null,2,{"$f":"IF(R10=0,R6,R10)","v":"Зевс"},null,null,null,null,null,null,{"$f":"INDEX($V$6:$V$35,U7)","v":"DDF"},null,null,null,null,{"$f":"RAND()","v":1.2603241543443389E-2},{"$f":"RANK(P7,$P$6:$P$35)","v":30},"Наташа",null,{"$f":"RAND()","v":0.61908696693312038},{"$f":"RANK(T7,$T$6:$T$35)","v":15},"POIU",null,null,"март",{"$f":"YEAR(Z5)","v":2014},2016]
[null,null,3,{"$f":"IF(R9=0,R7,R9)","v":"Игорь"},null,null,null,null,null,null,"HJIKKK,",null,null,null,null,0.36573949001421691,15,"Коля",null,0.5024974988984694,19,"CVBN",null,null,"апрель",null,2017]
[null,null,4,{"$f":"IF(R14=0,R8,R14)","v":"Коля"},null,null,null,null,null,null,"GHJYJMJKKU",null,null,null,null,0.52024227000474133,10,"Игорь",null,0.77621964405239252,8,"ADGFH",null,null,"май",null,2018]
[null,null,5,{"$f":"IF(R15=0,R7,R15)","v":"Наташа"},null,null,null,null,null,null,"VBNMJ",null,null,null,null,0.61069489560409962,9,"Зевс",null,0.2403146534322782,26,"LNRY",null,null,"июнь",null,2019]
[null,null,6,{"$f":"IF(R16=0,R6,IF(R6=0,R7,IF(R7=0,R8,R16)))","v":"Ветеран"},null,null,null,null,null,null,"CGBNMMMKHF",null,null,null,null,0.25375200745882032,20,"Дрочер",null,0.28952591154550256,25,"UILSDGH",null,null,"июль",null,2020]
[null,null,7,{"$f":"IF(R11=0,R8,R11)","v":"Дрочер"},null,null,null,null,null,null,"LNRY",null,null,null,null,0.88848982553911293,3,null,null,0.89840118697796834,5,"FFA",null,null,"август",null,2021]
[null,null,8,{"$f":"IF(R10=0,R6,R10)","v":"Зевс"},null,null,null,null,null,null,"HNJ",null,null,null,null,0.99131194536071943,1,null,null,0.54998471756949152,18,"GHJYJMJKKU",null,null,"сентябрь",null,2022]
[null,null,9,{"$f":"IF(R9=0,R7,R9)","v":"Игорь"},null,null,null,null,null,null,"POIU",null,null,null,null,2.7503021655410187E-2,29,null,null,0.98513210513782967,2,"DFBGFH",null,null,"октябрь",null,2023]
[null,null,10,{"$f":"IF(R14=0,R8,R14)","v":"Коля"},null,null,null,null,null,null,"BGF",null,null,null,null,0.18574510870094163,22,null,null,0.75063128853949512,10,"BGF",null,null,"ноябрь",null,2024]
[null,null,11,{"$f":"IF(R15=0,R7,R15)","v":"Наташа"},null,null,null,null,null,null,"FFA",null,null,null,null,0.62295758507611909,8,null,null,0.79625836441237885,7,"HMNJMJJKK",null,null,"декабрь",null,2025]
[null,null,12,{"$f":"IF(R16=0,R6,R16)","v":"Ветеран"},null,null,null,null,null,null,"QWFHJIK",null,null,null,null,0.46036514433942144,12,null,null,0.65763958257467225,14,"FGF"]
[null,null,13,{"$f":"IF(R11=0,R8,R11)","v":"Дрочер"},null,null,null,null,null,null,"ADGFH",null,null,null,null,0.84245849096034386,6,null,null,0.90555069364807839,4,"SDSGSFHFH"]
[null,null,14,{"$f":"IF(R10=0,R6,R10)","v":"Зевс"},null,null,null,null,null,null,"BBHMM",null,null,null,null,0.15755295320483964,25,null,null,0.13354617399408786,28,"QWFHJIK"]
[null,null,15,{"$f":"IF(R9=0,R7,R9)","v":"Игорь"},null,null,null,null,null,null,"HMNJMJJKK",null,null,null,null,0.39411750973760384,14,null,null,0.73783223370175888,11,"DDF"]
[null,null,16,{"$f":"IF(R9=0,R9,R8)","v":"Коля"},null,null,null,null,null,null,"SDSGSFHFH",null,null,null,null,0.27379822334906956,17,null,null,0.66689535410047174,13,"JIU"]
[null,null,17,{"$f":"IF(R10=0,R10,R7)","v":"Наташа"},null,null,null,null,null,null,"GHJJG",null,null,null,null,7.4768099026424228E-2,27,null,null,1.147419239884262E-2,30,"OOK"]
[null,null,18,{"$f":"IF(R6=0,R9,R6)","v":"Ветеран"},null,null,null,null,null,null,"OOK",null,null,null,null,0.2564571540670979,19,null,null,0.57283055119891124,17,"HNJ"]
[null,null,19,{"$f":"IF(R11=0,R8,R11)","v":"Дрочер"},null,null,null,null,null,null,"JIU",null,null,null,null,2.9084456233128053E-2,28,null,null,0.59596626059474922,16,"HJIKKK,"]
[null,null,20,{"$f":"IF(R10=0,R6,R10)","v":"Зевс"},null,null,null,null,null,null,"QWER",null,null,null,null,0.15960728704567706,24,null,null,0.99030031539968388,1,"HGFJHG"]
[null,null,21,{"$f":"IF(R9=0,R7,R9)","v":"Игорь"},null,null,null,null,null,null,"CFHJK",null,null,null,null,0.41329571263713116,13,null,null,0.29596957087625297,24,"NGJJG"]
[null,null,22,{"$f":"IF(R9=0,R9,R8)","v":"Коля"},null,null,null,null,null,null,"NGJJG",null,null,null,null,0.31624818339832594,16,null,null,0.41062548506226415,21,"FGB"]
[null,null,23,{"$f":"IF(R10=0,R10,R7)","v":"Наташа"},null,null,null,null,null,null,"VVBN ",null,null,null,null,0.86545363686385501,4,null,null,9.7772037004657308E-2,29,"JMI"]
[null,null,24,{"$f":"IF(R6=0,R9,R6)","v":"Ветеран"},null,null,null,null,null,null,"FGF",null,null,null,null,0.26293238277984188,18,null,null,0.69504722019411302,12,"CFHJK"]
[null,null,25,{"$f":"IF(R11=0,R8,R11)","v":"Дрочер"},null,null,null,null,null,null,"JMI",null,null,null,null,0.17629690843317614,23,null,null,0.32097655076245324,23,"CGBNMMMKHF"]
[null,null,26,{"$f":"IF(R10=0,R6,R10)","v":"Зевс"},null,null,null,null,null,null,"HGFJHG",null,null,null,null,0.14744631918335593,26,null,null,0.50234624179888032,20,"VBNMJ"]
[null,null,27,{"$f":"IF(R9=0,R7,R9)","v":"Игорь"},null,null,null,null,null,null,"UILSDGH",null,null,null,null,0.88911821035876981,2,null,null,0.86122071438181269,6,"VNMJHB"]
[null,null,28,{"$f":"IF(R9=0,R9,R8)","v":"Коля"},null,null,null,null,null,null,"CVBN",null,null,null,null,0.22660275771313243,21,null,null,0.95911362826509206,3,"BBHMM"]
[null,null,29,{"$f":"IF(R10=0,R10,R7)","v":"Наташа"},null,null,null,null,null,null,"VNMJHB",null,null,null,null,0.65879736873817385,7,null,null,0.1545595509641241,27,"VVBN "]
[null,null,30,{"$f":"IF(R6=0,R9,R6)","v":"Ветеран"},null,null,null,null,null,null,"FGB",null,null,null,null,0.50736407946534645,11,null,null,0.35960901027811543,22,"GHJJG"]
[]
[]
[]
[]
[]
[]
[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,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,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,null,null,null,"Дрочер"]