77INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Distributed renewable power generation1313INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Solar thermal133782513361339IV.b.Scenario2133816001598133679442200720102015202020252030203520402045205010$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.302325581395348561280(INDEX(F$16:F$19,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(F$16:F$19,ROUNDUP($E$8,0))*MOD($E$8,1))0(INDEX(G$16:G$19,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(G$16:G$19,ROUNDUP($E$8,0))*MOD($E$8,1))6.9767441860465115E-20.186046511627906970.302325581395348820.418604651162790660.534883720930232510.651162790697674470.767441860465116310.883720930232558161717109124522037841255839715730442200720102015202020252030203520402045205033INDEX(Vectors[Description], MATCH($C32, Vectors[Code], 0))Solar0.5$F32+($O32-$F32)/($O$31-$F$31)*(G$31-$F$31)0.5$F32+($O32-$F32)/($O$31-$F$31)*(H$31-$F$31)0.50.50.50.50.50.50.50.522432244715730442200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($C37, Vectors[Code], 0))Electricity (delivered to end user)1/147.1428571428571425E-2$F37+($O37-$F37)/($O$31-$F$31)*(G$31-$F$31)7.1428571428571425E-2$F37+($O37-$F37)/($O$31-$F$31)*(H$31-$F$31)7.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-232582*Global.UKIncidentSolarEnergy_SouthFacing*$F$32*Unit.W1.1000000000000001E-7Preferences.PowerUnits&"/average"GW/average31703235323732451801179938243936.0000000000005676.69841269841265"Cost of a "&plantsize.IV.b/Unit.kW&" kWaverage plant"Cost of a 0.11 kWaverage plantPreferences.moneyunits£m180117993176E48*GBP*plantsize.IV.b/Unit.kW4.3296000000000008E-4F48*GBP*plantsize.IV.b/Unit.kW7.4436825396825395E-514413651731179722616200720102015202020252030203520402045205015991246F200G206.9767441860465115E-20.186046511627906970.302325581395348820.418604651162790660.534883720930232510.651162790697674470.767441860465116310.883720930232558161833851INDEX(Global.Assumptions[Households], MATCH(F$61, Global.Assumptions[Year], 0))26042600INDEX(Global.Assumptions[Households], MATCH(G$61, Global.Assumptions[Year], 0))26917400INDEX(Global.Assumptions[Households], MATCH(H$61, Global.Assumptions[Year], 0))28469000INDEX(Global.Assumptions[Households], MATCH(I$61, Global.Assumptions[Year], 0))30004800INDEX(Global.Assumptions[Households], MATCH(J$61, Global.Assumptions[Year], 0))31434800INDEX(Global.Assumptions[Households], MATCH(K$61, Global.Assumptions[Year], 0))32744800INDEX(Global.Assumptions[Households], MATCH(L$61, Global.Assumptions[Year], 0))34415113.888514474INDEX(Global.Assumptions[Households], MATCH(M$61, Global.Assumptions[Year], 0))36170630.572164804INDEX(Global.Assumptions[Households], MATCH(N$61, Global.Assumptions[Year], 0))38015696.24979952INDEX(Global.Assumptions[Households], MATCH(O$61, Global.Assumptions[Year], 0))39954878.8200881783512561246F62*F630G62*G631877958.13953488375296558.13953488329071218.604651162413158753.48837209117514660.46511627722409841.60182337827758856.0204985733595266.45331120539954878.8200881715961261F64/INDEX(Global.Assumptions[Population], MATCH(F$61, Global.Assumptions[Year], 0))0G64/INDEX(Global.Assumptions[Population], MATCH(G$61, Global.Assumptions[Year], 0))3.0181382411972803E-2H64/INDEX(Global.Assumptions[Population], MATCH(H$61, Global.Assumptions[Year], 0))8.2316071401027979E-2I64/INDEX(Global.Assumptions[Population], MATCH(I$61, Global.Assumptions[Year], 0))0.13636426725734821J64/INDEX(Global.Assumptions[Population], MATCH(J$61, Global.Assumptions[Year], 0))0.19168575871183724K64/INDEX(Global.Assumptions[Population], MATCH(K$61, Global.Assumptions[Year], 0))0.24816854672141922L64/INDEX(Global.Assumptions[Population], MATCH(L$61, Global.Assumptions[Year], 0))0.31004967335009964M64/INDEX(Global.Assumptions[Population], MATCH(M$61, Global.Assumptions[Year], 0))0.37586504172671403N64/INDEX(Global.Assumptions[Population], MATCH(N$61, Global.Assumptions[Year], 0))0.44581801407533256O64/INDEX(Global.Assumptions[Population], MATCH(O$61, Global.Assumptions[Year], 0))0.5203170702436968983312571251Global.UKIncidentSolarEnergy_SouthFacing1101101101101101101101101101108351258Preferences.EnergyUnits & " / year"TWh / yearF$64*F$66*Unit.year*Unit.J01.81083991562790715.10725915162790678.747013251720931112.68845963869767416.88868650009302321.60891386297420926.76675450632595232.39457163026986638.5268914510582198331259F$320.5G$320.50.50.50.50.50.50.50.50.5835161Preferences.EnergyUnits & " / year"TWh / yearF$67*F$680G$67*G$680.905419957813953572.55362957581395334.37350662586046566.34422981934883718.444343250046511410.80445693148710413.38337725316297616.19728581513493319.263445725529118332245$F377.1428571428571425E-2$F377.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-28351143Preferences.EnergyUnits & " / year"TWh / yearF$69*F710G$69*G716.4672854129568108E-20.182402112558139510.312393330418604680.453159272810631180.603167375003322180.77174692367765030.955955518083069671.15694898679535221.37596040896636482616698F69/((1/Unit.W)*Unit.year*Unit.J)00.103287697674418620.291310697674418580.4989170232558140.723731441860465120.963306325581395281.23254128810028571.52673708112742151.84773965493211662.1975183351048493G740.10328769767441862IF((H74-G74)>0,H74-G74,0)0.18802299999999997IF((I74-H74)>0,I74-H74,0)0.207606325581395410.224814418604651120.239574883720930170.269234962518890450.294195793027135720.32100257380469510.349778680172732733446"Number of "&plantsize.IV.b/Unit.kW&" kWaverage plant"Number of 0.11 kWaverage plantF74/plantsize.IV.b0G74/plantsize.IV.b938979.06976744195H74/plantsize.IV.b2648279.06976744164535609.30232558126579376.74418604658757330.232558138711204920.80091168713879428.01024928516797633.22665560219977439.4100440853825G77938979.06976744195H772648279.06976744164535609.30232558126579376.74418604658757330.23255813873826G77+G78938979.06976744195H77+H782648279.06976744164535609.30232558126579376.74418604659696309.302325580313853199.87067912918415037.31257486723377009.9708416528734769.6426022243447G79/(G61-F61)312993.02325581398H79/(H61-G61)529655.81395348837907121.860465116221315875.34883720941939261.86046511612770639.97413582593683007.46251497324675401.994168335746953.928520444831832883176Preferences.moneyunits£m(F80*$G$52)0(G80*$G$52)23.29820702251753439.42589734366924967.52327154108526597.949583585382058144.35249650616461206.23764399221329274.15138342243199348.02208189987726(O80*$G$52)427.785006140876133177Preferences.moneyunits£m3184Preferences.moneyunits£mSUM(F83:F84)0SUM(G83:G84)23.29820702251753439.42589734366924967.52327154108526597.949583585382058144.35249650616461206.23764399221329274.15138342243199348.02208189987726427.7850061408761331853176Preferences.moneyunits£m(F80*$F$52)0(G80*$F$52)135.51345934883724229.31978120930236392.74748070697677569.72139103255824839.622815106976871199.57628320184741594.59491097048322024.2620473951206(O80*$F$52)2488.20117289221213177Preferences.moneyunits£m3184Preferences.moneyunits£mSUM(F88:F89)0SUM(G88:G89)135.51345934883724229.31978120930236392.74748070697677569.72139103255824839.622815106976871199.57628320184741594.59491097048322024.26204739512062488.2011728922121683729Preferences.EnergyUnitsTWh784184426916927207217227237247257267271315INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Domestic solar thermalF$690G$690.905419957813953572.55362957581395334.37350662586046566.34422981934883718.444343250046511410.80445693148710413.38337725316297616.19728581513493319.2634457255291133INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solar-F$690-G$69-0.90541995781395357-2.5536295758139533-4.3735066258604656-6.3442298193488371-8.4443432500465114-10.804456931487104-13.383377253162976-16.197285815134933-19.2634457255291145INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-F$720-G$72-6.4672854129568108E-2-0.18240211255813951-0.31239333041860468-0.45315927281063118-0.60316737500332218-0.7717469236776503-0.95595551808306967-1.1569489867953522-1.375960408966364857INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Lighting & appliancesF$720G$726.4672854129568108E-20.182402112558139510.312393330418604680.453159272810631180.603167375003322180.77174692367765030.955955518083069671.15694898679535221.3759604089663648148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])02613261878261444269169272072172272372472572672726152814Preferences.AreaUnitskm^2F64*Unit.m201.87795813953488375.29655813953488339.071218604651161113.1587534883720917.51466046511627522.40984160182337727.7588560204985733.59526645331120439.9548788200881692620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF7400.103287697674418620.291310697674418580.4989170232558140.723731441860465120.963306325581395281.23254128810028571.52673708112742151.84773965493211662.197518335104849331893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C119, CostVectors[Code], 0))Low estimate of capital costsF830G8323.29820702251753439.42589734366924967.52327154108526597.949583585382058144.35249650616461206.23764399221329274.15138342243199348.02208189987726427.785006140876133133INDEX(CostVectors[Description], MATCH(C120, CostVectors[Code], 0))Low estimate of operating costsF8400000000003135INDEX(CostVectors[Description], MATCH(C121, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C122, CostVectors[Code], 0))High estimate of capital costsF880G88135.51345934883724229.31978120930236392.74748070697677569.72139103255824839.622815106976871199.57628320184741594.59491097048322024.26204739512062488.20117289221213142INDEX(CostVectors[Description], MATCH(C123, CostVectors[Code], 0))High estimate of operating costsF8900000000003144INDEX(CostVectors[Description], MATCH(C124, CostVectors[Code], 0))High estimate of fuel costs