{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["零用金报销单"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"零用金报销单","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,3],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"差旅费报销单"]
[]
[null,"姓名","米申","授权人",null,null,"孔西明",null,"每英里补贴",null,null,{"v":0.32,"d":"¥0.32"}]
[]
[null,"部门","销售","提交日期",null,null,{"$f":"TODAY()","v":"2018-01-19"},null,"总报销费用",null,null,{"$f":"总报销费用","v":{"v":3475.5340714480503,"d":"¥3,475.53"}}]
[]
[null,"时长",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"yyyy年m月d日\"),\"从 \"&TEXT(MIN(B10:B13),\"yyyy年m月d日\")&\" 到 \"&TEXT(MAX(B10:B13),\"yyyy年m月d日\"))","v":"从 2017年12月20日 到 2017年12月25日"}]
[]
[null,"日期","费用说明","机票","住宿","地面\n交通费\n（加油费、租车费、打的费）","餐饮费及小费","会议和研讨会","英里数","里程补贴","杂项","货币兑换率","记账货币","汇总"]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"出差到客户办事处",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF(零用金报销单!I10<>\"\",零用金报销单!I10*里程运价,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":0.193,"d":"0.19"},"加元",{"$f":"IFERROR(IF(OR(零用金报销单!$L10=\"\",零用金报销单!$L10=1),SUM(零用金报销单!$J10:$K10,零用金报销单!$D10:$H10)*1,SUM(零用金报销单!$J10:$K10,零用金报销单!$D10:$H10)/零用金报销单!$L10),\"\")","v":{"v":3203.1088082901556,"d":"¥3,203.11"}}]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"和客户用餐",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF(零用金报销单!I11<>\"\",零用金报销单!I11*里程运价,\"\")","v":3.84},null,0.19,"加元",{"$f":"IFERROR(IF(OR(零用金报销单!$L11=\"\",零用金报销单!$L11=1),SUM(零用金报销单!$J11:$K11,零用金报销单!$D11:$H11)*1,SUM(零用金报销单!$J11:$K11,零用金报销单!$D11:$H11)/零用金报销单!$L11),\"\")","v":{"v":148.10526315789474,"d":"¥148.11"}}]
[null,"2017-12-20","下午研讨会",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF(零用金报销单!I12<>\"\",零用金报销单!I12*里程运价,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"人民币",{"$f":"IFERROR(IF(OR(零用金报销单!$L12=\"\",零用金报销单!$L12=1),SUM(零用金报销单!$J12:$K12,零用金报销单!$D12:$H12)*1,SUM(零用金报销单!$J12:$K12,零用金报销单!$D12:$H12)/零用金报销单!$L12),\"\")","v":{"v":101.92,"d":"¥101.92"}}]
[null,{"$f":"TODAY()-25","v":"2017-12-25"},"去机场",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF(零用金报销单!I13<>\"\",零用金报销单!I13*里程运价,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"人民币",{"$f":"IFERROR(IF(OR(零用金报销单!$L13=\"\",零用金报销单!$L13=1),SUM(零用金报销单!$J13:$K13,零用金报销单!$D13:$H13)*1,SUM(零用金报销单!$J13:$K13,零用金报销单!$D13:$H13)/零用金报销单!$L13),\"\")","v":{"v":22.400000000000002,"d":"¥22.40"}}]
[null,"汇总",null,{"$f":"SUBTOTAL(109,费用[机票])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,费用[住宿])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,费用[地面\n交通费\n（加油费、租车费、打的费）])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,费用[餐饮费及小费])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,费用[会议和研讨会])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,费用[英里数])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,费用[里程补贴])","v":39.36},{"$f":"SUBTOTAL(109,费用[杂项])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,费用[汇总])","v":{"v":3475.5340714480503,"d":"¥3,475.53"}}]