{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Calculator","index":0,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[[20,0,20,2],[5,0,5,1]]}
["Calculating greenhouse gas emissions from companies"]
[]
["1. Select the approach to be used for calculating the company's emissions"]
["2. Enter the average % shareholding in the company in the reporting year"]
[]
["3. Enter the Scope 1 and Scope 2, and Scope 3 (if this is to be included) OR Total emissions data, obtained from annual reports or data aggregators, for the reporting year"]
["Scope 1"]
["Scope 2"]
["Scope 3"]
["OR ","OR "]
["Total"]
[]
["4. Select the units in which the above emissions are reported"]
[]
[{"$f":"CONCATENATE(\"5. Result: Emissions from the company that should be reported as a contribution to the portfolio's Scope 3 emissions (\",B13,\")\")","v":"5. Result: Emissions from the company that should be reported as a contribution to the portfolio's Scope 3 emissions ()"},{"$f":"IF(AND(SUM(B7,B8,B9)>0,B11>0),\"Enter either Scope 1 and 2 OR total, not both\",(B11+B9+B8+B7)*B4)","v":0}]
[]
["3. Enter the currency used in the EEIO"]
["4. Select the emissions units used in the EEIO"]
[{"$f":"CONCATENATE(\"5. Enter the revenue for the company  (\",B17,\")\")","v":"5. Enter the revenue for the company  ()"}]
[]
["6. Enter the sectors in which the reporting company is active, the share of revenue that the company receives from that sector, as well as the relevant sectoral emission factor extracted from the EEIO "]
[]
["Sector ","Share of revenue from sector (%) ",{"$f":"CONCATENATE(\"Emission factor from EEIO (\",B18,\"/\",B17,\")\")","v":"Emission factor from EEIO (/)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"5. Result: Emissions from the company that should be reported as a contribution to the portfolio's Scope 3 emissions (\",B18,\")\")","v":"5. Result: Emissions from the company that should be reported as a contribution to the portfolio's Scope 3 emissions ()"},{"$f":"SUMPRODUCT(C24:C31,B24:B31)*B19*B4","v":0}]
[]
[]
["3. Enter the metric to be used for normalisation (e.g. employees, revenue, market capitalisation)"]
[{"$f":"IF(B36=\"\",\"\",CONCATENATE(\"4. Enter the \",B36,\" for the company of interest\"))","v":""}]
["5. Select the emissions units "]
[]
["6. Enter similar company's data"]
["Company name ",{"$f":"IF(B36=\"\",\"\",B36)","v":""},{"$f":"CONCATENATE(\"Total GHG Emissions (\",B38,\")\")","v":"Total GHG Emissions ()"},{"$f":"CONCATENATE(\"Emissions intensity (\",B38,\"/\",B41,\")\")","v":"Emissions intensity (/)"}]
[null,null,null,{"$f":"IF(B42=\"\",\"\",C42/B42)","v":""}]
[null,null,null,{"$f":"IF(B43=\"\",\"\",C43/B43)","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[]
[{"$f":"CONCATENATE(\"7. Result: Emissions from the company that should be reported as a contribution to the portfolio's Scope 3 emissions (\",B38,\")\")","v":"7. Result: Emissions from the company that should be reported as a contribution to the portfolio's Scope 3 emissions ()"},{"$f":"IFERROR(AVERAGE(D42:D48)*B37*B4,0)","v":0}]

{"sheet":"Lists","index":1,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Types of tools"]
["Please select"]
["Investment-specific method"]
["Average data method"]
["Similar company method"]
[]
[]
["Units"]
["kg CO2e"]
["tonnes CO2e"]
["kilotonne CO2e"]
["megatonne CO2e"]