Excel modeling Help

Using standard formula for pressure and substitute x_B = 1 – x_T into the pressure equation,

and solve for x_T,

(1)

where the partial pressures are computed as

The solution then consists of maximizing Eq. 1 by varying T subject to the constraint that 0 £ x_T £ 1. The Excel Solver can be used to obtain the solution. Here is how the worksheet can be set up:

The result is T = 112.8592 as shown below: