{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["里程日志","日志数据","计算"],"not_rendered":{"charts":1,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"里程日志","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[0,1,1,4]]}
[null,"里程日志"]
{"$rows_empty":9}
[null,null,"可报销",null,"总计"]
[null,null,"里程",null,"报销"]
[]
[]
[]
[]
[null,null,"2012-05-01",null,"2012-05-10"]
[]
[null,null,"期间",null,"期间"]
[null,null,"开始",null,"结束"]
[]
[]
[]
[]
[]
[null,null,54,null,{"v":9800,"d":"9,800"}]
[]
[null,null,"报销",null,"上一次加油"]
[null,null,"¢/英里",null,"里程表"]

{"sheet":"日志数据","index":1,"n_rows":19,"n_cols":15,"rows_kept":19,"merged":[[0,1,1,4]]}
[null,"里程日志"]
[{"$nulls":14}," "]
[]
[]
[null,"日期","活动","里程表 1","位置","里程表 2","目的地","报销","加仑","费用","里程","MPG","￠/英里","备注"]
[null,"2012-05-01","出差",{"v":10123,"d":"10,123"},"山腰 - 主街",{"v":10130,"d":"10,130"},null,null,15.56,{"v":641.1,"d":"¥641.10"},{"$f":"miles","v":7},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-01","出差",{"v":10130,"d":"10,130"},"办公室",{"v":10200,"d":"10,200"},"樱桃街","是",null,"",{"$f":"miles","v":70},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-01","出差",{"v":10200,"d":"10,200"},"枣庄",{"v":10285,"d":"10,285"},"办公室","是",null,"",{"$f":"miles","v":85},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-02","出差",{"v":10285,"d":"10,285"},"办公室",{"v":10450,"d":"10,450"},"可乐葡萄园","是",null,"",{"$f":"miles","v":165},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-02","燃油",{"v":10450,"d":"10,450"},"湾仔",{"$nulls":3},{"v":11.2,"d":"11.20"},{"v":554.2,"d":"¥554.20"},{"$f":"miles","v":650},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":{"v":58.03571428571429,"d":"58.0"}},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":{"v":85.26153846153848,"d":"85.3"}}]
[null,"2012-05-02","出差",{"v":10500,"d":"10,500"},"可乐葡萄园",{"v":10518,"d":"10,518"},"办公室","是",null,"",{"$f":"miles","v":18},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-03","出差",{"v":10518,"d":"10,518"},"办公室",{"v":10745,"d":"10,745"},"办公室","是",null,"",{"$f":"miles","v":227},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-04","燃油",{"v":10745,"d":"10,745"},"山腰 - 主街",{"$nulls":3},{"v":16.6,"d":"16.60"},{"v":692.4,"d":"¥692.40"},{"$f":"miles","v":295},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":{"v":17.771084337349397,"d":"17.8"}},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":{"v":234.71186440677965,"d":"234.7"}}]
[null,"2012-05-04","出差",{"v":10745,"d":"10,745"},"办公室",{"v":10800,"d":"10,800"},"杨村","是",null,"",{"$f":"miles","v":55},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-04","出差",{"v":10800,"d":"10,800"},"杨村",{"v":10875,"d":"10,875"},"办公室","是",null,"",{"$f":"miles","v":75},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-07","出差",{"v":10875,"d":"10,875"},"办公室",{"v":10921,"d":"10,921"},"樱桃街","是",null,"",{"$f":"miles","v":46},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-07","出差",{"v":10921,"d":"10,921"},"枣庄",{"v":10969,"d":"10,969"},"办公室","是",null,"",{"$f":"miles","v":48},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-09","出差",{"v":10969,"d":"10,969"},"办公室",{"v":11000,"d":"11,000"},"滨江路","是",null,"",{"$f":"miles","v":31},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]
[null,"2012-05-09","出差",{"v":11000,"d":"11,000"},"滨江路",{"v":11100,"d":"11,100"},"家中","否",null,"",{"$f":"miles","v":100},{"$f":"IF(OR(LEN(数据[[#This Row],[里程表 2]]),数据[[#This Row],[里程表 1]]=\"\"),\"\",IFERROR(数据[[#This Row],[里程]]/数据[[#This Row],[加仑]],\"\"))","v":""},{"$f":"IF(数据[[#This Row],[MPG]]=\"\",\"\",100*数据[[#This Row],[费用]]/数据[[#This Row],[里程]])","v":""}]

