{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Freshwater pH RPA","Marine pH RPA","Version notes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":45,"comments":2,"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":"Freshwater pH RPA","index":0,"n_rows":83,"n_cols":23,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,1,0,4],[10,1,10,3],[10,5,10,7],[10,9,10,10],[10,12,10,13],[10,18,10,19],[10,21,10,22],[11,1,12,1],[26,1,26,3],[27,1,28,3],[27,5,29,7],[29,1,29,3],[10,15,10,16],[30,1,31,3],[33,1,33,3],[49,1,49,3],[50,1,50,3],[51,1,52,1]]}
[null,"Freshwater pH RPA v1.4"]
[null,"Facility Name: ","Instructions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of pH of a mixture of two flows."]
[null,"Analyst:","1.  Enter information into the white blank cells to the left",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Based on the procedure in EPA's DESCON program (EPA, 1988. Technical "]
[null,"Run Date:","2.  Enter ambient and effluent data into columns below to the right (up to 500 data sets)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guidance on Supplementary Stream Design Conditions for Steady State"]
[null,"Run Notes:","3.  Enter mixing zone dilution value, existing pH limits, and the pH criterion (white cells with an * within the pH analysis table)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modeling.  USEPA Office of Water, Washington D.C.)"]
[null,null,"4.  Enter effluent and ambient data source information below pH analysis table"]
[null,null,"5.  If there is reasonable potential for lower or upper pH, click the applicable blue button to calculate pH limit"]
[null,null,"6.  Copy and paste \"pH Analysis\" table into fact sheet - double click video link below for a simple tutorial "]
[null,null,"NOTE: If you need to update the analysis, hit the RESET button then hit the calculate buttons."]
[]
[null,"pH Analysis",null,null,null,"Summary Statistics",null,null,null,"Ambient pH Data",null,null,"Effluent Temp Data",null,null,"Ambient Temp Data",null,null,"Effluent Alk Data",null,null,"Ambient Alk Data"]
[null,"INPUT","Lower pH","Upper pH",null,null,"10th %","90th%",null,"Date","pH Value",null,"Date","Deg C",null,"Date","Deg C",null,"Date","mg/l",null,"Date","mg/l"]
[null,null,"Criteria","Criteria",null,"Ambient temperature",{"$f":"IF(ISBLANK($Q$13),\"--\",PERCENTILE($Q13:$Q513,0.1))","v":"--"},{"$f":"IF(ISBLANK($Q$13),\"--\",PERCENTILE($Q13:$Q513,0.9))","v":"--"}]
[null,"1.  DILUTION AT MZ BOUNDARY","enter value","enter value",null,"Ambient pH",{"$f":"IF(ISBLANK($K$13),\"--\",PERCENTILE($K13:$K513,0.1))","v":"--"},{"$f":"IF(ISBLANK($K$13),\"--\",PERCENTILE($K13:$K513,0.9))","v":"--"}]
[null,"2.  UPSTREAM CHARACTERISTICS",null,null,null,"Ambient alkalinity",{"$f":"IF(ISBLANK($W$13),\"--\",PERCENTILE($W$13:$W$513,0.1))","v":"--"},{"$f":"IF(ISBLANK($W$13),\"--\",PERCENTILE($W13:$W513,0.9))","v":"--"}]
[null,"      Temperature (deg C):",{"$f":"IF(ISBLANK($G$13),\"--\",G13)","v":"--"},{"$f":"IF(ISBLANK($H$13),\"--\",H13)","v":"--"},null,"Effluent temperature",{"$f":"IF(ISBLANK($N$13),\"--\",PERCENTILE($N$13:$N$513,0.1))","v":"--"},{"$f":"IF(ISBLANK($N$13),\"--\",PERCENTILE($N$13:$N$513,0.9))","v":"--"}]
[null,"      pH:",{"$f":"IF(ISBLANK($G$14),\"--\",G14)","v":"--"},{"$f":"IF(ISBLANK($H$14),\"--\",H14)","v":"--"},null,"Effluent alkalinity",{"$f":"IF(ISBLANK($T$13),\"--\",PERCENTILE($T$13:$T$513,0.1))","v":"--"},{"$f":"IF(ISBLANK($T$13),\"--\",PERCENTILE($T$13:$T$513,0.9))","v":"--"}]
[null,"      Alkalinity (mg CaCO3/L):",{"$f":"IF(ISBLANK($G$15),\"--\",G15)","v":"--"},{"$f":"IF(ISBLANK($H$15),\"--\",H15)","v":"--"}]
[null,"3.  EFFLUENT CHARACTERISTICS"]
[null,"      Temperature (deg C):",{"$f":"IF(ISBLANK($G$16),\"--\",G16)","v":"--"},{"$f":"IF(ISBLANK($H$16),\"--\",H16)","v":"--"}]
[null,"      pH (S.U.) - Enter existing lower and upper limit","enter value","enter value"]
[null,"      Alkalinity (mg CaCO3/L):",{"$f":"IF(ISBLANK($G$17),\"--\",G17)","v":"--"},{"$f":"IF(ISBLANK($H$17),\"--\",H17)","v":"--"}]
[null,"4.  APPLICABLE PH CRITERIA","enter value","enter value"]
[null,"      pH at Mixing Zone Boundary:",{"$f":"IF(C14=\"enter value\",\"--\",C48-LOG((C47/C46)-1))","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",D48-LOG((D47/D46)-1))","v":"--"}]
[null,"      Is there Reasonable Potential?",{"$f":"IF(OR(C14=\"enter value\",C23=\"enter value\"),\"--\",IF(ROUND(C24,1)<ROUND(C23,1),\"Yes\",\"No\"))","v":"--"},{"$f":"IF(OR(D14=\"enter value\",D23=\"enter value\"),\"--\",IF(ROUND(D24,1)>ROUND(D23,1),\"Yes\",\"No\"))","v":"--"}]
[null,"      Proposed Effluent Limits",{"$f":"IF(OR(C21=\"enter value\",C23=\"enter value\"),\"--\",IF(C25=\"no\",C21,IF(C67=0,\"calculate\",C67)))","v":"--"},{"$f":"IF(OR(D21=\"enter value\",D23=\"enter value\"),\"--\",IF(D25=\"no\",D21,IF(D67=0,\"calculate\",D67)))","v":"--"}]
[null,"Effluent Data Source:"]
[null,null,null,null,null,"Video Tutorial for Copying and Pasting Summary Table into Fact Sheet                   (double click)"]
[]
[null,"Ambient Data Source:"]
[]
[]
[]
[null,"Intermediate Calculations"]
[null,"1.  IONIZATION CONSTANTS"]
[null,"      Upstream/Background pKa:",{"$f":"IF(C14=\"enter value\",\"--\",6.57-0.0118*C16+0.00012*(C16^2))","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",6.57-0.0118*D16+0.00012*(D16^2))","v":"--"}]
[null,"      Effluent pKa:",{"$f":"IF(C14=\"enter value\",\"--\",6.57-0.0118*C20+0.00012*(C20^2))","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",6.57-0.0118*D20+0.00012*(D20^2))","v":"--"}]
[null,"2.  IONIZATION FRACTIONS"]
[null,"      Upstream/Background Ionization Fraction:",{"$f":"IF(C14=\"enter value\",\"--\",1/(1+10^(C36-C17)))","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",1/(1+10^(D36-D17)))","v":"--"}]
[null,"      Effluent Ionization Fraction:",{"$f":"IF(C14=\"enter value\",\"--\",1/(1+10^(C37-C21)))","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",1/(1+10^(D37-D21)))","v":"--"}]
[null,"3.  TOTAL INORGANIC CARBON"]
[null,"      Upstream Total Inorganic Carbon (mg CaCO3/L):",{"$f":"IF(C14=\"enter value\",\"--\",C18/C39)","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",D18/D39)","v":"--"}]
[null,"      Effluent Total Inorganic Carbon (mg CaCO3/L):",{"$f":"IF(C14=\"enter value\",\"--\",C22/C40)","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",D22/D40)","v":"--"}]
[null,"4.  CONDITIONS AT MIXING ZONE BOUNDARY"]
[null,"      Temperature (deg C):",{"$f":"IF(C14=\"enter value\",\"--\",C16+(C20-C16)/C14)","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",D16+(D20-D16)/D14)","v":"--"}]
[null,"      Alkalinity (mg CaCO3/L):",{"$f":"IF(C14=\"enter value\",\"--\",C18+(C22-C18)/C14)","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",D18+(D22-D18)/D14)","v":"--"}]
[null,"      Total Inorganic Carbon (mg CaCO3/L):",{"$f":"IF(C14=\"enter value\",\"--\",C42+(C43-C42)/C14)","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",D42+(D43-D42)/D14)","v":"--"}]
[null,"      pKa:",{"$f":"IF(C14=\"enter value\",\"--\",6.57-0.0118*C45+0.00012*(C45^2))","v":"--"},{"$f":"IF(D14=\"enter value\",\"--\",6.57-0.0118*D45+0.00012*(D45^2))","v":"--"}]
[]
[]
[null,"Effluent Limit Calculations"]
[null,"INPUT","Lower pH","Upper pH"]
[null,null,"Criteria","Criteria"]
[null,"1.  DILUTION AT MZ BOUNDARY",{"$f":"C14","v":"enter value"},{"$f":"D14","v":"enter value"}]
[]
[null,"2.  UPSTREAM CHARACTERISTICS"]
[null,"      Temperature (deg C):",{"$f":"C16","v":"--"},"--"]
[null,"      pH:","--","--"]
[null,"      Alkalinity (mg CaCO3/L):","--","--"]
[]
[null,"3.  EFFLUENT CHARACTERISTICS"]
[null,"      Temperature (deg C):",{"$f":"C20","v":"--"},{"$f":"D20","v":"--"}]
[null,"      Alkalinity (mg CaCO3/L):",{"$f":"C22","v":"--"},{"$f":"D22","v":"--"}]
[]
[null,"4.  APPLICABLE PH CRITERIA",{"$f":"C23","v":"enter value"},"enter value"]
[null,"     Calculated pH at Mixing Zone Boundary",{"$f":"IF(C54=\"enter value\",\"--\",C83-LOG((C82/C81)-1))","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",D83-LOG((D82/D81)-1))","v":"--"}]
[null,"Required Effluent pH:"]
[]
[null,"Intermediate Calculations"]
[null,"1.  IONIZATION CONSTANTS"]
[null,"      Upstream/Background pKa:",{"$f":"IF(C54=\"enter value\",\"--\",6.57-0.0118*C57+0.00012*(C57^2))","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",6.57-0.0118*D57+0.00012*(D57^2))","v":"--"}]
[null,"      Effluent pKa:",{"$f":"IF(C54=\"enter value\",\"--\",6.57-0.0118*C62+0.00012*(C62^2))","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",6.57-0.0118*D62+0.00012*(D62^2))","v":"--"}]
[null,"2.  IONIZATION FRACTIONS"]
[null,"      Upstream/Background Ionization Fraction:",{"$f":"IF(C54=\"enter value\",\"--\",1/(1+10^(C71-C58)))","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",1/(1+10^(D71-D58)))","v":"--"}]
[null,"      Effluent Ionization Fraction:",{"$f":"IF(C54=\"enter value\",\"--\",1/(1+10^(C72-C67)))","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",1/(1+10^(D72-D67)))","v":"--"}]
[null,"3.  TOTAL INORGANIC CARBON"]
[null,"      Upstream Total Inorganic Carbon (mg CaCO3/L):",{"$f":"IF(C54=\"enter value\",\"--\",C59/C74)","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",D59/D74)","v":"--"}]
[null,"      Effluent Total Inorganic Carbon (mg CaCO3/L):",{"$f":"IF(C54=\"enter value\",\"--\",C63/C75)","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",D63/D75)","v":"--"}]
[null,"4.  CONDITIONS AT MIXING ZONE BOUNDARY"]
[null,"      Temperature (deg C):",{"$f":"IF(C54=\"enter value\",\"--\",C57+(C62-C57)/C54)","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",D57+(D62-D57)/D54)","v":"--"}]
[null,"      Alkalinity (mg CaCO3/L):",{"$f":"IF(C54=\"enter value\",\"--\",C59+(C63-C59)/C54)","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",D59+(D63-D59)/D54)","v":"--"}]
[null,"      Total Inorganic Carbon (mg CaCO3/L):",{"$f":"IF(C54=\"enter value\",\"--\",C77+(C78-C77)/C54)","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",D77+(D78-D77)/D54)","v":"--"}]
[null,"      pKa:",{"$f":"IF(C54=\"enter value\",\"--\",6.57-0.0118*C80+0.00012*(C80^2))","v":"--"},{"$f":"IF(D54=\"enter value\",\"--\",6.57-0.0118*D80+0.00012*(D80^2))","v":"--"}]

{"sheet":"Marine pH RPA","index":1,"n_rows":90,"n_cols":18,"rows_kept":90,"cut":false,"hidden":false,"merged":[[7,13,7,15],[8,13,8,15],[17,13,20,15],[0,0,0,3],[2,2,2,3],[3,2,3,3],[5,0,5,4],[6,2,6,3],[18,17,19,22],[20,17,20,22],[22,7,22,15],[85,1,85,3],[86,1,87,3],[24,13,24,15],[88,1,88,3],[89,1,90,3],[35,0,36,4],[37,2,37,3],[66,0,67,4],[68,1,68,3],[69,1,69,3],[70,1,71,1]]}
["Marine pH RPA v1.4",null,null,null,null,null,null,"Instructions:","1."," - Enter background and effluent data into the \"Raw Data\" fields below. "]
[null,null,null,null,null,null,null,null,"2."," - Enter mixing zone dilution (C8,D8), discharge depth (C9,D9) and existing pH limits (C17, D17) into the white cells to the left"]
[null,"[Enter Facility Name]","[EnterOutfall]",null,null,null,null,null,"3."," - Enter pH criterion into cells C33 and D33"]
[null,"[Enter Analyst]","[Enter Run Date]",null,null,null,null,null,"4."," - Press the \"calculate\" buttons in row 30 to calculate pH at edge of MZ (row 28)"]
[null,null,null,null,null,null,null,null,"5."," - If there is RP (row 34), iteratively enter a more stringent pH limit (increments of 0.1 SU) in row 48 and press \"calculate\" button in row 53 until there is no RP (row 65)"]
["2. Initial Reasonable Potential Analysis",null,null,null,null,null,null,null,"6."," - When finished, copy and paste the pH Analysis table into the fact sheet - double click video link in the freshwater tab for a simple tutorial "]
[null,"Discharge Area Characteristics","Characterization Values"]
[null,"Dilution at Mixing Zone boundary","enter value","enter value",null,null,null,"Background Data",null,null,null,null,null,"Effluent Data"]
[null,"Depth of Discharge (m)","enter value","enter value",null,null,null,"Summary Statistics",null,null,null,null,null,"Summary Statistics"]
[null,"Background Area Characteristics (@critical condition)",null,null,null,null,null,"pH","Temp","Salinty","Alkalinity",null,null,"Temp","Salinty","Alkalinity"]
[null,"Temperature (deg C):",{"$f":"IF($I$12=\"--\",\"*\",$I$12)","v":"*"},{"$f":"IF($I$12=\"--\",\"*\",$I$12)","v":"*"},null,null,null,"SU","Deg C","PSU","mg/L (CaCO3)",null,null,"Deg C","PSU","mg/L (CaCO3)"]
[null,"pH:",{"$f":"IF($H$14=\"--\",\"*\",$H$14)","v":"*"},{"$f":"IF($H$15=\"--\",\"*\",$H$15)","v":"*"},null,null,"Avg      ",{"$f":"IF(ISNUMBER(H$28),MEDIAN(H$28:H$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(I$28),AVERAGE(I$28:I$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(J$28),AVERAGE(J$28:J$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(K$28),AVERAGE(K$28:K$129),\"--\")","v":"--"},null,"Avg",{"$f":"IF(ISNUMBER(N$28),AVERAGE(N$28:N$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(O$28),AVERAGE(O$28:O$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(P$28),AVERAGE(P$28:P$129),\"--\")","v":"--"},null,"Run Notes:"]
[null,"Salinity (psu)",{"$f":"IF($J$12=\"--\",\"*\",$J$12)","v":"*"},{"$f":"IF($J$12=\"--\",\"*\",$J$12)","v":"*"},null,null,"Max.",{"$f":"IF(ISNUMBER(H$28),MAX(H$28:H$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(I$28),MAX(I$28:I$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(J$28),MAX(J$28:J$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(K$28),MAX(K$28:K$129),\"--\")","v":"--"},null,"Max.",{"$f":"IF(ISNUMBER(N$28),MAX(N$28:N$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(O$28),MAX(O$28:O$129),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(P$28),MAX(P$28:P$129),\"--\")","v":"--"}]
[null,"Total Alkalinity (mg/l)",{"$f":"IF($K$12=\"--\",\"*\",$K$12)","v":"*"},{"$f":"IF($K$12=\"--\",\"*\",$K$12)","v":"*"},null,null,0.1,{"$f":"IF(ISNUMBER(H$28),PERCENTILE(H$28:H$129,0.1),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(I$28),PERCENTILE(I$28:I$129,0.1),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(J$28),PERCENTILE(J$28:J$129,0.1),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(K$28),PERCENTILE(K$28:K$129,0.1),\"--\")","v":"--"},null,0.1,{"$f":"IF(ISNUMBER(N$28),PERCENTILE(N$28:N$129,0.1),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(O$28),PERCENTILE(O$28:O$129,0.1),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(P$28),PERCENTILE(P$28:P$129,0.1),\"--\")","v":"--"}]
[null,"Effluent Characteristics",null,null,null,null,0.9,{"$f":"IF(ISNUMBER(H$28),PERCENTILE(H$28:H$129,0.9),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(I$28),PERCENTILE(I$28:I$129,0.9),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(J$28),PERCENTILE(J$28:J$129,0.9),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(K$28),PERCENTILE(K$28:K$129,0.9),\"--\")","v":"--"},null,0.9,{"$f":"IF(ISNUMBER(N$28),PERCENTILE(N$28:N$129,0.9),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(O$28),PERCENTILE(O$28:O$129,0.9),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(P$28),PERCENTILE(P$28:P$129,0.9),\"--\")","v":"--"}]
[null,"Temperature (deg C):",{"$f":"IF($N$12=\"--\",\"*\",$N$12)","v":"*"},{"$f":"IF($N$12=\"--\",\"*\",$N$12)","v":"*"}]
[null,"pH:","enter value","enter value",null,null,null,"Ambient Data Source:",null,null,null,null,null,"Effluent Data Source:"]
[null,"Salinity (psu)",{"$f":"IF($O$12=\"--\",\"*\",$O$12)","v":"*"},{"$f":"IF($O$12=\"--\",\"*\",$O$12)","v":"*"}]
[null,"Total Alkalinity (mg/l)",{"$f":"IF($P$12=\"--\",\"*\",$P$12)","v":"*"},{"$f":"IF($P$12=\"--\",\"*\",$P$12)","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Based on the CO2SYS program (Lewis and Wallace, 1998), https://www.nodc.noaa.gov/ocads/oceans/CO2SYS/co2rprt.html"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adapted from Wa. Department of Ecology 3/2019"]
[null,"Conditions at the Mixing Zone Boundary"]
[null,"Temperature (deg C)",null,null,null,null,null,"1. Enter Raw Background and Effluent Data"]
[null,"Salinity (psu)"]
[null,"Density (kg/m^3)",null,null,null,null,null,null,"Background Raw Data",null,null,null,null,"Effluent Raw Data"]
[null,"Alkalinity (mmol/kg-SW)",null,null,null,null,null,"pH","Temperature","Salinty","Alkalinity",null,null,"Temperature","Salinty","Alkalinity"]
[null,"Total Inorganic Carbon (mmol/kg-SW)",null,null,null,null,null,"SU","Degree C","PSU","mg/L (CaCO3)",null,null,"Degree C","PSU","mg/L (CaCO3)"]
[null,"pH"]
[]
[null,"Click the Calculate button(s) to determine pH at edge of MZ"]
[]
[null,null,"Lower pH","Upper pH"]
[null,"Water Quality Criterion (Basin Standards or TBELs)","enter value","enter value"]
[null,"Is there Reasonable Potential?",{"$f":"IF(ISNUMBER($C$28),IF(ROUND($C$28,1)>=ROUND(C33,1),\"No\",\"Yes\"),\"--\")","v":"--"},{"$f":"IF(ISNUMBER($D$28),IF(ROUND($D$28,1)<=ROUND(D33,1),\"No\",\"Yes\"),\"--\")","v":"--"}]
[]
["3. This Section is Used to Iteratively Calculate pH Effluent Limits if there is RP"]
[]
[null,"Discharge Area Characteristics","Characterization Values"]
[null,"Dilution at Mixing Zone boundary",{"$f":"IF(C8=\"enter value\",\"--\",C8)","v":"--"},{"$f":"IF(D8=\"enter value\",\"--\",D8)","v":"--"}]
[null,"Depth of Discharge (m)",{"$f":"IF(C9=\"enter value\",\"--\",C9)","v":"--"},{"$f":"IF(D9=\"enter value\",\"--\",D9)","v":"--"}]
[null,"Background Area Characteristics (@critical condition)"]
[null,"Temperature (deg C):",{"$f":"IF($I$12=\"--\",\"*\",$I$12)","v":"*"},{"$f":"IF($I$12=\"--\",\"*\",$I$12)","v":"*"}]
[null,"pH:",{"$f":"IF($H$14=\"--\",\"*\",$H$14)","v":"*"},{"$f":"IF($H$15=\"--\",\"*\",$H$15)","v":"*"}]
[null,"Salinity (psu)",{"$f":"IF($J$12=\"--\",\"*\",$J$12)","v":"*"},{"$f":"IF($J$12=\"--\",\"*\",$J$12)","v":"*"}]
[null,"Total Alkalinity (mg/l)",{"$f":"IF($K$12=\"--\",\"*\",$K$12)","v":"*"},{"$f":"IF($K$12=\"--\",\"*\",$K$12)","v":"*"}]
[null,"Effluent Characteristics"]
[null,"Temperature (deg C):",{"$f":"IF($N$12=\"--\",\"*\",$N$12)","v":"*"},{"$f":"IF($N$12=\"--\",\"*\",$N$12)","v":"*"}]
[null,"pH: (Iteratively enter pH and hit calculate until no RP)",{"$f":"IF(C34=\"yes\",\"enter value\",IF(C34=\"--\",C34,\"no RP\"))","v":"--"},{"$f":"IF(D34=\"yes\",\"enter value\",IF(D34=\"--\",D34,\"no RP\"))","v":"--"}]
[null,"Salinity (psu)",{"$f":"IF($O$12=\"--\",\"*\",$O$12)","v":"*"},{"$f":"IF($O$12=\"--\",\"*\",$O$12)","v":"*"}]
[null,"Total Alkalinity (mg/l)",{"$f":"IF($P$12=\"--\",\"*\",$P$12)","v":"*"},{"$f":"IF($P$12=\"--\",\"*\",$P$12)","v":"*"}]
[]
[]
[null,"Click the Calculate button to determine pH at edge of MZ"]
[]
[null,"Conditions at the Mixing Zone Boundary"]
[null,"Temperature (deg C)"]
[null,"Salinity (psu)"]
[null,"Density (kg/m^3)"]
[null,"Alkalinity (mmol/kg-SW)"]
[null,"Total Inorganic Carbon (mmol/kg-SW)"]
[null,"pH"]
[]
[null,null,"Lower pH","Upper pH"]
[null,"Water Quality Criterion (Basin Standards)",{"$f":"IF(C33=\"enter value\",\"--\",C33)","v":"--"},{"$f":"IF(D33=\"enter value\",\"--\",D33)","v":"--"}]
[null,"Is there Reasonable Potential?",{"$f":"IF(ISNUMBER($C$61),IF(OR(ROUND($C$61,1)>=ROUND(C64,1),C48=C64),\"No\",\"Yes\"),\"--\")","v":"--"},{"$f":"IF(ISNUMBER($D$61),IF(OR(ROUND($D$61,1)<=ROUND(D64,1),D48=D64),\"No\",\"Yes\"),\"--\")","v":"--"}]
[]
["4. Copy and Paste This Table Into the Fact Sheet"]
[]
[]
[null,"pH Analysis"]
[null,"INPUT","Lower pH","Upper pH"]
[null,null,"Criteria","Criteria"]
[null,"1.  DILUTION AT MZ BOUNDARY",{"$f":"IF(C8=\"enter value\",\"--\",C8)","v":"--"},{"$f":"IF(D8=\"enter value\",\"--\",D8)","v":"--"}]
[null,"2.  UPSTREAM CHARACTERISTICS"]
[null,"      Temperature (deg C):",{"$f":"C11","v":"*"},{"$f":"D11","v":"*"}]
[null,"      pH:",{"$f":"C12","v":"*"},{"$f":"D12","v":"*"}]
[null,"      Alkalinity (mg CaCO3/L):",{"$f":"C14","v":"*"},{"$f":"D14","v":"*"}]
[null,"3.  EFFLUENT CHARACTERISTICS"]
[null,"      Temperature (deg C):",{"$f":"C16","v":"*"},{"$f":"D16","v":"*"}]
[null,"      pH (S.U.):",{"$f":"IF(C17=\"enter value\",\"--\",C17)","v":"--"},{"$f":"IF(D17=\"enter value\",\"--\",D17)","v":"--"}]
[null,"      Alkalinity (mg CaCO3/L):",{"$f":"C19","v":"*"},{"$f":"D19","v":"*"}]
[null,"4.  APPLICABLE PH CRITERIA",{"$f":"IF(C33=\"enter value\",\"--\",C33)","v":"--"},{"$f":"IF(D33=\"enter value\",\"--\",D33)","v":"--"}]
[null,"      pH at Mixing Zone Boundary:",{"$f":"C28","v":0},{"$f":"D28","v":0}]
[null,"      Is there Reasonable Potential?",{"$f":"C34","v":"--"},{"$f":"D34","v":"--"}]
[null,"      Proposed Effluent Limits",{"$f":"IF(C17=\"enter value\",\"--\",IF(C34=\"no\",C17,C48))","v":"--"},{"$f":"IF(D17=\"enter value\",\"--\",IF(D34=\"no\",D17,D48))","v":"--"}]
[null,"Effluent Data Source:"]
[null,{"$f":"IF(N18=\"\",\"\",N18)","v":""}]
[]
[null,"Ambient Data Source:"]
[null,{"$f":"IF(H18=\"\",\"\",H18)","v":""}]

{"sheet":"Version notes","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,1,6,1]]}
["Version","Comments","Modifier","Date","Notes"]
["V 1.0","New stand alone version - modified to remove effluent pH data, added summary statistic table, added more room for comments/notes","Schnurbusch"]
["V1.1","Added pH limit macro button calculator to the freshwater pH RPA, added video tutorial","Schnurbusch","2020-06-04","Used goal seek macro to calculate effluent limits in cases where there is RP"]
["v1.2","Fixed freshwater macro so it referred to the pH criterion in cell C64 and D64.  Previously it referred to a fixed value of 6.5 and 8.5","Schnurbusch","2020-11-10"]
[null,"Added summary table in the marine RPA for copying and pasting into the fact sheet"]
["v1.3","Fixed the marine pH RPA so that the macros work. I created a lower pH macro and an upper pH macro. These correspond to the RPAs against the lower pH criterion (e.g. 6.5) and the upper pH criterion (e.g. 8.5) in columns C and D respectively.","Schnurbusch","2021-06-15"]
[]
["v1.4","Updated marine pH RPA because the upgrade to office 365 caused macro errors","Schnurbusch","2022-03-17"]