-
Notifications
You must be signed in to change notification settings - Fork 9
/
database_beasiswa.sql
350 lines (305 loc) · 89.4 KB
/
database_beasiswa.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
-- MySQL dump 10.13 Distrib 5.5.54, for Linux (x86_64)
--
-- Host: localhost Database: beasiswa
-- ------------------------------------------------------
-- Server version 5.5.54-cll
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `mila_beasiswa`
--
DROP TABLE IF EXISTS `mila_beasiswa`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mila_beasiswa` (
`ID` int(4) NOT NULL,
`BEASISWA` varchar(20) NOT NULL,
`JURUSAN` int(4) NOT NULL,
`PRODI` int(4) NOT NULL,
`SMTDARI` int(4) NOT NULL,
`SMTSMP` int(4) NOT NULL,
`IPKMIN` float NOT NULL,
`TAHUN` int(10) NOT NULL,
`AKTIF` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mila_beasiswa`
--
LOCK TABLES `mila_beasiswa` WRITE;
/*!40000 ALTER TABLE `mila_beasiswa` DISABLE KEYS */;
INSERT INTO `mila_beasiswa` (`ID`, `BEASISWA`, `JURUSAN`, `PRODI`, `SMTDARI`, `SMTSMP`, `IPKMIN`, `TAHUN`, `AKTIF`) VALUES (1,'PPA',0,0,3,6,3,2014,1),(2,'BBM',0,0,2,6,3,2015,1),(3,'SUPERSEMAR',0,0,2,7,3,2014,1),(4,'BI',0,0,2,6,3,2014,1),(5,'BRI',0,0,3,7,3,2014,1),(6,'BTN',0,0,3,6,3,2014,1);
/*!40000 ALTER TABLE `mila_beasiswa` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mila_jurusan`
--
DROP TABLE IF EXISTS `mila_jurusan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mila_jurusan` (
`ID` int(4) NOT NULL,
`JURUSAN` varchar(50) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mila_jurusan`
--
LOCK TABLES `mila_jurusan` WRITE;
/*!40000 ALTER TABLE `mila_jurusan` DISABLE KEYS */;
INSERT INTO `mila_jurusan` (`ID`, `JURUSAN`) VALUES (1,'TEKNIK');
/*!40000 ALTER TABLE `mila_jurusan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mila_mahasiswa`
--
DROP TABLE IF EXISTS `mila_mahasiswa`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mila_mahasiswa` (
`ID` int(10) NOT NULL,
`NIM` int(20) NOT NULL,
`NAMA` varchar(50) NOT NULL,
`PRODI` int(4) NOT NULL,
`JURUSAN` int(4) NOT NULL,
`ALAMAT` text NOT NULL,
`IPK` float NOT NULL,
`GAJI` int(10) NOT NULL,
`SEMESTER` int(2) NOT NULL,
`JENKEL` enum('L','P') NOT NULL DEFAULT 'L',
`REKLISTRIK` int(20) NOT NULL,
`JMLPIAGAM` int(3) NOT NULL,
`PROPOSALPKM` enum('Y','T') NOT NULL DEFAULT 'T',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mila_mahasiswa`
--
LOCK TABLES `mila_mahasiswa` WRITE;
/*!40000 ALTER TABLE `mila_mahasiswa` DISABLE KEYS */;
INSERT INTO `mila_mahasiswa` (`ID`, `NIM`, `NAMA`, `PRODI`, `JURUSAN`, `ALAMAT`, `IPK`, `GAJI`, `SEMESTER`, `JENKEL`, `REKLISTRIK`, `JMLPIAGAM`, `PROPOSALPKM`) VALUES (1,9010,'MAHMUD KHUDORI',2,1,'SURABAYA',3.52,3500000,4,'L',180000,5,'Y'),(2,9011,'SUCI WULANDARI',7,1,'NGAWI',3.23,250000,6,'P',40000,3,'Y'),(3,9012,'SUHAIMI FIRDAUS',1,1,'BOYOLALI',3.07,2500000,4,'L',100000,2,'T'),(4,9013,'MUHAMMAD EKO SAPUTRA',5,1,'TENGGARONG',3,2000000,4,'L',80000,3,'Y'),(6,9015,'ANDIKA PRATAMA',6,1,'BOGOR',3.67,800000,6,'L',33000,4,'T'),(7,9016,'ZULFANDI',1,1,'MAGETAN',3.3,2000000,4,'L',61500,2,'Y'),(8,9017,'AYU OKTAVIANA',3,1,'MAGELANG',3.64,3000000,4,'P',200000,5,'Y');
/*!40000 ALTER TABLE `mila_mahasiswa` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mila_probabilitas`
--
DROP TABLE IF EXISTS `mila_probabilitas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mila_probabilitas` (
`ID` int(3) NOT NULL AUTO_INCREMENT,
`KOLOM` varchar(20) NOT NULL,
`DATA` text,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mila_probabilitas`
--
LOCK TABLES `mila_probabilitas` WRITE;
/*!40000 ALTER TABLE `mila_probabilitas` DISABLE KEYS */;
INSERT INTO `mila_probabilitas` (`ID`, `KOLOM`, `DATA`) VALUES (1,'PRODI','{\"BEASISWA\":{\"1\":\"PPA\",\"2\":\"BBM\",\"3\":\"SUPERSEMAR\",\"4\":\"BI\",\"5\":\"BRI\",\"6\":\"BTN\"},\"ITEM\":[\"D3 ELEKTRO\",\"D3 MESIN\",\"D3 PKK\",\"D3 SIPIL\",\"S1 ELEKTRO\",\"S1 MESIN\",\"S1 PKK\",\"S1 SIPIL\"],\"NILAI\":[[\"18\",\"24\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"8\",\"9\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"2\",\"7\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"9\",\"10\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"17\",\"19\",\"5\",\"2\",\"1\",\"1\",\"39\"],[\"32\",\"29\",\"5\",\"1\",\"3\",\"1\",\"28\"],[\"39\",\"28\",\"2\",\"2\",\"2\",\"0\",\"20\"],[\"21\",\"23\",\"3\",\"1\",\"2\",\"0\",\"13\"]],\"MAX\":[\"39\",\"29\",\"5\",\"2\",\"3\",\"1\",\"39\"],\"TOTAL\":[146,149,15,6,8,2,103],\"MEAN\":[18.25,18.625,1.875,0.75,1,0.25,12.875],\"STDEV\":[12.4412907002,8.83074984682,2.23207142743,0.886405260428,1.19522860933,0.462910049886,14.8846757247]}'),(2,'SEMESTER','{\"BEASISWA\":{\"1\":\"PPA\",\"2\":\"BBM\",\"3\":\"SUPERSEMAR\",\"4\":\"BI\",\"5\":\"BRI\",\"6\":\"BTN\"},\"ITEM\":[\"4\",\"6\",\"7\",\"8\",\"9\",\"10\"],\"NILAI\":[[\"59\",\"53\",\"10\",\"0\",\"0\",\"0\",\"41\"],[\"51\",\"73\",\"2\",\"0\",\"0\",\"0\",\"25\"],[\"0\",\"0\",\"0\",\"1\",\"4\",\"2\",\"0\"],[\"36\",\"23\",\"1\",\"0\",\"0\",\"0\",\"37\"],[\"0\",\"0\",\"0\",\"5\",\"4\",\"0\",\"0\"],[\"0\",\"0\",\"2\",\"0\",\"0\",\"0\",\"0\"]],\"MAX\":[\"59\",\"73\",\"10\",\"5\",\"4\",\"2\",\"41\"],\"TOTAL\":[146,149,15,6,8,2,103],\"MEAN\":[24.3333333333,24.8333333333,2.5,1,1.33333333333,0.333333333333,17.1666666667],\"STDEV\":[27.6598385148,31.5177198837,3.78153408024,2,2.06559111798,0.816496580928,19.5286114884]}'),(3,'JENKEL','{\"BEASISWA\":{\"1\":\"PPA\",\"2\":\"BBM\",\"3\":\"SUPERSEMAR\",\"4\":\"BI\",\"5\":\"BRI\",\"6\":\"BTN\"},\"ITEM\":[\"L\",\"P\"],\"NILAI\":[[\"58\",\"76\",\"8\",\"3\",\"4\",\"2\",\"77\"],[\"88\",\"73\",\"7\",\"3\",\"4\",\"0\",\"26\"]],\"MAX\":[\"88\",\"76\",\"8\",\"3\",\"4\",\"2\",\"77\"],\"TOTAL\":[146,149,15,6,8,2,103],\"MEAN\":[73,74.5,7.5,3,4,1,51.5],\"STDEV\":[21.2132034356,2.12132034356,0.707106781187,0,0,1.41421356237,36.0624458405]}'),(4,'IPK','{\"BEASISWA\":{\"1\":\"PPA\",\"2\":\"BBM\",\"3\":\"SUPERSEMAR\",\"4\":\"BI\",\"5\":\"BRI\",\"6\":\"BTN\"},\"ITEM\":[\"2.75\",\"2.76\",\"2.77\",\"2.78\",\"2.79\",\"2.8\",\"2.81\",\"2.82\",\"2.83\",\"2.84\",\"2.85\",\"2.86\",\"2.88\",\"2.89\",\"2.9\",\"2.91\",\"2.92\",\"2.93\",\"2.94\",\"2.95\",\"2.96\",\"2.97\",\"2.98\",\"2.99\",\"3\",\"3.01\",\"3.02\",\"3.03\",\"3.04\",\"3.05\",\"3.06\",\"3.07\",\"3.08\",\"3.09\",\"3.1\",\"3.11\",\"3.12\",\"3.13\",\"3.14\",\"3.15\",\"3.16\",\"3.17\",\"3.18\",\"3.19\",\"3.2\",\"3.21\",\"3.22\",\"3.23\",\"3.24\",\"3.25\",\"3.26\",\"3.27\",\"3.28\",\"3.29\",\"3.3\",\"3.31\",\"3.32\",\"3.33\",\"3.34\",\"3.35\",\"3.36\",\"3.37\",\"3.38\",\"3.39\",\"3.4\",\"3.41\",\"3.42\",\"3.43\",\"3.44\",\"3.45\",\"3.46\",\"3.47\",\"3.48\",\"3.49\",\"3.5\",\"3.51\",\"3.52\",\"3.54\",\"3.55\",\"3.57\",\"3.59\",\"3.61\",\"3.63\",\"3.64\",\"3.65\",\"3.88\"],\"NILAI\":[[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"2\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"2\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"4\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"4\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"3\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"0\",\"2\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"5\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"4\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"2\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"0\",\"4\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"3\",\"0\",\"0\",\"0\",\"0\",\"3\"],[\"0\",\"9\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"10\",\"0\",\"0\",\"0\",\"0\",\"4\"],[\"0\",\"9\",\"0\",\"0\",\"0\",\"0\",\"4\"],[\"0\",\"11\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"2\",\"10\",\"0\",\"0\",\"1\",\"0\",\"5\"],[\"0\",\"3\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"5\",\"3\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"3\",\"4\",\"0\",\"0\",\"0\",\"0\",\"4\"],[\"3\",\"5\",\"0\",\"0\",\"0\",\"1\",\"1\"],[\"1\",\"2\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"3\",\"2\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"4\",\"4\",\"0\",\"1\",\"0\",\"0\",\"7\"],[\"5\",\"2\",\"0\",\"1\",\"0\",\"1\",\"2\"],[\"5\",\"2\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"4\",\"0\",\"1\",\"1\",\"0\",\"0\",\"4\"],[\"3\",\"1\",\"1\",\"0\",\"1\",\"0\",\"3\"],[\"7\",\"2\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"10\",\"1\",\"1\",\"0\",\"1\",\"0\",\"4\"],[\"6\",\"3\",\"0\",\"0\",\"0\",\"0\",\"6\"],[\"3\",\"0\",\"0\",\"0\",\"0\",\"0\",\"4\"],[\"5\",\"4\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"6\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"5\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"3\",\"1\",\"1\",\"0\",\"0\",\"0\",\"1\"],[\"4\",\"2\",\"0\",\"0\",\"0\",\"0\",\"4\"],[\"3\",\"0\",\"1\",\"0\",\"0\",\"0\",\"4\"],[\"4\",\"1\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"4\",\"1\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"2\",\"0\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"2\",\"2\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"3\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"2\",\"0\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"4\",\"2\",\"0\",\"0\",\"1\",\"0\",\"2\"],[\"3\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"2\",\"1\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"3\",\"0\",\"0\",\"0\",\"1\",\"0\",\"0\"],[\"1\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"2\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"3\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"3\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"2\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"1\",\"0\",\"1\",\"1\",\"0\",\"0\"],[\"3\",\"0\",\"0\",\"1\",\"0\",\"0\",\"0\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"1\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"2\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"0\",\"0\",\"0\",\"1\",\"0\",\"0\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"2\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"2\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"0\",\"0\",\"1\",\"0\",\"0\",\"0\"],[\"0\",\"0\",\"1\",\"0\",\"1\",\"0\",\"0\"],[\"0\",\"0\",\"2\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\"]],\"MAX\":[\"10\",\"11\",\"2\",\"1\",\"1\",\"1\",\"7\"],\"TOTAL\":[146,149,15,6,8,2,103],\"MEAN\":[1.6976744186,1.73255813953,0.174418604651,0.0697674418605,0.093023255814,0.0232558139535,1.1976744186],\"STDEV\":[2.03539137697,2.43708803387,0.411363885432,0.256248853055,0.292168644964,0.1515988659,1.56295171309]}'),(5,'GAJI','{\"BEASISWA\":{\"1\":\"PPA\",\"2\":\"BBM\",\"3\":\"SUPERSEMAR\",\"4\":\"BI\",\"5\":\"BRI\",\"6\":\"BTN\"},\"ITEM\":[\"250000\",\"300000\",\"500000\",\"750000\",\"800000\",\"1000000\",\"1200000\",\"1500000\",\"2000000\",\"2500000\",\"3000000\",\"3500000\",\"5000000\",\"7500000\"],\"NILAI\":[[\"8\",\"19\",\"0\",\"0\",\"0\",\"0\",\"3\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"26\",\"31\",\"0\",\"0\",\"0\",\"0\",\"3\"],[\"15\",\"11\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"3\",\"3\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"61\",\"64\",\"0\",\"0\",\"0\",\"0\",\"28\"],[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"1\",\"5\",\"2\",\"1\",\"2\",\"1\",\"2\"],[\"4\",\"9\",\"2\",\"0\",\"1\",\"0\",\"11\"],[\"22\",\"6\",\"3\",\"3\",\"5\",\"1\",\"32\"],[\"2\",\"1\",\"5\",\"2\",\"0\",\"0\",\"6\"],[\"2\",\"0\",\"3\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"12\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"4\"]],\"MAX\":[\"61\",\"64\",\"5\",\"3\",\"5\",\"1\",\"32\"],\"TOTAL\":[146,149,15,6,8,2,103],\"MEAN\":[10.4285714286,10.6428571429,1.07142857143,0.428571428571,0.571428571429,0.142857142857,7.35714285714],\"STDEV\":[16.832725844,17.7703605559,1.63915014163,0.937614461877,1.39858641351,0.363136519601,10.3448771629]}'),(6,'REKLISTRIK','{\"BEASISWA\":{\"1\":\"PPA\",\"2\":\"BBM\",\"3\":\"SUPERSEMAR\",\"4\":\"BI\",\"5\":\"BRI\",\"6\":\"BTN\"},\"ITEM\":[\"20000\",\"30000\",\"40000\",\"50000\",\"60000\",\"70000\",\"80000\",\"90000\",\"100000\",\"110000\",\"120000\",\"130000\",\"135000\",\"150000\",\"180000\",\"190000\",\"200000\",\"250000\",\"300000\",\"350000\"],\"NILAI\":[[\"2\",\"14\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"10\",\"18\",\"0\",\"0\",\"0\",\"0\",\"0\"],[\"16\",\"33\",\"0\",\"0\",\"0\",\"0\",\"3\"],[\"29\",\"25\",\"1\",\"1\",\"1\",\"0\",\"4\"],[\"17\",\"13\",\"0\",\"0\",\"2\",\"0\",\"1\"],[\"23\",\"11\",\"2\",\"0\",\"1\",\"1\",\"10\"],[\"22\",\"9\",\"2\",\"1\",\"2\",\"0\",\"9\"],[\"1\",\"10\",\"0\",\"1\",\"0\",\"0\",\"4\"],[\"12\",\"11\",\"4\",\"2\",\"1\",\"1\",\"15\"],[\"0\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"],[\"8\",\"4\",\"2\",\"1\",\"1\",\"0\",\"6\"],[\"3\",\"1\",\"0\",\"0\",\"0\",\"0\",\"7\"],[\"0\",\"0\",\"1\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"2\"],[\"3\",\"0\",\"1\",\"0\",\"0\",\"0\",\"8\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\"],[\"0\",\"0\",\"1\",\"0\",\"0\",\"0\",\"14\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"6\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"7\"],[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"3\"]],\"MAX\":[\"29\",\"33\",\"4\",\"2\",\"2\",\"1\",\"15\"],\"TOTAL\":[146,149,15,6,8,2,103],\"MEAN\":[7.3,7.45,0.75,0.3,0.4,0.1,5.15],\"STDEV\":[9.35892481454,9.55028244278,1.06992375528,0.571240570577,0.680557047379,0.307793505626,4.39227791279]}'),(7,'JMLPIAGAM','{\"BEASISWA\":{\"1\":\"PPA\",\"2\":\"BBM\",\"3\":\"SUPERSEMAR\",\"4\":\"BI\",\"5\":\"BRI\",\"6\":\"BTN\"},\"ITEM\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\"],\"NILAI\":[[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"20\"],[\"5\",\"4\",\"1\",\"0\",\"0\",\"0\",\"41\"],[\"24\",\"15\",\"1\",\"0\",\"4\",\"2\",\"20\"],[\"40\",\"51\",\"0\",\"0\",\"0\",\"0\",\"13\"],[\"49\",\"39\",\"3\",\"5\",\"0\",\"0\",\"8\"],[\"27\",\"27\",\"4\",\"1\",\"4\",\"0\",\"1\"],[\"0\",\"13\",\"6\",\"0\",\"0\",\"0\",\"0\"]],\"MAX\":[\"49\",\"51\",\"6\",\"5\",\"4\",\"2\",\"41\"],\"TOTAL\":[146,149,15,6,8,2,103],\"MEAN\":[20.8571428571,21.2857142857,2.14285714286,0.857142857143,1.14285714286,0.285714285714,14.7142857143],\"STDEV\":[19.5228803496,18.6611386372,2.26778683806,1.86445447147,1.9518001459,0.755928946018,14.1387680476]}'),(8,'PROPOSALPKM','{\"BEASISWA\":{\"1\":\"PPA\",\"2\":\"BBM\",\"3\":\"SUPERSEMAR\",\"4\":\"BI\",\"5\":\"BRI\",\"6\":\"BTN\"},\"ITEM\":[\"Y\",\"T\"],\"NILAI\":[[\"146\",\"149\",\"15\",\"0\",\"0\",\"0\",\"0\"],[\"0\",\"0\",\"0\",\"6\",\"8\",\"2\",\"103\"]],\"MAX\":[\"146\",\"149\",\"15\",\"6\",\"8\",\"2\",\"103\"],\"TOTAL\":[146,149,15,6,8,2,103],\"MEAN\":[73,74.5,7.5,3,4,1,51.5],\"STDEV\":[103.237590053,105.358910397,10.6066017178,4.24264068712,5.65685424949,1.41421356237,72.8319984622]}');
/*!40000 ALTER TABLE `mila_probabilitas` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mila_prodi`
--
DROP TABLE IF EXISTS `mila_prodi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mila_prodi` (
`ID` int(4) NOT NULL,
`JURUSAN` int(4) NOT NULL,
`PRODI` varchar(50) NOT NULL,
`JENJANG` varchar(4) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mila_prodi`
--
LOCK TABLES `mila_prodi` WRITE;
/*!40000 ALTER TABLE `mila_prodi` DISABLE KEYS */;
INSERT INTO `mila_prodi` (`ID`, `JURUSAN`, `PRODI`, `JENJANG`) VALUES (1,1,'ELEKTRO','S1'),(2,1,'ELEKTRO','D3'),(3,1,'MESIN','S1'),(4,1,'MESIN','D3'),(5,1,'SIPIL','S1'),(6,1,'SIPIL','D3'),(7,1,'PKK','S1'),(8,1,'PKK','D3');
/*!40000 ALTER TABLE `mila_prodi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mila_rekomendasi`
--
DROP TABLE IF EXISTS `mila_rekomendasi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mila_rekomendasi` (
`NIM` int(20) NOT NULL,
`DATA` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`REKOMENDASI` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`NIM`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mila_rekomendasi`
--
LOCK TABLES `mila_rekomendasi` WRITE;
/*!40000 ALTER TABLE `mila_rekomendasi` DISABLE KEYS */;
INSERT INTO `mila_rekomendasi` (`NIM`, `DATA`, `REKOMENDASI`) VALUES (9010,'{\"PRODI\":{\"PPA\":{\"VAL\":\"18\",\"TOTAL\":146,\"NILAI\":0.123287671233},\"BBM\":{\"VAL\":\"24\",\"TOTAL\":149,\"NILAI\":0.161073825503},\"SUPERSEMAR\":{\"VAL\":\"0\",\"TOTAL\":15,\"NILAI\":0},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"1\",\"TOTAL\":103,\"NILAI\":0.00970873786408}},\"SEMESTER\":{\"PPA\":{\"VAL\":\"59\",\"TOTAL\":146,\"NILAI\":0.404109589041},\"BBM\":{\"VAL\":\"53\",\"TOTAL\":149,\"NILAI\":0.355704697987},\"SUPERSEMAR\":{\"VAL\":\"10\",\"TOTAL\":15,\"NILAI\":0.666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"41\",\"TOTAL\":103,\"NILAI\":0.398058252427}},\"JENKEL\":{\"PPA\":{\"VAL\":\"58\",\"TOTAL\":146,\"NILAI\":0.397260273973},\"BBM\":{\"VAL\":\"76\",\"TOTAL\":149,\"NILAI\":0.510067114094},\"SUPERSEMAR\":{\"VAL\":\"8\",\"TOTAL\":15,\"NILAI\":0.533333333333},\"BI\":{\"VAL\":\"3\",\"TOTAL\":6,\"NILAI\":0.5},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"77\",\"TOTAL\":103,\"NILAI\":0.747572815534}},\"IPK\":{\"PPA\":{\"VAL\":\"2\",\"STDEV\":2.03539137697,\"MEAN\":1.6976744186,\"NILAI\":0.276508135864},\"BBM\":{\"VAL\":\"0\",\"STDEV\":2.43708803387,\"MEAN\":1.73255813953,\"NILAI\":0.198445553606},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":0.411363885432,\"MEAN\":0.174418604651,\"NILAI\":0.568422940202},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.256248853055,\"MEAN\":0.0697674418605,\"NILAI\":0.759267911942},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.292168644964,\"MEAN\":0.093023255814,\"NILAI\":0.701444537913},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.1515988659,\"MEAN\":0.0232558139535,\"NILAI\":1.01242917452},\"TIDAK\":{\"VAL\":\"0\",\"STDEV\":1.56295171309,\"MEAN\":1.1976744186,\"NILAI\":0.237870688922}},\"GAJI\":{\"PPA\":{\"VAL\":\"2\",\"STDEV\":16.832725844,\"MEAN\":10.4285714286,\"NILAI\":0.0857632121984},\"BBM\":{\"VAL\":\"0\",\"STDEV\":17.7703605559,\"MEAN\":10.6428571429,\"NILAI\":0.0790833707925},\"SUPERSEMAR\":{\"VAL\":\"3\",\"STDEV\":1.63915014163,\"MEAN\":1.07142857143,\"NILAI\":0.155924292107},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.937614461877,\"MEAN\":0.428571428571,\"NILAI\":0.371058402293},\"BRI\":{\"VAL\":\"0\",\"STDEV\":1.39858641351,\"MEAN\":0.571428571429,\"NILAI\":0.310262102101},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.363136519601,\"MEAN\":0.142857142857,\"NILAI\":0.612606496016},\"TIDAK\":{\"VAL\":\"1\",\"STDEV\":10.3448771629,\"MEAN\":7.35714285714,\"NILAI\":0.102673276279}},\"REKLISTRIK\":{\"PPA\":{\"VAL\":\"3\",\"STDEV\":9.35892481454,\"MEAN\":7.3,\"NILAI\":0.117319515796},\"BBM\":{\"VAL\":\"0\",\"STDEV\":9.55028244278,\"MEAN\":7.45,\"NILAI\":0.0952082396149},\"SUPERSEMAR\":{\"VAL\":\"1\",\"STDEV\":1.06992375528,\"MEAN\":0.75,\"NILAI\":0.375223928862},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.571240570577,\"MEAN\":0.3,\"NILAI\":0.459750859291},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.680557047379,\"MEAN\":0.4,\"NILAI\":0.406795286871},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.307793505626,\"MEAN\":0.1,\"NILAI\":0.681980344699},\"TIDAK\":{\"VAL\":\"8\",\"STDEV\":4.39227791279,\"MEAN\":5.15,\"NILAI\":0.154188822955}},\"JMLPIAGAM\":{\"PPA\":{\"VAL\":\"49\",\"TOTAL\":146,\"NILAI\":0.335616438356},\"BBM\":{\"VAL\":\"39\",\"TOTAL\":149,\"NILAI\":0.261744966443},\"SUPERSEMAR\":{\"VAL\":\"3\",\"TOTAL\":15,\"NILAI\":0.2},\"BI\":{\"VAL\":\"5\",\"TOTAL\":6,\"NILAI\":0.833333333333},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"8\",\"TOTAL\":103,\"NILAI\":0.0776699029126}},\"PROPOSALPKM\":{\"PPA\":{\"VAL\":\"146\",\"TOTAL\":146,\"NILAI\":1},\"BBM\":{\"VAL\":\"149\",\"TOTAL\":149,\"NILAI\":1},\"SUPERSEMAR\":{\"VAL\":\"15\",\"TOTAL\":15,\"NILAI\":1},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"0\",\"TOTAL\":103,\"NILAI\":0}},\"LIKELIHOOD\":{\"PPA\":1.84806134095e-5,\"BBM\":1.1429344328e-5,\"SUPERSEMAR\":0,\"BI\":0,\"BRI\":0,\"BTN\":0,\"TIDAK\":0},\"PROBABILITY\":{\"PPA\":{\"TOTAL\":2.99099577376e-5,\"NILAI\":0.617874942241},\"BBM\":{\"TOTAL\":2.99099577376e-5,\"NILAI\":0.382125057759},\"SUPERSEMAR\":{\"TOTAL\":2.99099577376e-5,\"NILAI\":0},\"BI\":{\"TOTAL\":2.99099577376e-5,\"NILAI\":0},\"BRI\":{\"TOTAL\":2.99099577376e-5,\"NILAI\":0},\"BTN\":{\"TOTAL\":2.99099577376e-5,\"NILAI\":0},\"TIDAK\":{\"TOTAL\":2.99099577376e-5,\"NILAI\":0}},\"REKOMENDASI\":\"PPA\"}','PPA'),(9011,'{\"PRODI\":{\"PPA\":{\"VAL\":\"39\",\"TOTAL\":146,\"NILAI\":0.267123287671},\"BBM\":{\"VAL\":\"28\",\"TOTAL\":149,\"NILAI\":0.187919463087},\"SUPERSEMAR\":{\"VAL\":\"2\",\"TOTAL\":15,\"NILAI\":0.133333333333},\"BI\":{\"VAL\":\"2\",\"TOTAL\":6,\"NILAI\":0.333333333333},\"BRI\":{\"VAL\":\"2\",\"TOTAL\":8,\"NILAI\":0.25},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"20\",\"TOTAL\":103,\"NILAI\":0.194174757282}},\"SEMESTER\":{\"PPA\":{\"VAL\":\"51\",\"TOTAL\":146,\"NILAI\":0.349315068493},\"BBM\":{\"VAL\":\"73\",\"TOTAL\":149,\"NILAI\":0.489932885906},\"SUPERSEMAR\":{\"VAL\":\"2\",\"TOTAL\":15,\"NILAI\":0.133333333333},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"25\",\"TOTAL\":103,\"NILAI\":0.242718446602}},\"JENKEL\":{\"PPA\":{\"VAL\":\"88\",\"TOTAL\":146,\"NILAI\":0.602739726027},\"BBM\":{\"VAL\":\"73\",\"TOTAL\":149,\"NILAI\":0.489932885906},\"SUPERSEMAR\":{\"VAL\":\"7\",\"TOTAL\":15,\"NILAI\":0.466666666667},\"BI\":{\"VAL\":\"3\",\"TOTAL\":6,\"NILAI\":0.5},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"26\",\"TOTAL\":103,\"NILAI\":0.252427184466}},\"IPK\":{\"PPA\":{\"VAL\":\"4\",\"STDEV\":2.03539137697,\"MEAN\":1.6976744186,\"NILAI\":0.147455349113},\"BBM\":{\"VAL\":\"1\",\"STDEV\":2.43708803387,\"MEAN\":1.73255813953,\"NILAI\":0.244212115245},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":0.411363885432,\"MEAN\":0.174418604651,\"NILAI\":0.568422940202},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.256248853055,\"MEAN\":0.0697674418605,\"NILAI\":0.759267911942},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.292168644964,\"MEAN\":0.093023255814,\"NILAI\":0.701444537913},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.1515988659,\"MEAN\":0.0232558139535,\"NILAI\":1.01242917452},\"TIDAK\":{\"VAL\":\"2\",\"STDEV\":1.56295171309,\"MEAN\":1.1976744186,\"NILAI\":0.27965829891}},\"GAJI\":{\"PPA\":{\"VAL\":\"8\",\"STDEV\":16.832725844,\"MEAN\":10.4285714286,\"NILAI\":0.0962111411324},\"BBM\":{\"VAL\":\"19\",\"STDEV\":17.7703605559,\"MEAN\":10.6428571429,\"NILAI\":0.0847126842833},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":1.63915014163,\"MEAN\":1.07142857143,\"NILAI\":0.251614508927},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.937614461877,\"MEAN\":0.428571428571,\"NILAI\":0.371058402293},\"BRI\":{\"VAL\":\"0\",\"STDEV\":1.39858641351,\"MEAN\":0.571428571429,\"NILAI\":0.310262102101},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.363136519601,\"MEAN\":0.142857142857,\"NILAI\":0.612606496016},\"TIDAK\":{\"VAL\":\"3\",\"STDEV\":10.3448771629,\"MEAN\":7.35714285714,\"NILAI\":0.113484919423}},\"REKLISTRIK\":{\"PPA\":{\"VAL\":\"16\",\"STDEV\":9.35892481454,\"MEAN\":7.3,\"NILAI\":0.0846375365348},\"BBM\":{\"VAL\":\"33\",\"STDEV\":9.55028244278,\"MEAN\":7.45,\"NILAI\":0.00360268313697},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":1.06992375528,\"MEAN\":0.75,\"NILAI\":0.301609214217},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.571240570577,\"MEAN\":0.3,\"NILAI\":0.459750859291},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.680557047379,\"MEAN\":0.4,\"NILAI\":0.406795286871},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.307793505626,\"MEAN\":0.1,\"NILAI\":0.681980344699},\"TIDAK\":{\"VAL\":\"3\",\"STDEV\":4.39227791279,\"MEAN\":5.15,\"NILAI\":0.168829386069}},\"JMLPIAGAM\":{\"PPA\":{\"VAL\":\"24\",\"TOTAL\":146,\"NILAI\":0.164383561644},\"BBM\":{\"VAL\":\"15\",\"TOTAL\":149,\"NILAI\":0.10067114094},\"SUPERSEMAR\":{\"VAL\":\"1\",\"TOTAL\":15,\"NILAI\":0.0666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"20\",\"TOTAL\":103,\"NILAI\":0.194174757282}},\"PROPOSALPKM\":{\"PPA\":{\"VAL\":\"146\",\"TOTAL\":146,\"NILAI\":1},\"BBM\":{\"VAL\":\"149\",\"TOTAL\":149,\"NILAI\":1},\"SUPERSEMAR\":{\"VAL\":\"15\",\"TOTAL\":15,\"NILAI\":1},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"0\",\"TOTAL\":103,\"NILAI\":0}},\"LIKELIHOOD\":{\"PPA\":1.11011043634e-5,\"BBM\":3.38447766507e-7,\"SUPERSEMAR\":2.38585956745e-5,\"BI\":0,\"BRI\":0,\"BTN\":0,\"TIDAK\":0},\"PROBABILITY\":{\"PPA\":{\"TOTAL\":3.52981478044e-5,\"NILAI\":0.314495378763},\"BBM\":{\"TOTAL\":3.52981478044e-5,\"NILAI\":0.00958825852229},\"SUPERSEMAR\":{\"TOTAL\":3.52981478044e-5,\"NILAI\":0.675916362715},\"BI\":{\"TOTAL\":3.52981478044e-5,\"NILAI\":0},\"BRI\":{\"TOTAL\":3.52981478044e-5,\"NILAI\":0},\"BTN\":{\"TOTAL\":3.52981478044e-5,\"NILAI\":0},\"TIDAK\":{\"TOTAL\":3.52981478044e-5,\"NILAI\":0}},\"REKOMENDASI\":\"SUPERSEMAR\"}','SUPERSEMAR'),(9012,'{\"PRODI\":{\"PPA\":{\"VAL\":\"17\",\"TOTAL\":146,\"NILAI\":0.116438356164},\"BBM\":{\"VAL\":\"19\",\"TOTAL\":149,\"NILAI\":0.127516778523},\"SUPERSEMAR\":{\"VAL\":\"5\",\"TOTAL\":15,\"NILAI\":0.333333333333},\"BI\":{\"VAL\":\"2\",\"TOTAL\":6,\"NILAI\":0.333333333333},\"BRI\":{\"VAL\":\"1\",\"TOTAL\":8,\"NILAI\":0.125},\"BTN\":{\"VAL\":\"1\",\"TOTAL\":2,\"NILAI\":0.5},\"TIDAK\":{\"VAL\":\"39\",\"TOTAL\":103,\"NILAI\":0.378640776699}},\"SEMESTER\":{\"PPA\":{\"VAL\":\"59\",\"TOTAL\":146,\"NILAI\":0.404109589041},\"BBM\":{\"VAL\":\"53\",\"TOTAL\":149,\"NILAI\":0.355704697987},\"SUPERSEMAR\":{\"VAL\":\"10\",\"TOTAL\":15,\"NILAI\":0.666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"41\",\"TOTAL\":103,\"NILAI\":0.398058252427}},\"JENKEL\":{\"PPA\":{\"VAL\":\"58\",\"TOTAL\":146,\"NILAI\":0.397260273973},\"BBM\":{\"VAL\":\"76\",\"TOTAL\":149,\"NILAI\":0.510067114094},\"SUPERSEMAR\":{\"VAL\":\"8\",\"TOTAL\":15,\"NILAI\":0.533333333333},\"BI\":{\"VAL\":\"3\",\"TOTAL\":6,\"NILAI\":0.5},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"77\",\"TOTAL\":103,\"NILAI\":0.747572815534}},\"IPK\":{\"PPA\":{\"VAL\":\"4\",\"STDEV\":2.03539137697,\"MEAN\":1.6976744186,\"NILAI\":0.147455349113},\"BBM\":{\"VAL\":\"4\",\"STDEV\":2.43708803387,\"MEAN\":1.73255813953,\"NILAI\":0.165736800855},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":0.411363885432,\"MEAN\":0.174418604651,\"NILAI\":0.568422940202},\"BI\":{\"VAL\":\"1\",\"STDEV\":0.256248853055,\"MEAN\":0.0697674418605,\"NILAI\":0.00108358107042},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.292168644964,\"MEAN\":0.093023255814,\"NILAI\":0.701444537913},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.1515988659,\"MEAN\":0.0232558139535,\"NILAI\":1.01242917452},\"TIDAK\":{\"VAL\":\"7\",\"STDEV\":1.56295171309,\"MEAN\":1.1976744186,\"NILAI\":0.000324429969317}},\"GAJI\":{\"PPA\":{\"VAL\":\"22\",\"STDEV\":16.832725844,\"MEAN\":10.4285714286,\"NILAI\":0.0767588470311},\"BBM\":{\"VAL\":\"6\",\"STDEV\":17.7703605559,\"MEAN\":10.6428571429,\"NILAI\":0.0914432569202},\"SUPERSEMAR\":{\"VAL\":\"3\",\"STDEV\":1.63915014163,\"MEAN\":1.07142857143,\"NILAI\":0.155924292107},\"BI\":{\"VAL\":\"3\",\"STDEV\":0.937614461877,\"MEAN\":0.428571428571,\"NILAI\":0.00958413827341},\"BRI\":{\"VAL\":\"5\",\"STDEV\":1.39858641351,\"MEAN\":0.571428571429,\"NILAI\":0.00224261400056},\"BTN\":{\"VAL\":\"1\",\"STDEV\":0.363136519601,\"MEAN\":0.142857142857,\"NILAI\":0.0408288714614},\"TIDAK\":{\"VAL\":\"32\",\"STDEV\":10.3448771629,\"MEAN\":7.35714285714,\"NILAI\":0.00726519194332}},\"REKLISTRIK\":{\"PPA\":{\"VAL\":\"12\",\"STDEV\":9.35892481454,\"MEAN\":7.3,\"NILAI\":0.114933155435},\"BBM\":{\"VAL\":\"11\",\"STDEV\":9.55028244278,\"MEAN\":7.45,\"NILAI\":0.120451056335},\"SUPERSEMAR\":{\"VAL\":\"4\",\"STDEV\":1.06992375528,\"MEAN\":0.75,\"NILAI\":0.00382407303783},\"BI\":{\"VAL\":\"2\",\"STDEV\":0.571240570577,\"MEAN\":0.3,\"NILAI\":0.00629881897709},\"BRI\":{\"VAL\":\"1\",\"STDEV\":0.680557047379,\"MEAN\":0.4,\"NILAI\":0.327799121833},\"BTN\":{\"VAL\":\"1\",\"STDEV\":0.307793505626,\"MEAN\":0.1,\"NILAI\":0.0100019354086},\"TIDAK\":{\"VAL\":\"15\",\"STDEV\":4.39227791279,\"MEAN\":5.15,\"NILAI\":0.0153962917563}},\"JMLPIAGAM\":{\"PPA\":{\"VAL\":\"5\",\"TOTAL\":146,\"NILAI\":0.0342465753425},\"BBM\":{\"VAL\":\"4\",\"TOTAL\":149,\"NILAI\":0.0268456375839},\"SUPERSEMAR\":{\"VAL\":\"1\",\"TOTAL\":15,\"NILAI\":0.0666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"41\",\"TOTAL\":103,\"NILAI\":0.398058252427}},\"PROPOSALPKM\":{\"PPA\":{\"VAL\":\"0\",\"TOTAL\":146,\"NILAI\":0},\"BBM\":{\"VAL\":\"0\",\"TOTAL\":149,\"NILAI\":0},\"SUPERSEMAR\":{\"VAL\":\"0\",\"TOTAL\":15,\"NILAI\":0},\"BI\":{\"VAL\":\"6\",\"TOTAL\":6,\"NILAI\":1},\"BRI\":{\"VAL\":\"8\",\"TOTAL\":8,\"NILAI\":1},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"103\",\"TOTAL\":103,\"NILAI\":1}},\"LIKELIHOOD\":{\"PPA\":0,\"BBM\":0,\"SUPERSEMAR\":0,\"BI\":0,\"BRI\":0,\"BTN\":0,\"TIDAK\":1.62763993608e-9},\"PROBABILITY\":{\"PPA\":{\"TOTAL\":1.62763993608e-9,\"NILAI\":0},\"BBM\":{\"TOTAL\":1.62763993608e-9,\"NILAI\":0},\"SUPERSEMAR\":{\"TOTAL\":1.62763993608e-9,\"NILAI\":0},\"BI\":{\"TOTAL\":1.62763993608e-9,\"NILAI\":0},\"BRI\":{\"TOTAL\":1.62763993608e-9,\"NILAI\":0},\"BTN\":{\"TOTAL\":1.62763993608e-9,\"NILAI\":0},\"TIDAK\":{\"TOTAL\":1.62763993608e-9,\"NILAI\":1}},\"REKOMENDASI\":\"TIDAK\"}','TIDAK'),(9013,'{\"PRODI\":{\"PPA\":{\"VAL\":\"21\",\"TOTAL\":146,\"NILAI\":0.143835616438},\"BBM\":{\"VAL\":\"23\",\"TOTAL\":149,\"NILAI\":0.154362416107},\"SUPERSEMAR\":{\"VAL\":\"3\",\"TOTAL\":15,\"NILAI\":0.2},\"BI\":{\"VAL\":\"1\",\"TOTAL\":6,\"NILAI\":0.166666666667},\"BRI\":{\"VAL\":\"2\",\"TOTAL\":8,\"NILAI\":0.25},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"13\",\"TOTAL\":103,\"NILAI\":0.126213592233}},\"SEMESTER\":{\"PPA\":{\"VAL\":\"59\",\"TOTAL\":146,\"NILAI\":0.404109589041},\"BBM\":{\"VAL\":\"53\",\"TOTAL\":149,\"NILAI\":0.355704697987},\"SUPERSEMAR\":{\"VAL\":\"10\",\"TOTAL\":15,\"NILAI\":0.666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"41\",\"TOTAL\":103,\"NILAI\":0.398058252427}},\"JENKEL\":{\"PPA\":{\"VAL\":\"58\",\"TOTAL\":146,\"NILAI\":0.397260273973},\"BBM\":{\"VAL\":\"76\",\"TOTAL\":149,\"NILAI\":0.510067114094},\"SUPERSEMAR\":{\"VAL\":\"8\",\"TOTAL\":15,\"NILAI\":0.533333333333},\"BI\":{\"VAL\":\"3\",\"TOTAL\":6,\"NILAI\":0.5},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"77\",\"TOTAL\":103,\"NILAI\":0.747572815534}},\"IPK\":{\"PPA\":{\"VAL\":\"2\",\"STDEV\":2.03539137697,\"MEAN\":1.6976744186,\"NILAI\":0.276508135864},\"BBM\":{\"VAL\":\"10\",\"STDEV\":2.43708803387,\"MEAN\":1.73255813953,\"NILAI\":0.000809946923336},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":0.411363885432,\"MEAN\":0.174418604651,\"NILAI\":0.568422940202},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.256248853055,\"MEAN\":0.0697674418605,\"NILAI\":0.759267911942},\"BRI\":{\"VAL\":\"1\",\"STDEV\":0.292168644964,\"MEAN\":0.093023255814,\"NILAI\":0.00596264174792},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.1515988659,\"MEAN\":0.0232558139535,\"NILAI\":1.01242917452},\"TIDAK\":{\"VAL\":\"5\",\"STDEV\":1.56295171309,\"MEAN\":1.1976744186,\"NILAI\":0.0165453629318}},\"GAJI\":{\"PPA\":{\"VAL\":\"4\",\"STDEV\":16.832725844,\"MEAN\":10.4285714286,\"NILAI\":0.0903802501088},\"BBM\":{\"VAL\":\"9\",\"STDEV\":17.7703605559,\"MEAN\":10.6428571429,\"NILAI\":0.0942146919829},\"SUPERSEMAR\":{\"VAL\":\"2\",\"STDEV\":1.63915014163,\"MEAN\":1.07142857143,\"NILAI\":0.265354833311},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.937614461877,\"MEAN\":0.428571428571,\"NILAI\":0.371058402293},\"BRI\":{\"VAL\":\"1\",\"STDEV\":1.39858641351,\"MEAN\":0.571428571429,\"NILAI\":0.321801303382},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.363136519601,\"MEAN\":0.142857142857,\"NILAI\":0.612606496016},\"TIDAK\":{\"VAL\":\"11\",\"STDEV\":10.3448771629,\"MEAN\":7.35714285714,\"NILAI\":0.116555565499}},\"REKLISTRIK\":{\"PPA\":{\"VAL\":\"22\",\"STDEV\":9.35892481454,\"MEAN\":7.3,\"NILAI\":0.0379743788883},\"BBM\":{\"VAL\":\"9\",\"STDEV\":9.55028244278,\"MEAN\":7.45,\"NILAI\":0.127378085012},\"SUPERSEMAR\":{\"VAL\":\"2\",\"STDEV\":1.06992375528,\"MEAN\":0.75,\"NILAI\":0.194873489767},\"BI\":{\"VAL\":\"1\",\"STDEV\":0.571240570577,\"MEAN\":0.3,\"NILAI\":0.249081837398},\"BRI\":{\"VAL\":\"2\",\"STDEV\":0.680557047379,\"MEAN\":0.4,\"NILAI\":0.0304900678811},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.307793505626,\"MEAN\":0.1,\"NILAI\":0.681980344699},\"TIDAK\":{\"VAL\":\"9\",\"STDEV\":4.39227791279,\"MEAN\":5.15,\"NILAI\":0.12961024274}},\"JMLPIAGAM\":{\"PPA\":{\"VAL\":\"24\",\"TOTAL\":146,\"NILAI\":0.164383561644},\"BBM\":{\"VAL\":\"15\",\"TOTAL\":149,\"NILAI\":0.10067114094},\"SUPERSEMAR\":{\"VAL\":\"1\",\"TOTAL\":15,\"NILAI\":0.0666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"20\",\"TOTAL\":103,\"NILAI\":0.194174757282}},\"PROPOSALPKM\":{\"PPA\":{\"VAL\":\"146\",\"TOTAL\":146,\"NILAI\":1},\"BBM\":{\"VAL\":\"149\",\"TOTAL\":149,\"NILAI\":1},\"SUPERSEMAR\":{\"VAL\":\"15\",\"TOTAL\":15,\"NILAI\":1},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"0\",\"TOTAL\":103,\"NILAI\":0}},\"LIKELIHOOD\":{\"PPA\":3.60222844166e-6,\"BBM\":2.74052262242e-8,\"SUPERSEMAR\":0.000139346982024,\"BI\":0,\"BRI\":0,\"BTN\":0,\"TIDAK\":0},\"PROBABILITY\":{\"PPA\":{\"TOTAL\":0.000142976615692,\"NILAI\":0.0251945286593},\"BBM\":{\"TOTAL\":0.000142976615692,\"NILAI\":0.000191676282808},\"SUPERSEMAR\":{\"TOTAL\":0.000142976615692,\"NILAI\":0.974613795058},\"BI\":{\"TOTAL\":0.000142976615692,\"NILAI\":0},\"BRI\":{\"TOTAL\":0.000142976615692,\"NILAI\":0},\"BTN\":{\"TOTAL\":0.000142976615692,\"NILAI\":0},\"TIDAK\":{\"TOTAL\":0.000142976615692,\"NILAI\":0}},\"REKOMENDASI\":\"SUPERSEMAR\"}','SUPERSEMAR'),(9014,'{\"PRODI\":{\"PPA\":{\"VAL\":\"2\",\"TOTAL\":146,\"NILAI\":0.013698630136986},\"BBM\":{\"VAL\":\"7\",\"TOTAL\":149,\"NILAI\":0.046979865771812},\"SUPERSEMAR\":{\"VAL\":\"0\",\"TOTAL\":15,\"NILAI\":0},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"0\",\"TOTAL\":103,\"NILAI\":0}},\"SEMESTER\":{\"PPA\":{\"VAL\":\"0\",\"TOTAL\":146,\"NILAI\":0},\"BBM\":{\"VAL\":\"0\",\"TOTAL\":149,\"NILAI\":0},\"SUPERSEMAR\":{\"VAL\":\"0\",\"TOTAL\":15,\"NILAI\":0},\"BI\":{\"VAL\":\"1\",\"TOTAL\":6,\"NILAI\":0.16666666666667},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"0\",\"TOTAL\":103,\"NILAI\":0}},\"JENKEL\":{\"PPA\":{\"VAL\":\"88\",\"TOTAL\":146,\"NILAI\":0.6027397260274},\"BBM\":{\"VAL\":\"73\",\"TOTAL\":149,\"NILAI\":0.48993288590604},\"SUPERSEMAR\":{\"VAL\":\"7\",\"TOTAL\":15,\"NILAI\":0.46666666666667},\"BI\":{\"VAL\":\"3\",\"TOTAL\":6,\"NILAI\":0.5},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"26\",\"TOTAL\":103,\"NILAI\":0.25242718446602}},\"IPK\":{\"PPA\":{\"VAL\":\"2\",\"STDEV\":2.0353913769729,\"MEAN\":1.6976744186047,\"NILAI\":0.27650813586411},\"BBM\":{\"VAL\":\"0\",\"STDEV\":2.4370880338665,\"MEAN\":1.7325581395349,\"NILAI\":0.19844555360589},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":0.41136388543239,\"MEAN\":0.17441860465116,\"NILAI\":0.56842294020186},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.25624885305539,\"MEAN\":0.069767441860465,\"NILAI\":0.75926791194141},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.2921686449636,\"MEAN\":0.093023255813953,\"NILAI\":0.70144453791379},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.15159886590035,\"MEAN\":0.023255813953488,\"NILAI\":1.0124291745224},\"TIDAK\":{\"VAL\":\"2\",\"STDEV\":1.5629517130915,\"MEAN\":1.1976744186047,\"NILAI\":0.27965829891063}},\"GAJI\":{\"PPA\":{\"VAL\":\"1\",\"STDEV\":16.832725844041,\"MEAN\":10.428571428571,\"NILAI\":0.083102797207538},\"BBM\":{\"VAL\":\"0\",\"STDEV\":17.770360555873,\"MEAN\":10.642857142857,\"NILAI\":0.07908337079259},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":1.6391501416323,\"MEAN\":1.0714285714286,\"NILAI\":0.25161450892755},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.93761446187699,\"MEAN\":0.42857142857143,\"NILAI\":0.37105840229268},\"BRI\":{\"VAL\":\"0\",\"STDEV\":1.3985864135061,\"MEAN\":0.57142857142857,\"NILAI\":0.31026210210165},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.36313651960128,\"MEAN\":0.14285714285714,\"NILAI\":0.61260649601619},\"TIDAK\":{\"VAL\":\"0\",\"STDEV\":10.344877162948,\"MEAN\":7.3571428571429,\"NILAI\":0.096300768134727}},\"REKLISTRIK\":{\"PPA\":{\"VAL\":0,\"STDEV\":9.3589248145399,\"MEAN\":7.3,\"NILAI\":0.096182469271352},\"BBM\":{\"VAL\":0,\"STDEV\":9.5502824427784,\"MEAN\":7.45,\"NILAI\":0.095208239614861},\"SUPERSEMAR\":{\"VAL\":0,\"STDEV\":1.0699237552766,\"MEAN\":0.75,\"NILAI\":0.30160921421748},\"BI\":{\"VAL\":0,\"STDEV\":0.57124057057748,\"MEAN\":0.3,\"NILAI\":0.45975085929129},\"BRI\":{\"VAL\":0,\"STDEV\":0.68055704737872,\"MEAN\":0.4,\"NILAI\":0.40679528687077},\"BTN\":{\"VAL\":0,\"STDEV\":0.30779350562555,\"MEAN\":0.1,\"NILAI\":0.68198034469916},\"TIDAK\":{\"VAL\":0,\"STDEV\":4.3922779127872,\"MEAN\":5.15,\"NILAI\":0.095707720335518}},\"JMLPIAGAM\":{\"PPA\":{\"VAL\":\"1\",\"TOTAL\":146,\"NILAI\":0.0068493150684932},\"BBM\":{\"VAL\":\"0\",\"TOTAL\":149,\"NILAI\":0},\"SUPERSEMAR\":{\"VAL\":\"0\",\"TOTAL\":15,\"NILAI\":0},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"20\",\"TOTAL\":103,\"NILAI\":0.19417475728155}},\"PROPOSALPKM\":{\"PPA\":{\"VAL\":\"146\",\"TOTAL\":146,\"NILAI\":1},\"BBM\":{\"VAL\":\"149\",\"TOTAL\":149,\"NILAI\":1},\"SUPERSEMAR\":{\"VAL\":\"15\",\"TOTAL\":15,\"NILAI\":1},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"0\",\"TOTAL\":103,\"NILAI\":0}},\"LIKELIHOOD\":{\"PPA\":0,\"BBM\":0,\"SUPERSEMAR\":0,\"BI\":0,\"BRI\":0,\"BTN\":0,\"TIDAK\":0},\"PROBABILITY\":{\"PPA\":{\"TOTAL\":0,\"NILAI\":0},\"BBM\":{\"TOTAL\":0,\"NILAI\":0},\"SUPERSEMAR\":{\"TOTAL\":0,\"NILAI\":0},\"BI\":{\"TOTAL\":0,\"NILAI\":0},\"BRI\":{\"TOTAL\":0,\"NILAI\":0},\"BTN\":{\"TOTAL\":0,\"NILAI\":0},\"TIDAK\":{\"TOTAL\":0,\"NILAI\":0}},\"REKOMENDASI\":\"UNKNOWN\"}','UNKNOWN'),(9015,'{\"PRODI\":{\"PPA\":{\"VAL\":\"9\",\"TOTAL\":146,\"NILAI\":0.0616438356164},\"BBM\":{\"VAL\":\"10\",\"TOTAL\":149,\"NILAI\":0.0671140939597},\"SUPERSEMAR\":{\"VAL\":\"0\",\"TOTAL\":15,\"NILAI\":0},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"1\",\"TOTAL\":103,\"NILAI\":0.00970873786408}},\"SEMESTER\":{\"PPA\":{\"VAL\":\"51\",\"TOTAL\":146,\"NILAI\":0.349315068493},\"BBM\":{\"VAL\":\"73\",\"TOTAL\":149,\"NILAI\":0.489932885906},\"SUPERSEMAR\":{\"VAL\":\"2\",\"TOTAL\":15,\"NILAI\":0.133333333333},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"25\",\"TOTAL\":103,\"NILAI\":0.242718446602}},\"JENKEL\":{\"PPA\":{\"VAL\":\"58\",\"TOTAL\":146,\"NILAI\":0.397260273973},\"BBM\":{\"VAL\":\"76\",\"TOTAL\":149,\"NILAI\":0.510067114094},\"SUPERSEMAR\":{\"VAL\":\"8\",\"TOTAL\":15,\"NILAI\":0.533333333333},\"BI\":{\"VAL\":\"3\",\"TOTAL\":6,\"NILAI\":0.5},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"77\",\"TOTAL\":103,\"NILAI\":0.747572815534}},\"IPK\":{\"PPA\":{\"VAL\":0,\"STDEV\":2.03539137697,\"MEAN\":1.6976744186,\"NILAI\":0.197438812727},\"BBM\":{\"VAL\":0,\"STDEV\":2.43708803387,\"MEAN\":1.73255813953,\"NILAI\":0.198445553606},\"SUPERSEMAR\":{\"VAL\":0,\"STDEV\":0.411363885432,\"MEAN\":0.174418604651,\"NILAI\":0.568422940202},\"BI\":{\"VAL\":0,\"STDEV\":0.256248853055,\"MEAN\":0.0697674418605,\"NILAI\":0.759267911942},\"BRI\":{\"VAL\":0,\"STDEV\":0.292168644964,\"MEAN\":0.093023255814,\"NILAI\":0.701444537913},\"BTN\":{\"VAL\":0,\"STDEV\":0.1515988659,\"MEAN\":0.0232558139535,\"NILAI\":1.01242917452},\"TIDAK\":{\"VAL\":0,\"STDEV\":1.56295171309,\"MEAN\":1.1976744186,\"NILAI\":0.237870688922}},\"GAJI\":{\"PPA\":{\"VAL\":\"3\",\"STDEV\":16.832725844,\"MEAN\":10.4285714286,\"NILAI\":0.0881969711784},\"BBM\":{\"VAL\":\"3\",\"STDEV\":17.7703605559,\"MEAN\":10.6428571429,\"NILAI\":0.0862595521523},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":1.63915014163,\"MEAN\":1.07142857143,\"NILAI\":0.251614508927},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.937614461877,\"MEAN\":0.428571428571,\"NILAI\":0.371058402293},\"BRI\":{\"VAL\":\"0\",\"STDEV\":1.39858641351,\"MEAN\":0.571428571429,\"NILAI\":0.310262102101},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.363136519601,\"MEAN\":0.142857142857,\"NILAI\":0.612606496016},\"TIDAK\":{\"VAL\":\"0\",\"STDEV\":10.3448771629,\"MEAN\":7.35714285714,\"NILAI\":0.0963007681347}},\"REKLISTRIK\":{\"PPA\":{\"VAL\":0,\"STDEV\":9.35892481454,\"MEAN\":7.3,\"NILAI\":0.0961824692714},\"BBM\":{\"VAL\":0,\"STDEV\":9.55028244278,\"MEAN\":7.45,\"NILAI\":0.0952082396149},\"SUPERSEMAR\":{\"VAL\":0,\"STDEV\":1.06992375528,\"MEAN\":0.75,\"NILAI\":0.301609214217},\"BI\":{\"VAL\":0,\"STDEV\":0.571240570577,\"MEAN\":0.3,\"NILAI\":0.459750859291},\"BRI\":{\"VAL\":0,\"STDEV\":0.680557047379,\"MEAN\":0.4,\"NILAI\":0.406795286871},\"BTN\":{\"VAL\":0,\"STDEV\":0.307793505626,\"MEAN\":0.1,\"NILAI\":0.681980344699},\"TIDAK\":{\"VAL\":0,\"STDEV\":4.39227791279,\"MEAN\":5.15,\"NILAI\":0.0957077203356}},\"JMLPIAGAM\":{\"PPA\":{\"VAL\":\"40\",\"TOTAL\":146,\"NILAI\":0.27397260274},\"BBM\":{\"VAL\":\"51\",\"TOTAL\":149,\"NILAI\":0.342281879195},\"SUPERSEMAR\":{\"VAL\":\"0\",\"TOTAL\":15,\"NILAI\":0},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"13\",\"TOTAL\":103,\"NILAI\":0.126213592233}},\"PROPOSALPKM\":{\"PPA\":{\"VAL\":\"0\",\"TOTAL\":146,\"NILAI\":0},\"BBM\":{\"VAL\":\"0\",\"TOTAL\":149,\"NILAI\":0},\"SUPERSEMAR\":{\"VAL\":\"0\",\"TOTAL\":15,\"NILAI\":0},\"BI\":{\"VAL\":\"6\",\"TOTAL\":6,\"NILAI\":1},\"BRI\":{\"VAL\":\"8\",\"TOTAL\":8,\"NILAI\":1},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"103\",\"TOTAL\":103,\"NILAI\":1}},\"LIKELIHOOD\":{\"PPA\":0,\"BBM\":0,\"SUPERSEMAR\":0,\"BI\":0,\"BRI\":0,\"BTN\":0,\"TIDAK\":4.87464328836e-7},\"PROBABILITY\":{\"PPA\":{\"TOTAL\":4.87464328836e-7,\"NILAI\":0},\"BBM\":{\"TOTAL\":4.87464328836e-7,\"NILAI\":0},\"SUPERSEMAR\":{\"TOTAL\":4.87464328836e-7,\"NILAI\":0},\"BI\":{\"TOTAL\":4.87464328836e-7,\"NILAI\":0},\"BRI\":{\"TOTAL\":4.87464328836e-7,\"NILAI\":0},\"BTN\":{\"TOTAL\":4.87464328836e-7,\"NILAI\":0},\"TIDAK\":{\"TOTAL\":4.87464328836e-7,\"NILAI\":1}},\"REKOMENDASI\":\"TIDAK\"}','TIDAK'),(9016,'{\"PRODI\":{\"PPA\":{\"VAL\":\"17\",\"TOTAL\":146,\"NILAI\":0.116438356164},\"BBM\":{\"VAL\":\"19\",\"TOTAL\":149,\"NILAI\":0.127516778523},\"SUPERSEMAR\":{\"VAL\":\"5\",\"TOTAL\":15,\"NILAI\":0.333333333333},\"BI\":{\"VAL\":\"2\",\"TOTAL\":6,\"NILAI\":0.333333333333},\"BRI\":{\"VAL\":\"1\",\"TOTAL\":8,\"NILAI\":0.125},\"BTN\":{\"VAL\":\"1\",\"TOTAL\":2,\"NILAI\":0.5},\"TIDAK\":{\"VAL\":\"39\",\"TOTAL\":103,\"NILAI\":0.378640776699}},\"SEMESTER\":{\"PPA\":{\"VAL\":\"59\",\"TOTAL\":146,\"NILAI\":0.404109589041},\"BBM\":{\"VAL\":\"53\",\"TOTAL\":149,\"NILAI\":0.355704697987},\"SUPERSEMAR\":{\"VAL\":\"10\",\"TOTAL\":15,\"NILAI\":0.666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"41\",\"TOTAL\":103,\"NILAI\":0.398058252427}},\"JENKEL\":{\"PPA\":{\"VAL\":\"58\",\"TOTAL\":146,\"NILAI\":0.397260273973},\"BBM\":{\"VAL\":\"76\",\"TOTAL\":149,\"NILAI\":0.510067114094},\"SUPERSEMAR\":{\"VAL\":\"8\",\"TOTAL\":15,\"NILAI\":0.533333333333},\"BI\":{\"VAL\":\"3\",\"TOTAL\":6,\"NILAI\":0.5},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"2\",\"TOTAL\":2,\"NILAI\":1},\"TIDAK\":{\"VAL\":\"77\",\"TOTAL\":103,\"NILAI\":0.747572815534}},\"IPK\":{\"PPA\":{\"VAL\":\"3\",\"STDEV\":2.03539137697,\"MEAN\":1.6976744186,\"NILAI\":0.227824050421},\"BBM\":{\"VAL\":\"1\",\"STDEV\":2.43708803387,\"MEAN\":1.73255813953,\"NILAI\":0.244212115245},\"SUPERSEMAR\":{\"VAL\":\"0\",\"STDEV\":0.411363885432,\"MEAN\":0.174418604651,\"NILAI\":0.568422940202},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.256248853055,\"MEAN\":0.0697674418605,\"NILAI\":0.759267911942},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.292168644964,\"MEAN\":0.093023255814,\"NILAI\":0.701444537913},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.1515988659,\"MEAN\":0.0232558139535,\"NILAI\":1.01242917452},\"TIDAK\":{\"VAL\":\"0\",\"STDEV\":1.56295171309,\"MEAN\":1.1976744186,\"NILAI\":0.237870688922}},\"GAJI\":{\"PPA\":{\"VAL\":\"4\",\"STDEV\":16.832725844,\"MEAN\":10.4285714286,\"NILAI\":0.0903802501088},\"BBM\":{\"VAL\":\"9\",\"STDEV\":17.7703605559,\"MEAN\":10.6428571429,\"NILAI\":0.0942146919829},\"SUPERSEMAR\":{\"VAL\":\"2\",\"STDEV\":1.63915014163,\"MEAN\":1.07142857143,\"NILAI\":0.265354833311},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.937614461877,\"MEAN\":0.428571428571,\"NILAI\":0.371058402293},\"BRI\":{\"VAL\":\"1\",\"STDEV\":1.39858641351,\"MEAN\":0.571428571429,\"NILAI\":0.321801303382},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.363136519601,\"MEAN\":0.142857142857,\"NILAI\":0.612606496016},\"TIDAK\":{\"VAL\":\"11\",\"STDEV\":10.3448771629,\"MEAN\":7.35714285714,\"NILAI\":0.116555565499}},\"REKLISTRIK\":{\"PPA\":{\"VAL\":0,\"STDEV\":9.35892481454,\"MEAN\":7.3,\"NILAI\":0.0961824692714},\"BBM\":{\"VAL\":0,\"STDEV\":9.55028244278,\"MEAN\":7.45,\"NILAI\":0.0952082396149},\"SUPERSEMAR\":{\"VAL\":0,\"STDEV\":1.06992375528,\"MEAN\":0.75,\"NILAI\":0.301609214217},\"BI\":{\"VAL\":0,\"STDEV\":0.571240570577,\"MEAN\":0.3,\"NILAI\":0.459750859291},\"BRI\":{\"VAL\":0,\"STDEV\":0.680557047379,\"MEAN\":0.4,\"NILAI\":0.406795286871},\"BTN\":{\"VAL\":0,\"STDEV\":0.307793505626,\"MEAN\":0.1,\"NILAI\":0.681980344699},\"TIDAK\":{\"VAL\":0,\"STDEV\":4.39227791279,\"MEAN\":5.15,\"NILAI\":0.0957077203356}},\"JMLPIAGAM\":{\"PPA\":{\"VAL\":\"5\",\"TOTAL\":146,\"NILAI\":0.0342465753425},\"BBM\":{\"VAL\":\"4\",\"TOTAL\":149,\"NILAI\":0.0268456375839},\"SUPERSEMAR\":{\"VAL\":\"1\",\"TOTAL\":15,\"NILAI\":0.0666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"41\",\"TOTAL\":103,\"NILAI\":0.398058252427}},\"PROPOSALPKM\":{\"PPA\":{\"VAL\":\"146\",\"TOTAL\":146,\"NILAI\":1},\"BBM\":{\"VAL\":\"149\",\"TOTAL\":149,\"NILAI\":1},\"SUPERSEMAR\":{\"VAL\":\"15\",\"TOTAL\":15,\"NILAI\":1},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"0\",\"TOTAL\":103,\"NILAI\":0}},\"LIKELIHOOD\":{\"PPA\":1.2678169035e-6,\"BBM\":1.3605620517e-6,\"SUPERSEMAR\":0.000359449728148,\"BI\":0,\"BRI\":0,\"BTN\":0,\"TIDAK\":0},\"PROBABILITY\":{\"PPA\":{\"TOTAL\":0.000362078107103,\"NILAI\":0.00350150113644},\"BBM\":{\"TOTAL\":0.000362078107103,\"NILAI\":0.00375764793565},\"SUPERSEMAR\":{\"TOTAL\":0.000362078107103,\"NILAI\":0.992740850928},\"BI\":{\"TOTAL\":0.000362078107103,\"NILAI\":0},\"BRI\":{\"TOTAL\":0.000362078107103,\"NILAI\":0},\"BTN\":{\"TOTAL\":0.000362078107103,\"NILAI\":0},\"TIDAK\":{\"TOTAL\":0.000362078107103,\"NILAI\":0}},\"REKOMENDASI\":\"SUPERSEMAR\"}','SUPERSEMAR'),(9017,'{\"PRODI\":{\"PPA\":{\"VAL\":\"32\",\"TOTAL\":146,\"NILAI\":0.219178082192},\"BBM\":{\"VAL\":\"29\",\"TOTAL\":149,\"NILAI\":0.194630872483},\"SUPERSEMAR\":{\"VAL\":\"5\",\"TOTAL\":15,\"NILAI\":0.333333333333},\"BI\":{\"VAL\":\"1\",\"TOTAL\":6,\"NILAI\":0.166666666667},\"BRI\":{\"VAL\":\"3\",\"TOTAL\":8,\"NILAI\":0.375},\"BTN\":{\"VAL\":\"1\",\"TOTAL\":2,\"NILAI\":0.5},\"TIDAK\":{\"VAL\":\"28\",\"TOTAL\":103,\"NILAI\":0.271844660194}},\"SEMESTER\":{\"PPA\":{\"VAL\":\"59\",\"TOTAL\":146,\"NILAI\":0.404109589041},\"BBM\":{\"VAL\":\"53\",\"TOTAL\":149,\"NILAI\":0.355704697987},\"SUPERSEMAR\":{\"VAL\":\"10\",\"TOTAL\":15,\"NILAI\":0.666666666667},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"41\",\"TOTAL\":103,\"NILAI\":0.398058252427}},\"JENKEL\":{\"PPA\":{\"VAL\":\"88\",\"TOTAL\":146,\"NILAI\":0.602739726027},\"BBM\":{\"VAL\":\"73\",\"TOTAL\":149,\"NILAI\":0.489932885906},\"SUPERSEMAR\":{\"VAL\":\"7\",\"TOTAL\":15,\"NILAI\":0.466666666667},\"BI\":{\"VAL\":\"3\",\"TOTAL\":6,\"NILAI\":0.5},\"BRI\":{\"VAL\":\"4\",\"TOTAL\":8,\"NILAI\":0.5},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"26\",\"TOTAL\":103,\"NILAI\":0.252427184466}},\"IPK\":{\"PPA\":{\"VAL\":\"0\",\"STDEV\":2.03539137697,\"MEAN\":1.6976744186,\"NILAI\":0.197438812727},\"BBM\":{\"VAL\":\"0\",\"STDEV\":2.43708803387,\"MEAN\":1.73255813953,\"NILAI\":0.198445553606},\"SUPERSEMAR\":{\"VAL\":\"1\",\"STDEV\":0.411363885432,\"MEAN\":0.174418604651,\"NILAI\":0.0830012820258},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.256248853055,\"MEAN\":0.0697674418605,\"NILAI\":0.759267911942},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.292168644964,\"MEAN\":0.093023255814,\"NILAI\":0.701444537913},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.1515988659,\"MEAN\":0.0232558139535,\"NILAI\":1.01242917452},\"TIDAK\":{\"VAL\":\"0\",\"STDEV\":1.56295171309,\"MEAN\":1.1976744186,\"NILAI\":0.237870688922}},\"GAJI\":{\"PPA\":{\"VAL\":\"2\",\"STDEV\":16.832725844,\"MEAN\":10.4285714286,\"NILAI\":0.0857632121984},\"BBM\":{\"VAL\":\"1\",\"STDEV\":17.7703605559,\"MEAN\":10.6428571429,\"NILAI\":0.081664717356},\"SUPERSEMAR\":{\"VAL\":\"5\",\"STDEV\":1.63915014163,\"MEAN\":1.07142857143,\"NILAI\":0.017626641555},\"BI\":{\"VAL\":\"2\",\"STDEV\":0.937614461877,\"MEAN\":0.428571428571,\"NILAI\":0.101125211697},\"BRI\":{\"VAL\":\"0\",\"STDEV\":1.39858641351,\"MEAN\":0.571428571429,\"NILAI\":0.310262102101},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.363136519601,\"MEAN\":0.142857142857,\"NILAI\":0.612606496016},\"TIDAK\":{\"VAL\":\"6\",\"STDEV\":10.3448771629,\"MEAN\":7.35714285714,\"NILAI\":0.122948360019}},\"REKLISTRIK\":{\"PPA\":{\"VAL\":\"0\",\"STDEV\":9.35892481454,\"MEAN\":7.3,\"NILAI\":0.0961824692714},\"BBM\":{\"VAL\":\"0\",\"STDEV\":9.55028244278,\"MEAN\":7.45,\"NILAI\":0.0952082396149},\"SUPERSEMAR\":{\"VAL\":\"1\",\"STDEV\":1.06992375528,\"MEAN\":0.75,\"NILAI\":0.375223928862},\"BI\":{\"VAL\":\"0\",\"STDEV\":0.571240570577,\"MEAN\":0.3,\"NILAI\":0.459750859291},\"BRI\":{\"VAL\":\"0\",\"STDEV\":0.680557047379,\"MEAN\":0.4,\"NILAI\":0.406795286871},\"BTN\":{\"VAL\":\"0\",\"STDEV\":0.307793505626,\"MEAN\":0.1,\"NILAI\":0.681980344699},\"TIDAK\":{\"VAL\":\"14\",\"STDEV\":4.39227791279,\"MEAN\":5.15,\"NILAI\":0.0249976268294}},\"JMLPIAGAM\":{\"PPA\":{\"VAL\":\"49\",\"TOTAL\":146,\"NILAI\":0.335616438356},\"BBM\":{\"VAL\":\"39\",\"TOTAL\":149,\"NILAI\":0.261744966443},\"SUPERSEMAR\":{\"VAL\":\"3\",\"TOTAL\":15,\"NILAI\":0.2},\"BI\":{\"VAL\":\"5\",\"TOTAL\":6,\"NILAI\":0.833333333333},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"8\",\"TOTAL\":103,\"NILAI\":0.0776699029126}},\"PROPOSALPKM\":{\"PPA\":{\"VAL\":\"146\",\"TOTAL\":146,\"NILAI\":1},\"BBM\":{\"VAL\":\"149\",\"TOTAL\":149,\"NILAI\":1},\"SUPERSEMAR\":{\"VAL\":\"15\",\"TOTAL\":15,\"NILAI\":1},\"BI\":{\"VAL\":\"0\",\"TOTAL\":6,\"NILAI\":0},\"BRI\":{\"VAL\":\"0\",\"TOTAL\":8,\"NILAI\":0},\"BTN\":{\"VAL\":\"0\",\"TOTAL\":2,\"NILAI\":0},\"TIDAK\":{\"VAL\":\"0\",\"TOTAL\":103,\"NILAI\":0}},\"LIKELIHOOD\":{\"PPA\":2.91809086501e-5,\"BBM\":1.36982986985e-5,\"SUPERSEMAR\":1.13859471306e-5,\"BI\":0,\"BRI\":0,\"BTN\":0,\"TIDAK\":0},\"PROBABILITY\":{\"PPA\":{\"TOTAL\":5.42651544791e-5,\"NILAI\":0.537746716658},\"BBM\":{\"TOTAL\":5.42651544791e-5,\"NILAI\":0.252432685946},\"SUPERSEMAR\":{\"TOTAL\":5.42651544791e-5,\"NILAI\":0.209820597396},\"BI\":{\"TOTAL\":5.42651544791e-5,\"NILAI\":0},\"BRI\":{\"TOTAL\":5.42651544791e-5,\"NILAI\":0},\"BTN\":{\"TOTAL\":5.42651544791e-5,\"NILAI\":0},\"TIDAK\":{\"TOTAL\":5.42651544791e-5,\"NILAI\":0}},\"REKOMENDASI\":\"PPA\"}','PPA');
/*!40000 ALTER TABLE `mila_rekomendasi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mila_sample`
--
DROP TABLE IF EXISTS `mila_sample`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mila_sample` (
`ID` int(10) NOT NULL,
`NIM` int(20) NOT NULL,
`NAMA` varchar(50) NOT NULL,
`PRODI` int(4) NOT NULL,
`JURUSAN` int(4) NOT NULL,
`IPK` float NOT NULL,
`GAJI` int(10) NOT NULL,
`SEMESTER` int(2) NOT NULL,
`JENKEL` enum('L','P') NOT NULL DEFAULT 'L',
`REKLISTRIK` int(20) NOT NULL,
`JMLPIAGAM` int(3) NOT NULL,
`PROPOSALPKM` enum('Y','T') NOT NULL DEFAULT 'T',
`BEASISWA` int(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mila_sample`
--
LOCK TABLES `mila_sample` WRITE;
/*!40000 ALTER TABLE `mila_sample` DISABLE KEYS */;
INSERT INTO `mila_sample` (`ID`, `NIM`, `NAMA`, `PRODI`, `JURUSAN`, `IPK`, `GAJI`, `SEMESTER`, `JENKEL`, `REKLISTRIK`, `JMLPIAGAM`, `PROPOSALPKM`, `BEASISWA`) VALUES (1,85514067,'AHMIR\'ATUL MU\'MININ',1,1,3.52,3500000,4,'L',180000,5,'Y',1),(2,85514024,'NURUL AISYAH',1,1,3.51,1000000,4,'P',100000,5,'Y',1),(3,85514085,'AYU SARWENDAH',1,1,3.48,1000000,4,'P',70000,2,'T',0),(4,75413004,'Nanda Kurnia Akbar',2,1,3.46,1000000,6,'L',70000,6,'Y',1),(5,85514061,'Ary Surya Pranata',1,1,3.36,3000000,4,'L',135000,1,'T',0),(6,65514017,'Fitria Rahmawati',1,1,3.36,2500000,8,'P',120000,3,'Y',1),(7,85514048,'Indrawan Zainudin',1,1,3.34,2500000,4,'L',130000,2,'T',0),(8,85623242,'Eko Hadi Asputro',2,1,3.33,1000000,4,'L',80000,3,'Y',1),(9,85623039,'Sovia Ratna H',2,1,3.32,3000000,4,'P',70000,4,'Y',1),(10,85514034,'Ratna Prabowowati',1,1,3.3,1000000,4,'P',50000,5,'Y',1),(11,85514066,'Ifandi Rahmad S',1,1,3.29,3000000,4,'L',120000,2,'T',0),(12,85514073,'Asif Aulia al ula',1,1,3.29,750000,4,'P',40000,4,'Y',1),(13,75413008,'Nurun Nuchbah',2,1,3.28,2500000,6,'P',50000,6,'Y',1),(14,85514071,'Imam Hozali',1,1,3.28,3000000,4,'L',80000,1,'T',0),(15,85613049,'Puspita Aritias A',2,1,3.27,750000,4,'P',20000,2,'Y',1),(16,65514009,'Intan Kusuma W.',1,1,3.27,2500000,8,'P',50000,3,'Y',1),(17,85514086,'Ayu Zulaikha H.',1,1,3.26,1000000,4,'P',50000,4,'Y',1),(18,85514078,'Dzikrullah Fahmi Irawan',1,1,3.26,1000000,4,'L',50000,2,'T',0),(19,85623255,'Andri Istanaya',2,1,3.25,750000,4,'P',60000,5,'Y',1),(20,75514238,'Nadhiro Nurdjannah',1,1,3.25,500000,6,'P',30000,6,'Y',1),(21,65514217,'Bhayu Angga',1,1,3.23,1000000,8,'L',70000,2,'T',0),(22,85514044,'Emilya Ulfah C.',1,1,3.23,1500000,4,'P',70000,4,'Y',1),(23,65514029,'Suwarno Arieska',1,1,3.23,2500000,8,'L',100000,3,'T',0),(24,85623029,'Pebrian Yonas S',2,1,3.23,1000000,4,'L',130000,5,'Y',1),(25,65514021,'Narto Pujiatmiko',1,1,3.21,1000000,8,'L',100000,1,'T',0),(26,65514219,'Sulistyaningrum',1,1,3.21,1000000,8,'P',100000,4,'Y',1),(27,85623260,'Rahmawati Ardhini',2,1,3.21,2500000,4,'P',120000,4,'Y',1),(28,85514087,'Terdi Kristofer',1,1,3.21,2500000,4,'L',180000,4,'T',0),(29,85623012,'Fitra Rangga Yudha',2,1,3.18,1000000,4,'L',130000,3,'Y',1),(30,85623035,'Rifki Alfi A',2,1,3.18,1000000,4,'L',70000,3,'Y',1),(31,75413038,'Ratna Dewi Pahlevi',2,1,3.17,1000000,6,'P',80000,3,'Y',1),(32,85623039,'Elysabeth Rahayu',2,1,3.15,3500000,4,'P',80000,2,'Y',1),(33,75514207,'Kadek Pupitarini Putri',1,1,3.15,1000000,6,'P',100000,4,'Y',1),(34,65514047,'Eko Fahrudin',1,1,3.15,1000000,8,'L',80000,1,'T',0),(35,75514041,'Dwi Sulastanto',1,1,3.15,1000000,6,'L',70000,1,'T',0),(36,65514043,'Bagus Krisviandik',1,1,3.14,500000,8,'L',40000,5,'Y',1),(37,85514018,'A. Mujibur Rokhman',1,1,3.14,2000000,4,'L',50000,4,'T',0),(38,75413099,'Mahendra Redi W',2,1,3.14,1000000,6,'L',70000,4,'Y',1),(39,65514073,'Rendy Satria Pradana',1,1,3.14,2000000,8,'L',70000,2,'T',0),(40,65514077,'Achmad Yusuf',1,1,3.14,2500000,8,'L',20000,2,'T',0),(41,65514074,'Teguh Wicaksono',1,1,3.14,2500000,8,'L',200000,2,'T',0),(42,75514201,'Maria Ika',1,1,3.13,1000000,6,'P',80000,5,'Y',1),(43,85623006,'Bima Kharisma',2,1,3.13,1200000,4,'L',180000,5,'Y',1),(44,85623037,'Januar Arif R',2,1,3.12,1000000,4,'L',60000,5,'Y',1),(45,65514022,'Franklyn Hanki Septiyan',1,1,3.11,2500000,8,'L',130000,3,'T',0),(46,65514019,'Evan Agung Permadi',2,1,3.1,500000,8,'L',40000,5,'Y',1),(47,75514004,'Dewi Syafitri',1,1,3.08,1000000,6,'P',60000,6,'Y',1),(48,65514033,'Alfana Fitria',1,1,3.08,1000000,8,'P',70000,6,'Y',1),(49,65514023,'Radhi Nur Wulan Aziz',1,1,3.07,500000,8,'P',30000,6,'Y',1),(50,85514084,'Agus Setyono',1,1,3.07,2500000,4,'L',120000,4,'T',0),(51,75514062,'Rangga Andika',1,1,3.05,1000000,6,'L',80000,2,'T',0),(52,75514246,'Fuquh Prasetyo',1,1,3.03,1500000,6,'L',180000,1,'T',0),(53,75413201,'Aditya Esa P',2,1,3.03,1000000,6,'L',130000,3,'Y',1),(54,65514220,'Adhitya Irmayanti',1,1,3.02,3000000,8,'P',180000,5,'Y',1),(55,65514215,'Ariantono',1,1,3.02,2500000,8,'L',250000,1,'T',0),(56,85623045,'Suprayitno',2,1,3.02,2500000,4,'L',100000,4,'Y',1),(57,85524062,'David Samson Huda',3,1,3.36,1000000,4,'L',70000,2,'T',0),(58,85524034,'Jumadi',3,1,3.36,1000000,4,'L',70000,2,'T',0),(59,85524050,'Ika Nur Jannah',3,1,3.35,1000000,4,'P',80000,5,'Y',1),(60,85423012,'Rio Fredianto',4,1,3.31,750000,4,'L',30000,5,'Y',1),(61,85524075,'Tri Wijayanti',3,1,3.3,1000000,4,'P',40000,5,'Y',1),(62,75524027,'Achmad Susanto',3,1,3.29,500000,6,'L',80000,3,'T',0),(63,75524033,'Redy Ardiansyah',3,1,3.25,750000,6,'L',40000,2,'T',0),(64,65524012,'Arie Priambodo',3,1,3.25,2500000,8,'L',70000,1,'T',0),(65,75524006,'Nungky Sukmaningtyas',3,1,3.24,750000,6,'P',40000,4,'Y',1),(66,85524248,'Nanang Romadhoni',3,1,3.23,2500000,4,'L',80000,5,'Y',1),(67,65524203,'M. Khoirul Amin',3,1,3.22,1000000,8,'L',70000,6,'Y',1),(68,65524035,'Adi Irawan',3,1,3.22,1000000,8,'L',60000,6,'Y',1),(69,65524214,'Saiful Arif',3,1,3.22,2500000,8,'L',120000,6,'Y',1),(70,75524028,'Ja\'far Shodiq',3,1,3.2,500000,6,'L',30000,5,'Y',1),(71,65524057,'Renika Wahyu S',3,1,3.2,1000000,8,'P',100000,2,'T',0),(72,85524027,'Muhammad Warsiur',3,1,3.2,2500000,4,'L',100000,2,'T',0),(73,65524044,'Siswati Oktavia',3,1,3.2,1000000,8,'P',60000,4,'Y',1),(74,65524032,'Indra Kurniawan',3,1,3.19,1000000,8,'L',50000,5,'Y',1),(75,65524070,'Wahyu Satria Bhakti',3,1,3.17,1000000,8,'L',50000,6,'Y',1),(76,75524208,'Agus Purwanto',3,1,3.17,1000000,6,'L',50000,5,'Y',1),(77,65524062,'Candra Mega Putra',3,1,3.17,1000000,8,'L',30000,4,'Y',1),(78,65524026,'Angga Prima Setya',3,1,3.17,2500000,8,'L',100000,4,'Y',1),(79,75524046,'Indra Irawan',3,1,3.16,250000,6,'L',40000,4,'Y',1),(80,85524065,'Handini Novita Sari',3,1,3.16,1000000,4,'P',50000,3,'Y',1),(81,75524054,'Tulus Budi Hartoyo',3,1,3.15,500000,6,'L',50000,3,'Y',1),(82,75423207,'Muksin Saiful Alfarokh',4,1,3.14,500000,6,'L',40000,5,'Y',1),(83,75524037,'M. Husnul Haris',3,1,3.13,250000,6,'L',120000,2,'T',0),(84,75524213,'Rina Sugiarti',3,1,3.13,250000,6,'P',120000,4,'Y',1),(85,65524229,'Kartika Febiola C.Y',3,1,3.13,2000000,8,'P',180000,3,'T',0),(86,65524030,'Ammufarrih',3,1,3.13,500000,8,'L',80000,4,'Y',1),(87,65524233,'Agus Rahmad Senoaji',3,1,3.13,750000,8,'L',70000,5,'Y',1),(88,75524064,'Hassanudin',3,1,3.12,1000000,6,'L',70000,6,'Y',1),(89,65524014,'Wahyu Robby Cahyadi',3,1,3.12,1000000,8,'L',60000,4,'Y',1),(90,75524014,'Wiwid Suria Rahmawaty',3,1,3.11,1000000,6,'P',60000,4,'Y',1),(91,85524236,'Ulil Hidayah',3,1,3.11,1000000,4,'P',60000,4,'Y',1),(92,85423209,'Raihul Asdiq',4,1,3.1,2500000,4,'L',50000,5,'Y',1),(93,75423212,'Bayu Nur Edy',4,1,3.1,500000,6,'L',50000,5,'Y',1),(94,75423033,'Prayoga Hendra Lesmana',4,1,3.1,1000000,6,'L',70000,5,'Y',1),(95,65524009,'M. Farrich Mas\'ud',3,1,3.09,3000000,8,'L',120000,2,'T',0),(96,75524055,'Dedi Fachrudin',3,1,3.08,7500000,6,'L',300000,2,'T',0),(97,75423015,'Ferdiansyah',4,1,3.08,1000000,6,'L',80000,1,'Y',1),(98,65524015,'Sulihan',3,1,3.07,5000000,8,'L',350000,1,'T',0),(99,85524031,'Dwi Ayu Fariska',3,1,3.07,2000000,4,'P',120000,3,'Y',1),(100,75524072,'M. Mafhfud M.A',3,1,3.07,250000,6,'L',80000,5,'T',0),(101,85524013,'M. Sulaiman',3,1,3.07,3000000,4,'L',180000,3,'T',0),(102,85524203,'Kuntang Winangun',3,1,3.07,2500000,4,'L',200000,3,'T',0),(103,65524024,'Rengga Wahy Pratama',3,1,3.06,2500000,8,'L',80000,4,'Y',1),(104,75423107,'Puji Kristiono',4,1,3.06,750000,6,'L',40000,5,'Y',1),(105,65524033,'Samsul Hadi',3,1,3.05,1000000,8,'L',40000,6,'Y',1),(106,65524209,'Sulistyo Saputra U',3,1,3.04,1000000,8,'L',50000,5,'Y',1),(107,75524009,'Idris Hadi Firmansyah',3,1,3.04,1000000,6,'L',50000,5,'Y',1),(108,65524011,'Pebri Eko Pranoto',3,1,3.03,1000000,8,'L',60000,5,'Y',1),(109,65524211,'Eko Suprianto',3,1,3.02,2500000,8,'L',70000,5,'Y',1),(110,65524064,'Andrian Setya Cholis',3,1,3.02,5000000,8,'L',200000,2,'T',0),(111,75524069,'Yulizar Qhodavi',3,1,3.02,500000,6,'L',40000,4,'Y',1),(112,85423240,'M. Agus Winarto',4,1,3,2500000,4,'L',80000,6,'Y',1),(113,85534054,'Berkat Cipta Zega',5,1,3.65,1000000,4,'L',100000,5,'Y',1),(114,85534051,'Citra Nurmalita',5,1,3.5,1000000,4,'P',70000,6,'Y',1),(115,85433221,'Ari Agus Tajudin',6,1,3.49,1000000,4,'L',70000,6,'Y',1),(116,75433207,'Feri Sabta Pinga D',6,1,3.44,500000,6,'L',40000,6,'Y',1),(117,75433001,'Nina Isnawati',6,1,3.43,750000,6,'P',30000,6,'Y',1),(118,75593201,'Ettis Haditiansyah',6,1,3.41,500000,6,'P',30000,6,'Y',1),(119,85534055,'Arif Nurul Hindayati',5,1,3.41,1000000,4,'P',100000,6,'Y',1),(120,85433001,'Nurika Pratama Putri',5,1,3.4,1000000,4,'P',80000,6,'Y',1),(121,75433004,'Dessy Arie Setyawan',6,1,3.39,500000,6,'L',20000,5,'Y',1),(122,85534214,'Fitri Rohmah W',5,1,3.39,1000000,4,'P',40000,4,'Y',1),(123,75534006,'Miftachul Huda',5,1,3.35,5000000,6,'L',200000,2,'T',0),(124,75534002,'R. Endro Wibisono',5,1,3.35,1000000,6,'L',50000,3,'Y',1),(125,65534008,'Kurnia Hadi Putra',5,1,3.32,2500000,8,'L',120000,4,'Y',1),(126,85534014,'Risky Afif Azhari',5,1,3.31,2000000,4,'L',200000,3,'T',0),(127,75433014,'Hariez Wahyu A',6,1,3.31,500000,6,'L',50000,2,'Y',1),(128,75433013,'Indri Hapsari',6,1,3.3,2500000,6,'P',30000,2,'Y',1),(129,85433213,'Jumiaty',5,1,3.29,2500000,4,'P',40000,3,'Y',1),(130,65534001,'Shelly Anggraeni',5,1,3.29,2500000,8,'P',60000,4,'Y',1),(131,75534007,'Sugito',5,1,3.28,250000,6,'L',60000,4,'Y',1),(132,65534208,'Lutfi Saiful Akbar',5,1,3.27,2500000,8,'L',40000,4,'Y',1),(133,85534001,'Sita Resmi Puspita H',5,1,3.26,2500000,4,'P',100000,4,'Y',1),(134,85433003,'Siti Wahyuni R',5,1,3.22,2500000,4,'P',130000,4,'T',0),(135,85433207,'Dita Anggraini',5,1,3.22,2500000,4,'P',100000,4,'Y',1),(136,85534210,'Avilatus Sa\'adha',5,1,3.2,1000000,4,'P',80000,3,'Y',1),(137,85433008,'Cipto Roso',6,1,3.18,1000000,4,'L',80000,3,'Y',1),(138,75534037,'M. Rifki Mubarok',5,1,3.13,500000,6,'L',50000,3,'T',0),(139,75534051,'Windy Kusumaning T',5,1,3.13,250000,6,'P',50000,3,'Y',1),(140,75534010,'Bagus Setyo W',5,1,3.12,250000,6,'L',80000,4,'T',0),(141,75433201,'Fitra Budi W',6,1,3.12,500000,6,'L',70000,5,'Y',1),(142,85433216,'Dhesy Anggraeni',5,1,3.12,750000,4,'P',70000,5,'Y',1),(143,75534026,'Setiadi',5,1,3.11,500000,6,'L',60000,5,'Y',1),(144,75534204,'Arif Wahyudin',5,1,3.09,500000,6,'L',60000,5,'Y',1),(145,75534016,'Intan Mayasari',5,1,3.07,500000,6,'P',60000,5,'Y',1),(146,75534201,'Febri Puspa Eka',5,1,3.02,250000,6,'P',50000,5,'Y',1),(147,65534036,'M. Naofal Z',5,1,3,1000000,8,'L',50000,5,'Y',1),(148,85544116,'Asma\'ul Sama Suwitain',7,1,3.61,1000000,4,'P',80000,5,'Y',1),(149,85544050,'Indah Nursery',7,1,3.52,800000,4,'P',80000,5,'Y',1),(150,75544215,'Ismayanti',7,1,3.49,500000,6,'P',70000,5,'Y',1),(151,65544021,'Dindy Sinta M',7,1,3.47,2500000,8,'P',80000,6,'Y',1),(152,75544060,'Wijayanti Puspa Rima',7,1,3.46,250000,4,'P',50000,5,'Y',1),(153,65544223,'Biyan Yesi W',7,1,3.45,800000,8,'P',50000,5,'Y',1),(154,85544056,'Arif Nur Cahyani',7,1,3.42,1000000,4,'P',100000,6,'Y',1),(155,75544083,'Yunita N',7,1,3.42,5000000,6,'P',300000,4,'T',0),(156,85544131,'Hapshalita Duestika M',7,1,3.41,750000,4,'P',40000,5,'Y',1),(157,75544207,'Leni Widyaningsih',7,1,3.35,1000000,6,'P',50000,6,'Y',1),(158,75544209,'Sefi Eka Setya',7,1,3.32,750000,6,'P',50000,5,'Y',1),(159,65544238,'Musfulichah',7,1,3.29,1000000,8,'P',80000,6,'Y',1),(160,65544044,'Dewi Suksemasari',7,1,3.28,2500000,8,'P',100000,3,'T',0),(161,85544201,'Vera Oktavia',7,1,3.23,2000000,4,'P',80000,3,'Y',1),(162,85544011,'Imroatul Mufidah',7,1,3.21,1000000,4,'P',70000,3,'Y',1),(163,85544022,'Intan Ika Jayanti',7,1,3.2,750000,4,'P',80000,4,'Y',1),(164,85544097,'Siti Halima',7,1,3.19,1000000,4,'P',70000,5,'Y',1),(165,85453001,'Ratih Safitri',7,1,3.19,1000000,4,'P',70000,4,'Y',1),(166,75544072,'Yusfina Hurfitria',7,1,3.18,250000,6,'P',50000,4,'Y',1),(167,85544006,'Alful Laili',7,1,3.18,2000000,4,'P',80000,4,'Y',1),(168,65544213,'Rizky Yulianingrum P',7,1,3.17,1000000,8,'P',60000,5,'Y',1),(169,75544034,'Aprilia Vita R',7,1,3.16,750000,6,'P',50000,5,'Y',1),(170,75544029,'Ila Huda Puspito',7,1,3.16,250000,4,'P',50000,6,'Y',1),(171,65544059,'Septi Engga W',8,1,3.16,2500000,8,'P',120000,6,'Y',1),(172,85544037,'Fitria Anggada Pik',7,1,3.14,1000000,4,'P',100000,5,'Y',1),(173,85544115,'Nifta Kusuma Dewi',7,1,3.14,1000000,4,'P',60000,2,'Y',1),(174,85453012,'Weni Wulandari',8,1,3.14,1000000,4,'P',80000,3,'Y',1),(175,65544005,'Lina Umshikhotur',7,1,3.14,500000,8,'P',100000,2,'T',0),(176,75544061,'Aan Andriani',7,1,3.13,500000,6,'P',70000,3,'Y',1),(177,65544018,'Peppy Mayasari',7,1,3.13,300000,8,'P',50000,4,'Y',1),(178,75544002,'Chalifatul Jannah',7,1,3.13,500000,6,'P',50000,4,'Y',1),(179,65544008,'Fera Dwi Anggraini',7,1,3.13,2500000,4,'P',120000,4,'Y',1),(180,75544067,'Christina Prima Dewi',7,1,3.12,1000000,6,'P',100000,3,'Y',1),(181,75544070,'Vammela Mega',7,1,3.12,750000,6,'P',70000,3,'Y',1),(182,65544075,'Erna Wati R',7,1,3.1,2500000,8,'P',200000,2,'T',0),(183,65544221,'Herdina Purna Wulan',7,1,3.1,1500000,8,'P',180000,1,'T',0),(184,75544081,'Izaty Nurul Firdhausy',7,1,3.09,500000,6,'P',50000,3,'Y',1),(185,85544112,'Retno Dwi Cahyanti',7,1,3.09,2000000,4,'P',70000,3,'Y',1),(186,75544082,'Anis Sucianti',7,1,3.09,500000,4,'P',60000,4,'Y',1),(187,85544101,'Mita Kurniawati',7,1,3.09,800000,4,'P',70000,4,'Y',1),(188,75544050,'Yunita Windasari',7,1,3.08,1000000,6,'P',80000,4,'Y',1),(189,65544063,'Laylatul Al Barriyah',7,1,3.08,500000,8,'P',40000,5,'Y',1),(190,75544113,'Setiyo Rini',7,1,3.07,500000,6,'P',30000,6,'Y',1),(191,65544232,'Ely Susilowati',7,1,3.07,2000000,8,'P',100000,3,'T',0),(192,65544041,'Tiara Trinani P',7,1,3.06,500000,8,'P',50000,3,'Y',1),(193,75544234,'Enok Maulidiyah',7,1,3.04,750000,6,'P',30000,4,'Y',1),(194,85544097,'Himatul Hanifa',7,1,3.03,1000000,4,'P',90000,4,'Y',1),(195,85514079,'Fajar Bunaya M',1,1,3.29,1500000,4,'L',90000,5,'Y',2),(196,85623238,'Nur Ika Suprapto',1,1,3.23,2000000,4,'L',90000,6,'Y',2),(197,75413035,'Wiji Yuli F',2,1,3.22,1000000,6,'L',80000,6,'Y',2),(198,65514028,'Hendra Susila',1,1,3.21,1000000,8,'L',150000,5,'T',0),(199,65514030,'Sularto Setiawan',1,1,3.19,1000000,8,'L',130000,5,'T',0),(200,65514064,'M. Nanang Kholik',1,1,3.19,500000,4,'L',40000,4,'Y',2),(201,85514212,'Rizqa Rosayanti',1,1,3.16,750000,6,'P',30000,5,'Y',2),(202,75413120,'Budi Eko Prasetyo',2,1,3.16,250000,4,'L',30000,6,'Y',2),(203,85514059,'Angga Dwi Setyawan',1,1,3.16,1000000,8,'L',120000,1,'T',0),(204,65514034,'Lalita Harsoningtyas',1,1,3.14,1000000,6,'P',40000,2,'Y',2),(205,75413251,'Anita Puji Lestari',2,1,3.12,250000,8,'P',50000,6,'Y',2),(206,65514057,'Dedy Erianto',1,1,3.1,2500000,6,'L',300000,1,'T',0),(207,75413051,'M. Arief Tom Tom',2,1,3.1,5000000,4,'L',300000,1,'T',0),(208,85623267,'Very Andriyawan',2,1,3.09,2000000,6,'L',80000,4,'Y',2),(209,75514203,'Suci Wahyu W',1,1,3.08,1000000,6,'P',70000,5,'Y',2),(210,75413045,'Ariya Kusuma',2,1,3.08,500000,4,'L',70000,5,'Y',2),(211,85514040,'Laily Masruro',1,1,3.07,2000000,6,'P',60000,5,'Y',2),(212,75413254,'Anggoro Dwi Prakoso',2,1,3.07,500000,4,'L',100000,4,'Y',2),(213,85514090,'Yudha Setyawan',1,1,3.07,1000000,6,'L',60000,4,'Y',2),(214,75514024,'Arini Sufairoh',1,1,3.05,250000,8,'P',70000,4,'Y',2),(215,65514065,'Nasiful Haq',1,1,3.05,1000000,4,'L',60000,2,'T',0),(216,85514033,'A. Suherman',1,1,3.04,1000000,4,'L',90000,3,'Y',2),(217,85514245,'Dian Arif T',1,1,3.04,1000000,4,'L',70000,4,'Y',2),(218,65514046,'M. Choiron Yasin',1,1,3.03,2500000,8,'L',200000,1,'T',0),(219,85514083,'Farid Rahmad Ardian',1,1,3.02,2000000,4,'L',130000,2,'Y',2),(220,65514016,'Gatot Aryfianto',1,1,3.01,2500000,8,'L',100000,3,'Y',2),(221,85514039,'Yayuk Suaibah',1,1,3,1000000,4,'P',90000,4,'Y',2),(222,75514225,'Rahmad Fauzi Fadli',1,1,3,2500000,6,'L',200000,2,'T',0),(223,65514046,'M. Amin',1,1,3,2500000,8,'L',300000,2,'T',0),(224,85623028,'Ellyk Yuliani',2,1,3,2500000,4,'P',60000,2,'Y',2),(225,85623098,'Yasir Mubarok',2,1,3,2500000,4,'L',80000,2,'Y',2),(226,75413077,'Lita Agustina',2,1,2.99,250000,6,'P',40000,3,'Y',2),(227,75413078,'Tri Anggraeni NF',2,1,2.99,250000,6,'P',20000,3,'Y',2),(228,75413062,'Dwi Merryana',2,1,2.99,1000000,6,'P',40000,3,'Y',2),(229,75413244,'Panji Tri Komara Sandi',2,1,2.98,1000000,6,'L',30000,3,'Y',2),(230,75413065,'Indah Sulistyawati',2,1,2.98,1000000,6,'P',60000,4,'Y',2),(231,85514210,'Abdurrahman Zain',1,1,2.98,2000000,4,'L',100000,2,'T',0),(232,85514014,'Baktiar Kurnia',1,1,2.98,2500000,4,'L',250000,2,'T',0),(233,65514039,'Warsito',1,1,2.98,2500000,8,'L',250000,1,'T',0),(234,85514012,'Dhavy Cahya T',1,1,2.98,1000000,4,'P',70000,3,'Y',2),(235,85623023,'A. Yusuuf Setyawan',2,1,2.98,1000000,4,'L',80000,3,'Y',2),(236,65514011,'Didid Panggih S',1,1,2.97,2500000,8,'L',200000,2,'T',0),(237,65514026,'Putut Winoto',1,1,2.97,500000,8,'L',50000,4,'Y',2),(238,75413074,'Dina Widyantoko',2,1,2.97,250000,6,'P',40000,6,'Y',2),(239,85623277,'Rio Pradipta',2,1,2.96,1000000,4,'L',40000,4,'Y',2),(240,85623024,'Ria Susanti',2,1,2.95,750000,4,'P',40000,4,'Y',2),(241,85514050,'Toni Setyawan',1,1,2.95,1000000,4,'L',120000,5,'T',0),(242,75413034,'Linda Rahmawati',2,1,2.94,500000,6,'P',40000,6,'Y',2),(243,65514020,'Untung Setyo W',1,1,2.94,1000000,6,'L',80000,3,'T',0),(244,65514006,'Wahyu Rizal G.P',1,1,2.93,1000000,8,'L',90000,3,'T',0),(245,85514010,'M. Hafid',1,1,2.93,1000000,4,'L',90000,3,'T',0),(246,75514248,'Devit Etika Sari',1,1,2.88,1000000,6,'P',30000,4,'Y',2),(247,75514245,'Oky Primajaya',1,1,2.83,500000,6,'L',40000,4,'Y',2),(248,75413067,'Asifah Ummairoh',2,1,2.83,500000,6,'P',40000,4,'Y',2),(249,75514223,'Dhidik Setiawan',1,1,2.83,3500000,6,'L',300000,3,'T',0),(250,85514037,'Budi Hadi Wiratama',1,1,2.82,1000000,4,'L',200000,3,'T',0),(251,85623087,'Ayu Milati Nur Azizah',2,1,2.81,800000,4,'P',40000,3,'Y',2),(252,85623036,'Suci Yasinta',2,1,2.78,1000000,4,'P',50000,4,'Y',2),(253,85623249,'Arizal',1,1,2.77,1000000,4,'L',50000,4,'Y',2),(254,85623202,'Iin Noverianti',2,1,2.77,3000000,4,'P',100000,4,'Y',2),(255,75413134,'Bayu Prastyo',2,1,2.76,750000,6,'L',20000,4,'Y',2),(256,85623064,'Miftachul Huda',2,1,2.75,800000,4,'L',30000,5,'Y',2),(257,85423001,'Agus Sugiarto',4,1,3.26,1000000,4,'L',50000,5,'Y',2),(258,75423011,'M Zainudin',4,1,3.26,500000,6,'L',20000,5,'Y',2),(259,65524055,'Agus Suprayitno',3,1,3.15,2500000,8,'L',180000,4,'T',0),(260,75423005,'Ardian Eko Aprianto',4,1,3.06,250000,6,'L',20000,6,'Y',2),(261,85524241,'Nur Faidah',3,1,3.06,1000000,4,'P',30000,6,'Y',2),(262,85524060,'Hedri Purnomo',3,1,3.06,2500000,4,'L',200000,2,'T',0),(263,65524053,'Tommi Wahyu Susanto',3,1,3.04,2500000,8,'L',190000,2,'T',0),(264,65524204,'Nur Yachya',3,1,3.04,2500000,8,'P',70000,3,'Y',2),(265,85524009,'Dian Ardhianti Ardyani',3,1,3.04,1000000,4,'P',60000,4,'Y',2),(266,85523003,'M. Suhendrik',4,1,3.03,1000000,4,'L',60000,5,'Y',2),(267,85524053,'Agus Sugiono',3,1,3.03,2000000,4,'L',70000,2,'T',0),(268,75524040,'Dama Aruesta S',3,1,3.03,250000,6,'P',40000,5,'Y',2),(269,85524207,'M Ajib Zakaria',3,1,3.03,7500000,4,'L',350000,2,'T',0),(270,75524078,'Fitra Amirul Anas',3,1,3.01,500000,6,'L',20000,4,'Y',2),(271,65524010,'Rendra Setya Pasha',3,1,3.01,1000000,8,'L',40000,6,'Y',2),(272,75524011,'Dwi Devi Kurniawan',3,1,3,500000,6,'P',50000,4,'Y',2),(273,85423207,'A Jauhar Pribadi',4,1,3,750000,4,'L',50000,4,'Y',2),(274,85524238,'M Fauzi Kurniawan',3,1,3,1000000,4,'L',90000,2,'T',0),(275,85524083,'A. Muthohar',3,1,3,1000000,4,'L',80000,2,'T',0),(276,75423023,'Rahmad Indra Prasta',4,1,3,1000000,6,'L',60000,3,'Y',2),(277,85524038,'Fajrur Rohman Hakim',3,1,3,800000,4,'L',50000,4,'Y',2),(278,75524075,'M Bahrusshodiq',3,1,2.99,1000000,6,'L',50000,4,'Y',2),(279,65524074,'M Khoirul Anwar',3,1,2.99,500000,8,'L',40000,4,'Y',2),(280,75524073,'Tri Sugiharto',3,1,2.99,500000,6,'L',40000,5,'Y',2),(281,65524059,'Alex Noveri',3,1,2.98,2500000,8,'L',100000,2,'T',0),(282,75524077,'A Nasrul Hakim',3,1,2.98,500000,6,'L',30000,4,'Y',2),(283,65524073,'Wenda Erfika Putra',3,1,2.98,1000000,8,'P',30000,4,'Y',2),(284,75524209,'Aris Retma Dianto',3,1,2.98,1000000,6,'L',40000,5,'Y',2),(285,85423220,'Rekso Gesang Widi',4,1,2.97,3000000,4,'L',250000,1,'T',0),(286,75524061,'M Jamaludin Yusuf',3,1,2.97,750000,6,'L',30000,5,'Y',2),(287,85423004,'M Badrus Sholeh',4,1,2.97,750000,4,'L',30000,5,'Y',2),(288,85524048,'Alfian Syahri R',3,1,2.97,5000000,4,'P',250000,4,'T',0),(289,65524039,'Rinto Priambudi',3,1,2.97,500000,8,'L',50000,5,'Y',2),(290,65524002,'A Mustamil Khoiron',3,1,2.97,1000000,8,'L',20000,6,'Y',2),(291,85524263,'Abdullah Karim',3,1,2.96,1000000,4,'L',30000,7,'Y',2),(292,75524025,'Daud Agung Sasongko',3,1,2.96,250000,6,'L',20000,6,'Y',2),(293,75524026,'Heru Prasetya',3,1,2.96,1000000,6,'L',40000,6,'Y',2),(294,75524202,'Praba Apriliyanto',4,1,2.96,750000,6,'L',40000,7,'Y',2),(295,65524025,'Agung Supriyanto',3,1,2.96,1000000,8,'L',20000,7,'Y',2),(296,75423022,'Ferry Janu Andriyanto',4,1,2.95,500000,6,'L',30000,7,'Y',2),(297,65524027,'Arie Garuda Satrio',3,1,2.95,2500000,8,'L',100000,4,'T',0),(298,85524208,'M Muhtadi Mahfudz',3,1,2.94,1000000,4,'L',100000,4,'Y',2),(299,75524225,'M Suwito Hadi P',3,1,2.94,500000,6,'L',90000,4,'Y',2),(300,85524069,'Khoirul Feriyansah',3,1,2.93,1000000,4,'L',50000,4,'Y',2),(301,75524059,'M Agung Nasir',3,1,2.93,750000,6,'L',60000,4,'Y',2),(302,65524003,'Rahmad SH',3,1,2.91,1000000,8,'L',70000,4,'Y',2),(303,75423016,'achmad Rizal',3,1,2.88,5000000,6,'L',70000,3,'T',0),(304,85524025,'Ichwan Ardianto',3,1,2.86,1000000,4,'L',50000,5,'Y',2),(305,85524269,'M Sirojudin',3,1,2.86,1000000,4,'L',50000,6,'Y',2),(306,75524060,'M Ihwan Ansori',3,1,2.8,500000,6,'L',20000,7,'Y',2),(307,85524232,'Eko Edi Saputro',3,1,2.78,1000000,4,'L',20000,4,'T',0),(308,65334023,'Merry Diah R',5,1,3.4,1000000,8,'P',60000,5,'Y',2),(309,65534006,'Rizqi Rosani',5,1,3.38,2500000,8,'P',70000,6,'Y',2),(310,65534032,'alimul Bashoriyah',5,1,3.37,2500000,8,'P',100000,5,'Y',2),(311,85534204,'Yulia Kusuma W',5,1,3.31,750000,4,'P',40000,5,'Y',2),(312,65534005,'Felicia Tria M',5,1,3.29,1000000,8,'P',90000,7,'Y',2),(313,85534002,'Henyningtyas Suhel',5,1,3.27,1000000,4,'P',60000,7,'Y',2),(314,85534033,'Yasril Mahendra',5,1,3.21,1000000,4,'L',100000,2,'T',0),(315,75593005,'Silvy Dwi P',6,1,3.2,500000,6,'P',20000,4,'Y',2),(316,85534202,'Dwi Yuliarti',5,1,3.2,2000000,4,'P',40000,4,'Y',2),(317,75593003,'Saipul Hari W',6,1,3.16,250000,6,'L',50000,4,'Y',2),(318,85534056,'M Taufiq',5,1,3.16,2000000,4,'L',60000,4,'Y',2),(319,65534030,'Ahmad Nur Wahid',5,1,3.15,5000000,8,'L',200000,5,'T',0),(320,75433006,'Dwi Cahyono P',5,1,3.14,500000,6,'L',40000,6,'Y',2),(321,85534205,'Su\'adidatul Islami',5,1,3.14,2000000,4,'P',50000,7,'Y',2),(322,85433206,'Aji Setyawan',6,1,3.13,2000000,4,'L',100000,7,'Y',2),(323,75433210,'Ayu Shintia Nuryani',5,1,3.12,1000000,6,'P',60000,5,'Y',2),(324,75534011,'Ainur Rosyidin',5,1,3.11,5000000,6,'P',130000,1,'T',0),(325,75433206,'Budi Darmawan',6,1,3.09,1500000,6,'L',100000,4,'Y',2),(326,75534004,'Susilo Dwi Utama',5,1,3.09,5000000,6,'L',250000,5,'T',0),(327,75534019,'Dewam Masrulloh',5,1,3.08,7500000,6,'L',300000,5,'T',0),(328,85534219,'Yusuf',5,1,3.07,2000000,4,'L',100000,6,'T',0),(329,85433202,'Arif Khadafi',6,1,3.05,1500000,4,'L',100000,5,'Y',2),(330,75433203,'Muchlis Dian S',6,1,3.04,250000,6,'L',50000,4,'Y',2),(331,75534020,'Fajar Setiawan',5,1,3.03,1000000,6,'L',100000,6,'Y',2),(332,75593001,'Erwin Priambodo',5,1,3.03,500000,6,'L',50000,6,'Y',2),(333,85433217,'Indra Yuki Octriananda',6,1,3.01,1000000,4,'L',40000,4,'T',0),(334,75433005,'Yuanita Carolina S',5,1,3,250000,6,'P',40000,4,'Y',2),(335,85534042,'Hendrawan Budiono',5,1,3,1000000,4,'L',70000,4,'T',0),(336,85534216,'Kiki Sayyidah',5,1,3,1000000,4,'P',70000,4,'Y',2),(337,75534012,'Gandi Bagus Pambudi',5,1,2.99,500000,6,'L',80000,6,'Y',2),(338,75534030,'Joko Widagdo',5,1,2.99,1000000,6,'L',80000,6,'Y',2),(339,75534027,'Rikha Aden',5,1,2.99,500000,6,'P',70000,6,'Y',2),(340,65534014,'Dion Yuda Prawiro Adi',5,1,2.97,1500000,8,'L',80000,6,'Y',2),(341,75534202,'Afif Kristanto',5,1,2.97,500000,6,'L',50000,6,'Y',2),(342,75433204,'Bayu Ari Prayogo',6,1,2.96,250000,6,'L',50000,5,'Y',2),(343,75433202,'Taufiq Romadhon',6,1,2.96,250000,6,'L',30000,5,'Y',2),(344,85534053,'Luthfi Sagiar',5,1,2.96,1000000,4,'L',20000,5,'Y',2),(345,85534050,'Satriadin Elfarisi',5,1,2.94,1000000,4,'L',20000,5,'Y',2),(346,85534217,'Rifki Ari Budiarto',5,1,2.92,750000,4,'L',40000,5,'Y',2),(347,75534017,'Rizky Budi Darmawan',6,1,2.88,1000000,6,'L',30000,4,'Y',2),(348,85534221,'Hendrik Pujo Mustofa',5,1,2.79,2500000,4,'L',90000,1,'T',0),(349,75593202,'Amaludin',6,1,2.78,500000,6,'L',50000,3,'Y',2),(350,75443001,'Agus Dwi K',8,1,3.88,1000000,6,'L',90000,5,'Y',2),(351,75443020,'Dimar Retno Juliansih',8,1,3.34,1000000,6,'P',120000,4,'Y',2),(352,75443005,'Diah Ayu Oktaviani',8,1,3.34,500000,6,'P',30000,4,'Y',2),(353,75443007,'Siti Muslikah',8,1,3.3,500000,6,'P',30000,5,'Y',2),(354,65544056,'Faizatul Maulidyah',7,1,3.2,1000000,8,'P',40000,2,'T',0),(355,85544049,'Silfiatun',7,1,3.2,2500000,4,'P',180000,2,'T',0),(356,75443002,'Dewinta Eka Y',8,1,3.18,500000,6,'P',40000,3,'Y',2),(357,85544023,'Sumiatun',7,1,3.17,1000000,4,'P',50000,4,'Y',2),(358,75443204,'Maisyaroh Iswan',7,1,3.14,2000000,6,'P',200000,3,'T',0),(359,85544018,'Wafa\' Salim Amar',7,1,3.13,2000000,4,'P',180000,3,'T',0),(360,85544005,'Aik Anggun V.S',7,1,3.11,2500000,4,'P',130000,2,'T',0),(361,75443009,'Sandy Setiawan',7,1,3.11,500000,6,'P',20000,4,'Y',2),(362,85544010,'Nevy Vilanty B',7,1,3.07,1000000,4,'P',40000,5,'Y',2),(363,75443205,'Dinda Savitri',8,1,3.02,500000,6,'P',40000,5,'Y',2),(364,85544239,'Setyo Rokhmawati',7,1,3.02,1000000,4,'P',40000,7,'Y',2),(365,65544234,'Dwi Oktavina Sari',7,1,3,1000000,8,'P',50000,7,'Y',2),(366,75544214,'Rizma Ragil Musvita',7,1,2.99,5000000,6,'P',150000,1,'T',0),(367,65544049,'Miftakhul Jannah',7,1,2.99,1000000,8,'P',120000,4,'Y',2),(368,75443201,'Nur Setyorini',8,1,2.99,250000,6,'P',40000,4,'Y',2),(369,75544230,'Yuliawanti',7,1,2.98,750000,6,'P',40000,5,'Y',2),(370,65544067,'Lasmini',7,1,2.98,250000,8,'P',20000,5,'Y',2),(371,65544034,'Arista Raras Dayanti',7,1,2.97,1000000,8,'P',80000,5,'Y',2),(372,65544048,'Ita Fatkhur R',7,1,2.97,2500000,8,'P',80000,1,'T',0),(373,75544114,'Retno Harjanti TA',7,1,2.97,250000,6,'P',70000,3,'Y',2),(374,65544066,'Rismaya Ulfa',7,1,2.96,2500000,8,'P',130000,5,'T',0),(375,75443203,'Khusnul Khotimah',7,1,2.95,1000000,6,'P',100000,4,'T',0),(376,75544212,'Vivin Puji Libriyana',7,1,2.95,500000,6,'P',50000,4,'Y',2),(377,65544247,'Ifani Wahyu Ruriasanti',7,1,2.91,1000000,8,'P',50000,3,'T',0),(378,75544089,'Reni Puji Astuti',7,1,2.9,500000,6,'P',30000,4,'Y',2),(379,75544045,'Meita Kurnia Dewi S',7,1,2.89,250000,6,'P',40000,5,'Y',2),(380,65544233,'Astrianingsih',7,1,2.88,1000000,8,'P',60000,5,'Y',2),(381,85544002,'Roro Sekar Pandansari',7,1,2.88,2000000,4,'P',100000,5,'Y',2),(382,85544120,'Defi Wulandari',7,1,2.88,2500000,4,'P',100000,2,'T',0),(383,75544112,'Mafisa Restami',7,1,2.86,1000000,6,'P',120000,5,'Y',2),(384,65544231,'Diah Indah Ningrum',7,1,2.86,1000000,8,'P',90000,5,'Y',2),(385,85544043,'Evi Arik Us\'sofa',7,1,2.86,2000000,4,'P',100000,3,'T',0),(386,75544208,'Inez Liberty AR.R',7,1,2.86,1000000,6,'P',40000,4,'Y',2),(387,76655098,'Ayu Wajar Wanti',7,1,2.85,1000000,6,'P',40000,5,'Y',2),(388,85544207,'Maela Chusna',7,1,2.84,1000000,4,'P',40000,6,'Y',2),(389,76655015,'Fitriyah Hanik',7,1,2.84,1000000,6,'P',30000,6,'Y',2),(390,75544036,'Siska Zulfah Hasanah',7,1,2.83,7500000,6,'P',350000,2,'T',0),(391,75544064,'Lilik Dwi Wahyuni',7,1,2.83,250000,6,'P',80000,7,'Y',2),(392,85544238,'Rita Arumsari',7,1,2.81,1000000,4,'P',90000,7,'Y',2),(393,75544238,'Desi Retno F',7,1,2.81,1000000,6,'P',90000,6,'Y',2),(394,85544013,'Choirun Nisa\'',7,1,2.81,1000000,4,'P',100000,6,'Y',2),(395,75544049,'Anggraeni Putri S',7,1,2.8,1000000,6,'P',120000,6,'Y',2),(396,75544013,'Sukma Kardina Sari',7,1,2.8,5000000,6,'P',200000,2,'T',0),(397,85544127,'Abdullah Ni\'am Al Syuyubi',7,1,2.8,1000000,4,'L',50000,3,'Y',2),(398,87766006,'Septa Ningrum Proyono',7,1,2.8,1500000,4,'P',50000,4,'Y',2),(399,65514058,'M. Amrin Hakim',1,1,3.07,2500000,9,'L',100000,5,'T',4),(400,65514038,'Dian Mardiyanti',1,1,3.08,3000000,9,'P',80000,5,'T',4),(401,65524060,'Saiful Amri',3,1,3.1,3000000,9,'L',50000,5,'T',4),(402,75534024,'Choirul Umam M',5,1,3.54,1500000,7,'L',120000,5,'T',4),(403,65544028,'Warsih Hidayati',7,1,3.41,2500000,9,'P',100000,5,'T',4),(404,65544027,'Jauharotul Fuadiyah',7,1,3.4,2500000,9,'P',90000,6,'T',4),(405,65514075,'Ugik Waluyo',1,1,3,1500000,9,'L',100000,6,'T',5),(406,75524016,'Fida Nur Irawati',3,1,3.29,2500000,7,'P',120000,6,'T',5),(407,75524014,'Sri Astutik',3,1,3.55,2500000,7,'P',80000,6,'T',5),(408,65524040,'Febri Iswahyudi',3,1,3.32,1500000,9,'L',50000,6,'T',5),(409,75534003,'Cecep Pribadi',5,1,3.47,2500000,7,'L',70000,3,'T',5),(410,75534001,'Bungah Justin E',5,1,3.11,2000000,7,'L',80000,3,'T',5),(411,65544040,'Vitania Desi Kristanti',7,1,3.4,2500000,9,'P',60000,3,'T',5),(412,65544009,'Kadek Biana M',7,1,3.13,2500000,9,'P',60000,3,'T',5),(413,75514007,'Deny Akbar Puspita',1,1,3.04,1500000,7,'L',70000,3,'T',6),(414,65524202,'Dwi Cahyo Utomo',3,1,3.08,2500000,7,'L',100000,3,'T',6),(415,85514047,'Citra Ayu Mandasari',1,1,3.64,3000000,4,'P',200000,5,'Y',3),(416,85514063,'Ervia Novianti',1,1,3.59,2500000,4,'P',180000,5,'Y',3),(417,85514053,'Debbi Irfan M',1,1,3.55,3000000,4,'L',120000,7,'Y',3),(418,85514051,'Aditya Alpha T',1,1,3.43,3000000,4,'L',100000,7,'Y',3),(419,85514088,'Marfuatin',1,1,3.33,3500000,4,'P',100000,2,'Y',3),(420,85524045,'Novi Indah Riani',3,1,3.21,2500000,4,'P',50000,5,'Y',3),(421,85524259,'Nu\'man',3,1,3.19,1500000,4,'L',70000,6,'Y',3),(422,85524058,'Zein Abdurrachman F',3,1,3.13,2500000,6,'L',80000,6,'Y',3),(423,65524247,'Akhmad Rahmawan',3,1,3.11,1500000,10,'L',80000,6,'Y',3),(424,85524012,'Joko Prasetyo',3,1,3.1,2000000,4,'L',110000,6,'Y',3),(425,85534218,'Rishca Stefanie',5,1,3.63,2000000,4,'P',100000,7,'Y',3),(426,75534022,'Puguh Novi P',5,1,3.57,3000000,6,'L',100000,7,'Y',3),(427,85534045,'Arik Triarso',5,1,3.46,3500000,4,'L',120000,7,'Y',3),(428,65544227,'Siti Mazizatuz Zahroh',7,1,3.57,3500000,10,'P',70000,7,'Y',3),(429,75544005,'Dwi Rista Vanani',7,1,3.49,3000000,8,'P',135000,3,'Y',3);
/*!40000 ALTER TABLE `mila_sample` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mila_users`
--
DROP TABLE IF EXISTS `mila_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mila_users` (
`USER_ID` int(5) NOT NULL AUTO_INCREMENT,
`USER_NAME` varchar(255) NOT NULL,
`USER_MAIL` varchar(100) NOT NULL,
`USER_KEY` varchar(32) NOT NULL,
PRIMARY KEY (`USER_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mila_users`
--
LOCK TABLES `mila_users` WRITE;
/*!40000 ALTER TABLE `mila_users` DISABLE KEYS */;
INSERT INTO `mila_users` (`USER_ID`, `USER_NAME`, `USER_MAIL`, `USER_KEY`) VALUES (1,'Administrator','admin','21232f297a57a5a743894a0e4a801fc3'),(2,'Ayu Milati Nur Azizah','mila','f562f7f28a039094f7b602c033f106a4');
/*!40000 ALTER TABLE `mila_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary table structure for view `view_mahasiswa`
--
DROP TABLE IF EXISTS `view_mahasiswa`;
/*!50001 DROP VIEW IF EXISTS `view_mahasiswa`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_mahasiswa` (
`ID` tinyint NOT NULL,
`NIM` tinyint NOT NULL,
`NAMA` tinyint NOT NULL,
`ALAMAT` tinyint NOT NULL,
`IPK` tinyint NOT NULL,
`GAJI` tinyint NOT NULL,
`SEMESTER` tinyint NOT NULL,
`JENKEL` tinyint NOT NULL,
`REKLISTRIK` tinyint NOT NULL,
`JMLPIAGAM` tinyint NOT NULL,
`PROPOSALPKM` tinyint NOT NULL,
`JURUSAN` tinyint NOT NULL,
`PRODI` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
--
-- Temporary table structure for view `view_sample`
--
DROP TABLE IF EXISTS `view_sample`;
/*!50001 DROP VIEW IF EXISTS `view_sample`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_sample` (
`ID` tinyint NOT NULL,
`NIM` tinyint NOT NULL,
`NAMA` tinyint NOT NULL,
`IPK` tinyint NOT NULL,
`GAJI` tinyint NOT NULL,
`SEMESTER` tinyint NOT NULL,
`JENKEL` tinyint NOT NULL,
`REKLISTRIK` tinyint NOT NULL,
`JMLPIAGAM` tinyint NOT NULL,
`PROPOSALPKM` tinyint NOT NULL,
`BEASISWA` tinyint NOT NULL,
`PRODI` tinyint NOT NULL,
`JURUSAN` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
--
-- Dumping events for database 'beasiswa'
--
--
-- Dumping routines for database 'beasiswa'
--
--
-- Final view structure for view `view_mahasiswa`
--
/*!50001 DROP TABLE IF EXISTS `view_mahasiswa`*/;
/*!50001 DROP VIEW IF EXISTS `view_mahasiswa`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`u1786488`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_mahasiswa` AS select `a`.`ID` AS `ID`,`a`.`NIM` AS `NIM`,`a`.`NAMA` AS `NAMA`,`a`.`ALAMAT` AS `ALAMAT`,`a`.`IPK` AS `IPK`,`a`.`GAJI` AS `GAJI`,`a`.`SEMESTER` AS `SEMESTER`,`a`.`JENKEL` AS `JENKEL`,`a`.`REKLISTRIK` AS `REKLISTRIK`,`a`.`JMLPIAGAM` AS `JMLPIAGAM`,`a`.`PROPOSALPKM` AS `PROPOSALPKM`,`b`.`JURUSAN` AS `JURUSAN`,concat(`c`.`JENJANG`,' ',`c`.`PRODI`) AS `PRODI` from ((`mila_mahasiswa` `a` join `mila_jurusan` `b`) join `mila_prodi` `c`) where ((`a`.`JURUSAN` = `b`.`ID`) and (`a`.`PRODI` = `c`.`ID`) and (`b`.`ID` = `c`.`JURUSAN`)) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `view_sample`
--
/*!50001 DROP TABLE IF EXISTS `view_sample`*/;
/*!50001 DROP VIEW IF EXISTS `view_sample`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`u1786488`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_sample` AS select `a`.`ID` AS `ID`,`a`.`NIM` AS `NIM`,`a`.`NAMA` AS `NAMA`,`a`.`IPK` AS `IPK`,`a`.`GAJI` AS `GAJI`,`a`.`SEMESTER` AS `SEMESTER`,`a`.`JENKEL` AS `JENKEL`,`a`.`REKLISTRIK` AS `REKLISTRIK`,`a`.`JMLPIAGAM` AS `JMLPIAGAM`,`a`.`PROPOSALPKM` AS `PROPOSALPKM`,`a`.`BEASISWA` AS `BEASISWA`,concat(`c`.`JENJANG`,' ',`c`.`PRODI`) AS `PRODI`,`b`.`JURUSAN` AS `JURUSAN` from ((`mila_sample` `a` join `mila_jurusan` `b`) join `mila_prodi` `c`) where ((`a`.`JURUSAN` = `b`.`ID`) and (`a`.`PRODI` = `c`.`ID`) and (`b`.`ID` = `c`.`JURUSAN`)) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-02-23 15:32:37