The use of Solver in Excel to solve copolymer composition equation in terminal and penultimate models of copolymerization
Polimery 2002, No 10, 700
The standard Solver in Exce197 was applied in order to solve the copolymer composition equation in terminal and penultimate models of copolymerization. An unquestionable advantage of this software is easy access standard because Solver is a part of Microsoft Office package. The radical copolymerization of styrene with acrylonitrile in bulk was chosen to prove the usefulness of the calculation procedure of Solver. These monomers system displays a significant penultimate effect. For comparison the classical methods such as curve-fitting, Mayo-Lewis, Fineman-Ross, Kelen-Tüdös and Ezrielev-Brokhina-Roskin for the terminal model were also applied. The solutions obtained by Solver for penultimate model were compared with those obtained earlier by non-linear least squares minimizing method and Nelder-Mead simplex method. It was found that the precision of Solver is comparable with those obtained by above methods. The influences of started values, precision and convergence on the values of minimized function and so on the values of set of reactivity ratios have been also studied.
Keywords: reactivity ratios, terminal model, penultimate model, styrene/acrylonitrile system