{"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,"123 South Main Street, North Buffalo, NY 12345"]
[null,"電話",4255550121,null,"名前","Kim Abercrombie",null,null,"目的","年次営業セミナー",null,"マイル レート",{"v":0.5,"d":"¥0.50/マイル"}]
[null,"FAX",4255550122,null,"部署","営業",null,null,"開始日",{"$f":"IFERROR(MIN(経費[日付]),\"\")","v":"2018-06-12"},null,"食事レート",{"v":30,"d":"¥30.00/日"}]
[null,"電子メール","info@contoso.com",null,"職位","管理責任者",null,null,"終了日",{"$f":"IFERROR(MAX(経費[日付]),\"\")","v":"2018-07-12"},null,"ホテル レート",{"v":200,"d":"¥200.00/泊"}]
[null,"WEB","www.contoso.com",null,"マネージャー","Michael Tucker",null,null,"作成者","Kim Abercrombie",null,"電話レート",{"v":10,"d":"¥10.00/日"}]
[{"$nulls":8},"承認者","Michael Tucker",null,"その他レート",{"v":50,"d":"¥50.00/日"}]
[]
[null,"日付","口座","説明","ホテル","交通費","食事","電話","その他","走行距離計\n開始","走行距離計\n終了","走行距離\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,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":{"v":38.850000000000364,"d":"¥38.85"}},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":{"v":88.85000000000036,"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,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":{"v":30,"d":"¥30.00"}},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":{"v":725,"d":"¥725.00"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(経費[[#This Row],[走行距離計\n開始]:[走行距離計\n終了]])=2,(経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(経費[[#This Row],[日付]:[走行距離計\n終了]])=0,\"\",SUM(経費[[#This Row],[ホテル]:[交通費]],経費[[#This Row],[食事]:[その他]],((経費[[#This Row],[走行距離計\n終了]]-経費[[#This Row],[走行距離計\n開始]])*(MileageRate))))","v":""}]
[null,"合計",null,null,{"$f":"SUBTOTAL(109,経費[ホテル])","v":{"v":445,"d":"¥445"}},{"$f":"SUBTOTAL(109,経費[交通費])","v":{"v":225,"d":"¥225"}},{"$f":"SUBTOTAL(109,経費[食事])","v":{"v":20,"d":"¥20"}},{"$f":"SUBTOTAL(109,経費[電話])","v":0},{"$f":"SUBTOTAL(109,経費[その他])","v":{"v":55,"d":"¥55"}},{"$nulls":3},{"$f":"SUBTOTAL(109,経費[[合計 ]])","v":{"v":813.8500000000004,"d":"¥813.85"}}]
[{"$nulls":11},"前貸し",{"v":0,"d":"¥0.00"}]
[{"$nulls":11},"合計",{"$f":"経費[[#Totals],[合計 ]]-前貸し","v":{"v":813.8500000000004,"d":"¥813.85"}}]