The integration of response surface method in microsoft excel with visual basic application

Abstract

The purpose of this research is to create modules Response Surface Method (RSM) in Microsoft Excel by using Visual Basic Application programming language. Microsoft Excel has the facility to calculate the statistical problems. Analysis in Microsoft Excel is also relatively complete and procedure more easily and generally Microsoft Excel is available at almost any computer, as part of Microsoft Office. However, Microsoft Excel has not been able to solve problems related to this Response Surface Method. So the finishing will be the existence of a RSM modules in Microsoft Excel. Modules have been made will be applied to find the optimum conditions of membrane polyurethane (PU) in brackish water desalination process. The optimum conditions were determined by the membrane flux and percent rejection. With the RSM modules, it can be determined stationary point and the Response Surface characteristics so it can be used to determine whether the type of stationary point of maximum, minimum or saddle point.