{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Your details","SECTION 1","SECTION 2","SECTION 3","FINAL SCORE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"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":"Introduction","index":0,"n_rows":43,"n_cols":1,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["A guide to equality Impact Assessments (EIAs)"]
[]
["What are Equality Impact Assessments (EIAs)?"]
["·           EIAs are a tool to help you analyse and make more considered decisions about changes to service delivery, policy and practice. An EIA will help you to identify how specific communities of interest may be affected by decisions and to consider any potential discriminatory impact on people with protected characteristics ."]
["·           EIAs can also help to improve or promote equality by encouraging you to identify ways to remove barriers and improve participation for people with a protected characteristic."]
[]
["Why do we need to do Equality Impact Assessments (EIAs)?"]
["·           Although not a mandatory requirement, EIAs provide important evidence of how we have considered the implications of service and policy changes and demonstrate how we have met our legal Public Sector Equality Duty (Equality Act 2010)."]
["·           The three main elements of the Public Sector Equality Duty  are:"]
["ü   Eliminating discrimination"]
["ü   Promoting equality of opportunity "]
["ü   Fostering good relations"]
["·           In fulfilling our Public Sector Equality Duty we must ensure that we demonstrate that we have followed a number of key principles  (based on previous case law):"]
["ü   Knowledge"]
["ü   Timeliness"]
["ü   Real consideration"]
["ü   Sufficient information"]
["ü   No delegation"]
["ü   Review"]
["ü   Proper record keeping"]
["·           We need to provide evidence that we have given due regard to any potential discriminatory impact on people with protected characteristics in shaping policy, in delivering and making changes to services, and in relation to our own employees."]
["·           We must always consider whether a service change, decision or policy could have a discriminatory impact on people with protected characteristics, not just any impact that is the same as it would be for everyone else. "]
["·           The EIA tool allows us to capture, demonstrate and publish our rationale of how we have considered our communities and legal responsibilities under the Public Sector Equality Duty and is our main way of providing the evidence needed."]
[]
["·          But above all, EIAs are about understanding and meeting the needs of local people and supporting us to deliver our vision for Kirklees."]
[]
["When do we need to do Equality Impact Assessments (EIAs)?"]
["·           Whenever you plan to change, introduce or remove a service, activity or policy. "]
["·           At the VERY BEGINNING of any process of:"]
["ü Budget setting"]
["ü Service review (including changes to employment practice)"]
["ü Planning new projects and work programmes"]
["ü Policy development and review"]
["ü Procurement or commissioning activity"]
[]
["Who should do it?"]
["·           Overall responsibility for EIAs lies at a service level. A lead officer should be appointed from the service area that is making a proposal and all decisions should be approved by the senior management team in that service."]
["·           Those directly affected (partners, stakeholders, voluntary groups, communities, equality groups etc) should be engaged with as part of the process."]
[]
["How should we do it?"]
["·      Our EIA process has two stages: "]
["Stage 1 - initial screening assessment"]
["Stage 2 - further assessment and evidence "]

{"sheet":"Your details","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,3,4,7],[6,3,6,7],[8,3,8,7],[1,0,1,7],[8,0,8,2],[6,0,6,2],[4,0,4,2],[3,0,3,2],[5,0,5,2],[7,0,7,2],[7,3,7,7],[5,3,5,7],[3,3,3,7]]}
["EIA STAGE 1 – SCREENING TOOL (initial assessment)"]
["The purpose of this screening tool is to help you consider the potential impact of your proposal at an early stage.\n\nPlease give details of your service/lead officer then complete sections 1-3:\n1) What is your proposal?\n2) What level of impact do you think your proposal will have?\n3) How are you using advice and evidence/intelligence to help you?\n\nYou will then receive your stage 1 assessment score and advice on what to do what next."]
[]
["Directorate:",null,null,"Senior Officer responsible for policy/service:"]
["Economy and Infrastructure",null,null,"Adele Poppleton, Head of Service, Culture & Vibrancy"]
["Service:",null,null,"Lead Officer responsible for EIA:"]
["Culture and Vibrancy",null,null,"Adele Poppleton"]
["Specific Service Area/Policy:",null,null,"Date of EIA (Stage 1):"]
["ER6 Economy",null,null,"2018-01-19"]

{"sheet":"SECTION 1","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,0,6,6],[7,0,7,7],[8,0,8,7],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,0,5,6]]}
["1)  WHAT IS YOUR PROPOSAL?",null,null,null,null,null,null,"Please select YES or NO","YES","NO"]
["To introduce a service, activity or policy (i.e. start doing something)",null,null,null,null,null,null,"NO",{"$f":"IF($H2<>\"YES\",0,2)","v":0},{"$f":"IF($H2<>\"No\",0,0)","v":0},"Yes = +2",null,null,"YES"]
["To remove a service, activity or policy (i.e. stop doing something)",null,null,null,null,null,null,"YES",{"$f":"IF($H3<>\"YES\",0,-2)","v":-2},{"$f":"IF($H3<>\"No\",0,0)","v":0},"Yes = -2",null,null,"NO"]
["To reduce a service or activity (i.e. do less of something)",null,null,null,null,null,null,"NO",{"$f":"IF($H4<>\"YES\",0,-2)","v":0},0,"Yes = -2"]
["To increase a service or activity (i.e. do more of something)",null,null,null,null,null,null,"YES",{"$f":"IF($H5<>\"YES\",0,2)","v":2},0,"Yes = +2"]
["To change a service, activity or policy (i.e. redesign it)",null,null,null,null,null,null,"NO",{"$f":"IF($H6<>\"YES\",0,-2)","v":0},0,"Yes = -2"]
["To start charging for (or increase the charge for) a service or activity (i.e. ask people to pay for or to pay more for something)",null,null,null,null,null,null,"YES",{"$f":"IF($H7<>\"YES\",0,-2)","v":-2},0,"Yes = -2"]
["Please briefly outline your proposal and the overall aims/purpose of making this change:",null,null,null,null,null,null,null,{"$f":"SUM(I2:I7)","v":-2},{"$f":"SUM(J2:J7)","v":0},"TOTALS"]
["Closure of Heckmondwike and Holmfirth Markets.  Reduced cleansing costs through use of new compactor.  Increased income through increased charges for car boot sales (£2 extra per car); additional international market; and Sunday markets on New Street every Sunday.\n\nThese proposals will increase the profit margin for Markets and enable the service to get nearer to reaching the income target set each year but it will not deliver any contribution to the council’s savings target.  The increased markets in Huddersfield will contribute to increasing vibrancy in the town centre.",null,null,null,null,null,null,null,"Page Total",{"$f":"SUM(I8:J8)","v":-2}]

{"sheet":"SECTION 2","index":3,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,6,46,7],[33,1,35,1],[37,1,39,1],[41,1,43,1],[9,1,11,1],[13,1,15,1],[17,1,19,1],[21,1,23,1],[25,1,27,1],[29,1,31,1],[8,0,8,2],[7,3,8,3],[0,0,1,2],[7,0,7,2],[2,0,2,2],[5,0,5,2],[4,0,4,2],[3,0,3,2],[6,0,6,2]]}
["2) WHAT LEVEL OF IMPACT DO YOU THINK YOUR PROPOSAL WILL HAVE ON…",null,null,"Level of Impact"]
[null,null,null,"Please select from drop down",2,1,0,-1,"-2 ",null,"Very Positive"]
["Kirklees employees within this service/directorate? (overall)",null,null,"Neutral",{"$f":"IF($D3<>\"Very Positive\",0,2)","v":0},{"$f":"IF($D3<>\"Positive\",0,1)","v":0},{"$f":"IF($D3<>\"Neutral\",0,0)","v":0},{"$f":"IF($D3<>\"Negative\",0,-1)","v":0},{"$f":"IF($D3<>\"Very Negative\",0,-2)","v":0},null,"Positive"]
["Kirklees residents living in a specific ward/local area?",null,null,"Negative",{"$f":"IF($D4<>\"Very Positive\",0,2)","v":0},{"$f":"IF($D4<>\"Positive\",0,1)","v":0},{"$f":"IF($D4<>\"Neutral\",0,0)","v":0},{"$f":"IF($D4<>\"Negative\",0,-1)","v":-1},{"$f":"IF($D4<>\"Very Negative\",0,-2)","v":0},null,"Neutral"]
["Please tell us which area/ward will be affected:",null,null,"Holmfirth and Heckmondwike",0,0,0,0,0,null,"Negative"]
["Residents across Kirklees? (i.e. most/all local people)",null,null,"Neutral",0,0,0,0,0,null,"Very Negative"]
["Existing service users?",null,null,"Negative",0,0,0,-1,0,null,"Not Known"]
["Each of the following protected characteristic groups?",null,null,"Please select from drop down"]
["(Think about how your proposal might affect, either positively or negatively, any individuals/communities. Please consider the impact for both employees and residents - within these protected characteristic groups)."]
[null,"…age","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Negative",0,0,0,-1,0]
[null,null,"The largest percentage of Markets customers are older people who have the lowest access to their own transport and so like to shop locally.  Older people in Holmfirth will be affected by the closure of the market there."]
[null,"…disability","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Neutral",0,0,0,0,0]
[]
[null,"…gender reassignment","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Neutral",0,0,0,0,0]
[]
[null,"…marriage/ civil partnership","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Neutral",0,0,0,0,0]
[]
[null,"…pregnancy & maternity","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Neutral",0,0,0,0,0]
[]
[null,"…race","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Neutral",0,0,0,0,0]
[]
[null,"…religion &  belief","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Neutral",0,0,0,0,0]
[]
[null,"…sex","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Neutral",0,0,0,0,0]
[]
[null,"…sexual orientation","What impact is there on Kirklees employees/internal working practices?","Neutral",0,0,0,0,0]
[]
[null,null,"What impact is there on Kirklees residents/external service delivery?","Neutral",0,0,0,0,0]
[null,null,null,null,{"$f":"SUM(E3:E44)","v":0},{"$f":"SUM(F3:F44)","v":0},{"$f":"SUM(G3:G44)","v":0},{"$f":"SUM(H3:H44)","v":-3},{"$f":"SUM(I3:I44)","v":0},"Totals"]
[]
[null,null,null,null,null,null,"Page Total",null,{"$f":"SUM(E45:I45)","v":-3}]

{"sheet":"SECTION 3","index":4,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,5,0],[1,0,1,1],[0,0,0,1],[6,0,6,2],[14,4,14,5],[9,0,9,1],[10,0,10,1],[8,0,8,1],[7,0,7,2]]}
["3) HOW ARE YOU USING ADVICE AND EVIDENCE/INTELLIGENCE TO HELP YOU?",null,"Please select YES or NO"]
["Have you taken any specialist advice linked to your proposal? (Legal, HR etc)?",null,"NO",{"$f":"IF($C2<>\"YES\",0,2)","v":0},{"$f":"IF($C2<>\"NO\",0,-2)","v":-2},null,null,"YES"]
["Do you have any evidence/intelligence to support your assessment (in section 2) of the impact of your proposal on…","…employees?","NO",{"$f":"IF(C3<>\"YES\",0,2)","v":0},{"$f":"IF($C3<>\"NO\",0,-2)","v":-2},null,null,"NO"]
[null,"…Kirklees residents?","NO",{"$f":"IF(C4<>\"YES\",0,2)","v":0},-2]
[null,"…service users?","YES",{"$f":"IF(C5<>\"YES\",0,2)","v":2},0]
[null,"…any protected characteristic groups?","NO",{"$f":"IF(C6<>\"YES\",0,2)","v":0},-2]
["Please list your evidence/intelligence here [you can include hyperlinks to files/research/websites]: \n\nWe hold information about the traders at Heckmondwike and Holmfirth Markets who will be displaced.\n\n\n\n\n\n\n"]
[null,null,null,{"$f":"SUM(D2:D6)","v":2},{"$f":"SUM(E2:E6)","v":-8},"Totals"]
[null,null,"Please select from drop down"]
["To what extent do you feel you are able to mitigate any potential negative impact of your proposal on the different groups of people outlined in section 2?",null,"FULLY",{"$f":"IF(C10<>\"FULLY\",0,2)","v":2},{"$f":"IF($C10<>\"TO SOME EXTENT\",0,0)","v":0},{"$f":"IF($C10<>\"NOT AT ALL\",0,-2)","v":0},null,"FULLY"]
["To what extent do you feel you have considered your Public Sector Equality Duty?",null,"FULLY",{"$f":"IF(C11<>\"FULLY\",0,2)","v":2},{"$f":"IF($C11<>\"TO SOME EXTENT\",0,0)","v":0},{"$f":"IF($C11<>\"NOT AT ALL\",0,-2)","v":0},null,"TO SOME EXTENT"]
[null,null,null,{"$f":"SUM(D10:D11)","v":4},{"$f":"SUM(E10:E11)","v":0},{"$f":"SUM(F10:F11)","v":0},"Totals ","NOT AT ALL"]
[]
[]
[null,null,null,null,"Page total ",null,{"$f":"SUM(D8,E8,D12,E12,F12)","v":-2}]

{"sheet":"FINAL SCORE","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,5,3,5],[2,3,2,4],[8,0,8,1],[9,0,9,1]]}
["STAGE 1 ASSESSMENT"]
[]
["IMPACT","RISK"]
["Based on scoring of ","Based on scoring of "]
["1) and 2)","2) and 3)"]
[{"$f":"'SECTION 1'!J9+'SECTION 2'!I47","v":-5},{"$f":"'SECTION 2'!I47+'SECTION 3'!G15","v":-5}]
["SCORE (calculated)","SCORE (calculated)"]
["Max = - / + 32","Max risk = - / + 40"]
["You need to move on to complete a Stage 2 assessment if:"]
["The final Impact score is negative and or the Risk score is negative."]