This spreadsheet tool has been set up to perform all of the infiltration practice sizing calculations shown below<br>
This spreadsheet tool has been set up to perform all of the infiltration practice sizing calculations shown below<br>
{{Clickable button|[[Media:Infiltration Sizing 20200525 locked.xlsx|Download the infiltration practice sizing tool]]}}
{{Clickable button|[[Media:Infiltration Sizing 20200525 locked.xlsx|Download the infiltration practice sizing tool]]}}
−
−
==To calculate the required depth, where the area of the facility is constrained (3D drainage)==
−
In some very constrained sites, the surface area of the BMP may be limited, in this case the required depth of cell or trench can be calculated:
−
:<math>d=a[e^{\left ( -bD \right )} -1]</math>
−
Where
−
<math>a=\frac{Ap}{x}-\frac{i Ai}{x f'}</math>
−
and
−
<math>b=\frac{xf'}{nAp}</math>
−
−
(The rearrangement to calculate the required footprint area of the facility for a given depth using three dimensional drainage is not available at this time. Elegant submissions are invited.)
==To calculate the required depth, where the area of the facility is constrained (1D drainage)==
==To calculate the required depth, where the area of the facility is constrained (1D drainage)==