Commuting by the Numbers: Car, Public Transport, Bike & Remote Days – Cost per Trip, Pass Break-Even, Time Value & CO₂
Compare how you get to work: car costs per km, season pass vs single tickets, bike and e-bike costs, carpooling, home-office days and the value of your time, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you compare every way to get to work with a spreadsheet. You turn fuel or electricity, wear and parking into a car cost per km and per office day, and find how many trips make a monthly or annual pass pay off with ROUNDUP. You spread a bike and an e-bike purchase over its years of use, count office days with NETWORKDAYS and EOMONTH for hybrid weeks, and split carpool costs fairly including detours. Then you add the value of your time as a generalised cost, estimate CO₂ with fictional factors and finish with an annual dashboard, RANK.EQ and a chart.
Lessons
- Car Costs per Kilometre: Energy, Wear and Parking per Office Day Pro
- Single Tickets or a Pass? Break-Even Trips and the Cheapest Ticket Pro
- Bike and E-Bike: Purchase Spread over the Years, Maintenance and Charging per Trip Pro
- Hybrid Weeks: Office Days per Month with NETWORKDAYS and When a Pass Stops Paying Off Pro
- Carpooling: Shared Costs, Detour Kilometres and a Fair Split Pro
- The Value of Your Time: Door-to-Door Minutes and the Generalised Cost per Trip Pro
- CO₂ per Trip and per Year with Fictional Emission Factors Pro
- Capstone: The Annual Commute Dashboard – Cost, Time, CO₂, Ranks and a Chart Pro