Development Of A Spreadsheet For Bar Graph Softening

<p>Lime softening has been commonly used for decades for hardness removal in water treatment. Many methods are used for controlling lime feed to a water treatment system. Concentrations in influent to or effluent from a water softener are most often determined manually by physical measurements, though they can also be automatically measured by various devices. Based on influent concentrations, hand calculations can be made for determination of the required chemical feed. Alternatively, required lime dosage can be estimated and then adjusted until the desired effluent quality is attained. This type of iterative method requires special attention and multiple adjustments under circumstances where raw water quality fluctuates. The purpose of this study is to develop a spreadsheet that can work with existing equipment to improve on these existing methods for lime softening. A spreadsheet, utilizing the Bar Graph Method (Gullicks) could perform the necessary calculations for determining chemical feed based on user inputs. On-line measuring devices (hardness, alkalinity, pH, temperature and conductivity) would determine influent water quality to softening basins on a continuous basis. Supplemented with periodic analyses of Na+, SO42- and Cl- and small adjustments for conductivity variation, this software and hardware would then work together to automatically adjust chemical feed on a more continuous basis, providing a more consistent treated effluent, and a more efficient use of chemicals.</p>

Name thesis:degree_name

Master of Science (MS)

Level thesis:degree_level

Thesis

Discipline thesis:degree_discipline

Civil Engineering

Year

2012

Author dc:creator

• Norberg, James

Contributors dc:contributor

• Harvey Gullicks

• Automation, Bar Graph, Chemistry, Lime Softening, Spreadsheet, Water

Repository record dc:identifier

https://commons.und.edu/theses/1308

OAI identifier oai:identifier

oai:commons.und.edu:theses-2309