{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Summary","Buy a car","Rideshare"],"not_rendered":{"charts":1,"defined_names":33},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[1,1,1,13],[3,1,3,4],[10,1,10,4],[14,1,14,4]]}
[]
[null,"Buy a car vs. rideshare"]
[]
[null,"Average travel"]
[null,"Column1","Column2","Column3","Column4"]
[null,null,"Average trips per day",2]
[null,null,"Average time for each trip",20,"min(s)"]
[null,null,"Average distance for each trip",{"v":10,"d":"10.00"},"miles"]
[null,null,"Annual mileage",{"$f":"IFERROR(AverageTripsPerDay*AveDistancePerTrip*365,\"\")","v":{"v":7300,"d":"7,300"}},"miles"]
[]
[null,"Cost of time"]
[null,"Column1","Column2","Column3","Column4"]
[null,null,"Rate per hour",{"v":20,"d":"$20.00"}]
[]
[null,"Annual cost summary"]
[null," ","Column1","Buy a car","Rideshare"]
[null,null,"Purchase cost",{"$f":"AnnualPurchaseCost","v":{"v":7187.314844765674,"d":"$7,187"}},"-"]
[null,null,"Car usage costs",{"$f":"AnnualUsageCost","v":{"v":2990,"d":"$2,990"}},"-"]
[null,null,"Fuel costs",{"$f":"AnnualFuelCost","v":{"v":617.6923076923076,"d":"$618"}},"-"]
[null,null,"Fare cost","-",{"$f":"AnnualFareCost","v":{"v":12340.65,"d":"$12,341"}}]
[null,null,"Cost of time",{"$f":"AnnualCostOfTime_BuyCar","v":{"v":7300,"d":"$7,300"}},{"$f":"AnnualCostOfTime_Ridesharing","v":{"v":2190,"d":"$2,190"}}]
[null,null,"Total annual cost",{"$f":"SUBTOTAL(109,Table7[Buy a car])","v":{"v":18095.007152457983,"d":"$18,095"}},{"$f":"SUBTOTAL(109,Table7[Rideshare])","v":{"v":14530.65,"d":"$14,531"}}]

{"sheet":"Buy a car","index":1,"n_rows":36,"n_cols":5,"rows_kept":36,"merged":[[1,1,1,4],[3,1,3,4],[14,1,14,4],[24,1,24,4],[31,1,31,4]]}
[]
[null,"Buy a car"]
[]
[null,"Purchase cost"]
[null,"Column1","Activity","Cost","Terms"]
[null,null,"Price of car",{"v":30000,"d":"$30,000.00"}]
[null,null,"Sales tax",{"v":0.0575,"d":"$0.06"}]
[null,null,"Purchase fees",{"v":220,"d":"$220.00"}]
[null,null,"Down payment",{"v":3000,"d":"$3,000.00"},"months"]
[null,null,"Loan term",{"v":60,"d":"$60.00"}]
[null,null,"Interest rate",{"v":0.045,"d":"$0.05"}]
[null,null,"Annual purchase cost",{"$f":"IFERROR(-PMT(InterestRate,LoanTerm/12,PriceOfCar*(1+SalesTax)-DownPayment)+(PurchaseFees+DownPayment)/(LoanTerm/12),\"\")","v":{"v":7187.314844765674,"d":"$7,187.31"}}]
[null,null,{"$f":"IF(AnnualPurchaseCost=\"\",\"\",\"For loan term of \" & TEXT(LoanTerm/12,\"0.0\") & \" years\")","v":"For loan term of 5.0 years"}]
[]
[null,"Car usage costs"]
[null,"Column1","Activity","Cost","Terms"]
[null,null,"Maintenance & repairs",{"v":1000,"d":"$1,000"},"per year"]
[null,null,"Insurance",{"v":815,"d":"$815"},"per year"]
[null,null,"Registration & taxes",{"v":75,"d":"$75"},"per year"]
[null,null,"Parking",{"v":500,"d":"$500"},"per year"]
[null,null,"Property tax on garage",{"v":500,"d":"$500"},"per year"]
[null,null,"Other garage expenses",{"v":100,"d":"$100"},"per year"]
[null,null,"Annual usage cost",{"$f":"SUBTOTAL(109,Table3[Cost])","v":{"v":2990,"d":"$2,990.00"}}]
[]
[null,"Fuel costs"]
[null,"Column1","Activity","Unit","Terms"]
[null,null,"Fuel cost",{"v":3.3,"d":"$3.30"},"per gallon"]
[null,null,"Fuel efficiency",39,"miles / gal"]
[null,null,"Annual fuel cost",{"$f":"IFERROR(TotalMileage/FuelEfficiency*FuelCost,\"\")","v":{"v":617.6923076923076,"d":"$617.69"}}]
[null,null,{"$f":"IF(AnnualFuelCost=\"\",\"\",\"Based on \" & TEXT(TotalMileage,\"#,##0\") & \" total annual mileage\")","v":"Based on 7,300 total annual mileage"}]
[]
[null,"Cost of time"]
[null,"Column1","Activity","Unit","Terms"]
[null,null,"Average parking time",10,"mins"]
[null,null,"Annual cost of time",{"$f":"IFERROR((AveTimePerTrip+AveParkingTime)*AverageTripsPerDay/60*RatePerHour*365,\"\")","v":{"v":7300,"d":"$7,300.00"}}]
[null,null,{"$f":"IF(AnnualCostOfTime_BuyCar=\"\",\"\",\"Based on \" & AverageTripsPerDay & \" trips per day, \" & AveTimePerTrip + AveParkingTime & \" mins each trip, & \" & TEXT(RatePerHour,\"$#,##0.00\") & \" rate per hour\")","v":"Based on 2 trips per day, 30 mins each trip, & $20.00 rate per hour"}]

{"sheet":"Rideshare","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"merged":[[1,1,1,4],[3,1,3,4],[13,1,13,4]]}
[]
[null,"Rideshare"]
[]
[null,"Rideshare fare"]
[null,"Column1","Activity","Costs/Percent","Terms"]
[null,null,"Base fare",{"v":2.3,"d":"$2.30"},"per ride"]
[null,null,"Distance fare",{"v":1,"d":"$1.00"},"per mile"]
[null,null,"Time fare",{"v":0.12,"d":"$0.12"},"per min"]
[null,null,"Average surge multiplier",{"v":2.5,"d":"2.50"}]
[null,null,"Percent of rides during surge",{"v":0.1,"d":"10%"}]
[null,null,"Annual fare cost",{"$f":"IFERROR((BaseFare+DistanceFare*AveDistancePerTrip+TimeFare*AveTimePerTrip)*AverageTripsPerDay*365*((1-PercentRideDuringSurge)+AveSurgeMultiplier*PercentRideDuringSurge),\"\")","v":{"v":12340.65,"d":"$12,340.65"}}]
[null,null,{"$f":"IF(AnnualFareCost=\"\",\"\",\"Based on \" & AverageTripsPerDay & \" trips per day, \" & AveTimePerTrip & \" mins & \" & AveDistancePerTrip & \" miles per trip\")","v":"Based on 2 trips per day, 20 mins & 10 miles per trip"}]
[]
[null,"Cost of time"]
[null,"Column1","Activity","Cost","Terms"]
[null,null,"Average wait time per trip",{"v":5,"d":"$5.00"},"mins"]
[null,null,"Productive time during ride",{"v":0.8,"d":"$0.80"}]
[null,null,"Annual cost of time",{"$f":"IFERROR((AveWaitTime+AveTimePerTrip*(1-ProductivePercent))*AverageTripsPerDay/60*RatePerHour*365,\"\")","v":{"v":2190,"d":"$2,190.00"}}]
[null,null,{"$f":"IF(AnnualCostOfTime_Ridesharing=\"\",\"\",\"Based on \" & AverageTripsPerDay & \" trips per day, \" & AveTimePerTrip & \" mins each trip, & \" & TEXT(RatePerHour,\"$#,##0.00\") & \" rate per hour\")","v":"Based on 2 trips per day, 20 mins each trip, & $20.00 rate per hour"}]