{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Заполнение","Маршруты"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"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":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,3,2,4],[2,6,2,7]]}
[]
[null,"2017-07-01"]
[null,null,null,"Будни",null,null,"Выходные"]
[null,null,null,1,"08:00:00",null,1,"02:00:00"]
[null,null,null,2,"09:00:00",null,4,0.125]
[null,null,null,5,"02:00:00"]
[null,"Выходные"]
[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":"2017-07-01"}]
[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":"2017-07-02"}]
[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":"2017-07-08"}]
[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":"2017-07-09"}]
[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":"2017-07-15"}]
[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":"2017-07-16"}]
[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":"2017-07-22"}]
[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":"2017-07-23"}]
[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":"2017-07-29"}]
[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":"2017-07-30"}]
[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,{"$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,{"$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,{"$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,{"$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":""}]

{"sheet":"Маршруты","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Дата/маршрут",1,2,3,4,5,6,7,8,9,10,11,13,14,15]
[null,{"$f":"IF(Заполнение!B2=\"\",\"\",Заполнение!B2)","v":"2017-07-01"}]
[null,{"$f":"IF(ISERR(B3+1),\"\",IF(B3+1<=EOMONTH(Заполнение!$B$2,0),B3+1,\"\"))","v":"2017-07-02"},"08:00:00",null,null,"05:00:00"]
[null,{"$f":"IF(ISERR(B4+1),\"\",IF(B4+1<=EOMONTH(Заполнение!$B$2,0),B4+1,\"\"))","v":"2017-07-03"},null,"06:00:00"]
[null,{"$f":"IF(ISERR(B5+1),\"\",IF(B5+1<=EOMONTH(Заполнение!$B$2,0),B5+1,\"\"))","v":"2017-07-04"},"12:00:00"]
[null,{"$f":"IF(ISERR(B6+1),\"\",IF(B6+1<=EOMONTH(Заполнение!$B$2,0),B6+1,\"\"))","v":"2017-07-05"}]
[null,{"$f":"IF(ISERR(B7+1),\"\",IF(B7+1<=EOMONTH(Заполнение!$B$2,0),B7+1,\"\"))","v":"2017-07-06"},null,"03:00:00",null,null,"01:52:00"]
[null,{"$f":"IF(ISERR(B8+1),\"\",IF(B8+1<=EOMONTH(Заполнение!$B$2,0),B8+1,\"\"))","v":"2017-07-07"},null,"15:00:00"]
[null,{"$f":"IF(ISERR(B9+1),\"\",IF(B9+1<=EOMONTH(Заполнение!$B$2,0),B9+1,\"\"))","v":"2017-07-08"},"01:00:00"]
[null,{"$f":"IF(ISERR(B10+1),\"\",IF(B10+1<=EOMONTH(Заполнение!$B$2,0),B10+1,\"\"))","v":"2017-07-09"}]
[null,{"$f":"IF(ISERR(B11+1),\"\",IF(B11+1<=EOMONTH(Заполнение!$B$2,0),B11+1,\"\"))","v":"2017-07-10"}]
[null,{"$f":"IF(ISERR(B12+1),\"\",IF(B12+1<=EOMONTH(Заполнение!$B$2,0),B12+1,\"\"))","v":"2017-07-11"}]
[null,{"$f":"IF(ISERR(B13+1),\"\",IF(B13+1<=EOMONTH(Заполнение!$B$2,0),B13+1,\"\"))","v":"2017-07-12"},null,null,null,null,"12:00:00"]
[null,{"$f":"IF(ISERR(B14+1),\"\",IF(B14+1<=EOMONTH(Заполнение!$B$2,0),B14+1,\"\"))","v":"2017-07-13"}]
[null,{"$f":"IF(ISERR(B15+1),\"\",IF(B15+1<=EOMONTH(Заполнение!$B$2,0),B15+1,\"\"))","v":"2017-07-14"}]
[null,{"$f":"IF(ISERR(B16+1),\"\",IF(B16+1<=EOMONTH(Заполнение!$B$2,0),B16+1,\"\"))","v":"2017-07-15"},null,null,null,"10:00:00"]
[null,{"$f":"IF(ISERR(B17+1),\"\",IF(B17+1<=EOMONTH(Заполнение!$B$2,0),B17+1,\"\"))","v":"2017-07-16"}]
[null,{"$f":"IF(ISERR(B18+1),\"\",IF(B18+1<=EOMONTH(Заполнение!$B$2,0),B18+1,\"\"))","v":"2017-07-17"}]
[null,{"$f":"IF(ISERR(B19+1),\"\",IF(B19+1<=EOMONTH(Заполнение!$B$2,0),B19+1,\"\"))","v":"2017-07-18"}]
[null,{"$f":"IF(ISERR(B20+1),\"\",IF(B20+1<=EOMONTH(Заполнение!$B$2,0),B20+1,\"\"))","v":"2017-07-19"}]
[null,{"$f":"IF(ISERR(B21+1),\"\",IF(B21+1<=EOMONTH(Заполнение!$B$2,0),B21+1,\"\"))","v":"2017-07-20"}]
[null,{"$f":"IF(ISERR(B22+1),\"\",IF(B22+1<=EOMONTH(Заполнение!$B$2,0),B22+1,\"\"))","v":"2017-07-21"}]
[null,{"$f":"IF(ISERR(B23+1),\"\",IF(B23+1<=EOMONTH(Заполнение!$B$2,0),B23+1,\"\"))","v":"2017-07-22"}]
[null,{"$f":"IF(ISERR(B24+1),\"\",IF(B24+1<=EOMONTH(Заполнение!$B$2,0),B24+1,\"\"))","v":"2017-07-23"}]
[null,{"$f":"IF(ISERR(B25+1),\"\",IF(B25+1<=EOMONTH(Заполнение!$B$2,0),B25+1,\"\"))","v":"2017-07-24"}]
[null,{"$f":"IF(ISERR(B26+1),\"\",IF(B26+1<=EOMONTH(Заполнение!$B$2,0),B26+1,\"\"))","v":"2017-07-25"}]
[null,{"$f":"IF(ISERR(B27+1),\"\",IF(B27+1<=EOMONTH(Заполнение!$B$2,0),B27+1,\"\"))","v":"2017-07-26"}]
[null,{"$f":"IF(ISERR(B28+1),\"\",IF(B28+1<=EOMONTH(Заполнение!$B$2,0),B28+1,\"\"))","v":"2017-07-27"}]
[null,{"$f":"IF(ISERR(B29+1),\"\",IF(B29+1<=EOMONTH(Заполнение!$B$2,0),B29+1,\"\"))","v":"2017-07-28"}]
[null,{"$f":"IF(ISERR(B30+1),\"\",IF(B30+1<=EOMONTH(Заполнение!$B$2,0),B30+1,\"\"))","v":"2017-07-29"}]
[null,{"$f":"IF(ISERR(B31+1),\"\",IF(B31+1<=EOMONTH(Заполнение!$B$2,0),B31+1,\"\"))","v":"2017-07-30"}]
[null,{"$f":"IF(ISERR(B32+1),\"\",IF(B32+1<=EOMONTH(Заполнение!$B$2,0),B32+1,\"\"))","v":"2017-07-31"}]
[null,"Общее время",{"$f":"SUM(C3:C33)","v":0.87499999999999989},{"$f":"SUM(D3:D33)","v":1},0,0.625,0.57777777777777772,0,0,0,0,0,0,0,0,0]