{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Сводная","График рабочих смен"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Сумма по полю Общая загруженность (ч)","Названия столбцов"]
["Названия строк","2021-09-02","Общий итог"]
["Сотрудник 1",8,8]
["Сотрудник 2",8,8]
["Сотрудник 3",7.5,7.5]
["Сотрудник 4",7.5,7.5]
["Сотрудник 5",5,5]
["Общий итог",36,36]

{"sheet":"График рабочих смен","index":1,"n_rows":31,"n_cols":46,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,42,0,43]]}
["Уникальные даты","Дата","Операция","Сотрудник","10:00","10:30","11:00","11:30","12:00","12:30","13:00","13:30","14:00","14:30","15:00","15:30","16:00","16:30","17:00","17:30","18:00","18:30","19:00","19:30","20:00","20:30","21:00","21:30","22:00","Общая загруженность (%)","Общая загруженность (ч)",null,null,null,null,null,null,null,null,null,null,null,"Список",null,null,"На дату"]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A1,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":"2021-09-02"},"2021-09-02","Касса","Сотрудник 1",30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E2:AC2)/480","v":0.375},{"$f":"SUM(E2:AC2)/60","v":3},null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 1",{"$f":"IF(AS2=TRUE,1,0)","v":0},false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A2,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":"2021-09-03"},"2021-09-02","Зал","Сотрудник 1",null,null,null,null,null,null,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,2,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 2",{"$f":"IF(AS3=TRUE,1,0)","v":0},false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A3,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":"2021-09-04"},"2021-09-02","Примерочная","Сотрудник 1",null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,0.375,3,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 3",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A4,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":"2021-09-05"},"2021-09-02","Касса","Сотрудник 2",null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,0.625,5,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 4",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A5,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":"2021-09-06"},"2021-09-02","Зал","Сотрудник 2",30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.375,3,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 5",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A6,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-02","Касса","Сотрудник 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,0.5625,4.5,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 6",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A7,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-02","Зал","Сотрудник 3",null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,0.375,3,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 7",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A8,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-02","Зал","Сотрудник 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,0.5625,4.5,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 8",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A9,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-02","Примерочная","Сотрудник 4",null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,0.375,3,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 9",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A10,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-02","Примерочная","Сотрудник 5",30,30,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.625,5,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 10",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A11,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-03","Касса","Сотрудник 1",30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,4,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 11",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A12,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-03","Касса","Сотрудник 2",null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,0.5,4,null,null,null,null,null,null,null,null,null,null,null,"Сотрудник 12",0,false]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A13,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-03","Касса","Сотрудник 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,0.5625,4.5]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A14,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-03","Зал","Сотрудник 1",null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,0.5,4]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A15,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-03","Зал","Сотрудник 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,0.5625,4.5]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A16,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-03","Зал","Сотрудник 4",30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,4]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A17,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-03","Примерочная","Сотрудник 3",null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,0.5,4]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A18,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-03","Примерочная","Сотрудник 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,0.5625,4.5]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A19,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Касса","Сотрудник 1",30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:AC20)/480","v":0.3125},{"$f":"SUM(E20:AC20)/60","v":2.5}]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A20,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Касса","Сотрудник 2",null,null,null,null,null,30,30,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:AC21)/480","v":0.625},{"$f":"SUM(E21:AC21)/60","v":5}]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A21,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Касса","Сотрудник 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,30,0.625,5]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A22,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Примерочная","Сотрудник 1",null,null,null,null,null,30,30,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,0.625,5]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A23,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Примерочная","Сотрудник 2",30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3125,2.5]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A24,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Примерочная","Сотрудник 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,30,0.625,5]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A25,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Зал","Сотрудник 5",null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,0.375,3]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A26,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Зал","Сотрудник 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,30,0.625,5]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A27,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-04","Зал","Сотрудник 7",30,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E28:AC28)/480","v":0.5625},{"$f":"SUM(E28:AC28)/60","v":4.5}]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A28,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-05","Касса","Сотрудник 1",30,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:AC29)/480","v":0.5625},{"$f":"SUM(E29:AC29)/60","v":4.5}]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A29,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-05","Касса","Сотрудник 2",null,null,null,null,null,null,null,null,null,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,{"$f":"SUM(E30:AC30)/480","v":1},{"$f":"SUM(E30:AC30)/60","v":8}]
[{"$f":"IFERROR(INDEX(Исходный,MATCH(SUM(COUNTIF(A$1:A30,Исходный)),COUNTIF(Исходный,\"<\"&Исходный),0)),\"\")","v":""},"2021-09-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E31:AC31)/480","v":0},{"$f":"SUM(E31:AC31)/60","v":0}]