77INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Distributed renewable power generation
1313INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Solar thermal
1337
|
|
8251336
1339IV.b.Scenario2
|
1338
|
16001598
|
1336794422007201020152020202520302035204020452050
10$F16+($O16-$F16)/($O$15-$F$15)*(G$15-$F$15)0$F16+($O16-$F16)/($O$15-$F$15)*(H$15-$F$15)00000000
20$F17+($O17-$F17)/($O$15-$F$15)*(G$15-$F$15)6.9767441860465115E-20.186046511627906970.302325581395348820.418604651162790660.534883720930232510.651162790697674470.767441860465116310.883720930232558161
30$F18+($O18-$F18)/($O$15-$F$15)*(G$15-$F$15)0.209302325581395330.558139534883720920.906976744186046461.25581395348837211.60465116279069761.95348837209302322.30232558139534892.65116279069767423
40$F19+($O19-$F19)/($O$15-$F$15)*(G$15-$F$15)0.418604651162790661.11627906976744181.81395348837209292.51162790697674423.20930232558139533.90697674418604634.60465116279069795.30232558139534856
1280(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.883720930232558161
|
717
1091245
2203
|
784
|
1255839
|
7157304422007201020152020202520302035204020452050
33INDEX(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.5
|
22432244
|
7157304422007201020152020202520302035204020452050
45INDEX(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-2
|
32582*Global.UKIncidentSolarEnergy_SouthFacing*$F$32*Unit.W1.1000000000000001E-7Preferences.PowerUnits&"/average"GW/average
|
|
3170
|
3235
|
3237
324518011799
38243936.0000000000005676.69841269841265
|
"Cost of a "&plantsize.IV.b/Unit.kW&" kWaverage plant"Cost of a 0.11 kWaverage plantPreferences.moneyunits£m
18011799
3176E48*GBP*plantsize.IV.b/Unit.kW4.3296000000000008E-4F48*GBP*plantsize.IV.b/Unit.kW7.4436825396825395E-5
|
14413651
|
|
731
1797
22616
2007201020152020202520302035204020452050
15991246F200G206.9767441860465115E-20.186046511627906970.302325581395348820.418604651162790660.534883720930232510.651162790697674470.767441860465116310.883720930232558161
833851INDEX(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.82008817
83512561246F62*F630G62*G631877958.13953488375296558.13953488329071218.604651162413158753.48837209117514660.46511627722409841.60182337827758856.0204985733595266.45331120539954878.82008817
15961261F64/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.52031707024369689
83312571251Global.UKIncidentSolarEnergy_SouthFacing110110110110110110110110110110
8351258Preferences.EnergyUnits & " / year"TWh / yearF$64*F$66*Unit.year*Unit.J01.81083991562790715.10725915162790678.747013251720931112.68845963869767416.88868650009302321.60891386297420926.76675450632595232.39457163026986638.526891451058219
8331259F$320.5G$320.50.50.50.50.50.50.50.50.5
835161Preferences.EnergyUnits & " / year"TWh / yearF$67*F$680G$67*G$680.905419957813953572.55362957581395334.37350662586046566.34422981934883718.444343250046511410.80445693148710413.38337725316297616.19728581513493319.26344572552911
|
8332245$F377.1428571428571425E-2$F377.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-27.1428571428571425E-2
8351143Preferences.EnergyUnits & " / year"TWh / yearF$69*F710G$69*G716.4672854129568108E-20.182402112558139510.312393330418604680.453159272810631180.603167375003322180.77174692367765030.955955518083069671.15694898679535221.3759604089663648
|
2616698F69/((1/Unit.W)*Unit.year*Unit.J)00.103287697674418620.291310697674418580.4989170232558140.723731441860465120.963306325581395281.23254128810028571.52673708112742151.84773965493211662.1975183351048493
G740.10328769767441862IF((H74-G74)>0,H74-G74,0)0.18802299999999997IF((I74-H74)>0,I74-H74,0)0.207606325581395410.224814418604651120.239574883720930170.269234962518890450.294195793027135720.32100257380469510.34977868017273273
|
3446"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.410044085
3825G77938979.06976744195H772648279.06976744164535609.30232558126579376.74418604658757330.2325581387
3826G77+G78938979.06976744195H77+H782648279.06976744164535609.30232558126579376.74418604659696309.302325580313853199.87067912918415037.31257486723377009.9708416528734769.642602224
3447G79/(G61-F61)312993.02325581398H79/(H61-G61)529655.81395348837907121.860465116221315875.34883720941939261.86046511612770639.97413582593683007.46251497324675401.994168335746953.9285204448
|
3183288
3176Preferences.moneyunits£m(F80*$G$52)0(G80*$G$52)23.29820702251753439.42589734366924967.52327154108526597.949583585382058144.35249650616461206.23764399221329274.15138342243199348.02208189987726(O80*$G$52)427.78500614087613
3177Preferences.moneyunits£m
3184Preferences.moneyunits£mSUM(F83:F84)0SUM(G83:G84)23.29820702251753439.42589734366924967.52327154108526597.949583585382058144.35249650616461206.23764399221329274.15138342243199348.02208189987726427.78500614087613
|
3185
3176Preferences.moneyunits£m(F80*$F$52)0(G80*$F$52)135.51345934883724229.31978120930236392.74748070697677569.72139103255824839.622815106976871199.57628320184741594.59491097048322024.2620473951206(O80*$F$52)2488.2011728922121
3177Preferences.moneyunits£m
3184Preferences.moneyunits£mSUM(F88:F89)0SUM(G88:G89)135.51345934883724229.31978120930236392.74748070697677569.72139103255824839.622815106976871199.57628320184741594.59491097048322024.26204739512062488.2011728922121
|
683
|
729Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
1315INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Domestic solar thermalF$690G$690.905419957813953572.55362957581395334.37350662586046566.34422981934883718.444343250046511410.80445693148710413.38337725316297616.19728581513493319.26344572552911
33INDEX(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.26344572552911
45INDEX(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.3759604089663648
57INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Lighting & appliancesF$720G$726.4672854129568108E-20.182402112558139510.312393330418604680.453159272810631180.603167375003322180.77174692367765030.955955518083069671.15694898679535221.3759604089663648
148SUBTOTAL(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])0
|
2613
|
2618
|
782614442691692720721722723724725726727
26152814Preferences.AreaUnitskm^2F64*Unit.m201.87795813953488375.29655813953488339.071218604651161113.1587534883720917.51466046511627522.40984160182337727.7588560204985733.59526645331120439.954878820088169
2620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF7400.103287697674418620.291310697674418580.4989170232558140.723731441860465120.963306325581395281.23254128810028571.52673708112742151.84773965493211662.1975183351048493
|
3189
|
3190
|
78418442691692720721722723724725726727
3131INDEX(CostVectors[Description], MATCH(C119, CostVectors[Code], 0))Low estimate of capital costsF830G8323.29820702251753439.42589734366924967.52327154108526597.949583585382058144.35249650616461206.23764399221329274.15138342243199348.02208189987726427.78500614087613
3133INDEX(CostVectors[Description], MATCH(C120, CostVectors[Code], 0))Low estimate of operating costsF840000000000
3135INDEX(CostVectors[Description], MATCH(C121, CostVectors[Code], 0))Low estimate of fuel costs
3140INDEX(CostVectors[Description], MATCH(C122, CostVectors[Code], 0))High estimate of capital costsF880G88135.51345934883724229.31978120930236392.74748070697677569.72139103255824839.622815106976871199.57628320184741594.59491097048322024.26204739512062488.2011728922121
3142INDEX(CostVectors[Description], MATCH(C123, CostVectors[Code], 0))High estimate of operating costsF890000000000
3144INDEX(CostVectors[Description], MATCH(C124, CostVectors[Code], 0))High estimate of fuel costs
|