{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Январь","Февраль","Март","Апрель","Май","Июнь","Июль","Август","Сентябрь","Октябрь","Ноябрь","Декабрь","Имена сотрудников"],"not_rendered":{"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"Январь","index":0,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Январь"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},2023]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,1),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,2),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,3),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,4),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,5),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,6),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,7),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,8),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,9),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,10),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,11),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,12),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,13),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,14),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,15),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,16),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,17),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,18),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,19),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,20),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,21),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,22),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,23),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,24),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,25),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,26),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,27),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,28),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,29),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,30),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,1,31),1),\"ДДД\")","v":"Вт"}]
[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,null,"О","О","О","О",{"$nulls":6},"О",{"$nulls":18},{"$f":"COUNTA(Январь!$C9:$AG9)","v":5}]
[null,"Илья Глазков",{"$nulls":4},"Б","Б",{"$nulls":4},"ЛО",{"$nulls":8},"Б",{"$nulls":4},"О","О","О",{"$nulls":4},{"$f":"COUNTA(Январь!$C10:$AG10)","v":7}]
[null,"Виталий Дегтярев",null,null,"ЛО",{"$nulls":10},"Б",{"$nulls":14},"Б",null,null,{"$f":"COUNTA(Январь!$C11:$AG11)","v":3}]
[null,"Руслана Анкудинова",{"$nulls":6},"ЛО",{"$nulls":11},"О","О","О",{"$nulls":10},{"$f":"COUNTA(Январь!$C12:$AG12)","v":4}]
[null,"Мария Маслова",{"$nulls":3},"Б","О","О",{"$nulls":10},"Б",{"$nulls":6},"Б",{"$nulls":6},"О",{"$f":"COUNTA(Январь!$C13:$AG13)","v":6}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Январь Итог"},{"$f":"SUBTOTAL(103,Январь!$C$9:$C$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$D$9:$D$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$E$9:$E$13)","v":2},{"$f":"SUBTOTAL(103,Январь!$F$9:$F$13)","v":2},{"$f":"SUBTOTAL(103,Январь!$G$9:$G$13)","v":3},{"$f":"SUBTOTAL(103,Январь!$H$9:$H$13)","v":3},{"$f":"SUBTOTAL(103,Январь!$I$9:$I$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$J$9:$J$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$K$9:$K$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$L$9:$L$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$M$9:$M$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$N$9:$N$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$O$9:$O$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$P$9:$P$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$Q$9:$Q$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$R$9:$R$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$S$9:$S$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$T$9:$T$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$U$9:$U$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$V$9:$V$13)","v":2},{"$f":"SUBTOTAL(103,Январь!$W$9:$W$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$X$9:$X$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$Y$9:$Y$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$Z$9:$Z$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$AA$9:$AA$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$AB$9:$AB$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$AC$9:$AC$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$AD$9:$AD$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$AE$9:$AE$13)","v":1},{"$f":"SUBTOTAL(103,Январь!$AF$9:$AF$13)","v":0},{"$f":"SUBTOTAL(103,Январь!$AG$9:$AG$13)","v":1},{"$f":"SUBTOTAL(109,Январь[Всего дней])","v":25}]

{"sheet":"Февраль","index":1,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Февраль"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,1),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,2),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,3),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,4),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,5),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,6),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,7),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,8),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,9),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,10),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,11),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,12),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,13),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,14),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,15),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,16),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,17),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,18),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,19),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,20),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,21),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,22),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,23),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,24),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,25),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,26),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,27),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,28),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,2,29),1),\"ДДД\")","v":"Ср"}]
[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"," ","  ","Всего дней"]
[null,"Павел Безруков",null,null,"О","О","О","О",{"$nulls":6},"О",{"$nulls":18},{"$f":"COUNTA(Февраль[[#This Row],[1]:[29]])","v":5}]
[null,"Илья Глазков",{"$nulls":4},"Б","Б",{"$nulls":4},"ЛО",{"$nulls":8},"Б",{"$nulls":4},"О","О","О",{"$nulls":4},{"$f":"COUNTA(Февраль[[#This Row],[1]:[29]])","v":7}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Февраль[[#This Row],[1]:[29]])","v":0}]
[null,"Руслана Анкудинова",null,null,"Б",{"$nulls":10},"Б",{"$nulls":3},"ЛО",{"$nulls":9},"Б",{"$nulls":3},{"$f":"COUNTA(Февраль[[#This Row],[1]:[29]])","v":4}]
[null,"Мария Маслова",{"$nulls":7},"О","О","О","О",{"$nulls":12},"Б",{"$nulls":7},{"$f":"COUNTA(Февраль[[#This Row],[1]:[29]])","v":5}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Февраль Итог"},{"$f":"SUBTOTAL(103,Февраль[1])","v":0},{"$f":"SUBTOTAL(103,Февраль[2])","v":0},{"$f":"SUBTOTAL(103,Февраль[3])","v":2},{"$f":"SUBTOTAL(103,Февраль[4])","v":1},{"$f":"SUBTOTAL(103,Февраль[5])","v":2},{"$f":"SUBTOTAL(103,Февраль[6])","v":2},{"$f":"SUBTOTAL(103,Февраль[7])","v":0},{"$f":"SUBTOTAL(103,Февраль[8])","v":1},{"$f":"SUBTOTAL(103,Февраль[9])","v":1},{"$f":"SUBTOTAL(103,Февраль[10])","v":1},{"$f":"SUBTOTAL(103,Февраль[11])","v":2},{"$f":"SUBTOTAL(103,Февраль[12])","v":0},{"$f":"SUBTOTAL(103,Февраль[13])","v":1},{"$f":"SUBTOTAL(103,Февраль[14])","v":1},{"$f":"SUBTOTAL(103,Февраль[15])","v":0},{"$f":"SUBTOTAL(103,Февраль[16])","v":0},{"$f":"SUBTOTAL(103,Февраль[17])","v":0},{"$f":"SUBTOTAL(103,Февраль[18])","v":1},{"$f":"SUBTOTAL(103,Февраль[19])","v":0},{"$f":"SUBTOTAL(103,Февраль[20])","v":1},{"$f":"SUBTOTAL(103,Февраль[21])","v":0},{"$f":"SUBTOTAL(103,Февраль[22])","v":0},{"$f":"SUBTOTAL(103,Февраль[23])","v":0},{"$f":"SUBTOTAL(103,Февраль[24])","v":1},{"$f":"SUBTOTAL(103,Февраль[25])","v":1},{"$f":"SUBTOTAL(103,Февраль[26])","v":1},{"$f":"SUBTOTAL(103,Февраль[27])","v":1},{"$f":"SUBTOTAL(103,Февраль[28])","v":1},{"$f":"SUBTOTAL(103,Февраль[29])","v":0},null,null,{"$f":"SUBTOTAL(109,Февраль[Всего дней])","v":21}]

{"sheet":"Март","index":2,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Март"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,1),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,2),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,3),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,4),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,5),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,6),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,7),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,8),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,9),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,10),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,11),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,12),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,13),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,14),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,15),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,16),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,17),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,18),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,19),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,20),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,21),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,22),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,23),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,24),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,25),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,26),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,27),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,28),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,29),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,30),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,3,31),1),\"ДДД\")","v":"Пт"}]
[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,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Март[[#This Row],[1]:[31]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Март[[#This Row],[1]:[31]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Март[[#This Row],[1]:[31]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Март[[#This Row],[1]:[31]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Март[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Март Итог"},{"$f":"SUBTOTAL(103,Март[1])","v":0},{"$f":"SUBTOTAL(103,Март[2])","v":0},{"$f":"SUBTOTAL(103,Март[3])","v":0},{"$f":"SUBTOTAL(103,Март[4])","v":0},{"$f":"SUBTOTAL(103,Март[5])","v":0},{"$f":"SUBTOTAL(103,Март[6])","v":0},{"$f":"SUBTOTAL(103,Март[7])","v":0},{"$f":"SUBTOTAL(103,Март[8])","v":0},{"$f":"SUBTOTAL(103,Март[9])","v":0},{"$f":"SUBTOTAL(103,Март[10])","v":0},{"$f":"SUBTOTAL(103,Март[11])","v":0},{"$f":"SUBTOTAL(103,Март[12])","v":0},{"$f":"SUBTOTAL(103,Март[13])","v":0},{"$f":"SUBTOTAL(103,Март[14])","v":0},{"$f":"SUBTOTAL(103,Март[15])","v":0},{"$f":"SUBTOTAL(103,Март[16])","v":0},{"$f":"SUBTOTAL(103,Март[17])","v":0},{"$f":"SUBTOTAL(103,Март[18])","v":0},{"$f":"SUBTOTAL(103,Март[19])","v":0},{"$f":"SUBTOTAL(103,Март[20])","v":0},{"$f":"SUBTOTAL(103,Март[21])","v":0},{"$f":"SUBTOTAL(103,Март[22])","v":0},{"$f":"SUBTOTAL(103,Март[23])","v":0},{"$f":"SUBTOTAL(103,Март[24])","v":0},{"$f":"SUBTOTAL(103,Март[25])","v":0},{"$f":"SUBTOTAL(103,Март[26])","v":0},{"$f":"SUBTOTAL(103,Март[27])","v":0},{"$f":"SUBTOTAL(103,Март[28])","v":0},{"$f":"SUBTOTAL(103,Март[29])","v":0},{"$f":"SUBTOTAL(109,Март[30])","v":0},{"$f":"SUBTOTAL(109,Март[31])","v":0},{"$f":"SUBTOTAL(109,Март[Всего дней])","v":0}]

{"sheet":"Апрель","index":3,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Апрель"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,1),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,2),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,3),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,4),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,5),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,6),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,7),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,8),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,9),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,10),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,11),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,12),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,13),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,14),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,15),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,16),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,17),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,18),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,19),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,20),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,21),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,22),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,23),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,24),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,25),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,26),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,27),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,28),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,29),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,4,30),1),\"ДДД\")","v":"Вс"}]
[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"," ","Всего дней"]
[null,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Март5[[#This Row],[1]:[ ]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Март5[[#This Row],[1]:[ ]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Март5[[#This Row],[1]:[ ]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Март5[[#This Row],[1]:[ ]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Март5[[#This Row],[1]:[ ]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Апрель Итог"},{"$f":"SUBTOTAL(103,Март5[1])","v":0},{"$f":"SUBTOTAL(103,Март5[2])","v":0},{"$f":"SUBTOTAL(103,Март5[3])","v":0},{"$f":"SUBTOTAL(103,Март5[4])","v":0},{"$f":"SUBTOTAL(103,Март5[5])","v":0},{"$f":"SUBTOTAL(103,Март5[6])","v":0},{"$f":"SUBTOTAL(103,Март5[7])","v":0},{"$f":"SUBTOTAL(103,Март5[8])","v":0},{"$f":"SUBTOTAL(103,Март5[9])","v":0},{"$f":"SUBTOTAL(103,Март5[10])","v":0},{"$f":"SUBTOTAL(103,Март5[11])","v":0},{"$f":"SUBTOTAL(103,Март5[12])","v":0},{"$f":"SUBTOTAL(103,Март5[13])","v":0},{"$f":"SUBTOTAL(103,Март5[14])","v":0},{"$f":"SUBTOTAL(103,Март5[15])","v":0},{"$f":"SUBTOTAL(103,Март5[16])","v":0},{"$f":"SUBTOTAL(103,Март5[17])","v":0},{"$f":"SUBTOTAL(103,Март5[18])","v":0},{"$f":"SUBTOTAL(103,Март5[19])","v":0},{"$f":"SUBTOTAL(103,Март5[20])","v":0},{"$f":"SUBTOTAL(103,Март5[21])","v":0},{"$f":"SUBTOTAL(103,Март5[22])","v":0},{"$f":"SUBTOTAL(103,Март5[23])","v":0},{"$f":"SUBTOTAL(103,Март5[24])","v":0},{"$f":"SUBTOTAL(103,Март5[25])","v":0},{"$f":"SUBTOTAL(103,Март5[26])","v":0},{"$f":"SUBTOTAL(103,Март5[27])","v":0},{"$f":"SUBTOTAL(103,Март5[28])","v":0},{"$f":"SUBTOTAL(103,Март5[29])","v":0},{"$f":"SUBTOTAL(109,Март5[30])","v":0},{"$f":"SUBTOTAL(109,Март5[[ ]])","v":0},{"$f":"SUBTOTAL(109,Март5[Всего дней])","v":0}]

{"sheet":"Май","index":4,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Май"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,1),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,2),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,3),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,4),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,5),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,6),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,7),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,8),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,9),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,10),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,11),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,12),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,13),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,14),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,15),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,16),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,17),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,18),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,19),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,20),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,21),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,22),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,23),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,24),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,25),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,26),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,27),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,28),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,29),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,30),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,5,31),1),\"ДДД\")","v":"Ср"}]
[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,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Март58[[#This Row],[1]:[31]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Март58[[#This Row],[1]:[31]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Март58[[#This Row],[1]:[31]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Март58[[#This Row],[1]:[31]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Март58[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Обозначение причины отсутствия Итог"},{"$f":"SUBTOTAL(103,Март58[1])","v":0},{"$f":"SUBTOTAL(103,Март58[2])","v":0},{"$f":"SUBTOTAL(103,Март58[3])","v":0},{"$f":"SUBTOTAL(103,Март58[4])","v":0},{"$f":"SUBTOTAL(103,Март58[5])","v":0},{"$f":"SUBTOTAL(103,Март58[6])","v":0},{"$f":"SUBTOTAL(103,Март58[7])","v":0},{"$f":"SUBTOTAL(103,Март58[8])","v":0},{"$f":"SUBTOTAL(103,Март58[9])","v":0},{"$f":"SUBTOTAL(103,Март58[10])","v":0},{"$f":"SUBTOTAL(103,Март58[11])","v":0},{"$f":"SUBTOTAL(103,Март58[12])","v":0},{"$f":"SUBTOTAL(103,Март58[13])","v":0},{"$f":"SUBTOTAL(103,Март58[14])","v":0},{"$f":"SUBTOTAL(103,Март58[15])","v":0},{"$f":"SUBTOTAL(103,Март58[16])","v":0},{"$f":"SUBTOTAL(103,Март58[17])","v":0},{"$f":"SUBTOTAL(103,Март58[18])","v":0},{"$f":"SUBTOTAL(103,Март58[19])","v":0},{"$f":"SUBTOTAL(103,Март58[20])","v":0},{"$f":"SUBTOTAL(103,Март58[21])","v":0},{"$f":"SUBTOTAL(103,Март58[22])","v":0},{"$f":"SUBTOTAL(103,Март58[23])","v":0},{"$f":"SUBTOTAL(103,Март58[24])","v":0},{"$f":"SUBTOTAL(103,Март58[25])","v":0},{"$f":"SUBTOTAL(103,Март58[26])","v":0},{"$f":"SUBTOTAL(103,Март58[27])","v":0},{"$f":"SUBTOTAL(103,Март58[28])","v":0},{"$f":"SUBTOTAL(103,Март58[29])","v":0},{"$f":"SUBTOTAL(109,Март58[30])","v":0},{"$f":"SUBTOTAL(109,Март58[31])","v":0},{"$f":"SUBTOTAL(109,Март58[Всего дней])","v":0}]

{"sheet":"Июнь","index":5,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Июнь"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,1),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,2),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,3),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,4),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,5),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,6),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,7),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,8),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,9),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,10),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,11),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,12),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,13),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,14),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,15),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,16),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,17),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,18),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,19),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,20),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,21),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,22),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,23),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,24),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,25),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,26),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,27),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,28),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,29),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,6,30),1),\"ДДД\")","v":"Пт"}]
[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"," ","Всего дней"]
[null,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Июнь[[#This Row],[1]:[ ]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Июнь[[#This Row],[1]:[ ]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Июнь[[#This Row],[1]:[ ]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Июнь[[#This Row],[1]:[ ]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Июнь[[#This Row],[1]:[ ]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Июнь Итог"},{"$f":"SUBTOTAL(103,Июнь[1])","v":0},{"$f":"SUBTOTAL(103,Июнь[2])","v":0},{"$f":"SUBTOTAL(103,Июнь[3])","v":0},{"$f":"SUBTOTAL(103,Июнь[4])","v":0},{"$f":"SUBTOTAL(103,Июнь[5])","v":0},{"$f":"SUBTOTAL(103,Июнь[6])","v":0},{"$f":"SUBTOTAL(103,Июнь[7])","v":0},{"$f":"SUBTOTAL(103,Июнь[8])","v":0},{"$f":"SUBTOTAL(103,Июнь[9])","v":0},{"$f":"SUBTOTAL(103,Июнь[10])","v":0},{"$f":"SUBTOTAL(103,Июнь[11])","v":0},{"$f":"SUBTOTAL(103,Июнь[12])","v":0},{"$f":"SUBTOTAL(103,Июнь[13])","v":0},{"$f":"SUBTOTAL(103,Июнь[14])","v":0},{"$f":"SUBTOTAL(103,Июнь[15])","v":0},{"$f":"SUBTOTAL(103,Июнь[16])","v":0},{"$f":"SUBTOTAL(103,Июнь[17])","v":0},{"$f":"SUBTOTAL(103,Июнь[18])","v":0},{"$f":"SUBTOTAL(103,Июнь[19])","v":0},{"$f":"SUBTOTAL(103,Июнь[20])","v":0},{"$f":"SUBTOTAL(103,Июнь[21])","v":0},{"$f":"SUBTOTAL(103,Июнь[22])","v":0},{"$f":"SUBTOTAL(103,Июнь[23])","v":0},{"$f":"SUBTOTAL(103,Июнь[24])","v":0},{"$f":"SUBTOTAL(103,Июнь[25])","v":0},{"$f":"SUBTOTAL(103,Июнь[26])","v":0},{"$f":"SUBTOTAL(103,Июнь[27])","v":0},{"$f":"SUBTOTAL(103,Июнь[28])","v":0},{"$f":"SUBTOTAL(103,Июнь[29])","v":0},{"$f":"SUBTOTAL(109,Июнь[30])","v":0},{"$f":"SUBTOTAL(109,Июнь[[ ]])","v":0},{"$f":"SUBTOTAL(109,Июнь[Всего дней])","v":0}]

{"sheet":"Июль","index":6,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Июль"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,1),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,2),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,3),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,4),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,5),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,6),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,7),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,8),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,9),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,10),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,11),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,12),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,13),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,14),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,15),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,16),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,17),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,18),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,19),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,20),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,21),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,22),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,23),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,24),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,25),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,26),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,27),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,28),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,29),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,30),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,7,31),1),\"ДДД\")","v":"Пн"}]
[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,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Июль[[#This Row],[1]:[31]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Июль[[#This Row],[1]:[31]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Июль[[#This Row],[1]:[31]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Июль[[#This Row],[1]:[31]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Июль[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Июль Итог"},{"$f":"SUBTOTAL(103,Июль[1])","v":0},{"$f":"SUBTOTAL(103,Июль[2])","v":0},{"$f":"SUBTOTAL(103,Июль[3])","v":0},{"$f":"SUBTOTAL(103,Июль[4])","v":0},{"$f":"SUBTOTAL(103,Июль[5])","v":0},{"$f":"SUBTOTAL(103,Июль[6])","v":0},{"$f":"SUBTOTAL(103,Июль[7])","v":0},{"$f":"SUBTOTAL(103,Июль[8])","v":0},{"$f":"SUBTOTAL(103,Июль[9])","v":0},{"$f":"SUBTOTAL(103,Июль[10])","v":0},{"$f":"SUBTOTAL(103,Июль[11])","v":0},{"$f":"SUBTOTAL(103,Июль[12])","v":0},{"$f":"SUBTOTAL(103,Июль[13])","v":0},{"$f":"SUBTOTAL(103,Июль[14])","v":0},{"$f":"SUBTOTAL(103,Июль[15])","v":0},{"$f":"SUBTOTAL(103,Июль[16])","v":0},{"$f":"SUBTOTAL(103,Июль[17])","v":0},{"$f":"SUBTOTAL(103,Июль[18])","v":0},{"$f":"SUBTOTAL(103,Июль[19])","v":0},{"$f":"SUBTOTAL(103,Июль[20])","v":0},{"$f":"SUBTOTAL(103,Июль[21])","v":0},{"$f":"SUBTOTAL(103,Июль[22])","v":0},{"$f":"SUBTOTAL(103,Июль[23])","v":0},{"$f":"SUBTOTAL(103,Июль[24])","v":0},{"$f":"SUBTOTAL(103,Июль[25])","v":0},{"$f":"SUBTOTAL(103,Июль[26])","v":0},{"$f":"SUBTOTAL(103,Июль[27])","v":0},{"$f":"SUBTOTAL(103,Июль[28])","v":0},{"$f":"SUBTOTAL(103,Июль[29])","v":0},{"$f":"SUBTOTAL(109,Июль[30])","v":0},{"$f":"SUBTOTAL(109,Июль[31])","v":0},{"$f":"SUBTOTAL(109,Июль[Всего дней])","v":0}]

{"sheet":"Август","index":7,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Август"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,1),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,2),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,3),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,4),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,5),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,6),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,7),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,8),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,9),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,10),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,11),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,12),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,13),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,14),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,15),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,16),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,17),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,18),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,19),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,20),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,21),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,22),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,23),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,24),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,25),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,26),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,27),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,28),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,29),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,30),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,8,31),1),\"ДДД\")","v":"Чт"}]
[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,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Август[[#This Row],[1]:[31]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Август[[#This Row],[1]:[31]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Август[[#This Row],[1]:[31]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Август[[#This Row],[1]:[31]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Август[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Август Итог"},{"$f":"SUBTOTAL(103,Август[1])","v":0},{"$f":"SUBTOTAL(103,Август[2])","v":0},{"$f":"SUBTOTAL(103,Август[3])","v":0},{"$f":"SUBTOTAL(103,Август[4])","v":0},{"$f":"SUBTOTAL(103,Август[5])","v":0},{"$f":"SUBTOTAL(103,Август[6])","v":0},{"$f":"SUBTOTAL(103,Август[7])","v":0},{"$f":"SUBTOTAL(103,Август[8])","v":0},{"$f":"SUBTOTAL(103,Август[9])","v":0},{"$f":"SUBTOTAL(103,Август[10])","v":0},{"$f":"SUBTOTAL(103,Август[11])","v":0},{"$f":"SUBTOTAL(103,Август[12])","v":0},{"$f":"SUBTOTAL(103,Август[13])","v":0},{"$f":"SUBTOTAL(103,Август[14])","v":0},{"$f":"SUBTOTAL(103,Август[15])","v":0},{"$f":"SUBTOTAL(103,Август[16])","v":0},{"$f":"SUBTOTAL(103,Август[17])","v":0},{"$f":"SUBTOTAL(103,Август[18])","v":0},{"$f":"SUBTOTAL(103,Август[19])","v":0},{"$f":"SUBTOTAL(103,Август[20])","v":0},{"$f":"SUBTOTAL(103,Август[21])","v":0},{"$f":"SUBTOTAL(103,Август[22])","v":0},{"$f":"SUBTOTAL(103,Август[23])","v":0},{"$f":"SUBTOTAL(103,Август[24])","v":0},{"$f":"SUBTOTAL(103,Август[25])","v":0},{"$f":"SUBTOTAL(103,Август[26])","v":0},{"$f":"SUBTOTAL(103,Август[27])","v":0},{"$f":"SUBTOTAL(103,Август[28])","v":0},{"$f":"SUBTOTAL(103,Август[29])","v":0},{"$f":"SUBTOTAL(109,Август[30])","v":0},{"$f":"SUBTOTAL(109,Август[31])","v":0},{"$f":"SUBTOTAL(109,Август[Всего дней])","v":0}]

{"sheet":"Сентябрь","index":8,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Сентябрь"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,1),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,2),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,3),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,4),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,5),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,6),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,7),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,8),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,9),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,10),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,11),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,12),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,13),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,14),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,15),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,16),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,17),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,18),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,19),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,20),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,21),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,22),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,23),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,24),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,25),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,26),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,27),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,28),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,29),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,9,30),1),\"ДДД\")","v":"Сб"}]
[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"," ","Всего дней"]
[null,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Сентябрь[[#This Row],[1]:[ ]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Сентябрь[[#This Row],[1]:[ ]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Сентябрь[[#This Row],[1]:[ ]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Сентябрь[[#This Row],[1]:[ ]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Сентябрь[[#This Row],[1]:[ ]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Сентябрь Итог"},{"$f":"SUBTOTAL(103,Сентябрь[1])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[2])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[3])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[4])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[5])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[6])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[7])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[8])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[9])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[10])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[11])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[12])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[13])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[14])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[15])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[16])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[17])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[18])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[19])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[20])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[21])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[22])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[23])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[24])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[25])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[26])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[27])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[28])","v":0},{"$f":"SUBTOTAL(103,Сентябрь[29])","v":0},{"$f":"SUBTOTAL(109,Сентябрь[30])","v":0},{"$f":"SUBTOTAL(109,Сентябрь[[ ]])","v":0},{"$f":"SUBTOTAL(109,Сентябрь[Всего дней])","v":0}]

{"sheet":"Октябрь","index":9,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Октябрь"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,1),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,2),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,3),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,4),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,5),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,6),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,7),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,8),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,9),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,10),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,11),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,12),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,13),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,14),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,15),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,16),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,17),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,18),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,19),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,20),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,21),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,22),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,23),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,24),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,25),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,26),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,27),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,28),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,29),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,30),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,10,31),1),\"ДДД\")","v":"Вт"}]
[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,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Октябрь[[#This Row],[1]:[31]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Октябрь[[#This Row],[1]:[31]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Октябрь[[#This Row],[1]:[31]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Октябрь[[#This Row],[1]:[31]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Октябрь[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Октябрь Итог"},{"$f":"SUBTOTAL(103,Октябрь[1])","v":0},{"$f":"SUBTOTAL(103,Октябрь[2])","v":0},{"$f":"SUBTOTAL(103,Октябрь[3])","v":0},{"$f":"SUBTOTAL(103,Октябрь[4])","v":0},{"$f":"SUBTOTAL(103,Октябрь[5])","v":0},{"$f":"SUBTOTAL(103,Октябрь[6])","v":0},{"$f":"SUBTOTAL(103,Октябрь[7])","v":0},{"$f":"SUBTOTAL(103,Октябрь[8])","v":0},{"$f":"SUBTOTAL(103,Октябрь[9])","v":0},{"$f":"SUBTOTAL(103,Октябрь[10])","v":0},{"$f":"SUBTOTAL(103,Октябрь[11])","v":0},{"$f":"SUBTOTAL(103,Октябрь[12])","v":0},{"$f":"SUBTOTAL(103,Октябрь[13])","v":0},{"$f":"SUBTOTAL(103,Октябрь[14])","v":0},{"$f":"SUBTOTAL(103,Октябрь[15])","v":0},{"$f":"SUBTOTAL(103,Октябрь[16])","v":0},{"$f":"SUBTOTAL(103,Октябрь[17])","v":0},{"$f":"SUBTOTAL(103,Октябрь[18])","v":0},{"$f":"SUBTOTAL(103,Октябрь[19])","v":0},{"$f":"SUBTOTAL(103,Октябрь[20])","v":0},{"$f":"SUBTOTAL(103,Октябрь[21])","v":0},{"$f":"SUBTOTAL(103,Октябрь[22])","v":0},{"$f":"SUBTOTAL(103,Октябрь[23])","v":0},{"$f":"SUBTOTAL(103,Октябрь[24])","v":0},{"$f":"SUBTOTAL(103,Октябрь[25])","v":0},{"$f":"SUBTOTAL(103,Октябрь[26])","v":0},{"$f":"SUBTOTAL(103,Октябрь[27])","v":0},{"$f":"SUBTOTAL(103,Октябрь[28])","v":0},{"$f":"SUBTOTAL(103,Октябрь[29])","v":0},{"$f":"SUBTOTAL(109,Октябрь[30])","v":0},{"$f":"SUBTOTAL(109,Октябрь[31])","v":0},{"$f":"SUBTOTAL(109,Октябрь[Всего дней])","v":0}]

{"sheet":"Ноябрь","index":10,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Ноябрь"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,1),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,2),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,3),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,4),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,5),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,6),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,7),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,8),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,9),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,10),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,11),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,12),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,13),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,14),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,15),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,16),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,17),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,18),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,19),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,20),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,21),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,22),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,23),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,24),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,25),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,26),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,27),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,28),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,29),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,11,30),1),\"ДДД\")","v":"Чт"}]
[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"," ","Всего дней"]
[null,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Ноябрь[[#This Row],[1]:[ ]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Ноябрь[[#This Row],[1]:[ ]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Ноябрь[[#This Row],[1]:[ ]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Ноябрь[[#This Row],[1]:[ ]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Ноябрь[[#This Row],[1]:[ ]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Ноябрь Итог"},{"$f":"SUBTOTAL(103,Ноябрь[1])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[2])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[3])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[4])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[5])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[6])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[7])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[8])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[9])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[10])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[11])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[12])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[13])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[14])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[15])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[16])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[17])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[18])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[19])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[20])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[21])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[22])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[23])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[24])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[25])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[26])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[27])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[28])","v":0},{"$f":"SUBTOTAL(103,Ноябрь[29])","v":0},{"$f":"SUBTOTAL(109,Ноябрь[30])","v":0},{"$f":"SUBTOTAL(109,Ноябрь[[ ]])","v":0},{"$f":"SUBTOTAL(109,Ноябрь[Всего дней])","v":0}]

{"sheet":"Декабрь","index":11,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,10],[3,12,3,14],[3,16,3,20],[3,22,3,26],[5,2,5,32]]}
[null,"График отсутствия сотрудников"]
[null,"Декабрь"]
[]
[null,"Обозначение причины отсутствия","О","Отпуск",null,"ЛО","Личные обстоятельства",{"$nulls":4},"Б","Больничный",{"$nulls":3},"Собственная причина 1",{"$nulls":5},"Собственная причина 2"]
[]
[null,null,"Даты отсутствия",{"$nulls":30},{"$f":"ГодКалендаря","v":2023}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,1),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,2),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,3),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,4),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,5),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,6),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,7),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,8),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,9),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,10),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,11),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,12),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,13),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,14),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,15),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,16),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,17),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,18),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,19),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,20),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,21),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,22),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,23),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,24),1),\"ДДД\")","v":"Вс"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,25),1),\"ДДД\")","v":"Пн"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,26),1),\"ДДД\")","v":"Вт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,27),1),\"ДДД\")","v":"Ср"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,28),1),\"ДДД\")","v":"Чт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,29),1),\"ДДД\")","v":"Пт"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,30),1),\"ДДД\")","v":"Сб"},{"$f":"TEXT(WEEKDAY(DATE(ГодКалендаря,12,31),1),\"ДДД\")","v":"Вс"}]
[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,"Павел Безруков",{"$nulls":31},{"$f":"COUNTA(Декабрь[[#This Row],[1]:[31]])","v":0}]
[null,"Илья Глазков",{"$nulls":31},{"$f":"COUNTA(Декабрь[[#This Row],[1]:[31]])","v":0}]
[null,"Виталий Дегтярев",{"$nulls":31},{"$f":"COUNTA(Декабрь[[#This Row],[1]:[31]])","v":0}]
[null,"Руслана Анкудинова",{"$nulls":31},{"$f":"COUNTA(Декабрь[[#This Row],[1]:[31]])","v":0}]
[null,"Мария Маслова",{"$nulls":31},{"$f":"COUNTA(Декабрь[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"ИмяМесяца&\" Итог\"","v":"Декабрь Итог"},{"$f":"SUBTOTAL(103,Декабрь[1])","v":0},{"$f":"SUBTOTAL(103,Декабрь[2])","v":0},{"$f":"SUBTOTAL(103,Декабрь[3])","v":0},{"$f":"SUBTOTAL(103,Декабрь[4])","v":0},{"$f":"SUBTOTAL(103,Декабрь[5])","v":0},{"$f":"SUBTOTAL(103,Декабрь[6])","v":0},{"$f":"SUBTOTAL(103,Декабрь[7])","v":0},{"$f":"SUBTOTAL(103,Декабрь[8])","v":0},{"$f":"SUBTOTAL(103,Декабрь[9])","v":0},{"$f":"SUBTOTAL(103,Декабрь[10])","v":0},{"$f":"SUBTOTAL(103,Декабрь[11])","v":0},{"$f":"SUBTOTAL(103,Декабрь[12])","v":0},{"$f":"SUBTOTAL(103,Декабрь[13])","v":0},{"$f":"SUBTOTAL(103,Декабрь[14])","v":0},{"$f":"SUBTOTAL(103,Декабрь[15])","v":0},{"$f":"SUBTOTAL(103,Декабрь[16])","v":0},{"$f":"SUBTOTAL(103,Декабрь[17])","v":0},{"$f":"SUBTOTAL(103,Декабрь[18])","v":0},{"$f":"SUBTOTAL(103,Декабрь[19])","v":0},{"$f":"SUBTOTAL(103,Декабрь[20])","v":0},{"$f":"SUBTOTAL(103,Декабрь[21])","v":0},{"$f":"SUBTOTAL(103,Декабрь[22])","v":0},{"$f":"SUBTOTAL(103,Декабрь[23])","v":0},{"$f":"SUBTOTAL(103,Декабрь[24])","v":0},{"$f":"SUBTOTAL(103,Декабрь[25])","v":0},{"$f":"SUBTOTAL(103,Декабрь[26])","v":0},{"$f":"SUBTOTAL(103,Декабрь[27])","v":0},{"$f":"SUBTOTAL(103,Декабрь[28])","v":0},{"$f":"SUBTOTAL(103,Декабрь[29])","v":0},{"$f":"SUBTOTAL(109,Декабрь[30])","v":0},{"$f":"SUBTOTAL(109,Декабрь[31])","v":0},{"$f":"SUBTOTAL(109,Декабрь[Всего дней])","v":0}]

{"sheet":"Имена сотрудников","index":12,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Имена сотрудников"]
[]
[null,"Имена сотрудников"]
[null,"Павел Безруков"]
[null,"Илья Глазков"]
[null,"Виталий Дегтярев"]
[null,"Руслана Анкудинова"]
[null,"Мария Маслова"]