&EPA
United States
Environmental Protection
Agency
                       I : :
               ov
QUICK
REFERENCE
GUIDE

WHEAT Version 3.0
                  o
                   "O
                    o

                       o
O -
                    a
                    o
                       WHE/iT
                       Uf ATE D Health & Economic
                       WAI En/
                    \. Analysis Tool

-------
          The Water Health and Economic Analysis Tool (WHEAT): Quick Reference Guide
Installing WHEAT 3.0
Installing from a download

   •   Download the WHEAT file into a folder on your computer.
   •   Double click on the file WHEAT3.exe to start the setup wizard. Follow the prompts and click
       "Next" to move to the next screen in the wizard.
   •   The second screen will prompt you to install WHEAT in a default location (in most cases, the
       default will be your C drive). It is recommended that you use the default locations for the
       program installation.
   •   Continue through the wizard and click "Install."
   •   During installation, a WHEAT icon will be placed on your desktop and a new program file listing
       will be created, WHEAT / WHEAT 3.0.
   •   After the installation, the wizard will alert you to install the MS compatibility pack if your
       version of MS Excel is prior to 2007. The compatibility pack must be installed prior to viewing
       output reports, but does not need to be installed immediately after WHEAT installation. The
       compatibility pack is available from Microsoft at
       http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE-8F43-
       C6BB74CD1466&displavlang=en.

   •   Click "Finish" to complete the installation process.

Installing from a CD

   •   Open the CD with Windows Explorer
   •   Double click on the file WHEAT3.exe to start the setup wizard. Follow the prompts and click
       "Next" to move to the next screen in the wizard.
   •   The second screen will prompt you to install WHEAT in a default location (in most cases, the
       default will be your C drive). It is recommended that you use the default locations for the
       program installation.
   •   Continue through the wizard and click "Install."
   •   A WHEAT icon will be placed on your desktop during the installation and a new program file
       listing will be created, WHEAT / WHEAT 3.0.
   •   After the installation, the wizard will alert you to install the MS compatibility pack if your
       version of MS Excel is prior to 2007. The compatibility pack must be installed prior to viewing
       output reports, but does not need to be installed immediately after WHEAT installation. The
       compatibility pack is available from Microsoft at
       http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE-8F43-
       C6BB74CD1466&displavlang=en.

   •   Click "Finish" to complete the installation process.

-------
           The Water Health and Economic Analysis Tool (WHEAT): Quick Reference Guide
Opening WHEAT 3.0
       Double click on the program icon located on your desktop or go to Start / Programs / WHEAT /
       WHEATS.0 and click on the program name.
WHEAT Home Screen
The home screen provides a
brief description of the purpose
of WHEAT and enables you to
access WHEAT process steps.
Begin your WHEAT analysis by
clicking "Analysis." You can also
access WHEAT resources and the
help function by clicking the
buttons at the bottom of the
screen.
WHEAT provides water and
estimating the economic and
assesses risKs resulting fr
provides an analysis of liKely c
countermeasuresto improve
funding for future infrastrii.-turs in
WHEAT Overview
WHEAT assists drinking water and wastewater utility (water sector) owners and operators in quantifying
the utility-level costs, public health impacts and local economic impacts of an adverse event in the water
sector. WHEAT guides users through a consequence analysis by asking simple questions about a user-
defined scenario.

To begin your analysis, select your utility type (drinking water or wastewater) and select a type of
scenario for analysis (loss of assets, hazardous gas release or contamination event [drinking water only]).
You will then provide inputs to characterize your system and establish your baseline. Then you will
answer questions provided by WHEAT to specify details of the scenario selected. WHEAT then generates
order of magnitude estimates of impacts to the utility, represented by public health (injuries and fatalities)
and economic (utility-level and regional) consequences. WHEAT then produces a report summarizing the
baseline, scenario and consequence analysis results.

-------
            The Water Health and Economic Analysis Tool (WHEAT): Quick Reference Guide


