Excel modeling Help

Using standard formula for pressure and substitute xB = 1 – xT into the pressure equation,

Excel modeling Help

and solve for xT,

Excel modeling Help (1)

where the partial pressures are computed as

Excel modeling Help

Excel modeling Help

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

Excel modeling Help

The result is T = 112.8592 as shown below:

Excel modeling Help

Assignment Help | Excel Assignment Help | Excel Homework Help | Online Tutoring