copy pivot

Author: kaymaggot

Post on 25-Feb-2018

224 views

Category:

Documents


0 download

Embed Size (px)

TRANSCRIPT

  • 7/25/2019 Copy Pivot

    1/17

    Data

    CUSTOMER NAME Min of DIFF 1 Max of DIFF 1_2

    HOSPITAL 0 4

    HOSPITAL KUALA LUMPUR (DRU!

    "an# Tota$ 0 4

  • 7/25/2019 Copy Pivot

    2/17

    A%&"a'& of DIFF 1_ Min of DIFF 2 Max of DIFF 2_2 A%&"a'& of DIFF 2_

    1 0 10 2

    1 0 10 2

  • 7/25/2019 Copy Pivot

    3/17

    Min of DIFF Max of DIFF _2 A%&"a'& of DIFF _

    0 2 0

    0 2 0

  • 7/25/2019 Copy Pivot

    4/17

    CUSTOMER NAME LPO NUMBER CBR NUMBER

    HOSPITAL L0251240701154198 CBR534474

    HOSPITAL L0251240701154293 CBR534124

    HOSPITAL L0251240701154295 CBR534125

    HOSPITAL L0251240701154193 CBR534121

    HOSPITAL L0251240701154294 CBR535411

    HOSPITAL L0251240701154194 CBR534122HOSPITAL L0251240701155735 CBR555757

    HOSPITAL L0251240701155736 CBR555758

    HOSPITAL L0251240701154291 CBR534123

    HOSPITAL L0251240701153430 CBR520887

    HOSPITAL L0251240701153431 CBR520888

    HOSPITAL L0251240701154651 CBR538424

    HOSPITAL L0251240701154656 CBR538425

    HOSPITAL L0251240701154652 CBR538536

    HOSPITAL L0251240701154657 CBR538775

    HOSPITAL L0251240701154653 CBR538774

    HOSPITAL L0251240701154199 CBR536534

    HOSPITAL L0251240701152206 CBR504642

    HOSPITAL L0251240701154296 CBR534475

    HOSPITAL L0251240701155740 CBR549385

    HOSPITAL L0251240701153514 CBR522612

    HOSPITAL L0251240701155092 CBR543218

    HOSPITAL L0251240701152178 CBR503678

    HOSPITAL L0251240701153608 CBR524067

    HOSPITAL L0251240701155491 CBR547485

    HOSPITAL L0251240701155489 CBR547243

    HOSPITAL L0251240701155744 CBR549735

    HOSPITAL L0251240701153513 CBR522135

    HOSPITAL L0251240701154192 CBR532939

    HOSPITAL L0251240701155088 CBR544344

    HOSPITAL L0251240701155089 CBR544943

    HOSPITAL L0251240701153464 CBR522134

    HOSPITAL L0251240701155522 CBR546730

    HOSPITAL L0251240701150459 CBR478495

    HOSPITAL L0251240701153515 CBR522613

    HOSPITAL L0251240701153574 CBR522614

    HOSPITAL L0251240701153740 CBR525793

    HOSPITAL L0251240701150454 CBR477188

    HOSPITAL L0251240701155517 CBR547486

    HOSPITAL L0251240701155547 CBR547487

    HOSPITAL L0251240701151105 CBR486799

    HOSPITAL L0251240701155493 CBR547244

    HOSPITAL L0251240701155741 CBR549148

    HOSPITAL L0251240701153425 CBR520522

    HOSPITAL L0251240701153618 CBR523736

    HOSPITAL L0251240701150439 CBR477190

    HOSPITAL L0251240701151170 CBR486611

  • 7/25/2019 Copy Pivot

    5/17

    HOSPITAL L0251240701155520 CBR547981

    HOSPITAL L0251240701155737 CBR548860

    HOSPITAL L0251240701154650 CBR538013

    HOSPITAL L0251240701155739 CBR549734

    HOSPITAL L0251240701155519 CBR547742

    HOSPITAL L0251240701155742 CBR549462

    HOSPITAL L0251240701150458 CBR477685HOSPITAL L0251240701155490 CBR547980

    HOSPITAL L0251240701155738 CBR549733

    HOSPITAL L0251240701155521 CBR547982

    HOSPITAL L0251240701154658 CBR539282

    HOSPITAL L0251240701155096 CBR544950

    HOSPITAL L0251240701153581 CBR523029

    HOSPITAL L0251240701155098 CBR544951

    HOSPITAL L0251240701154655 CBR539281

    HOSPITAL L0251240701154659 CBR539283

    HOSPITAL L0251240701152205 CBR503679

    HOSPITAL L0251240701151102 CBR486523

    HOSPITAL L0251240701152248 CBR503680

    HOSPITAL L0251240701152166 CBR503677

    HOSPITAL L0251240701153429 CBR520646

    HOSPITAL L0251240701154660 CBR538015

    HOSPITAL L0251240701150444 CBR477686

    HOSPITAL L0251240701151164 CBR487364

    HOSPITAL L0251240701155094 CBR544946

    HOSPITAL L0251240701155093 CBR544945

    HOSPITAL L0251240701150402 CBR476035

    HOSPITAL L0251240701155095 CBR544947

    HOSPITAL L0251240701150403 CBR476036

    HOSPITAL L0251240701150404 CBR476037

    HOSPITAL L0251240701155090 CBR544944

    HOSPITAL L0251240701151165 CBR487365

    HOSPITAL L0251240701151167 CBR487367

    HOSPITAL L0251240701150438 CBR477189

    HOSPITAL L0251240701151166 CBR487366

    HOSPITAL L0251240701151169 CBR487368

    HOSPITAL L0251240701152224 CBR503685

    HOSPITAL L0251240701150453 CBR478099

    HOSPITAL L0251240701155743 CBR555759

    HOSPITAL L0251240701151060 CBR488343

    HOSPITAL L0251240701152239 CBR505324

    HOSPITAL L0251240701152247 CBR505325

    HOSPITAL L0251240701155091 CBR545786

    HOSPITAL L0251240701152240 CBR504505

    HOSPITAL L0251240701151168 CBR486801

    HOSPITAL L0251240701152229 CBR505323

  • 7/25/2019 Copy Pivot

    6/17

  • 7/25/2019 Copy Pivot

    7/17

    CBR CREATIONSERAH DO DAT DIFF 1 e-GRN DATE DIFF 2

    23-Se-15 28-Se-15 2 28-Se-15 0

    22-Se-15 28-Se-15 3 28-Se-15 0

    22-Se-15 28-Se-15 3 28-Se-15 0

    22-Se-15 28-Se-15 3 28-Se-15 0

    29-Se-15 29-Se-15 0 29-Se-15 0

    22-Se-15 28-Se-15 3 28-Se-15 030-N!"-15 1-De#-15 1 1-De#-15 0

    30-N!"-15 1-De#-15 1 1-De#-15 0

    22-Se-15 28-Se-15 3 28-Se-15 0

    5-A$%-15 5-A$%-15 0 5-A$%-15 0

    5-A$%-15 5-A$%-15 0 5-A$%-15 0

    8-O#&-15 12-O#&-15 2 12-O#&-15 0

    8-O#&-15 12-O#&-15 2 12-O#&-15 0

    8-O#&-15 12-O#&-15 2 12-O#&-15 0

    8-O#&-15 12-O#&-15 2 12-O#&-15 0

    8-O#&-15 12-O#&-15 2 12-O#&-15 0

    2-O#&-15 2-O#&-15 0 5-O#&-15 1

    30-M'(-15 27-M'(-15 4 28-M'(-15 1

    23-Se-15 29-Se-15 3 30-Se-15 1

    11-N!"-15 12-N!"-15 1 13-N!"-15 1

    12-A$%-15 12-A$%-15 0 13-A$%-15 1

    22-O#&-15 23-O#&-15 1 26-O#&-15 1

    27-M'(-15 27-M'(-15 0 28-M'(-15 1

    17-A$%-15 18-A$%-15 1 19-A$%-15 1

    4-N!"-15 5-N!"-15 1 6-N!"-15 1

    4-N!"-15 5-N!"-15 1 6-N!"-15 1

    12-N!"-15 13-N!"-15 1 16-N!"-15 1

    11-A$%-15 11-A$%-15 0 12-A$%-15 1

    17-Se-15 18-Se-15 1 21-Se-15 1

    26-O#&-15 27-O#&-15 1 28-O#&-15 1

    29-O#&-15 29-O#&-15 0 30-O#&-15 1

    11-A$%-15 11-A$%-15 0 12-A$%-15 1

    2-N!"-15 3-N!"-15 1 4-N!"-15 1

    12-Fe)-15 13-Fe)-15 1 16-Fe)-15 1

    12-A$%-15 12-A$%-15 0 13-A$%-15 1

    12-A$%-15 12-A$%-15 0 13-A$%-15 1

    21-A$%-15 21-A$%-15 0 24-A$%-15 1

    9-Fe)-15 10-Fe)-15 1 11-Fe)-15 1

    4-N!"-15 5-N!"-15 1 6-N!"-15 1

    4-N!"-15 5-N!"-15 1 6-N!"-15 1

    19-M'*-15 23-M'*-15 2 24-M'*-15 1

    4-N!"-15 5-N!"-15 1 6-N!"-15 1

    11-N!"-15 12-N!"-15 1 13-N!"-15 1

    4-A$%-15 4-A$%-15 0 5-A$%-15 1

    15-A$%-15 17-A$%-15 0 18-A$%-15 1

    9-Fe)-15 10-Fe)-15 1 11-Fe)-15 1

    19-M'*-15 23-M'*-15 2 24-M'*-15 1

  • 7/25/2019 Copy Pivot

    8/17

    5-N!"-15 6-N!"-15 1 11-N!"-15 2

    10-N!"-15 11-N!"-15 0 13-N!"-15 2

    7-O#&-15 7-O#&-15 0 9-O#&-15 2

    12-N!"-15 13-N!"-15 1 17-N!"-15 2

    5-N!"-15 6-N!"-15 1 11-N!"-15 2

    12-N!"-15 13-N!"-15 1 17-N!"-15 2

    10-Fe)-15 12-Fe)-15 2 16-Fe)-15 25-N!"-15 6-N!"-15 1 11-N!"-15 2

    12-N!"-15 13-N!"-15 1 17-N!"-15 2

    5-N!"-15 6-N!"-15 1 11-N!"-15 2

    11-O#&-15 12-O#&-15 0 15-O#&-15 2

    29-O#&-15 29-O#&-15 0 2-N!"-15 2

    12-A$%-15 13-A$%-15 1 17-A$%-15 2

    29-O#&-15 29-O#&-15 0 2-N!"-15 2

    11-O#&-15 12-O#&-15 0 15-O#&-15 2

    11-O#&-15 12-O#&-15 0 15-O#&-15 2

    27-M'(-15 27-M'(-15 0 1-+$,-15 3

    18-M'*-15 19-M'*-15 1 24-M'*-15 3

    27-M'(-15 27-M'(-15 0 1-+$,-15 3

    27-M'(-15 27-M'(-15 0 1-+$,-15 3

    4-A$%-15 5-A$%-15 1 10-A$%-15 3

    7-O#&-15 7-O#&-15 0 12-O#&-15 3

    10-Fe)-15 11-Fe)-15 1 16-Fe)-15 3

    22-M'*-15 25-M'*-15 2 30-M'*-15 3

    29-O#&-15 29-O#&-15 0 4-N!"-15 4

    29-O#&-15 29-O#&-15 0 4-N!"-15 4

    4-Fe)-15 5-Fe)-15 1 11-Fe)-15 4

    29-O#&-15 29-O#&-15 0 4-N!"-15 4

    4-Fe)-15 5-Fe)-15 1 11-Fe)-15 4

    4-Fe)-15 5-Fe)-15 1 11-Fe)-15 4

    29-O#&-15 29-O#&-15 0 4-N!"-15 4

    22-M'*-15 25-M'*-15 2 31-M'*-15 4

    22-M'*-15 25-M'*-15 2 31-M'*-15 4

    9-Fe)-15 10-Fe)-15 1 16-Fe)-15 4

    22-M'*-15 25-M'*-15 2 31-M'*-15 4

    22-M'*-15 25-M'*-15 2 31-M'*-15 4

    27-M'(-15 27-M'(-15 0 2-+$,-15 4

    11-Fe)-15 12-Fe)-15 1 23-Fe)-15 5

    30-N!"-15 1-De#-15 1 8-De#-15 5

    25-M'*-15 25-M'*-15 0 1-A*-15 5

    2-+$,-15 2-+$,-15 0 9-+$,-15 5

    2-+$,-15 2-+$,-15 0 9-+$,-15 5

    30-O#&-15 3-N!"-15 2 12-N!"-15 6

    29-M'(-15 29-M'(-15 0 9-+$,-15 7

    19-M'*-15 23-M'*-15 2 2-A*-15 8

    2-+$,-15 2-+$,-15 0 16-+$,-15 10

  • 7/25/2019 Copy Pivot

    9/17

    PERCENTAGE

    TOTAL LPO 93

    3 DAS 71 76. MIN

    4 DAS 84 90. MA/

    5 DAS 89 96. AERAGE6 DAS 90 97.

    7 DAS 91 98.

  • 7/25/2019 Copy Pivot

    10/17

    RAH INOICE D DIFF 3 CTUAL RC DAT REMARS

    28-Se-15 0 23-Se-15

    28-Se-15 0 22-Se-15

    28-Se-15 0 22-Se-15

    28-Se-15 0 22-Se-15

    30-Se-15 1 29-Se-15

    28-Se-15 0 22-Se-151-De#-15 0 30-N!"-15

    1-De#-15 0 30-N!"-15

    28-Se-15 0 22-Se-15

    5-A$%-15 0 5-A$%-15

    5-A$%-15 0 5-A$%-15

    13-O#&-15 1 8-O#&-15

    13-O#&-15 1 8-O#&-15

    13-O#&-15 1 8-O#&-15

    13-O#&-15 1 9-O#&-15

    13-O#&-15 1 9-O#&-15

    5-O#&-15 0

    1-+$,-15 2

    30-Se-15 0

    16-N!"-15 1 12-N!"-15

    13-A$%-15 0 12-A$%-15

    27-O#&-15 1 23-O#&-15

    28-M'(-15 0 27-M'(-15

    19-A$%-15 0 17-A$%-15

    9-N!"-15 1 5-N!"-15

    9-N!"-15 1 4-N!"-15

    16-N!"-15 0 13-N!"-15

    12-A$%-15 0 11-A$%-15

    21-Se-15 0 18-Se-15

    28-O#&-15 0 27-O#&-15

    2-N!"-15 1 28-O#&-15

    12-A$%-15 0 11-A$%-15

    5-N!"-15 1 3-N!"-15

    16-Fe)-15 0 13-Fe)-15

    13-A$%-15 0 12-A$%-15

    13-A$%-15 0 12-A$%-15

    25-A$%-15 1 21-A$%-15

    11-Fe)-15 0 10-Fe)-15

    9-N!"-15 1 5-N!"-15

    9-N!"-15 1 5-N!"-15

    24-M'*-15 0 20-M'*-15

    9-N!"-15 1 4-N!"-15

    16-N!"-15 1 12-N!"-15

    5-A$%-15 0 4-A$%-15

    18-A$%-15 0 17-A$%-15

    11-Fe)-15 0 10-Fe)-15

    24-M'*-15 0 19-M'*-15

  • 7/25/2019 Copy Pivot

    11/17

    11-N!"-15 0 6-N!"-15

    16-N!"-15 1 11-N!"-15

    12-O#&-15 1 7-O#&-15

    17-N!"-15 0 13-N!"-15

    11-N!"-15 0 5-N!"-15

    17-N!"-15 0 12-N!"-15

    16-Fe)-15 0 11-Fe)-1511-N!"-15 0 6-N!"-15

    17-N!"-15 0 13-N!"-15

    11-N!"-15 0 6-N!"-15

    19-O#&-15 2 12-O#&-15

    2-N!"-15 0 28-O#&-15

    17-A$%-15 0 13-A$%-15

    2-N!"-15 0 28-O#&-15

    19-O#&-15 2 12-O#&-15

    19-O#&-15 2 12-O#&-15

    1-+$,-15 0 27-M'(-15

    24-M'*-15 0 19-M'*-15

    1-+$,-15 0 27-M'(-15

    1-+$,-15 0 26-M'(-15

    10-A$%-15 0 4-A$%-15

    13-O#&-15 1 7-O#&-15

    16-Fe)-15 0 11-Fe)-15

    30-M'*-15 0 23-M'*-15

    4-N!"-15 0 29-O#&-15

    4-N!"-15 0 29-O#&-15

    11-Fe)-15 0 5-Fe)-15

    4-N!"-15 0 29-O#&-15

    11-Fe)-15 0 5-Fe)-15

    11-Fe)-15 0 5-Fe)-15

    4-N!"-15 0 29-O#&-15

    31-M'*-15 0 23-M'*-15

    31-M'*-15 0 23-M'*-15

    16-Fe)-15 0 10-Fe)-15

    31-M'*-15 0 23-M'*-15

    31-M'*-15 0 23-M'*-15

    2-+$,-15 0 27-M'(-15

    23-Fe)-15 0

    8-De#-15 0 7-De#-15

    1-A*-15 0 25-M'*-15

    9-+$,-15 0 2-+$,-15

    9-+$,-15 0 1-+$,-15

    16-N!"-15 2 30-O#&-15

    9-+$,-15 0 29-M'(-15

    2-A*-15 0 20-M'*-15

    16-+$,-15 0 1-+$,-15

  • 7/25/2019 Copy Pivot

    12/17

    0

    10

    2

  • 7/25/2019 Copy Pivot

    13/17

    D'&e H!'( '*e!$e Re'* S&'&e

    1)*an)1+ ,R NE- .EAR SELANOR

    )*an)1+ ,R MAULIDUR RASUL SELANOR

    )F&/)1+ ,R THAIPUSAM SELANOR

    1)F&/)1+ ,R CHINESE NE- .EAR SELANOR

    20)F&/)1+ ,R CHINESE NE- .EAR (2ND DA.! SELANOR

    1)Ma)1+ ,R LA,OUR DA. SELANOR)Ma)1+ ,R ESAK DA. SELANOR

    3)*n)1+ ,R AON5S ,IRTHDA. SELANOR

    4)*$)1+ ,R NU6UL AL)7URAN SELANOR

    13)*$)1+ ,R HARI RA.A PUASA SELANOR

    18)*$)1+ ,R HARI RA.A PUASA SELANOR

    19)*$)1+ ,R HARI RA.A PUASA SELANOR

    20)*$)1+ ,R HARI RA.A PUASA SELANOR

    21)*$)1+ ,R HARI RA.A PUASA SELANOR

    1)A')1+ ,R NATIONAL DA. SELANOR

    13)S&:)1+ ,R MALA.SIA DA. SELANOR24)S&:)1+ ,R HARI RA.A HA*I SELANOR

    14)O;t)1+ ,R A-AL MUHARRAM (MAAL HI*RAH! SELANOR

    10)No%)1+ ,R DEEPAALI SELANOR

  • 7/25/2019 Copy Pivot

    14/17

    D'&e H!'( '*e!$e Re'*

    1)*an)1+ ,R NE- .EAR

    )*an)1+ ,R MAULIDUR RASUL

    1)F&/)1+ ,R FEDERAL TERRITOR. DA.

    )F&/)1+ ,R THAIPUSAM

    1)F&/)1+ ,R CHINESE NE- .EAR

    20)F&/)1+ ,R CHINESE NE- .EAR (2ND DA.!1)Ma)1+ ,R LA,OUR DA.

    )Ma)1+ ,R ESAK DA.

    3)*n)1+ ,R AON5S ,IRTHDA.

    18)*$)1+ ,R HARI RA.A PUASA

    19)*$)1+ ,R HARI RA.A PUASA

    1)A')1+ ,R NATIONAL DA.

    13)S&:)1+ ,R MALA.SIA DA.

    24)S&:)1+ ,R HARI RA.A HA*I

    14)O;t)1+ ,R A-AL MUHARRAM (MAAL HI*RAH!

    10)No%)1+ ,R DEEPAALI

  • 7/25/2019 Copy Pivot

    15/17

    S&'&e

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN-ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

    -ILA.AH PERSEKUTUAN

  • 7/25/2019 Copy Pivot

    16/17

    PEMANTAUAN PRESTASI SERAH DO:EGRN DAN SERAH INOIS BAGI IL

    NO PT+ BIL= LPO

    MINIMA MASIMA PURATA MINIMA MASIMA1 HOSPITAL 93 0 4 1 0 10

    BILANGAN HARI PLSB UNTUSERAH DO

    BILANGAN HARIMENGESAHAN PEN

    DI E ;eGRN

  • 7/25/2019 Copy Pivot

    17/17

    AH PERSEUTUAN UALA LUMPUR ;HL< +AN-NO 2015

    PURATA MINIMA MASIMA PURATA2 76. 0 2 0

    PT+RIMAAN

    ' ? e )'@'

    BILANGAN HARI PLSB SERAHINOICE