In addition to the Pollutant Cycle and Hydrologic Cycle reports, SEVIEW can be used to extract any monthly SESOIL results. This method can also be used to extract monthly input parameters. SEVIEW can be used to extract select results for evaluation. Click on
the Extract Data command on the Pollutant Cycle Toolbar. A window displaying all the monthly input data and results will open.
A listing of contaminant mass process by the SESOIL model are presented in Table 10 Contaminant Mass (μg) Processes in the Output File.
A listing of the concentrations produced by the SESOIL model are presented in Table 11.
To extract the concentration adsorbed on soil in the second soil layer move to the “SOIL ZONE 2: SUBLAYER 1 ADSORBED” row of the window. Click on the small rectangle located at the beginning of the row and it will turn black.
9.4.5.2 Export Spreadsheet
Click Export Spreadsheet command located on the Pollutant Cycle Report toolbar. Save the spreadsheet table as a tab delimited .txt file. Open the .txt file using Excel and plat the data.
9.4.5.3 Sum Data
Mass within a SESOIL output file can be distributed in up to 564 monthly data sets. SEVIEW can be used to sum multiple data sets creating new SESOIL data sets. The summation of SESOIL data is one of the most powerful commands within SEVIEW; as individual SESOIL data sets may be summed to create additional data sets. For example, you could sum the data sets for the mass volatilized, in soil air, adsorbed on soil, contained in soil moisture and in groundwater runoff for all layers and sub-layers within the SESOIL output file. Or you could restrict the summation to the mass in soil moisture contained all sub-layers of a layer.
Use the sum data command to combine data sets. For example to look at the montly contaminant mass contained in soil moisture in layer 2. You will need to combine the soil moisture mass contained in all ten sub-layers. Click on the Sum Data command on the Pollutant Cycle Toolbar. Use the scrool bar to move through window until you see the “SOIL ZONE 2” data. Highlight the SOIL ZONE 2 text and press <CTRL + C> to copy the text to the clipboard.
Then close the window and a second window will appear. This time highlight the “IN SOIL MOI” data. Highlight the IN SOIL MOI text and press <CTRL + C> to copy the text to the clipboard.
When you close the second window SEVIEW will create a new monthly data set “SOIL ZONE 2 IN SOIL MOI”. Close the third window and click on the Extract Data
command on the Pollutant Cycle Toolbar. Click on the small rectangle at the start of the “SOIL ZONE 2 IN SOIL MOI” row and close the window. Finaly save it as a tab
9.4.5.4 View Spreadsheet
Use this option to view the contants of the SEVIEW spreadsheet.
The spreadsheet will already contain the data use to produce the Pollutant
Cycle Report.
9.4.5.5 SESOIL Summary
SEVIEW produces a SESOIL summary every time you view a pollutant cycle report. This summary table looks like an Excel spreadsheet. The summary table includes the description of the SESOIL scenario, the SESOIL output file used, the percent of the mass contained or lost in each of the SESOIL process, the percent of the total mass accounted for in the last month, a contaminant migration rate, a travel time to the water table, the maximum SESOIL leachate concentration, the infiltration rate at the month of the maximum leachate concentration and the year of the maximum concentration. The summary table also includes several SESOIL parameters that are often used to determine dilution in groundwater.
You can use the Delete All, Remove Deleted and Restore All commands to control the data within the summary table.
You can export the summary table using the Save As command.
9.4.5.6 Export Summary
The SEVIEW summary table of the SESOIL results can be saved in a number of different file formats. Once converted the table it can be used in spreadsheet programs to calculate groundwater dilution or in word processors programs to summarize the modeling results. The summary table can be converted to any of the following file formats presented in below.
Table 6 Export File Formats
File Type Default Extension
Excel Version 5 .XLS
LOTUS .WK1
LOTUS .WKS
Symphony .WR1
Symphony .WRK
ASCII Tab Delimited File (.TXT) ASCII Comma Delimited .PRN
FoxPro 2.x .DBF
Table 7 SESOIL Summary Table Output File Volatilized In Soil Air Ads on Soil In Soil Moisture Total Mass Migration Rate Travel Time to Groundwater Maximum Leachate Conc. Year of Maximum Conc.
units % % % % % cm/year years mg/L years S01 99.61 0.00 0.00 0.00 99.98 776.90/5.08 5.08 0.001037 5.42 S03 93.05 0.00 0.03 0.01 99.98 573.90/4.08 4.08 0.047911 4.25
The File format option produces a tab delimited ASCII file with a .TXT extension.