{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Background","SOP","Relevant Achilles Questions","Heat_mapping","Relevancy Guidance"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":1,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Background","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[" "]
["Purpose:\nThe purpose of this document is to provide procurement with the information needed to take Supply Chain CSR/Sustainability considerations into account when developing a sourcing strategy"]
[]
["Why this is important:\n1. We have made key external commitment to embed Sustainability considerations into our Procurement process\nA)In our last ISO 14001 Environmental Audit the fact that we do not embed environmental considerations into our sourcing decisions was identified as a weakness. In our corrective action plan we made a commitment to address this\nB) In our Modern Slavery Statement for 2018 we made a clear commitment to 'Incorporate risk assessments into procurement sourcing activity and part of award criteria'\nC)  One of the 5 commitments in the EU (Energy & Utility) Procurement Skills Accord is that, where relevant, signatories will embed relevant  skills development in their procurement process, evaluation criteria and contracts. This is also relevant in the US.\n2. We aim to be aligned to industry best practice and use the ISO 20400 Sustainable Procurement Guidance standard as reference\n3. Sustainability is now a core competency of Procurement professionals and we want to build up this capability within the Procurement function\n"]
[]
["Context:\n1. Benchmarking what other organisations do\n2. ISO 20400 Guidance"]
[]
["Process:\n1. There are already some key pre-qualification questions included in Achilles (UK) which address mandatory questions on Policy and legal compliance\n2. We have a created a relevancy decision tool to consider whether project specific Sustainability criteria should be included in a sourcing event\n3. If relevant project specific questions should be incorporated into the sourcing activity (support will be provided by the Supply Chain CSR team to support this decision)\n4. The assessment of the questions will be developed based on agreed scoring guidance (possibly some fundamental pass/fail criteria)\n5. There may be some scoring of questions on a case by case basis if deemed to be material to the sourcing activity"]

{"sheet":"SOP","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[9,0,12,0],[13,0,16,0],[13,3,16,5],[13,1,16,1],[8,3,8,5],[9,1,12,1],[9,3,12,5],[0,2,0,4],[4,0,4,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,5]]}
["Date","2019-03-08"]
["Originator","Nathalie Ritchie"]
["Team","Supply Chain CSR, Global Strategy"]
[]
["Operation Name",null,"Embedding relevant Supply Chain CSR/Sustainability considerations into SSP",null,"Page","1 of 1"]
[]
["No.","Main Operating Steps","Key Points","Explanation / Examples / Diagrams"]
[]
[1,"Introduction","The approach has been designed to ensure relevant Sustainability criteria are considered in the SSP","To meet audit requirements (ISO 14001 and ISO 50001) and drive alignment to Sustainable Procurement Guidance standard (ISO 20400)"]
[2,"Context:\nRelevancy & heat mapping","Step 1: A basic relevancy decision matrix has been created against 4 fundamental CSR/Sustainability considerations"]
[null,null,"Step 2: A heat mapping has been undertaken against the UVDB categories of spend using the 4 CSR/Sustainability considerations"]
[null,null,"Step 3: The relevant Achilles questions have been allocated to the 4 CSR/Sustainability areas of consideration"]
[null,null,"Step 4: A Sustainability Assessment Tool has been developed using the heat mapping allocation "]
[3,"Using the Sustainability Assessment Tool","SOP 1: Using the worksheet 'Relevant Achilles Questions' - Choose the relevant UVDB category of spend for your sourcing activity"]
[null,null,"SOP 2: Click on 'select tender questions'"]
[null,null,"SOP 3: Review associated Achilles UVDB Questions : Positive response required to yes/no questions"]
[null,null,"SOP 4: Assess free text responses using Evaluation Guidance provided"]
["Last Update by Name/Position","Date","Name / Position Approver","Date","Next Review due by","Date"]
[{"$f":"'[1]Version control'!D17","v":"Nathalie Ritchie"},{"$f":"B1","v":"2019-03-08"}]

{"sheet":"Relevant Achilles Questions","index":2,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,5,0,8]]}
[null,null,null,null,null,"Sustainability Impact -\n Pre-qualification Question Set "]
[null,null,null,null,null,"UVDB Spend Category:","PIPE SERVICES"]
[null,null,null,null,null,{"$f":"Heat_mapping!F2","v":"Environmental - energy consumption / carbon impact"},{"$f":"Heat_mapping!G2","v":"Environmental - resources/materials"},{"$f":"Heat_mapping!H2","v":"Social - Human Rights"},{"$f":"Heat_mapping!I2","v":"Economic - workforce skills, community impact"}]
[null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($G$2,Heat_mapping!$E$4:$I$43,2,FALSE)),\"Category not selected\",(VLOOKUP($G$2,Heat_mapping!$E$4:$I$43,2,FALSE)))","v":"Yes"},{"$f":"IF(ISERROR(VLOOKUP($G$2,Heat_mapping!$E$4:$I$43,3,FALSE)),\"Category not selected\",(VLOOKUP($G$2,Heat_mapping!$E$4:$I$43,3,FALSE)))","v":"Yes"},{"$f":"IF(ISERROR(VLOOKUP($G$2,Heat_mapping!$E$4:$I$43,4,FALSE)),\"Category not selected\",(VLOOKUP($G$2,Heat_mapping!$E$4:$I$43,4,FALSE)))","v":"Yes"},{"$f":"IF(ISERROR(VLOOKUP($G$2,Heat_mapping!$E$4:$I$43,5,FALSE)),\"Category not selected\",(VLOOKUP($G$2,Heat_mapping!$E$4:$I$43,5,FALSE)))","v":"Yes"}]
[]
["Selection Ind #1","Selection Ind #2","Selection Ind #3","Selection Ind #4","Consolidated Selection Ind #5","Area of Focus","Achilles section","Achilles question","Required response"]
[{"$f":"IF($F$4=\"Yes\",\"Y\",\"\")","v":"Y"},{"$f":"IF($G$4=\"Yes\",\"Y\",\"\")","v":"Y"},{"$f":"IF($H$4=\"Yes\",\"Y\",\"\")","v":"Y"},{"$f":"IF($I$4=\"Yes\",\"Y\",\"\")","v":"Y"},{"$f":"IF(OR(A7=\"Y\",B7=\"Y\",C7=\"Y\",D7=\"Y\"),\"Y\",\"\")","v":"Y"},"General","Supply Chain Management","Does the company have a formal mechanism to select approved subcontract companies to help fulfil their scope of service?","Yes"]
[{"$f":"IF($F$4=\"Yes\",\"Y\",\"\")","v":"Y"},{"$f":"IF($G$4=\"Yes\",\"Y\",\"\")","v":"Y"},{"$f":"IF($H$4=\"Yes\",\"Y\",\"\")","v":"Y"},{"$f":"IF($I$4=\"Yes\",\"Y\",\"\")","v":"Y"},{"$f":"IF(OR(A8=\"Y\",B8=\"Y\",C8=\"Y\",D8=\"Y\"),\"Y\",\"\")","v":"Y"},"General","Quality Management","Does your company have a documented [ QM / HS / ENV ] Management system?","Yes"]
[{"$f":"IF($F$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,null,null,"Y","Environment - Energy/Carbon","Environment Management","Does your company identify the environmental impacts of your operations?","Yes"]
[{"$f":"IF($F$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,null,null,"Y","Environment - Energy/Carbon","Environment Management","Do you have an Environmental Action Plan in place to reduce your impact on the environment?","Yes"]
[{"$f":"IF($F$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,null,null,"Y","Environment - Energy/Carbon","Environment Management","Have you completed an environmental impact assessment of the products/services that you supply with regards to sustainable development?","Yes"]
[null,{"$f":"IF($G$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,null,"Y","Environment - Resources","CSR","Does your company have any Policies or programmes regarding use of Natural Resources?","Yes"]
[null,{"$f":"IF($G$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,null,"Y","Environment - Resources","CSR","Do you carry out bio-diversity action plans","Yes"]
[null,null,null,{"$f":"IF($I$4=\"Yes\",\"Y\",\"\")","v":"Y"},"Y","Economic - workforce skills, community impact","CSR","Does the company have any programmes or policies in place to encourage local sourcing?","Yes"]
[null,null,null,null,null,"Economic - workforce skills, community impact","CSR","Is your organisation actively committed to Workforce Sustainability/Resilience to ensure continuity of operational and technical skills across the sector?","Yes"]
[null,null,null,null,null,"Economic - workforce skills, community impact","CSR","Has your organisation completed a Strategic Workforce Plan?  ","Yes"]
[null,null,null,null,null,"Economic - workforce skills, community impact","CSR","Does your organisation undertake any of the following activities to attract, recruit and retain skilled personnel within your sector as part of your Workforce Renewal & Skills Strategy?","Drop Down List (multi Select);\nApprenticeships\nApprenticeship Levy\nGraduate Schemes\nIn House Development Programmes\nIn House Training Programmes\nRelevant utility Professional Institution membership"]
[null,null,null,null,null,"Economic - workforce skills, community impact","CSR","Does your organisation subscribe to any externally operated initiative in relation to Workforce Sustainability/Resilience?","Drop Down List (multi Select);\nEnergy & Utilities Skills Partnership\nEnergy & Utility Procurement Skills Accord\nEnergy & Utility Talent Source Network\n5% club\nOther "]
[null,null,{"$f":"IF($H$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,"Y","Social - human rights","CSR","Does your organisation have a documented policy to ensure that neither slavery nor human trafficking takes place within your organisation?","Yes"]
[null,null,{"$f":"IF($H$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,"Y","Social - human rights","CSR","Please provide details of what your organisation does to prevent slavery or human trafficking","Free text"]
[null,null,{"$f":"IF($H$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,"Y","Social - human rights","CSR","Does your organisation have a documented policy to ensure that neither slavery nor human trafficking takes place within its supply chain?","Yes"]
[null,null,{"$f":"IF($H$4=\"Yes\",\"Y\",\"\")","v":"Y"},null,"Y","Social - human rights","CSR","Please provide details of what your organisation does to prevent slavery or human trafficking in its supply chain ","Free text"]

{"sheet":"Heat_mapping","index":3,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,4,0,9]]}
[null,null,null,null,"HEAT MAP TEMPLATE"]
[null,null,null,null,"SUSTAINABILITY IMPACT","Environmental - energy consumption / carbon impact","Environmental - resources/materials","Social - Human Rights","Economic - workforce skills, community impact","Comments"]
["UK Category team","UK Owner ","US Category Team ","US Owner","UVDB SPEND CATEGORY"]
["Indirects","Dan Goodchild","Indirects ","Pamela Booden ","CONSULTANCY","No","No","No","No"]
["GTO","Michael Mahon","Directs","Micheal Rotondo ","PIPE SERVICES","Yes","Yes","Yes","Yes"]
["Indirects","Dan Goodchild","Indirects","John Harrington ","IS","Yes","No","No","No"]
["Construction","Simon Smith","Electrical Construction ","Matt Bieber","BUILDING, CIVIL ENGINEERING & ASSOCIATED SERVICES","Yes","Yes","Yes","Yes"]
["ETO","Simon Smith","Electrical Construction ","Matt Bieber","OHL","Yes","Yes","Yes","Yes"]
["Indirects","Sarah Bayliss","Indirects ","Robert McCarthy ","FACILITIES","Yes","Yes","Yes","Yes"]
["ETO","Simon Smith","N/A","N/A","CONTROL & PROTECTION","No","Yes","Yes","No"," "]
["Indirects ","Alastair Patterson","Indirects ","Eric Crawford ","FLEET","Yes","No","No","No"]
["ETO","Simon Smith","Directs","Micheal Rotondo ","SUBSEA CABLES","Yes","Yes","Yes","Yes"]
["Indirects","Dan Goodchild","Indirects ","Pamela Booden ","RECRUITMENT SERVICES","No","No","Yes","Yes"]
["Indirects","Dan Goodchild","Indirects ","Pamela Booden ","BUSINESS & ADMINISTRATIVE SERVICES","No","No","No","No"]
["ETO","Simon Smith","Directs","Robert Kopp","TRANSFORMERS","Yes","Yes","Yes","No"]
["ETO","Simon Smith","Directs","Robert Kopp","METERS","Yes","Yes","Yes","Yes"]
["ETO","Simon Smith","Electrical Construction ","Matt Bieber","OVERHEAD LINE EQUIPMENT & ACCESSORIES","Yes","Yes","Yes","Yes"]
["GTO","Michael Mahon","Directs","Micheal Rotondo ","PIPES & ACCESSORIES","Yes","Yes","Yes","Yes"]
["ETO","Sara Tibbatts","Directs","Micheal Rotondo ","CABLES","Yes","Yes","Yes","Yes"]
["Indirects","Sarah Bayliss","Directs","Robert Kopp","MRO/PPE","Yes","Yes","Yes","No"]
["ETO","Simon Smith","Electrical Construction ","Diego Chevere","SUBSTATION SERVICES","Yes","No","Yes","Yes"]
["ETO","Simon Smith","Directs","Jim Powers","SWITCHGEAR","Yes","No","Yes","Yes"]
["Indirects","Dan Goodchild","Indirects ","Pamela Booden ","LEGAL SERVICES","No","No","No","No"]
["GTO","Michael Mahon","Directs","Robert Kopp","ENERGY, WATER, FUELS, OILS & GREASES","Yes","Yes","No","No"]
["Construction","Sarah Bayliss","Directs","Deb Smith ","BUILDING / CIVIL PRODUCTS","Yes","Yes","Yes","Yes"]
["GTO","Michael Mahon","Gas Construction","Don Schaefer","GENERATION PLANT & EQUIPMENT","Yes","Yes","Yes","No"]
["Indirects","Sarah Bayliss","Directs","Robert Kopp","TOOLS & SPECIALIST EQUIPMENT","No","Yes","Yes","No"]
["Indirects","David Short","Indirects ","Pamela Booden ","TRAVEL","Yes","No","Yes","No"]
["GTO","Dave Thomas","Directs","Robert Kopp","INDUSTRIAL GASES","Yes","No","No","No"]
["Indirects","Dan Goodchild","Indirects ","Pamela Booden ","TRAINING","No","No","No","No"]
["GTO","Michael Mahon","Gas Construction","Bob Flynn","VALVES, ACTUATORS & SPARES","No","Yes","Yes","No"]
["ETO","Michael Barker","Directs","Robert Kopp","SUBSTATION MATERIALS","No","Yes","Yes","No"]
["GTO","Michael Mahon","Gas Construction","Don Schaefer","TURBINE SERVICES","Yes","No","No","Yes"]
["GTO","Michael Mahon","Gas Construction","Don Schaefer","GENERATION SERVICES","No","No","No","Yes"]
["GTO","Michael Mahon","Gas Construction","Don Schaefer","GAS TRANSMISSION/DISTRIBUTION PLANT & EQUIPMENT","Yes","Yes","No","Yes"]
["Indirects","Sarah Bayliss","Indirects","Eric Crawford ","TRANSPORT, STORAGE & HIRE SERVICES","Yes","No","Yes","No"]
["Indirects","Sarah Bayliss","Indirects ","Kelly Reardon ","OFFICE/DEPOT MATERIALS & EQUIPMENT","Yes","No","Yes","No"]
["Indirects","Sarah Bayliss","Gas Construction","Don Schaefer","MECHANICAL MACHINERY, EQUIPMENT & SPARES","No","No","Yes","No"]
["Fleet","Alastair Patterson","Electrical Construction ","Steve Peltier ","TRANSPORT & MOBILE PLANT","Yes","No","Yes","No"]
["ETO","Simon Smith","Directs","Adam Karboski","ELECTRICAL PROTECTION EQUIPMENT","Yes","No","No","No"]
["GTO","Michael Mahon","Directs","Mike Rotondo ","CHEMICALS","Yes","Yes","No","No"]
["GTO","Michael Mahon","Gas Construction","Don Schaefer","PUMPS, ACCESSORIES & SPARES","No","No","Yes","No"]
[null,null,null,null,"Bespoke arrangement","Yes","No","No","No"]

{"sheet":"Relevancy Guidance","index":4,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,1,4,4]]}
[]
[]
[null,"Sustainable Procurement Criteria - decision tool"]
[]
[null,"The below decision tool is to be used to ensure the effective assessment of whether relevant sustainable procurement criteria should be included in the tender.\nPlease follow the steps selecting either 'yes' or 'no' from the drop down menu in column C. \nSuggested questions will then be provided as to the correct level of consideration required.  \n"]
[]
[null,"EVENT NO / TITLE:","[Insert WS Number and Title]","BUYER NAME / TELEPHONE :","[Insert Name, Number and Title]"]
[null,"EVENT DESCRIPTION:","[Insert brief description of the works, products or services being procured]","BUSINESS UNIT:","[Insert which part of the business requires the works, products or services] "]
[]
[null,"Area of focus","Description","Yes/No","Considerations"]
[1,"Environmental \n- energy consumption / carbon impact","\nWill the service or product  supplied have a high associated energy consumption/carbon impact?\n\n\n",null,"Consider the scope of the work/service provided/goods produced\n- Energy consumption in the operation of the service provided/production of the product?\n- High levels of transportation/travel involved?\n- Opportunities to use renewable energy?"]
[2,"Environmental \n- biodiversity","\nWill the service or product supplied have an impact on land use/natural habitats and potential impact on biodiversity?\n\n",null,"Consider the scope of the work/service provided/goods produced\n- Extraction of virgin/raw materials in the production process\n- Potential  land/water pollution (Use of hazardous materials)"]
[2,"Environmental \n- Resources","\nWill the service or product supplied have a high use of materials/resources and/or an inpact on biodiversity?\n\n",null,"Consider the scope of the work/service provided/goods produced\n- high use of virgin/raw materials  - associated waste materials\n- Opportunities for reducing use of materials - recycling/re-use\n- consideration of the whole lifecycle from use of materials to disposal\n- High water consumption in production / in an area of water scarcity\n- risk of land/water pollution"]
[null,"Environmental \n- water consumption /water scarcity","\nWill the service or product  have a high associated use of water or come from a source in a water stress area?\n\n\n",null,"Consider the scope of the work/service provided/goods produced"]
[3,"Social - human rights","Will the product or service have potential Human Rights risk in the supply chain? Including but not limited to modern slavery, the use of conflict minerals?\n\n",null,"Risk considerations  (risk assessment toolkit available)\n- sourcing from a high risk country?\n- sourcing in a high risk industry/category?\n- high levels of supply chain complexity/sub-contracting?\n- brand association                                                                       \nUnderstand potential labor standards/working conditions  in local context - working hours, H&S, wages, benefits\nUse of conflict minerals - cassiterite (tin),  wolframite (tungsten), coltan (tantalum), gold (ore)"]
[4,"Economic -\n skills development/strategic workforce planning\n","Does the product or service come from an industry where there are potential skills shortages?",null,"Strategic workforce planning is key to ensure we have the right skills in place to deliver our key business projects.\nIn the UK NG are members of the EU (Energy & Utility) Skills Accord  which promotes skills development and training in the supply chain to ensure strategic workforce planning.\nIn the US NG is  a partner with the Small Business Services - CAP (Corporate Alliance Partners) - Construction Mentoring Program which provides development and mentoring opportunities."]