A methodology for simulating biological systems using Microsoft Excel
A methodology for simulating biological systems using Microsoft Excel
复制标题
DOI：
10.1016/s0169-2607(98)00077-7
复制
发表时间：
1999-02-01
影响因子：
6.1
通讯作者：
Brown, AM
中科院分区：
文献类型：
--
作者：
Brown, AM
本研究的目的是开发一种简单的。使用Microsoft Excel电子表格解决基于生物学的模型的易于理解的方法。该方法涉及使用单元格内公式，其中从键入电子表格的数据生成新数据的列和列，但不需要任何编程技能或使用宏语言。该方法包括将关键参数值输入到电子表格中，并通过求解基于这些参数值的一组方程来进行模拟。本文中使用的例子是，首先，一个简单的电压钳位仿真，其中初始参数值用于计算系统的稳态。第二个例子是电流钳模拟，其中未达到稳态，并且每个时间增量的方程的解用作模拟中下一个时间增量的输入。计算基于描述离子通道行为的电压依赖性的Hodgkin Huxley数学方程。简要讨论了该方法存在的问题和灵活性。在本研究中开发的方法应该帮助新手建模创建简单的模拟，而不需要学习编程语言或购买昂贵的软件。(C)1999爱思唯尔科学爱尔兰有限公司保留所有权利。
The objective of this present study was to develop a simple. easily understood methodology for solving biologically based models using a Microsoft Excel spreadsheet. The method involves the use of in-cell formulas in which Rows and Columns of new data are generated from data typed into the spreadsheet, but does not require any programming skills or use of the macro language. The approach involves entering the key parameter values into the spreadsheet and conducting the simulation by solving a set of equations based on these parameter values. The examples used in this paper are firstly, a simple voltage clamp simulation in which initial parameter values are used to calculate a system in steady state. The second example is a current clamp simulation where steady state is not reached and the solution of the equations for each time increment is used as the input for the next time increment in the simulation. The calculations are based on the Hodgkin Huxley mathematical equations that describe the voltage dependence of ion channel behavior. The problems and flexibility of the method are briefly discussed. The methodology developed in this present study should help novice modelers to create simple simulations without the need to learn a programming language or purchase expensive software. (C) 1999 Elsevier Science Ireland Ltd. All rights reserved.