Show the VBA coding on Excel for the bubble point temperature (Tp) for different liquid mole fractions (xi) ranging between 0 and 1. Also solve using the dew point temperature (Tap) for different vapour mole fractions (vi) ranging between 0 and 1. Use both sets of data to create a VLE Txy diagram in Microsoft Excel. For the Antoine parameters given all temperatures are in C and pressures in mmHg. The numerical solution must be solved in Microsoft Excel using VBA. At the very least the problem shall be solved using the following parameters in Table 1. However, the solution should be flexible and robust enough that different parameters (e.g., different pressures and different compounds) could be easily changed on the Excel side and a new solution would be automatically calculated. The numerical methods used should also be able to be easily adapted to handle different nonlinear problems.

Component Properties Name Antoine Parameter (A) Antoine Parameter (B) Antoine Parameter (C) System Properties Overall Pressure (mmHg) Table 1: Binary VLE Properties Compound A Ethanol 8.1122 1592.861 226.184 Compound B p-Xylene 6.9982 1451.792 215.11 760