{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["menu","jwbn","hasil","nilai akhir"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"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":"menu","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"MENU UTAMA"]
[null,"KOREKSI HASIL UTS"]

{"sheet":"jwbn","index":1,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,21],[1,0,1,21],[3,0,4,0],[3,1,4,1]]}
["REKAPITULASI HASIL ULANGAN TENGAH SEMESTER"]
["PRAKARYA - 8A"]
[]
["NO","NAMA SISWA",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,"B","D","A","A","C","A","C","A","C","A","D","D","C","C","A","B","D","B","B","C"]
[1,"ADAM ABYAN MALIK","B","A","D","A","D","A","C","D","C","A","A","D","D","C","B","B","D","B","B","C"]
[2,"ADINDA RAMADHINA MALIK","B","A","A","C","C","C","C","D","B","A","D","D","C","C","A","B","D","B","B","C"]
[3,"AERIO GANI MARTIZA","B","D","A","A","C","C","C","A","C","A","D","D","C","C","A","B","D","B","B","C"]
[4,"ALFIRA NAJMI RAMADHANI","B","D","D","A","C",null,"C","C","A","A","D","D","C","C","A","B","D","B","B","C"]
[5,"ANINDYA LINTANG MAHARANI","B","A","A","A","A","A","C","C","D","A","D","D","C","C","A","B","C","B","B","C"]
[6,"ANNISA CASRIA HERDIANTI","B","C","A","A","C","C","C","D","B","A","D","D","C","C","A","B","D","B","B","C"]
[7,"ARYA PUTRA DARMAWAN","B","C","A","A","A","C","C","C","D","A","B","C","C","A","C","B","D","B","B","C"]
[8,"AULIA UROHMAH","B","C","A","A","C","A","C","C","D","A","D","D","C","C","A","B","D","B","B","C"]
[9,"AZZAHRA SALSABILA","B","C","A","A","C","A","C","A","C","A","D","D","C","C","A","B","D","B","B","C"]
[10,"BILLGIES NUGRAHA AL-AZIZ","B","D","C","A","C","C","C","D","D","A","D",null,"C","C",null,"D","D","B","B","C"]

