EPA CoST Training Guide
EPA CoST Training Guide
5-02
EP-D-07-102
2030-0005
1
Prepared for:
David Misenheimer
U.S. Environmental Protection Agency
C439-02
Research Triangle Park, NC 27711
Prepared by:
Contents
Tables ............................................................................................................................................ iv
Figures ............................................................................................................................................ v
Acronyms ..................................................................................................................................... vii
1
Introduction......................................................................................................................... 1-1
UNC-EMAQ(5-02)-007.v2
ii
August 1, 2012
UNC-EMAQ(5-02)-007.v2
iii
August 1, 2012
Tables
Table 3-1. Columns on the Control Measure Manager................................................................ 3-5
Table 3-2. Components on the Summary Tab of the View Control Measure Window............. 3-12
Table 3-3. Components on the Control Measure View Efficiency Record Window ................ 3-16
Table 3-4. Components on the Control Measure Equations Tab ............................................... 3-20
Table 3-5. Components on the Control Measure View Efficiency Record Window ................ 3-22
Table 4-1. Summary of Strategy Algorithms ............................................................................... 4-3
Table 4-2. Key Columns of the Control Strategy Manager ....................................................... 4-11
Table 4-3. Tabs of the Edit Control Strategy Window .............................................................. 4-14
Table 4-4. Fields on the Control Strategy Summary Tab Automatically Set by CoST ............. 4-17
Table 4-5. Tabs of the Dataset Properties View and Edit Windows ......................................... 4-20
Table 4-6. Examples of Row Filters (Data Viewer window) and Inventory Filters
(Inventories tab of the Edit Control Strategy window) ........................................................ 4-23
Table 4-7. Constraints Common to Multiple Control Strategy Types ....................................... 4-29
Table 4-8. Excerpt from the gdplev Table Used to Convert Data between Cost Years ........... 4-51
Table 4-9. Columns in the Strategy Detailed Result.................................................................. 4-52
Table 4-10. Columns in the Strategy Measure Summary .......................................................... 4-57
Table 4-11. Columns in the Strategy County Summary ............................................................ 4-58
Table 4-12. Columns in the Strategy Messages Output ............................................................. 4-60
Table 4-13. Example of Strategy Messages Output................................................................... 4-61
Table 4-14. Example of Strategy Measure Summary Data ....................................................... 4-62
Table 4-15. Example of Strategy County Summary Data ......................................................... 4-62
Table 6-1. Examples of Row Filters (Data Viewer window) and Inventory Filters
(Inventories tab of the Edit Control Strategy window) .......................................................... 6-1
UNC-EMAQ(5-02)-007.v2
iv
August 1, 2012
Figures
Figure 2-1. CoST/EMF Client-Server System ............................................................................. 2-1
Figure 2-2. Installation Package Zip File Folder and File Structure............................................ 2-2
Figure 2-4. Login to the Emissions Modeling Framework Window ........................................ 2-11
Figure 2-5. Register New User Window................................................................................... 2-12
Figure 2-6. EMF Main Window ............................................................................................... 2-13
Figure 3-1. Manage Menu of EMF Main Window ...................................................................... 3-2
Figure 3-2. Control Measure Manager before Control Measures are Loaded ............................. 3-3
Figure 3-3. Control Measure Manager with Control Measures ................................................... 3-4
Figure 3-4. Control Measure Manager showing Control Measure Details .................................. 3-5
Figure 3-5. Filter Rows Dialog .................................................................................................... 3-7
Figure 3-6. Control Measure Manager with Filter Applied ......................................................... 3-8
Figure 3-7. Show/Hide Columns Dialog ..................................................................................... 3-9
Figure 3-8. Format Columns Dialog .......................................................................................... 3-10
Figure 3-9. Summary Tab of View Control Measure Window ................................................. 3-12
Figure 3-10. Efficiencies Tab of View Control Measure Window ............................................ 3-14
Figure 3-11. View Efficiency Record Window ......................................................................... 3-16
Figure 3-12. SCCs Tab of View Control Measure Window ...................................................... 3-19
Figure 3-13. Equations Tab of View Control Measure Window ............................................... 3-20
Figure 3-14. Properties Tab of View Control Measure Window............................................... 3-21
Figure 3-15. View Property Record Window ............................................................................ 3-22
Figure 3-16. References Tab of View Control Measure Window ............................................. 3-23
Figure 3-17. View Reference Record Window.......................................................................... 3-24
Figure 3-18. Summary Tab of Edit Control Measure Window ................................................. 3-26
Figure 3-19. Efficiencies Tab of Edit Control Measure Window .............................................. 3-28
Figure 3-20. Edit Efficiency Record Window ........................................................................... 3-29
Figure 3-21. SCCs Tab of Edit Control Measure Window ........................................................ 3-30
Figure 3-22. Select SCCs and Filter Rows Dialogs ................................................................... 3-31
Figure 3-23. Equations Tab of Edit Control Measure Window ................................................. 3-33
Figure 3-24. Properties Tab of Edit Control Measure Window................................................. 3-35
Figure 3-25. Edit Property Record Window .............................................................................. 3-36
Figure 3-26. References Tab of Edit Control Measure Window ............................................... 3-37
Figure 3-27. Edit Reference Record Window............................................................................ 3-38
Figure 3-28. Add Reference Record Window ........................................................................... 3-39
Figure 3-29. Exporting Control Measures Dialog ..................................................................... 3-43
UNC-EMAQ(5-02)-007.v2
August 1, 2012
UNC-EMAQ(5-02)-007.v2
vi
August 1, 2012
Acronyms
AQM ......................... Air Quality Model
CE ............................. Control Efficiency
CMAQ....................... Community Multiscale Air Quality model
CMAS ....................... Community Modeling and Analysis System
CoST ......................... Control Strategy Tool
CPT ........................... Cost per Ton
CRF ........................... Capital Recovery Factor
CSV ........................... Comma-separated values
DBF ........................... D-base Format
EC ............................. Elemental Carbon
EMF .......................... Emissions Modeling Framework
EPA ........................... Environmental Protection Agency
ESRI .......................... Environmental Systems Research Institute (creators of ArcGIS software)
FGD........................... Flue Gas Desulfurization
FGR ............................... Flue gas recirculation
UNC-EMAQ(5-02)-007.v2
vii
August 1, 2012
1 Introduction
This document provides a training manual and users guide for the Control Strategy Tool (CoST)
software developed by EPAs Health and Environmental Impacts Division (HEID). CoST allows
users to estimate the emission reductions and costs associated with future-year control scenarios,
and then to generate emission inventories with the control scenarios applied [Misenheimer, 2007;
Eyth, 2008]. CoST tracks information about control measures, their costs, and the types of
emissions sources to which they apply. The purpose of CoST is to support national- and
regional-scale multipollutant analyses. CoST helps to develop control strategies that match
control measures to emission sources using algorithms such as Maximum Emissions
Reduction (for both single- and multiple-target pollutants), Least Cost, and Apply Measures
in Series.
The result of a control strategy run contains information that specifies the estimated cost and
emissions reduction achieved for each control measure-source combination. CoST is an
engineering cost estimation tool for creating controlled inventories and is not currently intended
to model emissions trading strategies, nor is it an economic impact tool. Control strategy results
can be exported to comma-separated-values (CSV) files, Google Earth-compatible (.kmz) files,
or Shapefiles. The results can also be viewed in a graphical table that supports sorting, filtering,
and plotting. The Strategy Detailed Results from a strategy can also be merged with the original
inventory to create controlled emissions inventories datasets that can be exported to files that can
be input to the Sparse Matrix Operator Kernel Emissions (SMOKE) modeling system, which is
used by EPA to prepare emissions inputs for air quality modeling.
CoST is a component of the Emissions Modeling Framework (EMF), which is currently being
used by EPA to solve many of the long-standing complexities of emissions modeling [Houyoux,
2008]. Emissions modeling is the process by which emissions inventories and other related
information is converted to hourly, gridded, chemically speciated emissions estimates suitable
for input to an air quality model such as the Community Multiscale Air Quality (CMAQ) model.
The EMF supports the management and quality assurance of emissions inventories and
emissions modeling-related data, and also the running of SMOKE to develop CMAQ inputs.
Providing CoST as a tool integrated within the EMF facilitates a level of collaboration between
control strategy development and emissions inventory modeling that was not previously possible.
The concepts that have been added to the EMF for CoST are control measures and control
strategies. Control measures store information about available control technologies and
practices that reduce emissions, the source categories to which they apply, the expected control
efficiencies, and their estimated costs. A control strategy is a set of control measures applied to
emissions inventory sources (in addition to any controls that are already in place) to accomplish
an emissions reduction goal. These concepts are discussed in more detail later in this document.
CoST supports multipollutant analyses and data transparency, and provides a wide array of
options for developing control strategies. CoST uses a Control Measures Database to develop
control strategies, and provides a user interface to that database. CoST has been developed to
replace the older AirControlNET software. It has been applied to develop strategies for criteria
and hazardous air pollutants (HAPs). CoST has been used in some very limited analyses for
greenhouse gases (GHGs). The main limiting factors in performing GHG analyses is the
availability of (1) GHG emissions inventories at an appropriate level of detail, and (2) control
measures for GHGs.
UNC-EMAQ(5-02)-007.v2
1-1
August 1, 2012
CoST is an extensible software system that provides several types of algorithms for developing
control strategies:
The first four algorithms are typically used for point and area sources; the last one is usually used
for mobile sources, for which most control techniques are independent of one another.
This document provides information on how to use CoST to view and edit control measures and
how to develop control strategies. This includes how to specify the input parameters to control
strategies, how to run the strategies, and how to analyze the outputs from the strategies. For
additional information on other aspects of CoST, please see the following independent
documents:
Control Strategy Tool (CoST) Control Measures Database Documentation: describes the
contents of the Control Measures Database
Control Strategy Tool (CoST) Cost Equations Documentation: describes how CoST uses
control measure engineering cost equations
These documents, and additional information about CoST, can be found at: http://www.epa.gov/
ttn/ecas/cost.htm. A glossary of terms is included as an appendix to this document.
UNC-EMAQ(5-02)-007.v2
1-2
August 1, 2012
CoST/EMF Clients
CoST/EMF Server
Future
Base Case
Emission
Inventory
Control
Measures
Database
Detailed
and
Summary
Reports
Control
Strategy
Tool
Control
Case
Emission
Inventory
SMOKE
CMAQ
Compute Server
UNC-EMAQ(5-02)-007.v2
2-1
August 1, 2012
UNC-EMAQ(5-02)-007.v2
2-2
August 1, 2012
\postgresql - includes the PostgreSQL installation package and postgresql jdbc driver
\tomcat - includes the Tomcat installation package
Click Install to accept the license agreement and start the installation process.
UNC-EMAQ(5-02)-007.v2
2-3
August 1, 2012
The default location is sufficient, click Next to continue to the next step. Remember this
directory for later use in Step 2-6.
UNC-EMAQ(5-02)-007.v2
2-4
August 1, 2012
The default location is sufficient, click Next to continue to the next step.
For this step, make sure you use the password postgres. This password is expected
during a later step when installing the CoST database. Note, that your network
administrator could have password security restrictions. If this is the case, then use
a password that meets these restrictions. Remember this password for a later step
during the installation.
The default Port is sufficient, click Next to continue to the next step.
UNC-EMAQ(5-02)-007.v2
2-5
August 1, 2012
The default Locale is sufficient, click Next to continue to the next step.
UNC-EMAQ(5-02)-007.v2
2-6
August 1, 2012
When you reach the end, uncheck the Launch Stack Builder option and click Finish
The PostgreSQL database is now installed and ready for the CoST system database. This
database will be installed in a later step.
UNC-EMAQ(5-02)-007.v2
2-7
August 1, 2012
Expand the Tomcat option and check the Service Startup and Native components and
then click Next. Note by checking Service Startup, this important step will make sure
the application server is available on startup when the machine is rebooted.
The default settings are sufficient, click Next to continue to the next step
The default location is sufficient, click Next to continue to the next step.
UNC-EMAQ(5-02)-007.v2
2-8
August 1, 2012
The default location is sufficient, click Install to install the Tomcat web server.
Remember this folder for later use in Step 2-6.
Once the program files have been installed click Next to finalize installation process.
When you reach the end, click Finish. The Tomcat application server is now installed
and ready for the CoST system application. This CoST application will be installed in
the next step.
UNC-EMAQ(5-02)-007.v2
2-9
August 1, 2012
SET EMF_CLIENT_DIRECTORY=C:\EMF_State
SET EMF_DATA_DIRECTORY=C:\EMF_State_Data
SET POSTGRESDIR=C:\Program Files\PostgreSQL\9.1
SET TOMCAT_DIR=C:\Program Files\Apache Software Foundation\Tomcat 6.0
The EMF_CLIENT_DIRECTORY variable contains the location where the EMF client
application will be installed. This is the location where you will find the actual program
to run CoST.
The EMF_DATA_DIRECTORY variable contains the location where the EMF data files
(e.g., inventories and control measure import files) will be installed.
The POSTGRESDIR variable contains the location where the PostgreSQL application
was installed.
The TOMCAT_DIR variable contains the location where the Tomcat application was
installed.
7. Next, you will execute the batch file via the command prompt. For Windows 7 and
Vista, right click the command prompt and choose Run as administrator. For Windows
XP, run the command prompt through normal means. Go the root folder of the install
package.
C:\>cd C:\cost_software_installation_root_directotry
From there, execute the Install_EMF.bat by running the follow command:
C:\>C:\cost_software_installation_root_directotry>Install_EMF.bat
Note: This installation process can take around 30-40 minutes to finish. During the
installation process, you will be prompted once (see Figure below) to enter the
PostgreSQL superuser password, postgres. You will be prompted three times to enter
the emf user password, emf. The emf user password will be required when creating the
database, restoring the database backup, and when executing some SQL UPDATE
statements to the new database.
UNC-EMAQ(5-02)-007.v2
2-10
August 1, 2012
11. Next, go to the directory containing the EMF client application; this was specified in the
batch file via the EMF_CLIENT_DIRECTORY variable. Edit the EMFClient.bat batch
file to match your computers settings:
set EMF_HOME=Location of EMF client application (e.g., C:\EMF_State see
EMF_CLIENT_DIRECTORY environment from Step 6)
set JAVA_EXE= Location of Java runtime application (e.g., C:\Program Files\Java\jre6\bin\java, note
that the directory is C:\Program Files\Java\jre6\bin and java is the Java runtime application)
12. Run the client by double clicking on the bat file EMFClient.bat. Instead of the using the
default system login, we recommend creating a new user by clicking the Register New
User button as shown in Figure 2-4.
If you have never used the EMF before, click the Register New User button. You will then see a
window that looks like Figure 2-5.
UNC-EMAQ(5-02)-007.v2
2-11
August 1, 2012
In the Register New User window, fill in your full name, affiliation, phone number, and email
address. You may then select a username with at least three characters and enter a password with
at least 8 characters and at least one digit and then click OK. Once your account has been
created, the EMF main window should appear (Figure 2-6).
If instead you are an existing EMF user, enter your EMF username and password in the Login
to the Emissions Modeling Framework window and click Log In. The EMF main window
should appear (Figure 2-6).
Note: The administrator EMF login name is admin, with a password admin12345.
UNC-EMAQ(5-02)-007.v2
2-12
August 1, 2012
UNC-EMAQ(5-02)-007.v2
2-13
August 1, 2012
Shows minimum, maximum, and average control efficiency, cost per ton (based on year
2006 values), and average rule effectiveness and rule penetration
Displays other control measure attributes (e.g., abbreviation, major pollutant, source
group, equipment life, sectors, class)
Allows import of control measure information into the system from CSV files
View, sort, and filter a list of control measures from the Control Measure Manager
window
View the detailed data available for a control measure, including control efficiencies,
SCCs, cost equations, and properties
Filter and display cost and control efficiency information for major and co-benefit
pollutants of the measures
UNC-EMAQ(5-02)-007.v2
3-1
August 1, 2012
This section is presented as a series of steps so that it can be used as part of a training class
or tutorial on how to use CoST.
Notice the different parts of the Control Measure Manager window. There is a Pollutant
Filter at the top, along with a Show Details checkbox and a Refresh button. Below those
buttons is a toolbar full of buttons that operate on the data shown in the table below the
toolbar, which is currently empty. There is also a distinct set of buttons and pull-down
menus below the table. The functions of all of these buttons will be discussed in the
coming sections.
UNC-EMAQ(5-02)-007.v2
3-2
August 1, 2012
Figure 3-2. Control Measure Manager before Control Measures are Loaded
2. To show some of the control measures from the database in the table, select a pollutant
from the Pollutant Filter pull-down menu at the upper left corner of the Control Measure
Manager (for the training, click on the down arrow and use the scroll bar to find and
select PM10). Information about any control measures that control the selected pollutant
will appear in the window (Figure 3-3). At this point, only the control measure name,
abbreviation, pollutant, and sector are shown in the manager window. Note that name
of each control measure must be unique within the database, and that the control
measures appear in a table in which the data can be sorted and filtered.
The abbreviation is a set of characters that is a short-hand for the control measure.
Typically, the abbreviation should express the name of the control measure in an
abbreviated form such that if someone is familiar with the abbreviation conventions, the
person might be able to infer the name of the measure. Typically the first character of the
measure denotes the major pollutant (e.g., P for PM controls, N for NOx controls,
S for SO2 controls). The next few characters usually denote the control technology (e.g.,
ESP for Electrostatic Precipitator, FFM for fabric filter mechanical shaker).
Abbreviations must be unique within the database (i.e., no two control measures can use
the same abbreviation).
UNC-EMAQ(5-02)-007.v2
3-3
August 1, 2012
3. To see more information about the measures, check the Show Details checkbox
additional columns will appear on the right of the table. An example is shown in Figure
3-4.
4. To better see the additional columns, you can make the Name column narrower by
positioning your mouse on the line between Name and Abbreviation on the table
header this will cause a special mouse pointer with arrows to appear and you can then
drag your mouse to make the Name column narrower.
UNC-EMAQ(5-02)-007.v2
3-4
August 1, 2012
5. Scroll to the right and examine the columns that are available in the Control Measure
Manager for future reference. Note that you may move the columns around by grabbing
the columns header with your mouse and dragging them. You may also change their
widths as desired. You can resize the Control Measure Manager window within the EMF
Main Window as desired, such as to make the entire window wider so that you can see
more columns.
6. After you scroll to the right a bit, hover your mouse over one of the columns other
than Name, you will see that the name of the measure corresponding to the row you are
on will appear briefly as a tooltip. This is so that you can tell what the name of the
measure is even if has scrolled off the window.
The columns shown on the Control Measure Manager with brief descriptions are shown in
Table 3-1. The table that shows the control measures allows the user to sort and filter
the data. Tables of this same type are used many places throughout CoST and the EMF.
Table 3-1. Columns on the Control Measure Manager
Column Name
Description
Select
This column will allow the user to view, edit, or copy the measure by
clicking the corresponding button at the bottom of the manager
window. These features will be discussed later in the training.
Name
Abbreviation
UNC-EMAQ(5-02)-007.v2
3-5
August 1, 2012
Column Name
Description
Pollutant
A pollutant (e.g., NOx, PM10) that the measure might control. Note
that any pollutant-specific information in the row is for this pollutant.
Maximum, minimum, and average cost per ton for the specified
pollutant aggregated across all locales, effective dates, and source
sizes.
Control
Technology
The control technology that is used for the measure (e.g., Low NOx
burner, Onroad Retrofit).
Source Group
Equipment Life
Expected lifetime (in years) of the equipment used for the measure.
Sectors
Class
The class of the measure. Options are Known (i.e., already in use),
Emerging (i.e., realistic, but in an experimental phase), Hypothetical
(i.e., the specified data are hypothetical), and Obsolete (i.e., no longer
in use).
Last Modified
Time
The date and time on which the information about the measure was
last modified in the editor or imported from a file.
Last Modified By
Date Reviewed
The date on which the data for the measure were last reviewed.
Creator
The user that created the measure (either from the import process or
by adding it via the New button).
Data Source
Description
UNC-EMAQ(5-02)-007.v2
3-6
August 1, 2012
7. To sort based on data in one of the columns, click on the column header. For example, to
sort based on the average control efficiency of the measure, first you may want to make
the Name column narrower so that the column labeled Avg CE comes into view on
the window, and then click on the column header for the Avg CE column. The table
will now be sorted by the values of Avg CE in descending order. Notice that
information about the currently specified sort is reflected in the line just under the
horizontal scrollbar for the table.
8. If you click on the header of a column (e.g., Avg CE) a second time, the sort order will
be reversed.
9. To perform a multicolumn sort, click the sort button
and then click Add to add an
additional column to sort by (e.g., Name). Notice that you can control whether the sort is
Ascending and whether it is Case Sensitive. Click OK once you have made your
selection. The data should now be sort according to the column(s) you specified.
10. To use a filter to limit the measures shown, click the button on the toolbar that looks
like a filter:
. When you do this the Filter Rows dialog appears (Figure 3-5).
11. To add a second criterion click Add Criteria again on the Filter Rows dialog (e.g., enter
Avg CE > 80). Note that if Match using is set to ALL criteria then only rows that
match all the specified criteria will be shown in the table after you click OK. If Match
UNC-EMAQ(5-02)-007.v2
3-7
August 1, 2012
using is set to ANY criteria, then rows will be shown in the table if they meet any of the
criteria that are listed.
12. Click OK to close the Filter Rows dialog and to apply the selected filter. Figure 3-6
shows the table that results from the selections shown in Figure 3-5. Notice that the
currently applied filter is reflected in the line under the horizontal scrollbar of the table.
Figure 3-6. Control Measure Manager with Filter Applied
13. Open the filter dialog again by clicking the Filter rows button. Set Match using to ANY
criteria and then click OK to see what effect it has on the measures shown. Hint: you
should see more measures than when Match using is set to ALL criteria.
14. Open the filter dialog again by clicking the Filter rows button. Remove one of criteria by
clicking somewhere in one of the rows shown on the Filter Dialog and then clicking
Delete Criteria. Now click OK to have the less stringent filter take effect.
15. To select all of the control measures that meet your filter criteria, click the Select All
button on the toolbar:
. You will see that the checkboxes in the Select column are
now all filled with checks. You may select or deselect individual measures by clicking
their checkboxes in the Select column. In the next subsection, we will discuss operations
that can be performed on selected measures, such as viewing them and exporting their
data.
16. To unselect all of the measures, click the Clear all the selections button:
see that all of the checks in the Select column are now removed.
UNC-EMAQ(5-02)-007.v2
3-8
August 1, 2012
17. To hide some of the columns that are shown in the table, click the Show/Hide columns
button:
. On the Show/Hide Columns dialog that appears (similar to the one shown in
Figure 3-7), uncheck some of the checkboxes in the Show? column and then click OK.
The columns you unchecked will no longer be seen in the table.
Figure 3-7. Show/Hide Columns Dialog
18. Click the Show/Hide columns button again and scroll down through the list of columns
at the top of the dialog to see others that are farther down the list. Select multiple columns
to show or hide by clicking on the first column name of interest, then holding down
the shift key, then clicking a second column name to select the intervening columns,
and then clicking the Show button or the Hide button to either show or hide those
columns.
UNC-EMAQ(5-02)-007.v2
3-9
August 1, 2012
If you want to select columns that are not next to each other, you can hold down the
control key when you click your mouse, then when you are finished selecting click Show
or Hide. The remaining buttons on the dialog are not used frequently: (a) Invert will
invert the selection of highlighted columns. (b) The Filter section at the bottom can be
used to locate columns when there are hundreds of column names, but there are no tables
that large used in CoST.
19. Click the Format columns button,
, to open the Format columns dialog and examine
the options for controlling how data in the table are shown. For example, check the
checkboxes in the Format? column for one or more of the column names Avg CE,
Min CE, and Max CE (note that you may first need to unhide the columns if you
hid them in the previous step). Because these columns are all numeric, some controls
used to format numbers will appear in the lower right corner.
Next, change the Font to Arial, the Style to Bold, the Size to 14, the Horizontal
Alignment to Left, the Text Color to blue, the Column Width to 60, and the number
of Decimal Places to 0, and select significant digits. Once you have made all of your
selections, your dialog should look similar to the one in Figure 3-8; if so, click OK. The
columns that you had selected for formatting will have the attributes you specified on the
Format Columns dialog. In practice, this dialog is not used very often, but it can be
particularly helpful to format numeric data by changing the number of decimal places or
the number of significant digits shown.
Figure 3-8. Format Columns Dialog
UNC-EMAQ(5-02)-007.v2
3-10
August 1, 2012
20. To remove the specified sort, the row and column filters, and the formatting, click the
Reset button:
21. If you are unsure of what a button does when using CoST, place your cursor over the
button and wait; in many cases, a small piece of text called a tooltip will appear. For
example, place your cursor over one of the buttons on the toolbar and hold it still.
You will see a tooltip describing what the button does. Many of the buttons and fields
used in CoST have tooltips to clarify what they do or what type of data should be entered.
22. If you wish to retrieve an updated set of control measures data from the server, click the
Refresh button at the upper right portion of the Control Measure Manager. Note that this
will also reset any special formatting that you have specified, but any sort and filter
settings will be preserved.
UNC-EMAQ(5-02)-007.v2
3-11
August 1, 2012
Creator
UNC-EMAQ(5-02)-007.v2
Description
A unique name that typically includes both the control technology used
and the group of sources to which the measure applies.
A description of the applicability of the measure and any other relevant
information.
A 10-character unique abbreviation that is used to assign the control
measure to sources in the inventory. Ideally, the abbreviation should be
somewhat readable so that the user has some idea of what type of
measure it is from reading the abbreviation (e.g., the DESP in
PDESPIBCL is short for Dry Electrostatic Precipitator, the IB is short
for Industrial Boiler, and the CL is short for Coal).
The name of the user who imported or created the measure.
3-12
August 1, 2012
Component
Last Modified
Time
Last Modified
By
Major
Pollutant
Control
Technology
Source Group
NEI Device
Code
Class
Equipment
Life
Date
Reviewed
Sectors
Months
Description
The date and time on which the information about the measure was last
modified in the editor or imported from a file.
The last user to modify the measure.
The pollutant most controlled by the measure. This is used to group the
measures only, and has no impact on how the measure is assigned to
sources.
The control technology that is used for the measure (e.g., Low NOx
burner). You can type a new entry into this field and then choose it from
the pull-down menu in the future.
The group of sources to which the measure applies (e.g., Fabricated
Metal Products Welding). You can type a new entry into this field and
then choose it from the pull-down menu in the future.
The numeric code used in the NEI to indicate that the measure has been
applied to a source. A cross-reference table to match the control measure
abbreviations and NEI Device Codes to one another may be created.
The class of the measure. Options are Known (i.e., already in use),
Emerging (i.e., realistic, but in an experimental phase), Hypothetical (i.e.,
the specified data are hypothetical), Obsolete (i.e., no longer in use), and
Temporary (i.e., the specified data are temporary and should be used
only for testing purposes).
The expected life of the control measure equipment, in years.
The date on which the data for the measure were last reviewed.
An emissions modeling sector or set of emissions modeling sectors to
which the measure applies. A sector represents a broad group of similar
emissions sources.
The month(s) of the year to which the control measure is applicable. This
is either All Months or a list of individual months (e.g., March, April,
and May for measures applicable only in spring months).
25. When viewing a control measure (as opposed to editing a control measure), you cannot
make changes to any of the selections. However, you can review the available selections
for some fields. Click the arrows next to the fields Major Pollutant, Control
Technology, Source Group, and Class to see the available options for each of these
fields. Note that if you make a selection that differs from the original value on one of
these menus, the new value will not be saved when you close the window because you
are only viewing the measure data.
UNC-EMAQ(5-02)-007.v2
3-13
August 1, 2012
The Row Limit and Row Filter fields are helpful when there are hundreds or thousands of
efficiency records (e.g., some data may be county specific and available for multiple
pollutants). The Row Limit is the maximum number of records that will be displayed on the
page. For example, if there were thousands of records, it could take a long time to transfer all
UNC-EMAQ(5-02)-007.v2
3-14
August 1, 2012
of those data from the server, so by default only 100 records will be transferred if the Row
Limit is set to 100.
27. To see how the Row Filter works, enter Pollutant=PM10 into the text field and then
click Apply. You will see only the record for PM10. These filters follow the syntax that
can be used in a Structured Query Language (SQL) WHERE clause. Note that the filter
may not seem necessary in this particular example that only has a few records, but if this
measure had entries for every county and pollutant as some mobile measure may have,
then the filter can be very helpful to wade through all the records. If desired, you may try
some other filters with this measure, such as:
Pollutant like 'PM%', Pollutant='PM10', or
Control Efficiency > 95.
Here are some examples of other types of filters that you may find useful that illustrate
other aspects of the syntax, although they may not all be applicable to this particular
measure:
28. To see the data for an efficiency record in their own window: In the Select column,
check the checkbox for the PM2_5 efficiency record and click View. A View
Efficiency Record window will appear (Figure 3-11). The fields of the efficiency record
are shown in Table 3-3.
Notice that most of the fields in Figure 3-11 are set using text fields. The Ref Yr Cost
Per Ton Reduced is shown with a label because this value is automatically computed
for the reference year (currently 2006) according to the cost year and the specified Cost
Per Ton Reduced. Note that the cost per ton reduced should take into account the
specified rule effectiveness and rule penetration, which dilute the effectiveness of the
control measure, but are not taken into account when the Ref Yr Cost Per Ton Reduced
is computed. Other fields that are labels are Last Modified By and Last Modified
Time. These fields are automatically updated and tracked by CoST when someone edits
the efficiency record, although editing is done from the Edit Efficiency Record window
instead of the View Efficiency Record window.
Note: The efficiency records must be unique according to the contents of the
following fields: Pollutant, Locale, Effective Date, Minimum Emissions, Maximum
Emissions, and Existing Measure Abbreviation. This means that two records cannot have
the same values for all of these fields.
UNC-EMAQ(5-02)-007.v2
3-15
August 1, 2012
Table 3-3. Components on the Control Measure View Efficiency Record Window
Component
Pollutant
Locale
Effective
Date
UNC-EMAQ(5-02)-007.v2
Description
The pollutant for which this record applies (emissions are either
decreased or increased). An asterisk appears beside this field because a
value for it must be specified.
A two-digit FIPS state code, or a five-digit FIPS county code, to denote
that the information on the row is relevant only for a particular state or
county. If left blank, it is assumed to apply to all states and counties.
The month, day, and year on which the record becomes effective. The
system will find the record with the closest effective date that is less than
or equal to the date of the analysis. If this is left blank, the record is
assumed to apply to any date.
3-16
August 1, 2012
Component
Existing
Measure
Abbreviation
Existing NEI
Device Code
Cost Year
Cost per Ton
Reduced
Capital to
Annual Ratio
Ref Yr Cost
per Ton
Reduced
Control
Efficiency
Minimum
Emissions
Maximum
Emissions
Rule
Effectiveness
Rule
Penetration
Equation
Type
UNC-EMAQ(5-02)-007.v2
Description
This field should be populated when the data on the row are provided,
assuming that a control measure has already been applied to the source.
The contents of the field should be the control measure abbreviation that
corresponds to the existing measure. The reason for this field is that the
efficiency of and cost of applying the measure may vary when there is
already a control measure installed on a source.
This is used in conjunction with Existing Measure and should specify the
device code used in the NEI that corresponds to the currently installed
device.
The year for which the cost data are provided.
The cost to reduce each ton of the specified pollutant.
The ratio of capital costs to annual costs. Applicable only for equationbased annualized costs.
The cost per ton to reduce the pollutant in 2006 dollars.
3-17
August 1, 2012
Component
Capital
Recovery
Factor
Discount
Rate
Incremental
CPT
Last
Modified By
Last
Modified
Time
Details
Description
The capital recovery factor to use. Applicable only for equation-based
annualized costs.
The discount rate used to compute the capital recovery factor. Applicable
only for equation-based annualized costs.
The cost to reduce a ton of the specified pollutant, when applied on top of
an existing measure at an emissions source.
The last user to modify the efficiency record.
The last date and time a user modified the efficiency record.
Text that specifies information about the source of data for this row or
reason they were changed.
29. When you are done examining the information on the View Efficiency Record Window,
click Close.
UNC-EMAQ(5-02)-007.v2
3-18
August 1, 2012
31. When you are finished examining the SCCs the measure can apply to, click Close.
UNC-EMAQ(5-02)-007.v2
3-19
August 1, 2012
UNC-EMAQ(5-02)-007.v2
Description
The name of the engineering cost equation type (e.g., Type 8).
The description of the engineering cost equation type (e.g., Non-EGU
PM Cost Equation).
The input parameters to the cost equations found in the inventory (e.g.,
stack velocity and temperature or design capacity).
The cost equation definitions.
3-20
August 1, 2012
35. To see the data for a property record in their own window: In the Select column,
check the checkbox for the STEAM_PCT property record and click View. A View
Property Record window will appear (Figure 3-15). The fields of the property record are
shown in Table 3-5.
Notice that most of the fields in Figure 3-15 are set using text fields. The Category is a
free-form drop down, where an existing category could be used or a new one could be
used by typing in the new category.
UNC-EMAQ(5-02)-007.v2
3-21
August 1, 2012
When you are done examining the information on the View Property Record Window,
click Close.
Figure 3-15. View Property Record Window
Table 3-5. Components on the Control Measure View Efficiency Record Window
Component
Name
Category
Units
Data Type
DB Field
Name
Description
The name of the property.
The category for the property (e.g., AirControlNET Properties, Cost
Properties, or Control Efficiency Properties).
The units for the property (e.g., % for percentage).
If applicable, this defines the data type of the property (e.g., double precision/float for numeric values, or a varchar/string for textual information).
If specified, this is a placeholder to help identify the database field name
from the particular data source reference that supplied the property
information (e.g., an ancillary dataset has a steam percentage stored in the
STEAM_PCT table field/column).
UNC-EMAQ(5-02)-007.v2
3-22
August 1, 2012
Component
Value
Description
The value of the property.
37. To see the data for a reference record in their own window: In the Select column,
check the checkbox for the first reference record and click View. A View Reference
Record window will appear (Figure 3-17). Notice that only field in Figure 3-17 is the
actual source/reference description that can be entered into a text field.
When you are done examining the information on the View Reference Record Window,
click Close.
UNC-EMAQ(5-02)-007.v2
3-23
August 1, 2012
UNC-EMAQ(5-02)-007.v2
3-24
August 1, 2012
42. If you wish, you may view the contents of your new measure at this time by selecting it
and clicking the View button, but we will edit the data for the new measure in the next
section, so you may not need to view it now.
UNC-EMAQ(5-02)-007.v2
3-25
August 1, 2012
44. Change the Name of the newly created measure to reflect the name of the new measure
you intended to create (e.g., you might change the part of the name that deals with the
affected sources, such as Selective Non-Catalytic Reduction; ICI Boilers - Natural
Gas and Oil). Recall that measure names must be unique.
45. When the measure was copied, the abbreviation was set to a number that was known to
be unique so that it could be saved in the database. At this point, you should replace the
automatically generated Abbreviation for the new measure with one that has some
meaning to you (e.g., NSNCRIBNGO). Try to follow a similar naming convention as
the other measures, but your new abbreviation must be unique in the database.
46. Edit the fields of the measure as desired. For training purposes, change the
Equipment Life to 10, and the Date Reviewed to todays date, set the Class to
Emerging, and make any other changes you wish, such as entering a more detailed
Description.
47. Next click the Add button under the Sectors list to add another sector for the measure.
For example, from the Select Sectors dialog, choose ptipm (i.e., point sources handled by
the Integrated Planning Model) and click OK. You will then see the new sector added to
UNC-EMAQ(5-02)-007.v2
3-26
August 1, 2012
the list of applicable sectors. Note that the sectors listed here are informational only; they
do not affect the use of the measure in control strategies in any way.
48. To remove a sector, click on the sector in the list and click Remove and it will no longer
appear on the list.
49. Adding and removing Months works similarly to adding and removing sectors. For
training purposes, specify some specific months to which the measure should apply (e.g.,
March, April, and May).
Note: the feature of setting specific months for which a measure applies is effective
when you are applying measures to monthly emission inventories. Specifying
months in this way is not effective when you are applying measures to annual
emission inventories.
50. To set the months back to All Months, select all of the months in the Months list by
clicking on the first month and then going to the last month and doing shift-click with
your mouse. Then click Remove.
51. Option to discard your changes: Now that you have changed information for the
measure, notice that an asterisk (*) appears after the measure name in the title for the
window. This means that CoST is aware that you have made changes. If you try to Close
a window on which you have made changes to the data without saving it, CoST will ask
you Would you like to discard the changes and close the current window? If you want
to discard (i.e., undo) ALL of the changes made since you started editing the measure,
click Yes. If you prefer to not to close the window so that your changes stay in-tact, click
No. For training purposes, click No.
UNC-EMAQ(5-02)-007.v2
3-27
August 1, 2012
53. Scroll to the right to examine additional fields on the window. Note that more of the
fields are filled in than we saw for the PM measure that we examined in Section 3.2. The
additional data allow CoST to compute the capital and operating and maintenance
(O&M) costs in addition to overall annualized costs when this measure is used in a
control strategy.
54. To edit an efficiency record, check the corresponding checkbox in the Select column and
then click Edit. The Edit Efficiency Record window will appear (Figure 3-20).
UNC-EMAQ(5-02)-007.v2
3-28
August 1, 2012
55. You can edit the values for the efficiency record as needed to reflect your new control
measure. For training purposes, enter 5000 as the value for Maximum Emissions, then
click Save. Notice that this value has been updated in the table in the Edit Control
Measure window. This means that the record will apply only to sources that emit between
25 and 5000 tons of NOx each year.
56. To add a new efficiency record, click Add. You will need to fill in the appropriate values
in the Add Efficiency Record window that appears. For training purposes, select CO2 as
the pollutant. Specify 06 as the Locale, 01/01/2015 as the Effective Date, and 10 as the
control efficiency. When you are finished, click Save. A new row should appear in the
table in the Edit Control Measure window. The effect of adding this record is to note that
there is a 10% reduction to CO2 when this control measure is applied, but only in
California (FIPS=06) starting on 01/01/2015.
57. To remove one or more efficiency records, click the corresponding checkboxes and then
click Remove to remove those records. For training purposes, click the checkbox in the
Select column for the record for CO2 that you just added. Next, click Remove to
remove that record. When ask to confirm if you are sure you want to remove the selected
record, click Yes. The record should disappear from the table.
When costs are specified for multiple efficiency records: If you have cost per ton values
specified for multiple efficiency records, they are additive when they are used in a control
strategy. For example, if a CPT is specified for both NOx and VOC for a measure, the total
UNC-EMAQ(5-02)-007.v2
3-29
August 1, 2012
cost of applying the measure is the sum of (1) the cost per ton for NOx times the NOx
emissions reduced and (2) the cost per ton for VOC times the VOC emissions reduced.
59. To add some new SCCs, click the Add button. A Select SCCs dialog similar to the one
shown in the background of Figure 3-22 will appear. Note that prior to filtering down the
list of SCCs (which we will do starting in the next step), there are over 11,500 possible
SCCs. This number of available SCCs can be found in the lower left hand corner of the
Select SCCs dialog.
60. To filter the SCCs on the Select SCCs dialog down to the more relevant ones, click the
Filter Rows button on the toolbar. For training purposes, in the Filter Rows dialog that
appears, click Add Criteria three times, enter the following criteria, then click OK:
UNC-EMAQ(5-02)-007.v2
3-30
August 1, 2012
61. At this point, in the Select SCCs window you should see only the SCCs that met your
criteria, such as the 13 SCCs shown in Figure 3-22. Many of these SCCs are already
associated with the measure (i.e., they are already shown on the SCCs tab of the Edit
Control Measure window in Figure 3-21), but apparently additional SCCs (i.e., the ones
starting with 101 and 105) may also be relevant for this measure.
Click the checkbox in the Select column for the SCCs you wish to add to the
measure (e.g., for training purposes 10100601) and then click OK. Now you will see
that the SCC is added to the list of applicable SCCs for the measure in the Edit Control
Measure window. If you had selected multiple SCCs, they all would have been added to
the Edit Control Measure window (if they were not already there). Note: If you select an
SCC to add that was already on the SCCs tab, it will not cause any problems and it will
not add the SCC for a second time.
UNC-EMAQ(5-02)-007.v2
3-31
August 1, 2012
Hints for adding groups of SCCs: If you need to add a lot of SCCs and are able to specify a
filter on the Select SCCs dialog that results in only the SCCs that are appropriate for the
control measure being shown, you could enter the filter and then click the Select All button
on the toolbar to select all of those SCCs at once. Then, when you clicked OK, all of the
SCCs would be added to the SCCs tab for the measure. This keeps you from having to click
all of the individual Select checkboxes. Alternatively, if most but not all of the SCCs were
appropriate, you could select all of them and then click on a few checkboxes to deselect the
ones that were not needed and then click OK to add only the ones that remained selected.
UNC-EMAQ(5-02)-007.v2
3-32
August 1, 2012
63. To remove equation information, click the Remove button. You will see a dialog that
says Are you sure you want to remove the equation information? So that you can see
how removing and resetting equation information works using the copied version of the
measure, click Yes. You will then see all of the equation information removed from the
Equations tab.
64. To add equation information to the measure, click the Add button on the Equations tab.
You will see a Select Equation Type dialog. Click the pull-down menu to see the
available types of equationsthere are at least eight different types and select the desired
equation type. For training purposes, select Type 1 EGU. You will see that there are
eight variables for this equation type. Note that the variables differ somewhat from the
variables for the Type 13 equation shown in Figure 3-23, and that the Type 1 equation is
UNC-EMAQ(5-02)-007.v2
3-33
August 1, 2012
UNC-EMAQ(5-02)-007.v2
3-34
August 1, 2012
68. To edit a property record, scroll down to the COST_BASIS property, and check the
corresponding checkbox in the Select column for the COST_BASIS property and then
click Edit. The Edit Property Record window will appear (Figure 3-25). Notice that the
data type is a string, which means the property will contain textual information about the
measure. Notice also how the value field contains detailed information about the
methodologies used for costing this control measure.
UNC-EMAQ(5-02)-007.v2
3-35
August 1, 2012
69. You can edit the value for the property record as needed to reflect your new control
measure. For training purposes, add some additional text to the Value, then click Save.
70. To add a new property record, click Add in the Properties tab. You will need to fill in
the appropriate values in the Add Property Record window that appears. For training
purposes, select No category as the Category. Specify POWER_LOSS for the Name,
MW/hr for the Units, numeric for the Data Type, POWER_LOSS for the DB Field
Name, and 5 as the Value. When you are finished, click Save. A new row should appear
in the table in the Edit Control Measure window.
71. To remove one or more property records, click the corresponding checkboxes and then
click Remove. For training purposes, click the checkbox in the Select column for the
record for POWER_LOSS that you just added. Next, click Remove to remove that
record. When ask to confirm if you are sure you want to remove the selected record, click
Yes. The record should disappear from the table.
72. Click Save at the bottom of the Edit Control Measure window to save the changes you
made to the control measure and to close the window.
UNC-EMAQ(5-02)-007.v2
3-36
August 1, 2012
74. To edit a property record, check the corresponding checkbox in the Select column for the
MACTEC Engineering and Consulting reference and then click Edit. The Edit
Reference Record window will appear (Figure 3-27).
UNC-EMAQ(5-02)-007.v2
3-37
August 1, 2012
75. You can edit the value for the reference record as needed to reflect your new control
measure. For training purposes, add some additional text to the Description, then click
Save.
76. To add a new reference to the control measure, click Add in the References tab, and the
Add Reference Record window will appear (Figure 3-28). You will need to either
choose a reference that already exists in the database, or add a new reference.
To choose an existing reference, click on the Use existing reference option and then
search for the reference by filling in the Text contains field, then click Search. When
you have located the correct reference, select the reference, and click Save to add the
reference. For this step, a new reference will be created instead of adding an existing one.
The next paragraph explains how to create a new reference.
To create a new reference, click on the Create new reference option and then type the
reference in the Description field, then click Save to add the reference. For training
purposes, click on Create new reference and then specify sample technical reference
for the Description. When you are finished, click Save. A new row should appear in the
table in the Edit Control Measure window.
UNC-EMAQ(5-02)-007.v2
3-38
August 1, 2012
77. To remove one or more reference records in the References tab, click the corresponding
checkboxes and then click Remove. For training purposes, click the checkbox in the
Select column for the record for sample technical reference that you just added.
Next, click Remove to remove that record. When ask to confirm if you are sure you want
to remove the selected reference, click Yes. The record should disappear from the table.
78. Click Save at the bottom of the Edit Control Measure window to save the changes you
made to the control measure and to close the window.
3-39
August 1, 2012
information on the data needed for efficiency records, see Sections 3.2 and 3.4. You may
add as many efficiency records as you need to describe the control efficiency and cost of
the measure.
82. Go to the SCCs tab, which should look like the one shown in Figure 3-21, except that no
SCCs are listed initially. Add at least one SCC for the measure; otherwise it will have no
effect on any emissions sources. Note that the same control efficiency and cost
information must apply to all sources with SCCs listed on this tab, otherwise the
information must be stored in a separate measure for the other SCCs. For more
information on the data needed for SCCs, see Sections 3.2 and 3.4.
83. If you need to associate a cost equation with the measure, go to the Equations tab and
add an equation. The tab should look similar to the one shown in Figure 3-23. Cost
equations are optional. Ideally, if you do not have a cost equation, you will have entered
cost per ton information on one or more of the efficiency records so that the cost of
applying the measure can be computed when it is use in a control strategy.
84. If you need to associate a property with the measure, go to the Properties tab and add a
property. The tab should look similar to the one shown in Figure 3-24. Properties are
optional.
85. If you need to associate a reference with the measure, go to the References tab and add a
reference. The tab should look similar to the one shown in Figure 3-26. References are
optional.
86. Once you have entered all of the relevant information for the measure, click Save at the
bottom of the New Control Measure window. Hint: set your Pollutant Filter on the
Control Measure Manager to a pollutant that you specified an efficiency record for,
so that you can see the measure on the Manager, otherwise your new measure will
not be visible.
87. Set the Pollutant Filter to a pollutant you specified for one of your new measures
efficiency records, and you should see the new measure listed. If you do not see it, try
clicking the Refresh button to reload the measures from the server.
3-40
August 1, 2012
90. Use the Filter Rows button on the toolbar of the Select SCCs dialog to enter a filter that
will help identify SCCs for which you would like to see available control measures. For
training purposes, try entering the filter SCC starts with 103 and then click OK. Hint:
the starts with operation is above the contains operation in the list of operations. You
should see about 54 SCCs that meet this criterion.
91. Click the checkbox in the Select column for a few of the SCCs that interest you
(e.g., select at least 10300101) and then click OK. If there are measures available for
your selected SCC(s), they will be shown in the table. If you happened to select an SCC
for which there are no measures available, none will be shown.
92. Click Find again and this time, enter a filter on the Select SCCs dialog based on the SCC
description instead of the SCC itself. For example, use the Filter Rows button on the
toolbar to enter the filter Description contains Cement, then click on the checkbox in
the Select column for a few of these SCCs (e.g., 30500606) and click OK. If there are
measures in the database for the selected SCCs, they will be shown in the Control
Measure Manager table. However, note that there may be some SCCs for which there are
no measures available in the database. In that case, no measures would be shown in the
table after you apply your filter. For the measures that are returned, notice whether they
all have the same value for Pollutant (e.g., measures for SCC 30500606 target NOx,
PM10, and SO2).
3-41
August 1, 2012
94. Now change the value of the Pollutant menu to something other than MAJOR (e.g.,
PM10). You will see that all entries in the Pollutant column are now set to the pollutant
you specified, and the cost per ton (CPT) and control efficiency (CE) values are specific
to the selected pollutant instead of being for the major pollutant specified for the
measure. Note that CPT values may not be filled in for some measures. For PM
measures, the cost information is typically associated with PM10, as opposed to PM2_5.
Therefore, if you now set the Pollutant menu to PM2_5, you will not see CPT values for
many of the measures that do show CPT values for PM10.
95. Next, set the Pollutant menu to some other pollutant that interests you. The control
efficiency and cost information for the measures will be shown for the selected pollutant.
UNC-EMAQ(5-02)-007.v2
3-42
August 1, 2012
98. Click the Select all button on the Control Measure Manager toolbar, and then click the
Export button. The Exporting Control Measures dialog (Figure 3-29) will appear.
To export by selected measures, select the Export By Measure option . The list of
measures displayed for export are the same measures that were chosen from the Control
Measure Manager. Note its not necessary to click the Select checkboxes for these
measures, all measures shown in the list will be exported regardless if they checked or
not. To export by control measure sector, select the Export By Sector option, then
choose the various sectors to include in the export process.
For training purposes export by measure, so make sure the Export By Measure option is
selected to export just the preselected measures from the Control Measure Manager.
To specify the folder (i.e., directory) into which the CSV files will be written, type the
folder name into the Folder text field (or paste it in using Control-V). Alternatively, you
may use the Browse button to bring up the file and directory browser shown in Figure
3-30. To specify an export file prefix when naming the new export files, type the prefix
into the Prefix text field.
Figure 3-29. Exporting Control Measures Dialog
UNC-EMAQ(5-02)-007.v2
3-43
August 1, 2012
99. To use the browser (Figure 3-30) to select the export folder, you may enter a starting
folder (e.g., C:\) by typing it into the Folder field and hitting the Enter key. To browse
into subfolders of the Folder, use the mouse or your arrow keys to find the folder you
wish to drill down into and either double click or press the Enter key on your keyboard.
If you want to create a new subfolder, enter the name in the New Subfolder field and
click the Create button. Once you have the desired folder, click OK.
100. Type an export file prefix string (e.g., fabric_filter) into the Prefix field of the Exporting
Control Measures dialog. This string will be included at the front of the names of the
files that will be written. It will help you identify the types of measures that are included
once they have been exported into files.
101. Once you have specified the desired Folder and the Prefix on the Exporting Control
Measures dialog, click the Export button. The message at the top of the dialog will
notify you that the export has started and that you should monitor the Status window to
track your export request.
The Status window is near the bottom of the EMF main window (Figure 2-6). It will
show a message when the export starts and another when it is finished. You can see
updates to the status on demand by clicking the Refresh button at the top of the Status
window.
102. After the export is finished, close the Exporting Control Measures dialog by clicking
Close and then use your computers file browser to look in the folder that you selected
for the export. In the example shown above, the files created in the selected folder are:
fabric_filter_summary.csv, fabric_filter_efficiencies.csv, fabric_filter_SCCs.csv,
fabric_filter_equations.csv, fabric_filter_Props.csv, and fabric_filter_Refs.csv.
These files may be opened with standard spreadsheet software. For a complete
UNC-EMAQ(5-02)-007.v2
3-44
August 1, 2012
description of the fields in the files, see Control Strategy Tool (CoST) Control
Measures Database (CMDB) Documentation.
Files in the exported format can also be imported into the CMDB. To import control
measures from files, you must be an Administrator for the EMF. If you are an
Administrator, you can click the Import button on the Control Measure Manager to start
importing measure. [Note that if you are taking a training class, you will not be an
Administrator and therefore will not be able to import control measure data, but you
can review the concepts for importing described in the following section.]
In the Import Control Measures window that appears (Figure 3-31), you may type or paste
the name of the Folder into the field. You may also use the Browse button to browse to a
folder containing the files to be imported (see the instructions for Figure 3-30) and select the
files directly from the browser. Alternatively, you may enter the folder name and then type in
a pattern to specify the files, then click Apply Pattern. When using a pattern, an asterisk (*)
will be expanded to the available file names.
It is also possible to purge existing measures from the system by sector. This feature will
remove all measures associated with the sectors chosen in the Purge Existing Measures By
Sectors list. The user must also click the Purge checkbox to allow the measures to be purged.
The measures will be purged when the Import button is clicked.
Once you have selected the files to import, click the Import button. Information about the
status of the import will be shown in the Status section of the window. To see updates to the
status of the import, click the Refresh Import Status button. Once the imports are complete,
click the Done button. If the measures you import already exist in the database, the new data
will replace the existing data. Note that you are not warned before the data are replaced, so
use the import feature with caution.
UNC-EMAQ(5-02)-007.v2
3-45
August 1, 2012
UNC-EMAQ(5-02)-007.v2
3-46
August 1, 2012
View, sort, and filter a list of control strategies from the Control Strategy Manager
window
This section is presented as a series of steps so that it may be used as part of a training class or as
a tutorial on how to use CoST. The numbered steps are the ones you are expected to perform,
while other material is provided for documentation purposes.
What is the maximum emissions reduction achievable for NOx (i.e., is my reduction
goal less than the maximum possible reduction?), and what set of controls will achieve
this reduction?
What set of controls can achieve the goal at the least cost?
What does the cost curve look like for other levels of reduction?
What are the emission reductions or increases for other pollutants of interest?
What are the engineering costs of applying the controls for a specific strategy?
What control measures are available for specific source categories and pollutants, how
much reduction does each one provide, and for what cost?
A future goal for CoST is to be able to answer this question: What is the optimum method for
achieving simultaneous targeted reductions for multiple pollutants?
UNC-EMAQ(5-02)-007.v2
4-1
August 1, 2012
CoST can help answer the above questions when users set up and run one or more control
strategies. A diagram of the basic steps for running a control strategy is shown in Figure 4-1. As
illustrated in that figure, the inputs to a control strategy consist of:
one or more emissions inventory datasets (that have already been loaded into the EMF)
filters to limit which control measures are to be included in the strategy analysis
constraints that limit the application of measures to specific sources based on the
resulting costs or emissions reduction achieved
Figure 4-1. Basic Steps for Running a Control Strategy
Type of Analysis
Outputs:
Cost Year
Target Pollutant
Detailed
Pairing of
Measures to
Sources
6) Run
Strategy
Query
Control
Case
Emissions
Inventory
Various
Summary
Files
Once the inputs have been defined, the strategy can be run on the EMF server. The method by
which the measures are associated with the strategies depends on the algorithm that has been
selected for the strategy. At this time, six algorithms are available to determine how measures are
assigned to sources:
UNC-EMAQ(5-02)-007.v2
4-2
August 1, 2012
Annotate Inventory: assigns control measures to the inventory based on the control
efficiency specified for each source, and can be used to fill in control measure
information for inventory sources that are missing these details but have a control
efficiency assigned.
Apply Measures in Series: assigns all control measures that can be used for a source in
the specified order; this is often used for mobile sources, for which the control measures
are typically independent of one another.
Least Cost: each source can be assigned only a single measure to achieve a specified
percent or absolute reduction for the sources included in the strategy run, with the
minimum possible annualized cost.
Least Cost Curve: performs least-cost runs iteratively at multiple percent reductions so
that a cost curve can be developed that shows how the annualized cost increases as the
level of desired reduction increases.
Maximum Emissions Reduction: assigns to each source the single measure (if a
measure is available for the source) that provides the maximum reduction to the target
pollutant, regardless of cost.
Multi-Pollutant Maximum Emissions Reduction: assigns all control measures that can
be used for a source based on a specific target pollutant order (e.g., NOx first, PM10
second, VOC third, and SO2 last). Each source target pollutant can be assigned only a
single measure, and it must be the one that provides the maximum reduction, regardless
of cost. If a sources target pollutant was already controlled via a co-impact from a
measure applied during a previous target pollutant iteration, then no additional control
will be chosen for that specific sources target pollutant (e.g., if a NOx measure also
controlled VOC as a co-impact, during the VOC iteration no measure would be attempted
for this source, since it was already controlled via the co-impact).
Some of the key aspects of each of the strategy types are summarized in Table 4-1, and some
additional information on each strategy type is provided in the following subsections.
Table 4-1. Summary of Strategy Algorithms
Strategy Type
Annotate Inventory
Multiple
Inventories
Processed
independently
Apply Measures in
Series
Processed
independently
Least Cost
Will be merged
Will be merged
UNC-EMAQ(5-02)-007.v2
Typical
Sectors
Area,
nonpoint
Mobile:
Onroad,
nonroad
Area,
nonpoint
Area,
nonpoint
Measure
Assignment
One per source
Standard
Multiple per
source
Standard
4-3
Outputs
August 1, 2012
Multiple
Inventories
Strategy Type
Typical
Sectors
Maximum
Emissions
Reduction
Processed
independently
Area,
nonpoint
Multi-Pollutant
Maximum
Emissions
Reduction
Processed
independently
Area,
nonpoint
Measure
Assignment
One per source,
to achieve
maximum
reduction of
target pollutant
One per source
target pollutant;
based on
specified target
pollutant order;
could be multiple
per source
Outputs
Standard
Standard
After the strategy run is complete, several outputs are associated with the strategy. The main
CoST output for each control strategy is a table called the Strategy Detailed Result. This
table consists of emission source-control measure pairings, each of which contains information
about the cost and emission reduction that would be achieved if the measure were to be applied
to the source. If multiple inventories were processed by the strategy, then there will be one
Strategy Result for each input inventory, unless the inventories were merged for a least cost run
(as indicated in the Multiple Inventories column Table 4-1). Also, there will be at least one
Strategy Detailed for each of the least cost iterations performed as part of a Least Cost Curve
run. In addition to the Strategy Detailed Result, two other outputs are produced for each strategy
run: the Strategy County Summary (which includes uncontrolled and controlled emissions), and
the Strategy Measure Summary (which summarizes how control measures were applied for each
sector-county-SCC-Pollutant combination). These three outputs are referred to in Table 4-1 as
the Standard outputs.
The Strategy Detailed Result table itself can be summarized on-demand in many ways using
predefined summary queries (e.g., by state, by county, by control technology). Users familiar
with SQL can also define their own custom queries. The Strategy Detailed Result table can also
be merged with the original input inventory, in an automated manner, to produce a controlled
emissions inventory that reflects implementation of the strategy. The controlled emissions
inventory includes information about the measures that have been applied to the controlled
sources and can be directly input to the SMOKE modeling system to prepare air quality modelready emissions data. Comments are placed at the top of the inventory file to indicate the
strategy that produced it and the settings of the high-level parameters that were used to run the
strategy.
Detailed information on specifying control strategy input parameters is given in Section 4.3.1.
Section 4.3.2 discusses fields automatically set by CoST. Section 4.3.3 addresses inventories and
inventory filtering. Section 4.3.4 discusses control measure filtering and custom overrides.
Constraints are discussed in Section 4.3.5. Running a strategy and accessing its outputs are
discussed in Section 4.4. Documentation for the various types of strategy outputs is given in
Section 4.5, and information about summaries of strategy inputs and outputs is given in Section
4.6.
UNC-EMAQ(5-02)-007.v2
4-4
August 1, 2012
4-5
August 1, 2012
information about the cost and emission reduction achieved if the measure was to be applied to
the source. Examples of these tables are given in Section 4.5. This dataset will be used to help
generate a single Strategy Detailed Result (no matter how many input inventories were
processed) once the optimization process has been performed to achieve the desired reduction.
This dataset has the all of the same columns as the Strategy Detailed Result (see Table 4-9), in
addition to the following columns:
marginal: This column stores the marginal cost (dollars are given based on the specified
cost year) for the source-measure record. This is calculated according to the following
equation:
marginal cost = annual cost (for specified cost year) / emission reduction (tons)
Note that cost equations are used to compute the annual cost, when applicable and all
required input data is available. For target pollutant source-control pair records, the
annual cost will be the total of the annual costs for the target pollutant and any costs
associated with cobenefit pollutants.
status: This column contains a flag that helps determine which source-control records
should be actively considered during the strategy run.
cum_annual_cost: This column contains the cumulative annual cost for the source and
all preceding sources that have been included in the strategy (i.e., for which status is
null). This is only specified for target pollutant sources, but it also includes costs
associated with cobenefit pollutants.
cum_emis_reduction: This column contains the cumulative emission reduction for the
source and all preceding sources that have been included in the strategy (i.e., for which
status is null). This is only calculated for target pollutant sources. The emission
reduction is cumulated by following the apply_order in an ascending order.
If multiple input inventories are used for the least cost strategy run and the user requests to create
controlled inventories, there will be one controlled inventory created for each of the input
inventories.
Domain-wide Percent Reduction Start (%): Specifies a percent reduction to be used for
the first Least Cost strategy to be run.
UNC-EMAQ(5-02)-007.v2
4-6
August 1, 2012
Domain-wide Percent Reduction End (%): Specifies a percent reduction to be used for
the last Least Cost strategy to be run.
Additional runs can be added to a least cost curve strategy if you do not delete the previous
results when you rerun the strategy. Suppose that you generate a coarse cost curve (default
increment is 25%) and you find an area of interest that bears further examination. You can then
go back and specify different start, end, and increment to obtain more information (e.g.,
start=80%, end=90%, increment=2%) about that portion of the curve.
The types of outputs for a Least Cost Curve strategy are the following:
1) Strategy Detailed Result datasets for each targeted percent reduction. Note that several
results could have the same actual percent reduction if the targeted reduction exceeds the
maximum available reduction. As with a Least Cost strategy, the actual percent reduction
may not exactly match the targeted reduction due to the discrete nature of applying
specific controls to specific sources. CoST will ensure that each actual reduction is equal
to or greater than the corresponding targeted reduction.
2) Least Cost Control Measure Worksheet: this output is the same as the worksheet
produced for a regular Least Cost strategy run. Note that the same worksheet is used for
all targeted percent reductions and only the status column is updated to specify when
measure-source combinations are included in the current strategy.
3) Least Cost Curve Summary: this output dataset contains a row with cost and emissions
reduction information for each of the runs that was performed for the strategy. Rows are
added to this output if additional strategy runs are performed (e.g., to examine different
sections of the curve). The columns of this summary are: Poll, Uncontroll_Emis (tons),
Total_Emis_Reduction (tons), Target_Percent_Reduction, Actual_Percent_Reduction,
Total_Annual_Cost, Average_Ann_Cost_per_Ton, Total_Annual_Oper_Maint_Cost,
Total_Annualized_Capital_Cost, Total_Capital_Cost. Here, the Uncontroll_Emis
column contains the emissions from the original input inventory with all existing controls
backed out so that it represents the uncontrolled emissions. The columns starting with
Total are computed by summing all of the values of the corresponding column in the
Strategy Detailed Result for the pollutant specified in the Poll column. Examples of Least
Cost Curve Summaries are given in Figure 10 and Table 19.
4) Controlled Inventories: these output datasets may optionally be created based on any of
the Strategy Detailed Results that are available for the strategy. Thus, results
corresponding to any of the targeted reductions may be processed by SMOKE and the
resulting data used as an input to an air quality model. Note that for each targeted
reduction, individual controlled inventories will be created for each of the input
inventories.
UNC-EMAQ(5-02)-007.v2
4-7
August 1, 2012
4-8
August 1, 2012
When an Annotate Inventory strategy is run, CoST looks at the percent reduction specified by
the CEFF, REFF, and RPEN columns and uses the available control measures in the database to
try to determine what control measure has the closest percent reduction to the one specified in
the inventory. It then fills in the control measures column with the measure that was found.
Note that the originally specified control efficiency fields and the emissions in the inventory are
not changed, even if the inventory efficiency differed from the efficiency specified for the
control measure. If no measure was found, it leaves the control measure field blank. Once the
strategy has been run, a summary report can be generated with using the "Compare CoST to NEI
measures" query that shows the sources with non-zero CEFF values and the difference between
the inventory specified percent reduction and the percent reduction that the control measure that
CoST guessed had been applied to the source. It is important for the user to then examine
the results of this report to find cases where the specified control efficiency matches were
not even close and those for which no match was found. Both of these situations can indicate
that there is missing or incorrect data in the control measures database, or that the information in
the inventory was erroneous. The eventual goal of the Annotate Inventory strategy is to develop
a base year inventory with more complete existing control measure information.
UNC-EMAQ(5-02)-007.v2
4-9
August 1, 2012
The Control Strategy Manager shows all of the control strategies currently available within
the EMF/CoST system in a sortable, filterable window. The columns shown in the window
are Select, Name, Last Modified, Is Final, Run Status, Region, Target Pollutant, Total Cost,
Reduction (tons), Average Cost Per Ton, Project, Strategy Type, Cost Year, Inv[entory]
UNC-EMAQ(5-02)-007.v2
4-10
August 1, 2012
Year, and Creator. Descriptions of some of the columns are given in Table 4-2. The
remaining fields are described in detail in Section 4.3.
Table 4-2. Key Columns of the Control Strategy Manager
Column
Description
Name
Last Modified
shows the date and time on which the strategy was last changed.
Run Status
Inv Year
shows the year of the emissions inventory that the strategy will process.
UNC-EMAQ(5-02)-007.v2
4-11
August 1, 2012
4. Once you have reviewed the information available on the Control Strategy Manager,
click the Reset button
For more information on performing sorting, filtering, formatting, and other operations on
the table that shows the control strategies used for the Control Strategy Manager, refer to
Section 3.1.
UNC-EMAQ(5-02)-007.v2
4-12
August 1, 2012
Note that if you had selected more than one control strategy before clicking Remove, all
of the selected strategies would have been removed.
UNC-EMAQ(5-02)-007.v2
4-13
August 1, 2012
Description
Shows you high-level information about the strategy, such as its Name
and the Target Pollutant.
From which you can specify the emission inventories to use as input to
the strategy and filters for those inventories.
Allows you to specify the classes of measures to include in the
strategy, or select specific measures to include.
Allows you to specify constraints for the strategy, such as a maximum
cost per ton.
Shows the results from the strategy after it has been run.
Figure 4-5. Summary Tab of Edit Control Strategy Window
UNC-EMAQ(5-02)-007.v2
4-14
August 1, 2012
UNC-EMAQ(5-02)-007.v2
4-15
August 1, 2012
17. Optionally specify the name of the geographic Region to which the strategy is to be
applied. For training purposes, select any region, because this setting is for user
information only and does not impact the strategy results. Region is different from the
concept of locale used in the control measure efficiency records (see Section 3.2.2) to
indicate the state or county code to which the record applies.
18. Select a Target Pollutant for the strategy (e.g., for training purposes pick NOX). The
target pollutant is the pollutant of primary interest for emissions reduction for this control
strategy. The Least Cost and Maximum Emissions Reduction algorithms will consider
reductions of this pollutant when performing their computations.
Note that reductions of pollutants other than the selected target pollutant (e.g., PM10,
PM2.5, elemental carbon [EC], organic carbon [OC]) will be included in strategy results if
those pollutants both appear in the inventories input to the strategy and they are affected
by measures applied as part of the strategy. These pollutants are sometimes referred to as
co-impact pollutants, because the impact on the emissions could be either a reduction
(i.e., a benefit) or an increase (i.e., a disbenefit).
19. Specify a Discount Rate (i.e., interest rate) to use when computing the annualized capital
cost for control measures when appropriate data are available. For training purposes,
enter 7. Note that discount rate typically does not affect strategies for area or mobile
sources.
20. Specify whether to Use Cost Equations for the strategy run. When the checkbox is
checked, cost equations will be included in the run, otherwise only CPT related cost
estimates will be used. For training purposes, leave this checked. When it is not
checked, they will not be used; only the default cost per ton values will be used.
21. Specify whether to Apply CAP measures on HAP Pollutants for the strategy run. When
the checkbox is checked, a CAP-to-HAP pollutant mapping relationship exists that will
allow any sources HAP pollutants to be reduced at the same emission reduction
percentage as the corresponding mapped CAP pollutant. For training purposes, leave
this unchecked. When it is not checked, control of the sources HAP pollutants will not
be attempted.
22. Specify whether to Include Measures with No Cost Data. When the checkbox is
checked, measures with control efficiencies but without cost data (e.g., measures with no
cost data specified or measures that use a cost equation to compute cost, but for which
there is not enough data for the source in the inventory to fill in the equations variables),
are included in the strategy run; otherwise they are not included. For training purposes,
leave this checked.
UNC-EMAQ(5-02)-007.v2
4-16
August 1, 2012
Running User
Total Annualized
Cost
Target Poll.
Reduction (tons)
Description
The name of the person who created the strategy.
The date and time when the strategy was last modified.
The name of the strategy that this strategy was copied from, if any.
The date and time on which the strategy run was most recently started,
or Not started if the strategy has never been run.
The date and time on which the strategy run was most recently completed. If the run has not completed, this field shows the run status of
either Not started, Running, Waiting, Completed, or Failed.
The name of the user who most recently ran the strategy.
The total annualized cost of applying the strategy.
The absolute emissions reduction achieved for the target pollutant, in
tons.
UNC-EMAQ(5-02)-007.v2
4-17
August 1, 2012
23. To add one or more inventories to the Inventories to Process table for the control
strategy, click the Add button on the Inventories tab. A Select Inventory Datasets dialog
will appear.
24. From the Select Inventory Datasets dialog, select the type of inventory that you wish to
show (e.g., ORL Nonpoint) from the pull-down menu titled Choose a dataset type
near the top of the dialog. The browser will then show you the inventories of the
specified type (Figure 4-7). If there are many inventories and you wish to narrow down
the list (e.g., to find inventories for 2017), you can then enter a string in the Dataset
name contains field and press the Enter key on your keyboard. This will limit the list to
those inventories for which their name contains the specified string.
25. To select an inventory to use for the strategy from the dialog, click on the name of the
inventory with your mouse. For training purposes, select
nonpt_pf4_cap_nopfc_2017ct_nc_sc_va and then click OK. When you return to the
Inventories tab, you will see the inventory you selected in the list of inventories to
process.
Figure 4-6. Inventories Tab of Edit Control Strategy Window
UNC-EMAQ(5-02)-007.v2
4-18
August 1, 2012
26. Click the Add button to add two more inventories. Select the ORL Point inventory type
from the pull down at the top and add the ptnonipm_xportfrac_cap2017ct and
ptnonipm_xportfrac_cap2017ct_nc_sc_va datasets. To select multiple inventories, hold
down the control key while clicking the additional inventories.
27. If you wish to remove inventories from the list of inventories to process, click the Select
checkboxes that correspond to those inventories, click the Remove button (Figure 4-6),
and then click Yes when you are asked to confirm deleting of the inventories. For training
purposes, remove the ptnonipm_xportfrac_cap2017ct inventory so that only the
nonpt_pf4_cap_nopfc_2017ct_nc_sc_va and
ptnonipm_xportfrac_cap2017ct_nc_sc_va inventories remain in the list. When asked
if you really want to remove the selected inventory, select Yes.
28. Note that multiple versions of the inventories may be available within the EMF. The
EMF supports the storing of multiple versions of a dataset to facilitate reproducibility of
historical runs. To specify which version of the inventory to use, check the Select
checkbox next to a single inventory and then click the Set Version button. A dialog will
appear that lists the versions available for the selected inventory. Choose the desired
version from the menu and then click the OK button. You will then see the number of the
version you specified in the Version column of the Inventories to Process table. Note that
the initial version of a dataset is always version number 0 and for this training exercise
the datasets only have one not multiple versions.
29. To see the properties (i.e., metadata) for an inventory you selected, click the
corresponding checkbox in the Select column and then click View. The Dataset
Properties View window will appear (Figure 4-8). The Dataset Properties View window
UNC-EMAQ(5-02)-007.v2
4-19
August 1, 2012
provides information about the selected inventory dataset and has multiple tabs as
described in Table 4-5.
Table 4-5. Tabs of the Dataset Properties View and Edit Windows
Tab
Summary
Data
Keywords
Notes
Revisions
History
Sources
QA
Description
Shows high-level properties of the dataset
Provides access to the actual inventory data so that you can view the
data that will be used in the control strategy
Shows additional types of metadata not found on the Summary tab
Shows comments that users have made about the dataset and
questions they may have
Shows the revisions that have been made to the dataset
Shows how the dataset has been used in the past
Shows where the data came from and where it is stored in the
database, if applicable
Shows QA summaries that have been made of the dataset (e.g., state
summaries, county summaries)
There are also buttons at the bottom of the window. The Edit Properties button will
bring up the Dataset Properties Editor that will allow you to change (as opposed to just
look at) the properties of the Dataset. The Edit Data button will bring up the Dataset
Versions Editor that allows you to edit the actual data of the dataset by adding new
versions. The Refresh button will update the data on the Dataset Properties View
window with the latest information available from the server. The Export button allows
the user to export the dataset data to a location on the server. The Close button closes the
Dataset Properties Editor window.
UNC-EMAQ(5-02)-007.v2
4-20
August 1, 2012
30. When you are finished examining the properties of the inventory dataset as shown on the
various tabs, click Close.
31. To view the inventory data itself (as opposed to just the metadata), check the select
checkbox for an inventory from the Inventories to Process table in the Inventories tab of
the Edit Control Strategy window and click the View Data button. This may take a
minute or two, but the Data Viewer window that shows the actual rows of data for the
selected inventory will appear (Figure 4-9). This is different from the metadata that was
shown in the Dataset Properties View window. Note that the View Data button is a
shortcut. The Data Viewer can also be brought up from the Data tab of the Dataset
Properties Viewer.
UNC-EMAQ(5-02)-007.v2
4-21
August 1, 2012
32. Inventories can have a lot of dataup to millions of rows. The fields in the upper right
corner of the window in the area labeled Current: provide information about how
many rows the inventory has, and which rows are currently visible. The Data Viewer
transfers only a small amount of data (300 rows) from the server to your desktop client to
keep the transfer time reasonable. It works similarly to a web search engine that shows
the results in pages, and the pagination arrows near the upper right corner of the window
facilitate moving between pages of data. Try using some of the pagination arrows in
the upper right corner to see how they work: go to first record, go to previous page,
give a specific record, go to next page, and go to last record.
33. You can control how the data are sorted by entering a comma-separated list of columns in
the Sort Order field and then clicking Apply. For training purposes, if you are using a
UNC laptop, do not specify a sort order because this function is very slow on these
laptops. It should be much faster on a true EMF server. Note that a descending sort can
be specified by following the column name with desc (e.g., ANN_EMIS desc, FIPS
will sort by decreasing annual emissions and then by county).
34. If you enter a Row Filter, and then click Apply, the Data Viewer will find rows that
meet the criteria you specified. Examples of the syntax for row filters are given in Table
4-6. See Section 6.0 for additional row filter examples. For training purposes, if you are
using a UNC laptop, do not specify a row filter because this function is very slow,
otherwise you may try some of the filters.
UNC-EMAQ(5-02)-007.v2
4-22
August 1, 2012
35. When you are finished examining the Data Viewer, click Close to close the window.
The next few paragraphs provide information on how the options at the lower portion
of the Inventories tab work, there are no training steps in them. The training exercises
start again with the next numbered bullet.
Some control strategy algorithms (e.g., Apply Measures in Series) are designed to process the
inventories iteratively and produce results for each inventory. However, the Least Cost and
Least Cost Curve strategy types can merge the input inventories from multiple sectors
together prior to processing them, thereby facilitating cross-sector analyses. The Merge
Inventories checkbox is shown in the lower right corner of the Inventories to Process
section, when multiple inventories will be merged together prior to applying the strategy
algorithm, such as for Least Cost or Least Cost Curve runs. Otherwise, each inventory will
be processed independently to create separate, independent results.
The fields in the Filters section of the Inventories tab of the Edit Control Strategy window let
you control whether the entire inventory is processed in the strategy or just a portion of it.
The Inventory Filter field allows you to specify a general filter that can be entered using the
same syntax as a Structured Query Language (SQL) where clause. Any of the columns in
the inventory can be used in the expression. Examples include: SCC like 212% to limit
the analysis to apply only to inventory records for which the SCC code starts with 212, and
FIPS like 06% or FIPS like 07% to limit the strategy analysis to apply only to
inventory records with Federal Information Processing Standards (FIPS) numeric statecounty codes starting with 06 or 07. Additional examples of filters are shown in Table 4-6.
Note that the Multi-Pollutant Max Emission Reduction strategy type the Inventory Filter
has been moved from the Inventories Tab to the Constraints Tab. For this Multi-Pollutant
UNC-EMAQ(5-02)-007.v2
4-23
August 1, 2012
Max Emission Reduction strategy its possible to specify the Inventory Filter different for
each target pollutant instead at the strategy level. Note that within the inventory filter, you
may use either upper or lower case to refer to the column names and for the SQL keywords;
the specified values within single quotes, however, are case sensitive (e.g., NOx is different
from NOX). Entering an inventory filter will not have an effect until the strategy is run.
Note that if you enter an inventory filter to include only specific pollutants, then
pollutants not specified by the filter will not be considered for the computation of coimpacts. In addition, pollutants like EC and OC that are not traditionally included in input
inventories will not be included in the results unless the inventory has been preprocessed to
include EC and OC.
The County Dataset field allows another way to filter the inventory. With this field you can
specify an EMF dataset containing a list of counties within which to consider applying
control measures during the strategy run. If the user selects a county dataset filter when
creating a control strategy, control measures will be applied only to counties that are included
in this list. The County Dataset pull-down will show as options the names of the available
datasets in the EMF that have the dataset type List of Counties (CSV). Note that CSV files
from which these county datasets are created must have at least two columns of data. Also,
the first row of the file must be the column names, and one of the columns must have a name
that starts with FIPS. CoST will assume that this column has the list of FIPS codes that
should be controlled. Make sure that leading zeros are present for FIPS codes less than
10000. Note that for the Multi-Pollutant Max Emission Reduction strategy type the County
Filter has been moved from the Inventories Tab to the Constraints Tab. For this MultiPollutant Max Emission Reduction strategy its possible to specify the County Filter
different for each target pollutant instead at the strategy level.
Note that only the records of the input inventories that pass both the inventory and county
filters will be considered for control measure application.
36. For training purposes, on the Inventories tab, specify the following Inventory Filter:
FIPS in ('45001', '45009', '45011'). Note that specifying a list of counties using the
Inventory Filter is an alternative to specifying a county dataset that has a list of counties
to consider controlling in the strategy (as show in the next bullet). If you just wanted to
control a few counties, you might use the Inventory Filter, but if you want to control
more than a few counties, the county dataset method is recommended. In addition, many
types of Inventory Filters can be specified using other fields of the inventory depending
on the needs of your analysis (e.g., SCC like '231%', or ANN_EMIS>5).
37. Examine the available county datasets by pulling down the menu and select one of
the datasets. After you have selected a county dataset, examine its properties and the
data themselves by clicking the View and View Data buttons.
38. If a county dataset is specified, a version of the dataset to use must be selected using the
County Dataset Version field, which shows the available versions of the selected
dataset. This selection is required because the EMF can store multiple versions of each
dataset. Examine the list of versions available for the dataset in the menu.
UNC-EMAQ(5-02)-007.v2
4-24
August 1, 2012
39. If you selected a county dataset as part of understanding how this feature works only for
training purposes, as opposed to performing a strategy run in support of your work, set
the pull-down menu back to Not selected before proceeding.
UNC-EMAQ(5-02)-007.v2
4-25
August 1, 2012
41. To select specific measures for inclusion in the strategy, click the Add button to show the
Select Control Measures dialog (Figure 4-11). On this dialog, specify a filter to find all
measures with the same control technology (e.g., Abbrev contains SNCR). You need to
check the Select checkboxes corresponding to any of the measures that you want to
include in your strategy run. If you want to select all or most of the measures that
matched the filter in your strategy, click the Select All button in the toolbar to select all
of the measures. If you do not want to include all of the measures, you can uncheck the
Select checkbox for the measures you do not want included. For training purposes,
Select All of the measures that matched your filter.
UNC-EMAQ(5-02)-007.v2
4-26
August 1, 2012
42. Prior to selecting OK on the Select Control Measures dialog, you may want to make
some optional settings for the group of measures in support of your analysis (see Measure
Properties and Regions at bottom of window). (For training purposes, you may make
whatever selections interest you, because these selections will be removed later in the
process and will not impact your results.)
Specify an Order to control the order in which this group of measures is applied as
compared to other groups of measures you have selected. This order of application is
particularly relevant to the Apply Measures in Series strategy type. When running
this type of strategy, since multiple measures can be applied to the sources, they will
be applied in increasing numerical order (i.e., measures with order set to 1 will be
applied before those with order set to 2).
Override the values of Rule Effectiveness or Rule Penetration that are specified in the
measure efficiency records using the Set RE % and Set RP % fields. This can be
helpful if you want to assess the level of emissions reductions achieved assuming
different levels of penetration for the measures. For example, setting the rule
UNC-EMAQ(5-02)-007.v2
4-27
August 1, 2012
penetration to 75% assumes that 75% of the sources are applying the measure and
would therefore result in 75% of the emissions reductions it would if it was 100%.
43. Once you have selected some the specific measures using the Select Control Measures
dialog and specified any desired overrides for those measures, click OK and the selected
measures will appear on the Measures tab. The tab will now look similar to that shown in
Figure 4-12. Note that only the table of specific measures and their properties is shown,
and the Classes to Include list is no longer shown. If desired, you may repeat the process
of selecting specific measures to add new sets of measures to the list of measures to be
used for the strategy. Each new group of measures selected can have different settings for
the order, RE, RP, and Region.
Figure 4-12. Measures Tab Showing Specific Measures to Include
UNC-EMAQ(5-02)-007.v2
4-28
August 1, 2012
44. After you have selected specific measures, if you wish to change their order, RE, RP, or
Region properties, select the measures you wish to adjust and click the Edit button on
the Measures tab. An Editing measures dialog will appear and you can make changes to
their properties when they are used in the strategy.
45. To remove specific measures from the list of measures to be included in the strategy run,
check the corresponding Select checkboxes and then click Remove. When you are
prompted to confirm the removal, click Yes.
46. For training purposes, remove all of the individually selected measures by clicking the
Select All button on the toolbar and then clicking Remove followed by clicking Yes
when prompted. Make sure that Known is selected in the Classes to Include list. Now
the Measures tab should look like Figure 4-10 again.
UNC-EMAQ(5-02)-007.v2
Constraint Description
If specified, requires each control measure to reduce the target pollutant
by at least the specified minimum tonnage for a particular source (down to
the plant+point+stack+segment level of specification); if the minimum
tonnage reduction is not attainable, the measure will not be applied.
If specified, requires each control measure used in the strategy to have a
control efficiency greater than or equal to the specified control efficiency
for a particular source and target pollutant.
4-29
August 1, 2012
Constraint Name
Maximum 2006
Cost per Ton
($/ton)
Maximum 2006
Annualized Cost
($/yr)
Minimum Percent
Reduction
Difference for
Replacement
Control (%)
Constraint Description
If specified, each control measure must have an annualized cost per ton
less than or equal to the specified maximum annualized cost per ton for
the target pollutant for each source. This cost is based on 2006 dollars.
If specified, each control measure must have an annualized cost less than
or equal to the specified annualized cost for each source and target
pollutant. This cost is based on 2006 dollars.
If specified, each control measure must have a percent reduction in
emissions with the new measure that is greater than or equal to the
specified difference in order for the old control measure to be replaced
by the new control measure. Incremental controls that add an additional
device onto a previously controlled source are not yet supported by CoST
except for the Apply Measures in Series strategy type, for which all
controls are assumed to be independently applicable. In the event that a
combination of two control devices is listed as a control measure (e.g.,
LNB+FGR) and the combined control efficiency provides an ample
increase in the control efficiency over the original efficiency, that
combination of the devices can still serve as a replacement control if the
source already has a measure applied (e.g., LNB). In the future, instead of
requiring an increase in the percent reduction, it may be more useful to
specify a minimum additional percent reduction in remaining emissions
(e.g., such as one might see when going from a 99% control measure to a
99.5% control measure).
The constraints in Table 4-7 are available on the Constraints tab for all types of strategies.
The lower portion of the Constraints tab is used to specify constraints that are specific to
particular strategies. These constraints vary based on the type of algorithm selected. Figure
4-13 shows the constraints specific to the Least Cost strategy algorithm. For the Least Cost
algorithm, you can specify either the Domain Wide Emissions Reduction [for the target
pollutant] in tons, or you can specify the Domain Wide Percent Reduction [in emissions of
the target pollutant]. When the strategy is run, CoST will attempt to satisfy the reduction you
specified using controls selected with the minimum cost. Note that after the strategy run is
complete, CoST will fill in the value for the least cost constraint that was not originally
specified.
47. For training purposes, enter a percent reduction of 50 for the Domain Wide Percent
Reduction (%).
48. Click Save to save all of the changes you made to the strategy. Note that if you were to
click Close without saving the changes, you will be prompted as to whether you wish to
close the window without saving the changes.
UNC-EMAQ(5-02)-007.v2
4-30
August 1, 2012
The other strategy type with special constraints is the Least Cost Curve. This algorithm
allows you to specify three special constraints: Domain-wide Percent Reduction Increment
(%), Domain-wide Percent Reduction Start (%), and Domain-wide Percent Reduction
End (%). The Least Cost Curve strategy will iteratively run Least Cost strategies. First it
will run the least cost strategy with the percent reduction specified as the value of Domainwide Percent Reduction Start (%), it will then add the Domain-wide Percent Reduction
Increment (%) to the starting percent value and will run the least cost strategy at that value
(i.e., starting value + increment). It will continue running strategies for each increment until
it reaches the value of Domain-wide Percent Reduction End. Note that it may not be
possible to achieve some of the selected percent reductions, in which case CoST will
generate the same result for that increment as the Maximum Emissions Reduction would
generate.
The Multi-Pollutant Max Emis Reduction strategy type uses a different Constraints Tab than
the other strategy types. Since this strategy type is running goals on numerous target
pollutants (e.g. PM2.5, NOx, SO2)it made sense to allow for the constraints discussed above
(see Table 4-7) and inventory filtering capability (see section 4.3.3) to be definable
differently for each target pollutant. The Tab interface is shown in Figure 4-14.
UNC-EMAQ(5-02)-007.v2
4-31
August 1, 2012
Figure 4-14. Constraints Tab (for Multi-Pollutant Maximum Emission Reduction strategy
type) of Edit Control Strategy Window
After the target pollutants are selected from the Summary Tab, if you wish to set the constraints
and filters, select the pollutants you wish to adjust and click the Edit button on the Constraints
tab. An Editing target pollutant dialog will appear and you can make changes to the constraints
and filters when they are used in the strategy. See Figure 4-15 for an example Edit Target
Pollutant dialog. Note if you want to review this functionality, you will need to create a copy of
the Multi-Pollutant Max Emissions Reduction Example strategy and edit this version of the
strategy. Since you are not the owner of the Multi-Pollutant Max Emissions Reduction
Example strategy you can only view and not edit this strategy.
UNC-EMAQ(5-02)-007.v2
4-32
August 1, 2012
Figure 4-15. Edit Target Pollutant Dialog of Edit Control Strategy Window
UNC-EMAQ(5-02)-007.v2
4-33
August 1, 2012
52. If the strategy runs successfully, you will see multiple messages in your status window.
You will get one message as the processing for each inventory completes, such as
Completed processing control strategy input dataset: dataset_name. When the
entire run has finished, you will see a message like Completed running control
strategy: your strategy name in the Status window. Otherwise, you will see a message
stating that the strategy failed and some information as to why it failed.
53. Once the strategy run has completed, click on the Outputs tab in the Edit Control
Strategy window and then click Refresh at the bottom of the window to see the newly
created outputs listed in the Output Datasets table (Figures 4-16 and 4-17).
CoST automatically generates three main outputs as EMF datasets after each successful
strategy run: Strategy Detailed Result, Strategy Measure Summary, and Strategy
County Summary. Some types of strategies also generate a Strategy Messages output.
Least cost and least cost curve strategies generate a Least Cost Control Measure
Worksheet that lists all of the available control measure options for each source in the
inventories.
For all types of strategies, it is possible to generate Controlled Inventory on-demand for any
of the Strategy Detailed Result datasets. The types of outputs are discussed in more detail in
Section 4.5. Note that the output datasets are given unique names that include a timestamp
indicating when the strategy was run, including the year, month, day, hour, and minute of the
run. You can rename the output datasets as described in the following section if you wish
them to have more meaningful names.
For additional details on the algorithms that are applied to assign measures to sources as part
of a strategy run (other than the descriptions in Section 4.1), please see the Control Strategy
Tool (CoST) Development Document.
UNC-EMAQ(5-02)-007.v2
4-34
August 1, 2012
Figure 4-16. Outputs Tab of Edit Control Strategy Window for Least Cost Strategy
UNC-EMAQ(5-02)-007.v2
4-35
August 1, 2012
Figure 4-17. Sample Outputs Tab for a Least Cost Curve Strategy
UNC-EMAQ(5-02)-007.v2
4-36
August 1, 2012
56. If you clear the entries in the Sort Order and Row Filter fields on the Data Viewer and
click Apply, all of the data records will be presented in the order in which they appear in
the database. More information about the columns included in the detailed result is given
in Table 4-9, which is discussed later in Section 4.5.1.
57. Close the Data Viewer when you are finished reviewing the Strategy Detailed Result.
58. From the Outputs tab, you can also access the properties (metadata) of an output dataset
(as opposed to the actual data contained in the output), and you can edit these properties.
To edit the output dataset properties, select an output (for training purposes, select the
Strategy Detailed Result) on the Outputs tab of the Edit Control Strategy window and
click the Edit button. This will bring up the Dataset Properties Editor for the output
dataset (Figure 4-19).
UNC-EMAQ(5-02)-007.v2
4-37
August 1, 2012
59. Notice that the tabs on the Dataset Properties Editor are the same as those on the Dataset
Properties Viewer shown in Figure 4-8, but with the editor you can actually change many
of the fields, whereas they could not be changed directly from the Dataset Properties
Viewer. For example, you can change the name of the output by replacing the
automatically generated name with a more meaningful one (e.g., Least Cost 2017 NOx
for Training Result) and then clicking Save. Notice that when you change the name, an
asterisk is added to the title bar of the window to indicate that something has been
changed but not yet saved. Throughout CoST and the EMF, if you change something
on a window and then try to close the window without saving the changes, you will
be prompted to confirm that you want to close without saving..
60. Examine the other tabs of the Dataset Properties Editor for the Strategy Detailed Result
output, in particular the Keywords tab, an example of which is shown in Figure 4-20. For
the Strategy Detailed Result, there are a number of keywords set in the Keywords
Specific to Dataset section (in the lower part of window). These keywords correspond
UNC-EMAQ(5-02)-007.v2
4-38
August 1, 2012
to the major parameters of the control strategy, such as the COST_YEAR and the
STRATEGY_TYPE (these specific keywords are available in the list of keywords but are
above the portion of the window shown in Figure 4-20). There are also keywords for the
UNCONTROLLED_EMISSIONS, the TOTAL_EMISSION_REDUCTION, and the
ACTUAL_PERCENT_REDUCTION.
Figure 4-20. Keywords Tab of Dataset Properties Editor
The keywords in the Keywords Specific to Dataset Type section (the upper part of
window in Figure 4-20) typically contain directives on how to export the data or other
data values that are the same for all datasets of the same type. Typically ORL inventories
will have some of these keywords.
61. Note that when you have the Dataset Properties Editor open for a dataset, no other
users can edit that dataset. Similarly, if you have a control strategy or control measure
UNC-EMAQ(5-02)-007.v2
4-39
August 1, 2012
open for editing, no other users can edit those items; users are able to view them,
however, if a view option is available.
When you are finished examining the other tabs, close the Dataset Properties Editor by
clicking Save if you wish to save the changes, or Close to close without saving changes.
If you are in the training class, click Close.
UNC-EMAQ(5-02)-007.v2
4-40
August 1, 2012
UNC-EMAQ(5-02)-007.v2
4-41
August 1, 2012
64. To run the summaries that are listed on the QA tab, first select the summaries of interest
and then click Edit. The Edit QA Step window will appear (Figure 4-23). You do not
actually need to edit anything in this window, just click Run to start the QA summary
processing.
Monitor the progress of the QA step in the Status window at the bottom of the EMF
main window. Once the run is complete, click the Refresh button to populate the Output
Name, Run Status, and Run Date fields in the Edit QA Step window. Note: as an
alternative to clicking Run on several different windows, you can instead select a few
summaries and click Run on the QA tab. However, at this time, you still need to open the
QA summaries using the Edit button when you want to view their results.
Figure 4-23. Edit QA Step Window to Create a Summary
65. To see the summarized output, click the View Results button to bring up the View QA
Step Results window (Figure 4-24). From this window, you can sort and filter the results
in the same way you can on the Control Measure Manager and Control Strategy
UNC-EMAQ(5-02)-007.v2
4-42
August 1, 2012
Manager. For example, click on the avg_cost_per_ton column header to sort on the
cost per ton. You can also show the Top N or Bottom N rows using the second and third
toolbar buttons from the left. The colorful toolbar buttons on the right support computing
statistics, creating plots (if you have the R software package installed on your client
machine), and saving the table and plot configurations.
Figure 4-24. View QA Step Results Window
66. If the summary you generated has the columns longitude and latitude (e.g., a plant, state,
or county summary), you can access an interface to create Google Earth-compatible
Keyhole Markup Language Zipped (.kmz) files by choosing Google Earth from the File
menu of the View QA Step Results window. The interface to create these files is shown
in Figure 4-25. Note that the following detailed result summaries have longitude and
latitude:
UNC-EMAQ(5-02)-007.v2
4-43
August 1, 2012
67. In the Create Google Earth file window, select a Label Column that will be used to label
the points in the .kmz file. This label will appear when you mouse over a point. For a
plant summary this would typically be plant_name, for a county summary this would be
county, for a state summary, this would be state_name.
UNC-EMAQ(5-02)-007.v2
4-44
August 1, 2012
68. If your file has data for multiple pollutants, you will often want to specify a filter so that
data for only one pollutant is included in the KMZ file. To do this, specify a Filter
Column (e.g., pollutant), and then specify a Filter Value (e.g., NOX).
69. Select a Data Column to specify the column to use to obtain the value when you mouse
over a point (e.g., total_emissions_reduction, total_annual_cost, or avg_cost_per_ton).
The mouse over information will have the form:
value from Label column : value from Data Column.
70. If you wish to limit the points shown in the file to include only those that reach a certain
size threshold (e.g., you do not want to show small sources or sources with a small
amount of reduction), you can specify a Minimum Data Cutoff. Points will only be
created for rows in the summary for which the value in the data column exceeds the value
given in minimum data cutoff. For example, if you selected total_emissions_reduction as
the Data Column, you might enter 1 as the minimum data cutoff to show only plants
with at least 1 ton of reduction.
71. If you wish to control the size of the points, you may adjust the value of the Icon Scale
setting to a number between 0 and 1. If this is your first time using the processor, we
recommend leaving it at the default setting of 0.3. Giving a value smaller than 0.3 will
result in smaller circles than the default and larger than 0.3 will result in larger circles.
72. If you are unsure of what some of the settings mean, place your mouse in the appropriate
field and a tooltip will appear that gives you some information about the field. Once you
have specified the settings (aside from the Properties file) click Generate and it will
create the .kmz file using default file name. The name and location of the created file can
be found on the Output File field.
If your computer has Google Earth installed (note that it is not installed on the training
laptops), you may open the created file in Google Earth by clicking Open.
If you find that you need to repeatedly create similar .kmz files, you may choose to click
Save to save the settings of the properties to a file. Once you have a file saved, you can
click Load the next time you enter the Create Google Earth file window so that you do
not have to type in all the properties again.
73. When you are done with the Create Google Earth file window, close the window by
clicking the X at the top right corner.
74. Back on the Edit QA Step window (Figure 4-23), you can export CSV files of the QA
step result to the EMF server. First, select a folder to export your results to by typing one
into the Export Folder field, or by clicking the Browse button. If desired, you can put
the files into your EMF temp directory.
75. Next, click the Export button, the Export QA Step Result will be exported to the EMF
server computer. It will be placed into the Export Folder specified on the Edit QA Step
window after you click the Export button.
UNC-EMAQ(5-02)-007.v2
4-45
August 1, 2012
UNC-EMAQ(5-02)-007.v2
4-46
August 1, 2012
UNC-EMAQ(5-02)-007.v2
4-47
August 1, 2012
UNC-EMAQ(5-02)-007.v2
4-48
August 1, 2012
79. To view the data for the controlled inventory, make sure the Controlled Inventory radio
button is still selected for non Least Cost strategy types (see Figure 4-28); for Least Cost
strategy types (see Figure 4-29), find the applicable Controlled Inventory result and make
UNC-EMAQ(5-02)-007.v2
4-49
August 1, 2012
sure the Result radio button is selected. Click the View Data button. The data for the
controlled inventory dataset will appear in the Data Viewer.
80. To view the data for the input inventory that was merged with the Strategy Detailed
Result to create the controlled inventory, select the Input Inventory radio button, click
View Data.
81. THIS CONCLUDES THE TRAINING EXERCISES IN SECTION 4. The
remainder of the section provides reference documentation on the outputs of strategies
and summaries that can be created. Advanced Exercises are available in Section 5.
Boiler Capacity (MW) from the design capacity column of the inventory; units are
obtained from the design_capacity_unit_numerator and
design_capacity_unit_denominator columns from the inventory. Note that boiler capacity
is often blank in inventories, so special steps may need to be taken to fill in this
information.
The stack flow rate provides information on the volume of effluent that requires treatment by the
control device. The capital annual ratio is used to calculate the capital costs of a control device
from an available O&M cost estimate for that device. The capital costs are the one-time costs to
purchase and install the device, while the operating and maintenance (O&M) costs are those
required to operate and maintain the device for each year. The discount rate and equipment life
are used to compute the annualized capital costs for the device. The discount rate can be
UNC-EMAQ(5-02)-007.v2
4-50
August 1, 2012
considered an annual interest rate used to calculate the cost of borrowing money to purchase and
install the control device. The annualized capital cost is computed based on the discount rate, and
the costs are spread over the life of the equipment. The algorithms to compute these cost
breakdowns vary based on whether the input data required to utilize a cost equation are available.
This topic is described in further detail in Table 4-9, which is given after an introductory
discussion of cost concepts, below. The columns of the Strategy Detailed Result are also given in
Table 4-9.
When cost data are provided for the control measures, the resulting costs are also specified in
terms of a particular year. To compute the cost results for a control strategy, it is necessary to
escalate or de-escalate the costs to the same year in order to adjust for inflation and to allow for
consistency in comparing control strategy results. This is done with the following formula:
Cost ($) for a year of interest = Cost for original cost year Chained GDP for year of interest
Chained GDP for original cost year
where the chained GDP is the chained Gross Domestic Product available from the United States
Department of Commerce Bureau of Economic Analysis spreadsheet at
http://www.bea.gov/national/xls/gdplev.xls. The current version used is dated January 30, 2009.
An excerpt of this version is shown in Table 4-8.
Table 4-8. Excerpt from the gdplev Table
Used to Convert Data between Cost Years
Year
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
Current_GDP Chained_GDP
7816.9
8328.9
8304.3
8703.5
8747
9066.9
9268.4
9470.3
9817
9817.0
10128
9890.7
10469.6
10048.8
10960.8
10301.0
11712.5
10675.8
12455.8
10989.5
13246.6
11294.8
13807.5
11523.9
14280.7
11671.3
To facilitate the comparison of the costs of control measures with one another, a normalized
version of the control measure cost per ton is stored within the control measures database. These
costs have all been converted to a consistent reference year using the above formula, so that
the cost of any measure can be compared with any other even if their cost years differ. Currently,
UNC-EMAQ(5-02)-007.v2
4-51
August 1, 2012
the reference year is 2006. In addition, during the course of the strategy run, the costs are
converted (using the above formula) from the reference year to the cost year that was specified as
an input to the strategy. The results of the strategy are therefore presented in terms of the
specified cost year.
As indicated above, Table 4-9 provides details on the columns of the Strategy Detailed Result.
Table 4-9. Columns in the Strategy Detailed Result
Column
DISABLE
Description
A true-false value that determines whether to disable the control
represented on this line during the creation of a controlled
inventory.
CM_ABBREV
The abbreviation for the control measure that was applied to the
source.
POLL
SCC
FIPS
PLANTID
For point sources, the plant ID for the source from the inventory.
POINTID
For point sources, the point ID for the source from the inventory.
STACKID
For point sources, the stack ID for the source from the inventory.
SEGMENT
For point sources, the segment for the source from the inventory.
The total annual cost (including both capital and O&M) required
to keep the measure on the source for a year.
ANNUAL_COST ($)
ANN_COST_PER_
TON ($/ton)
UNC-EMAQ(5-02)-007.v2
The annual cost (both capital and O&M) to reduce one ton of the
pollutant.
Ann_Cost_Per_Ton = Annual Cost ($) / Emis Reduction (tons)
4-52
August 1, 2012
Column
ANNUAL_OPER_
MAINT_COST ($)
Description
The annual cost to operate and maintain the measure once it has
been installed on the source.
a. Default Approach (used when there is no cost equation, or inputs to
cost equation are not available):
= (Annual Cost Annualized Capital Cost)
Note: if the capital recovery factor was not specified for the measure, it
would not be possible to compute Annualized Capital Cost or Annual
O&M Costs
b. Approach when Using Type 8 Cost Equation:
If Stack Flow Rate >= 5.0 cfm Then
= O&M Control Cost Factor x Stack Flow Rate (cfm) x Cost Yr
Chained GDP / Reference Yr Chained GDP
Else
= Default O&M Cost Per Ton Factor x Emission Reduction (tons) x
Cost Yr Chained GDP / Reference Yr Chained GDP
ANNUAL_VARIABLE
OPER_MAINT_COST ($)
ANNUAL_FIXED_
OPER_MAINT_COST ($)
The annual fixed cost to operate and maintain the measure once it
has been installed on the source.
a. Default Approach (used when there is no cost equation, or inputs to
cost equation are not available):
= blank (not calculated, no default approach available)
b. Approach when Using Type 10 Cost Equation:
= design_capacity x 1000 x
fixed_operation_maintenance_cost_multiplier (250 /
design_capacity) ^ fixed_operation_maintenance_cost_exponent x
Cost Yr Chained GDP / Reference Yr Chained GDP
UNC-EMAQ(5-02)-007.v2
4-53
August 1, 2012
Column
ANNUALIZED_
CAPITAL_COST ($)
Description
The annualized cost of installing the measure on the source
assuming a particular discount rate and equipment life.
Annualized_Capital_Cost = Total Capital Cost x Capital
Recovery Factor (CRF)
Note: if the CRF is not available for the measure, it is not possible
to compute the ACC or the breakdown of costs between capital
and O&M costs.
CRF = (Discount Rate x (1 + Discount Rate)^Equipment Life) /
((Discount Rate + 1) ^Equipment Life - 1)
TOTAL_CAPITAL_
COST ($)
CONTROL_EFF (%)
RULE_PEN (%)
RULE_EFF (%)
PERCENT_
REDUCTION (%)
The percent by which the emissions from the source are reduced
after the control measure has been applied.
Percent reduction = Control Efficiency (%) x Rule Penetration (%) /
100 x Rule Effectiveness (%) / 100
ADJ_FACTOR
INV_CTRL_EFF (%)
INV_RULE_PEN (%)
The rule penetration for the existing measure on the source, found
in the inventory.
UNC-EMAQ(5-02)-007.v2
4-54
August 1, 2012
Column
INV_RULE_EFF (%)
Description
The rule effectiveness for the existing measure on the source,
found in the inventory.
FINAL_EMISSIONS
(tons)
The final emission that results from the source being controlled.
EMIS_REDUCTION
(tons)
INV_EMISSIONS
(tons)
APPLY_ORDER
INPUT_EMIS (tons)
The emissions that still exist for the source after prior control
measures have been applied. Usually this is the same as
INV_EMISSIONS (see above), but for the Apply Measures In
Series strategy type, in which multiple measures are applied to
the same source, this is the emissions that are still available for the
source after all prior control measures have been applied.
OUTPUT_EMIS
(tons)
The emissions that still exist for the source after the current and
all prior control measures have been applied. Usually this is the
same as FINAL_EMISSIONS (see above), but for the Apply
Measures In Series strategy type, in which multiple measures are
applied to the same source, this is the emissions that are still
available for the source after the current and all prior control
measures have been applied.
FIPSST
FIPSCTY
SIC
NAICS
SOURCE_ID
The record number from the input inventory for this source.
The numeric ID of the input inventory dataset (for bookkeeping
purposes). If multiple inventories were merged to create the
inventory (as can be done for Least Cost strategies), this ID is that
of the merged inventory.
INPUT_DS_ID
CS_ID
CM_ID
UNC-EMAQ(5-02)-007.v2
4-55
August 1, 2012
Column
EQUATION TYPE
Description
The control measure equation that was used during the cost
calculations.
ORIGINAL_
DATASET_ID
SECTOR
The emissions sector specified for the input inventory (text, not an
ID number; e.g., ptnonipm for the point non-IPM sector)
CONTROL_
PROGRAM
XLOC
The longitude for the source, found in the inventory for point
sources; for nonpoint inventories the county centroid is used. This
is useful for mapping purposes.
YLOC
The latitude for the source, found in the inventory for point
sources; for nonpoint inventories the county centroid is used. This
is useful for mapping purposes.
PLANT
The plant name from the inventory (or county name for nonpoint
sources).
Indicates whether the measure was a replacement or an add-on
control.
A = Add-On Control
R = Replacement Control
This column is used when an Add-On Control was applied to a
source; it indicates the existing control measure abbreviation that
was on the source.
This column is used when an Add-On Control was applied to a
source; it indicates the existing control measure primary device
type code that was on the source.
The name of the control strategy that produced the detailed result.
Indicates the control technology of the control measure.
Indicates the source group of the control measure.
Information about this record and how it was produced; this
information is either created automatically by the system or
entered by the user.
REPLACEMENT_ADDON
EXISTING_MEASURE_
ABBREVIATION
EXISTING_PRIMARY_
DEVICE_TYPE_CODE
STRATEGY_NAME
CONTROL_TECHNOLOGY
SOURCE_GROUP
COMMENT
RECORD_ID
VERSION
DELETE_VERSIONS
UNC-EMAQ(5-02)-007.v2
4-56
August 1, 2012
pollutant, and control measure. This table contains information only for sources that were
controlled during the strategy run. It is generated by running a SQL statement that aggregates
the data from the Strategy Detailed Result according to the five categories just listed. The annual
cost and emission reduction are calculated by summing all costs and emission reductions for the
specified grouping (sector, FIPS, SCC, pollutant, and control measure). The average annual cost
per ton is calculated by dividing the total annual costs by the total emission reduction for each
measure. The columns contained in this summary and the formulas used to compute their values
are shown in Table 4-10. An example Strategy Measure Summary is shown in Table 4-14
(located at the end of Section 4.5).
Table 4-10. Columns in the Strategy Measure Summary
Column
SECTOR
Description
The sector for the source (e.g., ptnonipm for the point non-IPM
sector)
FIPS
SCC
POLL
CONTROL_MEASURE_
ABBREV
CONTROL_MEASURE
AVG_ANN_
COST_PER_TON
INPUT_EMIS
EMIS_REDUCTION
PCT_RED
UNC-EMAQ(5-02)-007.v2
4-57
August 1, 2012
Column
RECORD_ID
VERSION
DELETE_VERSIONS
Description
System specific columns used for tracking primary key and
versioning of data
Description
SECTOR
The emissions sector for the source (i.e., ptnonipm for the point
non-IPM emissions sector)
FIPS
POLL
UNCONTROLLED_EMIS The original inventory emission for the county (in tons)
EMIS_REDUCTION
REMAINING_EMIS
PCT_RED
ANNUAL_COST
ANNUAL_OPER_
MAINT_COST
ANNUALIZED_
CAPITAL_COST
The total annualized capital costs for the county. This is calculated
by summing the annualized capital costs for the county
= sum(annualized_capital_cost)
TOTAL_CAPITAL_
COST
AVG_ANN_
COST_PER_TON
UNC-EMAQ(5-02)-007.v2
4-58
August 1, 2012
Column
RECORD_ID
VERSION
DELETE_VERSIONS
Description
= sum(annual_cost) / sum(emis_reduction)
System specific columns used for tracking primary key and
versioning of data
CURRENT COST: The annualized cost for that source for the most recent control
strategy that was applied to the source.
TOTAL COST: The total cost for the source across all measures that have been
applied to the source.
In this way, the controlled inventories created by CoST always specify the relevant information
about the measures that have been applied as a result of a CoST control strategy.
The columns of the Strategy Messages output are described in Table 4-12. An example Strategy
Messages output is shown in Table 4-13.
UNC-EMAQ(5-02)-007.v2
4-59
August 1, 2012
Description
The state and county FIPS code for the source, found in the
inventory
The SCC code for the source, found in the inventory
For point sources, the plant ID for the source from the
inventory.
POINTID
For point sources, the point ID for the source from the
inventory.
STACKID
For point sources, the stack ID for the source from the
inventory.
SEGMENT
For point sources, the segment for the source from the
inventory.
POLL
STATUS
CONTROL_
PROGRAM
MESSAGE
MESSAGE_TYPE
INVENTORY PACKET_FIPS
PACKET_SCC
PACKET_PLANTID
PACKET_POINTID
PACKET_STACKID
PACKET_SEGMENT
PACKET_POLL, PACKET_SIC
PACKET_MACT
PACKET_NAICS
PACKET_COMPLIANCE_DATE
RECORD_ID
VERSION
DELETE_VERSIONS
UNC-EMAQ(5-02)-007.v2
4-60
August 1, 2012
scc
plantid
UNC-EMAQ(5-02)-007.v2
S942
status
PM2_5 Warning
4-61
control_
program
message
Emission reduction is
negative, -1693.9.
August 1, 2012
FIPS
SCC
POLL
CONTROL_
MEASURE_
ABBREV
ptnonipm
37001
10200906 PM10
PFFPJIBWD
ptnonipm
37001
10200906 PM2_5
PFFPJIBWD
ptnonipm
37001
30500311 PM10
PFFPJMIOR
ptnonipm
37001
30500311 PM2_5
PFFPJMIOR
ptnonipm
37001
30501110 PM10
PFFPJMIOR
ptnonipm
37001
30501110 PM2_5
PFFPJMIOR
CONTROL_ MEASURE
Fabric Filter (Pulse Jet
Type);(PM10) Industrial
Boilers - Wood
Fabric Filter (Pulse Jet
Type);(PM10) Industrial
Boilers - Wood
Fabric Filter (Pulse Jet
Type);(PM10) Mineral
Products - Other
Fabric Filter (Pulse Jet
Type);(PM10) Mineral
Products - Other
Fabric Filter (Pulse Jet
Type);(PM10) Mineral
Products - Other
Fabric Filter (Pulse Jet
Type);(PM10) Mineral
Products - Other
CONTROL_
SOURCE_
TECHNOLOGY GROUP
Fabric Filter
(Pulse Jet Type)
Fabric Filter
(Pulse Jet Type)
Fabric Filter
(Pulse Jet Type)
Fabric Filter
(Pulse Jet Type)
Fabric Filter
(Pulse Jet Type)
Fabric Filter
(Pulse Jet Type)
Industrial
Boilers Wood
Industrial
Boilers Wood
Mineral
Products Other
Mineral
Products Other
Mineral
Products Other
Mineral
Products Other
AVG_
ANN_
ANNUAL_
COST_
COST
PER_
TON
$419,294
$12,862
EMIS_
REDUCTION
32.6007
19.5426
$446,026
$83,379
5.3494
2.0939
$110
$147
0.7498
0.2605
POLL
EMIS_
REMAINING_ PCT_
REDUCT
EMIS
RED
ION
313.8724
313.8724
ptnonipm
37001 VOC
ptnonipm
37001 PM2_5
ptnonipm
37001 NH3
6.9128
6.9128
ptnonipm
37001 NOX
146.2904
146.2904
ptnonipm
37001 PM10
51.0928
ptnonipm
37001 SO2
54.3864
UNC-EMAQ(5-02)-007.v1
ANNUAL_
ANNUALIZED TOTAL_
AVG_ ANN_
ANNUAL_
OPER_
_CAPITAL_
CAPITAL_ COST_
COST
MAINT_COST COST
COST
PER_TON
INPUT_
EMIS
33.4717
33.2505
50.7019
0.2212 99.3391
0.3909 99.2349
$865,430
$746,831
$83,300
$882,489
$22,363
54.3864
4-62
August 1, 2012
Note that the summaries with Descriptions have more information than the ones without. For
example, the Summarize by SCC and Pollutant with Descriptions summary includes the SCC
description in addition to the pollutant description. The disadvantage to include the descriptions
is that they are a bit slower to generate because information has to be brought in from additional
tables than the table being summarized.
Each of the summaries is created using a customized SQL syntax that is very similar to standard
SQL, except that it includes some EMF-specific concepts that allow the queries to be defined
generally and then applied to specific datasets as needed. An example of the customized syntax
for the "Summarize by SCC and Pollutant" query is:
UNC-EMAQ(5-02)-007.v2
4-63
August 1, 2012
"select SCC, POLL, sum(ann_emis) as ann_emis from $TABLE[1] e group by SCC, POLL
order by SCC, POLL"
Notice that the only difference between this and standard SQL is the use of the $TABLE[1]
syntax. When this query is run, the $TABLE[1] portion of the query is replaced with the table
name used to contain the data in the EMF. Note that most datasets have their own tables in the
EMF schema, so you do not normally need to worry about selecting only the records for the
specific dataset of interest. The customized syntax also has extensions to refer to another dataset
and to refer to specific versions of other datasets using tokens other than $TABLE. For the
purposes of this discussion, it is sufficient to note that these other extensions exist.
Some of the summaries are constructed using more complex queries that join information from
other tables, such as the SCC descriptions, the pollutant descriptions (which are particularly
useful for HAPs), and to account for any missing descriptions. For example, the syntax for the
"Summarize by SCC and Pollutant with Descriptions" query is:
"select e.SCC, coalesce(s.scc_description,'AN UNSPECIFIED DESCRIPTION')::character
varying(248) as scc_description, e.POLL, coalesce(p.descrptn,'AN UNSPECIFIED
DESCRIPTION')::character varying(11) as pollutant_code_desc, coalesce(p.name,'AN
UNSPECIFIED SMOKE NAME')::character varying(11) as smoke_name,p.factor, p.voctog,
p.species, coalesce(sum(ann_emis), 0) as ann_emis, coalesce(sum(avd_emis), 0) as avd_emis
from $TABLE[1] e left outer join reference.invtable p on e.POLL=p.cas left outer join
reference.scc s on e.SCC=s.scc group by e.SCC,e.POLL,p.descrptn,s.scc_description,
p.name, p.factor,p.voctog, p.species order by e.SCC, p.name
This query is quite a bit more complex, but is still supported by the EMF QA step processing
system. In addition to summaries of the inventories, there are many summaries available for the
Strategy Detailed Results output by control strategy runs and for some of the other CoST-related
dataset types. Some of the summaries available for Strategy Detailed Results are as follows:
"Summarize by Pollutant"
"Summarize by County and Pollutant"
"Summarize by SCC and Pollutant"
"Summarize by Control Technology and Pollutant"
"Summarize by Control Measure and Pollutant"
"Summarize by Source Group and Pollutant"
"Summarize by U.S. State and Pollutant"
"Summarize by State, SCC, and Control Technology"
"Summarize by Control Technology, FIPS, and SCC"
"Summarize by Control Program, U.S. State and Pollutant"
"Summarize by Plant and Pollutant"
"Summarize all Control Measures"
"Summarize by Sector and Pollutant with Descriptions"
"Summarize by Sector, U.S. State, and Pollutant"
UNC-EMAQ(5-02)-007.v2
4-64
August 1, 2012
A plot created based the output of a Summarize by Control Technology and Pollutant summary
is shown in Figure 4-28.
Figure 4-30. Control Technologies used within a Least Cost Analysis
When multiple datasets need to be considered in a summary (e.g., to compare two inventories),
the EMF QA Program mechanism is used. The QA programs each have customized user
interfaces that allow users to select the datasets to be used in the query. Some of the following
QA programs may prove useful to CoST users:
"Multi-inventory sum": takes multiple inventories as input and reports the sum of
emissions from all inventories
"Multi-inventory column report": takes multiple inventories as input and shows the
emissions from each inventory in separate columns
"Multi-inventory difference report": takes two sets of inventories as input, sums each
inventory, and then computes the difference between the two sums
"Compare Control Strategies": compares the data available in the Strategy Detailed
Result datasets output from two control strategies
Summaries can be mapped with geographic information systems (GIS), mapping tools, and
Google Earth. To facilitate this mapping, many of the summaries that have with Descriptions
in their names include latitude and longitude information. For plant-level summaries, the latitude
and longitude provided are the average of all the values given for the specific combination of
UNC-EMAQ(5-02)-007.v2
4-65
August 1, 2012
FIPS and PLANT_ID. For county- and state-level summaries, the latitude and longitude are the
centroid values specified in the fips table of the EMF reference schema.
It is useful to note that after the summaries have been created, they can be exported to CSV files.
By clicking View Results, the summary results can be viewed in a table called the Analysis
Engine that does sorting, filtering, and plotting. From the File menu of the Analysis Engine
window, a compressed .kmz file can be created and subsequently loaded into Google Earth. Note
that each KMZ file is currently provided with a single latitude and longitude coordinate
representing its centroid, even for geographic shapes like counties.
Recall that in addition to the datasets output for control strategies, many types of summaries of
these datasets can be created in CoST (see Section 2.7). Figure 11 shows a plot that can be
created by summarizing a Least Cost Strategy Detailed Result using the "Summarize by Control
Technology and Pollutant" query. Some of the technologies used in this run were Low NOx
burners (LNB), Low NOx burners with Flue Gas Recovery (LNB + FGD), Non-Selective
Catalytic Reduction (NSCR), and Selective Non-catalytic Reduction (SNCR). Note that Figure
11 was generated by plotting data output from CoST with spreadsheet software, and not by CoST
itself. CoST does have some plotting capabilities, but they are not discussed in this document.
UNC-EMAQ(5-02)-007.v2
4-66
August 1, 2012
use the Edit Data button to create new versions of the dataset,
use the Export button to export the data to a file on the EMF server,
UNC-EMAQ(5-02)-007.v2
5-1
August 1, 2012
use the Purge button to purge datasets that were removed from the system,
Average CPT:
Average CPT:
7. What are some of the SCCs for sources that had control measures applied in the result,
but had a control efficiency of less than 90%? [It is important to note these because they
may provide opportunities for controls] Hint: Examine the Strategy Detailed Result
and apply a filter for CONTROL_EFF<90 to find the applicable rows.
SCCs with CE < 90%:
UNC-EMAQ(5-02)-007.v2
5-2
August 1, 2012
7. Based on the results of this strategy, how much additional emissions reduction could
you get over the previous maximum reduction result if there was a control measure with a
95% CE available for sources with SCCs starting with 102, such as the one you created?
UNC-EMAQ(5-02)-007.v2
5-3
August 1, 2012
UNC-EMAQ(5-02)-007.v2
6-1
August 1, 2012
7 References
Eyth, A.M., D. Del Vecchio, D. Yang, D. Misenheimer, D. Weatherhead, L. Sorrels, Recent
Applications of the Control Strategy Tool (CoST) within the Emissions Modeling
Framework, 17th Annual Emissions inventory Conference, Portland, OR, 2008.
Houyoux, M.R., M. Strum, R. Mason, A. Eyth, A. Zubrow, C. Allen, Using SMOKE from the
Emissions Modeling Framework, 17th Annual Emissions inventory Conference, Portland,
OR, 2008.
Misenheimer, D.C., A New Tool for Integrated Emissions and Controls Strategies Analysis,
16th Annual Emissions inventory Conference, Raleigh, NC, 2007.
UNC-EMAQ(5-02)-007.v2
7-1
August 1, 2012