{"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,4],[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,"名前","Kim Ambercrombie","承認者",null,null,"Yossi Banai",null,"マイルごとの払い戻し",null,null,{"v":0.32,"d":"¥0.32"}]
[]
[null,"部署","売上","提出日",null,null,{"$f":"TODAY()","v":"2018-01-19"},null,"払い戻し合計",null,null,{"$f":"払い戻し合計","v":{"v":58882.50181818182,"d":"¥58,882.50"}}]
[]
[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(ガス、レンタカー、タクシー)","食事とチップ","会議とセミナー","マイル","マイレージ払い戻し","雑費","通貨為替レート","経費の通貨","合計"]
[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*MileageRate,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":0.011,"d":"0.01"},"CAD",{"$f":"IFERROR(IF(OR(経費明細書!$L10=\"\",経費明細書!$L10=1),SUM(経費明細書!$J10:$K10,経費明細書!$D10:$H10)*1,SUM(経費明細書!$J10:$K10,経費明細書!$D10:$H10)/経費明細書!$L10),\"\")","v":{"v":56200.00000000001,"d":"¥56,200.00"}}]
[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*MileageRate,\"\")","v":3.84},null,{"v":0.011,"d":"0.01"},"CAD",{"$f":"IFERROR(IF(OR(経費明細書!$L11=\"\",経費明細書!$L11=1),SUM(経費明細書!$J11:$K11,経費明細書!$D11:$H11)*1,SUM(経費明細書!$J11:$K11,経費明細書!$D11:$H11)/経費明細書!$L11),\"\")","v":{"v":2558.1818181818185,"d":"¥2,558.18"}}]
[null,"2017-12-20","午後のセミナー",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF(経費明細書!I12<>\"\",経費明細書!I12*MileageRate,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"JPY",{"$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*MileageRate,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"JPY",{"$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(ガス、レンタカー、タクシー)])","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":58882.50181818182,"d":"¥58,882.50"}}]