111(d) Emissions Guidelines for Existing Power Plants

Calculation of Texas’ State Goals in Proposed Rule

Summary Comments:

1. Be wary of hidden significant figures and rounding errors in your calculations. Although many of 

the numbers in the supplementary data spreadsheets appear to be whole numbers, if you click on 

the cells you will see that they are rounded.

2. Be careful when looking up data in the TSD spreadsheets – sometimes the columns don’t match, 

for example the columns for NGCC generation and emission rate and OG Steam and emission 

rate are transposed in a couple of the spreadsheets. Double-check the column headings on every 

spreadsheet to make sure you are looking at the correct data.

3. Be careful of unit conversions – for example, the values for at-risk nuclear generation in Table 4-

10 on page 108-109 of the state goals computation TSD are expressed in GWh, whereas the same 

data in the accompanying spreadsheet is expressed in MWh.

4. In some cases, the sums of 2012 generation data at the unit level in the egrid spreadsheet don’t 

match the sums presented in the state goals computation spreadsheet. We are trying to trace the 

source of these discrepancies. We recommend confirming all the generation and emissions data 

at the unit level and making sure the sums of these data match the inputs that were used to 

calculate the state goals in the rule proposal.

5. These step-by-step calculations follow the example in the Goal Computation TSD. In addition to 

sample calculations for Texas, the sample calculations for the state of Ohio are included since 

these were the example calculations presented in the TSD.

6. This is a work product of the Region 6 office and is not official 111(d) support documentation 

from EPA headquarters/OAQPS. This document was prepared for illustrative purposes to assist 

the Region 6 states in following the step-by-step calculations necessary to compute the individual 

state goals contained in the proposed 111(d) ESPS for power plants. 
Step 1: Calculation of Texas’ unadjusted 2012 fossil emission rate for affected sources

Data: Refer to the Excel file “20140602tsd-state-goal-data-computation” posted on EPA’s 111(d) website technical data page

Column:

A B C D E F G H I ---

Coal Rate

(lbs/MWh)

NGCC 

Rate

(lbs/MWh)

O/G Rate

(lbs/MWh)

Other 

Emissions

(lbs)

Hist Coal 

Gen

(MWh)

Hist NGCC 

Gen.

(MWh)

Historic 

OG Steam 

Gen.

(MWh)

Other Gen.

(MWh)

2012 Fossil 

Rate

(lbs/MWh)

Ohio 2,126 963 1,332 284,732,506 86,473,075 20,907,183 321,602 214,178 1,897

Texas 2,239 837 1,377 23,395,881,438 138,705,138 148,010,278 20,911,868 35,025,953 1,420

The documentation also refers to the 2012 Fossil Emission Rate as the “unadjusted fossil rate” and the “historical fossil emission rate.”

TX 2012 Fossil Rate = (∗)(∗)(∗)



TX 2012 Fossil Rate = (,∗,,)(∗,,)(,∗,,),,,

,,,,,,,,

TX 2012 Fossil Rate = 1,420 lbs/MWh
Step 2: BSER Block 1 – Adjustment to State rate goal resulting from thermal efficiency (heat rate improvement or HRI)

Data: Refer to the Excel file “20140602tsd-state-goal-data-computation” posted on EPA’s 111(d) website technical data page

Multiply the 2012 Coal Rate in Column B by 0.94 to obtain the 6 percent reduction resulting from thermal efficiency improvement:

Adjusted Coal Emissions Rate = 2,239 lbs/MWh * 0.94 = 2,104 lbs/MWh

TX 2012 Fossil RateBB1 = 

(∗)(∗)(∗)



TX 2012 Fossil Rate BB1 = 

(,∗,,)(∗,,)(,∗,,),,,

,,,,,,,,

TX 2012 Fossil Rate BB1 = 1,366 lbs/MWh

Column:

A B C D E F G H I ---

2012 Coal 

Rate * 0.94

(lbs/MWh)

NGCC 

Rate

(lbs/MWh)

O/G Rate

(lbs/MWh)

Other 

Emissions

(lbs)

Hist Coal 

Gen

(MWh)

Hist NGCC 

Gen.

