{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","Data validation","ELEM list","Assessment form","Dashboard","Data summary"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":true,"merged":[]}
[null,null,"Interagency Emergency Health Kit 2017- Modules and Items\nSeptember 2017"]
[]
["Module","Pharmacological class","Item description","UOM","Qty","ATC"]
["basic module","Anti-infective medicines","Albendazole, chewable tablets 400 mg","tablet",2000,"P02CA03"]
["basic module","Anti-infective medicines","Amoxicillin, dispersible tablets 250 mg","tablet",30000,"J01CA04"]
["basic module","Dermatological medicines","Benzyl benzoate, lotion 25%[1] ","bottle, 1 litre",10,"P03AX01"]
["basic module","Disinfectants and antiseptics","Chlorhexidine digluconate, solution 5%","bottle, 1 litre",10,"A01AB03"]
["basic module","Medicines affecting the blood ","Ferrous sulfate + folic acid, tablets 200 mg+0.4 mg (and anolgues)","tablet",20000,"B03AE"]
["basic module","Analgesics","Ibuprofen, tablets 200 mg","tablet",40000,"M01AE01"]
["basic module","Dermatological medicines","Miconazole, cream 2%","tube 30 g",200,"D01AC02"]
["basic module","Gastrointestinal medicines","Omeprazole, solid oral dosage form 20 mg","tablet/capsule",1000,"A02BC02"]
["basic module","Solutions correcting water, electrolytes and acid-based disturbances ","ORS (oral rehydration salt) powder for dilution","sachet for 1 litre",2000,"A07CA"]
["basic module","Analgesics","Paracetamol, dispersible tablets 100 mg[2] ","tablet",10000,"N02BE01","mettere gocce"]
["basic module","Analgesics","Paracetamol, tablets, 500 mg","tablet",20000,"N02BE01"]
["basic module","Disinfectants and antiseptics","Povidone iodine, solution 10% ","bottle, 200 ml ",120,"D08AG02"]
["basic module","Anti-infective medicines","Gentamicine, eye drops 0,3%","bottle 10 ml",500,"S01AA11"]
["Module cold chain","Hormones , other endocrine medicines","Human Insulin NPH 100 IU/ml, 10 ml EP","vial",60,"A10AC01"]
["Module cold chain","Hormones , other endocrine medicines","Human Insulin Mix 70/30 100IU/ml, 10 ml EP","vial",200,"A10AD01"]
["Module cold chain","Hormones , other endocrine medicines","Human Insulin R100 IU/ml, 10 ml EP","vial",60,"A10Ab01"]
["Module cold chain","Hormones , other endocrine medicines","Glucagon1 mg/ mL.","vial",20,"H04AA01"]
["Supplementary Module","Anaesthetics","Ketamine, injection 50 mg/ml","10 ml/vial",25,"N01AX03"]
["Supplementary Module","Anaesthetics","Lidocaine, injection 1% ","20 ml/vial",50,"N01BB02"]
["Supplementary Module","Analgesics","Morphine, injection 10mg/ml","1 ml/ampoule",50,"N02AA01"]
["Supplementary Module","Analgesics","Morphine, tablet 10 mg ","tablet ",200,"N02AA01"]
["Supplementary Module","Antiallergics","Hydrocortisone, powder for injection 100mg  (as sodium succinate) ","vial",50,"H02AB09"]
["Supplementary Module","Antidotes","Calcium gluconate, injection 100mg/ml","10 ml/ampoule",10,"A12AA03"]
["Supplementary Module","Antidotes","Naloxone, injection 0.4 mg/ml","1 ml/ampoule",10,"V03AB15"]
["Supplementary Module","Anticonvulsants/antiepileptics","Carbamazepine tablets 200mg","tablet ",1605,"N03AF01"]
["Supplementary Module","Anticonvulsants/antiepileptics","Diazepam, injection 5mg/ml","2 ml/ampoule",200,"N05BA01"]
["Supplementary Module","Anticonvulsants/antiepileptics","Sodium Valproate 500mg enteric coated tablets","tablet",1900,"N03AG01"]
["Supplementary Module","Anticonvulsants/antiepileptics","Sodium Valproate 200mg scored tablets","tablet",3200,"N03AG01"]
["Supplementary Module","Anticonvulsants/antiepileptics","Magnesium sulfate, injection 500mg/ml ","10 ml/ampoule",30,"A12CC02"]
["Supplementary Module","Anti-infective medicines","Benzathine benzylpenicillin, powder for injection 2.4 million IU (1.44g)/vial","vial",50,"J01CE08"]
["Supplementary Module","Anti-infective medicines","Benzylpenicillin, powder for injection 5 million IU (3g)/vial, inj","vial ",250,"J01CE01"]
["Supplementary Module","Anti-infective medicines","Ceftriaxone, powder for injection 1g","vial",800,"J01DA13"]
["Supplementary Module","Anti-infective medicines","Cefalexin, solid oral dosage form 250 mg[6]","tablet/capsule",2000,"J01DB01"]
["Supplementary Module","Anti-infective medicines","Clotrimazole, pessary 500mg","pessary",100,"G01AF02"]
["Supplementary Module","Anti-infective medicines","Doxycycline, tablets 100mg ","tablet",3000,"J01AA02"]
["Supplementary Module","Anti-infective medicines","Metronidazole, tablets 500mg","tablet",2000,"G01AF01"]
["Supplementary Module","Anti-infective medicines","Nystatin, oral liquid 100,000IU/ml","bottle, 30ml",50,"A07AA02"]
["Supplementary Module","Cardiovascular medicines","Acetylsalicylic acid 100mg tablets USP","tablet",22000,"B01AC06"]
["Supplementary Module","Cardiovascular medicines","Amlodipine besylate 5 mg tablets","tablet",15000,"C08CA01"]
["Supplementary Module","Cardiovascular medicines","Bisoprolol, tablets 5 mg","tablet ",2000,"C07AB07"]
["Supplementary Module","Cardiovascular medicines","Hydralazine, powder for injection 20mg","ampoule",20,"C02DB02"]
["Supplementary Module","Cardiovascular medicines","Enalapril, tablets 5 mg","tablet ",5000,"C09AA02"]
["Supplementary Module","Cardiovascular medicines","Glyceryl trinitrate : (FCH)-free oral spay 0.4mg/ dose  (200doses)  ","spray ",3,"C01DA02"]
["Supplementary Module","Cardiovascular medicines","Methyldopa, tablets 250mg ","tablet",100,"C02AB01"]
["Supplementary Module","Dermatological medicines","Silver sulfadiazine, cream 1% ","tube, 50 g",30,"D06BA01"]
["Supplementary Module","Disinfectants and antiseptics","Sodium dichloroisocyanurate (NaDCC), tablet 1.67g  ","tablet ",1200,null,"mettere amuchina"]
["Supplementary Module","Diuretics","Furosemide, injection 10mg/ml","2 ml/ampoule",20,"C03CA01"]
["Supplementary Module","Diuretics","Furosemide, tablets  40 mg","tablet ",500,"C03CA01"]
["Supplementary Module","Diuretics","Hydrochlorothiazide, tablets 25mg","tablet ",500,"C03AA03"]
["Supplementary Module","Gastrointestinal medicines","Atropine, injection 1mg/ml","1 ml/ampoule",50,"A03BA01"]
["Supplementary Module","Medicines affecting the blood ","Folic acid, tablets 5mg ","tablet ",1000,"B03BB01"]
["Supplementary Module","Medicines affecting the blood ","Heparin sodium, injection5,000 IU/ml","vial 5 ml ",25,"B01AB01"]
["Supplementary Module","Oxytocics","Oxytocin, injection 10 IU/ml [5]","ampoule",200,"H01BB02"]
["Supplementary Module","Oxytocics","Misoprostol, tablets 200mcg","tablet ",60,"G02AD06"]
["Supplementary Module","Mental health medicines","Biperiden, tablets 2 mg ","tablet",400,"N04AA02"]
["Supplementary Module","Mental health medicines","Diazepam, tablets  5 mg ","tablet",240,"N05BA01"]
["Supplementary Module","Mental health medicines","Fluoxetine, tablets 20 mg","tablet",5000,"N06AB03"]
["Supplementary Module","Mental health medicines","Haloperidol, injection 5 mg/ml ","1 ml/ampoule",20,"N05AD01"]
["Supplementary Module","Mental health medicines","Risperidone 2mg BP","tablet",400,"N05AX08"]
["Supplementary Module","Mental health medicines","Haloperidol, tablets 5mg ","tablet ",1300,"N05AD01"]
["Supplementary Module","Medicines acting on the respiratory tract","Beclomethasone, inhaler 100 mcg/dose  ","unit",75,"R03BA01"]
["Supplementary Module","Medicines acting on the respiratory tract","Epinephrine (Adrenaline),  injection 1 mg/ml","1 ml/ampoule",50,"C01CA24"]
["Supplementary Module","Medicines acting on the respiratory tract","Prednisone 5mg ","tablet",7700,"H02AB07"]
["Supplementary Module","Medicines acting on the respiratory tract","Salbutamol, inhaler 100 mcg/dose","unit",75,"R03AC02"]
["Supplementary Module","Solutions correcting water, electrolytes and acid-based disturbances","Compound solution of Sodium lactate (Ringer lactate), injectable solution, with giving set and needle","500 ml bag",200,"B05BB01"]
["Supplementary Module","Solutions correcting water, electrolytes and acid-based disturbances","Glucose 5%, injectable solution, with giving set and needle","500 ml bag",100,"B05BA03"]
["Supplementary Module","Solutions correcting water, electrolytes and acid-based disturbances","Glucose 50%, injectable solution (hypertonic)  ","50 ml/vial",100,"B05BA03"]
["Supplementary Module","Solutions correcting water, electrolytes and acid-based disturbances","Water for injection ","10 ml/plastic vial",2000]
["Supplementary Module","Vitamins","Retinol (vitamin A), capsules 200,000IU","capsule",4000,"A11CA01"]
["Supplementary Module","Vitamins","Ascorbic acid, tablets 250mg ","tablet",4000,"A11GA01"]
["Supplementary Module","Medicines to treat diabetes and endocrine conditions","Glibenclamide 5 mg tablets BP","tablet",26000,"A10BB01"]
["Supplementary Module","Medicines to treat diabetes and endocrine conditions","Levothyroxine sodium100 mcg (sodium salt)","tablet",4100,"H03AA01"]
["Supplementary Module","Medicines to treat diabetes and endocrine conditions","Metformin 500mg tablets BP","tablet",60000,"A10BA02"]
["Supplementary Module – PEP","Anti-infective medicines","Atazanavir (ATV) + ritonavir (r), tablets 300+100 mg","tablet",1500,"J05AR23 "]
["Supplementary Module – PEP","Anti-infective medicines","Azithromycin, oral suspension 200mg/5 ml ","bottle, 15 ml",10,"J01FA10"]
["Supplementary Module – PEP","Anti-infective medicines","Azithromycin, tablets 250mg ","tablet",200,"J01FA10"]
["Supplementary Module – PEP","Anti-infective medicines","Cefixime (as trihydrate), powder for oral suspension, 100 mg/5 ml","bottle, 15 ml",10,"J01DD08"]
["Supplementary Module – PEP","Anti-infective medicines","Cefixime, tablets 200mg","tablet",112,"J01DD08"]
["Supplementary Module – PEP","Anti-infective medicines","Lamivudine (3TC) + Tenofovir (TDF), tablets 300+300mg ","tablet",1500,"J05AR12"]
["Supplementary Module – PEP","Anti-infective medicines","Lamivudine (3TC) + Zidovudine (AZT), tablets 30+60 mg","tablet",1800,"J05AR01"]
["Supplementary Module – PEP",null,"Levonorgestrel, tablets 1.50mcg","tablet",50,"G03AC03"]
["Supplementary Module – PEP","Anti-infective medicines","Lopinavir (LPV) + ritonavir (r), tablets 200+50 mg","tablet",480,"J05AR10"]
["Supplementary Module – PEP","Anti-infective medicines","Lopinavir (LPV) + ritonavir (r), tablets 100+25mg ","tablet",180,"J05AR10"]

