{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Welcome","Info","LD","SL","GW","SW","SD","IA","AF","Part1","Part2","ChemTox","Codes","Rating","Lists","SvCalc"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":373,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,2,5,4]]}
[]
[]
[null,null,"Welcome to the SHARP Tool"]
[null,null,"Version: ",null,"v2024.02.20"]
[]
[null,null,"The SHARP Tool is the Department of Ecology's site assessment procedure required by RCW 70A.305.030(2)(b) and regulated by chapter 173-340 WAC. The SHARP Tool supports meaningful decision making for sites that pose an exposure risk to people and other living things and plays a key role in how Ecology focuses on improving environmental equity under the HEAL Act of 2021.\n\nRatings rely on scores from assessing risks of potential chemical exposure and severity in soil, groundwater, surface water, sediment, and indoor air. These assessments inform an overall SHARP rating of low, medium, high, or critical. Exposure and severity risks can be re-assessed over time as site cleanups progress and as new information becomes available. The current Microsoft Excel format supports a planned conversion into an online application and is intended for internal Ecology use only."]
[]
[null,null,"SHARP Tool Structure"]
[]
[null,null,"Tabs",null,"Page and purpose"]
[]
[null,null,"The assessor enters information on only these two pages."]
[null,null,"Info",null,"Site Info page: collects readily available, site-specific information"]
[null,null,"LD",null,"Local Demographics page: collects state-only local demographics data from federal and state sources"]
[]
[null,null,"Answer questions on these five sheets to generate assessment scores for five environmental media."]
[null,null,"SL ",null,"Soil assessment page"]
[null,null,"GW",null,"Groundwater assessment page"]
[null,null,"SW",null,"Surface Water assessment page"]
[null,null,"SD",null,"Sediment assessment page"]
[null,null,"IA",null,"Indoor Air assessment page"]
[null,null,"AF",null,"Additional Factors — collects useful, non-scoring site information"]
[]
[null,null,"Together, the following two sheets comprise a SHARP Report."]
[null,null,"Pt1",null,"SHARP Report Part 1: text assessment summary"]
[null,null,"Pt2",null,"SHARP Report Part 2: site conceptual model"]
[]
[null,null,"ChemTox is a list of chemicals and relevant information from the CLARC database."]
[null,null,"ChemTox",null,"Chemical Toxicity Reference Table"]
[]
[null,null,"SHARP Tool Support"]
[]
[null,null,"SHARP\nManual",null,"The companion SHARP Manual helps users answer questions in the SHARP Tool, navigate online information sources to collect information."]

{"sheet":"Info","index":1,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,2,96,10],[55,2,59,10],[43,4,43,10],[44,4,44,10],[45,4,45,10],[46,4,46,10],[47,4,47,10],[48,4,48,10],[49,4,49,10],[50,4,50,10],[20,6,20,7],[6,6,6,10],[7,6,7,10],[8,6,8,7],[15,6,15,7],[9,6,9,7],[10,6,10,7],[11,6,11,10],[21,6,21,7],[38,7,38,9],[16,6,16,7],[32,7,32,8],[33,7,33,8],[34,7,34,8],[18,6,18,7],[36,7,36,8],[37,7,37,8],[17,6,17,7],[19,6,19,7],[35,7,35,8],[26,6,26,7],[27,8,27,9],[29,8,29,9],[25,6,25,8]]}
[]
[]
[null,null," Site Info",null,null,null,null,null,null,null,"Respond to all fields"]
[]
[null,null,1,"▼ Enter basic site info (add overflow to narrative)"]
[]
[null,null,null,null,"Site name",null,"CHS Sun Basin Petroleum Facility Diesel Release"]
[null,null,null,null,"Street address",null,"2 Division Street West"]
[null,null,null,null,"City",null,"Quincy",null,null,"Zip","98848"]
[null,null,null,null,"County","[select one]","Grant",null,"(select)"]
[null,null,null,null,"Land use","[select one]","menu ▼",null,"(select)"]
[null,null,null,null,"Parcel(s)","[list all, separated by \" ; \"]"]
[]
[null,null,2,"▼ Enter Ecology identifiers (all that apply, add overflow to narrative)"]
[]
[null,null,null,null,"Responsible unit",null,"ERO",null,"(select)"]
[null,null,null,null,"ERTS",null,"729023"]
[null,null,null,null,"CSID",null,"17003"]
[null,null,null,null,"FSID",null,"5629891"]
[null,null,null,null,"VCP"]
[null,null,null,null,"UST ID"]
[null,null,null,null,"LUST ID"]
[]
[null,null,3,"▼ Enter relevant info"]
[]
[null,null,null,null,"Assessor name",null,"Sara Fulton"]
[null,null,null,null,"Assessment date",null,"2024-03-04"]
[null,null,null,null,null,null,null,"Current MTCA cleanup milestone","initial investigation",null,"(select)"]
[]
[null,null,4,"Is this a SHARP first assessment or re-assessment.",null,null,null,null,"first assessment",null,"(select)"]
[]
[null,null,null,"♦ If re-assessing, enter SHARP first-assessment information from ISIS here."]
[null,null,null,null,"♦ SHARP Tool version"]
[null,null,null,null,"♦ SHARP assessment date"]
[null,null,null,null,"♦ SHARP rating",null,null,"menu ▼",null,"(select)"]
[null,null,null,null,"♦ EJFlagged?",null,null,"menu ▼",null,"(select)"]
[null,null,null,null,"♦ LD data confidence level",null,null,"menu ▼"]
[null,null,null,null,"♦ Cleanup milestone",null,null,"menu ▼",null,"(select)"]
[null,null,null,null,"♦ Assessor name"]
[]
[]
[null,null,5,"▼ Enter  sources reviewed (newest to oldest: year, title, author/organization)"]
[]
[null,null,null,null,"None"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,6,"▼ Describe the source/source area"]
[]
[null,null,"According to the SPILLs report, the cause of the release was due to mechanical failure (The wind caused an arm to fall into a valve opening it spilling 104 gallons of diesel into concrete and asphalt parking area and water oil separator containment)."]
[]
[]
[]
[]
[]
[null,null,7,"▼ Briefly summarize the site's contamination and cleanup history"]
[]
[null,null,"According to the SPILLs report, the cause of the release was due to mechanical failure (The wind caused an arm to fall into a valve opening it spilling 104 gallons of diesel into concrete and asphalt parking area and water oil separator containment). Photos taken by SPILLS show deep cracks in the concrete/asphalt, suspect that some of the diesel fuel seeped into those cracks. \n\nPer Shawn Conroy, they plan to seal the cracks but not replace the concrete/asphalt. At this time, no further cleanup work is expected at this time. "]

{"sheet":"LD","index":2,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[29,2,33,13],[8,2,8,8],[20,2,20,7],[3,10,3,13],[22,10,22,12],[24,10,24,12]]}
[]
[]
[]
[null,null,"Local Demographics",null,null,null,null,null,null,null,{"$f":"IF(OR(LD_P80_DemoIndex=\"\",LD_P80_SubDemoIndex=\"\",LD_P80_Color=\"\",LD_P80_Income=\"\",LD_P80_Unemployed=\"\",LD_P80_English=\"\",LD_P80_School=\"\",LD_P80_Under5=\"\",LD_P80_Over64=\"\",LD_P80_LowLife=\"\",EHDRank=\"\",LD_Override=\"menu ▼\",LD_Confidence=\"menu ▼\"),\"Respond to all fields\",\n\nIF(LD_Override=\"yes\",\"EJFlagged: Overridden\",\n\nIF(OR(LD_P80_DemoIndex>=80,LD_P80_SubDemoIndex>=80,EHDRank>8),\"EJFlagged\",\"No EJFlag\")))","v":"EJFlagged"}]
[]
[null,null,"Follow instructions in the SHARP Manual to collect local demographics information from"]
[null,null," the following two websites."]
[]
[null,null,"1  Collect EJScreen socioeconomic index data"]
[null,null,null,null,"Following SHARP Manual instructions, generate an EJScreen Community Report for the site."]
[null,null,null,null,"Within the Selected Variables table, enter the data in the \"Percentile in State\" column"]
[null,null,null,null,"for the following socioeconomic indicators."]
[]
[]
[null,null,null,null,null,95,"◄","Demographic Index",null,null,92,"◄","Limited English speaking households"]
[null,null,null,null,null,89,"◄","Supplemental Demographic Index",null,null,95,"◄","Less than high school education"]
[null,null,null,null,null,97,"◄","People of color",null,null,86,"◄","Under age 5"]
[null,null,null,null,null,80,"◄","Low income",null,null,17,"◄","Over age 64"]
[null,null,null,null,null,49,"◄","Unemployment rate",null,null,17,"◄","Low life expectancy"]
[]
[null,null,"2  Collect EHD rank data",null,null,null,null,null,null,null,10,"◄","Enter EHD ranking score 1 to 10"]
[]
[null,null,"3  Select a data confidence level",null,null,null,null,null,null,null,"low",null,null,"(select)"]
[]
[null,null,"4  Does the site qualify for an EJFlag override?",null,null,null,null,null,null,null,"no",null,null,"(select)"]
[null,null,null,null,null,"If \"yes\", leave comment below."]
[]
[null,null,"5  Enter comments"]

