{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Read Me","TAN Criteria Calculator","30-Day Avg TAN Calculator","TAN SSAC Calculator","30-Day Avg TAN SSAC Calculator","Un-ionized Ammonia Calculator"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"comments":5,"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":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["History:  The previous freshwater un-ionized ammonia criteria of 0.02 mg/L was recently replaced by a Total Ammonia Nitrogen (TAN) criteria for freshwaters.  The new TAN criteria has been adopted by the Environmental Regulation Commission and became effective for state purposes on 2/17/2016.  Approval by the USEPA is pending and is expected by the end of 2016.  \n\nThe new TAN criteria were developed by the USEPA and finalized in 2013 with more details provided at their website https://www.epa.gov/wqc/aquatic-life-criteria-ammonia (use button below to go to USEPA website).  Similar to the un-ionized ammonia calculation, the TAN criteria are expressed as an equation dependent on the water pH and temperature.  The TAN criteria include both a 30-day criterion and a single sample criterion.\n\nAs stated in Chapter 62-302, F.A.C., \"The 30-day average TAN value shall not exceed the average of the values calculated from the following equation, with no single value exceeding 2.5 times the value from the equation:"]
[]
["where T and pH are defined as the paired temperature (°C) and pH associated with the TAN sample. For purposes of total ammonia nitrogen criterion calculations, pH is subject to the range of 6.5 to 9.0. If the measured pH entered is < 6.5 a value of 6.5 will be used in the calculation of the criteria and if the measured pH entered is > 9.0 a value of 9.0 will be used.  Additionally, if the temperature entered is less than 7°C a value of 7°C will be used in the calculation of the criteria."]
["Assessment of the 30-day criteria in ambient waters for Chapter 62-303, F.A.C. (IWR) purposes requires a minimum of four (4) independent samples collected at a station within a 30-day period.  To apply the 30-day average criterion, the applicable 30-day criterion will be calculated for each individual sample using the equation provided above.  The average of the TAN concentrations (mg/L) measured during the 30-day period will be compared to the average of the 30-day criteria calculated for each of the individual samples.  If the average of the measured TAN concentrations is less than or equal to the average of the criteria calculated for the individual samples, the 30-day TAN criterion is achieved."]
["In addition to the generally applicable TAN criteria described above, the USEPA also provided for the calculation of site specific alternative criteria (SSAC) values for waters in which the unionid musels are shown to be absent, but early life stage (ELS) protection is required.  The modified SSAC equation is provided below. The SSAC is applied in the same manner as described for the generally applicable criteria described above.   Note: The SSAC equation should only be used for waterbodies where unionid mussels have been shown to be absent, ELS Protection is Required, and a TAN SSAC has been adopted by FDEP and approved by the USEPA!  For all other waterbodies the generally applicable TAN criteria equation should be used."]
[]
["To aid in the application of the new TAN criteria, a series of calculators have been developed to perform the necessary calculations.  Specifically, this spreadsheet contains calculators for: 1) the single sample TAN criteria, 2) the 30-day average TAN criteria, and 3) un-ionized ammonia.  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 single sample TAN Criteria"]
["2)  Calculation of 30-day average TAN Criteria"]
["3)  Calculation of 30-day TAN SSAC"]
["4)  Calculation of 30-day average TAN SSAC"]
["5)  Calculation of un-ionized ammonia"]

{"sheet":"TAN Criteria Calculator","index":1,"n_rows":105,"n_cols":9,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[0,0,0,4]]}
["                          Total Ammonia Nitrogen (TAN) Criteria Calculator",null,null,null,null,"Developed by Garry Payne, DEP,       Sept. 2016"]
["To use:  1) Press \"Clear Entries\" button on right to remove all old data entries.  2) Enter measured TAN concentration in mg/L (optional), Water Temperature in °C, and pH in standard units.  3. Once all required data is entered, the applicable TAN criteria are calculated automatically."]
["Columns A - D (Unshaded) are for data entry.           Additional notes are embedded as comments in the heading for each column, please review!"]
["Columns E (shaded Green) and Column F (shaded Blue) are results fields and are protected from change.  Do Not Attempt to Change These Fields!"]
["Site ID","Measured Total Ammonia Nitrogen (TAN), mg/L","Measured Water Temperature, °C","Measured pH, Standard pH units","30-Day Average TAN Criteria Applicable to Individual Sample, mg/L","Applicable Single Sample TAN Criteria, mg/L",null,"Final pH","Final Temp"]
[1,0.5,33,7,{"$f":"IF(AND(ISBLANK(C6),ISBLANK(D6)),\"\",IF(OR(ISBLANK(C6),ISBLANK(D6)),\"Enter both Temp and pH\",(0.8876*((0.0278/(1+10^(7.688-H6)))+(1.1994/(1+10^(H6-7.688))))*2.126*10^(0.028*(20-(I6))))))","v":0.81616038891323395},{"$f":"IF(AND(ISBLANK(C6),ISBLANK(D6)),\"\",IF(OR(ISBLANK(C6),ISBLANK(D6)),\"Enter both Temp and pH\",(2.5*(0.8876*((0.0278/(1+10^(7.688-H6)))+(1.1994/(1+10^(H6-7.688))))*2.126*10^(0.028*(20-MAX(C6,7)))))))","v":2.0404009722830847},null,{"$f":"IF(ISBLANK(D6),\"\",IF(D6<6.5,6.5,IF(D6>9,9,D6)))","v":7},{"$f":"IF(ISBLANK(C6),\"\",IF(C6<7,7,C6))","v":33}]
[2,1.1000000000000001,22,7.5,{"$f":"IF(AND(ISBLANK(C7),ISBLANK(D7)),\"\",IF(OR(ISBLANK(C7),ISBLANK(D7)),\"Enter both Temp and pH\",(0.8876*((0.0278/(1+10^(7.688-H7)))+(1.1994/(1+10^(H7-7.688))))*2.126*10^(0.028*(20-MAX(C7,7))))))","v":1.2249007868969757},{"$f":"IF(AND(ISBLANK(C7),ISBLANK(D7)),\"\",IF(OR(ISBLANK(C7),ISBLANK(D7)),\"Enter both Temp and pH\",(2.5*(0.8876*((0.0278/(1+10^(7.688-H7)))+(1.1994/(1+10^(H7-7.688))))*2.126*10^(0.028*(20-MAX(C7,7)))))))","v":3.0622519672424393},null,{"$f":"IF(ISBLANK(D7),\"\",IF(D7<6.5,6.5,IF(D7>9,9,D7)))","v":7.5},{"$f":"IF(ISBLANK(C7),\"\",IF(C7<7,7,C7))","v":22}]
[3,2.2200000000000002,25,8.1999999999999993,{"$f":"IF(AND(ISBLANK(C8),ISBLANK(D8)),\"\",IF(OR(ISBLANK(C8),ISBLANK(D8)),\"Enter both Temp and pH\",(0.8876*((0.0278/(1+10^(7.688-H8)))+(1.1994/(1+10^(H8-7.688))))*2.126*10^(0.028*(20-MAX(C8,7))))))","v":0.41477840262501631},{"$f":"IF(AND(ISBLANK(C8),ISBLANK(D8)),\"\",IF(OR(ISBLANK(C8),ISBLANK(D8)),\"Enter both Temp and pH\",(2.5*(0.8876*((0.0278/(1+10^(7.688-H8)))+(1.1994/(1+10^(H8-7.688))))*2.126*10^(0.028*(20-MAX(C8,7)))))))","v":1.0369460065625407},null,8.1999999999999993,25]
[4,0.8,35,8.5,{"$f":"IF(AND(ISBLANK(C9),ISBLANK(D9)),\"\",IF(OR(ISBLANK(C9),ISBLANK(D9)),\"Enter both Temp and pH\",(0.8876*((0.0278/(1+10^(7.688-H9)))+(1.1994/(1+10^(H9-7.688))))*2.126*10^(0.028*(20-MAX(C9,7))))))","v":0.13222142459418562},{"$f":"IF(AND(ISBLANK(C9),ISBLANK(D9)),\"\",IF(OR(ISBLANK(C9),ISBLANK(D9)),\"Enter both Temp and pH\",(2.5*(0.8876*((0.0278/(1+10^(7.688-H9)))+(1.1994/(1+10^(H9-7.688))))*2.126*10^(0.028*(20-MAX(C9,7)))))))","v":0.33055356148546405},null,8.5,35]
[5,1.65,20,7.25,{"$f":"IF(AND(ISBLANK(C10),ISBLANK(D10)),\"\",IF(OR(ISBLANK(C10),ISBLANK(D10)),\"Enter both Temp and pH\",(0.8876*((0.0278/(1+10^(7.688-H10)))+(1.1994/(1+10^(H10-7.688))))*2.126*10^(0.028*(20-MAX(C10,7))))))","v":1.6724243701598265},{"$f":"IF(AND(ISBLANK(C10),ISBLANK(D10)),\"\",IF(OR(ISBLANK(C10),ISBLANK(D10)),\"Enter both Temp and pH\",(2.5*(0.8876*((0.0278/(1+10^(7.688-H10)))+(1.1994/(1+10^(H10-7.688))))*2.126*10^(0.028*(20-MAX(C10,7)))))))","v":4.1810609253995663},null,7.25,20]
[6,0.78,28,8.5,0.20763560711870269,0.51908901779675676,null,8.5,28]
[7,null,null,null,"","",null,"",""]
[8,null,null,null,"","",null,"",""]
[9,null,null,null,"","",null,"",""]
[10,null,null,null,"","",null,"",""]
[11,null,null,null,"","",null,"",""]
[12,null,null,null,"","",null,"",""]
[13,null,null,null,"","",null,"",""]
[14,null,null,null,"","",null,"",""]
[15,null,null,null,"","",null,"",""]
[16,null,null,null,"","",null,"",""]
[17,null,null,null,"","",null,"",""]
[18,null,null,null,"","",null,"",""]
[19,null,null,null,"","",null,"",""]
[20,null,null,null,"","",null,"",""]
[21,null,null,null,"","",null,"",""]
[22,null,null,null,"","",null,"",""]
[23,null,null,null,"","",null,"",""]
[24,null,null,null,"","",null,"",""]
[25,null,null,null,"","",null,"",""]
[26,null,null,null,"","",null,"",""]
[27,null,null,null,"","",null,"",""]
[28,null,null,null,"","",null,"",""]
[29,null,null,null,"","",null,"",""]
[30,null,null,null,"","",null,"",""]
[31,null,null,null,"","",null,"",""]
[32,null,null,null,"","",null,"",""]
[33,null,null,null,"","",null,"",""]
[34,null,null,null,"","",null,"",""]
[35,null,null,null,"","",null,"",""]
[36,null,null,null,"","",null,"",""]
[37,null,null,null,"","",null,"",""]
[38,null,null,null,"","",null,"",""]
[39,null,null,null,"","",null,"",""]
[40,null,null,null,"","",null,"",""]
[41,null,null,null,"","",null,"",""]
[42,null,null,null,"","",null,"",""]
[43,null,null,null,"","",null,"",""]
[44,null,null,null,"","",null,"",""]
[45,null,null,null,"","",null,"",""]
[46,null,null,null,"","",null,"",""]
[47,null,null,null,"","",null,"",""]
[48,null,null,null,"","",null,"",""]
[49,null,null,null,"","",null,"",""]
[50,null,null,null,"","",null,"",""]
[51,null,null,null,"","",null,"",""]
[52,null,null,null,"","",null,"",""]
[53,null,null,null,"","",null,"",""]
[54,null,null,null,"","",null,"",""]
[55,null,null,null,"","",null,"",""]
[56,null,null,null,"","",null,"",""]
[57,null,null,null,"","",null,"",""]
[58,null,null,null,"","",null,"",""]
[59,null,null,null,"","",null,"",""]
[60,null,null,null,"","",null,"",""]
[61,null,null,null,"","",null,"",""]
[62,null,null,null,"","",null,"",""]
[63,null,null,null,"","",null,"",""]
[64,null,null,null,"","",null,"",""]
[65,null,null,null,"","",null,"",""]
[66,null,null,null,{"$f":"IF(AND(ISBLANK(C71),ISBLANK(D71)),\"\",IF(OR(ISBLANK(C71),ISBLANK(D71)),\"Enter both Temp and pH\",(0.8876*((0.0278/(1+10^(7.688-H71)))+(1.1994/(1+10^(H71-7.688))))*2.126*10^(0.028*(20-MAX(C71,7))))))","v":""},"",null,{"$f":"IF(ISBLANK(D71),\"\",IF(D71<6.5,6.5,IF(D71>9,9,D71)))","v":""},{"$f":"IF(ISBLANK(C71),\"\",IF(C71<7,7,C71))","v":""}]
[67,null,null,null,"","",null,"",""]
[68,null,null,null,"",{"$f":"IF(AND(ISBLANK(C73),ISBLANK(D73)),\"\",IF(OR(ISBLANK(C73),ISBLANK(D73)),\"Enter both Temp and pH\",(2.5*(0.8876*((0.0278/(1+10^(7.688-H73)))+(1.1994/(1+10^(H73-7.688))))*2.126*10^(0.028*(20-MAX(C73,7)))))))","v":""},null,"",""]
[69,null,null,null,"","",null,"",""]
[70,null,null,null,"","",null,"",""]
[71,null,null,null,"","",null,"",""]
[72,null,null,null,"","",null,"",""]
[73,null,null,null,"","",null,"",""]
[74,null,null,null,"","",null,"",""]
[75,null,null,null,"","",null,"",""]
[76,null,null,null,"","",null,"",""]
[77,null,null,null,"","",null,"",""]
[78,null,null,null,"","",null,"",""]
[79,null,null,null,"","",null,"",""]
[80,null,null,null,"","",null,"",""]
[81,null,null,null,"","",null,"",""]
[82,null,null,null,"","",null,"",""]
[83,null,null,null,"","",null,"",""]
[84,null,null,null,"","",null,"",""]
[85,null,null,null,"","",null,"",""]
[86,null,null,null,"","",null,"",""]
[87,null,null,null,"","",null,"",""]
[88,null,null,null,"","",null,"",""]
[89,null,null,null,"","",null,"",""]
[90,null,null,null,"","",null,"",""]
[91,null,null,null,"","",null,"",""]
[92,null,null,null,"","",null,"",""]
[93,null,null,null,"","",null,"",""]
[94,null,null,null,"","",null,"",""]
[95,null,null,null,"","",null,"",""]
[96,null,null,null,"","",null,"",""]
[97,null,null,null,"","",null,"",""]
[98,null,null,null,"","",null,"",""]
[99,null,null,null,"","",null,"",""]
[100,null,null,null,"","",null,"",""]

