On this page I will put together my collection of capacity price analysis and data. I will explain my opinions of the theories and present some history of capacity prices.
Gas Price Spreads.xlsm
Price Summary.xlsx
Exercise 12 – Price Analysis with Demand Repsonse and Demand Elasticity.xlsx
Exercise 6a – Simulaton with Simple Supply and Demand.xlsx
Equilibrium.xlsx
Cost Comparison.xls
U.S. Electricity and Gas Prices
You can create a macro that reads from the internet and then puts outputs in different sheets. I find this one of the most useful things to do with excel.
On this page I will put together my collection of capacity price analysis and data. I will explain my opinions of the theories and present some history of capacity prices.
Gas Price Spreads.xlsm
Price Summary.xlsx
Exercise 12 – Price Analysis with Demand Repsonse and Demand Elasticity.xlsx
Exercise 6a – Simulaton with Simple Supply and Demand.xlsx
Equilibrium.xlsx
Cost Comparison.xls
U.S. Electricity and Gas Prices
You can create a macro that reads from the internet and then puts outputs in different sheets. I find this one of the most useful things to do with excel.