School: GABU NATIONAL HIGH SCHOOL                                 Subject:
School ID:                          300372                      No. Of Item:
   Grade:                                8                             Date:
  Section DIAMOND                                               Type of Test:
 Teacher: KAREN CRIS M. JUAN                                       Purpose:
  No.                        Name               Score z score       MPS
   1     ALMONDIA,ARNEL ALIUZE, NATIVIDAD        16    -0.04      32.00%
   2     ANCHETA,FRANCIS ED, MASIAN              14    -0.57      28.00%
   3     ANCHETA,FRANZ MAR, MASIAN               12    -1.09      24.00%
   4     CONCEPCION,DANILO JR., PIEDAD           12    -1.09      24.00%
   5     FELIX,ERICSON, JR. REALO                16    -0.04      32.00%
   6     JABEL,JOSHUA, MATEO                     18     0.48      36.00%
   7     LABUGUEN,JHON MICHAEL, BADUA            14    -0.57      28.00%
   8     MATEO,TEE JAY, RETAMAL                  12    -1.09      24.00%
   9     MEDINA,MAYNARD, DEL ROSARIO             19     0.74      38.00%
  10     MILAR,DAVE NIÑO, ARQUILLO               21     1.26      42.00%
  11     PASCUAL,XIAN LEE, MATEO                 20     1.00      40.00%
  12     RAMOS,ROMER, OPLE                       12    -1.09      24.00%
  13     RAQUINIO,JAMES HOWEN, MADRIAGA          20     1.00      40.00%
  14     RAQUINIO,LIANDREI RAPHAEL, LIBANTINO    12    -1.09      24.00%
  15     SAMPAYAN,JAKE CARL, RESQUIR             15    -0.30      30.00%
  16     <=== TOTAL MALE                               -4.22       0.00%
  17     AGAG,MICAHELLA EZRA, PERALTA            23     1.78      46.00%
  18     ASUNCION,ISRAELA, SELDA                       -4.22       0.00%
  19     CABINGAS,JAMAICA MARIE, -               12    -1.09      24.00%
  20     CRISOSTOMO,SYDNEY ALYSSA, AGUSTIN       19     0.74      38.00%
  21     GANOTISI,MARICAR, SALVADOR                    -4.22       0.00%
  22     GUNGOB,ANGELYN, ALIVIO                  13    -0.83      26.00%
  23     NAZARENO,MELIZA, COMA                   13    -0.83      26.00%
  24     PALADA,JENELA KAYELENE, TIBUYEN         14    -0.57      28.00%
  25     PASION,SHANEIA JANELLE, CALMA           13    -0.83      26.00%
  26     PEÑARANDA,PRINCESS MAE, MUNDA           21     1.26      42.00%
  27     POBRE,ALTHEA GWEN, ARCONADO             16    -0.04      32.00%
  28     QUITOG,KARINA APRIL, SALVADOR           13    -0.83      26.00%
  29     RAMOS,CHERILYN, OPLE                    12    -1.09      24.00%
  30     RETAMAL,ARIANNE ZOFIA, PATOC            19     0.74      38.00%
  31     ROMOSOD,CZARINA LEI, MOLINA             22     1.52      44.00%
  32     ROMOSOD,HANNAH MAE, REAL                18     0.48      36.00%
  33     SALVADOR,FATE NICOLE, QUITOG            24     2.04      48.00%
       MAPEH
        50
  DIAGNOSTIC TEST
   Mastery Level             Descriptive Analysis                     Results
    Low Mastery                     Mean                               16.17
    Low Mastery            Mean Percentage Score                      32.33%
    Low Mastery               Standard Deviation                        3.83
    Low Mastery            z-score below the mean                        21
    Low Mastery            z-score above the mean                        12
  Average Mastery          MPS Standard (75% & up)                  0 out of 33
    Low Mastery
    Low Mastery                   Interpretation                     Remarks
  Average Mastery               Standard Deviation                    #REF!
  Average Mastery              Mean Percentage Score               Low Mastery
  Average Mastery                                          More group of learners perform
                                    z-score <> the mean
    Low Mastery                                                  BELOW the mean
  Average Mastery                                          0 % of the learners passed the
                           MPS Standard (75% & up)
    Low Mastery                                               MPS National Standard
    Low Mastery
                        DEVELOPED BY: DOMINICK L. DERILO