(MWh)

Historic 

OG Steam 

Gen.

(MWh)

Other Gen.

(MWh)

2012 Fossil 

Rate 

Adjusted by 

Block 1

(lbs/MWh)

Ohio 1,999 963 1,332 284,732,506 86,473,075 20,907,183 321,602 214,178 1,795

Texas 2,104 837 1,377 23,395,881,438 138,705,138 148,010,278 20,911,868 35,025,953 1,366
Step 3: BSER Blocks 1 & 2 – Adjustment to State rate goal resulting from HRI and re-dispatch to existing and under construction NGCC

1. Calculate the NGCC 70% Ceiling Value. Obtain 2012 NGCC capacity value from Column J of the State Goal Computation spreadsheet 

and multiple by 8,784 (the total number of hours in CY 2012) and by a factor of 70%.

Ohio: 4,342.5 * 8,784 * 0.70 = 26,701,164 MWh at 70% capacity

Texas : 37,547.7 * 8,784 * 0.70 = 230,873,298 MWh at 70% capacity

2. Compare the NGCC 70% Ceiling Value calculated above to the sum of the State’s 2012 coal, OG steam, and NGCC net generation. 

If the NGCC 70% Ceiling Value is less than this sum, increase the NGCC generation to the Ceiling Value.

If the NGCC 70% Ceiling Value is greater than this sum, increase the NGCC generation to the sum of the 2012 fossil generation.

Ohio: 26,701,164 < (86,473,075 + 20,907,183 + 321,602), so Column G adjusted to 26,701,164

Texas : 230,873,298 < (138,705,138+148,010,278+20,911,868), so Column G adjusted to 230,873,298

3. Reduce the generation from coal and OG steam in Columns F and H proportionally by the amount that Column G is increased.

Ohio: 26,701,164 – 20,907,183 = 5,793,981 MWh 

This is the amount by which generation from coal and OG steam must be reduced.

% Coal Generation = 86,473,075/(86,473,075 + 321,602) = 99.63%

% OG Steam Gen. = 321,602/(86,473,075 + 321,602) = 0.37%

Adjusted Coal Generation = 86,473,075 – (0.9963 * 5,793,981) = 80,700,563

Adjusted OG Steam Gen. = 321,602 – (0.0037 * 5,793,981) = 300,133

Texas : 230,873,298 – 148,010,278 = 82,863,020 MWh

This is the amount by which generation from coal and OG steam must be reduced.

% Coal Generation = 138,705,138 /(138,705,138 + 20,911,868) = 86.90%

% OG Steam Gen. = 20,911,868/(138,705,138 + 20,911,868) = 13.10%

Adjusted Coal Generation = 138,705,138 – (0.8690 * 82,863,020) = 66,697,173 MWh

Adjusted OG Steam Gen. = 20,911,868 – (0.1310 * 82,863,020) = 10,056,812 MWh
Column: Step 3A

A B C D E F G H I ---

2012 Coal 

Rate * 0.94

(lbs/MWh)

NGCC 

Rate

(lbs/MWh)

O/G Rate

(lbs/MWh)

Other 

Emissions

(lbs)

Adjusted 

Coal Gen

(MWh)

Adjusted 

NGCC 

Gen.

(MWh)

Adjusted 

OG Steam 

Gen.

(MWh)

Other Gen.

(MWh)

2012 Fossil 

Rate 

Adjusted 

by Blocks

1&2

(lbs/MWh)

Ohio 1,999 963 1,332 284,732,506 80,700,563 26,701,164 300,133 214,178 1,739

Texas 2,104 837 1,377 23,395,881,438 66,697,173 230,873,298 10,056,812 35,025,953 1,082

NOW, add in the generation capacity resulting from 70% utilization of NGCC sources under construction in 2012:

Ohio: Identify the “under construction” value for NGCC in Column K of the State Goals Computation spreadsheet.

For Ohio, this value is 539 MW. The amount of this generation capacity that is considered available for re-dispatch

is calculated by multiplying it by 8,784 (the number of hours in CY 2012) and by a 15% capacity factor:

539 * 8,784 * 0.15 = 710,186 MWh

