{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Табель учёта рабочего времени","Структура","всяки"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"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":123,"n_cols":43,"rows_kept":123,"cut":false,"hidden":false,"merged":[[91,22,91,27],[90,3,93,3],[94,3,97,3],[23,3,26,3],[27,3,30,3],[31,3,34,3],[35,3,38,3],[39,3,42,3],[97,39,97,43],[90,39,93,43],[94,29,94,33],[94,34,94,38],[94,39,94,43],[83,29,83,33],[83,34,83,38],[83,39,83,43],[84,29,84,33],[84,34,84,38],[84,39,84,43],[86,28,87,43],[78,29,78,33],[78,34,78,38],[78,39,78,43],[75,29,75,33],[75,34,75,38],[75,39,75,43],[76,29,76,33],[76,34,76,38],[89,4,89,19],[89,29,89,33],[89,34,89,38],[89,39,89,43],[77,29,77,33],[73,29,73,33],[69,29,69,33],[65,29,65,33],[61,29,61,33],[57,29,57,33],[53,29,53,33],[44,28,45,43],[46,29,49,33],[77,34,77,38],[77,39,77,43],[76,39,76,43],[73,34,73,38],[73,39,73,43],[74,29,74,33],[74,34,74,38],[74,39,74,43],[71,29,71,33],[71,34,71,38],[71,39,71,43],[72,29,72,33],[72,34,72,38],[72,39,72,43],[69,34,69,38],[69,39,69,43],[31,1,34,1],[35,1,38,1],[39,1,42,1],[27,1,30,1],[23,1,26,1],[19,1,22,1],[39,29,39,33],[35,29,35,33],[31,29,31,33],[27,29,27,33],[23,29,23,33],[20,29,20,33],[41,29,41,33],[37,29,37,33],[33,29,33,33],[29,29,29,33],[25,29,25,33],[21,29,21,33],[90,1,93,1],[94,1,97,1],[121,36,121,37],[117,29,117,33],[117,34,117,38],[113,29,113,33],[113,34,113,38],[109,29,109,33],[109,34,109,38],[105,29,105,33],[105,34,105,38],[101,29,101,33],[101,34,101,38],[97,29,97,33],[97,34,97,38],[119,1,119,2],[121,38,121,41],[113,39,113,43],[114,29,114,33],[114,34,114,38],[114,39,114,43],[111,29,111,33],[111,34,111,38],[111,39,111,43],[117,39,117,43],[118,22,119,24],[119,25,119,26],[119,30,119,34],[119,42,119,43],[115,29,115,33],[115,34,115,38],[115,39,115,43],[116,29,116,33],[116,34,116,38],[116,39,116,43],[119,36,119,37],[119,38,119,41],[121,42,121,43],[122,25,122,26],[122,30,122,34],[120,14,120,20],[120,25,120,26],[120,30,120,34],[121,22,121,24],[121,25,121,26],[121,30,121,34],[112,29,112,33],[112,34,112,38],[112,39,112,43],[109,39,109,43],[110,29,110,33],[110,34,110,38],[110,39,110,43],[107,29,107,33],[107,34,107,38],[107,39,107,43],[108,29,108,33],[108,34,108,38],[108,39,108,43],[105,39,105,43],[106,29,106,33],[106,34,106,38],[106,39,106,43],[103,29,103,33],[103,34,103,38],[103,39,103,43],[104,29,104,33],[104,34,104,38],[104,39,104,43],[101,39,101,43],[102,29,102,33],[102,34,102,38],[102,39,102,43],[99,29,99,33],[99,34,99,38],[99,39,99,43],[100,29,100,33],[100,34,100,38],[100,39,100,43],[98,29,98,33],[98,34,98,38],[98,39,98,43],[95,29,95,33],[95,34,95,38],[95,39,95,43],[96,29,96,33],[96,34,96,38],[96,39,96,43],[90,29,93,33],[90,34,93,38],[81,34,81,38],[81,39,81,43],[82,29,82,33],[82,34,82,38],[82,39,82,43],[79,29,79,33],[79,34,79,38],[79,39,79,43],[80,29,80,33],[80,34,80,38],[80,39,80,43],[81,29,81,33],[70,29,70,33],[70,34,70,38],[70,39,70,43],[67,29,67,33],[67,34,67,38],[67,39,67,43],[68,29,68,33],[68,34,68,38],[68,39,68,43],[65,34,65,38],[65,39,65,43],[66,29,66,33],[66,34,66,38],[66,39,66,43],[63,29,63,33],[63,34,63,38],[63,39,63,43],[64,29,64,33],[64,34,64,38],[64,39,64,43],[61,34,61,38],[61,39,61,43],[62,29,62,33],[62,34,62,38],[62,39,62,43],[59,29,59,33],[59,34,59,38],[59,39,59,43],[60,29,60,33],[60,34,60,38],[60,39,60,43],[57,34,57,38],[57,39,57,43],[58,29,58,33],[58,34,58,38],[58,39,58,43],[55,29,55,33],[55,34,55,38],[55,39,55,43],[56,29,56,33],[56,34,56,38],[56,39,56,43],[53,34,53,38],[53,39,53,43],[54,29,54,33],[54,34,54,38],[54,39,54,43],[51,29,51,33],[51,34,51,38],[51,39,51,43],[52,29,52,33],[52,34,52,38],[52,39,52,43],[46,34,49,38],[46,39,49,43],[50,29,50,33],[50,34,50,38],[50,39,50,43],[41,34,41,38],[41,39,41,43],[42,29,42,33],[42,34,42,38],[42,39,42,43],[39,34,39,38],[39,39,39,43],[40,29,40,33],[40,34,40,38],[40,39,40,43],[37,34,37,38],[37,39,37,43],[38,29,38,33],[38,34,38,38],[38,39,38,43],[35,34,35,38],[35,39,35,43],[36,29,36,33],[36,34,36,38],[36,39,36,43],[33,34,33,38],[33,39,33,43],[34,29,34,33],[34,34,34,38],[34,39,34,43],[31,34,31,38],[31,39,31,43],[32,29,32,33],[32,34,32,38],[32,39,32,43],[29,34,29,38],[29,39,29,43],[30,29,30,33],[30,34,30,38],[30,39,30,43],[27,34,27,38],[27,39,27,43],[28,29,28,33],[28,34,28,38],[28,39,28,43],[25,34,25,38],[25,39,25,43],[26,29,26,33],[26,34,26,38],[26,39,26,43],[24,39,24,43],[8,21,9,22],[8,23,9,24],[8,26,8,29],[19,3,22,3],[20,34,20,38],[20,39,20,43],[14,29,17,33],[14,34,17,38],[14,39,17,43],[18,29,18,33],[18,34,18,38],[18,39,18,43],[21,34,21,38],[21,39,21,43],[22,29,22,33],[22,34,22,38],[22,39,22,43],[19,29,19,33],[19,34,19,38],[119,3,119,6],[119,14,119,20],[19,39,19,43],[12,28,13,43],[9,26,9,27],[9,28,9,29],[10,3,10,4],[0,26,1,43],[2,39,2,43],[3,39,3,43],[4,39,4,43],[5,1,5,28],[5,39,6,43],[6,1,6,38],[4,1,4,28],[7,1,7,28],[10,21,10,22],[10,23,10,24],[10,26,10,27],[10,28,10,29],[23,34,23,38],[23,39,23,43],[24,29,24,33],[24,34,24,38]]}
[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,"Унифицированная форма № Т-13\nУтверждена постановлением Госкомстата России от 05.01.2004 г. № 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,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,"Форма по ОКУД",301008]
[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,"по ОКПО",74771084]
[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,"январь",2016,null,null,null,null,null,null,null,null,null,null,null,null,null,"ТАБЕЛЬ  ",null,null,null,{"$f":"NOW()+30","v":"2016-03-15T20:22:32.390"},null,{"$f":"NOW()","v":"2016-02-14T20:22:32.390"},null,null,{"$f":"DATE($D$11,VLOOKUP($C$11,всяки!$A$1:$B$12,2,0),1)","v":"2016-01-01"},null,{"$f":"DATE($D$11,VLOOKUP($C$11,всяки!$A$1:$B$12,2,0),16+COLUMN(O:O))","v":"2016-01-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"учета  рабочего времени"]
[null,"Номер \nпо \nпорядку","Фамилия, инициалы, должность (специальность, профессия)","Табельный номер","Отметки о явках и неявках на работу по числам месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отработано за",null,"Данные для начисления заработной платы \nпо видам и направлениям затрат",null,null,null,null,null,"Неявки по причинам"]
[null,null,null,null,{"$f":"--TEXT(1&$C$11&$D$11,\"ДММММГГГГ\")","v":"2016-01-01"},{"$f":"$E$14+COLUMN(A:A)","v":"2016-01-02"},{"$f":"$E$14+COLUMN(B:B)","v":"2016-01-03"},"2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09","2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","X","половину месяца (I, II)","месяц","код вида оплаты"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(E20:T20,\"Я\")*1+COUNTIF(E20:T20,\"РВ\")*1","v":5},{"$f":"COUNTIF(E20:T20,\"Я\")*1+COUNTIF(E20:T20,\"РВ\")*1+COUNTIF(E22:T22,\"Я\")*1+COUNTIF(E22:T22,\"РВ\")*1","v":15},null,null,null,null,null,null,"код","дни\n(часы)",null,null,null,null,"код ",null,null,null,null,"дни\n(часы)"]
[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":"--TEXT(16&$C$11&$D$11,\"ДММММГГГГ\")","v":"2016-01-16"},{"$f":"IF(TEXT($E$17+COLUMN(A:A),\"ММММ\")=$C$11,$E$17+COLUMN(A:A),\"\")","v":"2016-01-17"},"2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23","2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28","2016-01-29","2016-01-30","2016-01-31","дни"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"часы",null,"код вида оплаты","корреспондирующий счет","дни\n(часы)","код вида оплаты","корреспондирующий счет","дни\n(часы)"]
[null,1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6,7,8,9,7,8,9,10,11,null,null,null,null,10,null,null,null,null,11]
[null,"1",null,{"$f":"IFERROR(HLOOKUP($E$1,Структура!$A$1:$H$30,TRUNC(ROW(A4)/4)+1,0),\"\")","v":1},{"$f":"IF(E$14=\"\",\"\",IF(AND(E$14>=$AI20,E$14<=$AJ20),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$14,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$14,выхрабд,1,0)=E$14)),\"Я\",IF(OR(WEEKDAY(E$14,2)>5,ISNUMBER(MATCH(E$14,празд,0)),SUMPRODUCT(1*(E$14=допнер))),\"В\",IF(WEEKDAY(E$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В",{"$f":"IF(I$14=\"\",\"\",IF(AND(I$14>=$AI20,I$14<=$AJ20),\"Р\",IF(NOT(ISERROR(VLOOKUP(I$14,предпр,1,0)=I$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(I$14,выхрабд,1,0)=I$14)),\"Я\",IF(OR(WEEKDAY(I$14,2)>5,ISNUMBER(MATCH(I$14,празд,0)),SUMPRODUCT(1*(I$14=допнер))),\"В\",IF(WEEKDAY(I$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В","В","В","Я","Я","Я","Я","Я","Х",null,null,null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+1),TRUNC(ROW(A4)/4)+1,0),\"\")","v":"Кривенок П.В"},null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",{"$f":"T20","v":"Х"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+2),TRUNC(ROW(A5)/4)+1,0),\"\")","v":"Генеральный директор"},null,{"$f":"IF(E$17=\"\",\"\",IF(AND(E$17>=$AI22,E$14<=$AJ22),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$17,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$17,выхрабд,1,0)=E$17)),\"Я\",IF(OR(WEEKDAY(E$17,2)>5,ISNUMBER(MATCH(E$17,празд,0)),SUMPRODUCT(1*(E$17=допнер))),\"В\",IF(WEEKDAY(E$17,2)<6,\"Я\"))))))","v":"В"},"В","Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В",{"$f":"IF(T$17=\"\",\"\",IF(AND(T$17>=$AI22,T$14<=$AJ22),\"Р\",IF(NOT(ISERROR(VLOOKUP(T$17,предпр,1,0)=T$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(T$17,выхрабд,1,0)=T$17)),\"Я\",IF(OR(WEEKDAY(T$17,2)>5,ISNUMBER(MATCH(T$17,празд,0)),SUMPRODUCT(1*(T$17=допнер))),\"В\",IF(WEEKDAY(T$17,2)<6,\"Я\"))))))","v":"В"}," "," ",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,2,null,{"$f":"IFERROR(HLOOKUP($E$1,Структура!$A$1:$H$30,TRUNC(ROW(A8)/4)+1,0),\"\")","v":2},{"$f":"IF(E$14=\"\",\"\",IF(AND(E$14>=$AI24,E$14<=$AJ24),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$14,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$14,выхрабд,1,0)=E$14)),\"Я\",IF(OR(WEEKDAY(E$14,2)>5,ISNUMBER(MATCH(E$14,празд,0)),SUMPRODUCT(1*(E$14=допнер))),\"В\",IF(WEEKDAY(E$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В",{"$f":"IF(I$14=\"\",\"\",IF(AND(I$14>=$AI24,I$14<=$AJ24),\"Р\",IF(NOT(ISERROR(VLOOKUP(I$14,предпр,1,0)=I$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(I$14,выхрабд,1,0)=I$14)),\"Я\",IF(OR(WEEKDAY(I$14,2)>5,ISNUMBER(MATCH(I$14,празд,0)),SUMPRODUCT(1*(I$14=допнер))),\"В\",IF(WEEKDAY(I$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В","В","В","Я","Я","Я","Я","Я","Х"," "," ",null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+1),TRUNC(ROW(A9)/4)+1,0),\"\")","v":"Гудкова Л.М"},null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",{"$f":"T21","v":"Х"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+2),TRUNC(ROW(A10)/4)+1,0),\"\")","v":"Главный бухгалтер"},null,{"$f":"IF(E$17=\"\",\"\",IF(AND(E$17>=$AI26,E$14<=$AJ26),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$17,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$17,выхрабд,1,0)=E$17)),\"Я\",IF(OR(WEEKDAY(E$17,2)>5,ISNUMBER(MATCH(E$17,празд,0)),SUMPRODUCT(1*(E$17=допнер))),\"В\",IF(WEEKDAY(E$17,2)<6,\"Я\"))))))","v":"В"},"В","Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В"," "," ",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,"3",null,{"$f":"IFERROR(HLOOKUP($E$1,Структура!$A$1:$H$30,TRUNC(ROW(A12)/4)+1,0),\"\")","v":24},{"$f":"IF(E$14=\"\",\"\",IF(AND(E$14>=$AI28,E$14<=$AJ28),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$14,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$14,выхрабд,1,0)=E$14)),\"Я\",IF(OR(WEEKDAY(E$14,2)>5,ISNUMBER(MATCH(E$14,празд,0)),SUMPRODUCT(1*(E$14=допнер))),\"В\",IF(WEEKDAY(E$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В",{"$f":"IF(I$14=\"\",\"\",IF(AND(I$14>=$AI28,I$14<=$AJ28),\"Р\",IF(NOT(ISERROR(VLOOKUP(I$14,предпр,1,0)=I$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(I$14,выхрабд,1,0)=I$14)),\"Я\",IF(OR(WEEKDAY(I$14,2)>5,ISNUMBER(MATCH(I$14,празд,0)),SUMPRODUCT(1*(I$14=допнер))),\"В\",IF(WEEKDAY(I$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В","В","В","Я","Я","Я","Я","Я","Х"," ",null,null,null,null,null,null,null,null,"Отпуск по уходу ",null,null,null,null,"04.08.2014-",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+1),TRUNC(ROW(A13)/4)+1,0),\"\")","v":"Егорова Е.А."},null,"О","О","О","О","О","О","О","О","О","О","О","О","О","О","О",{"$f":"T21","v":"Х"},null,null,null,null,null,null,null,null,null,"за реб.до 1,5 лет",null,null,null,null," 29.11.2015",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+2),TRUNC(ROW(A14)/4)+1,0),\"\")","v":"Экономист"},null,{"$f":"IF(E$17=\"\",\"\",IF(AND(E$17>=$AI30,E$14<=$AJ30),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$17,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$17,выхрабд,1,0)=E$17)),\"Я\",IF(OR(WEEKDAY(E$17,2)>5,ISNUMBER(MATCH(E$17,празд,0)),SUMPRODUCT(1*(E$17=допнер))),\"В\",IF(WEEKDAY(E$17,2)<6,\"Я\"))))))","v":"В"},"В","Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В",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,"4",null,{"$f":"IFERROR(HLOOKUP($E$1,Структура!$A$1:$H$30,TRUNC(ROW(A16)/4)+1,0),\"\")","v":26},{"$f":"IF(E$14=\"\",\"\",IF(AND(E$14>=$AI32,E$14<=$AJ32),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$14,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$14,выхрабд,1,0)=E$14)),\"Я\",IF(OR(WEEKDAY(E$14,2)>5,ISNUMBER(MATCH(E$14,празд,0)),SUMPRODUCT(1*(E$14=допнер))),\"В\",IF(WEEKDAY(E$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В",{"$f":"IF(I$14=\"\",\"\",IF(AND(I$14>=$AI32,I$14<=$AJ32),\"Р\",IF(NOT(ISERROR(VLOOKUP(I$14,предпр,1,0)=I$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(I$14,выхрабд,1,0)=I$14)),\"Я\",IF(OR(WEEKDAY(I$14,2)>5,ISNUMBER(MATCH(I$14,празд,0)),SUMPRODUCT(1*(I$14=допнер))),\"В\",IF(WEEKDAY(I$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В","В","В","Я","Я","Я","Я","Я","Х"," "," ",null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+1),TRUNC(ROW(A17)/4)+1,0),\"\")","v":"Пинчук А.Е."},null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",{"$f":"T21","v":"Х"}," ",null,null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+2),TRUNC(ROW(A18)/4)+1,0),\"\")","v":"Начальник цеха"},null,{"$f":"IF(E$17=\"\",\"\",IF(AND(E$17>=$AI34,E$14<=$AJ34),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$17,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$17,выхрабд,1,0)=E$17)),\"Я\",IF(OR(WEEKDAY(E$17,2)>5,ISNUMBER(MATCH(E$17,празд,0)),SUMPRODUCT(1*(E$17=допнер))),\"В\",IF(WEEKDAY(E$17,2)<6,\"Я\"))))))","v":"В"},"В","Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В"," "," ",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,"5",null,{"$f":"IFERROR(HLOOKUP($E$1,Структура!$A$1:$H$30,TRUNC(ROW(A20)/4)+1,0),\"\")","v":7},{"$f":"IF(E$14=\"\",\"\",IF(AND(E$14>=$AI36,E$14<=$AJ36),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$14,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$14,выхрабд,1,0)=E$14)),\"Я\",IF(OR(WEEKDAY(E$14,2)>5,ISNUMBER(MATCH(E$14,празд,0)),SUMPRODUCT(1*(E$14=допнер))),\"В\",IF(WEEKDAY(E$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В",{"$f":"IF(I$14=\"\",\"\",IF(AND(I$14>=$AI36,I$14<=$AJ36),\"Р\",IF(NOT(ISERROR(VLOOKUP(I$14,предпр,1,0)=I$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(I$14,выхрабд,1,0)=I$14)),\"Я\",IF(OR(WEEKDAY(I$14,2)>5,ISNUMBER(MATCH(I$14,празд,0)),SUMPRODUCT(1*(I$14=допнер))),\"В\",IF(WEEKDAY(I$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В","В","В","Я","Я","Я","Я","Я","Х"," "," ",null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+1),TRUNC(ROW(A21)/4)+1,0),\"\")","v":"Воронов Д.Н."},null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",{"$f":"T21","v":"Х"}," ",null,null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+2),TRUNC(ROW(A22)/4)+1,0),\"\")","v":"Слесарь КИП и А"},null,{"$f":"IF(E$17=\"\",\"\",IF(AND(E$17>=$AI38,E$14<=$AJ38),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$17,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$17,выхрабд,1,0)=E$17)),\"Я\",IF(OR(WEEKDAY(E$17,2)>5,ISNUMBER(MATCH(E$17,празд,0)),SUMPRODUCT(1*(E$17=допнер))),\"В\",IF(WEEKDAY(E$17,2)<6,\"Я\"))))))","v":"В"},"В","Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В"," "," ",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,"6",null,{"$f":"IFERROR(HLOOKUP($E$1,Структура!$A$1:$H$30,TRUNC(ROW(A24)/4)+1,0),\"\")","v":16},{"$f":"IF(E$14=\"\",\"\",IF(AND(E$14>=$AI40,E$14<=$AJ40),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$14,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$14,выхрабд,1,0)=E$14)),\"Я\",IF(OR(WEEKDAY(E$14,2)>5,ISNUMBER(MATCH(E$14,празд,0)),SUMPRODUCT(1*(E$14=допнер))),\"В\",IF(WEEKDAY(E$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В",{"$f":"IF(I$14=\"\",\"\",IF(AND(I$14>=$AI40,I$14<=$AJ40),\"Р\",IF(NOT(ISERROR(VLOOKUP(I$14,предпр,1,0)=I$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(I$14,выхрабд,1,0)=I$14)),\"Я\",IF(OR(WEEKDAY(I$14,2)>5,ISNUMBER(MATCH(I$14,празд,0)),SUMPRODUCT(1*(I$14=допнер))),\"В\",IF(WEEKDAY(I$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В","В","В","Я","Я","Я","Я","Я","Х"," "," ",null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+1),TRUNC(ROW(A25)/4)+1,0),\"\")","v":"Михайлов Р.В."},null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",{"$f":"T21","v":"Х"}," ",null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+2),TRUNC(ROW(A26)/4)+1,0),\"\")","v":"Водитель автопогрузчика"},null,{"$f":"IF(E$17=\"\",\"\",IF(AND(E$17>=$AI42,E$14<=$AJ42),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$17,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$17,выхрабд,1,0)=E$17)),\"Я\",IF(OR(WEEKDAY(E$17,2)>5,ISNUMBER(MATCH(E$17,празд,0)),SUMPRODUCT(1*(E$17=допнер))),\"В\",IF(WEEKDAY(E$17,2)<6,\"Я\"))))))","v":"В"},"В","Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В"," "," ",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,"Номер \nпо \nпорядку","Фамилия, инициалы,\nдолжность \n(специальность, \nпрофессия) ","Табельный\n номер","Отметки о явках и неявках на работу по числам месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отработано за",null,"Данные для начисления заработной платы \nпо видам и направлениям затрат",null,null,null,null,null,"Неявки по причинам"]
[null,null,null,null,{"$f":"--TEXT(1&$C$11&$D$11,\"ДММММГГГГ\")","v":"2016-01-01"},{"$f":"$E$14+COLUMN(A:A)","v":"2016-01-02"},"2016-01-03","2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09","2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","X","половину\nмесяца\n(I, II)","месяц","код вида оплаты"]
[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,"код","дни\n(часы)",null,null,null,null,"код ",null,null,null,null,"дни\n(часы)"]
[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":"--TEXT(16&$C$11&$D$11,\"ДММММГГГГ\")","v":"2016-01-16"},{"$f":"IF(TEXT($E$17+COLUMN(A:A),\"ММММ\")=$C$11,$E$17+COLUMN(A:A),\"\")","v":"2016-01-17"},"2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23","2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28","2016-01-29","2016-01-30","2016-01-31","дни"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"часы",null,"код вида оплаты","кор-\nреспонди- рующий \nсчет","дни\n(часы)","код вида оплаты","кор-\nреспонди- рующий \nсчет","дни\n(часы)"]
[null,"1","2",3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6,7,8,9,7,8,9,10,11,null,null,null,null,10,null,null,null,null,11]
[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,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,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,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,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,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,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,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,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,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,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,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,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,"Номер по порядку","Фамилия, инициалы, должность \n(специальность, профессия) ","Табельный номер","Отметки о явках и неявках на работу по числам месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отработано за",null,"Данные для начисления заработной платы \nпо видам и направлениям затрат",null,null,null,null,null,"Неявки по причинам"]
[null,null,null,null,{"$f":"--TEXT(1&$C$11&$D$11,\"ДММММГГГГ\")","v":"2016-01-01"},{"$f":"$E$14+COLUMN(A:A)","v":"2016-01-02"},"2016-01-03","2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09","2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","X","половину\nмесяца\n(I, II)","месяц","код вида оплаты"]
[null,null,null,null,{"$f":"--TEXT(16&$C$11&$D$11,\"ДММММГГГГ\")","v":"2016-01-16"},{"$f":"IF(TEXT($E$17+COLUMN(A:A),\"ММММ\")=$C$11,$E$17+COLUMN(A:A),\"\")","v":"2016-01-17"},"2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23","2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28","2016-01-29","2016-01-30","2016-01-31",{"$f":"COUNTIF(E20:T20,\"Я\")*1+COUNTIF(E20:T20,\"РВ\")*1","v":5},{"$f":"COUNTIF(E20:T20,\"Я\")*1+COUNTIF(E20:T20,\"РВ\")*1+COUNTIF(E22:T22,\"Я\")*1+COUNTIF(E22:T22,\"РВ\")*1","v":15}]
[null,1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6,7,8,9,7,8,9,10,11,null,null,null,null,10,null,null,null,null,11]
[null,"7.",null,null,{"$f":"IF(E$14=\"\",\"\",IF(AND(E$14>=$AI91,E$14<=$AJ91),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$14,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$14,выхрабд,1,0)=E$14)),\"Я\",IF(OR(WEEKDAY(E$14,2)>5,ISNUMBER(MATCH(E$14,празд,0)),SUMPRODUCT(1*(E$14=допнер))),\"В\",IF(WEEKDAY(E$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В",{"$f":"IF(I$14=\"\",\"\",IF(AND(I$14>=$AI91,I$14<=$AJ91),\"Р\",IF(NOT(ISERROR(VLOOKUP(I$14,предпр,1,0)=I$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(I$14,выхрабд,1,0)=I$14)),\"Я\",IF(OR(WEEKDAY(I$14,2)>5,ISNUMBER(MATCH(I$14,празд,0)),SUMPRODUCT(1*(I$14=допнер))),\"В\",IF(WEEKDAY(I$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В","В","В","Я","Я","Я","Я","Я","Х",null,null,"код вида оплаты","корреспондирующий счет","дни\n(часы)","код вида оплаты","корреспондирующий счет","дни\n(часы)","код","дни\n(часы)",null,null,null,null,"код ",null,null,null,null,"дни\n(часы)"]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+1),TRUNC(ROW(A29)/4)+1,0),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"корреспондирующий счет"]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+2),TRUNC(ROW(A77)/4)+1,0),\"\")","v":0},null,{"$f":"IF(E$17=\"\",\"\",IF(AND(E$17>=$AI93,E$14<=$AJ93),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$17,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$17,выхрабд,1,0)=E$17)),\"Я\",IF(OR(WEEKDAY(E$17,2)>5,ISNUMBER(MATCH(E$17,празд,0)),SUMPRODUCT(1*(E$17=допнер))),\"В\",IF(WEEKDAY(E$17,2)<6,\"Я\"))))))","v":"В"},"В","Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В"," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "]
[null,"8.",null,null,{"$f":"IF(E$14=\"\",\"\",IF(AND(E$14>=$AI95,E$14<=$AJ95),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$14,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$14,выхрабд,1,0)=E$14)),\"Я\",IF(OR(WEEKDAY(E$14,2)>5,ISNUMBER(MATCH(E$14,празд,0)),SUMPRODUCT(1*(E$14=допнер))),\"В\",IF(WEEKDAY(E$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В",{"$f":"IF(I$14=\"\",\"\",IF(AND(I$14>=$AI95,I$14<=$AJ95),\"Р\",IF(NOT(ISERROR(VLOOKUP(I$14,предпр,1,0)=I$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(I$14,выхрабд,1,0)=I$14)),\"Я\",IF(OR(WEEKDAY(I$14,2)>5,ISNUMBER(MATCH(I$14,празд,0)),SUMPRODUCT(1*(I$14=допнер))),\"В\",IF(WEEKDAY(I$14,2)<6,\"Я\"))))))","v":"В"},"В","В","В","В","В","Я","Я","Я","Я","Я","Х",null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+1),TRUNC(ROW(A29)/4)+1,0),\"\")","v":0},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,{"$f":"IFERROR(INDEX(INDEX(Структура!$A$1:$H$30,0,MATCH($E$1,Структура!$A$1:$E$1,0)+2),TRUNC(ROW(A81)/4)+1,0),\"\")","v":0},null,{"$f":"IF(E$17=\"\",\"\",IF(AND(E$17>=$AI97,E$14<=$AJ97),\"Р\",IF(NOT(ISERROR(VLOOKUP(E$17,предпр,1,0)=E$18)),\"Я\",IF(NOT(ISERROR(VLOOKUP(E$17,выхрабд,1,0)=E$17)),\"Я\",IF(OR(WEEKDAY(E$17,2)>5,ISNUMBER(MATCH(E$17,празд,0)),SUMPRODUCT(1*(E$17=допнер))),\"В\",IF(WEEKDAY(E$17,2)<6,\"Я\"))))))","v":"В"},"В","Я","Я","Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В",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,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,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,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," "]
[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,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,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,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,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," ",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,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,{"$f":"X11","v":"2016-02-14T20:22:32.390"},null,{"$f":"X11","v":"2016-02-14T20:22:32.390"},null,null,null,{"$f":"X11","v":"2016-02-14T20:22:32.390"}]
[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,{"$f":"AK120","v":"2016-02-14T20:22:32.390"},null,{"$f":"AM120","v":"2016-02-14T20:22:32.390"},null,null,null,{"$f":"AQ120","v":"2016-02-14T20:22:32.390"}]
[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,"расшифровка подписи"]

