Spreadsheet: 70087d1270752576-adding-data-from-multiple-sheets-to-a-single-sheet-town-
Sheet: Sheet2

Name of Town | Name of UC/Cantonement | Population & Percentage |  |  | EPI DATA |  | MONTHLY COVERAGE OF 0-11 MONTH CHILDREN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COVERAGE of 12-23 MONTH CHILDREN |  |  |  |  | COVERAGE OF PREGNANAT LADIES
 |  | Total Population 2010 | Yearly Target Polulation under 1 year @ 3.533 % | Monthly Target Polulation under 1 year @ 3.533 % | No. of EPI centres (Pvt + Govt) | No. of Vaccinators Working | BCG |  |  | COVERAGE OF PENTA |  |  |  |  |  |  |  |  |  | COVERAGE OF MEASLES 1 |  |  |  | COVERAGE OF MEASLES 2
 |  |  |  |  |  |  |  |  |  | PENTA-1 |  |  | PENTA-2 |  |  | PENTA-3 |  |  | DOR |  |  |  |  |  |  |  |  |  | TARGET |  | T.T.  I |  |  | T.T.  2 |  |  | D.OUT
 |  |  |  |  |  |  | BCG | Yearly Cov % | Monthly [NAME] | PENTA-1 | Yearly Cov % | Monthly [NAME] | PENTA-2 | Yearly Cov % | Monthly [NAME] | PENTA-3 | Yearly Cov % | Monthly [NAME] | DOR. Penta 1-Penta 3 | Measles 1 | Yearly Cov % | Monthly [NAME] | DOR (BCG to Measles 1) | 12-23 Month Target @ 3.4% (Yearly) | 12-23 Month Target @ 3.4% (Monthly) | [NAME] | Yearly Cov % | Monthly [NAME] | [NAME]. Ladies @ 4% (Yearly) | [NAME]. Ladies @ 4% (Monthly) | T.T.  I | Yearly Cov % | Monthly [NAME] | T.T.II | Yearly Cov % | Monthly [NAME] | DOR (TT1  to TT2)
