I tracked 37 airport trips in a spreadsheet. Here's what the data actually shows about transportation costs.

I'm a data person. When something costs me money repeatedly, I track it. After two years of flying out of Boston Logan Airport from Rhode Island, I had a feeling I was overspending on transportation. But feelings aren't data. So I built a spreadsheet and tracked every single trip for 24 months. The results completely changed how I think about "cheap" vs "expensive." The setup Location: Providence, RI to Boston Logan Airport Distance: ~50 miles Frequency: 15-20 trips per year (business + personal) Time period: January 2023 - December 2024 Total trips tracked: 37 Transportation options available: Uber/Lyft MBTA Commuter Rail Professional car service (pre-booked) Drive and park at airport I tried all of them. Here's what the numbers actually said. Methodology For every trip I logged: Transportation method Total cost (including tips, parking, gas, fees) Time of departure/arrival Door-to-terminal duration Stress level (subjective 1-10 scale) Whether I made my flight comfortably I pulled dat