## Development of FGD Costs and Loads Input Table - **Current FGD Systems**

No data
This Excel file contains the following worksheets:

Table of Contents Table of Systems Field List Current Wet FGD Sys. - Raw Data Planned Wet FGD Sys. - Raw Data SE Unit IDs SE_Operating_Unit Fuel Usage Coal Burned Type of Coal ST Capacity Electric Generation Cl_Concentrations Coal Burned per day All Current Sys. Coal and Purge Coal Burned and GPD by System Purge vs. Coal (Type of System) Log Purge vs. Coal (System) GPD per Ton of Bar (All) GPD per Ton Bar (All) Coal and GPD with Ox Type Purge vs Coal (Oxid Type) Coal and GPD with Coal Type Purge vs. Coal (Type of Coal) This Excel workbook documents the analyses conducted by EPA to find a methodology to estimate the FGD wastewater flow for current wet FGD systems that did not report a flow rate in the Steam Electric Survey.

The FGD input table holds the FGD wastewater flow generated by all plants discharging FGD wastewater to surface waters or a POTW. All plants currently discharging or planning to discharge wastewater by January 1, 2014 are included in this input table as all plants are included in the costs and loadings analysis. For plants identifying a current wet FGD system in the Steam Electric Survey, EPA took the FGD purge flow sent to treatment or discharbed from question B5-2 as the FGD wastewater flow to include in the FGD input table. For plants that did not report a flow rate, EPA needed to develop a methodology to estimate this flow. This file documents the various analyses conducted to determine specific plant characteristics that best correlated to FGD purge flow.

This worksheet lists all of the tabs and provides a short explanation of what information and data can be found on each. See this tab for further information on the tabs listed below. Key to Highlighted Cells Throughout File: Missing or Incomplete Data (Includes a -111 or -999) Data used in Costs MethodologyGPD per Ton with Coal Type

GPD per ton with Ox Type Purge and ST_Cap. ST Capacity vs. Purge (System) ST Cap. Vs Purge (Coal Type) Log ST Cap. Vs Purge (Coal) ST_Cap vs Purge (Oxid Type) Purge and Generation Generation vs Purge (System) Generation vs Purge (Coal Type) Generation vs. Purge (Oxid Type) Purge and Cl_Concentration Cl_Conc. Vs Purge (System) Cl_Conc vs Purge (Coal Type) Tons per day vs. Capacity Ton per day vs Cap. (Coal Type)This Excel workbook documents the analyses conducted by EPA to find a methodology to estimate the FGD wastewater flow for

The FGD input table holds the FGD wastewater flow generated by all plants discharging FGD wastewater to surface waters or a POTW. All plants currently discharging or planning to discharge wastewater by January 1, 2014 are included in this input table as all plants are included in the costs and loadings analysis. For plants identifying a current wet FGD system in the Steam Electric Survey, EPA took the FGD purge flow sent to treatment or discharbed from question B5-2 as the FGD wastewater flow to include in the FGD input table. For plants that did not report a flow rate, EPA needed to develop a methodology to estimate this flow. This file documents the various analyses conducted to determine specific plant characteristics that best correlated to FGD purge flow.

This worksheet lists all of the tabs and provides a short explanation of what information and data can be found on each. See this tab for further information on the tabs listed below.

Missing or Incomplete Data (Includes a -111 or -999)

## Tab Name

Table of Systems Field List Current Wet FGD Sys. - Raw Data Planned Wet FGD Sys. - Raw Data SE Unit IDs
SE_Operating_Unit Fuel Usage Coal Burned Type of Coal ST_Capacity Electric Generation Cl_Concentrations
All Current Sys. Coal and Purge Coal burned and GPD by System Purge vs. Coal (Type of System) Log Purge vs. Coal (System) GPD per Ton for Bar (All) GPD per Ton Bar (All) Coal and GPD with Ox Type Purge vs. Coal (Oxid Type) Coal and GPD with Coal Type Purge vs. Coal (Type of Coal) GPD per Ton with Coal Type GPD per Ton with Oxid Type
Purge and ST_Cap. ST Capacity vs. Purge (System) ST Cap. Vs. Purge (Coal Type) Log ST Cap. Vs. Purge (Coal) ST_Cap vs Purge (Oxid Type)
Purge and Generation Generation vs Purge (System) Generation vs Purge (Coal Type) Generation vs Purge (Oxid Typ)
Purge and Cl_Concentration Cl_Conc. Vs Purge (System) Cl_Conc. Vs Purge (Coal Type)

