Skip to main content Accessibility help
×
Home

A Simple Microsoft Excel Method to Predict Antibiotic Outbreaks and Underutilization

  • Cristina Miglis (a1) (a2), Nathaniel J. Rhodes (a1) (a2), Sean N. Avedissian (a1) (a2), Teresa R. Zembower (a3), Michael Postelnick (a2), Richard G. Wunderink (a4), Sarah H. Sutton (a3) and Marc H. Scheetz (a1) (a2)...

Abstract

Benchmarking strategies are needed to promote the appropriate use of antibiotics. We have adapted a simple regressive method in Microsoft Excel that is easily implementable and creates predictive indices. This method trends consumption over time and can identify periods of over- and underuse at the hospital level.

Infect Control Hosp Epidemiol 2017;38:860–862

Copyright

Corresponding author

Address correspondence to Marc H. Scheetz, PharmD, MSc, Associate Professor of Pharmacy Practice, Midwestern University Chicago College of Pharmacy; 555 31st St, Downers Grove, IL 60515 (mschee@midwestern.edu).

References

Hide All
1. Llor, C, Bjerrum, L. Antimicrobial resistance: risk associated with antibiotic overuse and initiatives to reduce the problem. Ther Adv Drug Saf 2014;5:229241.
2. Antibiotic resistance threats in the United States. Centers for Disease Control and Prevention website. http://www.cdc.gov/drugresistance/pdf/ar-threats-2013-508.pdf. Published 2013. Accessed September 1, 2016.
3. Spellberg, B, Gilbert, DN. The future of antibiotics and resistance: a tribute to a career of leadership by John Bartlett. Clin Infect Dis 2014;59(Suppl 2):S71S75.
4. Spellberg, B, Srinivasan, A, Chambers, HF. New societal approaches to empowering antibiotic stewardship. JAMA 2016;315:12291230.
5. Scheetz, MH, Crew, PE, Miglis, C, et al. Investigating the extremes of antibiotic use with an epidemiologic framework. Antimicrob Agents Ch 2016;60:32653269.
6. Antimicrobial use and resistance (AUR) module. Centers for Disease Control and Prevention website. http://www.cdc.gov/nhsn/PDFs/pscManual/11pscAURcurrent.pdf. Published 2016. Accessed August 29, 2016.
7. Confidence and prediction intervals for forcasted values. Real Statistics University Excel website. http://www.real-statistics.com/regression/confidence-and-prediction-intervals/. Published 2016. Accessed March 27, 2017.
8. Altman, DG, Bland, JM. Statistics notes—standard deviations and standard errors. Brit Med J 2005;331:903903.
9. Using Excel to compute a confidence interval. Graphpad software website. http://www.graphpad.com/support/faqid/1432/. Published 2016. Accessed March 27, 2017.
Type Description Title
UNKNOWN
Supplementary materials

Miglis supplementary material
Miglis supplementary material 1

 Unknown (51 KB)
51 KB

A Simple Microsoft Excel Method to Predict Antibiotic Outbreaks and Underutilization

  • Cristina Miglis (a1) (a2), Nathaniel J. Rhodes (a1) (a2), Sean N. Avedissian (a1) (a2), Teresa R. Zembower (a3), Michael Postelnick (a2), Richard G. Wunderink (a4), Sarah H. Sutton (a3) and Marc H. Scheetz (a1) (a2)...

Metrics

Altmetric attention score

Full text views

Total number of HTML views: 0
Total number of PDF views: 0 *
Loading metrics...

Abstract views

Total abstract views: 0 *
Loading metrics...

* Views captured on Cambridge Core between <date>. This data will be updated every 24 hours.

Usage data cannot currently be displayed