{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1. ENTER DATA","2. RESULTS","3. CALCS_Loads","4. CALCS_Infiltration","5.CALCS_Adams&Papa","6. Error Checking"],"not_rendered":{"charts":9,"images":1,"macros":1,"external_links":0,"defined_names":90,"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":"1. ENTER DATA","index":0,"n_rows":69,"n_cols":25,"rows_kept":69,"cut":false,"hidden":false,"merged":[[59,13,62,16],[63,11,64,12],[23,11,24,12],[43,11,44,12],[61,11,62,12],[41,11,42,12],[40,13,42,16],[28,2,28,4],[48,2,48,8],[40,2,40,4],[29,2,29,4],[33,2,33,4],[44,2,44,4],[41,2,41,4],[45,2,45,4],[30,2,30,4],[31,2,31,4],[39,2,39,4],[35,2,35,4],[32,2,32,4],[34,2,34,4],[26,2,26,4],[23,2,23,4],[24,2,24,4],[27,2,27,4],[21,11,22,12],[25,2,25,4],[1,19,1,24],[21,2,21,4],[22,2,22,4],[11,2,11,3],[14,2,14,4],[10,2,10,8],[20,2,20,8],[20,13,22,16],[19,19,19,24]]}
["Row",null,null,"STORMWATER LOAD ANALYSIS TOOL 2.1"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Internal Lists"]
[{"$f":"A2+1","v":3}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BMP 1 Options","BMP 2 Options","Conveyance Options","WQV Options","Drainage areas","Infiltration Field Options"]
[5,null,null,null,null,null,null,null,null,null,null,"Simplified Schematic",null,null,null,null,null,null,null,"None","None","Pumped","Yes",1,"Irrigation"]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biofiltration","Infiltration Field","Gravity Drained","No",2,"Level spread"]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retention Basin","Beneficial Use",null,null,3,"N/A"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rainwater Harvesting","Alternative",null,null,4]
[9,null,"               KEY","Required User Input","Key User Input","Internal Calculation","Error","Calculator Output","Does Not Apply",null,null,null,null,null,null,null,null,null,null,"Sedimentation/Filtration",null,"Drawdown options","Splitter Options"]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternative",null,"Drawdown Time","Yes (Off-Line)"]
[11,null,"Step 1: Input site characteristics in yellow highlighted cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Rate","No (On-Line)"]
[12,null,"Site Name",null,null,"Editor Name",null,"Date","SLAT 2.1 - 08/2022"]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOR PLOTTING",null,null,"Infiltration Options","Infiltration Field Options"]
[14,null,"Is your site within the Barton Springs Zone (BSZ)? ",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,"Captions",null,null,"No; infiltrate all routed water","Yes","max rate"]
[15,null,"How many drainage areas, nmax, does your site have? ",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F14=\"Yes\",\"Existing\",\"Sed/Fil Equiv\")","v":"Existing"},"Developed, Untreated","Proposed","Yes","No; calculate area",{"$f":"IF(F14=\"Yes\",0.2,2)","v":0.2}]
[16,null,null,null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
[17,null,"Drainage area to the control, An (acres)",null,null,1,1,1,1,null,null,null,null,null,null,null,null,null,null,"Baseline Loads",null,null,"Compliance Factor"]
[18,null,"Base impervious cover of the drainage area, ICB (%)",null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compliance Factor (Compare to Baseline)"]
[19,null,"Developed impervious cover of the drainage area, ICD (%)",null,null,50,50,50,50,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compliance Factor (Compare to Sed/Fil)"]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read in for conditional formatting"]
[21,null,"Step 2: Input SCM characteristics in yellow highlighted cells",null,null,null,null,null,null,null,null,null,null,{"$f":"'2. RESULTS'!C40","v":""},null,null,null,null,null,"Error checking condition"]
[22,null,null,null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D",null,null,{"$f":"'2. RESULTS'!C16","v":"ERROR CHECK PASSED"},null,null,null,null,null,null,null,{"$f":"'6. Error Checking'!$G$29","v":2}]
[23,null,"SCM 1 (First in Series)",null,null,"SCM A1","SCM B1","SCM C1","SCM D1"]
[24,null,"SCM Type",null,null,"Retention Basin","Retention Basin","Retention Basin","Retention Basin",null,null,{"$f":"'2. RESULTS'!C18","v":"COMPLIANT"},null,"Results subject to review and approval"]
[25,null,"Is SCM 1 off-line?",null,null,"Yes (Off-Line)","Yes (Off-Line)","Yes (Off-Line)","Yes (Off-Line)",null,null,null,null,"by COA Development Services Department."]
[26,null,"What is the Water Quality Volume, WQV (inches) [aka Capture Depth]",null,null,2.5,2.5,2.5,2.5]
[27,null,"Minimum water quality volume allowed (in)",null,null,{"$f":"IF($F$14=\"Yes\",'3. CALCS_Loads'!C71,0)","v":0.8},{"$f":"IF($F$14=\"Yes\",'3. CALCS_Loads'!D71,0)","v":0.8},{"$f":"IF($F$14=\"Yes\",'3. CALCS_Loads'!E71,0)","v":0.8},{"$f":"IF($F$14=\"Yes\",'3. CALCS_Loads'!F71,0)","v":0.8}]
[28,null,"SCM 1 Actual Volume (ft3)",null,null,{"$f":"WQV_A1*DA_A*3630","v":9075},{"$f":"WQV_B1*DA_B*3630","v":9075},{"$f":"WQV_C1*DA_C*3630","v":9075},{"$f":"WQV_D1*DA_D*3630","v":9075}]
[29,null,"Do you know the drawdown time or the flow rate? ",null,null,"Drawdown Time","Drawdown Time","Drawdown Time","Drawdown Time"]
[30,null,"Drawdown Time, DDT (hrs)   [tot. time to empty full SCM 1]",null,null,60,60,60,60]
[31,null,"Flow Rate (gpm)   [use only for \"alternative\" controls]",null,null,15.08,15.08,15.08,15.08]
[32,null,"Treatment Rate, Ω (in/hr)",null,null,{"$f":"'5.CALCS_Adams&Papa'!B28","v":4.1666666666666664E-2},{"$f":"'5.CALCS_Adams&Papa'!C28","v":4.1666666666666664E-2},{"$f":"'5.CALCS_Adams&Papa'!D28","v":4.1666666666666664E-2},{"$f":"'5.CALCS_Adams&Papa'!E28","v":4.1666666666666664E-2}]
[33,null,"Do you already know the runoff capture efficiency? ",null,null,"No","No","No","No"]
[34,null,"User Entered Runoff Capture Efficiency, RCE (%)",null,null,0,0,0,0]
[35,null,"Runoff Capture Efficiency, RCE (%)",null,null,{"$f":"RCE_A1","v":0.98105345153995205},{"$f":"RCE_B1","v":0},{"$f":"RCE_C1","v":0},{"$f":"RCE_D1","v":0}]
[36,null,"Conveyance"]
[37,null,"How is effluent from SCM 1 discharged?",null,null,"Pumped","Pumped","Pumped","Pumped"]
[38,null,"Delay after end of rainfall before discharging SCM 1 (hrs)",null,null,{"$f":"IF(F37=\"Pumped\",12,0)","v":12},{"$f":"IF(G37=\"Pumped\",12,0)","v":12},12,12]
[39]
[40,null,"SCM 2 (Second in Series)",null,null,"SCM A2","SCM B2","SCM C2","SCM D2"]
[41,null,"SCM Type",null,null,"Infiltration Field","Infiltration Field","Infiltration Field","Infiltration Field",null,null,null,null,{"$f":"N21","v":""}]
[42,null,"Do you know the infiltrated or reused water quantity?",null,null,"No; infiltrate all routed water","No; infiltrate all routed water","No; infiltrate all routed water","No; infiltrate all routed water",null,null,{"$f":"'2. RESULTS'!C16","v":"ERROR CHECK PASSED"}]
[43,null,"User-entered infilt. water quality volume, WQVinf (in)",null,null,2.5,2.5,2.5,2.5]
[44,null,"-OR- Percent of yearly runoff infiltrated, RCEinf (%)",null,null,0,0,0,0,null,null,{"$f":"L24","v":"COMPLIANT"},null,"Results subject to review and approval"]
[45,null,"Soil infiltration rate (in/hr)",null,null,0.1,0.1,0.1,0.1,null,null,null,null,"by COA Development Services Department."]
[46,null,"Ratio of drawdown time / irrigation time, for any zone",null,null,{"$f":"IF(F37=\"Pumped\",2,1)","v":2},{"$f":"IF(G37=\"Pumped\",2,1)","v":2},{"$f":"IF(H37=\"Pumped\",2,1)","v":2},{"$f":"IF(I37=\"Pumped\",2,1)","v":2}]
[47,null,"Approximate Minimum Field Area (Ac)",null,null,{"$f":"'4. CALCS_Infiltration'!C25","v":0.83333333333333337},{"$f":"'4. CALCS_Infiltration'!D25","v":0},{"$f":"'4. CALCS_Infiltration'!E25","v":0},{"$f":"'4. CALCS_Infiltration'!F25","v":0}]
[48]
[49,null,"Step 3: Input Effluent Data for Alternative SCMs"]
[50]
[51,null,null,null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
[52,null,null,"Pollutant","Units",{"$f":"F24","v":"Retention Basin"},{"$f":"G24","v":"Retention Basin"},{"$f":"H24","v":"Retention Basin"},{"$f":"I24","v":"Retention Basin"}]
[53,null,null,"COD","mg/L"]
[54,null,null,"E. coli","CFU/100mL"]
[55,null,null,"Pb","mg/L"]
[56,null,null,"TN","mg/L"]
[57,null,null,"TP","mg/L"]
[58,null,null,"TSS","mg/L"]
[59,null,null,"Zn","mg/L"]
[60,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. RESULTS'!C40","v":""}]
[61,null,null,"Pollutant","Units",{"$f":"F41","v":"Infiltration Field"},{"$f":"G41","v":"Infiltration Field"},{"$f":"H41","v":"Infiltration Field"},{"$f":"I41","v":"Infiltration Field"}]
[62,null,null,"COD","mg/L",null,null,null,null,null,null,{"$f":"'2. RESULTS'!C16","v":"ERROR CHECK PASSED"}]
[63,null,null,"E. coli","CFU/100mL"]
[64,null,null,"Pb","mg/L",null,null,null,null,null,null,{"$f":"L44","v":"COMPLIANT"},null,"Results subject to review and approval"]
[65,null,null,"TN","mg/L",null,null,null,null,null,null,null,null,"by COA Development Services Department."]
[{"$f":"A65+1","v":66},null,null,"TP","mg/L"]
[67,null,null,"TSS","mg/L"]
[68,null,null,"Zn","mg/L"]
[69]

{"sheet":"2. RESULTS","index":1,"n_rows":43,"n_cols":26,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,2,41,8],[38,0,38,2],[27,6,28,6],[33,6,34,6],[5,2,5,6],[26,0,26,2],[23,0,23,1],[15,2,16,3],[17,2,19,3],[36,0,36,2],[35,0,35,2],[33,0,34,2],[30,0,30,2],[29,0,29,2],[32,0,32,2],[37,0,37,2],[3,25,3,30],[5,9,6,9],[33,5,34,5],[25,0,25,2],[27,5,28,5],[27,4,28,4],[33,7,34,7],[27,3,28,3],[27,0,28,2],[31,0,31,2],[5,8,6,8],[33,4,34,4],[33,3,34,3],[5,0,6,1],[5,7,6,7],[27,7,28,7]]}
[null,null,{"$f":"'1. ENTER DATA'!D1","v":"STORMWATER LOAD ANALYSIS TOOL 2.1"},null,null,null,null,null,null,"1/2",null,null,{"$f":"C1","v":"STORMWATER LOAD ANALYSIS TOOL 2.1"},null,null,null,null,null,"2/2"]
["Site Name:",{"$f":"'1. ENTER DATA'!C12","v":"Site Name"},null,null,"By:",{"$f":"'1. ENTER DATA'!F12","v":"Editor Name"},null,"Date:",{"$f":"'1. ENTER DATA'!H12","v":"Date"},null,"Site Name:",{"$f":"B2","v":"Site Name"},null,null,"By:",{"$f":"F2","v":"Editor Name"},null,"Date:",{"$f":"I2","v":"Date"}]
["RESULTS: COMPLIANCE TABLE",null,null,null,null,null,null,{"$f":"'1. ENTER DATA'!I12","v":"SLAT 2.1 - 08/2022"},null,null,"RESULTS: PLOTS",null,null,null,null,null,{"$f":"'1. ENTER DATA'!I12","v":"SLAT 2.1 - 08/2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read in for conditional formatting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Error checking condition"]
["POLLUTANT",null,"DEVELOPED LOAD, WITH CONTROLS",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F14=\"Yes\",\"EXISTING LOAD\",\"SED/FIL LOAD\")","v":"EXISTING LOAD"},"LOAD EQUIV. FACTOR, LEF","COMPLIES?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'6. Error Checking'!$G$29","v":2}]
[null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","TOTAL LOAD, Lout"]
["COD","lbs/yr",{"$f":"'3. CALCS_Loads'!AD153","v":1.2512593067632269},{"$f":"'3. CALCS_Loads'!AE153","v":0},{"$f":"'3. CALCS_Loads'!AF153","v":0},{"$f":"'3. CALCS_Loads'!AG153","v":0},{"$f":"SUM(C8:F8)","v":1.2512593067632269},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AH153,'3. CALCS_Loads'!AI153)","v":11.487751514525895},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AL153,'3. CALCS_Loads'!AM153)","v":0.10892116748704475},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AN153,'3. CALCS_Loads'!AO153)","v":"YES"}]
["E. coli","10^6 MPN/yr",{"$f":"'3. CALCS_Loads'!AD154","v":1871.0332495062835},{"$f":"'3. CALCS_Loads'!AE154","v":0},{"$f":"'3. CALCS_Loads'!AF154","v":0},{"$f":"'3. CALCS_Loads'!AG154","v":0},{"$f":"SUM(C9:F9)","v":1871.0332495062835},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AH154,'3. CALCS_Loads'!AI154)","v":11210.216427389736},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AL154,'3. CALCS_Loads'!AM154)","v":0.16690429320658065},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AN154,'3. CALCS_Loads'!AO154)","v":"YES"}]
["Pb","lbs/yr",{"$f":"'3. CALCS_Loads'!AD155","v":2.6342159422357997E-4},{"$f":"'3. CALCS_Loads'!AE155","v":0},{"$f":"'3. CALCS_Loads'!AF155","v":0},{"$f":"'3. CALCS_Loads'!AG155","v":0},2.6342159422357997E-4,{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AH155,'3. CALCS_Loads'!AI155)","v":1.2648339263936867E-3},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AL155,'3. CALCS_Loads'!AM155)","v":0.20826575625991589},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AN155,'3. CALCS_Loads'!AO155)","v":"YES"}]
["TN","lbs/yr",{"$f":"'3. CALCS_Loads'!AD156","v":6.7007581424196438E-2},{"$f":"'3. CALCS_Loads'!AE156","v":0},{"$f":"'3. CALCS_Loads'!AF156","v":0},{"$f":"'3. CALCS_Loads'!AG156","v":0},6.7007581424196438E-2,{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AH156,'3. CALCS_Loads'!AI156)","v":0.35142478926184617},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AL156,'3. CALCS_Loads'!AM156)","v":0.19067403174643202},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AN156,'3. CALCS_Loads'!AO156)","v":"YES"}]
["TP","lbs/yr",{"$f":"'3. CALCS_Loads'!AD157","v":8.4002021293228014E-3},{"$f":"'3. CALCS_Loads'!AE157","v":0},{"$f":"'3. CALCS_Loads'!AF157","v":0},{"$f":"'3. CALCS_Loads'!AG157","v":0},8.4002021293228014E-3,{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AH157,'3. CALCS_Loads'!AI157)","v":3.6619053670982289E-2},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AL157,'3. CALCS_Loads'!AM157)","v":0.22939429852004337},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AN157,'3. CALCS_Loads'!AO157)","v":"YES"}]
["TSS","lbs/yr",{"$f":"'3. CALCS_Loads'!AD158","v":0.96213595743452507},{"$f":"'3. CALCS_Loads'!AE158","v":0},{"$f":"'3. CALCS_Loads'!AF158","v":0},{"$f":"'3. CALCS_Loads'!AG158","v":0},0.96213595743452507,{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AH158,'3. CALCS_Loads'!AI158)","v":49.022281527282743},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AL158,'3. CALCS_Loads'!AM158)","v":1.9626503040236106E-2},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AN158,'3. CALCS_Loads'!AO158)","v":"YES"}]
["Zn","lbs/yr",{"$f":"'3. CALCS_Loads'!AD159","v":1.6672081976681118E-3},{"$f":"'3. CALCS_Loads'!AE159","v":0},{"$f":"'3. CALCS_Loads'!AF159","v":0},{"$f":"'3. CALCS_Loads'!AG159","v":0},1.6672081976681118E-3,{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AH159,'3. CALCS_Loads'!AI159)","v":6.9590967722314339E-3},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AL159,'3. CALCS_Loads'!AM159)","v":0.23957249801737152},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!AN159,'3. CALCS_Loads'!AO159)","v":"YES"}]
[]
[null,null,{"$f":"'6. Error Checking'!G33","v":"ERROR CHECK PASSED"}]
[]
[null,"Results subject to review and ",{"$f":"IF('6. Error Checking'!G29=1,\"NOT COMPLIANT\",IF(I8<=1,IF(I9<=1,IF(I10<=1,IF(I11<=1,IF(I12<=1,IF(I13<=1,IF(I14<=1,\"COMPLIANT\",\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"))","v":"COMPLIANT"}]
[null,"approval by COA Develop-"]
[null,"ment Services Department."]
[]
["SUMMARY OF INPUTS"]
[]
["Site Location",null,null,{"$f":"IF('1. ENTER DATA'!F14=\"Yes\", \"Within Barton Springs Zone - Compare to Existing Loads\",\"Outside Barton Springs Zone - Compare to Sed/Fil Loads\")","v":"Within Barton Springs Zone - Compare to Existing Loads"}]
[null,null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","TOTALS"]
["Drainage Area, An (Ac)",null,null,{"$f":"DA_A","v":1},{"$f":"IF(n_DA=1,\"N/A\",DA_B)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",DA_C)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",DA_D)","v":"N/A"},{"$f":"SUM(D26:G26)","v":1}]
["Developed IC, ICD (%)",null,null,{"$f":"ICA_d","v":50},{"$f":"IF(n_DA=1,\"N/A\",ICB_d)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",ICC_d)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",ICD_d)","v":"N/A"},{"$f":"(D27*D26+IF(n_DA>1,E27*E26,0)+IF(n_DA>2,F27*F26,0)+IF(n_DA>3,G27*G26,0))/(100*H26)","v":0.5}]
["SCM 1",null,null,{"$f":"'1. ENTER DATA'!F24","v":"Retention Basin"},{"$f":"IF(n_DA=1,\"N/A\",'1. ENTER DATA'!G24)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",'1. ENTER DATA'!H24)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",'1. ENTER DATA'!I24)","v":"N/A"},"-"]
[]
["Water Qual. Vol, WQV (in)",null,null,{"$f":"WQV_A1","v":2.5},{"$f":"IF(n_DA=1,\"N/A\",WQV_B1)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",WQV_C1)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",WQV_D1)","v":"N/A"},"-"]
["Actual Volume (ft3)",null,null,{"$f":"D30*D26/12*43560","v":9075},{"$f":"IF(n_DA=1,\"N/A\",E30*E26/12*43560)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",F30*F26/12*43560)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",G30*G26/12*43560)","v":"N/A"},{"$f":"SUM(D31:G31)","v":9075}]
["Drawdown Time, DDT (hrs)",null,null,{"$f":"IF('1. ENTER DATA'!F$29=\"Drawdown Time\", DDT_A1, \"N/A\")","v":60},{"$f":"IF(n_DA=1,\"N/A\",IF('1. ENTER DATA'!G$29=\"Drawdown Time\", DDT_B1, \"N/A\"))","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",IF('1. ENTER DATA'!H$29=\"Drawdown Time\", DDT_C1, \"N/A\"))","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",IF('1. ENTER DATA'!I$29=\"Drawdown Time\", DDT_D1, \"N/A\"))","v":"N/A"},"-"]
["Flowrate (gpm)",null,null,{"$f":"'5.CALCS_Adams&Papa'!B29","v":18.855833333333333},{"$f":"IF(n_DA=1,\"N/A\",'5.CALCS_Adams&Papa'!C29)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",'5.CALCS_Adams&Papa'!D29)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",'5.CALCS_Adams&Papa'!E29)","v":"N/A"},"-"]
["SCM 2",null,null,{"$f":"'3. CALCS_Loads'!C85","v":"Infiltration Field"},{"$f":"IF(n_DA=1,\"N/A\",'3. CALCS_Loads'!D85)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",'3. CALCS_Loads'!E85)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",'3. CALCS_Loads'!F85)","v":"N/A"},"-"]
[]
["Infiltration Rate (in/hr)",null,null,{"$f":"IF(D34<>\"Infiltration Field\",\"N/A\",'1. ENTER DATA'!F45)","v":0.1},{"$f":"IF(E34<>\"Infiltration Field\",\"N/A\",IF(n_DA=1,\"N/A\",'1. ENTER DATA'!G45))","v":"N/A"},{"$f":"IF(F34<>\"Infiltration Field\",\"N/A\",IF(n_DA<3,\"N/A\",'1. ENTER DATA'!H45))","v":"N/A"},{"$f":"IF(G34<>\"Infiltration Field\",\"N/A\",IF(n_DA<4,\"N/A\",'1. ENTER DATA'!I45))","v":"N/A"},"-"]
["Appx. Min. Infilt. Field Area (Ac)",null,null,{"$f":"IF(D34<>\"Infiltration Field\",\"N/A\",'4. CALCS_Infiltration'!C25)","v":0.83333333333333337},{"$f":"IF(E34<>\"Infiltration Field\",\"N/A\",IF(n_DA=1,\"N/A\",'4. CALCS_Infiltration'!D25))","v":"N/A"},{"$f":"IF(F34<>\"Infiltration Field\",\"N/A\",IF(n_DA<3,\"N/A\",'4. CALCS_Infiltration'!E25))","v":"N/A"},{"$f":"IF(G34<>\"Infiltration Field\",\"N/A\",IF(n_DA<4,\"N/A\",'4. CALCS_Infiltration'!F25))","v":"N/A"},{"$f":"SUM(D37:G37)","v":0.83333333333333337}]
["Irrigation Rate (gpm)",null,null,{"$f":"IF(D34<>\"Infiltration Field\",\"N/A\",'4. CALCS_Infiltration'!C28)","v":18.854166666666664},{"$f":"IF(E34<>\"Infiltration Field\",\"N/A\",'4. CALCS_Infiltration'!D28)","v":"N/A"},{"$f":"IF(F34<>\"Infiltration Field\",\"N/A\",'4. CALCS_Infiltration'!E28)","v":"N/A"},{"$f":"IF(G34<>\"Infiltration Field\",\"N/A\",'4. CALCS_Infiltration'!F28)","v":"N/A"},"-"]
["Error with Input Values?",null,null,{"$f":"IF('6. Error Checking'!G23>0,\"YES\",IF('6. Error Checking'!$D$2=\"No\",\"Not Checked\",\"NO\"))","v":"NO"},{"$f":"IF('6. Error Checking'!H23>0,\"YES\",IF('6. Error Checking'!$D$2=\"No\",\"Not Checked\",\"NO\"))","v":"NO"},{"$f":"IF('6. Error Checking'!I23>0,\"YES\",IF('6. Error Checking'!$D$2=\"No\",\"Not Checked\",\"NO\"))","v":"NO"},{"$f":"IF('6. Error Checking'!J23>0,\"YES\",IF('6. Error Checking'!$D$2=\"No\",\"Not Checked\",\"NO\"))","v":"NO"}]
[null,null,{"$f":"'6. Error Checking'!G34","v":""}]
[]
[]
[null,null,"Results subject to review and approval by COA Development Services Department."]

