The Excel file MEASLES SURVEILLANCE (see Toolbox) contains several worksheets, some of them protected, which automatically generate epidemic curves from the data entered.
The file allows summarizing the weekly data for each district and health care facility, in order to detect an outbreak and monitor its progress.
Using the worksheets
- Use one file for each region. Each file includes:
- an automatic summary worksheet for the region;
- an “Epidemic curve for the region” worksheet;
- a “Weekly incidence per district” worksheet;
- fifteen “District” worksheets named from A to O. Do not create new worksheets;
- fifteen “Epidemic curve” worksheets for each of the districts A through O.
- Fill in only the yellow boxes. Do not enter data into other boxes as this may modify the automatic calculations and generate errors.
- When doing the weekly update to the file, change the week number in the file name.
“District” worksheets
- When using for the first time:
- Begin with the “District A” worksheet.
- Enter the name of the region and district, and the year.
- Enter the week number when monitoring began. Subsequent week numbers will display automatically for all of the districts and for the region.
- For each facility, enter its name and the population served. The total population of the district is calculated automatically.
- Enter the name of the district on the tab.
- Each week:
- Enter the number of cases and deaths per facility. Note that if there are no cases, enter “zero” cases. Do not write “zero” cases if there is no data.
- The totals are calculated automatically for each facility and for the district.
- The case fatality rate and the incidence are calculated automatically.
- If the number of cases doubles for two consecutive weeks or the CFR is over 5%, the corresponding cells display in red.
“Epidemic curve per district” worksheets
An epidemic curve is automatically created for each district (A through O).
When using for the first time, enter:
- the name of the district, the name of the region, the country and the year;
- the source of the information;
- the number of inhabitants;
- the name of the district on the tab.
Note that these graphs are created with an automatic scale. To compare curves for different districts, make sure that the scale is the same; change if necessary.
“Region” worksheet
When using for the first time, enter the name of the region on the tab.
This worksheet is completely protected and generated automatically from the sheets for each district.
“Epidemic curve region” worksheet
This curve is created automatically.
When using for the first time, enter:
- the name of the region, the country and the year;
- the source of the information;
- the number of inhabitants;
- the name of the region on the tab.
“Weekly incidence per district” worksheet
These curves are created automatically.
When using for the first time, enter:
- the name of the country and the year;
- the source of the information.