$upload_data = $this->upload->data();
                $file        = $upload_data['full_path'];

                $this->load->library('excel_reader');
                $this->excel_reader->setOutputEncoding('CP1251');
                $this->excel_reader->read($file);
                $dataCell = $this->excel_reader->sheets[0];

                $dataExcel = array();

for ($i = 8; $i < $jumlahPeserta; $i++) {

            $dataExcel[$i - 8]['npm'] = substr($dataCell['cells'][$i][2], 0, 12);
            // average tugas
            $dataExcel[$i - 8]['nilai_1'] = number_format($dataCell['cells'][$i][12], 2);
            // absen
            $dataExcel[$i - 8]['nilai_2'] = number_format($dataCell['cells'][$i][11], 2);
            // UTS
            $dataExcel[$i - 8]['nilai_3'] = number_format($dataCell['cells'][$i][13], 2);
            // UAS
            $dataExcel[$i - 8]['nilai_4'] = $this->_uas_validation($testType, number_format($dataCell['cells'][$i][14]), $kodeJadwal, $dataExcel[$i - 8]['npm']);
            // detail tugas
            $dataExcel[$i - 8]['nilai_5'] = $this->_validasi_nilai_tugas($dataCell['cells'][$i][6]);
            $dataExcel[$i - 8]['nilai_6'] = $this->_validasi_nilai_tugas($dataCell['cells'][$i][7]);
            $dataExcel[$i - 8]['nilai_7'] = $this->_validasi_nilai_tugas($dataCell['cells'][$i][8]);
            $dataExcel[$i - 8]['nilai_8'] = $this->_validasi_nilai_tugas($dataCell['cells'][$i][9]);
            $dataExcel[$i - 8]['nilai_9'] = $this->_validasi_nilai_tugas($dataCell['cells'][$i][10]);

            // guna menghalangi nilai akhir yg tidak sesuai
            $forTotalPoinValidation = [
                'nilai_1' => $dataExcel[$i - 8]['nilai_1'],
                'nilai_2' => $dataExcel[$i - 8]['nilai_2'],
                'nilai_3' => $dataExcel[$i - 8]['nilai_3'],
                'nilai_4' => $dataExcel[$i - 8]['nilai_4'],
                'cell_4'  => $dataCell['cells'][$i][4],
                'cell_15' => $dataCell['cells'][$i][15]
            ];

            // nilai akhir
            $dataExcel[$i - 8]['nilai_10'] = $this->_validasi_nilai_akhir($testType, $kodeJadwal, $forTotalPoinValidation, $dataExcel[$i - 8]['npm']);

            $dataExcel[$i - 8]['code'] = $kodeJadwal;

            $this->_validasi_peserta_kelas($dataExcel[$i - 8]['npm'], $kodeJadwal);

            $datas[] = $dataExcel[$i - 8]['npm'];

            if ($dataExcel[$i - 8]['nilai_1'] < 0
                || $dataExcel[$i - 8]['nilai_2'] < 0
                || $dataExcel[$i - 8]['nilai_3'] < 0
                || $dataExcel[$i - 8]['nilai_4'] < 0
                || $dataExcel[$i - 8]['nilai_1'] > 101
                || $dataExcel[$i - 8]['nilai_2'] > 101
                || $dataExcel[$i - 8]['nilai_3'] > 101
                || $dataExcel[$i - 8]['nilai_4'] > 101
                || ctype_alpha($dataExcel[$i - 8]['nilai_1'])
                || ctype_alpha($dataExcel[$i - 8]['nilai_3'])
                || ctype_alpha($dataExcel[$i - 8]['nilai_4'])) {

                echo "Gagal Upload, Inputan Nilai Tidak Sesuai . <a href='javascript:history.go(-1)'><< Kembali</a>";
                exit();

            }

            $this->_validasi_konten_nilai_akhir($dataExcel[$i - 8]['nilai_10']);
        }