Sheet1Gred Purata Sekolah Dan Gred Purata Mata Pelajaran SMK Lui BaratSPM 20132013Bil DaftarBil HadirA+AA-B+BC+CDEGJumlah BilanganJumlah KiraanGPMPGPSYFB 120326626630932328329526525124127417385249996023.84BM2672663234374839281031702668813.31BI2672666375262822121517532666352.39Pend Is140140317202219201610491405784.13Pend M1271262122321491157501263382.68Sej2672662827222921204030212826612124.56Maths267266585930161216101929172668733.28Sci10710738116121718171411075294.94PSV105104221125292573001044033.88Add M162161358813151724231171616644.12Pdgn72720308561018202724416.13PAkaun41415535633542411684.10Eko A39391111597914392205.64ERT353501113291170352156.14Physics128127181722201391512101274003.15Chem1621613112146101117232981617204.47Bio162161722131892224281441617364.57Twr Is551211000000571.40EST15715618313436231111101565823.73B Know.77211030007014715.07Jumlah Bilangan = A1 +A2 +B3 + B4 + C5 +C6 + D7 + E8 +G9Jumlah Kiraan = A1 x 1 + A2 x 2 + B3 x 3 + B4 x 4 + C5 x 5 + C6 x 6 + D7 x 7 + E8 x 8 + G9 x 9GPS/GPMP = Jumlah Kiraan Jumlah Bilangan

Sheet2

Sheet3