673INDEX(Workstreams[Workstream], MATCH($A1,Workstreams[Code], 0))Electricity distribution, storage, and balancing
792INDEX(Modules[Module], MATCH($A2,Modules[Code], 0))Storage, demand shifting, backup
1341
|
|
8261340
1445VII.c.Scenario1
|
682
|
1911Preferences.EnergyUnitsTWh
|
743418442691692720721722723724725726727
67629INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-59.560244420136328INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-65.031165621912123INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-71.525282446494742INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-75.202503828488759INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-75.173184240755688INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-77.019330552538321INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-79.312273961766607INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-82.907874910364669INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-87.628257269228939INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))-93.425761453144673
1709879INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))4.9858220412000005INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))10.317757319999997INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))17.549707319999996INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))24.781657320000001INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))28.963039319999996INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))21.783685319999993INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))14.551735319999997INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))7.3197853199999958INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))8.7835319999996164E-2INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))8.7835319999996164E-2
1710880INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0.97693037639999991INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))4.1229127800000027INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))11.793162780000001INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))20.575607796000003INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))28.73074032000001INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))26.385659999999998INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))17.751149999999999INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))7.8894000000000002INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0
26332III.c!F1490III.c!G1490III.c!H1493.0020547945205484E-3III.c!I1490.1584417808219177III.c!J1490.39610445205479383III.c!K1490.39610445205479383III.c!L1490III.c!M1490III.c!N1490III.c!O1490
9641600INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))1.700604E-2INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))2.8059966000000006E-2INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))1.3604831999999999E-2INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0
15821602INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.01", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))+INDEX(INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Matrix"), MATCH(VII.c!$C$16:$C$21, INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Modules"), 0), MATCH("V.02", INDIRECT("'"&VII.c!$C$15:$O$15&"'!Year.Vectors"), 0))0
45INDEX(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.41059658387326
|
2583
|
784184422007201020152020202520302035204020452050
1319INDEX(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!O4540
1300IX.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.39468006494786
2584IX.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.239468006494786
2585840IX.a!F463/IX.a!F4740.1IX.a!G463/IX.a!G4740.10000000000000002IX.a!H463/IX.a!H4749.9999999999999992E-2IX.a!I463/IX.a!I4740.1IX.a!J463/IX.a!J4740.10000000000000002IX.a!K463/IX.a!K4749.9999999999999992E-2IX.a!L463/IX.a!L4740.1IX.a!M463/IX.a!M4740.1IX.a!N463/IX.a!N4749.9999999999999978E-2IX.a!O463/IX.a!O4749.9999999999999992E-2
2586840IX.a!F468/IX.a!F4740IX.a!G468/IX.a!G4740IX.a!H468/IX.a!H4740IX.a!I468/IX.a!I4740IX.a!J468/IX.a!J4740IX.a!K468/IX.a!K4740IX.a!L468/IX.a!L4740IX.a!M468/IX.a!M4740IX.a!N468/IX.a!N4740IX.a!O468/IX.a!O4740
2587840IX.a!F469/IX.a!F4740IX.a!G469/IX.a!G4740IX.a!H469/IX.a!H4740IX.a!I469/IX.a!I4740IX.a!J469/IX.a!J4740IX.a!K469/IX.a!K4740IX.a!L469/IX.a!L4740IX.a!M469/IX.a!M4740IX.a!N469/IX.a!N4740IX.a!O469/IX.a!O4740
2694IX.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.9829281183932252
2588IX.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.017071881606775
835IX.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.1280254822766
852IX.a!F52326042600IX.a!G52326917400IX.a!H52328469000IX.a!I52330004800IX.a!J52331434800IX.a!K52332744800IX.a!L52334415113.888514474IX.a!M52336170630.572164804IX.a!N52338015696.24979952IX.a!O52339954878.82008817
27992800IX.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.713596
1299IX.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.30371644668912
2589IX.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.130371644668909
2590840IX.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-2
2591840IX.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!O5440
2592840IX.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!O5440
2755IX.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.2883333333333322
|
2593
|
784184422007201020152020202520302035204020452050
1297IX.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.924246903574101
2584IX.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.2701649127859298
2585840IX.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.10354585600000001
2586840IX.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!O2160
2587840IX.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!O2160
1299IX.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.136977099682
2589IX.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.54323198703897
2590840IX.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.10354585600000001
2591840IX.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!O2340
2592840IX.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!O2340
2755IX.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.95419156882275
|
2754Preferences.EnergyUnits&" electricity"TWh electricity
|
794422007201020152020202520302035204020452050
10022594MAX(-INDIRECT(F62&"!T103"),0)0MAX(-INDIRECT(G62&"!T103"),0)0000005.6843418860808015E-14002595
|
1907Preferences.PowerUnitsGW
|
794422007201020152020202520302035204020452050
7401908I.a!Balancing.BoostableCapacity29.83760978720382127.57600475089434931.46798162361811538.04291041597788647.25753365804150356.24608761802112963.20363277482193468.1533326526667273.00029786813401275.6779179835098721925
740718
7402698Balancing.Boostable.Capacity.CoalBio28.13799999999999828.13799999999999823.42200000000000117.0550000000000038.61200000000000011.79999999999999980.60.60.60.6
8692699Balancing.Boostable.Capacity.CCS000.850000000000000091.70000000000000021.70000000000000021.70000000000000021.70000000000000021.70000000000000021.70000000000000021.7000000000000002
7540II.a!Balancing.BoostableCapacity11107.23.60000000000000051.20000000000000061.20000000000000060000
148SUM(F68:F72)68.97560978720382365.71400475089434762.93998162361811760.39791041597789758.7695336580415160.94608761802113265.50363277482193870.45333265266671775.30029786813401SUM(O68:O72)77.977917983509869
|
2804Preferences.PowerUnitsGW
|
794422007201020152020202520302035204020452050
7401908I.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.71925
740718I.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.06
7402698I.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.90000000000000013
8692699I.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.85
7540II.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.8
|
1909Preferences.EnergyUnits&" electricity"TWh electricity
|
794422007201020152020202520302035204020452050
8911927XII.a!Balancing.ShiftableCapacity000.21032091230592420.430146559060828942.31570428497161584.12044949472683896.09751679731956838.0777143045518019.970427127086743712.0600339602086671926
8911910004.3231431100909393E-28.7002769371567951E-20.452786438440831220.779320427574090371.11590227102255831.43274443322325481.58435300344638221.7579818734304171
148SUM(F87:F88)000.253552343406833580.517149328432396922.76849072341244724.8997699223009297.21341906834212669.510458737775055111.554780130533127SUM(O87:O88)13.818015833639084
|
1342
|
1915Preferences.PowerUnitsGW
|
1340804422007201020152020202520302035204020452050
1(Unit.GW)*3.53.53.53.53.53.53.53.53.53.53.5
2(Unit.GW)*3.53.53.53.5(Unit.GW)*3.753.753.753.753.753.753.75(Unit.GW)*44
33.53.53.5(Unit.GW)*3.753.75(Unit.GW)*7777777
43.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)*2020
|
1916Preferences.EnergyUnitsTWh
|
1340804422007201020152020202520302035204020452050
1(Unit.GWh)*272.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-22.7E-2
2(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.03
32.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.1
42.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.4
|
1917Preferences.PowerUnitsGW
|
1340804422007201020152020202520302035204020452050
1(Unit.GW)*2.52.52.5(Unit.GW)*444444444
22.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)*1010
32.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)*1515
42.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)*3030
|
19181920
|
1340804421919
10.75
20.75
30.75
40.75
|
19221921
|
13407944213591872
100
233%*75%0.247533%*90%0.29700000000000004
366%*75%0.49566%*90%0.59400000000000008
475%0.7590%0.9
|
784
|
976Preferences.EnergyUnitsTWh
|
784184422007201020152020202520302035204020452050
46168109('DUKES 09 (5.6)'!$K$248-'DUKES 09 (5.6)'!$M$249)*Unit.GWh-1.22549999999999960000000002468
1091006
|
1912
|
41844212531252
191312596
1914125972816
2817432
275628153.8MAX((L$148/$K149)-1,0)5.2631578947368363E-2MAX((M$148/$K149)-1,0)00
2752-1.858283.2MAX((L$148/$K150)-1,0)0.2500
2808028143MAX((L$148/$K151)-1,0)0.3333333333333332600
28090.128142.85MAX((L$148/$K152)-1,0)0.403508771929824485.2631578947368363E-20
28100.0128142.660.503759398496240520.12781954887218050
2811028142.40.666666666666666740.250
28120.12814210.50
28130.0128141.911.09424083769633510.570680628272251414.7120418848167533E-2
1.61.50.8750.25
2757-128011.332.0075187969924811.2556390977443610.50375939849624052
1321
27582848
285720072050
879-0.92IFERROR((1+F162)*F17*Conversion.to.average.power/III.a.1!F99,"nc")2.1839999999999984E-2IFERROR((1+F162)*O17*Conversion.to.average.power/III.a.1!O99,"nc")2.3999999999999983E-2
880-0.91IFERROR((1+F163)*F18*Conversion.to.average.power/III.a.2!F103,"nc")2.5469999999999986E-2IFERROR((1+F163)*O18*Conversion.to.average.power/III.a.2!O103,"nc")nc
20IFERROR((1+F164)*F19*Conversion.to.average.power/III.c!F99,"nc")ncIFERROR((1+F164)*O19*Conversion.to.average.power/III.c!O99,"nc")nc
1600-0.8IFERROR((1+F165)*F20*Conversion.to.average.power/IV.a!F82,"nc")1.939999999999999E-2IFERROR((1+F165)*O20*Conversion.to.average.power/IV.a!O82,"nc")nc
1601-0.8IFERROR((1+F166)*F27*Conversion.to.average.power/IV.b!F77,"nc")ncIFERROR((1+F166)*O27*Conversion.to.average.power/IV.b!O77,"nc")nc
1602F162-0.92IFERROR((1+F167)*F21*Conversion.to.average.power/IV.c!F82,"nc")ncIFERROR((1+F167)*O21*Conversion.to.average.power/IV.c!O82,"nc")nc
|
2849
|
41844212531252
27671434-0.16152858
521434-0.12652858
2851F173/F1720.783281733746129972859
|
14342860
|
1983
|
41844212531252
192311984
12580.419881989
199019911992
|
1091006
|
|
2805
|
794422007201020152020202520302035204020452050
74019080.9$F191+(((G$190-$F$190)/($O$190-$F$190))*($O191-$F191))0.9$F191+(((H$190-$F$190)/($O$190-$F$190))*($O191-$F191))0.90.90.90.90.90.90.90.9
7407180.8$F192+(((G$190-$F$190)/($O$190-$F$190))*($O192-$F192))0.806976744186046590.818604651162790690.830232558139534890.84186046511627910.853488372093023310.865116279069767510.876744186046511720.888372093023255820.9
74026980.9$F193+(((G$190-$F$190)/($O$190-$F$190))*($O193-$F193))0.90.90.90.90.90.90.90.90.9
8692699$F194+(((G$190-$F$190)/($O$190-$F$190))*($O194-$F194))6.2790697674418611E-20.167441860465116280.272093023255813970.376744186046511660.481395348837209250.5860465116279070.690697674418604750.795348837209302380.9
75400.75$F195+(((G$190-$F$190)/($O$190-$F$190))*($O195-$F195))0.760465116279069760.777906976744186070.795348837209302270.812790697674418580.830232558139534890.84767441860465120.865116279069767510.882558139534883710.9
|
1092807
|
813
|
2806Preferences.PowerUnits&"_e"GW_e
|
1340794422007201020152020202520302035204020452050
7401908MAX(F191-F78,0)*F687.99647942297062465.51520095017887176.29359632472362487.60858208319557959.45150673160830311.2492175236042312.64072655496439213.63066653053334914.60005957362680815.135583596701979
740718MAX(F192-F79,0)*F690000000000
7402698MAX(F193-F80,0)*F708.26140000000000548.26140000000000546.84660000000000144.93650000000000322.40360000000000040.359999999999999880000
8692699MAX(F194-F81,0)*F710000000008.5000000000000089E-2
7540MAX(F195-F82,0)*F721.69400000000000041.60465116279069790.5609302325581401201.5348837209302255E-23.6279069767441836E-20000
148SUM(F205:F209)17.951879422970631SUM(G205:G209)15.38125211296957713.70112655728176612.54508208319558311.87045556881760611.64549659337167112.64072655496439213.63066653053334914.60005957362680815.22058359670198
|
731
|
11931
21955
31928
41929
51933
61930
71987
|
11932
|
1951Preferences.PowerUnits&"e"GWe
|
4184422007201020152020202520302035204020452050
2598F63*Conversion.to.average.power00000006.4845332946392885E-1500
1965F21017.951879422970631G21015.38125211296957713.70112655728176612.54508208319558311.87045556881760611.64549659337167112.64072655496439213.63066653053334914.60005957362680815.22058359670198
1966INDEX(F$113:F$116,$E$8)2.52.544444444
1967(INDEX($G$129:$G$132,$E$8)*F88*Conversion.to.average.power)+(INDEX($H$129:$H$132,$E$8)*F87*Conversion.to.average.power)0000000000
1968INDEX(F$97:F$100,$E$8)3.53.53.53.53.53.53.53.53.53.5
1957SUM(F227:F231)23.951879422970631SUM(G227:G231)21.38125211296957721.20112655728176820.04508208319558119.37045556881760419.14549659337167120.14072655496439221.13066653053335422.10005957362680822.720583596701978
|
1952Preferences.EnergyUnits&"e"TWhe
|
4184422007201020152020202520302035204020452050
2598F227*Conversion.to.energy.per.second*$F$146*Unit.day00000001.556287990713429E-1600
1965F228*Conversion.to.energy.per.second*$F$146*Unit.day0.430845106151295120.369150050711269830.328827037374762320.301081969996693950.284890933651622550.279491918240920120.30337743731914540.327135996732800360.350401429767043360.36529400632084746
1966F229*INDEX($F$121:$F$124,$E$8)*Conversion.to.energy.per.second*$F$146*Unit.day4.4999999999999991E-24.4999999999999991E-27.1999999999999995E-27.1999999999999995E-27.1999999999999995E-27.1999999999999995E-27.1999999999999995E-27.1999999999999995E-27.1999999999999995E-27.1999999999999995E-2
1967F230*Conversion.to.energy.per.second*$F$146*Unit.day0000000000
1968INDEX(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-2
1958SUM(F237:F241)0.50284510615129507SUM(G237:G241)0.441150050711269840.427827037374762350.400081969996693990.383890933651622580.378491918240920160.402377437319145440.426135996732800560.449401429767043390.4642940063208475
|
21956
|
25992600
|
2601Preferences.PowerUnits&"th"GWth-F27*($F$166)*Conversion.to.average.power0000000000
2602Preferences.PowerUnits&"e"GWeF248*-(F29/F28)0000000000
|
2603SUMPRODUCT(F30:F32,$F$151:$F$153)/SUM(F30:F32)0000000000
2604Preferences.PowerUnits&"e"GWeF249*(1+F251)0G249*(1+G251)000000000
|
2605Preferences.PowerUnits&"e"GWe-F29*Conversion.to.average.power*(F251)0000000000
2606Preferences.PowerUnits&"e"GWeF254+F2520G254+G252000000000
|
26072608
2609828F3411.913.87105327645583214.1397405193525514.42387641995358314.72391600300722915.04032769556025114.78451374207188714.52869978858351614.27288583509514614.017071881606775
2610828F33-$F$1507.4499999999999993G33-$F$1505.78641649048625876.04223044397462956.29804439746300036.5538583509513716.80967230443974187.06548625792811267.32130021141648347.57711416490485417.8329281183932249
2611828F258+F25919.350000000000001G258+G25919.65746976694209320.18197096332718120.72192081741658121.27777435395859821.84999999999999421.8521.8521.8521.85
|
2612839F35246.8232.91946452443261223.18858047872828217.20268600363826211.40533175966439205.80903538981411200.42416184370828195.25890542752038190.48069350357281186.1280254822766
2695697F37/(60*60*24*365.25)1029.11529023620121081.5582237333241074.73452429929561085.03535237802791095.95146469106771107.56065909068551056.87662633447051008.4932269143944963.18572326520757921.01887496874281
26132614(F262*F260)-F2633746.4647097637999(G262*G260)-G2633497.04910828805173429.65092626861093415.8215083195613402.28348171482873389.36676417675153322.39130995055533257.91385667692613198.81742978785863145.8784818190011
2615Preferences.PowerUnits&"th"GWthF264*F36/Preferences.Unit.Power97.56768185049475194.1314696674328197.638732219941105102.49104119282678106.95010079100931110.98413681961492114.34047531415916117.84079854579777121.60527176937966125.69319352380114
2696Preferences.PowerUnits&"th"GWth(F38*Conversion.to.average.power)23.37136222893960625.38742581578089426.68142789846473328.39031949727986230.04261125681042131.62609116204933131.7182457408633131.81007704822741331.93071480310229432.090316729031379
2697F265/(F38*Conversion.to.average.power)4.17466816417236863.70779890606003983.6594267964781343.61007001709320943.55994689931503763.50925873991009143.60488017680157613.7045115724535583.80841057017504793.9168573680698318
|
2616Preferences.PowerUnits&"e"GWeF265*-(F39/F38)9.75676818504947549.41314696674328219.763873221994110510.24910411928267910.69501007910093211.09841368196149211.43404753141591711.78407985457977812.16052717693796512.569319352380113
2603SUMPRODUCT(F40:F42,$F$154:$F$156)/SUM(F40:F42)0000000000
2606Preferences.PowerUnits&"e"GWeF269*(1+F270)9.7567681850494754G269*(1+G270)9.41314696674328219.763873221994110510.24910411928267910.69501007910093211.09841368196149211.43404753141591711.78407985457977812.16052717693796512.569319352380113
|
2617Preferences.PowerUnits&"e"GWe-F39*Conversion.to.average.power2.33713622289396072.53874258157808932.66814278984647312.83903194972798633.00426112568104213.16260911620493353.17182457408633093.18100770482274123.19307148031022913.2090316729031376
2618Preferences.PowerUnits&"e"GWeF271-F2737.41963196215551516.87440438516519247.09573043214763737.41007216955469257.69074895341988987.9358045657565598.26222295732958588.60307214975703628.96745569662773619.3602876794769756
|
26192759
2763Preferences.PowerUnits&"e"GWe-$F$158*F43*Conversion.to.average.power0-2.0533880903490759E-2-6.4073313559966524E-2-0.12168225720587114-0.19488174005627801-0.28614343296068134-0.40174157730625892-0.54566887215757842-0.72286865921362831-0.94550916419499553
|
19362620
2621Preferences.PowerUnits&"e"GWeF274+F255+F2777.4196319621555151G274+G255+G2776.85387050426170147.03165711858767047.28838991234882097.49586721336361177.64966113279587747.86048138002332668.05740327759945718.24458703741410848.4147785152819807
|
26221079
|
2603SUMPRODUCT(F50:F52,$F$151:$F$153)/SUM(F50:F52)0000000000
2605Preferences.PowerUnits&"e"GWeF284*-F490000000000
|
26262623
2861
2624Preferences.PowerUnits&"th"GWthF53*Conversion.to.average.power8.50823281963495158.7679678970363559.23179591799511469.736762134294785710.2859148939937810.88254137552264211.53018596521218212.23267005709662112.99411338486139313.818957004298651
2753Preferences.PowerUnits&"th"GWthF289*($F$174*F267)27.821422035388927G289*($F$174*G267)25.46438089653634426.4616705404581427.53266080582130128.68167071477818629.91325795332805632.5570573426308735.49524814394953938.76219952797113442.39659919819141
2616Preferences.PowerUnits&"e"GWeF290*(-F54/F53)5.56428440707778555.0928761793072695.16002575538933784.84574830182454894.17605125607170363.80975253293586123.79016238759971593.89913881051359964.10529524907953654.3899921554656434
|
2603SUMPRODUCT(F55:F57,$F$154:$F$156)/SUM(F55:F57)0000000000
2625Preferences.PowerUnits&"e"GWeF291*(1+F293)5.5642844070777855G291*(1+G293)5.0928761793072695.16002575538933784.84574830182454894.17605125607170363.80975253293586123.79016238759971593.89913881051359964.10529524907953654.3899921554656434
2617Preferences.PowerUnits&"e"GWe-F54*Conversion.to.average.power1.70164656392699021.7535935794072711.80020020400904751.71367013563588211.49762920856549451.38600046958656381.34229812932614161.3437539127040411.37620343000345781.4308957320372995
2618Preferences.PowerUnits&"e"GWeF294-F2953.8626378431507953G294-G2953.3392825998999983.35982555138029063.13207816618866672.6784220475062092.42375206334929772.44786425827357412.55538489780955842.72909181907607852.9590964234283437
|
27602761
2762Preferences.PowerUnits&"e"GWe-$F$158*F58*Conversion.to.average.power-1.2474724803837463-1.512080835133091-1.886017659195746-2.0306501500845737-1.8901858730842507-1.8248231372332759-1.8220756890715448-1.8668305215042058-1.9456835579390486-2.0481623966259122
|
19372627
2621Preferences.PowerUnits&"e"GWeF296+F285+F2992.615165362767049G296+G285+G2991.8272017647669071.47380789218454461.1014280161040930.788236174421958370.598928926116021780.62578856920202930.688554376305352540.783408261137029880.91093402680243152
|
|
1959Preferences.PowerUnits&"e"GWe
|
7434184422007201020152020202520302035204020452050
67629-F280-F302-10.034797324922565-G280-G302-8.6810722690286077-8.5054650107722143-8.3898179284529135-8.2841033877855708-8.2485900589118994-8.4862699492253562-8.7459576539048101-9.0279952985511382-9.3257125420844122
1709879$F$162*(F17*Conversion.to.average.power)-0.52326674399999995-1.0828583999999994-1.8418583999999991-2.6008583999999999-3.0396983999999994-2.2862183999999988-1.5272183999999995-0.76821839999999941-9.2183999999995957E-3-9.2183999999995957E-3
1710880$F$163*(F18*Conversion.to.average.power)-0.10141531399999998-0.42800030000000017-1.2242503-2.1359574600000002-2.9825432000000003-2.7390999999999996-1.8427499999999997-0.8189999999999998400
26332$F$164*(F19*Conversion.to.average.power)0000000000
9641600$F$165*(F20*Conversion.to.average.power)-1.5519999999999998E-3-2.5608000000000002E-3-1.2415999999999998E-30000000
15821602$F$167*(F21*Conversion.to.average.power)0000000000
1960SUM(F308:F313)-10.661031382922566SUM(G308:G313)-10.194491769028607-11.572815310772214-13.126633788452914-14.30634498778557-13.273908458911897-11.856238349225354-10.333176053904808-9.0372136985511382-9.3349309420844122
|
1961Preferences.EnergyUnits&"e"TWhe
|
7434184422007201020152020202520302035204020452050
67629F308*Conversion.to.energy.per.second*$F$146*Unit.day-0.24083513579814153-0.20834573445668658-0.20413116025853315-0.2013556302828699-0.1988184813068537-0.19796616141388557-0.20367047878140854-0.20990298369371543-0.21667188716522731-0.22381710101002586
1709879-1.2558401855999997E-2-2.5988601599999984E-2-4.4204601599999976E-2-6.2420601599999993E-2-7.2952761599999985E-2-5.4869241599999966E-2-3.665324159999999E-2-1.8437241599999984E-2-2.2124159999999029E-4-2.2124159999999029E-4
1710880F310*Conversion.to.energy.per.second*$F$146*Unit.day-2.4339675359999996E-3-1.0272007200000004E-2-2.9382007199999997E-2-5.1262979040000003E-2-7.1581036799999997E-2-6.5738399999999989E-2-4.4225999999999988E-2-1.9655999999999996E-200
26332F311*Conversion.to.energy.per.second*$F$146*Unit.day0G311*Conversion.to.energy.per.second*$F$146*Unit.day000000000
9641600F312*Conversion.to.energy.per.second*$F$146*Unit.day-3.7247999999999993E-5G312*Conversion.to.energy.per.second*$F$146*Unit.day-6.1459199999999996E-5-2.9798399999999992E-50000000
15821602F313*Conversion.to.energy.per.second*$F$146*Unit.day0G313*Conversion.to.energy.per.second*$F$146*Unit.day000000000
1960SUM(F319:F324)-0.25586475319014151SUM(G319:G324)-0.24466780245668659-0.27774756745853313-0.31503921092286991-0.34335227970685367-0.31857380301388549-0.28454972038140852-0.24799622529371543-0.21689312876522729-0.22403834261002584
|
31962
|
1963Preferences.PowerUnits&"e"GWe
|
4184422007201020152020202520302035204020452050
1964F314-10.661031382922566G314-10.194491769028607-11.572815310772214-13.126633788452914-14.30634498778557-13.273908458911897-11.856238349225354-10.333176053904808-9.0372136985511382-9.3349309420844122
2628F332+F358-10.661031382922566G332+G358-10.194491769028607-11.572815310772214-13.126633788452914-14.30634498778557-13.273908458911897-11.856238349225354-10.333176053904801-9.0372136985511382-9.3349309420844122
"…after "&D228…after boosting thermal plantF333+F359000-0.58155170525733091-2.4358894189679638-1.6284118655402260000
"…after "&D229…after drawing from interconnectionF334+F3600000000000
"…after "&D230…after shifting demand from electric vehiclesF335+F3610000000000
"…after "&D231…after drawing from pumped storageF336+F3620000000000
1969F3370G337000000000
|
41971
|
1970Preferences.EnergyUnits&"e"TWhe
|
4184422007201020152020202520302035204020452050
1964F325-0.25586475319014151G325-0.24466780245668659-0.27774756745853313-0.31503921092286991-0.34335227970685367-0.31857380301388549-0.28454972038140852-0.24799622529371543-0.21689312876522729-0.22403834261002584
2628F345+F368-0.25586475319014151-0.24466780245668659-0.27774756745853313-0.31503921092286991-0.34335227970685367-0.31857380301388549-0.28454972038140852-0.24799622529371526-0.21689312876522729-0.22403834261002584
"…after "&D238…after boosting thermal plant000-1.3957240926175951E-2-5.8461346055231123E-2-3.908188477296537E-20000
"…after "&D239…after drawing from interconnection0000000000
"…after "&D240…after shifting demand from electric vehicles0000000000
"…after "&D241…after drawing from pumped storage0000000000
1978F3500000000000
|
51976
|
1972Preferences.PowerUnits&"e"GWe
|
4184422007201020152020202520302035204020452050
2598MIN(ABS(F332),F227)00000006.4845332946392885E-1500
1965MIN(ABS(F333),F228)10.66103138292256610.19449176902860711.57281531077221412.54508208319558311.87045556881760611.64549659337167111.85623834922535410.3331760539048019.03721369855113829.3349309420844122
1966MIN(ABS(F334),F229)0000.581551705257330912.43588941896796381.6284118655402260000
1967MIN(ABS(F335),F230)0000000000
1968MIN(ABS(F336),F231)0000000000
1974SUM(F358:F362)10.661031382922566SUM(G358:G362)10.19449176902860711.57281531077221413.12663378845291414.3063449877855713.27390845891189711.85623834922535410.3331760539048089.03721369855113829.3349309420844122
|
1973Preferences.EnergyUnits&"e"TWhe
|
4184422007201020152020202520302035204020452050
2598MIN(ABS(F345),F237)00000001.556287990713429E-1600
1965MIN(ABS(F346),F238)0.255864753190141510.244667802456686590.277747567458533130.301081969996693950.284890933651622550.279491918240920120.284549720381408520.247996225293715260.216893128765227290.22403834261002584
1966MIN(ABS(F347),F239)0001.3957240926175951E-25.8461346055231123E-23.908188477296537E-20000
1967MIN(ABS(F348),F240)0000000000
1968MIN(ABS(F349),F241)0000000000
1975SUM(F368:F372)0.25586475319014151SUM(G368:G372)0.244667802456686590.277747567458533130.315039210922869910.343352279706853670.318573803013885490.284549720381408520.247996225293715430.216893128765227290.22403834261002584
|
19721977
|
4184422007201020152020202520302035204020452050
2598IF(F227=0,0,F358/F227)0000000100
1965IF(F228=0,0,F359/F228)0.593867145145876130.662786858583024110.844661587672262291110.937939626940909820.758082961736169620.618984713930602060.61330965943428872
1966IF(F229=0,0,F360/F229)0000.145387926314332730.608972354741990960.40710296638505650000
1967IF(F230=0,0,F361/F230)0000000000
1968IF(F231=0,0,F362/F231)0000000000
1974IF(F232=0,0,F363/F232)0.445102081329713520.476795826323228640.545858508013924330.654855576743054610.738565230794871130.693317532620565950.588669843506860250.489013256584859390.40892259445923540.41085788586167438
|
19731977
|
4184422007201020152020202520302035204020452050
2598IF(F237=0,0,F368/F237)0000000100
1965IF(F238=0,0,F369/F238)0.593867145145875910.662786858583024220.844661587672262511110.937939626940909930.758082961736169740.618984713930602060.61330965943428861
1966IF(F239=0,0,F370/F239)0000.193850568419110440.811963139655987880.542803955180074630000
1967IF(F240=0,0,F371/F240)0000000000
1968IF(F241=0,0,F372/F241)0000000000
1975IF(F242=0,0,F373/F242)0.508834132141593120.554613565298715750.649205270342078530.787436661855752120.894400595608862760.841692484464370510.707171163167675480.581964976427973850.482626699424740070.48253550457251765
|
20011977
|
4184422007201020152020202520302035204020452050
2598MAX(F388,F378)0MAX(G388,G378)000000100
1965MAX(F389,F379)0.593867145145876130.662786858583024220.844661587672262511110.937939626940909930.758082961736169740.618984713930602060.61330965943428872
1966MAX(F390,F380)0000.193850568419110440.811963139655987880.542803955180074630000
19670000000000
19680000000000
19990.508834132141593120.554613565298715750.649205270342078530.787436661855752120.894400595608862760.841692484464370510.707171163167675480.581964976427973850.482626699424740070.48253550457251765
|
61985
|
19792007201020152020202520302035204020452050
1980Preferences.EnergyUnits&"e"TWheF3510000000000
14251981Preferences.PowerUnits&"e"GWeF408/(Conversion.to.energy.per.second*$F$146*Unit.day)0000000000
14261964Preferences.PowerUnits&"e"GWeF3380000000000
1982Preferences.PowerUnits&"e"GWeMIN(F409:F410)0MIN(G409:G410)000000000
1986Preferences.PowerUnits&"capacity"GWcapacity-F411/$F$1810-G411/$F$181000000000
|
71997
|
1993INDIRECT("EF."&$F$183&".CO2")+INDIRECT("EF."&$F$183&".CH4")+INDIRECT("EF."&$F$183&".N2O")0.18476551498713398"MtCO2e/"&Preferences.EnergyUnits&"th"MtCO2e/TWhth
|
19792007201020152020202520302035204020452050
1980Preferences.EnergyUnits&"e"TWheF3510G351000000000
1994Preferences.EnergyUnits&"th"TWhthF419/$F$1820G419/$F$182000000000
19951996$E$416*-F4200$E$416*-G420000000000
|
19981996F421*$F$1470000000000
|
|
2702
|
2708
|
782703442691692720721722723724725726727
2704INDEX(Vectors[Description], MATCH(VII.c.Info83[Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH(VII.c.Info83[Information type], Vectors[Description], 0))0
2710INDEX(Vectors[Description], MATCH(VII.c.Info83[Vector], Vectors[Code], 0))Installed Capacity INDEX(Vectors[Comment], MATCH(VII.c.Info83[Information type], Vectors[Description], 0))0F4120000000000
2711INDEX(Vectors[Description], MATCH(VII.c.Info83[Vector], Vectors[Code], 0))Number of units
27642000840F4030.50883413214159312G4030.554613565298715750.649205270342078530.787436661855752120.894400595608862760.841692484464370510.707171163167675480.581964976427973850.482626699424740070.48253550457251765
|
|
|
|
890
|
10611064
|
10601030442691692720721722723724725726727
10431053INDIRECT("EF."&$F$183&"."&$C444)*-F$420*$F$1470000000000
104410530000000000
104510530000000000
148SUBTOTAL(109,VII.c.Emissions75[2007])0SUBTOTAL(109,VII.c.Emissions75[2010])0SUBTOTAL(109,VII.c.Emissions75[2015])0SUBTOTAL(109,VII.c.Emissions75[2020])0SUBTOTAL(109,VII.c.Emissions75[2025])0SUBTOTAL(109,VII.c.Emissions75[2030])0SUBTOTAL(105,VII.c.Emissions75[2035])0SUBTOTAL(109,VII.c.Emissions75[2040])0SUBTOTAL(109,VII.c.Emissions75[2045])0SUBTOTAL(109,VII.c.Emissions75[2050])0
|
|
|
2773
Preferences.PowerUnits&"e"GWe2766276527752776
2780-O22*Conversion.to.average.power51.381541932908185
2779E45351.381541932908185G4710
2777E453+G45451.381541932908185
27672781E45551.381541932908185O269-O2739.3602876794769756
2782F456+G45660.74182961238516O271-O269+O252-O249+O2540
2783F457+G45760.74182961238516O2490
2786F458+G458-H45959.796320448190166-O2770.94550916419499553
522784F45959.796320448190166O291-O2952.9590964234283437
2785F460+G46062.755416871618507O294-O291+O2850
2787F461+G461-H46260.707254474992595-O2992.0481623966259122
2772E455+SUM(G456:G462)-SUM(H456:H462)60.707254474992595
|
2778E45551.381541932908185
512768E465-H46651.372323532908183-O3099.2183999999995957E-3
2769F466-H46751.372323532908183-O3100
2803F467-H46851.372323532908183-O3110
2770F468-H46951.372323532908183-O3120
2771F469-H47051.372323532908183-O3130
282788F47051.372323532908183O3580
2789F471+G47151.372323532908183O3599.3349309420844122
2790F472+G47260.707254474992595O3600
2791F473+G47360.707254474992595O3610
2792F474+G47460.707254474992595O3620
27742793F475+G47560.707254474992595-O3380
2794F476-G47760.707254474992595MAX(-(O411-O410),0)0
2772E465+SUM(G466:G476)-SUM(H466:H476)60.707254474992595
IF(ABS(E478-E463)<1,"balanced",E478-E463)balanced