This isn't an easy document to look through. However, I do have one comment/question. It's on the "TX" tab and it's around TX_PVLS. I suspect it is my own misunderstandings and not the fault of the document. Column AB is fine (and for us, 50% of TX_NEW are eligible for a VL test since it isn't offered until six months on treatment). Column AC is fine, although we often put a much smaller access rate than 100% as that would be far too many tests. Column AD makes sense as it is just the total number of clients that should get a routine VL test.
My issue comes with Column AE and AF. AE And AF seem to assume that we set the suppression rate only for routine tests. But that's not how we report. We report overall suppression rates. I'm unclear where the targeted VL tests are expected to be reported (both in terms of the target and in the anticipated suppression rate -- as targeted VL tests have far lower suppression rates).
• Targets:
o TX_CURR: (DP expected result: 1,830,844; DATIM: 1,831,233)
• Total NET_NEW appear in percentage, but the operands are numbers.
• Target PEPFAR TX_CURR Growth (FY20 to FY21) (%) on I4 should be in %. The same for Total NET_NEW N4
• % of NET_NEW from TX_RTT (%), the formula is =IF($B15="<01",0,0). So always it will be Zero.
This isn't an easy document to look through. However, I do have one comment/question. It's on the "TX" tab and it's around TX_PVLS. I suspect it is my own misunderstandings and not the fault of the document. Column AB is fine (and for us, 50% of TX_NEW are eligible for a VL test since it isn't offered until six months on treatment). Column AC is fine, although we often put a much smaller access rate than 100% as that would be far too many tests. Column AD makes sense as it is just the total number of clients that should get a routine VL test.
My issue comes with Column AE and AF. AE And AF seem to assume that we set the suppression rate only for routine tests. But that's not how we report. We report overall suppression rates. I'm unclear where the targeted VL tests are expected to be reported (both in terms of the target and in the anticipated suppression rate -- as targeted VL tests have far lower suppression rates).
• Targets: o TX_CURR: (DP expected result: 1,830,844; DATIM: 1,831,233) • Total NET_NEW appear in percentage, but the operands are numbers. • Target PEPFAR TX_CURR Growth (FY20 to FY21) (%) on I4 should be in %. The same for Total NET_NEW N4 • % of NET_NEW from TX_RTT (%), the formula is =IF($B15="<01",0,0). So always it will be Zero.