{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["General Notes","Comparison of Scenarios","Example 1 Truck Dig and Haul","Example 2 Greener Dig and Haul","Green BMP Scenario 3","Green BMP Scenario 4","Green BMP Scenario 5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"General Notes","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,1,22,2],[0,0,0,2],[1,0,1,2],[31,1,31,2],[27,1,27,2]]}
["Green Remediation Environmental Evaluation Numerical (GREEN) tool "]
["General Notes"]
[]
["For Green Best Management Practices (BMP) Scenarios Worksheets"]
[]
[null,"Legend for Scoring"]
[null,"1 to 2","Very Low environmental benefits."]
[null,"3 to 4","Low environmental benefits."]
[null,"5 to 6","Moderate environmental benefits."]
[null,"7  to 8","High environmental benefits."]
[null,"9 to 10","Very High environmental benefits."]
[]
[null,"Applicable"]
[null,"If the Applicable value is N, the Score cell will be gray and you will not need to enter a score value."]
[null,"If the Applicable value is Y, the Score cell will be clear and you will need to enter a score value."]
[]
[null,"Score"]
[null,"Guidance for scoring the five Green categories is provided in Section C.4 of the Guidance for Implementing Green Remediation for Sites in Washington State."]
[null,"If the score is greater than 10, the cell will turn yellow."]
[null,"Brief rationale for scoring should be noted in the scoring notes column."]
[]
[null,"Weighting Factors"]
[null,"Weighting factors (WF) are used for calculating a weighted mean that gives more (or less) importance to a specific metric. Ecology has established default WF for the GREEN tool. However, users can vary these WF based on site-specific considerations (e.g. increase weighting for water metric in drought areas). If site-specific WF are used, justification should be provided and the sum of WF should equal 100. (Weighting Factor Total cell will turn red if the total of all weighting factors does not equal 100)."]
[]
[]
["For Comparison Worksheet"]
[]
[null,"The color range for the comparison of scores will be from Green (Highest environmental benefit) to Red (Lowest environmental benefit)."]
[]
["Example BMP Scenario Worksheets"]
[]
[null,"Two example Green BMP scenario worksheets (Example 1 Truck Dig and Haul and Example 2 Greener Dig and Haul) have been presented as part of this tool. Use the \"clear entered values\" button to reset. "]

{"sheet":"Comparison of Scenarios","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,6],[15,0,15,6],[5,0,5,1],[0,0,0,6],[3,0,3,6],[1,0,1,6]]}
["Green Remediation Environmental Evaluation Numerical (GREEN) tool "]
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"Comparison of Scenarios"}]
[]
["Description of Green BMP Scenarios: Urban site dig and haul using diesel-powered excavators, offsite disposal of all excavated soil to regional landfill using trucks, restoration to grade using imported materials from regional sources delivered via truck, final surface grade consists of gravel and pavement with standard (pipe and gutter) stormwater conveyance."]
[]
["Green Remediation Metrics",null,{"$f":"'Example 1 Truck Dig and Haul'!A2","v":"Example 1 Truck Dig and Haul"},{"$f":"'Example 2 Greener Dig and Haul'!A2","v":"Example 2 Greener Dig and Haul"},{"$f":"'Green BMP Scenario 3'!A2","v":"Green BMP Scenario 3"},{"$f":"'Green BMP Scenario 4'!A2","v":"Green BMP Scenario 4"},{"$f":"'Green BMP Scenario 5'!A2","v":"Green BMP Scenario 5"}]
[]
[null,"Energy",{"$f":"'Example 1 Truck Dig and Haul'!G17","v":96},{"$f":"'Example 2 Greener Dig and Haul'!G17","v":168},{"$f":"'Green BMP Scenario 3'!G17","v":0},{"$f":"'Green BMP Scenario 4'!G17","v":0},{"$f":"'Green BMP Scenario 5'!G17","v":0}]
[null,"Water",{"$f":"'Example 1 Truck Dig and Haul'!G24","v":46.666666666666671},{"$f":"'Example 2 Greener Dig and Haul'!G24","v":80},{"$f":"'Green BMP Scenario 3'!G24","v":0},{"$f":"'Green BMP Scenario 4'!G24","v":0},{"$f":"'Green BMP Scenario 5'!G24","v":0}]
[null,"Material and Waste",{"$f":"'Example 1 Truck Dig and Haul'!G31","v":50},{"$f":"'Example 2 Greener Dig and Haul'!G31","v":135},{"$f":"'Green BMP Scenario 3'!G31","v":0},{"$f":"'Green BMP Scenario 4'!G31","v":0},{"$f":"'Green BMP Scenario 5'!G31","v":0}]
[null,"Air",{"$f":"'Example 1 Truck Dig and Haul'!G38","v":41.666666666666671},{"$f":"'Example 2 Greener Dig and Haul'!G38","v":158.33333333333331},{"$f":"'Green BMP Scenario 3'!G38","v":0},{"$f":"'Green BMP Scenario 4'!G38","v":0},{"$f":"'Green BMP Scenario 5'!G38","v":0}]
[null,"Land and Ecosystems",{"$f":"'Example 1 Truck Dig and Haul'!G44","v":40},{"$f":"'Example 2 Greener Dig and Haul'!G44","v":110},{"$f":"'Green BMP Scenario 3'!G44","v":0},{"$f":"'Green BMP Scenario 4'!G44","v":0},{"$f":"'Green BMP Scenario 5'!G44","v":0}]
[null,"Total Score for Green BMP Scenario (High Score = Greater Environmental Benefit)",{"$f":"'Example 1 Truck Dig and Haul'!G49","v":274.33333333333337},{"$f":"'Example 2 Greener Dig and Haul'!G49","v":651.33333333333326},{"$f":"'Green BMP Scenario 3'!G49","v":0},{"$f":"'Green BMP Scenario 4'!G49","v":0},{"$f":"'Green BMP Scenario 5'!G49","v":0}]
[null,"Costs",{"$f":"'Example 1 Truck Dig and Haul'!E47","v":275000},{"$f":"'Example 2 Greener Dig and Haul'!E47","v":250000},{"$f":"'Green BMP Scenario 3'!E47","v":0},{"$f":"'Green BMP Scenario 4'!E47","v":0},{"$f":"'Green BMP Scenario 5'!E47","v":0}]
[]
["The total Green BMP Scenario scores from the individual worksheets will transfer automatically to this worksheet. "]
["The color range for the comparison of scores will be from Green (Highest environmental benefit) to Red (Lowest environmental benefit)."]