## Description

Table of current and planned wet FGD systems. List of table and field names used to analyze FGD scrubber purge flow. Raw data from the database for all current wet FGD systems. This table includes data from the FGD_Systems and FGD_Wet_Water_Gen tables of the database. Raw data from the database for all planned wet FGD systems. This table includes data from only the FGD_Systems table of the database. Data from the FGD_Systems table of the database, used to assign SE Unit IDs to each FGD system. all plant IDs identified as having an FGD system servicing SE Unit-1. Group 2 is all plant IDs identified as having an FGD system servicing SE Unit-2 and so on. Data from the Fuel Usage table in the database. This data is broken up based on SE Unit ID and includes amount and types of coal burned by each SE Unit. Calculates total coal burned per FGD system and determines what types of coal are burned by SE Unit within a given FGD System. Determines the type of coal burned on an FGD Unit basis. Determines the total steam turbine capacity for each FGD system, uses data from the SE_Operating_Unit table in the database. Determines the total 2009 electric generation for each FGD system, uses data from the SE_Operating_Unit table in the database. Raw data from the FGD_Wet_General table of the database with plant ID, FGD Unit ID and WFGD_bd_chlor_ppm. capacity, 2009 generation, oxidation type, absorber type, purge rate in gpd, and gpd/ton of coal values for each FGD system. Data table for scatter plot of Purge Rate vs. Amount of Coal Burned based on absorber type. Scatter plot of Purge Rate vs. Amount of Coal Burned based on absorber type. Scatter plot of Purge Rate vs. Amount of Coal Burned based on absorber type on a log scale. Data table for the bar graph of GPD of scrubber purge/ton of coal. Bar graph of GPD of scrubber purge/ton of coal. Data tables for scatter plot of Purge Rate vs. Amount of Coal Burned based on oxidation type. Scatter plot of Purge Rate vs. Amount of Coal Burned based on oxidation type. Data tables for scatter plot of Purge Rate vs. Amount of Coal Burned based on type of coal burned. Scatter plot of Purge Rate vs. Amount of Coal Burned based on type of coal burned. Data tables and bar graphs of GPD of scrubber purge/ton of coal based on type of coal burned. Data tables and bar graphs of GPD of scrubber purge/ton of coal based on type oxidation type. down the spreadsheet, the first set is broken into subsets based on absorber type. The second set is based on type of coal burned and the third set is based on oxidation type.) Scatter plot of Purge Rate vs. Steam Turbine Capacity based on absorber type. Scatter plot of Purge Rate vs. Steam Turbine Capacity based on type of coal burned. Scatter plot of Purge Rate vs. Steam Turbine Capacity based on type of coal burned on a log scale. Scatter plot of Purge Rate vs. Steam Turbine Capacity based on type of oxidation. down the spreadsheet, the first set is broken subsets based on absorber type. The second set is based on type of coal burned and the third set is based on oxidation type.) Scatter plot of Purge Rate vs. 2009 Electric Generation based on absorber type. Scatter plot of Purge Rate vs. 2009 Electric Generation based on type of coal burned. Scatter plot of Purge Rate vs. 2009 Electric Generation based on oxidation type. Scrolling down the spreadsheet, the first set is broken into subsets based on absorber type and the second set is based on type of coal burned.) Scatter plot of Purge Rate vs. Blowdown Chlorine concentrations based on absorber type. Scatter plot of Purge Rate vs. Blowdown Chlorine concentrations based on type of coal burned.Raw data from the database for all current wet FGD systems. This table includes data from the FGD_Systems and FGD_Wet_Water_Gen tables of the database. Raw data from the database for all planned wet FGD systems. This table includes data from only the FGD_Systems table of the database.