{"sheet":"30-Day Avg TAN Calculator","index":2,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[[3,0,3,10],[2,0,2,10],[0,0,0,9],[1,0,1,10],[6,8,6,10]]}
["    30-Day Average Total Ammonia Nitrogen (TAN) Criteria Calculator",null,null,null,null,null,null,null,null,null,"Developed by Garry Payne, DEP, Sept. 2016"]
["To use:  1) Press \"Clear Entries\" button on right to remove all old data entries.  2) Enter Station ID in first cell (i.e., cell A6) (all data entered should be for the same station collected within the same 30-day period).  3) Enter measured TAN concentrations in mg/L collected at specified station during the same 30-day period.  Enter water temperature (in °C) and pH (in standard units) measured at time of TAN sample collection.  A minimum of 4 samples are required to calculate 30-day average TAN criteria for IWR purposes (Chapter 62-303, F.A.C.)  4) Once all required data are entered, the applicable TAN criteria (green and blue columns) and the averages of the measured TAN and the 30-day TAN criteria (red columns) are calculated automatically and achievement of the 30-day TAN criteria is assessed."]
["Columns C - E (Unshaded) are for data entry.                                 Additional notes are embedded as comments in the heading for each column, please review!"]
["Columns A and B (except Cell A6) (shaded Gray) are filled in automatically.  Columns F - I (shaded Green, Blue, and Red) are results fields and are protected from change.                                  Do Not Attempt to Change These Fields!"]
["Station ID","Monthly Observation Number","Measured Total Ammonia Nitrogen (TAN), mg/L","Measured Water Temperature, °C","Measured pH, Standard pH units","30-Day Average TAN Criteria Applicable to Individual Sample, mg/L","Single Sample Maximum TAN Criteria, mg/L","Single Sample Maximum TAN Criteria Achieved","Average of Measured TAN Concentrations, mg/L","Average of Individual 30-Day TAN Criteria, mg/L","30-Day TAN Criteria Achieved",null,null,"Final Temp","Final pH","Max Value Exceed"]
[null,1,0.5,33,7,{"$f":"IF(AND(ISBLANK(D6),ISBLANK(E6)),\"\",IF(OR(ISBLANK(D6),ISBLANK(E6)),\"Enter both Temp and pH\",(0.8876*((0.0278/(1+10^(7.688-O6)))+(1.1994/(1+10^(O6-7.688))))*2.126*10^(0.028*(20-N6)))))","v":0.81616038891323395},{"$f":"IF(AND(ISBLANK(D6),ISBLANK(E6)),\"\",IF(OR(ISBLANK(D6),ISBLANK(E6)),\"Enter both Temp and pH\",2.5*((0.8876*((0.0278/(1+10^(7.688-O6)))+(1.1994/(1+10^(O6-7.688))))*2.126*10^(0.028*(20-N6))))))","v":2.0404009722830847},{"$f":"IF(OR(ISBLANK(C6),ISBLANK(G6)),\"\",IF(C6>G6,\"NO\",\"Yes\"))","v":"Yes"},{"$f":"AVERAGE($C$6:$C$65)","v":1.175},{"$f":"AVERAGE($F$6:$F$65)","v":0.74468683005132341},{"$f":"IF(OR(I6>J6,MAX(P6:P500)>0),\"No\",\"Yes\")","v":"No"},null,null,{"$f":"IF(ISBLANK(D6),\"\",IF(D6<7,7,D6))","v":33},{"$f":"IF(ISBLANK(E6),\"\",IF(E6<6.5,6.5,IF(E6>9,9,E6)))","v":7},{"$f":"IF(H6=\"\",\"\",IF(H6=\"NO\",1,0))","v":0}]
[{"$f":"IF(ISBLANK($A$6),\"\",$A$6)","v":""},2,1.1000000000000001,22,7.5,{"$f":"IF(AND(ISBLANK(D7),ISBLANK(E7)),\"\",IF(OR(ISBLANK(D7),ISBLANK(E7)),\"Enter both Temp and pH\",(0.8876*((0.0278/(1+10^(7.688-O7)))+(1.1994/(1+10^(O7-7.688))))*2.126*10^(0.028*(20-MAX(N7,7))))))","v":1.2249007868969757},{"$f":"IF(AND(ISBLANK(D7),ISBLANK(E7)),\"\",IF(OR(ISBLANK(D7),ISBLANK(E7)),\"Enter both Temp and pH\",2.5*((0.8876*((0.0278/(1+10^(7.688-O7)))+(1.1994/(1+10^(O7-7.688))))*2.126*10^(0.028*(20-MAX(D7,7)))))))","v":3.0622519672424393},{"$f":"IF(OR(ISBLANK(C7),ISBLANK(G7)),\"\",IF(C7>G7,\"NO\",\"Yes\"))","v":"Yes"},{"$f":"IF(COUNT(F6:F65)<4,\"Minimum data requirements not met for IWR purposes!\",\"\")","v":""},null,null,null,null,{"$f":"IF(ISBLANK(D7),\"\",IF(D7<7,7,D7))","v":22},7.5,{"$f":"IF(H7=\"\",\"\",IF(H7=\"NO\",1,0))","v":0}]
[{"$f":"IF(ISBLANK($A$6),\"\",$A$6)","v":""},3,2.2200000000000002,25,8.1999999999999993,0.41477840262501631,{"$f":"IF(AND(ISBLANK(D8),ISBLANK(E8)),\"\",IF(OR(ISBLANK(D8),ISBLANK(E8)),\"Enter both Temp and pH\",2.5*((0.8876*((0.0278/(1+10^(7.688-O8)))+(1.1994/(1+10^(O8-7.688))))*2.126*10^(0.028*(20-MAX(D8,7)))))))","v":1.0369460065625407},{"$f":"IF(OR(ISBLANK(C8),ISBLANK(G8)),\"\",IF(C8>G8,\"NO\",\"Yes\"))","v":"NO"},null,null,null,null,null,25,8.1999999999999993,1]
[{"$f":"IF(ISBLANK($A$6),\"\",$A$6)","v":""},4,0.8,35,8.5,0.13222142459418562,0.33055356148546405,"NO",null,null,null,null,null,35,8.5,1]
[{"$f":"IF(ISNUMBER(F10),A9,\"\")","v":""},{"$f":"IF(ISNUMBER(C10),B9+1,\"\")","v":5},1.65,20,7.25,1.6724243701598265,4.1810609253995663,"Yes",null,null,null,null,null,20,7.25,0]
[{"$f":"IF(ISNUMBER(F11),A10,\"\")","v":""},{"$f":"IF(ISNUMBER(C11),B10+1,\"\")","v":6},0.78,28,8.5,0.20763560711870269,0.51908901779675676,"NO",null,null,null,null,null,28,8.5,1]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"",{"$f":"IF(ISBLANK(E38),\"\",IF(E38<6.5,6.5,IF(E38>9,9,E38)))","v":""},""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]
["","",null,null,null,"","","",null,null,null,null,null,"","",""]

