IntroductionThis report summarizes the ESG Navigator data for ABC Company provided by company personnel via the 5 Excel ratings worksheets listed below.
Note: In the tables below, hover over the column headings for brief explanations of each column. Click column headings to sort by that column.
Report run: Sun 6/7/20 14:28
This is a sample report. It includes only a subset of KSIs and the data it contains are not real.
The following 5 ESG Navigator Excel files were provided by ABC Company:
|No.||Contact name||#Rated||%Rated||#HR(!)||%HR(!)||#Comm.||Outliers||Phone||File name|
|1||Angela Adamsemail@example.com||123-456-2299||ESGN SELF-SCORING - ABC CO. - ADAMS.XLSX|
|2||Connie Carpenterfirstname.lastname@example.org||123-456-7723||ESGN SELF-SCORING - ABC CO. - CARPENTER.XLSX|
|3||Joseph Chenemail@example.com||123-456-9114||ESGN SELF-SCORING - ABC CO. - CHEN.XLSX|
|4||Matt Johnsonfirstname.lastname@example.org||123-456-3385||ESGN SELF-SCORING - ABC CO. - JOHNSON.XLSX|
|5||Juan Perezemail@example.com||123-456-2100||ESGN SELF-SCORING - ABC CO. - PEREZ.XLSX|
This section describes any quality control (QC) issues that may exist in the underlying data.2 QC issues were found:
|2||Connie Carpenter||02.02||0.00||!||KSI is marked as Highly Relevant (HR) but not rated.|
|2||Connie Carpenter||02.03||0.00||!||KSI is marked as Highly Relevant (HR) but not rated.|
Note: QC issues are potential errors/omissions in the underlying Excel files, including: Rating values other than those listed in the Excel drop-down menu; and KSIs flagged as HR(!) but not rated.
This section shows overall results for each of the 129 KSIs (34 included in this sample report), averaged across all 5 ESG Navigator Excel files for ABC Company.
* PSS = Products, Services and Solutions
Wide rating ranges are flagged based on standard deviation (SD): SD>1.0 is 'Very wide'; SD>0.5 is 'Wide'.
This section describes 'outliers', which are ratings and highly relevant ('HR(!)') designations that are significantly different from the average.*111 of the 129 KSIs (86%) qualified for outlier analysis; 8 outliers were found:
|01.01||Governance & Leadership||Co. Purpose (CEO's View re Role of Co. in Society)||HIGH rating||Connie Carpenter||4.00||1.60||1.00 - 4.00 (rated by 5)|
|01.02||Governance & Leadership||Sust. in Corporate Vision, Mission, Values & Polic||HIGH rating||Connie Carpenter||4.00||1.80||1.00 - 4.00 (rated by 5)|
|01.02||Governance & Leadership||Sust. in Corporate Vision, Mission, Values & Polic||Only HR(!)||Connie Carpenter||4.00||1.80||1.00 - 4.00 (rated by 5)|
|02.01||Governance & Leadership||Public Posture re: Sust. by CEO & C-Suite Execs||Only HR(!)||Connie Carpenter||4.00||2.80||1.00 - 4.00 (rated by 5)|
|05.02||Governance & Leadership||Sust. Factored Into Executive Compensation||HIGH rating||Connie Carpenter||4.00||1.90||0.50 - 4.00 (rated by 5)|
|07.02||Governance & Leadership||Sust. in Annual Report & Financial Disclosures||HIGH rating||Connie Carpenter||4.00||1.90||0.50 - 4.00 (rated by 5)|
|09.02||Strategy and Execution||Sust. Innovation through Material & Labor Inputs||HIGH rating||Connie Carpenter||4.00||1.50||0.50 - 4.00 (rated by 5)|
|11.02||Strategy and Execution||Product Stewardship Philosophy & Strategy||Only HR(!)||Connie Carpenter||0.50||1.10||0.50 - 3.00 (rated by 5)|
Note: KSIs qualify for outlier analysis if they are rated by 50% or more of respondents (see the %Rated column in the KSI table above). For qualifying KSIs, outliers are flagged if: a respondent's rating differs from the average by 2.0+; a respondent is the only one to designate the KSI as HR(!); or a respondent did not rate the KSI as HR(!) when most others did.