Data from the Fuel Usage table in the database. This data is broken up based on SE Unit ID and includes amount and types of coal burned by each SE Unit. Calculates total coal burned per FGD system and determines what types of coal are burned by SE Unit within a given FGD System.
Determines the total steam turbine capacity for each FGD system, uses data from the SE_Operating_Unit table in the database. Determines the total 2009 electric generation for each FGD system, uses data from the SE_Operating_Unit table in the database. Raw data from the FGD_Wet_General table of the database with plant ID, FGD Unit ID and WFGD_bd_chlor_ppm.No GPD or GPM Only

GPD Only GPM Both GPD and GPM **Total Number of Wet FGD Systems Reported 311**  Current Systems 263 46 8 4 205 Began operating sometime in 2009 36 3 0 0 33 Began operating sometime in 2010 19 1 0 0 18 Planned Systems 48 Online by 1/1/2014 33 Online after 1/1/2014 11 No Date 4

Yes No **Type of Oxidation (Wet FGD Systems only) 311**  59 50 Forced Oxidation Current 180 17 30 Planned 42 Inhibited Oxidation Current 33 20 10 Planned 1 Natural Oxidation Current 46 21 8 Planned 3 Not Applicable Current 4 1 2 Planned 0 No Answer Current 0 0 0 Planned 2 17 1 **Flow Data Available**

No Answer or Blank **Is a cementitious/pozzolanic material produced? (B4-15)** 

202

133 42

3

0 2 3

1 0**Table Name Field Name** 

FGD_Systems FGD_seunit (all) FGD_oxidation

FGD_slurry

FGD_Wet_Water_Gen WFGD_absorb_type WFGD_purge_WWTS_gpd WFGD_purge_WWTS_gpm

FGD_Wet_General WFGD_bd_chlor_ppm

Fuel_Usage fuel_coal_*_amt

SE_Units_Operating_ 2009_generation ST_capacity**Notes**

SE Unit ID identification Type of Oxidation (Forced, Natural, or Inhibited) Used to identify if the FGD System is a wet (answered "Yes") or dry (answered "No") system

Type of wet FGD absorber Scrubber purge flow rate in GPD Scrubber purge flow rate in GPM

Chloride concentration maintained less than - ppm

Used amount of each type of coal burned

The total unit electric generation in 2009 (MW-hrs). The steam turbine capacity (MW).

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to estimate FGD

**purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to estimate FGDplant_id FGD_id cbi_FGD_tbl FGD_online_date FGD_slurry

771 FGD-B FALSE5/1/2011 Yes 771 FGD-A FALSE 1/1/2012 Yes 1185 FGD-A FALSE7/1/2011 Yes 1185 FGD-B FALSE7/1/2011 Yes 1245 FGD-A FALSE 1/1/2013 Yes 1245 FGD-B FALSE 1/1/2012 Yes 1493 FGD-A FALSE4/1/2011 Yes 1634FGD-A FALSE6/1/2015 Yes 1634FGD-B FALSE6/1/2015 Yes 1674FGD-A FALSE 10/1/2010 Yes 2079 FGD-C FALSE4/1/2012 Yes 2079 FGD-A FALSE9/1/2010 Yes 2482 FGD-B FALSE5/1/2015 Yes 2482 FGD-A FALSE 12/1/2014 Yes 3095 FGD-A FALSE 10/1/2011 Yes 3265 FGD-A FALSE 1/1/2012 Yes 3709 FGD-A FALSE 12/1/2011 Yes 3709 FGD-B FALSE4/1/2012 Yes 3719 FGD-A FALSE6/1/2013 Yes 3719 FGD-B FALSE6/1/2013 Yes 4017 FGD-B FALSE 10/1/2014 Yes 4017 FGD-A FALSE4/1/2015 Yes 4533 FGD-A FALSE9/10/1899 Yes 4533 FGD-B FALSE9/10/1899 Yes 4679 FGD-A FALSE5/1/2011 Yes 5318 FGD-B FALSE 12:00:00 AM Yes 5318 FGD-A TRUE [Redacted] [Redacted] 5762 FGD-A FALSE 12/1/2014 Yes 5762 FGD-B FALSE 12/1/2013 Yes 6334FGD-B FALSE6/1/2012 Yes 6334FGD-A FALSE5/1/2011 Yes 6370 FGD-A FALSE 12/1/2014 Yes 6622 FGD-A FALSE 11/1/2011 Yes 7256 FGD-A FALSE4/1/2011 Yes 8013 FGD-A FALSE3/1/2011 Yes 8013 FGD-B FALSE3/1/2011 Yes 8179 FGD-D FALSE05/2012 Yes 8179 FGD-A FALSE01/2014 Yes 8179 FGD-C TRUE [Redacted] [Redacted] 8179 FGD-B FALSE05/2013 Yes 8902 FGD-A FALSE9/1/2010 Yes 8902 FGD-B FALSE9/1/2010 Yes 9161 FGD-A FALSE 1/1/2011 Yes 9166 FGD-A FALSE4/1/2011 Yes 9412 FGD-A FALSE 1/1/2014 Yes 9412 FGD-B FALSE 1/1/2016 Yes9948 FGD-A FALSE6/1/2010 Yes

