{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Общий табель","БДМ№1","БДМ№2","ВЫБРАТЬ ДАТУ","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":60,"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":10,"n_cols":45,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,44,4,44],[2,36,4,36],[2,37,4,37],[2,38,4,38],[2,39,4,39],[2,40,4,40],[2,41,4,41],[0,0,1,2],[0,27,0,32],[2,42,4,42],[2,43,4,43],[1,4,1,8],[1,10,1,17],[0,4,0,6],[0,7,0,9],[0,10,0,12],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,2,34],[2,35,4,35]]}
[{"$f":"'ВЫБРАТЬ ДАТУ'!C7","v":"2015-02-01"}]
[null,null,null,null,"Дней в месяце",null,null,null,null,{"$f":"DAY(DATE(YEAR(A1),MONTH(A1)+1,))","v":28},"Смещение столбца",null,null,null,null,null,null,null,4]
["№","Таб.№","Ф.  И.  O.","Должность","числа    месяца",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":"IF(COLUMN()-Toffset<=Tdays,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,{"$f":"IF(COLUMN()-Toffset<=Tdays,1,0)","v":0}]
[null,null,null,null,{"$f":"DATE(YEAR('ВЫБРАТЬ ДАТУ'!C7),MONTH('ВЫБРАТЬ ДАТУ'!C7),1)","v":"2015-02-01"},{"$f":"IF(F4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(E$5)+1),\"\")","v":"2015-02-02"},{"$f":"IF(G4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(F$5)+1),\"\")","v":"2015-02-03"},{"$f":"IF(H4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(G$5)+1),\"\")","v":"2015-02-04"},{"$f":"IF(I4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(H$5)+1),\"\")","v":"2015-02-05"},{"$f":"IF(J4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(I$5)+1),\"\")","v":"2015-02-06"},{"$f":"IF(K4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(J$5)+1),\"\")","v":"2015-02-07"},{"$f":"IF(L4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(K$5)+1),\"\")","v":"2015-02-08"},{"$f":"IF(M4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(L$5)+1),\"\")","v":"2015-02-09"},{"$f":"IF(N4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(M$5)+1),\"\")","v":"2015-02-10"},{"$f":"IF(O4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(N$5)+1),\"\")","v":"2015-02-11"},{"$f":"IF(P4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(O$5)+1),\"\")","v":"2015-02-12"},{"$f":"IF(Q4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(P$5)+1),\"\")","v":"2015-02-13"},{"$f":"IF(R4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(Q$5)+1),\"\")","v":"2015-02-14"},{"$f":"IF(S4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(R$5)+1),\"\")","v":"2015-02-15"},{"$f":"IF(T4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(S$5)+1),\"\")","v":"2015-02-16"},{"$f":"IF(U4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(T$5)+1),\"\")","v":"2015-02-17"},{"$f":"IF(V4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(U$5)+1),\"\")","v":"2015-02-18"},{"$f":"IF(W4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(V$5)+1),\"\")","v":"2015-02-19"},{"$f":"IF(X4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(W$5)+1),\"\")","v":"2015-02-20"},{"$f":"IF(Y4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(X$5)+1),\"\")","v":"2015-02-21"},{"$f":"IF(Z4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(Y$5)+1),\"\")","v":"2015-02-22"},{"$f":"IF(AA4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(Z$5)+1),\"\")","v":"2015-02-23"},{"$f":"IF(AB4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(AA$5)+1),\"\")","v":"2015-02-24"},{"$f":"IF(AC4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(AB$5)+1),\"\")","v":"2015-02-25"},{"$f":"IF(AD4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(AC$5)+1),\"\")","v":"2015-02-26"},{"$f":"IF(AE4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(AD$5)+1),\"\")","v":"2015-02-27"},{"$f":"IF(AF4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(AE$5)+1),\"\")","v":"2015-02-28"},{"$f":"IF(AG4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(AF$5)+1),\"\")","v":""},{"$f":"IF(AH4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(AG$5)+1),\"\")","v":""},{"$f":"IF(AI4,DATE(YEAR('ВЫБРАТЬ ДАТУ'!$C$7),MONTH('ВЫБРАТЬ ДАТУ'!$C$7),DAY(AH$5)+1),\"\")","v":""}]
[null,null,null,null,0,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(E6:AI6,\">0\")+COUNTIF(E6:AI6,\"1'\")+COUNTIF(E6:AI6,\"2'\")+COUNTIF(E6:AI6,\"3'\")+COUNTIF(E6:AI6,\"4'\")+COUNTIF(E6:AI6,\"5'\")+COUNTIF(E6:AI6,\"6'\")+COUNTIF(E6:AI6,\"7'\")+COUNTIF(E6:AI6,\"8'\")+COUNTIF(E6:AI6,\"9'\")+COUNTIF(E6:AI6,\"10'\")+COUNTIF(E6:AI6,\"11'\")+COUNTIF(E6:AI6,\"12'\")","v":0},{"$f":"SUM(E6:AI6)+COUNTIF(E6:AI6,\"12'\")*12+COUNTIF(E6:AI6,\"11'\")*11+COUNTIF(E6:AI6,\"10'\")*10+COUNTIF(E6:AI6,\"9'\")*9+COUNTIF(E6:AI6,\"8'\")*8+COUNTIF(E6:AI6,\"7'\")*7+COUNTIF(E6:AI6,\"6'\")*6+COUNTIF(E6:AI6,\"5'\")*5+COUNTIF(E6:AI6,\"4'\")*4+COUNTIF(E6:AI6,\"3'\")*3+COUNTIF(E6:AI6,\"2'\")*2+COUNTIF(E6:AI6,\"1'\")*1","v":0},{"$f":"(COUNTIF(E6:AI6,\"12'\"))*8+(COUNTIF(E6:AI6,\"11'\"))*8+(COUNTIF(E6:AI6,\"10'\"))*8+(COUNTIF(E6:AI6,\"9'\"))*8+(COUNTIF(E6:AI6,\"8'\"))*8+(COUNTIF(E6:AI6,\"7'\"))*7+(COUNTIF(E6:AI6,\"6'\"))*6+(COUNTIF(E6:AI6,\"5'\"))*5+(COUNTIF(E6:AI6,\"4'\"))*4+(COUNTIF(E6:AI6,\"3'\"))*3+(COUNTIF(E6:AI6,\"2'\"))*2+(COUNTIF(E6:AI6,\"1'\"))*1","v":0},null,{"$f":"COUNTIF(E6:AI6,\"б\")","v":0},{"$f":"COUNTIF(B6:AI6,\"г\")+COUNTIF(B6:AI6,\"к\")+COUNTIF(B6:AI6,\"оу\")+COUNTIF(B6:AI6,\"ос\")","v":0},{"$f":"COUNTIF(E6:AI6,\"а\")","v":0},{"$f":"COUNTIF(B6:AI6,\"о\")","v":0},{"$f":"COUNTIF(E6:AI6,\"Пр\")","v":0},{"$f":"COUNTIF(E6:AI6,\"в\")","v":0}]
[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":"COUNTIF(E7:AI7,\">0\")+COUNTIF(E7:AI7,\"1'\")+COUNTIF(E7:AI7,\"2'\")+COUNTIF(E7:AI7,\"3'\")+COUNTIF(E7:AI7,\"4'\")+COUNTIF(E7:AI7,\"5'\")+COUNTIF(E7:AI7,\"6'\")+COUNTIF(E7:AI7,\"7'\")+COUNTIF(E7:AI7,\"8'\")+COUNTIF(E7:AI7,\"9'\")+COUNTIF(E7:AI7,\"10'\")+COUNTIF(E7:AI7,\"11'\")+COUNTIF(E7:AI7,\"12'\")","v":0},{"$f":"SUM(E7:AI7)+COUNTIF(E7:AI7,\"12'\")*12+COUNTIF(E7:AI7,\"11'\")*11+COUNTIF(E7:AI7,\"10'\")*10+COUNTIF(E7:AI7,\"9'\")*9+COUNTIF(E7:AI7,\"8'\")*8+COUNTIF(E7:AI7,\"7'\")*7+COUNTIF(E7:AI7,\"6'\")*6+COUNTIF(E7:AI7,\"5'\")*5+COUNTIF(E7:AI7,\"4'\")*4+COUNTIF(E7:AI7,\"3'\")*3+COUNTIF(E7:AI7,\"2'\")*2+COUNTIF(E7:AI7,\"1'\")*1","v":0},{"$f":"(COUNTIF(E7:AI7,\"12'\"))*8+(COUNTIF(E7:AI7,\"11'\"))*8+(COUNTIF(E7:AI7,\"10'\"))*8+(COUNTIF(E7:AI7,\"9'\"))*8+(COUNTIF(E7:AI7,\"8'\"))*8+(COUNTIF(E7:AI7,\"7'\"))*7+(COUNTIF(E7:AI7,\"6'\"))*6+(COUNTIF(E7:AI7,\"5'\"))*5+(COUNTIF(E7:AI7,\"4'\"))*4+(COUNTIF(E7:AI7,\"3'\"))*3+(COUNTIF(E7:AI7,\"2'\"))*2+(COUNTIF(E7:AI7,\"1'\"))*1","v":0},null,{"$f":"COUNTIF(E7:AI7,\"б\")","v":0},{"$f":"COUNTIF(B7:AI7,\"г\")+COUNTIF(B7:AI7,\"к\")+COUNTIF(B7:AI7,\"оу\")+COUNTIF(B7:AI7,\"ос\")","v":0},{"$f":"COUNTIF(E7:AI7,\"а\")","v":0},{"$f":"COUNTIF(B7:AI7,\"о\")","v":0},{"$f":"COUNTIF(E7:AI7,\"Пр\")","v":0},{"$f":"COUNTIF(E7:AI7,\"в\")","v":0}]
[]
[]
[null,null,"2015-01-01"]

{"sheet":"БДМ№1","index":1,"n_rows":10,"n_cols":36,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,35,3,35],[0,1,0,2],[0,8,0,13],[0,14,0,30],[2,1,3,1],[2,2,3,3],[2,4,2,34]]}
[null,{"$f":"'Общий табель'!A1","v":"2015-02-01"},null,null,null,null,null,null,"БДМ № 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,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":"'Общий табель'!E5","v":"2015-02-01"},{"$f":"'Общий табель'!F5","v":"2015-02-02"},{"$f":"'Общий табель'!G5","v":"2015-02-03"},{"$f":"'Общий табель'!H5","v":"2015-02-04"},{"$f":"'Общий табель'!I5","v":"2015-02-05"},{"$f":"'Общий табель'!J5","v":"2015-02-06"},{"$f":"'Общий табель'!K5","v":"2015-02-07"},{"$f":"'Общий табель'!L5","v":"2015-02-08"},{"$f":"'Общий табель'!M5","v":"2015-02-09"},{"$f":"'Общий табель'!N5","v":"2015-02-10"},{"$f":"'Общий табель'!O5","v":"2015-02-11"},{"$f":"'Общий табель'!P5","v":"2015-02-12"},{"$f":"'Общий табель'!Q5","v":"2015-02-13"},{"$f":"'Общий табель'!R5","v":"2015-02-14"},{"$f":"'Общий табель'!S5","v":"2015-02-15"},{"$f":"'Общий табель'!T5","v":"2015-02-16"},{"$f":"'Общий табель'!U5","v":"2015-02-17"},{"$f":"'Общий табель'!V5","v":"2015-02-18"},{"$f":"'Общий табель'!W5","v":"2015-02-19"},{"$f":"'Общий табель'!X5","v":"2015-02-20"},{"$f":"'Общий табель'!Y5","v":"2015-02-21"},{"$f":"'Общий табель'!Z5","v":"2015-02-22"},{"$f":"'Общий табель'!AA5","v":"2015-02-23"},{"$f":"'Общий табель'!AB5","v":"2015-02-24"},{"$f":"'Общий табель'!AC5","v":"2015-02-25"},{"$f":"'Общий табель'!AD5","v":"2015-02-26"},{"$f":"'Общий табель'!AE5","v":"2015-02-27"},{"$f":"'Общий табель'!AF5","v":"2015-02-28"},{"$f":"'Общий табель'!AG5","v":""},{"$f":"'Общий табель'!AH5","v":""},{"$f":"'Общий табель'!AI5","v":""}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D5)=\"%\",TEXT(INDEX(E$5:AI5,MATCH(LEFTB(C5,SEARCH(\"%\",D5)),(C$5:C5),),),\"0;0;12\")*E5:AI5%,E5:AI5))),\"\",SUM(IF(RIGHTB(D5)=\"%\",TEXT(INDEX(E$5:AI5,MATCH(LEFTB(C5,SEARCH(\"%\",D5)),(C$5:C5),),),\"0,0;0;12\")*E5:AI5%,E5:AI5)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D6)=\"%\",TEXT(INDEX(E$5:AI6,MATCH(LEFTB(C6,SEARCH(\"%\",D6)),(C$5:C6),),),\"0;0;12\")*E6:AI6%,E6:AI6))),\"\",SUM(IF(RIGHTB(D6)=\"%\",TEXT(INDEX(E$5:AI6,MATCH(LEFTB(C6,SEARCH(\"%\",D6)),(C$5:C6),),),\"0,0;0;12\")*E6:AI6%,E6:AI6)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D7)=\"%\",TEXT(INDEX(E$5:AI7,MATCH(LEFTB(C7,SEARCH(\"%\",D7)),(C$5:C7),),),\"0;0;12\")*E7:AI7%,E7:AI7))),\"\",SUM(IF(RIGHTB(D7)=\"%\",TEXT(INDEX(E$5:AI7,MATCH(LEFTB(C7,SEARCH(\"%\",D7)),(C$5:C7),),),\"0,0;0;12\")*E7:AI7%,E7:AI7)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D8)=\"%\",TEXT(INDEX(E$5:AI8,MATCH(LEFTB(C8,SEARCH(\"%\",D8)),(C$5:C8),),),\"0;0;12\")*E8:AI8%,E8:AI8))),\"\",SUM(IF(RIGHTB(D8)=\"%\",TEXT(INDEX(E$5:AI8,MATCH(LEFTB(C8,SEARCH(\"%\",D8)),(C$5:C8),),),\"0,0;0;12\")*E8:AI8%,E8:AI8)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D9)=\"%\",TEXT(INDEX(E$5:AI9,MATCH(LEFTB(C9,SEARCH(\"%\",D9)),(C$5:C9),),),\"0;0;12\")*E9:AI9%,E9:AI9))),\"\",SUM(IF(RIGHTB(D9)=\"%\",TEXT(INDEX(E$5:AI9,MATCH(LEFTB(C9,SEARCH(\"%\",D9)),(C$5:C9),),),\"0,0;0;12\")*E9:AI9%,E9:AI9)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D10)=\"%\",TEXT(INDEX(E$5:AI10,MATCH(LEFTB(C10,SEARCH(\"%\",D10)),(C$5:C10),),),\"0;0;12\")*E10:AI10%,E10:AI10))),\"\",SUM(IF(RIGHTB(D10)=\"%\",TEXT(INDEX(E$5:AI10,MATCH(LEFTB(C10,SEARCH(\"%\",D10)),(C$5:C10),),),\"0,0;0;12\")*E10:AI10%,E10:AI10)))","v":0}]

