{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hardness Based Metals Criteria"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Hardness Based Metals Criteria","index":0,"n_rows":106,"n_cols":11,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,0,0,9],[4,4,5,4],[4,5,4,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3]]}
["             Hardness Based Metals Criteria Calculator for Freshwaters",null,null,null,null,null,null,null,null,null,"(Developed by Garry Payne Sept. 2016)"]
["To use:  1) Press \"Clear Entries\" button on right to remove all old data entries.  2) Enter either the measured hardness in mg/L CaCO3 or the Ca and Mg concentrations in mg/L and the hardness will be calculated for you.  (Note:  For the purpose of calculation of metals criteria, samples with hardness levels <25 mg/L, a hardness of 25 mg/L will be used to calculate the criteria.  For samples with a hardness of >400 mg/L, a hardness of 400 mg/L will be used to calculate the criteria.)  3) Once the necessary information is entered the applicable criteria will be shown in Columns F - K (shaded blue)."]
["Cells in Columns A - D (Unshaded) are for data entry.                              Additional notes are embedded as comments in the heading for each column, please review!"]
["Cells in Column E (shaded Green) and Columns F-K (shaded Blue) are results fields and are protected from change.                        Do Not Attempt to Change These Fields!"]
["Sample ID","Total Hardness, mg/L as CaCO3","Ca, mg/L","Mg, mg/L","Final Total Hardness, mg/L","FAC 62-302(530) Criteria for Class I, Class III and Class III-Limited Freshwaters"]
[null,null,null,null,null,"Cadmium (Cd), µg/L","Chromium III [Cr(III)], µg/L","Copper (Cu), µg/L","Lead (Pb), µg/L","Nickel (Ni), µg/L","Zinc (Zn), µg/L"]
[1,145,null,null,{"$f":"IF(AND(ISBLANK(B7),ISBLANK(C7),ISBLANK(D7)),\"\",IF(AND(ISBLANK(B7),OR(ISBLANK(C7),ISBLANK(D7))),\"Enter both Ca and Mg\",IF(ISBLANK(B7),IF((2.497*C7)+(4.118*D7) <25,25,IF((2.497*C7)+(4.118*D7) >400,400,ROUND((2.497*C7)+(4.118*D7),2))),IF(B7<25,25,IF(B7>400,400,ROUND(B7,2))))))","v":145},{"$f":"IF(ISNUMBER($E7),EXP((0.7409*(LN($E7)))-4.719),\"\")","v":0.35638703196077187},{"$f":"IF(ISNUMBER($E7),EXP((0.819*(LN($E7)))+0.6848),\"\")","v":116.83292643110468},{"$f":"IF(ISNUMBER($E7),EXP((0.8545*(LN($E7)))-1.702),\"\")","v":12.815033614844353},{"$f":"IF(ISNUMBER($E7),EXP((1.273*(LN($E7)))-4.705),\"\")","v":5.1058250473477607},{"$f":"IF(ISNUMBER($E7),EXP((0.846*(LN($E7)))+0.0584),\"\")","v":71.429914064113305},{"$f":"IF(ISNUMBER($E7),EXP((0.8473*(LN($E7)))+0.884),\"\")","v":164.15096126609302}]
[2,null,67,48,{"$f":"IF(AND(ISBLANK(B8),ISBLANK(C8),ISBLANK(D8)),\"\",IF(AND(ISBLANK(B8),OR(ISBLANK(C8),ISBLANK(D8))),\"Enter both Ca and Mg\",IF(ISBLANK(B8),IF((2.497*C8)+(4.118*D8) <25,25,IF((2.497*C8)+(4.118*D8) >400,400,ROUND((2.497*C8)+(4.118*D8),2))),IF(B8<25,25,IF(B8>400,400,ROUND(B8,2))))))","v":364.96},{"$f":"IF(ISNUMBER($E8),EXP((0.7409*(LN($E8)))-4.719),\"\")","v":0.70620674126711791},{"$f":"IF(ISNUMBER($E8),EXP((0.819*(LN($E8)))+0.6848),\"\")","v":248.81911190197005},{"$f":"IF(ISNUMBER($E8),EXP((0.8545*(LN($E8)))-1.702),\"\")","v":28.201315891345953},{"$f":"IF(ISNUMBER($E8),EXP((1.273*(LN($E8)))-4.705),\"\")","v":16.534181044751985},{"$f":"IF(ISNUMBER($E8),EXP((0.846*(LN($E8)))+0.0584),\"\")","v":155.9632564175235},{"$f":"IF(ISNUMBER($E8),EXP((0.8473*(LN($E8)))+0.884),\"\")","v":358.84486630405439}]
[3,null,null,null,{"$f":"IF(AND(ISBLANK(B9),ISBLANK(C9),ISBLANK(D9)),\"\",IF(AND(ISBLANK(B9),OR(ISBLANK(C9),ISBLANK(D9))),\"Enter both Ca and Mg\",IF(ISBLANK(B9),IF((2.497*C9)+(4.118*D9) <25,25,IF((2.497*C9)+(4.118*D9) >400,400,ROUND((2.497*C9)+(4.118*D9),2))),IF(B9<25,25,IF(B9>400,400,ROUND(B9,2))))))","v":""},"","","","","",""]
[4,null,null,null,"","","","","","",""]
[5,null,null,null,"","","","","","",""]
[6,null,null,null,"","","","","","",""]
[7,null,null,null,"","","","","","",""]
[8,null,null,null,"","","","","","",""]
[9,null,null,null,"","","","","","",""]
[10,null,null,null,"","","","","","",""]
[11,null,null,null,"","","","","","",""]
[12,null,null,null,"","","","","","",""]
[13,null,null,null,"","","","","","",""]
[14,null,null,null,"","","","","","",""]
[15,null,null,null,"","","","","","",""]
[16,null,null,null,"","","","","","",""]
[17,null,null,null,"","","","","","",""]
[18,null,null,null,"","","","","","",""]
[19,null,null,null,"","","","","","",""]
[20,null,null,null,"","","","","","",""]
[21,null,null,null,"","","","","","",""]
[22,null,null,null,"","","","","","",""]
[23,null,null,null,"","","","","","",""]
[24,null,null,null,"","","","","","",""]
[25,null,null,null,"","","","","","",""]
[26,null,null,null,"","","","","","",""]
[27,null,null,null,"","","","","","",""]
[28,null,null,null,"","","","","","",""]
[29,null,null,null,"","","","","","",""]
[30,null,null,null,"","","","","","",""]
[31,null,null,null,"","","","","","",""]
[32,null,null,null,"","","","","","",""]
[33,null,null,null,"","","","","","",""]
[34,null,null,null,"","","","","","",""]
[35,null,null,null,"","","","","","",""]
[36,null,null,null,"","","","","","",""]
[37,null,null,null,"","","","","","",""]
[38,null,null,null,"","","","","","",""]
[39,null,null,null,"","","","","","",""]
[40,null,null,null,"","","","","","",""]
[41,null,null,null,"","","","","","",""]
[42,null,null,null,"","","","","","",""]
[43,null,null,null,"","","","","","",""]
[44,null,null,null,"","","","","","",""]
[45,null,null,null,"","","","","","",""]
[46,null,null,null,"","","","","","",""]
[47,null,null,null,"","","","","","",""]
[48,null,null,null,"","","","","","",""]
[49,null,null,null,"","","","","","",""]
[50,null,null,null,"","","","","","",""]
[51,null,null,null,"","","","","","",""]
[52,null,null,null,"","","","","","",""]
[53,null,null,null,"","","","","","",""]
[54,null,null,null,"","","","","","",""]
[55,null,null,null,"","","","","","",""]
[56,null,null,null,"","","","","","",""]
[57,null,null,null,"","","","","","",""]
[58,null,null,null,"","","","","","",""]
[59,null,null,null,"","","","","","",""]
[60,null,null,null,"","","","","","",""]
[61,null,null,null,"","","","","","",""]
[62,null,null,null,"","","","","","",""]
[63,null,null,null,"","","","","","",""]
[64,null,null,null,"","","","","","",""]
[65,null,null,null,"","","","","","",""]
[66,null,null,null,"",{"$f":"IF(ISNUMBER($E72),EXP((0.7409*(LN($E72)))-4.719),\"\")","v":""},{"$f":"IF(ISNUMBER($E72),EXP((0.819*(LN($E72)))+0.6848),\"\")","v":""},{"$f":"IF(ISNUMBER($E72),EXP((0.8545*(LN($E72)))-1.702),\"\")","v":""},{"$f":"IF(ISNUMBER($E72),EXP((1.273*(LN($E72)))-4.705),\"\")","v":""},{"$f":"IF(ISNUMBER($E72),EXP((0.846*(LN($E72)))+0.0584),\"\")","v":""},{"$f":"IF(ISNUMBER($E72),EXP((0.8473*(LN($E72)))+0.884),\"\")","v":""}]
[67,null,null,null,{"$f":"IF(AND(ISBLANK(B73),ISBLANK(C73),ISBLANK(D73)),\"\",IF(AND(ISBLANK(B73),OR(ISBLANK(C73),ISBLANK(D73))),\"Enter both Ca and Mg\",IF(ISBLANK(B73),IF((2.497*C73)+(4.118*D73) <25,25,IF((2.497*C73)+(4.118*D73) >400,400,ROUND((2.497*C73)+(4.118*D73),2))),IF(B73<25,25,IF(B73>400,400,ROUND(B73,2))))))","v":""},"","","","","",""]
[68,null,null,null,"","","","","","",""]
[69,null,null,null,"","","","","","",""]
[70,null,null,null,"","","","","","",""]
[71,null,null,null,"","","","","","",""]
[72,null,null,null,"","","","","","",""]
[73,null,null,null,"","","","","","",""]
[74,null,null,null,"","","","","","",""]
[75,null,null,null,"","","","","","",""]
[76,null,null,null,"","","","","","",""]
[77,null,null,null,"","","","","","",""]
[78,null,null,null,"","","","","","",""]
[79,null,null,null,"","","","","","",""]
[80,null,null,null,"","","","","","",""]
[81,null,null,null,"","","","","","",""]
[82,null,null,null,"","","","","","",""]
[83,null,null,null,"","","","","","",""]
[84,null,null,null,"","","","","","",""]
[85,null,null,null,"","","","","","",""]
[86,null,null,null,"","","","","","",""]
[87,null,null,null,"","","","","","",""]
[88,null,null,null,"","","","","","",""]
[89,null,null,null,"","","","","","",""]
[90,null,null,null,"","","","","","",""]
[91,null,null,null,"","","","","","",""]
[92,null,null,null,"","","","","","",""]
[93,null,null,null,"","","","","","",""]
[94,null,null,null,"","","","","","",""]
[95,null,null,null,"","","","","","",""]
[96,null,null,null,"","","","","","",""]
[97,null,null,null,"","","","","","",""]
[98,null,null,null,"","","","","","",""]
[99,null,null,null,"","","","","","",""]
[100,null,null,null,"","","","","","",""]