copy pivot
Post on 25-Feb-2018
236 Views
Preview:
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
top related