{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Data Entry","Extraction Calculator","Drainage Calculator","Rewetting Calculator","Wetlands-Wetlands Calculator","Results Summary","Lookup Table"],"not_rendered":{"charts":4,"images":15,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Instructions","index":0,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[36,1,36,16],[44,7,44,8],[35,1,35,13],[0,1,0,7]]}
[null,"Blue Carbon Calculator Instructions"]
[]
["Before you begin,  be sure to click \"Enable Content\" when prompted."]
[]
[]
[]
["1.)","Determine what types of changes will occur within the wetland as a result of your project and enter the land cover data on the ",null,null,null,null,null,null,null,null,null,null,"tab using all three decision trees "]
[null,"below as guidance. One project may result in just one or multiple changes to the wetland."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: Data entered into the \"Upland\" categories is not used in the computation of greenhouse gas emissions or reductions because it is not included in the IPCC methods. The rows are included to ensure correct data entry and for future development of the calculator, which may include emissions factors for these land covers."]
["2.)","Be sure that you have not double counted any areas, ie: an area that is being rewetted is not also entered into the \"post\" column for wetlands remaining wetlands."]
[]
["3.)","Enter the project name at the bottom of the",null,null,null,"       sheet. Click"]
[]
["4.)","If you are navigated to the",null,null,"or",null,null,", enter data into the bold colored cells with black print. Click"]
[]
["5.)","Once all required data is entered, you will be automatically navigated the ",null,null,null,null,null,null," tab and can view the change in emissions resulting from your project, "]
[null,"relative to previous conditions. Results are shown as cumulative emissions over the 50 years following the project. When you are ready to enter data for a new project,"]
[null,"either click",null,"on the",null,"tab, or the","tab."]

