{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Dataset S1_rev2","Flag"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Dataset S1_rev2","index":0,"n_rows":48,"n_cols":36,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Site","DATE","TIME","nTA_i (umol kg-1)","nTA","TA (umol kg-1)","density (kg m-3)","salinity","temperature (deg C)","nDIC_i (umol kg-1)","nDIC (umol kg-1)","DIC (umol kg-1)","CO2 Flux (mmol m-2 h-1)","dC13","POCt (umol L-1)","TR_C13","O2_C13_avg","t (hrs)","h_avg (m)","Time_i","POC_i (umol L-1)","C13i","insitu_mag (cm s-1)","avg_mag (cm s-1)","U*","omega","PAR","Phosphate","Silicate","Ammon","Urea","NO3+NO2","NEC ","POCoc_up","Flag","notes"]
[2,"2017-01-14","09:00:00","nan","nan",2501.6099439999998,"nan",34.897183329999997,24.251650000000001,"nan","nan",1992.3079,-0.15163744100000001,-23.38,"nan","nan","nan","nan","nan","nan","nan","nan","nan","nan","nan",5.71,345.3,0.34,0.64,0,0.31,0.2,"nan","nan",4]
[2,"2017-01-14","16:30:00",2221.3000000000002,2195.495062,2183.14,1023.16,34.86,25.04,1963.07,1919.5,1908.7,0.03,-22.14,17.329999999999998,-15.87,-25.05,19.75,2.0099999999999998,0.87152777777777779,4.3,-24.89,2.71,3.72,0.01,3.07,263,"nan","nan","nan","nan","nan",1.62,0.14000000000000001,1]
[2,"2017-01-15","07:17:00",2228.98,2206.17,2196.64,1023.42,34.9,24.31,1962.98,1993.69,1985.07,0.08,-19.84,14.25,-15.87,-25.09,14.91666667,1.76,0.68541666666666667,2.81,-25.09,9.86,3.87,0.01,2.44,0,0.27,1.4,0,0.03,0.04,1.7,0.19,1]
[2,"2017-01-15","12:30:00","nan",2193.7400309999998,2183.6276229999999,1023.25,34.808799999999998,24.840399999999999,"nan",1934.792369,1925.8736240000001,0.82191561999999996,-22.85,"nan","nan","nan","nan",1.6115999999999999,"nan","nan","nan","nan","nan","nan",2.9,1168,0.33,3.43,0,0.4,0.2,"nan","nan",4]
[2,"2017-01-15","16:38:00",2205.0100000000002,2195.91,2185.9699999999998,1023.19,34.9,25.04,1969.01,1926.05,1917.33,0.69,-21.66,10.83,-15.87,-25.05,6,1.9,0.43958333333333338,7.88,-25.1,5.66,4.0599999999999996,0.01,3.01,261.2,"nan","nan","nan","nan","nan",2.34,0.92,1]
[2,"2017-01-16","07:25:00",2289.42,2279.23,2274.4699999999998,1023.52,34.979999999999997,24.17,1987.02,2034.71,2030.46,2.39,-21.94,4.58,-15.87,-24.59,9.75,1.89,0.90972222222222221,7.96,-24.59,8.4,3.9,0.01,2.8,0,0.38,1.1499999999999999,0,0.82,0.14000000000000001,1.56,0.47,3]
[2,"2017-01-16","13:00:00",2289.42,2264.21,2258.37,1023.34,34.96,24.71,1987.02,1957.21,1952.16,-1.5,-23.61,3.38,-15.87,-24.59,12.83333333,1.95,0.95138888888888884,7.96,-24.59,4.5199999999999996,4.84,0.01,3.42,814,0.3,1.21,0,0.22,0.15,2.39,0.14000000000000001,3]
[2,"2017-01-16","16:21:00",2288.9247059999998,2265.889631,2259.3453119999999,1023.2,34.869,25.1524,1988.4659690000001,1926.079328,1920.516445,-1.5915622039999999,"nan","nan","nan","nan","nan",1.857,"nan","nan","nan","nan","nan","nan",3.77,288.8,0.4,0.88,0,0.67,0.15,4.8631807179999997,"nan",2]
[2,"2017-01-17","07:30:00",2259.04,2260.35,2251.9499999999998,1023.46,34.93,24.23,1979.86,2021.14,2013.63,2.2599999999999998,-22.85,3.02,-15.87,-23.79,12.08333333,1.91,0.85763888888888884,6.25,-23.79,8.3000000000000007,3.22,0.01,2.73,17.38,0.47,1.85,0,0.64,0.15,0.34,0.12,3]
[2,"2017-01-17","12:40:00",2274.38,2255.5500000000002,2247.77,1023.36,34.93,24.57,1987.08,1964.78,1958,-0.08,-23.22,3.25,-15.87,-23.79,12.58333333,2.06,0.99305555555555547,6.25,-23.79,6.77,3.54,0.01,3.25,785,0.25,1.1599999999999999,0,0.96,0.19,2.04,7.0000000000000007E-2,3]
[2,"2017-01-17","16:30:00",2274.38,2248.34,2241.0300000000002,1023.32,34.94,24.71,1987.08,1942.39,1936.08,-1.1000000000000001,-22.19,9.48,-15.87,-25.53,12.83333333,2.2599999999999998,0.14930555555555555,1.75,-25.53,7.78,2.9,0,3.4,300.2,0.42,2.4,0,0.32,0.21,2.85,0.11,3]
[2,"2017-01-23","07:34:00",2301,2283.58,2280.2600000000002,1023.87,35.03,23.09,1993,2016.81,2013.88,4.3,-20.63,18.75,-15.87,-26.24,2.25,2.5299999999999998,0.21458333333333335,3.73,-24.53,28.6,13.62,0.02,3,30.86,0.39,24.05,0,1.23,0.19,14.37,2.27,3]
[2,"2017-01-23","12:31:00",2301,2283.4499999999998,2277.9699999999998,1023.69,35,23.63,1993,1992.26,1987.48,-1.44,-23.58,6.94,-15.87,-26.24,2.5,2.59,0.44513888888888892,6.29,-26.04,22.12,12.6,0.02,3.25,969,0.42,1.1299999999999999,0,0.24,0.25,13.29,1.67,3]
[2,"2017-01-23","16:34:00",2301,2281.96,2277.35,1023.75,35.01,23.47,1993,1991.15,1987.13,-2.41,-22.04,13.23,-15.87,-26.24,1.5,2.4,0.58611111111111114,4.08,-24.1,25.23,15.35,0.02,3.25,144.9,0.23,1.31,0,0.34,0.2,21.77,2.65,3]
[2,"2017-01-24","07:30:00",2301,2301.5100000000002,2294.92,1023.66,34.979999999999997,23.71,1993,2018.1,2012.32,0.6,-24.57,2.33,-15.87,-26.24,2.9166666669999999,2.5499999999999998,0.20833333333333334,4.5999999999999996,-22.4,17.850000000000001,10.1,0.02,3.19,29.1,0.32,1.34,0,1.45,7.0000000000000007E-2,3.15,0.65,3]
[2,"2017-01-24","12:30:00",2301,2276.21,2269.41,1023.65,34.979999999999997,23.7,1993,1982.37,1976.44,-2.74,-22.82,5.5,-15.87,-26.24,1.8333333329999999,2.73,0.38194444444444442,4.5999999999999996,-22.4,23.71,12.2,0.01,3.28,460,"nan","nan","nan","nan","nan",24.62,2.2599999999999998,3]
[2,"2017-01-24","16:42:00",2301,2282.2399999999998,2274.79,1023.63,34.97,23.77,1993,1976.33,1969.89,-4.71,-23.53,13.71,-15.87,-26.24,2.0833333330000001,2.11,0.61249999999999993,3.48,-25.12,21.98,11.44,0.02,3.4,149.4,0.36,2.2400000000000002,0,1.36,0.28999999999999998,13.64,0.92,3]
[2,"2017-01-25","07:27:00",2301,2298.79,2292.37,1023.7,34.99,23.56,1993,2021.72,2016.06,1.31,-24.58,3.04,-15.87,-26.24,5,2.74,0.12638888888888888,1.56,-27.23,5.51,6.37,0.01,3.12,0,0.38,1.35,0,0.25,0.2,2.74,0.14000000000000001,3]
[2,"2017-01-25","12:22:00",2301,2292.6402549999998,2288.3410090000002,1023.58,34.934366670000003,24.051066670000001,2002.6354260000001,1980.5903040000001,1976.876225,-3.780555771,"nan","nan","nan","nan",3.0832999999999999,2.3912,"nan","nan","nan","nan","nan","nan",3.48,1253,0.23,0.88,0,0.23,0.16,"nan","nan",2]
[2,"2017-01-25","16:38:00",2301,2292.6402549999998,2273.507971,1023.58,34.901299999999999,23.990083330000001,2002.6354260000001,1980.5903040000001,1947.520937,-6.8421310919999998,"nan","nan","nan","nan",3.0832999999999999,2.3912,"nan","nan","nan","nan","nan","nan",3.62,347.2,0.28999999999999998,1.04,0.49,0.04,0.17,"nan","nan",2]
[2,"2017-01-26","07:30:00",2301,2302.21,2294.7600000000002,1023.63,34.97,23.78,1993,2018.37,2011.84,0.69,-22.49,4.4000000000000004,-15.87,-26.24,2.0833333330000001,2.36,0.23611111111111113,2.9,-23.49,16.850000000000001,8.9700000000000006,0.01,3.19,56.47,0.31,0.44,1.57,0.5,0.41,3.69,1.19,3]
[2,"2017-01-26","12:40:00",2301,2286.9499999999998,2280.4299999999998,1023.54,34.99,24.09,1993,1971.44,1965.82,-2.09,-23.41,5.79,-15.87,-26.24,2.5,2.2999999999999998,0.4236111111111111,4.54,-27.33,14.36,9.42,0.01,3.51,1266,0.28000000000000003,1.25,0,0.15,0.14000000000000001,10.17,1.1399999999999999,3]
[2,"2017-01-26","16:45:00",2301,2279.2600000000002,2271.37,1023.49,34.96,24.21,1993,1951.98,1945.22,-2.21,-23.72,9.15,-15.87,-26.24,5.1666666670000003,2.44,0.51041666666666663,4.54,-27.33,18.760000000000002,6.39,0.01,3.63,570.79999999999995,0.31,1.96,0,0.48,0.19,7.07,0.52,3]
[3,"2017-01-14","08:00:00","nan","nan",2195.4952539999999,1023.36342534456,34.694516669999999,24.163283329999999,"nan","nan",1952.2283460000001,0.17203121699999999,-20.77,"nan","nan","nan","nan","nan","nan","nan","nan","nan","nan","nan",2.75,48.67,0.25,4.8899999999999997,0,0.59,0.17,"nan","nan",4]
[3,"2017-01-14","14:41:00","nan","nan",2166.4687819999999,"nan",34.555666670000001,25.58583333,"nan","nan",1822.37,-1.4092022689999999,-20.04,"nan","nan","nan","nan","nan","nan","nan","nan","nan","nan","nan",3.78,835,"nan","nan","nan","nan","nan","nan","nan",4]
[3,"2017-01-14","16:14:00","nan","nan",2156.9952709999998,"nan",34.559516670000001,25.844633330000001,"nan","nan",1783.49,-3.1807170849999999,-20.8,"nan","nan","nan","nan","nan","nan","nan","nan","nan","nan","nan",4.08,609.4,"nan","nan","nan","nan","nan","nan","nan",4]
[3,"2017-01-15","08:00:00","nan","nan",2187.0179899999998,1023.311735,34.688000000000002,24.32041667,"nan","nan",1957.9648790000001,8.9761334999999998E-2,-21.5,"nan","nan","nan","nan","nan","nan","nan","nan","nan","nan","nan",2.61,36.43,0.4,5.9,0,0.48,0.15,"nan","nan",4]
[3,"2017-01-15","12:48:00","nan","nan",2168.0820189999999,"nan",34.590716669999999,25.105,"nan","nan",1857.0369430000001,-1.227482747,-22.02,"nan","nan","nan","nan","nan","nan","nan","nan","nan","nan","nan",3.44,1168,0.36,7.66,0,0.53,0.15,"nan","nan",4]
[3,"2017-01-15","16:15:00","nan","nan",2184.5715319999999,"nan",34.660016669999997,25.58638333,"nan","nan",1868.8384189999999,-0.30065218700000002,-20.51,"nan","nan","nan","nan","nan","nan","nan","nan","nan","nan","nan",3.5,624.70000000000005,"nan","nan","nan","nan","nan","nan","nan",4]
[3,"2017-01-16","08:00:00",2289.42,2255.71,2258.0100000000002,1023.69,35.01,23.87,1987.02,2043.54,2045.63,8.9700000000000006,-21.05,4.57,-15.87,-24.59,11.08333333,2.02,0.89583333333333337,7.96,-24.59,3.09,3.6,0.01,2.4700000000000002,69.2,0.45,1.56,0,0.74,0.17,3.14,0.59,3]
[3,"2017-01-16","12:40:00",2289.4171930000002,2249.9538470000002,2252.606781,1023.54,35.011233330000003,24.391783329999999,1987.017924,1965.126387,1967.443479,0.23755145699999999,"nan","nan","nan","nan",15,1.8039000000000001,"nan","nan","nan","nan","nan","nan",3.2,814,0.38,2.02,0.15,0.43,0.15,2.4287829589999999,"nan",2]
[3,"2017-01-16","16:50:00",2289.42,2252.23,2254.5100000000002,1023.36,35.01,24.96,1987.02,1914.83,1916.76,-1.71,-19.36,3.52,-15.87,-24.59,17.75,1.82,0.97569444444444453,7.96,-24.59,1.22,3.94,0.01,3.74,234.9,0.47,1.1000000000000001,0,0,0.14000000000000001,1.95,0.49,3]
[3,"2017-01-17","08:00:00",2259.04,2278.66,2281.59,1023.73,35.01,23.75,1979.86,2056.3000000000002,2058.94,3.3,-20.149999999999999,5,-15.87,-23.79,13.75,1.99,0.78819444444444453,6.25,-23.79,2.46,3.21,0.01,2.58,17.38,1.24,1.03,5.47,2.78,0.44,-1.45,0.41,3]
[3,"2017-01-17","13:05:00",2259.04,2183.5500000000002,2171.12,1023.32,34.770000000000003,24.49,1979.86,1844.27,1833.77,-2.15,-20.91,4.96,-15.87,-23.79,18,1.84,0.8125,6.25,-23.79,2.59,2.81,0,3.68,785,0.24,3.63,0,1.33,0.18,3.95,0.23,1]
[3,"2017-01-17","16:55:00",2274.38,2242.08,2245.86,1023.41,35.03,24.86,1987.08,1912.74,1915.96,-2.31,-19.71,11.98,-15.87,-23.79,17.75,1.93,0.97916666666666663,6.25,-23.79,3.56,3.2,0.01,3.65,300.2,0.2,0.97,0,0.94,0.22,1.8,0.35,3]
[3,"2017-01-23","07:58:00",2301,2280.39,2283.41,1023.95,35.049999999999997,23.09,1993,2018.54,2021.21,6.17,-21.94,8.1,-15.87,-26.24,2.5,1.92,0.21388888888888891,3.73,-24.53,13.6,14.4,0.02,2.96,30.86,0.66,1.33,2.77,0.48,0.39,8.8800000000000008,1.19,3]
[3,"2017-01-23","12:51:00",2301,2275.0100000000002,2274.61,1023.71,34.99,23.75,1993,1963.9,1963.55,-5.33,-21.26,7.65,-15.87,-26.24,2.8333333330000001,2.0299999999999998,0.41736111111111113,6.29,-26.04,9.1,12.75,0.02,3.46,969,0.56000000000000005,1.51,0,0.74,0.15,10.23,2.16,3]
[3,"2017-01-23","16:15:00",2301,2279.16,2278.91,1023.69,35,23.85,1993,1954.62,1954.41,-8.64,-22.62,5.44,-15.87,-26.24,2.75,1.81,0.55902777777777779,6.29,-26.04,11.11,12.88,0.02,3.6,250.6,0.34,2.56,0.67,0.48,0.18,8.0299999999999994,1.45,3]
[3,"2017-01-24","08:00:00",2301,2289.59,2289.83,1023.75,35,23.66,1993,2026.02,2026.24,2.88,-23.47,3.63,-15.87,-26.24,4,2.04,0.16319444444444445,4.5999999999999996,-22.4,5.81,9.0399999999999991,0.01,2.99,29.1,"nan","nan","nan","nan","nan",3.48,0.63,3]
[3,"2017-01-24","12:50:00",2301,2286.35,2286.16,1023.56,35,24.29,1993,1948.03,1947.87,-11.66,-24.58,6.08,-15.87,-26.24,3.9166666669999999,2.09,0.36805555555555558,4.5999999999999996,-22.4,9.0500000000000007,9.3699999999999992,0.01,3.76,460,"nan","nan","nan","nan","nan",4.54,0.39,3]
[3,"2017-01-24","16:30:00",2301,2278.94,2280,1023.66,35.020000000000003,24.01,1993,1935.81,1936.71,-11.64,-22.86,"nan",-15.87,-26.24,3.8333333330000001,1.97,0.52430555555555558,3.17,-27.31,7.79,9.6199999999999992,0.01,3.8,149.4,0.34,1.21,0,1.19,0.25,6.31,0.53,3]
[3,"2017-01-25","07:53:00",2301,2264.71,2292.52,1023.88,34.97,23.13,1993,2014.78,2013.26,5.29,-23.89,7,-15.87,-26.24,5.6666666670000003,2.21,8.5416666666666655E-2,1.56,-27.23,6.07,6.28,0.01,2.83,33.15,0.28999999999999998,1.32,0,0.77,0.14000000000000001,1.74,0.14000000000000001,3]
[3,"2017-01-25","12:40:00",2301,2277.0108270000001,2277.4564700000001,1023.54,35.00685,24.36538333,2002.6354260000001,1935.7557629999999,1936.134618,-7.1301050889999997,"nan","nan","nan","nan",6.1666666670000003,2.2046000000000001,"nan","nan","nan","nan","nan","nan",3.78,1071,0.31,1.96,0,0.5,0.26,4.070494922,"nan",2]
[3,"2017-01-25","16:20:00",2301,2272.23,2273.3000000000002,1023.44,35.020000000000003,24.73,1993,1886.69,1887.57,-16.59,-23.24,2.33,-15.87,-26.24,6.75,1.84,0.44444444444444442,1.56,-27.23,5.78,4.9800000000000004,0.01,4.24,643.1,0.38,1.4,0.17,0.01,0.23,4.3,0.12,3]
[3,"2017-01-26","08:00:00",2301,2295.4,2296.64,1023.9,35.020000000000003,23.19,1993,2022.02,2023.11,1.33,-26.2,1.92,-15.87,-26.24,5.5833333329999997,2.4,0.10069444444444443,2.9,-23.49,7.22,6.51,0.01,3.08,56.47,0.39,1.07,0,0.46,0.19,1.67,0,3]
[3,"2017-01-26","12:26:00",2301,2281.41,2281.1,1023.53,35,24.37,1993,1943.76,1943.5,-4.55,-22.16,5.77,-15.87,-26.24,4.5,2.15,0.32708333333333334,2.9,-23.49,6.1,8,0.01,3.75,1229,0.37,0.81,0,1.27,0.17,5.28,0.55000000000000004,3]
[3,"2017-01-26","16:17:00",2301,2273.9506190000002,2273.5174849999999,1023.3,34.993333329999999,25.126316670000001,1991.077636,1888.8227549999999,1888.4629789999999,-3.8430788699999998,"nan","nan","nan","nan",5.8333333329999997,2.0893000000000002,"nan","nan","nan","nan","nan","nan",4.25,934,0.26,1.22,0,1.69,0.09,5.4217086930000002,"nan",2]

{"sheet":"Flag","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Flag","notes"]
[1,"parcel came from lagoon (i.e., low salinity)"]
[2,"sample lost/analysis error"]
[3,"good"]
[4,"water parcel not tracked back to reef crest"]