Total Adjusted NGCC Generation (Column G) = 26,701,164 + 710,186 = 27,411,350 MWh

Total Other Generation (Column I) = 214,178 + (539 * 8,784 * 0.55) = 214,178 + 2,604,016 = 2,818,195 MWh

The MWh associated with the 15% additional NGCC generation available for re-dispatch displaces coal and OG steam:

Adjusted Coal Generation = 80,700,563 – (0.9963 * 710,186) = 79,993,008 MWh

Adjusted OG Steam Gen. = 300,133 – (0.0037 * 710,186) = 297,502 MWh

Adjusted Other Emissions = 284,732,506 lbs + (963 lbs/MWh * 539 MW * 8784 hrs * 0.55) = 2,791,474,084 lbs/MWh

Adjusted 2012 Fossil Rate = (B*F + C*G + D*H + E) / (F + G + H + I) = 1,715 lbs/MWh

Texas: There are no “under construction” NGCC units identified in Texas. Therefore, no adjustments under this step.

Column: Step 3B

A B C D E F G H I ---

2012 Coal 

Rate * 0.94

(lbs/MWh)

NGCC 

Rate

(lbs/MWh)

O/G Rate

(lbs/MWh)

Other 

Emissions

(lbs)

Adjusted 

Coal Gen

(MWh)

Adjusted 

NGCC 

Gen.

(MWh)

Adjusted 

OG Steam 

Gen.

(MWh)

Other Gen.

(MWh)

2012 Fossil 

Rate 

Adjusted by 

Blocks 1&2

(lbs/MWh)

Ohio 1,999 963 1,332 2,791,474,084 79,993,008 27,411,350 297,502 2,818,195 1,715

Texas 2,104 837 1,377 23,395,881,438 66,697,173 230,873,298 10,056,812 35,025,953 1,082
Step 4: BSER Blocks 1, 2 & 3 – Adjustment to State rate goal resulting from HRI and re-dispatch to NGCC and nuclear & renewable

1. Determine the nuclear generation capacity that is defined as “under construction” or considered “at risk.” This value is specific to each 

state and is provided in Column T of the State Goals Computation spreadsheet. This number is added to the denominator in the Adjusted 

2012 Fossil Rate calculation.

Ohio: The under construction and at risk nuclear generation capacity in Column T is 993,077 MWh.

Adjusted 2012 Fossil Rate = (B*F + C*G + D*H + E) / (F + G + H + I + J) = 1,699 lbs/MWh

Texas: The under construction and at risk nuclear generation capacity in Column T is 2,291,006 MWh. 

Adjusted 2012 Fossil Rate = (B*F + C*G + D*H + E) / (F + G + H + I + J) = 1,075 lbs/MWh

Column: Step 4A

A B C D E F G H I J ---

2012 Coal 

Rate * 0.94

(lbs/MWh)

NGCC Rate

(lbs/MWh)

O/G Rate

(lbs/MWh)

Other 

Emissions

(lbs)

Adjusted 

Coal Gen

(MWh)

Adjusted 

NGCC Gen.

(MWh)

Adjusted 

OG Steam 

Gen.

(MWh)

Other Gen.

(MWh)

UC and 

AR

Nuclear 

Gen.

(MWh)

2012 Fossil 

Rate 

Adjusted by 

Blocks 1-3

(lbs/MWh)

Ohio 1,999 963 1,332 2,791,474,084 79,993,008 27,411,350 297,502 2,818,195 993,077 1,699

Texas 2,104 837 1,377 23,395,881,438 66,697,173 230,873,298 10,056,812 35,025,953 2,291,006 1,075
2. Determine the generation rate for existing and new renewable energy sources. For final state goal computations, use the value contained in

Column AD of the State Goals Computation spreadsheet for CY 2029 Existing and Incremental RE.

Ohio: The existing & incremental RE generation capacity in Column AD is 13,775,594 MWh. 

Adjusted 2012 Fossil Rate = (B*F + C*G + D*H + E) / (F + G + H + I + J + K) = 1,512 lbs/MWh

Texas: The existing & incremental RE generation capacity in Column AD is 85,962,502 MWh. 

