{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":29,"n_cols":34,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,1,20,7],[20,9,20,15],[20,17,20,23],[20,25,20,31],[4,1,4,7],[4,9,4,15],[5,1,5,7],[5,9,5,15],[12,17,12,23],[12,25,12,31]]}
[]
["осталось дней до конца периода",{"$f":"DATE(YEAR(TODAY()),5,1)-TODAY()","v":45}]
["Количество/% выходных",{"$f":"CountByColor(B8:P13,A3)","v":21},{"$f":"B3/B2","v":0.46666666666666667}]
["Количество/% рабочих смен",{"$f":"B2-B3","v":24},{"$f":"B4/B2","v":0.53333333333333333}]
[]
[null,{"$f":"TEXT(DATE($AH$29,Q6,1),\"ММММ\")","v":"Март"},null,null,null,null,null,null,null,{"$f":"TEXT(DATE($AH$29,I7,1),\"ММММ\")","v":"Апрель"},null,null,null,null,null,null,{"$f":"((INT(ROWS($B$4:R6)/8)+1)-1)*4+(INT(COLUMNS($B$4:R6)/8)+1)","v":3}]
[null,"ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС",{"$f":"((INT(ROWS($B$4:Z6)/8)+1)-1)*4+(INT(COLUMNS($B$4:Z6)/8)+1)","v":4},"ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС"]
[null,{"$f":"IF(COUNTA(B7:B7)<WEEKDAY(DATE($AH$29,Q6,1),2),\"\",IF(B7=TEXT(DATE($AH$29,Q6,1),\"ДДД\"),1,MAX(Q7:R7)+1))","v":""},{"$f":"IF(COUNTA(B7:C7)<WEEKDAY(DATE($AH$29,Q6,1),2),\"\",IF(C7=TEXT(DATE($AH$29,Q6,1),\"ДДД\"),1,MAX(B8:B8)+1))","v":1},{"$f":"IF(COUNTA(B7:D7)<WEEKDAY(DATE($AH$29,Q6,1),2),\"\",IF(D7=TEXT(DATE($AH$29,Q6,1),\"ДДД\"),1,MAX(B8:C8)+1))","v":2},{"$f":"IF(COUNTA(B7:E7)<WEEKDAY(DATE($AH$29,Q6,1),2),\"\",IF(E7=TEXT(DATE($AH$29,Q6,1),\"ДДД\"),1,MAX(B8:D8)+1))","v":3},{"$f":"IF(COUNTA(B7:F7)<WEEKDAY(DATE($AH$29,Q6,1),2),\"\",IF(F7=TEXT(DATE($AH$29,Q6,1),\"ДДД\"),1,MAX(B8:E8)+1))","v":4},{"$f":"IF(COUNTA(B7:G7)<WEEKDAY(DATE($AH$29,Q6,1),2),\"\",IF(G7=TEXT(DATE($AH$29,Q6,1),\"ДДД\"),1,MAX(B8:F8)+1))","v":5},{"$f":"IF(COUNTA(B7:H7)<WEEKDAY(DATE($AH$29,Q6,1),2),\"\",IF(H7=TEXT(DATE($AH$29,Q6,1),\"ДДД\"),1,MAX(B8:G8)+1))","v":6},null,{"$f":"IF(COUNTA(J7:J7)<WEEKDAY(DATE($AH$29,I7,1),2),\"\",IF(J7=TEXT(DATE($AH$29,I7,1),\"ДДД\"),1,MAX(I8:J8)+1))","v":""},{"$f":"IF(COUNTA(J7:K7)<WEEKDAY(DATE($AH$29,I7,1),2),\"\",IF(K7=TEXT(DATE($AH$29,I7,1),\"ДДД\"),1,MAX(J8:J8)+1))","v":""},{"$f":"IF(COUNTA(J7:L7)<WEEKDAY(DATE($AH$29,I7,1),2),\"\",IF(L7=TEXT(DATE($AH$29,I7,1),\"ДДД\"),1,MAX(J8:K8)+1))","v":""},{"$f":"IF(COUNTA(J7:M7)<WEEKDAY(DATE($AH$29,I7,1),2),\"\",IF(M7=TEXT(DATE($AH$29,I7,1),\"ДДД\"),1,MAX(J8:L8)+1))","v":""},{"$f":"IF(COUNTA(J7:N7)<WEEKDAY(DATE($AH$29,I7,1),2),\"\",IF(N7=TEXT(DATE($AH$29,I7,1),\"ДДД\"),1,MAX(J8:M8)+1))","v":1},{"$f":"IF(COUNTA(J7:O7)<WEEKDAY(DATE($AH$29,I7,1),2),\"\",IF(O7=TEXT(DATE($AH$29,I7,1),\"ДДД\"),1,MAX(J8:N8)+1))","v":2},{"$f":"IF(COUNTA(J7:P7)<WEEKDAY(DATE($AH$29,I7,1),2),\"\",IF(P7=TEXT(DATE($AH$29,I7,1),\"ДДД\"),1,MAX(J8:O8)+1))","v":3}]
[null,{"$f":"IF(MAX(B8:H8)+COUNTA(B7:B7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H8)+COUNTA(B7:B7))","v":7},{"$f":"IF(MAX(B8:H8)+COUNTA(B7:C7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H8)+COUNTA(B7:C7))","v":8},{"$f":"IF(MAX(B8:H8)+COUNTA(B7:D7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H8)+COUNTA(B7:D7))","v":9},{"$f":"IF(MAX(B8:H8)+COUNTA(B7:E7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H8)+COUNTA(B7:E7))","v":10},{"$f":"IF(MAX(B8:H8)+COUNTA(B7:F7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H8)+COUNTA(B7:F7))","v":11},12,{"$f":"IF(MAX(B8:H8)+COUNTA(B7:H7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H8)+COUNTA(B7:H7))","v":13},null,{"$f":"IF(MAX(J8:P8)+COUNTA(J7:J7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P8)+COUNTA(J7:J7))","v":4},{"$f":"IF(MAX(J8:P8)+COUNTA(J7:K7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P8)+COUNTA(J7:K7))","v":5},{"$f":"IF(MAX(J8:P8)+COUNTA(J7:L7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P8)+COUNTA(J7:L7))","v":6},{"$f":"IF(MAX(J8:P8)+COUNTA(J7:M7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P8)+COUNTA(J7:M7))","v":7},{"$f":"IF(MAX(J8:P8)+COUNTA(J7:N7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P8)+COUNTA(J7:N7))","v":8},{"$f":"IF(MAX(J8:P8)+COUNTA(J7:O7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P8)+COUNTA(J7:O7))","v":9},{"$f":"IF(MAX(J8:P8)+COUNTA(J7:P7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P8)+COUNTA(J7:P7))","v":10}]
[null,{"$f":"IF(MAX(B8:H9)+COUNTA(B7:B7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H9)+COUNTA(B7:B7))","v":14},{"$f":"IF(MAX(B8:H9)+COUNTA(B7:C7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H9)+COUNTA(B7:C7))","v":15},{"$f":"IF(MAX(B8:H9)+COUNTA(B7:D7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H9)+COUNTA(B7:D7))","v":16},{"$f":"IF(MAX(B8:H9)+COUNTA(B7:E7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H9)+COUNTA(B7:E7))","v":17},{"$f":"IF(MAX(B8:H9)+COUNTA(B7:F7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H9)+COUNTA(B7:F7))","v":18},19,{"$f":"IF(MAX(B8:H9)+COUNTA(B7:H7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H9)+COUNTA(B7:H7))","v":20},null,{"$f":"IF(MAX(J8:P9)+COUNTA(J7:J7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P9)+COUNTA(J7:J7))","v":11},{"$f":"IF(MAX(J8:P9)+COUNTA(J7:K7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P9)+COUNTA(J7:K7))","v":12},{"$f":"IF(MAX(J8:P9)+COUNTA(J7:L7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P9)+COUNTA(J7:L7))","v":13},{"$f":"IF(MAX(J8:P9)+COUNTA(J7:M7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P9)+COUNTA(J7:M7))","v":14},{"$f":"IF(MAX(J8:P9)+COUNTA(J7:N7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P9)+COUNTA(J7:N7))","v":15},{"$f":"IF(MAX(J8:P9)+COUNTA(J7:O7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P9)+COUNTA(J7:O7))","v":16},{"$f":"IF(MAX(J8:P9)+COUNTA(J7:P7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P9)+COUNTA(J7:P7))","v":17}]
[null,{"$f":"IF(MAX(B8:H10)+COUNTA(B7:B7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H10)+COUNTA(B7:B7))","v":21},{"$f":"IF(MAX(B8:H10)+COUNTA(B7:C7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H10)+COUNTA(B7:C7))","v":22},{"$f":"IF(MAX(B8:H10)+COUNTA(B7:D7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H10)+COUNTA(B7:D7))","v":23},{"$f":"IF(MAX(B8:H10)+COUNTA(B7:E7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H10)+COUNTA(B7:E7))","v":24},{"$f":"IF(MAX(B8:H10)+COUNTA(B7:F7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H10)+COUNTA(B7:F7))","v":25},{"$f":"IF(MAX(B8:H10)+COUNTA(B7:G7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H10)+COUNTA(B7:G7))","v":26},{"$f":"IF(MAX(B8:H10)+COUNTA(B7:H7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H10)+COUNTA(B7:H7))","v":27},null,{"$f":"IF(MAX(J8:P10)+COUNTA(J7:J7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P10)+COUNTA(J7:J7))","v":18},{"$f":"IF(MAX(J8:P10)+COUNTA(J7:K7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P10)+COUNTA(J7:K7))","v":19},{"$f":"IF(MAX(J8:P10)+COUNTA(J7:L7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P10)+COUNTA(J7:L7))","v":20},{"$f":"IF(MAX(J8:P10)+COUNTA(J7:M7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P10)+COUNTA(J7:M7))","v":21},{"$f":"IF(MAX(J8:P10)+COUNTA(J7:N7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P10)+COUNTA(J7:N7))","v":22},{"$f":"IF(MAX(J8:P10)+COUNTA(J7:O7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P10)+COUNTA(J7:O7))","v":23},{"$f":"IF(MAX(J8:P10)+COUNTA(J7:P7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P10)+COUNTA(J7:P7))","v":24}]
[null,{"$f":"IF(MAX(B8:H11)+COUNTA(B7:B7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H11)+COUNTA(B7:B7))","v":28},{"$f":"IF(MAX(B8:H11)+COUNTA(B7:C7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H11)+COUNTA(B7:C7))","v":29},{"$f":"IF(MAX(B8:H11)+COUNTA(B7:D7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H11)+COUNTA(B7:D7))","v":30},{"$f":"IF(MAX(B8:H11)+COUNTA(B7:E7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H11)+COUNTA(B7:E7))","v":31},{"$f":"IF(MAX(B8:H11)+COUNTA(B7:F7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H11)+COUNTA(B7:F7))","v":""},{"$f":"IF(MAX(B8:H11)+COUNTA(B7:G7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H11)+COUNTA(B7:G7))","v":""},{"$f":"IF(MAX(B8:H11)+COUNTA(B7:H7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H11)+COUNTA(B7:H7))","v":""},null,{"$f":"IF(MAX(J8:P11)+COUNTA(J7:J7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P11)+COUNTA(J7:J7))","v":25},{"$f":"IF(MAX(J8:P11)+COUNTA(J7:K7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P11)+COUNTA(J7:K7))","v":26},{"$f":"IF(MAX(J8:P11)+COUNTA(J7:L7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P11)+COUNTA(J7:L7))","v":27},{"$f":"IF(MAX(J8:P11)+COUNTA(J7:M7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P11)+COUNTA(J7:M7))","v":28},{"$f":"IF(MAX(J8:P11)+COUNTA(J7:N7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P11)+COUNTA(J7:N7))","v":29},{"$f":"IF(MAX(J8:P11)+COUNTA(J7:O7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P11)+COUNTA(J7:O7))","v":30},{"$f":"IF(MAX(J8:P11)+COUNTA(J7:P7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P11)+COUNTA(J7:P7))","v":""}]
[null,{"$f":"IF(MAX(B8:H12)+COUNTA(B7:B7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H12)+COUNTA(B7:B7))","v":""},{"$f":"IF(MAX(B8:H12)+COUNTA(B7:C7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H12)+COUNTA(B7:C7))","v":""},null,{"$f":"IF(MAX(B8:H12)+COUNTA(B7:E7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H12)+COUNTA(B7:E7))","v":""},{"$f":"IF(MAX(B8:H12)+COUNTA(B7:F7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H12)+COUNTA(B7:F7))","v":""},{"$f":"IF(MAX(B8:H12)+COUNTA(B7:G7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H12)+COUNTA(B7:G7))","v":""},{"$f":"IF(MAX(B8:H12)+COUNTA(B7:H7)>DAY(DATE($AH$29,Q6+1,1)-1),\"\",MAX(B8:H12)+COUNTA(B7:H7))","v":""},null,{"$f":"IF(MAX(J8:P12)+COUNTA(J7:J7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P12)+COUNTA(J7:J7))","v":""},{"$f":"IF(MAX(J8:P12)+COUNTA(J7:K7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P12)+COUNTA(J7:K7))","v":""},{"$f":"IF(MAX(J8:P12)+COUNTA(J7:L7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P12)+COUNTA(J7:L7))","v":""},{"$f":"IF(MAX(J8:P12)+COUNTA(J7:M7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P12)+COUNTA(J7:M7))","v":""},{"$f":"IF(MAX(J8:P12)+COUNTA(J7:N7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P12)+COUNTA(J7:N7))","v":""},{"$f":"IF(MAX(J8:P12)+COUNTA(J7:O7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P12)+COUNTA(J7:O7))","v":""},{"$f":"IF(MAX(J8:P12)+COUNTA(J7:P7)>DAY(DATE($AH$29,I7+1,1)-1),\"\",MAX(J8:P12)+COUNTA(J7:P7))","v":""}]
[{"$f":"((INT(ROWS($B$4:B14)/8)+1)-1)*4+(INT(COLUMNS($B$4:B14)/8)+1)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((INT(ROWS($B$4:R14)/8)+1)-1)*4+(INT(COLUMNS($B$4:R14)/8)+1)","v":7}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"((INT(ROWS($B$4:B22)/8)+1)-1)*4+(INT(COLUMNS($B$4:B22)/8)+1)","v":9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((INT(ROWS($B$4:R22)/8)+1)-1)*4+(INT(COLUMNS($B$4:R22)/8)+1)","v":11}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}