{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INTRO","COUNTRY_INFO","DEC","ALB_MBD","PZQ","SUMMARY","SHIPMENT"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":7,"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":"INTRO","index":0,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,0,0,1],[34,1,34,2],[36,1,36,2],[22,2,23,4],[25,2,26,4],[27,1,27,4],[13,1,13,4],[18,2,18,4],[20,2,20,4],[17,1,17,4],[15,1,15,4],[32,1,32,2],[29,1,29,4],[30,1,30,4],[7,2,7,4],[49,1,49,2],[46,1,46,4],[38,1,38,2],[40,1,40,2],[42,1,42,2],[47,1,47,2],[44,1,44,2],[48,1,48,2],[28,2,28,4],[21,1,21,4],[16,1,16,4],[24,1,24,4],[19,1,19,4],[2,1,2,4],[1,1,1,4],[5,1,5,4],[3,1,3,4],[14,1,14,4],[12,1,12,4],[4,1,4,4],[11,1,11,4],[10,2,10,4],[8,2,8,4],[9,2,9,4]]}
[null,null,"The current version should be used in countries non-endemic for onchocerciasis"]
[null,"Joint request for selected PC medicines"]
[]
[null,"As part of global efforts to accelerate expansion of preventive chemotherapy (PC) for control and elimination of lymphatic filariasis, schistosomiasis and soil-transmitted helminthiases, the World Health Organization (WHO) facilitates the supply of albendazole 400 mg tablets (GSK) to national lymphatic filariasis elimination programmes and national soil-transmitted helminth control programmes; diethylcarbamazine citrate 100 mg tablets (Eisai) to national lymphatic filariasis elimination programmes; mebendazole 500 mg tablets (J&J) for national soil-transmitted helminth control programmes; and praziquantel 600 mg tablets (Merck KGaA)  for school-age children to national schistosomiasis control programmes. WHO also collaborates to supply ivermectin 3 mg tablets (Merck) for onchocerciasis and lymphatic filariasis donation programmes.  \nThis Excel-based tool is designed to assist countries in quantifying the number of tablets of relevant PC medicines required to reach the planned target population and districts for the year of request. Output of the tool is a joint request for PC medicines, which can be printed, signed and submitted to WHO to request these medicines."]
[]
[null,"Structure of the application (worksheets):"]
[]
[null,"INTRO","This worksheet includes guides on how to complete the joint request for selected PC medicines and information about the status of PC for endemic diseases in the country."]
[null,"COUNTRY_INFO","This worksheet includes information about administrative structure of the country, population by age group, status of endemicity for each disease, population requiring PC and planned interventions."]
[null,"DEC, ALB_MBD and PZQ","These worksheets include information about endemic districts targeted for treatment with specified PC medicines, treatment plan, and number of tablets required and requested. "]
[null,"SUMMARY","This worksheet includes summary of number of tablets requested, information about stock, and date for submission of requested medicines. Before generating the report (run macros) please select the medicine for which the report is needed. Follow the same rule to see the number of people to be treated for the specific disease. \nThis worksheet should be printed and submitted as a joint request for selected PC medicines (see the instruction for submission in the SUMMARY worksheet)."]
[]
[null,"Instruction for data entry"]
[]
[null,"Most of the cells in the above-mentioned worksheets include formula that are calculated automatically according to the treatment policy recommended by WHO for each disease.\nSee the link http://www.who.int/neglected_diseases/preventive_chemotherapy/pct_manual/en/index.html"]
[]
[null,"Please enter your data into the cells according to their colour code:"]
[]
[null,null,"White - cell is not protected. Please enter the value of the requested indicator."]
[]
[null,null,"Yellow - cell is protected and includes name of indicator. No data entry required."]
[]
[null,null,"Orange - cell is not protected and includes a drop-down menu. Please select the value from the drop-down list."]
[]
[]
[null,null,"Green - cell is not protected and includes formula. Please change the value only if your data are different from those that are calculated automatically."]
[]
[]
[null,null,"Blue - cell is protected and includes formula. No data entry required."]
[]
[null,"Country data"]
[]
[null,"COUNTRY",null,null,"Rwanda"]
[]
[null,"Year for request of the medicine",null,null,2018]
[]
[null,"Is country endemic for lymphatic filariasis (LF)?",null,null,"Non-endemic"]
[]
[null,"Is country endemic for onchocerciasis (ONCHO)?",null,null,"Non-endemic"]
[]
[null,"Is country endemic for soil-transmitted helminthiases (STH)?",null,null,"Endemic"]
[]
[null,"Is country endemic for schistosomiasis (SCH)?",null,null,"Endemic"]
[]
[null,"How many administrative units in the country?",null,null,30]
[]
[null,"If demographical data at the second administrative level are not available by age group, please enter the proportion (%) of population by age group in the country. If data are available, please leave these cells blank."]
[null,"Preschool-age children (PreSAC) - aged 1-4 years",null,null,0.11700000000000001]
[null,"School-age children (SAC) - aged 5-14 years",null,null,0.28799999999999998]
[null,"Adults - aged 15 years and older",null,null,0.56599999999999995]

