Please email the VBA code (in excel) to 18hl38@queensu.ca and comment once you've done so. Post some sort of image or screenshot of the code so that I can rate your answer 100%.

Question 1) In Chemical Thermodynamics (i.e. ENCH 427), the Rachford-Rice equation is used for solving problems in vapour-liquid phase equilibrium. The Rachford-Rice equation is given below: zi(1 - Ki) Ki + a(1 - K) Where z, is the mole fraction of component i' in the feed, n is the number of components, K, is the distribution coefficient and a is the fraction of feed that is condensed. In the special case where both the vapour and liquid can be assumed to behave as ideal solutions, K, can be written as sat where T+Ci Pisat is the vapour pressure of component 'i' (bar) and T is the temperature (K). For a feed stream containing Heptane, Toluene and Benzene it is desired to find the value of at 0.60 bar and 80C. The following information is given for the system Component Name Heptane 0.45 Toluene Benzene 0.30 9.2535 9.3935 9.2806 2911.32 3096.52 2788.51 -56.51 53.67 52.36 2 3 e 0.25 d. write a VBA program to use the secant method to solve the Rachford-Rice equation for given starting guesses of 0 and 1 and -10. Report the computed value of . Question 1) In Chemical Thermodynamics (i.e. ENCH 427), the Rachford-Rice equation is used for solving problems in vapour-liquid phase equilibrium. The Rachford-Rice equation is given below: zi(1 - Ki) Ki + a(1 - K) Where z, is the mole fraction of component i' in the feed, n is the number of components, K, is the distribution coefficient and a is the fraction of feed that is condensed. In the special case where both the vapour and liquid can be assumed to behave as ideal solutions, K, can be written as sat where T+Ci Pisat is the vapour pressure of component 'i' (bar) and T is the temperature (K). For a feed stream containing Heptane, Toluene and Benzene it is desired to find the value of at 0.60 bar and 80C. The following information is given for the system Component Name Heptane 0.45 Toluene Benzene 0.30 9.2535 9.3935 9.2806 2911.32 3096.52 2788.51 -56.51 53.67 52.36 2 3 e 0.25 d. write a VBA program to use the secant method to solve the Rachford-Rice equation for given starting guesses of 0 and 1 and -10. Report the computed value of