{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Read Me","DO Saturation","Time of Day Interpreter","Time of Day Interpret & Assess","Combined DO Sat and Criteria"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":3,"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":"Read Me","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["History:  The previous salt and freshwater dissolved oxygen (DO) criteria expressed in mg/L DO concentration were recently replaced by DO criteria epressed as percent saturation.  The new DO criteria were adopted by the Environmental Regulation Commission and became effective for state purposes on 4/23/2013.  The new DO criteria became effective for all clean water act purposes upon approval by the USEPA which was received on 09/09/2013.   \n\n"]
["The revised DO criteria were developed by the FDEP and documented in \"Technical Support Document: Derivation of Dissolved Oxygen Criteria to Protect Aquatic Life in Florida’s Fresh and Marine Waters\".  The Technical Support Document (TSD) can be found at the website https://dep.state.fl.us/water/wqssp/docs/tsd-do-criteria-aquatic-life.pdf (use button below open a copy of the TSD).  \n"]
["As stated in Chapter 62-302.533, F.A.C., in Class I, Class III and Class III-Limited predominantly freshwaters no more than 10 percent of the daily average percent dissolved oxygen (DO) saturation values shall be below 67 percent in the Panhandle West bioregion, 38 percent in the Peninsula and Everglades bioregions, or 34 percent in the Northeast and Big Bend bioregions. A map of the bioregions is contained in SCI 1000: Stream Condition Index Methods (DEP-SOP-003/11 SCI 1000) dated March 1, 2014 (http://www.flrules.org/Gateway/reference.asp?No=Ref-06039).  For Class II, Class III, and Class III-Limited predominantly marine waters minimum DO saturation levels shall be:  no more than 10 percent ot the daily average percent DO saturation shall be below 42 percent saturation; and the seven-day average DO percent saturation shall not be below 51 percent more than once in any twelve week period; and the 30-day average DO percent saturation shall not be below 56 percent more than once per year."]
["For the full DO criteria and details concerning its implementation, please refer to Chapter 62-302.533, F.A.C. and Chapter 62-303, F.A.C., respectively."]
["The daily average criteria shall be assessed preferentially using daily average values calculated from full days of diel monitoring data.  For IWR assessments of ambient freshwaters, if diel monitoring data are not available, instantaneous samples may be used to assess the DO criterion by comparing the instantaneous value with a time-of-day-specific translation of the daily average criterion as specified in Section 62-303.420(9), F.A.C.   The actual DO measurement collected at a given time is assessed against the calculated time-of-day-specific translation for that time, and if the instantaneous DO is greater than or equal to the calculated value, the daily average DO criterion is achieved.  "]
["To aid in the application of the new DO criteria, a series of calculators have been developed to perform the necessary calculations.  Specifically, this spreadsheet contains calculators for: 1) Calculation of DO saturation concentration and percent saturation, 2) Calculation of time-of-day interpretation for the freshwater criteria, 3) Assess measured DO saturation based on time-of-day interpretation for the freshwater criteria, and 4) Calculate DO saturation and time-of-day interpretation for the freshwater criteria.  The calculators can be accessed by either clicking on the appropriate button below or the appropriate tab at the bottom of the screen."]
["1)  Calculation of DO saturation concentration"]
["2)  Calculation of time-of-day interpretation for the freshwater criteria"]
["3)  Assess measured DO saturation based on time-of-day interpretation for the freshwater criteria"]
["4)  Calculate DO saturation and time-of-day interpretation for the freshwater criteria"]

{"sheet":"DO Saturation","index":1,"n_rows":105,"n_cols":10,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7]]}
["Dissolved Oxygen Percent Saturation Calculator"]
["To use:  1) Press \"Clear Entries\" button on right to remove all old data entries.  2) Enter measured DO concentration in mg/L and Water Temperature in °C (DO concentration and water temperature are always required).  3) Then enter Salinity (ppt)/Specific Conductance measurement in µmhos/cm if available (salinity or conductivity is required for estuarine/marine waters, and is optional for freshwaters) (Note: Calculation preferentially uses salinity.  If salinity data is not available then leave salinity blank and enter conductivity and it will be used.  If neither salinity or conductivity data are entered then a salinity of zero is assumed.)   4) Entry of Barometric Pressure is optional and should generally be left blank (if blank, 1 atmosphere (i.e., 760 mm Hg) is assumed)."]
["Unshaded (white) fields (Columns A - F) are for data entry.                   Additional notes are embedded as comments in the heading for each column, please review!"]
["Shaded fields (Columns G and H) are results fields and are protected from change.                         Do Not Attempt to Change These Fields!"]
["Site ID","Measured DO Concentration, mg/L","Measured Water Temperature (°C)","Measured Salinity (ppt) (Salinity = 1.80655*Chlorinity = 1.0045 Chloride)","Measured Specific Conductance (μS/cm)","Barometric Pressure (mm Hg) (1 atm = 760 mm Hg)","DO Concentration (mg/L) at 100% Saturation","DO Percent Saturation for Given DO Concentration","Barometric Pressure","Final Salinity"]
[1,4.2,20,null,566,null,{"$f":"IF(OR(ISBLANK($B6),ISBLANK($C6)),\"\",(EXP((-139.34411+(157570.1/($C6+273.15)-(66423080/($C6+273.15)^2)+(12438000000/($C6+273.15)^3)-(862194900000/($C6+273.15)^4))-($J6*(0.017674-(10.754/($C6+273.15))+(2140.7/($C6+273.15)^2))))))*($I6/760)*((1-((EXP(11.8581-(3840.7/($C6+273.15))-(216961/($C6+273.15)^2)))/($I6/760)))*(1-(0.000975-(0.00001426*$C6)+(0.00000006436*$C6^2))*($I6/760)))/((1-(EXP(11.8581-(3840.7/($C6+273.15))-(216961/($C6+273.15)^2))))*(1-(0.000975-(0.00001426*$C6)+(0.00000006436*$C6^2)))))","v":9.0777066402724316},{"$f":"IF(OR(ISBLANK(B6),ISBLANK(C6)),\"\",B6/G6*100)","v":46.267192435665159},{"$f":"IF(ISBLANK(F6),760,F6)","v":760},{"$f":"IF(AND(ISBLANK($D6),ISBLANK($E6)),0,IF(ISBLANK($D6),IF($E6=0,0,(0.008-(0.1692*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))^0.5)+(25.3851*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4))))+(14.0941*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))^1.5)-(7.0261*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))^2)+(2.7081*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))^2.5)+(($C6-15)/(1+0.0162*($C6-15))*(0.0005-0.0056*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))^0.5-0.0066*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))-0.0375*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))^1.5+0.0636*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))^2-0.0144*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4)))^2.5)))-(0.008/(1+(1.5*400*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4))))+(400*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4))))^2))-((0.0005*($C6-15)/(1+0.0162*($C6-15)))/(1+(100*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4))))^0.5+(100*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+(($I6/760*1.01325)*(0.000207-(0.0000000637*($I6/760*1.01325))+(0.000000000003989*($I6/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($E6*(1+0.0191*($C6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C6+0.0001104259*$C6^2-0.00000069698*$C6^3+0.0000000010031*$C6^4))))^1.5))),$D6))","v":0.27461355073475502}]
[2,null,null,null,null,null,"","",760,0]
[3,null,null,null,null,null,"","",760,0]
[4,null,null,null,null,null,"","",760,0]
[5,null,null,null,null,null,"","",760,0]
[6,null,null,null,null,null,"","",760,0]
[7,null,null,null,null,null,"","",760,0]
[8,null,null,null,null,null,"","",760,0]
[9,null,null,null,null,null,"","",760,0]
[10,null,null,null,null,null,"","",760,0]
[11,null,null,null,null,null,"","",760,0]
[12,null,null,null,null,null,"","",760,0]
[13,null,null,null,null,null,"","",760,0]
[14,null,null,null,null,null,"","",760,0]
[15,null,null,null,null,null,"","",760,0]
[16,null,null,null,null,null,"","",760,0]
[17,null,null,null,null,null,"","",760,0]
[18,null,null,null,null,null,"","",760,0]
[19,null,null,null,null,null,"","",760,0]
[20,null,null,null,null,null,"","",760,0]
[21,null,null,null,null,null,"","",760,0]
[22,null,null,null,null,null,"","",760,0]
[23,null,null,null,null,null,"","",760,0]
[24,null,null,null,null,null,"","",760,0]
[25,null,null,null,null,null,"","",760,0]
[26,null,null,null,null,null,"","",760,0]
[27,null,null,null,null,null,"","",760,0]
[28,null,null,null,null,null,"","",760,0]
[29,null,null,null,null,null,"","",760,0]
[30,null,null,null,null,null,"","",760,0]
[31,null,null,null,null,null,"","",760,0]
[32,null,null,null,null,null,"","",760,0]
[33,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($B38),ISBLANK($C38)),\"\",(EXP((-139.34411+(157570.1/($C38+273.15)-(66423080/($C38+273.15)^2)+(12438000000/($C38+273.15)^3)-(862194900000/($C38+273.15)^4))-($J38*(0.017674-(10.754/($C38+273.15))+(2140.7/($C38+273.15)^2))))))*($I38/760)*((1-((EXP(11.8581-(3840.7/($C38+273.15))-(216961/($C38+273.15)^2)))/($I38/760)))*(1-(0.000975-(0.00001426*$C38)+(0.00000006436*$C38^2))*($I38/760)))/((1-(EXP(11.8581-(3840.7/($C38+273.15))-(216961/($C38+273.15)^2))))*(1-(0.000975-(0.00001426*$C38)+(0.00000006436*$C38^2)))))","v":""},{"$f":"IF(OR(ISBLANK(B38),ISBLANK(C38)),\"\",B38/G38*100)","v":""},{"$f":"IF(ISBLANK(F38),760,F38)","v":760},{"$f":"IF(AND(ISBLANK($D38),ISBLANK($E38)),0,IF(ISBLANK($D38),IF($E38=0,0,(0.008-(0.1692*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))^0.5)+(25.3851*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4))))+(14.0941*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))^1.5)-(7.0261*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))^2)+(2.7081*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))^2.5)+(($C38-15)/(1+0.0162*($C38-15))*(0.0005-0.0056*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))^0.5-0.0066*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))-0.0375*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))^1.5+0.0636*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))^2-0.0144*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4)))^2.5)))-(0.008/(1+(1.5*400*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4))))+(400*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4))))^2))-((0.0005*($C38-15)/(1+0.0162*($C38-15)))/(1+(100*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4))))^0.5+(100*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)/((1+(($I38/760*1.01325)*(0.000207-(0.0000000637*($I38/760*1.01325))+(0.000000000003989*($I38/760*1.01325)^2))/(1+(0.03426*$C38)+(0.0004464*$C38^2)+(0.4215-0.003107*$C38)*((($E38*(1+0.0191*($C38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C38+0.0001104259*$C38^2-0.00000069698*$C38^3+0.0000000010031*$C38^4))))^1.5))),$D38))","v":0}]
[34,null,null,null,null,null,"","",760,0]
[35,null,null,null,null,null,"","",760,0]
[36,null,null,null,null,null,"","",760,0]
[37,null,null,null,null,null,"","",760,0]
[38,null,null,null,null,null,"","",760,0]
[39,null,null,null,null,null,"","",760,0]
[40,null,null,null,null,null,"","",760,0]
[41,null,null,null,null,null,"","",760,0]
[42,null,null,null,null,null,"","",760,0]
[43,null,null,null,null,null,"","",760,0]
[44,null,null,null,null,null,"","",760,0]
[45,null,null,null,null,null,"","",760,0]
[46,null,null,null,null,null,"","",760,0]
[47,null,null,null,null,null,"","",760,0]
[48,null,null,null,null,null,"","",760,0]
[49,null,null,null,null,null,"","",760,0]
[50,null,null,null,null,null,"","",760,0]
[51,null,null,null,null,null,"","",760,0]
[52,null,null,null,null,null,"","",760,0]
[53,null,null,null,null,null,"","",760,0]
[54,null,null,null,null,null,"","",760,0]
[55,null,null,null,null,null,"","",760,0]
[56,null,null,null,null,null,"","",760,0]
[57,null,null,null,null,null,"","",760,0]
[58,null,null,null,null,null,"","",760,0]
[59,null,null,null,null,null,"","",760,0]
[60,null,null,null,null,null,"","",760,0]
[61,null,null,null,null,null,"","",760,0]
[62,null,null,null,null,null,"","",760,0]
[63,null,null,null,null,null,"","",760,0]
[64,null,null,null,null,null,"","",760,0]
[65,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($B70),ISBLANK($C70)),\"\",(EXP((-139.34411+(157570.1/($C70+273.15)-(66423080/($C70+273.15)^2)+(12438000000/($C70+273.15)^3)-(862194900000/($C70+273.15)^4))-($J70*(0.017674-(10.754/($C70+273.15))+(2140.7/($C70+273.15)^2))))))*($I70/760)*((1-((EXP(11.8581-(3840.7/($C70+273.15))-(216961/($C70+273.15)^2)))/($I70/760)))*(1-(0.000975-(0.00001426*$C70)+(0.00000006436*$C70^2))*($I70/760)))/((1-(EXP(11.8581-(3840.7/($C70+273.15))-(216961/($C70+273.15)^2))))*(1-(0.000975-(0.00001426*$C70)+(0.00000006436*$C70^2)))))","v":""},{"$f":"IF(OR(ISBLANK(B70),ISBLANK(C70)),\"\",B70/G70*100)","v":""},{"$f":"IF(ISBLANK(F70),760,F70)","v":760},{"$f":"IF(AND(ISBLANK($D70),ISBLANK($E70)),0,IF(ISBLANK($D70),IF($E70=0,0,(0.008-(0.1692*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))^0.5)+(25.3851*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4))))+(14.0941*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))^1.5)-(7.0261*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))^2)+(2.7081*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))^2.5)+(($C70-15)/(1+0.0162*($C70-15))*(0.0005-0.0056*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))^0.5-0.0066*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))-0.0375*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))^1.5+0.0636*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))^2-0.0144*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4)))^2.5)))-(0.008/(1+(1.5*400*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4))))+(400*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4))))^2))-((0.0005*($C70-15)/(1+0.0162*($C70-15)))/(1+(100*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4))))^0.5+(100*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)/((1+(($I70/760*1.01325)*(0.000207-(0.0000000637*($I70/760*1.01325))+(0.000000000003989*($I70/760*1.01325)^2))/(1+(0.03426*$C70)+(0.0004464*$C70^2)+(0.4215-0.003107*$C70)*((($E70*(1+0.0191*($C70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C70+0.0001104259*$C70^2-0.00000069698*$C70^3+0.0000000010031*$C70^4))))^1.5))),$D70))","v":0}]
[66,null,null,null,null,null,"","",760,0]
[67,null,null,null,null,null,"","",760,0]
[68,null,null,null,null,null,"","",760,0]
[69,null,null,null,null,null,"","",760,0]
[70,null,null,null,null,null,"","",760,0]
[71,null,null,null,null,null,"","",760,0]
[72,null,null,null,null,null,"","",760,0]
[73,null,null,null,null,null,"","",760,0]
[74,null,null,null,null,null,"","",760,0]
[75,null,null,null,null,null,"","",760,0]
[76,null,null,null,null,null,"","",760,0]
[77,null,null,null,null,null,"","",760,0]
[78,null,null,null,null,null,"","",760,0]
[79,null,null,null,null,null,"","",760,0]
[80,null,null,null,null,null,"","",760,0]
[81,null,null,null,null,null,"","",760,0]
[82,null,null,null,null,null,"","",760,0]
[83,null,null,null,null,null,"","",760,0]
[84,null,null,null,null,null,"","",760,0]
[85,null,null,null,null,null,"","",760,0]
[86,null,null,null,null,null,"","",760,0]
[87,null,null,null,null,null,"","",760,0]
[88,null,null,null,null,null,"","",760,0]
[89,null,null,null,null,null,"","",760,0]
[90,null,null,null,null,null,"","",760,0]
[91,null,null,null,null,null,"","",760,0]
[92,null,null,null,null,null,"","",760,0]
[93,null,null,null,null,null,"","",760,0]
[94,null,null,null,null,null,"","",760,0]
[95,null,null,null,null,null,"","",760,0]
[96,null,null,null,null,null,"","",760,0]
[97,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(B102),ISBLANK(C102)),\"\",B102/G102*100)","v":""},760,0]
[98,null,null,null,null,null,"","",760,0]
[99,null,null,null,null,null,"","",760,0]
[100,null,null,null,null,null,"","",760,0]