{"sheet":"COUNTRY_INFO","index":1,"n_rows":38,"n_cols":21,"rows_kept":38,"cut":false,"hidden":false,"merged":[[7,0,7,15],[5,3,5,6],[5,7,5,9],[5,10,5,12],[5,13,5,15],[3,16,3,18],[5,16,5,18],[3,0,3,2],[3,7,3,9],[3,13,3,15],[5,0,5,2]]}
["COUNTRY INFORMATION"]
["Administrative structure, population by age group, status of endemicity and planned interventions"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":12266868},{"$f":"SUM(E$9:E$1000)","v":1457145.1221686804},{"$f":"SUM(F$9:F$1000)","v":3523503.6015928993},{"$f":"SUM(G$9:G$1000)","v":6906877.4758457076},null,null,null,{"$f":"SUM(K$9:K$1000)","v":0},{"$f":"SUM(L$9:L$1000)","v":3902805.9752785848},{"$f":"SUM(M$9:M$1000)","v":2433861.8399585611}]
[]
["Country administrative structure",null,null,"Population",null,null,null,"Endemicity",null,null,"Population requiring PC",null,null,"Number of treatment\nrounds planned for the year",null,null,"Epidemiological surveys\nplanned for the year"]
["Country","Province/State","District","Total","PreSAC","SAC","Adults","LF","STH","SCH","LF","STH","SCH","LF","STH","SCH","LF","STH","SCH","IU_ID","IU_Name"]
[]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"East","Bugesera",422173,55835.348747802273,119707.60375475789,233070.28151544734,0,1,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H9>0,IF($H9=4,\"Unknown\",IF($H9=99,\"Stopped\",$D9)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I9>1, $I9<5), IF($I9=4, \"Unknown\", E9+F9), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J9>0,$J9<5), IF($J9=4,\"Unknown\", IF($J9=1, $F9*0.33, IF($J9=2, $F9*0.5+$G9*0.2, SUM(F9:G9)))), 0),\"Not required\")","v":106467.85818046841},0,2,1,null,null,null,38111,"Bugesera"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"North","Burera",392623,42485.87438655569,127851.01088546851,212035.98420697695,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H10>0,IF($H10=4,\"Unknown\",IF($H10=99,\"Stopped\",$D10)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I10>1, $I10<5), IF($I10=4, \"Unknown\", E10+F10), 0),\"Not required\")","v":170336.8852720242},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J10>0,$J10<5), IF($J10=4,\"Unknown\", IF($J10=1, $F10*0.33, IF($J10=2, $F10*0.5+$G10*0.2, SUM(F10:G10)))), 0),\"Not required\")","v":106332.70228412966},0,2,1,null,null,null,38121,"Burera"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"North","Gakenke",394549,41508.446456186306,116223.65007732168,227703.47770250778,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H11>0,IF($H11=4,\"Unknown\",IF($H11=99,\"Stopped\",$D11)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I11>1, $I11<5), IF($I11=4, \"Unknown\", E11+F11), 0),\"Not required\")","v":157732.09653350798},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J11>0,$J11<5), IF($J11=4,\"Unknown\", IF($J11=1, $F11*0.33, IF($J11=2, $F11*0.5+$G11*0.2, SUM(F11:G11)))), 0),\"Not required\")","v":103652.5205791624},0,2,1,null,null,null,38122,"Gakenke"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"Kigali","Gasabo",617732,69939.795096988237,134928.10027560566,394262.38475027896,0,1,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H12>0,IF($H12=4,\"Unknown\",IF($H12=99,\"Stopped\",$D12)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I12>1, $I12<5), IF($I12=4, \"Unknown\", E12+F12), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J12>0,$J12<5), IF($J12=4,\"Unknown\", IF($J12=1, $F12*0.33, IF($J12=2, $F12*0.5+$G12*0.2, SUM(F12:G12)))), 0),\"Not required\")","v":44526.273090949871},0,2,0,null,null,null,38118,"Gasabo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"East","Gatsibo",505117,62756.622087012933,155373.24984445944,273294.96715312084,0,2,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H13>0,IF($H13=4,\"Unknown\",IF($H13=99,\"Stopped\",$D13)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I13>1, $I13<5), IF($I13=4, \"Unknown\", E13+F13), 0),\"Not required\")","v":218129.87193147239},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J13>0,$J13<5), IF($J13=4,\"Unknown\", IF($J13=1, $F13*0.33, IF($J13=2, $F13*0.5+$G13*0.2, SUM(F13:G13)))), 0),\"Not required\")","v":132345.6183528539},0,2,1,null,null,null,38112,"Gatsibo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"North","Gicumbi",461474,48549.201052366239,142873.36309696344,258466.69893593068,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H14>0,IF($H14=4,\"Unknown\",IF($H14=99,\"Stopped\",$D14)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I14>1, $I14<5), IF($I14=4, \"Unknown\", E14+F14), 0),\"Not required\")","v":191422.56414932967},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J14>0,$J14<5), IF($J14=4,\"Unknown\", IF($J14=1, $F14*0.33, IF($J14=2, $F14*0.5+$G14*0.2, SUM(F14:G14)))), 0),\"Not required\")","v":123130.02133566786},0,2,1,null,null,null,38123,"Gicumbi"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"South","Gisagara",376202,49755.563430148373,107803.72076532149,207691.78371221028,0,2,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H15>0,IF($H15=4,\"Unknown\",IF($H15=99,\"Stopped\",$D15)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I15>1, $I15<5), IF($I15=4, \"Unknown\", E15+F15), 0),\"Not required\")","v":157559.28419546987},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J15>0,$J15<5), IF($J15=4,\"Unknown\", IF($J15=1, $F15*0.33, IF($J15=2, $F15*0.5+$G15*0.2, SUM(F15:G15)))), 0),\"Not required\")","v":95440.217125102805},0,2,1,null,null,null,38126,"Gisagara"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"South","Huye",383076,43371.941722031544,100945.31568933008,228758.20589673275,0,3,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H16>0,IF($H16=4,\"Unknown\",IF($H16=99,\"Stopped\",$D16)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I16>1, $I16<5), IF($I16=4, \"Unknown\", E16+F16), 0),\"Not required\")","v":144317.25741136161},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J16>0,$J16<5), IF($J16=4,\"Unknown\", IF($J16=1, $F16*0.33, IF($J16=2, $F16*0.5+$G16*0.2, SUM(F16:G16)))), 0),\"Not required\")","v":33311.954177478925},0,2,0,null,null,null,38127,"Huye"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"South","Kamonyi",397195,45368.368476731666,111431.08046916551,219678.41578206912,0,2,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H17>0,IF($H17=4,\"Unknown\",IF($H17=99,\"Stopped\",$D17)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I17>1, $I17<5), IF($I17=4, \"Unknown\", E17+F17), 0),\"Not required\")","v":156799.44894589717},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J17>0,$J17<5), IF($J17=4,\"Unknown\", IF($J17=1, $F17*0.33, IF($J17=2, $F17*0.5+$G17*0.2, SUM(F17:G17)))), 0),\"Not required\")","v":99651.223390996573},0,2,1,null,null,null,38128,"Kamonyi"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"West","Karongi",387054,44985.728781206562,115178.97800015815,216396.86775787294,0,3,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H18>0,IF($H18=4,\"Unknown\",IF($H18=99,\"Stopped\",$D18)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I18>1, $I18<5), IF($I18=4, \"Unknown\", E18+F18), 0),\"Not required\")","v":160164.70678136472},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J18>0,$J18<5), IF($J18=4,\"Unknown\", IF($J18=1, $F18*0.33, IF($J18=2, $F18*0.5+$G18*0.2, SUM(F18:G18)))), 0),\"Not required\")","v":38009.062740052192},0,2,0,null,null,null,38134,"Karongi"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"East","Kayonza",401458,50280.147017905991,120672.35284297439,218416.95864578366,0,2,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H19>0,IF($H19=4,\"Unknown\",IF($H19=99,\"Stopped\",$D19)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I19>1, $I19<5), IF($I19=4, \"Unknown\", E19+F19), 0),\"Not required\")","v":170952.49986088037},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J19>0,$J19<5), IF($J19=4,\"Unknown\", IF($J19=1, $F19*0.33, IF($J19=2, $F19*0.5+$G19*0.2, SUM(F19:G19)))), 0),\"Not required\")","v":104019.56815064393},0,2,1,null,null,null,38113,"Kayonza"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"Kigali","Kicukiro",371605,43562.467973387225,106858.36160993276,211110.42171718425,0,1,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H20>0,IF($H20=4,\"Unknown\",IF($H20=99,\"Stopped\",$D20)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I20>1, $I20<5), IF($I20=4, \"Unknown\", E20+F20), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J20>0,$J20<5), IF($J20=4,\"Unknown\", IF($J20=1, $F20*0.33, IF($J20=2, $F20*0.5+$G20*0.2, SUM(F20:G20)))), 0),\"Not required\")","v":35263.259331277812},0,2,0,null,null,null,38119,"Kicukiro"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"East","Kirehe",397039,49726.587226732656,120139.43473978608,216410.1076107405,0,2,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H21>0,IF($H21=4,\"Unknown\",IF($H21=99,\"Stopped\",$D21)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I21>1, $I21<5), IF($I21=4, \"Unknown\", E21+F21), 0),\"Not required\")","v":169866.02196651875},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J21>0,$J21<5), IF($J21=4,\"Unknown\", IF($J21=1, $F21*0.33, IF($J21=2, $F21*0.5+$G21*0.2, SUM(F21:G21)))), 0),\"Not required\")","v":39646.013464129406},0,2,0,null,null,null,38114,"Kirehe"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"South","Muhanga",372278,38419.326275914282,104067.88379592312,212238.80243684683,0,2,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H22>0,IF($H22=4,\"Unknown\",IF($H22=99,\"Stopped\",$D22)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I22>1, $I22<5), IF($I22=4, \"Unknown\", E22+F22), 0),\"Not required\")","v":142487.21007183741},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J22>0,$J22<5), IF($J22=4,\"Unknown\", IF($J22=1, $F22*0.33, IF($J22=2, $F22*0.5+$G22*0.2, SUM(F22:G22)))), 0),\"Not required\")","v":34342.401652654633},0,2,0,null,null,null,38129,"Muhanga"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"North","Musanze",429582,47346.230451863565,126973.98166636137,244048.29696551489,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H23>0,IF($H23=4,\"Unknown\",IF($H23=99,\"Stopped\",$D23)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I23>1, $I23<5), IF($I23=4, \"Unknown\", E23+F23), 0),\"Not required\")","v":174320.21211822494},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J23>0,$J23<5), IF($J23=4,\"Unknown\", IF($J23=1, $F23*0.33, IF($J23=2, $F23*0.5+$G23*0.2, SUM(F23:G23)))), 0),\"Not required\")","v":112296.65022628367},0,2,1,null,null,null,38124,"Musanze"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"East","Ngoma",393026,63400.531485020947,111049.37812904293,207134.65565913677,0,2,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H24>0,IF($H24=4,\"Unknown\",IF($H24=99,\"Stopped\",$D24)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I24>1, $I24<5), IF($I24=4, \"Unknown\", E24+F24), 0),\"Not required\")","v":174449.90961406389},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J24>0,$J24<5), IF($J24=4,\"Unknown\", IF($J24=1, $F24*0.33, IF($J24=2, $F24*0.5+$G24*0.2, SUM(F24:G24)))), 0),\"Not required\")","v":96951.620196348813},0,2,1,null,null,null,38115,"Ngoma"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"West","Ngororero",389275,46804.142161034099,120130.63154665417,211008.67424266197,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H25>0,IF($H25=4,\"Unknown\",IF($H25=99,\"Stopped\",$D25)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I25>1, $I25<5), IF($I25=4, \"Unknown\", E25+F25), 0),\"Not required\")","v":166934.77370768826},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J25>0,$J25<5), IF($J25=4,\"Unknown\", IF($J25=1, $F25*0.33, IF($J25=2, $F25*0.5+$G25*0.2, SUM(F25:G25)))), 0),\"Not required\")","v":102267.05062185948},0,2,1,null,null,null,38136,"Ngororero"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"West","Nyabihu",343815,40649.106606177964,108512.44560123778,184987.8834535387,0,3,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H26>0,IF($H26=4,\"Unknown\",IF($H26=99,\"Stopped\",$D26)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I26>1, $I26<5), IF($I26=4, \"Unknown\", E26+F26), 0),\"Not required\")","v":149161.55220741575},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J26>0,$J26<5), IF($J26=4,\"Unknown\", IF($J26=1, $F26*0.33, IF($J26=2, $F26*0.5+$G26*0.2, SUM(F26:G26)))), 0),\"Not required\")","v":35809.10704840847},0,2,0,null,null,null,38137,"Nyabihu"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"East","Nyagatare",543420,68059.803778585367,167699.35651043433,291840.43860257405,0,2,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H27>0,IF($H27=4,\"Unknown\",IF($H27=99,\"Stopped\",$D27)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I27>1, $I27<5), IF($I27=4, \"Unknown\", E27+F27), 0),\"Not required\")","v":235759.1602890197},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J27>0,$J27<5), IF($J27=4,\"Unknown\", IF($J27=1, $F27*0.33, IF($J27=2, $F27*0.5+$G27*0.2, SUM(F27:G27)))), 0),\"Not required\")","v":142217.76597573198},0,2,1,null,null,null,38116,"Nyagatare"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"South","Nyamagabe",398348,53995.275679296938,116915.39031384958,261497.78138899177,0,3,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H28>0,IF($H28=4,\"Unknown\",IF($H28=99,\"Stopped\",$D28)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I28>1, $I28<5), IF($I28=4, \"Unknown\", E28+F28), 0),\"Not required\")","v":170910.66599314651},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J28>0,$J28<5), IF($J28=4,\"Unknown\", IF($J28=1, $F28*0.33, IF($J28=2, $F28*0.5+$G28*0.2, SUM(F28:G28)))), 0),\"Not required\")","v":38582.078803570366},0,2,0,null,null,null,38130,"Nyamagabe"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"West","Nyamasheke",445375,44702.025662768436,122531.44534348132,211137.2462107545,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H29>0,IF($H29=4,\"Unknown\",IF($H29=99,\"Stopped\",$D29)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I29>1, $I29<5), IF($I29=4, \"Unknown\", E29+F29), 0),\"Not required\")","v":167233.47100624975},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J29>0,$J29<5), IF($J29=4,\"Unknown\", IF($J29=1, $F29*0.33, IF($J29=2, $F29*0.5+$G29*0.2, SUM(F29:G29)))), 0),\"Not required\")","v":103493.17191389157},0,2,1,null,null,null,38138,"Nyamasheke"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"South","Nyanza",377617,45402.456890285335,100263.75896604679,221336.97734014105,0,1,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H30>0,IF($H30=4,\"Unknown\",IF($H30=99,\"Stopped\",$D30)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I30>1, $I30<5), IF($I30=4, \"Unknown\", E30+F30), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J30>0,$J30<5), IF($J30=4,\"Unknown\", IF($J30=1, $F30*0.33, IF($J30=2, $F30*0.5+$G30*0.2, SUM(F30:G30)))), 0),\"Not required\")","v":94399.274951051601},0,2,1,null,null,null,38131,"Nyanza"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"Kigali","Nyarugenge",331940,34589.050165325345,72836.557559675493,215848.97651246301,0,1,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H31>0,IF($H31=4,\"Unknown\",IF($H31=99,\"Stopped\",$D31)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I31>1, $I31<5), IF($I31=4, \"Unknown\", E31+F31), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J31>0,$J31<5), IF($J31=4,\"Unknown\", IF($J31=1, $F31*0.33, IF($J31=2, $F31*0.5+$G31*0.2, SUM(F31:G31)))), 0),\"Not required\")","v":24036.063994692915},0,2,1,null,null,null,38120,"Nyarugenge"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"South","Nyaruguru",343340,40249.103629032012,110083.01847256621,183701.03707609486,0,3,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H32>0,IF($H32=4,\"Unknown\",IF($H32=99,\"Stopped\",$D32)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I32>1, $I32<5), IF($I32=4, \"Unknown\", E32+F32), 0),\"Not required\")","v":150332.12210159822},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J32>0,$J32<5), IF($J32=4,\"Unknown\", IF($J32=1, $F32*0.33, IF($J32=2, $F32*0.5+$G32*0.2, SUM(F32:G32)))), 0),\"Not required\")","v":36327.396095946853},0,2,0,null,null,null,38132,"Nyaruguru"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"West","Rubavu",470870,60388.988567644948,127383.02275987607,268447.92574210919,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H33>0,IF($H33=4,\"Unknown\",IF($H33=99,\"Stopped\",$D33)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I33>1, $I33<5), IF($I33=4, \"Unknown\", E33+F33), 0),\"Not required\")","v":187772.011327521},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J33>0,$J33<5), IF($J33=4,\"Unknown\", IF($J33=1, $F33*0.33, IF($J33=2, $F33*0.5+$G33*0.2, SUM(F33:G33)))), 0),\"Not required\")","v":117381.09652835988},0,2,1,null,null,null,38139,"Rubavu"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"South","Ruhango",373145,43369.237182877623,107301.47475418862,203012.8947439875,0,1,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H34>0,IF($H34=4,\"Unknown\",IF($H34=99,\"Stopped\",$D34)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I34>1, $I34<5), IF($I34=4, \"Unknown\", E34+F34), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J34>0,$J34<5), IF($J34=4,\"Unknown\", IF($J34=1, $F34*0.33, IF($J34=2, $F34*0.5+$G34*0.2, SUM(F34:G34)))), 0),\"Not required\")","v":35409.486668882244},0,2,1,null,null,null,38133,"Ruhango"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"North","Rulindo",335579,35304.526998947869,96835.274054257025,194679.24887991254,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H35>0,IF($H35=4,\"Unknown\",IF($H35=99,\"Stopped\",$D35)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I35>1, $I35<5), IF($I35=4, \"Unknown\", E35+F35), 0),\"Not required\")","v":132139.80105320489},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J35>0,$J35<5), IF($J35=4,\"Unknown\", IF($J35=1, $F35*0.33, IF($J35=2, $F35*0.5+$G35*0.2, SUM(F35:G35)))), 0),\"Not required\")","v":87353.486803111024},0,2,1,null,null,null,38125,"Rulindo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"West","Rusizi",467601,57626.943477921137,133994.35637955647,262366.57193199871,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H36>0,IF($H36=4,\"Unknown\",IF($H36=99,\"Stopped\",$D36)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I36>1, $I36<5), IF($I36=4, \"Unknown\", E36+F36), 0),\"Not required\")","v":191621.2998574776},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J36>0,$J36<5), IF($J36=4,\"Unknown\", IF($J36=1, $F36*0.33, IF($J36=2, $F36*0.5+$G36*0.2, SUM(F36:G36)))), 0),\"Not required\")","v":119470.49257617799},0,2,1,null,null,null,38140,"Rusizi"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"West","Rutsiro",378709,44015.806706691321,118387.342176618,204901.1691518389,0,3,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H37>0,IF($H37=4,\"Unknown\",IF($H37=99,\"Stopped\",$D37)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I37>1, $I37<5), IF($I37=4, \"Unknown\", E37+F37), 0),\"Not required\")","v":162403.14888330933},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J37>0,$J37<5), IF($J37=4,\"Unknown\", IF($J37=1, $F37*0.33, IF($J37=2, $F37*0.5+$G37*0.2, SUM(F37:G37)))), 0),\"Not required\")","v":100173.90491867678},0,2,1,null,null,null,38141,"Rutsiro"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Rwanda"},"East","Rwamagana",365651,44696.473994237269,98552.061511883818,211392.3401202861,0,1,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H38>0,IF($H38=4,\"Unknown\",IF($H38=99,\"Stopped\",$D38)),0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF(AND($I38>1, $I38<5), IF($I38=4, \"Unknown\", E38+F38), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF(AND($J38>0,$J38<5), IF($J38=4,\"Unknown\", IF($J38=1, $F38*0.33, IF($J38=2, $F38*0.5+$G38*0.2, SUM(F38:G38)))), 0),\"Not required\")","v":91554.498779999121},0,2,1,null,null,null,38117,"Rwamagana"]

