Commuting by the Numbers: Car, Public Transport, Bike & Remote Days – Cost per Trip, Pass Break-Even, Time Value & CO₂

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn consumption, energy prices, wear and parking into a cost per km, a cost per office day and a cost per month for a petrol and an electric car.
• Find how many trips make the monthly and the annual pass pay off, compare four ticket types for five commuting patterns and pick the cheapest ticket for each.
• Spread the purchase of a bike and an e-bike over their years of use, add gear, maintenance and charging, and turn everything into a cost per km and per one-way trip.
• Count the working days of a month with NETWORKDAYS and EOMONTH, turn office days per week into office days per month and find from which pattern the monthly pass pays off.
• Price a shared car day including the detours, compare an equal split with a fair split that charges each detour to the person who causes it, and work out what carpooling saves the driver per month.
• Add up door-to-door minutes, price Mira's time with her own value per hour, count usable train time only partly and find the option with the lowest generalised cost per trip.
• Turn fictional emission factors per km into CO₂ per trip and per year, compare each option with the petrol car and express the e-bike's yearly saving in tonnes.
• Bring all options together for one year: hours spent, generalised cost, a RANK.EQ ranking by money and a chart that shows how the order changes once time is priced in.