Docstoc

Threshold

Document Sample
Threshold Powered By Docstoc
					                                       Data entry sheet - epidemic threshold calculation based on 5 years' monthly data
                                                                                                         ic      ent
                                         modified from WHO template of the Field Guide for Malaria Epidem Assessm and Reporting, WHO/HTM/MAL/2004.1097

              This excel sheet is set up to do calculations automatically. Enter data in the w hite cells. Do NOT change the grey cells.
STEP 1: Enter 5 years' data by month in the white cells, making sure to exclude epidemic years. Mark missing data as "NA", do not leave cells blank
                  Dec copied        JAN         FEB         MAR         APR        MAY         JUN        JUL         AUG       SEP          OCT         NOV    DEC   Jan copied
  year 1                  6          5          2            5           1          5           5         10           2        10            2           3      6         5
  year 2                  1          1          3            4           5          2           2          2           2         1            1           2      1         1
  year 3                  4          3          8            3          10          1          10          8           8         8            5           1      4         3
  year 4                  1          3          3            3           4          4           2          2           7         1            7           7      1         3
  year 5                  4          1          1            1           1          1           1          1           1         4            4           4      4         1

STEP 2: View current year figures? Add data in the white cells below.
                         JAN        FEB        MAR         APR        MAY               JUN        JUL       AUG         SEP       OCT        NOV        DEC
  Current year              10        10         15           15       18                 8          8         5           2         1          1          1

STEP 3: View the threshold graph.




                                                        Automatic calculation section. Do NOT change the grey cells.

Automatic calculations
  sum                  16                   13         17         16         21         13         20        23         20         24         19         17     16        13
  mean (month)                               3          3          3          4          3          4         5          4          5          4          3      3
  SD                                         2          3          1          4          2          4         4          3          4          2          2      2
  mean+3SD                                   8         12          8         15          8         15        17         14         17         11         10     10
  mean+2SD                                   6          9          6         12          6         11        13         10         13          9          8      8
   MEAN (trimestral or C-SUM method)         3          3          4          3          4          4         4          4          4          4          3      3
   SD MEAN                                   2          2          3          2          3          3         3          4          3          3          2      2
   MEAN+1.96SD                               7          7          9          8         10         10        11         11         10         10          8      7

Automatic threshold overview: graph with thresholds appears in sheet "threshold graph"
                           JAN         FEB       MAR     APR         MAY        JUN                JUL       AUG         SEP       OCT        NOV        DEC
                              3           3
  mean cases (previous, next and current months)    4        3          4          4                 4          4          4          4          3          3
  alert threshold             6           9         6      12           6         11                13         10         13          9          8          8
  alarm threshold             8          12         8      15           8         15                17         14         17         11         10         10
  threshold C-SUM method 7                7         9        8         10         10                11         11         10         10          8          7
  Cases in the current year 10           10        15      15          18          8                 8          5          2          1          1          1
                     Threshold graph using the mean+2SD method

20


18


16


14


12
                                                                           alert threshold


10

                                                                           mean cases
 8                                                                         (previous, next
                                                                           and current
                                                                           months)

 6                                                                         Cases in the
                                                                           current year


 4


 2


 0
     1   2   3   4    5       6      7       8      9      10    11   12
                          Threshold graph (2SD, 3SD and C-SUM methods)

20


18


16                                                                                   alarm threshold


14

                                                                                     alert threshold
12


10
                                                                                     mean cases
                                                                                     (previous, next and
 8                                                                                   current months)


 6                                                                                   threshold C-SUM
                                                                                     method

 4

                                                                                     Cases in the current
 2                                                                                   year


 0
  JAN   FEB   MAR   APR   MAY   JUN      JUL    AUG     SEP     OCT      NOV   DEC

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:14
posted:9/20/2012
language:Unknown
pages:4