{"sheet":"3. CALCS_Loads","index":2,"n_rows":193,"n_cols":41,"rows_kept":193,"cut":false,"hidden":false,"merged":[[184,0,185,1],[184,2,184,6],[184,7,184,11],[184,12,185,12],[184,13,185,13],[15,8,15,11],[15,3,15,7],[149,40,151,40],[149,39,151,39],[150,17,150,20],[150,29,150,32],[149,36,150,36],[149,35,150,35],[150,25,150,28],[149,37,150,37],[149,38,150,38],[40,0,42,0],[149,34,150,34],[149,33,150,33],[40,16,40,17],[40,18,40,19],[40,20,40,21],[150,21,150,24],[150,13,150,16],[150,9,150,12],[150,5,150,8],[150,1,150,4],[57,0,61,0],[62,0,66,0]]}
["CALCULATIONS"]
[]
[]
[]
[]
["CONSTANTS"]
[33.4,"R, annual rainfall, in/yr",null,null,"Based on 2018 WPD Report CR-18-05 Updating the City of Austin Rainfall Period of Record Timeseries and Statistics. Uses 2004-2013 Camp Mabry rainfall data. "]
[76.8,"Annual no. rainfall events, θ, events/yr"]
[]
["CONVERSION FACTORS"]
["CF_1","Pollutant in mg/L",0.22670000000000001,"lb-L/(mg-Ac-in)","Outputs to lb/Ac-yr"]
["CF_2","Pollutant in MPN/100 mL",1.0279,"100 mL/(Ac-in)","Outputs to 10^6 MPN/Ac-yr"]
[]
["ECM TABLE 1.10: Pollutant Concentrations"]
["From CM-09-04, Table 4.8"]
[null,null,null,"EXISTING",null,null,null,null,"DEVELOPED"]
["Pollutant","Units","Conversion Factor","Undeveloped (0% IC) Concentration","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
["COD","mg/L","CF_1",{"$f":"38.9+66.6*0/100","v":38.9},{"$f":"38.9+66.6*ICA_b/100","v":38.9},{"$f":"38.9+66.6*ICB_b/100","v":38.9},{"$f":"38.9+66.6*ICC_b/100","v":38.9},{"$f":"38.9+66.6*ICD_b/100","v":38.9},{"$f":"38.9+66.6*ICA_d/100","v":72.199999999999989},{"$f":"38.9+66.6*ICB_d/100","v":72.199999999999989},{"$f":"38.9+66.6*ICC_d/100","v":72.199999999999989},{"$f":"38.9+66.6*ICD_d/100","v":72.199999999999989},"*Function of IC"]
["E. coli","CFU/100mL","CF_2",8372,{"$f":"IF(ICA_b=0,$D19,$I19)","v":8372},{"$f":"IF(ICB_b=0,$D19,$I19)","v":8372},{"$f":"IF(ICC_b=0,$D19,$I19)","v":8372},{"$f":"IF(ICD_b=0,$D19,$I19)","v":8372},24963,24963,24963,24963]
["Pb","mg/L","CF_1",{"$f":"(4.283*EXP(2.424*0/100))/1000","v":4.2830000000000003E-3},{"$f":"(4.283*EXP(2.424*ICA_b/100))/1000","v":4.2830000000000003E-3},{"$f":"(4.283*EXP(2.424*ICB_b/100))/1000","v":4.2830000000000003E-3},{"$f":"(4.283*EXP(2.424*ICC_b/100))/1000","v":4.2830000000000003E-3},{"$f":"(4.283*EXP(2.424*ICD_b/100))/1000","v":4.2830000000000003E-3},{"$f":"(4.283*EXP(2.424*ICA_d/100))/1000","v":1.439172946151095E-2},{"$f":"(4.283*EXP(2.424*ICB_d/100))/1000","v":1.439172946151095E-2},{"$f":"(4.283*EXP(2.424*ICC_d/100))/1000","v":1.439172946151095E-2},{"$f":"(4.283*EXP(2.424*ICD_d/100))/1000","v":1.439172946151095E-2},"*Function of IC"]
["TN","mg/L","CF_1",1.19,{"$f":"IF(ICA_b=0,$D21,$I21)","v":1.19},{"$f":"IF(ICB_b=0,$D21,$I21)","v":1.19},{"$f":"IF(ICC_b=0,$D21,$I21)","v":1.19},{"$f":"IF(ICD_b=0,$D21,$I21)","v":1.19},2.2200000000000002,2.2200000000000002,2.2200000000000002,2.2200000000000002]
["TP","mg/L","CF_1",0.124,{"$f":"IF(ICA_b=0,$D22,$I22)","v":0.124},{"$f":"IF(ICB_b=0,$D22,$I22)","v":0.124},{"$f":"IF(ICC_b=0,$D22,$I22)","v":0.124},{"$f":"IF(ICD_b=0,$D22,$I22)","v":0.124},0.39600000000000002,0.39600000000000002,0.39600000000000002,0.39600000000000002]
["TSS","mg/L","CF_1",166,{"$f":"$D23","v":166},{"$f":"$D23","v":166},{"$f":"$D23","v":166},{"$f":"$D23","v":166},166,166,166,166]
["Zn","mg/L","CF_1",{"$f":"(23.565*EXP(2.179*0/100))/1000","v":2.3565000000000003E-2},{"$f":"(23.565*EXP(2.179*ICA_b/100))/1000","v":2.3565000000000003E-2},{"$f":"(23.565*EXP(2.179*ICB_b/100))/1000","v":2.3565000000000003E-2},{"$f":"(23.565*EXP(2.179*ICC_b/100))/1000","v":2.3565000000000003E-2},{"$f":"(23.565*EXP(2.179*ICD_b/100))/1000","v":2.3565000000000003E-2},{"$f":"(23.565*EXP(2.179*ICA_d/100))/1000","v":7.0053732895324725E-2},{"$f":"(23.565*EXP(2.179*ICB_d/100))/1000","v":7.0053732895324725E-2},{"$f":"(23.565*EXP(2.179*ICC_d/100))/1000","v":7.0053732895324725E-2},{"$f":"(23.565*EXP(2.179*ICD_d/100))/1000","v":7.0053732895324725E-2},"*Function of IC"]
[]
["ECM TABLE 1.11: Treated Surface Effluent Concentrations"]
["Source: Glick et all. Impacts of Stormwater Control Measures on Water Quality in Austin, TX. CM-13-02. City of Austin Watershed Protection Department: September 2013."]
["Pollutant","Units","Biofiltration","Rainwater Harvesting","Retention Basin","Sedimentation/Filtration","Wet Pond"]
["COD","mg/L",22.4,43.79,43.79,22.4,31.58]
["E. coli","CFU/100mL",4895,11065,11065,4895,12138]
["Pb","mg/L",5.7400000000000003E-3,8.3099999999999997E-3,8.3099999999999997E-3,5.7400000000000003E-3,9.9399999999999992E-3]
["TN","mg/L",1.07,1.42,1.42,1.07,1.24]
["TP","mg/L",9.9000000000000005E-2,0.224,0.224,9.9000000000000005E-2,0.21099999999999999]
["TSS","mg/L",20.62,133.80000000000001,133.80000000000001,20.62,44.6]
["Zn","mg/L",2.3E-2,4.53E-2,4.53E-2,2.3E-2,4.3880000000000002E-2]
[null,null,"*Sand or bio, equal to sed/fil","*Equal to Sedimentation","*Equal to Sedimentation"]
[]
["ECM TABLE 1.12: Bypass Concentrations As a Function of Runoff Captured"]
[]
[null,null,"Drainage Area A","Drainage Area A","Drainage Area B","Drainage Area B","Drainage Area C","Drainage Area C","Drainage Area D","Drainage Area D","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
["Pollutant",null,{"$f":"'1. ENTER DATA'!F52","v":"Retention Basin"},{"$f":"C41","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!G52","v":"Retention Basin"},{"$f":"E41","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!H52","v":"Retention Basin"},{"$f":"G41","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!I52","v":"Retention Basin"},{"$f":"I41","v":"Retention Basin"},"Sed/Fil Equivalent",{"$f":"K41","v":"Sed/Fil Equivalent"},{"$f":"K41","v":"Sed/Fil Equivalent"},{"$f":"K41","v":"Sed/Fil Equivalent"}]
[null,"WQV",{"$f":"WQV_A1","v":2.5},{"$f":"WQV_A1","v":2.5},{"$f":"WQV_B1","v":2.5},{"$f":"WQV_B1","v":2.5},{"$f":"WQV_C1","v":2.5},{"$f":"WQV_C1","v":2.5},{"$f":"WQV_D1","v":2.5},{"$f":"WQV_D1","v":2.5},{"$f":"C71","v":0.8},{"$f":"D71","v":0.8},0.8,0.8]
[null,"Method","Yes (Off-Line)","No (On-Line)",{"$f":"C43","v":"Yes (Off-Line)"},{"$f":"D43","v":"No (On-Line)"},{"$f":"C43","v":"Yes (Off-Line)"},{"$f":"D43","v":"No (On-Line)"},{"$f":"C43","v":"Yes (Off-Line)"},{"$f":"D43","v":"No (On-Line)"},{"$f":"$E$43","v":"Yes (Off-Line)"},{"$f":"$E$43","v":"Yes (Off-Line)"},{"$f":"$E$43","v":"Yes (Off-Line)"},{"$f":"$E$43","v":"Yes (Off-Line)"}]
["COD","mg/L",{"$f":"IF(C$42>0.0053,EXP(4.493-0.5104*C$42),EXP(5.6158-212.362*C$42))","v":24.953148334792502},{"$f":"IF(D$42>0.0053,EXP(4.9161-0.5447*D$42),EXP(6.1257-228.771*D$42))","v":34.965085274290395},{"$f":"IF(E$42>0.0053,EXP(4.493-0.5104*E$42),EXP(5.6158-212.362*E$42))","v":24.953148334792502},{"$f":"IF(F$42>0.0053,EXP(4.9161-0.5447*F$42),EXP(6.1257-228.771*F$42))","v":34.965085274290395},{"$f":"IF(G$42>0.0053,EXP(4.493-0.5104*G$42),EXP(5.6158-212.362*G$42))","v":24.953148334792502},{"$f":"IF(H$42>0.0053,EXP(4.9161-0.5447*H$42),EXP(6.1257-228.771*H$42))","v":34.965085274290395},{"$f":"IF(I$42>0.0053,EXP(4.493-0.5104*I$42),EXP(5.6158-212.362*I$42))","v":24.953148334792502},{"$f":"IF(J$42>0.0053,EXP(4.9161-0.5447*J$42),EXP(6.1257-228.771*J$42))","v":34.965085274290395},{"$f":"IF(K$42>0.0053,EXP(4.493-0.5104*K$42),EXP(5.6158-212.362*K$42))","v":59.422919374266115},{"$f":"IF(L$42>0.0053,EXP(4.493-0.5104*L$42),EXP(5.6158-212.362*L$42))","v":59.422919374266115},{"$f":"IF(M$42>0.0053,EXP(4.493-0.5104*M$42),EXP(5.6158-212.362*M$42))","v":59.422919374266115},{"$f":"IF(N$42>0.0053,EXP(4.493-0.5104*N$42),EXP(5.6158-212.362*N$42))","v":59.422919374266115}]
["E. coli","CFU/100mL",{"$f":"IF(C$42>0.0091,EXP(10.1772-0.4647*C$42),EXP(10.4384-29.1718*C$42))","v":8229.24868738228},{"$f":"IF(D$42>0.0091,EXP(10.7915-0.6241*D$42),EXP(11.4771-75.97*D$42))","v":10211.297659526826},{"$f":"IF(E$42>0.0091,EXP(10.1772-0.4647*E$42),EXP(10.4384-29.1718*E$42))","v":8229.24868738228},{"$f":"IF(F$42>0.0091,EXP(10.7915-0.6241*F$42),EXP(11.4771-75.97*F$42))","v":10211.297659526826},{"$f":"IF(G$42>0.0091,EXP(10.1772-0.4647*G$42),EXP(10.4384-29.1718*G$42))","v":8229.24868738228},{"$f":"IF(H$42>0.0091,EXP(10.7915-0.6241*H$42),EXP(11.4771-75.97*H$42))","v":10211.297659526826},{"$f":"IF(I$42>0.0091,EXP(10.1772-0.4647*I$42),EXP(10.4384-29.1718*I$42))","v":8229.24868738228},{"$f":"IF(J$42>0.0091,EXP(10.7915-0.6241*J$42),EXP(11.4771-75.97*J$42))","v":10211.297659526826},{"$f":"IF(K$42>0.0091,EXP(10.1772-0.4647*K$42),EXP(10.4384-29.1718*K$42))","v":18132.115826484594},{"$f":"IF(L$42>0.0091,EXP(10.1772-0.4647*L$42),EXP(10.4384-29.1718*L$42))","v":18132.115826484594},{"$f":"IF(M$42>0.0091,EXP(10.1772-0.4647*M$42),EXP(10.4384-29.1718*M$42))","v":18132.115826484594},{"$f":"IF(N$42>0.0091,EXP(10.1772-0.4647*N$42),EXP(10.4384-29.1718*N$42))","v":18132.115826484594}]
["Pb","mg/L",{"$f":"IF(C$42>0.014,EXP(2.8821-0.4893*C$42),EXP(3.6322-54.0678*C$42))/1000","v":5.2532661133623381E-3},{"$f":"IF(D$42>0.014,EXP(3.5221-0.5291*D$42),EXP(4.2534-52.7676*D$42))/1000","v":9.0191491467805744E-3},{"$f":"IF(E$42>0.014,EXP(2.8821-0.4893*E$42),EXP(3.6322-54.0678*E$42))/1000","v":5.2532661133623381E-3},{"$f":"IF(F$42>0.014,EXP(3.5221-0.5291*F$42),EXP(4.2534-52.7676*F$42))/1000","v":9.0191491467805744E-3},{"$f":"IF(G$42>0.014,EXP(2.8821-0.4893*G$42),EXP(3.6322-54.0678*G$42))/1000","v":5.2532661133623381E-3},{"$f":"IF(H$42>0.014,EXP(3.5221-0.5291*H$42),EXP(4.2534-52.7676*H$42))/1000","v":9.0191491467805744E-3},{"$f":"IF(I$42>0.014,EXP(2.8821-0.4893*I$42),EXP(3.6322-54.0678*I$42))/1000","v":5.2532661133623381E-3},{"$f":"IF(J$42>0.014,EXP(3.5221-0.5291*J$42),EXP(4.2534-52.7676*J$42))/1000","v":9.0191491467805744E-3},{"$f":"IF(K$42>0.014,EXP(2.8821-0.4893*K$42),EXP(3.6322-54.0678*K$42))/1000","v":1.2069239190208175E-2},{"$f":"IF(L$42>0.014,EXP(2.8821-0.4893*L$42),EXP(3.6322-54.0678*L$42))/1000","v":1.2069239190208175E-2},{"$f":"IF(M$42>0.014,EXP(2.8821-0.4893*M$42),EXP(3.6322-54.0678*M$42))/1000","v":1.2069239190208175E-2},{"$f":"IF(N$42>0.014,EXP(2.8821-0.4893*N$42),EXP(3.6322-54.0678*N$42))/1000","v":1.2069239190208175E-2}]
["TN","mg/L",{"$f":"IF(C$42>0.0145,EXP(0.9574-0.267*C$42),EXP(1.8156-59.4508*C$42))","v":1.3362938519585843},{"$f":"IF(D$42>0.0145,EXP(1.3219-0.2364*D$42),EXP(2.2217-62.2914*D$42))","v":2.0769490208808548},{"$f":"IF(E$42>0.0145,EXP(0.9574-0.267*E$42),EXP(1.8156-59.4508*E$42))","v":1.3362938519585843},{"$f":"IF(F$42>0.0145,EXP(1.3219-0.2364*F$42),EXP(2.2217-62.2914*F$42))","v":2.0769490208808548},{"$f":"IF(G$42>0.0145,EXP(0.9574-0.267*G$42),EXP(1.8156-59.4508*G$42))","v":1.3362938519585843},{"$f":"IF(H$42>0.0145,EXP(1.3219-0.2364*H$42),EXP(2.2217-62.2914*H$42))","v":2.0769490208808548},{"$f":"IF(I$42>0.0145,EXP(0.9574-0.267*I$42),EXP(1.8156-59.4508*I$42))","v":1.3362938519585843},{"$f":"IF(J$42>0.0145,EXP(1.3219-0.2364*J$42),EXP(2.2217-62.2914*J$42))","v":2.0769490208808548},{"$f":"IF(K$42>0.0145,EXP(0.9574-0.267*K$42),EXP(1.8156-59.4508*K$42))","v":2.1039152212901104},{"$f":"IF(L$42>0.0145,EXP(0.9574-0.267*L$42),EXP(1.8156-59.4508*L$42))","v":2.1039152212901104},{"$f":"IF(M$42>0.0145,EXP(0.9574-0.267*M$42),EXP(1.8156-59.4508*M$42))","v":2.1039152212901104},{"$f":"IF(N$42>0.0145,EXP(0.9574-0.267*N$42),EXP(1.8156-59.4508*N$42))","v":2.1039152212901104}]
["TP","mg/L",{"$f":"IF(C$42>0.00426,EXP(-0.6134-0.4693*C$42),EXP(0.0336-152.341*C$42))","v":0.16752042413770912},{"$f":"IF(D$42>0.00426,EXP(-0.2231-0.4003*D$42),EXP(0.5338-178.08*D$42))","v":0.29409571600066703},{"$f":"IF(E$42>0.00426,EXP(-0.6134-0.4693*E$42),EXP(0.0336-152.341*E$42))","v":0.16752042413770912},{"$f":"IF(F$42>0.00426,EXP(-0.2231-0.4003*F$42),EXP(0.5338-178.08*F$42))","v":0.29409571600066703},{"$f":"IF(G$42>0.00426,EXP(-0.6134-0.4693*G$42),EXP(0.0336-152.341*G$42))","v":0.16752042413770912},{"$f":"IF(H$42>0.00426,EXP(-0.2231-0.4003*H$42),EXP(0.5338-178.08*H$42))","v":0.29409571600066703},{"$f":"IF(I$42>0.00426,EXP(-0.6134-0.4693*I$42),EXP(0.0336-152.341*I$42))","v":0.16752042413770912},{"$f":"IF(J$42>0.00426,EXP(-0.2231-0.4003*J$42),EXP(0.5338-178.08*J$42))","v":0.29409571600066703},{"$f":"IF(K$42>0.00426,EXP(-0.6134-0.4693*K$42),EXP(0.0336-152.341*K$42))","v":0.3720079700771225},{"$f":"IF(L$42>0.00426,EXP(-0.6134-0.4693*L$42),EXP(0.0336-152.341*L$42))","v":0.3720079700771225},{"$f":"IF(M$42>0.00426,EXP(-0.6134-0.4693*M$42),EXP(0.0336-152.341*M$42))","v":0.3720079700771225},{"$f":"IF(N$42>0.00426,EXP(-0.6134-0.4693*N$42),EXP(0.0336-152.341*N$42))","v":0.3720079700771225}]
["TSS","mg/L",{"$f":"IF(C$42>0.00399,EXP(5.2895-0.9341*C$42),EXP(6.3181-258.741*C$42))","v":19.187326826927933},{"$f":"IF(D$42>0.00399,EXP(5.8622-0.7645*D$42),EXP(6.8265-242.449*D$42))","v":51.984728876581904},{"$f":"IF(E$42>0.00399,EXP(5.2895-0.9341*E$42),EXP(6.3181-258.741*E$42))","v":19.187326826927933},{"$f":"IF(F$42>0.00399,EXP(5.8622-0.7645*F$42),EXP(6.8265-242.449*F$42))","v":51.984728876581904},{"$f":"IF(G$42>0.00399,EXP(5.2895-0.9341*G$42),EXP(6.3181-258.741*G$42))","v":19.187326826927933},{"$f":"IF(H$42>0.00399,EXP(5.8622-0.7645*H$42),EXP(6.8265-242.449*H$42))","v":51.984728876581904},{"$f":"IF(I$42>0.00399,EXP(5.2895-0.9341*I$42),EXP(6.3181-258.741*I$42))","v":19.187326826927933},{"$f":"IF(J$42>0.00399,EXP(5.8622-0.7645*J$42),EXP(6.8265-242.449*J$42))","v":51.984728876581904},{"$f":"IF(K$42>0.00399,EXP(5.2895-0.9341*K$42),EXP(6.3181-258.741*K$42))","v":93.899024739549674},{"$f":"IF(L$42>0.00399,EXP(5.2895-0.9341*L$42),EXP(6.3181-258.741*L$42))","v":93.899024739549674},{"$f":"IF(M$42>0.00399,EXP(5.2895-0.9341*M$42),EXP(6.3181-258.741*M$42))","v":93.899024739549674},{"$f":"IF(N$42>0.00399,EXP(5.2895-0.9341*N$42),EXP(6.3181-258.741*N$42))","v":93.899024739549674}]
["Zn","mg/L",{"$f":"IF(C$42>0.0147,EXP(4.61-0.4424*C$42),EXP(5.5439-63.9761*C$42))/1000","v":3.3248179043727767E-2},{"$f":"IF(D$42>0.0147,EXP(5.1995-0.531*D$42),EXP(6.1534-65.4251*D$42))/1000","v":4.8038366801708178E-2},{"$f":"IF(E$42>0.0147,EXP(4.61-0.4424*E$42),EXP(5.5439-63.9761*E$42))/1000","v":3.3248179043727767E-2},{"$f":"IF(F$42>0.0147,EXP(5.1995-0.531*F$42),EXP(6.1534-65.4251*F$42))/1000","v":4.8038366801708178E-2},{"$f":"IF(G$42>0.0147,EXP(4.61-0.4424*G$42),EXP(5.5439-63.9761*G$42))/1000","v":3.3248179043727767E-2},{"$f":"IF(H$42>0.0147,EXP(5.1995-0.531*H$42),EXP(6.1534-65.4251*H$42))/1000","v":4.8038366801708178E-2},{"$f":"IF(I$42>0.0147,EXP(4.61-0.4424*I$42),EXP(5.5439-63.9761*I$42))/1000","v":3.3248179043727767E-2},{"$f":"IF(J$42>0.0147,EXP(5.1995-0.531*J$42),EXP(6.1534-65.4251*J$42))/1000","v":4.8038366801708178E-2},{"$f":"IF(K$42>0.0147,EXP(4.61-0.4424*K$42),EXP(5.5439-63.9761*K$42))/1000","v":7.0532951656208445E-2},{"$f":"IF(L$42>0.0147,EXP(4.61-0.4424*L$42),EXP(5.5439-63.9761*L$42))/1000","v":7.0532951656208445E-2},{"$f":"IF(M$42>0.0147,EXP(4.61-0.4424*M$42),EXP(5.5439-63.9761*M$42))/1000","v":7.0532951656208445E-2},{"$f":"IF(N$42>0.0147,EXP(4.61-0.4424*N$42),EXP(5.5439-63.9761*N$42))/1000","v":7.0532951656208445E-2}]
[null,null,"*CM-14-10, \"Offline\" uses 80th pct, \"online\" uses 90th pct regressions"]
[]
[]
["CALCULATE: RUNOFF"]
[null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
[null,"Analyze?",1,{"$f":"IF(n_DA>1,1,0)","v":0},{"$f":"IF(n_DA>2,1,0)","v":0},{"$f":"IF(n_DA>3,1,0)","v":0}]
[null,"Drainage Area (Ac)",{"$f":"DA_A","v":1},{"$f":"DA_B","v":1},{"$f":"DA_C","v":1},{"$f":"DA_D","v":1}]
["Existing","IC %",{"$f":"ICA_b","v":0},{"$f":"ICB_b","v":0},{"$f":"ICC_b","v":0},{"$f":"ICD_b","v":0}]
[null,"Rv (Runoff Coeff)",{"$f":"0.7162*C58/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*D58/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*E58/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*F58/100+0.0644","v":6.4399999999999999E-2}]
[null,"Sd (Dep Storage)",{"$f":"0.2181*EXP(-1.9456*C58/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*D58/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*E58/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*F58/100)","v":0.21809999999999999}]
[null,"Runoff (in/yr)",{"$f":"C$56*$A$7*C59*EXP(-$A$8/$A$7*C60)","v":1.3026685000420581},{"$f":"D$56*$A$7*D59*EXP(-$A$8/$A$7*D60)","v":0},{"$f":"E$56*$A$7*E59*EXP(-$A$8/$A$7*E60)","v":0},{"$f":"F$56*$A$7*F59*EXP(-$A$8/$A$7*F60)","v":0}]
[null,"Runoff (Ac-in/yr)",{"$f":"C57*C61","v":1.3026685000420581},{"$f":"D57*D61","v":0},0,0]
["Developed","IC %",{"$f":"ICA_d","v":50},{"$f":"ICB_d","v":50},{"$f":"ICC_d","v":50},{"$f":"ICD_d","v":50}]
[null,"Rv (Runoff Coeff)",{"$f":"0.7162*C63/100+0.0644","v":0.42249999999999999},{"$f":"0.7162*D63/100+0.0644","v":0.42249999999999999},{"$f":"0.7162*E63/100+0.0644","v":0.42249999999999999},{"$f":"0.7162*F63/100+0.0644","v":0.42249999999999999}]
[null,"Sd (Dep Storage)",{"$f":"0.2181*EXP(-1.9456*C63/100)","v":8.2446835976164229E-2},{"$f":"0.2181*EXP(-1.9456*D63/100)","v":8.2446835976164229E-2},{"$f":"0.2181*EXP(-1.9456*E63/100)","v":8.2446835976164229E-2},{"$f":"0.2181*EXP(-1.9456*F63/100)","v":8.2446835976164229E-2}]
[null,"Runoff (in/yr)",{"$f":"C$56*$A$7*C64*EXP(-$A$8/$A$7*C65)","v":11.674555317764794},{"$f":"D$56*$A$7*D64*EXP(-$A$8/$A$7*D65)","v":0},{"$f":"E$56*$A$7*E64*EXP(-$A$8/$A$7*E65)","v":0},{"$f":"F$56*$A$7*F64*EXP(-$A$8/$A$7*F65)","v":0}]
[null,"Runoff (Ac-in/yr)",{"$f":"C57*C66","v":11.674555317764794},{"$f":"D57*D66","v":0},0,0]
[]
["CALCULATE: '1/2\" PLUS' (MINIMUM) WATER QUALITY VOLUME"]
[null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
[null," WQV (in)",{"$f":"MAX(0.5,0.5+(ICA_d-20)/100)","v":0.8},{"$f":"MAX(0.5,0.5+(ICB_d-20)/100)","v":0.8},{"$f":"MAX(0.5,0.5+(ICC_d-20)/100)","v":0.8},{"$f":"MAX(0.5,0.5+(ICD_d-20)/100)","v":0.8}]
[]
[]
["CALCULATE: Effluent Concentrations For Each SCM"]
[null,null,"SCM A.1","SCM B.1","SCM C.1","SCM D.1"]
["Pollutant","Units",{"$f":"'1. ENTER DATA'!F24","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!G24","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!H24","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!I24","v":"Retention Basin"}]
["COD","mg/L",{"$f":"IF(C$76=\"None\",I18,MIN(IF(C$76=\"Alternative\",'1. ENTER DATA'!F53,LOOKUP(C$76,$C$28:$G$28,$C29:$G29)),I18))","v":43.79},{"$f":"IF(D$76=\"None\",J18,MIN(IF(D$76=\"Alternative\",'1. ENTER DATA'!G53,LOOKUP(D$76,$C$28:$G$28,$C29:$G29)),J18))","v":43.79},{"$f":"IF(E$76=\"None\",K18,MIN(IF(E$76=\"Alternative\",'1. ENTER DATA'!H53,LOOKUP(E$76,$C$28:$G$28,$C29:$G29)),K18))","v":43.79},{"$f":"IF(F$76=\"None\",L18,MIN(IF(F$76=\"Alternative\",'1. ENTER DATA'!I53,LOOKUP(F$76,$C$28:$G$28,$C29:$G29)),L18))","v":43.79}]
["E. coli","CFU/100mL",{"$f":"IF(C$76=\"None\",I19,MIN(IF(C$76=\"Alternative\",'1. ENTER DATA'!F54,LOOKUP(C$76,$C$28:$G$28,$C30:$G30)),I19))","v":11065},{"$f":"IF(D$76=\"None\",J19,MIN(IF(D$76=\"Alternative\",'1. ENTER DATA'!G54,LOOKUP(D$76,$C$28:$G$28,$C30:$G30)),J19))","v":11065},{"$f":"IF(E$76=\"None\",K19,MIN(IF(E$76=\"Alternative\",'1. ENTER DATA'!H54,LOOKUP(E$76,$C$28:$G$28,$C30:$G30)),K19))","v":11065},{"$f":"IF(F$76=\"None\",L19,MIN(IF(F$76=\"Alternative\",'1. ENTER DATA'!I54,LOOKUP(F$76,$C$28:$G$28,$C30:$G30)),L19))","v":11065}]
["Pb","mg/L",{"$f":"IF(C$76=\"None\",I20,MIN(IF(C$76=\"Alternative\",'1. ENTER DATA'!F55,LOOKUP(C$76,$C$28:$G$28,$C31:$G31)),I20))","v":8.3099999999999997E-3},{"$f":"IF(D$76=\"None\",J20,MIN(IF(D$76=\"Alternative\",'1. ENTER DATA'!G55,LOOKUP(D$76,$C$28:$G$28,$C31:$G31)),J20))","v":8.3099999999999997E-3},{"$f":"IF(E$76=\"None\",K20,MIN(IF(E$76=\"Alternative\",'1. ENTER DATA'!H55,LOOKUP(E$76,$C$28:$G$28,$C31:$G31)),K20))","v":8.3099999999999997E-3},{"$f":"IF(F$76=\"None\",L20,MIN(IF(F$76=\"Alternative\",'1. ENTER DATA'!I55,LOOKUP(F$76,$C$28:$G$28,$C31:$G31)),L20))","v":8.3099999999999997E-3}]
["TN","mg/L",{"$f":"IF(C$76=\"None\",I21,MIN(IF(C$76=\"Alternative\",'1. ENTER DATA'!F56,LOOKUP(C$76,$C$28:$G$28,$C32:$G32)),I21))","v":1.42},{"$f":"IF(D$76=\"None\",J21,MIN(IF(D$76=\"Alternative\",'1. ENTER DATA'!G56,LOOKUP(D$76,$C$28:$G$28,$C32:$G32)),J21))","v":1.42},{"$f":"IF(E$76=\"None\",K21,MIN(IF(E$76=\"Alternative\",'1. ENTER DATA'!H56,LOOKUP(E$76,$C$28:$G$28,$C32:$G32)),K21))","v":1.42},{"$f":"IF(F$76=\"None\",L21,MIN(IF(F$76=\"Alternative\",'1. ENTER DATA'!I56,LOOKUP(F$76,$C$28:$G$28,$C32:$G32)),L21))","v":1.42}]
["TP","mg/L",{"$f":"IF(C$76=\"None\",I22,MIN(IF(C$76=\"Alternative\",'1. ENTER DATA'!F57,LOOKUP(C$76,$C$28:$G$28,$C33:$G33)),I22))","v":0.224},{"$f":"IF(D$76=\"None\",J22,MIN(IF(D$76=\"Alternative\",'1. ENTER DATA'!G57,LOOKUP(D$76,$C$28:$G$28,$C33:$G33)),J22))","v":0.224},{"$f":"IF(E$76=\"None\",K22,MIN(IF(E$76=\"Alternative\",'1. ENTER DATA'!H57,LOOKUP(E$76,$C$28:$G$28,$C33:$G33)),K22))","v":0.224},{"$f":"IF(F$76=\"None\",L22,MIN(IF(F$76=\"Alternative\",'1. ENTER DATA'!I57,LOOKUP(F$76,$C$28:$G$28,$C33:$G33)),L22))","v":0.224}]
["TSS","mg/L",{"$f":"IF(C$76=\"None\",I23,MIN(IF(C$76=\"Alternative\",'1. ENTER DATA'!F58,LOOKUP(C$76,$C$28:$G$28,$C34:$G34)),I23))","v":133.80000000000001},{"$f":"IF(D$76=\"None\",J23,MIN(IF(D$76=\"Alternative\",'1. ENTER DATA'!G58,LOOKUP(D$76,$C$28:$G$28,$C34:$G34)),J23))","v":133.80000000000001},{"$f":"IF(E$76=\"None\",K23,MIN(IF(E$76=\"Alternative\",'1. ENTER DATA'!H58,LOOKUP(E$76,$C$28:$G$28,$C34:$G34)),K23))","v":133.80000000000001},{"$f":"IF(F$76=\"None\",L23,MIN(IF(F$76=\"Alternative\",'1. ENTER DATA'!I58,LOOKUP(F$76,$C$28:$G$28,$C34:$G34)),L23))","v":133.80000000000001}]
["Zn","mg/L",{"$f":"IF(C$76=\"None\",I24,MIN(IF(C$76=\"Alternative\",'1. ENTER DATA'!F59,LOOKUP(C$76,$C$28:$G$28,$C35:$G35)),I24))","v":4.53E-2},{"$f":"IF(D$76=\"None\",J24,MIN(IF(D$76=\"Alternative\",'1. ENTER DATA'!G59,LOOKUP(D$76,$C$28:$G$28,$C35:$G35)),J24))","v":4.53E-2},{"$f":"IF(E$76=\"None\",K24,MIN(IF(E$76=\"Alternative\",'1. ENTER DATA'!H59,LOOKUP(E$76,$C$28:$G$28,$C35:$G35)),K24))","v":4.53E-2},{"$f":"IF(F$76=\"None\",L24,MIN(IF(F$76=\"Alternative\",'1. ENTER DATA'!I59,LOOKUP(F$76,$C$28:$G$28,$C35:$G35)),L24))","v":4.53E-2}]
[null,null,"SCM A.2","SCM B.2","SCM C.2","SCM D.2"]
["Pollutant","Units",{"$f":"IF(OR(WQV_A1=0,'1. ENTER DATA'!F24=\"None\"),\"None\",'1. ENTER DATA'!F41)","v":"Infiltration Field"},{"$f":"IF(OR(WQV_B1=0,'1. ENTER DATA'!G24=\"None\"),\"None\",'1. ENTER DATA'!G41)","v":"Infiltration Field"},{"$f":"IF(OR(WQV_C1=0,'1. ENTER DATA'!H24=\"None\"),\"None\",'1. ENTER DATA'!H41)","v":"Infiltration Field"},{"$f":"IF(OR(WQV_D1=0,'1. ENTER DATA'!I24=\"None\"),\"None\",'1. ENTER DATA'!I41)","v":"Infiltration Field"}]
["COD","mg/L",{"$f":"MIN(IF(C$85=\"Alternative\",'1. ENTER DATA'!F62,IF(OR(C$85=\"Infiltration Field\",C$85=\"None\",C$85=\"Beneficial Use\"),C77,LOOKUP(C$85,$C$28:$G$28,$C29:$G29))),C77)","v":43.79},{"$f":"MIN(IF(D$85=\"Alternative\",'1. ENTER DATA'!G62,IF(OR(D$85=\"Infiltration Field\",D$85=\"None\",D$85=\"Beneficial Use\"),D77,LOOKUP(D$85,$C$28:$G$28,$C29:$G29))),D77)","v":43.79},{"$f":"MIN(IF(E$85=\"Alternative\",'1. ENTER DATA'!H62,IF(OR(E$85=\"Infiltration Field\",E$85=\"None\",E$85=\"Beneficial Use\"),E77,LOOKUP(E$85,$C$28:$G$28,$C29:$G29))),E77)","v":43.79},{"$f":"MIN(IF(F$85=\"Alternative\",'1. ENTER DATA'!I62,IF(OR(F$85=\"Infiltration Field\",F$85=\"None\",F$85=\"Beneficial Use\"),F77,LOOKUP(F$85,$C$28:$G$28,$C29:$G29))),F77)","v":43.79}]
["E. coli","CFU/100mL",{"$f":"MIN(IF(C$85=\"Alternative\",'1. ENTER DATA'!F63,IF(OR(C$85=\"Infiltration Field\",C$85=\"None\",C$85=\"Beneficial Use\"),C78,LOOKUP(C$85,$C$28:$G$28,$C30:$G30))),C78)","v":11065},{"$f":"MIN(IF(D$85=\"Alternative\",'1. ENTER DATA'!G63,IF(OR(D$85=\"Infiltration Field\",D$85=\"None\",D$85=\"Beneficial Use\"),D78,LOOKUP(D$85,$C$28:$G$28,$C30:$G30))),D78)","v":11065},{"$f":"MIN(IF(E$85=\"Alternative\",'1. ENTER DATA'!H63,IF(OR(E$85=\"Infiltration Field\",E$85=\"None\",E$85=\"Beneficial Use\"),E78,LOOKUP(E$85,$C$28:$G$28,$C30:$G30))),E78)","v":11065},{"$f":"MIN(IF(F$85=\"Alternative\",'1. ENTER DATA'!I63,IF(OR(F$85=\"Infiltration Field\",F$85=\"None\",F$85=\"Beneficial Use\"),F78,LOOKUP(F$85,$C$28:$G$28,$C30:$G30))),F78)","v":11065}]
["Pb","mg/L",{"$f":"MIN(IF(C$85=\"Alternative\",'1. ENTER DATA'!F64,IF(OR(C$85=\"Infiltration Field\",C$85=\"None\",C$85=\"Beneficial Use\"),C79,LOOKUP(C$85,$C$28:$G$28,$C31:$G31))),C79)","v":8.3099999999999997E-3},{"$f":"MIN(IF(D$85=\"Alternative\",'1. ENTER DATA'!G64,IF(OR(D$85=\"Infiltration Field\",D$85=\"None\",D$85=\"Beneficial Use\"),D79,LOOKUP(D$85,$C$28:$G$28,$C31:$G31))),D79)","v":8.3099999999999997E-3},{"$f":"MIN(IF(E$85=\"Alternative\",'1. ENTER DATA'!H64,IF(OR(E$85=\"Infiltration Field\",E$85=\"None\",E$85=\"Beneficial Use\"),E79,LOOKUP(E$85,$C$28:$G$28,$C31:$G31))),E79)","v":8.3099999999999997E-3},{"$f":"MIN(IF(F$85=\"Alternative\",'1. ENTER DATA'!I64,IF(OR(F$85=\"Infiltration Field\",F$85=\"None\",F$85=\"Beneficial Use\"),F79,LOOKUP(F$85,$C$28:$G$28,$C31:$G31))),F79)","v":8.3099999999999997E-3}]
["TN","mg/L",{"$f":"MIN(IF(C$85=\"Alternative\",'1. ENTER DATA'!F65,IF(OR(C$85=\"Infiltration Field\",C$85=\"None\",C$85=\"Beneficial Use\"),C80,LOOKUP(C$85,$C$28:$G$28,$C32:$G32))),C80)","v":1.42},{"$f":"MIN(IF(D$85=\"Alternative\",'1. ENTER DATA'!G65,IF(OR(D$85=\"Infiltration Field\",D$85=\"None\",D$85=\"Beneficial Use\"),D80,LOOKUP(D$85,$C$28:$G$28,$C32:$G32))),D80)","v":1.42},{"$f":"MIN(IF(E$85=\"Alternative\",'1. ENTER DATA'!H65,IF(OR(E$85=\"Infiltration Field\",E$85=\"None\",E$85=\"Beneficial Use\"),E80,LOOKUP(E$85,$C$28:$G$28,$C32:$G32))),E80)","v":1.42},{"$f":"MIN(IF(F$85=\"Alternative\",'1. ENTER DATA'!I65,IF(OR(F$85=\"Infiltration Field\",F$85=\"None\",F$85=\"Beneficial Use\"),F80,LOOKUP(F$85,$C$28:$G$28,$C32:$G32))),F80)","v":1.42}]
["TP","mg/L",{"$f":"MIN(IF(C$85=\"Alternative\",'1. ENTER DATA'!F66,IF(OR(C$85=\"Infiltration Field\",C$85=\"None\",C$85=\"Beneficial Use\"),C81,LOOKUP(C$85,$C$28:$G$28,$C33:$G33))),C81)","v":0.224},{"$f":"MIN(IF(D$85=\"Alternative\",'1. ENTER DATA'!G66,IF(OR(D$85=\"Infiltration Field\",D$85=\"None\",D$85=\"Beneficial Use\"),D81,LOOKUP(D$85,$C$28:$G$28,$C33:$G33))),D81)","v":0.224},{"$f":"MIN(IF(E$85=\"Alternative\",'1. ENTER DATA'!H66,IF(OR(E$85=\"Infiltration Field\",E$85=\"None\",E$85=\"Beneficial Use\"),E81,LOOKUP(E$85,$C$28:$G$28,$C33:$G33))),E81)","v":0.224},{"$f":"MIN(IF(F$85=\"Alternative\",'1. ENTER DATA'!I66,IF(OR(F$85=\"Infiltration Field\",F$85=\"None\",F$85=\"Beneficial Use\"),F81,LOOKUP(F$85,$C$28:$G$28,$C33:$G33))),F81)","v":0.224}]
["TSS","mg/L",{"$f":"MIN(IF(C$85=\"Alternative\",'1. ENTER DATA'!F67,IF(OR(C$85=\"Infiltration Field\",C$85=\"None\",C$85=\"Beneficial Use\"),C82,LOOKUP(C$85,$C$28:$G$28,$C34:$G34))),C82)","v":133.80000000000001},{"$f":"MIN(IF(D$85=\"Alternative\",'1. ENTER DATA'!G67,IF(OR(D$85=\"Infiltration Field\",D$85=\"None\",D$85=\"Beneficial Use\"),D82,LOOKUP(D$85,$C$28:$G$28,$C34:$G34))),D82)","v":133.80000000000001},{"$f":"MIN(IF(E$85=\"Alternative\",'1. ENTER DATA'!H67,IF(OR(E$85=\"Infiltration Field\",E$85=\"None\",E$85=\"Beneficial Use\"),E82,LOOKUP(E$85,$C$28:$G$28,$C34:$G34))),E82)","v":133.80000000000001},{"$f":"MIN(IF(F$85=\"Alternative\",'1. ENTER DATA'!I67,IF(OR(F$85=\"Infiltration Field\",F$85=\"None\",F$85=\"Beneficial Use\"),F82,LOOKUP(F$85,$C$28:$G$28,$C34:$G34))),F82)","v":133.80000000000001}]
["Zn","mg/L",{"$f":"MIN(IF(C$85=\"Alternative\",'1. ENTER DATA'!F68,IF(OR(C$85=\"Infiltration Field\",C$85=\"None\",C$85=\"Beneficial Use\"),C83,LOOKUP(C$85,$C$28:$G$28,$C35:$G35))),C83)","v":4.53E-2},{"$f":"MIN(IF(D$85=\"Alternative\",'1. ENTER DATA'!G68,IF(OR(D$85=\"Infiltration Field\",D$85=\"None\",D$85=\"Beneficial Use\"),D83,LOOKUP(D$85,$C$28:$G$28,$C35:$G35))),D83)","v":4.53E-2},{"$f":"MIN(IF(E$85=\"Alternative\",'1. ENTER DATA'!H68,IF(OR(E$85=\"Infiltration Field\",E$85=\"None\",E$85=\"Beneficial Use\"),E83,LOOKUP(E$85,$C$28:$G$28,$C35:$G35))),E83)","v":4.53E-2},{"$f":"MIN(IF(F$85=\"Alternative\",'1. ENTER DATA'!I68,IF(OR(F$85=\"Infiltration Field\",F$85=\"None\",F$85=\"Beneficial Use\"),F83,LOOKUP(F$85,$C$28:$G$28,$C35:$G35))),F83)","v":4.53E-2}]
[]
["CALCULATE: Bypass Concentrations For Each SCM"]
[null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
[null,null,"SCM A.1","SCM B.1","SCM C.1","SCM D.1"]
["Pollutant","Units",{"$f":"'1. ENTER DATA'!F52","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!G52","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!H52","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!I52","v":"Retention Basin"}]
["COD","mg/L",{"$f":"IF(C$97=\"None\",I18,MIN(I18,IF('1. ENTER DATA'!F$25=\"Yes (Off-Line)\",C44,D44)))","v":24.953148334792502},{"$f":"IF(D$97=\"None\",J18,MIN(J18,IF('1. ENTER DATA'!G$25=\"Yes (Off-Line)\",E44,F44)))","v":24.953148334792502},{"$f":"IF(E$97=\"None\",K18,MIN(K18,IF('1. ENTER DATA'!H$25=\"Yes (Off-Line)\",G44,H44)))","v":24.953148334792502},{"$f":"IF(F$97=\"None\",L18,MIN(L18,IF('1. ENTER DATA'!I$25=\"Yes (Off-Line)\",I44,J44)))","v":24.953148334792502}]
["E. coli","CFU/100mL",{"$f":"IF(C$97=\"None\",I19,MIN(I19,IF('1. ENTER DATA'!F$25=\"Yes (Off-Line)\",C45,D45)))","v":8229.24868738228},{"$f":"IF(D$97=\"None\",J19,MIN(J19,IF('1. ENTER DATA'!G$25=\"Yes (Off-Line)\",E45,F45)))","v":8229.24868738228},{"$f":"IF(E$97=\"None\",K19,MIN(K19,IF('1. ENTER DATA'!H$25=\"Yes (Off-Line)\",G45,H45)))","v":8229.24868738228},{"$f":"IF(F$97=\"None\",L19,MIN(L19,IF('1. ENTER DATA'!I$25=\"Yes (Off-Line)\",I45,J45)))","v":8229.24868738228}]
["Pb","mg/L",{"$f":"IF(C$97=\"None\",I20,MIN(I20,IF('1. ENTER DATA'!F$25=\"Yes (Off-Line)\",C46,D46)))","v":5.2532661133623381E-3},{"$f":"IF(D$97=\"None\",J20,MIN(J20,IF('1. ENTER DATA'!G$25=\"Yes (Off-Line)\",E46,F46)))","v":5.2532661133623381E-3},{"$f":"IF(E$97=\"None\",K20,MIN(K20,IF('1. ENTER DATA'!H$25=\"Yes (Off-Line)\",G46,H46)))","v":5.2532661133623381E-3},{"$f":"IF(F$97=\"None\",L20,MIN(L20,IF('1. ENTER DATA'!I$25=\"Yes (Off-Line)\",I46,J46)))","v":5.2532661133623381E-3}]
["TN","mg/L",{"$f":"IF(C$97=\"None\",I21,MIN(I21,IF('1. ENTER DATA'!F$25=\"Yes (Off-Line)\",C47,D47)))","v":1.3362938519585843},{"$f":"IF(D$97=\"None\",J21,MIN(J21,IF('1. ENTER DATA'!G$25=\"Yes (Off-Line)\",E47,F47)))","v":1.3362938519585843},{"$f":"IF(E$97=\"None\",K21,MIN(K21,IF('1. ENTER DATA'!H$25=\"Yes (Off-Line)\",G47,H47)))","v":1.3362938519585843},{"$f":"IF(F$97=\"None\",L21,MIN(L21,IF('1. ENTER DATA'!I$25=\"Yes (Off-Line)\",I47,J47)))","v":1.3362938519585843}]
["TP","mg/L",{"$f":"IF(C$97=\"None\",I22,MIN(I22,IF('1. ENTER DATA'!F$25=\"Yes (Off-Line)\",C48,D48)))","v":0.16752042413770912},{"$f":"IF(D$97=\"None\",J22,MIN(J22,IF('1. ENTER DATA'!G$25=\"Yes (Off-Line)\",E48,F48)))","v":0.16752042413770912},{"$f":"IF(E$97=\"None\",K22,MIN(K22,IF('1. ENTER DATA'!H$25=\"Yes (Off-Line)\",G48,H48)))","v":0.16752042413770912},{"$f":"IF(F$97=\"None\",L22,MIN(L22,IF('1. ENTER DATA'!I$25=\"Yes (Off-Line)\",I48,J48)))","v":0.16752042413770912}]
["TSS","mg/L",{"$f":"IF(C$97=\"None\",I23,MIN(I23,IF('1. ENTER DATA'!F$25=\"Yes (Off-Line)\",C49,D49)))","v":19.187326826927933},{"$f":"IF(D$97=\"None\",J23,MIN(J23,IF('1. ENTER DATA'!G$25=\"Yes (Off-Line)\",E49,F49)))","v":19.187326826927933},{"$f":"IF(E$97=\"None\",K23,MIN(K23,IF('1. ENTER DATA'!H$25=\"Yes (Off-Line)\",G49,H49)))","v":19.187326826927933},{"$f":"IF(F$97=\"None\",L23,MIN(L23,IF('1. ENTER DATA'!I$25=\"Yes (Off-Line)\",I49,J49)))","v":19.187326826927933}]
["Zn","mg/L",{"$f":"IF(C$97=\"None\",I24,MIN(I24,IF('1. ENTER DATA'!F$25=\"Yes (Off-Line)\",C50,D50)))","v":3.3248179043727767E-2},{"$f":"IF(D$97=\"None\",J24,MIN(J24,IF('1. ENTER DATA'!G$25=\"Yes (Off-Line)\",E50,F50)))","v":3.3248179043727767E-2},{"$f":"IF(E$97=\"None\",K24,MIN(K24,IF('1. ENTER DATA'!H$25=\"Yes (Off-Line)\",G50,H50)))","v":3.3248179043727767E-2},{"$f":"IF(F$97=\"None\",L24,MIN(L24,IF('1. ENTER DATA'!I$25=\"Yes (Off-Line)\",I50,J50)))","v":3.3248179043727767E-2}]
[null,null,"SCM A.2","SCM B.2","SCM C.2","SCM D.2"]
["Pollutant","Units",{"$f":"C85","v":"Infiltration Field"},{"$f":"D85","v":"Infiltration Field"},"Infiltration Field","Infiltration Field"]
["COD","mg/L",{"$f":"C77","v":43.79},43.79,43.79,43.79]
["E. coli","CFU/100mL",11065,11065,11065,11065]
["Pb","mg/L",8.3099999999999997E-3,8.3099999999999997E-3,8.3099999999999997E-3,8.3099999999999997E-3]
["TN","mg/L",1.42,1.42,1.42,1.42]
["TP","mg/L",0.224,0.224,0.224,0.224]
["TSS","mg/L",133.80000000000001,133.80000000000001,133.80000000000001,133.80000000000001]
["Zn","mg/L",4.53E-2,4.53E-2,4.53E-2,4.53E-2]
[]
["CLASSIFY: SCM Volumes Calculation Method"]
[null,null,null,null,null,null,"PERMUTATIONS FOR VOLUME CALCULATIONS"]
[null,null,"SCM A","SCM B","SCM C","SCM D","METHOD NO.","SCM 1","SCM 2"]
[null,null,{"$f":"IF(AND('1. ENTER DATA'!F$33=\"No\",'1. ENTER DATA'!F$42=\"No; infiltrate all routed water\"),1,0)","v":1},{"$f":"IF(AND('1. ENTER DATA'!G$33=\"No\",'1. ENTER DATA'!G$42=\"No; infiltrate all routed water\"),1,0)","v":1},{"$f":"IF(AND('1. ENTER DATA'!H$33=\"No\",'1. ENTER DATA'!H$42=\"No; infiltrate all routed water\"),1,0)","v":1},{"$f":"IF(AND('1. ENTER DATA'!I$33=\"No\",'1. ENTER DATA'!I$42=\"No; infiltrate all routed water\"),1,0)","v":1},1,"Don't know RCE","all water inf","(SLAT Default)"]
[null,null,{"$f":"IF(AND('1. ENTER DATA'!F$33=\"No\",'1. ENTER DATA'!F$42=\"Yes\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!G$33=\"No\",'1. ENTER DATA'!G$42=\"Yes\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!H$33=\"No\",'1. ENTER DATA'!H$42=\"Yes\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!I$33=\"No\",'1. ENTER DATA'!I$42=\"Yes\"),1,0)","v":0},2,"Don't know RCE","all water NOT inf - give WQV"]
[null,null,{"$f":"IF(AND('1. ENTER DATA'!F$33=\"Yes\",'1. ENTER DATA'!F$42=\"No; infiltrate all routed water\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!G$33=\"Yes\",'1. ENTER DATA'!G$42=\"No; infiltrate all routed water\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!H$33=\"Yes\",'1. ENTER DATA'!H$42=\"No; infiltrate all routed water\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!I$33=\"Yes\",'1. ENTER DATA'!I$42=\"No; infiltrate all routed water\"),1,0)","v":0},3,"User override RCE","all water inf"]
[null,null,{"$f":"IF(AND('1. ENTER DATA'!F$33=\"Yes\",'1. ENTER DATA'!F$42=\"Yes\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!G$33=\"Yes\",'1. ENTER DATA'!G$42=\"Yes\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!H$33=\"Yes\",'1. ENTER DATA'!H$42=\"Yes\"),1,0)","v":0},{"$f":"IF(AND('1. ENTER DATA'!I$33=\"Yes\",'1. ENTER DATA'!I$42=\"Yes\"),1,0)","v":0},4,"User override RCE","all water NOT inf - give RCE"]
[]
["CALCULATE: SCM Volumes"]
[null,null,"SCM A.1","SCM B.1","SCM C.1","SCM D.1"]
["Control is not \"None\"? ",null,{"$f":"IF('1. ENTER DATA'!F24<>\"None\",1,0)*C56","v":1},{"$f":"IF('1. ENTER DATA'!G24<>\"None\",1,0)*D56","v":0},{"$f":"IF('1. ENTER DATA'!H24<>\"None\",1,0)*E56","v":0},{"$f":"IF('1. ENTER DATA'!I24<>\"None\",1,0)*F56","v":0}]
["Calculation Method Classification",null,{"$f":"INDEX($G$118:$G$121,MATCH(1,C$118:C$121,0))","v":1},{"$f":"INDEX($G$118:$G$121,MATCH(1,D$118:D$121,0))","v":1},{"$f":"INDEX($G$118:$G$121,MATCH(1,E$118:E$121,0))","v":1},{"$f":"INDEX($G$118:$G$121,MATCH(1,F$118:F$121,0))","v":1}]
["RCE of SCM 1",null,{"$f":"IF(C126>2,'1. ENTER DATA'!F34/100,RCE_A1_AP)*C125","v":0.98105345153995205},{"$f":"IF(D126>2,'1. ENTER DATA'!G34/100,RCE_B1_AP)*D125","v":0},{"$f":"IF(E126>2,'1. ENTER DATA'!H34/100,RCE_C1_AP)*E125","v":0},{"$f":"IF(F126>2,'1. ENTER DATA'!I34/100,RCE_D1_AP)*F125","v":0}]
["Volume treated by SCM 1 (in/yr)",null,{"$f":"RCE_A1*'3. CALCS_Loads'!C$66","v":11.453362789687253},{"$f":"RCE_B1*'3. CALCS_Loads'!D$66","v":0},{"$f":"RCE_C1*'3. CALCS_Loads'!E$66","v":0},{"$f":"RCE_D1*'3. CALCS_Loads'!F$66","v":0}]
["Volume treated by SCM 1 (Ac-in/yr)",null,{"$f":"RCE_A1*'3. CALCS_Loads'!C$67","v":11.453362789687253},{"$f":"RCE_B1*'3. CALCS_Loads'!D$67","v":0},{"$f":"RCE_C1*'3. CALCS_Loads'!E$67","v":0},{"$f":"RCE_D1*'3. CALCS_Loads'!F$67","v":0}]
["Bypass Volume (in/yr)",null,{"$f":"'3. CALCS_Loads'!C66-C128","v":0.22119252807754108},{"$f":"'3. CALCS_Loads'!D66-D128","v":0},{"$f":"'3. CALCS_Loads'!E66-E128","v":0},{"$f":"'3. CALCS_Loads'!F66-F128","v":0}]
["Bypass Volume (Ac-in/yr)",null,{"$f":"'3. CALCS_Loads'!C67-C129","v":0.22119252807754108},{"$f":"'3. CALCS_Loads'!D67-D129","v":0},{"$f":"'3. CALCS_Loads'!E67-E129","v":0},{"$f":"'3. CALCS_Loads'!F67-F129","v":0}]
[null,null,"SCM A.2","SCM B.2","SCM C.2","SCM D.2"]
["Control is not \"None\"?",null,{"$f":"IF(AND('1. ENTER DATA'!F41<>\"None\",WQV_A1<>0),1,0)*C56","v":1},{"$f":"IF(AND('1. ENTER DATA'!G41<>\"None\",WQV_B1<>0),1,0)*D56","v":0},{"$f":"IF(AND('1. ENTER DATA'!H41<>\"None\",WQV_C1<>0),1,0)*E56","v":0},{"$f":"IF(AND('1. ENTER DATA'!I41<>\"None\",WQV_D1<>0),1,0)*F56","v":0}]
["WQV Routed to SCM 2 (in)",null,{"$f":"C$133*C$125*IF(C$126<=2,WQV_A1,#N/A)","v":2.5},{"$f":"D$133*D$125*IF(D$126<=2,WQV_B1,#N/A)","v":0},{"$f":"E$133*E$125*IF(E$126<=2,WQV_C1,#N/A)","v":0},{"$f":"F$133*F$125*IF(F$126<=2,WQV_D1,#N/A)","v":0}]
["RCE Routed to SCM 2",null,{"$f":"C$133*C$125*IF(C$126<=2,'5.CALCS_Adams&Papa'!B49,'1. ENTER DATA'!F$34/100)","v":0.98105345153995205},{"$f":"D$133*D$125*IF(D$126<=2,'5.CALCS_Adams&Papa'!C49,'1. ENTER DATA'!G$34/100)","v":0},{"$f":"E$133*E$125*IF(E$126<=2,'5.CALCS_Adams&Papa'!D49,'1. ENTER DATA'!H$34/100)","v":0},{"$f":"F$133*F$125*IF(F$126<=2,'5.CALCS_Adams&Papa'!E49,'1. ENTER DATA'!I$34/100)","v":0}]
["Volume routed to SCM 2 (in/yr)",null,{"$f":"C135*'3. CALCS_Loads'!C$66","v":11.453362789687253},{"$f":"D135*'3. CALCS_Loads'!D$66","v":0},{"$f":"E135*'3. CALCS_Loads'!E$66","v":0},{"$f":"F135*'3. CALCS_Loads'!F$66","v":0}]
["Volume routed to SCM 2 (Ac-in/yr)",null,{"$f":"C135*'3. CALCS_Loads'!C$67","v":11.453362789687253},{"$f":"D135*'3. CALCS_Loads'!D$67","v":0},{"$f":"E135*'3. CALCS_Loads'!E$67","v":0},{"$f":"F135*'3. CALCS_Loads'!F$67","v":0}]
["WQV Infiltrated/reused (in)",null,{"$f":"C$133*C$125*IF(C$126=1,WQV_A1,IF(C$126=2,'1. ENTER DATA'!F43,#N/A))","v":2.5},{"$f":"D$133*D$125*IF(D$126=1,WQV_B1,IF(D$126=2,'1. ENTER DATA'!G43,#N/A))","v":0},{"$f":"E$133*E$125*IF(E$126=1,WQV_C1,IF(E$126=2,'1. ENTER DATA'!H43,#N/A))","v":0},{"$f":"F$133*F$125*IF(F$126=1,WQV_D1,IF(F$126=2,'1. ENTER DATA'!I43,#N/A))","v":0}]
["RCE Infiltrated",null,{"$f":"C$133*C$125*IF(C$126=3,'1. ENTER DATA'!F34/100,IF(C$126=4,'1. ENTER DATA'!F44/100,'5.CALCS_Adams&Papa'!B58))","v":0.98105345153995205},{"$f":"D$133*D$125*IF(D$126=3,'1. ENTER DATA'!G34/100,IF(D$126=4,'1. ENTER DATA'!G44/100,'5.CALCS_Adams&Papa'!C58))","v":0},{"$f":"E$133*E$125*IF(E$126=3,'1. ENTER DATA'!H34/100,IF(E$126=4,'1. ENTER DATA'!H44/100,'5.CALCS_Adams&Papa'!D58))","v":0},{"$f":"F$133*F$125*IF(F$126=3,'1. ENTER DATA'!I34/100,IF(F$126=4,'1. ENTER DATA'!I44/100,'5.CALCS_Adams&Papa'!E58))","v":0}]
["Infiltrated Volume (in/yr)",null,{"$f":"C139*'3. CALCS_Loads'!C$66","v":11.453362789687253},{"$f":"D139*'3. CALCS_Loads'!D$66","v":0},{"$f":"E139*'3. CALCS_Loads'!E$66","v":0},{"$f":"F139*'3. CALCS_Loads'!F$66","v":0}]
["Infiltrated Volume (Ac-in/yr) - for calcs",null,{"$f":"C139*'3. CALCS_Loads'!C$67","v":11.453362789687253},{"$f":"D139*'3. CALCS_Loads'!D$67","v":0},{"$f":"E139*'3. CALCS_Loads'!E$67","v":0},{"$f":"F139*'3. CALCS_Loads'!F$67","v":0}]
["Non-infiltrated Volume Treated by SCM 2 (in/yr)",null,{"$f":"(C136-C140)*C133*C125","v":0},{"$f":"(D136-D140)*D133*D125","v":0},{"$f":"(E136-E140)*E133*E125","v":0},{"$f":"(F136-F140)*F133*F125","v":0}]
["Non-infiltrated Volume Treated by SCM 2 (Acre-in/yr)",null,{"$f":"C57*C142","v":0},{"$f":"D57*D142","v":0},{"$f":"E57*E142","v":0},{"$f":"F57*F142","v":0}]
["Volume treated by only SCM 1 (bypasses SCM 2) (in/yr)",null,{"$f":"('3. CALCS_Loads'!C128-'3. CALCS_Loads'!C136)*C125","v":0},{"$f":"('3. CALCS_Loads'!D128-'3. CALCS_Loads'!D136)*D125","v":0},{"$f":"('3. CALCS_Loads'!E128-'3. CALCS_Loads'!E136)*E125","v":0},{"$f":"('3. CALCS_Loads'!F128-'3. CALCS_Loads'!F136)*F125","v":0}]
["Volume treated by only SCM 1 (bypasses SCM 2) (Acre-in/yr)",null,{"$f":"('3. CALCS_Loads'!C129-'3. CALCS_Loads'!C137)*C125","v":0},{"$f":"('3. CALCS_Loads'!D129-'3. CALCS_Loads'!D137)*D125","v":0},{"$f":"('3. CALCS_Loads'!E129-'3. CALCS_Loads'!E137)*E125","v":0},{"$f":"('3. CALCS_Loads'!F129-'3. CALCS_Loads'!F137)*F125","v":0}]
["Error?",null,{"$f":"IF(OR(C139>C135,C135>RCE_A1),1,0)","v":0},{"$f":"IF(OR(D139>D135,D135>RCE_B1),1,0)","v":0},{"$f":"IF(OR(E139>E135,E135>RCE_C1),1,0)","v":0},{"$f":"IF(OR(F139>F135,F135>RCE_D1),1,0)","v":0}]
[]
[]
["CALCULATE: Developed, Existing, and Sed/Fil Loadings - For Results Table"]
[null,"POLLUTANT EFFLUENT LOADS, lb/(yr) or 10^6 MPN/(yr)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Site EXISTING Load, L_ex","Total Site SED/FIL Load, L_sf","Total Site BYPASSED Load, L_un","Total Site  DEVELOPED, TREATED Load, L_out","Compliance Factor","Compliance Factor","BSZ COMPLIANT? Is L_out<L_base?","Non-BSZ COMPLIANT? Is L_out<L_sf?"]
[null,"SCM 1 All Effluent",null,null,null,"SCM 1 Effluent that Bypasses SCM 2",null,null,null,"SCM 2 Effluent",null,null,null,"Bypasses Both SCMs",null,null,null,"Existing",null,null,null,"Sed/Fil Equivalent",null,null,null,"Developed (Untreated/Without Controls) Load",null,null,null,"Developed (Treated) Load"]
["POLLUTANT","SCM A1","SCM B1","SCM C1","SCM D1","SCM A1","SCM B1","SCM C1","SCM D1","SCM A2","SCM B2","SCM C2","SCM D1","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","lb/(yr) or 10^6 MPN/(yr)","lb/(yr) or 10^6 MPN/(yr)","lb/(yr) or 10^6 MPN/(yr)","lb/(yr) or 10^6 MPN/(yr)","Compare to Existing","Compare to Sed/Fil"]
["COD",{"$f":"'3. CALCS_Loads'!C$129*'3. CALCS_Loads'!C77*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":113.69974291224376},{"$f":"'3. CALCS_Loads'!D$129*'3. CALCS_Loads'!D77*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$129*'3. CALCS_Loads'!E77*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$129*'3. CALCS_Loads'!F77*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C107*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D107*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E107*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F107*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$143*'3. CALCS_Loads'!C86*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$143*'3. CALCS_Loads'!D86*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$143*'3. CALCS_Loads'!E86*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$143*'3. CALCS_Loads'!F86*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$131*'3. CALCS_Loads'!C98*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":1.2512593067632269},{"$f":"'3. CALCS_Loads'!D$131*'3. CALCS_Loads'!D98*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$131*'3. CALCS_Loads'!E98*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$131*'3. CALCS_Loads'!F98*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E18*C$62*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":11.487751514525895},{"$f":"'3. CALCS_Loads'!F18*D$62*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G18*E$62*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H18*F$62*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!$F29+'5.CALCS_Adams&Papa'!G$41*'3. CALCS_Loads'!K44)*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*C$56","v":64.873820708739927},{"$f":"('5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!$F29+'5.CALCS_Adams&Papa'!H$41*'3. CALCS_Loads'!L44)*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*D$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!$F29+'5.CALCS_Adams&Papa'!I$41*'3. CALCS_Loads'!M44)*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*E$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!$F29+'5.CALCS_Adams&Papa'!J$41*'3. CALCS_Loads'!N44)*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*F$56","v":0},{"$f":"'3. CALCS_Loads'!I18*C$67*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":191.08608605679152},{"$f":"'3. CALCS_Loads'!J18*D$67*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!K18*E$67*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!L18*F$67*IF(LOOKUP($A153,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"F153+J153+N153","v":1.2512593067632269},0,0,0,{"$f":"SUM(R153:U153)","v":11.487751514525895},{"$f":"SUM(V153:Y153)","v":64.873820708739927},{"$f":"SUM(N153:Q153)","v":1.2512593067632269},{"$f":"SUM(AD153:AG153)","v":1.2512593067632269},{"$f":"AK153/AH153","v":0.10892116748704475},{"$f":"AK153/AI153","v":1.9287584623401945E-2},{"$f":"IF(AL153<=1,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(AM153<=1,\"YES\",\"NO\")","v":"YES"}]
["E. coli",{"$f":"'3. CALCS_Loads'!C$129*'3. CALCS_Loads'!C78*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":130267.26698146357},{"$f":"'3. CALCS_Loads'!D$129*'3. CALCS_Loads'!D78*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$129*'3. CALCS_Loads'!E78*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$129*'3. CALCS_Loads'!F78*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C108*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D108*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E108*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F108*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$143*'3. CALCS_Loads'!C87*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$143*'3. CALCS_Loads'!D87*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$143*'3. CALCS_Loads'!E87*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$143*'3. CALCS_Loads'!F87*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$131*'3. CALCS_Loads'!C99*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":1871.0332495062835},{"$f":"'3. CALCS_Loads'!D$131*'3. CALCS_Loads'!D99*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$131*'3. CALCS_Loads'!E99*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$131*'3. CALCS_Loads'!F99*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E19*C$62*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":11210.216427389736},{"$f":"'3. CALCS_Loads'!F19*D$62*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G19*E$62*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H19*F$62*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!$F30+'5.CALCS_Adams&Papa'!G$41*'3. CALCS_Loads'!K45)*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*C$56","v":67720.466152377601},{"$f":"('5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!$F30+'5.CALCS_Adams&Papa'!H$41*'3. CALCS_Loads'!L45)*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*D$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!$F30+'5.CALCS_Adams&Papa'!I$41*'3. CALCS_Loads'!M45)*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*E$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!$F30+'5.CALCS_Adams&Papa'!J$41*'3. CALCS_Loads'!N45)*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*F$56","v":0},{"$f":"'3. CALCS_Loads'!I19*C$67*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":299562.87508804898},{"$f":"'3. CALCS_Loads'!J19*D$67*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!K19*E$67*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!L19*F$67*IF(LOOKUP($A154,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},1871.0332495062835,0,0,0,11210.216427389736,67720.466152377601,1871.0332495062835,1871.0332495062835,0.16690429320658065,2.762877097296226E-2,{"$f":"IF(AL154<=1,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(AM154<=1,\"YES\",\"NO\")","v":"YES"}]
["Pb",{"$f":"'3. CALCS_Loads'!C$129*'3. CALCS_Loads'!C79*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":2.1576726732147652E-2},{"$f":"'3. CALCS_Loads'!D$129*'3. CALCS_Loads'!D79*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$129*'3. CALCS_Loads'!E79*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$129*'3. CALCS_Loads'!F79*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C109*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D109*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E109*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F109*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$143*'3. CALCS_Loads'!C88*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$143*'3. CALCS_Loads'!D88*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$143*'3. CALCS_Loads'!E88*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$143*'3. CALCS_Loads'!F88*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$131*'3. CALCS_Loads'!C100*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":2.6342159422357997E-4},{"$f":"'3. CALCS_Loads'!D$131*'3. CALCS_Loads'!D100*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$131*'3. CALCS_Loads'!E100*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$131*'3. CALCS_Loads'!F100*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E20*C$62*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":1.2648339263936867E-3},{"$f":"'3. CALCS_Loads'!F20*D$62*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G20*E$62*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H20*F$62*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!$F31+'5.CALCS_Adams&Papa'!G$41*'3. CALCS_Loads'!K46)*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*C$56","v":1.6158291269720446E-2},{"$f":"('5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!$F31+'5.CALCS_Adams&Papa'!H$41*'3. CALCS_Loads'!L46)*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*D$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!$F31+'5.CALCS_Adams&Papa'!I$41*'3. CALCS_Loads'!M46)*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*E$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!$F31+'5.CALCS_Adams&Papa'!J$41*'3. CALCS_Loads'!N46)*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*F$56","v":0},{"$f":"'3. CALCS_Loads'!I20*C$67*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":3.8089463357179276E-2},{"$f":"'3. CALCS_Loads'!J20*D$67*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!K20*E$67*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!L20*F$67*IF(LOOKUP($A155,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},2.6342159422357997E-4,0,0,0,1.2648339263936867E-3,1.6158291269720446E-2,2.6342159422357997E-4,2.6342159422357997E-4,0.20826575625991589,1.6302565031564593E-2,"YES","YES"]
["TN",{"$f":"'3. CALCS_Loads'!C$129*'3. CALCS_Loads'!C80*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":3.6869978290793823},{"$f":"'3. CALCS_Loads'!D$129*'3. CALCS_Loads'!D80*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$129*'3. CALCS_Loads'!E80*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$129*'3. CALCS_Loads'!F80*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C110*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D110*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E110*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F110*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$143*'3. CALCS_Loads'!C89*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$143*'3. CALCS_Loads'!D89*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$143*'3. CALCS_Loads'!E89*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$143*'3. CALCS_Loads'!F89*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$131*'3. CALCS_Loads'!C101*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":6.7007581424196438E-2},{"$f":"'3. CALCS_Loads'!D$131*'3. CALCS_Loads'!D101*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$131*'3. CALCS_Loads'!E101*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$131*'3. CALCS_Loads'!F101*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E21*C$62*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0.35142478926184617},{"$f":"'3. CALCS_Loads'!F21*D$62*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G21*E$62*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H21*F$62*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!$F32+'5.CALCS_Adams&Papa'!G$41*'3. CALCS_Loads'!K47)*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*C$56","v":2.9905691517805346},{"$f":"('5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!$F32+'5.CALCS_Adams&Papa'!H$41*'3. CALCS_Loads'!L47)*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*D$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!$F32+'5.CALCS_Adams&Papa'!I$41*'3. CALCS_Loads'!M47)*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*E$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!$F32+'5.CALCS_Adams&Papa'!J$41*'3. CALCS_Loads'!N47)*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*F$56","v":0},{"$f":"'3. CALCS_Loads'!I21*C$67*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":5.8755001529927595},{"$f":"'3. CALCS_Loads'!J21*D$67*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!K21*E$67*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!L21*F$67*IF(LOOKUP($A156,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},6.7007581424196438E-2,0,0,0,0.35142478926184617,2.9905691517805346,6.7007581424196438E-2,6.7007581424196438E-2,0.19067403174643202,2.2406297270973069E-2,"YES","YES"]
["TP",{"$f":"'3. CALCS_Loads'!C$129*'3. CALCS_Loads'!C81*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0.58161092515055046},{"$f":"'3. CALCS_Loads'!D$129*'3. CALCS_Loads'!D81*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$129*'3. CALCS_Loads'!E81*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$129*'3. CALCS_Loads'!F81*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C111*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D111*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E111*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F111*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$143*'3. CALCS_Loads'!C90*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$143*'3. CALCS_Loads'!D90*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$143*'3. CALCS_Loads'!E90*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$143*'3. CALCS_Loads'!F90*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$131*'3. CALCS_Loads'!C102*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":8.4002021293228014E-3},{"$f":"'3. CALCS_Loads'!D$131*'3. CALCS_Loads'!D102*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$131*'3. CALCS_Loads'!E102*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$131*'3. CALCS_Loads'!F102*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E22*C$62*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":3.6619053670982289E-2},{"$f":"'3. CALCS_Loads'!F22*D$62*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G22*E$62*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H22*F$62*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!$F33+'5.CALCS_Adams&Papa'!G$41*'3. CALCS_Loads'!K48)*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*C$56","v":0.30284702034210853},{"$f":"('5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!$F33+'5.CALCS_Adams&Papa'!H$41*'3. CALCS_Loads'!L48)*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*D$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!$F33+'5.CALCS_Adams&Papa'!I$41*'3. CALCS_Loads'!M48)*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*E$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!$F33+'5.CALCS_Adams&Papa'!J$41*'3. CALCS_Loads'!N48)*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*F$56","v":0},{"$f":"'3. CALCS_Loads'!I22*C$67*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":1.0480621894527624},{"$f":"'3. CALCS_Loads'!J22*D$67*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!K22*E$67*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!L22*F$67*IF(LOOKUP($A157,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},8.4002021293228014E-3,0,0,0,3.6619053670982289E-2,0.30284702034210853,8.4002021293228014E-3,8.4002021293228014E-3,0.22939429852004337,2.7737443544379552E-2,"YES","YES"]
["TSS",{"$f":"'3. CALCS_Loads'!C$129*'3. CALCS_Loads'!C82*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":347.40866868367704},{"$f":"'3. CALCS_Loads'!D$129*'3. CALCS_Loads'!D82*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$129*'3. CALCS_Loads'!E82*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$129*'3. CALCS_Loads'!F82*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C112*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D112*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E112*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F112*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$143*'3. CALCS_Loads'!C91*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$143*'3. CALCS_Loads'!D91*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$143*'3. CALCS_Loads'!E91*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$143*'3. CALCS_Loads'!F91*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$131*'3. CALCS_Loads'!C103*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0.96213595743452507},{"$f":"'3. CALCS_Loads'!D$131*'3. CALCS_Loads'!D103*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$131*'3. CALCS_Loads'!E103*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$131*'3. CALCS_Loads'!F103*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E23*C$62*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":49.022281527282743},{"$f":"'3. CALCS_Loads'!F23*D$62*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G23*E$62*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H23*F$62*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!$F34+'5.CALCS_Adams&Papa'!G$41*'3. CALCS_Loads'!K49)*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*C$56","v":65.498371230989022},{"$f":"('5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!$F34+'5.CALCS_Adams&Papa'!H$41*'3. CALCS_Loads'!L49)*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*D$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!$F34+'5.CALCS_Adams&Papa'!I$41*'3. CALCS_Loads'!M49)*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*E$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!$F34+'5.CALCS_Adams&Papa'!J$41*'3. CALCS_Loads'!N49)*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*F$56","v":0},{"$f":"'3. CALCS_Loads'!I23*C$67*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":439.33920062918833},{"$f":"'3. CALCS_Loads'!J23*D$67*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!K23*E$67*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!L23*F$67*IF(LOOKUP($A158,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},0.96213595743452507,0,0,0,49.022281527282743,65.498371230989022,0.96213595743452507,0.96213595743452507,1.9626503040236106E-2,1.4689463865313843E-2,"YES","YES"]
["Zn",{"$f":"'3. CALCS_Loads'!C$129*'3. CALCS_Loads'!C83*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0.11762042370232113},{"$f":"'3. CALCS_Loads'!D$129*'3. CALCS_Loads'!D83*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$129*'3. CALCS_Loads'!E83*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$129*'3. CALCS_Loads'!F83*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C113*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D113*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E113*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F113*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$143*'3. CALCS_Loads'!C92*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$143*'3. CALCS_Loads'!D92*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$143*'3. CALCS_Loads'!E92*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$143*'3. CALCS_Loads'!F92*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$131*'3. CALCS_Loads'!C104*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":1.6672081976681118E-3},{"$f":"'3. CALCS_Loads'!D$131*'3. CALCS_Loads'!D104*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$131*'3. CALCS_Loads'!E104*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$131*'3. CALCS_Loads'!F104*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E24*C$62*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":6.9590967722314339E-3},{"$f":"'3. CALCS_Loads'!F24*D$62*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G24*E$62*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H24*F$62*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!$F35+'5.CALCS_Adams&Papa'!G$41*'3. CALCS_Loads'!K50)*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*C$56","v":6.8014978442723972E-2},{"$f":"('5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!$F35+'5.CALCS_Adams&Papa'!H$41*'3. CALCS_Loads'!L50)*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*D$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!$F35+'5.CALCS_Adams&Papa'!I$41*'3. CALCS_Loads'!M50)*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*E$56","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!$F35+'5.CALCS_Adams&Papa'!J$41*'3. CALCS_Loads'!N50)*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)*F$56","v":0},{"$f":"'3. CALCS_Loads'!I24*C$67*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0.18540572898387131},{"$f":"'3. CALCS_Loads'!J24*D$67*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!K24*E$67*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!L24*F$67*IF(LOOKUP($A159,'3. CALCS_Loads'!$A$18:$A$24,'3. CALCS_Loads'!$C$18:$C$24)=\"CF_1\",CF_1,CF_2)","v":0},1.6672081976681118E-3,0,0,0,6.9590967722314339E-3,6.8014978442723972E-2,1.6672081976681118E-3,1.6672081976681118E-3,0.23957249801737152,2.4512368243593326E-2,"YES","YES"]
[]
["PLOT: Developed, Existing, and Sed/Fil Loadings"]
["POLLUTANT",{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",\"Drainage Area A - Existing\",\"Drainage Area A - Sed/Fil\")","v":"Drainage Area A - Existing"},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",\"Drainage Area B - Existing\",\"Drainage Area B - Sed/Fil\")","v":"Drainage Area B - Existing"},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",\"Drainage Area C - Existing\",\"Drainage Area C - Sed/Fil\")","v":"Drainage Area C - Existing"},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",\"Drainage Area D - Existing\",\"Drainage Area D- Sed/Fil\")","v":"Drainage Area D - Existing"},"Drainage Area A Developed (Treated) Load","Drainage Area B Developed (Treated) Load","Drainage Area C Developed (Treated) Load","Drainage Area D Developed (Treated) Load"]
["COD",{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!R153,'3. CALCS_Loads'!V153)","v":11.487751514525895},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!S153,'3. CALCS_Loads'!W153)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!T153,'3. CALCS_Loads'!X153)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!U153,'3. CALCS_Loads'!Y153)","v":0},{"$f":"AD153","v":1.2512593067632269},0,0,0]
["E. coli",{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!R154,'3. CALCS_Loads'!V154)","v":11210.216427389736},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!S154,'3. CALCS_Loads'!W154)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!T154,'3. CALCS_Loads'!X154)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!U154,'3. CALCS_Loads'!Y154)","v":0},1871.0332495062835,0,0,0]
["Pb",{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!R155,'3. CALCS_Loads'!V155)","v":1.2648339263936867E-3},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!S155,'3. CALCS_Loads'!W155)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!T155,'3. CALCS_Loads'!X155)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!U155,'3. CALCS_Loads'!Y155)","v":0},2.6342159422357997E-4,0,0,0]
["TN",{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!R156,'3. CALCS_Loads'!V156)","v":0.35142478926184617},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!S156,'3. CALCS_Loads'!W156)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!T156,'3. CALCS_Loads'!X156)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!U156,'3. CALCS_Loads'!Y156)","v":0},6.7007581424196438E-2,0,0,0]
["TP",{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!R157,'3. CALCS_Loads'!V157)","v":3.6619053670982289E-2},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!S157,'3. CALCS_Loads'!W157)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!T157,'3. CALCS_Loads'!X157)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!U157,'3. CALCS_Loads'!Y157)","v":0},{"$f":"AD157","v":8.4002021293228014E-3},0,0,0]
["TSS",{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!R158,'3. CALCS_Loads'!V158)","v":49.022281527282743},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!S158,'3. CALCS_Loads'!W158)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!T158,'3. CALCS_Loads'!X158)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!U158,'3. CALCS_Loads'!Y158)","v":0},0.96213595743452507,0,0,0]
["Zn",{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!R159,'3. CALCS_Loads'!V159)","v":6.9590967722314339E-3},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!S159,'3. CALCS_Loads'!W159)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!T159,'3. CALCS_Loads'!X159)","v":0},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",'3. CALCS_Loads'!U159,'3. CALCS_Loads'!Y159)","v":0},1.6672081976681118E-3,0,0,0]
[]
["PLOT: Load Equivalency Factor (LEF)"]
["POLLUTANT","RED","GREEN"]
[null,">1","<=1"]
["COD",{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A174,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A174,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))>1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A174,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A174,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A174,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A174,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))<=1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A174,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A174,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":0.10892116748704475}]
["E. coli",{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A175,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A175,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))>1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A175,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A175,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A175,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A175,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))<=1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A175,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A175,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":0.16690429320658065}]
["Pb",{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A176,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A176,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))>1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A176,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A176,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A176,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A176,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))<=1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A176,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A176,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":0.20826575625991589}]
["TN",{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A177,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A177,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))>1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A177,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A177,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A177,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A177,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))<=1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A177,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A177,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":0.19067403174643202}]
["TP",{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A178,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A178,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))>1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A178,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A178,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A178,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A178,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))<=1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A178,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A178,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":0.22939429852004337}]
["TSS",{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A179,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A179,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))>1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A179,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A179,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A179,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A179,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))<=1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A179,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A179,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":1.9626503040236106E-2}]
["Zn",{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A180,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A180,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))>1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A180,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A180,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A180,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A180,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159))<=1,IF('1. ENTER DATA'!$F$14=\"No\",LOOKUP($A180,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AM$153:$AM$159),LOOKUP('3. CALCS_Loads'!$A180,'3. CALCS_Loads'!$A$153:$A$159,'3. CALCS_Loads'!$AL$153:$AL$159)),#N/A)","v":0.23957249801737152}]
[]
[]
["RESULTS: LOAD REMOVED TABLE"]
[]
["POLLUTANT",null,"LOAD REMOVED",null,null,null,null,"PERCENT LOAD REMOVED"]
[null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","TOTAL","Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","TOTAL"]
["COD","lbs/yr",{"$f":"'3. CALCS_Loads'!Z153-'3. CALCS_Loads'!AD153","v":189.8348267500283},{"$f":"'3. CALCS_Loads'!AA153-'3. CALCS_Loads'!AE153","v":0},{"$f":"'3. CALCS_Loads'!AB153-'3. CALCS_Loads'!AF153","v":0},{"$f":"'3. CALCS_Loads'!AC153-'3. CALCS_Loads'!AG153","v":0},{"$f":"SUM(C187:F187)","v":189.8348267500283},{"$f":"IF(C187<>0,C187/(C187+'3. CALCS_Loads'!AD153),\"-\")","v":0.99345185548260517},{"$f":"IF(D187<>0,D187/(D187+'3. CALCS_Loads'!AE153),\"-\")","v":"-"},{"$f":"IF(E187<>0,E187/(E187+'3. CALCS_Loads'!AF153),\"-\")","v":"-"},{"$f":"IF(F187<>0,F187/(F187+'3. CALCS_Loads'!AG153),\"-\")","v":"-"},{"$f":"IF(G187<>0,G187/(G187+'2. RESULTS'!G8),\"-\")","v":0.99345185548260517}]
["E. coli","10^6 MPN/yr",{"$f":"'3. CALCS_Loads'!Z154-'3. CALCS_Loads'!AD154","v":297691.84183854272},{"$f":"'3. CALCS_Loads'!AA154-'3. CALCS_Loads'!AE154","v":0},{"$f":"'3. CALCS_Loads'!AB154-'3. CALCS_Loads'!AF154","v":0},{"$f":"'3. CALCS_Loads'!AC154-'3. CALCS_Loads'!AG154","v":0},{"$f":"SUM(C188:F188)","v":297691.84183854272},{"$f":"IF(C188<>0,C188/(C188+'3. CALCS_Loads'!AD154),\"-\")","v":0.99375412173836186},{"$f":"IF(D188<>0,D188/(D188+'3. CALCS_Loads'!AE154),\"-\")","v":"-"},{"$f":"IF(E188<>0,E188/(E188+'3. CALCS_Loads'!AF154),\"-\")","v":"-"},{"$f":"IF(F188<>0,F188/(F188+'3. CALCS_Loads'!AG154),\"-\")","v":"-"},{"$f":"IF(G188<>0,G188/(G188+'2. RESULTS'!G9),\"-\")","v":0.99375412173836186}]
["Pb","lbs/yr",{"$f":"'3. CALCS_Loads'!Z155-'3. CALCS_Loads'!AD155","v":3.7826041762955696E-2},{"$f":"'3. CALCS_Loads'!AA155-'3. CALCS_Loads'!AE155","v":0},{"$f":"'3. CALCS_Loads'!AB155-'3. CALCS_Loads'!AF155","v":0},{"$f":"'3. CALCS_Loads'!AC155-'3. CALCS_Loads'!AG155","v":0},3.7826041762955696E-2,{"$f":"IF(C189<>0,C189/(C189+'3. CALCS_Loads'!AD155),\"-\")","v":0.99308413479724367},{"$f":"IF(D189<>0,D189/(D189+'3. CALCS_Loads'!AE155),\"-\")","v":"-"},{"$f":"IF(E189<>0,E189/(E189+'3. CALCS_Loads'!AF155),\"-\")","v":"-"},{"$f":"IF(F189<>0,F189/(F189+'3. CALCS_Loads'!AG155),\"-\")","v":"-"},{"$f":"IF(G189<>0,G189/(G189+'2. RESULTS'!G10),\"-\")","v":0.99308413479724367}]
["TN","lbs/yr",{"$f":"'3. CALCS_Loads'!Z156-'3. CALCS_Loads'!AD156","v":5.8084925715685634},{"$f":"'3. CALCS_Loads'!AA156-'3. CALCS_Loads'!AE156","v":0},{"$f":"'3. CALCS_Loads'!AB156-'3. CALCS_Loads'!AF156","v":0},{"$f":"'3. CALCS_Loads'!AC156-'3. CALCS_Loads'!AG156","v":0},5.8084925715685634,{"$f":"IF(C190<>0,C190/(C190+'3. CALCS_Loads'!AD156),\"-\")","v":0.98859542512477594},{"$f":"IF(D190<>0,D190/(D190+'3. CALCS_Loads'!AE156),\"-\")","v":"-"},{"$f":"IF(E190<>0,E190/(E190+'3. CALCS_Loads'!AF156),\"-\")","v":"-"},{"$f":"IF(F190<>0,F190/(F190+'3. CALCS_Loads'!AG156),\"-\")","v":"-"},{"$f":"IF(G190<>0,G190/(G190+'2. RESULTS'!G11),\"-\")","v":0.98859542512477594}]
["TP","lbs/yr",{"$f":"'3. CALCS_Loads'!Z157-'3. CALCS_Loads'!AD157","v":1.0396619873234396},{"$f":"'3. CALCS_Loads'!AA157-'3. CALCS_Loads'!AE157","v":0},{"$f":"'3. CALCS_Loads'!AB157-'3. CALCS_Loads'!AF157","v":0},{"$f":"'3. CALCS_Loads'!AC157-'3. CALCS_Loads'!AG157","v":0},1.0396619873234396,{"$f":"IF(C191<>0,C191/(C191+'3. CALCS_Loads'!AD157),\"-\")","v":0.99198501557077556},{"$f":"IF(D191<>0,D191/(D191+'3. CALCS_Loads'!AE157),\"-\")","v":"-"},{"$f":"IF(E191<>0,E191/(E191+'3. CALCS_Loads'!AF157),\"-\")","v":"-"},{"$f":"IF(F191<>0,F191/(F191+'3. CALCS_Loads'!AG157),\"-\")","v":"-"},{"$f":"IF(G191<>0,G191/(G191+'2. RESULTS'!G12),\"-\")","v":0.99198501557077556}]
["TSS","lbs/yr",{"$f":"'3. CALCS_Loads'!Z158-'3. CALCS_Loads'!AD158","v":438.37706467175383},{"$f":"'3. CALCS_Loads'!AA158-'3. CALCS_Loads'!AE158","v":0},{"$f":"'3. CALCS_Loads'!AB158-'3. CALCS_Loads'!AF158","v":0},{"$f":"'3. CALCS_Loads'!AC158-'3. CALCS_Loads'!AG158","v":0},438.37706467175383,{"$f":"IF(C192<>0,C192/(C192+'3. CALCS_Loads'!AD158),\"-\")","v":0.99781003844852312},{"$f":"IF(D192<>0,D192/(D192+'3. CALCS_Loads'!AE158),\"-\")","v":"-"},{"$f":"IF(E192<>0,E192/(E192+'3. CALCS_Loads'!AF158),\"-\")","v":"-"},{"$f":"IF(F192<>0,F192/(F192+'3. CALCS_Loads'!AG158),\"-\")","v":"-"},{"$f":"IF(G192<>0,G192/(G192+'2. RESULTS'!G13),\"-\")","v":0.99781003844852312}]
["Zn","lbs/yr",{"$f":"'3. CALCS_Loads'!Z159-'3. CALCS_Loads'!AD159","v":0.1837385207862032},{"$f":"'3. CALCS_Loads'!AA159-'3. CALCS_Loads'!AE159","v":0},{"$f":"'3. CALCS_Loads'!AB159-'3. CALCS_Loads'!AF159","v":0},{"$f":"'3. CALCS_Loads'!AC159-'3. CALCS_Loads'!AG159","v":0},0.1837385207862032,{"$f":"IF(C193<>0,C193/(C193+'3. CALCS_Loads'!AD159),\"-\")","v":0.99100778488989871},{"$f":"IF(D193<>0,D193/(D193+'3. CALCS_Loads'!AE159),\"-\")","v":"-"},{"$f":"IF(E193<>0,E193/(E193+'3. CALCS_Loads'!AF159),\"-\")","v":"-"},{"$f":"IF(F193<>0,F193/(F193+'3. CALCS_Loads'!AG159),\"-\")","v":"-"},{"$f":"IF(G193<>0,G193/(G193+'2. RESULTS'!G14),\"-\")","v":0.99100778488989871}]

{"sheet":"4. CALCS_Infiltration","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["SIZING INFILTRATION FIELDS"]
[]
["LOOK UP…",null,"SCM A2","SCM B2","SCM C2","SCM D2"]
["Drainage Area","Ac",{"$f":"DA_A","v":1},{"$f":"DA_B","v":1},{"$f":"DA_C","v":1},{"$f":"DA_D","v":1}]
["Total water application time","hrs",{"$f":"'5.CALCS_Adams&Papa'!B25/'5.CALCS_Adams&Papa'!B28","v":60},{"$f":"'5.CALCS_Adams&Papa'!C25/'5.CALCS_Adams&Papa'!C28","v":60},{"$f":"'5.CALCS_Adams&Papa'!D25/'5.CALCS_Adams&Papa'!D28","v":60},{"$f":"'5.CALCS_Adams&Papa'!E25/'5.CALCS_Adams&Papa'!E28","v":60}]
["Soil Infiltration Rate (permeability)","in/hr",{"$f":"'1. ENTER DATA'!F45","v":0.1},{"$f":"'1. ENTER DATA'!G45","v":0.1},{"$f":"'1. ENTER DATA'!H45","v":0.1},{"$f":"'1. ENTER DATA'!I45","v":0.1}]
["Number of Application Zones",null,{"$f":"'1. ENTER DATA'!F46","v":2},{"$f":"'1. ENTER DATA'!G46","v":2},{"$f":"'1. ENTER DATA'!H46","v":2},{"$f":"'1. ENTER DATA'!I46","v":2}]
[]
["1. WQV_inf Known, Calculate Area"]
["Is this the scenario?","Yes = 1, No = 0",{"$f":"IF('1. ENTER DATA'!F33=\"Yes\",0,1)","v":1},{"$f":"IF('1. ENTER DATA'!G33=\"Yes\",0,1)","v":1},{"$f":"IF('1. ENTER DATA'!H33=\"Yes\",0,1)","v":1},{"$f":"IF('1. ENTER DATA'!I33=\"Yes\",0,1)","v":1}]
["WQV infiltrated","in",{"$f":"IF('1. ENTER DATA'!F42=\"Yes\",'1. ENTER DATA'!F43,'3. CALCS_Loads'!C134)*C10","v":2.5},{"$f":"IF('1. ENTER DATA'!G42=\"Yes\",'1. ENTER DATA'!G43,'3. CALCS_Loads'!D134)*D10","v":0},{"$f":"IF('1. ENTER DATA'!H42=\"Yes\",'1. ENTER DATA'!H43,'3. CALCS_Loads'!E134)*E10","v":0},{"$f":"IF('1. ENTER DATA'!I42=\"Yes\",'1. ENTER DATA'!I43,'3. CALCS_Loads'!F134)*F10","v":0}]
["Field Area","Acres",{"$f":"IF(C7=1,2*C11*C7/(C6*C5)*C4,C11*C7/(C6*C5)*C4)","v":0.83333333333333337},{"$f":"IF(D7=1,2*D11*D7/(D6*D5)*D4,D11*D7/(D6*D5)*D4)","v":0},0,0]
["Application Rate","gpm",{"$f":"IF(C7=1,2*C11*C$4/C$5*452.5,C11*C$4/C$5*452.5)","v":18.854166666666664},{"$f":"D11*D$4/D$5*452.5","v":0},0,0]
[]
[]
["2. RCE_inf Known, Calculate Area"]
["Is this the scenario?","Yes = 1, No = 0",{"$f":"IF('1. ENTER DATA'!F33=\"Yes\",1,0)","v":0},{"$f":"IF('1. ENTER DATA'!G33=\"Yes\",1,0)","v":0},{"$f":"IF('1. ENTER DATA'!H33=\"Yes\",1,0)","v":0},{"$f":"IF('1. ENTER DATA'!I33=\"Yes\",1,0)","v":0}]
["RCE infiltrated","%",{"$f":"'3. CALCS_Loads'!C139","v":0.98105345153995205},{"$f":"'3. CALCS_Loads'!D139","v":0},{"$f":"'3. CALCS_Loads'!E139","v":0},{"$f":"'3. CALCS_Loads'!F139","v":0}]
["WQV infiltrated","inches",{"$f":"'5.CALCS_Adams&Papa'!B63","v":2.5009999999998356},{"$f":"'5.CALCS_Adams&Papa'!C63","v":1E-3},{"$f":"'5.CALCS_Adams&Papa'!D63","v":1E-3},{"$f":"'5.CALCS_Adams&Papa'!E63","v":1E-3}]
["Field Area","Acres",{"$f":"IF(C7=1,2*C19*C7/(C6*C5)*C4,C19*C7/(C6*C5)*C4)","v":0.83366666666661182},{"$f":"IF(D7=1,2*D19*D7/(D6*D5)*D4,D19*D7/(D6*D5)*D4)","v":3.3333333333333332E-4},3.3333333333333332E-4,3.3333333333333332E-4]
["Application Rate","gpm",{"$f":"IF(C7=1,2*C19*C$4/C$5*452.5,C19*C$4/C$5*452.5)","v":18.861708333332093},{"$f":"D19*D$4/D$5*452.5","v":7.541666666666667E-3},7.541666666666667E-3,7.541666666666667E-3]
[]
[]
["3. Values for Use in Calculator",null,"SCM A2","SCM B2","SCM C2","SCM D2"]
["Field Area to Use (Ac)",null,{"$f":"IF(C10=1,C12,C20)","v":0.83333333333333337},{"$f":"IF(D10=1,D12,D20)","v":0},{"$f":"IF(E10=1,E12,E20)","v":0},{"$f":"IF(F10=1,F12,F20)","v":0}]
["WQV_inf to Use (in)",null,{"$f":"IF(C$10=1,C11,C19)","v":2.5},{"$f":"IF(D$10=1,D11,D19)","v":0},0,0]
["Yearly Volume Infiltrated (in/yr)",null,{"$f":"IF(C17=1,C18*'3. CALCS_Loads'!C66,'5.CALCS_Adams&Papa'!B59)","v":11.478578521002165},{"$f":"IF(D17=1,D18*'3. CALCS_Loads'!D66,'5.CALCS_Adams&Papa'!C59)","v":0},{"$f":"IF(E17=1,E18*'3. CALCS_Loads'!E66,'5.CALCS_Adams&Papa'!D59)","v":0},{"$f":"IF(F17=1,F18*'3. CALCS_Loads'!F66,'5.CALCS_Adams&Papa'!E59)","v":0}]
["Application Rate (gpm)",null,{"$f":"IF(C$10=1,C13,C21)","v":18.854166666666664},{"$f":"IF(D$10=1,D13,D21)","v":0},0,0]

{"sheet":"5.CALCS_Adams&Papa","index":4,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["ADAMS & PAPA FOR VOLUMETRIC STORMWATER CONTROL MEASURE"]
[]
["Rainfall Statistics",null,null,"Based on 2017 WPD Report Updating the City of Austin Rainfall Period of Record Timeseries and Statistics. Uses 2004-2013 Camp Mabry rainfall data. "]
["Parameter","Symbol","Value"]
["Mean annual rainfall event volume (in.)","v",0.44]
["Mean annual rainfall event duration (hr)","t",5.66]
["Mean annual rainfall event intensity (in/hr)","i",7.6999999999999999E-2]
["Delta = Time interval between storm event midpoints (hr)","Δ",114.2]
["Interevent time, b (hr) - Figure 4.2 in A&P","b",{"$f":"$C$8-$C$6","v":108.54}]
["Minimum Interevent Time (hr)","IETD",6]
["Psi = 1/(b - IETD)  but using simpler 1/b (1/hr)","y",{"$f":"1/C9","v":9.2131932927952825E-3}]
["Theta = avg. annual number of rainfall events","θ",{"$f":"'3. CALCS_Loads'!A8","v":76.8}]
["Average Annual total rainfall (in.)","P",{"$f":"'3. CALCS_Loads'!A7","v":33.4}]
["Zeta = 1/mean rainfall event volume (1/in)","z",{"$f":"1/v","v":2.2727272727272729}]
["Lambda = 1/mean rainfall event duration (1/hr)","l",{"$f":"1/t","v":0.17667844522968199}]
[]
[null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D",null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
["DRAINAGE AREA CHARACTERISTICS"]
["Drainage Area (acres) DA",{"$f":"'1. ENTER DATA'!F17","v":1},{"$f":"'1. ENTER DATA'!G17","v":1},{"$f":"'1. ENTER DATA'!H17","v":1},{"$f":"'1. ENTER DATA'!I17","v":1},null,{"$f":"DA_A","v":1},{"$f":"DA_B","v":1},{"$f":"DA_C","v":1},{"$f":"DA_D","v":1}]
["Runoff Coefficient Rv",{"$f":"RvA_d","v":0.42249999999999999},{"$f":"RvB_d","v":0.42249999999999999},{"$f":"RvC_d","v":0.42249999999999999},{"$f":"RvD_d","v":0.42249999999999999},null,{"$f":"RvA_d","v":0.42249999999999999},{"$f":"RvB_d","v":0.42249999999999999},{"$f":"RvC_d","v":0.42249999999999999},{"$f":"RvD_d","v":0.42249999999999999}]
["Depression Storage, Sd (in.)",{"$f":"SdA_d","v":8.2446835976164229E-2},{"$f":"SdB_d","v":8.2446835976164229E-2},{"$f":"SdC_d","v":8.2446835976164229E-2},{"$f":"SdD_d","v":8.2446835976164229E-2},null,{"$f":"SdA_d","v":8.2446835976164229E-2},{"$f":"SdB_d","v":8.2446835976164229E-2},{"$f":"SdC_d","v":8.2446835976164229E-2},{"$f":"SdD_d","v":8.2446835976164229E-2}]
[]
["SCM 1 (First in Series)"]
["SCM 1 Type",{"$f":"'1. ENTER DATA'!F24","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!G24","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!H24","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!I24","v":"Retention Basin"},null,"Sed/Fil Std","Sed/Fil Std","Sed/Fil Std","Sed/Fil Std"]
["Water Quality Volume (in.)",{"$f":"WQV_A1","v":2.5},{"$f":"WQV_B1","v":2.5},{"$f":"WQV_C1","v":2.5},{"$f":"WQV_D1","v":2.5},null,{"$f":"'3. CALCS_Loads'!C71","v":0.8},{"$f":"'3. CALCS_Loads'!D71","v":0.8},{"$f":"'3. CALCS_Loads'!E71","v":0.8},{"$f":"'3. CALCS_Loads'!F71","v":0.8}]
["Design Drawdown Time (hr), DDT - or -",{"$f":"DDT_A1","v":60},{"$f":"DDT_B1","v":60},{"$f":"DDT_C1","v":60},{"$f":"DDT_D1","v":60},null,48,48,48,48]
[" - or - Design Flow Rate",{"$f":"'1. ENTER DATA'!F31*0.00221/'5.CALCS_Adams&Papa'!B19","v":3.3326800000000004E-2},{"$f":"'1. ENTER DATA'!G31*0.00221/'5.CALCS_Adams&Papa'!C19","v":3.3326800000000004E-2},{"$f":"'1. ENTER DATA'!H31*0.00221/'5.CALCS_Adams&Papa'!D19","v":3.3326800000000004E-2},{"$f":"'1. ENTER DATA'!I31*0.00221/'5.CALCS_Adams&Papa'!E19","v":3.3326800000000004E-2}]
["Design Treatment Rate (in/hr)",{"$f":"IF('1. ENTER DATA'!F29=\"Flow Rate\",'5.CALCS_Adams&Papa'!B27,'5.CALCS_Adams&Papa'!B25/'5.CALCS_Adams&Papa'!B26)","v":4.1666666666666664E-2},{"$f":"IF('1. ENTER DATA'!G29=\"Flow Rate\",'5.CALCS_Adams&Papa'!C27,'5.CALCS_Adams&Papa'!C25/'5.CALCS_Adams&Papa'!C26)","v":4.1666666666666664E-2},{"$f":"IF('1. ENTER DATA'!H29=\"Flow Rate\",'5.CALCS_Adams&Papa'!D27,'5.CALCS_Adams&Papa'!D25/'5.CALCS_Adams&Papa'!D26)","v":4.1666666666666664E-2},{"$f":"IF('1. ENTER DATA'!I29=\"Flow Rate\",'5.CALCS_Adams&Papa'!E27,'5.CALCS_Adams&Papa'!E25/'5.CALCS_Adams&Papa'!E26)","v":4.1666666666666664E-2}]
["Average Flowrate (gpm)",{"$f":"B28*452.54*B19","v":18.855833333333333},{"$f":"C28*452.54*C19","v":18.855833333333333},18.855833333333333,18.855833333333333]
["Lag time before irrigation (hr)",{"$f":"'1. ENTER DATA'!F38","v":12},{"$f":"'1. ENTER DATA'!G38","v":12},{"$f":"'1. ENTER DATA'!H38","v":12},{"$f":"'1. ENTER DATA'!I38","v":12},null,{"$f":"G26","v":48},{"$f":"H26","v":48},{"$f":"I26","v":48},{"$f":"J26","v":48}]
["Adjusted Treatment Rate, Ω (in/hr)",{"$f":"(1/B28+IF(B25<>0,B30/B25,0))^(-1)","v":3.4722222222222224E-2},{"$f":"(1/C28+IF(C25<>0,C30/C25,0))^(-1)","v":3.4722222222222224E-2},3.4722222222222224E-2,3.4722222222222224E-2,"*Includes lag time",{"$f":"G25/G30","v":1.6666666666666666E-2},{"$f":"H25/H30","v":1.6666666666666666E-2},{"$f":"I25/I30","v":1.6666666666666666E-2},{"$f":"J25/J30","v":1.6666666666666666E-2}]
[]
["AVERAGE ANNUAL RUNOFF CAPTURE ANALYSIS"]
["Avg. Annual Number of Runoff Events Eqn. 7.9",{"$f":"THETA*EXP(-ZETA*B21)","v":63.677129748826701},{"$f":"THETA*EXP(-ZETA*C21)","v":63.677129748826701},{"$f":"THETA*EXP(-ZETA*D21)","v":63.677129748826701},{"$f":"THETA*EXP(-ZETA*E21)","v":63.677129748826701},null,{"$f":"THETA*EXP(-ZETA*G21)","v":63.677129748826701},{"$f":"THETA*EXP(-ZETA*H21)","v":63.677129748826701},{"$f":"THETA*EXP(-ZETA*I21)","v":63.677129748826701},{"$f":"THETA*EXP(-ZETA*J21)","v":63.677129748826701}]
["Avg. Runoff Volume per event (in.)",{"$f":"$C$13/THETA*B20","v":0.18374348958333331},{"$f":"$C$13/THETA*C20","v":0.18374348958333331},{"$f":"$C$13/THETA*D20","v":0.18374348958333331},{"$f":"$C$13/THETA*E20","v":0.18374348958333331},null,{"$f":"$C$13/THETA*G20","v":0.18374348958333331},{"$f":"$C$13/THETA*H20","v":0.18374348958333331},{"$f":"$C$13/THETA*I20","v":0.18374348958333331},{"$f":"$C$13/THETA*J20","v":0.18374348958333331}]
["R Average Annual Runoff Volume (in.)",{"$f":"B34*B35","v":11.700258026700103},{"$f":"C34*C35","v":11.700258026700103},{"$f":"D34*D35","v":11.700258026700103},{"$f":"E34*E35","v":11.700258026700103},null,{"$f":"G34*G35","v":11.700258026700103},{"$f":"H34*H35","v":11.700258026700103},11.700258026700103,{"$f":"J34*J35","v":11.700258026700103}]
["RCE Override by User?",{"$f":"'1. ENTER DATA'!F33","v":"No"},{"$f":"'1. ENTER DATA'!G33","v":"No"},{"$f":"'1. ENTER DATA'!H33","v":"No"},{"$f":"'1. ENTER DATA'!I33","v":"No"}]
["Average Annual Runoff Capture Efficiency RCE (%)",{"$f":"IF(B37=\"Yes\",'1. ENTER DATA'!F34/100,IF(AND(B25=0,'1. ENTER DATA'!F29=\"Drawdown Time\"),0,IF(B28=0,0,AdamsPapa_RCE(B25,B31,B20,B21))))","v":0.98105345153995205},{"$f":"IF(C37=\"Yes\",'1. ENTER DATA'!G34/100,IF(AND(C25=0,'1. ENTER DATA'!G29=\"Drawdown Time\"),0,IF(C28=0,0,AdamsPapa_RCE(C25,C31,C20,C21))))","v":0.98105345153995205},{"$f":"IF(D37=\"Yes\",'1. ENTER DATA'!H34/100,IF(AND(D25=0,'1. ENTER DATA'!H29=\"Drawdown Time\"),0,IF(D28=0,0,AdamsPapa_RCE(D25,D31,D20,D21))))","v":0.98105345153995205},{"$f":"IF(E37=\"Yes\",'1. ENTER DATA'!I34/100,IF(AND(E25=0,'1. ENTER DATA'!I29=\"Drawdown Time\"),0,IF(E28=0,0,AdamsPapa_RCE(E25,E31,E20,E21))))","v":0.98105345153995205},null,{"$f":"1-IF(G31=0,1,1-AdamsPapa_RCE(G25,G31,G20,G21))","v":0.94441041406320492},{"$f":"1-IF(H31=0,1,1-AdamsPapa_RCE(H25,H31,H20,H21))","v":0.94441041406320492},{"$f":"1-IF(I31=0,1,1-AdamsPapa_RCE(I25,I31,I20,I21))","v":0.94441041406320492},{"$f":"1-IF(J31=0,1,1-AdamsPapa_RCE(J25,J31,J20,J21))","v":0.94441041406320492}]
["Avg. Annual Runoff Volume Treated RC (in/yr)",{"$f":"B$36*B38","v":11.478578521002165},{"$f":"C$36*C38","v":11.478578521002165},11.478578521002165,11.478578521002165,null,{"$f":"G36*G38","v":11.049845527642182},{"$f":"H36*H38","v":11.049845527642182},{"$f":"I36*I38","v":11.049845527642182},{"$f":"J36*J38","v":11.049845527642182}]
["Volume treated (Acre-in/yr)",{"$f":"B39*B19","v":11.478578521002165},{"$f":"C39*C19","v":11.478578521002165},{"$f":"D39*D19","v":11.478578521002165},{"$f":"E39*E19","v":11.478578521002165},null,{"$f":"G39*G19","v":11.049845527642182},{"$f":"H39*H19","v":11.049845527642182},{"$f":"I39*I19","v":11.049845527642182},{"$f":"J39*J19","v":11.049845527642182}]
[null,null,null,null,null,null,{"$f":"(G36-G39)*G19","v":0.65041249905792142},{"$f":"(H36-H39)*H19","v":0.65041249905792142},0.65041249905792142,0.65041249905792142]
[]
["SCM 2 (Second in Series) ROUTING"]
["SCM 2 Type",{"$f":"'1. ENTER DATA'!F41","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!G41","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!H41","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!I41","v":"Infiltration Field"}]
["Water Quality Volume (in.) Routed",{"$f":"'3. CALCS_Loads'!C134","v":2.5},{"$f":"'3. CALCS_Loads'!D134","v":0},{"$f":"'3. CALCS_Loads'!E134","v":0},{"$f":"'3. CALCS_Loads'!F134","v":0}]
["Adjusted Treatment Rate, Ω (in/hr)",{"$f":"B31","v":3.4722222222222224E-2},{"$f":"C31","v":3.4722222222222224E-2},{"$f":"D31","v":3.4722222222222224E-2},{"$f":"E31","v":3.4722222222222224E-2}]
[]
["AVERAGE ANNUAL RUNOFF CAPTURE ANALYSIS"]
["Average Annual Runoff Capture Efficiency RCE (%)",{"$f":"IF(B45=0,0,IF(B28=0,0,AdamsPapa_RCE(B45,B46,B20,B21)))","v":0.98105345153995205},{"$f":"IF(C45=0,0,IF(C28=0,0,AdamsPapa_RCE(C45,C46,C20,C21)))","v":0},{"$f":"IF(D45=0,0,IF(D28=0,0,AdamsPapa_RCE(D45,D46,D20,D21)))","v":0},{"$f":"IF(E45=0,0,IF(E28=0,0,AdamsPapa_RCE(E45,E46,E20,E21)))","v":0}]
["Avg. Annual Runoff Volume Captured RC (in/yr)",{"$f":"B$36*B49","v":11.478578521002165},{"$f":"C$36*C49","v":0},0,0]
[]
[]
["SCM 2 Infiltration or Reuse"]
["Infiltrated water quality volume (in)",{"$f":"'4. CALCS_Infiltration'!C26","v":2.5},{"$f":"'4. CALCS_Infiltration'!D26","v":0},{"$f":"'4. CALCS_Infiltration'!E26","v":0},{"$f":"'4. CALCS_Infiltration'!F26","v":0}]
["Adjusted Treatment Rate, Ω (in/hr)",{"$f":"B46","v":3.4722222222222224E-2},{"$f":"C46","v":3.4722222222222224E-2},{"$f":"D46","v":3.4722222222222224E-2},{"$f":"E46","v":3.4722222222222224E-2}]
[]
["AVERAGE ANNUAL RUNOFF CAPTURE ANALYSIS"]
["Average Annual Runoff Capture Efficiency RCE (%)",{"$f":"IF(B54=0,0,IF(B28=0,0,AdamsPapa_RCE(B54,B55,B20,B21)))","v":0.98105345153995205},{"$f":"IF(C54=0,0,IF(C28=0,0,AdamsPapa_RCE(C54,C55,C20,C21)))","v":0},{"$f":"IF(D54=0,0,IF(D28=0,0,AdamsPapa_RCE(D54,D55,D20,D21)))","v":0},{"$f":"IF(E54=0,0,IF(E28=0,0,AdamsPapa_RCE(E54,E55,E20,E21)))","v":0}]
["Avg. Annual Runoff Volume Captured RC (in/yr)",{"$f":"B$36*B58","v":11.478578521002165},{"$f":"C$36*C58","v":0},{"$f":"D$36*D58","v":0},{"$f":"E$36*E58","v":0}]
[]
["Back-calculate WQVinf from RCE (user input)"]
["User Input RCE",{"$f":"'3. CALCS_Loads'!C139","v":0.98105345153995205},{"$f":"'3. CALCS_Loads'!D139","v":0},{"$f":"'3. CALCS_Loads'!E139","v":0},{"$f":"'3. CALCS_Loads'!F139","v":0}]
["Estimate WQVinf",{"$f":"WQV_from_RCE(B62,B26+B30,B20,B21)","v":2.5009999999998356},{"$f":"WQV_from_RCE(C62,C26+C30,C20,C21)","v":1E-3},{"$f":"WQV_from_RCE(D62,D26+D30,D20,D21)","v":1E-3},{"$f":"WQV_from_RCE(E62,E26+E30,E20,E21)","v":1E-3}]

{"sheet":"6. Error Checking","index":5,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
["ERROR CHECK"]
[null,"Error Checking On?",null,"Yes",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,"Analyze? ",{"$f":"IF(n_DA>=1,1,0)","v":1},{"$f":"IF(n_DA>=2,1,0)","v":0},{"$f":"IF(n_DA>=3,1,0)","v":0},{"$f":"IF(n_DA>=4,1,0)","v":0}]
[null,"Make sure the following are TRUE:",null,null,null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","Error Message","Print Error Message","Reference Sheet",null,"0 = false (error)"]
[null,"Is RCE infiltrated <= RCE of SCM 1? ",null,null,null,null,{"$f":"IF('3. CALCS_Loads'!C139<='3. CALCS_Loads'!C127,1,0)","v":1},{"$f":"IF('3. CALCS_Loads'!D139<='3. CALCS_Loads'!D127,1,0)","v":1},{"$f":"IF('3. CALCS_Loads'!E139<='3. CALCS_Loads'!E127,1,0)","v":1},{"$f":"IF('3. CALCS_Loads'!F139<='3. CALCS_Loads'!F127,1,0)","v":1},"Infiltrated runoff capture efficiency cannot be > capture efficiency of SCM 1. ",{"$f":"IF(OR(AND(G$23>0,G6=0),AND(H$23>0,H6=0),AND(I$23>0,I6=0),AND(J$23>0,J6=0)),K6,\"\")","v":""},"1. Enter Data",null,"1 = true (complies)"]
[null,"Error found in volumes on Sheet 3? ",null,null,null,null,{"$f":"IF('3. CALCS_Loads'!C146=1,0,1)","v":1},{"$f":"IF('3. CALCS_Loads'!D146=1,0,1)","v":1},{"$f":"IF('3. CALCS_Loads'!E146=1,0,1)","v":1},{"$f":"IF('3. CALCS_Loads'!F146=1,0,1)","v":1},"Volumes incompatible - check inputs. ",""]
[null,"Is WQV proposed >= min. WQV?",null,null,null,null,{"$f":"IF(WQV_A1>='1. ENTER DATA'!F27,1,0)","v":1},{"$f":"IF(WQV_B1>='1. ENTER DATA'!G27,1,0)","v":1},{"$f":"IF(WQV_C1>='1. ENTER DATA'!H27,1,0)","v":1},{"$f":"IF(WQV_D1>='1. ENTER DATA'!I27,1,0)","v":1},"Water quality volume does not meet minimum. ",""]
[null,"Is user-entered RCE for first control <= 1.0 (100%?)",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F34<=100,1,0)","v":1},{"$f":"IF('1. ENTER DATA'!G34<=100,1,0)","v":1},{"$f":"IF('1. ENTER DATA'!H34<=100,1,0)","v":1},{"$f":"IF('1. ENTER DATA'!I34<=100,1,0)","v":1},"User entered RCE should not exceed 100%. ",""]
[null,"If user input RCE for SCM 1, does not have user input WQV for SCM 2 ",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F33=\"Yes\",IF('1. ENTER DATA'!F42<>\"Yes; know WQV (in)\",1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!G33=\"Yes\",IF('1. ENTER DATA'!G42<>\"Yes; know WQV (in)\",1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!H33=\"Yes\",IF('1. ENTER DATA'!H42<>\"Yes; know WQV (in)\",1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!I33=\"Yes\",IF('1. ENTER DATA'!I42<>\"Yes; know WQV (in)\",1,0),1)","v":1},"If user input RCE for SCM 1, RCE must also be given for SCM 2. ",""]
[null,"Only allow \"flow rate\" if alternative control",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F29=\"Flow Rate\",IF('1. ENTER DATA'!F24=\"Alternative\",1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!G29=\"Flow Rate\",IF('1. ENTER DATA'!G24=\"Alternative\",1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!H29=\"Flow Rate\",IF('1. ENTER DATA'!H24=\"Alternative\",1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!I29=\"Flow Rate\",IF('1. ENTER DATA'!I24=\"Alternative\",1,0),1)","v":1},"Input FLOW RATE only if SCM 1 is alternative control. ",""]
[null,"Is soil infiltration rate <= 0.2 in/hr when in BSZ?",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F14=\"Yes\",IF('1. ENTER DATA'!F45<=0.2,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!G14=\"Yes\",IF('1. ENTER DATA'!G45<=0.2,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!H14=\"Yes\",IF('1. ENTER DATA'!H45<=0.2,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!I14=\"Yes\",IF('1. ENTER DATA'!I45<=0.2,1,0),1)","v":1},"For BSZ, infiltration rate cannot exceed 0.2 in/hr. ",""]
[null,"Is soil infiltration rate > 0?",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F45>0,1,0)","v":1},{"$f":"IF('1. ENTER DATA'!G45>0,1,0)","v":1},{"$f":"IF('1. ENTER DATA'!H45>0,1,0)","v":1},{"$f":"IF('1. ENTER DATA'!I45>0,1,0)","v":1},"Infiltration rate must be greater than 0 in/hr. ",""]
[null,"If pumped system, is # of irrigation zones >= 2? ",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F37=\"Pumped\",IF('1. ENTER DATA'!F46>=2,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!G37=\"Pumped\",IF('1. ENTER DATA'!G46>=2,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!H37=\"Pumped\",IF('1. ENTER DATA'!H46>=2,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!I37=\"Pumped\",IF('1. ENTER DATA'!I46>=2,1,0),1)","v":1},"Must have at least 2 irrigation zones if pumped. ",""]
[null,"If pumped system, is time delay 12 hours? ",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F37=\"Pumped\",IF('1. ENTER DATA'!F38>=12,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!G37=\"Pumped\",IF('1. ENTER DATA'!G38>=12,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!H37=\"Pumped\",IF('1. ENTER DATA'!H38>=12,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!I37=\"Pumped\",IF('1. ENTER DATA'!I38>=12,1,0),1)","v":1},"Must have delay of 12 hours if pumped. ",""]
[null,"If gravity drained and BSZ, is first control sed/fil?",null,null,null,null,{"$f":"IF(AND('1. ENTER DATA'!F37<>\"Pumped\",'1. ENTER DATA'!$F$14=\"Yes\"),IF('1. ENTER DATA'!F24=\"Sedimentation/Filtration\",1,0),1)","v":1},{"$f":"IF(AND('1. ENTER DATA'!G37<>\"Pumped\",'1. ENTER DATA'!$F$14=\"Yes\"),IF('1. ENTER DATA'!G24=\"Sedimentation/Filtration\",1,0),1)","v":1},{"$f":"IF(AND('1. ENTER DATA'!H37<>\"Pumped\",'1. ENTER DATA'!$F$14=\"Yes\"),IF('1. ENTER DATA'!H24=\"Sedimentation/Filtration\",1,0),1)","v":1},{"$f":"IF(AND('1. ENTER DATA'!I37<>\"Pumped\",'1. ENTER DATA'!$F$14=\"Yes\"),IF('1. ENTER DATA'!I24=\"Sedimentation/Filtration\",1,0),1)","v":1},"For BSZ, gravity drained allowed only if first control is sed/fil. ",""]
[null,"If BSZ where pumped, infiltrates all water? ",null,null,null,null,{"$f":"IF(AND('1. ENTER DATA'!$F$14=\"Yes\",'1. ENTER DATA'!F37=\"Pumped\"),IF('3. CALCS_Loads'!C139<>'3. CALCS_Loads'!C135,0,1),1)","v":1},{"$f":"IF(AND('1. ENTER DATA'!$F$14=\"Yes\",'1. ENTER DATA'!G37=\"Pumped\"),IF('3. CALCS_Loads'!D139<>'3. CALCS_Loads'!D135,0,1),1)","v":1},{"$f":"IF(AND('1. ENTER DATA'!$F$14=\"Yes\",'1. ENTER DATA'!H37=\"Pumped\"),IF('3. CALCS_Loads'!E139<>'3. CALCS_Loads'!E135,0,1),1)","v":1},{"$f":"IF(AND('1. ENTER DATA'!$F$14=\"Yes\",'1. ENTER DATA'!I37=\"Pumped\"),IF('3. CALCS_Loads'!F139<>'3. CALCS_Loads'!F135,0,1),1)","v":1},"For BSZ pumped systems, ALL captured water must be irrigated/infiltrated. ",""]
[null,"If BSZ and SCM 1 is retention, should be off-line",null,null,null,null,{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",IF('1. ENTER DATA'!F24='1. ENTER DATA'!$T$7,IF('1. ENTER DATA'!F25='1. ENTER DATA'!$W$10,1,0),1),1)","v":1},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",IF('1. ENTER DATA'!G24='1. ENTER DATA'!$T$7,IF('1. ENTER DATA'!G25='1. ENTER DATA'!$W$10,1,0),1),1)","v":1},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",IF('1. ENTER DATA'!H24='1. ENTER DATA'!$T$7,IF('1. ENTER DATA'!H25='1. ENTER DATA'!$W$10,1,0),1),1)","v":1},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",IF('1. ENTER DATA'!I24='1. ENTER DATA'!$T$7,IF('1. ENTER DATA'!I25='1. ENTER DATA'!$W$10,1,0),1),1)","v":1},"Retention basins must be offline. ",""]
[null,"If BSZ and SCM is retention, does it have a 60-hour DDT?",null,null,null,null,{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",IF('1. ENTER DATA'!F24='1. ENTER DATA'!$T$7,IF(DDT_A1=60,1,0),1),1)","v":1},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",IF('1. ENTER DATA'!G24='1. ENTER DATA'!$T$7,IF(DDT_B1=60,1,0),1),1)","v":1},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",IF('1. ENTER DATA'!H24='1. ENTER DATA'!$T$7,IF(DDT_C1=60,1,0),1),1)","v":1},{"$f":"IF('1. ENTER DATA'!$F$14=\"Yes\",IF('1. ENTER DATA'!I24='1. ENTER DATA'!$T$7,IF(DDT_D1=60,1,0),1),1)","v":1},"Retention/irrigation must have 60 hour drawdown time.",""]
[null,"If SCM 1 is alternative control, are all effluent concentrations entered?",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F24=\"Alternative\",IF(COUNTA('1. ENTER DATA'!F53:F59)=7,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!G24=\"Alternative\",IF(COUNTA('1. ENTER DATA'!G53:G59)=7,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!H24=\"Alternative\",IF(COUNTA('1. ENTER DATA'!H53:H59)=7,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!I24=\"Alternative\",IF(COUNTA('1. ENTER DATA'!I53:I59)=7,1,0),1)","v":1},"For alternative SCM 1, enter all effluent concentrations. ",""]
[null,"If SCM 2 is alternative control, are all effluent concentrations entered?",null,null,null,null,{"$f":"IF('1. ENTER DATA'!F41=\"Alternative\",IF(COUNTA('1. ENTER DATA'!F62:F68)=7,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!G41=\"Alternative\",IF(COUNTA('1. ENTER DATA'!G62:G68)=7,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!H41=\"Alternative\",IF(COUNTA('1. ENTER DATA'!H62:H68)=7,1,0),1)","v":1},{"$f":"IF('1. ENTER DATA'!I41=\"Alternative\",IF(COUNTA('1. ENTER DATA'!I62:I68)=7,1,0),1)","v":1},"For alternative SCM 2, enter all effluent concentrations. ",""]
[]
[null,"Errors by Drainage Area",null,null,null,null,{"$f":"(COUNT(G6:G22)-SUM(G6:G22))*G4","v":0},{"$f":"(COUNT(H6:H22)-SUM(H6:H22))*H4","v":0},{"$f":"(COUNT(I6:I22)-SUM(I6:I22))*I4","v":0},{"$f":"(COUNT(J6:J22)-SUM(J6:J22))*J4","v":0}]
[]
[null,"Overall Number of Errors",null,null,null,null,{"$f":"SUM(G23:J23)","v":0}]
[]
[null,"Error Check Override",null,null,null,null,{"$f":"IF(D2=\"No\",0,G25)","v":0}]
[]
[null,"Error Condition",null,null,null,null,{"$f":"IF(D2=\"Yes\",IF(G25>0,1,2),3)","v":2},"1 = ERRORS FOUND; ANALYSIS INCOMPLETE"]
[null,null,null,null,null,null,null,"2 = ERROR CHECK PASSED"]
[null,null,null,null,null,null,null,"3 = ERROR CHECK OFF"]
[]
[null,"Error Message",null,null,null,null,{"$f":"IF(G29=1,(TEXT(G25,\"0\")&\" ERRORS FOUND; ANALYSIS INCOMPLETE\"),IF(G29=2,\"ERROR CHECK PASSED\",\"ERROR CHECK OFF\"))","v":"ERROR CHECK PASSED"}]
[null,"Error Message - Detailed",null,null,null,null,{"$f":"CONCATENATE(L6,L7,L8,L9,L10,L11,L12,L13,L14,L15,L16,L17,L18,L19,L20,L21,L22)","v":""},null,null,"update formula if more rows added"]