{"sheet":"计算","index":2,"n_rows":69,"n_cols":13,"rows_kept":69,"hidden":true}
["*** 本表保持隐藏 ***"]
[]
[]
[]
[]
[{"$nulls":8},{"$f":"OFFSET(I9,,secondAxis=\"燃油费\")","v":"MPG"}]
[{"$nulls":12},1]
[{"$nulls":7},"出差","燃油","燃油",null,"Second Axis:  ",{"$f":"REPT(\"MPG\",M7=1)&REPT(\"燃油费\",M7=2)","v":"MPG"}]
[{"$nulls":7},"行驶里程","MPG","¢/英里"]
[null,null,"可报销里程:  ",{"$f":"SUMIFS(数据[里程],数据[报销],\"是\",数据[日期],\">=\"&periodStart,数据[日期],\"<=\"&periodEnd)","v":820},null,1,{"$f":"periodStart","v":"2012-05-01"},{"$f":"SUMIFS(数据[里程],数据[日期],G10,数据[活动],$H$8)","v":162},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G10,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G10,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[null,null,"报销总额:  ",{"$f":"D10*ReimbursementPerMile/100","v":{"v":442.8,"d":"¥442.80"}},null,2,{"$f":"G10+1","v":"2012-05-02"},{"$f":"SUMIFS(数据[里程],数据[日期],G11,数据[活动],$H$8)","v":183},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G11,数据[活动],$I$8),NA())","v":{"v":58.03571428571429,"d":"58.0"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G11,数据[活动],$J$8),NA())","v":{"v":85.26153846153848,"d":"85.3"}}]
[{"$nulls":5},3,"2012-05-03",{"$f":"SUMIFS(数据[里程],数据[日期],G12,数据[活动],$H$8)","v":227},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G12,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G12,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},4,"2012-05-04",{"$f":"SUMIFS(数据[里程],数据[日期],G13,数据[活动],$H$8)","v":130},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G13,数据[活动],$I$8),NA())","v":{"v":17.771084337349397,"d":"17.8"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G13,数据[活动],$J$8),NA())","v":{"v":234.71186440677965,"d":"234.7"}}]
[{"$nulls":5},5,"2012-05-05",{"$f":"SUMIFS(数据[里程],数据[日期],G14,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G14,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G14,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},6,"2012-05-06",{"$f":"SUMIFS(数据[里程],数据[日期],G15,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G15,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G15,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},7,"2012-05-07",{"$f":"SUMIFS(数据[里程],数据[日期],G16,数据[活动],$H$8)","v":94},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G16,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G16,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},8,"2012-05-08",{"$f":"SUMIFS(数据[里程],数据[日期],G17,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G17,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G17,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},9,"2012-05-09",{"$f":"SUMIFS(数据[里程],数据[日期],G18,数据[活动],$H$8)","v":131},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G18,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G18,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},10,"2012-05-10",{"$f":"SUMIFS(数据[里程],数据[日期],G19,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G19,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G19,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},11,"2012-05-11",{"$f":"SUMIFS(数据[里程],数据[日期],G20,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G20,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G20,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},12,"2012-05-12",{"$f":"SUMIFS(数据[里程],数据[日期],G21,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G21,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G21,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},13,"2012-05-13",{"$f":"SUMIFS(数据[里程],数据[日期],G22,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G22,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G22,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},14,"2012-05-14",{"$f":"SUMIFS(数据[里程],数据[日期],G23,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G23,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G23,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},15,"2012-05-15",{"$f":"SUMIFS(数据[里程],数据[日期],G24,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G24,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G24,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},16,"2012-05-16",{"$f":"SUMIFS(数据[里程],数据[日期],G25,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G25,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G25,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},17,"2012-05-17",{"$f":"SUMIFS(数据[里程],数据[日期],G26,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G26,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G26,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},18,"2012-05-18",{"$f":"SUMIFS(数据[里程],数据[日期],G27,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G27,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G27,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},19,"2012-05-19",{"$f":"SUMIFS(数据[里程],数据[日期],G28,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G28,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G28,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},20,"2012-05-20",{"$f":"SUMIFS(数据[里程],数据[日期],G29,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G29,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G29,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},21,"2012-05-21",{"$f":"SUMIFS(数据[里程],数据[日期],G30,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G30,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G30,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},22,"2012-05-22",{"$f":"SUMIFS(数据[里程],数据[日期],G31,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G31,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G31,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},23,"2012-05-23",{"$f":"SUMIFS(数据[里程],数据[日期],G32,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G32,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G32,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},24,"2012-05-24",{"$f":"SUMIFS(数据[里程],数据[日期],G33,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G33,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G33,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},25,"2012-05-25",{"$f":"SUMIFS(数据[里程],数据[日期],G34,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G34,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G34,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},26,"2012-05-26",{"$f":"SUMIFS(数据[里程],数据[日期],G35,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G35,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G35,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},27,"2012-05-27",{"$f":"SUMIFS(数据[里程],数据[日期],G36,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G36,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G36,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},28,"2012-05-28",{"$f":"SUMIFS(数据[里程],数据[日期],G37,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G37,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G37,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},29,"2012-05-29",{"$f":"SUMIFS(数据[里程],数据[日期],G38,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G38,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G38,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},30,"2012-05-30",{"$f":"SUMIFS(数据[里程],数据[日期],G39,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G39,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G39,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},31,"2012-05-31",{"$f":"SUMIFS(数据[里程],数据[日期],G40,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G40,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G40,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},32,"2012-06-01",{"$f":"SUMIFS(数据[里程],数据[日期],G41,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G41,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G41,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},33,"2012-06-02",{"$f":"SUMIFS(数据[里程],数据[日期],G42,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G42,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G42,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},34,{"$f":"G42+1","v":"2012-06-03"},{"$f":"SUMIFS(数据[里程],数据[日期],G43,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G43,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G43,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},35,"2012-06-04",{"$f":"SUMIFS(数据[里程],数据[日期],G44,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G44,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G44,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},36,"2012-06-05",{"$f":"SUMIFS(数据[里程],数据[日期],G45,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G45,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G45,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},37,"2012-06-06",{"$f":"SUMIFS(数据[里程],数据[日期],G46,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G46,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G46,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},38,"2012-06-07",{"$f":"SUMIFS(数据[里程],数据[日期],G47,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G47,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G47,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},39,"2012-06-08",{"$f":"SUMIFS(数据[里程],数据[日期],G48,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G48,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G48,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},40,"2012-06-09",{"$f":"SUMIFS(数据[里程],数据[日期],G49,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G49,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G49,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},41,"2012-06-10",{"$f":"SUMIFS(数据[里程],数据[日期],G50,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G50,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G50,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},42,"2012-06-11",{"$f":"SUMIFS(数据[里程],数据[日期],G51,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G51,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G51,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},43,"2012-06-12",{"$f":"SUMIFS(数据[里程],数据[日期],G52,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G52,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G52,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},44,"2012-06-13",{"$f":"SUMIFS(数据[里程],数据[日期],G53,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G53,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G53,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},45,"2012-06-14",{"$f":"SUMIFS(数据[里程],数据[日期],G54,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G54,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G54,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},46,"2012-06-15",{"$f":"SUMIFS(数据[里程],数据[日期],G55,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G55,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G55,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},47,"2012-06-16",{"$f":"SUMIFS(数据[里程],数据[日期],G56,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G56,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G56,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},48,"2012-06-17",{"$f":"SUMIFS(数据[里程],数据[日期],G57,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G57,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G57,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},49,"2012-06-18",{"$f":"SUMIFS(数据[里程],数据[日期],G58,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G58,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G58,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},50,"2012-06-19",{"$f":"SUMIFS(数据[里程],数据[日期],G59,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G59,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G59,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},51,"2012-06-20",{"$f":"SUMIFS(数据[里程],数据[日期],G60,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G60,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G60,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},52,"2012-06-21",{"$f":"SUMIFS(数据[里程],数据[日期],G61,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G61,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G61,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},53,"2012-06-22",{"$f":"SUMIFS(数据[里程],数据[日期],G62,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G62,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G62,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},54,"2012-06-23",{"$f":"SUMIFS(数据[里程],数据[日期],G63,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G63,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G63,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},55,"2012-06-24",{"$f":"SUMIFS(数据[里程],数据[日期],G64,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G64,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G64,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},56,"2012-06-25",{"$f":"SUMIFS(数据[里程],数据[日期],G65,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G65,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G65,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},57,"2012-06-26",{"$f":"SUMIFS(数据[里程],数据[日期],G66,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G66,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G66,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},58,"2012-06-27",{"$f":"SUMIFS(数据[里程],数据[日期],G67,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G67,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G67,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},59,"2012-06-28",{"$f":"SUMIFS(数据[里程],数据[日期],G68,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G68,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G68,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},60,"2012-06-29",{"$f":"SUMIFS(数据[里程],数据[日期],G69,数据[活动],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(数据[MPG],数据[日期],G69,数据[活动],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(数据[￠/英里],数据[日期],G69,数据[活动],$J$8),NA())","v":{"$error":"#N/A"}}]