Upload a CES survey xlsx and generate the standard report. The file never leaves your browser.
1 Epidemiologic coverage = the proportion of individuals in the
survey area who swallowed the medicine, or combination of medicines, out of the
total population in the survey area, regardless of eligibility for treatment.
2 Therapeutic coverage = the proportion of individuals in the
survey area who swallowed the medicine, or combination of medicines, out of the population of
people who were eligible to receive treatment.
Need the format? Download the data template (.xlsx)
— an ESPEN-format workbook (sheet data) with every expected column, an example row,
and a data dictionary. Then upload your completed file below.
Data must use the ESPEN p_* column schema on a sheet named data.
Only five columns are strictly required; the rest are optional but each one
it fills adds a section to the report. Replace ivm with alb or
pzq to match the drug you select above.
| Column | Req? | Type | Allowed / expected values |
|---|---|---|---|
p_district | Yes | text | Any label — one report row per district / implementation unit |
p_site | Yes | text | Any label — cluster / village |
p_sex | Yes | text | Male, Female |
p_age | Yes | integer | Age in years |
p_swalllowed_ivm | Yes | text | yes, no (note ESPEN triple-l spelling) |
p_received_ivm | No | text | yes, no — needed for therapeutic coverage & the treatment pathway |
p_nt_swallowed_ivm | No | text | never, once, twice or more — drives the never-treated section |
p_respondent | No | text | Himself, For_child_present, For_child_absent, For_Absent adult |
p_reason_not_swallowed_ivm | No | text (multi) | Fear.side.effects, Minor.elderly, Pregnancy.breastfeed, Lack.of.trust, Absent, Refused |
p_mda_location | No | text | House, Fixed.post, School |
p_side_effect | No | text | yes, no |
p_heard_ivm_camp | No | text | yes, no |
p_info_chanel | No | text (multi) | Community.leader, Family, Health.worker, Town.crier, Radio, School, Poster, CDD (note ESPEN spelling "chanel") |
p_satisfied | No | text | yes, no, do not know |
See the Data dictionary sheet in the template for the complete column list, including the ALB and PZQ variants.
Enter the administratively-reported coverage (%) for every district/IU so the report can validate it against the survey results. Upload your data file above — districts are detected automatically. A value is required for each district before you can generate the report.
Waiting for data file…
The browser's print dialog will open. Pick "Save as PDF" as the destination to produce the PDF report.