Evaluation of the Microsoft Excel Solver Spreadsheet-Based Program for Nonlinear Expressions of Adsorption Isotherm Models onto Magnetic Nanosorbent

Applied Sciences

Chadrudee Sirilamduan¹  Javier Rioyo²  Torpong Kreetachart³  Kowit Suwannahong⁴  Surachai Wongcharee⁵  Akkharaphong Wongphat⁶ 

[1] Department of Business Management, Faculty of Management Science, Ubon Ratchathani University, Ubon Ratchathani 34150, Thailand;Department of Environmental Engineering, Condorchem Envitech, 08338 Barcelona, Spain;Department of Environmental Engineering, School of Energy and Environment, University of Phayao, Phayao 56000, Thailand;Department of Environmental Health, Faculty of Public Health, Burapha University, Chonburi 20131, Thailand;Field of Environmental Engineering, Faculty of Engineering, Mahasarakham University, Khamriang, Kantarawichai, Mahasarakham 44150, Thailand;Field of Mathematics, Faculty of Science and Technology, Rajabhat Mahasarakham University, Mahasarakham 44000, Thailand;

关键词: adsorption;    isotherm;    nonlinear;    Microsoft Excel;    MATLAB;    OriginPro;   

DOI  :  10.3390/app11167432

来源: DOAJ

【 摘 要 】

The sorption of basic dyes onto magnetic nanosorbent is commonly used as a novel material to combat powdered activated carbon, which is difficult to handle and separate during water and wastewater treatment. This adsorption method is commonly implemented in water and wastewater treatment due to its low cost and high performance. To explore the feasibility of adsorption, six different nonlinear isotherm models were applied and introduced to evaluate the performance and adsorption mechanisms via Microsoft Excel, and they were then compared to those of MATLAB and OriginPro. The Langmuir best provided the sorption of methylene blue adsorbed for a two-parameter isotherm model. The three-parameter model Toth gave a goodness of fit indicating a heterogeneous sorbent surface. Error function analysis found that the Residual Sum of Squares Error, Chi-square, Coefficient of determination, Average Relative Error, Hybrid Fractional Error Function, Marquardt’s Percent Standard Deviation and Root Mean Square Error provided the best overall results. In comparison, it could be concluded that six isotherm models showed the confidence interval that is simply the best fit at all experimental data points provided by the three software tools. All error function results indicated that the Microsoft Excel Solver function spreadsheet method satisfied all the statistic measures to predict the real variance of the probability of experimental data for all six isotherm models of adsorption of basic dye removal. One added benefit of this Microsoft Excel software tool is the built-in function associated with the desired type of application, which designates the desired type of error/statistical functions not mentioned in this research to the adsorbent materials used.

【 授权许可】

Unknown