{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Inputs","WWF Results","CWF Results","TSF Results","316a Results","ORSANCO","Reference","Versions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":83,"comments":0,"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":"Instructions","index":0,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[10,1,12,10]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Thermal Limits Spreadsheet"]
[null,null,null,null,null,null,null,null,null,null,"Version 1.0, April 2024"]
[]
[]
[]
[]
[]
[]
[]
[null,"If prompted by Excel after opening the DEP Thermal Limits Spreadsheet, enable editing and macros.  This spreadsheet consists of three hyperlink tabs: Instructions, Inputs,  and Results.  Each tab has a corresponding worksheet."]
[]
[]
[]
[null,"Only those cells that are highlighted are available for data entry by the user:"]
[]
[null,"Red asterisks (*) are shown where cells may not be blank in order to calculate effluent limitations."]
[]
[null,"Purple asterisks (*) are shown where data may be left blank and still calculate effluent limitations."]
[]
[null,"Click on the button below to open detailed instructions on the use of the Thermal Limits Spreadsheet:"]
[]
[]
[]
[null,"If you have questions concerning use of this spreadsheet, contact the Bureau of Clean Water at 717-787-5017."]
[]
[null,"Reference:","Implementation Guidance for Temperature Criteria DEP-ID: 386-2000-001"]

