{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Kopi","Kenaikan"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Kopi","index":0,"n_rows":78,"n_cols":17,"rows_kept":78,"cut":false,"hidden":false,"merged":[[5,16,7,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kenapa Macro dapat dijalankan dari sheet ini,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Namun tidak dapat dijalankan dari sheet Kenaikan?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kesalahan dimanakah penusilan VBA?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hasilnya di kolom ini"]
[]
["Kelas","No","Nama","PAI","PKn","Ind","Ingg","Mat","IPA","IPS","Sebud","Penjas","TIK","Jawa","Jumlah","rank KLs"]
["7A",1,"Adinda Octaviana",55,65,85,70,76,80,79,80,83,78,78,{"$f":"SUM(D9:N9)","v":829},{"$f":"RANK(O9,O$9:O$43)","v":31}]
["7A",2,"Amelia Agustina Zulva",90,70,84,70,84,80,81,75,82,70,86,872,26]
["7A",3,"Anna Nurul Fathiyah",85,87,85,84,77,85,79,82,83,84,81,912,9]
["7A",4,"Annisa Hidayatun Ni'mah",86,94,90,87,91,86,81,84,82,88,86,955,2]
["7A",5,"Camelia Fatikha Rahim",82,81,81,77,76,79,80,81,82,78,77,874,25]
["7A",6,"Canthika Putriana",79,85,60,76,76,72,77,80,60,78,78,821,32]
["7A",7,"Dewi Aulia Putri",78,81,79,77,76,76,78,80,82,78,77,862,28]
["7A",8,"Dian Pertiwi",78,86,83,87,76,79,78,81,60,81,79,868,27]
["7A",9,"Dwi Suryo Wicaksono",85,88,88,84,77,80,80,81,84,78,82,907,11]
["7A",10,"Efi Setia Ningsih",83,93,86,85,76,76,82,82,81,84,83,911,10]
["7A",11,"Esti Krisjulianingrum",81,87,86,85,76,77,77,84,81,78,83,895,16]
["7A",12,"Faila Luthfiana",81,89,86,92,83,85,77,91,81,84,85,934,3]
["7A",13,"Firda Tryana Yulistina",82,88,83,85,87,81,79,84,81,82,91,923,7]
["7A",14,"Gita Octaviani",82,89,84,82,77,78,78,81,83,78,82,894,18]
["7A",15,"Indah Vebriani",80,87,81,81,77,80,81,80,84,78,82,891,19]
["7A",16,"Intan Muryaning Charimah",85,89,85,90,76,77,77,82,81,85,78,905,13]
["7A",17,"Luqman Dava Pratama",81,90,83,82,83,76,78,82,85,81,85,906,12]
["7A",18,"Maida Garjita",78,86,82,83,76,77,81,83,84,80,79,889,21]
["7A",19,"Marsa Nabila",81,89,86,79,76,78,79,85,82,79,83,897,15]
["7A",20,"Maulida Fadhaliva",78,78,70,74,76,72,70,80,81,78,77,834,30]
["7A",21,"Melisa Kartika Sari",85,90,85,82,83,78,78,84,81,81,86,913,8]
["7A",22,"Melly Khoirotun Nisa'",85,89,83,85,76,81,79,82,82,81,81,904,14]
["7A",23,"Muhammad Bagus Prasetyo Widodo",90,92,88,87,92,85,83,87,83,89,89,965,1]
["7A",24,"Muhammad Rafli",83,89,80,81,77,76,79,81,84,82,83,895,16]
["7A",25,"Noor Lailatul Firdausiyah",78,87,80,79,76,80,77,80,81,79,83,880,23]
["7A",26,"Putri Nabila Masduki",78,80,80,79,76,72,77,80,83,78,77,860,29]
["7A",27,"Ratu Alam Sekar Arum",78,87,81,81,76,76,77,80,83,79,77,875,24]
["7A",28,"Rezky Pratamaylida",88,94,87,80,82,80,81,83,81,86,86,928,6]
["7A",29,"Riana Putri Wulansari",84,95,88,86,84,82,78,85,81,81,86,930,4]
["7A",30,"Rusdiana Mivta Riandani",82,87,84,83,77,76,77,80,82,78,84,890,20]
["7A",31,"Sabrina Salsabila",88,89,86,87,76,83,84,83,81,82,90,929,5]
["7A",32,"Selvia Mei Anjani",81,87,84,80,76,76,77,80,85,78,77,881,22]
["7A",33,"Yusuf Wahyu Utomo",0,0,0,0,0,0,0,0,0,0,0,0,33]
["7A",34,0,0,0,0,0,0,0,0,0,0,0,0,0,33]
["7A",35,0,0,0,0,0,0,0,0,0,0,0,0,0,33]
["7B",1,"Adinda Octaviana",81,89,86,83,82,79,77,80,86,82,82,{"$f":"SUM(D44:N44)","v":907},{"$f":"RANK(O44,O$44:O$78)","v":12}]
["7B",2,"Amelia Agustina Zulva",82,88,86,89,84,81,77,81,80,81,83,912,10]
["7B",3,"Anna Nurul Fathiyah",80,80,84,88,76,76,77,80,88,79,78,886,20]
["7B",4,"Annisa Hidayatun Ni'mah",78,78,79,77,76,75,77,80,83,78,78,859,29]
["7B",5,"Camelia Fatikha Rahim",82,89,82,82,80,79,78,80,81,80,86,899,15]
["7B",6,"Canthika Putriana",87,90,82,85,86,82,80,80,81,84,86,923,5]
["7B",7,"Dewi Aulia Putri",79,83,80,79,76,76,77,80,81,79,78,868,27]
["7B",8,"Dian Pertiwi",86,92,85,81,82,76,80,80,81,84,86,913,9]
["7B",9,"Dwi Suryo Wicaksono",87,94,85,83,94,82,79,81,82,84,88,939,3]
["7B",10,"Efi Setia Ningsih",90,95,89,87,89,87,81,83,81,88,91,961,1]
["7B",11,"Esti Krisjulianingrum",81,87,82,80,76,76,77,80,81,84,83,887,19]
["7B",12,"Faila Luthfiana",79,86,84,83,76,76,77,80,83,81,77,882,21]
["7B",13,"Firda Tryana Yulistina",78,82,86,82,76,75,77,80,82,79,80,877,22]
["7B",14,"Gita Octaviani",78,78,78,70,76,72,77,80,81,78,77,845,30]
["7B",15,"Indah Vebriani",86,93,85,86,81,79,79,80,82,80,84,915,8]
["7B",16,"Intan Muryaning Charimah",79,82,82,79,76,75,78,80,89,79,78,877,22]
["7B",17,"Luqman Dava Pratama",78,79,80,79,76,78,78,83,84,82,77,874,25]
["7B",18,"Maida Garjita",91,95,86,86,93,82,83,83,82,86,89,956,2]
["7B",19,"Marsa Nabila",86,88,83,84,82,77,81,80,80,82,85,908,11]
["7B",20,"Maulida Fadhaliva",86,94,86,84,76,82,80,83,82,81,86,920,6]
["7B",21,"Melisa Kartika Sari",83,78,80,81,76,76,77,80,83,80,78,872,26]
["7B",22,"Melly Khoirotun Nisa'",86,90,82,79,76,76,77,80,81,81,80,888,18]
["7B",23,"Muhammad Bagus Prasetyo Widodo",84,88,84,84,78,81,77,80,82,83,82,903,14]
["7B",24,"Muhammad Rafli",89,93,89,80,88,81,78,81,82,86,90,937,4]
["7B",25,"Noor Lailatul Firdausiyah",82,79,79,72,76,77,77,80,84,78,77,861,28]
["7B",26,"Putri Nabila Masduki",82,89,85,79,89,85,77,84,84,84,82,920,6]
["7B",27,"Ratu Alam Sekar Arum",86,91,84,78,76,80,77,84,81,83,85,905,13]
["7B",28,"Rezky Pratamaylida",85,85,85,79,77,76,81,80,85,83,82,898,16]
["7B",29,"Riana Putri Wulansari",87,91,85,80,76,76,79,82,81,79,80,896,17]
["7B",30,"Rusdiana Mivta Riandani",78,88,83,77,76,76,77,80,84,78,79,876,24]
["7B",31,"Sabrina Salsabila",0,0,0,0,0,0,0,0,0,0,0,0,31]
["7B",32,"Selvia Mei Anjani",0,0,0,0,0,0,0,0,0,0,0,0,31]
["7B",33,"Yusuf Wahyu Utomo",0,0,0,0,0,0,0,0,0,0,0,0,31]
["7B",34," Yusuf Ibrohim ",0,0,0,0,0,0,0,0,0,0,0,0,31]
["7B",35,0,0,0,0,0,0,0,0,0,0,0,0,0,31]

{"sheet":"Kenaikan","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Kenapa Macro di bawah ini tidak dapat dijalankan dari sheet ini,"]
[null,null,null,"Namun dapat dijalankan dari sheet Kopi?"]
[null,null,null,"dimanakah Kesalahan  penusilan VBA?"]
[null,null,1,"Sub Etung()"]
[null,null,2,"Dim kl As String"]
[null,null,3,"Dim i As Integer"]
[null,null,4,"Dim baris As Integer"]
[null,null,5,"Dim a As Integer"]
[null,null,6,"Dim it As Integer"]
[703,null,7,"Dim z As Integer"]
[704,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A11,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},8,"Dim itu As Integer"]
[705,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A12,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},9,"baris = Sheet1.Range(\"A10000\").End(xlUp).row"]
[706,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A13,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},10,"z = 7"]
[707,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A14,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},11,"Sheet1.Range(\"Q9:Q1000\").ClearContents"]
[708,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A15,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},12,"For i = 9 To baris"]
[709,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A16,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},13,"it = 0"]
[710,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A17,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},14," For a = 1 To 11"]
[711,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A18,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},15," If Sheet1.Cells(i, a + 3) < Sheet6.Cells(29 + a, 5 + kelase(Sheet1.Cells(i, 1))) Then"]
[712,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A19,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},16," it = it + 1"]
[713,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A20,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},17," Else"]
[714,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A21,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},18," End If"]
[715,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A22,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},19," Next a"]
[716,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A23,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},20," If (it > 3 And Len(Sheet1.Cells(i, 3)) > 2) Then"]
[717,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A24,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},21,"  itu = itu + 1"]
[718,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A25,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},22," Sheets(\"kopi\").Cells(i, 17) = z & Format(itu, \"00\")"]
[719,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A26,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},23," Else"]
[720,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A27,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},24," If (Sheet1.Cells(i, 15) < Sheet6.Cells(41, 5 + kelase(Sheet1.Cells(i, 1))) And Len(Sheet1.Cells(i, 3)) > 2) Then"]
[721,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A28,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},25,"  itu = itu + 1"]
[722,null,26," Sheets(\"kopi\").Cells(i, 17) = z & Format(itu, \"00\")"]
[723,null,27," Else"]
[724,null,28," End If"]
[725,{"$f":"IFERROR(INDEX(Kopi!A$9:A$742,MATCH($A32,Kopi!$Q$9:$Q$742,0)),\"\")","v":""},29," End If"]
[null,null,30," Next i"]
[null,null,31,"End Sub"]
[]
[]
[]
[]
[]
[null,null,null,null,null,76,77,78,77,78,78]
[null,null,null,null,null,76,77,78,76,78,78]
[null,null,null,null,null,77,78,78,77,78,79]
[null,null,null,null,null,76,76,77,78,78,79]
[null,null,null,null,null,75,75,76,76,77,77]
[null,null,null,null,null,75,76,76,77,77,77]
[null,null,null,null,null,76,77,77,76,77,77]
[null,null,null,null,null,78,79,80,78,79,80]
[null,null,null,null,null,77,79,79,77,79,79]
[null,null,null,null,null,76,77,78,76,77,78]
[null,null,null,null,null,76,76,77,76,76,77]
[null,null,null,null,null,{"$f":"SUM(F40:F50)","v":838},{"$f":"SUM(G40:G50)","v":847},854,844,854,859]