Spreadsheet: 721848d1614893977-if-formula-based-on-text-selection-of-another-cell-interview-grid-ddi-level-competency-selection
Sheet: List

 |  |  |  |  |  |  |  | Position Level |  | Position List |  | Competency List |  |  | Question List1 |  |  | Question List2 |  |  | Question List3 |  |  | Question List 4 |  |  | Question List5 |  |  | Question List Other |  |  | Guiding Principles Questions |  |  | Guiding Principles Questions |  |  | Guiding Principles Questions |  |  | Guiding Principles Questions
 |  |  |  | 1 |  |  |  | 1-6 | 1 |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  |  |  | 2 |  |  |  | 7-8 | 2 |  |  |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2
 |  |  |  | 3 |  |  |  | 9-12 | 3 |  |  |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3
 |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4
0 |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5
Question 1 |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6
Question 2 |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7
Question 3 |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8
Question 4 |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  | 9 |  |  | 9 |  |  | 9 |  |  | 9 |  |  | 9 |  |  | 9 |  |  | 9 |  |  | 9 |  |  | 9
Question 5 |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10
Question 6 |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  | 11 |  |  | 11 |  |  | 11 |  |  | 11 |  |  | 11 |  |  | 11 |  |  | 11 |  |  | 11 |  |  | 11
Question 7 |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12
Question 8 |  |  |  | 13 |  |  |  |  | 13 |  |  |  |  | 13 |  |  | 13 |  |  | 13 |  |  | 13 |  |  | 13 |  |  | 13 |  |  | 13 |  |  | 13 |  |  | 13 |  |  | 13
Question 9 |  |  |  | 14 |  |  |  |  | 14 |  |  |  |  | 14 |  |  | 14 |  |  | 14 |  |  | 14 |  |  | 14 |  |  | 14 |  |  | 14 |  |  | 14 |  |  | 14 |  |  | 14
Question 10 |  |  |  | 15 |  |  |  |  | 15 |  |  |  |  | 15 |  |  | 15 |  |  | 15 |  |  | 15 |  |  | 15 |  |  | 15 |  |  | 15 |  |  | 15 |  |  | 15 |  |  | 15
Question 11 |  |  |  | 16 |  |  |  |  | 16 |  |  |  |  | 16 |  |  | 16 |  |  | 16 |  |  | 16 |  |  | 16 |  |  | 16 |  |  | 16 |  |  | 16 |  |  | 16 |  |  | 16
Question 12 |  |  |  | 17 |  |  |  |  | 17 |  |  |  |  | 17 |  |  | 17 |  |  | 17 |  |  | 17 |  |  | 17 |  |  | 17 |  |  | 17 |  |  | 17 |  |  | 17 |  |  | 17
Question 13 |  |  |  | 18 |  |  |  |  | 18 |  |  |  |  | 18 |  |  | 18 |  |  | 18 |  |  | 18 |  |  | 18 |  |  | 18 |  |  | 18 |  |  | 18 |  |  | 18 |  |  | 18
Question 14 |  |  |  | 19 |  |  |  |  | 19 |  |  |  |  | 19 |  |  | 19 |  |  | 19 |  |  | 19 |  |  | 19 |  |  | 19 |  |  | 19 |  |  | 19 |  |  | 19 |  |  | 19
Question 15 |  |  |  | 20 |  |  |  |  | 20 |  |  |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20
Question 16 |  |  |  | 21 |  |  |  |  |  |  |  |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 21
Question 17 |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 22 |  |  | 22 |  |  | 22 |  |  | 22 |  |  | 22 |  |  | 22 |  |  | 22 |  |  | 22 |  |  | 22 |  |  | 22
Question 18 |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  | 23 |  |  | 23 |  |  | 23
Question 19 |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  | 24 |  |  | 24 |  |  | 24
Question 20 |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  | 25 |  |  | 25 |  |  | 25
Question 21 |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  |  | 26 |  |  | 26 |  |  | 26
Question 22 |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  | 27 |  |  | 27 |  |  | 27
Question 23 |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  | 28 |  |  | 28 |  |  | 28
Question 24 |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  | 29 |  |  | 29 |  |  | 29
Question 25 |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  |  | 30 |  |  | 30 |  |  | 30
Question 26 |  |  |  | 31 |  |  |  | Camp
 |  |  |  | 32 |  |  |  | Community Relations
 |  |  |  |  |  |  |  | Construction
 |  |  |  |  |  |  |  | E&I
 |  |  |  |  |  |  |  | Engineering
 |  |  |  |  |  |  |  | Environment
 |  |  |  |  |  |  |  | Finance
 |  |  |  |  |  |  |  | Geology
 |  |  |  |  |  |  |  | H&S
 |  |  |  |  |  |  |  | HR
 |  |  | Level 7-8 Competencies | Level 1-6 Competencies |  |  |  | IT
 |  |  |  |  |  |  |  | Maintenance
 |  |  |  | Accountability |  |  |  | Mine
 |  |  |  | Active Learning |  |  |  | Process Plant
 |  |  |  | Adaptability |  |  |  | Proc. & Logistic
 |  |  |  | Analytical Thinking |  |  |  | Site Services |  |  |  | Collaborating
 |  |  |  | Anticipating |  |  |  | Strat. Optimization |  |  |  | Managing Work
 |  |  |  | Building Trusting Relationships | Trust |  |  |  |  |  |  | Valuing Differences
 |  |  |  | Coaching | Family |  |  |  |  |  |  | Safety Focus
 |  |  |  | Coaching and Developing Others | Equality |  |  |  |  |  |  | Coaching
 |  |  |  | Collaborative Relationship | Responsibility |  |  |  |  |  |  | HSEC Leadership
 |  |  |  | Conceptual thinking | Respect |  |  |  |  |  |  | Managerial Courage
 |  |  |  | [NAME] | Anchored in Our Values
 |  |  |  | [NAME] | Based on Collaboration
 |  |  |  | Customer Orientation | Clear and Simple
 |  |  |  | Diversity Management | Culture
 |  |  |  | Engagement Readiness | 0
 |  |  |  | Finance Management
 |  |  |  | Gaining Commitment
 |  |  |  | Holding People Accountable
 |  |  |  | Information Sharing
 |  |  |  | Innovation
 |  |  |  | Interpersonal Effectiveness
 |  |  |  | Leading Change
 |  |  |  | Leading Through Vision, Values and [NAME]
 |  |  |  | Organizational Awareness
 |  |  |  | Performance Management
 |  |  |  | Personal Integrity
 |  |  |  | Planning & Organizing
 |  |  |  | Quality Orientation
 |  |  |  | Results Orientation
 |  |  |  | Risk Management
 |  |  |  | Stewardship of Resources
 |  |  |  | Strategic Thinking
 |  |  |  | Talent Management
 |  |  |  | Team Leadership
 |  |  |  | Teamwork
 |  |  |  | Collaborating
 |  |  |  | Managing Work
 |  |  |  | Valuing Differences
 |  |  |  | Safety Focus
 |  |  |  | Coaching
 |  |  |  | HSEC Leadership
 |  |  |  | Managerial Courage