{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Прорывы","DATA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,14,1,16],[0,0,0,16],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,8,2,8],[1,9,2,9],[1,12,2,12],[1,13,2,13],[2,2,2,3],[2,4,2,5],[1,10,2,10],[1,11,2,11],[1,6,2,6],[1,7,2,7]]}
["Прорывы и аварийные ситуации на водопроводных и канализационных сетях"]
["№ п/п","Ф.И.О. диспетчера","Дата | Время",null,null,null,"ФИО звонившего","Телефон","Адрес","Вид аварии","Вс / Кс","Вк / Кк","К-во домовладений без водоснабжения","Перечень выполненных работ","Выполнение"]
[null,null,"звонка",null,"отключения",null,null,null,null,null,null,null,null,null,"Статус","Дата","Время"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[1,"Головина Н.П.","2019-10-12",null,null,null,null,null,null,null,"ВС"]
[{"$f":"IF($B6=\"\",\"\",IF(SUBTOTAL(103,B5),A5+1,COUNT($A$5:A5)+1))","v":2},"Головина Н.П.","2019-11-12",null,null,null,null,null,null,null,null,"КК"]
[{"$f":"IF($B7=\"\",\"\",IF(SUBTOTAL(103,B6),A6+1,COUNT($A$5:A6)+1))","v":3},"Ершова Л.В.","2019-12-12",null,null,null,null,null,null,null,null,"КК"]
[{"$f":"IF($B8=\"\",\"\",IF(SUBTOTAL(103,B7),A7+1,COUNT($A$5:A7)+1))","v":""}]
[{"$f":"IF($B9=\"\",\"\",IF(SUBTOTAL(103,B8),A8+1,COUNT($A$5:A8)+1))","v":4},"Головина Н.П."]
[{"$f":"IF($B10=\"\",\"\",IF(SUBTOTAL(103,B9),A9+1,COUNT($A$5:A9)+1))","v":5},"Егоров С.Е."]
[{"$f":"IF($B11=\"\",\"\",IF(SUBTOTAL(103,B10),A10+1,COUNT($A$5:A10)+1))","v":6},"Кистанова О.А"]
[{"$f":"IF($B12=\"\",\"\",IF(SUBTOTAL(103,B11),A11+1,COUNT($A$5:A11)+1))","v":""}]
[{"$f":"IF($B13=\"\",\"\",IF(SUBTOTAL(103,B12),A12+1,COUNT($A$5:A12)+1))","v":""}]
[{"$f":"IF($B14=\"\",\"\",IF(SUBTOTAL(103,B13),A13+1,COUNT($A$5:A13)+1))","v":""}]
[{"$f":"IF($B15=\"\",\"\",IF(SUBTOTAL(103,B14),A14+1,COUNT($A$5:A14)+1))","v":""}]
[{"$f":"IF($B16=\"\",\"\",IF(SUBTOTAL(103,B15),A15+1,COUNT($A$5:A15)+1))","v":""}]
[{"$f":"IF($B17=\"\",\"\",IF(SUBTOTAL(103,B16),A16+1,COUNT($A$5:A16)+1))","v":""}]
[{"$f":"IF($B18=\"\",\"\",IF(SUBTOTAL(103,B17),A17+1,COUNT($A$5:A17)+1))","v":""}]
[{"$f":"IF($B19=\"\",\"\",IF(SUBTOTAL(103,B18),A18+1,COUNT($A$5:A18)+1))","v":""}]
[{"$f":"IF($B20=\"\",\"\",IF(SUBTOTAL(103,B19),A19+1,COUNT($A$5:A19)+1))","v":""}]
[{"$f":"IF($B21=\"\",\"\",IF(SUBTOTAL(103,B20),A20+1,COUNT($A$5:A20)+1))","v":""}]

{"sheet":"DATA","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Ф.И.О. диспетчеров","Вс/Кс","ВК/КК"]
["Головина Н.П.","ВС","ВК","Выполнено"]
["Егоров С.Е.","КС","КК","В работе"]
["Ершова Л.В."]
["Каримова Н.В."]
["Кистанова О.А"]
["Тухлина Н.В."]