{"sheet":"SL","index":3,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":false,"merged":[[2,4,2,5],[4,4,4,5],[2,1,2,3],[111,1,116,6]]}
[]
[]
[null,"Soil Assessment",null,null,{"$f":"IF(OR(SL_ExScore=\"SHARPen it\",SL_SvScore=\"SHARPen it\",SL_Conf=\"menu ▼\"),\"SHARPen it\",\nCONCATENATE(SL_ExScore,SL_SvScore))","v":"C4"}]
[]
[null,1,"Select confidence level",null,"medium"]
[]
[null,2,"Potential Exposure",null,"Answers/Scores",null,"Tips"]
[null,null,"SL_Ex1","Is there a current impact to site soil that needs cleanup action?","maybe",null,"For people exposed to soil contamination, the MTCA soil-direct contact point of compliance is from ground surface to 15 feet deep across the site (WAC 173-340-740[6][d]). In leaching conditions, the point of contact can exceed this and include the saturated zone."]
[null,null,null,null,{"$f":"IF(SL_Ex1_Ans=\"menu ▼\",\"\",\nIF(OR(SL_Ex1_Ans=\"yes\",SL_Ex1_Ans=\"maybe\"),\"continue\",\nIF(SL_Ex1_Ans=\"no\",\"D\",\"\")))","v":"continue"},null,"► WAC 173-340-740 Unrestricted land use soil cleanup standards"]
[null,null,null,null,null,"Y","Either of the following is true."]
[null,null,null,null,null,"•","Testing results confirm contamination levels exceed an applicable MTCA cleanup or screening level."]
[null,null,null,null,null,"•","A contaminant is visible on soil (e.g., leaking drum liquid or a solid [powder])."]
[null,null,null,null,null,"M","All of the following are true."]
[null,null,null,null,null,"•","Soil is discolored, stained, or oily, or has an unnatural odor."]
[null,null,null,null,null,"•","Testing information isn't available or adequate enough to rule out an impact."]
[null,null,null,null,null,"•","A natural biological source cannot be ruled out."]
[null,null,null,null,null,"N","Either of the following is true."]
[null,null,null,null,null,"•","Soil testing information indicates no evidence of soil contamination at levels greater than applicable MTCA cleanup or screening levels."]
[null,null,null,null,null,"•","No release has been observed, documented, or reported."]
[null,null,"SL_Ex2","Is soil contaminated anywhere from ground surface to approximately 2 feet deep?","maybe",null,"Most soil-direct contact (dermal) exposures are likely to occur at ground surface and down into shallow depths. Common activities that can present soil-direct contact might include participating in sporting events, children playing, gardening, installing fence posts, and landscaping, each of which typically occur from ground surface to about 2 feet deep. Soil at this depth is considered to be \"readily accessible\". Soil-direct contact includes ingestion for children playing (age 0 to 6 years old), but consider the likelihood for elementary or middle school populations on site. Soil-direct contact exposures is less common or likely with increasing depth."]
[null,null,null,null,{"$f":"IF(SL_Ex1_Score=\"D\",\"SKIP\",\nIF(SL_Ex2_Ans=\"menu ▼\",\"\",\n\nIF(SL_Ex2_Ans=\"yes\",\"A\",\nIF(SL_Ex2_Ans=\"maybe\",\"B\",\nIF(SL_Ex2_Ans=\"no\",\"D\",\"\")))))","v":"B"},"Y","Either of the following is true for this approximate depth interval."]
[null,null,null,null,null,"•","Testing results confirm contamination levels exceed an applicable MTCA cleanup or screening level."]
[null,null,null,null,null,"•","A contaminant is visible on soil (e.g., leaking drum liquid or a solid [powder])."]
[null,null,null,null,null,"M","All of the following are true for this approximate depth interval."]
[null,null,null,null,null,"•","Soil is discolored, stained, or oily, or has an unnatural odor."]
[null,null,null,null,null,"•","Testing information isn't available or adequate enough to rule out an impact."]
[null,null,null,null,null,"•","A natural biological source cannot be ruled out."]
[null,null,null,null,null,"N","Either of the following is true for this approximate depth interval."]
[null,null,null,null,null,"•","Soil testing information indicates no evidence of soil contamination at levels greater than applicable MTCA cleanup or screening levels."]
[null,null,null,null,null,"•","No release has been observed, documented, or reported."]
[null,null,"SL_Ex3","Do plants or animals have access to soil contamination anywhere from ground surface to 6 feet deep?","no",null,"The conditional soil point of compliance for plants and animals is from ground surface to 6 feet deep, the reasonable depth terrestrial plants can root and animals can burrow (WAC 173-340-7490[4][a]). The area of contaminated soil that triggers evaluation of plant and animal protective values depends on site contaminants. Consider the following criteria, used for a terrestrial ecological evaluation (TEE), to estimate the risk of exposure to plants and animals (WAC 173-340-7490 through 7493)."]
[null,null,null,null,{"$f":"IF(SL_Ex1_Score=\"D\",\"SKIP\",\nIF(SL_Ex3_Ans=\"menu ▼\",\"\",\n\nIF(SL_Ex3_Ans=\"yes\",\"A\",\nIF(SL_Ex3_Ans=\"maybe\",\"B\",\nIF(SL_Ex3_Ans=\"no\",\"D\",\"\")))))","v":"D"},null," - All contaminated soil is under pavement, a building, or other physical barrier."]
[null,null,null,null,null,null," - Contamination isn't observed or confirmed from ground surface to 6 feet deep."]
[null,null,null,null,null,null," - Contaminant levels aren't greater than soil background levels."]
[null,null,null,null,null,null," - The site meets any of the criteria for a TEE exemption."]
[null,null,null,null,null,null," - The result of a simplified TEE ends the TEE process."]
[null,null,null,null,null,null,"► WAC 173-340-7490. Terrestrial ecological evaluation procedures"]
[null,null,null,null,null,null,"► WAC 173-340-7491. Exclusions from a terrestrial ecological evaluation"]
[null,null,null,null,null,null,"► WAC 173-340-7492. Simplified terrestrial ecological evaluation procedures"]
[null,null,null,null,null,null,"► WAC 173-340-7493. Site-specific terrestrial ecological evaluation procedures"]
[null,null,null,null,null,null,"See Ecology's draft guidance."]
[null,null,null,null,null,null,"► Technical Document: Terrestrial Ecological Evaluations under the Model Toxics Control Act"]
[null,null,null,null,null,"Y","Either of the following is true."]
[null,null,null,null,null,"•","A TEE was conducted that didn't result in a TEE exemption or a simplified TEE that ended. "]
[null,null,null,null,null,"•","A TEE hasn't been conducted, but the site doesn't meet any exclusion criteria."]
[null,null,null,null,null,"M","Either of the following is true."]
[null,null,null,null,null,"•","Knowledge of site conditions is too limited or inadequate to rule out access to plants and animals."]
[null,null,null,null,null,"•","A non-permanent barrier is in place that currently prevents plants and animals from accessing the soil."]
[null,null,null,null,null,"N","At least one TEE exclusion criterion is met."]
[null,null,"SL_Ex4","Do any physical barriers block people from direct contact with soil contamination?","yes",null,"Physical contact with soil contamination can be blocked by physical barriers such as buildings, pavement, soil caps, geotextile fabrics, and mitigation barriers. Security fencing and warning signage don't necessarily block access but rather deter access to contaminated soil."]
[null,null,null,null,{"$f":"IF(SL_Ex1_Score=\"D\",\"SKIP\",\nIF(SL_Ex4_Ans=\"menu ▼\",\"\",\n\nIF(SL_Ex4_Ans=\"yes\",\"C\",\nIF(SL_Ex4_Ans=\"maybe\",\"B\",\nIF(SL_Ex4_Ans=\"no\",\"A\",\"\")))))","v":"C"},"Y","A physical barrier is in place to block soil-direct contact."]
[null,null,null,null,null,"M","A physical barrier prevents some but not all soil-direct contact, such as a partially paved or fenced area."]
[null,null,null,null,null,"N","No physical barrier is in place to block soil-direct contact."]
[null,"",null,"Exposure score ►",{"$f":"IF(OR(SL_Ex1_Score=\"\",SL_Ex2_Score=\"\",SL_Ex3_Score=\"\",SL_Ex4_Score=\"\"),\"SHARPen it\",\nIF(SL_Ex1_Score=\"D\",\"D\",\n\nIF(AND(OR(SL_Ex2_Score=\"A\",SL_Ex2_Score=\"B\",SL_Ex2_Score=\"D\"),SL_Ex3_Score=\"A\",SL_Ex4_Score=\"A\"),\"A\",\nIF(AND(OR(SL_Ex2_Score=\"A\",SL_Ex2_Score=\"B\",SL_Ex2_Score=\"D\"),SL_Ex3_Score=\"A\",SL_Ex4_Score=\"B\"),\"A\",\nIF(AND(OR(SL_Ex2_Score=\"A\",SL_Ex2_Score=\"B\",SL_Ex2_Score=\"D\"),SL_Ex3_Score=\"A\",SL_Ex4_Score=\"C\"),\"C\",\n\nIF(AND(SL_Ex2_Score=\"A\",SL_Ex3_Score=\"B\",SL_Ex4_Score=\"A\"),\"A\",\nIF(AND(OR(SL_Ex2_Score=\"A\",SL_Ex2_Score=\"B\",SL_Ex2_Score=\"D\"),SL_Ex3_Score=\"B\",SL_Ex4_Score=\"B\"),\"B\",\nIF(AND(OR(SL_Ex2_Score=\"A\",SL_Ex2_Score=\"B\",SL_Ex2_Score=\"D\"),SL_Ex3_Score=\"B\",SL_Ex4_Score=\"C\"),\"C\",\n\n\nIF(AND(SL_Ex2_Score=\"A\",SL_Ex3_Score=\"D\",SL_Ex4_Score=\"A\"),\"A\",\nIF(AND(OR(SL_Ex2_Score=\"A\",SL_Ex2_Score=\"B\"),SL_Ex3_Score=\"D\",SL_Ex4_Score=\"B\"),\"B\",\nIF(AND(OR(SL_Ex2_Score=\"A\",SL_Ex2_Score=\"B\",SL_Ex2_Score=\"D\"),SL_Ex3_Score=\"D\",SL_Ex4_Score=\"C\"),\"C\",\n\nIF(AND(OR(SL_Ex3_Score=\"B\",SL_Ex3_Score=\"D\"),SL_Ex2_Score=\"B\",SL_Ex4_Score=\"A\"),\"B\",\n\nIF(AND(OR(SL_Ex4_Score=\"A\",SL_Ex4_Score=\"B\",SL_Ex4_Score=\"C\"),SL_Ex2_Score=\"D\",SL_Ex3_Score=\"D\"),\"C\",\n\"SHARPen it\")))))))))))))","v":"C"}]
[]
[null,3,"Severity",null,"Answers/Scores","Tips"]
[null,null,"SL_Sv1","Is any extremely toxic chemical in soil?","no",null,"Compare confirmed or suspected chemicals in soil with those listed as extremely toxic under the ChemTox table heading \"Soil, Groundwater, Air\"."]
[null,null,null,null,{"$f":"IF(SL_ExScore=\"D\",\"SKIP\",\nIF(SL_Sv1_Ans=\"menu ▼\",\"\",\n\nIF(SL_Sv1_Ans=\"yes\",10,\nIF(SL_Sv1_Ans=\"maybe\",6,\nIF(SL_Sv1_Ans=\"no\",0,\"\")))))","v":0},null,"► ChemTox"]
[null,null,null,null,null,"Y","Any chemical in soil is listed as extremely toxic in the ChemTox table."]
[null,null,null,null,null,"M","Any chemical in soil may be listed as extremely toxic in the ChemTox table, but analytical data are not available to confirm."]
[null,null,null,null,null,"N","No chemical in soil is listed as extremely toxic in the ChemTox table."]
[null,null,"SL_Sv2","Is any very toxic chemical in soil?","no",null,"Compare confirmed or suspected chemicals in soil with those listed as very toxic under the ChemTox table heading \"Soil, Groundwater, Air\"."]
[null,null,null,null,{"$f":"IF(SL_ExScore=\"D\",\"SKIP\",\nIF(OR(SL_Sv1_Score=10,SL_Sv1_Score=6,SL_Sv1_Score=2),\"SKIP\",\nIF(SL_Sv2_Ans=\"menu ▼\",\"\",\n\nIF(SL_Sv2_Ans=\"yes\",5,\nIF(SL_Sv2_Ans=\"maybe\",3,\nIF(SL_Sv2_Ans=\"no\",0,\"\"))))))","v":0},null,"► ChemTox"]
[null,null,null,null,null,"Y","Any chemical in soil is listed as very toxic in the ChemTox table."]
[null,null,null,null,null,"M","Any chemical in soil may be listed as very toxic in the ChemTox table, but analytical data are not available to confirm."]
[null,null,null,null,null,"N","No chemical in soil is listed as very toxic in the ChemTox table."]
[null,null,"SL_Sv3","Do children have unrestricted access to the site?","no",null,"Small children are at the greatest risk of accidental soil ingestion through playing and digging in shallow soil. Consider if children may live or play near the site or have unrestricted access to contaminated soil. For soil ingestion, children are considered to be 0 to 6 years of age, but consider the likelihood of occupancy by elementary and middle school populations."]
[null,null,null,null,{"$f":"IF(SL_ExScore=\"D\",\"SKIP\",\nIF(SL_Sv3_Ans=\"menu ▼\",\"\",\n\nIF(SL_Sv3_Ans=\"yes\",10,\nIF(SL_Sv3_Ans=\"maybe\",6,\nIF(SL_Sv3_Ans=\"no\",0,\"\")))))","v":0},"Y","No physical barrier blocks children from accessing the contaminated area."]
[null,null,null,null,null,"M","A physical barrier prevents some but not all soil-direct contact, such as a partially paved or fenced contaminated area."]
[null,null,null,null,null,"N","A physical barrier blocks access to the contaminated area."]
[null,null,"SL_Sv4","Are people likely to be exposed to contaminated soil as airborne dust?","no",null,"Bare, dry soil contamination can become airborne and present an inhalation exposure. This is more important in arid or windy regions like Eastern Washington or in seasonally dry areas."]
[null,null,null,null,{"$f":"IF(SL_ExScore=\"D\",\"SKIP\",\nIF(SL_Sv4_Ans=\"menu ▼\",\"\",\n\nIF(SL_Sv4_Ans=\"yes\",5,\nIF(SL_Sv4_Ans=\"maybe\",3,\nIF(SL_Sv4_Ans=\"no\",0,\"\")))))","v":0},"Y","People use or occupy areas susceptible to contact with dusty airborne contamination."]
[null,null,null,null,null,"M","People occasionally could use or occupy areas susceptible to contact with dusty airborne contamination."]
[null,null,null,null,null,"N","The soil contamination is capped or wouldn't likely present dusty conditions."]
[null,null,"SL_Sv5","Has any volatile chemical been identified in site soil or groundwater?","no",null,"A volatile chemical's liquid and gaseous phases can occupy and contaminate soil pore spaces. Further, a volatile chemical gaseous phase in groundwater can mobilize upward above the saturated zone and contaminate soil from below. Identify volatile chemicals in soil and groundwater by comparing confirmed or suspected chemicals with listed chemicals marked as \"yes\" under the  ChemTox table heading \"Possible Vapor Intrusion\"."]
[null,null,null,null,{"$f":"IF(SL_ExScore=\"D\",\"SKIP\",\nIF(SL_Sv5_Ans=\"menu ▼\",\"\",\n\nIF(SL_Sv5_Ans=\"yes\",5,\nIF(SL_Sv5_Ans=\"maybe\",3,\nIF(SL_Sv5_Ans=\"no\",0,\"\")))))","v":0},null,"► ChemTox"]
[null,null,null,null,null,"Y","A volatile chemical has been released to, or identified in, site soil or groundwater, as confirmed by analysis."]
[null,null,null,null,null,"M","A volatile chemical has likely been released to, or identified in, site soil or groundwater, but testing information isn't available to confirm."]
[null,null,null,null,null,"N","Testing information confirms no volatile chemical has been released to site soil or groundwater, and there is no credible reason to suspect a release."]
[null,null,"SL_Sv6","Does soil contamination pose an immediate risk to groundwater?","maybe",null,"Soil permeability is a soil quality that enables vapor and liquid contaminants to transmit through soil pore space and potentially reach groundwater. Cleanup levels for a soil are established based on the potential for a contaminant to leach from soil into groundwater (WAC 173-340-747). Review the following resources to assess whether groundwater is at risk from soil contamination, based on confirmed or potential soil concentrations."]
[null,null,null,null,{"$f":"IF(SL_ExScore=\"D\",\"SKIP\",\nIF(SL_Sv6_Ans=\"menu ▼\",\"\",\n\nIF(SL_Sv6_Ans=\"yes\",5,\nIF(SL_Sv6_Ans=\"maybe\",3,\nIF(SL_Sv6_Ans=\"no\",0,\"\")))))","v":3},null,"► WAC 173-340-747. Deriving soil concentrations for groundwater protection"]
[null,null,null,null,null,null,"► TCP Maps"]
[null,null,null,null,null,null,"► CLARC home page"]
[null,null,null,null,null,null,"► CLARC \"Master CLARC Spreadsheet\" Tab (surface water headings)(will download)"]
[null,null,null,null,null,null,"► WAC 173-340-357 Soil to groundwater pathway"]
[null,null,null,null,null,"Y","Any of the following is true."]
[null,null,null,null,null,"•","Soil contaminant levels are confirmed in site groundwater in excess of applicable MTCA cleanup or screening levels derived for groundwater protection."]
[null,null,null,null,null,"•","The soil contaminant is a non-aqueous phase liquid."]
[null,null,null,null,null,"•","The close proximity and depth of the soil contamination poses a risk to groundwater."]
[null,null,null,null,null,"M","Both of the following are true."]
[null,null,null,null,null,"•","Soil contaminant levels may be greater than applicable MTCA cleanup or screening levels for the soil to groundwater pathway."]
[null,null,null,null,null,"•","Groundwater isn't excessively deep or isn't separated from soil contamination by sufficiently low-permeability strata, such as fine-grained or clay-rich soils."]
[null,null,null,null,null,"N","Either of the following is true."]
[null,null,null,null,null,"•","Soil contamination is relatively \"old\" with no evidence of having mobilized to groundwater."]
[null,null,null,null,null,"•","Groundwater is fairly excessively \"deep\" or is separated from contamination by sufficiently low-permeability strata."]
[null,null,"SL_Sv7","Do soil contaminants pose an immediate risk to surface water or sediment?","no",null,"Contaminated runoff poses a common risk to surface water and sediment. The runoff pathway can be direct or indirect such as through water flowing in trenches or storm sewer systems that discharge to surface water."]
[null,null,null,null,{"$f":"IF(SL_ExScore=\"D\",\"SKIP\",\nIF(SL_Sv7_Ans=\"menu ▼\",\"\",\n\nIF(SL_Sv7_Ans=\"yes\",5,\nIF(SL_Sv7_Ans=\"maybe\",3,\nIF(SL_Sv7_Ans=\"no\",0,\"\")))))","v":0},"Y","Any of the following is true."]
[null,null,null,null,null,"•","Soil contaminants are confirmed in site surface water or sediment at levels greater than applicable MTCA cleanup or screening levels."]
[null,null,null,null,null,"•","A perennial or intermittent surface water body is within 100 ft downslope of site contamination."]
[null,null,null,null,null,"•","The close proximity of the soil contamination poses a risk to surface water or sediment."]
[null,null,null,null,null,"M","At least one of the following is true, and sampling hasn't ruled out surface water and/or sediment impacts."]
[null,null,null,null,null,"•","Site soil contamination is near or on a waterfront."]
[null,null,null,null,null,"•","A permitted stormwater treatment system is in place and operating as intended, at this time."]
[null,null,null,null,null,"•","Current or historic on-site wastewater or storm water systems drain to surface water or a waterfront."]
[null,null,null,null,null,"•","The site supports or has supported over-water activities like log rafting, boat maintenance, utility conveyance, or fuel or bilge transfer."]
[null,null,null,null,null,"N","Either of the following is true."]
[null,null,null,null,null,"•","Runoff from the site is not feasible."]
[null,null,null,null,null,"•","Site runoff cannot reach or is unlikely to reach surface water or sediment."]
[null,null,null,"Severity score",{"$f":"IF(SL_ExScore=\"D\",\"4\",\nIF(OR(SL_Sv1_Score=\"\",SL_Sv2_Score=\"\",SL_Sv3_Score=\"\",SL_Sv4_Score=\"\",SL_Sv5_Score=\"\",SL_Sv6_Score=\"\",SL_Sv7_Score=\"\"),\"SHARPen it\",\n\nIF(SL_SvQSum>=SL_SvThresh,1,\nIF(SL_SvQSum>=SL_SvThresh*2/3,2,\nIF(SL_SvQSum>=SL_SvThresh/3,3,4)))))","v":4}]
[]
[null,4,"Enter comments"]
[null,"The site is covered in concrete/asphalt however there are numerous cracks throughout. These cracks could have allowed the diesel to seep into the soil. "]

{"sheet":"GW","index":4,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[[2,4,2,5],[4,4,4,5],[2,1,2,3],[80,1,85,6]]}
[]
[]
[null,"Groundwater Assessment",null,null,{"$f":"IF(OR(GW_ExScore=\"SHARPen it\",GW_SvScore=\"SHARPen it\",GW_Conf=\"menu ▼\"),\"SHARPen it\",\nCONCATENATE(GW_ExScore,GW_SvScore))","v":"B4"}]
[]
[null,1,"Select confidence level",null,"medium"]
[]
[null,2,"Potential Exposure",null,"Answers/Scores",null,"Tips"]
[null,null,"GW_Ex1","Is there an on-site release or impact to groundwater that needs cleanup?","maybe",null,"The standard point of compliance for protection of groundwater quality is across the site from the top of the saturated zone to the lowest saturated depth which could be impacted (WAC 173-340-720[8][b]). If a release to soil has not been cleaned up, and site cleanup or screening levels aren't set, default to comparing data to Methods A or B cleanup levels protective of potable groundwater (WAC 173-340-720[3] and [4]). Compare concentrations with Method A cleanup levels, if the investigation is in its early stages or contaminants are few, and a fairly straightforward cleanup strategy is known or likely. Method B may be used at any site where contaminants aren't listed under Method A. See CLARC's \"GW Method A, B & ARARs\"."]
[null,null,null,null,{"$f":"IF(GW_Ex1_Ans=\"menu ▼\",\"\",\nIF(OR(GW_Ex1_Ans=\"yes\",GW_Ex1_Ans=\"maybe\"),\"continue\",\nIF(GW_Ex1_Ans=\"no\",\"D\",\"\")))","v":"continue"},null,"► WAC 173-340-720 Groundwater cleanup standards"]
[null,null,null,null,null,null,"► CLARC \"GW Method A, B & ARARs\" Tab (will download)"]
[null,null,null,null,null,"Y","Either of the following is true."]
[null,null,null,null,null,"•","Testing results indicate at least one chemical concentration that exceeds an applicable MTCA cleanup or screening level for soil or groundwater."]
[null,null,null,null,null,"•","An unnatural oil-like sheen is observed on groundwater samples."]
[null,null,null,null,null,"M","Any of the following is true."]
[null,null,null,null,null,"•","Testing has not been conducted and used to rule out an impact."]
[null,null,null,null,null,"•","The range of chemicals used in soil testing is insufficient to be able to rule out an impact to soil."]
[null,null,null,null,null,"•","Pit water or well water samples appear unnaturally discolored or have an unnatural odor."]
[null,null,null,null,null,"N","Either of the following is true."]
[null,null,null,null,null,"•","The range of chemicals used in soil testing is sufficient enough to rule out an impact to soil."]
[null,null,null,null,null,"•","Contaminant concentrations in soil don't exceed applicable MTCA cleanup or screening levels."]
[null,null,"GW_Ex2","Is a site or vicinity drinking water well impacted by contaminants released at the site?","maybe",null,"Review TCP Maps and the DOH Source Water Assessment Program (SWAP) Maps to identify drinking water wells on site or in the vicinity. Also review water well reports, boring logs, groundwater data, and related information to determine the potential for site contamination to have impacted any site or vicinity drinking water wells. Compare available site drinking water well data to applicable MTCA cleanup or screening levels in CLARC's \"GW Method A, B & ARARs\" sheet."]
[null,null,null,null,{"$f":"IF(GW_Ex1_Score=\"D\",\"SKIP\",\nIF(GW_Ex2_Ans=\"menu ▼\",\"\",\n\nIF(GW_Ex2_Ans=\"yes\",\"A\",\nIF(GW_Ex2_Ans=\"maybe\",\"B\",\nIF(GW_Ex2_Ans=\"no\",\"C\",\"\")))))","v":"B"},null,"► TCP Maps"]
[null,null,null,null,null,null,"► DOH SWAP Maps"]
[null,null,null,null,null,null,"► CLARC \"GW Method A, B & ARARs\" Tab"]
[null,null,null,null,null,"Y","Any of the following is true."]
[null,null,null,null,null,"•","A groundwater impact is confirmed for an on-site or vicinity drinking water well."]
[null,null,null,null,null,"•","Groundwater testing results show chemical concentrations greater than any applicable MTCA cleanup standard in a site or vicinity drinking water well."]
[null,null,null,null,null,"•","A TCP Maps query shows the estimated site plume to be within the 10-year travel-time zone of a Group A or B water supply well, unless a hydrogeologic factor indicates an absence of connection between the impacted groundwater and the drinking water aquifer (for example, a site adjacent to a groundwater discharge area where an upward gradient exists)."]
[null,null,null,null,null,"M","A domestic drinking water well or irrigation well is located on site or within 500 feet of the site."]
[null,null,null,null,null,"N","A municipal or community drinking water system serves the site with water from a surface water source, and groundwater isn't a likely or viable water supply source."]
[null,null,null,"Exposure score ►",{"$f":"IF(OR(GW_Ex1_Score=\"\",GW_Ex2_Score=\"\"),\"SHARPen it\",\n\nIF(GW_Ex1_Score=\"D\",\"D\",\n\nIF(GW_Ex2_Score=\"A\",\"A\",\nIF(GW_Ex2_Score=\"B\",\"B\",\nIF(GW_Ex2_Score=\"C\",\"C\")))))","v":"B"}]
[]
[null,3,"Severity",null,"Answers/Scores","Tips"]
[null,null,"GW_Sv1","Is any extremely toxic chemical in groundwater?","no",null,"Compare confirmed or suspected chemicals in groundwater with those listed as extremely toxic under the ChemTox table heading \"Soil, Groundwater, Air\"."]
[null,null,null,null,{"$f":"IF(GW_ExScore=\"D\",\"SKIP\",\nIF(GW_Sv1_Ans=\"menu ▼\",\"\",\n\nIF(GW_Sv1_Ans=\"yes\",10,\nIF(GW_Sv1_Ans=\"maybe\",6,\nIF(GW_Sv1_Ans=\"no\",0,\"\")))))","v":0},null,"► ChemTox"]
[null,null,null,null,null,"Y","Any chemical in groundwater is listed as extremely toxic in the ChemTox table."]
[null,null,null,null,null,"M","Any chemical in groundwater may be listed as extremely toxic in the ChemTox table, but analytical data are not available to confirm."]
[null,null,null,null,null,"N","No chemical in groundwater is listed as extremely toxic in the ChemTox table."]
[null,null,"GW_Sv2","Is any very toxic chemical in groundwater?","no",null,"Compare confirmed or suspected chemicals in groundwater with those listed as very toxic under the ChemTox table heading \"Soil, Groundwater, Air\"."]
[null,null,null,null,{"$f":"IF(GW_ExScore=\"D\",\"SKIP\",\nIF(OR(GW_Sv1_Score=10,GW_Sv1_Score=6),\"SKIP\",\nIF(GW_Sv2_Ans=\"menu ▼\",\"\",\n\nIF(GW_Sv2_Ans=\"yes\",5,\nIF(GW_Sv2_Ans=\"maybe\",3,\nIF(GW_Sv1_Ans=\"no\",0,\"\"))))))","v":0},null,"► ChemTox"]
[null,null,null,null,null,"Y","Any chemical in groundwater is listed as very toxic in the ChemTox table."]
[null,null,null,null,null,"M","Any chemical in groundwater may be listed as very toxic in the ChemTox table, but analytical data are not available to confirm."]
[null,null,null,null,null,"N","No chemical in groundwater is listed as very toxic in the ChemTox table."]
[null,null,"GW_Sv3","Is contaminated groundwater either: 1) within the 10-year travel-time zone of a Group A or B water supply well; or 2) within 500 feet of a domestic water well or irrigation well?","no",null,"Use TCP Maps and DOH SWAP Maps to access groundwater data and other information for the site and vicinity. See if a site or vicinity water supply well derives water from the affected aquifer. The following resources may be helpful."]
[null,null,null,null,{"$f":"IF(GW_ExScore=\"D\",\"SKIP\",\nIF(GW_Sv3_Ans=\"menu ▼\",\"\",\n\nIF(GW_Sv3_Ans=\"yes\",10,\nIF(GW_Sv3_Ans=\"maybe\",6,\nIF(GW_Sv3_Ans=\"no\",0,\"\")))))","v":0},null,"► TCP Maps"]
[null,null,null,null,null,null,"► DOH SWAP Maps"]
[null,null,null,null,null,"Y","Any water supply well meets these criteria, based on sufficient quality information."]
[null,null,null,null,null,"M","Any water supply well meets these criteria, based on minimal or low quality information."]
[null,null,null,null,null,"N","No known well meets these criteria."]
[null,null,"GW_Sv4","Has any water supply well been adversely affected by site contamination, including any taken out of service?","no",null,"Use TCP Maps and DOH SWAP Maps to determine if any water supply wells are impacted, or likely to be impacted, by contaminants originating from the site."]
[null,null,null,null,{"$f":"IF(GW_ExScore=\"D\",\"SKIP\",\nIF(GW_Sv4_Ans=\"menu ▼\",\"\",\n\nIF(GW_Sv4_Ans=\"yes\",10,\nIF(GW_Sv4_Ans=\"maybe\",6,\nIF(GW_Sv4_Ans=\"no\",0,\"\")))))","v":0},null,"► TCP Maps"]
[null,null,null,null,null,null,"► DOH SWAP Maps"]
[null,null,null,null,null,"Y","Impact to a water supply well has been confirmed by groundwater data."]
[null,null,null,null,null,"M","Impact to a water supply well is alleged or suspected, based on minimal information."]
[null,null,null,null,null,"N","No water supply well has been reported to be affected."]
[null,null,"GW_Sv5","Is any light non-aqueous phase liquid (LNAPL) chemical observed or present at a measurable thickness in site groundwater?","maybe",null,"LNAPLs such as oils don't mix well with water and are less dense than water. Therefore, they tend to spread or float across a water surface as a visible sheen or as a thicker layer that is measurable. Compare site observations identifying the presence of LNAPL with the chemicals listed in the following publication."]
[null,null,null,null,{"$f":"IF(GW_ExScore=\"D\",\"SKIP\",\nIF(GW_Sv5_Ans=\"menu ▼\",\"\",\n\nIF(GW_Sv5_Ans=\"yes\",5,\nIF(GW_Sv5_Ans=\"maybe\",3,\nIF(GW_Sv5_Ans=\"no\",0,\"\")))))","v":3},null,"► EPA Ground Water Issue, Light Nonaqueous Phase Liquids"]
[null,null,null,null,null,"Y","LNAPL is visible on groundwater or pit water as a sheen or is present in a measurable thickness."]
[null,null,null,null,null,"M","A sheen is observed on groundwater, but its thickness isn't measurable."]
[null,null,null,null,null,"N","No LNAPL is observed or measurable on site groundwater."]
[null,null,"GW_Sv6","Is any dense non-aqueous phase liquid (DNAPL) chemical observed or present at a measurable thickness in site groundwater?","no",null,"DNAPLs are organic chemicals (e.g., solvents) that don't mix well with water. They are denser than water and tend to sink to the bottom of aquifers. As such, they are difficult to observe in the field. Compare site observations identifying the presence of DNAPL with the chemicals listed in the following publication."]
[null,null,null,null,{"$f":"IF(GW_ExScore=\"D\",\"SKIP\",\nIF(GW_Sv6_Ans=\"menu ▼\",\"\",\n\nIF(GW_Sv6_Ans=\"yes\",5,\nIF(GW_Sv6_Ans=\"maybe\",3,\nIF(GW_Sv6_Ans=\"no\",0,\"\")))))","v":0},null,"► EPA Ground Water Issue, Dense Nonaqueous Phase Liquids"]
[null,null,null,null,null,"Y","Field observation or field DNAPL testing has confirmed DNAPL in groundwater."]
[null,null,null,null,null,"M","Field observation or field DNAPL concentrations is inconclusive, but DNAPL is suspected in site groundwater."]
[null,null,null,null,null,"N","DNAPL hasn't been observed or detected at a measurable thickness in site groundwater."]
[null,null,"GW_Sv7","Does a site plume extend beyond the source property boundary?","maybe",null,"Compare the site boundary, known or estimated, with the known or likely extent of the plume. "]
[null,null,null,null,{"$f":"IF(GW_ExScore=\"D\",\"SKIP\",\nIF(GW_Sv7_Ans=\"menu ▼\",\"\",\n\nIF(GW_Sv7_Ans=\"yes\",5,\nIF(GW_Sv7_Ans=\"maybe\",3,\nIF(GW_Sv7_Ans=\"no\",0,\"\")))))","v":3},"Y","The estimated leading edge of a plume extends beyond the source property line, based on groundwater data."]
[null,null,null,null,null,"M","The estimated leading edge of a plume likely extends beyond the source property line, but isn't wholly supported by groundwater data."]
[null,null,null,null,null,"N","Groundwater data indicate the plume doesn't extend past the property line."]
[null,null,"GW_Sv8","Does a site plume pose a potential risk to downgradient surface water or sediment?","no",null,"Identify downgradient surface water or sediment sources in the direction of groundwater flow from the site. Evaluate the risk to those sources from the site plume. Consider whether plume concentrations could sufficiently attenuate to non-risk levels before reaching the downgradient surface water or sediment sources. Review the following sources, as needed."]
[null,null,null,null,{"$f":"IF(GW_ExScore=\"D\",\"SKIP\",\nIF(GW_Sv8_Ans=\"menu ▼\",\"\",\n\nIF(GW_Sv8_Ans=\"yes\",5,\nIF(GW_Sv8_Ans=\"maybe\",3,\nIF(GW_Sv8_Ans=\"no\",0,\"\")))))","v":0},null,"► TCP Maps"]
[null,null,null,null,null,null,"► WAC 173-340-730 Surface water cleanup standards"]
[null,null,null,null,null,"Y","Groundwater data indicate an impact to surface water or sediment from a plume originating from the site."]
[null,null,null,null,null,"M","Either of the following is true."]
[null,null,null,null,null,"•","Nearby surface water or sediment sources are estimated to be downgradient of the site, based on indirect information such as topography features, surficial drainage patterns, or reliance on lower-quality information."]
[null,null,null,null,null,"•","Surface water or sediment sources are nearby, but a potential impact from groundwater and the estimated groundwater flow direction aren't well understood."]
[null,null,null,null,null,"N","Downgradient surface water and sediment sources aren't at risk."]
[null,null,null,"Severity score",{"$f":"IF(GW_ExScore=\"D\",\"4\",\nIF(OR(GW_Sv1_Score=\"\",GW_Sv2_Score=\"\",GW_Sv3_Score=\"\",GW_Sv4_Score=\"\",GW_Sv5_Score=\"\",GW_Sv6_Score=\"\",GW_Sv7_Score=\"\",GW_Sv8_Score=\"\"),\"SHARPen it\",\n\nIF(GW_SvQSum>=GW_SvThresh,1,\nIF(GW_SvQSum>=GW_SvThresh*2/3,2,\nIF(GW_SvQSum>=GW_SvThresh/3,3,4)))))","v":4}]
[]
[null,4,"Enter comments"]
[null,"The cracks in the concrete/asphalt may have allowed diesel fuel to seep into the ground. Groundwater is at approximately 17.5 feet bgs. "]

{"sheet":"SW","index":5,"n_rows":82,"n_cols":7,"rows_kept":82,"cut":false,"hidden":false,"merged":[[2,4,2,5],[4,4,4,5],[2,1,2,3],[82,1,87,6]]}
[]
[]
[null,"Surface Water Assessment",null,null,{"$f":"IF(OR(SW_ExScore=\"SHARPen it\",SW_SvScore=\"SHARPen it\",SW_Conf=\"menu ▼\"),\"SHARPen it\",\nCONCATENATE(SW_ExScore,SW_SvScore))","v":"D4"}]
[]
[null,1,"Select confidence level",null,"high"]
[]
[null,2,"Potential Exposure",null,"Answers/Scores",null,"Tips"]
[null,null,"SW_Ex1","Is surface water present on the site?","no",null,"MTCA defines surface water as lakes, rivers, ponds, streams, inland waters, salt waters, and all other surface waters and water courses in the state (WAC 173-340-200). Well to moderately well drained soils aren't likely to support surface water conditions. Use map sources, including the Department of Fish & Wildlife (DFW) sources, to identify or estimate the presence of surface water or its indicators, such as aquatic habitat."]
[null,null,null,null,{"$f":"IF(SW_Ex1_Ans=\"menu ▼\",\"\",\n\nIF(OR(SW_Ex1_Ans=\"yes\",SW_Ex1_Ans=\"maybe\"),\"continue\",\nIF(SW_Ex1_Ans=\"no\",\"D\",\"\")))","v":"D"},null,"► TCP Maps"]
[null,null,null,null,null,null,"► DFW Priority Habitat and Species Map Tool"]
[null,null,null,null,null,"Y","Surface water is observed or reported on site."]
[null,null,null,null,null,"M","Surface water is likely present, but information unavailable or inadequate to rule out its presence."]
[null,null,null,null,null,"N","Any of the following is true."]
[null,null,null,null,null,"•","The site is paved or covered by buildings or structures."]
[null,null,null,null,null,"•","The site is too steep to likely support surface water or has well-draining soil."]
[null,null,null,null,null,"•","No on-site standing or surface water is present."]
[null,null,"SW_Ex2","Is surface water contaminated at levels greater than applicable MTCA cleanup or screening levels?","menu ▼",null,"Based on the protection of surface water, the standard point of compliance is all locations where contamination is released to surface water (WAC 173-340-730[6]). If site-specific cleanup levels aren't available, use CLARC surface water screening levels for marine or fresh water. Search the surface water headings in the \"Master CLARC Spreadsheet\" tab."]
[null,null,null,null,{"$f":"IF(SW_Ex1_Score=\"D\",\"SKIP\",\nIF(SW_Ex2_Ans=\"menu ▼\",\"\",\n\nIF(OR(SW_Ex2_Ans=\"yes\",SW_Ex2_Ans=\"maybe\"),\"continue\",\nIF(SW_Ex2_Ans=\"no\",\"D\",\"\"))))","v":"SKIP"},null,"► WAC 173-340-730 Surface water cleanup standards"]
[null,null,null,null,null,null,"► CLARC \"Master CLARC Spreadsheet\" Tab (surface water headings)(will download)"]
[null,null,null,null,null,"Y","Available information confirms a surface water contaminant level greater than applicable MTCA cleanup or screening levels."]
[null,null,null,null,null,"M","Any of the following is true."]
[null,null,null,null,null,"•","Testing information isn't available or adequate enough to rule out an impact to surface water."]
[null,null,null,null,null,"•","Testing has not been conducted, and other information is too insufficient to rule out an impact to surface water."]
[null,null,null,null,null,"•","A water sheen water may not be biological in nature, but information isn't available to confirm."]
[null,null,null,null,null,"N","Any one of the following is true."]
[null,null,null,null,null,"•","An impact isn't likely."]
[null,null,null,null,null,"•","A surface water is upgradient/upslope from a contaminated area."]
[null,null,null,null,null,"•","Test results for a sufficient range of suspected chemicals indicate no contaminants at levels greater than applicable MTCA cleanup or screening levels."]
[null,null,"SW_Ex3","Is site surface water used as a drinking water source?","menu ▼",null,"Use Ecology's Water Rights Search mapping tool to find water right permits, certificates, or claims, which can help identify surface water sources used for drinking water."]
[null,null,null,null,{"$f":"IF(SW_Ex1_Score=\"D\",\"SKIP\",\nIF(SW_Ex2_Score=\"D\",\"SKIP\",\nIF(SW_Ex3_Ans=\"menu ▼\",\"\",\n\nIF(SW_Ex3_Ans=\"yes\",\"A\",\nIF(SW_Ex3_Ans=\"maybe\",\"B\",\nIF(SW_Ex3_Ans=\"potential future\",\"C\",\nIF(SW_Ex3_Ans=\"no\",\"D\",\" \")))))))","v":"SKIP"},null,"► Water Rights Search"]
[null,null,null,null,null,null,"See if site surface water is in a drinking water source protection area using DOH SWAP Maps."]
[null,null,null,null,null,null,"► DOH SWAP Maps"]
[null,null,null,null,null,"Y","Either of the following is true."]
[null,null,null,null,null,"•","The site has at least one water right permit, certificate, or claim."]
[null,null,null,null,null,"•","The site is located in a state drinking water source protection area."]
[null,null,null,null,null,"M","The site's surface water is of sufficient quality and quantity that it could be used as a drinking water source but isn't currently."]
[null,null,null,null,null,"PF","Site surface water isn't accessible as a drinking water source but could be in the future."]
[null,null,null,null,null,"N","Either of the following is true."]
[null,null,null,null,null,"•","The site's surface water is not of sufficient quality and quantity to be used as a drinking water source."]
[null,null,null,null,null,"•","People have no access to site surface water."]
[null,null,"SW_Ex4","Is the site accessible for fishing?","menu ▼",null,"Fishing may be conducted in contaminated areas putting fishers at risk of exposure during fishing activities and potentially during consumption of their catch. Identify potential fishing resources and whether they are physically accessible to fishers. Assume all streams and lakes on Puget Sound shorelines are fish-bearing water bodies."]
[null,null,null,null,{"$f":"IF(SW_Ex1_Score=\"D\",\"SKIP\",\nIF(SW_Ex2_Score=\"D\",\"SKIP\",\nIF(SW_Ex4_Ans=\"menu ▼\",\"\",\n\nIF(SW_Ex4_Ans=\"yes\",\"A\",\nIF(SW_Ex4_Ans=\"maybe\",\"B\",\nIF(SW_Ex4_Ans=\"potential future\",\"C\",\nIF(SW_Ex4_Ans=\"no\",\"D\",\" \")))))))","v":"SKIP"},"Y","Fishing resource areas are accessible to people who harvest or eat fish."]
[null,null,null,null,null,"M","Fishing resource areas may be accessible to people who harvest or eat fish, but additional information is needed to confirm."]
[null,null,null,null,null,"PF","Fishing resource areas are not accessible at this time to people who harvest or eat fish, but access could become available in the future."]
[null,null,null,null,null,"N","Fishing resource areas don't exist on site, or such areas are not accessible for fishing."]
[null,null,null,"Exposure score ►",{"$f":"IF(OR(SW_Ex1_Score=\"\",SW_Ex2_Score=\"\",SW_Ex3_Score=\"\",SW_Ex4_Score=\"\"),\"SHARPen it\",\n\nIF(OR(SW_Ex1_Score=\"D\",SW_Ex2_Score=\"D\"),\"D\",\nIF(AND(SW_Ex3_Score=\"D\",SW_Ex4_Score=\"D\"),\"D\",\n\nIF(OR(SW_Ex3_Score=\"A\",SW_Ex4_Score=\"A\"),\"A\",\nIF(OR(SW_Ex3_Score=\"B\",SW_Ex4_Score=\"B\"),\"B\",\nIF(OR(SW_Ex3_Score=\"C\",SW_Ex4_Score=\"C\"),\"C\",\"D\"))))))","v":"D"}]
[]
[null,3,"Severity",null,"Answers/Scores","Tips"]
[null,null,"SW_Sv1","Is a PBT (persistent bioaccumulative toxic) chemical impacting or likely to impact surface water or sediment?","menu ▼",null,"Compare site contaminants with the PBT list in WAC 173-333-310(2)."]
[null,null,null,null,{"$f":"IF(SW_ExScore=\"D\",\"SKIP\",\nIF(SW_Sv1_Ans=\"menu ▼\",\"\",\n\nIF(SW_Sv1_Ans=\"yes\",10,\nIF(SW_Sv1_Ans=\"maybe\",6,\nIF(SW_Sv1_Ans=\"no\",0,\"\")))))","v":"SKIP"},null,"▶ WAC 173-333-310 What chemicals or chemical groups are included on the PBT list?"]
[null,null,null,null,null,"Y","At least one PBT chemical is detected in surface water or sediment."]
[null,null,null,null,null,"M","At least one unconfirmed PBT chemical is suspected in surface water or sediment."]
[null,null,null,null,null,"N","No PBT chemical is detected in site surface water or sediment."]
[null,null,"SW_Sv2","Is there a current impact from any extremely toxic chemical to a marine or freshwater ecological community?","menu ▼",null,"Compare site confirmed or suspected chemicals with those listed as extremely toxic in the ChemTox table under the heading \"Surface Water\"."]
[null,null,null,null,{"$f":"IF(SW_ExScore=\"D\",\"SKIP\",\nIF(OR(SW_Sv1_Score=10,SW_Sv1_Score=6),\"SKIP\",\nIF(SW_Sv2_Ans=\"menu ▼\",\"\",\n\nIF(SW_Sv2_Ans=\"yes\",10,\nIF(SW_Sv2_Ans=\"maybe\",6,\nIF(SW_Sv2_Ans=\"no\",0,\"\"))))))","v":"SKIP"},null,"► ChemTox"]
[null,null,null,null,null,"Y","At least one extremely toxic chemical is detected in a marine or freshwater ecological community in surface water or sediment."]
[null,null,null,null,null,"M","At least one unconfirmed extremely toxic chemical is suspected in surface water or sediment."]
[null,null,null,null,null,"N","No extremely toxic chemical is detected in a freshwater or marine ecological community or in surface water or sediment."]
[null,null,"SW_Sv3","Are any at-risk aquatic species on site at any time of year, or are any impacted by site contamination?","menu ▼",null,"The Washington DFW PHS on the Web maps offer basic information about known locations of biodiversity areas and corridors across Washington. Use the map to create an online \"PHS Identify\" report that includes on-site and nearby priority habitats and species."]
[null,null,null,null,{"$f":"IF(SW_ExScore=\"D\",\"SKIP\",\nIF(SW_Sv3_Ans=\"menu ▼\",\"\",\n\nIF(SW_Sv3_Ans=\"yes\",10,\nIF(SW_Sv3_Ans=\"maybe\",6,\nIF(SW_Sv3_Ans=\"no\",0,\"\")))))","v":"SKIP"},null,"► DFW PHS on the Web"]
[null,null,null,null,null,"Y","At least one at-risk aquatic species is present at the site and is impacted by site contamination."]
[null,null,null,null,null,"M","Either of the following is likely to be true."]
[null,null,null,null,null,"•","An at-risk aquatic species may be impacted, but more information is needed to confirm."]
[null,null,null,null,null,"•","An at-risk aquatic species may access the site at any time of year, but more information is needed to confirm."]
[null,null,null,null,null,"N","It isn't likely or possible for an at-risk aquatic species to be impacted or access the site at any time of the year."]
[null,null,"SW_Sv4","Is site contamination less than 2 miles upstream of a current or suitable surface drinking water source?","menu ▼",null,"Use the DOH Source Water Assessment Program (SWAP) Maps to find information on the locations and quality of vicinity and regional public surface drinking water supplies."]
[null,null,null,null,{"$f":"IF(SW_ExScore=\"D\",\"SKIP\",\nIF(SW_Sv5_Ans=\"menu ▼\",\"\",\n\nIF(SW_Sv5_Ans=\"yes\",10,\nIF(SW_Sv5_Ans=\"maybe\",6,\nIF(SW_Sv5_Ans=\"no\",0,\"\")))))","v":"SKIP"},null,"► DOH SWAP Maps"]
[null,null,null,null,null,"Y","Both of the following are true."]
[null,null,null,null,null,"•","A surface drinking water supply intake is mapped within approximately 2 miles downstream of contamination."]
[null,null,null,null,null,"•","The mapped surface water is of sufficient quality to support a suitable drinking water source."]
[null,null,null,null,null,"M","Either of the following is true."]
[null,null,null,null,null,"•","Potential surface drinking water use is suspected, based solely on the general site setting. "]
[null,null,null,null,null,"•","Downstream surface water is of sufficient quality to support a suitable drinking water source, but information sources don't confirm this."]
[null,null,null,null,null,"N","The site isn't an upland source to a current or suitable drinking water source."]
[null,null,"SW_Sv5","Is the site less than 2 miles upland of an aquatic recreational source?","menu ▼",null,"Recreational activities can occur in or on the water or be enhanced by being close to water, such as hiking, nature viewing, and hunting waterfowl. Use the following link to identify in-water and near-water recreational resources, such as fishing and shellfishing locations; public fishing piers; clam, mussel, and oyster beaches; marine fishing areas; lowland and high lakes; and water access areas."]
[null,null,null,null,{"$f":"IF(SW_ExScore=\"D\",\"SKIP\",\nIF(SW_Sv4_Ans=\"menu ▼\",\"\",\n\nIF(SW_Sv4_Ans=\"yes\",5,\nIF(SW_Sv4_Ans=\"maybe\",3,\nIF(SW_Sv4_Ans=\"no\",0,\"\")))))","v":"SKIP"},null,"► DFW Places to Go"]
[null,null,null,null,null,"Y","The site is within 2 miles upland of a known aquatic recreational source."]
[null,null,null,null,null,"M","The site is within 2 miles upland of a water source that may be used for aquatic recreation, based on the general site setting."]
[null,null,null,null,null,"N","The site isn't within 2 miles upland of a known aquatic recreational source."]
[null,null,null,"Severity score",{"$f":"IF(SW_ExScore=\"D\",\"4\",\nIF(OR(SW_Sv1_Score=\"\",SW_Sv2_Score=\"\",SW_Sv3_Score=\"\",SW_Sv4_Score=\"\",SW_Sv5_Score=\"\"),\"SHARPen it\",\n\nIF(SW_SvQSum>=SW_SvThresh,1,\nIF(SW_SvQSum>=SW_SvThresh*2/3,2,\nIF(SW_SvQSum>=SW_SvThresh/3,3,4)))))","v":"4"}]
[]
[null,4,"Enter comments"]

{"sheet":"SD","index":6,"n_rows":102,"n_cols":7,"rows_kept":102,"cut":false,"hidden":false,"merged":[[2,4,2,5],[4,4,4,5],[2,1,2,3],[102,1,105,6]]}
[]
[]
[null,"Sediment Assessment",null,null,{"$f":"IF(OR(SD_ExScore=\"SHARPen it\",SD_SvScore=\"SHARPen it\",SD_Conf=\"menu ▼\"),\"SHARPen it\",\nCONCATENATE(SD_ExScore,SD_SvScore))","v":"D4"}]
[]
[null,1,"Select confidence level",null,"high"]
[]
[null,2,"Potential Exposure",null,"Answers/Scores",null,"Tips"]
[null,null,"SD_Ex1","Is sediment on site?","menu ▼",null,"Sediment can exist only if surface water conditions exist. Sediment accumulates when particulate matter settles at or below the ordinary high water mark, where surface water is present for a minimum of six consecutive weeks annually."]
[null,null,null,null,{"$f":"IF(SW_Ex1_Score=\"D\", \"D\",\nIF(SD_Ex1_Ans=\"menu ▼\",\"\",\n\nIF(OR(SD_Ex1_Ans=\"yes\",SD_Ex1_Ans=\"maybe\"),\"continue\",\nIF(SD_Ex1_Ans=\"no\",\"D\",\"\"))))","v":"D"},"Y","Sediment is in an on-site or adjacent area."]
[null,null,null,null,null,"M","Sediment may be in an on-site or adjacent area, but more information is needed to confirm."]
[null,null,null,null,null,"N","Sediment isn't observed on site or adjacent to the site."]
[null,null,"SD_Ex2","Does a sediment contaminant concentration exceed either a sediment cleanup objective or cleanup screening level for chemistry?","menu ▼",null,"Identify whether a site contaminant concentration exceeds a criterion for either a sediment cleanup objective (SCO) or a cleanup screening level (CSL) for chemistry in the Sediment Cleanup User’s Manual (SCUM)."]
[null,null,null,null,{"$f":"IF(SD_Ex1_Score=\"D\",\"SKIP\",\nIF(SD_Ex2_Ans=\"menu ▼\",\"\",\n\nIF(SD_Ex2_Ans=\"yes\",\"A\",\nIF(SD_Ex2_Ans=\"maybe\",\"B\",\nIF(SD_Ex2_Ans=\"no\",\"D\",\"\")))))","v":"SKIP"},null,"► see SCUM Table 8-1, p. 8-8"]
[null,null,null,null,null,"Y","Testing results indicate a contaminant concentration exceeds at least one criterion."]
[null,null,null,null,null,"M","Testing results aren't available or adequate enough to rule out exceeding at least one criterion."]
[null,null,null,null,null,"N","Testing results are adequate for screening and indicate no exceedance of a listed SCO or CSL."]
[null,null,"SD_Ex3","Does a biological test result exceed an  SCO, CSL, or performance standard for marine or freshwater criteria?","menu ▼",null,"Adverse effects are defined when any biological test result for an SCO, CSL, or performance standard is exceeded for marine or freshwater chemistry. See the following tables in the Sediment Cleanup User’s Manual (SCUM)."]
[null,null,null,null,{"$f":"IF(SD_Ex1_Score=\"D\",\"SKIP\",\nIF(SD_Ex3_Ans=\"menu ▼\",\"\",\n\nIF(SD_Ex3_Ans=\"yes\",\"A\",\nIF(SD_Ex3_Ans=\"maybe\",\"B\",\nIF(SD_Ex3_Ans=\"no\",\"D\",\"\")))))","v":"SKIP"},null,"► see SCUM Table 8-2, p. 8-11, & Table 8-4, p. 8-14"]
[null,null,null,null,null,"Y","At least one biological test result exceeds a listed SCO, CSL, or performance standard in either SCUM Table 8-2 or 8-4."]
[null,null,null,null,null,"M","Either of the following is true."]
[null,null,null,null,null,"•","Bioassay testing has been performed, but the quality or quantity of the data is insufficient to rule out an impact."]
[null,null,null,null,null,"•","Bioassay testing has not been performed, but an impact is suspected."]
[null,null,null,null,null,"N","Testing results indicate no biological criterion is exceeded in either table."]
[null,null,"SD_Ex4","Is there an impact to sediment from an on-site upland source that needs cleanup action?","menu ▼",null,"Upland sediment sources could include various land uses and cover types, such as forest, cropland, pasture, construction sites, or roads. Natural and unnatural activities and processes occurring at these upland locations can impact a downslope or downgradient site."]
[null,null,null,null,{"$f":"IF(SD_Ex1_Score=\"D\",\"SKIP\",\nIF(AND(SD_Ex2_Ans=\"no\", SD_Ex3_Ans=\"no\"),\"SKIP\",\n\nIF(SD_Ex4_Ans=\"menu ▼\",\"\",\n\nIF(SD_Ex4_Ans=\"yes\",\"A\",\nIF(SD_Ex4_Ans=\"maybe\",\"B\",\nIF(SD_Ex4_Ans=\"potential future\",\"C\",\nIF(SD_Ex4_Ans=\"no\",\"D\",\"\")))))))","v":"SKIP"},"Y","Field observation or testing results confirm site sediment is impacted from an on-site upland source."]
[null,null,null,null,null,"M","Any of the following is true."]
[null,null,null,null,null,"•","Testing has been conducted, but results are unavailable, inadequate, or too limited to rule out an impact."]
[null,null,null,null,null,"•","Too few samples have been tested to rule out a sediment impact."]
[null,null,null,null,null,"•","An oil-like sheen is visible on site sediment, or LNAPL or DNAPL has been identified in surface water or in nearby soil or groundwater."]
[null,null,null,null,null,"•","Contaminated surface water may pose a risk to site sediment, and relevant information isn't available to exclude a sediment concern."]
[null,null,null,null,null,"PF","A timely cleanup of an upland portion of the site sediment isn't scheduled for imminent action or currently underway, leaving site sediment vulnerable to a potential future impact."]
[null,null,null,null,null,"N","Site information confirms that site sediment isn't impacted by an on-site upland source."]
[null,null,"SD_Ex5","Is there an impact to sediment from an off-site upland source - either historically or currently?","menu ▼",null,"Contamination sources might include groundwater, surface water, permitted and unpermitted discharges, spills, bank erosion, or other sources. Identify information about historical and remaining sources and transport pathways to sediment from off-site upland sources and releases. Use upland remedial investigation information to see if the transport pathways are complete or controlled."]
[null,null,null,null,{"$f":"IF(SD_Ex1_Score=\"D\",\"SKIP\",\nIF(AND(SD_Ex2_Ans=\"no\",SD_Ex3_Ans=\"no\"),\"SKIP\",\nIF(SD_Ex5_Ans=\"menu ▼\",\"\",\n\nIF(SD_Ex5_Ans=\"yes\",\"B\",\nIF(SD_Ex5_Ans=\"maybe\",\"B\",\nIF(SD_Ex5_Ans=\"potential future\",\"C\",\nIF(SD_Ex5_Ans=\"no\",\"D\",\"\")))))))","v":"SKIP"},"Y","Current or historical impacts to sediment are confirmed from an off-site upland source."]
[null,null,null,null,null,"M","Any of the following is true."]
[null,null,null,null,null,"•","Upgradient groundwater contamination is known or suspected."]
[null,null,null,null,null,"•","Bioassay testing information is unavailable or inadequate enough to rule out a sediment impact from an off-site upland source."]
[null,null,null,null,null,"•","An unnatural oil-like sheen is observed on site surface water or nearby soil, or in groundwater from a suspected off-site upland source."]
[null,null,null,null,null,"•","An off-site upland site storm water or wastewater outfall discharges, or has historically discharged to, site surface water."]
[null,null,null,null,null,"•","An upland site has or had overwater activities (e.g., loading dock) that could impact site sediment."]
[null,null,null,null,null,"•","Wood waste is, or has historically been observed, in site sediment (beach, intertidal, or subtidal areas)."]
[null,null,null,null,null,"•","Site surface water is contaminated from an off-site upland source."]
[null,null,null,null,null,"PF","Site sediment currently is not impacted from a known off-site upland source but could become impacted in the future."]
[null,null,null,null,null,"N","No off-site upland source has impacted, or has the potential to impact, site sediment."]
[null,null,null,"Exposure score ►",{"$f":"IF(OR(SD_Ex1_Score=\"\",SD_Ex4_Score=\"\",SD_Ex2_Score=\"\",SD_Ex3_Score=\"\",SD_Ex5_Score=\"\"),\"SHARPen it\",\nIF(SD_Ex1_Score=\"D\",\"D\",\nIF(AND(SD_Ex2_Score=\"D\",SD_Ex3_Score=\"D\"),\"D\",\n\nIF(OR(SD_Ex2_Score=\"A\",SD_Ex3_Score=\"A\"),\"A\",\nIF(OR(SD_Ex2_Score=\"B\",SD_Ex3_Score=\"B\"),\"B\",\n\nIF(AND(SD_Ex2_Score=\"D\",SD_Ex3_Score=\"D\",OR(SD_Ex4_Score=\"A\",SD_Ex5_Score=\"A\",SD_Ex4_Score=\"B\",SD_Ex5_Score=\"B\",SD_Ex4_Score=\"C\",SD_Ex5_Score=\"C\")),\"C\",\"\"))))))","v":"D"}]
[]
[null,3,"Severity",null,"Answers/Scores",null,"Tips"]
[null,null,"SD_Sv1","Does any portion of the site area overlay a 303(d)-listed waterbody in Category 2, 3, 4a, 4b, or 5?","menu ▼",null,"Ecology conducts water quality assessments in streams, lakes, and marine waters. Use Ecology's Water Quality Atlas Map to find information to answer this question."]
[null,null,null,null,{"$f":"IF(SD_ExScore=\"D\",\"SKIP\",\nIF(SD_Sv1_Ans=\"menu ▼\",\"\",\n\nIF(SD_Sv1_Ans=\"yes\",5,\nIF(SD_Sv1_Ans=\"maybe\",3,\nIF(SD_Sv1_Ans=\"no\",0,\"\")))))","v":"SKIP"},null,"► Water Quality Atlas Map"]
[null,null,null,null,null,"Y","At least a portion of the site is mapped within a 303(d)-listed water body."]
[null,null,null,null,null,"M","The site is adjacent to a 303(d)-listed water body, or its estimated boundary intercepts a 303(d)-listed water body."]
[null,null,null,null,null,"N","No portion of the site is mapped in or adjacent to a 303(d)-listed water body."]
[null,null,"SD_Sv2","Are any PBTs in site sediment?","menu ▼",null,"Compare contaminants identified in site sediment with chemicals listed in WAC 173-333-310[2] PBT list. Chemical source areas could include upland soil and upgradient groundwater."]
[null,null,null,null,{"$f":"IF(SD_ExScore=\"D\",\"SKIP\",\nIF(SD_Sv2_Ans=\"menu ▼\",\"\",\n\nIF(OR(SD_Sv2_Ans=\"yes\",SD_Sv2_Ans=\"maybe\"),\"continue\",\nIF(SD_Sv2_Ans=\"no\",0,\"\"))))","v":"SKIP"},null,"▶ WAC 173-333-310. What chemicals or chemical groups are included on the PBT list?"]
[null,null,null,null,null,"Y","At least one Washington-listed PBT is confirmed in sediment."]
[null,null,null,null,null,"M","Testing results aren't available, and a PBT source is known but not confirmed in upland soil or groundwater."]
[null,null,null,null,null,"N","Sufficient information has been collected to show no PBT is present in sediment or an upland soil or groundwater source area."]
[null,null,"SD_Sv3","Is any PBT concentration in sediment greater than any listed in SCUM Tables 10-1 or 11-1?","menu ▼",null,"Compare site sediment contaminants with those listed in the following sources."]
[null,null,null,null,{"$f":"IF(SD_ExScore=\"D\",\"SKIP\",\nIF(SD_Sv3_Ans=\"menu ▼\",\"\",\n\nIF(SD_Sv3_Ans=\"yes\",10,\nIF(SD_Sv3_Ans=\"maybe\",6,\nIF(SD_Sv3_Ans=\"no\",0,\"\")))))","v":"SKIP"},null,"► see SCUM Table 10-1, p 10-21 and Table 11-1, p 11-6"]
[null,null,null,null,null,"Y","At least one PBT concentration in sediment exceeds any criterion listed in either table, based on sufficient testing results."]
[null,null,null,null,null,"M","At least one PBT concentration in sediment likely exceeds any criterion listed in either table, but more information is needed to confirm."]
[null,null,null,null,null,"N","No PBT concentration in sediment exceeds the criteria in either table, based on sufficient information to rule out the presence of any PBT chemical."]
[null,null,"SD_Sv4","Does or has the site historically supported shellfish?","menu ▼",null,"Any marine bay or inlet likely has supported shellfish. Further, any river or any area on the Puget Sound  is considered a shellfishing source. For more information on mapped shellfish habitat locations, see the following information sources."]
[null,null,null,null,{"$f":"IF(SD_ExScore=\"D\",\"SKIP\",\nIF(SD_Sv4_Ans=\"menu ▼\",\"\",\n\nIF(OR(SD_Sv4_Ans=\"yes\",SD_Sv4_Ans=\"maybe\"),5,\nIF(SD_Sv4_Ans=\"no\",0,\"\"))))","v":"SKIP"},null,"► DFW Commercial wild stock geoduck clam fishery"]
[null,null,null,null,null,null,"► DOH Commercial Shellfish Map Viewer"]
[null,null,null,null,null,null,"► DOH Shellfish Safety Information"]
[null,null,null,null,null,null,"► DFW PHS on the Web"]
[null,null,null,null,null,"Y","Any of the following is true."]
[null,null,null,null,null,"•","Shellfish are observed at the site."]
[null,null,null,null,null,"•","The site is located on a shoreline of the Puget Sound or any shoreline of a stream."]
[null,null,null,null,null,"•","The site historically has supported shellfish habitat."]
[null,null,null,null,null,"M","Shellfish may have inhabited the site based on historical knowledge (e.g., tribal oral history) or could be supported after restoration."]
[null,null,null,null,null,"N","Either of the following is true."]
[null,null,null,null,null,"•","The site isn't located on a Puget Sound shoreline or on a shoreline of any stream."]
[null,null,null,null,null,"•","No shellfish are present at the site, and shellfish habitat cannot be supported."]
[null,null,"SD_Sv5","Is the site accessible for fishing?","menu ▼",null,"Fishing may be conducted in contaminated areas putting fishers at risk of exposure during fishing activities and potentially during consumption of their catch. Identify potential fishing resources and whether they are physically accessible to fishers. Assume shoreline areas of the Puget Sound are considered to to support fish-bearing habitat."]
[null,null,null,null,{"$f":"IF(SD_ExScore=\"D\",\"SKIP\",\nIF(SD_Sv5_Ans=\"menu ▼\",\"\",\n\nIF(SD_Sv5_Ans=\"yes\",5,\nIF(SD_Sv5_Ans=\"maybe\",3,\nIF(SD_Sv5_Ans=\"no\",0,\"\")))))","v":"SKIP"},"Y","Fishing resource areas are accessible to people who harvest or eat fish."]
[null,null,null,null,null,"M","Fishing resource areas may be accessible to people who harvest or eat fish."]
[null,null,null,null,null,"N","Fishing resource areas don't exist on site, or such areas are not accessible for fishing."]
[null,null,"SD_Sv6","Is the site in an area that supports a sensitive or critical habitat?","menu ▼",null,"On-site habitat indicators might include eelgrass, shellfish, herring, forage fish, salmonids, spawning habitat, shorebirds, marine mammals, or endangered or threatened species. Access information about these habitat indicators from the following online resources."]
[null,null,null,null,{"$f":"IF(SD_ExScore=\"D\",\"SKIP\",\nIF(SD_Sv6_Ans=\"menu ▼\",\"\",\n\nIF(SD_Sv6_Ans=\"yes\",5,\nIF(SD_Sv6_Ans=\"maybe\",3,\nIF(SD_Sv6_Ans=\"no\",0,\"\")))))","v":"SKIP"},null,"General priority habitat and species:"]
[null,null,null,null,null,null,"► DFW PHS on the Web"]
[null,null,null,null,null,null,"Critical habitat (National Oceanic and Atmospheric Administration; NOAA):"]
[null,null,null,null,null,null,"► NOAA National NMFS ESA Critical Habitat Mapper"]
[null,null,null,null,null,null,"Seagrass (Department of Natural Resources, DNR):"]
[null,null,null,null,null,null,"►DNR Puget Sound Eelgrass Monitoring Data Viewer"]
[null,null,null,null,null,null,"►DNR Nearshore Habitat Biotic Community Monitoring"]
[null,null,null,null,null,null,"►DNR Nearshore Habitat Inventory"]
[null,null,null,null,null,null,"Shellfish:"]
[null,null,null,null,null,null,"► DFW Public clam, mussel, and oyster beaches"]
[null,null,null,null,null,null,"► DFW Commercial wild stock geoduck clam fishery"]
[null,null,null,null,null,null,"► DFW State Listed Species"]
[null,null,null,null,null,null,"► DOH Commercial Shellfish Map Viewer"]
[null,null,null,null,null,null,"► DOH Shellfish Safety Information"]
[null,null,null,null,null,null,"Forage fish:"]
[null,null,null,null,null,null,"►DFW Coastal Intertidal Forage Fish Spawning Surveys"]
[null,null,null,null,null,"Y","Relevant information confirms at least one sensitive or critical habitat indicator is on site."]
[null,null,null,null,null,"M","Relevant information isn't available, but at least one sensitive or critical habitat indicator may be on site."]
[null,null,null,null,null,"N","Relevant information confirms no sensitive or critical habitat indicator is on site."]
[null,null,null,"Severity score",{"$f":"IF(SD_ExScore=\"D\",\"4\",\nIF(OR(SD_Sv1_Score=\"\",SD_Sv2_Score=\"\",SD_Sv3_Score=\"\",SD_Sv4_Score=\"\",SD_Sv5_Score=\"\",SD_Sv6_Score=\"\"),\"SHARPen it\",\n\nIF(SD_SvQSum>=SD_SvThresh,1,\nIF(SD_SvQSum>=SD_SvThresh*2/3,2,\nIF(SD_SvQSum>=SD_SvThresh/3,3,4)))))","v":"4"}]
[]
[null,4,"Enter comments"]

{"sheet":"IA","index":7,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[2,4,2,5],[4,4,4,5],[2,1,2,3],[76,1,80,6]]}
[]
[]
[null,"Indoor Air Assessment",null,null,{"$f":"IF(OR(IA_ExScore=\"SHARPen it\",IA_SvScore=\"SHARPen it\",IA_Conf=\"menu ▼\"),\"SHARPen it\",\nCONCATENATE(IA_ExScore,IA_SvScore))","v":"D4"}]
[]
[null,1,"Select confidence level",null,"medium"]
[]
[null,2,"Potential Exposure",null,"Answers/Scores",null,"Tips"]
[null,null,"IA_Ex1","Is there an impact to indoor air that needs cleanup action, where indoor and outdoor ambient sources have been ruled out?","no",null,"The indoor air point of compliance is throughout the site (WAC 173-340-750[6]). If screening levels are established, they may be cleanup levels or conservative values applied during an investigation such as Method B values protective of unrestricted land use. The ChemTox table lists volatiles that have CLARC screening levels for individual volatiles under both Methods B and C and for workers. To identify volatiles, look at chemicals marked as \"yes\" in the ChemTox table under the heading \"Possible Vapor Intrusion”."]
[null,null,null,null,{"$f":"IF(IA_Ex1_Ans=\"menu ▼\",\"\",\n\nIF(IA_Ex1_Ans=\"yes\",\"A\",\nIF(IA_Ex1_Ans=\"maybe\",\"B\",\nIF(IA_Ex1_Ans=\"no\",\"D\",\"\"))))","v":"D"},null,"► WAC 173-340-750 Cleanup standards to protect air quality"]
[null,null,null,null,null,null,"► ChemTox"]
[null,null,null,null,null,null,"See the following guidance for additional information."]
[null,null,null,null,null,null,"► CLARC \"Vapor Intrusion Method B\" Tab (will download)"]
[null,null,null,null,null,null,"► CLARC \"Vapor Intrusion Method C\" Tab"]
[null,null,null,null,null,null,"► CLARC \"Vapor Intrusion Worker\" Tab"]
[null,null,null,null,null,null,"► Guidance for Evaluating Soil Vapor Intrusion in Washington State, Investigation and Remedial Action"]
[null,null,null,null,null,"Y","Testing information confirms at least one volatile vapor level exceeds a screening level for indoor air."]
[null,null,null,null,null,"M","Any of the following is true."]
[null,null,null,null,null,"•","Testing information is available, and at least one volatile vapor level exceeds screening levels, but ambient air or products in the building cannot be excluded as the source."]
[null,null,null,null,null,"•","Subsurface media concentrations exceed vapor intrusion screening levels, but indoor air has not yet been sampled."]
[null,null,null,null,null,"•","Testing information isn't available, but an unnatural odor is noted by occupants."]
[null,null,null,null,null,"N","Testing information confirms no volatile vapor level exceeds a screening level for indoor air."]
[null,null,"IA_Ex2","Are volatile petroleum chemical vapor levels greater than applicable soil vapor screening levels for soil, groundwater, or soil vapor?","menu ▼",null,"Volatile petroleum indicator chemicals include: benzene, toluene, ethylbenzene, and xylenes; ethylene dibromide; 1,2-dichloroethene; hexane; MTBE; and naphthalene. Default soil vapor screening distances for any of these chemicals are: 1) within 30 lateral feet of a building; or 2) within 15 vertical feet below a building's lowest point (e.g., crawl space or basement). Otherwise, site-specific vapor screening distances can be used, if established. Also, CLARC lists subsurface media screening levels protective of indoor air (Method B chemicals). See CLARC screening levels for subsurface media protective of indoor air. Also, see Ecology guidance for more information."]
[null,null,null,null,{"$f":"IF(OR(IA_Ex1_Score=\"D\"),\"SKIP\",\nIF(IA_Ex2_Ans=\"menu ▼\",\"\",\n\nIF(IA_Ex2_Ans=\"yes\",\"B\",\nIF(IA_Ex2_Ans=\"maybe\",\"B\",\nIF(IA_Ex2_Ans=\"no\",\"D\",\"\")))))","v":"SKIP"},null,"► CLARC \"Vapor Intrusion Method B\" Tab"]
[null,null,null,null,null,null,"► Guidance for Evaluating Soil Vapor Intrusion in Washington State, Investigation and Remedial Action"]
[null,null,null,null,null,"Y","Both of the following are true."]
[null,null,null,null,null,"•","At least one volatile petroleum chemical is in soil or groundwater within either default  screening distance or a site-specific screening distance."]
[null,null,null,null,null,"•","At least one volatile petroleum chemical level exceeds applicable soil vapor screening levels within either screening distance."]
[null,null,null,null,null,"M","Both of the following are true."]
[null,null,null,null,null,"•","At least one volatile petroleum chemical may be within a screening distance, but more information is needed to confirm."]
[null,null,null,null,null,"•","Volatile petroleum chemical levels within a screening distance may exceed applicable soil vapor screening levels, but more information is needed to confirm."]
[null,null,null,null,null,"N","Either of the following is true."]
[null,null,null,null,null,"•","Volatile petroleum chemicals aren't present within any screening distance."]
[null,null,null,null,null,"•","If present within any screening distance, volatile petroleum chemical levels do not exceed soil vapor screening levels."]
[null,null,"IA_Ex3","Are volatile non-petroleum chemical vapor levels greater than soil vapor screening levels in soil, groundwater, or soil vapor?","menu ▼",null,"Default vapor screening distances for volatile non-petroleum chemicals are within 100 lateral feet of a building or any vertical depth below a building's lowest point. Otherwise, site-specific vapor screening distances can be used, if established. Also, CLARC lists subsurface media screening levels protective of indoor air. See Ecology guidance for more information."]
[null,null,null,null,{"$f":"IF(OR(IA_Ex1_Score=\"D\"),\"SKIP\",\nIF(IA_Ex3_Ans=\"menu ▼\",\"\",\n\nIF(IA_Ex3_Ans=\"yes\",\"B\",\nIF(IA_Ex3_Ans=\"maybe\",\"B\",\nIF(IA_Ex3_Ans=\"no\",\"D\",\"\")))))","v":"SKIP"}]
[null,null,null,null,null,null,"► CLARC \"Vapor Intrusion Method B\" Tab"]
[null,null,null,null,null,null,"► Guidance for Evaluating Soil Vapor Intrusion in Washington State, Investigation and Remedial Action"]
[null,null,null,null,null,"Y","Both of the following are true."]
[null,null,null,null,null,"•","At least one volatile non-petroleum chemical is in soil or groundwater within either default  screening distance or a site-specific screening distance."]
[null,null,null,null,null,"•","At least one volatile non-petroleum chemical level exceeds applicable soil vapor screening levels within either screening distance."]
[null,null,null,null,null,"M","Both of the following are true."]
[null,null,null,null,null,"•","At least one volatile non-petroleum chemical may be within a screening distance, but more information is needed to confirm."]
[null,null,null,null,null,"•","Volatile non-petroleum chemical levels within a screening distances may exceed applicable soil vapor screening levels, but more information is needed to confirm."]
[null,null,null,null,null,"N","Either of the following is true."]
[null,null,null,null,null,"•","Volatile non-petroleum chemicals aren't present within any screening distance."]
[null,null,null,null,null,"•","If present within any screening distance, volatile non-petroleum chemical levels do not exceed soil vapor screening levels."]
[null,null,"IA_Ex4","Is vapor intrusion being limited by mitigation measures?","menu ▼",null,"Example mitigation measures might include HVAC system adjustments, sub-slab depressurization systems, and vapor barriers."]
[null,null,null,null,{"$f":"IF(IA_Ex1_Score=\"D\",\"SKIP\",\nIF(AND(IA_Ex2_Score=\"D\",IA_Ex3_Score=\"D\"),\"SKIP\",\nIF(IA_Ex4_Ans=\"menu ▼\",\"\",\n\nIF(IA_Ex4_Ans=\"yes\",\"C\",\nIF(IA_Ex4_Ans=\"maybe\",\"B\",\nIF(IA_Ex4_Ans=\"no\",\"A\",\"\"))))))","v":"SKIP"},"Y","A mitigation measure or system operates such that, if compromised or turned off, an exposure could be reactivated."]
[null,null,null,null,null,"M","More information is needed to confirm a mitigation measure or system is in place and effectively operating as intended."]
[null,null,null,null,null,"N","No mitigation measure or system is in place or operation."]
[null,null,null,"Exposure score ►",{"$f":"IF(OR(IA_Ex1_Score=\"\",IA_Ex2_Score=\"\",IA_Ex3_Score=\"\",IA_Ex4_Score=\"\"),\"SHARPen it\",\n\nIF(IA_Ex1_Score=\"D\",\"D\",\nIF(AND(IA_Ex2_Score=\"D\",IA_Ex3_Score=\"D\"),\"D\",\n\nIF(IA_Ex4_Score=\"A\",\"A\",\nIF(IA_Ex4_Score=\"B\",\"B\",\nIF(IA_Ex4_Score=\"C\",\"C\",\"\"))))))","v":"D"}]
[]
[null,3,"Severity",null,"Answers/Scores","Tips"]
[null,null,"IA_Sv1","Is any extremely toxic volatile chemical in soil vapor or indoor air?","menu ▼",null,"Compare confirmed or suspected volatile chemicals in indoor air that are: 1) marked as \"yes\" in the ChemTox table under the heading \"Possible Vapor Intrusion\"; and 2) identified as \"extremely\" under the heading \"Soil, Groundwater, Air\"."]
[null,null,null,null,{"$f":"IF(IA_ExScore=\"D\",\"SKIP\",\nIF(IA_Sv1_Ans=\"menu ▼\",\"\",\n\nIF(IA_Sv1_Ans=\"yes\",10,\nIF(IA_Sv1_Ans=\"maybe\",6,\nIF(IA_Sv1_Ans=\"no\",0,\"\")))))","v":"SKIP"},null,"► ChemTox"]
[null,null,null,null,null,"Y","Any site volatile chemical is listed as extremely toxic in the ChemTox table."]
[null,null,null,null,null,"M","Any chemical in indoor air may be listed as extremely toxic in the ChemTox table, but analytical data are not available to confirm."]
[null,null,null,null,null,"N","No site volatile chemical is listed as extremely toxic in the ChemTox table."]
[null,null,"IA_Sv2","Is any very toxic volatile chemical  in soil vapor or indoor air?","menu ▼",null,"Compare confirmed or suspected volatile chemicals in indoor air that are: 1) marked as \"yes\" in the ChemTox table under the heading \"Possible Vapor Intrusion\"; and 2) identified as \"very\" under the heading \"Soil, Groundwater, Air\"."]
[null,null,null,null,{"$f":"IF(IA_ExScore=\"D\",\"SKIP\",\nIF(OR(IA_Sv1_Score=15,IA_Sv1_Score=10,IA_Sv1_Score=6),\"SKIP\",\nIF(IA_Sv2_Ans=\"menu ▼\",\"\",\n\nIF(IA_Sv2_Ans=\"yes\",5,\nIF(IA_Sv2_Ans=\"maybe\",3,\nIF(IA_Sv2_Ans=\"no\",0,\"\"))))))","v":"SKIP"},null,"► ChemTox"]
[null,null,null,null,null,"Y","Any site volatile chemical is listed as very toxic in the ChemTox table."]
[null,null,null,null,null,"M","Any chemical in indoor air may be listed as very toxic in the ChemTox table, but analytical data are not available to confirm."]
[null,null,null,null,null,"N","No site volatile chemical is listed as very toxic in the ChemTox table."]
[null,null,"IA_Sv3","Are children or women of child-bearing age present in a potentially impacted building for extended periods of time?","menu ▼",null,"When considering possible affects of contaminated indoor air: 1) children are people from 0 up to 6 years old; and 2) women of childbearing age are approximately 13 to 50 years old. Children and women of childbearing age who may reside, work, or be a long-term guest or regular visitor (e.g., nanny) are more sensitive to indoor air contamination than other people. An exposure could recur, if an on-site, operating mitigation system is later turned off. Consider the likelihood of an elementary or middle school population when answering. This is especially important for trichloroethene vapor in indoor air."]
[null,null,null,null,{"$f":"IF(IA_ExScore=\"D\",\"SKIP\",\nIF(IA_Sv3_Ans=\"menu ▼\",\"\",\n\nIF(IA_Sv3_Ans=\"yes\",5,\nIF(IA_Sv3_Ans=\"maybe\",3,\nIF(IA_Sv3_Ans=\"no\",0,\"\")))))","v":"SKIP"},"Y","Children and women of child-bearing age likely occupy a potentially impacted building for extended periods of time."]
[null,null,null,null,null,"M","Either of the following is true."]
[null,null,null,null,null,"•","Building occupancy populations or uses are unknown."]
[null,null,null,null,null,"•","A vapor plume is expanding or suspected to be expanding in the direction of a building occupied or used by children and women of child-bearing age."]
[null,null,null,null,null,"N","Site buildings can't be occupied because of reasons such as inhabitability, condemnation, or blocked entry."]
[null,null,null,"Severity score",{"$f":"IF(IA_ExScore=\"D\",\"4\",\nIF(OR(IA_Sv1_Score=\"\",IA_Sv2_Score=\"\",IA_Sv3_Score=\"\"),\"SHARPen it\",\n\nIF(IA_SvQSum>=IA_SvThresh,1,\nIF(IA_SvQSum>=IA_SvThresh*2/3,2,\nIF(IA_SvQSum>=IA_SvThresh/3,3,4)))))","v":"4"}]
[]
[null,4,"Enter comments"]

