{"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,"每天平均出行次数",2]
[null,"每次出行的平均时间",20,"分钟"]
[null,"每次出行的平均距离",{"v":10,"d":"10.00"},"英里"]
[null,"年行驶里程",{"$f":"IFERROR(每天平均出行次数*AveDistancePerTrip*365,\"\")","v":{"v":7300,"d":"7,300"}},"英里"]
[null,"时间成本"]
[null,"每小时费率",{"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":"AnnualCostOfTime_BuyCar","v":{"v":7300,"d":"¥7,300.00"}},{"$f":"AnnualCostOfTime_Ridesharing","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(TotalMileage/燃料效率*燃油费用,\"\")","v":{"v":617.6923076923076,"d":"¥617.69"}}]
[null,{"$f":"IF(年度燃油费用=\"\",\"\",\"基于 \" & TEXT(TotalMileage,\"#,##0\") & \" 的年度总里程\")","v":"基于 7,300 的年度总里程"}]
[null,"时间成本"]
[null,"平均停车时间",10,"分钟"]
[null,"年度时间成本",{"$f":"IFERROR((AveTimePerTrip+平均停车时间)*每天平均出行次数/60*每小时费率*365,\"\")","v":{"v":7300,"d":"¥7,300.00"}}]
[null,{"$f":"IF(AnnualCostOfTime_BuyCar=\"\",\"\",\"基于每天 \" & 每天平均出行次数 & \" 次旅行，每次旅行 \" & AveTimePerTrip + 平均停车时间 & \" 分钟，每小时 \" & TEXT(每小时费率,\"¥#,##0.00\") & \" 的费率\")","v":"基于每天 2 次旅行，每次旅行 30 分钟，每小时 ¥20.00 的费率"}]

{"sheet":"拼车","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[null,"拼车"]
[null,"拼车费"]
[null,"基本车费",{"v":2.3,"d":"¥2.30"},"每次拼车"]
[null,"乘距车费",{"v":1,"d":"¥1.00"},"每英里"]
[null,"时间车费",{"v":0.12,"d":"¥0.12"},"每分钟"]
[null,"平均高峰时段乘数",{"v":2.5,"d":"2.50"}]
[null,"高峰时段拼车百分比",{"v":0.1,"d":"10%"}]
[null,"年度过路费成本",{"$f":"IFERROR((基本车费+乘距车费*AveDistancePerTrip+时间车费*AveTimePerTrip)*每天平均出行次数*365*((1-高峰时段拼车百分比)+平均高峰时段乘数*高峰时段拼车百分比),\"\")","v":{"v":12340.65,"d":"¥12,340.65"}}]
[null,{"$f":"IF(年度过路费成本=\"\",\"\",\"基于每天 \" & 每天平均出行次数 & \" 次旅行，每次旅行 \" & AveTimePerTrip & \" 分钟和 \" & AveDistancePerTrip & \" 英里路程\")","v":"基于每天 2 次旅行，每次旅行 20 分钟和 10 英里路程"}]
[null,"时间成本"]
[null,"每次出行的平均等待时间",{"v":5,"d":"¥5.00"},"分钟"]
[null,"行驶中的有效时间",{"v":0.8,"d":"¥0.80"}]
[null,"年度时间成本",{"$f":"IFERROR((AveWaitTime+AveTimePerTrip*(1-ProductivePercent))*每天平均出行次数/60*每小时费率*365,\"\")","v":{"v":2190,"d":"¥2,190.00"}}]
[null,{"$f":"IF(AnnualCostOfTime_Ridesharing=\"\",\"\",\"基于每天 \" & 每天平均出行次数 & \" 次旅行，每次旅行 \" & AveTimePerTrip & \" 分钟，每小时 \" & TEXT(每小时费率,\"¥#,##0.00\") & \" 的费率\")","v":"基于每天 2 次旅行，每次旅行 20 分钟，每小时 ¥20.00 的费率"}]