Introductory of Microsoft Excel SOLVER function-Spreadsheet method for isotherm and kinetics modelling of metals biosorption in water and wastewater

University of Technology, Sydney and Xi'an University of Architecture and technology
Publication Type:
Journal Article
Journal of Water Sustainability, 2013, 3 (4), pp. 223 - 237
Issue Date:
Full metadata record
Files in This Item:
Filename Description Size
Thumbnail2012008542OK.pdf585.48 kB
Adobe PDF
This paper aims to introduce a simple method to run a complicated non-linear analysis of isotherm and kinetics models for metals biosorption based on input functions of spreadsheets. A robust method is demonstrated here to exploit the `SOLVER function available in Microsoft (MS) Excel spreadsheet. It is more economic and user friendly than specialized computer programmes. In this study, an iterative method was proposed to produce the optimal goodness of fit between experimental data and predicted data. This was described the implementing method of a set of real data (garden grass as biosorbent) and the predicted results were compared with linear analysis and MATLAB analysis. The R2 values found from MS Excel spreadsheet were 0.995, 0.999 and 0.996 while being 0.997, 1.000 and 0.999 by MATLAB for copper, lead and cadmium adsorption, respectively onto garden grass. The prediction of maximum adsorption, qm by excel (59.336, 63.663 and 42.310 mg/g) were very similar to MATLAB (59.889, 63.509 and 41.560 mg/g). The predictions of kinetics parameters were also close to MATLAB analysis. Hence, the MS Excel Spreadsheet method could be a handy tool for biosorption models.
Please use this identifier to cite or link to this item: