{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":36,"comments":1,"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":192,"n_cols":16,"rows_kept":192,"cut":false,"hidden":false,"merged":[]}
[null,null,"№","столбец1 ","столбец2","столбец3","столбец4","столбец11","столбец6","Способ разработки мэппинга ","Ответственный от ИТ","столбец10","столбец6","столбец7","столбец8","Статус готовности"]
[]
[null,null,1,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,1,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,1,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,1,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,1,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,1,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,2,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,3,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,4,null,null,null,null,null,null,"Вручную","витечкин",null,null,null,null,"Выполнено"]
[null,null,5,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,5,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,5,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,6,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,7,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,8,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,10,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,11,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,11,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,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,13,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,14,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,16,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,17,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,18,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,19,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,21,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,21,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,23,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,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,26,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,26,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,26,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,28,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,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"В плане работ"]
[null,null,31,null,null,null,null,null,null,"Вручную","кузькина",null,null,null,null,"Выполнено"]
[null,null,32,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,33,null,null,null,null,null,null,"Вручную","витечкин",null,null,null,null,"В плане работ"]
[null,null,34,null,null,null,null,null,null,"Автоматически",null,null,null,null,null,"Не требуется"]
[null,null,34,null,null,null,null,null,null,"Автоматически","стулов",null,null,null,null,"В плане работ"]
[null,null,35,null,null,null,null,null,null,"Автоматически","стулов",null,null,null,null,"В плане работ"]
[null,null,36,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,37,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,38,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,38,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,39,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,39,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,39,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,39,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,40,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"В плане работ"]
[null,null,41,null,null,null,null,null,null,"Вручную","витечкин",null,null,null,null,"В плане работ"]
[null,null,42,null,null,null,null,null,null,"Вручную","Шарова",null,null,null,null,"В плане работ"]
[null,null,42,null,null,null,null,null,null,"Вручную","Шарова",null,null,null,null,"В плане работ"]
[null,null,43,null,null,null,null,null,null,"Вручную","Шарова",null,null,null,null,"В плане работ"]
[null,null,43,null,null,null,null,null,null,"Вручную","Шарова",null,null,null,null,"В плане работ"]
[null,null,43,null,null,null,null,null,null,"Вручную","Шарова",null,null,null,null,"В плане работ"]
[null,null,43,null,null,null,null,null,null,"Вручную","Шарова",null,null,null,null,"В плане работ"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,44,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,50,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"Выполнено"]
[null,null,45,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"Не актуально"]
[null,null,45,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"Не актуально"]
[null,null,46,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"В плане работ"]
[null,null,46,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"Не актуально"]
[null,null,47,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"В плане работ"]
[null,null,47,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"В плане работ"]
[null,null,48,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"В плане работ"]
[null,null,48,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"В плане работ"]
[null,null,48,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,49,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,50,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"Выполнено"]
[null,null,50,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"Не актуально"]
[null,null,50,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"Не актуально"]
[null,null,51,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Не требуется"]
[null,null,51,null,null,null,null,null,null,"Вручную","Иванова",null,null,null,null,"Не актуально"]
[null,null,51,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Не актуально"]
[null,null,51,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,51,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,51,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Не актуально"]
[null,null,52,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную","кузькина",null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,53,null,null,null,null,null,null,"Вручную",null,null,null,null,null,"В плане работ"]
[null,null,54,null,null,null,null,null,null,"Автоматически","витечкин",null,null,null,null,"В плане работ"]
[null,null,55,null,null,null,null,null,null,"ручную","кузькина",null,null,null,null,"В плане работ"]
[null,null,56,null,null,null,null,null,null,"Вручную","витечкин",null,null,null,null,"В плане работ"]
[null,null,57,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,57,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"В плане работ"]
[null,null,57,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,57,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,57,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,57,null,null,null,null,null,null,"Вручную","стулов",null,null,null,null,"Не актуально"]
[null,null,58,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,58,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,58,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"Выполнено"]
[null,null,59,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,60,null,null,null,null,null,null,"Вручную","Малыгин",null,null,null,null,"Выполнено"]
[null,null,61,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,61,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"В плане работ"]
[null,null,62,null,null,null,null,null,null,"Вручную","степаненко",null,null,null,null,"Выполнено"]
[null,null,63,null,null,null,null,null,null,"Вручную","петров",null,null,null,null,"Выполнено"]
[null,null,64,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"В плане работ"]
[null,null,64,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"В плане работ"]
[null,null,64,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"В плане работ"]
[null,null,64,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"В плане работ"]
[null,null,64,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"В плане работ"]
[null,null,64,null,null,null,null,null,null,"Вручную","Федотова",null,null,null,null,"В плане работ"]
[null,null,65,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,"Не требуется"]
[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,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,66,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,66,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,"Не требуется"]

{"sheet":"Лист2","index":1,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Ответственный от ИТ",null,1]
[null,null,1]
["петров",1]

{"sheet":"Лист3","index":2,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Ответственный","Выполнено","Осталось"]
["петров",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A2)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":15},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A2)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":7}]
["Федотова",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A3)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":5.9999999999999982},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A3)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":2.0000000000000004}]
["витечкин",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A4)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":2},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A4)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":6}]
["кузькина",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A5)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":2},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A5)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":3}]
["стулов",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A6)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":2},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A6)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":17}]
["Иванова",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A7)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":1},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A7)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":1}]
["сидоров",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A8)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":0},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A8)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":1}]
["Шарова",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A9)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":0},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A9)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":2}]
["Малыгин",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A10)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":2},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A10)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":6}]
["степаненко",{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A11)*(Лист1!$P$3:$P$1000=\"Выполнено\"))","v":1},{"$f":"SUM(IFERROR(1/COUNTIFS(Лист1!$C$3:$C$1000,Лист1!$C$3:$C$1000,Лист1!$K$3:$K$1000,Лист1!$K$3:$K$1000,Лист1!$P$3:$P$1000,Лист1!$P$3:$P$1000),0)*(Лист1!$K$3:$K$1000=A11)*(Лист1!$P$3:$P$1000<>\"Выполнено\"))","v":0}]
[]
[]
[]
[null,"осталось как должно быть"]
["витечкин",6,{"$f":"VLOOKUP(A16,$A$2:$C$11,3,0)","v":6}]
["Иванова",1,{"$f":"VLOOKUP(A17,$A$2:$C$11,3,0)","v":1}]
["кузькина",3,{"$f":"VLOOKUP(A18,$A$2:$C$11,3,0)","v":3}]
["Малыгин",5,{"$f":"VLOOKUP(A19,$A$2:$C$11,3,0)","v":6}]
["петров",6,{"$f":"VLOOKUP(A20,$A$2:$C$11,3,0)","v":7}]
["сидоров",1,{"$f":"VLOOKUP(A21,$A$2:$C$11,3,0)","v":1}]
["степаненко",0,{"$f":"VLOOKUP(A22,$A$2:$C$11,3,0)","v":0}]
["стулов",14,{"$f":"VLOOKUP(A23,$A$2:$C$11,3,0)","v":17}]
["Федотова",2,{"$f":"VLOOKUP(A24,$A$2:$C$11,3,0)","v":2.0000000000000004}]
["Шарова",2,{"$f":"VLOOKUP(A25,$A$2:$C$11,3,0)","v":2}]