{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["INTRO","COUNTRY_INFO","DEC","ALB_MBD","PZQ","IVM","IVM+","SUMMARY","SHIPMENT","DATA_POLICY"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":10,"comments":9,"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":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,1,21,4],[46,1,46,4],[38,1,38,2],[40,1,40,2],[42,1,42,2],[44,1,44,2],[36,1,36,2],[22,2,23,4],[25,2,26,4],[27,1,27,4],[32,1,32,2],[29,1,29,4],[30,1,30,4],[28,2,28,4],[24,1,24,4],[34,1,34,2],[0,1,0,4],[2,1,2,4],[1,1,1,4],[5,1,5,4],[3,1,3,4],[7,2,7,4],[11,1,11,4],[4,1,4,4],[10,2,10,4],[20,2,20,4],[17,1,17,4],[13,1,13,4],[18,2,18,4],[8,2,8,4],[9,2,9,4],[19,1,19,4],[12,1,12,4],[16,1,16,4],[14,1,14,4],[15,1,15,4]]}
[]
[null,"Joint request for selected PC medicines v.4.1"]
[]
[null,"As part of global efforts to accelerate expansion of preventive chemotherapy (PC) for control and elimination of lymphatic filariasis, schistosomiasis and soil-transmitted helminthiases, the World Health Organization (WHO) facilitates the supply of albendazole 400 mg tablets (GSK) to national lymphatic filariasis elimination programmes and national soil-transmitted helminth control programmes; diethylcarbamazine citrate 100 mg tablets (Eisai) to national lymphatic filariasis elimination programmes; mebendazole 500 mg tablets (J&J) for national soil-transmitted helminth control programmes; and praziquantel 600 mg tablets (Merck KGaA)  for school-age children to national schistosomiasis control programmes. WHO also collaborates to supply ivermectin 3 mg tablets (Merck) for onchocerciasis and lymphatic filariasis donation programmes.  \nThis Excel-based tool is designed to assist countries in quantifying the number of tablets of relevant PC medicines required to reach the planned target population and districts for the year of request. Output of the tool is a joint request for PC medicines, which can be printed, signed and submitted to WHO to request these medicines."]
[]
[null,"Structure of the application (worksheets):"]
[]
[null,"INTRO","This worksheet includes guides on how to complete the joint request for selected PC medicines and information about the status of PC for endemic diseases in the country."]
[null,"COUNTRY_INFO","This worksheet includes information about administrative structure of the country, population by age group, status of endemicity for each disease, population requiring PC and planned interventions."]
[null,"DEC, ALB_MBD, PZQ and IVM","These worksheets include information about endemic districts targeted for treatment with specified PC medicines, treatment plan, and number of tablets required and requested. "]
[null,"SUMMARY","This worksheet includes summary of number of tablets requested, information about stock, and date for submission of requested medicines. Before generating the report (run macros) please select the medicine for which the report is needed. Follow the same rule to see the number of people to be treated for the specific disease. \nThis worksheet should be printed and submitted as a joint request for selected PC medicines (see the instruction for submission in the SUMMARY worksheet)."]
[]
[null,"Instruction for data entry"]
[]
[null,"Most of the cells in the above-mentioned worksheets include formula that are calculated automatically according to the treatment policy recommended by WHO for each disease.\nSee the link https://www.who.int/publications/i/item/9789241599993."]
[]
[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,"Liberia",null,"LR","LBR"]
[null,null,null,null,5]
[null,"Year for request of the medicine",null,null,2024]
[]
[null,"Is country endemic for lymphatic filariasis (LF)?",null,null,"Endemic"]
[]
[null,"Is country endemic for onchocerciasis (ONCHO)?",null,null,"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,15]
[]
[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,"1-4 years age","Preschool-age children (PreSAC)",null,0.1137]
[null,"5-14 years age","School-age children (SAC)",null,0.2666]
[null,"15 years +","Adults",null,0.58989999999999998]
[null,"15-49 years","Women of reproductive age (WRA)",null,0.2432]

{"sheet":"COUNTRY_INFO","index":1,"n_rows":24,"n_cols":35,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,7,3,10],[3,21,3,24],[5,0,5,2],[3,26,3,29],[5,26,5,29],[5,3,5,6],[5,7,5,10],[5,11,5,20],[5,21,5,24],[6,3,7,3],[6,2,7,2],[6,1,7,1],[6,0,7,0],[6,21,7,21],[6,13,6,16],[6,11,7,11],[6,12,7,12],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,6,7,6],[6,5,7,5],[6,4,7,4],[6,28,7,28],[6,29,7,29],[6,17,6,20],[6,25,7,25],[6,22,7,22],[6,23,7,23],[6,24,7,24],[6,26,7,26],[6,27,7,27]]}
["COUNTRY INFORMATION"]
["Administrative structure, population by age group, status of endemicity and planned interventions"]
[]
["TOTAL",null,null,{"$f":"SUBTOTAL(9,D$10:D$1010)","v":4755968},{"$f":"SUBTOTAL(9,E$10:E$1010)","v":540755},1267941,2805545,null,null,null,null,{"$f":"SUBTOTAL(9,L$10:L$1010)","v":579749},4755968,258947,607168,553877,1419992,155745,486910,1077376,1720031]
[]
["Country administrative structure",null,null,"Population",null,null,null,"Endemicity",null,null,null,"Population requiring PC",null,null,null,null,null,null,null,null,null,"Number of treatment rounds planned for the year",null,null,null,"Criteria to apply for \nIVM+DEC+ALB therapy","Epidemiological surveys planned for the year"]
["Country","Province/State","District","Total","PreSAC","SAC","Adults","LF","Oncho","STH","SCH","LF","ONCHO","STH",null,null,null,"SCH",null,null,null,"LF","Oncho","STH","SCH","LF","LF","Oncho","STH","SCH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PreSAC","SAC","WRA","TOTAL","PreSAC","SAC","Adults","TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,"IU_ID","IU_Name"]
[]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Bomi","Bomi",115204,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D10*INTRO!$E$48,0))","v":13099},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D10*INTRO!$E$49,0))","v":30713},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D10*INTRO!$E$50,0))","v":67959},0,1,2,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H10>0,IF($H10=4,\"Unknown\",IF($H10=99,\"Stopped\",$D10)),0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I10>0, IF($I10=4,\"Unknown\",IF($I10=99,\"Stopped\",$D10)), 0),\"Not required\")","v":115204},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J10>1, IF($J10=4, \"Unknown\", IF($J10=99, \"Surveillance\", E10)), 0),\"Not required\")","v":13099},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J10>1, IF($J10=4, \"Unknown\", IF($J10=99, \"Surveillance\", F10)), 0),\"Not required\")","v":30713},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J10>1, IF($J10=4, \"Unknown\", IF($J10=99, \"Surveillance\", ROUND(D10*INTRO!$E$51,0))), 0),\"Not required\")","v":28018},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J10>1, IF($J10=4, \"Unknown\", IF($J10=99, \"Surveillance\", SUM($N10:$P10))), 0),\"Not required\")","v":71830},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K10>1, IF($K10=4, \"Unknown\", IF($K10=99, \"Surveillance\", ROUND(E10*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K10>1, IF($K10=4, \"Unknown\", IF($K10=99, \"Surveillance\", F10)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K10>1, IF($K10=4, \"Unknown\", IF($K10=99, \"Surveillance\", G10)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K10>1, IF($K10=4, \"Unknown\", IF($K10=99, \"Surveillance\", SUM($R10:$T10))), 0),\"Not required\")","v":0},0,1,0,0,null,null,null,null,null,null,null,null,26818,"Bomi"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Bong","Bong",456716,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D11*INTRO!$E$48,0))","v":51929},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D11*INTRO!$E$49,0))","v":121760},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D11*INTRO!$E$50,0))","v":269417},1,1,2,3,"Stopped",{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I11>0, IF($I11=4,\"Unknown\",IF($I11=99,\"Stopped\",$D11)), 0),\"Not required\")","v":456716},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J11>1, IF($J11=4, \"Unknown\", IF($J11=99, \"Surveillance\", E11)), 0),\"Not required\")","v":51929},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J11>1, IF($J11=4, \"Unknown\", IF($J11=99, \"Surveillance\", F11)), 0),\"Not required\")","v":121760},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J11>1, IF($J11=4, \"Unknown\", IF($J11=99, \"Surveillance\", ROUND(D11*INTRO!$E$51,0))), 0),\"Not required\")","v":111073},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J11>1, IF($J11=4, \"Unknown\", IF($J11=99, \"Surveillance\", SUM($N11:$P11))), 0),\"Not required\")","v":284762},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K11>1, IF($K11=4, \"Unknown\", IF($K11=99, \"Surveillance\", ROUND(E11*0.75,0))), 0),\"Not required\")","v":38947},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K11>1, IF($K11=4, \"Unknown\", IF($K11=99, \"Surveillance\", F11)), 0),\"Not required\")","v":121760},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K11>1, IF($K11=4, \"Unknown\", IF($K11=99, \"Surveillance\", G11)), 0),\"Not required\")","v":269417},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K11>1, IF($K11=4, \"Unknown\", IF($K11=99, \"Surveillance\", SUM($R11:$T11))), 0),\"Not required\")","v":430124},1,1,1,1,null,null,null,null,null,null,null,null,26819,"Bong"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Gbarpolu","Gbarpolu",114203,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D12*INTRO!$E$48,0))","v":12985},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D12*INTRO!$E$49,0))","v":30447},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D12*INTRO!$E$50,0))","v":67368},0,1,1,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H12>0,IF($H12=4,\"Unknown\",IF($H12=99,\"Stopped\",$D12)),0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I12>0, IF($I12=4,\"Unknown\",IF($I12=99,\"Stopped\",$D12)), 0),\"Not required\")","v":114203},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J12>1, IF($J12=4, \"Unknown\", IF($J12=99, \"Surveillance\", E12)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J12>1, IF($J12=4, \"Unknown\", IF($J12=99, \"Surveillance\", F12)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J12>1, IF($J12=4, \"Unknown\", IF($J12=99, \"Surveillance\", ROUND(D12*INTRO!$E$51,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J12>1, IF($J12=4, \"Unknown\", IF($J12=99, \"Surveillance\", SUM($N12:$P12))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K12>1, IF($K12=4, \"Unknown\", IF($K12=99, \"Surveillance\", ROUND(E12*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K12>1, IF($K12=4, \"Unknown\", IF($K12=99, \"Surveillance\", F12)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K12>1, IF($K12=4, \"Unknown\", IF($K12=99, \"Surveillance\", G12)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K12>1, IF($K12=4, \"Unknown\", IF($K12=99, \"Surveillance\", SUM($R12:$T12))), 0),\"Not required\")","v":0},0,1,0,0,null,null,null,null,null,null,null,null,26820,"Gbarpolu"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Grand Bassa","Grand Bassa",303617,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D13*INTRO!$E$48,0))","v":34521},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D13*INTRO!$E$49,0))","v":80944},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D13*INTRO!$E$50,0))","v":179104},99,1,2,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H13>0,IF($H13=4,\"Unknown\",IF($H13=99,\"Stopped\",$D13)),0),\"Not required\")","v":"Stopped"},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I13>0, IF($I13=4,\"Unknown\",IF($I13=99,\"Stopped\",$D13)), 0),\"Not required\")","v":303617},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J13>1, IF($J13=4, \"Unknown\", IF($J13=99, \"Surveillance\", E13)), 0),\"Not required\")","v":34521},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J13>1, IF($J13=4, \"Unknown\", IF($J13=99, \"Surveillance\", F13)), 0),\"Not required\")","v":80944},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J13>1, IF($J13=4, \"Unknown\", IF($J13=99, \"Surveillance\", ROUND(D13*INTRO!$E$51,0))), 0),\"Not required\")","v":73840},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J13>1, IF($J13=4, \"Unknown\", IF($J13=99, \"Surveillance\", SUM($N13:$P13))), 0),\"Not required\")","v":189305},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K13>1, IF($K13=4, \"Unknown\", IF($K13=99, \"Surveillance\", ROUND(E13*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K13>1, IF($K13=4, \"Unknown\", IF($K13=99, \"Surveillance\", F13)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K13>1, IF($K13=4, \"Unknown\", IF($K13=99, \"Surveillance\", G13)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K13>1, IF($K13=4, \"Unknown\", IF($K13=99, \"Surveillance\", SUM($R13:$T13))), 0),\"Not required\")","v":0},0,1,1,1,null,"TAS",null,null,null,null,null,null,26821,"Grand Bassa"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Grand Cape Mount","Grand Cape Mount",174035,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D14*INTRO!$E$48,0))","v":19788},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D14*INTRO!$E$49,0))","v":46398},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D14*INTRO!$E$50,0))","v":102663},1,1,2,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H14>0,IF($H14=4,\"Unknown\",IF($H14=99,\"Stopped\",$D14)),0),\"Not required\")","v":174035},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I14>0, IF($I14=4,\"Unknown\",IF($I14=99,\"Stopped\",$D14)), 0),\"Not required\")","v":174035},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J14>1, IF($J14=4, \"Unknown\", IF($J14=99, \"Surveillance\", E14)), 0),\"Not required\")","v":19788},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J14>1, IF($J14=4, \"Unknown\", IF($J14=99, \"Surveillance\", F14)), 0),\"Not required\")","v":46398},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J14>1, IF($J14=4, \"Unknown\", IF($J14=99, \"Surveillance\", ROUND(D14*INTRO!$E$51,0))), 0),\"Not required\")","v":42325},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J14>1, IF($J14=4, \"Unknown\", IF($J14=99, \"Surveillance\", SUM($N14:$P14))), 0),\"Not required\")","v":108511},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K14>1, IF($K14=4, \"Unknown\", IF($K14=99, \"Surveillance\", ROUND(E14*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K14>1, IF($K14=4, \"Unknown\", IF($K14=99, \"Surveillance\", F14)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K14>1, IF($K14=4, \"Unknown\", IF($K14=99, \"Surveillance\", G14)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K14>1, IF($K14=4, \"Unknown\", IF($K14=99, \"Surveillance\", SUM($R14:$T14))), 0),\"Not required\")","v":0},1,1,1,1,null,null,null,null,null,null,null,null,26822,"Grand Cape Mount"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Grand Gedeh","Grand Gedeh",171545,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D15*INTRO!$E$48,0))","v":19505},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D15*INTRO!$E$49,0))","v":45734},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D15*INTRO!$E$50,0))","v":101194},99,1,1,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H15>0,IF($H15=4,\"Unknown\",IF($H15=99,\"Stopped\",$D15)),0),\"Not required\")","v":"Stopped"},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I15>0, IF($I15=4,\"Unknown\",IF($I15=99,\"Stopped\",$D15)), 0),\"Not required\")","v":171545},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J15>1, IF($J15=4, \"Unknown\", IF($J15=99, \"Surveillance\", E15)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J15>1, IF($J15=4, \"Unknown\", IF($J15=99, \"Surveillance\", F15)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J15>1, IF($J15=4, \"Unknown\", IF($J15=99, \"Surveillance\", ROUND(D15*INTRO!$E$51,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J15>1, IF($J15=4, \"Unknown\", IF($J15=99, \"Surveillance\", SUM($N15:$P15))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K15>1, IF($K15=4, \"Unknown\", IF($K15=99, \"Surveillance\", ROUND(E15*0.75,0))), 0),\"Not required\")","v":14629},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K15>1, IF($K15=4, \"Unknown\", IF($K15=99, \"Surveillance\", F15)), 0),\"Not required\")","v":45734},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K15>1, IF($K15=4, \"Unknown\", IF($K15=99, \"Surveillance\", G15)), 0),\"Not required\")","v":101194},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K15>1, IF($K15=4, \"Unknown\", IF($K15=99, \"Surveillance\", SUM($R15:$T15))), 0),\"Not required\")","v":161557},0,1,0,0,null,"TAS",null,null,null,null,null,null,26823,"Grand Gedeh"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Grand Kru","Grand Kru",79314,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D16*INTRO!$E$48,0))","v":9018},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D16*INTRO!$E$49,0))","v":21145},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D16*INTRO!$E$50,0))","v":46787},1,1,3,0,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H16>0,IF($H16=4,\"Unknown\",IF($H16=99,\"Stopped\",$D16)),0),\"Not required\")","v":79314},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I16>0, IF($I16=4,\"Unknown\",IF($I16=99,\"Stopped\",$D16)), 0),\"Not required\")","v":79314},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J16>1, IF($J16=4, \"Unknown\", IF($J16=99, \"Surveillance\", E16)), 0),\"Not required\")","v":9018},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J16>1, IF($J16=4, \"Unknown\", IF($J16=99, \"Surveillance\", F16)), 0),\"Not required\")","v":21145},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J16>1, IF($J16=4, \"Unknown\", IF($J16=99, \"Surveillance\", ROUND(D16*INTRO!$E$51,0))), 0),\"Not required\")","v":19289},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J16>1, IF($J16=4, \"Unknown\", IF($J16=99, \"Surveillance\", SUM($N16:$P16))), 0),\"Not required\")","v":49452},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K16>1, IF($K16=4, \"Unknown\", IF($K16=99, \"Surveillance\", ROUND(E16*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K16>1, IF($K16=4, \"Unknown\", IF($K16=99, \"Surveillance\", F16)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K16>1, IF($K16=4, \"Unknown\", IF($K16=99, \"Surveillance\", G16)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K16>1, IF($K16=4, \"Unknown\", IF($K16=99, \"Surveillance\", SUM($R16:$T16))), 0),\"Not required\")","v":0},1,1,2,0,null,null,null,null,null,null,null,null,26824,"Grand Kru"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Lofa","Lofa",379174,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D17*INTRO!$E$48,0))","v":43112},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D17*INTRO!$E$49,0))","v":101088},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D17*INTRO!$E$50,0))","v":223675},99,1,1,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H17>0,IF($H17=4,\"Unknown\",IF($H17=99,\"Stopped\",$D17)),0),\"Not required\")","v":"Stopped"},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I17>0, IF($I17=4,\"Unknown\",IF($I17=99,\"Stopped\",$D17)), 0),\"Not required\")","v":379174},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J17>1, IF($J17=4, \"Unknown\", IF($J17=99, \"Surveillance\", E17)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J17>1, IF($J17=4, \"Unknown\", IF($J17=99, \"Surveillance\", F17)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J17>1, IF($J17=4, \"Unknown\", IF($J17=99, \"Surveillance\", ROUND(D17*INTRO!$E$51,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J17>1, IF($J17=4, \"Unknown\", IF($J17=99, \"Surveillance\", SUM($N17:$P17))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K17>1, IF($K17=4, \"Unknown\", IF($K17=99, \"Surveillance\", ROUND(E17*0.75,0))), 0),\"Not required\")","v":32334},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K17>1, IF($K17=4, \"Unknown\", IF($K17=99, \"Surveillance\", F17)), 0),\"Not required\")","v":101088},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K17>1, IF($K17=4, \"Unknown\", IF($K17=99, \"Surveillance\", G17)), 0),\"Not required\")","v":223675},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K17>1, IF($K17=4, \"Unknown\", IF($K17=99, \"Surveillance\", SUM($R17:$T17))), 0),\"Not required\")","v":357097},0,1,0,1,null,"TAS",null,null,null,null,null,null,26825,"Lofa"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Margibi","Margibi",287499,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D18*INTRO!$E$48,0))","v":32689},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D18*INTRO!$E$49,0))","v":76647},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D18*INTRO!$E$50,0))","v":169596},99,1,1,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H18>0,IF($H18=4,\"Unknown\",IF($H18=99,\"Stopped\",$D18)),0),\"Not required\")","v":"Stopped"},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I18>0, IF($I18=4,\"Unknown\",IF($I18=99,\"Stopped\",$D18)), 0),\"Not required\")","v":287499},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J18>1, IF($J18=4, \"Unknown\", IF($J18=99, \"Surveillance\", E18)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J18>1, IF($J18=4, \"Unknown\", IF($J18=99, \"Surveillance\", F18)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J18>1, IF($J18=4, \"Unknown\", IF($J18=99, \"Surveillance\", ROUND(D18*INTRO!$E$51,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J18>1, IF($J18=4, \"Unknown\", IF($J18=99, \"Surveillance\", SUM($N18:$P18))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K18>1, IF($K18=4, \"Unknown\", IF($K18=99, \"Surveillance\", ROUND(E18*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K18>1, IF($K18=4, \"Unknown\", IF($K18=99, \"Surveillance\", F18)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K18>1, IF($K18=4, \"Unknown\", IF($K18=99, \"Surveillance\", G18)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K18>1, IF($K18=4, \"Unknown\", IF($K18=99, \"Surveillance\", SUM($R18:$T18))), 0),\"Not required\")","v":0},0,1,0,0,null,"TAS",null,null,null,null,null,null,26826,"Margibi"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Maryland ","Maryland ",186172,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D19*INTRO!$E$48,0))","v":21168},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D19*INTRO!$E$49,0))","v":49633},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D19*INTRO!$E$50,0))","v":109823},1,1,3,3,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H19>0,IF($H19=4,\"Unknown\",IF($H19=99,\"Stopped\",$D19)),0),\"Not required\")","v":186172},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I19>0, IF($I19=4,\"Unknown\",IF($I19=99,\"Stopped\",$D19)), 0),\"Not required\")","v":186172},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J19>1, IF($J19=4, \"Unknown\", IF($J19=99, \"Surveillance\", E19)), 0),\"Not required\")","v":21168},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J19>1, IF($J19=4, \"Unknown\", IF($J19=99, \"Surveillance\", F19)), 0),\"Not required\")","v":49633},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J19>1, IF($J19=4, \"Unknown\", IF($J19=99, \"Surveillance\", ROUND(D19*INTRO!$E$51,0))), 0),\"Not required\")","v":45277},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J19>1, IF($J19=4, \"Unknown\", IF($J19=99, \"Surveillance\", SUM($N19:$P19))), 0),\"Not required\")","v":116078},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K19>1, IF($K19=4, \"Unknown\", IF($K19=99, \"Surveillance\", ROUND(E19*0.75,0))), 0),\"Not required\")","v":15876},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K19>1, IF($K19=4, \"Unknown\", IF($K19=99, \"Surveillance\", F19)), 0),\"Not required\")","v":49633},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K19>1, IF($K19=4, \"Unknown\", IF($K19=99, \"Surveillance\", G19)), 0),\"Not required\")","v":109823},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K19>1, IF($K19=4, \"Unknown\", IF($K19=99, \"Surveillance\", SUM($R19:$T19))), 0),\"Not required\")","v":175332},1,1,2,1,null,null,null,null,null,null,null,null,26827,"Maryland "]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Montserrado","Montserrado",1526094,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D20*INTRO!$E$48,0))","v":173517},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D20*INTRO!$E$49,0))","v":406857},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D20*INTRO!$E$50,0))","v":900243},99,1,1,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H20>0,IF($H20=4,\"Unknown\",IF($H20=99,\"Stopped\",$D20)),0),\"Not required\")","v":"Stopped"},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I20>0, IF($I20=4,\"Unknown\",IF($I20=99,\"Stopped\",$D20)), 0),\"Not required\")","v":1526094},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J20>1, IF($J20=4, \"Unknown\", IF($J20=99, \"Surveillance\", E20)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J20>1, IF($J20=4, \"Unknown\", IF($J20=99, \"Surveillance\", F20)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J20>1, IF($J20=4, \"Unknown\", IF($J20=99, \"Surveillance\", ROUND(D20*INTRO!$E$51,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J20>1, IF($J20=4, \"Unknown\", IF($J20=99, \"Surveillance\", SUM($N20:$P20))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K20>1, IF($K20=4, \"Unknown\", IF($K20=99, \"Surveillance\", ROUND(E20*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K20>1, IF($K20=4, \"Unknown\", IF($K20=99, \"Surveillance\", F20)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K20>1, IF($K20=4, \"Unknown\", IF($K20=99, \"Surveillance\", G20)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K20>1, IF($K20=4, \"Unknown\", IF($K20=99, \"Surveillance\", SUM($R20:$T20))), 0),\"Not required\")","v":0},0,1,0,1,null,"TAS",null,null,null,null,null,null,26828,"Montserrado"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Nimba","Nimba",632763,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D21*INTRO!$E$48,0))","v":71945},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D21*INTRO!$E$49,0))","v":168695},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D21*INTRO!$E$50,0))","v":373267},99,1,2,2,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H21>0,IF($H21=4,\"Unknown\",IF($H21=99,\"Stopped\",$D21)),0),\"Not required\")","v":"Stopped"},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I21>0, IF($I21=4,\"Unknown\",IF($I21=99,\"Stopped\",$D21)), 0),\"Not required\")","v":632763},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J21>1, IF($J21=4, \"Unknown\", IF($J21=99, \"Surveillance\", E21)), 0),\"Not required\")","v":71945},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J21>1, IF($J21=4, \"Unknown\", IF($J21=99, \"Surveillance\", F21)), 0),\"Not required\")","v":168695},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J21>1, IF($J21=4, \"Unknown\", IF($J21=99, \"Surveillance\", ROUND(D21*INTRO!$E$51,0))), 0),\"Not required\")","v":153888},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J21>1, IF($J21=4, \"Unknown\", IF($J21=99, \"Surveillance\", SUM($N21:$P21))), 0),\"Not required\")","v":394528},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K21>1, IF($K21=4, \"Unknown\", IF($K21=99, \"Surveillance\", ROUND(E21*0.75,0))), 0),\"Not required\")","v":53959},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K21>1, IF($K21=4, \"Unknown\", IF($K21=99, \"Surveillance\", F21)), 0),\"Not required\")","v":168695},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K21>1, IF($K21=4, \"Unknown\", IF($K21=99, \"Surveillance\", G21)), 0),\"Not required\")","v":373267},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K21>1, IF($K21=4, \"Unknown\", IF($K21=99, \"Surveillance\", SUM($R21:$T21))), 0),\"Not required\")","v":595921},0,1,1,1,null,"TAS",null,null,null,null,null,null,26829,"Nimba"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Rivercess","Rivercess",97934,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D22*INTRO!$E$48,0))","v":11135},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D22*INTRO!$E$49,0))","v":26109},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D22*INTRO!$E$50,0))","v":57771},99,1,2,0,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H22>0,IF($H22=4,\"Unknown\",IF($H22=99,\"Stopped\",$D22)),0),\"Not required\")","v":"Stopped"},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I22>0, IF($I22=4,\"Unknown\",IF($I22=99,\"Stopped\",$D22)), 0),\"Not required\")","v":97934},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J22>1, IF($J22=4, \"Unknown\", IF($J22=99, \"Surveillance\", E22)), 0),\"Not required\")","v":11135},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J22>1, IF($J22=4, \"Unknown\", IF($J22=99, \"Surveillance\", F22)), 0),\"Not required\")","v":26109},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J22>1, IF($J22=4, \"Unknown\", IF($J22=99, \"Surveillance\", ROUND(D22*INTRO!$E$51,0))), 0),\"Not required\")","v":23818},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J22>1, IF($J22=4, \"Unknown\", IF($J22=99, \"Surveillance\", SUM($N22:$P22))), 0),\"Not required\")","v":61062},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K22>1, IF($K22=4, \"Unknown\", IF($K22=99, \"Surveillance\", ROUND(E22*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K22>1, IF($K22=4, \"Unknown\", IF($K22=99, \"Surveillance\", F22)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K22>1, IF($K22=4, \"Unknown\", IF($K22=99, \"Surveillance\", G22)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K22>1, IF($K22=4, \"Unknown\", IF($K22=99, \"Surveillance\", SUM($R22:$T22))), 0),\"Not required\")","v":0},0,1,1,0,null,"TAS",null,null,null,null,null,null,26830,"Rivercess"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Rivergee","Rivergee",91470,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D23*INTRO!$E$48,0))","v":10400},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D23*INTRO!$E$49,0))","v":24386},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D23*INTRO!$E$50,0))","v":53958},99,1,2,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H23>0,IF($H23=4,\"Unknown\",IF($H23=99,\"Stopped\",$D23)),0),\"Not required\")","v":"Stopped"},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I23>0, IF($I23=4,\"Unknown\",IF($I23=99,\"Stopped\",$D23)), 0),\"Not required\")","v":91470},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J23>1, IF($J23=4, \"Unknown\", IF($J23=99, \"Surveillance\", E23)), 0),\"Not required\")","v":10400},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J23>1, IF($J23=4, \"Unknown\", IF($J23=99, \"Surveillance\", F23)), 0),\"Not required\")","v":24386},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J23>1, IF($J23=4, \"Unknown\", IF($J23=99, \"Surveillance\", ROUND(D23*INTRO!$E$51,0))), 0),\"Not required\")","v":22246},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J23>1, IF($J23=4, \"Unknown\", IF($J23=99, \"Surveillance\", SUM($N23:$P23))), 0),\"Not required\")","v":57032},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K23>1, IF($K23=4, \"Unknown\", IF($K23=99, \"Surveillance\", ROUND(E23*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K23>1, IF($K23=4, \"Unknown\", IF($K23=99, \"Surveillance\", F23)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K23>1, IF($K23=4, \"Unknown\", IF($K23=99, \"Surveillance\", G23)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K23>1, IF($K23=4, \"Unknown\", IF($K23=99, \"Surveillance\", SUM($R23:$T23))), 0),\"Not required\")","v":0},0,1,1,1,null,"TAS",null,null,null,null,null,null,26831,"Rivergee"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Liberia"},"Sinoe","Sinoe",140228,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D24*INTRO!$E$48,0))","v":15944},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D24*INTRO!$E$49,0))","v":37385},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D24*INTRO!$E$50,0))","v":82720},1,1,3,1,{"$f":"IF(INTRO!$E$37=\"Endemic\",IF($H24>0,IF($H24=4,\"Unknown\",IF($H24=99,\"Stopped\",$D24)),0),\"Not required\")","v":140228},{"$f":"IF(INTRO!$E$39=\"Endemic\", IF($I24>0, IF($I24=4,\"Unknown\",IF($I24=99,\"Stopped\",$D24)), 0),\"Not required\")","v":140228},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J24>1, IF($J24=4, \"Unknown\", IF($J24=99, \"Surveillance\", E24)), 0),\"Not required\")","v":15944},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J24>1, IF($J24=4, \"Unknown\", IF($J24=99, \"Surveillance\", F24)), 0),\"Not required\")","v":37385},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J24>1, IF($J24=4, \"Unknown\", IF($J24=99, \"Surveillance\", ROUND(D24*INTRO!$E$51,0))), 0),\"Not required\")","v":34103},{"$f":"IF(INTRO!$E$41=\"Endemic\", IF($J24>1, IF($J24=4, \"Unknown\", IF($J24=99, \"Surveillance\", SUM($N24:$P24))), 0),\"Not required\")","v":87432},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K24>1, IF($K24=4, \"Unknown\", IF($K24=99, \"Surveillance\", ROUND(E24*0.75,0))), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K24>1, IF($K24=4, \"Unknown\", IF($K24=99, \"Surveillance\", F24)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K24>1, IF($K24=4, \"Unknown\", IF($K24=99, \"Surveillance\", G24)), 0),\"Not required\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endemic\", IF($K24>1, IF($K24=4, \"Unknown\", IF($K24=99, \"Surveillance\", SUM($R24:$T24))), 0),\"Not required\")","v":0},1,1,2,0,null,null,null,null,null,null,null,null,26832,"Sinoe"]