{"sheet":"БДМ№2","index":2,"n_rows":10,"n_cols":36,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,35,3,35],[0,1,0,2],[0,8,0,13],[0,14,0,30],[2,1,3,1],[2,2,3,3],[2,4,2,34]]}
[null,{"$f":"'Общий табель'!A1","v":"2015-02-01"},null,null,null,null,null,null,"БДМ № 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,{"$f":"'Общий табель'!E5","v":"2015-02-01"},{"$f":"'Общий табель'!F5","v":"2015-02-02"},{"$f":"'Общий табель'!G5","v":"2015-02-03"},{"$f":"'Общий табель'!H5","v":"2015-02-04"},{"$f":"'Общий табель'!I5","v":"2015-02-05"},{"$f":"'Общий табель'!J5","v":"2015-02-06"},{"$f":"'Общий табель'!K5","v":"2015-02-07"},{"$f":"'Общий табель'!L5","v":"2015-02-08"},{"$f":"'Общий табель'!M5","v":"2015-02-09"},{"$f":"'Общий табель'!N5","v":"2015-02-10"},{"$f":"'Общий табель'!O5","v":"2015-02-11"},{"$f":"'Общий табель'!P5","v":"2015-02-12"},{"$f":"'Общий табель'!Q5","v":"2015-02-13"},{"$f":"'Общий табель'!R5","v":"2015-02-14"},{"$f":"'Общий табель'!S5","v":"2015-02-15"},{"$f":"'Общий табель'!T5","v":"2015-02-16"},{"$f":"'Общий табель'!U5","v":"2015-02-17"},{"$f":"'Общий табель'!V5","v":"2015-02-18"},{"$f":"'Общий табель'!W5","v":"2015-02-19"},{"$f":"'Общий табель'!X5","v":"2015-02-20"},{"$f":"'Общий табель'!Y5","v":"2015-02-21"},{"$f":"'Общий табель'!Z5","v":"2015-02-22"},{"$f":"'Общий табель'!AA5","v":"2015-02-23"},{"$f":"'Общий табель'!AB5","v":"2015-02-24"},{"$f":"'Общий табель'!AC5","v":"2015-02-25"},{"$f":"'Общий табель'!AD5","v":"2015-02-26"},{"$f":"'Общий табель'!AE5","v":"2015-02-27"},{"$f":"'Общий табель'!AF5","v":"2015-02-28"},{"$f":"'Общий табель'!AG5","v":""},{"$f":"'Общий табель'!AH5","v":""}]
[]
[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":"IF(ISNA(SUM(IF(RIGHTB(D6)=\"%\",TEXT(INDEX(E$5:AI6,MATCH(LEFTB(C6,SEARCH(\"%\",D6)),(C$5:C6),),),\"0;0;12\")*E6:AI6%,E6:AI6))),\"\",SUM(IF(RIGHTB(D6)=\"%\",TEXT(INDEX(E$5:AI6,MATCH(LEFTB(C6,SEARCH(\"%\",D6)),(C$5:C6),),),\"0,0;0;12\")*E6:AI6%,E6:AI6)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D7)=\"%\",TEXT(INDEX(E$5:AI7,MATCH(LEFTB(C7,SEARCH(\"%\",D7)),(C$5:C7),),),\"0;0;12\")*E7:AI7%,E7:AI7))),\"\",SUM(IF(RIGHTB(D7)=\"%\",TEXT(INDEX(E$5:AI7,MATCH(LEFTB(C7,SEARCH(\"%\",D7)),(C$5:C7),),),\"0,0;0;12\")*E7:AI7%,E7:AI7)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D8)=\"%\",TEXT(INDEX(E$5:AI8,MATCH(LEFTB(C8,SEARCH(\"%\",D8)),(C$5:C8),),),\"0;0;12\")*E8:AI8%,E8:AI8))),\"\",SUM(IF(RIGHTB(D8)=\"%\",TEXT(INDEX(E$5:AI8,MATCH(LEFTB(C8,SEARCH(\"%\",D8)),(C$5:C8),),),\"0,0;0;12\")*E8:AI8%,E8:AI8)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D9)=\"%\",TEXT(INDEX(E$5:AI9,MATCH(LEFTB(C9,SEARCH(\"%\",D9)),(C$5:C9),),),\"0;0;12\")*E9:AI9%,E9:AI9))),\"\",SUM(IF(RIGHTB(D9)=\"%\",TEXT(INDEX(E$5:AI9,MATCH(LEFTB(C9,SEARCH(\"%\",D9)),(C$5:C9),),),\"0,0;0;12\")*E9:AI9%,E9:AI9)))","v":0}]
[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":"IF(ISNA(SUM(IF(RIGHTB(D10)=\"%\",TEXT(INDEX(E$5:AI10,MATCH(LEFTB(C10,SEARCH(\"%\",D10)),(C$5:C10),),),\"0;0;12\")*E10:AI10%,E10:AI10))),\"\",SUM(IF(RIGHTB(D10)=\"%\",TEXT(INDEX(E$5:AI10,MATCH(LEFTB(C10,SEARCH(\"%\",D10)),(C$5:C10),),),\"0,0;0;12\")*E10:AI10%,E10:AI10)))","v":0}]

{"sheet":"ВЫБРАТЬ ДАТУ","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,2,6,4]]}
[]
[]
[]
[]
[]
[]
[null,null,"2015-02-01"]

{"sheet":"Лист2","index":4,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["2015-02-01"]
["2015-03-01"]
["2015-04-01"]
["2015-05-01"]
["2015-06-01"]
["2015-07-01"]
["2015-08-01"]
["2015-09-01"]
["2015-10-01"]
["2015-11-01"]
["2015-12-01"]