{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Табель ","Оплата","Расчетный листок ","Рабочий календарь 2021"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":19,"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":21,"n_cols":29,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,0,15,0],[9,1,15,1],[9,2,15,2],[9,20,11,20],[10,8,13,8],[10,9,13,9],[10,14,13,14],[10,3,13,3],[10,4,13,4],[10,5,13,5],[10,6,13,6],[10,7,13,7],[10,12,13,12],[10,13,13,13],[9,22,15,22],[9,23,15,23],[14,12,15,12],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[16,3,16,18],[14,16,15,16],[14,17,15,17],[14,18,15,18],[0,2,0,5],[3,22,3,26],[7,2,7,17],[7,22,7,24],[7,25,7,26],[8,1,8,13],[8,14,8,18],[10,18,13,18],[12,19,13,19],[12,20,13,20],[12,21,13,21],[10,15,13,15],[10,16,13,16],[10,17,13,17],[9,21,11,21],[9,3,9,18],[9,19,11,19],[9,25,15,25],[10,10,13,10],[10,11,13,11],[14,3,15,3],[14,15,15,15],[14,13,15,13],[14,14,15,14],[14,19,15,19],[14,20,15,20],[9,24,15,24],[14,21,15,21],[17,25,20,25],[19,1,20,1],[19,19,20,19],[17,24,20,24],[17,1,18,1],[17,2,20,2],[17,19,18,19],[17,20,18,20],[19,20,20,20],[19,21,20,21],[17,21,18,21],[17,0,20,0],[17,22,20,22],[17,23,20,23]]}
[null,"Табель","2021-11-01"]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,null,null,null,null,null,null,null,null,null,"Обозначения в табеле:"]
[null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,1,null,null," \"1\"  полный месяц",null,null,null,null,"О -отуск,"]
[null,"Рабочих дней",{"$f":"COUNTIF(D5:R5,\"\")+COUNTIF(D6:S6,\"\")","v":20},null,null,null,1,1,1,1,null,null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,null,"Б - болничный лист,"]
[null,"Рабочих часов",{"$f":"C5*8","v":160},null,null,null,null,1,1,null,null,null,null,null,1,1,null,null,1,null,null,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,null,null,null,"Р -отуск по уходу за ребенком."]
[null,null,"           Т А Б Е Л Ь"]
[null," учета использования рабочего времени ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"2021-11-01"}]
["№ п/п ","Фамилия, инициалы,            должность           (специальность,              профессия)","Таб. номер","Отметки о явках и неявках на работу по числам месяца",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]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"дней","дней","дней"]
[]
[null,null,null,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"часов","часов","часов"]
[]
[1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6,7,8,9,10,11]
[1,"Вася ",null,{"$f":"IF($T$4=1,CHOOSE(D$5+1,\"Я\",\"В\"),\"\")","v":"Я"},"Я","Я","В","В","В","В","Я","Я","Я","Я","Я","В","В","Я",null,null,null,null,{"$f":"COUNTIF(D18:S21,\"Б\")","v":0},{"$f":"COUNTIF(D18:S21,\"ДО\")","v":0},{"$f":"COUNTIF(D18:S21,\"О\")","v":0},{"$f":"COUNTIF(D19:S19,\"В\")+COUNTIF(D21:S21,\"В\")","v":14}]
[null,null,null,12,12,12,"в",12,12,12,"в","в",12,12,"в","в",12,12]
[null,"Тракторист",null,{"$f":"IF($T$4=1,CHOOSE(D$6+1,\"Я\",\"В\"),\"\")","v":"Я"},"Я","Я","Я","В","В","Я","Я","Я","Я","Я","В","В","Я","Я","В",{"$f":"SUM(D19:S19)+SUM(D21:S21)","v":204},160,{"$f":"T20-U20","v":44}]
[null,null,null,"в","в",12,12,"в","в",12,12,"в","в",12,12,"в","в",12,"в"]