{"sheet":"DEC","index":2,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,0,3,2],[5,0,5,2],[6,5,7,5],[6,2,7,2],[6,1,7,1],[6,10,7,10],[6,0,7,0],[6,11,7,11],[5,3,5,6],[5,9,5,12],[6,4,7,4],[6,3,7,3],[6,8,7,8],[6,12,7,12],[6,7,7,7],[6,6,7,6],[6,9,7,9]]}
["Diethylcarbamazine citrate (DEC)"]
["Administrative structure, eligible population by age group, treatment plan and information about tablets"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":0},{"$f":"SUM(E$9:E$1000)","v":0},{"$f":"SUM(F$9:F$1000)","v":0},{"$f":"SUM(G$9:G$1000)","v":0},null,{"$f":"SUM(I$9:I$1000)","v":0},{"$f":"SUM(J$9:J$1000)","v":0},{"$f":"SUM(K$9:K$1000)","v":0},{"$f":"SUM(L$9:L$1000)","v":0},{"$f":"SUM(M$9:M$1000)","v":0}]
[]
["Country administrative structure",null,null,"Population requiring treatment with DEC",null,null,null,"Treatment plan","Target population","Diethylcarbamazine citrate (DEC)"]
["Country","Province/State","District","PreSAC","SAC","Adults","Total","LF","LF","Total required","Remaining in stock","Tablets to be procured","Bottle (100 mg)\n1000 tablets"]
[]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H9=1,COUNTRY_INFO!E9,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H9=1,COUNTRY_INFO!F9,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H9=1,COUNTRY_INFO!G9,0))","v":0},{"$f":"SUM(D9:F9)","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N9)","v":"Not required"},{"$f":"IF(H9=1,G9,0)","v":0},{"$f":"IF(I9>0,I9*2.5,0)","v":0},null,{"$f":"IF($J9>$K9,$J9-$K9,0)","v":0},{"$f":"ROUNDUP($J9/1000,0)","v":0}]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!E10,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!F10,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!G10,0))","v":0},{"$f":"SUM(D10:F10)","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N10)","v":"Not required"},{"$f":"IF(H10=1,G10,0)","v":0},{"$f":"IF(I10>0,I10*2.5,0)","v":0},null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!E11,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!F11,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!G11,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N11)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!E12,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!F12,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!G12,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N12)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!E13,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!F13,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!G13,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N13)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!E14,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!F14,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!G14,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N14)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!E15,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!F15,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!G15,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N15)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!E16,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!F16,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!G16,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N16)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!E17,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!F17,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!G17,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N17)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!E18,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!F18,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!G18,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N18)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!E19,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!F19,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!G19,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N19)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!E20,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!F20,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!G20,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N20)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!E21,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!F21,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!G21,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N21)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!E22,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!F22,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!G22,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N22)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!E23,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!F23,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!G23,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N23)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!E24,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!F24,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!G24,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N24)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H25=1,COUNTRY_INFO!E25,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H25=1,COUNTRY_INFO!F25,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H25=1,COUNTRY_INFO!G25,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N25)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H26=1,COUNTRY_INFO!E26,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H26=1,COUNTRY_INFO!F26,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H26=1,COUNTRY_INFO!G26,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N26)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H27=1,COUNTRY_INFO!E27,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H27=1,COUNTRY_INFO!F27,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H27=1,COUNTRY_INFO!G27,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N27)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H28=1,COUNTRY_INFO!E28,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H28=1,COUNTRY_INFO!F28,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H28=1,COUNTRY_INFO!G28,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N28)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H29=1,COUNTRY_INFO!E29,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H29=1,COUNTRY_INFO!F29,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H29=1,COUNTRY_INFO!G29,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N29)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H30=1,COUNTRY_INFO!E30,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H30=1,COUNTRY_INFO!F30,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H30=1,COUNTRY_INFO!G30,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N30)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H31=1,COUNTRY_INFO!E31,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H31=1,COUNTRY_INFO!F31,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H31=1,COUNTRY_INFO!G31,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N31)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H32=1,COUNTRY_INFO!E32,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H32=1,COUNTRY_INFO!F32,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H32=1,COUNTRY_INFO!G32,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N32)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H33=1,COUNTRY_INFO!E33,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H33=1,COUNTRY_INFO!F33,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H33=1,COUNTRY_INFO!G33,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N33)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H34=1,COUNTRY_INFO!E34,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H34=1,COUNTRY_INFO!F34,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H34=1,COUNTRY_INFO!G34,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N34)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H35=1,COUNTRY_INFO!E35,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H35=1,COUNTRY_INFO!F35,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H35=1,COUNTRY_INFO!G35,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N35)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H36=1,COUNTRY_INFO!E36,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H36=1,COUNTRY_INFO!F36,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H36=1,COUNTRY_INFO!G36,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N36)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H37=1,COUNTRY_INFO!E37,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H37=1,COUNTRY_INFO!F37,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H37=1,COUNTRY_INFO!G37,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N37)","v":"Not required"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38))","v":" "},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H38=1,COUNTRY_INFO!E38,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H38=1,COUNTRY_INFO!F38,0))","v":0},{"$f":"IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H38=1,COUNTRY_INFO!G38,0))","v":0},0,{"$f":"IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!N38)","v":"Not required"},0,0,null,0,0]

