I need help with the VBA (Excel) Coding. The methods we used were the Bisection Method, Newton-Raphson, and the Regula-Falsi Methods, I need two methods.

When designing a distillation column for a multicomponent mixture, a system of material and energy balances are used to determine the reflux ration (the proportion of liquid that flows into the top of the column compared to the amount of vapor that leaves the top), the number equilibrium stages, and the location of the feed. Frequently, a "shortcut" method is used to give a first estimate of the answers for this system of equation. This requires the use of 4 equations (Fenske, Underwood, Gilliland, and Kirkbride equations). All of these are reasonably easy to work with except for the nonlinear Underwood equation: 1-9= E N components a:2: di- A textbook by Seader, Henley, and Roper works an example for a mixture of 8 components where the values for ai, 2, and q are given below. This problem has multiple roots. Find the root (6) between 1.00 and 0.765. Solve the equation using at least two of the techniques covered this week. q= 0.0866 Z i 1 Alpha 2.43 2 1.93 2 3 4 5 0.0137 0.5113 0.0411 0.0171 0.0262 0.0446 0.3106 0.0354 1.00 0.765 0.362 0.164 0.072 0.0362 6 7