Excel design matrix

Given the first type of simulation, it is advantageous to be able to design a system of RO modules that can achieve the process objective at a minimal cost. A model has been iategrated iato a process simulation program to predict the stream matrix for a reverse osmosis process (132). In the area of waste minimization, the proper placement of RO modules is essential for achieving minimum waste at a minimum cost. Excellent details on how to create an optimal network of RO modules is available (96). 

As an integral component of Microsoft Office, the spreadsheet program Excel is installed on many personal computers. Thus, a widespread basic expertise can be assumed. Although initially designed for business calculations and graphics, Excel is also extremely useful for scientific purposes. Its matrix capabilities, as well as the optimisation add-in solver, are not widely known but can often be applied in order to quickly resolve quite complex multivariate problems. We have used Excel 2002 but any other version will do equally well. 

The spreadsheet in Figure 4-62 is heavily matrix based (see Chapter 2, for an introduction to basic matrix functions in Excel). It is the only way to keep the structure reasonably simple. The matrix C in cells A21 C31 is computed in the usual way, see equation (4.63) the parameters required to compute the concentration matrix are in cells Q4 S4, they include the initial concentration for species A and the two rate constants that are to be fitted. In cells E 16 018 the computation of the best absorptivity matrix A for any given concentration matrix C, is done as a matrix equation, as demonstrated in The Pseudo-Inverse in Excel (p.146). Similarly the matrix Ycaic in cells E21 031 is written as the matrix product CA. Even the calculation of the square sum of the residuals in cell R7 is written in a compact way, using the Excel function SUMXMY2, especially designed for this purpose. We refer to... 

In this section we will present some modelling developments for various forms of composites. The purpose is not to propose a calculation method - excellent computer software programs exist for that - but to show the broad strength range according to the composite structure, to underline the separate effects of fibres and matrix, and to examine the effects of some service conditions. These examples cannot be used for design calculations. 

The specifically formulated CGP-1 catalyst plays a vital role in the MIP-CGP process. Unique catalyst design, such as metal promoted MFl zeolite, phosphorus modified Y zeolite, and a novel matrix with excellent capability to accommodate coke [12] were involved to ensure the primary cracking and secondary reactions to proceed within a defined path. The commercial trial results of the MIP-CGP process in SINOPEC Jiujiang Company showed that, in combination with CGP-1 catalyst, the propylene yield was 8.96 wt%, which increased by more than 2.6% as compared with FCC process. The light ends yield and slurry yield are basically equal. The olefin content of the gasoline produced by MIP-CGP process was 15.0 v%, which was 26.1% lower than that of FCC gasoline. The sulfur content of gasoline was decreased from 400 to 270 pg/g. 

Both these catalysts are extremely suitable for "Short Contact Time" riser designs where high activity is desired via the combination of high concentration of RE-USY zeolite with Selective Active Matrices. Excellent commercial results with SAM matrix catalysts recently obtained in several "Short Contact Riser" FCC units in Europe have confirmed the advantages of this technology[5]. 

---