Environmental Protection Agency SourceDK Overview  

SourceDK is a decision support tool for developing a screening-level model to estimate groundwater remediation timeframes and associated uncertainties at sites where groundwater is contaminated by a source in the unsaturated zone. This software is programmed in a Microsoft Excel spreadsheet and provides a graphic output of cleanup time based on the sampling results. SourcDK interfaces with MAROS and BIOSCREEN.

Home

 SourceDK Home Site
Functions
  • Analytical Modeling (Tier 1)
  • Remedial Process Selection
    		•
    Input
  • Tabular File: *.xls
  • Graphical File: NA
    		•  Output
    • Tabular File: NA
    • Graphical File:NA
    • Print Report: No
    Contaminants
    • Chlorinated Solvents
    • SVOCs
    • Pesticides/PCBs
    • Petroleum
    		 Media
    • Groundwater
    Technical Team Members
    • Hydrogeologist
    • General technical staff familiar with chemical fate and transport
    Comments  
     
    SourceDK - data loading
    • SourceDK is downloaded as a zip file that includes SourceDK help file, pdf file of users manual, and main SourceDK Excel file.
    • SourceDK requires user to change the level of macro security (in Microsoft Excel) to enable macros in the file.
    • Manual data entry is the easiest method to load data to SourceDK.
    • The process for copying and pasting data from an external Excel worksheet into SourceDK is explained on page 13 of the user's guide, however, versions of Excel that are newer than Excel 2000 may require a different procedure. For instance, copying and pasting data from an Excel 2003 workbook only requires that the user right-click in the cell and "paste." The cells first appear to be merged into a single cell, but the proper formatting is established after the user selects a chemical and action level in Step 2.
    • Regardless of the version, the Excel program must be opened a second time before the source data file is opened (you cannot just open the data file while in the SourceDK spreadsheet).
    • Because SourceDK is a Microsoft Excel spreadsheet, it is easy to download and does not require additional data field naming.
    SourceDK - graphic loading
    • Not applicable.
    SourceDK - logical flow
    • The program contains a logical flow pattern that a novice can use to create an output graph and estimated remediation timeframe in Tier 1.
    • The output graph for the Tier 1 worksheet will plot in the same units that were used to enter data to the graph. Although a window above the graph allows the user to select between milligrams per liter (mg/L) and micrograms per liter (μg/L), this selection only affects the labels on the graph's axis, it does not convert the data from set of units to the other.
    SourceDK - expert knowledge
    • The program requires expert knowledge of hydrogeology to calculate the Darcy velocity and other input data.
    • Tier 1 data results are simple to understand.
    SourceDK - functionality
    • Interfaces with MAROS and BIOSCREEN.
    • When entering data, zero is not accepted as a number.
    • Microsoft Excel spreadsheet is set up in a manner that is not always convenient to work with. For instance, tabbing over takes user to the next cell, not to the next data entry item. If user enters an incorrect character, the user must clear the entire cell and start over.
    • Tier 2 is not linked to information in Tier 1.
    SourceDK - technical application
    • According to the users manual, SourceDK is not designed to simulate the effects of chemical diffusion.
    • According to the users manual, in Tier 2, SourceDK assumes that all the biodegradation takes place in the dissolved phase and acts only on dissolved constituents.
    SourceDK - documentation
    • Help guide and users manual are comprehensive and give clear directions on how to use the system.
    • The users manual clearly outlines the uses and limitations of this tool.
    SourceDK - output
    • Saves information so that the user may come back to the system and finish.
    • Does not produce a report.
    • Data cannot be exported into another format, although a "sample history" or listing of sampling can be printed.
    SourceDK - sources
    • Version 1.0 downloaded November 1, 2004.
    Note that this DST matrix is under active construction. Comments and suggestions about the structure
    or content of this website should be sent to Mike Adam .
    This web site contains technology information from private contractors and government agencies and is for informational purposes only. EPA cannot guarantee the accuracy or completeness of the data. Reference to any specific commercial product, process, or service, by trade name, trademark, manufacturer, or otherwise, does not constitute or imply the endorsement, recommendation, or favor of the United States Government.