Home

MTCA Workbook User`s Guide for Ver 11.0 - CLU-IN

1. ssesessseesessrsesssressessresressessresreesetsresreeseesseseresresse 53 Figure 3 10 Calculate Protective Condition BOX essseseseeseresesreeseesresrrrsresresrresresseseresee 54 Figure 3 11 Floating Calculation Buttons c ic0icniegiie nada gee aitnhau 55 Figure 3 12 Test Adjusted Condition BOX essssseseesessesesesressessresressessrerressereresreeseesreesee 55 Figure 3 13 Dialogue Box for Entering Soil TPH Concentration seeeeeceeeeeereeeenee 56 Figure 3 14 Buttons for Soil Quality Criteria for Method C ssssssssessesesererrereesrerreersee 56 Figure 3 15 Protective Condition or Testing BOX esseseseseeeresrsssesressrseresresseseresressessresres 58 Figure 3 16 Floating Buttons for Soil to Ground Water Exposure Pathway 58 Figure 3 17 Model Results 22 2350 titewcctt ctl ceelieteeesl et heart ade et 60 Figure 3 18 Soil Vs Ground Water Concentration Predicted for TPH ee eeeeeee 60 Figure 3 19 Soil Vs Ground Water Concentration Predicted for each Component 61 Figure 3 20 TPH Mass Distribution in Soil Matrix eee eeeceeeeeeeneeceeceeeeeeeeeeaeeenaeens 61 Figure 3 21 Mass Balance Navigator 3coc 2 iy2 lt setosc ceccatealucces3 added i lt tecosendceteadneaNeomnda bees 62 Figure 3 22 Mass Distribution of Individual Component in Soil Matrix oo eee 62 Figure 3 23 Quick Instruction for Calculating TPH Ground Water Cleanup Levels 64 Figure 3 24 Entering Site Information saicc96 Sesser scc
2. n Hexane and Naphthalene but may also include fuel additives such as Methyl tertiary butyl ether MTBE Information contained in WAC 173 340 830 provides a more detailed discussion of the types of testing required for petroleum releases Table 830 1 in WAC 173 340 900 is a summary of the required testing for different types of petroleum releases The MTCA Cleanup Regulation allows for mixture specific chemical characterization of released petroleum in order to develop a cleanup level tailored to the types of compounds actually present in soil or ground water This method known as TPH fractionation measures the concentration of twelve sub groups or fractions of TPH within the released mixture and is based on work by a consortium of national experts TPH Criteria Working Group 1997 These fraction groups are defined based upon their relative average molecular size with the lighter weight and typically more volatile and soluble compounds in one group and heavier less volatile and soluble compounds in others The measured concentrations of each of the twelve groups are then assessed together with their individual chemical and toxicological properties to determine the appropriate cleanup level Depending on the particular TPH mixture present certain hazardous substances i e benzene carcinogenic PAHs or MTBE must still also be measured in addition to the individual TPH fractions The detailed analytical met
3. Don t Update when you are asked about updating links 2 On the Tools menu click Add Ins In the Add Ins available box select the check box next to the add in you want to load as shown to the right and then click OK If the add in you want to use is not listed in the Add Ins available box click Browse and then locate the add in If necessary follow the instructions in the setup program Or you can reinstall an Excel add in by using the program that you used to install Excel See Figure 1 4 Figure 1 4 Add in Features Add Ins available T Euro Currency Tools Internet Assistant VBA M Lookup Wizard M Solver Add in Automation Analysis ToolPak Analysis ToolPak VBA Lookup Wizard Solver Add In Opening error message Compile error can t find project or library or not executing the calculation or compatibility problem with different versions of MS EXCEL The revised Workbook is developed for MS EXCEL 2003 because that was the version that Department was using at the time Ecology has had mixed reports from outside users about their ability to use the Workbooks on older versions How to resolve this problem is to exactly locate two built in function files Figure 1 5 Compile Error Message Microsoft Visual Basic A Compile error Can t find project or library Help August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 It is possible that MS Visual Basic may open with a
4. Figure 3 26 provides the total concentration ug L of all the TPH fractions and compounds entered by the user and the corresponding hazard index and cancer risk In this particular example the Pass Fail indicates a Fail since both the carcinogenic and August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 67 non carcinogenic risks exceed the acceptable levels for total site risk HI 1 and RISK tx 10 Second the three columns located to the right of the data entry columns with the heading Current Condition provide the detail necessary to determine why the sample has failed and which fractions and chemicals are contributing to the hazard index and carcinogenic risk The sums of the hazard quotient and total carcinogenic risk are shown at the bottom of their respective columns Pass Fail Criteria A failure is registered IF either of the following conditions is true e Fora single hazardous substance TPH component the hazard quotient exceeds 1 or the carcinogenic risk exceeds 1 x 10 ie the ground water concentration exceeds the applicable Method A concentration listed immediately to the right of the data entry field or e For total site risk TPH mixture the hazard index exceeds or the sum of the carcinogenic risk exceeds 1 x 10 Calculating Protective Condition This tool allows the user to calculate a protective TPH ground water concentration based on various ground water quality crit
5. Main button to return to the MTCATPH Tool Navigator OR select End button to exit the MTCATPH Tool The Execute Calculation button is located at the right top corner of the worksheet A2 and allows the user to simultaneously and automatically evaluate the site specific risk under the current site condition entered the A1 worksheet and develop the soil TPH cleanup levels for both soil direct contact and soil to ground water exposure pathways Depending on the speed of your computer the calculations may take several minutes to complete You can follow the changes in the numbers that appear in the trial solution and set cell by watching the Status Bar box on the left bottom of the screen shown The calculation summary results will appear in the blue colored table section 1 row at the top of the main table 1 Summary of Calculation Results of the sheet A2 Soil Cleanup Levels The table stores all information used to calculate the TPH cleanup levels during the course of the calculations and this information in the gray portion of the lower table is provided for informational purpose August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 45 3 7 2 Entering Data Input A1 The user is required to enter all necessary site data and analytical data before performing any data analysis The user can always go back to change data that has been entered previously by clicking on the appropriate button on the
6. Risk of all cPAHs 1E 5 Naphthalene 160ug L 2 f the button right above does not l work then use Alternative right below For an alternative i calculation with Goal Seek i Function the volume of NAPL formedis not considered The calculation eror is within 0 1 with this alternative when comparing the i complete solution H i TPH Test Alternative i Calculate Protective Soil Condition for Adjusted Site specific TPH Ground Water Cleanup Level previously entered This tool allows the user to calculate a protective TPH soil concentration based on the site specific Target TPH ground water concentration that is previously adjusted and entered by the user This target TPH ground water concentration could be the value that is protective of surface water quality or non potable ground water quality etc The Worksheet uses the same composition ratio as for the measured data and the same hydrogeological data previously entered by the user Protection of Target TPH GW Conc This tool allows the user to calculate a protective TPH soil concentration based on various ground water quality criteria The worksheet uses the same composition ratio as for the measured data and the same hydrogeological data previously entered by the user Select the particular potable ground water quality criterion for which you want to calculate a protective TPH soil concentration e Target Soil Cleanup Level HI 1
7. 69 Testing Adjusted Condition One of the most useful tools included in the Workbook is the ability to determine based on the relative composition of the sample what TPH concentration would meet the risk based limitations This concentration would be the target ground water cleanup level This can be done using the buttons and the box located at the right side of the sheet as shown in Figure 3 29 Figure 3 29 Test Adjusted Condition Box TEST ADJUSTED CONDITION This tool allows the user to test whether a particular TPH A soil concentration is protective of human health The Test Adjusted TPH Workbook uses the same composition ratio as for the GW Conc measured data Tested TPH GW Conc ug L 100 HI 3 97E 01 __RISK 3 71E 06 Pass or Fail Pass The button Test Adjusted TPH GW Conc allows the user to enter a specific concentration and the results 3 8 4 Output Adjusting the Results As noted previously see Section 3 4 2 the potable ground water cleanup levels calculated using the ground water worksheet DO NOT account for several factors Consequently to establish a potable ground water cleanup level under the regulation the cleanup level calculated using the worksheet may need to be manually adjusted to account for the following e Concentrations based on potential surface water impacts see WAC 173 340 720 4 b i and 5 b i1 e Nonaqueous phase liquid NAPL limitation see WAC 173 340 720 7 d
8. Workbook Tools for Calculating Soil and Ground Water Cleanup Levels under the Model Toxics Control Act Cleanup Regulation User s Guide For MTCATPH 11 0 amp MTCASGL 11 0 Washington State Department of Ecology Toxics Cleanup Program Revised August 2006 Publication No 01 09 073 Printed on Recycled Paper amp If you have special accommodation needs please contact the Toxics Cleanup Program at 360 407 7170 voice 711 or 1 800 833 6388 TTY This Guidance is available on the Department of Ecology s website at http www ecy wa gov programs tcp tools toolmain html For additional copies of this publication please contact Department of Ecology Publications Distribution Office P O Box 47600 Olympia WA 98504 7600 360 407 7472 Refer to Publication No 01 09 073 Revised August 2006 Questions or Comments regarding Workbook Tools MTCASGL 11 0 and MTCATPH 11 0 and User s Guide should be addressed to Hun Seak Park Washington State Department of Ecology Toxics Cleanup Program PO Box 47600 Olympia WA 98504 7600 Disclaimer This User s Guide and associated programs are provided AS IS and without warranties as to performance or any other warranties of any kind whether expressed or implied The user assumes the entire risk of using this User s Guide and associated programs In no event shall the State of Washington and all parties associated with the preparation of this manual be liable for d
9. if no enter n EC Cancel Additional buttons provided at this A2 Worksheet are August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 51 Cautions This button shows the cautionary statement on the use of this Workbook Main This button allows the user to always return to the navigator Clear Calculation This lets the user clear all previously calculated values stored in the A2 Worksheet Once cleared the cleared data is irretrievable Direct Contact Calculations This lets the user execute the calculation for soil direct contact exposure pathway only Find the button Execute Calculation and click it to execute the calculation to establish the soil TPH cleanup levels to be protective of both pathways of direct soil contact and soil to ground water exposure pathways This button runs all the calculations needed to generate the site specific soil TPH cleanup level backward calculation and the current risk forward calculation under the site specific data entered previously As shown in Table 3 5 the calculation summary will appear in the section 1 of the worksheet A2 The maximum TPH soil concentrations to be protective of each decision criteria are shown in the table along with associated carcinogenic risk and Hazardous Index values The two protective soil concentrations are shown for Methods B and C correspondingly The user needs to show that both the carcinogenic risk from individual hazardo
10. August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 59 e Target Soil Cleanup Level RISK 1 x10 e Target Soil Cleanup Level based on benzene ground water cleanup level e Target Soil Cleanup Level based on MTBE ground water cleanup level e Target Soil Cleanup Level based on cPAHs Risk 1 x10 ground water cleanup level Testing Adjusted Condition Using the buttons TPH Test or TPH Test Alternative the adjusted concentration is scaled up or down by proportionality based on the same relative percentages as those for the actual measured soil concentrations TPH Test Button allows the user to test whether a particular TPH soil concentration is protective of ground water quality The Workbook uses the same composition ratio as for the measured data and the same hydrogeological data previously entered by the user An MS Excel built in function Solver is used for the exact calculation with this TPH Test button If the button TPH Test does not work properly then use TPH Test Alternative right below For an alternative calculation with Goal Seek function the volume of NAPL formed is not considered The calculation error is within 0 1 with this alternative when comparing the complete solution This is an alternative back up button Calculating Protective Soil Condition for Adjusted Site Specific TPH Ground Water Cleanup Level previously entered This tool allows the u
11. O yapn Total Mass distributed in Water Phase 0 99 in Solid 35 97 Total Mass distributed in Air Phase 2 70 in NAPL 60 34 Additional buttons provided at this A2 2 Worksheet are e TPH Range Test This button lets the user conduct the partitioning equilibrium calculation for the graphical output for the range of user defined soil concentration The user can view five trend lines to display for gt Soil TPH concentration vs Predicted TPH concentration at well See Figure 3 18 gt Soil TPH concentration vs Predicted HI at well gt Soil TPH concentration vs Predicted Risk at well gt Soil TPH concentration vs Predicted concentration of each TPH component and hazardous substance at well See Figure 3 19 gt Soil TPH concentration vs Predicted TPH mass distribution in each soil matrix at four phases See Figure 3 20 Figure 3 18 Soil Vs Ground Water Concentration Predicted for TPH w Soil TPH Vs Predicted TPH Well 450 400 5 350 z E 300 3 a E Predicted TPH well 3 200 E Raoult s Law Ba x 100 50 0 1111 1111 ttt 11 1 10 100 1000 10000 100000 Soil TPH mg kg of soil August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 61 Figure 3 19 Soil Vs Ground Water Concentration Predicted for each Component AL_EC gt 5 6 Predicted Concentration Well B AL EC 8 t AL EC gt 8 10 lt AL EC gt D 2 i i AL_EC
12. and e Total site risk see WAC 173 340 720 7 a August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 71 Appendix A Equations and Default Values for Calculating Potable Ground Water Cleanup Levels Equation 720 1 Potable Ground Water Cleanup Levels Noncarcinogens Potable Ground Water CleanupLevel Default Value P Definiti Chemical specific Oral Reference Dose ug L RfD x ABW x UCF x HQ x AT DWIR x INH x DWF x ED Chemical specific Units mg kg day Average Body Weight over the exposure duration 16 70 kg Unit Conversion Factor 1 000 1 000 ug mg Hazard Quotient 1 0 1 0 unitless Averaging Time 6 6 years Drinking Water Ingestion Rate 1 0 2 0 L day Inhalation Correction Factor 1 See Note 1 See Note 1 unitless Drinking Water Fraction 1 0 1 0 unitless Exposure Duration Footnotes 6 6 1 Use value of 2 for volatile organic compounds and 1 for all other substances Equation 720 2 Potable Ground Water Cleanup Levels Carcinogens Potable Ground Water Cleanup Level ug L Parameter Definition Acceptable Cancer Risk Level years RISK x ABW x AT x UCF CPF x DWIR x ED x INH x DWF Default Value Method B Method C Units unitless Average Body Weight over the exposure duration 70 70 kg Averaging Time 75 75 year
13. displays the results of more detailed calculations for the direct contact pathway the leaching pathway and vapor pathway to allow the user to determine the basis of the cleanup level Table 2 3 Summary of Calculation for Each Exposure Pathway 2 Summary of Calculation for each Exposure Pathway Summary by Exposure Pathway Method B Method C Unrestricted Land Use Industrial Land Use HOQ 1 0 RISK 1 0E 6 HO 1 0 RISK 1 0E 5 18 Cee Ingestion amp Ingestion amp Soil Dir ect Ingestion only Dermal Ingestion only Dermal Contact Under the Current HQ Exposure Point 1 250E 01 Condition RISK Exposure Point 1 700E 06 4 000E 01 2 778E 01 1 750E 03 3 333E 02 RISK 1 0E 6 or 1 0E J 2 941E 00 2 042E 00 3 860E 02 7 353E 01 Method B Method C HO 1 0 RISK 1 0E 6 HO 1 0 RISK 1 0E 5 Protection of Predicted Ground Water Under the Current Conc _ug l HQ Exposure Point 1 536E 02 7 024E 03 Potable Condition Ground Water RISK Exposure Point 4 776E 07 4776E 07 Target Ground Water CUL ug l 2 574E 01 Target Soil CUL mg kg 1 047E 01 Method B Method C HO 1 0 RISK 1 0E 6 HO 1 0 RISK 1 0E 5 Predicted Air Conc Protection of Under the Current ug mn Exposure Point As ets Condition i Ail Quality HQ Exposure Point N A N A RISK Exposure Point 1 903E 09 1 903E 09 for informational purpose only 2 574E 02 2 574E 01 N A N A D RISK 1 0E 6 or 1 0E
14. for gasoline you probably would not test for the cPAHs so these entries would all be zero For values below the method detection limit substitute one half the method detection limit For values above the method detection limit but below the practical quantitiation limit substitute the method detection limit However for a hazardous substance or petroleum fraction that has never been detected in any sample at a site and these substances are not suspected of being present at the site based on site history or other knowledge enter 0 for that value If the sample has been analyzed using both the VPH Volatile Petroleum Hydrocarbons and EPH Extractable Petroleum Hydrocarbons methods use the higher value for the fraction where there is an overlap between these two methods August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 46 All entries must be numeric values Any text entry will cause a VALUE error to appear in the column to the right This must be corrected or the Workbook will not execute its calculations correctly Figure 3 4 Entering Soil Concentration Measured 2 Enter Soil Concentration Measured Chemical of Concern Measured Soil Conc Composition or Equivalent Carbon Group i Ratio Petroleum EC Fraction AL _ EC gt 5 6 AL EC gt 6 8 AL _ EC gt 8 10 AL _ EC gt 10 12 AL _ EC gt 12 16 AL EC gt 16 21 AL EC gt 21 34 AR_ EC gt 8 10 AR_EC gt 10 12 24 AR_EC gt 12 16 AR_EC gt 16 21 AR
15. provided for informational purposes only Ground Water Cleanup Level for Drinking Water Beneficial Use Method B only END DISCLAIMER CAUTION TO USERS MTCATPH11 0 Version NO 11 AUGUST 1 2006 1 5 Common Error Messages and Troubleshooting Operating Tips Failing the MTCATPH xls Workbook on the Ecology website link to run When the user clicks on the link on the Ecology website the document may not open up The user should download the EXCEL Workbooks before trying to run them To download a file the user should right click on the link This will bring up a menu Then left click on Save Target As or Save Link As After clicking on Save the file will be downloaded onto your computer The user should then close the browser and open the spreadsheet as the user would any other file on the computer Opening with error message This Workbook contains links to other data source as shown or NAME is displayed in cell boxes The most common cause of this problem is that necessary add ins components are not added properly Follow installation instructions described in Figure 1 3 Figure 1 3 De linking Error Message xl This workbook contains links to other data sources If you update the links Excel attempts to retrieve the latest data If you don t update Excel uses the previous information Update August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 1 Click
16. 047E 01 mgkg Natural Background concentration for Soil N A mgkg Practical Quantitation Limit for Soil 0 008 mg kg Soil Cleanup Level not considering vapor pathway 1 047E 01 mg kg C sat corresponds to the total soil chemical concentration 2 628E 04 mgkg saturated in soil Soil concentration based on Vapor Pathway informational purposes only Soil Saturation Limit C SATEL R is the ratio of the ground water flow velocity to the NUE Vaa gt sat Pitts ons Retardation Factor R 118284 contaminant migration velocity in saturated zone Chemical of Concern The name of the chemical as entered by the user Most Stringent Soil Concentration based on Evaluation of the Direct Contact Pathway and the Leaching Pathway mg kg The worksheet calculates protective soil concentrations based on the direct contact pathway and the leaching pathway protection of ground water The lower most stringent of these two concentrations is presented in the table Natural Background Soil Concentration mg kg This is the chemical specific natural background concentration entered by the user Practical Quantitation Limit for Soil mg kg This is the chemical specific practical quantitation limit entered by the user Soil Cleanup Level mg kg The soil cleanup level presented in the table is the most stringent concentration based on evaluation of the direct contact pathway and the leaching pathway unless that con
17. 1 or 740 2 745 2 would result in a significantly higher soil cleanup level than would be calculated without the proposed changes See WAC 173 340 740 3 c ii1 and 173 340 745 5 c ili HQ x ABW x AT 1 SIR x ABI ie 1 lt SA x AF x ABS RfD 10 mg kg RID 10fmg kg Default Value Value Parameter Definition Method B Method C Equation Equation 740 4 745 4 Soil cleanup level mg kg soil erx ED Hazard Quotient 1 unitless Average Body Weight over the 16 kg exposure duration Averaging Time 6 0 years Exposure Frequency 1 0 unitless Exposure Duration 6 0 years Soil Ingestion Rate 200 mg day Gastrointestinal Absorption fraction 1 0 unitless Dermal Surface Area 2 200 2 cm Adherence Factor 0 2 mg cm day Dermal Absorption Fraction See Note 1 See Note 1 unitless Oral Reference Dose Chemical specific Chemical specific mg kg day Dermal Reference Dose See Note 2 See Note 2 mg kg day Gastrointestinal Absorption See Note 3 See Note 3 unitless conversion factor Footnotes 1 May use chemical specific values or the following defaults 0 01 for inorganic hazardous substances 0 0005 for volatile organic compounds with vapor pressure gt benzene 0 03 for volatile organic compounds with vapor pressure lt benzene 0 1 for other hazardous substances 2 Derived by R
18. 2 500 cm Adherence Factor 0 2 0 2 mg cm day Dermal Absorption Fraction See Note 1 See Note 1 unitless Oral Cancer Potency Factor Chemical specific Chemical specific mg kg day Dermal Cancer Potency Factor See Note 2 See Note 2 mg kg day Gastrointestinal Absorption See Note 3 See Note 3 unitless conversion factor Footnotes 1 May use chemical specific values or the following defaults 0 01 for inorganic hazardous substances 0 0005 for volatile organic compounds with vapor pressure gt benzene 0 03 for volatile organic compounds with vapor pressure lt benzene 0 1 for other hazardous substances 2 Derived by CPF GI see note 3 3 May use chemical specific values or the following defaults 0 2 for inorganic hazardous substances 0 8 for volatile organic compounds 0 5 for other organic hazardous substances B 4 Appendix C Equations and Default Values for Calculating Protective Soil Concentrations based on the Leaching Pathway Protection of Ground Water THREE PHASE PARTITIONING Equation 747 1 Three Phase Partitioning Equilibrium Equation 0 0 x H Py C C xUCF x DF x K Parameter Definition Default Value Units Soil concentration calculated mg kg Ground water cleanup level established under WAC 173 340 720 Unit Conversion Factor 1E 3 mg ug Dilution Factor 20 unitless Distribution Coefficient
19. 630E 05 3 880E 03 6 030E 07 6 560E 05 Soil Organic Oral Partitioning Liquid Density Raeren Coef Dose K oc P RfD 0 Lhkg mg L mg kg day 8 000E 02 6 700E 05 Le 3 800E 03 7 000E 05 Ll 3 020E 04 7 300E 05 0 03 2 340E 05 7 500E 05 0 03 5 370E 06 7 700E 05 0 03 9 550E 09 7 800E 05 2 1 070E 10 7 900E 05 2 1 580E 03 8 700E 05 0 1 2 510E 03 9 000E 05 0 02 5 010E 03 1 000E 06 0 05 1 580E 04 1 160E 06 0 03 1 260E 05 1 300E 06 0 04 6 200E 01 8 765E 05 0 004 1 400E 02 8 669E 05 0 08 2 040E 02 8 670E 05 0 1 2 330E 02 8 752E 05 0 2 1 191E 03 1 145E 06 0 02 3 038E 03 1 025E 06 0 05 2 976E 03 9 900E 05 0 004 3 410E 03 6 594E 05 0 06 1 090E 01 7 440E 05 6 600E 01 2 170E 06 0 009 3 800E 01 1 253E 06 0 03 1 274E 06 1 300E 06 1 300E 06 1 300E 06 1 274E 06 1 260E 06 1 300E 06 3 575E 05 1 230E 06 1 230E 06 9 688E 05 3 980E 05 1 789E 06 3 470E 06 F 1 Revised on August 2006 Red colored and italic typed values are revisions Inhalation Correction Factor INH unitless BeBe Re Re BR BPD VINNY NN LPfVYN WNW KFeP eenn e RRP NNNWD Toxicological Properties Gastroint Inhalation Oral Carcinogenic i Inhalation Dermal estinal Carcinogenic y Potency Factor with Reference Absorption Absorption CalEPA s TEF for Potency Factor with Dose Fraction Conversion CalEPA s TEF for Factor PANS cPAHs R D ABS GI CPF CPF mg kg day unitless unitless kg day mg kg day mg 1 7 0 03 0 8 1 7 0 03 0 8 0 085 0 03 0
20. 8 0 085 0 03 0 8 0 085 0 1 0 5 0 1 05 0 1 0 5 0 114 0 03 0 8 0 00086 0 03 0 8 0 05 0 1 0 5 0 1 0 5 0 1 0 5 0 00855 0 0005 0 95 0 055 0 027 1 4 0 03 1 0 286 0 03 0 92 0 029 0 03 0 9 0 00086 0 13 0 89 0 05 0 01 0 8 0 00086 0 01 0 8 0 2 0 03 0 8 0 857 0 00257 0 03 0 8 85 0 76 0 0014 0 03 0 8 0 091 0 091 0 13 0 89 0 73 0 61 0 13 0 89 0 73 0 61 0 13 0 89 0 73 0 61 0 13 0 89 7 3 6 1 0 13 0 89 0 073 0 061 0 13 0 89 2 92 2 44 0 13 0 89 0 73 0 61
21. A Mi 4 4 gt x Soil Cleanup Level for Unrestricted Land Use and Industrial Land use based on the evaluation of the following pathways Refer to WAC 173 340 720 740 745 747 and 750 Soil Direct Contact Standard and Modified Method B Unrestricted and C Industrial Use 1 2 Ground Water Protection 3 phase Equilibrium Partitioning Model 3 Air Quality Protection provided for informational purposes only und Water Cleanup Level for Method B amp C Refer to WAC 173 340 720 Air Cleanup Level for Method B and C Refer to WAC 173 340 750 informational purposes only SELECT TO PROCEED SELECT TO EXIT WORKBOOK Caution to Users MTCASGL 11 0 Version NO 11 August 1 2006 Rea NUM By opening MTCATPH11 xls the user will view Figure 1 2 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 Figure 1 2 Opening Title Screen of MTCATPH ial Fe Edit View Insert Format Tools Data Window Help a fe 2 m RETEA ae PERPER I EESO Soil Cleanup Level for Unrestricted Method B and Industrial Method C Land Uses 1 Protection of Soil Direct Contact Pathway Human Health Method B unrestricted land use Method C industrial land use 2 Protection of Ground Water Quality Leaching Pathway Based on protection of human health Method B Based on a target TPH ground water concentration already adjusted 3 Protection of Air Quality Vapor Pathway Method B only
22. Cleanup Levels ceceeseeeeseeeeeees 3 LS Overview OF File Sisirin eimen e ae a a Ea r Eo a aS E See eaS 4 1 31 ZIP Archive Fil Download oroe a saneeae date vere eames 4 1 3 2 Hardware and Software Requirements to run the Workbooks 00 4 TA Getting Startede iasa ee o E e EE A R e ENEE NR EE 5 1 4 1 Installing the Workbooks iscicisessadcassassetassosentasnacesaasevaatesasesnnassasaanisaivaceaseanaceutes 5 1 4 2 Assessing the Worksheet and Opening the title Screen eeeeeeeeeeeeeees 6 1 5 Common Error Messages and Troubleshooting Operating Tips ceeeeeeeeeees 7 1 6 Saving and Closing the Workbook 0 0 0 0 eeccceescecescecseececeeeeeceeneecesaeeeeseeesneeeenaees 12 Chapter 2 MTCASGL Workbook for Calculating Cleanup Levels for Individual Hazardous Substances cccacccsscenccesscdceetssussces consees entacceddocssessensdecasasocusesgssansess 13 Dit OVERVIEW iena noia i e i i Stes e E a a i Shoag Als 13 2 2 Whats New on MTCASGL 11 Version 11 woo ccceccessccecececeeesssssseceeeeeens 14 2 3 Calculating Soil Cleanup Levels Soil Worksheet seeneeseeseeeseseereesererrrrrrsreeee 15 2 3 1 Accessing the Soil Worksheet 4008 entails pasadena earns 15 2 3 2 Caution on Use of the Soil Worksheet ceeecceeneceenceceeeeeeceeeeeceteeeesaes 15 2 3 3 Equations and Parameters 4 200 oca kau deka ieee heeded 16 2 3 4 Entering Data for Input Parameters 2 20 24 4 otic eh 17 2 3 5 Output Interpreting the Result 1s cdc
23. EC gt 21 34 h fe bo bo OjJojvi e 4 n i W 1 Methyl Naphthalene 2 Methyl Naphthalene O A O O 0 07 a 845 45 100 00 Avoid Double Counting The petroleum fractions include hazardous substances that may also be individually quantified depending upon the type of mixture s present at a site see Table 830 1 in WAC 173 340 900 If you have quantified one or more August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 47 hazardous substances that are included in one of the TPH Equivalent Carbon EC fractions you need to make sure to subtract those concentrations from the appropriate EC fraction concentrations Otherwise you are double counting that particular substance Table 3 3 provides information on the individual substances that are represented by a particular EC fraction Table 3 3 Equivalent Carbon Numbers Equivalent Number of Carbon Carbon Associated EC Fraction Hazardous Substance n Hexane CHo AL_EC gt 5 6 Ethylbenzene and Xylenes CgHio AR_EC gt 8 10 Naphthalene CjoHs AR_EC gt 10 12 1 Methyl Naphthalene C Hio AR_EC gt 12 16 2 Methyl Naphthalene C Hjo AR_EC gt 12 16 Benzo a anthracene C gH 2 AR_EC gt 21 34 Benzo b fluoranthene Cy 9H 2 AR_EC gt 21 34 Benzo k fluoranthene C29H 2 AR_EC gt 21 34 Benzo a pyrene C20H12 AR_EC gt 21 34 Chrysene CigH 2 AR_EC gt 21 34 Dibenz a h anthracene C H 4 AR_EC gt 21 34 Indeno 1 2 3
24. Navigator box 3 7 2 1 Accessing the Soil Worksheet In the MTCATPH Workbook Navigator Box select Worksheet Al Data Entry 3 7 2 2 Input Data Part 1 Enter Logistical Site Information User specified text format is entered here As shown in Figure 3 3 enter descriptive text for the identification of a particular site or a sample or a project such as date site name sample name and additional information if necessary MTCATPH does not require the user to enter information for any of these entries as they are solely there for the benefit of the user Figure 3 3 Site Information 1 Enter Site Information Site Name ABC sto Sample Name ECY fresh gasoline default 3 7 2 3 Input Data Part 2 Enter Measured Soil Concentration The second part of the worksheet illustrated in Figure 3 4 requires the user to input analytical data soil concentrations dry basis mg kg in the non shaded white cells for the chemicals of concern and petroleum EC groups appropriate for the type of TPH mixture being evaluated Note that the right hand column automatically calculates the percentage of the total mixture represented by the particular fraction compound Be sure that the correct and consistent units are used for all chemical concentrations milligrams kilogram mg kg ppm and that you use the same number of significant figures as reported by the laboratory Enter zero 0 for substances that are not analyzed 1 e
25. Soil Ingestion Rate 200 50 mg day Gastrointestinal Absorption 10 10 nitless fraction Exposure Duration 6 20 unitless Exposure Frequency 1 0 0 4 years Soil Cleanup Level mg kg Chemical specific Chemical specific kg day mg B 1 Equations 740 3 and 745 3 Soil Direct Contact Ingestion Dermal Petroleum Mixtures Non Carcinogenic Risk HI x ABW x AT SIRx ABI amp Fo SAx AF F p X ABS ag 10 mg kg lt RfD 10 mg kg RD soil EF x ED x o i DefaltVaue sd Value Method B Method C Equation 740 3 Equation 745 3 Parameter Definition TPH soil cleanup level mg kg Hazard Index 1 1 unitless Average Body Weight over the exposure duration 16 70 kg AT Averaging Time 6 0 20 years EF Exposure Frequency 1 0 0 7 unitless ED Exposure Duration 6 0 20 years SIR Soil Ingestion Rate 200 50 mg day ABI Gastrointestinal Absorption fraction 1 0 1 0 unitless Fo Fraction by weight of petroleum component i Chemical specific Chemical specific unitless SA Dermal Surface Area 2 200 2 500 cm AF Adherence Factor 0 2 0 2 mg cm day ABS d i Dermal Absorption Fraction for petroleum component i See Note 1 See Note 1 unitless RAD oii Oral Reference Dose for petroleum component
26. USED IN THE PROGRAM Aqueous Solubility S This parameter is used to calculate the soil saturation limit Csat This soil saturation limit corresponds to the theoretical chemical concentration in soil at which sorption limits of the soil particles solubility limits of the soil pore water and saturation of soil pore air have all been reached The parameter is chemical specific The aqueous solubility of the contaminant must be entered as milligrams of contaminant per liter of water mg L Information on solubility for common contaminants can be obtained from the scientific literature These literature values may be used provided the requirements in WAC 173 340 702 14 15 and 16 are met August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 23 2 3 4 5 Input Data Part 5 Target Ground Water Cleanup Level The fifth part of the worksheet illustrated in Figure 2 6 requires the user to input the target ground water cleanup level for the site The target ground water cleanup level is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the target ground water cleanup level The parameter is site and chemical specific Figure 2 6 Target Ground Water Cleanup Level 5 Target Ground Water Cleanup Level Target Ground Water Cleanup Level applicable for a soil cleanup Ground Water CUL level calculation Cy 02574 Jug l Method A CUL for Result
27. air quality The program indicates whether or not the measured concentration current condition is above or below the acceptable risk indices pass fail e Cleanup Levels for Soil and Potable Ground Water The Workbook provides the tools necessary to calculate protective soil concentrations under Method B and Method C The Workbook back calculates a protective concentration based on the target risk levels carcinogenic and non carcinogenic set forth in the regulation For soil the Workbook calculates a protective concentration for the direct contact pathway the leaching pathway protection of ground water and the vapor pathway protection of air quality This calculated cleanup level might be lower or higher than the concentration actually measured in the sample The MTCASGL Workbook consists of two worksheets the Worksheet for Calculating Soil Cleanup Levels see Section 2 3 and the Worksheet for Calculating Potable Ground Water Cleanup Levels see Section 2 4 The Worksheet for Calculating Soil Cleanup Levels soil worksheet provides tools for evaluating both the direct contact pathway and the leaching pathway e For the evaluation of the direct contact pathway the worksheet uses the equations provided in the regulation see Appendix B The worksheet allows the user to evaluate the soil ingestion pathway alone or in conjunction with the dermal pathway e For the evaluation of the leaching pathway the worksheet uses the 3 p
28. cd pyrene C22H12 AR_EC gt 21 34 3 7 2 4 Input Data Part 3 Enter Hydro geological Characteristics of the Site The third part of the worksheet illustrated in Figure 3 5 requires the user to input default or site specific data for the following hydro geological characteristics of the site Figure 3 5 Entering Site specific Hydrological Data 3 Enter Site Specific Hydrogeological Data Total soil porosity Unitless Volumetric water content Unitless Volumetric air content 0 13 Unitless Soil bulk density measured kg L Fraction Organic Carbon Unitless Dilution Factor Unitless Total Soil Porosity n This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific Enter the default value of 0 43 or enter a site specific value determined under WAC 173 340 747 6 d iii D using site specific measurements Note that the sum of the volumetric water content and the volumetric air content must equal the total soil porosity The site specific soil porosity may be calculated using the following equation August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 48 Po Ps n l Table 3 4 Porosity Calculation Default Value Total soil porosity Calculated unitless Dry soil bulk density 1 50 see note 1
29. chemical specific data The regulation specifically describes which parameters may be adjusted and how they may be adjusted The Workbooks described in this User s Guide provide the necessary tools for calculating protective soil and ground water concentrations under modified Method B or Method C For the calculation of soil cleanup levels the Workbooks provide tools for evaluating the direct contact pathway the leaching pathway protection of ground water and the vapor pathway protection of air quality For the evaluation of the direct contact pathway the Workbooks use the equations provided in the regulation The Workbooks allow the user to evaluate the soil ingestion pathway alone or in conjunction with the dermal pathway For the evaluation of the leaching pathway the Workbooks use the 3 phase and 4 phase equilibrium partitioning models described in the regulation to calculate a soil cleanup level that will not cause an exceedance of the ground water cleanup level established under WAC 173 340 720 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 e For the evaluation of the vapor pathway the Workbooks provide informational tools for calculating air cleanup levels and soil concentrations that will not cause an exceedance of the air cleanup level established under WAC 173 340 750 NOTE The tools for evaluating the vapor pathway are provided for informational purposes only Please consult the regulation and the sit
30. consists of two sets of worksheets the Worksheet set for e Calculating Soil TPH Cleanup Levels e Calculating Ground Water TPH Cleanup Levels 3 2 Prerequisites for Use To use the MTCATPH Workbook the user should be familiar with the concept of TPH fractions and the analytical requirements for TPH mixtures Special analyses are required for various types of TPH mixtures see Table 830 1 in WAC 173 340 900 to adequately characterize TPH for evaluation using this Workbook tool Depending on the type of TPH analysis may also be required for specific volatile petroleum components BTEX fuel additives semi volatile compounds and other contaminants A primer on TPH mixtures fractions and analytical requirements is included in Appendix E August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 36 The fundamental equations associated parameters physical chemical properties of TPH fractions and default values for calculating soil cleanup levels based on the leaching pathway protection of ground water are set forth in WAC 173 340 747 and reproduced in Appendices C and F revised An in depth technical discussion of the model theory equilibrium partitioning for soil to ground water exposure pathway is included in a separate article Park and San Juan 20007 3 3 Restrictions and Cautions on Use The MTCATPH Workbook uses the three and four phase equilibrium partitioning models to calculate soil concentrations that are pr
31. contact pathway the leaching pathway protection of ground water and the vapor pathway protection of air quality 2 3 3 1 Direct Contact Pathway For the evaluation of the direct contact pathway the worksheet uses the standard equations provided in the regulation see Appendix B The worksheet allows the user to evaluate the soil ingestion pathway alone or in conjunction with the dermal pathway For each of the parameters used in the equations default assumptions values are set forth in the regulation to calculate standard Method B or C cleanup levels Under modified Methods B and C specified default assumptions may be adjusted based on site specific or chemical specific data The regulation specifically describes which parameters may be adjusted and how they may be adjusted e IF the regulation does not allow a parameter to be adjusted THEN the worksheet uses the default value for that parameter provided in the regulation Also the parameter is not listed in the worksheet and the user may not input data for that parameter e IF the regulation allows a parameter to be adjusted THEN the parameter is listed in the worksheet and the user may input either the default value provided in the regulation or a site specific or chemical specific value derived under the regulation 2 3 3 2 Leaching Pathway For the evaluation of the leaching pathway the worksheet uses the 3 phase equilibrium partitioning model described in the regulation
32. inputs are used for See Figure 2 1 Figure 2 1 Examples of Footnotes 2 1 Oral Reference Dose 2 2 Oral Carcinogenic Potency Factor 2 3 Inhalation Reference Dose 2 4 Inhalation Carcinogenic Potency Factor Soil ingestion only Soil dermal contact Soil to ground water leaching pathway Ground water ingestion Soil to air vapor pathway VVVVV AR WN Codes are revised to reduce memory requirements file size and simulation time and to increase calculation efficiency August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 15 2 3 Calculating Soil Cleanup Levels Soil Worksheet 2 3 1 Accessing the Soil Worksheet Once the MTCASGL Workbook is successfully loaded into Excel the title sheet will appear Be sure to enable the MACROs To use the Workbook tool click on the START button to exit click on the END button It is important to use the END button to exit the Workbook so your previous default Excel settings toolbars work area format are restored Selecting the START button makes the soil worksheet appear on your screen light blue background Note the following regarding the structure and contents of the soil worksheet e Non colored white cells in the sheet are used for data entry other cells in the Workbook are write protected and cannot be modified e The sheet is divided split into two windows one s
33. kg L Soil particle specific gravity 2 65 see note 2 kg L Footnotes 1 Use the default value of 1 50 kg L or use a site specific value derived under WAC 173 340 747 5 c 2 Use the default value of 2 65 kg L or use a site specific value derived under WAC 173 340 747 6 d iii D A site specific value may be derived by measuring the soil particle specific gravity using ASTM Method D854 00 Volumetric Water Content 6 This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific Enter the default value of 0 30 or enter a site specific value derived under WAC 173 340 747 5 d using site specific measurements Note that the sum of the volumetric water content and the volumetric air content must equal the total soil porosity Volumetric Air Content This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific The value for volumetric air content CANNOT be entered The Workbook automatically calculates a value based on the values entered for total soil porosity n and volumetric water content using the following equation 0 n 6 If the default values for total soil porosity n 0 43 and volumetric water content 4 0 3 are entered then the default vol
34. level before clicking on the button values for the following parameters must be entered in the soil worksheet August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 24 e Oral Reference Dose RfD Part 2 e Oral Carcinogenic Potency Factor CPF Part 2 e Inhalation Correction Factor INH Part 3 The Workbook calculates a potable ground water cleanup level based on the values entered for these parameters and the parameters listed in the ground water worksheet The potable ground water cleanup level calculated using the ground water worksheet must be manually adjusted as described in Section 2 4 and then manually entered in the soil worksheet as noted in Section 2 4 WARNING The Workbook DOES NOT automatically enter the result from the ground water worksheet 2 3 4 6 Input Data Part 6 Hydrogeological Characteristics of the Site The sixth part of the worksheet illustrated in Figure 2 7 requires the user to input default or site specific data for the following hydrogeological characteristics of the site Figure 2 7 Site specific Hydrological Information 6 Site Specific Hydrogeological Characteristics Total Soil Porosity default 0 43 Volumetric Water Content default 0 30 Volumetric Air Content default 0 13 Dry Soil Bulk Density default 1 50 Fraction Soil Organic Carbon default 0 001 for metals enter 1 for fo value here Dilution Factor default 20 for
35. of carbon mass of soil This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific e For organic hazardous substances enter the default value of 0 001 or enter a site specific value derived under WAC 173 340 747 5 b G The Workbook calculates a value for K4 using the foe value entered here and the Koc value entered in the fourth part of the worksheet using Equation 747 2 Ka Koc X foc August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 26 e For metals enter 1 for the fse value here and enter the distribution coefficient Ka instead of the Koc value in the fourth part of the worksheet Soil samples that are analyzed for foce must be collected outside the area of contamination and below the root zone The results are usually reported as percent organic carbon The reported value can be converted to a fraction by dividing by 100 Dilution Factor DF This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific Enter the applicable default value 20 for unsaturated zone soil and 1 for saturated zone soil or enter a site specific value derived under WAC 173 340 747 5 f using site specific estimates of infiltration and ground water flow rate Note
36. pathway are provided for informational purposes only Please consult the regulation and the site manager for more information regarding whether the pathway must be evaluated and how the pathway may be evaluated 3 5 2 Calculating Ground Water Cleanup Levels The ground water worksheet uses the standard equations provided in the regulation see Appendix A For each of the parameters used in the equations default assumptions values are set forth in the regulation to calculate standard Method B or C cleanup levels Under modified Methods B and C specified default assumptions may be adjusted based on site specific or chemical specific data The regulation specifically describes which parameters may be adjusted and how they may be adjusted Irrespective of whether a parameter may be adjusted under the regulation the worksheet uses the default value for that parameter provided in the regulation Also the parameter is not listed in the worksheet and the user may not input data for that parameter The default values for parameters are documented in the Data Base accessed using MAINI the tool navigator and in Appendix F The user should refer to these sources to understand the basis for the cleanup levels calculated using the MTCATPH Workbook August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 42 3 6 Navigating the Workbook and Visual Organization of the Workbook Interface The Workbook uses a pop up dial
37. protective of surface water Figure 3 6 Entering Target TPH Ground Water Concentration 4 Target TPH Ground Water Concentation if adjusted If you adjusted the target TPH ground water concentration enter adjusted 355 ug L alue here 7 U S EPA 1996 Soil Screening Guidance Technical Background Document EPA 540 R 95 128 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 50 3 7 2 6 Notes for Data Entry Figure 3 7 Notes for Data Entr Notes Data Entry for soil and ground water exposure pathways Data Entry for soil and ground water exposure pathways 1 All data at the data entry cell non colored cell except header information must be numeric values Use of alphabetical characters i e ND NA lt gt or will cause an error 2 Try to avoid double counting The Petroleum Equivalent Carbon EC fractions include many individual substances that must be analyzed separately When entering the concentration of Petroleum EC fraction into the data entry cell make sure you subtract the concentration of individual substances from the appropriate EC fraction See User s Guide 3 For the values of Petroleum EC fraction measurement below the method detection limit substitute one half the method detection limit For the values for Petroleum EC fraction measurement above the method detection limit but below the practical quantitation limit substitute the method detection limit Ho
38. required then leave this input box blank Dermal Absorption Fraction ABS This parameter is used to calculate a soil concentration that is protective of human health based on direct contact The parameter is specifically used to evaluate dermal contact The parameter is chemical specific Enter a chemical specific value established under WAC 173 340 740 3 c i1 C or 173 340 745 5 c 4i C or enter the applicable default value listed below 0 01 for inorganic hazardous substances 0 0005 for volatile organic compounds with a vapor pressure Benzene 0 03 for volatile organic compounds with a vapor pressure lt Benzene 0 1 for other organic hazardous substances NOTE Vapor pressure of Benzene is 0 125 atm or 95 mm Hg 95 torr 12 7 kPa at 25 C The applicable default value for a chemical is published in CLARC If an evaluation of the dermal pathway is not required then leave this input box blank Gastrointestinal Absorption Conversion Factor GI This parameter is used to derive a dermal reference dose based on the oral reference dose or a dermal cancer potency factor based on the oral cancer potency factor The dermal toxicity index is derived by dividing or multiplying the oral index by GI RfD R D xGI or CPF CPF GI August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 21 This parameter is chemical specific Enter a chemical specific value established under WAC 173 340 740 3 c 1 C or
39. return to the navigation tool August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 44 3 7 Calculating Soil TPH Cleanup Levels 3 7 1 Quick Instruction on How to Calculate the Soil TPH Cleanup Levels See Figure 3 2 for the quick instruction for calculating soil TPH cleanup levels Figure 3 2 Quick Calculation Instruction for Soil TPH Cleanup Levels r Quick Calculation Instruction Quick Instruction for Calculating Soil TPH Cleanup Levels 1 Data Entry Step Leave blank if there are no data availabe On the MTCATPH Tool Navigator select A1 button Under Section 1 enter site information Under Section 2 enter measured soil concentrations Under Section 3 enter site specific hydrogeological data or enter MTCA default values by selecting Set Default Hydrogeology button Under Section 4 enter site specific target TPH ground water concentration that is already adjusted if applicable and known Select Main button to return to the MTCATPH Tool Navigator 2 Calculation Step On the MTCATPH Tool Navigator select A2 button In response to question enter y or n Select Execute Calculation button e If the Warning dialogue box appears then follow the instructions shown for how to calculate a protective TPH soil concentration Select Print button to obtain a hard copy of the calculation inputs and outputs e Select
40. see Appendix C to calculate a cleanup level that will not cause an exceedance of the ground water cleanup level established under WAC 173 340 720 For each of the parameters used in the equations the user may input either the default value provided in the regulation or a site specific or chemical specific value derived under the regulation For the evaluation of the leaching pathway the worksheet also checks for soil saturation limits and warns the user if the soil saturation condition is exceeded 2 3 3 3 Vapor Pathway For the evaluation of the vapor pathway the worksheet first uses the standard equations provided in the regulation see Appendix D to calculate air cleanup levels For each of the parameters used in the equations default assumptions values are set forth in the regulation to calculate standard Method B or C cleanup levels Under modified Methods B and C specified default assumptions may be adjusted based on site specific August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 17 or chemical specific data The regulation specifically describes which parameters may be adjusted and how they may be adjusted Irrespective of whether a parameter may be adjusted under the regulation the worksheet uses the default value for that parameter provided in the regulation Also the parameter is not listed in the worksheet and the user may not input data for that parameter Second the worksheet converts the calculated a
41. the leaching pathway protection of ground water The sheet is divided into different columns and boxes that can be used to view results or develop what if analyses These areas are shown in the figure on the next page Current Condition When first viewed the results displayed are for the current condition Check to see that the total soil concentration being tested at the bottom of the column is the same as the total concentration listed in Sheet Al The information provided in the columns from left to right is as follows August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 57 e Measured Soil Concentration dry weight basis mg kg These concentrations correspond to the data entered in Sheet A It is provided for reference and is not changed by any of the adjusted condition calculations e Ground Water Cleanup Level Method A ug L These concentrations are the Method A ground water cleanup levels listed in Table 720 1 The Method A cleanup level is used to determine whether a chemical meets applicable requirements under state and federal law ARARs and the risk criteria for individual hazardous substances under Method B RISK 1 x10 for carcinogens and HQ 1 for non carcinogens The Method A cleanup levels in Table 720 1 were calculated under Method B and account for ARARs protection of human health natural background concentrations and practical quantitation limits e Predicted Concentra
42. total soil volume Use a default value of 0 43 ml ml or use a value determined from site specific measurements Volumetric water content ml water ml soil For unsaturated soil use a default value of 0 3 or a value determined from site specific measurements For saturated soil this value is unknown and must be solved for Volumetric water content equals the total soil porosity minus volume occupied by the NAPL Volumetric air content ml air volume ml total soil volume For unsaturated soil this value is unknown and must be solved for Volumetric air content equals the total soil porosity minus the volume occupied by the water and NAPL For saturated soil this value is zero Volumetric NAPL content ml NAPL volume ml total soil volume For both unsaturated and saturated soil this value is unknown and must be solved for C 3 Equation 747 7 Four Phase Partitioning Equilibrium Equation Mi x S l GFW O FRK fae Pe iG i S Poit NAPL soil P b i m Mole fraction at equilibrium of each component dimensionless This value is unknown and must be solved for Water Solubility of each component mg L See Table 747 4 for petroleum hydrocarbons see the scientific literature for other hazardous substances a Dry soil bulk density default is 1 5 kg L i T Xi Si Pb i oc Soc Total soil mass kg This value is derived from site specific measurements SOL Soil organic carbon water partitioning coeff
43. unsaturated zone soil 1 for saturated zone soll or site specific Total Soil Porosity n This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific Enter the default value of 0 43 or enter a site specific value determined under WAC 173 340 747 6 d iii D using site specific measurements The site specific soil porosity may be calculated using the following equation Po Ps n 1 Table 2 1 Forosity and Density Information Total soil porosity Calculated unitless Dry soil bulk density 1 50 see note 1 kg L Soil particle specific gravity 2 65 see note 2 kg L August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 25 Footnotes 1 Use the default value of 1 50 kg L or use a site specific value derived under WAC 173 340 747 5 c Use the same value as entered in Part 6 of the worksheet 2 Use the default value of 2 65 kg L or use a site specific value derived under WAC 173 340 747 6 d iii D A site specific value may be derived by measuring the soil particle specific gravity using ASTM Method D854 00 Note that the sum of the volumetric water content and the volumetric air content must equal the total soil porosity Volumetric Water Content G This parameter is used to calculate a soil concentration that is protective of ground water t
44. used for entering data and evaluating the potable ground water cleanup level Additional buttons provided at the MTCATPH Tool Navigator are Quick Instruction There are two quick instruction buttons which show the user how to calculate soil TPH cleanup levels and ground water TPH cleanup levels These buttons explain how to enter the data and to execute the calculation for establishing the TPH cleanup levels Default Residual Saturation Screening Levels This shows the default residual saturation screening levels for different TPH mixtures as set forth in WAC 173 340 900 Table 747 5 For a soil concentration to be protective of ground water the regulation requires that the concentration must not result in the accumulation of non aqueous phase liquid NAPL on or in the ground water WAC 173 340 747 2 b The default residual saturation screening levels may be used to determine whether the soil concentration calculated using the three and four phase models meets the regulatory requirement Site specific residual saturation screening levels may also be established See WAC 173 340 747 10 Abbreviations This shows the list of abbreviations used in the MTCATPH Workbook Data Base This shows the supporting physical chemical and toxicological information used in the Workbook calculations for TPH fractions and associated hazardous compounds Click on MAIN in the upper left corner to
45. 0z Equivalent Carbon Group or Chemical August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 63 3 7 5 Output Adjusting the Results Optional As noted previously see Section 3 3 the soil cleanup levels calculated using the soil worksheet DO NOT account for several factors Consequently to establish a soil cleanup level under the regulation the cleanup level calculated using the worksheet may need to be manually adjusted to account for the following e Concentrations established under applicable state and federal laws WAC 173 340 740 3 b i or 173 340 745 5 b i e Terrestrial ecological impacts see WAC 173 340 740 3 b Gi or 173 340 745 5 b i e Impacts on air quality vapor pathway see WAC 173 340 740 3 b 11 C c iv or 173 340 745 5 b Gii C c iv e Residual saturation see WAC 173 340 747 2 b and 10 and e Total site risk see WAC 173 340 740 5 a or 173 340 745 6 a August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 64 3 8 Calculating Ground Water TPH Cleanup Levels 3 8 1 Quick Instruction on How to Calculate the Ground Water TPH Cleanup Levels See Figure 3 23 Figure 3 23 Quick Instruction for Calculating TPH Ground Water Cleanup Levels Quick Instruction Quick Instructions for Calculating TPH Ground Water Cleanup Levels On the MTCATPH Tool Navigator select B button Under Section 1 enter site information Under Secti
46. 1 Methyl Naphthalene 2 Methyl Naphthalene n Hexane MTBE Ethylene Dibromide EDB 1 2 Dichloroethane EDC Benzo a anthracene Benzo b fluoranthene Benzo k fluoranthene Benzo a pyrene Chrysene Dibenz a h anthracene Indeno 1 2 3 cd pyrene Revised Properties of Chemicals commonly found at Petroleum Contaminated Sites Note Please refer to CLARC for the source of Database Physical Chemical Properties Molecular Weight GFW mg mol 8 100E 04 1 000E 05 1 300E 05 1 600E 05 2 000E 05 2 700E 05 4 000E 05 1 200E 05 1 300E 05 1 500E 05 1 900E 05 2 400E 05 7 800E 04 9 200E 04 1 060E 05 1 060E 05 1 280E 05 1 422E 05 1 422E 05 8 600E 04 8 800E 04 1 879E 05 9 900E 04 2 283E 05 2 523E 05 2 523E 05 2 523E 05 2 283E 05 2 780E 05 2 763E 05 Aqueous Solubility mg L 3 600E 01 5 400E 00 4 300E 01 3 400E 02 7 600E 04 1 300E 06 1 500E 11 6 500E 01 2 500E 01 5 800E 00 5 100E 01 6 600E 03 1 750E 03 5 260E 02 1 690E 02 1 710E 02 3 100E 01 2 500E 01 2 460E 01 9 500E 00 5 000E 04 3 400E 03 8 520E 03 9 400E 03 1 500E 03 8 000E 04 1 620E 03 1 600E 03 2 490E 03 2 200E 05 Henry s Law Carbon Water Constant unitless 3 300E 01 5 000E 01 8 000E 01 1 200E 02 5 200E 02 4 900E 03 1 000E 05 4 800E 01 1 400E 01 5 300E 02 1 300E 02 6 700E 04 2 280E 01 2 720E 01 3 230E 01 2 790E 01 1 980E 02 2 100E 02 2 120E 02 7 400E 01 1 800E 02 1 290E 02 4 010E 02 1 370E 04 4 550E 03 3 400E 05 4
47. 10 Library Solver for MS Excel XP amp 2002 e C Program Files Microsoft Office Office Library Solver for MS Excel 97 Figure 1 6 Locating Solver Built In Function a Microsoft Visual Basic MTCATPH11 0 xls Object Browser E y Eg rt Format Debug Run Tools Add Ins Window Help Type a question for hep f x gt y Oe all Me Se lt All Libra P References VBAProject Available References ME Visual Basic For Applications Microsoft Excel 11 0 Object Library OLE Automation Microsoft Forms 2 0 Object Library Browse Microsoft Office 11 0 Object Library v looku a Isover atpvbaen xis Priority ExcelAccess Help Applicat funcres Areas Ref Edit Control A Assista TbRun97Project E AutoCoh C JAS Helper COM Component 1 0 Type Libr Mua PIX E9 AutoF ilt F TAS RADIUS Protocol 1 0 aer Librarv Lookin SOLVER ae ek Ey 4 AutoReq EN E maes SOLVER32 DLL E Axis RINER SS SOLVER XLA S AxisTitle Location C Program Files Microsa Balloon Language English United States Balloont Ballooni BalloonLabel eS Assistant BalloonLabels AssistantBtn Border Atn Borders a Auto_Add File name ee 71 J W CalculatedFields Auta clase ai lt All Libraries gt Files oftype All Files Immediate x 4 gt 4 Once the file is located be sure it s the one with the xla extension click on it hig
48. 173 340 745 5 c ii C or enter the applicable default value listed below e 0 2 for inorganic hazardous substances e 0 8 for volatile organic compounds 0 5 for other organic hazardous substances The applicable default value for a chemical is published in CLARC If an evaluation of the dermal pathway is not required then leave the input box blank 2 3 4 4 Input Data Part 4 Physical and Chemical Properties of the Chemical The fourth part of the worksheet illustrated in Figure 2 5 requires the user to input chemical specific data for the following physical and chemical properties of the chemical Figure 2 5 Physical and Chemical Properties 4 Physical and Chemical Properties of the Chemical Chemical Specific Sol Organe Carbou Water Partitioning Coefficient for metals enter K value here and enter 1 for fy value Ca 6T0EH0S ky Henry s Law Constant for the evaluation of ground water and vapor exposure pathway 3 320 04 funitless the value for Henry s Law Constant is given n the unit of atm mol enter value here 8 300E 06 atmmt mol Converted untlss form of Hy 13 C Enter this converted value into H y input Box above for a calculation 35355 04 witless Solubility of the Chemucal in Water for the calculation of sou saturation Lut 2 S00E 02 mg l Soil Organic Carbon Water Partitioning Coefficient Ko This parameter is used to calculate a soil concentration that is protective of ground water tha
49. 4 2 628E 03 2 628E 04 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 30 For the direct contact pathway the worksheet first calculates HQ and RISK under Method B and Method C based on the current site conditions Noncarcinogenic Risk under the Current Condition This is the hazard quotient HQ based on the measured soil concentration The worksheet calculates the HQ using the direct contact equations in the regulation ingestion only AND ingestion dermal and solving for HQ Carcinogenic Risk under the Current Condition This is the carcinogenic risk under the current condition based on the measured soil concentration The worksheet calculates the carcinogenic risk using the direct contact equations in the regulation ingestion only AND ingestion dermal and solving for carcinogenic RISK For the direct contact pathway the worksheet next calculates protective soil concentrations under Method B and Method C based on the regulatory standards for HQ and RISK Target Soil CUL HQ 1 This is the protective soil concentration based on noncarcinogenic risk The worksheet calculates the protective soil concentration using the direct contact equations in the regulation ingestion only AND ingestion dermal Target Soil CUL RISK 1x 10 Method B or 1 x 10 Method C This is the protective soil concentration based on carcinogenic risk The worksheet calculates the protective soil concentration
50. 4 4 User Input Soil and Ground Water Worksheets To calculate a potable ground water cleanup level the Workbook requires the user to input data for several parameters some of which are listed in the soil worksheet The following parameters necessary for calculating a potable ground water cleanup level are listed in the soil worksheet and must be entered there e Oral Reference Dose RfD Part 2 e Oral Carcinogenic Potency Factor CPF Part 2 e Inhalation Correction Factor INH Part 3 The following parameters necessary for calculating a potable ground water cleanup level are listed in the ground water worksheet and must be entered there e Practical Quantitation Limit for Ground Water if known e Natural Background Ground Water Concentration if known e Most stringent ground water concentration based on applicable state and federal laws August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 33 This worksheet requires the user to provide information listed on the left side see illustration shown in Figure 2 9 Data is entered in the corresponding non shaded white boxes on the right Figure 2 9 Example Method B Ground Water Cleanup Levels 1 Calculation of Method B Cleanup Levels for Potable Ground Water Basis for Ground Water Concentration Concentration based on non carcinogenic nisk HQ 1 0 Concentration based on carcinogenic risk Risk 1 in 1 000 000 1 0E 6 Concentration based on carcinog
51. Applicable State or Federal Laws This parameter is used to calculate a ground water cleanup level and is chemical specific Enter the most stringent lowest ground water concentration criteria established under applicable state or federal law for the chemical of concern Ground water concentrations criteria established under applicable state or federal law are published in CLARC August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 34 2 4 5 Output Interpreting the Result For hazardous substances for which sufficiently protective health based concentrations have been established under applicable state and federal laws the worksheet establishes a ground water cleanup level based on the most stringent of those concentrations A concentration established under applicable state and federal laws is sufficiently protective if the excess cancer risk does not exceed 1 in 100 000 1 x 10 and the hazard quotient does not exceed one 1 If the concentration is not sufficiently protective the worksheet calculates a protective concentration by adjusting the concentration downward in accordance with WAC 173 340 720 7 b using the equations provided in the regulation For hazardous substances for which health based concentrations have not been established under applicable state and federal laws the worksheet calculates a protective concentration using the equations provided in the regulation If the ground water cleanup le
52. Chemical specific Chemical specific mg kg day Mixture specific Mixture specific unitless Footnotes 1 Use value of 2 for volatile organic compounds and 1 for all other substances A 2 Appendix B Equations and Default Values for Calculating Protective Soil Concentrations based on the Direct Contact Pathway Equations 740 1 and 745 1 Soil Direct Contact Ingestion Only Noncarcinogens R D x ABW x UCF x HQ x AT SIR x AB1 x EF x ED Soil Cleanup Level mg kg Default Value Units Parameter Definition Method B Method C Equation 740 1 Equation 745 1 Oral Reference Dose Chemical specific _ Chemical specific mg kg day Average Body Weight over the exposure duration Unit Conversion Factor 1 0E 6 1 0E 6 mg kg 16 70 kg Soil Ingestion Rate 200 50 mg day Gastrointestinal Absorption 1 0 10 tles fraction Exposure Frequency 1 0 unitless Hazard Quotient 1 0 l 0 unitless Averaging Time 6 20 years Exposure Duration 6 20 years Equations 740 2 and 745 2 Soil Direct Contact Ingestion Only Carcinogens RISK x ABW x AT x UCF CPF x SIR x AB x ED x EF DefaltVaue Value Parameter Definition Method B Method C Equation 740 2 Equation 745 2 Acceptable cancer risk level mg kg day Average Body Weight over 16 70 k the exposure duration Unit Conversion Factor 1 0E 6 1 0E 6 mg kg Oral Carcinogenic Potency Factor Averaging Time 75 75 years
53. Chemical specific 1 L kg Water filled soil porosity 0 3 unitless ml ml Air filled soil porosity 0 13 unitless ml ml Henry s law constant Chemical specific 2 unitless Dry soil bulk density 1 5 kg L Chemical specific ug L Footnotes 1 The regulation specifies default values for certain chemicals and procedures for establishing chemical specific values See WAC 173 340 747 4 c 2 The regulation specifies default values for certain chemicals and procedures for establishing chemical specific values See WAC 173 340 747 4 d Equation 747 2 Derivation of a Distribution Coefficient Kz for Organic Hazardous Substances based on the Soil Organic Carbon Water Partitioning Coefficient Koc K Ky X foc Parameter Definition Default Value Units calculated or site Distribution coefficient xe specific ml g L kg Soil organic carbon water partitioning coefficient Soil fraction of organic carbon 0 001 unitless g g Chemical specific 1 ml g L kg Footnotes 1 The regulation specifies default values for certain chemicals and procedures for establishing chemical specific values See WAC 173 340 747 4 c i C 1 Equation 747 3 Deriving a Dilution Factor from Site Specific Estimates of Infiltration and Ground Water Flow Volume pr 20 2 _ 1 Qo QO Q Parameter Definition Default Value Dilution Factor calculated unitless Flowrate of water infil
54. Factor 1 000 1 000 ug mg Inhalation Carcinogenic Potency Chemical Chemical Factor specific specific kg day mg Breathing Rate m day Inhalation Absorption fraction unitless Exposure Duration 30 30 unitless Exposure Frequency 1 0 1 0 years D 1 Appendix E Primer on TPH Fractions and Analytical Requirements for TPH Mixtures Unlike individual hazardous substances petroleum hydrocarbon mixtures such as gasoline diesel fuel lubricating oils etc are comprised of thousands of chemical compounds Typically the concentration of these mixtures is measured as total petroleum hydrocarbons or TPH that represents the expected range of these materials such as the gasoline range or the diesel range In reality these measured concentrations are the collective concentrations of the individual petroleum compounds A laboratory test result for NWTPH Gx expressed as 235 mg kg milligrams of TPH per kilogram of soil for example represents the measured total TPH concentration in the sample within the range of compounds typically contained in gasoline TPH mixtures can also contain specific chemicals of concern and depending on the type of mixture they may need to be tested to make sure a site is adequately characterized and that all cleanup requirements are considered These include volatile compounds such as benzene toluene ethylbenzene and xylenes collectively referred to as BTEX
55. Section 3 7 3 of Soil Cleanup Levels Calculation Result Summary Confirm that Predicted TPH well would match with target TPH ground water concentration previously entered in the data sheet A1 If both do not match users need to find the soil TPH concentration by entering fine tuning specific soil TPH concentrations and check the results Sheet A2 1B Evaluation of the Direct Contact Pathway under Method B Unrestricted Land Use Current Condition Results for the current condition based on the soil data entered in Sheet A are shown in two places in the sheet First a summary box shown in Figure 3 9 is located in the upper right hand portion of the sheet Figure 3 9 Test Current Condition Box August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 54 This box provides the total concentration mg kg of all the TPH fractions and compounds entered by the user and the corresponding hazard index and cancer risk In this particular example the Pass Fail indicates a Pass since both the carcinogenic and non carcinogenic risks do not exceed the allowable level established for Method B for mixtures under 173 340 708 5 Second the three columns located to the right of the data entry columns heading Current Condition provide the detail necessary to determine which fractions and chemicals are contributing to the hazard index and carcinogenic risk The sums of the hazard quotient and tot
56. The soil cleanup levels calculated using the Workbooks DO NOT account for the following Concentrations established under applicable state and federal laws Concentrations based on protection of air vapor pathway Concentrations based on protection of terrestrial ecological receptors Residual saturation limit for protection of ground water and Total site risk The soil cleanup levels calculated using the Workbooks might need to be manually adjusted to account for these considerations 1 2 2 Calculation of Potable Ground Water Cleanup Levels The potable ground water cleanup levels calculated using the Workbooks account for the following Concentrations established under applicable state and federal laws Concentrations based on protection of human health Natural background concentrations and Practical quantitation limits The potable ground water cleanup levels calculated using the Workbooks DO NOT account for the following e Concentrations based on potential surface water impacts August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 e Nonaqueous phase liquid NAPL limitation and e Total site risk The ground water cleanup levels calculated using the Workbooks might need to be manually adjusted to account for these considerations 1 3 Overview of Files 1 3 1 ZIP Archive File Download The zip archive file MTCACALC11 exe contains two MS Excel files 2003 version format and one MS Word file 2003
57. al carcinogenic risk are shown at the bottom of their respective columns Pass Fail Criteria A failure is registered IF either of the following conditions is true e Fora single hazardous substance TPH component and a cPAHs mixture the hazard quotient exceeds 1 or the carcinogenic risk exceeds 1 x 10 or e For total site risk TPH mixture the hazard index exceeds or the sum of the carcinogenic risk exceeds 1 x 10 Calculating Protective Condition This tool allows the user to calculate protective TPH soil concentration based on several soil quality criteria The Workbook uses the same composition ratio as for the measured data See Figure 3 10 Figure 3 10 Calculate Protective Condition Box CALCULATE PROTECTIVE CONDITION This tool allows the user to calculate protective TPH soil concentration based on various soil quality criteria The Workbook Calculate Protective uses the same composition ratio as for the TPH Soil Conc measured data Selected Criterion Benzene Risk 1E 6 ee ee e e e Protctive TPH Soil Conc mg kg 511801 33 HI 1 58E 02 ae e ae The Calculate Protective TPH Soil Conc back calculates a TPH concentration using the relative fraction compound percentages based on the entered data that meets the non carcinogenic hazard index of 1 or the 1 x 10 carcinogenic risk for multiple hazardous substances total site risk depending on the sol quality criterion buttons selected See floatin
58. allows the user to test whether a particular TPH soil concentration is protective of human health The Workbook Test Adjusted uses the same composition ratio as for the TPH Soil Conc measured data Tested TPH Soil Conc mg kg Pass or Fail August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 56 Figure 3 13 Dialogue Box for Entering Soil TPH Concentration Microsoft Excel Enter the soil TPH concentration mg kg that you want ee Cancel m 3 7 4 2 Sheet A2 1C Evaluation of the Direct Contact Pathway under Method C Industrial Land Use The sheet for evaluating the direct contact pathway under Method C industrial land use has all the same features as described in Section 3 7 4 1 above for the unrestricted land use scenario Under Method C cleanup levels are calculated the same as under Method B except that concentrations that are protective of human health are calculated using a less stringent target cancer risk for individual hazardous substances 1 x 10 and less stringent default exposure assumptions see Appendix B and Figure 3 14 Figure 3 14 Buttons for Soil Quality Criteria for Method C Select the particular soil quality criterion for which you want to calculate a protective TPH soil concentration HI 1 Total Risk 1E 5 3 7 4 3 Sheet A2 2 Evaluation of the Leaching Pathway Protection of Ground Water Sheet A2 2 provides additional detail regarding the evaluation of
59. amages or losses of any nature or kind including but not limited to any compensatory direct special incidental indirect or consequential damages whatsoever including without limitation damages for injuries to persons or property loss of business profits business interruption loss of business information or any other pecuniary or non pecuniary loss arising out of or relating to the use of or inability to use this manual and associated software even if the State of Washington and associated parties have been advised or are aware of the possibility of such damages This manual and associated software are not intended and cannot be relied on to create rights substantive or procedural enforceable by any party in litigation with the State of Washington Ecology reserves the right to act at variance with this User s Guide or associated software at any time Table of Contents List of Figures ii List of Tables iv List of Acronyms and Abbreviations v Chapter 1 HritrOa a Cee Oi vacccisces secs oiccpasccaceccdveacavcuciasnccsacsteecacandoceteaceeasbancactonnecpnsecascnceraanes 1 1 1 Purpose of the Workbook Tools xsisscsccssesccatavecsansviagcccas saavaaancs sanntas soacdasnacensscasouanacens 1 1 2 Caution on Use of the WiGtk BOOKS ys 515d cavacdsacuaceadcasucede cd saacocasdvaceaal sccadianraaeiaienceaee 3 1 2 1 Calculation of Soil Cleanup Le velSx icon taige eter cases deus tiated dacs teteteseadeaassts 3 1 2 2 Calculation of Potable Ground Water
60. ame Otherwise answer no and you will exit the Workbook without saving any changes Note The Workbook should be closed exited using the END button at the top of the sheet Do not close the Workbook using the typical means provided in Excel ie FILE CLOSE or clicking on the X Using the END button allows the programmed routines in the Workbook to return the Excel toolbar displays and other format options to those you normally use August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 13 Chapter 2 MTCASGL Workbook for Calculating Cleanup Levels for Individual Hazardous Substances 2 1 Overview The MTCASGL Workbook allows the user to use chemical and toxicity data site specific information and risk based exposure assumptions to calculate either of the following for a single chemical contaminant e Risk under Current Conditions The Workbook provides the tools necessary to calculate the risk carcinogenic and non carcinogenic under current conditions To calculate the risk under current conditions the Workbook requires the user to enter a measured soil or ground water concentration The Workbook then executes a forward calculation using the equations in the regulation and solving for risk For soil measurements the Workbook calculates the risk corresponding to the direct contact pathway the leaching pathway protection of ground water and the vapor pathway protection of
61. and Summary of Results Default Residual Saturation Levels Abbreviations August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 43 NOTE EACH WORKSHEET IN THE WORKBOOK CONTAINS A BUTTON LABELED MAIN THIS BUTTON CAN BE USED TO GO BACK TO THE NAVIGATION BOX SHOWN ABOVE ONCE YOU ARRIVE AT A PARTICULAR WORKSHEET USING THE NAVIGATION BOX MTCATPH Tool Navigator YOU MUST CLICK ON THE Close BUTTON AT BOTTOM BEFORE CONTINUING WORKSHEETS A AND B ARE NOT LINKED TO EACH OTHER As shown in the hierarchical structure only sheets A 1 and B are used for data entry Sheet A2 is used for the execution of calculation and calculation summary results for establishing soil TPH cleanup levels Sheets A2 1B and A2 1C are used to examine the detailed calculation results for the soil direct contact pathway under the unrestricted and industrial land use scenarios that result from the data entry for soil Section 3 7 of this User s Guide provides additional discussion of the results and evaluation options presented in these sheets This detail is useful in determining what TPH fractions or other compounds are actually causing a risk exceedance and therefore what components may be driving a site cleanup action Similar information is provided in sheets A2 2 and A2 3 for the leaching pathway protection of ground water and the vapor pathway protection of air quality Sheet B is
62. ard Method B or C cleanup levels Under modified Methods B and C specified default assumptions may be adjusted based on site specific or chemical specific data The regulation specifically describes which parameters may be adjusted and how they may be adjusted Irrespective of whether a parameter may be adjusted under the regulation the worksheet uses the default value for that parameter provided in the regulation Also the parameter is not listed in the worksheet and the user may not input data for that parameter The default values for parameters are documented in the Data Base accessed using MAIN the tool navigator and in Appendix F revised The user should refer to these sources to understand the basis for the cleanup levels calculated using the MTCATPH Workbook 3 5 1 2 Leaching Pathway For evaluation of the leaching pathway the worksheet uses the three and four phase equilibrium partitioning models depending upon NAPL formulation described in the regulation see Appendix C to calculate a cleanup level that will not cause an exceedance of the ground water cleanup level established under WAC 173 340 720 For each of the parameters used in the equations the user may input either the default value provided in the regulation or a site specific or chemical specific value derived under the regulation 3 5 1 3 Vapor Pathway August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 41 For evaluation o
63. ased on protection of human health and does not account for several site specific factors and or gt Based on adjusted site specific target ground water cleanup level e Natural background concentrations and e Practical quantitation limits Hun Seak Park and Charles San Juan 2000 A Method for Assessing Leaching Potential for Petroleum Hydrocarbons Release Sites Multiphase and Multi substance Equilibrium Partitioning Journal of Soil and Sediment Contamination 9 6 61 1 632 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 37 The soil cleanup levels calculated using the soil worksheet DO NOT account for the following Concentrations established under applicable state and federal laws as of this writing there are no applicable soil criteria for substances that are part of a TPH mixture Concentrations based on protection of air quality vapor pathway Concentrations based on protection of terrestrial ecological receptors Residual saturation limit for protection of ground water or Total site risk where chemicals other than petroleum mixtures co exist at a site e g chlorinated solvents The soil cleanup levels calculated using the soil worksheet may need to be manually adjusted to account for these considerations see Section 3 7 5 Note Unlike the previous version the revised MTCATPH Workbook DOES provide the user the additional means to manually enter the target TPH ground water cleanup level i
64. assusssasssesccecsssgetstsaesdcatasesies ach seaateaneaass 27 2 3 6 Output Adjustment of Result cscccsseagec ceccscasuasteady wcesacndewedacasaneceaacnendeats 31 2 4 Calculating Potable Ground Water Cleanup Levels Ground Water Worksheet 3 1 2 4 1 Accessing the Ground Water Worksheet ccccceessecceeeeceeeeeceeeeeesteeeesaes 31 2 4 2 Caution on Use of the Ground Water Worksheet 0 eecceeeseeeeeeeeeeeeeeeees 31 2 4 3 Equations and Parameters si ssciccisiieacsseiiceseorte nevsdaeisenicaansesatiantearusiaa 32 2 4 4 User Input Soil and Ground Water Worksheets seseeeseeeeeeeeeeeereesreerees 32 2 4 5 Output Interpreting the Result 02 2 0 sess nies h cue ort pedtcccct a coed sees acum does and 34 2 4 6 Output Adjustment of Result cee ecsssecssceessececssccecssecessscceesseeeenees 34 2 4 7 Output Transfer of Adjusted Result to Soil Worksheet eee 34 Chapter 3 MTCATPH Workbook for Calculating Cleanup Levels for a Petroleum Mixture e eesosseseoseesoesossesossossesocsoesossossesossossesoosoessesossossesossossesee 35 Sel OveryleW eion tere ieis t a AE Ea abe INSEKSA ETE ESEE ESA aa 35 Dy a ETES O DN E E A EEE E E E 35 3 3 Restrictions and Cautions On WSC sisson sates Mastery T E T R 36 3 3 1 Calculating Soil Cleanup Levels sais sssdesssagciiavessdeatasectaeacesetacsautecdenteedaans 36 ii 3 3 2 Calculating Ground Water Cleanup Levels sseeeseeseesseeressessresrersererssressesee 37 3 4 Wh
65. ats New on MTCATPH 11 Version 11 wo cccccessccecececeeesssrsaeeeeeceees 38 3 5 Overview of Equations and Parameters ceesceceeseeceeeeeceeeeeceeeeeceteeeenneeeenaeeees 39 3 5 1 Calculating Soil Cleanup We vels coos es scccaseinsesshecacesiyony scuseozeasianssteshocsvessess 39 3 5 2 Calculating Ground Water Cleanup Levels ccceeeceeeeseeeeeeeeceseeeeeteeeeeaes 41 3 6 Navigating the Workbook and Visual Organization of the Workbook Interface 42 3 7 Calculating Soil TPH Cleantip Levelsici3 2s 2 9c pace ie dincees oan tigie ne 44 3 7 1 Quick Instruction on How to Calculate the Soil TPH Cleanup Levells 44 3 7 2 Entering Data Input A esis cccssctesveccivevevegstevnntctants Gegdaseceaesaascnacease decedanacaaees 45 3 7 3 Executing the Calculation and Analyzing the Output Calculation Summary PADDLE assesses foes Bees Sebo ese hoes Soa ees SR Ges Ne Ss Sova OES oe SOR Oe ae 50 3 7 4 Advanced Features Optional s 6c sagccesecsssessdegetveasdecaseasstereesesndendgdaganteasinsses 52 3 7 5 Output Adjusting the Results Optional ssssssssssesssesssssessseesseesseessereseee 63 3 8 Calculating Ground Water TPH Cleanup Levels eeeseeeeeeeseeseeesreeresressrsererresse 64 3 8 1 Quick Instruction on How to Calculate the Ground Water TPH Cleanup EAA TPE EE E EEE E EE E AT E E 64 3 8 2 Entering Data Input nosine nnna a a E ai 64 3 8 3 Executing the Calculation and Analyzing the Output eeeeeereeeeee
66. atural Background NB Soil Concentration if known This parameter is used to adjust the soil cleanup level if necessary Methods for defining natural background concentrations are provided in WAC 173 340 709 Ecology has published information on background levels of certain metals Natural Background Soil Metals Concentrations in Washington State Publication No 94 115 Practical Quantitation Limit PQL for Soil if known This parameter is used to adjust the soil cleanup level if necessary The PQL is the lowest concentration of the contaminant that can be reliably measured within specified limits of precision accuracy representativeness completeness and comparability during routine laboratory operating conditions using department approved methods The analytical laboratory or site manager can assist in identifying the appropriate PQL Checkbox Is an evaluation of the dermal pathway required The checkbox item at the bottom of the first part of the worksheet requires the user to indicate whether an evaluation of the dermal pathway is required to calculate a soil concentration that is protective of human health based on direct contact To determine whether an evaluation of the dermal pathway is required see WAC 173 340 740 3 c Gii and 173 340 745 5 c iii If an evaluation of the dermal pathway is required then the user must enter a check in the checkbox and enter values for the following exposure parameters in Part 3 below
67. be assessed as part of the aromatic fraction gt EC12 to EC16 which you must already test for This is because the toxicity and the physical and chemical properties of 1 Methyl Naphthalene are very similar to those of the aromatic fraction gt EC12 to EC16 In addition there are no routine testing methods specifically for 1 Methyl Naphthalene other testing methods would need to be modified to test for it e g modification of calibration stock solution and or GC MS library scanning module gt The references doses inhalation and oral for several petroleum fractions and individual hazardous substance were updated Additional and more detailed information regarding the nature and basis for these changes can be found in Appendix F of this document and on the CLARC web site https fortress wa gov ecy clarc CLARCHome aspx https fortress wa gov ecy clarc FocusSheets petroToxParameters pdf e New summary tables for soil TPH cleanup levels calculation A2 Calculation and Summary of Results and Ground Water TPH cleanup levels calculation were added e The Workbook was revised to allow users to automatically calculate both soil and ground water cleanup levels for TPH by clicking just one button Previously the user August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 39 had to either toggle with different back calculation buttons or manually adjust the TPH levels to establish the protective concentrations See Secti
68. below the practical quantitation limit substitute the method detection limit For a hazardous substance or petroleum fraction that has never been detected in any sample at a site and these substances are not suspected of being present at the site based on site history or other knowledge enter 0 for that value If the sample has been analyzed using both the VPH Volatile Petroleum Hydrocarbons and EPH Extractable Petroleum Hydrocarbons methods use the higher value for the fraction where there is an overlap between these two methods All entries must be numeric values A text entry will cause a VALUE error to appear in one or more columns to the right This must be corrected or the Workbook will not execute its calculations correctly Note that the right hand column provides where available the listed Method A ground water cleanup levels for certain chemicals to facilitate direct comparison Avoid Double Counting Refer to Section 3 7 2 for details 3 8 3 Executing the Calculation and Analyzing the Output Click on MAIN in the upper right corner to return to the navigation tool Open the MTCATPH Tool Navigator and click the button B Current Condition Results for the current condition with ground water concentration measured are shown in two places in the sheet First a summary box shown in Figure 3 26 is located in the upper right hand portion of the sheet Figure 3 26 Testing Current Condition Box
69. bservations and what if options as described further in later sections 3 7 4 Advanced Features Optional Every worksheet in the MTCATPH Workbook provides a means for observing and evaluating the results based on the entered data The following discussion of these observations and analytical tools are organized by worksheet As described previously the Workbook allows the user to examine two situations e First the Workbook provides the tools necessary to calculate the risk carcinogenic and non carcinogenic under current conditions To calculate the risk under current conditions the Workbook requires the user to enter a measured soil or ground water concentration The Workbook then executes a forward calculation using the equations in the regulation and solving for risk e Second the Workbook provides the tools necessary to calculate protective concentrations under Method B and Method C The Workbook back calculates a protective concentration based on the target risk levels carcinogenic and non carcinogenic set forth in the regulation Confirmation Step to Verify Calculation Results The user can verify information shown in the Calculation Results Summary table discussed in Section 3 7 4 by conducting the following steps August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 3 7 4 1 53 Evaluation of Soil Direct Contact open A2 1B for Method B or A2 1C for Method C Worksheet dependin
70. ceedance of the ground water cleanup level The parameter is site specific Enter the applicable default value 20 for unsaturated zone soil and 1 for saturated zone soil or enter a site specific value derived under WAC 173 340 747 5 f using site specific estimates of infiltration and ground water flow rate Note that the default value of 20 might not be sufficiently protective of the ground water for a site where the source size is significantly larger than a half acre as specified by the EPA 3 7 2 5 Input Data Part 4 Enter target TPH ground water concentration if adjusted optional If you adjusted the target TPH ground water concentration enter the adjusted value here As described in Section 3 3 2 the potable ground water cleanup level calculated by the Workbook does not account for 1 concentrations based on potential surface water impacts 2 the nonaqueous phase liquid NAPL limitation or 3 total site risk where chemicals other than petroleum mixtures exist at a site This new feature of the Workbook allows the user to manually adjust the calculated value and enter the adjusted value into the Soil Worksheet The user may also use this feature to e Calculate a soil concentration that is protective of non potable ground water by entering the non potable ground water cleanup level or e Calculate a soil concentration that is protective of surface water quality by entering the ground water concentration that is
71. centration is more stringent than either the natural background concentration or the PQL If the calculated concentration is lower more stringent than either the natural background concentration or the PQL then the worksheet adjusts the calculated concentration upward to the natural background concentration or the PQL whichever is higher less stringent Soil Saturation Limit Csat mg kg The soil saturation limit corresponds to the chemical concentration in soil at which sorption limits of the soil particles solubility limits of the soil pore water and saturation of soil pore air have all been reached It is an indicator a theoretical threshold that the chemical may exist as a separate pure phase in August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 29 the soil and if it is a liquid may exist as a nonaqueous phase liquid with additional hazards to ground water quality Retardation Factor R unitless The retardation factor is the ratio of the ground water flow velocity to contaminant migration velocity If the retardation factor is 10 the contaminant plume in the saturated zone would move on average ten times slower than the ground water flow This result is provided so that the user can assess the chemical s relative mobility in the ground water The result is not used in calculating the soil cleanup level 2 3 5 2 Summary of Results by Exposure Pathway The second table example shown in Table 2 3
72. cument E August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 6 Save a working file under a user specified different from original name Use the END button when closing the file Note Do not attempt to run the Workbooks without saving the files to your hard drive It may cause the error messages as described below or the Workbooks may not run properly It is important to use the END button when closing the file And it is good practice to save working files under a new name 1 4 2 Assessing the Worksheet and Opening the title Screen Once the Workbook is successfully loaded into MS Excel the title sheet will appear Be sure to enable the MACROs To use the Workbooks click on the START button to exit click on the END button It is important to use the END button to exit the Workbook so your previous default MS Excel settings toolbars work area format are restored Selecting the START button makes the Navigator appear on your screen light blue background By opening MTCASGL11 xls you will view Figure 1 1 At this point you should see the following title screens as it appears below Figure 1 1 Opening Title Screen of MTCASGL Microsoft Excel 5_workingfile_MTCASGL11 XLS iii Fie Edit View Insert Format Tools Data Window Help DJ 101 MY Be ara 10 B Z ae ta 2a ca T a Hy ga Ic i i il l b 4 sf te i
73. der Sections 1 4 and 1 5 below describes how to check the status of these elements and make the appropriate modifications so that the Workbooks can run without encountering errors Note Workbooks are offered for use without warranty or support They are made to work with MS Excel 2003 and may not work properly with other applications or with early versions of MS Excel It is recommended that you have no other files open in Excel when using these Workbooks 1 4 Getting Started 1 4 1 Installing the Workbooks This section provides instructions for installing and opening the two Workbook files Once the Workbook is copied to your hard drive several modifications and changes to your MS Excel add in components are required to allow the routines contained in the Workbook to operate correctly To install the Workbook follow these instructions 1 Copy and save the Workbook file to the directory of choice Open Excel and then open the file or simply double click the Workbook icon as you would do with any other Excel file Click YES if you are asked about enabling the MACRO Click Don t Update when you are asked about updating links 5 On the Tools menu click Add Ins In the Add Ins available box select the check box next to solver Add In and then click OK If the add in you want to use is not listed in the Add Ins available box click Browse and then locate the add in as explained in this section of this do
74. e manager for more information regarding whether the pathway must be evaluated and how the pathway may be evaluated For the calculation of ground water cleanup levels the Workbooks provide tools for calculating only potable ground water cleanup levels as defined in the regulation When establishing cleanup levels for hazardous substances at a site the site manager often asks two types of questions e Is the measured or current concentration at the site protective e If not what is the protective concentration The Workbooks allow the user to answer both of these questions The Workbooks provide the tools to calculate the risk under current site conditions forward calculation and to calculate protective concentrations backward calculation if the measured concentrations at the site are not protective In the first instance the Workbooks require the user to enter measured soil or ground water concentrations The Workbooks then execute a forward calculation using the equations in the regulation and solving for risk In the second instance the Workbooks back calculate a protective concentration based on the target risk levels set forth in the regulation Also the Workbooks provide printing and previewing capabilities for all input and output screens This User s Guide describes the capabilities and limitations of the Workbooks and provides step by step instructions for installing and using the Workbooks This information is
75. eeastasieestocein sh Mceauaeneteterayeavatbeaabeeatieueks 64 Figure 3 25 Entering Ground Water Concentration Measured eeeeeseseeeeeneeeeeeees 65 Figure 3 26 Testing Current Condition Box ceeeeseesseceseeceseceseeeeseecsaecnseeseeeeeneesnaeens 66 Figure 3 27 Calculate Protective Condition BOX lt 4 4s cetc cele adie lcleneeead ss 67 Figure 3 28 Floating Buttons for Calculating Protective Ground Water TPH 68 Figure 3 29 Test Adjusted Condition BOX s 2 2 22 s 2ececases cos eeieoasas dae eta teecde niente aeeae 69 iv List of Tables Table 1 1 Description Of Workbooks 2 0 eee eseceseceeeeeseeeseneeeaceceaecaeessneesaeecsaecnseessneesaee 4 Table 2 1 Porosity and Density Information 00 0 0 cee eeececeeneeceeeeeceeneeceeeeeceeneeeeeeeeenaeees 24 Table 2 2 Calculation Summary Table si i c gsnecocecsave caaeaussdaceysceapeudscsdnase niles ansbesedsbasanncatnd 28 Table 2 3 Summary of Calculation for Each Exposure Pathway cscceeseeeeseeeeeteees 29 Table 3 1 Method B Equations v gcccasseccesaseseaasasuessecesssaaeenssccndee sesuaceusunscens seceeseaanenaneetebonees 40 Table 3 2 Method C BQu ations eunes inn ei r e ei siS 40 Table 3 3 Equivalent Carbon Numbers sssseesseeesseeesseessensseeesseessseessressersseeesseeesseesseesse 47 Table 3 4 Porosity Calculation sx ccas costs 28 5 aeseeaseaateassaasadsqaseechdaseccmiadoeeeaaciteesatagneeeee ee 48 Table 3 5 Summary of Calculation Results for Soil TPH 0 eee e
76. eee reads eee ee 18 Figure 2 3 Toxicological Properties J ce Aid esct csctied nce ies tees tect eeiee inal uh ete ne catteie 19 Figure 2 4 Exposure Parameters 1 2 0 aie1 eters dihtdaeeaaeceedeateeeee 19 Figure 2 5 Physical and Chemical Properties 0 ceeeesceessecsseeeseeesscecseeceaeeeseeeeneeseaeens 21 Figure 2 6 Target Ground Water Cleanup Level eee eesceeceeseeeneeceeecseeeseeesneeesaeenes 23 Figure 2 7 Site specific Hydrological Information cee ceeeeeeeeeeseeceeeceseeeeeeeeneeenaeens 24 Figure 2 8 Vapor Attenuation PactOrics a c5 2 itt eli acc eect peak eee os Ae ie tia 26 Figure 2 9 Example Method B Ground Water Cleanup Levels cee sceeeeeeeeeseeeneeeees 33 Figure 3 1 Overview of MTCATPH Interface Navigator cece eeeeeeeeeereeeeeeenaeees 42 Figure 3 2 Quick Calculation Instruction for Soil TPH Cleanup Levels eee 44 Fig rte 3 3 S1te Information a3 ite natin ata ae ica accede at EA E E de ade sales 45 Figure 3 4 Entering Soil Concentration Measured 0 ceeeesceeeeeeeseeceeeceseeeeeeeeaeeeaeens 46 Figure 3 5 Entering Site specific Hydrological Data o eee eeeeeeseeceeceneeeeeeeeneeeaeens 47 Figure 3 6 Entering Target TPH Ground Water Concentration 0 0 00 cee eeeeeeeeeeneeeneeeees 49 Figure 3 7 Notes for Data Entry scire e rata a E ELEA EREE ee 50 Figure 3 8 Calculating with New Data Entered eseseseeeeseseesessessresreesersrerrreseessrseresresse 50 Figure 3 9 Test Current Condition BOX
77. eeeeeeeeeeeeseeenneees 51 List of Acronyms and Abbreviations used in the MS Excel Workbooks and This User s Guide AL_EC AR_EC BTEX CLARC Conc cPAHs EC Ecology EPA GW HI HQ MCL mg kg MTCA MW NA NAPL PQL RISK TPH ug L WAC 100 NAPL Aliphatic Equivalent Carbon number Aromatic Equivalent Carbon number Benzene Toluene Ethylbenzene and Xylenes Ecology Cleanup Levels and Risk Calculations under the Model Toxics Control Act Cleanup Regulation Refer to Ecology s interactive web site at https fortress wa gov ecy clarc CLARCHome aspx Concentration Carcinogenic Polycyclic Aromatic Hydrocarbons Equivalent Carbon number Washington State Department of Ecology U S Environmental Protection Agency Ground Water Hazard Index Hazard Quotient Maximum Contaminant Level milligrams per kilogram for soil media sample same as part per million ppm Model Toxics Control Act Molecular Weight Not Applicable Nonaqueous Phase Liquid Practical Quantitation Limit Carcinogenic Risk Total Petroleum Hydrocarbon micrograms per liter for ground water media sample same as parts per billion ppb Washington Administrative Code TPH concentration at which air filled pore volume is completely filled by equilibrated NAPL This concentration is usually well above Residual Saturation Level See Appendices A through F for definitions of the parameter abbreviations found in the equations v
78. egulation and references the applicable procedures for deriving a site specific or chemical specific value under the regulation Header Information In the rectangular box at the top of the soil worksheet enter the date site name and evaluator name NOTE Once an evaluation has been completed for a particular site it is good practice to print out the results Click on the Preview or Print button to confirm that the proper header information appears on all printout sheets Remember to change the header information EACH TIME a new set of data is entered 2 3 41 Input Data Part 1 General Information The first part of the worksheet illustrated below in Figure 2 2 requires the user to input the following general information August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 18 Figure 2 2 General Information Symbol Value Unit 1 General information Name of Chemical Measured Soil Concentration 1f any Natural Background Concentration for Soil Practical Quantitation Limit for Soil To evaluate the ingestion and dermal pathways concurrently check here and input values for AF ABS GI Name of Chemical Enter the name of the chemical to be evaluated Measured Soil Concentration if known This parameter is used to calculate the carcinogenic and non carcinogenic risk at the site under current conditions Enter the soil concentration in milligrams per kilogram of soil dry weight basis N
79. elect the cell pull down the format menu select Cells and click on the Number tab Change either the format length of column or the font size of the cell until the value is visible DIV O or HNAME is displayed in a box The most common cause of this problem is that some input data are missing Double check to make certain that all of the input cells required for your run have data in them The buttons won t work Click on another cell or hit the enter return key and then click the buttons and they should work Text labels appear to be cut off On some monitor resolutions in MS Windows some cell labels may appear cut off This should affect only the screen display and in most cases printouts should not be affected Other potential error messages and opening more than one Workbook at a time It is possible that you may receive other error messages when trying to open the Workbooks Be sure the MACROs are activated in order to use the tools properly Some error Messages may require you to refer to online help or the documentation of the host application Check with your network operator or information technology specialist to be sure your MS Excel application can accept MACROs operation and to address other host application related errors It is not advisable to load and use more than one copy of the Workbook at the same time It may cause it to function improperly Resizing and rescaling the gra
80. enic risk Risk 1 in 100 000 1 0E 5 Enter Practical Quantitation Limit of Ground Water Enter Natural Background Level of Ground Water 0 0 1 Enter Most stringent concentration based on Applicable State or Federal Laws Method B Potable Ground Water Cleanup Level 2 574E 01 Practical Quantitation Limit PQL for Ground Water if known This parameter is used to adjust the ground water cleanup level as provided in WAC 173 340 720 7 c if necessary The parameter is chemical specific The PQL is the lowest concentration of the contaminant that can be reliably measured within specified limits of precision accuracy representativeness completeness and comparability during routine laboratory operating conditions using Department approved methods The analytical laboratory or site manager can assist the user in identifying the appropriate PQL Enter the PQL for the chemical if known If the PQL is not known leave the entry box blank Natural Background Ground Water Concentration if known This parameter is used to adjust the ground water cleanup level as provided in WAC 173 340 720 7 c if necessary The parameter is chemical and site specific Enter the natural background ground water concentration if known Methods for defining natural background concentrations are provided in WAC 173 340 709 If the natural background concentration is not known leave the entry box blank Most Stringent Ground Water Concentration Based on
81. eria The Workbook uses the same composition ratio as for the measured data See Figure 3 27 Figure 3 27 Calculate Protective Condition Box CALCULATE PROTECTIVE CONDITION This tool allows the user to calculate a protective TPH ground water concentration based on various ground water quality criteria The Workbook uses the same composition ratio as for the measured data Calculate Protective TPH GW Conc Selected Criterion Benzene MCL 5 ug L BoP sector rare OR a e Protective TPH GW Conc ug L 209 46 HI 8 31E 01 RISK 7 78E 06 The Button Calculate Protective TPH GW Conc allows the user select the particular water quality criterion for which the user wants to calculate a protective TPH ground water conc This button displays seven tabs to choose as shown in Figure 3 28 Click the Most stringent criterion button Then click Print button for a hardcopy of inputs and outputs this will be used for the confirmation Click the Test Adjusted TPH GW Conc button and enter the value of protective TPH ground water concentration which is maximum ground water TPH concentration to pass shown in the output table Confirm that the calculation result is Pass If the Fail sign appears then users need to find the maximum ground water TPH concentration to pass by entering fine tuning specific ground water TPH concentrations and check the results August 2006 User s Guide for MTCATPH amp MTCASGL Ve
82. eter is chemical specific e For metals except mercury enter the default value of 0 e For mercury enter the default value of 0 47 or enter a value derived from the scientific literature provided the requirements in WAC 173 340 702 14 15 and 16 are met e For components of petroleum mixtures enter the applicable default values provided in Table 747 4 e For individual organic hazardous substances enter a value derived from the scientific literature provided the requirements in WAC 173 340 702 14 15 and 16 are met The applicable default value for a chemical is published in CLARC however default values are not provided for all organic chemicals As of this writing Ecology is planning to publish in CLARC a more comprehensive database of H values for organic chemicals To enter Henry s law constant follow this set of instructions e IF Henry s law constant is provided as a unitless value THEN enter that value in the Hec unitless box e IF Henry s law constant is provided in units of atm m mol THEN the constant must be converted to a unitless value The Workbook provides a conversion tool that allows the user to enter the constant in units of atm m mol to determine the unitless form at 13 C If the conversion tool is used then the converted value provided by the Workbook must still be manually entered by the user in the Hec unitless box NOTE ANY ENTRIES MADE INSIDE THE CONVERSION BOX ARE NOT
83. f the vapor pathway the worksheet first uses the standard equations provided in the regulation see Appendix D to calculate air cleanup levels For each of the parameters used in the equations default assumptions values are set forth in the regulation to calculate standard Method B or C cleanup levels Under modified Methods B and C specified default assumptions may be adjusted based on site specific or chemical specific data The regulation specifically describes which parameters may be adjusted and how they may be adjusted Irrespective of whether a parameter may be adjusted under the regulation the worksheet uses the default value for that parameter provided in the regulation Also the parameter is not listed in the worksheet and the user may not input data for that parameter Second the worksheet converts the calculated air cleanup level into a soil vapor concentration using the vapor attenuation factor manually entered by the user Third the worksheet uses the three or four phase equilibrium partitioning models see Appendix C and the soil vapor concentration to calculate the associated soil concentration the concentration that is protective of air quality at the exposure point point of compliance Ecology is currently evaluating appropriate procedures for evaluating the vapor pathway including the use of vapor attenuation factors and intends to provide further guidance on this issue Note The tools for evaluating the vapor
84. fD x GI see note 3 3 May use chemical specific values or the following defaults 0 2 for inorganic hazardous substances 0 8 for volatile organic compounds 0 5 for other organic hazardous substances B 3 Equations 740 5 and 745 5 Soil Direct Contact Ingestion Dermal Carcinogens For hazardous substances that are part of a petroleum mixture cleanup levels must be calculated using Equations 740 4 and 745 4 for noncarcinogens and Equations 740 5 and 745 5 for carcinogens See WAC 173 340 740 3 b Gii B CU and 173 340 745 5 b 1i B CID For hazardous substances other than petroleum mixtures cleanup levels for dermal contact with the soil must be evaluated whenever the proposed changes to Equations 740 1 745 1 or 740 2 745 2 would result in a significantly higher soil cleanup level than would be calculated without the proposed changes See WAC 173 340 740 3 c ii and 173 340 745 5 c iil oi RISK x ABW x AT soil EF x EDx eae 4 E ten ater 10 mg kg 10 mg kg DefaltVaue Value Parameter Definition Method B Method C Equation 740 5 Equation 745 5 Soil cleanup level mg kg Acceptable cancer risk level OE OE unitless Average Body Weight over the k exposure duration 8 Averaging Time years Exposure Frequency unitless Exposure Duration years Soil Ingestion Rate mg day Gastrointestinal Absorption fraction unitless Dermal Surface Area 2 200
85. ference Dose RfD Enter the inhalation reference dose mg kg day for chemicals having non carcinogenic toxicity The applicable inhalation reference dose for a chemical is published in CLARC Note that an inhalation reference dose may not be available for some chemicals The process for establishing a reference dose is defined in WAC 173 340 708 7 Inhalation Carcinogenic Potency Factor CPF Enter the inhalation carcinogenic potency factor kg day mg for chemicals having carcinogenic toxicity The applicable inhalation cancer potency factor for a chemical is published in CLARC Note that an inhalation cancer potency factor may not be available for some chemicals The process for establishing a cancer potency factor is defined in WAC 173 340 708 8 2 3 4 3 Input Data Part 3 Exposure Parameters The third part of the worksheet illustrated in Figure 2 4 requires the user to input data for the following exposure parameters Figure 2 4 Exposure Parameters 3 Exposure Parameters Inhalation Correction Factor default 2 for volatiles 1 for all others for target ground water cleanup level Inhalation Absorption Fraction default 1 for target aw cleanup level Gastrointestinal Absorption Fraction default 1 for ingestion amp dermal exposure pathways Adherence Factor default 0 2 for dermal exposure pathway Dermal Absorption Fraction chemucal specific or defaults for dermal exposure pathway Gas
86. g buttons shown in Figure 3 11 The result is immediately shown in the box below the buttons August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 55 For all various conditions the details are provided in the four columns to the left under the heading Adjusted Condition The column shows the soil concentration corresponding to the total adjusted concentration and the corresponding hazard index or carcinogenic risk The pass fail criteria are the same as those for the Test current condition Figure 3 11 Floating Calculation Buttons Calculate Protctive TPH So Select the particular soil quality criterion for which you want to calculate a protective TPH soil concentration HI 1 Total Risk 1E 5 Risk of Benzene 1E 6 Risk of all CPAH 1E 6 Risk of EDB 1E 6 Risk of EDC 1E 6 Testing Adjusted Condition The button Test Adjusted TPH Soil Conc allows the user to enter a specific concentration and check the results One of the most useful tools included in the Workbook is the ability to determine based on the relative composition ratio of the sample what TPH concentration would meet the risk based limitations This concentration would be the target soil cleanup level This can be done using the buttons and the box located at the right low portion of the sheet as shown in Figure 3 12 and Figure 3 13 Figure 3 12 Test Adjusted Condition Box TEST ADJUSTED CONDITION This tool
87. g upon the applicable Method a Click Test Adjusted TPH Soil Conc button and enter the value of maximum protective Soil TPH Concentration to pass shown in outputs refer to Section 3 7 3 of Soil Cleanup Levels Calculation Result Summary Confirm the calculation result is Pass If a Fail sign appears then users need to find the maximum soil TPH concentration to pass by entering fine tuning specific soil TPH concentrations and check the results Evaluation of Soil to Ground Water open A2 2 Worksheet Based on Calculated Method B Potable Ground Water Cleanup Level which is based on protection of human health and does not account for several site specific factors a Click on the button Calculate or Test and the subsequent button TPH Test and enter the value of maximum protective Soil TPH Concentration to pass shown in outputs refer to Section 3 7 3 of Soil Cleanup Levels Calculation Result Summary Confirm that the calculation result is Pass If a Fail sign appears then users need to find the maximum soil TPH concentration to pass by entering fine tuning specific soil TPH concentrations and check the results Based on Adjusted Site Specific TPH Ground Water Cleanup Level a Click on the button Calculate or Test and the subsequent button TPH Test and enter the value of Corresponding soil TPH concentration shown in outputs refer to
88. gt 2 16 AL EC gt 6 21 AL EC gt 21 34 AR_EC gt 8 10 AR_EC gt 10 2 gt lt AR_EC gt 22 16 AR_EC gt 16 21 AR_EC gt 2134 Benzene Toluene Ethylbenzene Total Xylenes FIER A Naphthalene 1 E 03 4 t Methyl Naphthalene 2 Methyl Naphthalene Dissolved Concentratio Well ug l E04 4 E n Hexane MTBE 1 E 05 4 Ethylene Dibromide EDB 12 Dichloroethane EDC E 06 4 t Benzo a anthracene Benzo b fluoranthene Benzo k fluoranthene TPH Mass Distribution E07 J Benzo a pyrene Soil TPH mg kg of soil Chrysene Figure 3 20 TPH Mass Distribution in Soil Matrix TPH Mass Distribution in Soil Matrix In Pore Water Phase we aa eee et 212 Tn Pore Air Phase amp at Jn NAPL Phase gt In Dry Solid Phase fon i a fi R Ww a ji 0 HEEE 1 10 100 1000 10000 100000 Soil TPH mg kg of soil August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 62 e Mass Balance Pattern This button allows the user to evaluate the pattern of mass balance with the soil TPH concentration given tested under the same composition ratio as for the measured data and the same hydrogeological data previously entered by the user See Figure 3 21 Three options that the user can choose are gt Mas
89. h missing reference 1 Highlight the file with your cursor if it is not already highlighted 2 Click on Browse at the right side of the dialog box 3 Using the browser locate the missing file probably under Office Library Be sure to select All Files in the Files of Type scroll down window so that all files in the particular folder will be displayed If you still have trouble locating a particular file you may right click on My Computer on your desktop and select Explorer from the pop up menu Then fill in the appropriate file name to search for the location To search for the missing file under MS Windows 2000 a Click Start point to Search and then click For Files or Folders b In Search for files or folders named type all or parts of the missing file name you want to find c In Look in click the drive folder or network you want to search d To specify additional search criteria click Search Options and then click one or more of the options to narrow your search e Click Search Now August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 10 If the file is not located you may need to install it from the source disk or check with your PC administrator In most cases you may be able to find the file SOLVER XLA located in the following folder e C Program Files Microsoft Office Office1 I Library Solver for MS Excel 2003 e C Program Files Microsoft Office Office
90. hase equilibrium partitioning model described in the regulation see Appendix C to calculate a soil cleanup level that will not cause an exceedance of the ground water cleanup level established under WAC 173 340 720 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 14 For the evaluation of the vapor pathway the worksheet uses the equations provided in the regulation to calculate an air cleanup level see Appendix D and then calculates a soil cleanup level that will not cause an exceedance of that air cleanup level using the 3 phase equilibrium partitioning model and the site specific vapor attenuation factor entered by the user NOTE The tools for evaluating the vapor pathway are provided for informational purposes only Please consult the regulation and the site manager for more information regarding whether the pathway must be evaluated and how the pathway may be evaluated The Worksheet for Calculating Potable Ground Water Cleanup Levels ground water worksheet provides tools for calculating cleanup levels for potable ground water The worksheet uses the equations in the regulation see Appendix A The worksheet does not provide tools for calculating cleanup levels for nonpotable ground water 2 2 What s New on MTCASGL 11 Version 11 Very minor modifications are made to enhance the usability of the program Footnotes are inserted for input parameters to indicate which exposure pathway evaluations these
91. hat will not cause an exceedance of the ground water cleanup level The parameter is site specific Enter the default value of 0 30 or enter a site specific value derived under WAC 173 340 747 5 d using site specific measurements Note that the sum of the volumetric water content and the volumetric air content must equal the total soil porosity Volumetric Air Content This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific The value for volumetric air content CANNOT be entered The Workbook automatically calculates a value based on the values entered for total soil porosity n and volumetric water content using the following equation 0 n 86 If the default values for total soil porosity n 0 43 and volumetric water content 0 3 are entered then the default volumetric air content is 0 13 Dry Soil Bulk Density p This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific Enter the default value of 1 50 or enter a site specific value derived under WAC 173 340 747 5 c using site specific measurements Fraction Soil Organic Carbon f The fraction of soil organic carbon is the total mass of organic carbon divided by a unit mass of soil mass
92. hlight it and then click on the Open button The window should return to the Available References list The file should have a check mark next to it Repeat this process for each additional missing file Click OK to close the Available References window 6 Click File in the main toolbar and select Save Close Visual Basic this should return you to the MS Excel Workbook Save the corrected Visual Basic Routines under a new file name if necessary Installation is now complete Check by closing the Workbook and re opening in MS Excel It should open to the title sheet without any error messages ma Note The macro within the Workbook that calls the subroutines operated upon by SOLVER and or LOOKUP does not know where to look on the hard drive it only looks in the August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 11 folder it is operating within UNLESS the user establishes a path to these files for the Workbook If the instruction given above does not work please copy three MS Excel files SOLVER XLA SOLVER32 DLL and LOOKUP DLL or equivalent files for a different version of MS Excel 2003 into the same folder that contains the downloaded Workbook H is displayed in a number box Display properties chosen by users are not compatible with the cell format originally designed for the value e g the number is too big to fit into the cell window To fix this problem s
93. hods including VPH Volatile Petroleum Hydrocarbons and EPH Extractable Petroleum Hydrocarbons for petroleum hydrocarbons are described in a separate Ecology document Analytical Methods for Petroleum Hydrocarbons 1997 t TPH Criteria Working Group 1997 Total Petroleum Hydrocarbon Criteria Working Group Series Volume III Selection of Representative Total Petroleum Hydrocarbon TPH Fractions Based on Fate and Transport Considerations Ed J B Gustafson J G Tell and D Orem Amherst Scientific Publishers NOTE As of this writing this and other volumes are available on the Internet through Amherst Scientific Publishers at http www aehs com publications catalog tph htm Washington State Department of Ecology 1997 Analytical Methods for Petroleum Hydrocarbons Publication No ECY 97 602 E 1 Appendix F Properties of Chemicals commonly found at Petroleum Contaminated Sites Revised August 2006 CAS NO 71 43 2 108 88 3 100 41 4 91 20 3 90 12 00 91 57 6 110 54 3 1634 04 4 106 93 4 107 06 2 56 55 3 205 99 2 207 08 9 50 32 8 218 01 9 57 10 3 193 39 5 Compound or Petroleum Equivalent Carbon Fraction Petroleum EC Fraction AL_EC gt 5 6 AL_EC gt 6 8 AL_EC gt 8 10 AL_EC gt 10 12 AL_EC gt 12 16 AL_EC gt 16 21 AL_EC gt 21 34 AR_EC gt 8 10 AR_EC gt 10 12 AR_EC gt 12 16 AR_EC gt 16 21 AR_EC gt 21 34 Benzene Toluene Ethylbenzene Total Xylenes Naphthalene
94. hows the upper data entry portions and the lower provides the means of viewing the bottom calculation summary portion of the sheet Place your cursor in the upper window to begin data entry If you prefer you can remove the split by clicking on Window in the main toolbar and selecting Remove Split The Calculation Summary shown in the bottom half of the screen is located at the bottom of the sheet 2 3 2 Caution on Use of the Soil Worksheet The soil cleanup levels calculated using the soil worksheet account for the following Concentrations based on protection of human health direct contact pathway Concentrations based on protection of ground water leaching pathway Natural background concentrations and Practical quantitation limits The soil cleanup levels calculated using the soil worksheet DO NOT account for the following Concentrations established under applicable state and federal laws Concentrations based on protection of air quality vapor pathway Concentrations based on protection of terrestrial ecological receptors Residual saturation limit for protection of ground water or Total site risk The soil cleanup levels calculated using the soil worksheet may need to be manually adjusted account for these considerations see Section 2 3 6 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 16 2 3 3 Equations and Parameters The soil worksheet provides tools for evaluating the direct
95. i Chemical specific Chemical specific mg kg day RfDio Dermal Reference Dose for petroleum component i See Note 2 See Note 2 mg kg day GI Gastrointestinal Absorption conversion factor See Note 3 See Note 3 unitless The number of petroleum components petroleum fractions plus volatile organic compounds with an RfD present in the petroleum mixture See Table 830 1 Mixture specific Mixture specific unitless Footnotes 1 May use chemical specific values or the following defaults 0 0005 for volatile petroleum components with vapor pressure benzene 0 03 for volatile petroleum components with vapor pressure lt benzene 0 1 for other petroleum components 2 Derived by RfD x GI see note 3 3 May use chemical specific values or the following defaults 0 8 for volatile petroleum components 0 5 for other petroleum components B 2 Equations 740 4 and 745 4 Soil Direct Contact Ingestion Dermal Noncarcinogens For hazardous substances that are part of a petroleum mixture cleanup levels must be calculated using Equations 740 4 and 745 4 for noncarcinogens and Equations 740 5 and 745 5 for carcinogens See WAC 173 340 740 3 b Gii B CU and 173 340 745 5 b Gi1 B C1 For hazardous substances other than petroleum mixtures cleanup levels for dermal contact with the soil must be evaluated whenever the proposed changes to Equations 740 1 745
96. i Chapter 1 Introduction 1 1 Purpose of the Workbook Tools The purpose of this User s Guide is to introduce the user to the features of two Workbooks MTCATPH and MTCASGL for calculating Soil and Ground Water Cleanup Levels This guide is arranged as a set of tutorials that allow the user to learn the basics of Workbooks in a hands on environment The Model Toxics Control Act MTCA Cleanup Regulation chapter 173 340 WAC sets forth the requirements and procedures for establishing cleanup levels that are protective of human health and the environment The Workbooks described in this User s Guide provide tools for the calculation of Method B and Method C cleanup levels for soil and ground water based on protection of human health The regulation provides for the establishment of both standard and modified Methods B and C cleanup levels Under standard Methods B and C protective concentrations are calculated using standard equations and default assumptions provided in the regulation Except for petroleum mixtures protective concentrations calculated for hazardous substances under standard Methods B and C are published in CLARC One of the Workbooks described in this User s Guide provides the necessary tools for calculating protective soil and ground water concentrations under standard Method B or Method C for petroleum mixtures Under modified Methods B and C specified default assumptions may be adjusted based on site specific or
97. icient for each component L kg See Table 747 4 for petroleum hydrocarbons see WAC 173 340 747 4 b for other hazardous substances M Total mass of each component in the system mg This value is derived from site specific measurements K i fe Mass fraction of soil natural organic carbon default is 0 001 g soil organic g soil Henry s law constant for each component dimensionless See Table 747 4 for He petroleum hydrocarbons see WAC 173 340 747 4 c for other hazardous substances Gram formula weight or molecular weight of each component mg mol See Table GFW 747 4 for petroleum hydrocarbons see the scientific literature for other hazardous substances Molar density of the mixture mol L See Equation 747 8 For petroleum mixtures this means the petroleum fractions and organic hazardous Component substances with a reference dose for other hazardous substances this means each organic hazardous substance that is found in the NAPL C 4 Equation 747 8 Molar Density Equation Za ee Jp S x GFW PrarL ee re DE amp GFW p Gram formula weight or molecular weight of each component mg mol See Table 747 4 for petroleum hydrocarbons see the scientific literature for other hazardous substances Mole fraction at equilibrium of each component dimensionless after equilibration This value is unknown and must be solved for Density of each component mg L See Table 747 4 for petroleum h
98. include A CD ROM drive if you have received the Workbook on CD A hard disk drive with at least 40 MB of free disk space A minimum of 64 megabytes of system memory RAM 486 DX or higher processor running at 66 MHz or faster August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 e Any monitor supported by Windows with video graphics array VGA or better resolution and e An 800 x 600 or higher monitor resolution Recommended software needed to run the Workbook and associated functions is MS Excel version 2003 or XP version for Windows However MS Excel 2000 or earlier should be compatible with the Workbooks The software is implemented as an MS Excel Workbook programmed in Visual Basic and Visual Basic for Applications VBA and requires MS Excel Both Workbooks use automatic procedures programmed in MS Visual Basic However it should not be necessary to have Visual Basic installed on your particular system to operate the Workbook Visual Basic routines included in the Workbook make references or calls to library or add in functions that may or may not be installed on your particular computer or activated in your current MS Excel application Even if these elements are installed the Visual Basic routines need to be edited to provide the correct path for them The Visual Basic routine needs to know where they are on your particular computer s hard drive or network The discussion un
99. ir cleanup level into a soil vapor concentration using the vapor attenuation factor entered by the user Third the worksheet uses the 3 phase equilibrium partitioning model see Appendix C and the soil vapor concentration to calculate the associated soil concentration the concentration that is protective of air quality at the exposure point point of compliance Ecology is currently evaluating appropriate procedures for evaluating the vapor pathway including the use of vapor attenuation factors and intends to provide further guidance on this issue 2 3 4 Entering Data for Input Parameters As discussed above the worksheet lists only those parameters that may be adjusted by the user For each of the parameters listed in the worksheet the user must either enter the default value provided in the regulation or a site specific or chemical specific value derived under the regulation NOTE If no data is available for an input parameter then leave the input box blank unless specified otherwise As illustrated in the following sections the parameters for which the user must enter data are listed on the left side of the worksheet The user must enter the data in the corresponding non shaded white boxes on the right side of the worksheet The worksheet is organized into seven parts Each of the parameters listed under those parts is listed and described below For each parameter this User s Guide lists the default value provided in the r
100. ll of the August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 52 air space in the porous medium is filled with petroleum product It means the risk is acceptable even at this high soil TPH concentration In this case Soil to Ground Water is not a critical pathway will appear in the Section 3 in the gray portion of lower summary table A2 Soil Cleanup Levels Also 100 NAPL will appear in the protective soil TPH concentration box in the Section 1 row at the top blue colored portion of the main table Then the user should check the residual saturation TPH levels specified in WAC 173 340 747 10 The Execute Calculation button should be clicked in order to run all the calculations needed to generate the results Once the calculations are updated the detailed calculation results for each exposure pathway are displayed Additional information e g why a particular assessment passed or failed can be obtained by clicking the Main button and navigating to the appropriate sheet A2 1B A2 1C A2 2 or A2 3 and will appear in sections 2 and 3 in the gray portion of lower summary table for the particular pathway e A2 1B Direct Contact Pathway Unrestricted Land Use Method B e A2 1C Direct Contact Pathway Industrial Land Use Method C e A2 2 Leaching Pathway Protection of Ground Water Quality e A2 3 Vapor Pathway Protection of Air Quality Each sheet provides additional o
101. mulas used for this revised Workbook Version 11 are exactly the same as those used in previous version Version 10 However several changes were made to the table of physical and chemical properties and the toxicological information for several petroleum fractions and individual hazardous substances These changes do affect the calculation results Some modifications were made to enhance the usability of program e Significant changes were made to the Table in Appendix F Properties of Chemicals commonly found at Petroleum Contaminated Sites to incorporate updated and new scientific information Click on the Data Base button to view Appendix F Revised information in Appendix F will be used by MTCATPH Workbook to evaluate and develop TPH cleanup levels for hazardous waste sites contaminated with petroleum Note that two additional chemicals have been added to the database of petroleum products gt The values for Naphthalene CAS 91 20 3 no longer represent a total value for Naphthalene 1 Methyl Naphthalene and 2 Methyl Naphthalene The values for now represent only the values for pure Naphthalene gt As a consequence of the change above two chemicals were added to the database 1 Methyl Naphthalene CAS 90 12 00 and 2 Methyl Naphthalene CAS 91 57 6 NOTE You do not need to specifically test for and determine the concentration of 1 Methyl Naphthalene in the media of concern This is because 1 Methyl Naphthalene can
102. n error window that states Compile error Can t find project or library as shown in Figure 1 5 If this is the case it is likely that the Visual Basic routines included in the Workbook cannot locate one or both of the following function files that need to be present on your computer s hard drive to allow the Workbook to perform correctly e LOOKUP XLA e SOLVER XLA This usually is caused by not having the Solver Add in open and loaded It is the user s responsibility to verify that these files are correctly loaded To see if you have these files use your file browser to search for them See Figure 1 6 Usually these files are located in the Library folder contained in the Office folder The file SOLVER XLA probably is contained in a folder called Solver within the library folder If you don t have these files you may need to install one or both of them from your original MS Office source disk In order to establish a path to these files for the Workbook you may need to do the following 1 In Visual Basic with the error window showing click on OK in the error dialogue window to close it 2 Click on Run in the main toolbar and select Reset 3 Click on Tools in the main toolbar and select References A list of available references with checkmarks will appear for the Workbook Follow these instructions for each checked reference that is labeled as MISSING you should repeat this procedure for eac
103. ncluding a value that has been manually adjusted in the soil worksheet so that the user can calculate the protective soil condition In addition IF the ground water cleanup level must be manually adjusted to account for total site risk as described above THEN the MTCATPH Workbook can still be used to calculate a soil cleanup level by manually adjusting the target risk for the TPH mixture and using the TPH Test or Alternative button in Sheet A2 2 See Section 3 7 3 3 2 Calculating Ground Water Cleanup Levels The potable ground water cleanup levels calculated using the ground water worksheet account for the following Concentrations established under applicable state and federal laws Concentrations based on protection of human health Natural background concentrations and Practical quantitation limits The potable ground water cleanup levels calculated using the ground water worksheet DO NOT account for the following Concentrations based on potential surface water impacts Nonaqueous phase liquid NAPL limitation or Total site risk where chemicals other than petroleum mixtures exist at a site e g chlorinated solvents The ground water cleanup levels calculated using the ground water worksheet may need to be manually adjusted to account for these considerations See Section 3 8 4 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 38 3 4 What s New on MTCATPH 11 Version 11 The calculation for
104. nup levels be established under Method C industrial land use To determine whether soil cleanup levels can be based on industrial land use Method C see WAC 173 340 745 1 e If the site qualifies for use of Method C to establish soil cleanup levels then enter a check in the box e Ifthe site does not qualify for use of Method C to establish soil cleanup levels then leave the checkbox blank 2 Can air cleanup levels be established under Method C To determine whether the air cleanup level can be based on industrial land use Method C see WAC 173 340 745 1 e If the site qualifies for use of Method C to establish air cleanup levels then enter a check in the box e Ifthe site does not qualify for use of Method C to establish air cleanup levels then leave the checkbox blank The first table then displays the results example shown in Table 2 2 A description of the content of the table is provided below August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 28 Table 2 2 Calculation Summary Table B SUMMARY OF SOIL CLEANUP LEVEL CALCULATIONS Chemical of Concern DDT 1 Summary of Results To calculate a soil cleanup level based on Industrial Land Use Method C for Direct Soil Contact check here m To calculate a soil concentration based on Method C vapor pathway check here Basis for Soil Concentration Units Most stringent soil concentration based on Soil Direct Contact amp Ground Water Protection 1
105. ogue sheet Navigator to guide the user through data entry calculation execution and calculation results summary worksheets Figure 3 1 below depicts a flow chart illustrating how the MTCATPH interface works Details of how each window functions are provided in the following several sections Once the Workbook is successfully loaded into Excel the title sheet will appear as shown in Figure 1 2 Installation Navigator is a floating menu that pops up over the worksheet when the user click Main from any worksheet selected To use the Workbook click on the START button to exit click on the END button When the START button is selected the Workbook loads a navigation box as shown below Figure 3 1 Overview of MTCATPH Interface Navigator Main MTCATPH Tool Navigator MTCATPH Tool Navigator Note Worksheets 4 and B are not linke Select Button For desired evaluation A Calculating Soil TPH Cleanup Levels Data Entry Calculation and Summary of Results Detailed calculation results optional aj Soil Direct Contact Pathway Method B ip Soil Direct Contact Pathway Method C F gt i ape Protection of Ground Water Quality Protection of Air Quality Method B informational purposes only ie i i 8 i i is is is i PE np B 5 R a a 5 a BPBeepwepnveeeeeeeeeeeeunaad B Calculating Ground Water TPH Cleanup Levels Data Entry Calculation
106. on 2 enter measured ground water concentrations Select Calculate Protective TPH GW Concentration button Select Most Stringent Criterion button e Select Print button to obtain a hard copy of the calculation inputs and outputs Select Main button to return to the MTCATPH Tool Navigator OR select End button to exit the MTCATPH Tool 3 8 2 Entering Data Input 3 8 2 1 Accessing the Ground Water Worksheet In the MTCATPH Workbook Navigator Box select Worksheet B Calculating Ground Water TPH Cleanup Levels 3 8 2 2 Input Data Part 1 Enter Logistical Site Information As shown in Figure 3 24 enter the logistical information on the site to be evaluated Enter descriptive text for the identification of a particular site or a sample or a project including date site name sample name and additional information if necessary Figure 3 24 Entering Site Information 1 Enter Site Information Date 10 30 2005 Site Name xyz site VPH and EPH data analysis ND zero out Sample info GW sample MW 8 sample type N 3 8 2 3 Input Data Pat 2 Enter Measured Ground Water Concentrations The ground water worksheet illustrated in Figure 3 25 requires the user to input analytical data ground water concentrations ug L in the non shaded white cells for August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 65 the chemicals of concern and EC groups approp
107. on 3 7 4 e For the Soil Worksheet the Workbook was revised to allow users to manually enter the target ground water cleanup level As described in Section 3 3 2 the potable ground water cleanup level calculated by the Workbook does not account for 1 concentrations based on potential surface water impacts 2 the nonaqueous phase liquid NAPL limitation or 3 total site risk where chemicals other than petroleum mixtures exist at a site This new feature of the Workbook allows the user to manually adjust the calculated value and enter the adjusted value into the Soil Worksheet The user may also use this feature to calculate the soil cleanup level that is protective of surface water by manually entering the ground water concentration that is protective of surface water See Section 3 7 3 e When the Workbook is loaded typical EXCEL toolbar functions are turned off and revised codes provide the maximum area on the monitor screen to view the overall data without moving the horizontal scroll bar If necessary the user can resize the Workbook page with the percent box to make the sheet and cells larger or smaller e A Clear Button was added to properly clear all previously entered site specific data e Footnotes were inserted for input parameters e The pop up windows were updated to provide the user more information on the use of button e The codes were also modified to improve multi tasking with other Windows programs while the calcula
108. orksheet DO NOT account for the following e Concentrations based on potential surface water impacts e Nonaqueous phase liquid NAPL limitation or August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 32 e Total site risk The ground water cleanup levels calculated using the ground water worksheet may need to be manually adjusted to account for these considerations 2 4 3 Equations and Parameters The worksheet uses the standard equations for calculating potable ground water cleanup levels provided in the regulation see Appendix A For each of the parameters used in the equations default assumptions values are set forth in the regulation to calculate standard Method B or C cleanup levels Under modified Methods B and C specified default assumptions may be adjusted based on site specific or chemical specific data The regulation specifically describes which parameters may be adjusted and how they may be adjusted e IF the regulation does not allow a parameter to be adjusted THEN the worksheet uses the default value for that parameter provided in the regulation Also the parameter is not listed in the worksheet and the user may not input data for that parameter e IF the regulation allows a parameter to be adjusted THEN the parameter is listed in the worksheet and the user may input either the default value provided in the regulation or a site specific or chemical specific value derived under the regulation 2
109. otective of ground water quality The four phase model may be used only on a case by case basis for soil containing fuels e g gasoline that have been enhanced with alcohol If the model is used for alcohol enhanced fuels then it needs to be demonstrated that the effects of co solvency have been adequately considered and where necessary taken into account when using the tools Use of the model for alcohol enhanced fuels without considering the effects of co solvency and increased ground water contamination is prohibited See WAC 173 340 747 6 b The four phase model is intended for use primarily on known fresh or weathered TPH mixtures Use of the tool for other mixtures of organic compounds a mixture of solvents and creosote compounds for example is not as well tested as for petroleum product applications and the results may not be as reliable Such applications need to be thoroughly scrutinized quality checked to make sure the results are within reasonable bounds 3 3 1 Calculating Soil Cleanup Levels The soil cleanup levels calculated using the soil worksheet account for the following e Concentrations based on protection of soil direct contact pathway human health two options gt Method B gt Method C e Concentrations based on protection of ground water quality leaching pathway use either or both features when necessary and applicable gt Based on calculated Method B potable ground water cleanup level which is b
110. ph Users can manually resize the graph or rescale e g from or to normal to log scale the axis to make it look more meaningful by double clicking on the graph and resizing and rescaling it Refer to the MS Excel user s manual Preview printout reporting features and readability of worksheet The Workbooks provide printing and reviewing capabilities for all input output screens To view the printable worksheet click on the Preview button at the top of any worksheet Each worksheet can be printed by selecting the appropriate Print button The same print options are available on the Main Menu Some users may have difficulty viewing worksheet numbers or text To enlarge your view of a particular sheet click on View in the main toolbar and select Zoom Choose a magnification that works best for your needs and save it as modified August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 12 Input output worksheet prints on one page for most computer printer configurations The worksheet is designed at 1024 x 768 pixel screen resolution making it more readable on new computer configurations For older systems with lower resolution simply changing the screen zoom level to a higher percent or more instead of lower percent will improve readability Security and protection of worksheet The worksheets have been provided unlocked and unprotected It therefore is critical that Ecology
111. provided to document the methods used by the Department to develop concentrations that meet the acceptable risk levels required by The Model Toxics Control Act MTCA Cleanup Regulation chapter 173 340 WAC Note This User s Guide document replaces the Department s August 2001 document entitled Workbook Tools for Calculating Soil and Ground Water Cleanup Levels under the Model Toxics Control Act Cleanup Regulation User s Guide Publication No 01 09 073 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 1 2 Caution on Use of the Workbooks The requirements and procedures for establishing cleanup levels that are protective of human health and the environment are specified in the MTCA Cleanup Regulation chapter 173 340 WAC The use of this User s Guide and the associated programs may not be sufficient to establish cleanup levels under the regulation The Workbooks are merely computational tools and do not provide all the information necessary to establish cleanup levels for a site Appropriate background training and experience are necessary to accurately use the Workbooks 1 2 1 Calculation of Soil Cleanup Levels The soil cleanup levels calculated using the Workbooks account for the following Concentrations based on protection of human health direct contact pathway Concentrations based on protection of ground water leaching pathway Natural background concentrations or Practical quantitation limits
112. riate for the type of TPH mixture being evaluated Figure 3 25 Entering Ground Water Concentration Measured 2 Enter Ground Water Concentration Measured Gw Chemical of Concern a Cleanup GW Conc or EC Group Level ug L ug L Petroleum EC Fraction AL_EC gt 5 6 o AL EC gt 6 8 fo AL_EC gt 8 10 a a AL_EC 10 12 a AL_EC gt 12 16 a AL EC gt 16 21 AL EC gt 21 34 cote 1 lel AR EC gt 8 10 AR_EC gt 10 12 a AR_EC gt 12 16 P AR_EC gt 16 21 AR EC gt 21 34 Benzene 5 Toluene 1000 Ethylbenzene 700 Total Xylenes 200 1000 Naphthalene 1 Methyl Naphthalene 2 Methyl Naphthalene n Hexane MTBE i v Ethylene Dibromide EDB lt 1 2 Dichloroethane EDC tt Benzo a anthracene os for Benzo b fluoranthene all Benzo k fluoranthene os cPAHs Benzo a pyrene Chrysene 1E 05 Dibenz a h anthracene lo Indeno 1 2 3 cd pyrene n o O Sum 293 25 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 66 Be sure that the correct and consistent units are used for all chemical concentrations micrograms liter ug L ppb and that you use the same number of significant figures as reported by the laboratory Enter zero 0 for substances that are not analyzed 1 e for gasoline you probably would not test for the cPAHs so these entries would all be zero For values below the method detection limit substitute one half the method detection limit For values above the method detection limit but
113. rsion 11 0 68 Figure 3 28 Floating Buttons for Calculating Protective Ground Water TPH Calculate Protective TPH GW Select the particular ground water quality criterion for which you want to calculate a protective TPH ground water conc Clear calculation results Most stringent criterion HI 1 Total Risk 1E 5 Risk 1E 6 Benzene MCL 5 ug L MTBE 20 ug L Risk of all CPAHS 1E 5 Naphthalene 160 ug L These buttons back calculate a TPH concentration using the relative fraction compound percentages based on the entered data that meets various criteria shown below The result is immediately shown in the box below the buttons Total Ground Water TPH Cleanup Level HI 1 Total Ground Water TPH Cleanup Level RISK 1 x10 Total Ground Water TPH Cleanup Level based on benzene ground water cleanup level Total Ground Water TPH Cleanup Level based on MTBE ground water cleanup level Total Ground Water TPH Cleanup Level based on cPAHs Risk 1 x10 ground water cleanup level For all adjusted conditions the details are provided in the four columns to the left under the heading Adjusted Condition The column shows the ground water concentration corresponding to the total adjusted concentration and the corresponding hazard index or carcinogenic risk The pass fail criteria are the same as those for the current condition August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0
114. s Unit Conversion Factor 1 000 1 000 ug mg Oral Carcinogenic Potency Factor Chemical specific Chemical specific kg day mg Drinking Water Ingestion Rate 2 0 2 0 L day Inhalation Correction Factor See Note 1 See Note 1 unitless Drinking Water Fraction 1 0 1 0 unitless Exposure Duration Footnotes 30 30 1 Use value of 2 for volatile organic compounds and 1 for all other substances A 1 years Equation 720 3 Potable Ground Water Cleanup Levels Petroleum Mixtures Non Carcinogenic Risk c ar w ee poe ABW xUCF amo RID p F Definiti Default Value Unit ram r n n n Tee Soret Method B Method C a TPH ground water cleanup level ug L Hazard Index 1 0 1 0 unitless Averaging Time 6 6 years Drinking Water Ingestion Rate 1 0 2 0 L day Drinking Water Fraction 1 0 1 0 unitless Exposure Duration 6 6 years Average Body Weight over the 16 70 i exposure duration Unit Conversion Factor 1 000 1 000 ug mg Fraction by weight of petroleum component i Inhalation Correction Factor for petroleum component i Oral Reference Dose of Petroleum component i The number of petroleum components petroleum fractions plus volatile organic compounds with an RfD present in the petroleum mixture See Table 830 1 Chemical specific Chemical specific unitless See Note 1 See Note 1 unitless
115. s 66 3 8 4 Output Adjusting the Results 3 c 2csacgt cette seas eae s da agee ees 69 Appendices Appendix A Equations and Default Values for Calculating Potable Ground Water Cleanup Levels Appendix B Equations and Default Values for Calculating Soil Cleanup Levels based on the Direct Contact Pathway Appendix C Equations and Default Values for Calculating Soil Cleanup Levels based on the Leaching Pathway Protection of Ground Water Appendix D Equations and Default Values for Calculating Air Cleanup Levels Appendix E Primer on TPH Fractions and Analytical Requirements for TPH Mixtures Appendix F Revised Properties of Chemicals commonly found at Petroleum Contaminated Sites iii List of Figures Figure 1 1 Opening Title Screen of MTCASGL eeeeseeseeseseseeresseesrrsrreseesreseresresseseresresee 6 Figure 1 2 Opening Title Screen of MTCATPH 0 eeceeeeeeneecneeceseeeseeesseeeaeenseensees 7 Figure 1 3 De linking Error Message essseseseeseeseseresressersrersresesersstesseserssresseseeesreesesee 7 Figure TA Addin Feature Son nane a A it alas E 8 Figure 1 5 Compile Error Messasessssicccassscsecnsensacavssdiecsaneseasa sevatacsoenaeeassaedeve tedeseasnsaceests 8 Figure 1 6 Locating Solver Built In Function esseeeseseeseeseesseseesressrseresresseseresresseseresres 10 Figure 2 1 Examples Of POomores xc 4 2ecd pie Be aie a a ee cl 14 Figure 2 2 General Information o sscien co ceh2l cenit ea ah iocahdi een im i
116. s Distribution Pattern for each Component 4 phase See Figure 3 22 gt Component Mass Distribution Soil amp Well gt Total TPH Mass Distribution in 4 phase Well Figure 3 21 Mass Balance Navigator Mass Balance Navigator This tool right below allows the user to evaluate the pattern of mass balance with the soil TPH concentration given tested calculated under the same composition ratio as for the measured data and the same hydro geological data previously entered by the user Figure 3 22 Mass Distribution of Individual Component in Soil Matrix Mass Distribution of Individual Components in 4 phase E Pore Water HW Pore Air O Dry Solid adsorbed O NAPL 100 80 H E E E a a a r a a r r che ye pc ccd 78 0 E ir g S S 60 N 0 B E E E eae a ie o oo w in in oe a S Q 2 40 HE ry rad door ry ririt ee rnn i i in z MW M Se ee io i ion oe 0 2 men r E mo an z r z z r E eo n z r Bi KKUUUEULUbBRbRGN GY D d ko e he YG D Ba G Bo o Ae Dy te Oo My O Ox SS a A O ES a AAA Ue she x K K KAA ot o ep 8 a 2 85 Ca n 2 8 D Aa N g Co d Sa 8 O 0 ar Mg 82 88 O Ora My O Fy os y hy KA o a ng ay o KA A o fo
117. s from the Ground Water Cleanup Ground Water Level Worksheet are not automatically transferred into this worksheet The Workbook provides two methods for calculating the target ground water cleanup level These two methods are described below Use and Adjustment of Method A Values in Table 720 1 For chemicals listed in Table 720 1 except petroleum mixtures the value listed in Table 720 1 for a chemical may be used as the target ground water cleanup level provided the value is manually adjusted based on the following e Consideration of potential surface water impacts see WAC 173 340 720 4 b ii and 173 340 720 5 b 11 e Consideration of the nonaqueous phase liquid NAPL limitation see WAC 173 340 720 7 d and e Consideration of total site risk see WAC 173 340 720 7 a To see the values listed in Table 720 1 click the Method A CUL for Ground Water button to activate a pop up list The value from Table 720 1 must be manually adjusted as described above and then manually entered in the soil worksheet Calculation of Method B or Method C Value For chemicals not listed in Table 720 1 the user must calculate a potable ground water cleanup level using the ground water worksheet To access the worksheet click on the Cale Ground Water CULI button See Section 2 4 for instructions on calculating a potable ground water cleanup level Before calculating the potable ground water cleanup
118. see Section 2 3 4 3 e Adherence Factor AF e Dermal absorption fraction ABSa and e Gastrointestinal Absorption Conversion Factor GJ 2 3 4 2 Input Data Part 2 Toxicological Properties of the Chemical The second part of the worksheet illustrated in Figure 2 3 requires the user to input the following chemical specific toxicological data August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 19 Figure 2 3 Toxicological Properties 1 Toxicological Properties of the Chemical Chemical Specific Oral Reference Dose 0 0005 jg day Oral Carcmogeme Potency Factor 0 34 ko dayng Inhalation Reference Dose mgkg day Inhalation Caremogeme Potency Factor 034 kedang Oral Reference Dose RfD Enter the oral reference dose mg kg day for chemicals having non carcinogenic toxicity The applicable oral reference dose for a chemical is published in CLARC Note that an oral reference dose may not be available for some chemicals The process for establishing a reference dose is defined in WAC 173 340 708 7 Oral Carcinogenic Potency Factor CPF Enter the oral carcinogenic potency factor kg day mg for chemicals having carcinogenic toxicity The applicable oral cancer potency factor for a chemical is published in CLARC Note that an oral cancer potency factor may not be available for some chemicals The process for establishing a cancer potency factor is defined in WAC 173 340 708 8 Inhalation Re
119. sequently to establish a soil cleanup level under the regulation the cleanup level calculated using the worksheet may need to be manually adjusted to account for the following e Concentrations established under applicable state and federal laws WAC 173 340 740 3 b or 173 340 745 5 b 4 e Terrestrial ecological impacts see WAC 173 340 740 3 b Gi or 173 340 745 5 b ii e Impacts on air quality vapor pathway see WAC 173 340 740 3 b 11 C c iv or 173 340 745 5 b iii C 9 Gv e Residual saturation see WAC 173 340 747 2 b and 10 and e Total site risk see WAC 173 340 740 5 a or 173 340 745 6 a 2 4 Calculating Potable Ground Water Cleanup Levels Ground Water Worksheet This worksheet calculates a Method B or Method C potable ground water cleanup level 2 4 1 Accessing the Ground Water Worksheet The ground water worksheet is accessed by selecting the Cale Ground Water CUL button in Part 5 of the soil worksheet described in Section 2 3 4 5 above 2 4 2 Caution on Use of the Ground Water Worksheet The potable ground water cleanup levels calculated using the ground water worksheet account for the following e Concentrations established under applicable state and federal laws e Concentrations based on protection of human health Natural background concentrations and e Practical quantitation limits The potable ground water cleanup levels calculated using the ground water w
120. ser to calculate a protective TPH soil concentration based on the adjusted site specific target TPH ground water concentration that was previously entered by the user Instead of entering the adjusted potable ground water cleanup level the user may also have entered a non potable ground water cleanup level or the ground water concentration that is protective of surface water quality See Section 3 7 2 5 The Worksheet uses the same composition ratio as for the measured data and the same hydrogeological data previously entered by the user Detailed Model Results Figure 3 17 contains detailed model simulation results such as Type of model used for computation Initial Weighted Average Molecular Weight of NAPL Equilibrated Weighted Average MW of NAPL Initial Weighted Average Density of NAPL Volumetric NAPL Content NAPL Saturation by volume TPH concentration when air space is filled with petroleum product at 100 and Mass Distribution Pattern 4 phase in soil pore system in water air solid NAPL phases August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 60 Figure 3 17 Model Results DEDAILED MODEL RESULTS Type of model used for computation 4 Phase Model Computation completed Yes eee napa a ror ae E E Fe Sa A emacs Equiibrated Weighted Average MW of NAPL g mol 201 5 Initial Weighted Average Density of NAPL kg L 0 836 Volumetric NAPL Content Oxyp 1 1E 04 NAPL Saturation
121. shown in Figure 3 16 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 58 Figure 3 15 Protective Condition or Testing Box CALCULATE PROTECTIVE CONDITION OR TEST ADJUSTED CONDITION Tested TPH Soil Conc mg kg Figure 3 16 Floating TPH Test button used Predicted TPH GW Cone ug L 1 23E 02 RISK Well 2 67E 07 HI Well 2 11E 01 Buttons for Soil to Ground Water Exposure Pathwa Calculate or Test CALCULATE PROTECTIVE CONDITION OR TEST ADJUSTED CONDITION Calculate Protective Condition for Method B Potable Ground Water Quality Human Health This tool allows the user to calculate a protective TPH soil concentration based on various potable ground water quality criteria The Workbook uses the same composition ratio as for the measured data and the same hydrogeological data previously entered by the user Test Adjusted Condition This tool allows the user to test whether a particular TPH soil concentration is protective of ground water quality The Workbook uses the same composition ratio as for the measured data and the same hydrogeological data previously entered by the user LF c i Solver Function click the button i right below TPH Test i Select the particular potable ground water quality criterion for which you want to calculate a protective TPH soil concentration HI 1 Total Risk 1E 5 Risk 1E 6 Benzene MCL 5ug L MTBE 20ug L
122. site managers are confident that the formulas used for calculations are accurate Restoring EXCEL tools bars and miscellaneous options In order to maximize screen area on the computer to view the data most of the typical EXCEL toolbars are turned off when these Workbooks are loaded However if you prefer to have these toolbars available you can restore them from EXCEL s menu Select View Formula Bar View Toolbars Standard and View Toolbars Formatting to return the typical toolbars You can then resize the pages the percent box to make the tables and text larger or smaller You can also use Tools Options View Row amp Column Headers to restore the standard row and column labels 1 6 Saving and Closing the Workbook gt USE THE END BUTTON lt Once an analysis is complete it is good practice to print out a copy of the entire Workbook as a record At this point you may also wish to save the Workbook under a new name FILE SAVE AS If you accidentally exit without using the END button you can re establish your toolbars by clicking on VIEW TOOLBARS and selecting the toolbars you wish to use You may also need to click on TOOLS OPTIONS and make selections as appropriate to re establish certain work area components When you click on the END button you will be prompted to save your work and you can do so by answering yes and saving the file under a new file n
123. t will not cause an exceedance of the ground water cleanup level The parameter is chemical specific e For organic hazardous substances enter the Koc value The Workbook calculates a value for Kq using the Koc value entered here and the foc value entered in the sixth part of the worksheet using Equation 747 2 Ka Koc X foc Default Koc values are provided in Table 747 1 for selected nonionizing organics and Table 747 2 for selected ionizing organics Kg values for other organic hazardous substances may be established as provided in WAC 173 340 747 5 b e For metals enter the distribution coefficient Kg instead of the Koc value here and enter 1 0 for the foe value in the sixth part of the worksheet Default values are provided in Table 747 3 for the selected metals Kg values for other metals may be established as provided in WAC 173 340 747 5 b August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 22 The applicable default value for a chemical is published in CLARC however default values are not provided for all chemicals As of this writing Ecology is planning to publish in CLARC a more comprehensive database of Koc or Ka or Kow octanol water partition coefficient values for organic and inorganic chemicals Henry s Law Constant He or H This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The param
124. tering see 3 Equation 747 5 calculated m yr Ground water flowrate see Equation 747 4 calculated m yr Equation 747 4 Calculating Ground Water Flowrate Q Q KxAxl Parameter Definition Default Value Ground water flowrate calculated Site specific measurement Cross sectional Area of Aquifer Site specific mixing zone 1 measurement Site specific measurement Hydraulic conductivity Hydraulic Gradient unitless m m Footnotes 1 The aquifer mixing zone thickness shall not exceed 5 meters in depth and be equal to a unit width of 1 meter unless it can be demonstrated empirically that the mixing zone thickness exceeds 5 meters Equation 747 5 Calculating the Flowrate of Water Infiltrating Q Q LxW x Inf Parameter Definition Default Value Flowrate of water infiltering calculated Estimated length of contaminant source Site specific area parallel to ground water flow measurement Unit width of contaminant source area 1 0 Site specific measurement 1 Infiltration rate Footnotes 1 A default value may be used For sites west or east of the Cascade Mountains the default annual infiltration value shall be 70 percent or 25 percent respectively of the average annual precipitation amount C 2 FOUR PHASE PARTITIONING Equation 747 6 Conservation of Volume Equation n 0 0 Ovarpi Total soil porosity ml total pore space ml
125. that the default value of 20 might not be sufficiently protective of the ground water for a site where the source size is significantly larger than a half acre as specified by the EPA 2 3 4 7 Input Data Part 7 Vapor Attenuation Factor for the Site The seventh part of the worksheet illustrated in Figure 2 8 requires the user to input the vapor attenuation factor for the site Figure 2 8 Vapor Attenuation Factor 7 Vapor Attenuation Factor due to Advection building structure amp Diffusion soil layer Mechanisms Vapor Attenuation Factor is the ratio of air concentration at the exposure point e g within the building to the vapor phase contaminant concentration within the soil at the source Enter Vapor Attenuation Factor for the evaluation of vapor exposure pathway VAF xxx funitless Vapor Attenuation Factor VAF This parameter is used to calculate a soil concentration that is protective of air quality that will not cause an exceedance of the air cleanup level at the point of compliance This parameter is site and chemical specific The worksheet uses the 3 phase equilibrium partitioning model to predict the soil vapor concentration at the source based on the measured soil concentration The worksheet then uses the vapor attenuation factor to predict the air concentration at the point of compliance based on the soil vapor concentration at the source The vapor attenuation factor is based on several factors incl
126. tion at Well ug L The predicted ground water concentration based on the partitioning equations presented in Appendix C e Hazard Quotient HQ at Well The hazard quotient for each fraction or hazardous substance that contributes to the total hazard index for exposure to potable ground water sum at bottom of column e Risk at Well The carcinogenic risk for each fraction or hazardous substance that contributes to the total cancer risk is summed at the bottom of the column e Pass or Fail If any predicted individual chemical concentration at the well exceeds the applicable Method A ground water cleanup level a FAIL is indicated in the column Also at the bottom of the column a FAIL is indicated if the hazard index exceeds 1 or the total cancer risk exceeds 1 x 10 or when a predicted concentration at a well becomes higher than the ground water cleanup levels specified Also the site specific hydrogeological properties and ground water concentration protective of surface water quality if any previously entered are shown at the right upper corner of worksheet A2 2 Calculating Protective Condition for Ground Water Quality The Adjusted Condition is displayed at the request of the user by clicking the Calculate or Test button See Figure 3 15 The user may calculate the protective soil concentration by selecting one of the following back calculation buttons on the floating menu that pops up over the worksheet as
127. tions are being made e The codes were also revised to reduce memory requirements and simulation time and to increase calculation efficiency e The interface Navigator was modified to improve the usability of the program 3 5 Overview of Equations and Parameters 3 5 1 Calculating Soil Cleanup Levels The soil worksheet provides tools for evaluating the direct contact pathway the leaching pathway protection of ground water and the vapor pathway protection of air quality informational purpose only 3 5 1 1 Direct Contact Pathway For evaluation of the direct contact pathway the worksheet uses the standard equations provided in the regulation see Appendix B and Table 3 1 and Table 3 2 and summarized below For petroleum mixtures evaluation of the direct contact pathway involves a concurrent evaluation of both soil ingestion and dermal contact August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 40 Table 3 1 Method B Equations TPH Mixture e Non carcinogenic risk Equation 740 3 TPH Components e Non carcinogenic risk Equation 740 4 e Carcinogenic risk Equation 740 5 Table 3 2 Method C Equations TPH Mixture e Non carcinogenic risk Equation 745 3 TPH Components e Non carcinogenic risk Equation 745 4 e Carcinogenic risk Equation 745 5 For each of the parameters used in the equations default assumptions values are set forth in the regulation to calculate stand
128. trointestinal Absorption Conversion Factor chemucal specific or defaults for dermal exposure pathway August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 20 Inhalation Correction Factor INH This parameter is used to calculate the ground water cleanup level Enter the applicable default value 2 0 for volatile organic compounds as defined in WAC 173 340 200 and 1 0 for all other chemicals or enter a chemical specific value established under WAC 173 340 720 4 c i The applicable default value for a chemical is published in CLARC Inhalation Absorption Fraction ABS This parameter is used to calculate the air cleanup level Enter the default value of 1 0 or enter a chemical specific value established under WAC 173 340 750 3 c i Gastrointestinal absorption fraction AB This parameter is used to calculate a soil concentration that is protective of human health based on direct contact Enter the default value of 1 0 or enter a chemical specific value established under WAC 173 340 740 3 c Gi B or 173 340 745 5 c i B Adherence Factor AF This parameter is used to calculate a soil concentration that is protective of human health based on direct contact The parameter is specifically used to evaluate dermal contact Enter the default value of 0 2 or enter a chemical specific value established under WAC 173 340 740 3 c ii C or 173 340 745 5 c Gi C If an evaluation of the dermal pathway is not
129. uding the emission rate of the contaminant from soil due to diffusion and advection and the amount of dilution that occurs through mixing with indoor and or outdoor ambient air WARNING To calculate a soil cleanup level based on the vapor pathway the user must enter a value for VAF The user must enter a site specific value because a default value has not been established U S EPA 1996 Soil Screening Guidance Technical Background Document EPA 540 R 95 128 August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 27 If it appears that the vapor pathway is a controlling factor at a site the user needs to consult with the Ecology site manager to identify an appropriate method for evaluating the vapor pathway 2 3 5 Output Interpreting the Result The worksheet automatically calculates protective soil concentrations for the different pathways and then calculates a soil cleanup level based on those protective concentrations and other limits The worksheet displays the calculation results in two tables at the bottom of the active sheet or in the lower window if the screen is split 2 3 5 1 Summary of Results The first table example shown below displays the most stringent soil concentration based on soil direct contact and ground water protection as well as other limits The first table requires the user to make two decisions that will affect the results displayed in the table 1 Can soil clea
130. umetric air content is 0 13 Dry Soil Bulk Density 2 This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an exceedance of the ground water cleanup level The parameter is site specific Enter the default value of 1 50 or enter a site specific value derived under WAC 173 340 747 5 c using site specific measurements Fraction Soil Organic Carbon f The fraction of soil organic carbon is the total mass of organic carbon divided by a unit mass of soil mass of carbon mass of soil This parameter is used to calculate a soil concentration that is protective of ground water that August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 49 will not cause an exceedance of the ground water cleanup level The parameter is site specific Enter the default value of 0 001 or enter a site specific value derived under WAC 173 340 747 5 b i The Workbook calculates a value for Kg using the foc value entered here and the Koc value in the database using Equation 747 2 Ka Koc X foc Soil samples that are analyzed for foc must be collected outside the area of contamination and below the root zone The results are usually reported as percent organic carbon The reported value can be converted to a fraction by dividing by 100 Dilution Factor DF This parameter is used to calculate a soil concentration that is protective of ground water that will not cause an ex
131. us substances and the non carcinogenic risk from both TPH fractions and individual hazardous substances are acceptable Table 3 5 Summary of Calculation Results for Soil TPH 1 Summary of Calculation Results Exposure Path Method Goal Protective Soil With Measured Soil Conc Does Measured Soil rues te piii TPH Conc mgkg RISK Conc Pass or Fail Protection of Soil Direct MethodB 168 500E06 251E Contact Human Health 6 718 1 24E 06 1 90E 02 Protection of Method B Ground P a e GW Human Health Protectio 4 2146 06 1 14E 00 Water Quality Leaching Target TPH GW Conc 355 ug L E oe Warning Check to determine if a simplified or site specific Terrestrial Ecological Evaluation may be required Refer to WAC 173 340 7490 through 7494 Depending on the speed of your computer and site specific data entered previously the calculation may take from several seconds to several minutes to complete Do not disturb or stop the calculation It may cause the erroneous calculation results Click Print or Preview button for a hardcopy or a screen view of inputs and outputs Soil Cleanup Levels Calculation Result Summary If the Warning dialogue box appears then follow the instructions shown for how to calculate a protective soil TPH cleanup levels Occasionally for the evaluation of soil to ground water exposure pathway TPH soil cleanup level exceeds the theoretical maximum TPH that would be reached if a
132. using the direct contact equations in the regulation ingestion only AND ingestion dermal For the leaching pathway the worksheet first calculates the predicted ground water concentration based on current site conditions using 3 phase model and then calculates the HQ and RISK under Method B and Method C based on the predicted ground water concentration Noncarcinogenic Risk under the Current Condition This is the hazard quotient HQ based on the measured soil concentration and the predicted ground water concentration The worksheet calculates the HQ using the equation in the regulation and solving for HQ Carcinogenic Risk under the Current Condition This is the carcinogenic risk based on the measured soil concentration and the predicted ground water concentration The worksheet calculates the RISK using the equation in the regulation and solving for carcinogenic RISK For the leaching pathway the worksheet next calculates the soil concentration that is protective of ground water under either Method B or Method C using the 3 phase model August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 31 The protective soil concentration is based on the target ground water cleanup level calculated using the ground water worksheet or defined by the user 2 3 6 Output Adjustment of Result As noted previously see Section 2 3 the soil cleanup levels calculated using the soil worksheet DO NOT account for several factors Con
133. vel is lower more stringent than either the natural background concentration or the PQL then the worksheet adjusts the cleanup level upward to the natural background concentration or the PQL whichever is higher less stringent 2 4 6 Output Adjustment of Result As noted previously see Section 2 4 2 the potable ground water cleanup levels calculated using the ground water worksheet DO NOT account for several factors Consequently to establish a potable ground water cleanup level under the regulation the cleanup level calculated using the worksheet may need to be manually adjusted to account for the following e Concentrations based on potential surface water impacts see WAC 173 340 720 4 b Gi and 5 b i e Nonaqueous phase liquid NAPL limitation see WAC 173 340 720 7 d and e Total site risk see WAC 173 340 720 7 a 2 4 7 Output Transfer of Adjusted Result to Soil Worksheet To calculate a corresponding soil cleanup level using the soil worksheet the potable ground water cleanup level calculated using the ground water worksheet must be manually adjusted as described above and then manually entered in the soil worksheet The Workbook DOES NOT automatically enter the result from the ground water worksheet August 2006 User s Guide for MTCATPH amp MTCASGL Version 11 0 35 Chapter 3 MTCATPH Workbook for Calculating Cleanup Levels for a Petroleum Mixture 3 1 Overview The MTCATPH Workbook allo
134. version format This manual provides instructions on the use of the following two Microsoft Excel Workbook files described below in Table 1 1 This zip archive file may be obtained by e Contacting Ecology 360 407 7224 cesg461 ecy wa gov to obtain a compact disk CD containing the files or e Downloading the files from Ecology s Internet web site http www ecy wa gov programs tcp tools toolmain html Table 1 1 Description of Workbooks File Size File Name MB Version Description MTCASGLI1 xls 0 2 11 0 Workbook for Calculating Cleanup Levels for Individual Hazardous Substances Workbook for Calculating Cleanup Levels MTCATPH11 xls 1 8 11 0 ge Petroleum TPH Mixtures 1 3 2 Hardware and Software Requirements to run the Workbooks This section describes the required or recommended hardware and software for using the Workbooks Any hardware capable of operating MS Excel version 2003 SP2 will run the Workbooks A math coprocessor is not required but is recommended Modern processors may have the coprocessor included Please note you can check your hardware configuration if you are using MS Windows by right clicking on my computer on the windows desktop and selecting system information Some Workbook routines require intensive numeric processing best handled by hardware with greater amounts of Random Access Memory RAM and Pentium level processors Additional hardware recommendations
135. wever for a hazardous substance or petroleum fraction which has never been detected in any sample at a site and these substances are not suspected of being present at the site based on site history and other knowledge enter 0 for that hazardous substances or petroleum fraction for further calculation For additional information please refer to WAC 173 340 740 7 f for soil samples and WAC 173 340 720 9 f for ground water samples 4 For detail analytical testing requirements for petroleum contaminated sites refer to WAC 173 340 820 830 and 840 and Table 830 1 5 For detail information on site specific hydrogeological conditions for leaching pathway please refer to WAC 173 340 747 THIS COMPLETES DATA ENTRY FOR THE SOIL WORKSHEET SAVE YOUR WORK BEFORE CONTINUING You should save the file under a new file name that pertains to the particular site and sample 3 7 3 Executing the Calculation and Analyzing the Output Calculation Summary Table Click on MAIN in the upper right corner to return to the navigation tool Open the MTCATPH Tool Navigator and click the button of A2 Calculation and Summary of Results Worksheet Then enter y if new soil data entered or existing data edited enter 6699 n otherwise in response to the question shown in Figure 3 8 Figure 3 8 Calculating with New Data Entered Microsoft Excel Did you enter new soil data or edit previously entered soil data If yes enter y
136. ws the user to use pre established chemical and toxicity data risk based and site specific exposure assumptions and user defined and site specific information to calculate either of the following for a petroleum mixture e Risk under Current Conditions The Workbook provides the tools necessary to calculate the risk carcinogenic and non carcinogenic under current conditions site specific analytical measurement To calculate the risk under current conditions the Workbook requires the user to enter a measured soil or ground water concentration The Workbook then executes a forward calculation using the equations in the regulation and solving for risk For soil measurements the Workbook calculates the risk corresponding to the direct contact pathway the leaching pathway protection of ground water and the vapor pathway protection of air quality e Site specific and Risk based Cleanup Levels for Soil and Ground Water for Potable or Protection of Surface Water The Workbook provides the tools necessary to calculate protective soil concentrations under Method B and Method C The Workbook back calculates a protective concentration based on the target risk levels carcinogenic and non carcinogenic set forth in the regulation For soil the Workbook calculates a protective concentration for the direct contact pathway the leaching pathway protection of ground water and the vapor pathway protection of air quality The MTCATPH Workbook
137. ydrocarbons see the scientific literature for other hazardous substances For petroleum mixtures this means the petroleum fractions plus organic hazardous substances with a reference dose for other Component hazardous substances this means each organic hazardous substance that is found in the NAPL C 5 Appendix D Equations and Default Values for Calculating Air Cleanup Levels Equation 750 1 Air Cleanup Levels Noncarcinogens R D x ABW xUCF x HQ x AT BR x ABS x ED x EF DefatVaue Value Parameter Definition Method B Method EEE Units Equation 750 1 Equation 750 1 Inhalation Reference Dose Chemical specific Chemical specific mg kg day Air Cleanup Level ug m Average Body Weight over the exposure duration 16 70 kg Unit Conversion Factor 1 0E 3 1 0E 3 ug mg Breathing Rate m day Inhalation Absorption fraction unitless Hazard Quotient x unitless Averaging Time years Exposure Duration years Exposure Frequency unitless Equation 750 2 Air Cleanup Levels Carcinogens RISK x ABW x AT x UCF CPF x BR x ABS x ED x EF s dDefault Value Value Parameter Definition Method B Method TE Equation 750 2 Equation 750 2 Acceptable cancer risk level mg kg day Air Cleanup Level ug m Average Body Weight over the 70 70 kg exposure duration Averaging Time 75 75 years Unit Conversion

MTCA Workbook User`s Guide for Ver 11.0 - CLU-IN

Contents

Download Pdf Manuals

Related Search

Related Contents