HSP Application note #44
User DB handling with HSPiP20107.25
HSPiP Team Senior Developer, Dr. Hiroshi Yamamoto
Some of the user have their own database. And they may want to append HSP or Y-MB result to their database. I explain how to do this.
Hansen Solubility Parameters (HSP)Hansen Solubility Parameters(HSP) were developed by Charles M. Hansen as a way of predicting if one material will dissolve in another and form a solution. They are based on the idea that "like dissolves like" where one molecule is defined as being 'like' another if it bonds to itself in a similar way. What can perhaps be surprising is that one can assign HSP to so many different things. Gases like carbon dioxide, solids like carbon-60, sugar, and biological materials like human skin, depot fat, DNA, and even some proteins all have HSP. The list can be continued with drugs, polymers, plasticizers, and in fact any organic material and even many inorganic materials like salts. The only requirement for an experimental confirmation is that the material must behave differently in a sufficient number of test solvents upon contact. Pirika JAVA Demo Applet calculate HSP. HSPLight is available here. |
HSPiP(Hansen Solubility Parameters in Practice)The first edition of HSPiP that appeared in November, 2008, greatly enhanced the usefulness of the Hansen solubility parameters (HSP). The HSP values of over 1200++ chemicals and 500 polymers are provided in convenient electronic format and have been revised and updated using the latest data sources in the second edition (March, 2009). A third edition of the HSPiP appeared in March, 2010. There are now 10,000 compounds in the HSP file which also includes data on density, melting point, boiling point, critical parameters, Antoine constants and much more. The user is able to carry out many different sorts of optimisations of solubility, evaporation, diffusion, adhesion, create their own datasets (automatically if required) and explore the huge range of applications for HSP in coatings, paints, nanoparticles, cosmetics, pharma, organic photovoltaics and much more. The 3rd Edition v3.1 was released on 12 December 2010. Current users can upgrade free (now v3.1.09) by downloading the latest .msi installer from http://hansen-solubility.com The 4th Edition v4.0.x was released on 2 Jan. 2013. The Current users can upgrade with free charge. 2013.1.28 The Visual How to manual of HSPiP. You can understand what HSPiP can do. |
The hardness will depend on wether you have Smiles structure in your database or not.
Smiles(Simplified Molecular Input Line Entry Syntax) SMILES is a string obtained by printing the symbol nodes encountered in a depth-first tree traversal of a chemical graph. Pirika JAVA Demo Applet getting Smiles. Draw2Smiles is available here. |
HSPiP or other related software deal molecular structure with Smiles. Actually HSPiP can handle Inche or mol file, but if you want to handle DB with spreadsheet, the only answer is Smiles.
If there is no Smiles structure in your database, you need to make by yourself. ChemDraw or other software can handle Smiles. You can download Smiles structure from ChemSpider HP.
If you want to know how to draw molecules, please refer to Power Tools applications. The full version of this routine is implemented into Draw2Smiles Powert Tools in HSPiP ver. 4.
The developer version of HSP Studio, it produce Smiles if you draw structure.(Please use Power tools!)
Anyway, if you get Smiles, please make table like below.
And save No and Smiles column as .txt file.
Now you would better not include title.
(Maybe this will fix next version 3.1.X)
And run the HSPiP and select σ (DIY). Select Y-MB panel and push File Convert Button.
Then select Smiles text file. The program read file line by line, and make HSP, volume, MW and functional groups list from Smiles, and save it as .ssd file. That .ssd file is just text file,
so you can open it with text editor, and Select All , Copy and paste it to spreadsheet.
You can import this table into some relational database.
Y-MB Properties EstimationY-MB break Smiles into correspponding Functional Groups and Estimate various Properties. These estimation schemes are come from Pirika technologies. Pirika JAVA Demo Applet calculate Properties. PirikaLight is available here. |
Or if you manually copy smiles, paste it to Y-MB text field, and push calculate button, Y-MB estimate a lot of properties. These results are stored in Clipboard so you can paste it into spreadsheet.
This conversion should be done one by one with HSPiP.
With developer version HSP Studio, you can convert 2500 compounds at once.
And you get the result as text with title.
I can convert 10,000 compounds within 5 minuets.
I can easily combine all data with using relational database.
Now I am using FileMaker Pro. But maybe every relational database system can do the same thing.
I think Y-MB batch breaking is not so much used function.
But if you know the usage, it will help you so much.