{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":7,"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":49,"n_cols":41,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,2,4,2],[1,13,2,13],[1,14,1,24],[1,25,1,35],[2,14,2,20],[2,25,2,31],[5,2,9,2],[5,7,7,9],[5,10,7,11],[8,7,8,9],[8,10,8,11],[9,7,9,9],[9,10,9,11],[10,2,13,2],[10,7,10,9],[10,10,10,11],[11,7,11,9],[11,10,11,11],[12,7,12,9],[12,10,12,11],[13,7,13,9],[13,10,13,11],[32,0,32,7],[32,8,32,11],[14,2,17,2],[14,7,14,11],[19,7,23,11],[28,8,28,10],[29,8,29,10],[30,8,30,10]]}
[]
[]
[]
[]
[]
[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,"О1","О2","Б1","Б2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1","1.2","1.3","1.4","1.5","1.6","1.7","б1","т1","д1","з1","2.1","2.2","2.3","2.4","2.5","2.6","2.7","б2","т2","д2","з2",null,null,{"$f":"--(COUNTIF(Z7:AF7,\"*отпуск*\")>0)","v":0},{"$f":"--(COUNTIF(O7:U7,\"*больн*\")>0)","v":0},{"$f":"--(COUNTIF(Z7:AF7,\"*больн*\")>0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО1 (директор)",null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((LEN(O8:U8)-LEN(SUBSTITUTE(O8:U8,\"бриг\",\"\")))/LEN(\"бриг\"))","v":0},{"$f":"SUMPRODUCT((LEN(O8:U8)-LEN(SUBSTITUTE(O8:U8,\"трен\",\"\")))/LEN(\"трен\"))","v":0},{"$f":"SUMPRODUCT((LEN(O8:U8)-LEN(SUBSTITUTE(O8:U8,\"ДОТ\",\"\")))/LEN(\"ДОТ\"))","v":0},{"$f":"SUMPRODUCT((LEN(O8:U8)-LEN(SUBSTITUTE(O8:U8,\"знан\",\"\")))/LEN(\"знан\"))","v":0},null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((LEN(Z8:AF8)-LEN(SUBSTITUTE(Z8:AF8,\"бриг\",\"\")))/LEN(\"бриг\"))","v":0},{"$f":"SUMPRODUCT((LEN(Z8:AF8)-LEN(SUBSTITUTE(Z8:AF8,\"трен\",\"\")))/LEN(\"трен\"))","v":0},{"$f":"SUMPRODUCT((LEN(Z8:AF8)-LEN(SUBSTITUTE(Z8:AF8,\"ДОТ\",\"\")))/LEN(\"ДОТ\"))","v":0},{"$f":"SUMPRODUCT((LEN(Z8:AF8)-LEN(SUBSTITUTE(Z8:AF8,\"знан\",\"\")))/LEN(\"знан\"))","v":0},null,{"$f":"--(COUNTIF(O8:U8,\"*отпуск*\")>0)","v":0},0,{"$f":"--(COUNTIF(O8:U8,\"*больн*\")>0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО2 (зам. директора)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,{"$f":"--(COUNTIF(O9:U9,\"*отпуск*\")>0)","v":0},0,{"$f":"--(COUNTIF(O9:U9,\"*больн*\")>0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ДЗО 1",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,{"$f":"--(COUNTIF(N10:U10,\"*отпуск*\")>0)","v":0},0,{"$f":"--(COUNTIF(N10:U10,\"*больн*\")>0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО1 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,{"$f":"--(COUNTIF(O11:U11,\"*отпуск*\")>0)","v":0},0,{"$f":"--(COUNTIF(O11:U11,\"*больн*\")>0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО2 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО3 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО4 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО5 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО6 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО7 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО8 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО9 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО10 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ДЗО 2",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,{"$f":"--(COUNTIF(N21:U21,\"*отпуск*\")>0)","v":0},0,{"$f":"--(COUNTIF(N21:U21,\"*больн*\")>0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО11 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,{"$f":"--(COUNTIF(O22:U22,\"*отпуск*\")>0)","v":0},0,{"$f":"--(COUNTIF(O22:U22,\"*больн*\")>0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО12 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО13 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО14 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО15 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО16 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО17 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,"в срок",null,null,0,null,"ФИО18 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,"отклонение 1-3 дн.",null,null,1,null,"ФИО19 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,"отклонение  4 дн. и более",null,null,4,null,"ФИО20 (филиал)",null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Таблица58[б1])","v":0},{"$f":"SUBTOTAL(109,Таблица58[т1])","v":0},{"$f":"SUBTOTAL(109,Таблица58[д1])","v":0},{"$f":"SUBTOTAL(109,Таблица58[з1])","v":0},null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Таблица59[б2])","v":0},{"$f":"SUBTOTAL(109,Таблица59[т2])","v":0},{"$f":"SUBTOTAL(109,Таблица59[д2])","v":0},{"$f":"SUBTOTAL(109,Таблица59[з2])","v":0},null,{"$f":"SUBTOTAL(109,Таблица2931[О1])","v":0},{"$f":"SUBTOTAL(109,Таблица2931[О2])","v":0},{"$f":"SUBTOTAL(109,Таблица2931[Б1])","v":0},{"$f":"SUBTOTAL(109,Таблица2931[Б2])","v":0}]
["Проверки в соответствии с квартальными планами",null,null,null,null,null,null,null,"Выполнение плана проверок"]
["№","Вид проверки","ДЗО","Филиал","Структурное подразделение","Направления проверки","С","ПО","Дата \nначала проверки","к1","Дата \nзавершения проверки","к2","к3"]
[{"$f":"IF(B35<>\"\",MAX($A$34:A34)+1,\"\")","v":1},"       КП   ","х","х",null,"х","2016-03-09","2016-03-25","2016-03-09",{"$f":"IF(I35>40000,I35-G35,\" \")","v":0},"2016-03-25",{"$f":"IF(K35>40000,K35-H35,\" \")","v":"00:00:00"},{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":6}]
[{"$f":"IF(B36<>\"\",MAX($A$34:A35)+1,\"\")","v":2},"       КП   ",null,"х",null,null,"2016-03-09","2016-03-25","2016-03-14",5,null," ",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":4}]
[{"$f":"IF(B37<>\"\",MAX($A$34:A36)+1,\"\")","v":3},"            ВП",null,null,null,null,"2016-03-09","2016-03-14","2016-03-09",0,"2016-03-14","00:00:00",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":3}]
[{"$f":"IF(B38<>\"\",MAX($A$34:A37)+1,\"\")","v":4},"            ВП",null,null,null,null,"2016-03-09","2016-03-15","2016-03-10",1,"2016-03-18","1900-01-03",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":3}]
[{"$f":"IF(B39<>\"\",MAX($A$34:A38)+1,\"\")","v":5},"            ВП",null,null,null,null,"2016-03-09","2016-03-16","2016-03-11",2,null," ",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":3}]
[{"$f":"IF(B40<>\"\",MAX($A$34:A39)+1,\"\")","v":6},"ЦП      ",null,null,null,null,"2016-03-09","2016-03-17","2016-03-12",3,null," ",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":3}]
[{"$f":"IF(B41<>\"\",MAX($A$34:A40)+1,\"\")","v":7},"ЦП      ",null,null,null,null,"2016-03-09","2016-03-18","2016-03-13",4,null," ",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":3}]
[{"$f":"IF(B42<>\"\",MAX($A$34:A41)+1,\"\")","v":8},"ЦП      ",null,null,null,null,"2016-03-09","2016-03-19","2016-03-14",5,null," ",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":3}]
[{"$f":"IF(B43<>\"\",MAX($A$34:A42)+1,\"\")","v":""},null,"в",null,null,null,null,null,null," ",null," ",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":1}]
[{"$f":"IF(B44<>\"\",MAX($A$34:A43)+1,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(I44>40000,I44-G44,\" \")","v":" "},null,{"$f":"IF(K44>40000,K44-H44,\" \")","v":" "},{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":0}]
[{"$f":"IF(B45<>\"\",MAX($A$34:A43)+1,\"\")","v":""},null,"м",null,null,null,null,null,null," ",null," ",{"$f":"COUNTA(Таблица31[[#This Row],[ДЗО]:[Дата \nначала проверки]])","v":1}]
[{"$f":"IF(B46<>\"\",MAX($A$34:A45)+1,\"\")","v":""},null,"и",null,null,null,null,null,null,{"$f":"IF(I46>40000,I46-G46,\" \")","v":" "},null,{"$f":"IF(K46>40000,K46-H46,\" \")","v":" "}]
[{"$f":"IF(B47<>\"\",MAX($A$34:A46)+1,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(I47>40000,I47-G47,\" \")","v":" "},null,{"$f":"IF(K47>40000,K47-H47,\" \")","v":" "}]
[{"$f":"IF(B48<>\"\",MAX($A$34:A45)+1,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(I48>40000,I48-G48,\" \")","v":" "},null,{"$f":"IF(K48>40000,K48-H48,\" \")","v":" "}]
[{"$f":"IF(B49<>\"\",MAX($A$34:A45)+1,\"\")","v":""},null,null,null,null,null,null,null,null," ",null," "]