Science Inventory

SPREADSHEET BASED SCALING CALCULATIONS AND MEMBRANE PERFORMANCE

Citation:

Wolfe, T. D., W. L. Bourcier, AND T F. Speth*. SPREADSHEET BASED SCALING CALCULATIONS AND MEMBRANE PERFORMANCE. U.S. Environmental Protection Agency, Washington, DC, EPA/600/A-01/023, 2001.

Impact/Purpose:

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-T193-NTSX. 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 (CaSO4 2H2O), BaSO4, SrSO4, SiO2, and LSI are also provided. The spreadsheet is fully transparent, allowing the operator to manually change all aspects of the program.

Description:

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-T193-NTSX. 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 (CaSO4 2H2O), BaSO4, SrSO4, SiO2, and LSI are also provided. The spreadsheet is fully transparent, allowing the operator to manually change all aspects of the program.

URLs/Downloads:

SOLVER.XLA

TFSP FINAL REPORT.PDF   (PDF,NA pp, 360 KB,  about PDF)

TFSP VER3-2-02.XLS

Record Details:

Record Type: DOCUMENT (DATA/SPREADSHEET)
Product Published Date: 02/16/2001
Record Last Revised: 08/20/2018
OMB Category: Other
Record ID: 63789

Organization:

U.S. ENVIRONMENTAL PROTECTION AGENCY

OFFICE OF RESEARCH AND DEVELOPMENT

NATIONAL RISK MANAGEMENT RESEARCH LABORATORY

WATER SUPPLY AND WATER RESOURCES DIVISION

TREATMENT TECHNOLOGY EVALUATION BRANCH