Membuat ranking secara otomatis pada Microsoft Excel
Cara tersebut tidaklah salah, namun menurut saya masih kurang efektif karena memerlukan beberapa langkah.
No
|
NAMA
|
B.INDO
|
MTK
|
B.JAWA
|
IPA
|
IPS
|
SBK
|
1
|
Ely Nofitasari
|
65
|
82
|
85
|
76
|
67.65
|
68
|
2
|
Aji Ainun Najib
|
62
|
68
|
85
|
65
|
70.59
|
74
|
3
|
Maulidin
|
79
|
79
|
0
|
74
|
88.24
|
82
|
4
|
Risma Amalia Azizah
|
50
|
79
|
65
|
65
|
67.65
|
71
|
5
|
Tuti Amelia
|
71
|
82
|
79
|
71
|
79.41
|
76
|
6
|
Adi Irawan
|
68
|
88
|
79
|
71
|
70.59
|
71
|
7
|
Aldy Mayang Doro
|
68
|
79
|
53
|
71
|
52.94
|
65
|
8
|
Andika Syarif H.
|
59
|
74
|
50
|
71
|
64.71
|
74
|
9
|
Ardhian Dwi Saputra
|
74
|
79
|
62
|
76
|
64.71
|
65
|
10
|
Ayulian Solichah
|
56
|
82
|
82
|
71
|
73.53
|
74
|
11
|
Bintari
|
56
|
71
|
79
|
71
|
64.71
|
56
|
12
|
Dewi Saputri
|
65
|
88
|
82
|
76
|
73.53
|
88
|
13
|
Dian Tri Aprilia
|
71
|
85
|
76
|
71
|
61.76
|
79
|
14
|
Dimas Akbar N.
|
62
|
97
|
74
|
79
|
91.18
|
79
|
15
|
Dyah Darmastuti
|
53
|
82
|
74
|
62
|
58.82
|
79
|
16
|
Ela Kartiyani
|
56
|
79
|
76
|
65
|
67.65
|
65
|
17
|
Fairuz Nabil S.
|
76
|
97
|
79
|
88
|
94.12
|
100
|
18
|
Firma Devi Rahayu
|
76
|
94
|
94
|
82
|
85.29
|
91
|
19
|
Heru Prasetya S.
|
62
|
76
|
62
|
68
|
52.94
|
74
|
20
|
Hidayat Nazaruddin
|
76
|
94
|
79
|
79
|
82.35
|
68
|
21
|
Irfan Kurniawan
|
74
|
76
|
91
|
76
|
88.24
|
71
|
22
|
Joko Satriyo
|
56
|
85
|
0
|
85
|
70.59
|
68
|
23
|
Karina Lestari
|
65
|
71
|
74
|
74
|
70.59
|
94
|
24
|
Kharisma Fadilah
|
74
|
85
|
68
|
71
|
70.59
|
82
|
25
|
Louise Indrifatika
|
62
|
76
|
65
|
74
|
73.53
|
94
|
26
|
Mei Fiksal Ludin
|
59
|
76
|
62
|
56
|
73.53
|
53
|
27
|
Mohamad Ilham M.
|
74
|
76
|
65
|
62
|
67.65
|
59
|
28
|
Mokhamad Afifudin
|
79
|
97
|
79
|
85
|
97.06
|
97
|
29
|
M. Shahriel R.W.
|
65
|
85
|
68
|
74
|
73.53
|
71
|
30
|
Naufal Nawwaf N.M.
|
74
|
85
|
68
|
79
|
79.41
|
76
|
31
|
Ramdoni Ismail A.
|
53
|
79
|
62
|
59
|
67.65
|
59
|
32
|
Ratna Panca Utami
|
59
|
85
|
71
|
65
|
58.82
|
76
|
33
|
Resti Nur Fatma
|
76
|
91
|
88
|
85
|
79.41
|
65
|
34
|
Ridho Triadi
|
65
|
88
|
79
|
76
|
73.53
|
65
|
35
|
Rozid Chelvianto P.
|
56
|
65
|
76
|
62
|
52.94
|
82
|
36
|
Salsabila Aulia S.
|
38
|
74
|
65
|
50
|
58.82
|
56
|
37
|
Sella Destrianti
|
47
|
53
|
44
|
50
|
52.94
|
53
|
38
|
Sevila Yolanda A.
|
76
|
97
|
79
|
82
|
91.18
|
97
|
39
|
Wahid Suryanto
|
53
|
76
|
47
|
74
|
41.18
|
65
|
40
|
Zakiyya Yasmin N.A.
|
79
|
88
|
85
|
94
|
97.06
|
97
|
41
|
Zalsabilah Nur'aeni
|
59
|
74
|
76
|
68
|
61.76
|
79
|
42
|
Kahlil Farizy F.
|
71
|
91
|
59
|
91
|
85.29
|
74
|