{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["Facility Report","HTC","PMTCT + Infants","Care & Trmnt","VMMC","PEP"],"not_rendered":{"charts":21,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Facility Report","index":0,"n_rows":196,"n_cols":9,"rows_kept":196,"merged":[[0,0,0,6],[1,0,1,6]],"flags":["formulas_cached_only"]}
["Republic of Kenya - NASCOP"]
["Comprehensive HIV/AIDS Facility Reporting Form"]
[null,"District: …..………..County:…...……….Facility: ……….….. Month: ……..……… Year:……… MFL Code:………….."]
[]
["1 HIV Counselling and Testing"]
[null,"1.1 Testing",null,null,"Value","Validation Rules","Comments"]
[null,null,"First","HV01-01"]
[null,null,"Repeat","HV01-02"]
[null,null,"Total Tested (HV01-01 plus HV01-02)","HV01-03"]
[null,null,"Individual","HV01-04",null,"</=HV01-03"]
[null,null,"Couples","HV01-05",null,"<HV01-03"]
[null,null,"Static [Health Facility]","HV01-06",null,"HV01-06+HV01-07=HV01-03"]
[null,null,"Outreach","HV01-07"]
[null,"1.2 Test Results",{"$nulls":4},"Program defines it \"receiving positive results\"."]
[null,null,"Positive (all)","HV01-08",null,"<HV01-03"]
[null,null,"Discordant Couples","HV01-09",null,"</=HV01-05"]
[null,"1.3 Receiving Results",{"$nulls":6},"."]
[null,null,"Male (<15)","HV01-10"]
[null,null,"Female (<15)","HV01-11"]
[null,null,"Male (15-24) ","HV01-12"]
[null,null,"Female (15-24)","HV01-13"]
[null,null,"Male (25+)","HV01-14"]
[null,null,"Female (25+)","HV01-15"]
[null,null,"Total received results (Sum HV01-10 to HV01-15)","HV01-16",null,"</=HV01-03"]
[]
["2 Prevention of Mother-to-Child Transmission",{"$nulls":5},"Count events/visits"]
[null,"2.1 Testing for HIV"]
[null,null,"Antenatal","HV02-01"]
[null,null,"Labour and Delivery","HV02-02"]
[null,null,"Postnatal (within 72hrs)","HV02-03"]
[null,null,"Total Women Tested (PMTCT) (Sum HV02-01 to HV02-03)","HV02-04"]
[null,"2.2 HIV Positive Results"]
[null,null,"Known positive status (at entry into ANC)","HV02-05"]
[null,null,"Antenatal","HV02-06",null,"</=HV02-01"]
[null,null,"Labour and Delivery","HV02-07",null,"</=HV02-02"]
[null,null,"Postnatal (within 72hrs)","HV02-08",null,"</=HV02-03"]
[null,null,"Total Positive (PMTCT) (Sum HV02-05 to HV02-08)","HV02-09"]
[null,null,"Total with known status (HV02-04 plus HV02-05)","HV02-10"]
[null,"2.3 Partner Involvement"]
[null,null,"Male partners tested - ANC","HV02-11",null,"<HV02-01"]
[null,null,"Discordant Couples","HV02-12",null,"</=HV02-11"]
[null,"2.4 Prophylaxis"]
[null,null,"Prophylaxis – NVP Only","HV02-13"]
[null,null,"Prophylaxis – (AZT + SdNVP)","HV02-14"]
[null,null,"Prophylaxis – Interrupted HAART","HV02-15"]
[null,null,"HAART (ART)","HV02-16"]
[null,null,"Total PMTCT prophylaxis (Sum HV02-13 to HV02-16)","HV02-17",null,"</=HV02-09"]
[null,"2.5 Assesment for ART in MCH"]
[null,null,"Assessed for eligibility at 1st ANC - WHO Staging done","HV02-18"]
[null,null,"Assessed for eligibilityat 1st ANC - CD4","HV02-19"]
[null,null,"Assesed for Eligibility in ANC (Sum HV02-18 to HV02-19)","HV02-20",null,"</=(HV02-05)+(HV02-06)","Should not double count"]
[null,null,"Started on ART during ANC","HV02-21",null,"</=HV02-20","There is no definition in the indicator manual. It is difficult to count by current register."]
[null,"2.6 Family Planning",null,null,"Value","Notes"]
[null,null,"Received Family Planning in PNC","HV02-22"]
[null,null,"PMTCT- 1st PNC attendants","HV02-23"]
[null,"2.7 Infant Testing (Initial tests only)"]
[null,null,"PCR (within 2 months)","HV02-24"]
[null,null,"PCR (from 3  to 8 months)","HV02-25"]
[null,null,"Serology antibody test (from 9 to 12 months)","HV02-26"]
[null,null,"PCR (from 9 to 12 months)","HV02-27"]
[null,null,"Total  HEI Tested by 12 months  (Sum HV02-24 to HV02-26)","HV02-28"]
[null,"2.8 Confirmed Infant Test Results"]
[null,null,"Positive – (within 2 months) – PCR","HV02-29",null,"</=HV02-24"]
[null,null,"Positive – (3 – 8 months) – PCR","HV02-30",null,"</=HV02-25"]
[null,null,"Positive – (9 – 12months) – PCR","HV02-31",null,"</=HV02-27"]
[null,null,"Total Confirmed Positive (Sum HV02-29 to HV02-31)","HV02-32",null,"</=HV02-28"]
[null,"2.9 Infant Feeding"]
[null,null,"EBF (at 6 months)","HV02-33"]
[null,null,"ERF (at 6 months)","HV02-34"]
[null,null,"MF (at 6 months)","HV02-35"]
[null,null,"Total Exposed 6 months","HV02-36"]
[null,null,"BF (12 months)","HV02-37"]
[null,null,"Not BF (12 months)","HV02-38"]
[null,null,"Not Known","HV02-39"]
[null,null,"Total Exposed 12 months (Sum HV02-37 to HV02-39)","HV02-40"]
[]
[]
["3 Care and Treatment",{"$nulls":5},"Count events/visits"]
[null,"3.1 Cotrimoxazole Prophylaxis"]
[null,null,"HIV Exposed Infant (within 2 months)","HV03-01",null,"</=HV03-02"]
[null,null,"HIV Exposed Infant (Eligible for CTX at 2 months)","HV03-02"]
[null,null,"Male (<15)","HV03-03"]
[null,null,"Female (<15)","HV03-04"]
[null,null,"Male (15+)","HV03-05"]
[null,null,"Female (15+)","HV03-06"]
[null,null,"Total on CTX (Sum HV03-03 to HV03-06)","HV03-07"]
[null,"3.2 Enrolling in Care"]
[null,null,"(<1)","HV03-08",null,null,"In dashboard, compare with HV03-02"]
[null,null,"Male (<15)","HV03-09"]
[null,null,"Female (<15)","HV03-10"]
[null,null,"Male (15+)","HV03-11"]
[null,null,"Female (15+)","HV03-12"]
[null,null,"Total Enrolled in Care (Sum HV03-09 to HV03-12)","HV03-13"]
[null,"3.3 Currently in Care",{"$nulls":4},"Include \"enrolling in care\" (\"enrolling in care\" is subset of \"currently in care\")"]
[null,null,"(<1)","HV03-14"]
[null,null,"Male (<15)","HV03-15"]
[null,null,"Female (<15)","HV03-16"]
[null,null,"Male (15+)","HV03-17"]
[null,null,"Female (15+)","HV03-18"]
[null,null,"Currently in Care (Sum HV03-15 to HV03-18)","HV03-19"]
[]
[null,"3.4 Starting ART",null,null,"Value","Notes"]
[null,null,"(<1)","HV03-20",null,"</=HV03-14"]
[null,null,"Male (<15)","HV03-21",null,"</=HV03-15"]
[null,null,"Female (<15)","HV03-22",null,"</=HV03-16"]
[null,null,"Male (15+)","HV03-23",null,"</=HV03-17"]
[null,null,"Female (15+)","HV03-24",null,"</=HV03-18"]
[null,null,"Start ART (Sum HV03-21 to HV03-24)","HV03-25",null,"</=HV03-19"]
[null,null,"Pregnant","HV03-26",null,"</=(HV03-22+HV03-24)"]
[null,null,"TB Patient ","HV03-27",null,"</=HV03-25"]
[null,"3.3 Continuation on Therapy"]
[null,"3.3.1 Revisits"]
[null,null,"(<1)","HV03-28"]
[null,null,"Male (<15)","HV03-29"]
[null,null,"Female (<15)","HV03-30"]
[null,null,"Male (15+)","HV03-31"]
[null,null,"Female (15+)","HV03-32"]
[null,null,"Total Revisit on ART (Sum HV03-29 to HV03-32)","HV03-33"]
[null,"3.3.1 On Therapy (from the tally sheet- this month only and from last 2 months)"]
[null,null,"Current on ART – (<1)                (HIV03-20 plus HV03-28)","HV03-34"]
[null,null,"Current on ART – Male (<15)     (HIV03-21 plus HV03-29)","HV03-35"]
[null,null,"Current on ART – Female (<15) (HIV03-22 plus HV03-30)","HV03-36"]
[null,null,"Current on ART – Male (15+)     (HIV03-23 plus HV03-31)","HV03-37"]
[null,null,"Current on ART – Female (15+) (HIV03-24 plus HV03-32)","HV03-38"]
[null,null,"Total Current on ART (Sum HV03-35 to HV03-38)","HV03-39"]
[null,"3.4 Cumulative Ever on ART"]
[null,null,"Male (<15)","HV03-40"]
[null,null,"Female (<15)","HV03-41"]
[null,null,"Male (15+)","HV03-42"]
[null,null,"Female (15+)","HV03-43"]
[null,null,"Total Ever on ART (Sum HV03-40 to HV03-43)","HV03-44"]
[null,"3.5 Survival and Retention on ART at 12 months"]
[null,null,"ART Net Cohort at 12 months","HV03-45"]
[null,null,"On Original 1st Line at 12 months","HV03-46",null,"</=HV03-45"]
[null,null,"On alternative 1st Line at 12 months","HV03-47",null,"</=HV03-45"]
[null,null,"On 2nd Line (or higher) at 12 months ","HV03-48",null,"</=HV03-45"]
[null,null,"On therapy at 12 months (Sum HV03-46 to HV03-48)","HV03-49",null,"</=HV03-45"]
[null,"3.6 Screening"]
[null,null,"TB - Male (<15)","HV03-50"]
[null,null,"TB - Female (<15)","HV03-51"]
[null,null,"TB - Male (15+)","HV03-52"]
[null,null,"TB - Female (15+)","HV03-53"]
[null,null,"Total Screened for TB (Sum HV03-50 to HV03-53)","HV03-54",null,"</=HV03-73"]
[null,null,"Screened for cervical cancer (females 18+)","HV03-55",null,"</=HV03-70"]
[null,"3.8 HIV Care Visits"]
[null,null,"HIV Care visit – females (18+)","HV03-70"]
[null,null,"HIV-Care visit – scheduled","HV03-71"]
[null,null,"HIV-Care visit – unscheduled","HV03-72"]
[null,null,"HIV Care visits (Add HV03-71 and HV03-72)","HV03-73"]
[]
[]
["4 Voluntary Medical Male Circumcision"]
[null,"4.1 Number Circumcised",null,null,"Value","Notes"]
[null,null,"<15","HV04-01"]
[null,null,"15-24","HV04-02"]
[null,null,"25+","HV04-03"]
[null,null,"Total Circumcised (Sum HV04-01 to HV04-03)","HV04-06",null,">/=(HV04-07+HV04-08+HV04-09)"]
[null,"4.2 HIV Status (at circumcision)"]
[null,null,"Positive","HV04-07"]
[null,null,"Negative","HV04-08"]
[null,null,"Unknown","HV04-09"]
[null,"4.3 Adverse Events (Circumcision)"]
[null,null,"During -AE(s)– moderate","HV04-10",null,"</=HV04-06"]
[null,null,"During– AE(s) – severe","HV04-11",null,"</=HV04-06"]
[null,null,"Post -AE(s)– moderate","HV04-12",null,"</=HV04-06"]
[null,null,"Post– AE(s) – severe","HV04-13",null,"</=HV04-06"]
[null,null,"Total AE  During (Sum HV04-10 and HV04-11)","HV04-14",null,"</=HV04-06"]
[null,null,"Total AE  Post (Sum HV04-12 and HV04-13)","HV04-15",null,"</=HV04-06"]
[]
[]
["5 Post-Exposure Prophylaxis"]
[null,"5.1 Type of Exposure"]
[null,null,"Occupational – male","HV05-01"]
[null,null,"Occupational – female","HV05-02"]
[null,null,"Sexual assault – male","HV05-03"]
[null,null,"Sexual assault – female","HV05-04"]
[null,null,"Other reasons - male","HV05-05"]
[null,null,"Other reasons  - female","HV05-06"]
[null,null,"Total Exposed (Sum HV05-01 to HV05-06)","HV05-07"]
[null,"5.2 Provided with Prophylaxis"]
[null,null,"Occupational – male","HV05-08",null,"</=HV05-01"]
[null,null,"Occupational – female","HV05-09",null,"</=HV05-02"]
[null,null,"Sexual assault – male","HV05-10",null,"</=HV05-03"]
[null,null,"Sexual assault – female","HV05-11",null,"</=HV05-04"]
[null,null,"Other reasons – male ","HV05-12",null,"</=HV05-05"]
[null,null,"Other reasons – female","HV05-13",null,"</=HV05-06"]
[null,null,"Total PEP (Sum HV05-08 to HV05-13)","HV05-14",null,"</=HV05-07"]
[]
[]
["6 Blood Safety",{"$nulls":5},"Only * indicators are applicable"]
[null,null,"Donated blood units","HV06-01",null,null,"*"]
[null,null,"Blood units screened for TTIs","HV06-02",null,"</=HV06-01","*"]
[null,null,"Screened in quality-assured manner","HV06-03",null,"</=HV06-02"]
[null,null,"Units of whole blood screened for TTIs","HV06-04"]
[null,null,"Blood units reactive to HIV","HV06-05",null,"</=HV06-02","*"]
[null,null,"Blood units screened for HIV","HV06-06",null," =HIV06-4"]

{"sheet":"HTC","index":1,"n_rows":99,"n_cols":19,"rows_kept":99,"merged":[[30,14,30,16],[31,14,31,16]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":13},"1. HTC","Title/ Name of Graph","Formula","Data Presentation Type","Frequency"]
[{"$nulls":13},"i. ","1st and Repeat Testers","HV01-01 and HV01-02","Component Bar Graph","Monthly Count "]
[{"$nulls":13},"ii.","HTC Positivity","HV01-08 / HV01-03","Line Graph","Monthly Count"]
[{"$nulls":13},"iii","Couples Tested","HV01-05","Bar Graph","Monthly Count"]
[{"$nulls":13},"iv.","Couple Discordancy","HV01-09 / HV01-05","Bar Graph","Monthly Rate"]
[]
[]
[{"$nulls":15},"HTC First and Repeat Testers"]
[{"$nulls":14},"First Time Testers (HV01-01)","Repeat Testers (HV01-02)","HV01-03: Total Tested = (HV01-01 plus HV01-02)","% First Time Testers","%  Repeat  Testers"]
[{"$nulls":13},"Jan",213,98,311,{"v":68.48874598070739,"d":"68.5"},{"v":31.511254019292608,"d":"31.5"}]
[{"$nulls":13},"Feb",148,111,259,{"v":57.14285714285714,"d":"57.1"},{"v":42.857142857142854,"d":"42.9"}]
[{"$nulls":13},"March",171,101,272,{"v":62.86764705882353,"d":"62.9"},{"v":37.13235294117647,"d":"37.1"}]
[{"$nulls":13},"April",103,54,157,{"v":65.60509554140127,"d":"65.6"},{"v":34.394904458598724,"d":"34.4"}]
[{"$nulls":13},"May",98,56,154,{"v":63.63636363636363,"d":"63.6"},{"v":36.36363636363637,"d":"36.4"}]
[{"$nulls":13},"June",150,120,270,{"v":55.55555555555556,"d":"55.6"},{"v":44.44444444444444,"d":"44.4"}]
[{"$nulls":13},"July",204,90,294,{"v":69.38775510204081,"d":"69.4"},{"v":30.612244897959183,"d":"30.6"}]
[{"$nulls":13},"Aug",270,87,357,{"v":75.63025210084034,"d":"75.6"},{"v":24.369747899159663,"d":"24.4"}]
[{"$nulls":13},"Sept",309,211,520,{"v":59.42307692307692,"d":"59.4"},{"v":40.57692307692308,"d":"40.6"}]
[{"$nulls":13},"Oct",415,306,721,{"v":57.558945908460466,"d":"57.6"},{"v":42.44105409153953,"d":"42.4"}]
[{"$nulls":13},"Nov",590,297,887,{"v":66.5163472378805,"d":"66.5"},{"v":33.483652762119505,"d":"33.5"}]
[{"$nulls":13},"Dec",612,438,1050,{"v":58.285714285714285,"d":"58.3"},{"v":41.714285714285715,"d":"41.7"}]
{"$rows_empty":8}
[{"$nulls":13},"ii.","HTC Positivity "]
[{"$nulls":14},"(HV01-08 / HV01-03)"]
[{"$nulls":14},"HV01-08: Positive Test Results","Total Tested:HV01-03              = (HV01-01 plus HV01-02)","Positivity Rate = HV01-08 / HV01-03"]
[{"$nulls":13},"Jan",8,311,{"v":2.572347266881029,"d":"3"}]
[{"$nulls":13},"Feb",11,259,{"v":4.247104247104247,"d":"4"}]
[{"$nulls":13},"March",9,272,{"v":3.308823529411765,"d":"3"}]
[{"$nulls":13},"April",3,157,{"v":1.910828025477707,"d":"2"}]
[{"$nulls":13},"May",4,154,{"v":2.5974025974025974,"d":"3"}]
[{"$nulls":13},"June",7,270,{"v":2.5925925925925926,"d":"3"}]
[{"$nulls":13},"July",6,294,{"v":2.0408163265306123,"d":"2"}]
[{"$nulls":13},"Aug",17,357,{"v":4.761904761904762,"d":"5"}]
[{"$nulls":13},"Sept",31,520,{"v":5.961538461538462,"d":"6"}]
[{"$nulls":13},"Oct",36,721,{"v":4.993065187239944,"d":"5"}]
[{"$nulls":13},"Nov",58,887,{"v":6.538895152198422,"d":"7"}]
[{"$nulls":13},"Dec",74,1050,{"v":7.0476190476190474,"d":"7"}]
[]
[]
[]
[]
[]
[{"$nulls":8},"Positivity should be by gender in bar, and overall in line - ideal but not possible since the data elements are not disaggregated by gender thus maintain as is"]
[]
[]
[]
[]
[]
[]
[{"$nulls":13},"iii.","HTC Couples Testing"]
[{"$nulls":14},"Total Tested:HV01-03              = (HV01-01 plus HV01-02)","Couples","Discordant Couples"]
[{"$nulls":13},"Jan",311,12,3]
[{"$nulls":13},"Feb",259,17,4]
[{"$nulls":13},"March",272,19,5]
[{"$nulls":13},"April",157,11,4]
[{"$nulls":13},"May",154,9,2]
[{"$nulls":13},"June",270,15,3]
[{"$nulls":13},"July",294,18,5]
[{"$nulls":13},"Aug",357,21,7]
[{"$nulls":13},"Sept",520,27,9]
[{"$nulls":13},"Oct",721,33,11]
[{"$nulls":13},"Nov",887,41,17]
[{"$nulls":13},"Dec",1050,49,21]
{"$rows_empty":14}
[{"$nulls":14},"iii.","HTC Couple Discordancy"]
[{"$nulls":15},"Couples","Discordant Couples","Proportion"]
[{"$nulls":14},"Jan",12,3,{"v":25,"d":"25.0"}]
[{"$nulls":14},"Feb",17,4,{"v":23.52941176470588,"d":"23.5"}]
[{"$nulls":14},"March",19,5,{"v":26.31578947368421,"d":"26.3"}]
[{"$nulls":14},"April",11,4,{"v":36.36363636363637,"d":"36.4"}]
[{"$nulls":14},"May",9,2,{"v":22.22222222222222,"d":"22.2"}]
[{"$nulls":14},"June",15,3,{"v":20,"d":"20.0"}]
[{"$nulls":14},"July",18,5,{"v":27.77777777777778,"d":"27.8"}]
[{"$nulls":14},"Aug",21,7,{"v":33.33333333333333,"d":"33.3"}]
[{"$nulls":14},"Sept",27,9,{"v":33.33333333333333,"d":"33.3"}]
[{"$nulls":14},"Oct",33,11,{"v":33.33333333333333,"d":"33.3"}]
[{"$nulls":14},"Nov",41,17,{"v":41.46341463414634,"d":"41.5"}]
[{"$nulls":14},"Dec",49,21,{"v":42.857142857142854,"d":"42.9"}]

{"sheet":"PMTCT + Infants","index":2,"n_rows":177,"n_cols":22,"rows_kept":177,"merged":[[7,12,8,12],[7,13,8,13],[7,14,8,14],[7,15,8,15],[7,16,8,16]],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":12},"Program",null,"Title/ Name of Graph","Formula","Data Presentation Type","Frequency"]
[{"$nulls":12},"2.1. PMTCT","i.","Positivity at ANC","(HV02-05 + HV02-06) / ANC 1st Visits",null,"Monthly Rate"]
[{"$nulls":13},"ii.","ARV Prophylaxis for Mother","HV02-17 / HV02-09","Bar Graph","Monthly Rate"]
[{"$nulls":13},"iii.","Infants","Add new Indicator for Baby"]
[{"$nulls":13},"iv.","Assessment for Eligibility in ANC","HV02-20 / HV02.09","Fixed"]
[{"$nulls":13},"v.","Assessment Eligibility for ANC","HV02-18 and HV02-19","Component Graph","Monthly "]
[{"$nulls":17},"Count"]
[{"$nulls":13},"vi.","Type of Prophylaxis for +ve Mothers","HV02-13, HV02-14, HV02-15 and HV02-16","Component stacked Bar showing each prophylaxis","Monthly Count"]
[]
[]
[]
[]
[]
[]
[{"$nulls":14},"i.  Positivity at ANC"]
[{"$nulls":14},"HV02-05: Known positive status (at entry into ANC)","HV02-06 Antenatal HIV+ Results","ANC 1st Visits","Positivity at ANC"]
[{"$nulls":13},"Jan",3,5,33,{"v":24.242424242424242,"d":"24"}]
[{"$nulls":13},"Feb",1,6,37,{"v":18.91891891891892,"d":"19"}]
[{"$nulls":13},"March",5,4,50,18]
[{"$nulls":13},"April",4,7,44,25]
[{"$nulls":13},"May",2,3,39,{"v":12.82051282051282,"d":"13"}]
[{"$nulls":13},"June",3,3,40,15]
[{"$nulls":13},"July",3,1,34,{"v":11.76470588235294,"d":"12"}]
[{"$nulls":13},"Aug",1,7,51,{"v":15.686274509803921,"d":"16"}]
[{"$nulls":13},"Sept",4,4,49,{"v":16.3265306122449,"d":"16"}]
[{"$nulls":13},"Oct",5,2,35,20]
[{"$nulls":13},"Nov",2,1,47,{"v":6.382978723404255,"d":"6"}]
[{"$nulls":13},"Dec",2,6,69,{"v":11.594202898550725,"d":"12"}]
{"$rows_empty":9}
[{"$nulls":14},"ii. ARV Prophylaxis for Mother "]
[{"$nulls":14},"HV02-09","HV02-13 "," HV02-14,","HV02-15","HV02-16","HV02-17","ARV Prohylaxis Rate (HV02-17 / HV02-09)","Infant Prophylaxis"]
[{"$nulls":13},"Jan",24,9,7,5,3,24,{"v":100,"d":"100.0"}]
[{"$nulls":13},"Feb",33,12,9,6,6,33,{"v":100,"d":"100.0"}]
[{"$nulls":13},"March",41,25,7,6,3,41,{"v":100,"d":"100.0"}]
[{"$nulls":13},"April",33,14,8,6,5,33,{"v":100,"d":"100.0"}]
[{"$nulls":13},"May",38,18,12,8,2,40,{"v":105.26315789473684,"d":"105.3"}]
[{"$nulls":13},"June",22,12,8,0,0,20,{"v":90.9090909090909,"d":"90.9"}]
[{"$nulls":13},"July",40,27,4,4,2,37,92.5]
[{"$nulls":13},"Aug",37,15,10,6,4,35,{"v":94.5945945945946,"d":"94.6"}]
[{"$nulls":13},"Sept",12,6,4,0,2,12,{"v":100,"d":"100.0"}]
[{"$nulls":13},"Oct",10,7,1,1,1,10,{"v":100,"d":"100.0"}]
[{"$nulls":13},"Nov",18,11,2,3,1,17,{"v":94.44444444444444,"d":"94.4"}]
[{"$nulls":13},"Dec",22,10,7,3,1,21,{"v":95.45454545454545,"d":"95.5"}]
[]
[]
[]
[{"$nulls":9},"Put infant prophylaxsis"]
[{"$nulls":15},"v.  Assessment for Eligibility in ANC"]
[{"$nulls":15},"HV02-18","HV02-19","HV02-20","Not Assessed","HV02-20 / HV02.09"]
[{"$nulls":14},"Jan",4,27,31]
[{"$nulls":14},"Feb",2,33,35]
[{"$nulls":14},"March",7,40,47]
[{"$nulls":14},"April",6,38,44]
[{"$nulls":14},"May",9,30,39]
[{"$nulls":14},"June",11,18,29]
[{"$nulls":14},"July",8,26,34]
[{"$nulls":14},"Aug",3,42,45]
[{"$nulls":14},"Sept",9,37,46]
[{"$nulls":14},"Oct",5,22,27]
[{"$nulls":14},"Nov",1,39,40]
[{"$nulls":14},"Dec",4,58,62]
{"$rows_empty":11}
[{"$nulls":15},"vi.  Type of Prophylaxis for +ve Mothers"]
[{"$nulls":15},"HV02-13 "," HV02-14,","HV02-15","HV02-16"]
[{"$nulls":14},"Jan",9,7,5,3]
[{"$nulls":14},"Feb",12,9,6,6]
[{"$nulls":14},"March",25,7,6,3]
[{"$nulls":14},"April",14,8,6,5]
[{"$nulls":14},"May",18,12,8,2]
[{"$nulls":14},"June",12,8,0,0]
[{"$nulls":14},"July",27,4,4,2]
[{"$nulls":14},"Aug",15,10,6,4]
[{"$nulls":14},"Sept",6,4,0,2]
[{"$nulls":14},"Oct",7,1,1,1]
[{"$nulls":14},"Nov",11,2,3,1]
[{"$nulls":14},"Dec",10,7,3,1]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"Add not given"]
[]
[]
[]
[]
[{"$nulls":12},"2.2.  Infant Testing","i.","Total Infant Tests","HV02-28",null,"Monthly Count"]
[{"$nulls":13},"ii.","Positivity - Infants","HV02-32 / HV02-28","?","Monthly Rate"]
[{"$nulls":13},"iii.","Infant Feeding","(HV02-33 + HV02-34) / HV02-36","Line Graph","Monthly"]
[{"$nulls":13},"iv.","Mixed Feeding (Infants)","HV02-35 / HV02-36","Line Graph embedded in (iii) above","Monthly"]
[]
[]
[{"$nulls":14},"i.  Total Infant Tests"]
[{"$nulls":14},"HV02-24","HV02-25","HV02-26","HV02-28"]
[{"$nulls":13},"Jan",2,3,2,7]
[{"$nulls":13},"Feb",5,3,0,8]
[{"$nulls":13},"March",4,6,2,12]
[{"$nulls":13},"April",3,1,2,6]
[{"$nulls":13},"May",2,4,2,8]
[{"$nulls":13},"June",1,3,2,6]
[{"$nulls":13},"July",4,1,3,8]
[{"$nulls":13},"Aug",4,2,3,9]
[{"$nulls":13},"Sept",0,3,1,4]
[{"$nulls":13},"Oct",1,0,0,1]
[{"$nulls":13},"Nov",2,3,1,6]
[{"$nulls":13},"Dec",2,1,0,3]
{"$rows_empty":13}
[{"$nulls":14},"ii. Positivity Infants"]
[{"$nulls":14},"HV02-29","HV02-30","HV02-31","HV02-32","Positivity 2.32/2.28"]
[{"$nulls":13},"Jan",0,0,0,0,0]
[{"$nulls":13},"Feb",1,1,0,2,25]
[{"$nulls":13},"March",1,2,1,4,{"v":33.33333333333333,"d":"33"}]
[{"$nulls":13},"April",0,0,2,2,{"v":33.33333333333333,"d":"33"}]
[{"$nulls":13},"May",0,0,2,2,25]
[{"$nulls":13},"June",1,0,0,1,{"v":16.666666666666664,"d":"17"}]
[{"$nulls":13},"July",2,0,1,3,{"v":37.5,"d":"38"}]
[{"$nulls":13},"Aug",3,0,0,3,{"v":33.33333333333333,"d":"33"}]
[{"$nulls":13},"Sept",0,0,0,0,0]
[{"$nulls":13},"Oct",0,0,0,0,0]
[{"$nulls":13},"Nov",0,2,1,3,50]
[{"$nulls":13},"Dec",0,0,0,0,0]
{"$rows_empty":8}
[{"$nulls":14},"iii & iv: Infant Feeding"]
[]
[{"$nulls":14},"(HV02-33","HV02-34","HV02-35","HV02-36","EBF+ERF: (HV02-33 + HV02-34) / HV02-36","MF Rate: HV02-35 / HV02-36"]
[{"$nulls":13},"Jan",4,1,2,7,{"v":71.42857142857143,"d":"71.4"},{"v":28.57142857142857,"d":"28.6"}]
[{"$nulls":13},"Feb",6,3,4,13,{"v":69.23076923076923,"d":"69.2"},{"v":30.76923076923077,"d":"30.8"}]
[{"$nulls":13},"March",7,2,2,11,{"v":81.81818181818183,"d":"81.8"},{"v":18.181818181818183,"d":"18.2"}]
[{"$nulls":13},"April",6,1,4,11,{"v":63.63636363636363,"d":"63.6"},{"v":36.36363636363637,"d":"36.4"}]
[{"$nulls":13},"May",3,3,0,6,{"v":100,"d":"100.0"},{"v":0,"d":"0.0"}]
[{"$nulls":13},"June",5,4,1,10,{"v":90,"d":"90.0"},{"v":10,"d":"10.0"}]
[{"$nulls":13},"July",2,5,3,10,{"v":70,"d":"70.0"},{"v":30,"d":"30.0"}]
[{"$nulls":13},"Aug",0,4,4,8,{"v":50,"d":"50.0"},{"v":50,"d":"50.0"}]
[{"$nulls":13},"Sept",2,2,1,5,{"v":80,"d":"80.0"},{"v":20,"d":"20.0"}]
[{"$nulls":13},"Oct",4,3,5,12,{"v":58.333333333333336,"d":"58.3"},{"v":41.66666666666667,"d":"41.7"}]
[{"$nulls":13},"Nov",2,0,2,4,{"v":50,"d":"50.0"},{"v":50,"d":"50.0"}]
[{"$nulls":13},"Dec",1,6,1,8,87.5,12.5]

{"sheet":"Care & Trmnt","index":3,"n_rows":88,"n_cols":19,"rows_kept":88,"flags":["formulas_cached_only"]}
[]
[{"$nulls":10},"i.","Proportion Receiving Cotrimoxazole","HV03-07 / HV03-19","Line Graph"]
[{"$nulls":10},"ii.","Enrollees into Care","HV03-13","Bar Graph","Monthly Count"]
[{"$nulls":10},"iii.","Retention Rate on ARV","HV03-49 / HV03-45","Table (line or Bar)","Rate"]
[{"$nulls":10},"iv.","Screening - TB","HV03-54 / HV03-73",null,"Ratio"]
[]
[]
[]
[]
[]
[{"$nulls":10},"3.1 Cotrimoxazole Prophylaxis"]
[{"$nulls":12},"Jan","Feb","Mar","April","May","June"]
[{"$nulls":10},"Male (<15)","HV03-03",110,98,119,100,221,211]
[{"$nulls":10},"Female (<15)","HV03-04",234,307,86,238,177,349]
[{"$nulls":10},"Male (15+)","HV03-05",327,210,258,275,259,256]
[{"$nulls":10},"Female (15+)","HV03-06",255,198,299,217,227,301]
[{"$nulls":10},"Total on CTX (Sum HV03-03 to HV03-06)","HV03-07",926,813,762,830,884,1117]
[]
[{"$nulls":10},"Proportion Receiving Cotrimoxazole","HV03-07 / HV03-19",{"v":98.09322033898306,"d":"98"},{"v":83.55601233299075,"d":"84"},{"v":75.37091988130564,"d":"75"},100,{"v":89.74619289340102,"d":"90"},{"v":93.70805369127517,"d":"94"}]
[]
[]
[]
[{"$nulls":3},"discuss the team whether add all prophylaxis or not"]
[]
[]
[]
[]
[]
[{"$nulls":10},"3.2 Enrolling in Care",null,"Jan","Feb","Mar","April","May","June"]
[{"$nulls":10},"Male (<15)","HV03-09",4,2,3,4,4,7]
[{"$nulls":10},"Female (<15)","HV03-10",2,3,3,5,2,1]
[{"$nulls":10},"Male (15+)","HV03-11",6,9,10,4,3,5]
[{"$nulls":10},"Female (15+)","HV03-12",17,15,22,2,5,9]
[{"$nulls":10},"Total Enrolled in Care (Sum HV03-09 to HV03-12)","HV03-13",29,29,38,15,14,22]
[]
[]
[]
[]
[]
[]
[{"$nulls":10},"3.3 Currently in Care",null,"Jan","Feb","Mar","April","May","June"]
[{"$nulls":10},"Male (<15)","HV03-15",33,35,38,44,47,51]
[{"$nulls":10},"Female (<15)","HV03-16",29,32,35,54,63,86]
[{"$nulls":10},"Male (15+)","HV03-17",320,329,339,310,311,382]
[{"$nulls":10},"Female (15+)","HV03-18",562,577,599,422,564,673]
[{"$nulls":10},"Currently in Care (Sum HV03-15 to HV03-18)","HV03-19",944,973,1011,830,985,1192]
[]
[]
[{"$nulls":10},"3.5 Survival and Retention on ART at 12 months",null,"Jan","Feb","Mar","April","May","June"]
[{"$nulls":10},"ART Net Cohort at 12 months","HV03-45",8,6,7,6,8,9]
[{"$nulls":10},"On Original 1st Line at 12 months","HV03-46",6,5,5,6,7,6]
[{"$nulls":10},"On alternative 1st Line at 12 months","HV03-47",2,1,null,3,1,4]
[{"$nulls":10},"On 2nd Line (or higher) at 12 months ","HV03-48",2,4,1,5,3,3]
[{"$nulls":10},"On therapy at 12 months (Sum HV03-46 to HV03-48)","HV03-49",10,10,6,14,11,13]
[{"$nulls":10},"Retention Rate on original 1st line at 12 months",null,0.75,0.8333333333333334,0.7142857142857143,1,0.875,0.6666666666666666]
["Proposed Graph below OK?",null,null,"Net cohort is denominator"]
[{"$nulls":3},"Calculate proportion per 4 data elements (HV03-46<49)"]
[{"$nulls":3},"Change to 100% stack bar"]
[]
[]
[{"$nulls":13},"Jan","Feb","Mar","April","May","June"]
[]
[{"$nulls":12},"On Original 1st Line at 12 months",75,{"v":83.33333333333334,"d":"83"},{"v":71.42857142857143,"d":"71"},100,{"v":87.5,"d":"88"},{"v":66.66666666666666,"d":"67"}]
[{"$nulls":12},"On alternative 1st Line at 12 months",25,{"v":16.666666666666664,"d":"17"},0,50,{"v":12.5,"d":"13"},{"v":44.44444444444444,"d":"44"}]
[{"$nulls":12},"On 2nd Line (or higher) at 12 months ",25,{"v":66.66666666666666,"d":"67"},{"v":14.285714285714285,"d":"14"},{"v":83.33333333333334,"d":"83"},{"v":37.5,"d":"38"},{"v":33.33333333333333,"d":"33"}]
[{"$nulls":12},"On therapy at 12 months (Sum HV03-46 to HV03-48)",125,{"v":166.66666666666669,"d":"167"},{"v":85.71428571428571,"d":"86"},{"v":233.33333333333334,"d":"233"},{"v":137.5,"d":"138"},{"v":144.44444444444443,"d":"144"}]
{"$rows_empty":8}
[{"$nulls":10},"3.6 Screening",null,"Jan","Feb","Mar","April","May","June"]
[{"$nulls":10},"TB - Male (<15)","HV03-50",5,4,3,3,5,4]
[{"$nulls":10},"TB - Female (<15)","HV03-51",3,6,18,7,11,21]
[{"$nulls":10},"TB - Male (15+)","HV03-52",43,52,54,45,54,68]
[{"$nulls":10},"TB - Female (15+)","HV03-53",97,88,79,88,96,87]
[{"$nulls":10},"Total Screened for TB (Sum HV03-50 to HV03-53)","HV03-54",148,150,154,143,166,180]
[{"$nulls":10},"Screened for cervical cancer (females 18+)","HV03-55"]
[]
[{"$nulls":10},"3.8 HIV Care Visits",null,"Jan","Feb","Mar","April","May","June"]
[{"$nulls":10},"HIV Care visit – females (18+)","HV03-70"]
[{"$nulls":10},"HIV-Care visit – scheduled","HV03-71",87,95,105,137,112,103]
[{"$nulls":10},"HIV-Care visit – unscheduled","HV03-72",66,72,65,39,67,91]
[{"$nulls":10},"HIV Care visits (Add HV03-71 and HV03-72)","HV03-73",153,167,170,176,179,194]
[{"$nulls":10},"Screening - TB","HV03-54 / HV03-73",{"v":96.73202614379085,"d":"96.7"},{"v":89.82035928143712,"d":"89.8"},{"v":90.58823529411765,"d":"90.6"},{"v":81.25,"d":"81.3"},{"v":92.73743016759776,"d":"92.7"},{"v":92.78350515463917,"d":"92.8"}]

{"sheet":"VMMC","index":4,"n_rows":29,"n_cols":20,"rows_kept":29,"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":12},"4.  VMMC","i.","No. Provided with VMMC Services","HV04-06","Bar","Monthly Count"]
[{"$nulls":13},"ii.","VMMC Positivity","HV04-07 / HV04-06","Line","Monthly"]
[{"$nulls":13},"iii.","Adverse Events - Total","(HV04-15 + HV04-14) / HV04-06","Trend","Monthly"]
{"$rows_empty":8}
[{"$nulls":12},"4.1 Number Circumcised","Formula","Jan","Feb","Mar","April","May","June"]
[{"$nulls":12},"<15","HV04-01",9,12,8,5,7,11]
[{"$nulls":12},"15-24","HV04-02",15,18,12,17,35,19]
[{"$nulls":12},"25+","HV04-03",33,22,11,35,29,31]
[{"$nulls":12},"Total Circumcised (Sum HV04-01 to HV04-03)","HV04-06",57,52,31,57,71,61]
[{"$nulls":12},"Positive","HV04-07",5,2,6,4,17,8]
[{"$nulls":12},"ii. Positivity","HV04-07 / HV04-06",{"v":8.771929824561402,"d":"9"},{"v":3.8461538461538463,"d":"4"},{"v":19.35483870967742,"d":"19"},{"v":7.017543859649122,"d":"7"},{"v":23.943661971830984,"d":"24"},{"v":13.114754098360656,"d":"13"}]
[]
[{"$nulls":12},"During -AE(s)– moderate","HV04-10",1,3,2,4,9,7]
[{"$nulls":12},"During– AE(s) – severe","HV04-11",0,0,1,0,2,3]
[{"$nulls":12},"Post -AE(s)– moderate","HV04-12",3,2,4,1,6,1]
[{"$nulls":12},"Post– AE(s) – severe","HV04-13",1,0,2,0,7,0]
[{"$nulls":12},"Total AE  During (Sum HV04-10 and HV04-11)","HV04-14",1,3,3,4,11,10]
[{"$nulls":12},"Total AE  Post (Sum HV04-12 and HV04-13)","HV04-15",4,2,6,1,13,1]
[]
[{"$nulls":12},"iii. Adverse Events Total","(HV04-14 + HV04-15) / HV04-06",{"v":8.771929824561402,"d":"9"},{"v":9.615384615384617,"d":"10"},{"v":29.03225806451613,"d":"29"},{"v":8.771929824561402,"d":"9"},{"v":33.80281690140845,"d":"34"},{"v":18.0327868852459,"d":"18"}]

{"sheet":"PEP","index":5,"n_rows":29,"n_cols":19,"rows_kept":29,"flags":["formulas_cached_only"]}
[]
[{"$nulls":10},"5.  PEP"]
[{"$nulls":10},"i.","PEP Provision Rate","HV05-14 / HV05-07","Bar","Rate Monthly"]
[{"$nulls":10},"ii.","Provided with PEP by Reason","(HV05-08 + HV05-09), (HV05-10+HV05-11) and (HV05-12+HV05-13)","Stacked Bar Graph","Monthly Count"]
[]
[{"$nulls":11},"5.1 Type of Exposure",null,"Jan","Feb","Mar","April","May","June"]
[{"$nulls":11},"Occupational – male","HV05-01",1,0,0,1,0,1]
[{"$nulls":11},"Occupational – female","HV05-02",3,1,2,0,0,1]
[{"$nulls":11},"Sexual assault – male","HV05-03",1,0,1,0,1,2]
[{"$nulls":11},"Sexual assault – female","HV05-04",4,2,3,7,5,2]
[{"$nulls":11},"Other reasons - male","HV05-05",0,0,1,0,0,1]
[{"$nulls":11},"Other reasons  - female","HV05-06",1,0,0,0,1,0]
[{"$nulls":11},"Total Exposed (Sum HV05-01 to HV05-06)","HV05-07",10,3,7,8,7,7]
[{"$nulls":11},"5.2 Provided with Prophylaxis"]
[{"$nulls":11},"Occupational – male","HV05-08",1,0,0,1,0,1]
[{"$nulls":11},"Occupational – female","HV05-09",3,1,1,0,0,0]
[{"$nulls":11},"Sexual assault – male","HV05-10",0,0,1,0,1,1]
[{"$nulls":11},"Sexual assault – female","HV05-11",3,2,2,6,3,2]
[{"$nulls":11},"Other reasons – male ","HV05-12",0,0,1,0,0,1]
[{"$nulls":11},"Other reasons – female","HV05-13",1,0,0,0,1,0]
[{"$nulls":11},"Total PEP (Sum HV05-08 to HV05-13)","HV05-14",8,3,5,7,5,5]
[]
[{"$nulls":11},"i.  PEP Provision Rate","HV05-14 / HV05-07",{"v":80,"d":"80.0"},{"v":100,"d":"100.0"},{"v":71.42857142857143,"d":"71.4"},87.5,{"v":71.42857142857143,"d":"71.4"},{"v":71.42857142857143,"d":"71.4"}]
[]
[{"$nulls":11},"ii. Provided with PEP by Reason\n","(HV05-08 + HV05-09), (HV05-10+HV05-11) and (HV05-12+HV05-13)"]
[]
[{"$nulls":11},"Occupational","(HV05-08 + HV05-09)",4,1,1,1,0,1]
[{"$nulls":11},"Sexual Assault","(HV05-10+HV05-11)",3,2,3,6,4,3]
[{"$nulls":11},"Other Reasons","(HV05-12+HV05-13",1,0,1,0,1,1]