HSR_PivotTable.xls - MindTel

Document Sample
HSR_PivotTable.xls - MindTel Powered By Docstoc
					                                       HSR Pivot Tables Menu
1 Number of Active Facilities   1A     by Province     6 Supervisory Visits
  Submitting HSR                1B     by District
                                1C     by Facility

2 Number of Active Hospitals    2A     by Province     7 Services Provided
  Using Incinerator             2B     by District
                                2C     by Facility

3 Active Hospitals Properly     3A                       Number of Active Facilities
  Staffed                              EPHS            8 Using Appropriate IEC
                                       Requirements



4 Availability of Certified Staff 4A   by Province     9 Number of Beds available
                                  4B   by District
                                  4C   by Facility

5 Number of Health Workers      5A     by Province    10 Usable equipment available
  Received Refresher            5B     by District
  Training                      5C     by Facility

                                                      11 Hospital Staff Information
Supervisory Visits            6A    by Province
                              6B    by District
                              6C    by Facility


Services Provided             7A    by Province
                              7B    by District
                              7C    by Facility

Number of Active Facilities   8A
Using Appropriate IEC               by Province
                              8B    by District
                              8C    by Facility

Number of Beds available      9A    by Province
                              9B    by District
                              9C    by Facility

Usable equipment available    10A   by Province
                              10B   by District
                              10C   by Facility

Hospital Staff Information    11A   by Province
                              11B   by District
                              11C   by Facility
MENU                    1A. Number of Active Facilities Submitting HSR - By Province
    Refresh

