VNM -> Suggested Change to LTFU

[achafetz]

Thoughts, @noahbartlett?

Passed along from the Vietnam team by J.Buehler (Feb 5).

Our team here in Vietnam are in process of data entry for the datapack, and we found that current version seems to underestimate TX_NEW for FY19 (Tab Target calculation) because it use it underestimate the FY19 LTFU.

The current version, dated v2018.01.11, formula for column AM titled "FY19 LTFU (TX_NEW minus TX_NET_NEW)" is "=IFERROR(MAX(0,((1-AG26)*AL26)+((1-AI26)*AB26)),0)"

We believe above mentioned formula underestimate the LTFU for newly enrolled patients, especially for SNU where FY18 TX_NEW is significantly greater than FY19 TX_NET_NEW, and overestimates for SNU where FY18 TX_NET_NEW is significantly lower than FY19 TX_NET_NEW.

Therefore we would like to suggest to use column AF "FY19 TX_RET (Denom.)" (Column AD) so that the formula would be
"FY19 LTFU" = "IFERROR(MAX(0,((1-AG26)*AF26)+((1-AI26)*AB26)),0)".

[noahbartlett]

I wonder if this was largely addressed by readjusting the retention rates. Jacob do you know if (a) they fixed the first year vs. long term LTFU rates and (b) is this still a problem?

…

Sent from my iPhone On Feb 14, 2018, at 12:44 PM, Aaron <notifications@github.com> wrote: Thoughts, @noahbartlett <https://github.com/noahbartlett>? Passed along from the Vietnam team by J.Buehler (Feb 5). Our team here in Vietnam are in process of data entry for the datapack, and we found that current version seems to underestimate TX_NEW for FY19 (Tab Target calculation) because it use it underestimate the FY19 LTFU. The current version, dated v2018.01.11, formula for column AM titled "FY19 LTFU (TX_NEW minus TX_NET_NEW)" is "=IFERROR(MAX(0,((1-AG26)*AL26)+((1-AI26)*AB26)),0)" We believe above mentioned formula underestimate the LTFU for newly enrolled patients, especially for SNU where FY18 TX_NEW is significantly greater than FY19 TX_NET_NEW, and overestimates for SNU where FY18 TX_NET_NEW is significantly lower than FY19 TX_NET_NEW. Therefore we would like to suggest to use column AF "FY19 TX_RET (Denom.)" (Column AD) so that the formula would be "FY19 LTFU" = "IFERROR(MAX(0,((1-AG26)**AF26*)+((1-AI26)*AB26)),0)". — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#156>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AYQeQZmeRFrUdx7HQvGxy4p4oqehHSHZks5tUxuDgaJpZM4SFtYu> .