{"sheet":"Inputs","index":1,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,21,14,21],[12,22,14,22],[0,9,0,15],[1,9,1,15],[5,2,5,5],[7,2,7,5],[7,9,7,15],[9,9,9,15],[11,1,11,5],[11,13,11,15],[10,2,10,5],[5,9,5,13],[5,14,5,15],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,15,14,15],[12,5,14,5],[12,8,14,8],[12,9,14,9],[12,10,14,10],[12,11,14,11],[12,7,14,7]]}
[null,null,null,null,null,null,null,null,null,{"$f":"Instructions!K2","v":"Thermal Limits Spreadsheet"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Instructions!K3","v":"Version 1.0, April 2024"}]
[]
[]
[]
[null,"Facility:",null,null,null,null,null,null,"Permit No.:"]
[]
[null,"Stream Name:",null,null,null,null,null,null,"Analyst/Engineer:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WWF"]
[null,"Stream Q7-10 (cfs)*:",null,null,"Outfall No.: ",null,null,null,"Analysis Type*:",null,null,null,null,null,null,null,null,null,"CWF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSF"]
[null,"Facility Flows",null,null,null,null,null,null,"Stream Flows",null,null,null,null,"Temperature",null,null,null,null,"316a"]
[null,null,"Intake     (Stream)     (MGD)*","Intake         (External)     (MGD)*","Consumptive    Loss        (MGD)*","Discharge          Flow            (MGD)",null,"Q7-10 Multipliers (Default Shown)","PMF","Seasonal Stream Flow (cfs)","Adjusted Stream Flow     (cfs)","Downstream Stream Flow (cfs)",null,null,"316a","Ambient Stream Temperature (ºF)",null,null,"ORSANCO",null,null,"Q7-10 Multipliers (Default Shown)","PMF"]
[null,"Semi-Monthly",null,null,null,null,null,null,null,null,null,null,null,"Ambient Stream","Criteria*"]
[null,"Increment",null,null,null,null,null,null,null,null,null,null,null,"Temperature (ºF)*","(ºF)",null,null,"Hide: Adjusted Stream Flow"]
[null," Jan  1-31  ",null,null,null,{"$f":"MAX(0,D16+C16-E16)","v":0},null,3.2,1,{"$f":"RawQ*Inputs!H16","v":0},{"$f":"MAX(0,(J16-C16*1.547)*I16)","v":0},{"$f":"MAX(0,MIN(J16+D16*1.547-E16*1.547,MAX(0,K16+F16*1.547)))","v":0},null,null,null,null,null,"Rename Upstream to Seasonal",null,null,null,3.2,1]
[null," Feb  1-29   ",null,null,null,{"$f":"MAX(0,D17+C17-E17)","v":0},null,3.5,1,{"$f":"RawQ*Inputs!H17","v":0},{"$f":"MAX(0,(J17-C17*1.547)*I17)","v":0},{"$f":"MAX(0,MIN(J17+D17*1.547-E17*1.547,MAX(0,K17+F17*1.547)))","v":0},null,null,null,null,null,null,null,null,null,3.5,1]
[null," Mar  1-31  ",null,null,null,0,null,7,1,{"$f":"RawQ*Inputs!H18","v":0},0,0,null,null,null,null,null,null,null,null,null,7,1]
[null," Apr  1-15",null,null,null,0,null,9.3000000000000007,1,{"$f":"RawQ*Inputs!H19","v":0},{"$f":"MAX(0,(J19-C19*1.547)*I19)","v":0},0,null,null,null,null,null,null,null,null,null,9.3000000000000007,1]
[null," Apr 16-30     ",null,null,null,0,null,9.3000000000000007,1,{"$f":"RawQ*Inputs!H20","v":0},0,0,null,null,null,null,null,null,null,null,null,9.3000000000000007,1]
[null," May  1-15   ",null,null,null,0,null,5.0999999999999996,1,{"$f":"RawQ*Inputs!H21","v":0},0,0,null,null,null,null,null,null,null,null,null,5.0999999999999996,1]
[null," May 16-31   ",null,null,null,0,null,5.0999999999999996,1,{"$f":"RawQ*Inputs!H22","v":0},0,0,null,null,null,null,null,null,null,null,null,5.0999999999999996,1]
[null," Jun  1-15     ",null,null,null,0,null,3,1,{"$f":"RawQ*Inputs!H23","v":0},{"$f":"MAX(0,(J23-C23*1.547)*I23)","v":0},0,null,null,null,null,null,null,null,null,null,3,1]
[null," Jun 16-30",null,null,null,0,null,3,1,{"$f":"RawQ*Inputs!H24","v":0},{"$f":"MAX(0,(J24-C24*1.547)*I24)","v":0},0,null,null,null,null,null,null,null,null,null,3,1]
[null," Jul  1-31      ",null,null,null,0,null,1.7,1,{"$f":"RawQ*Inputs!H25","v":0},0,0,null,null,null,null,null,null,null,null,null,1.7,1]
[null," Aug  1-15     ",null,null,null,0,null,1.4,1,{"$f":"RawQ*Inputs!H26","v":0},0,{"$f":"MAX(0,MIN(J26+D26*1.547-E26*1.547,MAX(0,K26+F26*1.547)))","v":0},null,null,null,null,null,null,null,null,null,1.4,1]
[null," Aug 16-31     ",null,null,null,0,null,1.4,1,{"$f":"RawQ*Inputs!H27","v":0},0,0,null,null,null,null,null,null,null,null,null,1.4,1]
[null," Sep  1-15     ",null,null,null,0,null,1.1000000000000001,1,{"$f":"RawQ*Inputs!H28","v":0},0,{"$f":"MAX(0,MIN(J28+D28*1.547-E28*1.547,MAX(0,K28+F28*1.547)))","v":0},null,null,null,null,null,null,null,null,null,1.1000000000000001,1]
[null," Sep 16-30   ",null,null,null,0,null,1.1000000000000001,1,{"$f":"RawQ*Inputs!H29","v":0},0,0,null,null,null,null,null,null,null,null,null,1.1000000000000001,1]
[null," Oct  1-15    ",null,null,null,0,null,1.2,1,{"$f":"RawQ*Inputs!H30","v":0},0,0,null,null,null,null,null,null,null,null,null,1.2,1]
[null," Oct 16-31  ",null,null,null,0,null,1.2,1,{"$f":"RawQ*Inputs!H31","v":0},0,0,null,null,null,null,null,null,null,null,null,1.2,1]
[null," Nov  1-15     ",null,null,null,0,null,1.6,1,{"$f":"RawQ*Inputs!H32","v":0},0,0,null,null,null,null,null,null,null,null,null,1.6,1]
[null," Nov 16-30      ",null,null,null,0,null,1.6,1,{"$f":"RawQ*Inputs!H33","v":0},0,0,null,null,null,null,null,null,null,null,null,1.6,1]
[null," Dec  1-31     ",null,null,null,0,null,2.4,1,{"$f":"RawQ*Inputs!H34","v":0},0,0,null,null,null,null,null,null,null,null,null,2.4,1]

{"sheet":"WWF Results","index":2,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,{"$f":"Instructions!K2","v":"Thermal Limits Spreadsheet"}]
[null,null,null,null,null,{"$f":"Instructions!K3","v":"Version 1.0, April 2024"}]
[]
[]
[]
[]
[]
[]
[null,"Recommended Limits for Case 1 or Case 2"]
[]
[null,null,"WWF","WWF","Case 1","Case 2",null,null,"PMF",null,"Hide: Discharge, PMF"]
[null,"Semi-Monthly","Ambient Stream","Target Maximum","Daily","Daily",null,null,null,null,"Hide: Default Data"]
[null,"Increment","Temperature (ºF)","Stream Temp.","WLA","WLA",null,"at Discharge"]
[null,null,"(Default)","(ºF)","(Million BTUs/day)","(ºF) ",null,"Flow (MGD)"]
[null," Jan  1-31  ",35,{"$f":"IF(Inputs!N16>0,MAX(Reference!C11,Inputs!N16+1),MAX(Reference!C11,C16+1))","v":40},{"$f":"IF(Inputs!D16<>0,\"N/A -- Case 2\",IF(Inputs!N16>0,MAX(D16-Inputs!N16,1),MAX(D16-C16,1))*Inputs!L16*5.39)","v":0},{"$f":"IF(Inputs!J16>(Inputs!C16*1.547),IF(Inputs!F16=0,\"0\", MIN(110,(((Inputs!L16*D16)-(Inputs!K16*(IF(Inputs!N16>0,Inputs!N16,C16))))/(Inputs!F16*1.547)))),IF(Inputs!J16<(Inputs!C16*1.547), \"Targ: \"& D16,0))","v":0},null,{"$f":"Inputs!F16","v":0},{"$f":"Inputs!I16","v":1}]
[null," Feb  1-29   ",35,{"$f":"IF(Inputs!N17>0,MAX(Reference!C12,Inputs!N17+1),MAX(Reference!C12,C17+1))","v":40},{"$f":"IF(Inputs!D17<>0,\"N/A -- Case 2\",IF(Inputs!N17>0,MAX(D17-Inputs!N17,1),MAX(D17-C17,1))*Inputs!L17*5.39)","v":0},{"$f":"IF(Inputs!J17>(Inputs!C17*1.547),IF(Inputs!F17=0,\"0\", MIN(110,(((Inputs!L17*D17)-(Inputs!K17*(IF(Inputs!N17>0,Inputs!N17,C17))))/(Inputs!F17*1.547)))),IF(Inputs!J17<(Inputs!C17*1.547), \"Targ: \"& D17,0))","v":0},null,{"$f":"Inputs!F17","v":0},{"$f":"Inputs!I17","v":1}]
[null," Mar  1-31  ",40,{"$f":"IF(Inputs!N18>0,MAX(Reference!C13,Inputs!N18+1),MAX(Reference!C13,C18+1))","v":46},{"$f":"IF(Inputs!D18<>0,\"N/A -- Case 2\",IF(Inputs!N18>0,MAX(D18-Inputs!N18,1),MAX(D18-C18,1))*Inputs!L18*5.39)","v":0},{"$f":"IF(Inputs!J18>(Inputs!C18*1.547),IF(Inputs!F18=0,\"0\", MIN(110,(((Inputs!L18*D18)-(Inputs!K18*(IF(Inputs!N18>0,Inputs!N18,C18))))/(Inputs!F18*1.547)))),IF(Inputs!J18<(Inputs!C18*1.547), \"Targ: \"& D18,0))","v":0},null,{"$f":"Inputs!F18","v":0},{"$f":"Inputs!I18","v":1}]
[null," Apr  1-15",47,{"$f":"IF(Inputs!N19>0,MAX(Reference!C14,Inputs!N19+1),MAX(Reference!C14,C19+1))","v":52},{"$f":"IF(Inputs!D19<>0,\"N/A -- Case 2\",IF(Inputs!N19>0,MAX(D19-Inputs!N19,1),MAX(D19-C19,1))*Inputs!L19*5.39)","v":0},{"$f":"IF(Inputs!J19>(Inputs!C19*1.547),IF(Inputs!F19=0,\"0\", MIN(110,(((Inputs!L19*D19)-(Inputs!K19*(IF(Inputs!N19>0,Inputs!N19,C19))))/(Inputs!F19*1.547)))),IF(Inputs!J19<(Inputs!C19*1.547), \"Targ: \"& D19,0))","v":0},null,{"$f":"Inputs!F19","v":0},{"$f":"Inputs!I19","v":1}]
[null," Apr 16-30     ",53,{"$f":"IF(Inputs!N20>0,MAX(Reference!C15,Inputs!N20+1),MAX(Reference!C15,C20+1))","v":58},{"$f":"IF(Inputs!D20<>0,\"N/A -- Case 2\",IF(Inputs!N20>0,MAX(D20-Inputs!N20,1),MAX(D20-C20,1))*Inputs!L20*5.39)","v":0},{"$f":"IF(Inputs!J20>(Inputs!C20*1.547),IF(Inputs!F20=0,\"0\", MIN(110,(((Inputs!L20*D20)-(Inputs!K20*(IF(Inputs!N20>0,Inputs!N20,C20))))/(Inputs!F20*1.547)))),IF(Inputs!J20<(Inputs!C20*1.547), \"Targ: \"& D20,0))","v":0},null,{"$f":"Inputs!F20","v":0},{"$f":"Inputs!I20","v":1}]
[null," May  1-15   ",58,{"$f":"IF(Inputs!N21>0,MAX(Reference!C16,Inputs!N21+1),MAX(Reference!C16,C21+1))","v":64},{"$f":"IF(Inputs!D21<>0,\"N/A -- Case 2\",IF(Inputs!N21>0,MAX(D21-Inputs!N21,1),MAX(D21-C21,1))*Inputs!L21*5.39)","v":0},{"$f":"IF(Inputs!J21>(Inputs!C21*1.547),IF(Inputs!F21=0,\"0\", MIN(110,(((Inputs!L21*D21)-(Inputs!K21*(IF(Inputs!N21>0,Inputs!N21,C21))))/(Inputs!F21*1.547)))),IF(Inputs!J21<(Inputs!C21*1.547), \"Targ: \"& D21,0))","v":0},null,{"$f":"Inputs!F21","v":0},{"$f":"Inputs!I21","v":1}]
[null," May 16-31    ",62,{"$f":"IF(Inputs!N22>0,MAX(Reference!C17,Inputs!N22+1),MAX(Reference!C17,C22+1))","v":72},{"$f":"IF(Inputs!D22<>0,\"N/A -- Case 2\",IF(Inputs!N22>0,MAX(D22-Inputs!N22,1),MAX(D22-C22,1))*Inputs!L22*5.39)","v":0},{"$f":"IF(Inputs!J22>(Inputs!C22*1.547),IF(Inputs!F22=0,\"0\", MIN(110,(((Inputs!L22*D22)-(Inputs!K22*(IF(Inputs!N22>0,Inputs!N22,C22))))/(Inputs!F22*1.547)))),IF(Inputs!J22<(Inputs!C22*1.547), \"Targ: \"& D22,0))","v":0},null,{"$f":"Inputs!F22","v":0},{"$f":"Inputs!I22","v":1}]
[null," Jun  1-15     ",67,{"$f":"IF(Inputs!N23>0,MAX(Reference!C18,Inputs!N23+1),MAX(Reference!C18,C23+1))","v":80},{"$f":"IF(Inputs!D23<>0,\"N/A -- Case 2\",IF(Inputs!N23>0,MAX(D23-Inputs!N23,1),MAX(D23-C23,1))*Inputs!L23*5.39)","v":0},{"$f":"IF(Inputs!J23>(Inputs!C23*1.547),IF(Inputs!F23=0,\"0\", MIN(110,(((Inputs!L23*D23)-(Inputs!K23*(IF(Inputs!N23>0,Inputs!N23,C23))))/(Inputs!F23*1.547)))),IF(Inputs!J23<(Inputs!C23*1.547), \"Targ: \"& D23,0))","v":0},null,{"$f":"Inputs!F23","v":0},{"$f":"Inputs!I23","v":1}]
[null," Jun 16-30",71,{"$f":"IF(Inputs!N24>0,MAX(Reference!C19,Inputs!N24+1),MAX(Reference!C19,C24+1))","v":84},{"$f":"IF(Inputs!D24<>0,\"N/A -- Case 2\",IF(Inputs!N24>0,MAX(D24-Inputs!N24,1),MAX(D24-C24,1))*Inputs!L24*5.39)","v":0},{"$f":"IF(Inputs!J24>(Inputs!C24*1.547),IF(Inputs!F24=0,\"0\", MIN(110,(((Inputs!L24*D24)-(Inputs!K24*(IF(Inputs!N24>0,Inputs!N24,C24))))/(Inputs!F24*1.547)))),IF(Inputs!J24<(Inputs!C24*1.547), \"Targ: \"& D24,0))","v":0},null,{"$f":"Inputs!F24","v":0},{"$f":"Inputs!I24","v":1}]
[null," Jul  1-31      ",75,{"$f":"IF(Inputs!N25>0,MAX(Reference!C20,Inputs!N25+1),MAX(Reference!C20,C25+1))","v":87},{"$f":"IF(Inputs!D25<>0,\"N/A -- Case 2\",IF(Inputs!N25>0,MAX(D25-Inputs!N25,1),MAX(D25-C25,1))*Inputs!L25*5.39)","v":0},{"$f":"IF(Inputs!J25>(Inputs!C25*1.547),IF(Inputs!F25=0,\"0\", MIN(110,(((Inputs!L25*D25)-(Inputs!K25*(IF(Inputs!N25>0,Inputs!N25,C25))))/(Inputs!F25*1.547)))),IF(Inputs!J25<(Inputs!C25*1.547), \"Targ: \"& D25,0))","v":0},null,{"$f":"Inputs!F25","v":0},{"$f":"Inputs!I25","v":1}]
[null," Aug  1-15     ",74,{"$f":"IF(Inputs!N26>0,MAX(Reference!C21,Inputs!N26+1),MAX(Reference!C21,C26+1))","v":87},{"$f":"IF(Inputs!D26<>0,\"N/A -- Case 2\",IF(Inputs!N26>0,MAX(D26-Inputs!N26,1),MAX(D26-C26,1))*Inputs!L26*5.39)","v":0},{"$f":"IF(Inputs!J26>(Inputs!C26*1.547),IF(Inputs!F26=0,\"0\", MIN(110,(((Inputs!L26*D26)-(Inputs!K26*(IF(Inputs!N26>0,Inputs!N26,C26))))/(Inputs!F26*1.547)))),IF(Inputs!J26<(Inputs!C26*1.547), \"Targ: \"& D26,0))","v":0},null,{"$f":"Inputs!F26","v":0},{"$f":"Inputs!I26","v":1}]
[null," Aug 16-31     ",74,{"$f":"IF(Inputs!N27>0,MAX(Reference!C22,Inputs!N27+1),MAX(Reference!C22,C27+1))","v":87},{"$f":"IF(Inputs!D27<>0,\"N/A -- Case 2\",IF(Inputs!N27>0,MAX(D27-Inputs!N27,1),MAX(D27-C27,1))*Inputs!L27*5.39)","v":0},{"$f":"IF(Inputs!J27>(Inputs!C27*1.547),IF(Inputs!F27=0,\"0\", MIN(110,(((Inputs!L27*D27)-(Inputs!K27*(IF(Inputs!N27>0,Inputs!N27,C27))))/(Inputs!F27*1.547)))),IF(Inputs!J27<(Inputs!C27*1.547), \"Targ: \"& D27,0))","v":0},null,{"$f":"Inputs!F27","v":0},{"$f":"Inputs!I27","v":1}]
[null," Sep  1-15     ",71,{"$f":"IF(Inputs!N28>0,MAX(Reference!C23,Inputs!N28+1),MAX(Reference!C23,C28+1))","v":84},{"$f":"IF(Inputs!D28<>0,\"N/A -- Case 2\",IF(Inputs!N28>0,MAX(D28-Inputs!N28,1),MAX(D28-C28,1))*Inputs!L28*5.39)","v":0},{"$f":"IF(Inputs!J28>(Inputs!C28*1.547),IF(Inputs!F28=0,\"0\", MIN(110,(((Inputs!L28*D28)-(Inputs!K28*(IF(Inputs!N28>0,Inputs!N28,C28))))/(Inputs!F28*1.547)))),IF(Inputs!J28<(Inputs!C28*1.547), \"Targ: \"& D28,0))","v":0},null,{"$f":"Inputs!F28","v":0},{"$f":"Inputs!I28","v":1}]
[null," Sep 16-30   ",65,{"$f":"IF(Inputs!N29>0,MAX(Reference!C24,Inputs!N29+1),MAX(Reference!C24,C29+1))","v":78},{"$f":"IF(Inputs!D29<>0,\"N/A -- Case 2\",IF(Inputs!N29>0,MAX(D29-Inputs!N29,1),MAX(D29-C29,1))*Inputs!L29*5.39)","v":0},{"$f":"IF(Inputs!J29>(Inputs!C29*1.547),IF(Inputs!F29=0,\"0\", MIN(110,(((Inputs!L29*D29)-(Inputs!K29*(IF(Inputs!N29>0,Inputs!N29,C29))))/(Inputs!F29*1.547)))),IF(Inputs!J29<(Inputs!C29*1.547), \"Targ: \"& D29,0))","v":0},null,{"$f":"Inputs!F29","v":0},{"$f":"Inputs!I29","v":1}]
[null," Oct  1-15    ",60,{"$f":"IF(Inputs!N30>0,MAX(Reference!C25,Inputs!N30+1),MAX(Reference!C25,C30+1))","v":72},{"$f":"IF(Inputs!D30<>0,\"N/A -- Case 2\",IF(Inputs!N30>0,MAX(D30-Inputs!N30,1),MAX(D30-C30,1))*Inputs!L30*5.39)","v":0},{"$f":"IF(Inputs!J30>(Inputs!C30*1.547),IF(Inputs!F30=0,\"0\", MIN(110,(((Inputs!L30*D30)-(Inputs!K30*(IF(Inputs!N30>0,Inputs!N30,C30))))/(Inputs!F30*1.547)))),IF(Inputs!J30<(Inputs!C30*1.547), \"Targ: \"& D30,0))","v":0},null,{"$f":"Inputs!F30","v":0},{"$f":"Inputs!I30","v":1}]
[null," Oct 16-31  ",54,{"$f":"IF(Inputs!N31>0,MAX(Reference!C26,Inputs!N31+1),MAX(Reference!C26,C31+1))","v":66},{"$f":"IF(Inputs!D31<>0,\"N/A -- Case 2\",IF(Inputs!N31>0,MAX(D31-Inputs!N31,1),MAX(D31-C31,1))*Inputs!L31*5.39)","v":0},{"$f":"IF(Inputs!J31>(Inputs!C31*1.547),IF(Inputs!F31=0,\"0\", MIN(110,(((Inputs!L31*D31)-(Inputs!K31*(IF(Inputs!N31>0,Inputs!N31,C31))))/(Inputs!F31*1.547)))),IF(Inputs!J31<(Inputs!C31*1.547), \"Targ: \"& D31,0))","v":0},null,{"$f":"Inputs!F31","v":0},{"$f":"Inputs!I31","v":1}]
[null," Nov  1-15     ",48,{"$f":"IF(Inputs!N32>0,MAX(Reference!C27,Inputs!N32+1),MAX(Reference!C27,C32+1))","v":58},{"$f":"IF(Inputs!D32<>0,\"N/A -- Case 2\",IF(Inputs!N32>0,MAX(D32-Inputs!N32,1),MAX(D32-C32,1))*Inputs!L32*5.39)","v":0},{"$f":"IF(Inputs!J32>(Inputs!C32*1.547),IF(Inputs!F32=0,\"0\", MIN(110,(((Inputs!L32*D32)-(Inputs!K32*(IF(Inputs!N32>0,Inputs!N32,C32))))/(Inputs!F32*1.547)))),IF(Inputs!J32<(Inputs!C32*1.547), \"Targ: \"& D32,0))","v":0},null,{"$f":"Inputs!F32","v":0},{"$f":"Inputs!I32","v":1}]
[null," Nov 16-30      ",42,{"$f":"IF(Inputs!N33>0,MAX(Reference!C28,Inputs!N33+1),MAX(Reference!C28,C33+1))","v":50},{"$f":"IF(Inputs!D33<>0,\"N/A -- Case 2\",IF(Inputs!N33>0,MAX(D33-Inputs!N33,1),MAX(D33-C33,1))*Inputs!L33*5.39)","v":0},{"$f":"IF(Inputs!J33>(Inputs!C33*1.547),IF(Inputs!F33=0,\"0\", MIN(110,(((Inputs!L33*D33)-(Inputs!K33*(IF(Inputs!N33>0,Inputs!N33,C33))))/(Inputs!F33*1.547)))),IF(Inputs!J33<(Inputs!C33*1.547), \"Targ: \"& D33,0))","v":0},null,{"$f":"Inputs!F33","v":0},{"$f":"Inputs!I33","v":1}]
[null," Dec  1-31     ",37,{"$f":"IF(Inputs!N34>0,MAX(Reference!C29,Inputs!N34+1),MAX(Reference!C29,C34+1))","v":42},{"$f":"IF(Inputs!D34<>0,\"N/A -- Case 2\",IF(Inputs!N34>0,MAX(D34-Inputs!N34,1),MAX(D34-C34,1))*Inputs!L34*5.39)","v":0},{"$f":"IF(Inputs!J34>(Inputs!C34*1.547),IF(Inputs!F34=0,\"0\", MIN(110,(((Inputs!L34*D34)-(Inputs!K34*(IF(Inputs!N34>0,Inputs!N34,C34))))/(Inputs!F34*1.547)))),IF(Inputs!J34<(Inputs!C34*1.547), \"Targ: \"& D34,0))","v":0},null,{"$f":"Inputs!F34","v":0},{"$f":"Inputs!I34","v":1}]

{"sheet":"CWF Results","index":3,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,{"$f":"Instructions!K2","v":"Thermal Limits Spreadsheet"}]
[null,null,null,null,null,{"$f":"Instructions!K3","v":"Version 1.0, April 2024"}]
[]
[]
[]
[]
[]
[]
[null,"Recommended Limits for Case 1 or Case 2"]
[]
[null,null,"CWF","CWF","Case 1","Case 2",null,"PMF"]
[null,"Semi-Monthly","Ambient Stream","Target Maximum","Daily","Daily",null,null,"Hide: Discharge, PMF"]
[null,"Increment","Temperature (ºF)","Stream Temp.","WLA","WLA","at Discharge",null,"Hide: Default Data"]
[null,null,"(Default)","(ºF)","(Million BTUs/day)","(ºF) ","Flow (MGD)"]
[null," Jan  1-31  ",34,{"$f":"IF(Inputs!N16>0,MAX(Reference!D11,Inputs!N16+1),MAX(Reference!D11,C16+1))","v":38},{"$f":"IF(Inputs!D16<>0,\"N/A -- Case 2\",IF(Inputs!N16>0,MAX(D16-Inputs!N16,1),MAX(D16-C16,1))*Inputs!L16*5.39)","v":0},{"$f":"IF(Inputs!J16>(Inputs!C16*1.547),IF(Inputs!F16=0,\"0\", MIN(110,(((Inputs!L16*D16)-(Inputs!K16*(IF(Inputs!N16>0,Inputs!N16,C16))))/(Inputs!F16*1.547)))),IF(Inputs!J16<(Inputs!C16*1.547), \"Targ: \"& D16,0))","v":0},{"$f":"Inputs!F16","v":0},{"$f":"Inputs!I16","v":1}]
[null," Feb  1-29   ",35,{"$f":"IF(Inputs!N17>0,MAX(Reference!D12,Inputs!N17+1),MAX(Reference!D12,C17+1))","v":38},{"$f":"IF(Inputs!D17<>0,\"N/A -- Case 2\",IF(Inputs!N17>0,MAX(D17-Inputs!N17,1),MAX(D17-C17,1))*Inputs!L17*5.39)","v":0},{"$f":"IF(Inputs!J17>(Inputs!C17*1.547),IF(Inputs!F17=0,\"0\", MIN(110,(((Inputs!L17*D17)-(Inputs!K17*(IF(Inputs!N17>0,Inputs!N17,C17))))/(Inputs!F17*1.547)))),IF(Inputs!J17<(Inputs!C17*1.547), \"Targ: \"& D17,0))","v":0},{"$f":"Inputs!F17","v":0},{"$f":"Inputs!I17","v":1}]
[null," Mar  1-31  ",39,{"$f":"IF(Inputs!N18>0,MAX(Reference!D13,Inputs!N18+1),MAX(Reference!D13,C18+1))","v":42},{"$f":"IF(Inputs!D18<>0,\"N/A -- Case 2\",IF(Inputs!N18>0,MAX(D18-Inputs!N18,1),MAX(D18-C18,1))*Inputs!L18*5.39)","v":0},{"$f":"IF(Inputs!J18>(Inputs!C18*1.547),IF(Inputs!F18=0,\"0\", MIN(110,(((Inputs!L18*D18)-(Inputs!K18*(IF(Inputs!N18>0,Inputs!N18,C18))))/(Inputs!F18*1.547)))),IF(Inputs!J18<(Inputs!C18*1.547), \"Targ: \"& D18,0))","v":0},{"$f":"Inputs!F18","v":0},{"$f":"Inputs!I18","v":1}]
[null," Apr  1-15",46,{"$f":"IF(Inputs!N19>0,MAX(Reference!D14,Inputs!N19+1),MAX(Reference!D14,C19+1))","v":48},{"$f":"IF(Inputs!D19<>0,\"N/A -- Case 2\",IF(Inputs!N19>0,MAX(D19-Inputs!N19,1),MAX(D19-C19,1))*Inputs!L19*5.39)","v":0},{"$f":"IF(Inputs!J19>(Inputs!C19*1.547),IF(Inputs!F19=0,\"0\", MIN(110,(((Inputs!L19*D19)-(Inputs!K19*(IF(Inputs!N19>0,Inputs!N19,C19))))/(Inputs!F19*1.547)))),IF(Inputs!J19<(Inputs!C19*1.547), \"Targ: \"& D19,0))","v":0},{"$f":"Inputs!F19","v":0},{"$f":"Inputs!I19","v":1}]
[null," Apr 16-30     ",52,{"$f":"IF(Inputs!N20>0,MAX(Reference!D15,Inputs!N20+1),MAX(Reference!D15,C20+1))","v":53},{"$f":"IF(Inputs!D20<>0,\"N/A -- Case 2\",IF(Inputs!N20>0,MAX(D20-Inputs!N20,1),MAX(D20-C20,1))*Inputs!L20*5.39)","v":0},{"$f":"IF(Inputs!J20>(Inputs!C20*1.547),IF(Inputs!F20=0,\"0\", MIN(110,(((Inputs!L20*D20)-(Inputs!K20*(IF(Inputs!N20>0,Inputs!N20,C20))))/(Inputs!F20*1.547)))),IF(Inputs!J20<(Inputs!C20*1.547), \"Targ: \"& D20,0))","v":0},{"$f":"Inputs!F20","v":0},{"$f":"Inputs!I20","v":1}]
[null," May  1-15   ",55,{"$f":"IF(Inputs!N21>0,MAX(Reference!D16,Inputs!N21+1),MAX(Reference!D16,C21+1))","v":56},{"$f":"IF(Inputs!D21<>0,\"N/A -- Case 2\",IF(Inputs!N21>0,MAX(D21-Inputs!N21,1),MAX(D21-C21,1))*Inputs!L21*5.39)","v":0},{"$f":"IF(Inputs!J21>(Inputs!C21*1.547),IF(Inputs!F21=0,\"0\", MIN(110,(((Inputs!L21*D21)-(Inputs!K21*(IF(Inputs!N21>0,Inputs!N21,C21))))/(Inputs!F21*1.547)))),IF(Inputs!J21<(Inputs!C21*1.547), \"Targ: \"& D21,0))","v":0},{"$f":"Inputs!F21","v":0},{"$f":"Inputs!I21","v":1}]
[null," May 16-31    ",59,{"$f":"IF(Inputs!N22>0,MAX(Reference!D17,Inputs!N22+1),MAX(Reference!D17,C22+1))","v":60},{"$f":"IF(Inputs!D22<>0,\"N/A -- Case 2\",IF(Inputs!N22>0,MAX(D22-Inputs!N22,1),MAX(D22-C22,1))*Inputs!L22*5.39)","v":0},{"$f":"IF(Inputs!J22>(Inputs!C22*1.547),IF(Inputs!F22=0,\"0\", MIN(110,(((Inputs!L22*D22)-(Inputs!K22*(IF(Inputs!N22>0,Inputs!N22,C22))))/(Inputs!F22*1.547)))),IF(Inputs!J22<(Inputs!C22*1.547), \"Targ: \"& D22,0))","v":0},{"$f":"Inputs!F22","v":0},{"$f":"Inputs!I22","v":1}]
[null," Jun  1-15     ",63,{"$f":"IF(Inputs!N23>0,MAX(Reference!D18,Inputs!N23+1),MAX(Reference!D18,C23+1))","v":64},{"$f":"IF(Inputs!D23<>0,\"N/A -- Case 2\",IF(Inputs!N23>0,MAX(D23-Inputs!N23,1),MAX(D23-C23,1))*Inputs!L23*5.39)","v":0},{"$f":"IF(Inputs!J23>(Inputs!C23*1.547),IF(Inputs!F23=0,\"0\", MIN(110,(((Inputs!L23*D23)-(Inputs!K23*(IF(Inputs!N23>0,Inputs!N23,C23))))/(Inputs!F23*1.547)))),IF(Inputs!J23<(Inputs!C23*1.547), \"Targ: \"& D23,0))","v":0},{"$f":"Inputs!F23","v":0},{"$f":"Inputs!I23","v":1}]
[null," Jun 16-30",67,{"$f":"IF(Inputs!N24>0,MAX(Reference!D19,Inputs!N24+1),MAX(Reference!D19,C24+1))","v":68},{"$f":"IF(Inputs!D24<>0,\"N/A -- Case 2\",IF(Inputs!N24>0,MAX(D24-Inputs!N24,1),MAX(D24-C24,1))*Inputs!L24*5.39)","v":0},{"$f":"IF(Inputs!J24>(Inputs!C24*1.547),IF(Inputs!F24=0,\"0\", MIN(110,(((Inputs!L24*D24)-(Inputs!K24*(IF(Inputs!N24>0,Inputs!N24,C24))))/(Inputs!F24*1.547)))),IF(Inputs!J24<(Inputs!C24*1.547), \"Targ: \"& D24,0))","v":0},{"$f":"Inputs!F24","v":0},{"$f":"Inputs!I24","v":1}]
[null," Jul  1-31      ",71,{"$f":"IF(Inputs!N25>0,MAX(Reference!D20,Inputs!N25+1),MAX(Reference!D20,C25+1))","v":72},{"$f":"IF(Inputs!D25<>0,\"N/A -- Case 2\",IF(Inputs!N25>0,MAX(D25-Inputs!N25,1),MAX(D25-C25,1))*Inputs!L25*5.39)","v":0},{"$f":"IF(Inputs!J25>(Inputs!C25*1.547),IF(Inputs!F25=0,\"0\", MIN(110,(((Inputs!L25*D25)-(Inputs!K25*(IF(Inputs!N25>0,Inputs!N25,C25))))/(Inputs!F25*1.547)))),IF(Inputs!J25<(Inputs!C25*1.547), \"Targ: \"& D25,0))","v":0},{"$f":"Inputs!F25","v":0},{"$f":"Inputs!I25","v":1}]
[null," Aug  1-15     ",70,{"$f":"IF(Inputs!N26>0,MAX(Reference!D21,Inputs!N26+1),MAX(Reference!D21,C26+1))","v":71},{"$f":"IF(Inputs!D26<>0,\"N/A -- Case 2\",IF(Inputs!N26>0,MAX(D26-Inputs!N26,1),MAX(D26-C26,1))*Inputs!L26*5.39)","v":0},{"$f":"IF(Inputs!J26>(Inputs!C26*1.547),IF(Inputs!F26=0,\"0\", MIN(110,(((Inputs!L26*D26)-(Inputs!K26*(IF(Inputs!N26>0,Inputs!N26,C26))))/(Inputs!F26*1.547)))),IF(Inputs!J26<(Inputs!C26*1.547), \"Targ: \"& D26,0))","v":0},{"$f":"Inputs!F26","v":0},{"$f":"Inputs!I26","v":1}]
[null," Aug 16-31     ",70,{"$f":"IF(Inputs!N27>0,MAX(Reference!D22,Inputs!N27+1),MAX(Reference!D22,C27+1))","v":71},{"$f":"IF(Inputs!D27<>0,\"N/A -- Case 2\",IF(Inputs!N27>0,MAX(D27-Inputs!N27,1),MAX(D27-C27,1))*Inputs!L27*5.39)","v":0},{"$f":"IF(Inputs!J27>(Inputs!C27*1.547),IF(Inputs!F27=0,\"0\", MIN(110,(((Inputs!L27*D27)-(Inputs!K27*(IF(Inputs!N27>0,Inputs!N27,C27))))/(Inputs!F27*1.547)))),IF(Inputs!J27<(Inputs!C27*1.547), \"Targ: \"& D27,0))","v":0},{"$f":"Inputs!F27","v":0},{"$f":"Inputs!I27","v":1}]
[null," Sep  1-15     ",66,{"$f":"IF(Inputs!N28>0,MAX(Reference!D23,Inputs!N28+1),MAX(Reference!D23,C28+1))","v":67},{"$f":"IF(Inputs!D28<>0,\"N/A -- Case 2\",IF(Inputs!N28>0,MAX(D28-Inputs!N28,1),MAX(D28-C28,1))*Inputs!L28*5.39)","v":0},{"$f":"IF(Inputs!J28>(Inputs!C28*1.547),IF(Inputs!F28=0,\"0\", MIN(110,(((Inputs!L28*D28)-(Inputs!K28*(IF(Inputs!N28>0,Inputs!N28,C28))))/(Inputs!F28*1.547)))),IF(Inputs!J28<(Inputs!C28*1.547), \"Targ: \"& D28,0))","v":0},{"$f":"Inputs!F28","v":0},{"$f":"Inputs!I28","v":1}]
[null," Sep 16-30   ",60,{"$f":"IF(Inputs!N29>0,MAX(Reference!D24,Inputs!N29+1),MAX(Reference!D24,C29+1))","v":61},{"$f":"IF(Inputs!D29<>0,\"N/A -- Case 2\",IF(Inputs!N29>0,MAX(D29-Inputs!N29,1),MAX(D29-C29,1))*Inputs!L29*5.39)","v":0},{"$f":"IF(Inputs!J29>(Inputs!C29*1.547),IF(Inputs!F29=0,\"0\", MIN(110,(((Inputs!L29*D29)-(Inputs!K29*(IF(Inputs!N29>0,Inputs!N29,C29))))/(Inputs!F29*1.547)))),IF(Inputs!J29<(Inputs!C29*1.547), \"Targ: \"& D29,0))","v":0},{"$f":"Inputs!F29","v":0},{"$f":"Inputs!I29","v":1}]
[null," Oct  1-15    ",55,{"$f":"IF(Inputs!N30>0,MAX(Reference!D25,Inputs!N30+1),MAX(Reference!D25,C30+1))","v":56},{"$f":"IF(Inputs!D30<>0,\"N/A -- Case 2\",IF(Inputs!N30>0,MAX(D30-Inputs!N30,1),MAX(D30-C30,1))*Inputs!L30*5.39)","v":0},{"$f":"IF(Inputs!J30>(Inputs!C30*1.547),IF(Inputs!F30=0,\"0\", MIN(110,(((Inputs!L30*D30)-(Inputs!K30*(IF(Inputs!N30>0,Inputs!N30,C30))))/(Inputs!F30*1.547)))),IF(Inputs!J30<(Inputs!C30*1.547), \"Targ: \"& D30,0))","v":0},{"$f":"Inputs!F30","v":0},{"$f":"Inputs!I30","v":1}]
[null," Oct 16-31  ",51,{"$f":"IF(Inputs!N31>0,MAX(Reference!D26,Inputs!N31+1),MAX(Reference!D26,C31+1))","v":52},{"$f":"IF(Inputs!D31<>0,\"N/A -- Case 2\",IF(Inputs!N31>0,MAX(D31-Inputs!N31,1),MAX(D31-C31,1))*Inputs!L31*5.39)","v":0},{"$f":"IF(Inputs!J31>(Inputs!C31*1.547),IF(Inputs!F31=0,\"0\", MIN(110,(((Inputs!L31*D31)-(Inputs!K31*(IF(Inputs!N31>0,Inputs!N31,C31))))/(Inputs!F31*1.547)))),IF(Inputs!J31<(Inputs!C31*1.547), \"Targ: \"& D31,0))","v":0},{"$f":"Inputs!F31","v":0},{"$f":"Inputs!I31","v":1}]
[null," Nov  1-15     ",46,{"$f":"IF(Inputs!N32>0,MAX(Reference!D27,Inputs!N32+1),MAX(Reference!D27,C32+1))","v":47},{"$f":"IF(Inputs!D32<>0,\"N/A -- Case 2\",IF(Inputs!N32>0,MAX(D32-Inputs!N32,1),MAX(D32-C32,1))*Inputs!L32*5.39)","v":0},{"$f":"IF(Inputs!J32>(Inputs!C32*1.547),IF(Inputs!F32=0,\"0\", MIN(110,(((Inputs!L32*D32)-(Inputs!K32*(IF(Inputs!N32>0,Inputs!N32,C32))))/(Inputs!F32*1.547)))),IF(Inputs!J32<(Inputs!C32*1.547), \"Targ: \"& D32,0))","v":0},{"$f":"Inputs!F32","v":0},{"$f":"Inputs!I32","v":1}]
[null," Nov 16-30      ",40,{"$f":"IF(Inputs!N33>0,MAX(Reference!D28,Inputs!N33+1),MAX(Reference!D28,C33+1))","v":42},{"$f":"IF(Inputs!D33<>0,\"N/A -- Case 2\",IF(Inputs!N33>0,MAX(D33-Inputs!N33,1),MAX(D33-C33,1))*Inputs!L33*5.39)","v":0},{"$f":"IF(Inputs!J33>(Inputs!C33*1.547),IF(Inputs!F33=0,\"0\", MIN(110,(((Inputs!L33*D33)-(Inputs!K33*(IF(Inputs!N33>0,Inputs!N33,C33))))/(Inputs!F33*1.547)))),IF(Inputs!J33<(Inputs!C33*1.547), \"Targ: \"& D33,0))","v":0},{"$f":"Inputs!F33","v":0},{"$f":"Inputs!I33","v":1}]
[null," Dec  1-31     ",35,{"$f":"IF(Inputs!N34>0,MAX(Reference!D29,Inputs!N34+1),MAX(Reference!D29,C34+1))","v":40},{"$f":"IF(Inputs!D34<>0,\"N/A -- Case 2\",IF(Inputs!N34>0,MAX(D34-Inputs!N34,1),MAX(D34-C34,1))*Inputs!L34*5.39)","v":0},{"$f":"IF(Inputs!J34>(Inputs!C34*1.547),IF(Inputs!F34=0,\"0\", MIN(110,(((Inputs!L34*D34)-(Inputs!K34*(IF(Inputs!N34>0,Inputs!N34,C34))))/(Inputs!F34*1.547)))),IF(Inputs!J34<(Inputs!C34*1.547), \"Targ: \"& D34,0))","v":0},{"$f":"Inputs!F34","v":0},{"$f":"Inputs!I34","v":1}]

{"sheet":"TSF Results","index":4,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,{"$f":"Instructions!K2","v":"Thermal Limits Spreadsheet"}]
[null,null,null,null,null,{"$f":"Instructions!K3","v":"Version 1.0, April 2024"}]
[]
[]
[]
[]
[]
[]
[null,"Recommended Limits for Case 1 or Case 2"]
[]
[null,null,"TSF","TSF","Case 1","Case 2",null,"PMF",null,"Hide: Discharge, PMF"]
[null,"Semi-Monthly","Ambient Stream","Target Maximum","Daily","Daily"]
[null,"Increment","Temperature (ºF)","Stream Temp.","WLA","WLA","at Discharge",null,null,"Hide: Default Data"]
[null,null,"(Default)","(ºF)","(Million BTUs/day)","(ºF) ","Flow (MGD)"]
[null," Jan  1-31  ",34,{"$f":"IF(Inputs!N16>0,MAX(Reference!E11,Inputs!N16+1),MAX(Reference!E11,C16+1))","v":40},{"$f":"IF(Inputs!D16<>0,\"N/A -- Case 2\",IF(Inputs!N16>0,MAX(D16-Inputs!N16,1),MAX(D16-C16,1))*Inputs!L16*5.39)","v":0},{"$f":"IF(Inputs!J16>(Inputs!C16*1.547),IF(Inputs!F16=0,\"0\", MIN(110,(((Inputs!L16*D16)-(Inputs!K16*(IF(Inputs!N16>0,Inputs!N16,C16))))/(Inputs!F16*1.547)))),IF(Inputs!J16<(Inputs!C16*1.547), \"Targ: \"& D16,0))","v":0},{"$f":"IF(F16>0,Inputs!F16,\"0\")","v":"0"},{"$f":"Inputs!I16","v":1}]
[null," Feb  1-29   ",35,{"$f":"IF(Inputs!N17>0,MAX(Reference!E12,Inputs!N17+1),MAX(Reference!E12,C17+1))","v":40},{"$f":"IF(Inputs!D17<>0,\"N/A -- Case 2\",IF(Inputs!N17>0,MAX(D17-Inputs!N17,1),MAX(D17-C17,1))*Inputs!L17*5.39)","v":0},{"$f":"IF(Inputs!J17>(Inputs!C17*1.547),IF(Inputs!F17=0,\"0\", MIN(110,(((Inputs!L17*D17)-(Inputs!K17*(IF(Inputs!N17>0,Inputs!N17,C17))))/(Inputs!F17*1.547)))),IF(Inputs!J17<(Inputs!C17*1.547), \"Targ: \"& D17,0))","v":0},{"$f":"IF(F17>0,Inputs!F17,\"0\")","v":"0"},{"$f":"Inputs!I17","v":1}]
[null," Mar  1-31  ",39,{"$f":"IF(Inputs!N18>0,MAX(Reference!E13,Inputs!N18+1),MAX(Reference!E13,C18+1))","v":46},{"$f":"IF(Inputs!D18<>0,\"N/A -- Case 2\",IF(Inputs!N18>0,MAX(D18-Inputs!N18,1),MAX(D18-C18,1))*Inputs!L18*5.39)","v":0},{"$f":"IF(Inputs!J18>(Inputs!C18*1.547),IF(Inputs!F18=0,\"0\", MIN(110,(((Inputs!L18*D18)-(Inputs!K18*(IF(Inputs!N18>0,Inputs!N18,C18))))/(Inputs!F18*1.547)))),IF(Inputs!J18<(Inputs!C18*1.547), \"Targ: \"& D18,0))","v":0},{"$f":"IF(F18>0,Inputs!F18,\"0\")","v":"0"},{"$f":"Inputs!I18","v":1}]
[null," Apr  1-15",46,{"$f":"IF(Inputs!N19>0,MAX(Reference!E14,Inputs!N19+1),MAX(Reference!E14,C19+1))","v":52},{"$f":"IF(Inputs!D19<>0,\"N/A -- Case 2\",IF(Inputs!N19>0,MAX(D19-Inputs!N19,1),MAX(D19-C19,1))*Inputs!L19*5.39)","v":0},{"$f":"IF(Inputs!J19>(Inputs!C19*1.547),IF(Inputs!F19=0,\"0\", MIN(110,(((Inputs!L19*D19)-(Inputs!K19*(IF(Inputs!N19>0,Inputs!N19,C19))))/(Inputs!F19*1.547)))),IF(Inputs!J19<(Inputs!C19*1.547), \"Targ: \"& D19,0))","v":0},{"$f":"IF(F19>0,Inputs!F19,\"0\")","v":"0"},{"$f":"Inputs!I19","v":1}]
[null," Apr 16-30     ",52,{"$f":"IF(Inputs!N20>0,MAX(Reference!E15,Inputs!N20+1),MAX(Reference!E15,C20+1))","v":58},{"$f":"IF(Inputs!D20<>0,\"N/A -- Case 2\",IF(Inputs!N20>0,MAX(D20-Inputs!N20,1),MAX(D20-C20,1))*Inputs!L20*5.39)","v":0},{"$f":"IF(Inputs!J20>(Inputs!C20*1.547),IF(Inputs!F20=0,\"0\", MIN(110,(((Inputs!L20*D20)-(Inputs!K20*(IF(Inputs!N20>0,Inputs!N20,C20))))/(Inputs!F20*1.547)))),IF(Inputs!J20<(Inputs!C20*1.547), \"Targ: \"& D20,0))","v":0},{"$f":"IF(F20>0,Inputs!F20,\"0\")","v":"0"},{"$f":"Inputs!I20","v":1}]
[null," May  1-15   ",56,{"$f":"IF(Inputs!N21>0,MAX(Reference!E16,Inputs!N21+1),MAX(Reference!E16,C21+1))","v":64},{"$f":"IF(Inputs!D21<>0,\"N/A -- Case 2\",IF(Inputs!N21>0,MAX(D21-Inputs!N21,1),MAX(D21-C21,1))*Inputs!L21*5.39)","v":0},{"$f":"IF(Inputs!J21>(Inputs!C21*1.547),IF(Inputs!F21=0,\"0\", MIN(110,(((Inputs!L21*D21)-(Inputs!K21*(IF(Inputs!N21>0,Inputs!N21,C21))))/(Inputs!F21*1.547)))),IF(Inputs!J21<(Inputs!C21*1.547), \"Targ: \"& D21,0))","v":0},{"$f":"IF(F21>0,Inputs!F21,\"0\")","v":"0"},{"$f":"Inputs!I21","v":1}]
[null," May 16-31    ",60,{"$f":"IF(Inputs!N22>0,MAX(Reference!E17,Inputs!N22+1),MAX(Reference!E17,C22+1))","v":68},{"$f":"IF(Inputs!D22<>0,\"N/A -- Case 2\",IF(Inputs!N22>0,MAX(D22-Inputs!N22,1),MAX(D22-C22,1))*Inputs!L22*5.39)","v":0},{"$f":"IF(Inputs!J22>(Inputs!C22*1.547),IF(Inputs!F22=0,\"0\", MIN(110,(((Inputs!L22*D22)-(Inputs!K22*(IF(Inputs!N22>0,Inputs!N22,C22))))/(Inputs!F22*1.547)))),IF(Inputs!J22<(Inputs!C22*1.547), \"Targ: \"& D22,0))","v":0},{"$f":"IF(F22>0,Inputs!F22,\"0\")","v":"0"},{"$f":"Inputs!I22","v":1}]
[null," Jun  1-15     ",65,{"$f":"IF(Inputs!N23>0,MAX(Reference!E18,Inputs!N23+1),MAX(Reference!E18,C23+1))","v":70},{"$f":"IF(Inputs!D23<>0,\"N/A -- Case 2\",IF(Inputs!N23>0,MAX(D23-Inputs!N23,1),MAX(D23-C23,1))*Inputs!L23*5.39)","v":0},{"$f":"IF(Inputs!J23>(Inputs!C23*1.547),IF(Inputs!F23=0,\"0\", MIN(110,(((Inputs!L23*D23)-(Inputs!K23*(IF(Inputs!N23>0,Inputs!N23,C23))))/(Inputs!F23*1.547)))),IF(Inputs!J23<(Inputs!C23*1.547), \"Targ: \"& D23,0))","v":0},{"$f":"IF(F23>0,Inputs!F23,\"0\")","v":"0"},{"$f":"Inputs!I23","v":1}]
[null," Jun 16-30",69,{"$f":"IF(Inputs!N24>0,MAX(Reference!E19,Inputs!N24+1),MAX(Reference!E19,C24+1))","v":72},{"$f":"IF(Inputs!D24<>0,\"N/A -- Case 2\",IF(Inputs!N24>0,MAX(D24-Inputs!N24,1),MAX(D24-C24,1))*Inputs!L24*5.39)","v":0},{"$f":"IF(Inputs!J24>(Inputs!C24*1.547),IF(Inputs!F24=0,\"0\", MIN(110,(((Inputs!L24*D24)-(Inputs!K24*(IF(Inputs!N24>0,Inputs!N24,C24))))/(Inputs!F24*1.547)))),IF(Inputs!J24<(Inputs!C24*1.547), \"Targ: \"& D24,0))","v":0},{"$f":"IF(F24>0,Inputs!F24,\"0\")","v":"0"},{"$f":"Inputs!I24","v":1}]
[null," Jul  1-31      ",73,{"$f":"IF(Inputs!N25>0,MAX(Reference!E20,Inputs!N25+1),MAX(Reference!E20,C25+1))","v":74},{"$f":"IF(Inputs!D25<>0,\"N/A -- Case 2\",IF(Inputs!N25>0,MAX(D25-Inputs!N25,1),MAX(D25-C25,1))*Inputs!L25*5.39)","v":0},{"$f":"IF(Inputs!J25>(Inputs!C25*1.547),IF(Inputs!F25=0,\"0\", MIN(110,(((Inputs!L25*D25)-(Inputs!K25*(IF(Inputs!N25>0,Inputs!N25,C25))))/(Inputs!F25*1.547)))),IF(Inputs!J25<(Inputs!C25*1.547), \"Targ: \"& D25,0))","v":0},{"$f":"IF(F25>0,Inputs!F25,\"0\")","v":"0"},{"$f":"Inputs!I25","v":1}]
[null," Aug  1-15     ",72,{"$f":"IF(Inputs!N26>0,MAX(Reference!E21,Inputs!N26+1),MAX(Reference!E21,C26+1))","v":80},{"$f":"IF(Inputs!D26<>0,\"N/A -- Case 2\",IF(Inputs!N26>0,MAX(D26-Inputs!N26,1),MAX(D26-C26,1))*Inputs!L26*5.39)","v":0},{"$f":"IF(Inputs!J26>(Inputs!C26*1.547),IF(Inputs!F26=0,\"0\", MIN(110,(((Inputs!L26*D26)-(Inputs!K26*(IF(Inputs!N26>0,Inputs!N26,C26))))/(Inputs!F26*1.547)))),IF(Inputs!J26<(Inputs!C26*1.547), \"Targ: \"& D26,0))","v":0},{"$f":"IF(F26>0,Inputs!F26,\"0\")","v":"0"},{"$f":"Inputs!I26","v":1}]
[null," Aug 16-31     ",70,{"$f":"IF(Inputs!N27>0,MAX(Reference!E22,Inputs!N27+1),MAX(Reference!E22,C27+1))","v":87},{"$f":"IF(Inputs!D27<>0,\"N/A -- Case 2\",IF(Inputs!N27>0,MAX(D27-Inputs!N27,1),MAX(D27-C27,1))*Inputs!L27*5.39)","v":0},{"$f":"IF(Inputs!J27>(Inputs!C27*1.547),IF(Inputs!F27=0,\"0\", MIN(110,(((Inputs!L27*D27)-(Inputs!K27*(IF(Inputs!N27>0,Inputs!N27,C27))))/(Inputs!F27*1.547)))),IF(Inputs!J27<(Inputs!C27*1.547), \"Targ: \"& D27,0))","v":0},{"$f":"IF(F27>0,Inputs!F27,\"0\")","v":"0"},{"$f":"Inputs!I27","v":1}]
[null," Sep  1-15     ",68,{"$f":"IF(Inputs!N28>0,MAX(Reference!E23,Inputs!N28+1),MAX(Reference!E23,C28+1))","v":84},{"$f":"IF(Inputs!D28<>0,\"N/A -- Case 2\",IF(Inputs!N28>0,MAX(D28-Inputs!N28,1),MAX(D28-C28,1))*Inputs!L28*5.39)","v":0},{"$f":"IF(Inputs!J28>(Inputs!C28*1.547),IF(Inputs!F28=0,\"0\", MIN(110,(((Inputs!L28*D28)-(Inputs!K28*(IF(Inputs!N28>0,Inputs!N28,C28))))/(Inputs!F28*1.547)))),IF(Inputs!J28<(Inputs!C28*1.547), \"Targ: \"& D28,0))","v":0},{"$f":"IF(F28>0,Inputs!F28,\"0\")","v":"0"},{"$f":"Inputs!I28","v":1}]
[null," Sep 16-30   ",62,{"$f":"IF(Inputs!N29>0,MAX(Reference!E24,Inputs!N29+1),MAX(Reference!E24,C29+1))","v":78},{"$f":"IF(Inputs!D29<>0,\"N/A -- Case 2\",IF(Inputs!N29>0,MAX(D29-Inputs!N29,1),MAX(D29-C29,1))*Inputs!L29*5.39)","v":0},{"$f":"IF(Inputs!J29>(Inputs!C29*1.547),IF(Inputs!F29=0,\"0\", MIN(110,(((Inputs!L29*D29)-(Inputs!K29*(IF(Inputs!N29>0,Inputs!N29,C29))))/(Inputs!F29*1.547)))),IF(Inputs!J29<(Inputs!C29*1.547), \"Targ: \"& D29,0))","v":0},{"$f":"IF(F29>0,Inputs!F29,\"0\")","v":"0"},{"$f":"Inputs!I29","v":1}]
[null," Oct  1-15    ",57,{"$f":"IF(Inputs!N30>0,MAX(Reference!E25,Inputs!N30+1),MAX(Reference!E25,C30+1))","v":72},{"$f":"IF(Inputs!D30<>0,\"N/A -- Case 2\",IF(Inputs!N30>0,MAX(D30-Inputs!N30,1),MAX(D30-C30,1))*Inputs!L30*5.39)","v":0},{"$f":"IF(Inputs!J30>(Inputs!C30*1.547),IF(Inputs!F30=0,\"0\", MIN(110,(((Inputs!L30*D30)-(Inputs!K30*(IF(Inputs!N30>0,Inputs!N30,C30))))/(Inputs!F30*1.547)))),IF(Inputs!J30<(Inputs!C30*1.547), \"Targ: \"& D30,0))","v":0},{"$f":"IF(F30>0,Inputs!F30,\"0\")","v":"0"},{"$f":"Inputs!I30","v":1}]
[null," Oct 16-31  ",53,{"$f":"IF(Inputs!N31>0,MAX(Reference!E26,Inputs!N31+1),MAX(Reference!E26,C31+1))","v":66},{"$f":"IF(Inputs!D31<>0,\"N/A -- Case 2\",IF(Inputs!N31>0,MAX(D31-Inputs!N31,1),MAX(D31-C31,1))*Inputs!L31*5.39)","v":0},{"$f":"IF(Inputs!J31>(Inputs!C31*1.547),IF(Inputs!F31=0,\"0\", MIN(110,(((Inputs!L31*D31)-(Inputs!K31*(IF(Inputs!N31>0,Inputs!N31,C31))))/(Inputs!F31*1.547)))),IF(Inputs!J31<(Inputs!C31*1.547), \"Targ: \"& D31,0))","v":0},{"$f":"IF(F31>0,Inputs!F31,\"0\")","v":"0"},{"$f":"Inputs!I31","v":1}]
[null," Nov  1-15     ",47,{"$f":"IF(Inputs!N32>0,MAX(Reference!E27,Inputs!N32+1),MAX(Reference!E27,C32+1))","v":58},{"$f":"IF(Inputs!D32<>0,\"N/A -- Case 2\",IF(Inputs!N32>0,MAX(D32-Inputs!N32,1),MAX(D32-C32,1))*Inputs!L32*5.39)","v":0},{"$f":"IF(Inputs!J32>(Inputs!C32*1.547),IF(Inputs!F32=0,\"0\", MIN(110,(((Inputs!L32*D32)-(Inputs!K32*(IF(Inputs!N32>0,Inputs!N32,C32))))/(Inputs!F32*1.547)))),IF(Inputs!J32<(Inputs!C32*1.547), \"Targ: \"& D32,0))","v":0},{"$f":"IF(F32>0,Inputs!F32,\"0\")","v":"0"},{"$f":"Inputs!I32","v":1}]
[null," Nov 16-30      ",41,{"$f":"IF(Inputs!N33>0,MAX(Reference!E28,Inputs!N33+1),MAX(Reference!E28,C33+1))","v":50},{"$f":"IF(Inputs!D33<>0,\"N/A -- Case 2\",IF(Inputs!N33>0,MAX(D33-Inputs!N33,1),MAX(D33-C33,1))*Inputs!L33*5.39)","v":0},{"$f":"IF(Inputs!J33>(Inputs!C33*1.547),IF(Inputs!F33=0,\"0\", MIN(110,(((Inputs!L33*D33)-(Inputs!K33*(IF(Inputs!N33>0,Inputs!N33,C33))))/(Inputs!F33*1.547)))),IF(Inputs!J33<(Inputs!C33*1.547), \"Targ: \"& D33,0))","v":0},{"$f":"IF(F33>0,Inputs!F33,\"0\")","v":"0"},{"$f":"Inputs!I33","v":1}]
[null," Dec  1-31     ",36,{"$f":"IF(Inputs!N34>0,MAX(Reference!E29,Inputs!N34+1),MAX(Reference!E29,C34+1))","v":42},{"$f":"IF(Inputs!D34<>0,\"N/A -- Case 2\",IF(Inputs!N34>0,MAX(D34-Inputs!N34,1),MAX(D34-C34,1))*Inputs!L34*5.39)","v":0},{"$f":"IF(Inputs!J34>(Inputs!C34*1.547),IF(Inputs!F34=0,\"0\", MIN(110,(((Inputs!L34*D34)-(Inputs!K34*(IF(Inputs!N34>0,Inputs!N34,C34))))/(Inputs!F34*1.547)))),IF(Inputs!J34<(Inputs!C34*1.547), \"Targ: \"& D34,0))","v":0},{"$f":"IF(F34>0,Inputs!F34,\"0\")","v":"0"},{"$f":"Inputs!I34","v":1}]

{"sheet":"316a Results","index":5,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,{"$f":"Instructions!K2","v":"Thermal Limits Spreadsheet"}]
[null,null,null,null,{"$f":"Instructions!K3","v":"Version 1.0, April 2024"}]
[]
[]
[]
[]
[]
[]
[null,"Recommended Limits for Case 1 or Case 2"]
[]
[null,null,"316a","Case 1","Case 2",null,null,"PMF"]
[null,"Semi-Monthly","Target Maximum","Daily","Daily",null,null,null,null,"Hide: Discharge, PMF"]
[null,"Increment","Stream Temp.","WLA","WLA",null,"at Discharge",null,null,"Hide: Default Data"]
[null,null,"(ºF)","(Million BTUs/day)","(ºF) ",null,"Flow (MGD)"]
[null," Jan  1-31  ",{"$f":"IF(Inputs!P16>0,MAX(Inputs!O16,Inputs!P16+1),0)","v":0},{"$f":"IF(Inputs!D16<>0,\"N/A -- Case 2\",IF(Inputs!P16>0,MAX(C16-Inputs!P16,1),0)*Inputs!L16*5.39)","v":0},{"$f":"IF(Inputs!J16>(Inputs!C16*1.547),IF(Inputs!F16=0,\"0\", MIN(110,(((Inputs!L16*C16)-(Inputs!K16*(Inputs!P16)))/(Inputs!F16*1.547)))),IF(Inputs!J16<(Inputs!C16*1.547), \"Targ: \"& C16,0))","v":0},null,{"$f":"IF(E16>0,Inputs!F16,0)","v":0},{"$f":"Inputs!I16","v":1}]
[null," Feb  1-29   ",{"$f":"IF(Inputs!P17>0,MAX(Inputs!O17,Inputs!P17+1),0)","v":0},{"$f":"IF(Inputs!D17<>0,\"N/A -- Case 2\",IF(Inputs!P17>0,MAX(C17-Inputs!P17,1),0)*Inputs!L17*5.39)","v":0},{"$f":"IF(Inputs!J17>(Inputs!C17*1.547),IF(Inputs!F17=0,\"0\", MIN(110,(((Inputs!L17*C17)-(Inputs!K17*(Inputs!P17)))/(Inputs!F17*1.547)))),IF(Inputs!J17<(Inputs!C17*1.547), \"Targ: \"& C17,0))","v":0},null,{"$f":"IF(E17>0,Inputs!F17,0)","v":0},{"$f":"Inputs!I17","v":1}]
[null," Mar  1-31  ",{"$f":"IF(Inputs!P18>0,MAX(Inputs!O18,Inputs!P18+1),0)","v":0},{"$f":"IF(Inputs!D18<>0,\"N/A -- Case 2\",IF(Inputs!P18>0,MAX(C18-Inputs!P18,1),0)*Inputs!L18*5.39)","v":0},{"$f":"IF(Inputs!J18>(Inputs!C18*1.547),IF(Inputs!F18=0,\"0\", MIN(110,(((Inputs!L18*C18)-(Inputs!K18*(Inputs!P18)))/(Inputs!F18*1.547)))),IF(Inputs!J18<(Inputs!C18*1.547), \"Targ: \"& C18,0))","v":0},null,{"$f":"IF(E18>0,Inputs!F18,0)","v":0},{"$f":"Inputs!I18","v":1}]
[null," Apr  1-15",{"$f":"IF(Inputs!P19>0,MAX(Inputs!O19,Inputs!P19+1),0)","v":0},{"$f":"IF(Inputs!D19<>0,\"N/A -- Case 2\",IF(Inputs!P19>0,MAX(C19-Inputs!P19,1),0)*Inputs!L19*5.39)","v":0},{"$f":"IF(Inputs!J19>(Inputs!C19*1.547),IF(Inputs!F19=0,\"0\", MIN(110,(((Inputs!L19*C19)-(Inputs!K19*(Inputs!P19)))/(Inputs!F19*1.547)))),IF(Inputs!J19<(Inputs!C19*1.547), \"Targ: \"& C19,0))","v":0},null,{"$f":"IF(E19>0,Inputs!F19,0)","v":0},{"$f":"Inputs!I19","v":1}]
[null," Apr 16-30     ",{"$f":"IF(Inputs!P20>0,MAX(Inputs!O20,Inputs!P20+1),0)","v":0},{"$f":"IF(Inputs!D20<>0,\"N/A -- Case 2\",IF(Inputs!P20>0,MAX(C20-Inputs!P20,1),0)*Inputs!L20*5.39)","v":0},{"$f":"IF(Inputs!J20>(Inputs!C20*1.547),IF(Inputs!F20=0,\"0\", MIN(110,(((Inputs!L20*C20)-(Inputs!K20*(Inputs!P20)))/(Inputs!F20*1.547)))),IF(Inputs!J20<(Inputs!C20*1.547), \"Targ: \"& C20,0))","v":0},null,{"$f":"IF(E20>0,Inputs!F20,0)","v":0},{"$f":"Inputs!I20","v":1}]
[null," May  1-15   ",{"$f":"IF(Inputs!P21>0,MAX(Inputs!O21,Inputs!P21+1),0)","v":0},{"$f":"IF(Inputs!D21<>0,\"N/A -- Case 2\",IF(Inputs!P21>0,MAX(C21-Inputs!P21,1),0)*Inputs!L21*5.39)","v":0},{"$f":"IF(Inputs!J21>(Inputs!C21*1.547),IF(Inputs!F21=0,\"0\", MIN(110,(((Inputs!L21*C21)-(Inputs!K21*(Inputs!P21)))/(Inputs!F21*1.547)))),IF(Inputs!J21<(Inputs!C21*1.547), \"Targ: \"& C21,0))","v":0},null,{"$f":"IF(E21>0,Inputs!F21,0)","v":0},{"$f":"Inputs!I21","v":1}]
[null," May 16-31    ",{"$f":"IF(Inputs!P22>0,MAX(Inputs!O22,Inputs!P22+1),0)","v":0},{"$f":"IF(Inputs!D22<>0,\"N/A -- Case 2\",IF(Inputs!P22>0,MAX(C22-Inputs!P22,1),0)*Inputs!L22*5.39)","v":0},{"$f":"IF(Inputs!J22>(Inputs!C22*1.547),IF(Inputs!F22=0,\"0\", MIN(110,(((Inputs!L22*C22)-(Inputs!K22*(Inputs!P22)))/(Inputs!F22*1.547)))),IF(Inputs!J22<(Inputs!C22*1.547), \"Targ: \"& C22,0))","v":0},null,{"$f":"IF(E22>0,Inputs!F22,0)","v":0},{"$f":"Inputs!I22","v":1}]
[null," Jun  1-15     ",{"$f":"IF(Inputs!P23>0,MAX(Inputs!O23,Inputs!P23+1),0)","v":0},{"$f":"IF(Inputs!D23<>0,\"N/A -- Case 2\",IF(Inputs!P23>0,MAX(C23-Inputs!P23,1),0)*Inputs!L23*5.39)","v":0},{"$f":"IF(Inputs!J23>(Inputs!C23*1.547),IF(Inputs!F23=0,\"0\", MIN(110,(((Inputs!L23*C23)-(Inputs!K23*(Inputs!P23)))/(Inputs!F23*1.547)))),IF(Inputs!J23<(Inputs!C23*1.547), \"Targ: \"& C23,0))","v":0},null,{"$f":"IF(E23>0,Inputs!F23,0)","v":0},{"$f":"Inputs!I23","v":1}]
[null," Jun 16-30",{"$f":"IF(Inputs!P24>0,MAX(Inputs!O24,Inputs!P24+1),0)","v":0},{"$f":"IF(Inputs!D24<>0,\"N/A -- Case 2\",IF(Inputs!P24>0,MAX(C24-Inputs!P24,1),0)*Inputs!L24*5.39)","v":0},{"$f":"IF(Inputs!J24>(Inputs!C24*1.547),IF(Inputs!F24=0,\"0\", MIN(110,(((Inputs!L24*C24)-(Inputs!K24*(Inputs!P24)))/(Inputs!F24*1.547)))),IF(Inputs!J24<(Inputs!C24*1.547), \"Targ: \"& C24,0))","v":0},null,{"$f":"IF(E24>0,Inputs!F24,0)","v":0},{"$f":"Inputs!I24","v":1}]
[null," Jul  1-31      ",{"$f":"IF(Inputs!P25>0,MAX(Inputs!O25,Inputs!P25+1),0)","v":0},{"$f":"IF(Inputs!D25<>0,\"N/A -- Case 2\",IF(Inputs!P25>0,MAX(C25-Inputs!P25,1),0)*Inputs!L25*5.39)","v":0},{"$f":"IF(Inputs!J25>(Inputs!C25*1.547),IF(Inputs!F25=0,\"0\", MIN(110,(((Inputs!L25*C25)-(Inputs!K25*(Inputs!P25)))/(Inputs!F25*1.547)))),IF(Inputs!J25<(Inputs!C25*1.547), \"Targ: \"& C25,0))","v":0},null,{"$f":"IF(E25>0,Inputs!F25,0)","v":0},{"$f":"Inputs!I25","v":1}]
[null," Aug  1-15     ",{"$f":"IF(Inputs!P26>0,MAX(Inputs!O26,Inputs!P26+1),0)","v":0},{"$f":"IF(Inputs!D26<>0,\"N/A -- Case 2\",IF(Inputs!P26>0,MAX(C26-Inputs!P26,1),0)*Inputs!L26*5.39)","v":0},{"$f":"IF(Inputs!J26>(Inputs!C26*1.547),IF(Inputs!F26=0,\"0\", MIN(110,(((Inputs!L26*C26)-(Inputs!K26*(Inputs!P26)))/(Inputs!F26*1.547)))),IF(Inputs!J26<(Inputs!C26*1.547), \"Targ: \"& C26,0))","v":0},null,{"$f":"IF(E26>0,Inputs!F26,0)","v":0},{"$f":"Inputs!I26","v":1}]
[null," Aug 16-31     ",{"$f":"IF(Inputs!P27>0,MAX(Inputs!O27,Inputs!P27+1),0)","v":0},{"$f":"IF(Inputs!D27<>0,\"N/A -- Case 2\",IF(Inputs!P27>0,MAX(C27-Inputs!P27,1),0)*Inputs!L27*5.39)","v":0},{"$f":"IF(Inputs!J27>(Inputs!C27*1.547),IF(Inputs!F27=0,\"0\", MIN(110,(((Inputs!L27*C27)-(Inputs!K27*(Inputs!P27)))/(Inputs!F27*1.547)))),IF(Inputs!J27<(Inputs!C27*1.547), \"Targ: \"& C27,0))","v":0},null,{"$f":"IF(E27>0,Inputs!F27,0)","v":0},{"$f":"Inputs!I27","v":1}]
[null," Sep  1-15     ",{"$f":"IF(Inputs!P28>0,MAX(Inputs!O28,Inputs!P28+1),0)","v":0},{"$f":"IF(Inputs!D28<>0,\"N/A -- Case 2\",IF(Inputs!P28>0,MAX(C28-Inputs!P28,1),0)*Inputs!L28*5.39)","v":0},{"$f":"IF(Inputs!J28>(Inputs!C28*1.547),IF(Inputs!F28=0,\"0\", MIN(110,(((Inputs!L28*C28)-(Inputs!K28*(Inputs!P28)))/(Inputs!F28*1.547)))),IF(Inputs!J28<(Inputs!C28*1.547), \"Targ: \"& C28,0))","v":0},null,{"$f":"IF(E28>0,Inputs!F28,0)","v":0},{"$f":"Inputs!I28","v":1}]
[null," Sep 16-30   ",{"$f":"IF(Inputs!P29>0,MAX(Inputs!O29,Inputs!P29+1),0)","v":0},{"$f":"IF(Inputs!D29<>0,\"N/A -- Case 2\",IF(Inputs!P29>0,MAX(C29-Inputs!P29,1),0)*Inputs!L29*5.39)","v":0},{"$f":"IF(Inputs!J29>(Inputs!C29*1.547),IF(Inputs!F29=0,\"0\", MIN(110,(((Inputs!L29*C29)-(Inputs!K29*(Inputs!P29)))/(Inputs!F29*1.547)))),IF(Inputs!J29<(Inputs!C29*1.547), \"Targ: \"& C29,0))","v":0},null,{"$f":"IF(E29>0,Inputs!F29,0)","v":0},{"$f":"Inputs!I29","v":1}]
[null," Oct  1-15    ",{"$f":"IF(Inputs!P30>0,MAX(Inputs!O30,Inputs!P30+1),0)","v":0},{"$f":"IF(Inputs!D30<>0,\"N/A -- Case 2\",IF(Inputs!P30>0,MAX(C30-Inputs!P30,1),0)*Inputs!L30*5.39)","v":0},{"$f":"IF(Inputs!J30>(Inputs!C30*1.547),IF(Inputs!F30=0,\"0\", MIN(110,(((Inputs!L30*C30)-(Inputs!K30*(Inputs!P30)))/(Inputs!F30*1.547)))),IF(Inputs!J30<(Inputs!C30*1.547), \"Targ: \"& C30,0))","v":0},null,{"$f":"IF(E30>0,Inputs!F30,0)","v":0},{"$f":"Inputs!I30","v":1}]
[null," Oct 16-31  ",{"$f":"IF(Inputs!P31>0,MAX(Inputs!O31,Inputs!P31+1),0)","v":0},{"$f":"IF(Inputs!D31<>0,\"N/A -- Case 2\",IF(Inputs!P31>0,MAX(C31-Inputs!P31,1),0)*Inputs!L31*5.39)","v":0},{"$f":"IF(Inputs!J31>(Inputs!C31*1.547),IF(Inputs!F31=0,\"0\", MIN(110,(((Inputs!L31*C31)-(Inputs!K31*(Inputs!P31)))/(Inputs!F31*1.547)))),IF(Inputs!J31<(Inputs!C31*1.547), \"Targ: \"& C31,0))","v":0},null,{"$f":"IF(E31>0,Inputs!F31,0)","v":0},{"$f":"Inputs!I31","v":1}]
[null," Nov  1-15     ",{"$f":"IF(Inputs!P32>0,MAX(Inputs!O32,Inputs!P32+1),0)","v":0},{"$f":"IF(Inputs!D32<>0,\"N/A -- Case 2\",IF(Inputs!P32>0,MAX(C32-Inputs!P32,1),0)*Inputs!L32*5.39)","v":0},{"$f":"IF(Inputs!J32>(Inputs!C32*1.547),IF(Inputs!F32=0,\"0\", MIN(110,(((Inputs!L32*C32)-(Inputs!K32*(Inputs!P32)))/(Inputs!F32*1.547)))),IF(Inputs!J32<(Inputs!C32*1.547), \"Targ: \"& C32,0))","v":0},null,{"$f":"IF(E32>0,Inputs!F32,0)","v":0},{"$f":"Inputs!I32","v":1}]
[null," Nov 16-30      ",{"$f":"IF(Inputs!P33>0,MAX(Inputs!O33,Inputs!P33+1),0)","v":0},{"$f":"IF(Inputs!D33<>0,\"N/A -- Case 2\",IF(Inputs!P33>0,MAX(C33-Inputs!P33,1),0)*Inputs!L33*5.39)","v":0},{"$f":"IF(Inputs!J33>(Inputs!C33*1.547),IF(Inputs!F33=0,\"0\", MIN(110,(((Inputs!L33*C33)-(Inputs!K33*(Inputs!P33)))/(Inputs!F33*1.547)))),IF(Inputs!J33<(Inputs!C33*1.547), \"Targ: \"& C33,0))","v":0},null,{"$f":"IF(E33>0,Inputs!F33,0)","v":0},{"$f":"Inputs!I33","v":1}]
[null," Dec  1-31     ",{"$f":"IF(Inputs!P34>0,MAX(Inputs!O34,Inputs!P34+1),0)","v":0},{"$f":"IF(Inputs!D34<>0,\"N/A -- Case 2\",IF(Inputs!P34>0,MAX(C34-Inputs!P34,1),0)*Inputs!L34*5.39)","v":0},{"$f":"IF(Inputs!J34>(Inputs!C34*1.547),IF(Inputs!F34=0,\"0\", MIN(110,(((Inputs!L34*C34)-(Inputs!K34*(Inputs!P34)))/(Inputs!F34*1.547)))),IF(Inputs!J34<(Inputs!C34*1.547), \"Targ: \"& C34,0))","v":0},null,{"$f":"IF(E34>0,Inputs!F34,0)","v":0},{"$f":"Inputs!I34","v":1}]

{"sheet":"ORSANCO","index":6,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,{"$f":"Instructions!K2","v":"Thermal Limits Spreadsheet"}]
[null,null,null,null,null,{"$f":"Instructions!K3","v":"Version 1.0, April 2024"}]
[]
[]
[]
[]
[]
[]
[null,"Recommended Limits for Case 1 or Case 2",null,null,null,null,null,null,null,null,null,"Reference"]
[]
[null,null,"ORSANCO","ORSANCO","Case 1","Case 2",null,null,"PMF",null,null,"ORSANCO"]
[null,"Semi-Monthly","Ambient Stream","Target Maximum","Daily","Daily",null,null,null,null,"Semi-Monthly","Criteria MP 0- 341"]
[null,"Increment","Temperature (ºF)","Stream Temp.","WLA","WLA",null,"at Discharge",null,null,"Increment","Stream Temp."]
[null,null,"(Default)","(ºF)","(Million BTUs/day)","(ºF) ",null,"Flow (MGD)",null,null,null,"(ºF)"]
[null," Jan  1-31  ",35,{"$f":"MIN(L16,(IF(Inputs!N16>0,MAX(Reference!C11,Inputs!N16+1),MAX(Reference!C11,C16+1))))","v":40},{"$f":"IF(Inputs!D16<>0,\"N/A -- Case 2\",IF(Inputs!N16>0,MAX(D16-Inputs!N16,1),MAX(D16-C16,1))*Inputs!L16*5.39)","v":0},{"$f":"IF(Inputs!J16>(Inputs!C16*1.547),IF(Inputs!F16=0,\"0\", MIN(110,(((Inputs!L16*D16)-(Inputs!K16*(IF(Inputs!N16>0,Inputs!N16,C16))))/(Inputs!F16*1.547)))),IF(Inputs!J16<(Inputs!C16*1.547), \"Targ: \"& D16,0))","v":0},null,{"$f":"Inputs!F16","v":0},{"$f":"Inputs!I16","v":1},null," Jan  1-31  ",45.7]
[null," Feb  1-29   ",35,{"$f":"MIN(L17,(IF(Inputs!N17>0,MAX(Reference!C12,Inputs!N17+1),MAX(Reference!C12,C17+1))))","v":40},{"$f":"IF(Inputs!D17<>0,\"N/A -- Case 2\",IF(Inputs!N17>0,MAX(D17-Inputs!N17,1),MAX(D17-C17,1))*Inputs!L17*5.39)","v":0},{"$f":"IF(Inputs!J17>(Inputs!C17*1.547),IF(Inputs!F17=0,\"0\", MIN(110,(((Inputs!L17*D17)-(Inputs!K17*(IF(Inputs!N17>0,Inputs!N17,C17))))/(Inputs!F17*1.547)))),IF(Inputs!J17<(Inputs!C17*1.547), \"Targ: \"& D17,0))","v":0},null,{"$f":"Inputs!F17","v":0},{"$f":"Inputs!I17","v":1},null," Feb  1-29   ",43.9]
[null," Mar  1-31  ",40,{"$f":"MIN(L18,(IF(Inputs!N18>0,MAX(Reference!C13,Inputs!N18+1),MAX(Reference!C13,C18+1))))","v":46},{"$f":"IF(Inputs!D18<>0,\"N/A -- Case 2\",IF(Inputs!N18>0,MAX(D18-Inputs!N18,1),MAX(D18-C18,1))*Inputs!L18*5.39)","v":0},{"$f":"IF(Inputs!J18>(Inputs!C18*1.547),IF(Inputs!F18=0,\"0\", MIN(110,(((Inputs!L18*D18)-(Inputs!K18*(IF(Inputs!N18>0,Inputs!N18,C18))))/(Inputs!F18*1.547)))),IF(Inputs!J18<(Inputs!C18*1.547), \"Targ: \"& D18,0))","v":0},null,{"$f":"Inputs!F18","v":0},{"$f":"Inputs!I18","v":1},null," Mar  1-31  ",51.2]
[null," Apr  1-15",47,{"$f":"MIN(L19,(IF(Inputs!N19>0,MAX(Reference!C14,Inputs!N19+1),MAX(Reference!C14,C19+1))))","v":52},{"$f":"IF(Inputs!D19<>0,\"N/A -- Case 2\",IF(Inputs!N19>0,MAX(D19-Inputs!N19,1),MAX(D19-C19,1))*Inputs!L19*5.39)","v":0},{"$f":"IF(Inputs!J19>(Inputs!C19*1.547),IF(Inputs!F19=0,\"0\", MIN(110,(((Inputs!L19*D19)-(Inputs!K19*(IF(Inputs!N19>0,Inputs!N19,C19))))/(Inputs!F19*1.547)))),IF(Inputs!J19<(Inputs!C19*1.547), \"Targ: \"& D19,0))","v":0},null,{"$f":"Inputs!F19","v":0},{"$f":"Inputs!I19","v":1},null," Apr  1-15",61.2]
[null," Apr 16-30     ",53,{"$f":"MIN(L20,(IF(Inputs!N20>0,MAX(Reference!C15,Inputs!N20+1),MAX(Reference!C15,C20+1))))","v":58},{"$f":"IF(Inputs!D20<>0,\"N/A -- Case 2\",IF(Inputs!N20>0,MAX(D20-Inputs!N20,1),MAX(D20-C20,1))*Inputs!L20*5.39)","v":0},{"$f":"IF(Inputs!J20>(Inputs!C20*1.547),IF(Inputs!F20=0,\"0\", MIN(110,(((Inputs!L20*D20)-(Inputs!K20*(IF(Inputs!N20>0,Inputs!N20,C20))))/(Inputs!F20*1.547)))),IF(Inputs!J20<(Inputs!C20*1.547), \"Targ: \"& D20,0))","v":0},null,{"$f":"Inputs!F20","v":0},{"$f":"Inputs!I20","v":1},null," Apr 16-30     ",61.2]
[null," May  1-15   ",58,{"$f":"MIN(L21,(IF(Inputs!N21>0,MAX(Reference!C16,Inputs!N21+1),MAX(Reference!C16,C21+1))))","v":64},{"$f":"IF(Inputs!D21<>0,\"N/A -- Case 2\",IF(Inputs!N21>0,MAX(D21-Inputs!N21,1),MAX(D21-C21,1))*Inputs!L21*5.39)","v":0},{"$f":"IF(Inputs!J21>(Inputs!C21*1.547),IF(Inputs!F21=0,\"0\", MIN(110,(((Inputs!L21*D21)-(Inputs!K21*(IF(Inputs!N21>0,Inputs!N21,C21))))/(Inputs!F21*1.547)))),IF(Inputs!J21<(Inputs!C21*1.547), \"Targ: \"& D21,0))","v":0},null,{"$f":"Inputs!F21","v":0},{"$f":"Inputs!I21","v":1},null," May  1-15   ",71.2]
[null," May 16-31    ",62,{"$f":"MIN(L22,(IF(Inputs!N22>0,MAX(Reference!C17,Inputs!N22+1),MAX(Reference!C17,C22+1))))","v":71.2},{"$f":"IF(Inputs!D22<>0,\"N/A -- Case 2\",IF(Inputs!N22>0,MAX(D22-Inputs!N22,1),MAX(D22-C22,1))*Inputs!L22*5.39)","v":0},{"$f":"IF(Inputs!J22>(Inputs!C22*1.547),IF(Inputs!F22=0,\"0\", MIN(110,(((Inputs!L22*D22)-(Inputs!K22*(IF(Inputs!N22>0,Inputs!N22,C22))))/(Inputs!F22*1.547)))),IF(Inputs!J22<(Inputs!C22*1.547), \"Targ: \"& D22,0))","v":0},null,{"$f":"Inputs!F22","v":0},{"$f":"Inputs!I22","v":1},null," May 16-31    ",71.2]
[null," Jun  1-15     ",67,{"$f":"MIN(L23,(IF(Inputs!N23>0,MAX(Reference!C18,Inputs!N23+1),MAX(Reference!C18,C23+1))))","v":78.8},{"$f":"IF(Inputs!D23<>0,\"N/A -- Case 2\",IF(Inputs!N23>0,MAX(D23-Inputs!N23,1),MAX(D23-C23,1))*Inputs!L23*5.39)","v":0},{"$f":"IF(Inputs!J23>(Inputs!C23*1.547),IF(Inputs!F23=0,\"0\", MIN(110,(((Inputs!L23*D23)-(Inputs!K23*(IF(Inputs!N23>0,Inputs!N23,C23))))/(Inputs!F23*1.547)))),IF(Inputs!J23<(Inputs!C23*1.547), \"Targ: \"& D23,0))","v":0},null,{"$f":"Inputs!F23","v":0},{"$f":"Inputs!I23","v":1},null," Jun  1-15     ",78.8]
[null," Jun 16-30",71,{"$f":"MIN(L24,(IF(Inputs!N24>0,MAX(Reference!C19,Inputs!N24+1),MAX(Reference!C19,C24+1))))","v":84},{"$f":"IF(Inputs!D24<>0,\"N/A -- Case 2\",IF(Inputs!N24>0,MAX(D24-Inputs!N24,1),MAX(D24-C24,1))*Inputs!L24*5.39)","v":0},{"$f":"IF(Inputs!J24>(Inputs!C24*1.547),IF(Inputs!F24=0,\"0\", MIN(110,(((Inputs!L24*D24)-(Inputs!K24*(IF(Inputs!N24>0,Inputs!N24,C24))))/(Inputs!F24*1.547)))),IF(Inputs!J24<(Inputs!C24*1.547), \"Targ: \"& D24,0))","v":0},null,{"$f":"Inputs!F24","v":0},{"$f":"Inputs!I24","v":1},null," Jun 16-30",87]
[null," Jul  1-31      ",75,{"$f":"MIN(L25,(IF(Inputs!N25>0,MAX(Reference!C20,Inputs!N25+1),MAX(Reference!C20,C25+1))))","v":87},{"$f":"IF(Inputs!D25<>0,\"N/A -- Case 2\",IF(Inputs!N25>0,MAX(D25-Inputs!N25,1),MAX(D25-C25,1))*Inputs!L25*5.39)","v":0},{"$f":"IF(Inputs!J25>(Inputs!C25*1.547),IF(Inputs!F25=0,\"0\", MIN(110,(((Inputs!L25*D25)-(Inputs!K25*(IF(Inputs!N25>0,Inputs!N25,C25))))/(Inputs!F25*1.547)))),IF(Inputs!J25<(Inputs!C25*1.547), \"Targ: \"& D25,0))","v":0},null,{"$f":"Inputs!F25","v":0},{"$f":"Inputs!I25","v":1},null," Jul  1-31      ",89]
[null," Aug  1-15     ",74,{"$f":"MIN(L26,(IF(Inputs!N26>0,MAX(Reference!C21,Inputs!N26+1),MAX(Reference!C21,C26+1))))","v":87},{"$f":"IF(Inputs!D26<>0,\"N/A -- Case 2\",IF(Inputs!N26>0,MAX(D26-Inputs!N26,1),MAX(D26-C26,1))*Inputs!L26*5.39)","v":0},{"$f":"IF(Inputs!J26>(Inputs!C26*1.547),IF(Inputs!F26=0,\"0\", MIN(110,(((Inputs!L26*D26)-(Inputs!K26*(IF(Inputs!N26>0,Inputs!N26,C26))))/(Inputs!F26*1.547)))),IF(Inputs!J26<(Inputs!C26*1.547), \"Targ: \"& D26,0))","v":0},null,{"$f":"Inputs!F26","v":0},{"$f":"Inputs!I26","v":1},null," Aug  1-15     ",89]
[null," Aug 16-31     ",74,{"$f":"MIN(L27,(IF(Inputs!N27>0,MAX(Reference!C22,Inputs!N27+1),MAX(Reference!C22,C27+1))))","v":87},{"$f":"IF(Inputs!D27<>0,\"N/A -- Case 2\",IF(Inputs!N27>0,MAX(D27-Inputs!N27,1),MAX(D27-C27,1))*Inputs!L27*5.39)","v":0},{"$f":"IF(Inputs!J27>(Inputs!C27*1.547),IF(Inputs!F27=0,\"0\", MIN(110,(((Inputs!L27*D27)-(Inputs!K27*(IF(Inputs!N27>0,Inputs!N27,C27))))/(Inputs!F27*1.547)))),IF(Inputs!J27<(Inputs!C27*1.547), \"Targ: \"& D27,0))","v":0},null,{"$f":"Inputs!F27","v":0},{"$f":"Inputs!I27","v":1},null," Aug 16-31     ",89]
[null," Sep  1-15     ",71,{"$f":"MIN(L28,(IF(Inputs!N28>0,MAX(Reference!C23,Inputs!N28+1),MAX(Reference!C23,C28+1))))","v":84},{"$f":"IF(Inputs!D28<>0,\"N/A -- Case 2\",IF(Inputs!N28>0,MAX(D28-Inputs!N28,1),MAX(D28-C28,1))*Inputs!L28*5.39)","v":0},{"$f":"IF(Inputs!J28>(Inputs!C28*1.547),IF(Inputs!F28=0,\"0\", MIN(110,(((Inputs!L28*D28)-(Inputs!K28*(IF(Inputs!N28>0,Inputs!N28,C28))))/(Inputs!F28*1.547)))),IF(Inputs!J28<(Inputs!C28*1.547), \"Targ: \"& D28,0))","v":0},null,{"$f":"Inputs!F28","v":0},{"$f":"Inputs!I28","v":1},null," Sep  1-15     ",87]
[null," Sep 16-30   ",65,{"$f":"MIN(L29,(IF(Inputs!N29>0,MAX(Reference!C24,Inputs!N29+1),MAX(Reference!C24,C29+1))))","v":78},{"$f":"IF(Inputs!D29<>0,\"N/A -- Case 2\",IF(Inputs!N29>0,MAX(D29-Inputs!N29,1),MAX(D29-C29,1))*Inputs!L29*5.39)","v":0},{"$f":"IF(Inputs!J29>(Inputs!C29*1.547),IF(Inputs!F29=0,\"0\", MIN(110,(((Inputs!L29*D29)-(Inputs!K29*(IF(Inputs!N29>0,Inputs!N29,C29))))/(Inputs!F29*1.547)))),IF(Inputs!J29<(Inputs!C29*1.547), \"Targ: \"& D29,0))","v":0},null,{"$f":"Inputs!F29","v":0},{"$f":"Inputs!I29","v":1},null," Sep 16-30   ",81]
[null," Oct  1-15    ",60,{"$f":"MIN(L30,(IF(Inputs!N30>0,MAX(Reference!C25,Inputs!N30+1),MAX(Reference!C25,C30+1))))","v":72},{"$f":"IF(Inputs!D30<>0,\"N/A -- Case 2\",IF(Inputs!N30>0,MAX(D30-Inputs!N30,1),MAX(D30-C30,1))*Inputs!L30*5.39)","v":0},{"$f":"IF(Inputs!J30>(Inputs!C30*1.547),IF(Inputs!F30=0,\"0\", MIN(110,(((Inputs!L30*D30)-(Inputs!K30*(IF(Inputs!N30>0,Inputs!N30,C30))))/(Inputs!F30*1.547)))),IF(Inputs!J30<(Inputs!C30*1.547), \"Targ: \"& D30,0))","v":0},null,{"$f":"Inputs!F30","v":0},{"$f":"Inputs!I30","v":1},null," Oct  1-15    ",74.099999999999994]
[null," Oct 16-31  ",54,{"$f":"MIN(L31,(IF(Inputs!N31>0,MAX(Reference!C26,Inputs!N31+1),MAX(Reference!C26,C31+1))))","v":66},{"$f":"IF(Inputs!D31<>0,\"N/A -- Case 2\",IF(Inputs!N31>0,MAX(D31-Inputs!N31,1),MAX(D31-C31,1))*Inputs!L31*5.39)","v":0},{"$f":"IF(Inputs!J31>(Inputs!C31*1.547),IF(Inputs!F31=0,\"0\", MIN(110,(((Inputs!L31*D31)-(Inputs!K31*(IF(Inputs!N31>0,Inputs!N31,C31))))/(Inputs!F31*1.547)))),IF(Inputs!J31<(Inputs!C31*1.547), \"Targ: \"& D31,0))","v":0},null,{"$f":"Inputs!F31","v":0},{"$f":"Inputs!I31","v":1},null," Oct 16-31  ",74.099999999999994]
[null," Nov  1-15     ",48,{"$f":"MIN(L32,(IF(Inputs!N32>0,MAX(Reference!C27,Inputs!N32+1),MAX(Reference!C27,C32+1))))","v":58},{"$f":"IF(Inputs!D32<>0,\"N/A -- Case 2\",IF(Inputs!N32>0,MAX(D32-Inputs!N32,1),MAX(D32-C32,1))*Inputs!L32*5.39)","v":0},{"$f":"IF(Inputs!J32>(Inputs!C32*1.547),IF(Inputs!F32=0,\"0\", MIN(110,(((Inputs!L32*D32)-(Inputs!K32*(IF(Inputs!N32>0,Inputs!N32,C32))))/(Inputs!F32*1.547)))),IF(Inputs!J32<(Inputs!C32*1.547), \"Targ: \"& D32,0))","v":0},null,{"$f":"Inputs!F32","v":0},{"$f":"Inputs!I32","v":1},null," Nov  1-15     ",65]
[null," Nov 16-30      ",42,{"$f":"MIN(L33,(IF(Inputs!N33>0,MAX(Reference!C28,Inputs!N33+1),MAX(Reference!C28,C33+1))))","v":50},{"$f":"IF(Inputs!D33<>0,\"N/A -- Case 2\",IF(Inputs!N33>0,MAX(D33-Inputs!N33,1),MAX(D33-C33,1))*Inputs!L33*5.39)","v":0},{"$f":"IF(Inputs!J33>(Inputs!C33*1.547),IF(Inputs!F33=0,\"0\", MIN(110,(((Inputs!L33*D33)-(Inputs!K33*(IF(Inputs!N33>0,Inputs!N33,C33))))/(Inputs!F33*1.547)))),IF(Inputs!J33<(Inputs!C33*1.547), \"Targ: \"& D33,0))","v":0},null,{"$f":"Inputs!F33","v":0},{"$f":"Inputs!I33","v":1},null," Nov 16-30      ",65]
[null," Dec  1-31     ",37,{"$f":"MIN(L34,(IF(Inputs!N34>0,MAX(Reference!C29,Inputs!N34+1),MAX(Reference!C29,C34+1))))","v":42},{"$f":"IF(Inputs!D34<>0,\"N/A -- Case 2\",IF(Inputs!N34>0,MAX(D34-Inputs!N34,1),MAX(D34-C34,1))*Inputs!L34*5.39)","v":0},{"$f":"IF(Inputs!J34>(Inputs!C34*1.547),IF(Inputs!F34=0,\"0\", MIN(110,(((Inputs!L34*D34)-(Inputs!K34*(IF(Inputs!N34>0,Inputs!N34,C34))))/(Inputs!F34*1.547)))),IF(Inputs!J34<(Inputs!C34*1.547), \"Targ: \"& D34,0))","v":0},null,{"$f":"Inputs!F34","v":0},{"$f":"Inputs!I34","v":1},null," Dec  1-31     ",55.8]

{"sheet":"Reference","index":7,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,1,34,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!$K$2","v":"Thermal Limits Spreadsheet"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!$K$3","v":"Version 1.0, April 2024"}]
[]
[]
[]
[]
[]
[]
[null,"Semi-Monthly","WWF Criteria","CWF Criteria","TSF Criteria",null,null,"Q7-10 Multipliers",null,"Default Ambient Stream Temperature (°F)"]
[null,"Increment","(ºF)","(ºF)","(ºF)",null,null,"(Default Values)",null,"WWF","CWF","TSF"]
[null," Jan  1-31  ",40,38,40,null,null,3.2,null,35,34,34]
[null," Feb  1-29   ",40,38,40,null,null,3.5,null,35,35,35]
[null," Mar  1-31  ",46,42,46,null,null,7,null,40,39,39]
[null," Apr  1-15",52,48,52,null,null,9.3000000000000007,null,47,46,46]
[null," Apr 16-30     ",58,52,58,null,null,9.3000000000000007,null,53,52,52]
[null," May  1-15   ",64,54,64,null,null,5.0999999999999996,null,58,55,56]
[null," May 16-31   ",72,58,68,null,null,5.0999999999999996,null,62,59,60]
[null," Jun  1-15     ",80,60,70,null,null,3,null,67,63,65]
[null," Jun 16-30",84,64,72,null,null,3,null,71,67,69]
[null," Jul  1-31      ",87,66,74,null,null,1.7,null,75,71,73]
[null," Aug  1-15     ",87,66,80,null,null,1.4,null,74,70,72]
[null," Aug 16-31     ",87,66,87,null,null,1.4,null,74,70,70]
[null," Sep  1-15     ",84,64,84,null,null,1.1000000000000001,null,71,66,68]
[null," Sep 16-30   ",78,60,78,null,null,1.1000000000000001,null,65,60,62]
[null," Oct  1-15    ",72,54,72,null,null,1.2,null,60,55,57]
[null," Oct 16-31  ",66,50,66,null,null,1.2,null,54,51,53]
[null," Nov  1-15     ",58,46,58,null,null,1.6,null,48,46,47]
[null," Nov 16-30      ",50,42,50,null,null,1.6,null,42,40,41]
[null," Dec  1-31     ",42,40,42,null,null,2.4,null,37,35,36]
[]
[]
[null,"NOTES:"]
[null,"WWF= Warm water fishes"]
[null,"CWF= Cold water fishes"]
[null,"TSF= Trout stocking"]
[null,"Default PMF = 1"]

{"sheet":"Versions","index":8,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Date","Version","Change(s)"]
["2024-04-03",1,"Original"]