{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Как должно быть"],"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":"Лист1","index":0,"n_rows":142,"n_cols":3,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
["ФИО","Дата","Оценка"]
["Сотрудник 1","2019-01-01",5]
["Сотрудник 1","2019-01-02",2]
["Сотрудник 1","2019-01-01",5]
["Сотрудник 1","2019-01-02",2]
["Сотрудник 1","2019-01-02",5]
["Сотрудник 1","2019-01-01",2]
["Сотрудник 10","2019-01-01",3]
["Сотрудник 10","2019-01-02",5]
["Сотрудник 10","2019-01-01",2]
["Сотрудник 10","2019-01-02",3]
["Сотрудник 10","2019-01-02",5]
["Сотрудник 10","2019-01-01",2]
["Сотрудник 10","2019-01-01",3]
["Сотрудник 10","2019-01-02",5]
["Сотрудник 10","2019-01-01",2]
["Сотрудник 11","2019-01-02",5]
["Сотрудник 11","2019-01-02",5]
["Сотрудник 11","2019-01-01",5]
["Сотрудник 11","2019-01-01",5]
["Сотрудник 11","2019-01-02",5]
["Сотрудник 11","2019-01-01",5]
["Сотрудник 11","2019-01-02",5]
["Сотрудник 11","2019-01-02",5]
["Сотрудник 11","2019-01-01",5]
["Сотрудник 12","2019-01-01",5]
["Сотрудник 12","2019-01-02",2]
["Сотрудник 12","2019-01-01",5]
["Сотрудник 12","2019-01-02",2]
["Сотрудник 12","2019-01-02",5]
["Сотрудник 12","2019-01-01",2]
["Сотрудник 13","2019-01-01",5]
["Сотрудник 13","2019-01-02",1]
["Сотрудник 13","2019-01-01",5]
["Сотрудник 13","2019-01-02",1]
["Сотрудник 13","2019-01-02",5]
["Сотрудник 13","2019-01-01",1]
["Сотрудник 14","2019-01-01",3]
["Сотрудник 14","2019-01-02",3]
["Сотрудник 14","2019-01-01",3]
["Сотрудник 14","2019-01-02",3]
["Сотрудник 14","2019-01-02",3]
["Сотрудник 14","2019-01-01",3]
["Сотрудник 15","2019-01-01",2]
["Сотрудник 15","2019-01-02",1]
["Сотрудник 15","2019-01-01",2]
["Сотрудник 15","2019-01-02",1]
["Сотрудник 15","2019-01-02",2]
["Сотрудник 15","2019-01-01",1]
["Сотрудник 16","2019-01-01",5]
["Сотрудник 16","2019-01-02",2]
["Сотрудник 16","2019-01-01",5]
["Сотрудник 16","2019-01-02",2]
["Сотрудник 16","2019-01-02",5]
["Сотрудник 16","2019-01-01",2]
["Сотрудник 17","2019-01-01",4]
["Сотрудник 17","2019-01-02",4]
["Сотрудник 17","2019-01-01",4]
["Сотрудник 17","2019-01-02",4]
["Сотрудник 17","2019-01-02",4]
["Сотрудник 17","2019-01-01",4]
["Сотрудник 18","2019-01-01",5]
["Сотрудник 18","2019-01-02",2]
["Сотрудник 18","2019-01-01",5]
["Сотрудник 18","2019-01-02",2]
["Сотрудник 18","2019-01-02",5]
["Сотрудник 18","2019-01-01",2]
["Сотрудник 19","2019-01-01",3]
["Сотрудник 19","2019-01-02",3]
["Сотрудник 19","2019-01-01",3]
["Сотрудник 2","2019-01-02",5]
["Сотрудник 2","2019-01-02",3]
["Сотрудник 2","2019-01-01",5]
["Сотрудник 2","2019-01-01",3]
["Сотрудник 2","2019-01-02",5]
["Сотрудник 2","2019-01-01",3]
["Сотрудник 20","2019-01-02",5]
["Сотрудник 20","2019-01-02",5]
["Сотрудник 20","2019-01-01",5]
["Сотрудник 21","2019-01-01",2]
["Сотрудник 21","2019-01-02",2]
["Сотрудник 21","2019-01-01",2]
["Сотрудник 22","2019-01-02",3]
["Сотрудник 22","2019-01-02",3]
["Сотрудник 22","2019-01-01",3]
["Сотрудник 23","2019-01-01",1]
["Сотрудник 23","2019-01-02",1]
["Сотрудник 23","2019-01-01",1]
["Сотрудник 24","2019-01-02",2]
["Сотрудник 24","2019-01-02",2]
["Сотрудник 24","2019-01-01",2]
["Сотрудник 25","2019-01-01",4]
["Сотрудник 25","2019-01-02",4]
["Сотрудник 25","2019-01-01",4]
["Сотрудник 3","2019-01-02",5]
["Сотрудник 3","2019-01-02",1]
["Сотрудник 3","2019-01-01",5]
["Сотрудник 3","2019-01-01",1]
["Сотрудник 3","2019-01-02",5]
["Сотрудник 3","2019-01-01",1]
["Сотрудник 4","2019-01-02",5]
["Сотрудник 4","2019-01-02",2]
["Сотрудник 4","2019-01-01",5]
["Сотрудник 4","2019-01-01",2]
["Сотрудник 4","2019-01-02",5]
["Сотрудник 4","2019-01-01",2]
["Сотрудник 5","2019-01-02",3]
["Сотрудник 5","2019-01-02",4]
["Сотрудник 5","2019-01-01",5]
["Сотрудник 5","2019-01-01",3]
["Сотрудник 5","2019-01-02",4]
["Сотрудник 5","2019-01-01",5]
["Сотрудник 5","2019-01-02",3]
["Сотрудник 5","2019-01-02",4]
["Сотрудник 5","2019-01-01",5]
["Сотрудник 6","2019-01-01",2]
["Сотрудник 6","2019-01-02",2]
["Сотрудник 6","2019-01-01",2]
["Сотрудник 6","2019-01-02",2]
["Сотрудник 6","2019-01-02",2]
["Сотрудник 6","2019-01-01",2]
["Сотрудник 6","2019-01-01",2]
["Сотрудник 6","2019-01-02",2]
["Сотрудник 6","2019-01-01",2]
["Сотрудник 7","2019-01-02",5]
["Сотрудник 7","2019-01-02",5]
["Сотрудник 7","2019-01-01",5]
["Сотрудник 7","2019-01-01",5]
["Сотрудник 7","2019-01-02",5]
["Сотрудник 7","2019-01-01",5]
["Сотрудник 8","2019-01-02",4]
["Сотрудник 8","2019-01-02",2]
["Сотрудник 8","2019-01-01",4]
["Сотрудник 8","2019-01-01",2]
["Сотрудник 8","2019-01-02",4]
["Сотрудник 8","2019-01-01",2]
["Сотрудник 9","2019-01-02",5]
["Сотрудник 9","2019-01-02",1]
["Сотрудник 9","2019-01-01",5]
["Сотрудник 9","2019-01-01",1]
["Сотрудник 9","2019-01-02",5]
["Сотрудник 9","2019-01-01",1]

{"sheet":"Лист2","index":1,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["ФИО","Дата","Кол-во оценок","КПИ","Наименование","Соблюдение норм"]
["Сотрудник 1","2019-01-01"]
["Сотрудник 10","2019-01-01"]
["Сотрудник 11","2019-01-01"]
["Сотрудник 12","2019-01-01"]
["Сотрудник 13","2019-01-01"]
["Сотрудник 14","2019-01-01"]
["Сотрудник 15","2019-01-01"]
["Сотрудник 16","2019-01-01"]
["Сотрудник 17","2019-01-01"]
["Сотрудник 18","2019-01-01"]
["Сотрудник 19","2019-01-01"]
["Сотрудник 2","2019-01-01"]
["Сотрудник 2","2019-01-01"]
["Сотрудник 20","2019-01-01"]
["Сотрудник 21","2019-01-01"]
["Сотрудник 22","2019-01-01"]
["Сотрудник 23","2019-01-01"]
["Сотрудник 24","2019-01-01"]
["Сотрудник 25","2019-01-01"]
["Сотрудник 3","2019-01-01"]
["Сотрудник 4","2019-01-01"]
["Сотрудник 5","2019-01-01"]
["Сотрудник 6","2019-01-01"]
["Сотрудник 7","2019-01-01"]
["Сотрудник 8","2019-01-01"]
["Сотрудник 9","2019-01-01"]
["Сотрудник 1","2019-01-02"]
["Сотрудник 10","2019-01-02"]
["Сотрудник 11","2019-01-02"]
["Сотрудник 12","2019-01-02"]
["Сотрудник 13","2019-01-02"]
["Сотрудник 14","2019-01-02"]
["Сотрудник 15","2019-01-02"]
["Сотрудник 16","2019-01-02"]
["Сотрудник 17","2019-01-02"]
["Сотрудник 18","2019-01-02"]
["Сотрудник 19","2019-01-02"]
["Сотрудник 2","2019-01-02"]
["Сотрудник 2","2019-01-02"]
["Сотрудник 20","2019-01-02"]
["Сотрудник 21","2019-01-02"]
["Сотрудник 22","2019-01-02"]
["Сотрудник 23","2019-01-02"]
["Сотрудник 24","2019-01-02"]
["Сотрудник 25","2019-01-02"]
["Сотрудник 3","2019-01-02"]
["Сотрудник 4","2019-01-02"]
["Сотрудник 5","2019-01-02"]
["Сотрудник 6","2019-01-02"]
["Сотрудник 7","2019-01-02"]
["Сотрудник 8","2019-01-02"]
["Сотрудник 9","2019-01-02"]

{"sheet":"Как должно быть","index":2,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["ФИО","Дата","Кол-во оценок","КПИ","Наименование","Соблюдение норм"]
["Сотрудник 1","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A2,Лист1!B:B,B2,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 10","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A3,Лист1!B:B,B3,Лист1!C:C,\">0\")","v":5}]
["Сотрудник 11","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A4,Лист1!B:B,B4,Лист1!C:C,\">0\")","v":4}]
["Сотрудник 12","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A5,Лист1!B:B,B5,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 13","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A6,Лист1!B:B,B6,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 14","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A7,Лист1!B:B,B7,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 15","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A8,Лист1!B:B,B8,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 16","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A9,Лист1!B:B,B9,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 17","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A10,Лист1!B:B,B10,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 18","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A11,Лист1!B:B,B11,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 19","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A12,Лист1!B:B,B12,Лист1!C:C,\">0\")","v":2}]
["Сотрудник 2","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A13,Лист1!B:B,B13,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 2","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A14,Лист1!B:B,B14,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 20","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A15,Лист1!B:B,B15,Лист1!C:C,\">0\")","v":1}]
["Сотрудник 21","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A16,Лист1!B:B,B16,Лист1!C:C,\">0\")","v":2}]
["Сотрудник 22","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A17,Лист1!B:B,B17,Лист1!C:C,\">0\")","v":1}]
["Сотрудник 23","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A18,Лист1!B:B,B18,Лист1!C:C,\">0\")","v":2}]
["Сотрудник 24","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A19,Лист1!B:B,B19,Лист1!C:C,\">0\")","v":1}]
["Сотрудник 25","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A20,Лист1!B:B,B20,Лист1!C:C,\">0\")","v":2}]
["Сотрудник 3","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A21,Лист1!B:B,B21,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 4","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A22,Лист1!B:B,B22,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 5","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A23,Лист1!B:B,B23,Лист1!C:C,\">0\")","v":4}]
["Сотрудник 6","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A24,Лист1!B:B,B24,Лист1!C:C,\">0\")","v":5}]
["Сотрудник 7","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A25,Лист1!B:B,B25,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 8","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A26,Лист1!B:B,B26,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 9","2019-01-01",{"$f":"COUNTIFS(Лист1!A:A,A27,Лист1!B:B,B27,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 1","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A28,Лист1!B:B,B28,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 10","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A29,Лист1!B:B,B29,Лист1!C:C,\">0\")","v":4}]
["Сотрудник 11","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A30,Лист1!B:B,B30,Лист1!C:C,\">0\")","v":5}]
["Сотрудник 12","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A31,Лист1!B:B,B31,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 13","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A32,Лист1!B:B,B32,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 14","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A33,Лист1!B:B,B33,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 15","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A34,Лист1!B:B,B34,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 16","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A35,Лист1!B:B,B35,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 17","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A36,Лист1!B:B,B36,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 18","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A37,Лист1!B:B,B37,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 19","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A38,Лист1!B:B,B38,Лист1!C:C,\">0\")","v":1}]
["Сотрудник 2","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A39,Лист1!B:B,B39,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 2","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A40,Лист1!B:B,B40,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 20","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A41,Лист1!B:B,B41,Лист1!C:C,\">0\")","v":2}]
["Сотрудник 21","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A42,Лист1!B:B,B42,Лист1!C:C,\">0\")","v":1}]
["Сотрудник 22","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A43,Лист1!B:B,B43,Лист1!C:C,\">0\")","v":2}]
["Сотрудник 23","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A44,Лист1!B:B,B44,Лист1!C:C,\">0\")","v":1}]
["Сотрудник 24","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A45,Лист1!B:B,B45,Лист1!C:C,\">0\")","v":2}]
["Сотрудник 25","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A46,Лист1!B:B,B46,Лист1!C:C,\">0\")","v":1}]
["Сотрудник 3","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A47,Лист1!B:B,B47,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 4","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A48,Лист1!B:B,B48,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 5","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A49,Лист1!B:B,B49,Лист1!C:C,\">0\")","v":5}]
["Сотрудник 6","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A50,Лист1!B:B,B50,Лист1!C:C,\">0\")","v":4}]
["Сотрудник 7","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A51,Лист1!B:B,B51,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 8","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A52,Лист1!B:B,B52,Лист1!C:C,\">0\")","v":3}]
["Сотрудник 9","2019-01-02",{"$f":"COUNTIFS(Лист1!A:A,A53,Лист1!B:B,B53,Лист1!C:C,\">0\")","v":3}]