{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Info","Paris Compliance Test - SDA","Calculations","Metric 3","Benchmarks","Dropdown lists"],"not_rendered":{"charts":4,"images":3,"macros":1,"external_links":0,"defined_names":21,"comments":3,"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":"Info","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["General","In our Nature Communication publication (https://www.nature.com/articles/s41467-022-31143-4) (open access) we propose several compliance conditions and operational requirements to assess the Paris Compliance of a company, using a strict science-based approach, which are displayed on the right. This tool applies these conditions and requirements using the Sectoral Decarbonisation Approach and the IEA B2DS pathway. "]
["Data Required","To conduct the test, the following company data is required;\n- Location (OECD/Non-OECD/World)\n- Emissions (scope 1, in tCO2) since 2014 \n- Activity/Output since 2014. \nIf you do not have data since 2014, you could estimate this data instead. "]
["Maximum Action Scenario","In our Nature Communication publication, we used a \"Maximum Action Scenario\" for projecting the emissions and activity of Australian Electric Utilities. We assumed the fossil fuel assets of a company would close at the date submitted to the NEM (downloaded May 2022), the company would maintain a constant market share, and would replace their fossil fuel assets with zero carbon assets to maintain this market share. To conduct a similar analysis, you would have to compute the expected emissions for every year and enter them manually. We will include a calculation tool for this in future versions of the tool."]
["OECD countries","AUSTRALIA, AUSTRIA, BELGIUM, CANADA, CHILE, COLOMBIA, COSTA RICA, CZECH REPUBLIC, DENMARK, ESTONIA, FINLAND, FRANCE, GERMANY, GREECE, HUNGARY, ICELAND, IRELAND, ISRAEL, ITALY, JAPAN, KOREA, LATVIA, LITHUANIA, LUXEMBOURG, MEXICO, NETHERLANDS, NEW ZEALAND, NORWAY, POLAND, PORTUGAL, SLOVAK REPUBLIC, SLOVENIA, SPAIN, SWEDEN, SWITZERLAND, TURKEY, UNITED KINGDOM, UNITED STATES"]

{"sheet":"Paris Compliance Test - SDA","index":1,"n_rows":39,"n_cols":50,"rows_kept":39,"cut":false,"hidden":false,"merged":[[23,13,23,14],[7,1,7,2],[34,1,34,2],[23,11,23,12],[25,11,25,12]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Step 1: Complete the following items -> "]
[null,"COMPANY INFORMATION"]
[null,"Company Name (optional)"]
[null,"Date (optional)"]
[null,"Sector","<Please Select>"]
[null,"BENCHMARK"]
[null,"Benchmark Decarbonisation Pathway","<Please Select>"]
[null,"Region","<Please Select>"]
[null,"ACTUAL DATA"]
[null,"I have actual data (activity and emissions) until","<Please select>"]
[null,"PROJECTED DATA"]
[null,"Projected from",{"$f":"IF(C17=\"<Please select>\",\"Do not enter data here\", C17+1)","v":"Do not enter data here"}]
[null,"Activity Projection","<Please Select>"]
[null,"Carbon Emissions/Intensity Projection","<Please Select>"]
[]
[]
[]
[]
[]
[null,null,"Step 2: Input data -> ",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060]
[null,null,{"$f":"\"Activity (\" & VLOOKUP(C12, Sector_Units, 3, FALSE) & \")\"","v":"Activity ()"}]
[null,null,"Scope 1 Emissions (tCO2)"]
[]
[]
[null,null,"Step 3 results are automatically calculated, except for metric 3. Click on the button on the right to calculate. "]
[]
[]
[null,"Step 3: Your Results!"]
[null,"Metric 1: Performance to Date",{"$f":"Metric1","v":{"$error":"#N/A"}}]
[null,"Metric 2a: Estimated Year to Finish",{"$f":"Metric2A","v":{"$error":"#NUM!"}}]
[null,"Metric 3a: Re-alignment rate (constant acceleration)",{"$f":"IF(Sector=\"<Please select>\", 0, IF(Sector=\"Power Generation\", Metric3A, MetricA_Other))","v":0}]
[null,"Metric 3b: Re-alignment rate (Delayed Action)",{"$f":"IF(Sector=\"<Please select>\", 0, IF(Sector=\"Power Generation\", Metric3B, MetricB_Other))","v":0}]

{"sheet":"Calculations","index":2,"n_rows":111,"n_cols":49,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Year",null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060]
["Input Data","Unit"]
["Annual Activity",{"$f":"VLOOKUP(Sector, UnitLookup, 3, FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(C6<(ActualData_End+1), 'Paris Compliance Test - SDA'!D28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(D6<(ActualData_End+1), 'Paris Compliance Test - SDA'!E28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(E6<(ActualData_End+1), 'Paris Compliance Test - SDA'!F28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F6<(ActualData_End+1), 'Paris Compliance Test - SDA'!G28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(G6<(ActualData_End+1), 'Paris Compliance Test - SDA'!H28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H6<(ActualData_End+1), 'Paris Compliance Test - SDA'!I28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(I6<(ActualData_End+1), 'Paris Compliance Test - SDA'!J28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(J6<(ActualData_End+1), 'Paris Compliance Test - SDA'!K28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K6<(ActualData_End+1), 'Paris Compliance Test - SDA'!L28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(L6<(ActualData_End+1), 'Paris Compliance Test - SDA'!M28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(M6<(ActualData_End+1), 'Paris Compliance Test - SDA'!N28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(N6<(ActualData_End+1), 'Paris Compliance Test - SDA'!O28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(O6<(ActualData_End+1), 'Paris Compliance Test - SDA'!P28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(P6<(ActualData_End+1), 'Paris Compliance Test - SDA'!Q28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q6<(ActualData_End+1), 'Paris Compliance Test - SDA'!R28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R6<(ActualData_End+1), 'Paris Compliance Test - SDA'!S28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S6<(ActualData_End+1), 'Paris Compliance Test - SDA'!T28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T6<(ActualData_End+1), 'Paris Compliance Test - SDA'!U28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U6<(ActualData_End+1), 'Paris Compliance Test - SDA'!V28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V6<(ActualData_End+1), 'Paris Compliance Test - SDA'!W28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W6<(ActualData_End+1), 'Paris Compliance Test - SDA'!X28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X6<(ActualData_End+1), 'Paris Compliance Test - SDA'!Y28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y6<(ActualData_End+1), 'Paris Compliance Test - SDA'!Z28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Z6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AA28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AA6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AB28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AB6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AC28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AD28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AD6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AE28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AE6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AF28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AF6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AG28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AH28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AH6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AI28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AI6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AJ28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AK28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AK6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AL28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AL6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AM28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AM6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AN28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AN6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AO28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AO6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AP28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AP6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AQ28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AR28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AR6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AS28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AS6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AT28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AT6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AU28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AU6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AV28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AV6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AW28, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AW6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AX28, 0)","v":{"$error":"#VALUE!"}}]
["Annual Scope 1","tCO2",{"$f":"IF(C6<(ActualData_End+1), 'Paris Compliance Test - SDA'!D29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(D6<(ActualData_End+1), 'Paris Compliance Test - SDA'!E29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(E6<(ActualData_End+1), 'Paris Compliance Test - SDA'!F29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F6<(ActualData_End+1), 'Paris Compliance Test - SDA'!G29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(G6<(ActualData_End+1), 'Paris Compliance Test - SDA'!H29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H6<(ActualData_End+1), 'Paris Compliance Test - SDA'!I29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(I6<(ActualData_End+1), 'Paris Compliance Test - SDA'!J29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(J6<(ActualData_End+1), 'Paris Compliance Test - SDA'!K29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K6<(ActualData_End+1), 'Paris Compliance Test - SDA'!L29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(L6<(ActualData_End+1), 'Paris Compliance Test - SDA'!M29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(M6<(ActualData_End+1), 'Paris Compliance Test - SDA'!N29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(N6<(ActualData_End+1), 'Paris Compliance Test - SDA'!O29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(O6<(ActualData_End+1), 'Paris Compliance Test - SDA'!P29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(P6<(ActualData_End+1), 'Paris Compliance Test - SDA'!Q29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q6<(ActualData_End+1), 'Paris Compliance Test - SDA'!R29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R6<(ActualData_End+1), 'Paris Compliance Test - SDA'!S29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S6<(ActualData_End+1), 'Paris Compliance Test - SDA'!T29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T6<(ActualData_End+1), 'Paris Compliance Test - SDA'!U29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U6<(ActualData_End+1), 'Paris Compliance Test - SDA'!V29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V6<(ActualData_End+1), 'Paris Compliance Test - SDA'!W29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W6<(ActualData_End+1), 'Paris Compliance Test - SDA'!X29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X6<(ActualData_End+1), 'Paris Compliance Test - SDA'!Y29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y6<(ActualData_End+1), 'Paris Compliance Test - SDA'!Z29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Z6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AA29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AA6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AB29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AB6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AC29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AD29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AD6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AE29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AE6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AF29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AF6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AG29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AH29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AH6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AI29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AI6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AJ29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AK29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AK6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AL29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AL6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AM29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AM6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AN29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AN6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AO29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AO6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AP29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AP6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AQ29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AR29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AR6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AS29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AS6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AT29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AT6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AU29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AU6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AV29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AV6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AW29, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AW6<(ActualData_End+1), 'Paris Compliance Test - SDA'!AX29, 0)","v":{"$error":"#VALUE!"}}]
["Sector Intensity IEA - B2DS (ETP 2017)",{"$f":"VLOOKUP(Sector,UnitLookup, 2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(C6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(D6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(E6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(F6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(G6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(H6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(I6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(J6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(K6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(L6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(M6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(N6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(O6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(P6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(Q6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(R6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(S6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(T6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(U6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(V6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(W6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(X6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(Y6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(Z6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AA6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AB6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AC6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AD6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AE6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AF6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AG6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AH6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AI6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AJ6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AK6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AL6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AM6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AN6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AO6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AP6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AQ6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AR6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AS6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AT6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AU6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AV6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$2:$N$19,MATCH(1,(Benchmarks!$A$2:$A$19=Sector)*(Benchmarks!$E$2:$E$19=Region),0),MATCH(AW6,Benchmarks!$F$1:$N$1,0)),0)","v":0}]
["Sector Annual Activity - IEA B2DS (for region selected)",{"$f":"VLOOKUP(Sector,UnitLookup, 4,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(C6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(D6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(E6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(F6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(G6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(H6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(I6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(J6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(K6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(L6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(M6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(N6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(O6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(P6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(Q6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(R6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(S6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(T6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(U6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(V6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(W6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(X6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(Y6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(Z6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AA6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AB6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AC6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AD6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AE6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AF6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AG6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AH6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AI6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AJ6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AK6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AL6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AM6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AN6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AO6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AP6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AQ6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AR6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AS6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AT6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AU6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AV6,Benchmarks!$F$1:$N$1,0)),0)","v":0},{"$f":"IFERROR(INDEX(Benchmarks!$F$65:$N$103,MATCH(1,(Benchmarks!$A$65:$A$103=Sector)*(Benchmarks!$E$65:$E$103=Region),0),MATCH(AW6,Benchmarks!$F$1:$N$1,0)),0)","v":0}]
[]
["Calculated From IEA ETP inputs"]
["Sector Intensity IEA - B2DS (ETP 2017)",{"$f":"VLOOKUP(Sector,UnitLookup, 2,FALSE)","v":{"$error":"#N/A"}},{"$f":"Base_SI","v":0},{"$f":"Base_SI+($N$10-Base_SI)/($N$6-$C$6)","v":0},{"$f":"D14+($N$10-Base_SI)/($N$6-$C$6)","v":0},0,0,0,0,0,0,0,0,{"$f":"N10","v":0},{"$f":"N14+($S$10-$N$10)/5","v":0},{"$f":"O14+($S$10-$N$10)/5","v":0},0,0,0,{"$f":"S14+($X$10-$S$10)/5","v":0},{"$f":"T14+($X$10-$S$10)/5","v":0},0,0,0,{"$f":"X14+($AC$10-$X$10)/5","v":0},{"$f":"Y14+($AC$10-$X$10)/5","v":0},0,0,0,{"$f":"AC14+($AH$10-$AC$10)/5","v":0},{"$f":"AD14+($AH$10-$AC$10)/5","v":0},0,0,0,{"$f":"AH14+($AM$10-$AH$10)/5","v":0},{"$f":"AI14+($AM$10-$AH$10)/5","v":0},0,{"$f":"AK14+($AM$10-$AH$10)/5","v":0},{"$f":"AL14+($AM$10-$AH$10)/5","v":0},{"$f":"AM14+($AR$10-$AM$10)/5","v":0},{"$f":"AN14+($AR$10-$AM$10)/5","v":0},0,0,0,{"$f":"AR14+($AW$10-$AR$10)/5","v":0},{"$f":"AS14+($AW$10-$AR$10)/5","v":0},0,0,0]
["Sector Annual Activity - IEA B2DS",{"$f":"VLOOKUP(Sector,UnitLookup, 4,FALSE)","v":{"$error":"#N/A"}},{"$f":"C11","v":0},{"$f":"C15+($N$11-$C$11)/($N$6-$C$6)","v":0},{"$f":"D15+($N$11-$C$11)/($N$6-$C$6)","v":0},0,0,0,0,0,0,0,0,{"$f":"N11","v":0},{"$f":"N15+($S$11-$N$11)/5","v":0},{"$f":"O15+($S$11-$N$11)/5","v":0},0,0,0,{"$f":"S15+($X$11-$S$11)/5","v":0},{"$f":"T15+($X$11-$S$11)/5","v":0},0,0,0,{"$f":"X15+($AC$11-$X$11)/5","v":0},{"$f":"Y15+($AC$11-$X$11)/5","v":0},0,0,0,{"$f":"AC15+($AH$11-$AC$11)/5","v":0},{"$f":"AD15+($AH$11-$AC$11)/5","v":0},0,0,0,{"$f":"AH15+($AM$11-$AH$11)/5","v":0},{"$f":"AI15+($AM$11-$AH$11)/5","v":0},0,0,0,{"$f":"AM15+($AR$11-$AM$11)/5","v":0},{"$f":"AN15+($AR$11-$AM$11)/5","v":0},0,0,0,{"$f":"AR15+($AW$11-$AR$11)/5","v":0},{"$f":"AS15+($AW$11-$AR$11)/5","v":0},0,0,0]
["Sector Annual Activity - IEA B2DS  Annual growth",{"$f":"VLOOKUP(Sector,UnitLookup, 4,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"(D15/C15)-1","v":{"$error":"#DIV/0!"}},{"$f":"(E15/D15)-1","v":{"$error":"#DIV/0!"}},{"$f":"(F15/E15)-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Calculated Company specific"]
["CO2 intensity - Actual",null,{"$f":"IFERROR(C9/C8, 0)","v":0},{"$f":"IFERROR(D9/D8, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(E9/E8, NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Cumulative Emissions - Actual (tCO2)",null,{"$f":"C9","v":{"$error":"#VALUE!"}},{"$f":"IF(D6<(ActualData_End+1), D9+C20, NA())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Paris Compliant Pathway Calculations"]
["Actual"]
["d (constant)",null,{"$f":"Base_CI-End_SI","v":0}]
["p",null,{"$f":"(C10-End_SI)/(Base_SI-End_SI)","v":{"$error":"#DIV/0!"}},{"$f":"(D14-End_SI)/(Base_SI-End_SI)","v":{"$error":"#DIV/0!"}},{"$f":"(E14-End_SI)/(Base_SI-End_SI)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"(J14-End_SI)/(Base_SI-End_SI)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["m",null,{"$f":"IFERROR((Base_CA/1000/Base_SA)/(C8/1000/C15), 0)","v":0},{"$f":"IFERROR((Base_CA/1000/Base_SA)/(D8/1000/D15), 0)","v":0},{"$f":"IFERROR((Base_CA/1000/Base_SA)/(E8/1000/E15), 0)","v":0},0,0,0,0,{"$f":"IFERROR((Base_CA/1000/Base_SA)/(J8/1000/J15), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["PCP -  Intensity",{"$f":"VLOOKUP(Sector,UnitLookup, 2,FALSE)","v":{"$error":"#N/A"}},{"$f":"Base_CI","v":0},{"$f":"IF(D26>0, $C$24*D25*D26+End_SI, NA())","v":{"$error":"#N/A"}},{"$f":"IF(E26>0, $C$24*E25*E26+End_SI, NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["PCP (tCO2e) - Annual Emissions","tCO2",{"$f":"IF(C6<=ActualData_End, C28*C8, 0)","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["PCP (tCO2e) - Cumulative Emissions","tCO2",{"$f":"C29","v":{"$error":"#VALUE!"}},{"$f":"IF(D6<(ActualData_End+1),D29+C30,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(E6<(ActualData_End+1),E29+D30,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Projected"]
["Carbon Intensity growth (based on past 3 years, geometric average)",null,{"$f":"IFERROR((INDEX(C19:AW19, 1, MATCH(ActualData_End, Calculations!C6:AW6))/INDEX(C19:AW19, 1, (MATCH(ActualData_End, Calculations!C6:AW6)-3)))^(1/3)-1, 0)","v":0}]
["Carbon Intensity growth (based on past 5 years, geometric average)",null,{"$f":"IFERROR((INDEX(C19:AW19, 1, MATCH(ActualData_End, Calculations!C6:AW6))/(INDEX(C19:AW19, 1, (MATCH(ActualData_End, Calculations!C6:AW6)-5))))^(1/5)-1, 0)","v":0}]
[]
["m",null,{"$f":"IF(C6=(ActualData_End),C26, IF(C6>(ActualData_End),IF(A36>1, 1, A36), 0))","v":0},{"$f":"IF(D6=(ActualData_End),D26, IF(D6>(ActualData_End),IF(C36>1, 1, C36), 0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CO2 intensity - Projected (based on selection in \"Paris Compliance Test\")",{"$f":"VLOOKUP(Sector,UnitLookup, 2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(C6=ActualData_End,C19,IF(C6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,A37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,A37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!D29/'Paris Compliance Test - SDA'!D28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(D6=ActualData_End,D19,IF(D6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,C37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,C37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!E29/'Paris Compliance Test - SDA'!E28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(E6=ActualData_End,E19,IF(E6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,D37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,D37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!F29/'Paris Compliance Test - SDA'!F28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(F6=ActualData_End,F19,IF(F6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,E37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,E37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!G29/'Paris Compliance Test - SDA'!G28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(G6=ActualData_End,G19,IF(G6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,F37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,F37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!H29/'Paris Compliance Test - SDA'!H28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(H6=ActualData_End,H19,IF(H6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,G37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,G37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!I29/'Paris Compliance Test - SDA'!I28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(I6=ActualData_End,I19,IF(I6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,H37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,H37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!J29/'Paris Compliance Test - SDA'!J28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(J6=ActualData_End,J19,IF(J6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,I37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,I37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!K29/'Paris Compliance Test - SDA'!K28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(K6=ActualData_End,K19,IF(K6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,J37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,J37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!L29/'Paris Compliance Test - SDA'!L28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(L6=ActualData_End,L19,IF(L6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,K37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,K37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!M29/'Paris Compliance Test - SDA'!M28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(M6=ActualData_End,M19,IF(M6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,L37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,L37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!N29/'Paris Compliance Test - SDA'!N28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(N6=ActualData_End,N19,IF(N6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,M37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,M37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!O29/'Paris Compliance Test - SDA'!O28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(O6=ActualData_End,O19,IF(O6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,N37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,N37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!P29/'Paris Compliance Test - SDA'!P28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(P6=ActualData_End,P19,IF(P6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,O37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,O37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!Q29/'Paris Compliance Test - SDA'!Q28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(Q6=ActualData_End,Q19,IF(Q6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,P37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,P37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!R29/'Paris Compliance Test - SDA'!R28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(R6=ActualData_End,R19,IF(R6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,Q37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,Q37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!S29/'Paris Compliance Test - SDA'!S28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(S6=ActualData_End,S19,IF(S6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,R37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,R37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!T29/'Paris Compliance Test - SDA'!T28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(T6=ActualData_End,T19,IF(T6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,S37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,S37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!U29/'Paris Compliance Test - SDA'!U28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(U6=ActualData_End,U19,IF(U6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,T37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,T37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!V29/'Paris Compliance Test - SDA'!V28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(V6=ActualData_End,V19,IF(V6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,U37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,U37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!W29/'Paris Compliance Test - SDA'!W28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(W6=ActualData_End,W19,IF(W6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,V37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,V37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!X29/'Paris Compliance Test - SDA'!X28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(X6=ActualData_End,X19,IF(X6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,W37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,W37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!Y29/'Paris Compliance Test - SDA'!Y28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(Y6=ActualData_End,Y19,IF(Y6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,X37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,X37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!Z29/'Paris Compliance Test - SDA'!Z28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(Z6=ActualData_End,Z19,IF(Z6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,Y37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,Y37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AA29/'Paris Compliance Test - SDA'!AA28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AA6=ActualData_End,AA19,IF(AA6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,Z37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,Z37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AB29/'Paris Compliance Test - SDA'!AB28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AB6=ActualData_End,AB19,IF(AB6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AA37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AA37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AC29/'Paris Compliance Test - SDA'!AC28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AC6=ActualData_End,AC19,IF(AC6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AB37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AB37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AD29/'Paris Compliance Test - SDA'!AD28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AD6=ActualData_End,AD19,IF(AD6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AC37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AC37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AE29/'Paris Compliance Test - SDA'!AE28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AE6=ActualData_End,AE19,IF(AE6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AD37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AD37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AF29/'Paris Compliance Test - SDA'!AF28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF6=ActualData_End,AF19,IF(AF6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AE37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AE37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AG29/'Paris Compliance Test - SDA'!AG28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AG6=ActualData_End,AG19,IF(AG6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AF37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AF37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AH29/'Paris Compliance Test - SDA'!AH28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AH6=ActualData_End,AH19,IF(AH6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AG37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AG37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AI29/'Paris Compliance Test - SDA'!AI28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AI6=ActualData_End,AI19,IF(AI6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AH37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AH37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AJ29/'Paris Compliance Test - SDA'!AJ28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ6=ActualData_End,AJ19,IF(AJ6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AI37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AI37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AK29/'Paris Compliance Test - SDA'!AK28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AK6=ActualData_End,AK19,IF(AK6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AJ37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AJ37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AL29/'Paris Compliance Test - SDA'!AL28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AL6=ActualData_End,AL19,IF(AL6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AK37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AK37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AM29/'Paris Compliance Test - SDA'!AM28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AM6=ActualData_End,AM19,IF(AM6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AL37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AL37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AN29/'Paris Compliance Test - SDA'!AN28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AN6=ActualData_End,AN19,IF(AN6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AM37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AM37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AO29/'Paris Compliance Test - SDA'!AO28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AO6=ActualData_End,AO19,IF(AO6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AN37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AN37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AP29/'Paris Compliance Test - SDA'!AP28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AP6=ActualData_End,AP19,IF(AP6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AO37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AO37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AQ29/'Paris Compliance Test - SDA'!AQ28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ6=ActualData_End,AQ19,IF(AQ6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AP37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AP37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AR29/'Paris Compliance Test - SDA'!AR28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AR6=ActualData_End,AR19,IF(AR6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AQ37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AQ37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AS29/'Paris Compliance Test - SDA'!AS28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AS6=ActualData_End,AS19,IF(AS6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AR37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AR37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AT29/'Paris Compliance Test - SDA'!AT28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AT6=ActualData_End,AT19,IF(AT6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AS37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AS37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AU29/'Paris Compliance Test - SDA'!AU28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AU6=ActualData_End,AU19,IF(AU6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AT37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AT37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AV29/'Paris Compliance Test - SDA'!AV28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AV6=ActualData_End,AV19,IF(AV6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AU37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AU37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AW29/'Paris Compliance Test - SDA'!AW28,0))),NA()))","v":{"$error":"#VALUE!"}},{"$f":"IF(AW6=ActualData_End,AW19,IF(AW6>(ActualData_End-1),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$16,AV37*(1+$C$33),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$17,AV37*(1+$C$34),IF('Paris Compliance Test - SDA'!$C$21='Dropdown lists'!$A$18, 'Paris Compliance Test - SDA'!AX29/'Paris Compliance Test - SDA'!AX28,0))),NA()))","v":{"$error":"#VALUE!"}}]
["Annual Activity - Projected Constant Market share (region selected. or activity manually entered)","tCement",{"$f":"IF(C6=ActualData_End+1,(1+C16)*A8, IF(C6>ActualData_End,(1+C16)*A38,0))","v":{"$error":"#VALUE!"}},{"$f":"IF(D6=ActualData_End+1,(1+D16)*C8, IF(D6>ActualData_End,(1+D16)*C38,0))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(I6=ActualData_End+1,(1+I16)*H8, IF(I6>ActualData_End,(1+I16)*H38,0))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["PCP - Intensity (using fixed market share, capped at m=1)","tCO2/tCement",{"$f":"_xlfn.IFNA(IF(ActualData_End=C6,$C$24*C25*C26+End_SI,IF(ActualData_End<Calculations!C6,$C$24*C25*C36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=D6,$C$24*D25*D26+End_SI,IF(ActualData_End<Calculations!D6,$C$24*D25*D36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=E6,$C$24*E25*E26+End_SI,IF(ActualData_End<Calculations!E6,$C$24*E25*E36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=F6,$C$24*F25*F26+End_SI,IF(ActualData_End<Calculations!F6,$C$24*F25*F36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=G6,$C$24*G25*G26+End_SI,IF(ActualData_End<Calculations!G6,$C$24*G25*G36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=H6,$C$24*H25*H26+End_SI,IF(ActualData_End<Calculations!H6,$C$24*H25*H36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=I6,$C$24*I25*I26+End_SI,IF(ActualData_End<Calculations!I6,$C$24*I25*I36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=J6,$C$24*J25*J26+End_SI,IF(ActualData_End<Calculations!J6,$C$24*J25*J36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=K6,$C$24*K25*K26+End_SI,IF(ActualData_End<Calculations!K6,$C$24*K25*K36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=L6,$C$24*L25*L26+End_SI,IF(ActualData_End<Calculations!L6,$C$24*L25*L36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=M6,$C$24*M25*M26+End_SI,IF(ActualData_End<Calculations!M6,$C$24*M25*M36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=N6,$C$24*N25*N26+End_SI,IF(ActualData_End<Calculations!N6,$C$24*N25*N36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=O6,$C$24*O25*O26+End_SI,IF(ActualData_End<Calculations!O6,$C$24*O25*O36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=P6,$C$24*P25*P26+End_SI,IF(ActualData_End<Calculations!P6,$C$24*P25*P36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=Q6,$C$24*Q25*Q26+End_SI,IF(ActualData_End<Calculations!Q6,$C$24*Q25*Q36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=R6,$C$24*R25*R26+End_SI,IF(ActualData_End<Calculations!R6,$C$24*R25*R36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=S6,$C$24*S25*S26+End_SI,IF(ActualData_End<Calculations!S6,$C$24*S25*S36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=T6,$C$24*T25*T26+End_SI,IF(ActualData_End<Calculations!T6,$C$24*T25*T36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=U6,$C$24*U25*U26+End_SI,IF(ActualData_End<Calculations!U6,$C$24*U25*U36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=V6,$C$24*V25*V26+End_SI,IF(ActualData_End<Calculations!V6,$C$24*V25*V36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=W6,$C$24*W25*W26+End_SI,IF(ActualData_End<Calculations!W6,$C$24*W25*W36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=X6,$C$24*X25*X26+End_SI,IF(ActualData_End<Calculations!X6,$C$24*X25*X36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=Y6,$C$24*Y25*Y26+End_SI,IF(ActualData_End<Calculations!Y6,$C$24*Y25*Y36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=Z6,$C$24*Z25*Z26+End_SI,IF(ActualData_End<Calculations!Z6,$C$24*Z25*Z36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AA6,$C$24*AA25*AA26+End_SI,IF(ActualData_End<Calculations!AA6,$C$24*AA25*AA36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AB6,$C$24*AB25*AB26+End_SI,IF(ActualData_End<Calculations!AB6,$C$24*AB25*AB36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AC6,$C$24*AC25*AC26+End_SI,IF(ActualData_End<Calculations!AC6,$C$24*AC25*AC36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AD6,$C$24*AD25*AD26+End_SI,IF(ActualData_End<Calculations!AD6,$C$24*AD25*AD36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AE6,$C$24*AE25*AE26+End_SI,IF(ActualData_End<Calculations!AE6,$C$24*AE25*AE36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AF6,$C$24*AF25*AF26+End_SI,IF(ActualData_End<Calculations!AF6,$C$24*AF25*AF36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AG6,$C$24*AG25*AG26+End_SI,IF(ActualData_End<Calculations!AG6,$C$24*AG25*AG36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AH6,$C$24*AH25*AH26+End_SI,IF(ActualData_End<Calculations!AH6,$C$24*AH25*AH36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AI6,$C$24*AI25*AI26+End_SI,IF(ActualData_End<Calculations!AI6,$C$24*AI25*AI36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AJ6,$C$24*AJ25*AJ26+End_SI,IF(ActualData_End<Calculations!AJ6,$C$24*AJ25*AJ36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AK6,$C$24*AK25*AK26+End_SI,IF(ActualData_End<Calculations!AK6,$C$24*AK25*AK36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AL6,$C$24*AL25*AL26+End_SI,IF(ActualData_End<Calculations!AL6,$C$24*AL25*AL36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AM6,$C$24*AM25*AM26+End_SI,IF(ActualData_End<Calculations!AM6,$C$24*AM25*AM36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AN6,$C$24*AN25*AN26+End_SI,IF(ActualData_End<Calculations!AN6,$C$24*AN25*AN36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AO6,$C$24*AO25*AO26+End_SI,IF(ActualData_End<Calculations!AO6,$C$24*AO25*AO36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AP6,$C$24*AP25*AP26+End_SI,IF(ActualData_End<Calculations!AP6,$C$24*AP25*AP36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AQ6,$C$24*AQ25*AQ26+End_SI,IF(ActualData_End<Calculations!AQ6,$C$24*AQ25*AQ36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AR6,$C$24*AR25*AR26+End_SI,IF(ActualData_End<Calculations!AR6,$C$24*AR25*AR36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AS6,$C$24*AS25*AS26+End_SI,IF(ActualData_End<Calculations!AS6,$C$24*AS25*AS36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AT6,$C$24*AT25*AT26+End_SI,IF(ActualData_End<Calculations!AT6,$C$24*AT25*AT36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AU6,$C$24*AU25*AU26+End_SI,IF(ActualData_End<Calculations!AU6,$C$24*AU25*AU36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AV6,$C$24*AV25*AV26+End_SI,IF(ActualData_End<Calculations!AV6,$C$24*AV25*AV36+End_SI,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=AW6,$C$24*AW25*AW26+End_SI,IF(ActualData_End<Calculations!AW6,$C$24*AW25*AW36+End_SI,NA())), 0)","v":0}]
["PCP - Emissions","tCO2",{"$f":"C40*C38","v":{"$error":"#VALUE!"}},{"$f":"D40*D38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"M40*M38","v":{"$error":"#VALUE!"}},{"$f":"N40*N38","v":{"$error":"#VALUE!"}},{"$f":"O40*O38","v":{"$error":"#VALUE!"}},{"$f":"P40*P38","v":{"$error":"#VALUE!"}},{"$f":"Q40*Q38","v":{"$error":"#VALUE!"}},{"$f":"R40*R38","v":{"$error":"#VALUE!"}},{"$f":"S40*S38","v":{"$error":"#VALUE!"}},{"$f":"T40*T38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"V40*V38","v":{"$error":"#VALUE!"}},{"$f":"W40*W38","v":{"$error":"#VALUE!"}},{"$f":"X40*X38","v":{"$error":"#VALUE!"}},{"$f":"Y40*Y38","v":{"$error":"#VALUE!"}},{"$f":"Z40*Z38","v":{"$error":"#VALUE!"}},{"$f":"AA40*AA38","v":{"$error":"#VALUE!"}},{"$f":"AB40*AB38","v":{"$error":"#VALUE!"}},{"$f":"AC40*AC38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AE40*AE38","v":{"$error":"#VALUE!"}},{"$f":"AF40*AF38","v":{"$error":"#VALUE!"}},{"$f":"AG40*AG38","v":{"$error":"#VALUE!"}},{"$f":"AH40*AH38","v":{"$error":"#VALUE!"}},{"$f":"AI40*AI38","v":{"$error":"#VALUE!"}},{"$f":"AJ40*AJ38","v":{"$error":"#VALUE!"}},{"$f":"AK40*AK38","v":{"$error":"#VALUE!"}},{"$f":"AL40*AL38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AN40*AN38","v":{"$error":"#VALUE!"}},{"$f":"AO40*AO38","v":{"$error":"#VALUE!"}},{"$f":"AP40*AP38","v":{"$error":"#VALUE!"}},{"$f":"AQ40*AQ38","v":{"$error":"#VALUE!"}},{"$f":"AR40*AR38","v":{"$error":"#VALUE!"}},{"$f":"AS40*AS38","v":{"$error":"#VALUE!"}},{"$f":"AT40*AT38","v":{"$error":"#VALUE!"}},{"$f":"AU40*AU38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AW40*AW38","v":{"$error":"#VALUE!"}}]
["PCP - cumulative projected forward (base year 2014)","tCO2",{"$f":"_xlfn.IFNA(IF(ActualData_End=C6,C30,IF(ActualData_End<C6,A42+C41,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=D6,D30,IF(ActualData_End<D6,C42+D41,NA())), 0)","v":0},{"$f":"_xlfn.IFNA(IF(ActualData_End=E6,E30,IF(ActualData_End<E6,D42+E41,NA())), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Carbon budget","tCO2",{"$f":"MAX(IF(NOT(ISNA($C$42:$AW$42)),$C$42:$AW$42)\n)","v":0}]
["Remaining Carbon budget (if followed PCP from Base year)","tCO2",{"$f":"C44-C29","v":{"$error":"#VALUE!"}},{"$f":"IF((ActualData_End+1)>D6, C45-D29, IF(ActualData_End<(D6), C45-D41, 0))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Actual Remaining Carbon budget (based on actual emissions)","tCO2",{"$f":"IF(C6<(ActualData_End+1), C44-C9, NA())","v":{"$error":"#VALUE!"}},{"$f":"IF(D6<(ActualData_End+1), C46-D9, NA())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(I6<(ActualData_End+1), H46-I9, NA())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["Year",null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060]
["Data for Figure: Cumulative Carbon Emissions"]
["Company emissions - Actual","tCO2",{"$f":"C20","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["PCPe - \"Base\" (AM)","tCO2",{"$f":"IF(C30>0, C30, NA())","v":{"$error":"#VALUE!"}},{"$f":"IF(D30>0, D30, NA())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(G30>0, G30, NA())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["PCPe - \"Base\" (PM)","tCO2",{"$f":"IF(C42>0, C42, NA())","v":{"$error":"#N/A"}},{"$f":"IF(D42>0, D42, NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(J42>0, J42, NA())","v":{"$error":"#N/A"}},{"$f":"IF(K42>0, K42, NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AW42>0, AW42, NA())","v":{"$error":"#N/A"}}]
["PCP Emissions -Realignment - constant acceleration","tCO2",{"$f":"IF(C49=(ActualData_End),C51,IF(C49>(ActualData_End),C64*C38+B54,NA()))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["PCPemissions - \"Re-alignment\" - delayed action","tCO2",{"$f":"IF(C49=(ActualData_End),C51,IF(C49>(ActualData_End),C65*C38+A55,NA()))","v":{"$error":"#N/A"}},{"$f":"IF(D49=(ActualData_End),D51,IF(D49>(ActualData_End),D65*D38+C55,NA()))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Company emissions - Projected","tCO2",{"$f":"IF(C49=(ActualData_End),C51,IF(C49>(ActualData_End),C37*C38+A56,NA()))","v":{"$error":"#N/A"}},{"$f":"IF(D49=(ActualData_End),D51,IF(D49>(ActualData_End),D37*D38+C56,NA()))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Carbon Budget","tCO2",{"$f":"$C$44","v":0},{"$f":"$C$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Metric 2A Calc",null,{"$f":"_xlfn.IFNA(IF(C57>C56, 0, C6), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Data for Figure: Carbon intensities (gCO2/kWh)"]
["Company Intensity - Actual","tCO2/tCement",{"$f":"C19","v":0},{"$f":"D19","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["PCPintensity - \"base\" (AM)","tCO2/tCement",{"$f":"C28","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["PCPintensity - \"base\" (PM)","tCO2/tCement",{"$f":"IF(C40>0, C40, NA())","v":{"$error":"#N/A"}},{"$f":"IF(D40>0, D40, NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["PCPintensity - \"Re-alignment\"- constant acceleration","tCO2/tCement",{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!B13, NA()), IFERROR('Metric 3'!B14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!C13, NA()), IFERROR('Metric 3'!C14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!D13, NA()), IFERROR('Metric 3'!D14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!E13, NA()), IFERROR('Metric 3'!E14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!F13, NA()), IFERROR('Metric 3'!F14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!G13, NA()), IFERROR('Metric 3'!G14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!H13, NA()), IFERROR('Metric 3'!H14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!I13, NA()), IFERROR('Metric 3'!I14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!J13, NA()), IFERROR('Metric 3'!J14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!K13, NA()), IFERROR('Metric 3'!K14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!L13, NA()), IFERROR('Metric 3'!L14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!M13, NA()), IFERROR('Metric 3'!M14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!N13, NA()), IFERROR('Metric 3'!N14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!O13, NA()), IFERROR('Metric 3'!O14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!P13, NA()), IFERROR('Metric 3'!P14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!Q13, NA()), IFERROR('Metric 3'!Q14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!R13, NA()), IFERROR('Metric 3'!R14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!S13, NA()), IFERROR('Metric 3'!S14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!T13, NA()), IFERROR('Metric 3'!T14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!U13, NA()), IFERROR('Metric 3'!U14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!V13, NA()), IFERROR('Metric 3'!V14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!W13, NA()), IFERROR('Metric 3'!W14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!X13, NA()), IFERROR('Metric 3'!X14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!Y13, NA()), IFERROR('Metric 3'!Y14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!Z13, NA()), IFERROR('Metric 3'!Z14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AA13, NA()), IFERROR('Metric 3'!AA14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AB13, NA()), IFERROR('Metric 3'!AB14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AC13, NA()), IFERROR('Metric 3'!AC14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AD13, NA()), IFERROR('Metric 3'!AD14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AE13, NA()), IFERROR('Metric 3'!AE14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AF13, NA()), IFERROR('Metric 3'!AF14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AG13, NA()), IFERROR('Metric 3'!AG14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AH13, NA()), IFERROR('Metric 3'!AH14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AI13, NA()), IFERROR('Metric 3'!AI14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AJ13, NA()), IFERROR('Metric 3'!AJ14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AK13, NA()), IFERROR('Metric 3'!AK14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AL13, NA()), IFERROR('Metric 3'!AL14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AM13, NA()), IFERROR('Metric 3'!AM14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AN13, NA()), IFERROR('Metric 3'!AN14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AO13, NA()), IFERROR('Metric 3'!AO14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AP13, NA()), IFERROR('Metric 3'!AP14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AQ13, NA()), IFERROR('Metric 3'!AQ14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AR13, NA()), IFERROR('Metric 3'!AR14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AS13, NA()), IFERROR('Metric 3'!AS14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AT13, NA()), IFERROR('Metric 3'!AT14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AU13, NA()), IFERROR('Metric 3'!AU14, NA()))","v":{"$error":"#N/A"}},{"$f":"IF(Sector=\"Power Generation\", IFERROR('Metric 3'!AV13, NA()), IFERROR('Metric 3'!AV14, NA()))","v":{"$error":"#N/A"}}]
["PCPintensity - \"Re-alignment\" - delayed action","tCO2/tCement",{"$f":"IF(C6<(ActualData_End+5),'Metric 3'!B22, IF(Sector=\"Power Generation\", 'Metric 3'!B31, 'Metric 3'!B32))","v":{"$error":"#VALUE!"}},{"$f":"IF(D6<(ActualData_End+5),'Metric 3'!C22, IF(Sector=\"Power Generation\", 'Metric 3'!C31, 'Metric 3'!C32))","v":{"$error":"#VALUE!"}},{"$f":"IF(E6<(ActualData_End+5),'Metric 3'!D22, IF(Sector=\"Power Generation\", 'Metric 3'!D31, 'Metric 3'!D32))","v":{"$error":"#VALUE!"}},{"$f":"IF(F6<(ActualData_End+5),'Metric 3'!E22, IF(Sector=\"Power Generation\", 'Metric 3'!E31, 'Metric 3'!E32))","v":{"$error":"#VALUE!"}},{"$f":"IF(G6<(ActualData_End+5),'Metric 3'!F22, IF(Sector=\"Power Generation\", 'Metric 3'!F31, 'Metric 3'!F32))","v":{"$error":"#VALUE!"}},{"$f":"IF(H6<(ActualData_End+5),'Metric 3'!G22, IF(Sector=\"Power Generation\", 'Metric 3'!G31, 'Metric 3'!G32))","v":{"$error":"#VALUE!"}},{"$f":"IF(I6<(ActualData_End+5),'Metric 3'!H22, IF(Sector=\"Power Generation\", 'Metric 3'!H31, 'Metric 3'!H32))","v":{"$error":"#VALUE!"}},{"$f":"IF(J6<(ActualData_End+5),'Metric 3'!I22, IF(Sector=\"Power Generation\", 'Metric 3'!I31, 'Metric 3'!I32))","v":{"$error":"#VALUE!"}},{"$f":"IF(K6<(ActualData_End+5),'Metric 3'!J22, IF(Sector=\"Power Generation\", 'Metric 3'!J31, 'Metric 3'!J32))","v":{"$error":"#VALUE!"}},{"$f":"IF(L6<(ActualData_End+5),'Metric 3'!K22, IF(Sector=\"Power Generation\", 'Metric 3'!K31, 'Metric 3'!K32))","v":{"$error":"#VALUE!"}},{"$f":"IF(M6<(ActualData_End+5),'Metric 3'!L22, IF(Sector=\"Power Generation\", 'Metric 3'!L31, 'Metric 3'!L32))","v":{"$error":"#VALUE!"}},{"$f":"IF(N6<(ActualData_End+5),'Metric 3'!M22, IF(Sector=\"Power Generation\", 'Metric 3'!M31, 'Metric 3'!M32))","v":{"$error":"#VALUE!"}},{"$f":"IF(O6<(ActualData_End+5),'Metric 3'!N22, IF(Sector=\"Power Generation\", 'Metric 3'!N31, 'Metric 3'!N32))","v":{"$error":"#VALUE!"}},{"$f":"IF(P6<(ActualData_End+5),'Metric 3'!O22, IF(Sector=\"Power Generation\", 'Metric 3'!O31, 'Metric 3'!O32))","v":{"$error":"#VALUE!"}},{"$f":"IF(Q6<(ActualData_End+5),'Metric 3'!P22, IF(Sector=\"Power Generation\", 'Metric 3'!P31, 'Metric 3'!P32))","v":{"$error":"#VALUE!"}},{"$f":"IF(R6<(ActualData_End+5),'Metric 3'!Q22, IF(Sector=\"Power Generation\", 'Metric 3'!Q31, 'Metric 3'!Q32))","v":{"$error":"#VALUE!"}},{"$f":"IF(S6<(ActualData_End+5),'Metric 3'!R22, IF(Sector=\"Power Generation\", 'Metric 3'!R31, 'Metric 3'!R32))","v":{"$error":"#VALUE!"}},{"$f":"IF(T6<(ActualData_End+5),'Metric 3'!S22, IF(Sector=\"Power Generation\", 'Metric 3'!S31, 'Metric 3'!S32))","v":{"$error":"#VALUE!"}},{"$f":"IF(U6<(ActualData_End+5),'Metric 3'!T22, IF(Sector=\"Power Generation\", 'Metric 3'!T31, 'Metric 3'!T32))","v":{"$error":"#VALUE!"}},{"$f":"IF(V6<(ActualData_End+5),'Metric 3'!U22, IF(Sector=\"Power Generation\", 'Metric 3'!U31, 'Metric 3'!U32))","v":{"$error":"#VALUE!"}},{"$f":"IF(W6<(ActualData_End+5),'Metric 3'!V22, IF(Sector=\"Power Generation\", 'Metric 3'!V31, 'Metric 3'!V32))","v":{"$error":"#VALUE!"}},{"$f":"IF(X6<(ActualData_End+5),'Metric 3'!W22, IF(Sector=\"Power Generation\", 'Metric 3'!W31, 'Metric 3'!W32))","v":{"$error":"#VALUE!"}},{"$f":"IF(Y6<(ActualData_End+5),'Metric 3'!X22, IF(Sector=\"Power Generation\", 'Metric 3'!X31, 'Metric 3'!X32))","v":{"$error":"#VALUE!"}},{"$f":"IF(Z6<(ActualData_End+5),'Metric 3'!Y22, IF(Sector=\"Power Generation\", 'Metric 3'!Y31, 'Metric 3'!Y32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AA6<(ActualData_End+5),'Metric 3'!Z22, IF(Sector=\"Power Generation\", 'Metric 3'!Z31, 'Metric 3'!Z32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AB6<(ActualData_End+5),'Metric 3'!AA22, IF(Sector=\"Power Generation\", 'Metric 3'!AA31, 'Metric 3'!AA32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AC6<(ActualData_End+5),'Metric 3'!AB22, IF(Sector=\"Power Generation\", 'Metric 3'!AB31, 'Metric 3'!AB32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AD6<(ActualData_End+5),'Metric 3'!AC22, IF(Sector=\"Power Generation\", 'Metric 3'!AC31, 'Metric 3'!AC32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AE6<(ActualData_End+5),'Metric 3'!AD22, IF(Sector=\"Power Generation\", 'Metric 3'!AD31, 'Metric 3'!AD32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF6<(ActualData_End+5),'Metric 3'!AE22, IF(Sector=\"Power Generation\", 'Metric 3'!AE31, 'Metric 3'!AE32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AG6<(ActualData_End+5),'Metric 3'!AF22, IF(Sector=\"Power Generation\", 'Metric 3'!AF31, 'Metric 3'!AF32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AH6<(ActualData_End+5),'Metric 3'!AG22, IF(Sector=\"Power Generation\", 'Metric 3'!AG31, 'Metric 3'!AG32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AI6<(ActualData_End+5),'Metric 3'!AH22, IF(Sector=\"Power Generation\", 'Metric 3'!AH31, 'Metric 3'!AH32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ6<(ActualData_End+5),'Metric 3'!AI22, IF(Sector=\"Power Generation\", 'Metric 3'!AI31, 'Metric 3'!AI32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AK6<(ActualData_End+5),'Metric 3'!AJ22, IF(Sector=\"Power Generation\", 'Metric 3'!AJ31, 'Metric 3'!AJ32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AL6<(ActualData_End+5),'Metric 3'!AK22, IF(Sector=\"Power Generation\", 'Metric 3'!AK31, 'Metric 3'!AK32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AM6<(ActualData_End+5),'Metric 3'!AL22, IF(Sector=\"Power Generation\", 'Metric 3'!AL31, 'Metric 3'!AL32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AN6<(ActualData_End+5),'Metric 3'!AM22, IF(Sector=\"Power Generation\", 'Metric 3'!AM31, 'Metric 3'!AM32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AO6<(ActualData_End+5),'Metric 3'!AN22, IF(Sector=\"Power Generation\", 'Metric 3'!AN31, 'Metric 3'!AN32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AP6<(ActualData_End+5),'Metric 3'!AO22, IF(Sector=\"Power Generation\", 'Metric 3'!AO31, 'Metric 3'!AO32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ6<(ActualData_End+5),'Metric 3'!AP22, IF(Sector=\"Power Generation\", 'Metric 3'!AP31, 'Metric 3'!AP32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AR6<(ActualData_End+5),'Metric 3'!AQ22, IF(Sector=\"Power Generation\", 'Metric 3'!AQ31, 'Metric 3'!AQ32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AS6<(ActualData_End+5),'Metric 3'!AR22, IF(Sector=\"Power Generation\", 'Metric 3'!AR31, 'Metric 3'!AR32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AT6<(ActualData_End+5),'Metric 3'!AS22, IF(Sector=\"Power Generation\", 'Metric 3'!AS31, 'Metric 3'!AS32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AU6<(ActualData_End+5),'Metric 3'!AT22, IF(Sector=\"Power Generation\", 'Metric 3'!AT31, 'Metric 3'!AT32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AV6<(ActualData_End+5),'Metric 3'!AU22, IF(Sector=\"Power Generation\", 'Metric 3'!AU31, 'Metric 3'!AU32))","v":{"$error":"#VALUE!"}},{"$f":"IF(AW6<(ActualData_End+5),'Metric 3'!AV22, IF(Sector=\"Power Generation\", 'Metric 3'!AV31, 'Metric 3'!AV32))","v":{"$error":"#VALUE!"}}]
[]
[]
["METRIC 1",null,{"$f":"INDEX(C51:AW51, 1, MATCH(ActualData_End, C49:AW49, 0))/INDEX(C52:AW52, 1, MATCH(ActualData_End, C49:AW49, 0))","v":{"$error":"#N/A"}}]
["Metric 2A",null,{"$f":"SMALL(C58:AW58,COUNTIF(C58:AW58,0)+1)","v":{"$error":"#NUM!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"#REF!/AN57","v":{"$error":"#REF!"}}]

{"sheet":"Metric 3","index":3,"n_rows":36,"n_cols":51,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Year",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060]
["Remaining Carbon Budget",{"$f":"INDEX(Calculations!C46:AW46, 1,MATCH(ActualData_End, Calculations!C6:AW6,0))","v":{"$error":"#N/A"}}]
["PCPintensity (base year 2014)",{"$f":"IF(B1<(ActualData_End+1), Calculations!C28, Calculations!C40)","v":{"$error":"#VALUE!"}},{"$f":"IF(C1<(ActualData_End+1), Calculations!D28, Calculations!D40)","v":{"$error":"#VALUE!"}},{"$f":"IF(D1<(ActualData_End+1), Calculations!E28, Calculations!E40)","v":{"$error":"#VALUE!"}},{"$f":"IF(E1<(ActualData_End+1), Calculations!F28, Calculations!F40)","v":{"$error":"#VALUE!"}},{"$f":"IF(F1<(ActualData_End+1), Calculations!G28, Calculations!G40)","v":{"$error":"#VALUE!"}},{"$f":"IF(G1<(ActualData_End+1), Calculations!H28, Calculations!H40)","v":{"$error":"#VALUE!"}},{"$f":"IF(H1<(ActualData_End+1), Calculations!I28, Calculations!I40)","v":{"$error":"#VALUE!"}},{"$f":"IF(I1<(ActualData_End+1), Calculations!J28, Calculations!J40)","v":{"$error":"#VALUE!"}},{"$f":"IF(J1<(ActualData_End+1), Calculations!K28, Calculations!K40)","v":{"$error":"#VALUE!"}},{"$f":"IF(K1<(ActualData_End+1), Calculations!L28, Calculations!L40)","v":{"$error":"#VALUE!"}},{"$f":"IF(L1<(ActualData_End+1), Calculations!M28, Calculations!M40)","v":{"$error":"#VALUE!"}},{"$f":"IF(M1<(ActualData_End+1), Calculations!N28, Calculations!N40)","v":{"$error":"#VALUE!"}},{"$f":"IF(N1<(ActualData_End+1), Calculations!O28, Calculations!O40)","v":{"$error":"#VALUE!"}},{"$f":"IF(O1<(ActualData_End+1), Calculations!P28, Calculations!P40)","v":{"$error":"#VALUE!"}},{"$f":"IF(P1<(ActualData_End+1), Calculations!Q28, Calculations!Q40)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q1<(ActualData_End+1), Calculations!R28, Calculations!R40)","v":{"$error":"#VALUE!"}},{"$f":"IF(R1<(ActualData_End+1), Calculations!S28, Calculations!S40)","v":{"$error":"#VALUE!"}},{"$f":"IF(S1<(ActualData_End+1), Calculations!T28, Calculations!T40)","v":{"$error":"#VALUE!"}},{"$f":"IF(T1<(ActualData_End+1), Calculations!U28, Calculations!U40)","v":{"$error":"#VALUE!"}},{"$f":"IF(U1<(ActualData_End+1), Calculations!V28, Calculations!V40)","v":{"$error":"#VALUE!"}},{"$f":"IF(V1<(ActualData_End+1), Calculations!W28, Calculations!W40)","v":{"$error":"#VALUE!"}},{"$f":"IF(W1<(ActualData_End+1), Calculations!X28, Calculations!X40)","v":{"$error":"#VALUE!"}},{"$f":"IF(X1<(ActualData_End+1), Calculations!Y28, Calculations!Y40)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y1<(ActualData_End+1), Calculations!Z28, Calculations!Z40)","v":{"$error":"#VALUE!"}},{"$f":"IF(Z1<(ActualData_End+1), Calculations!AA28, Calculations!AA40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AA1<(ActualData_End+1), Calculations!AB28, Calculations!AB40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AB1<(ActualData_End+1), Calculations!AC28, Calculations!AC40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC1<(ActualData_End+1), Calculations!AD28, Calculations!AD40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AD1<(ActualData_End+1), Calculations!AE28, Calculations!AE40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AE1<(ActualData_End+1), Calculations!AF28, Calculations!AF40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AF1<(ActualData_End+1), Calculations!AG28, Calculations!AG40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG1<(ActualData_End+1), Calculations!AH28, Calculations!AH40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AH1<(ActualData_End+1), Calculations!AI28, Calculations!AI40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AI1<(ActualData_End+1), Calculations!AJ28, Calculations!AJ40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ1<(ActualData_End+1), Calculations!AK28, Calculations!AK40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AK1<(ActualData_End+1), Calculations!AL28, Calculations!AL40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AL1<(ActualData_End+1), Calculations!AM28, Calculations!AM40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AM1<(ActualData_End+1), Calculations!AN28, Calculations!AN40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AN1<(ActualData_End+1), Calculations!AO28, Calculations!AO40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AO1<(ActualData_End+1), Calculations!AP28, Calculations!AP40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AP1<(ActualData_End+1), Calculations!AQ28, Calculations!AQ40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ1<(ActualData_End+1), Calculations!AR28, Calculations!AR40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AR1<(ActualData_End+1), Calculations!AS28, Calculations!AS40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AS1<(ActualData_End+1), Calculations!AT28, Calculations!AT40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AT1<(ActualData_End+1), Calculations!AU28, Calculations!AU40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AU1<(ActualData_End+1), Calculations!AV28, Calculations!AV40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AV1<(ActualData_End+1), Calculations!AW28, Calculations!AW40)","v":{"$error":"#VALUE!"}}]
["Annual Activity (MWh) Projected Constant Market share World",{"$f":"Calculations!C38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!D38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!E38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!F38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!G38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!H38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!I38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!J38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!K38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!L38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!M38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!N38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!O38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!P38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!Q38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!R38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!S38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!T38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!U38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!V38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!W38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!X38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!Y38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!Z38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AA38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AB38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AC38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AD38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AE38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AF38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AG38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AH38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AI38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AJ38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AK38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AL38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AM38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AN38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AO38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AP38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AQ38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AR38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AS38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AT38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AU38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AV38","v":{"$error":"#VALUE!"}},{"$f":"Calculations!AW38","v":{"$error":"#VALUE!"}}]
["Emissions (Using revised carbon intensity below - to solve) Power Generation",{"$f":"B13*B4","v":{"$error":"#VALUE!"}},{"$f":"C13*C4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"H13*H4","v":{"$error":"#VALUE!"}},{"$f":"I13*I4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"K13*K4","v":{"$error":"#VALUE!"}},{"$f":"L13*L4","v":{"$error":"#VALUE!"}},{"$f":"M13*M4","v":{"$error":"#VALUE!"}},{"$f":"N13*N4","v":{"$error":"#VALUE!"}},{"$f":"O13*O4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"Q13*Q4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"S13*S4","v":{"$error":"#VALUE!"}},{"$f":"T13*T4","v":{"$error":"#VALUE!"}},{"$f":"U13*U4","v":{"$error":"#VALUE!"}},{"$f":"V13*V4","v":{"$error":"#VALUE!"}},{"$f":"W13*W4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"Y13*Y4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AA13*AA4","v":{"$error":"#VALUE!"}},{"$f":"AB13*AB4","v":{"$error":"#VALUE!"}},{"$f":"AC13*AC4","v":{"$error":"#VALUE!"}},{"$f":"AD13*AD4","v":{"$error":"#VALUE!"}},{"$f":"AE13*AE4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AG13*AG4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AI13*AI4","v":{"$error":"#VALUE!"}},{"$f":"AJ13*AJ4","v":{"$error":"#VALUE!"}},{"$f":"AK13*AK4","v":{"$error":"#VALUE!"}},{"$f":"AL13*AL4","v":{"$error":"#VALUE!"}},{"$f":"AM13*AM4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AO13*AO4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AQ13*AQ4","v":{"$error":"#VALUE!"}},{"$f":"AR13*AR4","v":{"$error":"#VALUE!"}},{"$f":"AS13*AS4","v":{"$error":"#VALUE!"}},{"$f":"AT13*AT4","v":{"$error":"#VALUE!"}},{"$f":"AU13*AU4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Emissions (Using revised carbon intensity below - to solve) Other sectors",{"$f":"B14*B4","v":{"$error":"#VALUE!"}},{"$f":"C14*C4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Projected Cumulative Emissions (from last reported data year) Power Generation",{"$f":"IF(B1<(ActualData_End),0,IF(B1>(ActualData_End-1),B5+A7,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Projected Cumulative Emissions (from last reported data year) Other sectors",{"$f":"IF(B1<(ActualData_End),0,IF(B1>(ActualData_End-1),B6+A8,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($M$3/$H$3)^(1/($M$1-$H$1))-1","v":{"$error":"#VALUE!"}}]
["1yr annual growth (PCP)",{"$f":"IF(B1<(ActualData_End+1),0,B3/A3)","v":{"$error":"#VALUE!"}},{"$f":"IF(C1<(ActualData_End+1),0,C3/B3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["1yr decarb rate (PCP)",{"$f":"IF(B1<(ActualData_End+1), 0,(1-B10))","v":{"$error":"#VALUE!"}},{"$f":"IF(C1<(ActualData_End+1), 0,(1-C10))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(J1<(ActualData_End+1), 0,(1-J10))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(AM1<(ActualData_End+1), 0,(1-AM10))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Revised decarb (PCP re-alignment)",{"$f":"B10*($B$16)","v":{"$error":"#VALUE!"}},{"$f":"C10*($B$16)","v":{"$error":"#VALUE!"}},{"$f":"D10*($B$16)","v":{"$error":"#VALUE!"}},{"$f":"E10*($B$16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"H10*($B$16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"O10*($B$16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Revised Carbon Intensity (PCP re-alignment) Power Generation",{"$f":"IF(B1=(ActualData_End),Calculations!C19,IF(B1<2051,A13*(1-B11*$B$16),B3))","v":{"$error":"#VALUE!"}},{"$f":"IF(C1=(ActualData_End),Calculations!D19,IF(C1<2051,B13*(1-C11*$B$16),C3))","v":{"$error":"#VALUE!"}},{"$f":"IF(D1=(ActualData_End),Calculations!E19,IF(D1<2051,C13*(1-D11*$B$16),D3))","v":{"$error":"#VALUE!"}},{"$f":"IF(E1=(ActualData_End),Calculations!F19,IF(E1<2051,D13*(1-E11*$B$16),E3))","v":{"$error":"#VALUE!"}},{"$f":"IF(F1=(ActualData_End),Calculations!G19,IF(F1<2051,E13*(1-F11*$B$16),F3))","v":{"$error":"#VALUE!"}},{"$f":"IF(G1=(ActualData_End),Calculations!H19,IF(G1<2051,F13*(1-G11*$B$16),G3))","v":{"$error":"#VALUE!"}},{"$f":"IF(H1=(ActualData_End),Calculations!I19,IF(H1<2051,G13*(1-H11*$B$16),H3))","v":{"$error":"#VALUE!"}},{"$f":"IF(I1=(ActualData_End),Calculations!J19,IF(I1<2051,H13*(1-I11*$B$16),I3))","v":{"$error":"#VALUE!"}},{"$f":"IF(J1=(ActualData_End),Calculations!K19,IF(J1<2051,I13*(1-J11*$B$16),J3))","v":{"$error":"#VALUE!"}},{"$f":"IF(K1=(ActualData_End),Calculations!L19,IF(K1<2051,J13*(1-K11*$B$16),K3))","v":{"$error":"#VALUE!"}},{"$f":"IF(L1=(ActualData_End),Calculations!M19,IF(L1<2051,K13*(1-L11*$B$16),L3))","v":{"$error":"#VALUE!"}},{"$f":"IF(M1=(ActualData_End),Calculations!N19,IF(M1<2051,L13*(1-M11*$B$16),M3))","v":{"$error":"#VALUE!"}},{"$f":"IF(N1=(ActualData_End),Calculations!O19,IF(N1<2051,M13*(1-N11*$B$16),N3))","v":{"$error":"#VALUE!"}},{"$f":"IF(O1=(ActualData_End),Calculations!P19,IF(O1<2051,N13*(1-O11*$B$16),O3))","v":{"$error":"#VALUE!"}},{"$f":"IF(P1=(ActualData_End),Calculations!Q19,IF(P1<2051,O13*(1-P11*$B$16),P3))","v":{"$error":"#VALUE!"}},{"$f":"IF(Q1=(ActualData_End),Calculations!R19,IF(Q1<2051,P13*(1-Q11*$B$16),Q3))","v":{"$error":"#VALUE!"}},{"$f":"IF(R1=(ActualData_End),Calculations!S19,IF(R1<2051,Q13*(1-R11*$B$16),R3))","v":{"$error":"#VALUE!"}},{"$f":"IF(S1=(ActualData_End),Calculations!T19,IF(S1<2051,R13*(1-S11*$B$16),S3))","v":{"$error":"#VALUE!"}},{"$f":"IF(T1=(ActualData_End),Calculations!U19,IF(T1<2051,S13*(1-T11*$B$16),T3))","v":{"$error":"#VALUE!"}},{"$f":"IF(U1=(ActualData_End),Calculations!V19,IF(U1<2051,T13*(1-U11*$B$16),U3))","v":{"$error":"#VALUE!"}},{"$f":"IF(V1=(ActualData_End),Calculations!W19,IF(V1<2051,U13*(1-V11*$B$16),V3))","v":{"$error":"#VALUE!"}},{"$f":"IF(W1=(ActualData_End),Calculations!X19,IF(W1<2051,V13*(1-W11*$B$16),W3))","v":{"$error":"#VALUE!"}},{"$f":"IF(X1=(ActualData_End),Calculations!Y19,IF(X1<2051,W13*(1-X11*$B$16),X3))","v":{"$error":"#VALUE!"}},{"$f":"IF(Y1=(ActualData_End),Calculations!Z19,IF(Y1<2051,X13*(1-Y11*$B$16),Y3))","v":{"$error":"#VALUE!"}},{"$f":"IF(Z1=(ActualData_End),Calculations!AA19,IF(Z1<2051,Y13*(1-Z11*$B$16),Z3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AA1=(ActualData_End),Calculations!AB19,IF(AA1<2051,Z13*(1-AA11*$B$16),AA3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AB1=(ActualData_End),Calculations!AC19,IF(AB1<2051,AA13*(1-AB11*$B$16),AB3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AC1=(ActualData_End),Calculations!AD19,IF(AC1<2051,AB13*(1-AC11*$B$16),AC3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AD1=(ActualData_End),Calculations!AE19,IF(AD1<2051,AC13*(1-AD11*$B$16),AD3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AE1=(ActualData_End),Calculations!AF19,IF(AE1<2051,AD13*(1-AE11*$B$16),AE3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF1=(ActualData_End),Calculations!AG19,IF(AF1<2051,AE13*(1-AF11*$B$16),AF3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AG1=(ActualData_End),Calculations!AH19,IF(AG1<2051,AF13*(1-AG11*$B$16),AG3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AH1=(ActualData_End),Calculations!AI19,IF(AH1<2051,AG13*(1-AH11*$B$16),AH3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AI1=(ActualData_End),Calculations!AJ19,IF(AI1<2051,AH13*(1-AI11*$B$16),AI3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ1=(ActualData_End),Calculations!AK19,IF(AJ1<2051,AI13*(1-AJ11*$B$16),AJ3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AK1=(ActualData_End),Calculations!AL19,IF(AK1<2051,AJ13*(1-AK11*$B$16),AK3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AL1=(ActualData_End),Calculations!AM19,IF(AL1<2051,AK13*(1-AL11*$B$16),AL3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AM1=(ActualData_End),Calculations!AN19,IF(AM1<2051,AL13*(1-AM11*$B$16),AM3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AN1=(ActualData_End),Calculations!AO19,IF(AN1<2051,AM13*(1-AN11*$B$16),AN3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AO1=(ActualData_End),Calculations!AP19,IF(AO1<2051,AN13*(1-AO11*$B$16),AO3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AP1=(ActualData_End),Calculations!AQ19,IF(AP1<2051,AO13*(1-AP11*$B$16),AP3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ1=(ActualData_End),Calculations!AR19,IF(AQ1<2051,AP13*(1-AQ11*$B$16),AQ3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AR1=(ActualData_End),Calculations!AS19,IF(AR1<2051,AQ13*(1-AR11*$B$16),AR3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AS1=(ActualData_End),Calculations!AT19,IF(AS1<2051,AR13*(1-AS11*$B$16),AS3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AT1=(ActualData_End),Calculations!AU19,IF(AT1<2051,AS13*(1-AT11*$B$16),AT3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AU1=(ActualData_End),Calculations!AV19,IF(AU1<2051,AT13*(1-AU11*$B$16),AU3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AV1=(ActualData_End),Calculations!AW19,IF(AV1<2051,AU13*(1-AV11*$B$16),AV3))","v":{"$error":"#VALUE!"}}]
["Revised Carbon Intensity (PCP re-alignment) Other sectors",{"$f":"IF(B1=(ActualData_End),Calculations!C19,A14*(1-B11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(C1=(ActualData_End),Calculations!D19,B14*(1-C11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(D1=(ActualData_End),Calculations!E19,C14*(1-D11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(E1=(ActualData_End),Calculations!F19,D14*(1-E11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(F1=(ActualData_End),Calculations!G19,E14*(1-F11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(G1=(ActualData_End),Calculations!H19,F14*(1-G11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(H1=(ActualData_End),Calculations!I19,G14*(1-H11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(I1=(ActualData_End),Calculations!J19,H14*(1-I11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(J1=(ActualData_End),Calculations!K19,I14*(1-J11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(K1=(ActualData_End),Calculations!L19,J14*(1-K11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(L1=(ActualData_End),Calculations!M19,K14*(1-L11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(M1=(ActualData_End),Calculations!N19,L14*(1-M11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(N1=(ActualData_End),Calculations!O19,M14*(1-N11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(O1=(ActualData_End),Calculations!P19,N14*(1-O11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(P1=(ActualData_End),Calculations!Q19,O14*(1-P11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(Q1=(ActualData_End),Calculations!R19,P14*(1-Q11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(R1=(ActualData_End),Calculations!S19,Q14*(1-R11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(S1=(ActualData_End),Calculations!T19,R14*(1-S11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(T1=(ActualData_End),Calculations!U19,S14*(1-T11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(U1=(ActualData_End),Calculations!V19,T14*(1-U11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(V1=(ActualData_End),Calculations!W19,U14*(1-V11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(W1=(ActualData_End),Calculations!X19,V14*(1-W11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(X1=(ActualData_End),Calculations!Y19,W14*(1-X11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(Y1=(ActualData_End),Calculations!Z19,X14*(1-Y11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(Z1=(ActualData_End),Calculations!AA19,Y14*(1-Z11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AA1=(ActualData_End),Calculations!AB19,Z14*(1-AA11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AB1=(ActualData_End),Calculations!AC19,AA14*(1-AB11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AC1=(ActualData_End),Calculations!AD19,AB14*(1-AC11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AD1=(ActualData_End),Calculations!AE19,AC14*(1-AD11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AE1=(ActualData_End),Calculations!AF19,AD14*(1-AE11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF1=(ActualData_End),Calculations!AG19,AE14*(1-AF11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AG1=(ActualData_End),Calculations!AH19,AF14*(1-AG11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AH1=(ActualData_End),Calculations!AI19,AG14*(1-AH11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AI1=(ActualData_End),Calculations!AJ19,AH14*(1-AI11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ1=(ActualData_End),Calculations!AK19,AI14*(1-AJ11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AK1=(ActualData_End),Calculations!AL19,AJ14*(1-AK11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AL1=(ActualData_End),Calculations!AM19,AK14*(1-AL11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AM1=(ActualData_End),Calculations!AN19,AL14*(1-AM11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AN1=(ActualData_End),Calculations!AO19,AM14*(1-AN11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AO1=(ActualData_End),Calculations!AP19,AN14*(1-AO11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AP1=(ActualData_End),Calculations!AQ19,AO14*(1-AP11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ1=(ActualData_End),Calculations!AR19,AP14*(1-AQ11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AR1=(ActualData_End),Calculations!AS19,AQ14*(1-AR11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AS1=(ActualData_End),Calculations!AT19,AR14*(1-AS11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AT1=(ActualData_End),Calculations!AU19,AS14*(1-AT11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AU1=(ActualData_End),Calculations!AV19,AT14*(1-AU11*$B$17))","v":{"$error":"#VALUE!"}},{"$f":"IF(AV1=(ActualData_End),Calculations!AW19,AU14*(1-AV11*$B$17))","v":{"$error":"#VALUE!"}}]
[]
["Metric 3: Re-alignment Decarbonisation rate - constant acceleration",2.6123201654872865,"<- POWER GENERATION metric 3a (constant acceleration). This ensures the company stays within its carbon budget by 2051 (when power generation sector should reach zero carbon intensity)"]
["Metric 3: Re-alignment Decarbonisation rate - constant acceleration",2.7248961804523812,"<- ALL OTHER SECTOR metric 3a (constant acceleration). This ensures the company stays within its carbon budget by 2060 (end of IEA B2DS scenario)"]
[]
["DELAYED ACTION (recent decarb in next 5 years)"]
["Remaining Carbon Budget",{"$f":"INDEX(Calculations!C46:AW46, 1,MATCH(ActualData_End, Calculations!C6:AW6,0))","v":{"$error":"#N/A"}}]
["PCPintensity (base year 2014)",{"$f":"IF(B1<(ActualData_End+1), Calculations!C28, Calculations!C40)","v":{"$error":"#VALUE!"}},{"$f":"IF(C1<(ActualData_End+1), Calculations!D28, Calculations!D40)","v":{"$error":"#VALUE!"}},{"$f":"IF(D1<(ActualData_End+1), Calculations!E28, Calculations!E40)","v":{"$error":"#VALUE!"}},{"$f":"IF(E1<(ActualData_End+1), Calculations!F28, Calculations!F40)","v":{"$error":"#VALUE!"}},{"$f":"IF(F1<(ActualData_End+1), Calculations!G28, Calculations!G40)","v":{"$error":"#VALUE!"}},{"$f":"IF(G1<(ActualData_End+1), Calculations!H28, Calculations!H40)","v":{"$error":"#VALUE!"}},{"$f":"IF(H1<(ActualData_End+1), Calculations!I28, Calculations!I40)","v":{"$error":"#VALUE!"}},{"$f":"IF(I1<(ActualData_End+1), Calculations!J28, Calculations!J40)","v":{"$error":"#VALUE!"}},{"$f":"IF(J1<(ActualData_End+1), Calculations!K28, Calculations!K40)","v":{"$error":"#VALUE!"}},{"$f":"IF(K1<(ActualData_End+1), Calculations!L28, Calculations!L40)","v":{"$error":"#VALUE!"}},{"$f":"IF(L1<(ActualData_End+1), Calculations!M28, Calculations!M40)","v":{"$error":"#VALUE!"}},{"$f":"IF(M1<(ActualData_End+1), Calculations!N28, Calculations!N40)","v":{"$error":"#VALUE!"}},{"$f":"IF(N1<(ActualData_End+1), Calculations!O28, Calculations!O40)","v":{"$error":"#VALUE!"}},{"$f":"IF(O1<(ActualData_End+1), Calculations!P28, Calculations!P40)","v":{"$error":"#VALUE!"}},{"$f":"IF(P1<(ActualData_End+1), Calculations!Q28, Calculations!Q40)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q1<(ActualData_End+1), Calculations!R28, Calculations!R40)","v":{"$error":"#VALUE!"}},{"$f":"IF(R1<(ActualData_End+1), Calculations!S28, Calculations!S40)","v":{"$error":"#VALUE!"}},{"$f":"IF(S1<(ActualData_End+1), Calculations!T28, Calculations!T40)","v":{"$error":"#VALUE!"}},{"$f":"IF(T1<(ActualData_End+1), Calculations!U28, Calculations!U40)","v":{"$error":"#VALUE!"}},{"$f":"IF(U1<(ActualData_End+1), Calculations!V28, Calculations!V40)","v":{"$error":"#VALUE!"}},{"$f":"IF(V1<(ActualData_End+1), Calculations!W28, Calculations!W40)","v":{"$error":"#VALUE!"}},{"$f":"IF(W1<(ActualData_End+1), Calculations!X28, Calculations!X40)","v":{"$error":"#VALUE!"}},{"$f":"IF(X1<(ActualData_End+1), Calculations!Y28, Calculations!Y40)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y1<(ActualData_End+1), Calculations!Z28, Calculations!Z40)","v":{"$error":"#VALUE!"}},{"$f":"IF(Z1<(ActualData_End+1), Calculations!AA28, Calculations!AA40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AA1<(ActualData_End+1), Calculations!AB28, Calculations!AB40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AB1<(ActualData_End+1), Calculations!AC28, Calculations!AC40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC1<(ActualData_End+1), Calculations!AD28, Calculations!AD40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AD1<(ActualData_End+1), Calculations!AE28, Calculations!AE40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AE1<(ActualData_End+1), Calculations!AF28, Calculations!AF40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AF1<(ActualData_End+1), Calculations!AG28, Calculations!AG40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG1<(ActualData_End+1), Calculations!AH28, Calculations!AH40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AH1<(ActualData_End+1), Calculations!AI28, Calculations!AI40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AI1<(ActualData_End+1), Calculations!AJ28, Calculations!AJ40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ1<(ActualData_End+1), Calculations!AK28, Calculations!AK40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AK1<(ActualData_End+1), Calculations!AL28, Calculations!AL40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AL1<(ActualData_End+1), Calculations!AM28, Calculations!AM40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AM1<(ActualData_End+1), Calculations!AN28, Calculations!AN40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AN1<(ActualData_End+1), Calculations!AO28, Calculations!AO40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AO1<(ActualData_End+1), Calculations!AP28, Calculations!AP40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AP1<(ActualData_End+1), Calculations!AQ28, Calculations!AQ40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ1<(ActualData_End+1), Calculations!AR28, Calculations!AR40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AR1<(ActualData_End+1), Calculations!AS28, Calculations!AS40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AS1<(ActualData_End+1), Calculations!AT28, Calculations!AT40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AT1<(ActualData_End+1), Calculations!AU28, Calculations!AU40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AU1<(ActualData_End+1), Calculations!AV28, Calculations!AV40)","v":{"$error":"#VALUE!"}},{"$f":"IF(AV1<(ActualData_End+1), Calculations!AW28, Calculations!AW40)","v":{"$error":"#VALUE!"}}]
["Carbon Intensity Delayed - projected",{"$f":"IF(B1<(ActualData_End+6), Calculations!C37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(C1<(ActualData_End+6), Calculations!D37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(D1<(ActualData_End+6), Calculations!E37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(E1<(ActualData_End+6), Calculations!F37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F1<(ActualData_End+6), Calculations!G37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(G1<(ActualData_End+6), Calculations!H37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H1<(ActualData_End+6), Calculations!I37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(I1<(ActualData_End+6), Calculations!J37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(J1<(ActualData_End+6), Calculations!K37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K1<(ActualData_End+6), Calculations!L37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(L1<(ActualData_End+6), Calculations!M37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(M1<(ActualData_End+6), Calculations!N37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(N1<(ActualData_End+6), Calculations!O37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(O1<(ActualData_End+6), Calculations!P37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(P1<(ActualData_End+6), Calculations!Q37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q1<(ActualData_End+6), Calculations!R37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R1<(ActualData_End+6), Calculations!S37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S1<(ActualData_End+6), Calculations!T37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T1<(ActualData_End+6), Calculations!U37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U1<(ActualData_End+6), Calculations!V37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V1<(ActualData_End+6), Calculations!W37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W1<(ActualData_End+6), Calculations!X37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X1<(ActualData_End+6), Calculations!Y37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y1<(ActualData_End+6), Calculations!Z37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Z1<(ActualData_End+6), Calculations!AA37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AA1<(ActualData_End+6), Calculations!AB37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AB1<(ActualData_End+6), Calculations!AC37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC1<(ActualData_End+6), Calculations!AD37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AD1<(ActualData_End+6), Calculations!AE37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AE1<(ActualData_End+6), Calculations!AF37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AF1<(ActualData_End+6), Calculations!AG37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG1<(ActualData_End+6), Calculations!AH37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AH1<(ActualData_End+6), Calculations!AI37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AI1<(ActualData_End+6), Calculations!AJ37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ1<(ActualData_End+6), Calculations!AK37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AK1<(ActualData_End+6), Calculations!AL37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AL1<(ActualData_End+6), Calculations!AM37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AM1<(ActualData_End+6), Calculations!AN37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AN1<(ActualData_End+6), Calculations!AO37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AO1<(ActualData_End+6), Calculations!AP37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AP1<(ActualData_End+6), Calculations!AQ37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ1<(ActualData_End+6), Calculations!AR37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AR1<(ActualData_End+6), Calculations!AS37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AS1<(ActualData_End+6), Calculations!AT37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AT1<(ActualData_End+6), Calculations!AU37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AU1<(ActualData_End+6), Calculations!AV37, 0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AV1<(ActualData_End+6), Calculations!AW37, 0)","v":{"$error":"#VALUE!"}}]
["Emissions (Using revised carbon intensity below - to solve) Power Generation",{"$f":"IF(B1<(ActualData_End+6),B22*B4, B4*B31)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Emissions (Using revised carbon intensity below - to solve) Other sectors",{"$f":"IF(B1<(ActualData_End+6),B22*B4, B4*B32)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Projected Cumulative Emissions (from last reported data year) Power Generation",{"$f":"IF(B1<(ActualData_End),0,IF(B1>(ActualData_End-1),B23+A25,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Remaining Carbon Budget",{"$f":"B18","v":0}]
["Projected Cumulative Emissions (from last reported data year) Other sectors",{"$f":"IF(B1<(ActualData_End),0,IF(B1>(ActualData_End-1),B24+A26,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["1yr annual growth (PCP)",{"$f":"IF(B1<(ActualData_End+5),0,B21/A21)","v":{"$error":"#VALUE!"}},{"$f":"IF(C1<(ActualData_End+5),0,C21/B21)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["1yr decarb rate (PCP)",{"$f":"IF(B1<(ActualData_End+5), 0,(1-B28))","v":{"$error":"#VALUE!"}},{"$f":"IF(C1<(ActualData_End+5), 0,(1-C28))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Revised decarb (PCP re-alignment)",{"$f":"B28*($B$35)","v":{"$error":"#VALUE!"}},{"$f":"C28*($B$35)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"O28*($B$35)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Revised Carbon Intensity (PCP re-alignment) Power Generation",{"$f":"IF(B1=(ActualData_End+5),B22,IF(B1<2051,A32*(1-B29*$B$35),B21))","v":{"$error":"#VALUE!"}},{"$f":"IF(C1=(ActualData_End+5),C22,IF(C1<2051,B31*(1-C29*$B$35),C21))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Revised Carbon Intensity (PCP re-alignment) Other Sectors",{"$f":"IF(B1=(ActualData_End+5),B22,A32*(1-B29*$B$36))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Carbon overshoot",{"$f":"AM25-B20","v":{"$error":"#N/A"}}]
["Metric 3: Re-alignment Decarbonisation rate -  delayed action",2.7491523685411914,"<- POWER GENERATION metric 3b (delayed action). This ensures the company stays within its carbon budget by 2051 (when power generation sector should reach zero carbon intensity)"]
["Metric 3: Re-alignment Decarbonisation rate -  delayed action",2.8714543052449271,"<- ALL OTHER SECTOR metric 3b (delayed action). This ensures the company stays within its carbon budget by 2060 (end of IEA B2DS scenario)"]

{"sheet":"Benchmarks","index":4,"n_rows":103,"n_cols":15,"rows_kept":103,"cut":false,"hidden":true,"merged":[[1,14,18,16],[64,14,81,16]]}
["Sector","Source","Type Data","Unit","Region",2014,2025,2030,2035,2040,2045,2050,2055,2060]
["Aluminium","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tAluminium","Non-OECD",2.4016864613792634,1.9902619948919846,1.7087969088978945,1.4850655756041058,1.2768574271185786,1.07393776277997,0.86852372772490061,0.67650129748652832,0.62081872349314826,"Always change back order to having intensities in rows 2-19 (otherwise amend formula in Calculations - C10)"]
["Aluminium","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tAluminium","OECD",1.2818849327207467,1.4673393238502548,1.4944477868775938,1.5262478369929662,1.5518880811607316,1.4840317806626193,1.450986700689201,1.3680436371318776,1.2744735609851934]
["Aluminium","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tAluminium","World",2.0639175553134463,1.8681767775761511,1.6636068954518357,1.4930911240193143,1.3286180752665129,1.151154092286103,0.97923024514042178,0.80892128375893979,0.74702512503346852]
["Cement","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tCement","Non-OECD",0.51959158807826178,0.46270445632853585,0.39845493557693834,0.33980810011297541,0.26903044092474798,0.23551098542895618,0.16688070836346222,0.14408850927925895,9.9032462503435045E-2]
["Cement","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tCement","OECD",0.64432697559354279,0.5327649380406394,0.48457701750383064,0.39914551428389761,0.3235740010161387,0.28430742360132211,0.19530810499043785,0.15304892126138661,9.4196784666336242E-2]
["Cement","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tCement","World",0.53411625171297805,0.47075683976957439,0.40840182327191937,0.34669752735708143,0.27506146499146583,0.24076478985956259,0.16991403492521551,0.14505236725717471,9.8502410529485634E-2]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tChemicals & petrochemicals","Non-OECD",2.036392163082271,1.5240101975059885,1.2258520341978707,1.021109566410759,0.83621873943560832,0.67157740820649492,0.52738745718638969,0.40348347579150096,0.31606174302879542]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tChemicals & petrochemicals","OECD",1.5096142801283299,1.1365800974864722,0.92598176644239183,0.81245119681545142,0.70176772503278462,0.60308566711875178,0.49263305982143285,0.39658210641184094,0.32976715488453728]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tChemicals & petrochemicals","World",1.8408032724773897,1.4117276529693543,1.1464888755518861,0.9706366581362702,0.80629367003008645,0.65742114635272286,0.52065056750615857,0.40221236982021946,0.3184830137571989]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Scope 1 Intensity","tCO2/MWh","Non-OECD",0.67987225492861203,0.38748489390994534,0.26558407119318489,0.16213641450991512,8.3367488035139783E-2,2.669283723000963E-2,-3.0929453326891984E-3,-1.8982080744256322E-2,-2.5922366865620803E-2]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Scope 1 Intensity","tCO2/MWh","OECD",0.43863901718667953,0.24011839725219183,0.16724540485814543,0.10323793860113228,5.1151948695728151E-2,7.3940324796641999E-3,-2.0290664063281279E-2,-4.031303794713547E-2,-5.4444304241561846E-2]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Scope 1 Intensity","tCO2/MWh","World",0.57202495010378573,0.33017876428006449,0.22879072446153514,0.14068513898566262,7.1913543456831874E-2,2.0346672401521292E-2,-8.024897639471E-3,-2.4465233985998262E-2,-3.2826658337934321E-2]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tPulp&Paper","Non-OECD",0.71559619916682204,0.42895816808223486,0.38473991930987528,0.29832509235241605,0.20293430559727899,8.402697291210541E-2,7.8022678548882923E-2,7.1275540185735134E-2,5.9641243946558495E-2]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tPulp&Paper","OECD",0.31410133760015413,0.19900901129112475,0.16637384602389887,0.13072900844210869,9.3099107774986561E-2,3.9613219145042143E-2,3.8895154511186525E-2,3.8207742813632067E-2,3.0925179988832957E-2]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tPulp&Paper","World",0.48576995354286878,0.30171846879200404,0.26636768173866116,0.20846050239403541,0.14461495576864666,6.0538668516583925E-2,5.7398143374499014E-2,5.389968825590398E-2,4.4587096622185358E-2]
["Steel","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tSteel","Non-OECD",1.6043657307767671,0.99563817464823923,0.79856917881202671,0.62100752996581288,0.51694503562117966,0.42636887289624781,0.30855777331965401,0.23302284417749267,0.12072677967435026]
["Steel","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tSteel","World",1.4001273916670471,0.8873767023994692,0.69889947135165642,0.52539682961525314,0.43975118066217356,0.36372307979045299,0.26711594428523239,0.20779797122523208,0.11686598611925214]
["Steel","IEA - B2DS (ETP2017) - industry","Scope 1 Intensity","tCO2/tSteel","OECD",0.93596655706103038,0.64585613052390334,0.4673982496688644,0.28791143859184393,0.23627525294081511,0.19041375593364659,0.14671062542630256,0.1324953954466026,0.10505321931377183]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/passenger kilometres (billions)","Non-OECD",0.15018240825429749,0.10885921317683622,8.7665114321138493E-2,6.7940891168900161E-2,5.2672126832574953E-2,3.9798090568711357E-2,3.0052865797715236E-2,2.3869705352848714E-2,1.8787406159955725E-2]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/passenger kilometres (billions)","OECD",0.15975341276140995,0.11487274011139002,9.275004774824494E-2,7.0281289106445655E-2,5.2234032249860986E-2,3.7125310341661111E-2,3.0746350374594049E-2,2.352030463046513E-2,1.7847639420125922E-2]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/passenger kilometres (billions)","World",0.15571021172031166,0.1118811511919762,9.0025600561738806E-2,6.8960751179221888E-2,5.248980976914782E-2,3.8721652607798612E-2,3.0323344552504287E-2,2.3735215721499534E-2,1.8429845178293852E-2]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","Non-OECD",6.8605001310766509E-2,5.4584244960449738E-2,4.6539483598402404E-2,3.7772978603025802E-2,2.8826295447075052E-2,2.0660666619707148E-2,1.4071718789572932E-2,8.5742532549459502E-3,5.1341436871333076E-3]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","OECD",8.4707188785580437E-2,6.3375293684278605E-2,4.9808928323756024E-2,3.6238695018952084E-2,2.494982028128221E-2,1.6469673514802143E-2,9.4819970049247505E-3,3.4756794843841077E-3,3.8177012883860821E-4]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","World",7.4611461562656231E-2,5.7437816970973436E-2,4.7535499925066518E-2,3.7328047909886156E-2,2.7749614218910791E-2,1.9541273627354871E-2,1.2886906517474985E-2,7.3021080843089867E-3,3.981628293594673E-3]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","Non-OECD",9.846575406459443E-2,7.9245273352912718E-2,6.8752852192379879E-2,5.5485079013118103E-2,4.0598277909436369E-2,2.866218377127841E-2,1.8328013587432145E-2,1.144005777736142E-2,7.4978786370964445E-3]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","OECD",0.21468390724402614,0.14750754320639664,0.11558524135263901,8.5122384959297387E-2,6.0296074238352149E-2,3.8794610584404428E-2,2.0029161623616554E-2,6.2789718277578054E-3,9.9969975914970073E-4]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","World",0.14037457946993598,9.9597063181503964E-2,8.1679979524518817E-2,6.2904821570476263E-2,4.5005681214482098E-2,3.0705209746959203E-2,1.8642646248141093E-2,1.054249806231539E-2,6.4276667886369347E-3]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","Non-OECD",7.1487223104557008E-3,6.0165746234964257E-3,5.0939346061231036E-3,3.9795887788413474E-3,3.0695061927660194E-3,1.3978126866978019E-3,-4.5834045752427563E-4,-1.7200160860488336E-3,-2.0625612227672184E-3]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","OECD",5.4590005668802869E-3,4.3958010224738157E-3,3.6190859825317627E-3,2.6997612343947234E-3,1.6597797147951932E-3,7.3225469894212304E-4,-2.1899570536047019E-4,-8.5466703220915129E-4,-9.8590569963255201E-4]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Intensity","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","World",5.0160991841673802E-2,3.7639854931143399E-2,3.1962576945328697E-2,2.7491288054942546E-2,2.2139254091830912E-2,1.8251967668732251E-2,1.5364275237603408E-2,1.2160707586548185E-2,1.0857246237557447E-2]
["Aluminium","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","Non-OECD",211.82126094469757,240.58729709202063,229.62527630092725,213.75150703253721,184.24191679546132,155.15113901999302,122.81298256904016,93.758792601088373,84.11165216846365]
["Aluminium","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","OECD",48.831164269870754,54.024130466027408,53.64843667552551,53.173085860521191,51.912955648661374,49.732870032111194,48.148344575452157,44.904514547748313,41.316503655338103]
["Aluminium","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","World",260.65242521456832,294.61142755804804,283.27371297645277,266.92459289305839,236.1548724441227,204.8840090521042,170.96132714449232,138.66330714883668,125.42815582380175]
["Cement","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","Non-OECD",1916.8362390028656,1849.2331413717739,1619.3285059106479,1400.1197469530766,1168.3238652723269,1054.5924223393765,759.32131484535739,646.03917796655537,434.42611434652366]
["Cement","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","OECD",313.26468793684893,276.50287824684767,257.15336238213462,216.0314602091992,174.69180290297768,153.61049354881507,106.15160800555357,82.712272352971212,50.869397211283001]
["Cement","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","World",2230.1009269397146,2125.7360196186214,1876.4818682927826,1616.1512071622758,1343.0156681753047,1208.2029158881917,865.472922850911,728.75145031952661,485.29551155780666]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","Non-OECD",737.982983696254,906.21337310913873,799.62174641793661,718.24851921520076,624.6307484485535,525.9159324257779,426.63738005314826,332.21664684549648,262.09978308317881]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","OECD",323.08680077013992,275.79680328997097,217.39288615686812,182.34398486035099,150.07485000838111,123.04510533660665,95.825831438745354,73.719400980438053,58.678225343342191]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","World",1061.0697844663939,1182.0101763991097,1017.0146325748048,900.5925040755518,774.70559845693458,648.96103776238454,522.46321149189362,405.93604782593451,320.77800842652101]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Emissions ","Scope 1 (MtCO2)","Non-OECD",8871.2562230000021,6805.1502599078231,5261.813265936803,3607.8382402521197,2068.7240458003475,733.31249291730342,-94.190875545261335,-642.26266815906297,-971.7196308925968]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Emissions ","Scope 1 (MtCO2)","OECD",4734.122652,2564.2861436198455,1821.3861589863279,1150.8107839438487,593.17986449079842,90.347307114415656,-261.47838878489404,-546.75830919122438,-772.11671574694935]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Emissions ","Scope 1 (MtCO2)","World",13625.004647,9369.4364035276667,7083.1994249231311,4758.6490241959691,2661.9039102911465,823.65980003171899,-355.66926433015539,-1189.020977350287,-1743.8363466395458]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","Non-OECD",122.45590659549578,84.585803783619355,81.121804851300652,65.374017751155719,46.016863988547932,19.444156466404674,18.371993117015112,17.058216043025517,14.473966212011375]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","OECD",71.95984438310748,48.614685375787523,41.527141746168901,33.119131716692173,23.898953717981563,10.289337168005837,10.208764874118128,10.125437384315809,8.2698499250934621]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","World",194.41575097860326,133.20048915940689,122.64894659746955,98.493149467847886,69.915817706529495,29.733493634410511,28.58075799113324,27.183653427341326,22.743816137104837]
["Steel","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","Non-OECD",1860.7546051150089,1151.595886238305,928.28888232015936,756.23735347269678,663.17828241930124,557.11527977535752,419.03429089468966,317.37314302979939,161.88570901456933]
["Steel","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","OECD",477.65555693118392,334.85296715665208,233.92012255824724,141.1528914052129,114.99364909363641,89.934822517010574,68.575326395437429,60.449347233759916,46.040412931682951]
["Steel","IEA - B2DS (ETP2017) - industry","Emissions ","Scope 1 (MtCO2)","World",2338.4101620461929,1486.448853394957,1162.2090048784066,897.39024487790971,778.1719315129377,647.05010229236814,487.60961729012712,377.8224902635593,207.92612194625229]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","Non-OECD",401.16888109227773,439.2458487732406,417.06145134435417,395.6993036858014,367.11411345610099,321.04239451959398,264.94385030297144,221.19053489187459,194.04240986581209]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","OECD",583.42572567181037,468.21259428847821,382.30543162229731,316.12835363797979,259.50081430802891,201.9450605308225,173.31986291492785,136.39309904109288,113.2098573025761]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","World",984.59460676408798,907.45844306171875,799.36688296665147,711.82765732378118,626.6149277641299,522.98745505041654,438.26371321789929,357.58363393296742,307.25226716838813]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","Non-OECD",1456.7259425805344,1680.3863283056639,1730.4701868654674,1653.5532743753708,1452.3996540219282,1180.8040741013824,904.51424112045913,615.71310674040751,408.04683444729261]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","OECD",1070.0974917159574,937.66722112302909,811.39987383951791,647.93775221932719,483.4213171813858,343.03340321249772,212.08602104264816,82.978364692541788,9.7141606976334316]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","World",2526.8234342964915,2618.0535494286933,2541.8700607049855,2301.4910265946983,1935.820971203314,1523.8374773138803,1116.6002621631071,698.69147143294936,417.76099514492608]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","Non-OECD",2154.7480670016771,2263.8842725135269,2106.1649398818704,1784.0859053527247,1387.465661073978,1063.2033028791875,738.45849922609932,495.46476232310204,344.13699480008546]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","OECD",2649.5549797349654,1790.0582816439583,1350.0161623898393,914.06219142373516,593.9745163649377,363.4427169958841,183.12708366244041,57.248946836021311,9.0468022344259111]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","World",4804.3030467366425,4053.9425541574856,3456.1811022717093,2698.1480967764601,1981.4401774389157,1426.6460198750715,921.58558288853965,552.71370915912325,353.18379703451137]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","Non-OECD",130.77697761333695,144.53521006382798,130.42010784993857,103.6930897362393,60.839445708090921,29.357752154884231,-9.0996865284982196,-39.562029564286121,-47.398982957610187]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","OECD",108.25477814655743,95.713462047411099,80.208926333016635,60.214430274242879,44.82148979429823,20.266671703802835,-6.7152967029798614,-25.817417488323912,-31.638620913504234]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","World",239.03175575989439,240.24867211123905,210.62903418295522,163.90752001048219,105.66093550238917,49.624423858687067,-15.814983231478079,-65.379447052610004,-79.037603871114413]
["Transport - Shipping","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","Non-OECD",513.20924256803164,574.06851544636254,577.44114764805533,583.2242281664569,541.64300317547315,510.02192538278325,483.76822254590547,428.23445217201947,417.20865843773942]
["Transport - Shipping","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","OECD",425.53815480332787,398.96168753358904,356.22984527661242,312.21341152944581,258.5760311399772,216.80508207789103,180.24715625175486,155.9266933467066,151.25242198524572]
["Transport - Shipping","IEA - B2DS (ETP2017) - transport","Emissions ","Well-to-wheel emissions by mode (MtCO2)","World",938.74739737135951,973.03020297995158,933.67099292466776,895.43763969590282,800.21903431545036,726.82700746067428,664.01537879766033,584.16114551872602,568.46108042298511]
["Aluminium","IEA - B2DS (ETP2017) - industry","Activity ","MtAluminium (primary and secondary)","Non-OECD",88.196883461236993,120.88222440537422,134.37833080411315,143.93405284179846,144.29325693098798,144.46939515225952,141.40429172931059,138.59366264253981,135.48504416103029,"Always change back order to having activies from rows 53-70 (otherwise amend formula in Calculations - C11)"]
["Aluminium","IEA - B2DS (ETP2017) - industry","Activity ","MtAluminium (primary and secondary)","OECD",38.093250824181752,36.817748688333175,35.898501872464351,34.839090068938944,33.45148163637753,33.511997977499846,33.183174285872006,32.823890502419388,32.418486283387175]
["Aluminium","IEA - B2DS (ETP2017) - industry","Activity ","MtAluminium (primary and secondary)","World",126.29013428541874,157.6999730937074,170.2768326765775,178.77314291073739,177.74473856736552,177.98139312975937,174.5874660151826,171.41755314495919,167.90353044441747]
["Cement","IEA - B2DS (ETP2017) - industry","Activity ","MtCement","Non-OECD",3689.1210000000005,3996.575170347518,4064.0191934527284,4120.324814174769,4342.7199585905792,4477.8905766054086,4550.084442304581,4483.6273287723607,4386.7041509894307]
["Cement","IEA - B2DS (ETP2017) - industry","Activity ","MtCement","OECD",486.18899999999996,518.99601213200708,530.67593611185202,541.23484413141603,539.88207443856004,540.29716003553813,543.50846325988709,540.43028641613205,540.03326537601606]
["Cement","IEA - B2DS (ETP2017) - industry","Activity ","MtCement","World",4175.3100000000004,4515.5711824795253,4594.6951295645804,4661.5596583061852,4882.6020330291394,5018.1877366409472,5093.5929055644683,5024.0576151884925,4926.7374163654467]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Activity ","MtChems (high value chemicals, ammonia and methanol)","Non-OECD",362.39728136610353,594.62421878287842,652.29874741054255,703.40004916404132,746.97052217478108,783.10545590013442,808.96383529721629,823.3711335855761,829.26766324673372]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Activity ","MtChems (high value chemicals, ammonia and methanol)","OECD",214.01943862287447,242.65496457301248,234.77015858755874,224.4368468839495,213.85259631506995,204.02591546314798,194.51766284926111,185.88685618579632,177.93835581923688]
["Chemicals and petrochemicals","IEA - B2DS (ETP2017) - industry","Activity ","MtChems (high value chemicals, ammonia and methanol)","World",576.416719988978,837.27918335589095,887.06890599810117,927.83689604799088,960.82311848985103,987.13137136328237,1003.4814981464774,1009.2579897713724,1007.2060190659705]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Activity ","TWh","Non-OECD",13048.41631452,17562.362731718247,19812.232120311834,22251.868904079471,24814.51815998547,27472.257317512547,30453.456305794436,33835.208943224075,37485.760306144235]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Activity ","TWh","OECD",10792.753189999999,10679.257287090019,10890.500462665597,11147.169340431086,11596.427499160684,12218.949181369944,12886.635349607644,13562.815829167135,14181.772115613312]
["Power Generation","IEA - B2DS (ETP2017) - Scenario","Activity ","TWh","World",23818.899236000001,28376.859498996477,30959.294532562992,33824.81659758625,37015.335114018257,40481.30248414159,44320.722868883975,48600.433498031431,53122.56668612465]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Activity ","MtPaper&Pulp (excluding recovered paper)","Non-OECD",171.12431108224553,197.18893374097857,210.84842195946905,219.13683906256327,226.75744178940312,231.40374801724454,235.46991027108425,239.32776936623617,242.68384182229272]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Activity ","MtPaper&Pulp (excluding recovered paper)","OECD",229.09754199999998,244.28383951252565,249.60138109810666,253.3418719484778,256.70443347044215,259.74503941050233,262.46880883792386,265.01009059093576,267.41477100795191]
["Pulp and paper","IEA - B2DS (ETP2017) - industry","Activity ","MtPaper&Pulp (excluding recovered paper)","World",400.2218530822455,441.47277325350422,460.44980305757571,472.47871101104107,483.46187525984527,491.14878742774687,497.9387191090081,504.33785995717193,510.09861283024463]
["Steel","IEA - B2DS (ETP2017) - industry","Activity ","Mt Steel","Non-OECD",1159.8069999999993,1156.6409520659108,1162.4401579098096,1217.7587500659267,1282.8796810523627,1306.650919404535,1358.0415958621345,1361.9829598683355,1340.9262588734796]
["Steel","IEA - B2DS (ETP2017) - industry","Activity ","Mt Steel","OECD",510.33400000000006,518.46371247576019,500.47282531325612,490.26496514199812,486.69358158487006,472.31263348615488,467.41894935132018,456.23734341863826,438.25799182955012]
["Steel","IEA - B2DS (ETP2017) - industry","Activity ","Mt Steel","World",1670.1409999999994,1675.1046645416709,1662.9129832230658,1708.0237152079249,1769.5732626372328,1778.9635528906899,1825.4605452134547,1818.2203032869736,1779.1842507030296]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","Non-OECD",2671.2108678733898,4034.9901120423146,4757.4392000055723,5824.1700524960461,6969.7985544236681,8066.778831143034,8815.9263108649611,9266.5800277872622,10328.32357025433]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","OECD",3652.0391995828631,4075.9243127173681,4121.8893240896632,4498.0443252710193,4968.0410094841864,5439.5521188197235,5637.0873551920304,5798.9512118999974,6343.1277738004273]
["Transport - Air","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","World",6323.2500674562525,8110.9144247596832,8879.3285240952355,10322.214377767064,11937.839563907855,13506.330949962758,14453.013666056991,15065.53123968726,16671.451344054756]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","Non-OECD",15397.231054596501,23372.578583316266,28627.991896463562,33872.080189662913,39111.95682414472,44493.392612905947,50291.860267017968,56433.524451231438,62767.661169927218]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","OECD",11125.85124538602,13148.258802029774,14390.204551174091,15617.162778093316,16812.637950544809,18037.432367296613,19347.990491621742,20710.216975029572,22140.244160882346]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","World",26523.082299982521,36520.837385346036,43018.196447637652,49489.242967756232,55924.594774689533,62530.82498020256,69639.850758639703,77143.741426261011,84907.905330809575]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","Non-OECD",5836.2929560199582,7412.6109805079896,8554.8484160333901,9904.0088435411872,11272.583800873414,12658.881117462171,13987.013880943208,15376.006761908458,16709.435559932521]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","OECD",1507.0493036417411,1647.2106405936443,1900.0450315001533,2262.5581081160026,2563.1055109845261,2790.752411484581,3019.2408977675509,3163.7809195851546,3304.8076224646284]
["Transport - Heavy road","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","World",7343.3422596616992,9059.8216211016334,10454.893447533543,12166.566951657191,13835.689311857939,15449.633528946753,17006.254778710758,18539.787681493613,20014.243182397149]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","Non-OECD",512.1189537669743,795.95522923337001,992.1772963244498,1185.1473373637978,1368.6394125620538,1554.0821635045907,1747.9445019967959,1957.0682396373741,2158.4564333459766]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","OECD",753.49307407122831,765.08434608108701,794.64784258805912,811.52370128089945,813.6864835209949,811.82675884855962,816.54105938493933,826.93945595843707,838.23579459063353]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","World",1265.6120278382025,1561.0395753144571,1786.8251389125089,1996.6710386446973,2182.3258960830485,2365.9089223531505,2564.4855613817349,2784.0076955958111,2996.6922279366099]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","Non-OECD",21371.10417767975,27772.111694222025,29641.678212513682,30969.189235373549,32806.841236371714,35540.205953669312,38543.301229754179,41352.569872817854,43739.458357837226]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","OECD",11588.163148550428,11370.283396701119,10885.183826154796,9926.6880142485516,9037.2785066198066,8556.5548673866415,8326.4818540910655,8290.6276245208319,8211.2834751956379]
["Transport - Light road","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","World",32959.267326230176,39142.39509092315,40526.862038668478,40895.877249622106,41844.119742991519,44096.760821055948,46869.78308384525,49643.197497338682,51950.741833032858]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","Non-OECD",7272.3861936345384,10973.718389535965,12811.865689106244,14611.851328015169,16250.58992306089,17730.295924183451,19021.32153777625,20134.424273358738,21088.568383285532]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","OECD",3555.0713268220879,4538.014602898681,4860.7831983536162,5204.1291682680412,5564.9040528844343,5942.2917210506821,6324.8468530724103,6719.3584434762779,7128.1986038170444]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Activity ","Freight tonne kilometres (billion)","World",10827.457520456626,15511.732992434645,17672.648887459858,19815.98049628321,21815.493975945326,23672.587645234133,25346.168390848659,26853.782716835016,28216.766987102576]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","Non-OECD",2958.85572813418,4277.89499995602,5254.2980196509079,6603.0232533743119,8214.6879462297511,10213.098160198495,12465.241613728835,15080.175627531878,17338.178998986121]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","OECD",1196.9702201298037,1427.9614566575158,1705.9038810324864,2129.317445968979,2628.9250529206911,3248.6590701179002,4111.9132313161008,5071.8691165319069,5733.2338794644565]
["Transport - Rail","IEA - B2DS (ETP2017) - transport","Activity ","Passenger kilometres (billion)","World",4155.8259482639842,5705.8564566135356,6960.2019006833934,8732.3406993432909,10843.612999150444,13461.757230316394,16577.154845044937,20152.044744063787,23071.412878450577]

{"sheet":"Dropdown lists","index":5,"n_rows":81,"n_cols":4,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
["Lists"]
["<Please select>"]
["IEA B2DS"]
[]
[]
["<Please select>"]
["OECD"]
["non-OECD"]
["World"]
[]
["<Please select>"]
["Constant market share"]
["Manual estimations provided in table <please complete>"]
[]
["<Please select>"]
["Carbon Intensity growth prior 3 years"]
["Carbon Intensity growth prior 5 years"]
["Manual estimations provided for emissions instead"]
[]
["<Please select>"]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]
[2031]
[2032]
[2033]
[2034]
[2035]
[2036]
[2037]
[2038]
[2039]
[2040]
[2041]
[2042]
[2043]
[2044]
[2045]
[2046]
[2047]
[2048]
[2049]
[2050]
[2051]
[2052]
[2053]
[2054]
[2055]
[2056]
[2057]
[2058]
[2059]
[2060]
[]
[]
["Units","IEA intensity","Company unit","IEA activity projection"]
["<Please select>"]
["Power Generation","tCO2/MWh","MWh","TWh"]
["Cement","tCO2/tCement","tCement","MtCement"]
["Steel","tCO2/tSteel","tSteel","Mt Steel"]
["Aluminium","tCO2/tAluminium","tAluminium","MtAluminium (primary and secondary)"]
["Chemicals and petrochemicals","tCO2/tChemicals & petrochemicals","tChemicals & petrochemicals","MtChems (high value chemicals, ammonia and methanol)"]
["Pulp and paper","tCO2/tPulp&Paper","tPulp&Paper","MtPaper&Pulp (excluding recovered paper)"]
["Transport - Air","Well-to-wheel emissions(MtCO2)/passenger kilometres (billions)","Well-to-wheel emissions (MtCO2)","passenger kilometres(billions)"]
["Transport - Heavy road","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","Well-to-wheel emissions (MtCO2)","Passenger kilometres (billions)+ freight tonne kilometres(billions)"]
["Transport - Light road","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","Well-to-wheel emissions (MtCO2)","Passenger kilometres (billions)+ freight tonne kilometres(billions)"]
["Transport - Rail","Well-to-wheel emissions(MtCO2)/(passenger kilometres (billions)+ freight tonnekilometres(billions))","Well-to-wheel emissions (MtCO2)","Passenger kilometres (billions)+ freight tonne kilometres(billions)"]