{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["里程记录和费用报表"],"not_rendered":{"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"里程记录和费用报表","index":0,"n_rows":20,"n_cols":9,"rows_kept":20}
[]
[]
[null,"员工姓名",null,"每英里价格",{"v":0.27,"d":"¥0.27"}]
[null,"员工 ID",null,"时长",{"$f":"\"从\"&TEXT(MIN(B9:B19),\"m/d/yy\")&\"到\"&TEXT(MAX(B9:B19),\"m/d/yy\")","v":"从5/9/18到5/9/18"}]
[null,"车辆说明",null,"总里程",{"$f":"总里程","v":10}]
[null,"授权人",null,"总报销",{"$f":"总报销","v":{"v":2.7,"d":"¥2.70"}}]
[]
[null,"日期","出发地","目的地","说明/备注","里程表开始","里程表结束","里程","报销"]
[null,"2018-05-09","总部","Northwind Traders","客户会议",36098,36103,{"$f":"IFERROR(IF(OR(ISBLANK(F9),ISBLANK(G9)),0,G9-F9), \"\")","v":5},{"$f":"IFERROR(H9*$E$3, \"\")","v":{"v":1.35,"d":"¥1.35"}}]
[null,"2018-05-09","Northwind Traders","总部","客户会议",36103,36108,{"$f":"IFERROR(IF(OR(ISBLANK(F10),ISBLANK(G10)),0,G10-F10), \"\")","v":5},{"$f":"IFERROR(H10*$E$3, \"\")","v":{"v":1.35,"d":"¥1.35"}}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":6},"总计",{"$f":"SUBTOTAL(109,支出[里程])","v":10},{"$f":"SUBTOTAL(109,支出[报销])","v":{"v":2.7,"d":"¥2.70"}}]