4 - If second property is degree of saturation, then use this value.The subfunctions can be used like any other excel function. Wilkinson, PE developed the VBA functions from ASHRAE methods. You might find slight differences when using psychrometric charts but it appears to be negligible. 3 - If second property is humidity ratio, then use this value I downloaded this excel file three years ago and found it to very useful - and still use it today.
2 - If second property is relative humidity, then use this value.1 - If second property is dewpoint temperature, then use this value.0 - If second property is wetbulb temperature, then use this value.Inputs the type of second property of air. Inputs drybulb temperature (use Celsius for SI unit system, Fahrenheit for IP unit system) Returns saturation pressure for a specified temperature Returns degreeof saturation of a given point in a psychrometric chart Returns humidity ratio of a given point in a psychrometric chart Returns relative humidity of a given point in a psychrometric chart (Range - ) Returns wet bulb temperature of a given point in a psychrometric chart Returns specific volume of a given point in a psychrometric chart Returns specific enthalpy of a given point in a psychrometric chart Saturation Pressure function is the only function in psychrometric properties chart which only has one input argument which is the temperature in SI units or IP units as selected by the excel sheet. Check unit conversion dialog for the list of SI and IP units used in each category. as macros which can be embedded into any Excel-compatible spread- sheet. Default units system for inputs and outputs is SI. 12-6a Diagram of psychrometric chart showing the properties of moist air. All the functions listed below have same number of input arguments, first one being the drybulb temperature, second one being the type of the 2nd property of the air, and the third one being the value of the third property of air. Psychrometric excel addin has few different functions to get psychrometric properties of air. It also can be used via the guided menu system in the psychrometric chart. Saturation pressure only requires the dry bulb temperature. In the same manner, you can calculate Wetbulb temperature, Dew point temperature, Relative Humidity,Humidity ratio, Specific Volume, Degree of Saturation. Follow the same steps for relative humidity.Ĭlick here to get additional information about the function and its input variables. It will replace the selected word with the cell reference. All you have to do is double click on "Drybulb" word in the cell function which will select the whole word and then click on the relevant cell for drybulb temperature. Now you can assign the relevant cell for dry bulb temperature and relative humidity. Then specific enthalpy function will be added with some input variables filled in to that cell as shown.
0 kommentar(er)
