{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["NOTA PENGGUNAAN","e-PC Form","Transcript","data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":44,"comments":1,"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":"NOTA PENGGUNAAN","index":0,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,8,17,17],[6,1,8,24],[10,1,10,24]]}
[]
[]
[]
[]
[]
[]
[null,"WELCOME TO E-PC "]
[]
[]
[]
[null,"version Oct 2022 - untuk pelajar lepasan diploma FBM UiTM sahaja"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Nota Penggunaan"]

{"sheet":"e-PC Form","index":1,"n_rows":70,"n_cols":75,"rows_kept":70,"cut":false,"hidden":false,"merged":[[43,12,43,13],[40,3,40,5],[40,9,40,11],[41,3,41,5],[41,9,41,11],[42,3,42,5],[42,9,42,11],[37,3,37,5],[37,9,37,11],[38,3,38,5],[38,9,38,11],[39,3,39,5],[39,9,39,11],[5,2,5,5],[9,2,9,3],[13,9,13,11],[7,8,7,11],[7,2,7,3],[13,2,13,4],[9,9,9,11],[11,2,11,4],[11,9,11,11],[17,14,18,14],[25,9,25,11],[23,9,23,11],[22,9,22,11],[21,9,21,11],[18,9,18,11],[26,9,26,11],[27,9,27,11],[33,9,33,11],[34,9,34,11],[35,9,35,11],[29,9,29,11],[30,9,30,11],[28,9,28,11],[31,9,31,11],[32,9,32,11],[33,3,33,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[31,3,31,5],[32,3,32,5],[24,3,24,5],[17,1,17,6],[17,7,17,13],[19,9,19,11],[20,9,20,11],[24,9,24,11],[25,3,25,5],[46,3,47,5],[46,10,47,13],[17,15,18,15],[36,3,36,5],[36,9,36,11],[35,3,35,5],[34,3,34,5],[22,3,22,5],[23,3,23,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[26,3,26,5],[27,3,27,5]]}
[]
[null,"E-PC Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subject Code - Name",null,"Subject Code - Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Transkrip di masukkan dalam format PDF, sila 'double click' untuk paparan penuh"]
[null,"PERMOHONAN PENGECUALIAN KREDIT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KKR1","Ko-Kurikulum I","HBU111","Ko-Kurikulum I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BMD101","Mandarin Language I ","TAC/TMC401","Third Language I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Viewing mode:",null,"Pelajar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BAB101","Arabic Language I","ACC407","Immediate Financial Accounting and Reporting"]
[null,"Nama Pelajar :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAC101","Foundation Arabic (Level I)","LAW416","Business Law"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TMC101","Foundation Mandarin (Level I)","HRM533","Introduction to Human Resource Management"]
[null,"No Pelajar :",null,null,null,null,null,null,"Maklumat Program Diploma",null,null,null,null,null,null,null,null,null,"Guide for approver",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TMC151","Foundation Mandarin (Level II)","MGT420","Principles and Practices of Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACC100","Accounting","MKT420","Principles and Practice of Marketing"]
[null,"No Kad Pengenalan :",null,null,null,null,null,null,"Nama Institusi :","UiTM",null,null,null,null,null,null,null,null,"Column \"Semester\" and \"Nama Kursus\" is not checked automatically",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACC106","Introduction to Financial Accounting and Reporting","HBU121","Ko-Kurikulum II"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACC117","Introduction to Financial Accounting","TAC/TMC451","Third Language II"]
[null,"Fakulti/Kampus :","Pengurusan dan Perniagaan",null,null,null,null,null,"Fakulti :","Pengurusan dan Perniagaan",null,null,null,null,null,null,null,null,"-1 = blank/not entered - Perlu Semakan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACC115","Financial Accounting ","FIN420","Financial Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACC150","Principles of Accounting 1 ","OPM530","Introduction to Operation Management"]
[null,"Nama Program :",null,null,null,"Kod Program :",{"$f":"_xlfn.IFNA(INDEX(KodDegree,MATCH(C14,NamaDegree,0)),\"\")","v":""},null,"Nama Program :",null,null,null,"Kod Program :",{"$f":"_xlfn.IFNA(INDEX(KodDiploma,MATCH(J14,NamaDiploma,0)),\"\")","v":""},null,null,null,null,"0 = OK - Layak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAW166","Business Law","HBU131","Ko-Kurikulum III"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAW299","Business Law","ECO415","Economics"]
[" =","Mod Program :","Sepenuh Masa",null,null,null,null,null,"Mod Program :","Sepenuh Masa",null,null,null,null,null,null,null,null,"1 = error / not matching the list in \"Data\" - Tidak Layak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAW251","Business Law","ECO415","Economics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGT370","Human Resource Management","INS452","Risk, Insurance and Takaful"]
[null,"Kursus UiTM Yang Dipohon Pengecualian Kredit",null,null,null,null,null,"Kursus Terdahulu Yang Mempunyai Kesetaraan",null,null,null,null,null,null,"Kelayakan","Pengesahan",null,null,"Check","more than 1 req?",null,null,"Check","Check",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGT340","Human Resource Management","IBM530","Introduction to International Business"]
[null,"Semester","Kod Kursus","Nama Kursus",null,null,"Jam Kredit","Semester","Kod Kursus","Nama Kursus",null,null,"Jam Kredit","Gred",null,null,"Checkbox","Blank line?","Kod","check from pairing list","sumif this page",null,"Jam","Gred",null,"Result","layak duplicate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGT160","Fundamentals of Management","TPT457","Principles and Practices of Transport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(LEN(CONCATENATE(C20,D20,G20,I20,J20,M20,N20))=0,\"blank\")","v":"blank"},{"$f":"VALUE(IF(LEN(I20)=0,\"-1\",IF(COUNTIF(data!$BB3:$BO3,I20)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W20+X20=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C20&\"_\"&I20,data!$BT$2:$BT$26),\"0\")","v":"0"},{"$f":"SUMIF($C$20:$C$43,C20,$T$20:$T$43)","v":0},{"$f":"VALUE(IF(U20<1,IF(T20=0,\"0\",\"1\"),\"0\"))","v":1},{"$f":"VALUE(IF(OR(ISBLANK($G20),ISBLANK($M20)),\"-1\",IF($M20>=$G20,\"0\",\"1\")))","v":-1},{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N20,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C20,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,{"$f":"IF(R20=\"blank\",\"\",IF(OR(S20>0,V20>0,W20>0,X20>0),\"Tidak Layak\",IF(OR(S20<0,V20<0,W20<0,X20<0),\"Perlu Semakan\",\"Layak\")))","v":""},{"$f":"IF(O20=\"Layak\",C20,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGT162","Fundamentals of Management","TPT457","Principles and Practices of Transport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(LEN(CONCATENATE(C21,D21,G21,I21,J21,M21,N21))=0,\"blank\")","v":"blank"},{"$f":"VALUE(IF(LEN(I21)=0,\"-1\",IF(COUNTIF(data!$BB4:$BO4,I21)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W21+X21=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C21&\"_\"&I21,data!$BT$2:$BT$26),\"0\")","v":"0"},{"$f":"SUMIF($C$20:$C$43,C21,$T$20:$T$43)","v":0},{"$f":"VALUE(IF(U21<1,IF(T21=0,\"0\",\"1\"),\"0\"))","v":1},{"$f":"VALUE(IF(OR(ISBLANK($G21),ISBLANK($M21)),\"-1\",IF($M21>=$G21,\"0\",\"1\")))","v":-1},{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N21,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C21,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,{"$f":"IF(R21=\"blank\",\"\",IF(OR(S21>0,V21>0,W21>0,X21>0),\"Tidak Layak\",IF(OR(S21<0,V21<0,W21<0,X21<0),\"Perlu Semakan\",\"Layak\")))","v":""},{"$f":"IF(O21=\"Layak\",C21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MKT260","Fundamentals of Marketing","ASM401","Fundamentals of Business"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I22)=0,\"-1\",IF(COUNTIF(data!$BB5:$BO5,I22)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W22+X22=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C22&\"_\"&I22,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N22,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C22,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MKT243","Fundamentals of Marketing","ASM401","Fundamentals of Business"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I23)=0,\"-1\",IF(COUNTIF(data!$BB6:$BO6,I23)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W23+X23=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C23&\"_\"&I23,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N23,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C23,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KKRII","Ko-Kurikulum II","ASM401","Fundamentals of Business"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I24)=0,\"-1\",IF(COUNTIF(data!$BB7:$BO7,I24)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W24+X24=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C24&\"_\"&I24,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N24,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C24,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BMD151","Mandarin Language II","EVM401","Introduction to Event Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I25)=0,\"-1\",IF(COUNTIF(data!$BB8:$BO8,I25)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W25+X25=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C25&\"_\"&I25,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N25,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C25,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BAB151","Arabic Language II","ASM401","Fundamentals of Business"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I26)=0,\"-1\",IF(COUNTIF(data!$BB9:$BO9,I26)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W26+X26=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C26&\"_\"&I26,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N26,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C26,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAC151","Foundation Arabic (Level II)","ASM404","Communication for Professionals "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I27)=0,\"-1\",IF(COUNTIF(data!$BB10:$BO10,I27)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W27+X27=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C27&\"_\"&I27,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N27,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C27,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIN260","Fundamentals of Finance","ASM402","Information And Communication Technologies In Organizations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I28)=0,\"-1\",IF(COUNTIF(data!$BB11:$BO11,I28)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W28+X28=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C28&\"_\"&I28,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N28,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C28,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIN262","Fundamentals of Finance","ASM403","Administrative Procedures"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I29)=0,\"-1\",IF(COUNTIF(data!$BB12:$BO12,I29)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W29+X29=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C29&\"_\"&I29,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N29,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C29,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIN242","Fundamentals of Finance","ASM451","Records Management for Administrative Professionals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I30)=0,\"-1\",IF(COUNTIF(data!$BB13:$BO13,I30)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W30+X30=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C30&\"_\"&I30,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N30,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C30,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGT345","Operations Managements","ASM453","Administrative Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I31)=0,\"-1\",IF(COUNTIF(data!$BB14:$BO14,I31)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W31+X31=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C31&\"_\"&I31,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N31,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C31,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGT375","Operations Managements","ASM454","Internet Technology and Web Designing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I32)=0,\"-1\",IF(COUNTIF(data!$BB15:$BO15,I32)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W32+X32=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C32&\"_\"&I32,data!$BT$2:$BT$26),\"0\")","v":"0"},0,{"$f":"VALUE(IF(U32<1,IF(T32=0,\"0\",\"1\"),\"0\"))","v":1},-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N32,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C32,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KKRIII","Ko-Kurikulum III"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I33)=0,\"-1\",IF(COUNTIF(data!$BB16:$BO16,I33)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W33+X33=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C33&\"_\"&I33,data!$BT$2:$BT$26),\"0\")","v":"0"},0,{"$f":"VALUE(IF(U33<1,IF(T33=0,\"0\",\"1\"),\"0\"))","v":1},-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N33,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C33,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INS200","Risk and Insurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I34)=0,\"-1\",IF(COUNTIF(data!$BB17:$BO17,I34)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W34+X34=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C34&\"_\"&I34,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N34,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C34,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INS250","Risk and Insurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I35)=0,\"-1\",IF(COUNTIF(data!$BB18:$BO18,I35)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W35+X35=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C35&\"_\"&I35,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N35,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C35,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INS210","Fundamentals of Insurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I36)=0,\"-1\",IF(COUNTIF(data!$BB19:$BO19,I36)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W36+X36=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C36&\"_\"&I36,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N36,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C36,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INS312","Fundamentals of Insurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I37)=0,\"-1\",IF(COUNTIF(data!$BB20:$BO20,I37)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W37+X37=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C37&\"_\"&I37,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N37,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C37,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGT358","Introduction to International Business "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I38)=0,\"-1\",IF(COUNTIF(data!$BB21:$BO21,I38)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W38+X38=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C38&\"_\"&I38,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N38,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C38,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGT361","Introduction to International Business "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I39)=0,\"-1\",IF(COUNTIF(data!$BB22:$BO22,I39)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W39+X39=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C39&\"_\"&I39,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N39,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C39,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TPT320","Business Logistics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I40)=0,\"-1\",IF(COUNTIF(data!$BB23:$BO23,I40)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W40+X40=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C40&\"_\"&I40,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N40,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C40,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TPT250","Fundamentals of Transport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I41)=0,\"-1\",IF(COUNTIF(data!$BB24:$BO24,I41)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W41+X41=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C41&\"_\"&I41,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N41,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C41,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TPT150","Introduction to Transport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I42)=0,\"-1\",IF(COUNTIF(data!$BB25:$BO25,I42)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W42+X42=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C42&\"_\"&I42,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N42,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C42,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TPT252","Business Logistics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"blank",{"$f":"VALUE(IF(LEN(I43)=0,\"-1\",IF(COUNTIF(data!$BB26:$BO26,I43)=0,\"-1\",\"0\")))","v":-1},{"$f":"IF(W43+X43=0,SUMIF(data!$BS$2:$BS$26,'e-PC Form'!C43&\"_\"&I43,data!$BT$2:$BT$26),\"0\")","v":"0"},0,1,-1,{"$f":"VALUE(_xlfn.IFNA(IF(MATCH($N43,INDEX(gradelist,0,1),0)<=MATCH(INDEX(listkoddiploma,1+MATCH($C43,listkoddegree,0),MATCH($G$14,data!$P$2:$AD$2,0)),gradelist,0),\"0\",\"1\"),\"-1\"))","v":-1},"unique in deg list","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT115","Introduction to Business"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jumlah Kod  yang layak diberi PC",null,{"$f":"AA44&\" / \"&Y44","v":"0 / 0"},null,{"$f":"COUNTIF(Q20:Q43, \"TRUE\")","v":0},{"$f":"COUNTIF(R20:R43, \"FALSE\")","v":0},null,null,null,null,null,null,{"$f":"SUMPRODUCT(($C$20:$C$43<>\"\")/COUNTIF($C$20:$C$43,$C$20:$C$43&\"\"))","v":0},{"$f":"COUNTIF($O$20:$O$43,\"Layak\")","v":0},{"$f":"SUMPRODUCT(($AA$20:$AA$43<>\"\")/COUNTIF($AA$20:$AA$43,$AA$20:$AA$43&\"\"))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT290","Organizing Events"]
[null,"Saya mengaku bahawa keterangan yang diberi dalam borang ini adalah betul dan benar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBM310","Organizing Events"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBM155","Interpersonal Communications for Office Professionals"]
[null,"Pengesahan elektronik:",null,null,null,null,null,null,"Pengesahan elektronik:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT155","Interpersonal Communications for Office Professionals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT165","Public Speaking "]
[null,"Tandatangan Pelajar:",null,null,null,null,null,null,"Tandatangan Pensyarah:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT240","Public Speaking "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COM165","Public Speaking "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBM182","Office Administration Ii"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT182","Office Administration Ii"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT351","Administrative Office Management "]
[null,"Nota Tambahan:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBM345","Administrative Office Management "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO169","Microeconomics "]
[null,"Kursus Sarjana Muda yang memerlukan dua atau lebih kursus diploma untuk mendapat pengecualian kredit. Pelajar perlu memasukkan maklumat semua kursus diploma yang setara.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO161","Microeconomics "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO162","Microeconomics "]
[null,"1) ECO 415","Kursus ini memerlukan ECO 161/162 dan ECO 210/211 untuk mendapat PC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO210","Macroeconomics"]
[null,null,"atau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO211","Macroeconomics"]
[null,null,"ECO 120 sahaja",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO120","Principles of Economics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO107","Principles of Economics"]
[null,null,"Contoh pengisian borang:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO219","Macroeconomics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO164","Macroeconomics"]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CSC134","Computer And Information Processing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT167","Records Management For Administrative Professionals"]
[null,"2) ASM 401","Kursus ini memerlukan MGT 162/160 dan MKT 243 dan FIN 242 untuk mendapat PC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBM247","Records Management For Administrative Professionals"]
[null,null,"atau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMT255","Office Software Applications "]
[null,null,"OMT 115 sahaja",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBM255","Office Software Applications "]
[]
[null,"3) TPT 457","Kursus ini memerlukan TPT 150 / 250 dan TPT 252 / 250 untuk mendapat PC"]

{"sheet":"Transcript","index":2,"n_rows":5,"n_cols":21,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["TRANSKRIP DIPLOMA"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lecturer"]

{"sheet":"data","index":3,"n_rows":57,"n_cols":86,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["Version","GARIS PANDUAN PC FPP _OCT2021_25102021  V2 UPDATED",null,null,null,null,null,null,"Senarai Kelayakan Program Diploma FBM",null,null,null,"count PC list:",{"$f":"COUNTA(N3:N40)","v":29},"selected degree:",{"$f":"MATCH('e-PC Form'!G14,data!P2:AD2,0)+15","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,null,null,"More than 1 subject requirement for PC"]
[null,null,null,null,null,null,null,null,"Semester","Kod","Nama","Jam","Semester","Kod","Nama","BA232","BA233","BA234","BA235","BA236","BA240","BA241","BA242","BA243","BA244","BA245","BA246","BA247","BA249","BA250",null,"occurrence",null,null,null,"Formatted code pairing from PDF Garis Panduan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"occurrence",null,"for data validation drop down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECO415_ECO161",0.5,null,null,null,null,null,null,null,null,null,"colourindex"]
["UiTM",null,null,null,null,null,null,null,null,"HBU111","Ko-Kurikulum I",1,null,{"$f":"_xlfn.TEXTJOIN(\"/\",TRUE,AJ3:AW3)","v":"KKR1"},"Ko-Kurikulum I","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH3",{"$f":"J3","v":"HBU111"},{"$f":"AH3&\"_\"&AF3","v":"HBU111_1"},"KKR1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C20","v":0},1,null,{"$f":"IF(ISNA(VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BB$1,FALSE)),\"\",IF(VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BB$1,FALSE)=0,\"\",VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BB$1,FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BC$1,FALSE)),\"\",IF(VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BC$1,FALSE)=0,\"\",VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BC$1,FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BD$1,FALSE)),\"\",IF(VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BD$1,FALSE)=0,\"\",VLOOKUP($AY3&\"_\"&$AZ3,$AI$3:$AW$31,BD$1,FALSE)))","v":""},"","","","","","","","","","","","line1","DROPDOWN WITHOUT BLANKS",null,"ECO415_ECO162",0.5,null,null,null,null,null,null,null,null,null,null,1,15,29,43]
[null,null,null,null,null,null,null,null,null,"TAC/TMC401","Third Language I",2,null,{"$f":"_xlfn.TEXTJOIN(\"/\",TRUE,AJ4:AW4)","v":"BMD101/BAB101/TAC101/TMC101/TMC151"},"Third Language I","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,{"$f":"COUNTIF(INDIRECT(AG4),AH4)","v":1},"AH3:AH4",{"$f":"J4","v":"TAC/TMC401"},{"$f":"AH4&\"_\"&AF4","v":"TAC/TMC401_1"},"BMD101","BAB101","TAC101","TMC101","TMC151",null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C21","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY4)>COUNTIF($AY$3:AY4,AY4),COUNTIF($AY$3:AY4,AY4),COUNTIF($AH$3:$AH$31,AY4))","v":0},null,{"$f":"IF(ISNA(VLOOKUP($AY4&\"_\"&$AZ4,$AI$3:$AW$31,BB$1,FALSE)),\"\",IF(VLOOKUP($AY4&\"_\"&$AZ4,$AI$3:$AW$31,BB$1,FALSE)=0,\"\",VLOOKUP($AY4&\"_\"&$AZ4,$AI$3:$AW$31,BB$1,FALSE)))","v":""},"","","","","","","","","","","","","","line2",null,null,"ECO415_ECO210",0.5,null,null,null,null,null,null,null,null,null,null,2,16,30,44]
[null,null,null,null,null,null,null,null,null,"ACC407","Immediate Financial Accounting and Reporting",3,null,{"$f":"_xlfn.TEXTJOIN(\"/\",TRUE,AJ5:AW5)","v":"ACC100/ACC106/ACC115/ACC117/ACC150"},"Introduction to Financial Accounting and Reporting / Financial Accounting","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,{"$f":"COUNTIF(INDIRECT(AG5),AH5)","v":1},"AH3:AH5","ACC407","ACC407_1","ACC100","ACC106","ACC115","ACC117","ACC150",null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C22","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY5)>COUNTIF($AY$3:AY5,AY5),COUNTIF($AY$3:AY5,AY5),COUNTIF($AH$3:$AH$31,AY5))","v":0},null,"","","","","","","","","","","","","","","line3",null,null,"ECO415_ECO211",0.5,null,null,null,null,null,null,null,null,null,null,3,17,31,45]
["Pengurusan dan Perniagaan",null,null,null,null,null,null,null,null,"LAW416","Business Law",3,null,"LAW166/LAW251/LAW299","Business Law","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH6","LAW416","LAW416_1","LAW166","LAW251","LAW299",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C23","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY6)>COUNTIF($AY$3:AY6,AY6),COUNTIF($AY$3:AY6,AY6),COUNTIF($AH$3:$AH$31,AY6))","v":0},null,"","","","","","","","","","","","","","","line4",null,null,"ECO415_ECO120",1,null,null,null,null,null,null,null,null,null,null,4,18,32,46]
["Lain-lain",null,null,null,null,null,null,null,null,"HRM533","Introduction to Human Resource Management",3,null,"MGT370/MGT340","Human Resource Management","C","C","C","C","C","C","C","C","B","C","C","C","C","C","C",null,1,"AH3:AH7","HRM533","HRM533_1","MGT370","MGT340",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C24","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY7)>COUNTIF($AY$3:AY7,AY7),COUNTIF($AY$3:AY7,AY7),COUNTIF($AH$3:$AH$31,AY7))","v":0},null,"","","","","","","","","","","","","","","line5",null,null,"ASM401_MGT162",0.3,null,null,null,null,null,null,null,null,null,null,5,19,33,47]
[null,null,null,null,null,null,null,null,null,"MGT420","Principles and Practices of Management",3,null,"MGT160/MGT162","Fundamentals of Management","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH8","MGT420","MGT420_1","MGT160","MGT162",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C25","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY8)>COUNTIF($AY$3:AY8,AY8),COUNTIF($AY$3:AY8,AY8),COUNTIF($AH$3:$AH$31,AY8))","v":0},null,"","","","","","","","","","","","","","","line6",null,null,"ASM401_MGT160",0.3,null,null,null,null,null,null,null,null,null,null,6,20,34,48]
[null,null,null,null,null,null,null,null,null,"MKT420","Principles and Practice of Marketing",3,null,"MKT260/MKT243","Fundamentals of Marketing","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH9","MKT420","MKT420_1","MKT260","MKT243",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C26","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY9)>COUNTIF($AY$3:AY9,AY9),COUNTIF($AY$3:AY9,AY9),COUNTIF($AH$3:$AH$31,AY9))","v":0},null,"","","","","","","","","","","","","","","line7",null,null,"ASM401_MKT243",0.3,null,null,null,null,null,null,null,null,null,null,7,21,35,49]
["BM111","Diploma Pengajian Perniagaan",null,null,null,null,null,null,null,"HBU121","Ko-Kurikulum II",1,null,"KKRII","Ko-Kurikulum II","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH10","HBU121","HBU121_1","KKRII",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C27","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY10)>COUNTIF($AY$3:AY10,AY10),COUNTIF($AY$3:AY10,AY10),COUNTIF($AH$3:$AH$31,AY10))","v":0},null,"","","","","","","","","","","","","","","line8",null,null,"ASM401_FIN242",0.4,null,null,null,null,null,null,null,null,null,null,8,22,36,50]
["BM114","Diploma Analisis Pelaburan",null,null,null,null,null,null,null,"TAC/TMC451","Third Language II",2,null,"BMD151/BAB151/TAC151/TMC151","Third Language II","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH11","TAC/TMC451","TAC/TMC451_1","BMD151","BAB151","TAC151","TMC151",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C28","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY11)>COUNTIF($AY$3:AY11,AY11),COUNTIF($AY$3:AY11,AY11),COUNTIF($AH$3:$AH$31,AY11))","v":0},null,"","","","","","","","","","","","","","","line9",null,null,"ASM401_OMT115",1,null,null,null,null,null,null,null,null,null,null,9,23,37,51]
["BM115","Diploma Pengajian Insurans",null,null,null,null,null,null,null,"FIN420","Financial Management",3,null,"FIN260/FIN262/FIN242","Fundamentals of Finance","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH12","FIN420","FIN420_1","FIN260","FIN262","FIN242",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C29","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY12)>COUNTIF($AY$3:AY12,AY12),COUNTIF($AY$3:AY12,AY12),COUNTIF($AH$3:$AH$31,AY12))","v":0},null,"","","","","","","","","","","","","","","line10",null,null,"TPT457_TPT150",0.5,null,null,null,null,null,null,null,null,null,null,10,24,38,52]
["BM117","Diploma Pengajian Perniagaan (Pengangkutan)",null,null,null,null,null,null,null,"OPM530","Introduction to Operation Management",3,null,"MGT345/MGT375","Operations Managements","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH13","OPM530","OPM530_1","MGT345","MGT375",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C30","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY13)>COUNTIF($AY$3:AY13,AY13),COUNTIF($AY$3:AY13,AY13),COUNTIF($AH$3:$AH$31,AY13))","v":0},null,"","","","","","","","","","","","","","","line11",null,null,"TPT457_TPT250",0.5,null,null,null,null,null,null,null,null,null,null,11,25,39,53]
["BM118","Diploma Pengurusan Teknologi Pejabat",null,null,null,null,null,null,null,"HBU131","Ko-Kurikulum III",1,null,"KKRIII","Ko-Kurikulum III","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C",null,1,"AH3:AH14","HBU131","HBU131_1","KKRIII",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C31","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY14)>COUNTIF($AY$3:AY14,AY14),COUNTIF($AY$3:AY14,AY14),COUNTIF($AH$3:$AH$31,AY14))","v":0},null,"","","","","","","","","","","","","","","line12",null,null,"TPT457_TPT252",0.5,null,null,null,null,null,null,null,null,null,null,12,26,40,54]
["BM119","Diploma Pengajian Perbankan",null,null,null,null,null,null,null,"ECO415","Economics",3,null,"ECO161/ECO162/ECO120","Microeconomics dan Macroeconomics / Principles of Economics","C","C","C","C","C","C","C","C","C","C","C","C","C","C","B",null,1,"AH3:AH15","ECO415","ECO415_1","ECO161","ECO162","ECO120",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C32","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY15)>COUNTIF($AY$3:AY15,AY15),COUNTIF($AY$3:AY15,AY15),COUNTIF($AH$3:$AH$31,AY15))","v":0},null,"","","","","","","","","","","","","","","line13",null,null,"TPT457_TPT250",0.5,null,null,null,null,null,null,null,null,null,null,13,27,41,55]
[null,null,null,null,null,null,null,null,null,"ECO415","Economics",3,null,"ECO210/ECO211","Microeconomics dan Macroeconomics / Principles of Economics","C","C","C","C","C","C","C","C","C","C","C","C","C","C","B",null,2,"AH3:AH16","ECO415","ECO415_2","ECO210","ECO211",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C33","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY16)>COUNTIF($AY$3:AY16,AY16),COUNTIF($AY$3:AY16,AY16),COUNTIF($AH$3:$AH$31,AY16))","v":0},null,"","","","","","","","","","","","","","","line14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,28,42,56]
["ACX11X","Diploma XXX",null,null,null,null,null,null,null,"INS452","Risk, Insurance and Takaful",3,null,"INS200/INS250/INS210/INS312","Risk and Insurance atau Fundamentals of Insurance",null,null,null,null,null,null,"B",null,null,null,null,null,null,null,null,null,1,"AH3:AH17","INS452","INS452_1","INS200","INS250","INS210","INS312",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C34","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY17)>COUNTIF($AY$3:AY17,AY17),COUNTIF($AY$3:AY17,AY17),COUNTIF($AH$3:$AH$31,AY17))","v":0},null,"","","","","","","","","","","","","","","line15"]
[null,null,null,null,null,null,null,null,null,"IBM530","Introduction to International Business",3,null,"MGT358/MGT361","International Business",null,null,null,null,null,null,null,null,null,"C",null,"C",null,null,null,null,1,"AH3:AH18","IBM530","IBM530_1","MGT358","MGT361",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C35","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY18)>COUNTIF($AY$3:AY18,AY18),COUNTIF($AY$3:AY18,AY18),COUNTIF($AH$3:$AH$31,AY18))","v":0},null,"","","","","","","","","","","","","","","line16"]
[null,null,null,null,null,null,null,null,null,"TPT457","Principles and Practices of Transport",3,null,"TPT150/TPT250","Introduction to Transport dan Principles and Practices in Transport",null,null,null,null,null,null,null,null,null,null,null,null,"B",null,null,null,1,"AH3:AH19","TPT457","TPT457_1","TPT150","TPT250",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C36","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY19)>COUNTIF($AY$3:AY19,AY19),COUNTIF($AY$3:AY19,AY19),COUNTIF($AH$3:$AH$31,AY19))","v":0},null,{"$f":"IF(ISNA(VLOOKUP($AY19&\"_\"&$AZ19,$AI$3:$AW$31,BB$1,FALSE)),\"\",IF(VLOOKUP($AY19&\"_\"&$AZ19,$AI$3:$AW$31,BB$1,FALSE)=0,\"\",VLOOKUP($AY19&\"_\"&$AZ19,$AI$3:$AW$31,BB$1,FALSE)))","v":""},"","","","","","","","","","","","","","line17"]
["BA232","Sarjana Muda Pengurusan Sistem Pejabat (Kepujian)",null,null,null,null,null,null,null,"TPT457","Principles and Practices of Transport",3,null,"TPT252/TPT320","Introduction to Transport dan Principles and Practices in Transport",null,null,null,null,null,null,null,null,null,null,null,null,"B",null,null,null,2,"AH3:AH20","TPT457","TPT457_2","TPT252","TPT320",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C37","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY20)>COUNTIF($AY$3:AY20,AY20),COUNTIF($AY$3:AY20,AY20),COUNTIF($AH$3:$AH$31,AY20))","v":0},null,"","","","","","","","","","","","","","","line18"]
["BA233","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Keusahawanan",null,null,null,null,null,null,null,"ASM401","Fundamentals of Business",3,null,"MGT162/MGT160/OMT115","Fundamentals of Management dan Fundamentals of Marketing dan Fundamentals of Finance","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"AH3:AH21","ASM401","ASM401_1","MGT162","MGT160","OMT115",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C38","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY21)>COUNTIF($AY$3:AY21,AY21),COUNTIF($AY$3:AY21,AY21),COUNTIF($AH$3:$AH$31,AY21))","v":0},null,"","","","","","","","","","","","","","","line19"]
["BA234","Sarjana Muda Perkhidmatan Pelangaan (Kepujian)",null,null,null,null,null,null,null,"ASM401","Fundamentals of Business",3,null,"MKT243","Fundamentals of Management dan Fundamentals of Marketing dan Fundamentals of Finance","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"AH3:AH22","ASM401","ASM401_2","MKT243",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C39","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY22)>COUNTIF($AY$3:AY22,AY22),COUNTIF($AY$3:AY22,AY22),COUNTIF($AH$3:$AH$31,AY22))","v":0},null,"","","","","","","","","","","","","","","line20"]
["BA235","Sarjana Muda Pentadbiran Kesihatan (Kepujian)",null,null,null,null,null,null,null,"ASM401","Fundamentals of Business",3,null,"FIN242","Fundamentals of Management dan Fundamentals of Marketing dan Fundamentals of Finance","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"AH3:AH23","ASM401","ASM401_3","FIN242",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C40","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY23)>COUNTIF($AY$3:AY23,AY23),COUNTIF($AY$3:AY23,AY23),COUNTIF($AH$3:$AH$31,AY23))","v":0},null,"","","","","","","","","","","","","","","line21"]
["BA236","Sarjana Muda Pengurusan Majlis (Kepujian)",null,null,null,null,null,null,null,"EVM401","Introduction to Event Management",null,null,"OMT290/OBM310","Organizing Events",null,null,null,null,"C",null,null,null,null,null,null,null,null,null,null,null,1,"AH3:AH24","EVM401","EVM401_1","OMT290","OBM310",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C41","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY24)>COUNTIF($AY$3:AY24,AY24),COUNTIF($AY$3:AY24,AY24),COUNTIF($AH$3:$AH$31,AY24))","v":0},null,"","","","","","","","","","","","","","","line22"]
["BA240","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Pemasaran",null,null,null,null,null,null,null,"ASM401","Fundamentals of Business",3,null,"OMT115","Introduction to Business","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"AH3:AH25","ASM401","ASM401_4","OMT115",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C42","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY25)>COUNTIF($AY$3:AY25,AY25),COUNTIF($AY$3:AY25,AY25),COUNTIF($AH$3:$AH$31,AY25))","v":0},null,"","","","","","","","","","","","","","","line23"]
["BA241","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Insurans",null,null,null,null,null,null,null,"ASM404","Communication for Professionals ",3,null,"OMT155/OBM155/OMT165/OMT240/COM165","Interpersonal Communication for Office Professional Atau Public Speaking ","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"AH3:AH26","ASM404","ASM404_1","OMT155","OBM155","OMT165","OMT240","COM165",null,null,null,null,null,null,null,null,null,null,{"$f":"'e-PC Form'!C43","v":0},{"$f":"IF(COUNTIF($AH$3:$AH$31,AY26)>COUNTIF($AY$3:AY26,AY26),COUNTIF($AY$3:AY26,AY26),COUNTIF($AH$3:$AH$31,AY26))","v":0},null,"","","","","","","","","","","","","","","line24"]
["BA242","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Kewangan",null,null,null,null,null,null,null,"ASM402","Information And Communication Technologies In Organizations",null,null,"CSC134","Computer and Information Processing","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"AH3:AH27","ASM402","ASM402_1","CSC134"]
["BA243","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Pengurusan Sumber Manusia)",null,null,null,null,null,null,null,"ASM403","Administrative Procedures",null,null,"OBM182/OMT182/OMT131/OBM131","Office Administration I and II ","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"AH3:AH28","ASM403","ASM403_1","OBM182","OMT182","OMT131","OBM131"]
["BA244","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Pengurusan Operasi",null,null,null,null,null,null,null,"ASM451","Records Management for Administrative Professionals",null,null,{"$f":"_xlfn.TEXTJOIN(\"/\",TRUE,AJ29:AW29)","v":"OMT167/OBM247"},"Records Management for Administrative Professionals","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"AH3:AH29","ASM451","ASM451_1","OMT167","OBM247"]
["BA245","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Pengurusan Peruncitan",null,null,null,null,null,null,null,"ASM453","Administrative Management",3,null,"OMT351/OBM345","Administrative Office Management ","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"AH3:AH30","ASM453","ASM453_1","OMT351","OBM345"]
["BA246","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Perniagaan Antarabangsa",null,null,null,null,null,null,null,"ASM454","Internet Technology and Web Designing",null,null,"OMT255/OBM255","Office Software Applications ","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"AH3:AH31","ASM454","ASM454_1","OMT255","OBM255"]
["BA247","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Pengangkutan"]
["BA249","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Perbankan Islam"]
["BA250","Sarjana Muda Pentadbiran Perniagaan (Kepujian) Ekonomi Perniagaan"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
["Sepenuh Masa"]
["Separuh Masa",null,null,null,null,null,null,null,null,"Codes no longer used"]
[null,null,null,null,null,null,null,null,null,"MGT417","Information Technology in Business",null,null,"MGT300/CSC134/255","Information Technology in Business","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C"]
["A+"]
["A"]
["A-"]
["B+"]
["B"]
["B-"]
["C+"]
["C"]
["LULUS"]
["C-"]
["D+"]
["D"]
["E"]
["F"]
["TIDAK LULUS"]