title: The use of microsoft excel as a user interface for biological simulations.
abstract: We used Microsoft Excel 4.0 for Windows running on a PC-486 to develop a user interface for two biological simulation models: a lung fluid balance model and a fractal model of the pulmonary circulation. The simulation programs were written in the C programming language, while the user interface was written in the macro language of Excel. The interface builds input data files for the simulation programs and provides a mechanism for displaying relevant information from output files produced from the simulations. Input fields are partially protected so that the user cannot modify certain portions of the spreadsheet. The Excel interface is used to build models from different available components and to select appropriate parameters for these models. The developed interface was also useful for running models in the batch mode. After selecting changes in lung fluid balance parameters, the interface allows users to find new steady state values by automatically running the model and adjusting initial conditions. Several different graphical options allow users to easily investigate the effects of selecting particular models and parameters. Techniques used in developing our user interface can be extended to most biological simulation programs which manipulate input and output data files.
authors.affiliation: Department of Biomedical Engineering, Vanderbilt University, School of Engineering, Nashville, Tennessee 37235, USA.
authors.forename: G
authors.initials: G
authors.lastname: Tack
authors.forename: R J
authors.initials: RJ
authors.lastname: Roselli
authors.forename: K A
authors.initials: KA
authors.lastname: Overholser
authors.forename: T R
authors.initials: TR
authors.lastname: Harris
mesh_terms: D003196:Computer Graphics; D003198:Computer Simulation; D003626:Data Display; D015633:Extravascular Lung Water / Q000378:metabolism; D017709:Fractals; D006801:Humans; D008168:Lung / Q000098:blood supply / Q000378:metabolism; D008954:Models, Biological; D011381:Programming Languages; D011652:Pulmonary Circulation; D012984:Software; D014584:User-Computer Interface; D014882:Water-Electrolyte Balance