{"sheet":"DEC","index":2,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":true,"merged":[[3,0,3,2],[5,0,5,2],[6,5,7,5],[6,2,7,2],[6,1,7,1],[6,10,7,10],[6,0,7,0],[6,11,7,11],[5,3,5,6],[5,9,5,11],[6,4,7,4],[6,3,7,3],[6,8,7,8],[6,7,7,7],[6,6,7,6],[6,9,7,9]]}
["Diethylcarbamazine citrate (DEC)"]
["Administrative structure, eligible population by age group, treatment plan and information about tablets"]
[]
["TOTAL",null,null,{"$f":"SUBTOTAL(9,D$10:D$1010)","v":0},0,0,0,null,{"$f":"SUBTOTAL(9,I$10:I$1010)","v":0},0,0,0]
[]
["Country administrative structure",null,null,"Population requiring treatment with DEC",null,null,null,"Treatment plan","Target population","Diethylcarbamazine citrate (DEC)"]
["Country","Province/State","District","PreSAC","SAC","Adults","Total","LF","LF","Total required","Remaining in stock","Tablets to be procured"]
[]
[]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!E10,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!F10,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!G10,0)))","v":0},{"$f":"SUM(D10:F10)","v":0},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V10),\"Treat with IVM\")","v":"Treat with IVM"},{"$f":"IF(H10=1,G10,0)","v":0},{"$f":"IF(I10>0,I10*2.5,0)","v":0},null,{"$f":"IF($J10>$K10,$J10-$K10,0)","v":0}]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!E11,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!F11,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!G11,0)))","v":0},{"$f":"SUM(D11:F11)","v":0},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V11),\"Treat with IVM\")","v":"Treat with IVM"},{"$f":"IF(H11=1,G11,0)","v":0},{"$f":"IF(I11>0,I11*2.5,0)","v":0},null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!E12,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!F12,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!G12,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V12),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!E13,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!F13,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!G13,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V13),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!E14,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!F14,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!G14,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V14),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!E15,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!F15,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!G15,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V15),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!E16,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!F16,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!G16,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V16),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!E17,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!F17,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!G17,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V17),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!E18,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!F18,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!G18,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V18),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!E19,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!F19,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!G19,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V19),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!E20,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!F20,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!G20,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V20),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!E21,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!F21,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!G21,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V21),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!E22,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!F22,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!G22,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V22),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!E23,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!F23,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!G23,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V23),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", \" \", IF(INTRO!$E$37=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!E24,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!F24,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\", 0, IF(INTRO!$E$37=\"Non-endemic\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!G24,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF(INTRO!$E$37=\"Non-endemic\",\"Not required\",COUNTRY_INFO!V24),\"Treat with IVM\")","v":"Treat with IVM"},0,0,null,0]

