{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":16,"n_cols":45,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,7],[1,25,1,39],[2,25,2,39],[4,0,4,39],[7,6,7,9],[7,10,7,13],[7,15,7,22],[8,2,9,5],[8,10,9,13],[8,15,8,18],[8,19,8,22],[9,15,9,18],[9,19,9,22],[12,11,13,11],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,27,13,27],[12,28,13,28],[12,29,13,29],[12,18,13,18],[12,19,13,19],[12,20,13,20],[12,21,13,21],[12,22,13,22],[12,23,13,23],[14,0,15,0],[14,1,15,1],[12,24,13,24],[12,25,13,25],[12,26,13,26],[12,12,13,12],[12,13,13,13],[12,14,13,14],[12,15,13,15],[12,16,13,16],[12,17,13,17],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,30,13,30],[12,31,13,31],[12,32,13,32],[12,33,12,39],[12,40,13,40]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"УТВЕРЖДАЮ"]
["НОРМА дней: 27 рабочих дня/ 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,"Дата составления",null,null,null,null,"Отчетный период"]
[null,null,"ТАБЕЛЬ",null,null,null,null,null,null,null,"2015-12-31",null,null,null,null,"с",null,null,null,"по"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-01",null,null,null,{"$f":"EOMONTH(P10,0)","v":"2016-02-29"}]
[null,null,null,null,null,null,"учета рабочего времени"]
[]
["Ф.И.О.","Должность",{"$f":"IF($P10+COLUMN()-3<=$T10,$P10+COLUMN()-3,2)","v":"2016-02-01"},"2016-02-02","2016-02-03","2016-02-04","2016-02-05","2016-02-06","2016-02-07","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-13","2016-02-14","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-20","2016-02-21","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28","2016-02-29","1900-01-02","1900-01-02","Кол-во дней",null,null,null,null,null,null,"Всего отраб. часов"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"рабочих","выходных","отпуск","не явка","командировка","болезнь","отпуск"]
["Иванов И.И.","зав.складом",8,null,null,5,null,null,null,null,8,null,null,8,null,null,null,"Б",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(C15:AG15)","v":4},{"$f":"COUNTIF(C$13:AG$14,\">2\")-COUNTA(C15:AG15)","v":"1900-01-24"},{"$f":"COUNTIF(C15:AG15,\"О\")","v":0},{"$f":"COUNTIF(C15:AG15,\"А\")","v":0},{"$f":"COUNTIF(C15:AG15,\"К\")","v":0},{"$f":"COUNTIF(C15:AG15,\"Б\")","v":1},{"$f":"COUNTIF(D15:AH15,\"О\")","v":0},{"$f":"SUM(C15:AG15)","v":29},null,null,{"$f":"SUM(IF(ISNUMBER(C15:AG15),C15:AG15/IF((WORKDAY(C$13:AG$13-1,1,Лист2!$A$2:$A$16)<>C$13:AG$13)-(C$13:AG$13=Лист2!$B$2),5,8)))","v":3.625},{"$f":"SUMPRODUCT(IF(ISNUMBER(C15:AG15),C15:AG15/IF((WEEKDAY(C$13:AG$13,2)>5)+ISNUMBER(MATCH(C$13:AG$13,Лист2!$A$2:$A$16,))-(C$13:AG$13=Лист2!$B$2),5,8)))","v":3.625}]
[null,null,null,null,null,null,null,null,null,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":"COUNT(C16:AG16)","v":0},null,{"$f":"COUNTIF(C16:AG16,\"О\")","v":0},{"$f":"COUNTIF(C16:AG16,\"А\")","v":0},{"$f":"COUNTIF(C16:AG16,\"К\")","v":0},null,null,{"$f":"SUM(C16:AH16)","v":0},null,null,{"$f":"SUM(C16:AG16/IF((WORKDAY(C$13:AG$13-1,1,Лист2!$A$2:$A$16)<>C$13:AG$13)-(C$13:AG$13=Лист2!$B$2),5,8))","v":0},{"$f":"SUMPRODUCT(C16:AG16/IF((WEEKDAY(C$13:AG$13,2)>5)+ISNUMBER(MATCH(C$13:AG$13,Лист2!$A$2:$A$16,))-(C$13:AG$13=Лист2!$B$2),5,8))","v":0}]

{"sheet":"Лист2","index":1,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Праздники","Рабочие"]
["2016-01-01","2016-02-20"]
["2016-01-04"]
["2016-01-05"]
["2016-01-06"]
["2016-01-07"]
["2016-01-08"]
["2016-02-22"]
["2016-02-23"]
["2016-03-07"]
["2016-03-08"]
["2016-05-02"]
["2016-05-03"]
["2016-05-09"]
["2016-06-13"]
["2016-11-04"]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}