HSC Excel Add-In's

HSC Excel AddIn makes native HSC functions and databases available directly within a normal Excel spreadsheet. Highly specialized applications may be created with these new Excel AddIn functions.

These functions work like normal Excel functions such as the SUM function. For example, H("FeO";500) function returns the enthalpy of FeO at 500 Kelvin. An other example is WTP("Na";"Na₂SO₄") function which returns the weight percent of sodium in sodium sulphate.

The 45 different HSC functions available in Excel automatically read the HSC database. The functions and what they return are:

• General Functions
• UNITS(T; E) Changes current units, T=C/K and E=Mcal/MJ/ kWh
• BAL(Equation) Balances given equation
• SPECIES(DBNo, Position) Returns species in database DBNo and given position.
• Species Functions
• H(Species;T) Enthalpy/mol of the species at T
• S(Species;T) Entropy /mol of the species at T
• CP(Species;T) C_p/mol of the species at T
• G(Species;T) Gibbs energy/mol of the species at T
• HKG(Species;T) Enthalpy/kg of the species at T
• HNM3(Species;T) Enthalpy/Nm³ of the species at T
• HLAT(Species;T) Latent enthalpy/mol of the species at T
• Reaction Equation Functions
• H(Equation;T) Enthalpy of the reaction equation at T
• S(Equation;T) Entropy of the reaction equation at T
• CP(Equation;T) C_p difference of the reaction equation at T
• G(Equation;T) Gibbs energy of the reaction equation at T
• HKG(Equation;T) Enthalpy/kg of the reaction equation at T
• K(Equation;T) Equilibrium constant of the reaction equation at T
• Iteration (reverse) Functions
• TATH(Species;H) Temperature of the species with given enthalpy/mol
• TATS(Species;S) Temperature of the species with given entropy/mol
• TATCP(Species;CP) Temperature of the species with given C_p/mol
• TATG(Species;G) Temperature of the species with given Gibbs energy/mol
• Flow Functions
• FLOWH(Species;Amount;T) Enthalpy of a flow (Species & Amount as ranges) at T
• FLOWS(Species;Amount;T) Entropy of a flow (Species and Amount as ranges) at T
• FLOWCP(Species;Amount;T) C_p of a flow (Species and Amount as ranges) at T
• FLOWG(Species;Amount;T) Gibbs energy of a flow (Species and Amount as ranges) at T
• Temperature independent Functions
• STRUCT(Species) Structural formula of the species
• CHNAME(Species) Chemical name of the species
• CONAME(Species) Common name of the species
• CAN(Species) Chemical abstract number of the species
• MW(Species) Molecular weight of the species
• DE(Species) Density of the species
• MP(Species) Melting point of the species
• BP(Species) Boiling point of the species
• PHASE(Species) Phase of the species
• RGBCOLOR(Species) RGB color of the species
• REF(Species) Eatabase reference of the species
• REL(Species) Reliability class of the species
• Percentage Functions
• MOLP(Species1;Species2) Mol-% of Species1 in Species2
• WTP(Species1;Species2) Wt-% of Species1 in Species2
• Cp Data Functions
• CPFUNCTION(Species) C_p polynomial function (as a string) of the given species
• CPA(Species) A-coefficient (as a number) of the C_p-function
• CPB(Species) B-coefficient (as a number) of the C_p-function
• CPC(Species) C-coefficient (as a number) of the C_p-function
• CPD(Species) D-coefficient (as a number) of the C_p-function
• TMIN(Species) Minimum valid temperature of the C_p-function
• TMAX(Species) Maximum valid temperature of the C_p-function