CS Software User Manual 1.0
Contents
1. Groundwater Protection amp CoronaScreen Restoration Group A Spreadsheet Tool for the Prediction of Contaminant Plume Length in Groundwater Version 1 0 Software User Manual 2005 Authors Arne H ttmann and Steven F Thornton Groundwater Protection and Restoration Group Dept of Civil and Structural Engineering University of Sheffield Mappin Street Sheffield S1 3JD United Kingdom This user manual and the associated user guides for the models included within the CORONA Screen decision support spreadsheet tool were prepared as part of the CORONA project funded by the European Commission under the Fifth Framework programme contract number EVK1 CT 2001 00087 The information contained in this user manual is copyright to the authors Contents 1 PUFPOSE OF this USERS VE AMUN cise scscsssets cae ceecswiescedsccauecaunceancdevosUecenacisvecstostuesnasseseassoctuaesneenveuase 1 De SOU WATE RE GUITE menisi coverin recasso cass andevsvcucestcctoes eveced E EA EE ia 1 Ds EMS Call ACI OM bs sces2. Figure 4 Dialog boxes for managing contaminants and adding contaminants to the database 5 3 2 2 Add new contaminant to database dialog On the Add contaminant dialog a description of the input fields is displayed in the text box at the bottom when the cursor is active in a field Before adding a new compound to the database it is recommended to view the details of existing contaminants to see an example showing the required formats for the fields The first four input fields are compulsory the user will be alerted if data is missing The last two fields are optional However they should be completed where possible as they provide a further description of the compound in the case of the chemical formula or are relevant for additional calculations the carbon balance in the Electron Balance Model The only characters allowed in the contaminant name are letters of the English alphabet the underscore and numbers except for the first character Examples of input data needs and styles for new organic contaminants and electron acceptors included in the plume source term composition using the Add Delete contaminants tool bar are shown in Appendix I 5 3 2 3 Dialog settings for Calculations settings The Calculations settings dialog box allows the user to switch models on or off and change the way values of aquifer dispersivity are calculated by CS Figure 5 Calculations for the Electron Balance
3. For the spreadsheet to function properly macros need to be enabled in Excel The security level in Tools gt Macro gt Security menu has to be set to Medium recommended or Low on the Security Level tab Figure 1 to enable the macros included in the workbook On the Trusted Sources tab tick the box Trust all installed add ins and templates and click OK Please consult Excel s helpmenu if in doubt about security levels and protection The calculations completed in CS require an add in the Analysis ToolPak to be activated in Excel In order to do this go to Tools gt Add Ins a workbook must be open in Excel for this field to be active tick the box for Analysis ToolPak and click OK Figure 1 The user may be asked to insert the MS Office installation CD at this point when the add in was not initially installed on the computer along with Excel Please consult Excel s help menu if you have problems with the installation of the add in IMPORTANT If the Analysis ToolPak is not included or activated in Excel or the user does not set the security level on the Tools menu to those recommended above CoronaScreen will not run on your computer Security El Security Level Trusted Sources Dunnunnununnnnunnnnnnnnnnnmnnnmnnn nmm a Add Ins ki EJ dd Ins available Access Links apanalysis ToolPak Ck High Only signed macros from trusted so
4. Upon opening the spreadsheet a welcome worksheet becomes visible and allows the user to enter their name the name of the project and the date of the field survey These fields will be shown in the header of other worksheets throughout the workbook The buttons in the right hand corner allows the user to go directly to the Introduction or Data Input sheet 5 2 Introduction sheet The Introduction sheet summarises the input parameters required for the three models used in CS Figure 2 It provides access to further information on the Conceptual Model used in each model for the calculations completed in CS Clicking the Help button opens the default web browser and shows an HTML version of this document plus the user guides to the three models included in CS Clicking the Go to Data Input button takes the user to the main worksheet for data inputs used in CS This can also be done using the tab button at the base of the worksheets Fl Micrewoll Excel CS wi als G fle Ede err pmet Pomat Looks paia wrek peip Adobe POF LELT TEAL TEE EE um LIUS zio sjm o E E AE E Ws Overview CORONA Screening Model CoronaScreen uses three different conceptual models for calculating plume length Go To Data4nput Electron Balance Model Conceptual Modal Analytical Model Conceptual Model Halp Travelling 1D Model Conceptual Model The table below summarises the Input data requirements for each m
5. compounds included in the calculations The concentration of these two components should be set to 0 in the Plume source term data input block when they are not required in the calculations The left list shows all compounds that are currently contained in the CS database A contaminant in this list can be added to the right list Add button and included in the calculations or its details can be viewed click View button It is also possible to add a new contaminant to the list by clicking Add new and entering the relevant properties in the appropriate field on the pop up dialog box The latter feature actually adds a new compound and its relevant properties to the workbook via the database whereas the other features are for the user s convenience to keep irrelevant compounds out of view Manage Contaminants Ed Add new contaminant to database Database Include in calculation Tor Required properties Mame Tril24methylbenzene TOC Ammonium i mmonium Benzene i Benzene Toluene Toluene 120 2 Molecul ht even Delete Ethylbenzene Saa veg Ethylbenzene oO Mvlene ag o_svlene Number of electrons donated E YEW Tril 4methylbenzene Tril 35methylbenzene Koc 925 Additional properties Chemical Formula CBHS CH3 5 3 Carbon ratio Carbon Ratio Carbon ratio mol f mol compound Optional required if carbon balance is wanted cancel
6. z or Calc alpha _z from dz switches between two options in the Plume fringe parameters block When the cell for the vertical transverse dispersivity alpha z is greyed out and locked i e user input is not possible alpha z is being calculated from the plume fringe thickness dz After clicking the button alpha z becomes an input value and dz is being calculated This button is only available when alpha z and dz are coupled Dispersivity tab under Calculation settings Reset sheet to default values will reset CS to a default dataset This feature is only possible when certain contaminants are included in the plume source term but the program issues an alert if this is not the case The dialogs mentioned here are explained below 5 3 2 Dialogs related to the Data Input worksheet There are two dialog boxes which are accessed using the Add Delete Contaminants button These dialogs are Manage contaminants and Add new contaminant to database 5 3 2 1 Manage contaminants dialog This dialog box shows two lists Figure 4 The right window lists the contaminants that are currently being displayed in the Plume source term composition data input block and which will be included in the calculations When one of the items in this list is marked using the cursor it can be deleted by clicking the Delete button Note that for technical reasons TOC and ammonium cannot be deleted from the list of
7. 003 Electron Acceptor e l ld 4 gt bi Welcome Datalnput AS_Output Draw gt Dy CG AutoShapes 4 H4G o Z A S2 eO Ready ie NUM nee Figure 7 Output screen for Analytical Model 5 6 Travelling 1D Model sheet This worksheet shows preliminary results and further input data for the 1D Travelling Model The user can enter the number of time steps n not to be confused with porosity and the time step length for PHREEQC here For an explanation of this feature and background information please refer to the user guide for the model The Back button returns the user to the Data Input sheet 5 7 Print Summary sheet The Print Summary sheet lists the results input parameters and time of calculation for a modelled scenario in a printable format It shows the plume lengths and other relevant data for the three models at the top in addition to the input blocks as seen on the Data Input sheet The formatting has been set up to allow the contents of this sheet to fit on two pages when printed It is a known problem that upon first viewing the Print Summary sheet after opening the file the Plume source term input block on the bottom of the page is not shown correctly Click lt lt Back and on the Data Input sheet and then click the Print Summary button again The data should then be displayed properly from now on 6 Comment on Calculati
8. 1 respectively as these are often reported in the literature The user has the option to choose whether vertical transverse dispersivity alpha z and the vertical thickness of the plume fringe are coupled or not If this box is checked only one of the two variables will be available and the remaining one will be calculated using an analytical approximation use button Calc dz from alpha _z or Calc alpha_z from dz to switch between alpha _z and dz If this option is not chosen both alpha z and dz are required as an input value Alternatively the user may input a value directly for alpha z in the relevant cell when this is the only required parameter for a specific model in this input section e g Analytical Model Note that a value of alpha z and the plume fringe thickness dz are required for the Electron Balance Model but that a value of alpha z only is required for the Analytical Model In CS alpha z is automatically calculated from the plume fringe thickness dz when this is provided by the user It is strongly recommended that alpha z is estimated for individual sites using a measurement of the plume fringe thickness obtained from a MLS installed across the plume fringe and the Calc alpha_z from dz option in the model Entering separate values of alpha z and or the plume fringe thickness dz by decoupling the relationship which predicts these parameters completed by accessing the Dispersivity tab in the
9. Calculation settings section of the model should only be undertaken by experienced modellers using realistic values of these parameters for the scenario being evaluated with CoronaScreen 5 4 Electron Balance Model sheet This worksheet shows details and preliminary results of the Electron Balance Model Figure 6 For a detailed description of the various sections of this sheet refer to the user guide for the model The Back button returns the user to the Data Input sheet Ed Microsoft Excel CS v1 0 xls 8 x File Edit Yiew Insert Format Tools Data Window Help Adobe PDF la x JOSE BI6RY 4BAS O o B x amp l o n Arial JA a asasala z a ala aaa C23 h Total ED from source Electron Balance Model Calculations User s Name 2 Feb 2006 lt lt Back to input Plume balance Plume EA vertical transverse disp input mass flux of e equiv Plume EA ED balance Saeed efday Dissolved O conc EA vert trans disp 02 1st order plume scale degradation rate day Dissolved NO conc EA vert trans disp NOS Dissolved SO conc EA vert trans disp 04 Distance from source for TOC flux estimate Aro tux 60 00 m Equivalent TOC flux at given distance from source TEEM ng Plume EA horizontal transverse disp input mass flux of e equiv Dissolved O conc EA horiz trans disp 02 Plume source input mass flux of e equivalents Dissolved NO3 conc EA hor
10. Model and the Analytical Model can normally be enabled all the time since they are virtually instantaneous and robust The settings for the Travelling 1D Model as seen on the dialog box offer a few more options The default options will enable the user to get started for the first runs It is recommended that the user familiarises themself with the 1D Travelling Model before changing any of the options refer to the user guide for this model Currently alerts can be switched on or off in the lower section of this dialog box Settings for calculations Electron Balance Analytical 1D Travelling Dispersivity File options Run PHREEQZ G Use default directory to store PHREEQC data fodtrom i Import output oF previous PAR EEG hun Dialog options M Notify about saving this spreadsheet before every run I Prompt for name of output File before every run Reset to default OK Cancel Figure 5 Choosing models and options for the calculation tab for Travelling 1D Model shown here On the Dispersivity tab Figure 5 the user can choose O The ratio between vertical transverse dispersivity and horizontal transverse dispersivity alpha z alpha y o The ratio between vertical transverse dispersivity and longitudinal dispersivity alpha z alpha x O Whether to couple dz and alpha z using the relationship built in to CS to estimate these parameters Default values of these ratios are 0 1 and 0 0
11. alculated from aquifer parameters see Assistant section below The input block Plume fringe parameters is set up to allow input of either the vertical thickness of the plume fringe or vertical transverse dispersivity of the aquifer the other value in each case is then calculated automatically This dependency can be decoupled on the Dispersivity tab under Calculation settings Recommendations are provided below for the input of alpha z and plume fringe thickness dz in CoronaScreen see section 5 3 1 3 The other three input blocks Background groundwater chemistry Plume chemistry residuals and products and Plume source dimensions are static and simply require the user to enter the data needed in each block according to the model used When the user clicks in the main body of the data input blocks a brief explanation for each of them is given in the text box at the bottom of the section Assistant see below 5 3 1 2 Results section The Results section contains the fields that display results of the plume length calculations for the three models The button Calculation settings shows a dialog box that enables the user to switch models or parts of them on and off see description of dialogs below By clicking the Calculate plume length s button calculations of predicted plume length are performed according to the chosen settings This button is only enabled when data in t
12. cssssssesccscsessectessvescsosacsesausensccassessesdessvodesscesdessnsepsccassascesdesavescsesacsesausenessasentaezsiats 1 4 Settings ANG Add Ins s xesscsssteseceassensdenaetsenenecenedenaausevecseteedesncesssnanroneduvanensetaseveadenssenaseaanenedeneneaes 1 Ds UNE SDECAU SIGE vet sscscescaiesevectelecsscotessectastececsstesevecac essceutesuscestessesutoassscsecassceutensesccesecsceauetssecce 2 De MMV SLC ONC SINC Uf tara soi clathrate aaa a stress eases ean stearate Daan than ate Nada ystinoit 2 DZ MMGOOWC HOM SNCS he R S 2 wee Data MPU NCC mene tne eee 3 ToL SSC CHONS ON TIT IVD ci rE aAA O eased Suites oa eed E ede eed aurea ee Buco 4 5 3 2 Dialogs related to the Data Input worksheet ccccccccc cc nnneeeeeeeeeeccceaaeeesseseeeeeeeaaaaaaes 3 5 4 Blectronm Balance Model SiGe Encep ec a TE E 7 DD Pita ical Moders iee iaasa Roatan ct eens aia ce Roatan et vce E aaa 7 36 Trave Nns TD Mode Te Se SU ecne a E N T TE 8 SENASA SNCS ar arse iesoliy R A N seat unsaaeuaep aed 8 6 Commient On Calculations ecn s 8 Te ME OUIIES MOO UIND iss ssvassetecetaasessceusececssansssscunsececetodsssacuseuseunsders sacuneuvecetestees 9 Bs LCI ANGUS UD DOE eea a 9 OL AR CLO rene ES annn a a a E a a ias 10 Appendix I Example inputs for addition of new contaminants ssssssssceceececoocssssssssscceceee 10 1 Purpose of this User Manual This document explains how to install and use CoronaScreen The requirements for the model to run its layout and logical s
13. ections of this sheet is given in the user guide for this model The output includes profiles of predicted contaminant concentration along the plume centreline and vertical electron donor electron acceptor distributions across the plume fringe Figure 7 The Back button returns the user to the Data Input sheet EJ Microsoft Excel CS 1 0 xls p i 18 x File Edit Yiew Insert Format Tools Data Window Help Adobe PDF x JOe EBS6RY BBSlo c ERE C BD ara JH 2 4 S2225 57 eee 2 oo AN43 if Analytical Model Calculations 7 User s Name siteName __ 2 Feb 2006 Centerline profile lt lt Back to Input SourceGeometry Vertical Planar Source Plume Electron Donors e equivalents Time to steady state TOC ENRE e l Time to Steady State EEE days 3 Ammonium ED plume e z Benzene ED e l 8 Toluene EDpiume e 5 Ethylbenzene EDpiume e l 8 m_p_Xylene EDpiume efl Centreline profile o_Xylene EDptume e Resolution Total ED in plume Tot ED piume ell Vertical profile m Position along centreln m Resolution m 200 300 400 500 600 700 Background Electron Acceptors e equivalents Simulation time Distance from source m Time days Oz Eabkgrd NO EAbkgrd S504 EAbkgrd Total EA in backgrd Tot EAskgrad Electron Donor e l 0 0 00002 0 00004 0 00006 0 00008 0 0001 he Vertical Distance m 0 0 00005 0 0001 0 00015 0 0002 0 00025 0 0
14. ed at any time from the displayed dialog in Excel Cancel button Once the run is completed relevant output data is read into Excel and processed to calculate the plume length Data for the Travelling 1D Model is saved by default in a subdirectory of the main directory containing the CS directory odtrm Users should note that since another application PHREEQC via the DOS window is invoked for the Travelling 1D Model unforeseen complications cannot be ruled out due to the different ways applications are treated on different computers 7 Troubleshooting The spreadsheet does not have an automated validation feature built in 1 e input data is not tested for consistency The user has to ensure that only sensible parameter combinations are entered in the Data Input worksheet As an example an organic carbon content as foc or effective porosity ne larger than 1 0 is not a realistic value since both terms are fractions between 0 and 1 0 However this kind of inconsistency will not necessarily cause the calculations to fail or be directly visible in the results Care should therefore be taken when choosing sets of input parameters which should be theoretically valid consistent with the scenario modelled representative for the conceptual site model for the problem and obtained from site specific investigations where possible Other falsely assigned input values may however not allow the iterations to converge causing an err
15. he input blocks has been changed since the last calculation re entering a value counts as change otherwise it will show when the last calculation was performed The button Print summary leads to a sheet that keeps a record of the most recent scenario see description of Summary sheet below which can be printed The user can return to the Data Input worksheet by clicking the Back button in this mode 5 3 1 3 Assistant section The column on the right hand side of the screen contains buttons for further functions and a description box On top of this column are three buttons e g Go to Electron Balance Model that lead to the sheets showing information for the three models The Add Delete compounds button presents the user with a dialog box that allows QO The addition of items to or deletion of items from the list of contaminants in the Plume source term input block which are included in the CS database Q Addition of new contaminants to the database for future availability The button Restore velocity equation relates to the cell containing the groundwater velocity in the Aquifer properties and hydrogeology input block This button is only active if the user has entered a value for groundwater velocity directly into the cell By clicking this button the user can revert back to the velocity being calculated by applying the equation v Ki n The button denoted Calc dz from alpha
16. he spreadsheet using macros written in Visual Basic for Applications VBA which perform procedures and calculations in the background The spreadsheet requires the geochemical model PHREEQC Parkhurst and Appelo 1999 to correctly run the Travelling 1D Model PHREEQC is an executable file controlled by macros that run outside Excel and is available as freeware from the USGS website http wwwbtr cr usgs gov Further information on the functionality and application of PHREEQC can also be found on the USGS website for this geochemical code PHREEQC is included with CoronaScreen and will boot up automatically when the software is loaded 3 Installation To install CoronaScreen copy the file setup exe onto your computer Double click on this file to install the spreadsheet together with the required files and directory structure The CS can be placed in any folder on the hard drive Two subfolders called odtrm and doc containing further necessary files and documentation will be created automatically To uninstall simply delete the file CS v1 0 xls and the subdirectories odtrm and doc together with their contents manually from the hard drive It is recommended that users keep a copy of the unedited downloaded CS and create a separate working version for each model application Modifications to the working version should then be saved with a different name than the original downloaded CS model 4 Settings and Add Ins
17. iz trans disp NO3 Dissolved SO conc EA horiz trans disp 04 TOC ee efday Total EA from dispersion Total EA dispersion Ammonium ED source efday Benzene EDsource efday Toluene EREE efday Plume ED residuals input mass flux of e equivalents Ethylbenzene Ems efday m_p_Xylene Ema e day Dissolved 504 EA esiauat s04 0 o Xylene EDsource efday Tokai ED from source Tot ED ource e day Plume EA products input mass flux of e equivalents Dissolved Mn Dissolved Fe Dissolved equivalent Fe EA produced Mn Plume products residual minus background SAren EA produced equiv Fe Mnf produced 0 mg Dissolved CH4 EA produced CHA Fe produced Oo mgl Total EA from products Total EA esigua DIC produced 0 mg l Methane produced 0 Sum EA mass flux of e equivalents Plume TDIC amp CH4 products input mass Total EA from dispersion Total EA dispersion Total EA from products Total EA produced 0 DIC DIG produced i Total EA from groundwater Total EA joundwater 0 299861227 M 4 p pil Welcome Fd DataInput EB_Output i eae Meee Se tea ee ee res oe aoe o conaassarcaconraunaconasosiseoe Draw gt G5 AutoShapes OB 48 Z A S32 ea Ready j NUM Figure 6 Output screen for Electron Balance Model 5 5 Analytical Model sheet This worksheet shows details preliminary results and graphs for the Analytical Model Figure 7 A more detailed description of the various s
18. odel Refer to the User Manual or Help for Information regarding capabilities and limitations of each model and Interpretation of results Electron Balance Model 2 Groundwater Flow Veloci Can also be calculated from KI En a E Transverse Vertical Dispersivity Of dry Can optionally be calculated from dz r Oooo o o O Transverse Honzontal Dispersrity Of yy Calculated from a by a user dehned rate e Longitudinal Dispersrvity oF a Calculated from a by a user defined ratio T ki ajs s Mas 4 4 amie Width idih narmal to giournderater Ia Fiame hickiess Verbcal thickness mornal to grounceaber Flor Fringe one Thickness vertical Piume fringe thickness in Z direchon opion to calculate rom a Porosity fective pornsity o EA Background Concentrators Eletron Acceptors Or SOy CE in background ground water a Y EA Flume Concentrations Ebetiron Acceptors 2 SO ete mnde the plure EA ema v ED Background Concentrations Electron Donars jeg Benzene in background ground water Elasa EDn nd i fn ED Plume Concentrations Electron Donors e g Benzene inside the plume EO 7 7 a o o O Buk Density Bulk Density of aguiher maternal Bp Organic Carbon Content Fraction of solid organic carbon inion aquifer materials far E Po a fe a Uistance iram sete ot montonng w ll used to represent thre aa a Distance source to source v ll 7 f ai area composibon j n
19. om dz m_p Xylene Cee mpl Fraction of organic carbon foc 0 001 amp Oo o_Xylene Coes magi Kd for Ammonium Famm 04 mig Plume chemistry residuals and products Plume source dimensions ick in one of fhe input Secon fer a heat Oo Tg residual 0 mg Plume width Y 1 explanation NOs NOs catia 9 mg Plume thickness Z i m so Sa rainal 0 mgl Distance source bo sowce wil s Mr Win produa 0 magi Fer lt _ Dissoked Inorganic Carbon li mgl Plume fringe parameters Methane o mgt en H Ii Waiame J Introduction p Datatnpat jal jouw Te Gi apoio SOR 4AM o 4 A S re Om Poissy lf KUM Figure 3 Data Input sheet 5 3 1 Sections on Data Input The Data Input worksheet is arranged in three sections as shown in Figure 3 and described below 5 3 1 1 Input section In this section the user can enter data in six input blocks Plume source term composition Plume chemistry residual and products Background groundwater chemistry Aquifer properties and hydrogeology Plume source dimensions and Plume fringe parameters Compounds in the input block Plume source term composition can be added or deleted as desired by clicking the Add Delete Compounds button see description of the Assistant section below The groundwater flow velocity in the block Aquifer properties and hydrogeology can be entered directly or c
20. ons An iteration using Excel s GoalSeek function is used to find the steady state plume length in the Electron Balance Model The same method is used to calculate the steady state plume length and the time to steady state plume length in the Analytical Model The iteration is virtually instantaneous and known to be fairly robust 1 e convergence is almost always achieved The calculations for the Travelling 1D Model are not completed in Excel but are undertaken in PHREEQC Several steps in Excel are needed to facilitate the simulation run when using the Travelling 1D Model Data is prepared and written to a hidden worksheet of the spreadsheet This worksheet is then saved as a plain data file txt format and used by PHREEQC as an input file The user will be alerted to this unless this alert is switched off and should make sure that any important data from previous simulations is saved under a different name the CS cannot save several solutions in one file Before the run is started the user can either choose a name for the file to which selected PHREEQC output data which is required output for the Travelling 1D Model is saved or use the default name fringe sel A dialog box in Excel indicates that PHREEQC runs in the background While the program runs the user can check on progress by activating the command window from the taskbar It is not recommended to use other applications while PHREEQC is running The run can be interrupt
21. or message to be generated or cause Excel to display errors in cells e g FNAME REF DIV O etc The cause in most of the cases is unrealistic values for input parameters and the user is advised to double check the entered values for inconsistencies Note that for the Distance source to MLS well input in the plume fringe parameters data block a value of x greater than one must always be entered in this box to avoid goal seek error or DIV 0 messages occurring when the model is run 8 Help and Support Every effort has been made to trap errors and return a meaningful error message that informs the user about why and where the error occurred However due to the complexity of the spreadsheet and set up configuration for individual computers no guarantee can be given that all errors are eliminated The cause in most cases will be inconsistent input data which may be rectified easily by checking the error message and double checking the data set However if errors continue to occur limited support for the software and different models is available from the following sources in the Groundwater Protection and Restoration Research Group at the University of Sheffield Technical problems and guidance Assistance Installation and use of CORONA Screen software Arne H ttmann ahuttmann golder com Electron Balance Model Steven Thornton s f thornton sheffield ac uk Analytical Model Marienne Gutierrez Neri gutier
22. rez geo uu nl Steven Thornton s f thornton sheffield ac uk Travelling 1D Model Ryan Wilson r d wilson sheffield ac uk 9 References Parkhurst D L and Appelo C A J 1999 User s guide to PHREEQC Version 2 A computer program for speciation batch reaction one dimensional transport and inverse geochemical calculations U S Geological Survey Water Resources Investigations Report 99 4259 310p Appendix I Example inputs for addition of new contaminants The following examples illustrate how new contaminants electron donors and electron acceptors are added to the CoronaScreen database using the Manage Contaminants tool bar in the Add Delete contaminants input option The examples below are formatted in the style of information required by the prompt boxes in the Manage Contaminants tool bar Example 1 Addition of methyl tertiary amyl ether TAME as a new organic contaminant electron donor in the plume source term composition Name TAME Molecular weight 102 18 g mol Number of electron donated in redox half reaction 36 Koc 0 Chemical formula C H 40 Carbon ratio 6 Redox half reaction CsH O 11H O 6CO 36H 36e Example 2 Addition of methyl ether ketone MEK as a new organic contaminant electron donor in the plume source term composition Name MEK Molecular weight 72 1 g mol Number of electron donated in redox half reaction 22 Kee 14 ml g Chemical formula C HgO Carbon ra
23. rn gi j j Inge pararveters T mypothapes gt w OOA gt A S eam oxo Finty Figure 2 Introduction sheet 5 3 Data Input sheet MN Welcome Initenductican 1 D is ss The Data Input worksheet is at the centre of the workbook Figure 3 It is arranged in sections and has several functions These features are described in more detail below Most functions 1 e mainly button activated functions are explained under the sections they can be found in Dialogs linked to a button click are described separately in the second subchapter Fi resol Excel CS w1 iali 2 8 E pe pie yew peet Foma Took paa window peip Adobe RDF igj i io AE IEE ELTE eee ee Sa HES sio ee E A Data ae Iput amp Rests User s Name Site Name 12 Feb 2006 Results _ Assistant Plume Le ngths Go te Electron Balance Model Calculate piume lengths Mot on calculation Li Electron Balance Model cu te Go to Analytical Analytical Model l EEA Galeuianon setangs printammary 1 D Model Flume source term composition f AddiDelete contaminants To Co 5 mg Groundwater flow velocity Y 0 37037 meday Restore Armanin Ee ari 3 mgi Hydraulic conductivity K 5 miday velocity Benzene pees 0 mil Hydraulic gradient i Do mim someon Toluene ae mgl Effective porosity Ny 027 eG Cale alpha_z Ethylbenzene cae o mgf Bulk density Pp 2 gem fr
24. tio 4 Redox half reaction CsHgO 7H O 4CO 22H 22e Example 3 Addition of sulphate as a new inorganic contaminant electron acceptor in the plume source term composition Name SO Molecular weight 96 06 g mol Number of electron donated in redox half reaction 8 Ko 0 Chemical formula SO Carbon ratio 0 Redox half reaction SO 8e 9H gt HS 4H 0 Note that inputs of electron acceptors in the plume source term composition are assigned a negative value
25. tructure are illustrated to enable the user to navigate effectively through the spreadsheet and achieve results without needing to view details of the calculations in the background No reference to the theoretical framework or conceptual basis of the calculations performed by the spreadsheet is made For specific information on the models included in the spreadsheet the use should refer to the user guide for each model Each user guide explains the data requirements calculations and interpretation of results produced by the models The user guides are available as standalone documents in pdf format 2 Software Requirements CoronaScreen CS is an Excel spreadsheet and requires Excel2000 or later versions Backward compatibility to Excel97 was not tested thoroughly and there are known but unresolved problems when running a part of the CS the 1D Travelling Model in Excel97 It is therefore advisable to only use Excel2000 or later versions Windows NT XP ME 2000 is the only operating system the spreadsheet has been used on to date This user manual refers in its descriptions to the environment encountered in Excel2000 9 0 4402 SR 1 Users of later versions Excel 2002 3 should have no problem viewing the environment described here older versions may show a different layout or lack described functions altogether and the user 1s referred to Excel s help menu to determine if relevant features are available Functionality has been added to t
26. urces will be allowed to run Unsigned macros are automatically disabled Cancel T Conditional Sum Wizard Euro Currency Tools E Internet Assistant YEBA Browse ith Medium You can choose whether or not to run potentially unsafe macros T Lookup Wizard Low nok recommended You are not protected From TMs Query Add in potentially unsafe macros Use this setting only iF you T ODBC Add in have virus scanning software installed or you are sure all documents you open are safe Analysis ToalPak Provides Functions and interfaces For Financial and scientific data analysis No virus scanner installed cancel Figure 1 Setting the security level and installing add ins to run macros in CoronaScreen 5 The Spreadsheet To start CS open the file by a double click on the file name or icon or open it from Excel The workbook contains several worksheets to structure the data input blocks and output sections Some of the sheets are hidden from view for clarity and become visible when needed As with other Excel workbooks the tabs at the bottom of the window indicate the visible worksheets Relevant sheets are explained in the following sections The size of worksheets in this workbook is automatically adjusted according to the user s screen resolution If the adjustments are not accurate this can be changed in the Standard command bar by changing the value in the percentage field 5 1 Welcome sheet
Download Pdf Manuals
Related Search