4.2 Article

Determination of the Hansen solubility parameters and the Hansen sphere radius with the aid of the solver add-in of Microsoft Excel

Journal

SN APPLIED SCIENCES
Volume 2, Issue 4, Pages -

Publisher

SPRINGER INT PUBL AG
DOI: 10.1007/s42452-020-2512-y

Keywords

Hansen solubility parameters; Excel's solver; Desirability function; Hansen sphere

Ask authors/readers for more resources

This paper describes the use Excel's Solver of Microsoft and desirability function for the determination of Hansen's solubility parameters (HSPs). The Excel's solver is powerful while at the same time being user-friendly and easy to comprehend. Results of HSPs for different polymers and oils were evaluated and compared with the results obtained by the use of other tools; no significant differences were found between the Microsoft Excel solution and either the professional program HSPiP or other software platform used by different authors. Improvements introduced in the Excel book developed by Steven Abbott for this purpose, by the inclusion of some restrictions and functions, allow simultaneously optimizing the diameter of the Hansen sphere together with the determination of Hansen's parameters, so that a tool, available to professional and researcher, can be used for these determinations with a high degree of precision, using any of the nonlinear optimization algorithms available in the Solver add-in. Finally, it is illustrated how the use of programming in Excel VBA can lead to a friendly interface for these determinations.

Authors

I am an author on this paper
Click your name to claim this paper and add it to your profile.

Reviews

Primary Rating

4.2
Not enough ratings

Secondary Ratings

Novelty
-
Significance
-
Scientific rigor
-
Rate this paper

Recommended

No Data Available
No Data Available