{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["отпуска","График","Черновик"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"отпуска","index":0,"n_rows":78,"n_cols":40,"rows_kept":78,"cut":false,"hidden":false,"merged":[[10,9,10,11],[11,9,11,10],[12,10,12,11],[13,10,13,11],[17,11,19,11],[20,6,20,7],[20,9,20,10],[4,10,4,11],[5,10,5,11],[6,0,6,8],[6,10,6,11],[7,0,7,8],[17,0,19,0],[17,1,19,1],[17,2,19,2],[17,3,19,3],[17,4,17,10],[18,4,19,4],[18,5,18,7],[18,8,18,10],[19,6,19,7],[19,9,19,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Структурное подразделение","Должность (специальность, профессия) по штатному расписанию","Фамилия, имя, отчество","Табельный номер",null,null,null,null,null,null,null,"Ознакомление"]
[null,null,null,null,"кол-во дней","дата",null,null,"перенесение отпуска"]
[null,null,null,null,null,"запланиро- ванная","фактическая",null,"основание (документ)","дата предполагаемого отпуска"]
[1,2,3,4,null,6,7,null,8,9,null,10]
["ЯНВАРЬ"]
[null,null,"рабочий 1",16884,15,"2015-01-05",{"$f":"IF(E23>EOMONTH(F23,0)-EOMONTH(F23,-1)-DAY(F23)+1,EOMONTH(F23,0)-EOMONTH(F23,-1)-DAY(F23)+1,E23)","v":15},null,{"$f":"IF(E23-G23>0,E23-G23,\"\")","v":""}]
[null,null,"рабочий 2",6991,15,"2015-01-06",{"$f":"IF(E24>EOMONTH(F24,0)-EOMONTH(F24,-1)-DAY(F24)+1,EOMONTH(F24,0)-EOMONTH(F24,-1)-DAY(F24)+1,E24)","v":15},null,{"$f":"IF(E24-G24>0,E24-G24,\"\")","v":""}]
[null,null,"рабочий 3",7455,15,"2015-01-07",{"$f":"IF(E25>EOMONTH(F25,0)-EOMONTH(F25,-1)-DAY(F25)+1,EOMONTH(F25,0)-EOMONTH(F25,-1)-DAY(F25)+1,E25)","v":15},null,{"$f":"IF(E25-G25>0,E25-G25,\"\")","v":""},null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,"рабочий 4",16655,15,"2015-01-08",{"$f":"IF(E26>EOMONTH(F26,0)-EOMONTH(F26,-1)-DAY(F26)+1,EOMONTH(F26,0)-EOMONTH(F26,-1)-DAY(F26)+1,E26)","v":15},null,{"$f":"IF(E26-G26>0,E26-G26,\"\")","v":""}]
[null,null,"рабочий 5",3033,15,"2015-01-09",{"$f":"IF(E27>EOMONTH(F27,0)-EOMONTH(F27,-1)-DAY(F27)+1,EOMONTH(F27,0)-EOMONTH(F27,-1)-DAY(F27)+1,E27)","v":15},null,{"$f":"IF(E27-G27>0,E27-G27,\"\")","v":""}]
[null,null,"рабочий 6",4578,15,"2015-01-10",{"$f":"IF(E28>EOMONTH(F28,0)-EOMONTH(F28,-1)-DAY(F28)+1,EOMONTH(F28,0)-EOMONTH(F28,-1)-DAY(F28)+1,E28)","v":15},null,{"$f":"IF(E28-G28>0,E28-G28,\"\")","v":""}]
[null,null,"рабочий 7",16813,15,"2015-01-11",{"$f":"IF(E29>EOMONTH(F29,0)-EOMONTH(F29,-1)-DAY(F29)+1,EOMONTH(F29,0)-EOMONTH(F29,-1)-DAY(F29)+1,E29)","v":15},null,{"$f":"IF(E29-G29>0,E29-G29,\"\")","v":""}]
["АВГУСТ"]
[null,null,"рабочий 1",16884,15,"2015-08-05",{"$f":"IF(E31>EOMONTH(F31,0)-EOMONTH(F31,-1)-DAY(F31)+1,EOMONTH(F31,0)-EOMONTH(F31,-1)-DAY(F31)+1,E31)","v":15},null,{"$f":"IF(E31-G31>0,E31-G31,\"\")","v":""}]
["СЕНТЯБРЬ"]
[null,null,"рабочий 2",6991,15,"2015-09-05",{"$f":"IF(E33>EOMONTH(F33,0)-EOMONTH(F33,-1)-DAY(F33)+1,EOMONTH(F33,0)-EOMONTH(F33,-1)-DAY(F33)+1,E33)","v":15},null,{"$f":"IF(E33-G33>0,E33-G33,\"\")","v":""}]
["ОКТЯБРЬ"]
[null,null,"рабочий 3",7455,15,"2015-10-05",{"$f":"IF(E35>EOMONTH(F35,0)-EOMONTH(F35,-1)-DAY(F35)+1,EOMONTH(F35,0)-EOMONTH(F35,-1)-DAY(F35)+1,E35)","v":15},null,{"$f":"IF(E35-G35>0,E35-G35,\"\")","v":""}]
[null,null,"рабочий 4",16655,15,"2015-10-06",{"$f":"IF(E36>EOMONTH(F36,0)-EOMONTH(F36,-1)-DAY(F36)+1,EOMONTH(F36,0)-EOMONTH(F36,-1)-DAY(F36)+1,E36)","v":15},null,{"$f":"IF(E36-G36>0,E36-G36,\"\")","v":""}]
["НОЯБРЬ"]
[null,null,"рабочий 5",3033,15,"2015-11-05",{"$f":"IF(E38>EOMONTH(F38,0)-EOMONTH(F38,-1)-DAY(F38)+1,EOMONTH(F38,0)-EOMONTH(F38,-1)-DAY(F38)+1,E38)","v":15},null,{"$f":"IF(E38-G38>0,E38-G38,\"\")","v":""}]
[null,null,"рабочий 6",4578,15,"2015-11-06",{"$f":"IF(E39>EOMONTH(F39,0)-EOMONTH(F39,-1)-DAY(F39)+1,EOMONTH(F39,0)-EOMONTH(F39,-1)-DAY(F39)+1,E39)","v":15},null,{"$f":"IF(E39-G39>0,E39-G39,\"\")","v":""}]
[null,null,"рабочий 7",16813,15,"2015-11-07",{"$f":"IF(E40>EOMONTH(F40,0)-EOMONTH(F40,-1)-DAY(F40)+1,EOMONTH(F40,0)-EOMONTH(F40,-1)-DAY(F40)+1,E40)","v":15},null,{"$f":"IF(E40-G40>0,E40-G40,\"\")","v":""}]
["ЯНВАРЬ"]
[null,null,"рабочий 1",16884,120,"2016-01-15",{"$f":"IF(E42>EOMONTH(F42,0)-EOMONTH(F42,-1)-DAY(F42)+1,EOMONTH(F42,0)-EOMONTH(F42,-1)-DAY(F42)+1,E42)","v":17},null,{"$f":"IF(E42-G42>0,E42-G42,\"\")","v":103}]
[null,null,"рабочий 2",6991,28,"05.01.2016",{"$f":"IF(E43>EOMONTH(F43,0)-EOMONTH(F43,-1)-DAY(F43)+1,EOMONTH(F43,0)-EOMONTH(F43,-1)-DAY(F43)+1,E43)","v":27},null,{"$f":"IF(E43-G43>0,E43-G43,\"\")","v":1}]
[null,null,"рабочий 3",7455,28,"15.01.2016",{"$f":"IF(E44>EOMONTH(F44,0)-EOMONTH(F44,-1)-DAY(F44)+1,EOMONTH(F44,0)-EOMONTH(F44,-1)-DAY(F44)+1,E44)","v":17},null,{"$f":"IF(E44-G44>0,E44-G44,\"\")","v":11},null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,"рабочий 4",16655,28,"15.01.2016",{"$f":"IF(E45>EOMONTH(F45,0)-EOMONTH(F45,-1)-DAY(F45)+1,EOMONTH(F45,0)-EOMONTH(F45,-1)-DAY(F45)+1,E45)","v":17},null,{"$f":"IF(E45-G45>0,E45-G45,\"\")","v":11}]
[null,null,"рабочий 5",3033,28,"15.01.2016",{"$f":"IF(E46>EOMONTH(F46,0)-EOMONTH(F46,-1)-DAY(F46)+1,EOMONTH(F46,0)-EOMONTH(F46,-1)-DAY(F46)+1,E46)","v":17},null,{"$f":"IF(E46-G46>0,E46-G46,\"\")","v":11}]
[null,null,"рабочий 6",4578,66,"2016-01-15",{"$f":"IF(E47>EOMONTH(F47,0)-EOMONTH(F47,-1)-DAY(F47)+1,EOMONTH(F47,0)-EOMONTH(F47,-1)-DAY(F47)+1,E47)","v":17},null,{"$f":"IF(E47-G47>0,E47-G47,\"\")","v":49}]
[null,null,"рабочий 7",16813,14,"2016-01-25",{"$f":"IF(E48>EOMONTH(F48,0)-EOMONTH(F48,-1)-DAY(F48)+1,EOMONTH(F48,0)-EOMONTH(F48,-1)-DAY(F48)+1,E48)","v":7},null,{"$f":"IF(E48-G48>0,E48-G48,\"\")","v":7}]
["АВГУСТ"]
[null,null,"рабочий 1",16884,28,"2016-08-25",{"$f":"IF(E50>EOMONTH(F50,0)-EOMONTH(F50,-1)-DAY(F50)+1,EOMONTH(F50,0)-EOMONTH(F50,-1)-DAY(F50)+1,E50)","v":7},null,{"$f":"IF(E50-G50>0,E50-G50,\"\")","v":21}]
["СЕНТЯБРЬ"]
[null,null,"рабочий 2",6991,28,"2016-09-15",{"$f":"IF(E52>EOMONTH(F52,0)-EOMONTH(F52,-1)-DAY(F52)+1,EOMONTH(F52,0)-EOMONTH(F52,-1)-DAY(F52)+1,E52)","v":16},null,{"$f":"IF(E52-G52>0,E52-G52,\"\")","v":12}]
["ОКТЯБРЬ"]
[null,null,"рабочий 3",7455,28,"2016-10-15",{"$f":"IF(E54>EOMONTH(F54,0)-EOMONTH(F54,-1)-DAY(F54)+1,EOMONTH(F54,0)-EOMONTH(F54,-1)-DAY(F54)+1,E54)","v":17},null,{"$f":"IF(E54-G54>0,E54-G54,\"\")","v":11}]
[null,null,"рабочий 4",16655,28,"2016-10-15",{"$f":"IF(E55>EOMONTH(F55,0)-EOMONTH(F55,-1)-DAY(F55)+1,EOMONTH(F55,0)-EOMONTH(F55,-1)-DAY(F55)+1,E55)","v":17},null,{"$f":"IF(E55-G55>0,E55-G55,\"\")","v":11}]
["НОЯБРЬ"]
[null,null,"рабочий 5",3033,28,"2016-11-15",{"$f":"IF(E57>EOMONTH(F57,0)-EOMONTH(F57,-1)-DAY(F57)+1,EOMONTH(F57,0)-EOMONTH(F57,-1)-DAY(F57)+1,E57)","v":16},null,{"$f":"IF(E57-G57>0,E57-G57,\"\")","v":12}]
[null,null,"рабочий 6",4578,35,"2016-11-15",{"$f":"IF(E58>EOMONTH(F58,0)-EOMONTH(F58,-1)-DAY(F58)+1,EOMONTH(F58,0)-EOMONTH(F58,-1)-DAY(F58)+1,E58)","v":16},null,{"$f":"IF(E58-G58>0,E58-G58,\"\")","v":19}]
[null,null,"рабочий 7",16813,14,"2016-11-15",{"$f":"IF(E59>EOMONTH(F59,0)-EOMONTH(F59,-1)-DAY(F59)+1,EOMONTH(F59,0)-EOMONTH(F59,-1)-DAY(F59)+1,E59)","v":14},null,{"$f":"IF(E59-G59>0,E59-G59,\"\")","v":""}]
["ЯНВАРЬ"]
[null,null,"рабочий 1",16884,15,"2017-01-05",{"$f":"IF(E61>EOMONTH(F61,0)-EOMONTH(F61,-1)-DAY(F61)+1,EOMONTH(F61,0)-EOMONTH(F61,-1)-DAY(F61)+1,E61)","v":15},null,{"$f":"IF(E61-G61>0,E61-G61,\"\")","v":""}]
[null,null,"рабочий 2",6991,15,"2017-01-06",{"$f":"IF(E62>EOMONTH(F62,0)-EOMONTH(F62,-1)-DAY(F62)+1,EOMONTH(F62,0)-EOMONTH(F62,-1)-DAY(F62)+1,E62)","v":15},null,{"$f":"IF(E62-G62>0,E62-G62,\"\")","v":""}]
[null,null,"рабочий 3",7455,15,"2017-01-07",{"$f":"IF(E63>EOMONTH(F63,0)-EOMONTH(F63,-1)-DAY(F63)+1,EOMONTH(F63,0)-EOMONTH(F63,-1)-DAY(F63)+1,E63)","v":15},null,{"$f":"IF(E63-G63>0,E63-G63,\"\")","v":""},null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,"рабочий 4",16655,15,"2017-01-08",{"$f":"IF(E64>EOMONTH(F64,0)-EOMONTH(F64,-1)-DAY(F64)+1,EOMONTH(F64,0)-EOMONTH(F64,-1)-DAY(F64)+1,E64)","v":15},null,{"$f":"IF(E64-G64>0,E64-G64,\"\")","v":""}]
[null,null,"рабочий 5",3033,15,"2017-01-09",{"$f":"IF(E65>EOMONTH(F65,0)-EOMONTH(F65,-1)-DAY(F65)+1,EOMONTH(F65,0)-EOMONTH(F65,-1)-DAY(F65)+1,E65)","v":15},null,{"$f":"IF(E65-G65>0,E65-G65,\"\")","v":""}]
[null,null,"рабочий 6",4578,15,"2017-01-10",{"$f":"IF(E66>EOMONTH(F66,0)-EOMONTH(F66,-1)-DAY(F66)+1,EOMONTH(F66,0)-EOMONTH(F66,-1)-DAY(F66)+1,E66)","v":15},null,{"$f":"IF(E66-G66>0,E66-G66,\"\")","v":""}]
[null,null,"рабочий 7",16813,15,"2017-01-11",{"$f":"IF(E67>EOMONTH(F67,0)-EOMONTH(F67,-1)-DAY(F67)+1,EOMONTH(F67,0)-EOMONTH(F67,-1)-DAY(F67)+1,E67)","v":15},null,{"$f":"IF(E67-G67>0,E67-G67,\"\")","v":""}]
["АВГУСТ"]
[null,null,"рабочий 1",16884,15,"2017-08-25",{"$f":"IF(E69>EOMONTH(F69,0)-EOMONTH(F69,-1)-DAY(F69)+1,EOMONTH(F69,0)-EOMONTH(F69,-1)-DAY(F69)+1,E69)","v":7},null,{"$f":"IF(E69-G69>0,E69-G69,\"\")","v":8}]
["СЕНТЯБРЬ"]
[null,null,"рабочий 2",6991,15,"2017-09-15",{"$f":"IF(E71>EOMONTH(F71,0)-EOMONTH(F71,-1)-DAY(F71)+1,EOMONTH(F71,0)-EOMONTH(F71,-1)-DAY(F71)+1,E71)","v":15},null,{"$f":"IF(E71-G71>0,E71-G71,\"\")","v":""}]
["ОКТЯБРЬ"]
[null,null,"рабочий 3",7455,15,"2017-10-15",{"$f":"IF(E73>EOMONTH(F73,0)-EOMONTH(F73,-1)-DAY(F73)+1,EOMONTH(F73,0)-EOMONTH(F73,-1)-DAY(F73)+1,E73)","v":15},null,{"$f":"IF(E73-G73>0,E73-G73,\"\")","v":""}]
[null,null,"рабочий 4",16655,15,"2017-10-16",{"$f":"IF(E74>EOMONTH(F74,0)-EOMONTH(F74,-1)-DAY(F74)+1,EOMONTH(F74,0)-EOMONTH(F74,-1)-DAY(F74)+1,E74)","v":15},null,{"$f":"IF(E74-G74>0,E74-G74,\"\")","v":""}]
["НОЯБРЬ"]
[null,null,"рабочий 5",3033,15,"2017-11-15",{"$f":"IF(E76>EOMONTH(F76,0)-EOMONTH(F76,-1)-DAY(F76)+1,EOMONTH(F76,0)-EOMONTH(F76,-1)-DAY(F76)+1,E76)","v":15},null,{"$f":"IF(E76-G76>0,E76-G76,\"\")","v":""}]
[null,null,"рабочий 6",4578,15,"2017-11-16",{"$f":"IF(E77>EOMONTH(F77,0)-EOMONTH(F77,-1)-DAY(F77)+1,EOMONTH(F77,0)-EOMONTH(F77,-1)-DAY(F77)+1,E77)","v":15},null,{"$f":"IF(E77-G77>0,E77-G77,\"\")","v":""}]
[null,null,"рабочий 7",16813,15,"2017-11-17",{"$f":"IF(E78>EOMONTH(F78,0)-EOMONTH(F78,-1)-DAY(F78)+1,EOMONTH(F78,0)-EOMONTH(F78,-1)-DAY(F78)+1,E78)","v":14},null,{"$f":"IF(E78-G78>0,E78-G78,\"\")","v":1}]

{"sheet":"График","index":1,"n_rows":37,"n_cols":57,"rows_kept":37,"cut":false,"hidden":false,"merged":[[37,42,39,42],[40,42,42,42],[16,41,18,41],[13,41,15,41],[10,41,12,41],[7,41,9,41],[31,42,33,42],[19,42,21,42],[22,42,24,42],[34,41,36,41],[28,41,30,41],[31,41,33,41],[25,41,27,41],[19,41,21,41],[22,41,24,41],[7,43,14,44],[34,42,36,42],[13,42,15,42],[16,42,18,42],[5,33,6,33],[5,34,6,34],[5,35,6,35],[5,36,6,36],[5,37,6,37],[5,38,6,38],[13,40,15,40],[7,42,9,42],[10,42,12,42],[25,42,27,42],[28,42,30,42],[7,40,9,40],[5,39,6,39],[5,40,6,40],[3,41,6,41],[19,39,21,39],[19,40,21,40],[10,39,12,39],[10,40,12,40],[13,39,15,39],[5,16,6,16],[5,17,6,17],[5,18,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,24,6,24],[0,16,0,21],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,39,4,40],[4,9,4,17],[4,18,4,20],[4,26,4,28],[4,29,4,30],[4,31,4,32],[2,1,2,41],[1,41,1,46],[3,8,3,21],[4,22,4,23],[3,22,3,38],[31,39,33,39],[22,40,24,40],[5,25,6,25],[5,26,6,26],[5,27,6,27],[5,28,6,28],[5,29,6,29],[5,30,6,30],[5,31,6,31],[5,32,6,32],[7,39,9,39],[22,39,24,39],[16,39,18,39],[16,40,18,40],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[22,6,24,6],[19,6,21,6],[34,6,36,6],[34,39,36,39],[34,40,36,40],[34,5,36,5],[28,39,30,39],[25,40,27,40],[28,40,30,40],[31,2,33,2],[31,3,33,3],[31,40,33,40],[28,3,30,3],[28,4,30,4],[25,5,27,5],[25,6,27,6],[25,39,27,39],[31,4,33,4],[31,5,33,5],[31,6,33,6],[25,2,27,2],[25,3,27,3],[25,4,27,4],[34,1,36,1],[34,2,36,2],[34,3,36,3],[34,4,36,4],[31,1,33,1],[28,2,30,2],[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4],[10,5,12,5],[10,6,12,6],[13,5,15,5],[28,1,30,1],[28,5,30,5],[28,6,30,6],[16,6,18,6],[22,1,24,1],[13,2,15,2],[13,3,15,3],[19,1,21,1],[19,2,21,2],[19,3,21,3],[19,4,21,4],[19,5,21,5],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[25,1,27,1],[16,5,18,5],[5,15,6,15],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6],[5,1,6,1],[13,4,15,4],[13,6,15,6],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[13,1,15,1]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-10-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,{"$f":"J5","v":"2015-10-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,{"$f":"Q1","v":"2015-10-01"},null,null,null,null,null,null,null,null,null,null,null,null,"Дней",null,{"$f":"DAY(EOMONTH(J5,0))","v":31},null,"Строк",null,null,null,null,1]
[null,"Табельный номер","Табельный номер","Граф. раб.","Сотрудник","Должность","Бригада","Часы",{"$f":"$Q$1+0","v":"2015-10-01"},{"$f":"IF(ISERR(I6+1),\"\",IF(I6+1<=EOMONTH($Q$1,0),I6+1,\"\"))","v":"2015-10-02"},"2015-10-03","2015-10-04","2015-10-05","2015-10-06","2015-10-07","2015-10-08","2015-10-09","2015-10-10","2015-10-11","2015-10-12","2015-10-13","2015-10-14","2015-10-15","2015-10-16","2015-10-17","2015-10-18","2015-10-19","2015-10-20","2015-10-21","2015-10-22","2015-10-23","2015-10-24","2015-10-25","2015-10-26","2015-10-27","2015-10-28","2015-10-29","2015-10-30",{"$f":"IF(ISERR(AL6+1),\"\",IF(AL6+1<=EOMONTH($Q$1,0),AL6+1,\"\"))","v":"2015-10-31"},"Итого смен","С графиком ознакомлен",null,"Нужны группы (диапазоны) по этому столбцу"]
[]
[null,44556,555,8,"ИТР1","начальник",null,"Смена",1,1,1,1,"В","В","В",1,1,1,4,"В","В",1,1,1,1,1,"В","В",1,1,1,1,4,"В","В",1,1,1,1,{"$f":"COUNTIF(I8:AM8,\"<>В\")-COUNTIFS(I8:AM8,\"<>В\",I10:AM10,\"<>\")","v":22},null,"ИТР","ИТР1","ИТР нужны по 1 человеку в группе или диапазоне"]
[null,null,null,null,null,null,null,"Часы"]
[]
[null,null,null,8,"ИТР2","заместитель",null,"Смена",1,1,"В","В",1,1,1,"В","В","В",1,1,1,3,3,"В","В",1,1,1,3,3,"В","В",1,1,1,"В",1,1,1,{"$f":"COUNTIF(I11:AM11,\"<>В\")-COUNTIFS(I11:AM11,\"<>В\",I13:AM13,\"<>\")","v":21},null,"ИТР","ИТР2"]
[null,null,null,null,null,null,null,"Часы",8,8,0,0,8,8,8,0,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,8,8,0,8,8,8]
[]
[null,null,null,7,"мастер 1","мастер 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,{"$f":"COUNTIF(I14:AM14,\"<>В\")-COUNTIFS(I14:AM14,\"<>В\",I16:AM16,\"<>\")","v":31},null,"ИТР","мастер 1"]
[null,null,null,null,null,null,null,"Часы",0,7,7,7,7,7,0,0,7,7,7,0,0,7,7,7,7,0,0,7,7,7,7,0,0,7,7,7,7,0,7]
[]
[null,null,null,7,"мастер 2","мастер 2",null,"Смена","В",2,2,1,1,"В","В","В",4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",{"$f":"COUNTIF(I17:AM17,\"<>В\")-COUNTIFS(I17:AM17,\"<>В\",I19:AM19,\"<>\")","v":19},null,"ИТР","мастер 2"]
[null,null,null,null,null,null,null,"Часы",7,7,7,7,0,7,7,0,7,0,0,7,7,7,7,0,0,7,7,7,7,0,0,7,7,7,7,0,0,7,7]
[]
[null,null,null,6,"рабочий 1","профессия 1",null,"Смена",1,1,1,1,"В","В","В","В",1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,{"$f":"COUNTIF(I20:AM20,\"<>В\")-COUNTIFS(I20:AM20,\"<>В\",I22:AM22,\"<>\")","v":21},null,"профессия 1","мастер 1"]
[null,null,null,null,null,null,null,"Часы",0,6,6,2,1,1,"В","В",4,4,"В",3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В"]
[null,null,null,null,null,null,null,"ОТ"]
[null,null,null,6,"рабочий 2","профессия 1",null,"Смена",1,1,1,1,"В","В","В","В",1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,{"$f":"COUNTIF(I23:AM23,\"<>В\")-COUNTIFS(I23:AM23,\"<>В\",I25:AM25,\"<>\")","v":21},null,"профессия 1","мастер 1"]
[null,null,null,null,null,null,null,"Часы",0,6,6,6,6,6,0,0,6,6,6,0,0,6,0,6,6,6,6,0,0,6,6,6,0,0,6,6,6,6,6]
[null,null,null,null,null,null,null,"ОТ"]
[null,null,null,6,"рабочий 3",null,null,"Смена","В",2,2,1,1,"В","В","В",4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",{"$f":"COUNTIF(I26:AM26,\"<>В\")-COUNTIFS(I26:AM26,\"<>В\",I28:AM28,\"<>\")","v":11},null,"профессия 1","мастер 2"]
[null,null,null,null,null,null,null,"Часы",6,6,6,6,0,6,6,0,6,0,0,6,6,6,6,0,0,6,6,6,6,0,0,6,6,6,6,0,0,6,6]
[null,null,null,null,null,null,null,"ОТ",null,null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,null,6,"рабочий 4",null,null,"Смена","В",2,2,1,1,"В","В","В",4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",{"$f":"COUNTIF(I29:AM29,\"<>В\")-COUNTIFS(I29:AM29,\"<>В\",I31:AM31,\"<>\")","v":11},null,"профессия 1","мастер 2"]
[null,null,null,null,null,null,null,"Часы",6,6,6,6,0,6,6,0,6,0,0,6,6,6,6,0,0,6,6,6,6,0,0,6,6,6,6,0,0,6,6]
[null,null,null,null,null,null,null,"ОТ",null,null,null,null,null,"ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ","ОТ"]
[null,null,null,6,"рабочий 5",null,null,"Смена",1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,{"$f":"COUNTIF(I32:AM32,\"<>В\")-COUNTIFS(I32:AM32,\"<>В\",I34:AM34,\"<>\")","v":21},null,"профессия 1","мастер 3"]
[null,null,null,null,null,null,null,"Часы",0,6,6,6,6,0,0,0,6,6,6,6,0,6,6,6,6,0,0,6,6,6,6,0,6,6,6,6,6,0,0]
[null,null,null,null,null,null,null,"ОТ"]
[null,null,null,6,"рабочий 6",null,null,"Смена",1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,{"$f":"COUNTIF(I35:AM35,\"<>В\")-COUNTIFS(I35:AM35,\"<>В\",I37:AM37,\"<>\")","v":21},null,"профессия 1","мастер 3"]
[null,null,null,null,null,null,null,"Часы",0,6,6,6,6,0,0,0,6,6,6,6,0,6,6,6,6,0,0,6,6,6,6,0,6,6,6,6,6,0,0]
[null,null,null,null,null,null,null,"ОТ"]

{"sheet":"Черновик","index":2,"n_rows":30,"n_cols":40,"rows_kept":30,"cut":false,"hidden":true,"merged":[[4,34,5,34],[4,10,5,10],[4,9,5,9],[4,8,5,8],[4,7,5,7],[4,33,5,33],[4,32,5,32],[4,31,5,31],[4,30,5,30],[4,29,5,29],[4,13,5,13],[4,12,5,12],[4,11,5,11],[4,15,5,15],[4,23,5,23],[4,22,5,22],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[0,16,0,21],[4,21,5,21],[4,20,5,20],[4,19,5,19],[4,18,5,18],[4,17,5,17],[4,16,5,16],[3,3,3,25],[4,5,5,5],[4,4,5,4],[4,6,5,6],[4,24,5,24],[4,14,5,14],[3,28,3,30],[4,28,5,28],[4,27,5,27],[4,26,5,26],[4,25,5,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-01"]
[]
[]
[null,null,null,{"$f":"График!J5","v":"2015-10-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,21]
["Ф, И, О,",null,null,{"$f":"$Q$1+0","v":"2016-03-01"},{"$f":"IF(ISERR(D5+1),\"\",IF(D5+1<=EOMONTH($Q$1,0),D5+1,\"\"))","v":"2016-03-02"},"2016-03-03","2016-03-04","2016-03-05","2016-03-06","2016-03-07","2016-03-08","2016-03-09","2016-03-10","2016-03-11","2016-03-12","2016-03-13","2016-03-14","2016-03-15","2016-03-16","2016-03-17","2016-03-18","2016-03-19","2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26","2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","ИТОГО"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I смена ","IIсмена","III смена ","iv смена ","выходные"]
["начальник","начальник",null,"В","В","В","В","В","В","В","В",1,1,4,"В","В",1,1,1,1,1,"В","В",1,1,1,1,4,"В","В",1,1,1,1,{"$f":"COUNT(D7:AH7)","v":17},{"$f":"COUNTIF(D7:AH7,1)","v":15},{"$f":"COUNTIF(D7:AH7,2)","v":0},{"$f":"COUNTIF(D7:AH7,3)","v":0},{"$f":"COUNTIF(D7:AH7,\"4\")","v":2},{"$f":"COUNTIF(D7:AH7,\"в\")","v":14}]
["заместитель","заместитель",null,1,1,"В","В",1,1,1,"В","В","В",1,1,1,3,3,"В","В",1,1,1,3,3,"В","В",1,1,1,"В",1,1,1,21,{"$f":"COUNTIF(D8:AH8,1)","v":17},0,4,0,10]
["заместитель","заместитель",null,"В",3,3,3,3,3,"В","В",3,3,3,3,3,"В","В",3,3,3,3,3,"В","В",3,3,3,3,3,"В","В","В",3,21,0,0,21,0,10]
["механик","механик",null,1,1,1,3,"В","В","В","В",1,1,1,"В","В",1,1,1,1,3,"В","В",1,1,1,1,1,"В","В",1,1,1,1,21,19,0,2,0,10]
["электромеханик","электромеханик",null,3,"В","В",1,1,1,1,"В",1,1,1,"В","В","В",1,1,1,1,1,"В","В",1,1,1,1,"В","В",3,3,3,2,21,16,1,4,0,10]
["электромеханик","электромеханик",null,"В","В",1,1,1,"В",3,"В",3,2,2,"В","В",1,1,1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,3,21,16,2,3,0,10]
[]
["I смена ",null,null,{"$f":"COUNTIF(D7:D12,1)","v":2},{"$f":"COUNTIF(E7:E12,1)","v":2},2,2,3,2,2,0,3,3,3,1,1,3,4,4,4,4,2,1,3,4,4,4,4,1,1,3,4,4,3]
["II смена ",null,null,{"$f":"COUNTIF(D7:D12,2)","v":0},{"$f":"COUNTIF(E7:E12,2)","v":0},0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
["III смена",null,null,{"$f":"COUNTIF(D7:D12,3)","v":1},{"$f":"COUNTIF(E7:E12,3)","v":1},1,2,1,1,1,0,2,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,2]
["IV смена",null,null,{"$f":"COUNTIF(D7:D12,4)","v":0},{"$f":"COUNTIF(E7:E12,4)","v":0},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0]
[]
["мастер 1",null,null,1,1,1,1,"В","В","В","В",1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,1,"В","В",1,1,1,1,{"$f":"COUNT(D19:AH19)","v":21},21,{"$f":"COUNTIF(D19:AH19,2)","v":0},{"$f":"COUNTIF(D19:AH19,3)","v":0},{"$f":"COUNTIF(D19:AH19,\"4\")","v":0},{"$f":"COUNTIF(D19:AH19,\"в\")","v":10}]
["мастер 2",null,null,2,1,1,"В","В",4,4,"В",3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,20,6,5,3,6,11]
["мастер 3",null,null,"В",2,2,1,1,"В","В","В",4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",19,6,6,4,3,12]
["мастер 4",null,null,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,21,6,6,5,4,10]
["мастер 5",null,null,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,21,5,4,6,6,10]
["мастер 6",null,null,4,3,3,"В","В",2,2,"В",1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",2,2,20,3,6,6,5,11]
["бригада 1",null,null,"В",4,4,3,3,"В","В","В",2,1,1,"В","В",4,4,3,3,"В","В",2,2,1,1,"В","В",4,4,3,3,"В","В",19,4,3,6,6,12]
["бригада 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["бригада 3",null,null,"В",3,3,3,3,3,"В","В",3,3,3,"В",4,4,4,4,"В","В",4,4,4,4,4,"В","В",3,3,3,3,"В","В",21]
["бригада 4"]
["бригада 5"]
["бригада 6",null,null,3,3,3,3,"В","В","В","В",3,3,3,"В","В",3,2,2,1,1,"В","В",3,3,3,3,3,"В","В",3,3,3,3,21]