{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions_First Time Use","Instructions","Reference Tables","DSV_App F Table 3-5 ","Performance Curve Example","Updates","Tables (hidden_locked)","Calcs (hidden_locked)","Input_Design_Output","Output_Summary"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":141,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions_First Time Use","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Instructions for First Time Use"]
[]
["This workbook uses macros which need to be enabled for the first use only."]
[]
["By default, when you first open a macro-enabled workbook you’ll see a yellow “SECURITY WARNING” bar appear just underneath the ribbon.  Clicking the “Enable Content” button will enable macros."]

{"sheet":"Instructions","index":1,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Background"]
["This calculator provides estimates of long-term cumulative reduction credits for a variety of structural stormwater control measures (SCMs) based on design capacity relative to contributing impervious cover (IC) drainage area.  For structural SCMs, the design capacity is referred to as the Design Storage Volume (DSV) and is equal to the physical storage capacity of the SCM to hold water (e.g., ponding and void space volume).  The calculator also provides cumulative performance reduction estimates for semi-structural SCMs that accomplish diversion of IC runoff to receiving pervious areas (i.e., IC disconnection) based on the ratio of IC source area to receiving pervious area according to hydrologic soil group (HSG) type (e.g., 2:1, HSG A, B, C or D)).  The cumulative performance estimates represent the net reductions that would be accomplished if IC runoff from all storm events for long-term rainfall record (e.g., 20 years) were to be routed through the selected SCM.  The calculator includes average annual reduction estimates for total phosphorus, total nitrogen, total suspended solids, zinc, freshwater and marine water indicator bacteria, and runoff volume (only for infiltration SCMs).  The reduction estimates provided by this calculator are consistent with the methodologies used to develop the reduction estimates presented in Attachment 3 to Appendix F of the MA and NH MS4 permits (https://www3.epa.gov/region1/npdes/stormwater/nh/2017-appendix-f-attach-3-sms4-nh-mod.pdf).\n\nThis performance calculator uses the same values and performance data as presented in the MA and NH Small MS4 General Permit from EPA Region 1.  The land uses have been consolidated into 4 types consistent with the most representative categories in development scenarios.  The Stormwater Control Measures (SCM) or BMPs use the 10 classification categories outlined in the permit and infiltration rates by soil type range from 0.17 in/hr (HSG D soils) to 8.27 in/hr (HSG A soils).  As with simplified approaches, choose the most conservative category that generally represents site and system conditions."]
["\nObjective"]
["This calculator was designed to aid in SCM selection, design, and planning level performance assessment.  The performance objectives can be optimized by estimated pollutant load reduction, runoff volume reduction, cost, or other related outcomes.  Because this is primarily a design tool and not a tool for crediting, the mimimum depth of 0.1 inch is required for the Physical Storage Capacity (depth of runoff treated). While a PSC ≤ 0.1 inch will get credit using the BATT (an EPA approved crediting tool), a PSC of at least 0.1 inch should be targeted for design. To optimize cost/% treatment, the DSV should be optimized to treat a PSC of about 0.4 inch. This optimized point may be seen as the knee on the performance curves."]
["\nA note on drainage area delineation"]
["To simplify the estimates and aid in design, only impervious area (IA) is evaluated.  The x-axis on the performance curves is the depth of runoff treated over the IA. This runoff depth multiplied by the impervious area gives volume of water to be stored in the SCM void space, named the Design Storage Volume (DSV)."]
["\nA note of system selection"]
["Model your system according to the classification that best suits your treatment.  There are crosswalks available to help reference model system select.  Biofiltration assumes no infiltration thus if you want to model performance of bioretention where infiltration is enhanced or anticipated then you should model the system as an infiltration basin as that will more accurately account for volume losses to infiltration.  The DSV may require design assumptions for the porosity of various types of media.  We recommend using a porosity of 0.2 for soil media, 0.3 for sand or peastone, and 0.4 for large diameter reservoir stone."]
["\nCalculator Instructions"]
["For information on the reference tables used in the calculator, see the worksheet titled \"Reference Tables.\""]
["For information on the how DSV is calculated per Appendix F, Table 3.5, see the worksheet titled \"DSV_App F Table 3-5.\""]
["For a walk-through example of what the performance curves are and how to calculate reductions by hand, see the worksheet titled \"Performance Curve Example.\""]
["For any input for site information, SCM design, and performance output, use the worksheet titled \"Input_Design_Output.\""]
["For a summary of the output, see the worksheet titled \"Output_Summary.\""]
[]
["The Input_Design_Output worksheet was designed to scroll down the page and enter information. It is divided into three general sections from top to bottom - \n1) Input: Site & SCM - General location and site details including the selected SCM\n2) Input: SCM Design - Design parameters for the selected SCM. Note that this section has all cells unlocked for number entries, formulas, and Goal Seek to aid in the design and sizing process. All orange cells are required and used in the calculations; if left blank, they are calculated as 0.\n3) Output - All calculations and output are in this section. The intermediate calculations such as DSV and PSC are shown. Using those values and site/SCM input, the following are calculated and reported: load reductions, pollutant load export rates, annual removal, and costs estimates, and estimated annual O&M hours. "]
["\nCell Legend"]
["Black/White = non-essential cells for notes or non-editable cells (output)"]
["Orange = REQUIRED input for caculation"]
["Grey = explanatory text"]
["Yellow = Optional known DSV to get output while skipping the design section"]
[]
["\nGet Started!"]
["An example bioretention (same as the Performance Curve Example example) has been entered in the Input_Design_Output worksheet. Note that the output from the example is also in the Output_Summary worksheet. As you replace the example SCM1 with your own input information, the Output_Summary will automatically update!"]

{"sheet":"Reference Tables","index":2,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,2],[17,4,17,7],[18,4,18,7],[19,4,19,7],[20,4,20,7],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[32,1,32,2],[21,1,21,3],[23,1,23,7],[25,3,25,5],[25,6,25,7],[21,4,21,7]]}
["Reference Tables"]
[null,"Crosswalk 1",null,"Costs","O&M"]
[null,"SCM 2","Applicable Performance Curve 3","Total Costs (2020) ($/cf DSV) 4","Annual Maintenance Hours (hr/ac/yr) 5"]
[null,{"$f":"'Tables (hidden_locked)'!P3","v":"Biofiltration   (w/ underdrain)"},{"$f":"'Tables (hidden_locked)'!Q3","v":"Biofiltration"},{"$f":"'Tables (hidden_locked)'!R3","v":15.870222769869997},{"$f":"'Tables (hidden_locked)'!S3","v":20.7}]
[null,{"$f":"'Tables (hidden_locked)'!P4","v":"Bioretention/Rain Garden  (no underdrains)"},{"$f":"'Tables (hidden_locked)'!Q4","v":"Infiltration Basin"},{"$f":"'Tables (hidden_locked)'!R4","v":15.870222769869997},{"$f":"'Tables (hidden_locked)'!S4","v":20.7}]
[null,{"$f":"'Tables (hidden_locked)'!P5","v":"Enhanced Biofiltration w/ Internal Storage Reservoir (ISR)  (no infiltration)"},{"$f":"'Tables (hidden_locked)'!Q5","v":"Enhanced Biofiltration With ISR"},{"$f":"'Tables (hidden_locked)'!R5","v":16.0245330885},{"$f":"'Tables (hidden_locked)'!S5","v":20.7}]
[null,{"$f":"'Tables (hidden_locked)'!P6","v":"Extended Dry Detention Basin"},{"$f":"'Tables (hidden_locked)'!Q6","v":"Dry Pond"},{"$f":"'Tables (hidden_locked)'!R6","v":6.9795744118799989},{"$f":"'Tables (hidden_locked)'!S6","v":24}]
[null,{"$f":"'Tables (hidden_locked)'!P7","v":"Gravel Wetland"},{"$f":"'Tables (hidden_locked)'!Q7","v":"Subsurface Gravel Wetland"},{"$f":"'Tables (hidden_locked)'!R7","v":9.0093486030899985},{"$f":"'Tables (hidden_locked)'!S7","v":21.7}]
[null,{"$f":"'Tables (hidden_locked)'!P8","v":"IC Disconnection"},{"$f":"'Tables (hidden_locked)'!Q8","v":"IC Disconnection"},{"$f":"'Tables (hidden_locked)'!R8","v":"Varies"},{"$f":"'Tables (hidden_locked)'!S8","v":"Varies"}]
[null,{"$f":"'Tables (hidden_locked)'!P9","v":"Infiltration Trench"},{"$f":"'Tables (hidden_locked)'!Q9","v":"Infiltration Trench"},{"$f":"'Tables (hidden_locked)'!R9","v":12.819626470799999},{"$f":"'Tables (hidden_locked)'!S9","v":"Unknown"}]
[null,{"$f":"'Tables (hidden_locked)'!P10","v":"Porous Pavement w/ impermeable underliner & underdrain "},{"$f":"'Tables (hidden_locked)'!Q10","v":"Porous Pavement"},{"$f":"'Tables (hidden_locked)'!R10","v":5.4602112745999989},{"$f":"'Tables (hidden_locked)'!S10","v":6}]
[null,{"$f":"'Tables (hidden_locked)'!P11","v":"Porous Pavement w/ subsurface infiltration"},{"$f":"'Tables (hidden_locked)'!Q11","v":"Infiltration Trench"},{"$f":"'Tables (hidden_locked)'!R11","v":5.4602112745999989},{"$f":"'Tables (hidden_locked)'!S11","v":6}]
[null,{"$f":"'Tables (hidden_locked)'!P12","v":"Sand Filter w/ underdrain"},{"$f":"'Tables (hidden_locked)'!Q12","v":"Sand Filter"},{"$f":"'Tables (hidden_locked)'!R12","v":18.410408015009999},{"$f":"'Tables (hidden_locked)'!S12","v":28.5}]
[null,{"$f":"'Tables (hidden_locked)'!P13","v":"Subsurface Infiltration  "},{"$f":"'Tables (hidden_locked)'!Q13","v":"Infiltration Trench"},{"$f":"'Tables (hidden_locked)'!R13","v":"Varies"},{"$f":"'Tables (hidden_locked)'!S13","v":"Varies"}]
[null,{"$f":"'Tables (hidden_locked)'!P14","v":"Surface Infiltration Practice"},{"$f":"'Tables (hidden_locked)'!Q14","v":"Infiltration Basin"},{"$f":"'Tables (hidden_locked)'!R14","v":6.4098132353999997},{"$f":"'Tables (hidden_locked)'!S14","v":20.7}]
[null,{"$f":"'Tables (hidden_locked)'!P15","v":"Water Quality Grass  Swale w/ Detention"},{"$f":"'Tables (hidden_locked)'!Q15","v":"Grass Swale"},{"$f":"'Tables (hidden_locked)'!R15","v":5.7094817893099989},{"$f":"'Tables (hidden_locked)'!S15","v":9.5}]
[null,{"$f":"'Tables (hidden_locked)'!P16","v":"Wet Pond"},{"$f":"'Tables (hidden_locked)'!Q16","v":"Wet Pond"},{"$f":"'Tables (hidden_locked)'!R16","v":6.9795744118799989},{"$f":"'Tables (hidden_locked)'!S16","v":28}]
[1,"For a more comprehensive crosswalk between MA and NH manuals and Appendix F, click the link to the right.",null,null,"UNHSC Crosswalk"]
[2,"Stormwater Control Measure type as described by Appendix F, click the link to the right.",null,null,"NH Small MS4 General Permit, Appendix F - Attachment 3, EPA Region 1 - 2017"]
[3,"See Appendix F and UNHSC Nomographs for Performance Curves, click the link to the right.",null,null,"UNHSC Nomographs - 2020"]
[4,"Total SCM costs with a multiplier of 1 for undeveloped areas, updated to 2020 dollars, click the link to the right.",null,null,"EPA Cost Memo - 2016"]
[5,"Total yearly maintenance hours per acre IC",null,null,"EPA Cost Memo - 2016"]
[]
[null,"Export Rates"]
[null,null,{"$f":"'Tables (hidden_locked)'!V2","v":"Vol"},{"$f":"'Tables (hidden_locked)'!W2","v":"P"},{"$f":"'Tables (hidden_locked)'!X2","v":"N"},{"$f":"'Tables (hidden_locked)'!Y2","v":"TSS"},{"$f":"'Tables (hidden_locked)'!Z2","v":"E. coli"},{"$f":"'Tables (hidden_locked)'!AA2","v":"Enterococcus"}]
[null,{"$f":"'Tables (hidden_locked)'!U3","v":"Land Use"},{"$f":"'Tables (hidden_locked)'!V3","v":"(cf/ac-yr)"},{"$f":"'Tables (hidden_locked)'!W3","v":"(lb/ac-yr)"},{"$f":"'Tables (hidden_locked)'!X3","v":0},{"$f":"'Tables (hidden_locked)'!Y3","v":0},{"$f":"'Tables (hidden_locked)'!Z3","v":"(Billion MPN/ac/yr)"},{"$f":"'Tables (hidden_locked)'!AA3","v":0}]
[null,{"$f":"'Tables (hidden_locked)'!U4","v":"Low-Density Residential \"Rural\""},{"$f":"'Tables (hidden_locked)'!V4","v":139984.416},{"$f":"'Tables (hidden_locked)'!W4","v":1.52},{"$f":"'Tables (hidden_locked)'!X4","v":14.1},{"$f":"'Tables (hidden_locked)'!Y4","v":439},{"$f":"'Tables (hidden_locked)'!Z4","v":6.4},{"$f":"'Tables (hidden_locked)'!AA4","v":497}]
[null,{"$f":"'Tables (hidden_locked)'!U5","v":"Medium-Density Residential"},{"$f":"'Tables (hidden_locked)'!V5","v":139984.416},{"$f":"'Tables (hidden_locked)'!W5","v":1.96},{"$f":"'Tables (hidden_locked)'!X5","v":14.1},{"$f":"'Tables (hidden_locked)'!Y5","v":439},{"$f":"'Tables (hidden_locked)'!Z5","v":6.4},{"$f":"'Tables (hidden_locked)'!AA5","v":497}]
[null,{"$f":"'Tables (hidden_locked)'!U6","v":"Multi-Family and High-Density Residential"},{"$f":"'Tables (hidden_locked)'!V6","v":139984.416},{"$f":"'Tables (hidden_locked)'!W6","v":2.3199999999999998},{"$f":"'Tables (hidden_locked)'!X6","v":14.1},{"$f":"'Tables (hidden_locked)'!Y6","v":439},{"$f":"'Tables (hidden_locked)'!Z6","v":6.4},{"$f":"'Tables (hidden_locked)'!AA6","v":497}]
[null,{"$f":"'Tables (hidden_locked)'!U7","v":"Commercial and Industrial"},{"$f":"'Tables (hidden_locked)'!V7","v":139984.416},{"$f":"'Tables (hidden_locked)'!W7","v":1.78},{"$f":"'Tables (hidden_locked)'!X7","v":15},{"$f":"'Tables (hidden_locked)'!Y7","v":377.4},{"$f":"'Tables (hidden_locked)'!Z7","v":6.4},{"$f":"'Tables (hidden_locked)'!AA7","v":497}]
[]
[]
[null,"Cost Multiplier6"]
[null,"Location","Example Cost Multiplier"]
[null,"New SCM in undeveloped area",1]
[null,"New SCM in partially developed area",1.5]
[null,"New SCM in developed area",2]
[null,"Difficult installation in highly urban settings",3]
[6,"Cost Adjustment Factors from Table 2","EPA Cost Memo - 2016"]

{"sheet":"DSV_App F Table 3-5 ","index":3,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,1,21,3],[20,1,20,3],[19,0,19,3],[0,0,0,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[18,0,18,3]]}
["Method for determining stormwater control design storage volume (DSV) (i.e., capacity) using Long-term cumulative performance curves1"]
["Stormwater Control Type","Description","Applicable Structural Stormwater Control Performance Curve ","Method for calculating Design Storage Capacity to Estimate Long-term Cumulative Reduction Performances  and Estimate Costs "]
["Infiltration Trench","Provides temporary storage of runoff using the void spaces within the soil/sand/gravel mixture that is used to backfill the trench for subsequent infiltration into the surrounding sub-soils. ","Infiltration Trench (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = void space volumes of stone and sand layers                      DSV = (Atrench x Dstone x nstone )+ (Atrench x Dsand x nsand)"]
["Surface Infiltration Practice  ","Provides temporary storage of runoff through surface ponding (e.g., basin or swale) for subsequent infiltration into the underlying soils. ","Surface Infiltration (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = Water volume of storage structure before bypass. Example for linear trapezoidal vegetated swale  \nDSV = (L x ((Wbottom+Wtop@Dmax )/2) x D)"]
["Bio-retention/Rain Garden  (no underdrains)","Provides temporary storage of runoff through surface ponding and possibly void spaces within the soil/sand/washed stone mixture that is used to filter runoff prior to infiltration into underlying soils.","Surface Infiltration (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = Ponding water storage volume and void space volumes of soil filter media:                                                                                            DSV = (Apond x Dpond) + (Asoil x Dsoil x nsoil mix) "]
["Subsurface Infiltration  ","Provides temporary storage of runoff using the combination of storage structures (e.g., galleys, chambers, pipes, etc.) and void spaces within the washed stone that is used to backfill the system for subsequent infiltration into the surrounding sub-soils. ","Infiltration Trench (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = Water storage volume of storage units and void space volumes of backfill materials. Example for subsurface galleys backfilled with washed stone:                                                               DSV = (L x W x D)galley + (Abackfill x Dstone x nstone) "]
["Bio-filtration   (w/underdrain)","Provides temporary surface ponding storage of runoff for filtering through an engineered soil media. The storage capacity includes void spaces in the filter media and temporary ponding at the surface.  After runoff has passed through the filter media it is collected by an under-drain pipe for discharge. Manufactured or packaged bio-filter systems such as tree box filters may be suitable for using the bio-filtration performance results. ","Bio-filtration ","DSV = Ponding water storage volume and void space volume of soil filter media.                                                                                              DSV =  (Abed x Dponding)+ (Abed x Dsoil x nsoil)  "]
["Enhanced Bio-filtration w/ Internal Storage Reservoir (ISR)  (no infiltration)","Provides temporary storage of runoff for filtering through an engineered soil media, augmented for enhanced phosphorus removal, followed by detention and denitrification in a subsurface internal storage reservoir (ISR) comprised of gravel.   An elevated outlet control at the top of the ISR is designed to provide a retention time of at least 24 hours in the system to allow for sufficient time for denitrification and nitrogen reduction to occur prior to discharge.  The design storage capacity for using the cumulative performance curves is comprised of void spaces in the filter media, temporary ponding at the surface of the practice and the void spaces in the gravel ISR.","Enhanced Bio-filtration w/ISR","DSV = Ponding water storage volume and void space volume of soil filter media and gravel ISR.                                                              DSV =  (Abed x Dponding)+ (Abed x Dsoil x nsoil) + (AISR x Dgravel  x ngravel) "]
["Gravel Wetland","Based on design by the UNH Stormwater Center (UNHSC).  Provides temporary surface ponding storage of runoff in a vegetated wetland cell that is eventually routed to an underlying saturated gravel internal storage reservoir (ISR) for nitrogen treatment.  Outflow is controlled by an elevated orifice that has its invert elevation equal to the top of the ISR layer and provides a retention time of at least 24 hours.","Gravel Wetland ","DSV = pretreatment volume + ponding volume + void space volume of gravel ISR.                                                                                  DSV = (A pretreatment x DpreTreatment)+ (A wetland x Dponding)                            + (AISR x Dgravel  x ngravel)  "]
["Porous Pavement with subsurface infiltration","Provides filtering of runoff through a filter course and temporary storage of runoff within the void spaces of a subsurface gravel reservoir prior to infiltration into subsoils.  ","Infiltration Trench (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = void space volumes of gravel layer                                          DSV = (Apavement x Dstone x nstone )"]
["Porous pavement w/ impermeable underliner w/underdrain ","Provides filtering of runoff through a filter course and temporary storage of runoff within the void spaces prior to discharge by way of an underdrain.","Porous Pavement","Depth of Filter Course = D FC"]
["Sand Filter w/underdrain","Provides filtering of runoff through a sand filter course and temporary storage of runoff through surface ponding and within void spaces of the sand and washed stone layers prior to discharge by way of an underdrain.","Sand Filter ","DSV = pretreatment volume + ponding volume + void space volume of sand and washed stone layers.                                                   DSV = (A pretreatment x DpreTreatment)+ (A bed x Dponding) \n+ (Abed x Dsand  x nsand) + (Abed x Dstone  x nstone)"]
["Wet  Pond","Provides treatment of runoff through routing through permanent pool.","Wet Pond ","DSV= Permanent pool volume prior to high flow bypass   DSV=Apond x Dpond   (does not include pretreatment volume)"]
["Extended Dry Detention Basin","Provides temporary detention storage for the design storage volume to drain in 24 hours through multiple out let controls.   ","Dry Pond","DSV= Ponding volume prior to high flow bypass   \nDSV=Apond x Dpond   (does not include pretreatment volume)"]
["Water Quality Grass  Swale w/ Detention","Conveys runoff through an open channel vegetated with grass with temporary storage provided by permeable check dams.  Primary removal mechanism is settling during temporary storage.","Water Quality Grass  Swale w/ Detention","2 DSV = Volume of swale at full depth of temporary storage:      DSV = (L x ((Wbottom+Wtop@Dmax )/2) x D)"]
["Footnotes:"]
["DSV= Design Storage Volume = physical storage capacity to hold water"]
["VSV=Void Space Volume"]
["L= length, W= width, D= depth at design capacity before bypass, n=porosity fill material, A= average surface area for calculating volume"]
["Infiltration rate = saturated soil hydraulic conductivity"]
[1,"NH Small MS4 General Permit, Appendix F - Attachment 3, EPA Region 1 - 2017"]
[2,"Note the corrected DSV calculation using the same equation as the Surface Infiltration Practice. \nThe published DSV calculation incorrectly added a dimension LxAxD=ft4. It could also be calculated as DSV = Lswale x AX-sect. swale"]