{"sheet":"AF","index":8,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,5],[37,1,43,6]]}
[]
[]
[null,{"$f":"IF(OR(AF_1Ans=\"menu ▼\",AF_2Ans=\"menu ▼\",AF_3Ans=\"menu ▼\",AF_4Ans=\"menu ▼\"),\"Additional Factors (SHARPen it)\",\n\nIF(OR(AF_1Ans=\"yes\",AF_1Ans=\"maybe\",AF_2Ans=\"yes\",AF_2Ans=\"maybe\",AF_3Ans=\"yes\",AF_3Ans=\"maybe\",AF_4Ans=\"yes\",AF_4Ans=\"maybe\"),\"Additional Factors identified\",\"Additional Factors\"))","v":"Additional Factors identified"}]
[]
[null,1,"Additional factor questions",null," Answers",null,"Tips"]
[null,null,"AF_1","Multi-chemical types:  \nDoes the site have a screening or cleanup standard exceedance of multiple chemical types where cumulative or synergistic effects are a concern?","no",null,"Potential cumulative or synergistic effects of multiple types of chemicals can be important factors during cleanup planning. These factors may not be directly related to specific exposure media or contact pathways and can include various chemical data groups. Filter chemical groups under the \"Chemical Data Group\" heading in CLARC's \"Master CLARC Spreadsheet\" tab. Common examples: carcinogenic polyaromatic hydrocarbons, herbicides, metals, polycarbonate biphenyls, pesticides, petroleum, volatile organic compounds, semi-volatile organic compounds, and others."]
[null,null,null,null,null,null,"► CLARC \"Master CLARC Spreadsheet\" Tab (will download)"]
[null,null,null,null,null,"Y","Applicable multiple-chemical-type MTCA cleanup or screening levels are exceeded."]
[null,null,null,null,null,"M","Applicable multiple-chemical-type MTCA cleanup or screening levels may be exceeded, but relevant information is needed to confirm."]
[null,null,null,null,null,"N","No applicable multiple-chemical-type MTCA cleanup or screening levels are exceeded."]
[null,null,"AF_2","Risks to off-site people:  \nAre people and other living things off-site at risk of exposure?","maybe",null,"People and other living things can be at risk off site from contamination that has moved, or been moved, from the site to other areas, such as through \"downwinder\" exposures. Examples might include effluent or discharges from storm sewer systems, mining operations, manufacturing, or the Hanford Site. Consider whether off-site exposures might have occurred or are occurring from sources."]
[null,null,null,null,null,"Y","People off site are at risk of exposure from site contamination."]
[null,null,null,null,null,"M","An off-site exposure isn't confirmed but is likely."]
[null,null,null,null,null,"N","Off-site exposures are unlikely."]
[null,null,"AF_3","Climate change impacts:  \nIs the site vulnerable to any high-threat climate change factor?","no",null,"Sites may be vulnerable to high-threat climate change impacts such as wildfire, flooding, landslide, and sea level rise. The level of threat can depend on the type of site (e.g., landfill, mine, etc.), media impacted (i.e., groundwater, sediment, soil), type of cleanup remedy (e.g., cap, treatment, etc.), and location. The vulnerability to climate change impacts increases for sites in specific locations, such as the following."]
[null,null,null,null,null,"•","Flooding for sites located in either of the following."]
[null,null,null,null,null,null,"- in a floodplain"]
[null,null,null,null,null,null,"- along or near a water body (i.e., marine shoreline, lake, creek, or river - notably one fed by snow melt)"]
[null,null,null,null,null,"•","Sea level rise for sites located along or near: 1) a marine shoreline; or 2) a tidally influenced stream or river."]
[null,null,null,null,null,"•","Wildfire for sites located in or near a grassland or forested area."]
[null,null,null,null,null,"•","Landslide for sites located in any of the following."]
[null,null,null,null,null,null,"- in or near an area of past landslides"]
[null,null,null,null,null,null,"- in or near a steep area that recently experienced wildfire"]
[null,null,null,null,null,null,"- atop an erosion-prone bluff"]
[null,null,null,null,null,null,"For more information on potential vulnerabilities, see these Ecology references."]
[null,null,null,null,null,null,"► Sustainable Remediation: Climate Change Resiliency and Green Remediation"]
[null,null,null,null,null,null,"Read about potential vulnerabilities in chapter 3."]
[null,null,null,null,null,null,"► TCP Maps"]
[null,null,null,null,null,null,"See the climate change layers to visualize potential vulnerabilities."]
[null,null,null,null,null,"Y","The site may be vulnerable to climate change impacts."]
[null,null,null,null,null,"M","The site may be vulnerable to climate change impacts, but not enough relevant information is available to confirm."]
[null,null,null,null,null,"N","The site isn't likely to be vulnerable to climate change impacts."]
[null,null,"AF_4","Plant and animal tissue: \nIs relevant testing information available that reports contaminant concentrations in plant or animal tissue from or near the site?","no",null,"While testing information for plant and animal tissue is rare or often unavailable, such information is useful for assessing potential risks to people and other living things that consume plants and animals as food sources in the area."]
[null,null,null,null,null,"Y","Testing information is available."]
[null,null,null,null,null,"N","Testing information isn't available."]
[]
[null,2,"Enter comments"]