{"sheet":"Example 1 Truck Dig and Haul","index":2,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,7],[3,0,3,7],[49,3,49,4],[1,0,1,7],[68,1,68,7],[63,1,63,7],[59,1,59,7],[60,1,60,7],[52,2,52,7],[53,2,53,7],[54,2,54,7],[55,2,55,7],[56,2,56,7]]}
["Green Remediation Environmental Evaluation Numerical (GREEN) tool "]
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"Example 1 Truck Dig and Haul"}]
[]
["Description of Green BMP Scenario: Urban site dig and haul using diesel-powered excavators, offsite disposal of all excavated soil to regional landfill using trucks, restoration to grade using imported materials from regional sources delivered via truck, final surface grade consists of gravel and pavement with standard (pipe and gutter) stormwater conveyance."]
[]
[]
["Green Remediation Metrics",null,null,"Applicable ","Score","Weighting ","Weighted","Scoring"]
[null,null,null,"(Y/N)","(1 to 10)","Factor","Score","Notes"]
[]
["Energy"]
[null,"Minimize use of non-renewable fuels (no idling, use of rail, efficient engines, etc.)",null,{"$f":"IF(E11>0,\"Y\",\"N\")","v":"Y"},2,null,null,"Heavy reliance on non-renewable diesel"]
[null,"Maximize use of renewable energy (use of solar, wind, etc.)",null,"Y",1,null,null,"No use of renewables"]
[null,"Use local goods and services",null,"Y",4,null,null,"Limited reliance on local fill and landfills"]
[null,"Use chemicals/materials that are produced with less energy (natural or recycled)",null,"N",null,null,null,"Not applicable"]
[null,"Avoid double handling of materials",null,"Y",7,null,null,"Soil loaded directly onto trucks"]
[null,"Minimize overall energy use",null,"Y",2,null,null,"Energy intensive option"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E11:E16)>0), AVERAGE(E11:E16), 0)","v":3.2},30,{"$f":"IF(E17>0,E17*F17, 0)","v":96}]
[]
["Water"]
[null,"Minimize freshwater consumption",null,"Y",7,null,null,"Low water usage"]
[null,"Recycle water or use reclaimed water (recirculation treatment systems, etc.)",null,{"$f":"IF(E21>0,\"Y\",\"N\")","v":"N"},null,null,null,"Not applicable"]
[null,"Use low impact development techniques to manage stormwater",null,"Y",3,null,null,"Some infiltration but no treatment"]
[null,"Use native, drought-resistant plants for landscaping and habitat restoration",null,"Y",4,null,null,"No vegetative restoration"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E20:E23)>0), AVERAGE(E20:E23), 0)","v":4.666666666666667},10,{"$f":"IF(E24>0,E24*F24, 0)","v":46.666666666666671}]
[]
["Materials and Waste"]
[null,"Minimize waste materials generated for disposal",null,"Y",2,null,null,"Limited soil segregation and reuse"]
[null,"Minimize consumption of raw and virgin materials",null,"Y",3,null,null,"Fill derived from commercial soil facility"]
[null,"Recycle or reuse equipment and materials",null,"Y",1,null,null,"No soil reuse or recycling"]
[null,"Use local facilities for waste recycling, reuse, disposal, and treatment",null,"Y",4,null,null,"Use regional but not local sources"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E27:E30)>0), AVERAGE(E27:E30), 0)","v":2.5},20,{"$f":"IF(E31>0,E31*F31, 0)","v":50}]
[]
["Air"]
[null,"Minimize emissions of greenhouse gases",null,"Y",2,null,null,"Limited use of low emission eqpt"]
[null,"Minimize emissions of other air pollutants",null,"Y",2,null,null,"Limited use of low emission eqpt"]
[null,"Use clean fuels and engine technologies",null,"Y",1,null,null,"No use of clean technology"]
[null,"Use materials and chemicals produced with less air emissions",null,"N",null,null,null,"Not applicable"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E34:E37)>0), AVERAGE(E34:E37), 0)","v":1.6666666666666667},25,{"$f":"IF(E38>0,E38*F38, 0)","v":41.666666666666671}]
[]
["Land and Ecosystems"]
[null,"Create and restore functional habitat",null,"Y",1,null,null,"No revegetation"]
[null,"Maintain and protect existing functional habitat",null,"Y",5,null,null,"Urban low habitat potential"]
[null,"Minimize nuisances to the community such as noise, odor, emissions, and light",null,"Y",2,null,null,"High level truck noise and emissions"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E41:E43)>0), AVERAGE(E41:E43), 0)","v":2.6666666666666665},15,{"$f":"IF(E44>0,E44*F44, 0)","v":40}]
[]
["Costs (Optional)"]
[null,"Total Cost of Remedy",null,"Y",275000,null,null,"Feasibility Study Estimate"]
[]
[null,null,"Total Score for Green BMP Scenario  (High Score = Greater Environmental Benefit)",null,null,null,{"$f":"SUM(G11:G44)","v":274.33333333333337}]
[null,null,null,"Weighting Factor Total",null,{"$f":"SUM(F17:F49)","v":100}]
[]
["Legend for Scoring"]
[null,{"$f":"'General Notes'!B7","v":"1 to 2"},{"$f":"'General Notes'!C7","v":"Very Low environmental benefits."}]
[null,{"$f":"'General Notes'!B8","v":"3 to 4"},{"$f":"'General Notes'!C8","v":"Low environmental benefits."}]
[null,{"$f":"'General Notes'!B9","v":"5 to 6"},{"$f":"'General Notes'!C9","v":"Moderate environmental benefits."}]
[null,{"$f":"'General Notes'!B10","v":"7  to 8"},{"$f":"'General Notes'!C10","v":"High environmental benefits."}]
[null,{"$f":"'General Notes'!B11","v":"9 to 10"},{"$f":"'General Notes'!C11","v":"Very High environmental benefits."}]
[]
["Applicable"]
[null,{"$f":"'General Notes'!B14","v":"If the Applicable value is N, the Score cell will be gray and you will not need to enter a score value."}]
[null,{"$f":"'General Notes'!B15","v":"If the Applicable value is Y, the Score cell will be clear and you will need to enter a score value."}]
[]
["Score"]
[null,{"$f":"'General Notes'!B18","v":"Guidance for scoring the five Green categories is provided in Section C.4 of the Guidance for Implementing Green Remediation for Sites in Washington State."}]
[null,"If the score is greater than 10, the cell will turn yellow."]
[null,"Brief rationale for scoring should be noted in the scoring notes column."]
[]
["Weighting Factors"]
[null,{"$f":"'General Notes'!B23","v":"Weighting factors (WF) are used for calculating a weighted mean that gives more (or less) importance to a specific metric. Ecology has established default WF for the GREEN tool. However, users can vary these WF based on site-specific considerations (e.g. increase weighting for water metric in drought areas). If site-specific WF are used, justification should be provided and the sum of WF should equal 100. (Weighting Factor Total cell will turn red if the total of all weighting factors does not equal 100)."}]