{"sheet":"Performance Curve Example","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Updates","index":5,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Version","Updates","Known issues to fix"]
[2,"major updates from v1, most important was removal of P and examples of design and credit calculation using performance curve","Input: Applicable Performance Curve for SCM2 - 5 not updating when new SCM selected"]
[2.1,"Input: Applicable Performance Curve for SCM2 - 5 update fix"]
[2.2000000000000002,"PSC=0 added to all tables for full interpolation. Warning language added based on PSC size to encourage mimimum and optimal sizing, orange input cell for surface basin and swale changed from W to Dponding. Added note to EPA DSV table for swale error"]

{"sheet":"Tables (hidden_locked)","index":6,"n_rows":412,"n_cols":51,"rows_kept":412,"cut":false,"hidden":true,"merged":[[0,0,4,0],[0,20,0,27],[0,35,0,50],[0,2,0,12],[0,15,0,16],[2,25,2,26],[2,22,2,24]]}
["*** All tables are saved as a defined name for use and quick updating in formulas. If the Name Manager values are correct and updated, all formulas should update immediately.",null,"Performance Curves",null,null,null,null,null,null,null,null,null,null,null,null,"Crosswalk",null,"Costs","O&M Hours",null,"Export Rates",null,null,null,null,null,null,null,null,"Bacteria Locations",null,"HSG","as numeric",null,null,"SCM Design Parameters (for conditional formatting)"]
[null,null,null,null,"Infiltration Rate (in/hr)","BMP Capacity: Depth of Runoff  from Impervious Area (inches)","Runoff Volume Reduction","Phosphorus Load Reduction"," Nitrogen Load Reduction","TSS Load Reduction","Zinc Load Reduction","Fecal Indicator Bacteria Load Reduction",null,null,null,"SCM","Applicable Performance Curve ","Total Costs (Rural x1) ($/DSV)","Annual Maintenance Hours (hr/yr/IC)",null,null,"Vol","P","N","TSS","E. coli","Enterococcus","Abbreviation",null,"Inland",null,"A",1,null,null,"design parameter",null,"Biofiltration   (w/ underdrain)","Bioretention/Rain Garden  (no underdrains)","Enhanced Biofiltration w/ Internal Storage Reservoir (ISR)  (no infiltration)","Extended Dry Detention Basin","Gravel Wetland","IC Disconnection","Infiltration Trench","Porous pavement w/ impermeable underliner & underdrain ","Porous Pavement w/ subsurface infiltration","Sand Filter w/ underdrain","Subsurface Infiltration  ","Surface Infiltration Practice","Water Quality Grass  Swale w/ Detention","Wet Pond"]
[null,null,null,"Curve","IR","PSC","Volume","TP","TN","TSS","TZn","FIB",null,null,null,"Biofiltration   (w/ underdrain)","Biofiltration",15.870222769869997,20.7,null,"Land Use","(cf/ac-yr)","(lb/ac-yr)",null,null,"(Billion MPN/ac/yr)",null,null,null,"Coastal",null,"B",2,null,null,"Width at top @ Dmax","WDmax",null,null,null,null,null,null,null,null,null,null,null,true,true]
[null,null,null,"Biofiltration",null,0,null,0,0,0,0,0,null,null,null,"Bioretention/Rain Garden  (no underdrains)","Infiltration Basin",15.870222769869997,20.7,null,"Low-Density Residential \"Rural\"",{"$f":"0.936*41.2/12*43560","v":139984.416},1.52,14.1,439,6.4,497,"Low Res.",null,null,null,"C",3,null,null,"Width at bed","Wbottom",null,null,null,null,null,null,null,null,null,null,null,true,true]
[null,null,null,"Biofiltration",null,0.1,null,0.14000000000000001,0.09,0.44,0.68,0.1099,null,null,null,"Enhanced Biofiltration w/ Internal Storage Reservoir (ISR)  (no infiltration)","Enhanced Biofiltration With ISR",16.0245330885,20.7,null,"Medium-Density Residential",{"$f":"0.936*41.2/12*43560","v":139984.416},1.96,14.1,439,6.4,497,"Med Res.",null,null,null,"D",4,null,null,"Area of pretreatment","Apretreatment",null,null,null,null,true,null,null,null,null,true]
[null,null,null,"Biofiltration",null,0.2,null,0.25,0.16,0.69,0.88,0.185,null,null,null,"Extended Dry Detention Basin","Dry Pond",6.9795744118799989,24,null,"Multi-Family and High-Density Residential",139984.416,2.3199999999999998,14.1,439,6.4,497,"Multi / High Res.",null,null,null,null,null,null,null,"Depth of pretreatment","Dpretreatment",null,null,null,null,true,null,null,null,null,true]
["Lookup Tables (locked and hidden)",null,null,"Biofiltration",null,0.4,null,0.37,0.23,0.91,0.95,0.30209999999999998,null,null,null,"Gravel Wetland","Subsurface Gravel Wetland",9.0093486030899985,21.7,null,"Commercial and Industrial",139984.416,1.78,15,377.4,6.4,497,"Comm. / Ind.",null,null,null,null,null,null,null,"Depth of filter course","DFC",null,null,null,null,null,null,null,true]
["performance curves",null,null,"Biofiltration",null,0.6,null,0.44,0.28000000000000003,0.97,0.96,0.40150000000000002,null,null,null,"IC Disconnection","IC Disconnection","Varies","Varies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of pond","Apond",true,true,true,true,true,null,null,null,null,true,null,null,null,true]
["crosswalk",null,null,"Biofiltration",null,0.8,null,0.48,0.31,0.98,0.96,0.48359999999999997,null,null,null,"Infiltration Trench","Infiltration Trench",12.819626470799999,"Unknown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depth of ponding","Dponding",true,true,true,true,true,null,null,null,null,true,null,true,true,true]
["costs",null,null,"Biofiltration",null,1,null,0.53,0.32,0.99,0.97,0.5504,null,null,null,"Porous Pavement w/ impermeable underliner & underdrain ","Porous Pavement",5.4602112745999989,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of media","Asoil",true,true,true]
["O&M",null,null,"Biofiltration",null,1.5,null,0.57999999999999996,0.37,1,0.98,0.66810000000000003,null,null,null,"Porous Pavement w/ subsurface infiltration","Infiltration Trench",5.4602112745999989,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depth of media","Dsoil",true,true,true]
["loading rates",null,null,"Biofiltration",null,2,null,0.63,0.4,1,0.99,0.747,null,null,null,"Sand Filter w/ underdrain","Sand Filter",18.410408015009999,28.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porosity of media (typical ~0.2)","ηsoil",true,true,true]
[null,null,null,"Dry Pond",null,0,null,0,0,0,0,0,null,null,null,"Subsurface Infiltration  ","Infiltration Trench","Varies","Varies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of ISR","AISR",null,null,true,null,true]
[null,null,null,"Dry Pond",null,0.1,null,2.18E-2,1.4014285714285712E-2,0.18,0.53,0,null,null,null,"Surface Infiltration Practice","Infiltration Basin",6.4098132353999997,20.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depth of gravel/stone","Dgravel",null,null,true,null,true,null,true,null,true,true,true]
[null,null,null,"Dry Pond",null,0.2,null,4.5466666666666676E-2,2.9098666666666672E-2,0.31,0.67,3.6528295850341702E-21,null,null,null,"Water Quality Grass  Swale w/ Detention","Grass Swale",5.7094817893099989,9.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porosity of gravel/stone (typical ~0.4)","ηgravel",null,null,true,null,true,null,true,null,true,true,true]
[null,null,null,"Dry Pond",null,0.4,null,9.1600000000000001E-2,5.6940540540540541E-2,0.38,0.68,6.9999999999999999E-4,null,null,null,"Wet Pond","Wet Pond",6.9795744118799989,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of sand","Asand",null,null,null,null,null,null,null,null,null,true]
[null,null,null,"Dry Pond",null,0.6,null,0.13446666666666665,8.5569696969696962E-2,0.4,0.69,4.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depth of sand","Dsand",null,null,null,null,null,null,true,null,null,true]
[null,null,null,"Dry Pond",null,0.8,null,0.17436666666666667,0.11261180555555556,0.44,0.72,8.5000000000000006E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porosity of sand (typical ~0.3)","ηsand",null,null,null,null,null,null,true,null,null,true]
[null,null,null,"Dry Pond",null,1,null,0.2114,0.1276377358490566,0.46,0.73,1.37E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area cross-section of galley/chambers/pipes","Ax-section galley",null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,"Dry Pond",null,1.5,null,0.29373333333333335,0.18738160919540231,0.47,0.74,2.8000000000000001E-2,null,null,null,null,"Infiltration Curves",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width","W",null,null,null,null,null,null,true,null,true,true,true]
[null,null,null,"Dry Pond",null,2,null,0.36430000000000001,0.23130158730158731,0.49,0.76,4.2599999999999999E-2,null,null,null,null,"Infiltration Basin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","L",null,null,null,null,null,null,true,null,true,true,true,true,true]
[null,null,null,"Enhanced Biofiltration With ISR",null,0,null,0,0,0,0,0,null,null,null,null,"Infiltration Trench",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pervious area","Aperv",null,null,null,null,null,true]
[null,null,null,"Enhanced Biofiltration With ISR",null,0.1,null,0.19,0.32,0.44,0.68,0.27889999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pervious Hydrologic Soil Group","HSGperv",null,null,null,null,null,true]
[null,null,null,"Enhanced Biofiltration With ISR",null,0.2,null,0.34,0.44,0.69,0.88,0.44919999999999999]
[null,null,null,"Enhanced Biofiltration With ISR",null,0.4,null,0.53,0.57999999999999996,0.91,0.95,0.64159999999999995]
[null,null,null,"Enhanced Biofiltration With ISR",null,0.6,null,0.64,0.66,0.97,0.96,0.74980000000000002]
[null,null,null,"Enhanced Biofiltration With ISR",null,0.8,null,0.71,0.71,0.98,0.96,0.81410000000000005]
[null,null,null,"Enhanced Biofiltration With ISR",null,1,null,0.76,0.75,0.99,0.97,0.85140000000000005]
[null,null,null,"Enhanced Biofiltration With ISR",null,1.5,null,0.84,0.82,1,0.98,0.89390000000000003]
[null,null,null,"Enhanced Biofiltration With ISR",null,2,null,0.89,0.86,1,0.99,0.91290000000000004]
["extra rows hidden",null,null,"Grass Swale",null,0,null,0,0,0,0,0]
[null,null,null,"Grass Swale",null,0.1,null,2.18E-2,1.4014285714285712E-2,0.28999999999999998,0.62,0]
[null,null,null,"Grass Swale",null,0.2,null,4.5466666666666676E-2,2.9098666666666672E-2,0.44,0.75,0]
[null,null,null,"Grass Swale",null,0.4,null,9.1600000000000001E-2,5.6940540540540541E-2,0.61,0.86,0]
[null,null,null,"Grass Swale",null,0.6,null,0.13446666666666665,8.5569696969696962E-2,0.7,0.91,0]
[null,null,null,"Grass Swale",null,0.8,null,0.17436666666666667,0.11261180555555556,0.76,0.94,0]
[null,null,null,"Grass Swale",null,1,null,0.2114,0.1276377358490566,0.8,0.95,0]
[null,null,null,"Grass Swale",null,1.5,null,0.29373333333333335,0.18738160919540231,0.87,0.97,0]
[null,null,null,"Grass Swale",null,2,null,0.36430000000000001,0.23130158730158731,0.9,0.99,0]
[null,null,null,"Porous Pavement",null,0,null,0,0,0,0,0]
[null,null,null,"Porous Pavement",null,12,null,0.61850702169953264,0.76,0.92,0.85,0]
[null,null,null,"Porous Pavement",null,18,null,0.69687600550776985,0.77,0.94,0.97,0]
[null,null,null,"Porous Pavement",null,24,null,0.7458940601320091,0.77,0.96,0.97,0]
[null,null,null,"Porous Pavement",null,32,null,0.78480964315319379,0.79,0.97,0.98,0]
[null,null,null,"Sand Filter",null,0,null,0,0,0,0,0]
[null,null,null,"Sand Filter",null,0.1,null,0.14000000000000001,0.09,0.44,0.68,0.33639999999999998]
[null,null,null,"Sand Filter",null,0.2,null,0.25,0.16,0.69,0.88,0.52200000000000002]
[null,null,null,"Sand Filter",null,0.4,null,0.37,0.23,0.91,0.95,0.72219999999999995]
[null,null,null,"Sand Filter",null,0.6,null,0.44,0.28000000000000003,0.97,0.96,0.81679999999999997]
[null,null,null,"Sand Filter",null,0.8,null,0.48,0.31,0.98,0.96,0.85740000000000005]
[null,null,null,"Sand Filter",null,1,null,0.53,0.32,0.99,0.97,0.87680000000000002]
[null,null,null,"Sand Filter",null,1.5,null,0.57999999999999996,0.37,1,0.98,0.9022]
[null,null,null,"Sand Filter",null,2,null,0.63,0.4,1,0.99,0.91900000000000004]
[null,null,null,"Subsurface Gravel Wetland",null,0,null,0,0,0,0,0]
[null,null,null,"Subsurface Gravel Wetland",null,0.1,null,0.19278132176596427,0.22,0.48,0.56999999999999995,0.3029]
[null,null,null,"Subsurface Gravel Wetland",null,0.2,null,0.26375445009193726,0.33,0.61,0.68,0.47210000000000002]
[null,null,null,"Subsurface Gravel Wetland",null,0.4,null,0.41385821400650263,0.48,0.82,0.83,0.65510000000000002]
[null,null,null,"Subsurface Gravel Wetland",null,0.6,null,0.51249221191761773,0.56999999999999995,0.91,0.88,0.72629999999999995]
[null,null,null,"Subsurface Gravel Wetland",null,0.8,null,0.57396601185484009,0.64,0.95,0.9,0.748]
[null,null,null,"Subsurface Gravel Wetland",null,1,null,0.61092121374213615,0.68,0.97,0.9,0.76070000000000004]
[null,null,null,"Subsurface Gravel Wetland",null,1.5,null,0.64929937120898928,0.74,0.99,0.91,0.78390000000000004]
[null,null,null,"Subsurface Gravel Wetland",null,2,null,0.66290633617082084,0.79,0.99,0.92,0.80669999999999997]
[null,null,null,"Wet Pond",null,0,null,0,0,0,0,0]
[null,null,null,"Wet Pond",null,0.1,null,0.14000000000000001,0.09,0.3,0.59,0.1452]
[null,null,null,"Wet Pond",null,0.2,null,0.25,0.16,0.44,0.71,0.23699999999999999]
[null,null,null,"Wet Pond",null,0.4,null,0.37,0.23,0.6,0.8,0.38590000000000002]
[null,null,null,"Wet Pond",null,0.6,null,0.44,0.28000000000000003,0.68,0.85,0.49940000000000001]
[null,null,null,"Wet Pond",null,0.8,null,0.48,0.31,0.74,0.87,0.58169999999999999]
[null,null,null,"Wet Pond",null,1,null,0.53,0.32,0.77,0.89,0.64159999999999995]
[null,null,null,"Wet Pond",null,1.5,null,0.57999999999999996,0.37,0.83,0.92,0.7369]
[null,null,null,"Wet Pond",null,2,null,0.63,0.4,0.86,0.93,0.79200000000000004]
[]
[null,null,null,"Infiltration Basin",0.17,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Basin",0.17,0.1,0.13,0.35,0.52,0.64,0.71,0.23580000000000001]
[null,null,null,"Infiltration Basin",0.17,0.2,0.246,0.52,0.69,0.8,0.86,0.39650000000000002]
[null,null,null,"Infiltration Basin",0.17,0.4,0.442,0.72,0.85,0.93,0.96,0.63390000000000002]
[null,null,null,"Infiltration Basin",0.17,0.6,0.59499999999999997,0.82,0.92,0.98,0.98,0.78520000000000001]
[null,null,null,"Infiltration Basin",0.17,0.8,0.70599999999999996,0.88,0.96,0.99,0.99,0.87780000000000002]
[null,null,null,"Infiltration Basin",0.17,1,0.78100000000000003,0.92,0.98,1,1,0.9294]
[null,null,null,"Infiltration Basin",0.17,1.5,0.89200000000000002,0.97,0.99,1,1,0.98099999999999998]
[null,null,null,"Infiltration Basin",0.17,2,0.93899999999999995,0.99,1,1,1,0.99450000000000005]
[null,null,null,"Infiltration Basin",0.27,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Basin",0.27,0.1,0.16300000000000001,0.37,0.54,0.65,0.73,0.25879999999999997]
[null,null,null,"Infiltration Basin",0.27,0.2,0.29799999999999999,0.54,0.71,0.81,0.88,0.434]
[null,null,null,"Infiltration Basin",0.27,0.4,0.51,0.74,0.87,0.94,0.97,0.67710000000000004]
[null,null,null,"Infiltration Basin",0.27,0.6,0.66,0.85,0.93,0.98,0.99,0.82479999999999998]
[null,null,null,"Infiltration Basin",0.27,0.8,0.76,0.9,0.97,0.99,1,0.90859999999999996]
[null,null,null,"Infiltration Basin",0.27,1,0.82399999999999995,0.93,0.98,1,1,0.9516]
[null,null,null,"Infiltration Basin",0.27,1.5,0.91500000000000004,0.98,0.99,1,1,0.98860000000000003]
[null,null,null,"Infiltration Basin",0.27,2,0.95199999999999996,0.99,1,1,1,0.99719999999999998]
[null,null,null,"Infiltration Basin",0.52,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Basin",0.52,0.1,0.20200000000000001,0.38,0.56000000000000005,0.65,0.75,0.29559999999999997]
[null,null,null,"Infiltration Basin",0.52,0.2,0.35599999999999998,0.56000000000000005,0.74,0.83,0.9,0.4864]
[null,null,null,"Infiltration Basin",0.52,0.4,0.57999999999999996,0.77,0.89,0.95,0.98,0.73380000000000001]
[null,null,null,"Infiltration Basin",0.52,0.6,0.72599999999999998,0.87,0.94,0.99,0.99,0.87409999999999999]
[null,null,null,"Infiltration Basin",0.52,0.8,0.81299999999999994,0.92,0.98,0.99,1,0.94210000000000005]
[null,null,null,"Infiltration Basin",0.52,1,0.86899999999999999,0.95,0.99,1,1,0.9728]
[null,null,null,"Infiltration Basin",0.52,1.5,0.94199999999999995,0.98,1,1,1,0.99470000000000003]
[null,null,null,"Infiltration Basin",0.52,2,0.96699999999999997,0.99,1,1,1,0.99890000000000001]
[null,null,null,"Infiltration Basin",1.02,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Basin",1.02,0.1,0.245,0.41,0.59,0.67,0.78,0.33989999999999998]
[null,null,null,"Infiltration Basin",1.02,0.2,0.42,0.6,0.77,0.94,0.92,0.54790000000000005]
[null,null,null,"Infiltration Basin",1.02,0.4,0.65600000000000003,0.81,0.92,0.96,0.99,0.8]
[null,null,null,"Infiltration Basin",1.02,0.6,0.79400000000000004,0.9,0.96,0.99,1,0.92300000000000004]
[null,null,null,"Infiltration Basin",1.02,0.8,0.86799999999999999,0.94,0.98,1,1,0.97119999999999995]
[null,null,null,"Infiltration Basin",1.02,1,0.91300000000000003,0.97,1,1,1,0.98770000000000002]
[null,null,null,"Infiltration Basin",1.02,1.5,0.96199999999999997,0.99,1,1,1,0.99819999999999998]
[null,null,null,"Infiltration Basin",1.02,2,0.98099999999999998,1,1,1,1,0.99980000000000002]
[null,null,null,"Infiltration Basin",2.41,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Basin",2.41,0.1,0.32800000000000001,0.46,0.64,0.7,0.82,0.4168]
[null,null,null,"Infiltration Basin",2.41,0.2,0.53800000000000003,0.67,0.82,0.88,0.95,0.65639999999999998]
[null,null,null,"Infiltration Basin",2.41,0.4,0.77800000000000002,0.87,0.95,0.98,1,0.90059999999999996]
[null,null,null,"Infiltration Basin",2.41,0.6,0.88400000000000001,0.94,0.98,1,1,0.97589999999999999]
[null,null,null,"Infiltration Basin",2.41,0.8,0.93400000000000005,0.97,0.99,1,1,0.99339999999999995]
[null,null,null,"Infiltration Basin",2.41,1,0.96,0.98,1,1,1,0.99819999999999998]
[null,null,null,"Infiltration Basin",2.41,1.5,0.98799999999999999,1,1,1,1,1]
[null,null,null,"Infiltration Basin",2.41,2,0.998,1,1,1,1,1]
[null,null,null,"Infiltration Basin",8.27,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Basin",8.27,0.1,0.54600000000000004,0.59,0.75,0.79,0.91,0.60240000000000005]
[null,null,null,"Infiltration Basin",8.27,0.2,0.77200000000000002,0.81,0.92,0.95,0.99,0.87090000000000001]
[null,null,null,"Infiltration Basin",8.27,0.4,0.93400000000000005,0.96,0.99,1,1,0.99199999999999999]
[null,null,null,"Infiltration Basin",8.27,0.6,0.97499999999999998,0.99,1,1,1,0.99939999999999996]
[null,null,null,"Infiltration Basin",8.27,0.8,0.99,1,1,1,1,1]
[null,null,null,"Infiltration Basin",8.27,1,0.996,1,1,1,1,1]
[null,null,null,"Infiltration Basin",8.27,1.5,1,1,1,1,1,1]
[null,null,null,"Infiltration Basin",8.27,2,1,1,1,1,1,1]
[]
[null,null,null,"Infiltration Trench",0.17,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Trench",0.17,0.1,0.14699999999999999,0.18,0.56000000000000005,0.32,0.51,0.21590000000000001]
[null,null,null,"Infiltration Trench",0.17,0.2,0.27600000000000002,0.33,0.72,0.56000000000000005,0.77,0.3463]
[null,null,null,"Infiltration Trench",0.17,0.4,0.48599999999999999,0.56999999999999995,0.87,0.84,0.94,0.53680000000000005]
[null,null,null,"Infiltration Trench",0.17,0.6,0.64100000000000001,0.73,0.93,0.95,0.98,0.68089999999999995]
[null,null,null,"Infiltration Trench",0.17,0.8,0.749,0.83,0.96,0.98,0.99,0.78039999999999998]
[null,null,null,"Infiltration Trench",0.17,1,0.82,0.9,0.98,0.99,0.99,0.84909999999999997]
[null,null,null,"Infiltration Trench",0.17,1.5,0.91600000000000004,0.97,0.99,1,1,0.94030000000000002]
[null,null,null,"Infiltration Trench",0.17,2,0.95399999999999996,0.99,1,1,1,0.97550000000000003]
[null,null,null,"Infiltration Trench",0.27,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Trench",0.27,0.1,0.17799999999999999,0.2,0.56999999999999995,0.36,0.56999999999999995,0.224]
[null,null,null,"Infiltration Trench",0.27,0.2,0.32500000000000001,0.37,0.74,0.51,0.84,0.36480000000000001]
[null,null,null,"Infiltration Trench",0.27,0.4,0.55000000000000004,0.63,0.88,0.88,0.97,0.56340000000000001]
[null,null,null,"Infiltration Trench",0.27,0.6,0.7,0.78,0.94,0.97,0.99,0.70950000000000002]
[null,null,null,"Infiltration Trench",0.27,0.8,0.79300000000000004,0.86,0.97,0.99,0.99,0.80689999999999995]
[null,null,null,"Infiltration Trench",0.27,1,0.85199999999999998,0.92,0.98,1,1,0.87180000000000002]
[null,null,null,"Infiltration Trench",0.27,1.5,0.93300000000000005,0.97,0.99,1,1,0.95420000000000005]
[null,null,null,"Infiltration Trench",0.27,2,0.96299999999999997,0.99,1,1,1,0.98219999999999996]
[null,null,null,"Infiltration Trench",0.52,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Trench",0.52,0.1,0.22,0.23,0.59,0.4,0.65,0.2442]
[null,null,null,"Infiltration Trench",0.52,0.2,0.38500000000000001,0.42,0.76,0.66,0.9,0.39879999999999999]
[null,null,null,"Infiltration Trench",0.52,0.4,0.61799999999999999,0.68,0.9,0.91,0.98,0.6069]
[null,null,null,"Infiltration Trench",0.52,0.6,0.75700000000000001,0.82,0.95,0.98,0.99,0.75149999999999995]
[null,null,null,"Infiltration Trench",0.52,0.8,0.83699999999999997,0.89,0.98,0.99,1,0.84279999999999999]
[null,null,null,"Infiltration Trench",0.52,1,0.88800000000000001,0.94,0.99,1,1,0.90300000000000002]
[null,null,null,"Infiltration Trench",0.52,1.5,0.95,0.98,1,1,1,0.97009999999999996]
[null,null,null,"Infiltration Trench",0.52,2,0.97199999999999998,0.99,1,1,1,0.98919999999999997]
[null,null,null,"Infiltration Trench",1.02,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Trench",1.02,0.1,0.26300000000000001,0.27,0.61,0.44,0.72,0.27489999999999998]
[null,null,null,"Infiltration Trench",1.02,0.2,0.44600000000000001,0.47,0.78,0.7,0.94,0.44540000000000002]
[null,null,null,"Infiltration Trench",1.02,0.4,0.68200000000000005,0.73,0.92,0.93,0.99,0.66500000000000004]
[null,null,null,"Infiltration Trench",1.02,0.6,0.81,0.86,0.97,0.99,1,0.80389999999999995]
[null,null,null,"Infiltration Trench",1.02,0.8,0.88,0.92,0.98,1,1,0.88849999999999996]
[null,null,null,"Infiltration Trench",1.02,1,0.92100000000000004,0.96,0.99,1,1,0.93769999999999998]
[null,null,null,"Infiltration Trench",1.02,1.5,0.96499999999999997,0.99,1,1,1,0.98370000000000002]
[null,null,null,"Infiltration Trench",1.02,2,0.98299999999999998,1,1,1,1,0.99460000000000004]
[null,null,null,"Infiltration Trench",2.41,0,0,0,0,0,0,0]
[null,null,null,"Infiltration Trench",2.41,0.1,0.34,0.33,0.65,0.5,0.81,0.33560000000000001]
[null,null,null,"Infiltration Trench",2.41,0.2,0.54700000000000004,0.55000000000000004,0.83,0.77,0.98,0.53549999999999998]
[null,null,null,"Infiltration Trench",2.41,0.4,0.78300000000000003,0.81,0.95,0.97,1,0.76439999999999997]
[null,null,null,"Infiltration Trench",2.41,0.6,0.88400000000000001,0.91,0.98,1,1,0.88829999999999998]
[null,null,null,"Infiltration Trench",2.41,0.8,0.93400000000000005,0.96,0.99,1,1,0.94899999999999995]
[null,null,null,"Infiltration Trench",2.41,1,0.96,0.98,1,1,1,0.97589999999999999]
[null,null,null,"Infiltration Trench",2.41,1.5,0.98799999999999999,1,1,1,1,0.995]
[null,null,null,"Infiltration Trench",2.41,2,0.998,1,1,1,1,0.99829999999999997]
[null,null,null,"Infiltration Trench",8.27,0,0,0,0,0,0,0]
["corrected from earlier versions which had them switched (from EPA)",null,null,"Infiltration Trench",8.27,0.1,0.53600000000000003,0.5,0.76,0.92,0.93,0.50190000000000001]
[null,null,null,"Infiltration Trench",8.27,0.2,0.76100000000000001,0.75,0.92,0.98,1,0.74760000000000004]
[null,null,null,"Infiltration Trench",8.27,0.4,0.92600000000000005,0.94,0.98,1,1,0.93669999999999998]
[null,null,null,"Infiltration Trench",8.27,0.6,0.97199999999999998,0.98,1,1,1,0.98370000000000002]
[null,null,null,"Infiltration Trench",8.27,0.8,0.98899999999999999,0.99,1,1,1,0.99439999999999995]
[null,null,null,"Infiltration Trench",8.27,1,0.995,1,1,1,1,0.99739999999999995]
[null,null,null,"Infiltration Trench",8.27,1.5,1,1,1,1,1,0.99960000000000004]
[null,null,null,"Infiltration Trench",8.27,2,1,1,1,1,1,0.99990000000000001]
[]
[null,"HSG to numeric",null,null,"HSG","IC/PC"]
[null,{"$f":"VLOOKUP(E184,table_HSG_conv,2,FALSE)","v":1},null,"IC Disconnection","A",1.4E-2,1,1,1,1,1,1]
[null,1,null,"IC Disconnection","A",0.02,1,1,1,1,1,1]
[null,1,null,"IC Disconnection","A",3.3000000000000002E-2,0.99,0.99,0.99,0.99,0.99,0.99]
[null,1,null,"IC Disconnection","A",0.1,0.99,0.99,0.99,0.99,0.99,0.99]
[null,1,null,"IC Disconnection","A",0.25,0.95,0.95,0.95,0.95,0.95,0.95]
[null,1,null,"IC Disconnection","A",0.5,0.93,0.93,0.93,0.93,0.93,0.93]
[null,1,null,"IC Disconnection","A",1,0.88,0.88,0.88,0.88,0.88,0.88]
[null,1,null,"IC Disconnection","A",2,0.78,0.78,0.78,0.78,0.78,0.78]
[null,1,null,"IC Disconnection","A",4,0.63,0.63,0.63,0.63,0.63,0.63]
[null,1,null,"IC Disconnection","A",6,0.52,0.52,0.52,0.52,0.52,0.52]
[null,1,null,"IC Disconnection","A",8,0.45,0.45,0.45,0.45,0.45,0.45]
[null,2,null,"IC Disconnection","B",1.4E-2,0.99,0.99,0.99,0.99,0.99,0.99]
[null,2,null,"IC Disconnection","B",0.02,0.9,0.9,0.9,0.9,0.9,0.9]
[null,2,null,"IC Disconnection","B",3.3000000000000002E-2,0.89,0.89,0.89,0.89,0.89,0.89]
[null,2,null,"IC Disconnection","B",0.1,0.88,0.88,0.88,0.88,0.88,0.88]
[null,2,null,"IC Disconnection","B",0.25,0.78,0.78,0.78,0.78,0.78,0.78]
[null,2,null,"IC Disconnection","B",0.5,0.74,0.74,0.74,0.74,0.74,0.74]
[null,2,null,"IC Disconnection","B",1,0.66,0.66,0.66,0.66,0.66,0.66]
[null,2,null,"IC Disconnection","B",2,0.54,0.54,0.54,0.54,0.54,0.54]
[null,2,null,"IC Disconnection","B",4,0.39,0.39,0.39,0.39,0.39,0.39]
[null,2,null,"IC Disconnection","B",6,0.31,0.31,0.31,0.31,0.31,0.31]
[null,2,null,"IC Disconnection","B",8,0.26,0.26,0.26,0.26,0.26,0.26]
[null,3,null,"IC Disconnection","C",1.4E-2,0.94,0.94,0.94,0.94,0.94,0.94]
[null,3,null,"IC Disconnection","C",0.02,0.82,0.82,0.82,0.82,0.82,0.82]
[null,3,null,"IC Disconnection","C",3.3000000000000002E-2,0.79,0.79,0.79,0.79,0.79,0.79]
[null,3,null,"IC Disconnection","C",0.1,0.73,0.73,0.73,0.73,0.73,0.73]
[null,3,null,"IC Disconnection","C",0.25,0.62,0.62,0.62,0.62,0.62,0.62]
[null,3,null,"IC Disconnection","C",0.5,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995]
[null,3,null,"IC Disconnection","C",1,0.48,0.48,0.48,0.48,0.48,0.48]
[null,3,null,"IC Disconnection","C",2,0.37,0.37,0.37,0.37,0.37,0.37]
[null,3,null,"IC Disconnection","C",4,0.26,0.26,0.26,0.26,0.26,0.26]
[null,3,null,"IC Disconnection","C",6,0.2,0.2,0.2,0.2,0.2,0.2]
[null,3,null,"IC Disconnection","C",8,0.16,0.16,0.16,0.16,0.16,0.16]
[null,4,null,"IC Disconnection","D",1.4E-2,0.75,0.75,0.75,0.75,0.75,0.75]
[null,4,null,"IC Disconnection","D",0.02,0.71,0.71,0.71,0.71,0.71,0.71]
[null,4,null,"IC Disconnection","D",3.3000000000000002E-2,0.68,0.68,0.68,0.68,0.68,0.68]
[null,4,null,"IC Disconnection","D",0.1,0.62,0.62,0.62,0.62,0.62,0.62]
[null,4,null,"IC Disconnection","D",0.25,0.44,0.44,0.44,0.44,0.44,0.44]
[null,4,null,"IC Disconnection","D",0.5,0.39,0.39,0.39,0.39,0.39,0.39]
[null,4,null,"IC Disconnection","D",1,0.32,0.32,0.32,0.32,0.32,0.32]
[null,4,null,"IC Disconnection","D",2,0.24,0.24,0.24,0.24,0.24,0.24]
[null,4,null,"IC Disconnection","D",4,0.16,0.16,0.16,0.16,0.16,0.16]
[null,4,null,"IC Disconnection","D",6,0.12,0.12,0.12,0.12,0.12,0.12]
[null,4,null,"IC Disconnection","D",8,0.1,0.1,0.1,0.1,0.1,0.1]
[]
["for bicubic --> update from normal table values",null,null,"Infiltration Basin","IR","PSC"]
[null,null,null,"Volume",null,0,0.1,0.2,0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,0.17,{"$f":"SUMIFS($G$73:$G$126,$E$73:$E$126,$E231,$F$73:$F$126,F$230)","v":0},{"$f":"SUMIFS($G$73:$G$126,$E$73:$E$126,$E231,$F$73:$F$126,G$230)","v":0.13},0.246,0.442,0.59499999999999997,0.70599999999999996,0.78100000000000003,0.89200000000000002,0.93899999999999995]
[null,null,null,"calc",0.27,{"$f":"SUMIFS($G$73:$G$126,$E$73:$E$126,$E232,$F$73:$F$126,F$230)","v":0},0.16300000000000001,0.29799999999999999,0.51,0.66,0.76,0.82399999999999995,0.91500000000000004,0.95199999999999996]
[null,null,"PSC",0.1,0.52,0,0.20200000000000001,0.35599999999999998,0.57999999999999996,0.72599999999999998,0.81299999999999994,0.86899999999999999,0.94199999999999995,0.96699999999999997]
[null,null,"IR",1.5,1.02,0,0.245,0.42,0.65600000000000003,0.79400000000000004,0.86799999999999999,0.91300000000000003,0.96199999999999997,0.98099999999999998]
["bicubic: table, column index value, row index value",null,"RE",{"$f":"IF(AND(D233>=0.1,D234>=0.17),Interpolation_Bicubic(curve_InfBasin_Vol, MIN(2,D233), MIN(8.27,D234)),0)","v":0.27914052144126988},2.41,0,0.32800000000000001,0.53800000000000003,0.77800000000000002,0.88400000000000001,0.93400000000000005,0.96,0.98799999999999999,0.998]
[null,null,null,null,8.27,0,0.54600000000000004,0.77200000000000002,0.93400000000000005,0.97499999999999998,0.99,0.996,1,1]
[null,null,null,"Infiltration Basin"]
[null,null,null,"TP",null,{"$f":"F$230","v":0},0.1,0.2,0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($H$73:$H$126,$E$73:$E$126,$E239,$F$73:$F$126,F$230)","v":0},{"$f":"SUMIFS($H$73:$H$126,$E$73:$E$126,$E239,$F$73:$F$126,G$230)","v":0.35},0.52,0.72,0.82,0.88,0.92,0.97,0.99]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($H$73:$H$126,$E$73:$E$126,$E240,$F$73:$F$126,F$230)","v":0},0.37,0.54,0.74,0.85,0.9,0.93,0.98,0.99]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.38,0.56000000000000005,0.77,0.87,0.92,0.95,0.98,0.99]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.41,0.6,0.81,0.9,0.94,0.97,0.99,1]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.46,0.67,0.87,0.94,0.97,0.98,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.59,0.81,0.96,0.99,1,1,1,1]
[null,null,null,"Infiltration Basin"]
[null,null,null,"TN",null,{"$f":"F$230","v":0},0.1,0.2,0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($I$73:$I$126,$E$73:$E$126,$E247,$F$73:$F$126,F$230)","v":0},{"$f":"SUMIFS($I$73:$I$126,$E$73:$E$126,$E247,$F$73:$F$126,G$230)","v":0.52},0.69,0.85,0.92,0.96,0.98,0.99,1]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($I$73:$I$126,$E$73:$E$126,$E248,$F$73:$F$126,F$230)","v":0},0.54,0.71,0.87,0.93,0.97,0.98,0.99,1]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.56000000000000005,0.74,0.89,0.94,0.98,0.99,1,1]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.59,0.77,0.92,0.96,0.98,1,1,1]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.64,0.82,0.95,0.98,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.75,0.92,0.99,1,1,1,1,1]
[null,null,null,"Infiltration Basin"]
[null,null,null,"TSS",null,{"$f":"F$230","v":0},0.1,0.2,0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($J$73:$J$126,$E$73:$E$126,$E255,$F$73:$F$126,F$230)","v":0},{"$f":"SUMIFS($J$73:$J$126,$E$73:$E$126,$E255,$F$73:$F$126,G$230)","v":0.64},0.8,0.93,0.98,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($J$73:$J$126,$E$73:$E$126,$E256,$F$73:$F$126,F$230)","v":0},0.65,0.81,0.94,0.98,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.65,0.83,0.95,0.99,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.67,0.94,0.96,0.99,1,1,1,1]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.7,0.88,0.98,1,1,1,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.79,0.95,1,1,1,1,1,1]
[null,null,null,"Infiltration Basin"]
[null,null,null,"TZn",null,{"$f":"F$230","v":0},0.1,0.2,0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($K$73:$K$126,$E$73:$E$126,$E263,$F$73:$F$126,F$230)","v":0},{"$f":"SUMIFS($K$73:$K$126,$E$73:$E$126,$E263,$F$73:$F$126,G$230)","v":0.71},0.86,0.96,0.98,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($K$73:$K$126,$E$73:$E$126,$E264,$F$73:$F$126,F$230)","v":0},0.73,0.88,0.97,0.99,1,1,1,1]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.75,0.9,0.98,0.99,1,1,1,1]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.78,0.92,0.99,1,1,1,1,1]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.82,0.95,1,1,1,1,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.91,0.99,1,1,1,1,1,1]
[null,null,null,"Infiltration Basin"]
[null,null,null,"FIB",null,{"$f":"F$230","v":0},0.1,0.2,0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($L$73:$L$126,$E$73:$E$126,$E271,$F$73:$F$126,F$230)","v":0},{"$f":"SUMIFS($L$73:$L$126,$E$73:$E$126,$E271,$F$73:$F$126,G$230)","v":0.23580000000000001},0.39650000000000002,0.63390000000000002,0.78520000000000001,0.87780000000000002,0.9294,0.98099999999999998,0.99450000000000005]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($L$73:$L$126,$E$73:$E$126,$E272,$F$73:$F$126,F$230)","v":0},0.25879999999999997,0.434,0.67710000000000004,0.82479999999999998,0.90859999999999996,0.9516,0.98860000000000003,0.99719999999999998]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.29559999999999997,0.4864,0.73380000000000001,0.87409999999999999,0.94210000000000005,0.9728,0.99470000000000003,0.99890000000000001]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.33989999999999998,0.54790000000000005,0.8,0.92300000000000004,0.97119999999999995,0.98770000000000002,0.99819999999999998,0.99980000000000002]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.4168,0.65639999999999998,0.90059999999999996,0.97589999999999999,0.99339999999999995,0.99819999999999998,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.60240000000000005,0.87090000000000001,0.99199999999999999,0.99939999999999996,1,1,1,1]
[]
[]
[]
[null,null,null,"Infiltration Trench","IR","PSC"]
[null,null,null,"Volume",null,0,0.1,0.2,0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,0.17,{"$f":"SUMIFS($G$128:$G$181,$E$128:$E$181,$E282,$F$128:$F$181,F$281)","v":0},{"$f":"SUMIFS($G$128:$G$181,$E$128:$E$181,$E282,$F$128:$F$181,G$281)","v":0.14699999999999999},0.27600000000000002,0.48599999999999999,0.64100000000000001,0.749,0.82,0.91600000000000004,0.95399999999999996]
[null,null,null,"calc",0.27,{"$f":"SUMIFS($G$128:$G$181,$E$128:$E$181,$E283,$F$128:$F$181,F$281)","v":0},0.17799999999999999,0.32500000000000001,0.55000000000000004,0.7,0.79300000000000004,0.85199999999999998,0.93300000000000005,0.96299999999999997]
[null,null,"PSC",0.1,0.52,0,0.22,0.38500000000000001,0.61799999999999999,0.75700000000000001,0.83699999999999997,0.88800000000000001,0.95,0.97199999999999998]
[null,null,"IR",20,1.02,0,0.26300000000000001,0.44600000000000001,0.68200000000000005,0.81,0.88,0.92100000000000004,0.96499999999999997,0.98299999999999998]
[null,null,"RE",{"$f":"IF(AND(D284>=0.1,D285>=0.17),Interpolation_Bicubic(curve_InfTrench_Vol, MIN(2,D284), MIN(8.27,D285)),0)","v":0.53600000000000003},2.41,0,0.34,0.54700000000000004,0.78300000000000003,0.88400000000000001,0.93400000000000005,0.96,0.98799999999999999,0.998]
[null,null,null,null,8.27,0,0.53600000000000003,0.76100000000000001,0.92600000000000005,0.97199999999999998,0.98899999999999999,0.995,1,1]
[null,null,null,"Infiltration Trench"]
[null,null,null,"TP",null,{"$f":"F$281","v":0},{"$f":"G$281","v":0.1},{"$f":"H$281","v":0.2},0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($H$128:$H$181,$E$128:$E$181,$E290,$F$128:$F$181,F$281)","v":0},{"$f":"SUMIFS($H$128:$H$181,$E$128:$E$181,$E290,$F$128:$F$181,G$281)","v":0.18},0.33,0.56999999999999995,0.73,0.83,0.9,0.97,0.99]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($H$128:$H$181,$E$128:$E$181,$E291,$F$128:$F$181,F$281)","v":0},0.2,0.37,0.63,0.78,0.86,0.92,0.97,0.99]
[null,null,"RE",{"$f":"IF(AND(D284>=0.1,D285>=0.17),Interpolation_Bicubic(curve_InfTrench_TP, MIN(2,D284), MIN(8.27,D285)),0)","v":0.5},{"$f":"$E$233","v":0.52},0,0.23,0.42,0.68,0.82,0.89,0.94,0.98,0.99]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.27,0.47,0.73,0.86,0.92,0.96,0.99,1]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.33,0.55000000000000004,0.81,0.91,0.96,0.98,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.5,0.75,0.94,0.98,0.99,1,1,1]
[null,null,null,"Infiltration Trench"]
[null,null,null,"TN",null,{"$f":"F$281","v":0},{"$f":"G$281","v":0.1},{"$f":"H$281","v":0.2},0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($I$128:$I$181,$E$128:$E$181,$E298,$F$128:$F$181,F$281)","v":0},{"$f":"SUMIFS($I$128:$I$181,$E$128:$E$181,$E298,$F$128:$F$181,G$281)","v":0.56000000000000005},0.72,0.87,0.93,0.96,0.98,0.99,1]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($I$128:$I$181,$E$128:$E$181,$E299,$F$128:$F$181,F$281)","v":0},0.56999999999999995,0.74,0.88,0.94,0.97,0.98,0.99,1]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.59,0.76,0.9,0.95,0.98,0.99,1,1]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.61,0.78,0.92,0.97,0.98,0.99,1,1]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.65,0.83,0.95,0.98,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.76,0.92,0.98,1,1,1,1,1]
[null,null,null,"Infiltration Trench"]
[null,null,null,"TSS",null,{"$f":"F$281","v":0},{"$f":"G$281","v":0.1},{"$f":"H$281","v":0.2},0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($J$128:$J$181,$E$128:$E$181,$E306,$F$128:$F$181,F$281)","v":0},{"$f":"SUMIFS($J$128:$J$181,$E$128:$E$181,$E306,$F$128:$F$181,G$281)","v":0.32},0.56000000000000005,0.84,0.95,0.98,0.99,1,1]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($J$128:$J$181,$E$128:$E$181,$E307,$F$128:$F$181,F$281)","v":0},0.36,0.51,0.88,0.97,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.4,0.66,0.91,0.98,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.44,0.7,0.93,0.99,1,1,1,1]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.5,0.77,0.97,1,1,1,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.92,0.98,1,1,1,1,1,1]
[null,null,null,"Infiltration Trench"]
[null,null,null,"TZn",null,{"$f":"F$281","v":0},{"$f":"G$281","v":0.1},{"$f":"H$281","v":0.2},0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($K$128:$K$181,$E$128:$E$181,$E314,$F$128:$F$181,F$281)","v":0},{"$f":"SUMIFS($K$128:$K$181,$E$128:$E$181,$E314,$F$128:$F$181,G$281)","v":0.51},0.77,0.94,0.98,0.99,0.99,1,1]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($K$128:$K$181,$E$128:$E$181,$E315,$F$128:$F$181,F$281)","v":0},0.56999999999999995,0.84,0.97,0.99,0.99,1,1,1]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.65,0.9,0.98,0.99,1,1,1,1]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.72,0.94,0.99,1,1,1,1,1]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.81,0.98,1,1,1,1,1,1]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.93,1,1,1,1,1,1,1]
[null,null,null,"Infiltration Trench"]
[null,null,null,"FIB",null,{"$f":"F$281","v":0},{"$f":"G$281","v":0.1},{"$f":"H$281","v":0.2},0.4,0.6,0.8,1,1.5,2]
[null,null,null,null,{"$f":"$E$231","v":0.17},{"$f":"SUMIFS($L$128:$L$181,$E$128:$E$181,$E322,$F$128:$F$181,F$281)","v":0},{"$f":"SUMIFS($L$128:$L$181,$E$128:$E$181,$E322,$F$128:$F$181,G$281)","v":0.21590000000000001},0.3463,0.53680000000000005,0.68089999999999995,0.78039999999999998,0.84909999999999997,0.94030000000000002,0.97550000000000003]
[null,null,null,null,{"$f":"$E$232","v":0.27},{"$f":"SUMIFS($L$128:$L$181,$E$128:$E$181,$E323,$F$128:$F$181,F$281)","v":0},0.224,0.36480000000000001,0.56340000000000001,0.70950000000000002,0.80689999999999995,0.87180000000000002,0.95420000000000005,0.98219999999999996]
[null,null,null,null,{"$f":"$E$233","v":0.52},0,0.2442,0.39879999999999999,0.6069,0.75149999999999995,0.84279999999999999,0.90300000000000002,0.97009999999999996,0.98919999999999997]
[null,null,null,null,{"$f":"$E$234","v":1.02},0,0.27489999999999998,0.44540000000000002,0.66500000000000004,0.80389999999999995,0.88849999999999996,0.93769999999999998,0.98370000000000002,0.99460000000000004]
[null,null,null,null,{"$f":"$E$235","v":2.41},0,0.33560000000000001,0.53549999999999998,0.76439999999999997,0.88829999999999998,0.94899999999999995,0.97589999999999999,0.995,0.99829999999999997]
[null,null,null,null,{"$f":"$E$236","v":8.27},0,0.50190000000000001,0.74760000000000004,0.93669999999999998,0.98370000000000002,0.99439999999999995,0.99739999999999995,0.99960000000000004,0.99990000000000001]
[]
[]
[null,null,null,"IC Disconnection","IA/perv","HSG (numeric)"]
[null,null,null,"Volume",null,1,2,3,4]
[null,null,null,null,1.4E-2,{"$f":"SUMIFS($G$184:$G$227,$F$184:$F$227,$E332,$B$184:$B$227,F$331)","v":1},{"$f":"SUMIFS($G$184:$G$227,$F$184:$F$227,$E332,$B$184:$B$227,G$331)","v":0.99},0.94,0.75]
[null,null,null,"calc",0.02,{"$f":"SUMIFS($G$184:$G$227,$F$184:$F$227,$E333,$B$184:$B$227,F$331)","v":1},0.9,0.82,0.71]
[null,null,"HSG",1,3.3000000000000002E-2,0.99,0.89,0.79,0.68]
[null,null,"IA/perv",0.5,0.1,0.99,0.88,0.73,0.62]
[null,null,"RE",{"$f":"IF(D335>=0.014,Interpolation_Bicubic(E331:I342, D334, MIN(8,D335)),0)","v":0.93},0.25,0.95,0.78,0.62,0.44]
[null,null,null,null,0.5,0.93,0.74,0.56999999999999995,0.39]
[null,null,null,null,1,0.88,0.66,0.48,0.32]
[null,null,null,null,2,0.78,0.54,0.37,0.24]
[null,null,null,null,4,0.63,0.39,0.26,0.16]
[null,null,null,null,6,0.52,0.31,0.2,0.12]
[null,null,null,null,8,0.45,0.26,0.16,0.1]
[]
[null,null,null,"IC Disconnection","IA/perv","HSG (numeric)"]
[null,null,null,"TP",null,1,2,3,4]
[null,null,null,null,1.4E-2,{"$f":"SUMIFS($H$184:$H$227,$F$184:$F$227,$E346,$B$184:$B$227,F$331)","v":1},{"$f":"SUMIFS($H$184:$H$227,$F$184:$F$227,$E346,$B$184:$B$227,G$331)","v":0.99},0.94,0.75]
[null,null,null,null,0.02,{"$f":"SUMIFS($H$184:$H$227,$F$184:$F$227,$E347,$B$184:$B$227,F$331)","v":1},0.9,0.82,0.71]
[null,null,null,null,3.3000000000000002E-2,0.99,0.89,0.79,0.68]
[null,null,null,null,0.1,0.99,0.88,0.73,0.62]
[null,null,null,null,0.25,0.95,0.78,0.62,0.44]
[null,null,null,null,0.5,0.93,0.74,0.56999999999999995,0.39]
[null,null,null,null,1,0.88,0.66,0.48,0.32]
[null,null,null,null,2,0.78,0.54,0.37,0.24]
[null,null,null,null,4,0.63,0.39,0.26,0.16]
[null,null,null,null,6,0.52,0.31,0.2,0.12]
[null,null,null,null,8,0.45,0.26,0.16,0.1]
[]
[null,null,null,"IC Disconnection","IA/perv","HSG (numeric)"]
[null,null,null,"TN",null,1,2,3,4]
[null,null,null,null,1.4E-2,{"$f":"SUMIFS($I$184:$I$227,$F$184:$F$227,$E360,$B$184:$B$227,F$331)","v":1},{"$f":"SUMIFS($I$184:$I$227,$F$184:$F$227,$E360,$B$184:$B$227,G$331)","v":0.99},0.94,0.75]
[null,null,null,null,0.02,{"$f":"SUMIFS($I$184:$I$227,$F$184:$F$227,$E361,$B$184:$B$227,F$331)","v":1},0.9,0.82,0.71]
[null,null,null,null,3.3000000000000002E-2,0.99,0.89,0.79,0.68]
[null,null,null,null,0.1,0.99,0.88,0.73,0.62]
[null,null,null,null,0.25,0.95,0.78,0.62,0.44]
[null,null,null,null,0.5,0.93,0.74,0.56999999999999995,0.39]
[null,null,null,null,1,0.88,0.66,0.48,0.32]
[null,null,null,null,2,0.78,0.54,0.37,0.24]
[null,null,null,null,4,0.63,0.39,0.26,0.16]
[null,null,null,null,6,0.52,0.31,0.2,0.12]
[null,null,null,null,8,0.45,0.26,0.16,0.1]
[]
[null,null,null,"IC Disconnection","IA/perv","HSG (numeric)"]
[null,null,null,"TSS",null,1,2,3,4]
[null,null,null,null,1.4E-2,{"$f":"SUMIFS($J$184:$J$227,$F$184:$F$227,$E374,$B$184:$B$227,F$331)","v":1},{"$f":"SUMIFS($J$184:$J$227,$F$184:$F$227,$E374,$B$184:$B$227,G$331)","v":0.99},0.94,0.75]
[null,null,null,null,0.02,{"$f":"SUMIFS($J$184:$J$227,$F$184:$F$227,$E375,$B$184:$B$227,F$331)","v":1},0.9,0.82,0.71]
[null,null,null,null,3.3000000000000002E-2,0.99,0.89,0.79,0.68]
[null,null,null,null,0.1,0.99,0.88,0.73,0.62]
[null,null,null,null,0.25,0.95,0.78,0.62,0.44]
[null,null,null,null,0.5,0.93,0.74,0.56999999999999995,0.39]
[null,null,null,null,1,0.88,0.66,0.48,0.32]
[null,null,null,null,2,0.78,0.54,0.37,0.24]
[null,null,null,null,4,0.63,0.39,0.26,0.16]
[null,null,null,null,6,0.52,0.31,0.2,0.12]
[null,null,null,null,8,0.45,0.26,0.16,0.1]
[]
[null,null,null,"IC Disconnection","IA/perv","HSG (numeric)"]
[null,null,null,"TZn",null,1,2,3,4]
[null,null,null,null,1.4E-2,{"$f":"SUMIFS($K$184:$K$227,$F$184:$F$227,$E388,$B$184:$B$227,F$331)","v":1},{"$f":"SUMIFS($K$184:$K$227,$F$184:$F$227,$E388,$B$184:$B$227,G$331)","v":0.99},0.94,0.75]
[null,null,null,null,0.02,{"$f":"SUMIFS($K$184:$K$227,$F$184:$F$227,$E389,$B$184:$B$227,F$331)","v":1},0.9,0.82,0.71]
[null,null,null,null,3.3000000000000002E-2,0.99,0.89,0.79,0.68]
[null,null,null,null,0.1,0.99,0.88,0.73,0.62]
[null,null,null,null,0.25,0.95,0.78,0.62,0.44]
[null,null,null,null,0.5,0.93,0.74,0.56999999999999995,0.39]
[null,null,null,null,1,0.88,0.66,0.48,0.32]
[null,null,null,null,2,0.78,0.54,0.37,0.24]
[null,null,null,null,4,0.63,0.39,0.26,0.16]
[null,null,null,null,6,0.52,0.31,0.2,0.12]
[null,null,null,null,8,0.45,0.26,0.16,0.1]
[]
[null,null,null,"IC Disconnection","IA/perv","HSG (numeric)"]
[null,null,null,"FIB",null,1,2,3,4]
[null,null,null,null,1.4E-2,{"$f":"SUMIFS($L$184:$L$227,$F$184:$F$227,$E402,$B$184:$B$227,F$331)","v":1},{"$f":"SUMIFS($L$184:$L$227,$F$184:$F$227,$E402,$B$184:$B$227,G$331)","v":0.99},0.94,0.75]
[null,null,null,null,0.02,{"$f":"SUMIFS($L$184:$L$227,$F$184:$F$227,$E403,$B$184:$B$227,F$331)","v":1},0.9,0.82,0.71]
[null,null,null,null,3.3000000000000002E-2,0.99,0.89,0.79,0.68]
[null,null,null,null,0.1,0.99,0.88,0.73,0.62]
[null,null,null,null,0.25,0.95,0.78,0.62,0.44]
[null,null,null,null,0.5,0.93,0.74,0.56999999999999995,0.39]
[null,null,null,null,1,0.88,0.66,0.48,0.32]
[null,null,null,null,2,0.78,0.54,0.37,0.24]
[null,null,null,null,4,0.63,0.39,0.26,0.16]
[null,null,null,null,6,0.52,0.31,0.2,0.12]
[null,null,null,null,8,0.45,0.26,0.16,0.1]