{"sheet":"Part1","index":9,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[[23,2,27,10],[29,2,33,10],[58,2,62,10],[64,2,68,10],[70,2,103,10],[35,2,39,10],[41,2,44,10],[46,2,50,10],[52,2,56,10]]}
[]
[]
[null,null,{"$f":"IF(SiteName=\"\",\"Site Name = SHARPen it\",SiteName)","v":"CHS Sun Basin Petroleum Facility Diesel Release"}]
[null,null,"SHARP Report — Part 1 of 2"]
[null,null,{"$f":"IF(XAssess=\"menu ▼\",\"• Assessment incomplete. SHARPen it.\",\nIF(XAssess=\"first assessment\",\"• SHARP first assessment\",\nIF(XAssess=\"re-assessment\",\"• SHARP re-assessment results\")))","v":"• SHARP first assessment"},null,null,null,null,{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"This section is blank if this is a SHARP first assessment\",\nIF(XAssess=\"re-assessment\",\"♦ Historic SHARP first assessment results\",\"\"))","v":"This section is blank if this is a SHARP first assessment"}]
[null,null," • SHARP Tool Version",null,null,{"$f":"SHARPVersionCurrent","v":"v2024.02.20"},null,{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",\" ♦ SHARP Tool version\")","v":""},{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",FirstSHARPVersion)","v":""}]
[null,null," • SHARP rating",null,null,{"$f":"IF(SHARPRating=\"SHARPen it\",\"SHARPen it\",SHARPRating)","v":"Low"},null,{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",\" ♦ SHARP rating\")","v":""},{"$f":"IF(XAssess=\"menu ▼\",\"\",\nIF(XAssess=\"first assessment\",\"\",\nIF(XAssess=\"re-assessment\",FirstSHARPRating)))","v":""}]
[null,null," • SHARP date",null,null,{"$f":"IF(AssessDate=\"\",\"SHARPen it\",AssessDate)","v":"2024-03-04"},null,{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",\" ♦ SHARP date\")","v":""},{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",FirstAssessDate)","v":""}]
[null,null," • EJFlagged?",null,null,{"$f":"IF(EJFlag=\"Respond to all fields\",\"SHARPen it\",\nIF(EJFlag=\"respond to all fields\",\"\",\nIF(EJFlag=\"EJFlagged: Overridden\",\"✔️– Overridden\",\nIF(EJFlag=\"EJFlagged\",\"✔️\",\nIF(EJFlag=\"No EJFlag\",\"🚫\",\"\")))))","v":"✔️"},null,{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",\" ♦ EJFlagged?\")","v":""},{"$f":"IF(FirstEJFlag=\"menu ▼\",\"\",\nIF(FirstEJFlag=\"EJFlagged: Overridden\",\"✔️– Overridden\",\nIF(FirstEJFlag=\"EJFlagged\",\"✔️\",\nIF(FirstEJFlag=\"No EJFlag\",\"🚫\",\"\"))))","v":""}]
[null,null," • LD data confidence level",null,null,{"$f":"IF(LD_Confidence=\"menu ▼\",\"SHARPen it\",LD_Confidence)","v":"low"},null,{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",\" ♦ LD data confidence level\")","v":""},{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",FirstLD_Confidence)","v":""}]
[null,null," • Cleanup milestone",null,null,{"$f":"IF(CleanupMilestone=\"menu ▼\",\"SHARPen it\",CleanupMilestone)","v":"initial investigation"},null,{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",\" ♦ Cleanup milestone\")","v":""},{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",FirstCleanupMilestone)","v":""}]
[null,null," • Assessor",null,null,{"$f":"IF(Assessor=\"\",\"SHARPen it\",Assessor)","v":"Sara Fulton"},null,{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",\" ♦ First assessor\")","v":""},{"$f":"IF(OR(XAssess=\"menu ▼\",XAssess=\"first assessment\"),\"\",FirstAssessor)","v":""}]
[null,null,"Assessment Media",null,null,"Scores","Conf","Additional Factors",null,"Ecology Info"]
[null,null," Indoor air",null,null,{"$f":"IF(OR(IA_ExScore=\"SHARPen it\",IA_SvScore=\"SHARPen it\"),\"SHARPen it\",IA_Score)","v":"D4"},{"$f":"IF(IA_Conf=\"menu ▼\",\"SHARPen it\",IA_Conf)","v":"medium"}," multiple chemical types",{"$f":"IF(AF_1Ans=\"menu ▼\",\"SHARPen it\",\nIF(OR(AF_1Ans=\"yes\",AF_1Ans=\"maybe\"),\"✔️\",\nIF(AF_1Ans=\"no\",\"🚫\",\"\")))","v":"🚫"}," ERTS",{"$f":"IF(ERTS=\"\",\"n/a\",ERTS)","v":"729023"}]
[null,null," Groundwater",null,null,{"$f":"IF(OR(GW_ExScore=\"SHARPen it\",GW_SvScore=\"SHARPen it\"),\"SHARPen it\",GW_Score)","v":"B4"},{"$f":"IF(GW_Conf=\"menu ▼\",\"SHARPen it\",GW_Conf)","v":"medium"}," risk to off-site people",{"$f":"IF(AF_2Ans=\"menu ▼\",\"SHARPen it\",\nIF(OR(AF_2Ans=\"yes\",AF_2Ans=\"maybe\"),\"✔️\",\nIF(AF_2Ans=\"no\",\"🚫\",\"\")))","v":"✔️"}," CSID",{"$f":"IF(CSID=\"\",\"SHARPen it\",CSID)","v":"17003"}]
[null,null," Surface water",null,null,{"$f":"IF(OR(SW_ExScore=\"SHARPen it\",SW_SvScore=\"SHARPen it\"),\"SHARPen it\",SW_Score)","v":"D4"},{"$f":"IF(SW_Conf=\"menu ▼\",\"SHARPen it\",SW_Conf)","v":"high"}," climate change impacts",{"$f":"IF(AF_3Ans=\"menu ▼\",\"SHARPen it\",\nIF(OR(AF_3Ans=\"yes\",AF_3Ans=\"maybe\"),\"✔️\",\nIF(AF_3Ans=\"no\",\"🚫\",\"\")))","v":"🚫"}," FSID",{"$f":"IF(FSID=\"\",\"SHARPen it\",FSID)","v":"5629891"}]
[null,null," Sediment",null,null,{"$f":"IF(OR(SD_ExScore=\"SHARPen it\",SD_SvScore=\"SHARPen it\"),\"SHARPen it\",SD_Score)","v":"D4"},{"$f":"IF(SD_Conf=\"menu ▼\",\"SHARPen it\",SD_Conf)","v":"high"}," plant/animal tissue data",{"$f":"IF(AF_4Ans=\"menu ▼\",\"SHARPen it\",\nIF(OR(AF_4Ans=\"yes\",AF_4Ans=\"maybe\"),\"✔️\",\nIF(AF_4Ans=\"no\",\"🚫\",\"\")))","v":"🚫"}," VCP",{"$f":"IF(VCP=\"\",\"n/a\",VCP)","v":"n/a"}]
[null,null," Soil",null,null,{"$f":"IF(OR(SL_ExScore=\"SHARPen it\",SL_SvScore=\"SHARPen it\"),\"SHARPen it\",SL_Score)","v":"C4"},{"$f":"IF(SL_Conf=\"menu ▼\",\"SHARPen it\",SL_Conf)","v":"medium"},null,null," UST ID",{"$f":"IF(UST=\"\",\"n/a\",UST)","v":"n/a"}]
[null,null,null,null,null,null,null,null,null," LUST ID",{"$f":"IF(LUST=\"\",\"n/a\",LUST)","v":"n/a"}]
[null,null,"Location and Land Use Info"]
[null,null,{"$f":"_xlfn.CONCAT(Address,\", \",City,\", \",County, \" County, \",Zip)","v":"2 Division Street West, Quincy, Grant County, 98848"},null,null,null,null,null,"Responsible unit –",{"$f":"Responsible_Unit","v":"ERO"}]
[null,null,"Parcel",null,{"$f":"IF(Parcel=\"\",\"SHARPen it\",Parcel)","v":"SHARPen it"},null,null,null,"Land use –",{"$f":"Landuse","v":"menu ▼"}]
[null,null,"Source/source area description"]
[null,null,{"$f":"IF(SourceArea=\"\",\"no comments\",SourceArea)","v":"According to the SPILLs report, the cause of the release was due to mechanical failure (The wind caused an arm to fall into a valve opening it spilling 104 gallons of diesel into concrete and asphalt parking area and water oil separator containment)."}]
[]
[]
[]
[]
[null,null,"Local demographics comments"]
[null,null,{"$f":"IF(LD_Comments=\"\",\"no comments\",LD_Comments)","v":"no comments"}]
[]
[]
[]
[]
[null,null,"Soil comments"]
[null,null,{"$f":"IF(SL_Comments=\"\",\"no comments\",SL_Comments)","v":"The site is covered in concrete/asphalt however there are numerous cracks throughout. These cracks could have allowed the diesel to seep into the soil. "}]
[]
[]
[]
[]
[null,null,"Groundwater comments"]
[null,null,{"$f":"IF(GW_Comments=\"\",\"no comments\",GW_Comments)","v":"The cracks in the concrete/asphalt may have allowed diesel fuel to seep into the ground. Groundwater is at approximately 17.5 feet bgs. "}]
[]
[]
[]
[null,null,"Surface water comments"]
[null,null,{"$f":"IF(SW_Comments=\"\",\"no comments\",SW_Comments)","v":"no comments"}]
[]
[]
[]
[]
[null,null,"Sediment comments"]
[null,null,{"$f":"IF(SD_Comments=\"\",\"no comments\",SD_Comments)","v":"no comments"}]
[]
[]
[]
[]
[null,null,"Indoor air comments"]
[null,null,{"$f":"IF(IA_Comments=\"\",\"no comments\",IA_Comments)","v":"no comments"}]
[]
[]
[]
[]
[null,null,"Additional factors comments"]
[null,null,{"$f":"IF(AF_Comments=\"\",\"no comments\",AF_Comments)","v":"no comments"}]
[]
[]
[]
[]
[null,null,"Site narrative summary"]
[null,null,{"$f":"IF(SiteNarrative=\"\",\"\n\nNo site narrative entered! Incomplete assessment!\",SiteNarrative)","v":"According to the SPILLs report, the cause of the release was due to mechanical failure (The wind caused an arm to fall into a valve opening it spilling 104 gallons of diesel into concrete and asphalt parking area and water oil separator containment). Photos taken by SPILLS show deep cracks in the concrete/asphalt, suspect that some of the diesel fuel seeped into those cracks. \n\nPer Shawn Conroy, they plan to seal the cracks but not replace the concrete/asphalt. At this time, no further cleanup work is expected at this time. "}]

