{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":8,"n_cols":49,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,4,5,34],[2,36,2,42],[2,43,4,43],[2,44,2,46],[2,47,4,47],[2,35,3,35],[3,41,4,41],[3,42,4,42],[3,44,4,44],[3,45,4,45],[3,46,4,46],[2,48,4,48],[3,36,4,36],[3,37,4,37],[3,38,4,38],[3,39,4,39],[3,40,4,40],[0,0,0,7],[1,0,1,7],[2,0,4,0],[2,3,4,3],[2,4,3,34]]}
["Норма времени при 40 часовой рабочей неделе 160 часов 25 дня"]
["Норма времени при 36 часовой рабочей неделе 144 час 20 дня"]
["номер по порядку",null,null,"Табельный номер","отметки о явках и неявках на работу по числам месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Дни","Дни неявок на работу по причинам",null,null,null,null,null,null,"количество выходных и праздничных дней","Отработано часов",null,null,"Командировочные дни [жёлтые]","Командировочные часы [жёлтые]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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]
[1,2,null,3,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,5,6,7,8,9,10,11,12,13,14,15,16]
[1,"Иванов Иван Иванович","Управляющий отделением",null,5,8,7,7,7,"б/с",6,5,8,7,7,7,6,6,5,"В",7,7,7,7,6,5,"В",7,7,7,7,null,null,null,null,{"$f":"COUNT(E7:AI7)","v":24},{"$f":"COUNTIF(B7:AI7,\"О\")","v":0},{"$f":"COUNTIF(D7:AH7,\"Мо\")","v":0},{"$f":"COUNTIF(E7:AI7,\"Б\")","v":0},{"$f":"COUNTIF(E7:AI7,\"б/с\")","v":1},null,null,{"$f":"COUNTIF(E7:AI7,\"НН\")","v":0},{"$f":"COUNTIF(E7:AI7,\"В\")","v":2},{"$f":"SUM(E7:AI7)","v":158},{"$f":"SUM(F7,M7,T7,AA7,AH7)","v":16},null,{"$f":"COUNTIF(E8:AI8,6)","v":3},{"$f":"SUMIF(E8:AI8,6,E7:AI7)","v":21}]
[null,null,null,null,{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":6},{"$f":"ЦветГ","v":6},{"$f":"ЦветГ","v":6},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":0},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":35},{"$f":"ЦветГ","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Суммирование дней по цвету ячеек","Суммирование часов по цвету ячеек"]