{"sheet":"Calcs (hidden_locked)","index":7,"n_rows":211,"n_cols":11,"rows_kept":211,"cut":false,"hidden":true,"merged":[]}
["calc notes",null,"Notes","Parameter","Abbrev.","Units","SCM 1","SCM 2","SCM 3","SCM 4","SCM 5"]
[null,"Input: \nSite & BMP","Site","ID",null,null,{"$f":"IF(ISBLANK(Input_Design_Output!F2),\"\",Input_Design_Output!F2)","v":"Example Bioretention"},{"$f":"IF(ISBLANK(Input_Design_Output!G2),\"\",Input_Design_Output!G2)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H2),\"\",Input_Design_Output!H2)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I2),\"\",Input_Design_Output!I2)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J2),\"\",Input_Design_Output!J2)","v":""}]
[null,null,null,"Date",null,null,{"$f":"IF(ISBLANK(Input_Design_Output!F3),\"\",Input_Design_Output!F3)","v":44378},{"$f":"IF(ISBLANK(Input_Design_Output!G3),\"\",Input_Design_Output!G3)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H3),\"\",Input_Design_Output!H3)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I3),\"\",Input_Design_Output!I3)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J3),\"\",Input_Design_Output!J3)","v":""}]
[null,null,null,"Location",null,null,{"$f":"IF(ISBLANK(Input_Design_Output!F4),\"\",Input_Design_Output!F4)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G4),\"\",Input_Design_Output!G4)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H4),\"\",Input_Design_Output!H4)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I4),\"\",Input_Design_Output!I4)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J4),\"\",Input_Design_Output!J4)","v":""}]
[null,null,null,"Description/Notes",null,null,{"$f":"IF(ISBLANK(Input_Design_Output!F5),\"\",Input_Design_Output!F5)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G5),\"\",Input_Design_Output!G5)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H5),\"\",Input_Design_Output!H5)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I5),\"\",Input_Design_Output!I5)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J5),\"\",Input_Design_Output!J5)","v":""}]
[null,null,null,"Costs Multiplier (Recommended 1-3)",null,null,{"$f":"IF(ISBLANK(Input_Design_Output!F6),\"\",Input_Design_Output!F6)","v":2},{"$f":"IF(ISBLANK(Input_Design_Output!G6),\"\",Input_Design_Output!G6)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H6),\"\",Input_Design_Output!H6)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I6),\"\",Input_Design_Output!I6)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J6),\"\",Input_Design_Output!J6)","v":""}]
[null,null,null,"Location (for FIB)",null,null,{"$f":"IF(ISBLANK(Input_Design_Output!F7),\"\",Input_Design_Output!F7)","v":"Inland"},{"$f":"IF(ISBLANK(Input_Design_Output!G7),\"\",Input_Design_Output!G7)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H7),\"\",Input_Design_Output!H7)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I7),\"\",Input_Design_Output!I7)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J7),\"\",Input_Design_Output!J7)","v":""}]
[null,null,"Watershed","Impervious Drainage Area","IA","ac",{"$f":"IF(ISBLANK(Input_Design_Output!F8),\"\",Input_Design_Output!F8)","v":0.84},{"$f":"IF(ISBLANK(Input_Design_Output!G8),\"\",Input_Design_Output!G8)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H8),\"\",Input_Design_Output!H8)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I8),\"\",Input_Design_Output!I8)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J8),\"\",Input_Design_Output!J8)","v":""}]
[null,null,null,"Land Use","LU","-",{"$f":"IF(ISBLANK(Input_Design_Output!F9),\"\",Input_Design_Output!F9)","v":"Medium-Density Residential"},{"$f":"IF(ISBLANK(Input_Design_Output!G9),\"\",Input_Design_Output!G9)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H9),\"\",Input_Design_Output!H9)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I9),\"\",Input_Design_Output!I9)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J9),\"\",Input_Design_Output!J9)","v":""}]
[null,null,"SCM","Selected SCM","-","-",{"$f":"IF(ISBLANK(Input_Design_Output!F10),\"\",Input_Design_Output!F10)","v":"Bioretention/Rain Garden  (no underdrains)"},{"$f":"IF(ISBLANK(Input_Design_Output!G10),\"\",Input_Design_Output!G10)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H10),\"\",Input_Design_Output!H10)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I10),\"\",Input_Design_Output!I10)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J10),\"\",Input_Design_Output!J10)","v":""}]
["lookup curve from table",null,null,"Applicable Performance Curve (See Crosswalk)","-","-",{"$f":"IFERROR(VLOOKUP(G$10,table_SCM_appcurve_costs_OM,2,FALSE),\"\")","v":"Infiltration Basin"},"","","",""]
[null,null,null,"Infiltration Rate (0.17-8.27)","IR","in/hr",{"$f":"IF(ISBLANK(Input_Design_Output!F12),\"\",Input_Design_Output!F12)","v":0.52},{"$f":"IF(ISBLANK(Input_Design_Output!G12),\"\",Input_Design_Output!G12)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H12),\"\",Input_Design_Output!H12)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I12),\"\",Input_Design_Output!I12)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J12),\"\",Input_Design_Output!J12)","v":""}]
[null,null,null,"Known DSV (to skip design section below, or blank)","DSV","cf",{"$f":"IF(ISBLANK(Input_Design_Output!F13),0,Input_Design_Output!F13)","v":0},{"$f":"IF(ISBLANK(Input_Design_Output!G13),0,Input_Design_Output!G13)","v":0},{"$f":"IF(ISBLANK(Input_Design_Output!H13),0,Input_Design_Output!H13)","v":0},{"$f":"IF(ISBLANK(Input_Design_Output!I13),0,Input_Design_Output!I13)","v":0},{"$f":"IF(ISBLANK(Input_Design_Output!J13),0,Input_Design_Output!J13)","v":0}]
[]
[null,"Input: \nBMP Design","SCM Design Specifications: DSV is calculated from orange Input cells only. Formulas, Goal Seek, and Solver may be used in any cell.\n\nAll parameters pertain to the BMP system, not native materials.","Width at top @ Dmax","WDmax","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F15),\"\",Input_Design_Output!F15)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G15),\"\",Input_Design_Output!G15)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H15),\"\",Input_Design_Output!H15)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I15),\"\",Input_Design_Output!I15)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J15),\"\",Input_Design_Output!J15)","v":""}]
[null,null,null,"Width at bed","Wbottom","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F16),\"\",Input_Design_Output!F16)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G16),\"\",Input_Design_Output!G16)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H16),\"\",Input_Design_Output!H16)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I16),\"\",Input_Design_Output!I16)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J16),\"\",Input_Design_Output!J16)","v":""}]
[null,null,null,"Area of pretreatment","Apretreatment","sf",{"$f":"IF(ISBLANK(Input_Design_Output!F17),\"\",Input_Design_Output!F17)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G17),\"\",Input_Design_Output!G17)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H17),\"\",Input_Design_Output!H17)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I17),\"\",Input_Design_Output!I17)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J17),\"\",Input_Design_Output!J17)","v":""}]
[null,null,null,"Depth of pretreatment","Dpretreatment","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F18),\"\",Input_Design_Output!F18)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G18),\"\",Input_Design_Output!G18)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H18),\"\",Input_Design_Output!H18)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I18),\"\",Input_Design_Output!I18)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J18),\"\",Input_Design_Output!J18)","v":""}]
[null,null,null,"Depth of filter course","DFC","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F19),\"\",Input_Design_Output!F19)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G19),\"\",Input_Design_Output!G19)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H19),\"\",Input_Design_Output!H19)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I19),\"\",Input_Design_Output!I19)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J19),\"\",Input_Design_Output!J19)","v":""}]
[null,null,null,"Area of pond","Apond","sf",{"$f":"IF(ISBLANK(Input_Design_Output!F20),\"\",Input_Design_Output!F20)","v":800},{"$f":"IF(ISBLANK(Input_Design_Output!G20),\"\",Input_Design_Output!G20)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H20),\"\",Input_Design_Output!H20)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I20),\"\",Input_Design_Output!I20)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J20),\"\",Input_Design_Output!J20)","v":""}]
[null,null,null,"Depth of ponding","Dponding","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F21),\"\",Input_Design_Output!F21)","v":1},{"$f":"IF(ISBLANK(Input_Design_Output!G21),\"\",Input_Design_Output!G21)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H21),\"\",Input_Design_Output!H21)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I21),\"\",Input_Design_Output!I21)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J21),\"\",Input_Design_Output!J21)","v":""}]
[null,null,null,"Area of media","Asoil","sf",{"$f":"IF(ISBLANK(Input_Design_Output!F22),\"\",Input_Design_Output!F22)","v":800},{"$f":"IF(ISBLANK(Input_Design_Output!G22),\"\",Input_Design_Output!G22)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H22),\"\",Input_Design_Output!H22)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I22),\"\",Input_Design_Output!I22)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J22),\"\",Input_Design_Output!J22)","v":""}]
[null,null,null,"Depth of media","Dsoil","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F23),\"\",Input_Design_Output!F23)","v":3},{"$f":"IF(ISBLANK(Input_Design_Output!G23),\"\",Input_Design_Output!G23)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H23),\"\",Input_Design_Output!H23)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I23),\"\",Input_Design_Output!I23)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J23),\"\",Input_Design_Output!J23)","v":""}]
[null,null,null,"Porosity of media (typical 0.2)","ηsoil","-",{"$f":"IF(ISBLANK(Input_Design_Output!F24),\"\",Input_Design_Output!F24)","v":0.2},{"$f":"IF(ISBLANK(Input_Design_Output!G24),\"\",Input_Design_Output!G24)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H24),\"\",Input_Design_Output!H24)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I24),\"\",Input_Design_Output!I24)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J24),\"\",Input_Design_Output!J24)","v":""}]
[null,null,null,"Area of ISR","AISR","sf",{"$f":"IF(ISBLANK(Input_Design_Output!F25),\"\",Input_Design_Output!F25)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G25),\"\",Input_Design_Output!G25)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H25),\"\",Input_Design_Output!H25)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I25),\"\",Input_Design_Output!I25)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J25),\"\",Input_Design_Output!J25)","v":""}]
[null,null,null,"Depth of gravel/stone","Dgravel","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F26),\"\",Input_Design_Output!F26)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G26),\"\",Input_Design_Output!G26)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H26),\"\",Input_Design_Output!H26)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I26),\"\",Input_Design_Output!I26)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J26),\"\",Input_Design_Output!J26)","v":""}]
[null,null,null,"Porosity of gravel/stone (typical 0.4)","ηgravel","-",{"$f":"IF(ISBLANK(Input_Design_Output!F27),\"\",Input_Design_Output!F27)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G27),\"\",Input_Design_Output!G27)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H27),\"\",Input_Design_Output!H27)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I27),\"\",Input_Design_Output!I27)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J27),\"\",Input_Design_Output!J27)","v":""}]
[null,null,null,"Area of sand","Asand","sf",{"$f":"IF(ISBLANK(Input_Design_Output!F28),\"\",Input_Design_Output!F28)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G28),\"\",Input_Design_Output!G28)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H28),\"\",Input_Design_Output!H28)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I28),\"\",Input_Design_Output!I28)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J28),\"\",Input_Design_Output!J28)","v":""}]
[null,null,null,"Depth of sand","Dsand","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F29),\"\",Input_Design_Output!F29)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G29),\"\",Input_Design_Output!G29)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H29),\"\",Input_Design_Output!H29)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I29),\"\",Input_Design_Output!I29)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J29),\"\",Input_Design_Output!J29)","v":""}]
[null,null,null,"Porosity of sand (typical 0.3)","ηsand","-",{"$f":"IF(ISBLANK(Input_Design_Output!F30),\"\",Input_Design_Output!F30)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G30),\"\",Input_Design_Output!G30)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H30),\"\",Input_Design_Output!H30)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I30),\"\",Input_Design_Output!I30)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J30),\"\",Input_Design_Output!J30)","v":""}]
[null,null,null,"Area cross-section of galley/chambers/pipes (total)","Ax-section galley","sf",{"$f":"IF(ISBLANK(Input_Design_Output!F31),\"\",Input_Design_Output!F31)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G31),\"\",Input_Design_Output!G31)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H31),\"\",Input_Design_Output!H31)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I31),\"\",Input_Design_Output!I31)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J31),\"\",Input_Design_Output!J31)","v":""}]
[null,null,null,"Width","W","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F32),\"\",Input_Design_Output!F32)","v":40},{"$f":"IF(ISBLANK(Input_Design_Output!G32),\"\",Input_Design_Output!G32)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H32),\"\",Input_Design_Output!H32)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I32),\"\",Input_Design_Output!I32)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J32),\"\",Input_Design_Output!J32)","v":""}]
[null,null,null,"Length","L","ft",{"$f":"IF(ISBLANK(Input_Design_Output!F33),\"\",Input_Design_Output!F33)","v":20},{"$f":"IF(ISBLANK(Input_Design_Output!G33),\"\",Input_Design_Output!G33)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H33),\"\",Input_Design_Output!H33)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I33),\"\",Input_Design_Output!I33)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J33),\"\",Input_Design_Output!J33)","v":""}]
[null,null,null,"Pervious area","Aperv","ac",{"$f":"IF(ISBLANK(Input_Design_Output!F34),\"\",Input_Design_Output!F34)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G34),\"\",Input_Design_Output!G34)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H34),\"\",Input_Design_Output!H34)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I34),\"\",Input_Design_Output!I34)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J34),\"\",Input_Design_Output!J34)","v":""}]
[null,null,null,"Pervious Hydrologic Soil Group","HSGperv","-",{"$f":"IF(ISBLANK(Input_Design_Output!F35),\"\",Input_Design_Output!F35)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G35),\"\",Input_Design_Output!G35)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H35),\"\",Input_Design_Output!H35)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I35),\"\",Input_Design_Output!I35)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J35),\"\",Input_Design_Output!J35)","v":""}]
[]
[]
["ignore if IC disc or PPw/liner, then use given DSV, or max of calculated one",null,null,"Design Storage Volume","DSV","cf",{"$f":"IFERROR(IF(OR(G$10=$D75,G$10=$D72),\"N/A\",IF(G13>0,G13,IF(MAX(G67:G81)=0,\"\",IFERROR(MAX(G67:G81),\"\")))),\"\")","v":1280},{"$f":"IFERROR(IF(OR(H$10=$D75,H$10=$D72),\"N/A\",IF(H13>0,H13,IF(MAX(H67:H81)=0,\"\",IFERROR(MAX(H67:H81),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR(I$10=$D75,I$10=$D72),\"N/A\",IF(I13>0,I13,IF(MAX(I67:I81)=0,\"\",IFERROR(MAX(I67:I81),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR(J$10=$D75,J$10=$D72),\"N/A\",IF(J13>0,J13,IF(MAX(J67:J81)=0,\"\",IFERROR(MAX(J67:J81),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR(K$10=$D75,K$10=$D72),\"N/A\",IF(K13>0,K13,IF(MAX(K67:K81)=0,\"\",IFERROR(MAX(K67:K81),\"\")))),\"\")","v":""}]
["for IC disc, IA/PC",null,null,"Impervious to Pervious Ratio","IA/PC","ac/ac",{"$f":"IF(G11=$D72,G8/G34,IF(G11=\"\",\"\",\"N/A\"))","v":"N/A"},{"$f":"IF(H11=$D72,H8/H34,IF(H11=\"\",\"\",\"N/A\"))","v":""},{"$f":"IF(I11=$D72,I8/I34,IF(I11=\"\",\"\",\"N/A\"))","v":""},{"$f":"IF(J11=$D72,J8/J34,IF(J11=\"\",\"\",\"N/A\"))","v":""},{"$f":"IF(K11=$D72,K8/K34,IF(K11=\"\",\"\",\"N/A\"))","v":""}]
["ignore if IC disc, then lookup if PPw/liner, then DSV/WQV",null,null,"Physical Storage Capacity: Depth of Runoff  from IA\n(range of 0 - 2, goal > 0.1, optimal 0.4)","PSC","in",{"$f":"IF(G$10=$D72,\"N/A\",IF(G$10=$D74,G74,IFERROR(G38/(G8*3630),\"\")))","v":0.41978223796405617},{"$f":"IF(H$10=$D72,\"N/A\",IF(H$10=$D74,H74,IFERROR(H38/(H8*3630),\"\")))","v":""},"","",""]
[null,null,"Performance Curve Results","Removal Efficiency: Volume","VolRE","-",{"$f":"IF(G$40=\"\",\"\", IF(AND(G$92,G$93),IFERROR(MAX(0,MIN(1,SUMIFS(G$98:G$163,$D$98:$D$163,G$11,$E$98:$E$163,$E41))),\"\"),0))","v":0.59760686218543724},"","","",""]
[null,null,null,"Removal Efficiency: P","PRE","-",0.78381371113356024,"","","",""]
[null,null,null,"Removal Efficiency: N","NRE","-",0.89793279531198233,"","","",""]
[null,null,null,"Removal Efficiency: TSS","TSSRE","-",0.95686860158166143,"","","",""]
[null,null,null,"Removal Efficiency: Zn","ZnRE","-",0.9829659095564891,"","","",""]
[null,null,null,"Removal Efficiency: Bacteria","FIBRE","-",0.75188195952112169,"","","",""]
[null,null,"Loading Rates","Load: Volume","VolLER","Mgal/yr",{"$f":"IFERROR(VLOOKUP(G$9,table_PLER_abb,2,FALSE) * G$8 * 7.48/1000000,\"\")","v":0.87955008261119993},{"$f":"IFERROR(VLOOKUP(H$9,table_PLER_abb,2,FALSE) * H$8 * 7.48/1000000,\"\")","v":""},"","",""]
[null,null,null,"Load: P","PLER","lb/yr",{"$f":"IFERROR(VLOOKUP(G$9,table_PLER_abb,3,FALSE) * G$8,\"\")","v":1.6463999999999999},"","","",""]
[null,null,null,"Load: N","NLER","lb/yr",{"$f":"IFERROR(VLOOKUP(G$9,table_PLER_abb,4,FALSE) * G$8,\"\")","v":11.843999999999999},"","","",""]
[null,null,null,"Load: TSS","TSSLER","lb/yr",{"$f":"IFERROR(VLOOKUP(G$9,table_PLER_abb,5,FALSE) * G$8,\"\")","v":368.76},"","","",""]
[null,null,null,"Load: Bacteria","FIBLER","Billion MPN/yr",{"$f":"IFERROR(IF(G$7='Tables (hidden_locked)'!$AD$2, VLOOKUP(G$9,table_PLER_abb,6,FALSE) * G$8,VLOOKUP(G$9,table_PLER_abb,7,FALSE) * G$8),\"\")","v":5.3760000000000003},{"$f":"IFERROR(IF(H$7='Tables (hidden_locked)'!$AD$2, VLOOKUP(H$9,table_PLER_abb,6,FALSE) * H$8,VLOOKUP(H$9,table_PLER_abb,7,FALSE) * H$8),\"\")","v":""},{"$f":"IFERROR(IF(I$7='Tables (hidden_locked)'!$AD$2, VLOOKUP(I$9,table_PLER_abb,6,FALSE) * I$8,VLOOKUP(I$9,table_PLER_abb,7,FALSE) * I$8),\"\")","v":""},{"$f":"IFERROR(IF(J$7='Tables (hidden_locked)'!$AD$2, VLOOKUP(J$9,table_PLER_abb,6,FALSE) * J$8,VLOOKUP(J$9,table_PLER_abb,7,FALSE) * J$8),\"\")","v":""},{"$f":"IFERROR(IF(K$7='Tables (hidden_locked)'!$AD$2, VLOOKUP(K$9,table_PLER_abb,6,FALSE) * K$8,VLOOKUP(K$9,table_PLER_abb,7,FALSE) * K$8),\"\")","v":""}]
[null,null,"SCM Annual Performance","Reduction: Volume","VolRed","Mgal/yr",{"$f":"IFERROR(G47*G41,\"\")","v":0.5256251650042213},"","","",""]
[null,null,null,"Reduction: P","PRed","lb/yr",1.2904708940102936,"","","",""]
[null,null,null,"Reduction: N","NRed","lb/yr",10.635116027675119,"","","",""]
[null,null,null,"Reduction: TSS","TSSRed","lb/yr",352.85486551925345,"","","",""]
[null,null,null,"Reduction: Bacteria","FIBRed","%",{"$f":"G46","v":0.75188195952112169},{"$f":"H46","v":""},{"$f":"I46","v":""},{"$f":"J46","v":""},{"$f":"K46","v":""}]
[null,null,"Costs","Estimated Total Costs",null,"$",{"$f":"IF(G$38=\"\",\"\",IF(ISNUMBER(G$165), ROUNDUP(PRODUCT(G$6,G$38,G$165),-3),G$165))","v":41000},{"$f":"IF(H$38=\"\",\"\",IF(ISNUMBER(H$165), ROUNDUP(PRODUCT(H$6,H$38,H$165),-3),H$165))","v":""},{"$f":"IF(I$38=\"\",\"\",IF(ISNUMBER(I$165), ROUNDUP(PRODUCT(I$6,I$38,I$165),-3),I$165))","v":""},{"$f":"IF(J$38=\"\",\"\",IF(ISNUMBER(J$165), ROUNDUP(PRODUCT(J$6,J$38,J$165),-3),J$165))","v":""},{"$f":"IF(K$38=\"\",\"\",IF(ISNUMBER(K$165), ROUNDUP(PRODUCT(K$6,K$38,K$165),-3),K$165))","v":""}]
[null,null,null,"Removal Costs: Volume",null,"$/Mgal-yr",{"$f":"IFERROR(IF(ISNUMBER(G$165), IF(G52=0,\"N/A\",ROUND(G$57/G52,-1)),G$57),\"\")","v":78000},"","","",""]
[null,null,null,"Removal Costs: P",null,"$/lb-yr",31770,"","","",""]
[null,null,null,"Removal Costs: N",null,"$/lb-yr",3860,"","","",""]
[null,null,null,"Removal Costs: TSS",null,"$/lb-yr",120,"","","",""]
[null,null,null,"Removal Costs: Bacteria",null,"$/%-yr",{"$f":"IFERROR(IF(ISNUMBER(G$165), IF(G56=0,\"N/A\",ROUND(G$57/G56/100,-1)),G$57),\"\")","v":550},{"$f":"IFERROR(IF(ISNUMBER(H$165), IF(H56=0,\"N/A\",ROUND(H$57/H56/100,-1)),H$57),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(I$165), IF(I56=0,\"N/A\",ROUND(I$57/I56/100,-1)),I$57),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(J$165), IF(J56=0,\"N/A\",ROUND(J$57/J56/100,-1)),J$57),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(K$165), IF(K56=0,\"N/A\",ROUND(K$57/K56/100,-1)),K$57),\"\")","v":""}]
[null,null,"O&M","Estimated O&M Hours",null,"hr/yr",{"$f":"IF(ISNUMBER(G$166), G$166*G$8, G$166)","v":17.387999999999998},{"$f":"IF(ISNUMBER(H$166), H$166*H$8, H$166)","v":""},{"$f":"IF(ISNUMBER(I$166), I$166*I$8, I$166)","v":""},{"$f":"IF(ISNUMBER(J$166), J$166*J$8, J$166)","v":""},{"$f":"IF(ISNUMBER(K$166), K$166*K$8, K$166)","v":""}]
[]
[]
[null,null,null,"DSV calculation for each BMP",null,"Vlookup column:",4,5,6,7,8]
["calc DSV using App F, Table 3-5",null,null,"Biofiltration   (w/ underdrain)","DSV","cf",{"$f":"IF(G$10=$D67,(PRODUCT(G$20:G$21) + PRODUCT(G$22:G$24)),\"\")","v":""},{"$f":"IF(H$10=$D67,(PRODUCT(H$20:H$21) + PRODUCT(H$22:H$24)),\"\")","v":""},"","",""]
[null,null,null,"Bioretention/Rain Garden  (no underdrains)","DSV","cf",{"$f":"IF(G$10=$D68,(PRODUCT(G$20:G$21) + PRODUCT(G$22:G$24)),\"\")","v":1280},"","","",""]
[null,null,null,"Enhanced Biofiltration w/ Internal Storage Reservoir (ISR)  (no infiltration)","DSV","cf",{"$f":"IF(G$10=$D69,(PRODUCT(G$20:G$21) + PRODUCT(G$22:G$24) + PRODUCT(G$25:G$27)),\"\")","v":""},{"$f":"IF(H$10=$D69,(PRODUCT(H$20:H$21) + PRODUCT(H$22:H$24) + PRODUCT(H$25:H$27)),\"\")","v":""},"","",""]
[null,null,null,"Extended Dry Detention Basin","DSV","cf",{"$f":"IF(G$10=$D70,(PRODUCT(G$20:G$21)),\"\")","v":""},{"$f":"IF(H$10=$D70,(PRODUCT(H$20:H$21)),\"\")","v":""},"","",""]
[null,null,null,"Gravel Wetland","DSV","cf",{"$f":"IF(G$10=$D71,(PRODUCT(G$17:G$18) + PRODUCT(G$20:G$21) + PRODUCT(G$25:G$27)),\"\")","v":""},{"$f":"IF(H$10=$D71,(PRODUCT(H$17:H$18) + PRODUCT(H$20:H$21) + PRODUCT(H$25:H$27)),\"\")","v":""},"","",""]
["no DSV",null,null,"IC Disconnection"]
[null,null,null,"Infiltration Trench","DSV","cf",{"$f":"IF(G$10=$D73,(PRODUCT(G$32:G$33)*(PRODUCT(G$26:G$27) + PRODUCT(G$29:G$30))),\"\")","v":""},{"$f":"IF(H$10=$D73,(PRODUCT(H$32:H$33)*(PRODUCT(H$26:H$27) + PRODUCT(H$29:H$30))),\"\")","v":""},{"$f":"IF(I$10=$D73,(PRODUCT(I$32:I$33)*(PRODUCT(I$26:I$27) + PRODUCT(I$29:I$30))),\"\")","v":""},{"$f":"IF(J$10=$D73,(PRODUCT(J$32:J$33)*(PRODUCT(J$26:J$27) + PRODUCT(J$29:J$30))),\"\")","v":""},{"$f":"IF(K$10=$D73,(PRODUCT(K$32:K$33)*(PRODUCT(K$26:K$27) + PRODUCT(K$29:K$30))),\"\")","v":""}]
[null,null,null,"Porous pavement w/ impermeable underliner & underdrain ","PSC","in",{"$f":"IF(G$10=$D75,(G$19*12),\"\")","v":""},{"$f":"IF(H$10=$D75,(H$19*12),\"\")","v":""},"","",""]
["filter course porosity:",null,0.3,"Porous pavement w/ impermeable underliner & underdrain ","DSV (for costs)","cf",{"$f":"IF(G$10=$D75, PRODUCT(G$19,G$8,$C$75)*43560,\"\")","v":""},{"$f":"IF(H$10=$D75, PRODUCT(H$19,H$8,$C$75)*43560,\"\")","v":""},{"$f":"IF(I$10=$D75, PRODUCT(I$19,I$8,$C$75)*43560,\"\")","v":""},{"$f":"IF(J$10=$D75, PRODUCT(J$19,J$8,$C$75)*43560,\"\")","v":""},{"$f":"IF(K$10=$D75, PRODUCT(K$19,K$8,$C$75)*43560,\"\")","v":""}]
[null,null,null,"Porous Pavement w/ subsurface infiltration","DSV","cf",{"$f":"IF(G$10=$D76,(PRODUCT(G$26:G$27,G$32:G$33)),\"\")","v":""},{"$f":"IF(H$10=$D76,(PRODUCT(H$26:H$27,H$32:H$33)),\"\")","v":""},{"$f":"IF(I$10=$D76,(PRODUCT(I$26:I$27,I$32:I$33)),\"\")","v":""},{"$f":"IF(J$10=$D76,(PRODUCT(J$26:J$27,J$32:J$33)),\"\")","v":""},{"$f":"IF(K$10=$D76,(PRODUCT(K$26:K$27,K$32:K$33)),\"\")","v":""}]
[null,null,null,"Sand Filter w/ underdrain","DSV","cf",{"$f":"IF(G$10=$D77,(PRODUCT(G17:G18) + PRODUCT(G20:G21) + PRODUCT(G28:G30) + PRODUCT(G26:G27,G32:G33)),\"\")","v":""},{"$f":"IF(H$10=$D77,(PRODUCT(H17:H18) + PRODUCT(H20:H21) + PRODUCT(H28:H30) + PRODUCT(H26:H27,H32:H33)),\"\")","v":""},{"$f":"IF(I$10=$D77,(PRODUCT(I17:I18) + PRODUCT(I20:I21) + PRODUCT(I28:I30) + PRODUCT(I26:I27,I32:I33)),\"\")","v":""},{"$f":"IF(J$10=$D77,(PRODUCT(J17:J18) + PRODUCT(J20:J21) + PRODUCT(J28:J30) + PRODUCT(J26:J27,J32:J33)),\"\")","v":""},{"$f":"IF(K$10=$D77,(PRODUCT(K17:K18) + PRODUCT(K20:K21) + PRODUCT(K28:K30) + PRODUCT(K26:K27,K32:K33)),\"\")","v":""}]
[null,null,null,"Subsurface Infiltration  ","DSV","cf",{"$f":"IF(G$10=$D78,(PRODUCT(G$26:G$27,G$32:G$33) + PRODUCT(1-G$27,G$31,G$33)),\"\")","v":""},{"$f":"IF(H$10=$D78,(PRODUCT(H$26:H$27,H$32:H$33) + PRODUCT(1-H$27,H$31,H$33)),\"\")","v":""},"","",""]
[null,null,null,"Surface Infiltration Practice","DSV","cf",{"$f":"IF(G$10=$D79,PRODUCT(AVERAGE(G$15:G$16),G$21,G$33),\"\")","v":""},{"$f":"IF(H$10=$D79,PRODUCT(AVERAGE(H$15:H$16),H$21,H$33),\"\")","v":""},"","",""]
[null,null,null,"Water Quality Grass  Swale w/ Detention","DSV","cf",{"$f":"IF(G$10=$D80,PRODUCT(AVERAGE(G$15:G$16),G$21,G$33),\"\")","v":""},"","","",""]
[null,null,null,"Wet Pond","DSV","cf",{"$f":"IF(G$10=$D81, PRODUCT(G$20:G$21),\"\")","v":""},{"$f":"IF(H$10=$D81, PRODUCT(H$20:H$21),\"\")","v":""},"","",""]
[]
[]
[null,null,null,"Lower limit","Upper limit"]
["set boundary limits for future updates",null,"IR",{"$f":"'Tables (hidden_locked)'!E231","v":0.17},{"$f":"'Tables (hidden_locked)'!E236","v":8.27}]
[null,null,"IA/perv",{"$f":"'Tables (hidden_locked)'!F184","v":1.4E-2},{"$f":"'Tables (hidden_locked)'!F194","v":8}]
[null,null,"PSC",{"$f":"'Tables (hidden_locked)'!F4","v":0},{"$f":"'Tables (hidden_locked)'!F12","v":2},null,{"$f":"AND(ISNUMBER(G12),G12>=$D$85)","v":true}]
[]
["bounded values for interpolation",null,"bounded values for interpolation","Bounded IR",null,"in/hr",{"$f":"IF(OR(NOT(ISNUMBER(G12)),G12=-999),-999,MAX($D85,MIN($E85,G12)))","v":0.52},{"$f":"IF(OR(NOT(ISNUMBER(H12)),H12=-999),-999,MAX($D85,MIN($E85,H12)))","v":-999},-999,-999,-999]
[null,null,null,"Bounded IA/perv",null,"ac/ac",{"$f":"IF(G39=\"N/A\",-999,MAX($D86,MIN($E86,G39)))","v":-999},8,8,8,8]
[null,null,null,"Bounded PSC",null,"in",{"$f":"IF(G40=\"N/A\",-999,MAX($D87,MIN($E87,G40)))","v":0.41978223796405617},2,2,2,2]
[null,null,null,"PSC credit?",null,null,{"$f":"G40>=$D$87","v":true},{"$f":"H40>=$D$87","v":true},true,true,true]
[null,null,null,"IR credit?",null,null,{"$f":"IF(NOT(G176),TRUE, AND(ISNUMBER(G12),G12>=$D$85))","v":true},true,{"$f":"IF(NOT(I176),TRUE, AND(ISNUMBER(I12),I12>=$D$85))","v":true},{"$f":"IF(NOT(J176),TRUE, AND(ISNUMBER(J12),J12>=$D$85))","v":true},true]
[]
["lookup conversion table",null,null,"IC Disconnection HSG as numeric",null,null,{"$f":"IFERROR(VLOOKUP(G35,table_HSG_conv,2,FALSE),-999)","v":-999},{"$f":"IFERROR(VLOOKUP(H35,table_HSG_conv,2,FALSE),-999)","v":-999},{"$f":"IFERROR(VLOOKUP(I35,table_HSG_conv,2,FALSE),-999)","v":-999},{"$f":"IFERROR(VLOOKUP(J35,table_HSG_conv,2,FALSE),-999)","v":-999},{"$f":"IFERROR(VLOOKUP(K35,table_HSG_conv,2,FALSE),-999)","v":-999}]
[]
[null,null,"calculator order","performance for each curve","same names as input for lookup"]
["interpolation from curves",null,1,"Biofiltration","VolRE","RE",0,0,0,0,0]
[null,null,2,"Dry Pond","VolRE","RE",0,0,0,0,0]
[null,null,3,"Enhanced Biofiltration With ISR","VolRE","RE",0,0,0,0,0]
[null,null,4,"Grass Swale","VolRE","RE",0,0,0,0,0]
[null,null,5,"IC Disconnection","VolRE","RE",{"$f":"Interpolation_Bicubic(curve_ICDisc_Vol,G$95,G$90)","v":4.906281182185455E+20},{"$f":"Interpolation_Bicubic(curve_ICDisc_Vol,H$95,H$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_Vol,I$95,I$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_Vol,J$95,J$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_Vol,K$95,K$90)","v":8403585.450000003}]
[null,null,6,"Infiltration Basin","VolRE","RE",{"$f":"Interpolation_Bicubic(curve_InfBasin_Vol,G$91,G$89)","v":0.59760686218543724},{"$f":"Interpolation_Bicubic(curve_InfBasin_Vol,H$91,H$89)","v":-184920506.98842853},{"$f":"Interpolation_Bicubic(curve_InfBasin_Vol,I$91,I$89)","v":-184920506.98842853},{"$f":"Interpolation_Bicubic(curve_InfBasin_Vol,J$91,J$89)","v":-184920506.98842853},{"$f":"Interpolation_Bicubic(curve_InfBasin_Vol,K$91,K$89)","v":-184920506.98842853}]
[null,null,7,"Infiltration Trench","VolRE","RE",{"$f":"Interpolation_Bicubic(curve_InfTrench_Vol,G$91,G$89)","v":0.63536632332144627},{"$f":"Interpolation_Bicubic(curve_InfTrench_Vol,H$91,H$89)","v":-159380685.20578629},{"$f":"Interpolation_Bicubic(curve_InfTrench_Vol,I$91,I$89)","v":-159380685.20578629},{"$f":"Interpolation_Bicubic(curve_InfTrench_Vol,J$91,J$89)","v":-159380685.20578629},{"$f":"Interpolation_Bicubic(curve_InfTrench_Vol,K$91,K$89)","v":-159380685.20578629}]
[null,null,8,"Porous Pavement","VolRE","RE",0,0,0,0,0]
[null,null,9,"Sand Filter","VolRE","RE",0,0,0,0,0]
[null,null,10,"Subsurface Gravel Wetland","VolRE","RE",0,0,0,0,0]
[null,null,11,"Wet Pond","VolRE","RE",0,0,0,0,0]
[null,null,12,"Biofiltration","PRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_PSC,curve_Biofilt_TP,G$91)","v":0.37829172049736742},{"$f":"Interpolation_Cubic(curve_Biofilt_PSC,curve_Biofilt_TP,H$91)","v":0.63},{"$f":"Interpolation_Cubic(curve_Biofilt_PSC,curve_Biofilt_TP,I$91)","v":0.63},{"$f":"Interpolation_Cubic(curve_Biofilt_PSC,curve_Biofilt_TP,J$91)","v":0.63},0.63]
[null,null,13,"Dry Pond","PRE","RE",{"$f":"Interpolation_Cubic(curve_DryPond_PSC,curve_DryPond_TP,G$91)","v":9.5981644037304664E-2},{"$f":"Interpolation_Cubic(curve_DryPond_PSC,curve_DryPond_TP,H$91)","v":0.36430000000000001},{"$f":"Interpolation_Cubic(curve_DryPond_PSC,curve_DryPond_TP,I$91)","v":0.36430000000000001},0.36430000000000001,0.36430000000000001]
[null,null,14,"Enhanced Biofiltration With ISR","PRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_ISR_PSC,curve_Biofilt_ISR_TP,G$91)","v":0.54346774494183248},{"$f":"Interpolation_Cubic(curve_Biofilt_ISR_PSC,curve_Biofilt_ISR_TP,H$91)","v":0.89},{"$f":"Interpolation_Cubic(curve_Biofilt_ISR_PSC,curve_Biofilt_ISR_TP,I$91)","v":0.89},0.89,0.89]
[null,null,15,"Grass Swale","PRE","RE",{"$f":"Interpolation_Cubic(curve_GrassSwale_PSC,curve_GrassSwale_TP,G$91)","v":9.5981644037304664E-2},{"$f":"Interpolation_Cubic(curve_GrassSwale_PSC,curve_GrassSwale_TP,H$91)","v":0.36430000000000001},{"$f":"Interpolation_Cubic(curve_GrassSwale_PSC,curve_GrassSwale_TP,I$91)","v":0.36430000000000001},0.36430000000000001,0.36430000000000001]
[null,null,16,"IC Disconnection","PRE","RE",{"$f":"Interpolation_Bicubic(curve_ICDisc_TP,G$95,G$90)","v":4.906281182185455E+20},{"$f":"Interpolation_Bicubic(curve_ICDisc_TP,H$95,H$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TP,I$95,I$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TP,J$95,J$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TP,K$95,K$90)","v":8403585.450000003}]
[null,null,17,"Infiltration Basin","PRE","RE",{"$f":"Interpolation_Bicubic(curve_InfBasin_TP,G$91,G$89)","v":0.78381371113356024},{"$f":"Interpolation_Bicubic(curve_InfBasin_TP,H$91,H$89)","v":-31308590.520853519},{"$f":"Interpolation_Bicubic(curve_InfBasin_TP,I$91,I$89)","v":-31308590.520853519},{"$f":"Interpolation_Bicubic(curve_InfBasin_TP,J$91,J$89)","v":-31308590.520853519},{"$f":"Interpolation_Bicubic(curve_InfBasin_TP,K$91,K$89)","v":-31308590.520853519}]
[null,null,18,"Infiltration Trench","PRE","RE",{"$f":"Interpolation_Bicubic(curve_InfTrench_TP,G$91,G$89)","v":0.69837903672438828},{"$f":"Interpolation_Bicubic(curve_InfTrench_TP,H$91,H$89)","v":-31308590.520853519},{"$f":"Interpolation_Bicubic(curve_InfTrench_TP,I$91,I$89)","v":-31308590.520853519},{"$f":"Interpolation_Bicubic(curve_InfTrench_TP,J$91,J$89)","v":-31308590.520853519},{"$f":"Interpolation_Bicubic(curve_InfTrench_TP,K$91,K$89)","v":-31308590.520853519}]
[null,null,19,"Porous Pavement","PRE","RE",{"$f":"Interpolation_Cubic(curve_PorPave_PSC,curve_PorPave_TP,G$91)","v":2.7100556754622571E-2},0.12842509425587387,0.12842509425587387,0.12842509425587387,0.12842509425587387]
[null,null,20,"Sand Filter","PRE","RE",{"$f":"Interpolation_Cubic(curve_Sand_PSC,curve_Sand_TP,G$91)","v":0.37829172049736742},0.63,0.63,0.63,0.63]
[null,null,21,"Subsurface Gravel Wetland","PRE","RE",{"$f":"Interpolation_Cubic(curve_SubGravWet_PSC,curve_SubGravWet_TP,G$91)","v":0.42727855428315525},0.66290633617082084,0.66290633617082084,0.66290633617082084,0.66290633617082084]
[null,null,22,"Wet Pond","PRE","RE",{"$f":"Interpolation_Cubic(curve_WetPond_PSC,curve_WetPond_TP,G$91)","v":0.37829172049736742},0.63,0.63,0.63,0.63]
[null,null,23,"Biofiltration","NRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_PSC,curve_Biofilt_TN,G$91)","v":0.23512153137673517},0.4,0.4,0.4,0.4]
[null,null,24,"Dry Pond","NRE","RE",{"$f":"Interpolation_Cubic(curve_DryPond_PSC,curve_DryPond_TN,G$91)","v":5.9667590950306403E-2},0.23130158730158731,0.23130158730158731,0.23130158730158731,0.23130158730158731]
[null,null,25,"Enhanced Biofiltration With ISR","NRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_ISR_PSC,curve_Biofilt_ISR_TN,G$91)","v":0.59086515915226467},0.86,0.86,0.86,0.86]
[null,null,26,"Grass Swale","NRE","RE",{"$f":"Interpolation_Cubic(curve_GrassSwale_PSC,curve_GrassSwale_TN,G$91)","v":5.9667590950306403E-2},0.23130158730158731,0.23130158730158731,0.23130158730158731,0.23130158730158731]
[null,null,27,"IC Disconnection","NRE","RE",{"$f":"Interpolation_Bicubic(curve_ICDisc_TN,G$95,G$90)","v":4.906281182185455E+20},{"$f":"Interpolation_Bicubic(curve_ICDisc_TN,H$95,H$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TN,I$95,I$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TN,J$95,J$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TN,K$95,K$90)","v":8403585.450000003}]
[null,null,28,"Infiltration Basin","NRE","RE",{"$f":"Interpolation_Bicubic(curve_InfBasin_TN,G$91,G$89)","v":0.89793279531198233},{"$f":"Interpolation_Bicubic(curve_InfBasin_TN,H$91,H$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TN,I$91,I$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TN,J$91,J$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TN,K$91,K$89)","v":1.0000224113464355}]
[null,null,29,"Infiltration Trench","NRE","RE",{"$f":"Interpolation_Bicubic(curve_InfTrench_TN,G$91,G$89)","v":0.90781363481278654},{"$f":"Interpolation_Bicubic(curve_InfTrench_TN,H$91,H$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TN,I$91,I$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TN,J$91,J$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TN,K$91,K$89)","v":1.0000224113464355}]
[null,null,30,"Porous Pavement","NRE","RE",{"$f":"Interpolation_Cubic(curve_PorPave_PSC,curve_PorPave_TN,G$91)","v":3.5516352425491601E-2},0.16808205409356727,0.16808205409356727,0.16808205409356727,0.16808205409356727]
[null,null,31,"Sand Filter","NRE","RE",{"$f":"Interpolation_Cubic(curve_Sand_PSC,curve_Sand_TN,G$91)","v":0.23512153137673517},0.4,0.4,0.4,0.4]
[null,null,32,"Subsurface Gravel Wetland","NRE","RE",{"$f":"Interpolation_Cubic(curve_SubGravWet_PSC,curve_SubGravWet_TN,G$91)","v":0.49141097475164647},0.79,0.79,0.79,0.79]
[null,null,33,"Wet Pond","NRE","RE",{"$f":"Interpolation_Cubic(curve_WetPond_PSC,curve_WetPond_TN,G$91)","v":0.23512153137673517},0.4,0.4,0.4,0.4]
[null,null,34,"Biofiltration","TSSRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_PSC,curve_Biofilt_TSS,G$91)","v":0.92072953237013233},1,1,1,1]
[null,null,35,"Dry Pond","TSSRE","RE",{"$f":"Interpolation_Cubic(curve_DryPond_PSC,curve_DryPond_TSS,G$91)","v":0.38130087201954183},0.49,0.49,0.49,0.49]
[null,null,36,"Enhanced Biofiltration With ISR","TSSRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_ISR_PSC,curve_Biofilt_ISR_TSS,G$91)","v":0.92072953237013233},1,1,1,1]
[null,null,37,"Grass Swale","TSSRE","RE",{"$f":"Interpolation_Cubic(curve_GrassSwale_PSC,curve_GrassSwale_TSS,G$91)","v":0.62177816245780859},0.9,0.9,0.9,0.9]
[null,null,38,"IC Disconnection","TSSRE","RE",{"$f":"Interpolation_Bicubic(curve_ICDisc_TSS,G$95,G$90)","v":4.906281182185455E+20},{"$f":"Interpolation_Bicubic(curve_ICDisc_TSS,H$95,H$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TSS,I$95,I$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TSS,J$95,J$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TSS,K$95,K$90)","v":8403585.450000003}]
[null,null,39,"Infiltration Basin","TSSRE","RE",{"$f":"Interpolation_Bicubic(curve_InfBasin_TSS,G$91,G$89)","v":0.95686860158166143},{"$f":"Interpolation_Bicubic(curve_InfBasin_TSS,H$91,H$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TSS,I$91,I$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TSS,J$91,J$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TSS,K$91,K$89)","v":1.0000224113464355}]
[null,null,40,"Infiltration Trench","TSSRE","RE",{"$f":"Interpolation_Bicubic(curve_InfTrench_TSS,G$91,G$89)","v":0.92298641226351175},{"$f":"Interpolation_Bicubic(curve_InfTrench_TSS,H$91,H$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TSS,I$91,I$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TSS,J$91,J$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TSS,K$91,K$89)","v":1.0000224113464355}]
[null,null,41,"Porous Pavement","TSSRE","RE",{"$f":"Interpolation_Cubic(curve_PorPave_PSC,curve_PorPavE_TSS,G$91)","v":4.2921314638911003E-2},0.20313307139376222,0.20313307139376222,0.20313307139376222,0.20313307139376222]
[null,null,42,"Sand Filter","TSSRE","RE",{"$f":"Interpolation_Cubic(curve_Sand_PSC,curve_Sand_TSS,G$91)","v":0.92072953237013233},1,1,1,1]
[null,null,43,"Subsurface Gravel Wetland","TSSRE","RE",{"$f":"Interpolation_Cubic(curve_SubGravWet_PSC,curve_SubGravWet_TSS,G$91)","v":0.83649303169452349},0.99,0.99,0.99,0.99]
[null,null,44,"Wet Pond","TSSRE","RE",{"$f":"Interpolation_Cubic(curve_WetPond_PSC,curve_WetPond_TSS,G$91)","v":0.61089299952268927},0.86,0.86,0.86,0.86]
[null,null,45,"Biofiltration","ZnRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_PSC,curve_Biofilt_TZn,G$91)","v":0.9523946373425024},0.99,0.99,0.99,0.99]
[null,null,46,"Dry Pond","ZnRE","RE",{"$f":"Interpolation_Cubic(curve_DryPond_PSC,curve_DryPond_TZn,G$91)","v":0.67951445423210588},0.76,0.76,0.76,0.76]
[null,null,47,"Enhanced Biofiltration With ISR","ZnRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_ISR_PSC,curve_Biofilt_ISR_TZn,G$91)","v":0.9523946373425024},0.99,0.99,0.99,0.99]
[null,null,48,"Grass Swale","ZnRE","RE",{"$f":"Interpolation_Cubic(curve_GrassSwale_PSC,curve_GrassSwale_TZn,G$91)","v":0.86910460758711905},0.99,0.99,0.99,0.99]
[null,null,49,"IC Disconnection","ZnRE","RE",{"$f":"Interpolation_Bicubic(curve_ICDisc_TZn,G$95,G$90)","v":4.906281182185455E+20},{"$f":"Interpolation_Bicubic(curve_ICDisc_TZn,H$95,H$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TZn,I$95,I$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TZn,J$95,J$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_TZn,K$95,K$90)","v":8403585.450000003}]
[null,null,50,"Infiltration Basin","ZnRE","RE",{"$f":"Interpolation_Bicubic(curve_InfBasin_TZn,G$91,G$89)","v":0.9829659095564891},{"$f":"Interpolation_Bicubic(curve_InfBasin_TZn,H$91,H$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TZn,I$91,I$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TZn,J$91,J$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfBasin_TZn,K$91,K$89)","v":1.0000224113464355}]
[null,null,51,"Infiltration Trench","ZnRE","RE",{"$f":"Interpolation_Bicubic(curve_InfTrench_TZn,G$91,G$89)","v":0.9829659095564891},{"$f":"Interpolation_Bicubic(curve_InfTrench_TZn,H$91,H$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TZn,I$91,I$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TZn,J$91,J$89)","v":1.0000224113464355},{"$f":"Interpolation_Bicubic(curve_InfTrench_TZn,K$91,K$89)","v":1.0000224113464355}]
[null,null,52,"Porous Pavement","ZnRE","RE",{"$f":"Interpolation_Cubic(curve_PorPave_PSC,curve_PorPave_TZn,G$91)","v":3.638333750084155E-2},0.17250167519493176,0.17250167519493176,0.17250167519493176,0.17250167519493176]
[null,null,53,"Sand Filter","ZnRE","RE",{"$f":"Interpolation_Cubic(curve_Sand_PSC,curve_Sand_TZn,G$91)","v":0.9523946373425024},0.99,0.99,0.99,0.99]
[null,null,54,"Subsurface Gravel Wetland","ZnRE","RE",{"$f":"Interpolation_Cubic(curve_SubGravWet_PSC,curve_SubGravWet_TZn,G$91)","v":0.84189941251774536},0.92,0.92,0.92,0.92]
[null,null,55,"Wet Pond","ZnRE","RE",{"$f":"Interpolation_Cubic(curve_WetPond_PSC,curve_WetPond_TZn,G$91)","v":0.80833952024863376},0.93,0.93,0.93,0.93]
[null,null,56,"Biofiltration","FIBRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_PSC,curve_Biofilt_FIB,G$91)","v":0.31265746150789453},0.747,0.747,0.747,0.747]
[null,null,57,"Dry Pond","FIBRE","RE",{"$f":"Interpolation_Cubic(curve_DryPond_PSC,curve_DryPond_FIB,G$91)","v":9.1123852923199686E-4},4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2]
[null,null,58,"Enhanced Biofiltration With ISR","FIBRE","RE",{"$f":"Interpolation_Cubic(curve_Biofilt_ISR_PSC,curve_Biofilt_ISR_FIB,G$91)","v":0.65504275137529488},0.91290000000000004,0.91290000000000004,0.91290000000000004,0.91290000000000004]
[null,null,59,"Grass Swale","FIBRE","RE",{"$f":"Interpolation_Cubic(curve_GrassSwale_PSC,curve_GrassSwale_FIB,G$91)","v":0},0,0,0,0]
[null,null,60,"IC Disconnection","FIBRE","RE",{"$f":"Interpolation_Bicubic(curve_ICDisc_FIB,G$95,G$90)","v":4.906281182185455E+20},{"$f":"Interpolation_Bicubic(curve_ICDisc_FIB,H$95,H$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_FIB,I$95,I$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_FIB,J$95,J$90)","v":8403585.450000003},{"$f":"Interpolation_Bicubic(curve_ICDisc_FIB,K$95,K$90)","v":8403585.450000003}]
[null,null,61,"Infiltration Basin","FIBRE","RE",{"$f":"Interpolation_Bicubic(curve_InfBasin_FIB,G$91,G$89)","v":0.75188195952112169},{"$f":"Interpolation_Bicubic(curve_InfBasin_FIB,H$91,H$89)","v":-59991239.733140856},{"$f":"Interpolation_Bicubic(curve_InfBasin_FIB,I$91,I$89)","v":-59991239.733140856},{"$f":"Interpolation_Bicubic(curve_InfBasin_FIB,J$91,J$89)","v":-59991239.733140856},{"$f":"Interpolation_Bicubic(curve_InfBasin_FIB,K$91,K$89)","v":-59991239.733140856}]
[null,null,62,"Infiltration Trench","FIBRE","RE",{"$f":"Interpolation_Bicubic(curve_InfTrench_FIB,G$91,G$89)","v":0.62386586067998218},{"$f":"Interpolation_Bicubic(curve_InfTrench_FIB,H$91,H$89)","v":-104011118.0360429},{"$f":"Interpolation_Bicubic(curve_InfTrench_FIB,I$91,I$89)","v":-104011118.0360429},{"$f":"Interpolation_Bicubic(curve_InfTrench_FIB,J$91,J$89)","v":-104011118.0360429},{"$f":"Interpolation_Bicubic(curve_InfTrench_FIB,K$91,K$89)","v":-104011118.0360429}]
[null,null,63,"Porous Pavement","FIBRE","RE",{"$f":"Interpolation_Cubic(curve_PorPave_PSC,curve_PorPave_FIB,G$91)","v":0},0,0,0,0]
[null,null,64,"Sand Filter","FIBRE","RE",{"$f":"Interpolation_Cubic(curve_Sand_PSC,curve_Sand_FIB,G$91)","v":0.73534507519415537},0.91900000000000004,0.91900000000000004,0.91900000000000004,0.91900000000000004]
[null,null,65,"Subsurface Gravel Wetland","FIBRE","RE",{"$f":"Interpolation_Cubic(curve_SubGravWet_PSC,curve_SubGravWet_FIB,G$91)","v":0.66627398023070317},0.80669999999999997,0.80669999999999997,0.80669999999999997,0.80669999999999997]
[null,null,66,"Wet Pond","FIBRE","RE",{"$f":"Interpolation_Cubic(curve_WetPond_PSC,curve_WetPond_FIB,G$91)","v":0.3988949777164213},0.79200000000000004,0.79200000000000004,0.79200000000000004,0.79200000000000004]
[]
[null,"base cost/DSV",null,"x1 Costs",null,"$/DSV/yr",{"$f":"IFERROR(VLOOKUP(G$10,table_SCM_appcurve_costs_OM,3,FALSE),\"\")","v":15.870222769869997},{"$f":"IFERROR(VLOOKUP(H$10,table_SCM_appcurve_costs_OM,3,FALSE),\"\")","v":""},"","",""]
[null,"base hr/IA",null,"Estimated O&M Hours",null,"hr/yr",{"$f":"IFERROR(VLOOKUP(G$10,table_SCM_appcurve_costs_OM,4,FALSE),\"\")","v":20.7},"","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Conditional Formatting of inputs by SCM",null,"row of table"]
["True values return orange input conditional formatting",null,null,"Infiltration Rate (0.17-8.27)","IR","in/hr",{"$f":"IF(OR(G$11='Tables (hidden_locked)'!$Q$21,G$11='Tables (hidden_locked)'!$Q$22),TRUE,0)","v":true},{"$f":"IF(OR(H$11='Tables (hidden_locked)'!$Q$21,H$11='Tables (hidden_locked)'!$Q$22),TRUE,0)","v":0},{"$f":"IF(OR(I$11='Tables (hidden_locked)'!$Q$21,I$11='Tables (hidden_locked)'!$Q$22),TRUE,0)","v":0},{"$f":"IF(OR(J$11='Tables (hidden_locked)'!$Q$21,J$11='Tables (hidden_locked)'!$Q$22),TRUE,0)","v":0},{"$f":"IF(OR(K$11='Tables (hidden_locked)'!$Q$21,K$11='Tables (hidden_locked)'!$Q$22),TRUE,0)","v":0}]
[]
[null,null,null,"Width at top @ Dmax","WDmax",2,{"$f":"IFERROR(IF(HLOOKUP(G$10, table_cond_format,$F178,FALSE),TRUE,0),0)","v":0},{"$f":"IFERROR(IF(HLOOKUP(H$10, table_cond_format,$F178,FALSE),TRUE,0),0)","v":0},0,0,0]
[null,null,null,"Width at bed","Wbottom",3,0,0,0,0,0]
[null,null,null,"Area of pretreatment","Apretreatment",4,0,0,0,0,0]
[null,null,null,"Depth of pretreatment","Dpretreatment",5,0,0,0,0,0]
[null,null,null,"Depth of filter course","DFC",6,0,0,0,0,0]
[null,null,null,"Area of pond","Apond",7,true,0,0,0,0]
[null,null,null,"Depth of ponding","Dponding",8,true,0,0,0,0]
[null,null,null,"Area of media","Asoil",9,true,0,0,0,0]
[null,null,null,"Depth of media","Dsoil",10,true,0,0,0,0]
[null,null,null,"Porosity of media (typical 0.2)","ηsoil",11,true,0,0,0,0]
[null,null,null,"Area of ISR","AISR",12,{"$f":"IFERROR(IF(HLOOKUP(G$10, table_cond_format,$F188,FALSE),TRUE,0),0)","v":0},0,0,0,0]
[null,null,null,"Depth of gravel/stone","Dgravel",13,0,0,0,0,0]
[null,null,null,"Porosity of gravel/stone (typical 0.4)","ηgravel",14,0,0,0,0,0]
[null,null,null,"Area of sand","Asand",15,0,0,0,0,0]
[null,null,null,"Depth of sand","Dsand",16,0,0,0,0,0]
[null,null,null,"Porosity of sand (typical 0.3)","ηsand",17,0,0,0,0,0]
[null,null,null,"Area cross-section of galley/chambers/pipes (total)","Ax-section galley",18,0,0,0,0,0]
[null,null,null,"Width","W",19,0,0,0,0,0]
[null,null,null,"Length","L",20,0,0,0,0,0]
[null,null,null,"Pervious area","Aperv",21,0,0,0,0,0]
[null,null,null,"Pervious Hydrologic Soil Group","HSGperv",22,0,0,0,0,0]
[]
[]
[]
[null,null,null,"min",0.1]
[null,null,null,"min txt","DSV too small, increase for PSC > 0.1"]
[null,null,null,"low range",0.3]
[null,null,null,"low range txt","DSV small, increase for optimal range 0.3 ≤ PSC ≤ 0.6"]
[null,null,null,"optimal range",0.6]
[null,null,null,"optimal range txt","PSC in optimal range 0.3 ≤ PSC ≤ 0.6"]
[null,null,null,"too large",2]
[null,null,null,"too large txt"," "]
[null,null,null,"way too large txt","Max credit for PSC = 2"]
["ignore if IC disc, then lookup if PPw/liner, then DSV/WQV",null,null,"Physical Storage Capacity: Depth of Runoff  from IA\n(range of 0 - 2, goal > 0.1, optimal 0.4)","PSC","in",{"$f":"IF(NOT(ISNUMBER(G40)),\"\",IF(G40<$E$202,$E$203,IF(G40<$E$204,$E$205,IF(G40<=$E$206,$E$207,IF(G40<=$E$208,$E$209,$E$210)))))","v":"PSC in optimal range 0.3 ≤ PSC ≤ 0.6"},{"$f":"IF(NOT(ISNUMBER(H40)),\"\",IF(H40<$E$202,$E$203,IF(H40<$E$204,$E$205,IF(H40<=$E$206,$E$207,IF(H40<=$E$208,$E$209,$E$210)))))","v":""},"","",""]