{"sheet":"Example 2 Greener Dig and Haul","index":3,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,1,68,7],[49,3,49,4],[0,0,0,7],[3,0,3,7],[1,0,1,7],[60,1,60,7],[56,2,56,7],[63,1,63,7],[52,2,52,7],[53,2,53,7],[54,2,54,7],[55,2,55,7],[59,1,59,7]]}
["Green Remediation Environmental Evaluation Numerical (GREEN) tool "]
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"Example 2 Greener Dig and Haul"}]
[]
["Description of Green BMP Scenario: Urban site dig and haul using clean diesel-powered excavators, offsite disposal of greater than MTCA soil to local landfill using rail, use below MTCA soil as fill along with imported materials from local sources delivered via rail, final surface grade consists of landscaping, rain gardens, and permeable pavement"]
[]
[]
["Green Remediation Metrics",null,null,"Applicable ","Score","Weighting ","Weighted","Scoring"]
[null,null,null,"(Y/N)","(1 to 10)","Factor","Score","Notes"]
[]
["Energy"]
[null,"Minimize use of non-renewable fuels (no idling, use of rail, efficient engines, etc.)",null,"Y",7,null,null,"Less reliance on non-renewable diesel"]
[null,"Maximize use of renewable energy (use of solar, wind, etc.)",null,"Y",5,null,null,"Use biodiesel"]
[null,"Use local goods and services",null,"Y",6,null,null,"Reduce travel using local fill and landfills"]
[null,"Use chemicals/materials that are produced with less energy (natural or recycled)",null,{"$f":"IF(E14>0,\"Y\",\"N\")","v":"N"},null,null,null,"Not applicable"]
[null,"Avoid double handling of materials",null,"Y",4,null,null,"Some double handling of clean soil"]
[null,"Minimize overall energy use",null,"Y",6,null,null,"Rail low energy option, local sources"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E11:E16)>0), AVERAGE(E11:E16), 0)","v":5.6},30,{"$f":"IF(E17>0,E17*F17, 0)","v":168}]
[]
["Water"]
[null,"Minimize freshwater consumption",null,"Y",7,null,null,"Low water usage"]
[null,"Recycle water or use reclaimed water (recirculation treatment systems, etc.)",null,"N",null,null,null,"Not applicable"]
[null,"Use low impact development techniques to manage stormwater",null,"Y",9,null,null,"Use of LID stormwater BMPs"]
[null,"Use native, drought-resistant plants for landscaping and habitat restoration",null,"Y",8,null,null,"Use of low water native vegetation"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E20:E23)>0), AVERAGE(E20:E23), 0)","v":8},10,{"$f":"IF(E24>0,E24*F24, 0)","v":80}]
[]
["Materials and Waste"]
[null,"Minimize waste materials generated for disposal",null,"Y",6,null,null,"Soil segregation and reuse"]
[null,"Minimize consumption of raw and virgin materials",null,"Y",6,null,null,"Minimize imported fill"]
[null,"Recycle or reuse equipment and materials",null,"Y",7,null,null,"Reuse of clean site soil"]
[null,"Use local facilities for waste recycling, reuse, disposal, and treatment",null,"Y",8,null,null,"Use local sources"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E27:E30)>0), AVERAGE(E27:E30), 0)","v":6.75},20,{"$f":"IF(E31>0,E31*F31, 0)","v":135}]
[]
["Air"]
[null,"Minimize emissions of greenhouse gases",null,"Y",5,null,null,"Use of lower emission equipment"]
[null,"Minimize emissions of other air pollutants",null,"Y",7,null,null,"Minimal use of high emission engines"]
[null,"Use clean fuels and engine technologies",null,"Y",7,null,null,"High use of clean engine technology"]
[null,"Use materials and chemicals produced with less air emissions",null,"N",null,null,null,"Not applicable"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E34:E37)>0), AVERAGE(E34:E37), 0)","v":6.333333333333333},25,{"$f":"IF(E38>0,E38*F38, 0)","v":158.33333333333331}]
[]
["Land and Ecosystems"]
[null,"Create and restore functional habitat",null,"Y",9,null,null,"Create new habitat via revegetation/LID"]
[null,"Maintain and protect existing functional habitat",null,"Y",8,null,null,"Urban low existing habitat"]
[null,"Minimize nuisances to the community such as noise, odor, emissions, and light",null,"Y",5,null,null,"High level truck noise, low emissions"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E41:E43)>0), AVERAGE(E41:E43), 0)","v":7.333333333333333},15,{"$f":"IF(E44>0,E44*F44, 0)","v":110}]
[]
["Costs (Optional)"]
[null,"Total Cost of Remedy",null,"Y",250000,null,null,"FS Estimate - less soil disposal and fill"]
[]
[null,null,"Total Score for Green BMP Scenario  (High Score = Greater Environmental Benefit)",null,null,null,{"$f":"SUM(G11:G44)","v":651.33333333333326}]
[null,null,null,"Weighting Factor Total",null,{"$f":"SUM(F17:F49)","v":100}]
[]
["Legend for Scoring"]
[null,{"$f":"'General Notes'!B7","v":"1 to 2"},{"$f":"'General Notes'!C7","v":"Very Low environmental benefits."}]
[null,{"$f":"'General Notes'!B8","v":"3 to 4"},{"$f":"'General Notes'!C8","v":"Low environmental benefits."}]
[null,{"$f":"'General Notes'!B9","v":"5 to 6"},{"$f":"'General Notes'!C9","v":"Moderate environmental benefits."}]
[null,{"$f":"'General Notes'!B10","v":"7  to 8"},{"$f":"'General Notes'!C10","v":"High environmental benefits."}]
[null,{"$f":"'General Notes'!B11","v":"9 to 10"},{"$f":"'General Notes'!C11","v":"Very High environmental benefits."}]
[]
["Applicable"]
[null,{"$f":"'General Notes'!B14","v":"If the Applicable value is N, the Score cell will be gray and you will not need to enter a score value."}]
[null,{"$f":"'General Notes'!B15","v":"If the Applicable value is Y, the Score cell will be clear and you will need to enter a score value."}]
[]
["Score"]
[null,{"$f":"'General Notes'!B18","v":"Guidance for scoring the five Green categories is provided in Section C.4 of the Guidance for Implementing Green Remediation for Sites in Washington State."}]
[null,"If the score is greater than 10, the cell will turn yellow."]
[null,"Brief rationale for scoring should be noted in the scoring notes column."]
[]
["Weighting Factors"]
[null,{"$f":"'General Notes'!B23","v":"Weighting factors (WF) are used for calculating a weighted mean that gives more (or less) importance to a specific metric. Ecology has established default WF for the GREEN tool. However, users can vary these WF based on site-specific considerations (e.g. increase weighting for water metric in drought areas). If site-specific WF are used, justification should be provided and the sum of WF should equal 100. (Weighting Factor Total cell will turn red if the total of all weighting factors does not equal 100)."}]

