{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["PMTCT","HTC","PEP","MARPS","Prevention W Positives","DashBoard Home Page (WIP)"],"not_rendered":{"charts":8,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"PMTCT","index":0,"n_rows":85,"n_cols":19,"rows_kept":85,"merged":[[0,5,1,17],[13,1,18,1],[25,2,26,9]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"Facility/ District \"X\" DASHBOARD"]
[]
[null,"PMTCT"]
[]
[]
[null,null,"1.  PMTCT HIV Prevalence Rate",{"$nulls":8},"ii.  Number of Male Partners Tested (HV02-11)"]
{"$rows_empty":7}
[null,"% PMTCT women HIV +"]
{"$rows_empty":7}
[null,null,"Q1",null,"Q2",null,"Q3",null,"Q4"]
[]
[{"$nulls":4},"Quarters (this axis could also represent facilities in the district)"]
[{"$nulls":11},"Number of Male Partners Tested each Quarter"]
[null,"Formula","PMTCT HIV Prevalance =  {Total PMTCT women HIV Positive (HV02-09 / Total PMTCT women tested  (HV02-04)}",{"$nulls":8},"Yr1, Q1","Q2","Q3","Q4","Yr2, Q1","Q2","Q3","Q4"]
[{"$nulls":11},74,98,214,43,22,56,77,132]
[]
[]
[]
[]
[]
[{"$nulls":4},"iii.  Prophylaxis (PMTCT) - Count"]
[]
[null,null," Option 1 (One Quarter All regimens)",{"$nulls":11}," Option 2 (4 Quarters all regimens)"]
{"$rows_empty":20}
[{"$nulls":9},"One Drug","2 ARVs","3 ARVs","HAART"]
[{"$nulls":8},"Q1",390,150,98,30]
[{"$nulls":8},"Q2",489,220,150,70]
[{"$nulls":8},"Q3",240,141,120,44]
[{"$nulls":8},"Q4",79,56,39,23]
[]
[]
[]
[null,"iii.  ART in MCH",{"$nulls":9},"iv.  PCR: Rate of Infants testing Positive (Comparison Chart)"]
[]
[{"$nulls":3},"Women Started on ART during ANC - simple bar chart"]
{"$rows_empty":16}
[{"$nulls":4},"Q1","Q2","Q3","Q4",{"$nulls":5},"By 3 Months","3-9 months","9-12 months"]
[{"$nulls":4},300,115,80,225,{"$nulls":4},"PCR infants Tested",117,98,104]
[{"$nulls":12},"PCR infants Testing Positive",11,9,6]

{"sheet":"HTC","index":1,"n_rows":26,"n_cols":27,"rows_kept":26,"merged":[[8,15,21,15],[12,1,17,1],[21,2,21,3],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,16,21,17],[21,19,21,20],[21,22,21,23],[21,25,21,26],[25,2,26,13],[25,16,26,27]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"HIV Testing and Counselling"]
[]
[]
[{"$nulls":3},"i.  HIV Prevalence ",{"$nulls":15},"ii.  HIV Incidence"]
[]
[{"$nulls":15},"HIV Incidence Rate"]
[]
[]
[]
[null,"HIV Prevalence Rate"]
{"$rows_empty":7}
[null,null,"Male","Female",null,"Male","Female",null,"Male","Female",null,"Male","Female",{"$nulls":3},"Male","Female",null,"Male","Female",null,"Male","Female",null,"Male","Female"]
[null,null,"Q1",null,null,"Q2",null,null,"Q3",null,null,"Q4",{"$nulls":4},"Q1",null,null,"Q2",null,null,"Q3",null,null,"Q4"]
[]
[{"$nulls":5},"Quarterly Cumulative",{"$nulls":14},"Quarters"]
[]
[null,null,"HIV Prevalance =  {HIV+ HTC Clients(HV01-08) / Total HTC Tested for HIV (HV01-03)}",{"$nulls":13},"HIV Incidence =  {HIV+ HTC Clients(HV01-01) this reporting quarter / HTC Tested (1st time testers?) for HIV (HV01-03)} this reporting quarter only"]

{"sheet":"PEP","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"merged":[[28,1,28,2],[29,1,29,2]],"flags":["formulas_cached_only"]}
[null,"Post Exposure Prophylaxis"]
[]
[]
[null,null,"Comparing Total Provided with PEP against Total Exposed to Risk"]
[null,null,"HV 05-14/ HV05-7"]
{"$rows_empty":22}
[{"$nulls":3},"Q1","Q2","Q3","Q4"]
[null,"Total Exposed",null,11,19,14,9]
[null,"Total Provided with PEP",null,5,17,13,9]

{"sheet":"MARPS","index":3,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[24,1,24,3],[25,1,25,3]],"flags":["formulas_cached_only"]}
[]
[]
[null,"Most-at-risk Persons (MARPS)"]
[null,"Comparing MARPS testing HIV Positive to MARPS Tested"]
{"$rows_empty":19}
[{"$nulls":4},"Q1","Q2","Q3","Q4"]
[null,"MAPRS Testing HIV Positive",null,null,3,6,2,3]
[null,"Total MARPS Tested",null,null,9,11,5,8]

{"sheet":"Prevention W Positives","index":4,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[27,2,27,4],[28,2,28,4]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Prevention With Positives"]
{"$rows_empty":23}
[{"$nulls":5},"Q1","Q2","Q3","Q4"]
[null,null,"Disclosed HIV Status to Partner",null,null,5,6,3,2]
[null,null,"Partner Received onsite HIV testing",null,null,1,0,0,1]

{"sheet":"DashBoard Home Page (WIP)","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"merged":[[3,1,5,5],[6,1,8,5],[9,1,11,5]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"MOH 711 B Report"]
[]
[]
[null,"Comprehensive Facility HIV/AIDS Report (MOH 726)"]
[]
[]
[null,"Graphs for HIV Programmes (as will be defined by TWG"]
[]
[]
[]
[{"$nulls":3},"HTC"]
[{"$nulls":3},"PMTCT"]
[{"$nulls":3},"Infants"]
[{"$nulls":3},"Care & Treatment"]
[{"$nulls":3},"VMMC"]
[{"$nulls":3},"PEP"]