{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["readme","Example","Wetland GHG Model"],"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":"row_number_cap","date_system":"1900"}

{"sheet":"readme","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[9,0,13,11],[14,0,14,11],[32,4,32,5],[2,0,2,11],[4,0,4,7],[5,0,5,7],[6,0,8,11]]}
["README"]
["BWM wetland GHG Model Overview "]
["The BWM wetland C and GHG model is a non-linear empirical model developed by fitting  data for four different wetlands of Waquoit Bay, MA, representing biogeochemical and ecological gradients. A robust multivariate data-analytic framework is utilized to select the dominant process variables as model inputs. The model is unique in a sense that it is very simple, handy and user-friendly; anyone can use the model without requiring much input data.  \n"]
["Model Assumptions and Boundaries"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["UserGuide"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PAR Options ",null,null,"CH4 GWP potential options "]
[null,100,null,null,1,"If GWP is not considered"]
[null,200,null,null,34,"If 100 years GWP is considered"]
[null,300,null,null,86,"If 20 years GWP is considered"]
[null,400]
[null,500]
[null,600,null,null,"Highlight indicates \"recommended\"."]
[null,700]
[null,800]
[null,900]
[]
["Model Output"]

{"sheet":"Example","index":1,"n_rows":200,"n_cols":22,"rows_kept":200,"cut":false,"hidden":false,"merged":[[11,7,11,10],[37,6,37,7],[15,14,15,21],[15,1,15,8],[27,6,29,8],[30,6,30,7],[30,9,30,10],[30,12,30,13]]}
["README"]
["1. Enable \"macros\" in your Excel spreadsheet. If your version of the Excel software does not have \"macros\" enabled already, you should be asked to enable \"macros\" when you open this file. Then save this Excel file as a \"Excel Macro-Enabled Workbook\"."]
["2. Required input variables are photosynthetically active radiation (PAR, units: micromole/m2/s; Column B), soil temperature (units: degree celsius; Column C), sediment salinity (units: parts per thousand, ppt; Column D), water depth relative to the marsh elevation (units: meter; Column E)."]
["3. Net lateral flux (units: g/m2/) over the  growing extended period  (e.g., May-October) is considered as an input parameter (Column F) to calculate the net ecosystem carbon balance of the wetlands; net lateral flux is positive when going out of the wetland to the estuary/bay and negative otherwise."]
["4. Relative water depth (WD) is positive when water is above the marsh soil surface and  is negative when water is below the marsh soil surface. This is needed because CH4 flux model is being developed for two water level conditions: a) when water level is above the marsh soil surface (i.e., WD>0), and b) when the water level is below the march soil surface (WD<0). However, all the modeling equations are integrated here in a way that an user just needs to input their measured water depths relative the marsh elevation following the stated sign conventions (i.e., \"positive\" when WD>0 and \"negative\" when WD<0)."]
["5. Predicted variables are  CO2  flux (micromole/m2/s) (including both sequestration and emissions) and CH4 emission flux (micromole/m2/s)."]
["6. CH4 sequestration fluxes (from the atmosphere to the soil) were assumed negligible for the Waquoit Bay wetland system. It can be assumed negligible for most tidal wetlands."]
["7. To estimate the potential wetland carbon storage, Net Ecosystem Carbon Balance (NECB), the instanteneous balance of predicted CO2  and CH4 fluxes were up-scaled over the extended growing season (e.g., May to October) and substracted from the corresponding net lateral flux."]
["8. Positive sign of net wetland carbon balance indicates net carbon sequestration and negative sign indicates net GHG emissions."]
[]
[]
[null,null,null,null,null,null,null,"BWM Wetland GHG Model "]
[]
[]
[]
[null,"Input Variables  ",null,null,null,null,null,null,null,null,null,null,null,null,"Outputs"]
["Number of observations ","Photosynthetically active radiation, PAR (micromole/m2/s)","Soil temperature, ST (OC)","Soil salinity, SS  (ppt)","Water depth related to marsh surface, WD (m)","Net lateral flux over the growing  period (g/m2) ","Enter threshold value of light, PAR (micromole/m2/s) ","Enter the number of days for which you want to estimate wetland carbon storage (NECB)","Enter CO2 equivalent global warming potential (GWP) for CH4",null,null,null,null,null,"Predicted CO2 Flux (micromole/m2/s)","Predicted CH4 emission flux (micromole/m2/s)",null,"Total CO2 sequestration over the growing period (gC/m2)","Total CH4 emission over the growing period by considering the GWP (gC/m2)",null,"Net ecosystem carbon balance over the growing period,  NECB (gC/m2)","Net ecosystem carbon balance over the growing period, NECB (metric ton C/hectare)"]
[1,2080.36666666667,20.520873014285701,25,5.3999999999999999E-2,0,300,153,34,null,null,null,null,null,{"$f":"IF(B18>=$G$18,10^$H$32*B18^$H$33*C18^$H$34*D18^$H$35,-(10^$H$39*C18^$H$40))","v":11.161146180064387},{"$f":"IF(E18>0,(10^$K$32*E18^$K$33*C18^$K$34*D18^$K$35/1000),(10^$N$32*ABS(E18)^$N$33*C18^$N$34*D18^$N$35/1000))","v":1.3800418060936196E-3},null,933.32798503689878,18.567686624555233,null,{"$f":"R18-S18-F18","v":914.76029841234356},{"$f":"U18*0.01","v":9.1476029841234361}]
[2,2062.4499999999998,18.069166665000001,24,5.6386000000000019E-2,null,null,null,null,null,null,null,null,null,{"$f":"IF(B19>=$G$18,10^$H$32*B19^$H$33*C19^$H$34*D19^$H$35,-(10^$H$39*C19^$H$40))","v":8.5024519836874521},{"$f":"IF(E19>0,(10^$K$32*E19^$K$33*C19^$K$34*D19^$K$35/1000),(10^$N$32*ABS(E19)^$N$33*C19^$N$34*D19^$N$35/1000))","v":9.1561566852958547E-4}]
[3,2000,18.665888888000001,26,6.6139599999999993E-2,null,null,null,null,null,null,null,null,null,8.292696594938862,9.0615813415440569E-4]
[4,1819.95,18.800714287142899,21,8.6256400000000039E-2,null,null,null,null,null,null,null,null,null,9.7224043047246695,1.1339928918893676E-3]
[5,2039.95,19.033888887142901,21,8.6256400000000039E-2,null,null,null,null,null,null,null,null,null,10.919464549074879,1.1844935849184316E-3]
[6,1284.5333333333299,19.284333333999999,20,8.3513199999999982E-2,null,null,null,null,null,null,null,null,null,8.3340796940321216,1.3220025370512564E-3]
[7,1406.2,21.321111112000001,22,8.0465199999999987E-2,null,null,null,null,null,null,null,null,null,10.334178653380336,1.6979157723222384E-3]
[8,1717.86666666667,20.309074073333299,22,7.7722000000000041E-2,null,null,null,null,null,null,null,null,null,10.6978134769149,1.4394972854367078E-3]
[9,1684.95,20.048174602857099,22,7.2235600000000039E-2,null,null,null,null,null,null,null,null,null,10.219110780193814,1.3950338545733521E-3]
[10,1.2,19.578888890000002,22,4.0841199999999994E-2,null,null,null,null,null,null,null,null,null,-2.5305916220235716,1.4344852108500643E-3]
[11,1.2,18.330833335000001,22,5.7910000000000045E-2,null,"Model Parameters ",null,null,null,null,null,null,null,-1.8775384413878571,1.0614437654126142E-3]
[12,1.2,18.800873017142901,22,7.2235600000000039E-2,null,null,null,null,null,null,null,null,null,-2.1058071945741177,1.1116684506439504E-3]
[13,1.2,20.650918803461501,31,-0.32402347775999996,null,null,null,null,null,null,null,null,null,-3.2220859627602412,3.6035231052905847E-2]
[14,1.2,20.669907408333302,31,-0.32402347775999996,null,"CO2 Sequestration",null,null,"CH4 Emission ( WaterDepth>0)",null,null,"CH4 Emission (WaterDepth<0)",null,-3.2355339621765342,3.6013037530154571E-2]
[15,1.2,20.185833335000002,31,-0.32504541119999997,null,"ß0",-3.2290325129753001,null,"ß0",-3.10480249060749,null,"ß0",0.76560953475094096,-2.9060717464837471,3.6717027832237466E-2]
[16,1.2,20.555,31,-0.32504541119999997,null,"Light (PAR)",0.75749489806043402,null,"Water Depth",-0.195729714796681,null,"Water Depth",1.10341759618242,-3.1548192009100018,3.6273679271090889E-2]
[17,1211.825,22.368888890000001,29,-9.0631999999999657E-3,null,"Soil Temperature",2.4071986621249799,null,"Soil Temperature",3.53479239685938,null,"Soil Temperature",-0.67031450387372205,7.8655266971916245,5.9780650936155021E-4]
[18,1149.325,23.850845409565199,24,-1.2720799999999949E-2,null,"Soil Salinity",-0.99821792829412304,null,"Soil Salinity",-1.17440900010423,null,"Soil Salinity",1.4835966674052701,10.651505068882301,6.2865653549148699E-4]
[19,728.7,23.5855072482609,24,-1.6073599999999938E-2,null,null,null,null,null,null,null,null,null,7.3419548347074226,8.1992857913566395E-4]
[20,1984.325,20.057125603913001,22,2.3892800000000047E-2,null,null,null,null,null,null,null,null,null,11.57927672286853,1.7350621594922923E-3]
[21,1894.95,20.3286473413044,20,1.3834400000000024E-2,null,"CO2 Emission",null,null,null,null,null,null,null,12.702715897204795,2.2647350094128034E-3]
[22,1427.45,21.430700483478301,20,-1.8639999999997547E-4,null,"ß0",-5.4507817028966796,null,null,null,null,null,null,11.638279214728419,4.8791560433606816E-6]
[23,1962.45,20.547398989545499,20,-4.0000000000000036E-3,null,"Soil Temperature",4.5317061154593903,null,null,null,null,null,null,13.384455350697877,1.4788500520690286E-4]
[24,551.20000000000005,24.851376809565199,32,-0.31826348927999998,null,null,null,null,null,null,null,null,null,5.0572366972514002,3.2710531957432849E-2]
[25,529.53333333333296,24.674106279130399,30,-0.31724155583999997,null,null,null,null,null,null,null,null,null,5.1429885652128302,2.9760972072298327E-2]
[26,595.57500000000005,25.3734782608696,34,-0.31724155583999997,null,null,null,null,null,null,null,null,null,5.306884748632033,3.5168617516737256E-2]
[27,500.36666666666702,26.35277778,32,-0.31826348927999998,null,null,null,null,null,null,null,null,null,5.4126303894102987,3.1449280292781809E-2]
[28,1851.2,20.073695653043501,28,0.23042680000000001,null,null,null,null,null,null,null,null,null,8.6526753618029879,8.4126056223379113E-4]
[29,1871.2,19.943712120454499,29,0.23042680000000001,null,null,null,null,null,null,null,null,null,8.2924184157055212,7.8896861910089384E-4]
[30,1862.45,20.0442499995,26,0.23621800000000001,null,null,null,null,null,null,null,null,null,9.3268774693596654,9.0858388284141914E-4]
[31,1909.95,19.746111110000001,26,0.23699999999999999,null,null,null,null,null,null,null,null,null,9.1696902303669887,8.611500461056746E-4]
[32,1973.7,20.399806762608701,27,0.24170440000000001,null,null,null,null,null,null,null,null,null,9.7913652590526148,9.2078190738621387E-4]
[33,1893.075,20.133712120454501,27,0.23621800000000001,null,null,null,null,null,null,null,null,null,9.1917071244241288,8.8298315773442388E-4]
[34,2042.0333333333299,20.364999999999998,26,0.22189239999999996,null,null,null,null,null,null,null,null,null,10.390016519278509,9.7286842259007968E-4]
[35,2058.6999999999998,20.968333333913002,28,0.21,null,null,null,null,null,null,null,null,null,10.415619751980607,9.9944289505404164E-4]
[36,1965.36666666667,20.637053139130401,28,0.19999999999999998,null,null,null,null,null,null,null,null,null,9.6777244145264181,9.538013326444595E-4]
[37,1876.2,25.1234057973913,28,7.2578000000000004E-2,null,null,null,null,null,null,null,null,null,15.001951636504131,2.3313275153074042E-3]
[38,1148.7,24.772083334166702,28,8.1578000000000012E-2,null,null,null,null,null,null,null,null,null,10.000553565787074,2.1679424502725709E-3]
[39,979.95,25.952800926249999,29,8.7999999999999995E-2,null,null,null,null,null,null,null,null,null,9.5767840207984705,2.4165062775982288E-3]
[40,1342.45,24.871111110000001,30,0.108,null,null,null,null,null,null,null,null,null,10.606229586961707,1.9192583734539191E-3]
[41,1923.7,25.414837964583299,28,0.11699999999999999,null,null,null,null,null,null,null,null,null,15.719186108233457,2.2116575021982297E-3]
[42,1018.7,25.2619444466667,29,0.124,null,null,null,null,null,null,null,null,null,9.2421170294753789,2.054079979643872E-3]
[43,1027.45,25.362608695652199,28,0.136578,null,null,null,null,null,null,null,null,null,9.7264752385732205,2.1301381423556595E-3]
[44,1804.95,26.095949074583299,28,0.14657800000000001,null,null,null,null,null,null,null,null,null,15.963091879878213,2.3235874406337142E-3]
[45,1941.2,25.6019444466667,30,0.14657800000000001,null,null,null,null,null,null,null,null,null,15.037228360334396,2.0027680320904486E-3]
[46,1.2,25.452777780000002,29,8.8578000000000018E-2,null,null,null,null,null,null,null,null,null,-8.3099236860472416,2.2530238704181137E-3]
[47,1.2,25.016111110000001,29,8.5578000000000015E-2,null,null,null,null,null,null,null,null,null,-7.6831533720657115,2.1336800787363692E-3]
[48,1.2,25.257777780000001,29,8.2000000000000003E-2,null,null,null,null,null,null,null,null,null,-8.0252934225814521,2.2259669655877307E-3]
[49,1966.2,28.027950193793099,30,8.1500000000000003E-2,null,null,null,null,null,null,null,null,null,18.88098602661691,3.093902877219756E-3]
[50,1884.95,27.0645238114286,30,7.957800000000001E-2,null,null,null,null,null,null,null,null,null,16.810235039108406,2.7468724342066117E-3]
[51,1944.95,25.835517241724201,35,7.6578000000000007E-2,null,null,null,null,null,null,null,null,null,13.196832579218055,1.9594698524260344E-3]
[52,1872.45,27.3525478944828,34,6.5577999999999997E-2,null,null,null,null,null,null,null,null,null,15.142269771340873,2.55681511199437E-3]
[53,1823.7,24.444074073333301,33,-1.0999999999999982E-2,null,null,null,null,null,null,null,null,null,11.666076528651427,8.4488400469260227E-4]
[54,1906.825,24.009572647692298,33,-1.0999999999999982E-2,null,null,null,null,null,null,null,null,null,11.556808695272849,8.5510269619666613E-4]
[55,1924.325,24.291111109999999,32,-1.0999999999999982E-2,null,null,null,null,null,null,null,null,null,12.341587402560494,8.1058353488561662E-4]
[56,1946.2,25.299985755128201,34,-1.0999999999999982E-2,null,null,null,null,null,null,null,null,null,12.922595606223185,8.630041913350613E-4]
[57,1948.7,23.991594202608699,31,9.0000000000000357E-3,null,null,null,null,null,null,null,null,null,12.482598021061529,2.6446419520240261E-3]
[58,1987.0333333333335,24.267045454090901,30,1.2000000000000038E-2,null,null,null,null,null,null,null,null,null,13.454358066508096,2.7049643198924695E-3]
[59,2000.3666666666668,23.7085353545455,34,1.2000000000000038E-2,null,null,null,null,null,null,null,null,null,11.28392724693272,2.1506956770396117E-3]
[60,1646.2,27.8303888885,29,-4.7999999999999987E-2,null,null,null,null,null,null,null,null,null,16.783773523144788,3.2493349801250284E-3]
[61,1408.7,26.169417989523801,29,-5.4999999999999993E-2,null,null,null,null,null,null,null,null,null,12.861793156260493,3.9349972486130954E-3]
[62,1046.2,26.970972222499999,34,-6.2E-2,null,null,null,null,null,null,null,null,null,9.4191757819324415,5.57262151655277E-3]
[63,688.7,25.886416666500001,32,-6.2E-2,null,null,null,null,null,null,null,null,null,6.6044701126256298,5.2353552063048626E-3]
[64,425.36666666666702,22.047763158157899,33,1.3000000000000039E-2,null,null,null,null,null,null,null,null,null,3.0212026973616886,1.6963409484678539E-3]
[65,434.11666666666702,21.763624999499999,31,1.3000000000000039E-2,null,null,null,null,null,null,null,null,null,3.1653503068957494,1.7437669373118036E-3]
[66,512.70000000000005,21.708190476571399,34,9.0000000000000357E-3,null,null,null,null,null,null,null,null,null,{"$f":"IF(B83>=$G$18,10^$H$32*B83^$H$33*C83^$H$34*D83^$H$35,-(10^$H$39*C83^$H$40))","v":3.2541982795061899},{"$f":"IF(E83>0,(10^$K$32*E83^$K$33*C83^$K$34*D83^$K$35/1000),(10^$N$32*ABS(E83)^$N$33*C83^$N$34*D83^$N$35/1000))","v":1.6661628162377726E-3}]
[67,1.2,22.618666665999999,33,0.18600000000000008,null,null,null,null,null,null,null,null,null,-4.8670374269211791,1.1030082212521457E-3]
[68,1.2,22.153888890000001,33,0.16900000000000007,null,null,null,null,null,null,null,null,null,-4.4299841140887404,1.0443664756653826E-3]
[69,1.2,22.547839504444401,33,0.13500000000000004,null,null,null,null,null,null,null,null,null,-4.7983531183659229,1.1614636729510115E-3]
[70,1660.7,21.342873013999998,32,0.17857799999999999,null,null,null,null,null,null,null,null,null,8.0840630616537332,9.3887614491861265E-4]
[71,1750.4857142857099,20.709378531186498,13,0.16700000000000001,null,null,null,null,null,null,null,null,null,19.229187485409689,2.4631294299560938E-3]
[72,1786.2,21.565654320666699,29,0.15257800000000002,null,null,null,null,null,null,null,null,null,9.6633492730426589,1.1275428892839493E-3]
[73,1847.45,21.629022987930998,30,0.134578,null,null,null,null,null,null,null,null,null,9.6513877176974887,1.1220622771463229E-3]
[74,1862.86666666667,21.4707957951351,30,0.128,null,null,null,null,null,null,null,null,null,9.5421807842464563,1.1040919306450994E-3]
[75,1879.95,21.900496031071398,30,0.124,null,null,null,null,null,null,null,null,null,10.077821077510723,1.1915815343282701E-3]
[76,1907.0333333333299,22.521927084062501,30,0.11457799999999999,null,null,null,null,null,null,null,null,null,10.897415199238361,1.3359637292661738E-3]
[77,1923.7,22.3087152784375,31,0.113,null,null,null,null,null,null,null,null,null,10.375927976677881,1.2463706815011208E-3]
[78,1928.7,22.037183909310301,30,0.11,null,null,null,null,null,null,null,null,null,10.430217383556986,1.2469783290110607E-3]
[79,1514.95,20.528124998749998,34,-1.3999999999999985E-2,null,null,null,null,null,null,null,null,null,6.463067629421313,1.2954625029323711E-3]
[80,1564.95,20.031723645641001,33,-1.3999999999999985E-2,null,null,null,null,null,null,null,null,null,6.4338665958089951,1.2598421635367358E-3]
[81,1614.5333333333299,21.174387464359,32,-1.3999999999999985E-2,null,null,null,null,null,null,null,null,null,7.7637074051276516,1.1596844503562046E-3]
[82,1657.0333333333299,20.886234568888899,30,-1.3999999999999985E-2,null,null,null,null,null,null,null,null,null,8.1709236335513964,1.0635192537483305E-3]
[83,1859.5333333333299,21.632453703888899,30,-6.2E-2,null,null,null,null,null,null,null,null,null,9.7028707905698006,5.3656788567124766E-3]
[84,1819.325,21.388472222727199,30,-6.5000000000000002E-2,null,null,null,null,null,null,null,null,null,9.286475718497508,5.6960084713455145E-3]
[85,1797.0333333333299,21.4484313711765,32,-6.9000000000000006E-2,null,null,null,null,null,null,null,null,null,8.6844638580321405,6.6827766043280187E-3]
[86,1677.86666666667,21.250511695,33,-7.5000000000000011E-2,null,null,null,null,null,null,null,null,null,7.8187762548069522,7.716841911745452E-3]
[87,1244.7,17.218342440491799,34,9.9577999999999972E-2,null,null,null,null,null,null,null,null,null,3.6474570687402168,4.5885648310827013E-4]
[88,1154.325,17.728358587045498,32,8.7578000000000017E-2,null,null,null,null,null,null,null,null,null,3.926367225315635,5.6017608764112972E-4]
[89,1071.825,16.914999999999999,32,8.2578000000000013E-2,null,null,null,null,null,null,null,null,null,3.3151096353191059,4.7998116176826099E-4]
[90,1549.25555555556,17.058660131176499,32,4.3577999999999978E-2,null,null,null,null,null,null,null,null,null,4.4723717209555085,5.604555539593174E-4]
[91,1643.3875,16.357654322222199,32,4.6577999999999981E-2,null,null,null,null,null,null,null,null,null,4.2274069031068811,4.769405726429074E-4]
[92,1333.7,16.430357143571399,33,4.6577999999999981E-2,null,null,null,null,null,null,null,null,null,3.5373586472792424,4.6728026834680342E-4]
[93,1466.61666666667,16.0134126985714,32,4.9577999999999983E-2,null,null,null,null,null,null,null,null,null,3.6846861359290797,4.3702578239020586E-4]
[94,1407.86666666667,16.736502058148101,33,5.5577999999999989E-2,null,null,null,null,null,null,null,null,null,3.8528575979346118,4.818385323417982E-4]
[95,1367.7,16.9640656568182,31,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,4.1446075272420497,5.1988901977317035E-4]
[96,1233.075,17.220425531702102,32,0.12,null,null,null,null,null,null,null,null,null,3.8486794111246141,4.7525415917311592E-4]
[97,1114.95,17.27222222,32,0.14599999999999999,null,null,null,null,null,null,null,null,null,3.5918912443383264,4.6223824421819635E-4]
[98,953.07500000000005,16.74888889,32,0.18057799999999999,null,null,null,null,null,null,null,null,null,2.9617665321828768,3.9770863416798948E-4]
[99,1.2,17.300206348285698,32,0.34657800000000005,null,null,null,null,null,null,null,null,null,-1.4444511815382008,3.925226406947134E-4]
[100,1.2,16.892222220000001,32,0.34200000000000003,null,null,null,null,null,null,null,null,null,-1.2963850471438267,3.6170847334056745E-4]
[101,1.2,16.701111109999999,32,0.33400000000000002,null,null,null,null,null,null,null,null,null,-1.2312349837112542,3.4906300028874813E-4]
[102,478.50769230769203,15.2592625,32,0.32857800000000004,null,null,null,null,null,null,null,null,null,1.4044372667145155,2.5450095338888287E-4]
[103,375.45,15.079000000000001,32,0.30257800000000001,null,null,null,null,null,null,null,null,null,1.1357603042957207,2.4800114475824096E-4]
[104,451.2,15.031000000000001,33,0.27800000000000002,null,null,null,null,null,null,null,null,null,1.2562449513726108,2.4047272025099948E-4]
[105,303.7,14.798260869565199,32,0.2465,null,null,null,null,null,null,null,null,null,0.92441852353252352,2.4156117819030379E-4]
[106,247.86666666666699,14.84,32,0.21857800000000002,null,null,null,null,null,null,null,null,null,-0.72079616923595546,2.4978716356758928E-4]
[107,199.95,15.2602127659574,32,0.20157800000000001,null,null,null,null,null,null,null,null,null,-0.81802590217222737,2.8010312000377159E-4]
[108,160.84285714285701,15.2710434782609,31,0.15257800000000002,null,null,null,null,null,null,null,null,null,-0.82066022809402184,3.0780377059389744E-4]
[109,127.45,15.27,31,0.14057800000000001,null,null,null,null,null,null,null,null,null,-0.82040613818741126,3.1270298941438234E-4]
[110,115.575,15.2946956521739,32,0.126,null,null,null,null,null,null,null,null,null,-0.82643606865848418,3.095465713119679E-4]
[111,1.2,15.0487380952381,32,6.3577999999999996E-2,null,null,null,null,null,null,null,null,null,-0.76789639416944822,3.3418163447547901E-4]
[112,1.2,15.212894736842101,32,6.3577999999999996E-2,null,null,null,null,null,null,null,null,null,-0.80659404987346917,3.472463824450388E-4]
[113,1.2,15.1641612903226,32,5.8999999999999997E-2,null,null,null,null,null,null,null,null,null,-0.79495077895671273,3.4838905157640846E-4]
[114,1306.2,9.12510714285715,32,0.16857799999999998,null,null,null,null,null,null,null,null,null,0.87165533167240827,4.7110287261998193E-5]
[115,1284.325,8.8935862068965506,32,0.17357799999999998,null,null,null,null,null,null,null,null,null,0.80895038839095035,4.2773934042029592E-5]
[116,1284.4142857142899,9.1139999999999901,33,0.16457799999999997,null,null,null,null,null,null,null,null,null,0.83214345283175672,4.5456140805742201E-5]
[117,1273.2833333333299,9.4191954022988398,35,0.15257800000000002,null,null,null,null,null,null,null,null,null,0.84384115407300708,4.8370613193329805E-5]
[118,1259.7,9.1974262295081992,36,0.13857800000000001,null,null,null,null,null,null,null,null,null,0.76844222663916284,4.3834709664503798E-5]
[119,1183.7,9.3975714285714407,34,0.136578,null,null,null,null,null,null,null,null,null,0.81738107743087773,5.0728828732686709E-5]
[120,415.7,9.7770746268656499,34,9.6000000000000002E-2,null,null,null,null,null,null,null,null,null,0.40696765591708567,6.2516930195450311E-5]
[121,467.03333333333302,9.8759016393442707,34,8.6578000000000016E-2,null,null,null,null,null,null,null,null,null,0.45538530312277892,6.610254154482931E-5]
[122,353.38749999999999,10.0975,33,8.0500000000000002E-2,null,null,null,null,null,null,null,null,null,0.40067217462502369,7.5109843234092742E-5]
[123,1.2,10.4795,34,4.8577999999999982E-2,null,null,null,null,null,null,null,null,null,-0.14897104414104118,9.1287169851051649E-5]
[124,1.2,9.7344090909090895,34,4.8577999999999982E-2,null,null,null,null,null,null,null,null,null,-0.10664657844534692,7.0337498598627705E-5]
[125,1.2,9.6319999999999997,34,4.8577999999999982E-2,null,null,null,null,null,null,null,null,null,-0.10165582231698519,6.7756535994092378E-5]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]

{"sheet":"Wetland GHG Model","index":2,"n_rows":200,"n_cols":16,"rows_kept":200,"cut":false,"hidden":false,"merged":[[15,10,15,15],[11,8,11,10],[37,6,37,7],[15,1,15,8],[30,6,30,7]],"read":"row_number_cap"}
["README"]
["1. Enable \"macros\" in your Excel spreadsheet. If your version of the Excel software does not have \"macros\" enabled already, you should be asked to enable \"macros\" when you open this file. Then save this Excel file as a \"Excel Macro-Enabled Workbook\"."]
["2. Required input variables are photosynthetically active radiation (PAR, units: micromole/m2/s; Column B), soil temperature (units: degree celsius; Column C), sediment salinity (units: parts per thousand, ppt; Column D), water depth relative to the marsh elevation (units: meter; Column E)."]
["3. Net lateral flux (units: g/m2/) over the  growing extended period  (e.g., May-October) is considered as an input parameter (Column F) to calculate the net ecosystem carbon balance of the wetlands; net lateral flux is positive when going out of the wetland to the estuary/bay and negative otherwise."]
["4. Relative water depth (WD) is positive when water is above the marsh soil surface and  is negative when water is below the marsh soil surface. This is needed because CH4 flux model is being developed for two water level conditions: a) when water level is above the marsh soil surface (i.e., WD>0), and b) when the water level is below the march soil surface (WD<0). However, all the modeling equations are integrated here in a way that an user just needs to input their measured water depths relative the marsh elevation following the stated sign conventions (i.e., \"positive\" when WD>0 and \"negative\" when WD<0)."]
["5. Predicted variables are  CO2  flux (micromole/m2/s) (including both sequestration and emissions) and CH4 emission flux (micromole/m2/s)."]
["6. CH4 sequestration fluxes (from the atmosphere to the soil) were assumed negligible for the Waquoit Bay wetland system. It can be assumed negligible for most tidal wetlands."]
["7. To estimate the potential wetland carbon storage, Net Ecosystem Carbon Balance (NECB), the instanteneous balance of predicted CO2  and CH4 fluxes were up-scaled over the extended growing season (e.g., May to October) and substracted from the corresponding net lateral flux."]
["8. Positive sign of net wetland carbon balance indicates net carbon sequestration and negative sign indicates net GHG emissions."]
[]
[]
[null,null,null,null,null,null,null,null,"BWM Wetland GHG Model "]
[]
[]
[]
[null,"Input Variables  ",null,null,null,null,null,null,null,null,"Outputs"]
["Number of observations ","Photosynthetically active radiation, PAR (micromole/m2/s)","Soil temperature, ST (OC)","Soil salinity, SS  (ppt)","Water depth related to marsh surface, WD (m)","Net lateral flux over the growing  period (g/m2) ","Enter threshold value of light, PAR (micromole/m2/s)  ","Enter the number of days for which you want to estimate wetland carbon storage (NECB)","Enter CO2 equivalent global warming potential (GWP) for CH4",null,"Predicted CO2 Flux (micromole/m2/s)","Predicted CH4 emission flux (micromole/m2/s)","Total CO2 sequestration over the growing period (gC/m2)","Total CH4 emission over the growing period by considering the GWP (gC/m2)","Net ecosystem carbon balance over the growing period,  NECB (gC/m2)","Net ecosystem carbon balance over the growing period, NECB (metric ton C/hectare)"]
[1,null,null,null,null,0,100,null,1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]