{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Readme","Example","Coastal Wetland GHG Model "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Readme","index":0,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[[9,0,13,11],[14,0,14,11],[39,4,39,5],[2,0,2,11],[4,0,4,7],[5,0,5,7],[6,0,8,11]]}
["README"]
["Coastal wetland GHG model (CWGM) overview "]
["The coastal wetland GHG model (CWGM) is a power-law based empirical model developed by using data for four different wetlands in Waquoit Bay and Great Pond estuaries, MA, representing biogeochemical and ecological gradients. The model predicts daytime net uptake fluxes of CO2 (NEECO2,uptake, units: µmol/m2/s), nighttime emission fluxes of CO2 (NEECO2,emission, units: µmol/m2/s), and net emission fluxes of CH4 (NEECH4,emission, units: nmol/m2/s) from photosynthetically active radiation (PAR, units: µmol/m2/s), soil temperature (ST, units: °C), and porewater salinity (SS, units: parts per thousand, ppt). A robust multivariate data analytics framework was utilized to select the dominant environmental drivers of fluxes as model inputs. The model is simple, handy and user-friendly, and only requires a single set of input variables to predict the GHG fluxes.   \n"]
["Model Assumptions and Domain"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["UserGuide"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CH4 GWP options "]
[null,1,"If GWP is not considered"]
[null,34,"If 100 years GWP is considered (recommended)"]
[null,86,"If 20 years GWP is considered"]
[]
[]
[]
[]
["Model Output"]
[]
[]
[]
[]
["Reference"]

{"sheet":"Example","index":1,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,1,15,6],[15,9,15,14],[30,5,30,6],[37,5,37,6],[11,6,11,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Coastal Wetland GHG Model (CWGM)"]
[]
[]
[]
[null,"Inputs   ",null,null,null,null,null,null,null,"Outputs"]
["Date","Photosynthetically active radiation, PAR (micromole/m2/s)","Soil temperature, ST (°C)","Soil salinity, SS  (ppt)",null,"Enter the number of days for which you want to estimate net atmospheric carbon removal (NACR) ","Enter CO2 equivalent global warming potential (GWP) for CH4",null,null,"Predicted daytime net uptake fluxes of CO2, NEECO2, uptake (micromole/m2/s)","Predicted nighttime net emission fluxes of CO2, NEECO2, emission (micromole/m2/s)","Predicted anytime net emission fluxes of CH4,  NEECH4, emission (nanomole/m2/s)","Net CO2 (uptake minus emission) over the user defined period (gC/m2)","Net CH4 emission over the user defiend period by considering a GWP (gC/m2)","Net atmospheric carbon removal over the user defined period,  NACR (gC/m2)"]
["2013-05-01",1825.1583333333331,15.359888888888886,32,null,183,34,null,null,-2.7752414052610419,2.1762973357474409,0.2825441923453279,-240.72904195442194,4.4047311357060108,-236.32431081871593]
["2013-05-03",904.23571428571427,12.067516041979001,36,null,null,null,null,null,-0.69760386725275314,1.5191849465981413,0.10485118101380633]
["2013-05-17",1542.1722222222224,16.080632758087201,34.222222222222221,null,null,null,null,null,-2.6861619675631649,2.330191798839762,0.30229414263310561]
["2013-05-20",1223.6999999999989,16.79169300774015,36.5,null,null,null,null,null,-2.4804017082473275,2.4853684656208177,0.32172188800678941]
["2013-05-21",1635.9916666666677,19.394810247111199,25.25,null,null,null,null,null,-7.1496435932005014,3.080714460299101,0.86988577553610447]
["2013-06-04",1902.6285714285716,18.446037235262558,21,null,null,null,null,null,-8.1613332106926499,2.8588777894392461,0.93836020499143735]
["2013-06-05",1880.9916666666666,19.062477512595251,22.833333333333332,null,null,null,null,null,-8.2492490566110614,3.0023908171212303,0.93875045481843045]
["2013-06-06",1353.35625,21.729235837035574,31.25,null,null,null,null,null,-7.2903485464605389,3.6491879807635632,0.96550790846890833]
["2013-06-17",1029.95,23.268413849275365,25.666666666666668,null,null,null,null,null,-9.406506438034496,4.0409409247905872,1.5947646638779982]
["2013-06-18",1817.29375,20.5909681045603,20.5,null,null,null,null,null,-11.654771103488278,3.368048844591629,1.4168279962984316]
["2013-06-19",1936.4083333333333,20.256852693233846,27.222222222222221,null,null,null,null,null,-8.503658649553433,3.2869434716247246,0.91311708787314894]
["2013-07-10",1579.4142857142858,25.305896596293998,28.714285714285715,null,null,null,null,null,-14.568330778874854,4.5793135001729421,1.8309759588413204]
["2013-08-01",1967.8666666666668,24.1293198283498,30.5,null,null,null,null,null,-13.507786131465652,4.2657182707704795,1.4321079071709626]
["2013-08-13",457.39444444444467,21.839859544743103,32.666666666666664,null,null,null,null,null,-3.4549304125162186,3.6769037636296891,0.92548725678928223]
["2013-08-14",1891.6166666666668,21.978023514324633,30.166666666666668,null,null,null,null,null,-9.8025337976555864,3.7116162222619491,1.0531710152739431]
["2013-08-15",1688.1531249999987,21.042542458803936,31.75,null,null,null,null,null,-7.4642840441394496,3.4786948648953109,0.84593072050538176]
["2013-09-17",1156.95,17.287233675845766,32.666666666666664,null,null,null,null,null,-2.9609775830225273,2.5954400309966634,0.41315353721430575]
["2013-09-24",1432.0482142857149,14.704768680565751,29.5,null,null,null,null,null,-2.2360698799596128,2.0394483618519672,0.27131328406420796]
["2013-09-25",1389.5689236111127,16.756662470276236,32.125,null,null,null,null,null,-3.0712401512204957,2.4776468663866003,0.37949732236344846]
["2013-09-26",896.54642857142846,16.220093504323241,33.4,null,null,null,null,null,-1.982733378864252,2.3603667960656365,0.32182986218919518]
["2013-10-15",1081.1568903318916,14.420765466390817,33.666666666666664,null,null,null,null,null,-1.5126696629888234,1.9810370021060095,0.21222156925896213]
["2013-10-16",402.21442307692303,15.041880842391299,32.25,null,null,null,null,null,-0.94703553572611676,2.1095032293062523,0.26012211479716008]
["2013-10-17",701.55714285714259,16.584304761904765,31.666666666666668,null,null,null,null,null,-1.9202781659923542,2.4397702553839302,0.37337256917975464]
["2013-10-29",980.8603835978837,9.4330402973713419,33.666666666666664,null,null,null,null,null,-0.35254467795559591,1.0525216010491143,4.9071368395220562E-2]
["2013-10-30",488.99761904761908,9.5409285803627331,32.666666666666664,null,null,null,null,null,-0.23873033541878824,1.0705083543171516,5.3155256307831002E-2]

{"sheet":"Coastal Wetland GHG Model ","index":2,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[11,6,11,10],[37,5,37,6],[30,5,30,6],[15,1,15,6],[15,9,15,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Coastal Wetland GHG Model (CWGM)"]
[]
[]
[]
[null,"Inputs   ",null,null,null,null,null,null,null,"Outputs"]
["Date","Photosynthetically active radiation, PAR (micromole/m2/s)","Soil temperature, ST (°C)","Soil salinity, SS  (ppt)",null,"Enter the number of days for which you want to estimate net atmospheric carbon removal (NACR) ","Enter CO2 equivalent global warming potential (GWP) for CH4",null,null,"Predicted daytime net uptake fluxes of CO2, NEECO2, uptake (micromole/m2/s)","Predicted nighttime net emission fluxes of CO2, NEECO2, emission (micromole/m2/s)","Predicted anytime net emission fluxes of CH4,  NEECH4, emission (nanomole/m2/s)","Net CO2 (uptake minus emission) over the user defined period (gC/m2)","Net CH4 emission over the user defiend period by considering a GWP (gC/m2)","Net atmospheric carbon removal over the user defined period,  NACR (gC/m2)"]
[null,null,null,null,null,183,34]