{"sheet":"Оплата","index":1,"n_rows":3,"n_cols":30,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,27,0,28],[0,18,0,20],[0,21,0,22],[0,23,0,24],[0,25,0,26]]}
[null,null,null,null,null,null,null,null,null," критерий минусовой",null,null,null,null,null,null,"КТУ в месяце",null," в месяце",null,null,"переработка в месяце",null,"премия",null,"доплата",null,"всего к оплате"]
[null,"должность","оклад","Напряженность работ ","Сложность работ, ответственность","1-Й класс (10%)","2-Й класс (10%)","3-Й класс (10%)","1(2%)","2(3%)","3(5%)","4(8%)","5(10%)","6(15%)","ставка","за месяц","всего","тариф"," часов по норме","отработано по норме","рубли","часы","рубли",0.35,"рубли",null,"рубли","часы","рубли","примечание"]
[{"$f":"'Табель '!B18","v":"Вася "},{"$f":"'Табель '!B20","v":"Тракторист"},15000,null,0.2,0.1,null,null,null,null,null,null,null,null,1,{"$f":"SUM(D3:H3)-SUM(I3:N3)","v":0.30000000000000004},{"$f":"O3+P3","v":1.3},{"$f":"Q3*C3","v":19500},160,{"$f":"'Табель '!U20","v":160},{"$f":"R3/S3*T3","v":19500},{"$f":"'Табель '!V20","v":44},{"$f":"V3*((R3/S3)*2)","v":10725},0.35,{"$f":"(C3/S3)*T3*X3","v":5250},null,null,null,{"$f":"U3+W3+Y3+AA3","v":35475}]

{"sheet":"Расчетный листок ","index":2,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,6,0,7],[1,4,1,6],[7,1,7,6],[6,4,6,6],[3,2,3,5],[4,5,4,6]]}
[null,"Расчетный листок",null,null,null,null,{"$f":"'Табель '!C1","v":"2021-11-01"}]
[null,"Ф.И.О.",null,null,{"$f":"'Табель '!B18","v":"Вася "}]
[]
[null,"должность:",{"$f":"'Табель '!B20","v":"Тракторист"},null,null,null,"КТУ",{"$f":"Оплата!Q3","v":1.3}]
[null,"часов в месяце:",{"$f":"'Табель '!C6","v":160},null,null,"отработано часов:",null,{"$f":"'Табель '!T20","v":204}]
[null,null,null,null,null,"переработка часов:",null,{"$f":"'Табель '!V20","v":44}]
[]
[null,"начисления"]
[null,"Тариф",null,null,null,null,{"$f":"Оплата!R3","v":19500}]
[null,"Надбавка премиальная",null,null,null,null,{"$f":"Оплата!Y3","v":5250}]
[null,"Переработка",null,null,null,null,{"$f":"Оплата!W3","v":10725}]
[null,"Доплата",null,null,null,null,{"$f":"Оплата!AA3","v":0}]
[]
[null,"начислено:",null,null,null,null,{"$f":"Оплата!AC3","v":35475}]