{"sheet":"TAN SSAC Calculator","index":3,"n_rows":106,"n_cols":8,"rows_kept":106,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,0,2,5],[3,0,3,5],[4,0,4,5],[0,0,0,4],[0,5,1,5]]}
["Total Ammonia Nitrogen (TAN) SSAC Calculator",null,null,null,null,"Developed by Garry Payne, DEP,       Jan. 2019"]
["Note: Use this tab only when unionid mussels have been shown to be absent, early life stage protection is required, and a TAN SSAC for the waterbody has been adopted by FDEP and approved by the USEPA."]
["To use:  1) Press \"Clear Entries\" button on right to remove all old data entries.  2) Enter measured TAN concentration in mg/L (optional), Water Temperature in °C, and pH in standard units.  3. Once all required data is entered, the applicable TAN criteria are calculated automatically."]
["Columns A - D (Unshaded) are for data entry.           Additional notes are embedded as comments in the heading for each column, please review!"]
["Columns E (shaded Green) and Column F (shaded Blue) are results fields and are protected from change.  Do Not Attempt to Change These Fields!"]
["Site ID","Measured Total Ammonia Nitrogen (TAN), mg/L","Measured Water Temperature, °C","Measured pH, Standard pH units","30-Day Average TAN SSAC Value Applicable to Individual Sample, mg/L","Applicable Single Sample TAN SSAC Value, mg/L",null,"Final pH"]
[1,0.5,33,7,{"$f":"IF(AND(ISBLANK(C7),ISBLANK(D7)),\"\",IF(OR(ISBLANK(C7),ISBLANK(D7)),\"Enter both Temp and pH\",(0.9405*((0.0278/(1+10^(7.688-H7)))+(1.1994/(1+10^(H7-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-C7)))))))","v":3.0699274296643853},{"$f":"IF(AND(ISBLANK(C7),ISBLANK(D7)),\"\",IF(OR(ISBLANK(C7),ISBLANK(D7)),\"Enter both Temp and pH\",(2.5*(0.9405*((0.0278/(1+10^(7.688-H7)))+(1.1994/(1+10^(H7-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-C7))))))))","v":7.6748185741609634},null,{"$f":"IF(ISBLANK(D7),\"\",IF(D7<6.5,6.5,IF(D7>9,9,D7)))","v":7}]
[2,1.1000000000000001,22,7.5,{"$f":"IF(AND(ISBLANK(C8),ISBLANK(D8)),\"\",IF(OR(ISBLANK(C8),ISBLANK(D8)),\"Enter both Temp and pH\",(0.9405*((0.0278/(1+10^(7.688-H8)))+(1.1994/(1+10^(H8-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-C8)))))))","v":4.6073744516315642},{"$f":"IF(AND(ISBLANK(C8),ISBLANK(D8)),\"\",IF(OR(ISBLANK(C8),ISBLANK(D8)),\"Enter both Temp and pH\",(2.5*(0.9405*((0.0278/(1+10^(7.688-H8)))+(1.1994/(1+10^(H8-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-C8))))))))","v":11.518436129078911},null,{"$f":"IF(ISBLANK(D8),\"\",IF(D8<6.5,6.5,IF(D8>9,9,D8)))","v":7.5}]
[3,2.2200000000000002,25,8.1999999999999993,1.5601585334794836,3.9003963336987093,null,8.1999999999999993]
[4,0.8,35,8.5,0.49734118889485085,1.243352972237127,null,8.5]
[5,1.65,20,7.25,5.7680740602817844,14.42018515070446,null,7.25]
[6,0.78,28,8.5,0.78100610410350113,1.9525152602587528,null,8.5]
[7,null,null,null,"","",null,""]
[8,null,null,null,"","",null,""]
[9,null,null,null,"","",null,""]
[10,null,null,null,"","",null,""]
[11,null,null,null,"","",null,""]
[12,null,null,null,"","",null,""]
[13,null,null,null,"","",null,""]
[14,null,null,null,"","",null,""]
[15,null,null,null,"","",null,""]
[16,null,null,null,"","",null,""]
[17,null,null,null,"","",null,""]
[18,null,null,null,"","",null,""]
[19,null,null,null,"","",null,""]
[20,null,null,null,"","",null,""]
[21,null,null,null,"","",null,""]
[22,null,null,null,"","",null,""]
[23,null,null,null,"","",null,""]
[24,null,null,null,"","",null,""]
[25,null,null,null,"","",null,""]
[26,null,null,null,"","",null,""]
[27,null,null,null,"","",null,""]
[28,null,null,null,"","",null,""]
[29,null,null,null,"","",null,""]
[30,null,null,null,"","",null,""]
[31,null,null,null,"","",null,""]
[32,null,null,null,"","",null,""]
[33,null,null,null,"","",null,""]
[34,null,null,null,"","",null,""]
[35,null,null,null,"","",null,""]
[36,null,null,null,"","",null,""]
[37,null,null,null,"","",null,""]
[38,null,null,null,"","",null,""]
[39,null,null,null,"","",null,""]
[40,null,null,null,"","",null,""]
[41,null,null,null,"","",null,""]
[42,null,null,null,"","",null,""]
[43,null,null,null,"","",null,""]
[44,null,null,null,"","",null,""]
[45,null,null,null,"","",null,""]
[46,null,null,null,"","",null,""]
[47,null,null,null,"","",null,""]
[48,null,null,null,"","",null,""]
[49,null,null,null,"","",null,""]
[50,null,null,null,"","",null,""]
[51,null,null,null,"","",null,""]
[52,null,null,null,"","",null,""]
[53,null,null,null,"","",null,""]
[54,null,null,null,"","",null,""]
[55,null,null,null,"","",null,""]
[56,null,null,null,"","",null,""]
[57,null,null,null,"","",null,""]
[58,null,null,null,"","",null,""]
[59,null,null,null,"","",null,""]
[60,null,null,null,"","",null,""]
[61,null,null,null,"","",null,""]
[62,null,null,null,"","",null,""]
[63,null,null,null,"","",null,""]
[64,null,null,null,"","",null,""]
[65,null,null,null,"","",null,""]
[66,null,null,null,{"$f":"IF(AND(ISBLANK(C72),ISBLANK(D72)),\"\",IF(OR(ISBLANK(C72),ISBLANK(D72)),\"Enter both Temp and pH\",(0.9405*((0.0278/(1+10^(7.688-H72)))+(1.1994/(1+10^(H72-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-C72)))))))","v":""},{"$f":"IF(AND(ISBLANK(C72),ISBLANK(D72)),\"\",IF(OR(ISBLANK(C72),ISBLANK(D72)),\"Enter both Temp and pH\",(2.5*(0.9405*((0.0278/(1+10^(7.688-H72)))+(1.1994/(1+10^(H72-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-C72))))))))","v":""},null,{"$f":"IF(ISBLANK(D72),\"\",IF(D72<6.5,6.5,IF(D72>9,9,D72)))","v":""}]
[67,null,null,null,"","",null,""]
[68,null,null,null,"","",null,""]
[69,null,null,null,"","",null,""]
[70,null,null,null,"","",null,""]
[71,null,null,null,"","",null,""]
[72,null,null,null,"","",null,""]
[73,null,null,null,"","",null,""]
[74,null,null,null,"","",null,""]
[75,null,null,null,"","",null,""]
[76,null,null,null,"","",null,""]
[77,null,null,null,"","",null,""]
[78,null,null,null,"","",null,""]
[79,null,null,null,"","",null,""]
[80,null,null,null,"","",null,""]
[81,null,null,null,"","",null,""]
[82,null,null,null,"","",null,""]
[83,null,null,null,"","",null,""]
[84,null,null,null,"","",null,""]
[85,null,null,null,"","",null,""]
[86,null,null,null,"","",null,""]
[87,null,null,null,"","",null,""]
[88,null,null,null,"","",null,""]
[89,null,null,null,"","",null,""]
[90,null,null,null,"","",null,""]
[91,null,null,null,"","",null,""]
[92,null,null,null,"","",null,""]
[93,null,null,null,"","",null,""]
[94,null,null,null,"","",null,""]
[95,null,null,null,"","",null,""]
[96,null,null,null,"","",null,""]
[97,null,null,null,"","",null,""]
[98,null,null,null,"","",null,""]
[99,null,null,null,"","",null,""]
[100,null,null,null,"","",null,""]

