{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["INTRO","COUNTRY_INFO","MDA2","T1","T2","T3_R1","T3_R2","DISTRICT","SUMMARY"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":8,"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":[[7,2,7,4],[8,2,8,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[9,2,9,4],[11,2,11,4],[12,1,12,4],[13,1,13,4],[22,1,22,4],[23,2,24,4],[25,1,25,4],[26,2,27,4],[18,1,18,4],[19,2,19,4],[20,1,20,4],[21,2,21,4],[45,1,45,2],[10,2,10,4],[48,1,48,2],[49,1,49,2],[41,1,41,2],[43,1,43,2],[46,1,46,4],[47,1,47,2],[33,1,33,2],[35,1,35,2],[37,1,37,2],[39,1,39,2],[28,1,28,4],[29,2,29,4],[30,1,30,4],[31,1,31,4]]}
[null,"The current version should be used in countries non-endemic for onchocerciasis"]
[null,"PC Joint Reporting Form v.2"]
[]
[null,"The purpose of this template Joint Reporting Form (JRF) - available as an Excel file - is to provide national health authorities and data managers with a standardized tool to address these reporting challenges, facilitate  integration and thereby further contribute to improving overall programme management. This template aims to standardize national reporting of programme implementation outcomes, improve availability and coordination of preventive chemotherapy data across the World Health Organization regions. \nNational authorities are requested to complete this form for submission to the World Health Organization any time before 15 August of the current year for reporting data on PC interventions implemented during the previous year."]
[]
[null,"Structure of the application (worksheets):"]
[]
[null,"INTRO","This worksheet includes guides on how to complete the joint reporting form and information about 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, planned interventions and interventions implemented"]
[null,"MDA2, \nT1, T2 \nand T3","These worksheets include information about endemic districts targeted for treatment with specified PC medicines, treatment plan, and number of people who received treatment by age group"]
[null,"DISTRICT","This worksheet includes summary of people treated by disease at the level of implementation. If data by gender is available, it requires to enter."]
[null,"SUMMARY","This worksheet includes summary of people treated by disease and by PC intervention. Before generating the report (run macros) please select the disease for which you need the report. Follow the same rule to generate various reports.\nThis worksheet should be printed and submitted as a Joint Report (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 of reporting data",null,null,2016]
[]
[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":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,18,3,19],[5,18,5,19],[5,3,5,6],[5,7,5,9],[5,10,5,12],[5,16,5,17],[3,0,3,2],[3,7,3,9],[3,16,3,17],[5,0,5,2],[3,13,3,15],[5,13,5,15]]}
["COUNTRY INFORMATION"]
["Administrative structure, population by age group, endemicity status, planned interventions and interventions implemented"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":11653034},{"$f":"SUM(E$9:E$1000)","v":1363403},{"$f":"SUM(F$9:F$1000)","v":3356074},{"$f":"SUM(G$9:G$1000)","v":6595616},null,null,null,{"$f":"SUM(K$9:K$1000)","v":0},{"$f":"SUM(L$9:L$1000)","v":4338846},{"$f":"SUM(M$9:M$1000)","v":1788628.0400000003}]
[]
["Country administrative structure",null,null,"Population",null,null,null,"Endemicity",null,null,"Population requiring PC",null,null,"Number of treatment\nrounds planned",null,null,"PC implemented",null,"Click to see the recommended strategy"]
["Country","Province/State","District","Total","PreSAC","SAC","Adults","LF","STH","SCH","LF","STH","SCH","LF","STH","SCH","ROUND 1","ROUND2",null,null,"IU_ID","IU_Name"]
[]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"East","Bugesera",401047,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D9*INTRO!$E$48,0))","v":46922},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D9*INTRO!$E$49,0))","v":115502},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D9*INTRO!$E$50,0))","v":226993},0,2,2,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H9>0, IF($H9=4,\"Unknown\", IF($H9=99,\"Stopped\", $D9)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I9>1,$I9<5), IF($I9=4, \"Unknown\", E9+F9), 0),\"Not required\")","v":162424},{"$f":"IF(INTRO!$E$44=\"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":103149.6},0,2,1,"T3 (ALB/MBD)",null,null,null,38111,"Bugesera",null,{"$f":"V9=C9","v":true}]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"North","Burera",372976,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D10*INTRO!$E$48,0))","v":43638},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D10*INTRO!$E$49,0))","v":107417},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D10*INTRO!$E$50,0))","v":211104},0,3,2,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H10>0, IF($H10=4,\"Unknown\", IF($H10=99,\"Stopped\", $D10)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I10>1,$I10<5), IF($I10=4, \"Unknown\", E10+F10), 0),\"Not required\")","v":151055},{"$f":"IF(INTRO!$E$44=\"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":95929.3},0,2,1,"T3 (ALB/MBD)",null,null,null,38121,"Burera",null,{"$f":"V10=C10","v":true}]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"North","Gakenke",374806,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D11*INTRO!$E$48,0))","v":43852},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D11*INTRO!$E$49,0))","v":107944},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D11*INTRO!$E$50,0))","v":212140},0,3,2,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H11>0, IF($H11=4,\"Unknown\", IF($H11=99,\"Stopped\", $D11)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I11>1,$I11<5), IF($I11=4, \"Unknown\", E11+F11), 0),\"Not required\")","v":151796},{"$f":"IF(INTRO!$E$44=\"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":96400},0,2,1,"T3 (ALB/MBD)",null,null,null,38122,"Gakenke",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"Kigali","Gasabo",586821,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D12*INTRO!$E$48,0))","v":68658},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D12*INTRO!$E$49,0))","v":169004},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D12*INTRO!$E$50,0))","v":332141},0,1,1,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H12>0, IF($H12=4,\"Unknown\", IF($H12=99,\"Stopped\", $D12)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I12>1,$I12<5), IF($I12=4, \"Unknown\", E12+F12), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$44=\"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":55771.32},0,2,0,"T3 (ALB/MBD)",null,null,null,38118,"Gasabo",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"East","Gatsibo",479841,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D13*INTRO!$E$48,0))","v":56141},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D13*INTRO!$E$49,0))","v":138194},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D13*INTRO!$E$50,0))","v":271590},0,3,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H13>0, IF($H13=4,\"Unknown\", IF($H13=99,\"Stopped\", $D13)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I13>1,$I13<5), IF($I13=4, \"Unknown\", E13+F13), 0),\"Not required\")","v":194335},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38112,"Gatsibo",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"North","Gicumbi",438382,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D14*INTRO!$E$48,0))","v":51291},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D14*INTRO!$E$49,0))","v":126254},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D14*INTRO!$E$50,0))","v":248124},0,3,3,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H14>0, IF($H14=4,\"Unknown\", IF($H14=99,\"Stopped\", $D14)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I14>1,$I14<5), IF($I14=4, \"Unknown\", E14+F14), 0),\"Not required\")","v":177545},{"$f":"IF(INTRO!$E$44=\"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":374378},0,2,1,"T3 (ALB/MBD)",null,null,null,38123,"Gicumbi",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"South","Gisagara",357377,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D15*INTRO!$E$48,0))","v":41813},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D15*INTRO!$E$49,0))","v":102925},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D15*INTRO!$E$50,0))","v":202275},0,3,1,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H15>0, IF($H15=4,\"Unknown\", IF($H15=99,\"Stopped\", $D15)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I15>1,$I15<5), IF($I15=4, \"Unknown\", E15+F15), 0),\"Not required\")","v":144738},{"$f":"IF(INTRO!$E$44=\"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":33965.25},0,2,0,"T3 (ALB/MBD)",null,null,null,38126,"Gisagara",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"South","Huye",363907,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D16*INTRO!$E$48,0))","v":42577},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D16*INTRO!$E$49,0))","v":104805},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D16*INTRO!$E$50,0))","v":205971},0,3,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H16>0, IF($H16=4,\"Unknown\", IF($H16=99,\"Stopped\", $D16)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I16>1,$I16<5), IF($I16=4, \"Unknown\", E16+F16), 0),\"Not required\")","v":147382},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38127,"Huye",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"South","Kamonyi",377319,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D17*INTRO!$E$48,0))","v":44146},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D17*INTRO!$E$49,0))","v":108668},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D17*INTRO!$E$50,0))","v":213563},0,2,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H17>0, IF($H17=4,\"Unknown\", IF($H17=99,\"Stopped\", $D17)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I17>1,$I17<5), IF($I17=4, \"Unknown\", E17+F17), 0),\"Not required\")","v":152814},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38128,"Kamonyi",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"West","Karongi",367686,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D18*INTRO!$E$48,0))","v":43019},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D18*INTRO!$E$49,0))","v":105894},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D18*INTRO!$E$50,0))","v":208110},0,3,1,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H18>0, IF($H18=4,\"Unknown\", IF($H18=99,\"Stopped\", $D18)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I18>1,$I18<5), IF($I18=4, \"Unknown\", E18+F18), 0),\"Not required\")","v":148913},{"$f":"IF(INTRO!$E$44=\"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":34945.020000000004},0,2,0,"T3 (ALB/MBD)",null,null,null,38134,"Karongi",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"East","Kayonza",381369,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D19*INTRO!$E$48,0))","v":44620},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D19*INTRO!$E$49,0))","v":109834},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D19*INTRO!$E$50,0))","v":215855},0,2,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H19>0, IF($H19=4,\"Unknown\", IF($H19=99,\"Stopped\", $D19)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I19>1,$I19<5), IF($I19=4, \"Unknown\", E19+F19), 0),\"Not required\")","v":154454},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38113,"Kayonza",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"Kigali","Kicukiro",353010,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D20*INTRO!$E$48,0))","v":41302},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D20*INTRO!$E$49,0))","v":101667},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D20*INTRO!$E$50,0))","v":199804},0,1,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H20>0, IF($H20=4,\"Unknown\", IF($H20=99,\"Stopped\", $D20)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I20>1,$I20<5), IF($I20=4, \"Unknown\", E20+F20), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38119,"Kicukiro",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"East","Kirehe",377171,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D21*INTRO!$E$48,0))","v":44129},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D21*INTRO!$E$49,0))","v":108625},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D21*INTRO!$E$50,0))","v":213479},0,3,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H21>0, IF($H21=4,\"Unknown\", IF($H21=99,\"Stopped\", $D21)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I21>1,$I21<5), IF($I21=4, \"Unknown\", E21+F21), 0),\"Not required\")","v":152754},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38114,"Kirehe",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"South","Muhanga",353649,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D22*INTRO!$E$48,0))","v":41377},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D22*INTRO!$E$49,0))","v":101851},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D22*INTRO!$E$50,0))","v":200165},0,3,1,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H22>0, IF($H22=4,\"Unknown\", IF($H22=99,\"Stopped\", $D22)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I22>1,$I22<5), IF($I22=4, \"Unknown\", E22+F22), 0),\"Not required\")","v":143228},{"$f":"IF(INTRO!$E$44=\"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":33610.83},0,2,0,"T3 (ALB/MBD)",null,null,null,38129,"Muhanga",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"North","Musanze",408086,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D23*INTRO!$E$48,0))","v":47746},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D23*INTRO!$E$49,0))","v":117529},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D23*INTRO!$E$50,0))","v":230977},0,3,2,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H23>0, IF($H23=4,\"Unknown\", IF($H23=99,\"Stopped\", $D23)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I23>1,$I23<5), IF($I23=4, \"Unknown\", E23+F23), 0),\"Not required\")","v":165275},{"$f":"IF(INTRO!$E$44=\"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":104959.9},0,2,1,"T3 (ALB/MBD)",null,null,null,38124,"Musanze",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"East","Ngoma",373359,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D24*INTRO!$E$48,0))","v":43683},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D24*INTRO!$E$49,0))","v":107527},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D24*INTRO!$E$50,0))","v":211321},0,3,1,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H24>0, IF($H24=4,\"Unknown\", IF($H24=99,\"Stopped\", $D24)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I24>1,$I24<5), IF($I24=4, \"Unknown\", E24+F24), 0),\"Not required\")","v":151210},{"$f":"IF(INTRO!$E$44=\"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":35483.910000000003},0,2,0,"T3 (ALB/MBD)",null,null,null,38115,"Ngoma",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"West","Ngororero",369796,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D25*INTRO!$E$48,0))","v":43266},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D25*INTRO!$E$49,0))","v":106501},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D25*INTRO!$E$50,0))","v":209305},0,3,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H25>0, IF($H25=4,\"Unknown\", IF($H25=99,\"Stopped\", $D25)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I25>1,$I25<5), IF($I25=4, \"Unknown\", E25+F25), 0),\"Not required\")","v":149767},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38136,"Ngororero",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"West","Nyabihu",326610,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D26*INTRO!$E$48,0))","v":38213},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D26*INTRO!$E$49,0))","v":94064},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D26*INTRO!$E$50,0))","v":184861},0,3,1,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H26>0, IF($H26=4,\"Unknown\", IF($H26=99,\"Stopped\", $D26)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I26>1,$I26<5), IF($I26=4, \"Unknown\", E26+F26), 0),\"Not required\")","v":132277},{"$f":"IF(INTRO!$E$44=\"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":31041.120000000003},0,2,0,"T3 (ALB/MBD)",null,null,null,38137,"Nyabihu",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"East","Nyagatare",516227,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D27*INTRO!$E$48,0))","v":60399},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D27*INTRO!$E$49,0))","v":148673},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D27*INTRO!$E$50,0))","v":292184},0,3,2,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H27>0, IF($H27=4,\"Unknown\", IF($H27=99,\"Stopped\", $D27)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I27>1,$I27<5), IF($I27=4, \"Unknown\", E27+F27), 0),\"Not required\")","v":209072},{"$f":"IF(INTRO!$E$44=\"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":132773.29999999999},0,2,1,"T3 (ALB/MBD)",null,null,null,38116,"Nyagatare",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"South","Nyamagabe",378415,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D28*INTRO!$E$48,0))","v":44275},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D28*INTRO!$E$49,0))","v":108984},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D28*INTRO!$E$50,0))","v":214183},0,3,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H28>0, IF($H28=4,\"Unknown\", IF($H28=99,\"Stopped\", $D28)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I28>1,$I28<5), IF($I28=4, \"Unknown\", E28+F28), 0),\"Not required\")","v":153259},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38130,"Nyamagabe",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"West","Nyamasheke",423088,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D29*INTRO!$E$48,0))","v":49501},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D29*INTRO!$E$49,0))","v":121849},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D29*INTRO!$E$50,0))","v":239468},0,3,2,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H29>0, IF($H29=4,\"Unknown\", IF($H29=99,\"Stopped\", $D29)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I29>1,$I29<5), IF($I29=4, \"Unknown\", E29+F29), 0),\"Not required\")","v":171350},{"$f":"IF(INTRO!$E$44=\"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":108818.1},0,2,1,"T3 (ALB/MBD)",null,null,null,38138,"Nyamasheke",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"South","Nyanza",358721,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D30*INTRO!$E$48,0))","v":41970},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D30*INTRO!$E$49,0))","v":103312},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D30*INTRO!$E$50,0))","v":203036},0,2,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H30>0, IF($H30=4,\"Unknown\", IF($H30=99,\"Stopped\", $D30)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I30>1,$I30<5), IF($I30=4, \"Unknown\", E30+F30), 0),\"Not required\")","v":145282},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38131,"Nyanza",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"Kigali","Nyarugenge",315330,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D31*INTRO!$E$48,0))","v":36894},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D31*INTRO!$E$49,0))","v":90815},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D31*INTRO!$E$50,0))","v":178477},0,2,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H31>0, IF($H31=4,\"Unknown\", IF($H31=99,\"Stopped\", $D31)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I31>1,$I31<5), IF($I31=4, \"Unknown\", E31+F31), 0),\"Not required\")","v":127709},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38120,"Nyarugenge",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"South","Nyaruguru",326159,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D32*INTRO!$E$48,0))","v":38161},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D32*INTRO!$E$49,0))","v":93934},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D32*INTRO!$E$50,0))","v":184606},0,3,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H32>0, IF($H32=4,\"Unknown\", IF($H32=99,\"Stopped\", $D32)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I32>1,$I32<5), IF($I32=4, \"Unknown\", E32+F32), 0),\"Not required\")","v":132095},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38132,"Nyaruguru",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"West","Rubavu",447308,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D33*INTRO!$E$48,0))","v":52335},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D33*INTRO!$E$49,0))","v":128825},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D33*INTRO!$E$50,0))","v":253176},0,3,1,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H33>0, IF($H33=4,\"Unknown\", IF($H33=99,\"Stopped\", $D33)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I33>1,$I33<5), IF($I33=4, \"Unknown\", E33+F33), 0),\"Not required\")","v":181160},{"$f":"IF(INTRO!$E$44=\"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":42512.25},0,2,0,"T3 (ALB/MBD)",null,null,null,38139,"Rubavu",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"South","Ruhango",354473,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D34*INTRO!$E$48,0))","v":41473},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D34*INTRO!$E$49,0))","v":102088},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D34*INTRO!$E$50,0))","v":200632},0,3,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H34>0, IF($H34=4,\"Unknown\", IF($H34=99,\"Stopped\", $D34)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I34>1,$I34<5), IF($I34=4, \"Unknown\", E34+F34), 0),\"Not required\")","v":143561},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38133,"Ruhango",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"North","Rulindo",318787,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D35*INTRO!$E$48,0))","v":37298},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D35*INTRO!$E$49,0))","v":91811},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D35*INTRO!$E$50,0))","v":180433},0,3,0,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H35>0, IF($H35=4,\"Unknown\", IF($H35=99,\"Stopped\", $D35)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I35>1,$I35<5), IF($I35=4, \"Unknown\", E35+F35), 0),\"Not required\")","v":129109},{"$f":"IF(INTRO!$E$44=\"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":0},0,2,0,"T3 (ALB/MBD)",null,null,null,38125,"Rulindo",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"West","Rusizi",444202,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D36*INTRO!$E$48,0))","v":51972},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D36*INTRO!$E$49,0))","v":127930},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D36*INTRO!$E$50,0))","v":251418},0,3,3,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H36>0, IF($H36=4,\"Unknown\", IF($H36=99,\"Stopped\", $D36)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I36>1,$I36<5), IF($I36=4, \"Unknown\", E36+F36), 0),\"Not required\")","v":179902},{"$f":"IF(INTRO!$E$44=\"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":379348},0,2,1,"T3 (ALB/MBD)",null,null,null,38140,"Rusizi",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"West","Rutsiro",359758,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D37*INTRO!$E$48,0))","v":42092},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D37*INTRO!$E$49,0))","v":103610},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D37*INTRO!$E$50,0))","v":203623},0,3,2,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H37>0, IF($H37=4,\"Unknown\", IF($H37=99,\"Stopped\", $D37)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I37>1,$I37<5), IF($I37=4, \"Unknown\", E37+F37), 0),\"Not required\")","v":145702},{"$f":"IF(INTRO!$E$44=\"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":92529.600000000006},0,2,1,"T3 (ALB/MBD)",null,null,null,38141,"Rutsiro",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"Rwanda"},"East","Rwamagana",347354,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D38*INTRO!$E$48,0))","v":40640},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D38*INTRO!$E$49,0))","v":100038},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D38*INTRO!$E$50,0))","v":196602},0,3,1,{"$f":"IF(INTRO!$E$38=\"Endemic\", IF($H38>0, IF($H38=4,\"Unknown\", IF($H38=99,\"Stopped\", $D38)), 0),\"Not required\")","v":"Not required"},{"$f":"IF(INTRO!$E$42=\"Endemic\", IF(AND($I38>1,$I38<5), IF($I38=4, \"Unknown\", E38+F38), 0),\"Not required\")","v":140678},{"$f":"IF(INTRO!$E$44=\"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":33012.54},0,2,0,"T3 (ALB/MBD)",null,null,null,38117,"Rwamagana",null,true]