{"sheet":"Time of Day Interpreter","index":2,"n_rows":106,"n_cols":15,"rows_kept":106,"cut":false,"hidden":false,"merged":[[4,6,4,8],[4,9,4,11],[0,0,0,4],[1,0,1,4],[3,0,3,4],[4,0,5,0],[4,1,5,1],[4,4,5,4],[2,0,2,4]]}
["Time-of-Day Interpreter for Florida's Freshwater DO Criteria! "]
["To use: Choose SCI Bioregion and waterbody type from Drop-down lists.  Then enter local time at which DO measurement was taken in 24 hour format (e.g., 16:10).                                                                                       Note: The time-of-day interpretion is only applicable for freshwaters!",null,null,null,null,null,null,null,null,null,null,null,null,"Bioregions","Waterbody Type"]
["Unshaded (white) fields (Columns A - F) are for data entry.       Additional notes are embedded as comments in the heading for each column, please review!"]
["Yellow shaded cells (Column E) are the result field and are protected from change.          Do Not Attempt to Change This Field!",null,null,null,null,null,null,null,null,null,null,null,null,"Big Bend","Stream/Canal"]
["Sample","SCI-2012 Bioregion","Waterbody Type","Time-of-day Sample was Collected (local time)","Time-of-day Interpretation of Criteria",null,"Streams",null,null,"Lakes",null,null,null,"Everglades","Lake/Wetland"]
[null,null,"(e.g., Lake or Stream)","(24 hr format, 23:15)",null,null,"Northeast + Big Bend","Peninsula + Everglades","Panhandle West","Northeast + Big Bend","Peninsula + Everglades","Panhandle West",null,"Northeast","Estuary/Marine"]
[1,"Northeast","Stream/Canal","11:11:00",{"$f":"IF(OR(ISBLANK($B7),ISBLANK($C7),ISBLANK($D7)),\"\",IF($C7=\"Estuary/Marine\",\"Time of day Adjustment not appropriate for marine waters!\",IF(OR(CONCATENATE($B7,\"-\",$C7)=\"Peninsula-Lake/Wetland\",CONCATENATE($B7,\"-\",$C7)=\"Everglades-Lake/Wetland\"),K7,IF(OR(CONCATENATE($B7,\"-\",$C7)=\"Northeast-Lake/Wetland\",CONCATENATE($B7,\"-\",$C7)=\"Big Bend-Lake/Wetland\"),J7,IF(CONCATENATE($B7,\"-\",$C7)=\"Panhandle West-Lake/Wetland\",L7,IF(OR(CONCATENATE($B7,\"-\",$C7)=\"Peninsula-Stream/Canal\",CONCATENATE($B7,\"-\",$C7)=\"Everglades-Stream/Canal\"),H7,IF(OR(CONCATENATE($B7,\"-\",$C7)=\"Northeast-Stream/Canal\",CONCATENATE($B7,\"-\",$C7)=\"Big Bend-Stream/Canal\"),G7,IF(CONCATENATE($B7,\"-\",$C7)=\"Panhandle West-Stream/Canal\",I7,\"Error! Check Entries\"))))))))","v":34.421644306282673},null,{"$f":"1.18443700433286E-13*(HOUR($D7)*60+MINUTE($D7))^5 - 4.14323598958596E-10*(HOUR($D7)*60+MINUTE($D7))^4 + 4.77287727122539E-07*(HOUR($D7)*60+MINUTE($D7))^3 - 0.000196917585728373*(HOUR($D7)*60+MINUTE($D7))^2 + 0.0231405627601475*(HOUR($D7)*60+MINUTE($D7)) + 31.2398283659495","v":34.421644306282673},{"$f":"1.98879987167155E-13*(HOUR($D7)*60+MINUTE($D7))^5 - 6.89410992615642E-10*(HOUR($D7)*60+MINUTE($D7))^4 + 7.83730333422071E-07*(HOUR($D7)*60+MINUTE($D7))^3 - 0.00031597890334556*(HOUR($D7)*60+MINUTE($D7))^2 + 0.0355135105918976*(HOUR($D7)*60+MINUTE($D7)) + 33.4327310978006","v":39.066720166422357},{"$f":"9.08511511657608E-14*(HOUR($D7)*60+MINUTE($D7))^5 - 2.99407211249053E-10*(HOUR($D7)*60+MINUTE($D7))^4 + 3.1560253348998E-07*(HOUR($D7)*60+MINUTE($D7))^3 - 0.000108510891323021*(HOUR($D7)*60+MINUTE($D7))^2 + 0.00628484730145829*(HOUR($D7)*60+MINUTE($D7)) + 65.6142372750764","v":67.985473191520057},{"$f":"1.45776613020539E-13*(HOUR($D7)*60+MINUTE($D7))^5-5.56072270585461E-10*(HOUR($D7)*60+MINUTE($D7))^4+7.06833400255548E-07*(HOUR($D7)*60+MINUTE($D7))^3-0.000318788465226261*(HOUR($D7)*60+MINUTE($D7))^2+0.0281711711660364*(HOUR($D7)*60+MINUTE($D7))+34.1911117699055","v":30.208682757887964},{"$f":"1.37090283182826E-13*(HOUR($D7)*60+MINUTE($D7))^5 - 5.04960255463897E-10*(HOUR($D7)*60+MINUTE($D7))^4 + 6.13524315934422E-07*(HOUR($D7)*60+MINUTE($D7))^3 - 0.00025817433468811*(HOUR($D7)*60+MINUTE($D7))^2 + 0.0195966892410979*(HOUR($D7)*60+MINUTE($D7)) + 37.1360250050275","v":35.681049151112255},{"$f":"7.11895278892582E-14*(HOUR($D7)*60+MINUTE($D7))^5-2.64195273421019E-10*(HOUR($D7)*60+MINUTE($D7))^4 + 3.22473039456213E-07*(HOUR($D7)*60+MINUTE($D7))^3 - 0.00013606873481109*(HOUR($D7)*60+MINUTE($D7))^2 + 0.0107100719720847*(HOUR($D7)*60+MINUTE($D7))+66.3535900428978","v":65.825763407252651},null,"Panhandle West"]
[2,null,null,null,{"$f":"IF(OR(ISBLANK($B8),ISBLANK($C8),ISBLANK($D8)),\"\",IF($C8=\"Estuary/Marine\",\"Time of day Adjustment not appropriate for marine waters!\",IF(OR(CONCATENATE($B8,\"-\",$C8)=\"Peninsula-Lake/Wetland\",CONCATENATE($B8,\"-\",$C8)=\"Everglades-Lake/Wetland\"),K8,IF(OR(CONCATENATE($B8,\"-\",$C8)=\"Northeast-Lake/Wetland\",CONCATENATE($B8,\"-\",$C8)=\"Big Bend-Lake/Wetland\"),J8,IF(CONCATENATE($B8,\"-\",$C8)=\"Panhandle West-Lake/Wetland\",L8,IF(OR(CONCATENATE($B8,\"-\",$C8)=\"Peninsula-Stream/Canal\",CONCATENATE($B8,\"-\",$C8)=\"Everglades-Stream/Canal\"),H8,IF(OR(CONCATENATE($B8,\"-\",$C8)=\"Northeast-Stream/Canal\",CONCATENATE($B8,\"-\",$C8)=\"Big Bend-Stream/Canal\"),G8,IF(CONCATENATE($B8,\"-\",$C8)=\"Panhandle West-Stream/Canal\",I8,\"Error! Check Entries\"))))))))","v":""},null,{"$f":"1.18443700433286E-13*(HOUR($D8)*60+MINUTE($D8))^5 - 4.14323598958596E-10*(HOUR($D8)*60+MINUTE($D8))^4 + 4.77287727122539E-07*(HOUR($D8)*60+MINUTE($D8))^3 - 0.000196917585728373*(HOUR($D8)*60+MINUTE($D8))^2 + 0.0231405627601475*(HOUR($D8)*60+MINUTE($D8)) + 31.2398283659495","v":31.239828365949499},{"$f":"1.98879987167155E-13*(HOUR($D8)*60+MINUTE($D8))^5 - 6.89410992615642E-10*(HOUR($D8)*60+MINUTE($D8))^4 + 7.83730333422071E-07*(HOUR($D8)*60+MINUTE($D8))^3 - 0.00031597890334556*(HOUR($D8)*60+MINUTE($D8))^2 + 0.0355135105918976*(HOUR($D8)*60+MINUTE($D8)) + 33.4327310978006","v":33.432731097800598},{"$f":"9.08511511657608E-14*(HOUR($D8)*60+MINUTE($D8))^5 - 2.99407211249053E-10*(HOUR($D8)*60+MINUTE($D8))^4 + 3.1560253348998E-07*(HOUR($D8)*60+MINUTE($D8))^3 - 0.000108510891323021*(HOUR($D8)*60+MINUTE($D8))^2 + 0.00628484730145829*(HOUR($D8)*60+MINUTE($D8)) + 65.6142372750764","v":65.614237275076405},34.191111769905497,{"$f":"1.37090283182826E-13*(HOUR($D8)*60+MINUTE($D8))^5 - 5.04960255463897E-10*(HOUR($D8)*60+MINUTE($D8))^4 + 6.13524315934422E-07*(HOUR($D8)*60+MINUTE($D8))^3 - 0.00025817433468811*(HOUR($D8)*60+MINUTE($D8))^2 + 0.0195966892410979*(HOUR($D8)*60+MINUTE($D8)) + 37.1360250050275","v":37.136025005027498},{"$f":"7.11895278892582E-14*(HOUR($D8)*60+MINUTE($D8))^5-2.64195273421019E-10*(HOUR($D8)*60+MINUTE($D8))^4 + 3.22473039456213E-07*(HOUR($D8)*60+MINUTE($D8))^3 - 0.00013606873481109*(HOUR($D8)*60+MINUTE($D8))^2 + 0.0107100719720847*(HOUR($D8)*60+MINUTE($D8))+66.3535900428978","v":66.353590042897807},null,"Peninsula"]
[3,null,null,null,{"$f":"IF(OR(ISBLANK($B9),ISBLANK($C9),ISBLANK($D9)),\"\",IF($C9=\"Estuary/Marine\",\"Time of day Adjustment not appropriate for marine waters!\",IF(OR(CONCATENATE($B9,\"-\",$C9)=\"Peninsula-Lake/Wetland\",CONCATENATE($B9,\"-\",$C9)=\"Everglades-Lake/Wetland\"),K9,IF(OR(CONCATENATE($B9,\"-\",$C9)=\"Northeast-Lake/Wetland\",CONCATENATE($B9,\"-\",$C9)=\"Big Bend-Lake/Wetland\"),J9,IF(CONCATENATE($B9,\"-\",$C9)=\"Panhandle West-Lake/Wetland\",L9,IF(OR(CONCATENATE($B9,\"-\",$C9)=\"Peninsula-Stream/Canal\",CONCATENATE($B9,\"-\",$C9)=\"Everglades-Stream/Canal\"),H9,IF(OR(CONCATENATE($B9,\"-\",$C9)=\"Northeast-Stream/Canal\",CONCATENATE($B9,\"-\",$C9)=\"Big Bend-Stream/Canal\"),G9,IF(CONCATENATE($B9,\"-\",$C9)=\"Panhandle West-Stream/Canal\",I9,\"Error! Check Entries\"))))))))","v":""},null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807,null,"Marine"]
[4,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[5,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[6,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[7,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[8,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[9,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[10,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[11,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[12,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[13,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[14,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[15,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[16,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[17,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[18,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[19,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[20,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[21,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[22,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[23,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[24,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[25,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[26,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[27,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[28,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[29,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[30,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[31,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[32,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[33,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[34,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[35,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[36,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[37,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[38,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[39,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[40,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[41,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[42,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[43,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[44,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[45,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[46,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[47,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[48,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[49,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[50,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[51,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[52,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[53,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[54,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[55,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[56,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[57,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[58,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[59,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[60,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[61,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[62,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[63,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[64,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[65,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,{"$f":"1.45776613020539E-13*(HOUR($D71)*60+MINUTE($D71))^5-5.56072270585461E-10*(HOUR($D71)*60+MINUTE($D71))^4+7.06833400255548E-07*(HOUR($D71)*60+MINUTE($D71))^3-0.000318788465226261*(HOUR($D71)*60+MINUTE($D71))^2+0.0281711711660364*(HOUR($D71)*60+MINUTE($D71))+34.1911117699055","v":34.191111769905497},37.136025005027498,66.353590042897807]
[66,null,null,null,"",null,{"$f":"1.18443700433286E-13*(HOUR($D72)*60+MINUTE($D72))^5 - 4.14323598958596E-10*(HOUR($D72)*60+MINUTE($D72))^4 + 4.77287727122539E-07*(HOUR($D72)*60+MINUTE($D72))^3 - 0.000196917585728373*(HOUR($D72)*60+MINUTE($D72))^2 + 0.0231405627601475*(HOUR($D72)*60+MINUTE($D72)) + 31.2398283659495","v":31.239828365949499},{"$f":"1.98879987167155E-13*(HOUR($D72)*60+MINUTE($D72))^5 - 6.89410992615642E-10*(HOUR($D72)*60+MINUTE($D72))^4 + 7.83730333422071E-07*(HOUR($D72)*60+MINUTE($D72))^3 - 0.00031597890334556*(HOUR($D72)*60+MINUTE($D72))^2 + 0.0355135105918976*(HOUR($D72)*60+MINUTE($D72)) + 33.4327310978006","v":33.432731097800598},{"$f":"9.08511511657608E-14*(HOUR($D72)*60+MINUTE($D72))^5 - 2.99407211249053E-10*(HOUR($D72)*60+MINUTE($D72))^4 + 3.1560253348998E-07*(HOUR($D72)*60+MINUTE($D72))^3 - 0.000108510891323021*(HOUR($D72)*60+MINUTE($D72))^2 + 0.00628484730145829*(HOUR($D72)*60+MINUTE($D72)) + 65.6142372750764","v":65.614237275076405},34.191111769905497,{"$f":"1.37090283182826E-13*(HOUR($D72)*60+MINUTE($D72))^5 - 5.04960255463897E-10*(HOUR($D72)*60+MINUTE($D72))^4 + 6.13524315934422E-07*(HOUR($D72)*60+MINUTE($D72))^3 - 0.00025817433468811*(HOUR($D72)*60+MINUTE($D72))^2 + 0.0195966892410979*(HOUR($D72)*60+MINUTE($D72)) + 37.1360250050275","v":37.136025005027498},{"$f":"7.11895278892582E-14*(HOUR($D72)*60+MINUTE($D72))^5-2.64195273421019E-10*(HOUR($D72)*60+MINUTE($D72))^4 + 3.22473039456213E-07*(HOUR($D72)*60+MINUTE($D72))^3 - 0.00013606873481109*(HOUR($D72)*60+MINUTE($D72))^2 + 0.0107100719720847*(HOUR($D72)*60+MINUTE($D72))+66.3535900428978","v":66.353590042897807}]
[67,null,null,null,{"$f":"IF(OR(ISBLANK($B73),ISBLANK($C73),ISBLANK($D73)),\"\",IF($C73=\"Estuary/Marine\",\"Time of day Adjustment not appropriate for marine waters!\",IF(OR(CONCATENATE($B73,\"-\",$C73)=\"Peninsula-Lake/Wetland\",CONCATENATE($B73,\"-\",$C73)=\"Everglades-Lake/Wetland\"),K73,IF(OR(CONCATENATE($B73,\"-\",$C73)=\"Northeast-Lake/Wetland\",CONCATENATE($B73,\"-\",$C73)=\"Big Bend-Lake/Wetland\"),J73,IF(CONCATENATE($B73,\"-\",$C73)=\"Panhandle West-Lake/Wetland\",L73,IF(OR(CONCATENATE($B73,\"-\",$C73)=\"Peninsula-Stream/Canal\",CONCATENATE($B73,\"-\",$C73)=\"Everglades-Stream/Canal\"),H73,IF(OR(CONCATENATE($B73,\"-\",$C73)=\"Northeast-Stream/Canal\",CONCATENATE($B73,\"-\",$C73)=\"Big Bend-Stream/Canal\"),G73,IF(CONCATENATE($B73,\"-\",$C73)=\"Panhandle West-Stream/Canal\",I73,\"Error! Check Entries\"))))))))","v":""},null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[68,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[69,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[70,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[71,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[72,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[73,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[74,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[75,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[76,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[77,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[78,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[79,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[80,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[81,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[82,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[83,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[84,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[85,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[86,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[87,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[88,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[89,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[90,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[91,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[92,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[93,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[94,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[95,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[96,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[97,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[98,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[99,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[100,null,null,null,"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]

{"sheet":"Time of Day Interpret & Assess","index":3,"n_rows":106,"n_cols":17,"rows_kept":106,"cut":false,"hidden":false,"merged":[[4,8,4,10],[4,11,4,13],[4,1,5,1],[4,6,5,6],[0,0,0,6],[1,0,1,6],[3,0,3,6],[4,0,5,0],[4,2,5,2],[4,5,5,5],[2,0,2,6]]}
["Time-of-Day Interpreter for Florida's Freshwater DO Criteria! "]
["To use: 1) Enter measured % DO Saturation (i.e., from instantaneous measurement, not daily average calculated from diel data)   2) Choose SCI Bioregion and Waterbody Type from Drop-down lists.  3) Then enter local time that the DO saturation measurement was taken in 24 hour format (e.g., 16:10). \nNote: The time-of-day interpretion is only applicable for freshwaters!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bioregions","Waterbody Type"]
["Unshaded (white) fields (Columns A - E) are for data entry.       Additional notes are embedded as comments in the heading for each column, please review!"]
["Yellow shaded cells (Columns F and G) are the result fields and are protected from change.                            Do Not Attempt to Change These Fields!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Bend","Stream/Canal"]
["Sample","Measured DO Saturation, %","SCI-2012 Bioregion","Waterbody Type","Time-of-day Sample Collected (local time)","Time-of-day Interpretation of Criteria, %","DO Saturation Criteria Achieved",null,"Streams",null,null,"Lakes",null,null,null,"Everglades","Lake/Wetland"]
[null,null,null,"(e.g., Lake or Stream)","(24 hr format, 23:15)",null,null,null,"Northeast + Big Bend","Peninsula + Everglades","Panhandle West","Northeast + Big Bend","Peninsula + Everglades","Panhandle West",null,"Northeast","Estuary/Marine"]
[1,38.85,"Peninsula","Lake/Wetland","16:44:00",{"$f":"IF(AND(ISBLANK($B7),ISBLANK($C7),ISBLANK($D7),ISBLANK($E7)),\"\",IF(OR(ISBLANK($B7),ISBLANK($C7),ISBLANK($D7),ISBLANK($E7)),\"Enter all required values\",IF($D7=\"Estuary/Marine\",\"Time of day Adjustment not appropriate for marine waters!\",IF(OR(CONCATENATE($C7,\"-\",$D7)=\"Peninsula-Lake/Wetland\",CONCATENATE($C7,\"-\",$D7)=\"Everglades-Lake/Wetland\"),M7,IF(OR(CONCATENATE($C7,\"-\",$D7)=\"Northeast-Lake/Wetland\",CONCATENATE($C7,\"-\",$D7)=\"Big Bend-Lake/Wetland\"),L7,IF(CONCATENATE($C7,\"-\",$D7)=\"Panhandle West-Lake/Wetland\",N7,IF(OR(CONCATENATE($C7,\"-\",$D7)=\"Peninsula-Stream/Canal\",CONCATENATE($C7,\"-\",$D7)=\"Everglades-Stream/Canal\"),J7,IF(OR(CONCATENATE($C7,\"-\",$D7)=\"Northeast-Stream/Canal\",CONCATENATE($C7,\"-\",$D7)=\"Big Bend-Stream/Canal\"),I7,IF(CONCATENATE($C7,\"-\",$D7)=\"Panhandle West-Stream/Canal\",K7,\"Error! Check Entries\")))))))))","v":44.249223076725798},{"$f":"IF(AND(ISBLANK(B7),NOT(ISNUMBER(F7))),\"\",IF(ISBLANK(B7),\"Measured DO Saturation Not entered!\",IF(ISNUMBER(F7),IF(B7<F7,\"No\",\"Yes\"),\"Enter all required values!\")))","v":"No"},null,{"$f":"1.18443700433286E-13*(HOUR($E7)*60+MINUTE($E7))^5 - 4.14323598958596E-10*(HOUR($E7)*60+MINUTE($E7))^4 + 4.77287727122539E-07*(HOUR($E7)*60+MINUTE($E7))^3 - 0.000196917585728373*(HOUR($E7)*60+MINUTE($E7))^2 + 0.0231405627601475*(HOUR($E7)*60+MINUTE($E7)) + 31.2398283659495","v":38.853940096268715},{"$f":"1.98879987167155E-13*(HOUR($E7)*60+MINUTE($E7))^5 - 6.89410992615642E-10*(HOUR($E7)*60+MINUTE($E7))^4 + 7.83730333422071E-07*(HOUR($E7)*60+MINUTE($E7))^3 - 0.00031597890334556*(HOUR($E7)*60+MINUTE($E7))^2 + 0.0355135105918976*(HOUR($E7)*60+MINUTE($E7)) + 33.4327310978006","v":46.130878763089257},{"$f":"9.08511511657608E-14*(HOUR($E7)*60+MINUTE($E7))^5 - 2.99407211249053E-10*(HOUR($E7)*60+MINUTE($E7))^4 + 3.1560253348998E-07*(HOUR($E7)*60+MINUTE($E7))^3 - 0.000108510891323021*(HOUR($E7)*60+MINUTE($E7))^2 + 0.00628484730145829*(HOUR($E7)*60+MINUTE($E7)) + 65.6142372750764","v":70.404664538073305},{"$f":"1.45776613020539E-13*(HOUR($E7)*60+MINUTE($E7))^5-5.56072270585461E-10*(HOUR($E7)*60+MINUTE($E7))^4+7.06833400255548E-07*(HOUR($E7)*60+MINUTE($E7))^3-0.000318788465226261*(HOUR($E7)*60+MINUTE($E7))^2+0.0281711711660364*(HOUR($E7)*60+MINUTE($E7))+34.1911117699055","v":40.173079029404342},{"$f":"1.37090283182826E-13*(HOUR($E7)*60+MINUTE($E7))^5 - 5.04960255463897E-10*(HOUR($E7)*60+MINUTE($E7))^4 + 6.13524315934422E-07*(HOUR($E7)*60+MINUTE($E7))^3 - 0.00025817433468811*(HOUR($E7)*60+MINUTE($E7))^2 + 0.0195966892410979*(HOUR($E7)*60+MINUTE($E7)) + 37.1360250050275","v":44.249223076725798},{"$f":"7.11895278892582E-14*(HOUR($E7)*60+MINUTE($E7))^5-2.64195273421019E-10*(HOUR($E7)*60+MINUTE($E7))^4 + 3.22473039456213E-07*(HOUR($E7)*60+MINUTE($E7))^3 - 0.00013606873481109*(HOUR($E7)*60+MINUTE($E7))^2 + 0.0107100719720847*(HOUR($E7)*60+MINUTE($E7))+66.3535900428978","v":70.482181967762401},null,"Panhandle West"]
[2,44.2,"Northeast","Stream/Canal","11:11:00",{"$f":"IF(AND(ISBLANK($B8),ISBLANK($C8),ISBLANK($D8),ISBLANK($E8)),\"\",IF(OR(ISBLANK($B8),ISBLANK($C8),ISBLANK($D8),ISBLANK($E8)),\"Enter all required values\",IF($D8=\"Estuary/Marine\",\"Time of day Adjustment not appropriate for marine waters!\",IF(OR(CONCATENATE($C8,\"-\",$D8)=\"Peninsula-Lake/Wetland\",CONCATENATE($C8,\"-\",$D8)=\"Everglades-Lake/Wetland\"),M8,IF(OR(CONCATENATE($C8,\"-\",$D8)=\"Northeast-Lake/Wetland\",CONCATENATE($C8,\"-\",$D8)=\"Big Bend-Lake/Wetland\"),L8,IF(CONCATENATE($C8,\"-\",$D8)=\"Panhandle West-Lake/Wetland\",N8,IF(OR(CONCATENATE($C8,\"-\",$D8)=\"Peninsula-Stream/Canal\",CONCATENATE($C8,\"-\",$D8)=\"Everglades-Stream/Canal\"),J8,IF(OR(CONCATENATE($C8,\"-\",$D8)=\"Northeast-Stream/Canal\",CONCATENATE($C8,\"-\",$D8)=\"Big Bend-Stream/Canal\"),I8,IF(CONCATENATE($C8,\"-\",$D8)=\"Panhandle West-Stream/Canal\",K8,\"Error! Check Entries\")))))))))","v":34.421644306282673},{"$f":"IF(AND(ISBLANK(B8),NOT(ISNUMBER(F8))),\"\",IF(ISBLANK(B8),\"Measured DO Saturation Not entered!\",IF(ISNUMBER(F8),IF(B8<F8,\"No\",\"Yes\"),\"Enter all required values!\")))","v":"Yes"},null,{"$f":"1.18443700433286E-13*(HOUR($E8)*60+MINUTE($E8))^5 - 4.14323598958596E-10*(HOUR($E8)*60+MINUTE($E8))^4 + 4.77287727122539E-07*(HOUR($E8)*60+MINUTE($E8))^3 - 0.000196917585728373*(HOUR($E8)*60+MINUTE($E8))^2 + 0.0231405627601475*(HOUR($E8)*60+MINUTE($E8)) + 31.2398283659495","v":34.421644306282673},{"$f":"1.98879987167155E-13*(HOUR($E8)*60+MINUTE($E8))^5 - 6.89410992615642E-10*(HOUR($E8)*60+MINUTE($E8))^4 + 7.83730333422071E-07*(HOUR($E8)*60+MINUTE($E8))^3 - 0.00031597890334556*(HOUR($E8)*60+MINUTE($E8))^2 + 0.0355135105918976*(HOUR($E8)*60+MINUTE($E8)) + 33.4327310978006","v":39.066720166422357},{"$f":"9.08511511657608E-14*(HOUR($E8)*60+MINUTE($E8))^5 - 2.99407211249053E-10*(HOUR($E8)*60+MINUTE($E8))^4 + 3.1560253348998E-07*(HOUR($E8)*60+MINUTE($E8))^3 - 0.000108510891323021*(HOUR($E8)*60+MINUTE($E8))^2 + 0.00628484730145829*(HOUR($E8)*60+MINUTE($E8)) + 65.6142372750764","v":67.985473191520057},30.208682757887964,{"$f":"1.37090283182826E-13*(HOUR($E8)*60+MINUTE($E8))^5 - 5.04960255463897E-10*(HOUR($E8)*60+MINUTE($E8))^4 + 6.13524315934422E-07*(HOUR($E8)*60+MINUTE($E8))^3 - 0.00025817433468811*(HOUR($E8)*60+MINUTE($E8))^2 + 0.0195966892410979*(HOUR($E8)*60+MINUTE($E8)) + 37.1360250050275","v":35.681049151112255},{"$f":"7.11895278892582E-14*(HOUR($E8)*60+MINUTE($E8))^5-2.64195273421019E-10*(HOUR($E8)*60+MINUTE($E8))^4 + 3.22473039456213E-07*(HOUR($E8)*60+MINUTE($E8))^3 - 0.00013606873481109*(HOUR($E8)*60+MINUTE($E8))^2 + 0.0107100719720847*(HOUR($E8)*60+MINUTE($E8))+66.3535900428978","v":65.825763407252651},null,"Peninsula"]
[3,null,null,null,null,{"$f":"IF(AND(ISBLANK($B9),ISBLANK($C9),ISBLANK($D9),ISBLANK($E9)),\"\",IF(OR(ISBLANK($B9),ISBLANK($C9),ISBLANK($D9),ISBLANK($E9)),\"Enter all required values\",IF($D9=\"Estuary/Marine\",\"Time of day Adjustment not appropriate for marine waters!\",IF(OR(CONCATENATE($C9,\"-\",$D9)=\"Peninsula-Lake/Wetland\",CONCATENATE($C9,\"-\",$D9)=\"Everglades-Lake/Wetland\"),M9,IF(OR(CONCATENATE($C9,\"-\",$D9)=\"Northeast-Lake/Wetland\",CONCATENATE($C9,\"-\",$D9)=\"Big Bend-Lake/Wetland\"),L9,IF(CONCATENATE($C9,\"-\",$D9)=\"Panhandle West-Lake/Wetland\",N9,IF(OR(CONCATENATE($C9,\"-\",$D9)=\"Peninsula-Stream/Canal\",CONCATENATE($C9,\"-\",$D9)=\"Everglades-Stream/Canal\"),J9,IF(OR(CONCATENATE($C9,\"-\",$D9)=\"Northeast-Stream/Canal\",CONCATENATE($C9,\"-\",$D9)=\"Big Bend-Stream/Canal\"),I9,IF(CONCATENATE($C9,\"-\",$D9)=\"Panhandle West-Stream/Canal\",K9,\"Error! Check Entries\")))))))))","v":""},"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807,null,"Marine"]
[4,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[5,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[6,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[7,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[8,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[9,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[10,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[11,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[12,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[13,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[14,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[15,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[16,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[17,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[18,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[19,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[20,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[21,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[22,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[23,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[24,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[25,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[26,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[27,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[28,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[29,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[30,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[31,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[32,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[33,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[34,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[35,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[36,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[37,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[38,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[39,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[40,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[41,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[42,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[43,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[44,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[45,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[46,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[47,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[48,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[49,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[50,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[51,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[52,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[53,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[54,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[55,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[56,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[57,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[58,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[59,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[60,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[61,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[62,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[63,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[64,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[65,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,{"$f":"1.45776613020539E-13*(HOUR($E71)*60+MINUTE($E71))^5-5.56072270585461E-10*(HOUR($E71)*60+MINUTE($E71))^4+7.06833400255548E-07*(HOUR($E71)*60+MINUTE($E71))^3-0.000318788465226261*(HOUR($E71)*60+MINUTE($E71))^2+0.0281711711660364*(HOUR($E71)*60+MINUTE($E71))+34.1911117699055","v":34.191111769905497},37.136025005027498,66.353590042897807]
[66,null,null,null,null,"",{"$f":"IF(AND(ISBLANK(B72),NOT(ISNUMBER(F72))),\"\",IF(ISBLANK(B72),\"Measured DO Saturation Not entered!\",IF(ISNUMBER(F72),IF(B72<F72,\"No\",\"Yes\"),\"Enter all required values!\")))","v":""},null,{"$f":"1.18443700433286E-13*(HOUR($E72)*60+MINUTE($E72))^5 - 4.14323598958596E-10*(HOUR($E72)*60+MINUTE($E72))^4 + 4.77287727122539E-07*(HOUR($E72)*60+MINUTE($E72))^3 - 0.000196917585728373*(HOUR($E72)*60+MINUTE($E72))^2 + 0.0231405627601475*(HOUR($E72)*60+MINUTE($E72)) + 31.2398283659495","v":31.239828365949499},{"$f":"1.98879987167155E-13*(HOUR($E72)*60+MINUTE($E72))^5 - 6.89410992615642E-10*(HOUR($E72)*60+MINUTE($E72))^4 + 7.83730333422071E-07*(HOUR($E72)*60+MINUTE($E72))^3 - 0.00031597890334556*(HOUR($E72)*60+MINUTE($E72))^2 + 0.0355135105918976*(HOUR($E72)*60+MINUTE($E72)) + 33.4327310978006","v":33.432731097800598},{"$f":"9.08511511657608E-14*(HOUR($E72)*60+MINUTE($E72))^5 - 2.99407211249053E-10*(HOUR($E72)*60+MINUTE($E72))^4 + 3.1560253348998E-07*(HOUR($E72)*60+MINUTE($E72))^3 - 0.000108510891323021*(HOUR($E72)*60+MINUTE($E72))^2 + 0.00628484730145829*(HOUR($E72)*60+MINUTE($E72)) + 65.6142372750764","v":65.614237275076405},34.191111769905497,{"$f":"1.37090283182826E-13*(HOUR($E72)*60+MINUTE($E72))^5 - 5.04960255463897E-10*(HOUR($E72)*60+MINUTE($E72))^4 + 6.13524315934422E-07*(HOUR($E72)*60+MINUTE($E72))^3 - 0.00025817433468811*(HOUR($E72)*60+MINUTE($E72))^2 + 0.0195966892410979*(HOUR($E72)*60+MINUTE($E72)) + 37.1360250050275","v":37.136025005027498},{"$f":"7.11895278892582E-14*(HOUR($E72)*60+MINUTE($E72))^5-2.64195273421019E-10*(HOUR($E72)*60+MINUTE($E72))^4 + 3.22473039456213E-07*(HOUR($E72)*60+MINUTE($E72))^3 - 0.00013606873481109*(HOUR($E72)*60+MINUTE($E72))^2 + 0.0107100719720847*(HOUR($E72)*60+MINUTE($E72))+66.3535900428978","v":66.353590042897807}]
[67,null,null,null,null,{"$f":"IF(AND(ISBLANK($B73),ISBLANK($C73),ISBLANK($D73),ISBLANK($E73)),\"\",IF(OR(ISBLANK($B73),ISBLANK($C73),ISBLANK($D73),ISBLANK($E73)),\"Enter all required values\",IF($D73=\"Estuary/Marine\",\"Time of day Adjustment not appropriate for marine waters!\",IF(OR(CONCATENATE($C73,\"-\",$D73)=\"Peninsula-Lake/Wetland\",CONCATENATE($C73,\"-\",$D73)=\"Everglades-Lake/Wetland\"),M73,IF(OR(CONCATENATE($C73,\"-\",$D73)=\"Northeast-Lake/Wetland\",CONCATENATE($C73,\"-\",$D73)=\"Big Bend-Lake/Wetland\"),L73,IF(CONCATENATE($C73,\"-\",$D73)=\"Panhandle West-Lake/Wetland\",N73,IF(OR(CONCATENATE($C73,\"-\",$D73)=\"Peninsula-Stream/Canal\",CONCATENATE($C73,\"-\",$D73)=\"Everglades-Stream/Canal\"),J73,IF(OR(CONCATENATE($C73,\"-\",$D73)=\"Northeast-Stream/Canal\",CONCATENATE($C73,\"-\",$D73)=\"Big Bend-Stream/Canal\"),I73,IF(CONCATENATE($C73,\"-\",$D73)=\"Panhandle West-Stream/Canal\",K73,\"Error! Check Entries\")))))))))","v":""},"",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[68,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[69,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[70,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[71,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[72,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[73,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[74,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[75,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[76,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[77,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[78,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[79,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[80,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[81,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[82,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[83,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[84,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[85,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[86,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[87,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[88,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[89,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[90,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[91,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[92,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[93,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[94,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[95,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[96,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[97,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[98,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[99,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[100,null,null,null,null,"","",null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]

{"sheet":"Combined DO Sat and Criteria","index":4,"n_rows":105,"n_cols":25,"rows_kept":105,"cut":false,"hidden":false,"merged":[[3,16,3,18],[3,19,3,21],[0,0,0,12],[1,1,1,12],[2,0,2,12],[3,0,3,12]]}
["Dissolved Oxygen Percent Saturation and Applicable DO Criteria Calculator"]
["To use: ","1) Press \"Clear Entries\" button on right to remove all old data entries.  2) Choose SCI Bioregion and waterbody type from Drop-down lists.  3) Enter local time at which DO measurement was taken in 24 hour format (e.g., 16:10).  4) Enter measured DO concentration in mg/L and Water Temperature in °C (DO concentration and water temperature are always required).  5) Then enter Salinity (ppt)/Specific Conductance measurement in µmhos/cm if available (salinity or conductivity is required for estuarine/marine waters, and is optional for freshwaters) (Note: Calculation preferentially uses salinity.  If salinity data is not available then leave salinity blank and enter conductivity and it will be used.  If neither salinity or conductivity data are entered then a salinity of zero is assumed.)   6) Entry of Barometric Pressure is optional and should generally be left blank (if blank, 1 atmosphere (i.e., 760 mm Hg) is assumed).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bioregions","Waterbody Type"]
["White fields (Columns A - I) are for data entry.                          Additional notes are embedded as comments in the heading for each column, please review before using!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Bend","Stream/Canal"]
["Shaded fields (Columns J - M) are results fields and are protected from change.                                                Do Not Attempt to Change These Fields!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Streams",null,null,"Lakes",null,null,null,"Everglades","Lake/Wetland"]
["Site ID","SCI-2012 Bioregion","Waterbody Type (e.g., Lake or Stream)","Time-of-day Sample Collected (local time, 23:15)","Measured DO Concentration, mg/L","Measured Water Temperature (°C)","Measured Salinity (ppt) (Salinity = 1.80655*Chlorinity = 1.0045 Chloride)","Measured Specific Conductance (μS/cm)","Barometric Pressure (mm Hg) (1 atm = 760 mm Hg)","DO Concentration (mg/L) at 100% Saturation","DO Percent Saturation for Given DO Concentration","Applicable DO Criteria","Comments/Error Message","Final Barometric Pressure","Final Salinity",null,"Northeast + Big Bend","Peninsula + Everglades","Panhandle West","Northeast + Big Bend","Peninsula + Everglades","Panhandle West",null,"Northeast","Estuary/Marine"]
[1,"Northeast","Lake/Wetland","12:45:00",4.2,20,null,566,null,{"$f":"IF(OR(ISBLANK($E6),ISBLANK($F6)),\"\",(EXP((-139.34411+(157570.1/($F6+273.15)-(66423080/($F6+273.15)^2)+(12438000000/($F6+273.15)^3)-(862194900000/($F6+273.15)^4))-($O6*(0.017674-(10.754/($F6+273.15))+(2140.7/($F6+273.15)^2))))))*($N6/760)*((1-((EXP(11.8581-(3840.7/($F6+273.15))-(216961/($F6+273.15)^2)))/($N6/760)))*(1-(0.000975-(0.00001426*$F6)+(0.00000006436*$F6^2))*($N6/760)))/((1-(EXP(11.8581-(3840.7/($F6+273.15))-(216961/($F6+273.15)^2))))*(1-(0.000975-(0.00001426*$F6)+(0.00000006436*$F6^2)))))","v":9.0777066402724316},{"$f":"IF(OR(ISBLANK(E6),ISBLANK(F6)),\"\",E6/J6*100)","v":46.267192435665159},{"$f":"IF(AND(ISBLANK($B6),ISBLANK($C6),ISBLANK($D6)),\"\",IF(OR(ISBLANK($B6),ISBLANK($C6),ISBLANK($D6)),\"Must Enter All Required Data\",IF($O6>2.7,42,IF(AND($O6=0,OR($B6=\"Marine\",$C6=\"Estuary/Marine\")),42,IF(OR(CONCATENATE($B6,\"-\",$C6)=\"Peninsula-Lake/Wetland\",CONCATENATE($B6,\"-\",$C6)=\"Everglades-Lake/Wetland\"),U6,IF(OR(CONCATENATE($B6,\"-\",$C6)=\"Northeast-Lake/Wetland\",CONCATENATE($B6,\"-\",$C6)=\"Big Bend-Lake/Wetland\"),T6,IF(CONCATENATE($B6,\"-\",$C6)=\"Panhandle West-Lake/Wetland\",V6,IF(OR(CONCATENATE($B6,\"-\",$C6)=\"Peninsula-Stream/Canal\",CONCATENATE($B6,\"-\",$C6)=\"Everglades-Stream/Canal\"),R6,IF(OR(CONCATENATE($B6,\"-\",$C6)=\"Northeast-Stream/Canal\",CONCATENATE($B6,\"-\",$C6)=\"Big Bend-Stream/Canal\"),Q6,IF(CONCATENATE($B6,\"-\",$C6)=\"Panhandle West-Stream/Canal\",S6,\"Error! Check Entries\"))))))))))","v":33.372102435936718},{"$f":"IF(O6>2.7,\"Marine Criteria Apply, No time of day adjustment.\",IF(AND(O6=0,OR(B6=\"Marine\",C6=\"Estuary/Marine\")),\"Marine Criteria Apply, No time of day adjustment.\",IF(AND($O6<=2.7,OR($B6=\"Marine\",$C6=\"Estuary/Marine\")),\"Salinity and Bioregion or Waterbody Type Don't Agree\",\"\")))","v":""},{"$f":"IF(ISBLANK(I6),760,I6)","v":760},{"$f":"IF(AND(ISBLANK($G6),ISBLANK($H6)),0,IF(ISBLANK($G6),IF($H6=0,0,(0.008-(0.1692*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))^0.5)+(25.3851*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4))))+(14.0941*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))^1.5)-(7.0261*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))^2)+(2.7081*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))^2.5)+(($F6-15)/(1+0.0162*($F6-15))*(0.0005-0.0056*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))^0.5-0.0066*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))-0.0375*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))^1.5+0.0636*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))^2-0.0144*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4)))^2.5)))-(0.008/(1+(1.5*400*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4))))+(400*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4))))^2))-((0.0005*($F6-15)/(1+0.0162*($F6-15)))/(1+(100*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4))))^0.5+(100*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)/((1+(($N6/760*1.01325)*(0.000207-(0.0000000637*($N6/760*1.01325))+(0.000000000003989*($N6/760*1.01325)^2))/(1+(0.03426*$F6)+(0.0004464*$F6^2)+(0.4215-0.003107*$F6)*((($H6*(1+0.0191*($F6-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F6+0.0001104259*$F6^2-0.00000069698*$F6^3+0.0000000010031*$F6^4))))^1.5))),$G6))","v":0.27461355073475502},null,{"$f":"1.18443700433286E-13*(HOUR($D6)*60+MINUTE($D6))^5 - 4.14323598958596E-10*(HOUR($D6)*60+MINUTE($D6))^4 + 4.77287727122539E-07*(HOUR($D6)*60+MINUTE($D6))^3 - 0.000196917585728373*(HOUR($D6)*60+MINUTE($D6))^2 + 0.0231405627601475*(HOUR($D6)*60+MINUTE($D6)) + 31.2398283659495","v":36.513292670023446},{"$f":"1.98879987167155E-13*(HOUR($D6)*60+MINUTE($D6))^5 - 6.89410992615642E-10*(HOUR($D6)*60+MINUTE($D6))^4 + 7.83730333422071E-07*(HOUR($D6)*60+MINUTE($D6))^3 - 0.00031597890334556*(HOUR($D6)*60+MINUTE($D6))^2 + 0.0355135105918976*(HOUR($D6)*60+MINUTE($D6)) + 33.4327310978006","v":42.547693402822432},{"$f":"9.08511511657608E-14*(HOUR($D6)*60+MINUTE($D6))^5 - 2.99407211249053E-10*(HOUR($D6)*60+MINUTE($D6))^4 + 3.1560253348998E-07*(HOUR($D6)*60+MINUTE($D6))^3 - 0.000108510891323021*(HOUR($D6)*60+MINUTE($D6))^2 + 0.00628484730145829*(HOUR($D6)*60+MINUTE($D6)) + 65.6142372750764","v":69.473063121827337},{"$f":"1.45776613020539E-13*(HOUR($D6)*60+MINUTE($D6))^5-5.56072270585461E-10*(HOUR($D6)*60+MINUTE($D6))^4+7.06833400255548E-07*(HOUR($D6)*60+MINUTE($D6))^3-0.000318788465226261*(HOUR($D6)*60+MINUTE($D6))^2+0.0281711711660364*(HOUR($D6)*60+MINUTE($D6))+34.1911117699055","v":33.372102435936718},{"$f":"1.37090283182826E-13*(HOUR($D6)*60+MINUTE($D6))^5 - 5.04960255463897E-10*(HOUR($D6)*60+MINUTE($D6))^4 + 6.13524315934422E-07*(HOUR($D6)*60+MINUTE($D6))^3 - 0.00025817433468811*(HOUR($D6)*60+MINUTE($D6))^2 + 0.0195966892410979*(HOUR($D6)*60+MINUTE($D6)) + 37.1360250050275","v":38.685650702461579},{"$f":"7.11895278892582E-14*(HOUR($D6)*60+MINUTE($D6))^5-2.64195273421019E-10*(HOUR($D6)*60+MINUTE($D6))^4 + 3.22473039456213E-07*(HOUR($D6)*60+MINUTE($D6))^3 - 0.00013606873481109*(HOUR($D6)*60+MINUTE($D6))^2 + 0.0107100719720847*(HOUR($D6)*60+MINUTE($D6))+66.3535900428978","v":67.45434122741095},null,"Panhandle West"]
[2,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807,null,"Peninsula"]
[3,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807,null,"Marine"]
[4,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[5,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[6,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[7,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[8,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[9,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[10,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[11,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[12,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[13,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[14,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[15,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[16,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[17,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[18,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[19,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[20,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[21,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[22,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[23,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[24,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[25,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[26,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[27,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[28,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[29,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[30,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[31,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[32,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[33,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($E38),ISBLANK($F38)),\"\",(EXP((-139.34411+(157570.1/($F38+273.15)-(66423080/($F38+273.15)^2)+(12438000000/($F38+273.15)^3)-(862194900000/($F38+273.15)^4))-($O38*(0.017674-(10.754/($F38+273.15))+(2140.7/($F38+273.15)^2))))))*($N38/760)*((1-((EXP(11.8581-(3840.7/($F38+273.15))-(216961/($F38+273.15)^2)))/($N38/760)))*(1-(0.000975-(0.00001426*$F38)+(0.00000006436*$F38^2))*($N38/760)))/((1-(EXP(11.8581-(3840.7/($F38+273.15))-(216961/($F38+273.15)^2))))*(1-(0.000975-(0.00001426*$F38)+(0.00000006436*$F38^2)))))","v":""},{"$f":"IF(OR(ISBLANK(E38),ISBLANK(F38)),\"\",E38/J38*100)","v":""},{"$f":"IF(AND(ISBLANK($B38),ISBLANK($C38),ISBLANK($D38)),\"\",IF(OR(ISBLANK($B38),ISBLANK($C38),ISBLANK($D38)),\"Must Enter All Required Data\",IF($O38>2.7,42,IF(AND($O38=0,OR($B38=\"Marine\",$C38=\"Estuary/Marine\")),42,IF(OR(CONCATENATE($B38,\"-\",$C38)=\"Peninsula-Lake/Wetland\",CONCATENATE($B38,\"-\",$C38)=\"Everglades-Lake/Wetland\"),U38,IF(OR(CONCATENATE($B38,\"-\",$C38)=\"Northeast-Lake/Wetland\",CONCATENATE($B38,\"-\",$C38)=\"Big Bend-Lake/Wetland\"),T38,IF(CONCATENATE($B38,\"-\",$C38)=\"Panhandle West-Lake/Wetland\",V38,IF(OR(CONCATENATE($B38,\"-\",$C38)=\"Peninsula-Stream/Canal\",CONCATENATE($B38,\"-\",$C38)=\"Everglades-Stream/Canal\"),R38,IF(OR(CONCATENATE($B38,\"-\",$C38)=\"Northeast-Stream/Canal\",CONCATENATE($B38,\"-\",$C38)=\"Big Bend-Stream/Canal\"),Q38,IF(CONCATENATE($B38,\"-\",$C38)=\"Panhandle West-Stream/Canal\",S38,\"Error! Check Entries\"))))))))))","v":""},{"$f":"IF(O38>2.7,\"Marine Criteria Apply, No time of day adjustment.\",IF(AND(O38=0,OR(B38=\"Marine\",C38=\"Estuary/Marine\")),\"Marine Criteria Apply, No time of day adjustment.\",IF(AND($O38<=2.7,OR($B38=\"Marine\",$C38=\"Estuary/Marine\")),\"Salinity and Bioregion or Waterbody Type Don't Agree\",\"\")))","v":""},{"$f":"IF(ISBLANK(I38),760,I38)","v":760},{"$f":"IF(AND(ISBLANK($G38),ISBLANK($H38)),0,IF(ISBLANK($G38),IF($H38=0,0,(0.008-(0.1692*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))^0.5)+(25.3851*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4))))+(14.0941*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))^1.5)-(7.0261*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))^2)+(2.7081*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))^2.5)+(($F38-15)/(1+0.0162*($F38-15))*(0.0005-0.0056*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))^0.5-0.0066*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))-0.0375*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))^1.5+0.0636*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))^2-0.0144*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4)))^2.5)))-(0.008/(1+(1.5*400*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4))))+(400*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4))))^2))-((0.0005*($F38-15)/(1+0.0162*($F38-15)))/(1+(100*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4))))^0.5+(100*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)/((1+(($N38/760*1.01325)*(0.000207-(0.0000000637*($N38/760*1.01325))+(0.000000000003989*($N38/760*1.01325)^2))/(1+(0.03426*$F38)+(0.0004464*$F38^2)+(0.4215-0.003107*$F38)*((($H38*(1+0.0191*($F38-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F38+0.0001104259*$F38^2-0.00000069698*$F38^3+0.0000000010031*$F38^4))))^1.5))),$G38))","v":0},null,{"$f":"1.18443700433286E-13*(HOUR($D38)*60+MINUTE($D38))^5 - 4.14323598958596E-10*(HOUR($D38)*60+MINUTE($D38))^4 + 4.77287727122539E-07*(HOUR($D38)*60+MINUTE($D38))^3 - 0.000196917585728373*(HOUR($D38)*60+MINUTE($D38))^2 + 0.0231405627601475*(HOUR($D38)*60+MINUTE($D38)) + 31.2398283659495","v":31.239828365949499},{"$f":"1.98879987167155E-13*(HOUR($D38)*60+MINUTE($D38))^5 - 6.89410992615642E-10*(HOUR($D38)*60+MINUTE($D38))^4 + 7.83730333422071E-07*(HOUR($D38)*60+MINUTE($D38))^3 - 0.00031597890334556*(HOUR($D38)*60+MINUTE($D38))^2 + 0.0355135105918976*(HOUR($D38)*60+MINUTE($D38)) + 33.4327310978006","v":33.432731097800598},{"$f":"9.08511511657608E-14*(HOUR($D38)*60+MINUTE($D38))^5 - 2.99407211249053E-10*(HOUR($D38)*60+MINUTE($D38))^4 + 3.1560253348998E-07*(HOUR($D38)*60+MINUTE($D38))^3 - 0.000108510891323021*(HOUR($D38)*60+MINUTE($D38))^2 + 0.00628484730145829*(HOUR($D38)*60+MINUTE($D38)) + 65.6142372750764","v":65.614237275076405},{"$f":"1.45776613020539E-13*(HOUR($D38)*60+MINUTE($D38))^5-5.56072270585461E-10*(HOUR($D38)*60+MINUTE($D38))^4+7.06833400255548E-07*(HOUR($D38)*60+MINUTE($D38))^3-0.000318788465226261*(HOUR($D38)*60+MINUTE($D38))^2+0.0281711711660364*(HOUR($D38)*60+MINUTE($D38))+34.1911117699055","v":34.191111769905497},{"$f":"1.37090283182826E-13*(HOUR($D38)*60+MINUTE($D38))^5 - 5.04960255463897E-10*(HOUR($D38)*60+MINUTE($D38))^4 + 6.13524315934422E-07*(HOUR($D38)*60+MINUTE($D38))^3 - 0.00025817433468811*(HOUR($D38)*60+MINUTE($D38))^2 + 0.0195966892410979*(HOUR($D38)*60+MINUTE($D38)) + 37.1360250050275","v":37.136025005027498},{"$f":"7.11895278892582E-14*(HOUR($D38)*60+MINUTE($D38))^5-2.64195273421019E-10*(HOUR($D38)*60+MINUTE($D38))^4 + 3.22473039456213E-07*(HOUR($D38)*60+MINUTE($D38))^3 - 0.00013606873481109*(HOUR($D38)*60+MINUTE($D38))^2 + 0.0107100719720847*(HOUR($D38)*60+MINUTE($D38))+66.3535900428978","v":66.353590042897807}]
[34,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[35,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[36,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[37,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[38,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[39,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[40,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[41,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[42,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[43,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[44,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[45,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[46,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[47,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[48,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[49,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[50,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[51,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[52,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[53,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[54,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[55,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[56,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[57,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[58,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[59,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[60,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[61,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[62,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[63,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[64,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[65,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($E70),ISBLANK($F70)),\"\",(EXP((-139.34411+(157570.1/($F70+273.15)-(66423080/($F70+273.15)^2)+(12438000000/($F70+273.15)^3)-(862194900000/($F70+273.15)^4))-($O70*(0.017674-(10.754/($F70+273.15))+(2140.7/($F70+273.15)^2))))))*($N70/760)*((1-((EXP(11.8581-(3840.7/($F70+273.15))-(216961/($F70+273.15)^2)))/($N70/760)))*(1-(0.000975-(0.00001426*$F70)+(0.00000006436*$F70^2))*($N70/760)))/((1-(EXP(11.8581-(3840.7/($F70+273.15))-(216961/($F70+273.15)^2))))*(1-(0.000975-(0.00001426*$F70)+(0.00000006436*$F70^2)))))","v":""},{"$f":"IF(OR(ISBLANK(E70),ISBLANK(F70)),\"\",E70/J70*100)","v":""},{"$f":"IF(AND(ISBLANK($B70),ISBLANK($C70),ISBLANK($D70)),\"\",IF(OR(ISBLANK($B70),ISBLANK($C70),ISBLANK($D70)),\"Must Enter All Required Data\",IF($O70>2.7,42,IF(AND($O70=0,OR($B70=\"Marine\",$C70=\"Estuary/Marine\")),42,IF(OR(CONCATENATE($B70,\"-\",$C70)=\"Peninsula-Lake/Wetland\",CONCATENATE($B70,\"-\",$C70)=\"Everglades-Lake/Wetland\"),U70,IF(OR(CONCATENATE($B70,\"-\",$C70)=\"Northeast-Lake/Wetland\",CONCATENATE($B70,\"-\",$C70)=\"Big Bend-Lake/Wetland\"),T70,IF(CONCATENATE($B70,\"-\",$C70)=\"Panhandle West-Lake/Wetland\",V70,IF(OR(CONCATENATE($B70,\"-\",$C70)=\"Peninsula-Stream/Canal\",CONCATENATE($B70,\"-\",$C70)=\"Everglades-Stream/Canal\"),R70,IF(OR(CONCATENATE($B70,\"-\",$C70)=\"Northeast-Stream/Canal\",CONCATENATE($B70,\"-\",$C70)=\"Big Bend-Stream/Canal\"),Q70,IF(CONCATENATE($B70,\"-\",$C70)=\"Panhandle West-Stream/Canal\",S70,\"Error! Check Entries\"))))))))))","v":""},{"$f":"IF(O70>2.7,\"Marine Criteria Apply, No time of day adjustment.\",IF(AND(O70=0,OR(B70=\"Marine\",C70=\"Estuary/Marine\")),\"Marine Criteria Apply, No time of day adjustment.\",IF(AND($O70<=2.7,OR($B70=\"Marine\",$C70=\"Estuary/Marine\")),\"Salinity and Bioregion or Waterbody Type Don't Agree\",\"\")))","v":""},{"$f":"IF(ISBLANK(I70),760,I70)","v":760},{"$f":"IF(AND(ISBLANK($G70),ISBLANK($H70)),0,IF(ISBLANK($G70),IF($H70=0,0,(0.008-(0.1692*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))^0.5)+(25.3851*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4))))+(14.0941*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))^1.5)-(7.0261*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))^2)+(2.7081*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))^2.5)+(($F70-15)/(1+0.0162*($F70-15))*(0.0005-0.0056*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))^0.5-0.0066*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))-0.0375*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))^1.5+0.0636*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))^2-0.0144*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4)))^2.5)))-(0.008/(1+(1.5*400*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4))))+(400*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4))))^2))-((0.0005*($F70-15)/(1+0.0162*($F70-15)))/(1+(100*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4))))^0.5+(100*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)/((1+(($N70/760*1.01325)*(0.000207-(0.0000000637*($N70/760*1.01325))+(0.000000000003989*($N70/760*1.01325)^2))/(1+(0.03426*$F70)+(0.0004464*$F70^2)+(0.4215-0.003107*$F70)*((($H70*(1+0.0191*($F70-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$F70+0.0001104259*$F70^2-0.00000069698*$F70^3+0.0000000010031*$F70^4))))^1.5))),$G70))","v":0},null,{"$f":"1.18443700433286E-13*(HOUR($D70)*60+MINUTE($D70))^5 - 4.14323598958596E-10*(HOUR($D70)*60+MINUTE($D70))^4 + 4.77287727122539E-07*(HOUR($D70)*60+MINUTE($D70))^3 - 0.000196917585728373*(HOUR($D70)*60+MINUTE($D70))^2 + 0.0231405627601475*(HOUR($D70)*60+MINUTE($D70)) + 31.2398283659495","v":31.239828365949499},{"$f":"1.98879987167155E-13*(HOUR($D70)*60+MINUTE($D70))^5 - 6.89410992615642E-10*(HOUR($D70)*60+MINUTE($D70))^4 + 7.83730333422071E-07*(HOUR($D70)*60+MINUTE($D70))^3 - 0.00031597890334556*(HOUR($D70)*60+MINUTE($D70))^2 + 0.0355135105918976*(HOUR($D70)*60+MINUTE($D70)) + 33.4327310978006","v":33.432731097800598},{"$f":"9.08511511657608E-14*(HOUR($D70)*60+MINUTE($D70))^5 - 2.99407211249053E-10*(HOUR($D70)*60+MINUTE($D70))^4 + 3.1560253348998E-07*(HOUR($D70)*60+MINUTE($D70))^3 - 0.000108510891323021*(HOUR($D70)*60+MINUTE($D70))^2 + 0.00628484730145829*(HOUR($D70)*60+MINUTE($D70)) + 65.6142372750764","v":65.614237275076405},{"$f":"1.45776613020539E-13*(HOUR($D70)*60+MINUTE($D70))^5-5.56072270585461E-10*(HOUR($D70)*60+MINUTE($D70))^4+7.06833400255548E-07*(HOUR($D70)*60+MINUTE($D70))^3-0.000318788465226261*(HOUR($D70)*60+MINUTE($D70))^2+0.0281711711660364*(HOUR($D70)*60+MINUTE($D70))+34.1911117699055","v":34.191111769905497},{"$f":"1.37090283182826E-13*(HOUR($D70)*60+MINUTE($D70))^5 - 5.04960255463897E-10*(HOUR($D70)*60+MINUTE($D70))^4 + 6.13524315934422E-07*(HOUR($D70)*60+MINUTE($D70))^3 - 0.00025817433468811*(HOUR($D70)*60+MINUTE($D70))^2 + 0.0195966892410979*(HOUR($D70)*60+MINUTE($D70)) + 37.1360250050275","v":37.136025005027498},{"$f":"7.11895278892582E-14*(HOUR($D70)*60+MINUTE($D70))^5-2.64195273421019E-10*(HOUR($D70)*60+MINUTE($D70))^4 + 3.22473039456213E-07*(HOUR($D70)*60+MINUTE($D70))^3 - 0.00013606873481109*(HOUR($D70)*60+MINUTE($D70))^2 + 0.0107100719720847*(HOUR($D70)*60+MINUTE($D70))+66.3535900428978","v":66.353590042897807}]
[66,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[67,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[68,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[69,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[70,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[71,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[72,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[73,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[74,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[75,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[76,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[77,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[78,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[79,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[80,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[81,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[82,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[83,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[84,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[85,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[86,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[87,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[88,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[89,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[90,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[91,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[92,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[93,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[94,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[95,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[96,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[97,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(E102),ISBLANK(F102)),\"\",E102/J102*100)","v":""},"","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[98,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[99,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]
[100,null,null,null,null,null,null,null,null,"","","","",760,0,null,31.239828365949499,33.432731097800598,65.614237275076405,34.191111769905497,37.136025005027498,66.353590042897807]