Software for Improving Mass Dispensing and Vaccination Clinic Operations

This software is provided free of charge for use by public health emergency preparedness planners. All of the software is copyrighted by the University of Maryland.

Clinic Planning Model Generator

The Clinic Planning Model Generator software creates a Microsoft Excel workbook for POD planning. Public health planners in 25 states have used the software to evaluate and improve their POD plans.

The software has the following features:

• You determine the patient flow that you want, and the planning model calculates the staff needed at each workstation to serve your population in the desired timeframe.
• Based on the staffing levels that you enter, the planning model determines POD capacity.
• The planning model also estimates how long patients will spend in a POD, which can be used to determine how much space you will need for patients waiting in lines.
• You can specify support and management staff, and you can enter the distances between workstations to estimate walking time.
• You can define your own workstations and add your own time study data.
• Microsoft Excel is the only required software.

The CLINIC PLANNING MODEL GENERATOR Version 2.04 is available for download free of charge.

See our Frequently Asked Questions and our blog for more information about the software.

Note: it is essential to have both the Clinic Generator and Clinic Template files in the same folder on your computer when using the software.

Note: If running Microsoft Excel 2003, you may need to change the Macro Security level to Medium. On the Excel Tools menu, click Options. Click the Security tab. Under Security, click Macro Security. Click the Security Level tab, and then click on the button next to Medium. Then click OK.

Registration: Please send an email to jwh2@umd.edu to tell us that you have downloaded the software. We will update you when revisions are available. We will not send you junk email.

Download: You can use the following links to download the user's guide and the software:

• Users Guide
• Clinic Generator
• Clinic Template
• Sample Clinic Model

You can also download a zip file that contains all of the above files.

• CPMG_2.04.zip

Copyright notice: Copyright 2008 University of Maryland and Montgomery County APC. All rights reserved.

Disclaimer: Cooperative Agreement Number U50/CCU302718 from the CDC to NACCHO supported this publication. Its contents are solely the responsibility of the University of Maryland and the Advanced Practice Center for Public Health Emergency Preparedness and Response of Montgomery County, Maryland, and do not necessarily represent the official views of CDC or NACCHO.

School Flu Mist Clinic Planning Model: The following complete clinic planning model was created for a local school district that is planning a school flumist clinic in which a batch of 15 students arrives every 5 minutes:

• school-flu-mist-clinic.xls

Drive-through Flu Clinic Example: The following complete model is an example of a clinic planning model. It was created for planning a drive-through flu clinic.

• Drive-through-clinic.xls

The CLINIC PLANNING MODEL GENERATOR Version 1.25 is still available for download as a zip file.

• Clinic Generator 1.25.zip

Sponsor

• The Montgomery County, Maryland, Advanced Practice Center for Public Health Emergency Preparedness and Response.
• CPMG is listed in the NACCHO STOCKbox set of tools.

Return to Project home page.

Last updated by Jeffrey W. Herrmann, August 26, 2009.