{"sheet":"ALB_MBD","index":3,"n_rows":38,"n_cols":27,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,14,6,17],[5,9,7,9],[6,10,6,13],[5,10,5,17],[5,8,7,8],[3,6,3,7],[5,0,5,2],[5,6,5,7],[5,3,5,5],[6,23,7,23],[5,18,5,23],[6,21,7,21],[6,18,7,18],[6,19,7,19],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[3,0,3,2],[6,20,7,20],[6,4,7,4],[6,26,7,26],[5,24,5,26],[6,24,7,24],[6,25,7,25],[6,22,7,22]]}
["Albendazole (ALB) and Mebendazole (MBD)"]
["Administrative structure, eligible population by age group, treatment plan and information about tablets"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":1457145.1221686804},{"$f":"SUM(E$9:E$1000)","v":3523503.6015928993},{"$f":"SUM(F$9:F$1000)","v":4980648.723761579},null,null,{"$f":"SUM(I$9:I$1000)","v":0},null,{"$f":"SUM(K$9:K$1000)","v":2914290.2443373608},{"$f":"SUM(L$9:L$1000)","v":7047007.2031857986},{"$f":"SUM(M$9:M$1000)","v":0},{"$f":"SUM(N$9:N$1000)","v":9961297.447523158},{"$f":"SUM(O$9:O$1000)","v":0},{"$f":"SUM(P$9:P$1000)","v":0},0,0,0,0,0,0,7047007.2031857986,35250,0,0,0]
[]
["Country administrative structure",null,null,"Population requiring treatment with ALB/MBD",null,null,"Treatment plan",null,"People covered by PELF with ALB","Select medicine for treatment of STH","Target population",null,null,null,null,null,null,null,"Albendazole (ALB)",null,null,null,null,null,"Mebendazole (MBD)"]
["Country","Province/State","District","PreSAC","SAC","Total","LF","STH",null,null,"STH (ALB)",null,null,null,"STH (MBD)",null,null,null,"Remaining in stock (LF)","Tablets to be procured (LF)","Bottle (400 mg)\n200 tablets (LF)","Remaining in stock (STH)","Tablets to be procured for SAC (STH)","Bottle (400 mg)\n200 tablets (STH)","Remaining in stock","Tablets to be procured for SAC","Bottles (500 mg)\n150 tablets"]
[null,null,null,null,null,null,null,null,null,null,"PreSAC","SAC","Other","Total","PreSAC","SAC","Other","Total"]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9))","v":"East"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9))","v":"Bugesera"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H9=0,COUNTRY_INFO!$H9=4,COUNTRY_INFO!$H9=99),OR(COUNTRY_INFO!$I9=0,COUNTRY_INFO!$I9=4)),0,COUNTRY_INFO!$E9))","v":55835.348747802273},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H9=0,COUNTRY_INFO!$H9=4,COUNTRY_INFO!$H9=99),OR(COUNTRY_INFO!$I9=0,COUNTRY_INFO!$I9=4)),0,COUNTRY_INFO!$F9))","v":119707.60375475789},{"$f":"SUM(D9:E9)","v":175542.95250256016},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N9)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O9)","v":2},{"$f":"IF($G9=1,DEC!I9,0)","v":0},"ALB",{"$f":"IF($J9=\"ALB\", IF($H9<>0, IF($I9=0, $D9*$H9, $D9*($H9-$G9)),0),0)","v":111670.69749560455},{"$f":"IF($J9=\"ALB\", IF($H9<>0, IF($I9=0, $E9*$H9, $E9*($H9-$G9)),0), 0)","v":239415.20750951578},null,{"$f":"SUM(K9:M9)","v":351085.90500512032},{"$f":"IF($J9=\"MBD\", IF($H9<>0, IF($I9=0, $D9*$H9, $D9*($H9-$G9)),0),0)","v":0},{"$f":"IF($J9=\"MBD\", IF($H9<>0,IF($I9=0, $E9*$H9, $E9*($H9-$G9)),0), 0 )","v":0},null,{"$f":"SUM(O9:Q9)","v":0},null,{"$f":"IF($I9>$S9, $I9-$S9,0)","v":0},{"$f":"ROUNDUP($I9/200,0)","v":0},null,{"$f":"IF($L9>$V9,$L9-$V9,0)","v":239415.20750951578},{"$f":"ROUNDUP($L9/200,0)","v":1198},null,{"$f":"IF($P9>$Y9,$P9-$Y9,0)","v":0},{"$f":"ROUNDUP($P9/150,0)","v":0}]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"North"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Burera"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H10=0,COUNTRY_INFO!$H10=4,COUNTRY_INFO!$H10=99),OR(COUNTRY_INFO!$I10=0,COUNTRY_INFO!$I10=4)),0,COUNTRY_INFO!$E10))","v":42485.87438655569},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H10=0,COUNTRY_INFO!$H10=4,COUNTRY_INFO!$H10=99),OR(COUNTRY_INFO!$I10=0,COUNTRY_INFO!$I10=4)),0,COUNTRY_INFO!$F10))","v":127851.01088546851},{"$f":"SUM(D10:E10)","v":170336.8852720242},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N10)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O10)","v":2},{"$f":"IF($G10=1,DEC!I10,0)","v":0},"ALB",84971.74877311138,255702.02177093702,null,{"$f":"SUM(K10:M10)","v":340673.7705440484},0,0,null,{"$f":"SUM(O10:Q10)","v":0},null,0,0,null,255702.02177093702,1279,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"North"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Gakenke"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H11=0,COUNTRY_INFO!$H11=4,COUNTRY_INFO!$H11=99),OR(COUNTRY_INFO!$I11=0,COUNTRY_INFO!$I11=4)),0,COUNTRY_INFO!$E11))","v":41508.446456186306},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H11=0,COUNTRY_INFO!$H11=4,COUNTRY_INFO!$H11=99),OR(COUNTRY_INFO!$I11=0,COUNTRY_INFO!$I11=4)),0,COUNTRY_INFO!$F11))","v":116223.65007732168},157732.09653350798,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N11)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O11)","v":2},{"$f":"IF($G11=1,DEC!I11,0)","v":0},"ALB",83016.892912372612,232447.30015464337,null,315464.19306701596,0,0,null,0,null,0,0,null,232447.30015464337,1163,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Kigali"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"Gasabo"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H12=0,COUNTRY_INFO!$H12=4,COUNTRY_INFO!$H12=99),OR(COUNTRY_INFO!$I12=0,COUNTRY_INFO!$I12=4)),0,COUNTRY_INFO!$E12))","v":69939.795096988237},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H12=0,COUNTRY_INFO!$H12=4,COUNTRY_INFO!$H12=99),OR(COUNTRY_INFO!$I12=0,COUNTRY_INFO!$I12=4)),0,COUNTRY_INFO!$F12))","v":134928.10027560566},204867.89537259389,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N12)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O12)","v":2},{"$f":"IF($G12=1,DEC!I12,0)","v":0},"ALB",139879.59019397647,269856.20055121131,null,409735.79074518778,0,0,null,0,null,0,0,null,269856.20055121131,1350,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"East"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Gatsibo"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H13=0,COUNTRY_INFO!$H13=4,COUNTRY_INFO!$H13=99),OR(COUNTRY_INFO!$I13=0,COUNTRY_INFO!$I13=4)),0,COUNTRY_INFO!$E13))","v":62756.622087012933},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H13=0,COUNTRY_INFO!$H13=4,COUNTRY_INFO!$H13=99),OR(COUNTRY_INFO!$I13=0,COUNTRY_INFO!$I13=4)),0,COUNTRY_INFO!$F13))","v":155373.24984445944},218129.87193147239,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N13)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O13)","v":2},{"$f":"IF($G13=1,DEC!I13,0)","v":0},"ALB",125513.24417402587,310746.49968891888,null,436259.74386294477,0,0,null,0,null,0,0,null,310746.49968891888,1554,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"North"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Gicumbi"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H14=0,COUNTRY_INFO!$H14=4,COUNTRY_INFO!$H14=99),OR(COUNTRY_INFO!$I14=0,COUNTRY_INFO!$I14=4)),0,COUNTRY_INFO!$E14))","v":48549.201052366239},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H14=0,COUNTRY_INFO!$H14=4,COUNTRY_INFO!$H14=99),OR(COUNTRY_INFO!$I14=0,COUNTRY_INFO!$I14=4)),0,COUNTRY_INFO!$F14))","v":142873.36309696344},191422.56414932967,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N14)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O14)","v":2},{"$f":"IF($G14=1,DEC!I14,0)","v":0},"ALB",97098.402104732479,285746.72619392688,null,382845.12829865934,0,0,null,0,null,0,0,null,285746.72619392688,1429,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"South"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Gisagara"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H15=0,COUNTRY_INFO!$H15=4,COUNTRY_INFO!$H15=99),OR(COUNTRY_INFO!$I15=0,COUNTRY_INFO!$I15=4)),0,COUNTRY_INFO!$E15))","v":49755.563430148373},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H15=0,COUNTRY_INFO!$H15=4,COUNTRY_INFO!$H15=99),OR(COUNTRY_INFO!$I15=0,COUNTRY_INFO!$I15=4)),0,COUNTRY_INFO!$F15))","v":107803.72076532149},157559.28419546987,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N15)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O15)","v":2},{"$f":"IF($G15=1,DEC!I15,0)","v":0},"ALB",99511.126860296747,215607.44153064297,null,315118.56839093973,0,0,null,0,null,0,0,null,215607.44153064297,1079,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"South"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Huye"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H16=0,COUNTRY_INFO!$H16=4,COUNTRY_INFO!$H16=99),OR(COUNTRY_INFO!$I16=0,COUNTRY_INFO!$I16=4)),0,COUNTRY_INFO!$E16))","v":43371.941722031544},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H16=0,COUNTRY_INFO!$H16=4,COUNTRY_INFO!$H16=99),OR(COUNTRY_INFO!$I16=0,COUNTRY_INFO!$I16=4)),0,COUNTRY_INFO!$F16))","v":100945.31568933008},144317.25741136161,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N16)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O16)","v":2},{"$f":"IF($G16=1,DEC!I16,0)","v":0},"ALB",86743.883444063089,201890.63137866015,null,288634.51482272323,0,0,null,0,null,0,0,null,201890.63137866015,1010,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"South"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Kamonyi"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H17=0,COUNTRY_INFO!$H17=4,COUNTRY_INFO!$H17=99),OR(COUNTRY_INFO!$I17=0,COUNTRY_INFO!$I17=4)),0,COUNTRY_INFO!$E17))","v":45368.368476731666},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H17=0,COUNTRY_INFO!$H17=4,COUNTRY_INFO!$H17=99),OR(COUNTRY_INFO!$I17=0,COUNTRY_INFO!$I17=4)),0,COUNTRY_INFO!$F17))","v":111431.08046916551},156799.44894589717,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N17)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O17)","v":2},{"$f":"IF($G17=1,DEC!I17,0)","v":0},"ALB",90736.736953463333,222862.16093833101,null,313598.89789179433,0,0,null,0,null,0,0,null,222862.16093833101,1115,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"West"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Karongi"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H18=0,COUNTRY_INFO!$H18=4,COUNTRY_INFO!$H18=99),OR(COUNTRY_INFO!$I18=0,COUNTRY_INFO!$I18=4)),0,COUNTRY_INFO!$E18))","v":44985.728781206562},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H18=0,COUNTRY_INFO!$H18=4,COUNTRY_INFO!$H18=99),OR(COUNTRY_INFO!$I18=0,COUNTRY_INFO!$I18=4)),0,COUNTRY_INFO!$F18))","v":115178.97800015815},160164.70678136472,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N18)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O18)","v":2},{"$f":"IF($G18=1,DEC!I18,0)","v":0},"ALB",89971.457562413125,230357.95600031631,null,320329.41356272943,0,0,null,0,null,0,0,null,230357.95600031631,1152,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"East"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Kayonza"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H19=0,COUNTRY_INFO!$H19=4,COUNTRY_INFO!$H19=99),OR(COUNTRY_INFO!$I19=0,COUNTRY_INFO!$I19=4)),0,COUNTRY_INFO!$E19))","v":50280.147017905991},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H19=0,COUNTRY_INFO!$H19=4,COUNTRY_INFO!$H19=99),OR(COUNTRY_INFO!$I19=0,COUNTRY_INFO!$I19=4)),0,COUNTRY_INFO!$F19))","v":120672.35284297439},170952.49986088037,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N19)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O19)","v":2},{"$f":"IF($G19=1,DEC!I19,0)","v":0},"ALB",100560.29403581198,241344.70568594878,null,341904.99972176075,0,0,null,0,null,0,0,null,241344.70568594878,1207,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Kigali"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Kicukiro"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H20=0,COUNTRY_INFO!$H20=4,COUNTRY_INFO!$H20=99),OR(COUNTRY_INFO!$I20=0,COUNTRY_INFO!$I20=4)),0,COUNTRY_INFO!$E20))","v":43562.467973387225},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H20=0,COUNTRY_INFO!$H20=4,COUNTRY_INFO!$H20=99),OR(COUNTRY_INFO!$I20=0,COUNTRY_INFO!$I20=4)),0,COUNTRY_INFO!$F20))","v":106858.36160993276},150420.82958331998,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N20)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O20)","v":2},{"$f":"IF($G20=1,DEC!I20,0)","v":0},"ALB",87124.935946774451,213716.72321986553,null,300841.65916663996,0,0,null,0,null,0,0,null,213716.72321986553,1069,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"East"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Kirehe"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H21=0,COUNTRY_INFO!$H21=4,COUNTRY_INFO!$H21=99),OR(COUNTRY_INFO!$I21=0,COUNTRY_INFO!$I21=4)),0,COUNTRY_INFO!$E21))","v":49726.587226732656},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H21=0,COUNTRY_INFO!$H21=4,COUNTRY_INFO!$H21=99),OR(COUNTRY_INFO!$I21=0,COUNTRY_INFO!$I21=4)),0,COUNTRY_INFO!$F21))","v":120139.43473978608},169866.02196651875,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N21)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O21)","v":2},{"$f":"IF($G21=1,DEC!I21,0)","v":0},"ALB",99453.174453465312,240278.86947957217,null,339732.04393303749,0,0,null,0,null,0,0,null,240278.86947957217,1202,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"South"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"Muhanga"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H22=0,COUNTRY_INFO!$H22=4,COUNTRY_INFO!$H22=99),OR(COUNTRY_INFO!$I22=0,COUNTRY_INFO!$I22=4)),0,COUNTRY_INFO!$E22))","v":38419.326275914282},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H22=0,COUNTRY_INFO!$H22=4,COUNTRY_INFO!$H22=99),OR(COUNTRY_INFO!$I22=0,COUNTRY_INFO!$I22=4)),0,COUNTRY_INFO!$F22))","v":104067.88379592312},142487.21007183741,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N22)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O22)","v":2},{"$f":"IF($G22=1,DEC!I22,0)","v":0},"ALB",76838.652551828563,208135.76759184623,null,284974.42014367483,0,0,null,0,null,0,0,null,208135.76759184623,1041,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"North"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Musanze"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H23=0,COUNTRY_INFO!$H23=4,COUNTRY_INFO!$H23=99),OR(COUNTRY_INFO!$I23=0,COUNTRY_INFO!$I23=4)),0,COUNTRY_INFO!$E23))","v":47346.230451863565},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H23=0,COUNTRY_INFO!$H23=4,COUNTRY_INFO!$H23=99),OR(COUNTRY_INFO!$I23=0,COUNTRY_INFO!$I23=4)),0,COUNTRY_INFO!$F23))","v":126973.98166636137},174320.21211822494,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N23)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O23)","v":2},{"$f":"IF($G23=1,DEC!I23,0)","v":0},"ALB",94692.460903727129,253947.96333272275,null,348640.42423644988,0,0,null,0,null,0,0,null,253947.96333272275,1270,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"East"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"Ngoma"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H24=0,COUNTRY_INFO!$H24=4,COUNTRY_INFO!$H24=99),OR(COUNTRY_INFO!$I24=0,COUNTRY_INFO!$I24=4)),0,COUNTRY_INFO!$E24))","v":63400.531485020947},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H24=0,COUNTRY_INFO!$H24=4,COUNTRY_INFO!$H24=99),OR(COUNTRY_INFO!$I24=0,COUNTRY_INFO!$I24=4)),0,COUNTRY_INFO!$F24))","v":111049.37812904293},174449.90961406389,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N24)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O24)","v":2},{"$f":"IF($G24=1,DEC!I24,0)","v":0},"ALB",126801.06297004189,222098.75625808586,null,348899.81922812777,0,0,null,0,null,0,0,null,222098.75625808586,1111,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":"West"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":"Ngororero"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H25=0,COUNTRY_INFO!$H25=4,COUNTRY_INFO!$H25=99),OR(COUNTRY_INFO!$I25=0,COUNTRY_INFO!$I25=4)),0,COUNTRY_INFO!$E25))","v":46804.142161034099},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H25=0,COUNTRY_INFO!$H25=4,COUNTRY_INFO!$H25=99),OR(COUNTRY_INFO!$I25=0,COUNTRY_INFO!$I25=4)),0,COUNTRY_INFO!$F25))","v":120130.63154665417},166934.77370768826,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N25)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O25)","v":2},{"$f":"IF($G25=1,DEC!I25,0)","v":0},"ALB",93608.284322068197,240261.26309330834,null,333869.54741537652,0,0,null,0,null,0,0,null,240261.26309330834,1202,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":"West"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":"Nyabihu"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H26=0,COUNTRY_INFO!$H26=4,COUNTRY_INFO!$H26=99),OR(COUNTRY_INFO!$I26=0,COUNTRY_INFO!$I26=4)),0,COUNTRY_INFO!$E26))","v":40649.106606177964},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H26=0,COUNTRY_INFO!$H26=4,COUNTRY_INFO!$H26=99),OR(COUNTRY_INFO!$I26=0,COUNTRY_INFO!$I26=4)),0,COUNTRY_INFO!$F26))","v":108512.44560123778},149161.55220741575,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N26)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O26)","v":2},{"$f":"IF($G26=1,DEC!I26,0)","v":0},"ALB",81298.213212355928,217024.89120247556,null,298323.1044148315,0,0,null,0,null,0,0,null,217024.89120247556,1086,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":"East"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":"Nyagatare"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H27=0,COUNTRY_INFO!$H27=4,COUNTRY_INFO!$H27=99),OR(COUNTRY_INFO!$I27=0,COUNTRY_INFO!$I27=4)),0,COUNTRY_INFO!$E27))","v":68059.803778585367},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H27=0,COUNTRY_INFO!$H27=4,COUNTRY_INFO!$H27=99),OR(COUNTRY_INFO!$I27=0,COUNTRY_INFO!$I27=4)),0,COUNTRY_INFO!$F27))","v":167699.35651043433},235759.1602890197,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N27)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O27)","v":2},{"$f":"IF($G27=1,DEC!I27,0)","v":0},"ALB",136119.60755717073,335398.71302086866,null,471518.32057803939,0,0,null,0,null,0,0,null,335398.71302086866,1677,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28))","v":"South"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28))","v":"Nyamagabe"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H28=0,COUNTRY_INFO!$H28=4,COUNTRY_INFO!$H28=99),OR(COUNTRY_INFO!$I28=0,COUNTRY_INFO!$I28=4)),0,COUNTRY_INFO!$E28))","v":53995.275679296938},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H28=0,COUNTRY_INFO!$H28=4,COUNTRY_INFO!$H28=99),OR(COUNTRY_INFO!$I28=0,COUNTRY_INFO!$I28=4)),0,COUNTRY_INFO!$F28))","v":116915.39031384958},170910.66599314651,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N28)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O28)","v":2},{"$f":"IF($G28=1,DEC!I28,0)","v":0},"ALB",107990.55135859388,233830.78062769916,null,341821.33198629302,0,0,null,0,null,0,0,null,233830.78062769916,1170,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29))","v":"West"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29))","v":"Nyamasheke"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H29=0,COUNTRY_INFO!$H29=4,COUNTRY_INFO!$H29=99),OR(COUNTRY_INFO!$I29=0,COUNTRY_INFO!$I29=4)),0,COUNTRY_INFO!$E29))","v":44702.025662768436},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H29=0,COUNTRY_INFO!$H29=4,COUNTRY_INFO!$H29=99),OR(COUNTRY_INFO!$I29=0,COUNTRY_INFO!$I29=4)),0,COUNTRY_INFO!$F29))","v":122531.44534348132},167233.47100624975,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N29)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O29)","v":2},{"$f":"IF($G29=1,DEC!I29,0)","v":0},"ALB",89404.051325536871,245062.89068696264,null,334466.94201249949,0,0,null,0,null,0,0,null,245062.89068696264,1226,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30))","v":"South"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30))","v":"Nyanza"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H30=0,COUNTRY_INFO!$H30=4,COUNTRY_INFO!$H30=99),OR(COUNTRY_INFO!$I30=0,COUNTRY_INFO!$I30=4)),0,COUNTRY_INFO!$E30))","v":45402.456890285335},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H30=0,COUNTRY_INFO!$H30=4,COUNTRY_INFO!$H30=99),OR(COUNTRY_INFO!$I30=0,COUNTRY_INFO!$I30=4)),0,COUNTRY_INFO!$F30))","v":100263.75896604679},145666.21585633213,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N30)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O30)","v":2},{"$f":"IF($G30=1,DEC!I30,0)","v":0},"ALB",90804.91378057067,200527.51793209359,null,291332.43171266426,0,0,null,0,null,0,0,null,200527.51793209359,1003,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31))","v":"Kigali"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31))","v":"Nyarugenge"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H31=0,COUNTRY_INFO!$H31=4,COUNTRY_INFO!$H31=99),OR(COUNTRY_INFO!$I31=0,COUNTRY_INFO!$I31=4)),0,COUNTRY_INFO!$E31))","v":34589.050165325345},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H31=0,COUNTRY_INFO!$H31=4,COUNTRY_INFO!$H31=99),OR(COUNTRY_INFO!$I31=0,COUNTRY_INFO!$I31=4)),0,COUNTRY_INFO!$F31))","v":72836.557559675493},107425.60772500084,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N31)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O31)","v":2},{"$f":"IF($G31=1,DEC!I31,0)","v":0},"ALB",69178.10033065069,145673.11511935099,null,214851.21545000168,0,0,null,0,null,0,0,null,145673.11511935099,729,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32))","v":"South"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32))","v":"Nyaruguru"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H32=0,COUNTRY_INFO!$H32=4,COUNTRY_INFO!$H32=99),OR(COUNTRY_INFO!$I32=0,COUNTRY_INFO!$I32=4)),0,COUNTRY_INFO!$E32))","v":40249.103629032012},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H32=0,COUNTRY_INFO!$H32=4,COUNTRY_INFO!$H32=99),OR(COUNTRY_INFO!$I32=0,COUNTRY_INFO!$I32=4)),0,COUNTRY_INFO!$F32))","v":110083.01847256621},150332.12210159822,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N32)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O32)","v":2},{"$f":"IF($G32=1,DEC!I32,0)","v":0},"ALB",80498.207258064023,220166.03694513242,null,300664.24420319643,0,0,null,0,null,0,0,null,220166.03694513242,1101,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33))","v":"West"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33))","v":"Rubavu"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H33=0,COUNTRY_INFO!$H33=4,COUNTRY_INFO!$H33=99),OR(COUNTRY_INFO!$I33=0,COUNTRY_INFO!$I33=4)),0,COUNTRY_INFO!$E33))","v":60388.988567644948},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H33=0,COUNTRY_INFO!$H33=4,COUNTRY_INFO!$H33=99),OR(COUNTRY_INFO!$I33=0,COUNTRY_INFO!$I33=4)),0,COUNTRY_INFO!$F33))","v":127383.02275987607},187772.011327521,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N33)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O33)","v":2},{"$f":"IF($G33=1,DEC!I33,0)","v":0},"ALB",120777.9771352899,254766.04551975214,null,375544.022655042,0,0,null,0,null,0,0,null,254766.04551975214,1274,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34))","v":"South"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34))","v":"Ruhango"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H34=0,COUNTRY_INFO!$H34=4,COUNTRY_INFO!$H34=99),OR(COUNTRY_INFO!$I34=0,COUNTRY_INFO!$I34=4)),0,COUNTRY_INFO!$E34))","v":43369.237182877623},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H34=0,COUNTRY_INFO!$H34=4,COUNTRY_INFO!$H34=99),OR(COUNTRY_INFO!$I34=0,COUNTRY_INFO!$I34=4)),0,COUNTRY_INFO!$F34))","v":107301.47475418862},150670.71193706623,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N34)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O34)","v":2},{"$f":"IF($G34=1,DEC!I34,0)","v":0},"ALB",86738.474365755246,214602.94950837723,null,301341.42387413245,0,0,null,0,null,0,0,null,214602.94950837723,1074,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35))","v":"North"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35))","v":"Rulindo"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H35=0,COUNTRY_INFO!$H35=4,COUNTRY_INFO!$H35=99),OR(COUNTRY_INFO!$I35=0,COUNTRY_INFO!$I35=4)),0,COUNTRY_INFO!$E35))","v":35304.526998947869},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H35=0,COUNTRY_INFO!$H35=4,COUNTRY_INFO!$H35=99),OR(COUNTRY_INFO!$I35=0,COUNTRY_INFO!$I35=4)),0,COUNTRY_INFO!$F35))","v":96835.274054257025},132139.80105320489,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N35)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O35)","v":2},{"$f":"IF($G35=1,DEC!I35,0)","v":0},"ALB",70609.053997895739,193670.54810851405,null,264279.60210640979,0,0,null,0,null,0,0,null,193670.54810851405,969,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36))","v":"West"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36))","v":"Rusizi"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H36=0,COUNTRY_INFO!$H36=4,COUNTRY_INFO!$H36=99),OR(COUNTRY_INFO!$I36=0,COUNTRY_INFO!$I36=4)),0,COUNTRY_INFO!$E36))","v":57626.943477921137},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H36=0,COUNTRY_INFO!$H36=4,COUNTRY_INFO!$H36=99),OR(COUNTRY_INFO!$I36=0,COUNTRY_INFO!$I36=4)),0,COUNTRY_INFO!$F36))","v":133994.35637955647},191621.2998574776,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N36)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O36)","v":2},{"$f":"IF($G36=1,DEC!I36,0)","v":0},"ALB",115253.88695584227,267988.71275911294,null,383242.5997149552,0,0,null,0,null,0,0,null,267988.71275911294,1340,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37))","v":"West"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37))","v":"Rutsiro"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H37=0,COUNTRY_INFO!$H37=4,COUNTRY_INFO!$H37=99),OR(COUNTRY_INFO!$I37=0,COUNTRY_INFO!$I37=4)),0,COUNTRY_INFO!$E37))","v":44015.806706691321},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H37=0,COUNTRY_INFO!$H37=4,COUNTRY_INFO!$H37=99),OR(COUNTRY_INFO!$I37=0,COUNTRY_INFO!$I37=4)),0,COUNTRY_INFO!$F37))","v":118387.342176618},162403.14888330933,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N37)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O37)","v":2},{"$f":"IF($G37=1,DEC!I37,0)","v":0},"ALB",88031.613413382642,236774.68435323599,null,324806.29776661866,0,0,null,0,null,0,0,null,236774.68435323599,1184,null,0,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38))","v":"Rwanda"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38))","v":"East"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38))","v":"Rwamagana"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H38=0,COUNTRY_INFO!$H38=4,COUNTRY_INFO!$H38=99),OR(COUNTRY_INFO!$I38=0,COUNTRY_INFO!$I38=4)),0,COUNTRY_INFO!$E38))","v":44696.473994237269},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,IF(AND(OR(COUNTRY_INFO!$H38=0,COUNTRY_INFO!$H38=4,COUNTRY_INFO!$H38=99),OR(COUNTRY_INFO!$I38=0,COUNTRY_INFO!$I38=4)),0,COUNTRY_INFO!$F38))","v":98552.061511883818},143248.53550612109,{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!N38)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!O38)","v":2},{"$f":"IF($G38=1,DEC!I38,0)","v":0},"ALB",89392.947988474538,197104.12302376764,null,286497.07101224217,0,0,null,0,null,0,0,null,197104.12302376764,986,null,0,0]

