62862919563228224912548448948631630321322323360612555556643644645651646647648649650321322323360188481108751.742836526536541141.42.71.51.91.61.72112654904914924931203535611.742683243253611141.3121.71.51.721.7120072020203020504944954964975712203562563564565114333222221#REF!#REF!118#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!4984995005012351221.644233283294241141.91.21.31.22.41.622.53#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!5045035025052341211.644293263273641142.71.41.51.31.91.611.34#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!5065075085093502146176196206211141.61121142.53617619620621351396246176226236241142112.51242.53617622623624352397146186256266271142112.52.9142.53618625626627104380144254264274281141111111115915105115125131503891.242853353363621141.21112.71.21245922853353363621913881.943373383393781141.81121.61.93345893373383393781143811428433333436511411112.614342843335145151125721.943303313323661142111.51.91.9123516517518519210581143403413423671141111111113593405205225214821093414287344345363114111.51.81.9113128734452352435447212928094Preferences.EnergyUnits & " / year"TWh / year200720202030205056634430431432584114243333322155INDEX(#REF!, MATCH($BD22, #REF!, 0))#REF!SUMIFS(INDIRECT("'"&BI$21&"'!Year.NetBalance"), INDIRECT("'"&BI$21&"'!Year.Vectors"),$BD22)#REF!#REF!#REF!#REF!43052552658557024374433372373114222242434156INDEX(#REF!, MATCH($BD23, #REF!, 0))#REF!#REF!#REF!#REF!#REF!3744333723731433822202343286434487113222232333157INDEX(#REF!, MATCH($BD24, #REF!, 0))#REF!#REF!#REF!#REF!#REF!3432864344342612602426943543648811413111231137INDEX(#REF!, MATCH($BD25, #REF!, 0))#REF!#REF!#REF!#REF!#REF!269527528529141567220336937037136811213211222138INDEX(#REF!, MATCH($BD26, #REF!, 0))#REF!#REF!#REF!#REF!SUMIFS(INDIRECT("'"&BL$21&"'!Year.NetBalance"), INDIRECT("'"&BL$21&"'!Year.Vectors"),$BD26)#REF!3693703713684732182192443757857958011423.732.512121437578579580492426847412619631738334438573574439141423433344248Preferences.EnergyUnits & " / year"TWh / year2007202020302050438573574439657346596606616621414323334446596606616626581466366466566612222212121266366466566612719734310320347375141323443244256253-(INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BI$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BI$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BJ$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BJ$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BK$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BK$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BL$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BL$30&"!Year.Vectors"),0)))#REF!3103203473754751281372444044131144214122212244477264INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH($BD34,INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BI$30&"!Year.Vectors"),0))/BI$33#REF!INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH($BD34,INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BJ$30&"!Year.Vectors"),0))/BJ$33#REF!INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH($BD34,INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BK$30&"!Year.Vectors"),0))/BK$33#REF!INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH($BD34,INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BL$30&"!Year.Vectors"),0))/BL$33#REF!530531531532139146346676686696701412221434346420072050267117255-INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH($BD35,INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.05",INDIRECT(BI$30&"!Year.Vectors"),0))/BI$33#REF!#REF!#REF!#REF!66766866967011647611718900000050INDEX(#REF!, MATCH($AR36, #REF!, 0))#REF!SUMIFS(INDIRECT("'"&AW$35&"'!Year.EmissionsBySector"), INDIRECT("'"&AW$35&"'!Year.Modules"),$AR36)#REF!#REF!AX36*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!132254#REF!#REF!#REF!#REF!3842429229329437614142342243377INDEX(#REF!, MATCH($AR37, #REF!, 0))#REF!#REF!#REF!AX37*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!84356#REF!#REF!#REF!#REF!2922932943763853444344444544614143334324481INDEX(#REF!, MATCH($AR38, #REF!, 0))#REF!#REF!#REF!AX38*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!104357#REF!#REF!#REF!#REF!443444445446386420334658658758814143334433378INDEX(#REF!, MATCH($AR39, #REF!, 0))#REF!#REF!#REF!AX39*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!120358#REF!#REF!#REF!#REF!346586587588387120365565629737714143231143382INDEX(#REF!, MATCH($AR40, #REF!, 0))#REF!#REF!#REF!AX40*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!29529629737747713313500000083INDEX(#REF!, MATCH($AR41, #REF!, 0))#REF!#REF!#REF!AX41*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!241-(INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BI$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BI$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BJ$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BJ$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BK$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BK$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BL$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BL$30&"!Year.Vectors"),0)))#REF!5692430530630737914142344244484INDEX(#REF!, MATCH($AR42, #REF!, 0))#REF!#REF!#REF!AX42*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!77245INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH($BD42,INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BI$30&"!Year.Vectors"),0))/BI$41#REF!INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH($BD42,INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BJ$30&"!Year.Vectors"),0))/BJ$41#REF!INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH($BD42,INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BK$30&"!Year.Vectors"),0))/BK$41#REF!INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH($BD42,INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BL$30&"!Year.Vectors"),0))/BL$41#REF!305306307379390120154454548548512122122121285243-INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH($BD43,INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.04",INDIRECT(BI$30&"!Year.Vectors"),0))/BI$41#REF!#REF!#REF!#REF!544545545545478271247185INDEX(#REF!, MATCH($AR44, #REF!, 0))#REF!SUMIFS(INDIRECT("'"&AW$35&"'!Year.EmissionsBySector"), INDIRECT("'"&AW$35&"'!Year.Modules"),$AR44)#REF!#REF!AX44*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!84247#REF!#REF!#REF!#REF!5822202447448449487142222212322147INDEX(#REF!, MATCH($AR45, #REF!, 0))#REF!#REF!#REF!AX45*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!149263#REF!#REF!#REF!#REF!44744844944958323450451452486131313332233163INDEX(#REF!, MATCH($AR46, #REF!, 0))#REF!#REF!#REF!AX46*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!53353453553547913219059SUM(AW36:AW46)#REF!SUM(AX36:AX46)#REF!AX47*'Intermediate output'!$H$155/'Intermediate output'!$F$205#REF!240-(INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BI$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BI$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BJ$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BJ$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BK$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BK$30&"!Year.Vectors"),0)))#REF!-(INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BL$30&"!Year.Vectors"),0))+INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BL$30&"!Year.Vectors"),0)))#REF!39134272273298299141423443344231AW47/677.35#REF!77246INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH($BD48,INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BI$30&"!Year.Vectors"),0))/BI$47#REF!INDEX(INDIRECT(BJ$30&"!Year.Matrix"),MATCH($BD48,INDIRECT(BJ$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BJ$30&"!Year.Vectors"),0))/BJ$47#REF!INDEX(INDIRECT(BK$30&"!Year.Matrix"),MATCH($BD48,INDIRECT(BK$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BK$30&"!Year.Vectors"),0))/BK$47#REF!INDEX(INDIRECT(BL$30&"!Year.Matrix"),MATCH($BD48,INDIRECT(BL$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BL$30&"!Year.Vectors"),0))/BL$47#REF!5365375385393924203300301302303141434344344315120244-INDEX(INDIRECT(BI$30&"!Year.Matrix"),MATCH($BD49,INDIRECT(BI$30&"!Year.Modules"),0),MATCH("V.03",INDIRECT(BI$30&"!Year.Vectors"),0))/BI$47#REF!#REF!#REF!#REF!3003013023033934203655656271304141433234433318104266#REF!#REF!#REF!#REF!29527027130448013413631684247#REF!#REF!#REF!#REF!5683427531330830914142344344482262#REF!#REF!#REF!#REF!54054154254339422012762744854851212212222125465475475474837014070143122773483491111121211213125485495503551103952428828929029111142223243455455355255163315315413641642607111111111111590$E8=1$E8=2$E8=3$E8=4$E5>=1$E5>=3$E5>=2$E5>=4$E22>=1$E22>=3$E22>=2$E22>=4$E46>=1$E46>=3$E46>=2$E46>=4$E7>=1$E7>=3$E7>=2$E7>=4