{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["车辆记录簿","计算"],"not_rendered":{"charts":2,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"车辆记录簿","index":0,"n_rows":28,"n_cols":14,"rows_kept":28,"merged":[[6,1,6,2],[10,1,10,2],[14,1,14,2],[21,9,21,13],[22,1,22,7],[28,9,28,13]]}
[]
[{"$nulls":13},"里程表起始数字："]
[{"$nulls":13},10987]
[]
[]
[null,"总里程",null,"加油费总计",{"$nulls":8},"图形：","维护费用"]
[null,{"$f":"SUM(加油费[范围])","v":900},null,{"$f":"SUM(加油费[费用])","v":{"v":1685.5,"d":"¥1,685.50"}}]
[]
[{"$nulls":3},"总计"]
[null,"平均 MPG",null,"维护费用"]
[null,{"$f":"AVERAGE(加油费[MPG])","v":{"v":19.22128851540616,"d":"19.2"}},null,{"$f":"SUM(维护费用[费用])","v":{"v":2088.7,"d":"¥2,088.70"}}]
[]
[null,"总计",null,"总计"]
[null,"加油升数",null,"贷款还款"]
[null,{"$f":"SUM(加油费[升])","v":47},null,{"$f":"SUM(还款[金额])","v":{"v":6431.8,"d":"¥6,431.80"}}]
[]
[]
[null,"加油记录",{"$nulls":7},"贷款还款"]
[null,"日期","上次里程数","升","费用","里程数","范围","MPG",null,"日期","项目","金额","支票编号","备注"]
[null,"2013-01-11",{"$f":"IFERROR(MAX(起始里程,IF(加油费[里程数]<加油费[[#This Row],[里程数]],加油费[里程数])),\"\")","v":10987},16,{"v":563.4,"d":"¥563.40"},{"v":11291,"d":"11,291"},{"$f":"IFERROR(加油费[里程数]-加油费[[#This Row],[上次里程数]],\"\")","v":304},{"$f":"IFERROR(加油费[范围]/加油费[升],\"\")","v":{"v":19,"d":"19.0"}},null,"2013-01-02","一月还款",{"v":3215.9,"d":"¥3,215.90"},1055]
[null,"2013-01-16",{"$f":"IFERROR(MAX(起始里程,IF(加油费[里程数]<加油费[[#This Row],[里程数]],加油费[里程数])),\"\")","v":11291},17,{"v":602.5,"d":"¥602.50"},{"v":11601,"d":"11,601"},{"$f":"IFERROR(加油费[里程数]-加油费[[#This Row],[上次里程数]],\"\")","v":310},{"$f":"IFERROR(加油费[范围]/加油费[升],\"\")","v":{"v":18.235294117647058,"d":"18.2"}},null,"2013-02-02","二月还款",{"v":3215.9,"d":"¥3,215.90"},1062]
[null,"2013-01-21",{"$f":"IFERROR(MAX(起始里程,IF(加油费[里程数]<加油费[[#This Row],[里程数]],加油费[里程数])),\"\")","v":11601},14,{"v":519.6,"d":"¥519.60"},{"v":11887,"d":"11,887"},{"$f":"IFERROR(加油费[里程数]-加油费[[#This Row],[上次里程数]],\"\")","v":286},{"$f":"IFERROR(加油费[范围]/加油费[升],\"\")","v":{"v":20.428571428571427,"d":"20.4"}}]
[]
[{"$nulls":9},"维护记录"]
[{"$nulls":9},"日期","项目","费用","里程数","备注"]
[{"$nulls":9},"2013-01-05","换油",{"v":438.7,"d":"¥438.70"},{"v":10567,"d":"10,567"}]
[{"$nulls":9},"2013-01-18","10,000 英里服务",{"v":670,"d":"¥670.00"},{"v":11420,"d":"11,420"}]
[{"$nulls":9},"2013-03-01","纠偏",{"v":980,"d":"¥980.00"},{"v":12887,"d":"12,887"}]

{"sheet":"计算","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"hidden":true}
["***此工作表应保持处于隐藏状态***"]
[]
[]
[null,"加油",{"$f":"SUM(加油费[费用])","v":1685.5}]
[null,"维护",{"$f":"SUM(维护费用[费用])","v":2088.7}]
[null,"贷款",{"$f":"SUM(还款[金额])","v":6431.8}]