{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["START","FPC","TB Prevelance"],"not_rendered":{"charts":2,"external_links":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"START","index":0,"n_rows":30,"n_cols":16,"rows_kept":30,"merged":[[2,0,3,14],[4,0,4,3],[4,5,4,15],[5,0,5,3],[5,5,5,15],[6,0,6,3],[6,5,6,15],[7,0,7,3],[7,5,7,15],[8,0,8,3],[8,5,8,15],[9,0,9,3],[9,5,9,15],[12,0,12,2],[13,0,13,2],[14,0,14,1],[14,3,14,4],[15,0,15,1],[15,3,15,4],[16,0,16,1],[16,3,16,4],[16,7,20,15],[24,14,24,15],[28,12,28,14]],"flags":["formulas_cached_only"]}
["Sample Size Calculator"]
[]
["Instructions:  Complete the fields in green with the necessary information.  Then read through the steps below to attain your final sample size."]
[]
["Level of Confidence Measure",{"$nulls":3},1.96,"Describes the level of uncertainty in the sample mean or prevalence as an estimate of the population mean or prevalence.  Recommended value: 1.96 (for 95% confidence level)"]
["Margin of Error (MOE)",{"$nulls":3},0.05,"The expected half-width of the confidence interval.  The smaller the margin of error, the larger the sample size needed.  Recommended value: 0.05 (for small baseline levels, e.g. <.10, a smaller MOE of 0.02 or 0.01 is appropriate)\n"]
["Baseline levels of the indicators",{"$nulls":3},0.5,"The estimated prevalence of the risk factors within the target population.  Values closest to 50% are the most conservative.  Recommended value: 0.5 if no previous data on population, else value closest to 0.5 from previous data"]
["Design effect (Deff)",{"$nulls":3},1.5,"Describes the loss of sampling efficiency due to using a complex sample design.  A value of 1.0 is appropriate for simple random samples.Recommended value: 1.5 (for most STEPS surveys)"]
["Expected Response Rate",{"$nulls":3},0.8,"The anticipated response rate. Recommended value: enter response rate from previous national/subnational household surveys, else use 0.8 as an estimate"]
["Number of age/sex Estimates",{"$nulls":3},8,"The number of age-sex groups for which estimates will be calculated.  If age-sex estimates are desired for specific states/regions/island, multiply the number of age-sex groups by the number of states/regions/islands to attain the total number of estimates desired."]
[]
[]
["Population Size",null,null,"FPC Check:",null,null,"Step 1:","Initial calculation:"]
["State",null,null,"initial n ≥10% ?",{"$nulls":3},"n=",3.8415999999999997,"* (",0.5,"* (1-",0.5,"))","=",600000]
["Kassala",null,0.002,"yes",{"$nulls":6},0.05,"*",0.05]
["Al- Gedarif",null,0.001,"yes"]
["Red Sea",null,0.005,"yes",null,null,"Step 2: ","Complete the population table to the left to check if the Finite Population Correction (FPC) can be applied.  If the initial n calculated above is 10% or more of the size of the majority of the age groups, then the FPC can be applied.  If the FPC can be applied, continue calculating your sample size on the FPC worksheet.  If the FPC cannot be applied continue to Step 3 below."]
["60-69",null,4,"yes"]
["State","Population"]
["Kassala",{"v":2519071,"d":"2,519,071"},5,"yes"]
["Gedarif",{"v":2208385,"d":"2,208,385"},6,"yes"]
["Red Sea",{"v":1482053,"d":"1,482,053"},7,"yes"]
[null,null,8,"yes",null,null,"Step 3:","Multiply by the design effect and number of age-sex estimates:"]
["Total",{"v":6209509,"d":"6,209,509"}]
[{"$nulls":7},"n=",600000,"*",1.5,"*",8,"=",7200000]
[]
[{"$nulls":6},"Step 4:","Adjust for expected non-response to get your final sample size:"]
[]
[{"$nulls":7},"n=",7200000,"/",0.8,"=",9000000]
[{"$nulls":11},"FINAL SAMPLE SIZE"]

{"sheet":"FPC","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"merged":[[0,0,3,4],[5,0,5,2],[5,3,6,3],[5,4,6,4],[6,0,6,2],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[13,10,13,13],[18,0,18,3]],"flags":["formulas_cached_only"]}
["Instructions: This worksheet is only to be used if the Finite Population Correction is applicable (i.e. the target population is very small).  Complete the population table in the lower left corner of the START worksheet to confirm if the FPC is applicable for your target population."]
[]
[]
[{"$nulls":6},"Step 2:","Apply FPC to sample size for each estimate and sum these adjusted"]
[{"$nulls":7},"n's together (see table to the left)."]
["Population Size",null,null,"Intitial n       (calculated on START worksheet)","n after FPC applied"]
["State",{"$nulls":5},"Step 3:","Now, multiply the adjusted n values by the design effect:"]
["Kassala",null,0.002,600000,{"v":0.0019999999933333333,"d":"0.00"}]
["Al- Gedarif",null,0.001,600000,{"v":0.0009999999983333334,"d":"0.00"},null,null,"n=",{"v":0.00799999995,"d":"0.01"},"*",1.5,"=",0.011999999925]
["Red Sea",null,0.005,600000,{"v":0.0049999999583333335,"d":"0.00"}]
[{"$nulls":6},"Step 4:","Finally, adjust for expected non-response:"]
[]
[{"$nulls":7},"n=",{"v":0.011999999925,"d":"0.01"},"/",0.8,"=",0.014999999906249999]
[{"$nulls":10},"FINAL SAMPLE SIZE"]
[]
[]
[]
[]
["Sum of n for all estimates:",{"$nulls":3},{"v":0.00799999995,"d":"0.01"}]

{"sheet":"TB Prevelance","index":2,"n_rows":54,"n_cols":5,"rows_kept":54,"flags":["formulas_cached_only"]}
[]
["Population","Population"]
["Census (C)","Projection (P)"]
["2008-04-22","2018-07-01"]
[{"v":5274321,"d":"5,274,321"},{"v":7993900,"d":"7,993,900"}]
[{"v":3575280,"d":"3,575,280"},{"v":5096900,"d":"5,096,900"}]
[{"v":2879810,"d":"2,879,810"},{"v":3765800,"d":"3,765,800"}]
[{"v":1789806,"d":"1,789,806"},{"v":2519100,"d":"2,519,100"}]
[{"v":1730588,"d":"1,730,588"},{"v":2493900,"d":"2,493,900"}]
[{"v":2113626,"d":"2,113,626"},{"v":2305000,"d":"2,305,000"}]
[{"v":2039495,"d":"2,039,495"},{"v":2216200,"d":"2,216,200"}]
[{"v":1348378,"d":"1,348,378"},{"v":2208400,"d":"2,208,400"}]
[{"v":1285058,"d":"1,285,058"},{"v":1918700,"d":"1,918,700"}]
[{"v":1419983,"d":"1,419,983"},{"v":1764800,"d":"1,764,800"}]
[{"v":1213784,"d":"1,213,784"},{"v":1587200,"d":"1,587,200"}]
[{"v":1120441,"d":"1,120,441"},{"v":1511400,"d":"1,511,400"}]
[{"v":1396110,"d":"1,396,110"},{"v":1482100,"d":"1,482,100"}]
[{"v":867918,"d":"867,918"},{"v":1300700,"d":"1,300,700"}]
[{"v":832112,"d":"832,112"},{"v":1108400,"d":"1,108,400"}]
[{"v":754710,"d":"754,710"},{"v":1024500,"d":"1,024,500"}]
[{"v":699065,"d":"699,065"},{"v":936300,"d":"936,300"}]
[{"v":553515,"d":"553,515"},{"v":751400,"d":"751,400"}]
[{"v":30894000,"d":"30,894,000"},{"v":41984500,"d":"41,984,500"}]
{"$rows_empty":11}
[null,"Table-2: Annual number of infections"]
[null,null,"Year","Tuberculosis","CHANGE, %"]
[null,null,2001,{"v":23997,"d":"23,997"}]
[null,null,2002,{"v":24554,"d":"24,554"},{"v":0.0232,"d":"2.32%"}]
[null,null,2003,{"v":25105,"d":"25,105"},{"v":0.0224,"d":"2.24%"}]
[null,null,2004,{"v":26567,"d":"26,567"},{"v":0.0582,"d":"5.82%"}]
[null,null,2005,{"v":27562,"d":"27,562"},{"v":0.0375,"d":"3.75%"}]
[null,null,2006,{"v":28937,"d":"28,937"},{"v":0.0499,"d":"4.99%"}]
[null,null,2007,{"v":29270,"d":"29,270"},{"v":0.0115,"d":"1.15%"}]
[null,null,2008,{"v":24281,"d":"24,281"},{"v":-0.1704,"d":"-17.04%"}]
[null,null,2009,{"v":26001,"d":"26,001"},{"v":0.0708,"d":"7.08%"}]
[null,null,2010,{"v":26131,"d":"26,131"},{"v":0.005,"d":"0.50%"}]
[null,null,2011,{"v":19348,"d":"19,348"},{"v":-0.2596,"d":"-25.96%"}]
[null,null,2012,{"v":18775,"d":"18,775"},{"v":-0.0296,"d":"-2.96%"}]
[null,null,2013,{"v":22556.4090909091,"d":"22,556"},{"v":-0.10948,"d":"-10.95%"}]
[null,null,2014,{"v":22173.7027972028,"d":"22,174"},{"v":-0.124982727272727,"d":"-12.50%"}]
[null,null,2015,{"v":21790.9965034965,"d":"21,791"},{"v":-0.140485454545455,"d":"-14.05%"}]
[null,null,2016,{"v":21408.2902097902,"d":"21,408"},{"v":-0.155988181818182,"d":"-15.60%"}]
[null,null,2017,{"v":21025.5839160839,"d":"21,026"},{"v":-0.171490909090909,"d":"-17.15%"}]
[null,null,2018,{"v":20642.8776223776,"d":"20,643"},{"v":-0.186993636363636,"d":"-18.70%"}]