Interagency team requested help setting CXCA targets. OU-level targets are set at the OU level. Country team identified 87 (out of ~1600 in OU) sites where they want to implement CXCA screening among TX_CURR px.
Challenge was to create PSNU-level targets (to match DP) for the PSNUs of those sites.
For each 25-49 age band, in each PSNU where there are sites where the teams want to work, I calculated what the age_band/PSNU's share of the total TX_CURR was for women, 25-49 in those PSNUs.
I then applied those percentages to the 225,000 overall target to get the PSNU/age_band breakdowns.
I create a new workbook with the TX_CURR tab from the DP, created a pivot table, filtered to the age groups and PSNUs of interest and used "show value as a % of column total" to get the breakdowns, then applied those to the 225,000.
Interagency team requested help setting CXCA targets. OU-level targets are set at the OU level. Country team identified 87 (out of ~1600 in OU) sites where they want to implement CXCA screening among TX_CURR px.
Challenge was to create PSNU-level targets (to match DP) for the PSNUs of those sites.
For each 25-49 age band, in each PSNU where there are sites where the teams want to work, I calculated what the age_band/PSNU's share of the total TX_CURR was for women, 25-49 in those PSNUs.
I then applied those percentages to the 225,000 overall target to get the PSNU/age_band breakdowns.
I create a new workbook with the TX_CURR tab from the DP, created a pivot table, filtered to the age groups and PSNUs of interest and used "show value as a % of column total" to get the breakdowns, then applied those to the 225,000.