{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Date","Праздники","ГРАФИК","Выхождаемость"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":12,"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":"Date","index":0,"n_rows":124,"n_cols":1,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
["2015-10-01"]
["2015-11-01"]
["2015-12-01"]
["2016-01-01"]
["2016-02-01"]
["2016-03-01"]
["2016-04-01"]
["2016-05-01"]
["2016-06-01"]
["2016-07-01"]
["2016-08-01"]
["2016-09-01"]
["2016-10-01"]
["2016-11-01"]
["2016-12-01"]
["2017-01-01"]
["2017-02-01"]
["2017-03-01"]
["2017-04-01"]
["2017-05-01"]
["2017-06-01"]
["2017-07-01"]
["2017-08-01"]
["2017-09-01"]
["2017-10-01"]
["2017-11-01"]
["2017-12-01"]
["2018-01-01"]
["2018-02-01"]
["2018-03-01"]
["2018-04-01"]
["2018-05-01"]
["2018-06-01"]
["2018-07-01"]
["2018-08-01"]
["2018-09-01"]
["2018-10-01"]
["2018-11-01"]
["2018-12-01"]
["2019-01-01"]
["2019-02-01"]
["2019-03-01"]
["2019-04-01"]
["2019-05-01"]
["2019-06-01"]
["2019-07-01"]
["2019-08-01"]
["2019-09-01"]
["2019-10-01"]
["2019-11-01"]
["2019-12-01"]
["2020-01-01"]
["2020-02-01"]
["2020-03-01"]
["2020-04-01"]
["2020-05-01"]
["2020-06-01"]
["2020-07-01"]
["2020-08-01"]
["2020-09-01"]
["2020-10-01"]
["2020-11-01"]
["2020-12-01"]
["2021-01-01"]
["2021-02-01"]
["2021-03-01"]
["2021-04-01"]
["2021-05-01"]
["2021-06-01"]
["2021-07-01"]
["2021-08-01"]
["2021-09-01"]
["2021-10-01"]
["2021-11-01"]
["2021-12-01"]
["2022-01-01"]
["2022-02-01"]
["2022-03-01"]
["2022-04-01"]
["2022-05-01"]
["2022-06-01"]
["2022-07-01"]
["2022-08-01"]
["2022-09-01"]
["2022-10-01"]
["2022-11-01"]
["2022-12-01"]
["2023-01-01"]
["2023-02-01"]
["2023-03-01"]
["2023-04-01"]
["2023-05-01"]
["2023-06-01"]
["2023-07-01"]
["2023-08-01"]
["2023-09-01"]
["2023-10-01"]
["2023-11-01"]
["2023-12-01"]
["2024-01-01"]
["2024-02-01"]
["2024-03-01"]
["2024-04-01"]
["2024-05-01"]
["2024-06-01"]
["2024-07-01"]
["2024-08-01"]
["2024-09-01"]
["2024-10-01"]
["2024-11-01"]
["2024-12-01"]
["2025-01-01"]
["2025-02-01"]
["2025-03-01"]
["2025-04-01"]
["2025-05-01"]
["2025-06-01"]
["2025-07-01"]
["2025-08-01"]
["2025-09-01"]
["2025-10-01"]
["2025-11-01"]
["2025-12-01"]
["2026-01-01"]

{"sheet":"Праздники","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,1,1,1]]}
["2024-01-01","Новогодние праздники"]
["2024-01-02"]
["2024-05-09","День Победы"]
["2024-08-25","День шахтера"]
["2024-12-31","Новый год"]

{"sheet":"ГРАФИК","index":2,"n_rows":72,"n_cols":53,"rows_kept":72,"cut":false,"hidden":false,"merged":[[1,43,1,44],[0,43,0,44],[5,44,9,45],[41,39,43,39],[44,39,46,39],[47,39,49,39],[50,39,52,39],[23,42,25,42],[29,42,31,42],[11,41,13,41],[8,43,9,43],[11,43,13,43],[32,41,34,41],[17,43,19,43],[23,43,25,43],[47,41,49,41],[26,45,28,45],[11,45,13,45],[17,45,19,45],[20,45,22,45],[11,44,13,44],[14,44,16,44],[20,44,22,44],[17,44,19,44],[23,45,25,45],[35,45,37,45],[29,45,31,45],[65,43,67,43],[53,43,55,43],[53,42,55,42],[14,43,16,43],[3,43,3,44],[2,43,2,44],[59,45,61,45],[14,45,16,45],[44,44,46,44],[23,44,25,44],[56,45,58,45],[32,45,34,45],[32,43,34,43],[56,44,58,44],[74,42,76,42],[68,42,70,42],[59,42,61,42],[65,42,67,42],[71,42,73,42],[41,41,43,41],[68,41,70,41],[44,42,46,42],[11,46,13,46],[68,44,70,44],[68,45,70,45],[26,41,28,41],[53,41,55,41],[38,41,40,41],[62,42,64,42],[29,41,31,41],[38,43,40,43],[44,45,46,45],[50,44,52,44],[59,44,61,44],[53,45,55,45],[35,44,37,44],[26,44,28,44],[50,45,52,45],[6,39,7,43],[8,17,9,17],[8,20,9,20],[8,37,9,37],[8,23,9,23],[8,30,9,30],[8,13,9,13],[8,16,9,16],[26,43,28,43],[11,42,13,42],[14,42,16,42],[23,41,25,41],[20,43,22,43],[26,42,28,42],[20,42,22,42],[20,41,22,41],[8,40,9,40],[8,24,9,24],[8,39,9,39],[8,31,9,31],[8,18,9,18],[8,35,9,35],[8,33,9,33],[8,19,9,19],[74,41,76,41],[29,43,31,43],[8,41,8,42],[17,41,19,41],[41,43,43,43],[50,42,52,42],[71,39,73,39],[71,41,73,41],[56,42,58,42],[71,43,73,43],[68,43,70,43],[74,43,76,43],[74,39,76,39],[68,39,70,39],[62,39,64,39],[50,41,52,41],[65,39,67,39],[44,41,46,41],[59,41,61,41],[35,43,37,43],[38,42,40,42],[56,41,58,41],[35,42,37,42],[44,43,46,43],[62,5,64,5],[71,4,73,4],[71,5,73,5],[65,6,67,6],[59,6,61,6],[65,4,67,4],[56,6,58,6],[17,42,19,42],[11,39,13,39],[53,6,55,6],[32,42,34,42],[71,6,73,6],[47,5,49,5],[44,5,46,5],[35,6,37,6],[35,41,37,41],[41,42,43,42],[47,42,49,42],[59,39,61,39],[65,41,67,41],[50,5,52,5],[11,40,13,40],[32,3,34,3],[47,4,49,4],[41,3,43,3],[38,5,40,5],[11,3,13,3],[14,6,16,6],[53,39,55,39],[47,6,49,6],[44,6,46,6],[35,3,37,3],[29,6,31,6],[17,6,19,6],[53,5,55,5],[32,39,34,39],[35,39,37,39],[26,6,28,6],[23,6,25,6],[14,3,16,3],[62,2,64,2],[65,2,67,2],[56,4,58,4],[56,2,58,2],[59,5,61,5],[62,41,64,41],[14,41,16,41],[50,6,52,6],[14,39,16,39],[17,39,19,39],[20,39,22,39],[23,39,25,39],[26,39,28,39],[29,39,31,39],[38,39,40,39],[50,4,52,4],[20,3,22,3],[23,4,25,4],[41,6,43,6],[56,39,58,39],[50,3,52,3],[32,6,34,6],[38,6,40,6],[53,4,55,4],[74,2,76,2],[74,3,76,3],[74,4,76,4],[74,5,76,5],[71,2,73,2],[71,3,73,3],[65,3,67,3],[65,5,67,5],[68,2,70,2],[68,5,70,5],[68,4,70,4],[74,6,76,6],[8,1,9,1],[8,2,9,2],[8,3,9,3],[6,8,6,21],[6,22,6,38],[8,12,9,12],[8,32,9,32],[8,36,9,36],[8,34,9,34],[8,25,9,25],[8,38,9,38],[8,8,9,8],[8,4,9,4],[8,14,9,14],[6,1,7,1],[8,28,9,28],[8,22,9,22],[8,29,9,29],[6,5,7,5],[8,6,9,6],[7,29,7,30],[7,18,7,20],[7,22,7,23],[8,27,9,27],[7,31,7,32],[0,16,0,22],[20,5,22,5],[17,5,19,5],[20,4,22,4],[8,9,9,9],[17,4,19,4],[14,5,16,5],[14,4,16,4],[7,26,7,28],[8,21,9,21],[8,11,9,11],[8,26,9,26],[8,15,9,15],[6,2,7,2],[26,3,28,3],[11,5,13,5],[11,4,13,4],[17,2,19,2],[8,10,9,10],[6,7,7,7],[29,4,31,4],[11,6,13,6],[6,6,7,6],[6,3,7,3],[23,5,25,5],[26,5,28,5],[14,2,16,2],[23,2,25,2],[6,4,7,4],[11,2,13,2],[8,5,9,5],[7,9,7,17],[29,2,31,2],[62,3,64,3],[68,6,70,6],[32,5,34,5],[62,6,64,6],[56,3,58,3],[20,6,22,6],[23,3,25,3],[41,5,43,5],[35,5,37,5],[29,5,31,5],[68,3,70,3],[35,4,37,4],[32,4,34,4],[56,5,58,5],[62,4,64,4],[59,4,61,4],[59,3,61,3],[44,3,46,3],[47,3,49,3],[44,4,46,4],[26,4,28,4],[53,3,55,3],[38,3,40,3],[38,4,40,4],[41,2,43,2],[20,2,22,2],[17,3,19,3],[29,3,31,3],[41,4,43,4],[35,2,37,2],[59,2,61,2],[32,2,34,2],[38,2,40,2],[50,2,52,2],[26,2,28,2],[53,2,55,2],[44,2,46,2],[47,2,49,2],[71,44,73,44],[59,43,61,43],[29,44,31,44],[65,45,67,45],[41,44,43,44],[62,44,64,44],[65,44,67,44],[62,45,64,45],[74,44,76,44],[53,44,55,44],[47,43,49,43],[50,43,52,43],[38,45,40,45],[41,45,43,45],[47,45,49,45],[56,43,58,43],[47,44,49,44],[71,45,73,45],[74,45,76,45],[38,44,40,44],[32,44,34,44],[62,43,64,43]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-01"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"J8","v":"2024-03-01"}]
[]
[]
[null,"Табельный номер"]
[null,null,null,null,null,null,null,null,null,{"$f":"Q1","v":"2024-03-01"},null,null,null,null,null,null,null,null,"ruk",null,null,null,"Дней",null,{"$f":"DAY(EOMONTH(J8,0))","v":31},null,"Строк",null,null,{"$f":"ROWS(B12:B77)","v":66}]
[null,"Номер телефона","Таб. на спуск","Граф. раб.","Сотрудник","Должность","Бригада","Часы",{"$f":"$Q$1+0","v":"2024-03-01"},{"$f":"IF(ISERR(I9+1),\"\",IF(I9+1<=EOMONTH($Q$1,0),I9+1,\"\"))","v":"2024-03-02"},"2024-03-03","2024-03-04","2024-03-05",{"$f":"IF(ISERR(M9+1),\"\",IF(M9+1<=EOMONTH($Q$1,0),M9+1,\"\"))","v":"2024-03-06"},"2024-03-07","2024-03-08","2024-03-09","2024-03-10","2024-03-11","2024-03-12","2024-03-13","2024-03-14","2024-03-15","2024-03-16","2024-03-17","2024-03-18","2024-03-19","2024-03-20","2024-03-21","2024-03-22","2024-03-23","2024-03-24","2024-03-25","2024-03-26","2024-03-27","2024-03-28","2024-03-29","2024-03-30","2024-03-31","Итого смен","Итого часов","С графиком ознакомлен и согласен"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","токарь",null,null,1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,"В","В",{"$f":"COUNTIF(I12:AM12,\"<>В\")-COUNTIFS(I12:AM12,\"<>В\",I14:AM14,\"<>\")","v":8},null,null,null,null,null,"токарь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,null,null,"Сотрудник №2","слесарь",null,null,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",{"$f":"COUNTIF(I15:AM15,\"<>В\")-COUNTIFS(I15:AM15,\"<>В\",I17:AM17,\"<>\")","v":15},null,null,null,null,null,"слесарь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,"Сотрудник №3","наладчик",null,null,"В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В","В","В",{"$f":"COUNTIF(I18:AM18,\"<>В\")-COUNTIFS(I18:AM18,\"<>В\",I20:AM20,\"<>\")","v":10},null,null,null,null,null,"наладчик"]
[]
[null,null,null,null,null,null,null,null,null,"УО","УО","УО","УО","УО","УО","УО"]
[null,null,null,null,"Сотрудник №4","грузчик",null,null,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В","В",{"$f":"COUNTIF(I21:AM21,\"<>В\")-COUNTIFS(I21:AM21,\"<>В\",I23:AM23,\"<>\")","v":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,"Сотрудник №5","токарь",null,null,1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,"В","В",{"$f":"COUNTIF(I24:AM24,\"<>В\")-COUNTIFS(I24:AM24,\"<>В\",I26:AM26,\"<>\")","v":15},null,null,null,null,null,"токарь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[]
[null,null,null,null,"Сотрудник №6","слесарь",null,null,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",{"$f":"COUNTIF(I27:AM27,\"<>В\")-COUNTIFS(I27:AM27,\"<>В\",I29:AM29,\"<>\")","v":8},null,null,null,null,null,"слесарь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,null,null,"Сотрудник №7","наладчик",null,null,"В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В","В","В",14,null,null,null,null,null,"наладчик"]
[]
[]
[null,null,null,null,"Сотрудник №8","грузчик",null,null,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В","В",14,null,null,null,null,null,"грузчик"]
[]
[]
[null,null,null,null,"Сотрудник №9","токарь",null,null,1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,"В","В",5,null,null,null,null,null,"токарь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,null,null,"Сотрудник №10","слесарь",null,null,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",15,null,null,null,null,null,"слесарь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,"Сотрудник №11","наладчик",null,null,"В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В","В","В",7,null,null,null,null,null,"наладчик"]
[]
[null,null,null,null,null,null,null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,null,null,"Сотрудник №12","грузчик",null,null,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В","В",{"$f":"COUNTIF(I45:AM45,\"<>В\")-COUNTIFS(I45:AM45,\"<>В\",I47:AM47,\"<>\")","v":14},null,null,null,null,null,"грузчик"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"В","В"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"В","В"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,"Руководитель №1",null,null,null,1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,"В","В",{"$f":"COUNTIF(I54:AM54,\"<>В\")-COUNTIFS(I54:AM54,\"<>В\",I56:AM56,\"<>\")","v":15},null,null,null,null,null,"Руководитель №1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[]
[null,null,null,null,"Руководитель №2",null,null,null,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",{"$f":"COUNTIF(I57:AM57,\"<>В\")-COUNTIFS(I57:AM57,\"<>В\",I59:AM59,\"<>\")","v":9},null,null,null,null,null,"Руководитель №2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"К","К","К","К","К","К","К","К","К","К"]
[null,null,null,null,"Руководитель №3",null,null,null,"В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В","В","В",{"$f":"COUNTIF(I60:AM60,\"<>В\")-COUNTIFS(I60:AM60,\"<>В\",I62:AM62,\"<>\")","v":14},null,null,null,null,null,"Руководитель №3"]
[]
[]
[null,null,null,null,"Руководитель №4",null,null,null,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В",1,2,"В","В","В",{"$f":"COUNTIF(I63:AM63,\"<>В\")-COUNTIFS(I63:AM63,\"<>В\",I65:AM65,\"<>\")","v":14},null,null,null,null,null,"Руководитель №4"]
[]
[]
[null,null,null,null,"Руководитель №5",null,null,null,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,1,"В","В",{"$f":"COUNTIF(I66:AM66,\"<>В\")-COUNTIFS(I66:AM66,\"<>В\",I68:AM68,\"<>\")","v":8},null,null,null,null,null,"Руководитель №5"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"В","В"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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":"Выхождаемость","index":3,"n_rows":44,"n_cols":51,"rows_kept":44,"cut":false,"hidden":false,"merged":[[14,2,14,3],[0,17,0,22],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,21,6,21],[5,3,6,3],[5,4,6,4],[5,5,6,5],[4,6,4,11],[5,7,6,7],[5,30,6,30],[5,31,6,31],[5,22,6,22],[5,23,6,23],[5,24,6,24],[5,25,6,25],[5,26,6,26],[5,27,6,27],[5,28,6,28],[5,34,6,34],[5,32,6,32],[5,33,6,33],[5,2,6,2],[5,16,6,16],[5,17,6,17],[5,18,6,18],[5,19,6,19],[5,20,6,20],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[5,6,6,6],[5,29,6,29]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"R1","v":"2024-03-01"}]
[null,"Общая выхождаемость","Числа месяца",{"$f":"$R$1+0","v":"2024-03-01"},{"$f":"IF(ISERR(D6+1),\"\",IF(D6+1<=EOMONTH($R$1,0),D6+1,\"\"))","v":"2024-03-02"},"2024-03-03","2024-03-04","2024-03-05","2024-03-06","2024-03-07","2024-03-08","2024-03-09","2024-03-10","2024-03-11","2024-03-12","2024-03-13","2024-03-14","2024-03-15","2024-03-16","2024-03-17","2024-03-18","2024-03-19","2024-03-20","2024-03-21","2024-03-22","2024-03-23","2024-03-24","2024-03-25","2024-03-26","2024-03-27","2024-03-28","2024-03-29",{"$f":"IF(ISERR(AF6+1),\"\",IF(AF6+1<=EOMONTH($R$1,0),AF6+1,\"\"))","v":"2024-03-30"},"2024-03-31","Итого"]
[]
[null,null,"1-я смена",{"$f":"COUNTIFS(ГРАФИК!I12:I68,1,ГРАФИК!I12:I68,\"<>\")","v":5},{"$f":"COUNTIFS(ГРАФИК!J24:J47,1,ГРАФИК!J24:J47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!K24:K47,1,ГРАФИК!K24:K47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!L24:L47,1,ГРАФИК!L24:L47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!M24:M47,1,ГРАФИК!M24:M47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!N24:N47,1,ГРАФИК!N24:N47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!O24:O47,1,ГРАФИК!O24:O47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!P24:P47,1,ГРАФИК!P24:P47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!Q24:Q47,1,ГРАФИК!Q24:Q47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!R24:R47,1,ГРАФИК!R24:R47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!S24:S47,1,ГРАФИК!S24:S47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!T24:T47,1,ГРАФИК!T24:T47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!U24:U47,1,ГРАФИК!U24:U47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!V24:V47,1,ГРАФИК!V24:V47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!W24:W47,1,ГРАФИК!W24:W47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!X24:X47,1,ГРАФИК!X24:X47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!Y24:Y47,1,ГРАФИК!Y24:Y47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!Z24:Z47,1,ГРАФИК!Z24:Z47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AA24:AA47,1,ГРАФИК!AA24:AA47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AB24:AB47,1,ГРАФИК!AB24:AB47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AC24:AC47,1,ГРАФИК!AC24:AC47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AD24:AD47,1,ГРАФИК!AD24:AD47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AE24:AE47,1,ГРАФИК!AE24:AE47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AF24:AF47,1,ГРАФИК!AF24:AF47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AG24:AG47,1,ГРАФИК!AG24:AG47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AH24:AH47,1,ГРАФИК!AH24:AH47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AI24:AI47,1,ГРАФИК!AI24:AI47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AJ24:AJ47,1,ГРАФИК!AJ24:AJ47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AK24:AK47,1,ГРАФИК!AK24:AK47,\"<>\")","v":2},{"$f":"COUNTIFS(ГРАФИК!AL24:AL47,1,ГРАФИК!AL24:AL47,\"<>\")","v":0},{"$f":"COUNTIFS(ГРАФИК!AM24:AM47,1,ГРАФИК!AM24:AM47,\"<>\")","v":0},{"$f":"SUM(D8:AH8)","v":61}]
[null,null,"2-я смена",{"$f":"COUNTIFS(ГРАФИК!I12:I68,2,ГРАФИК!I12:I68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!J12:J68,2,ГРАФИК!J12:J68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!K12:K68,2,ГРАФИК!K12:K68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!L12:L68,2,ГРАФИК!L12:L68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!M12:M68,2,ГРАФИК!M12:M68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!N12:N68,2,ГРАФИК!N12:N68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!O12:O68,2,ГРАФИК!O12:O68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!P12:P68,2,ГРАФИК!P12:P68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!Q12:Q68,2,ГРАФИК!Q12:Q68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!R12:R68,2,ГРАФИК!R12:R68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!S12:S68,2,ГРАФИК!S12:S68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!T12:T68,2,ГРАФИК!T12:T68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!U12:U68,2,ГРАФИК!U12:U68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!V12:V68,2,ГРАФИК!V12:V68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!W12:W68,2,ГРАФИК!W12:W68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!X12:X68,2,ГРАФИК!X12:X68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!Y12:Y68,2,ГРАФИК!Y12:Y68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!Z12:Z68,2,ГРАФИК!Z12:Z68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AA12:AA68,2,ГРАФИК!AA12:AA68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AB12:AB68,2,ГРАФИК!AB12:AB68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AC12:AC68,2,ГРАФИК!AC12:AC68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AD12:AD68,2,ГРАФИК!AD12:AD68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AE12:AE68,2,ГРАФИК!AE12:AE68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AF12:AF68,2,ГРАФИК!AF12:AF68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AG12:AG68,2,ГРАФИК!AG12:AG68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AH12:AH68,2,ГРАФИК!AH12:AH68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AI12:AI68,2,ГРАФИК!AI12:AI68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AJ12:AJ68,2,ГРАФИК!AJ12:AJ68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AK12:AK68,2,ГРАФИК!AK12:AK68,\"<>\")","v":4},{"$f":"COUNTIFS(ГРАФИК!AL12:AL68,2,ГРАФИК!AL12:AL68,\"<>\")","v":0},{"$f":"COUNTIFS(ГРАФИК!AM12:AM68,2,ГРАФИК!AM12:AM68,\"<>\")","v":0},{"$f":"SUM(D9:AH9)","v":116}]
[null,null,"3-я смена",null,null,null,null,null,null,null,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(D10:AH10)","v":0}]
[null,null,"4-я смена",null,null,null,null,null,null,null,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(D11:AH11)","v":0}]
[null,null,"Итого за сутки",{"$f":"SUM(D8:D11)","v":9},{"$f":"SUM(E8:E11)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"SUM(AF8:AF11)","v":6},0,0,{"$f":"SUM(D12:AH12)","v":177}]
[null,null,"% выхождаемости",{"$f":"IF(D12=0,0,D8/D12*100)","v":55.555555555555557},{"$f":"IF(E12=0,0,E8/E12*100)","v":33.333333333333329},33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,33.333333333333329,{"$f":"IF(AF12=0,0,AF8/AF12*100)","v":33.333333333333329},0,0,{"$f":"IF(AI12=0,0,AI8/AI12*100)","v":34.463276836158194}]
[]
[null,null,"Сменный руководитель"]
[]
[null,null,"Числа месяца",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Итого"]
[null,null,"1-я смена",null,null,null,null,null,null,null,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(D18:AH18)","v":0}]
[null,null,"2-я смена",null,null,null,null,null,null,null,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(D19:AH19)","v":0}]
[null,null,"3-я смена",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"4-я смена",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Итого за сутки",{"$f":"SUM(D18:D21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AG18:AG21)","v":0},0,{"$f":"SUM(D22:AH22)","v":0}]
[null,null,"% выхождаемости",{"$f":"IF(D22=0,0,D18/D22*100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AG22=0,0,AG18/AG22*100)","v":0},0,{"$f":"IF(AI22=0,0,AI18/AI22*100)","v":0}]
[]
[null,null,"Числа месяца",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Итого"]
[null,"токарь","1-я смена",null,null,null,null,null,null,null,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(D26:AH26)","v":0},{"$f":"SUM(D26:K26)","v":0}]
[null,null,"2-я смена",null,null,null,null,null,null,null,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(D27:AH27)","v":0},{"$f":"SUM(D27:K27)","v":0}]
[null,null,"3-я смена",null,null,null,null,null,null,null,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(D28:AH28)","v":0},0]
[null,null,"4-я смена",null,null,null,null,null,null,null,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(D29:AH29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"слесарь","1-я смена",null,null,null,null,null,null,null,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(D31:AH31)","v":0},0]
[null,null,"2-я смена",null,null,null,null,null,null,null,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(D32:AH32)","v":0},0]
[null,null,"3-я смена",null,null,null,null,null,null,null,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(D33:AH33)","v":0},0]
[null,null,"4-я смена",null,null,null,null,null,null,null,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(D34:AH34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"наладчик","1-я смена",null,null,null,null,null,null,null,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(D36:AH36)","v":0},0]
[null,null,"2-я смена",null,null,null,null,null,null,null,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(D37:AH37)","v":0},0]
[null,null,"3-я смена",null,null,null,null,null,null,null,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(D38:AH38)","v":0},0]
[null,null,"4-я смена",null,null,null,null,null,null,null,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(D39:AH39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"грузчик","1-я смена",null,null,null,null,null,null,null,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(D41:AH41)","v":0},0]
[null,null,"2-я смена",null,null,null,null,null,null,null,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(D42:AH42)","v":0},0]
[null,null,"3-я смена",null,null,null,null,null,null,null,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(D43:AH43)","v":0},0]
[null,null,"4-я смена",null,null,null,null,null,null,null,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(D44:AH44)","v":0}]