首页> 外文期刊>Polimery >The use of solver in excel to solve copolymer composition equation in terminal and penultimate models of copolymerization
【24h】

The use of solver in excel to solve copolymer composition equation in terminal and penultimate models of copolymerization

机译:在Excel中使用求解器在共聚的末端和倒数第二个模型中求解共聚物组成方程

获取原文
获取原文并翻译 | 示例
           

摘要

The standard Solver in Excel 97 was applied in order to solve the copolymer composition equation in terminal and penultimae models of copolymerization.An unquestinalbe advantage of this software is easy access standard becase Solveris 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 displys a significant penultimate effect.For comparison the classical methods such as curve-fitting,Mayo-Lewis,Fineman-Ross,Kelen-Tudos 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.
机译:应用Excel 97中的标准Solver来解决共聚的末端和倒数第二模型中的共聚物组成方程式。该软件的一个明显优势是易于使用的标准,因为Solver是Microsoft Office软件包的一部分。苯乙烯与丙烯腈的自由基共聚。选择散装来证明求解器计算方法的实用性。这些单体系统显示出明显的倒数第二个效果。最终模型也使用了-Roskin方法。将Solver倒数第二个模型获得的解与之前通过非线性最小二乘最小化方法和nelder-Mead单纯形法获得的解进行比较,发现Solver的精度与初始值,精度和收敛性对最小化函数值的影响等等,还研究了一组反应率的值。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号