Spreadsheet: 168836d1342604131-sumproduct-or-sumif-book3
Sheet: Unsuccessful Colleagues (2)

 |  |  | FTE | Current Grade |  |  |  |  |  | No Action |  |  |  |  |  |  | Number of Preferences | First Preference Job Number | First Preference Job Grade | First Preference Job Title | First Preference Job BU | Second Preference Job Number | Second Preference Job Grade | Second Preference Job Title | Second Preference Job BU | Third Preference Job Number | Third Preference Job Grade | Third Preference Job Title | Third Preference Job BU | Choose From Drop Down 1st Preference | Choose From Drop Down 2nd Preference | Choose From Drop Down 3rd Preference | Outstanding | Resigned / Leaver / Transfer | [NAME] Yes / No | Choose From Drop Down Reason For Non-Preference | Comments / Notes
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007918 | C | Analyst HNW & Business Processing | W&I | GFO007773 | C | Finance Assistant | Group Operations | GFO007686 | C | Finance Change Project Office | Group Finance | Selected | Not Selected | Not Selected |  |  |  |  | Consider for 7918 in W&I - colleagued pref and was reserved.  Rhian to confirm
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007878 | EU | Manager, Transaction Banking | Wholesale | GFO007855 | EU | Manager - Global BSU - Global Impairments | Wholesale | GFO008296 | EU | Manager, Reward | Group Finance |  |  | Selected
 |  |  | 1 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008358 | EL | Finance Change SME | Group Finance | GFO008312 | EL | Manager,  Analysis & Design | Retail | GFO008334 | EL | Manager,  PCA Reporting | Retail | Selected
 |  |  | 1 | F |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007906 | F | Senior Manager, Transaction Banking Finance | Wholesale | [NAME] | F | Senior Business Partner Wholesale Europe | W&I | GFO008322 | F | Senior Manager Business Analytics & Strategic Planning | W&I | Not Selected | Selected | Not Selected |  |  | Yes
 |  |  | 1 | F |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007976 | F | Senior Finance manager, Cost Management | W&I | GFO007811 | F | Senior Manager, GEF & Group Ops Partnering | Group Operations | GFO007752 | F | Finance Change Business Partner - Wholesale & Commercial | Group Finance | Selected | Not Selected | Not Selected |  |  |  |  | SELECTED FOR A ROLE IN INSURANCE
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GFO007687 | C | PA | Group Finance | GFO008005 | C | PA | Insurance |  |  |  |  | Not Selected | Selected
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007773 | C | Finance Assistant | Group Operations | GFO007679 | C | PA | Group Finance | GFO008327 | C | PA | Group Finance | Selected | Not Selected | Not Selected |  |  |  |  | Offer 7773 (in replacement of [NAME])
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007773 | C | Finance Assistant | Group Operations | GFO008081 | C | PA | Retail | GFO008080 | C | PA | Retail | Selected | Not Selected | Not Selected
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GFO007772 | C | Analyst Facilities Management Finance - Property Finance | Group Operations |  |  |  |  |  |  |  |  | Not Selected |  |  |  |  |  |  | At risk, Halifax
 |  |  | 1 | DL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007800 | DL | Management Accountant, Cost Reporting | Group Operations | GFO007689 | DL | Assistant Manager, Tax Compliance | Group Finance | GFO007940 | DL | Assistant Manager R&W SWIP Strategy | W&I | Selected | Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, Cost Reporting | Group Operations | GFO007779 | DU | Assistant Manager, Reporting, Assets & Controls | Group Operations | GFO007932 | DU | Finance Assistant Manager | W&I | Not Selected | Not Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, Cost Reporting | Group Operations | GFO008272 | DU | Assistant Manager BSU Ireland | Wholesale | GFO007699 | DU | Finance Change SME | Group Finance | Not Selected |  | Selected |  |  |  |  | SELECTED FOE GFO007832 IN WHOLESALE
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, Cost Reporting | Group Operations | [NAME] | DU | Assistant Manager, Cost Transfer Charging | Group Operations | GFO007801 | DU | Assistant Manager, GEF & Group Ops Finance | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007778 | DU | Assistant Manager, [NAME], Strategic Programmes | Group Operations | [NAME] | DU | Assistant Manager, Cost Reporting | Group Operations | GFO008272 | DU | Assistant Manager BSU Ireland | Wholesale | Selected | Not Selected | Not Selected |  |  | Yes
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007784 | DU | Assistant Manager, SD Financial Control | Group Operations | GFO007785 | DU | Assistant Manager, SD Finance | Group Operations | GFO007777 | DU | Assistant Manager, CIO Support | Group Operations | Selected |  | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007779 | DU | Assistant Manager, Reporting, Assets & Controls | Group Operations | GFO007839 | DU | Global Balance Sheet Assistant Manager | Wholesale | GFO007784 | DU | Assistant Manager, SD Financial Control | Group Operations |  | Not Selected | Selected |  |  | Yes
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007777 | DU | Assistant Manager, CIO Support | Group Operations | [NAME] | DU | Assistant Manager, IT Supply Finance | Group Operations | GFO007804 | DU | Assistant Manager, Group Operations Finance | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, IT Supply Finance | Group Operations | GFO008291 | DU | Assistant Planning Manager | Group Finance | GFO007801 | DU | Assistant Manager, GEF & Group Ops Finance | Group Operations | Selected | Not Selected | Not Selected |  |  | Yes
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007785 | DU | Assistant Manager, SD Finance | Group Operations | GFO007784 | DU | Assistant Manager, SD Financial Control | Group Operations | [NAME] | DU | Assistant Manager, IT Supply Finance | Group Operations | Selected | Not Selected | Not Selected |  |  |  |  | MOSADDEQ SELECTED FOR GFO007785 IN IT
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, IT Supply Finance | Group Operations | GFO007787 | DU | Assistant Finance Manager, Financial Control, IT Supply | Group Operations | GFO008096 | DU | Assistant Manager, CMU Analysis | Retail | Selected | Not Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, IT Supply Finance | Group Operations | GFO007787 | DU | Assistant Finance Manager, Financial Control, IT Supply | Group Operations | GFO008096 | DU | Assistant Manager, CMU Analysis | Retail | Not Selected | Selected | Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, IT Supply Finance | Group Operations | GFO007787 | DU | Assistant Finance Manager, Financial Control, IT Supply | Group Operations | GFO007779 | DU | Assistant Manager, Reporting, Assets & Controls | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007688 | DU | Finance Change Business Partner - Insurance & W&I | Group Finance | GFO008341 | DU | Portfolio Office Support | Group Finance | GFO007777 | DU | Assistant Manager, CIO Support | Group Operations | Not Selected | Not Selected | Selected
 |  |  | 0.5 | DU |  |  |  |  |  | Resigned |  |  |  |  |  |  | 3 | GFO007785 | DU | Assistant Manager, SD Finance | Group Operations | GFO007784 | DU | Assistant Manager, SD Financial Control | Group Operations | GFO007778 | DU | Assistant Manager, [NAME], Strategic Programmes | Group Operations | Not Selected | Not Selected |  |  | Resigned | Yes |  | Resigned - Not preference for any roles
 |  |  | 1 | DL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008033 | DL | Assistant Business Partnering Manager | Insurance | GFO008016 | DL | MI Assistant Analyst | Insurance | GFO008006 | DL | MI Assistant Analyst | Insurance | Not Selected | Not Selected | Not Selected
 |  |  | 0.6 | DL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DL | Assistant Manager, Finance Volume Planning | Retail | GFO008006 | DL | MI Assistant Analyst | Insurance | GFO007800 | DL | Management Accountant, Cost Reporting | Group Operations | Not Selected | Not Selected | Not Selected
 |  |  | 1 | DL |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME] | DL | Assistant Manager, Finance Volume Planning | Retail | GFO007940 | DL | Assistant Manager R&W SWIP Strategy | W&I |  |  |  |  | Not Selected | Not Selected |  |  |  | Yes
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007936 | DU | Assistant Finance Manager, Islands Business Partner | W&I | GFO007823 | DU | Assistant Manager [NAME] | Wholesale | GFO007779 | DU | Assistant Manager, Reporting, Assets & Controls | Group Operations |  |  | Selected |  |  | Yes
 |  |  | 0.8 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007953 | EU | Finance Manager [NAME] | W&I | GFO007961 | EU | Finance Manager, Investment and Simplification | W&I | GFO007806 | EU | Manager, GEF & Group Ops Finance | Group Operations | Selected |  | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008053 | EU | Manager, Partnering & Insight | Insurance | GFO008057 | EU | Portfolio Manager | Insurance | GFO007961 | EU | Finance Manager, Investment and Simplification | W&I |  |  | Selected |  |  |  |  | SIMONE PEARSON SELECTED FOR GFO007700 IN COE FINANCE CHANGE
 |  |  | 1 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, Cost Reporting | Group Operations | GFO007777 | DU | Assistant Manager, CIO Support | Group Operations | GFO008034 | DU | Assistant Business Partnering Manager | Insurance | Selected | Not Selected | Not Selected |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | EU | Manager, Cost Transfer Charging | Group Operations | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007808 | EU | Manager, Cost Reporting | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO008057 | EU | Portfolio Manager | Insurance | GFO007874 | EU | Manager, [NAME] | Wholesale | Selected |  | Selected
 |  |  | 0.6 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO008053 | EU | Manager, Partnering & Insight | Insurance | GFO007808 | EU | Manager, Cost Reporting | Group Operations | Selected |  | Not Selected |  |  | Yes
 |  |  | 0.7 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO008057 | EU | Portfolio Manager | Insurance | Selected
 |  |  | 1 | EU |  |  |  |  |  | Resigned |  |  |  |  |  |  | 3 | GFO007806 | EU | Manager, GEF & Group Ops Finance | Group Operations | [NAME] | EU | Manager, Cost Transfer Charging | Group Operations | GFO007809 | EU | Manager, Cost Partnering | Group Operations | Not Selected | Not Selected | Not Selected |  | Resigned
 |  |  | 1 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007808 | EU | Manager, Cost Reporting | Group Operations | GFO007961 | EU | Finance Manager, Investment and Simplification | W&I | GFO007955 | EU | Finance Manager Data Management | W&I | Selected | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO008044 | EU | MI Manager | Insurance | GFO008057 | EU | Portfolio Manager | Insurance | Selected |  |  |  |  |  |  | Selected for GFO007808
 |  |  | 0.77 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007793 | EU | Portfolio Finance Manager | Group Operations | GFO007808 | EU | Manager, Cost Reporting | Group Operations | GFO007806 | EU | Manager, GEF & Group Ops Finance | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 1 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008312 | EL | Manager,  Analysis & Design | Retail | GFO008221 | EL | MI Manager, Business Support | Retail | GFO008313 | EL | Manager, Finance Performance Analyst | Retail |  |  |  |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GFO007797 | EU | Manager, SD Finance | Group Operations |  |  |  |  |  |  |  |  | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | Selected |  | Not Selected |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007799 | EU | Finance Manager, Planning & Reporting | Group Operations | GFO007796 | EU | Manager, SD Financial Control | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | Selected |  |  |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations | GFO007971 | EU | Manager, Business Development | W&I | GFO007797 | EU | Manager, SD Finance | Group Operations | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007971 | EU | Manager, Business Development | W&I | GFO008245 | EU | Manager, F&BPM Partnering | Retail | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007797 | EU | Manager, SD Finance | Group Operations | [NAME] | EU | Manager, Group Cost Management | Group Operations | GFO008245 | EU | Manager, F&BPM Partnering | Retail | Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO008321 | EU | Manager Commercial Analytics | W&I | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007796 | EU | Manager, SD Financial Control | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations | Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007796 | EU | Manager, SD Financial Control | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | Selected |  | Not Selected
 |  |  | 0.71 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GFO008345 | EU | Manager - Governance and Control | Group Finance | GFO007809 | EU | Manager, Cost Partnering | Group Operations |  |  |  |  | Selected |  | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations | GFO008229 | EU | Manager | Retail | GFO007797 | EU | Manager, SD Finance | Group Operations | Selected | Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | [NAME] | EU | Manager Restructures | Wholesale | Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | Not Selected | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | Not Selected | Selected
 |  |  | 1 | EU |  |  |  |  |  | Resigned |  |  |  |  |  |  | 1 | GFO007778 | DU | Assistant Manager, [NAME], Strategic Programmes | Group Operations |  |  |  |  |  |  |  |  | Not Selected |  |  |  | Resigned |  |  | Resigned - Not preference for any roles
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007972 | EU | Manager Business Reporting | W&I |  | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007793 | EU | Portfolio Finance Manager | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007799 | EU | Finance Manager, Planning & Reporting | Group Operations | Selected
 |  |  | 1 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008334 | EL | Manager,  PCA Reporting | Retail | GFO008358 | EL | Finance Change SME | Group Finance | GFO008223 | EL | Manager, [NAME] | Retail |  |  | Selected |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations | GFO007792 | EU | Manager - FBP Central Functions | Group Operations | Selected |  |  |  |  |  |  | Selected for role GFO007799
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007806 | EU | Manager, GEF & Group Ops Finance | Group Operations | Selected |  | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007971 | EU | Manager, Business Development | W&I | GFO007700 | EU | Finance Analytics & MI Manager | Group Finance | Selected |  |  |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | Selected |  | Reserve
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007964 | EU | FBP HNW | W&I | GFO007806 | EU | Manager, GEF & Group Ops Finance | Group Operations | Selected |  | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007718 | EU | Finance Change Business Partner - Insurance & W&I | Group Finance | Not Selected |  | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007809 | EU | Manager, Cost Partnering | Group Operations | Selected | Reserve | Not Selected |  |  | Yes |  | Selected for GFO007793
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007799 | EU | Finance Manager, Planning & Reporting | Group Operations | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | Not Selected |  | Selected |  |  | Yes |  | JENNIFER PHAM SELECTED FOR GFO007863 IN WHOLESALE FINANCE
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GFO007799 | EU | Finance Manager, Planning & Reporting | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations |  |  |  |  | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008257 | EU | Manager, Products Cost Analysis | Retail | GFO007955 | EU | Finance Manager Data Management | W&I | GFO007799 | EU | Finance Manager, Planning & Reporting | Group Operations |  |  | Selected |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007799 | EU | Finance Manager, Planning & Reporting | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007808 | EU | Manager, Cost Reporting | Group Operations | Selected |  | Not Selected |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  | Resigned |  |  |  |  |  |  | 3 | GFO007799 | EU | Finance Manager, Planning & Reporting | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | Not Selected |  |  |  | Resigned |  |  | Resigned - Not preference for any roles
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | Selected |  | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007964 | EU | FBP HNW | W&I | Selected | Not Selected
 |  |  | 0.8 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GFO008334 | EL | Manager,  PCA Reporting | Retail |  |  |  |  |  |  |  |  |  |  | Selected |  |  | Yes |  | SELECTED FOR VERDE CC1479 - PROCUREMENT BP MANAGER
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO008229 | EU | Manager | Retail | Selected
 |  |  | 1 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GFO008334 | EL | Manager,  PCA Reporting | Retail | GFO008223 | EL | Manager, [NAME] | Retail |  |  |  |  |  |  | Selected |  |  |  |  | SELECTED FOR VERDE CC1513 - CORPORATE CORE BP CONSULTANT
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations | GFO008265 | EU | Manager | Retail |  | Not Selected | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations |  |  |  |  | Selected | Not Selected
 |  |  | 1 | F |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007811 | F | Senior Manager, GEF & Group Ops Partnering | Group Operations | GFO007814 | F | Senior Manager, Cost Transfer Charging | Group Operations | GFO007813 | F | Senior Manager, Cost Partnering | Group Operations | Not Selected | Selected | Not Selected
 |  |  | 0.94 | F |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007815 | F | Senior Manager, Cost Reporting | Group Operations | GFO007976 | F | Senior Finance manager, Cost Management | W&I | GFO007811 | F | Senior Manager, GEF & Group Ops Partnering | Group Operations | Not Selected | Selected | Not Selected
 |  |  | 1 | F |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007741 | F | Senior Manager, Core HR Business Partnering, Performance Management | Group Finance | GFO008163 | F | Senior Manager [NAME] | Retail | GFO007742 | F | Senior Programme Manager | Group Finance | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007791 | EU | Finance Manager, Financial Control, IT Supply | Group Operations |  |  |  |  |  |  |  |  | Selected | Selected |  |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007789 | EU | Finance Manager, CIO Support | Group Operations | GFO007798 | EU | Finance Manager, [NAME], Simplification & Cost Management | Group Operations | Selected | Not Selected | Not Selected |  |  | Yes
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, IT Supply Finance | Group Operations |  |  |  |  |  |  |  |  | Selected |  |  |  |  |  |  | Maternity
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007788 | EU | Manager, IT Supply Finance | Group Operations |  |  |  |  |  |  |  |  | Selected |  |  |  |  |  |  | Maternity
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007790 | EU | Manager, [NAME] | Group Operations |  |  |  |  |  |  |  |  | Selected |  |  |  |  |  |  | Maternity
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007797 | EU | Manager, SD Finance | Group Operations |  |  |  |  |  |  |  |  | Selected |  |  |  |  |  |  | Maternity
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  |  | GFO007778 |  |  | Group Operations |  |  |  |  |  |  |  |  | Selected |  |  |  |  |  |  | Maternity
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | EU |  | Wholesale | GFO007797 | EU | Manager, SD Finance | Group Operations | GFO007788 | EU | Manager, IT Supply Finance | Group Operations |  | Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | EU |  | Retail | GFO007797 | EU | Manager, SD Finance | Group Operations |  |  |  |  |  | Selected
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GFO007687 | C | PA | Group Finance | GFO008005 | C | PA | Insurance |  |  |  |  | Not Selected | Not Selected |  |  |  |  |  | At risk [NAME] but Verde to review
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GFO008076 | C | MI Analyst, Business Support | Retail |  |  |  |  |  |  |  |  | Not Selected |  |  |  |  |  |  | At risk - Wolverhampton - 1 of 4 being considered for 1 W&I role in Solihull  Rhian to confirm
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007772 | C | Analyst Facilities Management Finance - Property Finance | Group Operations | GFO008001 | C | MI  Analyst | Insurance | GFO007999 | C | Assistant Change | Insurance | Not Selected | Not Selected | Not Selected |  |  | Yes |  | At risk, Leeds
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007783 | DU | Assistant Manager - S&OP Business Services | Group Operations | GFO007930 | DU | Assistant Finance manager, Cost Management | W&I | GFO007786 | DU | Assistant Manager - Wholesale Operations | Group Operations | Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007786 | DU | Assistant Manager - Wholesale Operations | Group Operations | GFO007780 | DU | Assistant Manager - Global Payments | Group Operations | GFO007783 | DU | Assistant Manager - S&OP Business Services | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GFO007780 | DU | Assistant Manager - Global Payments | Group Operations | GFO007786 | DU | Assistant Manager - Wholesale Operations | Group Operations |  |  |  |  | Selected | Not Selected |  |  |  |  |  | WILLIAM GOVAN SELECTED FOR GFO007780 IN GROUP OPERATIONS
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008282 | DU | Assistant manager - Credit Operations | Group Operations | GFO008281 | DU | Assistant Manager - S&OP (GSL) | Group Operations | GFO007780 | DU | Assistant Manager - Global Payments | Group Operations | Not Selected | Selected | Not Selected
 |  |  | 0.7 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007782 | DU | Assistant Manager - RMPB Mortgage Operations | Group Operations | GFO008097 | DU | Senior Analyst, Data Accuracy | Retail | GFO008333 | DU | Assistant Manager, [NAME] | Retail | Reserve | Not Selected | Selected |  |  |  |  | VIKKI SMITH SELECTED FOR GFO008096 IN RETAIL
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GFO007699 | DU | Finance Change SME | Group Finance
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008282 | DU | Assistant manager - Credit Operations | Group Operations | GFO008281 | DU | Assistant Manager - S&OP (GSL) | Group Operations | GFO007801 | DU | Assistant Manager, GEF & Group Ops Finance | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008281 | DU | Assistant Manager - S&OP (GSL) | Group Operations | GFO008282 | DU | Assistant manager - Credit Operations | Group Operations | GFO007699 | DU | Finance Change SME | Group Finance | Not Selected | Not Selected | Not Selected
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007782 | DU | Assistant Manager - RMPB Mortgage Operations | Group Operations | GFO008308 | DU | Assistant Manager, Product Costs Consolidation | Retail | GFO007946 | DU | Assistant Manager Business Reporting | W&I | Selected | Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007808 | EU | Manager, Cost Reporting | Group Operations | [NAME] | EU | Manager, Cost Transfer Charging | Group Operations | GFO008055 | EU | Business Partnering Manager | Insurance | Selected | Not Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007863 | EU | Manager, Analysis and Management Reporting | Wholesale | GFO007951 | EU | Finance Manager Business Insight | W&I | GFO007799 | EU | Finance Manager, Planning & Reporting | Group Operations | Selected
 |  |  | 0.8 | EL |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008226 | EL | Specialist, Data Accuracy | Retail | GFO008334 | EL | Manager,  PCA Reporting | Retail | GFO008046 | EL | Manager [NAME] | Insurance |  |  |  |  |  | Yes
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GFO008257 | EU | Manager, Products Cost Analysis | Retail | [NAME] | EU | Manager, Cost Transfer Charging | Group Operations |  |  |  |  |  | Selected
 |  |  | 1 | EU |  |  |  |  |  | Resigned |  |  |  |  |  |  | 3 | GFO007809 | EU | Manager, Cost Partnering | Group Operations | GFO008058 | EU | Strategy Manager | Insurance | GFO007713 | EU | Manager, Analysis and Insight | Group Finance | Not Selected |  |  |  | Resigned |  |  | Resigned - already reflected - not preference for any roles
 |  |  | 1 | F |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GFO007776 | F | Senior Manager - Wholesale Operations | Group Operations |  |  |  |  |  |  |  |  | Selected |  |  |  |  |  |  | Selected for role GFO007775
 |  |  | 0.6 | F |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007776 | F | Senior Manager - Wholesale Operations | Group Operations | GFO007811 | F | Senior Manager, GEF & Group Ops Partnering | Group Operations | GFO007976 | F | Senior Finance manager, Cost Management | W&I | Selected | Not Selected |  |  |  |  |  | 0.6 role shared
 |  |  | 0.6 | F |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007776 | F | Senior Manager - Wholesale Operations | Group Operations | GFO007976 | F | Senior Finance manager, Cost Management | W&I | GFO007811 | F | Senior Manager, GEF & Group Ops Partnering | Group Operations | Selected |  | Not Selected |  |  |  |  | 0.6 role shared
 |  |  | 1 | F |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008160 | F | Senior Manager, Product Costs | Retail | GFO007811 | F | Senior Manager, GEF & Group Ops Partnering | Group Operations | GFO007741 | F | Senior Manager, Core HR Business Partnering, Performance Management | Group Finance | Selected | Not Selected | Not Selected
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007772 | C | Analyst Facilities Management Finance - Property Finance | Group Operations | GFO007771 | C | Analyst Asset Management Finance - Property Finance | Group Operations | GFO007684 | C | Analyst | Group Finance | Not Selected | Reserve | Selected |  |  |  |  | At risk - 1 of 2 consider for Gp Finance 7684  in Bristol & Verde.  [NAME] to confirm
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007771 | C | Analyst Asset Management Finance - Property Finance | Group Operations | GFO007772 | C | Analyst Facilities Management Finance - Property Finance | Group Operations | GFO008079 | C | MI Analyst, Business Support | Retail | Selected | Not Selected | Not Selected |  |  | Yes
 |  |  | 0.6 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007920 | C | Analyst Miami | W&I | GFO007771 | C | Analyst Asset Management Finance - Property Finance | Group Operations | GFO007772 | C | Analyst Facilities Management Finance - Property Finance | Group Operations | Not Selected | Reserve | Selected |  |  |  |  | Selected for a role in Verde
 |  |  | 1 | C |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007772 | C | Analyst Facilities Management Finance - Property Finance | Group Operations | GFO007771 | C | Analyst Asset Management Finance - Property Finance | Group Operations | GFO007999 | C | Assistant Change | Insurance | Selected | Not Selected |  |  |  | Yes
 |  |  | 1 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | DU | Assistant Manager, Cost Reporting | Group Operations | GFO007801 | DU | Assistant Manager, GEF & Group Ops Finance | Group Operations | GFO008293 | DU | Assistant Manager | Group Finance | Not Selected | Selected | Not Selected
 |  |  | 0.6 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007794 | EU | Manager - Property Finance | Group Operations | GFO008237 | EU | Manager, Cost Analytics | Retail | GFO008336 | EU | Manager, Community Bank Costs | Retail
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GFO007794 | EU | Manager - Property Finance | Group Operations |  |  |  |  |  |  |  |  | Reserve
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | EU | Manager, Cost Transfer Charging | Group Operations | GFO007806 | EU | Manager, GEF & Group Ops Finance | Group Operations | GFO007808 | EU | Manager, Cost Reporting | Group Operations | Selected | Not Selected | Not Selected
 |  |  | 0.6 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008298 | EU | Specialist | Group Finance | GFO008040 | EU | Finance Change Manager | Insurance | GFO007702 | EU | Finance Change Business Partner - Group Finance & FBS | Group Finance |  |  | Selected |  |  |  |  | [NAME] SELECTED FOR GFO008354 IN COMMERCIAL
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO007794 | EU | Manager - Property Finance | Group Operations | [NAME] | EU | Finance Manager Banking and Lending Product Partnering | W&I | GFO007963 | EU | Manager GSR Retail & Insurance | W&I | Selected
 |  |  | 0.6 | DU |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] | DU | Assistant Manager, Cost Transfer Charging | Group Operations |  |  |  |  |  |  |  |  | Selected
 |  |  | 1 | EU |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GFO008055 | EU | Business Partnering Manager | Insurance | [NAME] | EU | Manager, Group Cost Management | Group Operations | [NAME] | EU | Finance Manager Banking and Lending Product Partnering | W&I |  |  | Selected |  |  |  |  | [NAME] SELECTED FOR GFO007961 IN W&I
 |  |  |  |  |  |  |  |  |  | SUMPRODUCT(({"Resigned","Transfer",New LBG Role"},K2:K126)*D2:D126)