{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Праздники"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":21,"n_cols":36,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,38,10,38],[11,38,14,38],[15,38,18,38],[19,38,22,38],[19,34,22,34],[25,0,25,6],[25,17,25,29],[26,0,26,7],[26,17,26,35],[19,16,22,16],[19,17,22,17],[19,18,22,18],[19,10,22,10],[19,11,22,11],[19,12,22,12],[19,13,22,13],[19,14,22,14],[19,15,22,15],[15,34,18,34],[19,1,22,1],[19,2,22,2],[19,3,22,3],[19,4,22,4],[19,5,22,5],[27,19,27,34],[19,28,22,28],[19,29,22,29],[19,30,22,30],[19,31,22,31],[19,32,22,32],[19,33,22,33],[19,22,22,22],[19,23,22,23],[19,24,22,24],[19,25,22,25],[19,26,22,26],[19,27,22,27],[19,19,22,19],[19,20,22,20],[19,21,22,21],[19,6,22,6],[19,7,22,7],[19,8,22,8],[19,9,22,9],[15,28,18,28],[15,29,18,29],[15,30,18,30],[15,31,18,31],[15,32,18,32],[15,10,18,10],[15,11,18,11],[15,12,18,12],[15,13,18,13],[15,14,18,14],[15,15,18,15],[11,23,14,23],[11,24,14,24],[11,25,14,25],[11,26,14,26],[11,27,14,27],[11,16,14,16],[11,17,14,17],[15,33,18,33],[15,22,18,22],[15,23,18,23],[15,24,18,24],[15,25,18,25],[15,26,18,26],[15,27,18,27],[15,16,18,16],[15,17,18,17],[15,18,18,18],[15,19,18,19],[15,20,18,20],[15,21,18,21],[11,21,14,21],[11,10,14,10],[11,11,14,11],[11,12,14,12],[11,13,14,13],[11,14,14,14],[11,15,14,15],[11,34,14,34],[15,1,18,1],[15,2,18,2],[15,3,18,3],[15,4,18,4],[15,5,18,5],[15,6,18,6],[15,7,18,7],[15,8,18,8],[15,9,18,9],[11,28,14,28],[11,29,14,29],[11,30,14,30],[11,31,14,31],[11,32,14,32],[11,33,14,33],[11,22,14,22],[11,1,14,1],[11,2,14,2],[11,3,14,3],[11,4,14,4],[11,5,14,5],[11,6,14,6],[11,7,14,7],[11,8,14,8],[11,9,14,9],[0,0,0,9],[7,26,10,26],[7,27,10,27],[11,18,14,18],[11,19,14,19],[11,20,14,20],[0,25,0,34],[1,0,1,9],[1,22,1,35],[2,0,2,9],[2,25,2,34],[7,1,10,1],[7,2,10,2],[7,3,10,3],[7,4,10,4],[7,5,10,5],[7,6,10,6],[7,34,10,34],[7,28,10,28],[7,29,10,29],[7,30,10,30],[7,31,10,31],[7,32,10,32],[7,33,10,33],[7,22,10,22],[4,24,4,25],[4,19,4,22],[4,14,4,17],[4,7,4,13],[7,10,10,10],[7,11,10,11],[7,12,10,12],[7,13,10,13],[7,14,10,14],[7,15,10,15],[7,7,10,7],[7,16,10,16],[7,17,10,17],[7,18,10,18],[7,19,10,19],[7,20,10,20],[7,21,10,21],[7,25,10,25],[7,23,10,23],[7,8,10,8],[7,9,10,9],[7,24,10,24]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,"График сменности на",null,null,null,null,null,null,"октябрь",null,null,null,null,2022,null,null,null,null,"года"]
[]
["ФИО","Нагрузка","Часы/Дни","Дежурства",{"$f":"DATE(T5,MONTH(O5&0),1)","v":"2022-10-01"},{"$f":"E7+1","v":"2022-10-02"},{"$f":"F7+1","v":"2022-10-03"},{"$f":"G7+1","v":"2022-10-04"},"2022-10-05","2022-10-06","2022-10-07","2022-10-08","2022-10-09","2022-10-10","2022-10-11","2022-10-12","2022-10-13","2022-10-14","2022-10-15","2022-10-16","2022-10-17","2022-10-18","2022-10-19","2022-10-20","2022-10-21","2022-10-22","2022-10-23","2022-10-24","2022-10-25","2022-10-26","2022-10-27","2022-10-28",{"$f":"IF(AF7=\"\",\"\",IF(MONTH(AF7)<>MONTH(AF7+1),\"\",AF7+1))","v":"2022-10-29"},{"$f":"IF(AG7=\"\",\"\",IF(MONTH(AG7)<>MONTH(AG7+1),\"\",AG7+1))","v":"2022-10-30"},{"$f":"IF(AH7=\"\",\"\",IF(MONTH(AH7)<>MONTH(AH7+1),\"\",AH7+1))","v":"2022-10-31"},"Подпись"]
[null,null,null,null,{"$f":"IFERROR(IF(ISNUMBER(VLOOKUP(E$7,ПВ,1,0)),\"В\",IF(WEEKDAY(E$7,2)>5,\"В\",IF(MOD(E$7,2)=0,\"7:30-11:24\",\"12:30-16:24\" ))),\"\")","v":"В"},{"$f":"IFERROR(IF(ISNUMBER(VLOOKUP(F$7,ПВ,1,0)),\"В\",IF(WEEKDAY(F$7,2)>5,\"В\",IF(MOD(F$7,2)=0,\"7:30-11:24\",\"12:30-16:24\" ))),\"\")","v":"В"},"12:30-16:24","7:30-11:24","12:30-16:24","7:30-11:24","12:30-16:24","В","В","7:30-11:24","12:30-16:24","7:30-11:24","12:30-16:24","7:30-11:24","В","В","12:30-16:24","7:30-11:24","12:30-16:24","7:30-11:24","12:30-16:24","В","В","7:30-11:24","12:30-16:24","7:30-11:24","12:30-16:24","7:30-11:24","В","В","12:30-16:24"]
["Иванов"]
[]
[]
[null,null,null,null,{"$f":"IFERROR(IF(ISNUMBER(VLOOKUP(E$7,ПВ,1,0)),\"В\",IF(WEEKDAY(E$7,2)>5,\"В\",IF(MOD(E$7,2)=0,\"11:24-15:00\",\"16:24-20:00\" ))),\"\")","v":"В"},"В","16:24-20:00","11:24-15:00","16:24-20:00","11:24-15:00","16:24-20:00","В","В","11:24-15:00","16:24-20:00","11:24-15:00","16:24-20:00","11:24-15:00","В","В","16:24-20:00","11:24-15:00","16:24-20:00","11:24-15:00","16:24-20:00","В","В","11:24-15:00","16:24-20:00","11:24-15:00","16:24-20:00","11:24-15:00","В","В","16:24-20:00"]
["Петров"]
[]
[]
[null,null,null,null,{"$f":"IFERROR(IF(ISNUMBER(VLOOKUP(E$7,ПВ,1,0)),\"В\",IF(WEEKDAY(E$7,2)>5,\"В\",IF(MOD(E$7,2)=0,\"7:30-14:57\",\"12:30-20:00\" ))),\"\")","v":"В"},"В","12:30-20:00","7:30-14:57","12:30-20:00","7:30-14:57","12:30-20:00","В","В","7:30-14:57","12:30-20:00","7:30-14:57","12:30-20:00","7:30-14:57","В","В","12:30-20:00","7:30-14:57","12:30-20:00","7:30-14:57","12:30-20:00","В","В","7:30-14:57","12:30-20:00","7:30-14:57","12:30-20:00","7:30-14:57","В","В","12:30-20:00"]
["Сидоров"]
[]
[]
[null,null,null,null,{"$f":"IFERROR(IF(ISNUMBER(VLOOKUP(E$7,ПВ,1,0)),\"В\",IF(WEEKDAY(E$7,2)>5,\"В\",IF(MOD(E$7,2)=0,\"12:30-20:00\",\"7:30-14:57\" ))),\"\")","v":"В"},"В","7:30-14:57","12:30-20:00","7:30-14:57","12:30-20:00","7:30-14:57","В","В","12:30-20:00","7:30-14:57","12:30-20:00","7:30-14:57","12:30-20:00","В","В","7:30-14:57","12:30-20:00","7:30-14:57","12:30-20:00","7:30-14:57","В","В","12:30-20:00","7:30-14:57","12:30-20:00","7:30-14:57","12:30-20:00","В","В","7:30-14:57"]
["Васильев"]

{"sheet":"Праздники","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[2021,"январь",null,"праздники"]
[2022,"февраль",null,"2022-11-04"]
[2023,"март"]
[2024,"апрель"]
[2025,"май"]
[2026,"июнь"]
[2027,"июль"]
[2028,"август"]
[2029,"сентябрь"]
[2030,"октябрь"]
[2031,"ноябрь"]
[2032,"декабрь"]