Quote of the Day
There’s an unpriced externality in the cost of fossil fuels. The unpriced externality is the probability-weighted harm of changing the chemical constituency of the atmosphere and oceans. Since it is not captured in the price of gasoline, it does not drive the right behavior. It’d be like if tossing out garbage was just free, and there was no penalty, and you could do it as much as you want. The streets would be full of garbage. We’ve regulated a lot of other things, like sulfur emissions and nitrous oxide emissions; it’s done a lot of good on that front.
— Elon Musk. I view this quote as a restatement of the Tragedy of the Commons.
I have been reading about how low natural gas prices have been affecting the coal mining industry. Coal mining is affected because those coal-fired electrical generation plants that can switch fuels are converting to natural gas to achieve significant cost reductions. Also, natural gas can fuel peaking generators that are designed to provide peak load support. The fuel conversions have increased to the point where it is significantly reducing the demand for coal.
I had no idea what the price advantages were for natural gas over other fuels, so I surfed over the US Department of Energy's (DoE) web site and found two tables that provided a summary of the maintenance, fuel, and operating costs for different types of electrical generation plants. The DoE combines the data for natural gas, solar, wind, etc into a single category called "Gas Turbine and Small Scale." This type of data is best presented in the form of a graph, so I used Excel's Get and Transform (Power Query) to download the tables, combine them, and reformat the information for easy plotting. Costs are expressed in Mills ($0.001) per kW-hr.
My Excel workbook is available here. It is a good example for people who want to (1) learn how to access data with a complex format, (2) uses an inner join to combine data, and (3) makes use of table transpose and unpivot operations.
Figure 1 shows the dramatic drop in the cost of electrical power produced by natural gas since 2008. Starting in 2012, electrical power generated from natural gas has had roughly the same cost or lower than from coal, and you can reduce your carbon footprint as well.
Figure 2 shows how the cost of natural gas, coal, and uranium have varied with time – the water for a hydroelectric plant is considered to be free. The drop in prices of electricity generated by natural gas is entirely accounted for by the price drop in fuel since the plant maintenance and operating costs have not changed much (Figure 3).