ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
CDPHE Antibiotic Surveillance Tool for Long-Term Care FacilitiesCommon Antibiotics by Class:
2
Fluoroquinolonesciprofloxacin, delafloxacin, levofloxacin, moxifloxacin
3
This sheet is a tool to be used by long-term care facilities that are interested in tracking antibiotic usage and infection types among residents, in order to improve their antimicrobial stewardship program. DO NOT download this tool to an Excel document as formatting/equations will be lost. Please contact us if you need to work with an Excel file of the tool rather than the google sheet tool.
You will need to make your own copy of this google sheet tool in your own google account in order to edit/save your data entries. (You can open a google account using any email address; you don't need a gmail address to open a google account). Make a copy of google sheet navigate to "File" dropdown menu, click "Make a Copy": File>Make a Copy		Cephalosporinscefdinir, cefepime, cefixime, cefotaxime, cefpodoxime, ceftaroline, ceftazidime, ceftazidime-avibactam, ceftolozane-tazobactam, ceftriaxone, cefuroxime, cephalexin
4
Penicillins + Beta-lactamase Inhibitors
amoxicillin, amoxicillin-clavulanate, ampicillin-sulbactam, piperacillin-tazobactam
5
Instructions for Page 2:Carbapenemsertapenem, imipenem, imipenem-cilastatin-relebactam, meropenem, meropenem-vaborbactam
6
Enter the average number of residents each month in line 4 on the Data Sheet. Otherazithromycin, clindamycin, doxycycline, fosfomycin, nitrofurantoin, trimethoprim-sulfamethoxazole
7
8
Enter the number of antibiotic starts for urinary, respiratory, skin, and other infections for each month in lines 6 through 9. The totals will be added automatically.
9
10
Enter the number of residents treated for C. difficile each month in row 11.
11
12
Enter the numbers of different classes of antibiotics started in lines 14 through 19. Line 19 can be edited to track any antibiotic of the facility's choosing. The totals for each antibiotic used will also be added automatically.
13
14
The sheet will automatically calculate the number of infections, number of antibiotic starts and number of C. difficile cases per 1,000 resident days.
15
16
Instructions for Page 3:

This page provides a place to enter the number of different antibiotics prescribed by different providers working in or with the facility. Enter the total number of antibiotic starts based on antibiotic class for each month.

The tables below will populate automatically with the number of starts per quarter for each provider, as well as the total number of starts.
17
18
Pages 4-8 automatically populate from the data entered on Page 2, and cannot be edited. Page 4 shows a collection of bar charts visiualizing the number of different antibiotic starts per quarter for different providers. Page 5 displays a pie chart of the yearly total rates of the four categories of antibiotic starts per infection (urinary, respiratory, skin, and other). Page 6 is a bar chart of the four categories of antibiotic starts compared by quarter per 1,000 residents. Page 7 shows a bar chart showing the quarterly trends in antibiotic class prescribed per 1,000 residents (Fluoroquinolones, Penicillins, Cephalosporins, Carbapenems, Vancomycin, Other), and page 8 displays a bar chart with the number of C. difficile and UTI cases per quarter per 1,000 residents
19
20
For this tool, an "antibiotic start" will be defined as a new antibiotic prescribed to a resident during their time in the long-term care facility. It will not include antibiotics started in a separate facility and continued when the resident moved to the current facility, or antibiotics started while the resident was hospitalized. It should include all antibiotics prescribed within the facility, regardless of the number of doses taken or whether the antibiotic prescription was finished.
21
22
For assistance with this tool, please email
catherine.emanuel@state.co.us
lauren.biehle@state.co.us
rachel.schaefer@state.co.us
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100