| GROUP |
Male/Female |
Total Examinees |
Appeared Examinees |
GPA 5 |
% |
GPA 4 to <5 |
% |
GPA 3.5 to <4 |
% |
GPA 3 to <3.5 |
% |
GPA 2 to <3 |
% |
GPA 1 to <2 |
% |
@php
$total_examinees = [0,0];
$total_appeared = [0,0];
$total_gpa_5 = [0,0];
$total_gpa_4 = [0,0];
$total_gpa_35 = [0,0];
$total_gpa_3 = [0,0];
$total_gpa_2 = [0,0];
$total_gpa_1 = [0,0];
@endphp
@foreach($gpaData as $group_name => $group_info)
@php
$total_examinees = [$total_examinees[0] + $group_info[0]->totalExaminee, $total_examinees[1] + $group_info[1]->totalExaminee];
$total_appeared = [
$total_appeared[0] + $group_info[0]->totalExaminee - $group_info[0]->absent,
$total_appeared[1] + $group_info[1]->totalExaminee - $group_info[1]->absent,
];
$total_gpa_5 = [$total_gpa_5[0] + $group_info[0]->gpa5, $total_gpa_5[1] + $group_info[1]->gpa5];
$total_gpa_4 = [$total_gpa_4[0] + $group_info[0]->gpa4, $total_gpa_4[1] + $group_info[1]->gpa4];
$total_gpa_35 = [$total_gpa_35[0] + $group_info[0]->gpa35, $total_gpa_35[1] + $group_info[1]->gpa35];
$total_gpa_3 = [$total_gpa_3[0] + $group_info[0]->gpa3, $total_gpa_3[1] + $group_info[1]->gpa3];
$total_gpa_2 = [$total_gpa_2[0] + $group_info[0]->gpa2, $total_gpa_2[1] + $group_info[1]->gpa2];
$total_gpa_1 = [$total_gpa_1[0] + $group_info[0]->gpa1, $total_gpa_1[1] + $group_info[1]->gpa1];
@endphp
| {{$group_name}} |
male |
{{number_format($group_info[1]->totalExaminee)}} |
{{number_format($group_info[1]->totalExaminee - $group_info[1]->absent)}} |
{{number_format($group_info[1]->gpa5)}} |
{{number_format($group_info[1]->gpa5 * 100 / ($group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[1]->gpa4)}} |
{{number_format($group_info[1]->gpa4 * 100 / ($group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[1]->gpa35)}} |
{{number_format($group_info[1]->gpa35 * 100 / ($group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[1]->gpa3)}} |
{{number_format($group_info[1]->gpa3 * 100 / ($group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[1]->gpa2)}} |
{{number_format($group_info[1]->gpa2 * 100 / ($group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[1]->gpa1)}} |
{{number_format($group_info[1]->gpa1 * 100 / ($group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
| female |
{{number_format($group_info[0]->totalExaminee)}} |
{{number_format($group_info[0]->totalExaminee - $group_info[0]->absent)}} |
{{number_format($group_info[0]->gpa5)}} |
{{number_format($group_info[0]->gpa5 * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent), 2)}} |
{{number_format($group_info[0]->gpa4)}} |
{{number_format($group_info[0]->gpa4 * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent), 2)}} |
{{number_format($group_info[0]->gpa35)}} |
{{number_format($group_info[0]->gpa35 * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent), 2)}} |
{{number_format($group_info[0]->gpa3)}} |
{{number_format($group_info[0]->gpa3 * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent), 2)}} |
{{number_format($group_info[0]->gpa2)}} |
{{number_format($group_info[0]->gpa2 * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent), 2)}} |
{{number_format($group_info[0]->gpa1)}} |
{{number_format($group_info[0]->gpa1 * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent), 2)}} |
| total |
{{number_format($group_info[0]->totalExaminee + $group_info[1]->totalExaminee)}} |
{{number_format($group_info[0]->totalExaminee - $group_info[0]->absent + $group_info[1]->totalExaminee - $group_info[1]->absent)}} |
{{number_format($group_info[0]->gpa5 + $group_info[1]->gpa5)}} |
{{number_format(($group_info[0]->gpa5 + $group_info[1]->gpa5) * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent + $group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[0]->gpa4 + $group_info[1]->gpa4)}} |
{{number_format(($group_info[0]->gpa4 + $group_info[1]->gpa4) * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent + $group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[0]->gpa35 + $group_info[1]->gpa35)}} |
{{number_format(($group_info[0]->gpa35 + $group_info[1]->gpa35) * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent + $group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[0]->gpa3 + $group_info[1]->gpa3)}} |
{{number_format(($group_info[0]->gpa3 + $group_info[1]->gpa3) * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent + $group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[0]->gpa2 + $group_info[1]->gpa2)}} |
{{number_format(($group_info[0]->gpa2 + $group_info[1]->gpa2) * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent + $group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
{{number_format($group_info[0]->gpa1 + $group_info[1]->gpa1)}} |
{{number_format(($group_info[0]->gpa1 + $group_info[1]->gpa1) * 100 / ($group_info[0]->totalExaminee - $group_info[0]->absent + $group_info[1]->totalExaminee - $group_info[1]->absent), 2)}} |
@endforeach
| total male |
|
{{number_format($total_examinees[1])}} |
{{number_format($total_appeared[1])}} |
{{number_format($total_gpa_5[1])}} |
{{number_format($total_gpa_5[1] * 100 / $total_appeared[1], 2)}} |
{{number_format($total_gpa_4[1])}} |
{{number_format($total_gpa_4[1] * 100 / $total_appeared[1], 2)}} |
{{number_format($total_gpa_35[1])}} |
{{number_format($total_gpa_35[1] * 100 / $total_appeared[1], 2)}} |
{{number_format($total_gpa_3[1])}} |
{{number_format($total_gpa_3[1] * 100 / $total_appeared[1], 2)}} |
{{number_format($total_gpa_2[1])}} |
{{number_format($total_gpa_2[1] * 100 / $total_appeared[1], 2)}} |
{{number_format($total_gpa_1[1])}} |
{{number_format($total_gpa_1[1] * 100 / $total_appeared[1], 2)}} |
| total female |
|
{{number_format($total_examinees[0])}} |
{{number_format($total_appeared[0])}} |
{{number_format($total_gpa_5[0])}} |
{{number_format($total_gpa_5[0] * 100 / $total_appeared[0], 2)}} |
{{number_format($total_gpa_4[0])}} |
{{number_format($total_gpa_4[0] * 100 / $total_appeared[0], 2)}} |
{{number_format($total_gpa_35[0])}} |
{{number_format($total_gpa_35[0] * 100 / $total_appeared[0], 2)}} |
{{number_format($total_gpa_3[0])}} |
{{number_format($total_gpa_3[0] * 100 / $total_appeared[0], 2)}} |
{{number_format($total_gpa_2[0])}} |
{{number_format($total_gpa_2[0] * 100 / $total_appeared[0], 2)}} |
{{number_format($total_gpa_1[0])}} |
{{number_format($total_gpa_1[0] * 100 / $total_appeared[0], 2)}} |
| grand total |
|
{{number_format($total_examinees[0] + $total_examinees[1])}} |
{{number_format($total_appeared[0] + $total_appeared[1])}} |
{{number_format($total_gpa_5[0] + $total_gpa_5[1])}} |
{{number_format(($total_gpa_5[0] + $total_gpa_5[1]) * 100 / ($total_appeared[0] + $total_appeared[1]), 2)}} |
{{number_format($total_gpa_4[0] + $total_gpa_4[1])}} |
{{number_format(($total_gpa_4[0] + $total_gpa_4[1]) * 100 / ($total_appeared[0] + $total_appeared[1]), 2)}} |
{{number_format($total_gpa_35[0] + $total_gpa_35[1])}} |
{{number_format(($total_gpa_35[0] + $total_gpa_35[1]) * 100 / ($total_appeared[0] + $total_appeared[1]), 2)}} |
{{number_format($total_gpa_3[0] + $total_gpa_3[1])}} |
{{number_format(($total_gpa_3[0] + $total_gpa_3[1]) * 100 / ($total_appeared[0] + $total_appeared[1]), 2)}} |
{{number_format($total_gpa_2[0] + $total_gpa_2[1])}} |
{{number_format(($total_gpa_2[0] + $total_gpa_2[1]) * 100 / ($total_appeared[0] + $total_appeared[1]), 2)}} |
{{number_format($total_gpa_1[0] + $total_gpa_1[1])}} |
{{number_format(($total_gpa_1[0] + $total_gpa_1[1]) * 100 / ($total_appeared[0] + $total_appeared[1]), 2)}} |