Absolutely No Mastery
  Average Mastery
Absolutely No Mastery
    Low Mastery
  Average Mastery
Absolutely No Mastery
    Low Mastery
    Low Mastery
    Low Mastery
    Low Mastery
  Average Mastery
    Low Mastery
    Low Mastery
    Low Mastery
  Average Mastery
  Average Mastery
  Average Mastery
  Average Mastery
  School: GABU NATIONAL HIGH SCHOOL                              Subject:
School ID:                          300372                   No. Of Item:
   Grade:                                8                          Date:
  Section MOONSTONE                                          Type of Test:
 Teacher: KAREN CRIS M. JUAN                                    Purpose:
  No.                       Name             Score z score       MPS
   1     AGUILAR,CYRELLE DAVE, JULIAN         17    -0.06      34.00%
   2     AGUSTIN,JEDSEL, ACOB                 11    -2.73      22.00%
   3     BAÑADA,REAGAN, DOMINGO               19     0.83      38.00%
   4     BARANGAY,JAKE, COGAL                 19     0.83      38.00%
   5     CAMPOS,CHAOZ ROD, MARINE             15    -0.95      30.00%
   6     DOMINGO,CHARLES JEMIEL, HERMINIA     13    -1.84      26.00%
   7     EMPEÑO,MARK ANGELO, BARTOLOME              -7.62       0.00%
   8     GASPAR,JAY VINCE CLYDE, MAGDAONG     19     0.83      38.00%
   9     IBAO,JHESS DAN, YALA                 16    -0.51      32.00%
  10     JACINTO,MARK LANCESEI, PASCUAL       20     1.27      40.00%
  11     NAVIA,EL JOHN, TROPEL                17    -0.06      34.00%
  12     POLO,RAIN JUZLHEY, DALLEGO           19     0.83      38.00%
  13     ROSALES,JOHN LUCERO, GONZALES        16    -0.51      32.00%
  14     RUIZ,JARRED JAMES, RAMOS             19     0.83      38.00%
  15     BAJADO,ALYSSA JOY, LACSINA           20     1.27      40.00%
  16     BALINO,RHEA JOY, BARANGAY            18     0.38      36.00%
  17     CARIAGA,NATASHA NICOLE, JIMENEZ      18     0.38      36.00%
  18     CESISTA,FATIMA, TEODORO              15    -0.95      30.00%
  19     ELADIO,SHANTELLE MAE, MAGLAY         17    -0.06      34.00%
  20     GAOIRAN,FRINCESS, DELA CRUZ          18     0.38      36.00%
  21     GERARDO,ERIKA, RAMIREZ               15    -0.95      30.00%
  22     ILORETA,MICAELA JANEA, MANUEL        19     0.83      38.00%
  23     LIBRON,KRISTINE JOY, NIDOY           19     0.83      38.00%
  24     MARANTE,EUANNE JOYCE, HARAMEL        18     0.38      36.00%
  25     PAULINO,TRIZHA MEI, DALERE           18     0.38      36.00%
  26     RAPACON,MAXINE VICTORIA, RAMIREZ     18     0.38      36.00%
  27     ROSALES,DANIELLA JHADE, GAOIRAN      19     0.83      38.00%
  28     SORIA,HANNA EUNICE, JULIAN           15    -0.95      30.00%
  29     TABIL,FERLIE ANGELA, AGCAOILI        17    -0.06      34.00%
  30     TOMAS,JANINE, DOMINGO                      -7.62       0.00%
  31     ZARAGOZA,JENICA, GAOIRAN             13    -1.84      26.00%
       MAPEH
        50
  DIAGNOSTIC TEST
   Mastery Level             Descriptive Analysis                     Results
    Low Mastery                     Mean                               17.14
    Low Mastery            Mean Percentage Score                      34.28%
  Average Mastery             Standard Deviation                        2.25
  Average Mastery          z-score below the mean                        15
    Low Mastery            z-score above the mean                        16
    Low Mastery            MPS Standard (75% & up)                  0 out of 31
