Jump to content



Submitter

File Information

  • Submitted: Jun 16 2011 08:34 PM
  • Last Updated: Jun 20 2011 01:30 PM
  • File Size: 115.5KB
  • Views: 34762
  • Downloads: 11,500

Previous Versions

  • 16 Jun 2011 Download Physical Properties MS Excel Add-In

Download Physical Properties MS Excel Add-In

* * * * - 7 Votes



Screenshots
This is a Microsoft Excel Add-In that contains a database with the most used physical and chemical properties of various compounds, orderedn and presented in a fast and easy to query way.

"Properties Databank 1.0" contains the following properties for over 450 different chemicals:

- Mole Weight.
- Melting Point.
- Boiling Point.
- Critical Temperature.
- Critical Pressure.
- Critical Volume.
- Critical Compresibility Factor.
- Ascentric Factor.
- Liquid Density.
- Dipole Moment.
- Heat Capacity of the Vapor in the ideal gas state. (As a function of the temperature.)
- Viscosity. (As a function of the temperature.)
- Standard Enthalpy of Formation.
- Standard Free Energy of Formation.
- Vapor Pressure. (As a function of the temperature.)
- Vaporizing Heat.

In addition of beeing a fast reference to these properties, the "Properties Databank 1.0" Add-In contains the following functions that can be used as the standard Microsoft Excel's worksheet functions:

- Cp(Name,Temperature): Returns the heat capacity in Cal/mol-K of the compound "Name" in the ideal gas state at the specified temperature in K.

- AntoineP(Name, Temperature): Returns the vapor pressure in mmHg of the compound "Name" at the specified temperature in K using Antoine's equation.

- AntoineT(Name, Pressure): Returns the saturation temperature in K of the compound "Name" at the specified Pressure in mmHg using Antoine's equation.

- Viscosity(Name, Temperature): Returns the viscosity in cP of the compound "Name" at the specified temperature in K.

- HarlacherP(Name, Temperature): Returns the vapor pressure in mmHg of the compound "Name" at the specified temperature in K using Harlacher's equation.

All these functions can be either directly written in the cell were they are going to be used, preceded of the "=" sign; they also appear in the cathegory or "Databank" in the functions editor; or they can directly be inserted from the "Properties Databank 1.0" window using the "Insert Function" buttons.

Remember: This has to be installed as an Add-In in Excel


Disclaimer: All software provided "As-Is" with no warranty, expressed or implied, available. See our Terms of Use for more information.




Thank you

Here is another one that works for 5000 compounds: https://sites.google.com/site/azeotropeXL


Random Files





user(s) are online (in the past 15 minutes)

members, guests, anonymous users