673INDEX(Workstreams[Workstream], MATCH($A1,Workstreams[Code], 0))Electricity distribution, storage, and balancing792INDEX(Modules[Module], MATCH($A2,Modules[Code], 0))Storage, demand shifting, backupConversion.to.average.power0.1140771161305042134182613401445VII.c.Scenario16821911Preferences.EnergyUnitsTWh74341844269169272072172272372472572672767629INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))-59.560244420136328INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))-65.031165621912123INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))-71.525282446494742INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))-75.202503828488759INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))-75.173184240755688INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))-77.019330552538321INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))-79.312273961766607INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))-82.907874910364669INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))-87.628257269228939INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C16, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))-93.4257614531446731709879INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))4.9858220412000005INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))10.317757319999997INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))17.549707319999996INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))24.781657320000001INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))28.963039319999996INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))21.783685319999993INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))14.551735319999997INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))7.3197853199999958INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))8.7835319999996164E-2INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C17, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))8.7835319999996164E-21710880INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))0.97693037639999991INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))4.1229127800000027INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))11.793162780000001INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))20.575607796000003INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))28.73074032000001INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))26.385659999999998INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))17.751149999999999INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))7.8894000000000002INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C18, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))026332III.c!F1490III.c!G1490III.c!H1493.0020547945205484E-3III.c!I1490.1584417808219177III.c!J1490.39610445205479383III.c!K1490.39610445205479383III.c!L1490III.c!M1490III.c!N1490III.c!O14909641600INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))1.700604E-2INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))2.8059966000000006E-2INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))1.3604831999999999E-2INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C20, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))015821602INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!F$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!F$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!F$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!G$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!G$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!G$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!H$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!H$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!H$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!I$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!I$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!I$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!J$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!J$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!J$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!K$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!K$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!K$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!L$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!L$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!L$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!M$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!M$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!M$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!N$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!N$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!N$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!O$15&"'!Year.Matrix"), MATCH(VII.c!$C21, INDIRECT("'"&VII.c!O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!O$15&"'!Year.Vectors"), 0))045INDEX(Vectors[Description], MATCH($C22, Vectors[Code], 0))Electricity (delivered to end user)INDEX(INDIRECT("'"&F$15&"'!Year.NetBalance"), MATCH($C22, INDIRECT("'"&F$15&"'!Year.Vectors"), 0))-354.55512401053005INDEX(INDIRECT("'"&G$15&"'!Year.NetBalance"), MATCH($C22, INDIRECT("'"&G$15&"'!Year.Vectors"), 0))-360.93233792616286-372.62479962516409-381.79160355482168-389.2191103035388-398.37245385032901-409.14816543679922-421.5036539584932-435.11431844714406-450.4105965838732625837841844220072010201520202025203020352040204520501319INDEX(Vectors[Description], MATCH($C27, Vectors[Code], 0))Domestic solar thermalIX.a!E456&"_th"TWh_thIX.a!F4540IX.a!G4540IX.a!H4540IX.a!I4540IX.a!J4540IX.a!K4540IX.a!L4540IX.a!M4540IX.a!N4540IX.a!O45401300IX.a!E456&"_th"TWh_thIX.a!F456105.21210400000001IX.a!G456111.87510173199756IX.a!H456124.05211233911317IX.a!I456137.0737531120196IX.a!J456150.55871023168706IX.a!K456164.42548922456871IX.a!L456181.17890394177863IX.a!M456199.63933443866182IX.a!N456219.98070960799851IX.a!O456242.394680064947862584IX.a!E474&"_e"TWh_eIX.a!F478-10.521210400000001IX.a!G478-11.187510173199756IX.a!H478-12.405211233911315IX.a!I478-13.707375311201961IX.a!J478-15.055871023168706IX.a!K478-16.442548922456872IX.a!L478-18.117890394177863IX.a!M478-19.963933443866182IX.a!N478-21.998070960799847IX.a!O478-24.2394680064947862585840IX.a!F2930.1IX.a!G2930.1IX.a!H2939.9999999999999992E-2IX.a!I2930.1IX.a!J2930.1IX.a!K2930.1IX.a!L2930.1IX.a!M2930.1IX.a!N2939.9999999999999992E-2IX.a!O2939.9999999999999992E-22586840IX.a!F2980IX.a!G2980IX.a!H2980IX.a!I2980IX.a!J2980IX.a!K2980IX.a!L2980IX.a!M2980IX.a!N2980IX.a!O29802587840IX.a!F2990IX.a!G2990IX.a!H2990IX.a!I2990IX.a!J2990IX.a!K2990IX.a!L2990IX.a!M2990IX.a!N2990IX.a!O29902694IX.a!$O$107°CIX.a!F1105.6IX.a!G1103.9364164904862582IX.a!H1104.1922304439746298IX.a!I1104.4480443974630006IX.a!J1104.7038583509513714IX.a!K1104.9596723044397422IX.a!L1105.2154862579281129IX.a!M1105.4713002114164837IX.a!N1105.7271141649048545IX.a!O1105.98292811839322522588IX.a!$E$492°CIX.a!F49211.9IX.a!G49213.871053276455832IX.a!H49214.13974051935255IX.a!I49214.423876419953583IX.a!J49214.723916003007229IX.a!K49215.040327695560251IX.a!L49214.784513742071887IX.a!M49214.528699788583516IX.a!N49214.272885835095146IX.a!O49214.017071881606775835IX.a!E493W / °CIX.a!F493246.8IX.a!G493232.91946452443261IX.a!H493223.18858047872828IX.a!I493217.20268600363826IX.a!J493211.40533175966439IX.a!K493205.80903538981411IX.a!L493200.42416184370828IX.a!M493195.25890542752038IX.a!N493190.48069350357281IX.a!O493186.1280254822766852IX.a!F52326042600IX.a!G52326917400IX.a!H52328469000IX.a!I52330004800IX.a!J52331434800IX.a!K52332744800IX.a!L52334415113.888514474IX.a!M52336170630.572164804IX.a!N52338015696.24979952IX.a!O52339954878.8200881727992800IX.a!F52032476408683.15794IX.a!G52034131381801.286747IX.a!H52033916042224.027447IX.a!I52034241111636.204857IX.a!J52034585597942.134842IX.a!K52034951956255.320213IX.a!L52033352489823.212688IX.a!M52031825625857.673695IX.a!N52030395829780.514114IX.a!O52029065145248.7135961299IX.a!E526&"_th"TWh_thIX.a!F526204.87336129888465IX.a!G526222.54617470113536IX.a!H526233.8893969579419IX.a!I526248.86954071315532IX.a!J526263.35353027720021IX.a!K526277.23431512652451IX.a!L526278.04214216440784IX.a!M526278.84713540476156IX.a!N526279.90464596399477IX.a!O526281.303716446689122589IX.a!E557&"_e"TWh_eIX.a!F548-20.487336129888465IX.a!G548-22.254617470113537IX.a!H548-23.388939695794189IX.a!I548-24.886954071315532IX.a!J548-26.335353027720021IX.a!K548-27.723431512652454IX.a!L548-27.804214216440784IX.a!M548-27.884713540476156IX.a!N548-27.990464596399473IX.a!O548-28.1303716446689092590840IX.a!F533/IX.a!F5449.9999999999999992E-2IX.a!G533/IX.a!G5449.9999999999999992E-2IX.a!H533/IX.a!H5449.9999999999999992E-2IX.a!I533/IX.a!I5449.9999999999999978E-2IX.a!J533/IX.a!J5449.9999999999999978E-2IX.a!K533/IX.a!K5440.1IX.a!L533/IX.a!L5440.10000000000000002IX.a!M533/IX.a!M5440.10000000000000002IX.a!N533/IX.a!N5440.1IX.a!O533/IX.a!O5449.9999999999999964E-22591840IX.a!F538/IX.a!F5440IX.a!G538/IX.a!G5440IX.a!H538/IX.a!H5440IX.a!I538/IX.a!I5440IX.a!J538/IX.a!J5440IX.a!K538/IX.a!K5440IX.a!L538/IX.a!L5440IX.a!M538/IX.a!M5440IX.a!N538/IX.a!N5440IX.a!O538/IX.a!O54402592840IX.a!F539/IX.a!F5440IX.a!G539/IX.a!G5440IX.a!H539/IX.a!H5440IX.a!I539/IX.a!I5440IX.a!J539/IX.a!J5440IX.a!K539/IX.a!K5440IX.a!L539/IX.a!L5440IX.a!M539/IX.a!M5440IX.a!N539/IX.a!N5440IX.a!O539/IX.a!O54402755IX.a!E592&"_e"TWh_eIX.a!F5830IX.a!G583-0.18000000000000002IX.a!H583-0.56166666666666665IX.a!I583-1.0666666666666667IX.a!J583-1.7083333333333333IX.a!K583-2.5083333333333333IX.a!L583-3.5216666666666665IX.a!M583-4.7833333333333332IX.a!N583-6.3366666666666669IX.a!O583-8.288333333333332225937841844220072010201520202025203020352040204520501297IX.c!E202&"_th"TWh_thIX.c!F20213.4986017390997IX.c!G20213.9106803036901IX.c!H20214.6465592885608IX.c!I20215.4477054243129IX.c!J20216.318955019175601IX.c!K20217.265523293914399IX.c!L20218.293033538406899IX.c!M20219.4075485247056IX.c!N20220.615604350901499IX.c!O20221.9242469035741012584IX.c!E229&"_e"TWh_eIX.c!F220-2.6997203478199401IX.c!G220-2.7821360607380203IX.c!H220-2.8560790612693561IX.c!I220-2.7187961546790702IX.c!J220-2.3760398507919676IX.c!K220-2.1989370467129379IX.c!L220-2.1296017924071777IX.c!M220-2.1319114424195003IX.c!N220-2.1833937090589335IX.c!O220-2.27016491278592982585840IX.c!F205/IX.c!F2160.19999999999999998IX.c!G205/IX.c!G2160.20000000000000004IX.c!H205/IX.c!H2160.19499999999999998IX.c!I205/IX.c!I2160.17599999999999999IX.c!J205/IX.c!J2160.14560000000000001IX.c!K205/IX.c!K2160.12736IX.c!L205/IX.c!L2160.11641600000000001IX.c!M205/IX.c!M2160.10984960000000002IX.c!N205/IX.c!N2160.10590975999999999IX.c!O205/IX.c!O2160.103545856000000012586840IX.c!F210/IX.c!F2160IX.c!G210/IX.c!G2160IX.c!H210/IX.c!H2160IX.c!I210/IX.c!I2160IX.c!J210/IX.c!J2160IX.c!K210/IX.c!K2160IX.c!L210/IX.c!L2160IX.c!M210/IX.c!M2160IX.c!N210/IX.c!N2160IX.c!O210/IX.c!O21602587840IX.c!F211/IX.c!F2160IX.c!G211/IX.c!G2160IX.c!H211/IX.c!H2160IX.c!I211/IX.c!I2160IX.c!J211/IX.c!J2160IX.c!K211/IX.c!K2160IX.c!L211/IX.c!L2160IX.c!M211/IX.c!M2160IX.c!N211/IX.c!N2160IX.c!O211/IX.c!O21601299IX.c!E234&"_th"TWh_thIX.c!F23474.58316889692IX.c!G23476.860006585420706IX.c!H23480.925923017145195IX.c!I23485.352456869228106IX.c!J23490.166329960749493IX.c!K23495.396357697831505IX.c!L234101.07361017105001IX.c!M234107.231585720509IX.c!N234113.906397931695IX.c!O234121.1369770996822589IX.c!E261&"_e"TWh_eIX.c!F252-14.916633779384IX.c!G252-15.372001317084141IX.c!H252-15.780554988343313IX.c!I252-15.022032408984145IX.c!J252-13.128217642285128IX.c!K252-12.149680116395821IX.c!L252-11.766585401672959IX.c!M252-11.779346798763626IX.c!N252-12.063799267410314IX.c!O252-12.543231987038972590840IX.c!F237/IX.c!F2340.2IX.c!G237/IX.c!G2340.2IX.c!H237/IX.c!H2340.19500000000000001IX.c!I237/IX.c!I2340.17599999999999999IX.c!J237/IX.c!J2340.14560000000000001IX.c!K237/IX.c!K2340.12736IX.c!L237/IX.c!L2340.11641600000000002IX.c!M237/IX.c!M2340.10984960000000001IX.c!N237/IX.c!N2340.10590976000000001IX.c!O237/IX.c!O2340.103545856000000012591840IX.c!F242/IX.c!F2340IX.c!G242/IX.c!G2340IX.c!H242/IX.c!H2340IX.c!I242/IX.c!I2340IX.c!J242/IX.c!J2340IX.c!K242/IX.c!K2340IX.c!L242/IX.c!L2340IX.c!M242/IX.c!M2340IX.c!N242/IX.c!N2340IX.c!O242/IX.c!O23402592840IX.c!F243/IX.c!F2340IX.c!G243/IX.c!G2340IX.c!H243/IX.c!H2340IX.c!I243/IX.c!I2340IX.c!J243/IX.c!J2340IX.c!K243/IX.c!K2340IX.c!L243/IX.c!L2340IX.c!M243/IX.c!M2340IX.c!N243/IX.c!N2340IX.c!O243/IX.c!O23402755IX.c!E297&"_e"TWh_eIX.c!F288-10.935343763043921IX.c!G288-13.254900600776679IX.c!H288-16.532830800509913IX.c!I288-17.800679215641377IX.c!J288-16.569369363456545IX.c!K288-15.996399620986899IX.c!L288-15.972315490401165IX.c!M288-16.364636351505872IX.c!N288-17.055862068893703IX.c!O288-17.954191568822752754Preferences.EnergyUnits&" electricity"TWh electricity79442200720102015202020252030203520402045205010022594MAX(-INDIRECT(F62&"!T103"),0)0MAX(-INDIRECT(G62&"!T103"),0)0000005.6843418860808015E-140025951907Preferences.PowerUnitsGW7944220072010201520202025203020352040204520507401908I.a!Balancing.BoostableCapacity29.83760978720382127.57600475089434931.46798162361811538.04291041597788647.25753365804150356.24608761802112963.20363277482193468.1533326526667273.00029786813401275.67791798350987219257407187402698Balancing.Boostable.Capacity.CoalBio28.13799999999999828.13799999999999823.42200000000000117.0550000000000038.61200000000000011.79999999999999980.60.60.60.68692699Balancing.Boostable.Capacity.CCS000.850000000000000091.70000000000000021.70000000000000021.70000000000000021.70000000000000021.70000000000000021.70000000000000021.70000000000000027540II.a!Balancing.BoostableCapacity11107.23.60000000000000051.20000000000000061.20000000000000060000148SUM(F68:F72)68.97560978720382365.71400475089434762.93998162361811760.39791041597789758.7695336580415160.94608761802113265.50363277482193870.45333265266671775.30029786813401SUM(O68:O72)77.9779179835098692804Preferences.PowerUnitsGW7944220072010201520202025203020352040204520507401908I.a!F640.63200000000000001I.a!G640.7I.a!H640.7I.a!I640.7I.a!J640.7I.a!K640.7I.a!L640.7I.a!M640.7I.a!N640.7I.a!O640.71925740718I.a!F636.0299999999999999E-2I.a!G630.06I.a!H630.06I.a!I630.06I.a!J630.06I.a!K630.06I.a!L630.06I.a!M630.06I.a!N630.06I.a!O630.067402698I.a!F1150.60639704314450193I.a!G1150.60639704314450193I.a!H1150.60768508240116126I.a!I1150.61055408970976244I.a!J1150.62090106827682301I.a!K1150.70000000000000007I.a!L1150.90000000000000013I.a!M1150.90000000000000013I.a!N1150.90000000000000013I.a!O1150.900000000000000138692699I.b!F810I.b!G810.85I.b!H810.85I.b!I810.85I.b!J810.85I.b!K810.85I.b!L810.85I.b!M810.85I.b!N810.85I.b!O810.857540II.a!F570.59599999999999997II.a!G570.6II.a!H570.7II.a!I570.8II.a!J570.8II.a!K570.8II.a!L570.8II.a!M570.8II.a!N570.8II.a!O570.81909Preferences.EnergyUnits&" electricity"TWh electricity7944220072010201520202025203020352040204520508911927XII.a!Balancing.ShiftableCapacity000.21032091230592420.430146559060828942.31570428497161584.12044949472683896.09751679731956838.0777143045518019.970427127086743712.06003396020866719268911910004.3231431100909393E-28.7002769371567951E-20.452786438440831220.779320427574090371.11590227102255831.43274443322325481.58435300344638221.7579818734304171148SUM(F87:F88)000.253552343406833580.517149328432396922.76849072341244724.8997699223009297.21341906834212669.510458737775055111.554780130533127SUM(O87:O88)13.81801583363908413421915Preferences.PowerUnitsGW13408044220072010201520202025203020352040204520501(Unit.GW)*3.53.53.53.53.53.53.53.53.53.53.52(Unit.GW)*3.53.53.53.5(Unit.GW)*3.753.753.753.753.753.753.75(Unit.GW)*4433.53.53.5(Unit.GW)*3.753.75(Unit.GW)*777777743.53.53.5(Unit.GW)*3.753.75(Unit.GW)*77(Unit.GW)*1010(Unit.GW)*1515(Unit.GW)*1515(Unit.GW)*2020(Unit.GW)*20201916Preferences.EnergyUnitsTWh13408044220072010201520202025203020352040204520501(Unit.GWh)*272.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22(Unit.GWh)*272.7E-22.7E-22.7E-2(Unit.GWh)*282.8000000000000001E-2(Unit.GWh)*282.8000000000000001E-2(Unit.GWh)*300.03(Unit.GWh)*300.03(Unit.GWh)*300.03(Unit.GWh)*300.03(Unit.GWh)*300.0332.7E-22.7E-22.7E-2(Unit.GWh)*282.8000000000000001E-2(Unit.GWh)*353.5000000000000003E-2(Unit.GWh)*800.08(Unit.GWh)*1000.1(Unit.GWh)*1000.1(Unit.GWh)*1000.1(Unit.GWh)*1000.142.7E-22.7E-22.7E-2(Unit.GWh)*282.8000000000000001E-2(Unit.GWh)*353.5000000000000003E-2(Unit.GWh)*1500.15(Unit.GWh)*3000.3(Unit.GWh)*3500.35000000000000003(Unit.GWh)*4000.4(Unit.GWh)*4000.41917Preferences.PowerUnitsGW13408044220072010201520202025203020352040204520501(Unit.GW)*2.52.52.5(Unit.GW)*44444444422.52.5(Unit.GW)*44(Unit.GW)*66(Unit.GW)*88(Unit.GW)*1010(Unit.GW)*1010(Unit.GW)*1010(Unit.GW)*1010(Unit.GW)*101032.52.5(Unit.GW)*44(Unit.GW)*66(Unit.GW)*1010(Unit.GW)*1515(Unit.GW)*1515(Unit.GW)*1515(Unit.GW)*1515(Unit.GW)*151542.52.5(Unit.GW)*44(Unit.GW)*99(Unit.GW)*1515(Unit.GW)*2525(Unit.GW)*3030(Unit.GW)*3030(Unit.GW)*3030(Unit.GW)*303019181920134080442191910.7520.7530.7540.751922192113407944213591872100233%*75%0.247533%*90%0.29700000000000004366%*75%0.49566%*90%0.59400000000000008475%0.7590%0.9784976Preferences.EnergyUnitsTWh78418442200720102015202020252030203520402045205046168109('DUKES 09 (5.6)'!$K$248-'DUKES 09 (5.6)'!$M$249)*Unit.GWh-1.2254999999999996000000000246819124184421253125219135259619141259728162817432275628153.8MAX((L$147/$K148)-1,0)5.2631578947368363E-2MAX((M$147/$K148)-1,0)002752-1.48283.2MAX((L$147/$K149)-1,0)0.25002808028143MAX((L$147/$K150)-1,0)0.333333333333333260028090.128142.85MAX((L$147/$K151)-1,0)0.403508771929824485.2631578947368363E-2028100.0128142.660.503759398496240520.127819548872180502811028142.40.666666666666666740.25028120.12814210.5028130.0128141.911.09424083769633510.570680628272251414.7120418848167533E-21.61.50.8750.252757-128011.332.0075187969924811.2556390977443610.50375939849624052132128482758280220072050879-0.83880-0.852-0.431600-0.81601-0.81602F162-0.8328494184421253125227671434-0.16152850521434-0.126528502851F174/F1730.78328173374612997285214342853198341844212531252192311984198912580.4198819901991199211728551182856280579442200720102015202020252030203520402045205074019080.9$F192+(((G$191-$F$191)/($O$191-$F$191))*($O192-$F192))0.9$F192+(((H$191-$F$191)/($O$191-$F$191))*($O192-$F192))0.90.90.90.90.90.90.90.97407180.8$F193+(((G$191-$F$191)/($O$191-$F$191))*($O193-$F193))0.806976744186046590.818604651162790690.830232558139534890.84186046511627910.853488372093023310.865116279069767510.876744186046511720.888372093023255820.974026980.9$F194+(((G$191-$F$191)/($O$191-$F$191))*($O194-$F194))0.90.90.90.90.90.90.90.90.98692699$F195+(((G$191-$F$191)/($O$191-$F$191))*($O195-$F195))6.2790697674418611E-20.167441860465116280.272093023255813970.376744186046511660.481395348837209250.5860465116279070.690697674418604750.795348837209302380.975400.75$F196+(((G$191-$F$191)/($O$191-$F$191))*($O196-$F196))0.760465116279069760.777906976744186070.795348837209302270.812790697674418580.830232558139534890.84767441860465120.865116279069767510.882558139534883710.910928078132806Preferences.PowerUnits&"_e"GW_e13407944220072010201520202025203020352040204520507401908MAX(F192-F78,0)*F687.9964794229706246MAX(G192-G78,0)*G685.51520095017887176.29359632472362487.60858208319557959.45150673160830311.2492175236042312.64072655496439213.63066653053334914.60005957362680815.135583596701979740718MAX(F193-F79,0)*F6900000000007402698MAX(F194-F80,0)*F708.26140000000000548.26140000000000546.84660000000000144.93650000000000322.40360000000000040.3599999999999998800008692699MAX(F195-F81,0)*F710000000008.5000000000000089E-27540MAX(F196-F82,0)*F721.69400000000000041.60465116279069790.5609302325581401201.5348837209302255E-23.6279069767441836E-20000148SUM(F206:F210)17.951879422970631SUM(G206:G210)15.38125211296957713.70112655728176612.54508208319558311.87045556881760611.64549659337167112.64072655496439213.63066653053334914.60005957362680815.2205835967019873111931219553192841929519336193071987119321951Preferences.PowerUnits&"e"GWe41844220072010201520202025203020352040204520502598F63*Conversion.to.average.power00000006.4845332946392885E-15001965F21117.951879422970631G21115.38125211296957713.70112655728176612.54508208319558311.87045556881760611.64549659337167112.64072655496439213.63066653053334914.60005957362680815.220583596701981966INDEX(F$113:F$116,$E$8)2.52.5444444441967(INDEX($G$129:$G$132,$E$8)*F88*Conversion.to.average.power)+(INDEX($H$129:$H$132,$E$8)*F87*Conversion.to.average.power)00000000001968INDEX(F$97:F$100,$E$8)3.53.53.53.53.53.53.53.53.53.51957SUM(F228:F232)23.951879422970631SUM(G228:G232)21.38125211296957721.20112655728176820.04508208319558119.37045556881760419.14549659337167120.14072655496439221.13066653053335422.10005957362680822.7205835967019781952Preferences.EnergyUnits&"e"TWhe41844220072010201520202025203020352040204520502598F228*Conversion.to.energy.per.second*$F$145*Unit.day00000007.7814399535671445E-16001965F229*Conversion.to.energy.per.second*$F$145*Unit.day2.15422553075647551.84575025355634931.64413518687381171.50540984998346981.42445466825811271.39745959120460061.5168871865957271.63567998366400171.75200714883521691.82647003160423731966F230*INDEX($F$121:$F$124,$E$8)*Conversion.to.energy.per.second*$F$145*Unit.day0.224999999999999950.224999999999999950.360000000000000040.360000000000000040.360000000000000040.360000000000000040.360000000000000040.360000000000000040.360000000000000040.360000000000000041967F231*Conversion.to.energy.per.second*$F$145*Unit.day00000000001968INDEX(F$105:F$108,$E$8)2.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-21958SUM(F238:F242)2.4062255307564757SUM(G238:G242)2.09775025355634932.03113518687381191.89240984998346981.81145466825811271.78445959120460061.9038871865957272.02267998366400282.13900714883521692.213470031604237521956259926002601Preferences.PowerUnits&"th"GWth-F27*($F$166)*Conversion.to.average.power00000000002602Preferences.PowerUnits&"e"GWeF249*-(F29/F28)00000000N249*-(IFERROR((N29/N28),-1))0O249*-(IFERROR((O29/O28),-1))02603SUMPRODUCT(F30:F32,$F$150:$F$152)/SUM(F30:F32)00000000SUMPRODUCT(N30:N32,$F$150:$F$152)/SUM(N30:N32)002604Preferences.PowerUnits&"e"GWeF250*(1+F252)0G250*(1+G252)0000000002605Preferences.PowerUnits&"e"GWe-F29*Conversion.to.average.power*(F252)00000000002606Preferences.PowerUnits&"e"GWeF255+F2530G255+G253000000000260726082609828F3411.913.87105327645583214.1397405193525514.42387641995358314.72391600300722915.04032769556025114.78451374207188714.52869978858351614.27288583509514614.0170718816067752610828F33-$F$1497G33-$F$1495.33641649048625775.59223044397463025.8480443974630016.10385835095137176.35967230443974256.61548625792811336.87130021141648417.12711416490485487.38292811839322562611828F259+F26018.899999999999999G259+G26019.2074697669420919.73197096332717820.27192081741658620.82777435395860321.39999999999999121.421.421.421.42612839F35246.8232.91946452443261223.18858047872828217.20268600363826211.40533175966439205.80903538981411200.42416184370828195.25890542752038190.48069350357281186.12802548227662695697F37/(60*60*24*365.25)1029.11529023620121081.5582237333241074.73452429929561085.03535237802791095.95146469106771107.56065909068551056.87662633447051008.4932269143944963.18572326520757921.0188749687428126132614(F263*F261)-F2643635.4047097637986(G263*G261)-G2643392.2353492520563329.21606505318193318.08029961792453307.15108242298083296.75269825133463232.20043712088593170.04734923454093113.10111771125053062.12087035197652615Preferences.PowerUnits&"th"GWthF265*F36/Preferences.Unit.Power94.67539069449472391.31015578995730794.77945215599905399.558335773975912103.95963284574994107.95150775370031111.23654615402157114.6626115654329118.3467064858223122.346668307376162696Preferences.PowerUnits&"th"GWth(F38*Conversion.to.average.power)23.37136222893960625.38742581578089426.68142789846473328.39031949727986230.04261125681042131.62609116204933131.7182457408633131.81007704822741331.93071480310229432.0903167290313792697F266/(F38*Conversion.to.average.power)4.05091452381251663.59666854184163353.5522631141286383.50677053083234293.46040601987229433.41336863922152793.50702075590243293.60460024638080423.70635944781054773.81257278762511922616Preferences.PowerUnits&"e"GWeF266*-(F39/F38)9.46753906944947239.1310155789957319.47794521559990429.955833577397591210.39596328457499510.79515077537003311.12365461540215811.4662611565432911.83467064858222912.2346668307376152603SUMPRODUCT(F40:F42,$F$153:$F$155)/SUM(F40:F42)00000000002606Preferences.PowerUnits&"e"GWeF270*(1+F271)9.4675390694494723G270*(1+G271)9.1310155789957319.47794521559990429.955833577397591210.39596328457499510.79515077537003311.12365461540215811.4662611565432911.83467064858222912.2346668307376152617Preferences.PowerUnits&"e"GWe-F39*Conversion.to.average.power2.33713622289396072.53874258157808932.66814278984647312.83903194972798633.00426112568104213.16260911620493353.17182457408633093.18100770482274123.19307148031022913.20903167290313762618Preferences.PowerUnits&"e"GWeF272-F2747.1304028465555126.59227299741764136.80980242575343117.11680162766960497.39170215889395277.63254165916509927.95183004131582658.28525345172054818.64159916827200019.0256351578344773261927592763Preferences.PowerUnits&"e"GWe-$F$157*F43*Conversion.to.average.power0-2.0533880903490759E-2-6.4073313559966524E-2-0.12168225720587114-0.19488174005627801-0.28614343296068134-0.40174157730625892-0.54566887215757842-0.72286865921362831-0.94550916419499553193626202621Preferences.PowerUnits&"e"GWeF275+F256+F2787.130402846555512G275+G256+G2786.57173911651415036.74572911219346426.99511937046373337.19682041883767457.34639822620441767.55008846400956737.73958457956296997.91873050905837158.0801259936394825262210792603SUMPRODUCT(F50:F52,$F$150:$F$152)/SUM(F50:F52)0SUMPRODUCT(G50:G52,$F$150:$F$152)/SUM(G50:G52)0000000002605Preferences.PowerUnits&"e"GWeF285*-F4900000000002626262328542624Preferences.PowerUnits&"th"GWthF53*Conversion.to.average.power8.50823281963495158.7679678970363559.23179591799511469.736762134294785710.2859148939937810.88254137552264211.53018596521218212.23267005709662112.99411338486139313.8189570042986512753Preferences.PowerUnits&"th"GWthF290*($F$175*F268)26.996685284713614G290*($F$175*G268)24.70116099294255125.68675954648394826.74483405920155827.87969281803328829.09588154148186631.67325132926239634.53793508337928137.7235179325242641.2678086540913112616Preferences.PowerUnits&"e"GWeF291*(-F54/F53)5.39933705694272354.94023219858851095.00891811156436974.70709079441947424.05928327430564733.70565147312313053.68727322674741183.79397835373518083.9952887305893414.27311057233209282603SUMPRODUCT(F55:F57,$F$153:$F$155)/SUM(F55:F57)00000000002625Preferences.PowerUnits&"e"GWeF292*(1+F294)5.3993370569427235G292*(1+G294)4.94023219858851095.00891811156436974.70709079441947424.05928327430564733.70565147312313053.68727322674741183.79397835373518083.9952887305893414.27311057233209282617Preferences.PowerUnits&"e"GWe-F54*Conversion.to.average.power1.70164656392699021.7535935794072711.80020020400904751.71367013563588211.49762920856549451.38600046958656381.34229812932614161.3437539127040411.37620343000345781.43089573203729952618Preferences.PowerUnits&"e"GWeF295-F2963.6976904930157333G295-G2963.18663861918123993.20871790755532252.99342065878359212.56165406574015282.31965100353656692.344975097421272.450224441031142.61908530058588342.8422148402947931276027612762Preferences.PowerUnits&"e"GWe-$F$157*F58*Conversion.to.average.power-1.2474724803837463-1.512080835133091-1.886017659195746-2.0306501500845737-1.8901858730842507-1.8248231372332759-1.8220756890715448-1.8668305215042058-1.9456835579390486-2.0481623966259122193726272621Preferences.PowerUnits&"e"GWeF297+F286+F3002.450218012631987G297+G286+G3001.67455778404814891.32270024835957640.962770508699018370.671468192655902070.494827866303291010.522899408349725150.58339391952693420.673401742646834830.794052443668880951959Preferences.PowerUnits&"e"GWe743418442200720102015202020252030203520402045205067629-F281-F303-9.5806208591874995-G281-G303-8.2462969005622995-8.0684293605530399-7.9578898791627513-7.8682886114935764-7.8412260925077089-8.0729878723592918-8.3229784990899045-8.5921322517052054-8.87417843730836251709879$F$162*(F17*Conversion.to.average.power)-0.47207760599999993-0.97692659999999931-1.6616765999999992-2.3464265999999996-2.7423365999999989-2.0625665999999989-1.3778165999999994-0.69306659999999942-8.3165999999996344E-3-8.3165999999996344E-31710880$F$163*(F20*Conversion.to.average.power)-1.6489999999999996E-3$F$163*(G18*Conversion.to.average.power)-0.39978050000000015-1.1435305-1.9951250999999999-2.7858920000000005-2.5584999999999996-1.7212499999999995-0.764999999999999790026332$F$164*(F19*Conversion.to.average.power)00-1.4726027397260274E-4-7.7720700152206935E-3-1.9430175038051712E-2-1.9430175038051712E-200009641600$F$165*(F20*Conversion.to.average.power)-1.5519999999999998E-3-2.5608000000000002E-3-1.2415999999999998E-3000000015821602$F$167*(F21*Conversion.to.average.power)00000000001960SUM(F309:F314)-10.055899465187499SUM(G309:G314)-9.625564800562298-10.875025320827014-12.307213649177971-13.415947386531627-12.481722867545757-11.172054472359291-9.7810450990899049-8.6004488517052042-8.88249503730836131961Preferences.EnergyUnits&"e"TWhe743418442200720102015202020252030203520402045205067629F309*Conversion.to.energy.per.second*$F$145*Unit.day-1.1496745031025-0.98955562806747599-0.96821152326636473-0.95494678549953016-0.94419463337922904-0.94094713110092498-0.96875854468311484-0.99875741989078848-1.0310558702046246-1.06490141247700351709879-5.664931271999999E-2-0.1172311919999999-0.19940119199999987-0.28157119199999997-0.32908039199999983-0.24750799199999987-0.16533799199999991-8.3167991999999927E-2-9.9799199999995604E-4-9.9799199999995604E-41710880F311*Conversion.to.energy.per.second*$F$145*Unit.day-1.9787999999999991E-4-4.7973660000000015E-2H311*Conversion.to.energy.per.second*$F$145*Unit.day-0.13722366-0.23941501199999995-0.33430704-0.30701999999999996-0.20654999999999993-9.1799999999999965E-20026332F312*Conversion.to.energy.per.second*$F$145*Unit.day0G312*Conversion.to.energy.per.second*$F$145*Unit.day0-1.7671232876712326E-5-9.3264840182648323E-4-2.3316210045662049E-3-2.3316210045662049E-300009641600F313*Conversion.to.energy.per.second*$F$145*Unit.day-1.8623999999999998E-4G313*Conversion.to.energy.per.second*$F$145*Unit.day-3.0729599999999998E-4-1.4899199999999997E-4000000015821602F314*Conversion.to.energy.per.second*$F$145*Unit.day0G314*Conversion.to.energy.per.second*$F$145*Unit.day0000000001960SUM(F320:F325)-1.2067079358224999SUM(G320:G325)-1.1550677760674759-1.3050030384992415-1.4768656379013565-1.6099136863837953-1.4978067441054912-1.3406465366831148-1.1737254118907883-1.0320538622046247-1.0658994044770036319621963Preferences.PowerUnits&"e"GWe41844220072010201520202025203020352040204520501964F315-10.055899465187499G315-9.625564800562298-10.875025320827014-12.307213649177971-13.415947386531627-12.481722867545757-11.172054472359291-9.7810450990899049-8.6004488517052042-8.88249503730836132628F333+F359-10.055899465187499G333+G359-9.625564800562298-10.875025320827014-12.307213649177971-13.415947386531627-12.481722867545757-11.172054472359291-9.7810450990898978-8.6004488517052042-8.8824950373083613"…after "&D229…after boosting thermal plantF334+F3600000-1.5454918177140211-0.836226274174086020000"…after "&D230…after drawing from interconnectionF335+F3610000000000"…after "&D231…after shifting demand from electric vehiclesF336+F3620000000000"…after "&D232…after drawing from pumped storageF337+F36300000000001969F3380G338000000000419711970Preferences.EnergyUnits&"e"TWhe41844220072010201520202025203020352040204520501964F326-1.2067079358224999G326-1.1550677760674759-1.3050030384992415-1.4768656379013565-1.6099136863837953-1.4978067441054912-1.3406465366831148-1.1737254118907883-1.0320538622046247-1.06589940447700362628F346+F369-1.2067079358224999-1.1550677760674759-1.3050030384992415-1.4768656379013565-1.6099136863837953-1.4978067441054912-1.3406465366831148-1.1737254118907874-1.0320538622046247-1.0658994044770036"…after "&D239…after boosting thermal plant0000-0.18545901812568255-0.100347152900890580000"…after "&D240…after drawing from interconnection0000000000"…after "&D241…after shifting demand from electric vehicles0000000000"…after "&D242…after drawing from pumped storage00000000001978F3510000000000519761972Preferences.PowerUnits&"e"GWe41844220072010201520202025203020352040204520502598MIN(ABS(F333),F228)00000006.4845332946392885E-15001965MIN(ABS(F334),F229)10.0558994651874999.62556480056229810.87502532082701412.30721364917797111.87045556881760611.64549659337167111.1720544723592919.78104509908989788.60044885170520428.88249503730836131966MIN(ABS(F335),F230)00001.54549181771402110.8362262741740860200001967MIN(ABS(F336),F231)00000000001968MIN(ABS(F337),F232)00000000001974SUM(F359:F363)10.055899465187499SUM(G359:G363)9.62556480056229810.87502532082701412.30721364917797113.41594738653162712.48172286754575711.1720544723592919.78104509908990498.60044885170520428.88249503730836131973Preferences.EnergyUnits&"e"TWhe41844220072010201520202025203020352040204520502598MIN(ABS(F346),F238)00000007.7814399535671445E-16001965MIN(ABS(F347),F239)1.20670793582249991.15506777606747591.30500303849924151.47686563790135651.42445466825811271.39745959120460061.34064653668311481.17372541189078741.03205386220462471.06589940447700361966MIN(ABS(F348),F240)00000.185459018125682550.1003471529008905800001967MIN(ABS(F349),F241)00000000001968MIN(ABS(F350),F242)00000000001975SUM(F369:F373)1.2067079358224999SUM(G369:G373)1.15506777606747591.30500303849924151.47686563790135651.60991368638379531.49780674410549121.34064653668311481.17372541189078831.03205386220462471.06589940447700361972197741844220072010201520202025203020352040204520502598IF(F228=0,0,F359/F228)00000001001965IF(F229=0,0,F360/F229)0.560158589986979430.625798519513632860.793732199710777910.9810389097145692110.883814266828807370.71757643525207560.589069435527567630.5835843928634271966IF(F230=0,0,F361/F230)00000.386372954428505280.209056568543521500001967IF(F231=0,0,F362/F231)00000000001968IF(F232=0,0,F363/F232)00000000001974IF(F233=0,0,F364/F233)0.419837595522611240.450187142909351020.512945634820139440.613976714991628430.692598443999866810.651940408370866310.554699674903512570.462883888918340920.389159532491422930.39094484521065321973197741844220072010201520202025203020352040204520502598IF(F238=0,0,F369/F238)00000001001965IF(F239=0,0,F370/F239)0.560158589986979540.625798519513632860.793732199710777910.98103890971456931110.883814266828807480.717576435252075480.589069435527567850.583584392863427231966IF(F240=0,0,F371/F240)00000.515163939238007070.2787420913913626900001967IF(F241=0,0,F372/F241)00000000001968IF(F242=0,0,F373/F242)00000000001975IF(F243=0,0,F374/F243)0.501494112001684140.550622160149556010.642499350576371640.780415319606509560.888740808475147580.839361536393433140.704162802356098290.58028230929770330.482492011663740010.481551315020281032001197741844220072010201520202025203020352040204520502598MAX(F389,F379)0MAX(G389,G379)0000001001965MAX(F390,F380)0.560158589986979540.625798519513632860.793732199710777910.98103890971456931110.883814266828807480.71757643525207560.589069435527567850.583584392863427231966MAX(F391,F381)00000.515163939238007070.278742091391362690000196700000000001968000000000019990.501494112001684140.550622160149556010.642499350576371640.780415319606509560.888740808475147580.839361536393433140.704162802356098290.58028230929770330.482492011663740010.4815513150202810361985197920072010201520202025203020352040204520501980Preferences.EnergyUnits&"e"TWheF352000000000014251981Preferences.PowerUnits&"e"GWeF409/(Conversion.to.energy.per.second*$F$145*Unit.day)000000000014261964Preferences.PowerUnits&"e"GWeF33900000000001982Preferences.PowerUnits&"e"GWeMIN(F410:F411)0MIN(G410:G411)0000000001986Preferences.PowerUnits&"capacity"GWcapacity-F412/$F$1820-G412/$F$182000000000719971993INDIRECT("EF."&$F$184&".CO2")+INDIRECT("EF."&$F$184&".CH4")+INDIRECT("EF."&$F$184&".N2O")0.18476551498713398"MtCO2e/"&Preferences.EnergyUnits&"th"MtCO2e/TWhth197920072010201520202025203020352040204520501980Preferences.EnergyUnits&"e"TWheF3520G3520000000001994Preferences.EnergyUnits&"th"TWhthF420/$F$1830G420/$F$18300000000019951996$E$417*-F4210$E$417*-G42100000000019981996F422*$F$1460000000000270227087827034426916927207217227237247257267272704INDEX(Vectors[Description], MATCH(VII.c.Info[Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH(VII.c.Info[Information type], Vectors[Description], 0))02710INDEX(Vectors[Description], MATCH(VII.c.Info[Vector], Vectors[Code], 0))Installed Capacity INDEX(Vectors[Comment], MATCH(VII.c.Info[Information type], Vectors[Description], 0))0F413000000000027113112F433/Unit.GW000000000027642000840F4040.50149411200168414G4040.550622160149556010.642499350576371640.780415319606509560.888740808475147580.839361536393433140.704162802356098290.58028230929770330.482492011663740010.48155131502028103890106110641060103044269169272072172272372472572672710431053INDIRECT("EF."&$F$184&"."&$C445)*-F$421*$F$1460000000000104410530000000000104510530000000000148SUBTOTAL(109,VII.c.Emissions[2007])0SUBTOTAL(109,VII.c.Emissions[2010])0SUBTOTAL(109,VII.c.Emissions[2015])0SUBTOTAL(109,VII.c.Emissions[2020])0SUBTOTAL(109,VII.c.Emissions[2025])0SUBTOTAL(109,VII.c.Emissions[2030])0SUBTOTAL(109,VII.c.Emissions[2035])0SUBTOTAL(109,VII.c.Emissions[2040])0SUBTOTAL(109,VII.c.Emissions[2045])0SUBTOTAL(109,VII.c.Emissions[2050])02773Preferences.PowerUnits&"e"GWe27662765277527762780-O22*Conversion.to.average.power51.3815419329081852779E45451.381541932908185G47202777E454+G45551.38154193290818527672781E45651.381541932908185O270-O2749.02563515783447732782F457+G45760.407177090742664O272-O270+O253-O250+O25502783F458+G45860.407177090742664O25002786F459+G459-H46059.461667926547669-O2780.94550916419499553522784F46059.461667926547669O292-O2962.84221484029479312785F461+G46162.303882766842463O295-O292+O28602787F462+G462-H46360.255720370216551-O3002.04816239662591222772E456+SUM(G457:G463)-SUM(H457:H463)60.2557203702165442778E45651.381541932908185512768E466-H46751.373225332908184-O3108.3165999999996344E-32769F467-H46851.373225332908184-O31102803F468-H46951.373225332908184-O31202770F469-H47051.373225332908184-O31302771F470-H47151.373225332908184-O3140282788F47151.373225332908184O35902789F472+G47251.373225332908184O3608.88249503730836132790F473+G47360.255720370216544O36102791F474+G47460.255720370216544O36202792F475+G47560.255720370216544O363027742793F476+G47660.255720370216544-O33902794F477-G47860.255720370216544MAX(-(O412-O411),0)02772E466+SUM(G467:G477)-SUM(H467:H477)60.255720370216544IF(ABS(E479-E464)<1,"balanced",E479-E464)balanced