Employee Name	{{ $user->first_name }} {{ $user->last_name }}
Email	{{ $user->email }}
Organisation	{{ $user->organization }}
Employer Type	{{ $profile['employer_type'] ?? '' }}
Industry Division	{{ $profile['industry'] ?? '' }}
Industry Sub Division	{{ $profile['service'] ?? '' }}
Occupation Major Group	{{ $profile['occupation'] ?? '' }}
Occupation Group	{{ $profile['occupation2'] ?? '' }}
Tenure Overall	{{ $answers->{'21'} ?? '' }}
Tenure Current Organisation	{{ $answers->{'22'} ?? '' }}
Highest Education Level	{{ $profile['education'] ?? '' }}
Gender	{{ $profile['gender'] ?? '' }}
Age Range	{{ $profile['age'] ?? '' }}
Birth Country	{{ $answers->{'26'} ?? '' }}
Ancestry	{{ $answers->{'27'} ?? '' }}
State / Territory	{{ $profile['state'] ?? '' }}
How Long Have You Been In The Workforce?	{{ $answers->{'21'} ?? '' }}
How Long Have You Been Working In Current Organisation?	{{ $answers->{'22'} ?? '' }}
How Long Have You Lived In Australia?	{{ $answers->{'29'} ?? '' }}
How Long Have You Lived Outside Your Country Of Birth?	{{ $answers->{'30'} ?? '' }}

@php $selfTotal = 0; $orgTotal = 0; $industryTotal = 0; $overallTotal = 0; $rowCount = count($reportData); @endphp @foreach($reportData as $row) @php $selfTotal += $row['self']; $orgTotal += $row['organisation']; $industryTotal += $row['industry']; $overallTotal += $row['overall']; @endphp @endforeach

Sub-Dimensions	Self - Individual (A)	Others - Same Organisation (B)	Others - Same Industry (C)	Overall - All Participants (D)
{{ $row['dimension'] }}	{{ number_format($row['self'],2) }}	{{ number_format($row['organisation'],2) }}	{{ number_format($row['industry'],2) }}	{{ number_format($row['overall'],2) }}
Overall	{{ number_format($selfTotal/$rowCount,2) }}	{{ number_format($orgTotal/$rowCount,2) }}	{{ number_format($industryTotal/$rowCount,2) }}	{{ number_format($overallTotal/$rowCount,2) }}

@foreach($reportData as $row) @endforeach

Sub-Dimensions	Self (A)	A-B	A-C	A-D
{{ $row['dimension'] }}	{{ number_format($row['self'],2) }}	{{ number_format($row['gap_org'],2) }}	{{ number_format($row['gap_industry'],2) }}	{{ number_format($row['gap_overall'],2) }}

Interaction Frequency	Self - Individual
12.1 Frequency – Colleagues (Own Organisation)	{{ $answers->{'12_1'} ?? '' }}
12.2 Frequency – Colleagues (Other Organisations)	{{ $answers->{'12_2'} ?? '' }}
12.3 Frequency – Customers / Clients	{{ $answers->{'12_3'} ?? '' }}
12.4 Frequency – Outside Work	{{ $answers->{'12_4'} ?? '' }}

Category	Organisation	Work Unit	Customers / Clients
Ethnicity	{{ $answers->{'13_1'} ?? '' }}	{{ $answers->{'14_1'} ?? '' }}	{{ $answers->{'15_1'} ?? '' }}
Nationality	{{ $answers->{'13_2'} ?? '' }}	{{ $answers->{'14_2'} ?? '' }}	{{ $answers->{'15_2'} ?? '' }}
Customs	{{ $answers->{'13_3'} ?? '' }}	{{ $answers->{'14_3'} ?? '' }}	{{ $answers->{'15_3'} ?? '' }}
Language	{{ $answers->{'13_4'} ?? '' }}	{{ $answers->{'14_4'} ?? '' }}	{{ $answers->{'15_4'} ?? '' }}
Religion	{{ $answers->{'13_5'} ?? '' }}	{{ $answers->{'14_5'} ?? '' }}	{{ $answers->{'15_5'} ?? '' }}