Introductory of Microsoft Excel SOLVER Function-Spreadsheet Method for Isotherm and Kinetics Modelling of Metals Biosorption in Water and Wastewater

Md Anwar Hossain, Huu Hao Ngo, Wenshan Guo



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.

Keywords: Solver function; Microsoft Excel spreadsheet; non-linear analysis; iteration; goodness of fit; MATLAB