{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Linelist","SummaryTables","EpiUpdateChart","PivotTable","Data Dictionary","DropDownMenuOptions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":1},"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":"Home","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,2,3],[3,1,3,3],[4,1,4,3]]}
[]
[]
[]
[null,"<Outbreak #> | <Outbreak/Event Name> "]
[null,"This tool can be used to organize cases during an outbreak investigation. \nUp to 200 cases and 70 exposures can be added to the line list tab."]
[null,"LINE LIST","SUMMARY TABLE","EPI UPDATE CHART"]
[]
[null,"PIVOT TABLE",null,"DATA DICTIONARY"]

{"sheet":"Linelist","index":1,"n_rows":4,"n_cols":121,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,50,2,120],[2,11,2,19],[2,20,2,36],[2,0,2,4],[2,5,2,7],[2,8,2,10],[2,37,2,45],[2,46,2,49]]}
[null,{"$f":"Home!B4","v":"<Outbreak #> | <Outbreak/Event Name> "}]
[null,"Refer to datadictionary as needed."]
["Case Identification",null,null,null,null,"Place",null,null,"Person",null,null,"Time/Date",null,null,null,null,null,null,null,null,"Symptoms/Complications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinical Specimen/Diagnostics",null,null,null,null,null,null,null,null,"Other",null,null,null,"Exposures/Risk Factors"]
["Case ID\n(Required field)","Provincial ID","Laboratory ID","Outbreak/ CLSN Cluster ID","Case Initials","P/T","HU","City","Age","Sex","Case Status","Report Date to Health Unit","Report Date to ________","Illness Onset Date","Specimen Collection Date","Isolation Date","PFGE Upload Date - NML","MLVA Report Date","Other Date","Other Date","Asymptomatic","Diarrhea","Bloody Diarrhea (HUS)","Vomitting","Headache","Chills","Nausea","Muscle Aches","Fever","Abdominal Cramps","Other","Other","Hospitalized","Death","Underlying Illness","Pregnant","Other Complications","Specimen Collection Done","Type of Specimen Collected","Genus Species (Pathogen)","Serotype/Serovar","PFGE 1","PFGE 2","Phage Type","MLVA","Notes","Link to Other Cases","Questionnaire Received","Questionnaire Type Used","Notes","exposure 1","exposure 2","exposure 3","exposure 4","exposure 5","exposure 6","exposure 7","exposure 8","exposure 9","exposure 10","exposure 11","exposure 12","exposure 13","exposure 14","exposure 15","exposure 16","exposure 17","exposure 18","exposure 19","exposure 20","exposure 21","exposure 22","exposure 23","exposure 24","exposure 25","exposure 26","exposure 27","exposure 28","exposure 29","exposure 30","exposure 31","exposure 32","exposure 33","exposure 34","exposure 35","exposure 36","exposure 37","exposure 38","exposure 39","exposure 40","exposure 41","exposure 42","exposure 43","exposure 44","exposure 45","exposure 46","exposure 47","exposure 48","exposure 49","exposure 50","exposure 51","exposure 52","exposure 53","exposure 54","exposure 55","exposure 56","exposure 57","exposure 58","exposure 59","exposure 60","exposure 61","exposure 62","exposure 63","exposure 64","exposure 65","exposure 66","exposure 67","exposure 68","exposure 69","exposure 70","exposure 71"]

