{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Заполнение","График","Рассчет"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"2017-05-01"]
[]
[]
[]
[]
[null,"Выходные"]
[{"$f":"IF(B8=\"\",\"\",1)","v":1},{"$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-05-06"}]
[{"$f":"IF(B9=\"\",\"\",1)","v":1},{"$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-05-07"}]
[1,{"$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-05-13"}]
[1,{"$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-05-14"}]
[1,{"$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-05-20"}]
[1,{"$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-05-21"}]
[1,{"$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-05-27"}]
[1,{"$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-05-28"}]
[1,"2017-05-01"]
[1,"2017-05-08"]
[1,"2017-05-09"]
["",{"$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":""}]
["",{"$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":""}]
["",{"$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":""}]
["",{"$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":62,"n_cols":33,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"IF(Заполнение!B2=\"\",\"\",Заполнение!B2)","v":"2017-05-01"},{"$f":"IF(ISERR(C2+1),\"\",IF(C2+1<=EOMONTH(Заполнение!$B$2,0),C2+1,\"\"))","v":"2017-05-02"},{"$f":"IF(ISERR(D2+1),\"\",IF(D2+1<=EOMONTH(Заполнение!$B$2,0),D2+1,\"\"))","v":"2017-05-03"},{"$f":"IF(ISERR(E2+1),\"\",IF(E2+1<=EOMONTH(Заполнение!$B$2,0),E2+1,\"\"))","v":"2017-05-04"},{"$f":"IF(ISERR(F2+1),\"\",IF(F2+1<=EOMONTH(Заполнение!$B$2,0),F2+1,\"\"))","v":"2017-05-05"},{"$f":"IF(ISERR(G2+1),\"\",IF(G2+1<=EOMONTH(Заполнение!$B$2,0),G2+1,\"\"))","v":"2017-05-06"},{"$f":"IF(ISERR(H2+1),\"\",IF(H2+1<=EOMONTH(Заполнение!$B$2,0),H2+1,\"\"))","v":"2017-05-07"},{"$f":"IF(ISERR(I2+1),\"\",IF(I2+1<=EOMONTH(Заполнение!$B$2,0),I2+1,\"\"))","v":"2017-05-08"},{"$f":"IF(ISERR(J2+1),\"\",IF(J2+1<=EOMONTH(Заполнение!$B$2,0),J2+1,\"\"))","v":"2017-05-09"},{"$f":"IF(ISERR(K2+1),\"\",IF(K2+1<=EOMONTH(Заполнение!$B$2,0),K2+1,\"\"))","v":"2017-05-10"},{"$f":"IF(ISERR(L2+1),\"\",IF(L2+1<=EOMONTH(Заполнение!$B$2,0),L2+1,\"\"))","v":"2017-05-11"},{"$f":"IF(ISERR(M2+1),\"\",IF(M2+1<=EOMONTH(Заполнение!$B$2,0),M2+1,\"\"))","v":"2017-05-12"},{"$f":"IF(ISERR(N2+1),\"\",IF(N2+1<=EOMONTH(Заполнение!$B$2,0),N2+1,\"\"))","v":"2017-05-13"},{"$f":"IF(ISERR(O2+1),\"\",IF(O2+1<=EOMONTH(Заполнение!$B$2,0),O2+1,\"\"))","v":"2017-05-14"},{"$f":"IF(ISERR(P2+1),\"\",IF(P2+1<=EOMONTH(Заполнение!$B$2,0),P2+1,\"\"))","v":"2017-05-15"},{"$f":"IF(ISERR(Q2+1),\"\",IF(Q2+1<=EOMONTH(Заполнение!$B$2,0),Q2+1,\"\"))","v":"2017-05-16"},{"$f":"IF(ISERR(R2+1),\"\",IF(R2+1<=EOMONTH(Заполнение!$B$2,0),R2+1,\"\"))","v":"2017-05-17"},{"$f":"IF(ISERR(S2+1),\"\",IF(S2+1<=EOMONTH(Заполнение!$B$2,0),S2+1,\"\"))","v":"2017-05-18"},{"$f":"IF(ISERR(T2+1),\"\",IF(T2+1<=EOMONTH(Заполнение!$B$2,0),T2+1,\"\"))","v":"2017-05-19"},{"$f":"IF(ISERR(U2+1),\"\",IF(U2+1<=EOMONTH(Заполнение!$B$2,0),U2+1,\"\"))","v":"2017-05-20"},{"$f":"IF(ISERR(V2+1),\"\",IF(V2+1<=EOMONTH(Заполнение!$B$2,0),V2+1,\"\"))","v":"2017-05-21"},{"$f":"IF(ISERR(W2+1),\"\",IF(W2+1<=EOMONTH(Заполнение!$B$2,0),W2+1,\"\"))","v":"2017-05-22"},{"$f":"IF(ISERR(X2+1),\"\",IF(X2+1<=EOMONTH(Заполнение!$B$2,0),X2+1,\"\"))","v":"2017-05-23"},{"$f":"IF(ISERR(Y2+1),\"\",IF(Y2+1<=EOMONTH(Заполнение!$B$2,0),Y2+1,\"\"))","v":"2017-05-24"},{"$f":"IF(ISERR(Z2+1),\"\",IF(Z2+1<=EOMONTH(Заполнение!$B$2,0),Z2+1,\"\"))","v":"2017-05-25"},{"$f":"IF(ISERR(AA2+1),\"\",IF(AA2+1<=EOMONTH(Заполнение!$B$2,0),AA2+1,\"\"))","v":"2017-05-26"},{"$f":"IF(ISERR(AB2+1),\"\",IF(AB2+1<=EOMONTH(Заполнение!$B$2,0),AB2+1,\"\"))","v":"2017-05-27"},{"$f":"IF(ISERR(AC2+1),\"\",IF(AC2+1<=EOMONTH(Заполнение!$B$2,0),AC2+1,\"\"))","v":"2017-05-28"},{"$f":"IF(ISERR(AD2+1),\"\",IF(AD2+1<=EOMONTH(Заполнение!$B$2,0),AD2+1,\"\"))","v":"2017-05-29"},{"$f":"IF(ISERR(AE2+1),\"\",IF(AE2+1<=EOMONTH(Заполнение!$B$2,0),AE2+1,\"\"))","v":"2017-05-30"},{"$f":"IF(ISERR(AF2+1),\"\",IF(AF2+1<=EOMONTH(Заполнение!$B$2,0),AF2+1,\"\"))","v":"2017-05-31"}]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]