Absolutely No Mastery
  Average Mastery                 Interpretation                     Remarks
    Low Mastery                 Standard Deviation                    #REF!
  Average Mastery              Mean Percentage Score               Low Mastery
    Low Mastery                                            More group of learners perform
                                    z-score <> the mean
  Average Mastery                                                ABOVE the mean
    Low Mastery
                           MPS Standard (75% & up)
  Average Mastery
  Average Mastery
                        DEVELOPED BY: DOMINICK L. DERILO
  Average Mastery
  Average Mastery
    Low Mastery
    Low Mastery
  Average Mastery
    Low Mastery
  Average Mastery
  Average Mastery
  Average Mastery
  Average Mastery
  Average Mastery
  Average Mastery
    Low Mastery
    Low Mastery
Absolutely No Mastery
    Low Mastery
  School: GABU NATIONAL HIGH SCHOOL                                     Subject:
School ID:                          300372                          No. Of Item:
   Grade:                                8                                 Date:
  Section PERIDOT                                                   Type of Test:
 Teacher: KAREN CRIS M. JUAN                                           Purpose:
  No.                          Name                 Score z score      MPS
   1     ANCHETA,ALLEN, ESPIRITU                      9    -1.50      18.00%
   2     ANCHETA,MARK JOSEPH, ANAC                   14    -0.44      28.00%
   3     ANCHETA,TAYRON, BACUD                       17     0.20      34.00%
   4     ARQUILLO,DON AMBROCIO LOUISS, DE PERALTA    16    -0.01      32.00%
   5     CORPUZ,JALL WADE, ABAIGAR                   15    -0.23      30.00%
   6     DANCEL,JUMER JR., GABRIEL                   11    -1.08      22.00%
   7     DOMINGO,ZHYRUS RODNEY, MENOR                12    -0.86      24.00%
   8     NAVARRO,JACOB HOWEN, AUREA                  10    -1.29      20.00%
   9     RABANG,JOHN NIÑO, TARAMPI                   22     1.26      44.00%
  10     RABANG,LESTER, RAZA                         10    -1.29      20.00%
  11     RAQUINIO,RAYNIEL, GINES                     25     1.90      50.00%
  12     RETAMAL,CARL JERIELLE, -                    14    -0.44      28.00%
  13     RULLODA,JOHN DAVE, MANADAY                  16    -0.01      32.00%
  14     TIGUIAMO,FREDERICK, RENTEGRADO              13    -0.65      26.00%
  15     ULEP,LORD LEANDRO, YALA                     24     1.69      48.00%
  16     VILLANUEVA,ELIZANDRO WIL, TAPAOAN           15    -0.23      30.00%
  17     ALONZO,HYLEI, MILANDRES                     17     0.20      34.00%
  18     ALONZO,KELYN CLAIRE, AMIT                   13    -0.65      26.00%
  19     ARQUILLO,JIANE KURTNEY, PACAPAC             21     1.05      42.00%
  20     COLIS,KAESHA CHLOE, CASTILLO                17     0.20      34.00%
  21     DELA CRUZ,AKEZIAH ANNE, BARROGA             21     1.05      42.00%
  22     FIGURA,REINE Y'SHA, GUMBAN                  18     0.41      36.00%
  23     GAOIRAN,KIZZY RAIZEL, OBANDO                 7    -1.93      14.00%
  24     GARCIA,THERESA MAE, RAMOLETE                20     0.84      40.00%
  25     LEGASPI,SHAZNA MAE, LACUESTA                21     1.05      42.00%
  26     QUITOG,PRINCESS ANGEL, RACOMA               22     1.26      44.00%
  27     RACOMA,ABIGAIL KATE, SOLIVEN                17     0.20      34.00%
  28     RACOMA,DECEREE JOY, ACOSTA                  21     1.05      42.00%
  29     RACUYA,ELIZABETH, ARQUILLO                  20     0.84      40.00%
  30     RAGASA,ANGEL JOY, -                         10    -1.29      20.00%
  31     REYES,JADE BERNADETTE, RAGUDO               12    -0.86      24.00%
  32     RICAMONTE,MARLYN JOY, BUMANGLAG             14    -0.44      28.00%
    MAPEH
     50