WHEAT Interface
The WHEAT interface is simple and easy to use.
                   System and Scenario Selection
                      The choice of system type and scenario type should be cased on an assessment of now your chosen scenario is expected to
                      impact your utility. If you are a combined water and wastewater utility, select the system type associated with the system assets
                      expected to be impacted by the scenano.
                    Resources
                       Menu
                                          Drinking Water        '« Wastewa
                      Select the "Loss of Operating Assets" scenario to analyze the consequences of one or more system assets becoming
                      non-operational. Select the "Hazardous Gas Release" scenario option if you expect the chosen scenario to result in the release
                      of gases stored at your facility (this scenano option also allows for the loss of system assets). Select "Contamination" to view
                      order of magnitude estimates of drinking water contamination impacts, which water systems can use for risk management
                      planning when site specific modeling is not feasible.
After you begin your analysis, the screens in WHEAT (the System and Scenario Selection screen is
shown above) are made up of three areas:

        Content Area
        The middle of the screen contains the majority of the program working area. In the content area,
        you will be making selections and inputting data relevant to your analysis.
        Navigation Area
        The bottom right of the window contains buttons to navigate to the next step, previous step or to
        cancel the analysis. Buttons for Home, Help and Resources can be found to the left of these
        navigation buttons.
        Resources Menu
        The left-hand bar labeled WHEAT Resources will open a menu where you can view three
        resources: a User's Guide, Technical Documentation and a Case Study. Descriptions of these
        resources can be found in the "Resources" section below. These documents can provide further
        assistance about the use and methodologies behind WHEAT calculations.

-------
           The Water Health and Economic Analysis Tool (WHEAT): Quick Reference Guide
Help Icon
       At the bottom left of each screen is a help icon ( Btfl). Clicking on this icon displays additional
       information directly related to the screen you are viewing.
                  '_%• WHEA-

Contents Index | Search \f\<\>




2 Welcome to WHEAT
2 Glossary
2 WHEAT Documentation
2 Other Tools
2 Accessibility Shortcuts
B 12) Create Analysis
|2 System and Scenario E
EH
EB<
EH









^ Baseline Inputs
fe Release of a Hazardous G
i Identify Assets
2 Service Loss Profile (Drinki
2 Service Loss Profile [Waste
2 Service Loss Profile Sumnn
2 Service Loss Profile Summ
2 Wastewater Treatment Pla
2 Additional Costs (Drinking *
?] Additional Costs (Wastewa
2 Run Analysis
2 Drinking Water Contaminai
t \ ni | \
1



















                                          System and Scenario
                                          Selection
                                               On this screen, select the type of
                                               system and scenario being analyzed.

                                               There are two system choices:

                                               • Drinking water system

                                               • Wastewater system

                                               There are three scenario choices:

                                               • Loss of assets - Analyze the
                                                 consequences of one or more
                                                 system assets becoming non-
                                                 operational, including both the
                                                 potential cost of asset replacement
                                                 and/or impacts associated with
                                                 service disruptions.

                                               • Hazardous gas - Analyze the
       The right half of the window provides detailed instructions and information. The left half of the
       window provides a table of contents of the available help materials.
The User's Guide, Technical Documentation and Zenith City Case Study are all located under the
WHEAT Resources menu bar shown on the left-hand side of the screen or by clicking on the Resources
button icon (jpsj ) on the bottom left of the screen. Descriptions of these resources are below.
    The User's Guide outlines the steps involved in stepping through a WHEAT analysis and provides
    additional detail on various concepts used throughout the tool.
    The Technical Documentation provide users with a thorough explanation of how WHEAT works and
    the methodology behind each function within the tool, including how user inputs are inserted into
    calculations.
    The Zenith City Case Study provide users with guidance on how to translate the concept of a "what
    if scenario (or hypothetical sequence of events) into quantifiable inputs using case study examples.

-------
           The Water Health and Economic Analysis Tool (WHEAT): Quick Reference Guide
The following table shows the locations where WHEAT files will be stored. Program files are those files
that are used to run the WHEAT software. Analysis files are the user-generated files that are created by
conducting a consequence analysis. The file locations shown assume a hard disk with the drive letter C,
but can be another drive you choose during installation.

Program file
(WHEAT3.exe)
Analysis Files
Windows XP
C:\Program Files\WHEAT3
Includes subdirectories of
• Analyses
• Database
• Help
• Intl
• XL Template
C:\Program
Files\WHEAT3\Analyses
Windows 7
C:\Program Files (x86)\WHEAT3
Includes subdirectories of
• Analyses
• Database
• Help
• Intl
• XL Template
C:\Program Files
(x86)\WHEAT\Analyses
Office of Water (4608T)
EPA 817-F-14-004
       5

May 2014

-------