{"sheet":"ALB_MBD","index":3,"n_rows":24,"n_cols":21,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,9,6,10],[6,11,7,11],[0,6,0,10],[1,6,1,7],[1,9,1,10],[5,6,5,11],[6,6,6,7],[3,0,3,2],[3,3,3,4],[5,0,5,2],[5,3,5,4],[5,5,7,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[5,12,5,17],[6,20,7,20],[5,18,5,20],[6,18,7,18],[6,19,7,19],[6,16,7,16],[6,17,7,17],[6,15,7,15],[6,12,7,12],[6,13,7,13],[6,14,7,14]]}
["Albendazole (ALB) and Mebendazole (MBD)",null,null,null,null,null,"Select medicine for treatment of STH for each age group"]
["Administrative structure, eligible population by age group, treatment plan and information about tablets",null,null,null,null,null,"ALB",null,"ALB"]
[]
["TOTAL",null,null,null,null,{"$f":"SUBTOTAL(9,F$10:F$1010)","v":887731},null,{"$f":"SUBTOTAL(9,H$10:H$1010)","v":291978},408297,null,372461,1072736,887731,0,887731,700275,0,700275,0,0,0]
[]
["Country administrative structure",null,null,"Treatment plan",null,"People targeted by PELF with ALB","Target population for STH",null,null,null,null,null,"Albendazole (ALB)",null,null,null,null,null,"Mebendazole (MBD)"]
["Country","Province/State","District","LF","STH",null,"PreSAC",null,"SAC","WRA",null,"Total","Total required","Remaining in stock (LF)","Tablets to be procured (LF)","Total required","Remaining in stock (STH)","Tablets to be procured (STH)","Total required","Remaining in stock","Tablets to be procured"]
[null,null,null,null,null,null,"Rounds","People","People","Rounds","People"]
[]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"Bomi"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Bomi"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V10)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X10)","v":0},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D10=1,DEC!I10,0),IF($D10=1,IVM!G10,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N10=\"Unknown\",COUNTRY_INFO!N10=\"Surveillance\",COUNTRY_INFO!N10=\"Not required\",COUNTRY_INFO!N10=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E10<>0,$G10=\"\"),IF($F10=0,COUNTRY_INFO!N10*$E10,COUNTRY_INFO!N10*($E10-$D10)),IF(AND($E10<>0,$G10<>0),IF($F10=0,COUNTRY_INFO!N10*$G10,COUNTRY_INFO!N10*($G10-$D10)),0)),IF($G10=\"\",COUNTRY_INFO!N10*$E10,COUNTRY_INFO!N10*$G10)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O10=\"Unknown\",COUNTRY_INFO!O10=\"Surveillance\",COUNTRY_INFO!O10=\"Not required\",COUNTRY_INFO!O10=0),0,IF($E10<>0, IF($F10=0,COUNTRY_INFO!O10*$E10,COUNTRY_INFO!O10*($E10-$D10)),COUNTRY_INFO!O10*$E10))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P10=\"Unknown\",COUNTRY_INFO!P10=\"Surveillance\",COUNTRY_INFO!P10=\"Not required\",COUNTRY_INFO!P10=0),0,IF(AND($E10<>0,$J10=\"\"),IF($F10=0,COUNTRY_INFO!P10*$E10,COUNTRY_INFO!P10*($E10-$D10)), IF(AND($E10<>0,$J10<>0),IF($F10=0,COUNTRY_INFO!P10*$J10,COUNTRY_INFO!P10*($J10-$D10)), COUNTRY_INFO!P10*$J10)))","v":0},{"$f":"ROUND($H10,0)+ROUND($I10,0)+ROUND($K10,0)","v":0},{"$f":"$F10","v":0},null,{"$f":"IF($M10>$N10, $M10-$N10,0)","v":0},{"$f":"ROUND((IF($G$2=\"ALB\",$H10,0)+IF($I$2=\"ALB\",$I10,0)+IF($J$2=\"ALB\",$K10,0)),0)","v":0},null,{"$f":"IF($P10>$Q10,$P10-$Q10,0)","v":0},{"$f":"ROUND((IF($G$2=\"MBD\",$H10,0)+IF($I$2=\"MBD\",$I10,0)+IF($J$2=\"MBD\",$K10,0)),0)","v":0},null,{"$f":"IF($S10>$T10,$S10-$T10,0)","v":0}]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"Bong"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Bong"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V11)","v":1},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X11)","v":1},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D11=1,DEC!I11,0),IF($D11=1,IVM!G11,0))","v":391177},null,{"$f":"IF(OR(COUNTRY_INFO!N11=\"Unknown\",COUNTRY_INFO!N11=\"Surveillance\",COUNTRY_INFO!N11=\"Not required\",COUNTRY_INFO!N11=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E11<>0,$G11=\"\"),IF($F11=0,COUNTRY_INFO!N11*$E11,COUNTRY_INFO!N11*($E11-$D11)),IF(AND($E11<>0,$G11<>0),IF($F11=0,COUNTRY_INFO!N11*$G11,COUNTRY_INFO!N11*($G11-$D11)),0)),IF($G11=\"\",COUNTRY_INFO!N11*$E11,COUNTRY_INFO!N11*$G11)))","v":51929},{"$f":"IF(OR(COUNTRY_INFO!O11=\"Unknown\",COUNTRY_INFO!O11=\"Surveillance\",COUNTRY_INFO!O11=\"Not required\",COUNTRY_INFO!O11=0),0,IF($E11<>0, IF($F11=0,COUNTRY_INFO!O11*$E11,COUNTRY_INFO!O11*($E11-$D11)),COUNTRY_INFO!O11*$E11))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P11=\"Unknown\",COUNTRY_INFO!P11=\"Surveillance\",COUNTRY_INFO!P11=\"Not required\",COUNTRY_INFO!P11=0),0,IF(AND($E11<>0,$J11=\"\"),IF($F11=0,COUNTRY_INFO!P11*$E11,COUNTRY_INFO!P11*($E11-$D11)), IF(AND($E11<>0,$J11<>0),IF($F11=0,COUNTRY_INFO!P11*$J11,COUNTRY_INFO!P11*($J11-$D11)), COUNTRY_INFO!P11*$J11)))","v":0},51929,391177,null,391177,51929,null,51929,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Gbarpolu"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"Gbarpolu"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V12)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X12)","v":0},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D12=1,DEC!I12,0),IF($D12=1,IVM!G12,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N12=\"Unknown\",COUNTRY_INFO!N12=\"Surveillance\",COUNTRY_INFO!N12=\"Not required\",COUNTRY_INFO!N12=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E12<>0,$G12=\"\"),IF($F12=0,COUNTRY_INFO!N12*$E12,COUNTRY_INFO!N12*($E12-$D12)),IF(AND($E12<>0,$G12<>0),IF($F12=0,COUNTRY_INFO!N12*$G12,COUNTRY_INFO!N12*($G12-$D12)),0)),IF($G12=\"\",COUNTRY_INFO!N12*$E12,COUNTRY_INFO!N12*$G12)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O12=\"Unknown\",COUNTRY_INFO!O12=\"Surveillance\",COUNTRY_INFO!O12=\"Not required\",COUNTRY_INFO!O12=0),0,IF($E12<>0, IF($F12=0,COUNTRY_INFO!O12*$E12,COUNTRY_INFO!O12*($E12-$D12)),COUNTRY_INFO!O12*$E12))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P12=\"Unknown\",COUNTRY_INFO!P12=\"Surveillance\",COUNTRY_INFO!P12=\"Not required\",COUNTRY_INFO!P12=0),0,IF(AND($E12<>0,$J12=\"\"),IF($F12=0,COUNTRY_INFO!P12*$E12,COUNTRY_INFO!P12*($E12-$D12)), IF(AND($E12<>0,$J12<>0),IF($F12=0,COUNTRY_INFO!P12*$J12,COUNTRY_INFO!P12*($J12-$D12)), COUNTRY_INFO!P12*$J12)))","v":0},0,0,null,0,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"Grand Bassa"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Grand Bassa"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V13)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X13)","v":1},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D13=1,DEC!I13,0),IF($D13=1,IVM!G13,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N13=\"Unknown\",COUNTRY_INFO!N13=\"Surveillance\",COUNTRY_INFO!N13=\"Not required\",COUNTRY_INFO!N13=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E13<>0,$G13=\"\"),IF($F13=0,COUNTRY_INFO!N13*$E13,COUNTRY_INFO!N13*($E13-$D13)),IF(AND($E13<>0,$G13<>0),IF($F13=0,COUNTRY_INFO!N13*$G13,COUNTRY_INFO!N13*($G13-$D13)),0)),IF($G13=\"\",COUNTRY_INFO!N13*$E13,COUNTRY_INFO!N13*$G13)))","v":34521},{"$f":"IF(OR(COUNTRY_INFO!O13=\"Unknown\",COUNTRY_INFO!O13=\"Surveillance\",COUNTRY_INFO!O13=\"Not required\",COUNTRY_INFO!O13=0),0,IF($E13<>0, IF($F13=0,COUNTRY_INFO!O13*$E13,COUNTRY_INFO!O13*($E13-$D13)),COUNTRY_INFO!O13*$E13))","v":80944},null,{"$f":"IF(OR(COUNTRY_INFO!P13=\"Unknown\",COUNTRY_INFO!P13=\"Surveillance\",COUNTRY_INFO!P13=\"Not required\",COUNTRY_INFO!P13=0),0,IF(AND($E13<>0,$J13=\"\"),IF($F13=0,COUNTRY_INFO!P13*$E13,COUNTRY_INFO!P13*($E13-$D13)), IF(AND($E13<>0,$J13<>0),IF($F13=0,COUNTRY_INFO!P13*$J13,COUNTRY_INFO!P13*($J13-$D13)), COUNTRY_INFO!P13*$J13)))","v":73840},189305,0,null,0,115465,null,115465,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"Grand Cape Mount"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Grand Cape Mount"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V14)","v":1},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X14)","v":1},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D14=1,DEC!I14,0),IF($D14=1,IVM!G14,0))","v":149061},null,{"$f":"IF(OR(COUNTRY_INFO!N14=\"Unknown\",COUNTRY_INFO!N14=\"Surveillance\",COUNTRY_INFO!N14=\"Not required\",COUNTRY_INFO!N14=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E14<>0,$G14=\"\"),IF($F14=0,COUNTRY_INFO!N14*$E14,COUNTRY_INFO!N14*($E14-$D14)),IF(AND($E14<>0,$G14<>0),IF($F14=0,COUNTRY_INFO!N14*$G14,COUNTRY_INFO!N14*($G14-$D14)),0)),IF($G14=\"\",COUNTRY_INFO!N14*$E14,COUNTRY_INFO!N14*$G14)))","v":19788},{"$f":"IF(OR(COUNTRY_INFO!O14=\"Unknown\",COUNTRY_INFO!O14=\"Surveillance\",COUNTRY_INFO!O14=\"Not required\",COUNTRY_INFO!O14=0),0,IF($E14<>0, IF($F14=0,COUNTRY_INFO!O14*$E14,COUNTRY_INFO!O14*($E14-$D14)),COUNTRY_INFO!O14*$E14))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P14=\"Unknown\",COUNTRY_INFO!P14=\"Surveillance\",COUNTRY_INFO!P14=\"Not required\",COUNTRY_INFO!P14=0),0,IF(AND($E14<>0,$J14=\"\"),IF($F14=0,COUNTRY_INFO!P14*$E14,COUNTRY_INFO!P14*($E14-$D14)), IF(AND($E14<>0,$J14<>0),IF($F14=0,COUNTRY_INFO!P14*$J14,COUNTRY_INFO!P14*($J14-$D14)), COUNTRY_INFO!P14*$J14)))","v":0},19788,149061,null,149061,19788,null,19788,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"Grand Gedeh"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Grand Gedeh"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V15)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X15)","v":0},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D15=1,DEC!I15,0),IF($D15=1,IVM!G15,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N15=\"Unknown\",COUNTRY_INFO!N15=\"Surveillance\",COUNTRY_INFO!N15=\"Not required\",COUNTRY_INFO!N15=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E15<>0,$G15=\"\"),IF($F15=0,COUNTRY_INFO!N15*$E15,COUNTRY_INFO!N15*($E15-$D15)),IF(AND($E15<>0,$G15<>0),IF($F15=0,COUNTRY_INFO!N15*$G15,COUNTRY_INFO!N15*($G15-$D15)),0)),IF($G15=\"\",COUNTRY_INFO!N15*$E15,COUNTRY_INFO!N15*$G15)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O15=\"Unknown\",COUNTRY_INFO!O15=\"Surveillance\",COUNTRY_INFO!O15=\"Not required\",COUNTRY_INFO!O15=0),0,IF($E15<>0, IF($F15=0,COUNTRY_INFO!O15*$E15,COUNTRY_INFO!O15*($E15-$D15)),COUNTRY_INFO!O15*$E15))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P15=\"Unknown\",COUNTRY_INFO!P15=\"Surveillance\",COUNTRY_INFO!P15=\"Not required\",COUNTRY_INFO!P15=0),0,IF(AND($E15<>0,$J15=\"\"),IF($F15=0,COUNTRY_INFO!P15*$E15,COUNTRY_INFO!P15*($E15-$D15)), IF(AND($E15<>0,$J15<>0),IF($F15=0,COUNTRY_INFO!P15*$J15,COUNTRY_INFO!P15*($J15-$D15)), COUNTRY_INFO!P15*$J15)))","v":0},0,0,null,0,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"Grand Kru"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Grand Kru"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V16)","v":1},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X16)","v":2},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D16=1,DEC!I16,0),IF($D16=1,IVM!G16,0))","v":67932},null,{"$f":"IF(OR(COUNTRY_INFO!N16=\"Unknown\",COUNTRY_INFO!N16=\"Surveillance\",COUNTRY_INFO!N16=\"Not required\",COUNTRY_INFO!N16=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E16<>0,$G16=\"\"),IF($F16=0,COUNTRY_INFO!N16*$E16,COUNTRY_INFO!N16*($E16-$D16)),IF(AND($E16<>0,$G16<>0),IF($F16=0,COUNTRY_INFO!N16*$G16,COUNTRY_INFO!N16*($G16-$D16)),0)),IF($G16=\"\",COUNTRY_INFO!N16*$E16,COUNTRY_INFO!N16*$G16)))","v":18036},{"$f":"IF(OR(COUNTRY_INFO!O16=\"Unknown\",COUNTRY_INFO!O16=\"Surveillance\",COUNTRY_INFO!O16=\"Not required\",COUNTRY_INFO!O16=0),0,IF($E16<>0, IF($F16=0,COUNTRY_INFO!O16*$E16,COUNTRY_INFO!O16*($E16-$D16)),COUNTRY_INFO!O16*$E16))","v":21145},null,{"$f":"IF(OR(COUNTRY_INFO!P16=\"Unknown\",COUNTRY_INFO!P16=\"Surveillance\",COUNTRY_INFO!P16=\"Not required\",COUNTRY_INFO!P16=0),0,IF(AND($E16<>0,$J16=\"\"),IF($F16=0,COUNTRY_INFO!P16*$E16,COUNTRY_INFO!P16*($E16-$D16)), IF(AND($E16<>0,$J16<>0),IF($F16=0,COUNTRY_INFO!P16*$J16,COUNTRY_INFO!P16*($J16-$D16)), COUNTRY_INFO!P16*$J16)))","v":19289},58470,67932,null,67932,39181,null,39181,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"Lofa"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Lofa"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V17)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X17)","v":0},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D17=1,DEC!I17,0),IF($D17=1,IVM!G17,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N17=\"Unknown\",COUNTRY_INFO!N17=\"Surveillance\",COUNTRY_INFO!N17=\"Not required\",COUNTRY_INFO!N17=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E17<>0,$G17=\"\"),IF($F17=0,COUNTRY_INFO!N17*$E17,COUNTRY_INFO!N17*($E17-$D17)),IF(AND($E17<>0,$G17<>0),IF($F17=0,COUNTRY_INFO!N17*$G17,COUNTRY_INFO!N17*($G17-$D17)),0)),IF($G17=\"\",COUNTRY_INFO!N17*$E17,COUNTRY_INFO!N17*$G17)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O17=\"Unknown\",COUNTRY_INFO!O17=\"Surveillance\",COUNTRY_INFO!O17=\"Not required\",COUNTRY_INFO!O17=0),0,IF($E17<>0, IF($F17=0,COUNTRY_INFO!O17*$E17,COUNTRY_INFO!O17*($E17-$D17)),COUNTRY_INFO!O17*$E17))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P17=\"Unknown\",COUNTRY_INFO!P17=\"Surveillance\",COUNTRY_INFO!P17=\"Not required\",COUNTRY_INFO!P17=0),0,IF(AND($E17<>0,$J17=\"\"),IF($F17=0,COUNTRY_INFO!P17*$E17,COUNTRY_INFO!P17*($E17-$D17)), IF(AND($E17<>0,$J17<>0),IF($F17=0,COUNTRY_INFO!P17*$J17,COUNTRY_INFO!P17*($J17-$D17)), COUNTRY_INFO!P17*$J17)))","v":0},0,0,null,0,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"Margibi"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Margibi"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V18)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X18)","v":0},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D18=1,DEC!I18,0),IF($D18=1,IVM!G18,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N18=\"Unknown\",COUNTRY_INFO!N18=\"Surveillance\",COUNTRY_INFO!N18=\"Not required\",COUNTRY_INFO!N18=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E18<>0,$G18=\"\"),IF($F18=0,COUNTRY_INFO!N18*$E18,COUNTRY_INFO!N18*($E18-$D18)),IF(AND($E18<>0,$G18<>0),IF($F18=0,COUNTRY_INFO!N18*$G18,COUNTRY_INFO!N18*($G18-$D18)),0)),IF($G18=\"\",COUNTRY_INFO!N18*$E18,COUNTRY_INFO!N18*$G18)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O18=\"Unknown\",COUNTRY_INFO!O18=\"Surveillance\",COUNTRY_INFO!O18=\"Not required\",COUNTRY_INFO!O18=0),0,IF($E18<>0, IF($F18=0,COUNTRY_INFO!O18*$E18,COUNTRY_INFO!O18*($E18-$D18)),COUNTRY_INFO!O18*$E18))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P18=\"Unknown\",COUNTRY_INFO!P18=\"Surveillance\",COUNTRY_INFO!P18=\"Not required\",COUNTRY_INFO!P18=0),0,IF(AND($E18<>0,$J18=\"\"),IF($F18=0,COUNTRY_INFO!P18*$E18,COUNTRY_INFO!P18*($E18-$D18)), IF(AND($E18<>0,$J18<>0),IF($F18=0,COUNTRY_INFO!P18*$J18,COUNTRY_INFO!P18*($J18-$D18)), COUNTRY_INFO!P18*$J18)))","v":0},0,0,null,0,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"Maryland "},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Maryland "},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V19)","v":1},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X19)","v":2},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D19=1,DEC!I19,0),IF($D19=1,IVM!G19,0))","v":159456},null,{"$f":"IF(OR(COUNTRY_INFO!N19=\"Unknown\",COUNTRY_INFO!N19=\"Surveillance\",COUNTRY_INFO!N19=\"Not required\",COUNTRY_INFO!N19=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E19<>0,$G19=\"\"),IF($F19=0,COUNTRY_INFO!N19*$E19,COUNTRY_INFO!N19*($E19-$D19)),IF(AND($E19<>0,$G19<>0),IF($F19=0,COUNTRY_INFO!N19*$G19,COUNTRY_INFO!N19*($G19-$D19)),0)),IF($G19=\"\",COUNTRY_INFO!N19*$E19,COUNTRY_INFO!N19*$G19)))","v":42336},{"$f":"IF(OR(COUNTRY_INFO!O19=\"Unknown\",COUNTRY_INFO!O19=\"Surveillance\",COUNTRY_INFO!O19=\"Not required\",COUNTRY_INFO!O19=0),0,IF($E19<>0, IF($F19=0,COUNTRY_INFO!O19*$E19,COUNTRY_INFO!O19*($E19-$D19)),COUNTRY_INFO!O19*$E19))","v":49633},null,{"$f":"IF(OR(COUNTRY_INFO!P19=\"Unknown\",COUNTRY_INFO!P19=\"Surveillance\",COUNTRY_INFO!P19=\"Not required\",COUNTRY_INFO!P19=0),0,IF(AND($E19<>0,$J19=\"\"),IF($F19=0,COUNTRY_INFO!P19*$E19,COUNTRY_INFO!P19*($E19-$D19)), IF(AND($E19<>0,$J19<>0),IF($F19=0,COUNTRY_INFO!P19*$J19,COUNTRY_INFO!P19*($J19-$D19)), COUNTRY_INFO!P19*$J19)))","v":45277},137246,159456,null,159456,91969,null,91969,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Montserrado"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Montserrado"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V20)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X20)","v":0},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D20=1,DEC!I20,0),IF($D20=1,IVM!G20,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N20=\"Unknown\",COUNTRY_INFO!N20=\"Surveillance\",COUNTRY_INFO!N20=\"Not required\",COUNTRY_INFO!N20=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E20<>0,$G20=\"\"),IF($F20=0,COUNTRY_INFO!N20*$E20,COUNTRY_INFO!N20*($E20-$D20)),IF(AND($E20<>0,$G20<>0),IF($F20=0,COUNTRY_INFO!N20*$G20,COUNTRY_INFO!N20*($G20-$D20)),0)),IF($G20=\"\",COUNTRY_INFO!N20*$E20,COUNTRY_INFO!N20*$G20)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O20=\"Unknown\",COUNTRY_INFO!O20=\"Surveillance\",COUNTRY_INFO!O20=\"Not required\",COUNTRY_INFO!O20=0),0,IF($E20<>0, IF($F20=0,COUNTRY_INFO!O20*$E20,COUNTRY_INFO!O20*($E20-$D20)),COUNTRY_INFO!O20*$E20))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P20=\"Unknown\",COUNTRY_INFO!P20=\"Surveillance\",COUNTRY_INFO!P20=\"Not required\",COUNTRY_INFO!P20=0),0,IF(AND($E20<>0,$J20=\"\"),IF($F20=0,COUNTRY_INFO!P20*$E20,COUNTRY_INFO!P20*($E20-$D20)), IF(AND($E20<>0,$J20<>0),IF($F20=0,COUNTRY_INFO!P20*$J20,COUNTRY_INFO!P20*($J20-$D20)), COUNTRY_INFO!P20*$J20)))","v":0},0,0,null,0,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"Nimba"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Nimba"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V21)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X21)","v":1},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D21=1,DEC!I21,0),IF($D21=1,IVM!G21,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N21=\"Unknown\",COUNTRY_INFO!N21=\"Surveillance\",COUNTRY_INFO!N21=\"Not required\",COUNTRY_INFO!N21=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E21<>0,$G21=\"\"),IF($F21=0,COUNTRY_INFO!N21*$E21,COUNTRY_INFO!N21*($E21-$D21)),IF(AND($E21<>0,$G21<>0),IF($F21=0,COUNTRY_INFO!N21*$G21,COUNTRY_INFO!N21*($G21-$D21)),0)),IF($G21=\"\",COUNTRY_INFO!N21*$E21,COUNTRY_INFO!N21*$G21)))","v":71945},{"$f":"IF(OR(COUNTRY_INFO!O21=\"Unknown\",COUNTRY_INFO!O21=\"Surveillance\",COUNTRY_INFO!O21=\"Not required\",COUNTRY_INFO!O21=0),0,IF($E21<>0, IF($F21=0,COUNTRY_INFO!O21*$E21,COUNTRY_INFO!O21*($E21-$D21)),COUNTRY_INFO!O21*$E21))","v":168695},null,{"$f":"IF(OR(COUNTRY_INFO!P21=\"Unknown\",COUNTRY_INFO!P21=\"Surveillance\",COUNTRY_INFO!P21=\"Not required\",COUNTRY_INFO!P21=0),0,IF(AND($E21<>0,$J21=\"\"),IF($F21=0,COUNTRY_INFO!P21*$E21,COUNTRY_INFO!P21*($E21-$D21)), IF(AND($E21<>0,$J21<>0),IF($F21=0,COUNTRY_INFO!P21*$J21,COUNTRY_INFO!P21*($J21-$D21)), COUNTRY_INFO!P21*$J21)))","v":153888},394528,0,null,0,240640,null,240640,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"Rivercess"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"Rivercess"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V22)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X22)","v":1},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D22=1,DEC!I22,0),IF($D22=1,IVM!G22,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N22=\"Unknown\",COUNTRY_INFO!N22=\"Surveillance\",COUNTRY_INFO!N22=\"Not required\",COUNTRY_INFO!N22=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E22<>0,$G22=\"\"),IF($F22=0,COUNTRY_INFO!N22*$E22,COUNTRY_INFO!N22*($E22-$D22)),IF(AND($E22<>0,$G22<>0),IF($F22=0,COUNTRY_INFO!N22*$G22,COUNTRY_INFO!N22*($G22-$D22)),0)),IF($G22=\"\",COUNTRY_INFO!N22*$E22,COUNTRY_INFO!N22*$G22)))","v":11135},{"$f":"IF(OR(COUNTRY_INFO!O22=\"Unknown\",COUNTRY_INFO!O22=\"Surveillance\",COUNTRY_INFO!O22=\"Not required\",COUNTRY_INFO!O22=0),0,IF($E22<>0, IF($F22=0,COUNTRY_INFO!O22*$E22,COUNTRY_INFO!O22*($E22-$D22)),COUNTRY_INFO!O22*$E22))","v":26109},null,{"$f":"IF(OR(COUNTRY_INFO!P22=\"Unknown\",COUNTRY_INFO!P22=\"Surveillance\",COUNTRY_INFO!P22=\"Not required\",COUNTRY_INFO!P22=0),0,IF(AND($E22<>0,$J22=\"\"),IF($F22=0,COUNTRY_INFO!P22*$E22,COUNTRY_INFO!P22*($E22-$D22)), IF(AND($E22<>0,$J22<>0),IF($F22=0,COUNTRY_INFO!P22*$J22,COUNTRY_INFO!P22*($J22-$D22)), COUNTRY_INFO!P22*$J22)))","v":23818},61062,0,null,0,37244,null,37244,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"Rivergee"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Rivergee"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V23)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X23)","v":1},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D23=1,DEC!I23,0),IF($D23=1,IVM!G23,0))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!N23=\"Unknown\",COUNTRY_INFO!N23=\"Surveillance\",COUNTRY_INFO!N23=\"Not required\",COUNTRY_INFO!N23=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E23<>0,$G23=\"\"),IF($F23=0,COUNTRY_INFO!N23*$E23,COUNTRY_INFO!N23*($E23-$D23)),IF(AND($E23<>0,$G23<>0),IF($F23=0,COUNTRY_INFO!N23*$G23,COUNTRY_INFO!N23*($G23-$D23)),0)),IF($G23=\"\",COUNTRY_INFO!N23*$E23,COUNTRY_INFO!N23*$G23)))","v":10400},{"$f":"IF(OR(COUNTRY_INFO!O23=\"Unknown\",COUNTRY_INFO!O23=\"Surveillance\",COUNTRY_INFO!O23=\"Not required\",COUNTRY_INFO!O23=0),0,IF($E23<>0, IF($F23=0,COUNTRY_INFO!O23*$E23,COUNTRY_INFO!O23*($E23-$D23)),COUNTRY_INFO!O23*$E23))","v":24386},null,{"$f":"IF(OR(COUNTRY_INFO!P23=\"Unknown\",COUNTRY_INFO!P23=\"Surveillance\",COUNTRY_INFO!P23=\"Not required\",COUNTRY_INFO!P23=0),0,IF(AND($E23<>0,$J23=\"\"),IF($F23=0,COUNTRY_INFO!P23*$E23,COUNTRY_INFO!P23*($E23-$D23)), IF(AND($E23<>0,$J23<>0),IF($F23=0,COUNTRY_INFO!P23*$J23,COUNTRY_INFO!P23*($J23-$D23)), COUNTRY_INFO!P23*$J23)))","v":22246},57032,0,null,0,34786,null,34786,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Liberia"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"Sinoe"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),\" \",IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"Sinoe"},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!V24)","v":1},{"$f":"IF(AND(INTRO!$E$37=\"Non-endemic\",INTRO!$E$41=\"Non-endemic\"),0,COUNTRY_INFO!X24)","v":2},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",IF($D24=1,DEC!I24,0),IF($D24=1,IVM!G24,0))","v":120105},null,{"$f":"IF(OR(COUNTRY_INFO!N24=\"Unknown\",COUNTRY_INFO!N24=\"Surveillance\",COUNTRY_INFO!N24=\"Not required\",COUNTRY_INFO!N24=0),0,IF(INTRO!$E$39=\"Non-endemic\",IF(AND($E24<>0,$G24=\"\"),IF($F24=0,COUNTRY_INFO!N24*$E24,COUNTRY_INFO!N24*($E24-$D24)),IF(AND($E24<>0,$G24<>0),IF($F24=0,COUNTRY_INFO!N24*$G24,COUNTRY_INFO!N24*($G24-$D24)),0)),IF($G24=\"\",COUNTRY_INFO!N24*$E24,COUNTRY_INFO!N24*$G24)))","v":31888},{"$f":"IF(OR(COUNTRY_INFO!O24=\"Unknown\",COUNTRY_INFO!O24=\"Surveillance\",COUNTRY_INFO!O24=\"Not required\",COUNTRY_INFO!O24=0),0,IF($E24<>0, IF($F24=0,COUNTRY_INFO!O24*$E24,COUNTRY_INFO!O24*($E24-$D24)),COUNTRY_INFO!O24*$E24))","v":37385},null,{"$f":"IF(OR(COUNTRY_INFO!P24=\"Unknown\",COUNTRY_INFO!P24=\"Surveillance\",COUNTRY_INFO!P24=\"Not required\",COUNTRY_INFO!P24=0),0,IF(AND($E24<>0,$J24=\"\"),IF($F24=0,COUNTRY_INFO!P24*$E24,COUNTRY_INFO!P24*($E24-$D24)), IF(AND($E24<>0,$J24<>0),IF($F24=0,COUNTRY_INFO!P24*$J24,COUNTRY_INFO!P24*($J24-$D24)), COUNTRY_INFO!P24*$J24)))","v":34103},103376,120105,null,120105,69273,null,69273,0,null,0]

