{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1. ENTER DATA","2. RESULTS","3. CALCS_Loads","4. CALCS_Infiltration","5.CALCS_Adams&Papa"],"not_rendered":{"charts":11,"images":5,"macros":1,"external_links":0,"defined_names":94,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. ENTER DATA","index":0,"n_rows":82,"n_cols":22,"rows_kept":82,"cut":false,"hidden":false,"merged":[[52,1,52,3],[30,1,30,3],[59,1,59,7],[54,1,54,3],[44,1,44,3],[53,1,53,3],[31,1,31,3],[35,1,35,3],[27,1,27,3],[32,1,32,3],[33,1,33,3],[43,1,43,3],[39,1,39,3],[34,1,34,3],[37,1,37,3],[36,1,36,3],[0,1,0,7],[81,9,81,10],[58,9,58,10],[45,1,45,3],[51,1,51,3],[56,1,56,3],[48,1,48,3],[50,1,50,3],[47,1,47,3],[38,1,38,3],[1,1,1,7],[28,1,28,3],[27,9,27,10],[25,1,25,3],[26,1,26,3],[29,1,29,3],[1,16,1,21],[23,1,23,3],[24,1,24,3],[11,1,11,2],[14,1,14,3],[10,1,10,7],[22,1,22,7]]}
["Row","STORMWATER LOAD ANALYSIS TOOL 1.1"]
[2,"For full instructions and assumptions, see SLAT User Manual.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Internal Lists"]
[{"$f":"A2+1","v":3},"(1) Enable Macros in the worksheet."]
[4,"(2) If performing a new analysis, click \"Restore Defaults\" button to the right.",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,"(3) Answer questions in the yellow cells. Move vertically from top to bottom.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None","None","Pumped","Yes",1,"Irrigation"]
[6,"(4) Click \"View Full Results\" button at bottom. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biofiltration","Infiltration Field","Gravity Drained","No",2,"Level spread"]
[7,"Assumptions: SCMs IN SERIES that treat a specified drainage area, and the second SCM only receives treated volume (not bypass/overflow) from the first SCM. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retention Basin","Beneficial Reuse",null,null,3,"N/A"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rainwater Harvesting","Alternative",null,null,4]
[9,"KEY","Required User Input","Key User Input","Internal Calculation","Error","Calculator Output","Does Not Apply",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,"Alternative",null,"Drawdown Time","Yes (Off-Line)"]
[11,"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,"Flow Rate","No (On-Line)"]
[12,"Site Name",null,null,"Editor Name",null,"Date","SLAT 1.1 - 3/2015",null,"Simplified Schematic"]
[13,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,"Is your site within the Barton Springs Zone? ",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,"Captions",null,null,"Yes","Yes"]
[15,"How many drainage areas, nmax, does your site have? ",null,null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E14=\"Yes\",\"Existing\",\"Sed/Fil Equiv\")","v":"Existing"},"Developed, Untreated","Proposed","No; infiltrate all routed water","No; calculate area"]
[16,null,null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
[17,"Drainage area to the control, An (Acres)",null,null,1,1,1,1,null,null,null,null,null,null,null,null,"Baseline Loads",null,null,"Compliance Factor"]
[18,"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,"Compliance Factor (Compare to Baseline)"]
[19,"Developed impervious cover of the drainage area, ICD (%)",null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"Compliance Factor (Compare to Sed/Fil)"]
[20,"Annual average runoff for existing site, VEx (in/yr)",null,null,{"$f":"'3. CALCS_Loads'!C83","v":1.1845187709210347},{"$f":"'3. CALCS_Loads'!D83","v":0},{"$f":"'3. CALCS_Loads'!E83","v":0},{"$f":"'3. CALCS_Loads'!F83","v":0}]
[21,"Annual average runoff for developed site, Vd (in/yr)",null,null,{"$f":"'3. CALCS_Loads'!C88","v":1.1845187709210347},{"$f":"'3. CALCS_Loads'!D88","v":0},{"$f":"'3. CALCS_Loads'!E88","v":0},{"$f":"'3. CALCS_Loads'!F88","v":0}]
[22]
[23,"Step 2: Input SCM characteristics in yellow highlighted cells"]
[24,null,null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
[25,"SCM 1 (First in Series)",null,null,"SCM A1","SCM B1","SCM C1","SCM D1"]
[26,"SCM Type",null,null,"Retention Basin","Retention Basin","Retention Basin","Retention Basin"]
[27,"Is SCM 1 off-line?",null,null,"Yes (Off-Line)","Yes (Off-Line)","Yes (Off-Line)","Yes (Off-Line)"]
[28,"What is the water quality volume, WQV, (in)?",null,null,2.5,2.5,2.5,2.5,null,{"$f":"'2. RESULTS'!G18","v":"COMPLIANT"}]
[29,"Minimum water quality volume allowed (in)",null,null,{"$f":"IF($E$14=\"Yes\",'3. CALCS_Loads'!C93,0)","v":0.5},{"$f":"IF($E$14=\"Yes\",'3. CALCS_Loads'!D93,0)","v":0.5},{"$f":"IF($E$14=\"Yes\",'3. CALCS_Loads'!E93,0)","v":0.5},{"$f":"IF($E$14=\"Yes\",'3. CALCS_Loads'!F93,0)","v":0.5}]
[30,"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}]
[31,"Do you know the drawdown time or the flow rate? ",null,null,"Drawdown Time","Drawdown Time","Drawdown Time","Drawdown Time"]
[32,"Drawdown Time, DDT (hrs)",null,null,60,60,60,60]
[33,"Flow Rate (gpm)",null,null,15.08,15.08,15.08,15.08]
[34,"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}]
[35,"Do you already know the runoff capture efficiency? ",null,null,"No","No","No","No"]
[36,"User Entered Runoff Capture Efficiency, RCE (%)",null,null,0,0,0,0]
[{"$f":"A36+1","v":37},"Runoff Capture Efficiency, RCE (%)",null,null,{"$f":"IF(E$26=\"None\",0,IF(E35=\"Yes\",E36,RCE_A1_AP*100))","v":99.953062408075681},{"$f":"IF(F$26=\"None\",0,IF(F35=\"Yes\",F36,RCE_B1_AP*100))","v":99.953062408075681},{"$f":"IF(G$26=\"None\",0,IF(G35=\"Yes\",G36,RCE_C1_AP*100))","v":99.953062408075681},{"$f":"IF(H$26=\"None\",0,IF(H35=\"Yes\",H36,RCE_D1_AP*100))","v":99.953062408075681}]
[38,"Annual average volume treated by SCM 1, VT,1 (in/yr)",null,null,{"$f":"'3. CALCS_Loads'!C144","v":1.1839627863340729},{"$f":"'3. CALCS_Loads'!D144","v":0},{"$f":"'3. CALCS_Loads'!E144","v":0},{"$f":"'3. CALCS_Loads'!F144","v":0}]
[39,"Annual average bypass volume, Vby,1 (in/yr)",null,null,{"$f":"'3. CALCS_Loads'!C146","v":5.5598458696182185E-4},{"$f":"'3. CALCS_Loads'!D146","v":0},{"$f":"'3. CALCS_Loads'!E146","v":0},{"$f":"'3. CALCS_Loads'!F146","v":0}]
[40,"Conveyance"]
[41,"How is effluent from SCM 1 discharged?",null,null,"Pumped","Pumped","Pumped","Pumped"]
[42,"Delay after end of rainfall before discharging SCM 1 (hrs)",null,null,12,12,12,12]
[43]
[44,"SCM 2 (Second in Series)",null,null,"SCM A2","SCM B2","SCM C2","SCM D2"]
[45,"SCM Type",null,null,"Infiltration Field","Infiltration Field","Infiltration Field","Infiltration Field"]
[46,"Percent of SCM 1's WQV routed to SCM 2",null,null,100,100,100,100]
[47,"Water quality volume routed to SCM 2 (in)",null,null,{"$f":"'3. CALCS_Loads'!C150","v":2.5},{"$f":"'3. CALCS_Loads'!D150","v":0},{"$f":"'3. CALCS_Loads'!E150","v":0},{"$f":"'3. CALCS_Loads'!F150","v":0}]
[48,"Does SCM 2 reduce volume, such as by infiltration?",null,null,"Yes","Yes","Yes","Yes"]
[49,"Do you already know the infiltrated or reused water quality volume? ",null,null,"No; infiltrate all routed water","No; infiltrate all routed water","No; infiltrate all routed water","No; infiltrate all routed water"]
[{"$f":"A49+1","v":50},"User-entered infilt. water quality volume, WQVinf (in)",null,null,0,0,0,0]
[51,"Number of application zones",null,null,2,2,2,2]
[{"$f":"A51+1","v":52},"Soil infiltration rate (in/hr)",null,null,0.2,0.2,0.2,0.2]
[{"$f":"A52+1","v":53},"Assumed total application time (hrs)",null,null,{"$f":"'4. CALCS_Infiltration'!E5","v":60},{"$f":"'4. CALCS_Infiltration'!F5","v":60},{"$f":"'4. CALCS_Infiltration'!G5","v":60},{"$f":"'4. CALCS_Infiltration'!H5","v":60}]
[54,"Do you know the infiltration field area?",null,null,"No; calculate area","No; calculate area","No; calculate area","No; calculate area"]
[55,"User-Entered Infiltration Field Area (Ac)",null,null,0,0,0,0]
[56,"Field Area (Ac)",null,null,{"$f":"'4. CALCS_Infiltration'!E20","v":0.41666666666666669},{"$f":"'4. CALCS_Infiltration'!F20","v":0},{"$f":"'4. CALCS_Infiltration'!G20","v":0},{"$f":"'4. CALCS_Infiltration'!H20","v":0}]
[57,"Annual Infiltrated Volume, Vinf (in/yr)",null,null,{"$f":"'3. CALCS_Loads'!C154","v":1.1839627863340727},{"$f":"'3. CALCS_Loads'!D154","v":0},{"$f":"'3. CALCS_Loads'!E154","v":0},{"$f":"'3. CALCS_Loads'!F154","v":0}]
[{"$f":"A57+1","v":58},"Annual Non-Infilt. Volume Treated by SCM 2, VT,2 (in/yr)",null,null,{"$f":"'3. CALCS_Loads'!C156","v":0},{"$f":"'3. CALCS_Loads'!D156","v":0},{"$f":"'3. CALCS_Loads'!E156","v":0},{"$f":"'3. CALCS_Loads'!F156","v":0}]
[{"$f":"A58+1","v":59},null,null,null,null,null,null,null,null,{"$f":"J28","v":"COMPLIANT"}]
[60,"Step 3: Input Effluent Data for Alternative SCMs"]
[61,null,null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D"]
[62,null,null,null,"SCM A1","SCM B1","SCM C1","SCM D1"]
[63,null,"Pollutant","Units",{"$f":"E26","v":"Retention Basin"},{"$f":"F26","v":"Retention Basin"},"Retention Basin","Retention Basin"]
[64,null,"COD","mg/L"]
[65,null,"E. coli","CFU/100mL"]
[66,null,"Pb","mg/L"]
[67,null,"TN","mg/L"]
[68,null,"TOC","mg/L"]
[69,null,"TP","mg/L"]
[70,null,"TSS","mg/L"]
[71,null,"Zn","mg/L"]
[72,null,null,null,{"$f":"E44","v":"SCM A2"},"SCM B2","SCM C2",{"$f":"H44","v":"SCM D2"}]
[73,null,"Pollutant",null,{"$f":"E45","v":"Infiltration Field"},{"$f":"F45","v":"Infiltration Field"},"Infiltration Field","Infiltration Field"]
[74,null,"COD","mg/L"]
[75,null,"E. coli","CFU/100mL"]
[76,null,"Pb","mg/L"]
[77,null,"TN","mg/L"]
[78,null,"TOC","mg/L"]
[79,null,"TP","mg/L"]
[80,null,"TSS","mg/L"]
[81,null,"Zn","mg/L"]
[82,null,null,null,null,null,null,null,null,{"$f":"J59","v":"COMPLIANT"}]

{"sheet":"2. RESULTS","index":1,"n_rows":40,"n_cols":19,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,2],[28,6,30,6],[35,6,36,6],[5,2,5,6],[0,0,0,7],[27,0,27,2],[28,7,30,7],[38,0,38,2],[37,0,37,2],[35,0,36,2],[32,0,32,2],[31,0,31,2],[24,0,24,1],[34,0,34,2],[0,10,0,17],[5,8,6,8],[35,4,36,4],[35,3,36,3],[5,0,6,1],[5,7,6,7],[5,9,6,9],[35,5,36,5],[26,0,26,2],[28,5,30,5],[17,6,18,7],[28,4,30,4],[35,7,36,7],[28,3,30,3],[28,0,30,2],[33,0,33,2]]}
[{"$f":"'1. ENTER DATA'!B1","v":"STORMWATER LOAD ANALYSIS TOOL 1.1"},null,null,null,null,null,null,null,null,"1/2",{"$f":"A1","v":"STORMWATER LOAD ANALYSIS TOOL 1.1"},null,null,null,null,null,null,null,"2/2"]
["Site Name:",{"$f":"'1. ENTER DATA'!B12","v":"Site Name"},null,null,"By:",{"$f":"'1. ENTER DATA'!E12","v":"Editor Name"},null,"Date:",{"$f":"'1. ENTER DATA'!G12","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,null,null,{"$f":"'1. ENTER DATA'!H12","v":"SLAT 1.1 - 3/2015"},"RESULTS: PLOTS",null,null,null,null,null,null,null,{"$f":"'1. ENTER DATA'!H12","v":"SLAT 1.1 - 3/2015"}]
[]
[]
["POLLUTANT",null,"DEVELOPED LOAD, WITH CONTROLS",null,null,null,null,{"$f":"IF('1. ENTER DATA'!E14=\"Yes\",\"EXISTING LOAD\",\"SED/FIL LOAD\")","v":"EXISTING LOAD"},"LOAD EQUIV. FACTOR, LEF","FULLY COMPLIES?"]
[null,null,"Drainage Area A","Drainage Area B","Drainage Area C","Drainage Area D","TOTAL LOAD, Lout"]
["COD","lbs/yr",{"$f":"'3. CALCS_Loads'!Z166","v":3.1451373828027501E-3},{"$f":"'3. CALCS_Loads'!AA166","v":0},{"$f":"'3. CALCS_Loads'!AB166","v":0},{"$f":"'3. CALCS_Loads'!AC166","v":0},{"$f":"SUM(C8:F8)","v":3.1451373828027501E-3},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AD166,'3. CALCS_Loads'!AE166)","v":10.445832768807366},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AH166,'3. CALCS_Loads'!AI166)","v":3.0109015263910264E-4},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AJ166,'3. CALCS_Loads'!AK166)","v":"YES"}]
["E. coli","10^6 MPN/yr",{"$f":"'3. CALCS_Loads'!Z167","v":4.7029872910285206},{"$f":"'3. CALCS_Loads'!AA167","v":0},{"$f":"'3. CALCS_Loads'!AB167","v":0},{"$f":"'3. CALCS_Loads'!AC167","v":0},{"$f":"SUM(C9:F9)","v":4.7029872910285206},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AD167,'3. CALCS_Loads'!AE167)","v":10193.469623240113},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AH167,'3. CALCS_Loads'!AI167)","v":4.6137257134765673E-4},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AJ167,'3. CALCS_Loads'!AK167)","v":"YES"}]
["Pb","lbs/yr",{"$f":"'3. CALCS_Loads'!Z168","v":5.39836626216777E-7},{"$f":"'3. CALCS_Loads'!AA168","v":0},{"$f":"'3. CALCS_Loads'!AB168","v":0},{"$f":"'3. CALCS_Loads'!AC168","v":0},5.39836626216777E-7,{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AD168,'3. CALCS_Loads'!AE168)","v":1.1501157261902815E-3},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AH168,'3. CALCS_Loads'!AI168)","v":4.6937591924333316E-4},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AJ168,'3. CALCS_Loads'!AK168)","v":"YES"}]
["TN","lbs/yr",{"$f":"'3. CALCS_Loads'!Z169","v":1.6842875663683436E-4},{"$f":"'3. CALCS_Loads'!AA169","v":0},{"$f":"'3. CALCS_Loads'!AB169","v":0},{"$f":"'3. CALCS_Loads'!AC169","v":0},1.6842875663683436E-4,{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AD169,'3. CALCS_Loads'!AE169)","v":0.31955118238768027},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AH169,'3. CALCS_Loads'!AI169)","v":5.2707912196831171E-4},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AJ169,'3. CALCS_Loads'!AK169)","v":"YES"}]
["TOC","lbs/yr",{"$f":"'3. CALCS_Loads'!Z170","v":1.1988437757772159E-3},{"$f":"'3. CALCS_Loads'!AA170","v":0},{"$f":"'3. CALCS_Loads'!AB170","v":0},{"$f":"'3. CALCS_Loads'!AC170","v":0},{"$f":"SUM(C12:F12)","v":1.1988437757772159E-3},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AD170,'3. CALCS_Loads'!AE170)","v":3.4989511819424157},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AH170,'3. CALCS_Loads'!AI170)","v":3.4262946621384043E-4},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AJ170,'3. CALCS_Loads'!AK170)","v":"YES"}]
["TP","lbs/yr",{"$f":"'3. CALCS_Loads'!Z171","v":2.1114560025429979E-5},{"$f":"'3. CALCS_Loads'!AA171","v":0},{"$f":"'3. CALCS_Loads'!AB171","v":0},{"$f":"'3. CALCS_Loads'!AC171","v":0},2.1114560025429979E-5,{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AD171,'3. CALCS_Loads'!AE171)","v":3.329777026560702E-2},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AH171,'3. CALCS_Loads'!AI171)","v":6.3411333122323282E-4},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AJ171,'3. CALCS_Loads'!AK171)","v":"YES"}]
["TSS","lbs/yr",{"$f":"'3. CALCS_Loads'!Z172","v":2.4184034042475234E-3},{"$f":"'3. CALCS_Loads'!AA172","v":0},{"$f":"'3. CALCS_Loads'!AB172","v":0},{"$f":"'3. CALCS_Loads'!AC172","v":0},2.4184034042475234E-3,{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AD172,'3. CALCS_Loads'!AE172)","v":44.576047291054564},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AH172,'3. CALCS_Loads'!AI172)","v":5.4253428718271391E-5},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AJ172,'3. CALCS_Loads'!AK172)","v":"YES"}]
["Zn","lbs/yr",{"$f":"'3. CALCS_Loads'!Z173","v":2.9701727986921205E-6},{"$f":"'3. CALCS_Loads'!AA173","v":0},{"$f":"'3. CALCS_Loads'!AB173","v":0},{"$f":"'3. CALCS_Loads'!AC173","v":0},2.9701727986921205E-6,{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AD173,'3. CALCS_Loads'!AE173)","v":6.3279190024921744E-3},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AH173,'3. CALCS_Loads'!AI173)","v":4.6937591924333321E-4},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!AJ173,'3. CALCS_Loads'!AK173)","v":"YES"}]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(I8<=1,IF(I9<=1,IF(I10<=1,IF(I11<=1,IF(I13<=1,IF(I14<=1,IF(I15<=1,\"COMPLIANT\",\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\"),\"NOT COMPLIANT\")","v":"COMPLIANT"}]
[]
[]
[]
[]
[]
["SUMMARY OF INPUTS"]
["Site Location",null,{"$f":"IF('1. ENTER DATA'!E14=\"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(D27:G27)","v":1}]
["Developed IC, ICD (%)",null,null,{"$f":"ICA_d","v":0},{"$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":"(D28*D27+IF(n_DA>1,E28*E27,0)+IF(n_DA>2,F28*F27,0)+IF(n_DA>3,G28*G27,0))/(100*H27)","v":0}]
["SCM 1",null,null,{"$f":"'1. ENTER DATA'!E26","v":"Retention Basin"},{"$f":"IF(n_DA=1,\"N/A\",'1. ENTER DATA'!F26)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",'1. ENTER DATA'!G26)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",'1. ENTER DATA'!H26)","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":"D32*D27/12*43560","v":9075},{"$f":"IF(n_DA=1,\"N/A\",E32*E27/12*43560)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",F32*F27/12*43560)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",G32*G27/12*43560)","v":"N/A"},{"$f":"SUM(D33:G33)","v":9075}]
["Drawdown Time, DDT (hrs)",null,null,{"$f":"IF('1. ENTER DATA'!E$31=\"Drawdown Time\", DDT_A1, \"N/A\")","v":60},{"$f":"IF(n_DA=1,\"N/A\",IF('1. ENTER DATA'!F$31=\"Drawdown Time\", DDT_B1, \"N/A\"))","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",IF('1. ENTER DATA'!G$31=\"Drawdown Time\", DDT_C1, \"N/A\"))","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",IF('1. ENTER DATA'!H$31=\"Drawdown Time\", DDT_D1, \"N/A\"))","v":"N/A"},"-"]
["- OR - Flowrate (gpm)",null,null,{"$f":"IF('1. ENTER DATA'!E$31=\"Flow Rate\", '1. ENTER DATA'!E33, \"N/A\")","v":"N/A"},{"$f":"IF(n_DA=1,\"N/A\",IF('1. ENTER DATA'!F$31=\"Flow Rate\", '1. ENTER DATA'!F33, \"N/A\"))","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",IF('1. ENTER DATA'!G$31=\"Flow Rate\", '1. ENTER DATA'!G33, \"N/A\"))","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",IF('1. ENTER DATA'!H$31=\"Flow Rate\", '1. ENTER DATA'!H33, \"N/A\"))","v":"N/A"},"-"]
["SCM 2",null,null,{"$f":"'1. ENTER DATA'!E45","v":"Infiltration Field"},{"$f":"IF(n_DA=1,\"N/A\",'1. ENTER DATA'!F45)","v":"N/A"},{"$f":"IF(n_DA<3,\"N/A\",'1. ENTER DATA'!G45)","v":"N/A"},{"$f":"IF(n_DA<4,\"N/A\",'1. ENTER DATA'!H45)","v":"N/A"},"-"]
[]
["Infiltration Rate (in/hr)",null,null,{"$f":"IF(D36<>\"Infiltration Field\",\"N/A\",'1. ENTER DATA'!E52)","v":0.2},{"$f":"IF(E36<>\"Infiltration Field\",\"N/A\",IF(n_DA=1,\"N/A\",'1. ENTER DATA'!F52))","v":"N/A"},{"$f":"IF(F36<>\"Infiltration Field\",\"N/A\",IF(n_DA<3,\"N/A\",'1. ENTER DATA'!G52))","v":"N/A"},{"$f":"IF(G36<>\"Infiltration Field\",\"N/A\",IF(n_DA<4,\"N/A\",'1. ENTER DATA'!H52))","v":"N/A"},"-"]
["Infiltration Field Area (Ac)",null,null,{"$f":"IF(D36<>\"Infiltration Field\",\"N/A\",'4. CALCS_Infiltration'!E20)","v":0.41666666666666669},{"$f":"IF(E36<>\"Infiltration Field\",\"N/A\",IF(n_DA=1,\"N/A\",'4. CALCS_Infiltration'!F20))","v":"N/A"},{"$f":"IF(F36<>\"Infiltration Field\",\"N/A\",IF(n_DA<3,\"N/A\",'4. CALCS_Infiltration'!G20))","v":"N/A"},{"$f":"IF(G36<>\"Infiltration Field\",\"N/A\",IF(n_DA<4,\"N/A\",'4. CALCS_Infiltration'!H20))","v":"N/A"},{"$f":"SUM(D39:G39)","v":0.41666666666666669}]
["Error with Input Values?",null,null,{"$f":"IF(OR(AND('1. ENTER DATA'!E49=\"Yes\",'1. ENTER DATA'!E50>'1. ENTER DATA'!E47),AND('1. ENTER DATA'!E54=\"Yes\",'1. ENTER DATA'!E55<'1. ENTER DATA'!E56)),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(OR(AND('1. ENTER DATA'!F49=\"Yes\",'1. ENTER DATA'!F50>'1. ENTER DATA'!F47),AND('1. ENTER DATA'!F54=\"Yes\",'1. ENTER DATA'!F55<'1. ENTER DATA'!F56)),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(OR(AND('1. ENTER DATA'!G49=\"Yes\",'1. ENTER DATA'!G50>'1. ENTER DATA'!G47),AND('1. ENTER DATA'!G54=\"Yes\",'1. ENTER DATA'!G55<'1. ENTER DATA'!G56)),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(OR(AND('1. ENTER DATA'!H49=\"Yes\",'1. ENTER DATA'!H50>'1. ENTER DATA'!H47),AND('1. ENTER DATA'!H54=\"Yes\",'1. ENTER DATA'!H55<'1. ENTER DATA'!H56)),\"YES\",\"NO\")","v":"NO"}]

{"sheet":"3. CALCS_Loads","index":2,"n_rows":196,"n_cols":37,"rows_kept":196,"cut":false,"hidden":false,"merged":[[34,8,34,11],[34,3,34,7],[162,36,164,36],[162,35,164,35],[163,17,163,20],[163,25,163,28],[162,32,163,32],[162,31,163,31],[61,0,63,0],[162,30,163,30],[162,29,163,29],[61,16,61,17],[61,18,61,19],[61,20,61,21],[163,21,163,24],[163,13,163,16],[163,9,163,12],[163,5,163,8],[163,1,163,4]]}
["CONSTANTS"]
[31.73,"R, annual rainfall, in/yr","(CM-09-04, Pg 51)"]
[79.33,"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.9: Runoff (From Table 3.2, CM-09-03)"]
["IC (%)","Rv","Sd","Runoff Events","Runoff (in)"]
[0,6.4000000000000001E-2,0.218,46,1.18]
[5,0.1,0.19800000000000001,48.4,1.94]
[10,0.13600000000000001,0.18,50.6,2.76]
[15,0.17199999999999999,0.16300000000000001,52.8,3.63]
[20,0.20799999999999999,0.14799999999999999,54.8,4.55]
[25,0.24299999999999999,0.13400000000000001,56.7,5.52]
[30,0.27900000000000003,0.122,58.5,6.54]
[35,0.315,0.11,60.2,7.59]
[40,0.35099999999999998,0.1,61.8,8.67]
[45,0.38700000000000001,9.0999999999999998E-2,63.2,9.7799999999999994]
[50,0.42299999999999999,8.2000000000000003E-2,64.599999999999994,10.91]
[55.000000000000007,0.45800000000000002,7.4999999999999997E-2,65.8,12.06]
[60,0.49399999999999999,6.8000000000000005E-2,66.900000000000006,13.23]
[65,0.53,6.2E-2,68,14.42]
[70,0.56599999999999995,5.6000000000000001E-2,69,15.61]
[75,0.60199999999999998,5.0999999999999997E-2,69.900000000000006,16.82]
[80,0.63700000000000001,4.5999999999999999E-2,70.7,18.03]
[85,0.67300000000000004,4.2000000000000003E-2,71.5,19.239999999999998]
[90,0.70899999999999996,3.7999999999999999E-2,72.2,20.46]
[95,0.745,3.4000000000000002E-2,72.8,21.69]
[100,0.78100000000000003,3.1E-2,73.400000000000006,22.91]
[]
["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*ICA_b/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":38.9},{"$f":"38.9+66.6*ICB_d/100","v":38.9},{"$f":"38.9+66.6*ICC_d/100","v":38.9},{"$f":"38.9+66.6*ICD_d/100","v":38.9},"*Function of IC"]
["E. coli","CFU/100mL","CF_2",8372,{"$f":"IF(ICA_b=0,$D38,$I38)","v":8372},{"$f":"IF(ICB_b=0,$D38,$I38)","v":8372},{"$f":"IF(ICC_b=0,$D38,$I38)","v":8372},{"$f":"IF(ICD_b=0,$D38,$I38)","v":8372},24963,24963,24963,24963]
["Pb","mg/L","CF_1",{"$f":"(4.283*EXP(2.424*ICA_b/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":4.2830000000000003E-3},{"$f":"(4.283*EXP(2.424*ICB_d/100))/1000","v":4.2830000000000003E-3},{"$f":"(4.283*EXP(2.424*ICC_d/100))/1000","v":4.2830000000000003E-3},{"$f":"(4.283*EXP(2.424*ICD_d/100))/1000","v":4.2830000000000003E-3},"*Function of IC"]
["TN","mg/L","CF_1",1.19,{"$f":"IF(ICA_b=0,$D40,$I40)","v":1.19},{"$f":"IF(ICB_b=0,$D40,$I40)","v":1.19},{"$f":"IF(ICC_b=0,$D40,$I40)","v":1.19},{"$f":"IF(ICD_b=0,$D40,$I40)","v":1.19},2.2200000000000002,2.2200000000000002,2.2200000000000002,2.2200000000000002]
["TOC","mg/L","CF_1",13.03,{"$f":"IF(ICA_b=0,$D41,$I41)","v":13.03},{"$f":"IF(ICB_b=0,$D41,$I41)","v":13.03},{"$f":"IF(ICC_b=0,$D41,$I41)","v":13.03},{"$f":"IF(ICD_b=0,$D41,$I41)","v":13.03},13.03,13.03,13.03,13.03]
["TP","mg/L","CF_1",0.124,{"$f":"IF(ICA_b=0,$D42,$I42)","v":0.124},{"$f":"IF(ICB_b=0,$D42,$I42)","v":0.124},{"$f":"IF(ICC_b=0,$D42,$I42)","v":0.124},{"$f":"IF(ICD_b=0,$D42,$I42)","v":0.124},0.39600000000000002,0.39600000000000002,0.39600000000000002,0.39600000000000002]
["TSS","mg/L","CF_1",166,{"$f":"$D43","v":166},{"$f":"$D43","v":166},{"$f":"$D43","v":166},{"$f":"$D43","v":166},166,166,166,166]
["Zn","mg/L","CF_1",{"$f":"(23.565*EXP(2.179*ICA_b/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":2.3565000000000003E-2},{"$f":"(23.565*EXP(2.179*ICB_d/100))/1000","v":2.3565000000000003E-2},{"$f":"(23.565*EXP(2.179*ICC_d/100))/1000","v":2.3565000000000003E-2},{"$f":"(23.565*EXP(2.179*ICD_d/100))/1000","v":2.3565000000000003E-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]
["TOC","mg/L",7.33,11.45,11.45,7.33,7.77]
["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'!E63","v":"Retention Basin"},{"$f":"C62","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!F63","v":"Retention Basin"},{"$f":"E62","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!G63","v":"Retention Basin"},{"$f":"G62","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!H63","v":"Retention Basin"},{"$f":"I62","v":"Retention Basin"},"Sed/Fil Equivalent",{"$f":"K62","v":"Sed/Fil Equivalent"},{"$f":"K62","v":"Sed/Fil Equivalent"},{"$f":"K62","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":"C93","v":0.5},{"$f":"D93","v":0.5},0.5,0.5]
[null,"Method","Yes (Off-Line)","No (On-Line)",{"$f":"C64","v":"Yes (Off-Line)"},{"$f":"D64","v":"No (On-Line)"},{"$f":"C64","v":"Yes (Off-Line)"},{"$f":"D64","v":"No (On-Line)"},{"$f":"C64","v":"Yes (Off-Line)"},{"$f":"D64","v":"No (On-Line)"},{"$f":"$E$64","v":"Yes (Off-Line)"},{"$f":"$E$64","v":"Yes (Off-Line)"},{"$f":"$E$64","v":"Yes (Off-Line)"},{"$f":"$E$64","v":"Yes (Off-Line)"}]
["COD","mg/L",{"$f":"IF(C$63>0.0053,EXP(4.493-0.5104*C$63),EXP(5.6158-212.362*C$63))","v":24.953148334792502},{"$f":"IF(D$63>0.0053,EXP(4.9161-0.5447*D$63),EXP(6.1257-228.771*D$63))","v":34.965085274290395},{"$f":"IF(E$63>0.0053,EXP(4.493-0.5104*E$63),EXP(5.6158-212.362*E$63))","v":24.953148334792502},{"$f":"IF(F$63>0.0053,EXP(4.9161-0.5447*F$63),EXP(6.1257-228.771*F$63))","v":34.965085274290395},{"$f":"IF(G$63>0.0053,EXP(4.493-0.5104*G$63),EXP(5.6158-212.362*G$63))","v":24.953148334792502},{"$f":"IF(H$63>0.0053,EXP(4.9161-0.5447*H$63),EXP(6.1257-228.771*H$63))","v":34.965085274290395},{"$f":"IF(I$63>0.0053,EXP(4.493-0.5104*I$63),EXP(5.6158-212.362*I$63))","v":24.953148334792502},{"$f":"IF(J$63>0.0053,EXP(4.9161-0.5447*J$63),EXP(6.1257-228.771*J$63))","v":34.965085274290395},{"$f":"IF(K$63>0.0053,EXP(4.493-0.5104*K$63),EXP(5.6158-212.362*K$63))","v":69.255322408603291},{"$f":"IF(L$63>0.0053,EXP(4.493-0.5104*L$63),EXP(5.6158-212.362*L$63))","v":69.255322408603291},{"$f":"IF(M$63>0.0053,EXP(4.493-0.5104*M$63),EXP(5.6158-212.362*M$63))","v":69.255322408603291},{"$f":"IF(N$63>0.0053,EXP(4.493-0.5104*N$63),EXP(5.6158-212.362*N$63))","v":69.255322408603291}]
["E. coli","CFU/100mL",{"$f":"IF(C$63>0.0091,EXP(10.1772-0.4647*C$63),EXP(10.4384-29.1718*C$63))","v":8229.24868738228},{"$f":"IF(D$63>0.0091,EXP(10.7915-0.6241*D$63),EXP(11.4771-75.97*D$63))","v":10211.297659526826},{"$f":"IF(E$63>0.0091,EXP(10.1772-0.4647*E$63),EXP(10.4384-29.1718*E$63))","v":8229.24868738228},{"$f":"IF(F$63>0.0091,EXP(10.7915-0.6241*F$63),EXP(11.4771-75.97*F$63))","v":10211.297659526826},{"$f":"IF(G$63>0.0091,EXP(10.1772-0.4647*G$63),EXP(10.4384-29.1718*G$63))","v":8229.24868738228},{"$f":"IF(H$63>0.0091,EXP(10.7915-0.6241*H$63),EXP(11.4771-75.97*H$63))","v":10211.297659526826},{"$f":"IF(I$63>0.0091,EXP(10.1772-0.4647*I$63),EXP(10.4384-29.1718*I$63))","v":8229.24868738228},{"$f":"IF(J$63>0.0091,EXP(10.7915-0.6241*J$63),EXP(11.4771-75.97*J$63))","v":10211.297659526826},{"$f":"IF(K$63>0.0091,EXP(10.1772-0.4647*K$63),EXP(10.4384-29.1718*K$63))","v":20844.595812804615},{"$f":"IF(L$63>0.0091,EXP(10.1772-0.4647*L$63),EXP(10.4384-29.1718*L$63))","v":20844.595812804615},{"$f":"IF(M$63>0.0091,EXP(10.1772-0.4647*M$63),EXP(10.4384-29.1718*M$63))","v":20844.595812804615},{"$f":"IF(N$63>0.0091,EXP(10.1772-0.4647*N$63),EXP(10.4384-29.1718*N$63))","v":20844.595812804615}]
["Pb","mg/L",{"$f":"IF(C$63>0.014,EXP(2.8821-0.4893*C$63),EXP(3.6322-54.0678*C$63))/1000","v":5.2532661133623381E-3},{"$f":"IF(D$63>0.014,EXP(3.5221-0.5291*D$63),EXP(4.2534-52.7676*D$63))/1000","v":9.0191491467805744E-3},{"$f":"IF(E$63>0.014,EXP(2.8821-0.4893*E$63),EXP(3.6322-54.0678*E$63))/1000","v":5.2532661133623381E-3},{"$f":"IF(F$63>0.014,EXP(3.5221-0.5291*F$63),EXP(4.2534-52.7676*F$63))/1000","v":9.0191491467805744E-3},{"$f":"IF(G$63>0.014,EXP(2.8821-0.4893*G$63),EXP(3.6322-54.0678*G$63))/1000","v":5.2532661133623381E-3},{"$f":"IF(H$63>0.014,EXP(3.5221-0.5291*H$63),EXP(4.2534-52.7676*H$63))/1000","v":9.0191491467805744E-3},{"$f":"IF(I$63>0.014,EXP(2.8821-0.4893*I$63),EXP(3.6322-54.0678*I$63))/1000","v":5.2532661133623381E-3},{"$f":"IF(J$63>0.014,EXP(3.5221-0.5291*J$63),EXP(4.2534-52.7676*J$63))/1000","v":9.0191491467805744E-3},{"$f":"IF(K$63>0.014,EXP(2.8821-0.4893*K$63),EXP(3.6322-54.0678*K$63))/1000","v":1.3977515460260432E-2},{"$f":"IF(L$63>0.014,EXP(2.8821-0.4893*L$63),EXP(3.6322-54.0678*L$63))/1000","v":1.3977515460260432E-2},{"$f":"IF(M$63>0.014,EXP(2.8821-0.4893*M$63),EXP(3.6322-54.0678*M$63))/1000","v":1.3977515460260432E-2},{"$f":"IF(N$63>0.014,EXP(2.8821-0.4893*N$63),EXP(3.6322-54.0678*N$63))/1000","v":1.3977515460260432E-2}]
["TN","mg/L",{"$f":"IF(C$63>0.0145,EXP(0.9574-0.267*C$63),EXP(1.8156-59.4508*C$63))","v":1.3362938519585843},{"$f":"IF(D$63>0.0145,EXP(1.3219-0.2364*D$63),EXP(2.2217-62.2914*D$63))","v":2.0769490208808548},{"$f":"IF(E$63>0.0145,EXP(0.9574-0.267*E$63),EXP(1.8156-59.4508*E$63))","v":1.3362938519585843},{"$f":"IF(F$63>0.0145,EXP(1.3219-0.2364*F$63),EXP(2.2217-62.2914*F$63))","v":2.0769490208808548},{"$f":"IF(G$63>0.0145,EXP(0.9574-0.267*G$63),EXP(1.8156-59.4508*G$63))","v":1.3362938519585843},{"$f":"IF(H$63>0.0145,EXP(1.3219-0.2364*H$63),EXP(2.2217-62.2914*H$63))","v":2.0769490208808548},{"$f":"IF(I$63>0.0145,EXP(0.9574-0.267*I$63),EXP(1.8156-59.4508*I$63))","v":1.3362938519585843},{"$f":"IF(J$63>0.0145,EXP(1.3219-0.2364*J$63),EXP(2.2217-62.2914*J$63))","v":2.0769490208808548},{"$f":"IF(K$63>0.0145,EXP(0.9574-0.267*K$63),EXP(1.8156-59.4508*K$63))","v":2.2793720765192464},{"$f":"IF(L$63>0.0145,EXP(0.9574-0.267*L$63),EXP(1.8156-59.4508*L$63))","v":2.2793720765192464},{"$f":"IF(M$63>0.0145,EXP(0.9574-0.267*M$63),EXP(1.8156-59.4508*M$63))","v":2.2793720765192464},{"$f":"IF(N$63>0.0145,EXP(0.9574-0.267*N$63),EXP(1.8156-59.4508*N$63))","v":2.2793720765192464}]
["TOC","mg/L",{"$f":"IF(C$63>0.00608,EXP(2.724-0.1886*C$63),EXP(2.724-0.1886*C$63))","v":9.5114848498470099},{"$f":"IF(D$63>0.00608,EXP(3.1124-0.2821*D$63),EXP(3.1124-0.2821*D$63))","v":11.102274530675251},{"$f":"IF(E$63>0.00608,EXP(2.724-0.1886*E$63),EXP(2.724-0.1886*E$63))","v":9.5114848498470099},{"$f":"IF(F$63>0.00608,EXP(3.1124-0.2821*F$63),EXP(3.1124-0.2821*F$63))","v":11.102274530675251},{"$f":"IF(G$63>0.00608,EXP(2.724-0.1886*G$63),EXP(2.724-0.1886*G$63))","v":9.5114848498470099},{"$f":"IF(H$63>0.00608,EXP(3.1124-0.2821*H$63),EXP(3.1124-0.2821*H$63))","v":11.102274530675251},{"$f":"IF(I$63>0.00608,EXP(2.724-0.1886*I$63),EXP(2.724-0.1886*I$63))","v":9.5114848498470099},{"$f":"IF(J$63>0.00608,EXP(3.1124-0.2821*J$63),EXP(3.1124-0.2821*J$63))","v":11.102274530675251},{"$f":"IF(K$63>0.00608,EXP(2.724-0.1886*K$63),EXP(2.724-0.1886*K$63))","v":13.869608395416487},{"$f":"IF(L$63>0.00608,EXP(2.724-0.1886*L$63),EXP(2.724-0.1886*L$63))","v":13.869608395416487},{"$f":"IF(M$63>0.00608,EXP(2.724-0.1886*M$63),EXP(2.724-0.1886*M$63))","v":13.869608395416487},{"$f":"IF(N$63>0.00608,EXP(2.724-0.1886*N$63),EXP(2.724-0.1886*N$63))","v":13.869608395416487}]
["TP","mg/L",{"$f":"IF(C$63>0.00426,EXP(-0.6134-0.4693*C$63),EXP(0.0336-152.341*C$63))","v":0.16752042413770912},{"$f":"IF(D$63>0.00426,EXP(-0.2231-0.4003*D$63),EXP(0.5338-178.08*D$63))","v":0.29409571600066703},{"$f":"IF(E$63>0.00426,EXP(-0.6134-0.4693*E$63),EXP(0.0336-152.341*E$63))","v":0.16752042413770912},{"$f":"IF(F$63>0.00426,EXP(-0.2231-0.4003*F$63),EXP(0.5338-178.08*F$63))","v":0.29409571600066703},{"$f":"IF(G$63>0.00426,EXP(-0.6134-0.4693*G$63),EXP(0.0336-152.341*G$63))","v":0.16752042413770912},{"$f":"IF(H$63>0.00426,EXP(-0.2231-0.4003*H$63),EXP(0.5338-178.08*H$63))","v":0.29409571600066703},{"$f":"IF(I$63>0.00426,EXP(-0.6134-0.4693*I$63),EXP(0.0336-152.341*I$63))","v":0.16752042413770912},{"$f":"IF(J$63>0.00426,EXP(-0.2231-0.4003*J$63),EXP(0.5338-178.08*J$63))","v":0.29409571600066703},{"$f":"IF(K$63>0.00426,EXP(-0.6134-0.4693*K$63),EXP(0.0336-152.341*K$63))","v":0.42824920421712837},{"$f":"IF(L$63>0.00426,EXP(-0.6134-0.4693*L$63),EXP(0.0336-152.341*L$63))","v":0.42824920421712837},{"$f":"IF(M$63>0.00426,EXP(-0.6134-0.4693*M$63),EXP(0.0336-152.341*M$63))","v":0.42824920421712837},{"$f":"IF(N$63>0.00426,EXP(-0.6134-0.4693*N$63),EXP(0.0336-152.341*N$63))","v":0.42824920421712837}]
["TSS","mg/L",{"$f":"IF(C$63>0.00399,EXP(5.2895-0.9341*C$63),EXP(6.3181-258.741*C$63))","v":19.187326826927933},{"$f":"IF(D$63>0.00399,EXP(5.8622-0.7645*D$63),EXP(6.8265-242.449*D$63))","v":51.984728876581904},{"$f":"IF(E$63>0.00399,EXP(5.2895-0.9341*E$63),EXP(6.3181-258.741*E$63))","v":19.187326826927933},{"$f":"IF(F$63>0.00399,EXP(5.8622-0.7645*F$63),EXP(6.8265-242.449*F$63))","v":51.984728876581904},{"$f":"IF(G$63>0.00399,EXP(5.2895-0.9341*G$63),EXP(6.3181-258.741*G$63))","v":19.187326826927933},{"$f":"IF(H$63>0.00399,EXP(5.8622-0.7645*H$63),EXP(6.8265-242.449*H$63))","v":51.984728876581904},{"$f":"IF(I$63>0.00399,EXP(5.2895-0.9341*I$63),EXP(6.3181-258.741*I$63))","v":19.187326826927933},{"$f":"IF(J$63>0.00399,EXP(5.8622-0.7645*J$63),EXP(6.8265-242.449*J$63))","v":51.984728876581904},{"$f":"IF(K$63>0.00399,EXP(5.2895-0.9341*K$63),EXP(6.3181-258.741*K$63))","v":124.26917760649039},{"$f":"IF(L$63>0.00399,EXP(5.2895-0.9341*L$63),EXP(6.3181-258.741*L$63))","v":124.26917760649039},{"$f":"IF(M$63>0.00399,EXP(5.2895-0.9341*M$63),EXP(6.3181-258.741*M$63))","v":124.26917760649039},{"$f":"IF(N$63>0.00399,EXP(5.2895-0.9341*N$63),EXP(6.3181-258.741*N$63))","v":124.26917760649039}]
["Zn","mg/L",{"$f":"IF(C$63>0.0147,EXP(4.61-0.4424*C$63),EXP(5.5439-63.9761*C$63))/1000","v":3.3248179043727767E-2},{"$f":"IF(D$63>0.0147,EXP(5.1995-0.531*D$63),EXP(6.1534-65.4251*D$63))/1000","v":4.8038366801708178E-2},{"$f":"IF(E$63>0.0147,EXP(4.61-0.4424*E$63),EXP(5.5439-63.9761*E$63))/1000","v":3.3248179043727767E-2},{"$f":"IF(F$63>0.0147,EXP(5.1995-0.531*F$63),EXP(6.1534-65.4251*F$63))/1000","v":4.8038366801708178E-2},{"$f":"IF(G$63>0.0147,EXP(4.61-0.4424*G$63),EXP(5.5439-63.9761*G$63))/1000","v":3.3248179043727767E-2},{"$f":"IF(H$63>0.0147,EXP(5.1995-0.531*H$63),EXP(6.1534-65.4251*H$63))/1000","v":4.8038366801708178E-2},{"$f":"IF(I$63>0.0147,EXP(4.61-0.4424*I$63),EXP(5.5439-63.9761*I$63))/1000","v":3.3248179043727767E-2},{"$f":"IF(J$63>0.0147,EXP(5.1995-0.531*J$63),EXP(6.1534-65.4251*J$63))/1000","v":4.8038366801708178E-2},{"$f":"IF(K$63>0.0147,EXP(4.61-0.4424*K$63),EXP(5.5439-63.9761*K$63))/1000","v":8.0543708515584678E-2},{"$f":"IF(L$63>0.0147,EXP(4.61-0.4424*L$63),EXP(5.5439-63.9761*L$63))/1000","v":8.0543708515584678E-2},{"$f":"IF(M$63>0.0147,EXP(4.61-0.4424*M$63),EXP(5.5439-63.9761*M$63))/1000","v":8.0543708515584678E-2},{"$f":"IF(N$63>0.0147,EXP(4.61-0.4424*N$63),EXP(5.5439-63.9761*N$63))/1000","v":8.0543708515584678E-2}]
[null,null,"*CM-14-10, \"Offline\" uses 80th pct, \"online\" uses 90th pct regressions"]
[]
[]
["CALCULATE: RUNOFF"]
[null,null,"Drainage Area 1","Drainage Area 2","Drainage Area 3","Drainage Area 4"]
[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*C80/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*D80/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*E80/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*F80/100+0.0644","v":6.4399999999999999E-2}]
[null,"Sd (Dep Storage)",{"$f":"0.2181*EXP(-1.9456*C80/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*D80/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*E80/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*F80/100)","v":0.21809999999999999}]
[null,"Runoff (in/yr)",{"$f":"C$78*$A$2*C81*EXP(-$A$3/$A$2*C82)","v":1.1845187709210347},{"$f":"D$78*$A$2*D81*EXP(-$A$3/$A$2*D82)","v":0},{"$f":"E$78*$A$2*E81*EXP(-$A$3/$A$2*E82)","v":0},{"$f":"F$78*$A$2*F81*EXP(-$A$3/$A$2*F82)","v":0}]
[null,"Runoff (Ac-in/yr)",{"$f":"C79*C83","v":1.1845187709210347},{"$f":"D79*D83","v":0},0,0]
["Developed","IC %",{"$f":"ICA_d","v":0},{"$f":"ICB_d","v":0},{"$f":"ICC_d","v":0},{"$f":"ICD_d","v":0}]
[null,"Rv (Runoff Coeff)",{"$f":"0.7162*C85/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*D85/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*E85/100+0.0644","v":6.4399999999999999E-2},{"$f":"0.7162*F85/100+0.0644","v":6.4399999999999999E-2}]
[null,"Sd (Dep Storage)",{"$f":"0.2181*EXP(-1.9456*C85/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*D85/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*E85/100)","v":0.21809999999999999},{"$f":"0.2181*EXP(-1.9456*F85/100)","v":0.21809999999999999}]
[null,"Runoff (in/yr)",{"$f":"C$78*$A$2*C86*EXP(-$A$3/$A$2*C87)","v":1.1845187709210347},{"$f":"D$78*$A$2*D86*EXP(-$A$3/$A$2*D87)","v":0},{"$f":"E$78*$A$2*E86*EXP(-$A$3/$A$2*E87)","v":0},{"$f":"F$78*$A$2*F86*EXP(-$A$3/$A$2*F87)","v":0}]
[null,"Runoff (Ac-in/yr)",{"$f":"C79*C88","v":1.1845187709210347},{"$f":"D79*D88","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.5},{"$f":"MAX(0.5,0.5+(ICB_d-20)/100)","v":0.5},{"$f":"MAX(0.5,0.5+(ICC_d-20)/100)","v":0.5},{"$f":"MAX(0.5,0.5+(ICD_d-20)/100)","v":0.5}]
[]
[]
["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'!E63","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!F63","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!G63","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!H63","v":"Retention Basin"}]
["COD","mg/L",{"$f":"IF(C$98=\"None\",I37,MIN(IF(C$98=\"Alternative\",'1. ENTER DATA'!E64,LOOKUP(C$98,$C$48:$G$48,$C49:$G49)),I37))","v":38.9},{"$f":"IF(D$98=\"None\",J37,MIN(IF(D$98=\"Alternative\",'1. ENTER DATA'!F64,LOOKUP(D$98,$C$48:$G$48,$C49:$G49)),J37))","v":38.9},{"$f":"IF(E$98=\"None\",K37,MIN(IF(E$98=\"Alternative\",'1. ENTER DATA'!G64,LOOKUP(E$98,$C$48:$G$48,$C49:$G49)),K37))","v":38.9},{"$f":"IF(F$98=\"None\",L37,MIN(IF(F$98=\"Alternative\",'1. ENTER DATA'!H64,LOOKUP(F$98,$C$48:$G$48,$C49:$G49)),L37))","v":38.9}]
["E. coli","CFU/100mL",{"$f":"IF(C$98=\"None\",I38,MIN(IF(C$98=\"Alternative\",'1. ENTER DATA'!E65,LOOKUP(C$98,$C$48:$G$48,$C50:$G50)),I38))","v":11065},{"$f":"IF(D$98=\"None\",J38,MIN(IF(D$98=\"Alternative\",'1. ENTER DATA'!F65,LOOKUP(D$98,$C$48:$G$48,$C50:$G50)),J38))","v":11065},{"$f":"IF(E$98=\"None\",K38,MIN(IF(E$98=\"Alternative\",'1. ENTER DATA'!G65,LOOKUP(E$98,$C$48:$G$48,$C50:$G50)),K38))","v":11065},{"$f":"IF(F$98=\"None\",L38,MIN(IF(F$98=\"Alternative\",'1. ENTER DATA'!H65,LOOKUP(F$98,$C$48:$G$48,$C50:$G50)),L38))","v":11065}]
["Pb","mg/L",{"$f":"IF(C$98=\"None\",I39,MIN(IF(C$98=\"Alternative\",'1. ENTER DATA'!E66,LOOKUP(C$98,$C$48:$G$48,$C51:$G51)),I39))","v":4.2830000000000003E-3},{"$f":"IF(D$98=\"None\",J39,MIN(IF(D$98=\"Alternative\",'1. ENTER DATA'!F66,LOOKUP(D$98,$C$48:$G$48,$C51:$G51)),J39))","v":4.2830000000000003E-3},{"$f":"IF(E$98=\"None\",K39,MIN(IF(E$98=\"Alternative\",'1. ENTER DATA'!G66,LOOKUP(E$98,$C$48:$G$48,$C51:$G51)),K39))","v":4.2830000000000003E-3},{"$f":"IF(F$98=\"None\",L39,MIN(IF(F$98=\"Alternative\",'1. ENTER DATA'!H66,LOOKUP(F$98,$C$48:$G$48,$C51:$G51)),L39))","v":4.2830000000000003E-3}]
["TN","mg/L",{"$f":"IF(C$98=\"None\",I40,MIN(IF(C$98=\"Alternative\",'1. ENTER DATA'!E67,LOOKUP(C$98,$C$48:$G$48,$C52:$G52)),I40))","v":1.42},{"$f":"IF(D$98=\"None\",J40,MIN(IF(D$98=\"Alternative\",'1. ENTER DATA'!F67,LOOKUP(D$98,$C$48:$G$48,$C52:$G52)),J40))","v":1.42},{"$f":"IF(E$98=\"None\",K40,MIN(IF(E$98=\"Alternative\",'1. ENTER DATA'!G67,LOOKUP(E$98,$C$48:$G$48,$C52:$G52)),K40))","v":1.42},{"$f":"IF(F$98=\"None\",L40,MIN(IF(F$98=\"Alternative\",'1. ENTER DATA'!H67,LOOKUP(F$98,$C$48:$G$48,$C52:$G52)),L40))","v":1.42}]
["TOC","mg/L",{"$f":"IF(C$98=\"None\",I41,MIN(IF(C$98=\"Alternative\",'1. ENTER DATA'!E68,LOOKUP(C$98,$C$48:$G$48,$C53:$G53)),I41))","v":11.45},{"$f":"IF(D$98=\"None\",J41,MIN(IF(D$98=\"Alternative\",'1. ENTER DATA'!F68,LOOKUP(D$98,$C$48:$G$48,$C53:$G53)),J41))","v":11.45},{"$f":"IF(E$98=\"None\",K41,MIN(IF(E$98=\"Alternative\",'1. ENTER DATA'!G68,LOOKUP(E$98,$C$48:$G$48,$C53:$G53)),K41))","v":11.45},{"$f":"IF(F$98=\"None\",L41,MIN(IF(F$98=\"Alternative\",'1. ENTER DATA'!H68,LOOKUP(F$98,$C$48:$G$48,$C53:$G53)),L41))","v":11.45}]
["TP","mg/L",{"$f":"IF(C$98=\"None\",I42,MIN(IF(C$98=\"Alternative\",'1. ENTER DATA'!E69,LOOKUP(C$98,$C$48:$G$48,$C54:$G54)),I42))","v":0.224},{"$f":"IF(D$98=\"None\",J42,MIN(IF(D$98=\"Alternative\",'1. ENTER DATA'!F69,LOOKUP(D$98,$C$48:$G$48,$C54:$G54)),J42))","v":0.224},{"$f":"IF(E$98=\"None\",K42,MIN(IF(E$98=\"Alternative\",'1. ENTER DATA'!G69,LOOKUP(E$98,$C$48:$G$48,$C54:$G54)),K42))","v":0.224},{"$f":"IF(F$98=\"None\",L42,MIN(IF(F$98=\"Alternative\",'1. ENTER DATA'!H69,LOOKUP(F$98,$C$48:$G$48,$C54:$G54)),L42))","v":0.224}]
["TSS","mg/L",{"$f":"IF(C$98=\"None\",I43,MIN(IF(C$98=\"Alternative\",'1. ENTER DATA'!E70,LOOKUP(C$98,$C$48:$G$48,$C55:$G55)),I43))","v":133.80000000000001},{"$f":"IF(D$98=\"None\",J43,MIN(IF(D$98=\"Alternative\",'1. ENTER DATA'!F70,LOOKUP(D$98,$C$48:$G$48,$C55:$G55)),J43))","v":133.80000000000001},{"$f":"IF(E$98=\"None\",K43,MIN(IF(E$98=\"Alternative\",'1. ENTER DATA'!G70,LOOKUP(E$98,$C$48:$G$48,$C55:$G55)),K43))","v":133.80000000000001},{"$f":"IF(F$98=\"None\",L43,MIN(IF(F$98=\"Alternative\",'1. ENTER DATA'!H70,LOOKUP(F$98,$C$48:$G$48,$C55:$G55)),L43))","v":133.80000000000001}]
["Zn","mg/L",{"$f":"IF(C$98=\"None\",I44,MIN(IF(C$98=\"Alternative\",'1. ENTER DATA'!E71,LOOKUP(C$98,$C$48:$G$48,$C56:$G56)),I44))","v":2.3565000000000003E-2},{"$f":"IF(D$98=\"None\",J44,MIN(IF(D$98=\"Alternative\",'1. ENTER DATA'!F71,LOOKUP(D$98,$C$48:$G$48,$C56:$G56)),J44))","v":2.3565000000000003E-2},{"$f":"IF(E$98=\"None\",K44,MIN(IF(E$98=\"Alternative\",'1. ENTER DATA'!G71,LOOKUP(E$98,$C$48:$G$48,$C56:$G56)),K44))","v":2.3565000000000003E-2},{"$f":"IF(F$98=\"None\",L44,MIN(IF(F$98=\"Alternative\",'1. ENTER DATA'!H71,LOOKUP(F$98,$C$48:$G$48,$C56:$G56)),L44))","v":2.3565000000000003E-2}]
[null,null,"SCM A.2","SCM B.2","SCM C.2","SCM D.2"]
["Pollutant","Units",{"$f":"'1. ENTER DATA'!E73","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!F73","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!G73","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!H73","v":"Infiltration Field"}]
["COD","mg/L",{"$f":"MIN(IF(C$108=\"Alternative\",'1. ENTER DATA'!E74,IF(OR(C$108=\"Infiltration Field\",C$108=\"None\",C$108=\"Beneficial Reuse\"),C99,LOOKUP(C$108,$C$48:$G$48,$C49:$G49))),C99)","v":38.9},{"$f":"MIN(IF(D$108=\"Alternative\",'1. ENTER DATA'!F74,IF(OR(D$108=\"Infiltration Field\",D$108=\"None\",D$108=\"Beneficial Reuse\"),D99,LOOKUP(D$108,$C$48:$G$48,$C49:$G49))),D99)","v":38.9},{"$f":"MIN(IF(E$108=\"Alternative\",'1. ENTER DATA'!G74,IF(OR(E$108=\"Infiltration Field\",E$108=\"None\",E$108=\"Beneficial Reuse\"),E99,LOOKUP(E$108,$C$48:$G$48,$C49:$G49))),E99)","v":38.9},{"$f":"MIN(IF(F$108=\"Alternative\",'1. ENTER DATA'!H74,IF(OR(F$108=\"Infiltration Field\",F$108=\"None\",F$108=\"Beneficial Reuse\"),F99,LOOKUP(F$108,$C$48:$G$48,$C49:$G49))),F99)","v":38.9}]
["E. coli","CFU/100mL",{"$f":"MIN(IF(C$108=\"Alternative\",'1. ENTER DATA'!E75,IF(OR(C$108=\"Infiltration Field\",C$108=\"None\",C$108=\"Beneficial Reuse\"),C100,LOOKUP(C$108,$C$48:$G$48,$C50:$G50))),C100)","v":11065},{"$f":"MIN(IF(D$108=\"Alternative\",'1. ENTER DATA'!F75,IF(OR(D$108=\"Infiltration Field\",D$108=\"None\",D$108=\"Beneficial Reuse\"),D100,LOOKUP(D$108,$C$48:$G$48,$C50:$G50))),D100)","v":11065},{"$f":"MIN(IF(E$108=\"Alternative\",'1. ENTER DATA'!G75,IF(OR(E$108=\"Infiltration Field\",E$108=\"None\",E$108=\"Beneficial Reuse\"),E100,LOOKUP(E$108,$C$48:$G$48,$C50:$G50))),E100)","v":11065},{"$f":"MIN(IF(F$108=\"Alternative\",'1. ENTER DATA'!H75,IF(OR(F$108=\"Infiltration Field\",F$108=\"None\",F$108=\"Beneficial Reuse\"),F100,LOOKUP(F$108,$C$48:$G$48,$C50:$G50))),F100)","v":11065}]
["Pb","mg/L",{"$f":"MIN(IF(C$108=\"Alternative\",'1. ENTER DATA'!E76,IF(OR(C$108=\"Infiltration Field\",C$108=\"None\",C$108=\"Beneficial Reuse\"),C101,LOOKUP(C$108,$C$48:$G$48,$C51:$G51))),C101)","v":4.2830000000000003E-3},{"$f":"MIN(IF(D$108=\"Alternative\",'1. ENTER DATA'!F76,IF(OR(D$108=\"Infiltration Field\",D$108=\"None\",D$108=\"Beneficial Reuse\"),D101,LOOKUP(D$108,$C$48:$G$48,$C51:$G51))),D101)","v":4.2830000000000003E-3},{"$f":"MIN(IF(E$108=\"Alternative\",'1. ENTER DATA'!G76,IF(OR(E$108=\"Infiltration Field\",E$108=\"None\",E$108=\"Beneficial Reuse\"),E101,LOOKUP(E$108,$C$48:$G$48,$C51:$G51))),E101)","v":4.2830000000000003E-3},{"$f":"MIN(IF(F$108=\"Alternative\",'1. ENTER DATA'!H76,IF(OR(F$108=\"Infiltration Field\",F$108=\"None\",F$108=\"Beneficial Reuse\"),F101,LOOKUP(F$108,$C$48:$G$48,$C51:$G51))),F101)","v":4.2830000000000003E-3}]
["TN","mg/L",{"$f":"MIN(IF(C$108=\"Alternative\",'1. ENTER DATA'!E77,IF(OR(C$108=\"Infiltration Field\",C$108=\"None\",C$108=\"Beneficial Reuse\"),C102,LOOKUP(C$108,$C$48:$G$48,$C52:$G52))),C102)","v":1.42},{"$f":"MIN(IF(D$108=\"Alternative\",'1. ENTER DATA'!F77,IF(OR(D$108=\"Infiltration Field\",D$108=\"None\",D$108=\"Beneficial Reuse\"),D102,LOOKUP(D$108,$C$48:$G$48,$C52:$G52))),D102)","v":1.42},{"$f":"MIN(IF(E$108=\"Alternative\",'1. ENTER DATA'!G77,IF(OR(E$108=\"Infiltration Field\",E$108=\"None\",E$108=\"Beneficial Reuse\"),E102,LOOKUP(E$108,$C$48:$G$48,$C52:$G52))),E102)","v":1.42},{"$f":"MIN(IF(F$108=\"Alternative\",'1. ENTER DATA'!H77,IF(OR(F$108=\"Infiltration Field\",F$108=\"None\",F$108=\"Beneficial Reuse\"),F102,LOOKUP(F$108,$C$48:$G$48,$C52:$G52))),F102)","v":1.42}]
["TOC","mg/L",{"$f":"MIN(IF(C$108=\"Alternative\",'1. ENTER DATA'!E78,IF(OR(C$108=\"Infiltration Field\",C$108=\"None\",C$108=\"Beneficial Reuse\"),C103,LOOKUP(C$108,$C$48:$G$48,$C53:$G53))),C103)","v":11.45},{"$f":"MIN(IF(D$108=\"Alternative\",'1. ENTER DATA'!F78,IF(OR(D$108=\"Infiltration Field\",D$108=\"None\",D$108=\"Beneficial Reuse\"),D103,LOOKUP(D$108,$C$48:$G$48,$C53:$G53))),D103)","v":11.45},{"$f":"MIN(IF(E$108=\"Alternative\",'1. ENTER DATA'!G78,IF(OR(E$108=\"Infiltration Field\",E$108=\"None\",E$108=\"Beneficial Reuse\"),E103,LOOKUP(E$108,$C$48:$G$48,$C53:$G53))),E103)","v":11.45},{"$f":"MIN(IF(F$108=\"Alternative\",'1. ENTER DATA'!H78,IF(OR(F$108=\"Infiltration Field\",F$108=\"None\",F$108=\"Beneficial Reuse\"),F103,LOOKUP(F$108,$C$48:$G$48,$C53:$G53))),F103)","v":11.45}]
["TP","mg/L",{"$f":"MIN(IF(C$108=\"Alternative\",'1. ENTER DATA'!E79,IF(OR(C$108=\"Infiltration Field\",C$108=\"None\",C$108=\"Beneficial Reuse\"),C104,LOOKUP(C$108,$C$48:$G$48,$C54:$G54))),C104)","v":0.224},{"$f":"MIN(IF(D$108=\"Alternative\",'1. ENTER DATA'!F79,IF(OR(D$108=\"Infiltration Field\",D$108=\"None\",D$108=\"Beneficial Reuse\"),D104,LOOKUP(D$108,$C$48:$G$48,$C54:$G54))),D104)","v":0.224},{"$f":"MIN(IF(E$108=\"Alternative\",'1. ENTER DATA'!G79,IF(OR(E$108=\"Infiltration Field\",E$108=\"None\",E$108=\"Beneficial Reuse\"),E104,LOOKUP(E$108,$C$48:$G$48,$C54:$G54))),E104)","v":0.224},{"$f":"MIN(IF(F$108=\"Alternative\",'1. ENTER DATA'!H79,IF(OR(F$108=\"Infiltration Field\",F$108=\"None\",F$108=\"Beneficial Reuse\"),F104,LOOKUP(F$108,$C$48:$G$48,$C54:$G54))),F104)","v":0.224}]
["TSS","mg/L",{"$f":"MIN(IF(C$108=\"Alternative\",'1. ENTER DATA'!E80,IF(OR(C$108=\"Infiltration Field\",C$108=\"None\",C$108=\"Beneficial Reuse\"),C105,LOOKUP(C$108,$C$48:$G$48,$C55:$G55))),C105)","v":133.80000000000001},{"$f":"MIN(IF(D$108=\"Alternative\",'1. ENTER DATA'!F80,IF(OR(D$108=\"Infiltration Field\",D$108=\"None\",D$108=\"Beneficial Reuse\"),D105,LOOKUP(D$108,$C$48:$G$48,$C55:$G55))),D105)","v":133.80000000000001},{"$f":"MIN(IF(E$108=\"Alternative\",'1. ENTER DATA'!G80,IF(OR(E$108=\"Infiltration Field\",E$108=\"None\",E$108=\"Beneficial Reuse\"),E105,LOOKUP(E$108,$C$48:$G$48,$C55:$G55))),E105)","v":133.80000000000001},{"$f":"MIN(IF(F$108=\"Alternative\",'1. ENTER DATA'!H80,IF(OR(F$108=\"Infiltration Field\",F$108=\"None\",F$108=\"Beneficial Reuse\"),F105,LOOKUP(F$108,$C$48:$G$48,$C55:$G55))),F105)","v":133.80000000000001}]
["Zn","mg/L",{"$f":"MIN(IF(C$108=\"Alternative\",'1. ENTER DATA'!E81,IF(OR(C$108=\"Infiltration Field\",C$108=\"None\",C$108=\"Beneficial Reuse\"),C106,LOOKUP(C$108,$C$48:$G$48,$C56:$G56))),C106)","v":2.3565000000000003E-2},{"$f":"MIN(IF(D$108=\"Alternative\",'1. ENTER DATA'!F81,IF(OR(D$108=\"Infiltration Field\",D$108=\"None\",D$108=\"Beneficial Reuse\"),D106,LOOKUP(D$108,$C$48:$G$48,$C56:$G56))),D106)","v":2.3565000000000003E-2},{"$f":"MIN(IF(E$108=\"Alternative\",'1. ENTER DATA'!G81,IF(OR(E$108=\"Infiltration Field\",E$108=\"None\",E$108=\"Beneficial Reuse\"),E106,LOOKUP(E$108,$C$48:$G$48,$C56:$G56))),E106)","v":2.3565000000000003E-2},{"$f":"MIN(IF(F$108=\"Alternative\",'1. ENTER DATA'!H81,IF(OR(F$108=\"Infiltration Field\",F$108=\"None\",F$108=\"Beneficial Reuse\"),F106,LOOKUP(F$108,$C$48:$G$48,$C56:$G56))),F106)","v":2.3565000000000003E-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'!E63","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!F63","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!G63","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!H63","v":"Retention Basin"}]
["COD","mg/L",{"$f":"IF(C$121=\"None\",I37,MIN(I37,IF('1. ENTER DATA'!E$27=\"Yes (Off-Line)\",C65,D65)))","v":24.953148334792502},{"$f":"IF(D$121=\"None\",J37,MIN(J37,IF('1. ENTER DATA'!F$27=\"Yes (Off-Line)\",E65,F65)))","v":24.953148334792502},{"$f":"IF(E$121=\"None\",K37,MIN(K37,IF('1. ENTER DATA'!G$27=\"Yes (Off-Line)\",G65,H65)))","v":24.953148334792502},{"$f":"IF(F$121=\"None\",L37,MIN(L37,IF('1. ENTER DATA'!H$27=\"Yes (Off-Line)\",I65,J65)))","v":24.953148334792502}]
["E. coli","CFU/100mL",{"$f":"IF(C$121=\"None\",I38,MIN(I38,IF('1. ENTER DATA'!E$27=\"Yes (Off-Line)\",C66,D66)))","v":8229.24868738228},{"$f":"IF(D$121=\"None\",J38,MIN(J38,IF('1. ENTER DATA'!F$27=\"Yes (Off-Line)\",E66,F66)))","v":8229.24868738228},{"$f":"IF(E$121=\"None\",K38,MIN(K38,IF('1. ENTER DATA'!G$27=\"Yes (Off-Line)\",G66,H66)))","v":8229.24868738228},{"$f":"IF(F$121=\"None\",L38,MIN(L38,IF('1. ENTER DATA'!H$27=\"Yes (Off-Line)\",I66,J66)))","v":8229.24868738228}]
["Pb","mg/L",{"$f":"IF(C$121=\"None\",I39,MIN(I39,IF('1. ENTER DATA'!E$27=\"Yes (Off-Line)\",C67,D67)))","v":4.2830000000000003E-3},{"$f":"IF(D$121=\"None\",J39,MIN(J39,IF('1. ENTER DATA'!F$27=\"Yes (Off-Line)\",E67,F67)))","v":4.2830000000000003E-3},{"$f":"IF(E$121=\"None\",K39,MIN(K39,IF('1. ENTER DATA'!G$27=\"Yes (Off-Line)\",G67,H67)))","v":4.2830000000000003E-3},{"$f":"IF(F$121=\"None\",L39,MIN(L39,IF('1. ENTER DATA'!H$27=\"Yes (Off-Line)\",I67,J67)))","v":4.2830000000000003E-3}]
["TN","mg/L",{"$f":"IF(C$121=\"None\",I40,MIN(I40,IF('1. ENTER DATA'!E$27=\"Yes (Off-Line)\",C68,D68)))","v":1.3362938519585843},{"$f":"IF(D$121=\"None\",J40,MIN(J40,IF('1. ENTER DATA'!F$27=\"Yes (Off-Line)\",E68,F68)))","v":1.3362938519585843},{"$f":"IF(E$121=\"None\",K40,MIN(K40,IF('1. ENTER DATA'!G$27=\"Yes (Off-Line)\",G68,H68)))","v":1.3362938519585843},{"$f":"IF(F$121=\"None\",L40,MIN(L40,IF('1. ENTER DATA'!H$27=\"Yes (Off-Line)\",I68,J68)))","v":1.3362938519585843}]
["TOC","mg/L",{"$f":"IF(C$121=\"None\",I41,MIN(I41,IF('1. ENTER DATA'!E$27=\"Yes (Off-Line)\",C69,D69)))","v":9.5114848498470099},{"$f":"IF(D$121=\"None\",J41,MIN(J41,IF('1. ENTER DATA'!F$27=\"Yes (Off-Line)\",E69,F69)))","v":9.5114848498470099},{"$f":"IF(E$121=\"None\",K41,MIN(K41,IF('1. ENTER DATA'!G$27=\"Yes (Off-Line)\",G69,H69)))","v":9.5114848498470099},{"$f":"IF(F$121=\"None\",L41,MIN(L41,IF('1. ENTER DATA'!H$27=\"Yes (Off-Line)\",I69,J69)))","v":9.5114848498470099}]
["TP","mg/L",{"$f":"IF(C$121=\"None\",I42,MIN(I42,IF('1. ENTER DATA'!E$27=\"Yes (Off-Line)\",C70,D70)))","v":0.16752042413770912},{"$f":"IF(D$121=\"None\",J42,MIN(J42,IF('1. ENTER DATA'!F$27=\"Yes (Off-Line)\",E70,F70)))","v":0.16752042413770912},{"$f":"IF(E$121=\"None\",K42,MIN(K42,IF('1. ENTER DATA'!G$27=\"Yes (Off-Line)\",G70,H70)))","v":0.16752042413770912},{"$f":"IF(F$121=\"None\",L42,MIN(L42,IF('1. ENTER DATA'!H$27=\"Yes (Off-Line)\",I70,J70)))","v":0.16752042413770912}]
["TSS","mg/L",{"$f":"IF(C$121=\"None\",I43,MIN(I43,IF('1. ENTER DATA'!E$27=\"Yes (Off-Line)\",C71,D71)))","v":19.187326826927933},{"$f":"IF(D$121=\"None\",J43,MIN(J43,IF('1. ENTER DATA'!F$27=\"Yes (Off-Line)\",E71,F71)))","v":19.187326826927933},{"$f":"IF(E$121=\"None\",K43,MIN(K43,IF('1. ENTER DATA'!G$27=\"Yes (Off-Line)\",G71,H71)))","v":19.187326826927933},{"$f":"IF(F$121=\"None\",L43,MIN(L43,IF('1. ENTER DATA'!H$27=\"Yes (Off-Line)\",I71,J71)))","v":19.187326826927933}]
["Zn","mg/L",{"$f":"IF(C$121=\"None\",I44,MIN(I44,IF('1. ENTER DATA'!E$27=\"Yes (Off-Line)\",C72,D72)))","v":2.3565000000000003E-2},{"$f":"IF(D$121=\"None\",J44,MIN(J44,IF('1. ENTER DATA'!F$27=\"Yes (Off-Line)\",E72,F72)))","v":2.3565000000000003E-2},{"$f":"IF(E$121=\"None\",K44,MIN(K44,IF('1. ENTER DATA'!G$27=\"Yes (Off-Line)\",G72,H72)))","v":2.3565000000000003E-2},{"$f":"IF(F$121=\"None\",L44,MIN(L44,IF('1. ENTER DATA'!H$27=\"Yes (Off-Line)\",I72,J72)))","v":2.3565000000000003E-2}]
[null,null,"SCM A.2","SCM B.2","SCM C.2","SCM D.2"]
["Pollutant","Units",{"$f":"'1. ENTER DATA'!E73","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!F73","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!G73","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!H73","v":"Infiltration Field"}]
["COD","mg/L",{"$f":"C99","v":38.9},38.9,38.9,38.9]
["E. coli","CFU/100mL",11065,11065,11065,11065]
["Pb","mg/L",4.2830000000000003E-3,4.2830000000000003E-3,4.2830000000000003E-3,4.2830000000000003E-3]
["TN","mg/L",1.42,1.42,1.42,1.42]
["TOC","mg/L",11.45,11.45,11.45,11.45]
["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",2.3565000000000003E-2,2.3565000000000003E-2,2.3565000000000003E-2,2.3565000000000003E-2]
[]
["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'!E26<>\"None\",1,0)","v":1},{"$f":"IF('1. ENTER DATA'!F26<>\"None\",1,0)","v":1},{"$f":"IF('1. ENTER DATA'!G26<>\"None\",1,0)","v":1},{"$f":"IF('1. ENTER DATA'!H26<>\"None\",1,0)","v":1}]
["Volume treated by SCM 1 (in/yr)",null,{"$f":"RCE_A1/100*'3. CALCS_Loads'!C88*C143","v":1.1839627863340729},{"$f":"RCE_B1/100*'3. CALCS_Loads'!D88*D143","v":0},{"$f":"RCE_C1/100*'3. CALCS_Loads'!E88*E143","v":0},{"$f":"RCE_D1/100*'3. CALCS_Loads'!F88*F143","v":0}]
["Volume treated by SCM 1 (Ac-in/yr)",null,{"$f":"RCE_A1/100*'3. CALCS_Loads'!C89","v":1.1839627863340729},{"$f":"RCE_B1/100*'3. CALCS_Loads'!D89","v":0},{"$f":"RCE_C1/100*'3. CALCS_Loads'!E89","v":0},{"$f":"RCE_D1/100*'3. CALCS_Loads'!F89","v":0}]
["Bypass Volume (in/yr)",null,{"$f":"'3. CALCS_Loads'!C88-C144","v":5.5598458696182185E-4},{"$f":"'3. CALCS_Loads'!D88-D144","v":0},{"$f":"'3. CALCS_Loads'!E88-E144","v":0},{"$f":"'3. CALCS_Loads'!F88-F144","v":0}]
["Bypass Volume (Ac-in/yr)",null,{"$f":"'3. CALCS_Loads'!C89-C145","v":5.5598458696182185E-4},{"$f":"'3. CALCS_Loads'!D89-D145","v":0},{"$f":"'3. CALCS_Loads'!E89-E145","v":0},{"$f":"'3. CALCS_Loads'!F89-F145","v":0}]
[null,null,"SCM A.2","SCM B.2","SCM C.2","SCM D.2"]
["Control is not \"None\"?",null,{"$f":"IF('1. ENTER DATA'!E45<>\"None\",1,0)","v":1},{"$f":"IF('1. ENTER DATA'!F45<>\"None\",1,0)","v":1},{"$f":"IF('1. ENTER DATA'!G45<>\"None\",1,0)","v":1},{"$f":"IF('1. ENTER DATA'!H45<>\"None\",1,0)","v":1}]
["WQV Routed to SCM 2 (in)",null,{"$f":"C149*C143*C78*'1. ENTER DATA'!E46/100*IF('5.CALCS_Adams&Papa'!B28=0,0,WQV_A1)","v":2.5},{"$f":"D149*D143*D78*'1. ENTER DATA'!F46/100*IF('5.CALCS_Adams&Papa'!B28=0,0,WQV_B1)","v":0},{"$f":"E149*E143*E78*'1. ENTER DATA'!G46/100*IF('5.CALCS_Adams&Papa'!B28=0,0,WQV_C1)","v":0},{"$f":"F149*F143*F78*'1. ENTER DATA'!H46/100*IF('5.CALCS_Adams&Papa'!B28=0,0,WQV_D1)","v":0}]
["Volume routed to SCM 2 (in/yr)",null,{"$f":"'5.CALCS_Adams&Papa'!B50*C78*C149*C143","v":1.1839627863340727},{"$f":"'5.CALCS_Adams&Papa'!C50*D78*D149*D143","v":0},{"$f":"'5.CALCS_Adams&Papa'!D50*E78*E149*E143","v":0},{"$f":"'5.CALCS_Adams&Papa'!E50*F78*F149*F143","v":0}]
["Volume routed to SCM 2 (Ac-in/yr)",null,{"$f":"C79*C151","v":1.1839627863340727},{"$f":"D79*D151","v":0},{"$f":"E79*E151","v":0},{"$f":"F79*F151","v":0}]
["WQV Infiltrated/reused (in)",null,{"$f":"'4. CALCS_Infiltration'!E21*C149*C143*C78","v":2.5},{"$f":"IF('1. ENTER DATA'!F49=\"Yes\",'1. ENTER DATA'!F50,D150)*D149*D143*D78","v":0},{"$f":"IF('1. ENTER DATA'!G49=\"Yes\",'1. ENTER DATA'!G50,E150)*E149*E143*E78","v":0},{"$f":"IF('1. ENTER DATA'!H49=\"Yes\",'1. ENTER DATA'!H50,F150)*F149*F143*F78","v":0}]
["Infiltrated Volume (in/yr)",null,{"$f":"C$78*IF('1. ENTER DATA'!E48=\"Yes\",'4. CALCS_Infiltration'!E22,0)*C149*C143","v":1.1839627863340727},{"$f":"D$78*IF('1. ENTER DATA'!F48=\"Yes\",'4. CALCS_Infiltration'!F22,0)*D149*D143","v":0},{"$f":"E$78*IF('1. ENTER DATA'!G48=\"Yes\",'4. CALCS_Infiltration'!G22,0)*E149*E143","v":0},{"$f":"F$78*IF('1. ENTER DATA'!H48=\"Yes\",'4. CALCS_Infiltration'!H22,0)*F149*F143","v":0}]
["Infiltrated Volume (Ac-in/yr) - for calcs",null,{"$f":"C79*C154","v":1.1839627863340727},{"$f":"D79*D154","v":0},{"$f":"E79*E154","v":0},{"$f":"F79*F154","v":0}]
["Non-infiltrated Volume Treated by SCM 2 (in/yr)",null,{"$f":"(C151-C154)*C149*C143","v":0},{"$f":"(D151-D154)*D149*D143","v":0},{"$f":"(E151-E154)*E149*E143","v":0},{"$f":"(F151-F154)*F149*F143","v":0}]
["Non-infiltrated Volume Treated by SCM 2 (Acre-in/yr)",null,{"$f":"C79*C156","v":0},{"$f":"D79*D156","v":0},{"$f":"E79*E156","v":0},{"$f":"F79*F156","v":0}]
["Volume treated by only SCM 1 (bypasses SCM 2) (in/yr)",null,{"$f":"('3. CALCS_Loads'!C144-'3. CALCS_Loads'!C151)*C143","v":2.2204460492503131E-16},{"$f":"('3. CALCS_Loads'!D144-'3. CALCS_Loads'!D151)*D143","v":0},{"$f":"('3. CALCS_Loads'!E144-'3. CALCS_Loads'!E151)*E143","v":0},{"$f":"('3. CALCS_Loads'!F144-'3. CALCS_Loads'!F151)*F143","v":0}]
["Volume treated by only SCM 1 (bypasses SCM 2) (Acre-in/yr)",null,{"$f":"('3. CALCS_Loads'!C145-'3. CALCS_Loads'!C152)*C143","v":2.2204460492503131E-16},{"$f":"('3. CALCS_Loads'!D145-'3. CALCS_Loads'!D152)*D143","v":0},{"$f":"('3. CALCS_Loads'!E145-'3. CALCS_Loads'!E152)*E143","v":0},{"$f":"('3. CALCS_Loads'!F145-'3. CALCS_Loads'!F152)*F143","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,"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 (Treated) Load",null,null,null,null,null,null,null,"Compare to Existing","Compare to Sed/Fil"]
["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","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)"]
["COD",{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C99*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":10.440929746449244},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D99*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E99*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F99*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$159*'3. CALCS_Loads'!C132*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":1.958129214330029E-15},{"$f":"'3. CALCS_Loads'!D$159*'3. CALCS_Loads'!D132*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$159*'3. CALCS_Loads'!E132*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$159*'3. CALCS_Loads'!F132*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$157*'3. CALCS_Loads'!C109*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$157*'3. CALCS_Loads'!D109*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$157*'3. CALCS_Loads'!E109*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$157*'3. CALCS_Loads'!F109*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$147*'3. CALCS_Loads'!C122*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":3.145137382800792E-3},{"$f":"'3. CALCS_Loads'!D$147*'3. CALCS_Loads'!D122*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$147*'3. CALCS_Loads'!E122*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$147*'3. CALCS_Loads'!F122*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E37*C$84*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":10.445832768807366},{"$f":"'3. CALCS_Loads'!F37*D$84*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G37*E$84*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H37*F$84*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$39*'3. CALCS_Loads'!$F49+'5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!K65)*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*C$78","v":6.0660747236617665},{"$f":"('5.CALCS_Adams&Papa'!H$39*'3. CALCS_Loads'!$F49+'5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!L65)*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*D$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$39*'3. CALCS_Loads'!$F49+'5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!M65)*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*E$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$39*'3. CALCS_Loads'!$F49+'5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!N65)*IF(LOOKUP($A166,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*F$78","v":0},{"$f":"F166+J166+N166","v":3.1451373828027501E-3},0,0,0,{"$f":"SUM(R166:U166)","v":10.445832768807366},{"$f":"SUM(V166:Y166)","v":6.0660747236617665},{"$f":"SUM(N166:Q166)","v":3.145137382800792E-3},{"$f":"SUM(Z166:AC166)","v":3.1451373828027501E-3},{"$f":"AG166/AD166","v":3.0109015263910264E-4},{"$f":"AG166/AE166","v":5.1847982856765705E-4},{"$f":"IF(AH166<=1,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(AI166<=1,\"YES\",\"NO\")","v":"YES"}]
["E. coli",{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C100*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":13466.053526425461},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D100*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E100*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F100*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$159*'3. CALCS_Loads'!C133*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":2.525471720637995E-12},{"$f":"'3. CALCS_Loads'!D$159*'3. CALCS_Loads'!D133*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$159*'3. CALCS_Loads'!E133*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$159*'3. CALCS_Loads'!F133*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$157*'3. CALCS_Loads'!C110*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$157*'3. CALCS_Loads'!D110*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$157*'3. CALCS_Loads'!E110*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$157*'3. CALCS_Loads'!F110*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$147*'3. CALCS_Loads'!C123*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":4.7029872910259956},{"$f":"'3. CALCS_Loads'!D$147*'3. CALCS_Loads'!D123*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$147*'3. CALCS_Loads'!E123*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$147*'3. CALCS_Loads'!F123*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E38*C$84*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":10193.469623240113},{"$f":"'3. CALCS_Loads'!F38*D$84*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G38*E$84*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H38*F$84*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$39*'3. CALCS_Loads'!$F50+'5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!K66)*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*C$78","v":6038.6953961544959},{"$f":"('5.CALCS_Adams&Papa'!H$39*'3. CALCS_Loads'!$F50+'5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!L66)*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*D$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$39*'3. CALCS_Loads'!$F50+'5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!M66)*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*E$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$39*'3. CALCS_Loads'!$F50+'5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!N66)*IF(LOOKUP($A167,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*F$78","v":0},4.7029872910285206,0,0,0,10193.469623240113,6038.6953961544959,4.7029872910259956,4.7029872910285206,4.6137257134765673E-4,7.7880849794533967E-4,{"$f":"IF(AH167<=1,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(AI167<=1,\"YES\",\"NO\")","v":"YES"}]
["Pb",{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C101*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":1.1495758895640649E-3},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D101*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E101*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F101*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$159*'3. CALCS_Loads'!C134*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":2.1559556362404923E-19},{"$f":"'3. CALCS_Loads'!D$159*'3. CALCS_Loads'!D134*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$159*'3. CALCS_Loads'!E134*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$159*'3. CALCS_Loads'!F134*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$157*'3. CALCS_Loads'!C111*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$157*'3. CALCS_Loads'!D111*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$157*'3. CALCS_Loads'!E111*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$157*'3. CALCS_Loads'!F111*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$147*'3. CALCS_Loads'!C124*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":5.3983662621656143E-7},{"$f":"'3. CALCS_Loads'!D$147*'3. CALCS_Loads'!D124*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$147*'3. CALCS_Loads'!E124*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$147*'3. CALCS_Loads'!F124*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E39*C$84*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":1.1501157261902815E-3},{"$f":"'3. CALCS_Loads'!F39*D$84*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G39*E$84*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H39*F$84*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$39*'3. CALCS_Loads'!$F51+'5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!K67)*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*C$78","v":1.5503295899988519E-3},{"$f":"('5.CALCS_Adams&Papa'!H$39*'3. CALCS_Loads'!$F51+'5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!L67)*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*D$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$39*'3. CALCS_Loads'!$F51+'5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!M67)*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*E$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$39*'3. CALCS_Loads'!$F51+'5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!N67)*IF(LOOKUP($A168,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*F$78","v":0},5.39836626216777E-7,0,0,0,1.1501157261902815E-3,1.5503295899988519E-3,5.3983662621656143E-7,5.39836626216777E-7,4.6937591924333316E-4,3.4820765190786093E-4,"YES","YES"]
["TN",{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C102*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0.38113419639994678},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D102*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E102*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F102*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$159*'3. CALCS_Loads'!C135*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":7.1479266949836524E-17},{"$f":"'3. CALCS_Loads'!D$159*'3. CALCS_Loads'!D135*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$159*'3. CALCS_Loads'!E135*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$159*'3. CALCS_Loads'!F135*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$157*'3. CALCS_Loads'!C112*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$157*'3. CALCS_Loads'!D112*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$157*'3. CALCS_Loads'!E112*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$157*'3. CALCS_Loads'!F112*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$147*'3. CALCS_Loads'!C125*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":1.6842875663676288E-4},{"$f":"'3. CALCS_Loads'!D$147*'3. CALCS_Loads'!D125*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$147*'3. CALCS_Loads'!E125*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$147*'3. CALCS_Loads'!F125*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E40*C$84*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0.31955118238768027},{"$f":"'3. CALCS_Loads'!F40*D$84*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G40*E$84*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H40*F$84*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$39*'3. CALCS_Loads'!$F52+'5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!K68)*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*C$78","v":0.28864371908313202},{"$f":"('5.CALCS_Adams&Papa'!H$39*'3. CALCS_Loads'!$F52+'5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!L68)*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*D$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$39*'3. CALCS_Loads'!$F52+'5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!M68)*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*E$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$39*'3. CALCS_Loads'!$F52+'5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!N68)*IF(LOOKUP($A169,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*F$78","v":0},1.6842875663683436E-4,0,0,0,0.31955118238768027,0.28864371908313202,1.6842875663676288E-4,1.6842875663683436E-4,5.2707912196831171E-4,5.8351783011888561E-4,"YES","YES"]
["TOC",{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C103*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":3.073229963929148},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D103*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E103*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F103*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$159*'3. CALCS_Loads'!C136*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":5.7636451167297759E-16},{"$f":"'3. CALCS_Loads'!D$159*'3. CALCS_Loads'!D136*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$159*'3. CALCS_Loads'!E136*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$159*'3. CALCS_Loads'!F136*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$157*'3. CALCS_Loads'!C113*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$157*'3. CALCS_Loads'!D113*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$157*'3. CALCS_Loads'!E113*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$157*'3. CALCS_Loads'!F113*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$147*'3. CALCS_Loads'!C126*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":1.1988437757766395E-3},{"$f":"'3. CALCS_Loads'!D$147*'3. CALCS_Loads'!D126*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$147*'3. CALCS_Loads'!E126*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$147*'3. CALCS_Loads'!F126*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E41*C$84*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":3.4989511819424157},{"$f":"'3. CALCS_Loads'!F41*D$84*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G41*E$84*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H41*F$84*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$39*'3. CALCS_Loads'!$F53+'5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!K69)*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*C$78","v":1.9754450661810417},{"$f":"('5.CALCS_Adams&Papa'!H$39*'3. CALCS_Loads'!$F53+'5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!L69)*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*D$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$39*'3. CALCS_Loads'!$F53+'5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!M69)*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*E$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$39*'3. CALCS_Loads'!$F53+'5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!N69)*IF(LOOKUP($A170,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*F$78","v":0},{"$f":"F170+J170+N170","v":1.1988437757772159E-3},{"$f":"G170+K170+O170","v":0},{"$f":"H170+L170+P170","v":0},{"$f":"I170+M170+Q170","v":0},{"$f":"SUM(R170:U170)","v":3.4989511819424157},{"$f":"SUM(V170:Y170)","v":1.9754450661810417},{"$f":"SUM(N170:Q170)","v":1.1988437757766395E-3},{"$f":"SUM(Z170:AC170)","v":1.1988437757772159E-3},{"$f":"AG170/AD170","v":3.4262946621384043E-4},{"$f":"AG170/AE170","v":6.0687274797007525E-4},{"$f":"IF(AH170<=1,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(AI170<=1,\"YES\",\"NO\")","v":"YES"}]
["TP",{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C104*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":6.0122577460273295E-2},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D104*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E104*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F104*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$159*'3. CALCS_Loads'!C137*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":1.127560267377703E-17},{"$f":"'3. CALCS_Loads'!D$159*'3. CALCS_Loads'!D137*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$159*'3. CALCS_Loads'!E137*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$159*'3. CALCS_Loads'!F137*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$157*'3. CALCS_Loads'!C114*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$157*'3. CALCS_Loads'!D114*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$157*'3. CALCS_Loads'!E114*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$157*'3. CALCS_Loads'!F114*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$147*'3. CALCS_Loads'!C127*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":2.1114560025418703E-5},{"$f":"'3. CALCS_Loads'!D$147*'3. CALCS_Loads'!D127*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$147*'3. CALCS_Loads'!E127*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$147*'3. CALCS_Loads'!F127*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E42*C$84*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":3.329777026560702E-2},{"$f":"'3. CALCS_Loads'!F42*D$84*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G42*E$84*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H42*F$84*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$39*'3. CALCS_Loads'!$F54+'5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!K70)*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*C$78","v":2.6942839039508486E-2},{"$f":"('5.CALCS_Adams&Papa'!H$39*'3. CALCS_Loads'!$F54+'5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!L70)*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*D$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$39*'3. CALCS_Loads'!$F54+'5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!M70)*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*E$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$39*'3. CALCS_Loads'!$F54+'5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!N70)*IF(LOOKUP($A171,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*F$78","v":0},2.1114560025429979E-5,0,0,0,3.329777026560702E-2,2.6942839039508486E-2,2.1114560025418703E-5,2.1114560025429979E-5,6.3411333122323282E-4,7.8367984882617505E-4,"YES","YES"]
["TSS",{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C105*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":35.912503857966819},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D105*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E105*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F105*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$159*'3. CALCS_Loads'!C138*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":6.7351590971043162E-15},{"$f":"'3. CALCS_Loads'!D$159*'3. CALCS_Loads'!D138*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$159*'3. CALCS_Loads'!E138*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$159*'3. CALCS_Loads'!F138*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$157*'3. CALCS_Loads'!C115*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$157*'3. CALCS_Loads'!D115*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$157*'3. CALCS_Loads'!E115*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$157*'3. CALCS_Loads'!F115*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$147*'3. CALCS_Loads'!C128*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":2.4184034042407884E-3},{"$f":"'3. CALCS_Loads'!D$147*'3. CALCS_Loads'!D128*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$147*'3. CALCS_Loads'!E128*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$147*'3. CALCS_Loads'!F128*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E43*C$84*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":44.576047291054564},{"$f":"'3. CALCS_Loads'!F43*D$84*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G43*E$84*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H43*F$84*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$39*'3. CALCS_Loads'!$F55+'5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!K71)*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*C$78","v":5.6499005620370877},{"$f":"('5.CALCS_Adams&Papa'!H$39*'3. CALCS_Loads'!$F55+'5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!L71)*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*D$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$39*'3. CALCS_Loads'!$F55+'5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!M71)*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*E$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$39*'3. CALCS_Loads'!$F55+'5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!N71)*IF(LOOKUP($A172,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*F$78","v":0},2.4184034042475234E-3,0,0,0,44.576047291054564,5.6499005620370877,2.4184034042407884E-3,2.4184034042475234E-3,5.4253428718271391E-5,4.2804353416364574E-4,"YES","YES"]
["Zn",{"$f":"'3. CALCS_Loads'!C$145*'3. CALCS_Loads'!C106*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":6.3249488296934836E-3},{"$f":"'3. CALCS_Loads'!D$145*'3. CALCS_Loads'!D106*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$145*'3. CALCS_Loads'!E106*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$145*'3. CALCS_Loads'!F106*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$159*'3. CALCS_Loads'!C139*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":1.186203468783731E-18},{"$f":"'3. CALCS_Loads'!D$159*'3. CALCS_Loads'!D139*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$159*'3. CALCS_Loads'!E139*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$159*'3. CALCS_Loads'!F139*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$157*'3. CALCS_Loads'!C116*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!D$157*'3. CALCS_Loads'!D116*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$157*'3. CALCS_Loads'!E116*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$157*'3. CALCS_Loads'!F116*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!C$147*'3. CALCS_Loads'!C129*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":2.9701727986909343E-6},{"$f":"'3. CALCS_Loads'!D$147*'3. CALCS_Loads'!D129*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E$147*'3. CALCS_Loads'!E129*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!F$147*'3. CALCS_Loads'!F129*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!E44*C$84*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":6.3279190024921744E-3},{"$f":"'3. CALCS_Loads'!F44*D$84*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!G44*E$84*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"'3. CALCS_Loads'!H44*F$84*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)","v":0},{"$f":"('5.CALCS_Adams&Papa'!G$39*'3. CALCS_Loads'!$F56+'5.CALCS_Adams&Papa'!G$40*'3. CALCS_Loads'!K72)*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*C$78","v":6.2388253646953251E-3},{"$f":"('5.CALCS_Adams&Papa'!H$39*'3. CALCS_Loads'!$F56+'5.CALCS_Adams&Papa'!H$40*'3. CALCS_Loads'!L72)*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*D$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!I$39*'3. CALCS_Loads'!$F56+'5.CALCS_Adams&Papa'!I$40*'3. CALCS_Loads'!M72)*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*E$78","v":0},{"$f":"('5.CALCS_Adams&Papa'!J$39*'3. CALCS_Loads'!$F56+'5.CALCS_Adams&Papa'!J$40*'3. CALCS_Loads'!N72)*IF(LOOKUP($A173,'3. CALCS_Loads'!$A$37:$A$44,'3. CALCS_Loads'!$C$37:$C$44)=\"CF_1\",CF_1,CF_2)*F$78","v":0},2.9701727986921205E-6,0,0,0,6.3279190024921744E-3,6.2388253646953251E-3,2.9701727986909343E-6,2.9701727986921205E-6,4.6937591924333321E-4,4.7607884899294176E-4,"YES","YES"]
[]
["PLOT: Developed, Existing, and Sed/Fil Loadings"]
["POLLUTANT",{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",\"Drainage Area A - Existing\",\"Drainage Area A - Sed/Fil\")","v":"Drainage Area A - Existing"},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",\"Drainage Area B - Existing\",\"Drainage Area B - Sed/Fil\")","v":"Drainage Area B - Existing"},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",\"Drainage Area C - Existing\",\"Drainage Area C - Sed/Fil\")","v":"Drainage Area C - Existing"},{"$f":"IF('1. ENTER DATA'!$E$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'!$E$14=\"Yes\",'3. CALCS_Loads'!R166,'3. CALCS_Loads'!V166)","v":10.445832768807366},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!S166,'3. CALCS_Loads'!W166)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!T166,'3. CALCS_Loads'!X166)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!U166,'3. CALCS_Loads'!Y166)","v":0},{"$f":"Z166","v":3.1451373828027501E-3},0,0,0]
["E. coli",{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!R167,'3. CALCS_Loads'!V167)","v":10193.469623240113},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!S167,'3. CALCS_Loads'!W167)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!T167,'3. CALCS_Loads'!X167)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!U167,'3. CALCS_Loads'!Y167)","v":0},4.7029872910285206,0,0,0]
["Pb",{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!R168,'3. CALCS_Loads'!V168)","v":1.1501157261902815E-3},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!S168,'3. CALCS_Loads'!W168)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!T168,'3. CALCS_Loads'!X168)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!U168,'3. CALCS_Loads'!Y168)","v":0},5.39836626216777E-7,0,0,0]
["TN",{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!R169,'3. CALCS_Loads'!V169)","v":0.31955118238768027},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!S169,'3. CALCS_Loads'!W169)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!T169,'3. CALCS_Loads'!X169)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!U169,'3. CALCS_Loads'!Y169)","v":0},1.6842875663683436E-4,0,0,0]
["TOC",{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!R170,'3. CALCS_Loads'!V170)","v":3.4989511819424157},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!S170,'3. CALCS_Loads'!W170)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!T170,'3. CALCS_Loads'!X170)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!U170,'3. CALCS_Loads'!Y170)","v":0},1.1988437757772159E-3,0,0,0]
["TP",{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!R171,'3. CALCS_Loads'!V171)","v":3.329777026560702E-2},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!S171,'3. CALCS_Loads'!W171)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!T171,'3. CALCS_Loads'!X171)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!U171,'3. CALCS_Loads'!Y171)","v":0},{"$f":"Z171","v":2.1114560025429979E-5},0,0,0]
["TSS",{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!R172,'3. CALCS_Loads'!V172)","v":44.576047291054564},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!S172,'3. CALCS_Loads'!W172)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!T172,'3. CALCS_Loads'!X172)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!U172,'3. CALCS_Loads'!Y172)","v":0},2.4184034042475234E-3,0,0,0]
["Zn",{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!R173,'3. CALCS_Loads'!V173)","v":6.3279190024921744E-3},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!S173,'3. CALCS_Loads'!W173)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!T173,'3. CALCS_Loads'!X173)","v":0},{"$f":"IF('1. ENTER DATA'!$E$14=\"Yes\",'3. CALCS_Loads'!U173,'3. CALCS_Loads'!Y173)","v":0},2.9701727986921205E-6,0,0,0]
[]
["PLOT: Load Equivalency Factor (LEF)"]
["POLLUTANT","RED","GREEN"]
[null,">1","<=1"]
["COD",{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A189,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A189,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))>1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A189,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A189,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A189,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A189,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))<=1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A189,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A189,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":3.0109015263910264E-4}]
["E. coli",{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A190,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A190,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))>1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A190,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A190,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A190,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A190,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))<=1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A190,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A190,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":4.6137257134765673E-4}]
["Pb",{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A191,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A191,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))>1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A191,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A191,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A191,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A191,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))<=1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A191,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A191,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":4.6937591924333316E-4}]
["TN",{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A192,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A192,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))>1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A192,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A192,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A192,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A192,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))<=1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A192,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A192,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":5.2707912196831171E-4}]
["TOC",{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A193,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A193,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))>1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A193,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A193,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A193,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A193,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))<=1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A193,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A193,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":3.4262946621384043E-4}]
["TP",{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A194,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A194,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))>1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A194,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A194,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A194,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A194,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))<=1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A194,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A194,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":6.3411333122323282E-4}]
["TSS",{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A195,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A195,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))>1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A195,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A195,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A195,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A195,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))<=1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A195,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A195,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":5.4253428718271391E-5}]
["Zn",{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A196,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A196,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))>1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A196,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A196,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A196,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A196,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173))<=1,IF('1. ENTER DATA'!$E$14=\"No\",LOOKUP($A196,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AI$166:$AI$173),LOOKUP('3. CALCS_Loads'!$A196,'3. CALCS_Loads'!$A$166:$A$173,'3. CALCS_Loads'!$AH$166:$AH$173)),#N/A)","v":4.6937591924333321E-4}]

