@php $i = 1; $cell = 7; $les = $lesson->id; @endphp @foreach($row as $rows) @php $i++; $cell++; @endphp @endforeach

TRANSKRIP NILAI
Tahun Ajaran:		{{ $year->name }}
Kelas:		{{ $class->name }}
Mata Pelajaran:		{{ $lesson->name }}
No	Nama Siswa	NIS	Nilai Semester 1	Nilai Semester 2	Nilai Semester 3	Nilai Semester 4	Nilai Semester 5	Nilai Semester 6	Nilai Rata-rata	Nilai Sekolah	Nilai SKL	Nilai Akhir
{{ $i }}	{{ $rows->name }}	{{ $rows->code }}	{{ $rows->semester_1 ?? 0 }}	{{ $rows->semester_2 ?? 0 }}	{{ $rows->semester_3 ?? 0 }}	{{ $rows->semester_4 ?? 0 }}	{{ $rows->semester_5 ?? 0 }}	{{ $rows->semester_6 ?? 0 }}	=ROUND(AVERAGEIF(D{{$cell}}:I{{$cell}};">0");0)		=ROUND((J{{$cell}}/100*60)+(K{{$cell}}/100*40),0)	=ROUND(AVERAGE(J{{$cell}}:L{{$cell}}),0)