DIAGNOSTIC TEST
 Mastery Level             Descriptive Analysis                  Results
 Low Mastery                      Mean                            16.06
 Low Mastery              Mean Percentage Score                  32.13%
 Low Mastery               Standard Deviation                      4.70
  Low Mastery         z-score below the mean                       17
  Low Mastery         z-score above the mean                       15
  Low Mastery         MPS Standard (75% & up)                  0 out of 32
  Low Mastery
  Low Mastery                Interpretation                     Remarks
Average Mastery            Standard Deviation                    #REF!
  Low Mastery             Mean Percentage Score               Low Mastery
Average Mastery                                       More group of learners perform
                               z-score <> the mean
  Low Mastery                                               BELOW the mean
  Low Mastery                                         0 % of the learners passed the
                      MPS Standard (75% & up)
  Low Mastery                                            MPS National Standard
Average Mastery
                   DEVELOPED BY: DOMINICK L. DERILO
  Low Mastery
  Low Mastery
  Low Mastery
Average Mastery
  Low Mastery
Average Mastery
Average Mastery
Very Low Mastery
Average Mastery
Average Mastery
Average Mastery
  Low Mastery
Average Mastery
Average Mastery
  Low Mastery
  Low Mastery
  Low Mastery
  School: GABU NATIONAL HIGH SCHOOL                              Subject:
School ID:                          300372                   No. Of Item:
   Grade:                                8                          Date:
  Section SAPPHIRE                                           Type of Test:
 Teacher: KAREN CRIS M. JUAN                                    Purpose:
  No.                        Name            Score z score       MPS
   1     ALONZO,CLARK KHEN, UMANGAY           16    -0.38      32.00%
   2     ALONZO,JOHN CHELMER, BALOVAR         14    -1.06      28.00%
   3     CAALIM,JOHN FRANCIS, VALDEZ                -5.82       0.00%
   4     CONCEPCION,NOLI FRED, MORALES        13    -1.40      26.00%
   5     ESTEBAN,ROEDEN KYLE, DOMINGO         16    -0.38      32.00%
   6     FELIX,JOHN MARK, SAMOY               18     0.29      36.00%
   7     GALARPIZ,ANGELO, CASTILLO                  -5.82       0.00%
   8     MITRA,JUSTINE ALEXIS, BALANAY        20     0.97      40.00%
   9     PASCUA,MARK STEVEN, MIGUEL           18     0.29      36.00%
  10     PASION,LAWRENCE, CAYABYAB            14    -1.06      28.00%
  11     PULAYAN,JOHN REYMARK, CLEMENTE       13    -1.40      26.00%
  12     PUYAOAN,SANTINO, TEODORO                   -5.82       0.00%
  13     RACADIO,JOHN ANDREI, RABANG          20     0.97      40.00%
  14     RACADIO,MARC CHESTER, DADIZ          17    -0.05      34.00%
  15     RAMOS,RESTY, BASILIO                 19     0.63      38.00%
  16     SAHAGUN,LOIDE ESTEBAN, LAGMAY        17    -0.05      34.00%
  17     SOLIMAN,RENZ AARON, CASTAÑEDA        16    -0.38      32.00%
  18     TIZON,ALGEN KIRCHZ, AURELIO          19     0.63      38.00%
  19     ULEP,JOHN CARLO, RAGMAC              21     1.31      42.00%
  20     UTLEG,ANGELO, CAALIM                 14    -1.06      28.00%
  21     ABAD,MARY JOY, BILAN                 14    -1.06      28.00%
  22     AGLIPAY,JOYCE, ASUNCION              20     0.97      40.00%
  23     ANCHETA,KRISTHEL MAE, DADIZ          20     0.97      40.00%
  24     ARQUILLO,RISA MAE, ABLITER           14    -1.06      28.00%
  25     BORROMEO,HAILEY DIONNE, ALEGAR       20     0.97      40.00%
  26     BUENA,JENNA MAE, DADIZ               11    -2.08      22.00%
  27     CLEMENTE,DHERICKA FREL, NITURA       23     1.99      46.00%
  28     DIMAYA,KASSANDRA CHARICE, AVERO      19     0.63      38.00%
  29     JUAN,CLOE, DULDULAO                  19     0.63      38.00%
  30     RABANG,ELOIZA MAE, RACADIO           17    -0.05      34.00%
  31     RAMOS,ANGEL, SAYO                    21     1.31      42.00%
  32     RAQUINIO,KRISZA LORAINE, ALVARO      16    -0.38      32.00%
  33     SALVADOR,PRECIOUS ANGEL, LORENZO     15    -0.72      30.00%
       MAPEH
        50
  DIAGNOSTIC TEST
   Mastery Level             Descriptive Analysis                     Results
    Low Mastery                     Mean                               17.13
    Low Mastery            Mean Percentage Score                      34.27%