{"sheet":"Input_Design_Output","index":8,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[65,2,65,3],[66,2,66,3],[1,0,12,0],[14,0,34,0],[1,1,6,1],[7,1,8,1],[9,1,12,1],[14,1,34,1],[37,0,63,0],[41,1,46,1],[47,1,51,1],[52,1,56,1],[57,1,62,1],[37,1,40,1]]}
[null,"Notes","Parameter","Abbrev.","Units","SCM 1","SCM 2","SCM 3","SCM 4","SCM 5"]
["Input: \nSite & SCM","Site","ID",null,null,"Example Bioretention"]
[null,null,"Date",null,null,"2021-07-01"]
[null,null,"Location"]
[null,null,"Description/Notes"]
[null,null,"Costs Multiplier (Recommended 1-3)",null,null,2]
[null,null,"Location (for FIB)",null,null,"Inland"]
[null,"Watershed","Impervious Drainage Area","IA","ac",{"$f":"1*0.84","v":0.84}]
[null,null,"Land Use","LU","-","Medium-Density Residential"]
[null,"Stormwater Control Measure","Stormwater Control Measure","SCM","-","Bioretention/Rain Garden  (no underdrains)"]
[null,null,"Applicable Performance Curve (See Crosswalk)","-","-",{"$f":"'Calcs (hidden_locked)'!G11","v":"Infiltration Basin"},{"$f":"'Calcs (hidden_locked)'!H11","v":""},{"$f":"'Calcs (hidden_locked)'!I11","v":""},{"$f":"'Calcs (hidden_locked)'!J11","v":""},{"$f":"'Calcs (hidden_locked)'!K11","v":""}]
[null,null,"Infiltration Rate (0.17-8.27)","IR","in/hr",0.52]
[null,null,"Known DSV (to skip design section below, or blank)","DSV","cf"]
[]
["Input: \nSCM Design","SCM Design Specifications: DSV is calculated from orange Input cells only.\n\nFormulas, Goal Seek, and Solver may be used in any cell.\n","Width at top @ Dmax","WDmax","ft"]
[null,null,"Width at bed","Wbottom","ft"]
[null,null,"Area of pretreatment","Apretreatment","sf"]
[null,null,"Depth of pretreatment","Dpretreatment","ft"]
[null,null,"Depth of filter course","DFC","ft"]
[null,null,"Area of pond","Apond","sf",800]
[null,null,"Depth of ponding","Dponding","ft",1]
[null,null,"Area of media","Asoil","sf",800]
[null,null,"Depth of media","Dsoil","ft",3]
[null,null,"Porosity of media (recommended 0.2)","ηsoil","-",0.2]
[null,null,"Area of ISR","AISR","sf"]
[null,null,"Depth of gravel/stone","Dgravel","ft"]
[null,null,"Porosity of gravel/stone (recommended 0.4)","ηgravel","-"]
[null,null,"Area of sand","Asand","sf"]
[null,null,"Depth of sand","Dsand","ft"]
[null,null,"Porosity of sand (recommended 0.3)","ηsand","-"]
[null,null,"Area cross-section of galley/chambers/pipes","Ax-section galley","sf"]
[null,null,"Width","W","ft",40]
[null,null,"Length","L","ft",20]
[null,null,"Pervious area","Aperv","ac"]
[null,null,"Pervious Hydrologic Soil Group","HSGperv","-"]
[]
[]
["Output","Intermediate Calculations","Design Storage Volume","DSV","cf",{"$f":"'Calcs (hidden_locked)'!G38","v":1280},{"$f":"'Calcs (hidden_locked)'!H38","v":""},{"$f":"'Calcs (hidden_locked)'!I38","v":""},{"$f":"'Calcs (hidden_locked)'!J38","v":""},{"$f":"'Calcs (hidden_locked)'!K38","v":""}]
[null,null,"Impervious to Pervious Ratio\n(range of 0.014 - 8)","IA/PC","ac/ac",{"$f":"'Calcs (hidden_locked)'!G39","v":"N/A"},{"$f":"'Calcs (hidden_locked)'!H39","v":""},{"$f":"'Calcs (hidden_locked)'!I39","v":""},{"$f":"'Calcs (hidden_locked)'!J39","v":""},{"$f":"'Calcs (hidden_locked)'!K39","v":""}]
[null,null,"Physical Storage Capacity: Depth of Runoff  from IA\n(range of 0 - 2, goal > 0.1, optimal 0.4)","PSC","in",{"$f":"'Calcs (hidden_locked)'!G40","v":0.41978223796405617},{"$f":"'Calcs (hidden_locked)'!H40","v":""},{"$f":"'Calcs (hidden_locked)'!I40","v":""},{"$f":"'Calcs (hidden_locked)'!J40","v":""},{"$f":"'Calcs (hidden_locked)'!K40","v":""}]
[null,null,"PSC Notes",null,null,{"$f":"'Calcs (hidden_locked)'!G211","v":"PSC in optimal range 0.3 ≤ PSC ≤ 0.6"},{"$f":"'Calcs (hidden_locked)'!H211","v":""},{"$f":"'Calcs (hidden_locked)'!I211","v":""},{"$f":"'Calcs (hidden_locked)'!J211","v":""},{"$f":"'Calcs (hidden_locked)'!K211","v":""}]
[null,"Performance Curve Removal Efficiencies","Removal Efficiency: Volume","VolRE","-",{"$f":"'Calcs (hidden_locked)'!G41","v":0.59760686218543724},{"$f":"'Calcs (hidden_locked)'!H41","v":""},{"$f":"'Calcs (hidden_locked)'!I41","v":""},{"$f":"'Calcs (hidden_locked)'!J41","v":""},{"$f":"'Calcs (hidden_locked)'!K41","v":""}]
[null,null,"Removal Efficiency: P","PRE","-",{"$f":"'Calcs (hidden_locked)'!G42","v":0.78381371113356024},{"$f":"'Calcs (hidden_locked)'!H42","v":""},{"$f":"'Calcs (hidden_locked)'!I42","v":""},{"$f":"'Calcs (hidden_locked)'!J42","v":""},{"$f":"'Calcs (hidden_locked)'!K42","v":""}]
[null,null,"Removal Efficiency: N","NRE","-",{"$f":"'Calcs (hidden_locked)'!G43","v":0.89793279531198233},{"$f":"'Calcs (hidden_locked)'!H43","v":""},{"$f":"'Calcs (hidden_locked)'!I43","v":""},{"$f":"'Calcs (hidden_locked)'!J43","v":""},{"$f":"'Calcs (hidden_locked)'!K43","v":""}]
[null,null,"Removal Efficiency: TSS","TSSRE","-",{"$f":"'Calcs (hidden_locked)'!G44","v":0.95686860158166143},{"$f":"'Calcs (hidden_locked)'!H44","v":""},{"$f":"'Calcs (hidden_locked)'!I44","v":""},{"$f":"'Calcs (hidden_locked)'!J44","v":""},{"$f":"'Calcs (hidden_locked)'!K44","v":""}]
[null,null,"Removal Efficiency: Zn","ZnRE","-",{"$f":"'Calcs (hidden_locked)'!G45","v":0.9829659095564891},{"$f":"'Calcs (hidden_locked)'!H45","v":""},{"$f":"'Calcs (hidden_locked)'!I45","v":""},{"$f":"'Calcs (hidden_locked)'!J45","v":""},{"$f":"'Calcs (hidden_locked)'!K45","v":""}]
[null,null,"Removal Efficiency: Bacteria","FIBRE","-",{"$f":"'Calcs (hidden_locked)'!G46","v":0.75188195952112169},{"$f":"'Calcs (hidden_locked)'!H46","v":""},{"$f":"'Calcs (hidden_locked)'!I46","v":""},{"$f":"'Calcs (hidden_locked)'!J46","v":""},{"$f":"'Calcs (hidden_locked)'!K46","v":""}]
[null,"Loading Rates","Load: Volume","VolLER","Mgal/yr",{"$f":"'Calcs (hidden_locked)'!G47","v":0.87955008261119993},{"$f":"'Calcs (hidden_locked)'!H47","v":""},{"$f":"'Calcs (hidden_locked)'!I47","v":""},{"$f":"'Calcs (hidden_locked)'!J47","v":""},{"$f":"'Calcs (hidden_locked)'!K47","v":""}]
[null,null,"Load: P","PLER","lb/yr",{"$f":"'Calcs (hidden_locked)'!G48","v":1.6463999999999999},{"$f":"'Calcs (hidden_locked)'!H48","v":""},{"$f":"'Calcs (hidden_locked)'!I48","v":""},{"$f":"'Calcs (hidden_locked)'!J48","v":""},{"$f":"'Calcs (hidden_locked)'!K48","v":""}]
[null,null,"Load: N","NLER","lb/yr",{"$f":"'Calcs (hidden_locked)'!G49","v":11.843999999999999},{"$f":"'Calcs (hidden_locked)'!H49","v":""},{"$f":"'Calcs (hidden_locked)'!I49","v":""},{"$f":"'Calcs (hidden_locked)'!J49","v":""},{"$f":"'Calcs (hidden_locked)'!K49","v":""}]
[null,null,"Load: TSS","TSSLER","lb/yr",{"$f":"'Calcs (hidden_locked)'!G50","v":368.76},{"$f":"'Calcs (hidden_locked)'!H50","v":""},{"$f":"'Calcs (hidden_locked)'!I50","v":""},{"$f":"'Calcs (hidden_locked)'!J50","v":""},{"$f":"'Calcs (hidden_locked)'!K50","v":""}]
[null,null,"Load: Bacteria","FIBLER","Billion MPN/yr",{"$f":"'Calcs (hidden_locked)'!G51","v":5.3760000000000003},{"$f":"'Calcs (hidden_locked)'!H51","v":""},{"$f":"'Calcs (hidden_locked)'!I51","v":""},{"$f":"'Calcs (hidden_locked)'!J51","v":""},{"$f":"'Calcs (hidden_locked)'!K51","v":""}]
[null,"Reductions","Reduction: Volume","VolRed","Mgal/yr",{"$f":"'Calcs (hidden_locked)'!G52","v":0.5256251650042213},{"$f":"'Calcs (hidden_locked)'!H52","v":""},{"$f":"'Calcs (hidden_locked)'!I52","v":""},{"$f":"'Calcs (hidden_locked)'!J52","v":""},{"$f":"'Calcs (hidden_locked)'!K52","v":""}]
[null,null,"Reduction: P","PRed","lb/yr",{"$f":"'Calcs (hidden_locked)'!G53","v":1.2904708940102936},{"$f":"'Calcs (hidden_locked)'!H53","v":""},{"$f":"'Calcs (hidden_locked)'!I53","v":""},{"$f":"'Calcs (hidden_locked)'!J53","v":""},{"$f":"'Calcs (hidden_locked)'!K53","v":""}]
[null,null,"Reduction: N","NRed","lb/yr",{"$f":"'Calcs (hidden_locked)'!G54","v":10.635116027675119},{"$f":"'Calcs (hidden_locked)'!H54","v":""},{"$f":"'Calcs (hidden_locked)'!I54","v":""},{"$f":"'Calcs (hidden_locked)'!J54","v":""},{"$f":"'Calcs (hidden_locked)'!K54","v":""}]
[null,null,"Reduction: TSS","TSSRed","lb/yr",{"$f":"'Calcs (hidden_locked)'!G55","v":352.85486551925345},{"$f":"'Calcs (hidden_locked)'!H55","v":""},{"$f":"'Calcs (hidden_locked)'!I55","v":""},{"$f":"'Calcs (hidden_locked)'!J55","v":""},{"$f":"'Calcs (hidden_locked)'!K55","v":""}]
[null,null,"Reduction: Bacteria","FIBRed","%/yr",{"$f":"'Calcs (hidden_locked)'!G56","v":0.75188195952112169},{"$f":"'Calcs (hidden_locked)'!H56","v":""},{"$f":"'Calcs (hidden_locked)'!I56","v":""},{"$f":"'Calcs (hidden_locked)'!J56","v":""},{"$f":"'Calcs (hidden_locked)'!K56","v":""}]
[null,"Costs","Estimated Total Costs",null,"$",{"$f":"'Calcs (hidden_locked)'!G57","v":41000},{"$f":"'Calcs (hidden_locked)'!H57","v":""},{"$f":"'Calcs (hidden_locked)'!I57","v":""},{"$f":"'Calcs (hidden_locked)'!J57","v":""},{"$f":"'Calcs (hidden_locked)'!K57","v":""}]
[null,null,"Removal Costs: Volume",null,"$/Mgal-yr",{"$f":"'Calcs (hidden_locked)'!G58","v":78000},{"$f":"'Calcs (hidden_locked)'!H58","v":""},{"$f":"'Calcs (hidden_locked)'!I58","v":""},{"$f":"'Calcs (hidden_locked)'!J58","v":""},{"$f":"'Calcs (hidden_locked)'!K58","v":""}]
[null,null,"Removal Costs: P",null,"$/lb-yr",{"$f":"'Calcs (hidden_locked)'!G59","v":31770},{"$f":"'Calcs (hidden_locked)'!H59","v":""},{"$f":"'Calcs (hidden_locked)'!I59","v":""},{"$f":"'Calcs (hidden_locked)'!J59","v":""},{"$f":"'Calcs (hidden_locked)'!K59","v":""}]
[null,null,"Removal Costs: N",null,"$/lb-yr",{"$f":"'Calcs (hidden_locked)'!G60","v":3860},{"$f":"'Calcs (hidden_locked)'!H60","v":""},{"$f":"'Calcs (hidden_locked)'!I60","v":""},{"$f":"'Calcs (hidden_locked)'!J60","v":""},{"$f":"'Calcs (hidden_locked)'!K60","v":""}]
[null,null,"Removal Costs: TSS",null,"$/lb-yr",{"$f":"'Calcs (hidden_locked)'!G61","v":120},{"$f":"'Calcs (hidden_locked)'!H61","v":""},{"$f":"'Calcs (hidden_locked)'!I61","v":""},{"$f":"'Calcs (hidden_locked)'!J61","v":""},{"$f":"'Calcs (hidden_locked)'!K61","v":""}]
[null,null,"Removal Costs: Bacteria",null,"$/%-yr",{"$f":"'Calcs (hidden_locked)'!G62","v":550},{"$f":"'Calcs (hidden_locked)'!H62","v":""},{"$f":"'Calcs (hidden_locked)'!I62","v":""},{"$f":"'Calcs (hidden_locked)'!J62","v":""},{"$f":"'Calcs (hidden_locked)'!K62","v":""}]
[null,"O&M","Estimated O&M Hours",null,"hr/yr",{"$f":"'Calcs (hidden_locked)'!G63","v":17.387999999999998},{"$f":"'Calcs (hidden_locked)'!H63","v":""},{"$f":"'Calcs (hidden_locked)'!I63","v":""},{"$f":"'Calcs (hidden_locked)'!J63","v":""},{"$f":"'Calcs (hidden_locked)'!K63","v":""}]
[]
[null,null,"MS4 Permit SCM Performance Calculator\nVersion 2.2 - Updated July 2021\nUNH Stormwater Center"]
[null,null,"https://www.unh.edu/unhsc/"]

