1320INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))District heating1322INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))District heating effective demand35376821325Preferences.EnergyUnitsTWh78418442691692720721722723724725726727751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transportINDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-8.8131931365908187INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-8.7994339849696726INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-8.8172853425074926INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-17.032633281024037INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-25.775149507714918INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-34.933235440748291INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-44.875400563684579INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-55.538440853093348INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-66.996019931756763INDEX(INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&XVII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-79.3286488807059137841326418794422007201020152020202520302035204020452050169816991097777777777442109132731703538(200*Unit.MW/4.1)*Conversion.to.annual.energy0.42760975609756108Preferences.EnergyUnitsTWh35395/300.1666666666666666635403541Preferences.moneyunits&"/ unit"£m/ unit17991801317624*MGBP*Price200924.699743740158695F31*249.3994874803173931771%*F310.246997437401586941%*G310.493994874803173897173537731113281329Preferences.EnergyUnitsTWh-XVII.a.Inputs[2007]8.8131931365908187-XVII.a.Inputs[2010]8.7994339849696726-XVII.a.Inputs[2015]8.8172853425074926-XVII.a.Inputs[2020]17.032633281024037-XVII.a.Inputs[2025]25.775149507714918-XVII.a.Inputs[2030]34.933235440748291-XVII.a.Inputs[2035]44.875400563684579-XVII.a.Inputs[2040]55.538440853093348-XVII.a.Inputs[2045]66.996019931756763-XVII.a.Inputs[2050]79.32864888070591313301326F$177G$177777777778351331F40/F411.2590275909415456G40/G411.25706199785281041.25961219178678462.43323332586057673.68216421538784564.9904622058211846.41077150909779727.93406297901333529.570859990250966111.332664125815131332F40-F427.5541655456492727G40-G427.54237198711686227.557673150720708214.59939995516345922.09298529232707229.94277323492710638.4646290545867847.60437787408001557.42515994150579767.99598475489078523542274020072010201520202025203020352040204520503543F40/$F$2520.610364966930383G40/$F$2520.57818807801485820.61993492144690539.83219053855722860.27727183529040681.694196501863999104.94475377087996129.88113592156211156.67561129375008185.5164615622257435483549MAX((G46-F46)/(G45-F45),0)0MAX((H46-G46)/(H45-G45),0)8.3493686864095189E-33.84245112342206464.08901625934663574.28338493331471874.65011145380319144.98727643013643015.35889507443759525.768170053695132435473549(F46*$F$26)/(G45-F45)1.1450202759405768(G46*$F$26)/(H45-G45)0.685939602600495250.687331164048230141.32773968461857412.009242394509682.72313988339546633.49815845902933154.32937119738540325.22252037645833593550SUM(G47:G48)1.1450202759405768SUM(H47:H48)0.694288971286904814.52978228747029475.41675594396521026.29262732782439837.37325133719865818.48543488916576129.688266271822998410.990690430153467331891799Preferences.moneyunits£m20072010201520202025203020352040204520503237G49*$F$3128.281707393018042H49*$F$3117.148759672404946111.88446169922615133.79248371892211155.42628244958223182.11741856058927209.58806728619621239.29769420045074271.46723715220523306F46*$F$325.090707330743248G46*$F$325.082759721637558H46*$F$325.09307108498487889.838448989115372414.88833167687558220.17825718654209825.92108525014787932.08030773943303938.69847449288340645.8220906016797611801Preferences.moneyunits£m20072010201520202025203020352040204520503237G49*$G$3156.563414786036084H49*$G$3134.297519344809892223.7689233984523267.58496743784423310.85256489916446364.23483712117854419.17613457239241478.59538840090147542.93447430441043306F46*$G$3210.181414661486496G46*$G$3210.165519443275116H46*$G$3210.18614216996975819.67689797823074529.77666335375116440.35651437308419551.84217050029575864.16061547886607777.39694898576681291.644181203359523683778Preferences.EnergyUnitsTWh78418442691692720721722723724725726727751INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Heat transportF$408.8131931365908187G$408.79943398496967268.817285342507492617.03263328102403725.77514950771491834.93323544074829144.87540056368457955.53844085309334866.99601993175676379.32864888070591346INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)-F$42-1.2590275909415456-G$42-1.2570619978528104-1.2596121917867846-2.4332333258605767-3.6821642153878456-4.990462205821184-6.4107715090977972-7.9340629790133352-9.5708599902509661-11.3326641258151334INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Conversion losses-F$43-7.5541655456492727-G$43-7.5423719871168622-7.5576731507207082-14.599399955163459-22.092985292327072-29.942773234927106-38.46462905458678-47.604377874080015-57.425159941505797-67.995984754890785148SUBTOTAL(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])0261326187826144426916927207217227237247257267272615INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))0F9-8.81319313659081872621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of unitsF110318931903161784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C86, CostVectors[Code], 0))Low estimate of capital costsF530G5328.28170739301804217.148759672404946111.88446169922615133.79248371892211155.42628244958223182.11741856058927209.58806728619621239.29769420045074271.46723715220523133INDEX(CostVectors[Description], MATCH(C87, CostVectors[Code], 0))Low estimate of operating costsF545.0907073307432485.0827597216375585.09307108498487889.838448989115372414.88833167687558220.17825718654209825.92108525014787932.08030773943303938.69847449288340645.8220906016797613140INDEX(CostVectors[Description], MATCH(C88, CostVectors[Code], 0))High estimate of capital costsF570G5756.56341478603608434.297519344809892223.7689233984523267.58496743784423310.85256489916446364.23483712117854419.17613457239241478.59538840090147542.93447430441043142INDEX(CostVectors[Description], MATCH(C89, CostVectors[Code], 0))High estimate of operating costsF5810.18141466148649610.16551944327511610.18614216996975819.67689797823074529.77666335375116440.35651437308419551.84217050029575864.16061547886607777.39694898576681291.644181203359523