{"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":27,"n_cols":14,"rows_kept":27,"merged":[[9,10,10,10]]}
[" 費用報表"]
[null,"CONTOSO, LTD"]
[null,"台北市北平東路24號"]
[null,"電話","425.555.0121",null,"姓名","黃安東",null,null,"事由","年度銷售研討會",null,"里程數補貼費率",{"v":15,"d":"NT$15.00/英哩"}]
[null,"傳真","425.555.0122",null,"部門","業務",null,null,"開始日期","2012-12-01",null,"餐費補貼費率",{"v":900,"d":"NT$900.00/天"}]
[null,"電子郵件","info@contoso.com",null,"職位","常務董事",null,null,"結束日期","2012-12-05",null,"住宿費補貼費率",{"v":6000,"d":"NT$6,000.00/夜"}]
[null,"網站","www.contoso.com",null,"主管","鍾法蘭",null,null,"申報人","黃安東",null,"電話費補貼費率",{"v":300,"d":"NT$300.00/天"}]
[{"$nulls":8},"核准人","鍾法蘭",null,"其他補貼費率",{"v":1500,"d":"NT$1,500.00/天"}]
[]
[{"$nulls":10},"里程計",null,null," "]
[{"$nulls":13}," "]
[]
[null,"日期","會計科目","描述","住宿費","交通費","餐費","電話費","其他","開始","結束","合計","合計 "]
[null,"2012-12-01","業務","里程數補貼",{"$nulls":5},{"v":11378.5,"d":"11,378.5 英哩"},{"v":11456.2,"d":"11,456.2 英哩"},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":{"v":1165.500000000011,"d":"NT$1,165.50"}},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":{"v":1165.500000000011,"d":"NT$1,165.50"}}]
[null,"2012-12-02","業務","開會",{"v":13350,"d":"NT$13,350.00"},{"v":6750,"d":"NT$6,750.00"},{"v":600,"d":"NT$600.00"},null,{"v":150,"d":"NT$150.00"},null,null,{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":{"v":20850,"d":"NT$20,850.00"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[開始]:[結束]])=2,(tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[日期]:[結束]])=0,\"\",SUM(tblExpenses[[#This Row],[住宿費]:[交通費]],tblExpenses[[#This Row],[餐費]:[其他]],((tblExpenses[[#This Row],[結束]]-tblExpenses[[#This Row],[開始]])*(MileageRate))))","v":""}]
[null,"合計",null,null,{"$f":"SUBTOTAL(109,tblExpenses[住宿費])","v":{"v":13350,"d":"NT$13,350.00"}},{"$f":"SUBTOTAL(109,tblExpenses[交通費])","v":{"v":6750,"d":"NT$6,750.00"}},{"$f":"SUBTOTAL(109,tblExpenses[餐費])","v":{"v":600,"d":"NT$600.00"}},{"$f":"SUBTOTAL(109,tblExpenses[電話費])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,tblExpenses[其他])","v":{"v":150,"d":"NT$150.00"}},{"$nulls":3},{"$f":"SUBTOTAL(109,tblExpenses[[合計 ]])","v":{"v":22015.50000000001,"d":"NT$22,015.50"}}]
[{"$nulls":11},"預支費用",{"v":0,"d":"NT$0.00"}]
[{"$nulls":11},"合計",{"$f":"tblExpenses[[#Totals],[合計 ]]-Advances","v":{"v":22015.50000000001,"d":"NT$22,015.50"}}]