• 主题
高级搜索  >
历史搜索 清空历史
首页> 外文期刊>Journal of Natural Resources and Life Sciences Education >Overcoming Microsoft Excel's Weaknesses for Crop Model Building and Simulations
【24h】

Overcoming Microsoft Excel's Weaknesses for Crop Model Building and Simulations

机译：克服Microsoft Excel在作物模型建立和仿真方面的不足

获取原文
获取原文并翻译 | 示例
           
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

Using spreadsheets such as Microsoft Excel for building crop models and running simulations can be beneficial. Excel is easy to use, powerful, and versatile, and it requires the least proficiency in computer programming compared to other programming platforms. Excel, however, has several weaknesses: it does not directly support loops for iterative calculations, and it does not allow one cell to alter the contents of another cell. Thus, the objective of this study was to develop an Excel add-in, called BuildIt, that overcomes some of Excel's weaknesses by: (1) providing a loop for repetitive calculations and (2) providing several operations (called actions) typically needed in building crop models. These actions are such as for numerical integration,initialization of variables, and solving differential equations using the Runge-Kutta method, as well as for copying and manipulation of cell ranges. BuildIt was written in Excel's script language, Visual Basic for Applications (VBA), but it does not require users to program in VBA to build their models. Several examples of models were used in this article to illustrate how BuildIt implements the infrastructure in Excel, and how it can be used to build models and run model simulations. With BuildIt, users are able to use Excel to build and run their mathematical models, without requiring any knowledge in VBA.
机译：使用Microsoft Excel等电子表格来构建作物模型和运行模拟可能会有所帮助。 Excel易于使用，功能强大且用途广泛，与其他编程平台相比，它对计算机编程的要求最少。但是，Excel有几个缺点：它不直接支持循环进行迭代计算，并且它不允许一个单元格更改另一单元格的内容。因此，本研究的目的是开发一个名为BuildIt的Excel加载项，该加载项通过以下方式克服了Excel的一些弱点：（1）提供重复计算的循环，以及（2）提供通常需要的几种操作（称为操作）建立作物模型。这些动作例如用于数值积分，变量初始化和使用Runge-Kutta方法求解微分方程，以及复制和操纵像元范围。 BuildIt是用Excel的脚本语言Visual Basic for Applications（VBA）编写的，但它不需要用户在VBA中编程即可构建模型。本文使用了几个模型示例来说明BuildIt如何在Excel中实现基础结构，以及如何将其用于构建模型和运行模型仿真。使用BuildIt，用户可以使用Excel来构建和运行其数学模型，而无需任何VBA知识。

著录项

相似文献

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

客服邮箱：kefu@zhangqiaokeyan.com

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

  • 客服微信

  • 服务号