{"sheet":"PZQ","index":4,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,0,3,2],[5,0,5,2],[5,4,5,7],[5,8,5,9],[6,17,7,17],[6,6,7,6],[6,7,7,7],[6,9,7,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,4,7,4],[5,3,7,3],[6,5,7,5],[6,8,7,8],[6,12,7,12],[5,12,5,17],[5,10,5,11],[6,10,7,10],[6,14,7,14],[6,15,7,15],[6,16,7,16],[6,13,7,13],[6,11,7,11]]}
["Praziquantel (PZQ)"]
["Administrative structure, eligible population by age group, treatment plan and information about tablets"]
[]
["TOTAL",null,null,null,{"$f":"SUBTOTAL(9,E$10:E$1010)","v":141116},441176,976182,1558474,null,0,null,null,{"$f":"SUBTOTAL(9,M$10:M$1010)","v":0},882352,2928546,3810898,0,3810898]
[]
["Country administrative structure",null,null,"Treatment plan\nSCH","Target population for SCH",null,null,null,"Hot spots",null,"Previous year MDA",null,"Praziquantel (PZQ)"]
["Country","Province/State","District",null,"PreSAC","SAC","Adults","Total","Planned","Population","Rounds","Age groups","PreSAC","SAC","Adults","Total required","Remaining in stock","Tablets to be procured"]
[]
[]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"Bomi"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Bomi"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y10)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R10=\"Unknown\",COUNTRY_INFO!R10=\"Surveillance\",COUNTRY_INFO!R10=\"Not required\",COUNTRY_INFO!R10=0),0,IF($D10<>0, COUNTRY_INFO!R10,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S10=\"Unknown\",COUNTRY_INFO!S10=\"Surveillance\",COUNTRY_INFO!S10=\"Not required\",COUNTRY_INFO!S10=0),0,IF($D10<>0, COUNTRY_INFO!S10,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T10=\"Unknown\",COUNTRY_INFO!T10=\"Surveillance\",COUNTRY_INFO!T10=\"Not required\",COUNTRY_INFO!T10=0),0,IF($D10<>0, COUNTRY_INFO!T10,0))","v":0},{"$f":"SUM(E10:G10)","v":0},null,null,null,null,null,{"$f":"IF($I10<>\"Yes\",$F10*2,($F10+ROUND(J10*$F10/SUM(COUNTRY_INFO!$E10:$G10),0))*2)","v":0},{"$f":"IF($I10<>\"Yes\",$G10*3,($G10+ROUND(J10*$G10/SUM(COUNTRY_INFO!$E10:$G10),0))*3)","v":0},{"$f":"SUM(M10:O10)","v":0},null,{"$f":"IF($P10>$Q10,P10-Q10,0)","v":0}]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"Bong"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Bong"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y11)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R11=\"Unknown\",COUNTRY_INFO!R11=\"Surveillance\",COUNTRY_INFO!R11=\"Not required\",COUNTRY_INFO!R11=0),0,IF($D11<>0, COUNTRY_INFO!R11,0))","v":38947},{"$f":"IF(OR(COUNTRY_INFO!S11=\"Unknown\",COUNTRY_INFO!S11=\"Surveillance\",COUNTRY_INFO!S11=\"Not required\",COUNTRY_INFO!S11=0),0,IF($D11<>0, COUNTRY_INFO!S11,0))","v":121760},{"$f":"IF(OR(COUNTRY_INFO!T11=\"Unknown\",COUNTRY_INFO!T11=\"Surveillance\",COUNTRY_INFO!T11=\"Not required\",COUNTRY_INFO!T11=0),0,IF($D11<>0, COUNTRY_INFO!T11,0))","v":269417},{"$f":"SUM(E11:G11)","v":430124},null,null,null,null,null,{"$f":"IF($I11<>\"Yes\",$F11*2,($F11+ROUND(J11*$F11/SUM(COUNTRY_INFO!$E11:$G11),0))*2)","v":243520},{"$f":"IF($I11<>\"Yes\",$G11*3,($G11+ROUND(J11*$G11/SUM(COUNTRY_INFO!$E11:$G11),0))*3)","v":808251},{"$f":"SUM(M11:O11)","v":1051771},null,{"$f":"IF($P11>$Q11,P11-Q11,0)","v":1051771}]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Gbarpolu"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"Gbarpolu"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y12)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R12=\"Unknown\",COUNTRY_INFO!R12=\"Surveillance\",COUNTRY_INFO!R12=\"Not required\",COUNTRY_INFO!R12=0),0,IF($D12<>0, COUNTRY_INFO!R12,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S12=\"Unknown\",COUNTRY_INFO!S12=\"Surveillance\",COUNTRY_INFO!S12=\"Not required\",COUNTRY_INFO!S12=0),0,IF($D12<>0, COUNTRY_INFO!S12,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T12=\"Unknown\",COUNTRY_INFO!T12=\"Surveillance\",COUNTRY_INFO!T12=\"Not required\",COUNTRY_INFO!T12=0),0,IF($D12<>0, COUNTRY_INFO!T12,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I12<>\"Yes\",$F12*2,($F12+ROUND(J12*$F12/SUM(COUNTRY_INFO!$E12:$G12),0))*2)","v":0},{"$f":"IF($I12<>\"Yes\",$G12*3,($G12+ROUND(J12*$G12/SUM(COUNTRY_INFO!$E12:$G12),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"Grand Bassa"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Grand Bassa"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y13)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R13=\"Unknown\",COUNTRY_INFO!R13=\"Surveillance\",COUNTRY_INFO!R13=\"Not required\",COUNTRY_INFO!R13=0),0,IF($D13<>0, COUNTRY_INFO!R13,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S13=\"Unknown\",COUNTRY_INFO!S13=\"Surveillance\",COUNTRY_INFO!S13=\"Not required\",COUNTRY_INFO!S13=0),0,IF($D13<>0, COUNTRY_INFO!S13,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T13=\"Unknown\",COUNTRY_INFO!T13=\"Surveillance\",COUNTRY_INFO!T13=\"Not required\",COUNTRY_INFO!T13=0),0,IF($D13<>0, COUNTRY_INFO!T13,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I13<>\"Yes\",$F13*2,($F13+ROUND(J13*$F13/SUM(COUNTRY_INFO!$E13:$G13),0))*2)","v":0},{"$f":"IF($I13<>\"Yes\",$G13*3,($G13+ROUND(J13*$G13/SUM(COUNTRY_INFO!$E13:$G13),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"Grand Cape Mount"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Grand Cape Mount"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y14)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R14=\"Unknown\",COUNTRY_INFO!R14=\"Surveillance\",COUNTRY_INFO!R14=\"Not required\",COUNTRY_INFO!R14=0),0,IF($D14<>0, COUNTRY_INFO!R14,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S14=\"Unknown\",COUNTRY_INFO!S14=\"Surveillance\",COUNTRY_INFO!S14=\"Not required\",COUNTRY_INFO!S14=0),0,IF($D14<>0, COUNTRY_INFO!S14,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T14=\"Unknown\",COUNTRY_INFO!T14=\"Surveillance\",COUNTRY_INFO!T14=\"Not required\",COUNTRY_INFO!T14=0),0,IF($D14<>0, COUNTRY_INFO!T14,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I14<>\"Yes\",$F14*2,($F14+ROUND(J14*$F14/SUM(COUNTRY_INFO!$E14:$G14),0))*2)","v":0},{"$f":"IF($I14<>\"Yes\",$G14*3,($G14+ROUND(J14*$G14/SUM(COUNTRY_INFO!$E14:$G14),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"Grand Gedeh"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Grand Gedeh"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y15)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R15=\"Unknown\",COUNTRY_INFO!R15=\"Surveillance\",COUNTRY_INFO!R15=\"Not required\",COUNTRY_INFO!R15=0),0,IF($D15<>0, COUNTRY_INFO!R15,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S15=\"Unknown\",COUNTRY_INFO!S15=\"Surveillance\",COUNTRY_INFO!S15=\"Not required\",COUNTRY_INFO!S15=0),0,IF($D15<>0, COUNTRY_INFO!S15,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T15=\"Unknown\",COUNTRY_INFO!T15=\"Surveillance\",COUNTRY_INFO!T15=\"Not required\",COUNTRY_INFO!T15=0),0,IF($D15<>0, COUNTRY_INFO!T15,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I15<>\"Yes\",$F15*2,($F15+ROUND(J15*$F15/SUM(COUNTRY_INFO!$E15:$G15),0))*2)","v":0},{"$f":"IF($I15<>\"Yes\",$G15*3,($G15+ROUND(J15*$G15/SUM(COUNTRY_INFO!$E15:$G15),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"Grand Kru"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Grand Kru"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y16)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R16=\"Unknown\",COUNTRY_INFO!R16=\"Surveillance\",COUNTRY_INFO!R16=\"Not required\",COUNTRY_INFO!R16=0),0,IF($D16<>0, COUNTRY_INFO!R16,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S16=\"Unknown\",COUNTRY_INFO!S16=\"Surveillance\",COUNTRY_INFO!S16=\"Not required\",COUNTRY_INFO!S16=0),0,IF($D16<>0, COUNTRY_INFO!S16,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T16=\"Unknown\",COUNTRY_INFO!T16=\"Surveillance\",COUNTRY_INFO!T16=\"Not required\",COUNTRY_INFO!T16=0),0,IF($D16<>0, COUNTRY_INFO!T16,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I16<>\"Yes\",$F16*2,($F16+ROUND(J16*$F16/SUM(COUNTRY_INFO!$E16:$G16),0))*2)","v":0},{"$f":"IF($I16<>\"Yes\",$G16*3,($G16+ROUND(J16*$G16/SUM(COUNTRY_INFO!$E16:$G16),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"Lofa"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Lofa"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y17)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R17=\"Unknown\",COUNTRY_INFO!R17=\"Surveillance\",COUNTRY_INFO!R17=\"Not required\",COUNTRY_INFO!R17=0),0,IF($D17<>0, COUNTRY_INFO!R17,0))","v":32334},{"$f":"IF(OR(COUNTRY_INFO!S17=\"Unknown\",COUNTRY_INFO!S17=\"Surveillance\",COUNTRY_INFO!S17=\"Not required\",COUNTRY_INFO!S17=0),0,IF($D17<>0, COUNTRY_INFO!S17,0))","v":101088},{"$f":"IF(OR(COUNTRY_INFO!T17=\"Unknown\",COUNTRY_INFO!T17=\"Surveillance\",COUNTRY_INFO!T17=\"Not required\",COUNTRY_INFO!T17=0),0,IF($D17<>0, COUNTRY_INFO!T17,0))","v":223675},357097,null,null,null,null,null,{"$f":"IF($I17<>\"Yes\",$F17*2,($F17+ROUND(J17*$F17/SUM(COUNTRY_INFO!$E17:$G17),0))*2)","v":202176},{"$f":"IF($I17<>\"Yes\",$G17*3,($G17+ROUND(J17*$G17/SUM(COUNTRY_INFO!$E17:$G17),0))*3)","v":671025},873201,null,873201]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"Margibi"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Margibi"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y18)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R18=\"Unknown\",COUNTRY_INFO!R18=\"Surveillance\",COUNTRY_INFO!R18=\"Not required\",COUNTRY_INFO!R18=0),0,IF($D18<>0, COUNTRY_INFO!R18,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S18=\"Unknown\",COUNTRY_INFO!S18=\"Surveillance\",COUNTRY_INFO!S18=\"Not required\",COUNTRY_INFO!S18=0),0,IF($D18<>0, COUNTRY_INFO!S18,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T18=\"Unknown\",COUNTRY_INFO!T18=\"Surveillance\",COUNTRY_INFO!T18=\"Not required\",COUNTRY_INFO!T18=0),0,IF($D18<>0, COUNTRY_INFO!T18,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I18<>\"Yes\",$F18*2,($F18+ROUND(J18*$F18/SUM(COUNTRY_INFO!$E18:$G18),0))*2)","v":0},{"$f":"IF($I18<>\"Yes\",$G18*3,($G18+ROUND(J18*$G18/SUM(COUNTRY_INFO!$E18:$G18),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"Maryland "},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Maryland "},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y19)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R19=\"Unknown\",COUNTRY_INFO!R19=\"Surveillance\",COUNTRY_INFO!R19=\"Not required\",COUNTRY_INFO!R19=0),0,IF($D19<>0, COUNTRY_INFO!R19,0))","v":15876},{"$f":"IF(OR(COUNTRY_INFO!S19=\"Unknown\",COUNTRY_INFO!S19=\"Surveillance\",COUNTRY_INFO!S19=\"Not required\",COUNTRY_INFO!S19=0),0,IF($D19<>0, COUNTRY_INFO!S19,0))","v":49633},{"$f":"IF(OR(COUNTRY_INFO!T19=\"Unknown\",COUNTRY_INFO!T19=\"Surveillance\",COUNTRY_INFO!T19=\"Not required\",COUNTRY_INFO!T19=0),0,IF($D19<>0, COUNTRY_INFO!T19,0))","v":109823},175332,null,null,null,null,null,{"$f":"IF($I19<>\"Yes\",$F19*2,($F19+ROUND(J19*$F19/SUM(COUNTRY_INFO!$E19:$G19),0))*2)","v":99266},{"$f":"IF($I19<>\"Yes\",$G19*3,($G19+ROUND(J19*$G19/SUM(COUNTRY_INFO!$E19:$G19),0))*3)","v":329469},428735,null,428735]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Montserrado"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Montserrado"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y20)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R20=\"Unknown\",COUNTRY_INFO!R20=\"Surveillance\",COUNTRY_INFO!R20=\"Not required\",COUNTRY_INFO!R20=0),0,IF($D20<>0, COUNTRY_INFO!R20,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S20=\"Unknown\",COUNTRY_INFO!S20=\"Surveillance\",COUNTRY_INFO!S20=\"Not required\",COUNTRY_INFO!S20=0),0,IF($D20<>0, COUNTRY_INFO!S20,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T20=\"Unknown\",COUNTRY_INFO!T20=\"Surveillance\",COUNTRY_INFO!T20=\"Not required\",COUNTRY_INFO!T20=0),0,IF($D20<>0, COUNTRY_INFO!T20,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I20<>\"Yes\",$F20*2,($F20+ROUND(J20*$F20/SUM(COUNTRY_INFO!$E20:$G20),0))*2)","v":0},{"$f":"IF($I20<>\"Yes\",$G20*3,($G20+ROUND(J20*$G20/SUM(COUNTRY_INFO!$E20:$G20),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"Nimba"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Nimba"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y21)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R21=\"Unknown\",COUNTRY_INFO!R21=\"Surveillance\",COUNTRY_INFO!R21=\"Not required\",COUNTRY_INFO!R21=0),0,IF($D21<>0, COUNTRY_INFO!R21,0))","v":53959},{"$f":"IF(OR(COUNTRY_INFO!S21=\"Unknown\",COUNTRY_INFO!S21=\"Surveillance\",COUNTRY_INFO!S21=\"Not required\",COUNTRY_INFO!S21=0),0,IF($D21<>0, COUNTRY_INFO!S21,0))","v":168695},{"$f":"IF(OR(COUNTRY_INFO!T21=\"Unknown\",COUNTRY_INFO!T21=\"Surveillance\",COUNTRY_INFO!T21=\"Not required\",COUNTRY_INFO!T21=0),0,IF($D21<>0, COUNTRY_INFO!T21,0))","v":373267},595921,null,null,null,null,null,{"$f":"IF($I21<>\"Yes\",$F21*2,($F21+ROUND(J21*$F21/SUM(COUNTRY_INFO!$E21:$G21),0))*2)","v":337390},{"$f":"IF($I21<>\"Yes\",$G21*3,($G21+ROUND(J21*$G21/SUM(COUNTRY_INFO!$E21:$G21),0))*3)","v":1119801},1457191,null,1457191]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"Rivercess"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"Rivercess"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y22)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R22=\"Unknown\",COUNTRY_INFO!R22=\"Surveillance\",COUNTRY_INFO!R22=\"Not required\",COUNTRY_INFO!R22=0),0,IF($D22<>0, COUNTRY_INFO!R22,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S22=\"Unknown\",COUNTRY_INFO!S22=\"Surveillance\",COUNTRY_INFO!S22=\"Not required\",COUNTRY_INFO!S22=0),0,IF($D22<>0, COUNTRY_INFO!S22,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T22=\"Unknown\",COUNTRY_INFO!T22=\"Surveillance\",COUNTRY_INFO!T22=\"Not required\",COUNTRY_INFO!T22=0),0,IF($D22<>0, COUNTRY_INFO!T22,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I22<>\"Yes\",$F22*2,($F22+ROUND(J22*$F22/SUM(COUNTRY_INFO!$E22:$G22),0))*2)","v":0},{"$f":"IF($I22<>\"Yes\",$G22*3,($G22+ROUND(J22*$G22/SUM(COUNTRY_INFO!$E22:$G22),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"Rivergee"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Rivergee"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y23)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R23=\"Unknown\",COUNTRY_INFO!R23=\"Surveillance\",COUNTRY_INFO!R23=\"Not required\",COUNTRY_INFO!R23=0),0,IF($D23<>0, COUNTRY_INFO!R23,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S23=\"Unknown\",COUNTRY_INFO!S23=\"Surveillance\",COUNTRY_INFO!S23=\"Not required\",COUNTRY_INFO!S23=0),0,IF($D23<>0, COUNTRY_INFO!S23,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T23=\"Unknown\",COUNTRY_INFO!T23=\"Surveillance\",COUNTRY_INFO!T23=\"Not required\",COUNTRY_INFO!T23=0),0,IF($D23<>0, COUNTRY_INFO!T23,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I23<>\"Yes\",$F23*2,($F23+ROUND(J23*$F23/SUM(COUNTRY_INFO!$E23:$G23),0))*2)","v":0},{"$f":"IF($I23<>\"Yes\",$G23*3,($G23+ROUND(J23*$G23/SUM(COUNTRY_INFO!$E23:$G23),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Liberia"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"Sinoe"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\",\" \", IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"Sinoe"},{"$f":"IF(INTRO!$E$43=\"Non-endemic\", \"Not required\", COUNTRY_INFO!Y24)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R24=\"Unknown\",COUNTRY_INFO!R24=\"Surveillance\",COUNTRY_INFO!R24=\"Not required\",COUNTRY_INFO!R24=0),0,IF($D24<>0, COUNTRY_INFO!R24,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S24=\"Unknown\",COUNTRY_INFO!S24=\"Surveillance\",COUNTRY_INFO!S24=\"Not required\",COUNTRY_INFO!S24=0),0,IF($D24<>0, COUNTRY_INFO!S24,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T24=\"Unknown\",COUNTRY_INFO!T24=\"Surveillance\",COUNTRY_INFO!T24=\"Not required\",COUNTRY_INFO!T24=0),0,IF($D24<>0, COUNTRY_INFO!T24,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I24<>\"Yes\",$F24*2,($F24+ROUND(J24*$F24/SUM(COUNTRY_INFO!$E24:$G24),0))*2)","v":0},{"$f":"IF($I24<>\"Yes\",$G24*3,($G24+ROUND(J24*$G24/SUM(COUNTRY_INFO!$E24:$G24),0))*3)","v":0},0,null,0]