{"sheet":"Структура","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["МТО",null,"должность","САХО","Сектор ТО"]
[1,"Кривенок П.В","Генеральный директор"]
[2,"Гудкова Л.М","Главный бухгалтер"]
[24,"Егорова Е.А.","Экономист"]
[26,"Пинчук А.Е.","Начальник цеха"]
[7,"Воронов Д.Н.","Слесарь КИП и А"]
[16,"Михайлов Р.В.","Водитель автопогрузчика"]

{"sheet":"всяки","index":2,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,11,6,14],[7,11,7,14],[8,11,8,14],[9,11,9,14],[0,10,0,14],[1,10,1,14],[2,11,2,14],[3,11,3,14],[4,11,4,14],[5,11,5,14]]}
["январь",1,2010,null,"наименование приздников","Список гос. предпраздничных дней (дополняемый)","Список гос. праздничных дней (дополняемый)","Список дополнительных нерабочих дней","Рабочие выходные",null,"Обозначение дней в табеле рабочего времени"]
["февраль",2,2011]
["март",3,2012,null,"Новый год",{"$f":"G3-1","v":"2015-12-31"},"2016-01-01",null,"2016-02-20",null,"В","Выходные и праздничные дни"]
["апрель",4,2013,null,"Новый год",null,"2016-01-04",null,null,null,"*","Предпразнечные дни"]
["май",5,2014,null,"Новый год",null,"2016-01-05",null,null,null,null,"Дополнительные выходные дни"]
["июнь",6,2015,null,"Новый год",null,"2016-01-06",null,null,null,"Я","Рабочий день"]
["июль",7,2016,null,"Рождество",null,"2016-01-07"]
["август",8,2017,null,"Новый год",null,"2016-01-08"]
["сентябрь",9,2018]
["октябрь",10,2019]
["ноябрь",11,2020]
["декабрь",12,2021,null,"Перенос с 20.02.2016",null,"2016-02-22"]
[null,null,null,null,"Защитник отечества",{"$f":"G13-3","v":"2016-02-20"},"2016-02-23"]
[null,null,null,null,"Международный женский день",null,"2016-03-07"]
[null,null,null,null,"Международный женский день",null,"2016-03-08"]
[null,null,null,null,"Весна и туд май",null,"2016-05-01"]
[null,null,null,null,"Весна и туд май",null,"2016-05-02"]
[null,null,null,null,"Весна и туд май",null,"2016-05-03"]
[null,null,null,null,"День Победы",null,"2016-05-09"]
[null,null,null,null,"День России",null,"2016-06-13"]
[null,null,null,null,"День единства",{"$f":"G21-1","v":"2016-11-03"},"2016-11-04"]