期刊文献+

用Excel解方程组 被引量:1

Equations Solving with Excel
下载PDF
导出
摘要 利用Excel中矩阵函数的强大的数据处理功能,用矩阵逆函数MINVERSE,克拉默法则,规化求解命令,和EXCEL中的IF函数和行列式值MDETERM函数四种方法,均可以方便的求出方程组的解。本文通过两个实例对上述方法做了详细介绍,并给出了题解图例。 Matrix function using Excel,a powerful data processing capabilities,with the matrix inverse function MINVERSE,cramer rule,regulation methods for solving a command,and EXCEL in the function and the determinant of four methods MDETERM function,can easily find the equation solutions group.In this paper, above two examples described in details,and gives the problem solution legend.
作者 黄日红
出处 《计算机光盘软件与应用》 2010年第14期40-41,共2页 Computer CD Software and Application
关键词 EXCEL 解方程组 矩阵函数 行列式值函数 克拉默法则 规化求解 EXCEL Solving equations Matrix functions Determinant function Cramer rule Regulation solution
  • 相关文献

同被引文献12

  • 1孙锦,张俊礼,葛斌.基于符号经济学的冷热电联供产品成本分摊[J].热能动力工程,2010,25(5):501-504. 被引量:4
  • 2徐明仿,晏刚,杜维明,吴业正.天然气冷热电三联产系统的应用分析[J].天然气工业,2004,24(8):92-95. 被引量:11
  • 3李庚生,李永华,闫顺林,苗鑫华.火用经济学的发展及应用[J].华北电力技术,2006(10):5-8. 被引量:5
  • 4Delft University of Technology. Cycle-Tempo Release 5 [ OL ]. ht- tp ://www. cycle-tempo, nl/,2012.
  • 5Medina-Flores JM, Picon-Nu? ez M. Modelling the power produc- tion of single and multiple extraction steam turbines [ J ]. Chemical Engineering Science,2010,65 (9) :2811 - 2820.
  • 6Lozano MA, Valero A. Theory of the exergetic cost. Energy [ J ]. 1993,18(9) :939-960.
  • 7王加璇,张恒良.动力工程热经济学[M].北京:水利水电出版社,1994.
  • 8Bruno J C,Femandez F,Castells F,et al. A rigorous MINLP mod- el for the optimal synthesis and operation of utility plants[ J]. In- stitution of Chemical Engineers, 1998,76 (3) :246 - 258.
  • 9Ghaebi H,Saidi bi H,Ahmadi P. Exergneconomic optimization of a trigeneration system for heating, cooling and power production purpose based on TRR method and using evolutionary algorithm [ J ]. Applied Thermal Engineering,2012,36 : 113 - 125.
  • 10Isafiade A J, Fraser D M. Interval-based MINLP superstructure synthesis of heat exchange networks [ J ]. Chemical Engineering Research and Design 2008,86(3) :245 -257.

引证文献1

二级引证文献7

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部