{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Title","Intro","1. Epidemiology","2. Medical Costs","3. Lab Testing","4. Lab Costs","5. Response Activities","6. Response Illustrations","Results","Results - Response Illustration","National Outbreak","Epidemiology (Details)","Health Outcomes","Response Impact","Data Summary","Mean COI","Data Read Me","Low","High"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":1,"defined_names":112,"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":"Title","index":0,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,5,16,20],[17,5,17,20],[0,0,1,25],[4,5,4,20],[5,5,5,20],[7,5,7,20],[8,5,8,20],[15,5,15,20],[11,5,11,20],[12,5,12,20]]}
["CENTERS FOR DISEASE CONTROL & PREVENTION (CDC)"]
[]
[]
[]
[null,null,null,null,null,"Public Health Laboratory Impact:"]
[null,null,null,null,null," A tool to estimate public health laboratory contribution to and impact of Salmonella diagnostic testing"]
[]
[null,null,null,null,null,"Authors: Leah S. Fischer, Seonghye Jeon, Emily B. Kahn, Gloria J. Kang, Martin I. Meltzer (HEMU/CDC)"]
[null,null,null,null,null,"Ian D. Plumb,  Hilary K. Whitham (DFWED/CDC), Eija Trees (APHL)"]
[null,null,null,null,null,null,null,null,null,null,null,"Contact Info: HEMU@cdc.gov"]
[]
[null,null,null,null,null,"Acknowledgments: H. Hanson, K. Kubota, L. Kurimski, K. Larson, S. Shea, B. Su, A. Wright, A. Yusuf (APHL)"]
[null,null,null,null,null,"C. Bean, D. Boxrud, R. Jepson, P. Lewandowski, M. Pentella, D. Severson, V. Waddell (APHL - Member Laboratories)"]
[]
[]
[null,null,null,null,null,"Version 1.0"]
[null,null,null,null,null,"Date of this version:"]
[null,null,null,null,null,"2021-02-09"]

