Spreadsheet: 168638d1342531479-pivot-table-advanced-filter-or-countif-in-excel-2007-pivot-table-advanced-filter-or-countif
Sheet: Sheet1

Development Needs Development Area 1 - 9 | Development Activity Total Count | Count of People (Rows) with that development activity | 70 - On the job | 20 - Coaching / Mentoring | 10 - Course / Programme | 10 - E - Learning | 10 - Research / Reading
HSSE
Personal Development
Technical/Functional
Management/Leadership
Business Skills
Dev. [NAME]. Area 1 | Dev. Needs Description 1 | Dev. Needs Activity 1 | Dev. Needs Activity Details/Actions 1 | Dev. Needs Target Date 1 | Dev. [NAME]. Area 2 | Dev. Needs Description 2 | Dev. Needs Activity 2 | Dev. Needs Activity Details/Actions 2 | Dev. Needs Target Date 2 | Dev. [NAME]. Area 3 | Dev. Needs Description 3 | Dev. Needs Activity 3 | Dev. Needs Activity Details/Actions 3 | Dev. Needs Target Date 3 | Dev. [NAME]. Area 4 | Dev. Needs Description 4 | Dev. Needs Activity 4 | Dev. Needs Activity Details/Actions 4 | Dev. Needs Target Date 4 | Dev. [NAME]. Area 5 | Dev. Needs Description 5 | Dev. Needs Activity 5 | Dev. Needs Activity Details/Actions 5 | Dev. Needs Target Date 5 | Dev. [NAME]. Area 6 | Dev. Needs Description 6 | Dev. Needs Activity 6 | Dev. Needs Activity Details/Actions 6 | Dev. Needs Target Date 6 | Dev. [NAME]. Area 7 | Dev. Needs Description 7 | Dev. Needs Activity 7 | Dev. Needs Activity Details/Actions 7 | Dev. Needs Target Date 7 | Dev. [NAME]. Area 8 | Dev. Needs Description 8 | Dev. Needs Activity 8 | Dev. Needs Activity Details/Actions 8 | Dev. Needs Target Date 8 | Dev. [NAME]. Area 9 | Dev. Needs Description 9 | Dev. Needs Activity 9 | Dev. Needs Activity Details/Actions 9 | Dev. Needs Target Date 9
Personal Development | Raise my profile with the HR leadership team by becoming a more proactive member of the HR community. | 70 - On the job | Identify area(s) where I can make a meaningful contribution and ensure I take a proactive approach to involving others and communicating results upwards. | 2012-11-01 00:00:00 | Technical/Functional | Become an expert in CIPD upgrading assessments and pass on my knowledge to colleagues in BG. | 20 - Coaching / Mentoring | Continue to work closely with CIPD to assess upgrading applications (average 1 per fortnight).,  Work on a one to one basis with colleagues who are looking to progress their CIPD membership.  Also, utilise my CCoaching accrediation to coach others. | 2012-12-01 00:00:00 | Technical/Functional | Become a fully fledged Pensions Trustee, able to make meaningful contributions at meetings. | 10 - Course / Programme | Mainly through classroom based training but also attendance at Trustee meetings. | 2013-06-01 00:00:00
Technical/Functional | Financial Reporting - Be proactive in providing financial data upon request.  Understand and analyse data to a point where I am in a position to answer questions instantly. | 70 - On the job | Regularly review budgets, actuals and forecast, investigating any abnormal costs by using SAP system, speaking to colleagues so variances are fully understood and can be reported to managers. | 2012-10-01 00:00:00 | Personal Development | Develop more self confidence to be able to talk and act confidently regardless of what the situation or who I am talking to.  Not to be afraid to voice out my ideas and opinions and willing to try new things and take risks. | 70 - On the job | Review voice impact course recently taken and practice with colleague who attended same course.  Contact Learning Management System co-ordinator for any suitable courses. | 2012-11-01 00:00:00 | Business Skills | Improve [NAME] and Excel skills | 10 - Course / Programme | Attend external courses, complete self learning courses. | 2012-12-01 00:00:00
Technical/Functional | Attend and become involved in SPE related Well Integrity forums. | 10 - Course / Programme | Attend Well Integrity/Workover/Completion related courses/seminars | 2011-12-01 00:00:00
Business Skills | Integrate HSSE into BG Group leadership development programmes and identify appropriate programmes for capability needs of FCRs, FSRs and LEADs talent pool | 20 - Coaching / Mentoring | Knowledge transfer of parenting skills and management of Chairman's Awards process. Identify and support successors. | 2013-05-01 00:00:00 | Business Skills | Integrate HSSE into BG Group leadership development programmes and identify appropriate programmes for capability needs of FCRs, FSRs and LEADs talent pool | 10 - Course / Programme | Retirement planning | 2012-12-01 00:00:00
Technical/Functional | Developing through day to day work | 70 - On the job | On-going discussions with colleagues within BG on Cost Recovery initiatives. These will take the form of regular discussions with CRT, Tax and BGA. | 2013-05-01 00:00:00 | Technical/Functional | Updating knowledge of Accounting to satisfy ACCA CPD requirements | 10 - Course / Programme | IFRS | 2013-04-01 00:00:00 | Technical/Functional | Developing through day to day work | 70 - On the job | On-going discussions with colleagues outside of BG on Cost Recovery initiatives. These will take the form of brainstorming and attending forums on cost recovery and related subjects. | 2013-05-01 00:00:00 | Technical/Functional | Updating knowledge of Accounting to satisfy ACCA CPD requirements | 10 - E - Learning | Relevant topics to be studied to accrue adequate CPD points | 2013-06-01 00:00:00
Technical/Functional | I want to carry on continuously improving my technical and functional skills and knowledge, through a combination of further experience, dialogue with corporate treasurers and other experts, and relevant seminars and conferences | 70 - On the job | Further on-the-job experience though assignments as they arise | 2012-12-01 00:00:00 | Technical/Functional | I want to carry on continuously improving my technical and functional skills and knowledge, through a combination of further experience, dialogue with corporate treasurers and other experts, and relevant seminars and conferences | 10 - Course / Programme | Attend relevant seminars and conferences | 2012-12-01 00:00:00 | Technical/Functional | I want to carry on continuously improving my technical and functional skills and knowledge, through a combination of further experience, dialogue with corporate treasurers and other experts, and relevant seminars and conferences | 10 - Research / Reading | Dialogue with corporate treasurers and other Treasury experts | 2012-12-01 00:00:00
Management/Leadership | I have firm views on how the Tax Department could be better organized and managed in order to provide greater efficiency and effectiveness. | 10 - Course / Programme | I would like to attend the PWC strategic tax management course in Q3 2012. | 2012-11-01 00:00:00 | Management/Leadership | I have firm views on how the Tax Department could be better organized and managed in order to provide greater efficiency and effectiveness. | 70 - On the job | Having only been in the Acting role for some 2 months I am being given the opportunity to develop and would very much like to continue that development. | 2012-12-01 00:00:00 | Management/Leadership | I have firm views on how the Tax Department could be better organized and managed in order to provide greater efficiency and effectiveness. | 20 - Coaching / Mentoring | I have had the offer of ad hoc mentoring by two Big 4 tax partners which I intend taking advantage of. | 2012-12-01 00:00:00
HSSE | Chartered Membership | 10 - Course / Programme | IPD | 2013-03-01 00:00:00
Management/Leadership | Leading the team through the hand-over from the previous Head of Insurable Risk through an annual renewal cycle whilst challenging the core components of the existing programmes. | 70 - On the job | On the job workplace learning | 2013-03-01 00:00:00 | Management/Leadership | Successful integration of a new member in to an established, experienced Team | 20 - Coaching / Mentoring | Coaching, mentoring and managing of all the team members to ensure a seamless and uninterrupted insurable risk service to the Group. | 2013-06-01 00:00:00 | Technical/Functional | Continue to update my knowledge base using both internal and external sources | 10 - Course / Programme | Attendance at appropriate conferences, workshops and seminars as appropriate over the year, with specific reference to cyber and political risks. | 2013-06-01 00:00:00
Technical/Functional | would like some further involvement in tax technical issues - disposal/acquisition, CFC's, specific projects | 70 - On the job | To be discussed with Manager | 2013-03-01 00:00:00 | Management/Leadership | I have now taken on responsibility (again) for managing members of the compliance team - I would like to address specific performance issues during the next year. In addition, I would like to take on a coordination role with HR for staff dev. | 70 - On the job |  | 2013-04-01 00:00:00 | Management/Leadership | I would like to attend some formal training to gain insight in to my management strengths and weaknesses. Perhaps coaching skills | 20 - Coaching / Mentoring |  | 2013-03-01 00:00:00
Technical/Functional | Increase knowledge of HR core skills, especially those related to OD and L&D. | 70 - On the job | Involvement in Project Express AM outsource programme, especially the TUPE exercise and similar activities in other locations and with contractor migration | 2012-10-01 00:00:00 | Personal Development | Improve ability to make an impact through presentations and general business engagement - feedback has shown that I can become quiet when confronting challenging environments and individuals and therefore fail to achieve my aims | 10 - Course / Programme | BG High Impact Voice And Presentation Skills | 2012-12-01 00:00:00 | Technical/Functional | Increase knowledge of HR core skills, especially those related to OD and L&D. | 20 - Coaching / Mentoring | Spend time with my new colleagues in HR understanding their roles and using this to assist my integration into HR and my overall knowledge of the subject and how it is implemented in BG | 2013-04-01 00:00:00 | Technical/Functional | Increase knowledge of HR core skills, especially those related to OD and L&D. | 10 - Course / Programme | Achieve or move closer to being a chartered HR professional - currently an associate member | 2013-04-01 00:00:00
Personal Development | Ensure to keep up to date with all the relevant changes and proposed changes to SAP and HSBC process changes | 10 - Course / Programme | Overview with Treasury in relation to submission of our daily cash flow requirments | 2012-12-01 00:00:00
Technical/Functional | Writing dynamics course. Also seek out IFRS and/or LMS opportunities to develop further understanding of accounting | 10 - Course / Programme | Fundamentals of gas and oil contracts or Joint Venture agreement/PSC commercial workshop | 2012-10-01 00:00:00 | Technical/Functional | Writing dynamics course. Also seek out IFRS and/or LMS opportunities to develop further understanding of accounting | 10 - Course / Programme | Shadow work with IA Managers to attain greater understanding of financials/accounting | 2012-11-01 00:00:00 | Technical/Functional | Writing dynamics course. Also seek out IFRS and/or LMS opportunities to develop further understanding of accounting | 70 - On the job | Rio/asset visit to manage stakeholder relationships, develop approvals plan and provide training / consultantcy | 2012-09-01 00:00:00
Management/Leadership | Receive informal mentoring and coaching from senior level | 20 - Coaching / Mentoring | Establish links with EVPs | 2013-06-01 00:00:00 | Management/Leadership | Potential leadership course at USA Business School | 10 - Course / Programme | An offsite residential course | 2013-06-01 00:00:00
Management/Leadership | To be able to offer full support of managing / running the department in the payroll managers absence | 70 - On the job | Actively look to widen knowledge by involving myself in the unknowns of the payroll department | 2012-12-01 00:00:00
Personal Development | Focus on my medium to long term career aspirations within Treasury. | 20 - Coaching / Mentoring | Investigate possible career progressions within the Treasury Function and find out what is required to achieve those goals.  Discuss further options with [NAME] Manager, other Department Managers and [NAME].  Formulate action plan for 2013 ADR. | 2012-12-01 00:00:00 | Personal Development | Improve presenting skills. | 10 - Course / Programme | Attend 'High Impact Voice and Presentation Skills' course from core curriculum. Aimed at gaining confidence presenting to higher level audiences. | 2013-04-01 00:00:00 | Technical/Functional | Aim to expand on job knowledge of the wider Treasury Function outside Accounting to a greater level understanding. | 10 - Course / Programme | ACMT Diploma in Treasury. I am exempt from the first level of AMCT stage one and only need to do a conversion paper in stage two and two papers from four at stage three to receive the Diploma.  I would be looking to do this over an 18 month period. | 2013-10-01 00:00:00 | Personal Development | Focus on my medium to long term career aspirations within Treasury. | 70 - On the job | Keep up high involvement in Treasury Projects.  Gain a greater understanding of Treasury outside of accounting.  See how projects, such as debt issuance and M&A, develop from the start and how other functions involved interact with each other. | 2013-07-01 00:00:00 | Personal Development | Improve presenting skills. | 10 - Course / Programme | Attend 'Writing Dynamics' course from core curriculum. | 2013-04-01 00:00:00 | Technical/Functional | Aim to expand on job knowledge of the wider Treasury Function outside Accounting to a greater level understanding. | 10 - E - Learning | Continue with [NAME] development tool and [NAME] online courses throughout the development year and targeting Treasury related non accounting courses as well. | 2013-07-01 00:00:00
Personal Development | Impact | 70 - On the job | I am interested in short term assignment opportunities. | 2013-06-01 00:00:00 | Personal Development | Impact | 10 - Course / Programme | Undertake activities to raise my profile especially within Finance by focusing on Impact | 2013-06-01 00:00:00
Management/Leadership | work with others across UKU and the wider BG community to share experience in non-operate environment and to assist in developing and implementing best practice | 70 - On the job | actively engage with others working in non-operate environment to share learnings elsewhere within UKU and those in UKU with other assets | 2012-12-01 00:00:00 | Technical/Functional | develop further experience internationally by assisting, where appropriate, in early stages of upstream projects | 20 - Coaching / Mentoring | supporting local lawyers to provide expert upstream experience | 2012-12-01 00:00:00
Management/Leadership |  | 10 - Course / Programme | Attend Duke leadership course as recommended by parent mgr - [NAME] | 2012-12-01 00:00:00 | Technical/Functional |  | 10 - Course / Programme | Attend course and or on job learning and or coaching to increase technical knowledge especially of fraccing, pilots, E&A work programme etc | 2012-12-01 00:00:00 | HSSE | I am always interested to further develop my knowledge and competence in HSE matters & use every opportunity to do so especially "on the job" and from the exposure I get to many parts of the business especially Ops & the Project | 10 - Course / Programme | Attend training on how to conduct Incident Investigations | 2012-12-01 00:00:00 | Management/Leadership |  | 10 - Course / Programme | Attend public speaking course to increase confidence at speaking publicly to large groups of people. [NAME] (London) personal presentations course is recommended. | 2012-12-01 00:00:00
HSSE | Be aware of HSSE needs for the project and encourage team members accordingly. | 10 - Research / Reading | Given current age, develop technical knowledge by reading technical publications/literature etc. | 2013-06-01 00:00:00
Technical/Functional | Would like to take part in some execution management as well as engineering this year to develop my skills. | 10 - Course / Programme | Would like to take part in some further relevent ABB/Motorola technical training this year. | 2013-05-01 00:00:00
Technical/Functional | Continue learning and developing skills on the job by participating in interesting and challenging projects.  [NAME] is keen not to be diverted to other matters, such a dealing, on a routine basis. | 70 - On the job | Continue learning and developing skills on the job by participating in interesting and challenging projects.  [NAME] is keen not to be diverted to other matters, such a dealing, on a routine basis. | 2013-06-01 00:00:00
Business Skills | Gain more detailed familiarity with downstream modelling and corporate financials | 10 - Course / Programme | Attended downstream course in 2011 at Economics Conference but more in-depth course required, eg one-to-one with G [NAME] | 2012-12-01 00:00:00 | Business Skills | Gain familiarity with the new BPC system | 10 - E - Learning | LMS course and through use of system | 2012-10-01 00:00:00 | Business Skills | Gain more detailed familiarity with downstream modelling and corporate financials | 10 - Research / Reading | Read 'Principles of Corporate Finance' (Brealey/Myers/Allen) and gain on-the-job experience | 2013-06-01 00:00:00
Management/Leadership |  | 20 - Coaching / Mentoring | Part of Group Development Programme for Hi Potential - completed assessment and report with external party for submission to GEC | 2012-12-01 00:00:00
Technical/Functional | I will find appropriate seminars being held to cover current developments in the Industry. | 10 - Course / Programme | To be agreed . | 2012-10-01 00:00:00
Personal Development | Continue to develop/apply influencing skills - use in getting [NAME] resolved, getting BGAT amended & rolled out across all FRs & associated actions as per schedule (schedule to be agreed  w/c25th June). | 10 - Course / Programme | Attend industry Assurance forum later in year. | 2012-12-01 00:00:00
Business Skills | Dealing with Contractor representatives and Senior management at the negotiation and decision making meetings where key project decisions are made | 10 - Course / Programme |  | 2013-05-01 00:00:00 | Management/Leadership | Strategic planning for dealing with external stake holders and government bodies at executive level | 20 - Coaching / Mentoring | Work with the Project Director closely to develop skills in the areas of the business that I am less familiar with | 2013-02-01 00:00:00 | HSSE | Dealing with stress for Managers. | 10 - Course / Programme | This is mandatory and to date I have not completed it | 2011-12-01 00:00:00
Technical/Functional | This is in progress, and under discussion with my manager and Group HR as the organisation of the graduate management and parenting is under review more widely in BG. Proposals have been made to my manager and will be reviewed with her and HoFin June | 70 - On the job | In the event that I move back to Development Engineering, identify and recruit successor for my current position | 2012-01-01 00:00:00 | Personal Development | I would like to apply to become a Fellow if the IChemE as I move back into a technical role and continue to guide the Engineering graduates on their careers in BG, although on a more informal basis in the future | 20 - Coaching / Mentoring | Apply to become FIChemE | 2012-12-01 00:00:00 | Personal Development | In order to prepare myself for my new role with the Development Engineering team, I would like to refresh my understanding of the project process in BG by attending the Managing Projects the BG Way course and the Leading Projects course | 10 - Course / Programme | Managing Projects the BG Way | 2012-08-01 00:00:00 | Personal Development | In order to prepare myself for my new role with the Development Engineering team, I would like to refresh my understanding of the project process in BG by attending the Managing Projects the BG Way course and the Leading Projects course | 20 - Coaching / Mentoring | Participate in the Oxford 'Leading Projects' programme | 2012-09-01 00:00:00
Technical/Functional | Keep up to date with key changes to UK and foreign tax legislation as it applies to my role and continued exposure to corporate tax/reporting. | 70 - On the job | Wide variety of new and existing project work / day-to-day transactions | 2012-12-01 00:00:00 | Technical/Functional | Keep up to date with key changes to UK and foreign tax legislation as it applies to my role and continued exposure to corporate tax/reporting. | 10 - Research / Reading | Input into Oil and Gas Association Tax Subcommittee for Tanzania and Kenya and generally keeping up to date with changes in tax regimes through annual Budgets, external advisers, updates etc | 2012-12-01 00:00:00
Technical/Functional | I would like to attend more courses on Risk Management. This was planned for 2012 however, due to circumstances was unable to attend. | 10 - Course / Programme |  | 2013-07-01 00:00:00
Business Skills | Attend course on negotiating skills. Increasingly relevant as involved with various audits and reviews with HMRC. | 10 - Course / Programme | Look for relevant external courses or seminars on RTI. This is going to be the most important change over the next year. | 2013-03-01 00:00:00
Management/Leadership | External Profile | 20 - Coaching / Mentoring | Actively seek to raise my external profile by participating in real estate, FM  and/or travel conferences, seminars, forums etc. as a guest speaker or panel member. Continue membership of ACRE and Corenet and mentoring work with [NAME] | 2013-06-01 00:00:00 | Personal Development | Local Community Activities | 20 - Coaching / Mentoring | Speak to [NAME] about participating in / contributing towards the Community Involvement Team | 2013-06-01 00:00:00 | Personal Development | Languages | 10 - E - Learning | [NAME] Portuguese Course | 2012-12-01 00:00:00
Technical/Functional | Increased involvement with the managing of our Captive Insurance Company and the associated reinsurance programme. | 70 - On the job | Assisting with the ITT for Captive Reinsurance Broking services, evaluation of bids and appointment of Broking Service Provider. | 2012-12-01 00:00:00 | Technical/Functional | Maintain and improve communication via all means including face to face meetings with external Service Providers and Internal connections. Working closely with and learning from colleagues where appropriate, in new Asset responsibilities. | 70 - On the job | Hand over of existing Asset responsibilities to Colleagues  and take on the handling of other Assets from colleagues where agreed. | 2012-12-01 00:00:00 | Personal Development | Responsibility for training and developing new team member | 10 - E - Learning | Look to attend the Performance Through People course. | 2012-12-01 00:00:00 | Personal Development | Responsibility for training and developing new team member | 70 - On the job | Work with Colleagues to manage the integration of a new person into the Insurance Team. | 2012-12-01 00:00:00 | Technical/Functional | Maintain and improve communication via all means including face to face meetings with external Service Providers and Internal connections. Working closely with and learning from colleagues where appropriate, in new Asset responsibilities. | 20 - Coaching / Mentoring | Continue with close involvement with the security team and Shipping Asset as they review and implement new security measures for the LNG fleet. | 2012-12-01 00:00:00 | Technical/Functional | Increased involvement with the managing of our Captive Insurance Company and the associated reinsurance programme. | 20 - Coaching / Mentoring | Developing an understanding of the membership of industry insurance mutual OIL.  Noted as an alternate representative to the Head of Function for OIL. | 2012-12-01 00:00:00 | Technical/Functional | Increased involvement with the managing of our Captive Insurance Company and the associated reinsurance programme. | 20 - Coaching / Mentoring | Working closely with the Head of Function on the placement of the Captive reinsurance programme with the appointed Broker. | 2012-12-01 00:00:00 | Technical/Functional | Maintain and improve communication via all means including face to face meetings with external Service Providers and Internal connections. Working closely with and learning from colleagues where appropriate, in new Asset responsibilities. | 10 - Course / Programme | Look to attend the OIL sponsored Energy School course. | 2013-06-01 00:00:00
Technical/Functional | Undertand details of IA job and build good understanding of complex transactions | 70 - On the job | Working closely with IA team to develop depth in complex transactions.  Develop knowledge of shipping transactions, M&A and divestments. Shadow [NAME] on Avatar and support [NAME] on GEMs. | 2013-02-01 00:00:00 | Personal Development | Coaching | 20 - Coaching / Mentoring | Continue with coaching activities and 4 planned supervision session  Looking to preparation for next level of accreditation | 2013-12-01 00:00:00 | Technical/Functional | Finance skills | 10 - Course / Programme | Find a suitable stretch course that relates to complex issues of job | 2012-12-01 00:00:00 | Technical/Functional | Undertand details of IA job and build good understanding of complex transactions | 70 - On the job | Assist Assurance Manager (commercial) in commercial assurance | 2013-05-01 00:00:00 | Technical/Functional | Finance skills | 10 - Course / Programme | Attend Managing Projects the BG Way | 2012-12-01 00:00:00
Management/Leadership | To coach and inspire others within the organisation to deliver on obligations and best practice | 70 - On the job | Continued exposure to the mega project during assignment in Australia | 2013-03-01 00:00:00 | Management/Leadership | To coach and inspire others within the organisation to deliver on obligations and best practice | 70 - On the job | Obtain additional external exposure through presentations, speaking opportunities and engagement with senior management within contractor organisations to be acknowledged as a leader in the capital projects arena | 2013-03-01 00:00:00 | Management/Leadership | To coach and inspire others within the organisation to deliver on obligations and best practice | 10 - E - Learning | To learn to speak Arabic as an ongoing development in more academic arena | 2013-03-01 00:00:00