{"sheet":"Green BMP Scenario 3","index":4,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,1,68,7],[0,0,0,7],[3,0,3,7],[49,3,49,4],[1,0,1,7],[52,2,52,7],[60,1,60,7],[63,1,63,7],[46,1,46,2],[59,1,59,7],[53,2,53,7],[54,2,54,7],[55,2,55,7],[56,2,56,7]]}
["Green Remediation Environmental Evaluation Numerical (GREEN) tool "]
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"Green BMP Scenario 3"}]
[]
["Description of Green BMP Scenario 3: (Please fill in description)"]
[]
[]
["Green Remediation Metrics",null,null,"Applicable ","Score","Weighting ","Weighted","Scoring"]
[null,null,null,"(Y/N)","(1 to 10)","Factor","Score","Notes"]
[]
["Energy"]
[null,"Minimize use of non-renewable fuels (no idling, use of rail, efficient engines, etc.)",null,{"$f":"IF(E11>0,\"Y\",\"N\")","v":"N"}]
[null,"Maximize use of renewable energy (use of solar, wind, etc.)",null,"N"]
[null,"Use local goods and services",null,"N"]
[null,"Use chemicals/materials that are produced with less energy (natural or recycled)",null,"N"]
[null,"Avoid double handling of materials",null,"N"]
[null,"Minimize overall energy use",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E11:E16)>0), AVERAGE(E11:E16), 0)","v":0},30,{"$f":"IF(E17>0,E17*F17, 0)","v":0}]
[]
["Water"]
[null,"Minimize freshwater consumption",null,{"$f":"IF(E20>0,\"Y\",\"N\")","v":"N"}]
[null,"Recycle water or use reclaimed water (recirculation treatment systems, etc.)",null,{"$f":"IF(E21>0,\"Y\",\"N\")","v":"N"}]
[null,"Use low impact development techniques to manage stormwater",null,"N"]
[null,"Use native, drought-resistant plants for landscaping and habitat restoration",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E20:E23)>0), AVERAGE(E20:E23), 0)","v":0},10,{"$f":"IF(E24>0,E24*F24, 0)","v":0}]
[]
["Materials and Waste"]
[null,"Minimize waste materials generated for disposal",null,{"$f":"IF(E27>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize consumption of raw and virgin materials",null,{"$f":"IF(E28>0,\"Y\",\"N\")","v":"N"}]
[null,"Recycle or reuse equipment and materials",null,"N"]
[null,"Use local facilities for waste recycling, reuse, disposal, and treatment",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E27:E30)>0), AVERAGE(E27:E30), 0)","v":0},20,{"$f":"IF(E31>0,E31*F31, 0)","v":0}]
[]
["Air"]
[null,"Minimize emissions of greenhouse gases",null,{"$f":"IF(E34>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize emissions of other air pollutants",null,{"$f":"IF(E35>0,\"Y\",\"N\")","v":"N"}]
[null,"Use clean fuels and engine technologies",null,"N"]
[null,"Use materials and chemicals produced with less air emissions",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E34:E37)>0), AVERAGE(E34:E37), 0)","v":0},25,{"$f":"IF(E38>0,E38*F38, 0)","v":0}]
[]
["Land and Ecosystems"]
[null,"Create and restore functional habitat",null,{"$f":"IF(E41>0,\"Y\",\"N\")","v":"N"}]
[null,"Maintain and protect existing functional habitat",null,{"$f":"IF(E42>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize nuisances to the community such as noise, odor, emissions, and light",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E41:E43)>0), AVERAGE(E41:E43), 0)","v":0},15,{"$f":"IF(E44>0,E44*F44, 0)","v":0}]
[]
["Costs (Optional)"]
[null,"Total Cost of Remedy",null,{"$f":"IF(E47>0,\"Y\",\"N\")","v":"N"}]
[]
[null,null,"Total Score for Green BMP Scenario  (High Score = Greater Environmental Benefit)",null,null,null,{"$f":"SUM(G11:G44)","v":0}]
[null,null,null,"Weighting Factor Total",null,{"$f":"SUM(F17:F49)","v":100}]
[]
["Legend for Scoring"]
[null,{"$f":"'General Notes'!B7","v":"1 to 2"},{"$f":"'General Notes'!C7","v":"Very Low environmental benefits."}]
[null,{"$f":"'General Notes'!B8","v":"3 to 4"},{"$f":"'General Notes'!C8","v":"Low environmental benefits."}]
[null,{"$f":"'General Notes'!B9","v":"5 to 6"},{"$f":"'General Notes'!C9","v":"Moderate environmental benefits."}]
[null,{"$f":"'General Notes'!B10","v":"7  to 8"},{"$f":"'General Notes'!C10","v":"High environmental benefits."}]
[null,{"$f":"'General Notes'!B11","v":"9 to 10"},{"$f":"'General Notes'!C11","v":"Very High environmental benefits."}]
[]
["Applicable"]
[null,{"$f":"'General Notes'!B14","v":"If the Applicable value is N, the Score cell will be gray and you will not need to enter a score value."}]
[null,{"$f":"'General Notes'!B15","v":"If the Applicable value is Y, the Score cell will be clear and you will need to enter a score value."}]
[]
["Score"]
[null,{"$f":"'General Notes'!B18","v":"Guidance for scoring the five Green categories is provided in Section C.4 of the Guidance for Implementing Green Remediation for Sites in Washington State."}]
[null,"If the score is greater than 10, the cell will turn yellow."]
[null,"Brief rationale for scoring should be noted in the scoring notes column."]
[]
["Weighting Factors"]
[null,{"$f":"'General Notes'!B23","v":"Weighting factors (WF) are used for calculating a weighted mean that gives more (or less) importance to a specific metric. Ecology has established default WF for the GREEN tool. However, users can vary these WF based on site-specific considerations (e.g. increase weighting for water metric in drought areas). If site-specific WF are used, justification should be provided and the sum of WF should equal 100. (Weighting Factor Total cell will turn red if the total of all weighting factors does not equal 100)."}]