ABC | [NAME] | 57456 | 2029.92048 | 169.16004 | 3 | 2
 | Daryabad | 74211 | 2621.87463 | 218.4895525 | 1 | 1
 | Nayabad | 56797 | 2006.63801 | 167.2198341666667 | 0 | 0
 | [NAME] | 73474 | 2595.83642 | 216.3197016666667 | 2 | 0
 | Bughdadi | 71332 | 2520.15956 | 210.0132966666667 | 3 | 6
 |  |  |  |  |  |  | 106 | 5.221879430469119 | 62.66255316562942 | 124 | 6.108613673378969 | 73.30336408054762 | 127 | 6.256402713863944 | 75.07683256636733 | 121 | 5.960824632893994 | 71.52989559472792 | 2.419354838709677 | 59 | 2.906517796204509 | 34.87821355445411 | 44.33962264150944 | 1953.504 | 162.792 | 48 | 2.457123200157256 | 29.48547840188707 | 2298.24 | 191.52 | 63 | 2.741228070175439 | 32.89473684210527 | 53 | 2.306112503480925 | 27.67335004177109 | 15.87301587301587
 |  |  |  |  |  |  | 54 | 2.660202728729551 | 31.92243274475461 | 119 | 5.862298605904011 | 70.34758327084812 | 113 | 5.566720524934061 | 66.80064629920872 | 114 | 5.615983538429052 | 67.39180246114861 | 4.201680672268908 | 118 | 5.813035592409019 | 69.75642710890823 | -118.5185185185185 | 1953.504 | 162.792 | 79 | 4.044015266925483 | 48.5281832031058 | 2298.24 | 191.52 | 34 | 1.479392926761348 | 17.75271512113618 | 36 | 1.566416040100251 | 18.79699248120301 | -5.88235294117647
 | [NAME] | 73035 | 2580.32655 | 215.0272125 | 1 | 2 | 160 | 7.882082159198669 | 94.58498591038403 | 243 | 11.97091227928298 | 143.6509473513958 | 240 | 11.823123238798 | 141.8774788655761 | 235 | 11.57680817132305 | 138.9216980558765 | 6.621035510978585 | 177 | 8.719553388613528 | 104.6346406633623 | -74.17889587700907 | 3907.008 | 325.584 | 127 | 6.50113846708274 | 78.01366160499288 | 4596.48 | 383.04 | 97 | 4.220620996936787 | 50.64745196324144 | 89 | 3.872528543581176 | 46.47034252297411 | 9.990662931839402
 |  |  |  |  |  |  | 34 | 1.296782066196659 | 15.56138479435991 | 52 | 1.983313748300772 | 23.79976497960927 | 55 | 2.097735695318125 | 25.17282834381749 | 48 | 1.830751152277636 | 21.96901382733163 | 7.692307692307693 | 16 | 0.6102503840925453 | 7.323004609110543 | 52.94117647058824 | 2523.174 | 210.2645 | 16 | 0.6341219432349889 | 7.609463318819867 | 2968.44 | 247.37 | 3 | 0.1010631847030764 | 1.212758216436916 | 0 | 0 | 0 | 100
 |  |  |  |  |  |  | 29 | 1.106078821167738 | 13.27294585401286 | 37 | 1.411204013214011 | 16.93444815856813 | 48 | 1.830751152277636 | 21.96901382733163 | 40 | 1.525625960231363 | 18.30751152277636 | -8.108108108108109 | 38 | 1.449344662219795 | 17.39213594663754 | -31.03448275862069 | 2523.174 | 210.2645 | 23 | 0.9115502934002966 | 10.93860352080356 | 2968.44 | 247.37 | 1 | 0.03368772823435879 | 0.4042527388123054 | 3 | 0.1010631847030764 | 1.212758216436916 | -200
 | [NAME] | 56177 | 1984.73341 | 165.3944508333333 | 1 | 2 | 63 | 2.402860887364397 | 28.83433064837277 | 89 | 3.394517761514783 | 40.7342131381774 | 103 | 3.92848684759576 | 47.14184217114912 | 88 | 3.356377112508999 | 40.27652535010799 | -0.4158004158004163 | 54 | 2.05959504631234 | 24.71514055574809 | 21.90669371196755 | 5046.348 | 420.529 | 39 | 1.545672236635286 | 18.54806683962343 | 5936.88 | 494.74 | 4 | 0.1347509129374352 | 1.617010955249222 | 3 | 0.1010631847030764 | 1.212758216436916 | -100
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 1931.098 | 160.9248333333333 | 0 | 0 | 0 | 2271.88 | 189.3233333333334 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 1931.098 | 160.9248333333333 | 0 | 0 | 0 | 2271.88 | 189.3233333333334 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
 | [NAME] | 75799 | 2677.97867 | 223.1648891666666 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 3862.196 | 321.8496666666667 | 0 | 0 | 0 | 4543.76 | 378.6466666666667 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  | 587 | 22.61313522983856 | 271.3576227580627 | 331 | 12.75118869007932 | 153.0142642809519 | 292 | 11.24878277191288 | 134.9853932629545 | 245 | 9.438191024378954 | 113.2582922925475 | 25.98187311178248 | 212 | 8.166924478238116 | 98.00309373885739 | 63.88415672913118 | 2498.116 | 208.1763333333333 | 257 | 10.28775285054817 | 123.4530342065781 | 2938.96 | 244.9133333333333 | 409 | 13.91648746495359 | 166.9978495794431 | 429 | 14.59700029942565 | 175.1640035931078 | -4.88997555012225
 |  |  |  |  |  |  | 253 | 9.746376853746431 | 116.9565222449572 | 239 | 9.207051652353348 | 110.4846198282402 | 215 | 8.28249416425092 | 99.38992997101104 | 238 | 9.168528423682414 | 110.022341084189 | 0.4184100418410042 | 120 | 4.622787440512141 | 55.47344928614569 | 52.56916996047431 | 2498.116 | 208.1763333333333 | 36 | 1.441086002411417 | 17.29303202893701 | 2938.96 | 244.9133333333333 | 304 | 10.34379508397528 | 124.1255410077034 | 341 | 11.60274382774859 | 139.2329259329831 | -12.17105263157895
 | Singho Lane | 62381 | 2203.92073 | 183.6600608333333 | 0 | 0 | 840 | 32.35951208358499 | 388.3141450030199 | 570 | 21.95824034243267 | 263.4988841091921 | 507 | 19.5312769361638 | 234.3753232339656 | 483 | 18.60671944806137 | 223.2806333767364 | 26.40028315362348 | 332 | 12.78971191875026 | 153.4765430250031 | 116.4533266896055 | 4996.232 | 416.3526666666667 | 293 | 11.72883885295959 | 140.7460662355151 | 5877.92 | 489.8266666666667 | 713 | 24.26028254892887 | 291.1233905871465 | 770 | 26.19974412717423 | 314.3969295260908 | -17.0610281817012
 |  |  |  |  |  |  | 294 | 11.66592800973284 | 139.9911361167941 | 440 | 17.45921198735528 | 209.5105438482633 | 411 | 16.30849119727959 | 195.7018943673551 | 409 | 16.22913114279161 | 194.7495737134993 | 7.045454545454545 | 284 | 11.26912773729295 | 135.2295328475154 | 3.401360544217687 | 2425.288 | 202.1073333333333 | 29 | 1.19573427980512 | 14.34881135766144 | 2853.28 | 237.7733333333333 | 413 | 14.4745696181237 | 173.6948354174844 | 227 | 7.955756182358548 | 95.46907418830259 | 45.03631961259079
 |  |  |  |  |  |  | 210 | 8.332805721237746 | 99.99366865485295 | 458 | 18.17345247774708 | 218.081429732965 | 421 | 16.70529146971948 | 200.4634976366338 | 348 | 13.80864948090826 | 165.7037937708992 | 24.0174672489083 | 315 | 12.49920858185662 | 149.9905029822794 | -50 | 2425.288 | 202.1073333333333 | 221 | 9.112319856445914 | 109.347838277351 | 2853.28 | 237.7733333333333 | 258 | 9.042225088319407 | 108.5067010598329 | 185 | 6.483766051701901 | 77.80519262042282 | 28.29457364341085
 | Chakiwara | 83343 | 2944.50819 | 245.3756825 | 1 | 2 | 504 | 19.99873373097059 | 239.9848047716471 | 898 | 35.63266446510236 | 427.5919735812283 | 832 | 33.01378266699906 | 396.1653920039888 | 757 | 30.03778062369987 | 360.4533674843985 | 31.06292179436284 | 599 | 23.76833631914957 | 285.2200358297948 | -46.59863945578231 | 4850.576 | 404.2146666666667 | 250 | 10.30805413625103 | 123.6966496350124 | 5706.56 | 475.5466666666667 | 671 | 23.51679470644311 | 282.2015364773173 | 412 | 14.43952223406045 | 173.2742668087254 | 73.33089325600164
 |  |  |  |  |  |  | 44 | 1.705210528489117 | 20.46252634186941 | 47 | 1.821474882704284 | 21.85769859245141 | 50 | 1.937739236919451 | 23.25287084303342 | 48 | 1.860229667442673 | 22.32275600931208 | -2.127659574468085 | 60 | 2.325287084303342 | 27.9034450116401 | -36.36363636363637 | 2483.19 | 206.9325 | 0 | 0 | 0 | 2921.4 | 243.45 | 52 | 1.779968508249469 | 21.35962209899363 | 43 | 1.47189703566783 | 17.66276442801396 | 17.30769230769231
 |  |  |  |  |  |  | 39 | 1.511436604797172 | 18.13723925756606 | 52 | 2.015248806396229 | 24.18298567675475 | 48 | 1.860229667442673 | 22.32275600931208 | 50 | 1.937739236919451 | 23.25287084303342 | 3.846153846153846 | 38 | 1.472681820058783 | 17.6721818407054 | 2.564102564102564 | 2483.19 | 206.9325 | 20 | 0.8054156145925201 | 9.664987375110242 | 2921.4 | 243.45 | 53 | 1.814198671869651 | 21.77038406243582 | 52 | 1.779968508249469 | 21.35962209899363 | 1.886792452830189
 | Allama Iqbal Colony | 81051 | 2863.53183 | 238.6276525 | 2 | 6 | 83 | 3.216647133286289 | 38.59976559943547 | 99 | 3.836723689100514 | 46.04068426920616 | 98 | 3.797968904362125 | 45.57562685234549 | 98 | 3.797968904362125 | 45.57562685234549 | 1.718494271685761 | 98 | 3.797968904362125 | 45.57562685234549 | -33.7995337995338 | 4966.38 | 413.865 | 20 | 0.8054156145925201 | 9.664987375110242 | 5842.8 | 486.9 | 105 | 3.594167180119121 | 43.13000616142945 | 95 | 3.2518655439173 | 39.0223865270076 | 19.1944847605225
 |  |  |  |  |  |  | 111 | 5.592690657633461 | 67.11228789160153 | 158 | 7.960766882036818 | 95.52920258444182 | 134 | 6.751536469575529 | 81.01843763490636 | 167 | 8.414228286709802 | 100.9707394405176 | -5.69620253164557 | 132 | 6.650767268537089 | 79.80920722244507 | -18.91891891891892 | 1910.018 | 159.1681666666667 | 66 | 3.455464817609049 | 41.46557781130858 | 2247.08 | 187.2566666666667 | 13 | 0.578528579311818 | 6.942342951741816 | 12 | 0.5340263809032166 | 6.4083165708386 | 7.692307692307693
 |  |  |  |  |  |  | 117 | 5.894998260748783 | 70.7399791289854 | 160 | 8.061536083075259 | 96.73843299690311 | 139 | 7.00345947217163 | 84.04151366605957 | 124 | 6.247690464383326 | 74.9722855725999 | 22.5 | 92 | 4.635383247768273 | 55.62459897321929 | 21.36752136752137 | 1910.018 | 159.1681666666667 | 53 | 2.774842959595145 | 33.29811551514174 | 2247.08 | 187.2566666666667 | 20 | 0.8900439681720277 | 10.68052761806433 | 15 | 0.6675329761290207 | 8.010395713548249 | 25