{"sheet":"30-Day Avg TAN SSAC Calculator","index":4,"n_rows":66,"n_cols":16,"rows_kept":66,"cut":false,"hidden":false,"merged":[[4,0,4,10],[7,8,7,10],[0,0,0,9],[0,10,1,10],[1,0,1,9],[2,0,2,10],[3,0,3,10]]}
["30-Day Average Total Ammonia Nitrogen (TAN) SSAC Calculator",null,null,null,null,null,null,null,null,null,"Developed by Garry Payne, DEP, Jan. 2019"]
["Note: Use this tab only when unionid mussels have been shown to be absent, early life stage protection is required, and a TAN SSAC for the waterbody has been adopted by FDEP and approved by the USEPA."]
["To use:  1) Press \"Clear Entries\" button on right to remove all old data entries.  2) Enter Station ID in first cell (i.e., cell A7) (all data entered should be for the same station collected within the same 30-day period).  3) Enter measured TAN concentrations in mg/L collected at specified station during the same 30-day period.  Enter water temperature (in °C) and pH (in standard units) measured at time of TAN sample collection.  A minimum of 4 samples is required to calculate 30-day average TAN criteria for IWR purposes (Chapter 62-303, F.A.C.)  4) Once all required data are entered, the applicable TAN criteria (green and blue columns) and the averages of the measured TAN and the 30-day TAN SSAC values are calculated (red columns) automatically and achievement of the 30-day TAN SSAC is assessed."]
["Columns C - E (Unshaded) are for data entry.                                 Additional notes are embedded as comments in the heading for each column, please review!"]
["Columns A and B (except Cell A7) (shaded Gray) are filled in automatically.  Columns F - I (shaded Green, Blue, and Red) are results fields and are protected from change.                                          Do Not Attempt to Change These Fields!"]
["Station ID","Monthly Observation Number","Measured Total Ammonia Nitrogen (TAN), mg/L","Measured Water Temperature, °C","Measured pH, Standard pH units","30-Day Average TAN SSAC Applicable to Individual Sample, mg/L","Single Sample Maximum TAN Criteria, mg/L","Single Sample Maximum TAN Criteria Achieved","Average of Measured TAN Concentrations, mg/L","Average of Individual 30-Day TAN SSAC Values, mg/L","30-Day TAN SSAC Achieved",null,null,null,"Final pH","Max Value Exceed"]
[null,1,0.5,33,7,{"$f":"IF(AND(ISBLANK(D7),ISBLANK(E7)),\"\",IF(OR(ISBLANK(D7),ISBLANK(E7)),\"Enter both Temp and pH\",(0.9405*((0.0278/(1+10^(7.688-O7)))+(1.1994/(1+10^(O7-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-D7)))))))","v":3.0699274296643853},{"$f":"IF(AND(ISBLANK(D7),ISBLANK(E7)),\"\",IF(OR(ISBLANK(D7),ISBLANK(E7)),\"Enter both Temp and pH\",2.5*((0.9405*((0.0278/(1+10^(7.688-O7)))+(1.1994/(1+10^(O7-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-D7))))))))","v":7.6748185741609634},{"$f":"IF(OR(ISBLANK(C7),ISBLANK(G7)),\"\",IF((ROUND(C7,2))>(ROUND(G7,2)),\"NO\",\"Yes\"))","v":"Yes"},{"$f":"AVERAGE($C$7:$C$66)","v":1.175},{"$f":"AVERAGE($F$7:$F$66)","v":2.7139802946759279},{"$f":"IF(OR(I7>J7,MAX(P7:P501)>0),\"No\",\"Yes\")","v":"Yes"},null,null,null,{"$f":"IF(ISBLANK(E7),\"\",IF(E7<6.5,6.5,IF(E7>9,9,E7)))","v":7},{"$f":"IF(H7=\"\",\"\",IF(H7=\"NO\",1,0))","v":0}]
[{"$f":"IF(ISBLANK($A$7),\"\",$A$7)","v":""},2,1.1000000000000001,22,7.5,{"$f":"IF(AND(ISBLANK(D8),ISBLANK(E8)),\"\",IF(OR(ISBLANK(D8),ISBLANK(E8)),\"Enter both Temp and pH\",(0.9405*((0.0278/(1+10^(7.688-O8)))+(1.1994/(1+10^(O8-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-D8)))))))","v":4.6073744516315642},{"$f":"IF(AND(ISBLANK(D8),ISBLANK(E8)),\"\",IF(OR(ISBLANK(D8),ISBLANK(E8)),\"Enter both Temp and pH\",2.5*((0.9405*((0.0278/(1+10^(7.688-O8)))+(1.1994/(1+10^(O8-7.688))))*MIN(6.92,(7.547*10^(0.028*(20-D8))))))))","v":11.518436129078911},"Yes",{"$f":"IF(COUNT(F7:F66)<4,\"Minimum data requirements not met for IWR purposes!\",\"\")","v":""},null,null,null,null,null,7.5,{"$f":"IF(H8=\"\",\"\",IF(H8=\"NO\",1,0))","v":0}]
[{"$f":"IF(ISBLANK($A$7),\"\",$A$7)","v":""},3,2.2200000000000002,25,8.1999999999999993,1.5601585334794836,3.9003963336987093,{"$f":"IF(OR(ISBLANK(C9),ISBLANK(G9)),\"\",IF((ROUND(C9,2))>(ROUND(G9,2)),\"NO\",\"Yes\"))","v":"Yes"},null,null,null,null,null,null,8.1999999999999993,0]
[{"$f":"IF(ISBLANK($A$7),\"\",$A$7)","v":""},4,0.8,35,8.5,0.49734118889485085,1.243352972237127,{"$f":"IF(OR(ISBLANK(C10),ISBLANK(G10)),\"\",IF((ROUND(C10,2))>(ROUND(G10,2)),\"NO\",\"Yes\"))","v":"Yes"},null,null,null,null,null,null,8.5,0]
[{"$f":"IF(ISNUMBER(F11),A10,\"\")","v":""},{"$f":"IF(ISNUMBER(C11),B10+1,\"\")","v":5},1.65,20,7.25,5.7680740602817844,14.42018515070446,"Yes",null,null,null,null,null,null,7.25,0]
["",{"$f":"IF(ISNUMBER(C12),B11+1,\"\")","v":6},0.78,28,8.5,0.78100610410350113,1.9525152602587528,"Yes",null,null,null,null,null,null,8.5,0]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]
["","",null,null,null,"","","",null,null,null,null,null,null,"",""]

