Font Size: a A A

Development of a spreadsheet for bar graph softening

Posted on:2013-04-09Degree:M.SType:Thesis
University:The University of North DakotaCandidate:Norberg, JamesFull Text:PDF
GTID:2451390008487464Subject:Engineering
Abstract/Summary:
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.
Keywords/Search Tags:Softening, Chemical feed, Water, Spreadsheet
Related items