{"sheet":"Part2","index":10,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"SiteNamePart1","v":"CHS Sun Basin Petroleum Facility Diesel Release"},null,null,null,null,"SHARP Report — Part 2 of 2"]
[null,null,{"$f":"TEXT(AssessDate, \"MM/DD/YYYY\")","v":"03/04/2024"},null,null,null,null,"Conceptual site model"]
[null,null,{"$f":"IF(XAssess=\"first assessment\",\"SHARP First Assessment\",\nIF(XAssess=\"re-assessment\",\"SHARP Re-assessment\",\nIF(XAssess=\"menu ▼\",\"SHARP first/re-assessment = SHARPen it\",\"SHARPen it\")))","v":"SHARP First Assessment"}]
[null,null,{"$f":"IF(SHARPRating=\"SHARPen it\",\"SHARP Rating = SHARPen it\", _xlfn.CONCAT(SHARPRating,\" SHARP Rating\"))","v":"Low SHARP Rating"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"▼ Hidden ▼"]
[null,null,{"$f":"SL_Score","v":"C4"}]
[null,null,{"$f":"CONCATENATE(\"soil\",CHAR(10),SL_Conf, \" confidence\")","v":"soil\nmedium confidence"},null,{"$f":"CONCATENATE(SL!E3,\"  \",SL_Score,CHAR(10),SL_Conf, \" confidence\")","v":"C4  C4\nmedium confidence"}]
[null,null,{"$f":"GW_Score","v":"B4"}]
[null,null,{"$f":"CONCATENATE(\"groundwater\",CHAR(10),GW_Conf, \" confidence\")","v":"groundwater\nmedium confidence"},null,{"$f":"CONCATENATE(GW!E3,\"  \",GW_Score,CHAR(10),GW_Conf, \" confidence\")","v":"B4  B4\nmedium confidence"}]
[null,null,{"$f":"SW_Score","v":"D4"}]
[null,null,{"$f":"CONCATENATE(\"surface water\",CHAR(10),SW_Conf, \" confidence\")","v":"surface water\nhigh confidence"},null,{"$f":"CONCATENATE(SW!E3,\"  \",SW_Score,CHAR(10),SW_Conf, \" confidence\")","v":"D4  D4\nhigh confidence"}]
[null,null,{"$f":"SD_Score","v":"D4"}]
[null,null,{"$f":"CONCATENATE(\"sediment\",CHAR(10),SD_Conf, \" confidence\")","v":"sediment\nhigh confidence"},null,{"$f":"CONCATENATE(SD!E3,\"  \",SD_Score,CHAR(10),SD_Conf, \" confidence\")","v":"D4  D4\nhigh confidence"}]
[null,null,{"$f":"IA_Score","v":"D4"}]
[null,null,{"$f":"CONCATENATE(\"indoor air\",CHAR(10),IA_Conf, \" confidence\")","v":"indoor air\nmedium confidence"},null,{"$f":"CONCATENATE(IA!E3,\"  \",IA_Score,CHAR(10),IA_Conf, \" confidence\")","v":"D4  D4\nmedium confidence"}]

{"sheet":"ChemTox","index":11,"n_rows":654,"n_cols":6,"rows_kept":654,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Chemical Toxicity Reference Table"]
[null,null,null,"Toxicity Category"]
[null,"Chemical Name","Possible\nVapor\nIntrusion","Soil,\nGroundwater,\nIndoor Air","Surface\nWater","CAS #"]
[null,"acenaphthene",null,null,"extremely\n(only freshwater)","83-32-9"]
[null,"acephate",null,"extremely","extremely\n(only freshwater)","30560-19-1"]
[null,"acetaldehyde","yes",null,"extremely\n(only freshwater)","75-07-0"]
[null,"acetochlor",null,null,null,"34256-82-1"]
[null,"acetone",null,null,null,"67-64-1"]
[null,"acetone cyanohydrin",null,"very",null,"75-86-5"]
[null,"acetonitrile","yes",null,null,"75-05-8"]
[null,"acetophenone",null,null,null,"98-86-2"]
[null,"acifluorfen, sodium",null,null,null,"62476-59-9"]
[null,"acrolein","yes","extremely",null,"107-02-8"]
[null,"acrylamide",null,"very",null,"79-06-1"]
[null,"acrylic acid",null,"very",null,"79-10-7"]
[null,"acrylonitrile","yes","very",null,"107-13-1"]
[null,"alachlor",null,null,"extremely","15972-60-8"]
[null,"alar",null,null,null,"1596-84-5"]
[null,"aldicarb",null,"very","extremely","116-06-3"]
[null,"aldicarb sulfone",null,"very",null,"1646-88-4"]
[null,"aldrin",null,"extremely","extremely","309-00-2"]
[null,"ally",null,null,null,"74223-64-6"]
[null,"allyl alcohol",null,"extremely",null,"107-18-6"]
[null,"allyl chloride","yes","very",null,"107-05-1"]
[null,"aluminum",null,"very",null,"7429-90-5"]
[null,"aluminum phosphide",null,"extremely",null,"20859-73-8"]
[null,"amdro",null,null,"extremely","67485-29-4"]
[null,"ametryn",null,null,null,"834-12-8"]
[null,"aminobiphenyl;4-",null,"extremely",null,"92-67-1"]
[null,"aminophenol;m-",null,null,null,"591-27-5"]
[null,"amitraz",null,"very",null,"33089-61-1"]
[null,"ammonia",null,null,null,"7664-41-7"]
[null,"ammonium perchlorate",null,"very",null,"7790-98-9"]
[null,"ammonium sulfamate",null,null,null,"7773-06-0"]
[null,"aniline",null,"very","extremely\n(only freshwater)","62-53-3"]
[null,"anthracene",null,null,"extremely","120-12-7"]
[null,"antimony",null,"extremely",null,"7440-36-0"]
[null,"antimony pentoxide",null,"very",null,"1314-60-9"]
[null,"antimony potassium tartrate",null,"very",null,"28300-74-5"]
[null,"antimony tetroxide",null,"extremely",null,"1332-81-6"]
[null,"antimony trioxide",null,"extremely",null,"1309-64-4"]
[null,"apollo",null,null,"extremely","74115-24-5"]
[null,"aramite",null,null,"extremely","140-57-8"]
[null,"arsenic",null,"extremely",null,"7440-38-2"]
[null,"arsine",null,"extremely",null,"7784-42-1"]
[null,"asbestos",null,"extremely",null,"1332-21-4"]
[null,"assure",null,null,null,"76578-14-8"]
[null,"asulam",null,null,null,"3337-71-1"]
[null,"atrazine",null,null,"extremely","1912-24-9"]
[null,"avermectin B1",null,"extremely","extremely","65195-55-3"]
[null,"azobenzene",null,"very",null,"103-33-3"]
[null,"barium and compounds",null,"very",null,"7440-39-3"]
[null,"baygon",null,"very",null,"114-26-1"]
[null,"bayleton",null,null,null,"43121-43-3"]
[null,"baythroid",null,null,null,"68359-37-5"]
[null,"benefin",null,null,null,"1861-40-1"]
[null,"benomyl",null,null,null,"17804-35-2"]
[null,"bentazon",null,null,null,"25057-89-0"]
[null,"benzaldehyde",null,null,null,"100-52-7"]
[null,"benzene","yes","very",null,"71-43-2"]
[null,"benzenethiol",null,"very",null,"108-98-5"]
[null,"benzidine",null,"extremely",null,"92-87-5"]
[null,"benzo[a]anthracene",null,"use cPAH TEQ - \nsee benzo(a)pyrene",null,"56-55-3"]
[null,"benzo[a]pyrene (also use for cPAH TEQ)",null,"Extremely",null,"50-32-8"]
[null,"benzo[b]fluoranthene",null,"use cPAH TEQ - \nsee benzo(a)pyrene",null,"205-99-2"]
[null,"benzo[e]pyrene",null,"extremely",null,"192-97-2"]
[null,"benzo[k]fluoranthene",null,"use cPAH TEQ - \nsee benzo(a)pyrene",null,"207-08-9"]
[null,"benzoic acid",null,null,null,"65-85-0"]
[null,"benzotrichloride",null,"extremely",null,"98-07-7"]
[null,"benzyl alcohol",null,null,null,"100-51-6"]
[null,"benzyl chloride","yes","very",null,"100-44-7"]
[null,"beryllium",null,"extremely",null,"7440-41-7"]
[null,"beta-chloronaphthalene",null,null,null,"91-58-7"]
[null,"bidrin",null,"extremely",null,"141-66-2"]
[null,"biphenthrin",null,null,null,"82657-04-3"]
[null,"biphenyl;1,1-",null,"very",null,"92-52-4"]
[null,"bis(2-chloro-1-methyl-ethyl)ether",null,null,null,"108-60-1"]
[null,"bis(2-chloroethoxy)methane",null,"very",null,"111-91-1"]
[null,"bis(2-chloroethyl)ether",null,"very",null,"111-44-4"]
[null,"bis(2-ethylhexyl) phthalate (DEHP)",null,null,null,"117-81-7"]
[null,"bis(chloromethyl)ether",null,"extremely",null,"542-88-1"]
[null,"bisphenol a",null,null,null,"80-05-7"]
[null,"boron",null,null,null,"7440-42-8"]
[null,"bromate",null,"very",null,"15541-45-4"]
[null,"bromoacetic acid",null,null,null,"79-08-3"]
[null,"bromobenzene","yes",null,null,"108-86-1"]
[null,"bromochloromethane",null,null,null,"74-97-5"]
[null,"bromodichloromethane","yes",null,null,"75-27-4"]
[null,"bromoethene","yes","very",null,"593-60-2"]
[null,"bromoform","yes",null,null,"75-25-2"]
[null,"bromomethane","yes","very",null,"74-83-9"]
[null,"bromophos",null,null,null,"2104-96-3"]
[null,"bromoxynil",null,null,null,"1689-84-5"]
[null,"bromoxynil octanoate",null,null,null,"1689-99-2"]
[null,"butadiene;1,3-","yes","extremely",null,"106-99-0"]
[null,"butanol;n-",null,null,null,"71-36-3"]
[null,"butyl alcohol;tert-",null,null,null,"75-65-0"]
[null,"butyl benzyl phthalate",null,null,null,"85-68-7"]
[null,"butylate",null,null,null,"2008-41-5"]
[null,"butylphthalyl butylglycolate",null,null,null,"85-70-1"]
[null,"butyric acid;4-(2-methyl-4-chlorophenoxy)-",null,null,null,"94-81-5"]
[null,"cacodylic acid",null,null,null,"75-60-5"]
[null,"cadmium",null,"extremely","extremely\n(only freshwater)","7440-43-9"]
[null,"calcium cyanide",null,"very",null,"592-01-8"]
[null,"caprolactam",null,"very",null,"105-60-2"]
[null,"captafol",null,"very",null,"2425-06-01"]
[null,"captan",null,null,null,"133-06-2"]
[null,"carbaryl",null,null,null,"63-25-2"]
[null,"carbofuran",null,null,null,"1563-66-2"]
[null,"carbon disulfide","yes",null,null,"75-15-0"]
[null,"carbon tetrachloride","yes","very",null,"56-23-5"]
[null,"carbosulfan",null,null,null,"55285-14-8"]
[null,"carboxin",null,null,null,"5234-68-4"]
[null,"cerium oxide and cerium compounds",null,"very",null,"1306-38-3"]
[null,"chloral hydrate",null,null,null,"302-17-0"]
[null,"chloramben",null,null,null,"133-90-4"]
[null,"chloranil",null,null,null,"118-75-2"]
[null,"chlordane",null,"very","extremely","12789-03-6"]
[null,"chlordane (alpha)",null,"very",null,"5103-71-9"]
[null,"chlordane (gamma)",null,"very",null,"5103-74-2"]
[null,"chlordecone (kepone)",null,"extremely",null,"143-50-0"]
[null,"chloride",null,null,null,"16887-00-6"]
[null,"chlorimuron-ethyl",null,null,null,"90982-32-4"]
[null,"chlorine",null,"extremely",null,"7782-50-5"]
[null,"chlorine cyanide",null,null,null,"506-77-4"]
[null,"chlorine dioxide",null,"extremely",null,"10049-04-4"]
[null,"chlorite",null,null,null,"7758-19-2"]
[null,"chloro-1,1-difluoroethane;1-",null,null,null,"75-68-3"]
[null,"chloro-1,3-butadiene;2-","yes",null,null,"126-99-8"]
[null,"chloro-2-methylaniline hydrochloride;4-",null,null,null,"3165-93-3"]
[null,"chloro-2-methylaniline;4-",null,"very",null,"95-69-2"]
[null,"chloroacetic acid",null,"very",null,"79-11-8"]
[null,"chloroacetophenone;2-",null,"extremely",null,"532-27-4"]
[null,"chloroaniline;p-",null,"very",null,"106-47-8"]
[null,"chlorobenzene","yes",null,null,"108-90-7"]
[null,"chlorobenzilate",null,null,null,"510-15-6"]
[null,"chlorobenzoic acid;p-",null,null,null,"74-11-3"]
[null,"chlorobenzotrifluoride;4-",null,"very",null,"98-56-6"]
[null,"chlorobutane;1-",null,null,null,"109-69-3"]
[null,"chlorocresol",null,null,null,"59-50-7"]
[null,"chlorodifluoromethane","yes",null,null,"75-45-6"]
[null,"chloroform","yes",null,null,"67-66-3"]
[null,"chloromethane","yes",null,null,"74-87-3"]
[null,"chloromethyl methyl ether",null,"extremely",null,"107-30-2"]
[null,"chloronitrobenzene;o-",null,"extremely",null,"88-73-3"]
[null,"chloronitrobenzene;p-",null,"very",null,"100-00-5"]
[null,"chlorophenol; 2-",null,null,null,"95-57-8"]
[null,"chlorothalonil",null,null,null,"1897-45-6"]
[null,"chlorotoluene;o-",null,null,null,"95-49-8"]
[null,"chlorotoluene;p-",null,null,null,"106-43-4"]
[null,"chlorpropham",null,null,null,"101-21-3"]
[null,"chlorpyrifos",null,"very","extremely","2921-88-2"]
[null,"chlorpyrifos-methyl",null,null,null,"5598-13-0"]
[null,"chlorsulfuron",null,null,null,"64902-72-3"]
[null,"chlorthiophos",null,"very",null,"60238-56-4"]
[null,"chromium (III)",null,null,null,"16065-83-1"]
[null,"chromium (total)",null,null,null,"7440-47-3"]
[null,"chromium (VI)",null,"extremely",null,"18540-29-9"]
[null,"chrysene",null,"use cPAH TEQ - \nsee benzo(a)pyrene",null,"218-01-9"]
[null,"cobalt",null,"extremely",null,"7440-48-4"]
[null,"coke oven emissions",null,null,null,"E649830"]
[null,"copper",null,null,null,"7440-50-8"]
[null,"copper cyanide",null,null,null,"544-92-3"]
[null,"cresol;m-",null,null,null,"108-39-4"]
[null,"cresol;o-",null,null,null,"95-48-7"]
[null,"cresol;p-",null,null,null,"106-44-5"]
[null,"cresols",null,null,null,"1319-77-3"]
[null,"crotonaldehyde",null,"very",null,"123-73-9"]
[null,"cumene","yes",null,null,"98-82-8"]
[null,"cyanazine",null,"very",null,"21725-46-2"]
[null,"cyanide",null,"very",null,"57-12-5"]
[null,"cyanogen",null,"very",null,"460-19-5"]
[null,"cyanogen bromide",null,null,null,"506-68-3"]
[null,"cyclohexane","yes",null,null,"110-82-7"]
[null,"cyclohexanone","yes",null,null,"108-94-1"]
[null,"cyclohexylamine",null,null,null,"108-91-8"]
[null,"cyromazine",null,null,null,"66215-27-8"]
[null,"dacthal",null,null,null,"1861-32-1"]
[null,"dalapon, sodium salt",null,null,null,"75-99-0"]
[null,"danitol",null,null,null,"39515-41-8"]
[null,"DDD",null,"extremely",null,"72-54-8"]
[null,"DDE",null,"extremely",null,"72-55-9"]
[null,"DDT",null,"very","extremely","50-29-3"]
[null,"decabromodiphenyl ether (PBDE-209)",null,null,null,"1163-19-5"]
[null,"demeton",null,"extremely","extremely","8065-48-3"]
[null,"di(2-ethylhexyl)adipate",null,null,null,"103-23-1"]
[null,"diallate",null,null,null,"2303-16-4"]
[null,"diazinon",null,"very","extremely","333-41-5"]
[null,"dibenz[a,h]anthracene",null,"use cPAH TEQ - \nsee benzo(a)pyrene",null,"53-70-3"]
[null,"dibenzofuran",null,"very",null,"132-64-9"]
[null,"dibromo-3-chloropropane;1,2-","yes","extremely",null,"96-12-8"]
[null,"dibromoacetic acid",null,null,null,"631-64-1"]
[null,"dibromobenzene;1,4-",null,null,null,"106-37-6"]
[null,"dibromochloromethane",null,null,null,"124-48-1"]
[null,"di-butyl phthalate",null,null,null,"84-74-2"]
[null,"dicamba",null,null,null,"1918-00-9"]
[null,"dichloramine",null,null,null,"3400-09-07"]
[null,"dichloro-2-butene;1,4-",null,null,null,"764-41-0"]
[null,"dichloro-2-butene;trans-1,4-",null,null,null,"110-57-6"]
[null,"dichloroacetic acid",null,"very",null,"79-43-6"]
[null,"dichlorobenzene;1,2-","yes",null,null,"95-50-1"]
[null,"dichlorobenzene;1,3-",null,null,null,"541-73-1"]
[null,"dichlorobenzene;1,4-","yes",null,null,"106-46-7"]
[null,"dichlorobenzidine;3,3'-",null,"very",null,"91-94-1"]
[null,"dichlorodifluoromethane","yes",null,null,"75-71-8"]
[null,"dichloroethane;1,1-","yes",null,null,"75-34-3"]
[null,"dichloroethane;1,2- (EDC)","yes",null,null,"107-06-2"]
[null,"dichloroethylene;1,1-","yes",null,null,"75-35-4"]
[null,"dichloroethylene;1,2-,cis","yes","very",null,"156-59-2"]
[null,"dichloroethylene;1,2-,trans","yes",null,null,"156-60-5"]
[null,"dichlorophenol;2,4-",null,"very",null,"120-83-2"]
[null,"dichlorophenoxyacetic acid;2,4-",null,null,null,"94-75-7"]
[null,"dichloropropane;1,2-","yes","very",null,"78-87-5"]
[null,"dichloropropane;1,3-",null,null,null,"142-28-9"]
[null,"dichloropropanol;2,3-",null,"very",null,"616-23-9"]
[null,"dichloropropene;1,3-","yes",null,null,"542-75-6"]
[null,"dichlorvos",null,"very",null,"62-73-7"]
[null,"dicyclopentadiene",null,"extremely",null,"77-73-6"]
[null,"dieldrin",null,"extremely","extremely","60-57-1"]
[null,"diesel, and/or oil range"]
[null,"diethyl phthalate",null,null,null,"84-66-2"]
[null,"diethylene glycol monobutyl ether",null,"extremely",null,"112-34-5"]
[null,"diethylene glycol monoethyl ether",null,"extremely",null,"111-90-0"]
[null,"diethylformamide",null,"very",null,"617-84-5"]
[null,"diethylstilbesterol",null,"extremely",null,"56-53-1"]
[null,"difenzoquat",null,null,null,"43222-48-6"]
[null,"diflubenzuron",null,null,null,"35367-38-5"]
[null,"difluoroethane;1,1-","yes",null,null,"75-37-6"]
[null,"diisopropyl ether",null,null,null,"108-20-3"]
[null,"diisopropyl methylphosphonate",null,null,null,"1445-75-6"]
[null,"dimethipin",null,null,null,"55290-64-7"]
[null,"dimethoate",null,"very",null,"60-51-5"]
[null,"dimethoxybenzidine;3,3'-",null,"very",null,"119-90-4"]
[null,"dimethyl phthalate",null,null,null,"131-11-3"]
[null,"dimethyl terephthalate",null,null,null,"120-61-6"]
[null,"dimethylaniline hydrochloride;2,4-",null,null,null,"21436-96-4"]
[null,"dimethylaniline;2,4-",null,"very",null,"95-68-1"]
[null,"dimethylaniline;N,N-",null,"very",null,"121-69-7"]
[null,"dimethylbenzidine;3,3'-",null,"extremely",null,"119-93-7"]
[null,"dimethylformamide;N,N-",null,null,null,"68-12-2"]
[null,"dimethylhydrazine;1,1-",null,"extremely",null,"57-14-7"]
[null,"dimethylhydrazine;1,2-",null,"extremely",null,"540-73-8"]
[null,"dimethylphenol;2,4-",null,null,null,"105-67-9"]
[null,"dimethylphenol;2,6-",null,"very",null,"576-26-1"]
[null,"dimethylphenol;3,4-",null,"very",null,"95-65-8"]
[null,"dinitrobenzene;m-",null,"extremely",null,"99-65-0"]
[null,"dinitrobenzene;o-",null,"extremely",null,"528-29-0"]
[null,"dinitrobenzene;p-",null,"extremely",null,"100-25-4"]
[null,"dinitro-o-cyclohexyl phenol;4,6-",null,"very",null,"131-89-5"]
[null,"dinitrophenol;2,4-",null,"very",null,"51-28-5"]
[null,"dinitrophenols",null,null,null,"25550-58-7"]
[null,"dinitrotoluene mixture; 2,4-/2,6-",null,"very",null,"E1615210"]
[null,"dinitrotoluene, 2-amino-4,6-",null,"extremely",null,"35572-78-2"]
[null,"dinitrotoluene, 4-amino-2,6-",null,"extremely",null,"19406-51-0"]
[null,"dinitrotoluene;2,4-",null,"very",null,"121-14-2"]
[null,"dinitrotoluene;2,6-",null,"extremely",null,"606-20-2"]
[null,"di-n-octyl phthalate",null,null,null,"117-84-0"]
[null,"dinoseb",null,"very",null,"88-85-7"]
[null,"dioxane;1,4-","yes",null,null,"123-91-1"]
[null,"diphenamid",null,null,null,"957-51-7"]
[null,"diphenylamine",null,null,null,"122-39-4"]
[null,"diphenylhydrazine;1,2-",null,"very",null,"122-66-7"]
[null,"diquat",null,"very",null,"2764-72-9"]
[null,"direct black 38",null,"extremely",null,"1937-37-7"]
[null,"direct blue 6",null,"extremely",null,"2602-46-2"]
[null,"direct brown 95",null,"extremely",null,"16071-86-6"]
[null,"disulfoton",null,"extremely",null,"298-04-4"]
[null,"dithiane;1,4-",null,null,null,"505-29-3"]
[null,"diuron",null,"very",null,"330-54-1"]
[null,"DNOC",null,"extremely",null,"534-52-1"]
[null,"dodine",null,null,null,"2439-10-03"]
[null,"endosulfan",null,null,"extremely","115-29-7"]
[null,"endosulfan sulfate",null,null,null,"1031-07-8"]
[null,"endosulfan;alpha",null,null,"extremely","959-98-8"]
[null,"endosulfan;beta",null,null,"extremely","33213-65-9"]
[null,"endothall",null,null,null,"145-73-3"]
[null,"endrin",null,"extremely","extremely","72-20-8"]
[null,"endrin aldehyde",null,null,null,"7421-93-4"]
[null,"epichlorohydrin",null,"very",null,"106-89-8"]
[null,"epoxybutane",null,null,null,"106-88-7"]
[null,"ethephon",null,null,null,"16672-87-0"]
[null,"ethion",null,"very",null,"563-12-2"]
[null,"ethoxyethanol acetate;2-",null,null,null,"111-15-9"]
[null,"ethoxyethanol;2-",null,null,null,"110-80-5"]
[null,"ethyl acetate","yes",null,null,"141-78-6"]
[null,"ethyl acrylate","yes",null,null,"140-88-5"]
[null,"ethyl chloride","yes",null,null,"75-00-3"]
[null,"ethyl dipropylthiocarbamate;S-",null,null,null,"759-94-4"]
[null,"ethyl ether",null,null,null,"60-29-7"]
[null,"ethyl methacrylate","yes",null,null,"97-63-2"]
[null,"ethyl p-nitrophenyl phenylphosphorothioate",null,"extremely",null,"2104-64-5"]
[null,"ethyl tertiary butyl ether (ETBE)","yes",null,null,"637-92-3"]
[null,"ethylbenzene","yes",null,null,"100-41-4"]
[null,"ethylene cyanohydrin",null,null,null,"109-78-4"]
[null,"ethylene diamine",null,null,null,"107-15-3"]
[null,"ethylene dibromide (EDB)","yes","very",null,"106-93-4"]
[null,"ethylene glycol",null,null,null,"107-21-1"]
[null,"ethylene glycol monobutyl ether (EGBE)",null,null,null,"111-76-2"]
[null,"ethylene oxide","yes","extremely",null,"75-21-8"]
[null,"ethylene thiourea",null,"extremely",null,"96-45-7"]
[null,"ethylphthalyl ethyl glycolate",null,null,null,"84-72-0"]
[null,"express",null,null,null,"101200-48-0"]
[null,"fenamiphos",null,"extremely",null,"22224-92-6"]
[null,"fluometuron",null,null,null,"2164-17-2"]
[null,"fluoranthene",null,null,null,"206-44-0"]
[null,"fluorene",null,null,null,"86-73-7"]
[null,"fluoride",null,null,null,"16984-48-8"]
[null,"fluridone",null,null,null,"59756-60-4"]
[null,"flurprimidol",null,null,null,"56425-91-3"]
[null,"flutolanil",null,null,null,"66332-96-5"]
[null,"fluvalinate",null,null,null,"69409-94-5"]
[null,"folpet",null,null,null,"133-07-3"]
[null,"fomesafen",null,null,null,"72178-02-0"]
[null,"fonofos",null,"very",null,"944-22-9"]
[null,"formaldehyde",null,null,null,"50-00-0"]
[null,"formic acid",null,"extremely",null,"64-18-6"]
[null,"fosetyl-al",null,null,null,"39148-24-8"]
[null,"furan",null,"very",null,"110-00-9"]
[null,"furazolidone",null,"very",null,"67-45-8"]
[null,"furfural",null,"very",null,"98-01-1"]
[null,"furium",null,"very",null,"531-82-8"]
[null,"furmecyclox",null,null,null,"60568-05-0"]
[null,"glufosinate-ammonium",null,null,null,"77182-82-2"]
[null,"glycidaldehyde",null,"extremely",null,"765-34-4"]
[null,"glyphosate",null,null,null,"1071-83-6"]
[null,"guthion",null,"very","extremely","86-50-0"]
[null,"haloxyfop-methyl",null,"extremely",null,"69806-40-2"]
[null,"harmony",null,null,null,"79277-27-3"]
[null,"heptachlor","yes","extremely","extremely","76-44-8"]
[null,"heptachlor epoxide",null,"extremely","extremely","1024-57-3"]
[null,"heptane;n-","yes","extremely",null,"142-82-5"]
[null,"hexabromobenzene",null,"very",null,"87-82-1"]
[null,"hexabromodiphenyl ether; 2,2',4,4',5,5'- (PBDE-153)",null,"extremely",null,"68631-49-2"]
[null,"hexachlorobenzene","yes","extremely",null,"118-74-1"]
[null,"hexachlorobutadiene","yes","very",null,"87-68-3"]
[null,"hexachlorocyclohexane;alpha",null,"extremely",null,"319-84-6"]
[null,"hexachlorocyclohexane;beta-",null,"very",null,"319-85-7"]
[null,"hexachlorocyclohexane;technical",null,"very",null,"608-73-1"]
[null,"hexachlorocyclopentadiene","yes","extremely",null,"77-47-4"]
[null,"hexachlorodibenzo-p-dioxin, mixture",null,"extremely",null,"34465-46-8"]
[null,"hexachloroethane","yes","very",null,"67-72-1"]
[null,"hexachlorophene",null,"extremely",null,"70-30-4"]
[null,"hexafluoropropylene oxide dimer acid (HFPO-DA; GenX)",null,"extremely",null,"13252-13-6"]
[null,"hexamethylene diisocyanate;1,6-",null,"extremely",null,"822-06-0"]
[null,"hexane;n-","yes",null,null,"110-54-3"]
[null,"hexanone;2-","yes",null,null,"591-78-6"]
[null,"hexazinone",null,null,null,"51235-04-2"]
[null,"hydrazine",null,"extremely",null,"302-01-2"]
[null,"hydrazine sulfate",null,"very",null,"10034-93-2"]
[null,"hydrogen chloride",null,null,null,"7647-01-0"]
[null,"hydrogen cyanide",null,"very",null,"74-90-8"]
[null,"hydrogen sulfide","yes","very",null,"7783-06-04"]
[null,"hydroquinone",null,null,null,"123-31-9"]
[null,"imazalil",null,null,null,"35554-44-0"]
[null,"imazaquin",null,null,null,"81335-37-7"]
[null,"indeno[1,2,3-cd]pyrene",null,"use cPAH TEQ - \nsee benzo(a)pyrene",null,"193-39-5"]
[null,"iprodione",null,null,null,"36734-19-7"]
[null,"iron",null,null,null,"7439-89-6"]
[null,"isobutyl alcohol",null,null,null,"78-83-1"]
[null,"isophorone",null,null,null,"78-59-1"]
[null,"isopropalin",null,null,null,"33820-53-0"]
[null,"isopropanol",null,null,null,"67-63-0"]
[null,"isopropyl methyl phosphonic acid",null,null,null,"1832-54-8"]
[null,"isoxaben",null,null,null,"82558-50-7"]
[null,"lactofen",null,null,null,"77501-63-4"]
[null,"lead",null,"extremely",null,"7439-92-1"]
[null,"lindane",null,"extremely","extremely","58-89-9"]
[null,"linuron",null,null,null,"330-55-2"]
[null,"lithium",null,"very",null,"7439-93-2"]
[null,"lithium perchlorate",null,"very",null,"7791-03-09"]
[null,"londax",null,null,null,"83055-99-6"]
[null,"malathion",null,null,"extremely","121-75-5"]
[null,"maleic anhydride",null,"very",null,"108-31-6"]
[null,"maleic hydrazide",null,null,null,"123-33-1"]
[null,"malononitrile",null,"extremely",null,"109-77-3"]
[null,"mancozeb",null,null,null,"8018-01-07"]
[null,"maneb",null,null,null,"12427-38-2"]
[null,"manganese (diet or non-diet source)",null,"extremely",null,"7439-96-5"]
[null,"mephosfolan",null,"extremely",null,"950-10-7"]
[null,"mepiquat chloride",null,null,null,"24307-26-4"]
[null,"mercuric chloride",null,"extremely",null,"7487-94-7"]
[null,"mercury","yes","extremely","extremely","7439-97-6"]
[null,"merphos",null,"extremely",null,"150-50-5"]
[null,"metalaxyl",null,null,null,"57837-19-1"]
[null,"methacrylonitrile","yes","extremely",null,"126-98-7"]
[null,"methamidosphos",null,"extremely",null,"10265-92-6"]
[null,"methanol","yes",null,null,"67-56-1"]
[null,"methidathion",null,"very",null,"950-37-8"]
[null,"methomyl",null,null,null,"16752-77-5"]
[null,"methoxy-5-nitroaniline;2-",null,null,null,"99-59-2"]
[null,"methoxychlor",null,null,"extremely","72-43-5"]
[null,"methoxyethanol acetate;2-",null,"very",null,"110-49-6"]
[null,"methoxyethanol;2-",null,null,null,"109-86-4"]
[null,"methyl acetate",null,null,null,"79-20-9"]
[null,"methyl acrylate",null,null,null,"96-33-3"]
[null,"methyl ethyl ketone","yes",null,null,"78-93-3"]
[null,"methyl isobutyl ketone","yes",null,null,"108-10-1"]
[null,"methyl mercury",null,"extremely","extremely","22967-92-6"]
[null,"methyl methacrylate","yes",null,null,"80-62-6"]
[null,"methyl naphthalene;1-",null,null,null,"90-12-0"]
[null,"methyl naphthalene;2-",null,"very",null,"91-57-6"]
[null,"methyl parathion",null,"extremely",null,"298-00-0"]
[null,"methyl styrene",null,null,null,"25013-15-4"]
[null,"methyl styrene, alpha",null,null,null,"98-83-9"]
[null,"methyl tert-butyl ether (MTBE)","yes",null,null,"1634-04-4"]
[null,"methyl-4-chlorophenoxy-acetic acid;2-",null,"very",null,"94-74-6"]
[null,"methyl-5-nitroaniline;2-",null,null,null,"99-55-8"]
[null,"methylaniline hydrochloride;2-",null,null,null,"636-21-5"]
[null,"methylaniline;2-",null,null,null,"95-53-4"]
[null,"methylene bis(2-chloroaniline);4,4'-",null,"very",null,"101-14-4"]
[null,"methylene bis(n,n'-dimethyl)aniline;4,4'-",null,null,null,"101-61-1"]
[null,"methylene bromide","yes","very",null,"74-95-3"]
[null,"methylene chloride","yes",null,null,"75-09-2"]
[null,"methylene diphenyl diisocyanate (MDI)",null,"very",null,"101-68-8"]
[null,"methylene diphenyl diisocyanate (polymeric) (PMDI)",null,"very",null,"9016-87-9"]
[null,"methylenebisbenzenamine;4,4-",null,"very",null,"101-77-9"]
[null,"methylhydrazine",null,"extremely",null,"60-34-4"]
[null,"metolachlor",null,null,null,"51218-45-2"]
[null,"metribuzin",null,null,null,"21087-64-9"]
[null,"mirex","yes","extremely","extremely","2385-85-5"]
[null,"molinate",null,"very",null,"2212-67-1"]
[null,"molybdenum",null,"very",null,"7439-98-7"]
[null,"monochloramine",null,null,null,"10599-90-3"]
[null,"naled",null,"very",null,"300-76-5"]
[null,"naphthalene","yes","very",null,"91-20-3"]
[null,"napropamide",null,null,null,"15299-99-7"]
[null,"n-butylbenzene",null,null,null,"104-51-8"]
[null,"nickel refinery dust",null,"extremely",null,"E715532"]
[null,"nickel soluble salts",null,"extremely",null,"7440-02-0"]
[null,"nickel subsulfide",null,"extremely",null,"12035-72-2"]
[null,"nitrate (measured as nitrogen)",null,null,null,"14797-55-8"]
[null,"nitrite (measured as nitrogen)",null,null,null,"14797-65-0"]
[null,"nitroaniline, 2-",null,"extremely",null,"88-74-4"]
[null,"nitroaniline, 4-",null,"very",null,"100-01-6"]
[null,"nitrobenzene",null,"very",null,"98-95-3"]
[null,"nitrofurantoin",null,null,null,"67-20-9"]
[null,"nitrofurazone",null,null,null,"59-87-0"]
[null,"nitroglycerin",null,"extremely",null,"55-63-0"]
[null,"nitroguanidine",null,null,null,"556-88-7"]
[null,"nitropropane;2-","yes","very",null,"79-46-9"]
[null,"nitrosodiethanolamine;N-",null,"very",null,"1116-54-7"]
[null,"nitrosodiethylamine;N-",null,"extremely",null,"55-18-5"]
[null,"nitrosodimethylamine;N-",null,"extremely",null,"62-75-9"]
[null,"nitroso-di-n-butylamine;N-",null,"extremely",null,"924-16-3"]
[null,"nitroso-di-n-propylamine;N-",null,"extremely",null,"621-64-7"]
[null,"nitrosodiphenylamine;N-",null,null,null,"86-30-6"]
[null,"nitroso-n-ethylurea;n-",null,"extremely",null,"759-73-9"]
[null,"nitroso-N-methylethylamine;N-",null,"extremely",null,"10595-95-6"]
[null,"nitroso-n-methylurea,n-",null,"extremely",null,"684-93-5"]
[null,"nitrosopyrrolidine;N-",null,"extremely",null,"930-55-2"]
[null,"nitrotoluene, m-",null,"extremely",null,"99-08-1"]
[null,"nitrotoluene, o-",null,"very",null,"88-72-2"]
[null,"nitrotoluene, p-",null,"very",null,"99-99-0"]
[null,"nonylphenol",null,null,null,"84852-15-3"]
[null,"norflurazon",null,"very",null,"27314-13-2"]
[null,"nustar",null,"very",null,"85509-19-9"]
[null,"octabromodiphenyl ether (OctaBDE)",null,null,null,"32536-52-0"]
[null,"octahydro-1,3,5,7-tetranitro-1,3,5,7-tetrazocine",null,null,null,"2691-41-0"]
[null,"octamethylpyrophosphoramide",null,"very",null,"152-16-9"]
[null,"oryzalin",null,null,null,"19044-88-3"]
[null,"oxadiazon",null,null,null,"19666-30-9"]
[null,"oxamyl",null,null,null,"23135-22-0"]
[null,"oxyfluorfen",null,null,null,"42874-03-3"]
[null,"paclobutrazol",null,null,null,"76738-62-0"]
[null,"paraquat dichloride",null,"very",null,"1910-42-5"]
[null,"parathion",null,null,"extremely","56-38-2"]
[null,"pebulate",null,null,null,"1114-71-2"]
[null,"pendimethalin",null,null,null,"40487-42-1"]
[null,"pentabromo-6-chloro-cyclohexane;1,2,3,4,5-",null,null,null,"87-84-3"]
[null,"pentabromodiphenyl ether; 2,2',4,4',5- (PBDE-99)",null,"extremely",null,"60348-60-9"]
[null,"pentabromodiphenyl ethers (PentaBDE)",null,"very",null,"32534-81-9"]
[null,"pentachlorobenzene",null,"very",null,"608-93-5"]
[null,"pentachloroethane",null,null,null,"76-01-7"]
[null,"pentachloronitrobenzene",null,"very",null,"82-68-8"]
[null,"pentachlorophenol",null,null,null,"87-86-5"]
[null,"pentaerythritol tetranitrate (PETN)",null,null,null,"78-11-5"]
[null,"pentane;n-",null,null,null,"109-66-0"]
[null,"perchlorate and perchlorate salts",null,"very",null,"14797-73-0"]
[null,"perfluorobutanesulfonic acid (PFBS)",null,"extremely",null,"375-73-5"]
[null,"perfluorobutanoic acid (PFBA)",null,"very",null,"375-22-4"]
[null,"perfluorohexanesulfonic acid (PFHxS)",null,"extremely",null,"355-46-4"]
[null,"perfluorononanoic acid (PFNA)",null,"extremely",null,"375-95-1"]
[null,"perfluorooctanesulfonic acid (PFOS)",null,"extremely",null,"1763-23-1"]
[null,"perfluorooctanoic acid (PFOA)",null,"extremely",null,"335-67-1"]
[null,"permethrin",null,null,null,"52645-53-1"]
[null,"phenmedipham",null,null,null,"13684-63-4"]
[null,"phenol",null,null,null,"108-95-2"]
[null,"phenylenediamine, p-",null,"very",null,"106-50-3"]
[null,"phenylenediamine;m-",null,null,null,"108-45-2"]
[null,"phenylenediamine;o-",null,"very",null,"95-54-5"]
[null,"phenylmercuric acetate",null,"extremely",null,"62-38-4"]
[null,"phenylphenol;2-",null,null,null,"90-43-7"]
[null,"phorate",null,"extremely",null,"298-02-2"]
[null,"phosgene","yes","extremely",null,"75-44-5"]
[null,"phosmet",null,null,null,"732-11-6"]
[null,"phosphine",null,"extremely",null,"7803-51-2"]
[null,"phosphoric acid",null,null,null,"7664-38-2"]
[null,"phosphorus",null,"extremely",null,"7723-14-0"]
[null,"phthalic acid;p-",null,null,null,"100-21-0"]
[null,"phthalic anhydride",null,null,null,"85-44-9"]
[null,"picloram",null,null,null,"1918-02-01"]
[null,"pirimiphos-methyl",null,"very",null,"29232-93-7"]
[null,"polybrominated biphenyls",null,"extremely",null,"36355-01-8"]
[null,"polychlorinated biphenyls (PCBs)",null,"extremely","extremely","1336-36-3"]
[null,"potassium cyanide",null,"very",null,"151-50-8"]
[null,"potassium perchlorate",null,"very",null,"7778-74-7"]
[null,"potassium silver cyanide",null,null,null,"506-61-6"]
[null,"prochloraz",null,null,null,"67747-09-5"]
[null,"profluralin",null,null,null,"26399-36-0"]
[null,"prometon",null,null,null,"1610-18-0"]
[null,"prometryn",null,null,null,"7287-19-6"]
[null,"pronamide",null,null,null,"23950-58-5"]
[null,"propachlor",null,null,null,"1918-16-7"]
[null,"propanil",null,null,null,"709-98-8"]
[null,"propargite",null,null,null,"2312-35-8"]
[null,"propargyl alcohol",null,"very",null,"107-19-7"]
[null,"propazine",null,null,null,"139-40-2"]
[null,"propham",null,null,null,"122-42-9"]
[null,"propiconazole",null,null,null,"60207-90-1"]
[null,"propionaldehyde","yes",null,null,"123-38-6"]
[null,"propionic acid;(2-methyl-4-chlorophenoxy)2-",null,"very",null,"93-65-2"]
[null,"propylbenzene;n-","yes",null,null,"103-65-1"]
[null,"propylene glycol",null,null,null,"57-55-6"]
[null,"propylene glycol dinitrate;1,2-",null,"extremely",null,"6423-43-4"]
[null,"propylene glycol monoethyl ether",null,null,null,"52125-53-8"]
[null,"propylene glycol monomethyl ether (PGME)",null,null,null,"107-98-2"]
[null,"propylene oxide",null,null,null,"75-56-9"]
[null,"pursuit",null,null,null,"81335-77-5"]
[null,"pydrin",null,null,null,"51630-58-1"]
[null,"pyrene",null,null,null,"129-00-0"]
[null,"pyridine",null,"very",null,"110-86-1"]
[null,"quinalphos",null,"very",null,"13593-03-8"]
[null,"quinoline",null,"very",null,"91-22-5"]
[null,"radium 226",null,"extremely","extremely","13982-63-3"]
[null,"radium 228",null,"extremely","extremely","15262-20-1"]
[null,"RDX",null,"very",null,"121-82-4"]
[null,"refractory ceramic fibers",null,"extremely",null,"E715557"]
[null,"resmethrin",null,null,null,"10453-86-8"]
[null,"ronnel",null,null,null,"299-84-3"]
[null,"rotenone",null,"very",null,"83-79-4"]
[null,"s,s,s-tributylphosphorotrithioate",null,"extremely",null,"78-48-8"]
[null,"savey",null,null,null,"78587-05-0"]
[null,"sec-butylbenzene",null,null,null,"135-98-8"]
[null,"selenious acid",null,null,null,"7783-00-8"]
[null,"selenium and compounds",null,null,null,"7782-49-2"]
[null,"sethoxydim",null,null,null,"74051-80-2"]
[null,"silver",null,null,"extremely","7440-22-4"]
[null,"silver cyanide",null,null,null,"506-64-9"]
[null,"simazine",null,null,null,"122-34-9"]
[null,"sodium azide",null,"very",null,"26628-22-8"]
[null,"sodium cyanide",null,"very",null,"143-33-9"]
[null,"sodium diethyldithiocarbamate",null,null,null,"148-18-5"]
[null,"sodium fluoroacetate",null,"extremely",null,"62-74-8"]
[null,"sodium metavanadate",null,"very",null,"13718-26-8"]
[null,"sodium perchlorate",null,"very",null,"7601-89-0"]
[null,"strontium",null,null,null,"7440-24-6"]
[null,"strychnine",null,"extremely",null,"57-24-9"]
[null,"styrene","yes",null,null,"100-42-5"]
[null,"systhane",null,null,null,"88671-89-0"]
[null,"TCDD;2,3,7,8- (use for dioxin/furan TEQ)",null,"extremely",null,"1746-01-6"]
[null,"tebuthiuron",null,null,null,"34014-18-1"]
[null,"temephos",null,null,null,"3383-96-8"]
[null,"terbacil",null,null,null,"5902-51-2"]
[null,"terbufos",null,"extremely",null,"13071-79-9"]
[null,"terbutryn",null,"very",null,"886-50-0"]
[null,"tert-butylbenzene",null,null,null,"98-06-6"]
[null,"tetrabromodiphenyl ether 2,2',4,4' (PBDE-47)",null,"extremely",null,"5436-43-1"]
[null,"tetrachlorobenzene;1,2,4,5-",null,"extremely",null,"95-94-3"]
[null,"tetrachloroethane;1,1,1,2-","yes",null,null,"630-20-6"]
[null,"tetrachloroethane;1,1,2,2-","yes",null,null,"79-34-5"]
[null,"tetrachloroethylene (PCE)","yes",null,null,"127-18-4"]
[null,"tetrachlorophenol;2,3,4,6-",null,null,null,"58-90-2"]
[null,"tetrachlorotoluene;p,a,a,a,-",null,"extremely",null,"5216-25-1"]
[null,"tetrachlorvinphos",null,null,null,"961-11-5"]
[null,"tetraethyl dithiopyrophosphate",null,"very",null,"3689-24-5"]
[null,"tetraethyl lead",null,"extremely",null,"78-00-2"]
[null,"tetrafluoroethane;1,1,1,2-",null,null,null,"811-97-2"]
[null,"tetrahydrofuran","yes",null,null,"109-99-9"]
[null,"thallic oxide",null,"extremely",null,"1314-32-5"]
[null,"thallium acetate",null,"extremely",null,"563-68-8"]
[null,"thallium carbonate",null,"extremely",null,"6533-73-9"]
[null,"thallium chloride",null,"extremely",null,"7791-12-0"]
[null,"thallium nitrate",null,"extremely",null,"10102-45-1"]
[null,"thallium selenite",null,"extremely",null,"12039-52-0"]
[null,"thallium(I) sulfate",null,"extremely",null,"7446-18-6"]
[null,"thallium, soluble salts",null,"extremely",null,"7440-28-0"]
[null,"thiobencarb",null,null,null,"28249-77-6"]
[null,"thiocyanomethylthiobenzothiazole;2-",null,null,null,"21564-17-0"]
[null,"thiofanox",null,"extremely",null,"39196-18-4"]
[null,"thiophanate-methyl",null,null,null,"23564-05-8"]
[null,"thiram",null,null,null,"137-26-8"]
[null,"tin",null,null,null,"7440-31-5"]
[null,"TNT",null,null,null,"118-96-7"]
[null,"toluene","yes",null,null,"108-88-3"]
[null,"toluene diisocyanate mixture;2,4-/2,6-",null,"extremely",null,"26471-62-5"]
[null,"toluene-2,4-diisocyanate",null,"extremely",null,"584-84-9"]
[null,"toluene-2,6-diisocyanate",null,"extremely",null,"91-08-7"]
[null,"toluenediamine;2,5-",null,null,null,"95-70-5"]
[null,"toluidine;p-",null,null,null,"106-49-0"]
[null,"Total Petroleum Hydrocarbons (TPH), gas,","some",null,null,"none"]
[null,"toxaphene",null,"extremely","extremely","8001-35-2"]
[null,"TP;2,4,5-",null,null,null,"93-72-1"]
[null,"tralomethrin",null,null,null,"66841-25-6"]
[null,"triallate",null,null,null,"2303-17-5"]
[null,"triasulfuron",null,null,null,"82097-50-5"]
[null,"tribromobenzene;1,2,4-",null,null,null,"615-54-3"]
[null,"tributyltin",null,"very","extremely","688-73-3"]
[null,"tributyltin oxide",null,"extremely",null,"56-35-9"]
[null,"trichloramine",null,null,null,"10025-85-1"]
[null,"trichloro-1,2,2-trifluoroethane;1,1,2-","yes",null,null,"76-13-1"]
[null,"trichloroacetic acid",null,null,null,"76-03-9"]
[null,"trichloroaniline hydrochloride;2,4,6-",null,null,null,"33663-50-2"]
[null,"trichloroaniline;2,4,6-",null,"extremely",null,"634-93-5"]
[null,"trichlorobenzene;1,2,3-",null,"very",null,"87-61-6"]
[null,"trichlorobenzene;1,2,4-","yes","very",null,"120-82-1"]
[null,"trichloroethane;1,1,1-","yes",null,null,"71-55-6"]
[null,"trichloroethane;1,1,2-","yes","very",null,"79-00-5"]
[null,"trichloroethylene (TCE)","yes","very",null,"79-01-6"]
[null,"trichlorofluoromethane","yes",null,null,"75-69-4"]
[null,"trichlorophenol;2,4,5-",null,null,null,"95-95-4"]
[null,"trichlorophenol;2,4,6-",null,"very",null,"88-06-2"]
[null,"trichlorophenoxyacetic acid;2,4,5-",null,null,null,"93-76-5"]
[null,"trichloropropane;1,1,2-",null,null,null,"598-77-6"]
[null,"trichloropropane;1,2,3-","yes","extremely",null,"96-18-4"]
[null,"trichloropropene;1,2,3-",null,"extremely",null,"96-19-5"]
[null,"tridiphane",null,"very",null,"58138-08-2"]
[null,"triethylamine","yes",null,null,"121-44-8"]
[null,"trifluralin",null,null,null,"1582-09-8"]
[null,"trihalomethanes, (total) (TTHMs)",null,null,null,"none"]
[null,"trimethyl phosphate",null,null,null,"512-56-1"]
[null,"trimethylbenzene;1,2,3-","yes",null,null,"526-73-8"]
[null,"trimethylbenzene;1,2,4-","yes",null,null,"95-63-6"]
[null,"trimethylbenzene;1,3,5-","yes",null,null,"108-67-8"]
[null,"trinitrobenzene;1,3,5-",null,null,null,"99-35-4"]
[null,"trinitrophenylmethylnitramine",null,"very",null,"479-45-8"]
[null,"uranium, soluble salts",null,"extremely",null,"7440-61-1"]
[null,"vanadium",null,"extremely",null,"7440-62-2"]
[null,"vanadium pentoxide",null,"extremely",null,"1314-62-1"]
[null,"vernam",null,"very",null,"1929-77-7"]
[null,"vinclozolin",null,"very",null,"50471-44-8"]
[null,"vinyl acetate","yes",null,null,"108-05-4"]
[null,"vinyl chloride","yes","extremely",null,"75-01-4"]
[null,"warfarin",null,"extremely",null,"81-81-2"]
[null,"white mineral oil",null,null,null,"8012-95-1"]
[null,"xylene;m-",null,null,null,"108-38-3"]
[null,"xylene;o-",null,null,null,"95-47-6"]
[null,"xylene;p-",null,null,null,"106-42-3"]
[null,"xylenes","yes",null,null,"1330-20-7"]
[null,"zinc",null,null,null,"7440-66-6"]
[null,"zinc cyanide",null,null,null,"557-21-1"]
[null,"zinc phosphide",null,"extremely",null,"1314-84-7"]
[null,"zineb",null,null,null,"12122-67-7"]

{"sheet":"Codes","index":12,"n_rows":94,"n_cols":4,"rows_kept":94,"cut":false,"hidden":true,"merged":[]}
[null,"Assessor Name",{"$f":"Assessor","v":"Sara Fulton"},{"$f":"C1","v":"Sara Fulton"}]
[null,"Time (hrs) ="]
[null,"Version","2024.02.02A"]
[]
[null,"Reference","Answers","Scores"]
[null,"SL_Ex1",{"$f":"SL_Ex1_Ans","v":"maybe"},{"$f":"SL_Ex1_Score","v":"continue"}]
[null,"SL_Ex2",{"$f":"SL_Ex2_Ans","v":"maybe"},{"$f":"SL_Ex2_Score","v":"B"}]
[null,"SL_Ex3",{"$f":"SL_Ex3_Ans","v":"no"},{"$f":"SL_Ex3_Score","v":"D"}]
[null,"SL_Ex4",{"$f":"SL_Ex4_Ans","v":"yes"},{"$f":"SL_Ex4_Score","v":"C"}]
[null,"SL_Sv1",{"$f":"SL_Sv1_Ans","v":"no"},{"$f":"SL_Sv1_Score","v":0}]
[null,"SL_Sv2",{"$f":"SL_Sv2_Ans","v":"no"},{"$f":"SL_Sv2_Score","v":0}]
[null,"SL_Sv3",{"$f":"SL_Sv3_Ans","v":"no"},{"$f":"SL_Sv3_Score","v":0}]
[null,"SL_Sv4",{"$f":"SL_Sv4_Ans","v":"no"},{"$f":"SL_Sv4_Score","v":0}]
[null,"SL_Sv5",{"$f":"SL_Sv5_Ans","v":"no"},{"$f":"SL_Sv5_Score","v":0}]
[null,"SL_Sv6",{"$f":"SL_Sv6_Ans","v":"maybe"},{"$f":"SL_Sv6_Score","v":3}]
[null,"SL_Sv7",{"$f":"SL_Sv7_Ans","v":"no"},{"$f":"SL_Sv7_Score","v":0}]
[null,"GW_Ex1",{"$f":"GW_Ex1_Ans","v":"maybe"},{"$f":"GW_Ex1_Score","v":"continue"}]
[null,"GW_Ex2",{"$f":"GW_Ex2_Ans","v":"maybe"},{"$f":"GW_Ex2_Score","v":"B"}]
[null,"GW_Sv1",{"$f":"GW_Sv1_Ans","v":"no"},{"$f":"GW_Sv1_Score","v":0}]
[null,"GW_Sv2",{"$f":"GW_Sv2_Ans","v":"no"},{"$f":"GW_Sv2_Score","v":0}]
[null,"GW_Sv3",{"$f":"GW_Sv3_Ans","v":"no"},{"$f":"GW_Sv3_Score","v":0}]
[null,"GW_Sv4",{"$f":"GW_Sv4_Ans","v":"no"},{"$f":"GW_Sv4_Score","v":0}]
[null,"GW_Sv5",{"$f":"GW_Sv5_Ans","v":"maybe"},{"$f":"GW_Sv5_Score","v":3}]
[null,"GW_Sv6",{"$f":"GW_Sv6_Ans","v":"no"},{"$f":"GW_Sv6_Score","v":0}]
[null,"GW_Sv7",{"$f":"GW_Sv7_Ans","v":"maybe"},{"$f":"GW_Sv7_Score","v":3}]
[null,"GW_Sv8",{"$f":"GW_Sv8_Ans","v":"no"},{"$f":"GW_Sv8_Score","v":0}]
[null,"SW_Ex1",{"$f":"SW_Ex1_Ans","v":"no"},{"$f":"SW_Ex1_Score","v":"D"}]
[null,"SW_Ex2",{"$f":"SW_Ex2_Ans","v":"menu ▼"},{"$f":"SW_Ex2_Score","v":"SKIP"}]
[null,"SW_Ex3",{"$f":"SW_Ex3_Ans","v":"menu ▼"},{"$f":"SW_Ex3_Score","v":"SKIP"}]
[null,"SW_Ex4",{"$f":"SW_Ex4_Ans","v":"menu ▼"},{"$f":"SW_Ex4_Score","v":"SKIP"}]
[null,"SW_Sv1",{"$f":"SW_Sv1_Ans","v":"menu ▼"},{"$f":"SW_Sv1_Score","v":"SKIP"}]
[null,"SW_Sv2",{"$f":"SW_Sv2_Ans","v":"menu ▼"},{"$f":"SW_Sv2_Score","v":"SKIP"}]
[null,"SW_Sv3",{"$f":"SW_Sv3_Ans","v":"menu ▼"},{"$f":"SW_Sv3_Score","v":"SKIP"}]
[null,"SW_Sv4",{"$f":"SW_Sv4_Ans","v":"menu ▼"},{"$f":"SW_Sv4_Score","v":"SKIP"}]
[null,"SW_Sv5",{"$f":"SW_Sv5_Ans","v":"menu ▼"},{"$f":"SW_Sv5_Score","v":"SKIP"}]
[null,"SD_Ex1",{"$f":"SD_Ex1_Ans","v":"menu ▼"},{"$f":"SD_Ex1_Score","v":"D"}]
[null,"SD_Ex2",{"$f":"SD_Ex2_Ans","v":"menu ▼"},{"$f":"SD_Ex2_Score","v":"SKIP"}]
[null,"SD_Ex3",{"$f":"SD_Ex3_Ans","v":"menu ▼"},{"$f":"SD_Ex3_Score","v":"SKIP"}]
[null,"SD_Ex4",{"$f":"SD_Ex4_Ans","v":"menu ▼"},{"$f":"SD_Ex4_Score","v":"SKIP"}]
[null,"SD_Ex5",{"$f":"SD_Ex5_Ans","v":"menu ▼"},{"$f":"SD_Ex5_Score","v":"SKIP"}]
[null,"SD_Sv1",{"$f":"SD_Sv1_Ans","v":"menu ▼"},{"$f":"SD_Sv1_Score","v":"SKIP"}]
[null,"SD_Sv2",{"$f":"SD_Sv2_Ans","v":"menu ▼"},{"$f":"SD_Sv2_Score","v":"SKIP"}]
[null,"SD_Sv3",{"$f":"SD_Sv3_Ans","v":"menu ▼"},{"$f":"SD_Sv3_Score","v":"SKIP"}]
[null,"SD_Sv4",{"$f":"SD_Sv4_Ans","v":"menu ▼"},{"$f":"SD_Sv4_Score","v":"SKIP"}]
[null,"SD_Sv5",{"$f":"SD_Sv5_Ans","v":"menu ▼"},{"$f":"SD_Sv5_Score","v":"SKIP"}]
[null,"SD_Sv6",{"$f":"SD_Sv6_Ans","v":"menu ▼"},{"$f":"SD_Sv6_Score","v":"SKIP"}]
[null,"IA_Ex1",{"$f":"IA_Ex1_Ans","v":"no"},{"$f":"IA_Ex1_Score","v":"D"}]
[null,"IA_Ex2",{"$f":"IA_Ex2_Ans","v":"menu ▼"},{"$f":"IA_Ex2_Score","v":"SKIP"}]
[null,"IA_Ex3",{"$f":"IA_Ex3_Ans","v":"menu ▼"},{"$f":"IA_Ex3_Score","v":"SKIP"}]
[null,"IA_Ex4",{"$f":"IA_Ex4_Ans","v":"menu ▼"},{"$f":"IA_Ex4_Score","v":"SKIP"}]
[null,"IA_Sv1",{"$f":"IA_Sv1_Ans","v":"menu ▼"},{"$f":"IA_Sv1_Score","v":"SKIP"}]
[null,"IA_Sv2",{"$f":"IA_Sv2_Ans","v":"menu ▼"},{"$f":"IA_Sv2_Score","v":"SKIP"}]
[null,"IA_Sv3",{"$f":"IA_Sv3_Ans","v":"menu ▼"},{"$f":"IA_Sv3_Score","v":"SKIP"}]
[]
[null,"SL_Conf",{"$f":"SL_Conf","v":"medium"}]
[null,"GW_Conf",{"$f":"GW_Conf","v":"medium"}]
[null,"SW_Conf",{"$f":"SW_Conf","v":"high"}]
[null,"SD_Conf",{"$f":"SD_Conf","v":"high"}]
[null,"IA_Conf",{"$f":"IA_Conf","v":"medium"}]
[]
[null,"AF_1",{"$f":"AF_1Ans","v":"no"}]
[null,"AF_2",{"$f":"AF_2Ans","v":"maybe"}]
[null,"AF_3",{"$f":"AF_3Ans","v":"no"}]
[null,"AF_4",{"$f":"AF_4Ans","v":"no"}]
[]
[null,"LD_DemoIndex",{"$f":"LD_P80_DemoIndex","v":95}]
[null,"LD_SubDemoIndex",{"$f":"LD_P80_SubDemoIndex","v":89}]
[null,"LD_Color",{"$f":"LD_P80_Color","v":97}]
[null,"LD_Income",{"$f":"LD_P80_Income","v":80}]
[null,"LD_Unemployed",{"$f":"LD_P80_Unemployed","v":49}]
[null,"LD_English",{"$f":"LD_P80_English","v":92}]
[null,"LD_School",{"$f":"LD_P80_School","v":95}]
[null,"LD_Under5",{"$f":"LD_P80_Under5","v":86}]
[null,"LD_Over64",{"$f":"LD_P80_Over64","v":17}]
[null,"LD_LowLife",{"$f":"LD_P80_LowLife","v":17}]
[null,"EHDRank",{"$f":"EHDRank","v":10}]
[null,"LD_Confidence",{"$f":"LD_Confidence","v":"low"}]
[null,"LD_Override",{"$f":"LD_Override","v":"no"}]
[]
[null,"CSID",{"$f":"CSID","v":"17003"}]
[null,"Date",{"$f":"AssessDate","v":"2024-03-04"}]
[]
[null,"Land use",{"$f":"Landuse","v":"menu ▼"}]
[null,"MTCA milestone",{"$f":"CleanupMilestone","v":"initial investigation"}]
[null,"SL_ExScore",{"$f":"SL_ExScore","v":"C"}]
[null,"SL_SvScore",{"$f":"SL_SvScore","v":4}]
[null,"GW_ExScore",{"$f":"GW_ExScore","v":"B"}]
[null,"GW_SvScore",{"$f":"GW_SvScore","v":4}]
[null,"SW_ExScore",{"$f":"SW_ExScore","v":"D"}]
[null,"SW_SvScore",{"$f":"SW_SvScore","v":"4"}]
[null,"SD_ExScore",{"$f":"SD_ExScore","v":"D"}]
[null,"SD_SvScore",{"$f":"SD_SvScore","v":"4"}]
[null,"IA_ExScore",{"$f":"IA_ExScore","v":"D"}]
[null,"IA_SvScore",{"$f":"IA_SvScore","v":"4"}]

{"sheet":"Rating","index":13,"n_rows":38,"n_cols":28,"rows_kept":38,"cut":false,"hidden":true,"merged":[[22,5,22,9],[1,5,1,8]]}
[]
[null,null,"SHARP Rating",null,null,{"$f":"IF(OR(ConfIA=\"menu ▼\",ConfGW=\"menu ▼\",ConfSL=\"menu ▼\",ConfSW=\"menu ▼\",ConfSD=\"menu ▼\",LD_Confidence=\"menu ▼\"),\"SHARPen it\",\n\nIF(A_Count=1,\"Medium\",\nIF(A_Count=2,\"High\",\nIF(A_Count>2,\"Critical\",\n\nIF(SitePoints<ThresholdLow,\"Low\",\nIF(AND(SitePoints>ThresholdLowMed,SitePoints<ThresholdMedHi),\" Medium\",\nIF(SitePoints>ThresholdMedHi,\" High\",\"\")))))))","v":"Low"}]
[]
[null,null,null,"SHARP Results - auto-populated from ranking results",null,null,null,null,null,null,null,null,null,null,null,null,"SHARP Rating calculations"]
[null,null,null,"Ranking scores and confidence levels (auto-populated)",null,null,null,null,null,null,null,null,null,null,null,null,"Site totals"]
[null,null,null,null,"Media exposure priority","IA","GW","SL","SW","SD",null,null,null,null,null,null,2,"Maximum possible points",null,null,null,null,null,null,null,{"$f":"SUM(Max_IA,Max_GW,Max_SL,Max_SW,Max_SD)","v":3500},null,"MaxPts"]
[null,null,null,null,"Exposure scores (A-D)",{"$f":"IA_ExScore","v":"D"},{"$f":"GW_ExScore","v":"B"},{"$f":"SL_ExScore","v":"C"},{"$f":"SW_ExScore","v":"D"},{"$f":"SD_ExScore","v":"D"},null,"ExpScore",null,null,null,null,{"$f":"Q6+0.1","v":2.1},"Total points",null,null,null,null,null,null,null,{"$f":"SUM(ExWtSv_IA,ExWtSv_GW,ExWtSv_SL,ExWtSv_SW,ExWtSv_SD)","v":0},null,"SitePoints"]
[null,null,null,null,"Severity scores (1-4)",{"$f":"IA_SvScore","v":"4"},{"$f":"GW_SvScore","v":4},{"$f":"SL_SvScore","v":4},{"$f":"SW_SvScore","v":"4"},{"$f":"SD_SvScore","v":"4"},null,"SevScore",null,null,null,null,{"$f":"Q7+0.1","v":2.2000000000000002},"# of \"A\" exposures",null,null,null,null,null,null,null,{"$f":"COUNTIFS(ExpScore_IA:ExpScore_SD,\"=A\")","v":0},null,"A_Count"]
[null,null,null,null,"Confidence levels (L-M-H)",{"$f":"IA_Conf","v":"medium"},{"$f":"GW_Conf","v":"medium"},{"$f":"SL_Conf","v":"medium"},{"$f":"SW_Conf","v":"high"},{"$f":"SD_Conf","v":"high"},null,"Conf",null,null,null,null,{"$f":"Q8+0.1","v":2.3000000000000003},"Maximum possible points divided by 3 (ranges)",null,null,null,null,null,null,null,{"$f":"ThresholdMedHi-ThresholdLowMed","v":1167.6666666666667},null,"RangeValue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q9+0.1","v":2.4000000000000004},"Range levels bumped by # of \"A's\"",null,null,null,null,null,null,null,{"$f":"IF((A_Count=1),SitePoints+RangeValue,\nIF((A_Count>=2),SitePoints+ThresholdMedHi,\"no A's\"))","v":"no A's"},null,"BumpedValue"]
[]
[]
[null,null,null,"Preparing the Report — exposure score conversions and weighting",null,null,null,null,null,null,null,null,null,null,null,null,null,"SHARP Rating Ranges"]
[null,null,null,"Maximum possible points and media exposure priorities",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q10+0.1","v":2.5000000000000004},"low",null,"medium",null,null,"high",null,"critical (>2 A's)"]
[null,null,null,1,{"$f":"E6","v":"Media exposure priority"},"IA","GW","SL","SW","SD",null,null,null,null,null,null,{"$f":"Q14+0.1","v":2.6000000000000005},"< ",{"$f":"(SUM(Max_IA,Max_GW,Max_SL,Max_SW,Max_SD)/3)+1","v":1167.6666666666667},{"$f":"S15","v":1167.6666666666667},"—",{"$f":"2*T15","v":2335.3333333333335},"> ",{"$f":"V15","v":2335.3333333333335},{"$f":"IF(A_Count>2,\">2 A's\",\"N/A\")","v":"N/A"}]
[null,null,null,{"$f":"D15+0.1","v":1.1000000000000001},"Maximum possible points for media",{"$f":"4*ExpPriority_IA*5*5","v":900},{"$f":"4*ExpPriority_GW*5*5","v":800},{"$f":"4*ExpPriority_SL*5*5","v":700},{"$f":"4*ExpPriority_SW*5*5","v":600},{"$f":"4*ExpPriority_SD*5*5","v":500},null,"Max"]
[null,null,null,{"$f":"D16+0.1","v":1.2000000000000002},"Exposure priority weights for \"A's\"",9,8,7,6,5,null,"ExpPriority",null,null,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Maximum, possible total site points, if all environmental media scores are \"A1\""]
[null,null,null,"Source values and conversions",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18+0.1","v":2.1},"Total number of points earned for this site"]
[null,null,null,{"$f":"D17+0.1","v":1.3000000000000003},"Exposure points for exposure scores",{"$f":"IF(ExpScore_IA=\"A\",4,\nIF(ExpScore_IA=\"B\",3,\nIF(ExpScore_IA=\"C\",2,\nIF(ExpScore_IA=\"D\",1,\"\"))))","v":1},{"$f":"IF(ExpScore_GW=\"A\",4,\nIF(ExpScore_GW=\"B\",3,\nIF(ExpScore_GW=\"C\",2,\nIF(ExpScore_GW=\"D\",1,\"\"))))","v":3},{"$f":"IF(ExpScore_SL=\"A\",4,\nIF(ExpScore_SL=\"B\",3,\nIF(ExpScore_SL=\"C\",2,\nIF(ExpScore_SL=\"D\",1,\"\"))))","v":2},{"$f":"IF(ExpScore_SW=\"A\",4,\nIF(ExpScore_SW=\"B\",3,\nIF(ExpScore_SW=\"C\",2,\nIF(ExpScore_SW=\"D\",1,\"\"))))","v":1},{"$f":"IF(ExpScore_SD=\"A\",4,\nIF(ExpScore_SD=\"B\",3,\nIF(ExpScore_SD=\"C\",2,\nIF(ExpScore_SD=\"D\",1,\"\"))))","v":1},null,"ExpPts",null,null,null,null,{"$f":"Q19+0.1","v":2.2000000000000002},"Total number of \"A\" exposures for the site"]
[null,null,null,{"$f":"D20+0.1","v":1.4000000000000004},"Non-D routes (binary, yes = 1, no = 0)",{"$f":"IF(OR(ExpScore_IA=\"A\",ExpScore_IA=\"B\",ExpScore_IA=\"C\"),1,0)","v":0},{"$f":"IF(OR(ExpScore_GW=\"A\",ExpScore_GW=\"B\",ExpScore_GW=\"C\"),1,0)","v":1},{"$f":"IF(OR(ExpScore_SL=\"A\",ExpScore_SL=\"B\",ExpScore_SL=\"C\"),1,0)","v":1},{"$f":"IF(OR(ExpScore_SW=\"A\",ExpScore_SW=\"B\",ExpScore_SW=\"C\"),1,0)","v":0},{"$f":"IF(OR(ExpScore_SD=\"A\",ExpScore_SD=\"B\",ExpScore_SD=\"C\"),1,0)","v":0},null,"Non_D",null,null,null,null,2.2999999999999998,"Maximum possible points divided into three ranges"]
[null,null,null,{"$f":"D21+0.1","v":1.5000000000000004},"Severity points for severity scores",{"$f":"IF(AND(ExpScore_IA=\"A\",SvScore_IA=4),\"error\",\nIF(SvScore_IA=4,0,\nIF(SvScore_IA=3,1,\nIF(SvScore_IA=2,3,\nIF(SvScore_IA=1,5,0)))))","v":0},{"$f":"IF(AND(ExpScore_GW=\"A\",SvScore_GW=4),\"error\",\nIF(SvScore_GW=4,0,\nIF(SvScore_GW=3,1,\nIF(SvScore_GW=2,3,\nIF(SvScore_GW=1,5,0)))))","v":0},{"$f":"IF(AND(ExpScore_SL=\"A\",SvScore_SL=4),\"error\",\nIF(SvScore_SL=4,0,\nIF(SvScore_SL=3,1,\nIF(SvScore_SL=2,3,\nIF(SvScore_SL=1,5,0)))))","v":0},{"$f":"IF(AND(ExpScore_SW=\"A\",SvScore_SW=4),\"error\",\nIF(SvScore_SW=4,0,\nIF(SvScore_SW=3,1,\nIF(SvScore_SW=2,3,\nIF(SvScore_SW=1,5,0)))))","v":0},{"$f":"IF(AND(ExpScore_SD=\"A\",SvScore_SD=4),\"error\",\nIF(SvScore_SD=4,0,\nIF(SvScore_SD=3,1,\nIF(SvScore_SD=2,3,\nIF(SvScore_SD=1,5,0)))))","v":0},null,"SvPts",null,null,null,null,2.4,"Total points plus number of range value bumps (by # of \"A's\"), where:"]
[null,null,null,{"$f":"D22+0.1","v":1.6000000000000005},"Sum of Non-D routes",{"$f":"SUM(F21:J21)","v":2},null,null,null,null,null,"NonDSum",null,null,null,null,null,"One \"A\" ensures no less than medium."]
[null,null,null,{"$f":"D23+0.1","v":1.7000000000000006},"Total points by medium",{"$f":"IF(Non_D_IA=0,0,\nIF(ExpPts_IA=4,ExpPts_IA*SvPts_IA*NonDSum*ExpPriority_IA,\nIF(ExpPts_IA=3,ExpPts_IA*SvPts_IA*NonDSum,\nIF(ExpPts_IA=2,ExpPts_IA*SvPts_IA*NonDSum,\nIF(ExpPts_IA=1,ExpPts_IA*SvPts_IA*NonDSum,\"\")))))","v":0},{"$f":"IF(Non_D_GW=0,0,\nIF(ExpPts_GW=4,ExpPts_GW*SvPts_GW*NonDSum*ExpPriority_GW,\nIF(ExpPts_GW=3,ExpPts_GW*SvPts_GW*NonDSum,\nIF(ExpPts_GW=2,ExpPts_GW*SvPts_GW*NonDSum,\nIF(ExpPts_GW=1,ExpPts_GW*SvPts_GW*NonDSum,\"\")))))","v":0},{"$f":"IF(Non_D_SL=0,0,\nIF(ExpPts_SL=4,ExpPts_SL*SvPts_SL*NonDSum*ExpPriority_SL,\nIF(ExpPts_SL=3,ExpPts_SL*SvPts_SL*NonDSum,\nIF(ExpPts_SL=2,ExpPts_SL*SvPts_SL*NonDSum,\nIF(ExpPts_SL=1,ExpPts_SL*SvPts_SL*NonDSum,\"\")))))","v":0},{"$f":"IF(Non_D_SW=0,0,\nIF(ExpPts_SW=4,ExpPts_SW*SvPts_SW*NonDSum*ExpPriority_SW,\nIF(ExpPts_SW=3,ExpPts_SW*SvPts_SW*NonDSum,\nIF(ExpPts_SW=2,ExpPts_SW*SvPts_SW*NonDSum,\nIF(ExpPts_SW=1,ExpPts_SW*SvPts_SW*NonDSum,\"\")))))","v":0},{"$f":"IF(Non_D_SD=0,0,\nIF(ExpPts_SD=4,ExpPts_SD*SvPts_SD*NonDSum*ExpPriority_SD,\nIF(ExpPts_SD=3,ExpPts_SD*SvPts_SD*NonDSum,\nIF(ExpPts_SD=2,ExpPts_SD*SvPts_SD*NonDSum,\nIF(ExpPts_SD=1,ExpPts_SD*SvPts_SD*NonDSum,\"\")))))","v":0},null,"ExWtSv",null,null,null,null,null,"Two \"A's\" ensure a high."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Three or more \"A's\" ensure a critical."]
[null,null,null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,2.5,"SHARP Rating ranges of \"low\", \"medium\", and \"high\""]
[null,null,null,1,"Listed in order of highest to lowest exposure priority from left to right.",null,null,null,null,null,null,null,null,null,null,null,2.6,"Maximum possible points by \"3\"."]
[null,null,null,{"$f":"D27+0.1","v":1.1000000000000001},"Maximum possible points (all \"A1's\") per environmental medium (= 4*ExpPriority_IA*5*5), where:"]
[null,null,null,null,"4 = SevPts (for severity scores = \"1\")"]
[null,null,null,null,"ExpPriority = highest to lowest exposure priority [IA to SD], left to right"]
[null,null,null,null,"the first \"5\" = an \"A\" exposure score for all five media"]
[null,null,null,null,"the second \"5\" = the maximum possible number of \"A's\""]
[null,null,null,{"$f":"D28+0.1","v":1.2000000000000002},"Weights media in order of exposure priority from left to right, highest to lowest exposure risk."]
[null,null,null,{"$f":"D33+0.1","v":1.3000000000000003},"Assigns respective values of \"4\", \"3\", \"2\", and \"1\" to alpha exposure scores of \"A\", \"B\", \"C\", and \"D\"."]
[null,null,null,1.4000000000000004,"Non-\"D\" exposure scores are counted as \"1\". \"D\" scores are counted as \"0\"."]
[null,null,null,1.5000000000000004,"Weights severity scores of \"4\", \"3\", \"2\", and \"1\" to \"0\", \"1\", \"3\", and \"5\", respectively."]
[null,null,null,1.6000000000000005,"Counts the total of non-\"D\" exposure scores."]
[null,null,null,1.7000000000000006,"Total points earned for each environmental medium: (ExpPriority)(ExpPts)(SvPts)(NonDSum)"]

{"sheet":"Lists","index":14,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Input Lists"]
[]
[null,null,"Counties list (39)",null,"Land Use (10)",null,"ISIS Responsible Unit (8)"]
[null,null,"menu ▼",null,"menu ▼",null,"menu ▼"]
[null,1,"Adams",null,"Agricultural",null,"CRO"]
[null,2,"Asotin",null,"Commercial",null,"ERO"]
[null,3,"Benton",null,"Industrial",null,"NWRO"]
[null,4,"Chelan",null,"Mixed use",null,"SWRO"]
[null,5,"Clallam",null,"Recreational",null,"HQ"]
[null,6,"Clark",null,"Transportation",null,"Haz Waste"]
[null,7,"Columbia",null,"Residential",null,"Solid Waste"]
[null,8,"Cowlitz",null,"Undeveloped",null,"PLIA"]
[null,9,"Douglas",null,"Vacant"]
[null,10,"Ferry",null,"Other",null,"Data validation range"]
[null,11,"Franklin",null,null,null,"menu ▼"]
[null,12,"Garfield",null,"MTCA cleanup milestones (11)",null,"yes"]
[null,13,"Grant",null,"menu ▼",null,"maybe"]
[null,14,"Grays Harbor",null,"initial investigation",null,"no"]
[null,15,"Island",null,"site hazard assessment"]
[null,16,"Jefferson",null,"CSL listing"]
[null,17,"King",null,"remedial investigation"]
[null,18,"Kitsap",null,"feasibility study"]
[null,19,"Kittitas",null,"cleanup action plan"]
[null,20,"Klickitat",null,"cleanup implementation"]
[null,21,"Lewis",null,"cleanup completion/NFA"]
[null,22,"Lincoln",null,"post-cleanup controls & monitoring"]
[null,23,"Mason",null,"periodic review"]
[null,24,"Okanogan",null,"NFA rescission"]
[null,25,"Pacific"]
[null,26,"Pend Oreille",null,"Terms"]
[null,27,"Pierce",null,"CSL = cleanup screening level."]
[null,28,"San Juan",null,"DFW = Washington Department of Fish & Wildlife"]
[null,29,"Skagit",null,"DNAPL = dense non-aqueous phase liquid."]
[null,30,"Skamania",null,"DNR = Washington Department of Natural Resources."]
[null,31,"Snohomish",null,"DOH = Washington Department of Health."]
[null,32,"Spokane",null,"Ecology = Washington Department of Ecology."]
[null,33,"Stevens",null,"EHD = environmental health disparities"]
[null,34,"Thurston",null,"LNAPL = light non-aqueous phase liquid."]
[null,35,"Wahkiakum",null,"MTCA = Model Toxics Control Act."]
[null,36,"Walla Walla",null,"n/a = not applicable."]
[null,37,"Whatcom",null,"NAPL = non-aqueous phase liquid."]
[null,38,"Whitman",null,"NOAA = National Oceanic and Atmospheric Administration."]
[null,39,"Yakima",null,"PBT = persistent bioaccumulative toxic"]
[null,null,null,null,"SCO = sediment cleanup objective."]
[null,null,null,null,"SCUM = sediment cleanup manual."]
[null,null,null,null,"SHARP = site hazard assessment and ranking process."]
[null,null,null,null,"SWAP = Source Water Assessment Program."]
[null,null,null,null,"TCE = trichloroethene"]

{"sheet":"SvCalc","index":15,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Severity Scoring Logic"]
[]
[null,null,"SL Severity score inputs"]
[null,null,40,"= SvMaxPoints  |  maximum sum of severity Q-scores"]
[null,null,{"$f":"SUM(SL_Sv1_Score,SL_Sv2_Score,SL_Sv3_Score,SL_Sv4_Score,SL_Sv5_Score,SL_Sv6_Score,SL_Sv7_Score)","v":3},"= SvQSum  |  sum of severity Q-scores"]
[null,null,20,"= SvThresh  |  Threshold"]
[null,null,{"$f":"SL_SvQSum/SL_SvMaxPoints","v":7.4999999999999997E-2},"= SvQSumMaxRatio  |  SvQSum/SvMaxPoints"]
[]
[null,null,"GW Severity score inputs"]
[null,null,50,"= SvMaxPoints  |  maximum sum of severity Q-scores"]
[null,null,{"$f":"SUM(GW_Sv1_Score,GW_Sv2_Score,GW_Sv3_Score,GW_Sv4_Score,GW_Sv5_Score,GW_Sv6_Score,GW_Sv7_Score,GW_Sv8_Score)","v":6},"= SvQSum  |  sum of severity Q-scores"]
[null,null,20,"= SvThresh  |  Threshold"]
[null,null,{"$f":"GW_SvQSum/GW_SvMaxPoints","v":0.12},"= SvQSumMaxRatio  |  SvQSum/SvMaxPoints"]
[]
[null,null,"SW Severity score inputs"]
[null,null,45,"= SvMaxPoints  |  maximum sum of severity Q-scores"]
[null,null,{"$f":"SUM(SW_Sv1_Score,SW_Sv2_Score,SW_Sv3_Score,SW_Sv4_Score,SW_Sv5_Score)","v":0},"= SvQSum  |  sum of severity Q-scores"]
[null,null,20,"= SvThresh  |  Threshold"]
[null,null,{"$f":"SW_SvQSum/SW_SvMaxPoints","v":0},"= SvQSumMaxRatio  |  SvQSum/SvMaxPoints"]
[]
[null,null,"SD Severity score inputs"]
[null,null,25,"= SvMaxPoints  |  maximum sum of severity Q-scores"]
[null,null,{"$f":"SUM(SD_Sv1_Score,SD_Sv2_Score,SD_Sv3_Score,SD_Sv4_Score,SD_Sv5_Score,SD_Sv6_Score)","v":0},"= SvQSum  |  sum of severity Q-scores"]
[null,null,20,"= SvThresh  |  Threshold"]
[null,null,{"$f":"SD_SvQSum/SD_SvMaxPoints","v":0},"= SvQSumMaxRatio  |  SvQSum/SvMaxPoints"]
[]
[null,null,"IA Severity score inputs"]
[null,null,15,"= SvMaxPoints  |  maximum sum of severity Q-scores"]
[null,null,{"$f":"SUM(IA_Sv1_Score,IA_Sv2_Score,IA_Sv3_Score)","v":0},"= SvQSum  |  sum of severity Q-scores"]
[null,null,10,"= SvThresh  |  Threshold"]
[null,null,{"$f":"IA_SvQSum/IA_SvMaxPoints","v":0},"= SvQSumMaxRatio  |  SvQSum/SvMaxPoints"]