1. Implement root finding method to determine the dew point pressure for the giv
ID: 3588168 • Letter: 1
Question
1. Implement root finding method to determine the dew point pressure for the given fluid mixture phase behavior 2. Implement bilinear interpolation method to determine the fluid mixture density at the thermodynamic conditions for which the tabulated data is not listed. Data: An Excel spreadsheet is provided on the course Moodle page under Project 1. It contains the tabulated entries of liquid fraction and mixture density as a function of temperature and pressure. Programming Requirements: 1. Implemented VBA Macros must read/write/search/sort a variety of data/messages based upon the calculations performed for dew point pressure calculations and fluid mixture densities. 2. Root finding problem could use bisection method. Appearance of liquid fraction (i.e. gas fraction less than 1.0) at a given temperature indicates that fluid mixture pressure is above dew point. Assume that the dew point pressure can be evaluated as the linearly interpolated pressure at liquid fraction value of 0.01 for any given temperature in the two-phase region range. 3. Implement VBA macro to locate the nearest tabulated entries of mixture densities for different temperature and pressure. Apply bilinear interpolation method to calculate the fluid mixture density at the desired thermodynamic state. Display the results as a message box.
Explanation / Answer
For designers, manufacturers of developed equipment, operators and responsible establishment it is essential to have models available for assess the physical effects of unplanned release of harmful materials.
For this purpose the manual ‘Methods for the calculation of physical effects of the release of harmful materials (liquids and gases)’, was issued by the Directorate General of Labour in 1979.
In the past decade the manual has been widely recognised as an important tool to be used in safety and risk assessment studies to calculate the risks of activities involving harmful materials.
Because of its yellow cover, the handbook is world-wide known as the ‘Yellow Book’.
The ‘Yellow Book’, originating from 1979, was partially revise in 1988.
However, it can be stated that the Yellow Book issued in 1988 was almost completely based on literature published before 1979.
The current version of the Yellow Book results from an general study and evaluation of recent literature on models for the calculation of physical effects of the release of harmful materials.
The group for the Prevention of Disasters, Subcommittee Risk Evaluation started this project in June 1993 and it was completed in March 1996.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.