"Man learns in two ways: by doing, and by being done." -
Unknown
Objective
The primary purpose of this assignment is to familiarize yourself with the Excel
spreadsheet program and develop a tool to help you estimate the yearly cost of
operating your project treatment system.
Part 1: Compute the yearly costs of a full-size
water treatment system based on your prototype treatment work in the lab. This application will aid you in
designing and testing your system for the first project. To familiarize yourself
with the computational procedure, by hand, estimate the costs associated with a
prototype treatment system with the following characteristics:
-
flowrate into the system of 900 ml/min
-
system run time of 60 minutes
-
filter consists of 4 inches of anthracite and
4 inches of filter sand
-
coagulant dosage of 35 mg/l
-
prototype sedimentation tank has
4 chambers active
Part 2: Develop a
spreadsheet to
estimate yearly costs of a full-size water treatment system. Check your spread
sheet with the results from Part One and with the following prototype treatment system:
-
flowrate
into the system of 900 ml/min
-
system run
time of 55 minutes
-
filter consists of
6 inches of anthracite and
2 inches of filter sand
-
coagulant dosage of 60 mg/l
-
prototype
sedimentation tank has 2 chambers active
Part 3: Use your cost
spreadsheet developed in Part 2 to estimate yearly costs of each of the
prototype water treatment systems (WTS) run in lab last week (click here for
WTS data). Tabulate your WTS cost data by flowrate and the number of
sedimentation tanks used in the prototype runs and then construct a graph from
the data (the figure below shows the typical organization and format of the
graph).


This website was originally
developed by Charles Camp for
CIVL
1112.
This site is maintained by the Department of Civil Engineering
at the University of Memphis. Your
comments and questions are welcomed.
|