This Article Full Text (PDF) References Alert me when this article is cited Alert me if a correction is posted Services Email this article to a friend Similar articles in this journal Alert me to new issues of the journal Download to citation manager Citing Articles Citing Articles via HighWire Citing Articles via Google Scholar Google Scholar Articles by Herrmann, J. W. Search for Related Content

Disseminating Emergency Preparedness Planning Models as Automatically Generated Custom Spreadsheets

Department of Mechanical Engineering and Institute for Systems Research, University of Maryland, College Park, Maryland 20742
jwh2{at}umd.edu

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.

Key Words: health care; treatment; planning; government; queues; approximations

This article has been cited by other articles:

				M. L. Brandeau, J. H. McCoy, N. Hupert, J.-E. Holty, and D. M. Bravata Recommendations for Modeling Disaster Responses in Public Health and Medicine: A Position Paper of the Society for Medical Decision Making Med Decis Making, July 1, 2009; 29(4): 438 - 460. [Abstract] [PDF]