{"sheet":"4. CALCS_Infiltration","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["SIZING INFILTRATION FIELDS"]
[]
["LOOK UP…",null,null,null,"SCM A2","SCM B2","SCM C2","SCM D2"]
["Drainage Area",null,null,"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",null,null,"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},"Water application time: if given DDT, = DDT; if given treatment rate, = WQV_inf / treatment rate"]
["Soil Infiltration Rate (permeability)",null,null,"in/hr",{"$f":"'1. ENTER DATA'!E52","v":0.2},{"$f":"'1. ENTER DATA'!F52","v":0.2},{"$f":"'1. ENTER DATA'!G52","v":0.2},{"$f":"'1. ENTER DATA'!H52","v":0.2}]
["Number of Application Zones",null,null,null,{"$f":"'1. ENTER DATA'!E51","v":2},{"$f":"'1. ENTER DATA'!F51","v":2},{"$f":"'1. ENTER DATA'!G51","v":2},{"$f":"'1. ENTER DATA'!H51","v":2}]
[]
["1. WQV_inf Known, Calculate Area"]
["WQV infiltrated",null,null,"in",{"$f":"IF('1. ENTER DATA'!E49=\"Yes\",'1. ENTER DATA'!E50,'3. CALCS_Loads'!C150)","v":2.5},{"$f":"IF('1. ENTER DATA'!F49=\"Yes\",'1. ENTER DATA'!F50,'3. CALCS_Loads'!D150)","v":0},{"$f":"IF('1. ENTER DATA'!G49=\"Yes\",'1. ENTER DATA'!G50,'3. CALCS_Loads'!E150)","v":0},{"$f":"IF('1. ENTER DATA'!H49=\"Yes\",'1. ENTER DATA'!H50,'3. CALCS_Loads'!F150)","v":0}]
["Field Area",null,null,"Acres",{"$f":"IF(E10<>0,E10*E7/(E6*E5)*E4,0)","v":0.41666666666666669},{"$f":"IF(F10<>0,F10*F7/(F6*F5)*F4,0)","v":0},0,0,null,"A_field (Ac) = WQV (in) * no. of zones * Drainage area (Ac) / [I (in/hr) * app time (hr)]"]
[]
["2. Area Known, Calculate WQV_inf"]
["User Input Field Area",null,null,"Ac",{"$f":"'1. ENTER DATA'!E55","v":0},{"$f":"'1. ENTER DATA'!F55","v":0},{"$f":"'1. ENTER DATA'!G55","v":0},{"$f":"'1. ENTER DATA'!H55","v":0}]
["Corresponding WQVinf",null,null,"in",{"$f":"E14*E6*E5/(E4*E7)","v":0},{"$f":"F14*F6*F5/(F4*F7)","v":0},{"$f":"G14*G6*G5/(G4*G7)","v":0},{"$f":"H14*H6*H5/(H4*H7)","v":0},null,"WQV (in) = A_field (Ac) * I (in/hr) * app time (hr) / [drainage area (Ac) * no. of zones]"]
[]
[]
["3. Values for Use in Calculator"]
[null,null,null,null,"SCM A2","SCM B2","SCM C2","SCM D2"]
["Field Area to Use (Ac)",null,null,null,{"$f":"IF('1. ENTER DATA'!E54=\"Yes\",E14,E11)","v":0.41666666666666669},{"$f":"IF('1. ENTER DATA'!F54=\"Yes\",F14,F11)","v":0},{"$f":"IF('1. ENTER DATA'!G54=\"Yes\",G14,G11)","v":0},{"$f":"IF('1. ENTER DATA'!H54=\"Yes\",H14,H11)","v":0}]
["WQV_inf to Use (in)",null,null,null,{"$f":"IF('1. ENTER DATA'!E54=\"Yes\",IF(E15<E10,E15,E10),E10)","v":2.5},{"$f":"IF('1. ENTER DATA'!F54=\"Yes\",IF(F15<F10,F15,F10),F10)","v":0},{"$f":"IF('1. ENTER DATA'!G54=\"Yes\",IF(G15<G10,G15,G10),G10)","v":0},{"$f":"IF('1. ENTER DATA'!H54=\"Yes\",IF(H15<H10,H15,H10),H10)","v":0},null,"Will adjust for user input field area but not greater than routed volume"]
["Yearly Volume Infiltrated (in/yr)",null,null,null,{"$f":"'5.CALCS_Adams&Papa'!B60","v":1.1839627863340727},{"$f":"'5.CALCS_Adams&Papa'!C60","v":0},{"$f":"'5.CALCS_Adams&Papa'!D60","v":0},{"$f":"'5.CALCS_Adams&Papa'!E60","v":0}]

{"sheet":"5.CALCS_Adams&Papa","index":4,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["ADAMS & PAPA FOR VOLUMETRIC STORMWATER CONTROL MEASURE"]
[]
["Rainfall Statistics"]
["Parameter","Symbol","Value"]
["Mean annual rainfall event volume (in.)","v",{"$f":"'3. CALCS_Loads'!$A$2/'3. CALCS_Loads'!$A$3","v":0.39997478885667465}]
["Mean annual rainfall event duration (hr)","t",5.77]
["Mean annual rainfall event intensity (in/hr)","i",8.3000000000000004E-2]
["Delta = Time interval between storm event midpoints (hr)","Δ",109.4]
["Interevent time, b (hr) - Figure 4.2 in A&P","b",{"$f":"$C$8-$C$6","v":103.63000000000001}]
["Minimum Interevent Time (hr)","IETD",6]
["Psi = 1/(b - IETD)  but using simpler 1/b (1/hr)","y",{"$f":"1/C9","v":9.6497153333976633E-3}]
["Theta = avg. annual number of rainfall events","θ",{"$f":"'3. CALCS_Loads'!A3","v":79.33}]
["Average Annual total rainfall (in.)","P",{"$f":"'3. CALCS_Loads'!A2","v":31.73}]
["Zeta = 1/mean rainfall event volume (1/in)","z",{"$f":"1/v","v":2.5001575795776869}]
["Lambda = 1/mean rainfall event duration (1/hr)","l",{"$f":"1/t","v":0.1733102253032929}]
[]
["Drainage Area","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'!E17","v":1},{"$f":"'1. ENTER DATA'!F17","v":1},{"$f":"'1. ENTER DATA'!G17","v":1},{"$f":"'1. ENTER DATA'!H17","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":6.4399999999999999E-2},{"$f":"RvB_d","v":6.4399999999999999E-2},{"$f":"RvC_d","v":6.4399999999999999E-2},{"$f":"RvD_d","v":6.4399999999999999E-2},null,{"$f":"RvA_d","v":6.4399999999999999E-2},{"$f":"RvB_d","v":6.4399999999999999E-2},{"$f":"RvC_d","v":6.4399999999999999E-2},{"$f":"RvD_d","v":6.4399999999999999E-2}]
["Depression Storage, Sd (in.)",{"$f":"SdA_d","v":0.21809999999999999},{"$f":"SdB_d","v":0.21809999999999999},{"$f":"SdC_d","v":0.21809999999999999},{"$f":"SdD_d","v":0.21809999999999999},null,{"$f":"SdA_d","v":0.21809999999999999},{"$f":"SdB_d","v":0.21809999999999999},{"$f":"SdC_d","v":0.21809999999999999},{"$f":"SdD_d","v":0.21809999999999999}]
[]
["SCM 1 (First in Series) Type",{"$f":"'1. ENTER DATA'!E26","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!F26","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!G26","v":"Retention Basin"},{"$f":"'1. ENTER DATA'!H26","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'!C93","v":0.5},{"$f":"'3. CALCS_Loads'!D93","v":0.5},{"$f":"'3. CALCS_Loads'!E93","v":0.5},{"$f":"'3. CALCS_Loads'!F93","v":0.5}]
["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'!E33*0.00221/'5.CALCS_Adams&Papa'!B20","v":3.3326800000000004E-2},{"$f":"'1. ENTER DATA'!F33*0.00221/'5.CALCS_Adams&Papa'!C20","v":3.3326800000000004E-2},{"$f":"'1. ENTER DATA'!G33*0.00221/'5.CALCS_Adams&Papa'!D20","v":3.3326800000000004E-2},{"$f":"'1. ENTER DATA'!H33*0.00221/'5.CALCS_Adams&Papa'!E20","v":3.3326800000000004E-2}]
["Design Treatment Rate ",{"$f":"IF('1. ENTER DATA'!E31=\"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'!F31=\"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'!G31=\"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'!H31=\"Flow Rate\",'5.CALCS_Adams&Papa'!E27,'5.CALCS_Adams&Papa'!E25/'5.CALCS_Adams&Papa'!E26)","v":4.1666666666666664E-2}]
["Lag time before irrigation (hr)",{"$f":"'1. ENTER DATA'!E42","v":12},{"$f":"'1. ENTER DATA'!F42","v":12},{"$f":"'1. ENTER DATA'!G42","v":12},{"$f":"'1. ENTER DATA'!H42","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,B29/B25,0))^(-1)","v":3.4722222222222224E-2},{"$f":"(1/C28+IF(C25<>0,C29/C25,0))^(-1)","v":3.4722222222222224E-2},3.4722222222222224E-2,3.4722222222222224E-2,"*Includes lag time",{"$f":"G25/G29","v":1.0416666666666666E-2},{"$f":"H25/H29","v":1.0416666666666666E-2},{"$f":"I25/I29","v":1.0416666666666666E-2},{"$f":"J25/J29","v":1.0416666666666666E-2}]
[]
["AVERAGE ANNUAL RUNOFF CAPTURE ANALYSIS"]
["Avg. Annual Number of Runoff Events Eqn. 7.9",{"$f":"THETA*EXP(-ZETA*B22)","v":45.985769926556991},{"$f":"THETA*EXP(-ZETA*C22)","v":45.985769926556991},{"$f":"THETA*EXP(-ZETA*D22)","v":45.985769926556991},{"$f":"THETA*EXP(-ZETA*E22)","v":45.985769926556991},null,{"$f":"THETA*EXP(-ZETA*G22)","v":45.985769926556991},{"$f":"THETA*EXP(-ZETA*H22)","v":45.985769926556991},{"$f":"THETA*EXP(-ZETA*I22)","v":45.985769926556991},{"$f":"THETA*EXP(-ZETA*J22)","v":45.985769926556991}]
["Avg. Runoff Volume per event (in.)",{"$f":"$C$13/THETA*B21","v":2.5758376402369845E-2},{"$f":"$C$13/THETA*C21","v":2.5758376402369845E-2},{"$f":"$C$13/THETA*D21","v":2.5758376402369845E-2},{"$f":"$C$13/THETA*E21","v":2.5758376402369845E-2},null,{"$f":"$C$13/THETA*G21","v":2.5758376402369845E-2},{"$f":"$C$13/THETA*H21","v":2.5758376402369845E-2},{"$f":"$C$13/THETA*I21","v":2.5758376402369845E-2},{"$f":"$C$13/THETA*J21","v":2.5758376402369845E-2}]
["R Average Annual Runoff Volume (in.)",{"$f":"B33*B34","v":1.1845187709210345},{"$f":"C33*C34","v":1.1845187709210345},{"$f":"D33*D34","v":1.1845187709210345},{"$f":"E33*E34","v":1.1845187709210345},null,{"$f":"G33*G34","v":1.1845187709210345},{"$f":"H33*H34","v":1.1845187709210345},1.1845187709210345,{"$f":"J33*J34","v":1.1845187709210345}]
["Probability of Spill Occurring (GP) Eqn. 8.4a",{"$f":"LAMBDA/B$30/(LAMBDA/B$30+ZETA/B$21)*(PSI/B$30+ZETA/B$21*EXP(-(PSI/B$30+ZETA/B$21)*B$25))/(PSI/B$30+ZETA/B$21)*EXP(-ZETA*B$22)","v":4.6937591924310618E-4},{"$f":"LAMBDA/C$30/(LAMBDA/C$30+ZETA/C$21)*(PSI/C$30+ZETA/C$21*EXP(-(PSI/C$30+ZETA/C$21)*C$25))/(PSI/C$30+ZETA/C$21)*EXP(-ZETA*C$22)","v":4.6937591924310618E-4},{"$f":"LAMBDA/D$30/(LAMBDA/D$30+ZETA/D$21)*(PSI/D$30+ZETA/D$21*EXP(-(PSI/D$30+ZETA/D$21)*D$25))/(PSI/D$30+ZETA/D$21)*EXP(-ZETA*D$22)","v":4.6937591924310618E-4},{"$f":"LAMBDA/E$30/(LAMBDA/E$30+ZETA/E$21)*(PSI/E$30+ZETA/E$21*EXP(-(PSI/E$30+ZETA/E$21)*E$25))/(PSI/E$30+ZETA/E$21)*EXP(-ZETA*E$22)","v":4.6937591924310618E-4},null,{"$f":"IF(G30=0,1,G29/(G29+t*G25/(v*G21))*(G29/(b*G25)+1/(v*G21)*EXP(-(G29/(b*G25)+1/(v*G21))*G25))/(G29/(b*G25)+1/(v*G21))*EXP(-G22/v))","v":4.0528790637700124E-3},{"$f":"IF(H30=0,1,H29/(H29+t*H25/(v*H21))*(H29/(b*H25)+1/(v*H21)*EXP(-(H29/(b*H25)+1/(v*H21))*H25))/(H29/(b*H25)+1/(v*H21))*EXP(-H22/v))","v":4.0528790637700124E-3},{"$f":"IF(I30=0,1,I29/(I29+t*I25/(v*I21))*(I29/(b*I25)+1/(v*I21)*EXP(-(I29/(b*I25)+1/(v*I21))*I25))/(I29/(b*I25)+1/(v*I21))*EXP(-I22/v))","v":4.0528790637700124E-3},{"$f":"IF(J30=0,1,J29/(J29+t*J25/(v*J21))*(J29/(b*J25)+1/(v*J21)*EXP(-(J29/(b*J25)+1/(v*J21))*J25))/(J29/(b*J25)+1/(v*J21))*EXP(-J22/v))","v":4.0528790637700124E-3}]
["Average Annual Runoff Capture Efficiency RCE (%)",{"$f":"IF(AND(B25=0,'1. ENTER DATA'!E31=\"Drawdown Time\"),0,IF(B28=0,0,1-B36))","v":0.99953062408075688},{"$f":"IF(AND(C25=0,'1. ENTER DATA'!F31=\"Drawdown Time\"),0,IF(C28=0,0,1-C36))","v":0.99953062408075688},{"$f":"IF(AND(D25=0,'1. ENTER DATA'!G31=\"Drawdown Time\"),0,IF(D28=0,0,1-D36))","v":0.99953062408075688},{"$f":"IF(AND(E25=0,'1. ENTER DATA'!H31=\"Drawdown Time\"),0,IF(E28=0,0,1-E36))","v":0.99953062408075688},null,{"$f":"1-G36","v":0.99594712093622995},{"$f":"1-H36","v":0.99594712093622995},{"$f":"1-I36","v":0.99594712093622995},{"$f":"1-J36","v":0.99594712093622995}]
["Avg. Annual Runoff Volume Treated RC (in/yr)",{"$f":"B$35*B37","v":1.1839627863340727},{"$f":"C$35*C37","v":1.1839627863340727},1.1839627863340727,1.1839627863340727,null,{"$f":"G35*G37","v":1.179718059593726},{"$f":"H35*H37","v":1.179718059593726},{"$f":"I35*I37","v":1.179718059593726},{"$f":"J35*J37","v":1.179718059593726}]
["Volume treated (Acre-in/yr)",{"$f":"B38*B20","v":1.1839627863340727},{"$f":"C38*C20","v":1.1839627863340727},{"$f":"D38*D20","v":1.1839627863340727},{"$f":"E38*E20","v":1.1839627863340727},null,{"$f":"G38*G20","v":1.179718059593726},{"$f":"H38*H20","v":1.179718059593726},{"$f":"I38*I20","v":1.179718059593726},{"$f":"J38*J20","v":1.179718059593726}]
["Bypass Volume (Acre-in/yr)",{"$f":"B35*B36*B20","v":5.559845869617749E-4},{"$f":"C35*C36*C20","v":5.559845869617749E-4},{"$f":"D35*D36*D20","v":5.559845869617749E-4},{"$f":"E35*E36*E20","v":5.559845869617749E-4},null,{"$f":"G35*G36*G20","v":4.8007113273084486E-3},{"$f":"H35*H36*H20","v":4.8007113273084486E-3},{"$f":"I35*I36*I20","v":4.8007113273084486E-3},{"$f":"J35*J36*J20","v":4.8007113273084486E-3}]
[]
["SCM 2 (Second in Series) ROUTING"]
["SCM 2 Type",{"$f":"'1. ENTER DATA'!E45","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!F45","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!G45","v":"Infiltration Field"},{"$f":"'1. ENTER DATA'!H45","v":"Infiltration Field"}]
["Water Quality Volume (in.) Routed",{"$f":"'3. CALCS_Loads'!C150","v":2.5},{"$f":"'3. CALCS_Loads'!D150","v":0},{"$f":"'3. CALCS_Loads'!E150","v":0},{"$f":"'3. CALCS_Loads'!F150","v":0}]
["Adjusted  Treatment Rate, Ω (in/hr)",{"$f":"B30","v":3.4722222222222224E-2},{"$f":"C30","v":3.4722222222222224E-2},{"$f":"D30","v":3.4722222222222224E-2},{"$f":"E30","v":3.4722222222222224E-2}]
[]
["AVERAGE ANNUAL RUNOFF CAPTURE ANALYSIS"]
["Probability of Spill Occurring (GP) Eqn. 8.4a",{"$f":"LAMBDA/B$45/(LAMBDA/B$45+ZETA/B$21)*(PSI/B$45+ZETA/B$21*EXP(-(PSI/B$45+ZETA/B$21)*B$44))/(PSI/B$45+ZETA/B$21)*EXP(-ZETA*B$22)","v":4.6937591924310618E-4},{"$f":"LAMBDA/C$45/(LAMBDA/C$45+ZETA/C$21)*(PSI/C$45+ZETA/C$21*EXP(-(PSI/C$45+ZETA/C$21)*C$44))/(PSI/C$45+ZETA/C$21)*EXP(-ZETA*C$22)","v":6.6037888240971163E-2},{"$f":"LAMBDA/D$45/(LAMBDA/D$45+ZETA/D$21)*(PSI/D$45+ZETA/D$21*EXP(-(PSI/D$45+ZETA/D$21)*D$44))/(PSI/D$45+ZETA/D$21)*EXP(-ZETA*D$22)","v":6.6037888240971163E-2},{"$f":"LAMBDA/E$45/(LAMBDA/E$45+ZETA/E$21)*(PSI/E$45+ZETA/E$21*EXP(-(PSI/E$45+ZETA/E$21)*E$44))/(PSI/E$45+ZETA/E$21)*EXP(-ZETA*E$22)","v":6.6037888240971163E-2}]
["Average Annual Runoff Capture Efficiency RCE (%)",{"$f":"IF(B44=0,0,IF(B28=0,0,1-B48))","v":0.99953062408075688},{"$f":"IF(C44=0,0,IF(C28=0,0,1-C48))","v":0},0,0]
["Avg. Annual Runoff Volume Captured RC (in/yr)",{"$f":"B$35*B49","v":1.1839627863340727},{"$f":"C$35*C49","v":0},0,0]
["Avg. Annual Volume Captured (Acre-in/yr)",{"$f":"B50*B20","v":1.1839627863340727},{"$f":"C50*C20","v":0},{"$f":"D50*D20","v":0},{"$f":"E50*E20","v":0}]
[]
["SCM 2 Infiltration or Reuse"]
["Infiltrated water quality volume (in)",{"$f":"'4. CALCS_Infiltration'!E21","v":2.5},{"$f":"'4. CALCS_Infiltration'!F21","v":0},{"$f":"'4. CALCS_Infiltration'!G21","v":0},{"$f":"'4. CALCS_Infiltration'!H21","v":0}]
["Adjusted  Treatment Rate, Ω (in/hr)",{"$f":"B45","v":3.4722222222222224E-2},{"$f":"C45","v":3.4722222222222224E-2},{"$f":"D45","v":3.4722222222222224E-2},{"$f":"E45","v":3.4722222222222224E-2}]
[]
["AVERAGE ANNUAL RUNOFF CAPTURE ANALYSIS"]
["Probability of Spill Occurring (GP) Eqn. 8.4a",{"$f":"LAMBDA/B$55/(LAMBDA/B$55+ZETA/B$21)*(PSI/B$55+ZETA/B$21*EXP(-(PSI/B$55+ZETA/B$21)*B$54))/(PSI/B$55+ZETA/B$21)*EXP(-ZETA*B$22)","v":4.6937591924310618E-4},{"$f":"LAMBDA/C$55/(LAMBDA/C$55+ZETA/C$21)*(PSI/C$55+ZETA/C$21*EXP(-(PSI/C$55+ZETA/C$21)*C$54))/(PSI/C$55+ZETA/C$21)*EXP(-ZETA*C$22)","v":6.6037888240971163E-2},{"$f":"LAMBDA/D$55/(LAMBDA/D$55+ZETA/D$21)*(PSI/D$55+ZETA/D$21*EXP(-(PSI/D$55+ZETA/D$21)*D$54))/(PSI/D$55+ZETA/D$21)*EXP(-ZETA*D$22)","v":6.6037888240971163E-2},{"$f":"LAMBDA/E$55/(LAMBDA/E$55+ZETA/E$21)*(PSI/E$55+ZETA/E$21*EXP(-(PSI/E$55+ZETA/E$21)*E$54))/(PSI/E$55+ZETA/E$21)*EXP(-ZETA*E$22)","v":6.6037888240971163E-2}]
["Average Annual Runoff Capture Efficiency RCE (%)",{"$f":"IF(B54=0,0,IF(B28=0,0,1-B58))","v":0.99953062408075688},{"$f":"IF(C54=0,0,IF(C28=0,0,1-C58))","v":0},0,0]
["Avg. Annual Runoff Volume Captured RC (in/yr)",{"$f":"B$35*B59","v":1.1839627863340727},{"$f":"C$35*C59","v":0},{"$f":"D$35*D59","v":0},{"$f":"E$35*E59","v":0}]
["Avg. Annual Volume Captured (Acre-in/yr)",{"$f":"B60*B34","v":3.0496959096791631E-2},{"$f":"C60*C34","v":0},{"$f":"D60*D34","v":0},{"$f":"E60*E34","v":0}]