{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Заполнение","График"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,3,2,8],[2,10,2,15]]}
[]
[null,"2018-07-01"]
[null,null,null,"Будни",null,null,null,null,null,null,"Выходные"]
[null,null,null,1,null,null,null,null,"09:00:00",null,1,null,null,null,null,"10:00:00"]
[null,11.791666666666666,null,"Рез",null,null,null,null,"09:00:00",null,"Рез",null,null,null,null,"10:00:00"]
[null,null,null,"2е",null,null,null,null,"09:00:00",null,"2е",null,null,null,null,"10:00:00"]
[null,"Выходные",null,"3л",null,null,null,null,"09:00:00",null,"3л",null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B1)),\"\"))","v":"2018-07-01"},null,3,null,null,null,null,"09:00:00",null,3,null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B8=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B2)),\"\")))","v":"2018-07-07"},null,"р4р",null,null,null,null,"09:00:00",null,"р4р",null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B9=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B3)),\"\")))","v":"2018-07-08"},null,"лн7",null,null,null,null,"09:00:00",null,"лн7",null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B10=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B4)),\"\")))","v":"2018-07-14"},null,5,null,null,null,null,"09:00:00",null,5,null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B11=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B5)),\"\")))","v":"2018-07-15"},null,869,null,null,null,null,"09:00:00",null,869,null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B12=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B6)),\"\")))","v":"2018-07-21"},null,"47п",null,null,null,null,"09:00:00",null,"47п",null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B13=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B7)),\"\")))","v":"2018-07-22"},null,"пдл",null,null,null,null,"09:00:00",null,"пдл",null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B14=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B8)),\"\")))","v":"2018-07-28"},null,"е68",null,null,null,null,"09:00:00",null,"е68",null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B15=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B9)),\"\")))","v":"2018-07-29"},null,"лш4",null,null,null,null,"09:00:00",null,"лш4",null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B16=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B10)),\"\")))","v":""},null,65,null,null,null,null,"09:00:00",null,65,null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B17=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B11)),\"\")))","v":""},null,7,null,null,null,null,"09:00:00",null,7,null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B18=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B12)),\"\")))","v":""},null,9,null,null,null,null,"09:00:00",null,9,null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B19=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B13)),\"\")))","v":""},null,15,null,null,null,null,"09:00:00",null,15,null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B20=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B14)),\"\")))","v":""},null,22,null,null,null,null,"09:00:00",null,22,null,null,null,null,"10:00:00"]
[null,{"$f":"IF($B$2=\"\",\"\",IF($B21=EOMONTH($B$2,0),\"\",IFERROR(SMALL(IF(WEEKDAY($B$2+ROW($1:$31)-1,2)>5,$B$2+ROW($1:$31)-1),ROW(B15)),\"\")))","v":""},null,"9н",null,null,null,null,"09:00:00",null,"9н",null,null,null,null,"10:00:00"]
[null,null,null,"ь7",null,null,null,null,"09:00:00",null,"ь7",null,null,null,null,"10:00:00"]
[null,null,null,35,null,null,null,null,"09:00:00",null,35,null,null,null,null,"10:00:00"]
[null,null,null,36,null,null,null,null,"09:00:00",null,36,null,null,null,null,"10:00:00"]
[null,null,null,37,null,null,null,null,"09:00:00",null,37,null,null,null,null,"10:00:00"]
[null,null,null,38,null,null,null,null,"09:00:00",null,38,null,null,null,null,"10:00:00"]
[null,null,null,39,null,null,null,null,"09:00:00",null,39,null,null,null,null,"10:00:00"]
[null,null,null,40,null,null,null,null,"09:00:00",null,40,null,null,null,null,"10:00:00"]
[null,null,null,41,null,null,null,null,"09:00:00",null,41,null,null,null,null,"10:00:00"]
[null,null,null,42,null,null,null,null,"09:00:00",null,42,null,null,null,null,"10:00:00"]
[null,null,null,43,null,null,null,null,"09:00:00",null,43,null,null,null,null,"10:00:00"]
[null,null,null,44,null,null,null,null,"09:00:00",null,44,null,null,null,null,"10:00:00"]
[null,null,null,45,null,null,null,null,"09:00:00",null,45,null,null,null,null,"10:00:00"]
[null,null,null,46,null,null,null,null,"09:00:00",null,46,null,null,null,null,"10:00:00"]
[null,null,null,47,null,null,null,null,"09:00:00",null,47,null,null,null,null,"10:00:00"]
[null,null,null,48,null,null,null,null,"09:00:00",null,48,null,null,null,null,"10:00:00"]
[null,null,null,49,null,null,null,null,"09:00:00",null,49,null,null,null,null,"10:00:00"]

