{"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":16,"n_cols":4,"rows_kept":16}
[null,"Buy a car vs rideshare"]
[null,"Average travel"]
[null,"Average trips per day",2]
[null,"Average time for each trip",20,"min(s)"]
[null,"Average distance for each trip",{"v":10,"d":"10.00"},"miles"]
[null,"Annual mileage",{"$f":"IFERROR(AverageTripsPerDay*AveDistancePerTrip*365,\"\")","v":{"v":7300,"d":"7,300"}},"miles"]
[null,"Cost of time"]
[null,"Rate per hour",{"v":20,"d":"£20.00"}]
[null,"Annual cost summary"]
[" ","Column1","Buy a car","Rideshare"]
[null,"Purchase cost",{"$f":"AnnualPurchaseCost","v":{"v":7187.314844765674,"d":"£7,187.31"}},"-"]
[null,"Car usage costs",{"$f":"AnnualUsageCost","v":{"v":2990,"d":"£2,990.00"}},"-"]
[null,"Fuel costs",{"$f":"AnnualFuelCost","v":{"v":617.6923076923076,"d":"£617.69"}},"-"]
[null,"Fare cost","-",{"$f":"AnnualFareCost","v":{"v":12340.65,"d":"£12,340.65"}}]
[null,"Cost of time",{"$f":"AnnualCostOfTime_BuyCar","v":{"v":7300,"d":"£7,300.00"}},{"$f":"AnnualCostOfTime_Ridesharing","v":{"v":2190,"d":"£2,190.00"}}]
[null,"Total annual cost",{"$f":"SUBTOTAL(109,Table7[Buy a car])","v":{"v":18095.007152457983,"d":"£18,095.01"}},{"$f":"SUBTOTAL(109,Table7[Rideshare])","v":{"v":14530.65,"d":"£14,530.65"}}]

{"sheet":"Buy a car","index":1,"n_rows":28,"n_cols":4,"rows_kept":28}
[null,"Buy a car"]
[null,"Purchase cost"]
[]
[null,"Price of car",{"v":30000,"d":"£30,000.00"}]
[null,"VAT",{"v":0.0575,"d":"£0.06"}]
[null,"Purchase fees",{"v":220,"d":"£220.00"}]
[null,"Down payment",{"v":3000,"d":"£3,000.00"},"months"]
[null,"Loan term",{"v":60,"d":"£60.00"}]
[null,"Interest rate",{"v":0.045,"d":"£0.05"}]
[null,"Annual purchase cost",{"$f":"IFERROR(-PMT(InterestRate,LoanTerm/12,PriceOfCar*(1+VAT)-DownPayment)+(PurchaseFees+DownPayment)/(LoanTerm/12),\"\")","v":{"v":7187.314844765674,"d":"£7,187.31"}}]
[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,"Maintenance & repairs",{"v":1000,"d":"£1,000.00"},"per year"]
[null,"Insurance",{"v":815,"d":"£815.00"},"per year"]
[null,"Registration & taxes",{"v":75,"d":"£75.00"},"per year"]
[null,"Parking",{"v":500,"d":"£500.00"},"per year"]
[null,"Property tax on garage",{"v":500,"d":"£500.00"},"per year"]
[null,"Other garage expenses",{"v":100,"d":"£100.00"},"per year"]
[null,"Annual usage cost",{"$f":"SUBTOTAL(109,Table3[Column3])","v":{"v":2990,"d":"£2,990.00"}}]
[null,"Fuel costs"]
[null,"Fuel cost",{"v":3.3,"d":"£3.30"},"per gallon"]
[null,"Fuel efficiency",39,"miles/gal"]
[null,"Annual fuel cost",{"$f":"IFERROR(TotalMileage/FuelEfficiency*FuelCost,\"\")","v":{"v":617.6923076923076,"d":"£617.69"}}]
[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,"Average parking time",10,"min."]
[null,"Annual cost of time",{"$f":"IFERROR((AveTimePerTrip+AveParkingTime)*AverageTripsPerDay/60*RatePerHour*365,\"\")","v":{"v":7300,"d":"£7,300.00"}}]
[null,{"$f":"IF(AnnualCostOfTime_BuyCar=\"\",\"\",\"Based on \" & AverageTripsPerDay & \" trips per day, \" & AveTimePerTrip + AveParkingTime & \" min. each trip & \" & TEXT(RatePerHour,\"£#,##0.00\") & \" rate per hour\")","v":"Based on 2 trips per day, 30 min. each trip & £20.00 rate per hour"}]

{"sheet":"Rideshare","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[null,"Rideshare"]
[null,"Rideshare fare"]
[null,"Base fare",{"v":2.3,"d":"£2.30"},"per ride"]
[null,"Distance fare",{"v":1,"d":"£1.00"},"per mile"]
[null,"Time fare",{"v":0.12,"d":"£0.12"},"per min."]
[null,"Average surge multiplier",{"v":2.5,"d":"2.50"}]
[null,"Percentage of rides during surge",{"v":0.1,"d":"10%"}]
[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,{"$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,"Average wait time per trip",{"v":5,"d":"£5.00"},"min."]
[null,"Productive time during ride",{"v":0.8,"d":"£0.80"}]
[null,"Annual cost of time",{"$f":"IFERROR((AveWaitTime+AveTimePerTrip*(1-ProductivePercent))*AverageTripsPerDay/60*RatePerHour*365,\"\")","v":{"v":2190,"d":"£2,190.00"}}]
[null,{"$f":"IF(AnnualCostOfTime_Ridesharing=\"\",\"\",\"Based on \" & AverageTripsPerDay & \" trips per day, \" & AveTimePerTrip & \" min. each trip & \" & TEXT(RatePerHour,\"£#,##0.00\") & \" rate per hour\")","v":"Based on 2 trips per day, 20 min. each trip & £20.00 rate per hour"}]