{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["янв.14","фев.14"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"янв.14","index":0,"n_rows":8,"n_cols":71,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,9,5,10],[4,0,6,0],[4,1,6,1],[5,2,6,2],[5,3,6,3],[3,15,3,16],[3,17,3,18],[3,19,3,20],[3,21,3,22],[4,2,4,3],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,4,6,4],[3,67,3,68],[3,69,3,70],[4,11,4,12],[4,13,4,14],[4,15,4,16],[4,17,4,18],[4,19,4,20],[1,0,1,2],[4,9,4,10],[3,9,3,10],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[3,31,3,32],[3,33,3,34],[3,35,3,36],[3,37,3,38],[3,39,3,40],[3,41,3,42],[3,43,3,44],[3,45,3,46],[3,47,3,48],[3,49,3,50],[4,67,4,68],[4,69,4,70],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[4,53,4,54],[4,55,4,56],[4,57,4,58],[4,59,4,60],[4,61,4,62],[4,63,4,64],[4,41,4,42],[4,43,4,44],[4,45,4,46],[4,47,4,48],[4,49,4,50],[4,51,4,52],[4,29,4,30],[4,31,4,32],[4,33,4,34],[5,67,5,68],[5,69,5,70],[3,11,3,12],[3,13,3,14],[3,51,3,52],[3,53,3,54],[3,55,3,56],[5,49,5,50],[5,51,5,52],[5,53,5,54],[5,55,5,56],[5,57,5,58],[5,59,5,60],[5,37,5,38],[5,39,5,40],[5,41,5,42],[5,43,5,44],[5,45,5,46],[5,47,5,48],[5,25,5,26],[5,27,5,28],[5,29,5,30],[5,31,5,32],[5,33,5,34],[3,57,3,58],[3,59,3,60],[4,21,4,22],[4,23,4,24],[4,25,4,26],[4,27,4,28],[5,61,5,62],[5,63,5,64],[5,65,5,66],[5,35,5,36],[4,65,4,66],[4,35,4,36],[4,37,4,38],[4,39,4,40],[3,61,3,62],[3,63,3,64],[3,65,3,66]]}
[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,null,null,null,null,null,"ТО-1/1","ТО-1/2","ТО-2"]
["период планирования ТО",null,null,{"$f":"RIGHT(CELL(\"имяфайла\",A1),LEN(CELL(\"имяфайла\",A1))-FIND(\"]\",CELL(\"имяфайла\",A1),1))","v":"янв.14"},null,{"$f":"MONTH(D2)","v":1}]
[]
[null,null,null,null,null,null,null,null,"номер месяца",{"$f":"IFERROR(MONTH(J6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(L6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(N6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(P6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(R6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(T6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(V6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(X6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(Z6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AB6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AD6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AF6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AH6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AJ6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AL6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AN6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AP6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AR6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AT6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AV6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AX6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(AZ6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BB6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BD6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BF6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BH6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BJ6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BL6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BN6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BP6),\"\")","v":1},null,{"$f":"IFERROR(MONTH(BR6),\"\")","v":1}]
["№  п.п.","Гар.№ авто","Последнее ТО",null,"Кратность пробега между ТО, км","Наработка на начало периода, км","Наработка на начало периода после последнего ТО, км","Плановая наработка за планируемый период, км","день месяца",{"$f":"IFERROR(DAY(J6),\"\")","v":1},null,{"$f":"IFERROR(DAY(L6),\"\")","v":2},null,{"$f":"IFERROR(DAY(N6),\"\")","v":3},null,{"$f":"IFERROR(DAY(P6),\"\")","v":4},null,{"$f":"IFERROR(DAY(R6),\"\")","v":5},null,{"$f":"IFERROR(DAY(T6),\"\")","v":6},null,{"$f":"IFERROR(DAY(V6),\"\")","v":7},null,{"$f":"IFERROR(DAY(X6),\"\")","v":8},null,{"$f":"IFERROR(DAY(Z6),\"\")","v":9},null,{"$f":"IFERROR(DAY(AB6),\"\")","v":10},null,{"$f":"IFERROR(DAY(AD6),\"\")","v":11},null,{"$f":"IFERROR(DAY(AF6),\"\")","v":12},null,{"$f":"IFERROR(DAY(AH6),\"\")","v":13},null,{"$f":"IFERROR(DAY(AJ6),\"\")","v":14},null,{"$f":"IFERROR(DAY(AL6),\"\")","v":15},null,{"$f":"IFERROR(DAY(AN6),\"\")","v":16},null,{"$f":"IFERROR(DAY(AP6),\"\")","v":17},null,{"$f":"IFERROR(DAY(AR6),\"\")","v":18},null,{"$f":"IFERROR(DAY(AT6),\"\")","v":19},null,{"$f":"IFERROR(DAY(AV6),\"\")","v":20},null,{"$f":"IFERROR(DAY(AX6),\"\")","v":21},null,{"$f":"IFERROR(DAY(AZ6),\"\")","v":22},null,{"$f":"IFERROR(DAY(BB6),\"\")","v":23},null,{"$f":"IFERROR(DAY(BD6),\"\")","v":24},null,{"$f":"IFERROR(DAY(BF6),\"\")","v":25},null,{"$f":"IFERROR(DAY(BH6),\"\")","v":26},null,{"$f":"IFERROR(DAY(BJ6),\"\")","v":27},null,{"$f":"IFERROR(DAY(BL6),\"\")","v":28},null,{"$f":"IFERROR(DAY(BN6),\"\")","v":29},null,{"$f":"IFERROR(DAY(BP6),\"\")","v":30},null,{"$f":"IFERROR(DAY(BR6),\"\")","v":31}]
[null,null,"Вид","Наработка на момент проведения последнего ТО, км",null,null,null,null,"дата",{"$f":"DATEVALUE(D2)","v":"2014-01-01"},{"$f":"DATEVALUE(K5)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(MONTH(J6+1)=$F$2,J6+1,\"\"),\"\")","v":"2014-01-02"},null,{"$f":"IFERROR(IF(MONTH(L6+1)=$F$2,L6+1,\"\"),\"\")","v":"2014-01-03"},null,{"$f":"IFERROR(IF(MONTH(N6+1)=$F$2,N6+1,\"\"),\"\")","v":"2014-01-04"},null,{"$f":"IFERROR(IF(MONTH(P6+1)=$F$2,P6+1,\"\"),\"\")","v":"2014-01-05"},null,{"$f":"IFERROR(IF(MONTH(R6+1)=$F$2,R6+1,\"\"),\"\")","v":"2014-01-06"},null,{"$f":"IFERROR(IF(MONTH(T6+1)=$F$2,T6+1,\"\"),\"\")","v":"2014-01-07"},null,{"$f":"IFERROR(IF(MONTH(V6+1)=$F$2,V6+1,\"\"),\"\")","v":"2014-01-08"},null,{"$f":"IFERROR(IF(MONTH(X6+1)=$F$2,X6+1,\"\"),\"\")","v":"2014-01-09"},null,{"$f":"IFERROR(IF(MONTH(Z6+1)=$F$2,Z6+1,\"\"),\"\")","v":"2014-01-10"},null,{"$f":"IFERROR(IF(MONTH(AB6+1)=$F$2,AB6+1,\"\"),\"\")","v":"2014-01-11"},null,{"$f":"IFERROR(IF(MONTH(AD6+1)=$F$2,AD6+1,\"\"),\"\")","v":"2014-01-12"},null,{"$f":"IFERROR(IF(MONTH(AF6+1)=$F$2,AF6+1,\"\"),\"\")","v":"2014-01-13"},null,{"$f":"IFERROR(IF(MONTH(AH6+1)=$F$2,AH6+1,\"\"),\"\")","v":"2014-01-14"},null,{"$f":"IFERROR(IF(MONTH(AJ6+1)=$F$2,AJ6+1,\"\"),\"\")","v":"2014-01-15"},null,{"$f":"IFERROR(IF(MONTH(AL6+1)=$F$2,AL6+1,\"\"),\"\")","v":"2014-01-16"},null,{"$f":"IFERROR(IF(MONTH(AN6+1)=$F$2,AN6+1,\"\"),\"\")","v":"2014-01-17"},null,{"$f":"IFERROR(IF(MONTH(AP6+1)=$F$2,AP6+1,\"\"),\"\")","v":"2014-01-18"},null,{"$f":"IFERROR(IF(MONTH(AR6+1)=$F$2,AR6+1,\"\"),\"\")","v":"2014-01-19"},null,{"$f":"IFERROR(IF(MONTH(AT6+1)=$F$2,AT6+1,\"\"),\"\")","v":"2014-01-20"},null,{"$f":"IFERROR(IF(MONTH(AV6+1)=$F$2,AV6+1,\"\"),\"\")","v":"2014-01-21"},null,{"$f":"IFERROR(IF(MONTH(AX6+1)=$F$2,AX6+1,\"\"),\"\")","v":"2014-01-22"},null,{"$f":"IFERROR(IF(MONTH(AZ6+1)=$F$2,AZ6+1,\"\"),\"\")","v":"2014-01-23"},null,{"$f":"IFERROR(IF(MONTH(BB6+1)=$F$2,BB6+1,\"\"),\"\")","v":"2014-01-24"},null,{"$f":"IFERROR(IF(MONTH(BD6+1)=$F$2,BD6+1,\"\"),\"\")","v":"2014-01-25"},null,{"$f":"IFERROR(IF(MONTH(BF6+1)=$F$2,BF6+1,\"\"),\"\")","v":"2014-01-26"},null,{"$f":"IFERROR(IF(MONTH(BH6+1)=$F$2,BH6+1,\"\"),\"\")","v":"2014-01-27"},null,{"$f":"IFERROR(IF(MONTH(BJ6+1)=$F$2,BJ6+1,\"\"),\"\")","v":"2014-01-28"},null,{"$f":"IFERROR(IF(MONTH(BL6+1)=$F$2,BL6+1,\"\"),\"\")","v":"2014-01-29"},null,{"$f":"IFERROR(IF(MONTH(BN6+1)=$F$2,BN6+1,\"\"),\"\")","v":"2014-01-30"},null,{"$f":"IFERROR(IF(MONTH(BP6+1)=$F$2,BP6+1,\"\"),\"\")","v":"2014-01-31"}]
[null,null,null,null,null,null,null,null,"Ср.суточный пробег за период, км","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО"]
[{"$f":"IF(B8=\"\",\"\",COUNTA($B$8:B8))","v":1},"А1 ","ТО-1/2",76534,6000,76800,{"$f":"F8-D8","v":266},10000,{"$f":"IFERROR(H8/COUNTIFS($J$5:$BR$5,\">0\"),)","v":322.58064516129031},{"$f":"IF(K8<>\"\",$F8+$I8*J$5,\"\")","v":""},{"$f":"IF(I8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*J$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(M8<>\"\",$F8+$I8*L$5,\"\")","v":""},{"$f":"IF(K8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*L$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(O8<>\"\",$F8+$I8*N$5,\"\")","v":""},{"$f":"IF(M8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*N$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(Q8<>\"\",$F8+$I8*P$5,\"\")","v":""},{"$f":"IF(O8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*P$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(S8<>\"\",$F8+$I8*R$5,\"\")","v":""},{"$f":"IF(Q8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*R$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(U8<>\"\",$F8+$I8*T$5,\"\")","v":""},{"$f":"IF(S8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*T$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(W8<>\"\",$F8+$I8*V$5,\"\")","v":""},{"$f":"IF(U8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*V$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(Y8<>\"\",$F8+$I8*X$5,\"\")","v":""},{"$f":"IF(W8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*X$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AA8<>\"\",$F8+$I8*Z$5,\"\")","v":""},{"$f":"IF(Y8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*Z$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AC8<>\"\",$F8+$I8*AB$5,\"\")","v":""},{"$f":"IF(AA8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AB$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AE8<>\"\",$F8+$I8*AD$5,\"\")","v":""},{"$f":"IF(AC8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AD$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AG8<>\"\",$F8+$I8*AF$5,\"\")","v":""},{"$f":"IF(AE8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AF$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AI8<>\"\",$F8+$I8*AH$5,\"\")","v":""},{"$f":"IF(AG8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AH$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AK8<>\"\",$F8+$I8*AJ$5,\"\")","v":""},{"$f":"IF(AI8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AJ$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AM8<>\"\",$F8+$I8*AL$5,\"\")","v":""},{"$f":"IF(AK8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AL$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AO8<>\"\",$F8+$I8*AN$5,\"\")","v":""},{"$f":"IF(AM8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AN$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AQ8<>\"\",$F8+$I8*AP$5,\"\")","v":""},{"$f":"IF(AO8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AP$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AS8<>\"\",$F8+$I8*AR$5,\"\")","v":82606.451612903227},{"$f":"IF(AQ8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AR$5+$F8,$I8,$E8),\"\"))","v":"ТО-2"},{"$f":"IF(AU8<>\"\",$F8+$I8*AT$5,\"\")","v":""},{"$f":"IF(AS8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AT$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AW8<>\"\",$F8+$I8*AV$5,\"\")","v":""},{"$f":"IF(AU8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AV$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AY8<>\"\",$F8+$I8*AX$5,\"\")","v":""},{"$f":"IF(AW8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AX$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BA8<>\"\",$F8+$I8*AZ$5,\"\")","v":""},{"$f":"IF(AY8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AZ$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BC8<>\"\",$F8+$I8*BB$5,\"\")","v":""},{"$f":"IF(BA8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BB$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BE8<>\"\",$F8+$I8*BD$5,\"\")","v":""},{"$f":"IF(BC8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BD$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BG8<>\"\",$F8+$I8*BF$5,\"\")","v":""},{"$f":"IF(BE8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BF$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BI8<>\"\",$F8+$I8*BH$5,\"\")","v":""},{"$f":"IF(BG8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BH$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BK8<>\"\",$F8+$I8*BJ$5,\"\")","v":""},{"$f":"IF(BI8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BJ$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BM8<>\"\",$F8+$I8*BL$5,\"\")","v":""},{"$f":"IF(BK8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BL$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BO8<>\"\",$F8+$I8*BN$5,\"\")","v":""},{"$f":"IF(BM8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BN$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BQ8<>\"\",$F8+$I8*BP$5,\"\")","v":""},{"$f":"IF(BO8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BP$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BS8<>\"\",$F8+$I8*BR$5,\"\")","v":""},{"$f":"IF(BQ8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BR$5+$F8,$I8,$E8),\"\"))","v":""}]