{"sheet":"IVM","index":5,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,4,3,5],[6,4,7,4],[6,5,7,5],[5,8,5,13],[6,0,7,0],[6,1,7,1],[6,2,7,2],[5,0,5,2],[5,4,5,5],[5,6,5,7],[6,12,7,12],[5,3,7,3],[6,13,7,13],[6,8,7,8],[6,6,7,6],[6,7,7,7],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["Ivermectin (IVM)"]
["Administrative structure, eligible population by age group, treatment plan and information about tablets"]
[]
["TOTAL",null,null,{"$f":"SUBTOTAL(9,D$10:D$1010)","v":4073486},null,null,{"$f":"SUBTOTAL(9,G$10:G$1010)","v":887731},4073486,0,8920113.9999999981,2485646.7999999998,11405760.799999999,0,11405760.799999999]
[]
["Country administrative structure",null,null,"Population requiring treatment with IVM","Treatment plan",null,"Target population",null,"Ivermectin (IVM)"]
["Country","Province/State","District",null,"LF","Oncho","LF","Oncho","LF only","Oncho only","LF+Oncho","Total required","Remaining in stock","Tablets to be procured"]
[]
[]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"Bomi"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Bomi"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!F10+COUNTRY_INFO!G10,0),IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!F10+COUNTRY_INFO!G10,IF(COUNTRY_INFO!$I10=1,IF(COUNTRY_INFO!M10>=(COUNTRY_INFO!F10+COUNTRY_INFO!G10),COUNTRY_INFO!F10+COUNTRY_INFO!G10,COUNTRY_INFO!$M10),0))))","v":98672},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V10))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W10,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H10=1, IF($E10=1,$D10, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I10=1, IF(AND(COUNTRY_INFO!$I10=1,$F10<>0),IF(COUNTRY_INFO!M10>=(COUNTRY_INFO!F10+COUNTRY_INFO!G10),COUNTRY_INFO!F10+COUNTRY_INFO!G10,COUNTRY_INFO!$M10), 0),0)","v":98672},{"$f":"IF(G10<H10,0,IF($E10=1, (G10-H10)*2.8, 0))","v":0},{"$f":"IF($E10<$F10, H10*(F10-E10)*2.8, 0)","v":276281.59999999998},{"$f":"IF(AND($E10=1, $F10<>0), H10*2.8, 0)","v":0},{"$f":"SUM(I10:K10)","v":276281.59999999998},null,{"$f":"IF($L10>$M10,$L10-$M10,0)","v":276281.59999999998}]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"Bong"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Bong"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!F11+COUNTRY_INFO!G11,0),IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!F11+COUNTRY_INFO!G11,IF(COUNTRY_INFO!$I11=1,IF(COUNTRY_INFO!M11>=(COUNTRY_INFO!F11+COUNTRY_INFO!G11),COUNTRY_INFO!F11+COUNTRY_INFO!G11,COUNTRY_INFO!$M11),0))))","v":391177},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V11))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W11,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H11=1, IF($E11=1,$D11, 0),0)","v":391177},{"$f":"IF(COUNTRY_INFO!I11=1, IF(AND(COUNTRY_INFO!$I11=1,$F11<>0),IF(COUNTRY_INFO!M11>=(COUNTRY_INFO!F11+COUNTRY_INFO!G11),COUNTRY_INFO!F11+COUNTRY_INFO!G11,COUNTRY_INFO!$M11), 0),0)","v":391177},0,0,{"$f":"IF(AND($E11=1, $F11<>0), H11*2.8, 0)","v":1095295.5999999999},{"$f":"SUM(I11:K11)","v":1095295.5999999999},null,1095295.5999999999]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Gbarpolu"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"Gbarpolu"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!F12+COUNTRY_INFO!G12,0),IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!F12+COUNTRY_INFO!G12,IF(COUNTRY_INFO!$I12=1,IF(COUNTRY_INFO!M12>=(COUNTRY_INFO!F12+COUNTRY_INFO!G12),COUNTRY_INFO!F12+COUNTRY_INFO!G12,COUNTRY_INFO!$M12),0))))","v":97815},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V12))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W12,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H12=1, IF($E12=1,$D12, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I12=1, IF(AND(COUNTRY_INFO!$I12=1,$F12<>0),IF(COUNTRY_INFO!M12>=(COUNTRY_INFO!F12+COUNTRY_INFO!G12),COUNTRY_INFO!F12+COUNTRY_INFO!G12,COUNTRY_INFO!$M12), 0),0)","v":97815},0,273882,0,273882,null,273882]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"Grand Bassa"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Grand Bassa"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!F13+COUNTRY_INFO!G13,0),IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!F13+COUNTRY_INFO!G13,IF(COUNTRY_INFO!$I13=1,IF(COUNTRY_INFO!M13>=(COUNTRY_INFO!F13+COUNTRY_INFO!G13),COUNTRY_INFO!F13+COUNTRY_INFO!G13,COUNTRY_INFO!$M13),0))))","v":260048},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V13))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W13,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H13=1, IF($E13=1,$D13, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I13=1, IF(AND(COUNTRY_INFO!$I13=1,$F13<>0),IF(COUNTRY_INFO!M13>=(COUNTRY_INFO!F13+COUNTRY_INFO!G13),COUNTRY_INFO!F13+COUNTRY_INFO!G13,COUNTRY_INFO!$M13), 0),0)","v":260048},0,728134.39999999991,0,728134.39999999991,null,728134.39999999991]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"Grand Cape Mount"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Grand Cape Mount"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!F14+COUNTRY_INFO!G14,0),IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!F14+COUNTRY_INFO!G14,IF(COUNTRY_INFO!$I14=1,IF(COUNTRY_INFO!M14>=(COUNTRY_INFO!F14+COUNTRY_INFO!G14),COUNTRY_INFO!F14+COUNTRY_INFO!G14,COUNTRY_INFO!$M14),0))))","v":149061},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V14))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W14,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H14=1, IF($E14=1,$D14, 0),0)","v":149061},{"$f":"IF(COUNTRY_INFO!I14=1, IF(AND(COUNTRY_INFO!$I14=1,$F14<>0),IF(COUNTRY_INFO!M14>=(COUNTRY_INFO!F14+COUNTRY_INFO!G14),COUNTRY_INFO!F14+COUNTRY_INFO!G14,COUNTRY_INFO!$M14), 0),0)","v":149061},0,0,417370.8,417370.8,null,417370.8]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"Grand Gedeh"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Grand Gedeh"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!F15+COUNTRY_INFO!G15,0),IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!F15+COUNTRY_INFO!G15,IF(COUNTRY_INFO!$I15=1,IF(COUNTRY_INFO!M15>=(COUNTRY_INFO!F15+COUNTRY_INFO!G15),COUNTRY_INFO!F15+COUNTRY_INFO!G15,COUNTRY_INFO!$M15),0))))","v":146928},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V15))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W15,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H15=1, IF($E15=1,$D15, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I15=1, IF(AND(COUNTRY_INFO!$I15=1,$F15<>0),IF(COUNTRY_INFO!M15>=(COUNTRY_INFO!F15+COUNTRY_INFO!G15),COUNTRY_INFO!F15+COUNTRY_INFO!G15,COUNTRY_INFO!$M15), 0),0)","v":146928},0,411398.39999999997,0,411398.39999999997,null,411398.39999999997]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"Grand Kru"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Grand Kru"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!F16+COUNTRY_INFO!G16,0),IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!F16+COUNTRY_INFO!G16,IF(COUNTRY_INFO!$I16=1,IF(COUNTRY_INFO!M16>=(COUNTRY_INFO!F16+COUNTRY_INFO!G16),COUNTRY_INFO!F16+COUNTRY_INFO!G16,COUNTRY_INFO!$M16),0))))","v":67932},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V16))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W16,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H16=1, IF($E16=1,$D16, 0),0)","v":67932},{"$f":"IF(COUNTRY_INFO!I16=1, IF(AND(COUNTRY_INFO!$I16=1,$F16<>0),IF(COUNTRY_INFO!M16>=(COUNTRY_INFO!F16+COUNTRY_INFO!G16),COUNTRY_INFO!F16+COUNTRY_INFO!G16,COUNTRY_INFO!$M16), 0),0)","v":67932},0,0,190209.59999999998,190209.59999999998,null,190209.59999999998]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"Lofa"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Lofa"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!F17+COUNTRY_INFO!G17,0),IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!F17+COUNTRY_INFO!G17,IF(COUNTRY_INFO!$I17=1,IF(COUNTRY_INFO!M17>=(COUNTRY_INFO!F17+COUNTRY_INFO!G17),COUNTRY_INFO!F17+COUNTRY_INFO!G17,COUNTRY_INFO!$M17),0))))","v":324763},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V17))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W17,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H17=1, IF($E17=1,$D17, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I17=1, IF(AND(COUNTRY_INFO!$I17=1,$F17<>0),IF(COUNTRY_INFO!M17>=(COUNTRY_INFO!F17+COUNTRY_INFO!G17),COUNTRY_INFO!F17+COUNTRY_INFO!G17,COUNTRY_INFO!$M17), 0),0)","v":324763},0,909336.39999999991,0,909336.39999999991,null,909336.39999999991]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"Margibi"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Margibi"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!F18+COUNTRY_INFO!G18,0),IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!F18+COUNTRY_INFO!G18,IF(COUNTRY_INFO!$I18=1,IF(COUNTRY_INFO!M18>=(COUNTRY_INFO!F18+COUNTRY_INFO!G18),COUNTRY_INFO!F18+COUNTRY_INFO!G18,COUNTRY_INFO!$M18),0))))","v":246243},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V18))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W18,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H18=1, IF($E18=1,$D18, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I18=1, IF(AND(COUNTRY_INFO!$I18=1,$F18<>0),IF(COUNTRY_INFO!M18>=(COUNTRY_INFO!F18+COUNTRY_INFO!G18),COUNTRY_INFO!F18+COUNTRY_INFO!G18,COUNTRY_INFO!$M18), 0),0)","v":246243},0,689480.39999999991,0,689480.39999999991,null,689480.39999999991]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"Maryland "},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Maryland "},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!F19+COUNTRY_INFO!G19,0),IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!F19+COUNTRY_INFO!G19,IF(COUNTRY_INFO!$I19=1,IF(COUNTRY_INFO!M19>=(COUNTRY_INFO!F19+COUNTRY_INFO!G19),COUNTRY_INFO!F19+COUNTRY_INFO!G19,COUNTRY_INFO!$M19),0))))","v":159456},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V19))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W19,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H19=1, IF($E19=1,$D19, 0),0)","v":159456},{"$f":"IF(COUNTRY_INFO!I19=1, IF(AND(COUNTRY_INFO!$I19=1,$F19<>0),IF(COUNTRY_INFO!M19>=(COUNTRY_INFO!F19+COUNTRY_INFO!G19),COUNTRY_INFO!F19+COUNTRY_INFO!G19,COUNTRY_INFO!$M19), 0),0)","v":159456},0,0,446476.79999999999,446476.79999999999,null,446476.79999999999]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Montserrado"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Montserrado"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!F20+COUNTRY_INFO!G20,0),IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!F20+COUNTRY_INFO!G20,IF(COUNTRY_INFO!$I20=1,IF(COUNTRY_INFO!M20>=(COUNTRY_INFO!F20+COUNTRY_INFO!G20),COUNTRY_INFO!F20+COUNTRY_INFO!G20,COUNTRY_INFO!$M20),0))))","v":1307100},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V20))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W20,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H20=1, IF($E20=1,$D20, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I20=1, IF(AND(COUNTRY_INFO!$I20=1,$F20<>0),IF(COUNTRY_INFO!M20>=(COUNTRY_INFO!F20+COUNTRY_INFO!G20),COUNTRY_INFO!F20+COUNTRY_INFO!G20,COUNTRY_INFO!$M20), 0),0)","v":1307100},0,3659880,0,3659880,null,3659880]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"Nimba"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Nimba"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!F21+COUNTRY_INFO!G21,0),IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!F21+COUNTRY_INFO!G21,IF(COUNTRY_INFO!$I21=1,IF(COUNTRY_INFO!M21>=(COUNTRY_INFO!F21+COUNTRY_INFO!G21),COUNTRY_INFO!F21+COUNTRY_INFO!G21,COUNTRY_INFO!$M21),0))))","v":541962},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V21))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W21,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H21=1, IF($E21=1,$D21, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I21=1, IF(AND(COUNTRY_INFO!$I21=1,$F21<>0),IF(COUNTRY_INFO!M21>=(COUNTRY_INFO!F21+COUNTRY_INFO!G21),COUNTRY_INFO!F21+COUNTRY_INFO!G21,COUNTRY_INFO!$M21), 0),0)","v":541962},0,1517493.5999999999,0,1517493.5999999999,null,1517493.5999999999]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"Rivercess"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"Rivercess"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!F22+COUNTRY_INFO!G22,0),IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!F22+COUNTRY_INFO!G22,IF(COUNTRY_INFO!$I22=1,IF(COUNTRY_INFO!M22>=(COUNTRY_INFO!F22+COUNTRY_INFO!G22),COUNTRY_INFO!F22+COUNTRY_INFO!G22,COUNTRY_INFO!$M22),0))))","v":83880},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V22))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W22,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H22=1, IF($E22=1,$D22, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I22=1, IF(AND(COUNTRY_INFO!$I22=1,$F22<>0),IF(COUNTRY_INFO!M22>=(COUNTRY_INFO!F22+COUNTRY_INFO!G22),COUNTRY_INFO!F22+COUNTRY_INFO!G22,COUNTRY_INFO!$M22), 0),0)","v":83880},0,234863.99999999997,0,234863.99999999997,null,234863.99999999997]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"Rivergee"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Rivergee"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!F23+COUNTRY_INFO!G23,0),IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!F23+COUNTRY_INFO!G23,IF(COUNTRY_INFO!$I23=1,IF(COUNTRY_INFO!M23>=(COUNTRY_INFO!F23+COUNTRY_INFO!G23),COUNTRY_INFO!F23+COUNTRY_INFO!G23,COUNTRY_INFO!$M23),0))))","v":78344},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V23))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W23,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H23=1, IF($E23=1,$D23, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I23=1, IF(AND(COUNTRY_INFO!$I23=1,$F23<>0),IF(COUNTRY_INFO!M23>=(COUNTRY_INFO!F23+COUNTRY_INFO!G23),COUNTRY_INFO!F23+COUNTRY_INFO!G23,COUNTRY_INFO!$M23), 0),0)","v":78344},0,219363.19999999998,0,219363.19999999998,null,219363.19999999998]
[{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Liberia"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"Sinoe"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",\" \",IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"Sinoe"},{"$f":"IF(INTRO!$E$39=\"Non-endemic\",0,IF(INTRO!$E$39=\"Endemic but PC is not required\",IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!F24+COUNTRY_INFO!G24,0),IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!F24+COUNTRY_INFO!G24,IF(COUNTRY_INFO!$I24=1,IF(COUNTRY_INFO!M24>=(COUNTRY_INFO!F24+COUNTRY_INFO!G24),COUNTRY_INFO!F24+COUNTRY_INFO!G24,COUNTRY_INFO!$M24),0))))","v":120105},{"$f":"IF(AND(INTRO!$E$39=\"Non-endemic\",INTRO!$E$37=\"Non-endemic\"),\"Not required\",IF(INTRO!$E$39=\"Non-endemic\",\"Treat with DEC\",COUNTRY_INFO!V24))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non-endemic\",COUNTRY_INFO!W24,\"Not required\")","v":1},{"$f":"IF(COUNTRY_INFO!H24=1, IF($E24=1,$D24, 0),0)","v":120105},{"$f":"IF(COUNTRY_INFO!I24=1, IF(AND(COUNTRY_INFO!$I24=1,$F24<>0),IF(COUNTRY_INFO!M24>=(COUNTRY_INFO!F24+COUNTRY_INFO!G24),COUNTRY_INFO!F24+COUNTRY_INFO!G24,COUNTRY_INFO!$M24), 0),0)","v":120105},0,0,336294,336294,null,336294]

{"sheet":"IVM+","index":6,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":true,"merged":[[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[3,0,3,2],[5,0,5,2],[6,5,7,5],[6,6,7,6],[6,7,7,7],[5,4,7,4],[5,5,5,7]]}
["Ivermectin (IVM) for IDA therapy"]
["Administrative structure, eligible population by age group, treatment plan and information about tablets"]
[]
["TOTAL",null,null,null,{"$f":"SUBTOTAL(9,E$10:E$1010)","v":0},0,0,0]
[]
["Country administrative structure",null,null,"Treatment plan","Population targeted for treatment with IVM \n(IDA therapy)","Ivermectin (IVM)"]
["Country","Province/State","District","LF",null,"Total required","Remaining in stock","Tablets to be procured"]
[]
[]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z10<>\"\",COUNTRY_INFO!V10,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z10<>\"\",COUNTRY_INFO!$H10=1),COUNTRY_INFO!F10+COUNTRY_INFO!G10,0)","v":0},{"$f":"E10*2.8","v":0},null,{"$f":"IF($F10>$G10,$F10-$G10,0)","v":0}]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z11<>\"\",COUNTRY_INFO!V11,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z11<>\"\",COUNTRY_INFO!$H11=1),COUNTRY_INFO!F11+COUNTRY_INFO!G11,0)","v":0},{"$f":"E11*2.8","v":0},null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z12<>\"\",COUNTRY_INFO!V12,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z12<>\"\",COUNTRY_INFO!$H12=1),COUNTRY_INFO!F12+COUNTRY_INFO!G12,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z13<>\"\",COUNTRY_INFO!V13,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z13<>\"\",COUNTRY_INFO!$H13=1),COUNTRY_INFO!F13+COUNTRY_INFO!G13,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z14<>\"\",COUNTRY_INFO!V14,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z14<>\"\",COUNTRY_INFO!$H14=1),COUNTRY_INFO!F14+COUNTRY_INFO!G14,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z15<>\"\",COUNTRY_INFO!V15,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z15<>\"\",COUNTRY_INFO!$H15=1),COUNTRY_INFO!F15+COUNTRY_INFO!G15,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z16<>\"\",COUNTRY_INFO!V16,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z16<>\"\",COUNTRY_INFO!$H16=1),COUNTRY_INFO!F16+COUNTRY_INFO!G16,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z17<>\"\",COUNTRY_INFO!V17,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z17<>\"\",COUNTRY_INFO!$H17=1),COUNTRY_INFO!F17+COUNTRY_INFO!G17,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z18<>\"\",COUNTRY_INFO!V18,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z18<>\"\",COUNTRY_INFO!$H18=1),COUNTRY_INFO!F18+COUNTRY_INFO!G18,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z19<>\"\",COUNTRY_INFO!V19,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z19<>\"\",COUNTRY_INFO!$H19=1),COUNTRY_INFO!F19+COUNTRY_INFO!G19,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z20<>\"\",COUNTRY_INFO!V20,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z20<>\"\",COUNTRY_INFO!$H20=1),COUNTRY_INFO!F20+COUNTRY_INFO!G20,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z21<>\"\",COUNTRY_INFO!V21,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z21<>\"\",COUNTRY_INFO!$H21=1),COUNTRY_INFO!F21+COUNTRY_INFO!G21,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z22<>\"\",COUNTRY_INFO!V22,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z22<>\"\",COUNTRY_INFO!$H22=1),COUNTRY_INFO!F22+COUNTRY_INFO!G22,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z23<>\"\",COUNTRY_INFO!V23,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z23<>\"\",COUNTRY_INFO!$H23=1),COUNTRY_INFO!F23+COUNTRY_INFO!G23,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endemic\",INTRO!$E$39=\"Non-endemic\"),IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z24<>\"\",COUNTRY_INFO!V24,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z24<>\"\",COUNTRY_INFO!$H24=1),COUNTRY_INFO!F24+COUNTRY_INFO!G24,0)","v":0},0,null,0]

