Assessing Soil and Groundwater Impacts of Chemical Mixture Releases from Hazardous Materials Transportation Incidents (2010) / Chapter Skim
Currently Skimming:
Appendix M - User Operational Manual
Appendix M - User Operational Manual
Pages 32-53
The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.
From page 32... ...
32 A P P E N D I X M User Operational Manual
|
From page 33... ...
43 4.4. Emergency Response Guidebook (ERG 2008)
|
From page 34... ...
, requiring Excel Macros to operate. Macros are written inside the tool to operate the toolbar buttons or help icons and repeat the steps of common calculations.
|
From page 35... ...
. Select the following: "Menu," then "Tools," then "Options," then "Security," and then click on "Macro Security." Lower the security level to "Medium or Low." This step requires that the user restart the Excel Software and reopen the Chemical Mixture Tool.
|
From page 36... ...
TOOL INPUT AND EXECUTION 3.1. Tool Input Parameters Interface and Help Button
|
From page 37... ...
3. Run: Begins the calculation process and produces output.
|
From page 38... ...
The drop down menu will allow you to limit the way in which you search the registry to items which begin with your data entry, items which end with your data entry, or items which contain your data entry at any point. After completing it, click the "Search" button on this form, and results will be displayed (note: entering nothing in the input box will result in all items in the registry being returned alphanumerically)
|
From page 39... ...
The default output page will provide a summary table of the fate and transport property parameters of your input mixture as well as a number of calculated values further to the right of what is shown here. In addition, there are four buttons (1 through 4)
|
From page 40... ...
• The Red color represents the ratio of the property greater than 10.0, indicating that the chemical mixture may have a dramatic effect on the property of a component. • The Blue color highlights the major mixture NAPL transport properties in the unsaturated zone.
|
From page 42... ...
It should be noted that even though the color change from green to red indicates the severity of the property change of a component in a mixture compared to its pure phase, the red color does not guarantee the mixture is not acceptable considering the uncertainty of the tool.
|
From page 43... ...
is designed to simulate a component plume in a saturated groundwater aquifer with default hydrogeologic characteristics. Select any component and then click the "Go to Component Plume" button and it will take the user to an interface of the Domenico Analytical Model designed by the research team, where a plume of the component is shown.
|
From page 45... ...
DOT Hazardous Class and United Nations Identification Number (UN#) assigned to the component for proper shipping as shown below.
|
From page 46... ...
"Medium" is the recommended setting which will result in the prompt mentioned above. A higher security setting will not allow the tool to run, and a lower security setting may allow potentially malicious macros to run without prompting, if the user is concerned.
|
From page 47... ...
, which will allow access to a number of application settings. On the next window, navigate first to the "Trust Center" (1)
|
From page 48... ...
If it fails to turn on the ERROR Function in the Analysis Toolpak, a note will show as pictured below. If this function is not available, the data source calculations for the plume will result in "#VALUE!
|
From page 49... ...
From this menu, check the boxes next to both "Analysis ToolPak" and "Analysis ToolPak – VBA," then click OK. Close Excel and reopen it, then run the Chemical Mixture Tool; the issue associated with the screening model plumes should be gone.
|
From page 51... ...
which will allow access to a number of application-wide settings. Once the "Options" window is open, select the "Add-Ins" tab on the right.
|
From page 52... ...
Doublecheck to make certain that all of the input cells required for your run have data. In addition, as described in 5.2, the ERROR Function required for the Screening Model may cause this issue (Please see the troubleshooting section 5.1 for detailed assistance)
|
From page 53... ...
This tool's main limitation is that it cannot be used for all chemical substances, with the database of 740 components derived from literary research and interviews with professional personnel based on hazardous material classification and commodity flow survey and incident reports. The intended application domain is for liquid organic chemicals, particularly petroleum and related compounds.
|
Key Terms
This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More
information on Chapter Skim is available.