{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Наряд 1","Наряд 2"],"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":98,"n_cols":75,"rows_kept":98,"cut":false,"hidden":false,"merged":[[92,0,92,10],[92,11,92,78],[93,0,93,12],[93,13,93,32],[93,33,97,46],[93,47,93,59],[93,60,93,78],[94,0,94,12],[94,13,94,32],[94,47,94,59],[97,0,97,6],[97,7,97,32],[97,47,97,53],[97,54,97,78],[94,60,94,78],[95,0,95,18],[95,19,95,32],[95,47,95,65],[95,66,95,78],[96,0,96,18],[96,19,96,32],[96,47,96,65],[96,66,96,78],[91,50,91,52],[91,53,91,56],[91,57,91,62],[91,63,91,66],[91,67,91,70],[91,71,91,78],[90,53,90,56],[90,57,90,62],[90,63,90,66],[90,67,90,70],[90,71,90,78],[90,50,90,52],[91,0,91,2],[91,3,91,38],[91,39,91,43],[91,44,91,46],[91,47,91,49],[90,0,90,2],[90,3,90,38],[90,39,90,43],[90,44,90,46],[90,47,90,49],[86,71,86,78],[86,50,86,52],[89,0,89,2],[89,3,89,38],[89,39,89,43],[89,44,89,46],[89,47,89,49],[88,0,88,2],[88,3,88,38],[88,39,88,43],[88,44,88,46],[88,47,88,49],[89,50,89,52],[89,53,89,56],[89,57,89,62],[89,63,89,66],[89,67,89,70],[89,71,89,78],[88,53,88,56],[88,57,88,62],[88,63,88,66],[88,67,88,70],[88,71,88,78],[88,50,88,52],[84,63,84,66],[84,67,84,70],[84,71,84,78],[84,50,84,52],[87,0,87,2],[87,3,87,38],[87,39,87,43],[87,44,87,46],[87,47,87,49],[86,0,86,2],[86,3,86,38],[86,39,86,43],[86,44,86,46],[86,47,86,49],[87,50,87,52],[87,53,87,56],[87,57,87,62],[87,63,87,66],[87,67,87,70],[87,71,87,78],[86,53,86,56],[86,57,86,62],[86,63,86,66],[86,67,86,70],[82,53,82,56],[82,57,82,62],[82,63,82,66],[82,67,82,70],[82,71,82,78],[82,50,82,52],[85,0,85,2],[85,3,85,38],[85,39,85,43],[85,44,85,46],[85,47,85,49],[84,0,84,2],[84,3,84,38],[84,39,84,43],[84,44,84,46],[84,47,84,49],[85,50,85,52],[85,53,85,56],[85,57,85,62],[85,63,85,66],[85,67,85,70],[85,71,85,78],[84,53,84,56],[84,57,84,62],[81,63,81,66],[81,67,81,70],[81,71,81,78],[75,71,80,78],[77,63,80,66],[77,67,80,70],[78,50,80,52],[78,53,80,56],[83,0,83,2],[83,3,83,38],[83,39,83,43],[83,44,83,46],[83,47,83,49],[82,0,82,2],[82,3,82,38],[82,39,82,43],[82,44,82,46],[82,47,82,49],[83,50,83,52],[83,53,83,56],[83,57,83,62],[83,63,83,66],[83,67,83,70],[83,71,83,78],[81,0,81,2],[81,3,81,38],[81,39,81,43],[81,44,81,46],[81,47,81,49],[73,0,80,2],[73,3,80,38],[73,39,80,43],[73,44,74,62],[81,50,81,52],[81,53,81,56],[81,57,81,62],[73,63,74,78],[75,44,80,46],[75,47,80,49],[75,50,77,56],[75,57,80,62],[75,63,76,70],[65,74,68,78],[68,24,72,38],[68,39,72,52],[69,0,72,23],[69,53,72,58],[69,59,71,78],[72,60,72,78],[62,68,64,73],[62,74,64,78],[65,0,68,8],[65,9,68,23],[65,24,67,28],[65,29,67,52],[65,53,68,56],[65,57,68,62],[65,63,68,67],[65,68,68,73],[55,46,57,52],[55,53,57,56],[58,63,61,67],[58,68,61,73],[58,74,61,78],[61,0,64,8],[61,9,64,23],[62,24,64,28],[62,29,64,52],[62,53,64,56],[62,57,64,62],[62,63,64,67],[51,0,52,23],[51,24,54,39],[51,40,54,47],[51,48,54,52],[51,53,52,78],[53,0,54,3],[55,57,57,62],[55,63,57,67],[56,68,57,73],[56,74,57,78],[57,0,60,3],[57,4,60,23],[58,24,61,28],[58,29,61,52],[58,53,61,56],[58,57,61,62],[53,4,56,23],[53,53,54,67],[53,68,55,78],[55,0,56,3],[55,24,57,28],[55,29,57,29],[55,30,57,32],[55,33,57,45],[45,0,45,10],[45,11,45,78],[46,0,46,12],[46,13,46,32],[46,33,50,46],[46,47,46,59],[46,60,46,78],[47,0,47,12],[47,13,47,32],[47,47,47,59],[47,60,47,78],[48,0,48,18],[48,19,48,32],[48,47,48,65],[48,66,48,78],[49,0,49,18],[49,19,49,32],[49,47,49,65],[49,66,49,78],[50,0,50,6],[50,7,50,32],[50,47,50,53],[50,54,50,78],[44,50,44,52],[44,53,44,56],[44,57,44,62],[44,63,44,66],[44,67,44,70],[44,71,44,78],[43,53,43,56],[43,57,43,62],[43,63,43,66],[43,67,43,70],[43,71,43,78],[43,50,43,52],[44,0,44,2],[44,3,44,38],[44,39,44,43],[44,44,44,46],[44,47,44,49],[43,0,43,2],[43,3,43,38],[43,39,43,43],[43,44,43,46],[43,47,43,49],[39,71,39,78],[39,50,39,52],[42,0,42,2],[42,3,42,38],[42,39,42,43],[42,44,42,46],[42,47,42,49],[41,0,41,2],[41,3,41,38],[41,39,41,43],[41,44,41,46],[41,47,41,49],[42,50,42,52],[42,53,42,56],[42,57,42,62],[42,63,42,66],[42,67,42,70],[42,71,42,78],[41,53,41,56],[41,57,41,62],[41,63,41,66],[41,67,41,70],[41,71,41,78],[41,50,41,52],[37,63,37,66],[37,67,37,70],[37,71,37,78],[37,50,37,52],[40,0,40,2],[40,3,40,38],[40,39,40,43],[40,44,40,46],[40,47,40,49],[39,0,39,2],[39,3,39,38],[39,39,39,43],[39,44,39,46],[39,47,39,49],[40,50,40,52],[40,53,40,56],[40,57,40,62],[40,63,40,66],[40,67,40,70],[40,71,40,78],[39,53,39,56],[39,57,39,62],[39,63,39,66],[39,67,39,70],[35,53,35,56],[35,57,35,62],[35,63,35,66],[35,67,35,70],[35,71,35,78],[35,50,35,52],[38,0,38,2],[38,3,38,38],[38,39,38,43],[38,44,38,46],[38,47,38,49],[37,0,37,2],[37,3,37,38],[37,39,37,43],[37,44,37,46],[37,47,37,49],[38,50,38,52],[38,53,38,56],[38,57,38,62],[38,63,38,66],[38,67,38,70],[38,71,38,78],[37,53,37,56],[37,57,37,62],[34,63,34,66],[34,67,34,70],[34,71,34,78],[28,71,33,78],[30,63,33,66],[30,67,33,70],[31,50,33,52],[31,53,33,56],[36,0,36,2],[36,3,36,38],[36,39,36,43],[36,44,36,46],[36,47,36,49],[35,0,35,2],[35,3,35,38],[35,39,35,43],[35,44,35,46],[35,47,35,49],[36,50,36,52],[36,53,36,56],[36,57,36,62],[36,63,36,66],[36,67,36,70],[36,71,36,78],[34,0,34,2],[34,3,34,38],[34,39,34,43],[34,44,34,46],[34,47,34,49],[26,0,33,2],[26,3,33,38],[26,39,33,43],[26,44,27,62],[34,50,34,52],[34,53,34,56],[34,57,34,62],[26,63,27,78],[28,44,33,46],[28,47,33,49],[28,50,30,56],[28,57,33,62],[28,63,29,70],[18,68,21,73],[18,74,21,78],[21,24,25,38],[21,39,25,52],[22,0,25,23],[22,53,25,58],[22,59,24,78],[25,60,25,78],[15,63,17,67],[15,68,17,73],[15,74,17,78],[18,0,21,8],[18,9,21,23],[18,24,20,28],[18,29,20,52],[18,53,21,56],[18,57,21,62],[18,63,21,67],[9,74,10,78],[10,0,13,3],[10,4,13,23],[11,24,14,28],[11,29,14,52],[11,53,14,56],[11,57,14,62],[11,63,14,67],[11,68,14,73],[11,74,14,78],[14,0,17,8],[14,9,17,23],[15,24,17,28],[15,29,17,52],[15,53,17,56],[15,57,17,62],[0,0,3,55],[0,56,0,59],[0,60,3,78],[1,56,2,59],[3,56,3,59],[4,0,5,23],[4,24,7,39],[4,40,7,47],[4,48,7,52],[4,53,5,78],[6,0,7,3],[6,4,9,23],[6,53,7,67],[6,68,8,78],[8,0,9,3],[8,24,10,28],[8,29,10,29],[8,30,10,32],[8,33,10,45],[8,46,10,52],[8,53,10,56],[8,57,10,62],[8,63,10,67],[9,68,10,73]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[]
["УП\"Бумажная фабрика\"Гознака",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[null,null,null,null,{"$f":"[1]Начальная!$C$4","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,{"$f":"[1]Начальная!$C$12","v":"2016-05-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"план",null,null,null,null,null,"фактически"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"по норме",null,null,null,null,null,"фактически"]
["Объект"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Профессия",null,null,null,null,"рабочие",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Начало"]
[]
[]
["Конструкт. элемент"]
[null,null,null,null,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":"'[1]Наряд 2'!F11","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,null,null,null,null,null,null,null,null,null,null,"Мастер",null,null,null,null,{"$f":"[1]Начальная!$C$8","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,{"$f":"IFERROR(VLOOKUP(D35,[1]Список!$R$2:$S$94,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(AS35*BF35),\"\")","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,{"$f":"IFERROR(VLOOKUP(D36,[1]Список!$R$2:$S$94,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(AS36*BF36),\"\")","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,{"$f":"IFERROR(VLOOKUP(D37,[1]Список!$R$2:$S$94,2,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D38,[1]Список!$R$2:$S$94,2,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D39,[1]Список!$R$2:$S$94,2,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D40,[1]Список!$R$2:$S$94,2,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D41,[1]Список!$R$2:$S$94,2,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D42,[1]Список!$R$2:$S$94,2,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D43,[1]Список!$R$2:$S$94,2,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D44,[1]Список!$R$2:$S$94,2,0),\"\")","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,{"$f":"IFERROR(SUM(AS35:AU44),\"\")","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,{"$f":"IFERROR(SUM(BT35:BY44),\"\")","v":0}]
["Сумма прописью",null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX({\"\",\"сто \",\"двести \",\"триста \",\"четыреста \",\"пятьсот \",\"шестьсот \",\"семьсот \",\"восемьсот \",\"девятьсот \"},MOD(TRUNC(BT45/10^8),10)+1)&CHOOSE(MOD(TRUNC(BT45/10^7),10)+1,\"\",INDEX({\"десять \",\"одиннадцать \",\"двенадцать \",\"тринадцать \",\"четырнадцать \",\"пятнадцать \",\"шестнадцать \",\"семнадцать \",\"восемнадцать \",\"девятнадцать \"},MOD(TRUNC(BT45/10^6),10)+1),\"двадцать \",\"тридцать \",\"сорок \",\"пятьдесят \",\"шестьдесят \",\"семьдесят \",\"восемьдесят \",\"девяносто \")&IF(MOD(TRUNC(BT45/10^7),10)<>1,INDEX({\"\",\"один \",\"два \",\"три \",\"четыре \",\"пять \",\"шесть \",\"семь \",\"восемь \",\"девять \"},MOD(TRUNC(BT45/10^6),10)+1),\"\")&IF(MOD(TRUNC(BT45/10^6),1000),\"миллион\"&IF(MOD(TRUNC(BT45/10^7),10)=1,\"ов \",VLOOKUP(MOD(TRUNC(BT45/10^6),10),{0,\"ов \";1,\" \";2,\"а \";5,\"ов \"},2)),\"\")&INDEX({\"\",\"сто \",\"двести \",\"триста \",\"четыреста \",\"пятьсот \",\"шестьсот \",\"семьсот \",\"восемьсот \",\"девятьсот \"},MOD(TRUNC(BT45/10^5),10)+1)&CHOOSE(MOD(TRUNC(BT45/10^4),10)+1,\"\",INDEX({\"десять \",\"одиннадцать \",\"двенадцать \",\"тринадцать \",\"четырнадцать \",\"пятнадцать \",\"шестнадцать \",\"семнадцать \",\"восемнадцать \",\"девятнадцать \"},MOD(TRUNC(BT45/1000),10)+1),\"двадцать \",\"тридцать \",\"сорок \",\"пятьдесят \",\"шестьдесят \",\"семьдесят \",\"восемьдесят \",\"девяносто \")&IF(MOD(TRUNC(BT45/10^4),10)<>1,INDEX({\"\",\"одна \",\"две \",\"три \",\"четыре \",\"пять \",\"шесть \",\"семь \",\"восемь \",\"девять \"},MOD(TRUNC(BT45/1000),10)+1),\"\")&IF(MOD(TRUNC(BT45/1000),1000),\"тысяч\"&IF(MOD(TRUNC(BT45/10^4),10)=1,\" \",VLOOKUP(MOD(TRUNC(BT45/1000),10),{0,\" \";1,\"а \";2,\"и \";5,\" \"},2)),\"\")&INDEX({\"\",\"сто \",\"двести \",\"триста \",\"четыреста \",\"пятьсот \",\"шестьсот \",\"семьсот \",\"восемьсот \",\"девятьсот \"},MOD(TRUNC(BT45/100),10)+1)&CHOOSE(MOD(TRUNC(BT45/10),10)+1,\"\",INDEX({\"десять \",\"одиннадцать \",\"двенадцать \",\"тринадцать \",\"четырнадцать \",\"пятнадцать \",\"шестнадцать \",\"семнадцать \",\"восемнадцать \",\"девятнадцать \"},MOD(TRUNC(BT45),10)+1),\"двадцать \",\"тридцать \",\"сорок \",\"пятьдесят \",\"шестьдесят \",\"семьдесят \",\"восемьдесят \",\"девяносто \")&IF(TRUNC(BT45)=0,\"ноль \",IF(MOD(TRUNC(BT45/10),10)<>1,INDEX({\"\",\"один \",\"два \",\"три \",\"четыре \",\"пять \",\"шесть \",\"семь \",\"восемь \",\"девять \"},MOD(TRUNC(BT45),10)+1),\"\"))&\"\"&IF(MOD(TRUNC(BT45/10),10)=1,\"ов\",VLOOKUP(MOD(TRUNC(BT45),10),{0,\"\";1,\"\";2,\"\";5,\"\"},2))&TEXT(TRUNC((BT45-TRUNC(BT45)+0.00001)*100),)","v":"ноль "}]
["Наряд выдал: нач.цеха",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Начальная!$C$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,{"$f":"N47","v":"Романов В.В."}]
["мастер",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Начальная!$C$8","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,{"$f":"N48","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,"рабочий"]
[{"$f":"AE9","v":0},null,null,null,null,null,null,{"$f":"AH9","v":"2016-05-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AE9","v":0},null,null,null,null,null,null,{"$f":"AH9","v":"2016-05-01"}]
["УП\"Бумажная фабрика\"Гознака",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,{"$f":"[1]Начальная!$C$4","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,{"$f":"[1]Начальная!$C$12","v":"2016-05-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"план",null,null,null,null,null,"фактически"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"по норме",null,null,null,null,null,"фактически"]
["Объект"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Профессия",null,null,null,null,"рабочие",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Начало"]
[]
[]
["Конструкт. элемент"]
[null,null,null,null,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":"'[1]Наряд 2'!F47","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,null,null,null,null,null,null,null,null,null,null,"Мастер",null,null,null,null,{"$f":"[1]Начальная!$C$8","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,{"$f":"IFERROR(VLOOKUP(D82,[1]Список!$R$2:$U$80,4,0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(RIGHT(D82,1)=\":\",\"\",'[1]Наряд 2'!$Z$47)","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,{"$f":"IFERROR(VLOOKUP(D83,[1]Список!$R$2:$U$80,4,0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(RIGHT(D82,1)=\":\",'[1]Наряд 2'!$Z$47,\"\")","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,{"$f":"IFERROR(VLOOKUP(D84,[1]Список!$R$2:$U$80,4,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D85,[1]Список!$R$2:$U$80,4,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D86,[1]Список!$R$2:$U$80,4,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D87,[1]Список!$R$2:$U$80,4,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D88,[1]Список!$R$2:$U$80,4,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D89,[1]Список!$R$2:$U$80,4,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D90,[1]Список!$R$2:$U$80,4,0),\"\")","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,{"$f":"IFERROR(VLOOKUP(D91,[1]Список!$R$2:$U$80,4,0),\"\")","v":""}]
[null,null,null,"Итого по наряду…….."]
["Сумма прописью"]
["Наряд выдал: нач.цеха",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Начальная!$C$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,{"$f":"N94","v":"Романов В.В."}]
["мастер",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Начальная!$C$8","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,{"$f":"N95","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,"рабочий"]
[{"$f":"AE56","v":0},null,null,null,null,null,null,{"$f":"AH56","v":"2016-05-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AE56","v":0},null,null,null,null,null,null,{"$f":"AH56","v":"2016-05-01"}]

{"sheet":"Наряд 2","index":1,"n_rows":75,"n_cols":68,"rows_kept":75,"cut":false,"hidden":true,"merged":[[72,5,73,19],[72,20,73,37],[72,38,73,44],[72,45,73,61],[74,5,75,19],[74,20,75,37],[74,38,75,44],[74,45,75,61],[70,67,71,70],[71,41,71,44],[70,45,71,51],[70,52,71,56],[70,57,71,61],[70,62,71,66],[66,67,67,70],[68,0,69,4],[68,5,69,19],[68,20,69,24],[68,25,69,28],[68,45,69,51],[68,52,69,56],[68,57,69,61],[68,62,69,66],[68,67,69,70],[66,0,67,4],[66,5,67,19],[66,20,67,24],[66,25,67,28],[66,45,67,51],[66,52,67,56],[66,57,67,61],[66,62,67,66],[62,57,63,61],[62,62,63,66],[62,67,63,70],[64,0,65,4],[64,5,65,19],[64,20,65,24],[64,25,65,28],[64,45,65,51],[64,52,65,56],[64,57,65,61],[62,0,63,4],[62,5,63,19],[62,20,63,24],[62,25,63,28],[62,45,63,51],[62,52,63,56],[64,62,65,66],[64,67,65,70],[60,0,61,4],[60,5,61,19],[60,20,61,24],[60,25,61,28],[60,45,61,51],[60,52,61,56],[60,57,61,61],[60,62,61,66],[60,67,61,70],[58,0,59,4],[58,5,59,19],[58,20,59,24],[58,25,59,28],[58,45,59,51],[58,52,59,56],[58,57,59,61],[58,62,59,66],[58,67,59,70],[54,57,55,61],[54,62,55,66],[54,67,55,70],[56,0,57,4],[56,5,57,19],[56,20,57,24],[56,25,57,28],[56,45,57,51],[56,52,57,56],[56,57,57,61],[54,0,55,4],[54,5,55,19],[54,20,55,24],[54,25,55,28],[54,45,55,51],[54,52,55,56],[56,62,57,66],[56,67,57,70],[52,0,53,4],[52,5,53,19],[52,20,53,24],[52,25,53,28],[52,45,53,51],[52,52,53,56],[52,57,53,61],[52,62,53,66],[52,67,53,70],[50,0,51,4],[50,5,51,19],[50,20,51,24],[50,25,51,28],[50,45,51,51],[50,52,51,56],[50,57,51,61],[50,62,51,66],[50,67,51,70],[46,57,47,61],[46,62,47,66],[46,67,47,70],[48,0,49,4],[48,5,49,19],[48,20,49,24],[48,25,49,28],[48,45,49,51],[48,52,49,56],[48,57,49,61],[46,0,47,4],[46,5,47,19],[46,20,47,24],[46,25,47,28],[46,45,47,51],[46,52,47,56],[48,62,49,66],[48,67,49,70],[42,0,45,4],[42,5,45,19],[42,20,45,24],[42,25,45,28],[42,29,43,44],[42,45,45,51],[36,5,37,19],[36,20,37,37],[36,38,37,44],[36,45,37,61],[38,5,39,19],[38,20,39,37],[38,38,39,44],[38,45,39,61],[42,52,42,70],[43,52,45,56],[43,57,43,70],[44,57,45,61],[44,62,45,66],[44,67,45,70],[40,25,40,38],[40,39,40,43],[40,44,40,48],[34,67,35,70],[35,41,35,44],[30,67,31,70],[32,0,33,4],[32,5,33,19],[32,20,33,24],[32,25,33,28],[32,45,33,51],[32,52,33,56],[32,57,33,61],[32,62,33,66],[32,67,33,70],[30,0,31,4],[30,5,31,19],[30,20,31,24],[30,25,31,28],[30,45,31,51],[30,52,31,56],[30,57,31,61],[30,62,31,66],[34,45,35,51],[34,52,35,56],[34,57,35,61],[34,62,35,66],[26,57,27,61],[26,62,27,66],[26,67,27,70],[28,0,29,4],[28,5,29,19],[28,20,29,24],[28,25,29,28],[28,45,29,51],[28,52,29,56],[28,57,29,61],[26,0,27,4],[26,5,27,19],[26,20,27,24],[26,25,27,28],[26,45,27,51],[26,52,27,56],[28,62,29,66],[28,67,29,70],[24,0,25,4],[24,5,25,19],[24,20,25,24],[24,25,25,28],[24,45,25,51],[24,52,25,56],[24,57,25,61],[24,62,25,66],[24,67,25,70],[22,0,23,4],[22,5,23,19],[22,20,23,24],[22,25,23,28],[22,45,23,51],[22,52,23,56],[22,57,23,61],[22,62,23,66],[22,67,23,70],[18,57,19,61],[18,62,19,66],[18,67,19,70],[20,0,21,4],[20,5,21,19],[20,20,21,24],[20,25,21,28],[20,45,21,51],[20,52,21,56],[20,57,21,61],[18,0,19,4],[18,5,19,19],[18,20,19,24],[18,25,19,28],[18,45,19,51],[18,52,19,56],[20,62,21,66],[20,67,21,70],[16,52,17,56],[16,57,17,61],[16,62,17,66],[16,67,17,70],[12,62,13,66],[12,67,13,70],[14,0,15,4],[14,5,15,19],[14,20,15,24],[14,25,15,28],[14,45,15,51],[14,52,15,56],[14,57,15,61],[14,62,15,66],[14,67,15,70],[12,0,13,4],[12,5,13,19],[12,20,13,24],[12,25,13,28],[12,45,13,51],[12,52,13,56],[12,57,13,61],[10,0,11,4],[16,0,17,4],[16,5,17,19],[16,20,17,24],[16,25,17,28],[16,45,17,51],[10,5,11,19],[10,20,11,24],[10,25,11,28],[10,45,11,51],[10,52,11,56],[0,0,3,46],[0,47,0,50],[0,51,3,70],[1,47,2,50],[3,47,3,50],[4,25,4,38],[4,39,4,43],[4,44,4,48],[10,57,11,61],[10,62,11,66],[10,67,11,70],[6,52,6,70],[7,52,9,56],[7,57,7,70],[8,57,9,61],[8,62,9,66],[8,67,9,70],[6,0,9,4],[6,5,9,19],[6,20,9,24],[6,25,9,28],[6,29,7,44],[6,45,9,51]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"[1]Начальная!C12","v":"2016-05-01"},null,null,null,null,"месяц"]
[]
["№№     п/п",null,null,null,null,"Фамилия, имя,                                  отчество",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Табл.№",null,null,null,null,"Разряд",null,null,null,"Числа месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Всего отработано часов",null,null,null,null,null,null,"З а р п л а т а"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Часовая тарифная ставка",null,null,null,null,"причитается"]
[null,null,null,null,null,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":"[1]Начальная!C12","v":"2016-05-01"},{"$f":"AD9+1","v":"2016-05-02"},{"$f":"AE9+1","v":"2016-05-03"},"2016-05-04","2016-05-05","2016-05-06","2016-05-07","2016-05-08","2016-05-09","2016-05-10","2016-05-11","2016-05-12","2016-05-13","2016-05-14","2016-05-15",null,null,null,null,null,null,null,null,null,null,null,null,null,"по тарифу",null,null,null,null,"коэффициент",null,null,null,null,"всего"]
[null,null,null,null,null,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":"AR9+1","v":"2016-05-16"},{"$f":"AD10+1","v":"2016-05-17"},"2016-05-18","2016-05-19","2016-05-20","2016-05-21","2016-05-22","2016-05-23","2016-05-24","2016-05-25","2016-05-26","2016-05-27",{"$f":"IF(DAY(EOMONTH($AD$9,0))>=28,AO10+1,\"\")","v":"2016-05-28"},{"$f":"IF(DAY(EOMONTH($AD$9,0))>=29,AP10+1,\"\")","v":"2016-05-29"},{"$f":"IF(DAY(EOMONTH($AD$9,0))>=30,AQ10+1,\"\")","v":"2016-05-30"},{"$f":"IF(DAY(EOMONTH($AD$9,0))>=31,AR10+1,\"\")","v":"2016-05-31"}]
[{"$f":"IF(ISBLANK(F11),\"\",COUNTA($F$11:F11))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F11,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F11,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD12:AS12)+SUM(AD11:AS11)","v":0}]
[]
[{"$f":"IF(ISBLANK(F13),\"\",COUNTA($F$11:F13))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F13,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F13,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD14:AS14)+SUM(AD13:AS13)","v":0}]
[]
[{"$f":"IF(ISBLANK(F15),\"\",COUNTA($F$11:F15))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F15,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F15,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD16:AS16)+SUM(AD15:AS15)","v":0}]
[]
[{"$f":"IF(ISBLANK(F17),\"\",COUNTA($F$11:F17))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F17,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F17,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD18:AS18)+SUM(AD17:AS17)","v":0}]
[]
[{"$f":"IF(ISBLANK(F19),\"\",COUNTA($F$11:F19))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F19,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F19,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD20:AS20)+SUM(AD19:AS19)","v":0}]
[]
[{"$f":"IF(ISBLANK(F21),\"\",COUNTA($F$11:F21))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F21,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F21,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD22:AS22)+SUM(AD21:AS21)","v":0}]
[]
[{"$f":"IF(ISBLANK(F23),\"\",COUNTA($F$11:F23))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F23,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F23,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD24:AS24)+SUM(AD23:AS23)","v":0}]
[]
[{"$f":"IF(ISBLANK(F25),\"\",COUNTA($F$11:F25))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F25,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F25,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD26:AS26)+SUM(AD25:AS25)","v":0}]
[]
[{"$f":"IF(ISBLANK(F27),\"\",COUNTA($F$11:F27))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F27,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F27,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD28:AS28)+SUM(AD27:AS27)","v":0}]
[]
[{"$f":"IF(ISBLANK(F29),\"\",COUNTA($F$11:F29))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F29,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F29,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD30:AS30)+SUM(AD29:AS29)","v":0}]
[]
[{"$f":"IF(ISBLANK(F31),\"\",COUNTA($F$11:F31))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F31,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F31,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD32:AS32)+SUM(AD31:AS31)","v":0}]
[]
[{"$f":"IF(ISBLANK(F33),\"\",COUNTA($F$11:F33))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F33,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F33,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD34:AS34)+SUM(AD33:AS33)","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,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":"[1]Начальная!$C$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,{"$f":"[1]Начальная!$C$8","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,{"$f":"[1]Начальная!C12","v":"2016-05-01"},null,null,null,null,"месяц"]
[]
["№№     п/п",null,null,null,null,"Фамилия, имя,                                  отчество",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Табл.№",null,null,null,null,"Разряд",null,null,null,"Числа месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Всего отработано часов",null,null,null,null,null,null,"З а р п л а т а"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Часовая тарифная ставка",null,null,null,null,"причитается"]
[null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"по тарифу",null,null,null,null,"коэффициент",null,null,null,null,"всего"]
[null,null,null,null,null,null,null,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,{"$f":"IF(DAY(EOMONTH($AD$9,0))>=28,AO46+1,\"\")","v":"1900-01-28"},{"$f":"IF(DAY(EOMONTH($AD$9,0))>=29,AP46+1,\"\")","v":"1900-01-29"},{"$f":"IF(DAY(EOMONTH($AD$9,0))>=30,AQ46+1,\"\")","v":"1900-01-30"},{"$f":"IF(DAY(EOMONTH($AD$9,0))>=31,AR46+1,\"\")","v":"1900-01-31"}]
[{"$f":"IF(ISBLANK(F47),\"\",COUNTA($F$47:F47))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F47,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F47,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD48:AS48)+SUM(AD47:AS47)","v":0}]
[]
[{"$f":"IF(ISBLANK(F49),\"\",COUNTA($F$47:F49))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F49,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F49,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD50:AS50)+SUM(AD49:AS49)","v":0}]
[]
[{"$f":"IF(ISBLANK(F51),\"\",COUNTA($F$47:F51))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F51,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F51,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD52:AS52)+SUM(AD51:AS51)","v":0}]
[]
[{"$f":"IF(ISBLANK(F53),\"\",COUNTA($F$47:F53))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F53,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F53,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD54:AS54)+SUM(AD53:AS53)","v":0}]
[]
[{"$f":"IF(ISBLANK(F55),\"\",COUNTA($F$47:F55))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F55,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F55,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD56:AS56)+SUM(AD55:AS55)","v":0}]
[]
[{"$f":"IF(ISBLANK(F57),\"\",COUNTA($F$47:F57))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F57,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F57,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD58:AS58)+SUM(AD57:AS57)","v":0}]
[]
[{"$f":"IF(ISBLANK(F59),\"\",COUNTA($F$47:F59))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F59,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F59,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD60:AS60)+SUM(AD59:AS59)","v":0}]
[]
[{"$f":"IF(ISBLANK(F61),\"\",COUNTA($F$47:F61))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F61,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F61,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD62:AS62)+SUM(AD61:AS61)","v":0}]
[]
[{"$f":"IF(ISBLANK(F63),\"\",COUNTA($F$47:F63))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F63,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F63,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD64:AS64)+SUM(AD63:AS63)","v":0}]
[]
[{"$f":"IF(ISBLANK(F65),\"\",COUNTA($F$47:F65))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F65,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F65,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD66:AS66)+SUM(AD65:AS65)","v":0}]
[]
[{"$f":"IF(ISBLANK(F67),\"\",COUNTA($F$47:F67))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F67,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F67,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD68:AS68)+SUM(AD67:AS67)","v":0}]
[]
[{"$f":"IF(ISBLANK(F69),\"\",COUNTA($F$47:F69))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F69,[1]Список!$B$2:$C$118,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(LEFT(RIGHT(INDEX('[1]Общий табель'!$C$6:$D$120,MATCH(F69,'[1]Общий табель'!$C$6:$C$120,0),2),4)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD70:AS70)+SUM(AD69:AS69)","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,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":"[1]Начальная!$C$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,{"$f":"[1]Начальная!$C$8","v":"Хомич Н.Н."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Счетовод"]