{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Настройки","июнь 2017"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Настройки","index":0,"n_rows":12,"n_cols":35,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,4,0,5],[3,4,3,5]]}
["№","ФИО сотрудника","Должность","Норма раб. дня  (часов)","Настройки",null,null,null,null,"январь",2014]
[1,"Иванов Иван Иванович","Директор",8,"Год",2017,null,null,null,"февраль",2015,8,{"$f":"\"  - рабочий день (обозначение - количество часов)\"","v":"  - рабочий день (обозначение - количество часов)"},null,null,null,null,null,null,null,null,null,null,"оп",{"$f":"\"  - отпуск (обозначение - оп)\"","v":"  - отпуск (обозначение - оп)"},null,null,null,null,null,null,null,null,"б",{"$f":"\"  - больничных (обозначение - буква б)\"","v":"  - больничных (обозначение - буква б)"}]
[2,"Петров Петр Петрович","Зам. Директора",8,"Месяц","июнь",null,null,null,"март",2016,"пр",{"$f":"\"  - праздничный день (обозначение - пр)\"","v":"  - праздничный день (обозначение - пр)"},null,null,null,null,null,null,null,null,null,null,"ог",{"$f":"\"  - отгул (обозначение - ог)\"","v":"  - отгул (обозначение - ог)"},null,null,null,null,null,null,null,null,"у",{"$f":"\"  - учебный отпуск (обозначение - у)\"","v":"  - учебный отпуск (обозначение - у)"}]
[3,"Зайцев Алексей Игоревич","Бухгалтер",8,"Расчетные столбцы:",null,null,null,null,"апрель",2017,"пг",{"$f":"\"  - прогул (обозначение -пг)\"","v":"  - прогул (обозначение -пг)"},null,null,null,null,null,null,null,null,null,null,"обс",{"$f":"\"  - отпуск без содержания (обозначение - обс)\"","v":"  - отпуск без содержания (обозначение - обс)"},null,null,null,null,null,null,null,null,"к",{"$f":"\"  - командировка (обозначение - буква к)\"","v":"  - командировка (обозначение - буква к)"}]
[4,"Волкой Михаил Алексеевич","Экономист планового отдела",8,"Переработка","Да",null,null,null,"май",2018]
[5,"Львов Лев Львович","Программист",12,"Недоработка","Да",null,null,null,"июнь",2019]
[6,null,null,null,"Отгулы","Да",null,null,null,"июль",2020]
[null,null,null,null,"Праздничные дни","Да",null,null,null,"август",2021]
[null,null,null,null,"Прогулы","Да",null,null,null,"сентябрь",2022]
[null,null,null,null,"Отпуск без содержания","Да",null,null,null,"октябрь",2023]
[null,null,null,null,"Учебный отпуск","Да",null,null,null,"ноябрь",2024]
[null,null,null,null,"Дней командировки","Да",null,null,null,"декабрь",2025]

{"sheet":"июнь 2017","index":1,"n_rows":11,"n_cols":46,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,42,4,42],[3,43,4,43],[3,44,4,44],[3,45,4,45],[3,40,4,40],[3,41,4,41],[0,0,2,3],[3,36,4,36],[3,37,4,37],[3,38,4,38],[3,39,4,39],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,34,4,34],[3,35,4,35]]}
["июнь 2017",null,null,null,8,{"$f":"\"  - рабочий день (обозначение - количество часов)\"","v":"  - рабочий день (обозначение - количество часов)"},null,null,null,null,null,null,null,null,null,null,"оп",{"$f":"\"  - отпуск (обозначение - оп)\"","v":"  - отпуск (обозначение - оп)"},null,null,null,null,null,null,null,null,"б",{"$f":"\"  - больничных (обозначение - буква б)\"","v":"  - больничных (обозначение - буква б)"}]
[null,null,null,null,"пр",{"$f":"\"  - праздничный день (обозначение - пр)\"","v":"  - праздничный день (обозначение - пр)"},null,null,null,null,null,null,null,null,null,null,"ог",{"$f":"\"  - отгул (обозначение - ог)\"","v":"  - отгул (обозначение - ог)"},null,null,null,null,null,null,null,null,"у",{"$f":"\"  - учебный отпуск (обозначение - у)\"","v":"  - учебный отпуск (обозначение - у)"}]
[null,null,null,null,"пг",{"$f":"\"  - прогул (обозначение -пг)\"","v":"  - прогул (обозначение -пг)"},null,null,null,null,null,null,null,null,null,null,"обс",{"$f":"\"  - отпуск без содержания (обозначение - обс)\"","v":"  - отпуск без содержания (обозначение - обс)"},null,null,null,null,null,null,null,null,"к",{"$f":"\"  - командировка (обозначение - буква к)\"","v":"  - командировка (обозначение - буква к)"}]
["№","сотрудник","должность","раб. день (ч.)","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","рабочих дней","рабочих часов","дней отпуска","дней больнич","перераб. часов","недораб. часов","отгулов","праздн. дней","прогулов дней","отп. без содержан","учебного отпуска","дней командировки"]
[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]
[1,"Иванов Иван Иванович","Директор","08:00:00","08:15:00","07:40:00","09:00:00",null,null,null,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":"COUNTIF(E6:AH6,\">0\")","v":3},{"$f":"SUM(E6:AH6)","v":1.0381944444444444},{"$f":"COUNTIF(E6:AH6,\"=оп\")","v":0},{"$f":"COUNTIF(E6:AH6,\"=б\")","v":0},{"$f":"IF(D6=\"\",0,IF(AJ6-AI6*D6<0,0,AJ6-AI6*D6))","v":3.819444444444442E-2},{"$f":"IF(D6=\"\",0,IF(AI6*D6-AJ6<0,0,AI6*D6-AJ6))","v":0},{"$f":"COUNTIF(E6:AH6,\"=ог\")","v":0},{"$f":"COUNTIF(E6:AH6,\"=пр\")","v":0},{"$f":"COUNTIF(E6:AH6,\"=пг\")","v":0},{"$f":"COUNTIF(E6:AH6,\"=обс\")","v":0},{"$f":"COUNTIF(E6:AH6,\"=у\")","v":0},{"$f":"COUNTIF(E6:AH6,\"=к\")","v":0}]
[2,"Петров Петр Петрович","Зам. Директора","08:00:00","08:00:00","09:00:00","09:00:00",null,null,null,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,{"$f":"SUM(E7:AH7)","v":1.0833333333333333},0,0,{"$f":"IF(D7=\"\",0,IF(AJ7-AI7*D7<0,0,AJ7-AI7*D7))","v":8.3333333333333259E-2},{"$f":"IF(D7=\"\",0,IF(AI7*D7-AJ7<0,0,AI7*D7-AJ7))","v":0},0,0,0,0,0,0]
[3,"Зайцев Алексей Игоревич","Бухгалтер","08:00:00","05:00:00","06:00:00",null,null,null,null,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,0.45833333333333337,0,0,0,0.20833333333333326,0,0,0,0,0,0]
[4,"Волкой Михаил Алексеевич","Экономист планового отдела","08:00:00",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,1,1,0,0,0.66666666666666674,0,0,0,0,0,0,0]
[5,"Львов Лев Львович","Программист","12:00:00",null,null,null,null,null,null,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,0,0,0,0,0,0,0,0,0,0,0]
[6,null,null,null,null,null,null,null,null,null,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,0,0,0,0,0,0,0,0,0,0,0]