{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Data Entry","Input_Database","Facility","ActAcceptable","Total Malaria Cases","Total Monthly Treatments Issued","All ACTs vs Malaria Cases","ALU Only vs Malaria Cases","Sev Treatments vs Sev Cases","mRDTs vs Malaria Testing","LLINs","Form Glossary","Data Flow Chart","Action Plan Template","Drop Down","Dropdown"],"not_rendered":{"charts":7,"images":12,"macros":1,"external_links":1,"defined_names":28,"comments":0,"pivot_tables":7},"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":"Data Entry","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input_Database","index":1,"n_rows":34,"n_cols":59,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Country","Region/Province/State","District","Facility","Month","Year","Total Confirmed Malaria Cases","Total Severe Malaria Cases","Total Suspected Malaria Cases Tested with mRDTs","Total Monthly LLIN Clients","ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)","ALU 6x2 (Artemether/Lumefantrine 20/120 mg Tablet, 6x2 tablets per Blister Pack)","ALU 6x3 (Artemether/Lumefantrine 20/120 mg Tablet, 6x3 tablets per Blister Pack)","ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)","mRDT","Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set","Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 30 mg Vial, 1 Set","Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 120 mg Vial, 1 Set","Artesunate suppository 100 mg (Rectal Artesunate)","ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)","ASAQ 100/270 mg x 6 (Artesunate/Amodiaquine 100/270 mg Tablet, 6 Tablets per Blister Pack)","ASAQ 25/67.5 mg x 3 (Artesunate/Amodiaquine 25/67.5 mg Tablet, 3 Tablets per Blister Pack)","ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)","Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)","Chloroquine 50 mg base/5 mL Syrup, 60 mL","Primaquine 7.5 mg Tablet","Primaquine 15 mg Tablet","Quinine Sulfate 300 mg Tablet","Quinine Dihydrochloride 600mg/2ml injectable (= Quinine Dihydrochloride 300mg/ml inj. or Quinine 250mg base/ml inj.)","Quinine Resorcine 400mg/4ml injectable","SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)","Long Lasting Insecticide Treated Nets (LLINs)","Long Lasting Insecticide Treated Hammock Net (LLIHN)","Dihydroartemisinin-Piperaquine (DHA-PPQ)","Pyronaridine-Artesunate","SP+AQ 76.5mg + 250/12.5mg Tablets","SP+AQ 153mg + 500/25mg Tablets","Data Collector","Timestamp","Total ALU","Total Artesunate","Total ASAQ","Total Chloroquine","Total Primaquine","Total Quinine","Total LLINs","Total Other Treatments","Total Malaria Cases","Total Treatments Issued","Total Treatments/Total Malaria Cases ","Severe Malaria Commodities/Severe Malaria Services Rendered","Total Malaria/ Malaria Service Rendered  ","Total ALU/Total Malaria Cases","LLINs","ACT Treatments Issued Overage","Acceptable Ratio","Current Ratio","DATE","Quarter"]
["NIUE **",null,"NEW","THIRD PHARMACY","FEBRUARY",2026,444,555,10,60,100,200,300,400,null,1300,1200,1400,null,900,1000,700,800,2000,2100,1800,1900,2200,2300,2400,1700,1500,1600,1100,null,null,null,"ISRAEL","2024-02-20T11:55:51",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":1000},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":3900},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":3400},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":4100},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":3700},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":6900},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":3100},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":5900},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":444},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":9200},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":20.72072072072072},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":7.0270270270270272},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":44.4},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":2.2522522522522523},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":51.666666666666664},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":8756},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":20.72072072072072},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2026-02-01"}]
["NIUE **",null,"NEW","PHARMACY","FEBRUARY",2026,3434,4545,19,342,111,222,333,444,null,3330,2220,4440,null,999,1000,777,888,1212,1313,8880,9990,1414,1515,1616,7770,5550,6660,1110,null,null,null,"STEVE","2024-02-20T12:27:05",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":1110},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":9990},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":3664},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":2525},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":18870},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":4545},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":12210},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":21090},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":3434},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":24754},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":7.2085032032615022},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":2.1980198019801982},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":180.73684210526315},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.32323820617355853},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":35.701754385964911},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":21320},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":7.2085032032615022},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2026-02-01"}]
["NIUE **",null,"NEW","PHARMACY","APRIL",2020,222,22,28,624,22,22,22,22,222,22,222,222,null,22,222,22,22,222,22,222,222,222,222,222,222,222,22,22,null,222,222,"STEVE","2024-02-26T17:23:10",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":88},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":466},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":288},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":244},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":444},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":666},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":244},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":488},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":222},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":842},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3.7927927927927927},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":21.181818181818183},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":7.9285714285714288},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.3963963963963964},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0.39102564102564102},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":620},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3.7927927927927927},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2020-04-01"}]
["NIUE **",null,"NEW","PHARMACY","JUNE",2027,444,444,37,906,444,444,444,444,444,444,444,444,null,444,444,444,444,444,444,444,444,444,444,444,444,444,444,444,null,444,444,"John Smith","2024-02-26T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":1776},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":1332},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":1776},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":888},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":888},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":1332},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":888},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":1776},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":444},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":4884},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":11},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":12},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":4},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0.98013245033112584},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":4440},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":11},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2027-06-01"}]
["NIUE **",null,"NEW","OTHER PHARMACY","MARCH",2023,29,30,46,1188,1,2,3,4,13,15,14,16,null,9,10,7,8,24,25,22,23,26,27,28,19,17,18,11,12,20,21,"Tim Burton","2024-02-27T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":10},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":45},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":34},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":49},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":45},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":81},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":35},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":65},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":29},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":112},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3.8620689655172415},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":1.5},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":0.63043478260869568},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.34482758620689657},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":2.9461279461279462E-2},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":83},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3.8620689655172415},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2023-03-01"}]
["LIBERIA",null,"NEW","THIRD PHARMACY","JULY",2024,111,111,55,1470,1,2,2,2,111,111,111,111,null,10,3,4,5,111,111,111,111,111,111,111,7,111,111,111,111,111,111,"ISRAEL","2024-02-28T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":7},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":333},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":22},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":222},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":222},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":333},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":222},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":340},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":111},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":473},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":4.2612612612612617},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":2.0181818181818181},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":6.3063063063063057E-2},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0.15102040816326531},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":362},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":4.2612612612612617},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-07-01"}]
["NIGER",null,"NEW","THIRD PHARMACY","MAY",2024,111,111,64,1752,2,5,3,2,111,111,111,111,null,6,2.5,15,10,111,111,1111,111,111,111,111,111,111,111,111,111,111,111,"ISRAEL","2024-02-29T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":12},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":333},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":33.5},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":222},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":1222},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":333},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":222},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":444},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":111},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":1489.5},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":13.418918918918919},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1.734375},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.10810810810810811},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0.12671232876712329},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":1378.5},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":13.418918918918919},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-05-01"}]
["ZAMBIA",null,"NEW","THIRD PHARMACY","JULY",2025,111,111,73,2034,2,1.5,1.3333333333333299,2,20,111,111,111,null,111,111,1111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,"ISRAEL","2024-03-01T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":6.8333333333333304},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":333},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":1444},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":222},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":222},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":333},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":222},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":444},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":111},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":1894.8333333333333},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":17.07057057057057},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1.5205479452054795},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":6.1561561561561534E-2},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0.10914454277286136},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":1783.8333333333333},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":17.07057057057057},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2025-07-01"}]
["ZAMBIA",null,"NEW","THIRD PHARMACY","FEBRUARY",2021,66,66,82,2316,2,2,2.5,0.75,33,666,66,66,null,66,66,66,66,66,66,66,66,66,66,66,66,66,66,66,66,66,66,"ISRAEL","2024-03-02T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":7.25},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":798},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":264},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":132},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":132},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":198},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":132},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":264},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":66},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":535.25},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":8.1098484848484844},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":12.090909090909092},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":0.80487804878048785},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.10984848484848485},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":5.6994818652849742E-2},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":469.25},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":8.1098484848484844},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2021-02-01"}]
["MOZAMBIQUE",null,"NEW","THIRD PHARMACY","FEBRUARY",2018,33,33,91,2598,33,33,33,33,33,33,33,33,null,333,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,"ISRAEL","2024-03-03T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":132},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":99},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":432},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":66},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":66},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":99},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":66},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":132},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":33},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":696},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":21.09090909090909},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":0.36263736263736263},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":4},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":2.5404157043879907E-2},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":663},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":21.09090909090909},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2018-02-01"}]
["BENIN",null,"NEW","THIRD PHARMACY","APRIL",2020,11,11,100,2880,11,11,11,11,11,11,11,11,null,11,11,11,11,11,11,11,11,11,11,11,3.6666666666666701,11,11,11,11,11,11,"ISRAEL","2024-03-04T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":44},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":33},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":44},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":22},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":22},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":33},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":22},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":36.666666666666671},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":11},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":132},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":12},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":0.11},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":4},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":7.6388888888888886E-3},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":121},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":12},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2020-04-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","APRIL",2024,22,1,88,5,null,33,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BB","2024-03-09T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":37},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":22},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":37},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.6818181818181819},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":0.25},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.6818181818181819},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":15},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.6818181818181819},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","APRIL",2024,44,32,1,8,3,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,"AA","2024-03-10T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":3},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":44},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":6.8181818181818177E-2},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":44},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":6.8181818181818177E-2},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":-41},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":6.8181818181818177E-2},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","APRIL",2024,1,1,1,1,3,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,"ISRAEL","2024-03-11T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":3},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":1},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":2},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","MAY",2019,4,4,4,4,null,null,null,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISRAEL","2024-03-12T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":99},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":4},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":99},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":24.75},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":24.75},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":95},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":24.75},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2019-05-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","APRIL",2024,3,3,3,3,44,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,"ISRAEL","2024-03-13T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":44},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":3},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":44},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":14.666666666666666},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":14.666666666666666},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":41},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":14.666666666666666},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","APRIL",2024,9,9,9,9,43,43,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,"ISRAEL","2024-03-14T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":86},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":9},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":86},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":9.5555555555555554},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":9.5555555555555554},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":77},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":9.5555555555555554},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","APRIL",2024,1,1,1,1,2,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,"ISRAEL","2024-03-15T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":2},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":1},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":2},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":2},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":2},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":1},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":2},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","APRIL",2024,3,3,3,3,21,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,"ISRAEL","2024-03-16T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":21},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":3},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":21},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":7},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":7},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":18},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":7},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","WEST","NEW","THIRD PHARMACY","APRIL",2024,10,10,10,10,100,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,"ISRAEL","2024-03-17T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":100},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":10},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":100},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":10},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":10},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":90},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":10},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","SOUTH","NEW","THIRD PHARMACY","APRIL",2024,4,4,4,4,33,33,33,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOHN","2024-03-18T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":132},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":4},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":132},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":33},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":33},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":128},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":33},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","SOUTH","NEW","THIRD PHARMACY","APRIL",2024,1,1,1,1,8,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,"HERMES ","2024-03-19T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":8},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":1},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":8},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":8},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":8},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":7},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":8},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","EAST","NEW","OTHER PHARMACY","APRIL",2024,5,6,7,8,1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOHN","2024-03-20T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":10},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":5},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":10},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":2},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":0.7142857142857143},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":2},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":5},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":2},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","EAST","NEW","OTHER PHARMACY","APRIL",2024,1,1,1,3,1,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,"JOHN","2024-03-21T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":1},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":1},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":0},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["MALAWI",null,null,null,"APRIL",2024,2,2,2,2,0.16666666666666699,8.3333333333333301E-2,5.5555555555555601E-2,4.1666666666666699E-2,null,null,null,null,null,0.66666666666666696,0.33333333333333298,0.66666666666666696,0.66666666666666696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-22T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":0.34722222222222254},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":2.3333333333333339},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":2},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":2.6805555555555562},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.3402777777777781},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.17361111111111127},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":0.68055555555555625},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.3402777777777781},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","CENTRAL","NEW","THIRD PHARMACY","JUNE",2024,5000,500,500,500,60000,200,100,30,9000,33,500,500,500,40,20,20,20,22,22,22,10,10,5,8,6,8,1000,5,6,4,8,"JOHN","2024-03-23T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":60330},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":1533},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":100},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":44},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":32},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":23},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":1008},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":1019},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":5000},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":60473},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":12.0946},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":3.0659999999999998},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":10},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":12.066000000000001},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":2.016},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":55473},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":12.0946},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-06-01"}]
["NIUE **","CENTRAL","NEW","THIRD PHARMACY","JUNE",2024,2,2,2,2,6,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,"HERMES ","2024-03-24T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":6},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":2},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":6},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":4},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":3},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-06-01"}]
["ZAMBIA","NORTH","NEW","FIRST PHARMACY","APRIL",2024,11,11,11,11,5.5,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,"JOE","2024-03-25T17:34:09",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":5.5},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":11},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":5.5},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.5},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.5},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":-5.5},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":0.5},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2024-04-01"}]
["NIUE **","CENTRAL","NEW","THIRD PHARMACY","MARCH",2020,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,null,null,null,"HERMES ","2024-04-04T14:12:30",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":0},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":0},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":0},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":"-    "},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":0},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":"-    "},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2020-03-01"}]
["BAHAMAS","THANJA","A","TA","JANUARY",2023,350,12,12000,120,50,100,150,200,15000,6,6,8,null,15,10,10,15,null,null,null,null,null,null,null,3000,150,null,null,null,null,null,"NOSA IGB","2024-04-04T22:07:27",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":500},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":20},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":50},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":150},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":3150},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":350},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":550},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.5714285714285714},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":1.6666666666666667},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":2.9166666666666667E-2},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.4285714285714286},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":1.25},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":200},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.5714285714285714},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2023-01-01"}]
["BAHAMAS","THANJA","A","TA","FEBRUARY",2023,225,13,20000,124,80,70,150,55,22000,5,9,4,null,null,null,null,null,null,null,null,null,null,null,null,4500,179,null,null,null,null,null,"NOSA IGB","2024-04-04T22:10:23",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":355},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":18},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":179},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":4679},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":225},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":355},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.5777777777777777},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":1.3846153846153846},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":1.125E-2},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.5777777777777777},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":1.4435483870967742},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":130},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.5777777777777777},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2023-02-01"}]
["BAHAMAS","LANSA","C","LC","JANUARY",2023,176,8,17890,690,100,120,25,55,23000,5,4,7,null,15,10,15,10,null,null,null,null,null,null,null,4500,455,null,null,null,null,null,"LANRE AHM","2024-04-04T22:13:03",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":300},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":16},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":50},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":455},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":4955},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":176},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":350},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.9886363636363635},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":2},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":9.8378982671883733E-3},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.7045454545454546},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":0.65942028985507251},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":174},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.9886363636363635},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2023-01-01"}]
["BAHAMAS","LANSA","C","LC","FEBRUARY",2023,4300,35,16700,430,1000,1500,2000,500,18500,20,16,5,null,75,200,50,25,null,null,null,null,null,null,null,7800,560,120,null,null,null,null,"LANRE AHM","2024-04-04T22:16:03",{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])","v":5000},{"$f":"SUM(Input_Database[[#This Row],[Artesunate (w/ 1 Amp NaHCO3 5% + 1 Amp NaCl 0.9%) 60 mg Vial, 1 Set]:[Artesunate suppository 100 mg (Rectal Artesunate)]])","v":41},{"$f":"SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])","v":350},{"$f":"SUM(Input_Database[[#This Row],[Chloroquine 150mg base Tablet (= Chloroquine Phosphate 250mg, or Chloroquine sulfate 200mg)]:[Chloroquine 50 mg base/5 mL Syrup, 60 mL]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Quinine Sulfate 300 mg Tablet]:[Quinine Resorcine 400mg/4ml injectable]])","v":0},{"$f":"SUM(Input_Database[[#This Row],[Long Lasting Insecticide Treated Nets (LLINs)]:[Long Lasting Insecticide Treated Hammock Net (LLIHN)]])","v":680},{"$f":"SUM(Input_Database[[#This Row],[SP (Sulfadoxine/pyrimethamine 500mg/25mg, 3 tablets)]:[Dihydroartemisinin-Piperaquine (DHA-PPQ)]])","v":8480},{"$f":"Input_Database[[#This Row],[Total Confirmed Malaria Cases]]","v":4300},{"$f":"SUM(Input_Database[[#This Row],[ALU 6x1 (Artemether/Lumefantrine 20/120 mg Tablet, 6x1 tablets per Blister Pack)]:[ALU 6x4 (Artemether/Lumefantrine 20/120 mg Tablet, 6x4 tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[ASAQ 100/270 mg x 3 (Artesunate/Amodiaquine 100/270 mg Tablet, 3 Tablets per Blister Pack)]:[ASAQ 50/135 mg x3 (Artesunate/Amodiaquine 50/135 mg Tablet, 3 Tablets per Blister Pack)]])+SUM(Input_Database[[#This Row],[Primaquine 7.5 mg Tablet]:[Primaquine 15 mg Tablet]])+SUM(Input_Database[[#This Row],[Dihydroartemisinin-Piperaquine (DHA-PPQ)]:[Pyronaridine-Artesunate]])","v":5350},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.2441860465116279},{"$f":"IF(Input_Database[[#This Row],[Total Severe Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Artesunate]]/Input_Database[[#This Row],[Total Severe Malaria Cases]])","v":1.1714285714285715},{"$f":"IF(Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]]=0,\"-    \",Input_Database[[#This Row],[Total Malaria Cases]]/Input_Database[[#This Row],[Total Suspected Malaria Cases Tested with mRDTs]])","v":0.25748502994011974},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total ALU]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.1627906976744187},{"$f":"IF(Input_Database[[#This Row],[Total Monthly LLIN Clients]]=0,\"-    \",Input_Database[[#This Row],[Total LLINs]]/Input_Database[[#This Row],[Total Monthly LLIN Clients]])","v":1.5813953488372092},{"$f":"Input_Database[[#This Row],[Total Treatments Issued]]-Input_Database[[#This Row],[Total Malaria Cases]]","v":1050},{"$f":"_xlfn.IFNA(INDEX(TreatmentAcceptableRatio[],MATCH(Input_Database[[#This Row],[Country]],TreatmentAcceptableRatio[Commodity],0),2),\"-    \")","v":"-    "},{"$f":"IF(Input_Database[[#This Row],[Total Malaria Cases]]=0,\"-    \",Input_Database[[#This Row],[Total Treatments Issued]]/Input_Database[[#This Row],[Total Malaria Cases]])","v":1.2441860465116279},{"$f":"IFERROR(DATE(Input_Database[[#This Row],[Year]],IF(Input_Database[[#This Row],[Month]]=\"January\",1,IF(Input_Database[[#This Row],[Month]]=\"February\",2,IF(Input_Database[[#This Row],[Month]]=\"March\",3,IF(Input_Database[[#This Row],[Month]]=\"April\",4,IF(Input_Database[[#This Row],[Month]]=\"May\",5,IF(Input_Database[[#This Row],[Month]]=\"June\",6,IF(Input_Database[[#This Row],[Month]]=\"July\",7,IF(Input_Database[[#This Row],[Month]]=\"August\",8,IF(Input_Database[[#This Row],[Month]]=\"September\",9,IF(Input_Database[[#This Row],[Month]]=\"October\",10,IF(Input_Database[[#This Row],[Month]]=\"November\",11,IF(Input_Database[[#This Row],[Month]]=\"December\",12,\"Error\")))))))))))),1),\"-    \")","v":"2023-02-01"}]

{"sheet":"Facility","index":2,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["COUNTRY","REGION/PROVINCE/STATE","DISTRICT","FACILITY","DATA COLLECTOR 1","DATA COLLECTOR 2","DATA COLLECTOR 3"]
["NIUE **","EAST","NEW","PHARMACY","STEVE","John Smith","Clara Red"]
["NIUE **","EAST","NEW","OTHER PHARMACY","JOHN","Tim Burton","Steven Spiellberg"]
["NIUE **","EAST","NEW","THIRD PHARMACY","ISRAEL"]
["NIUE **","EAST","NEW","PHARMACY","ELIZABETH"]
["NIUE **","EAST","NEW","OTHER PHARMACY","TIM"]
["NIUE **","CENTRAL","NEW","THIRD PHARMACY","JOHN"]
["NIUE **","WEST","NEW","PHARMACY","GELF"]
["NIUE **","WEST","NEW","OTHER PHARMACY","JOSE"]
["NIUE **","CENTRAL","NEW","THIRD PHARMACY","HERMES "]
["NIUE **","WEST","NEW","PHARMACY","STEVE"]
["NIUE **","WEST","NEW","OTHER PHARMACY","JOHN"]
["NIUE **","CENTRAL","NEW","THIRD PHARMACY","ISRAEL","AA","BB"]
["NIUE **","SOUTH","NEW","PHARMACY","ELIZABETH","CC","DD"]
["NIUE **","SOUTH","NEW","OTHER PHARMACY","TIM"]
["NIUE **","SOUTH","NEW","THIRD PHARMACY","JOHN"]
["NIUE **","SOUTH","NEW","PHARMACY","GELF"]
["NIUE **","SOUTH","NEW","OTHER PHARMACY","JOSE"]
["NIUE **","SOUTH","NEW","THIRD PHARMACY","HERMES "]
["NIUE **","SOUTH","NEW","PHARMACY","STEVE"]
["NIUE **","SOUTH","NEW","OTHER PHARMACY","JOHN"]
["NIUE **","SOUTH","NEW","THIRD PHARMACY","ISRAEL"]
["NIUE **","SOUTH","NEW","PHARMACY","ELIZABETH"]
["NIUE **","SOUTH","NEW","OTHER PHARMACY","TIM"]
["NIUE **","SOUTH","NEW","THIRD PHARMACY","JOHN"]
["NIUE **","SOUTH","NEW","PHARMACY","GELF"]
["NIUE **","SOUTH","NEW","OTHER PHARMACY","JOSE"]
["NIUE **","SOUTH","NEW","THIRD PHARMACY","HERMES "]
["NIUE **","SOUTH","NEW","PHARMACY","STEVE"]
["NIUE **","SOUTH","NEW","OTHER PHARMACY","JOHN"]
["NIUE **","SOUTH","NEW","THIRD PHARMACY","ISRAEL"]
["NIUE **","SOUTH","NEW","PHARMACY","ELIZABETH"]
["NIUE **","SOUTH","NEW","OTHER PHARMACY","TIM"]
["LIBERIA","SOUTH","NEW","THIRD PHARMACY","JOHN"]
["MOZAMBIQUE","SOUTH","NEW","THIRD PHARMACY","JOHN"]
["NIGER","SOUTH","NEW","THIRD PHARMACY","JOHN"]
["ZAMBIA","SOUTH","NEW","THIRD PHARMACY","JOHN"]
["BENIN","SOUTH","NEW","THIRD PHARMACY","JOHN"]
["MALAWI","SOUTH","NEW","THIRD PHARMACY","JOHN"]
["TANZANIA","SOUTHEAST","NEW","THIRD PHARMACY","JOHN"]
["ZAMBIA","NORTH","NEW","FIRST PHARMACY","JOE"]
["ZAMBIA","NORTH","NEW","THIRD PHARMACY","JIM"]
["ZAMBIA","SOUTH","NEW","FIRST PHARMACY","BOB"]
["BAHAMAS","THANJA","A","TA","NOSA IGB"]
["BAHAMAS","THANJA","B","TB","NOSA IGB"]
["BAHAMAS","LANSA","C","LC","LANRE AHM"]
["BAHAMAS","LANSA","D","LD","LANRE AHM"]
["GUATEMALA","BOOM","C","C","STEVE"]

{"sheet":"ActAcceptable","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Commodity","ActAcceptableRatio"]
["ACT",1.1499999999999999]
["mRDT",1.1499999999999999]
["LLIN",1.1499999999999999]
["Severe Malaria",1.1499999999999999]
["Other",1.2]

{"sheet":"Total Malaria Cases","index":4,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Analysis Tools"]
["Dashboard"]
[]
["Total Malaria Cases"]
[]
["Total Monthly Treatments Issued"]
[]
["Total Monthly ACTs Consumed/Total Malaria Cases"]
[]
["Total Monthly Treatments/Total Malaria Cases"]
[]
["Severe Malaria Consumed/Severe Services"]
[]
["Total Monthly Malaria Cases/Total Suspected Malaria Cases Tested with mRDTs"]
[]
["Total Monthly LLINs Distributed/Total Monthly LLIN Clients"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Country","BAHAMAS"]
[null,null,"Region/Province/State","THANJA"]
[null,null,"District","(All)"]
[]
[null,null,"Row Labels","Sum of Total Malaria Cases"]
[null,null,"2023-01-01",350]
[null,null,"2023-02-01",225]
[null,null,"Grand Total",575]

{"sheet":"Total Monthly Treatments Issued","index":5,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Analysis Tools"]
["Dashboard"]
[]
["Total Malaria Cases"]
[]
["Total Monthly Treatments Issued"]
[]
["Total Monthly ACTs Consumed/Total Malaria Cases"]
[]
["Total Monthly Treatments/Total Malaria Cases"]
[]
["Severe Malaria Consumed/Severe Services"]
[]
["Total Monthly Malaria Cases/Total Suspected Malaria Cases Tested with mRDTs"]
[]
["Total Monthly LLINs Distributed/Total Monthly LLIN Clients"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Country","BAHAMAS"]
[null,null,"Region/Province/State","THANJA"]
[null,null,"District","(All)"]
[]
[null,null,"Row Labels","Sum of Total Treatments Issued"]
[null,null,"2023-01-01",550]
[null,null,"2023-02-01",355]
[null,null,"Grand Total",905]

{"sheet":"All ACTs vs Malaria Cases","index":6,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Analysis Tools"]
["Dashboard"]
[]
["Total Malaria Cases"]
[]
["Total Monthly Treatments Issued",null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Total Monthly ACTs Consumed/Total Malaria Cases"]
[]
["Total Monthly Treatments/Total Malaria Cases"]
[]
["Severe Malaria Consumed/Severe Services"]
[]
["Total Monthly Malaria Cases/Total Suspected Malaria Cases Tested with mRDTs"]
[]
["Total Monthly LLINs Distributed/Total Monthly LLIN Clients"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Country","BAHAMAS"]
[null,null,"Region/Province/State","THANJA"]
[null,null,"District","(All)"]
[]
[null,null,"Row Labels","Sum of Total Treatments Issued","Sum of Total Malaria Cases","Ratio of Treatments to Cases"]
[null,null,"2023-01-01",550,350,1.5714285714285714]
[null,null,"2023-02-01",355,225,1.5777777777777777]
[null,null,"Grand Total",905,575,1.5739130434782609]

{"sheet":"ALU Only vs Malaria Cases","index":7,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Analysis Tools"]
["Dashboard"]
[]
["Total Malaria Cases"]
[]
["Total Monthly Treatments Issued",null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Total Monthly ACTs Consumed/Total Malaria Cases"]
[]
["Total Monthly Treatments/Total Malaria Cases"]
[]
["Severe Malaria Consumed/Severe Services"]
[]
["Total Monthly Malaria Cases/Total Suspected Malaria Cases Tested with mRDTs"]
[]
["Total Monthly LLINs Distributed/Total Monthly LLIN Clients"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Country","BAHAMAS"]
[null,null,"Region/Province/State","THANJA"]
[null,null,"District","(All)"]
[]
[null,null,"Row Labels","Sum of Total ALU","Sum of Total Malaria Cases","Ratio of ALU to Cases"]
[null,null,"2023-01-01",500,350,1.4285714285714286]
[null,null,"2023-02-01",355,225,1.5777777777777777]
[null,null,"Grand Total",855,575,1.4869565217391305]

{"sheet":"Sev Treatments vs Sev Cases","index":8,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Analysis Tools"]
["Dashboard"]
[]
["Total Malaria Cases"]
[]
["Total Monthly Treatments Issued",null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Total Monthly ACTs Consumed/Total Malaria Cases"]
[]
["Total Monthly Treatments/Total Malaria Cases"]
[]
["Severe Malaria Consumed/Severe Services"]
[]
["Total Monthly Malaria Cases/Total Suspected Malaria Cases Tested with mRDTs"]
[]
["Total Monthly LLINs Distributed/Total Monthly LLIN Clients"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Country","BAHAMAS"]
[null,null,"Region/Province/State","THANJA"]
[null,null,"District","(All)"]
[]
[null,null,"Row Labels","Sum of Total Artesunate","Sum of Total Severe Malaria Cases","Ratio of Severe Treatments to Severe Cases"]
[null,null,"2023-01-01",20,12,1.6666666666666667]
[null,null,"2023-02-01",18,13,1.3846153846153846]
[null,null,"Grand Total",38,25,1.52]

{"sheet":"mRDTs vs Malaria Testing","index":9,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Analysis Tools"]
["Dashboard"]
[]
["Total Malaria Cases"]
[]
["Total Monthly Treatments Issued",null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Total Monthly ACTs Consumed/Total Malaria Cases"]
[]
["Total Monthly Treatments/Total Malaria Cases"]
[]
["Severe Malaria Consumed/Severe Services"]
[]
["Total Monthly Malaria Cases/Total Suspected Malaria Cases Tested with mRDTs"]
[]
["Total Monthly LLINs Distributed/Total Monthly LLIN Clients"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Country","BAHAMAS"]
[null,null,"Region/Province/State","THANJA"]
[null,null,"District","(All)"]
[]
[null,null,"Row Labels","Sum of mRDT","Sum of Total Suspected Malaria Cases Tested with mRDTs","Ratio of Malaria Tests (mRDTs) to Tested Cases"]
[null,null,"2023-01-01",15000,12000,1.25]
[null,null,"2023-02-01",22000,20000,1.1000000000000001]
[null,null,"Grand Total",37000,32000,1.15625]

{"sheet":"LLINs","index":10,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Analysis Tools"]
["Dashboard"]
[]
["Total Malaria Cases"]
[]
["Total Monthly Treatments Issued",null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Total Monthly ACTs Consumed/Total Malaria Cases"]
[]
["Total Monthly Treatments/Total Malaria Cases"]
[]
["Severe Malaria Consumed/Severe Services"]
[]
["Total Monthly Malaria Cases/Total Suspected Malaria Cases Tested with mRDTs"]
[]
["Total Monthly LLINs Distributed/Total Monthly LLIN Clients"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Country","BAHAMAS"]
[null,null,"Region/Province/State","THANJA"]
[null,null,"District","(All)"]
[]
[null,null,"Row Labels","Sum of Total LLINs","Sum of Total Monthly LLIN Clients","Ratio of LLINs to Clients"]
[null,null,"2023-01-01",150,120,1.25]
[null,null,"2023-02-01",179,124,1.4435483870967742]
[null,null,"Grand Total",329,244,1.348360655737705]

{"sheet":"Form Glossary","index":11,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Term","Description","Examples","Common Mistakes"]
["Consumption","Refers broadly to any form of commodity utilization  whether dispensed or issued or in some cases distribution data when used as a proxy for commodities issued or dispensed","1000 treatments of AL 6x1 were dispensed during the previous month. "]
["Service Data","Service data refers broadly to quantitative data on services provided ; hence  for the purposes of this process malaria services data will refer to malaria cases treated (ACTs and Severe malaria medicines) or people tested for malaria(MRDTs) or number of  recipients (LLINs).","There were 100 people tested for malaria using mRDTs during the previous month. "]
["Dispensing","This is when a health care worker gives the prescribed medicine to a patient.                                 \n\nThis occurs normally at the treating facility level (health care service delivery points) at the dispensaries/pharmacies, or consultation rooms","A patient received medicines from a health care worker"]
["Issuance","This is the act of on supply chain actor issuing another supply chain actor a given amount of product. \n\nNote that issuance often means the issuing of commodities from “one hand to another’ and distribution refers to commodity movement between supply chain levels or several supply chain facilities.","Medicines were issued from the pharmacy stores (stock cards) to the dispensaries (no records)"]
["Prescription","This is the patients’ treatments/medicines along with patients’ diagnosis.","Patients’ treatments and diagnosis were documented in register books"]
["Accetpable Discrepancy Ratio","The ADR is a pre-defined acceptable ratio comparing tha amount of commodities consumed vs the amount of malaria services provided. This is set prior to a site visit and is used as a standard of performance.","The the site visit team used the ADR as a standard of performance when reviewing the site's performance."]
["Deviation ratio","This is a ratio comparing the sites performance against the ADR for a particular commodity. When the sites ratio of commodities consumed to malaria services provided is calculated it is then compared against the performance standard of the ADR. The DR is then used to help guide improvement discussions. ","The sites team compared the DR to the ADR and used this comparison in discussions for identifying improvement actions. "]

{"sheet":"Data Flow Chart","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Action Plan Template","index":13,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Date","Action Number","Site Name","Site Area","Action Identified","Proposed Solution","Proposed Timeline","Responsible Party"]

{"sheet":"Drop Down","index":14,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["COUNTRY"]
["NIUE **"]
["LIBERIA"]
["MOZAMBIQUE"]
["NIGER"]
["ZAMBIA"]
["BENIN"]
["MALAWI"]
["TANZANIA"]
["BAHAMAS"]
["GUATEMALA"]

{"sheet":"Dropdown","index":15,"n_rows":201,"n_cols":2,"rows_kept":201,"cut":false,"hidden":true,"merged":[]}
["Countries (eng)","Upper"]
["Afghanistan",{"$f":"UPPER(A2)","v":"AFGHANISTAN"}]
["Albania","ALBANIA"]
["Algeria","ALGERIA"]
["Andorra","ANDORRA"]
["Angola","ANGOLA"]
["Antigua and Barbuda","ANTIGUA AND BARBUDA"]
["Argentina","ARGENTINA"]
["Armenia","ARMENIA"]
["Australia","AUSTRALIA"]
["Austria","AUSTRIA"]
["Azerbaijan","AZERBAIJAN"]
["Bahamas","BAHAMAS"]
["Bahrain","BAHRAIN"]
["Bangladesh","BANGLADESH"]
["Barbados","BARBADOS"]
["Belarus","BELARUS"]
["Belgium","BELGIUM"]
["Belize","BELIZE"]
["Benin","BENIN"]
["Bhutan","BHUTAN"]
["Bolivia","BOLIVIA"]
["Bosnia and Herzegovina","BOSNIA AND HERZEGOVINA"]
["Botswana","BOTSWANA"]
["Brazil","BRAZIL"]
["Brunei Darussalam","BRUNEI DARUSSALAM"]
["Bulgaria","BULGARIA"]
["Burkina Faso","BURKINA FASO"]
["Burundi","BURUNDI"]
["Cabo Verde","CABO VERDE"]
["Cambodia","CAMBODIA"]
["Cameroon","CAMEROON"]
["Canada","CANADA"]
["Central African Republic",{"$f":"UPPER(A34)","v":"CENTRAL AFRICAN REPUBLIC"}]
["Chad","CHAD"]
["Chile","CHILE"]
["China","CHINA"]
["Colombia","COLOMBIA"]
["Comoros","COMOROS"]
["Congo","CONGO"]
["Cook Islands **","COOK ISLANDS **"]
["Costa Rica","COSTA RICA"]
["Côte d'Ivoire","CÔTE D'IVOIRE"]
["Croatia","CROATIA"]
["Cuba","CUBA"]
["Cyprus","CYPRUS"]
["Czechia","CZECHIA"]
["Democratic People's Republic of Korea","DEMOCRATIC PEOPLE'S REPUBLIC OF KOREA"]
["Democratic Republic of the Congo","DEMOCRATIC REPUBLIC OF THE CONGO"]
["Denmark","DENMARK"]
["Djibouti","DJIBOUTI"]
["Dominica","DOMINICA"]
["Dominican Republic","DOMINICAN REPUBLIC"]
["Ecuador","ECUADOR"]
["Egypt","EGYPT"]
["El Salvador","EL SALVADOR"]
["Equatorial Guinea","EQUATORIAL GUINEA"]
["Eritrea","ERITREA"]
["Estonia","ESTONIA"]
["Eswatini","ESWATINI"]
["Ethiopia","ETHIOPIA"]
["Fiji","FIJI"]
["Finland","FINLAND"]
["France","FRANCE"]
["Gabon","GABON"]
["Gambia",{"$f":"UPPER(A66)","v":"GAMBIA"}]
["Georgia","GEORGIA"]
["Germany","GERMANY"]
["Ghana","GHANA"]
["Greece","GREECE"]
["Grenada","GRENADA"]
["Guatemala","GUATEMALA"]
["Guinea","GUINEA"]
["Guinea-Bissau","GUINEA-BISSAU"]
["Guyana","GUYANA"]
["Haiti","HAITI"]
["Holy See *","HOLY SEE *"]
["Honduras","HONDURAS"]
["Hungary","HUNGARY"]
["Iceland","ICELAND"]
["India","INDIA"]
["Indonesia","INDONESIA"]
["Iran","IRAN"]
["Iraq","IRAQ"]
["Ireland","IRELAND"]
["Israel","ISRAEL"]
["Italy","ITALY"]
["Jamaica","JAMAICA"]
["Japan","JAPAN"]
["Jordan","JORDAN"]
["Kazakhstan","KAZAKHSTAN"]
["Kenya","KENYA"]
["Kiribati","KIRIBATI"]
["Kuwait","KUWAIT"]
["Kyrgyzstan","KYRGYZSTAN"]
["Laos","LAOS"]
["Latvia","LATVIA"]
["Lebanon",{"$f":"UPPER(A98)","v":"LEBANON"}]
["Lesotho","LESOTHO"]
["Liberia","LIBERIA"]
["Libya","LIBYA"]
["Liechtenstein","LIECHTENSTEIN"]
["Lithuania","LITHUANIA"]
["Luxembourg","LUXEMBOURG"]
["Madagascar","MADAGASCAR"]
["Malawi","MALAWI"]
["Malaysia","MALAYSIA"]
["Maldives","MALDIVES"]
["Mali","MALI"]
["Malta","MALTA"]
["Marshall Islands","MARSHALL ISLANDS"]
["Mauritania","MAURITANIA"]
["Mauritius","MAURITIUS"]
["Mexico","MEXICO"]
["Micronesia (Federated States of)","MICRONESIA (FEDERATED STATES OF)"]
["Monaco","MONACO"]
["Mongolia","MONGOLIA"]
["Montenegro","MONTENEGRO"]
["Morocco","MOROCCO"]
["Mozambique","MOZAMBIQUE"]
["Myanmar","MYANMAR"]
["Namibia","NAMIBIA"]
["Nauru","NAURU"]
["Nepal","NEPAL"]
["Netherlands","NETHERLANDS"]
["New Zealand","NEW ZEALAND"]
["Nicaragua","NICARAGUA"]
["Niger","NIGER"]
["Nigeria","NIGERIA"]
["Niue **",{"$f":"UPPER(A130)","v":"NIUE **"}]
["North Macedonia","NORTH MACEDONIA"]
["Norway","NORWAY"]
["Oman","OMAN"]
["Pakistan","PAKISTAN"]
["Palau","PALAU"]
["Panama","PANAMA"]
["Papua New Guinea","PAPUA NEW GUINEA"]
["Paraguay","PARAGUAY"]
["Peru","PERU"]
["Philippines","PHILIPPINES"]
["Poland","POLAND"]
["Portugal","PORTUGAL"]
["Qatar","QATAR"]
["Republic of Korea","REPUBLIC OF KOREA"]
["Republic of Moldova","REPUBLIC OF MOLDOVA"]
["Romania","ROMANIA"]
["Russian Federation","RUSSIAN FEDERATION"]
["Rwanda","RWANDA"]
["Saint Kitts and Nevis","SAINT KITTS AND NEVIS"]
["Saint Lucia","SAINT LUCIA"]
["Saint Vincent and the Grenadines","SAINT VINCENT AND THE GRENADINES"]
["Samoa","SAMOA"]
["San Marino","SAN MARINO"]
["Sao Tome and Principe","SAO TOME AND PRINCIPE"]
["Saudi Arabia","SAUDI ARABIA"]
["Senegal","SENEGAL"]
["Serbia","SERBIA"]
["Seychelles","SEYCHELLES"]
["Sierra Leone","SIERRA LEONE"]
["Singapore","SINGAPORE"]
["Slovakia","SLOVAKIA"]
["Slovenia",{"$f":"UPPER(A162)","v":"SLOVENIA"}]
["Solomon Islands","SOLOMON ISLANDS"]
["Somalia","SOMALIA"]
["South Africa","SOUTH AFRICA"]
["South Sudan","SOUTH SUDAN"]
["Spain","SPAIN"]
["Sri Lanka","SRI LANKA"]
["State of Palestine *","STATE OF PALESTINE *"]
["Sudan","SUDAN"]
["Suriname","SURINAME"]
["Sweden","SWEDEN"]
["Switzerland","SWITZERLAND"]
["Syria","SYRIA"]
["Tajikistan","TAJIKISTAN"]
["Tanzania","TANZANIA"]
["Thailand","THAILAND"]
["Timor-Leste","TIMOR-LESTE"]
["Togo","TOGO"]
["Tonga","TONGA"]
["Trinidad and Tobago","TRINIDAD AND TOBAGO"]
["Tunisia","TUNISIA"]
["Turkey","TURKEY"]
["Turkmenistan","TURKMENISTAN"]
["Tuvalu","TUVALU"]
["Uganda","UGANDA"]
["Ukraine","UKRAINE"]
["United Arab Emirates","UNITED ARAB EMIRATES"]
["United Kingdom of Great Britain and Northern Ireland","UNITED KINGDOM OF GREAT BRITAIN AND NORTHERN IRELAND"]
["United States of America","UNITED STATES OF AMERICA"]
["Uruguay","URUGUAY"]
["Uzbekistan","UZBEKISTAN"]
["Vanuatu","VANUATU"]
["Venezuela",{"$f":"UPPER(A194)","v":"VENEZUELA"}]
["Viet Nam","VIET NAM"]
["Yemen","YEMEN"]
["Zambia","ZAMBIA"]
["Zimbabwe","ZIMBABWE"]
[]
["*Observer State"]
["**Member of specialized agencies"]