{"sheet":"фев.14","index":1,"n_rows":8,"n_cols":71,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,63,5,64],[5,65,5,66],[5,67,5,68],[5,69,5,70],[4,4,6,4],[5,51,5,52],[5,53,5,54],[5,55,5,56],[5,57,5,58],[5,59,5,60],[5,61,5,62],[5,39,5,40],[5,41,5,42],[5,43,5,44],[5,45,5,46],[5,47,5,48],[5,49,5,50],[5,27,5,28],[5,29,5,30],[5,31,5,32],[5,33,5,34],[5,35,5,36],[5,37,5,38],[5,15,5,16],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,25,5,26],[4,61,4,62],[4,63,4,64],[4,65,4,66],[4,67,4,68],[4,69,4,70],[5,2,6,2],[5,3,6,3],[5,9,5,10],[5,11,5,12],[5,13,5,14],[4,49,4,50],[4,51,4,52],[4,53,4,54],[4,55,4,56],[4,57,4,58],[4,59,4,60],[4,37,4,38],[4,39,4,40],[4,41,4,42],[4,43,4,44],[4,45,4,46],[4,47,4,48],[4,25,4,26],[4,27,4,28],[4,29,4,30],[4,31,4,32],[4,33,4,34],[4,35,4,36],[4,13,4,14],[4,15,4,16],[4,17,4,18],[4,19,4,20],[4,21,4,22],[4,23,4,24],[3,67,3,68],[3,69,3,70],[4,0,6,0],[4,1,6,1],[4,2,4,3],[4,5,6,5],[4,6,6,6],[4,7,6,7],[4,9,4,10],[4,11,4,12],[3,55,3,56],[3,57,3,58],[3,59,3,60],[3,61,3,62],[3,63,3,64],[3,65,3,66],[3,43,3,44],[3,45,3,46],[3,47,3,48],[3,49,3,50],[3,51,3,52],[3,53,3,54],[3,31,3,32],[3,33,3,34],[3,35,3,36],[3,37,3,38],[3,39,3,40],[3,41,3,42],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[1,0,1,2],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18]]}
[]
["период планирования ТО",null,null,{"$f":"RIGHT(CELL(\"имяфайла\",A1),LEN(CELL(\"имяфайла\",A1))-FIND(\"]\",CELL(\"имяфайла\",A1),1))","v":"фев.14"},null,{"$f":"MONTH(D2)","v":2}]
[]
[null,null,null,null,null,null,null,null,"номер месяца",{"$f":"IFERROR(MONTH(J6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(L6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(N6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(P6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(R6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(T6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(V6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(X6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(Z6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AB6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AD6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AF6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AH6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AJ6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AL6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AN6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AP6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AR6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AT6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AV6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AX6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(AZ6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(BB6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(BD6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(BF6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(BH6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(BJ6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(BL6),\"\")","v":2},null,{"$f":"IFERROR(MONTH(BN6),\"\")","v":""},null,{"$f":"IFERROR(MONTH(BP6),\"\")","v":""},null,{"$f":"IFERROR(MONTH(BR6),\"\")","v":""}]
["№  п.п.","Гар.№ авто","Последнее ТО",null,"Кратность пробега между ТО, км","Наработка на начало периода, км","Наработка на начало периода после последнего ТО, км","Плановая наработка за планируемый период, км","день месяца",{"$f":"IFERROR(DAY(J6),\"\")","v":1},null,{"$f":"IFERROR(DAY(L6),\"\")","v":2},null,{"$f":"IFERROR(DAY(N6),\"\")","v":3},null,{"$f":"IFERROR(DAY(P6),\"\")","v":4},null,{"$f":"IFERROR(DAY(R6),\"\")","v":5},null,{"$f":"IFERROR(DAY(T6),\"\")","v":6},null,{"$f":"IFERROR(DAY(V6),\"\")","v":7},null,{"$f":"IFERROR(DAY(X6),\"\")","v":8},null,{"$f":"IFERROR(DAY(Z6),\"\")","v":9},null,{"$f":"IFERROR(DAY(AB6),\"\")","v":10},null,{"$f":"IFERROR(DAY(AD6),\"\")","v":11},null,{"$f":"IFERROR(DAY(AF6),\"\")","v":12},null,{"$f":"IFERROR(DAY(AH6),\"\")","v":13},null,{"$f":"IFERROR(DAY(AJ6),\"\")","v":14},null,{"$f":"IFERROR(DAY(AL6),\"\")","v":15},null,{"$f":"IFERROR(DAY(AN6),\"\")","v":16},null,{"$f":"IFERROR(DAY(AP6),\"\")","v":17},null,{"$f":"IFERROR(DAY(AR6),\"\")","v":18},null,{"$f":"IFERROR(DAY(AT6),\"\")","v":19},null,{"$f":"IFERROR(DAY(AV6),\"\")","v":20},null,{"$f":"IFERROR(DAY(AX6),\"\")","v":21},null,{"$f":"IFERROR(DAY(AZ6),\"\")","v":22},null,{"$f":"IFERROR(DAY(BB6),\"\")","v":23},null,{"$f":"IFERROR(DAY(BD6),\"\")","v":24},null,{"$f":"IFERROR(DAY(BF6),\"\")","v":25},null,{"$f":"IFERROR(DAY(BH6),\"\")","v":26},null,{"$f":"IFERROR(DAY(BJ6),\"\")","v":27},null,{"$f":"IFERROR(DAY(BL6),\"\")","v":28},null,{"$f":"IFERROR(DAY(BN6),\"\")","v":""},null,{"$f":"IFERROR(DAY(BP6),\"\")","v":""},null,{"$f":"IFERROR(DAY(BR6),\"\")","v":""}]
[null,null,"Вид","Наработка на момент проведения последнего ТО, км",null,null,null,null,"дата",{"$f":"DATEVALUE(D2)","v":"2014-02-01"},{"$f":"DATEVALUE(K5)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(MONTH(J6+1)=$F$2,J6+1,\"\"),\"\")","v":"2014-02-02"},null,{"$f":"IFERROR(IF(MONTH(L6+1)=$F$2,L6+1,\"\"),\"\")","v":"2014-02-03"},null,{"$f":"IFERROR(IF(MONTH(N6+1)=$F$2,N6+1,\"\"),\"\")","v":"2014-02-04"},null,{"$f":"IFERROR(IF(MONTH(P6+1)=$F$2,P6+1,\"\"),\"\")","v":"2014-02-05"},null,{"$f":"IFERROR(IF(MONTH(R6+1)=$F$2,R6+1,\"\"),\"\")","v":"2014-02-06"},null,{"$f":"IFERROR(IF(MONTH(T6+1)=$F$2,T6+1,\"\"),\"\")","v":"2014-02-07"},null,{"$f":"IFERROR(IF(MONTH(V6+1)=$F$2,V6+1,\"\"),\"\")","v":"2014-02-08"},null,{"$f":"IFERROR(IF(MONTH(X6+1)=$F$2,X6+1,\"\"),\"\")","v":"2014-02-09"},null,{"$f":"IFERROR(IF(MONTH(Z6+1)=$F$2,Z6+1,\"\"),\"\")","v":"2014-02-10"},null,{"$f":"IFERROR(IF(MONTH(AB6+1)=$F$2,AB6+1,\"\"),\"\")","v":"2014-02-11"},null,{"$f":"IFERROR(IF(MONTH(AD6+1)=$F$2,AD6+1,\"\"),\"\")","v":"2014-02-12"},null,{"$f":"IFERROR(IF(MONTH(AF6+1)=$F$2,AF6+1,\"\"),\"\")","v":"2014-02-13"},null,{"$f":"IFERROR(IF(MONTH(AH6+1)=$F$2,AH6+1,\"\"),\"\")","v":"2014-02-14"},null,{"$f":"IFERROR(IF(MONTH(AJ6+1)=$F$2,AJ6+1,\"\"),\"\")","v":"2014-02-15"},null,{"$f":"IFERROR(IF(MONTH(AL6+1)=$F$2,AL6+1,\"\"),\"\")","v":"2014-02-16"},null,{"$f":"IFERROR(IF(MONTH(AN6+1)=$F$2,AN6+1,\"\"),\"\")","v":"2014-02-17"},null,{"$f":"IFERROR(IF(MONTH(AP6+1)=$F$2,AP6+1,\"\"),\"\")","v":"2014-02-18"},null,{"$f":"IFERROR(IF(MONTH(AR6+1)=$F$2,AR6+1,\"\"),\"\")","v":"2014-02-19"},null,{"$f":"IFERROR(IF(MONTH(AT6+1)=$F$2,AT6+1,\"\"),\"\")","v":"2014-02-20"},null,{"$f":"IFERROR(IF(MONTH(AV6+1)=$F$2,AV6+1,\"\"),\"\")","v":"2014-02-21"},null,{"$f":"IFERROR(IF(MONTH(AX6+1)=$F$2,AX6+1,\"\"),\"\")","v":"2014-02-22"},null,{"$f":"IFERROR(IF(MONTH(AZ6+1)=$F$2,AZ6+1,\"\"),\"\")","v":"2014-02-23"},null,{"$f":"IFERROR(IF(MONTH(BB6+1)=$F$2,BB6+1,\"\"),\"\")","v":"2014-02-24"},null,{"$f":"IFERROR(IF(MONTH(BD6+1)=$F$2,BD6+1,\"\"),\"\")","v":"2014-02-25"},null,{"$f":"IFERROR(IF(MONTH(BF6+1)=$F$2,BF6+1,\"\"),\"\")","v":"2014-02-26"},null,{"$f":"IFERROR(IF(MONTH(BH6+1)=$F$2,BH6+1,\"\"),\"\")","v":"2014-02-27"},null,{"$f":"IFERROR(IF(MONTH(BJ6+1)=$F$2,BJ6+1,\"\"),\"\")","v":"2014-02-28"},null,{"$f":"IFERROR(IF(MONTH(BL6+1)=$F$2,BL6+1,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(MONTH(BN6+1)=$F$2,BN6+1,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(MONTH(BP6+1)=$F$2,BP6+1,\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Ср.суточный пробег за период, км","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО","наработка на момент ТО, км","Вид ТО"]
[{"$f":"IF(B8=\"\",\"\",COUNTA($B$8:B8))","v":1},"А1 ",{"$f":"IF(LOOKUP(\"ТО-1/1\",янв.14!8:8)=\"ТО-1/1\",IF(LOOKUP(\"ТО-1/2\",янв.14!8:8)=\"ТО-1/2\",IF(LOOKUP(\"ТО-2\",янв.14!8:8)=\"ТО-2\",\"ТО-2\"),\"ТО-1/2\"),\"ТО-1/1\")","v":"ТО-1/1"},{"$f":"LOOKUP(9E+307,янв.14!8:8)","v":82606.451612903227},6000,{"$f":"янв.14!F8+янв.14!H8","v":86800},{"$f":"F8-D8","v":4193.5483870967728},10000,{"$f":"IFERROR(H8/COUNTIFS($J$5:$BR$5,\">0\"),)","v":357.14285714285717},{"$f":"IF(K8<>\"\",$F8+$I8*J$5,\"\")","v":""},{"$f":"IF(I8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*J$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(M8<>\"\",$F8+$I8*L$5,\"\")","v":""},{"$f":"IF(K8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*L$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(O8<>\"\",$F8+$I8*N$5,\"\")","v":""},{"$f":"IF(M8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*N$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(Q8<>\"\",$F8+$I8*P$5,\"\")","v":""},{"$f":"IF(O8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*P$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(S8<>\"\",$F8+$I8*R$5,\"\")","v":""},{"$f":"IF(Q8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*R$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(U8<>\"\",$F8+$I8*T$5,\"\")","v":88942.857142857145},{"$f":"IF(S8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*T$5+$F8,$I8,$E8),\"\"))","v":"ТО-1/2"},{"$f":"IF(W8<>\"\",$F8+$I8*V$5,\"\")","v":""},{"$f":"IF(U8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*V$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(Y8<>\"\",$F8+$I8*X$5,\"\")","v":""},{"$f":"IF(W8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*X$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AA8<>\"\",$F8+$I8*Z$5,\"\")","v":""},{"$f":"IF(Y8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*Z$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AC8<>\"\",$F8+$I8*AB$5,\"\")","v":""},{"$f":"IF(AA8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AB$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AE8<>\"\",$F8+$I8*AD$5,\"\")","v":""},{"$f":"IF(AC8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AD$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AG8<>\"\",$F8+$I8*AF$5,\"\")","v":""},{"$f":"IF(AE8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AF$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AI8<>\"\",$F8+$I8*AH$5,\"\")","v":""},{"$f":"IF(AG8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AH$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AK8<>\"\",$F8+$I8*AJ$5,\"\")","v":""},{"$f":"IF(AI8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AJ$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AM8<>\"\",$F8+$I8*AL$5,\"\")","v":""},{"$f":"IF(AK8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AL$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AO8<>\"\",$F8+$I8*AN$5,\"\")","v":""},{"$f":"IF(AM8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AN$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AQ8<>\"\",$F8+$I8*AP$5,\"\")","v":""},{"$f":"IF(AO8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AP$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AS8<>\"\",$F8+$I8*AR$5,\"\")","v":""},{"$f":"IF(AQ8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AR$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AU8<>\"\",$F8+$I8*AT$5,\"\")","v":""},{"$f":"IF(AS8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AT$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AW8<>\"\",$F8+$I8*AV$5,\"\")","v":""},{"$f":"IF(AU8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AV$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(AY8<>\"\",$F8+$I8*AX$5,\"\")","v":""},{"$f":"IF(AW8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AX$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BA8<>\"\",$F8+$I8*AZ$5,\"\")","v":94657.142857142855},{"$f":"IF(AY8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*AZ$5+$F8,$I8,$E8),\"\"))","v":"ТО-2"},{"$f":"IF(BC8<>\"\",$F8+$I8*BB$5,\"\")","v":""},{"$f":"IF(BA8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BB$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BE8<>\"\",$F8+$I8*BD$5,\"\")","v":""},{"$f":"IF(BC8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BD$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BG8<>\"\",$F8+$I8*BF$5,\"\")","v":""},{"$f":"IF(BE8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BF$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BI8<>\"\",$F8+$I8*BH$5,\"\")","v":""},{"$f":"IF(BG8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BH$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BK8<>\"\",$F8+$I8*BJ$5,\"\")","v":""},{"$f":"IF(BI8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BJ$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BM8<>\"\",$F8+$I8*BL$5,\"\")","v":""},{"$f":"IF(BK8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BL$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BO8<>\"\",$F8+$I8*BN$5,\"\")","v":""},{"$f":"IF(BM8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BN$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BQ8<>\"\",$F8+$I8*BP$5,\"\")","v":""},{"$f":"IF(BO8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BP$5+$F8,$I8,$E8),\"\"))","v":""},{"$f":"IF(BS8<>\"\",$F8+$I8*BR$5,\"\")","v":""},{"$f":"IF(BQ8>\"\",\"\",IFERROR(FutureRepear($C8,$D8,$I8*BR$5+$F8,$I8,$E8),\"\"))","v":""}]