{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ОСНОВНОЙ ТАБЕЛЬ","ТАБЛИЦА","СПИСОК","норма"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":1,"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":59,"n_cols":68,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,45,0,65],[6,61,9,61],[6,62,9,62],[6,63,9,63],[6,64,9,64],[6,65,9,65],[2,45,3,65],[4,45,5,47],[4,48,5,50],[4,51,5,53],[4,54,5,56],[4,57,5,59],[4,60,5,62],[4,63,5,65],[6,45,9,45],[6,46,9,46],[6,47,9,47],[6,48,9,48],[6,49,9,49],[6,50,9,50],[6,51,9,51],[6,52,9,52],[6,53,9,53],[6,54,9,54],[6,55,9,55],[6,56,9,56],[6,57,9,57],[6,58,9,58],[6,59,9,59],[6,60,9,60],[5,41,9,41],[5,39,9,39],[5,7,5,37],[5,40,9,40],[5,38,9,38],[31,39,33,39],[34,39,36,39],[31,38,33,38],[37,38,39,38],[34,38,36,38],[28,38,30,38],[16,38,18,38],[10,39,12,39],[13,38,15,38],[25,38,27,38],[28,39,30,39],[25,39,27,39],[22,38,24,38],[16,39,18,39],[19,38,21,38],[19,39,21,39],[13,39,15,39],[10,38,12,38],[22,39,24,39],[37,39,39,39],[49,39,51,39],[40,38,42,38],[52,39,54,39],[55,38,57,38],[55,39,57,39],[40,39,42,39],[46,39,48,39],[43,39,45,39],[43,38,45,38],[46,38,48,38],[49,38,51,38],[52,38,54,38],[0,0,1,1],[0,4,1,4],[0,19,0,29],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[2,2,2,39],[0,2,1,3],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[3,2,3,39],[4,22,4,23],[4,15,4,18],[5,4,9,4],[5,3,9,3],[5,6,9,6],[5,2,9,2],[0,12,0,18],[1,12,1,18],[5,5,9,5],[8,36,9,36],[8,37,9,37],[8,35,9,35]]}
["ОТЧЁТНЫЙ ПЕРИОД",null,{"$f":"--(1&\"/\"&E1&\"/\"&[1]норма!$A$1)","v":"2014-06-01"},null,6,null,null,null,null,null,null,null,"Предпраздничные",null,null,null,null,null,null,"Праздничные",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Служит для счёта отсутствующих и в какой период"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(--(INDEX(норма!D3:D14,$E1)&\"/\"&$E1),\"\")","v":"2014-06-12"},{"$f":"IFERROR(--(INDEX(норма!E3:E14,$E1)&\"/\"&$E1),\"\")","v":"2014-06-13"},{"$f":"IFERROR(--(INDEX(норма!F3:F14,$E1)&\"/\"&$E1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!G3:G14,$E1)&\"/\"&$E1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!H3:H14,$E1)&\"/\"&$E1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!I3:I14,$E1)&\"/\"&$E1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!J3:J14,$E1)&\"/\"&$E1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!K3:K14,$E1)&\"/\"&$E1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!L3:L14,$E1)&\"/\"&$E1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!M3:M14,$E1)&\"/\"&$E1),\"\")","v":""},{"$f":"IFERROR(--(INDEX(норма!N3:N14,$E1)&\"/\"&$E1),\"\")","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," рабочего времени участка такелажных работ 1 категории"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"за",{"$f":"C1","v":"2014-06-01"},null,null,null,"месяц",null,null,2014,null,"г.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Д/О",null,null,"Отпуск",null,null,"Больничный",null,null,"Увольнение",null,null,"Командировка",null,null,"Донорский день",null,null,"Учебный отпуск"]
[null,null,"№ по сп","Фамилия,И,О.","Таб. №","Разряд","Специальность","ДНИ МЕСЯЦА",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Итого дней за месяц","Итого часов за месяц","Кол-во вых.дней","Кол-во вых.часов"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"H9","v":"2014-06-01"},{"$f":"I9","v":"2014-06-02"},"2014-06-03","2014-06-04","2014-06-05","2014-06-06","2014-06-07","2014-06-08","2014-06-09","2014-06-10","2014-06-11","2014-06-12","2014-06-13","2014-06-14","2014-06-15","2014-06-16","2014-06-17","2014-06-18","2014-06-19","2014-06-20","2014-06-21","2014-06-22","2014-06-23","2014-06-24","2014-06-25","2014-06-26","2014-06-27","2014-06-28","2014-06-29","2014-06-30",""]
[null,null,null,null,null,null,null,{"$f":"C1","v":"2014-06-01"},{"$f":"H9+1","v":"2014-06-02"},{"$f":"I9+1","v":"2014-06-03"},{"$f":"J9+1","v":"2014-06-04"},"2014-06-05","2014-06-06","2014-06-07","2014-06-08","2014-06-09","2014-06-10","2014-06-11","2014-06-12","2014-06-13","2014-06-14","2014-06-15","2014-06-16","2014-06-17","2014-06-18","2014-06-19","2014-06-20","2014-06-21","2014-06-22","2014-06-23","2014-06-24","2014-06-25","2014-06-26","2014-06-27","2014-06-28",{"$f":"IF(DAY($AI9+1)>DAY(AI9),$AI9+1,\"\")","v":"2014-06-29"},{"$f":"IF(DAY($AI9+2)>DAY(AI9),$AI9+2,\"\")","v":"2014-06-30"},{"$f":"IF(DAY($AI9+3)>DAY(AI9),$AI9+3,\"\")","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,{"$f":"COUNT(H12:AL12)+SUMPRODUCT((ТАБЛИЦА!$F$1:$F$28=H12:AL12)*ТАБЛИЦА!$G$1:$G$28)","v":19},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H12:AL12,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H13:AL13)","v":137}]
[null,null,1,"Иванова А.В.",719,"-","Планировщик",null,8,7,7,7,7,null,null,8,7,6,null,null,null,null,8,7,7,7,7,null,null,8,7,7,7,7,null,null,8,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H12:AL12))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H12:AL12),H12:AL12,))","v":0},null,{"$f":"AT12","v":""},null,{"$f":"IF(COUNTIF(H12:AL12,\"д/о\"),COUNTIF(H12:AL12,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"MAX(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"IF(COUNTIF(H12:AL12,\"о\"),COUNTIF(H12:AL12,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"MAX(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"IF(COUNTIF(H12:AL12,\"Б\"),COUNTIF(H12:AL12,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"MAX(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"IF(COUNTIF(H12:AL12,\"А\"),COUNTIF(H12:AL12,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"MAX(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"IF(COUNTIF(H12:AL12,\"К\"),COUNTIF(H12:AL12,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"MAX(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"IF(COUNTIF(H12:AL12,\"Д\"),COUNTIF(H12:AL12,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"MAX(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"IF(COUNTIF(H12:AL12,\"У\"),COUNTIF(H12:AL12,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","v":0},{"$f":"MAX(IF(ISTEXT(H12:AL12),--$H$59:$AL$59))","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,{"$f":"COUNT(H15:AL15)+SUMPRODUCT((ТАБЛИЦА!$F$1:$F$28=H15:AL15)*ТАБЛИЦА!$G$1:$G$28)","v":17.64},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H15:AL15,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H16:AL16)","v":126.5}]
[null,null,2,"Забенько О.Н.",623,null,"Кладовщик",null,8,7,7,7,7,null,null,8,7,6,null,null,null,null,8,7,7,7,7,null,null,8,7,7,7,"А",null,null,"я/4,5",null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H15:AL15))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H15:AL15),H15:AL15,))","v":0},null,null,null,{"$f":"IF(COUNTIF(H15:AL15,\"д/о\"),COUNTIF(H15:AL15,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":27},{"$f":"MAX(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H15:AL15,\"о\"),COUNTIF(H15:AL15,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":27},{"$f":"MAX(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H15:AL15,\"Б\"),COUNTIF(H15:AL15,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":27},{"$f":"MAX(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H15:AL15,\"А\"),COUNTIF(H15:AL15,\"А\"),\"\")","v":1},{"$f":"MIN(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":27},{"$f":"MAX(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H15:AL15,\"К\"),COUNTIF(H15:AL15,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":27},{"$f":"MAX(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H15:AL15,\"Д\"),COUNTIF(H15:AL15,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":27},{"$f":"MAX(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H15:AL15,\"У\"),COUNTIF(H15:AL15,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":27},{"$f":"MAX(IF(ISTEXT(H15:AL15),--$H$59:$AL$59))","v":30},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Должны оставаться только ячейки где именно (день-нач-кон)выделил жёлтым"]
[null,null,null,null,null,null,null,null,null,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,1,null,null,null,{"$f":"COUNT(H18:AL18)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H18:AL18)*ТАБЛИЦА!$C$1:$C$28)","v":20},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H18:AL18,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H19:AL19)","v":158}]
[null,null,3,"Петровский С.А.",28,"-","Ст.Мастер",8,8,8,8,8,8,null,null,8,8,"Д/О",null,null,null,null,8,8,8,8,8,8,null,8,8,8,8,7,7,null,"О",null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H18:AL18))","v":3},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H18:AL18),H18:AL18,))","v":23},null,null,null,{"$f":"IF(COUNTIF(H18:AL18,\"д/о\"),COUNTIF(H18:AL18,\"д/о\"),\"\")","v":1},{"$f":"MIN(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H18:AL18,\"о\"),COUNTIF(H18:AL18,\"о\"),\"\")","v":1},{"$f":"MIN(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H18:AL18,\"Б\"),COUNTIF(H18:AL18,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H18:AL18,\"А\"),COUNTIF(H18:AL18,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H18:AL18,\"К\"),COUNTIF(H18:AL18,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H18:AL18,\"Д\"),COUNTIF(H18:AL18,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H18:AL18,\"У\"),COUNTIF(H18:AL18,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H18:AL18),--$H$59:$AL$59))","v":30}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H21:AL21)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H21:AL21)*ТАБЛИЦА!$C$1:$C$28)","v":21},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H21:AL21,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H22:AL22)","v":167}]
[null,null,4,"Шевчук А.Н.",30,"-","Мастер",null,"Д/О",8,8,8,8,8,null,"Д/О",8,7,null,8,8,8,8,8,8,"Д/О",8,null,8,8,8,8,8,"Д/О",null,8,8,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H21:AL21))","v":6},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H21:AL21),H21:AL21,))","v":48},null,null,null,{"$f":"IF(COUNTIF(H21:AL21,\"д/о\"),COUNTIF(H21:AL21,\"д/о\"),\"\")","v":4},{"$f":"MIN(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":27},{"$f":"IF(COUNTIF(H21:AL21,\"о\"),COUNTIF(H21:AL21,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":27},{"$f":"IF(COUNTIF(H21:AL21,\"Б\"),COUNTIF(H21:AL21,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":27},{"$f":"IF(COUNTIF(H21:AL21,\"А\"),COUNTIF(H21:AL21,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":27},{"$f":"IF(COUNTIF(H21:AL21,\"К\"),COUNTIF(H21:AL21,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":27},{"$f":"IF(COUNTIF(H21:AL21,\"Д\"),COUNTIF(H21:AL21,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":27},{"$f":"IF(COUNTIF(H21:AL21,\"У\"),COUNTIF(H21:AL21,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H21:AL21),--$H$59:$AL$59))","v":27}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H24:AL24)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H24:AL24)*ТАБЛИЦА!$C$1:$C$28)","v":0},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H24:AL24,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H25:AL25)","v":0}]
[null,null,5,"Горбачёв Г.Е.",900,4,"такелажник",null,"Э","Э","Э","Э","Э",null,null,"Э","Э","Э",null,null,null,null,"Э","Э","Э","Э","Э",null,null,"Э","Э","Э","Э","Э",null,null,"Д/О",null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H24:AL24))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H24:AL24),H24:AL24,))","v":0},null,null,null,{"$f":"IF(COUNTIF(H24:AL24,\"д/о\"),COUNTIF(H24:AL24,\"д/о\"),\"\")","v":1},{"$f":"MIN(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H24:AL24,\"о\"),COUNTIF(H24:AL24,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H24:AL24,\"Б\"),COUNTIF(H24:AL24,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H24:AL24,\"А\"),COUNTIF(H24:AL24,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H24:AL24,\"К\"),COUNTIF(H24:AL24,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H24:AL24,\"Д\"),COUNTIF(H24:AL24,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H24:AL24,\"У\"),COUNTIF(H24:AL24,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H24:AL24),--$H$59:$AL$59))","v":30}]
[]
[null,null,null,null,null,null,null,null,null,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":"COUNT(H27:AL27)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H27:AL27)*ТАБЛИЦА!$C$1:$C$28)","v":15},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H27:AL27,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H28:AL28)","v":130}]
[null,null,6,"Мошнегуца Г.М.",901,5,"такелажник",null,"Д/О","Д/О","Д/О","Д/О","Д/О",null,null,8,8,7,null,8,8,8,8,8,8,8,8,null,null,"Д",8,8,8,7,null,null,"Д/О",null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H27:AL27))","v":3},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H27:AL27),H27:AL27,))","v":24},null,null,null,{"$f":"IF(COUNTIF(H27:AL27,\"д/о\"),COUNTIF(H27:AL27,\"д/о\"),\"\")","v":6},{"$f":"MIN(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H27:AL27,\"о\"),COUNTIF(H27:AL27,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H27:AL27,\"Б\"),COUNTIF(H27:AL27,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H27:AL27,\"А\"),COUNTIF(H27:AL27,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H27:AL27,\"К\"),COUNTIF(H27:AL27,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H27:AL27,\"Д\"),COUNTIF(H27:AL27,\"Д\"),\"\")","v":1},{"$f":"MIN(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H27:AL27,\"У\"),COUNTIF(H27:AL27,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H27:AL27),--$H$59:$AL$59))","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H30:AL30)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H30:AL30)*ТАБЛИЦА!$C$1:$C$28)","v":0},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H30:AL30,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H31:AL31)","v":0}]
[null,null,7,"Коновалов А.Г.",902,5,"такелажник",null,"О","О","О","О","О",null,null,"О","О","О",null,null,null,null,"О","О","О","О","О",null,null,"О","О","О","О","О",null,null,"О",null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H30:AL30))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H30:AL30),H30:AL30,))","v":0},null,null,null,{"$f":"IF(COUNTIF(H30:AL30,\"д/о\"),COUNTIF(H30:AL30,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H30:AL30,\"о\"),COUNTIF(H30:AL30,\"о\"),\"\")","v":19},{"$f":"MIN(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H30:AL30,\"Б\"),COUNTIF(H30:AL30,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H30:AL30,\"А\"),COUNTIF(H30:AL30,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H30:AL30,\"К\"),COUNTIF(H30:AL30,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H30:AL30,\"Д\"),COUNTIF(H30:AL30,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H30:AL30,\"У\"),COUNTIF(H30:AL30,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H30:AL30),--$H$59:$AL$59))","v":30}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H33:AL33)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H33:AL33)*ТАБЛИЦА!$C$1:$C$28)","v":15},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H33:AL33,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H34:AL34)","v":123}]
[null,null,8,"Стасюк И.И.",905,5,"такелажник",null,8,8,"Д/О",8,8,8,8,8,8,7,null,null,null,null,"К","К","К","К","К",8,null,8,8,"Д/О",8,8,null,null,8,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H33:AL33))","v":3},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H33:AL33),H33:AL33,))","v":24},null,null,null,{"$f":"IF(COUNTIF(H33:AL33,\"д/о\"),COUNTIF(H33:AL33,\"д/о\"),\"\")","v":2},{"$f":"MIN(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":4},{"$f":"MAX(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":25},{"$f":"IF(COUNTIF(H33:AL33,\"о\"),COUNTIF(H33:AL33,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":4},{"$f":"MAX(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":25},{"$f":"IF(COUNTIF(H33:AL33,\"Б\"),COUNTIF(H33:AL33,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":4},{"$f":"MAX(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":25},{"$f":"IF(COUNTIF(H33:AL33,\"А\"),COUNTIF(H33:AL33,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":4},{"$f":"MAX(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":25},{"$f":"IF(COUNTIF(H33:AL33,\"К\"),COUNTIF(H33:AL33,\"К\"),\"\")","v":5},{"$f":"MIN(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":4},{"$f":"MAX(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":25},{"$f":"IF(COUNTIF(H33:AL33,\"Д\"),COUNTIF(H33:AL33,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":4},{"$f":"MAX(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":25},{"$f":"IF(COUNTIF(H33:AL33,\"У\"),COUNTIF(H33:AL33,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":4},{"$f":"MAX(IF(ISTEXT(H33:AL33),--$H$59:$AL$59))","v":25}]
[null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H36:AL36)+SUMPRODUCT((ТАБЛИЦА!$F$1:$F$28=H36:AL36)*ТАБЛИЦА!$G$1:$G$28)","v":0},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H36:AL36,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H37:AL37)","v":0}]
[null,null,9,"Кузьмина И.В.",906,3,"такелажник",null,"О","О","О","О","О",null,null,"О","О","О",null,null,null,null,"О","О","О","О","О",null,null,"О","О","О","О","О",null,null,"О",null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H36:AL36))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H36:AL36),H36:AL36,))","v":0},null,null,null,{"$f":"IF(COUNTIF(H36:AL36,\"д/о\"),COUNTIF(H36:AL36,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H36:AL36,\"о\"),COUNTIF(H36:AL36,\"о\"),\"\")","v":19},{"$f":"MIN(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H36:AL36,\"Б\"),COUNTIF(H36:AL36,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H36:AL36,\"А\"),COUNTIF(H36:AL36,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H36:AL36,\"К\"),COUNTIF(H36:AL36,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H36:AL36,\"Д\"),COUNTIF(H36:AL36,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H36:AL36,\"У\"),COUNTIF(H36:AL36,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H36:AL36),--$H$59:$AL$59))","v":30}]
[]
[null,null,null,null,null,null,null,null,null,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":"COUNT(H39:AL39)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H39:AL39)*ТАБЛИЦА!$C$1:$C$28)","v":16},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H39:AL39,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H40:AL40)","v":126}]
[null,null,10,"Зиновьев Н.Н.",907,5,"такелажник",null,"О","О","О",8,8,null,null,8,8,7,null,null,null,null,8,8,8,8,8,null,null,8,8,8,8,7,null,null,8,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H39:AL39))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H39:AL39),H39:AL39,))","v":0},null,null,null,{"$f":"IF(COUNTIF(H39:AL39,\"д/о\"),COUNTIF(H39:AL39,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":4},{"$f":"IF(COUNTIF(H39:AL39,\"о\"),COUNTIF(H39:AL39,\"о\"),\"\")","v":3},{"$f":"MIN(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":4},{"$f":"IF(COUNTIF(H39:AL39,\"Б\"),COUNTIF(H39:AL39,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":4},{"$f":"IF(COUNTIF(H39:AL39,\"А\"),COUNTIF(H39:AL39,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":4},{"$f":"IF(COUNTIF(H39:AL39,\"К\"),COUNTIF(H39:AL39,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":4},{"$f":"IF(COUNTIF(H39:AL39,\"Д\"),COUNTIF(H39:AL39,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":4},{"$f":"IF(COUNTIF(H39:AL39,\"У\"),COUNTIF(H39:AL39,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H39:AL39),--$H$59:$AL$59))","v":4}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H42:AL42)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H42:AL42)*ТАБЛИЦА!$C$1:$C$28)","v":5},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H42:AL42,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H43:AL43)","v":40}]
[null,null,11,"Парфёнов А.В.",908,3,"такелажник",null,"Б","Б","Б","Б","Б",null,null,"Б","Б","Б",null,null,null,null,"Б","Б","Б","Б","Б",null,null,8,"А",8,8,8,null,null,8,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H42:AL42))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H42:AL42),H42:AL42,))","v":0},null,null,null,{"$f":"IF(COUNTIF(H42:AL42,\"д/о\"),COUNTIF(H42:AL42,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":24},{"$f":"IF(COUNTIF(H42:AL42,\"о\"),COUNTIF(H42:AL42,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":24},{"$f":"IF(COUNTIF(H42:AL42,\"Б\"),COUNTIF(H42:AL42,\"Б\"),\"\")","v":13},{"$f":"MIN(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":24},{"$f":"IF(COUNTIF(H42:AL42,\"А\"),COUNTIF(H42:AL42,\"А\"),\"\")","v":1},{"$f":"MIN(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":24},{"$f":"IF(COUNTIF(H42:AL42,\"К\"),COUNTIF(H42:AL42,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":24},{"$f":"IF(COUNTIF(H42:AL42,\"Д\"),COUNTIF(H42:AL42,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":24},{"$f":"IF(COUNTIF(H42:AL42,\"У\"),COUNTIF(H42:AL42,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H42:AL42),--$H$59:$AL$59))","v":24}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H45:AL45)+SUMPRODUCT((ТАБЛИЦА!$F$1:$F$28=H45:AL45)*ТАБЛИЦА!$G$1:$G$28)","v":6},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H45:AL45,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H46:AL46)","v":44}]
[null,null,12,"Московченко О.А.",909,4,"такелажник",null,8,7,7,7,7,null,null,8,"О","О",null,null,null,null,"О","О","О","О","О",null,null,"О","О","О","О","О",null,null,"О",null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H45:AL45))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H45:AL45),H45:AL45,))","v":0},null,null,null,{"$f":"IF(COUNTIF(H45:AL45,\"д/о\"),COUNTIF(H45:AL45,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":10},{"$f":"MAX(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H45:AL45,\"о\"),COUNTIF(H45:AL45,\"о\"),\"\")","v":13},{"$f":"MIN(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":10},{"$f":"MAX(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H45:AL45,\"Б\"),COUNTIF(H45:AL45,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":10},{"$f":"MAX(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H45:AL45,\"А\"),COUNTIF(H45:AL45,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":10},{"$f":"MAX(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H45:AL45,\"К\"),COUNTIF(H45:AL45,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":10},{"$f":"MAX(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H45:AL45,\"Д\"),COUNTIF(H45:AL45,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":10},{"$f":"MAX(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":30},{"$f":"IF(COUNTIF(H45:AL45,\"У\"),COUNTIF(H45:AL45,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":10},{"$f":"MAX(IF(ISTEXT(H45:AL45),--$H$59:$AL$59))","v":30}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H48:AL48)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H48:AL48)*ТАБЛИЦА!$C$1:$C$28)","v":2},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H48:AL48,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H49:AL49)","v":16}]
[null,null,13,"Гундаков А.А.",910,3,"такелажник",null,"Б","Б","Б","Б","Б",null,null,"Б","Б","Б",null,null,null,null,"Б","Б","Б","Б","Б",null,null,"Б","Б","Б","Б",8,null,null,8,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H48:AL48))","v":0},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H48:AL48),H48:AL48,))","v":0},null,null,null,{"$f":"IF(COUNTIF(H48:AL48,\"д/о\"),COUNTIF(H48:AL48,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":26},{"$f":"IF(COUNTIF(H48:AL48,\"о\"),COUNTIF(H48:AL48,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":26},{"$f":"IF(COUNTIF(H48:AL48,\"Б\"),COUNTIF(H48:AL48,\"Б\"),\"\")","v":17},{"$f":"MIN(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":26},{"$f":"IF(COUNTIF(H48:AL48,\"А\"),COUNTIF(H48:AL48,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":26},{"$f":"IF(COUNTIF(H48:AL48,\"К\"),COUNTIF(H48:AL48,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":26},{"$f":"IF(COUNTIF(H48:AL48,\"Д\"),COUNTIF(H48:AL48,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":26},{"$f":"IF(COUNTIF(H48:AL48,\"У\"),COUNTIF(H48:AL48,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":2},{"$f":"MAX(IF(ISTEXT(H48:AL48),--$H$59:$AL$59))","v":26}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H51:AL51)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H51:AL51)*ТАБЛИЦА!$C$1:$C$28)","v":22.93},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H51:AL51,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H52:AL52)","v":183.5}]
[null,null,14,"Румянцев Д.А.",911,4,"такелажник",null,8,8,8,8,8,8,null,8,8,"6/я",null,8,8,null,8,8,8,"6/я",8,8,null,"3,5/я",8,8,8,8,8,null,8,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H51:AL51))","v":5},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H51:AL51),H51:AL51,))","v":40},null,null,null,{"$f":"IF(COUNTIF(H51:AL51,\"д/о\"),COUNTIF(H51:AL51,\"д/о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":23},{"$f":"IF(COUNTIF(H51:AL51,\"о\"),COUNTIF(H51:AL51,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":23},{"$f":"IF(COUNTIF(H51:AL51,\"Б\"),COUNTIF(H51:AL51,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":23},{"$f":"IF(COUNTIF(H51:AL51,\"А\"),COUNTIF(H51:AL51,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":23},{"$f":"IF(COUNTIF(H51:AL51,\"К\"),COUNTIF(H51:AL51,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":23},{"$f":"IF(COUNTIF(H51:AL51,\"Д\"),COUNTIF(H51:AL51,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":23},{"$f":"IF(COUNTIF(H51:AL51,\"У\"),COUNTIF(H51:AL51,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":11},{"$f":"MAX(IF(ISTEXT(H51:AL51),--$H$59:$AL$59))","v":23},null,"2.Как сделать чтобы не ститал если (я/6;где взято увольнен)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Так-как он видет (ТЕКСТ \"Я\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H54:AL54)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H54:AL54)*ТАБЛИЦА!$C$1:$C$28)","v":24},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H54:AL54,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H55:AL55)","v":168}]
[null,802,15,"Остапчик А.Б.",914,5,"такелажник",null,7,7,7,7,7,7,null,"Д/О",7,6,null,7,7,8,7,7,7,7,7,7,null,7,7,7,7,7,7,null,7,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H54:AL54))","v":6},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H54:AL54),H54:AL54,))","v":43},null," ",null,{"$f":"IF(COUNTIF(H54:AL54,\"д/о\"),COUNTIF(H54:AL54,\"д/о\"),\"\")","v":1},{"$f":"MIN(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"MAX(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"IF(COUNTIF(H54:AL54,\"о\"),COUNTIF(H54:AL54,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"MAX(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"IF(COUNTIF(H54:AL54,\"Б\"),COUNTIF(H54:AL54,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"MAX(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"IF(COUNTIF(H54:AL54,\"А\"),COUNTIF(H54:AL54,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"MAX(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"IF(COUNTIF(H54:AL54,\"К\"),COUNTIF(H54:AL54,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"MAX(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"IF(COUNTIF(H54:AL54,\"Д\"),COUNTIF(H54:AL54,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"MAX(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"IF(COUNTIF(H54:AL54,\"У\"),COUNTIF(H54:AL54,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9},{"$f":"MAX(IF(ISTEXT(H54:AL54),--$H$59:$AL$59))","v":9}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H57:AL57)+SUMPRODUCT((ТАБЛИЦА!$B$1:$B$28=H57:AL57)*ТАБЛИЦА!$C$1:$C$28)","v":24},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(H57:AL57,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))+SUM(H58:AL58)","v":172}]
[null,203,16,"Челпанников С.Ю.",918,5,"такелажник",null,7,7,7,"Д/О",7,7,8,7,7,"Д/О",null,8,8,8,7,7,7,7,7,7,null,7,7,7,7,7,7,null,7,null,null,null,{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*ISNUMBER(H57:AL57))","v":7},{"$f":"SUM(((IFERROR(WEEKDAY(H$9:AL$9,2),)>5)+(ISNUMBER(MATCH(--H$9:AL$9,T$2:AD$2,))))*IF(ISNUMBER(H57:AL57),H57:AL57,))","v":53},null,null,null,{"$f":"IF(COUNTIF(H57:AL57,\"д/о\"),COUNTIF(H57:AL57,\"д/о\"),\"\")","v":2},{"$f":"MIN(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":5},{"$f":"MAX(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":11},{"$f":"IF(COUNTIF(H57:AL57,\"о\"),COUNTIF(H57:AL57,\"о\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":5},{"$f":"MAX(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":11},{"$f":"IF(COUNTIF(H57:AL57,\"Б\"),COUNTIF(H57:AL57,\"Б\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":5},{"$f":"MAX(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":11},{"$f":"IF(COUNTIF(H57:AL57,\"А\"),COUNTIF(H57:AL57,\"А\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":5},{"$f":"MAX(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":11},{"$f":"IF(COUNTIF(H57:AL57,\"К\"),COUNTIF(H57:AL57,\"К\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":5},{"$f":"MAX(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":11},{"$f":"IF(COUNTIF(H57:AL57,\"Д\"),COUNTIF(H57:AL57,\"Д\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":5},{"$f":"MAX(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":11},{"$f":"IF(COUNTIF(H57:AL57,\"У\"),COUNTIF(H57:AL57,\"У\"),\"\")","v":""},{"$f":"MIN(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":5},{"$f":"MAX(IF(ISTEXT(H57:AL57),--$H$59:$AL$59))","v":11}]
[]
[null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]

{"sheet":"ТАБЛИЦА","index":1,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":true,"merged":[[0,0,27,0],[0,4,27,4],[31,9,31,11],[1,9,2,9],[4,9,5,9]]}
["8 часовой рабочий день","7,5/я",0.94,null,"7 часовой рабочий день"]
[null,"7/я",0.87,null,null,null,null,null,null,"Ж","ПРОИЗВЕД(P14*            (R14/100)/160*T14)"]
[null,"6,5/я",0.81,null,null,"6,5/я",0.93,null,null,null,"                      Оклад*(% допл/100/ кол-во дней раб.графика(М) * кол-во отраб.часов "]
[null,"6/я",0.75,null,null,"6/я",0.86]
[null,"5,5/я",0.68,null,null,"5,5/я",0.78,null,null,"М","ПРОИЗВЕД(P9*(R9/100)/17*S9)"]
[null,"5/я",0.62,null,null,"5/я",0.71,null,null,null,"                      Оклад*(% допл/100/ кол-во дней раб графика * кол-во отраб.часов "]
[null,"4,5/я",0.56000000000000005,null,null,"4,5/я",0.64]
[null,"4/я",0.5,null,null,"4/я",0.56999999999999995]
[null,"3,5/я",0.43,null,null,"3,5/я",0.5]
[null,"3/я",0.37,null,null,"3/я",0.43]
[null,"2,5/я",0.31,null,null,"2,5/я",0.36]
[null,"2/я",0.25,null,null,"2/я",0.28000000000000003]
[null,"1,5/я",0.18,null,null,"1,5/я",0.21]
[null,"1/я",0.12,null,null,"1/я",0.14000000000000001]
[null,"я/1",0.12,null,null,"я/1",0.14000000000000001]
[null,"я/1,5",0.18,null,null,"я/1,5",0.21]
[null,"я/2",0.25,null,null,"я/2",0.28000000000000003]
[null,"я/2,5",0.31,null,null,"я/2,5",0.36]
[null,"я/3",0.37,null,null,"я/3",0.43]
[null,"я/3,5",0.43,null,null,"я/3,5",0.5]
[null,"я/4",0.5,null,null,"я/4",0.56999999999999995]
[null,"я/4,5",0.56000000000000005,null,null,"я/4,5",0.64]
[null,"я/5",0.62,null,null,"я/5",0.71]
[null,"я/5,5",0.68,null,null,"я/5,5",0.78]
[null,"я/6",0.75,null,null,"я/6",0.86]
[null,"я/6,5",0.81,null,null,"я/6,5",0.93]
[null,"я/7",0.87]
[null,"я/7,5",0.94]
[]
[]
[null,null,null,null,null,"Кол-во дней","Кол-во часов "]
["Д/О",7,5.5,8,7,{"$f":"COUNT(A32:E32)+SUMPRODUCT(($B$1:$B$28=A32:E32)*$C$1:$C$28)","v":4},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(A32:E32,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))","v":27.5}]
[7,"6/Я",5,8,7,{"$f":"COUNT(A33:E33)+SUMPRODUCT(($B$1:$B$28=A33:E33)*$C$1:$C$28)","v":4.75},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(A33:E33,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))","v":27}]
[7,7,6,8,7,{"$f":"COUNT(A34:E34)+SUMPRODUCT(($B$1:$B$28=A34:E34)*$C$1:$C$28)","v":5},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(A34:E34,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))","v":35}]
[7,7,"Б",8,7,{"$f":"COUNT(A35:E35)+SUMPRODUCT(($B$1:$B$28=A35:E35)*$C$1:$C$28)","v":4},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(A35:E35,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))","v":29}]
[7,7,"*",8,7,{"$f":"COUNT(A36:E36)+SUMPRODUCT(($B$1:$B$28=A36:E36)*$C$1:$C$28)","v":4},{"$f":"SUMPRODUCT(--TEXT(SUBSTITUTE(SUBSTITUTE(A36:E36,\"я\",\"\"),\"/\",\"\"),\"#,#;;0;\\0\"))","v":29}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[7,7,8,8,7,{"$f":"COUNT(A72:E72)+SUMPRODUCT(($B$1:$B$28=A72:E72)*$C$1:$C$28)","v":5},{"$f":"SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(A72:E72,\"я\",\"\"),\"/\",\"*\"))","v":37}]

{"sheet":"СПИСОК","index":2,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":true,"merged":[[6,1,6,7]]}
["№","таб","Ф.И.О.","Ф.И.О.","шифр","разряд","категория","оклады"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
[]
[]
[]
["1 табл.","2 табл."]
["За",719,"Зыкова А.В.",null,31170,null,4]
[1,860,"Перепёлкина О.П.",null,92200,null,2]
[2,28,"Петровский С.А.",null,28185,null,6]
[3,30,"Шевчук А.Н.",null,28180,null,6]
[4,900,"Горбачёв Г.Е.","Горбачёва Г.Е.",98500,4,1,5491]
["% доплат",901,"Мошнегуца Г.М.","Мошнегуцу Г.М.",98500,5,1,6033]
[5,902,"Коновалов А.Г.","Коновалова А.Г.",98500,5,1,6033]
[10,905,"Стасюк И.И.","Стасюка И.И.",98500,5,1,6033]
[15,906,"Кузьмина И.В.","Кузьмину И.В.",98400,3,1,4998]
[20,907,"Зиновьев Н.Н.","Зиновьева Н.Н.",98500,5,1,6033]
[25,908,"Парфёнов А.В.","Парфёнова А.В.",98500,3,1,4998]
[30,909,"Московченко О.А.","Московченко О.А.",98400,4,1,5491]
[35,910,"Гундаков А.А.","Гундакова А.А.",98500,3,1,4998]
[40,911,"Румянцев Д.А.","Румянцева Д.А.",98500,4,1,5491]
[45,914,"Остапчик А.Б.","Остапчика А.Б.",98500,5,1,6033]
[50,918,"Челпанников С.Ю.","Челпанникова С.Ю.",98500,5,1,6033]
[55,919,"Соколов С.В.","Соколова С.В.",98500,3,1,4998]
[60,920,"Копусов Р.А.","Копусова Р.А.",98500,5,1,6033]
[65,921,"Нецветаев А.В.","Нецветаева А.В.",98500,5,1,6033]
[70,923,"Самойлов С.А.","Самойлова С.А.",98500,4,1,5491]

{"sheet":"норма","index":3,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":true,"merged":[[11,1,13,1],[0,1,0,11],[1,3,1,11],[2,1,4,1],[5,1,7,1],[8,1,10,1],[24,1,26,1],[27,1,29,1],[16,1,16,6],[17,3,17,4],[17,5,17,6],[18,1,20,1],[21,1,23,1]]}
[2014,"Заполняется раз в год"]
[null,null,null,"Праздничные"]
[null,"1 квартал","январь",1,2,3,6,7,8,null,null,null,null,"тут нужно заполнять ТОЛЬКО праздники, которые НЕ в выходные дни"]
[null,null,"февраль",null,null,null,null,null,null,null,null,null,null,"Если случайна заполнили иначе, то выдельтся красным"]
[null,null,"март",10]
[null,"2 квартал","апрель"]
[null,null,"май",1,2,9]
[null,null,"июнь",12,13]
[null,"3 квартал","июль"]
[null,null,"август"]
[null,null,"сентябрь"]
[null,"4 квартал","октябрь"]
[null,null,"ноябрь",3,4]
[null,null,"декабрь"]
[]
[]
[null,"Производственный календарь на 2014г. при 5 дневной рабочей неделе"]
[null,null,null,"муж.гр",null,"жен.гр"]
[null,"1 квартал","январь",17,136,17,123]
[null,null,"февраль",20,159,20,143]
[null,null,"март",20,159,20,144]
[null,"2 квартал","апрель",22,175,22,157]
[null,null,"май",19,151,19,136]
[null,null,"июнь",19,151,19,137]
[null,"3 квартал","июль",23,184,23,165]
[null,null,"август",21,168,21,151]
[null,null,"сентябрь",22,176,22,159]
[null,"4 квартал","октябрь",23,184,23,165]
[null,null,"ноябрь",18,144,18,129]
[null,null,"декабрь",23,183,23,163]