{"sheet":"MDA2","index":2,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,5,5,8],[5,9,5,12],[5,13,5,16],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,4,6,4]]}
["MDA 2 - Diethylcarbamazine citrate (DEC) + Albendazole (ALB)"]
["Administrative structure, population requiring PC by age group, population treated by age group and coverage"]
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F$9:F$1000)","v":0},{"$f":"SUM(G$9:G$1000)","v":0},0,0,0,0,0,0,{"$f":"IF(F4<>0, IF(J4/F4*100=0, \"-\", J4/F4*100), \" \")","v":" "},{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":" "},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "}]
[]
[null,null,null,"PC implemented","Date","Population targeted for MDA 2",null,null,null,"Population treated",null,null,null,"Programme coverage (%)"]
["Country","Province/State","District",null,null,"PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"East"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Bugesera"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,{"$f":"SUM(F9:H9)","v":0},null,null,null,{"$f":"SUM(J9:L9)","v":0},{"$f":"IF(F9<>0, IF(J9/F9*100=0, \"-\", J9/F9*100), \" \")","v":" "},{"$f":"IF(G9<>0, IF(K9/G9*100=0, \"-\", K9/G9*100), \" \")","v":" "},{"$f":"IF(H9<>0, IF(L9/H9*100=0, \"-\", L9/H9*100), \" \")","v":" "},{"$f":"IF(I9<>0, IF(M9/I9*100=0, \"-\", M9/I9*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"North"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Burera"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,{"$f":"SUM(F10:H10)","v":0},null,null,null,{"$f":"SUM(J10:L10)","v":0},{"$f":"IF(F10<>0, IF(J10/F10*100=0, \"-\", J10/F10*100), \" \")","v":" "},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":" "},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"North"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Gakenke"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Gasabo"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"East"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Gatsibo"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"North"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Gicumbi"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"South"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Gisagara"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16)","v":"South"},{"$f":"IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16)","v":"Huye"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17)","v":"South"},{"$f":"IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17)","v":"Kamonyi"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18)","v":"West"},{"$f":"IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18)","v":"Karongi"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19)","v":"East"},{"$f":"IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19)","v":"Kayonza"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20)","v":"Kicukiro"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21)","v":"East"},{"$f":"IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21)","v":"Kirehe"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22)","v":"South"},{"$f":"IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22)","v":"Muhanga"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23)","v":"North"},{"$f":"IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23)","v":"Musanze"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24)","v":"East"},{"$f":"IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24)","v":"Ngoma"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25)","v":"West"},{"$f":"IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25)","v":"Ngororero"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26)","v":"West"},{"$f":"IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26)","v":"Nyabihu"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27)","v":"East"},{"$f":"IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27)","v":"Nyagatare"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28)","v":"South"},{"$f":"IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28)","v":"Nyamagabe"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29)","v":"West"},{"$f":"IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29)","v":"Nyamasheke"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30)","v":"South"},{"$f":"IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30)","v":"Nyanza"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31)","v":"Nyarugenge"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32)","v":"South"},{"$f":"IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32)","v":"Nyaruguru"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33)","v":"West"},{"$f":"IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33)","v":"Rubavu"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34)","v":"South"},{"$f":"IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34)","v":"Ruhango"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35)","v":"North"},{"$f":"IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35)","v":"Rulindo"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36)","v":"West"},{"$f":"IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36)","v":"Rusizi"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37)","v":"West"},{"$f":"IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37)","v":"Rutsiro"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38)","v":"East"},{"$f":"IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38)","v":"Rwamagana"},{"$f":"IF(COUNTRY_INFO!$Q$9:$Q$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$Q$9:$Q$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]

{"sheet":"T1","index":3,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,6,5,10],[5,11,5,14],[5,15,5,18],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,5,6,5],[5,4,6,4]]}
["T 1 - Praziquantel (PZQ) and Albendazole (ALB) or Mebendazole (MBD)"]
["Administrative structure, population requiring PC by age group, population treated by age group and coverage"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":0},0,0,0,{"$f":"SUM(K$9:K$1000)","v":0},0,0,0,0,{"$f":"IF(G4<>0, IF(L4/G4*100=0, \"-\", L4/G4*100), \" \")","v":" "},{"$f":"IF(OR(I4<>0,H4<>0), IF(M4/MAX(H4,I4)*100=0, \"-\", M4/MAX(H4,I4)*100), \" \")","v":" "},{"$f":"IF(J4<>0, IF(N4/J4*100=0, \"-\", N4/J4*100), \" \")","v":" "},{"$f":"IF(K4<>0, IF(O4/K4*100=0, \"-\", O4/K4*100), \" \")","v":" "}]
[]
[null,null,null,"PC implemented","Medicine","Date","Population targeted for T1",null,null,null,null,"Population treated",null,null,null,"Programme coverage (%)"]
["Country","Province/State","District",null,null,null,"PreSAC (ALB)","SAC (ALB)","SAC (PZQ)","Adults (PZQ)","Total","PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"East"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Bugesera"},null,null,null,null,null,null,null,{"$f":"MAX(H9:I9)+G9+J9","v":0},null,null,null,{"$f":"SUM(L9:N9)","v":0},{"$f":"IF(G9<>0, IF(L9/G9*100=0, \"-\", L9/G9*100), \" \")","v":" "},{"$f":"IF(OR(I9<>0,H9<>0), IF(M9/MAX(H9,I9)*100=0, \"-\", M9/MAX(H9,I9)*100), \" \")","v":" "},{"$f":"IF(J9<>0, IF(N9/J9*100=0, \"-\", N9/J9*100), \" \")","v":" "},{"$f":"IF(K9<>0, IF(O9/K9*100=0, \"-\", O9/K9*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"North"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Burera"},null,null,null,null,null,null,null,{"$f":"MAX(H10:I10)+G10+J10","v":0},null,null,null,{"$f":"SUM(L10:N10)","v":0},{"$f":"IF(G10<>0, IF(L10/G10*100=0, \"-\", L10/G10*100), \" \")","v":" "},{"$f":"IF(OR(I10<>0,H10<>0), IF(M10/MAX(H10,I10)*100=0, \"-\", M10/MAX(H10,I10)*100), \" \")","v":" "},{"$f":"IF(J10<>0, IF(N10/J10*100=0, \"-\", N10/J10*100), \" \")","v":" "},{"$f":"IF(K10<>0, IF(O10/K10*100=0, \"-\", O10/K10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"North"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Gakenke"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Gasabo"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"East"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Gatsibo"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"North"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Gicumbi"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"South"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Gisagara"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16)","v":"South"},{"$f":"IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16)","v":"Huye"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17)","v":"South"},{"$f":"IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17)","v":"Kamonyi"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18)","v":"West"},{"$f":"IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18)","v":"Karongi"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19)","v":"East"},{"$f":"IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19)","v":"Kayonza"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20)","v":"Kicukiro"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21)","v":"East"},{"$f":"IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21)","v":"Kirehe"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22)","v":"South"},{"$f":"IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22)","v":"Muhanga"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23)","v":"North"},{"$f":"IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23)","v":"Musanze"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24)","v":"East"},{"$f":"IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24)","v":"Ngoma"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25)","v":"West"},{"$f":"IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25)","v":"Ngororero"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26)","v":"West"},{"$f":"IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26)","v":"Nyabihu"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27)","v":"East"},{"$f":"IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27)","v":"Nyagatare"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28)","v":"South"},{"$f":"IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28)","v":"Nyamagabe"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29)","v":"West"},{"$f":"IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29)","v":"Nyamasheke"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30)","v":"South"},{"$f":"IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30)","v":"Nyanza"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31)","v":"Nyarugenge"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32)","v":"South"},{"$f":"IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32)","v":"Nyaruguru"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33)","v":"West"},{"$f":"IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33)","v":"Rubavu"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34)","v":"South"},{"$f":"IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34)","v":"Ruhango"},null,null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35)","v":"North"},{"$f":"IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35)","v":"Rulindo"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36)","v":"West"},{"$f":"IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36)","v":"Rusizi"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37)","v":"West"},{"$f":"IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37)","v":"Rutsiro"},null,null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38)","v":"East"},{"$f":"IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38)","v":"Rwamagana"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,null,null,null,null,null,0," "," "," "," "]

