Spreadsheet: 122610d1317026235-excel-2007-dependent-validation-on-seperate-worksheets-array-not-working-v6_testing
Sheet: Dependent Validation

DRC | Estb1 | P&D:Professionally manage our people and their careers | P&D:Identify and develop an appropriate number of high calibre staff | REP:Market and communicate our capabilities | Experience | Prepare | Model | Relationship | Partnership | All1 | All2
ALL1: All Impacted | Supply the right people with the right skills doing the right jobs | Improve our leadership and engagement | Improve our leadership and engagement | A single Investment Portfolio covering all elements of the mission | More collaborative working –internally and with partners | [NAME] to manage technology risks | More collaborative working –internally and with partners | [NAME] to manage technology risks | A single Investment Portfolio covering all elements of the mission | All Objectives Impacted | No Objectives Impacted
ALL2: None Impacted | Grow the ITS and other skillswe need through Development and Training | Manage our people better | Supply the right people with the right skills doing the right jobs | More collaborative working –internally and with partners | Greater cost-awareness | We encourage innovation | Manage our partnerships in an integrated way | More collaborative working –internally and with partners | More collaborative working –internally and with partners | Can't quantify to a single objective | No single Objective impacted
C&P1:Create a new customer engagement model |  |  |  | Minimise bureaucracy: fewer and simpler processes | Minimise bureaucracy: fewer and simpler processes | Technology as a cornerstone of UKUSAB | Greater cost-awareness | Manage our partnerships in an integrated way | Manage our partnerships in an integrated way
C&P2:Actively manage our customer relationships |  |  |  | Develop the culture needed to meet the ITS challenge |  |  | Develop the culture needed to meet the ITS challenge | Deliver our commitments within our budget | Deliver our commitments within our budget
C&P3:Invest in new and existing relationships and partnerships
P&D1:Establish an xxxx xxxx tradecraft development programme
P&D2:Professionally manage our people and their careers
P&D3:Identify and develop an appropriate number of high calibre staff
REP1:Market and communicate our capabilities
REP2:Customers have the best possible experience
REP3:Prepare for the future
Dependent Validation List. Do not add or delete rows
Category Definitions
 | DRC
Establish | P&D1:Establish an xxxx xxxx development programme |  |  |  |  | CSC
Manage | P&D2:Professionally manage our people and their careers
Identify | P&D3:Identify and develop an appropriate number of high calibre staff
Market | REP1:Market and communicate our capabilities
Experience | REP2:Customers have the best possible experience
Prepare | REP3:Prepare for the future
Model | C&P1:Create a new customer engagement model
Relationship | C&P2:Actively manage our customer relationships
Partnership | C&P1:Invest in new and existing relationships and partnerships
All1 | ALL1: All Impacted
All2 | ALL2: None Impacted
 | CSC
EstablishA | Supply the right people with the right skills doing the right jobs
EstablishB | Grow the ITS and other skillswe need through Development and Training
ManageA | Improve our leadership and engagement
[NAME] | Manage our people better
IdentifyA | Improve our leadership and engagement
IdentifyB | Supply the right people with the right skills doing the right jobs
MarketA | A single Investment Portfolio covering all elements of the mission
MarketB | More collaborative working –internally and with partners
MarketC | Minimise bureaucracy: fewer and simpler processes
MarketD | Develop the culture needed to meet the ITS challenge
ExperienceA | More collaborative working –internally and with partners
ExperienceB | Greater cost-awareness
ExperienceC | Minimise bureaucracy: fewer and simpler processes
[NAME] | [NAME] to manage technology risks
PrepareB | We encourage innovation
PrepareC | Technology as a cornerstone of UKUSAB
[NAME] | More collaborative working –internally and with partners
ModelB | Manage our partnerships in an integrated way
ModelC | Greater cost-awareness
ModelD | Develop the culture needed to meet the ITS challenge
RelationshipA | [NAME] to manage technology risks
RelationshipB | More collaborative working –internally and with partners
RelationshipC | Manage our partnerships in an integrated way
RelationshipD | Deliver our commitments within our budget
PartnershipA | A single Investment Portfolio covering all elements of the mission
PartnershipB | More collaborative working –internally and with partnersB
PartnershipC | Manage our partnerships in an integrated way
PartnershipD | Deliver our commitments within our budget
All1A | All Objectives Impacted
All1B | Can't quantify to a single objective
All2A | No Objectives Impacted
All2B | No single Objective impacted