Total ABC |  | 765056 | 27029.42848 | 2252.452373333333 | 17 | 25 | 228 | 11.48768891838224 | 137.8522670205869 | 318 | 16.02230296511208 | 192.2676355813449 | 273 | 13.75499594174716 | 165.0599513009659 | 291 | 14.66191875109313 | 175.9430250131175 | 16.80379746835443 | 224 | 11.28615051630536 | 135.4338061956643 | 2.448602448602447 | 3820.036 | 318.3363333333334 | 119 | 6.230307777204194 | 74.76369332645032 | 4494.16 | 374.5133333333333 | 33 | 1.468572547483846 | 17.62287056980615 | 27 | 1.201559357032237 | 14.41871228438685 | 32.69230769230769
 |  |  |  |  |  |  | 222 | 8.289834511639334 | 99.47801413967201 | 231 | 8.625908883732821 | 103.5109066047938 | 209 | 7.804393751948743 | 93.6527250233849 | 173 | 6.460096263574797 | 77.52115516289756 | 25.10822510822511 | 40 | 1.493663875971051 | 17.92396651165262 | 81.98198198198197 | 2577.166 | 214.7638333333333 | 28 | 1.086464744607061 | 13.03757693528473 | 3031.96 | 252.6633333333333 | 153 | 5.046240715576722 | 60.55488858692068 | 64 | 2.110845789522289 | 25.33014947426747 | 58.16993464052288
 |  |  |  |  |  |  | 191 | 7.13224500776177 | 85.58694009314124 | 190 | 7.094903410862494 | 85.13884093034993 | 184 | 6.870853829466836 | 82.45024595360204 | 177 | 6.609462651171902 | 79.31355181406282 | 6.842105263157896 | 143 | 5.339848356596509 | 64.07818027915809 | 25.13089005235602 | 2577.166 | 214.7638333333333 | 130 | 5.044300599961352 | 60.53160719953623 | 3031.96 | 252.6633333333333 | 156 | 5.14518661196058 | 61.74223934352696 | 129 | 4.254673544505864 | 51.05608253407037 | 17.30769230769231
 |  |  |  |  |  |  | 413 | 15.42207951940111 | 185.0649542328132 | 421 | 15.72081229459532 | 188.6497475351438 | 393 | 14.67524758141558 | 176.1029709769869 | 350 | 13.0695589147467 | 156.8347069769604 | 31.950330371383 | 183 | 6.83351223256756 | 82.00214679081071 | 107.112872034338 | 5154.332 | 429.5276666666667 | 158 | 6.130765344568413 | 73.56918413482096 | 6063.92 | 505.3266666666667 | 309 | 10.1914273275373 | 122.2971279304476 | 193 | 6.365519334028154 | 76.38623200833784 | 75.47762694821519
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 2120.954 | 176.7461666666667 | 0 | 0 | 0 | 2495.24 | 207.9366666666666 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 2120.954 | 176.7461666666667 | 0 | 0 | 0 | 2495.24 | 207.9366666666666 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 4241.908 | 353.4923333333334 | 0 | 0 | 0 | 4990.48 | 415.8733333333333 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  | 65 | 2.2074993786993 | 26.4899925443916 | 65 | 2.2074993786993 | 26.4899925443916 | 55 | 1.867884089668638 | 22.41460907602366 | 44 | 1.494307271734911 | 17.93168726081893 | 32.30769230769231 | 61 | 2.071653263087035 | 24.85983915704442 | 6.153846153846154 | 2833.662 | 236.1385 | 15 | 0.5293503600641148 | 6.352204320769378 | 3333.72 | 277.81 | 29 | 0.8698990917053623 | 10.43878910046435 | 18 | 0.5399373672653972 | 6.479248407184766 | 37.93103448275862
 |  |  |  |  |  |  | 65 | 2.2074993786993 | 26.4899925443916 | 65 | 2.2074993786993 | 26.4899925443916 | 55 | 1.867884089668638 | 22.41460907602366 | 44 | 1.494307271734911 | 17.93168726081893 | 32.30769230769231 | 61 | 2.071653263087035 | 24.85983915704442 | 6.153846153846154 | 2833.662 | 236.1385 | 15 | 0.5293503600641148 | 6.352204320769378 | 3333.72 | 277.81 | 29 | 0.8698990917053623 | 10.43878910046435 | 18 | 0.5399373672653972 | 6.479248407184766 | 37.93103448275862
 |  |  |  |  |  |  | 130 | 4.4149987573986 | 52.9799850887832 | 130 | 4.4149987573986 | 52.9799850887832 | 110 | 3.735768179337277 | 44.82921815204732 | 88 | 2.988614543469821 | 35.86337452163785 | 64.61538461538461 | 122 | 4.14330652617407 | 49.71967831408885 | 12.30769230769231 | 5667.324000000001 | 472.277 | 30 | 1.05870072012823 | 12.70440864153876 | 6667.44 | 555.62 | 58 | 1.739798183410725 | 20.87757820092869 | 36 | 1.079874734530794 | 12.95849681436953 | 75.86206896551724
 |  |  |  |  |  |  | 210 | 7.333601037708737 | 88.00321245250483 | 300 | 10.47657291101248 | 125.7188749321498 | 265 | 9.254306071394359 | 111.0516728567323 | 271 | 9.463837529614608 | 113.5660503553753 | 9.666666666666666 | 281 | 9.813056626648358 | 117.7566795197803 | -33.80952380952381 | 2755.734 | 229.6445 | 36 | 1.30636701510378 | 15.67640418124536 | 3242.04 | 270.17 | 162 | 4.996853832771959 | 59.96224599326349 | 96 | 2.961098567568568 | 35.53318281082281 | 40.74074074074074
 |  |  |  |  |  |  | 216 | 7.543132495928987 | 90.51758995114783 | 238 | 8.311414509403235 | 99.73697411283882 | 243 | 8.48602405792011 | 101.8322886950413 | 128 | 4.470004442031992 | 53.6400533043839 | 46.21848739495798 | 111 | 3.876331977074618 | 46.51598372489541 | 48.61111111111111 | 2755.734 | 229.6445 | 118 | 4.281980771729057 | 51.38376926074867 | 3242.04 | 270.17 | 102 | 3.146167228041604 | 37.75400673649924 | 102 | 3.146167228041604 | 37.75400673649924 | 0
 |  |  |  |  |  |  | 426 | 14.87673353363772 | 178.5208024036527 | 538 | 18.78798742041572 | 225.4558490449886 | 508 | 17.74033012931447 | 212.8839615517736 | 399 | 13.9338419716466 | 167.2061036597592 | 55.88515406162465 | 392 | 13.68938860372297 | 164.2726632446757 | 14.8015873015873 | 5511.468000000001 | 459.289 | 154 | 5.588347786832836 | 67.06017344199402 | 6484.08 | 540.34 | 264 | 8.143021060813563 | 97.71625272976274 | 198 | 6.107265795610171 | 73.28718954732204 | 40.74074074074074