Training: Assessing Public Health Laboratory Impact of Salmonella Diagnostic Testing

What to know

The Public Health Laboratory (PLH) Impact tool is a way to measure a laboratory's contribution to Salmonella diagnostic testing and its impact. The tool uses jurisdiction-specific data to estimate the number of cases, hospitalizations, and total direct medical costs averted due to public health response activities.

Scientific illustration of Salmonella, which are pink on a black background.

How the PHL Impact tool works: Data and results

To use the PHL Impact tool, provide data inputs for up to three example years for nontyphoidal Salmonella burden, PHL throughput, and costs associated with diagnostic testing. Input jurisdiction-specific estimates for five categories of data: epidemiology, medical costs, laboratory testing, laboratory costs, and outbreak response activities. PHL Impact tool uses these inputs to produce several types of results:

  • Burden of nontyphoidal Salmonella
  • Outbreak response activities
  • Volume of specimens and isolates tested by the public health laboratory
  • Total and average (per case) direct medical costs associated with Salmonella outbreak(s)
  • Total and average (per specimen/isolate) laboratory testing costs associated with Salmonella outbreak(s)

With the PHL Impact tool, users also have the option to develop up to two illustrations of response impact by providing information about one or two selected Salmonella outbreaks and associated response activities within their jurisdiction. After using the tool to generate findings, users can create a report to describe their PHL's contribution to and impact on Salmonella diagnostic testing. Estimates derived by the tool should not be considered forecasts of what will occur.

Getting started

Download the tool, user manual, and report template

We recommend downloading and saving the PHL Impact spreadsheet to your computer and then opening the spreadsheet from your computer. This will allow the spreadsheet to open in Excel instead of your web browser.

Load, start, and navigate

  1. Open the PHL Impact tool spreadsheet and click the box at the top of the spreadsheet that says "Enable Macros," or "Enable Content" (depending on the version of Excel being used).
  2. After enabling macros, click the "Start" button on the cover page to start navigating the tool.

If you encounter any issues, contact HEMU@cdc.gov with the subject line, "PHL Impact tool inquiry."

Changing input variables

When you download and open the PHL Impact tool spreadsheet, some inputs are pre-populated with numbers and estimates based on published sources. Users can change the values in the yellow cells in the tool to best illustrate Salmonella burden, direct medical, and laboratory testing costs in their jurisdiction. Further, we encourage users to enter a range of values to explore the impact of year-to-year variability. A user can, in the tool, click icon buttons at the top right corners of each page to see variable definitions and explanations. Additional explanations are provided in the accompanying manual.

Tip‎

PHL Impact tool uses the Windows** operating system (Microsoft Windows 2010 or higher) and Excel (Microsoft Office 2013 or higher). Full functionality of the tool is supported in the desktop version of Microsoft Office® for Windows. Some functionality may not be available in Microsoft Office for Macs or in the browser version of Office 365.


*Persons with disabilities experiencing problems accessing the spreadsheet should contact CDC-INFO at the CDC-INFO email form: http://www.cdc.gov/info/, 800-232-4636 or the TTY number at (888) 232-6348 and ask for a 508 Accommodation PR#2021-1. If emailing, please type "508 Accommodation PR#2021-1" without quotes in the subject line of the email and include the page URL in the email.

**Microsoft Windows and Office are copyrighted products produced by Microsoft Corporation, WA. The use of trade names and commercial sources is for identification only and does not imply endorsement by the U.S. Department of Health and Human Services.