{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["User Information","1.1.1 Type","1.1.2 Area","1.1.3 Proximity","1.1.4 Open Water","1.1.5 Interspersion","1.1.6 Vegetation Communities","1.1.7 Diversity","1.1.8 Carbon Sequestration","1.2.1 Reproductive Habitat","1.2.2 Migration...Habitat","1.2.3 Significant Species","1.2.4 Colonial Waterbirds","1.2.5 Waterfowl","1.2.6 Passerine, Shorebird...","1.2.7 Fish","2.1.1 Flood Attenuation","2.1.2 Groundwater Discharge","2.1.3 Groundwater Recharge","2.2.1 ST Water Quality Wetland ","2.2.2 ST Water Quality Buffer","2.2.3 LT Water Quality","2.2.4 Erosion","2.2.5 Carbon Storage","3.1.1 Goods","3.2.1 Recreation","3.3.1 Aesthetics","3.4.1 Education & Research","3.5.1 Historical, Religious &..","EBI Scores","Admin."],"not_rendered":{"charts":0,"images":2,"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":"User Information","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Welcome to the Wetland Restoration Environmental Benefit Index Calculator!"]
[]
[null,"Prepared by: Credit Valley Conservation"]
[]
[null,"Funded by: Greenbelt"]
[]
[null,"What does it do?"]
[null,"This Calculator assists with measuring the public benefits received when wetlands are restored on private lands in the Greenbelt region of Ontario. The Calculator is best used to compare the benefits derived from multiple restoration projects. The Calculator should be used in conjunction with the Environmental Benefit Index (EBI) User Manual available at:  "]
[null,"www.creditvalleyca.ca/watershed-science/our-watershed/ecological-goods-services/.    "]
[]
[null,"Who is it for?"]
[null,"The EBI Calculator is designed for use by conservation practitioners (preferably those with experience conducting wetland evaluations in Ontario). The Ontario Wetland Evaluation System provides the foundation upon which the EBI has been developed.   "]
[]
[null,"How to use it?"]
[null,"The EBI is comprised of three components; Biological, Hydrological and Social. Each component has multiple sub-components and in many cases, each sub-component has multiple attributes (i.e. wetland type, groundwater recharge, etc.). Each attribute is calculated on a separate worksheet within the Calculator. To calculate the EBI score for a wetland restoration project, the user must start at worksheet 1.1.1 Wetland Type and complete the steps listed for both the existing wetland condition (if applicable) and the restored wetland condition before proceeding to the next worksheet (i.e. 1.1.2 Wetland Area). Once all attributes have been scored, the existing and restored conditions scores are automatically tabulated in the EBI Scores worksheet. Also within this worksheet, the change in condition score is calculated and this score as well as the existing condition score may be adjusted by a weighting factor before the total EBI score is computed.  In addition, the Climate Change and Pollution Reduction scores are computed in this worksheet."]
[]
[null,"How to edit it?"]
[null,"With a basic understanding of Microsoft Excel, users may manipulate the EBI Calculator to suit their local needs.  Changes that a user may want to make include the following:"]
[null,"-        Adjust the maximum points for each attribute"]
[null,"-        Adjust the weighting factors for the existing condition and change in condition EBI scores"]
[null,"-        Edit, delete or add attributes"]
[null,"Users are advised to take extreme caution when modifying the EBI Calculator. Many formulas support the computation of the EBI score and making structural edits to the Calculator may result in broken formulas. Users should be particularly careful when making edits to the Admin. worksheet; this worksheet provides the route information for each drop-down menu in the Calculator."]
[]
[null,"Where to get assistance?"]
[null,"The User Manual explains how each attribute is calculated and how to use the EBI Calculator. If further information is required on specific attributes, the Ontario Wetland Evaluation System, Southern Manual, 3rd Edition, Version 3.2 may provide the necessary information."]

{"sheet":"1.1.1 Type","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.1.1 Wetland Type"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Is there an existing wetland present at the project site?",1,null,null,{"$f":"IF(E7=1, \"Continue to  Step 2\", \"Zero Points Scored, Continue to Restored Conditions Evaluation\")","v":"Continue to  Step 2"}]
[null,null,"Step 2","Calculate the Fractional Area (FA) of the existing wetland types. "]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland that is comprised of each of the wetland types. For example, if a wetland is 100% swamp the FA would be 1. If a wetland was 60% swamp and 40% marsh the FA would be .6 for swamp and .4 for marsh. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Marsh",0,null,{"$f":"E11*5","v":0}]
[null,null,null,"     Fractional Area - Swamp",0,null,{"$f":"E12*8","v":0}]
[null,null,null,"     Fractional Area - Bog and/or Fen",0,null,{"$f":"E13*10","v":0}]
[]
[null,null,"Existing Condition Score",null,{"$f":"ROUND(IF(E7=2, 0, SUM(G11:G13)),0)","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Calculate the Fractional Area (FA) of the proposed wetland types."]
[null,null,null,"     Fractional Area - Marsh",0,null,{"$f":"E20*5","v":0}]
[null,null,null,"     Fractional Area - Swamp",0,null,{"$f":"E21*8","v":0}]
[null,null,null,"     Fractional Area - Bog and/or Fen",0,null,{"$f":"E22*10","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"ROUND(SUM(G20:G22),0)","v":0}]

{"sheet":"1.1.2 Area","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.1.2 Effective Project Area"]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the proposed effective project area. "]
[null,null,null,"Note:"]
[null,null,null,"The effective project area is the wetland area measured from the high water mark."]
[null,null,null,"     Less than 0.5 hectares",null,0,{"$f":"IF($F$10=1,2,0)","v":0}]
[null,null,null,"     Greater than or equal to 0.5 hectares but less than 2 hectares",null,null,{"$f":"IF($F$10=2,5,0)","v":0}]
[null,null,null,"     Greater than or equal to 2 hectares but less than 5 hectares",null,null,{"$f":"IF($F$10=3,10,0)","v":0}]
[null,null,null,"     Greater than or equal to 5 hectares but less than 10 hectares",null,null,{"$f":"IF($F$10=4,15,0)","v":0}]
[null,null,null,"     Greater than or equal to 10 hectares",null,null,{"$f":"IF($F$10=5,20,0)","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"SUM(G10,G11,G12,G13,G14)","v":0}]

{"sheet":"1.1.3 Proximity","index":3,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.1.3 Proximity to Other Wetlands"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the proximity of the existing project site to other wetlands. "]
[null,null,null,"     No wetland within 120 metres of the restoration project",null,0,{"$f":"IF($F$8=1, 4, 0)","v":0}]
[null,null,null,"     A wetland exists within 30-120 metres of the restoration project",null,null,{"$f":"IF($F$8=2, 6, 0)","v":0}]
[null,null,null,"     A wetland exists within 10-29 metres of the restoration project",null,null,{"$f":"IF($F$8=3, 8, 0)","v":0}]
[null,null,null,"     A wetland exists less than 10 metres from the restoration project",null,null,{"$f":"IF($F$8=4, 10, 0)","v":0}]
[]
[null,null,"Existing Condition Score",null,{"$f":"SUM(G8,G9,G10,G11)","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the proximity of the proposed wetland to other wetlands. "]
[null,null,null,"     No wetland within 120 metres of the restoration project",null,0,{"$f":"IF($F$18=1, 4, 0)","v":0}]
[null,null,null,"     A wetland exists within 30-120 metres of the restoration project",null,null,{"$f":"IF($F$18=2, 6, 0)","v":0}]
[null,null,null,"     A wetland exists within 10-29 metres of the restoration project",null,null,{"$f":"IF($F$18=3, 8, 0)","v":0}]
[null,null,null,"     A wetland exists less than 10 metres from the restoration project",null,null,{"$f":"IF($F$18=4, 10, 0)","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"SUM(G18,G19,G20,G21)","v":0}]

{"sheet":"1.1.4 Open Water","index":4,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.1.4 Permanent and Seasonal Open Water Types"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the permanent and seasonal open water types at the existing project site. "]
[null,null,null,"Notes:"]
[null,null,null,"Include the presence of streams and rivers within the wetland limits."]
[null,null,null,"Permanent open water is year round standing water with or without emergent vegetation."]
[null,null,null,"Seasonal open water includes intermittent watercourses and vernal pools that contain ponded water for greater than 2 months of the year."]
[null,null,null,"When assessing open water do not include areas with vegetation so dense that duck could not swim through it. "]
[null,null,null,"     No permanent or seasonal open water",null,0,{"$f":"IF($F$13=1, 0, 0)","v":0}]
[null,null,null,"     More than 95% of the area is permanent open water",null,null,{"$f":"IF($F$13=2, 2, 0)","v":0}]
[null,null,null,"     Less than 5% of the area is permanent open water and/or seasonal open water",null,null,{"$f":"IF($F$13=3, 4, 0)","v":0}]
[null,null,null,"     5-25% of the area is permanent open water and it is occuring in the central portion of the wetland; vegetation is peripheral",null,null,{"$f":"IF($F$13=4, 4, 0)","v":0}]
[null,null,null,"     76-95% of the area is permanent open water and it is occuring in the central portion of the wetland; vegetation is peripheral",null,null,{"$f":"IF($F$13=5, 4, 0)","v":0}]
[null,null,null,"     5-25% of the area is permanent open water and it is occuring in various sized ponds; vegetation is in dense patches or diffuse open stands",null,null,{"$f":"IF($F$13=6, 6, 0)","v":0}]
[null,null,null,"     76-95% of the area is permanent open water, vegetation is in dense patches or diffuse open stands",null,null,{"$f":"IF($F$13=7, 6, 0)","v":0}]
[null,null,null,"     26-75% of the area is permanent open water and it is occuring in the central portion of the wetland",null,null,{"$f":"IF($F$13=8, 8, 0)","v":0}]
[null,null,null,"     26-75% of the area is permanent open water and it is occuring in a pattern of small ponds; embayments are common and/or 6-100% of the area is seasonal open water",null,null,{"$f":"IF($F$13=9, 10, 0)","v":0}]
[]
[null,null,"Existing Condition Score",null,{"$f":"SUM(G13:G21)","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the permanent and seasonal open water types at the proposed wetland. "]
[null,null,null,"     No permanent or seasonal open water",null,0,{"$f":"IF($F$28=1, 0, 0)","v":0}]
[null,null,null,"     More than 95% of the area is permanent open water",null,null,{"$f":"IF($F$28=2, 2, 0)","v":0}]
[null,null,null,"     Less than 5% of the area is permanent open water and/or seasonal open water",null,null,{"$f":"IF($F$28=3, 4, 0)","v":0}]
[null,null,null,"     5-25% of the area is permanent open water and it is occuring in the central portion of the wetland; vegetation is peripheral",null,null,{"$f":"IF($F$28=4, 4, 0)","v":0}]
[null,null,null,"     76-95% of the area is permanent open water and it is occuring in the central portion of the wetland; vegetation is peripheral",null,null,{"$f":"IF($F$28=5, 4, 0)","v":0}]
[null,null,null,"     5-25% of the area is permanent open water and it is occuring in various sized ponds; vegetation is in dense patches or diffuse open stands",null,null,{"$f":"IF($F$28=6, 6, 0)","v":0}]
[null,null,null,"     76-95% of the area is permanent open water, vegetation is in dense patches or diffuse open stands",null,null,{"$f":"IF($F$28=7, 6, 0)","v":0}]
[null,null,null,"     26-75% of the area is permanent open water and it is occuring in the central portion of the wetland",null,null,{"$f":"IF($F$28=8, 8, 0)","v":0}]
[null,null,null,"     26-75% of the area is permanent open water and it is occuring in a pattern of small ponds; embayments are common and/or 6-100% of the area is seasonal open water",null,null,{"$f":"IF($F$28=9, 10, 0)","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"SUM(G28:G36)","v":0}]

{"sheet":"1.1.5 Interspersion","index":5,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.1.5 Interspersion"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the number of interspersion intersections of the existing project site."]
[null,null,null,"     Less than 20 intersections",null,0,{"$f":"IF($F$8=1, 2, 0)","v":0}]
[null,null,null,"     21-30 intersections",null,null,{"$f":"IF($F$8=2, 4, 0)","v":0}]
[null,null,null,"     31-40 intersections",null,null,{"$f":"IF($F$8=3, 6, 0)","v":0}]
[null,null,null,"     41-50 intersections",null,null,{"$f":"IF($F$8=4, 8, 0)","v":0}]
[null,null,null,"     Greater than 50 intersections",null,null,{"$f":"IF($F$8=5, 10, 0)","v":0}]
[]
[null,null,"Existing Condition Score",null,{"$f":"SUM(G8:G12)","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the number of interspersion intersections at the propsed wetland site."]
[null,null,null,"     Less than 20 intersections",null,0,{"$f":"IF($F$19=1, 2, 0)","v":0}]
[null,null,null,"     21-30 intersections",null,null,{"$f":"IF($F$19=2, 4, 0)","v":0}]
[null,null,null,"     31-40 intersections",null,null,{"$f":"IF($F$19=3, 6, 0)","v":0}]
[null,null,null,"     41-50 intersections",null,null,{"$f":"IF($F$19=4, 8, 0)","v":0}]
[null,null,null,"     Greater than 50 intersections",null,null,{"$f":"IF($F$19=5, 10, 0)","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"SUM(G19:G23)","v":0}]

{"sheet":"1.1.6 Vegetation Communities","index":6,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.1.6 Vegetation Communities on the Site"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Input the number of communities with 1-3 forms",0,{"$f":"IF(E7=1,1.5,IF(E7=2,2.5,IF(E7=3,3.5,IF(E7=4,4.5,IF(E7=5,5,IF(E7=6,5.5,IF(E7=7,6,IF(E7=8,6.5,IF(E7=9,7,IF(E7=10,7.5,IF(E7=11,8,IF(E7=12,8.5,IF(E7=13,9,IF(E7=14,9.5,IF(E7=15,10,IF(E7=16,10.5,IF(E7=17,11,IF(E7=18,11.5,IF(E7=19,12,IF(E7=20,12.5,IF(E7=21,13,IF(E7=22,13.5,IF(E7=23,14,IF(E7=24,14.5,IF(E7=25,15,IF(E7=26,15.5,IF(E7=27,16,IF(E7=28,16.5,IF(E7=29,17,IF(E7=30,17.5,IF(E7=31,18,IF(E7=32,18.5,IF(E7=33,19,IF(E7=34,19.5,IF(E7=35,20,IF(E7=36,20.5,IF(E7=37,21,IF(E7=38,21.5,IF(E7=39,22,IF(E7=40,22.5,IF(E7=41,23,IF(E7=42,23.5,IF(E7=43,24,IF(E7=44,24.5,IF(E7=45,25,IF(E7=46,25.5,IF(E7=47,26,IF(E7=48,26.5,IF(E7=49,27,IF(E7=50,27.5,IF(E7=51,28,IF(E7=52,28.5,IF(E7=53,29,IF(E7=54,29.5,IF(E7=55,30,IF(E7=56,30.5,IF(E7=57,31,IF(E7=58,31.5,IF(E7=59,32,IF(E7=60,32.5))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":false}]
[null,null,null,null,null,{"$f":"IF(E7=61,33,IF(E7=62,33.5,IF(E7=63, 34,IF(E7=64,34.5,IF(E7=65,35,IF(E7=66,35.5,IF(E7=67,36,IF(E7=68,36.5,IF(E7=69,37,IF(E7=70,37.5,IF(E7=71,38,IF(E7=72,38.5,IF(E7=73,39,IF(E7=74,39.5,IF(E7=75,40,IF(E7=76,40.5,IF(E7=77,41,IF(E7=78,41.5,IF(E7=79,42,IF(E7=80,42.5,IF(E7=81,43,IF(E7=82,43.5,IF(E7=83,44,IF(E7=84,44.5,IF(E7=85,45)))))))))))))))))))))))))","v":false}]
[null,null,"Step 2","Input the number of commuities with 4-5 forms",0,{"$f":"IF(E9=1,2,IF(E9=2,3.5,IF(E9=3,5,IF(E9=4,6.5,IF(E9=5,7.5,IF(E9=6,8.5,IF(E9=7,9.5,IF(E9=8,10.55,IF(E9=9,11.5,IF(E9=10,12.5,IF(E9=11,13,IF(E9=12,13.5,IF(E9=13,14,IF(E9=14,14.5,IF(E9=15,15,IF(E9=16,15.5,IF(E9=17,16,IF(E9=18,16.5,IF(E9=19,17,IF(E9=20,17.5,IF(E9=21,18,IF(E9=22,18.5,IF(E9=23,19,IF(E9=24,19.5,IF(E9=25,20,IF(E9=26,20.5,IF(E9=27,21,IF(E9=28,21.5,IF(E9=29,22,IF(E9=30,22.5,IF(E9=31,23,IF(E9=32,23.5,IF(E9=33,24,IF(E9=34,24.5,IF(E9=35,25,IF(E9=36,25.5,IF(E9=37,26,IF(E9=38,26.5,IF(E9=39,27,IF(E9=40,27.5,IF(E9=41,28,IF(E9=42,28.5,IF(E9=43,29,IF(E9=44,29.5,IF(E9=45,30,IF(E9=46,30.5,IF(E9=47,31,IF(E9=48,31.5,IF(E9=49,32,IF(E9=50,32.5,IF(E9=51,33,IF(E9=52,33.5,IF(E9=53,34,IF(E9=54,34.5,IF(E9=55,35,IF(E9=56,35.5,IF(E9=57,36,IF(E9=58,36.5,IF(E9=59,37,IF(E9=60,37.5))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":false}]
[null,null,null,null,null,{"$f":"IF(E9=61,38,IF(E9=62,38.5,IF(E9=63, 39,IF(E9=64,39.5,IF(E9=65,40,IF(E9=66,40.5,IF(E9=67,41,IF(E9=68,41.5,IF(E9=69,42,IF(E9=70,42.5,IF(E9=71,43,IF(E9=72,43.5,IF(E9=73,44,IF(E9=74,44.5,IF(E9=75,45)))))))))))))))","v":false}]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(SUM(F7:F10)>45,45,SUM(F7:F10))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Input the number of communities with 1-3 forms",0,{"$f":"IF(E16=1,1.5,IF(E16=2,2.5,IF(E16=3,3.5,IF(E16=4,4.5,IF(E16=5,5,IF(E16=6,5.5,IF(E16=7,6,IF(E16=8,6.5,IF(E16=9,7,IF(E16=10,7.5,IF(E16=11,8,IF(E16=12,8.5,IF(E16=13,9,IF(E16=14,9.5,IF(E16=15,10,IF(E16=16,10.5,IF(E16=17,11,IF(E16=18,11.5,IF(E16=19,12,IF(E16=20,12.5,IF(E16=21,13,IF(E16=22,13.5,IF(E16=23,14,IF(E16=24,14.5,IF(E16=25,15,IF(E16=26,15.5,IF(E16=27,16,IF(E16=28,16.5,IF(E16=29,17,IF(E16=30,17.5,IF(E16=31,18,IF(E16=32,18.5,IF(E16=33,19,IF(E16=34,19.5,IF(E16=35,20,IF(E16=36,20.5,IF(E16=37,21,IF(E16=38,21.5,IF(E16=39,22,IF(E16=40,22.5,IF(E16=41,23,IF(E16=42,23.5,IF(E16=43,24,IF(E16=44,24.5,IF(E16=45,25,IF(E16=46,25.5,IF(E16=47,26,IF(E16=48,26.5,IF(E16=49,27,IF(E16=50,27.5,IF(E16=51,28,IF(E16=52,28.5,IF(E16=53,29,IF(E16=54,29.5,IF(E16=55,30,IF(E16=56,30.5,IF(E16=57,31,IF(E16=58,31.5,IF(E16=59,32,IF(E16=60,32.5))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":false}]
[null,null,null,null,null,{"$f":"IF(E16=61,33,IF(E16=62,33.5,IF(E16=63, 34,IF(E16=64,34.5,IF(E16=65,35,IF(E16=66,35.5,IF(E16=67,36,IF(E16=68,36.5,IF(E16=69,37,IF(E16=70,37.5,IF(E16=71,38,IF(E16=72,38.5,IF(E16=73,39,IF(E16=74,39.5,IF(E16=75,40,IF(E16=76,40.5,IF(E16=77,41,IF(E16=78,41.5,IF(E16=79,42,IF(E16=80,42.5,IF(E16=81,43,IF(E16=82,43.5,IF(E16=83,44,IF(E16=84,44.5,IF(E16=85,45)))))))))))))))))))))))))","v":false}]
[null,null,"Step 2","Input the number of commuities with 4-5 forms",0,{"$f":"IF(E18=1,2,IF(E18=2,3.5,IF(E18=3,5,IF(E18=4,6.5,IF(E18=5,7.5,IF(E18=6,8.5,IF(E18=7,9.5,IF(E18=8,10.55,IF(E18=9,11.5,IF(E18=10,12.5,IF(E18=11,13,IF(E18=12,13.5,IF(E18=13,14,IF(E18=14,14.5,IF(E18=15,15,IF(E18=16,15.5,IF(E18=17,16,IF(E18=18,16.5,IF(E18=19,17,IF(E18=20,17.5,IF(E18=21,18,IF(E18=22,18.5,IF(E18=23,19,IF(E18=24,19.5,IF(E18=25,20,IF(E18=26,20.5,IF(E18=27,21,IF(E18=28,21.5,IF(E18=29,22,IF(E18=30,22.5,IF(E18=31,23,IF(E18=32,23.5,IF(E18=33,24,IF(E18=34,24.5,IF(E18=35,25,IF(E18=36,25.5,IF(E18=37,26,IF(E18=38,26.5,IF(E18=39,27,IF(E18=40,27.5,IF(E18=41,28,IF(E18=42,28.5,IF(E18=43,29,IF(E18=44,29.5,IF(E18=45,30,IF(E18=46,30.5,IF(E18=47,31,IF(E18=48,31.5,IF(E18=49,32,IF(E18=50,32.5,IF(E18=51,33,IF(E18=52,33.5,IF(E18=53,34,IF(E18=54,34.5,IF(E18=55,35,IF(E18=56,35.5,IF(E18=57,36,IF(E18=58,36.5,IF(E18=59,37,IF(E18=60,37.5))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":false}]
[null,null,null,null,null,{"$f":"IF(E18=61,38,IF(E18=62,38.5,IF(E18=63, 39,IF(E18=64,39.5,IF(E18=65,40,IF(E18=66,40.5,IF(E18=67,41,IF(E18=68,41.5,IF(E18=69,42,IF(E18=70,42.5,IF(E18=71,43,IF(E18=72,43.5,IF(E18=73,44,IF(E18=74,44.5,IF(E18=75,45)))))))))))))))","v":false}]
[null,null,null,null,null,1]
[null,null,"Restored Condition Score",null,{"$f":"IF(SUM(F16:F19)>45,45,SUM(F16:F19))","v":0}]

{"sheet":"1.1.7 Diversity","index":7,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.1.7 Diversity of Surrounding Habitat"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Select all habitats that exist within 120 metres of the existing project site/wetland boundary"]
[null,null,null,"Note:"]
[null,null,null,"Mixed forest defined as either 25% coniferous trees distributed singularly or in clumps in deciduous forest, or 25% deciduous trees distributed singularly or in clumps of coniferous forest."]
[null,null,null,"      non-intensive agriculture (hay/pasture)",null,false,{"$f":"IF(F10,1,0)","v":0}]
[null,null,null,"     abandoned agricultural land",null,false,{"$f":"IF(F11,1,0)","v":0}]
[null,null,null,"     deciduous forest",null,false,0]
[null,null,null,"     coniferous forest",null,false,0]
[null,null,null,"     mixed forest",null,false,0]
[null,null,null,"     abandoned pits and quarries",null,false,0]
[null,null,null,"     open lake or deep river",null,false,0]
[null,null,null,"     terrain appreciably undulating, hilly or with ravines",null,false,0]
[null,null,null,"     creek flood plain",null,false,0]
[null,null,null,"     grassland",null,false,0]
[]
[null,null,"Existing Condition Score",null,{"$f":"SUM(G10:G19)","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select all habitats that exist within 120 metres of the restored wetland boundary"]
[null,null,null,"      non-intensive agriculture (hay/pasture)",null,false,{"$f":"IF(F26,1,0)","v":0}]
[null,null,null,"     abandoned agricultural land",null,false,{"$f":"IF(F27,1,0)","v":0}]
[null,null,null,"     deciduous forest",null,false,0]
[null,null,null,"     coniferous forest",null,false,0]
[null,null,null,"     mixed forest",null,false,0]
[null,null,null,"     abandoned pits and quarries",null,false,0]
[null,null,null,"     open lake or deep river",null,false,0]
[null,null,null,"     terrain appreciably undulating, hilly or with ravines",null,false,0]
[null,null,null,"     creek flood plain",null,false,0]
[null,null,null,"     grassland",null,false,0]
[]
[null,null,"Existing Condition Score",null,{"$f":"SUM(G26:G35)","v":0}]

{"sheet":"1.1.8 Carbon Sequestration","index":8,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.1.8 Carbon Sequestration"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the vegetation of the existing project area."]
[null,null,null,"      aquatic dominated vegetation",null,0]
[null,null,null,"     grass/forb dominated vegetation"]
[null,null,null,"     tree dominated vegetation"]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(F8=1,5,IF(F8=2,10,IF(F8=3,15,0)))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Are there plantings proposed as part of this project?",1,null,null,null,null,{"$f":"IF(E16=1,\"Continue onto Step #2\",IF(E16=2,\"Zero Points Added to Existing Condition Score, Proceed to 1.2.1\"))","v":"Continue onto Step #2"}]
[]
[null,null,"Step 2","Select all vegetation planting types planned as part of the restoration project"]
[null,null,null,"      aquatic vegetation",null,false,{"$f":"IF(F19,1,0)","v":0},{"$f":"IF(G19=1,5,0)","v":0}]
[null,null,null,"     grass/forb vegetation",null,false,{"$f":"IF(F20,1,0)","v":0},{"$f":"IF(G20=1,8,0)","v":0}]
[null,null,null,"     tree vegetation",null,false,{"$f":"IF(F21,1,0)","v":0},{"$f":"IF(G21=1,10,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H19:H21)","v":0}]
[null,null,"Restored Condition Score",null,{"$f":"IF(H23>25,25,H23)","v":0},null,null,{"$f":"IF(E16=2,E12,IF(E16=1,SUM(E12,H22)))","v":0}]

{"sheet":"1.2.1 Reproductive Habitat","index":9,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.2.1 Reproductive Habitat for Endangered and/or Threatened Species"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does the project site already contain a wetland?",1,null,null,null,null,{"$f":"IF(E7=1,\"Continue onto Step #2\",IF(E7=2,\"Continue to Restored Condition\"))","v":"Continue onto Step #2"}]
[]
[null,null,"Step 2","Select the one option below that best represents the existing condition."]
[null,null,null,"Notes:"]
[null,null,null,"Local records to be used to validate presence/absence of species at risk."]
[null,null,null,"Record must be no more than 20 years old to be considered valid."]
[null,null,null,"Species at risk recovery strategies are to be used to validate likelihood that the proposed project will have a repoductive benefit to species at risk."]
[null,null,null,"     no record of endangered or threatened species reproducing in the wetland",null,0]
[null,null,null,"     confirmed reproductive use of the wetland by one endangered or threatened species"]
[null,null,null,"     confirmed reproductive use of the wetland by more than one endangered or threatened species"]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(F14=1,0,IF(F14=2,6,IF(F14=3,12,0))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the intended restored condition."]
[null,null,null,"     no predicted reproductive benefit to endangered or threatened species",null,0,{"$f":"IF(F23=1,0)","v":false}]
[null,null,null,"     a predicted reproductive benefit to one endangered or threatened species",null,null,{"$f":"IF(F23=2,6)","v":false}]
[null,null,null,"     a predicted reproductive benefit to more than one endangered or threatened species",null,null,{"$f":"IF(F23=3,12)","v":false}]
[null,null,null,null,null,null,{"$f":"SUM(G23:G25)","v":0}]
[null,null,"Restored Condition Score",null,{"$f":"SUM(E18,G26)","v":0}]

{"sheet":"1.2.2 Migration...Habitat","index":10,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.2.2 Traditional Migration, Feeding or Hibernation Habitat for Endangered and/or Threatened Species"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does the project site already contain a wetland?",1,null,null,null,null,{"$f":"IF(E7=1,\"Continue onto Step #2\",IF(E7=2,\"Continue to Restored Condition\"))","v":"Continue onto Step #2"}]
[]
[null,null,"Step 2","Select the one option below that best represents the existing condition."]
[null,null,null,"Notes:"]
[null,null,null,"Local records to be used to validate presence/absence of species at risk."]
[null,null,null,"Record must be no more than 20 years old to be considered valid."]
[null,null,null,"Species at risk recovery strategies are to be used to validate likelihood that the proposed project will have a migration, feeding and/or hibernation benefit to species at risk."]
[null,null,null,"     no record of endangered or threatened species utilizing the existing wetland for migration, feeding or hibernation",null,0]
[null,null,null,"     confirmed migration, feeding or hibernation use of the wetland by one endangered or threatened species"]
[null,null,null,"     confirmed migration, feeding or hibernation use of the wetland by more than one endangered or threatened species"]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(F14=1,0,IF(F14=2,6,IF(F14=3,12,0))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the intended restored condition."]
[null,null,null,"     no predicted migration, feeding or hibernation benefit to endangered or threatened species",null,0,{"$f":"IF(F23=1,0)","v":false}]
[null,null,null,"     a predicted migration, feeding or hibernation benefit to one endangered or threatened species",null,null,{"$f":"IF(F23=2,6)","v":false}]
[null,null,null,"     a predicted migration, feeding or hibernation benefit to more than one endangered or threatened species",null,null,{"$f":"IF(F23=3,12)","v":false}]
[null,null,null,null,null,null,{"$f":"SUM(G23:G25)","v":0}]
[null,null,"Restored Condition Score",null,{"$f":"SUM(E18,G26)","v":0}]

{"sheet":"1.2.3 Significant Species","index":11,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.2.3 Presence of Locally, Regionally, and/or Provincially Significant Plant and Animal Species that Directly Benefit from the Existence of Wetlands"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the existing condition."]
[null,null,null,"Notes:"]
[null,null,null,"Local records to be used to validate presence/absence of significant species"]
[null,null,null,"Record must be no more than 20 years old to be considered valid."]
[null,null,null,"Where available, species at risk recovery strategies or other documents are to be used to validate the likelihood that the proposed project will have a benefit to any locally, regionally, and/or provincially significant species."]
[null,null,null,"     no record of locally, regionally, and/or provincially significant plant or animal species within 120 metres of the effective project area",null,0]
[null,null,null,"     confirmed record of one locally, regionally, and/or provincially significant plant or animal species within 120 metres of the effective project area"]
[null,null,null,"     confirmed record of more than one locally, regionally, and/or provincially significant plant and/or animal species within 120 metres of the effective project area"]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(F12=1,0,IF(F12=2,10,IF(F12=3,20,0)))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the intended restored condition."]
[null,null,null,"     the project does not intend to benefit a locally, regionally, and/or provincially significant plant or animal species within 120 metres of the effective project area",null,0,{"$f":"IF(F21=1,0)","v":false}]
[null,null,null,"     the project intends to benefit one locally, regionally, and/or provincially significant plant or animal species within 120 metres of the effective project area",null,null,{"$f":"IF(F21=2,5)","v":false}]
[null,null,null,"     the project intends to benefit more than one locally, regionally, and/or provincially significant plant and/or animal species within 120 metres of the effective project area",null,null,{"$f":"IF(F21=3,10)","v":false}]
[null,null,null,null,null,null,{"$f":"SUM(G21:G23)","v":0}]
[null,null,"Restored Condition Score",null,{"$f":"SUM(E16,G24)","v":0}]

{"sheet":"1.2.4 Colonial Waterbirds","index":12,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.2.4 Nesting and Feeding Habitat for Colonial Waterbirds"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the existing condition."]
[null,null,null,"Notes:"]
[null,null,null,"Only the following wetland dependent colonial waterbirds are eligible to be scored: red necked grebe, black-crowned night heron, great egret, black tern, caspian tern, common tern and great blue heron (scored for nesting only) "]
[null,null,null,"Local records to be used to validate feeding/nesting of colonial waterbirds"]
[null,null,null,"Record must be no more than 20 years old to be considered valid."]
[null,null,null,"Where available, documents are to be used to validate the likelihood that the proposed project will have a benefit to colonial waterbirds."]
[null,null,null,"     no record of colonial waterbirds nesting or feeding in the existing wetland or it is not possible (i.e. no open water)",null,0]
[null,null,null,"     colonial waterbirds utilize the existing wetland as an active feeding area (except great blue heron)"]
[null,null,null,"     colonial waterbirds have been known to nest in the existing wetland within the last five years "]
[null,null,null,"     colonial waterbirds are currently nesting in the existing wetland"]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(F13=1,0,IF(F13=2,4,IF(F13=3,7,IF(F13=4,10,0))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the intended restored condition."]
[null,null,null,"     no improved benefit to nesting and feeding habitat for colonial waterbirds as a result of the wetland restoration project",null,0,{"$f":"IF(F23=1,0)","v":false}]
[null,null,null,"     the project intends to improve nesting and/or feeding habitat for colonial waterbirds ",null,null,{"$f":"IF(F23=2,5)","v":false}]
[null,null,null,null,null,null,{"$f":"SUM(G23:G24)","v":0}]
[null,null,"Restored Condition Score",null,{"$f":"SUM(E18,G25)","v":0}]

{"sheet":"1.2.5 Waterfowl","index":13,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.2.5 Waterfowl Breeding, Staging and/or Moulting Area"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does the project site already contain a wetland?",1,null,null,null,{"$f":"IF(E7=1,\"Continue onto Step #2\",IF(E7=2,\"Continue to Restored Condition\"))","v":"Continue onto Step #2"}]
[]
[null,null,"Step 2","Select the one option below that best represents the existing condition."]
[null,null,null,"Notes:"]
[null,null,null,"Local records to be used to validate significance of waterfowl breeding, staging and/or moulting area"]
[null,null,null,"Record must be no more than 20 years old to be considered valid."]
[null,null,null,"Geese are not considered an eligible species of waterfowl to score. Wetland restoration designs intended to benefit geese are not encouraged."]
[null,null,null,"     no evidence of waterfowl breeding, staging and/or moulting",null,0]
[null,null,null,"     evidence of waterfowl breeding, staging and/or moulting at any scale "]
[null,null,null,"     evidence of waterfowl breeding, staging and/or moulting to a scale that would be considered locally significant"]
[null,null,null,"     evidence of waterfowl breeding, staging and/or moulting to a scale that would be considered watershed significant "]
[null,null,null,"     evidence of waterfowl breeding, staging and/or moulting to a scale that would be considered provincially significant "]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(F14=1,0,IF(F14=2,2,IF(F14=3,4,IF(F14=4,7,IF(F14=5,10,0))))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the intended restored condition."]
[null,null,null,"     no increase in wetland area",null,0,{"$f":"IF(F25=1,0)","v":false}]
[null,null,null,"     increase in wetland area of up to 0.5 hectares",null,null,{"$f":"IF(F25=2,2)","v":false}]
[null,null,null,"     increase in wetland area of more than 0.5 hectares but less than 2 hectares",null,null,{"$f":"IF(F25=3,3)","v":false}]
[null,null,null,"     increase in wetland area of greater than or equal to 2 hectares",null,null,{"$f":"IF(F25=4,5)","v":false}]
[null,null,null,null,null,null,{"$f":"SUM(G25:G28)","v":0}]
[null,null,"Restored Condition Score",null,{"$f":"SUM(E20,G29)","v":0}]

{"sheet":"1.2.6 Passerine, Shorebird...","index":14,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.2.6 Migratory Passerine, Shorebird or Raptor Stopover Area"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does the project site already contain a wetland?",1,null,null,null,null,{"$f":"IF(E7=1,\"Continue onto Step #2\",IF(E7=2,\"Continue to Restored Condition\"))","v":"Continue onto Step #2"}]
[]
[null,null,"Step 2","Select the one option below that best represents the existing condition."]
[null,null,null,"Notes:"]
[null,null,null,"Local records to be used to validate significance of migratory passerine, shorebird or raptor stopover area"]
[null,null,null,"Record must be no more than 20 years old to be considered valid."]
[null,null,null,"     no evidence of migratory passerine, shorebird or raptors utilizing the wetland for stopover habitat",null,0]
[null,null,null,"     evidence of migratory passerine, shorebird or raptors utilizing the wetland for stopover habitat at any scale "]
[null,null,null,"     evidence of migratory passerine, shorebird or raptors utilizing the wetland for stopover habitat at a scale that would be considered locally significant"]
[null,null,null,"     evidence of migratory passerine, shorebird or raptors utilizing the wetland for stopover habitat at a scale that would be considered watershed significant"]
[null,null,null,"     evidence of migratory passerine, shorebird or raptors utilizing the wetland for stopover habitat at a scale that would be considered provincially significant"]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(F13=1,0,IF(F13=2,2,IF(F13=3,4,IF(F13=4,7,IF(F13=5,10,0))))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the one option below that best represents the intended restored condition."]
[null,null,null,"     no increase in wetland area",null,0,{"$f":"IF(F24=1,0)","v":false}]
[null,null,null,"     increase in wetland area of up to 0.5 hectares",null,null,{"$f":"IF(F24=2,2)","v":false}]
[null,null,null,"     increase in wetland area of more than 0.5 hectares but less than 2 hectares",null,null,{"$f":"IF(F24=3,3)","v":false}]
[null,null,null,"     increase in wetland area of greater than or equal to 2 hectares",null,null,{"$f":"IF(F24=4,5)","v":false}]
[null,null,null,null,null,null,{"$f":"SUM(G24:G27)","v":0}]
[null,null,"Restored Condition Score",null,{"$f":"SUM(E19,G28)","v":0}]

{"sheet":"1.2.7 Fish","index":15,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1.2.7 Fish Habitat"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Is there an existing wetland present at the project site?",1,null,null,{"$f":"IF(E7=1, \"Continue to  Step 2\", \"Zero Points Scored, Skip Step 2 and Continue to Restored Conditions Evaluation\")","v":"Continue to  Step 2"}]
[null,null,"Step 2","Calculate the Fractional Area (FA) of the fish habitat types. "]
[null,null,null,"Notes: "]
[null,null,null,"FA is simply the fraction of the total wetland that is comprised of each fish habitat type. For example, if a wetland is 100% permanent habitat with piscivores the FA would be 1. If a wetland was 60% permanent habitat with piscivores and 40% permanent habitat without piscivores the FA would be .6 for permanent habitat with piscivores and .4 for permanent habitat without piscivores. It is important that the sum of the FA's total 1. "]
[null,null,null,"When calculating FA only include the area up to the high water mark"]
[null,null,null,"Record must be no more than 20 years old to be considered valid"]
[null,null,null,"Piscivores: fish that eat other fish"]
[null,null,null,"Fish stocking is not regarded as a wetland restoraiton activity"]
[null,null,null,"     Fractional Area - Seasonal habitat without piscivores",0,null,{"$f":"E15*3","v":0}]
[null,null,null,"     Fractional Area - Seasonal habitat with piscivores",0,null,{"$f":"E16*8","v":0}]
[null,null,null,"     Fractional Area - Permanent habitat without piscivores",0,null,{"$f":"E17*15","v":0}]
[null,null,null,"     Fractional Area - Permanent habitat with piscivores",0,null,{"$f":"E18*20","v":0}]
[]
[null,null,"Existing Condition Score",null,{"$f":"ROUND(IF(E7=2, 0, SUM(G15:G18)),0)","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Calculate the Fractional Area (FA) of the intended fish habitat types. "]
[null,null,null,"     Fractional Area - Seasonal habitat without piscivores",0,null,{"$f":"E25*3","v":0}]
[null,null,null,"     Fractional Area - Seasonal habitat with piscivores",0,null,{"$f":"E26*8","v":0}]
[null,null,null,"     Fractional Area - Permanent habitat without piscivores",0,null,{"$f":"E27*15","v":0}]
[null,null,null,"     Fractional Area - Permanent habitat with piscivores",0,null,{"$f":"E28*20","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"ROUND(IF(E23=2, 0, SUM(G25:G28)),0)","v":0}]

{"sheet":"2.1.1 Flood Attenuation","index":16,"n_rows":236,"n_cols":24,"rows_kept":236,"cut":false,"hidden":false,"merged":[[10,3,11,3],[29,3,30,3],[29,4,29,6],[29,7,29,9],[29,10,29,12],[208,7,208,11],[209,6,209,11],[210,6,210,11],[10,4,10,6],[10,7,10,9],[10,10,10,12],[49,6,49,11],[10,13,10,15],[29,13,29,15],[52,6,53,15],[50,7,50,15],[207,6,207,11]]}
[]
[]
[null,null,"2.1.1 Flood Attenuation Capacity"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","What is the catchment area upstream of the project site?",0,"hectares"]
[]
[null,null,"Step 2","Using the table below select the value that best represents the land use, slope and soil type for the catchment and enter it here.",0]
[]
[null,null,null,"LAND USE","SANDY SOIL",null,null,"SANDY LOAM SOIL",null,null,"CLAY LOAM SOIL",null,null,"CLAY SOIL"]
[null,null,null,null,"0-2%","2-6%",0.06,"0-2%","2-6%",0.06,"0-2%","2-6%",0.06,"0-2%","2-6%",0.06]
[null,null,null,"CULTIVATED LAND",0.08,0.13,0.16,0.11,0.15,0.21,0.14000000000000001,0.19,0.26,0.18,0.23,0.31]
[null,null,null,"PASTURE",0.12,0.2,0.3,0.18,0.28000000000000003,0.37,0.24,0.34,0.44,0.3,0.4,0.5]
[null,null,null,"MEADOW",0.1,0.16,0.25,0.14000000000000001,0.22,0.3,0.2,0.28000000000000003,0.36,0.24,0.3,0.4]
[null,null,null,"FOREST",0.05,0.08,0.11,0.08,0.11,0.14000000000000001,0.1,0.13,0.16,0.12,0.16,0.3]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.05HA)",0.25,0.28000000000000003,0.31,0.27,0.3,0.35,0.3,0.33,0.38,0.33,0.36,0.42]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.1HA)",0.22,0.26,0.28999999999999998,0.24,0.28999999999999998,0.33,0.27,0.31,0.36,0.3,0.34,0.4]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.13HA)",0.19,0.23,0.26,0.22,0.26,0.3,0.25,0.28999999999999998,0.34,0.28000000000000003,0.32,0.39]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.2HA)",0.16,0.2,0.24,0.19,0.23,0.28000000000000003,0.22,0.27,0.32,0.26,0.3,0.37]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.4HA)",0.14000000000000001,0.19,0.22,0.17,0.21,0.26,0.2,0.25,0.31,0.24,0.28999999999999998,0.35]
[null,null,null,"INDUSTRIAL",0.67,0.68,0.68,0.68,0.68,0.69,0.68,0.69,0.69,0.69,0.69,0.7]
[null,null,null,"COMMERCIAL",0.71,0.71,0.72,0.71,0.72,0.72,0.72,0.72,0.72,0.72,0.72,0.72]
[null,null,null,"STREETS",0.7,0.71,0.72,0.71,0.72,0.74,0.72,0.73,0.76,0.73,0.75,0.78]
[null,null,null,"OPEN SPACE",0.05,0.1,0.14000000000000001,0.08,0.13,0.19,0.12,0.17,0.24,0.15,0.21,0.28000000000000003]
[null,null,null,"PARKING",0.85,0.86,0.87,0.85,0.86,0.87,0.85,0.86,0.87,0.85,0.86,0.87]
[]
[null,null,"Step 3","Similar as in Step 2, using the table below select the value that best represents the land use, slope and soil type for the catchment and enter it here.",0]
[]
[null,null,null,"LAND USE","SANDY SOIL",null,null,"SANDY LOAM SOIL",null,null,"CLAY LOAM SOIL",null,null,"CLAY SOIL"]
[null,null,null,null,"0-2%","2-6%",0.06,"0-2%","2-6%",0.06,"0-2%","2-6%",0.06,"0-2%","2-6%",0.06]
[null,null,null,"CULTIVATED LAND",0.14000000000000001,0.18,0.22,0.16,0.21,0.28000000000000003,0.2,0.25,0.34,0.24,0.28999999999999998,0.41]
[null,null,null,"PASTURE",0.15,0.25,0.37,0.23,0.34,0.45,0.3,0.42,0.52,0.37,0.5,0.62]
[null,null,null,"MEADOW",0.14000000000000001,0.22,0.3,0.2,0.28000000000000003,0.37,0.26,0.35,0.44,0.3,0.4,0.5]
[null,null,null,"FOREST",0.08,0.11,0.14000000000000001,0.1,0.14000000000000001,0.18,0.12,0.16,0.2,0.15,0.2,0.25]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.05HA)",0.33,0.37,0.4,0.35,0.39,0.44,0.38,0.42,0.49,0.41,0.45,0.54]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.1HA)",0.3,0.34,0.37,0.33,0.37,0.42,0.36,0.4,0.47,0.38,0.42,0.52]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.13HA)",0.28000000000000003,0.32,0.35,0.3,0.35,0.39,0.33,0.38,0.45,0.36,0.4,0.5]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.2HA)",0.25,0.28999999999999998,0.32,0.28000000000000003,0.32,0.36,0.31,0.35,0.42,0.34,0.38,0.48]
[null,null,null,"RESIDENTIAL LOT (SIZE 0.4HA)",0.22,0.26,0.28999999999999998,0.24,0.28000000000000003,0.34,0.28000000000000003,0.32,0.4,0.31,0.35,0.46]
[null,null,null,"INDUSTRIAL",0.85,0.85,0.86,0.85,0.86,0.86,0.86,0.86,0.87,0.86,0.86,0.88]
[null,null,null,"COMMERCIAL",0.88,0.88,0.89,0.89,0.89,0.89,0.89,0.89,0.9,0.89,0.89,0.9]
[null,null,null,"STREETS",0.76,0.77,0.79,0.8,0.82,0.84,0.84,0.85,0.89,0.89,0.91,0.95]
[null,null,null,"OPEN SPACE",0.11,0.16,0.2,0.14000000000000001,0.19,0.26,0.18,0.23,0.32,0.22,0.27,0.39]
[null,null,null,"PARKING",0.95,0.96,0.97,0.95,0.96,0.97,0.95,0.96,0.97,0.95,0.96,0.97]
[]
[null,null,"Step 3","Lookup rainfall amounts by navigating to the project site location on the Ministry of Transportation of Ontario website found here: mto.gov.on.ca/IDF_Curves/terms.shtml. "]
[null,null,null,"Copy the 5, 10, 25 and 50 Year, 1 hour rainfall amounts (found in Row A) and record them in the corresponding location below.  "]
[]
[null,null,null,"     1 hour rainfall amount - 5 Year Storm",0,"mm","How to calculate rainfall amounts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Storm Volume - 5 Yr",{"$f":"$E$7*$E$9*E50","v":0}]
[null,null,null,"     1 hour rainfall amount - 10 Year Storm",0,"mm","1) Click: here:","http://www.mto.gov.on.ca/IDF_Curves/map_acquisition.shtml",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Storm Volume - 10 Yr",{"$f":"$E$7*$E$9*E51","v":0}]
[null,null,null,"     1 hour rainfall amount - 25 Year Storm",0,"mm","2) Find the location of your project site and click on the map",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Storm Volume - 25 Yr",{"$f":"$E$7*$E$28*E52","v":0}]
[null,null,null,"     1 hour rainfall amount - 50 Year Storm",0,"mm","3) Record the rainfall amounts listed in the row labeled \"A\" and enter them into the appropriate locations in the calculator (i.e. boxes to the left)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Storm Volume - 50 Yr",{"$f":"$E$7*$E$28*E53","v":0}]
[null,null,null,"     1 hour rainfall amount - 100 Year Storm",0,"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Storm Volume - 100 Yr",{"$f":"$E$7*$E$28*E54","v":0}]
[]
[null,null,"Step 4","What is the area of the existing wetland base (i.e. the lowest topographical zone of the wetland)?",0,"m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Potential Wetland Flood Volume Storage =",{"$f":"((E56+E58)/2)*E60","v":0}]
[]
[null,null,"Step 5","What is the area of the existing wetland measured at the location of the high water mark?",0,"m2"]
[]
[null,null,"Step 6","What is the vertical distance (i.e. depth of water) between the existing wetland base and the high water mark? ",0,"m"]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(X56>X54,75,IF(X56>X53,60,IF(X56>X52,45,IF(X56>X51,30,IF(X56>X50,15,0)))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Upon construction of the proposed wetland restoration project, will the flood volume storage change compared to that of the existing condition?",1,{"$f":"IF(E66=1, \"Continue to  Step 2\", \"Skip The Remaining Steps and Continue to 2.1.2 Groundwater Discharge\")","v":"Continue to  Step 2"}]
[]
[null,null,"Step 2","What is the area of the proposed wetland base (i.e. the lowest topographical zone of the wetland)?",0,"m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Potential Wetland Flood Volume Storage =",{"$f":"((E68+E70)/2)*E72","v":0}]
[]
[null,null,"Step 3","What is the area of the proposed wetland measured at the location of the high water mark?",0,"m2"]
[]
[null,null,"Step 4","What is the vertical distance (i.e. depth of water) between the proposed wetland base and the high water mark? ",0,"m"]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E66=2,E62,IF(X68>E54,75,IF(X68>E53,60,IF(X68>E52,45,IF(X68>E51,30,IF(X68>E50,15,0))))))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"     Dominant catchment land use",1]
[null,null,null,"     Dominant catchment soil type",1]
[null,null,null,"     Average catchment slope",1]
[]
[null,null,null,"     1 hour rainfall amount - 5 Year Storm",21,"mm","How to calculate rainfall amounts"]
[null,null,null,"     1 hour rainfall amount - 10 Year Storm",30,"mm","1) Click: here:","http://www.mto.gov.on.ca/IDF_Curves/map_acquisition.shtml"]
[null,null,null,"     1 hour rainfall amount - 25 Year Storm",33,"mm","2) Find the location of your project site and click on the map"]
[null,null,null,"     1 hour rainfall amount - 50 Year Storm",36,"mm","3) Record the rainfall amounts listed in the row labeled \"A\" and enter them into the appropriate locations in the calculator"]
[null,null,null,"     1 hour rainfall amount - 100 Year Storm",50,"mm"]
[]
[]
[]
[]
[null,null,null,"5 Year Flood Volume"]
[null,null,null,"10 Year Flood Volume"]
[null,null,null,"25 Year Flood Volume"]
[null,null,null,"50 Year Flood Volume"]
[null,null,null,"100 year Flood Volume"]
[]
[]
[]
[null,null,"Existing Condition Score",null,{"$f":"ROUND(IF(N7=2, 0, SUM(G7:G208)),0)","v":12}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Calculate the Fractional Area (FA) of the wetland types."]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland that is comprised of each of the wetland types. For example, if a wetland is 100% swamp the FA would be 1. If a wetland was 60% swamp and 40% marsh the FA would be .6 for swamp and .4 for marsh. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Marsh",0,null,{"$f":"E232*5","v":0}]
[null,null,null,"     Fractional Area - Swamp",0,null,{"$f":"E233*8","v":0}]
[null,null,null,"     Fractional Area - Bog and/or Fen",0,null,{"$f":"E234*10","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"ROUND(SUM(G232:G234),0)","v":0}]

{"sheet":"2.1.2 Groundwater Discharge","index":17,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"2.1.2 Groundwater Discharge"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Select the options that best characterize the existing project site."]
[null,null,null,"     Dominant wetland type",1,{"$f":"IF(E8=1,0,IF(E8=2,2,IF(E8=3,2,IF(E8=4,5))))","v":0}]
[null,null,null,"     Topography",1,{"$f":"IF(E9=1,0,IF(E9=2,0,IF(E9=3,2,IF(E9=4,5))))","v":0}]
[null,null,null,"     Wetland area:upslope catchment area ",1,{"$f":"IF(E10=1,0,IF(E10=2,2,IF(E10=3,5)))","v":0}]
[null,null,null,"     Lagg development",1,{"$f":"IF(E11=1,0,IF(E11=2,2,IF(E11=3,5)))","v":0}]
[null,null,null,"     Seeps",1,{"$f":"IF(E12=1,0,IF(E12=2,2,IF(E12=3,5)))","v":0}]
[null,null,null,"     Surface marl deposits",1,{"$f":"IF(E13=1,0,IF(E13=2,5))","v":0}]
[null,null,null,"     Iron precipitates",1,{"$f":"IF(E14=1,0,IF(E14=2,5))","v":0}]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(SUM(F8:F14)>25,25,SUM(F8:F14))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Select the options that best characterize the intended restored condition."]
[null,null,null,"     Dominant wetland type",1,{"$f":"IF(E21=1,0,IF(E21=2,2,IF(E21=3,2,IF(E21=4,5))))","v":0}]
[null,null,null,"     Topography",2,{"$f":"IF(E22=1,0,IF(E22=2,0,IF(E22=3,2,IF(E22=4,5))))","v":0}]
[null,null,null,"     Wetland area:upslope catchment area ",1,{"$f":"IF(E23=1,0,IF(E23=2,2,IF(E23=3,5)))","v":0}]
[null,null,null,"     Lagg development",1,{"$f":"IF(E24=1,0,IF(E24=2,2,IF(E24=3,5)))","v":0}]
[null,null,null,"     Seeps",1,{"$f":"IF(E25=1,0,IF(E25=2,2,IF(E25=3,5)))","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"SUM(F21:F25)","v":0}]

{"sheet":"2.1.3 Groundwater Recharge","index":18,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"2.1.3 Groundwater Recharge"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Is the project site located within a municpal wellhead protection zone?",2,{"$f":"IF(E7=1, \"Contine to 2.2.1 Short Term Water Quality\", IF(E7=2, \"Continue to Step #2\"))","v":"Continue to Step #2"}]
[]
[null,null,"Step 2","Does a wetland currently exist at the project site?",2,{"$f":"IF(E9=1,\"Contine to Step 3\",IF(E9=2,\"Continue to Restored Condition Scoring\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Step 3","Is the exisitng wetland greater than 50% lacustrine (by area) or located on a major river (i.e. St. Clair, Detroit, Niagara, St. Lawrence, Ottawa)? ",2,{"$f":"IF(E11=1,\"Continue to Restored Condition Scoring\",IF(E11=2,\"Continue to Step 4\"))","v":"Continue to Step 4"}]
[]
[null,null,"Step 4","Calculate the Fractional Area (FA) of the existing wetland site types. "]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland that is comprised of each of the wetland site types. For example, if a wetland is 100% lacustrine the FA would be 1. If a wetland was 60% lacustrine and 40% riverine the FA would be .6 for lacustrine and .4 for riverine. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Isolated ",0,null,{"$f":"E16*20","v":0}]
[null,null,null,"     Fractional Area - Palustrine",0,null,{"$f":"E17*20","v":0}]
[null,null,null,"     Fractiona Area - Riverine",0,null,{"$f":"E18*8","v":0}]
[null,null,null,"     Fractional Area - Lacustrine ",0,null,{"$f":"E19*0","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G16:G19)>25,25,SUM(G16:G19))","v":0}]
[null,null,"Step 5","Using the table below select the value that best represents the dominant wetland site type and soil type/condition and enter it here.",0]
[]
[null,null,null,"DOMINANT WETLAND SITE TYPE (from step 4)","SANDS, GRAVELS, LOAMS","CLAYS, SUBSTRATES IN HIGH WATER TABLES OR SHALLOW SUBSTRATES OVER IMPERVIOUS MEATERIALS SUCH AS CONSOLIDATED BEDROCK"]
[null,null,null,"Lacustrine or major river (i.e. St. Clair, Detroit, Niagara, St. Lawrence, Ottawa)",0,0]
[null,null,null,"Isolated",5,3]
[null,null,null,"Palustrine",4,2]
[null,null,null,"Riverine (not on a major river)",2,1]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=1,25,IF(E9=2,0,IF(E11=1,0,SUM(G20,E21,0))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Will the restored wetland be greater than 50% lacustrine (by area) or located on a major river (i.e. St. Clair, Detroit, Niagara, St. Lawrence, Ottawa)? ",2,{"$f":"IF(E33=1,\"Contine to 2.2.1 Short Term Water Quality \",IF(E33=2,\"Continue to Step 2\"))","v":"Continue to Step 2"}]
[]
[null,null,"Step 2","Calculate the Fractional Area (FA) of the proposed wetland site types. "]
[null,null,null,"     Fractional Area - Isolated ",0,null,{"$f":"E36*20","v":0}]
[null,null,null,"     Fractional Area - Palustrine",0,null,{"$f":"E37*20","v":0}]
[null,null,null,"     Fractiona Area - Riverine",0,null,{"$f":"E38*8","v":0}]
[null,null,null,"     Fractional Area - Lacustrine ",0,null,{"$f":"E39*0","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G36:G39)>25,25,SUM(G36:G39))","v":0}]
[null,null,"Step 3","Using the table below select the value that best represents the dominant wetland site type and soil type/condition and enter it here.",0]
[]
[null,null,null,"DOMINANT WETLAND SITE TYPE (from step 4)","SANDS, GRAVELS, LOAMS","CLAYS, SUBSTRATES IN HIGH WATER TABLES OR SHALLOW SUBSTRATES OVER IMPERVIOUS MEATERIALS SUCH AS CONSOLIDATED BEDROCK"]
[null,null,null,"Lacustrine or major river (i.e. St. Clair, Detroit, Niagara, St. Lawrence, Ottawa)",0,0]
[null,null,null,"Isolated",5,3]
[null,null,null,"Palustrine",4,2]
[null,null,null,"Riverine (not on a major river)",2,1]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E7=1,25,IF(E33=1,0,SUM(G40,E41)))","v":0}]

{"sheet":"2.2.1 ST Water Quality Wetland ","index":19,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"2.2.1 Short-Term Water Quality Improvement in Wetland"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does a wetland currently exist at the project site?",1,{"$f":"IF(E7=1,\"Continue to Step 2\",IF(E7=2,\"Continue to Restored Condition Scoring\"))","v":"Continue to Step 2"}]
[]
[null,null,"Step 2","Is the exisitng wetland located on a major lake (i.e. Huron, Erie, St. Clair, Ontario, Simcoe) or major river (i.e. St. Clair, Detroit, Niagara, St. Lawrence, Ottawa )?",1,{"$f":"IF(E9=1,\"Continue to Restored Condition Scoring\",IF(E9=2,\"Continue to Step 3\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Step 3","Calculate the Fractional Area (FA) of the wetland site types. "]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland that is comprised of each of the wetland site types. For example, if a wetland is 100% lacustrine the FA would be 1. If a wetland was 60% lacustrine and 40% riverine the FA would be .6 for lacustrine and .4 for riverine. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Isolated ",0,null,{"$f":"E14*0.5","v":0}]
[null,null,null,"     Fractional Area - Palustrine with no Inflow",0,null,{"$f":"E15*0.7","v":0}]
[null,null,null,"     Fractional Area - Palustrine with Inflow",0,null,{"$f":"E16*1","v":0}]
[null,null,null,"     Fractiona Area - Riverine",0,null,{"$f":"E17*1","v":0}]
[null,null,null,"     Fractional Area - Lacustrine on lake shoreline",0,null,{"$f":"E18*0.2","v":0}]
[null,null,null,"     Fractional Area - Lacustrine at lake Inflow or Outflow",0,null,{"$f":"E19*1","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G14:G19)>1,1,SUM(G14:G19))","v":0}]
[null,null,"Step 4","Which option best describes the land use in the upstream catchment?",3,null,{"$f":"IF(E21=1,1,IF(E21=2,0.8,IF(E21=3,0.6)))","v":0.6}]
[]
[null,null,"Step 5","Calculate the Fractional Area (FA) of the vegetation types in the wetland."]
[null,null,null,"     Fractional Area - Live Trees, Shrubs, Herbs or Mosses",0,null,{"$f":"E24*0.75","v":0}]
[null,null,null,"     Fractional Area - Emergent, Subemergent of Floating Vegetation",0,null,{"$f":"E25*1","v":0}]
[null,null,null,"     Fractional Area - Little or No Vegetation",0,null,{"$f":"E26*0.5","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G24:G26)>1,1,SUM(G24:G26))","v":0}]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(E9=2,0,G27*G21*G20*50))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Is the proposed wetland restoration project located on a major lake (i.e. Huron, Erie, St. Clair, Ontario, Simcoe) or major river (i.e. St. Clair, Detroit, Niagara, St. Lawrence, Ottawa )?",2,{"$f":"IF(E32=1,\"Contine to 2.2.2 Short Term Water Quality Improvement in Upland Buffer\",IF(E32=2,\"Continue to Step 2\"))","v":"Continue to Step 2"}]
[]
[null,null,"Step 2","Calculate the Fractional Area (FA) of the wetland site types. "]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland that is comprised of each of the wetland site types. For example, if a wetland is 100% lacustrine the FA would be 1. If a wetland was 60% lacustrine and 40% riverine the FA would be .6 for lacustrine and .4 for riverine. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Isolated ",0,null,{"$f":"E37*0.5","v":0}]
[null,null,null,"     Fractional Area - Palustrine with no Inflow",0,null,{"$f":"E38*0.7","v":0}]
[null,null,null,"     Fractional Area - Palustrine with Inflow",0,null,{"$f":"E39*1","v":0}]
[null,null,null,"     Fractiona Area - Riverine",0,null,{"$f":"E40*1","v":0}]
[null,null,null,"     Fractional Area - Lacustrine on lake shoreline",0,null,{"$f":"E41*0.2","v":0}]
[null,null,null,"     Fractional Area - Lacustrine at lake Inflow or Outflow",0,null,{"$f":"E42*1","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G37:G42)>1,1,SUM(G37:G42))","v":0}]
[null,null,"Step 3","Which option best describes the land use in the upstream catchment?",1,null,{"$f":"IF(E44=1,1,IF(E44=2,0.8,IF(E44=3,0.6)))","v":1}]
[]
[null,null,"Step 4","Calculate the Fractional Area (FA) of the vegetation types in the wetland."]
[null,null,null,"     Fractional Area - Live Trees, Shrubs, Herbs or Mosses",0,null,{"$f":"E47*0.75","v":0}]
[null,null,null,"     Fractional Area - Emergent, Subemergent of Floating Vegetation",0,null,{"$f":"E48*1","v":0}]
[null,null,null,"     Fractional Area - Little or No Vegetation",0,null,{"$f":"E49*0.5","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G47:G49)>1,1,SUM(G47:G49))","v":0}]
[null,null,"Restored Condition Score",null,{"$f":"IF(E32=1,0,G50*G44*G43*50)","v":0}]

{"sheet":"2.2.2 ST Water Quality Buffer","index":20,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"2.2.2 Short-Term Water Quality Improvement in Upland Buffer"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does a wetland currently exist at the project site?",2,{"$f":"IF(E7=1,\"Continue to Step 2\",IF(E7=2,\"Continue to Restored Condition Scoring\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Step 2","Is the existing wetland buffered (on the subject property) with natural vegetation and left undisturbed (i.e. not mowed, harvested, tilled, etc.)?",1,{"$f":"IF(E9=1,\"Continue to Step 3\",IF(E9=2,\"Continue to Restored Conditions Scoring\"))","v":"Continue to Step 3"}]
[]
[null,null,"Step 3","Is the existing wetland buffer greater than or equal to 50m in width for the entire wetland boundary located on the subject property?",1,{"$f":"IF(E11=1,\"Continue to Restored Conditions Scoring\",IF(E11=2,\"Continue to Step 4\"))","v":"Continue to Restored Conditions Scoring"}]
[]
[null,null,"Step 4","Calculate the Fractional Area (FA) of the wetland site types. "]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland that is comprised of each of the wetland site types. For example, if a wetland is 100% lacustrine the FA would be 1. If a wetland was 60% lacustrine and 40% riverine the FA would be .6 for lacustrine and .4 for riverine. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Isolated ",0,null,{"$f":"E16*0.5","v":0}]
[null,null,null,"     Fractional Area - Palustrine with no Inflow",0,null,{"$f":"E17*0.7","v":0}]
[null,null,null,"     Fractional Area - Palustrine with Inflow",0,null,{"$f":"E18*1","v":0}]
[null,null,null,"     Fractiona Area - Riverine",0,null,{"$f":"E19*0.8","v":0}]
[null,null,null,"     Fractional Area - Lacustrine on lake shoreline (not including major lakes)",0,null,{"$f":"E20*0.5","v":0}]
[null,null,null,"     Fractional Area - Lacustrine on lake shoreline (only major lakes)",0,null,{"$f":"E21*0.2","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G16:G21)>1,1,SUM(G16:G21))","v":0}]
[null,null,"Step 5","Which option best describes the land use in the upstream catchment?",1,null,{"$f":"IF(E23=1,1,IF(E23=2,0.6,IF(E23=3,0.4)))","v":1}]
[]
[null,null,"Step 6","Which option best describes the vegetation in the buffer?",2,null,{"$f":"IF(E25=1,0.3,IF(E25=2,1))","v":1}]
[]
[null,null,"Step 7","What percentage of the wetland boundary is buffered on the subject property?",1,null,{"$f":"IF(E27=1,1,IF(E27=2,0.5,IF(E27=3,0.2)))","v":1}]
[]
[null,null,"Step 8","How wide is the wetland buffer on the subject property?",1,null,{"$f":"IF(E29=1,1,IF(E29=2,0.8,IF(E29=3,0.6,IF(E29=4,0.4))))","v":1}]
[]
[null,null,"Step 9","How steep is the buffer on the subject property?",1,null,{"$f":"IF(E31=1,1,IF(E31=2,0.8,IF(E31=3,0.6,IF(E31=4,0.4))))","v":1}]
[]
[null,null,"Step 10","What soil type best describes the buffer area?",1,null,{"$f":"IF(E33=1,1,IF(E33=2,0.7,IF(E33=3,0.4)))","v":1}]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(E9=2,0,IF(E11=1,50,(50*G22*G23*G25*G27*G29*G31*G33))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Upon completion of the proposed wetland restoration project, will the wetland buffer (on the subject property) be naturally vegetated and left undisturbed (i.e. not mowed, harvested, tilled, etc.)?",1,{"$f":"IF(E39=1,\"Continue to Step 2\",IF(E39=2,\"Continue to 2.2.3 Long-Term Nutrient Trap in Wetland\"))","v":"Continue to Step 2"}]
[]
[null,null,"Step 2","Upon completion of the proposed wetland restoration project, will the wetland buffer be greater than or equal to 50m in width for the entire wetland boundary located on the subject property?",2,{"$f":"IF(E41=1,\"Continue to 2.2.3 Long-Term Nutrient Trap in Wetland\",IF(E41=2,\"Continue to Step 3\"))","v":"Continue to Step 3"}]
[]
[null,null,"Step 3","Calculate the Fractional Area (FA) of the wetland site types. "]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland that is comprised of each of the wetland site types. For example, if a wetland is 100% lacustrine the FA would be 1. If a wetland was 60% lacustrine and 40% riverine the FA would be .6 for lacustrine and .4 for riverine. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Isolated ",0,null,{"$f":"E46*0.5","v":0}]
[null,null,null,"     Fractional Area - Palustrine with no Inflow",0,null,{"$f":"E47*0.7","v":0}]
[null,null,null,"     Fractional Area - Palustrine with Inflow",0,null,{"$f":"E48*1","v":0}]
[null,null,null,"     Fractiona Area - Riverine",0,null,{"$f":"E49*0.8","v":0}]
[null,null,null,"     Fractional Area - Lacustrine on lake shoreline (not including major lakes)",0,null,{"$f":"E50*0.5","v":0}]
[null,null,null,"     Fractional Area - Lacustrine on lake shoreline (only major lakes)",0,null,{"$f":"E51*0.2","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G46:G51)>1,1,SUM(G46:G51))","v":0}]
[null,null,"Step 4","Which option best describes the land use in the upstream catchment?",1,null,{"$f":"IF(E53=1,1,IF(E53=2,0.6,IF(E53=3,0.4)))","v":1}]
[]
[null,null,"Step 5","Which option best describes the vegetation in the buffer?",2,null,{"$f":"IF(E55=1,0.3,IF(E55=2,1))","v":1}]
[]
[null,null,"Step 6","What percentage of the wetland boundary is buffered on the subject property?",1,null,{"$f":"IF(E57=1,1,IF(E57=2,0.5,IF(E57=3,0.2)))","v":1}]
[]
[null,null,"Step 7","How wide is the wetland buffer on the subject property?",1,null,{"$f":"IF(E59=1,1,IF(E59=2,0.8,IF(E59=3,0.6,IF(E59=4,0.4))))","v":1}]
[]
[null,null,"Step 8","How steep is the buffer on the subject property?",1,null,{"$f":"IF(E61=1,1,IF(E61=2,0.8,IF(E61=3,0.6,IF(E61=4,0.4))))","v":1}]
[]
[null,null,"Step 9","What soil type best describes the buffer area?",1,null,{"$f":"IF(E63=1,1,IF(E63=2,0.7,IF(E63=3,0.4)))","v":1}]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E39=2,0,IF(E41=1,50,(50*G52*G53*G55*G57*G59*G61*G63)))","v":0}]

{"sheet":"2.2.3 LT Water Quality","index":21,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"2.2.3 Long-Term Nutrient (Nitrogen and Phosphorus) Trap in Wetland"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does a wetland currently exist at the project site?",2,{"$f":"IF(E7=1,\"Continue to Step 2\",IF(E7=2,\"Continue to Restored Condition Scoring\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Step 2","Is the existing wetland located in a river mouth?",1,{"$f":"IF(E9=1,\"Continue to Restored Condition Scoring\",IF(E9=2,\"Continue to Step 3\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Step 3","Does the wetland have permanent open water?",2,null,{"$f":"IF(E11=1,10,IF(E11=2,20))","v":20}]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(E9=1,50,G11))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Is the proposed wetland restoration project located in a river mouth?",2,{"$f":"IF(E17=1,\"Continue to 2.2.4 Shoreline Erosion Control\",IF(E17=2,\"Continue to Step 2\"))","v":"Continue to Step 2"}]
[]
[null,null,"Step 2","Does the proposed wetland restoration project intend to increase the area of permanent open water?",2,null,{"$f":"IF(E19=1,20, 0)","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E17=1,50,IF(SUM(G19,E13)>50,50,SUM(G19,E13)))","v":0}]

{"sheet":"2.2.4 Erosion","index":22,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"2.2.4 Shoreline Erosion Control"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does a wetland currently exist at the project site?",2,null,null,{"$f":"IF(E7=1,\"Continue to Step 2\",IF(E7=2,\"Continue to Restored Condition Scoring\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Step 2","Is the existing wetland entirely isolated?",1,null,null,{"$f":"IF(E9=1,\"Continue to 2.2.5 Carbon Storage\",IF(E9=2,\"Continue to Step 3\"))","v":"Continue to 2.2.5 Carbon Storage"}]
[]
[null,null,"Step 3","Calculate the Fractional Area (FA) of the wetland shoreline vegetation. "]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland shoreline that is comprised of each of the wetland vegetation types. For example, if a wetland shoreline is 100% trees and shrubs the FA would be 1. If a wetland shoreline was 60% trees and shrubs and 40% emergent vegetation the FA would be .6 for trees and shrubs and .4 for emergent. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Tree and shrub shoreline",0,null,{"$f":"E14*25","v":0}]
[null,null,null,"     Fractional Area - Emergent vegetation shoreline",0,null,{"$f":"E15*12","v":0}]
[null,null,null,"     Fractional Area - Submergent vegetation shoreline",0,null,{"$f":"E16*9","v":0}]
[null,null,null,"     Fractiona Area - Other shoreline vegetation",0,null,{"$f":"E17*6","v":0}]
[null,null,null,"     Fractional Area - No vegetation",0,null,{"$f":"E18*0","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G14:G18)>25,25,SUM(G14:G18))","v":0}]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(E9=1,0,G19))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Will the proposed wetland restoration project be entirely isolated?",2,null,null,{"$f":"IF(E24=1,\"Continue to 2.2.5 Carbon Storage\",IF(E24=2,\"Continue to Step 2\"))","v":"Continue to Step 2"}]
[]
[null,null,"Step 2","Calculate the Fractional Area (FA) of the proposed wetland shoreline vegetation. "]
[null,null,null,"Note: "]
[null,null,null,"FA is simply the fraction of the total wetland shoreline that is comprised of each of the wetland vegetation types. For example, if a wetland shoreline is 100% trees and shrubs the FA would be 1. If a wetland shoreline was 60% trees and shrubs and 40% emergent vegetation the FA would be .6 for trees and shrubs and .4 for emergent. It is important that the sum of the FA's total 1. "]
[null,null,null,"     Fractional Area - Tree and shrub shoreline",0,null,{"$f":"E29*25","v":0}]
[null,null,null,"     Fractional Area - Emergent vegetation shoreline",0,null,{"$f":"E30*12","v":0}]
[null,null,null,"     Fractional Area - Submergent vegetation shoreline",0,null,{"$f":"E31*9","v":0}]
[null,null,null,"     Fractiona Area - Other shoreline vegetation",0,null,{"$f":"E32*6","v":0}]
[null,null,null,"     Fractional Area - No vegetation",0,null,{"$f":"E33*0","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G29:G33)>25,25,SUM(G29:G33))","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E24=1,0,G34)","v":0}]

{"sheet":"2.2.5 Carbon Storage","index":23,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"2.2.5 Carbon Storage"]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does a wetland currently exist at the project site?",2,null,null,{"$f":"IF(E7=1,\"Continue to Step 2\",IF(E7=2,\"Continue to Restored Condition Scoring\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Step 2","Does the wetland have permanent open water?",1,null,null,{"$f":"IF(E9=1,\"Continue to Restored Condition Scoring\",IF(E9=2,\"Continue to Restored Condition Scoring\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Existing Condition Score",null,{"$f":"IF(E7=2,0,IF(E9=1,15,5))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Does the proposed wetland restoration project intend to increase the area of permanent open water?",2,null,{"$f":"IF(E15=1,10, 0)","v":0}]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E15=1,SUM(E11,G15),E11)","v":0}]

{"sheet":"3.1.1 Goods","index":24,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"3.1.1 Sustainable Use to the Wetland for Harvesting Goods"]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Upon completion of the proposed project will the wetland be used for the harvesting of goods (i.e. food, fuel, fibre)?",2,null,{"$f":"IF(E7=1,\"Continue to Step 2\",\"Continue to 3.2.1 Recreation\")","v":"Continue to 3.2.1 Recreation"}]
[]
[null,null,"Step 2","Will the harvests take place in accordance with best management practices (i.e. fuel and fibre wood products harvested in accordance with a Managed Forest Plan and only licensed trappers, hunters and anglers granted access. ",1]
[null,null,null,"Notes:"]
[null,null,null,"If the timber associated with the wetland is immature at the moment and the Managed Forest Plan does not call for a thinning within the next 10 years answer \"yes\"."]
[null,null,null,"If fish are harvested by a licensed angler choose \"yes\" but do not score angling as a recreational activity in 3.2.1."]
[null,null,null,"Due to the devastating impacts to wetland quality, peat extraction is not recognized as sustainable use of the wetland."]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E7=2,0,IF(E9=1,25,0))","v":0}]

{"sheet":"3.2.1 Recreation","index":25,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"3.2.1 Sustainable Use of the Wetland for Recreation "]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Upon completion of the proposed project will the wetland be used for recreation (i.e catch and release fishing, hiking, bird watching and nature enjoyment)?",2,{"$f":"IF(E7=1,\"Continue to Step 2\",\"Continue to 3.3.1 Landscape Aesthetics\")","v":"Continue to 3.3.1 Landscape Aesthetics"}]
[null,null,null,"Note:"]
[null,null,null,"Only include catch and release fishing in the recreation section."]
[]
[null,null,"Step 2","What frequency of public access will be granted by the landowner? ",1]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E7=2,0,IF(E11=1,10,IF(E11=2,20,IF(E11=3,25))))","v":0}]

{"sheet":"3.3.1 Aesthetics","index":26,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"3.3.1 Landscape Aesthetics "]
[]
[null,null,"Existing Condition"]
[]
[null,null,"Step 1","Does a wetland currently exist at the project site?",2,{"$f":"IF(E7=1,\"Continue to Step 2\",IF(E7=2,\"Continue to Restored Condition Scoring\"))","v":"Continue to Restored Condition Scoring"}]
[]
[null,null,"Step 2","What is the distance between the existing wetland and the closest public space (i.e. road, trail, navigable water, neighbouring property, etc.) and is the wetland distinctly recognizable?",1]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E7=2,0,IF(E9=1,0,IF(E9=2,10,IF(E9=3,20,IF(E9=4,25)))))","v":0}]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","What is the distance between the proposed wetland and the closest public space (i.e. road, trail, navigable water, neighbouring property, etc.) and will the wetland be distinctly recognizable?",1]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E15=1,0,IF(E15=2,10,IF(E15=3,20,IF(E15=4,25))))","v":0}]

{"sheet":"3.4.1 Education & Research","index":27,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"3.4.1 Education and Research "]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Upon completion of the proposed project will the wetland be used for education and/or research?",2,{"$f":"IF(E7=1,\"Continue to Step 2\",\"Continue to 3.5.1 Enhancement to the Historical, Religious, and/or Spiritual Value\")","v":"Continue to 3.5.1 Enhancement to the Historical, Religious, and/or Spiritual Value"}]
[]
[null,null,"Step 2","What frequency of public access will be granted by the landowner? ",1]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E7=2,0,IF(E9=1,10,IF(E9=2,20,IF(E9=3,25))))","v":0}]

{"sheet":"3.5.1 Historical, Religious &..","index":28,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"3.5.1 Enhancement to the Historical, Religious and/or Spiritual Value "]
[]
[null,null,"Restored Condition"]
[]
[null,null,"Step 1","Will the proposed project enhance the historical, religious and/or spiritual value of the wetland?",2]
[null,null,null,"Note:"]
[null,null,null,"Eligible enhancements include: interpretive signage (e.g. sign informing visitors of a historic trade route through the wetland or preservation of a historical dam), public use of the wetland for religious ceremonies, or presence of sacred sites or use of the wetland for song, chant and/or stories."]
[]
[null,null,"Restored Condition Score",null,{"$f":"IF(E7=1,25,0)","v":0}]

{"sheet":"EBI Scores","index":29,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[47,5,47,6],[49,5,49,9],[48,5,48,6],[47,7,48,8],[35,2,45,2],[35,3,36,3],[37,3,38,3],[39,3,40,3],[41,3,42,3],[43,3,45,3],[6,2,23,2],[6,3,14,3],[15,3,23,3],[24,2,34,2],[24,3,27,3],[28,3,34,3],[4,9,5,9],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,6],[4,7,4,8]]}
[]
[]
[null,null,"Environmental Benefit Index Scores"]
[]
[null,null,"Component","Sub Component","Attribute","Existing Condition ",null,"Restored Condition",null,"Change in Condition"]
[null,null,null,null,null,"Maximum Points","Score","Maximum Points","Score"]
[null,null,"Biological","Wetland Site Characteristics and Biodiversity","Wetland Type",10,{"$f":"'1.1.1 Type'!E15","v":0},10,{"$f":"'1.1.1 Type'!E24","v":0},{"$f":"I7-G7","v":0}]
[null,null,null,null,"Effective Project Area",0,0,20,{"$f":"'1.1.2 Area'!E16","v":0},{"$f":"I8-G8","v":0}]
[null,null,null,null,"Proximity to Other Wetlands",10,{"$f":"'1.1.3 Proximity'!E13","v":0},10,{"$f":"'1.1.3 Proximity'!E23","v":0},0]
[null,null,null,null,"Permanent and Seasonal Open Water Types",10,{"$f":"'1.1.4 Open Water'!E23","v":0},10,{"$f":"'1.1.4 Open Water'!E38","v":0},0]
[null,null,null,null,"Interspersion",10,{"$f":"'1.1.5 Interspersion'!E14","v":0},10,{"$f":"'1.1.5 Interspersion'!E25","v":0},0]
[null,null,null,null,"Vegetation Communities on the Site",45,{"$f":"'1.1.6 Vegetation Communities'!E12","v":0},45,{"$f":"'1.1.6 Vegetation Communities'!E21","v":0},0]
[null,null,null,null,"Diversity of Surrounding Habitat",10,{"$f":"'1.1.7 Diversity'!E21","v":0},10,{"$f":"'1.1.7 Diversity'!E37","v":0},0]
[null,null,null,null,"Carbon Sequestration",15,{"$f":"'1.1.8 Carbon Sequestration'!E12","v":0},25,{"$f":"'1.1.8 Carbon Sequestration'!E23","v":0},0]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F7:F14)","v":110},{"$f":"SUM(G7:G14)","v":0},{"$f":"SUM(H7:H14)","v":140},{"$f":"SUM(I7:I14)","v":0},{"$f":"SUM(J7:J14)","v":0}]
[null,null,null,"Wildlife and Wildlife Habitat","Reproductive Habitat for Endangered and/or Threatened Species",12,{"$f":"'1.2.1 Reproductive Habitat'!E18","v":0},24,{"$f":"'1.2.1 Reproductive Habitat'!E27","v":0},0]
[null,null,null,null,"Traditional Migration, Feeding or Hibernation Habitat for Endangered and/or Threatened Species",12,{"$f":"'1.2.2 Migration...Habitat'!E18","v":0},24,{"$f":"'1.2.2 Migration...Habitat'!E27","v":0},0]
[null,null,null,null,"Presence of Locally, Regionally, and/or Provincially Significant Plan and Animal Species",20,{"$f":"'1.2.3 Significant Species'!E16","v":0},30,{"$f":"'1.2.3 Significant Species'!E25","v":0},0]
[null,null,null,null,"Nesting and Feeding Habitat for Colonial Waterbirds",10,{"$f":"'1.2.4 Colonial Waterbirds'!E18","v":0},15,{"$f":"'1.2.4 Colonial Waterbirds'!E26","v":0},0]
[null,null,null,null,"Waterfowl Breeding, Staging and/or Moulting Area",10,{"$f":"'1.2.5 Waterfowl'!E20","v":0},15,{"$f":"'1.2.5 Waterfowl'!E30","v":0},0]
[null,null,null,null,"Migratory Passerine, Shorebird, or Raptor Stopover Area",10,{"$f":"'1.2.6 Passerine, Shorebird...'!E19","v":0},15,{"$f":"'1.2.6 Passerine, Shorebird...'!E29","v":0},0]
[null,null,null,null,"Fish Habitat",20,{"$f":"'1.2.7 Fish'!E20","v":0},20,{"$f":"'1.2.7 Fish'!E30","v":0},0]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F16:F22)","v":94},{"$f":"SUM(G16:G22)","v":0},{"$f":"SUM(H16:H22)","v":143},{"$f":"SUM(I16:I22)","v":0},{"$f":"SUM(J16:J22)","v":0}]
[null,null,null,null,"TOTAL",{"$f":"SUM(F15,F23)","v":204},{"$f":"SUM(G15,G23)","v":0},{"$f":"SUM(H15,H23)","v":283},{"$f":"SUM(I15,I23)","v":0},{"$f":"SUM(J15,J23)","v":0}]
[null,null,"Hydrological","Flood Attenuation and Ground Water Recharge/Discharge","Flood Attenuation Capacity",75,{"$f":"'2.1.1 Flood Attenuation'!E62","v":0},75,{"$f":"'2.1.1 Flood Attenuation'!E74","v":0},{"$f":"I25-G25","v":0}]
[null,null,null,null,"Ground Water Discharge",25,{"$f":"'2.1.2 Groundwater Discharge'!E16","v":0},25,{"$f":"'2.1.2 Groundwater Discharge'!E27","v":0},0]
[null,null,null,null,"Ground Water Recharge",25,{"$f":"'2.1.3 Groundwater Recharge'!E29","v":0},25,{"$f":"'2.1.3 Groundwater Recharge'!E49","v":0},0]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F25:F27)","v":125},{"$f":"SUM(G25:G27)","v":0},{"$f":"SUM(H25:H27)","v":125},{"$f":"SUM(I25:I27)","v":0},{"$f":"SUM(J25:J27)","v":0}]
[null,null,null,"Water Quality and Carbon Storage","Short-Term Water Quality Improvement (in wetland)",50,{"$f":"'2.2.1 ST Water Quality Wetland '!E28","v":0},50,{"$f":"'2.2.1 ST Water Quality Wetland '!E51","v":0},0]
[null,null,null,null,"Short-Term Water Quality Improvement (in upland buffer)",50,{"$f":"'2.2.2 ST Water Quality Buffer'!E35","v":0},50,{"$f":"'2.2.2 ST Water Quality Buffer'!E65","v":0},0]
[null,null,null,null,"Long-Term Nutrient Trap (in wetland)",50,{"$f":"'2.2.3 LT Water Quality'!E13","v":0},50,{"$f":"'2.2.3 LT Water Quality'!E21","v":0},0]
[null,null,null,null,"Shoreline Erosion Control",25,{"$f":"'2.2.4 Erosion'!E20","v":0},25,{"$f":"'2.2.4 Erosion'!E36","v":0},0]
[null,null,null,null,"Carbon Storage",15,{"$f":"'2.2.5 Carbon Storage'!E11","v":0},25,{"$f":"'2.2.5 Carbon Storage'!E17","v":0},{"$f":"I33-G33","v":0}]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F29:F33)","v":190},{"$f":"SUM(G29:G33)","v":0},{"$f":"SUM(H29:H33)","v":200},{"$f":"SUM(I29:I33)","v":0},{"$f":"SUM(J29:J33)","v":0}]
[null,null,null,null,"TOTAL",{"$f":"SUM(F28,F34)","v":315},{"$f":"SUM(G28,G34)","v":0},{"$f":"SUM(H28,H34)","v":325},{"$f":"SUM(I28,I34)","v":0},{"$f":"SUM(J28,J34)","v":0}]
[null,null,"Social","Goods","Sustainable Use of Wetland for Harvesting Food and/or Fuel and/or Fibre",0,0,25,{"$f":"'3.1.1 Goods'!E15","v":0},{"$f":"I36-G36","v":0}]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F36:F36)","v":0},{"$f":"SUM(G36:G36)","v":0},{"$f":"SUM(H36:H36)","v":25},{"$f":"SUM(I36:I36)","v":0},{"$f":"SUM(J36:J36)","v":0}]
[null,null,null,"Recreation","Sustainable use of the Wetland for Catch and Release Fishing, Hiking, Bird Watching and Nature Enjoyment",0,0,25,{"$f":"'3.2.1 Recreation'!E13","v":0},{"$f":"I38-G38","v":0}]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F38:F38)","v":0},{"$f":"SUM(G38:G38)","v":0},{"$f":"SUM(H38:H38)","v":25},{"$f":"SUM(I38:I38)","v":0},{"$f":"SUM(J38:J38)","v":0}]
[null,null,null,"Aesthetics","Landscape Aesthetics",25,{"$f":"'3.3.1 Aesthetics'!E11","v":0},25,{"$f":"'3.3.1 Aesthetics'!E17","v":0},{"$f":"I40-G40","v":0}]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F40)","v":25},{"$f":"SUM(G40)","v":0},{"$f":"SUM(H40)","v":25},{"$f":"SUM(I40)","v":0},{"$f":"SUM(J40)","v":0}]
[null,null,null,"Education and Research ","Use of the Wetland for Education and Research Activities",0,0,25,{"$f":"'3.4.1 Education & Research'!E11","v":0},{"$f":"I42-G42","v":0}]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F42)","v":0},{"$f":"SUM(G42)","v":0},{"$f":"SUM(H42)","v":25},{"$f":"SUM(I42)","v":0},{"$f":"SUM(J42)","v":0}]
[null,null,null,"Cultural and Aboriginal Values","Enhancement to the Historical, Religious and/or Spiritual Value of the Wetland",0,0,25,{"$f":"'3.5.1 Historical, Religious &..'!E11","v":0},{"$f":"I44-G44","v":0}]
[null,null,null,null,"SUBTOTAL",{"$f":"SUM(F44)","v":0},{"$f":"SUM(G44)","v":0},{"$f":"SUM(H44)","v":25},{"$f":"SUM(I44)","v":0},{"$f":"SUM(J44)","v":0}]
[null,null,null,null,"TOTAL",{"$f":"SUM(F37,F39,F41,F43,F45)","v":25},{"$f":"SUM(G37,G39,G41,G43,G45)","v":0},{"$f":"SUM(H37,H39,H41,H43,H45)","v":125},{"$f":"SUM(I37,I39,I41,I43,I45)","v":0},{"$f":"SUM(J37,J39,J41,J43,J45)","v":0}]
[null,null,null,null,"GRAND TOTAL",{"$f":"SUM(F24,F35,F46)","v":544},{"$f":"SUM(G24,G35,G46)","v":0},{"$f":"SUM(H24,H35,H46)","v":733},{"$f":"SUM(I24,I35,I46)","v":0},{"$f":"SUM(J24,J35,J46)","v":0}]
[null,null,null,null,"WEIGHTING",0.55000000000000004,null,null,null,0.45]
[null,null,null,null,"ADJUSTED SCORE",{"$f":"G47*F48","v":0},null,null,null,{"$f":"J47*J48","v":0}]
[null,null,null,null,"EBI SCORE",{"$f":"SUM(F49,J49)","v":0}]
[]
[null,null,"Bonus Scores"]
[null,null,"Climate Change Score",{"$f":"SUM(J14,J25,J26,J27,J33)","v":0},"out of a possible 175"]
[null,null,"Pollution Reduction Score",{"$f":"SUM(J14,J29,J30,J31,J32,J33)","v":0},"out of a possible 225"]

{"sheet":"Admin.","index":30,"n_rows":119,"n_cols":14,"rows_kept":119,"cut":false,"hidden":false,"merged":[[45,0,45,12],[28,0,28,12]]}
["NOTE: DO NOT MAKE EDITS TO THIS PAGE UNLESS YOU WISH TO CHANGE THE FUNCTIONALITY OF THE CALCULATOR. IN THIS CASE, MAKE EDITS WITH CAUTION!"]
["YES"]
["NO"]
[]
["CULTIVATED LAND"]
["PASTURE"]
["MEADOW"]
["FOREST"]
["RESIDENTIAL LOT (SIZE 0.05HA)"]
["RESIDENTIAL LOT (SIZE 0.1HA)"]
["RESIDENTIAL LOT (SIZE 0.13HA)"]
["RESIDENTIAL LOT (SIZE 0.2HA)"]
["RESIDENTIAL LOT (SIZE 0.4HA)"]
["INDUSTRIAL"]
["COMMERCIAL"]
["STREETS"]
["OPEN SPACE"]
["PARKING"]
[]
["SAND"]
["SANDY LOAM"]
["CLAY LOAM"]
["CLAY"]
[]
["0-2%"]
["2-6%"]
[">6%"]
[]
["FOR STORM INERVALS LESS THAN 25 YEARS"]
["ID","LAND USE","0-2% / SANDY","2-6% / SANDY","6% / SANDY","0-2% / SANDY LOAM","2-6% / SANDY LOAM","6% / SANDY LOAM","0-2% / CLAY LOAM","2-6% / CLAY LOAM","6% / CLAY LOAM","0-2% / CLAY","2-6% / CLAY","6% / CLAY"]
[1,"CULTIVATED LAND",0.08,0.13,0.16,0.11,0.15,0.21,0.14000000000000001,0.19,0.26,0.18,0.23,0.31]
[2,"PASTURE",0.12,0.2,0.3,0.18,0.28000000000000003,0.37,0.24,0.34,0.44,0.3,0.4,0.5]
[3,"MEADOW",0.1,0.16,0.25,0.14000000000000001,0.22,0.3,0.2,0.28000000000000003,0.36,0.24,0.3,0.4]
[4,"FOREST",0.05,0.08,0.11,0.08,0.11,0.14000000000000001,0.1,0.13,0.16,0.12,0.16,0.3]
[5,"RESIDENTIAL LOT (SIZE 0.05HA)",0.25,0.28000000000000003,0.31,0.27,0.3,0.35,0.3,0.33,0.38,0.33,0.36,0.42]
[6,"RESIDENTIAL LOT (SIZE 0.1HA)",0.22,0.26,0.28999999999999998,0.24,0.28999999999999998,0.33,0.27,0.31,0.36,0.3,0.34,0.4]
[7,"RESIDENTIAL LOT (SIZE 0.13HA)",0.19,0.23,0.26,0.22,0.26,0.3,0.25,0.28999999999999998,0.34,0.28000000000000003,0.32,0.39]
[8,"RESIDENTIAL LOT (SIZE 0.2HA)",0.16,0.2,0.24,0.19,0.23,0.28000000000000003,0.22,0.27,0.32,0.26,0.3,0.37]
[9,"RESIDENTIAL LOT (SIZE 0.4HA)",0.14000000000000001,0.19,0.22,0.17,0.21,0.26,0.2,0.25,0.31,0.24,0.28999999999999998,0.35]
[10,"INDUSTRIAL",0.67,0.68,0.68,0.68,0.68,0.69,0.68,0.69,0.69,0.69,0.69,0.7]
[11,"COMMERCIAL",0.71,0.71,0.72,0.71,0.72,0.72,0.72,0.72,0.72,0.72,0.72,0.72]
[12,"STREETS",0.7,0.71,0.72,0.71,0.72,0.74,0.72,0.73,0.76,0.73,0.75,0.78]
[13,"OPEN SPACE",0.05,0.1,0.14000000000000001,0.08,0.13,0.19,0.12,0.17,0.24,0.15,0.21,0.28000000000000003]
[14,"PARKING",0.85,0.86,0.87,0.85,0.86,0.87,0.85,0.86,0.87,0.85,0.86,0.87]
[]
["FOR STORM RECURRENCE INTERVALS OF 25 YEARS OR GREATER"]
["LAND USE","0-2% / SANDY","2-6% / SANDY","6% / SANDY","0-2% / SANDY LOAM","2-6% / SANDY LOAM","6% / SANDY LOAM","0-2% / CLAY LOAM","2-6% / CLAY LOAM","6% / CLAY LOAM","0-2% / CLAY","2-6% / CLAY","6% / CLAY"]
["CULTIVATED LAND",0.14000000000000001,0.18,0.22,0.16,0.21,0.28000000000000003,0.2,0.25,0.34,0.24,0.28999999999999998,0.41]
["PASTURE",0.15,0.25,0.37,0.23,0.34,0.45,0.3,0.42,0.52,0.37,0.5,0.62]
["MEADOW",0.14000000000000001,0.22,0.3,0.2,0.28000000000000003,0.37,0.26,0.35,0.44,0.3,0.4,0.5]
["FOREST",0.08,0.11,0.14000000000000001,0.1,0.14000000000000001,0.18,0.12,0.16,0.2,0.15,0.2,0.25]
["RESIDENTIAL LOT (SIZE 0.05HA)",0.33,0.37,0.4,0.35,0.39,0.44,0.38,0.42,0.49,0.41,0.45,0.54]
["RESIDENTIAL LOT (SIZE 0.1HA)",0.3,0.34,0.37,0.33,0.37,0.42,0.36,0.4,0.47,0.38,0.42,0.52]
["RESIDENTIAL LOT (SIZE 0.13HA)",0.28000000000000003,0.32,0.35,0.3,0.35,0.39,0.33,0.38,0.45,0.36,0.4,0.5]
["RESIDENTIAL LOT (SIZE 0.2HA)",0.25,0.28999999999999998,0.32,0.28000000000000003,0.32,0.36,0.31,0.35,0.42,0.34,0.38,0.48]
["RESIDENTIAL LOT (SIZE 0.4HA)",0.22,0.26,0.28999999999999998,0.24,0.28000000000000003,0.34,0.28000000000000003,0.32,0.4,0.31,0.35,0.46]
["INDUSTRIAL",0.85,0.85,0.86,0.85,0.86,0.86,0.86,0.86,0.87,0.86,0.86,0.88]
["COMMERCIAL",0.88,0.88,0.89,0.89,0.89,0.89,0.89,0.89,0.9,0.89,0.89,0.9]
["STREETS",0.76,0.77,0.79,0.8,0.82,0.84,0.84,0.85,0.89,0.89,0.91,0.95]
["OPEN SPACE",0.11,0.16,0.2,0.14000000000000001,0.19,0.26,0.18,0.23,0.32,0.22,0.27,0.39]
["PARKING",0.95,0.96,0.97,0.95,0.96,0.97,0.95,0.96,0.97,0.95,0.96,0.97]
[]
["Bog","Flat","Large (>50% wetland)","None ","None","None"]
["Swamp","Rolling","Moderate (5-50% wetland)","Minor","Seasonal","Present"]
["Marsh","Hilly","Small (<5% wetland)","Extensive","Permanent"]
["Fen","Steep"]
[]
["Sand"]
["Gravel"]
["Loam"]
["Clay"]
["Substrates in high water tables "]
["Shallow substrates over impervious materials such as consolidated bedrock"]
[]
["Isolated"]
["Palustrine"]
["Riverine"]
["Lacustrine"]
[]
["Over 50% agricultural and/or urban"]
["Between 30% and 50% agricultural and/or urban"]
["Over 50% forested or other natural vegetation"]
[]
["Simple species buffer containing only trees, or shrubs, or trees"]
["Complex species buffer containing trees, shrubs and grasses/forbs"]
[]
[1]
["50-99%"]
["less than 50%"]
[]
["15m to less than 50m"]
["10m to less than 15m"]
["5m to less than 10m"]
["Less than 5m"]
[]
["Less than 5%"]
["5% to less than 10%"]
["10% to less than 15%"]
["Greater than 15%"]
[]
["Sand"]
["Loam"]
["Clay"]
[]
["Wetland does not have permanent open water"]
["Wetland does have permanent open water"]
[]
["Infrequent, situation-by-situation (daily) basis"]
["Frequent, long standing (monthly, seasonly) informal basis"]
["Year-round, formalized access (i.e. Bruce Trail Agreement, etc.)"]
[]
["Greater than or equal to 120 metres and wetland is not distinctly recognizable"]
["Greater than or equal to 120 metres and wetland is distinctly recognizable"]
["Less than 120 metres"]
["Immediately adjacent"]
[]
["Minimal public allowance on an infrequent, situation-by-situation (daily) basis"]
["Public allowance on a frequent (ongoing) basis"]
["Public allowance on a more frequent (ongoing) basis and landowner is willing to participate in education and research activities"]