search

achafetz / DataPack

PEPFAR Targeting Tool for Country Operating Plan (COP) 18
1 stars 4 forks source link

VNM -> Suggested Change to LTFU #156

Open achafetz opened 6 years ago

achafetz commented 6 years ago

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 commented 6 years ago

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 https://github.com/achafetz/DataPack/issues/156, or mute the thread https://github.com/notifications/unsubscribe-auth/AYQeQZmeRFrUdx7HQvGxy4p4oqehHSHZks5tUxuDgaJpZM4SFtYu .