{"sheet":"Рабочий календарь 2021","index":3,"n_rows":55,"n_cols":24,"rows_kept":55,"cut":false,"hidden":false,"merged":[[52,1,52,23],[53,1,53,23],[54,1,54,23],[46,3,46,23],[47,3,47,23],[48,3,48,23],[49,3,49,23],[50,3,50,23],[51,3,51,23],[45,3,45,23],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[40,19,41,22],[40,23,41,23],[41,1,41,2],[42,1,42,23],[43,1,43,23],[44,3,44,23],[35,1,35,2],[22,1,22,17],[23,1,23,17],[24,2,24,6],[24,7,24,12],[24,13,24,17],[32,1,32,17],[33,1,33,17],[34,1,34,2],[34,3,34,7],[34,8,34,12],[34,13,34,17],[16,19,16,23],[17,19,19,19],[17,20,17,22],[17,23,19,23],[18,20,19,20],[18,21,19,21],[18,22,19,22],[11,1,11,3],[12,1,12,17],[13,1,13,17],[14,2,14,6],[14,7,14,12],[14,13,14,17],[10,1,10,3],[0,0,54,0],[0,1,0,17],[0,18,41,18],[1,1,1,17],[2,1,2,17],[3,1,3,17],[4,1,4,3],[4,4,4,8],[4,9,4,12],[4,13,4,17],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3]]}
[null,"ПРОИЗВОДСТВЕННЫЙ КАЛЕНДАРЬ"]
[null,"НА 2021 ГОД"]
[]
[null,"I квартал"]
[null,"Дни недели",null,null,"январь",null,null,null,null,"февраль",null,null,null,"март"]
[null,"Понедельник",null,null,null,4,11,18,25,1,8,15,22,1,8,15,22,29]
[null,"Вторник",null,null,null,5,12,19,26,2,9,16,23,2,9,16,23,30]
[null,"Среда",null,null,null,6,13,20,27,3,10,17,24,3,10,17,24,31]
[null,"Четверг",null,null,null,7,14,21,28,4,11,18,25,4,11,18,25]
[null,"Пятница",null,null,1,8,15,22,29,5,12,19,26,5,12,19,26]
[null,"Суббота",null,null,2,9,16,23,30,6,13,"20*",27,6,13,20,27]
[null,"Воскресенье",null,null,3,10,17,24,31,7,14,21,28,7,14,21,28]
[]
[null,"II квартал"]
[null,"Дни недели","апрель",null,null,null,null,"май",null,null,null,null,null,"июнь"]
[null,"Понедельник",null,5,12,19,26,null,3,10,17,24,31,null,7,14,21,28]
[null,"Вторник",null,6,13,20,27,null,4,11,18,25,null,1,8,15,22,29,null,"Нормы рабочего времени на 2021 год"]
[null,"Среда",null,7,14,21,28,null,5,12,19,26,null,2,9,16,23,30,null,"Периоды","Количество дней",null,null,"Рабо-чее время"]
[null,"Четверг",1,8,15,22,29,null,6,13,20,27,null,3,10,17,24,null,null,null,"кален-дарные","рабо-чие","Выход-ные"]
[null,"Пятница",2,9,16,23,"30*",null,7,14,21,28,null,4,"11*",18,25]
[null,"Суббота",3,10,17,24,null,1,8,15,22,29,null,5,12,19,26,null,null,"январь",31,15,16,120]
[null,"Воскресенье",4,11,18,25,null,2,9,16,23,30,null,6,13,20,27,null,null,"февраль",28,19,9,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"март",31,22,9,176]
[null,"III квартал",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I квартал",90,56,34,447]
[null,"Дни недели","июль",null,null,null,null,"август",null,null,null,null,null,"сентябрь",null,null,null,null,null,"апрель",30,22,8,175]
[null,"Понедельник",null,5,12,19,26,null,2,9,16,23,30,null,6,13,20,27,null,"май",31,19,12,152]
[null,"Вторник",null,6,13,20,27,null,3,10,17,24,31,null,7,14,21,28,null,"июнь",30,21,9,167]
[null,"Среда",null,7,14,21,28,null,4,11,18,25,null,1,8,15,22,29,null,"II квартал",91,62,29,494]
[null,"Четверг",1,8,15,22,29,null,5,12,19,26,null,2,9,16,23,30,null,"1 полугодие",181,118,63,941]
[null,"Пятница",2,9,16,23,30,null,6,13,20,27,null,3,10,17,24,null,null,"июль",31,22,9,176]
[null,"Суббота",3,10,17,24,31,null,7,14,21,28,null,4,11,18,25,null,null,"август",31,22,9,176]
[null,"Воскресенье",4,11,18,25,null,1,8,15,22,29,null,5,12,19,26,null,null,"сентябрь",30,22,8,176]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"III квартал",92,66,26,528]
[null,"IV квартал",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9 месяцев",273,184,89,1469]
[null,"Дни недели",null,"октябрь",null,null,null,null,"ноябрь",null,null,null,null,"декабрь",null,null,null,null,null,"октябрь",31,21,10,168]
[null,"Понедельник",null,null,4,11,18,25,1,8,15,22,29,null,6,13,20,27,null,"ноябрь",30,20,10,159]
[null,"Вторник",null,null,5,12,19,26,2,9,16,23,30,null,7,14,21,28,null,"декабрь",31,22,9,176]
[null,"Среда",null,null,6,13,20,27,"3*",10,17,24,null,1,8,15,22,29,null,"IV квартал",92,63,29,503]
[null,"Четверг",null,null,7,14,21,28,4,11,18,25,null,2,9,16,23,30,null,"2 полугодие",184,129,55,1031]
[null,"Пятница",null,1,8,15,22,29,5,12,19,26,null,3,10,17,24,31,null,"Год",365,247,118,1972]
[null,"Суббота",null,2,9,16,23,30,6,13,20,27,null,4,11,18,25,null,null,"Среднемесячное количество рабочих часов",null,null,null,164.33]
[null,"Воскресенье",null,3,10,17,24,31,7,14,21,28,null,5,12,19,26]
[]
[null,"* - Укороченные  предпраздничные рабочие дни при 40-часовой рабочей неделе (сокращение на 1 час)."]
[null,"1-6, 8 января","-","Новогодние каникулы (в ред. Федерального закона от 23.04.2012 № 35-ФЗ);"]
[null,"7 января","-","Рождество Христово;"]
[null,"23 февраля","-","День защитника Отечества;"]
[null,"8 марта","-","Международный женский день;"]
[null,"1 мая","-","Праздник Весны и Труда;"]
[null,"9 мая","-","День Победы;"]
[null,"12 июня","-","День России;"]
[null,"4 ноября","-","День народного единства"]
[null,"Норма рабочего времени на 2021 год при 40-часовой рабочей неделе - 1972 часов."]
[null,"Среднемесячное количество рабочих часов в 2021 году - 164,33 часа."]
[null,"Производственный календарь подготовлен ИД \"Вариант-52\", веб-сайт: variant52.ru"]