Power Module NewPlants Sheet

The "NewPlants" sheet lays out the specifications for each new plant that can be built by the model.


·  Click here to get an animated introduction to this sheet.

·  Read the detailed overview of the sheet while you work on it by clicking here.

 

Modifications to this sheet ...

If changes are made to the plants that will be built by the model this will modify the table in rows 7 – 31.

If changes are made here this same distribution of plants technology must be replicated on the supply sheet in rows 179 - 203.

The same changes will need to be applied to each of the sections of the output sheet.

 

Overview of the sheet

The "NewPlants" sheet lays out the specifications for each new plant that can be built by the model.

It contains default specifications for 25 plant types in rows 7-31 (the number may vary) – including efficiencies, investments, and operating costs. It can be easily expanded to include more, by adding more rows to the list.

Below the main list of plants there is another illustrative list of the same plants containing real prices in 2005 USD. This list is not used in the calculations.

Cells in columns U, V and W refer to the lists in columns AK-AM, using the Data/Data validation function.

Column B has a list of typical Heat Rate Degradation percentages experienced in the first 22 years of a plant's life. These numbers are used in the list of new plants in the "Units" sheet in BC114-higher (may vary)