IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v38y2008i4p263-270.html
   My bibliography  Save this article

Disseminating Emergency Preparedness Planning Models as Automatically Generated Custom Spreadsheets

Author

Listed:
  • Jeffrey W. Herrmann

    (Department of Mechanical Engineering and Institute for Systems Research, University of Maryland, College Park, Maryland 20742)

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.

Suggested Citation

  • Jeffrey W. Herrmann, 2008. "Disseminating Emergency Preparedness Planning Models as Automatically Generated Custom Spreadsheets," Interfaces, INFORMS, vol. 38(4), pages 263-270, August.
    • Handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:263-270
    DOI: 10.1287/inte.1070.0335
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.1070.0335
    Download Restriction: no
    File URL: https://libkey.io/10.1287/inte.1070.0335?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Stephen G. Powell, 1997. "The Teachers' Forum: From Intelligent Consumer to Active Modeler, Two MBA Success Stories," Interfaces, INFORMS, vol. 27(3), pages 88-98, June.
    2. Kay Aaby & Jeffrey W. Herrmann & Carol S. Jordan & Mark Treadwell & Kathy Wood, 2006. "Montgomery County’s Public Health Service Uses Operations Research to Plan Emergency Mass Dispensing and Vaccination Clinics," Interfaces, INFORMS, vol. 36(6), pages 569-579, December.
    3. Thomas A. Grossman, 1999. "Teachers' Forum: Spreadsheet Modeling and Simulation Improves Understanding of Queues," Interfaces, INFORMS, vol. 29(3), pages 88-103, June.
    4. Edwards, John S. & Finlay, Paul N. & Wilson, John M., 2000. "The role of OR specialists in `do it yourself' spreadsheet development," European Journal of Operational Research, Elsevier, vol. 127(1), pages 14-27, November.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Duijzer, Lotty Evertje & van Jaarsveld, Willem & Dekker, Rommert, 2018. "Literature review: The vaccine supply chain," European Journal of Operational Research, Elsevier, vol. 268(1), pages 174-192.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Thomas A. Grossman, 2002. "Student Consulting Projects Benefit Faculty and Industry," Interfaces, INFORMS, vol. 32(2), pages 42-48, April.
    2. Larry J. LeBlanc & Michael R. Galbreth, 2007. "Implementing Large-Scale Optimization Models in Excel Using VBA," Interfaces, INFORMS, vol. 37(4), pages 370-382, August.
    3. Cunha, Claudio Barbieri & Mutarelli, Fernando, 2007. "A spreadsheet-based optimization model for the integrated problem of producing and distributing a major weekly newsmagazine," European Journal of Operational Research, Elsevier, vol. 176(2), pages 925-940, January.
    4. Allan W. Gray & Joshua D. Detre & Brian C. Briggeman, 2005. "Valuing Limited Information in Decision Making Under Uncertainty," Working Papers 05-02, Purdue University, College of Agriculture, Department of Agricultural Economics.
    5. Briggeman, Brian C. & Detre, Joshua D. & Gray, Allan W., 2004. "Compound Options: A Real Options Application To An Agricultural Business," 2004 Annual meeting, August 1-4, Denver, CO 19996, American Agricultural Economics Association (New Name 2008: Agricultural and Applied Economics Association).
    6. Ubaid Illahi & Mohammad Shafi Mir, 2021. "Maintaining efficient logistics and supply chain management operations during and after coronavirus (COVID-19) pandemic: learning from the past experiences," Environment, Development and Sustainability: A Multidisciplinary Approach to the Theory and Practice of Sustainable Development, Springer, vol. 23(8), pages 11157-11178, August.
    7. Eva K. Lee & Chien-Hung Chen & Ferdinand Pietz & Bernard Benecke, 2009. "Modeling and Optimizing the Public-Health Infrastructure for Emergency Response," Interfaces, INFORMS, vol. 39(5), pages 476-490, October.
    8. Brian C. Briggeman & Allan W. Gray & Joshua D. Detre, 2008. "Using Limited Information to Support the Decision to Launch a New Product in the Fruit Juice Market: A Teaching Case Study," Review of Agricultural Economics, Agricultural and Applied Economics Association, vol. 30(2), pages 370-378.
    9. Kiygi-Calli, Meltem & Weverbergh, Marcel & Franses, Philip Hans, 2021. "Forecasting time-varying arrivals: Impact of direct response advertising on call center performance," Journal of Business Research, Elsevier, vol. 131(C), pages 227-240.
    10. Lawson, Barry R. & Baker, Kenneth R. & Powell, Stephen G. & Foster-Johnson, Lynn, 2009. "A comparison of spreadsheet users with different levels of experience," Omega, Elsevier, vol. 37(3), pages 579-590, June.
    11. Azrah A. Anparasan & Miguel A. Lejeune, 2018. "Data laboratory for supply chain response models during epidemic outbreaks," Annals of Operations Research, Springer, vol. 270(1), pages 53-64, November.
    12. Akash Dania & Bridget Anakwe & Bernadette Ruf, 2019. "Student Preference for Spreadsheet-Based Learning," Accounting and Finance Research, Sciedu Press, vol. 8(3), pages 1-16, August.
    13. Anton Ovchinnikov & Joseph Milner, 2008. "Spreadsheet Model Helps to Assign Medical Residents at the University of Vermont's College of Medicine," Interfaces, INFORMS, vol. 38(4), pages 311-323, August.
    14. Azrah Anparasan & Miguel Lejeune, 2019. "Resource deployment and donation allocation for epidemic outbreaks," Annals of Operations Research, Springer, vol. 283(1), pages 9-32, December.
    15. Kiygi Calli, M. & Weverbergh, M. & Franses, Ph.H.B.F., 2017. "Call center performance with direct response advertising," Econometric Institute Research Papers EI2017-04, Erasmus University Rotterdam, Erasmus School of Economics (ESE), Econometric Institute.
    16. Thomas A. Grossman, 1999. "Teachers' Forum: Spreadsheet Modeling and Simulation Improves Understanding of Queues," Interfaces, INFORMS, vol. 29(3), pages 88-103, June.
    17. Feng, Keli & Bizimana, Emmanuel & Agu, Deedee D. & Issac, Tana T., 2012. "Optimization and Simulation Modeling of Disaster Relief Supply Chain: A Literature Review," MPRA Paper 58204, University Library of Munich, Germany.
    18. Robinson, Stewart & Radnor, Zoe J. & Burgess, Nicola & Worthington, Claire, 2012. "SimLean: Utilising simulation in the implementation of lean in healthcare," European Journal of Operational Research, Elsevier, vol. 219(1), pages 188-197.
    19. Briggeman, Brian C. & Gunderson, Michael A. & Detre, Joshua D., 2006. "Protecting Your Turf: First-mover Advantages as a Barrier to Competitor Innovation," International Food and Agribusiness Management Review, International Food and Agribusiness Management Association, vol. 9(1), pages 1-18.
    20. Thomas A. Grossman & Vijay Mehrotra & Mouwafac Sidaoui, 2016. "A Student-Centered Approach to the Business School Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 16(2), pages 42-53, January.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:263-270. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.