The target audience are rapid needs assessment teams, who often work under high time pressure. Yet analysts in project monitoring units, evaluators and trainers too may find the tools and process logic useful. Two macro-enabled Excel workbooks (for part 1and part 2) show the train of preparation steps as well as a variety of frequently needed analysis forms.

These notes speak to “one case – one record” data situations, which are typical of most surveys and assessments. For the special challenges that “one case – many records” datasets offer, see an example further down on the same page.”