Excel For PC
Excel For PC
NO MONTH
N : Number of red cell units cross- D : Number of red cell units C.T Ratio
matched transfused
1 Jan 423 301 1.41
2 Feb 434 369 1.18
3 Mar 342 265 1.29
4 Apr 327 247 1.32
5 May 368 293 1.26
6 Jun 404 311 1.30
7 Jul 422 310 1.36
8 Aug 467 332 1.41
9 Sep 476 401 1.19
10 Oct 458 403 1.14
11 Nov 404 368 1.10
12 Dec 485 432 1.12
TOTAL 5010 4032 1.24
≤
C.T RATIO
1.41
1.18
1.29 1.41 1
1.36
1.32 1.32
1.29 1.30 467
1.26 1.26
434 1.18
1.30 423 422
404
1.36
1.41 369 368
342
1.19 327 3
311 310
1.14 301 293
1.10 265
1.12 247
1.24
600
1.41
1.29 1.32 1.
500 1.26
1.18
100
0
Jan Feb Mar Apr May Ju
1.41 1.40
1.36
485
476
467
458
1.19 432 1.20
2
1.14 1.12
401 403 404 1.10
368 1.00
332
310
0.80
0.60
0.40
0.20
0.00
Jul Aug Sep Oct Nov Dec
1.60
1.41
1.36
1.30 1.40
6
1.19 4851.12
467 476 1.14 1.10 1.20
458
422 432
404 401 403 404 1.00
1.60
1.41
1.36
1.30 1.40
6
1.19 4851.12
467 476 1.14 1.10 1.20
458
422 432
404 401 403 404 1.00
368
332 0.80
311 310
293
0.60
0.40
0.20
0.00
y Jun Jul Aug Sep Oct Nov Dec
1.40
1.20
32
1.00
1.60
1.40
1.20
32
1.00
0.80
0.60
0.40
0.20
0.00
HOSPITAL PERFORMANCE INDICATORS FOR ACCOUNTABILITY (HPIA)
NO MONTH
N : Number of red cell units cross- D : Number of red cell units C.T Ratio
matched transfused
1 Jan-21 445 398 1.12
2 Feb-21 378 344 1.10
3 Mar-21 435 397 1.10
4 Apr-21 410 374 1.10
5 May-21 414 376 1.10
6 Jun-21 432 374 1.16
7 Jul-21 428 381 1.12
8 Aug-21 373 322 1.16
9 Sep-21 447 357 1.25
10 Oct-21 490 389 1.26
11 Nov-21 446 367 1.22
12 Dec-21 522 446 1.17
TOTAL 5220 4525 1.15
445
435 432 428
410 414
398 397
378 374 376 374 381
373
344
32
1.30
522
490 1.25
389 1.20
381
373 367
357
322
1.15
1.10
1.05
1.00
44378 44409 44440 44470 44501 44531
≤
1.23
1.22
1.20
1.20
1.15
C.T Ratio
Jan -
Period Jan-22 Feb-22 Mar-22 Apr-22 May-22
Mar
N : Number of red
cell units cross- 475 437 416 1328 482 504
matched
D : Number of red
cell units 395 355 341 1091 418 421
transfused
CT Ratio 1.20 1.23 1.22 1.22 1.15 1.20
1.17
1.15
1.14
Jun-22 Apr - Jun Jan-Jun Jul-22 Aug-22 Sep-22 Jul-Aug Oct-22 Nov-22 Dec-22 Oct-Dec
653 1639 2967 528 465 477 1470 450 517 534 1501
566 1405 2496 465 396 385 1246 363 419 458 1240
1.15 1.17 1.19 1.14 1.17 1.24 1.18 1.24 1.23 1.17 1.21
Jul-Dec
2971
2486
1.20
Service Standard 16 : Blood Transfusion Services
Performance Indicator : Crossmatch to transfusion ratio (C:T ratio)
Target : ≤ 2.0
600 1.60
300 0.80
0.60
200
0.40
100
0.20
0 0.00
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Period Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
No red cell crossmatch 423 434 342 327 368 404 422 467 476 458 404 485
(Numerator)
No. of red cell transfused 301 369 265 247 293 311 310 332 401 403 368 432
(Denominator)
C:T RATIO 1.41 1.18 1.29 1.32 1.26 1.30 1.36 1.41 1.19 1.14 1.10 1.12
Remark Achieved the standard target (≤2.0)
KEY PERFORMANCE INDICATOR (KPI)
JUL 0 268 0%
AUG 0 473 0%
SEP 0 293 0%
≤ 2.0 %
OCT 0 354 0%
NOV 0 334 0%
DEC 0 465 0%
Criteria
Inclusion : All red cell in stock (collected and / or received from other centre)
Exclusion : Red cell units that are not suitable for use.
0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Period Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20
N 1 0 0 0 0 0 0 0 0
D 379 386 272 187 341 409 268 473 293
Rate (%) 0.3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
0% 0%
Nov Dec
0 268 0%
0 473 0%
0 293 0%
≤ 2.0 %
0 354 0%
0 334 0%
0 465 0%
Criteria
Inclusion : All red cell in stock (collected and / or received from other centre)
Exclusion : Red cell units that are not suitable for use.
Period Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21
N 0 0 0 0 0 0 0 0 0 0
D 379 386 272 187 341 409 268 473 293 354
Rate (%) 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
0% 0%
Nov Dec
Nov-21 Dec-21
0 0
334 465
0.0 0.0
KEY PERFORMANCE INDICATOR (KPI)
0 268 0%
0 473 0%
0 293 0%
≤ 2.0 %
0 354 0%
0 334 0%
0 465 0%
Criteria
Inclusion : All red cell in stock (collected and / or received from other centre)
Exclusion : Red cell units that are not suitable for use.
Denominator
Prepared By : Verified By :
0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Period Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22
N 0 0 0 0 0 0 0 0 0 0
D 416 311 444 333 514 467 456 440 333 398
Rate (%) 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
Period Jan-22 Feb-22 Mar-22 Jan -Mar Apr-22 May-22 Jun-22 Apr-Jun Jul-22 Aug-22
N:
Number
of
0 0 0 0 0 0 0 0 0 0
expired
red cell in
stock
D : Total
number
of red 416 311 444 1171 333 514 467 1314 456 440
cell in
stock.
Performa
0 0 0 0 0 0 0 0 0 0
nce (%)
0% 0%
Nov Dec
Nov-22 Dec-22
0 0
322 522
0 0
0 0 0 0 0 0
Service Standard 16 : Blood Transfusion Services
Performance Indicator : Red Cell Expiry
Target : ≤ 2.5%
500 0.3%
450
0.3%
400
350
0.2%
300
250
200
0.1%
150
100
50
0 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0.0%
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Period Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Total Blood Stock 379 386 272 187 341 409 268 473 293 354 334 465
% 0.26 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Remark Achieved the standard target (≤2.5%)
MONTH Total Platelet in Stock PLT Expired PLT Expiry Rate Platelet Conc Expiry (%)
Jan 66 31 47.0% 47.0
Feb 77 38 49.4% 49.4
Mar 60 29 48.3% 48.3
Apr 35 3 8.6% 8.6
May 28 10 35.7% 35.7
Jun 71 26 36.6% 36.6
Jul 34 18 52.9% 52.9
Aug 52 16 30.8% 30.8
Sep 73 32 43.8% 43.8
Oct 83 47 56.6% 56.6
Nov 71 47 66.2% 66.2
Dec 92 41 44.6% 44.6
TOTAL 742 338 45.6% 45.6
MONTH Total Aphresis in Stock Aphresis Expired Aphresis Expiry Rate Aphresis Expiry Rate (%)
Jan 1 0 0% 0
Feb 0 0 #DIV/0! 0
Mar 2 0 0% 0
Apr 1 0 0% 0
May 0 0 #DIV/0! 0
Jun 3 2 67% 67
Jul 4 1 25% 25
Aug 0 0 #DIV/0! 0
Sep 0 0 #DIV/0! 0
Oct 1 1 100% 100
Nov 0 0 #DIV/0! 0
Dec 0 0 #DIV/0! 0
TOTAL 12 4 33% 33
100
90
80
52.9
70 49.4 48.3
47.0
Total No. of platelets in stock
4
60
35.7 36.6
50
30.8
40 77
71 73
66
30 60
52
20
35 34
8.6 28
10
0
Jan Feb Mar Apr May Jun Jul Aug Sep
Month
67
0 0 0 0 0 0
Jan Feb Mar Apr May Jun Jul Aug
60.0
56.6
52.9
50.0
43.8 44.6
92
30.8 30.0
83
73 71
20.0
52
34
10.0
0.0
Jul Aug Sep Oct Nov Dec
100
25
25
0 0 0 0
Jul Aug Sep Oct Nov Dec
100 70.0
66.2
90
60.0
80 56.6
52.9
70 49.4 50.0
48.3
47.0
43.8 44.6
60
40.0
35.7 36.6
50
30.8 30.0
40
30 20.0
20
10.0
8.6
10
0 0.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Period Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Total number of 31 50 29 3 10 26 18 16 22 45 47 41
expired platelet
% 45.6 76.9 40.8 7.0 19.2 39.4 24.7 17.6 25.6 42.5 49.5 32.5
Remark Not achieved the standard target (≤15%)
Service Standard 16 : Blood Transfusion Services
Performance Indicator : Apheresis (Platelet or Plasma) Expiry
Target : ≤ 0%
4.5 120
4
100 100
3.5
3 80
2.5 67
60
2
1.5 40
1
25
20
0.5
0 0 0 0 0 0 0 0 0 0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Period Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expired 0 0 0 0 0 1 0 0 0 1 0 0
Apheresis
Total Apheresis 2 1 3 3 6 8 5 6 0 1 0 0
In Stock
% 0.00 0.00 0.00 0.00 0.00 12.50 0.00 0.00 0.00 100.00 0.00 0.00
Remark Not achieved the standard target (≤0%)
Number of adverse events in donors Number of adverse events in patie
(adverse donor reactions )
No of.
Adverse
MONTH Adverse donor reaction Seroconvertion MONTH
events in
donor
Jan 37 0 37 Jan
Feb 13 0 13 Feb
Mar 14 1 15 Mar
Apr 14 0 14 Apr
May 19 0 19 May
Jun 27 1 28 Jun
Jul 19 1 20 Jul
Aug 18 1 19 Aug
Sep 27 0 27 Sep
Oct 22 2 24 Oct
Nov 18 1 19 Nov
Dec 22 0 22 Dec
TOTAL 250 7 257 TOTAL
Tabung Darah
Tabung
Tabung Darah Pusat Tabung Darah Pusat No. of blood
Darah
Perkhidmatan Darah (PPD) Bergerak Perkhidmatan collection
Bergerak
Darah (PPD)
No. of
Transfusion Seroconvert
Near Miss IBCT adverse 7
reactions Recipient
events
0 0 4 0 4 6
1 0 2 0 3
1 0 3 0 4
0 0 0 0 5
0
0 0 6 0 6
0 0 6 0 6 497
0 0 6 0 6 42
2
0 0 2 0 2
4 0 38 0 42
1
0
Jan Fe
No. of blo
Jan
Feb 40
Mar
Apr 37
May 35
Jun
Jul
Aug 30
Sep
Oct
Nov 25
Total No. of blood collection
Dec
20
15 15
497 14
13
25
15 15
497 14
13
425 415
10
332
288
0
Jan Feb Mar Apr Ma
Patient
Period Jan-20 Feb-20 Mar-20 Apr-20
N 4 3 4 0
D 301 369 265 247
No. of blood collection No. of adverse events
7 700
6 6 6 6 600
5 5 500
No. of blood collection
1 1 100
0 0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Month
700
600
500
28
27
24
400
22
No of ADR
20
19 19 19
612 601 300
577
15
14 495
447
27
24
400
22
No of ADR
20
19 19 19
612 601 300
577
15
14 495
447
415 407 416
200
332
288
100
0
Mar Apr May Jun Jul Aug Sep Oct Nov Dec
600
500
No. of adverse events
400
300
200
100
0
Number of adverse events in donors Number of adverse events in patie
(adverse donor reactions )
No of.
Adverse
MONTH Adverse donor reaction Seroconvertion MONTH
events in
donor
Jan 14 1 15 Jan
Feb 16 0 16 Feb
Mar 26 0 26 Mar
Apr 23 0 23 Apr
May 20 0 20 May
Jun 26 1 27 Jun
Jul 27 0 27 Jul
Aug 24 0 24 Aug
Sep 20 0 20 Sep
Oct 24 0 24 Oct
Nov 12 0 12 Nov
Dec 15 0 15 Dec
TOTAL 247 2 249 TOTAL
Tabung Darah
Tabung
Tabung Darah Pusat Tabung Darah Pusat No. of blood
Darah
Perkhidmatan Darah (PPD) Bergerak Perkhidmatan collection
Bergerak
Darah (PPD)
No. of
Transfusion Seroconvert
Near Miss IBCT adverse 10
reactions Recipient
events
9
1 0 2 0 3
2 0 6 0 8 8
0 0 9 0 9
0 0 1 0 1 7
0 0 3 0 3
0
Jan F
No. of blo
Jan
Feb 30
Mar
Apr
May
26
Jun 25
Jul
Aug 23
Sep
Oct 20
Nov
Total No. of blood collection
Dec
16
15 15
594
509
494
10
20
594
509
494
10
428
343
0
Jan Feb Mar Apr Ma
10 700
9 9
600
8 8
7 500
No. of blood collection
594 300
4 4 4 4 4
534 528
509 494 510
450 431 451
3 4283 3 410 200
343
2 2
100
1 1
0 0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Month
700
27 27
26 600
24 24
23
500
20 20
400
No of ADR
15
594 300
12
534 528
509 510
494
450 451
20 20
400
No of ADR
15
594 300
12
534 528
509 510
494
450 451
431
410 200
100
0
Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Patient
Period Jan-21 Feb-21 Mar-21 Apr-21
N 3 8 9 1
D 428 343 594 509
700
600
500
No. of adverse events
400
300
200
100
0
May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
3 0 4 2 6 4 4 4
494 534 450 528 431 451 410 510
Number of adverse events in donors Number of adverse events in patie
(adverse donor reactions )
No of.
Adverse
MONTH Adverse donor reaction Seroconvertion MONTH
events in
donor
Jan 40 0 40 Jan
Feb 25 0 25 Feb
Mar 19 0 19 Mar
Apr 23 0 23 Apr
May 31 0 31 May
Jun 17 0 17 Jun
Jul 12 0 12 Jul
Aug 12 0 12 Aug
Sep 6 0 6 Sep
Oct 6 0 6 Oct
Nov 6 0 6 Nov
Dec 14 0 14 Dec
TOTAL 211 0 211 TOTAL
Tabung Darah
Tabung
Tabung Darah Pusat Tabung Darah Pusat No. of blood
Darah
Perkhidmatan Darah (PPD) Bergerak Perkhidmatan collection
Bergerak
Darah (PPD)
No. of
Transfusion Seroconvert
Near Miss IBCT adverse 8
reactions Recipient
events
0 0 5 0 5 7
0 0 4 0 4
0 0 2 0 2
6
1 0 1 0 2
0 0 7 0 7
0 0 6 0 6 5 5
0
Jan Fe
Jan
Feb
Mar
Apr 45
May
Jun 40 40
Jul
Aug
35
Sep
Oct
Nov 30
Dec
Total No. of blood collection
25 25
23
20
19
609
15 547
30
20
19
609
15 547
406 395
10
0
Jan Feb Mar Apr
8 800
7 7 700
6 6 6 600
5 5 5 500
No. of blood collection
1 100
0 0
Jan Feb Mar Apr May Jun Jul Aug
800
700
600
31
500
No of ADR
23 400
714
19 689 685
635
17 300
547 556 537 521
14
31
500
No of ADR
23 400
714
19 689 685
635
17 300
547 556 537 521
14
12 12
395 395 200
6 6 6 100
0
Mar Apr May Jun Jul Aug
Month
Patient
Period Jan-22 Feb-22 Mar-22
N 5 4 2
D 609 406 547
800
700
600
500
No. of adverse events
400
300
200
100
800
700
600
500
No of ADR
400
685
300
14
500
No of ADR
400
685
300 4
3
14
5
200 4
100
35
30
27 27
25
22 22
20 19 19
18 18
15 14 14
13
10
5
2
1 1 1 1 1
0 0 0 0 0 0
0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Period Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Adverse donor 37 13 14 14 19 27 19 18 27 22 18 22
reaction
Seroconvertion 0 0 1 0 0 1 1 1 0 2 1 0
Service Standard 16 : Blood Transfusion Services
Performance Indicator :Number of adverse events in patients
(Near Misses, Incorrect blood component transfused (IBCT), Transfusion Reaction,
Transfusion transmitted infections)
6.5
6 6 6
5.5
4.5
4 4
3.5
3 3
2.5
2 2
1.5
1 1 1 1 1 1
0.5
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
-0.5
Period Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Near Miss 0 1 1 0 0 1 0 0 1 0 0 0
IBCT 0 0 0 0 0 0 0 0 0 0 0 0
Transfusion reactions 4 2 3 0 6 4 3 1 1 6 6 2
Seroconvert Recipient 0 0 0 0 0 0 0 0 0 0 0 0