{"sheet":"Рассчет","index":2,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C2,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(Заполнение!B2=\"\",\"\",Заполнение!B2)","v":"2017-05-01"},{"$f":"IF(C2=\"\",\"\",IF(WEEKDAY(C2,2)=1,\"пон\",IF(WEEKDAY(C2,2)=2,\"вт\",IF(WEEKDAY(C2,2)=3,\"ср\",IF(WEEKDAY(C2,2)=4,\"чет\",IF(WEEKDAY(C2,2)=5,\"пят\",IF(WEEKDAY(C2,2)=6,\"суб\",\"воск\")))))))","v":"пон"}]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C3,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C2+1),\"\",IF(C2+1<=EOMONTH(Заполнение!$B$2,0),C2+1,\"\"))","v":"2017-05-02"},{"$f":"IF(C3=\"\",\"\",IF(WEEKDAY(C3,2)=1,\"пон\",IF(WEEKDAY(C3,2)=2,\"вт\",IF(WEEKDAY(C3,2)=3,\"ср\",IF(WEEKDAY(C3,2)=4,\"чет\",IF(WEEKDAY(C3,2)=5,\"пят\",IF(WEEKDAY(C3,2)=6,\"суб\",\"воск\")))))))","v":"вт"}]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C4,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C3+1),\"\",IF(C3+1<=EOMONTH(Заполнение!$B$2,0),C3+1,\"\"))","v":"2017-05-03"},"ср"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C5,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C4+1),\"\",IF(C4+1<=EOMONTH(Заполнение!$B$2,0),C4+1,\"\"))","v":"2017-05-04"},"чет"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C6,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C5+1),\"\",IF(C5+1<=EOMONTH(Заполнение!$B$2,0),C5+1,\"\"))","v":"2017-05-05"},"пят"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C7,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C6+1),\"\",IF(C6+1<=EOMONTH(Заполнение!$B$2,0),C6+1,\"\"))","v":"2017-05-06"},"суб"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C8,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C7+1),\"\",IF(C7+1<=EOMONTH(Заполнение!$B$2,0),C7+1,\"\"))","v":"2017-05-07"},"воск"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C9,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C8+1),\"\",IF(C8+1<=EOMONTH(Заполнение!$B$2,0),C8+1,\"\"))","v":"2017-05-08"},"пон"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C10,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C9+1),\"\",IF(C9+1<=EOMONTH(Заполнение!$B$2,0),C9+1,\"\"))","v":"2017-05-09"},"вт"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C11,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C10+1),\"\",IF(C10+1<=EOMONTH(Заполнение!$B$2,0),C10+1,\"\"))","v":"2017-05-10"},"ср"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C12,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C11+1),\"\",IF(C11+1<=EOMONTH(Заполнение!$B$2,0),C11+1,\"\"))","v":"2017-05-11"},"чет"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C13,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C12+1),\"\",IF(C12+1<=EOMONTH(Заполнение!$B$2,0),C12+1,\"\"))","v":"2017-05-12"},"пят"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C14,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C13+1),\"\",IF(C13+1<=EOMONTH(Заполнение!$B$2,0),C13+1,\"\"))","v":"2017-05-13"},"суб"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C15,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C14+1),\"\",IF(C14+1<=EOMONTH(Заполнение!$B$2,0),C14+1,\"\"))","v":"2017-05-14"},"воск"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C16,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C15+1),\"\",IF(C15+1<=EOMONTH(Заполнение!$B$2,0),C15+1,\"\"))","v":"2017-05-15"},"пон"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C17,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C16+1),\"\",IF(C16+1<=EOMONTH(Заполнение!$B$2,0),C16+1,\"\"))","v":"2017-05-16"},"вт"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C18,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C17+1),\"\",IF(C17+1<=EOMONTH(Заполнение!$B$2,0),C17+1,\"\"))","v":"2017-05-17"},"ср"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C19,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C18+1),\"\",IF(C18+1<=EOMONTH(Заполнение!$B$2,0),C18+1,\"\"))","v":"2017-05-18"},"чет"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C20,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C19+1),\"\",IF(C19+1<=EOMONTH(Заполнение!$B$2,0),C19+1,\"\"))","v":"2017-05-19"},"пят"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C21,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C20+1),\"\",IF(C20+1<=EOMONTH(Заполнение!$B$2,0),C20+1,\"\"))","v":"2017-05-20"},"суб"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C22,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C21+1),\"\",IF(C21+1<=EOMONTH(Заполнение!$B$2,0),C21+1,\"\"))","v":"2017-05-21"},"воск"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C23,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C22+1),\"\",IF(C22+1<=EOMONTH(Заполнение!$B$2,0),C22+1,\"\"))","v":"2017-05-22"},"пон"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C24,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C23+1),\"\",IF(C23+1<=EOMONTH(Заполнение!$B$2,0),C23+1,\"\"))","v":"2017-05-23"},"вт"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C25,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C24+1),\"\",IF(C24+1<=EOMONTH(Заполнение!$B$2,0),C24+1,\"\"))","v":"2017-05-24"},"ср"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C26,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C25+1),\"\",IF(C25+1<=EOMONTH(Заполнение!$B$2,0),C25+1,\"\"))","v":"2017-05-25"},"чет"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C27,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C26+1),\"\",IF(C26+1<=EOMONTH(Заполнение!$B$2,0),C26+1,\"\"))","v":"2017-05-26"},"пят"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C28,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C27+1),\"\",IF(C27+1<=EOMONTH(Заполнение!$B$2,0),C27+1,\"\"))","v":"2017-05-27"},"суб"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C29,Заполнение!$B$8:$B$22,0)),\"\")","v":1},{"$f":"IF(ISERR(C28+1),\"\",IF(C28+1<=EOMONTH(Заполнение!$B$2,0),C28+1,\"\"))","v":"2017-05-28"},"воск"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C30,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C29+1),\"\",IF(C29+1<=EOMONTH(Заполнение!$B$2,0),C29+1,\"\"))","v":"2017-05-29"},"пон"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C31,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C30+1),\"\",IF(C30+1<=EOMONTH(Заполнение!$B$2,0),C30+1,\"\"))","v":"2017-05-30"},"вт"]
[null,{"$f":"IFERROR(INDEX(Заполнение!$A$8:$A$22,MATCH(C32,Заполнение!$B$8:$B$22,0)),\"\")","v":""},{"$f":"IF(ISERR(C31+1),\"\",IF(C31+1<=EOMONTH(Заполнение!$B$2,0),C31+1,\"\"))","v":"2017-05-31"},"ср"]