{"sheet":"Data validation","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Nystatin, oral liquid 100,000IU/ml (30ml)","bottle 30ml",50]
["Nystatin, oral liquid 100,000IU/ml (100ml)","bottle 100ml",15]
[]
["Paracetamol, solution 100mg/ml (30ml)  [3]","bottle 30ml",334]
["Paracetamol, suspension 120mg/5ml (120ml) [3]","bottle 120ml",348]
[]
["Carbamazepine tablets 200mg [1]","tablets",1605]
["Phenobarbital tablets 50 mg [1]","tablets",1605]
[]
["Ascorbic acid, tablets 500mg ","tablet",2000]
["Ascorbic acid, injectable solution 500mg/5ml","vial",2000]
[]
["Amoxicillin, dispersible tablets 500 mg [1]","tablet",15000]
["amoxicillin suspension 250mg/5mL (100ml) [1]","bottle 100ml",{"$f":"C13*(0.5/5)","v":1500}]

{"sheet":"ELEM list","index":2,"n_rows":123,"n_cols":5,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Basic Module"]
["#","Item description","UOM","Qty","ATC"]
[1,"Albendazole, chewable tablets 400 mg","tablet",2000,"P02CA03"]
[2,"Amoxicillin, dispersible tablets 500 mg [1]","tablet",15000,"J01CA04"]
[3,"Benzyl benzoate, lotion 25% [2] ","bottle, 1 litre",10,"P03AX01"]
[4,"Chlorhexidine digluconate, solution 5%","bottle, 1 litre",10,"A01AB03"]
[5,"Ferrous sulfate + folic acid, tablets 200 mg+0.4 mg (and analgues)","tablet",20000,"B03AE"]
[6,"Ibuprofen, tablets 200 mg","tablet",40000,"M01AE01"]
[7,"Miconazole, cream 2%","tube 30 g",200,"D01AC02"]
[8,"Omeprazole, solid oral dosage form 20 mg","tablet/capsule",1000,"A02BC02"]
[9,"ORS (oral rehydration salt) powder for dilution","sachet for 1 litre",2000,"A07CA"]
[10,"Paracetamol, solution 100mg/ml (30ml) [3]","bottle",334,"N02BE01"]
[11,"Paracetamol, tablets, 500 mg","tablet",20000,"N02BE01"]
[12,"Povidone iodine, solution 10% ","bottle, 200 ml ",120,"D08AG02"]
[13,"Gentamicine, eye drops 0,3%","bottle 10 ml",500,"S01AA11"]
[]
[]
[]
[null," Cold chain  module"]
["#","Item description","UOM","Qty","ATC"]
[null,"Hormones , other endocrine medicines"]
[1,"Human Insulin NPH 100 IU/ml, 10 ml","vial",60,"A10AC01"]
[2,"Human Insulin Mix 70/30 100IU/ml, 10 ml","vial",200,"A10AD01"]
[3,"Human Insulin R100 IU/ml, 10 ml","vial",60,"A10Ab01"]
[4,"Glucagon1 mg/ mL.","vial",20,"H04AA01"]
[]
[]
[]
[null,"Supplementary Module "]
["#","Item description","UOM","Qty","ATC"]
[null,"Anaesthetics"]
[1,"Ketamine, injection 50 mg/ml","10 ml/vial",25,"N01AX03"]
[2,"Lidocaine, injection 1% ","20 ml/vial",50,"N01BB02"]
[null,"Analgesics"]
[3,"Morphine, injection 10mg/ml","1 ml/ampoule",50,"N02AA01"]
[" 4","Morphine, tablets 10 mg (immediate release)","tablet ",200,"N02AA01"]
[null,"Antiallergics"]
[5,"Hydrocortisone, powder for injection 100mg/ml  (as sodium succinate) ","vial",50,"H02AB09"]
[null,"Antidotes"]
[6,"Calcium gluconate, injection 100mg/ml","10 ml/ampoule",10,"A12AA03"]
[7,"Naloxone, injection 0.4 mg/ml","1 ml/ampoule",10,"V03AB15"]
[null,"Anticonvulsants/antiepileptics"]
[8,"Carbamazepine, tablets 200mg [1]","tablet ",1605,"N03AF01"]
[9,"Diazepam, injection 5mg/ml","2 ml/ampoule",200,"N05BA01"]
[10,"Sodium Valproate 500mg enteric coated tablets","tablet",1900,"N03AG01"]
[11,"Sodium Valproate 200mg scored tablets","tablet",3200,"N03AG01"]
[12,"Magnesium sulfate, injection 200mg/ml ","10 ml/ampoule",75,"A12CC02"]
[null,"Anti-infective medicines"]
[13,"Benzathine benzylpenicillin, powder for injection 1.2 million IU/vial","vial",100,"J01CE08"]
[14,"Benzylpenicillin, powder for injection 1 million IU/vial, inj","vial ",1250,"J01CE01"]
[15,"Ceftriaxone, powder for injection 1g","vial",800,"J01DA13"]
[16,"Cefalexin, powder for oral suspension 250 mg/5 mL","bottle 100ml",100,"J01DB01"]
[17,"Clotrimazole, pessary 500mg","pessary",100,"G01AF02"]
[18,"Doxycycline, tablets 100mg ","tablet",3000,"J01AA02"]
[19,"Metronidazole, tablets 500mg","tablet",2000,"G01AF01"]
[20,"Nystatin, oral liquid 100,000IU/ml","bottle, 30ml",50,"A07AA02"]
[null,"Cardiovascular medicines"]
[21,"Acetylsalicylic acid, tablets 100mg","tablet",22000,"B01AC06"]
[22,"Amlodipine besylate, tablets 5 mg ","tablet",15000,"C08CA01"]
[23,"Bisoprolol, tablets 5 mg","tablet ",2000,"C07AB07"]
[24,"Hydralazine, powder for injection 20mg","ampoule",20,"C02DB02"]
[25,"Enalapril, tablets 5 mg","tablet ",5000,"C09AA02"]
[26,"Glyceryl trinitrate : (FCH)-free oral spray 0.4mg/ dose  (200doses)  ","spray ",3,"C01DA02"]
[27,"Methyldopa, tablets 250mg ","tablet",100,"C02AB01"]
[null,"Dermatological medicines"]
[28,"Silver sulfadiazine, cream 1% ","tube, 50 g",30,"D06BA01"]
[null,"Diuretics"]
[30,"Furosemide, injection 10mg/ml","2 ml/ampoule",20,"C03CA01"]
[31,"Furosemide, tablets  25 mg","tablet ",800,"C03CA01"]
[32,"Hydrochlorothiazide, tablets 25mg","tablet ",500,"C03AA03"]
[null,"Gastrointestinal medicines"]
[33,"Atropine, injection 1mg/ml","1 ml/ampoule",50,"A03BA01"]
[null,"Medicines affecting the blood "]
[34,"Folic acid, tablets 5mg ","tablet ",1000,"B03BB01"]
[35,"Heparin sodium, injection5,000 IU/ml","vial 5 ml ",25,"B01AB01"]
[null,"Oxytocics"]
[36,"Oxytocin, injection 5 IU/ml [2]","ampoule",400,"H01BB02"]
[37,"Misoprostol, tablets 200mcg","tablet ",60,"G02AD06"]
[null,"Mental health medicines"]
[38,"Biperiden, tablets 2 mg ","tablet",400,"N04AA02"]
[39,"Diazepam, tablets  5 mg ","tablet",240,"N05BA01"]
[40,"Fluoxetine, tablets 20 mg","tablet",5000,"N06AB03"]
[41,"Haloperidol, injection 5 mg/ml ","1 ml/ampoule",20,"N05AD01"]
[42,"Risperidone, tablets 2mg","tablet",400,"N05AX08"]
[43,"Haloperidol, tablets 5mg ","tablet ",1300,"N05AD01"]
[null,"Medicines acting on the respiratory tract"]
[44,"Beclomethasone, inhaler 100 mcg/dose  ","unit",75,"R03BA01"]
[45,"Epinephrine (Adrenaline),  injection 1 mg/ml","1 ml/ampoule",50,"C01CA24"]
[46,"Prednisone, tablets 5mg ","tablet",7700,"H02AB07"]
[47,"Salbutamol, inhaler 100 mcg/dose","unit",75,"R03AC02"]
[null,"Solutions correcting water, electrolytes and acid-based disturbances "]
[48,"Compound solution of Sodium lactate (Ringer lactate), injectable solution, with giving set and needle","500 ml bag",200,"B05BB01"]
[49,"Glucose 5%, injectable solution, with giving set and needle","500 ml bag",100,"B05BA03"]
[50,"Glucose 50%, injectable solution (hypertonic)  ","50 ml/vial",100,"B05BA03"]
[51,"Water for injection ","10 ml/plastic vial",2000]
[null,"Vitamins"]
[52,"Retinol (vitamin A), solution os/ev 100,000IU/ml","vial",8000,"A11CA01"]
[53,"Ascorbic acid, tablets 500mg ","tablet",2000,"A11GA01"]
[null,"Medicines to treat diabetes and endocrine conditions"]
[54,"Glibenclamide, tablets 5 mg tablets","tablet",26000,"A10BB01"]
[55,"Levothyroxine sodium, tablets100 mcg (sodium salt)","tablet",4100,"H03AA01"]
[56,"Metformin 500mg tablets","tablet",60000,"A10BA02"]
[]
[]
[]
[null,"Supplementary Module – Post Exposure Prohylaxis (PEP)"]
["#","Item description","UOM","Qty","ATC"]
[1,"Atazanavir (ATV) + ritonavir (r), tablets 300+100 mg","tablet",1500,"J05AR23 "]
[2,"Azithromycin, oral suspension 200mg/5 ml ","bottle, 15 ml",10,"J01FA10"]
[3,"Azithromycin, tablets 500mg ","tablet",100,"J01FA10"]
[4,"Cefixime (as trihydrate), powder for oral suspension, 100 mg/5 ml","bottle, 100 ml",2,"J01DD08"]
[5,"Cefixime, tablets 400mg","tablet",56,"J01DD08"]
[6,"Lamivudine (3TC) + Tenofovir (TDF), tablets 300+300mg ","tablet",1500,"J05AR12"]
[7,"Lamivudine (3TC) + Zidovudine (AZT), tablets 30+60 mg","tablet",1800,"J05AR01"]
[8,"Levonorgestrel, tablets 1.50mcg","tablet",50,"G03AC03"]
[9,"Lopinavir (LPV) + ritonavir (r), tablets 200+50 mg","tablet",480,"J05AR10"]
[10,"Lopinavir (LPV) + ritonavir (r), tablets 100+25mg ","tablet",180,"J05AR10"]

{"sheet":"Assessment form","index":3,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[[2,3,4,3],[2,4,4,4],[2,6,4,6]]}
[]
[null,null,null,"Comment","Disaster Index",null,"N° patients considered "]
[null,null,null,{"$f":"IF(E3=0,\"\",IF(AND(E3>0,E3<0.33),\"Low coverage\",IF(AND(E3>=0.33,E3<0.66),\"Medium coverage\",IF(AND(E3>=0.66,E3<1),\"High coverage\",IF(E3=1,\"Full coverage\",\"\")))))","v":""},{"$f":"IFERROR(SUM(I8:I996)/COUNTA(I8:I996),\"\")","v":0}]
[]
[]
[]
["Module","ATC","Pharmacological class","Items description","UOM","Qty std 10.K patients","Qty for patients considered","Qty in stock","% covered"]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D8,'ELEM list'!B:B,0))","v":"P02CA03"},"Anti-infective medicines",{"$f":"'ELEM list'!B9","v":"Albendazole, chewable tablets 400 mg"},{"$f":"'ELEM list'!C9","v":"tablet"},{"$f":"'ELEM list'!D9","v":2000},{"$f":"IFERROR(IF($G$3=0,\"\",IF(ROUND((F8*$G$3)/10000,0)<1,1,ROUND((F8*$G$3)/10000,0))),\"ERROR\")","v":""},null,{"$f":"IFERROR(IF($G:$G=\"ERROR\",\"ERROR\",IF(($H:$H/$G:$G)<=1,$H:$H/$G:$G,1)),\"\")","v":""}]
["basic module","J01CA04","Anti-infective medicines","amoxicillin suspension 250mg/5mL (100ml) [1]",{"$f":"IFERROR(INDEX('Data validation'!$B$13:$B$14,MATCH('Assessment form'!$D$9,'Data validation'!$A$13:$A$14,0)),\"ERROR\")","v":"bottle 100ml"},{"$f":"IFERROR(INDEX('Data validation'!$C$13:$C$14,MATCH('Assessment form'!$D$9,'Data validation'!$A$13:$A$14,0)),\"ERROR\")","v":1500},"",null,{"$f":"IFERROR(IF($G:$G=\"ERROR\",\"ERROR\",IF(($H:$H/$G:$G)<=1,$H:$H/$G:$G,1)),\"\")","v":""}]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D10,'ELEM list'!B:B,0))","v":"P03AX01"},"Dermatological medicines",{"$f":"'ELEM list'!B11","v":"Benzyl benzoate, lotion 25% [2] "},{"$f":"'ELEM list'!C11","v":"bottle, 1 litre"},{"$f":"'ELEM list'!D11","v":10},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D11,'ELEM list'!B:B,0))","v":"A01AB03"},"Disinfectants and antiseptics",{"$f":"'ELEM list'!B12","v":"Chlorhexidine digluconate, solution 5%"},{"$f":"'ELEM list'!C12","v":"bottle, 1 litre"},{"$f":"'ELEM list'!D12","v":10},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D12,'ELEM list'!B:B,0))","v":"B03AE"},"Medicines affecting the blood ",{"$f":"'ELEM list'!B13","v":"Ferrous sulfate + folic acid, tablets 200 mg+0.4 mg (and analgues)"},{"$f":"'ELEM list'!C13","v":"tablet"},{"$f":"'ELEM list'!D13","v":20000},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D13,'ELEM list'!B:B,0))","v":"M01AE01"},"Analgesics",{"$f":"'ELEM list'!B14","v":"Ibuprofen, tablets 200 mg"},{"$f":"'ELEM list'!C14","v":"tablet"},{"$f":"'ELEM list'!D14","v":40000},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D14,'ELEM list'!B:B,0))","v":"D01AC02"},"Dermatological medicines",{"$f":"'ELEM list'!B15","v":"Miconazole, cream 2%"},{"$f":"'ELEM list'!C15","v":"tube 30 g"},{"$f":"'ELEM list'!D15","v":200},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D15,'ELEM list'!B:B,0))","v":"A02BC02"},"Gastrointestinal medicines",{"$f":"'ELEM list'!B16","v":"Omeprazole, solid oral dosage form 20 mg"},{"$f":"'ELEM list'!C16","v":"tablet/capsule"},{"$f":"'ELEM list'!D16","v":1000},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D16,'ELEM list'!B:B,0))","v":"A07CA"},"Solutions correcting water, electrolytes and acid-based disturbances",{"$f":"'ELEM list'!B17","v":"ORS (oral rehydration salt) powder for dilution"},{"$f":"'ELEM list'!C17","v":"sachet for 1 litre"},{"$f":"'ELEM list'!D17","v":2000},"",null,""]
["basic module","N02BE01","Analgesics","Paracetamol, solution 100mg/ml (30ml)  [3]",{"$f":"IFERROR(INDEX('Data validation'!$B$4:$B$5,MATCH('Assessment form'!$D$17,'Data validation'!$A$4:$A$5,0)),\"ERROR\")","v":"bottle 30ml"},{"$f":"IFERROR(INDEX('Data validation'!$C$4:$C$5,MATCH('Assessment form'!$D$17,'Data validation'!$A$4:$A$5,0)),\"ERROR\")","v":334},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D18,'ELEM list'!B:B,0))","v":"N02BE01"},"Analgesics",{"$f":"'ELEM list'!B19","v":"Paracetamol, tablets, 500 mg"},{"$f":"'ELEM list'!C19","v":"tablet"},{"$f":"'ELEM list'!D19","v":20000},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D19,'ELEM list'!B:B,0))","v":"D08AG02"},"Disinfectants and antiseptics",{"$f":"'ELEM list'!B20","v":"Povidone iodine, solution 10% "},{"$f":"'ELEM list'!C20","v":"bottle, 200 ml "},{"$f":"'ELEM list'!D20","v":120},"",null,""]
["basic module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D20,'ELEM list'!B:B,0))","v":"S01AA11"},"Anti-infective medicines",{"$f":"'ELEM list'!B21","v":"Gentamicine, eye drops 0,3%"},{"$f":"'ELEM list'!C21","v":"bottle 10 ml"},{"$f":"'ELEM list'!D21","v":500},"",null,""]
["Module cold chain",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D21,'ELEM list'!B:B,0))","v":"A10AC01"},"Hormones , other endocrine medicines",{"$f":"'ELEM list'!B28","v":"Human Insulin NPH 100 IU/ml, 10 ml"},{"$f":"'ELEM list'!C28","v":"vial"},{"$f":"'ELEM list'!D28","v":60},"",null,""]
["Module cold chain",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D22,'ELEM list'!B:B,0))","v":"A10AD01"},"Hormones , other endocrine medicines",{"$f":"'ELEM list'!B29","v":"Human Insulin Mix 70/30 100IU/ml, 10 ml"},{"$f":"'ELEM list'!C29","v":"vial"},{"$f":"'ELEM list'!D29","v":200},"",null,""]
["Module cold chain",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D23,'ELEM list'!B:B,0))","v":"A10Ab01"},"Hormones , other endocrine medicines",{"$f":"'ELEM list'!B30","v":"Human Insulin R100 IU/ml, 10 ml"},{"$f":"'ELEM list'!C30","v":"vial"},{"$f":"'ELEM list'!D30","v":60},"",null,""]
["Module cold chain",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D24,'ELEM list'!B:B,0))","v":"H04AA01"},"Hormones , other endocrine medicines",{"$f":"'ELEM list'!B31","v":"Glucagon1 mg/ mL."},{"$f":"'ELEM list'!C31","v":"vial"},{"$f":"'ELEM list'!D31","v":20},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D25,'ELEM list'!B:B,0))","v":"N01AX03"},"Anaesthetics",{"$f":"'ELEM list'!B38","v":"Ketamine, injection 50 mg/ml"},{"$f":"'ELEM list'!C38","v":"10 ml/vial"},{"$f":"'ELEM list'!D38","v":25},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D26,'ELEM list'!B:B,0))","v":"N01BB02"},"Anaesthetics",{"$f":"'ELEM list'!B39","v":"Lidocaine, injection 1% "},{"$f":"'ELEM list'!C39","v":"20 ml/vial"},{"$f":"'ELEM list'!D39","v":50},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D27,'ELEM list'!B:B,0))","v":"N02AA01"},"Analgesics",{"$f":"'ELEM list'!B41","v":"Morphine, injection 10mg/ml"},{"$f":"'ELEM list'!C41","v":"1 ml/ampoule"},{"$f":"'ELEM list'!D41","v":50},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D28,'ELEM list'!B:B,0))","v":"N02AA01"},"Analgesics",{"$f":"'ELEM list'!B42","v":"Morphine, tablets 10 mg (immediate release)"},{"$f":"'ELEM list'!C42","v":"tablet "},{"$f":"'ELEM list'!D42","v":200},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D29,'ELEM list'!B:B,0))","v":"H02AB09"},"Antiallergics",{"$f":"'ELEM list'!B44","v":"Hydrocortisone, powder for injection 100mg/ml  (as sodium succinate) "},{"$f":"'ELEM list'!C44","v":"vial"},{"$f":"'ELEM list'!D44","v":50},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D30,'ELEM list'!B:B,0))","v":"A12AA03"},"Antidotes",{"$f":"'ELEM list'!B46","v":"Calcium gluconate, injection 100mg/ml"},{"$f":"'ELEM list'!C46","v":"10 ml/ampoule"},{"$f":"'ELEM list'!D46","v":10},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D31,'ELEM list'!B:B,0))","v":"V03AB15"},"Antidotes",{"$f":"'ELEM list'!B47","v":"Naloxone, injection 0.4 mg/ml"},{"$f":"'ELEM list'!C47","v":"1 ml/ampoule"},{"$f":"'ELEM list'!D47","v":10},"",null,""]
["Supplementary Module","N03AF01","Anticonvulsants/antiepileptics","Carbamazepine tablets 200mg [1]",{"$f":"IFERROR(INDEX('Data validation'!$B$7:$B$8,MATCH('Assessment form'!$D$32,'Data validation'!$A$7:$A$8,0)),\"ERROR\")","v":"tablets"},{"$f":"IFERROR(INDEX('Data validation'!$C$7:$C$8,MATCH('Assessment form'!$D$32,'Data validation'!$A$7:$A$8,0)),\"ERROR\")","v":1605},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D33,'ELEM list'!B:B,0))","v":"N05BA01"},"Anticonvulsants/antiepileptics",{"$f":"'ELEM list'!B50","v":"Diazepam, injection 5mg/ml"},{"$f":"'ELEM list'!C50","v":"2 ml/ampoule"},{"$f":"'ELEM list'!D50","v":200},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D34,'ELEM list'!B:B,0))","v":"N03AG01"},"Anticonvulsants/antiepileptics",{"$f":"'ELEM list'!B51","v":"Sodium Valproate 500mg enteric coated tablets"},{"$f":"'ELEM list'!C51","v":"tablet"},{"$f":"'ELEM list'!D51","v":1900},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D35,'ELEM list'!B:B,0))","v":"N03AG01"},"Anticonvulsants/antiepileptics",{"$f":"'ELEM list'!B52","v":"Sodium Valproate 200mg scored tablets"},{"$f":"'ELEM list'!C52","v":"tablet"},{"$f":"'ELEM list'!D52","v":3200},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D36,'ELEM list'!B:B,0))","v":"A12CC02"},"Anticonvulsants/antiepileptics",{"$f":"'ELEM list'!B53","v":"Magnesium sulfate, injection 200mg/ml "},{"$f":"'ELEM list'!C53","v":"10 ml/ampoule"},{"$f":"'ELEM list'!D53","v":75},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D37,'ELEM list'!B:B,0))","v":"J01CE08"},"Anti-infective medicines",{"$f":"'ELEM list'!B55","v":"Benzathine benzylpenicillin, powder for injection 1.2 million IU/vial"},{"$f":"'ELEM list'!C55","v":"vial"},{"$f":"'ELEM list'!D55","v":100},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D38,'ELEM list'!B:B,0))","v":"J01CE01"},"Anti-infective medicines",{"$f":"'ELEM list'!B56","v":"Benzylpenicillin, powder for injection 1 million IU/vial, inj"},{"$f":"'ELEM list'!C56","v":"vial "},{"$f":"'ELEM list'!D56","v":1250},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D39,'ELEM list'!B:B,0))","v":"J01DA13"},"Anti-infective medicines",{"$f":"'ELEM list'!B57","v":"Ceftriaxone, powder for injection 1g"},{"$f":"'ELEM list'!C57","v":"vial"},{"$f":"'ELEM list'!D57","v":800},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D40,'ELEM list'!B:B,0))","v":"J01DB01"},"Anti-infective medicines",{"$f":"'ELEM list'!B58","v":"Cefalexin, powder for oral suspension 250 mg/5 mL"},{"$f":"'ELEM list'!C58","v":"bottle 100ml"},{"$f":"'ELEM list'!D58","v":100},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D41,'ELEM list'!B:B,0))","v":"G01AF02"},"Anti-infective medicines",{"$f":"'ELEM list'!B59","v":"Clotrimazole, pessary 500mg"},{"$f":"'ELEM list'!C59","v":"pessary"},{"$f":"'ELEM list'!D59","v":100},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D42,'ELEM list'!B:B,0))","v":"J01AA02"},"Anti-infective medicines",{"$f":"'ELEM list'!B60","v":"Doxycycline, tablets 100mg "},{"$f":"'ELEM list'!C60","v":"tablet"},{"$f":"'ELEM list'!D60","v":3000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D43,'ELEM list'!B:B,0))","v":"G01AF01"},"Anti-infective medicines",{"$f":"'ELEM list'!B61","v":"Metronidazole, tablets 500mg"},{"$f":"'ELEM list'!C61","v":"tablet"},{"$f":"'ELEM list'!D61","v":2000},"",null,""]
["Supplementary Module","A07AA02","Anti-infective medicines","Nystatin, oral liquid 100,000IU/ml (100ml)",{"$f":"IFERROR(INDEX('Data validation'!$B$1:$B$2,MATCH('Assessment form'!$D$44,'Data validation'!$A$1:$A$2,0)),\"ERROR\")","v":"bottle 100ml"},{"$f":"IFERROR(INDEX('Data validation'!$C$1:$C$2,MATCH('Assessment form'!$D$44,'Data validation'!$A$1:$A$2,0)),\"ERROR\")","v":15},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D45,'ELEM list'!B:B,0))","v":"B01AC06"},"Cardiovascular medicines",{"$f":"'ELEM list'!B64","v":"Acetylsalicylic acid, tablets 100mg"},{"$f":"'ELEM list'!C64","v":"tablet"},{"$f":"'ELEM list'!D64","v":22000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D46,'ELEM list'!B:B,0))","v":"C08CA01"},"Cardiovascular medicines",{"$f":"'ELEM list'!B65","v":"Amlodipine besylate, tablets 5 mg "},{"$f":"'ELEM list'!C65","v":"tablet"},{"$f":"'ELEM list'!D65","v":15000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D47,'ELEM list'!B:B,0))","v":"C07AB07"},"Cardiovascular medicines",{"$f":"'ELEM list'!B66","v":"Bisoprolol, tablets 5 mg"},{"$f":"'ELEM list'!C66","v":"tablet "},{"$f":"'ELEM list'!D66","v":2000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D48,'ELEM list'!B:B,0))","v":"C02DB02"},"Cardiovascular medicines",{"$f":"'ELEM list'!B67","v":"Hydralazine, powder for injection 20mg"},{"$f":"'ELEM list'!C67","v":"ampoule"},{"$f":"'ELEM list'!D67","v":20},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D49,'ELEM list'!B:B,0))","v":"C09AA02"},"Cardiovascular medicines",{"$f":"'ELEM list'!B68","v":"Enalapril, tablets 5 mg"},{"$f":"'ELEM list'!C68","v":"tablet "},{"$f":"'ELEM list'!D68","v":5000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D50,'ELEM list'!B:B,0))","v":"C01DA02"},"Cardiovascular medicines",{"$f":"'ELEM list'!B69","v":"Glyceryl trinitrate : (FCH)-free oral spray 0.4mg/ dose  (200doses)  "},{"$f":"'ELEM list'!C69","v":"spray "},{"$f":"'ELEM list'!D69","v":3},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D51,'ELEM list'!B:B,0))","v":"C02AB01"},"Cardiovascular medicines",{"$f":"'ELEM list'!B70","v":"Methyldopa, tablets 250mg "},{"$f":"'ELEM list'!C70","v":"tablet"},{"$f":"'ELEM list'!D70","v":100},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D52,'ELEM list'!B:B,0))","v":"D06BA01"},"Dermatological medicines",{"$f":"'ELEM list'!B72","v":"Silver sulfadiazine, cream 1% "},{"$f":"'ELEM list'!C72","v":"tube, 50 g"},{"$f":"'ELEM list'!D72","v":30},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D53,'ELEM list'!B:B,0))","v":"C03CA01"},"Diuretics",{"$f":"'ELEM list'!B74","v":"Furosemide, injection 10mg/ml"},{"$f":"'ELEM list'!C74","v":"2 ml/ampoule"},{"$f":"'ELEM list'!D74","v":20},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D54,'ELEM list'!B:B,0))","v":"C03CA01"},"Diuretics",{"$f":"'ELEM list'!B75","v":"Furosemide, tablets  25 mg"},{"$f":"'ELEM list'!C75","v":"tablet "},{"$f":"'ELEM list'!D75","v":800},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D55,'ELEM list'!B:B,0))","v":"C03AA03"},"Diuretics",{"$f":"'ELEM list'!B76","v":"Hydrochlorothiazide, tablets 25mg"},{"$f":"'ELEM list'!C76","v":"tablet "},{"$f":"'ELEM list'!D76","v":500},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D56,'ELEM list'!B:B,0))","v":"A03BA01"},"Gastrointestinal medicines",{"$f":"'ELEM list'!B78","v":"Atropine, injection 1mg/ml"},{"$f":"'ELEM list'!C78","v":"1 ml/ampoule"},{"$f":"'ELEM list'!D78","v":50},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D57,'ELEM list'!B:B,0))","v":"B03BB01"},"Medicines affecting the blood ",{"$f":"'ELEM list'!B80","v":"Folic acid, tablets 5mg "},{"$f":"'ELEM list'!C80","v":"tablet "},{"$f":"'ELEM list'!D80","v":1000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D58,'ELEM list'!B:B,0))","v":"B01AB01"},"Medicines affecting the blood ",{"$f":"'ELEM list'!B81","v":"Heparin sodium, injection5,000 IU/ml"},{"$f":"'ELEM list'!C81","v":"vial 5 ml "},{"$f":"'ELEM list'!D81","v":25},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D59,'ELEM list'!B:B,0))","v":"H01BB02"},"Oxytocics",{"$f":"'ELEM list'!B83","v":"Oxytocin, injection 5 IU/ml [2]"},{"$f":"'ELEM list'!C83","v":"ampoule"},{"$f":"'ELEM list'!D83","v":400},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D60,'ELEM list'!B:B,0))","v":"G02AD06"},"Oxytocics",{"$f":"'ELEM list'!B84","v":"Misoprostol, tablets 200mcg"},{"$f":"'ELEM list'!C84","v":"tablet "},{"$f":"'ELEM list'!D84","v":60},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D61,'ELEM list'!B:B,0))","v":"N04AA02"},"Mental health medicines",{"$f":"'ELEM list'!B86","v":"Biperiden, tablets 2 mg "},{"$f":"'ELEM list'!C86","v":"tablet"},{"$f":"'ELEM list'!D86","v":400},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D62,'ELEM list'!B:B,0))","v":"N05BA01"},"Mental health medicines",{"$f":"'ELEM list'!B87","v":"Diazepam, tablets  5 mg "},{"$f":"'ELEM list'!C87","v":"tablet"},{"$f":"'ELEM list'!D87","v":240},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D63,'ELEM list'!B:B,0))","v":"N06AB03"},"Mental health medicines",{"$f":"'ELEM list'!B88","v":"Fluoxetine, tablets 20 mg"},{"$f":"'ELEM list'!C88","v":"tablet"},{"$f":"'ELEM list'!D88","v":5000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D64,'ELEM list'!B:B,0))","v":"N05AD01"},"Mental health medicines",{"$f":"'ELEM list'!B89","v":"Haloperidol, injection 5 mg/ml "},{"$f":"'ELEM list'!C89","v":"1 ml/ampoule"},{"$f":"'ELEM list'!D89","v":20},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D65,'ELEM list'!B:B,0))","v":"N05AX08"},"Mental health medicines",{"$f":"'ELEM list'!B90","v":"Risperidone, tablets 2mg"},{"$f":"'ELEM list'!C90","v":"tablet"},{"$f":"'ELEM list'!D90","v":400},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D66,'ELEM list'!B:B,0))","v":"N05AD01"},"Mental health medicines",{"$f":"'ELEM list'!B91","v":"Haloperidol, tablets 5mg "},{"$f":"'ELEM list'!C91","v":"tablet "},{"$f":"'ELEM list'!D91","v":1300},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D67,'ELEM list'!B:B,0))","v":"R03BA01"},"Medicines acting on the respiratory tract",{"$f":"'ELEM list'!B93","v":"Beclomethasone, inhaler 100 mcg/dose  "},{"$f":"'ELEM list'!C93","v":"unit"},{"$f":"'ELEM list'!D93","v":75},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D68,'ELEM list'!B:B,0))","v":"C01CA24"},"Medicines acting on the respiratory tract",{"$f":"'ELEM list'!B94","v":"Epinephrine (Adrenaline),  injection 1 mg/ml"},{"$f":"'ELEM list'!C94","v":"1 ml/ampoule"},{"$f":"'ELEM list'!D94","v":50},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D69,'ELEM list'!B:B,0))","v":"H02AB07"},"Medicines acting on the respiratory tract",{"$f":"'ELEM list'!B95","v":"Prednisone, tablets 5mg "},{"$f":"'ELEM list'!C95","v":"tablet"},{"$f":"'ELEM list'!D95","v":7700},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D70,'ELEM list'!B:B,0))","v":"R03AC02"},"Medicines acting on the respiratory tract",{"$f":"'ELEM list'!B96","v":"Salbutamol, inhaler 100 mcg/dose"},{"$f":"'ELEM list'!C96","v":"unit"},{"$f":"'ELEM list'!D96","v":75},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D71,'ELEM list'!B:B,0))","v":"B05BB01"},"Solutions correcting water, electrolytes and acid-based disturbances",{"$f":"'ELEM list'!B98","v":"Compound solution of Sodium lactate (Ringer lactate), injectable solution, with giving set and needle"},{"$f":"'ELEM list'!C98","v":"500 ml bag"},{"$f":"'ELEM list'!D98","v":200},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D72,'ELEM list'!B:B,0))","v":"B05BA03"},"Solutions correcting water, electrolytes and acid-based disturbances",{"$f":"'ELEM list'!B99","v":"Glucose 5%, injectable solution, with giving set and needle"},{"$f":"'ELEM list'!C99","v":"500 ml bag"},{"$f":"'ELEM list'!D99","v":100},{"$f":"IFERROR(IF($G$3=0,\"\",IF(ROUND((F72*$G$3)/10000,0)<1,1,ROUND((F72*$G$3)/10000,0))),\"ERROR\")","v":""},null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D73,'ELEM list'!B:B,0))","v":"B05BA03"},"Solutions correcting water, electrolytes and acid-based disturbances",{"$f":"'ELEM list'!B100","v":"Glucose 50%, injectable solution (hypertonic)  "},{"$f":"'ELEM list'!C100","v":"50 ml/vial"},{"$f":"'ELEM list'!D100","v":100},"",null,{"$f":"IFERROR(IF($G:$G=\"ERROR\",\"ERROR\",IF(($H:$H/$G:$G)<=1,$H:$H/$G:$G,1)),\"\")","v":""}]
["Supplementary Module",null,"Solutions correcting water, electrolytes and acid-based disturbances",{"$f":"'ELEM list'!B101","v":"Water for injection "},{"$f":"'ELEM list'!C101","v":"10 ml/plastic vial"},{"$f":"'ELEM list'!D101","v":2000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D75,'ELEM list'!B:B,0))","v":"A11CA01"},"Vitamins",{"$f":"'ELEM list'!B103","v":"Retinol (vitamin A), solution os/ev 100,000IU/ml"},{"$f":"'ELEM list'!C103","v":"vial"},{"$f":"'ELEM list'!D103","v":8000},"",null,""]
["Supplementary Module","A11GA01","Vitamins","Ascorbic acid, injectable solution 500mg/5ml",{"$f":"IFERROR(INDEX('Data validation'!$B$10:$B$11,MATCH('Assessment form'!$D$76,'Data validation'!$A$10:$A$11,0)),\"ERROR\")","v":"vial"},{"$f":"IFERROR(INDEX('Data validation'!$C$10:$C$11,MATCH('Assessment form'!$D$76,'Data validation'!$A$10:$A$11,0)),\"ERROR\")","v":2000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D77,'ELEM list'!B:B,0))","v":"A10BB01"},"Medicines to treat diabetes and endocrine conditions",{"$f":"'ELEM list'!B106","v":"Glibenclamide, tablets 5 mg tablets"},{"$f":"'ELEM list'!C106","v":"tablet"},{"$f":"'ELEM list'!D106","v":26000},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D78,'ELEM list'!B:B,0))","v":"H03AA01"},"Medicines to treat diabetes and endocrine conditions",{"$f":"'ELEM list'!B107","v":"Levothyroxine sodium, tablets100 mcg (sodium salt)"},{"$f":"'ELEM list'!C107","v":"tablet"},{"$f":"'ELEM list'!D107","v":4100},"",null,""]
["Supplementary Module",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D79,'ELEM list'!B:B,0))","v":"A10BA02"},"Medicines to treat diabetes and endocrine conditions",{"$f":"'ELEM list'!B108","v":"Metformin 500mg tablets"},{"$f":"'ELEM list'!C108","v":"tablet"},{"$f":"'ELEM list'!D108","v":60000},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D80,'ELEM list'!B:B,0))","v":"J05AR23 "},"Anti-infective medicines",{"$f":"'ELEM list'!B114","v":"Atazanavir (ATV) + ritonavir (r), tablets 300+100 mg"},{"$f":"'ELEM list'!C114","v":"tablet"},{"$f":"'ELEM list'!D114","v":1500},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D81,'ELEM list'!B:B,0))","v":"J01FA10"},"Anti-infective medicines",{"$f":"'ELEM list'!B115","v":"Azithromycin, oral suspension 200mg/5 ml "},{"$f":"'ELEM list'!C115","v":"bottle, 15 ml"},{"$f":"'ELEM list'!D115","v":10},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D82,'ELEM list'!B:B,0))","v":"J01FA10"},"Anti-infective medicines",{"$f":"'ELEM list'!B116","v":"Azithromycin, tablets 500mg "},{"$f":"'ELEM list'!C116","v":"tablet"},{"$f":"'ELEM list'!D116","v":100},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D83,'ELEM list'!B:B,0))","v":"J01DD08"},"Anti-infective medicines",{"$f":"'ELEM list'!B117","v":"Cefixime (as trihydrate), powder for oral suspension, 100 mg/5 ml"},{"$f":"'ELEM list'!C117","v":"bottle, 100 ml"},{"$f":"'ELEM list'!D117","v":2},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D84,'ELEM list'!B:B,0))","v":"J01DD08"},"Anti-infective medicines",{"$f":"'ELEM list'!B118","v":"Cefixime, tablets 400mg"},{"$f":"'ELEM list'!C118","v":"tablet"},{"$f":"'ELEM list'!D118","v":56},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D85,'ELEM list'!B:B,0))","v":"J05AR12"},"Anti-infective medicines",{"$f":"'ELEM list'!B119","v":"Lamivudine (3TC) + Tenofovir (TDF), tablets 300+300mg "},{"$f":"'ELEM list'!C119","v":"tablet"},{"$f":"'ELEM list'!D119","v":1500},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D86,'ELEM list'!B:B,0))","v":"J05AR01"},"Anti-infective medicines",{"$f":"'ELEM list'!B120","v":"Lamivudine (3TC) + Zidovudine (AZT), tablets 30+60 mg"},{"$f":"'ELEM list'!C120","v":"tablet"},{"$f":"'ELEM list'!D120","v":1800},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D87,'ELEM list'!B:B,0))","v":"G03AC03"},"Anti-infective medicines",{"$f":"'ELEM list'!B121","v":"Levonorgestrel, tablets 1.50mcg"},{"$f":"'ELEM list'!C121","v":"tablet"},{"$f":"'ELEM list'!D121","v":50},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D88,'ELEM list'!B:B,0))","v":"J05AR10"},"Anti-infective medicines",{"$f":"'ELEM list'!B122","v":"Lopinavir (LPV) + ritonavir (r), tablets 200+50 mg"},{"$f":"'ELEM list'!C122","v":"tablet"},{"$f":"'ELEM list'!D122","v":480},"",null,""]
["Supplementary Module – PEP",{"$f":"INDEX('ELEM list'!E:E,MATCH('Assessment form'!D89,'ELEM list'!B:B,0))","v":"J05AR10"},"Anti-infective medicines",{"$f":"'ELEM list'!B123","v":"Lopinavir (LPV) + ritonavir (r), tablets 100+25mg "},{"$f":"'ELEM list'!C123","v":"tablet"},{"$f":"'ELEM list'!D123","v":180},"",null,{"$f":"IFERROR(IF($G:$G=\"ERROR\",\"ERROR\",IF(($H:$H/$G:$G)<=1,$H:$H/$G:$G,1)),\"\")","v":""}]

