Excel trick: Search for multiple keywords from a list
Recently I was given a large spreadsheet with people’s expertise written in long phrases, and I had to identify those people who have AI-related expertise. The issue...
Category
statistics
EV has come a long way but US is falling behind
I came across the data of EV stock at the country level from the IEA website. While it is informative, it does not have any map visualization, which is quite easy to do with...
EV Charging Networks: The Top 8
In the EV book that I co-wrote and co-edited (with Peter Fox-Penner and David Jermain) in 2019, we documented the status of EV charging infrastructure in cities around the...
How much do you pay charging an EV on a monthly basis?
I always knew it is a bit cheaper to drive an EV as opposed to a gasoline car (not the owning part, which deserve a separate calculation, but just the day-to-day cost of using...
Why Supply Chain Delays are Multi-faceted: A Mathematical Explanations (Without the Heavy Math)
Paul Krugman recently penned an excellent article explaining why we see the supply chain snarls in New York Times. It mentioned a number of factors: The US consumers are...
Understanding CO2 Emissions for different freight transport modes (renewable as well as non-renewable)
One of the most important questions to ask in transitioning to renewable modes of transport is simply: How much less CO2 are we going to emit by switching to renewables? The...
Tesla Lease Mileage Limit and the Central Limit Theorem
I am onto my second Tesla car leases now, so I think I can define another form of range anxiety with my leased cars: Driving over the lease limit. It was actually quite...
SHOULD I BUY OR LEASE A TESLA? PART 4: It all comes down to your apetities towards risk
Having used multiple spreadsheets to illustrate the dollars and cents around the leasing vs buying option, let me conclude. It depends on how you view uncertainty. As I said...
SHOULD I BUY OR LEASE A TESLA? PART 3: It is not black-and-white (because we do not know the future)
In my last post, I showed that the total cost of buying a Tesla with a loan (or cash) is easy to figure out. However the final value is critically dependent upon one thing:...
SHOULD I BUY OR LEASE A TESLA? PART 2: Total loan cost (when you are sure about the depreciation)
In a previous post, I calculated the total cost of leasing a Tesla, using my own experience as an example. Before we move on to the buying option, let me mention one important...