Absolutely No Mastery         Standard Deviation                        2.94
    Low Mastery            z-score below the mean                        19
    Low Mastery            z-score above the mean                        14
  Average Mastery          MPS Standard (75% & up)                  0 out of 33
Absolutely No Mastery
  Average Mastery                 Interpretation                     Remarks
  Average Mastery               Standard Deviation                    #REF!
    Low Mastery                Mean Percentage Score               Low Mastery
    Low Mastery                                            More group of learners perform
                                    z-score <> the mean
Absolutely No Mastery                                            BELOW the mean
  Average Mastery                                          0 % of the learners passed the
                           MPS Standard (75% & up)
    Low Mastery                                               MPS National Standard
  Average Mastery
                        DEVELOPED BY: DOMINICK L. DERILO
    Low Mastery
    Low Mastery
  Average Mastery
  Average Mastery
    Low Mastery
    Low Mastery
  Average Mastery
  Average Mastery
    Low Mastery
  Average Mastery
    Low Mastery
  Average Mastery
  Average Mastery
  Average Mastery
    Low Mastery
  Average Mastery
    Low Mastery
    Low Mastery
  School:                               Subject:
School ID:                          No. Of Item:
   Grade:                                  Date:
  Section                           Type of Test:
 Teacher:                              Purpose:
  No.        Name   Score z score      MPS
Mastery Level        Descriptive Analysis          Results
                            Mean
                   Mean Percentage Score
                      Standard Deviation
                   z-score below the mean
                   z-score above the mean
                   MPS Standard (75% & up)
                          Interpretation           Remarks
                        Standard Deviation
                       Mean Percentage Score        #N/A
                            z-score <> the mean
                   MPS Standard (75% & up)
                DEVELOPED BY: DOMINICK L. DERILO
  School:                               Subject:
School ID:                          No. Of Item:
   Grade:                                  Date:
  Section                           Type of Test:
 Teacher:                              Purpose:
  No.        Name   Score z score      MPS
Mastery Level        Descriptive Analysis          Results
                            Mean
                   Mean Percentage Score
                      Standard Deviation
                   z-score below the mean
                   z-score above the mean
                   MPS Standard (75% & up)
                          Interpretation           Remarks
                        Standard Deviation
                       Mean Percentage Score        #N/A
                            z-score <> the mean
                   MPS Standard (75% & up)
                DEVELOPED BY: DOMINICK L. DERILO
