{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["マイレージの記録と経費明細書"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"マイレージの記録と経費明細書","index":0,"n_rows":20,"n_cols":9,"rows_kept":20}
[null,"マイレージの記録と経費明細書"]
[]
[null,"従業員名",null,"マイル単価",{"v":0.27,"d":"¥0.27"}]
[null,"従業員 ID",null,"期間",{"$f":"\"開始 \"&TEXT(MIN(B9:B19),\"yy年m月d日\")&\" 終了 \"&TEXT(MAX(B9:B19),\"yy年m月d日\")","v":"開始 17年8月2日 終了 17年8月3日"}]
[null,"車両の説明",null,"マイレージ合計",{"$f":"Mileage_Total","v":10}]
[null,"承認者",null,"払い戻し合計",{"$f":"Reimbursement_Total","v":{"v":2.7,"d":"¥2.70"}}]
[]
[null,"日付","出発地","目的地","説明/メモ","走行距離計の開始値","走行距離計の終了値","マイレージ","払い戻し"]
[null,{"$f":"TODAY()","v":"2017-08-02"},"本社","Northwind Traders","顧客との会議",36098,36103,{"$f":"IFERROR(IF(OR(ISBLANK(F9),ISBLANK(G9)),0,G9-F9), \"\")","v":5},{"$f":"IFERROR(H9*$E$3, \"\")","v":{"v":1.35,"d":"¥1.35"}}]
[null,{"$f":"TODAY()+1","v":"2017-08-03"},"Northwind Traders","本社","顧客との会議",36103,36108,{"$f":"IFERROR(IF(OR(ISBLANK(F10),ISBLANK(G10)),0,G10-F10), \"\")","v":5},{"$f":"IFERROR(H10*$E$3, \"\")","v":{"v":1.35,"d":"¥1.35"}}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":7},0,{"v":0,"d":"¥0.00"}]
[{"$nulls":6},"合計",{"$f":"SUBTOTAL(109,経費[マイレージ])","v":10},{"$f":"SUBTOTAL(109,経費[払い戻し])","v":{"v":2.7,"d":"¥2.70"}}]