{"sheet":"Data Entry","index":1,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[[74,4,74,5],[70,0,70,2],[61,0,69,0],[61,1,64,1],[0,0,3,0],[5,0,26,0],[27,0,60,0],[27,1,39,1],[0,2,3,2],[0,1,3,1],[16,1,26,1],[5,1,15,1],[61,8,63,8],[65,1,69,1],[65,8,67,8],[68,8,69,8],[51,8,52,8],[53,1,60,1],[53,8,60,8],[40,1,52,1],[41,8,46,8],[47,8,50,8],[34,8,37,8],[38,8,39,8],[2,6,2,7],[1,3,1,4],[2,3,3,3],[0,8,3,8],[0,3,0,7],[2,4,3,4],[2,5,3,5],[1,5,1,7],[5,8,8,8],[16,8,19,8],[9,8,14,8],[20,8,25,8],[28,8,33,8],[53,11,60,11],[0,10,3,10],[0,9,3,9],[0,11,3,11],[53,13,60,13],[53,9,60,9],[53,12,60,12],[0,12,2,13],[53,10,60,10]]}
["Location","Soil Type","MA DEP Wetland Category","Wetland Changes",null,null,null,null,"Calculator Land Use Category","Values for extraction calculator","Values for Drained Calculator","Values for Rewetting Calculator","Values for Conversion Calculator"]
[null,null,null,"Wetlands Destruction",null,"Wetlands Restoration"]
[null,null,null,"Wetland area to be extracted","Wetland area to be drained","Rewetted wetland area","Wetlands Remaining Weltands"]
[null,null,null,null,null,null,"Saturated area prior to project","Saturated area post project",null,null,null,null,"Pre-Conversion Area","Post-Conversion Area"]
[null,null,null,"(acres)","(acres)","(acres)","(acres)","(acres)",null,"(ha)","(ha)","(ha)","(ha)","(ha)"]
["Inland Wetland","Organic","DEEP MARSH",null,null,null,null,null,"FW Wetland",{"$f":"SUM(D6:D9)/2.2411","v":0},{"$f":"SUM(E6:E9)/2.2411","v":0},{"$f":"SUM(F6:F9)/2.2411","v":0},{"$f":"SUM(G6:G9)/2.2411","v":0},{"$f":"SUM(H6:H9)/2.2411","v":0}]
[null,null,"SHALLOW MARSH, MEADOW, OR FEN"]
[null,null,"BOG"]
[null,null,"SHRUB SWAMP"]
[null,null,"WOODED SWAMP DECIDUOUS",null,null,null,null,null,"FW Forested Wetland",{"$f":"SUM(D10:D15)/2.2411","v":0},{"$f":"SUM(E10:E15)/2.2411","v":0},{"$f":"SUM(F10:F15)/2.2411","v":0},{"$f":"SUM(G10:G15)/2.2411","v":0},0]
[null,null,"WOODED SWAMP CONIFEROUS"]
[null,null,"WOODED SWAMP MIXED TREES"]
[null,null,"FLOODPLAIN FOREST DECID"]
[null,null,"FLOODPLAIN FOREST CONIF"]
[null,null,"FLOODPLAIN FOREST MIX"]
[null,null,"OPEN WATER (FRESH)",null,null,null,null,null,"Open water fresh",{"$f":"D16/2.2411","v":0},{"$f":"E16/2.2411","v":0},{"$f":"F16/2.2411","v":0},{"$f":"G16/2.2411","v":0},0]
[null,"Mineral","DEEP MARSH",null,null,null,null,null,"FW Wetland",{"$f":"SUM(D17:D20)/2.2411","v":0},{"$f":"SUM(E17:E20)/2.2411","v":0},{"$f":"SUM(F17:F20)/2.2411","v":0},{"$f":"SUM(G17:G20)/2.2411","v":0},0]
[null,null,"SHALLOW MARSH, MEADOW, OR FEN"]
[null,null,"BOG"]
[null,null,"SHRUB SWAMP"]
[null,null,"WOODED SWAMP DECIDUOUS",null,null,null,null,null,"FW Forested Wetland",{"$f":"SUM(D21:D26)/2.2411","v":0},{"$f":"SUM(E21:E26)/2.2411","v":0},{"$f":"SUM(F21:F26)/2.2411","v":0},{"$f":"SUM(G21:G26)/2.2411","v":0},0]
[null,null,"WOODED SWAMP CONIFEROUS"]
[null,null,"WOODED SWAMP MIXED TREES"]
[null,null,"FLOODPLAIN FOREST DECID"]
[null,null,"FLOODPLAIN FOREST CONIF"]
[null,null,"FLOODPLAIN FOREST MIX"]
[null,null,"OPEN WATER (FRESH)",null,null,null,null,null,"Open water fresh",{"$f":"D27/2.2411","v":0},{"$f":"E27/2.2411","v":0},{"$f":"F27/2.2411","v":0},{"$f":"G27/2.2411","v":0},0]
["Coastal Wetland","Organic","PHRAGMITES DOMINATED - WETLAND",null,null,null,null,null,"Phragmites Wetland",{"$f":"D28/2.2411","v":0},{"$f":"E28/2.2411","v":0},0,0,0]
[null,null,"SALT MARSH - HIGH",null,null,null,null,null,"SW/brackish Wetland",{"$f":"SUM(D29:D34)/2.2411","v":0},{"$f":"SUM(E29:E34)/2.2411","v":0},{"$f":"SUM(F29:F34)/2.2411","v":0},{"$f":"SUM(G29:G34)/2.2411","v":0},{"$f":"SUM(H29:H34)/2.2411","v":0}]
[null,null,"SALT MARSH - LOW"]
[null,null,"BARRIER BEACH-BOG"]
[null,null,"BARRIER BEACH-SALT MARSH"]
[null,null,"BARRIER BEACH-DEEP MARSH"]
[null,null,"BARRIER BEACH-MARSH"]
[null,null,"BARRIER BEACH-SHRUB SWAMP",null,null,null,null,null,"SW/brackish Forested Wetland",{"$f":"SUM(D35:D38)/2.2411","v":0},{"$f":"SUM(E35:E38)/2.2411","v":0},{"$f":"SUM(F35:F38)/2.2411","v":0},{"$f":"SUM(G35:G38)/2.2411","v":0},0]
[null,null,"BARRIER BEACH-WOODED SWAMP DECIDUOUS"]
[null,null,"BARRIER BEACH-WOODED SWAMP CONIFEROUS"]
[null,null,"BARRIER BEACH-WOODED SWAMP MIXED TREES"]
[null,null,"OPEN WATER (SALT)",null,null,null,null,null,"Open water salt",{"$f":"SUM(D39:D40)/2.2411","v":0},{"$f":"SUM(E39:E40)/2.2411","v":0},{"$f":"SUM(F39:F40)/2.2411","v":0},{"$f":"SUM(G39:G40)/2.2411","v":0},0]
[null,null,"BARRIER BEACH-OPEN WATER"]
[null,"Mineral","PHRAGMITES DOMINATED - WETLAND",null,null,null,null,null,"Phragmites Wetland",{"$f":"D41/2.2411","v":0},{"$f":"E41/2.2411","v":0},{"$f":"F41/2.2411","v":0},{"$f":"G41/2.2411","v":0},0]
[null,null,"SALT MARSH - HIGH",null,null,null,null,null,"SW/brackish Wetland",{"$f":"SUM(D42:D47)/2.2411","v":0},{"$f":"SUM(E42:E47)/2.2411","v":0},{"$f":"SUM(F42:F47)/2.2411","v":0},{"$f":"SUM(G42:G47)/2.2411","v":0},0]
[null,null,"SALT MARSH - LOW"]
[null,null,"BARRIER BEACH-BOG"]
[null,null,"BARRIER BEACH-SALT MARSH"]
[null,null,"BARRIER BEACH-DEEP MARSH"]
[null,null,"BARRIER BEACH-MARSH"]
[null,null,"BARRIER BEACH-SHRUB SWAMP",null,null,null,null,null,"FW Forested Tidal Wetland",{"$f":"SUM(D48:D51)/2.2411","v":0},{"$f":"SUM(E48:E51)/2.2411","v":0},{"$f":"SUM(F48:F51)/2.2411","v":0},{"$f":"SUM(G48:G51)/2.2411","v":0},0]
[null,null,"BARRIER BEACH-WOODED SWAMP DECIDUOUS"]
[null,null,"BARRIER BEACH-WOODED SWAMP CONIFEROUS"]
[null,null,"BARRIER BEACH-WOODED SWAMP MIXED TREES"]
[null,null,"OPEN WATER (SALT)",null,null,null,null,null,"Open water salt",{"$f":"SUM(D52:D53)/2.2411","v":0},{"$f":"SUM(E52:E53)/2.2411","v":0},{"$f":"SUM(F52:F53)/2.2411","v":0},{"$f":"SUM(G52:G53)/2.2411","v":0},{"$f":"SUM(H52:H53)/2.2411","v":0}]
[null,null,"BARRIER BEACH-OPEN WATER"]
[null,"NA","TIDAL FLAT",null,null,null,null,null,"No Guidance"]
[null,null,"COASTAL BEACH"]
[null,null,"COASTAL DUNE"]
[null,null,"BARRIER BEACH SYSTEM"]
[null,null,"ROCKY INTERTIDAL SHORE"]
[null,null,"COASTAL BANK BLUFF OR SEA CLIFF"]
[null,null,"BARRIER BEACH-COASTAL BEACH"]
[null,null,"BARRIER BEACH-COASTAL DUNE"]
["Upland","Organic","FORESTED UPLAND DECIDUOUS",null,null,null,null,null,"Forest",{"$f":"SUM(D62:D64)","v":0},{"$f":"SUM(E62:E64)","v":0},{"$f":"SUM(F62:F64)","v":0},{"$f":"SUM(G62:G64)","v":0},0]
[null,null,"FORESTED UPLAND CONIFEROUS"]
[null,null,"FORESTED UPLAND MIX"]
[null,null,"GRASSLAND UPLAND",null,null,null,null,null,"Grassland",{"$f":"SUM(D65:D65)","v":0},{"$f":"SUM(E65:E65)","v":0},{"$f":"SUM(F65:F65)","v":0},{"$f":"SUM(G65:G65)","v":0},{"$f":"SUM(H65:H65)","v":0}]
[null,"Mineral","FORESTED UPLAND DECIDUOUS",null,null,null,null,null,"Forest",{"$f":"SUM(D66:D68)","v":0},{"$f":"SUM(E66:E68)","v":0},{"$f":"SUM(F66:F68)","v":0},{"$f":"SUM(G66:G68)","v":0},0]
[null,null,"FORESTED UPLAND CONIFEROUS"]
[null,null,"FORESTED UPLAND MIX"]
[null,null,"GRASSLAND UPLAND",null,null,null,null,null,"Grassland",{"$f":"SUM(D69:D70)","v":0},{"$f":"SUM(E69:E70)","v":0},{"$f":"SUM(F69:F70)","v":0},{"$f":"SUM(G69:G70)","v":0},{"$f":"SUM(H69:H70)","v":0}]
[null,null,"CRANBERRY BOG"]
["Total:",null,null,{"$f":"SUM(D6:D70)","v":0},0,0,0,0]
[]
[]
[]
[null,null,null,"Project Name:"]

