solverproject1

solverproject1 - Formoredetailscontact:clement@auburn.edu...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
For more details contact: clement@auburn.edu 1 Tutorial Problem for using EXCEL Solver to fit experimental data to a model Developed by: Dr Prabhakar Clement, Department of Civil Engineering, Auburn University. The solver option available in EXCEL is a powerful optimization tool. In this tutorial, I will show how you can use it to for regression (curve fitting) applications. The first step is to select Options under File menu and go to “Add Ins” and include “Solver Add-Ins” tools. Then click on the “Data” tab and you should see and option called Solver option in EXCEL. See below for details. In this exercise we will use the solver option to fit a nonlinear equation to an experimental dataset. The problem involves understanding how toxic metals such as arsenic when discharged in the groundwater would absorb and contaminate soils. To understand this, environmental engineers typically run lab experiments where mix the contaminant in water and let the soil “soak” in the solution for a long time (long enough to reach equilibrium) and then analyze contaminant concentrations in the water phase (designate as C) and in the soil phase ( designated as S). We do this many, many times by soaking the soil in water containing various levels of contaminants. A typical data set collected from such an experiment is given below. Typical units used are: water concentration c in mg/Liter of water and soil concentration S in mg/mg of soil. Now if we plot the values of C (x axis) vs. S (y-axis) we get a graph which is provides useful picture that shows how toxic contaminated water would eventually soak into soil pores and contaminate soil. Note, this process can happen (and happens all the time) in any neighborhood where someone dumps used motor oil, waste coolant or even excess amount of fertilizer in the backyard! The graph shown below provides excellent visual information to assess how the contaminant would partition from water and pollute soils.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
For more details contact: clement@auburn.edu 2
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

solverproject1 - Formoredetailscontact:clement@auburn.edu...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online