{"sheet":"Dashboard","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data summary","index":5,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,8,4],[1,1,1,2]]}
[]
[null,"Modules covered"]
[null,"Modules","% avg coverage",null,"N° patients covered","Disaster Index"]
[null,"basic module",{"$f":"IFERROR(AVERAGEIF('Assessment form'!$A$8:$A$88,$B4,'Assessment form'!$I$8:$I$88),\"\")","v":""},null,{"$f":"'Assessment form'!G3","v":0},{"$f":"'Assessment form'!E3","v":0}]
[null,"Module cold chain",{"$f":"IFERROR(AVERAGEIF('Assessment form'!$A$8:$A$88,$B5,'Assessment form'!$I$8:$I$88),\"\")","v":""}]
[null,"Supplementary Module",{"$f":"IFERROR(AVERAGEIF('Assessment form'!$A$8:$A$88,$B6,'Assessment form'!$I$8:$I$88),\"\")","v":""}]
[null,"Supplementary Module – PEP",{"$f":"IFERROR(AVERAGEIF('Assessment form'!$A$8:$A$88,$B7,'Assessment form'!$I$8:$I$88),\"\")","v":""}]
[]
[null,"N° and qty of items covered for each pharmacological class"]
[null,"Pharmacological class","N°","% of items covered","% of QTY covered"]
[null,"Anti-infective medicines",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B11,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B11,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B11)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B11,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Dermatological medicines",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B12,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B12,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B12)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B12,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Disinfectants and antiseptics",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B13,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B13,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B13)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B13,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Medicines affecting the blood ",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B14,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B14,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B14)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B14,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Analgesics",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B15,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B15,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B15)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B15,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Gastrointestinal medicines",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B16,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B16,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B16)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B16,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Hormones , other endocrine medicines",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B17,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B17,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B17)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B17,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Anaesthetics",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B18,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B18,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B18)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B18,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Antiallergics",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B19,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B19,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B19)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B19,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Antidotes",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B20,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B20,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B20)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B20,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Anticonvulsants/antiepileptics",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B21,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B21,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B21)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B21,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Cardiovascular medicines",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B22,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B22,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B22)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B22,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Diuretics",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B23,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B23,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B23)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B23,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Oxytocics",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B24,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B24,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B24)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B24,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Mental health medicines",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B25,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B25,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B25)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B25,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Medicines acting on the respiratory tract",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B26,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B26,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B26)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B26,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Solutions correcting water, electrolytes and acid-based disturbances",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B27,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B27,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B27)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B27,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Vitamins",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B28,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B28,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B28)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B28,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[null,"Medicines to treat diabetes and endocrine conditions",{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B29,'Assessment form'!$I$8:$I$88,\">0\")","v":0},{"$f":"COUNTIFS('Assessment form'!$C$8:$C$88,'Data summary'!$B29,'Assessment form'!$I$8:$I$88,\">0\")/COUNTIF('Assessment form'!$C$8:$C$88,'Data summary'!$B29)","v":0},{"$f":"IFERROR(AVERAGEIF('Assessment form'!$C$8:$C$89,'Data summary'!$B29,'Assessment form'!$I$8:$I$89),\"\")","v":""}]
[]
[null,"Type of coverage","N° for each category","% for each category"]
[null,"Missing",{"$f":"IFERROR(COUNTIF('Assessment form'!$I$8:$I$88,0),\"\")","v":0},{"$f":"C32/COUNTA('Assessment form'!$D$8:$D$88)","v":0}]
[null,"Low coverage",{"$f":"IFERROR(COUNTIFS('Assessment form'!$I$8:$I$88,\">0\",'Assessment form'!$I$8:$I$88,\"<0,33\"),\"\")","v":0},{"$f":"C33/COUNTA('Assessment form'!$D$8:$D$88)","v":0}]
[null,"Medium coverage",{"$f":"IFERROR(COUNTIFS('Assessment form'!$I$8:$I$88,\">=0,33\",'Assessment form'!$I$8:$I$88,\"<0,66\"),\"\")","v":0},{"$f":"C34/COUNTA('Assessment form'!$D$8:$D$88)","v":0}]
[null,"high coverage",{"$f":"IFERROR(COUNTIFS('Assessment form'!$I$8:$I$88,\">=0,66\",'Assessment form'!$I$8:$I$88,\"<1\"),\"\")","v":0},{"$f":"C35/COUNTA('Assessment form'!$D$8:$D$88)","v":0}]
[null,"full coverage",{"$f":"IFERROR(COUNTIF('Assessment form'!$I$8:$I$88,1),\"\")","v":0},{"$f":"C36/COUNTA('Assessment form'!$D$8:$D$88)","v":0}]