SOS 212: Example simulation (numerical integration) of a bacterial population in Google Sheets/Excel
Автор: Ted Pavlic
Загружено: 2022-09-26
Просмотров: 248
Описание:
This video tutorial covers how to use Euler's method of numerical integration to simulate a simple System Dynamics Model (SDM) in a spreadsheet program like Google Sheets or Microsoft Excel. Numerical integration is the simulation process used behind the scenes in tools like Vensim, Insight Maker, Stella, AnyLogic, and other System Dynamics Modeling tools, and knowing how to perform numerical integration manually helps to better understand the role of the "time step" that must be properly configured in each of these tools.
The particular example is the simulation of a simple, asexual, clonal bacterial population with a given average time between reproduction events (per bacterium) and an average lifetime (per bacterium). The example explores how to simulate the system for several different simulation time steps and how to determine which time step is the best fit for the system (i.e., at what time step does the approximation "converge" to a solution that is hopefully "close enough" to the analytical solution of the modeled differential equation).
This tutorial also covers how to export Google Sheets projects to XLSX files and then fix the embedded charts, which are often broken when opened in Microsoft Excel.
This video was recorded by Theodore Pavlic as part of SOS 212 (Systems, Dynamics, and Sustainability) at Arizona State University.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Физически-информированные нейронные сети (PINN) [Машинное обучение с учетом физики]](https://imager.clipsaver.ru/-zrY7P2dVC4/max.jpg)