{"sheet":"Un-ionized Ammonia Calculator","index":5,"n_rows":105,"n_cols":10,"rows_kept":105,"cut":false,"hidden":false,"merged":[[3,0,3,7],[1,0,1,7],[2,0,2,7],[0,0,0,6]]}
["          Un-ionized Ammonia Nitrogen Calculator",null,null,null,null,null,null,"Developed by Garry Payne, DEP, Sept. 2016"]
["To use:  1) Press \"Clear Entries\" button on right to remove all old data entries.  2) Enter measured TAN concentration in mg/L, Water Temperature in °C, and pH in standard units (these parameters are always required).  4) Then enter measured Salinity (ppt) or Specific Conductance (µmhos/cm) if available.  (Note: Calculation preferentially uses salinity.  If salinity data are not available, then leave salinity blank and enter specific conductance and it will be used.  If neither salinity or conductance data are entered, then a salinity of zero is assumed)."]
["Columns A - F (Unshaded) are for data entry.                     Additional notes are embedded as comments in the heading for each column, please review!"]
["Column G (shaded Green) and Column H (shaded Blue) are results fields and are protected from change.                  Do Not Attempt to Change These Fields!"]
["Site ID","Measured Total Ammonia Nitrogen (TAN), mg/L","Measured Water Temperature, °C","Measured pH, Standard pH units","Measured Salinity, ppt (Optional)","Specific Conductance, µmhos/cm (Optional)","Calculated Un-ionized Ammonia, mg/L as N","Calculated Un-ionized Ammonia, mg/L as NH3","Final Salinity","Final pH"]
[1,0.75,27.5,7.25,null,1275,{"$f":"IF(AND(ISBLANK(B6),ISBLANK(C6), ISBLANK(D6)),\"\",IF(OR(ISBLANK(B6),ISBLANK(C6), ISBLANK(D6)),\"Enter all required values\",(B6*(1/((10^((0.0901821+(2729.92/(C6+273.15)))+((0.1552-(0.0003142*C6))*((19.9273*I6)/(1000-(1.005109*I6))))-D6))+1)))))","v":8.867629980727364E-3},{"$f":"IF(AND(ISBLANK(B6),ISBLANK(C6), ISBLANK(D6)),\"\",IF(OR(ISBLANK(B6),ISBLANK(C6), ISBLANK(D6)),\"Enter all required values\",(B6*(1/((10^((0.0901821+(2729.92/(C6+273.15)))+((0.1552-(0.0003142*C6))*((19.9273*I6)/(1000-(1.005109*I6))))-D6))+1)))*(17/14)))","v":1.0767836405168941E-2},{"$f":"IF(AND(ISBLANK($E6),ISBLANK($F6)),0,IF(ISBLANK($E6),IF($F6=0,0,(0.008-(0.1692*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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*((($F6*(1+0.0191*($C6-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C6)+(0.0004464*$C6^2)+(0.4215-0.003107*$C6)*((($F6*(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))),$E6))","v":0.63175972230685518},{"$f":"IF(ISBLANK(D6),\"\",IF(D6<6.5,6.5,IF(D6>9,9,D6)))","v":7.25}]
[2,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B7),ISBLANK(C7), ISBLANK(D7)),\"\",IF(OR(ISBLANK(B7),ISBLANK(C7), ISBLANK(D7)),\"Enter all required values\",(B7*(1/((10^((0.0901821+(2729.92/(C7+273.15)))+((0.1552-(0.0003142*C7))*((19.9273*I7)/(1000-(1.005109*I7))))-D7))+1)))))","v":""},{"$f":"IF(AND(ISBLANK(B7),ISBLANK(C7), ISBLANK(D7)),\"\",IF(OR(ISBLANK(B7),ISBLANK(C7), ISBLANK(D7)),\"Enter all required values\",(B7*(1/((10^((0.0901821+(2729.92/(C7+273.15)))+((0.1552-(0.0003142*C7))*((19.9273*I7)/(1000-(1.005109*I7))))-D7))+1)))*(17/14)))","v":""},{"$f":"IF(AND(ISBLANK($E7),ISBLANK($F7)),0,IF(ISBLANK($E7),IF($F7=0,0,(0.008-(0.1692*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))^0.5)+(25.3851*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4))))+(14.0941*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))^1.5)-(7.0261*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))^2)+(2.7081*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))^2.5)+(($C7-15)/(1+0.0162*($C7-15))*(0.0005-0.0056*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))^0.5-0.0066*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))-0.0375*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))^1.5+0.0636*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))^2-0.0144*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4)))^2.5)))-(0.008/(1+(1.5*400*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4))))+(400*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4))))^2))-((0.0005*($C7-15)/(1+0.0162*($C7-15)))/(1+(100*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4))))^0.5+(100*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C7)+(0.0004464*$C7^2)+(0.4215-0.003107*$C7)*((($F7*(1+0.0191*($C7-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C7+0.0001104259*$C7^2-0.00000069698*$C7^3+0.0000000010031*$C7^4))))^1.5))),$E7))","v":0},{"$f":"IF(ISBLANK(D7),\"\",IF(D7<6.5,6.5,IF(D7>9,9,D7)))","v":""}]
[3,null,null,null,null,null,"","",0,""]
[4,null,null,null,null,null,"","",0,""]
[5,null,null,null,null,null,"","",0,""]
[6,null,null,null,null,null,"","",0,""]
[7,null,null,null,null,null,"","",0,""]
[8,null,null,null,null,null,"","",0,""]
[9,null,null,null,null,null,"","",0,""]
[10,null,null,null,null,null,"","",0,""]
[11,null,null,null,null,null,"","",0,""]
[12,null,null,null,null,null,"","",0,""]
[13,null,null,null,null,null,"","",0,""]
[14,null,null,null,null,null,"","",0,""]
[15,null,null,null,null,null,"","",0,""]
[16,null,null,null,null,null,"","",0,""]
[17,null,null,null,null,null,"","",0,""]
[18,null,null,null,null,null,"","",0,""]
[19,null,null,null,null,null,"","",0,""]
[20,null,null,null,null,null,"","",0,""]
[21,null,null,null,null,null,"","",0,""]
[22,null,null,null,null,null,"","",0,""]
[23,null,null,null,null,null,"","",0,""]
[24,null,null,null,null,null,"","",0,""]
[25,null,null,null,null,null,"","",0,""]
[26,null,null,null,null,null,"","",0,""]
[27,null,null,null,null,null,"","",0,""]
[28,null,null,null,null,null,"","",0,""]
[29,null,null,null,null,null,"","",0,""]
[30,null,null,null,null,null,"","",0,""]
[31,null,null,null,null,null,"","",0,""]
[32,null,null,null,null,null,"","",0,""]
[33,null,null,null,null,null,"","",0,""]
[34,null,null,null,null,null,"","",0,""]
[35,null,null,null,null,null,"","",0,""]
[36,null,null,null,null,null,"","",0,""]
[37,null,null,null,null,null,"","",0,""]
[38,null,null,null,null,null,"","",0,""]
[39,null,null,null,null,null,"","",0,""]
[40,null,null,null,null,null,"","",0,""]
[41,null,null,null,null,null,"","",0,""]
[42,null,null,null,null,null,"","",0,""]
[43,null,null,null,null,null,"","",0,""]
[44,null,null,null,null,null,"","",0,""]
[45,null,null,null,null,null,"","",0,""]
[46,null,null,null,null,null,"","",0,""]
[47,null,null,null,null,null,"","",0,""]
[48,null,null,null,null,null,"","",0,""]
[49,null,null,null,null,null,"","",0,""]
[50,null,null,null,null,null,"","",0,""]
[51,null,null,null,null,null,"","",0,""]
[52,null,null,null,null,null,"","",0,""]
[53,null,null,null,null,null,"","",0,""]
[54,null,null,null,null,null,"","",0,""]
[55,null,null,null,null,null,"","",0,""]
[56,null,null,null,null,null,"","",0,""]
[57,null,null,null,null,null,"","",0,""]
[58,null,null,null,null,null,"","",0,""]
[59,null,null,null,null,null,"","",0,""]
[60,null,null,null,null,null,"","",0,""]
[61,null,null,null,null,null,"","",0,""]
[62,null,null,null,null,null,"","",0,""]
[63,null,null,null,null,null,"","",0,""]
[64,null,null,null,null,null,"","",0,""]
[65,null,null,null,null,null,"","",0,""]
[66,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B71),ISBLANK(C71), ISBLANK(D71)),\"\",IF(OR(ISBLANK(B71),ISBLANK(C71), ISBLANK(D71)),\"Enter all required values\",(B71*(1/((10^((0.0901821+(2729.92/(C71+273.15)))+((0.1552-(0.0003142*C71))*((19.9273*I71)/(1000-(1.005109*I71))))-D71))+1)))))","v":""},{"$f":"IF(AND(ISBLANK(B71),ISBLANK(C71), ISBLANK(D71)),\"\",IF(OR(ISBLANK(B71),ISBLANK(C71), ISBLANK(D71)),\"Enter all required values\",(B71*(1/((10^((0.0901821+(2729.92/(C71+273.15)))+((0.1552-(0.0003142*C71))*((19.9273*I71)/(1000-(1.005109*I71))))-D71))+1)))*(17/14)))","v":""},{"$f":"IF(AND(ISBLANK($E71),ISBLANK($F71)),0,IF(ISBLANK($E71),IF($F71=0,0,(0.008-(0.1692*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))^0.5)+(25.3851*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4))))+(14.0941*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))^1.5)-(7.0261*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))^2)+(2.7081*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))^2.5)+(($C71-15)/(1+0.0162*($C71-15))*(0.0005-0.0056*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))^0.5-0.0066*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))-0.0375*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))^1.5+0.0636*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))^2-0.0144*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4)))^2.5)))-(0.008/(1+(1.5*400*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4))))+(400*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4))))^2))-((0.0005*($C71-15)/(1+0.0162*($C71-15)))/(1+(100*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4))))^0.5+(100*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)/((1+((760/760*1.01325)*(0.000207-(0.0000000637*(760/760*1.01325))+(0.000000000003989*(760/760*1.01325)^2))/(1+(0.03426*$C71)+(0.0004464*$C71^2)+(0.4215-0.003107*$C71)*((($F71*(1+0.0191*($C71-25))/10000)/4.2914)))))*(0.6766097+0.0200564*$C71+0.0001104259*$C71^2-0.00000069698*$C71^3+0.0000000010031*$C71^4))))^1.5))),$E71))","v":0},{"$f":"IF(ISBLANK(D71),\"\",IF(D71<6.5,6.5,IF(D71>9,9,D71)))","v":""}]
[67,null,null,null,null,null,"","",0,""]
[68,null,null,null,null,null,"","",0,""]
[69,null,null,null,null,null,"","",0,""]
[70,null,null,null,null,null,"","",0,""]
[71,null,null,null,null,null,"","",0,""]
[72,null,null,null,null,null,"","",0,""]
[73,null,null,null,null,null,"","",0,""]
[74,null,null,null,null,null,"","",0,""]
[75,null,null,null,null,null,"","",0,""]
[76,null,null,null,null,null,"","",0,""]
[77,null,null,null,null,null,"","",0,""]
[78,null,null,null,null,null,"","",0,""]
[79,null,null,null,null,null,"","",0,""]
[80,null,null,null,null,null,"","",0,""]
[81,null,null,null,null,null,"","",0,""]
[82,null,null,null,null,null,"","",0,""]
[83,null,null,null,null,null,"","",0,""]
[84,null,null,null,null,null,"","",0,""]
[85,null,null,null,null,null,"","",0,""]
[86,null,null,null,null,null,"","",0,""]
[87,null,null,null,null,null,"","",0,""]
[88,null,null,null,null,null,"","",0,""]
[89,null,null,null,null,null,"","",0,""]
[90,null,null,null,null,null,"","",0,""]
[91,null,null,null,null,null,"","",0,""]
[92,null,null,null,null,null,"","",0,""]
[93,null,null,null,null,null,"","",0,""]
[94,null,null,null,null,null,"","",0,""]
[95,null,null,null,null,null,"","",0,""]
[96,null,null,null,null,null,"","",0,""]
[97,null,null,null,null,null,"","",0,""]
[98,null,null,null,null,null,"","",0,""]
[99,null,null,null,null,null,"","",0,""]
[100,null,null,null,null,null,"","",0,""]