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

Abstract

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 andmore » 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.« less

Authors:
; ;
Publication Date:
Research Org.:
Lawrence Livermore National Lab. (LLNL), Livermore, CA (United States)
Sponsoring Org.:
USDOE
OSTI Identifier:
15013303
Report Number(s):
UCRL-JC-143230
TRN: US200802%%1096
DOE Contract Number:  
W-7405-ENG-48
Resource Type:
Conference
Resource Relation:
Conference: 2001 MEMBRANES Technology Conference, San Antonio, TX, Mar 03 - Mar 07, 2001
Country of Publication:
United States
Language:
English
Subject:
58 GEOSCIENCES; 54 ENVIRONMENTAL SCIENCES; CALCIUM SULFATES; COMPUTER CODES; MEMBRANES; PERFORMANCE; US EPA

Citation Formats

Wolfe, T D, Bourcier, W L, and Speth, T F. Spreadsheet Based Scaling Calculations and Membrane Performance. United States: N. p., 2000. Web.
Wolfe, T D, Bourcier, W L, & Speth, T F. Spreadsheet Based Scaling Calculations and Membrane Performance. United States.
Wolfe, T D, Bourcier, W L, and Speth, T F. 2000. "Spreadsheet Based Scaling Calculations and Membrane Performance". United States. https://www.osti.gov/servlets/purl/15013303.
@article{osti_15013303,
title = {Spreadsheet Based Scaling Calculations and Membrane Performance},
author = {Wolfe, T D and Bourcier, W L and Speth, T F},
abstractNote = {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.},
doi = {},
url = {https://www.osti.gov/biblio/15013303}, journal = {},
number = ,
volume = ,
place = {United States},
year = {Thu Dec 28 00:00:00 EST 2000},
month = {Thu Dec 28 00:00:00 EST 2000}
}

Conference:
Other availability
Please see Document Availability for additional information on obtaining the full-text document. Library patrons may search WorldCat to identify libraries that hold this conference proceeding.

Save / Share: