{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","SIA Scoping Worksheet ","Categories of impacts","Characteristics of impacts","Dimensions of  impacts","Social impact assessment levels"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":26,"comments":6,"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":"Instructions","index":0,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["SIA Scoping Worksheet- Instructions"]
["This worksheet is to guide you through considering the various activities of your project and the likely impacts they will have on people and guide you in the level of assessment for each impact during the SIA. It can be used to plan how you will investigate each impact and to think about early refinements or mitigations that can be planned for."]
["SCOPE SOCIAL IMPACTS"]
["Project Activities "]
["Identify specific project activities that could have social impacts. For example, an activity might be ‘drilling during construction’, or ‘transport of materials and goods to/from site’. Ensure to consider all project phases and aspects of the project such as construction and operational workforces, and operational users."]
[]
["Categories of impacts "]
["Use the categories of social impact as a framework to consider whether the project activities are likely to cause positive or negative impacts, either directly or indirectly. Use additional rows if the project activity is likely to cause impacts in multiple categories. You can refer to the Categories of impacts tab (click this cell)."]
[]
["Potential impacts on people"]
["Describe the way people are likely to experience the impact. If different stakeholder groups are likely to experience impacts differently, use additional lines to describe them. The Characteristics of impacts tab may be useful for this (click this cell)."]
[]
["Impacted people "]
["Provide a brief description of who is likely to be impacted (e.g. nearby residents, businesses). This can assist in thinking about how different people experience impacts and lead to identifying other impacts, and guiding how you plan your SIA investigation.  "]
[]
["Cumulative impacts "]
["Consider if combined or cumulative impacts are relevant for this specific social impact. Project impacts that occur in combination with other projects are considered cumulative. Combined impacts refer to the combined effect of different impacts from the one project."]
[]
["Dimensions of impacts "]
["Consider at a preliminary level whether social impacts (without mitigation/enhancement) are likely to be significant having regard to the extent of people affected, duration of impacts, intensity/scale of impacts, sensitivity of the people affected, and their level of concern or interest. You can refer to the Dimensions of impacts tab (click this cell)."]
[]
["Managed by other disciplines "]
["This aspect allows for the consideration of likely mitigation measures from other disciplines influencing social impacts. This is to support proportionality. For example, where a construction noise management plan will be developed and implemented, it supports the SIA scoping to consider the social impact of the likely residual environmental impact, rather than the premitigation impact which would not be realistic. Options are;"]
["Yes - fully if the  social impact will likely be fully managed by other management measures."]
["Yes - partly the social impact will likely be somewhat reduced by other management measures, however residual social impacts remain."]
["No if the  social impact will not managed by other management measures. "]
["Unknown if it is unknown whether other management measures are likely"]
[]
["Assessment levels for each social impact "]
["The worksheet will auto-fill based on previous responses and suggest a level of assessment for each impact. This is a recommendation and you should consider each project impact on its merits and propose a higher or lower level of assessment that can be justified. The worksheet will also outline what types of data are expected for the level of assessment. You can refer to the Social impact assessment levels tab (click this cell)."]
["PLAN YOUR SOCIAL IMPACT ASSESSMENT"]
["Data collection plan"]
["Drawing on your scoping and level of assessment, consider and describe the methods will you use to investigate this impact for example, what data you will rely on and how you expect to collect it.  "]
[]
["Project refinements "]
["SIA scoping can present opportunities for early project refinement for better social outcomes. Explore opportunities for these and document them here."]
[]
["Initial mitigation or enhancement plans"]
["Early identification of  mitigation/enhancement measures is encouraged during SIA scoping. Consider and describe any of these measures here."]

{"sheet":"SIA Scoping Worksheet ","index":1,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,14,4,14],[3,15,4,15],[1,14,1,16],[3,16,4,16],[3,11,4,11],[1,0,1,13],[2,12,2,13],[2,2,2,4],[2,6,2,10],[3,0,4,0],[3,1,4,1],[3,4,4,4],[3,5,4,5],[3,6,3,10],[3,3,4,3],[3,12,4,12],[3,13,4,13],[0,5,0,11]]}
["Social Impact Assessment (SIA) Scoping Worksheet",null,null,"Project name: ",null,null,null,null,null,null,null,null,"Date: ",{"$f":"TODAY()","v":"2025-07-07"}]
["SCOPE SOCIAL IMPACTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"PLAN YOUR SIA"]
["PROJECT ACTIVITIES","CATEGORY OF SOCIAL IMPACT","LIKELY IMPACTS ON PEOPLE",null,null,"COMBINED AND CUMULATIVE IMPACTS","DIMENSIONS OF IMPACT",null,null,null,null,"MANAGEMENT BY OTHER TECHNICAL DISCIPLINES","ASSESSMENT LEVEL FOR EACH IMPACT*",null,"Data collection plan","Opportunities for, or refinements to date?","Initial mitigation or enhancement plans?"]
["Which project activity / activities could produce social impacts?","Which social impact categories could be affected by the project activities","\n\nHow is this impact likely to be experienced by people? \n\n\n","Who is likely to be impacted?","Is the impact  positive or negative\n\n","Will this impact combine with others  from this project, and/or have cumulative impacts with other projects?","Is this dimension significant for  the social impact?  ",null,null,null,null,"Is there another technical discipline (i.e. not the SIA) that will likely manage some of this social impact?","Level of assessment for each social impact","Indicative data requirements","What data and methods will you use to investigate this impact?","Have you identified or adopted any refinements to reduce social impacts?","What mitigation / enhancement measures are being considered?"]
[null,null,"Use additional rows if different people are likely to experience the impact differently ",null,null,null,"extent ","duration ","intensity","sensitivity ","level of concern/interest "]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(G6:K6, \"YES\")>=2, L6=\"No\", E6=\"Negative\"), \"Detailed\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")>=2, L6=\"Yes - partly\", E6=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")>=2, L6=\"Yes - partly\", E6=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")>=2, L6=\"Yes - fully\", E6=\"Positive\"), \"Minor\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")>=2, L6=\"Yes - fully\", E6=\"Negative\"), \"Minor\",\n    IF(AND(COUNTIF(G6:K6, \"?\")>=2, L6=\"No\", E6=\"Positive\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G6:K6, \"?\")>=2, L6=\"Yes - partly\", E6=\"Positive\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G6:K6, \"?\")>=2, L6=\"Yes - fully\", E6=\"Positive\"), \"Minor - unknown\",\n    IF(AND(COUNTIF(G6:K6, \"?\")>=2, L6=\"No\", E6=\"Negative\"), \"Detailed - unknown\",\n    IF(AND(COUNTIF(G6:K6, \"?\")>=2, L6=\"Yes - partly\", E6=\"Negative\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G6:K6, \"?\")>=2, L6=\"Yes - fully\", E6=\"Negative\"), \"Minor - unknown\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")>=2, L6=\"No\", E6=\"Positive\"), \"Standard\",\n\n    IF(AND(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"No\", E6=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"No\", E6=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"Yes - partly\", E6=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"Yes - partly\", E6=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"Yes - fully\", E6=\"Positive\"), \"Minor\",\n    IF(AND(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"Yes - fully\", E6=\"Negative\"), \"Minor\",\n    IF(AND(COUNTIF(G6:K6, \"No\")>4, L6=\"No\", E6=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G6:K6, \"No\")>4, L6=\"No\", E6=\"Negative\"), \"Not relevant\",\n    IF(AND(COUNTIF(G6:K6, \"No\")>4, L6=\"Yes - partly\", E6=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G6:K6, \"No\")>4, L6=\"Yes - partly\", E6=\"Negative\"), \"Not relevant\",\n    IF(AND(COUNTIF(G6:K6, \"No\")>4, L6=\"Yes - fully\", E6=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G6:K6, \"No\")>4, L6=\"Yes - fully\", E6=\"Positive\"), \"Not relevant\",\n\n\n    IF(OR(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"No\", E6=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"No\", E6=\"Negative\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"Yes - partly\", E6=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"Yes - partly\", E6=\"Negative\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"Yes - fully\", E6=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G6:K6, \"YES\")=1, COUNTIF(G6:K6, \"?\")=1, L6=\"Yes - fully\", E6=\"Negative\"), \"Not Relevant\",\n\n    \" \"))))))))))))))))))))))))))))))","v":" "},{"$f":"IF(M6 =\"Minor\",\"Secondary data + limited engagement (if required)\",\nIF(M6 =\"Minor - unknown\",\"Secondary data + limited engagement (if required)\",\nIF(M6=\"Standard\",\"Secondary data + targeted engagement + potentially targeted research\",\nIF(M6=\"Detailed\", \"Secondary data + detailed engagement + targeted research\",\nIF(M6=\"Detailed - unknown\",\"Secondary data + detailed engagement + targeted research\",\nIF(M6=\"Standard - unknown\",\"Secondary data + targeted engagement + potentially targeted research\",\" \"))))))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(G7:K7, \"YES\")>=2, L7=\"No\", E7=\"Negative\"), \"Detailed\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")>=2, L7=\"Yes - partly\", E7=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")>=2, L7=\"Yes - partly\", E7=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")>=2, L7=\"Yes - fully\", E7=\"Positive\"), \"Minor\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")>=2, L7=\"Yes - fully\", E7=\"Negative\"), \"Minor\",\n    IF(AND(COUNTIF(G7:K7, \"?\")>=2, L7=\"No\", E7=\"Positive\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G7:K7, \"?\")>=2, L7=\"Yes - partly\", E7=\"Positive\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G7:K7, \"?\")>=2, L7=\"Yes - fully\", E7=\"Positive\"), \"Minor - unknown\",\n    IF(AND(COUNTIF(G7:K7, \"?\")>=2, L7=\"No\", E7=\"Negative\"), \"Detailed - unknown\",\n    IF(AND(COUNTIF(G7:K7, \"?\")>=2, L7=\"Yes - partly\", E7=\"Negative\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G7:K7, \"?\")>=2, L7=\"Yes - fully\", E7=\"Negative\"), \"Minor - unknown\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")>=2, L7=\"No\", E7=\"Positive\"), \"Standard\",\n\n    IF(AND(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"No\", E7=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"No\", E7=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"Yes - partly\", E7=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"Yes - partly\", E7=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"Yes - fully\", E7=\"Positive\"), \"Minor\",\n    IF(AND(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"Yes - fully\", E7=\"Negative\"), \"Minor\",\n    IF(AND(COUNTIF(G7:K7, \"No\")>4, L7=\"No\", E7=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G7:K7, \"No\")>4, L7=\"No\", E7=\"Negative\"), \"Not relevant\",\n    IF(AND(COUNTIF(G7:K7, \"No\")>4, L7=\"Yes - partly\", E7=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G7:K7, \"No\")>4, L7=\"Yes - partly\", E7=\"Negative\"), \"Not relevant\",\n    IF(AND(COUNTIF(G7:K7, \"No\")>4, L7=\"Yes - fully\", E7=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G7:K7, \"No\")>4, L7=\"Yes - fully\", E7=\"Positive\"), \"Not relevant\",\n\n\n    IF(OR(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"No\", E7=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"No\", E7=\"Negative\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"Yes - partly\", E7=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"Yes - partly\", E7=\"Negative\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"Yes - fully\", E7=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G7:K7, \"YES\")=1, COUNTIF(G7:K7, \"?\")=1, L7=\"Yes - fully\", E7=\"Negative\"), \"Not Relevant\",\n\n    \" \"))))))))))))))))))))))))))))))","v":" "},{"$f":"IF(M7 =\"Minor\",\"Secondary data + limited engagement (if required)\",\nIF(M7 =\"Minor - unknown\",\"Secondary data + limited engagement (if required)\",\nIF(M7=\"Standard\",\"Secondary data + targeted engagement + potentially targeted research\",\nIF(M7=\"Detailed\", \"Secondary data + detailed engagement + targeted research\",\nIF(M7=\"Detailed - unknown\",\"Secondary data + detailed engagement + targeted research\",\nIF(M7=\"Standard - unknown\",\"Secondary data + targeted engagement + potentially targeted research\",\" \"))))))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"IF(M11 =\"Minor\",\"Secondary data + limited engagement (if required)\",\nIF(M11 =\"Minor - unknown\",\"Secondary data + limited engagement (if required)\",\nIF(M11=\"Standard\",\"Secondary data + targeted engagement + potentially targeted research\",\nIF(M11=\"Detailed\", \"Secondary data + detailed engagement + targeted research\",\nIF(M11=\"Detailed - unknown\",\"Secondary data + detailed engagement + targeted research\",\nIF(M11=\"Standard - unknown\",\"Secondary data + targeted engagement + potentially targeted research\",\" \"))))))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(G39:K39, \"YES\")>=2, L39=\"No\", E39=\"Negative\"), \"Detailed\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")>=2, L39=\"Yes - partly\", E39=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")>=2, L39=\"Yes - partly\", E39=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")>=2, L39=\"Yes - fully\", E39=\"Positive\"), \"Minor\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")>=2, L39=\"Yes - fully\", E39=\"Negative\"), \"Minor\",\n    IF(AND(COUNTIF(G39:K39, \"?\")>=2, L39=\"No\", E39=\"Positive\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G39:K39, \"?\")>=2, L39=\"Yes - partly\", E39=\"Positive\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G39:K39, \"?\")>=2, L39=\"Yes - fully\", E39=\"Positive\"), \"Minor - unknown\",\n    IF(AND(COUNTIF(G39:K39, \"?\")>=2, L39=\"No\", E39=\"Negative\"), \"Detailed - unknown\",\n    IF(AND(COUNTIF(G39:K39, \"?\")>=2, L39=\"Yes - partly\", E39=\"Negative\"), \"Standard - unknown\",\n    IF(AND(COUNTIF(G39:K39, \"?\")>=2, L39=\"Yes - fully\", E39=\"Negative\"), \"Minor - unknown\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")>=2, L39=\"No\", E39=\"Positive\"), \"Standard\",\n\n    IF(AND(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"No\", E39=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"No\", E39=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"Yes - partly\", E39=\"Positive\"), \"Standard\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"Yes - partly\", E39=\"Negative\"), \"Standard\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"Yes - fully\", E39=\"Positive\"), \"Minor\",\n    IF(AND(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"Yes - fully\", E39=\"Negative\"), \"Minor\",\n    IF(AND(COUNTIF(G39:K39, \"No\")>4, L39=\"No\", E39=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G39:K39, \"No\")>4, L39=\"No\", E39=\"Negative\"), \"Not relevant\",\n    IF(AND(COUNTIF(G39:K39, \"No\")>4, L39=\"Yes - partly\", E39=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G39:K39, \"No\")>4, L39=\"Yes - partly\", E39=\"Negative\"), \"Not relevant\",\n    IF(AND(COUNTIF(G39:K39, \"No\")>4, L39=\"Yes - fully\", E39=\"Positive\"), \"Not relevant\",\n    IF(AND(COUNTIF(G39:K39, \"No\")>4, L39=\"Yes - fully\", E39=\"Positive\"), \"Not relevant\",\n\n\n    IF(OR(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"No\", E39=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"No\", E39=\"Negative\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"Yes - partly\", E39=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"Yes - partly\", E39=\"Negative\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"Yes - fully\", E39=\"Positive\"), \"Not Relevant\",\n    IF(OR(COUNTIF(G39:K39, \"YES\")=1, COUNTIF(G39:K39, \"?\")=1, L39=\"Yes - fully\", E39=\"Negative\"), \"Not Relevant\",\n\n    \" \"))))))))))))))))))))))))))))))","v":" "}," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,"* If the recommended level of assessment includes an 'unknown', research these aspects first to establish the level of assessment to undertake"]

{"sheet":"Categories of impacts","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,8,0],[12,0,12,3],[9,0,9,3],[10,0,10,3],[11,0,11,3]]}
["CATEGORIES",null,"MEANING FOR WORKSHEET PURPOSE",{"$f":"UPPER(\"Further explanation and examples\")","v":"FURTHER EXPLANATION AND EXAMPLES"}]
["SOCIAL IMPACTS","way of life","including how people live, how they\nget around, how they work, how they play, and how they interact each day","Impacts on people's daily routines caused by construction activities and/or operational arrangements. Impacts on people's commuting/travelling times, their experience of travel, and their ability to move around freely. Impacts on people's experience of privacy, peace, and quiet enjoyment, especially if affected by increased noise. Impacts on people's general experience of life in their community, especially if the project might cause a 'tipping point' of cumulative impacts on their lives, e.g. through property acquisitions, severance of communities, or major disruption during construction. "]
[null,"community"," including composition, cohesion, character, how the community functions, resilience, and people’s sense of place","Composition - impacts on demographic characteristics and community structure. Can be changed by in-migration and out-migration over time, including the presence of newcomers and loss of longer term residents or sections of the community. Also inflow/outflow of temporary residents, e.g. during construction. \nCharacter - impacts on a community's shared identity and attributes, and natural and built features that people value. Can be affected by changes to buildings, vegetation, landscapes, land uses/industries, or land ownership and management.\nCohesion and function - impacts on social connections, interrelationships, networks and interactions, trust and cooperation, participation in community activities and institutions, and the potential for harmony or conflict. Lack of cohesion can result in social dislocation, alienation, division, dispossession, tensions, impoverishment, and crime.\nSense of place - impacts on feelings of belonging in a place, or identity with a place, which may derive from cultural or historical connections."]
[null,"accessibility","how people access and use infrastructure, services and facilities, whether provided by a public, private, or not-forprofit organisation","Impacts on how people use  roads and other access routes; severance, restrictions, and/or improvements in access. Impacts of project (including project-related transport) on pedestrian routes and people's access to schools, medical services, community services, and businesses. Impacts on capacity of services to respond to in-migrating residents."]
[null,"culture","both Aboriginal and non-Aboriginal, including shared beliefs, customs, practices, obligations, values and stories, and connections to Country, land, waterways, places and buildings","Impacts on people’s values, customs, and beliefs associated with (or embedded in) the site or locality, e.g. as secondary effects of changes to scenic quality, landforms, or water flows. Strengthening of community values and culture through project design elements. \n\nFor Aboriginal cultural heritage, also consider potential for intangible harm through ‘cultural or spiritual loss’ (i.e., loss or diminution of traditional attachment to the land or connection to country, or loss of rights to gain spiritual sustenance from the land)."]
[null,"health and wellbeing","physical and mental health[1],  especially for people vulnerable to social exclusion or substantial change, psychological stress resulting from financial or other pressures, access to open space and effects on public health ","Health impacts, and well-founded concerns/fears about health impacts, associated with noise, dust, odour, vibration, lighting, and toxic materials. Stress, anxiety, and uncertainty - or hopes - about a proposal, about changes to adjacent uses, and about cumulative change to a neighbourhood. Psychological stress and fears/hopes for the future. Potential impact of the project on social behaviours such as alcohol/drug use, domestic or other violence. Impacts of project elements on ability to sleep, people's general health and wellbeing, and overall community health."]
[null,"surroundings","access to, and use of, services that ecosystems provide[2], such as shade, pollution control, erosion control, public safety and security, access to and use of the natural and built environment, and amenity aesthetic value and amenity[3] ","Impacts on anything provided by the environment and that is useful for people, e.g. food and clean water supply, flood or fire defences. Impacts on safety of pedestrians, children, drivers, and cyclists. Impacts on levels of crime and violence, perceptions of crime, safety, and security, especially for women. Loss or enhancement of public spaces. Impacts on the perceived quality and uses of a natural or built area. Impacts on the valued features, the soundscape, and aesthetics of a place and how people use or appreciate it. "]
[null,"livelihoods"," including people’s capacity to sustain themselves through employment or business","Impacts on people’s livelihoods, e.g. from new employment and business opportunities (positive), or from disruption during construction (negative). \nFor Aboriginal people, rights to land and to gain spiritual and cultural sustenance from the land. "]
[null,"decision-making systems","including the extent to which people can have a say in decisions that affect their lives, and have access to complaint, remedy and grievance mechanisms.","Capacity of affected people to influence project decisions, including elements of project design. Extent to which they can navigate large amounts of technical material and make informed decisions. Effectiveness of engagement mechanisms at enabling all groups (especially vulnerable or marginalised groups) to participate in the assessment process. Levels of trust in the rigour and impartiality of the assessment process. Extent to which people feel empowered to determine their futures, including after a project closes. Opportunities for people to have a say in the project's community investment decisions. Accessibility and effectiveness of complaint and remedy procedures."]
["[1] The World Health Organization defines health as a state of complete physical, mental and social wellbeing and not merely the absence of disease or infirmity. For this guideline, wellbeing is a state in which people have their basic needs met, can realise their potential, can cope with the normal stresses of life, can work productively and fruitfully, and can participate in their community. See: Smyth, E. and Vanclay, F. (2017). The Social Framework for Projects: a conceptual but practical model to assist in assessing, planning and managing the social impacts of projects. Impact Assessment and Project Appraisal, 35:1, p. 78; Schirmer, J., et al. (2016), Wellbeing, resilience and liveability in rural and regional Australia: The 2015 Regional Wellbeing Survey, University of Canberra, p. 23; and OECD. (2011). How’s life?: measuring well-being. OECD Publishing, p. 18: http://dx.doi.org/10.1787/9789264121164-en."]
["[2] “Ecosystem services” include: provisioning services, such as food and water; regulating services, such as flood and disease control; supporting services, such as nutrient cycling, that maintain the conditions for life on Earth; and cultural services, such as spiritual, recreational, and cultural benefits. See: Millennium Ecosystem Assessment (2005). Ecosystems and Human Well-Being: Our Human Planet: Summary for Decision Makers. The Millennium Ecosystem Assessment Series, Volume 5, Island Press, Washington DC. "]
["[3] When considering perceptions of adverse impacts on amenity, an evaluation must be made of the reasonableness of those perceptions. This evaluation involves ‘the identification of evidence that can be objectively assessed to ascertain whether it supports a factual finding of an adverse effect on amenity…’: Telstra Corporation Ltd v Hornsby Shire Council [2006] NSWLEC 133"]

{"sheet":"Characteristics of impacts","index":3,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,0,35,0],[1,0,5,0],[6,0,9,0],[10,0,13,0],[14,0,21,0],[22,0,29,0]]}
["CATEGORIES","EXAMPLES"]
["A social impact may be physically observable or it may manifest as rational or justified fears (of negative impacts in the future) or aspirations (of positive impacts in the future). ","Physically observable impacts "]
[null,"More paths and cycleways "]
[null,"Acquisition of residential properties  "]
[null,"Rational or justified fears "]
[null,"Psychological stress regarding the future personal and community impacts of compulsory property acquisition "]
["A social impact may be experienced positively by some people, and negatively by others. ","Positive "]
[null,"Improved livelihoods owing to more work opportunities "]
[null,"Negative "]
[null,"Increased prevalence of adverse health conditions "]
["A social impact may be tangible or intangible. ","Tangible "]
[null,"Availability of affordable housing "]
[null,"Intangible "]
[null,"Community cohesion  "]
["Social impacts may be direct or indirect. They may also combine with other impacts from a single project or be cumulative with impacts from other projects. ","Direct   "]
[null,"Sleep disturbance caused by construction noise "]
[null,"Indirect  "]
[null,"Strain on family relations and health from sleep disturbance caused by construction noise "]
[null,"Combined "]
[null,"Sleep disturbance due to increased noise and restricted access because of significantly reduced street parking caused by a single project  "]
[null,"Cumulative  "]
[null,"Sleep disturbance due to increased noise and restricted access because of significantly reduced street parking from one project. In addition, poor air quality creating health conditions and strained family relations from another project "]
["A social impact may be best assessed using quantitative methods or qualitative methods.  ","Directly quantitative "]
[null,"Changes in population demographics "]
[null,"Partially/indirectly quantitative  "]
[null,"Incidence of voluntary work among a community as a proxy indicator of community cohesion "]
[null,"Qualitative (measurable through perception surveys or oral story telling, for example) "]
[null,"Cultural values  "]
[null,"Sense of place "]
[null,"Connection to Country "]
["A social impact may be experienced differently within a community, by different communities, and at different times/stages of the project. ","Different experiences within a community  "]
[null,"An increase in the value/cost of housing may be positive for homeowners wanting to rent out or sell their properties, but negative for individuals and families wanting to buy or rent. "]
[null,"Different experiences for different communities "]
[null,"People living near a project may experience most of the noise and dust impacts, while people in the region’s nearest town may benefit from most of the job opportunities. "]
[null,"Different experiences over time "]
[null,"People’s experiences of impacts during project construction may be quite negative, whereas experiences during operation may be more positive. "]

{"sheet":"Dimensions of  impacts","index":4,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,5,0]]}
["DIMENSIONS",null,"DETAILS NEEDED TO ENABLE ASSESSMENT"]
["Magnitude","Extent","Who specifically is expected to be affected (directly, indirectly, and/or cumulatively), including any vulnerable people? Which location(s) and people are affected? (e.g. near neighbours, local, regional, future generations)."]
[null,"Duration","When is the social impact expected to occur? Will it be time-limited (e.g. over particular project phases) or permanent?"]
[null,"Intensity or scale","What is the likely scale or degree of change? (e.g. mild, moderate, severe)"]
[null,"Sensitivity or importance","How sensitive/vulnerable (or how adaptable/resilient) are affected people to the impact, or (for positive impacts) how important is it to them? This might depend on the value they attach to the matter; whether it is rare/unique or replaceable; the extent to which it is tied to their identity; and their capacity to cope with or adapt to change."]
[null,"Level of concern/interest","How concerned/interested are people? Sometimes, concerns may be disproportionate to findings from technical assessments of likelihood, duration and/or intensity."]

{"sheet":"Social impact assessment levels","index":5,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,4,0]]}
["LEVEL",null,"MEANING FOR WORKSHEET PURPOSE"]
["LEVEL OF ASSESSMENT FOR EACH SOCIAL IMPACT","Detailed assessment","The project may result in a significant negative social impact, including cumulative impacts "]
[null,"Standard assessment","The project may result in a moderate social impact, including cumulative impacts "]
[null,"Minor assessment","The impact is considered minor. "]
[null,"Not relevant","Where potential social impacts are immaterial and do not warrant assessment."]