Data Structure Issue (import) - BRHC & KI total/extra values - Githubissues

USAID-OHA-SI / WeekendSpecial

SA weekly data munging

0 stars 1 forks source link

Data Structure Issue (import) - BRHC & KI total/extra values #42

Closed achafetz closed 6 years ago

achafetz commented 6 years ago

Both partners have extra data that need to be resolved

BRHC has totals on a line below the last row. Should be deleted.
BRHC has additional data in the follow ranges on the Proxy TX_NEW tab that needs to be deleted: X540:Z775 & AN73:AN87
KI has an extra row at the bottom with data and a facility. Need to go into each of their tabs and add the partner and districts in columns and B.

To clean:

BRHC
- Direct HTS_TST_ART
- Direct HTS_POS
- IPT initiations
- Proxy TX_NEW
KI
- HTS_TST
- Proxy HTS_POS
- Proxy TX_NEW

achafetz commented 6 years ago

Looks to be resolved