9971 FGD-A TRUE [Redacted] [Redacted]FGD_oxidation FGD_type

Forced oxidation Jet bubbling reactor Forced oxidation Jet bubbling reactor Forced oxidation Spray/Tray Forced oxidation Spray/Tray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray Inhibited oxidation Spray/Tray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray/Tray Forced oxidation Jet bubbling reactor Forced oxidation Spray/Tray Forced oxidation Spray/Tray Forced oxidation Spray Forced oxidation Spray Natural oxidation Spray Natural oxidation Spray No Answer No Answer No Answer No Answer Forced oxidation Spray/Tray Forced oxidation Jet bubbling reactor [Redacted] [Redacted] Forced oxidation Jet bubbling reactor Forced oxidation Jet bubbling reactor Forced oxidation Spray Forced oxidation Spray Forced oxidation Jet bubbling reactor Forced oxidation Spray Forced oxidation Spray/Tray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray [Redacted] [Redacted] Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray Forced oxidation Spray/Tray Natural oxidation Spray Forced oxidation Spray Forced oxidation SprayForced oxidation Spray/Tray

[Redacted] [Redacted]

### All plant-level data has been removed from this tab as a result of CBI sanitization. All

**data used to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to estimate FGD purge flow is considered

**CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to estimate FGD purge flow is considered

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to estimate FGD purge flow is considered CBI or CBI deducible.

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to estimate FGD purge flow is considered CBI or CBI deducible.

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data

**used to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used

**to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All

**data used to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to

**estimate FGD purge flow is considered CBI or CBI deducible.***Same value reported for ST capacity and generation

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data

**used to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All

**data used to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used

**to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All

**data used to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data

**used to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used

**to estimate FGD purge flow is considered CBI or CBI deducible.**1731 FGD-1 Recirculation 4413600 Natural oxidation 173581

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data

**used to estimate FGD purge flow is considered CBI or CBI deducible.**Bituminous Coal Purge Rate per Amount of Coal Burned (GPD/Ton)

min 0.00116838

max 1.874427421 avg 0.214289769 median 0.145413952

Blend Coal Purge Rate per Amount of Coal Burned (GPD/Ton)

min 0.001527915

max 1.084905197 avg 0.150649057 median 0.101730087 

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to **estimate FGD purge flow is considered CBI or CBI deducible.**Lignite Coal Purge Rate per Amount of Coal Burned (GPD/Ton)

min 0.069664865

max 0.53609737 avg 0.224180519 median 0.231310015

Subbituminous Coal Purge Rate per Amount of Coal Burned (GPD/Ton)min 0.002030949

max 0.344909557 avg 0.071442372 median 0.039179797

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used

**to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to

**estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data used to

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data

**used to estimate FGD purge flow is considered CBI or CBI deducible.**

### All plant-level data has been removed from this tab as a result of CBI sanitization. All data

**used to estimate FGD purge flow is considered CBI or CBI deducible.**