Spreadsheet: 771787d1646847519-text-box-cell-link-is-breaking-sample-quartiles
Sheet: Calculation

 | Selected Information (Form Controls) |  |  |  |  |  |  |  |  |  |  |  | Calculation for scrolling table
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Drug-Bug
 |  | Selected Type | 2
 |  | Selected Year | 3 |  |  |  |  |  |  |  |  |  |  | Bug
 |  | Selected Bug | 4
 |  | Selected Drug-Bug | 4 |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | For Drop_down selections |  | 7 |  |  |  | Types data |  |  |  |  |  |  |  |  |  |  | difference from  previous year
 | Year | Type | Values |  |  |  |  | gram_positive |  |  |  |  | Nr. | Type | isolates_tested | isolates_susceptible | %susceptibility | Δ% susceptibility
 | 2018 | gram_negative | isolates_tested |  |  |  | Amikacin-Citrobacter freundii | Ampicillin-Enterococcus spp.
 | 2019 | gram_positive | isolates_susceptible |  |  |  | Amikacin-Klebsiella pneumoniae | Group A Strep-Penicillin
 | 2020 |  | %susceptibility |  |  |  | Amikacin-Proteus mirabilis | Group B Strep-Penicillin
 |  |  |  |  |  |  | [NAME] cloacae complex | Linezolid-MRSA
 |  |  |  |  |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus
 | unique bugs |  |  | Unique drug-bug |  |  | [NAME] coli | Linezolid-MSSA
 |  |  |  |  |  |  | Ertapenem-Acinetobacter baumannii | Penicillin-MRSA
 | Citrobacter freundii | Group B Strep |  | Amikacin-E. coli | Group B Strep-Penicillin |  | Ertapenem-E. coli | Penicillin-MSSA
 | E. coli | MRSA |  | Amikacin-Klebsiella pneumoniae | Linezolid-MRSA |  | Tobramycin-Klebsiella aerogenes
 | Enterobacter cloacae complex | MSSA |  | Amikacin-Proteus mirabilis | Linezolid-MSSA |  | Imipenem-Citrobacter freundii
 | Klebsiella aerogenes | Staphylococcus aureus |  | [NAME] cloacae complex | Penicillin-MRSA |  | Meripenem-Citrobacter freundii
 | Klebsiella pneumoniae |  |  | Ciproflaxin-Citrobacter freundii | Penicillin-MSSA |  | Amikacin-E. coli
 | Morganella morganii |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus |  | Ciproflaxin-Citrobacter freundii |  |  |  | Group B Strep-Penicillin
 | Proteus mirabilis |  |  | [NAME] coli |  |  |  |  |  |  | Linezolid-MRSA
 |  |  |  | Ertapenem-Acinetobacter baumannii |  |  |  |  |  |  | Linezolid-MSSA
 |  |  |  | Ertapenem-E. coli |  |  |  |  |  |  | Penicillin-MRSA
 |  |  |  | Imipenem-Citrobacter freundii |  |  |  |  |  | Amikacin-E. coli | Penicillin-MSSA
 |  |  |  | Meripenem-Citrobacter freundii |  |  |  |  |  | Amikacin-Klebsiella pneumoniae | Penicillin-Staphylococcus aureus
 |  |  |  | Tobramycin-Klebsiella aerogenes |  |  |  |  |  | Amikacin-Proteus mirabilis
 |  |  |  |  | Unique drug-bug |  |  |  |  | [NAME] cloacae complex |  |  |  | Calculations for headers
 |  |  |  |  |  |  |  |  |  | Ciproflaxin-Citrobacter freundii |  |  |  | Hospital Numbers
 |  |  |  |  | Group B Strep-Penicillin |  |  |  |  | [NAME] morganii |  |  |  | isolate_hospital_n
 |  |  |  |  | Linezolid-MRSA |  |  |  |  | [NAME] coli
 |  |  |  |  | Linezolid-MSSA |  |  |  |  | Ertapenem-Acinetobacter baumannii
 |  |  |  |  | Penicillin-MRSA |  |  |  |  | Ertapenem-E. coli
 |  |  |  |  | Penicillin-MSSA |  |  |  |  | Imipenem-Citrobacter freundii
 |  |  |  |  | Penicillin-Staphylococcus aureus |  |  |  |  | Meripenem-Citrobacter freundii
 |  |  |  |  |  |  |  |  |  | Tobramycin-Klebsiella aerogenes
 |  |  |  |  |  |  |  |  |  |  |  | Median |  | [NAME] will show quartiles, min and [NAME] for  all drug_bug combinations for Citrobacter freundi such as Amikacin-Citrobacter freundii, [NAME] freundii,[NAME] freundii, and Ciproflaxin-Citrobacter freundii in one chart. This will change when another bug is chosen such as E. coli for example, this chart will show Citroxene-E.coli,ertapenem-E.coli and Amikacin-E.coli for example.
 |  |  |  |  |  |  |  |  |  |  |  | Q1
 |  |  |  |  |  |  |  |  |  |  |  | Q3
 |  |  |  |  |  |  |  |  |  |  |  | Min
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME])))
 |  |  |  |  |  |  |  |  |  |  | Median | Q1 | Q3 | Min | [NAME]