School Name:                GABU NATIONAL HIGH SCHOOL                Region:               I
School ID:                            300752                         Division:         LAOAG CITY
Grade and Section:                  11 (A, B, C)                     District:             I
Subject (for secondary):               CS 3                          Date:
Teacher:                         APRILYN R. RAMOS                    Purpose:       DIAGNOSTIC TEST
                       SUMMARY OF INTERPRETATION AND ANALYSIS PER SUBJECT AREAS
   Descriptive Analysis    #REF!   #REF!    #REF!   #REF!   #REF!     MAPEH      MAPEH MAPEH     MAPEH     0       0       Average
          Mean             #REF!   #REF!    #REF!   #REF!   #REF!      16.17      17.14  16.06    17.13                     #REF!
 Mean Percentage Score     #REF!   #REF!    #REF!   #REF!   #REF!     32.33%     34.28% 32.13%   34.27%                     #REF!
    Standard Deviation     #REF!   #REF!    #REF!   #REF!   #REF!      3.83       2.25   4.70      2.94                     #REF!
 z-score below the mean    #REF!   #REF!    #REF!   #REF!   #REF!       21         15     17        19                      #REF!
 z-score above the mean    #REF!   #REF!    #REF!   #REF!   #REF!       12         16     15        14                      #REF!
 MPS Standard (75% & up)   #REF!   #REF!    #REF!   #REF!   #REF!        0          0      0         0     0       0        #REF!
                                                                      INTERPRETATION
         Subjects
                             Standard Deviation      Mean Percentage Score      z-score <> the mean       MPS Standard (75% & up)
           #REF!                   #REF!                     #REF!                       #REF!                     #REF!
           #REF!                   #REF!                     #REF!                       #REF!                     #REF!
           #REF!                   #REF!                     #REF!                       #REF!                     #REF!
           #REF!                   #REF!                     #REF!                       #REF!                     #REF!
           #REF!                   #REF!                     #REF!                       #REF!                     #REF!
                               More group of learners   0 % of the learners passed the
MAPEH   #REF!   Low Mastery
                              perform BELOW the mean       MPS National Standard
                               More group of learners
MAPEH   #REF!   Low Mastery
                              perform ABOVE the mean
                               More group of learners   0 % of the learners passed the
MAPEH   #REF!   Low Mastery
                              perform BELOW the mean       MPS National Standard
                               More group of learners   0 % of the learners passed the
MAPEH   #REF!   Low Mastery
                              perform BELOW the mean       MPS National Standard
  0                #N/A
  0                #N/A
 0.00%       4.00%    Absolutely No Mastery                -3
 5.00%      14.00%    Very Low Mastery                     -2
15.00%      34.00%    Low Mastery                          -1
35.00%      65.00%    Average Mastery                       0 Mean
66.00%      85.00%    Moving Towards Mastery                1
86.00%      95.00%    Closely Approximate Mastery           2
96.00%     100.00%    Mastered                              3
   20 sd              REMARKS                                No. of pupils
                 0    Exactly the same                                   20
               1.6    Homogenous Group                                   30
              3.04    Normal Group                                       40
              4.48    Heterogenous Group                                 50
              5.92    Highly Different Group                             60
                                                                         70
   20 sd              REMARKS
                 0    Highly homogenate group
               1.6    Homogenous Group
              3.04    Normal Group
              4.48    Heterogenous Group                     More group of learners perform B
              5.92    Highly heterpgenate rroup              More group of learners perform A
   30 sd              REMARKS                       Sub1             #REF!
                  0   Highly homogenate group                        #REF!
             4.465    Homogenous Group                               #REF!
              5.91    Normal Group
             7.355    Heterogenous Group            Sub2             #REF!
                8.8   Highly heterpgenate rroup                      #REF!
                                                                     #REF!
   40 sd              REMARKS
                  0   Highly homogenate group       Sub3             #REF!
             7.355    Homogenous Group                               #REF!
                8.8   Normal Group                                   #REF!
            10.245    Heterogenous Group
             11.69    Highly heterpgenate rroup     Sub4             #REF!
                                                                     #REF!
   50 sd              REMARKS                                        #REF!
                 0    Highly homogenate group
             10.26    Homogenous Group              Sub5             #REF!
              11.7    Normal Group                                   #REF!
             13.14    Heterogenous Group                             #REF!
             14.58    Highly heterpgenate rroup
                                                    Sub6                 0