{"sheet":"hasil","index":2,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,21],[0,0,1,0],[0,1,1,1]]}
["NO","NAMA SISWA","NILAI"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[1,{"$f":"VLOOKUP(A3,DATA,2,TRUE)","v":"ADAM ABYAN MALIK"},{"$f":"IF(jwbn!C6=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D6=jwbn!D$5,5,0)","v":0},{"$f":"IF(jwbn!E6=jwbn!E$5,5,0)","v":0},{"$f":"IF(jwbn!F6=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G6=jwbn!G$5,5,0)","v":0},{"$f":"IF(jwbn!H6=jwbn!H$5,5,0)","v":5},{"$f":"IF(jwbn!I6=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J6=jwbn!J$5,5,0)","v":0},{"$f":"IF(jwbn!K6=jwbn!K$5,5,0)","v":5},{"$f":"IF(jwbn!L6=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M6=jwbn!M$5,5,0)","v":0},{"$f":"IF(jwbn!N6=jwbn!N$5,5,0)","v":5},{"$f":"IF(jwbn!O6=jwbn!O$5,5,0)","v":0},{"$f":"IF(jwbn!P6=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q6=jwbn!Q$5,5,0)","v":0},{"$f":"IF(jwbn!R6=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S6=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T6=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U6=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V6=jwbn!V$5,5,0)","v":5}]
[2,"ADINDA RAMADHINA MALIK",{"$f":"IF(jwbn!C7=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D7=jwbn!D$5,5,0)","v":0},{"$f":"IF(jwbn!E7=jwbn!E$5,5,0)","v":5},{"$f":"IF(jwbn!F7=jwbn!F$5,5,0)","v":0},{"$f":"IF(jwbn!G7=jwbn!G$5,5,0)","v":5},{"$f":"IF(jwbn!H7=jwbn!H$5,5,0)","v":0},{"$f":"IF(jwbn!I7=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J7=jwbn!J$5,5,0)","v":0},{"$f":"IF(jwbn!K7=jwbn!K$5,5,0)","v":0},{"$f":"IF(jwbn!L7=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M7=jwbn!M$5,5,0)","v":5},{"$f":"IF(jwbn!N7=jwbn!N$5,5,0)","v":5},{"$f":"IF(jwbn!O7=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P7=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q7=jwbn!Q$5,5,0)","v":5},{"$f":"IF(jwbn!R7=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S7=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T7=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U7=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V7=jwbn!V$5,5,0)","v":5}]
[3,"AERIO GANI MARTIZA",{"$f":"IF(jwbn!C8=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D8=jwbn!D$5,5,0)","v":5},{"$f":"IF(jwbn!E8=jwbn!E$5,5,0)","v":5},{"$f":"IF(jwbn!F8=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G8=jwbn!G$5,5,0)","v":5},{"$f":"IF(jwbn!H8=jwbn!H$5,5,0)","v":0},{"$f":"IF(jwbn!I8=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J8=jwbn!J$5,5,0)","v":5},{"$f":"IF(jwbn!K8=jwbn!K$5,5,0)","v":5},{"$f":"IF(jwbn!L8=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M8=jwbn!M$5,5,0)","v":5},{"$f":"IF(jwbn!N8=jwbn!N$5,5,0)","v":5},{"$f":"IF(jwbn!O8=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P8=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q8=jwbn!Q$5,5,0)","v":5},{"$f":"IF(jwbn!R8=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S8=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T8=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U8=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V8=jwbn!V$5,5,0)","v":5}]
[4,"ALFIRA NAJMI RAMADHANI",{"$f":"IF(jwbn!C9=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D9=jwbn!D$5,5,0)","v":5},{"$f":"IF(jwbn!E9=jwbn!E$5,5,0)","v":0},{"$f":"IF(jwbn!F9=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G9=jwbn!G$5,5,0)","v":5},{"$f":"IF(jwbn!H9=jwbn!H$5,5,0)","v":0},{"$f":"IF(jwbn!I9=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J9=jwbn!J$5,5,0)","v":0},{"$f":"IF(jwbn!K9=jwbn!K$5,5,0)","v":0},{"$f":"IF(jwbn!L9=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M9=jwbn!M$5,5,0)","v":5},{"$f":"IF(jwbn!N9=jwbn!N$5,5,0)","v":5},{"$f":"IF(jwbn!O9=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P9=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q9=jwbn!Q$5,5,0)","v":5},{"$f":"IF(jwbn!R9=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S9=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T9=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U9=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V9=jwbn!V$5,5,0)","v":5}]
[5,"ANINDYA LINTANG MAHARANI",{"$f":"IF(jwbn!C10=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D10=jwbn!D$5,5,0)","v":0},{"$f":"IF(jwbn!E10=jwbn!E$5,5,0)","v":5},{"$f":"IF(jwbn!F10=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G10=jwbn!G$5,5,0)","v":0},{"$f":"IF(jwbn!H10=jwbn!H$5,5,0)","v":5},{"$f":"IF(jwbn!I10=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J10=jwbn!J$5,5,0)","v":0},{"$f":"IF(jwbn!K10=jwbn!K$5,5,0)","v":0},{"$f":"IF(jwbn!L10=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M10=jwbn!M$5,5,0)","v":5},{"$f":"IF(jwbn!N10=jwbn!N$5,5,0)","v":5},{"$f":"IF(jwbn!O10=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P10=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q10=jwbn!Q$5,5,0)","v":5},{"$f":"IF(jwbn!R10=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S10=jwbn!S$5,5,0)","v":0},{"$f":"IF(jwbn!T10=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U10=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V10=jwbn!V$5,5,0)","v":5}]
[6,"ANNISA CASRIA HERDIANTI",{"$f":"IF(jwbn!C11=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D11=jwbn!D$5,5,0)","v":0},{"$f":"IF(jwbn!E11=jwbn!E$5,5,0)","v":5},{"$f":"IF(jwbn!F11=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G11=jwbn!G$5,5,0)","v":5},{"$f":"IF(jwbn!H11=jwbn!H$5,5,0)","v":0},{"$f":"IF(jwbn!I11=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J11=jwbn!J$5,5,0)","v":0},{"$f":"IF(jwbn!K11=jwbn!K$5,5,0)","v":0},{"$f":"IF(jwbn!L11=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M11=jwbn!M$5,5,0)","v":5},{"$f":"IF(jwbn!N11=jwbn!N$5,5,0)","v":5},{"$f":"IF(jwbn!O11=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P11=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q11=jwbn!Q$5,5,0)","v":5},{"$f":"IF(jwbn!R11=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S11=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T11=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U11=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V11=jwbn!V$5,5,0)","v":5}]
[7,"ARYA PUTRA DARMAWAN",{"$f":"IF(jwbn!C12=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D12=jwbn!D$5,5,0)","v":0},{"$f":"IF(jwbn!E12=jwbn!E$5,5,0)","v":5},{"$f":"IF(jwbn!F12=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G12=jwbn!G$5,5,0)","v":0},{"$f":"IF(jwbn!H12=jwbn!H$5,5,0)","v":0},{"$f":"IF(jwbn!I12=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J12=jwbn!J$5,5,0)","v":0},{"$f":"IF(jwbn!K12=jwbn!K$5,5,0)","v":0},{"$f":"IF(jwbn!L12=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M12=jwbn!M$5,5,0)","v":0},{"$f":"IF(jwbn!N12=jwbn!N$5,5,0)","v":0},{"$f":"IF(jwbn!O12=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P12=jwbn!P$5,5,0)","v":0},{"$f":"IF(jwbn!Q12=jwbn!Q$5,5,0)","v":0},{"$f":"IF(jwbn!R12=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S12=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T12=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U12=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V12=jwbn!V$5,5,0)","v":5}]
[8,"AULIA UROHMAH",{"$f":"IF(jwbn!C13=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D13=jwbn!D$5,5,0)","v":0},{"$f":"IF(jwbn!E13=jwbn!E$5,5,0)","v":5},{"$f":"IF(jwbn!F13=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G13=jwbn!G$5,5,0)","v":5},{"$f":"IF(jwbn!H13=jwbn!H$5,5,0)","v":5},{"$f":"IF(jwbn!I13=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J13=jwbn!J$5,5,0)","v":0},{"$f":"IF(jwbn!K13=jwbn!K$5,5,0)","v":0},{"$f":"IF(jwbn!L13=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M13=jwbn!M$5,5,0)","v":5},{"$f":"IF(jwbn!N13=jwbn!N$5,5,0)","v":5},{"$f":"IF(jwbn!O13=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P13=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q13=jwbn!Q$5,5,0)","v":5},{"$f":"IF(jwbn!R13=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S13=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T13=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U13=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V13=jwbn!V$5,5,0)","v":5}]
[9,"AZZAHRA SALSABILA",{"$f":"IF(jwbn!C14=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D14=jwbn!D$5,5,0)","v":0},{"$f":"IF(jwbn!E14=jwbn!E$5,5,0)","v":5},{"$f":"IF(jwbn!F14=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G14=jwbn!G$5,5,0)","v":5},{"$f":"IF(jwbn!H14=jwbn!H$5,5,0)","v":5},{"$f":"IF(jwbn!I14=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J14=jwbn!J$5,5,0)","v":5},{"$f":"IF(jwbn!K14=jwbn!K$5,5,0)","v":5},{"$f":"IF(jwbn!L14=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M14=jwbn!M$5,5,0)","v":5},{"$f":"IF(jwbn!N14=jwbn!N$5,5,0)","v":5},{"$f":"IF(jwbn!O14=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P14=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q14=jwbn!Q$5,5,0)","v":5},{"$f":"IF(jwbn!R14=jwbn!R$5,5,0)","v":5},{"$f":"IF(jwbn!S14=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T14=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U14=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V14=jwbn!V$5,5,0)","v":5}]
[10,"BILLGIES NUGRAHA AL-AZIZ",{"$f":"IF(jwbn!C15=jwbn!C$5,5,0)","v":5},{"$f":"IF(jwbn!D15=jwbn!D$5,5,0)","v":5},{"$f":"IF(jwbn!E15=jwbn!E$5,5,0)","v":0},{"$f":"IF(jwbn!F15=jwbn!F$5,5,0)","v":5},{"$f":"IF(jwbn!G15=jwbn!G$5,5,0)","v":5},{"$f":"IF(jwbn!H15=jwbn!H$5,5,0)","v":0},{"$f":"IF(jwbn!I15=jwbn!I$5,5,0)","v":5},{"$f":"IF(jwbn!J15=jwbn!J$5,5,0)","v":0},{"$f":"IF(jwbn!K15=jwbn!K$5,5,0)","v":0},{"$f":"IF(jwbn!L15=jwbn!L$5,5,0)","v":5},{"$f":"IF(jwbn!M15=jwbn!M$5,5,0)","v":5},{"$f":"IF(jwbn!N15=jwbn!N$5,5,0)","v":0},{"$f":"IF(jwbn!O15=jwbn!O$5,5,0)","v":5},{"$f":"IF(jwbn!P15=jwbn!P$5,5,0)","v":5},{"$f":"IF(jwbn!Q15=jwbn!Q$5,5,0)","v":0},{"$f":"IF(jwbn!R15=jwbn!R$5,5,0)","v":0},{"$f":"IF(jwbn!S15=jwbn!S$5,5,0)","v":5},{"$f":"IF(jwbn!T15=jwbn!T$5,5,0)","v":5},{"$f":"IF(jwbn!U15=jwbn!U$5,5,0)","v":5},{"$f":"IF(jwbn!V15=jwbn!V$5,5,0)","v":5}]

{"sheet":"nilai akhir","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3]]}
["NILAI UTS SMT GANJIL"]
["MAPEL PRAKARYA"]
[]
["NO","NAMA SISWA","NILAI","KET"]
[]
[1,{"$f":"VLOOKUP(A6,DATA,2,TRUE)","v":"ADAM ABYAN MALIK"},{"$f":"SUM(hasil!C3:V3)","v":65},{"$f":"IF(C6<75,\"BELUM TUNTAS\",\"TUNTAS\")","v":"BELUM TUNTAS"}]
[2,"ADINDA RAMADHINA MALIK",{"$f":"SUM(hasil!C4:V4)","v":75},{"$f":"IF(C7<75,\"BELUM TUNTAS\",\"TUNTAS\")","v":"TUNTAS"}]
[3,"AERIO GANI MARTIZA",{"$f":"SUM(hasil!C5:V5)","v":95},"TUNTAS"]
[4,"ALFIRA NAJMI RAMADHANI",{"$f":"SUM(hasil!C6:V6)","v":80},"TUNTAS"]
[5,"ANINDYA LINTANG MAHARANI",{"$f":"SUM(hasil!C7:V7)","v":75},"TUNTAS"]
[6,"ANNISA CASRIA HERDIANTI",{"$f":"SUM(hasil!C8:V8)","v":80},"TUNTAS"]
[7,"ARYA PUTRA DARMAWAN",{"$f":"SUM(hasil!C9:V9)","v":55},"BELUM TUNTAS"]
[8,"AULIA UROHMAH",{"$f":"SUM(hasil!C10:V10)","v":85},"TUNTAS"]
[9,"AZZAHRA SALSABILA",{"$f":"SUM(hasil!C11:V11)","v":95},"TUNTAS"]
[10,"BILLGIES NUGRAHA AL-AZIZ",{"$f":"SUM(hasil!C12:V12)","v":65},"BELUM TUNTAS"]