Cleaning a distribution list, calculating kits and planning shelter

• Lines 7 and 15: same ID, same name, same phone, different villages: duplicate. Keep line 7, remove line 15 and check the actual village.
• Lines 11 and 18: same name, same phone, same size, two IDs: probable double registration. Keep line 11, put line 18 on hold and verify by a visit.
• Line 9: size 0, impossible. On hold, check the household composition.
• Line 13: 19 people, outlier (data entry error or polygamous family). On hold; if there are several households, apply the cluster rule on splitting households.
• Line 20: village of Bunia, outside the target area. On hold, check eligibility with the committee.

Validated list: 15 households (lines 1 to 8, 10 to 12, 14, 16, 17, 19), 70 people.

Sizes retained: 5, 3, 7, 2, 6, 4, 8, 1, 5, 6, 3, 4, 9, 2, 5 (15 households, 70 people).

• Tarpaulins: 15 × 2 = 30; jerrycans: 30; kitchen sets: 15.
• Blankets (cap of 6): 5 + 3 + 6 + 2 + 6 + 4 + 6 + 1 + 5 + 6 + 3 + 4 + 6 + 2 + 5 = 64.
• Sleeping mats: 3 + 2 + 4 + 1 + 3 + 2 + 4 + 1 + 3 + 3 + 2 + 2 + 5 + 1 + 3 = 39; nets: 39.

Sphere standard: at least 3.5 m² of covered living space per person. One kit (18 m²) is enough for up to 5 people (5 × 3.5 = 17.5 m²). Households of 6 people or more (6 × 3.5 = 21 m²) need an extension: 330 + 140 = 470 extensions. Kit and extension (30 m²) cover up to 8 people; households of more than 8 people must be assessed case by case.

Tarpaulins: 1,350 × 2 + 470 = 3,170.

Weight: 3,170 × 4.5 = 14,265 kg; fixings 1,350 × 6 = 8,100 kg and 470 × 2 = 940 kg; total 23,305 kg, i.e. 3 trucks of 10 tonnes.

To be added: contingency stock (5 to 10%), local timber compliant with environmental rules, and technical support for households that cannot build on their own (older people, persons with disabilities, women on their own).

Do not let tension rise: a team member (if possible of the same sex as the person) receives complaints at the help desk away from the queue. Calmly explain that the household is not excluded but under verification, for what reason, and when the answer will be given. Record each complaint in the register, with a tracking number. Carry out the verification on site when possible (document, committee, neighbours), otherwise within 72 hours. Keep a small reserve stock to serve households confirmed as eligible without organising a second distribution. Never give in to pressure by adding names without verification, and inform the project manager if there is a security risk.