{"sheet":"График","index":1,"n_rows":7,"n_cols":38,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,34,4,35]]}
[]
[]
[]
[null,null,null,"СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ","СЧ"]
[null,null,null,{"$f":"IF(Заполнение!B2=\"\",\"\",Заполнение!B2)","v":"2018-07-01"},{"$f":"IF(ISERR(D5+1),\"\",IF(D5+1<=EOMONTH(Заполнение!$B$2,0),D5+1,\"\"))","v":"2018-07-02"},{"$f":"IF(ISERR(E5+1),\"\",IF(E5+1<=EOMONTH(Заполнение!$B$2,0),E5+1,\"\"))","v":"2018-07-03"},{"$f":"IF(ISERR(F5+1),\"\",IF(F5+1<=EOMONTH(Заполнение!$B$2,0),F5+1,\"\"))","v":"2018-07-04"},{"$f":"IF(ISERR(G5+1),\"\",IF(G5+1<=EOMONTH(Заполнение!$B$2,0),G5+1,\"\"))","v":"2018-07-05"},{"$f":"IF(ISERR(H5+1),\"\",IF(H5+1<=EOMONTH(Заполнение!$B$2,0),H5+1,\"\"))","v":"2018-07-06"},{"$f":"IF(ISERR(I5+1),\"\",IF(I5+1<=EOMONTH(Заполнение!$B$2,0),I5+1,\"\"))","v":"2018-07-07"},{"$f":"IF(ISERR(J5+1),\"\",IF(J5+1<=EOMONTH(Заполнение!$B$2,0),J5+1,\"\"))","v":"2018-07-08"},{"$f":"IF(ISERR(K5+1),\"\",IF(K5+1<=EOMONTH(Заполнение!$B$2,0),K5+1,\"\"))","v":"2018-07-09"},{"$f":"IF(ISERR(L5+1),\"\",IF(L5+1<=EOMONTH(Заполнение!$B$2,0),L5+1,\"\"))","v":"2018-07-10"},{"$f":"IF(ISERR(M5+1),\"\",IF(M5+1<=EOMONTH(Заполнение!$B$2,0),M5+1,\"\"))","v":"2018-07-11"},{"$f":"IF(ISERR(N5+1),\"\",IF(N5+1<=EOMONTH(Заполнение!$B$2,0),N5+1,\"\"))","v":"2018-07-12"},{"$f":"IF(ISERR(O5+1),\"\",IF(O5+1<=EOMONTH(Заполнение!$B$2,0),O5+1,\"\"))","v":"2018-07-13"},{"$f":"IF(ISERR(P5+1),\"\",IF(P5+1<=EOMONTH(Заполнение!$B$2,0),P5+1,\"\"))","v":"2018-07-14"},{"$f":"IF(ISERR(Q5+1),\"\",IF(Q5+1<=EOMONTH(Заполнение!$B$2,0),Q5+1,\"\"))","v":"2018-07-15"},{"$f":"IF(ISERR(R5+1),\"\",IF(R5+1<=EOMONTH(Заполнение!$B$2,0),R5+1,\"\"))","v":"2018-07-16"},{"$f":"IF(ISERR(S5+1),\"\",IF(S5+1<=EOMONTH(Заполнение!$B$2,0),S5+1,\"\"))","v":"2018-07-17"},{"$f":"IF(ISERR(T5+1),\"\",IF(T5+1<=EOMONTH(Заполнение!$B$2,0),T5+1,\"\"))","v":"2018-07-18"},{"$f":"IF(ISERR(U5+1),\"\",IF(U5+1<=EOMONTH(Заполнение!$B$2,0),U5+1,\"\"))","v":"2018-07-19"},{"$f":"IF(ISERR(V5+1),\"\",IF(V5+1<=EOMONTH(Заполнение!$B$2,0),V5+1,\"\"))","v":"2018-07-20"},{"$f":"IF(ISERR(W5+1),\"\",IF(W5+1<=EOMONTH(Заполнение!$B$2,0),W5+1,\"\"))","v":"2018-07-21"},{"$f":"IF(ISERR(X5+1),\"\",IF(X5+1<=EOMONTH(Заполнение!$B$2,0),X5+1,\"\"))","v":"2018-07-22"},{"$f":"IF(ISERR(Y5+1),\"\",IF(Y5+1<=EOMONTH(Заполнение!$B$2,0),Y5+1,\"\"))","v":"2018-07-23"},{"$f":"IF(ISERR(Z5+1),\"\",IF(Z5+1<=EOMONTH(Заполнение!$B$2,0),Z5+1,\"\"))","v":"2018-07-24"},{"$f":"IF(ISERR(AA5+1),\"\",IF(AA5+1<=EOMONTH(Заполнение!$B$2,0),AA5+1,\"\"))","v":"2018-07-25"},{"$f":"IF(ISERR(AB5+1),\"\",IF(AB5+1<=EOMONTH(Заполнение!$B$2,0),AB5+1,\"\"))","v":"2018-07-26"},{"$f":"IF(ISERR(AC5+1),\"\",IF(AC5+1<=EOMONTH(Заполнение!$B$2,0),AC5+1,\"\"))","v":"2018-07-27"},{"$f":"IF(ISERR(AD5+1),\"\",IF(AD5+1<=EOMONTH(Заполнение!$B$2,0),AD5+1,\"\"))","v":"2018-07-28"},{"$f":"IF(ISERR(AE5+1),\"\",IF(AE5+1<=EOMONTH(Заполнение!$B$2,0),AE5+1,\"\"))","v":"2018-07-29"},{"$f":"IF(ISERR(AF5+1),\"\",IF(AF5+1<=EOMONTH(Заполнение!$B$2,0),AF5+1,\"\"))","v":"2018-07-30"},{"$f":"IF(ISERR(AG5+1),\"\",IF(AG5+1<=EOMONTH(Заполнение!$B$2,0),AG5+1,\"\"))","v":"2018-07-31"},"Рабочее время",null,"Норма"]
[null,1,null,"46!","1!","Рез!","2е!","3л!","3!","р4р!","лн7!","5!","869!","47п!","пдл!","е68!","лш4!","65!",7,"9!","15!",22,"9н!","ь7!","35!","36!",37,"38!","39!",40,"41!",42,43,"44!",{"$f":"IFERROR(IF(AK6>AJ6,AK6-AJ6,AJ6-AK6),0)","v":9.5},{"$f":"(SUM(IF(COUNTIF(Заполнение!$B$8:$B$22,$D$5:$AH$5),(($D6:$AH6)=Заполнение!$K$4:$K$38)*Заполнение!$P$4:$P$38,($D6:$AH6=Заполнение!$D$4:$D$38)*Заполнение!$I$4:$I$38)*($D$4:$AH$4=\"сч\")))","v":2.291666666666667},{"$f":"IF(B6=\"\",\"\",IF((Заполнение!$B$5-AL6*8/24)<0,0,Заполнение!$B$5-AL6*8/24)-IFERROR(INDEX(Заполнение!$V$4:$V$160,MATCH($B6,Заполнение!$U$4:$U$160,0)),0)+IFERROR(INDEX(Заполнение!$W$4:$W$160,MATCH($B6,Заполнение!$U$4:$U$160,0)),0))","v":11.791666666666666},{"$f":"IF(B6=\"\",\"\",(SUMPRODUCT((D6:AH6=\"О\")*ISNA(MATCH($D$5:$AH$5,Заполнение!$B$8:$B$22,)))+SUMPRODUCT((D6:AH6=\"Б\")*ISNA(MATCH($D$5:$AH$5,Заполнение!$B$8:$B$22,)))))","v":0}]
[null,2,null,46,1,"Рез","2е","3л",3,"р4р","лн7",5,869,"47п","пдл","е68","лш4",65,7,9,15,22,"9н","ь7",35,36,37,38,39,40,41,42,43,44,{"$f":"IFERROR(IF(AK7>AJ7,AK7-AJ7,AJ7-AK7),0)","v":0.20833333333333215},{"$f":"(SUM(IF(COUNTIF(Заполнение!$B$8:$B$22,$D$5:$AH$5),(($D7:$AH7)=Заполнение!$K$4:$K$38)*Заполнение!$P$4:$P$38,($D7:$AH7=Заполнение!$D$4:$D$38)*Заполнение!$I$4:$I$38)*($D$4:$AH$4=\"сч\")))","v":11.999999999999998},{"$f":"IF(B7=\"\",\"\",IF((Заполнение!$B$5-AL7*8/24)<0,0,Заполнение!$B$5-AL7*8/24)-IFERROR(INDEX(Заполнение!$V$4:$V$160,MATCH($B7,Заполнение!$U$4:$U$160,0)),0)+IFERROR(INDEX(Заполнение!$W$4:$W$160,MATCH($B7,Заполнение!$U$4:$U$160,0)),0))","v":11.791666666666666},{"$f":"IF(B7=\"\",\"\",(SUMPRODUCT((D7:AH7=\"О\")*ISNA(MATCH($D$5:$AH$5,Заполнение!$B$8:$B$22,)))+SUMPRODUCT((D7:AH7=\"Б\")*ISNA(MATCH($D$5:$AH$5,Заполнение!$B$8:$B$22,)))))","v":0}]