Question: Objectives: 1. Implement root finding method to determine the bubble p

Question

Question: Objectives: 1. Implement root finding method to determine the bubble point pressure for the given... Objectives: 1. Implement root finding method to determine the bubble point pressure for the given fluid mixture phase behavior 2. Implement 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: Implemented VBA Macros must read/write a variety of data/messages based upon the calculations performed for bubble point pressure calculations and fluid mixture densities. Root finding problem could use bisection method. Appearance of gas fraction (i.e. liquid fraction less than 1.0) at a given temperature indicates that fluid mixture is below bubble point. Assume that the bubble point pressure can be evaluated as the linearly interpolated pressure at liquid fraction value of 0.99 for any given temperature in the two-phase region range. 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. Using ONLY Arrays, Do While Loops, For Loops, Strings Objectives: 1. Implement root finding method to de Expert Answe

Explanation / Answer

For designers, manufacturers of industrial equipment, operators and responsible authorities it is essential to have models available for assessing the physical effects of accidental releases of hazardous materials. For this purpose the handbook ‘Methods for the calculation of physical effects of the release of dangerous materials (liquids and gases)’, was issued by the Directorate General of Labour in 1979. In the past decade the handbook has been widely recognised as an important tool to be used in safety and risk assessment studies to evaluate the risks of activities involving hazardous materials. Because of its yellow cover, the handbook is world-wide known as the ‘Yellow Book’. The ‘Yellow Book’, originating from 1979, was partially revised in 1988. However, it can be stated that the Yellow Book issued in 1988 was almost entirely based on literature published before 1979. The current version of the Yellow Book results from an extensive study and evaluation of recent literature on models for the calculation of physical effects of the release of dangerous materials. The Committee for the Prevention of Disasters, Subcommittee Risk Evaluation started this project in June 1993 and it was completed in March 1996.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.