Disseminating Emergency Preparedness Planning Models as Automatically Generated Custom Spreadsheets

Jeffrey W. Herrmann ()
Additional contact information
Jeffrey W. Herrmann: Department of Mechanical Engineering and Institute for Systems Research, University of Maryland, College Park, Maryland 20742

Interfaces, 2008, vol. 38, issue 4, 263-270

Abstract: When public health officials requested OR models to help county health departments across the United States create plans for dispensing medications and vaccines during emergencies, we developed capacity planning and queueing network models. We then faced the challenge of distributing these models to people with minimal experience with OR techniques and no resources for acquiring and learning new software. To eliminate the most significant obstacles, we decided to use spreadsheets. We created a spreadsheet application that runs Visual Basic for Applications (VBA) macros to generate customized analytical models without the assistance of an OR professional; thus, users could evaluate a wide variety of plans. Developing spreadsheets for this type of application differs significantly from end-user modeling and typical spreadsheet applications. The software is available on our website for public health emergency preparedness planners to download.

Keywords: health care; treatment; planning; government; queues; approximations (search for similar items in EconPapers)
Date: 2008
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://dx.doi.org/10.1287/inte.1070.0335 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:38:y:2008:i:4:p:263-270

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().