Get the missed settlement list¶

The missed settlement list is the list of settlements that no team visited, or visited only in part, during a door-to-door campaign. Use it:

  • during the campaign, for example at the end of day 4 of a 5-day round, to plan the mop-up day;

  • after the mop-up day, for the final report and to improve the microplan of the next round.

The list is built from the Geocoverage Indicators export in Excel.

Before you start¶

  • The Tracking Round must have Targeted Areas (see the Targeted Areas tab in the Administrator guide).

  • The settlements must be one of the levels of the results:

    • either the Targeted Areas are the settlements themselves: the list comes from the Targeted Areas sheet;

    • or the Targeted Areas are grid cells or other parts of settlements (see Create a Targeted Areas layer): the settlements must then be uploaded as a base layer and selected as the smallest aggregation level of the Targeted Areas. The Targeted Areas of a grid cannot be exported one by one, so without this level there is no list by settlement.

    In the MDG demo, the Targeted Areas are settlement polygons and the smallest aggregation level is Madagascar Admin 5 - Localities: both the Targeted Areas sheet and the localities sheet can be used.

  • All phones must have uploaded their data: check Teams report. on the map (see Map Indicators and Panels).

Base layers aggregated used in the Targeted Areas tab

Targeted Areas tab of the MDG D2D demo round: Base layers aggregated used ends with Madagascar Admin 5 - Localities, the smallest aggregation level of the exports¶

Build the list¶

  1. Open the map of the Tracking Round, click the download icon and download the Geocoverage Indicators in Excel. If the settlements are the Targeted Areas, keep Export Targeted Areas turned on. See Geocoverage indicators and Targeted Areas.

  2. When the e-mail arrives, download the ZIP file, unzip it and open the .xlsx file of the Geocoverage_indicators folder.

  3. Open the sheet of the settlement level: the sheet named after the settlement base layer, or the last sheet (Targeted Areas). Each row is one settlement.

  4. Turn on the filters: click a cell of the first row, then Data > Filter. An arrow appears in each column title.

  5. Click the arrow of the Visited (%) column and choose Sort Smallest to Largest. The settlements never visited (0) come first, then the settlements partly covered.

  6. Keep the rows at 0 for the settlements never visited. When settlements are divided into grid cells, also keep the rows below a threshold, for example 80, for the settlements only partly covered.

  7. Share the list with the supervisors. The parent columns (for example the commune and fokontany names) help to group the settlements by area for the mop-up teams.

Example: in the MDG D2D - July 2026 Round, the same sort on the fokontany sheet brings up the least covered fokontany of the Analavory commune, Andranomavo (0 of 40 Targeted Areas visited) and Tsarazaza (1 of 45, 2.2 %): their settlements are the first candidates for the mop-up.

Useful columns¶

  • Visited, Targeted Areas and Visited (%): Targeted Areas visited, Targeted Areas in the settlement, and the percentage. For a settlement divided into grid cells, this is the share of its cells reached by a team.

  • Days: days on which the settlement had activity. Empty if it was never visited.

  • Custom indicators, for example the population: the difference between the den column (all Targeted Areas) and the num column (visited Targeted Areas) is the population not reached. Use it to give priority to the largest settlements.

  • N/A in Visited (%): the settlement contains no Targeted Area, so it is not monitored.

All the columns are described in Geocoverage indicators and Targeted Areas.

Tip

The same information is available on the map: open the Areas tab, drill down to the settlement level and sort the list to bring the least covered settlements to the top (see Geo-Coverage Investigation).

Note

  • A settlement in the list had no valid GPS point of a team (or not enough time inside it). Check with the supervisors before sending a mop-up team: the phone may have been off, or the team may have worked without tracking.

  • Get the list by Targeted Area before the Tracking Round is archived, about 30 days after its end date. After archiving, only the final indicators of the aggregation levels are kept.