{"sheet":"T2","index":4,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,5,5,8],[5,9,5,12],[5,13,5,16],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,4,6,4]]}
["T 2 - Praziquantel (PZQ) "]
["Administrative structure, population requiring PC by age group, population treated by age group and coverage"]
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F$9:F$1000)","v":0},0,0,0,0,0,0,0,{"$f":"IF(F4<>0, IF(J4/F4*100=0, \"-\", J4/F4*100), \" \")","v":" "},{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":" "},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "}]
[]
[null,null,null,"PC implemented","Date","Population targeted for T2",null,null,null,"Population treated",null,null,null,"Programme coverage (%)"]
["Country","Province/State","District",null,null,"PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"East"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Bugesera"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,{"$f":"SUM(F9:H9)","v":0},null,null,null,{"$f":"SUM(J9:L9)","v":0},{"$f":"IF(F9<>0, IF(J9/F9*100=0, \"-\", J9/F9*100), \" \")","v":" "},{"$f":"IF(G9<>0, IF(K9/G9*100=0, \"-\", K9/G9*100), \" \")","v":" "},{"$f":"IF(H9<>0, IF(L9/H9*100=0, \"-\", L9/H9*100), \" \")","v":" "},{"$f":"IF(I9<>0, IF(M9/I9*100=0, \"-\", M9/I9*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"North"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Burera"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,{"$f":"SUM(F10:H10)","v":0},null,null,null,{"$f":"SUM(J10:L10)","v":0},{"$f":"IF(F10<>0, IF(J10/F10*100=0, \"-\", J10/F10*100), \" \")","v":" "},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":" "},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"North"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Gakenke"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Gasabo"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"East"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Gatsibo"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"North"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Gicumbi"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"South"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Gisagara"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16)","v":"South"},{"$f":"IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16)","v":"Huye"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17)","v":"South"},{"$f":"IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17)","v":"Kamonyi"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18)","v":"West"},{"$f":"IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18)","v":"Karongi"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19)","v":"East"},{"$f":"IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19)","v":"Kayonza"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20)","v":"Kicukiro"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21)","v":"East"},{"$f":"IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21)","v":"Kirehe"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22)","v":"South"},{"$f":"IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22)","v":"Muhanga"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23)","v":"North"},{"$f":"IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23)","v":"Musanze"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24)","v":"East"},{"$f":"IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24)","v":"Ngoma"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25)","v":"West"},{"$f":"IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25)","v":"Ngororero"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26)","v":"West"},{"$f":"IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26)","v":"Nyabihu"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27)","v":"East"},{"$f":"IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27)","v":"Nyagatare"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28)","v":"South"},{"$f":"IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28)","v":"Nyamagabe"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29)","v":"West"},{"$f":"IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29)","v":"Nyamasheke"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30)","v":"South"},{"$f":"IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30)","v":"Nyanza"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31)","v":"Nyarugenge"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32)","v":"South"},{"$f":"IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32)","v":"Nyaruguru"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33)","v":"West"},{"$f":"IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33)","v":"Rubavu"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34)","v":"South"},{"$f":"IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34)","v":"Ruhango"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35)","v":"North"},{"$f":"IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35)","v":"Rulindo"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36)","v":"West"},{"$f":"IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36)","v":"Rusizi"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37)","v":"West"},{"$f":"IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37)","v":"Rutsiro"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38)","v":"East"},{"$f":"IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38)","v":"Rwamagana"},{"$f":"IF(COUNTRY_INFO!$R$9:$R$1000=\"T2 (PZQ)\", COUNTRY_INFO!$R$9:$R$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]

{"sheet":"T3_R1","index":5,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,6,5,9],[5,10,5,13],[5,14,5,17],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,5,6,5],[5,4,6,4]]}
["T 3 - Albendazole (ALB) or Mebendazole (MBD) - Round 1"]
["Administrative structure, population requiring PC by age group, population treated by age group and coverage"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":1375888},3317376,0,4693264,1412841,3323164,0,4736005,{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":102.68575639877665},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":100.17447524790677},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "},{"$f":"IF(J4<>0, IF(N4/J4*100=0, \"-\", N4/J4*100), \" \")","v":100.91068816925706}]
[]
[null,null,null,"PC implemented","Medicine","Date","Population targeted for T3",null,null,null,"Population treated",null,null,null,"Programme coverage (%)"]
["Country","Province/State","District",null,null,null,"PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"East"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Bugesera"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",52938,113496,null,{"$f":"SUM(G9:I9)","v":166434},43372,115275,null,{"$f":"SUM(K9:M9)","v":158647},{"$f":"IF(G9<>0, IF(K9/G9*100=0, \"-\", K9/G9*100), \" \")","v":81.929804677169514},{"$f":"IF(H9<>0, IF(L9/H9*100=0, \"-\", L9/H9*100), \" \")","v":101.56745612180164},{"$f":"IF(I9<>0, IF(M9/I9*100=0, \"-\", M9/I9*100), \" \")","v":" "},{"$f":"IF(J9<>0, IF(N9/J9*100=0, \"-\", N9/J9*100), \" \")","v":95.321268490813168}]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"North"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Burera"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",40281,121217,null,{"$f":"SUM(G10:I10)","v":161498},45670,119538,null,{"$f":"SUM(K10:M10)","v":165208},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":113.37851592562249},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":98.614880751049768},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "},{"$f":"IF(J10<>0, IF(N10/J10*100=0, \"-\", N10/J10*100), \" \")","v":102.29724207110924}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"North"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Gakenke"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",39355,110193,null,149548,40183,93310,null,133493,102.10392580358277,84.678700098917361," ",89.264316473640577]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Gasabo"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",66311,127927,null,194238,65600,138672,null,204272,98.927779704724699,108.39932148803615," ",105.16582748998651]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"East"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Gatsibo"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",59500,147311,null,206811,60627,134253,null,194880,101.89411764705882,91.135760398069394," ",94.230964503822335]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"North"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Gicumbi"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",46030,135460,null,181490,45980,113698,null,159678,99.891375190093413,83.934740882917467," ",87.981706981100885]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"South"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Gisagara"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",47174,102210,null,149384,41179,97531,null,138710,87.291728494509684,95.422170042070249," ",92.854656455845344]
[{"$f":"IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16)","v":"South"},{"$f":"IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16)","v":"Huye"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",41121,95708,null,136829,40211,105260,null,145471,97.787018798180981,109.98035691896185," ",106.31591256239541]
[{"$f":"IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17)","v":"South"},{"$f":"IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17)","v":"Kamonyi"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",43014,105649,null,148663,42772,103455,null,146227,99.437392476867998,97.923312099499284," ",98.361394563543044]
[{"$f":"IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18)","v":"West"},{"$f":"IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18)","v":"Karongi"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",42652,109203,null,151855,44363,111554,null,155917,104.01153521523024,102.15287125811562," ",102.67492015409437]
[{"$f":"IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19)","v":"East"},{"$f":"IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19)","v":"Kayonza"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",47671,114411,null,162082,53662,116177,null,169839,112.56738897862432,101.54355787467988," ",104.7858491380906]
[{"$f":"IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20)","v":"Kicukiro"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",35654,78015,null,113669,45083,91187,null,136270,126.44584057889719,116.88393257706851," ",119.88316955370418]
[{"$f":"IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21)","v":"East"},{"$f":"IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21)","v":"Kirehe"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",47146,113906,null,161052,46658,114859,null,161517,98.964917490349123,100.8366547855249," ",100.28872662245733]
[{"$f":"IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22)","v":"South"},{"$f":"IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22)","v":"Muhanga"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",36426,98668,null,135094,37404,93645,null,131049,102.68489540438148,94.909190416345723," ",97.00578856203829]
[{"$f":"IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23)","v":"North"},{"$f":"IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23)","v":"Musanze"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",44889,120385,null,165274,47892,126987,null,174879,106.68983492615118,105.48407193587241," ",105.81156140711786]
[{"$f":"IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24)","v":"East"},{"$f":"IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24)","v":"Ngoma"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",60111,105287,null,165398,55010,110250,null,165260,91.514032373442461,104.71378232830264," ",99.916564891957577]
[{"$f":"IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25)","v":"West"},{"$f":"IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25)","v":"Ngororero"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",44376,113897,null,158273,48443,108221,null,156664,109.16486389039119,95.01655004082636," ",98.983402096377787]
[{"$f":"IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26)","v":"West"},{"$f":"IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26)","v":"Nyabihu"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",38540,102882,null,141422,44860,92654,null,137514,116.39854696419305,90.05851363698217," ",97.23663927818869]
[{"$f":"IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27)","v":"East"},{"$f":"IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27)","v":"Nyagatare"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",64528,158998,null,223526,69528,158078,null,227606,107.74857426233572,99.421376369514078," ",101.82529101759974]
[{"$f":"IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28)","v":"South"},{"$f":"IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28)","v":"Nyamagabe"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",42382,116173,null,158555,40595,117566,null,158161,95.783587371997541,101.19907379511591," ",99.751505786635548]
[{"$f":"IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29)","v":"West"},{"$f":"IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29)","v":"Nyamasheke"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",51194,110849,null,162043,54821,125601,null,180422,107.08481462671406,113.30819402971611," ",111.342051183945]
[{"$f":"IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30)","v":"South"},{"$f":"IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30)","v":"Nyanza"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",43047,95061,null,138108,40923,103094,null,144017,95.065858247961529,108.45036345083683," ",104.27853563877545]
[{"$f":"IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31)","v":"Nyarugenge"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",32794,69057,null,101851,41553,80124,null,121677,126.70915411355736,116.02589165472001," ",119.46569007668064]
[{"$f":"IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32)","v":"South"},{"$f":"IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32)","v":"Nyaruguru"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",38161,104371,null,142532,38708,93067,null,131775,101.43340059222767,89.169405294574162," ",92.452922852412087]
[{"$f":"IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33)","v":"West"},{"$f":"IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33)","v":"Rubavu"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",57255,120773,null,178028,55916,125105,null,181021,97.6613396209938,103.58689442176644," ",101.68119621632552]
[{"$f":"IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34)","v":"South"},{"$f":"IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34)","v":"Ruhango"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",41119,101734,null,142853,43095,105357,null,148452,104.80556433765413,103.56124796036723," ",103.91941366299622]
[{"$f":"IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35)","v":"North"},{"$f":"IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35)","v":"Rulindo"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",33473,91811,null,125284,39412,92936,null,132348,117.74265826188271,101.22534336844168," ",105.6383895788768]
[{"$f":"IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36)","v":"West"},{"$f":"IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36)","v":"Rusizi"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",54637,127042,null,181679,57624,129839,null,187463,105.4669912330472,102.20163410525653," ",103.18363707418028]
[{"$f":"IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37)","v":"West"},{"$f":"IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37)","v":"Rutsiro"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",41732,112244,null,153976,40867,102649,null,143516,97.927250071887286,91.45165888599837," ",93.206733516911726]
[{"$f":"IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38)","v":"East"},{"$f":"IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38)","v":"Rwamagana"},{"$f":"IF(OR(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":"T3 (ALB/MBD)"},null,"26 - 29 Apr 2016",42377,93438,null,135815,40830,103222,null,144052,96.349434834934044,110.47111453584195," ",106.06486765084857]

{"sheet":"T3_R2","index":6,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,6,5,9],[5,10,5,13],[5,14,5,17],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,5,6,5],[5,4,6,4]]}
["T 3 - Albendazole (ALB) or Mebendazole (MBD) - Round 2"]
["Administrative structure, population requiring PC by age group, population treated by age group and coverage"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":0},0,0,0,0,0,0,0,{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":" "},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "},{"$f":"IF(J4<>0, IF(N4/J4*100=0, \"-\", N4/J4*100), \" \")","v":" "}]
[]
[null,null,null,"PC implemented","Medicine","Date","Population targeted for T3",null,null,null,"Population treated",null,null,null,"Programme coverage (%)"]
["Country","Province/State","District",null,null,null,"PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"East"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Bugesera"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,{"$f":"SUM(G9:I9)","v":0},null,null,null,{"$f":"SUM(K9:M9)","v":0},{"$f":"IF(G9<>0, IF(K9/G9*100=0, \"-\", K9/G9*100), \" \")","v":" "},{"$f":"IF(H9<>0, IF(L9/H9*100=0, \"-\", L9/H9*100), \" \")","v":" "},{"$f":"IF(I9<>0, IF(M9/I9*100=0, \"-\", M9/I9*100), \" \")","v":" "},{"$f":"IF(J9<>0, IF(N9/J9*100=0, \"-\", N9/J9*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"North"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Burera"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,{"$f":"SUM(G10:I10)","v":0},null,null,null,{"$f":"SUM(K10:M10)","v":0},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":" "},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "},{"$f":"IF(J10<>0, IF(N10/J10*100=0, \"-\", N10/J10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"North"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Gakenke"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Gasabo"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"East"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Gatsibo"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"North"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Gicumbi"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"South"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Gisagara"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16)","v":"South"},{"$f":"IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16)","v":"Huye"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17)","v":"South"},{"$f":"IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17)","v":"Kamonyi"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18)","v":"West"},{"$f":"IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18)","v":"Karongi"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19)","v":"East"},{"$f":"IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19)","v":"Kayonza"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20)","v":"Kicukiro"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21)","v":"East"},{"$f":"IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21)","v":"Kirehe"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22)","v":"South"},{"$f":"IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22)","v":"Muhanga"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23)","v":"North"},{"$f":"IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23)","v":"Musanze"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24)","v":"East"},{"$f":"IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24)","v":"Ngoma"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25)","v":"West"},{"$f":"IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25)","v":"Ngororero"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26)","v":"West"},{"$f":"IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26)","v":"Nyabihu"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27)","v":"East"},{"$f":"IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27)","v":"Nyagatare"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28)","v":"South"},{"$f":"IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28)","v":"Nyamagabe"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29)","v":"West"},{"$f":"IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29)","v":"Nyamasheke"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30)","v":"South"},{"$f":"IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30)","v":"Nyanza"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31)","v":"Nyarugenge"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32)","v":"South"},{"$f":"IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32)","v":"Nyaruguru"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33)","v":"West"},{"$f":"IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33)","v":"Rubavu"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34)","v":"South"},{"$f":"IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34)","v":"Ruhango"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35)","v":"North"},{"$f":"IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35)","v":"Rulindo"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36)","v":"West"},{"$f":"IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36)","v":"Rusizi"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37)","v":"West"},{"$f":"IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37)","v":"Rutsiro"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38)","v":"East"},{"$f":"IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38)","v":"Rwamagana"},{"$f":"IF(AND(COUNTRY_INFO!$Q$9:$Q$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$R$9:$R$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},"ALB",null,null,null,null,0,null,null,null,0," "," "," "," "]

{"sheet":"DISTRICT","index":7,"n_rows":38,"n_cols":21,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,0,3,2],[5,0,5,2],[5,4,5,8],[5,10,5,14],[5,16,5,20],[5,3,6,3],[5,9,6,9],[5,15,6,15]]}
["Number of individuals treated"]
["Administrative structure, population treated by age group and gender"]
[]
["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},{"$f":"SUM(H$9:H$1000)","v":0},{"$f":"IF(D4>0, IF(H4/D4*100<>0, H4/D4*100, \"-\"),0)","v":0},{"$f":"SUM(J$9:J$1000)","v":4338846},{"$f":"SUM(K$9:K$1000)","v":0},{"$f":"SUM(L$9:L$1000)","v":0},{"$f":"SUM(M$9:M$1000)","v":4736005},{"$f":"SUM(N$9:N$1000)","v":4262252},{"$f":"IF(J4>0, IF(N4/J4*100<>0, N4/J4*100, \"-\"),0)","v":98.234691897338593},{"$f":"SUM(P$9:P$1000)","v":1788628.0400000003},{"$f":"SUM(Q$9:Q$1000)","v":0},{"$f":"SUM(R$9:R$1000)","v":0},{"$f":"SUM(S$9:S$1000)","v":0},{"$f":"SUM(T$9:T$1000)","v":0},{"$f":"IF(P4>0, IF(T4/P4*100<>0, T4/P4*100, \"-\"),0)","v":"-"}]
[]
[null,null,null,"Population requiring PC for LF","Population treated for lymphatic filariasis",null,null,null,null,"Population requiring PC for STH","Population treated for STH",null,null,null,null,"Population requiring PC for SCH","Population treated for schistosomiasis"]
["Country","Province/State","District",null,"Male","Female","Total treated","Total treated in need of PC","(%)",null,"Male","Female","Total treated","Total treated in need of PC","(%)",null,"Male","Female","Total treated","Total treated in need of PC","(%)"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"East"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Bugesera"},{"$f":"COUNTRY_INFO!K9","v":"Not required"},null,null,{"$f":"'MDA2'!M9","v":0},{"$f":"IF(AND(COUNTRY_INFO!H9>0,COUNTRY_INFO!H9<4),IF(D9>'MDA2'!M9,'MDA2'!M9,D9),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H9>0,COUNTRY_INFO!H9<4), IF(G9/D9*100<>0, IF(G9/D9*100>100,100,G9/D9*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L9","v":162424},null,null,{"$f":"SUM(MAX('MDA2'!J9, 'T1'!L9, MAX(T3_R1!K9, T3_R2!K9)), MAX('MDA2'!K9, 'T1'!M9, MAX(T3_R1!L9, T3_R2!L9)), MAX('MDA2'!L9, 'T1'!N9, MAX(T3_R1!M9, T3_R2!M9)))","v":158647},{"$f":"IF(AND(COUNTRY_INFO!I9>1,COUNTRY_INFO!I9<4),IF(J9>SUM(MAX('MDA2'!J9,MAX(T3_R1!K9,T3_R2!K9)),MAX('MDA2'!K9,'T1'!M9,MAX(T3_R1!L9,T3_R2!L9))),SUM(MAX('MDA2'!J9,MAX(T3_R1!K9,T3_R2!K9)),MAX('MDA2'!K9,'T1'!M9,MAX(T3_R1!L9,T3_R2!L9))),J9),0)","v":158647},{"$f":"IF(AND(COUNTRY_INFO!I9>1,COUNTRY_INFO!I9<4), IF(M9/J9*100<>0, IF(N9/J9*100>100,100,N9/J9*100), \"-\"),0)","v":97.674604738216033},{"$f":"COUNTRY_INFO!M9","v":103149.6},null,null,{"$f":"MAX(SUM('T1'!L9:'T1'!N9),SUM('T2'!J9:'T2'!L9))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J9>0,COUNTRY_INFO!J9<4),IF(P9>MAX('T1'!M9,'T2'!M9),MAX('T1'!M9,'T2'!M9),P9),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J9>0,COUNTRY_INFO!J9<4), IF(S9/P9*100<>0, IF(T9/P9*100>100,100,T9/P9*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"North"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Burera"},{"$f":"COUNTRY_INFO!K10","v":"Not required"},null,null,{"$f":"'MDA2'!M10","v":0},{"$f":"IF(AND(COUNTRY_INFO!H10>0,COUNTRY_INFO!H10<4),IF(D10>'MDA2'!M10,'MDA2'!M10,D10),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H10>0,COUNTRY_INFO!H10<4), IF(G10/D10*100<>0, IF(G10/D10*100>100,100,G10/D10*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L10","v":151055},null,null,{"$f":"SUM(MAX('MDA2'!J10, 'T1'!L10, MAX(T3_R1!K10, T3_R2!K10)), MAX('MDA2'!K10, 'T1'!M10, MAX(T3_R1!L10, T3_R2!L10)), MAX('MDA2'!L10, 'T1'!N10, MAX(T3_R1!M10, T3_R2!M10)))","v":165208},{"$f":"IF(AND(COUNTRY_INFO!I10>1,COUNTRY_INFO!I10<4),IF(J10>SUM(MAX('MDA2'!J10,MAX(T3_R1!K10,T3_R2!K10)),MAX('MDA2'!K10,'T1'!M10,MAX(T3_R1!L10,T3_R2!L10))),SUM(MAX('MDA2'!J10,MAX(T3_R1!K10,T3_R2!K10)),MAX('MDA2'!K10,'T1'!M10,MAX(T3_R1!L10,T3_R2!L10))),J10),0)","v":151055},{"$f":"IF(AND(COUNTRY_INFO!I10>1,COUNTRY_INFO!I10<4), IF(M10/J10*100<>0, IF(N10/J10*100>100,100,N10/J10*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M10","v":95929.3},null,null,{"$f":"MAX(SUM('T1'!L10:'T1'!N10),SUM('T2'!J10:'T2'!L10))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J10>0,COUNTRY_INFO!J10<4),IF(P10>MAX('T1'!M10,'T2'!M10),MAX('T1'!M10,'T2'!M10),P10),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J10>0,COUNTRY_INFO!J10<4), IF(S10/P10*100<>0, IF(T10/P10*100>100,100,T10/P10*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"North"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Gakenke"},{"$f":"COUNTRY_INFO!K11","v":"Not required"},null,null,{"$f":"'MDA2'!M11","v":0},{"$f":"IF(AND(COUNTRY_INFO!H11>0,COUNTRY_INFO!H11<4),IF(D11>'MDA2'!M11,'MDA2'!M11,D11),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H11>0,COUNTRY_INFO!H11<4), IF(G11/D11*100<>0, IF(G11/D11*100>100,100,G11/D11*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L11","v":151796},null,null,{"$f":"SUM(MAX('MDA2'!J11, 'T1'!L11, MAX(T3_R1!K11, T3_R2!K11)), MAX('MDA2'!K11, 'T1'!M11, MAX(T3_R1!L11, T3_R2!L11)), MAX('MDA2'!L11, 'T1'!N11, MAX(T3_R1!M11, T3_R2!M11)))","v":133493},{"$f":"IF(AND(COUNTRY_INFO!I11>1,COUNTRY_INFO!I11<4),IF(J11>SUM(MAX('MDA2'!J11,MAX(T3_R1!K11,T3_R2!K11)),MAX('MDA2'!K11,'T1'!M11,MAX(T3_R1!L11,T3_R2!L11))),SUM(MAX('MDA2'!J11,MAX(T3_R1!K11,T3_R2!K11)),MAX('MDA2'!K11,'T1'!M11,MAX(T3_R1!L11,T3_R2!L11))),J11),0)","v":133493},{"$f":"IF(AND(COUNTRY_INFO!I11>1,COUNTRY_INFO!I11<4), IF(M11/J11*100<>0, IF(N11/J11*100>100,100,N11/J11*100), \"-\"),0)","v":87.942370022925502},{"$f":"COUNTRY_INFO!M11","v":96400},null,null,{"$f":"MAX(SUM('T1'!L11:'T1'!N11),SUM('T2'!J11:'T2'!L11))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J11>0,COUNTRY_INFO!J11<4),IF(P11>MAX('T1'!M11,'T2'!M11),MAX('T1'!M11,'T2'!M11),P11),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J11>0,COUNTRY_INFO!J11<4), IF(S11/P11*100<>0, IF(T11/P11*100>100,100,T11/P11*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Gasabo"},{"$f":"COUNTRY_INFO!K12","v":"Not required"},null,null,{"$f":"'MDA2'!M12","v":0},{"$f":"IF(AND(COUNTRY_INFO!H12>0,COUNTRY_INFO!H12<4),IF(D12>'MDA2'!M12,'MDA2'!M12,D12),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H12>0,COUNTRY_INFO!H12<4), IF(G12/D12*100<>0, IF(G12/D12*100>100,100,G12/D12*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L12","v":0},null,null,{"$f":"SUM(MAX('MDA2'!J12, 'T1'!L12, MAX(T3_R1!K12, T3_R2!K12)), MAX('MDA2'!K12, 'T1'!M12, MAX(T3_R1!L12, T3_R2!L12)), MAX('MDA2'!L12, 'T1'!N12, MAX(T3_R1!M12, T3_R2!M12)))","v":204272},{"$f":"IF(AND(COUNTRY_INFO!I12>1,COUNTRY_INFO!I12<4),IF(J12>SUM(MAX('MDA2'!J12,MAX(T3_R1!K12,T3_R2!K12)),MAX('MDA2'!K12,'T1'!M12,MAX(T3_R1!L12,T3_R2!L12))),SUM(MAX('MDA2'!J12,MAX(T3_R1!K12,T3_R2!K12)),MAX('MDA2'!K12,'T1'!M12,MAX(T3_R1!L12,T3_R2!L12))),J12),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I12>1,COUNTRY_INFO!I12<4), IF(M12/J12*100<>0, IF(N12/J12*100>100,100,N12/J12*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!M12","v":55771.32},null,null,{"$f":"MAX(SUM('T1'!L12:'T1'!N12),SUM('T2'!J12:'T2'!L12))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J12>0,COUNTRY_INFO!J12<4),IF(P12>MAX('T1'!M12,'T2'!M12),MAX('T1'!M12,'T2'!M12),P12),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J12>0,COUNTRY_INFO!J12<4), IF(S12/P12*100<>0, IF(T12/P12*100>100,100,T12/P12*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"East"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Gatsibo"},{"$f":"COUNTRY_INFO!K13","v":"Not required"},null,null,{"$f":"'MDA2'!M13","v":0},{"$f":"IF(AND(COUNTRY_INFO!H13>0,COUNTRY_INFO!H13<4),IF(D13>'MDA2'!M13,'MDA2'!M13,D13),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H13>0,COUNTRY_INFO!H13<4), IF(G13/D13*100<>0, IF(G13/D13*100>100,100,G13/D13*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L13","v":194335},null,null,{"$f":"SUM(MAX('MDA2'!J13, 'T1'!L13, MAX(T3_R1!K13, T3_R2!K13)), MAX('MDA2'!K13, 'T1'!M13, MAX(T3_R1!L13, T3_R2!L13)), MAX('MDA2'!L13, 'T1'!N13, MAX(T3_R1!M13, T3_R2!M13)))","v":194880},{"$f":"IF(AND(COUNTRY_INFO!I13>1,COUNTRY_INFO!I13<4),IF(J13>SUM(MAX('MDA2'!J13,MAX(T3_R1!K13,T3_R2!K13)),MAX('MDA2'!K13,'T1'!M13,MAX(T3_R1!L13,T3_R2!L13))),SUM(MAX('MDA2'!J13,MAX(T3_R1!K13,T3_R2!K13)),MAX('MDA2'!K13,'T1'!M13,MAX(T3_R1!L13,T3_R2!L13))),J13),0)","v":194335},{"$f":"IF(AND(COUNTRY_INFO!I13>1,COUNTRY_INFO!I13<4), IF(M13/J13*100<>0, IF(N13/J13*100>100,100,N13/J13*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M13","v":0},null,null,{"$f":"MAX(SUM('T1'!L13:'T1'!N13),SUM('T2'!J13:'T2'!L13))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J13>0,COUNTRY_INFO!J13<4),IF(P13>MAX('T1'!M13,'T2'!M13),MAX('T1'!M13,'T2'!M13),P13),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J13>0,COUNTRY_INFO!J13<4), IF(S13/P13*100<>0, IF(T13/P13*100>100,100,T13/P13*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"North"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Gicumbi"},{"$f":"COUNTRY_INFO!K14","v":"Not required"},null,null,{"$f":"'MDA2'!M14","v":0},{"$f":"IF(AND(COUNTRY_INFO!H14>0,COUNTRY_INFO!H14<4),IF(D14>'MDA2'!M14,'MDA2'!M14,D14),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H14>0,COUNTRY_INFO!H14<4), IF(G14/D14*100<>0, IF(G14/D14*100>100,100,G14/D14*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L14","v":177545},null,null,{"$f":"SUM(MAX('MDA2'!J14, 'T1'!L14, MAX(T3_R1!K14, T3_R2!K14)), MAX('MDA2'!K14, 'T1'!M14, MAX(T3_R1!L14, T3_R2!L14)), MAX('MDA2'!L14, 'T1'!N14, MAX(T3_R1!M14, T3_R2!M14)))","v":159678},{"$f":"IF(AND(COUNTRY_INFO!I14>1,COUNTRY_INFO!I14<4),IF(J14>SUM(MAX('MDA2'!J14,MAX(T3_R1!K14,T3_R2!K14)),MAX('MDA2'!K14,'T1'!M14,MAX(T3_R1!L14,T3_R2!L14))),SUM(MAX('MDA2'!J14,MAX(T3_R1!K14,T3_R2!K14)),MAX('MDA2'!K14,'T1'!M14,MAX(T3_R1!L14,T3_R2!L14))),J14),0)","v":159678},{"$f":"IF(AND(COUNTRY_INFO!I14>1,COUNTRY_INFO!I14<4), IF(M14/J14*100<>0, IF(N14/J14*100>100,100,N14/J14*100), \"-\"),0)","v":89.93663578247768},{"$f":"COUNTRY_INFO!M14","v":374378},null,null,{"$f":"MAX(SUM('T1'!L14:'T1'!N14),SUM('T2'!J14:'T2'!L14))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J14>0,COUNTRY_INFO!J14<4),IF(P14>MAX('T1'!M14,'T2'!M14),MAX('T1'!M14,'T2'!M14),P14),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J14>0,COUNTRY_INFO!J14<4), IF(S14/P14*100<>0, IF(T14/P14*100>100,100,T14/P14*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"South"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Gisagara"},{"$f":"COUNTRY_INFO!K15","v":"Not required"},null,null,{"$f":"'MDA2'!M15","v":0},{"$f":"IF(AND(COUNTRY_INFO!H15>0,COUNTRY_INFO!H15<4),IF(D15>'MDA2'!M15,'MDA2'!M15,D15),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H15>0,COUNTRY_INFO!H15<4), IF(G15/D15*100<>0, IF(G15/D15*100>100,100,G15/D15*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L15","v":144738},null,null,{"$f":"SUM(MAX('MDA2'!J15, 'T1'!L15, MAX(T3_R1!K15, T3_R2!K15)), MAX('MDA2'!K15, 'T1'!M15, MAX(T3_R1!L15, T3_R2!L15)), MAX('MDA2'!L15, 'T1'!N15, MAX(T3_R1!M15, T3_R2!M15)))","v":138710},{"$f":"IF(AND(COUNTRY_INFO!I15>1,COUNTRY_INFO!I15<4),IF(J15>SUM(MAX('MDA2'!J15,MAX(T3_R1!K15,T3_R2!K15)),MAX('MDA2'!K15,'T1'!M15,MAX(T3_R1!L15,T3_R2!L15))),SUM(MAX('MDA2'!J15,MAX(T3_R1!K15,T3_R2!K15)),MAX('MDA2'!K15,'T1'!M15,MAX(T3_R1!L15,T3_R2!L15))),J15),0)","v":138710},{"$f":"IF(AND(COUNTRY_INFO!I15>1,COUNTRY_INFO!I15<4), IF(M15/J15*100<>0, IF(N15/J15*100>100,100,N15/J15*100), \"-\"),0)","v":95.835233318133447},{"$f":"COUNTRY_INFO!M15","v":33965.25},null,null,{"$f":"MAX(SUM('T1'!L15:'T1'!N15),SUM('T2'!J15:'T2'!L15))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J15>0,COUNTRY_INFO!J15<4),IF(P15>MAX('T1'!M15,'T2'!M15),MAX('T1'!M15,'T2'!M15),P15),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J15>0,COUNTRY_INFO!J15<4), IF(S15/P15*100<>0, IF(T15/P15*100>100,100,T15/P15*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16)","v":"South"},{"$f":"IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16)","v":"Huye"},{"$f":"COUNTRY_INFO!K16","v":"Not required"},null,null,{"$f":"'MDA2'!M16","v":0},{"$f":"IF(AND(COUNTRY_INFO!H16>0,COUNTRY_INFO!H16<4),IF(D16>'MDA2'!M16,'MDA2'!M16,D16),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H16>0,COUNTRY_INFO!H16<4), IF(G16/D16*100<>0, IF(G16/D16*100>100,100,G16/D16*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L16","v":147382},null,null,{"$f":"SUM(MAX('MDA2'!J16, 'T1'!L16, MAX(T3_R1!K16, T3_R2!K16)), MAX('MDA2'!K16, 'T1'!M16, MAX(T3_R1!L16, T3_R2!L16)), MAX('MDA2'!L16, 'T1'!N16, MAX(T3_R1!M16, T3_R2!M16)))","v":145471},{"$f":"IF(AND(COUNTRY_INFO!I16>1,COUNTRY_INFO!I16<4),IF(J16>SUM(MAX('MDA2'!J16,MAX(T3_R1!K16,T3_R2!K16)),MAX('MDA2'!K16,'T1'!M16,MAX(T3_R1!L16,T3_R2!L16))),SUM(MAX('MDA2'!J16,MAX(T3_R1!K16,T3_R2!K16)),MAX('MDA2'!K16,'T1'!M16,MAX(T3_R1!L16,T3_R2!L16))),J16),0)","v":145471},{"$f":"IF(AND(COUNTRY_INFO!I16>1,COUNTRY_INFO!I16<4), IF(M16/J16*100<>0, IF(N16/J16*100>100,100,N16/J16*100), \"-\"),0)","v":98.703369475241203},{"$f":"COUNTRY_INFO!M16","v":0},null,null,{"$f":"MAX(SUM('T1'!L16:'T1'!N16),SUM('T2'!J16:'T2'!L16))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J16>0,COUNTRY_INFO!J16<4),IF(P16>MAX('T1'!M16,'T2'!M16),MAX('T1'!M16,'T2'!M16),P16),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J16>0,COUNTRY_INFO!J16<4), IF(S16/P16*100<>0, IF(T16/P16*100>100,100,T16/P16*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17)","v":"South"},{"$f":"IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17)","v":"Kamonyi"},{"$f":"COUNTRY_INFO!K17","v":"Not required"},null,null,{"$f":"'MDA2'!M17","v":0},{"$f":"IF(AND(COUNTRY_INFO!H17>0,COUNTRY_INFO!H17<4),IF(D17>'MDA2'!M17,'MDA2'!M17,D17),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H17>0,COUNTRY_INFO!H17<4), IF(G17/D17*100<>0, IF(G17/D17*100>100,100,G17/D17*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L17","v":152814},null,null,{"$f":"SUM(MAX('MDA2'!J17, 'T1'!L17, MAX(T3_R1!K17, T3_R2!K17)), MAX('MDA2'!K17, 'T1'!M17, MAX(T3_R1!L17, T3_R2!L17)), MAX('MDA2'!L17, 'T1'!N17, MAX(T3_R1!M17, T3_R2!M17)))","v":146227},{"$f":"IF(AND(COUNTRY_INFO!I17>1,COUNTRY_INFO!I17<4),IF(J17>SUM(MAX('MDA2'!J17,MAX(T3_R1!K17,T3_R2!K17)),MAX('MDA2'!K17,'T1'!M17,MAX(T3_R1!L17,T3_R2!L17))),SUM(MAX('MDA2'!J17,MAX(T3_R1!K17,T3_R2!K17)),MAX('MDA2'!K17,'T1'!M17,MAX(T3_R1!L17,T3_R2!L17))),J17),0)","v":146227},{"$f":"IF(AND(COUNTRY_INFO!I17>1,COUNTRY_INFO!I17<4), IF(M17/J17*100<>0, IF(N17/J17*100>100,100,N17/J17*100), \"-\"),0)","v":95.689531063907765},{"$f":"COUNTRY_INFO!M17","v":0},null,null,{"$f":"MAX(SUM('T1'!L17:'T1'!N17),SUM('T2'!J17:'T2'!L17))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J17>0,COUNTRY_INFO!J17<4),IF(P17>MAX('T1'!M17,'T2'!M17),MAX('T1'!M17,'T2'!M17),P17),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J17>0,COUNTRY_INFO!J17<4), IF(S17/P17*100<>0, IF(T17/P17*100>100,100,T17/P17*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18)","v":"West"},{"$f":"IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18)","v":"Karongi"},{"$f":"COUNTRY_INFO!K18","v":"Not required"},null,null,{"$f":"'MDA2'!M18","v":0},{"$f":"IF(AND(COUNTRY_INFO!H18>0,COUNTRY_INFO!H18<4),IF(D18>'MDA2'!M18,'MDA2'!M18,D18),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H18>0,COUNTRY_INFO!H18<4), IF(G18/D18*100<>0, IF(G18/D18*100>100,100,G18/D18*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L18","v":148913},null,null,{"$f":"SUM(MAX('MDA2'!J18, 'T1'!L18, MAX(T3_R1!K18, T3_R2!K18)), MAX('MDA2'!K18, 'T1'!M18, MAX(T3_R1!L18, T3_R2!L18)), MAX('MDA2'!L18, 'T1'!N18, MAX(T3_R1!M18, T3_R2!M18)))","v":155917},{"$f":"IF(AND(COUNTRY_INFO!I18>1,COUNTRY_INFO!I18<4),IF(J18>SUM(MAX('MDA2'!J18,MAX(T3_R1!K18,T3_R2!K18)),MAX('MDA2'!K18,'T1'!M18,MAX(T3_R1!L18,T3_R2!L18))),SUM(MAX('MDA2'!J18,MAX(T3_R1!K18,T3_R2!K18)),MAX('MDA2'!K18,'T1'!M18,MAX(T3_R1!L18,T3_R2!L18))),J18),0)","v":148913},{"$f":"IF(AND(COUNTRY_INFO!I18>1,COUNTRY_INFO!I18<4), IF(M18/J18*100<>0, IF(N18/J18*100>100,100,N18/J18*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M18","v":34945.020000000004},null,null,{"$f":"MAX(SUM('T1'!L18:'T1'!N18),SUM('T2'!J18:'T2'!L18))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J18>0,COUNTRY_INFO!J18<4),IF(P18>MAX('T1'!M18,'T2'!M18),MAX('T1'!M18,'T2'!M18),P18),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J18>0,COUNTRY_INFO!J18<4), IF(S18/P18*100<>0, IF(T18/P18*100>100,100,T18/P18*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19)","v":"East"},{"$f":"IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19)","v":"Kayonza"},{"$f":"COUNTRY_INFO!K19","v":"Not required"},null,null,{"$f":"'MDA2'!M19","v":0},{"$f":"IF(AND(COUNTRY_INFO!H19>0,COUNTRY_INFO!H19<4),IF(D19>'MDA2'!M19,'MDA2'!M19,D19),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H19>0,COUNTRY_INFO!H19<4), IF(G19/D19*100<>0, IF(G19/D19*100>100,100,G19/D19*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L19","v":154454},null,null,{"$f":"SUM(MAX('MDA2'!J19, 'T1'!L19, MAX(T3_R1!K19, T3_R2!K19)), MAX('MDA2'!K19, 'T1'!M19, MAX(T3_R1!L19, T3_R2!L19)), MAX('MDA2'!L19, 'T1'!N19, MAX(T3_R1!M19, T3_R2!M19)))","v":169839},{"$f":"IF(AND(COUNTRY_INFO!I19>1,COUNTRY_INFO!I19<4),IF(J19>SUM(MAX('MDA2'!J19,MAX(T3_R1!K19,T3_R2!K19)),MAX('MDA2'!K19,'T1'!M19,MAX(T3_R1!L19,T3_R2!L19))),SUM(MAX('MDA2'!J19,MAX(T3_R1!K19,T3_R2!K19)),MAX('MDA2'!K19,'T1'!M19,MAX(T3_R1!L19,T3_R2!L19))),J19),0)","v":154454},{"$f":"IF(AND(COUNTRY_INFO!I19>1,COUNTRY_INFO!I19<4), IF(M19/J19*100<>0, IF(N19/J19*100>100,100,N19/J19*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M19","v":0},null,null,{"$f":"MAX(SUM('T1'!L19:'T1'!N19),SUM('T2'!J19:'T2'!L19))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J19>0,COUNTRY_INFO!J19<4),IF(P19>MAX('T1'!M19,'T2'!M19),MAX('T1'!M19,'T2'!M19),P19),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J19>0,COUNTRY_INFO!J19<4), IF(S19/P19*100<>0, IF(T19/P19*100>100,100,T19/P19*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20)","v":"Kicukiro"},{"$f":"COUNTRY_INFO!K20","v":"Not required"},null,null,{"$f":"'MDA2'!M20","v":0},{"$f":"IF(AND(COUNTRY_INFO!H20>0,COUNTRY_INFO!H20<4),IF(D20>'MDA2'!M20,'MDA2'!M20,D20),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H20>0,COUNTRY_INFO!H20<4), IF(G20/D20*100<>0, IF(G20/D20*100>100,100,G20/D20*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L20","v":0},null,null,{"$f":"SUM(MAX('MDA2'!J20, 'T1'!L20, MAX(T3_R1!K20, T3_R2!K20)), MAX('MDA2'!K20, 'T1'!M20, MAX(T3_R1!L20, T3_R2!L20)), MAX('MDA2'!L20, 'T1'!N20, MAX(T3_R1!M20, T3_R2!M20)))","v":136270},{"$f":"IF(AND(COUNTRY_INFO!I20>1,COUNTRY_INFO!I20<4),IF(J20>SUM(MAX('MDA2'!J20,MAX(T3_R1!K20,T3_R2!K20)),MAX('MDA2'!K20,'T1'!M20,MAX(T3_R1!L20,T3_R2!L20))),SUM(MAX('MDA2'!J20,MAX(T3_R1!K20,T3_R2!K20)),MAX('MDA2'!K20,'T1'!M20,MAX(T3_R1!L20,T3_R2!L20))),J20),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I20>1,COUNTRY_INFO!I20<4), IF(M20/J20*100<>0, IF(N20/J20*100>100,100,N20/J20*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!M20","v":0},null,null,{"$f":"MAX(SUM('T1'!L20:'T1'!N20),SUM('T2'!J20:'T2'!L20))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J20>0,COUNTRY_INFO!J20<4),IF(P20>MAX('T1'!M20,'T2'!M20),MAX('T1'!M20,'T2'!M20),P20),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J20>0,COUNTRY_INFO!J20<4), IF(S20/P20*100<>0, IF(T20/P20*100>100,100,T20/P20*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21)","v":"East"},{"$f":"IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21)","v":"Kirehe"},{"$f":"COUNTRY_INFO!K21","v":"Not required"},null,null,{"$f":"'MDA2'!M21","v":0},{"$f":"IF(AND(COUNTRY_INFO!H21>0,COUNTRY_INFO!H21<4),IF(D21>'MDA2'!M21,'MDA2'!M21,D21),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H21>0,COUNTRY_INFO!H21<4), IF(G21/D21*100<>0, IF(G21/D21*100>100,100,G21/D21*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L21","v":152754},null,null,{"$f":"SUM(MAX('MDA2'!J21, 'T1'!L21, MAX(T3_R1!K21, T3_R2!K21)), MAX('MDA2'!K21, 'T1'!M21, MAX(T3_R1!L21, T3_R2!L21)), MAX('MDA2'!L21, 'T1'!N21, MAX(T3_R1!M21, T3_R2!M21)))","v":161517},{"$f":"IF(AND(COUNTRY_INFO!I21>1,COUNTRY_INFO!I21<4),IF(J21>SUM(MAX('MDA2'!J21,MAX(T3_R1!K21,T3_R2!K21)),MAX('MDA2'!K21,'T1'!M21,MAX(T3_R1!L21,T3_R2!L21))),SUM(MAX('MDA2'!J21,MAX(T3_R1!K21,T3_R2!K21)),MAX('MDA2'!K21,'T1'!M21,MAX(T3_R1!L21,T3_R2!L21))),J21),0)","v":152754},{"$f":"IF(AND(COUNTRY_INFO!I21>1,COUNTRY_INFO!I21<4), IF(M21/J21*100<>0, IF(N21/J21*100>100,100,N21/J21*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M21","v":0},null,null,{"$f":"MAX(SUM('T1'!L21:'T1'!N21),SUM('T2'!J21:'T2'!L21))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J21>0,COUNTRY_INFO!J21<4),IF(P21>MAX('T1'!M21,'T2'!M21),MAX('T1'!M21,'T2'!M21),P21),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J21>0,COUNTRY_INFO!J21<4), IF(S21/P21*100<>0, IF(T21/P21*100>100,100,T21/P21*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22)","v":"South"},{"$f":"IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22)","v":"Muhanga"},{"$f":"COUNTRY_INFO!K22","v":"Not required"},null,null,{"$f":"'MDA2'!M22","v":0},{"$f":"IF(AND(COUNTRY_INFO!H22>0,COUNTRY_INFO!H22<4),IF(D22>'MDA2'!M22,'MDA2'!M22,D22),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H22>0,COUNTRY_INFO!H22<4), IF(G22/D22*100<>0, IF(G22/D22*100>100,100,G22/D22*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L22","v":143228},null,null,{"$f":"SUM(MAX('MDA2'!J22, 'T1'!L22, MAX(T3_R1!K22, T3_R2!K22)), MAX('MDA2'!K22, 'T1'!M22, MAX(T3_R1!L22, T3_R2!L22)), MAX('MDA2'!L22, 'T1'!N22, MAX(T3_R1!M22, T3_R2!M22)))","v":131049},{"$f":"IF(AND(COUNTRY_INFO!I22>1,COUNTRY_INFO!I22<4),IF(J22>SUM(MAX('MDA2'!J22,MAX(T3_R1!K22,T3_R2!K22)),MAX('MDA2'!K22,'T1'!M22,MAX(T3_R1!L22,T3_R2!L22))),SUM(MAX('MDA2'!J22,MAX(T3_R1!K22,T3_R2!K22)),MAX('MDA2'!K22,'T1'!M22,MAX(T3_R1!L22,T3_R2!L22))),J22),0)","v":131049},{"$f":"IF(AND(COUNTRY_INFO!I22>1,COUNTRY_INFO!I22<4), IF(M22/J22*100<>0, IF(N22/J22*100>100,100,N22/J22*100), \"-\"),0)","v":91.496774373725813},{"$f":"COUNTRY_INFO!M22","v":33610.83},null,null,{"$f":"MAX(SUM('T1'!L22:'T1'!N22),SUM('T2'!J22:'T2'!L22))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J22>0,COUNTRY_INFO!J22<4),IF(P22>MAX('T1'!M22,'T2'!M22),MAX('T1'!M22,'T2'!M22),P22),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J22>0,COUNTRY_INFO!J22<4), IF(S22/P22*100<>0, IF(T22/P22*100>100,100,T22/P22*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23)","v":"North"},{"$f":"IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23)","v":"Musanze"},{"$f":"COUNTRY_INFO!K23","v":"Not required"},null,null,{"$f":"'MDA2'!M23","v":0},{"$f":"IF(AND(COUNTRY_INFO!H23>0,COUNTRY_INFO!H23<4),IF(D23>'MDA2'!M23,'MDA2'!M23,D23),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H23>0,COUNTRY_INFO!H23<4), IF(G23/D23*100<>0, IF(G23/D23*100>100,100,G23/D23*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L23","v":165275},null,null,{"$f":"SUM(MAX('MDA2'!J23, 'T1'!L23, MAX(T3_R1!K23, T3_R2!K23)), MAX('MDA2'!K23, 'T1'!M23, MAX(T3_R1!L23, T3_R2!L23)), MAX('MDA2'!L23, 'T1'!N23, MAX(T3_R1!M23, T3_R2!M23)))","v":174879},{"$f":"IF(AND(COUNTRY_INFO!I23>1,COUNTRY_INFO!I23<4),IF(J23>SUM(MAX('MDA2'!J23,MAX(T3_R1!K23,T3_R2!K23)),MAX('MDA2'!K23,'T1'!M23,MAX(T3_R1!L23,T3_R2!L23))),SUM(MAX('MDA2'!J23,MAX(T3_R1!K23,T3_R2!K23)),MAX('MDA2'!K23,'T1'!M23,MAX(T3_R1!L23,T3_R2!L23))),J23),0)","v":165275},{"$f":"IF(AND(COUNTRY_INFO!I23>1,COUNTRY_INFO!I23<4), IF(M23/J23*100<>0, IF(N23/J23*100>100,100,N23/J23*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M23","v":104959.9},null,null,{"$f":"MAX(SUM('T1'!L23:'T1'!N23),SUM('T2'!J23:'T2'!L23))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J23>0,COUNTRY_INFO!J23<4),IF(P23>MAX('T1'!M23,'T2'!M23),MAX('T1'!M23,'T2'!M23),P23),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J23>0,COUNTRY_INFO!J23<4), IF(S23/P23*100<>0, IF(T23/P23*100>100,100,T23/P23*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24)","v":"East"},{"$f":"IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24)","v":"Ngoma"},{"$f":"COUNTRY_INFO!K24","v":"Not required"},null,null,{"$f":"'MDA2'!M24","v":0},{"$f":"IF(AND(COUNTRY_INFO!H24>0,COUNTRY_INFO!H24<4),IF(D24>'MDA2'!M24,'MDA2'!M24,D24),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H24>0,COUNTRY_INFO!H24<4), IF(G24/D24*100<>0, IF(G24/D24*100>100,100,G24/D24*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L24","v":151210},null,null,{"$f":"SUM(MAX('MDA2'!J24, 'T1'!L24, MAX(T3_R1!K24, T3_R2!K24)), MAX('MDA2'!K24, 'T1'!M24, MAX(T3_R1!L24, T3_R2!L24)), MAX('MDA2'!L24, 'T1'!N24, MAX(T3_R1!M24, T3_R2!M24)))","v":165260},{"$f":"IF(AND(COUNTRY_INFO!I24>1,COUNTRY_INFO!I24<4),IF(J24>SUM(MAX('MDA2'!J24,MAX(T3_R1!K24,T3_R2!K24)),MAX('MDA2'!K24,'T1'!M24,MAX(T3_R1!L24,T3_R2!L24))),SUM(MAX('MDA2'!J24,MAX(T3_R1!K24,T3_R2!K24)),MAX('MDA2'!K24,'T1'!M24,MAX(T3_R1!L24,T3_R2!L24))),J24),0)","v":151210},{"$f":"IF(AND(COUNTRY_INFO!I24>1,COUNTRY_INFO!I24<4), IF(M24/J24*100<>0, IF(N24/J24*100>100,100,N24/J24*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M24","v":35483.910000000003},null,null,{"$f":"MAX(SUM('T1'!L24:'T1'!N24),SUM('T2'!J24:'T2'!L24))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J24>0,COUNTRY_INFO!J24<4),IF(P24>MAX('T1'!M24,'T2'!M24),MAX('T1'!M24,'T2'!M24),P24),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J24>0,COUNTRY_INFO!J24<4), IF(S24/P24*100<>0, IF(T24/P24*100>100,100,T24/P24*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25)","v":"West"},{"$f":"IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25)","v":"Ngororero"},{"$f":"COUNTRY_INFO!K25","v":"Not required"},null,null,{"$f":"'MDA2'!M25","v":0},{"$f":"IF(AND(COUNTRY_INFO!H25>0,COUNTRY_INFO!H25<4),IF(D25>'MDA2'!M25,'MDA2'!M25,D25),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H25>0,COUNTRY_INFO!H25<4), IF(G25/D25*100<>0, IF(G25/D25*100>100,100,G25/D25*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L25","v":149767},null,null,{"$f":"SUM(MAX('MDA2'!J25, 'T1'!L25, MAX(T3_R1!K25, T3_R2!K25)), MAX('MDA2'!K25, 'T1'!M25, MAX(T3_R1!L25, T3_R2!L25)), MAX('MDA2'!L25, 'T1'!N25, MAX(T3_R1!M25, T3_R2!M25)))","v":156664},{"$f":"IF(AND(COUNTRY_INFO!I25>1,COUNTRY_INFO!I25<4),IF(J25>SUM(MAX('MDA2'!J25,MAX(T3_R1!K25,T3_R2!K25)),MAX('MDA2'!K25,'T1'!M25,MAX(T3_R1!L25,T3_R2!L25))),SUM(MAX('MDA2'!J25,MAX(T3_R1!K25,T3_R2!K25)),MAX('MDA2'!K25,'T1'!M25,MAX(T3_R1!L25,T3_R2!L25))),J25),0)","v":149767},{"$f":"IF(AND(COUNTRY_INFO!I25>1,COUNTRY_INFO!I25<4), IF(M25/J25*100<>0, IF(N25/J25*100>100,100,N25/J25*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M25","v":0},null,null,{"$f":"MAX(SUM('T1'!L25:'T1'!N25),SUM('T2'!J25:'T2'!L25))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J25>0,COUNTRY_INFO!J25<4),IF(P25>MAX('T1'!M25,'T2'!M25),MAX('T1'!M25,'T2'!M25),P25),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J25>0,COUNTRY_INFO!J25<4), IF(S25/P25*100<>0, IF(T25/P25*100>100,100,T25/P25*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26)","v":"West"},{"$f":"IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26)","v":"Nyabihu"},{"$f":"COUNTRY_INFO!K26","v":"Not required"},null,null,{"$f":"'MDA2'!M26","v":0},{"$f":"IF(AND(COUNTRY_INFO!H26>0,COUNTRY_INFO!H26<4),IF(D26>'MDA2'!M26,'MDA2'!M26,D26),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H26>0,COUNTRY_INFO!H26<4), IF(G26/D26*100<>0, IF(G26/D26*100>100,100,G26/D26*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L26","v":132277},null,null,{"$f":"SUM(MAX('MDA2'!J26, 'T1'!L26, MAX(T3_R1!K26, T3_R2!K26)), MAX('MDA2'!K26, 'T1'!M26, MAX(T3_R1!L26, T3_R2!L26)), MAX('MDA2'!L26, 'T1'!N26, MAX(T3_R1!M26, T3_R2!M26)))","v":137514},{"$f":"IF(AND(COUNTRY_INFO!I26>1,COUNTRY_INFO!I26<4),IF(J26>SUM(MAX('MDA2'!J26,MAX(T3_R1!K26,T3_R2!K26)),MAX('MDA2'!K26,'T1'!M26,MAX(T3_R1!L26,T3_R2!L26))),SUM(MAX('MDA2'!J26,MAX(T3_R1!K26,T3_R2!K26)),MAX('MDA2'!K26,'T1'!M26,MAX(T3_R1!L26,T3_R2!L26))),J26),0)","v":132277},{"$f":"IF(AND(COUNTRY_INFO!I26>1,COUNTRY_INFO!I26<4), IF(M26/J26*100<>0, IF(N26/J26*100>100,100,N26/J26*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M26","v":31041.120000000003},null,null,{"$f":"MAX(SUM('T1'!L26:'T1'!N26),SUM('T2'!J26:'T2'!L26))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J26>0,COUNTRY_INFO!J26<4),IF(P26>MAX('T1'!M26,'T2'!M26),MAX('T1'!M26,'T2'!M26),P26),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J26>0,COUNTRY_INFO!J26<4), IF(S26/P26*100<>0, IF(T26/P26*100>100,100,T26/P26*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27)","v":"East"},{"$f":"IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27)","v":"Nyagatare"},{"$f":"COUNTRY_INFO!K27","v":"Not required"},null,null,{"$f":"'MDA2'!M27","v":0},{"$f":"IF(AND(COUNTRY_INFO!H27>0,COUNTRY_INFO!H27<4),IF(D27>'MDA2'!M27,'MDA2'!M27,D27),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H27>0,COUNTRY_INFO!H27<4), IF(G27/D27*100<>0, IF(G27/D27*100>100,100,G27/D27*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L27","v":209072},null,null,{"$f":"SUM(MAX('MDA2'!J27, 'T1'!L27, MAX(T3_R1!K27, T3_R2!K27)), MAX('MDA2'!K27, 'T1'!M27, MAX(T3_R1!L27, T3_R2!L27)), MAX('MDA2'!L27, 'T1'!N27, MAX(T3_R1!M27, T3_R2!M27)))","v":227606},{"$f":"IF(AND(COUNTRY_INFO!I27>1,COUNTRY_INFO!I27<4),IF(J27>SUM(MAX('MDA2'!J27,MAX(T3_R1!K27,T3_R2!K27)),MAX('MDA2'!K27,'T1'!M27,MAX(T3_R1!L27,T3_R2!L27))),SUM(MAX('MDA2'!J27,MAX(T3_R1!K27,T3_R2!K27)),MAX('MDA2'!K27,'T1'!M27,MAX(T3_R1!L27,T3_R2!L27))),J27),0)","v":209072},{"$f":"IF(AND(COUNTRY_INFO!I27>1,COUNTRY_INFO!I27<4), IF(M27/J27*100<>0, IF(N27/J27*100>100,100,N27/J27*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M27","v":132773.29999999999},null,null,{"$f":"MAX(SUM('T1'!L27:'T1'!N27),SUM('T2'!J27:'T2'!L27))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J27>0,COUNTRY_INFO!J27<4),IF(P27>MAX('T1'!M27,'T2'!M27),MAX('T1'!M27,'T2'!M27),P27),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J27>0,COUNTRY_INFO!J27<4), IF(S27/P27*100<>0, IF(T27/P27*100>100,100,T27/P27*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28)","v":"South"},{"$f":"IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28)","v":"Nyamagabe"},{"$f":"COUNTRY_INFO!K28","v":"Not required"},null,null,{"$f":"'MDA2'!M28","v":0},{"$f":"IF(AND(COUNTRY_INFO!H28>0,COUNTRY_INFO!H28<4),IF(D28>'MDA2'!M28,'MDA2'!M28,D28),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H28>0,COUNTRY_INFO!H28<4), IF(G28/D28*100<>0, IF(G28/D28*100>100,100,G28/D28*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L28","v":153259},null,null,{"$f":"SUM(MAX('MDA2'!J28, 'T1'!L28, MAX(T3_R1!K28, T3_R2!K28)), MAX('MDA2'!K28, 'T1'!M28, MAX(T3_R1!L28, T3_R2!L28)), MAX('MDA2'!L28, 'T1'!N28, MAX(T3_R1!M28, T3_R2!M28)))","v":158161},{"$f":"IF(AND(COUNTRY_INFO!I28>1,COUNTRY_INFO!I28<4),IF(J28>SUM(MAX('MDA2'!J28,MAX(T3_R1!K28,T3_R2!K28)),MAX('MDA2'!K28,'T1'!M28,MAX(T3_R1!L28,T3_R2!L28))),SUM(MAX('MDA2'!J28,MAX(T3_R1!K28,T3_R2!K28)),MAX('MDA2'!K28,'T1'!M28,MAX(T3_R1!L28,T3_R2!L28))),J28),0)","v":153259},{"$f":"IF(AND(COUNTRY_INFO!I28>1,COUNTRY_INFO!I28<4), IF(M28/J28*100<>0, IF(N28/J28*100>100,100,N28/J28*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M28","v":0},null,null,{"$f":"MAX(SUM('T1'!L28:'T1'!N28),SUM('T2'!J28:'T2'!L28))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J28>0,COUNTRY_INFO!J28<4),IF(P28>MAX('T1'!M28,'T2'!M28),MAX('T1'!M28,'T2'!M28),P28),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J28>0,COUNTRY_INFO!J28<4), IF(S28/P28*100<>0, IF(T28/P28*100>100,100,T28/P28*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29)","v":"West"},{"$f":"IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29)","v":"Nyamasheke"},{"$f":"COUNTRY_INFO!K29","v":"Not required"},null,null,{"$f":"'MDA2'!M29","v":0},{"$f":"IF(AND(COUNTRY_INFO!H29>0,COUNTRY_INFO!H29<4),IF(D29>'MDA2'!M29,'MDA2'!M29,D29),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H29>0,COUNTRY_INFO!H29<4), IF(G29/D29*100<>0, IF(G29/D29*100>100,100,G29/D29*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L29","v":171350},null,null,{"$f":"SUM(MAX('MDA2'!J29, 'T1'!L29, MAX(T3_R1!K29, T3_R2!K29)), MAX('MDA2'!K29, 'T1'!M29, MAX(T3_R1!L29, T3_R2!L29)), MAX('MDA2'!L29, 'T1'!N29, MAX(T3_R1!M29, T3_R2!M29)))","v":180422},{"$f":"IF(AND(COUNTRY_INFO!I29>1,COUNTRY_INFO!I29<4),IF(J29>SUM(MAX('MDA2'!J29,MAX(T3_R1!K29,T3_R2!K29)),MAX('MDA2'!K29,'T1'!M29,MAX(T3_R1!L29,T3_R2!L29))),SUM(MAX('MDA2'!J29,MAX(T3_R1!K29,T3_R2!K29)),MAX('MDA2'!K29,'T1'!M29,MAX(T3_R1!L29,T3_R2!L29))),J29),0)","v":171350},{"$f":"IF(AND(COUNTRY_INFO!I29>1,COUNTRY_INFO!I29<4), IF(M29/J29*100<>0, IF(N29/J29*100>100,100,N29/J29*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M29","v":108818.1},null,null,{"$f":"MAX(SUM('T1'!L29:'T1'!N29),SUM('T2'!J29:'T2'!L29))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J29>0,COUNTRY_INFO!J29<4),IF(P29>MAX('T1'!M29,'T2'!M29),MAX('T1'!M29,'T2'!M29),P29),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J29>0,COUNTRY_INFO!J29<4), IF(S29/P29*100<>0, IF(T29/P29*100>100,100,T29/P29*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30)","v":"South"},{"$f":"IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30)","v":"Nyanza"},{"$f":"COUNTRY_INFO!K30","v":"Not required"},null,null,{"$f":"'MDA2'!M30","v":0},{"$f":"IF(AND(COUNTRY_INFO!H30>0,COUNTRY_INFO!H30<4),IF(D30>'MDA2'!M30,'MDA2'!M30,D30),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H30>0,COUNTRY_INFO!H30<4), IF(G30/D30*100<>0, IF(G30/D30*100>100,100,G30/D30*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L30","v":145282},null,null,{"$f":"SUM(MAX('MDA2'!J30, 'T1'!L30, MAX(T3_R1!K30, T3_R2!K30)), MAX('MDA2'!K30, 'T1'!M30, MAX(T3_R1!L30, T3_R2!L30)), MAX('MDA2'!L30, 'T1'!N30, MAX(T3_R1!M30, T3_R2!M30)))","v":144017},{"$f":"IF(AND(COUNTRY_INFO!I30>1,COUNTRY_INFO!I30<4),IF(J30>SUM(MAX('MDA2'!J30,MAX(T3_R1!K30,T3_R2!K30)),MAX('MDA2'!K30,'T1'!M30,MAX(T3_R1!L30,T3_R2!L30))),SUM(MAX('MDA2'!J30,MAX(T3_R1!K30,T3_R2!K30)),MAX('MDA2'!K30,'T1'!M30,MAX(T3_R1!L30,T3_R2!L30))),J30),0)","v":144017},{"$f":"IF(AND(COUNTRY_INFO!I30>1,COUNTRY_INFO!I30<4), IF(M30/J30*100<>0, IF(N30/J30*100>100,100,N30/J30*100), \"-\"),0)","v":99.129279607934919},{"$f":"COUNTRY_INFO!M30","v":0},null,null,{"$f":"MAX(SUM('T1'!L30:'T1'!N30),SUM('T2'!J30:'T2'!L30))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J30>0,COUNTRY_INFO!J30<4),IF(P30>MAX('T1'!M30,'T2'!M30),MAX('T1'!M30,'T2'!M30),P30),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J30>0,COUNTRY_INFO!J30<4), IF(S30/P30*100<>0, IF(T30/P30*100>100,100,T30/P30*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A31=0,\" \",COUNTRY_INFO!A31)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B31=0,\" \",COUNTRY_INFO!B31)","v":"Kigali"},{"$f":"IF(COUNTRY_INFO!C31=0,\" \",COUNTRY_INFO!C31)","v":"Nyarugenge"},{"$f":"COUNTRY_INFO!K31","v":"Not required"},null,null,{"$f":"'MDA2'!M31","v":0},{"$f":"IF(AND(COUNTRY_INFO!H31>0,COUNTRY_INFO!H31<4),IF(D31>'MDA2'!M31,'MDA2'!M31,D31),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H31>0,COUNTRY_INFO!H31<4), IF(G31/D31*100<>0, IF(G31/D31*100>100,100,G31/D31*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L31","v":127709},null,null,{"$f":"SUM(MAX('MDA2'!J31, 'T1'!L31, MAX(T3_R1!K31, T3_R2!K31)), MAX('MDA2'!K31, 'T1'!M31, MAX(T3_R1!L31, T3_R2!L31)), MAX('MDA2'!L31, 'T1'!N31, MAX(T3_R1!M31, T3_R2!M31)))","v":121677},{"$f":"IF(AND(COUNTRY_INFO!I31>1,COUNTRY_INFO!I31<4),IF(J31>SUM(MAX('MDA2'!J31,MAX(T3_R1!K31,T3_R2!K31)),MAX('MDA2'!K31,'T1'!M31,MAX(T3_R1!L31,T3_R2!L31))),SUM(MAX('MDA2'!J31,MAX(T3_R1!K31,T3_R2!K31)),MAX('MDA2'!K31,'T1'!M31,MAX(T3_R1!L31,T3_R2!L31))),J31),0)","v":121677},{"$f":"IF(AND(COUNTRY_INFO!I31>1,COUNTRY_INFO!I31<4), IF(M31/J31*100<>0, IF(N31/J31*100>100,100,N31/J31*100), \"-\"),0)","v":95.276762013640379},{"$f":"COUNTRY_INFO!M31","v":0},null,null,{"$f":"MAX(SUM('T1'!L31:'T1'!N31),SUM('T2'!J31:'T2'!L31))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J31>0,COUNTRY_INFO!J31<4),IF(P31>MAX('T1'!M31,'T2'!M31),MAX('T1'!M31,'T2'!M31),P31),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J31>0,COUNTRY_INFO!J31<4), IF(S31/P31*100<>0, IF(T31/P31*100>100,100,T31/P31*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A32=0,\" \",COUNTRY_INFO!A32)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B32=0,\" \",COUNTRY_INFO!B32)","v":"South"},{"$f":"IF(COUNTRY_INFO!C32=0,\" \",COUNTRY_INFO!C32)","v":"Nyaruguru"},{"$f":"COUNTRY_INFO!K32","v":"Not required"},null,null,{"$f":"'MDA2'!M32","v":0},{"$f":"IF(AND(COUNTRY_INFO!H32>0,COUNTRY_INFO!H32<4),IF(D32>'MDA2'!M32,'MDA2'!M32,D32),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H32>0,COUNTRY_INFO!H32<4), IF(G32/D32*100<>0, IF(G32/D32*100>100,100,G32/D32*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L32","v":132095},null,null,{"$f":"SUM(MAX('MDA2'!J32, 'T1'!L32, MAX(T3_R1!K32, T3_R2!K32)), MAX('MDA2'!K32, 'T1'!M32, MAX(T3_R1!L32, T3_R2!L32)), MAX('MDA2'!L32, 'T1'!N32, MAX(T3_R1!M32, T3_R2!M32)))","v":131775},{"$f":"IF(AND(COUNTRY_INFO!I32>1,COUNTRY_INFO!I32<4),IF(J32>SUM(MAX('MDA2'!J32,MAX(T3_R1!K32,T3_R2!K32)),MAX('MDA2'!K32,'T1'!M32,MAX(T3_R1!L32,T3_R2!L32))),SUM(MAX('MDA2'!J32,MAX(T3_R1!K32,T3_R2!K32)),MAX('MDA2'!K32,'T1'!M32,MAX(T3_R1!L32,T3_R2!L32))),J32),0)","v":131775},{"$f":"IF(AND(COUNTRY_INFO!I32>1,COUNTRY_INFO!I32<4), IF(M32/J32*100<>0, IF(N32/J32*100>100,100,N32/J32*100), \"-\"),0)","v":99.757750104091741},{"$f":"COUNTRY_INFO!M32","v":0},null,null,{"$f":"MAX(SUM('T1'!L32:'T1'!N32),SUM('T2'!J32:'T2'!L32))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J32>0,COUNTRY_INFO!J32<4),IF(P32>MAX('T1'!M32,'T2'!M32),MAX('T1'!M32,'T2'!M32),P32),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J32>0,COUNTRY_INFO!J32<4), IF(S32/P32*100<>0, IF(T32/P32*100>100,100,T32/P32*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A33=0,\" \",COUNTRY_INFO!A33)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B33=0,\" \",COUNTRY_INFO!B33)","v":"West"},{"$f":"IF(COUNTRY_INFO!C33=0,\" \",COUNTRY_INFO!C33)","v":"Rubavu"},{"$f":"COUNTRY_INFO!K33","v":"Not required"},null,null,{"$f":"'MDA2'!M33","v":0},{"$f":"IF(AND(COUNTRY_INFO!H33>0,COUNTRY_INFO!H33<4),IF(D33>'MDA2'!M33,'MDA2'!M33,D33),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H33>0,COUNTRY_INFO!H33<4), IF(G33/D33*100<>0, IF(G33/D33*100>100,100,G33/D33*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L33","v":181160},null,null,{"$f":"SUM(MAX('MDA2'!J33, 'T1'!L33, MAX(T3_R1!K33, T3_R2!K33)), MAX('MDA2'!K33, 'T1'!M33, MAX(T3_R1!L33, T3_R2!L33)), MAX('MDA2'!L33, 'T1'!N33, MAX(T3_R1!M33, T3_R2!M33)))","v":181021},{"$f":"IF(AND(COUNTRY_INFO!I33>1,COUNTRY_INFO!I33<4),IF(J33>SUM(MAX('MDA2'!J33,MAX(T3_R1!K33,T3_R2!K33)),MAX('MDA2'!K33,'T1'!M33,MAX(T3_R1!L33,T3_R2!L33))),SUM(MAX('MDA2'!J33,MAX(T3_R1!K33,T3_R2!K33)),MAX('MDA2'!K33,'T1'!M33,MAX(T3_R1!L33,T3_R2!L33))),J33),0)","v":181021},{"$f":"IF(AND(COUNTRY_INFO!I33>1,COUNTRY_INFO!I33<4), IF(M33/J33*100<>0, IF(N33/J33*100>100,100,N33/J33*100), \"-\"),0)","v":99.923272245528821},{"$f":"COUNTRY_INFO!M33","v":42512.25},null,null,{"$f":"MAX(SUM('T1'!L33:'T1'!N33),SUM('T2'!J33:'T2'!L33))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J33>0,COUNTRY_INFO!J33<4),IF(P33>MAX('T1'!M33,'T2'!M33),MAX('T1'!M33,'T2'!M33),P33),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J33>0,COUNTRY_INFO!J33<4), IF(S33/P33*100<>0, IF(T33/P33*100>100,100,T33/P33*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A34=0,\" \",COUNTRY_INFO!A34)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B34=0,\" \",COUNTRY_INFO!B34)","v":"South"},{"$f":"IF(COUNTRY_INFO!C34=0,\" \",COUNTRY_INFO!C34)","v":"Ruhango"},{"$f":"COUNTRY_INFO!K34","v":"Not required"},null,null,{"$f":"'MDA2'!M34","v":0},{"$f":"IF(AND(COUNTRY_INFO!H34>0,COUNTRY_INFO!H34<4),IF(D34>'MDA2'!M34,'MDA2'!M34,D34),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H34>0,COUNTRY_INFO!H34<4), IF(G34/D34*100<>0, IF(G34/D34*100>100,100,G34/D34*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L34","v":143561},null,null,{"$f":"SUM(MAX('MDA2'!J34, 'T1'!L34, MAX(T3_R1!K34, T3_R2!K34)), MAX('MDA2'!K34, 'T1'!M34, MAX(T3_R1!L34, T3_R2!L34)), MAX('MDA2'!L34, 'T1'!N34, MAX(T3_R1!M34, T3_R2!M34)))","v":148452},{"$f":"IF(AND(COUNTRY_INFO!I34>1,COUNTRY_INFO!I34<4),IF(J34>SUM(MAX('MDA2'!J34,MAX(T3_R1!K34,T3_R2!K34)),MAX('MDA2'!K34,'T1'!M34,MAX(T3_R1!L34,T3_R2!L34))),SUM(MAX('MDA2'!J34,MAX(T3_R1!K34,T3_R2!K34)),MAX('MDA2'!K34,'T1'!M34,MAX(T3_R1!L34,T3_R2!L34))),J34),0)","v":143561},{"$f":"IF(AND(COUNTRY_INFO!I34>1,COUNTRY_INFO!I34<4), IF(M34/J34*100<>0, IF(N34/J34*100>100,100,N34/J34*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M34","v":0},null,null,{"$f":"MAX(SUM('T1'!L34:'T1'!N34),SUM('T2'!J34:'T2'!L34))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J34>0,COUNTRY_INFO!J34<4),IF(P34>MAX('T1'!M34,'T2'!M34),MAX('T1'!M34,'T2'!M34),P34),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J34>0,COUNTRY_INFO!J34<4), IF(S34/P34*100<>0, IF(T34/P34*100>100,100,T34/P34*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A35=0,\" \",COUNTRY_INFO!A35)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B35=0,\" \",COUNTRY_INFO!B35)","v":"North"},{"$f":"IF(COUNTRY_INFO!C35=0,\" \",COUNTRY_INFO!C35)","v":"Rulindo"},{"$f":"COUNTRY_INFO!K35","v":"Not required"},null,null,{"$f":"'MDA2'!M35","v":0},{"$f":"IF(AND(COUNTRY_INFO!H35>0,COUNTRY_INFO!H35<4),IF(D35>'MDA2'!M35,'MDA2'!M35,D35),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H35>0,COUNTRY_INFO!H35<4), IF(G35/D35*100<>0, IF(G35/D35*100>100,100,G35/D35*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L35","v":129109},null,null,{"$f":"SUM(MAX('MDA2'!J35, 'T1'!L35, MAX(T3_R1!K35, T3_R2!K35)), MAX('MDA2'!K35, 'T1'!M35, MAX(T3_R1!L35, T3_R2!L35)), MAX('MDA2'!L35, 'T1'!N35, MAX(T3_R1!M35, T3_R2!M35)))","v":132348},{"$f":"IF(AND(COUNTRY_INFO!I35>1,COUNTRY_INFO!I35<4),IF(J35>SUM(MAX('MDA2'!J35,MAX(T3_R1!K35,T3_R2!K35)),MAX('MDA2'!K35,'T1'!M35,MAX(T3_R1!L35,T3_R2!L35))),SUM(MAX('MDA2'!J35,MAX(T3_R1!K35,T3_R2!K35)),MAX('MDA2'!K35,'T1'!M35,MAX(T3_R1!L35,T3_R2!L35))),J35),0)","v":129109},{"$f":"IF(AND(COUNTRY_INFO!I35>1,COUNTRY_INFO!I35<4), IF(M35/J35*100<>0, IF(N35/J35*100>100,100,N35/J35*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M35","v":0},null,null,{"$f":"MAX(SUM('T1'!L35:'T1'!N35),SUM('T2'!J35:'T2'!L35))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J35>0,COUNTRY_INFO!J35<4),IF(P35>MAX('T1'!M35,'T2'!M35),MAX('T1'!M35,'T2'!M35),P35),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J35>0,COUNTRY_INFO!J35<4), IF(S35/P35*100<>0, IF(T35/P35*100>100,100,T35/P35*100), \"-\"),0)","v":0}]
[{"$f":"IF(COUNTRY_INFO!A36=0,\" \",COUNTRY_INFO!A36)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B36=0,\" \",COUNTRY_INFO!B36)","v":"West"},{"$f":"IF(COUNTRY_INFO!C36=0,\" \",COUNTRY_INFO!C36)","v":"Rusizi"},{"$f":"COUNTRY_INFO!K36","v":"Not required"},null,null,{"$f":"'MDA2'!M36","v":0},{"$f":"IF(AND(COUNTRY_INFO!H36>0,COUNTRY_INFO!H36<4),IF(D36>'MDA2'!M36,'MDA2'!M36,D36),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H36>0,COUNTRY_INFO!H36<4), IF(G36/D36*100<>0, IF(G36/D36*100>100,100,G36/D36*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L36","v":179902},null,null,{"$f":"SUM(MAX('MDA2'!J36, 'T1'!L36, MAX(T3_R1!K36, T3_R2!K36)), MAX('MDA2'!K36, 'T1'!M36, MAX(T3_R1!L36, T3_R2!L36)), MAX('MDA2'!L36, 'T1'!N36, MAX(T3_R1!M36, T3_R2!M36)))","v":187463},{"$f":"IF(AND(COUNTRY_INFO!I36>1,COUNTRY_INFO!I36<4),IF(J36>SUM(MAX('MDA2'!J36,MAX(T3_R1!K36,T3_R2!K36)),MAX('MDA2'!K36,'T1'!M36,MAX(T3_R1!L36,T3_R2!L36))),SUM(MAX('MDA2'!J36,MAX(T3_R1!K36,T3_R2!K36)),MAX('MDA2'!K36,'T1'!M36,MAX(T3_R1!L36,T3_R2!L36))),J36),0)","v":179902},{"$f":"IF(AND(COUNTRY_INFO!I36>1,COUNTRY_INFO!I36<4), IF(M36/J36*100<>0, IF(N36/J36*100>100,100,N36/J36*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M36","v":379348},null,null,{"$f":"MAX(SUM('T1'!L36:'T1'!N36),SUM('T2'!J36:'T2'!L36))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J36>0,COUNTRY_INFO!J36<4),IF(P36>MAX('T1'!M36,'T2'!M36),MAX('T1'!M36,'T2'!M36),P36),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J36>0,COUNTRY_INFO!J36<4), IF(S36/P36*100<>0, IF(T36/P36*100>100,100,T36/P36*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A37=0,\" \",COUNTRY_INFO!A37)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B37=0,\" \",COUNTRY_INFO!B37)","v":"West"},{"$f":"IF(COUNTRY_INFO!C37=0,\" \",COUNTRY_INFO!C37)","v":"Rutsiro"},{"$f":"COUNTRY_INFO!K37","v":"Not required"},null,null,{"$f":"'MDA2'!M37","v":0},{"$f":"IF(AND(COUNTRY_INFO!H37>0,COUNTRY_INFO!H37<4),IF(D37>'MDA2'!M37,'MDA2'!M37,D37),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H37>0,COUNTRY_INFO!H37<4), IF(G37/D37*100<>0, IF(G37/D37*100>100,100,G37/D37*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L37","v":145702},null,null,{"$f":"SUM(MAX('MDA2'!J37, 'T1'!L37, MAX(T3_R1!K37, T3_R2!K37)), MAX('MDA2'!K37, 'T1'!M37, MAX(T3_R1!L37, T3_R2!L37)), MAX('MDA2'!L37, 'T1'!N37, MAX(T3_R1!M37, T3_R2!M37)))","v":143516},{"$f":"IF(AND(COUNTRY_INFO!I37>1,COUNTRY_INFO!I37<4),IF(J37>SUM(MAX('MDA2'!J37,MAX(T3_R1!K37,T3_R2!K37)),MAX('MDA2'!K37,'T1'!M37,MAX(T3_R1!L37,T3_R2!L37))),SUM(MAX('MDA2'!J37,MAX(T3_R1!K37,T3_R2!K37)),MAX('MDA2'!K37,'T1'!M37,MAX(T3_R1!L37,T3_R2!L37))),J37),0)","v":143516},{"$f":"IF(AND(COUNTRY_INFO!I37>1,COUNTRY_INFO!I37<4), IF(M37/J37*100<>0, IF(N37/J37*100>100,100,N37/J37*100), \"-\"),0)","v":98.499677423782799},{"$f":"COUNTRY_INFO!M37","v":92529.600000000006},null,null,{"$f":"MAX(SUM('T1'!L37:'T1'!N37),SUM('T2'!J37:'T2'!L37))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J37>0,COUNTRY_INFO!J37<4),IF(P37>MAX('T1'!M37,'T2'!M37),MAX('T1'!M37,'T2'!M37),P37),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J37>0,COUNTRY_INFO!J37<4), IF(S37/P37*100<>0, IF(T37/P37*100>100,100,T37/P37*100), \"-\"),0)","v":"-"}]
[{"$f":"IF(COUNTRY_INFO!A38=0,\" \",COUNTRY_INFO!A38)","v":"Rwanda"},{"$f":"IF(COUNTRY_INFO!B38=0,\" \",COUNTRY_INFO!B38)","v":"East"},{"$f":"IF(COUNTRY_INFO!C38=0,\" \",COUNTRY_INFO!C38)","v":"Rwamagana"},{"$f":"COUNTRY_INFO!K38","v":"Not required"},null,null,{"$f":"'MDA2'!M38","v":0},{"$f":"IF(AND(COUNTRY_INFO!H38>0,COUNTRY_INFO!H38<4),IF(D38>'MDA2'!M38,'MDA2'!M38,D38),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H38>0,COUNTRY_INFO!H38<4), IF(G38/D38*100<>0, IF(G38/D38*100>100,100,G38/D38*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!L38","v":140678},null,null,{"$f":"SUM(MAX('MDA2'!J38, 'T1'!L38, MAX(T3_R1!K38, T3_R2!K38)), MAX('MDA2'!K38, 'T1'!M38, MAX(T3_R1!L38, T3_R2!L38)), MAX('MDA2'!L38, 'T1'!N38, MAX(T3_R1!M38, T3_R2!M38)))","v":144052},{"$f":"IF(AND(COUNTRY_INFO!I38>1,COUNTRY_INFO!I38<4),IF(J38>SUM(MAX('MDA2'!J38,MAX(T3_R1!K38,T3_R2!K38)),MAX('MDA2'!K38,'T1'!M38,MAX(T3_R1!L38,T3_R2!L38))),SUM(MAX('MDA2'!J38,MAX(T3_R1!K38,T3_R2!K38)),MAX('MDA2'!K38,'T1'!M38,MAX(T3_R1!L38,T3_R2!L38))),J38),0)","v":140678},{"$f":"IF(AND(COUNTRY_INFO!I38>1,COUNTRY_INFO!I38<4), IF(M38/J38*100<>0, IF(N38/J38*100>100,100,N38/J38*100), \"-\"),0)","v":100},{"$f":"COUNTRY_INFO!M38","v":33012.54},null,null,{"$f":"MAX(SUM('T1'!L38:'T1'!N38),SUM('T2'!J38:'T2'!L38))","v":0},{"$f":"IF(AND(COUNTRY_INFO!J38>0,COUNTRY_INFO!J38<4),IF(P38>MAX('T1'!M38,'T2'!M38),MAX('T1'!M38,'T2'!M38),P38),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J38>0,COUNTRY_INFO!J38<4), IF(S38/P38*100<>0, IF(T38/P38*100>100,100,T38/P38*100), \"-\"),0)","v":"-"}]

{"sheet":"SUMMARY","index":8,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,1,69,2],[66,1,66,7],[68,1,68,2],[63,3,64,7],[3,3,3,5],[27,1,27,5],[47,1,47,2],[50,3,50,4],[33,1,33,2],[62,1,62,2],[62,3,62,7],[34,1,34,2],[35,1,35,2],[36,1,36,2],[38,1,38,2],[42,1,42,2],[43,1,43,2],[0,1,0,7],[64,1,64,2],[45,1,45,2],[49,1,49,7],[46,1,46,2],[37,1,37,2],[32,1,32,2],[15,1,15,3],[54,1,60,7],[44,1,44,2],[1,1,1,7],[5,1,11,7],[23,1,23,5],[24,1,24,5],[26,1,26,5]]}
[null,"The current version should be used in countries non-endemic for onchocerciasis"]
[null,"PC Joint Reporting Form v.2"]
[]
[null,"Country",null,{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\" \")","v":"Rwanda"},null,null,"Year",{"$f":"IF(INTRO!$E$36<>0,INTRO!$E$36,\" \")","v":2016}]
[]
[null,"National authorities are requested to complete the Joint Reporting Form (JRF) for submission to the World Health Organization any time before 15 August of the current year for reporting data on PC interventions implemented during the previous year."]
[]
[]
[]
[]
[]
[]
[]
[null,"Number of people received treatment (at least once) for the diseases"]
[]
[null,null,null,null,"PreSAC","SAC","Adults","Total"]
[null,"Lymphatic filariasis",null,null," "," "," ",{"$f":"SUM(E17:G17)","v":0}]
[null,"Soil-transmitted helminthiases",null,null,{"$f":"T3_R1!K4","v":1412841},{"$f":"T3_R1!L4","v":3323164},0,{"$f":"SUM(E18:G18)","v":4736005}]
[null,"Schistosomiasis",null,null,"Not targeted",null,0,{"$f":"SUM(E19:G19)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E20:G20)","v":0}]
[]
[null,"Coverage of PC interventions for the diseases (%)"]
[]
[null,null,null,null,null,null,"Geographical","National"]
[null,"Lymphatic filariasis",null,null,null,null,0,0]
[null,"Soil-transmitted helminthiases",null,null,null,null,100,{"$f":"T3_R1!R4","v":100.91068816925706}]
[null,"Schistosomiasis"]
[]
[]
[null,"Number of people treated and programme coverage (%) by PC interventions"]
[]
[null,null,null,"PreSAC","SAC","Adults","Total","Coverage (%)"]
[]
[null,"MDA 2 (DEC+ALB)",null,{"$f":"'MDA2'!$J$4","v":0},{"$f":"'MDA2'!$K$4","v":0},{"$f":"'MDA2'!$L$4","v":0},{"$f":"'MDA2'!$M$4","v":0},{"$f":"'MDA2'!$Q$4","v":" "}]
[]
[null,"T 1 (PZQ+ALB/MBD)",null,{"$f":"IF('T1'!$L$4<>0,'T1'!$L$4,\"Not targeted\")","v":"Not targeted"},{"$f":"'T1'!$M$4","v":0},{"$f":"IF('T1'!$N$4<>0,'T1'!$N$4,\"Not targeted\")","v":"Not targeted"},{"$f":"'T1'!$O$4","v":0},{"$f":"'T1'!$S$4","v":" "}]
[null,"T 2 (PZQ)",null,{"$f":"IF('T2'!$J$4<>0,'T2'!$J$4,\"Not targeted\")","v":"Not targeted"},{"$f":"'T2'!$K$4","v":0},{"$f":"'T2'!$L$4","v":0},{"$f":"'T2'!$M$4","v":0},{"$f":"'T2'!$Q$4","v":" "}]
[null,"T 3 (ALB/MBD) - round 1",null,{"$f":"T3_R1!$K$4","v":1412841},{"$f":"T3_R1!$L$4","v":3323164},{"$f":"IF(T3_R1!$M$4<>0,T3_R1!$M$4,\"Not targeted\")","v":"Not targeted"},{"$f":"T3_R1!$N$4","v":4736005},{"$f":"T3_R1!$R$4","v":100.91068816925706}]
[null,"T 3 (ALB/MBD) - round 2",null,{"$f":"T3_R2!$K$4","v":0},{"$f":"T3_R2!$L$4","v":0},{"$f":"IF(T3_R2!$M$4<>0,T3_R2!$M$4,\"Not targeted\")","v":"Not targeted"},{"$f":"T3_R2!$N$4","v":0},{"$f":"T3_R2!$R$4","v":" "}]
[]
[null,"Inventory of PC medicines in the country"]
[]
[null,null,null,"DEC","ALB (LF)","ALB (STH)","MBD","PZQ"]
[null,"Available"]
[null,"Distributed"]
[null,"Wasted"]
[null,"Received"]
[null,"Remaining",null,null,null,{"$f":"F47-F45-F46","v":0},{"$f":"G47-G45-G46","v":0},0]
[]
[null,"Please indicate the medicine has been used to treat PreSAC for STH and delivery channels"]
[null,"PC medicine","Mebendazole","Delivery channels",null,"WHO, UNICEF","Source","Johnson&Johnson"]
[]
[null,"Additional information"]
[]
[null,"In 2016, there was only Round 1 treatment for STH and no treatment for schistosomiasis due to lack of funds for distribution. The signature of partnership with END Fund was still in process."]
[]
[]
[]
[]
[]
[]
[]
[null,"Name and signature of NTD coordinator or Ministry of Health representative:",null,"Dr Aimable MBITUYUMUREMYI"]
[null,null,null,"2017-04-24"]
[null,"Date:"]
[]
[null,"Please send the national report (signed and in electronic format) to the concerned WR with copy to:"]
[]
[null,"WHO headquarters",null,"PC_JointForms@who.int"]
[null,"WHO Regional Office",null,"Regional Advisor for NTD"]