Key populations dashboard (Excel): Update Excel dashboard using MER structured dataset.

[wvp3]

Proposed due date: 11/16/2018

[wvp3]

See archived RStudio code for this dashboard here: https://github.com/ICPI/Prevention-Cluster/tree/master/KP%20Dashboard

[wvp3]

The update is now available at: https://www.pepfar.net/OGAC-HQ/icpi/Products/ICPI%20Approved%20Tools%20(Most%20Current%20Versions)/Key%20Populations%20Dashboard/DRAFT%20for%20QC_ICPI_KP%20Tool_FY18Q4_initial_v2_11-16-2018.xlsx

And is in need of QC review

[vanamala-narasimhan]

QC Complete for Initial 2018Q4 release

[wvp3]

Uploaded and approved in PEPFAR Sharepoint. To be included in 11/21/2018 huddle

[wvp3]

Updated for FY2019Q1 clean on SharePoint Products / Tools (most recent versions) / KP dashboard; needs QC.

[vanamala-narasimhan]

Key Populations Tool 2.0 Task List for Q3 Release

• [ ] Rewrite R code for new MSD format, Genie (by Jul 19th)
• [ ] Incorporate Q3 format and KP Group code changes (by Jul 19th)
• [ ] Create Q3 Tool Template for population (by Jul 19th)
• [ ] Test out new code on Q3 test dataset for Genie (after Aug 15th)
• [ ] Test out new code on Q3 test MSD (after Aug 15th, use pano testing MSD?)
• [ ] Populate tool with Q3 Initial data (August 15th, data entry closes)

[vanamala-narasimhan]

Most updated R code for MER transformation workingRcodeKPToolQ4.txt

[vanamala-narasimhan]

Most updated R code for MER transformation as of FY20 Q1

workingRcodeKPToolFY20Q1.txt

[vanamala-narasimhan]

Handover of Key Pop tool to @LaChandraS and HSS/KP Cluster. Updated R code is posted above, attached is the guide for updating the tool. The ICPI Key Populations Tool Quarterly Update Guide.pptx