{"sheet":"Green BMP Scenario 4","index":5,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,1,68,7],[0,0,0,7],[3,0,3,7],[49,3,49,4],[1,0,1,7],[52,2,52,7],[60,1,60,7],[63,1,63,7],[46,1,46,2],[59,1,59,7],[53,2,53,7],[54,2,54,7],[55,2,55,7],[56,2,56,7]]}
["Green Remediation Environmental Evaluation Numerical (GREEN) tool "]
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"Green BMP Scenario 4"}]
[]
["Description of Green BMP Scenario 4: (Please fill in description)"]
[]
[]
["Green Remediation Metrics",null,null,"Applicable ","Score","Weighting ","Weighted","Scoring"]
[null,null,null,"(Y/N)","(1 to 10)","Factor","Score","Notes"]
[]
["Energy"]
[null,"Minimize use of non-renewable fuels (no idling, use of rail, efficient engines, etc.)",null,{"$f":"IF(E11>0,\"Y\",\"N\")","v":"N"}]
[null,"Maximize use of renewable energy (use of solar, wind, etc.)",null,"N"]
[null,"Use local goods and services",null,"N"]
[null,"Use chemicals/materials that are produced with less energy (natural or recycled)",null,"N"]
[null,"Avoid double handling of materials",null,"N"]
[null,"Minimize overall energy use",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E11:E16)>0), AVERAGE(E11:E16), 0)","v":0},30,{"$f":"IF(E17>0,E17*F17, 0)","v":0}]
[]
["Water"]
[null,"Minimize freshwater consumption",null,{"$f":"IF(E20>0,\"Y\",\"N\")","v":"N"}]
[null,"Recycle water or use reclaimed water (recirculation treatment systems, etc.)",null,{"$f":"IF(E21>0,\"Y\",\"N\")","v":"N"}]
[null,"Use low impact development techniques to manage stormwater",null,"N"]
[null,"Use native, drought-resistant plants for landscaping and habitat restoration",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E20:E23)>0), AVERAGE(E20:E23), 0)","v":0},10,{"$f":"IF(E24>0,E24*F24, 0)","v":0}]
[]
["Materials and Waste"]
[null,"Minimize waste materials generated for disposal",null,{"$f":"IF(E27>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize consumption of raw and virgin materials",null,{"$f":"IF(E28>0,\"Y\",\"N\")","v":"N"}]
[null,"Recycle or reuse equipment and materials",null,"N"]
[null,"Use local facilities for waste recycling, reuse, disposal, and treatment",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E27:E30)>0), AVERAGE(E27:E30), 0)","v":0},20,{"$f":"IF(E31>0,E31*F31, 0)","v":0}]
[]
["Air"]
[null,"Minimize emissions of greenhouse gases",null,{"$f":"IF(E34>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize emissions of other air pollutants",null,{"$f":"IF(E35>0,\"Y\",\"N\")","v":"N"}]
[null,"Use clean fuels and engine technologies",null,"N"]
[null,"Use materials and chemicals produced with less air emissions",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E34:E37)>0), AVERAGE(E34:E37), 0)","v":0},25,{"$f":"IF(E38>0,E38*F38, 0)","v":0}]
[]
["Land and Ecosystems"]
[null,"Create and restore functional habitat",null,{"$f":"IF(E41>0,\"Y\",\"N\")","v":"N"}]
[null,"Maintain and protect existing functional habitat",null,{"$f":"IF(E42>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize nuisances to the community such as noise, odor, emissions, and light",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E41:E43)>0), AVERAGE(E41:E43), 0)","v":0},15,{"$f":"IF(E44>0,E44*F44, 0)","v":0}]
[]
["Costs (Optional)"]
[null,"Total Cost of Remedy",null,{"$f":"IF(E47>0,\"Y\",\"N\")","v":"N"}]
[]
[null,null,"Total Score for Green BMP Scenario  (High Score = Greater Environmental Benefit)",null,null,null,{"$f":"SUM(G11:G44)","v":0}]
[null,null,null,"Weighting Factor Total",null,{"$f":"SUM(F17:F49)","v":100}]
[]
["Legend for Scoring"]
[null,{"$f":"'General Notes'!B7","v":"1 to 2"},{"$f":"'General Notes'!C7","v":"Very Low environmental benefits."}]
[null,{"$f":"'General Notes'!B8","v":"3 to 4"},{"$f":"'General Notes'!C8","v":"Low environmental benefits."}]
[null,{"$f":"'General Notes'!B9","v":"5 to 6"},{"$f":"'General Notes'!C9","v":"Moderate environmental benefits."}]
[null,{"$f":"'General Notes'!B10","v":"7  to 8"},{"$f":"'General Notes'!C10","v":"High environmental benefits."}]
[null,{"$f":"'General Notes'!B11","v":"9 to 10"},{"$f":"'General Notes'!C11","v":"Very High environmental benefits."}]
[]
["Applicable"]
[null,{"$f":"'General Notes'!B14","v":"If the Applicable value is N, the Score cell will be gray and you will not need to enter a score value."}]
[null,{"$f":"'General Notes'!B15","v":"If the Applicable value is Y, the Score cell will be clear and you will need to enter a score value."}]
[]
["Score"]
[null,{"$f":"'General Notes'!B18","v":"Guidance for scoring the five Green categories is provided in Section C.4 of the Guidance for Implementing Green Remediation for Sites in Washington State."}]
[null,"If the score is greater than 10, the cell will turn yellow."]
[null,"Brief rationale for scoring should be noted in the scoring notes column."]
[]
["Weighting Factors"]
[null,{"$f":"'General Notes'!B23","v":"Weighting factors (WF) are used for calculating a weighted mean that gives more (or less) importance to a specific metric. Ecology has established default WF for the GREEN tool. However, users can vary these WF based on site-specific considerations (e.g. increase weighting for water metric in drought areas). If site-specific WF are used, justification should be provided and the sum of WF should equal 100. (Weighting Factor Total cell will turn red if the total of all weighting factors does not equal 100)."}]