60 sd            REMARKS                                  33
             0   Highly homogenate group                0.00
        13.125   Homogenous Group
         14.57   Normal Group                Sub7          0
        16.015   Heterogenous Group                       31
         17.46   Highly heterpgenate rroup              0.00
                                             Sub8          0
                                                          32
                                                        0.00
                                             Sub9          0
                                                          33
                                                        0.00
                                             Sub10         0
                                                           0
                                                     #DIV/0!
                                             Sub11         0
                                                           0
                                                     #DIV/0!
          ave. no.         Max sd               average sd exdsame Homo      hetero
                     #REF!      5.92     2.88          3.04     0.16     1.6      4.48
                     #REF!       8.8     2.89          5.91     3.02  4.465      7.355
                     #REF!    11.69      2.89           8.8     5.91  7.355     10.245
                              14.58      2.88          11.7     8.82  10.26      13.14
                              17.46      2.89         14.57    11.68 13.125     16.015
                              20.35
re group of learners perform BELOW the mean
re group of learners perform ABOVE the mean
          of the learners passed the MPS National Standard
          of the learners passed the MPS National Standard
          of the learners passed the MPS National Standard
          of the learners passed the MPS National Standard
          of the learners passed the MPS National Standard
of the learners passed the MPS National Standard
of the learners passed the MPS National Standard
of the learners passed the MPS National Standard
of the learners passed the MPS National Standard
of the learners passed the MPS National Standard
of the learners passed the MPS National Standard
Compatibility Report for DIAGNOSTIC TEST_MPS.xls
Run on 29/09/2022 13:36
If the workbook is saved in an earlier file format or opened in
an earlier version of Microsoft Excel, the listed features will
not be available.
Significant loss of functionality                                     # of         Version
                                                                  occurrences
One or more functions in this workbook are not available in            24
versions prior to Excel 2007. When recalculated in earlier
versions, these functions will return a #NAME? error instead
of their current results.
                                                                    1'!I8:I10    Excel 97-2003
                                                                     1'!I20
                                                                    2'!I8:I10    Excel 97-2003
                                                                     2'!I20
                                                                    3'!I8:I10    Excel 97-2003
                                                                     3'!I20
                                                                  Sub9'!I8:I10   Excel 97-2003
                                                                    Sub9'!I20
                                                                  Sub10'!I8:I10 Excel 97-2003
                                                                   Sub10'!I20
                                                                  Sub11'!I8:I10 Excel 97-2003
                                                                   Sub11'!I20
Some cells in this workbook use conditional formatting types           6
like data bars, color scales, or icon sets. These formatting
types won't show in earlier versions of Microsoft Excel.
                                                                   1'!E8:E67     Excel 97-2003
                                                                   2'!E8:E67     Excel 97-2003
                                                                   3'!E8:E67     Excel 97-2003
                                                                  Sub9'!E8:E67 Excel 97-2003
                                                                Sub10'!E8:E67 Excel 97-2003
                                                                Sub11'!E8:E67 Excel 97-2003
Some cells contain conditional formatting with the 'Stop if           9
True' option cleared. Earlier versions of Excel do not
recognize this option and will stop after the first true
condition.
                                                                  1'!A8:A67   Excel 97-2003
                                                                  2'!A8:A67   Excel 97-2003
                                                                  3'!A8:A67   Excel 97-2003
                                                                Sub9'!A8:A67 Excel 97-2003
                                                                Sub10'!A8:A67 Excel 97-2003
                                                                Sub11'!A8:A67 Excel 97-2003
                                                                Summary'!B9:M9
                                                                             Excel 97-2003
                                                                Summary'!A19:A29
Minor loss of fidelity
Some cells or styles in this workbook contain formatting that        22       Excel 97-2003
is not supported by the selected file format. These formats
will be converted to the closest format available.