{"sheet":"Output_Summary","index":9,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[26,0,30,0],[3,0,6,0],[1,0,1,9],[31,0,36,0],[0,0,0,9],[15,0,20,0],[21,0,25,0],[7,0,8,0],[9,0,11,0]]}
[]
["Summary Output\nUNHSC Performance Curve Calculator v2.2"]
[null,"Parameter","Abbrev.","Units","SCM 1","SCM 2","SCM 3","SCM 4","SCM 5","TOTAL"]
["Location","ID","-","-",{"$f":"IF(ISBLANK(Input_Design_Output!F2),\"\",Input_Design_Output!F2)","v":"Example Bioretention"},{"$f":"IF(ISBLANK(Input_Design_Output!G2),\"\",Input_Design_Output!G2)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H2),\"\",Input_Design_Output!H2)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I2),\"\",Input_Design_Output!I2)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J2),\"\",Input_Design_Output!J2)","v":""}]
[null,"Date","-","-",{"$f":"IF(ISBLANK(Input_Design_Output!F3),\"\",Input_Design_Output!F3)","v":"2021-07-01"},{"$f":"IF(ISBLANK(Input_Design_Output!G3),\"\",Input_Design_Output!G3)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H3),\"\",Input_Design_Output!H3)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I3),\"\",Input_Design_Output!I3)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J3),\"\",Input_Design_Output!J3)","v":""}]
[null,"Location","-","-",{"$f":"IF(ISBLANK(Input_Design_Output!F4),\"\",Input_Design_Output!F4)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G4),\"\",Input_Design_Output!G4)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H4),\"\",Input_Design_Output!H4)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I4),\"\",Input_Design_Output!I4)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J4),\"\",Input_Design_Output!J4)","v":""}]
[null,"Description/Notes","-","-",{"$f":"IF(ISBLANK(Input_Design_Output!F5),\"\",Input_Design_Output!F5)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!G5),\"\",Input_Design_Output!G5)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H5),\"\",Input_Design_Output!H5)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I5),\"\",Input_Design_Output!I5)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J5),\"\",Input_Design_Output!J5)","v":""}]
["Watershed","Impervious Drainage Area","IA","ac",{"$f":"IF(ISBLANK(Input_Design_Output!F8),\"\",Input_Design_Output!F8)","v":0.84},{"$f":"IF(ISBLANK(Input_Design_Output!G8),\"\",Input_Design_Output!G8)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H8),\"\",Input_Design_Output!H8)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I8),\"\",Input_Design_Output!I8)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J8),\"\",Input_Design_Output!J8)","v":""},{"$f":"SUM(E8:I8)","v":0.84}]
[null,"Land Use","LU","-",{"$f":"IF(ISBLANK(Input_Design_Output!F9),\"\", VLOOKUP(Input_Design_Output!F9,table_PLER_abb,8,FALSE))","v":"Med Res."},{"$f":"IF(ISBLANK(Input_Design_Output!G9),\"\", VLOOKUP(Input_Design_Output!G9,table_PLER_abb,8,FALSE))","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H9),\"\", VLOOKUP(Input_Design_Output!H9,table_PLER_abb,8,FALSE))","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I9),\"\", VLOOKUP(Input_Design_Output!I9,table_PLER_abb,8,FALSE))","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J9),\"\", VLOOKUP(Input_Design_Output!J9,table_PLER_abb,8,FALSE))","v":""}]
["SCM","Stormwater Control Measure","SCM","-",{"$f":"IF(ISBLANK(Input_Design_Output!F10),\"\",Input_Design_Output!F10)","v":"Bioretention/Rain Garden  (no underdrains)"},{"$f":"IF(ISBLANK(Input_Design_Output!G10),\"\",Input_Design_Output!G10)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H10),\"\",Input_Design_Output!H10)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I10),\"\",Input_Design_Output!I10)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J10),\"\",Input_Design_Output!J10)","v":""}]
[null,"Applicable Performance Curve","-","-",{"$f":"IF(ISBLANK(Input_Design_Output!F11),\"\",Input_Design_Output!F11)","v":"Infiltration Basin"},{"$f":"IF(ISBLANK(Input_Design_Output!G11),\"\",Input_Design_Output!G11)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H11),\"\",Input_Design_Output!H11)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I11),\"\",Input_Design_Output!I11)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J11),\"\",Input_Design_Output!J11)","v":""}]
[null,"Infiltration Rate","IR","in/hr",{"$f":"IF(ISBLANK(Input_Design_Output!F12),\"\",Input_Design_Output!F12)","v":0.52},{"$f":"IF(ISBLANK(Input_Design_Output!G12),\"\",Input_Design_Output!G12)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H12),\"\",Input_Design_Output!H12)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I12),\"\",Input_Design_Output!I12)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J12),\"\",Input_Design_Output!J12)","v":""}]
["Intermediate Calculations","Design Storage Volume","DSV","cf",{"$f":"IF(ISBLANK(Input_Design_Output!F38),\"\",Input_Design_Output!F38)","v":1280},{"$f":"IF(ISBLANK(Input_Design_Output!G38),\"\",Input_Design_Output!G38)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H38),\"\",Input_Design_Output!H38)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I38),\"\",Input_Design_Output!I38)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J38),\"\",Input_Design_Output!J38)","v":""}]
[null,"Impervious to Pervious Ratio","IA/perv","ac/ac",{"$f":"IF(ISBLANK(Input_Design_Output!F39),\"\",Input_Design_Output!F39)","v":"N/A"},{"$f":"IF(ISBLANK(Input_Design_Output!G39),\"\",Input_Design_Output!G39)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H39),\"\",Input_Design_Output!H39)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I39),\"\",Input_Design_Output!I39)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J39),\"\",Input_Design_Output!J39)","v":""}]
[null,"Physical Storage Capacity","PSC","in",{"$f":"IF(ISBLANK(Input_Design_Output!F40),\"\",Input_Design_Output!F40)","v":0.41978223796405617},{"$f":"IF(ISBLANK(Input_Design_Output!G40),\"\",Input_Design_Output!G40)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H40),\"\",Input_Design_Output!H40)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I40),\"\",Input_Design_Output!I40)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J40),\"\",Input_Design_Output!J40)","v":""}]
["Performance Curve Removal Efficiencies","Volume","VolRE","%",{"$f":"IF(ISBLANK(Input_Design_Output!F42),\"\",Input_Design_Output!F42)","v":0.59760686218543724},{"$f":"IF(ISBLANK(Input_Design_Output!G42),\"\",Input_Design_Output!G42)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H42),\"\",Input_Design_Output!H42)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I42),\"\",Input_Design_Output!I42)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J42),\"\",Input_Design_Output!J42)","v":""}]
[null,"P","PRE","%",{"$f":"IF(ISBLANK(Input_Design_Output!F43),\"\",Input_Design_Output!F43)","v":0.78381371113356024},{"$f":"IF(ISBLANK(Input_Design_Output!G43),\"\",Input_Design_Output!G43)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H43),\"\",Input_Design_Output!H43)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I43),\"\",Input_Design_Output!I43)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J43),\"\",Input_Design_Output!J43)","v":""}]
[null,"N","NRE","%",{"$f":"IF(ISBLANK(Input_Design_Output!F44),\"\",Input_Design_Output!F44)","v":0.89793279531198233},{"$f":"IF(ISBLANK(Input_Design_Output!G44),\"\",Input_Design_Output!G44)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H44),\"\",Input_Design_Output!H44)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I44),\"\",Input_Design_Output!I44)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J44),\"\",Input_Design_Output!J44)","v":""}]
[null,"TSS","TSSRE","%",{"$f":"IF(ISBLANK(Input_Design_Output!F45),\"\",Input_Design_Output!F45)","v":0.95686860158166143},{"$f":"IF(ISBLANK(Input_Design_Output!G45),\"\",Input_Design_Output!G45)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H45),\"\",Input_Design_Output!H45)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I45),\"\",Input_Design_Output!I45)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J45),\"\",Input_Design_Output!J45)","v":""}]
[null,"Zn","ZnRE","%",{"$f":"IF(ISBLANK(Input_Design_Output!F46),\"\",Input_Design_Output!F46)","v":0.9829659095564891},{"$f":"IF(ISBLANK(Input_Design_Output!G46),\"\",Input_Design_Output!G46)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H46),\"\",Input_Design_Output!H46)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I46),\"\",Input_Design_Output!I46)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J46),\"\",Input_Design_Output!J46)","v":""}]
[null,"Bacteria","FIBRE","%",{"$f":"IF(ISBLANK(Input_Design_Output!F47),\"\",Input_Design_Output!F47)","v":0.75188195952112169},{"$f":"IF(ISBLANK(Input_Design_Output!G47),\"\",Input_Design_Output!G47)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H47),\"\",Input_Design_Output!H47)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I47),\"\",Input_Design_Output!I47)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J47),\"\",Input_Design_Output!J47)","v":""}]
["Load Export Rates","Volume","VolLER","Mgal/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F48),\"\",Input_Design_Output!F48)","v":0.87955008261119993},{"$f":"IF(ISBLANK(Input_Design_Output!G48),\"\",Input_Design_Output!G48)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H48),\"\",Input_Design_Output!H48)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I48),\"\",Input_Design_Output!I48)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J48),\"\",Input_Design_Output!J48)","v":""},{"$f":"SUM(E22:I22)","v":0.87955008261119993}]
[null,"P","PLER","lb/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F49),\"\",Input_Design_Output!F49)","v":1.6463999999999999},{"$f":"IF(ISBLANK(Input_Design_Output!G49),\"\",Input_Design_Output!G49)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H49),\"\",Input_Design_Output!H49)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I49),\"\",Input_Design_Output!I49)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J49),\"\",Input_Design_Output!J49)","v":""},1.6463999999999999]
[null,"N","NLER","lb/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F50),\"\",Input_Design_Output!F50)","v":11.843999999999999},{"$f":"IF(ISBLANK(Input_Design_Output!G50),\"\",Input_Design_Output!G50)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H50),\"\",Input_Design_Output!H50)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I50),\"\",Input_Design_Output!I50)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J50),\"\",Input_Design_Output!J50)","v":""},11.843999999999999]
[null,"TSS","TSSLER","lb/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F51),\"\",Input_Design_Output!F51)","v":368.76},{"$f":"IF(ISBLANK(Input_Design_Output!G51),\"\",Input_Design_Output!G51)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H51),\"\",Input_Design_Output!H51)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I51),\"\",Input_Design_Output!I51)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J51),\"\",Input_Design_Output!J51)","v":""},368.76]
[null,"Bacteria","FIBLER","Billion MPN/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F52),\"\",Input_Design_Output!F52)","v":5.3760000000000003},{"$f":"IF(ISBLANK(Input_Design_Output!G52),\"\",Input_Design_Output!G52)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H52),\"\",Input_Design_Output!H52)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I52),\"\",Input_Design_Output!I52)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J52),\"\",Input_Design_Output!J52)","v":""},5.3760000000000003]
["SCM Annual Performance","Volume","VolRed","Mgal/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F53),\"\",Input_Design_Output!F53)","v":0.5256251650042213},{"$f":"IF(ISBLANK(Input_Design_Output!G53),\"\",Input_Design_Output!G53)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H53),\"\",Input_Design_Output!H53)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I53),\"\",Input_Design_Output!I53)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J53),\"\",Input_Design_Output!J53)","v":""},0.5256251650042213]
[null,"P","PRed","lb/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F54),\"\",Input_Design_Output!F54)","v":1.2904708940102936},{"$f":"IF(ISBLANK(Input_Design_Output!G54),\"\",Input_Design_Output!G54)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H54),\"\",Input_Design_Output!H54)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I54),\"\",Input_Design_Output!I54)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J54),\"\",Input_Design_Output!J54)","v":""},1.2904708940102936]
[null,"N","NRed","lb/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F55),\"\",Input_Design_Output!F55)","v":10.635116027675119},{"$f":"IF(ISBLANK(Input_Design_Output!G55),\"\",Input_Design_Output!G55)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H55),\"\",Input_Design_Output!H55)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I55),\"\",Input_Design_Output!I55)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J55),\"\",Input_Design_Output!J55)","v":""},10.635116027675119]
[null,"TSS","TSSRed","lb/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F56),\"\",Input_Design_Output!F56)","v":352.85486551925345},{"$f":"IF(ISBLANK(Input_Design_Output!G56),\"\",Input_Design_Output!G56)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H56),\"\",Input_Design_Output!H56)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I56),\"\",Input_Design_Output!I56)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J56),\"\",Input_Design_Output!J56)","v":""},352.85486551925345]
[null,"Bacteria","FIBRed","%/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F57),\"\",Input_Design_Output!F57)","v":0.75188195952112169},{"$f":"IF(ISBLANK(Input_Design_Output!G57),\"\",Input_Design_Output!G57)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H57),\"\",Input_Design_Output!H57)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I57),\"\",Input_Design_Output!I57)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J57),\"\",Input_Design_Output!J57)","v":""},{"$f":"SUMPRODUCT(E26:I26,E31:I31)/SUM(E26:I26)","v":0.75188195952112158}]
["Costs","Total SCM Costs","-","$",{"$f":"IF(ISBLANK(Input_Design_Output!F58),\"\",Input_Design_Output!F58)","v":41000},{"$f":"IF(ISBLANK(Input_Design_Output!G58),\"\",Input_Design_Output!G58)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H58),\"\",Input_Design_Output!H58)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I58),\"\",Input_Design_Output!I58)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J58),\"\",Input_Design_Output!J58)","v":""},{"$f":"IF(SUM(E32:I32)=0,\"N/A\",SUM(E32:I32))","v":41000}]
[null,"Volume","-","$/Mgal-yr",{"$f":"IF(ISBLANK(Input_Design_Output!F59),\"\",Input_Design_Output!F59)","v":78000},{"$f":"IF(ISBLANK(Input_Design_Output!G59),\"\",Input_Design_Output!G59)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H59),\"\",Input_Design_Output!H59)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I59),\"\",Input_Design_Output!I59)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J59),\"\",Input_Design_Output!J59)","v":""},78000]
[null,"P","-","$/lb-yr",{"$f":"IF(ISBLANK(Input_Design_Output!F60),\"\",Input_Design_Output!F60)","v":31770},{"$f":"IF(ISBLANK(Input_Design_Output!G60),\"\",Input_Design_Output!G60)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H60),\"\",Input_Design_Output!H60)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I60),\"\",Input_Design_Output!I60)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J60),\"\",Input_Design_Output!J60)","v":""},31770]
[null,"N","-","$/lb-yr",{"$f":"IF(ISBLANK(Input_Design_Output!F61),\"\",Input_Design_Output!F61)","v":3860},{"$f":"IF(ISBLANK(Input_Design_Output!G61),\"\",Input_Design_Output!G61)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H61),\"\",Input_Design_Output!H61)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I61),\"\",Input_Design_Output!I61)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J61),\"\",Input_Design_Output!J61)","v":""},3860]
[null,"TSS","-","$/lb-yr",{"$f":"IF(ISBLANK(Input_Design_Output!F62),\"\",Input_Design_Output!F62)","v":120},{"$f":"IF(ISBLANK(Input_Design_Output!G62),\"\",Input_Design_Output!G62)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H62),\"\",Input_Design_Output!H62)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I62),\"\",Input_Design_Output!I62)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J62),\"\",Input_Design_Output!J62)","v":""},120]
[null,"Bacteria","-","$/%-yr",{"$f":"IF(ISBLANK(Input_Design_Output!F63),\"\",Input_Design_Output!F63)","v":550},{"$f":"IF(ISBLANK(Input_Design_Output!G63),\"\",Input_Design_Output!G63)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H63),\"\",Input_Design_Output!H63)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I63),\"\",Input_Design_Output!I63)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J63),\"\",Input_Design_Output!J63)","v":""},550]
["O&M","Estimated O&M Hours","O&M hr","hr/yr",{"$f":"IF(ISBLANK(Input_Design_Output!F64),\"\",Input_Design_Output!F64)","v":17.387999999999998},{"$f":"IF(ISBLANK(Input_Design_Output!G64),\"\",Input_Design_Output!G64)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!H64),\"\",Input_Design_Output!H64)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!I64),\"\",Input_Design_Output!I64)","v":""},{"$f":"IF(ISBLANK(Input_Design_Output!J64),\"\",Input_Design_Output!J64)","v":""},{"$f":"SUM(E38:I38)","v":17.387999999999998}]