{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["сводная таблица"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":69,"n_cols":27,"rows_kept":69,"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,"№","список фамилий дежурных №1","Допустимо смен","смен назначено","Номера свободных сотрудников","Не исчерпали запас допустимых смен",null,null,null,null,null,"январь",{"$f":"TODAY()","v":"2014-09-19"},2014]
[null,null,"1\n","Ветеран",null,null,null,null,null,null,{"$f":"INDEX($X$6:$X$35,W6)","v":0},null,null,1,"Ветеран",5,{"$f":"COUNTIF($D$6:$D$35,O6)","v":2},{"$f":"IF(P6-Q6<=0,\"\",ROW(O6)-ROW($O$6)+1)","v":1},{"$f":"IF(N6>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R2)-1)))","v":"Ветеран"},null,null,null,null,null,"февраль",{"$f":"MONTH(Z5)","v":9},2015]
[null,null,2,"Коля",null,null,null,null,null,null,0,null,null,2,"Коля",5,2,2,{"$f":"IF(N7>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R3)-1)))","v":"Коля"},null,null,null,null,null,"март",{"$f":"YEAR(Z5)","v":2014},2016]
[null,null,3,"Наташа",null,null,null,null,null,null,0,null,null,3,"Наташа",5,2,3,{"$f":"IF(N8>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R4)-1)))","v":"Наташа"},null,null,null,null,null,"апрель",null,2017]
[null,null,4,"Игорь",null,null,null,null,null,null,0,null,null,4,"Игорь",5,2,4,{"$f":"IF(N9>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R5)-1)))","v":"Игорь"},null,null,null,null,null,"май",null,2018]
[null,null,5,"Зевс",null,null,null,null,null,null,0,null,null,5,"Зевс",5,2,5,{"$f":"IF(N10>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R6)-1)))","v":"Зевс"},null,null,null,null,null,"июнь",null,2019]
[null,null,6,"Дрочер",null,null,null,null,null,null,0,null,null,6,"Дрочер",5,2,6,"Дрочер",null,null,null,null,null,"июль",null,2020]
[null,null,7,"Ветеран",null,null,null,null,null,null,0,null,null,7,null,null,null,null,null,null,null,null,null,null,"август",null,2021]
[null,null,8,"Коля",null,null,null,null,null,null,0,null,null,8,null,null,null,null,null,null,null,null,null,null,"сентябрь",null,2022]
[null,null,9,"Наташа",null,null,null,null,null,null,0,null,null,9,null,null,null,null,null,null,null,null,null,null,"октябрь",null,2023]
[null,null,10,"Игорь",null,null,null,null,null,null,0,null,null,10,null,null,null,null,null,null,null,null,null,null,"ноябрь",null,2024]
[null,null,11,"Зевс",null,null,null,null,null,null,0,null,null,11,null,null,null,null,null,null,null,null,null,null,"декабрь",null,2025]
[null,null,12,"Дрочер",null,null,null,null,null,null,0,null,null,12]
[null,null,13,null,null,null,null,null,null,null,0,null,null,13]
[null,null,14,null,null,null,null,null,null,null,0,null,null,14]
[null,null,15,null,null,null,null,null,null,null,0,null,null,15]
[null,null,16,null,null,null,null,null,null,null,0,null,null,16]
[null,null,17,null,null,null,null,null,null,null,0,null,null,17]
[null,null,18,null,null,null,null,null,null,null,0,null,null,18]
[null,null,19,null,null,null,null,null,null,null,0,null,null,19]
[null,null,20,null,null,null,null,null,null,null,0,null,null,20]
[null,null,21,null,null,null,null,null,null,null,0,null,null,21]
[null,null,22,null,null,null,null,null,null,null,0,null,null,22]
[null,null,23,null,null,null,null,null,null,null,0,null,null,23]
[null,null,24,null,null,null,null,null,null,null,0,null,null,24]
[null,null,25,null,null,null,null,null,null,null,0,null,null,25]
[null,null,26,null,null,null,null,null,null,null,0,null,null,26]
[null,null,27,null,null,null,null,null,null,null,0,null,null,27]
[null,null,28,null,null,null,null,null,null,null,0,null,null,28]
[null,null,29,null,null,null,null,null,null,null,0,null,null,29]
[null,null,30,null,null,null,null,null,null,null,0,null,null,30]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"№","список фамилий дежурных №2","Допустимо смен","смен назначено","Номера свободных сотрудников","Не исчерпали запас допустимых смен"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Ветеран",5,{"$f":"COUNTIF($K$6:$K$35,O40)","v":0},{"$f":"IF(P40-Q40<=0,\"\",ROW(O40)-ROW($O$6)+1)","v":35},{"$f":"IF(N40>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R36)-1)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Коля",5,{"$f":"COUNTIF($K$6:$K$35,O41)","v":0},36,{"$f":"IF(N41>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R37)-1)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Наташа",5,0,37,{"$f":"IF(N42>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R38)-1)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Игорь",5,0,38,{"$f":"IF(N43>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R39)-1)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Зевс",5,0,39,{"$f":"IF(N44>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R40)-1)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Дрочер",5,0,40,{"$f":"IF(N45>COUNT($R$6:$R$35),\"\",INDEX($O$6:$O$35,SMALL($R$6:$R$35,ROW(R41)-1)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30]