77INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Distributed renewable power generation1317INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Distributed solar thermal134182613401343IV.b.Scenario1134216081606134079442200720102015202020252030203520402045205010$F16+($O16-$F16)/($O$15-$F$15)*(G$15-$F$15)0$F16+($O16-$F16)/($O$15-$F$15)*(H$15-$F$15)0000000020$F17+($O17-$F17)/($O$15-$F$15)*(G$15-$F$15)6.9767441860465115E-20.186046511627906970.302325581395348820.418604651162790660.534883720930232510.651162790697674470.767441860465116310.88372093023255816130$F18+($O18-$F18)/($O$15-$F$15)*(G$15-$F$15)0.209302325581395330.558139534883720920.906976744186046461.25581395348837211.60465116279069761.95348837209302322.30232558139534892.6511627906976742340$F19+($O19-$F19)/($O$15-$F$15)*(G$15-$F$15)0.418604651162790661.11627906976744181.81395348837209292.51162790697674423.20930232558139533.90697674418604634.60465116279069795.30232558139534856717109124822257841258840715730442200720102015202020252030203520402045205033INDEX(Vectors[Description], MATCH($C31, Vectors[Code], 0))Solar0.5$F31+($O31-$F31)/($O$30-$F$30)*(G$30-$F$30)0.5$F31+($O31-$F31)/($O$30-$F$30)*(H$30-$F$30)0.50.50.50.50.50.50.50.522652266715730442200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($C36, Vectors[Code], 0))Electricity (delivered to end user)1/147.1428571428571425E-2$F36+($O36-$F36)/($O$30-$F$30)*(G$30-$F$30)7.1428571428571425E-2$F36+($O36-$F36)/($O$30-$F$30)*(H$30-$F$30)7.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-2731179822705200720102015202020252030203520402045205016071249INDEX(F$16:F$19, MATCH($E$8, $C$16:$C$19, 0))0INDEX(G$16:G$19, MATCH($E$8, $C$16:$C$19, 0))000000000834852INDEX(Global.Assumptions[Households], MATCH(F$43, Global.Assumptions[Year], 0))26042600INDEX(Global.Assumptions[Households], MATCH(G$43, Global.Assumptions[Year], 0))26917400INDEX(Global.Assumptions[Households], MATCH(H$43, Global.Assumptions[Year], 0))28469000INDEX(Global.Assumptions[Households], MATCH(I$43, Global.Assumptions[Year], 0))30004800INDEX(Global.Assumptions[Households], MATCH(J$43, Global.Assumptions[Year], 0))31434800INDEX(Global.Assumptions[Households], MATCH(K$43, Global.Assumptions[Year], 0))32744800INDEX(Global.Assumptions[Households], MATCH(L$43, Global.Assumptions[Year], 0))34415113.888514474INDEX(Global.Assumptions[Households], MATCH(M$43, Global.Assumptions[Year], 0))36170630.572164804INDEX(Global.Assumptions[Households], MATCH(N$43, Global.Assumptions[Year], 0))38015696.24979952INDEX(Global.Assumptions[Households], MATCH(O$43, Global.Assumptions[Year], 0))39954878.8200881783612591249F44*F450G44*G4500000000016041264F46/INDEX(Global.Assumptions[Population], MATCH(F$43, Global.Assumptions[Year], 0))0G46/INDEX(Global.Assumptions[Population], MATCH(G$43, Global.Assumptions[Year], 0))0H46/INDEX(Global.Assumptions[Population], MATCH(H$43, Global.Assumptions[Year], 0))0I46/INDEX(Global.Assumptions[Population], MATCH(I$43, Global.Assumptions[Year], 0))0J46/INDEX(Global.Assumptions[Population], MATCH(J$43, Global.Assumptions[Year], 0))0K46/INDEX(Global.Assumptions[Population], MATCH(K$43, Global.Assumptions[Year], 0))0L46/INDEX(Global.Assumptions[Population], MATCH(L$43, Global.Assumptions[Year], 0))0M46/INDEX(Global.Assumptions[Population], MATCH(M$43, Global.Assumptions[Year], 0))0N46/INDEX(Global.Assumptions[Population], MATCH(N$43, Global.Assumptions[Year], 0))0O46/INDEX(Global.Assumptions[Population], MATCH(O$43, Global.Assumptions[Year], 0))083412601254Global.UKIncidentSolarEnergy_SouthFacing1101101101101101101101101101108361261Preferences.EnergyUnits & " / year"TWh / yearF$46*F$48*Unit.year*Unit.J00000000008341262F$310.5G$310.50.50.50.50.50.50.50.50.5836161Preferences.EnergyUnits & " / year"TWh / yearF$49*F$500G$49*G$500000000008342267$F367.1428571428571425E-2$F367.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-28361146Preferences.EnergyUnits & " / year"TWh / yearF$51*F530G$51*G530000000002705698F51/((1/Unit.W)*Unit.year*Unit.J)0000000000683729Preferences.EnergyUnitsTWh784184426916927207217227237247257267271319INDEX(Vectors[Description], MATCH(IV.b.Outputs[Vector], Vectors[Code], 0))Domestic solar thermalF$510G$5100000000033INDEX(Vectors[Description], MATCH(IV.b.Outputs[Vector], Vectors[Code], 0))Solar-F$510-G$5100000000045INDEX(Vectors[Description], MATCH(IV.b.Outputs[Vector], Vectors[Code], 0))Electricity (delivered to end user)-F$540-G$5400000000057INDEX(Vectors[Description], MATCH(IV.b.Outputs[Vector], Vectors[Code], 0))Lighting & appliancesF$540G$54000000000148SUBTOTAL(109,IV.b.Outputs[2007])0SUBTOTAL(109,IV.b.Outputs[2010])0SUBTOTAL(109,IV.b.Outputs[2015])0SUBTOTAL(109,IV.b.Outputs[2020])0SUBTOTAL(109,IV.b.Outputs[2025])0SUBTOTAL(109,IV.b.Outputs[2030])0SUBTOTAL(109,IV.b.Outputs[2035])0SUBTOTAL(109,IV.b.Outputs[2040])0SUBTOTAL(109,IV.b.Outputs[2045])0SUBTOTAL(109,IV.b.Outputs[2050])02702270878270344269169272072172272372472572672727043017Preferences.AreaUnitskm^2F46*Unit.m200000000002710INDEX(Vectors[Description], MATCH(IV.b.info[Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF560000000000