{"sheet":"Extraction Calculator","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,7,2,7],[4,0,9,0],[4,1,6,1],[7,1,9,1],[10,0,17,0],[10,1,13,1],[14,1,17,1],[1,5,2,5],[1,6,2,6],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,2,3],[1,4,2,4]]}
[]
["Location","Soil Type","Land Use Category","Pre Extraction area","Soil C stock","Emissions CO2-C ","Emissions  CO2e ","Emissions  gasoline"]
[]
[null,null,null,"(ha)","(tonnes C/ha)","tonnes CO2-C/yr","tonnes CO2e/yr","gallons of gasoline equivalents/yr"]
["Inland Wetland","Organic","FW Wetland",{"$f":"'Data Entry'!J6","v":0},{"$f":"'Lookup Table'!D4","v":0},{"$f":"E5*D5","v":0},{"$f":"F5*44/12","v":0},{"$f":"G5*113","v":0}]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!J10","v":0},{"$f":"'Lookup Table'!D6","v":0},{"$f":"E6*D6","v":0},{"$f":"F6*44/12","v":0},{"$f":"G6*113","v":0}]
[null,null,"Open water fresh",{"$f":"'Data Entry'!J16","v":0},{"$f":"'Lookup Table'!D8","v":0},0,0,0]
[null,"Mineral","FW Wetland",{"$f":"'Data Entry'!J17","v":0},{"$f":"'Lookup Table'!D10","v":128},0,0,0]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!J21","v":0},{"$f":"'Lookup Table'!D11","v":128},0,0,0]
[null,null,"Open water fresh",{"$f":"'Data Entry'!J27","v":0},{"$f":"'Lookup Table'!D12","v":0},0,0,0]
["Coastal Wetland","Organic","Phragmites Wetland",{"$f":"'Data Entry'!J28","v":0},{"$f":"'Lookup Table'!D13","v":340},0,0,0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!J29","v":0},{"$f":"'Lookup Table'!D14","v":340},0,0,0]
[null,null,"SW/brackish Forested Wetland",{"$f":"'Data Entry'!J35","v":0},{"$f":"'Lookup Table'!D15","v":340},0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!J39","v":0},{"$f":"'Lookup Table'!D16","v":0},0,0,0]
[null,"Mineral","Phragmites Wetland",{"$f":"'Data Entry'!J41","v":0},{"$f":"'Lookup Table'!D17","v":226},0,0,0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!J42","v":0},{"$f":"'Lookup Table'!D18","v":226},0,0,0]
[null,null,"FW Coastal Forested Wetland",{"$f":"'Data Entry'!J48","v":0},{"$f":"'Lookup Table'!D19","v":226},0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!J52","v":0},{"$f":"'Lookup Table'!D20","v":0},0,{"$f":"F18*44/12","v":0},0]
[null,null,null,null,"Total:",{"$f":"SUM(F5:F18)","v":0},{"$f":"SUM(G5:G18)","v":0},{"$f":"SUM(H5:H18)","v":0}]

{"sheet":"Drainage Calculator","index":3,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,10,2,10],[4,0,9,0],[4,1,6,1],[7,1,9,1],[1,7,2,7],[1,8,2,8],[1,9,2,9],[10,0,17,0],[10,1,13,1],[14,1,17,1],[1,5,2,5],[1,6,2,6],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,2,3],[1,4,2,4]]}
[]
["Location","Soil Type","Land Use Category","Pre Draining area","Emissions Factor DOC","Emissions Factor CO2","Emissions Factor CH4","Emissions CO2-C ","Emissions CH4-C ","Emissions  CO2e ","Emissions  gasoline"]
[]
[null,null,null,"(ha)","tonnes C/yr","tonnes CO2-C/ha/yr","tonnes CH4-C/ha/yr","tonnes CO2-C/yr","tonnes CH4-C/yr","tonnes CO2e/yr","gallons of gasoline equivalents/yr"]
["Inland Wetland","Organic","FW Wetland",{"$f":"'Data Entry'!K6","v":0},{"$f":"'Lookup Table'!E4","v":0.31},{"$f":"'Lookup Table'!F4","v":0},{"$f":"'Lookup Table'!G4","v":0},{"$f":"SUM(E5:F5)*D5","v":0},{"$f":"D5*G5","v":0},{"$f":"(H5*44/12)+(I5*16/12*34)","v":0},{"$f":"J5*113","v":0}]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!K10","v":0},{"$f":"'Lookup Table'!E6","v":0.31},{"$f":"'Lookup Table'!F6","v":0},{"$f":"'Lookup Table'!G6","v":0},0,0,{"$f":"(H6*44/12)+(I6*16/12*34)","v":0},{"$f":"J6*113","v":0}]
[null,null,"Open water fresh",{"$f":"'Data Entry'!K16","v":0},{"$f":"'Lookup Table'!E8","v":0},{"$f":"'Lookup Table'!F8","v":0},{"$f":"'Lookup Table'!G8","v":0},0,0,0,0]
[null,"Mineral","FW Wetland",{"$f":"'Data Entry'!K17","v":0},{"$f":"'Lookup Table'!E10","v":0},{"$f":"'Lookup Table'!F10","v":6.4},{"$f":"'Lookup Table'!G10","v":0},0,0,0,0]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!K21","v":0},{"$f":"'Lookup Table'!E11","v":0},{"$f":"'Lookup Table'!F11","v":6.4},{"$f":"'Lookup Table'!G11","v":0},0,0,0,0]
[null,null,"Open water fresh",{"$f":"'Data Entry'!K27","v":0},{"$f":"'Lookup Table'!E12","v":0},{"$f":"'Lookup Table'!F12","v":0},{"$f":"'Lookup Table'!G12","v":0},0,0,0,0]
["Coastal Wetland","Organic","Phragmites Wetland",{"$f":"'Data Entry'!K28","v":0},{"$f":"'Lookup Table'!E13","v":0},{"$f":"'Lookup Table'!F13","v":7.9},{"$f":"'Lookup Table'!G13","v":0},0,0,0,0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!K29","v":0},{"$f":"'Lookup Table'!E14","v":0},{"$f":"'Lookup Table'!F14","v":7.9},{"$f":"'Lookup Table'!G14","v":0},0,0,0,0]
[null,null,"SW/brackish Forested Wetland",{"$f":"'Data Entry'!K35","v":0},{"$f":"'Lookup Table'!E15","v":0},{"$f":"'Lookup Table'!F15","v":7.9},{"$f":"'Lookup Table'!G15","v":0},0,0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!K39","v":0},{"$f":"'Lookup Table'!E16","v":0},{"$f":"'Lookup Table'!F16","v":0},{"$f":"'Lookup Table'!G16","v":0},0,0,0,0]
[null,"Mineral","Phragmites Wetland",{"$f":"'Data Entry'!K41","v":0},{"$f":"'Lookup Table'!E17","v":0},{"$f":"'Lookup Table'!F17","v":7.9},{"$f":"'Lookup Table'!G17","v":0},0,0,0,0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!K42","v":0},{"$f":"'Lookup Table'!E18","v":0},{"$f":"'Lookup Table'!F18","v":7.9},{"$f":"'Lookup Table'!G18","v":0},0,0,0,0]
[null,null,"FW Coastal Forested Wetland",{"$f":"'Data Entry'!K48","v":0},{"$f":"'Lookup Table'!E19","v":0},{"$f":"'Lookup Table'!F19","v":7.9},{"$f":"'Lookup Table'!G19","v":0},0,0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!K52","v":0},{"$f":"'Lookup Table'!E20","v":0},{"$f":"'Lookup Table'!F20","v":0},{"$f":"'Lookup Table'!G20","v":0},0,0,0,0]
[null,null,null,null,null,null,"Total:",{"$f":"SUM(H5:H18)","v":0},{"$f":"SUM(I5:I18)","v":0},{"$f":"SUM(J5:J18)","v":0},{"$f":"SUM(K5:K18)","v":0}]

{"sheet":"Rewetting Calculator","index":4,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,0,21,0],[14,1,17,1],[18,1,21,1],[5,8,6,8],[5,7,6,7],[8,0,13,0],[8,1,10,1],[11,1,13,1],[5,3,6,3],[5,0,7,0],[5,1,7,1],[5,2,7,2],[5,4,6,4],[5,9,6,9],[5,10,6,10],[5,6,6,6],[5,5,6,5],[1,0,1,4],[3,0,3,5]]}
[]
[]
[null,null,null,null,null,null,null,"Nutrient Poor","Nutrient Rich","Unknown"]
["What is the nutrient status of the wetland following restoration?  (place \"x\" in the correct box):",null,null,null,null,null,null,null,null,"x"]
[]
["Location","Soil Type","Land Use Category","Post rewetting area","Emissions Factor DOC","Emissions Factor CO2","Emissions Factor CH4","Emissions CO2-C ","Emissions CH4-C ","Emissions  CO2e ","Emissions  gasoline"]
[]
[null,null,null,"(ha)","tonnes C/yr","tonnes CO2-C/ha/yr","tonnes CH4-C/ha/yr","tonnes CO2-C/yr","tonnes CH4-C/yr","tonnes CO2e/yr","gallons of gasoline equivalents/yr"]
["Inland Wetland","Organic","FW Wetland",{"$f":"'Data Entry'!L6","v":0},{"$f":"'Lookup Table'!H4","v":0.24},{"$f":"IF(ISTEXT(H4),'Lookup Table'!I4,IF(ISTEXT(I4),'Lookup Table'!I5,'Lookup Table'!I5))","v":0.5},{"$f":"IF(ISTEXT(H4),'Lookup Table'!J4,IF(ISTEXT(I4),'Lookup Table'!J5,'Lookup Table'!J5))","v":0.216},{"$f":"SUM(E9:F9)*D9","v":0},{"$f":"D9*G9","v":0},{"$f":"(H9*44/12)+(I9*16/12*34)","v":0},{"$f":"J9*113","v":0}]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!L10","v":0},{"$f":"'Lookup Table'!H6","v":0.24},{"$f":"IF(ISTEXT(H4),'Lookup Table'!I6,IF(ISTEXT(I4),'Lookup Table'!I7,'Lookup Table'!I7))","v":0.5},{"$f":"IF(ISTEXT(H4),'Lookup Table'!J6,IF(ISTEXT('Rewetting Calculator'!I4),'Lookup Table'!J7,'Lookup Table'!J7))","v":0.216},{"$f":"SUM(E10:F10)*D10","v":0},{"$f":"D10*G10","v":0},{"$f":"(H10*44/12)+(I10*16/12*34)","v":0},{"$f":"J10*113","v":0}]
[null,null,"Open water fresh",{"$f":"'Data Entry'!L16","v":0},{"$f":"'Lookup Table'!H8","v":0},{"$f":"'Lookup Table'!I8","v":0},{"$f":"IF(ISTEXT(H4),'Lookup Table'!J8,IF(ISTEXT('Rewetting Calculator'!I4),'Lookup Table'!J9,'Lookup Table'!J9))","v":0.216},0,0,0,0]
[null,"Mineral","FW Wetland",{"$f":"'Data Entry'!L17","v":0},{"$f":"'Lookup Table'!H10","v":0},{"$f":"'Lookup Table'!I10","v":0},{"$f":"'Lookup Table'!J10","v":0.17699999999999999},0,0,0,0]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!L21","v":0},{"$f":"'Lookup Table'!H11","v":0},{"$f":"'Lookup Table'!I11","v":0},{"$f":"'Lookup Table'!J11","v":0.17699999999999999},0,0,0,0]
[null,null,"Open water fresh",{"$f":"'Data Entry'!L27","v":0},{"$f":"'Lookup Table'!H12","v":0},{"$f":"'Lookup Table'!I12","v":0},{"$f":"'Lookup Table'!J12","v":0.17699999999999999},0,0,0,0]
["Coastal Wetland","Organic","Phragmites Wetland",{"$f":"'Data Entry'!L28","v":0},{"$f":"'Lookup Table'!H12","v":0},{"$f":"'Lookup Table'!I13","v":-0.91},{"$f":"'Lookup Table'!J13","v":0.14599999999999999},0,0,{"$f":"(H15*44/12)+(I15*16/12*34)","v":0},0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!L29","v":0},{"$f":"'Lookup Table'!H13","v":0},{"$f":"'Lookup Table'!I14","v":-0.91},{"$f":"'Lookup Table'!J14","v":0},0,0,0,0]
[null,null,"SW/brackish Forested Wetland",{"$f":"'Data Entry'!L35","v":0},{"$f":"'Lookup Table'!H14","v":0},{"$f":"'Lookup Table'!I15","v":-0.91},{"$f":"'Lookup Table'!J15","v":0},0,0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!L39","v":0},{"$f":"'Lookup Table'!H15","v":0},{"$f":"'Lookup Table'!I16","v":0},{"$f":"'Lookup Table'!J16","v":0},0,0,0,0]
[null,"Mineral","Phragmites Wetland",{"$f":"'Data Entry'!L41","v":0},{"$f":"'Lookup Table'!H16","v":0},{"$f":"'Lookup Table'!I17","v":-0.91},{"$f":"'Lookup Table'!J17","v":0.14599999999999999},0,0,0,0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!L42","v":0},{"$f":"'Lookup Table'!H17","v":0},{"$f":"'Lookup Table'!I18","v":-0.91},{"$f":"'Lookup Table'!J18","v":0},0,0,0,0]
[null,null,"FW Coastal Forested Wetland",{"$f":"'Data Entry'!L48","v":0},{"$f":"'Lookup Table'!H18","v":0},{"$f":"'Lookup Table'!I19","v":-0.91},{"$f":"'Lookup Table'!J19","v":0.14599999999999999},0,0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!L52","v":0},{"$f":"'Lookup Table'!H19","v":0},{"$f":"'Lookup Table'!I20","v":0},{"$f":"'Lookup Table'!J20","v":0},0,0,0,0]
[null,null,null,null,null,null,"Total:",{"$f":"SUM(H9:H22)","v":0},{"$f":"SUM(I9:I22)","v":0},{"$f":"SUM(J9:J22)","v":0},{"$f":"SUM(K9:K22)","v":0}]

{"sheet":"Wetlands-Wetlands Calculator","index":5,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[4,7,5,7],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,3,5,3],[7,1,9,1],[10,1,12,1],[4,4,5,4],[4,5,5,5],[4,6,5,6],[2,0,2,6],[29,9,30,9],[32,0,37,0],[32,1,34,1],[35,1,37,1],[29,6,30,6],[29,7,30,7],[29,8,30,8],[27,0,27,5],[13,0,20,0],[13,1,16,1],[17,1,20,1],[25,0,25,5],[4,8,5,8],[4,9,5,9],[7,0,12,0],[38,0,45,0],[38,1,41,1],[42,1,45,1],[29,4,30,4],[29,5,30,5],[29,0,31,0],[29,1,31,1],[29,2,31,2],[29,3,30,3]]}
[]
[null,null,null,null,null,null,null,null,"Nutrient Poor","Nutrient Rich","Unknown"]
["What was the nutrient status of the wetland or water body prior to restoration?  (place \"x\" in the correct box):",null,null,null,null,null,null,null,null,null,"x"]
[]
["Location","Soil Type","Land Use Category","Pre Restoration Area","Emissions Factor CO2","Emissions Factor CH4","Emissions CO2-C  (pre restoration)","Emissions CH4-C (pre restoration)","Emissions  CO2e (pre restoration)","Emissions  gasoline (pre restoration)"]
[]
[null,null,null,"(ha)","tonnes CO2-C/ha/yr","tonnes CH4-C/ha/yr","tonnes CO2-C/yr","tonnes CH4-C/yr","tonnes CO2e/yr","gallons of gasoline equivalents/yr"]
["Inland Wetland","Organic","FW Wetland",{"$f":"'Data Entry'!M6","v":0},{"$f":"IF(ISTEXT(I3),'Lookup Table'!K4,IF(ISTEXT(J3),'Lookup Table'!K5,'Lookup Table'!K5))","v":0},{"$f":"IF(ISTEXT(I3),'Lookup Table'!L4,IF(ISTEXT(J3),'Lookup Table'!L5,'Lookup Table'!L5))","v":0.216},{"$f":"SUM(E8:E8)*D8","v":0},{"$f":"D8*F8","v":0},{"$f":"(G8*44/12)+(H8*16/12*34)","v":0},{"$f":"I8*113","v":0}]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!M10","v":0},{"$f":"IF(ISTEXT(I3),'Lookup Table'!K6,IF(ISTEXT(J3),'Lookup Table'!K7,'Lookup Table'!K7))","v":0},{"$f":"IF(ISTEXT(I3),'Lookup Table'!L6,IF(ISTEXT(J3),'Lookup Table'!L7,'Lookup Table'!L7))","v":0.216},0,0,{"$f":"(G9*44/12)+(H9*16/12*34)","v":0},{"$f":"I9*113","v":0}]
[null,null,"Open water fresh",{"$f":"'Data Entry'!M16","v":0},{"$f":"'Lookup Table'!K10","v":0},{"$f":"IF(ISTEXT(I3),'Lookup Table'!L8,IF(ISTEXT(J3),'Lookup Table'!L9,'Lookup Table'!L9))","v":0.216},0,0,0,0]
[null,"Mineral","FW Wetland",{"$f":"'Data Entry'!M17","v":0},{"$f":"'Lookup Table'!K11","v":0},{"$f":"'Lookup Table'!L10","v":0},0,0,0,0]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!M21","v":0},{"$f":"'Lookup Table'!K12","v":0},{"$f":"'Lookup Table'!L11","v":0},0,0,0,0]
[null,null,"Open water fresh",{"$f":"'Data Entry'!M27","v":0},{"$f":"'Lookup Table'!K12","v":0},{"$f":"'Lookup Table'!L12","v":0},0,0,0,0]
["Coastal Wetland","Organic","Phragmites Wetland",{"$f":"'Data Entry'!M28","v":0},{"$f":"'Lookup Table'!K13","v":-0.91},{"$f":"'Lookup Table'!L13","v":0.14599999999999999},0,0,{"$f":"(G14*44/12)+(H14*16/12*34)","v":0},0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!M29","v":0},{"$f":"'Lookup Table'!K14","v":-0.91},{"$f":"'Lookup Table'!L14","v":0},0,0,0,0]
[null,null,"SW/brackish Forested Wetland",{"$f":"'Data Entry'!M35","v":0},{"$f":"'Lookup Table'!K15","v":-0.91},{"$f":"'Lookup Table'!L15","v":0},0,0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!M39","v":0},{"$f":"'Lookup Table'!K16","v":0},{"$f":"'Lookup Table'!L16","v":0},0,0,0,0]
[null,"Mineral","Phragmites Wetland",{"$f":"'Data Entry'!M41","v":0},{"$f":"'Lookup Table'!K17","v":-0.91},{"$f":"'Lookup Table'!L17","v":0.41599999999999998},0,0,0,0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!M42","v":0},{"$f":"'Lookup Table'!K18","v":-0.91},{"$f":"'Lookup Table'!L18","v":0},0,0,0,0]
[null,null,"FW Coastal Forested Wetland",{"$f":"'Data Entry'!M48","v":0},{"$f":"'Lookup Table'!K19","v":-0.91},{"$f":"'Lookup Table'!L19","v":0.41599999999999998},0,0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!M52","v":0},{"$f":"'Lookup Table'!K20","v":0},{"$f":"'Lookup Table'!L20","v":0},0,0,0,0]
[null,null,null,null,null,"Total:",{"$f":"SUM(G8:G21)","v":0},{"$f":"SUM(H8:H21)","v":0},{"$f":"SUM(I8:I21)","v":0},{"$f":"SUM(J8:J21)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Nutrient Poor","Nutrient Rich","Unknown"]
["What will be the nurtient status of the wetland after restoration?  (place \"x\" in the correct box):",null,null,null,null,null,null,null,null,"x"]
[]
["Location","Soil Type","Land Use Category","Post Restoration Area","Emissions Factor CO2","Emissions Factor CH4","Emissions CO2-C  (post restoration)","Emissions CH4-C (post restoration)","Emissions  CO2e (post  restoration)","Emissions  gasoline (post restoration)"]
[]
[null,null,null,"(ha)","tonnes CO2-C/ha/yr","tonnes CH4-C/ha/yr","tonnes CO2-C/yr","tonnes CH4-C/yr","tonnes CO2e/yr","gallons of gasoline equivalents/yr"]
["Inland Wetland","Organic","FW Wetland",{"$f":"'Data Entry'!N6","v":0},{"$f":"IF(ISTEXT(H28),'Lookup Table'!K4,IF(ISTEXT(I28),'Lookup Table'!K5,'Lookup Table'!K5))","v":0},{"$f":"IF(ISTEXT(H28),'Lookup Table'!L4,IF(ISTEXT(I28),'Lookup Table'!L5,'Lookup Table'!L5))","v":0.216},{"$f":"SUM(E33:E33)*D33","v":0},{"$f":"D33*F33","v":0},{"$f":"(G33*44/12)+(H33*16/12*34)","v":0},{"$f":"I33*113","v":0}]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!N10","v":0},{"$f":"IF(ISTEXT(H28),'Lookup Table'!K6,IF(ISTEXT(I28),'Lookup Table'!K7,'Lookup Table'!K7))","v":0},{"$f":"IF(ISTEXT(H28),'Lookup Table'!L6,IF(ISTEXT(I28),'Lookup Table'!L7,'Lookup Table'!L7))","v":0.216},0,0,{"$f":"(G34*44/12)+(H34*16/12*34)","v":0},{"$f":"I34*113","v":0}]
[null,null,"Open water fresh",{"$f":"'Data Entry'!N16","v":0},{"$f":"'Lookup Table'!K8","v":0},{"$f":"IF(ISTEXT(H28),'Lookup Table'!L8,IF(ISTEXT(I28),'Lookup Table'!L9,'Lookup Table'!L9))","v":0.216},0,0,0,0]
[null,"Mineral","FW Wetland",{"$f":"'Data Entry'!N17","v":0},{"$f":"'Lookup Table'!K10","v":0},{"$f":"'Lookup Table'!L10","v":0},0,0,0,0]
[null,null,"FW Forested Wetland",{"$f":"'Data Entry'!N21","v":0},{"$f":"'Lookup Table'!K11","v":0},{"$f":"'Lookup Table'!L11","v":0},0,0,0,0]
[null,null,"Open water fresh",{"$f":"'Data Entry'!N27","v":0},{"$f":"'Lookup Table'!K12","v":0},{"$f":"'Lookup Table'!L12","v":0},0,0,0,0]
["Coastal Wetland","Organic","Phragmites Wetland",{"$f":"'Data Entry'!N28","v":0},{"$f":"'Lookup Table'!K13","v":-0.91},{"$f":"'Lookup Table'!L13","v":0.14599999999999999},0,0,0,0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!N29","v":0},{"$f":"'Lookup Table'!K14","v":-0.91},{"$f":"'Lookup Table'!L14","v":0},0,0,0,0]
[null,null,"SW/brackish Forested Wetland",{"$f":"'Data Entry'!N35","v":0},{"$f":"'Lookup Table'!K15","v":-0.91},{"$f":"'Lookup Table'!L15","v":0},0,0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!N39","v":0},{"$f":"'Lookup Table'!K16","v":0},{"$f":"'Lookup Table'!L16","v":0},0,0,0,0]
[null,"Mineral","Phragmites Wetland",{"$f":"'Data Entry'!N41","v":0},{"$f":"'Lookup Table'!K17","v":-0.91},{"$f":"'Lookup Table'!L17","v":0.41599999999999998},0,0,0,0]
[null,null,"SW/brackish Wetland",{"$f":"'Data Entry'!N42","v":0},{"$f":"'Lookup Table'!K18","v":-0.91},{"$f":"'Lookup Table'!L18","v":0},0,0,0,0]
[null,null,"FW Coastal Forested Wetland",{"$f":"'Data Entry'!N48","v":0},{"$f":"'Lookup Table'!K19","v":-0.91},{"$f":"'Lookup Table'!L19","v":0.41599999999999998},0,0,0,0]
[null,null,"Open water salt",{"$f":"'Data Entry'!N52","v":0},{"$f":"'Lookup Table'!K20","v":0},{"$f":"'Lookup Table'!L20","v":0},0,0,0,0]
[null,null,null,null,null,"Total:",{"$f":"SUM(G33:G46)","v":0},{"$f":"SUM(H33:H46)","v":0},{"$f":"SUM(I33:I46)","v":0},{"$f":"SUM(J33:J46)","v":0}]
[null,null,null,null,null,"Difference between pre and post Total:",{"$f":"G47-G22","v":0},{"$f":"H47-H22","v":0},{"$f":"I47-I22","v":0},{"$f":"J47-J22","v":0}]

{"sheet":"Results Summary","index":6,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,1,1]]}
[{"$f":"\"Cumulative Emissions/Reductions Relative to Emissions Prior to Management Activity for \"&'Data Entry'!E75","v":"Cumulative Emissions/Reductions Relative to Emissions Prior to Management Activity for "},null,"Years Post Project","Years Post Project","Years Post Project","Years Post Project","Years Post Project","Years Post Project","Years Post Project"]
[null,null,0,1,10,20,30,40,50]
["From Extracting Wetlands"]
["CO2-C emissions (tonnes CO2-C)",null,0,{"$f":"'Extraction Calculator'!F19","v":0},{"$f":"D4","v":0},{"$f":"E4","v":0},{"$f":"F4","v":0},0,0]
["GHG emissions (tonnes CO2e)",null,0,{"$f":"'Extraction Calculator'!G19","v":0},{"$f":"D5","v":0},0,0,0,0]
["GHG emissions (gallons of gasoline equivalent)",null,0,{"$f":"'Extraction Calculator'!H19","v":0},0,0,0,0,0]
["From Draining Wetlands"]
["CO2-C emissions (tonnes CO2-C)",null,0,{"$f":"'Drainage Calculator'!H19","v":0},{"$f":"D8*10","v":0},{"$f":"D8*20","v":0},{"$f":"SUM('Drainage Calculator'!$H$5:$H$7,'Drainage Calculator'!$H$11:$H$14)*30+SUM('Drainage Calculator'!$H$8:$H$10,'Drainage Calculator'!$H$15:$H$18)*20","v":0},{"$f":"SUM('Drainage Calculator'!$H$5:$H$7,'Drainage Calculator'!$H$11:$H$14)*40+SUM('Drainage Calculator'!$H$8:$H$10,'Drainage Calculator'!$H$15:$H$18)*20","v":0},{"$f":"SUM('Drainage Calculator'!$H$5:$H$7,'Drainage Calculator'!$H$11:$H$14)*50+SUM('Drainage Calculator'!$H$8:$H$10,'Drainage Calculator'!$H$15:$H$18)*20","v":0}]
["CH4-C emissions (tonnes CH4-C)",null,0,{"$f":"'Drainage Calculator'!I19","v":0},{"$f":"D9*10","v":0},{"$f":"D9*20","v":0},{"$f":"SUM('Drainage Calculator'!$I$5:$I$7,'Drainage Calculator'!$I$11:$I$14)*30+SUM('Drainage Calculator'!$I$8:$I$10,'Drainage Calculator'!$I$15:$I$18)*20","v":0},{"$f":"SUM('Drainage Calculator'!$I$5:$I$7,'Drainage Calculator'!$I$11:$I$14)*40+SUM('Drainage Calculator'!$I$8:$I$10,'Drainage Calculator'!$I$15:$I$18)*20","v":0},{"$f":"SUM('Drainage Calculator'!$I$5:$I$7,'Drainage Calculator'!$I$11:$I$14)*50+SUM('Drainage Calculator'!$I$8:$I$10,'Drainage Calculator'!$I$15:$I$18)*20","v":0}]
["GHG emissions (tonnes CO2e)",null,0,{"$f":"'Drainage Calculator'!J19","v":0},0,0,{"$f":"SUM('Drainage Calculator'!$J$5:$J$7,'Drainage Calculator'!$J$11:$J$14)*30+SUM('Drainage Calculator'!$J$8:$J$10,'Drainage Calculator'!$J$15:$J$18)*20","v":0},{"$f":"SUM('Drainage Calculator'!$J$5:$J$7,'Drainage Calculator'!$J$11:$J$14)*40+SUM('Drainage Calculator'!$J$8:$J$10,'Drainage Calculator'!$J$15:$J$18)*20","v":0},{"$f":"SUM('Drainage Calculator'!$J$5:$J$7,'Drainage Calculator'!$J$11:$J$14)*50+SUM('Drainage Calculator'!$J$8:$J$10,'Drainage Calculator'!$J$15:$J$18)*20","v":0}]
["GHG emissions (gallons of gasoline equivalent)",null,0,{"$f":"'Drainage Calculator'!K19","v":0},0,0,{"$f":"SUM('Drainage Calculator'!$K$5:$K$7,'Drainage Calculator'!$K$11:$K$14)*30+SUM('Drainage Calculator'!$K$8:$K$10,'Drainage Calculator'!$K$15:$K$18)*20","v":0},{"$f":"SUM('Drainage Calculator'!$K$5:$K$7,'Drainage Calculator'!$K$11:$K$14)*40+SUM('Drainage Calculator'!$K$8:$K$10,'Drainage Calculator'!$K$15:$K$18)*20","v":0},{"$f":"SUM('Drainage Calculator'!$K$5:$K$7,'Drainage Calculator'!$K$11:$K$14)*50+SUM('Drainage Calculator'!$K$8:$K$10,'Drainage Calculator'!$K$15:$K$18)*20","v":0}]
["From Rewetting/Revegetation Wetlands"]
["CO2-C emissions (tonnes CO2-C)",null,0,{"$f":"'Rewetting Calculator'!H23","v":0},{"$f":"$D$13*10","v":0},{"$f":"$D$13*20","v":0},{"$f":"$D$13*30","v":0},{"$f":"$D$13*40","v":0},{"$f":"$D$13*50","v":0}]
["CH4-C emissions (tonnes CH4-C)",null,0,{"$f":"'Rewetting Calculator'!I23","v":0},{"$f":"$D$14*10","v":0},{"$f":"$D$14*20","v":0},{"$f":"$D$14*30","v":0},{"$f":"$D$14*40","v":0},{"$f":"$D$14*50","v":0}]
["GHG emissions (tonnes CO2e)",null,0,{"$f":"'Rewetting Calculator'!J23","v":0},{"$f":"$D$15*10","v":0},{"$f":"$D$15*20","v":0},{"$f":"$D$15*30","v":0},{"$f":"$D$15*40","v":0},{"$f":"$D$15*50","v":0}]
["GHG emissions (gallons of gasoline equivalent)",null,0,{"$f":"'Rewetting Calculator'!K23","v":0},{"$f":"$D$16*10","v":0},{"$f":"$D$16*20","v":0},{"$f":"$D$16*30","v":0},{"$f":"$D$16*40","v":0},{"$f":"$D$16*50","v":0}]
["From Converting Wetlands Remaining Wetlands"]
["CO2-C emissions (tonnes CO2-C)",null,0,{"$f":"'Wetlands-Wetlands Calculator'!G48","v":0},{"$f":"$D$18*10","v":0},{"$f":"$D$18*20","v":0},{"$f":"$D$18*30","v":0},{"$f":"$D$18*40","v":0},{"$f":"$D$18*50","v":0}]
["CH4-C emissions (tonnes CH4-C)",null,0,{"$f":"'Wetlands-Wetlands Calculator'!H48","v":0},{"$f":"$D$19*10","v":0},{"$f":"$D$19*20","v":0},{"$f":"$D$19*30","v":0},{"$f":"$D$19*40","v":0},{"$f":"$D$19*50","v":0}]
["GHG emissions (tonnes CO2e)",null,0,{"$f":"'Wetlands-Wetlands Calculator'!I48","v":0},{"$f":"$D$20*10","v":0},{"$f":"$D$20*20","v":0},{"$f":"$D$20*30","v":0},{"$f":"$D$20*40","v":0},{"$f":"$D$20*50","v":0}]
["GHG emissions (gallons of gasoline equivalent)",null,0,{"$f":"'Wetlands-Wetlands Calculator'!J48","v":0},{"$f":"$D$21*10","v":0},{"$f":"$D$21*20","v":0},{"$f":"$D$21*30","v":0},{"$f":"$D$21*40","v":0},{"$f":"$D$21*50","v":0}]
["From All Wetlands Management Activites"]
[{"$f":"'Data Entry'!E75&\": Cumulative CO2-C emissions/reductions\"","v":": Cumulative CO2-C emissions/reductions"},"(tonnes CO2-C)*",0,{"$f":"SUM(D4,D8,D13,D18)","v":0},{"$f":"SUM(E4,E8,E13,E18)","v":0},0,0,0,0]
[{"$f":"'Data Entry'!E75&\": Cumulative CH4-C emissions/reductions\"","v":": Cumulative CH4-C emissions/reductions"},"(tonnes CH4-C)*",0,{"$f":"SUM(D9,D14,D19)","v":0},{"$f":"SUM(E9,E14,E19)","v":0},0,0,0,0]
[{"$f":"'Data Entry'!E75&\": Cumulative GHG emissions/reductions\"","v":": Cumulative GHG emissions/reductions"},"(tonnes CO2e)*",0,{"$f":"SUM(D5,D10,D15,D20)","v":0},{"$f":"SUM(E5,E10,E15,E20)","v":0},0,0,0,{"$f":"SUM(I5,I10,I15,I20)","v":0}]
[{"$f":"'Data Entry'!E75&\": Cumulative GHG emissions/reductions\"","v":": Cumulative GHG emissions/reductions"},"(gallons of gas equivalent)*",0,{"$f":"SUM(D6,D11,D16,D21)","v":0},{"$f":"SUM(E6,E11,E16,E21)","v":0},0,0,0,0]
["*Negative values are net benefits"]

{"sheet":"Lookup Table","index":7,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,7,0,11],[1,10,1,11],[22,0,22,11],[20,0,20,11],[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,0,6],[1,4,1,6],[1,7,1,9],[3,0,11,0],[9,1,11,1],[12,0,19,0],[12,1,15,1],[3,1,8,1],[16,1,19,1],[23,0,23,11]]}
["Wetland Type","Soil Type","Land Use Category","Wetlands Destruction",null,null,null,"Wetlands Restoration"]
[null,null,null,"Extraction","Drained",null,null,"Rewetted",null,null,"Wetlands Remaining Wetlands"]
[null,null,null,"Soil C stock: tonnes C/ha","EF tonnes DOC- C/ha/yr","EF tonnes CO2- C/ha/yr","EF tonnes CH4-C/ha/yr","EF tonnes DOC- C/ha/yr","EF tonnes CO2-C/ha/yr","EF tonnes CH4-C/ha/yr","EF tonnes CO2-C/ha/yr*","EF tonnes CH4-C/ha/yr*"]
["Inland","Organic","FW Wetland (nutrient poor)",null,0.31,null,null,0.24,{"$f":"-0.23","v":-0.23},9.1999999999999998E-2,0,9.1999999999999998E-2]
[null,null,"FW Wetland (nutrient rich)",null,0.31,null,null,0.24,0.5,0.216,0,0.216]
[null,null,"FW Forested Wetland (nutrient poor)",null,0.31,null,null,0.24,{"$f":"-0.23","v":-0.23},9.1999999999999998E-2,0,9.1999999999999998E-2]
[null,null,"FW Forested Wetland (nutrient rich)",null,0.31,null,null,0.24,0.5,0.216,0,0.216]
[null,null,"Open water fresh (nutrient poor)",null,null,null,null,null,0,9.1999999999999998E-2,0,9.1999999999999998E-2]
[null,null,"Open water fresh (nutrient rich)",null,null,null,null,null,null,0.216,0,0.216]
[null,"Mineral","FW Wetland",128,null,6.4,0,null,null,0.17699999999999999,0,0]
[null,null,"FW Forested Wetland",128,null,6.4,0,null,null,0.17699999999999999,0,0]
[null,null,"Open water fresh",null,null,null,0,null,0,0.17699999999999999,0,0]
["Coastal","Organic","Phragmites Wetland",340,null,7.9,0,null,{"$f":"-0.91","v":-0.91},0.14599999999999999,-0.91,0.14599999999999999]
[null,null,"SW/brackish Wetland",340,null,7.9,0,null,{"$f":"-0.91","v":-0.91},0,-0.91,0]
[null,null,"SW/brackish Forested Wetland",340,null,7.9,0,null,{"$f":"-0.91","v":-0.91},0,-0.91,0]
[null,null,"Open water salt",null,null,null,0,null,0,0,0,0]
[null,"Mineral","Phragmites Wetland",226,null,7.9,0,null,{"$f":"-0.91","v":-0.91},0.14599999999999999,-0.91,0.41599999999999998]
[null,null,"SW/brackish Wetland",226,null,7.9,0,null,{"$f":"-0.91","v":-0.91},0,-0.91,0]
[null,null,"FW Forested Tidal Wetland",226,null,7.9,0,null,{"$f":"-0.91","v":-0.91},0.14599999999999999,-0.91,0.41599999999999998]
[null,null,"Open water salt",null,null,null,0,null,0,0,0,0]
["CO2 and CH4 emission factors for rewetting of inland wetlands (cells J4 to J7 and K4 to K7) vary with nutrient status. These variations have been built into the calculator based on answers to questions on the \"Rewetting\" and \"Conversion\" Calculator sheets. See accompanying report for mor information."]
["Negative values indicate removal (sequestration) of C"]
["Sources pertain to values listed in the respective row, in order from left to right. ie the first source listed refers to the value farthest to the left in that row, the last source pertains to the value in that row farthest to the right."]
["*Because there is no guidance provided by IPCC for \"natural\" wetlands, or wetlands occuring before and after an activity, these values were dervived from the IPCC values to represent the wetland emissions prior to and after the restoration project. The difference between them is considered to be the emissions resulting from the project."]