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

{"sheet":"零用金报销单","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[3,2,3,3],[3,5,3,6],[3,9,3,10],[4,2,4,3],[4,5,4,6],[4,9,4,10],[5,2,5,3],[5,5,5,6],[5,9,5,10],[6,2,6,3],[6,5,6,6],[6,9,6,10],[7,9,7,10]]}
[null,"零用金报销单"]
[null,"CONTOSO, LTD"]
[null,"邮编 098052 江苏省南京市天府街 4567 号"]
[null,"电话",4255550121,null,"姓名","米申",null,null,"用途","年度销售研讨会",null,"里程费",{"v":5,"d":"¥5.00/英哩"}]
[null,"传真",4255550122,null,"部门","销售部",null,null,"开始日期",{"$f":"IFERROR(MIN(费用[日期]),\"\")","v":"2018-06-12"},null,"餐饮费",{"v":300,"d":"¥300.00/天"}]
[null,"电子邮件","info@contoso.com",null,"职位","总经理",null,null,"结束日期",{"$f":"IFERROR(MAX(费用[日期]),\"\")","v":"2018-07-12"},null,"住宿费",{"v":2000,"d":"¥2,000.00/晚"}]
[null,"Web 地址","www.contoso.com",null,"经理","黄琏",null,null,"申请人","米申",null,"电话费",{"v":100,"d":"¥100.00/天"}]
[{"$nulls":8},"审批人","黄琏",null,"杂项费",{"v":500,"d":"¥500.00/天"}]
[]
[null,"日期","帐目","说明","住宿费","交通费","餐饮费","电话费","杂项费","起始\n里程","起始\n里程2","里程费用\n总计","总计 "]
[null,{"$f":"TODAY()","v":"2018-06-12"},"销售","里程费用",{"$nulls":4},{"v":50,"d":"¥50.00"},{"v":11378.5,"d":"11,378.5 英哩"},{"v":11456.2,"d":"11,456.2 英哩"},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":{"v":388.50000000000364,"d":"¥388.50"}},{"v":88.85,"d":"¥88.85"}]
[null,{"$f":"TODAY()+30","v":"2018-07-12"},"销售","会议费用",{"v":445,"d":"¥445.00"},{"v":225,"d":"¥225.00"},{"v":20,"d":"¥20.00"},null,{"v":5,"d":"¥5.00"},{"v":11500,"d":"11,500.0 英哩"},{"v":11560,"d":"11,560.0 英哩"},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":{"v":300,"d":"¥300.00"}},{"$f":"IF(COUNTA(费用[[#This Row],[日期]:[起始\n里程2]])=0,\"\",SUM(费用[[#This Row],[住宿费]:[交通费]],费用[[#This Row],[餐饮费]:[杂项费]],((费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*(里程运价))))","v":{"v":995,"d":"¥995.00"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""},{"$f":"IF(COUNTA(费用[[#This Row],[日期]:[起始\n里程2]])=0,\"\",SUM(费用[[#This Row],[住宿费]:[交通费]],费用[[#This Row],[餐饮费]:[杂项费]],((费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*(里程运价))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""},{"$f":"IF(COUNTA(费用[[#This Row],[日期]:[起始\n里程2]])=0,\"\",SUM(费用[[#This Row],[住宿费]:[交通费]],费用[[#This Row],[餐饮费]:[杂项费]],((费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*(里程运价))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""},{"$f":"IF(COUNTA(费用[[#This Row],[日期]:[起始\n里程2]])=0,\"\",SUM(费用[[#This Row],[住宿费]:[交通费]],费用[[#This Row],[餐饮费]:[杂项费]],((费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*(里程运价))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""},{"$f":"IF(COUNTA(费用[[#This Row],[日期]:[起始\n里程2]])=0,\"\",SUM(费用[[#This Row],[住宿费]:[交通费]],费用[[#This Row],[餐饮费]:[杂项费]],((费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*(里程运价))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""},{"$f":"IF(COUNTA(费用[[#This Row],[日期]:[起始\n里程2]])=0,\"\",SUM(费用[[#This Row],[住宿费]:[交通费]],费用[[#This Row],[餐饮费]:[杂项费]],((费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*(里程运价))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(费用[[#This Row],[起始\n里程]:[起始\n里程2]])=2,(费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*里程运价,\"\")","v":""},{"$f":"IF(COUNTA(费用[[#This Row],[日期]:[起始\n里程2]])=0,\"\",SUM(费用[[#This Row],[住宿费]:[交通费]],费用[[#This Row],[餐饮费]:[杂项费]],((费用[[#This Row],[起始\n里程2]]-费用[[#This Row],[起始\n里程]])*(里程运价))))","v":""}]
[null,"总计",null,null,{"$f":"SUBTOTAL(109,费用[住宿费])","v":{"v":445,"d":"¥445.00"}},{"$f":"SUBTOTAL(109,费用[交通费])","v":{"v":225,"d":"¥225.00"}},{"$f":"SUBTOTAL(109,费用[餐饮费])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(109,费用[电话费])","v":0},{"$f":"SUBTOTAL(109,费用[杂项费])","v":{"v":55,"d":"¥55.00"}},{"$nulls":3},{"$f":"SUBTOTAL(109,费用[[总计 ]])","v":{"v":1083.85,"d":"¥1,083.85"}}]
[{"$nulls":11},"预付款",{"v":0,"d":"¥0.00"}]
[{"$nulls":11},"总计",{"$f":"费用[[#Totals],[总计 ]]-预付款","v":{"v":1083.85,"d":"¥1,083.85"}}]