{"sheet":"PZQ","index":4,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,4,7,4],[6,5,7,5],[6,7,7,7],[6,6,7,6],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[3,0,3,2],[5,0,5,2],[5,3,5,5],[5,8,5,11],[5,6,5,7],[5,12,5,17],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,17,7,17],[6,13,7,13],[6,14,7,14],[6,15,7,15],[6,11,7,11],[6,16,7,16],[6,12,7,12]]}
["Praziquantel (PZQ)"]
["Administrative structure, eligible population by age group, treatment plan and information about tablets"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":1558131.4174583664},{"$f":"SUM(E$9:E$1000)","v":875730.4225001951},{"$f":"SUM(F$9:F$1000)","v":2433861.8399585611},null,null,{"$f":"SUM(I$9:I$1000)","v":1289311.0492436758},1062090,875730.4225001951,1961856.4864948876,2715315.1599867325,2627191.2675005854,2715315.1599867325,0,2715315.1599867325,2729]
[]
["Country administrative structure",null,null,"Population requiring treatment with PZQ",null,null,"Treatment plan",null,"Target population",null,null,null,"Praziquantel (PZQ)"]
["Country","Province/State","District","SAC","Adults","Total","SCH","All SAC targeted?","SAC","SAC\nat lower level","Adults","Total","SAC","Adults","Total required\nfor SAC","Remaining in stock","Tablets to be procured","Bottle (600 mg)\n1000 tablets"]
[]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9))","v":"East"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9))","v":"Bugesera"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J9>0, IF(COUNTRY_INFO!$J9=4, 0, IF(COUNTRY_INFO!$J9=1, COUNTRY_INFO!$F9*0.33, IF(COUNTRY_INFO!$J9=2, COUNTRY_INFO!$F9*0.5, COUNTRY_INFO!$F9))), 0))","v":59853.801877378944},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J9>0, IF(COUNTRY_INFO!$J9=4, 0, IF(COUNTRY_INFO!$J9=1, 0, IF(COUNTRY_INFO!$J9=2, COUNTRY_INFO!$G9*0.2, COUNTRY_INFO!$G9))), 0))","v":46614.05630308947},{"$f":"SUM(D9:E9)","v":106467.85818046841},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P9)","v":1},null,{"$f":"IF($D9=0,0,IF(AND($G9>0,$H9<>\"Yes\"),D9,IF(AND($G9>0,$H9=\"Yes\"),COUNTRY_INFO!$F9,0)))","v":59853.801877378944},64242,{"$f":"IF($G9>0,E9, 0)","v":46614.05630308947},{"$f":"IF($J9=0,SUM(I9,K9),SUM(J9,K9))","v":110856.05630308947},{"$f":"IF($J9=0,$I9*2.5,$J9*2.5)","v":160605},{"$f":"$K9*3","v":139842.1689092684},{"$f":"M9","v":160605},null,{"$f":"IF($O9>$P9,O9-P9,0)","v":160605},{"$f":"ROUNDUP($O9/1000,0)","v":161}]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"North"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Burera"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J10>0, IF(COUNTRY_INFO!$J10=4, 0, IF(COUNTRY_INFO!$J10=1, COUNTRY_INFO!$F10*0.33, IF(COUNTRY_INFO!$J10=2, COUNTRY_INFO!$F10*0.5, COUNTRY_INFO!$F10))), 0))","v":63925.505442734255},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J10>0, IF(COUNTRY_INFO!$J10=4, 0, IF(COUNTRY_INFO!$J10=1, 0, IF(COUNTRY_INFO!$J10=2, COUNTRY_INFO!$G10*0.2, COUNTRY_INFO!$G10))), 0))","v":42407.196841395395},{"$f":"SUM(D10:E10)","v":106332.70228412966},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P10)","v":1},null,{"$f":"IF($D10=0,0,IF(AND($G10>0,$H10<>\"Yes\"),D10,IF(AND($G10>0,$H10=\"Yes\"),COUNTRY_INFO!$F10,0)))","v":63925.505442734255},81432,{"$f":"IF($G10>0,E10, 0)","v":42407.196841395395},{"$f":"IF($J10=0,SUM(I10,K10),SUM(J10,K10))","v":123839.1968413954},203580,127221.59052418618,{"$f":"M10","v":203580},null,{"$f":"IF($O10>$P10,O10-P10,0)","v":203580},204]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"North"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Gakenke"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J11>0, IF(COUNTRY_INFO!$J11=4, 0, IF(COUNTRY_INFO!$J11=1, COUNTRY_INFO!$F11*0.33, IF(COUNTRY_INFO!$J11=2, COUNTRY_INFO!$F11*0.5, COUNTRY_INFO!$F11))), 0))","v":58111.825038660842},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J11>0, IF(COUNTRY_INFO!$J11=4, 0, IF(COUNTRY_INFO!$J11=1, 0, IF(COUNTRY_INFO!$J11=2, COUNTRY_INFO!$G11*0.2, COUNTRY_INFO!$G11))), 0))","v":45540.695540501561},103652.5205791624,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P11)","v":1},null,{"$f":"IF($D11=0,0,IF(AND($G11>0,$H11<>\"Yes\"),D11,IF(AND($G11>0,$H11=\"Yes\"),COUNTRY_INFO!$F11,0)))","v":58111.825038660842},51204,45540.695540501561,96744.695540501561,128010,136622.08662150468,128010,null,128010,129]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Kigali"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"Gasabo"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J12>0, IF(COUNTRY_INFO!$J12=4, 0, IF(COUNTRY_INFO!$J12=1, COUNTRY_INFO!$F12*0.33, IF(COUNTRY_INFO!$J12=2, COUNTRY_INFO!$F12*0.5, COUNTRY_INFO!$F12))), 0))","v":44526.273090949871},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J12>0, IF(COUNTRY_INFO!$J12=4, 0, IF(COUNTRY_INFO!$J12=1, 0, IF(COUNTRY_INFO!$J12=2, COUNTRY_INFO!$G12*0.2, COUNTRY_INFO!$G12))), 0))","v":0},44526.273090949871,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P12)","v":0},null,{"$f":"IF($D12=0,0,IF(AND($G12>0,$H12<>\"Yes\"),D12,IF(AND($G12>0,$H12=\"Yes\"),COUNTRY_INFO!$F12,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"East"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Gatsibo"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J13>0, IF(COUNTRY_INFO!$J13=4, 0, IF(COUNTRY_INFO!$J13=1, COUNTRY_INFO!$F13*0.33, IF(COUNTRY_INFO!$J13=2, COUNTRY_INFO!$F13*0.5, COUNTRY_INFO!$F13))), 0))","v":77686.624922229719},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J13>0, IF(COUNTRY_INFO!$J13=4, 0, IF(COUNTRY_INFO!$J13=1, 0, IF(COUNTRY_INFO!$J13=2, COUNTRY_INFO!$G13*0.2, COUNTRY_INFO!$G13))), 0))","v":54658.99343062417},132345.6183528539,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P13)","v":1},null,{"$f":"IF($D13=0,0,IF(AND($G13>0,$H13<>\"Yes\"),D13,IF(AND($G13>0,$H13=\"Yes\"),COUNTRY_INFO!$F13,0)))","v":77686.624922229719},42018,54658.99343062417,96676.993430624163,105045,163976.98029187252,105045,null,105045,106]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"North"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Gicumbi"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J14>0, IF(COUNTRY_INFO!$J14=4, 0, IF(COUNTRY_INFO!$J14=1, COUNTRY_INFO!$F14*0.33, IF(COUNTRY_INFO!$J14=2, COUNTRY_INFO!$F14*0.5, COUNTRY_INFO!$F14))), 0))","v":71436.68154848172},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J14>0, IF(COUNTRY_INFO!$J14=4, 0, IF(COUNTRY_INFO!$J14=1, 0, IF(COUNTRY_INFO!$J14=2, COUNTRY_INFO!$G14*0.2, COUNTRY_INFO!$G14))), 0))","v":51693.339787186138},123130.02133566786,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P14)","v":1},null,{"$f":"IF($D14=0,0,IF(AND($G14>0,$H14<>\"Yes\"),D14,IF(AND($G14>0,$H14=\"Yes\"),COUNTRY_INFO!$F14,0)))","v":71436.68154848172},18025,51693.339787186138,69718.339787186138,45062.5,155080.01936155843,45062.5,null,45062.5,46]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"South"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Gisagara"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J15>0, IF(COUNTRY_INFO!$J15=4, 0, IF(COUNTRY_INFO!$J15=1, COUNTRY_INFO!$F15*0.33, IF(COUNTRY_INFO!$J15=2, COUNTRY_INFO!$F15*0.5, COUNTRY_INFO!$F15))), 0))","v":53901.860382660743},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J15>0, IF(COUNTRY_INFO!$J15=4, 0, IF(COUNTRY_INFO!$J15=1, 0, IF(COUNTRY_INFO!$J15=2, COUNTRY_INFO!$G15*0.2, COUNTRY_INFO!$G15))), 0))","v":41538.356742442062},95440.217125102805,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P15)","v":1},null,{"$f":"IF($D15=0,0,IF(AND($G15>0,$H15<>\"Yes\"),D15,IF(AND($G15>0,$H15=\"Yes\"),COUNTRY_INFO!$F15,0)))","v":53901.860382660743},72181,41538.356742442062,113719.35674244206,180452.5,124615.07022732618,180452.5,null,180452.5,181]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"South"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Huye"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J16>0, IF(COUNTRY_INFO!$J16=4, 0, IF(COUNTRY_INFO!$J16=1, COUNTRY_INFO!$F16*0.33, IF(COUNTRY_INFO!$J16=2, COUNTRY_INFO!$F16*0.5, COUNTRY_INFO!$F16))), 0))","v":33311.954177478925},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J16>0, IF(COUNTRY_INFO!$J16=4, 0, IF(COUNTRY_INFO!$J16=1, 0, IF(COUNTRY_INFO!$J16=2, COUNTRY_INFO!$G16*0.2, COUNTRY_INFO!$G16))), 0))","v":0},33311.954177478925,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P16)","v":0},null,{"$f":"IF($D16=0,0,IF(AND($G16>0,$H16<>\"Yes\"),D16,IF(AND($G16>0,$H16=\"Yes\"),COUNTRY_INFO!$F16,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"South"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Kamonyi"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J17>0, IF(COUNTRY_INFO!$J17=4, 0, IF(COUNTRY_INFO!$J17=1, COUNTRY_INFO!$F17*0.33, IF(COUNTRY_INFO!$J17=2, COUNTRY_INFO!$F17*0.5, COUNTRY_INFO!$F17))), 0))","v":55715.540234582753},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J17>0, IF(COUNTRY_INFO!$J17=4, 0, IF(COUNTRY_INFO!$J17=1, 0, IF(COUNTRY_INFO!$J17=2, COUNTRY_INFO!$G17*0.2, COUNTRY_INFO!$G17))), 0))","v":43935.683156413827},99651.223390996573,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P17)","v":1},null,{"$f":"IF($D17=0,0,IF(AND($G17>0,$H17<>\"Yes\"),D17,IF(AND($G17>0,$H17=\"Yes\"),COUNTRY_INFO!$F17,0)))","v":55715.540234582753},38949,43935.683156413827,82884.683156413827,97372.5,131807.04946924146,97372.5,null,97372.5,98]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"West"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Karongi"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J18>0, IF(COUNTRY_INFO!$J18=4, 0, IF(COUNTRY_INFO!$J18=1, COUNTRY_INFO!$F18*0.33, IF(COUNTRY_INFO!$J18=2, COUNTRY_INFO!$F18*0.5, COUNTRY_INFO!$F18))), 0))","v":38009.062740052192},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J18>0, IF(COUNTRY_INFO!$J18=4, 0, IF(COUNTRY_INFO!$J18=1, 0, IF(COUNTRY_INFO!$J18=2, COUNTRY_INFO!$G18*0.2, COUNTRY_INFO!$G18))), 0))","v":0},38009.062740052192,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P18)","v":0},null,{"$f":"IF($D18=0,0,IF(AND($G18>0,$H18<>\"Yes\"),D18,IF(AND($G18>0,$H18=\"Yes\"),COUNTRY_INFO!$F18,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"East"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Kayonza"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J19>0, IF(COUNTRY_INFO!$J19=4, 0, IF(COUNTRY_INFO!$J19=1, COUNTRY_INFO!$F19*0.33, IF(COUNTRY_INFO!$J19=2, COUNTRY_INFO!$F19*0.5, COUNTRY_INFO!$F19))), 0))","v":60336.176421487195},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J19>0, IF(COUNTRY_INFO!$J19=4, 0, IF(COUNTRY_INFO!$J19=1, 0, IF(COUNTRY_INFO!$J19=2, COUNTRY_INFO!$G19*0.2, COUNTRY_INFO!$G19))), 0))","v":43683.391729156734},104019.56815064393,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P19)","v":1},null,{"$f":"IF($D19=0,0,IF(AND($G19>0,$H19<>\"Yes\"),D19,IF(AND($G19>0,$H19=\"Yes\"),COUNTRY_INFO!$F19,0)))","v":60336.176421487195},49009,43683.391729156734,92692.391729156734,122522.5,131050.1751874702,122522.5,null,122522.5,123]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Kigali"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Kicukiro"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J20>0, IF(COUNTRY_INFO!$J20=4, 0, IF(COUNTRY_INFO!$J20=1, COUNTRY_INFO!$F20*0.33, IF(COUNTRY_INFO!$J20=2, COUNTRY_INFO!$F20*0.5, COUNTRY_INFO!$F20))), 0))","v":35263.259331277812},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J20>0, IF(COUNTRY_INFO!$J20=4, 0, IF(COUNTRY_INFO!$J20=1, 0, IF(COUNTRY_INFO!$J20=2, COUNTRY_INFO!$G20*0.2, COUNTRY_INFO!$G20))), 0))","v":0},35263.259331277812,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P20)","v":0},null,{"$f":"IF($D20=0,0,IF(AND($G20>0,$H20<>\"Yes\"),D20,IF(AND($G20>0,$H20=\"Yes\"),COUNTRY_INFO!$F20,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"East"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Kirehe"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J21>0, IF(COUNTRY_INFO!$J21=4, 0, IF(COUNTRY_INFO!$J21=1, COUNTRY_INFO!$F21*0.33, IF(COUNTRY_INFO!$J21=2, COUNTRY_INFO!$F21*0.5, COUNTRY_INFO!$F21))), 0))","v":39646.013464129406},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J21>0, IF(COUNTRY_INFO!$J21=4, 0, IF(COUNTRY_INFO!$J21=1, 0, IF(COUNTRY_INFO!$J21=2, COUNTRY_INFO!$G21*0.2, COUNTRY_INFO!$G21))), 0))","v":0},39646.013464129406,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P21)","v":0},null,{"$f":"IF($D21=0,0,IF(AND($G21>0,$H21<>\"Yes\"),D21,IF(AND($G21>0,$H21=\"Yes\"),COUNTRY_INFO!$F21,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"South"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"Muhanga"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J22>0, IF(COUNTRY_INFO!$J22=4, 0, IF(COUNTRY_INFO!$J22=1, COUNTRY_INFO!$F22*0.33, IF(COUNTRY_INFO!$J22=2, COUNTRY_INFO!$F22*0.5, COUNTRY_INFO!$F22))), 0))","v":34342.401652654633},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J22>0, IF(COUNTRY_INFO!$J22=4, 0, IF(COUNTRY_INFO!$J22=1, 0, IF(COUNTRY_INFO!$J22=2, COUNTRY_INFO!$G22*0.2, COUNTRY_INFO!$G22))), 0))","v":0},34342.401652654633,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P22)","v":0},null,{"$f":"IF($D22=0,0,IF(AND($G22>0,$H22<>\"Yes\"),D22,IF(AND($G22>0,$H22=\"Yes\"),COUNTRY_INFO!$F22,0)))","v":0},20597,0,20597,51492.5,0,51492.5,null,51492.5,52]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"North"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Musanze"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J23>0, IF(COUNTRY_INFO!$J23=4, 0, IF(COUNTRY_INFO!$J23=1, COUNTRY_INFO!$F23*0.33, IF(COUNTRY_INFO!$J23=2, COUNTRY_INFO!$F23*0.5, COUNTRY_INFO!$F23))), 0))","v":63486.990833180687},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J23>0, IF(COUNTRY_INFO!$J23=4, 0, IF(COUNTRY_INFO!$J23=1, 0, IF(COUNTRY_INFO!$J23=2, COUNTRY_INFO!$G23*0.2, COUNTRY_INFO!$G23))), 0))","v":48809.659393102978},112296.65022628367,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P23)","v":1},null,{"$f":"IF($D23=0,0,IF(AND($G23>0,$H23<>\"Yes\"),D23,IF(AND($G23>0,$H23=\"Yes\"),COUNTRY_INFO!$F23,0)))","v":63486.990833180687},17752,48809.659393102978,66561.659393102978,44380,146428.97817930894,44380,null,44380,45]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"East"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"Ngoma"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J24>0, IF(COUNTRY_INFO!$J24=4, 0, IF(COUNTRY_INFO!$J24=1, COUNTRY_INFO!$F24*0.33, IF(COUNTRY_INFO!$J24=2, COUNTRY_INFO!$F24*0.5, COUNTRY_INFO!$F24))), 0))","v":55524.689064521466},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J24>0, IF(COUNTRY_INFO!$J24=4, 0, IF(COUNTRY_INFO!$J24=1, 0, IF(COUNTRY_INFO!$J24=2, COUNTRY_INFO!$G24*0.2, COUNTRY_INFO!$G24))), 0))","v":41426.931131827354},96951.620196348813,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P24)","v":1},null,{"$f":"IF($D24=0,0,IF(AND($G24>0,$H24<>\"Yes\"),D24,IF(AND($G24>0,$H24=\"Yes\"),COUNTRY_INFO!$F24,0)))","v":55524.689064521466},39392,41426.931131827354,80818.931131827354,98480,124280.79339548206,98480,null,98480,99]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":"West"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":"Ngororero"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J25>0, IF(COUNTRY_INFO!$J25=4, 0, IF(COUNTRY_INFO!$J25=1, COUNTRY_INFO!$F25*0.33, IF(COUNTRY_INFO!$J25=2, COUNTRY_INFO!$F25*0.5, COUNTRY_INFO!$F25))), 0))","v":60065.315773327085},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J25>0, IF(COUNTRY_INFO!$J25=4, 0, IF(COUNTRY_INFO!$J25=1, 0, IF(COUNTRY_INFO!$J25=2, COUNTRY_INFO!$G25*0.2, COUNTRY_INFO!$G25))), 0))","v":42201.734848532396},102267.05062185948,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P25)","v":1},null,{"$f":"IF($D25=0,0,IF(AND($G25>0,$H25<>\"Yes\"),D25,IF(AND($G25>0,$H25=\"Yes\"),COUNTRY_INFO!$F25,0)))","v":60065.315773327085},8162,42201.734848532396,50363.734848532396,20405,126605.2045455972,20405,null,20405,21]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":"West"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":"Nyabihu"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J26>0, IF(COUNTRY_INFO!$J26=4, 0, IF(COUNTRY_INFO!$J26=1, COUNTRY_INFO!$F26*0.33, IF(COUNTRY_INFO!$J26=2, COUNTRY_INFO!$F26*0.5, COUNTRY_INFO!$F26))), 0))","v":35809.10704840847},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J26>0, IF(COUNTRY_INFO!$J26=4, 0, IF(COUNTRY_INFO!$J26=1, 0, IF(COUNTRY_INFO!$J26=2, COUNTRY_INFO!$G26*0.2, COUNTRY_INFO!$G26))), 0))","v":0},35809.10704840847,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P26)","v":0},null,{"$f":"IF($D26=0,0,IF(AND($G26>0,$H26<>\"Yes\"),D26,IF(AND($G26>0,$H26=\"Yes\"),COUNTRY_INFO!$F26,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":"East"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":"Nyagatare"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J27>0, IF(COUNTRY_INFO!$J27=4, 0, IF(COUNTRY_INFO!$J27=1, COUNTRY_INFO!$F27*0.33, IF(COUNTRY_INFO!$J27=2, COUNTRY_INFO!$F27*0.5, COUNTRY_INFO!$F27))), 0))","v":83849.678255217164},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J27>0, IF(COUNTRY_INFO!$J27=4, 0, IF(COUNTRY_INFO!$J27=1, 0, IF(COUNTRY_INFO!$J27=2, COUNTRY_INFO!$G27*0.2, COUNTRY_INFO!$G27))), 0))","v":58368.087720514814},142217.76597573198,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P27)","v":1},null,{"$f":"IF($D27=0,0,IF(AND($G27>0,$H27<>\"Yes\"),D27,IF(AND($G27>0,$H27=\"Yes\"),COUNTRY_INFO!$F27,0)))","v":83849.678255217164},143442,58368.087720514814,201810.0877205148,358605,175104.26316154446,358605,null,358605,359]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28))","v":"South"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28))","v":"Nyamagabe"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J28>0, IF(COUNTRY_INFO!$J28=4, 0, IF(COUNTRY_INFO!$J28=1, COUNTRY_INFO!$F28*0.33, IF(COUNTRY_INFO!$J28=2, COUNTRY_INFO!$F28*0.5, COUNTRY_INFO!$F28))), 0))","v":38582.078803570366},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J28>0, IF(COUNTRY_INFO!$J28=4, 0, IF(COUNTRY_INFO!$J28=1, 0, IF(COUNTRY_INFO!$J28=2, COUNTRY_INFO!$G28*0.2, COUNTRY_INFO!$G28))), 0))","v":0},38582.078803570366,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P28)","v":0},null,{"$f":"IF($D28=0,0,IF(AND($G28>0,$H28<>\"Yes\"),D28,IF(AND($G28>0,$H28=\"Yes\"),COUNTRY_INFO!$F28,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29))","v":"West"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29))","v":"Nyamasheke"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J29>0, IF(COUNTRY_INFO!$J29=4, 0, IF(COUNTRY_INFO!$J29=1, COUNTRY_INFO!$F29*0.33, IF(COUNTRY_INFO!$J29=2, COUNTRY_INFO!$F29*0.5, COUNTRY_INFO!$F29))), 0))","v":61265.722671740659},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J29>0, IF(COUNTRY_INFO!$J29=4, 0, IF(COUNTRY_INFO!$J29=1, 0, IF(COUNTRY_INFO!$J29=2, COUNTRY_INFO!$G29*0.2, COUNTRY_INFO!$G29))), 0))","v":42227.449242150906},103493.17191389157,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P29)","v":1},null,{"$f":"IF($D29=0,0,IF(AND($G29>0,$H29<>\"Yes\"),D29,IF(AND($G29>0,$H29=\"Yes\"),COUNTRY_INFO!$F29,0)))","v":61265.722671740659},72815,42227.449242150906,115042.44924215091,182037.5,126682.34772645272,182037.5,null,182037.5,183]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30))","v":"South"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30))","v":"Nyanza"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J30>0, IF(COUNTRY_INFO!$J30=4, 0, IF(COUNTRY_INFO!$J30=1, COUNTRY_INFO!$F30*0.33, IF(COUNTRY_INFO!$J30=2, COUNTRY_INFO!$F30*0.5, COUNTRY_INFO!$F30))), 0))","v":50131.879483023396},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J30>0, IF(COUNTRY_INFO!$J30=4, 0, IF(COUNTRY_INFO!$J30=1, 0, IF(COUNTRY_INFO!$J30=2, COUNTRY_INFO!$G30*0.2, COUNTRY_INFO!$G30))), 0))","v":44267.395468028211},94399.274951051601,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P30)","v":1},null,{"$f":"IF($D30=0,0,IF(AND($G30>0,$H30<>\"Yes\"),D30,IF(AND($G30>0,$H30=\"Yes\"),COUNTRY_INFO!$F30,0)))","v":50131.879483023396},46191,44267.395468028211,90458.395468028204,115477.5,132802.18640408464,115477.5,null,115477.5,116]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31))","v":"Kigali"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31))","v":"Nyarugenge"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J31>0, IF(COUNTRY_INFO!$J31=4, 0, IF(COUNTRY_INFO!$J31=1, COUNTRY_INFO!$F31*0.33, IF(COUNTRY_INFO!$J31=2, COUNTRY_INFO!$F31*0.5, COUNTRY_INFO!$F31))), 0))","v":24036.063994692915},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J31>0, IF(COUNTRY_INFO!$J31=4, 0, IF(COUNTRY_INFO!$J31=1, 0, IF(COUNTRY_INFO!$J31=2, COUNTRY_INFO!$G31*0.2, COUNTRY_INFO!$G31))), 0))","v":0},24036.063994692915,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P31)","v":1},null,{"$f":"IF($D31=0,0,IF(AND($G31>0,$H31<>\"Yes\"),D31,IF(AND($G31>0,$H31=\"Yes\"),COUNTRY_INFO!$F31,0)))","v":24036.063994692915},null,0,24036.063994692915,60090.159986732288,0,60090.159986732288,null,60090.159986732288,61]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32))","v":"South"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32))","v":"Nyaruguru"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J32>0, IF(COUNTRY_INFO!$J32=4, 0, IF(COUNTRY_INFO!$J32=1, COUNTRY_INFO!$F32*0.33, IF(COUNTRY_INFO!$J32=2, COUNTRY_INFO!$F32*0.5, COUNTRY_INFO!$F32))), 0))","v":36327.396095946853},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J32>0, IF(COUNTRY_INFO!$J32=4, 0, IF(COUNTRY_INFO!$J32=1, 0, IF(COUNTRY_INFO!$J32=2, COUNTRY_INFO!$G32*0.2, COUNTRY_INFO!$G32))), 0))","v":0},36327.396095946853,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P32)","v":0},null,{"$f":"IF($D32=0,0,IF(AND($G32>0,$H32<>\"Yes\"),D32,IF(AND($G32>0,$H32=\"Yes\"),COUNTRY_INFO!$F32,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33))","v":"West"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33))","v":"Rubavu"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J33>0, IF(COUNTRY_INFO!$J33=4, 0, IF(COUNTRY_INFO!$J33=1, COUNTRY_INFO!$F33*0.33, IF(COUNTRY_INFO!$J33=2, COUNTRY_INFO!$F33*0.5, COUNTRY_INFO!$F33))), 0))","v":63691.511379938034},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J33>0, IF(COUNTRY_INFO!$J33=4, 0, IF(COUNTRY_INFO!$J33=1, 0, IF(COUNTRY_INFO!$J33=2, COUNTRY_INFO!$G33*0.2, COUNTRY_INFO!$G33))), 0))","v":53689.585148421844},117381.09652835988,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P33)","v":1},null,{"$f":"IF($D33=0,0,IF(AND($G33>0,$H33<>\"Yes\"),D33,IF(AND($G33>0,$H33=\"Yes\"),COUNTRY_INFO!$F33,0)))","v":63691.511379938034},42099,53689.585148421844,95788.585148421844,105247.5,161068.75544526553,105247.5,null,105247.5,106]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34))","v":"South"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34))","v":"Ruhango"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J34>0, IF(COUNTRY_INFO!$J34=4, 0, IF(COUNTRY_INFO!$J34=1, COUNTRY_INFO!$F34*0.33, IF(COUNTRY_INFO!$J34=2, COUNTRY_INFO!$F34*0.5, COUNTRY_INFO!$F34))), 0))","v":35409.486668882244},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J34>0, IF(COUNTRY_INFO!$J34=4, 0, IF(COUNTRY_INFO!$J34=1, 0, IF(COUNTRY_INFO!$J34=2, COUNTRY_INFO!$G34*0.2, COUNTRY_INFO!$G34))), 0))","v":0},35409.486668882244,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P34)","v":1},null,{"$f":"IF($D34=0,0,IF(AND($G34>0,$H34<>\"Yes\"),D34,IF(AND($G34>0,$H34=\"Yes\"),COUNTRY_INFO!$F34,0)))","v":35409.486668882244},15686,0,15686,39215,0,39215,null,39215,40]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35))","v":"North"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35))","v":"Rulindo"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J35>0, IF(COUNTRY_INFO!$J35=4, 0, IF(COUNTRY_INFO!$J35=1, COUNTRY_INFO!$F35*0.33, IF(COUNTRY_INFO!$J35=2, COUNTRY_INFO!$F35*0.5, COUNTRY_INFO!$F35))), 0))","v":48417.637027128512},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J35>0, IF(COUNTRY_INFO!$J35=4, 0, IF(COUNTRY_INFO!$J35=1, 0, IF(COUNTRY_INFO!$J35=2, COUNTRY_INFO!$G35*0.2, COUNTRY_INFO!$G35))), 0))","v":38935.849775982511},87353.486803111024,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P35)","v":1},null,{"$f":"IF($D35=0,0,IF(AND($G35>0,$H35<>\"Yes\"),D35,IF(AND($G35>0,$H35=\"Yes\"),COUNTRY_INFO!$F35,0)))","v":48417.637027128512},11092,38935.849775982511,50027.849775982511,27730,116807.54932794753,27730,null,27730,28]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36))","v":"West"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36))","v":"Rusizi"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J36>0, IF(COUNTRY_INFO!$J36=4, 0, IF(COUNTRY_INFO!$J36=1, COUNTRY_INFO!$F36*0.33, IF(COUNTRY_INFO!$J36=2, COUNTRY_INFO!$F36*0.5, COUNTRY_INFO!$F36))), 0))","v":66997.178189778235},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J36>0, IF(COUNTRY_INFO!$J36=4, 0, IF(COUNTRY_INFO!$J36=1, 0, IF(COUNTRY_INFO!$J36=2, COUNTRY_INFO!$G36*0.2, COUNTRY_INFO!$G36))), 0))","v":52473.314386399747},119470.49257617799,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P36)","v":1},"Yes",{"$f":"IF($D36=0,0,IF(AND($G36>0,$H36<>\"Yes\"),D36,IF(AND($G36>0,$H36=\"Yes\"),COUNTRY_INFO!$F36,0)))","v":133994.35637955647},122538,52473.314386399747,175011.31438639975,306345,157419.94315919923,306345,null,306345,307]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37))","v":"West"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37))","v":"Rutsiro"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J37>0, IF(COUNTRY_INFO!$J37=4, 0, IF(COUNTRY_INFO!$J37=1, COUNTRY_INFO!$F37*0.33, IF(COUNTRY_INFO!$J37=2, COUNTRY_INFO!$F37*0.5, COUNTRY_INFO!$F37))), 0))","v":59193.671088308998},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J37>0, IF(COUNTRY_INFO!$J37=4, 0, IF(COUNTRY_INFO!$J37=1, 0, IF(COUNTRY_INFO!$J37=2, COUNTRY_INFO!$G37*0.2, COUNTRY_INFO!$G37))), 0))","v":40980.233830367783},100173.90491867678,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P37)","v":1},null,{"$f":"IF($D37=0,0,IF(AND($G37>0,$H37<>\"Yes\"),D37,IF(AND($G37>0,$H37=\"Yes\"),COUNTRY_INFO!$F37,0)))","v":59193.671088308998},46751,40980.233830367783,87731.233830367783,116877.5,122940.70149110335,116877.5,null,116877.5,117]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38))","v":"Rwanda"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38))","v":"East"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38))","v":"Rwamagana"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J38>0, IF(COUNTRY_INFO!$J38=4, 0, IF(COUNTRY_INFO!$J38=1, COUNTRY_INFO!$F38*0.33, IF(COUNTRY_INFO!$J38=2, COUNTRY_INFO!$F38*0.5, COUNTRY_INFO!$F38))), 0))","v":49276.030755941909},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", 0, IF(COUNTRY_INFO!$J38>0, IF(COUNTRY_INFO!$J38=4, 0, IF(COUNTRY_INFO!$J38=1, 0, IF(COUNTRY_INFO!$J38=2, COUNTRY_INFO!$G38*0.2, COUNTRY_INFO!$G38))), 0))","v":42278.46802405722},91554.498779999121,{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!P38)","v":1},null,{"$f":"IF($D38=0,0,IF(AND($G38>0,$H38<>\"Yes\"),D38,IF(AND($G38>0,$H38=\"Yes\"),COUNTRY_INFO!$F38,0)))","v":49276.030755941909},58513,42278.46802405722,100791.46802405722,146282.5,126835.40407217166,146282.5,null,146282.5,147]

{"sheet":"SUMMARY","index":5,"n_rows":91,"n_cols":8,"rows_kept":91,"cut":false,"hidden":false,"merged":[[90,1,90,7],[75,2,75,3],[78,1,78,7],[79,1,79,7],[72,2,72,3],[85,1,85,7],[89,1,89,7],[73,4,73,5],[76,2,76,3],[80,1,80,7],[81,2,81,7],[82,2,82,7],[63,1,63,7],[64,1,64,7],[75,4,75,5],[74,2,74,3],[72,4,72,5],[67,1,67,7],[68,1,68,7],[65,1,65,7],[74,4,74,5],[73,2,73,3],[5,2,5,5],[84,1,84,7],[46,5,46,6],[47,5,47,6],[48,5,48,6],[76,4,76,5],[62,1,62,7],[9,1,10,1],[9,2,9,5],[9,6,9,7],[25,1,25,7],[50,5,50,6],[6,1,6,7],[55,1,55,7],[21,2,24,5],[30,2,30,3],[0,1,0,7],[1,1,1,7],[2,1,2,5],[3,1,3,7],[4,1,4,7],[30,4,30,5],[30,6,30,7],[40,5,40,6],[41,5,41,6],[49,5,49,6],[53,1,53,7],[61,1,61,7],[44,5,44,6],[42,5,42,6],[43,5,43,6],[54,1,54,7],[56,1,56,7],[57,1,57,7],[45,5,45,6],[58,1,58,7],[59,1,59,7]]}
[null,"The current version should be used in countries non-endemic for onchocerciasis"]
[null,"Joint request for selected PC medicines"]
[]
[null,"This form constitutes an official government request to WHO for the supply of the PC medicines. It can be submitted any time before 15 August of the current year for distribution of medicines during the following year, but at least 6-8 months before the planned PC intervention(s) to allow time for reviewing and approval of the request, placing order, manufacturing PC medicines and shipment to the country."]
[]
[null,"Country",{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Rwanda"},null,null,null,"Year",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2018}]
[]
[null,"Information on PC medicines requested to WHO"]
[]
[null,"PC medicine","Number of tablets",null,null,null,"Total number of bottles"]
[null,null,"Required","In stock","In pipeline","Requested","Required","Requested"]
[null,"Albendazole for STH (SAC)",7047007.2031857986,4389600,0,{"$f":"IF(C12>(D12+E12),C12-D12-E12, 0)","v":2657407.2031857986},{"$f":"IF($C12=0,0, IF($B12=\"Albendazole for LF\", IF($C12=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C12/200,0)), IF($B12=\"Albendazole for STH (SAC)\", IF($C12=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C12/200,0)), IF($B12=\"Mebendazole (SAC)\", IF($C12=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C12/150,0)), IF($B12=\"Diethylcarbamazine citrate\", IF($C12=DEC!$J$4,DEC!$M$4,ROUNDUP($C12/1000,0)), IF($B12=\"Praziquantel (SAC)\", IF($C12=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C12/1000,0))))))))","v":35250},{"$f":"IF($F12=0,0,IF(OR($B12=\"Albendazole for LF\",$B12=\"Albendazole for STH (SAC)\"),$G12-ROUNDUP(($E12+$D12)/200,0),IF($B12=\"Mebendazole (SAC)\",$G12-ROUNDUP(($E12+$D12)/150,0),$G12-ROUNDUP(($E12+$D12)/1000,0))))","v":13302}]
[null,"Praziquantel (SAC)",2715315.1599867325,641000,0,2074315.1599867325,{"$f":"IF($C13=0,0, IF($B13=\"Albendazole for LF\", IF($C13=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C13/200,0)), IF($B13=\"Albendazole for STH (SAC)\", IF($C13=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C13/200,0)), IF($B13=\"Mebendazole (SAC)\", IF($C13=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C13/150,0)), IF($B13=\"Diethylcarbamazine citrate\", IF($C13=DEC!$J$4,DEC!$M$4,ROUNDUP($C13/1000,0)), IF($B13=\"Praziquantel (SAC)\", IF($C13=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C13/1000,0))))))))","v":2729},2088]
[null,null,0,0,0,0,{"$f":"IF($C14=0,0, IF($B14=\"Albendazole for LF\", IF($C14=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C14/200,0)), IF($B14=\"Albendazole for STH (SAC)\", IF($C14=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C14/200,0)), IF($B14=\"Mebendazole (SAC)\", IF($C14=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C14/150,0)), IF($B14=\"Diethylcarbamazine citrate\", IF($C14=DEC!$J$4,DEC!$M$4,ROUNDUP($C14/1000,0)), IF($B14=\"Praziquantel (SAC)\", IF($C14=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C14/1000,0))))))))","v":0},0]
[null,null,0,0,0,0,{"$f":"IF($C15=0,0, IF($B15=\"Albendazole for LF\", IF($C15=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C15/200,0)), IF($B15=\"Albendazole for STH (SAC)\", IF($C15=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C15/200,0)), IF($B15=\"Mebendazole (SAC)\", IF($C15=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C15/150,0)), IF($B15=\"Diethylcarbamazine citrate\", IF($C15=DEC!$J$4,DEC!$M$4,ROUNDUP($C15/1000,0)), IF($B15=\"Praziquantel (SAC)\", IF($C15=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C15/1000,0))))))))","v":0},0]
[null,null,0,0,0,0,{"$f":"IF($C16=0,0, IF($B16=\"Albendazole for LF\", IF($C16=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C16/200,0)), IF($B16=\"Albendazole for STH (SAC)\", IF($C16=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C16/200,0)), IF($B16=\"Mebendazole (SAC)\", IF($C16=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C16/150,0)), IF($B16=\"Diethylcarbamazine citrate\", IF($C16=DEC!$J$4,DEC!$M$4,ROUNDUP($C16/1000,0)), IF($B16=\"Praziquantel (SAC)\", IF($C16=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C16/1000,0))))))))","v":0},0]
[null,null,0,0,0,0,{"$f":"IF($C17=0,0, IF($B17=\"Albendazole for LF\", IF($C17=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C17/200,0)), IF($B17=\"Albendazole for STH (SAC)\", IF($C17=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C17/200,0)), IF($B17=\"Mebendazole (SAC)\", IF($C17=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C17/150,0)), IF($B17=\"Diethylcarbamazine citrate\", IF($C17=DEC!$J$4,DEC!$M$4,ROUNDUP($C17/1000,0)), IF($B17=\"Praziquantel (SAC)\", IF($C17=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C17/1000,0))))))))","v":0},0]
[]
[null,"Number of people to be treated with donated medicine ( see User Guide for details )"]
[]
[null,"Disease",null,null,null,null,"Round 1","Round 2"]
[null,"Soil-transmitted helminthiases","These figures are estimated only for targeted \nage groups to be treated with donated \nmedicines in areas where treatment for specific disease is required",null,null,null,3523500,3523500]
[null,"Schistosomiasis",null,null,null,null,1086126.0639946931," "]
[null,null,null,null,null,null," "," "]
[null,null,null,null,null,null," "," "]
[]
[]
[]
[null,"Information on planned PC interventions"]
[]
[null,"PC medicine","Planned date of the \n1st round of PC",null,"Planned date of the \n2nd round of PC",null,"Date by which the medicine \nshould arrive to the national warehouse"]
[null,"Albendazole for STH","March",2018,"September",2018,"January",2018]
[null,"Praziquantel",null,null,"September",2018,"January",2018]
[]
[]
[]
[]
[]
[null,"Information on PC medicines for treatment of population not targeted with current donation through WHO"]
[]
[null,"PC medicine","Age group","# of people","# of tablets","Specify source",null,"Status"]
[null,"Mebendazole","PreSAC",{"$f":"COUNTRY_INFO!E4","v":1457145.1221686804},{"$f":"D42*2","v":2914290.2443373608},"UNICEF",null,"Required"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Checklist"]
[null,"Submission"]
[null,"What should be submitted?"]
[null,"The supply of the requested medicines should be based on up-to-date epidemiological data, specific usage plans, and capacity for implementation. The following checklist ensures that all necessary forms and information are provided to WHO (in electronic format). "]
[null,"Joint request for selected PC medicines"]
[null,"Joint reporting form"]
[null,"PC epidemiological data reporting form"]
[]
[null,"Availability of funding for implementation"]
[]
[null,"Financial resources secured for the implementation in the year for which the medicines are requested"]
[null,"Resources are secured from The END Fund Grant"]
[]
[]
[]
[null,"Who should fill in the form? "]
[null,"National NTD coordinator should compile all required information needed to complete the request form. In the absence of such a coordinator, specific programme managers should coordinate their respective part. The final single request must be approved by the Ministry of Health."]
[]
[null,"Information on person(s) who has filled in the form"]
[]
[null,"Title ","Name",null,"Phone",null,"Email","Date"]
[null,"Other","Mr. Jean Bosco MBONIGABA",null,"00250738609068",null,"jbosco.mbonigaba@rbc.gov.rw","2017-10-30"]
[null,null,null,null,"00250788609068"]
[]
[]
[]
[null,"The WHO recommends that all serious adverse events suspected to be associated with use of PC medicines should be reported in accordance with national Pharmacovigilance guidelines. In the absence of a national Pharmacovigilance system, contact the WHO Neglected Tropical Disease department for guidance."]
[null,"The WHO is committed to facilitate PC medicines donation with a free-of-charge supply of a) albendazole, mebendazole and praziquantel to the MoH’s national warehouse; and b) diethylcarbamazine citrate to the entry port/airport of recipient countries."]
[null,"The institution submitting the present request is responsible for a) arranging the offloading of the medicines from the truck and storing it in the national warehouse and subsequent shipment to the final distribution centres; b) for registering the donated medicine, if required, by the relevant national regulatory authorities; and c) for informing about any changes of their PC campaigns (e.g. postpone of the planned MDA date, replacement of NTD coordinator, etc.)."]
[null,"Name and signature of NTD coordinator or Ministry of Health representative"]
[null,"Date:"]
[]
[null,"Please complete information on shipment and consignee in the workshsheet SHIPMENT"]
[null,"Please send the national request (signed and in electronic format) to the concerned WR with copy to:"]
[]
[null,"WHO headquarters","PC_JointForms@who.int"]
[null,"WHO Regional Office","Regional Advisor for NTD"]
[]
[null,"Please note that your request will be reviewed by an independent panel before approval. The information in this form, joint reporting form and PC epidemiological data reporting form are essential for WHO to ensure efficient usage of medicines. As part of its ongoing monitoring and evaluation activities, and to meet its contractual obligations to donors and other partners, WHO and its appointed agents reserve the right to periodically inspect stocks of the medicines at country level."]

{"sheet":"SHIPMENT","index":6,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[35,1,35,7],[22,2,22,4],[25,2,25,4],[25,5,25,7],[23,2,23,4],[23,5,23,7],[27,5,27,7],[29,2,29,4],[29,5,29,7],[28,2,28,4],[28,5,28,7],[22,5,22,7],[18,2,18,4],[20,2,20,4],[13,2,13,4],[13,5,13,7],[26,5,26,7],[9,2,9,4],[12,2,12,4],[11,2,11,4],[21,5,21,7],[21,2,21,4],[15,1,15,7],[14,2,14,4],[14,5,14,7],[17,5,17,7],[16,5,16,7],[17,2,17,4],[16,2,16,4],[18,5,18,7],[19,2,19,4],[19,5,19,7],[20,5,20,7],[38,1,38,6],[0,1,0,7],[1,1,1,7],[2,1,2,5],[11,5,11,7],[12,5,12,7],[6,1,6,7],[9,5,9,7],[10,2,10,4],[3,2,3,5],[10,5,10,7],[4,1,4,7],[7,2,7,4],[7,5,7,7],[8,2,8,4],[8,5,8,7],[39,1,39,7],[27,2,27,4],[36,1,36,6],[26,2,26,4],[46,1,56,7],[44,1,44,7],[30,2,30,4],[30,5,30,7],[31,2,31,4],[31,5,31,7],[32,2,32,4],[32,5,32,7],[37,1,37,5],[40,1,40,6],[41,1,41,6],[42,1,42,7]]}
[]
[null,"Joint request for selected PC medicines"]
[]
[null,"Country",{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Rwanda"},null,null,null,"Year",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2018}]
[]
[null,"Information on shipment and consignee "]
[]
[null,"Albendazole for STH","Consignee",null,null,"Delivery point / Final recipient\nif different from the consignee"]
[null,"Name","Dr Michel GASANA",null,null,"N/A"]
[null,"Department/Unit","DPC Malaria and NTDs"]
[null,"Organization","World Health Organization/ Rwanda"]
[null,"Phone","00250 280300507/00250 788307870"]
[null,"Fax",250280300508]
[null,"E-mail","whorw@rw,afro.who.int"]
[null,"Mailing address","P.O Box 1324 Kigali, Rwanda"]
[]
[null,"Praziquantel","Consignee",null,null,"Delivery point / Final recipient\nif different from the consignee"]
[null,"Name","Dr Michel GASANA",null,null,"N/A"]
[null,"Department/Unit","DPC Malaria and NTDs"]
[null,"Organization","World Health Organization/ Rwanda"]
[null,"Phone","00250 280300507/00250 788307870"]
[null,"Fax",250280300508]
[null,"E-mail","whorw@rw,afro.who.int"]
[null,"Mailing address","P.O Box 1324 Kigali, Rwanda"]
[]
[null,null,"Consignee",null,null,"Delivery point / Final recipient\nif different from the consignee"]
[null,"Name"]
[null,"Department/Unit"]
[null,"Organization"]
[null,"Phone"]
[null,"Fax"]
[null,"E-mail"]
[null,"Mailing address"]
[]
[null,"Information on import requirements"]
[]
[null,"Is the Import Permit required?",null,null,null,null,null,"Yes"]
[null,"How long does it take to obtain the Import Permit?",null,null,null,null,7,"Days"]
[null,"Do you require any documents to be submitted together with the Import Permit application?",null,null,null,null,null,"Yes"]
[null,"Parking list, commercial invoice and certificate of analysis"]
[null,"Does the consignee have to get customs clearance before the shipment can proceed?",null,null,null,null,null,"No"]
[null,"Is there any additional information may be helpful in ensuring timely clearance and delivery of medicines to your country? ",null,null,null,null,null,"No"]
[]
[]
[null,"Additional information"]