# Difference between revisions of "Double ring infiltrometers"

Jenny Hill (talk | contribs) m |
Jenny Hill (talk | contribs) m (→Calculations) |
||

Line 30: | Line 30: | ||

==Calculations== | ==Calculations== | ||

[[File:DRI.xlsx]] | [[File:DRI.xlsx]] | ||

+ | |||

Using the DRI (double ring infiltrometer) spreadsheet | Using the DRI (double ring infiltrometer) spreadsheet | ||

===The Solver add-in=== | ===The Solver add-in=== | ||

Line 52: | Line 53: | ||

##‘Solve’! | ##‘Solve’! | ||

##The solver produces the optimized S and A values to match the model to the field data. | ##The solver produces the optimized S and A values to match the model to the field data. | ||

− | ##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. | + | ##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== | ==To review== | ||

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

## Revision as of 19:49, 9 May 2019

### Packing list

• 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

- 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 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 evaporationAbiotic transfer of water vapour to the atmosphere., particularly in hot weather and when the soil is clayey and infiltration is slow.

## Calculations

Using the DRI (double ring infiltrometer) spreadsheet

### The Solver add-in

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,
- 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’.
- 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

- Save a new copy of your spreadsheet.
- Enter time and water level data into the clear spaces of the sheet.
- Rows may be added or removed as required,
- Check that the data is 'complete' i.e. that unused rows have been deleted,
- Check that the no errors have appeared in the calculation columns.
- 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.
- Open the Solver,
- Set objective: (select orange cell),
- To: (choose ‘Min’),
- By changing variable cells: (select the pink cells, for the S and A numbers),
- Leave the constraints box empty,
- Ensure that the ‘GRG nonlinear’ Solving method is selected,
- ‘Solve’!
- The solver produces the optimized S and A values to match the model to the field data.
- The saturated hydraulic conductivityA parameter that describes the capability of a medium to transmit water. (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 rateThe rate at which stormwater percolates into the subsoil measured in inches per hour. has stabilized.