{"sheet":"Intro","index":1,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,16383],[21,2,28,11],[4,2,5,11],[11,4,11,11],[9,4,9,11]]}
["INTRODUCTION"]
[]
[null,null,"About the Tool"]
[]
[null,null,"This tool allows public health decision-makers and funders to estimate the resources needed for Salmonella diagnostic testing by public health laboratories and its impact on outcomes associated with Salmonella such as ER visits, hospitalizations, and deaths."]
[]
[]
[null,null,"Instruction"]
[]
[null,null,"User Input",null,"Click the yellow cells and enter your values; they are pre-populated with illustrative numbers or suggested default values."]
[]
[null,null,"Calculated or linked cell",null,"Grey cells contain formula or calculation; they will be automatically updated based on user entries in the yellow cells."]
[]
[null,null,"Link to other pages",null,"Blue cells are linked to other pages that contain detailed calculations or assumed default parameters. "]
[]
[null,null,null,null,"Click the arrow buttons on the upper right corner to navigate through the tool. "]
[]
[null,null,null,null,"Click the icons to see general information, definitions and detailed explanations of the corresponding page. "]
[]
[]
[null,null,"Background"]
[null,null,"Public health laboratories (PHLs) have a role in protecting public health and the environment by performing a range of critical services that include reference testing, diagnostic testing, disease surveillance, and emergency response support. This tool was developed to evaluate PHL system contributions to and impact on nontyphoidal Salmonella diagnostic testing at local jurisdiction levels, given the relatively large disease burden associated with outbreaks, cases, and hospitalizations from Salmonella infections in the United States. Nontyphoidal Salmonella are estimated to cause 1.35 million infections, 26,600 hospitalizations, and 421 deaths each year in the United States, resulting in an estimated $400 million in direct medical costs when accounting for under-reported and under-diagnosed cases. "]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Descriptions of Health Outcomes Considered in this Model"]
[]
[null,null,"Non-hospitalized cases",null,"Recovered cases without a visit to physician office, ER room or hospital."]
[]
[null,null,"Received medical care",null,"Visited a physician, emergency room, or hospital-based outpatient clinic."]
[]
[null,null,"Physician office visit",null,"Visited physician office."]
[]
[null,null,"Emergency room visit",null,"Visited emergency room."]
[]
[null,null,"Hospital-based",null,"Visited hospital-based outpatient clinic."]
[null,null,"outpatient clinic visit"]
[]
[null,null,"Hospitalized cases",null,"Hospitalized cases were assumed to have additional medical costs including physician care,"]
[null,null,"(inpatient overnight stays)",null,"emergency room services, and outpatient services. Hospitalizations may result in recovery or death."]
[]
[null,null,"Death",null,"Death in this tool is always preceded by hospitalization."]
[]
[]
[]
[]
[null,"References"]
[]
[null,"CDC National Outbreak Reporting System (NORS)"]
[null,null,"https://wwwn.cdc.gov/norsdashboard/"]
[null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014."]
[null,null,"Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]
[null,"Economic Research Service (ERS), U.S. Department of Agriculture (USDA). "]
[null,null,"Cost Estimates of Foodborne Illnesses. http://ers.usda.gov/data-products/cost-estimates-of-foodborne-illnesses.aspx.(2014)."]
[null,"Hoffmann, Sandra, Michael Batz, J. Glenn Morris Jr.  2012. "]
[null,null,"“Annual Cost of Illness and Quality-Adjusted Life Year Losses in the United States Due to 14 Foodborne Pathogens.” J. Food Protection 75(7): 1291-1302."]
[null,"Hoffmann, Sandra, Bryan Maculloch, and Michael Batz."]
[null,null,"Economic Burden of Major Foodborne Illnesses Acquired in the United States, EIB-140, U.S. Department of Agriculture, Economic Research Service, May 2015."]
[null,"Scallan, E., Hoekstra, R. M., Angulo, F. J., Tauxe, R. V., Widdowson, M., Roy, S. L....Griffin, P. M. (2011). "]
[null,null,"Foodborne Illness Acquired in the United States—Major Pathogens. Emerging Infectious Diseases, 17(1), 7-15. https://dx.doi.org/10.3201/eid1701.p11101."]
[null,"Robert L. Scharff, John Besser, Donald J. Sharp, Timothy F. Jones, Peter Gerner-Smidt, Craig W. Hedberg (2016)."]
[null,null,"An Economic Evaluation of PulseNet: A Network for Foodborne Disease Surveillance. American Journal of Preventive Medicine, 50(5)."]

{"sheet":"1. Epidemiology","index":2,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,5,22,7],[3,2,3,4],[11,5,12,7],[38,5,39,7]]}
["1. EPIDEMIOLOGY"]
[null,null,"Low year","Average year","High year"]
[null,"Year(s):",2020,2000,2010]
[null,"For:","U.S. State"]
[]
[null,"Reported Cases and Outcomes",null,null,null,null,null,null,null,null,"Note: The default numbers on this page are for illustrative purposes only."]
[null,null,null,null,null,null,null,null,null,null,"Enter your numbers in the yellow cell. Click the icons for more information."]
[null,null,"Number of lab confirmed reported Salmonella cases",null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,null,"National (for comparison)",null,{"$f":"national_low","v":21268.033920000002},{"$f":"national_med","v":39385.248},{"$f":"national_high","v":70893.446400000001}]
[null,null,null,{"$f":"TEXT(area,\"\")","v":"U.S. State"},null,400,800,1200]
[]
[null,null,null,null,null,"Click here to see the national estimates of Salmonella cases"]
[]
[]
[null,null,"Note: Calculated based on the % of health outcomes (Batz et al. 2010). Users may enter in values if data are available."]
[null,null,{"$f":"\"Total hospitalized in \"&TEXT(area,\"\")","v":"Total hospitalized in U.S. State"},null,null,{"$f":"'Epidemiology (Details)'!L11","v":7.5200000000000005},{"$f":"'Epidemiology (Details)'!M11","v":15.040000000000001},{"$f":"'Epidemiology (Details)'!N11","v":22.560000000000002}]
[null,null,null,"Died",null,{"$f":"'Epidemiology (Details)'!L16","v":0.15040000000000001},{"$f":"'Epidemiology (Details)'!M16","v":0.30080000000000001},{"$f":"'Epidemiology (Details)'!N16","v":0.45120000000000005}]
[]
[null,null,{"$f":"\"Total non-hospitalized in \"&TEXT(area,\"\")","v":"Total non-hospitalized in U.S. State"},null,null,{"$f":"'Epidemiology (Details)'!L18","v":392.48},{"$f":"'Epidemiology (Details)'!M18","v":784.96},{"$f":"'Epidemiology (Details)'!N18","v":1177.44}]
[null,null,null,"Received medical care",null,{"$f":"'Epidemiology (Details)'!L19","v":28.799999999999997},{"$f":"'Epidemiology (Details)'!M19","v":57.599999999999994},{"$f":"'Epidemiology (Details)'!N19","v":86.399999999999991}]
[]
[null,null,null,null,null,"Click here to edit epidemiologic parameters (e.g., % hospitalization, % death)"]
[]
[]
[]
[null,"Estimated Cases and Outcomes modified for under-reporting and under-diagnosis"]
[]
[null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,"Number of estimated Salmonella cases",null,null,{"$f":"'Epidemiology (Details)'!V9","v":11640},{"$f":"'Epidemiology (Details)'!W9","v":23280},{"$f":"'Epidemiology (Details)'!X9","v":34920}]
[]
[null,null,{"$f":"\"Total hospitalized in \"&TEXT(area,\"\")","v":"Total hospitalized in U.S. State"},null,null,{"$f":"'Epidemiology (Details)'!V11","v":218.83200000000002},{"$f":"'Epidemiology (Details)'!W11","v":437.66400000000004},{"$f":"'Epidemiology (Details)'!X11","v":656.49599999999998}]
[null,null,null,"Died",null,{"$f":"'Epidemiology (Details)'!V16","v":4.376640000000001},{"$f":"'Epidemiology (Details)'!W16","v":8.7532800000000019},{"$f":"'Epidemiology (Details)'!X16","v":13.12992}]
[]
[null,null,{"$f":"\"Total non-hospitalized in \"&TEXT(area,\"\")","v":"Total non-hospitalized in U.S. State"},null,null,{"$f":"'Epidemiology (Details)'!V18","v":11421.168},{"$f":"'Epidemiology (Details)'!W18","v":22842.335999999999},{"$f":"'Epidemiology (Details)'!X18","v":34263.504000000001}]
[null,null,null,"Received medical care",null,{"$f":"'Epidemiology (Details)'!V19","v":838.07999999999993},{"$f":"'Epidemiology (Details)'!W19","v":1676.1599999999999},{"$f":"'Epidemiology (Details)'!X19","v":2514.2399999999998}]
[]
[null,null,"Note: Modified for",{"$f":"\"under-reporting factor of \"&TEXT(under_rep_adj,\"#.#\") & \"0 and under-diagnosis factor of \" &TEXT(under_diag_adj,\"##.#\")","v":"under-reporting factor of 1.0 and under-diagnosis factor of 29.1"}]
[]
[null,null,null,null,null,"Click here to edit \nunder-reporting or under-diagnosis factors"]
[]
[]
[]
[]
[null,"References"]
[]
[null,"Scallan, E., Hoekstra, R. M., Angulo, F. J., Tauxe, R. V., Widdowson, M., Roy, S. L....Griffin, P. M. (2011). "]
[null,null,"Foodborne Illness Acquired in the United States—Major Pathogens. Emerging Infectious Diseases, 17(1), 7-15. https://dx.doi.org/10.3201/eid1701.p11101."]
[null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014."]
[null,null,"Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]
[null,"Collier SA, Deng L, Adam EA, Benedict KM, Beshearse EM, Blackstock AJ, et al. "]
[null,null,"Estimate of Burden and Direct Healthcare Cost of Infectious Waterborne Disease in the United States. Emerging Infectious Diseases. 2021;27(1):140-9. doi: 10.3201/eid2701.190676."]

{"sheet":"2. Medical Costs","index":3,"n_rows":23,"n_cols":27,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["2. DIRECT MEDICAL COSTS"]
[]
[null,"Note: Enter your numbers in the yellow cell. Click the icon for more information."]
[]
[]
[null,"Health outcome costs (2019 USD)"]
[null,null,null,null,"Mean cost per visit"]
[null,null,null,"Physician office visit",{"$f":"'Data Summary'!F18","v":135.95675543730002}]
[]
[null,null,null,"Emergency room visit",{"$f":"'Data Summary'!F21","v":572.93437185783}]
[]
[null,null,null,"Hospital-based ",{"$f":"'Data Summary'!F24","v":658.82731349811002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: This table is to convert the medical cost reported as 2013 USD into 2019 USD."]
[null,null,null,"outpatient clinic visit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: https://www.bls.gov/cpi/factsheets/medical-care.htm"]
[null,null,null,null,"Mean cost per hospitalization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Medical CPI"]
[null,null,null,"Hospitalization",{"$f":"'Data Summary'!F27","v":13938.024278606757},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,454.01100000000002]
[null,null,null,"(inpatient overnight stays)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,536.14700000000005]
[]
[null,"Note: Default values are the mean cost per visit, and likely higher than the median cost (which is the most representative cost estimate of the population)."]
[]
[null,"References"]
[]
[null,"Economic Research Service (ERS), U.S. Department of Agriculture (USDA). Cost Estimates of Foodborne Illnesses."]
[null,null," http://ers.usda.gov/data-products/cost-estimates-of-foodborne-illnesses.aspx"]

{"sheet":"3. Lab Testing","index":4,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["3. JURISDICTION LABORATORY TESTING"]
[]
[null,"Note: The default numbers on this page are for illustrative purposes only."]
[]
[]
[null,"Throughput"]
[]
[null,null,"Salmonella testing breakdown",null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,"Total number of Salmonella specimens received",null,{"$f":"SUM(E10:E11)","v":100},{"$f":"SUM(F10:F11)","v":200},{"$f":"SUM(G10:G11)","v":500}]
[null,null,null,"Specimens tested by the PHL",100,200,500]
[null,null,null,"Specimens sent elsewhere by PHL ",0,0,0]
[]
[null,null,"Total number of Salmonella isolates received",null,{"$f":"SUM(E14:E15)","v":400},{"$f":"SUM(F14:F15)","v":800},{"$f":"SUM(G14:G15)","v":1200}]
[null,null,null,"Isolates tested by the PHL",400,800,1200]
[null,null,null,"Isolates sent elsewhere by PHL ",0,0,0]
[]
[]
[null,"Specimens"]
[]
[null,null,"Salmonella specimens tested by the PHL",null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,"Number of Salmonella specimens tested by PHL",null,{"$f":"sample_low","v":100},{"$f":"sample_med","v":200},{"$f":"sample_high","v":500}]
[null,null,null,"Perform Culture",100,200,500]
[null,null,null,"CIDT",100,200,500]
[null,null,null,"Other: ______________"]
[null,null,null,"Other: ______________"]
[]
[]
[null,"Isolates"]
[]
[null,null,"Salmonella isolates tested by the PHL",null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,"Number of Salmonellaisolates tested by PHL",null,{"$f":"isolate_low","v":400},{"$f":"isolate_med","v":800},{"$f":"isolate_high","v":1200}]
[null,null,null,"Conventional Serotyping",0,0,0]
[null,null,null,"Molecular Serotyping ",400,800,1200]
[null,null,null,"Antimicrobial Susceptibility",400,800,1200]
[null,null,null,"PFGE",400,800,1200]
[null,null,null,"WGS Lab",400,800,1200]
[null,null,null,"WGS Data Analysis",400,800,1200]
[null,null,null,"Other: _______________"]
[null,null,null,"Other: _______________"]

{"sheet":"4. Lab Costs","index":5,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[6,6,6,7]]}
["4. JURISDICTION LABORATORY TESTING COSTS"]
[]
[null,"Note: Default cost values are approximate estimates based on published literatures and may not best represent your jurisdiction."]
[]
[]
[null,"Salmonella Specimen costs"]
[]
[null,null,"Mean Cost per Specimen Tested",null,null,null,"Lower Estimate","Upper Estimate",null,null,null,null,null,null,null,null,"Low year","Med year","High year"]
[null,null,null,{"$f":"'3. Lab Testing'!D22","v":"Perform Culture"},{"$f":"G9","v":67.897199999999998},null,{"$f":"6789.72/100","v":67.897199999999998},{"$f":"G9*1.5","v":101.8458},null,null,null,null,null,null,null,"Total cost, Culture",{"$f":"E9*'3. Lab Testing'!E22","v":6789.7199999999993},{"$f":"E9*'3. Lab Testing'!F22","v":13579.439999999999},{"$f":"E9*'3. Lab Testing'!G22","v":33948.6}]
[null,null,null,{"$f":"'3. Lab Testing'!D23","v":"CIDT"},{"$f":"G10","v":251.636},null,{"$f":"25163.6/100","v":251.636},{"$f":"G10*1.5","v":377.45400000000001},null,null,null,null,null,null,null,"Total cost, CIDT",{"$f":"E10*'3. Lab Testing'!E23","v":25163.599999999999},{"$f":"E10*'3. Lab Testing'!F23","v":50327.199999999997},{"$f":"E10*'3. Lab Testing'!G23","v":125818}]
[null,null,null,{"$f":"'3. Lab Testing'!D24","v":"Other: ______________"},null,null,null,null,null,null,null,null,null,null,null,"Total cost, Other",{"$f":"E11*'3. Lab Testing'!E24","v":0},{"$f":"E11*'3. Lab Testing'!F24","v":0},{"$f":"E11*'3. Lab Testing'!G24","v":0}]
[null,null,null,{"$f":"'3. Lab Testing'!D25","v":"Other: ______________"},null,null,null,null,null,null,null,null,null,null,null,"Total cost, Other",{"$f":"E12*'3. Lab Testing'!E25","v":0},{"$f":"E12*'3. Lab Testing'!F25","v":0},{"$f":"E12*'3. Lab Testing'!G25","v":0}]
[]
[null,"Salmonella Isolate costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total cost to process specimen",{"$f":"SUM(Q9:Q12)/sample_low","v":319.53320000000002},{"$f":"SUM(R9:R12)/sample_med","v":319.53320000000002},{"$f":"SUM(S9:S12)/sample_high","v":319.53320000000002}]
[]
[null,null,"Mean Cost per Isolate Tested",null,null,null,"Lower Estimate","Upper Estimate"]
[null,null,null,{"$f":"'3. Lab Testing'!D32","v":"Conventional Serotyping"},{"$f":"G17","v":93},null,{"$f":"111600/1200","v":93},{"$f":"G17*1.5","v":139.5},null,null,null,null,null,null,null,"Total cost, Conventional Serotyping",{"$f":"E17*'3. Lab Testing'!E32","v":0},{"$f":"E17*'3. Lab Testing'!F32","v":0},{"$f":"E17*'3. Lab Testing'!G32","v":0}]
[null,null,null,{"$f":"'3. Lab Testing'!D33","v":"Molecular Serotyping "},31,null,31,88,null,null,null,null,null,null,null,"Total cost, Molecular Serotyping ",{"$f":"E18*'3. Lab Testing'!E33","v":12400},{"$f":"E18*'3. Lab Testing'!F33","v":24800},{"$f":"E18*'3. Lab Testing'!G33","v":37200}]
[null,null,null,{"$f":"'3. Lab Testing'!D34","v":"Antimicrobial Susceptibility"},30.28,null,{"$f":"36336/1200","v":30.28},45.42,null,null,null,null,null,null,null,"Total cost, AMR",{"$f":"E19*'3. Lab Testing'!E34","v":12112},{"$f":"E19*'3. Lab Testing'!F34","v":24224},{"$f":"E19*'3. Lab Testing'!G34","v":36336}]
[null,null,null,{"$f":"'3. Lab Testing'!D35","v":"PFGE"},94.2,null,{"$f":"113040/1200","v":94.2},141.30000000000001,null,null,null,null,null,null,null,"Total cost, PFGE",{"$f":"E20*'3. Lab Testing'!E35","v":37680},{"$f":"E20*'3. Lab Testing'!F35","v":75360},{"$f":"E20*'3. Lab Testing'!G35","v":113040}]
[null,null,null,{"$f":"'3. Lab Testing'!D36","v":"WGS Lab"},211.75,null,{"$f":"254100/1200","v":211.75},317.625,null,null,null,null,null,null,null,"Total cost, WGS lab",{"$f":"E21*'3. Lab Testing'!E36","v":84700},{"$f":"E21*'3. Lab Testing'!F36","v":169400},{"$f":"E21*'3. Lab Testing'!G36","v":254100}]
[null,null,null,{"$f":"'3. Lab Testing'!D37","v":"WGS Data Analysis"},{"$f":"G22","v":13},null,13,40,null,null,null,null,null,null,null,"Total cost, WGS data analysis",{"$f":"E22*'3. Lab Testing'!E37","v":5200},{"$f":"E22*'3. Lab Testing'!F37","v":10400},{"$f":"E22*'3. Lab Testing'!G37","v":15600}]
[null,null,null,{"$f":"'3. Lab Testing'!D38","v":"Other: _______________"},null,null,null,null,null,null,null,null,null,null,null,"Total cost, Other",{"$f":"E23*'3. Lab Testing'!E38","v":0},{"$f":"E23*'3. Lab Testing'!F38","v":0},{"$f":"E23*'3. Lab Testing'!G38","v":0}]
[null,null,null,{"$f":"'3. Lab Testing'!D39","v":"Other: _______________"},null,null,null,null,null,null,null,null,null,null,null,"Total cost, Other",{"$f":"E24*'3. Lab Testing'!E39","v":0},{"$f":"E24*'3. Lab Testing'!F39","v":0},{"$f":"E24*'3. Lab Testing'!G39","v":0}]
[]
[null,"Shipping costs for specimens and isolates sent elsewhere",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total cost to process isolates",{"$f":"SUM(Q17:Q24)/isolate_low","v":380.23},{"$f":"SUM(R17:R24)/isolate_med","v":380.23},{"$f":"SUM(S17:S24)/isolate_high","v":380.23}]
[]
[null,null,"Mean cost per shipment of"]
[null,null,null,"specimens sent elsewhere",60,null,null,null,null,null,null,null,null,null,null,"Total cost, shipping specimen",{"$f":"$E$29*'3. Lab Testing'!E11","v":0},{"$f":"$E$29*'3. Lab Testing'!F11","v":0},{"$f":"$E$29*'3. Lab Testing'!G11","v":0}]
[null,null,null,"Isolates sent elsewhere",60,null,null,null,null,null,null,null,null,null,null,"Total cost, shipping isolates",{"$f":"$E$30*'3. Lab Testing'!E15","v":0},{"$f":"$E$30*'3. Lab Testing'!F15","v":0},{"$f":"$E$30*'3. Lab Testing'!G15","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total costs",{"$f":"SUM(Q9:Q12)+SUM(Q17:Q24)+SUM(Q29:Q30)","v":184045.32},{"$f":"SUM(R9:R12)+SUM(R17:R24)+SUM(R29:R30)","v":368090.64},{"$f":"SUM(S9:S12)+SUM(S17:S24)+SUM(S29:S30)","v":616042.6}]
[]
[]
[null,"References"]
[]
[null,"Specimen Culture and CIDT cost"]
[null,"Aamer Imdad, Fiona Retzer, Linda S Thomas, et al. (2018)"]
[null,null,"Impact of Culture-Independent Diagnostic Testing on Recovery of Enteric Bacterial Infections. Clin Infect Dis. 2018 Jun 15; 66(12): 1892–1898."]
[null,"Conventional Serotyping cost",null,null,null,null,null,null,null,null,"$111,600/ 1,200 isolates = $93"]
[null,"Eija Trees, Cristina Maria da Silva, Bishwa Adhikari, Greg Armstrong (2018)"]
[null,null,"Economics of Next Genome Sequencing for Salmonella, CDC Office of Advanced Molecular Detection"]
[null,"Molecular Serotyping cost"]
[null,"Personal communication with Eija Trees and CDC reference lab"]
[null,null,"Note: It does not include the capital investment in instrumentation, i.e. the Bioplex machine and a thermocycler; therefore, the overall cost is lower than the conventional serotyping cost. It is important to note that the labor cost is much less in molecular serotyping because the assay is quick (1.5-3 h) and one person can process as many as 94 samples at a time. "]
[null,"Serotyping cost"]
[null,"Association of Public Health Laboratories (2014)"]
[null,null,"Salmonella Serotyping in US Public Health Laboratories. White Paper. Nov 2014"]
[null,null,"https://www.aphl.org/aboutAPHL/publications/Documents/FS_SalmonellaSustainabilityWhitePaper_Nov2014.pdf"]
[null,"Catherine Yoshida, Simone Gurnik, Aaminah Ahmad, Travis Blimkie, Stephanie A. Murphy, Andrew M. Kropinski, John H. E. Nash (2016)"]
[null,null,"Evaluation of Molecular Methods for Identification of Salmonella Serovars. J Clin Microbiol. 2016 Aug; 54(8): 1992–1998."]
[null,"Antimicrobial susceptibility cost",null,null,null,null,null,null,null,null,"$36,336/ 1,200 isolates = $30.28"]
[null,"Eija Trees, Cristina Maria da Silva, Bishwa Adhikari, Greg Armstrong (2018)"]
[null,null,"Economics of Next Genome Sequencing for Salmonella, CDC Office of Advanced Molecular Detection"]
[null,"PFGE cost"]
[null,"Kimberlee Musser (2017)"]
[null,null,"Implementation and Impact of Salmonella serotype determination using pulsed-field gel electrophoresis in New York ",null,null,null,null,null,null,null,"$117,419/ 1,700 isolates = $69.07"]
[null,null,"https://www.aphl.org/conferences/proceedings/Documents/2017/Annual-Meeting/56Musser.pdf"]
[null,"Kristy A. Kubota, William J. Wolfgang, Deborah J. Baker, David Boxrud, Lauren Turner, Eija Trees, Heather A. Carleton, Peter Gerner-Smidt (2019)",null,null,null,null,null,null,null,null,"$30 /isolate"]
[null,null,"PulseNet and the Changing Paradigm of Laboratory-Based Surveillance for Foodborne Diseases. Public Health Reports. 2019 Nov; 134(2_suppl): 22S-28S"]
[null,"Eija Trees, Cristina Maria da Silva, Bishwa Adhikari, Greg Armstrong (2018)"]
[null,null,"Economics of Next Genome Sequencing for Salmonella, CDC Office of Advanced Molecular Detection",null,null,null,null,null,null,null,"$113,040 / 1,200 isolates = $94.2"]
[null,"WGS cost"]
[null,"Kristy A. Kubota, William J. Wolfgang, Deborah J. Baker, David Boxrud, Lauren Turner, Eija Trees, Heather A. Carleton, Peter Gerner-Smidt (2019)",null,null,null,null,null,null,null,null,"$120 /isolate"]
[null,null,"PulseNet and the Changing Paradigm of Laboratory-Based Surveillance for Foodborne Diseases. Public Health Reports. 2019 Nov; 134(2_suppl): 22S-28S"]
[null,"Eija Trees, Cristina Maria da Silva, Bishwa Adhikari, Greg Armstrong (2018)",null,null,null,null,null,null,null,null,"$254,100 /1,200 isolates = $211.75"]
[null,null,"Economics of Next Genome Sequencing for Salmonella, CDC Office of Advanced Molecular Detection"]
[null,"WGS Data analysis cost"]
[null,"Personal communication with Eija Trees and CDC reference lab"]
[]
[null,"Note: upper estimates for PFGE, AMR, or conventional serotyping cost may be lower."]

{"sheet":"5. Response Activities","index":6,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[11,4,11,7]]}
["5. JURISDICTION RESPONSE"]
[]
[null,"Note: The default numbers on this page are for illustrative purposes only."]
[]
[]
[null,"Salmonella",null,{"$f":"\"Outbreak Response Activities in \"&TEXT(area,\"\")","v":"Outbreak Response Activities in U.S. State"}]
[]
[null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,"Number of outbreak investigations",null,null,0,0,0]
[null,null,"Number of community outreach activities",null,null,0,0,0]
[null,null," (messaging, recalls, etc)"]

{"sheet":"6. Response Illustrations","index":7,"n_rows":31,"n_cols":29,"rows_kept":31,"cut":false,"hidden":false,"merged":[[16,5,16,8],[22,6,23,8]]}
["6. ILLUSTRATIONS of RESPONSE IMPACT (Optional)"]
[]
[null,"Note: The default numbers on this page are for illustrative purposes only."]
[]
[]
[null,"Salmonella",null,{"$f":"\"Outbreak Response Activities in \"&TEXT(area,\"\")","v":"Outbreak Response Activities in U.S. State"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"case"]
[null,null,null,null,null,null,"Illustration 1",null,"Illustration 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg"]
[null,null,"Unit of the product",null,null,null,"kg",null,"case",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pack"]
[null,null,"Amount of outbreak-related products distributed",null,null,null,25000,{"$f":"G9","v":"kg"},5000,{"$f":"I9","v":"case"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"unit"]
[null,null,"Amount of products discarded by retailers due to response activities",null,null,null,10000,{"$f":"G9","v":"kg"},2000,{"$f":"I9","v":"case"}]
[null,null,"Amount of products consumed",null,null,null,{"$f":"G11-G12","v":15000},{"$f":"G9","v":"kg"},{"$f":"I11-I12","v":3000},{"$f":"I9","v":"case"}]
[]
[null,null,"Number of Salmonella cases attributable to the product",null,null,null,200,null,100]
[]
[]
[null,"Salmonella Outbreak Response Impact"]
[]
[null,null,null,null,null,null,{"$f":"G8","v":"Illustration 1"},null,{"$f":"I8","v":"Illustration 2"}]
[null,null,"Number of Salmonella cases prevented due to response activities",null,null,null,{"$f":"'Response Impact'!F16","v":133.33333333333334},null,{"$f":"'Response Impact'!G16","v":66.666666666666671}]
[]
[null,null,null,null,null,null,"Click here to see \nHow the cases are calculated"]
[]
[]
[]
[]
[null,"References"]
[]
[null,"Robert L. Scharff, John Besser, Donald J. Sharp, Timothy F. Jones, Peter Gerner-Smidt, Craig W. Hedberg (2016)."]
[null,null,"An Economic Evaluation of PulseNet: A Network for Foodborne Disease Surveillance. American Journal of Preventive Medicine, 50(5)."]

{"sheet":"Results","index":8,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[12,3,12,4],[42,3,42,4]]}
["RESULTS"]
[]
[null,null,"Note: The default numbers on this page are for illustrative purposes only."]
[]
[]
[null,null,"Salmonella Cases and Health Outcome"]
[]
[null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,null,"Number of lab confirmed reported Salmonella cases",null,{"$f":"'Epidemiology (Details)'!L9","v":400},{"$f":"'Epidemiology (Details)'!M9","v":800},{"$f":"'Epidemiology (Details)'!N9","v":1200}]
[null,null,null,"Number of cases hospitalized",null,{"$f":"'1. Epidemiology'!F16","v":7.5200000000000005},{"$f":"'1. Epidemiology'!G16","v":15.040000000000001},{"$f":"'1. Epidemiology'!H16","v":22.560000000000002}]
[null,null,null,"Number of hospitalized cases died",null,{"$f":"'1. Epidemiology'!F17","v":0.15040000000000001},{"$f":"'1. Epidemiology'!G17","v":0.30080000000000001},{"$f":"'1. Epidemiology'!H17","v":0.45120000000000005}]
[]
[null,null,null,"Note: modified for ",null,{"$f":"\"under-reporting factor of \"&TEXT(under_rep_adj,\"#.#\") & \"0 and under-diagnosis factor of \" &TEXT(under_diag_adj,\"##.#\")","v":"under-reporting factor of 1.0 and under-diagnosis factor of 29.1"}]
[null,null,null,"Total number of estimated Salmonella cases",null,{"$f":"'Epidemiology (Details)'!V9","v":11640},{"$f":"'Epidemiology (Details)'!W9","v":23280},{"$f":"'Epidemiology (Details)'!X9","v":34920}]
[null,null,null,"Number of cases hospitalized",null,{"$f":"'Epidemiology (Details)'!V11","v":218.83200000000002},{"$f":"'Epidemiology (Details)'!W11","v":437.66400000000004},{"$f":"'Epidemiology (Details)'!X11","v":656.49599999999998}]
[null,null,null,"Number of hospitalized cases died",null,{"$f":"'Epidemiology (Details)'!V16","v":4.376640000000001},{"$f":"'Epidemiology (Details)'!W16","v":8.7532800000000019},{"$f":"'Epidemiology (Details)'!X16","v":13.12992}]
[]
[]
[null,null,"Salmonella Outbreak Response Activity"]
[]
[null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,null,"Number of outbreak investigations",null,{"$f":"'5. Response Activities'!F9","v":0},{"$f":"'5. Response Activities'!G9","v":0},{"$f":"'5. Response Activities'!H9","v":0}]
[null,null,null,"Number of community outreach activities",null,{"$f":"'5. Response Activities'!F10","v":0},{"$f":"'5. Response Activities'!G10","v":0},{"$f":"'5. Response Activities'!H10","v":0}]
[null,null,null," (messaging, recalls, etc)"]
[]
[]
[null,null,"Salmonella Specimens and Isolates Tested"]
[]
[null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,null,"Number of Salmonella specimens tested by the state lab",null,{"$f":"'3. Lab Testing'!E10","v":100},{"$f":"'3. Lab Testing'!F10","v":200},{"$f":"'3. Lab Testing'!G10","v":500}]
[null,null,null,"Number of Salmonella isolates tested by the state lab",null,{"$f":"'3. Lab Testing'!E14","v":400},{"$f":"'3. Lab Testing'!F14","v":800},{"$f":"'3. Lab Testing'!G14","v":1200}]
[]
[]
[null,null,"Medical costs and Lab testing costs associated with Salmonella outbreak"]
[]
[null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,null,"Total medical costs",null,{"$f":"'Epidemiology (Details)'!L43","v":120637.13051696336},{"$f":"'Epidemiology (Details)'!M43","v":241274.26103392671},{"$f":"'Epidemiology (Details)'!N43","v":361911.39155089005}]
[null,null,null,"Average medical cost per case",null,{"$f":"F37/F9","v":301.5928262924084},{"$f":"G37/G9","v":301.5928262924084},{"$f":"H37/H9","v":301.5928262924084}]
[null,null,null,"Total lab testing costs",null,{"$f":"'4. Lab Costs'!Q32","v":184045.32},{"$f":"'4. Lab Costs'!R32","v":368090.64},{"$f":"'4. Lab Costs'!S32","v":616042.6}]
[null,null,null,"Average cost per specimen tested",null,{"$f":"'4. Lab Costs'!Q14","v":319.53320000000002},{"$f":"'4. Lab Costs'!R14","v":319.53320000000002},{"$f":"'4. Lab Costs'!S14","v":319.53320000000002}]
[null,null,null,"Average cost per isolate tested",null,{"$f":"'4. Lab Costs'!Q26","v":380.23},{"$f":"'4. Lab Costs'!R26","v":380.23},{"$f":"'4. Lab Costs'!S26","v":380.23}]
[]
[null,null,null,"Note: modified for",null,{"$f":"\" under-reporting factor of \"&TEXT(under_rep_adj,\"#.#\") & \"0 and under-diagnosis factor of \" &TEXT(under_diag_adj,\"##.#\")","v":" under-reporting factor of 1.0 and under-diagnosis factor of 29.1"}]
[null,null,null,"Total direct medical costs",null,{"$f":"'Epidemiology (Details)'!V43","v":3510540.4980436335},{"$f":"'Epidemiology (Details)'!W43","v":7021080.9960872671},{"$f":"'Epidemiology (Details)'!X43","v":10531621.494130898}]
[null,null,null,"Average medical cost per case",null,{"$f":"F44/F14","v":301.5928262924084},{"$f":"G44/G14","v":301.5928262924084},{"$f":"H44/H14","v":301.59282629240829}]

{"sheet":"Results - Response Illustration","index":9,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["RESULTS - ILLUSTRATION of OUTBREAK RESPONSE IMPACT"]
[]
[null,null,"Note: The default numbers on this page are for illustrative purposes only."]
[]
[]
[null,null,"Illustration of Salmonella Outbreak Response Impact"]
[]
[null,null,null,null,null,{"$f":"'6. Response Illustrations'!G8","v":"Illustration 1"},{"$f":"'6. Response Illustrations'!I8","v":"Illustration 2"}]
[null,null,null,"Number of cases averted",null,{"$f":"'6. Response Illustrations'!G21","v":133.33333333333334},{"$f":"'6. Response Illustrations'!I21","v":66.666666666666671}]
[null,null,null,"Number of hospitalizations averted",null,{"$f":"F9*hosp","v":2.5066666666666668},{"$f":"G9*hosp","v":1.2533333333333334}]
[null,null,null,"Total direct medical costs averted",null,{"$f":"F9*Results!G38","v":40212.376838987788},{"$f":"G9*Results!G38","v":20106.188419493894}]

{"sheet":"National Outbreak","index":10,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,1,3,3],[17,5,18,7]]}
["EPIDEMIOLOGY (National)"]
[]
[null,"Back to Epidemiology"]
[]
[]
[null,"Reported Cases and Outcomes"]
[]
[null,null,"Number of lab confirmed reported Salmonella cases",null,null,"Low","Med","High"]
[null,null,null,"National (for comparison)",null,{"$f":"G9*0.54","v":21268.033920000002},39385.248,{"$f":"G9*1.8","v":70893.446400000001}]
[]
[null,null,"Note: Calculated based on the % of health outcomes (Batz et al. 2010). Users may enter values if data available."]
[null,null,{"$f":"\"Total hospitalized in \"&TEXT(area,\"\")","v":"Total hospitalized in U.S. State"},null,null,{"$f":"national_low*hosp","v":399.83903769600005},{"$f":"national_med*hosp","v":740.44266240000002},{"$f":"national_high*hosp","v":1332.7967923200001}]
[null,null,null,"Died",null,{"$f":"F12*died","v":7.9967807539200013},{"$f":"G12*died","v":14.808853248},{"$f":"H12*died","v":26.655935846400002}]
[]
[null,null,{"$f":"\"Total non-hospitalized in \"&TEXT(area,\"\")","v":"Total non-hospitalized in U.S. State"},null,null,{"$f":"national_low*(1-hosp)","v":20868.194882304},{"$f":"national_med*(1-hosp)","v":38644.805337599995},{"$f":"national_high*(1-hosp)","v":69560.649607679996}]
[null,null,null,"Received medical care",null,{"$f":"national_low*outpatient_care","v":1531.29844224},{"$f":"national_med*outpatient_care","v":2835.7378559999997},{"$f":"national_high*outpatient_care","v":5104.3281407999993}]
[]
[null,null,null,null,null,"Click here to edit epidemiologic parameters"]
[]
[]
[]
[null,"Estimated Cases and Outcomes modified for under-reporting and under-diagnosis"]
[]
[null,null,null,null,null,"Low","Med","High"]
[null,null,"Number of estimated Salmonella cases",null,null,{"$f":"national_low*under_diag_adj*under_rep_adj","v":618899.78707200009},{"$f":"national_med*under_diag_adj*under_rep_adj","v":1146110.7168000001},{"$f":"national_high*under_diag_adj*under_rep_adj","v":2062999.2902400002}]
[]
[null,null,{"$f":"\"Total hospitalized in \"&TEXT(area,\"\")","v":"Total hospitalized in U.S. State"},null,null,{"$f":"F25*hosp","v":11635.315996953603},{"$f":"G25*hosp","v":21546.88147584},{"$f":"H25*hosp","v":38784.386656512004}]
[null,null,null,"Died",null,{"$f":"F27*died","v":232.70631993907205},{"$f":"G27*died","v":430.93762951680003},{"$f":"H27*died","v":775.68773313024008}]
[]
[null,null,{"$f":"\"Total non-hospitalized in \"&TEXT(area,\"\")","v":"Total non-hospitalized in U.S. State"},null,null,{"$f":"F25*(1-hosp)","v":607264.47107504646},{"$f":"G25*(1-hosp)","v":1124563.8353241601},{"$f":"H25*(1-hosp)","v":2024214.9035834882}]
[null,null,null,"Received medical care",null,{"$f":"F25*outpatient_care","v":44560.784669184002},{"$f":"G25*outpatient_care","v":82519.971609600005},{"$f":"H25*outpatient_care","v":148535.94889728}]
[]
[null,null,"Note: Modified for",{"$f":"\"under-reporting factor of \"&TEXT(under_rep_adj,\"#.#\") & \"0 and under-diagnosis factor of \" &TEXT(under_diag_adj,\"##.#\")","v":"under-reporting factor of 1.0 and under-diagnosis factor of 29.1"}]
[]
[]
[]
[]
[]
[]
[]
[null,"References"]
[]
[null,"Collier SA, Deng L, Adam EA, Benedict KM, Beshearse EM, Blackstock AJ, et al. "]
[null,null,"Estimate of Burden and Direct Healthcare Cost of Infectious Waterborne Disease in the United States. Emerging Infectious Diseases. 2021;27(1):140-9. doi: 10.3201/eid2701.190676."]
[null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014."]
[null,null,"Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]

{"sheet":"Epidemiology (Details)","index":11,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,7,3,9],[5,1,5,4],[15,1,15,4],[2,1,3,2],[11,2,12,3]]}
["EPIDEMIOLOGY (Details)"]
[null,null,null,null,null,null,null,"Low year","Average year","High year"]
[null,"Back to Epidemiology",null,null,null,null,"Year(s):",{"$f":"year_low","v":2020},{"$f":"year_med","v":2000},{"$f":"year_high","v":2010}]
[null,null,null,null,null,null,"For:",{"$f":"area","v":"U.S. State"}]
[]
[null,"Proportion of health outcomes",null,null,null,null,"Cases and outcomes",null,null,null,null,null,null,null,null,null,"Cases and outcomes modified for under-reporting and under-diagnosis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Modified",{"$f":"\"for under-reporting factor of \"&TEXT(under_rep_adj,\"#.#\") & \"0 and under-diagnosis factor of \" &TEXT(under_diag_adj,\"##.#\")","v":"for under-reporting factor of 1.0 and under-diagnosis factor of 29.1"}]
[null,null,"% hospitalized",1.8800000000000001E-2,null,null,null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"},null,null,null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,"% dead among hospitalized cases",0.02,null,null,null,"Total number of reported cases",null,null,null,{"$f":"case_low","v":400},{"$f":"case_med","v":800},{"$f":"case_high","v":1200},null,null,null,"Total number of estimated cases",null,null,null,{"$f":"L9*under_rep_adj*under_diag_adj","v":11640},{"$f":"M9*under_rep_adj*under_diag_adj","v":23280},{"$f":"N9*under_rep_adj*under_diag_adj","v":34920}]
[null,null,"% received outpatient medical care ",7.1999999999999995E-2]
[null,null,null,null,null,null,null,"Total hospitalized",null,null,null,{"$f":"L9*hosp","v":7.5200000000000005},{"$f":"M9*hosp","v":15.040000000000001},{"$f":"N9*hosp","v":22.560000000000002},null,null,null,"Total hospitalized",null,null,null,{"$f":"V9*hosp","v":218.83200000000002},{"$f":"W9*hosp","v":437.66400000000004},{"$f":"X9*hosp","v":656.49599999999998}]
[null,null,"Click here to see the health outcomes decision tree",null,null,null,null,null,null,"Physician office visits",null,{"$f":"L11*office_hosp","v":5.2640000000000002},{"$f":"M11*office_hosp","v":10.528},{"$f":"N11*office_hosp","v":15.792},null,null,null,null,null,"Physician office visits",null,{"$f":"V11*office_hosp","v":153.1824},{"$f":"W11*office_hosp","v":306.3648},{"$f":"X11*office_hosp","v":459.54719999999998}]
[null,null,null,null,null,null,null,null,null,"Emergency room visits",null,{"$f":"L11*ER_hosp","v":2.2560000000000002},{"$f":"M11*ER_hosp","v":4.5120000000000005},{"$f":"N11*ER_hosp","v":6.7680000000000007},null,null,null,null,null,"Emergency room visits",null,{"$f":"V11*ER_hosp","v":65.649600000000007},{"$f":"W11*ER_hosp","v":131.29920000000001},{"$f":"X11*ER_hosp","v":196.94879999999998}]
[null,null,null,null,null,null,null,null,null,"Outpatient clinic visits",null,{"$f":"L11*outpt_hosp","v":1.5040000000000002},{"$f":"M11*outpt_hosp","v":3.0080000000000005},{"$f":"N11*outpt_hosp","v":4.5120000000000005},null,null,null,null,null,"Outpatient clinic visits",null,{"$f":"V11*outpt_hosp","v":43.766400000000004},{"$f":"W11*outpt_hosp","v":87.532800000000009},{"$f":"X11*outpt_hosp","v":131.29920000000001}]
[null,null,null,null,null,null,null,null,"Recovered",null,null,{"$f":"L11-L16","v":7.3696000000000002},{"$f":"M11-M16","v":14.7392},{"$f":"N11-N16","v":22.108800000000002},null,null,null,null,"Recovered",null,null,{"$f":"V11-V16","v":214.45536000000001},{"$f":"W11-W16","v":428.91072000000003},{"$f":"X11-X16","v":643.36608000000001}]
[null,"Medical encounters per case (hospitalized)",null,null,null,null,null,null,"Died",null,null,{"$f":"L11*died","v":0.15040000000000001},{"$f":"M11*died","v":0.30080000000000001},{"$f":"N11*died","v":0.45120000000000005},null,null,null,null,"Died",null,null,{"$f":"V11*died","v":4.376640000000001},{"$f":"W11*died","v":8.7532800000000019},{"$f":"X11*died","v":13.12992}]
[]
[null,null,"Physician office visit",0.7,null,null,null,"Total non-hospitalized",null,null,null,{"$f":"L9-L11","v":392.48},{"$f":"M9-M11","v":784.96},{"$f":"N9-N11","v":1177.44},null,null,null,"Total non-hospitalized",null,null,null,{"$f":"V9-V11","v":11421.168},{"$f":"W9-W11","v":22842.335999999999},{"$f":"X9-X11","v":34263.504000000001}]
[null,null,"Emergency room visit",0.3,null,null,null,null,"Received medical care",null,null,{"$f":"L9*outpatient_care","v":28.799999999999997},{"$f":"M9*outpatient_care","v":57.599999999999994},{"$f":"N9*outpatient_care","v":86.399999999999991},null,null,null,null,"Received medical care",null,null,{"$f":"V9*outpatient_care","v":838.07999999999993},{"$f":"W9*outpatient_care","v":1676.1599999999999},{"$f":"X9*outpatient_care","v":2514.2399999999998}]
[null,null,"Hospital-based outpatient clinic visit",0.2,null,null,null,null,null,"Physician office visits",null,{"$f":"L19*office_nonhosp","v":40.319999999999993},{"$f":"M19*office_nonhosp","v":80.639999999999986},{"$f":"N19*office_nonhosp","v":120.95999999999998},null,null,null,null,null,"Physician office visits",null,{"$f":"V19*office_nonhosp","v":1173.3119999999999},{"$f":"W19*office_nonhosp","v":2346.6239999999998},{"$f":"X19*office_nonhosp","v":3519.9359999999997}]
[null,null,null,null,null,null,null,null,null,"Emergency room visits",null,{"$f":"L19*ER_nonhosp","v":2.88},{"$f":"M19*ER_nonhosp","v":5.76},{"$f":"N19*ER_nonhosp","v":8.6399999999999988},null,null,null,null,null,"Emergency room visits",null,{"$f":"V19*ER_nonhosp","v":83.807999999999993},{"$f":"W19*ER_nonhosp","v":167.61599999999999},{"$f":"X19*ER_nonhosp","v":251.42399999999998}]
[null,null,null,null,null,null,null,null,null,"Outpatient clinic visits",null,{"$f":"L19*outpt_nonhosp","v":8.6399999999999988},{"$f":"M19*outpt_nonhosp","v":17.279999999999998},{"$f":"N19*outpt_nonhosp","v":25.919999999999998},null,null,null,null,null,"Outpatient clinic visits",null,{"$f":"V19*outpt_nonhosp","v":251.42399999999998},{"$f":"W19*outpt_nonhosp","v":502.84799999999996},{"$f":"X19*outpt_nonhosp","v":754.27199999999993}]
[null,"Medical encounters per case (non-hospitalized)",null,null,null,null,null,null,"No medical care",null,null,{"$f":"L9-L11-L19","v":363.68},{"$f":"M9-M11-M19","v":727.36},{"$f":"N9-N11-N19","v":1091.04},null,null,null,null,"No medical care",null,null,{"$f":"V9-V11-V19","v":10583.088},{"$f":"W9-W11-W19","v":21166.175999999999},{"$f":"X9-X11-X19","v":31749.264000000003}]
[]
[null,null,"Physician office visit",1.4]
[null,null,"Emergency room visit",0.1,null,null,"Health outcomes summary",null,null,null,null,null,null,null,null,null,"Health outcomes summary modified for under-reporting"]
[null,null,"Hospital-based outpatient clinic visit",0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Modified",{"$f":"\"for under-reporting factor of \"&TEXT(under_rep_adj,\"#.#\") & \"0 and under-diagnosis factor of \" &TEXT(under_diag_adj,\"##.#\")","v":"for under-reporting factor of 1.0 and under-diagnosis factor of 29.1"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"},null,null,null,null,null,null,null,{"$f":"\"Low (\" &TEXT(year_low,\"####\") &\")\"","v":"Low (2020)"},{"$f":"\"Med (\" &TEXT(year_med,\"####\") &\")\"","v":"Med (2000)"},{"$f":"\"High (\" &TEXT(year_high,\"####\") &\")\"","v":"High (2010)"}]
[null,null,null,null,null,null,null,"Total physician office visits",null,null,null,{"$f":"L20+L12","v":45.583999999999996},{"$f":"M20+M12","v":91.167999999999992},{"$f":"N20+N12","v":136.75199999999998},null,null,null,"Total physician office visits",null,null,null,{"$f":"V20+V12","v":1326.4943999999998},{"$f":"W20+W12","v":2652.9887999999996},{"$f":"X20+X12","v":3979.4831999999997}]
[null,"Correction for under-reporting and under-diagnosis",null,null,null,null,null,null,"Total costs",null,null,{"$f":"L29*cost_office","v":6197.452739853883},{"$f":"M29*cost_office","v":12394.905479707766},{"$f":"N29*cost_office","v":18592.358219561651},null,null,null,null,"Total costs",null,null,{"$f":"V29*cost_office","v":180345.874729748},{"$f":"W29*cost_office","v":360691.749459496},{"$f":"X29*cost_office","v":541037.624189244}]
[]
[null,null,"under-reporting factor",1,null,null,null,"Total emergency room visits",null,null,null,{"$f":"L21+L13","v":5.1360000000000001},{"$f":"M21+M13","v":10.272},{"$f":"N21+N13","v":15.407999999999999},null,null,null,"Total emergency room visits",null,null,null,{"$f":"V21+V13","v":149.45760000000001},{"$f":"W21+W13","v":298.91520000000003},{"$f":"X21+X13","v":448.37279999999998}]
[null,null,"under-diagnosis factor",29.1,null,null,null,null,"Total costs",null,null,{"$f":"L32*cost_ER","v":2942.5909338618148},{"$f":"M32*cost_ER","v":5885.1818677236297},{"$f":"N32*cost_ER","v":8827.7728015854445},null,null,null,null,"Total costs",null,null,{"$f":"V32*cost_ER","v":85629.396175378817},{"$f":"W32*cost_ER","v":171258.79235075763},{"$f":"X32*cost_ER","v":256888.18852613642}]
[]
[null,null,null,null,null,null,null,"Total hospital-based outpatient clinic visits",null,null,null,{"$f":"L22+L14","v":10.143999999999998},{"$f":"M22+M14","v":20.287999999999997},{"$f":"N22+N14","v":30.431999999999999},null,null,null,"Total hospital-based outpatient clinic visits",null,null,null,{"$f":"V22+V14","v":295.19039999999995},{"$f":"W22+W14","v":590.38079999999991},{"$f":"X22+X14","v":885.57119999999998}]
[null,null,null,null,null,null,null,null,"Total costs",null,null,{"$f":"L35*cost_outpt","v":6683.1442681248272},{"$f":"M35*cost_outpt","v":13366.288536249654},{"$f":"N35*cost_outpt","v":20049.432804374483},null,null,null,null,"Total costs",null,null,{"$f":"V35*cost_outpt","v":194479.49820243247},{"$f":"W35*cost_outpt","v":388958.99640486494},{"$f":"X35*cost_outpt","v":583438.49460729747}]
[]
[null,null,null,null,null,null,null,"Total hospitalizations",null,null,null,{"$f":"L11","v":7.5200000000000005},{"$f":"M11","v":15.040000000000001},{"$f":"N11","v":22.560000000000002},null,null,null,"Total hospitalizations",null,null,null,{"$f":"V11","v":218.83200000000002},{"$f":"W11","v":437.66400000000004},{"$f":"X11","v":656.49599999999998}]
[null,null,null,null,null,null,null,null,"Total costs",null,null,{"$f":"L38*cost_hosp","v":104813.94257512283},{"$f":"M38*cost_hosp","v":209627.88515024565},{"$f":"N38*cost_hosp","v":314441.82772536849},null,null,null,null,"Total costs",null,null,{"$f":"V38*cost_hosp","v":3050085.7289360743},{"$f":"W38*cost_hosp","v":6100171.4578721486},{"$f":"X38*cost_hosp","v":9150257.186808221}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L30+L33+L36+L39","v":120637.13051696336},{"$f":"M30+M33+M36+M39","v":241274.26103392671},{"$f":"N30+N33+N36+N39","v":361911.39155089005},null,null,null,null,null,null,null,{"$f":"V30+V33+V36+V39","v":3510540.4980436335},{"$f":"W30+W33+W36+W39","v":7021080.9960872671},{"$f":"X30+X33+X36+X39","v":10531621.494130898}]
[null,"References"]
[]
[null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014."]
[null,null,"Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]
[null,"Scallan, E., Hoekstra, R. M., Angulo, F. J., Tauxe, R. V., Widdowson, M., Roy, S. L....Griffin, P. M. (2011). "]
[null,null,"Foodborne Illness Acquired in the United States—Major Pathogens. Emerging Infectious Diseases, 17(1), 7-15. https://dx.doi.org/10.3201/eid1701.p11101."]
[null,"Collier SA, Deng L, Adam EA, Benedict KM, Beshearse EM, Blackstock AJ, et al. "]
[null,null,"Estimate of Burden and Direct Healthcare Cost of Infectious Waterborne Disease in the United States. Emerging Infectious Diseases. 2021;27(1):140-9. doi: 10.3201/eid2701.190676."]

{"sheet":"Health Outcomes","index":12,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[17,7,17,8],[4,9,5,11],[9,4,9,5],[4,4,4,5],[14,4,14,5],[13,7,13,8]]}
["HEALTH OUTCOME"]
[]
[]
[]
[null,null,null,null,{"$f":"1-outpatient_care-hosp","v":0.90920000000000001},null,null,null,null,"Back to Epidemiology (Details)"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"outpatient_care","v":7.1999999999999995E-2}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"1-died","v":0.98}]
[null,null,null,null,{"$f":"hosp","v":1.8800000000000001E-2}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"died","v":0.02}]
[]
[]
[]
[]
[null,"References"]
[]
[null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014."]
[null,null,"Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]

{"sheet":"Response Impact","index":13,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,1,3,3]]}
["RESPONSE IMPACT CALCULATIONS"]
[]
[null,"Back to Response Illustrations"]
[]
[]
[null,"Salmonella Outbreak Response Impact"]
[]
[null,null,null,null,null,{"$f":"'6. Response Illustrations'!G8","v":"Illustration 1"},{"$f":"'6. Response Illustrations'!I8","v":"Illustration 2"}]
[null,null,"Amount of outbreak-related products distributed",null,null,{"$f":"'6. Response Illustrations'!G11","v":25000},{"$f":"'6. Response Illustrations'!I11","v":5000}]
[null,null,"Amount of products discarded by retailers due to response activities",null,null,{"$f":"'6. Response Illustrations'!G12","v":10000},{"$f":"'6. Response Illustrations'!I12","v":2000}]
[null,null,"Products consumed",null,null,{"$f":"'6. Response Illustrations'!G13","v":15000},{"$f":"'6. Response Illustrations'!I13","v":3000}]
[]
[null,null,"Number of Salmonella cases attributable to the product",null,null,{"$f":"'6. Response Illustrations'!G15","v":200},{"$f":"'6. Response Illustrations'!I15","v":100}]
[null,null,"Cases per 1,000 unit product consumed",null,null,{"$f":"F13/F11*1000","v":13.333333333333334},{"$f":"G13/G11*1000","v":33.333333333333336}]
[]
[null,null,"Cases averted due to recall",null,null,{"$f":"F14*F10/1000","v":133.33333333333334},{"$f":"G14*G10/1000","v":66.666666666666671}]
[]
[]
[]
[]
[]
[null,"References"]
[]
[null,"Robert L. Scharff, John Besser, Donald J. Sharp, Timothy F. Jones, Peter Gerner-Smidt, Craig W. Hedberg (2016)."]
[null,null,"An Economic Evaluation of PulseNet: A Network for Foodborne Disease Surveillance. American Journal of Preventive Medicine, 50(5)."]

{"sheet":"Data Summary","index":14,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,1,5,4],[12,1,13,4],[12,8,12,10],[12,6,12,7],[4,8,4,10],[4,6,4,7]]}
["DATA SUMMARY"]
[]
[]
[]
[null,null,null,null,null,null,"Non-hospitalized",null,"Hospitalized"]
[null,"Health outcomes",null,null,null,"Total cases","No medical care","Received medical care","Total","Recovered","Died"]
[]
[null,"Number of cases"]
[null,null,null,"low",null,644786,589816.40799999994,46424.592000000004,8545,8545,0]
[null,null,null,"mean",null,1027561,934240.60800000001,73984.392000000007,19336,18957.999999999996,378]
[null,null,null,"high",null,1679667,1521240.976,120936.024,37490.000000000007,36479.000000000007,1011]
[]
[null,"Cost component",null,null,null,null,"Non-hospitalized",null,"Hospitalized"]
[null,null,null,null,null,null,"No medical care","Received medical care","Total","Recovered"]
[null,"Medical costs"]
[null,null,"Physician office visits"]
[null,null,null,"Average visits per case",null,null,0,1.4,0.7,1]
[null,null,null,"Average cost per visit",null,135.95675543730002]
[null,null,"Emergency room visits"]
[null,null,null,"Average visits per case",null,null,0,0.1,0.3,0]
[null,null,null,"Average cost per visit",null,572.93437185783]
[null,null,"Outpatient clinic visits"]
[null,null,null,"Average visits per case",null,null,0,0.3,0.2,0]
[null,null,null,"Average cost per visit",null,658.82731349811002]
[null,null,"Hospitalizations"]
[null,null,null,"Average admissions per case",null,null,0,0,1,0]
[null,null,null,"Average cost per hospitalization",null,13938.024278606757]
[]
[null,null,null,"Total Cost per case",null,null,0,445.28108884743597,14336.839781669838,135.95675543730002]
[]
[]
[]
[]
[null,"References"]
[]
[null,"Economic Research Service (ERS), U.S. Department of Agriculture (USDA). Cost Estimates of Foodborne Illnesses."]
[null,null," http://ers.usda.gov/data-products/cost-estimates-of-foodborne-illnesses.aspx"]

{"sheet":"Mean COI","index":15,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,2,29,9],[3,5,3,6],[3,8,3,9],[23,0,23,9],[27,0,27,9],[28,2,28,9]]}
["Cost of foodborne illness estimates for Salmonella (nontyphoidal) "]
[null,null,null,null,"Mean estimates, 2013"]
[]
[null,null,null,null,null,"Non-hospitalized",null,"Hospitalized","Post-hospitalization outcomes"]
["Health outcomes",null,null,null,"Total cases","Didn't visit physician; recovered","Visited physician; recovered","Hospitalized","Post-hospitalization recovery","Hospitalized; died"]
["Number of cases",null,null,null,1027561]
[null,"Cases by outcome",null,null,null,934240.60800000001,73984.392000000007,19336,18957.999999999996,378]
[]
["Medical costs"]
[null,"Physician office visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Emergency room visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Outpatient clinic visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Hospitalizations",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Total medical costs by outcome",null,null,null,null,{"$f":"SUM(G10:G13)","v":{"$error":"#REF!"}},{"$f":"SUM(H10:H13)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
["Premature death",null,null,null,null,null,null,null,null,{"$f":"J7*#REF!","v":{"$error":"#REF!"}}]
[]
["Productivity loss, nonfatal cases",null,null,null,null,{"$f":"F7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"G7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}}]
[]
["Total cost by outcome",null,null,null,null,{"$f":"SUM(F14:F18)","v":{"$error":"#REF!"}},{"$f":"SUM(G14:G18)","v":{"$error":"#REF!"}},{"$f":"SUM(H14:H18)","v":{"$error":"#REF!"}},{"$f":"SUM(I14:I18)","v":{"$error":"#REF!"}},{"$f":"J16","v":{"$error":"#REF!"}}]
[]
["Total cost of illness",null,null,null,{"$f":"SUM(F20:J20)","v":{"$error":"#REF!"}}]
[]
["Note: In each pathogen Excel file, the spreadsheets for low, mean, and high costs of foodborne illness are linked to the spreadsheet with assumptions used in estimating cost-of-illness estimates for that pathogen. Users may change the assumptions in the per-case assumptions worksheet to conduct sensitivity analysis on the influence of specific per-case assumptions. They may also update per-case costs in the per-case assumptions worksheet for inflation and income growth by using information from the Consumer Price Indexes Excel spreadsheet and the VSL Excel spreadsheet provided as part of this data product. See the Documentation page of this data product for further guidance."]
["ERS's mean estimate of the total annual cost of foodborne illness from Salmonella in 2013 dollars is $3,666,600,031."]
["Citation: Economic Research Service (ERS), U.S. Department of Agriculture (USDA). Cost Estimates of Foodborne Illnesses. http://ers.usda.gov/data-products/cost-estimates-of-foodborne-illnesses.aspx."]
[]
["Source: This spreadsheet is based on:"]
[null,null,"Hoffmann, Sandra, Michael Batz, J. Glenn Morris Jr.  2012.  “Annual Cost of Illness and Quality-Adjusted Life Year Losses in the United States Due to 14 Foodborne Pathogens.” J. Food Protection 75(7): 1291-1302; and"]
[null,null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014. Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]

{"sheet":"Data Read Me","index":16,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Low, Mean, and High Estimates of the Annual Cost of Foodborne Illnesses Caused by  Salmonella (nontyphoidal)"]
[]
[null,"This Excel file reports the USDA Economic Research Service estimates of the annual cost of foodborne illnesses for Salmonella (nontyphoidal) in the U.S.  "]
[]
[null,"ERS has developed similar Excel files for each of 15 major foodborne pathogens.  The U.S. Centers for Disease Control and Prevention estimates that these 15 pathogens cause over 95 percent of the foodborne illnesses, hospitalizations and deaths each year in the U.S. for which a pathogen cause can be identified."]
[]
[null,"This Excel file contains 3 worksheets in addition to this cover page:  mean, low, and high estimates of foodborne illness and a spreadsheet that contains assumptions used in calculating the mean, low, and high estimates.  More detailed discussion of how these spreadsheets were developed and how to work with them can be found in the Documentation."]
[]
[null,"Sources: "]
[null,"Hoffmann, Sandra, Michael Batz, J. Glenn Morris Jr.  2012.  “Annual Cost of Illness and Quality-Adjusted Life Year Losses in the United States Due to 14 Foodborne Pathogens.” J. Food Protection 75(7): 1291-1302; and"]
[]
[null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014. Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]
[]
[null,"Cite as:  Economic Research Service (ERS), U.S. Department of Agriculture (USDA). Cost Estimates of Foodborne Illnesses. http://ers.usda.gov/data-products/cost-estimates-of-foodborne-illnesses.aspx.(2014)."]

{"sheet":"Low","index":17,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,2,29,9],[3,5,3,6],[3,8,3,9],[23,0,23,9],[27,0,27,9],[28,2,28,9]]}
["Cost of foodborne illness estimates for Salmonella (nontyphoidal) "]
[null,null,null,null,"Low estimates, 2013"]
[]
[null,null,null,null,null,"Non-hospitalized",null,"Hospitalized","Post-hospitalization outcomes"]
["Health outcomes",null,null,null,"Total cases","Didn't visit physician; recovered","Visited physician; recovered","Hospitalized","Post-hospitalization recovery","Hospitalized; died"]
["Number of cases",null,null,null,644786]
[null,"Cases by outcome",null,null,null,589816.40799999994,46424.592000000004,8545,8545,0]
[]
["Medical costs"]
[null,"Physician office visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Emergency room visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Outpatient clinic visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Hospitalizations",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Total medical costs by outcome",null,null,null,null,{"$f":"SUM(G10:G13)","v":{"$error":"#REF!"}},{"$f":"SUM(H10:H13)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
["Premature death",null,null,null,null,null,null,null,null,{"$f":"J7*#REF!","v":{"$error":"#REF!"}}]
[]
["Productivity loss, nonfatal cases",null,null,null,null,{"$f":"F7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"G7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}}]
[]
["Total cost by outcome",null,null,null,null,{"$f":"SUM(F14:F18)","v":{"$error":"#REF!"}},{"$f":"SUM(G14:G18)","v":{"$error":"#REF!"}},{"$f":"SUM(H14:H18)","v":{"$error":"#REF!"}},{"$f":"SUM(I14:I18)","v":{"$error":"#REF!"}},{"$f":"J16","v":{"$error":"#REF!"}}]
[]
["Total cost of illness",null,null,null,{"$f":"SUM(F20:J20)","v":{"$error":"#REF!"}}]
[]
["Note: In each pathogen Excel file, the spreadsheets for low, mean, and high costs of foodborne illness are linked to the spreadsheet with assumptions used in estimating cost-of-illness estimates for that pathogen. Users may change the assumptions in the per-case assumptions worksheet to conduct sensitivity analysis on the influence of specific per-case assumptions. They may also update per-case costs in the per-case assumptions worksheet for inflation and income growth by using information from the Consumer Price Indexes Excel spreadsheet and the VSL Excel spreadsheet provided as part of this data product. See the Documentation page of this data product for further guidance."]
["ERS's low estimate of the total annual cost of foodborne illness from Salmonella in 2013 dollars is $192,932,710."]
["Citation: Economic Research Service (ERS), U.S. Department of Agriculture (USDA). Cost Estimates of Foodborne Illnesses. http://ers.usda.gov/data-products/cost-estimates-of-foodborne-illnesses.aspx."]
[]
["Source: This spreadsheet is based on:"]
[null,null,"Hoffmann, Sandra, Michael Batz, J. Glenn Morris Jr.  2012.  “Annual Cost of Illness and Quality-Adjusted Life Year Losses in the United States Due to 14 Foodborne Pathogens.” J. Food Protection 75(7): 1291-1302; and"]
[null,null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014. Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]

{"sheet":"High","index":18,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,2,29,9],[3,5,3,6],[3,8,3,9],[23,0,23,9],[27,0,27,9],[28,2,28,9]]}
["Cost of foodborne illness estimates for Salmonella (nontyphoidal) "]
[null,null,null,null,"High estimates, 2013"]
[]
[null,null,null,null,null,"Non-hospitalized",null,"Hospitalized","Post-hospitalization outcomes"]
["Health outcomes",null,null,null,"Total cases","Didn't visit physician; recovered","Visited physician; recovered","Hospitalized","Post-hospitalization recovery","Hospitalized; died"]
["Number of cases",null,null,null,1679667]
[null,"Cases by outcome",null,null,null,1521240.976,120936.024,37490.000000000007,36479.000000000007,1011]
[]
["Medical costs"]
[null,"Physician office visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Emergency room visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Outpatient clinic visits",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Hospitalizations",null,null,null,null,{"$f":"G$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H$7*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I$7*#REF!*#REF!","v":{"$error":"#REF!"}}]
[null,"Total medical costs by outcome",null,null,null,null,{"$f":"SUM(G10:G13)","v":{"$error":"#REF!"}},{"$f":"SUM(H10:H13)","v":{"$error":"#REF!"}},{"$f":"SUM(I10:I13)","v":{"$error":"#REF!"}}]
[]
["Premature death",null,null,null,null,null,null,null,null,{"$f":"J7*#REF!","v":{"$error":"#REF!"}}]
[]
["Productivity loss, nonfatal cases",null,null,null,null,{"$f":"F7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"G7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I7*#REF!*#REF!*#REF!","v":{"$error":"#REF!"}}]
[]
["Total cost by outcome",null,null,null,null,{"$f":"SUM(F14:F18)","v":{"$error":"#REF!"}},{"$f":"SUM(G14:G18)","v":{"$error":"#REF!"}},{"$f":"SUM(H14:H18)","v":{"$error":"#REF!"}},{"$f":"SUM(I14:I18)","v":{"$error":"#REF!"}},{"$f":"J16","v":{"$error":"#REF!"}}]
[]
["Total cost of illness",null,null,null,{"$f":"SUM(F20:J20)","v":{"$error":"#REF!"}}]
[]
["Note: In each pathogen Excel file, the spreadsheets for low, mean, and high costs of foodborne illness are linked to the spreadsheet with assumptions used in estimating cost-of-illness estimates for that pathogen. Users may change the assumptions in the per-case assumptions worksheet to conduct sensitivity analysis on the influence of specific per-case assumptions. They may also update per-case costs in the per-case assumptions worksheet for inflation and income growth by using information from the Consumer Price Indexes Excel spreadsheet and the VSL Excel spreadsheet provided as part of this data product. See the Documentation page of this data product for further guidance."]
["ERS's high estimate of the total annual cost of foodborne illness from Salmonella in 2013 dollars is $9,485,969,040."]
["Citation: Economic Research Service (ERS), U.S. Department of Agriculture (USDA). Cost Estimates of Foodborne Illnesses. http://ers.usda.gov/data-products/cost-estimates-of-foodborne-illnesses.aspx."]
[]
["Source: This spreadsheet is based on:"]
[null,null,"Hoffmann, Sandra, Michael Batz, J. Glenn Morris Jr.  2012.  “Annual Cost of Illness and Quality-Adjusted Life Year Losses in the United States Due to 14 Foodborne Pathogens.” J. Food Protection 75(7): 1291-1302; and"]
[null,null,"Batz, Michael B., Sandra A. Hoffmann, J. Glenn Morris Jr. 2014. Disease-Outcome Trees, EQ-5D Scores, and Estimated Annual Losses of Quality-Adjusted Life Years (QALYs) Due to 14 Foodborne Pathogens in the United States.  Foodborne Pathogen and Disease 11(5): 395-402."]