{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Line List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":40,"n_cols":1,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Instructions for the LTC Acute Gastroenteritis Surveillance Line List Spreadsheet"]
["Complete the Line List on the \"Line List\" spreadsheet."]
[]
["A paper version is available at"]
["LTC Acute Gastroenteritis Outbreak Resources (print only)  [PDF – 7 pages]"]
["Section A: Case Demographics "]
["On each line, enter name and age of each person affected by the current outbreak at your facility. Use the dropdown to select gender and indicate whether the person is Resident or Staff."]
["Staff includes all healthcare personnel (e.g., nurses, physicians and other providers, therapists, food services, environmental services), whether employed, contracted, consulting, or volunteer. Answers might vary by facility due to differences in the names of resident care locations."]
["Residents only: Use the dropdown to indicate if the resident is on a Short stay or Long stay. Short stay residents are often admitted directly from hospitals, require skilled nursing or rehabilitation care, and are expected to stay less than 100 days. Long stay residents are admitted to receive residential care or nursing support and are expected to stay 100 days or more.  "]
["Section B: Case Location "]
["Residents only: Enter the building, unit, or floor where the resident is located and the room and bed number for each resident being monitored for outbreak illness. Answers might vary by facility due to differences in the names of resident care locations."]
["Staff only: Enter the floor, unit, or location where the staff member had been primarily working at the time of illness onset. "]
["Staff Only (Food handler): Select Yes or No from the dropdown to indicate if they were responsible for handling food at the beginning or during the outbreak period."]
["Section C: Signs and Symptoms (s/s)"]
["Symptom onset date: Enter the date (month/day) each person developed or reported s/s (e.g., abdominal cramps, diarrhea, vomiting) consistent with the outbreak illness."]
["Symptoms: Select Yes or No from the dropdown to indicate if they experienced abdominal pain or tenderness, diarrhea, or vomiting."]
["Additional documented s/s: Use the dropdown to select all additional s/s they experienced. Click the drop-down arrow for each additional item."]
["N: nausea     F: fever     B: blood in stool     LA: loss of appetite      O: other (Specify in the “other” column)   "]
["Definition of Fever \n1: a single oral temp > 37.8°C (100°F) or \n2: repeated oral temps > 37.2°C (99°F) or rectal temps > 37.5°C (99.5°F) or \n3: a single temp > 1.1°C (2°F) over baseline from any site (oral, tympanic, axillary).\nFrom: Stone N, Ashraf MS, Calder, J, et al. Surveillance Definitions in Long-Term Care Facilities: Revisiting the McGeer Criteria. Infect Control Hosp Epidemiol 2012; 33:965-977."]
["Other s/s: Enter all other s/s the person experienced."]
["Section D: Diagnostics"]
["Type of specimen collected:  Use the dropdown to select all types of specimens collected for laboratory testing. Click the drop-down arrow for each additional item."]
["S: stool     B: blood     O: other (Specify in the “other” column)"]
["Other type of specimen collected: Enter all other types of specimens collected."]
["Date of collection: Enter the date (month/day) of specimen collection."]
["Type of test ordered: Use the dropdown to select all the diagnostic laboratory tests that were performed for each individual. Click the drop-down arrow for each additional item."]
["0: no test performed     1: culture     2: Polymerase Chain Reaction (PCR), also called nucleic acid amplification testing, includes multiplex PCR tests for several organisms using a single specimen     3: urine antigen    \n4: other (Specify in the “other” column) "]
["Other type of test ordered: Enter other types of tests ordered."]
["Pathogen detected: Use the dropdown to select all the bacterial or viral organisms that were identified through laboratory testing. Click the drop-down arrow for each additional item."]
["0: Negative results   "]
["Bacterial:     1: Salmonella     2: Campylobacter     3: C. difficile     4: Shigella"]
["Viral:     5: Norovirus     6: Rotavirus "]
["7: Other (Specify in the “other” column)  "]
["Other type of pathogen detected: Enter other pathogens detected."]
["Section E: Outcome During Outbreak"]
["Outbreak defined as date of first case to resolution of last case."]
["Symptom Resolution Date: Enter the date that each person recovered from the outbreak illness and was symptom-free for 24 hours."]
["Hospitalized: Select Yes or No from the dropdown to indicate if hospitalization was required during the outbreak period. Note: The outbreak period is the time from the date of symptom onset for the first case to date of symptom resolution for the last case."]
["Died: Select Yes or No from the dropdown to indicate if the resident or staff member died during the outbreak period."]
["Case (C) or Not a case (leave blank): Based on the clinical criteria and laboratory findings collected during the outbreak investigation, select Case from the dropdown if the person meets the case definition. If the person is not a case, leave blank."]

{"sheet":"Line List","index":1,"n_rows":51,"n_cols":25,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["LTC Acute Gastroenteritis Surveillance Line List"]
["Date: "]
["This worksheet was created to help nursing homes and other LTC facilities detect, characterize and investigate a possible outbreak of respiratory illness."]
["Yellow boxes indicate a drop-down list."]
["Line List Table 1"]
["data entry key on this row","text",null,"male\nfemale","R: Resident\nS: Staff","S: Short stay\nL: Long stay","text","text","text","y/n","date","y/n","y/n","y/n","N: nausea\nF: fever\nB: blood in stool\nLA: loss of appetite\nO: other (specify)","text","S: stool\nB: blood\nO: other","date ","0: no test\n1: culture\n2: PCR\n3: other","0: Negative\n1: Salmonella\n2: Campy\n3: C. diff\n4: Shigella\n5: Norovirus\n6: Rotavirus\n7: other (specify)","text","date","y/n","y/n","Case \n(blank)"]
["#","A. Case Demographics",null,null,null,null,"B. Case Location",null,null,null,"C. Signs and Symptoms (s/s)",null,null,null,null,null,"D. Diagnostics",null,null,null,null,"E. Outcome During Outbreak "]
["#","Name","DOB\n(mm/dd/yy)","Gender","Resident / Staff","Residents Only (Stay)","Residents Only \n(Building / Floor)","Residents Only (Room / Bed)","Staff Only (Primary floor assignment)","Staff Only (Food handler)","Symptom onset date (mm/dd)","Abdominal pain or tenderness","Diarrhea","Vomiting","Additional documented s/s (select all that apply)","Other s/s","Type of specimen collected  (Select all that apply)","Date of collection (mm/dd)","Type of test ordered (Select all that apply)","Pathogen Detected (Select all that apply)","Other type of pathogen detected","Symptom resolution date (mm/dd)","Hospitalized","Died","Case or Not a case (leave blank)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
["line list end","line list end",null,"line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end","line list end"]
["facility information next 6 rows","If sending to your local Public Health Department, complete the following information:"]
[null,"Facility Name:"]
[null,"City, State: "]
[null,"County: "]
[null,"Contact Person:"]
[null,"Phone: "]
[null,"Email:"]
["form end","form end",null,"form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end","form end"]
[]
[]
[]
[]
["DO NOT TYPE BELOW THIS LINE","DO NOT TYPE BELOW THIS LINE"]
[null,null,null,null,"SYMPTOMS ","Type of specimen collected  (select alL that apply) ","Type of test ordered (Select all that apply)","Pathogen Detected (Select all codes  that apply) "]
[null,"Male",null,"Resident","N ","S",0,0,null,"Case ","Short stay"]
[null,"Female",null,"Staff ","F ","B",1,1,null,"     ","Long stay "]
[null,null,null,null,"B ","O",2,2]
[null,null,null,null,"LA ",null,3,3]
[null,null,null,null,"O",null,null,4]
[null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,7]