{"sheet":"SummaryTables","index":2,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2],[0,1,0,11],[1,1,1,11]]}
[null,{"$f":"Linelist!B1","v":"<Outbreak #> | <Outbreak/Event Name> "}]
[null,"Summary of Cases"]
[]
[null,null,"TOTAL CASES",{"$f":"COUNTA(Linelist!K5:K200)","v":0},null,null,null,"ONSET DATES"]
[null,null,"Confirmed Cases",{"$f":"COUNTIF(Linelist!K5:K201,\"confirmed\")","v":0},null,null,null,"Start",{"$f":"MIN(Linelist!N5:N200)","v":"00:00:00"}]
[null,null,"Probable Cases",{"$f":"COUNTIF(Linelist!K5:K201,\"probable\")","v":0},null,null,null,"End",{"$f":"MAX(Linelist!N5:N200)","v":"00:00:00"}]
[null,null,"Unknown",{"$f":"COUNTIF(Linelist!K5:K201,\"unknown\")","v":0}]
[]
[null,null,"SEX                 known for:",{"$f":"D10+D12","v":0},null,null,null,"AGE"]
[null,null,"Number of Females",{"$f":"COUNTIF(Linelist!J5:J200, \"F\")","v":0},null,null,null,"Mean",{"$f":"AVERAGE(Linelist!I5:I200)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"(D10/(D10+D12))*100%","v":{"$error":"#DIV/0!"}},null,null,null,"Median",{"$f":"MEDIAN(Linelist!I5:I200)","v":{"$error":"#NUM!"}}]
[null,null,"Number of Males",{"$f":"COUNTIF(Linelist!J5:J200, \"M\")","v":0},null,null,null,"Min Age",{"$f":"MIN(Linelist!I5:I200)","v":0}]
[null,null,null,{"$f":"(D12/(D10+D12))*100%","v":{"$error":"#DIV/0!"}},null,null,null,"Max Age",{"$f":"MAX(Linelist!I5:I200)","v":0}]
[]
[null,null,"SYMPTOMS","Yes","No","%Y=Y/Y+N",null,"COMPLICATIONS","Yes","No","%Y=Y/Y+N"]
[null,null,{"$f":"Linelist!U4","v":"Asymptomatic"},{"$f":"COUNTIF(Linelist!U5:U1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!U5:U1048576,\"N\")","v":0},{"$f":"D16/(D16+E16)","v":{"$error":"#DIV/0!"}},null,{"$f":"Linelist!AG4","v":"Hospitalized"},{"$f":"COUNTIF(Linelist!AG5:AG200,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AG5:AG200,\"N\")","v":0},{"$f":"I16/(I16+J16)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"Linelist!V4","v":"Diarrhea"},{"$f":"COUNTIF(Linelist!V5:V1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!V5:V1048576,\"N\")","v":0},{"$f":"D17/(D17+E17)","v":{"$error":"#DIV/0!"}},null,{"$f":"Linelist!AH4","v":"Death"},{"$f":"COUNTIF(Linelist!AH5:AH200,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AH5:AH200,\"N\")","v":0},{"$f":"I17/(I17+J17)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"Linelist!W4","v":"Bloody Diarrhea (HUS)"},{"$f":"COUNTIF(Linelist!W5:W1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!W5:W1048576,\"N\")","v":0},{"$error":"#DIV/0!"},null,{"$f":"Linelist!AI4","v":"Underlying Illness"},{"$f":"COUNTIF(Linelist!AI5:AI200,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AI5:AI200,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!X4","v":"Vomitting"},{"$f":"COUNTIF(Linelist!X5:X1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!X5:X1048576,\"N\")","v":0},{"$error":"#DIV/0!"},null,{"$f":"Linelist!AJ4","v":"Pregnant"},{"$f":"COUNTIF(Linelist!AJ5:AJ200,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AJ5:AJ200,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!Y4","v":"Headache"},{"$f":"COUNTIF(Linelist!Y5:Y1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!Y5:Y1048576,\"N\")","v":0},{"$error":"#DIV/0!"},null,{"$f":"Linelist!AK4","v":"Other Complications"},{"$f":"COUNTIF(Linelist!AK5:AK200,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AK5:AK200,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!Z4","v":"Chills"},{"$f":"COUNTIF(Linelist!Z5:Z1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!Z5:Z1048576,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!AA4","v":"Nausea"},{"$f":"COUNTIF(Linelist!AA5:AA1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AA5:AA1048576,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!AB4","v":"Muscle Aches"},{"$f":"COUNTIF(Linelist!AB5:AB1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AB5:AB1048576,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!AC4","v":"Fever"},{"$f":"COUNTIF(Linelist!AC5:AC1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AC5:AC1048576,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!AD4","v":"Abdominal Cramps"},{"$f":"COUNTIF(Linelist!AD5:AD1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AD5:AD1048576,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!AE4","v":"Other"},{"$f":"COUNTIF(Linelist!AE5:AE1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AE5:AE1048576,\"N\")","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"Linelist!AF4","v":"Other"},{"$f":"COUNTIF(Linelist!AF5:AF1048576,\"Y\")","v":0},{"$f":"COUNTIF(Linelist!AF5:AF1048576,\"N\")","v":0},{"$error":"#DIV/0!"}]

{"sheet":"EpiUpdateChart","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,2],[8,1,9,1],[3,2,3,4],[2,1,2,4],[4,1,4,4],[5,2,5,4],[6,2,6,4],[14,2,14,4],[15,1,15,4],[1,1,1,4],[12,2,12,4],[11,2,11,4],[10,2,10,4],[9,2,9,4],[8,2,8,4]]}
[]
[null,{"$f":"Linelist!B1","v":"<Outbreak #> | <Outbreak/Event Name> "}]
[null,"Epidemiologic Update"]
[null,"Case Count",{"$f":"SummaryTables!D4","v":0}]
[null,"Age (years)"]
[null,"Mean",{"$f":"SummaryTables!I10","v":{"$error":"#DIV/0!"}}]
[null,"Median",{"$f":"SummaryTables!I11","v":{"$error":"#NUM!"}}]
[null,"   Range",{"$f":"SummaryTables!I12","v":0},"to",{"$f":"SummaryTables!I13","v":0}]
[null,"Sex\n% Female",{"$f":"SummaryTables!D11","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"SummaryTables!D10","v":0}]
[null,"Hospitalizations",{"$f":"SummaryTables!K16","v":{"$error":"#DIV/0!"}}]
[null,"HUS",{"$f":"SummaryTables!F18","v":{"$error":"#DIV/0!"}}]
[null,"Deaths",{"$f":"SummaryTables!K17","v":{"$error":"#DIV/0!"}}]
[null,"Onset date range",{"$f":"SummaryTables!I5","v":"00:00:00"},"to",{"$f":"SummaryTables!I6","v":"00:00:00"}]
[null,"Epi-curve"]
[null,"<copy and paste epi curve here>"]
[null,"†Note: <enter case definition for \"confirmed\" and \"probable\">"]

{"sheet":"PivotTable","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Linelist!B1","v":"<Outbreak #> | <Outbreak/Event Name> "}]
[null,"Pivot Table Analysis"]
["Make sure that every row has an ID (column A must be filled for every case)."]
["Use this page for any pivot table analysis; click on \"Count of ID\" to begin adding to your pivot table (a pane on the right will open)."]
["What is a Pivot Table?"]

{"sheet":"Data Dictionary","index":5,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,"Field Name Definition","Rationale","Variable Format"]
["Case ID","ID assigned by organization/agency investigating the outbreak","Case ID is used for identifcation of cases ","Alphanumeric"]
["Provincial ID","P/T public health case ID supplied by P/T (e.g. iPHIS number)","P/T case ID allows provincial colleagues to accurately identify the individual within their database for data verification and supports accurate linkage with laboratory identifiers and national IDs","Alphanumeric"]
["Laboratory ID","ID assigned by the laboratory, e.g. provincial laboratory, National Microbiology Lab (NML)",null,"Alphanumeric"]
["Outbreak/CLSN Cluster ID","Cluster ID assigned by  Canadian Network For Public Health Intelligence (CNPHI) on the Canadian Laboratory Surveillance Network (CLSN) discussion board",null,"Alphanumeric"]
["Case Initials","If relevant, the initials of the case can be included",null,"Text"]
["P/T","Province/Territory where case usually resides. This field is typcially the field that is used to assign a case to a P/T for case updates (follow-up)","P/T of usual residence is used in geographic analysis and for data management purposes","Drop down menu: lists each P/T"]
["HU","Health Unit (HU) where case usually resides","Health Unit is used in geographic analysis and for data management purposes","Text"]
["City","City where case usually resides","City is used in geographic analysis and for data management purposes.","Text"]
["Age","Age of case at time of illness onset","Age allows for identification of age-related trends at varying degrees of granularity, from specific years to compiled age-groups appropriate for the particular analysis ","The age of the person, expressed in years (and months for children under 1 year of age), at time of illness"]
["Sex","Legal sex of case","Sex allows for the identification and analysis of differential impacts and outcomes experienced by different sexes, and better identification of at-risk populations","Drop down menu: Male, Female, <leave blank>"]
["Case Status","Classification of case's status in the investigation specific to each investigation. \n\nCase defintions will be defined at the time of OICC investigation and will vary by circumstance. The category list can be modified with different case naming conventions if needed. Laboratory confirmed and Probable are most often used.","Classification Status supports the appropriate categorization of a case for reporting requirements and analysis","Drop down menu: Confirmed, Probably, Unknown, <leave blank>"]
["Report Date to Health Unit","Date case was reported to the local health unit.","Date case reported allows for measurement of timeliness of case notification during an investigation.","yyyy-mm-dd"]
["Report Date to ________","Date case was reported to an organization/agency of choice.\n","Date case reported allows for measurement of timeliness of case notification during an investigation.","yyyy-mm-dd"]
["Illness Onset Date","The date when the case began showing symptoms.","Symptom onset date type allows for data management and supports appropriate reporting and analysis.","yyyy-mm-dd"]
["Specimen Collection Date","The date when the specimen was collected.","Allows for data management and supports appropriate reporting and analysis.","yyyy-mm-dd"]
["Isolation Date","The date when the specimen was isolated.","Allows for data management and supports appropriate reporting and analysis.","yyyy-mm-dd"]
["PFGE Upload Date - NML","The date when PFGE results were uploaded by NML.","Allows for data management and supports appropriate reporting and analysis.","yyyy-mm-dd"]
["MLVA Report Date","The date when MLVA results were uploaded by NML.","Allows for data management and supports appropriate reporting and analysis.","yyyy-mm-dd"]
["Other Date","Any other date of interest can be entered.","Allows for data management and supports appropriate reporting and analysis.","yyyy-mm-dd"]
["Other Date","Any other date of interest can be entered.","Allows for data management and supports appropriate reporting and analysis.","yyyy-mm-dd"]
["Asymptomatic","Case did not show any symptoms.",null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Diarrhea","Three of more loose stools within 24 hours.",null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Bloody Diarrhea (HUS)","Hemolytic Uremic Syndrome (HUS). This field is only to be filled out if the case has E. coli","HUS is used as a measure of severity and burden of illness.","Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Vomitting",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Headache",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Chills",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Nausea",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Muscle Aches",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Fever",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Abdominal Cramps",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Other",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Other",null,null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Hospitalized","Whether the person was admitted to hospital in relation to the reported episode of the disease/condition.  Individuals who visit an emergency room or outpatient clinic are not included","Admitted to hospital is used as a measure of severity and burden of illness.","Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Death","The vital status of the person","Died is used to calculate case fatality and mortality rates and to estimate severity and burden of illness.","Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Underlying Illness","List any pre-existing medical conditions that the case currently has or is experiencing, that may result in a compromised immune system, thus placing the case at higher risk for more severe disease.\n\nIt is acknowledged that this variable is not systematically collected across jurisdictions. Variable is optional but available to capture information if it is collected by some jurisdictions. This variable could be very helpful in identifying pathogens with increased virulence. For example, if you were seeing increased rates of hospitalisations, HUS or deaths in young people, it would be important to understand if these individuals were healthy, or considered higher risk given underlying conditions.  ","Underlying illnesses is used in the analysis of risk. Individuals with underlying illness are known to be at higher risk for more severe disease. ","Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Pregnant","Whether the person is pregnant. To be entered for Listeria outbreak investigations only. If the case is a male enter \"not applicable\"","Pregnancy is used to describe the case and population at risk; also to help hypothesize on the source of illness. ","Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Other Complications","Report if any other complications reported.","Other complications is used in the analysis of risk.","Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Specimen Collection Done","Whether any specimen testing was done for this case.",null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Type of Specimen Collected","The type of specimen collected for each case: food, stool, blood, environmental.",null,"Drop down menu: Food, Stool, blood, Environmental, N/A"]
["Genus Species (Pathogen)","The pathogen isolated for each case.",null,"Text"]
["Serotype/Serovar","Serotype information for the isolated pathogen.",null,"Alphanumeric"]
["PFGE 1","1st enzyme PFGE pattern.",null,"Alphanumeric"]
["PFGE 2","2nd enzyme PFGE pattern.",null,"Alphanumeric"]
["Phage Type","Phage type information for the case.",null,"Alphanumeric"]
["MLVA","MLVA information for the case.",null,"Alphanumeric"]
["Notes","Notes related to clinical specimen testing or diagnostics",null,"Text"]
["Link to Other Cases","List the National ID of the case(s) that  are linked to this case","Cases linked to other cases is used to document epidemiologic links between cases where common exposures may have occurred.","(Abbreviated P/T characters-#)"]
["Questionnaire Received","Whether questionnaires were received for each case.",null,"Drop down menu: Yes, No, Don't Know (DK), N/A, <leave blank>"]
["Questionnaire Type Used","Track the type/name of the questionnaire on file for the case.",null,"Text"]
["Notes","Other Notes can be captured here.",null,"Text"]
["Exposures/Risk Factors (Exposures #1-71)","Exposure(s) of interest at the initial stage of the investigation (including travel/animal exposures); specific exposures are reported as separate variables. Preliminary exposure information includes travel, food consumption, animal contact, and social events. ","Preliminary exposure information can provide initial hypotheses regaring source, as well as initial inclusion/exclusion criteria for cases (e.g. exlcusion of travel-related cases). Additional (more detailed) exposure information, such as that from hypothesis-generating questionnaires, should be captured in a separate investigation-specific database.","Text"]

{"sheet":"DropDownMenuOptions","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,16383]]}
["Drop Down Menu Options"]
[]
["P/T","Gender","Yes/No","Case Status","Type of Specime","Pathogen"]
["AB","M","Y","Confirmed","Food","Campylobacter"]
["BC","F","N","Probable","Stool","Clostridium botulinum"]
["MB",null,"DK","Unknown","Blood","Clostridium perfringens"]
["NB",null,"N/A",null,"Environmental","E.coli"]
["NL",null,null,null,"N/A","Listeria"]
["NS",null,null,null,null,"Norovirus"]
["NT",null,null,null,null,"Salmonella"]
["NU",null,null,null,null,"Shigella"]
["ON"]
["PEI"]
["QC"]
["SK"]
["YT"]