77INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Distributed renewable power generation963INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Solar PV133782513361339IV.a.Scenario213382202Preferences.PowerUnitsGW133679442200720102015202020252030203520402045205010.02*Unit.GW0.020.033*Unit.GW3.3000000000000002E-20.016*Unit.GW1.6E-200000002(Unit.GW)*0.020.02(Unit.GW)*0.048122084.8122079999999998E-2(Unit.GW)*0.2079066509090.20790665090900001(Unit.GW)*0.8982399657744830.89823996577448295(Unit.GW)*2.282062891330072.28206289133007(Unit.GW)*5.797794841488125.7977948414881197(Unit.GW)*10.824613357990810.824613357990801(Unit.GW)*20.209796578438220.209796578438201(Unit.GW)*37.732144718161337.732144718161301(Unit.GW)*70.446762762136270.4467627621362033(Unit.GW)*0.01995979054785881.9959790547858802E-2(Unit.GW)*0.06084991645896616.0849916458966098E-2(Unit.GW)*0.3900317822273150.39003178222731499(Unit.GW)*2.52.5(Unit.GW)*6.351484509382816.3514845093828098(Unit.GW)*16.136542189171916.136542189171902(Unit.GW)*25.114105018720325.114105018720299(Unit.GW)*39.086333583569339.086333583569299(Unit.GW)*60.832009417307960.832009417307901(Unit.GW)*94.675888743451694.6758887434515944(Unit.GW)*0.01800854871641811.8008548716418101E-2(Unit.GW)*0.09651456577705339.6514565777053293E-2(Unit.GW)*1.584101862319271.58410186231927(Unit.GW)*2626(Unit.GW)*105.373530302408105.373530302408(Unit.GW)*149.05450745547149.05450745547(Unit.GW)*161.203630911659161.20363091165899(Unit.GW)*164.012992568036164.012992568036(Unit.GW)*164.635504556198164.63550455619799(Unit.GW)*164.77214623702164.772146237021280(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.02(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))4.8122079999999998E-20.207906650909000010.898239965774482952.282062891330075.797794841488119710.82461335799080120.20979657843820137.73214471816130170.4467627621362037171091245784800715730442200720102015202020252030203520402045205033INDEX(Vectors[Description], MATCH($C31, Vectors[Code], 0))Solar9.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-21998839715730442200720102015202020252030203520402045205033INDEX(Vectors[Description], MATCH($C36, Vectors[Code], 0))Solar0.20.20.20.20.20.20.20.20.20.232582.5*Unit.kW2.4999999999999998E-633603170323732451801179932558192.1562532380067650323617993243180132563359180117993176109E45*plantsize.IV.a*GBP/Unit.kW2.0480390633095015E-2F45*plantsize.IV.a*GBP/Unit.kW1.6249999999999999E-33177004421093259812762Preferences.PowerUnitsGW71579442200720102015202020252030203520402045205033INDEX(Vectors[Description], MATCH($C67, Vectors[Code], 0))SolarF200.02G204.8122079999999998E-20.207906650909000010.898239965774482952.282062891330075.797794841488119710.82461335799080120.20979657843820137.73214471816130170.446762762136203731179720072010201520202025203020352040204520501999801Preferences.PowerUnitsGWF$670.02G$674.8122079999999998E-20.207906650909000010.898239965774482952.282062891330075.797794841488119710.82461335799080120.20979657843820137.73214471816130170.446762762136203833800F$319.7000000000000003E-2G$319.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-29.7000000000000003E-28351260F76*F771.9400000000000001E-34.6678417600000003E-32.0166945138173003E-28.7129276680124851E-20.22136010045901680.56238609962434761.04998749572510761.96035026810850573.66001803766164626.833335987927212548Preferences.EnergyUnitsTWhF78*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy1.700604E-24.0918300868160007E-20.176783441081224540.763775239377974421.94044264062374144.92987654930703119.204190387526294317.18443045023916232.083718118141988O78*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy59.90102327016993720002002Preferences.PowerUnitsGWF78/F$369.7000000000000003E-3G78/G$362.33392088E-20.1008347256908650.435646383400624231.1068005022950842.81193049812173795.24993747862553759.801751340542526918.30009018830822934.16667993963605520012003Preferences.PowerUnits & " / m2"GW / m2Global.UKIncidentSolarEnergy_SouthFacing*Unit.W1.1000000000000001E-71.1000000000000001E-71.1000000000000001E-71.1000000000000001E-71.1000000000000001E-71.1000000000000001E-71.1000000000000001E-71.1000000000000001E-71.1000000000000001E-71.1000000000000001E-783520061246F82/F8388181.818181818177G82/G83212174.62545454546916679.324462409133960421.66727840210061822.74813712625563004.52837943347726704.35114124489106830.36856842166364456.25734752310606181.2694186620041261F84/INDEX(Global.Assumptions[Households], MATCH(F$74, Global.Assumptions[Year], 0))3.3860604617748681E-3G84/INDEX(Global.Assumptions[Households], MATCH(G$74, Global.Assumptions[Year], 0))7.8824338700820094E-3H84/INDEX(Global.Assumptions[Households], MATCH(H$74, Global.Assumptions[Year], 0))3.2199210525919744E-2I84/INDEX(Global.Assumptions[Households], MATCH(I$74, Global.Assumptions[Year], 0))0.13199293670607376J84/INDEX(Global.Assumptions[Households], MATCH(J$74, Global.Assumptions[Year], 0))0.32008547050202724K84/INDEX(Global.Assumptions[Households], MATCH(K$74, Global.Assumptions[Year], 0))0.78067371089087223L84/INDEX(Global.Assumptions[Households], MATCH(L$74, Global.Assumptions[Year], 0))1.3867948978971507M84/INDEX(Global.Assumptions[Households], MATCH(M$74, Global.Assumptions[Year], 0))2.4635133244577938N84/INDEX(Global.Assumptions[Households], MATCH(N$74, Global.Assumptions[Year], 0))4.3762043752710396O84/INDEX(Global.Assumptions[Households], MATCH(O$74, Global.Assumptions[Year], 0))7.773923747035737220051261F84/INDEX(Global.Assumptions[Population], MATCH(F$74, Global.Assumptions[Year], 0))1.4462437174129234E-3G84/INDEX(Global.Assumptions[Population], MATCH(G$74, Global.Assumptions[Year], 0))3.4099394305704563E-3H84/INDEX(Global.Assumptions[Population], MATCH(H$74, Global.Assumptions[Year], 0))1.4246504755807335E-2I84/INDEX(Global.Assumptions[Population], MATCH(I$74, Global.Assumptions[Year], 0))5.9535551090306116E-2J84/INDEX(Global.Assumptions[Population], MATCH(J$74, Global.Assumptions[Year], 0))0.14657225163500609K84/INDEX(Global.Assumptions[Population], MATCH(K$74, Global.Assumptions[Year], 0))0.36220706055227919L84/INDEX(Global.Assumptions[Population], MATCH(L$74, Global.Assumptions[Year], 0))0.66031921854120157M84/INDEX(Global.Assumptions[Population], MATCH(M$74, Global.Assumptions[Year], 0))1.2065390047012339N84/INDEX(Global.Assumptions[Population], MATCH(N$74, Global.Assumptions[Year], 0))2.2077000521620525O84/INDEX(Global.Assumptions[Population], MATCH(O$74, Global.Assumptions[Year], 0))4.0449052283555371273932572740F76/plantsize.IV.a8000.0000000000009G76/plantsize.IV.a19248.83200000000283162.660363600007359295.9863097932912825.156532028112319117.93659524814329845.34319632038083918.631375281115092857.88726452228178705.1048544833821IF($E$8=1,0,-G67)-4.8122079999999998E-2IF($E$8=1,0,-H67)-0.20790665090900001-0.89823996577448295-2.2820628913300738222740J92/Unit.kW*2.500-120305.20000000001-519766.62727250007-2245599.9144362076-5705157.22832517613823G91-G9319248.832000000002H91-H9383162.660363600007I91-I93359295.9863097932912825.156532028112319117.93659524814450150.54319632058603685.258647780917338457.8017007333883862.333179663249IF(((G94-F91)/(G$30-F$30))>0,(G94-F91)/(G$30-F$30),0)3749.6106666666674IF(((H94-G91)/(H$30-G$30))>0,(H94-G91)/(H$30-G$30),0)12782.765672720001IF(((I94-H91)/(I$30-H$30))>0,(I94-H91)/(I$30-H$30),0)55226.665189238636110705.83404444698281258.55601264397426206.5213202145854767.983090292081850907.83406508973758200.889183028131832883176Preferences.moneyunits£m(F95*$G$54)0(G95*$G$54)6.0931173333333346(H95*$G$54)20.77199421817000189.743330932512777179.89698032222634457.04515352054642692.585597145348521388.99797252172453007.7252303557707(O95*$G$54)6107.07644492242073177Preferences.moneyunits£m00000000003184Preferences.moneyunits£mSUM(F98:F99)0SUM(G98:G99)6.093117333333334620.77199421817000189.743330932512777179.89698032222634457.04515352054642692.585597145348521388.99797252172453007.72523035577076107.076444922420731853176Preferences.moneyunits£m(F95*$F$54)0(G95*$F$54)76.793491175353168261.796034348623211131.06367643875752267.29872659286325760.28509603918348728.876047010531717505.98219435193537907.315467508844(O95*$F$54)76969.4222881134483177Preferences.moneyunits£m00000000003184Preferences.moneyunits£mSUM(F103:F104)0SUM(G103:G104)76.793491175353168261.796034348623211131.06367643875752267.29872659286325760.28509603918348728.876047010531717505.98219435193537907.31546750884476969.422288113448683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F$791.700604E-2G$794.0918300868160007E-20.176783441081224540.763775239377974421.94044264062374144.92987654930703119.204190387526294317.18443045023916232.08371811814198859.90102327016993733INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solar-F$79-1.700604E-2-G$79-4.0918300868160007E-2-0.17678344108122454-0.76377523937797442-1.9404426406237414-4.9298765493070311-9.2041903875262943-17.184430450239162-32.083718118141988-59.901023270169937148SUBTOTAL(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])02613261878261444269169272072172272372472572672726152815Preferences.AreaUnitskm^2F84*Unit.m28.8181818181818167E-20.212174625454545430.916679324462409073.960421667278402110.06182274813712525.5630045283794347.72670435114124489.10683036856841166.36445625734751310.606181269418642620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF670.024.8122079999999998E-20.207906650909000010.898239965774482952.282062891330075.797794841488119710.82461335799080120.20979657843820137.73214471816130170.44676276213620331893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C131, CostVectors[Code], 0))Low estimate of capital costsF980G986.093117333333334620.77199421817000189.743330932512777179.89698032222634457.04515352054642692.585597145348521388.99797252172453007.72523035577076107.07644492242073133INDEX(CostVectors[Description], MATCH(C132, CostVectors[Code], 0))Low estimate of operating costsF9900000000003135INDEX(CostVectors[Description], MATCH(C133, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C134, CostVectors[Code], 0))High estimate of capital costsF1030G10376.793491175353168261.796034348623211131.06367643875752267.29872659286325760.28509603918348728.876047010531717505.98219435193537907.315467508844O10376969.4222881134483142INDEX(CostVectors[Description], MATCH(C135, CostVectors[Code], 0))High estimate of operating costsF10400000000003144INDEX(CostVectors[Description], MATCH(C136, CostVectors[Code], 0))High estimate of fuel costs