Please do as stated in the questions, use excel spreadsheet also show formulas and please organize

You can use transport processes and separation process principle by John Geankoplis chapter 8 and 10.

With the aid of figure below, write a solver for Problem 1 using Excel.

Problem 1. Evaporation of Sugar Solution in Double Effect Evaporator. A double-effect evaporator with reverse feed is used to concentrate 4536 kg/h of a 10 wt % sugar solution to 50%. The feed enters the second effect at 37.8°C. Saturated steam at 115.6°C enters the first effect and the vapor from this effect is used to heat the second effect. The absolute pressure in the second effect is 13.65 kPa abs. The overall coefficients are U₁ = 2270 and U₂ = 1705 W/m² - K.

Problem 2. A pure gas, A is entering to a counter-current tray tower separation unit and leaves the tower with 1.5 mot % of gas, B. The inert gas flow rate is 500 mot gas/h.m². The liquid entering the tower contains 0.1 mot % 13 and it is leaving the tower with 0.02 mot % B.

Equilibrium curve for this tower is given by y = -817140x³ + 6500 x² + 16.755 x where x and y are mole fractions.

a) Determine whether this processes is a stripping process or an absorption process.

b) What is the total liquid and vapor flow rates at the entrance and exit of the tower?

c) Determine the inert liquid flow rate.

d) What is the equation of the operating line?

e) How many theoretical trays does that tower have? Obtain your solution graphically using Excel. Analytical answers will not be accepted. (If the process is a stripping process, start from the concentrated end and step off, if the process is an absorption, start from the dilute end to draw the stairs)

(Use solver while determining the points for the stairs.lf you don't draw the sta. using Excel, if you do the rest correctly, you will get max. 5 pts from this part)

Problem 3. Ina counter-current stage tower, gas C is absorbed in a liquid. Equilibrium relationship is given by y = 3x. The total inlet gas flow to the tower is 50 mol/h and total inlet pure liquid flow rate is 120 mol/h. The entering gas contains 1 mot % C. Exiting total gas flow rate is 49.7 mol/h and the exiting gas of the mole fraction y₁ = 0.004024145.

a) What is the exiting total liquid flow rate and composition?

b) Can you assume that the operating line for this case is a straight line? If you can justify that assumption, use the inlet and outlet compositions to draw the operating line and tit a linear equation for the operating line.

c) How many stages the tower has? Obtain the number of stages graphically using Excel with the given equilibrium relationship and a suitable operating line.

d) Can you use analytical equations to obtain the number of stages for this case? If you can, what justifies the use of analytical equations?

e) How many stages do you get if you use the analytical equation?

The heating areas for both effects are equal. Use boiling-point-rise and heat-capacity data. Calculate the area and steam consumption.