Difference between revisions of "Double ring infiltrometers"

From LID SWM Planning and Design Guide
Jump to navigation Jump to search
Line 30: Line 30:
 
===The Solver add-in===
 
===The Solver add-in===
 
To use the calculation spreadsheet, an additional add-in must be enabled in your Excel program.  
 
To use the calculation spreadsheet, an additional add-in must be enabled in your Excel program.  
#Go to ‘File’ in you menu toolbar and select ‘Options’ from the menu,
+
# Go to ‘File’ in your menu toolbar and select ‘Options’ from the menu,
#Choose ‘Add-ins’ and then at the bottom of the window, for ‘Manage Add-ins’, select ‘Go’.  
+
# Choose ‘Add-ins’ and then at the bottom of the window, for ‘Manage Add-ins’, select ‘Go’.  
#Check the box for the ‘Solver’ add-in and then ‘OK’.  
+
# Check the box for the ‘Solver’ add-in and then ‘OK’.  
#Your new Solver add-in appears on the right end of the ‘Data’ toolbar in the main Excel window. It is useful for solving all kinds of iterative equations.  
+
# Your new Solver add-in appears on the right end of the ‘Data’ toolbar in the main Excel window. It is useful for solving all kinds of iterative equations.
 +
 
 
===Performing calculations===
 
===Performing calculations===
 
#Save a new copy of your spreadsheet.  
 
#Save a new copy of your spreadsheet.  

Revision as of 19:53, 9 May 2019

Double ring
Schematic diagram of double ring infiltrometer illustrating the infiltration of water both vertically, and laterally particularly from the outer ring.
Double ring infiltrometer in use

Packing list[edit]

• Small ring (28 – 32 cm) • Large ring (53 – 57 cm) • Sledge hammer for driving rings into ground • Wooden block to distribute force when driving rings into ground • Level • Two metal rulers with clips to secure • Container for water • Screwdriver or similar implement to dislodge rocks

Installation[edit]

  1. Choose or create clear, level ground at the desired test location.
  2. Work with minimal disturbance to the soil within the test area.
  3. Place the wooden block across the ring and use the sledge hammer to drive the ring into the ground by ≥ 5 cm.
  4. Check that the ring is level in all directions and correct as necessary.
  5. Repeat with the second ring (note that the order may vary if the rings are of differing heights.
  6. Both rings should be firm into the ground.
  7. Secure the metal rulers to the inside of the rings.

Measurements[edit]

  1. To begin measurements gently pour 5 – 10 cm of water into both the inner and outer rings.
  2. Measurement of the water depth should be made every 15 minutes for the first hour, 30 minutes in the second hour and then hourly up to 6 hours.
  3. The rings should be covered to reduce evaporation, particularly in hot weather and when the soil is clayey and infiltration is slow.

Calculations[edit]

File:DRI.xlsx

Using the DRI (double ring infiltrometer) spreadsheet

The Solver add-in[edit]

To use the calculation spreadsheet, an additional add-in must be enabled in your Excel program.

  1. Go to ‘File’ in your menu toolbar and select ‘Options’ from the menu,
  2. Choose ‘Add-ins’ and then at the bottom of the window, for ‘Manage Add-ins’, select ‘Go’.
  3. Check the box for the ‘Solver’ add-in and then ‘OK’.
  4. Your new Solver add-in appears on the right end of the ‘Data’ toolbar in the main Excel window. It is useful for solving all kinds of iterative equations.

Performing calculations[edit]

  1. Save a new copy of your spreadsheet.
  2. Enter time and water level data into the clear spaces of the sheet.
  3. Rows may be added or removed as required,
  4. Check that the data is 'complete' i.e. that unused rows have been deleted,
  5. Check that the no errors have appeared in the calculation columns.
  6. The orange box shows the sum of squares (i.e. the error between the current model and the measured data). The objective of our calculation is to minimize this number by finding the best S (Soil sorptivity) and A (parameter) for our soil.
    1. Open the Solver,
    2. Set objective: (select orange cell),
    3. To: (choose ‘Min’),
    4. By changing variable cells: (select the pink cells, for the S and A numbers),
    5. Leave the constraints box empty,
    6. Ensure that the ‘GRG nonlinear’ Solving method is selected,
    7. ‘Solve’!
    8. The solver produces the optimized S and A values to match the model to the field data.
    9. The saturated hydraulic conductivity (K) is approximated by dividing A by 2/3, where A is the slope of the linear part of the graph. i.e when infiltration rate has stabilized.

To review[edit]

https://www.astm.org/Standards/D3385.htm