{"sheet":"Green BMP Scenario 5","index":6,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,1,68,7],[0,0,0,7],[3,0,3,7],[49,3,49,4],[1,0,1,7],[52,2,52,7],[60,1,60,7],[63,1,63,7],[46,1,46,2],[59,1,59,7],[53,2,53,7],[54,2,54,7],[55,2,55,7],[56,2,56,7]]}
["Green Remediation Environmental Evaluation Numerical (GREEN) tool "]
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"Green BMP Scenario 5"}]
[]
["Description of Green BMP Scenario 5: (Please fill in description)"]
[]
[]
["Green Remediation Metrics",null,null,"Applicable ","Score","Weighting ","Weighted","Scoring"]
[null,null,null,"(Y/N)","(1 to 10)","Factor","Score","Notes"]
[]
["Energy"]
[null,"Minimize use of non-renewable fuels (no idling, use of rail, efficient engines, etc.)",null,{"$f":"IF(E11>0,\"Y\",\"N\")","v":"N"}]
[null,"Maximize use of renewable energy (use of solar, wind, etc.)",null,"N"]
[null,"Use local goods and services",null,"N"]
[null,"Use chemicals/materials that are produced with less energy (natural or recycled)",null,"N"]
[null,"Avoid double handling of materials",null,"N"]
[null,"Minimize overall energy use",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E11:E16)>0), AVERAGE(E11:E16), 0)","v":0},30,{"$f":"IF(E17>0,E17*F17, 0)","v":0}]
[]
["Water"]
[null,"Minimize freshwater consumption",null,{"$f":"IF(E20>0,\"Y\",\"N\")","v":"N"}]
[null,"Recycle water or use reclaimed water (recirculation treatment systems, etc.)",null,{"$f":"IF(E21>0,\"Y\",\"N\")","v":"N"}]
[null,"Use low impact development techniques to manage stormwater",null,"N"]
[null,"Use native, drought-resistant plants for landscaping and habitat restoration",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E20:E23)>0), AVERAGE(E20:E23), 0)","v":0},10,{"$f":"IF(E24>0,E24*F24, 0)","v":0}]
[]
["Materials and Waste"]
[null,"Minimize waste materials generated for disposal",null,{"$f":"IF(E27>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize consumption of raw and virgin materials",null,{"$f":"IF(E28>0,\"Y\",\"N\")","v":"N"}]
[null,"Recycle or reuse equipment and materials",null,"N"]
[null,"Use local facilities for waste recycling, reuse, disposal, and treatment",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E27:E30)>0), AVERAGE(E27:E30), 0)","v":0},20,{"$f":"IF(E31>0,E31*F31, 0)","v":0}]
[]
["Air"]
[null,"Minimize emissions of greenhouse gases",null,{"$f":"IF(E34>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize emissions of other air pollutants",null,{"$f":"IF(E35>0,\"Y\",\"N\")","v":"N"}]
[null,"Use clean fuels and engine technologies",null,"N"]
[null,"Use materials and chemicals produced with less air emissions",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E34:E37)>0), AVERAGE(E34:E37), 0)","v":0},25,{"$f":"IF(E38>0,E38*F38, 0)","v":0}]
[]
["Land and Ecosystems"]
[null,"Create and restore functional habitat",null,{"$f":"IF(E41>0,\"Y\",\"N\")","v":"N"}]
[null,"Maintain and protect existing functional habitat",null,{"$f":"IF(E42>0,\"Y\",\"N\")","v":"N"}]
[null,"Minimize nuisances to the community such as noise, odor, emissions, and light",null,"N"]
[null,null,"Total Score (Average x WF)",null,{"$f":"IF((SUM(E41:E43)>0), AVERAGE(E41:E43), 0)","v":0},15,{"$f":"IF(E44>0,E44*F44, 0)","v":0}]
[]
["Costs (Optional)"]
[null,"Total Cost of Remedy",null,{"$f":"IF(E47>0,\"Y\",\"N\")","v":"N"}]
[]
[null,null,"Total Score for Green BMP Scenario  (High Score = Greater Environmental Benefit)",null,null,null,{"$f":"SUM(G11:G44)","v":0}]
[null,null,null,"Weighting Factor Total",null,{"$f":"SUM(F17:F49)","v":100}]
[]
["Legend for Scoring"]
[null,{"$f":"'General Notes'!B7","v":"1 to 2"},{"$f":"'General Notes'!C7","v":"Very Low environmental benefits."}]
[null,{"$f":"'General Notes'!B8","v":"3 to 4"},{"$f":"'General Notes'!C8","v":"Low environmental benefits."}]
[null,{"$f":"'General Notes'!B9","v":"5 to 6"},{"$f":"'General Notes'!C9","v":"Moderate environmental benefits."}]
[null,{"$f":"'General Notes'!B10","v":"7  to 8"},{"$f":"'General Notes'!C10","v":"High environmental benefits."}]
[null,{"$f":"'General Notes'!B11","v":"9 to 10"},{"$f":"'General Notes'!C11","v":"Very High environmental benefits."}]
[]
["Applicable"]
[null,{"$f":"'General Notes'!B14","v":"If the Applicable value is N, the Score cell will be gray and you will not need to enter a score value."}]
[null,{"$f":"'General Notes'!B15","v":"If the Applicable value is Y, the Score cell will be clear and you will need to enter a score value."}]
[]
["Score"]
[null,{"$f":"'General Notes'!B18","v":"Guidance for scoring the five Green categories is provided in Section C.4 of the Guidance for Implementing Green Remediation for Sites in Washington State."}]
[null,"If the score is greater than 10, the cell will turn yellow."]
[null,"Brief rationale for scoring should be noted in the scoring notes column."]
[]
["Weighting Factors"]
[null,{"$f":"'General Notes'!B23","v":"Weighting factors (WF) are used for calculating a weighted mean that gives more (or less) importance to a specific metric. Ecology has established default WF for the GREEN tool. However, users can vary these WF based on site-specific considerations (e.g. increase weighting for water metric in drought areas). If site-specific WF are used, justification should be provided and the sum of WF should equal 100. (Weighting Factor Total cell will turn red if the total of all weighting factors does not equal 100)."}]