{"sheet":"SUMMARY","index":7,"n_rows":93,"n_cols":8,"rows_kept":93,"cut":false,"hidden":false,"merged":[[74,2,74,3],[74,4,74,5],[73,2,73,3],[73,4,73,5],[60,4,60,6],[61,4,61,6],[62,4,62,6],[72,2,72,3],[72,4,72,5],[25,1,27,1],[9,7,10,7],[32,2,35,4],[81,2,81,7],[83,3,83,7],[59,4,59,6],[50,1,50,7],[56,1,56,7],[51,1,51,7],[52,1,52,7],[80,1,80,7],[58,1,58,7],[78,1,78,7],[79,1,79,7],[66,1,66,7],[76,2,76,3],[9,1,10,1],[9,3,9,6],[9,2,10,2],[17,1,19,1],[21,1,23,1],[83,1,83,2],[0,1,0,7],[1,1,1,7],[2,1,2,5],[3,1,3,7],[4,1,4,7],[6,1,6,7],[5,2,5,5],[65,1,65,7],[54,1,54,7],[53,1,53,7],[36,1,36,7],[41,2,41,3],[41,4,41,5],[41,6,41,7],[55,1,55,7],[82,2,82,6],[63,4,63,6],[75,2,75,3],[97,1,97,7],[75,4,75,5],[70,4,70,5],[71,4,71,5],[70,2,70,3],[71,2,71,3],[92,1,92,7],[76,4,76,5],[87,1,87,7],[91,1,91,7],[86,1,86,7],[84,1,84,2],[84,3,84,7]]}
[]
[null,"Joint request for selected PC medicines v.4.1"]
[]
[null,"This form constitutes an official government request to WHO for the supply of the PC medicines. To ensure the medicines are delivered on time, the request for PC medicines should be submitted at least 9 months before the first date of MDA planned in the calendar year of the request. "]
[]
[null,"Country",{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Liberia"},null,null,null,"Year",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2024}]
[]
[null,"Information on PC medicines requested to WHO"]
[]
[null,"PC medicine","Target group","Number of tablets",null,null,null,"Specify \nsource"]
[null,null,null,"Required","In stock","In pipeline","Requested"]
[null,"Diethylcarbamazine citrate","ALL",0,0,null,{"$f":"IF(D12>(E12+F12),D12-E12-F12, 0)","v":0}]
[null,null,null,null,null,null,0]
[null,"Ivermectin","ALL",11405760.799999999,1914092,null,9491668.7999999989]
[]
[null,"Albendazole for LF","ALL",887731,0,null,887731]
[null,null,null,null,null,null,0]
[null,"Albendazole for STH","PreSAC",291978,null,null,291978]
[null,null,"SAC",408297,null,null,408297]
[null,null,"WRA",null,null,null,0]
[]
[null,"Mebendazole","PreSAC",null,null,null,0]
[null,null,"SAC",null,null,null,0]
[null,null,"WRA",null,null,null,0]
[]
[null,"Praziquantel","PreSAC",0,null,null,0]
[null,null,"SAC",882352,null,null,882352]
[null,null,"Adults",2928546,null,null,{"$f":"IF(D28>(E28+F28),D28-E28-F28, 0)","v":2928546}]
[]
[null,"Number of people to be treated with donated medicine ( see User Guide for details )"]
[]
[null,"Disease",null,null,null,"Round 1","Round 2","Round 3"]
[null,"Lymphatic filariasis","These figures are estimated only \nfor targeted age groups to be treated \nwith donated medicines in areas \nwhere treatment for \na specific disease is planned",null,null,887731]
[null,"Onchocerciasis",null,null,null,4073486,0]
[null,"Schistosomiasis",null,null,null,1417358,0]
[null,"Soil-transmitted helminthiases",null,null,null,1276445,252962,0]
[]
[]
[]
[null,"Information on planned PC interventions"]
[]
[null,"PC medicine","Planned date of the \n1st round of PC",null,"Planned date of the \n2nd round of PC",null,"Date by which the medicine should arrive to the national warehouse"]
[null,"Diethylcarbamazine citrate"]
[null,"Ivermectin","April",2024,null,null,"February",2024]
[null,"Albendazole for LF","April",2024,null,null,"February",2024]
[null,"Albendazole for STH","April",2024,null,null,"February",2024]
[null,"Mebendazole"]
[null,"Praziquantel","April",2024,null,null,"February",2024]
[]
[null,"Checklist"]
[null,"Submission"]
[null,"What should be submitted?"]
[null,"The supply of the requested medicines should be based on up-to-date epidemiological data, specific usage plans, and capacity for implementation. The following checklist ensures that all necessary forms and information are provided to WHO (in electronic format). "]
[null,"Joint request for selected PC medicines"]
[null,"Joint reporting form"]
[null,"PC epidemiological data reporting form"]
[]
[null,"Availability of funding for implementation in the year for which the medicines are requested"]
[]
[null,"Diseases \ntargeted for implementation","Total treatments","Funding secured for","Source",null,null,"Amount"]
[null,{"$f":"B33","v":"Lymphatic filariasis"},{"$f":"SUM(F33:H33)","v":887731},"N/A","Sightsavers"]
[null,{"$f":"B34","v":"Onchocerciasis"},{"$f":"SUM(F34:H34)","v":4073486},"N/A","Sightsavers"]
[null,{"$f":"B35","v":"Schistosomiasis"},{"$f":"SUM(F35:H35)","v":1417358},"N/A","N/A"]
[null,{"$f":"B36","v":"Soil-transmitted helminthiases"},{"$f":"SUM(F36:H36)","v":1529407},"N/A","Sightsavers"]
[]
[null,"Who should fill in the form? "]
[null,"National NTD coordinator should compile all required information needed to complete the request form. In the absence of such a coordinator, specific programme managers should coordinate their respective part. The final single request must be approved by the Ministry of Health."]
[]
[null,"Information on person(s) who has filled in the form"]
[]
[null,"Title ","Name",null,"Phone",null,"Email","Date"]
[null,"ONCHO Programme Manager","Sonnie Ziama Gbewo",null,886634780,null,"sonnieziama@gmail.com","2023-05-03"]
[null,"LF Programme Manager","Abraham Nyenswah",null,777025215,null,"nyenswahwlah@gmail.com","2023-05-03"]
[null,"SCH Programme Manager","Anthony K. Bettee",null,886539548,null,"abettee@gmail.com","2023-05-03"]
[]
[]
[]
[]
[null,"The WHO recommends that all serious adverse events suspected to be associated with use of PC medicines should be reported in accordance with national Pharmacovigilance guidelines. In the absence of a national Pharmacovigilance system, contact the WHO Neglected Tropical Disease department for guidance."]
[null,"The WHO is committed to facilitate PC medicines donation with a free-of-charge supply of a) albendazole, mebendazole and praziquantel to the MoH’s national warehouse; and b) diethylcarbamazine citrate to the entry port/airport of recipient countries."]
[null,"The institution submitting the present request is responsible for a) arranging the offloading of the medicines from the truck and storing it in the national warehouse and subsequent shipment to the final distribution centres; b) for registering the donated medicine, if required, by the relevant national regulatory authorities; and c) for informing about any changes of their PC campaigns (e.g. postpone of the planned MDA date, replacement of NTD coordinator, etc.)."]
[null,null,"I have read and accept WHO Data Sharing Policy"]
[null,null,"I confirm that all information provided in this form is complete and correct"]
[null,"Name and signature of NTD coordinator \nor Ministry of Health representative"]
[null,"Date:"]
[]
[null,"Please complete information on shipment and consignee in the worksheet SHIPMENT. Any additional details related to this Request should be provided in the \"Additional information\" box in the worksheet SHIPMENT."]
[null,"Please send the national request (signed and in electronic format) to the concerned WR with copy to:"]
[null,"WHO headquarters","PC_JointForms@who.int"]
[null,"WHO Regional Office","Regional Advisor for NTD"]
[null,"Mectizan donation program","Dr Yao Sodahlon, email: ysodahlon@taskforce.org"]
[]
[null,"Please note that your request will be reviewed by an independent panel before approval. The information in this form, joint reporting form and PC epidemiological data reporting form are essential for WHO to ensure efficient usage of medicines. As part of its ongoing monitoring and evaluation activities, and to meet its contractual obligations to donors and other partners, WHO and its appointed agents reserve the right to periodically inspect stocks of the medicines at country level."]

{"sheet":"SHIPMENT","index":8,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[34,1,34,7],[36,1,36,7],[0,1,0,7],[1,1,1,7],[2,1,2,5],[17,5,17,7],[18,5,18,7],[19,2,19,4],[19,5,19,7],[21,2,21,4],[3,2,3,5],[4,1,4,7],[22,2,22,4],[22,5,22,7],[15,2,15,4],[20,5,20,7],[15,5,15,7],[20,2,20,4],[18,2,18,4],[16,2,16,4],[47,1,56,7],[45,1,45,7],[37,1,37,6],[38,1,38,5],[40,1,40,7],[41,1,41,6],[39,1,39,6],[42,1,42,6],[43,1,43,7],[25,2,25,4],[25,5,25,7],[24,1,24,7],[6,1,6,7],[7,2,7,4],[7,5,7,7],[8,2,8,4],[8,5,8,7],[9,2,9,4],[9,5,9,7],[10,2,10,4],[10,5,10,7],[11,2,11,4],[11,5,11,7],[12,2,12,4],[12,5,12,7],[13,2,13,4],[13,5,13,7],[14,2,14,4],[14,5,14,7],[23,2,23,4],[23,5,23,7],[21,5,21,7],[16,5,16,7],[17,2,17,4],[26,2,26,4],[26,5,26,7],[27,2,27,4],[27,5,27,7],[28,2,28,4],[28,5,28,7],[32,2,32,4],[32,5,32,7],[29,2,29,4],[29,5,29,7],[30,2,30,4],[30,5,30,7],[31,2,31,4],[31,5,31,7]]}
[]
[null,"Joint request for selected PC medicines v.4.1"]
[]
[null,"Country",{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Liberia"},null,null,null,"Year",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2024}]
[]
[null,"Information on shipment and consignee "]
[]
[null,null,"Consignee",null,null,"Delivery point / Final recipient\nif different from the consignee"]
[null,"Name","Clement, Dr Lugala Peter Lasuba",null,null,"Karsor K.Kollie"]
[null,"Department/Unit","Country Representative Office",null,null,"Health Services/ Neglected Tropical Diseases"]
[null,"Organization","World Health Organization",null,null,"Ministry of Health"]
[null,"Phone","+231 886516803",null,null,"+231777532903/231886532903"]
[null,"Fax"]
[null,"E-mail","wholiberia@who.int",null,null,"karsorkollie@gmail.com"]
[null,"Mailing address","1st Street, Sinkor AF 133354 UN House, Pan African Plaza, 1000 Monrovia 10 Liberia",null,null,"Congo Town, Monrovia, Liberia"]
[]
[null,null,"Consignee",null,null,"Delivery point / Final recipient\nif different from the consignee"]
[null,"Name","Clement, Dr Lugala Peter Lasuba",null,null,"Alex Korkolea"]
[null,"Department/Unit","Country Representative Office",null,null,"Supply Chain Unit/ Central Medicine Store"]
[null,"Organization","World Health Organization",null,null,"Ministry of Health"]
[null,"Phone","+231 886516803",null,null,"+231776150865/231886430576"]
[null,"Fax"]
[null,"E-mail","wholiberia@who.int",null,null,"alexkorkolea@gmail.com"]
[null,"Mailing address","1st Street, Sinkor AF 133354 UN House, Pan African Plaza, 1000 Monrovia 10 Liberia",null,null,"Caldwell, Bushrod Island, Monrovia, Liberia"]
[]
[null,null,"Consignee",null,null,"Delivery point / Final recipient\nif different from the consignee"]
[null,"Name","Clement, Dr Lugala Peter Lasuba"]
[null,"Department/Unit","Country Representative Office"]
[null,"Organization","World Health Organization"]
[null,"Phone","+231 886516803"]
[null,"Fax"]
[null,"E-mail","wholiberia@who.int"]
[null,"Mailing address","1st Street, Sinkor AF 133354 UN House, Pan African Plaza, 1000 Monrovia 10 Liberia"]
[]
[]
[null,"Information on import requirements"]
[]
[null,"Is the Import Permit required?",null,null,null,null,null,"No"]
[null,"How long does it take to obtain the Import Permit?"]
[null,"Do you require any documents to be submitted together with the Import Permit application?",null,null,null,null,null,"No"]
[]
[null,"Does the consignee have to get customs clearance before the shipment can proceed?",null,null,null,null,null,"No"]
[null,"Is there any additional information may be helpful in ensuring timely clearance and delivery of medicines to your country? ",null,null,null,null,null,"No"]
[]
[]
[null,"Additional information"]

{"sheet":"DATA_POLICY","index":9,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":true,"merged":[[55,1,55,2],[0,1,0,5],[1,1,1,7],[3,3,3,5],[6,1,6,7],[8,1,12,7],[13,1,16,7],[17,1,21,7],[22,1,25,7],[26,2,36,7],[38,1,45,7]]}
[]
[null,"Joint request for selected PC medicines v.4.1"]
[]
[null,"Country",null,{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Liberia"},null,null,"Year",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2024}]
[]
[]
[null,"WHO Data Sharing Policy statement"]
[]
[null,"Data are the basis for all sound public health actions and the benefits of data sharing are widely recognized, including scientific and public health benefits. Whenever possible, WHO wishes to promote the sharing of health data, including but not restricted to surveillance and epidemiological data.  "]
[]
[]
[]
[]
[null,{"$f":"\"In this connection, and without prejudice to information sharing and publication pursuant to legally binding instruments, by providing data to WHO, the Ministry of Health of \" & D4 & \":\"","v":"In this connection, and without prejudice to information sharing and publication pursuant to legally binding instruments, by providing data to WHO, the Ministry of Health of Liberia:"}]
[]
[]
[]
[null,"Confirms that all data to be supplied to WHO hereunder have been collected in accordance with applicable national laws, including data protection laws aimed at protecting the confidentiality of identifiable persons;"]
[]
[]
[]
[]
[null,{"$f":"\"Agrees that WHO shall be entitled, subject always to measures to ensure the ethical and secure use of the data, and subject always to an appropriate acknowledgement of \"&D4&\":\"","v":"Agrees that WHO shall be entitled, subject always to measures to ensure the ethical and secure use of the data, and subject always to an appropriate acknowledgement of Liberia:"}]
[]
[]
[]
[null,null,"to publish the data, stripped of any personal identifiers and make the Data available to any interested party on request (to the extent they have not, or not yet, been published by WHO) on terms that allow non-commercial, not-for-profit use of the Data for public health purposes (provided always that publication of the Data shall remain under the control of WHO); \nto use, compile, aggregate, evaluate and analyse the Data and publish and disseminate the results thereof in conjunction with WHO’s work and in accordance with the Organization’s policies and practices."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Except where data sharing and publication is required under legally binding instruments (IHR, WHO Nomenclature Regulations 1967, etc.), the Ministry of Health of \", D4,\" may in respect of certain data opt out of (any part of) the above,\" & \" by notifying WHO thereof in writing at the following address, provided that any such notification shall clearly identify the data in question and clearly indicate the scope of the opt-out (in reference to the  above), \" & \"and provided that specific reasons shall be given for the opt out.\")","v":"Except where data sharing and publication is required under legally binding instruments (IHR, WHO Nomenclature Regulations 1967, etc.), the Ministry of Health of Liberia may in respect of certain data opt out of (any part of) the above, by notifying WHO thereof in writing at the following address, provided that any such notification shall clearly identify the data in question and clearly indicate the scope of the opt-out (in reference to the  above), and provided that specific reasons shall be given for the opt out."}]