skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: Spreadsheet Based Scaling Calculations and Membrane Performance

Conference ·
OSTI ID:15013303

Many membrane element manufacturers provide a computer program to aid buyers in the use of their elements. However, to date there are few examples of fully integrated public domain software available for calculating reverse osmosis and nanofiltration system performance. The Total Flux and Scaling Program (TFSP), written for Excel 97 and above, provides designers and operators new tools to predict membrane system performance, including scaling and fouling parameters, for a wide variety of membrane system configurations and feedwaters. The TFSP development was funded under EPA contract 9C-R193-NTSX. It is freely downloadable at www.reverseosmosis.com/download/TFSP.zip. TFSP includes detailed calculations of reverse osmosis and nanofiltration system performance. Of special significance, the program provides scaling calculations for mineral species not normally addressed in commercial programs, including aluminum, iron, and phosphate species. In addition, ASTM calculations for common species such as calcium sulfate (CaSO{sub 4}{times}2H{sub 2}O), BaSO{sub 4}, SrSO{sub 4}, SiO{sub 2}, and LSI are also provided. Scaling calculations in commercial membrane design programs are normally limited to the common minerals and typically follow basic ASTM methods, which are for the most part graphical approaches adapted to curves. In TFSP, the scaling calculations for the less common minerals use subsets of the USGS PHREEQE and WATEQ4F databases and use the same general calculational approach as PHREEQE and WATEQ4F. The activities of ion complexes are calculated iteratively. Complexes that are unlikely to form in significant concentration were eliminated to simplify the calculations. The calculation provides the distribution of ions and ion complexes that is used to calculate an effective ion product ''Q.'' The effective ion product is then compared to temperature adjusted solubility products (Ksp's) of solids in order to calculate a Saturation Index (SI) for each solid of interest. The SI is expressed as a log value (log(Q) - log(Ksp)) where positive values indicate potential scaling conditions. As this is an unprotected spreadsheet, the methodology is plainly visible to and readily modified by the user.

Research Organization:
Lawrence Livermore National Lab. (LLNL), Livermore, CA (United States)
Sponsoring Organization:
USDOE
DOE Contract Number:
W-7405-ENG-48
OSTI ID:
15013303
Report Number(s):
UCRL-JC-143230; TRN: US200802%%1096
Resource Relation:
Conference: 2001 MEMBRANES Technology Conference, San Antonio, TX, Mar 03 - Mar 07, 2001
Country of Publication:
United States
Language:
English

Similar Records

Fresh Water Generation from Aquifer-Pressured Carbon Storage: Interim Progress Report
Technical Report · Wed Jul 22 00:00:00 EDT 2009 · OSTI ID:15013303

Removal of As(III) by Electrically Conducting Ultrafiltration Membranes
Journal Article · Wed Aug 25 00:00:00 EDT 2021 · Water Research · OSTI ID:15013303

Removal of ammonium and nitrate ions from mine effluents by membrane technology
Journal Article · Tue Feb 01 00:00:00 EST 1994 · Separation Science and Technology; (United States) · OSTI ID:15013303