{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["概要","自動車購入","ライドシェア"],"not_rendered":{"charts":1,"defined_names":33},"read":"whole","date_system":"1900"}

{"sheet":"概要","index":0,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,"自動車購入とライドシェア"]
[null,"移動の平均"]
[null,"1 日あたりの平均移動回数",2]
[null,"移動 1 回あたりの平均時間",20,"分"]
[null,"移動 1 回あたりの平均距離",{"v":10,"d":"10.00"},"マイル"]
[null,"年間走行距離",{"$f":"IFERROR(_1_日あたりの平均移動回数*移動_1_回あたりの平均距離*365,\"\")","v":{"v":7300,"d":"7,300"}},"マイル"]
[null,"時間費用"]
[null,"1 時間あたりの料金",{"v":20,"d":"¥20.00"}]
[null,"年間費用まとめ"]
[" ","列 1","自動車購入","ライドシェア"]
[null,"購入費用",{"$f":"年間購入費用","v":{"v":7187.314844765674,"d":"¥7,187.31"}},"-"]
[null,"自動車使用経費",{"$f":"年間使用経費","v":{"v":2990,"d":"¥2,990.00"}},"-"]
[null,"燃料代",{"$f":"年間燃料代","v":{"v":617.6923076923076,"d":"¥617.69"}},"-"]
[null,"乗車料金","-",{"$f":"年間乗車料金","v":{"v":12340.65,"d":"¥12,340.65"}}]
[null,"時間費用",{"$f":"年間時間費用_自動車購入","v":{"v":7300,"d":"¥7,300.00"}},{"$f":"年間時間費用_ライドシェア","v":{"v":2190,"d":"¥2,190.00"}}]
[null,"年間費用合計",{"$f":"SUBTOTAL(109,表7[自動車購入])","v":{"v":18095.007152457983,"d":"¥18,095.01"}},{"$f":"SUBTOTAL(109,表7[ライドシェア])","v":{"v":14530.65,"d":"¥14,530.65"}}]

{"sheet":"自動車購入","index":1,"n_rows":28,"n_cols":4,"rows_kept":28}
[null,"自動車購入"]
[null,"購入費用"]
[]
[null,"自動車価格",{"v":30000,"d":"¥30,000.00"}]
[null,"消費税",{"v":0.0575,"d":"¥0.06"}]
[null,"購入手数料",{"v":220,"d":"¥220.00"}]
[null,"頭金",{"v":3000,"d":"¥3,000.00"},"月"]
[null,"ローン期間",{"v":60,"d":"¥60.00"}]
[null,"利率",{"v":0.045,"d":"¥0.05"}]
[null,"年間購入費用",{"$f":"IFERROR(-PMT(利率,ローン期間/12,自動車価格*(1+消費税)-頭金)+(購入手数料+頭金)/(ローン期間/12),\"\")","v":{"v":7187.314844765674,"d":"¥7,187.31"}}]
[null,{"$f":"IF(年間購入費用=\"\",\"\", TEXT(ローン期間/12,\"0.0\") & \" 年のローン期間の場合\")","v":"5.0 年のローン期間の場合"}]
[null,"自動車使用経費"]
[null,"保守/修理",{"v":1000,"d":"¥1,000.00"},"/年"]
[null,"保険",{"v":815,"d":"¥815.00"},"/年"]
[null,"登録費用/税金",{"v":75,"d":"¥75.00"},"/年"]
[null,"駐車場",{"v":500,"d":"¥500.00"},"/年"]
[null,"車庫の固定資産税",{"v":500,"d":"¥500.00"},"/年"]
[null,"その他の車庫経費",{"v":100,"d":"¥100.00"},"/年"]
[null,"年間使用経費",{"$f":"SUBTOTAL(109,表3[列3])","v":{"v":2990,"d":"¥2,990.00"}}]
[null,"燃料代"]
[null,"燃料代",{"v":3.3,"d":"¥3.30"},"/ガロン"]
[null,"燃費",39,"マイル/ガロン"]
[null,"年間燃料代",{"$f":"IFERROR(マイレージ合計/燃費*燃料代,\"\")","v":{"v":617.6923076923076,"d":"¥617.69"}}]
[null,{"$f":"IF(年間燃料代=\"\",\"\",\"年間合計走行距離 \" & TEXT(マイレージ合計,\"#,##0\") & \" マイルに基づく\")","v":"年間合計走行距離 7,300 マイルに基づく"}]
[null,"時間費用"]
[null,"平均駐車時間",10,"分"]
[null,"年間時間費用",{"$f":"IFERROR((移動_1_回あたりの平均時間+平均駐車時間)*_1_日あたりの平均移動回数/60*_1_時間あたりの料金*365,\"\")","v":{"v":7300,"d":"¥7,300.00"}}]
[null,{"$f":"IF(年間時間費用_自動車購入=\"\",\"\",\"時給 \" & TEXT(_1_時間あたりの料金,\"¥#,##0.00\") & \" 、各訪問に \" & 移動_1_回あたりの平均時間 + 平均駐車時間 & \" 分、1 日 \" & _1_日あたりの平均移動回数 & \" 回の訪問に基づく\")","v":"時給 ¥20.00 、各訪問に 30 分、1 日 2 回の訪問に基づく"}]

{"sheet":"ライドシェア","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[null,"ライドシェア"]
[null,"ライドシェア料金"]
[null,"基本料金",{"v":2.3,"d":"¥2.30"},"乗車 1 回あたり"]
[null,"距離料金",{"v":1,"d":"¥1.00"},"1 マイルあたり"]
[null,"時間料金",{"v":0.12,"d":"¥0.12"},"1 分あたり"]
[null,"平均サージ乗数",{"v":2.5,"d":"2.50"}]
[null,"サージ中の乗車割合",{"v":0.1,"d":"10%"}]
[null,"年間料金",{"$f":"IFERROR((基本料金+距離料金*移動_1_回あたりの平均距離+時間料金*移動_1_回あたりの平均時間)*_1_日あたりの平均移動回数*365*((1-サージ中の乗車割合)+平均サージ乗数*サージ中の乗車割合),\"\")","v":{"v":12340.65,"d":"¥12,340.65"}}]
[null,{"$f":"IF(年間乗車料金=\"\",\"\", 移動_1_回あたりの平均時間 & \" 分で \" & 平均駐車時間 & \" マイル、1 日 \" & _1_日あたりの平均移動回数 & \" 回の訪問に基づく\")","v":"20 分で 10 マイル、1 日 2 回の訪問に基づく"}]
[null,"時間費用"]
[null,"移動 1 回あたりの平均待ち時間",{"v":5,"d":"¥5.00"},"分"]
[null,"乗車中の生産時間",{"v":0.8,"d":"¥0.80"}]
[null,"年間時間費用",{"$f":"IFERROR((平均待ち時間+移動_1_回あたりの平均時間*(1-生産率))*_1_日あたりの平均移動回数/60*_1_時間あたりの料金*365,\"\")","v":{"v":2190,"d":"¥2,190.00"}}]
[null,{"$f":"IF(年間時間費用_ライドシェア=\"\",\"\",\"時給 \" & TEXT(_1_時間あたりの料金,\"¥#,##0.00\") & \" 、各訪問に \" & 移動_1_回あたりの平均時間 & \" 分、1 日 \" & _1_日あたりの平均移動回数 & \" 回の訪問に基づく\")","v":"時給 ¥20.00 、各訪問に 20 分、1 日 2 回の訪問に基づく"}]