Adjusted 2012 Fossil Rate = (B*F + C*G + D*H + E) / (F + G + H + I + J + K) = 861 lbs/MWh

Column: Step 4B

A B C D E F G H I J K ---

2012 Coal 

Rate * 0.94

(lbs/MWh)

NGCC Rate

(lbs/MWh)

O/G Rate

(lbs/MWh)

Other Emissions

(lbs)

Adjusted Coal 

Gen

(MWh)

Adjusted 

NGCC Gen.

(MWh)

Adjusted 

OG Steam 

Gen.

(MWh)

Other Gen.

(MWh)

UC and 

AR

Nuclear 

Gen.

(MWh)

RE

(MWh)

2012 

Fossil 

Rate 

Adjusted 

by 

Blocks 

1-3

(lbs/

MWh)

OH 1,999 963 1,332 2,791,474,084 79,993,008 27,411,350 297,502 2,818,195 993,077 13,775,594 1,512

TX 2,104 837 1,377 23,395,881,438 66,697,173 230,873,298 10,056,812 35,025,953 2,291,006 85,962,502 861
Step 5: BSER Blocks 1, 2, 3 & 4 – Adjustment to State rate goal resulting from Blocks 1 – 3 and Demand-Side Energy Efficiency

First, look up the 2012 historical retail sales and estimated energy efficiency savings for 2029 for your state and calculate avoided generation:

Ohio: 2012 Retail Sales = 152,456,864 MWh (source: www.eia.gov/electricity/data/state)

EE savings for 2029 = 11.57% (from Column AN of State Goals Computation spreadsheet)

Avoided Generation = 2012 Retail Sales * 2029 EE Savings * 1.0751 = (152,456,864)(0.115568306)(1.0751)

Avoided Generation = 18,942,382 MWh

Texas: 2012 Retail Sales = 365,104,131 MWh (source: www.eia.gov/electricity/data/state)

EE savings for 2029 = 9.9075% (from Column AN of State Goals Computation spreadsheet)

Avoided Generation = 2012 Retail Sales * 2029 EE Savings * 1.0751 = (365,104,131)(0.099075)(1.0751)

Avoided Generation = 38,889,261 MWh

Note: the product of 2012 Retail Sales * 1.0751 can be found in Column AP of the State Goals Computation spreadsheet

Next, multiply the avoided generation by your state’s share of sales coming from in-state power generation (Column AO in the spreadsheet):

Ohio: OH EE Avoided Generation = 18,942,382 * 0.8597 = 16,284,584 MWh

Texas: TX EE Avoided Generation = 38,889,261 * 0.9811686 = 38,156,922 MWh

The lesser of the Avoided Generation or the EE Avoided Generation value is added to the denominator and the Adjusted 2012 Fossil Rate 

recalculated once again:

Ohio: Adjusted 2012 Fossil Rate = (B*F + C*G + D*H + E) / (F + G + H + I + J + K + L) = 1,338 lbs/MWh

Texas: Adjusted 2012 Fossil Rate = (B*F + C*G + D*H + E) / (F + G + H + I + J + K + L) = 791 lbs/MWh

Column:

A B C D E F G H I J K L ---

2012 Coal 

Rate *

0.94

(lbs/MWh)

NGCC 

Rate

(lbs/MWh)

O/G Rate

(lbs/MWh)

Other 

Emissions

(lbs)

Adjusted 

Coal Gen

(MWh)

Adjusted 

NGCC 

Gen.

(MWh)

Adjusted 

OG Steam 

Gen.

(MWh)

Other Gen.

(MWh)

UC and 

AR 

Nuclear 

Gen.

(MWh)

RE

(MWh)

EE

(MWh)

2012 

Fossil 

Rate 

Adjusted 

by Blocks 

1- 4

(lbs/MWh)

OH 1,999 963 1,332 2,791,474,084 79,993,008 27,411,350 297,502 2,818,195 993,077 13,775,594 16,284,584 1,338

TX 2,104 837 1,377 23,395,881,438 66,697,173 230,873,298 10,056,812 35,025,953 2,291,006 85,962,502 38,156,922 791