Related Experiment Videos
The use of microsoft excel as a user interface for biological simulations
G Tack1, R J Roselli, K A Overholser
1Department of Biomedical Engineering, Vanderbilt University, School of Engineering, Nashville, Tennessee 37235, USA.
Computers and Biomedical Research, an International Journal
|February 1, 1995
Summary
This study developed a user interface using Microsoft Excel 4.0 for biological simulation models, simplifying data input and output visualization for lung fluid balance and pulmonary circulation simulations.
Area of Science:
- Computational Biology
- Physiology
- Computer Science
Background:
- Biological simulations require user-friendly interfaces for data management and analysis.
- Existing simulation tools often lack integrated graphical user interfaces (GUIs).
Purpose of the Study:
- To develop a versatile GUI using Microsoft Excel 4.0 for biological simulation models.
- To enhance the usability of lung fluid balance and pulmonary circulation models.
Main Methods:
- Developed a GUI using Microsoft Excel 4.0 macro language.
- Integrated C-programmed simulation models (lung fluid balance, fractal pulmonary circulation).
- Implemented features for input file generation, output data display, and parameter adjustment.
Main Results:
- The Excel interface successfully managed input/output for biological simulations.
- Partial input field protection prevented unintended data modification.
- Enabled model component assembly, parameter selection, and batch mode execution.
- Facilitated steady-state value determination and graphical analysis of simulation outcomes.
Conclusions:
- The developed Excel-based GUI enhances biological simulation accessibility and efficiency.
- The interface design is adaptable for various biological simulation programs handling data files.
- This approach simplifies complex physiological modeling for researchers.