GrantID         (All)
GrantType       (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
NGO             (All)
Year            (All)

Submitted HSR Quarter
Province
es Submitting HSR - By Province
MENU                             1B. Number of Active Facilities Submitting HSR - By District
    Refresh

GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

Submitted HSR Quarter
District      Q2        Q3       Grand Total
0613 QARABAGH         1      1             2
0614 ANDAR            1      1             2
Grand Total           2      2             4
ubmitting HSR - By District
MENU                                                                     1C. Number of Active Facilities Submittin
   Refresh
GrantID              (All)
GrantType            (All)
NGO                  (All)
Province             (All)
District             (All)
Facility Type        (All)
Year                 (All)

Submitted HSR                                              Quarter
FacilityID           FacilityName                          Q2            Q3         Grand Total
                1511 Gharabagh District Hospital                     1          1             2
                 270 Mawlawi Abdul Zahir Shahed Hospital             1          1             2
C. Number of Active Facilities Submitting HSR - By Facility
MENU                      2A. Number of Active Hospitals Using Incinerator -By Province
    Refresh

GrantID         (All)
GrantType       (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
NGO             (All)
Year            (All)

Incinerator     Quarter
Province
rator -By Province
MENU                               2B. Number of Active Hospitals Using Incinerator -By District
    Refresh


GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

 Incinerator    Quarter
District        Q1        Q2       Q3         Q4       Grand Total
Chahar Asyab            0      1          1        0             2
Qalat                   1      0          0                      1
Maymana                 1      0          1                      2
Chaghcharan             1      1          1                      3
Puli Khumri             1      1          1                      3
Khost(Matun)            1      1          1                      3
Taluqan                 1      1          1                      3
Kunduz                  1      1          1                      3
Darzab                         0          0                      0
Rustaq                         1          1                      2
Qarabagh                       2          2                      4
Farkhar                        1          1                      2
Sholgara                       1                                 1
Aqcha                          1          0                      1
Aybak                          0          0                      0
Muhammad Agha                  0          0                      0
Maydan Shahr                   0          0                      0
Markazi Bihsud                 0          0                      0
Chaki Wardak                   0          0                      0
Saydabad                       0          0                      0
Baraki Barak                   1          0                      1
Andkhoy                        1          1                      2
Andar                          1          1                      2
Jaji                           0          1                      1
Mihtarlam                      0                                 0
Asadabad                       1          1                      2
Dara-I-Suf Bala                0          0                      0
Fayzabad                       1          1                      2
Puli Alam                      0          0                      0
Spin Boldak                    0          0                      0
Qala-I- Naw                    1          1                      2
Shindand                       0          0                      0
Urgoon                         1          1                      2
Sharan                         1          1                      2
Panjab                         1          1                      2
Yakawlang                      0                                 0
Ghazni                         1          1                      2
Zaranj             1     1        2
Shirin Tagab       1     1        2
Ghoryan            0     0        0
Chamkanay                0        0
Gardez                   1        1
Jalalabad                1        1
Chaharikar               1        1
Dashti Qala              1        1
Farah                    1        1
Grand Total    7   24   28   0   59
g Incinerator -By District
MENU                                                                         2C. Number of Active Hospitals Using Inc
   Refresh
GrantID                (All)
GrantType              (All)
NGO                    (All)
Province               (All)
District               (All)
Facility Type          (All)
Year                   (All)

Incinerator                                                    Quarter
FacilityID             FacilityName                            Q1            Q2         Q3       Q4
                   5   Qara Bagh District Hospital                                  1        1
                 682   Khost Hospital                                    1          1        1
                  27   Chahar Asyab District Hospital                    0          1        1        0
                1511   Gharabagh District Hospital                                  1        1
                 270   Mawlawi Abdul Zahir Shahed Hospital                          1        1
                2117   Zabul Provincial Hospital                         1          0        0
                 596   Maimana Civilian Hospital                         1          0        1
                2116   Ghor Provincial Hospital                          1          1        1
                 466   Puli Khumri Molki Provincial Hospital             1          1        1
                 429   Taluqan Central Hospital                          1          1        1
                 519   Kunduz Provincial Hospital                        1          1        1
                 586   Darzab District Hospital                                     0        0
                 449   Rustaq Central District Hospital                             1        1
                 439   Farkhar Center District Hospital                             1        1
                 561   Shulgareh                                                    1
                 590   Aqcha District Hospital                                      1        0
                 530   Aybak                                                        0        0
                 238   S.Safiqullah Ludin District Hospital                         0        0
                  91   Meydan Shaher Hospital                                       0        0
                 202   Tagab Hospital of Bihsub District                            0        0
                 205   Chak Deh Merdad District Hospital                            0        0
                 213   Ghazi Mohd Jan Khan Hospital                                 0        0
                 231   Baraki Rojan 52 Beds Hospital                                1        0
                 608   Shahre Naw                                                   1        1
                 293   Zazi Aryob ( Haji Aryub ) Clinic                             0        1
                 356   laghman Public Health Hospital                               0
                 380   Asadabad                                                     1        1
                 532   Dehi                                                         0        0
                 403   Fayzabad Hospital                                            1        1
                 226   Nayeb Aminullah Khan PH                                      0        0
                 751   Spin Blodak District Hospital                                0        0
                 612   Qala e Naw provincial Hospital                               1        1
                1192   Shindan                                                      0        0
                 836   Urgun Hostpital                                              1        1
                 814   Sharan Central Hospital                                      1        1
                 809   Panjab                                                       1        1
                 805   Shuhada Hospital                                             0
                1100   Ghazni provincial hospital                                   1        1
                 686   Zaranj                                                       1        1
              2018   Shar-Naw CHC+                           1     1
               662   Ghoryan public Health Hospital          0     0
               289   Chamkani                                      0
               278   Gardez Provincial Hospital                    1
              1212   General Hospital of Public Health             1
                61   Charikar PH                                   1
              1162   Sina                                          1
               673   Farah Provincial Hospital                     1
Grand Total                                              7   24   28   0
ctive Hospitals Using Incinerator -By Facility




          Grand Total
                    2
                    3
                    2
                    2
                    2
                    1
                    2
                    3
                    3
                    3
                    3
                    0
                    2
                    2
                    1
                    1
                    0
                    0
                    0
                    0
                    0
                    0
                    1
                    2
                    1
                    0
                    2
                    0
                    2
                    0
                    0
                    2
                    0
                    2
                    2
                    2
                    0
                    2
                    2
 2
 0
 0
 1
 1
 1
 1
 1
59
Menu                          3A. Facility staffing status (meet/not meet) EPHS requ
    Refresh                   (Applicable for 1385 and above)


GrantType                     (All)
GrantID                       (All)
NGO                           (All)
Facility Type                 (All)
Province                      (All)
District                      (All)
Year (select a single year)   (All)

Sum of Match                                       Meet (1=Y,0=N)
FacilityID and Name           Health Workers
/not meet) EPHS requirements
MENU                                4A. Availability of Certified Staff -By Province
    Refresh
GrantID         (All)
GrantType       (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
NGO             (All)
Year            (All)

                        Month ToQ
Province        Data
ed Staff -By Province
MENU                                4B. Availability of Certified Staff -By District
    Refresh
GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                        Month ToQ
District        Data
ed Staff -By District
MENU                                  4C. Availability of Certified Staff -By Facility
   Refresh

GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
District        (All)
Facility Type   (All)
Year            (All)

                                      Month ToQ
FacilityID      FacilityName   Data
vailability of Certified Staff -By Facility
MENU
                                  5A. Number of Health Workers Received Refresher Training -By Prov
  Refresh
GrantID         (All)
GrantType       (All)
NGO             (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                        Quarter
Province        Data
s Received Refresher Training -By Province
MENU
                                  5B. Number of Health Workers Received Refresher Training -By Di
   Refresh
GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                        Quarter
District        Data
Received Refresher Training -By District
MENU
                                      5C. Number of Health Workers Received Refreshe
   Refresh


GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
District        (All)
Facility Type   (All)
Year            (All)

                                      Quarter
FacilityID      FacilityName   Data
er of Health Workers Received Refresher Training -By Facility
MENU
                        6A. Supervisory Visits -By Province
    Refresh

GrantID         (All)
GrantType       (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
NGO             (All)
Year            (All)

                        Quarter
Province        Data
MENU
                        6B. Supervisory Visits -By District
    Refresh


GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                        Quarter
District        Data
MENU
                               6C. Supervisory Visits -By Facility
   Refresh

GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
District        (All)
Facility Type   (All)
Year            (All)

                                      Quarter
FacilityID      FacilityName   Data
Menu                    7A. Service Provided- By Province
     Refresh


GrantID         (All)
GrantType       (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
NGO             (All)
Year            (All)

                        Quarter
Province        Data
Menu                                                  7B. Service Provided- By District

     Refresh

GrantID         (All)
GrantType       (All)
NGOAcro         (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                                                      Quarter
District        Data                                  Q2            Q3       Grand Total
0614 ANDAR       E1. Curative OPD                               1        1             2
                IMCI Implemented                                1        1             2
                ARI Case Management                             1        1             2
                DD Case Management                              1        1             2
                Malaria Case Management                         1        1             2
                Minor Surgery (I and D, Suture)                 1        1             2
                Major Surgery                                   1        1             2
                E2. Routine Grouth Monitoring                   1        1             2
                 Nutrition Rehabilition                         0        1             1
                Child Immunization                              1        1             2
                Management of severely ill child                1        1             2
                E3. TB Detection_Referral                       1        1             2
                TB Lab Diagnosis                                1        1             2
                TB Treatment (Excl DOTS)                        1        0             1
                DOTS                                            1        1             2
                Malaria Lab Diagnosis                           1        1             2
                ITN Distribution                                0        0             0
                HIV/AIDS Diagnosis                              0        0             0
                E4. Antenatal Care                              1        1             2
                TT Immunization                                 1        1             2
                Basic EmOC                                      1        1             2
                Comprehensive EmOC                              1        1             2
                Blood Transfusion                               1        1             2
                Blood Storage                                   0        1             1
                Neonatal resuscitation                          1        1             2
                E5. Oral Contraceptives                         1        1             2
                Injectible Contraceptives                       1        1             2
                IUD                                             1        1             2
                Condoms                                         1        1             2
                Tubal Ligation                                  1        1             2
                Vasectomy                                       1        1             2
                E6. Thorax                                      1        1             2
                Abdomen                                         1        1             2
                Extremities                                     1        1             2
                Ultrasound                                      0        0             0
                E7. Closed Fracture and Dislocation             1        1             2
                Laceration and soft tissues injury              1        1             2
0614 ANDAR      Acute Osteomyelitis                               1   1   2
                Rheumatoid Arthritis                              1   1   2
                Amputation                                        1   1   2
                Burns                                             1   1   2
                Superficial abscesses, cysts and tumors           1   1   2
                E8. Acute Confusion                               1   1   2
                Depression                                        1   1   2
                E9. Obstetric Complication & Birth Preparedness   1   1   2
                Family Planning                                   1   1   2
                 Nutrition                                        1   1   2
                Child Health                                      1   1   2
                Safe injection                                    1   1   2
0613 QARABAGH    E1. Curative OPD                                 1   1   2
                IMCI Implemented                                  1   1   2
                ARI Case Management                               1   1   2
                DD Case Management                                0   1   1
                Malaria Case Management                           1   1   2
                Minor Surgery (I and D, Suture)                   1   1   2
                Major Surgery                                     1   1   2
                E2. Routine Grouth Monitoring                     1   1   2
                 Nutrition Rehabilition                           0   1   1
                Child Immunization                                1   1   2
                Management of severely ill child                  1   1   2
                E3. TB Detection_Referral                         1   1   2
                TB Lab Diagnosis                                  1   1   2
                TB Treatment (Excl DOTS)                          1   1   2
                DOTS                                              1   1   2
                Malaria Lab Diagnosis                             1   1   2
                ITN Distribution                                  0   0   0
                HIV/AIDS Diagnosis                                1   0   1
                E4. Antenatal Care                                1   1   2
                TT Immunization                                   1   1   2
                Basic EmOC                                        1   1   2
                Comprehensive EmOC                                1   1   2
                Blood Transfusion                                 1   1   2
                Blood Storage                                     0   0   0
                Neonatal resuscitation                            1   0   1
                E5. Oral Contraceptives                           1   1   2
                Injectible Contraceptives                         1   1   2
                IUD                                               1   1   2
                Condoms                                           1   1   2
                Tubal Ligation                                    1   1   2
                Vasectomy                                         1   0   1
                E6. Thorax                                        1   1   2
                Abdomen                                           1   1   2
                Extremities                                       1   1   2
                Ultrasound                                        0   0   0
                E7. Closed Fracture and Dislocation               1   1   2
                Laceration and soft tissues injury                1   1   2
                Acute Osteomyelitis                               1   1   2
                Rheumatoid Arthritis                              1   0   1
                Amputation                                        1   1   2
0613 QARABAGH   Burns                                             1   1   2
                Superficial abscesses, cysts and tumors           1   1   2
                E8. Acute Confusion                               1   1   2
                Depression                                        1   1   2
                E9. Obstetric Complication & Birth Preparedness   1   1   2
                Family Planning                                   1   1   2
                Nutrition                                         1   1   2
                Child Health                                      1   1   2
                Safe injection                                    1   1   2
ded- By District
Menu                                                  7C. Service Provided- By Facility

     Refresh

GrantID         (All)
GrantType       (All)
NGOAcro         (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                                                      Quarter
District        Data                                  Q2            Q3       Grand Total
0614 ANDAR       E1. Curative OPD                               1        1             2
                IMCI Implemented                                1        1             2
                ARI Case Management                             1        1             2
                DD Case Management                              1        1             2
                Malaria Case Management                         1        1             2
                Minor Surgery (I and D, Suture)                 1        1             2
                Major Surgery                                   1        1             2
                E2. Routine Grouth Monitoring                   1        1             2
                Nutrition Rehabilition                          0        1             1
                Child Immunization                              1        1             2
                Management of severely ill child                1        1             2
                E3. TB Detection_Referral                       1        1             2
                TB Lab Diagnosis                                1        1             2
                TB Treatment (Excl DOTS)                        1        0             1
                DOTS                                            1        1             2
                Malaria Lab Diagnosis                           1        1             2
                ITN Distribution                                0        0             0
                HIV/AIDS Diagnosis                              0        0             0
                E4. Antenatal Care                              1        1             2
                TT Immunization                                 1        1             2
                Basic EmOC                                      1        1             2
                Comprehensive EmOC                              1        1             2
                Blood Transfusion                               1        1             2
                Blood Storage                                   0        1             1
                Neonatal resuscitation                          1        1             2
                E5. Oral Contraceptives                         1        1             2
                Injectible Contraceptives                       1        1             2
                IUD                                             1        1             2
                Condoms                                         1        1             2
                Tubal Ligation                                  1        1             2
                Vasectomy                                       1        1             2
                E6. Thorax                                      1        1             2
                Abdomen                                         1        1             2
                Extremities                                     1        1             2
                Ultrasound                                      0        0             0
                E7. Closed Fracture and Dislocation             1        1             2
                Laceration and soft tissues injury              1        1             2
0614 ANDAR      Acute Osteomyelitis                               1   1   2
                Rheumatoid Arthritis                              1   1   2
                Amputation                                        1   1   2
                Burns                                             1   1   2
                Superficial abscesses, cysts and tumors           1   1   2
                E8. Acute Confusion                               1   1   2
                Depression                                        1   1   2
                E9. Obstetric Complication & Birth Preparedness   1   1   2
                Family Planning                                   1   1   2
                 Nutrition                                        1   1   2
                Child Health                                      1   1   2
                Safe Injection                                    1   1   2
0613 QARABAGH    E1. Curative OPD                                 1   1   2
                IMCI Implemented                                  1   1   2
                ARI Case Management                               1   1   2
                DD Case Management                                0   1   1
                Malaria Case Management                           1   1   2
                Minor Surgery (I and D, Suture)                   1   1   2
                Major Surgery                                     1   1   2
                E2. Routine Grouth Monitoring                     1   1   2
                Nutrition Rehabilition                            0   1   1
                Child Immunization                                1   1   2
                Management of severely ill child                  1   1   2
                E3. TB Detection_Referral                         1   1   2
                TB Lab Diagnosis                                  1   1   2
                TB Treatment (Excl DOTS)                          1   1   2
                DOTS                                              1   1   2
                Malaria Lab Diagnosis                             1   1   2
                ITN Distribution                                  0   0   0
                HIV/AIDS Diagnosis                                1   0   1
                E4. Antenatal Care                                1   1   2
                TT Immunization                                   1   1   2
                Basic EmOC                                        1   1   2
                Comprehensive EmOC                                1   1   2
                Blood Transfusion                                 1   1   2
                Blood Storage                                     0   0   0
                Neonatal resuscitation                            1   0   1
                E5. Oral Contraceptives                           1   1   2
                Injectible Contraceptives                         1   1   2
                IUD                                               1   1   2
                Condoms                                           1   1   2
                Tubal Ligation                                    1   1   2
                Vasectomy                                         1   0   1
                E6. Thorax                                        1   1   2
                Abdomen                                           1   1   2
                Extremities                                       1   1   2
                Ultrasound                                        0   0   0
                E7. Closed Fracture and Dislocation               1   1   2
                Laceration and soft tissues injury                1   1   2
                Acute Osteomyelitis                               1   1   2
                Rheumatoid Arthritis                              1   0   1
                Amputation                                        1   1   2
0613 QARABAGH   Burns                                             1   1   2
                Superficial abscesses, cysts and tumors           1   1   2
                E8. Acute Confusion                               1   1   2
                Depression                                        1   1   2
                E9. Obstetric Complication & Birth Preparedness   1   1   2
                Family Planning                                   1   1   2
                Nutrition                                         1   1   2
                Child Health                                      1   1   2
                Safe Injection                                    1   1   2
ded- By Facility
MENU
   Refresh
                          8A.Number of Active Facilities Using Appropriate IEC-By Province
GrantID         (All)
GrantType       (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
NGO             (All)
Year            (All)

IEC             Quarter
Provice
Using Appropriate IEC-By Province
MENU
    Refresh
                          8B.Number of Active Facilities Using Appropriate IEC-By District
GrantID         (All)
GrantType       (All)
NGO             (All)
Provice         (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

IEC             Quarter
District
Using Appropriate IEC-By District
MENU
    Refresh
                               8C.Number of Active Facilities Using Appropriate IEC-By Facility

GrantID         (All)
GrantType       (All)
NGO             (All)
Provice         (All)
District        (All)
Facility Type   (All)
Year            (All)

IEC                            Quarter
FacilityID      FacilityName
s Using Appropriate IEC-By Facility
MENU                              9A.Number of Beds- By Province
   Refresh
GrantID         (All)
GrantType       (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
NGO             (All)
Year            (All)

                        Quarter
Province        Data
MENU                              9B.Number of Beds- By District
    Refresh
GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                        Quarter
District        Data
MENU                                            9C.Number of Beds- By Facility
    Refresh


GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
District        (All)
Facility Type   (All)
Year            (All)

                                      Quarter
FacilityID      FacilityName   Data
ber of Beds- By Facility
Menu
                        11A. Hospitals Staff Information - by Province
   Refresh

GrantID         (All)
GrantType       (All)
District        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
NGO             (All)
Year            (All)

                               Quarter
Province        Name    Data
n - by Province
Menu
                        11B. Hospitals Staff Information - by District
    Refresh



GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
FacilityID      (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                               Quarter
District        Name    Data
n - by District
Menu
                        11C. Hospitals Staff Information - by Facility
   Refresh



GrantID         (All)
GrantType       (All)
NGO             (All)
Province        (All)
District        (All)
FacilityName    (All)
Facility Type   (All)
Year            (All)

                               Quarter
FacilityID      Name    Data
n - by Facility

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:7/26/2011
language:English
pages:59