1671Preferences.EnergyUnits & " / year"TWh / year24492007201020152020202520302035204020452050167236INDEX(Vectors[Description], MATCH($C7, Vectors[Code], 0))Road transportINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))502.50552967076953INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))490.85404977847907INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))470.28702972578913INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))445.11640773235172INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))424.44768007195523INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))392.44298320543953INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))356.16794784956346INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))350.91869963982009INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))343.23053939693961INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))339.65660332418173INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C7, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))335.9214519651574237INDEX(Vectors[Description], MATCH($C8, Vectors[Code], 0))Rail transportINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))16.246998166435951INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))15.852446803025652INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))17.724487403333239INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))17.183448840130435INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))16.963945338992865INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))16.668321544879074INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))16.278078430943093INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))15.860444512419436INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))15.374887113066478INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))14.894486251116774INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C8, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))14.42259508147466838INDEX(Vectors[Description], MATCH($C9, Vectors[Code], 0))Domestic aviationINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))8.7346938775510203INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))9.0198346087095516INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))9.5510973295169013INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))10.163716423089292INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))11.078742052970153INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))11.927979753386868INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))12.657847240047854INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))13.331077116581312INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))13.860251279239513INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))14.344409418627478INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C9, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))14.78544909264656839INDEX(Vectors[Description], MATCH($C10, Vectors[Code], 0))National navigationINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))18.81937240536579INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))18.817339999999998INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))26.572895707388618INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))25.383064556311584INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))24.589843788926849INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))23.996704956708381INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))23.688791719453825INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))23.384829464713203INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))23.084767495533725INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))22.788555765479813INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C10, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))22.496144870285519954INDEX(Vectors[Description], MATCH($C11, Vectors[Code], 0))International aviationINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))152.99167541479133INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))152.99167541479133INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))153.63082794362825INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))174.02097069883129INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))194.2224288429754INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))201.39443053847114INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))208.13218382871563INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))212.05653906435825INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))212.09205012603269INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))209.1795176408344INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C11, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))206.26698515563612955INDEX(Vectors[Description], MATCH($C12, Vectors[Code], 0))International shippingINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))29.222291428230907INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))29.222291428230907INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))33.337857580646393INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))41.824074726648497INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))50.74INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))59.251128237495081INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))69.189913232481004INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))80.795830147396316INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))94.348523711435732INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))110.17454626418257INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C12, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))128.69260SUM(F7:F12)728.52056096314448SUM(H7:H12)716.7576380332365711.1041956903025713.6916829773628722.0426400958205705.68154823638008686.11476230120479696.34741994528872701.99101912224774711.03811866442288722.5826261652002813INDEX(Vectors[Description], MATCH($C14, Vectors[Code], 0))IndustryINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))443.27401323896316INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))484.94967152772296INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))477.06598353088668INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))471.79679543671375INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))468.01022688125772INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))466.62815410564502INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))467.27078311897588INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))469.63816961238564INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))473.49398888259941INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))478.65264401758344INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C14, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))484.969026213444416INDEX(Vectors[Description], MATCH($C15, Vectors[Code], 0))Heating and coolingINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))544.74376989125381INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))498.42483853439262INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))527.14266867050026INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))554.11036409922224INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))584.62532188516423INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))612.7136804533053INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))643.77648009101449INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))666.21817252012693INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))693.03620933979801INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))724.3415717397047INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C15, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))760.266304450131257INDEX(Vectors[Description], MATCH($C16, Vectors[Code], 0))Lighting & appliancesINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))183.99501047219411INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))176.36080205964583INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))177.42796936210306INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))181.64752039357137INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))185.83085939782245INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))189.81046011329818INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))193.5794282147545INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))198.16407689154261INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))202.8565997740406INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))207.74130210103971INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C16, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))212.8268727852689340INDEX(Vectors[Description], MATCH($C17, Vectors[Code], 0))Food consumption [UNUSED]INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))59.090632000000006INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C17, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))01009F13+F14+F15+F16+F171959.6239865655555H13+H14+H15+H16+H171876.4929501549977I13+I14+I15+I16+I171892.74081725379281921.246362906871960.50904826006511974.83384290862841990.74145372594972030.36783896934392071.37781711868592121.77363652275062180.64482961404471226MAX(0,H$47-H$18)669.5938528779925681.09873670519187649.99024400614439599.88029400328901531.57904867595926518.65531049315405534.69957559000682568.47673826221626601.40566665415326620.5833030499311514477INDEX(Vectors[Description], MATCH($C23, Vectors[Code], 0))Nuclear fission-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))163.24447683045062-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))163.91620313701554-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))160.70999999999998-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))134.99639999999999-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))77.140800000000027-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))25.713600000000014-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))25.713600000000014-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C23, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))033INDEX(Vectors[Description], MATCH($C24, Vectors[Code], 0))Solar-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0.53605914770000007-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))1.700604E-2-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))2.8059966000000006E-2-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))1.3604831999999999E-2-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C24, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))08INDEX(Vectors[Description], MATCH($C25, Vectors[Code], 0))Wind-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))6.9788618847825861-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))5.9627524176000009-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))14.440670099999998-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))29.342870099999999-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))45.357265116000008-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))57.693779640000002-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))48.169345319999991-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))32.302885319999994-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))15.209185319999996-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))8.7835319999996164E-2-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C25, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))8.7835319999996164E-29INDEX(Vectors[Description], MATCH($C26, Vectors[Code], 0))Tidal-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))5.0034246575342495E-3-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))2.0013698630136998E-2-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))5.0034246575342486E-2-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0.12508561643835608-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0.12508561643835608-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C26, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))010INDEX(Vectors[Description], MATCH($C27, Vectors[Code], 0))Wave-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))3.0020547945205484E-3-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0.1584417808219177-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0.39610445205479383-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0.39610445205479383-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C27, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))011INDEX(Vectors[Description], MATCH($C28, Vectors[Code], 0))Geothermal-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C28, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))012INDEX(Vectors[Description], MATCH($C29, Vectors[Code], 0))Hydro-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))5.0883943400000007-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))4.1144009940000004-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))5.3297280000000011-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))5.3297280000000011-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))5.3297280000000011-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))5.3297280000000011-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))5.3297280000000011-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))5.3297280000000011-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))5.3297280000000011-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))5.3297280000000011-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C29, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))5.329728000000001160INDEX(Vectors[Description], MATCH($C30, Vectors[Code], 0))Electricity oversupply (imports)-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))5.2145242500000002-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))5.2145242500000002-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))5.6843418860808015E-14-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))1.1368683772161603E-13-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))-5.6843418860808015E-14-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C30, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))01787SUM(F23:F30)181.06231645293323SUM(H23:H30)179.22488683861556SUM(I23:I30)180.51346149065751169.70561868542461128.0362691433973389.25829770849328879.73386338849316237.63261331999999720.5389133199999425.41756331999999755.4175633199999975104INDEX(Vectors[Description], MATCH($C32, Vectors[Code], 0))Environmental heat-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C32, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))054INDEX(Vectors[Description], MATCH($C33, Vectors[Code], 0))Waste-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))14.240524277899516-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))62.237942434867549-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))78.796342045405098-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))112.42322739740875-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))153.55003907237216-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))173.39314773589589-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))185.55356846592838-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))198.8151335811468-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))213.1543181135421-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))222.87194421999808-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C33, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))233.156312694248021015INDEX(Vectors[Description], MATCH($C34, Vectors[Code], 0))Agriculture-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))58.005772267812624-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))4.8815222222222214-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))3.0279139524977032-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))4.6928452384770294-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))6.4025630819315333-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))8.1581908174588182-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))9.9608927538040106-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))11.811876531949348-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))13.712395650409537-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))15.663752170256295-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C34, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))17.66729961334454759INDEX(Vectors[Description], MATCH($C35, Vectors[Code], 0))Biomass oversupply (imports)-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))26.262503111111116-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))4.0007200000000003-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))3.7216-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))3.2564000000000002-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))2.7911999999999999-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))2.3260000000000001-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))1.8608-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))1.3956-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0.93040000000000012-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0.4652-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C35, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))01017SUM(F33:F35)98.508799656823257SUM(H33:H35)71.12018465708976685.545855997902791120.37247263588579162.74380215430369183.87733855335472197.37526121973241212.02261011309614227.79711376395164239.00089639025438250.82361230759255979INDEX(Vectors[Description], MATCH($C37, Vectors[Code], 0))Coal oversupply (imports)-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))329.60273235621702-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))322.68137258509557-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))327.40470450518353-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))243.13564938038488-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))135.38600824731412-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))-9.7100997793789645-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))-127.74029406117114-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))-157.73948629015786-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))-168.86830612366919-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))-175.43867886784773-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C37, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))-182.11542294348061987INDEX(Vectors[Description], MATCH($C38, Vectors[Code], 0))Coal reserves-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))145.79944495555736-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))124.39544583847987-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C38, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))124.39544583847987141SUM(F37:F38)475.40217731177438SUM(H37:H38)447.07681842357545SUM(I37:I38)451.8001503436634367.53109521886472259.781454085794114.68534605910091-3.3448482226912688-33.344040451677984-44.472860285189313-51.043233029367855-57.719977105000737988INDEX(Vectors[Description], MATCH($C40, Vectors[Code], 0))Oil reserves-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))887.46007573003203-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))975.89120834979803-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))815.4323959706519-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))664.52033513004915-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))527.86775447758896-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))419.31653778914142-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))333.08789440544865-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))264.59138956080642-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))210.18056977027507-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))166.95884163987617-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C40, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))132.62526993906516980INDEX(Vectors[Description], MATCH($C41, Vectors[Code], 0))Oil and petroleum products oversupply (imports)-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))79.743976905201578-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))-99.626488767574756-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))55.34765064730766-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))195.68958706939225-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))335.26616882453402-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))418.94158686156516-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))479.46110977101455-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))553.0832756599583-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))609.0698229814584-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))658.26340925229385-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C41, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))701.40782445643435795INDEX(Vectors[Description], MATCH($C42, Vectors[Code], 0))Petroleum products oversupply-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))-60.581053896315709-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C42, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))01423SUM(F40:F42)906.622998738918SUM(H40:H42)876.26471958222328SUM(I40:I42)870.78004661795956860.20992219944139863.13392330212298838.25812465070658812.5490041764632817.67466522076472819.25039275173344825.22225089217834.03309439549957981INDEX(Vectors[Description], MATCH($C44, Vectors[Code], 0))Gas oversupply (imports)-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))214.86865308275657-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))133.59090031729465-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))347.31805485755001-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))544.43394565374615-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))742.37819286709714-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))959.16194117733608-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))1167.9577172460649-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))1328.4201001758292-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))1455.7550223141213-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))1576.7011576242896-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C44, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))1667.0906714380969989INDEX(Vectors[Description], MATCH($C45, Vectors[Code], 0))Gas reserves-INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))834.0611502141918-INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))838.80929321419171-INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))637.88198465125163-INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))508.98355251965154-INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))404.31570071063896-INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))321.17184343559597-INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))255.12576641104135-INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))202.66146618133868-INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))160.98597351628524-INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))127.88066797955751-INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C45, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))101.5831683077875275SUM(F44:F45)1048.9298032969484SUM(H44:H45)972.40019353148637SUM(I44:I45)985.200039508801641053.41749817339771146.69389357773621280.3337846129321423.08348365710621531.0815663571681616.74099583040651704.58182560384721768.67383974588441010F31+F32+F36+F39+F43+F462710.5260954573969H31+H32+H36+H39+H43+H462546.08680303299022573.83955395898472571.23660691301442560.38934226335412506.41289158458772509.39676421910372565.06741455935072639.85455538090222723.17930317690392801.22813266397591227MAX(0,-(H$47-H$18))0000000000101134INDEX(Vectors[Description], MATCH($C52, Vectors[Code], 0))Conversion lossesINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))561.41930248844437INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))548.37651774683582INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))563.61061669233823INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))534.59949610651211INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))487.79884832258381INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))422.51805965530184INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))409.83667488108119INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))425.6097897081271INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))458.04461352141089INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))489.29859083635012INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C52, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))507.0286836766787235INDEX(Vectors[Description], MATCH($C53, Vectors[Code], 0))Distribution losses and own useINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))186.94703532055274INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))121.21733513115662INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))117.48812001285407INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))115.39074789963161INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))112.08144568070595INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))109.06098902065651INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))108.81864158244093INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))109.08979221060923INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))110.43212474080529INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))112.10707581780287INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C53, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))113.554619373251871012F47-SUM(F52:F53)1962.1597576483998H47-SUM(H52:H53)1876.49295015499771892.74081725379231921.24636290687071960.50904826006441974.83384290862931990.74144775558172030.36783264061432071.37781711868592121.77363652275112180.6448296140452123564INDEX(Vectors[Description], MATCH($C58, Vectors[Code], 0))Coal and fossil wasteINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0.46688353851152442INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C58, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))065INDEX(Vectors[Description], MATCH($C59, Vectors[Code], 0))Oil and petroleum productsINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))35.994120424665141INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C59, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))066INDEX(Vectors[Description], MATCH($C60, Vectors[Code], 0))Natural gasINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))-10.228142999999932INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C60, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))047INDEX(Vectors[Description], MATCH($C61, Vectors[Code], 0))Solid hydrocarbonsINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C61, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))049INDEX(Vectors[Description], MATCH($C62, Vectors[Code], 0))Liquid hydrocarbonsINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))-40.985250464344332INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C62, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))050INDEX(Vectors[Description], MATCH($C63, Vectors[Code], 0))Gaseous hydrocarbonsINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))15.047768550745332INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C63, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))0108INDEX(Vectors[Description], MATCH($C64, Vectors[Code], 0))Blast furnace gasINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))-0.11045622230000071INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C64, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))0752INDEX(Vectors[Description], MATCH($C65, Vectors[Code], 0))Edible biomassINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C65, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))0751INDEX(Vectors[Description], MATCH($C66, Vectors[Code], 0))Heat transportINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))2.9616599999983118E-3INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))-1.7763568394002505E-15INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C66, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))1.7763568394002505E-15753INDEX(Vectors[Description], MATCH($C67, Vectors[Code], 0))Dry biomass and wasteINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))-0.34098803451720627INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C67, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))0917INDEX(Vectors[Description], MATCH($C68, Vectors[Code], 0))Wet biomass and wasteINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C68, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))01319INDEX(Vectors[Description], MATCH($C69, Vectors[Code], 0))Domestic solar thermalINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C69, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))01464INDEX(Vectors[Description], MATCH($C70, Vectors[Code], 0))H2INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C70, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))01780INDEX(Vectors[Description], MATCH($C71, Vectors[Code], 0))Energy crops (second generation)INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C71, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))01236SUM(F58:F71)-0.15310354723947603SUM(H58:H71)00000000-1.7763568394002505E-151.7763568394002505E-151014F18-F54+F72-2.6888746300838249H18-H54+H7204.5474735088646412E-13-6.8212102632969618E-136.8212102632969618E-13-9.0949470177292824E-135.9703679653466679E-66.328729568849667E-60-4.5652370772586437E-13-4.5297099404706387E-13167345INDEX(Vectors[Description], MATCH($C80, Vectors[Code], 0))Electricity (delivered to end user)INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))-352.03495223253594INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))-354.55512401053005INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))-360.93233792616286INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))-372.62479962516409INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))-381.79160355482168INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))-389.2191103035388INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))-398.37245385032901INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))-409.14816543679922INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))-421.5036539584932INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))-435.11431844714406INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C80, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))-450.4105965838732646INDEX(Vectors[Description], MATCH($C81, Vectors[Code], 0))Electricity (supplied to grid)INDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))354.72382686261983INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))354.55512401053005INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))360.93233792616286INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))372.62479962516409INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))381.79160355482168INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))389.2191103035388INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))398.37245385032901INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))409.14816543679922INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))421.5036539584932INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))435.11431844714406INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C81, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))450.410596583873261237SUM(F80:F81)2.6888746300838875SUM(H80:H81)00000000004658INDEX(INDIRECT("'"&H$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&H$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))-26.584481639635896INDEX(INDIRECT("'"&I$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&I$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))-27.062644031803529INDEX(INDIRECT("'"&J$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&J$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))-27.93934277992264INDEX(INDIRECT("'"&K$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&K$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))-28.626668147006853INDEX(INDIRECT("'"&L$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&L$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))-29.183581313444904INDEX(INDIRECT("'"&M$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&M$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))-29.869897423358736INDEX(INDIRECT("'"&N$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&N$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))-30.677858407208532INDEX(INDIRECT("'"&O$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&O$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))-31.604270791376905INDEX(INDIRECT("'"&P$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&P$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))-32.624796051621161INDEX(INDIRECT("'"&Q$4&"'!Year.Matrix"), MATCH("VII.b", INDIRECT("'"&Q$4&"'!Year.Modules"), 0), MATCH('Intermediate output'!$C84, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))-33.7717083305382181769-H80-H84381.13960565016595-I80-I84387.99498195796639400.56414240508673410.41827170182853418.4026916169837428.24235127368775439.82602384400775453.10792474987011467.73911449876522484.182304914411471770H111382.39863324110746I111389.25494195830294401.83170614927013411.69545854792074419.69203416596741429.54618204519448441.14652131286232454.44715044829348469.09904302344387485.5648483004132561INDEX(Vectors[Description], MATCH($C89, Vectors[Code], 0))UnallocatedINDEX(INDIRECT("'"&F$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&H$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&I$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&I$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&J$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&J$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&K$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&K$4&"'!Year.Vectors"), 0))1.0231815394945443E-12INDEX(INDIRECT("'"&L$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&L$4&"'!Year.Vectors"), 0))-9.0949470177292824E-13INDEX(INDIRECT("'"&M$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&M$4&"'!Year.Vectors"), 0))5.9703683064071811E-6INDEX(INDIRECT("'"&N$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&N$4&"'!Year.Vectors"), 0))6.328729568849667E-6INDEX(INDIRECT("'"&O$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&O$4&"'!Year.Vectors"), 0))-1.0231815394945443E-12INDEX(INDIRECT("'"&P$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&P$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&Q$4&"'!Year.NetBalance"), MATCH('Intermediate output'!$C89, INDIRECT("'"&Q$4&"'!Year.Vectors"), 0))-1.0231815394945443E-121018F74+F82+F896.2616578588858829E-14H74+H82+H8904.5474735088646412E-13-6.8212102632969618E-131.7053025658242404E-12-1.8189894035458565E-121.1940736271753849E-51.2657459137699334E-5-1.0231815394945443E-12-4.5652370772586437E-13-1.4761525335416081E-121238462007201020152020202520302035204020452050740INDEX(Modules[Module], MATCH($C96, Modules[Code], 0))Biomass/Coal powerINDEX(INDIRECT("'"&F$4&"'!Year.Matrix"), MATCH($C96, INDIRECT("'"&F$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))276.53401618322465INDEX(INDIRECT("'"&H$4&"'!Year.Matrix"), MATCH($C96, INDIRECT("'"&H$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))309.62005353950747316.85548046764541317.86206003884547324.71926489452346336.85523323247423356.18240284170128392.56377143286232422.9361198232935452.67806777844385469.10848033041327825INDEX(Modules[Module], MATCH($C97, Modules[Code], 0))Domestic space heating and hot waterINDEX(INDIRECT("'"&F$4&"'!Year.Matrix"), MATCH($C97, INDIRECT("'"&F$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&H$4&"'!Year.Matrix"), MATCH($C97, INDIRECT("'"&H$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&H$4&"'!Year.Vectors"), 0))0000000000933INDEX(Modules[Module], MATCH($C98, Modules[Code], 0))Commercial heating and coolingINDEX(INDIRECT("'"&F$4&"'!Year.Matrix"), MATCH($C98, INDIRECT("'"&F$4&"'!Year.Modules"), 0), MATCH($C$95, INDIRECT("'"&F$4&"'!Year.Vectors"), 0))000000000002348F96+F97+F98276.53401618322465G96+G97+G980309.62005353950747316.85548046764541317.86206003884547324.71926489452346336.85523323247423356.18240284170128392.56377143286232422.9361198232935452.67806777844385469.10848033041327869INDEX(Modules[Module], MATCH($C100, Modules[Code], 0))Carbon Capture Storage (CCS)0005.079787425000000110.83464451000000210.87674322510.92815581510.95013656000000110.97211730500000111.00341192499999811.038804649999999754INDEX(Modules[Module], MATCH($C101, Modules[Code], 0))Nuclear power57.24889500000000557.46989599999999952.59599999999999744.18063999999999725.2460800000000068.41536000000000518.415360000000005100001709INDEX(Modules[Module], MATCH($C102, Modules[Code], 0))Onshore wind4.49128229999999994.985822041200000510.31775731999999717.54970731999999624.78165732000000128.96303931999999621.78368531999999314.5517353199999977.31978531999999588.7835319999996164E-28.7835319999996164E-21710INDEX(Modules[Module], MATCH($C103, Modules[Code], 0))Offshore wind0.782552399999999930.976930376399999914.122912780000002711.79316278000000120.57560779600000328.7307403200000126.38565999999999817.7511499999999997.889400000000000200799INDEX(Modules[Module], MATCH($C104, Modules[Code], 0))Hydroelectric4.11375510000000064.11440099400000045.32972800000000115.32972800000000115.32972800000000115.32972800000000115.32972800000000115.32972800000000115.32972800000000115.32972800000000115.3297280000000011804INDEX(Modules[Module], MATCH($C105, Modules[Code], 0))Wave and Tidal005.0034246575342495E-32.3015753424657545E-20.208476027397260180.521190068493149860.521190068493149860000805INDEX(Modules[Module], MATCH($C106, Modules[Code], 0))Geothermal00000000000806INDEX(Modules[Module], MATCH($C107, Modules[Code], 0))Tidal [UNUSED - See III.c]00000000000964INDEX(Modules[Module], MATCH($C108, Modules[Code], 0))Distributed solar PV01.700604E-22.8059966000000006E-21.3604831999999999E-200000001651SUM(F102:F108)9.3875898000000007SUM(H102:H108)10.09415945160000119.80346149065753634.70921868542465950.89546914339727163.54469770849315354.02026338849314237.63261331999999720.5389133199999995.41756331999999755.4175633199999975772INDEX(Modules[Module], MATCH($C110, Modules[Code], 0))Electricity imports / exports5.21452425000000025.2145242500000002000000000885F99+F100+F101+F109+F110348.38502523322467H99+H100+H101+H109+H110382.39863324110746389.25494195830294401.83170614927013411.69545854792074419.69203416596741429.54618204519448441.14652131286232454.44715044829348469.09904302344387485.5648483004132589016921030169520072010201520202025203020352040204520501053INDEX(IPCC[Sector_description], MATCH($C119, IPCC[Sector_code], 0))Fuel Combustion1052INDEX(IPCC[Sector_description], MATCH($C120, IPCC[Sector_code], 0))Fugitive Emissions from Fuels11031F142/$F$1610.6828579138027161H142*$H$135/$F$1610.682999087602175310.687754273830417210.668166756223947830.649437724519872810.6165409807255080.593311084140743410.608479953094531840.625818019243826520.645459068486650240.659574291142763222INDEX(IPCC[Sector_description], MATCH($C122, IPCC[Sector_code], 0))Industrial Processes3.4882184192791134E-2H143*$H$135/$F$1613.6341149145131674E-23.5656446131557606E-23.4595810641237575E-23.3629083548162741E-23.2749027666202572E-23.1948986928052675E-23.122283955942785E-23.05649550431774E-22.9970154566039121E-22.9433674665684903E-23INDEX(IPCC[Sector_description], MATCH($C123, IPCC[Sector_code], 0))Solvent and Other Product Use0H144*$H$135/$F$16100000000004INDEX(IPCC[Sector_description], MATCH($C124, IPCC[Sector_code], 0))Agriculture5.4352073272077611E-2H145*$H$135/$F$1615.6426762033361555E-25.5436230793638575E-25.3987102034546118E-25.1277924271695967E-25.1531040185631448E-25.1788664708274146E-25.2050917757687908E-25.2317922981179502E-25.2589807876196687E-25.286670391518411E-25INDEX(IPCC[Sector_description], MATCH($C125, IPCC[Sector_code], 0))Land Use, Land-Use Change and Forestry-2.2259510626399782E-3H146*$H$135/$F$161-2.3776279024886023E-33.3219612524222138E-37.7311473518456063E-31.2008705747395935E-21.5962211172041645E-21.8185624681597092E-21.8580092994714002E-21.729490423095835E-21.5674740473342975E-21.5057506043692737E-26INDEX(IPCC[Sector_description], MATCH($C126, IPCC[Sector_code], 0))Waste2.8590076266100505E-2H147*$H$135/$F$1612.9865269095529577E-23.0090369197758159E-22.9730409718040231E-22.8843300589581799E-22.8286223726095711E-22.8316631275004417E-22.872639002206067E-22.9392573164361464E-23.0280550131054115E-23.1350783516886686E-27INDEX(IPCC[Sector_description], MATCH($C127, IPCC[Sector_code], 0))Other0H148*$H$135/$F$16100000000001038INDEX(IPCC[Sector_description], MATCH($C128, IPCC[Sector_code], 0))International Aviation and Shipping5.3182960880876672E-2H149*$H$135/$F$1616.0495989268503289E-26.2074580719528559E-27.1661683118773883E-28.1328806585051497E-28.6535687685116228E-29.207238554982064E-29.7228517067260711E-20.1017398720169260.106027218207124240.111207469605459391039INDEX(IPCC[Sector_description], MATCH($C129, IPCC[Sector_code], 0))Bioenergy creditH150*$H$135/$F$161-1.2111371890290761E-2I150*$H$135/$F$161-1.4345146602483948E-2-1.8516209525472116E-2-2.4616586854786952E-2-3.0213380844323911E-2-3.2607652550276311E-2-3.5249370390983567E-2-3.813190955135573E-2-3.9762337360331718E-2-4.1496562729150192E-21066INDEX(IPCC[Sector_description], MATCH($C130, IPCC[Sector_code], 0))Carbon captureH151*$H$135/$F$1610I151*$H$135/$F$1610-3.6938995816971775E-3-8.701737207798382E-3-8.5187890005651024E-3-8.3434262282576412E-3-8.1751842578190962E-3-8.1566621370938591E-3-7.9956924928019143E-3-7.8409960037790112E-3148SUM(F121:F128)0.85163925735192203SUM(H121:H130)0.85163925735192203SUM(I121:I130)0.859988715322838380.843662799981221960.823207221199175440.792873001315706590.774672298504958450.79286415584688030.810839674991979730.832243509887273690.85015287015674191394F154/F1590.82154175185293077(H$154/$F$159)*$H$1350.81401728472871304(I$154/$F$159)*$H$1350.82098391467063780.794321683957806890.763328055771758770.726759368801860540.702335657921833060.715748280601185450.729601728922954160.74721309998797680.760310240617634861694$F$152/$H$1521.041825504511900730531-Q1310.149847129843258116911030152210631053INDEX(IPCC[Sector_description], MATCH($C140, IPCC[Sector_code], 0))Fuel Combustion532.63873751129393SUMIFS(INDIRECT("'"&H$4&"'!Year.Emissions"), INDIRECT("'"&H$4&"'!Year.IPCC"), $C140)512.08938220417508516.51857693803493501.96619907108055487.88566594707601462.6035765118981444.58324078832459456.09708962970376469.30268030374611484.2075940681637494.931885206837481052INDEX(IPCC[Sector_description], MATCH($C141, IPCC[Sector_code], 0))Fugitive Emissions from Fuels13.365006440409912.10264631136367111.32298897835483810.84222730808688910.54849654316311510.58280574826235210.77452817789446410.90256924750766411.00369629872989411.17300683659452111.28194714927233211031F140+F141546.00374395170388H140+H141524.19202851553871I140+I141527.84156591638975512.80842637916749498.43416249023915473.18638226016043455.35776896621906466.9996588772114480.30637660247601495.38060090475824506.213832356109832INDEX(IPCC[Sector_description], MATCH($C143, IPCC[Sector_code], 0))Industrial Processes27.891312059948401SUMIFS(INDIRECT("'"&H$4&"'!Year.Emissions"), INDIRECT("'"&H$4&"'!Year.IPCC"), $C143)27.89131205994840527.36581229262639126.55178972762075125.80984051401508225.13441021499184624.52039039411891623.96308267721259423.45816572291183623.00166486612777622.5899242176713143INDEX(IPCC[Sector_description], MATCH($C144, IPCC[Sector_code], 0))Solvent and Other Product Use000000000004INDEX(IPCC[Sector_description], MATCH($C145, IPCC[Sector_code], 0))Agriculture43.45916609917990343.30673259999999742.54651404439215441.43432845352158739.35507327896008439.54933612174251339.74705925720603339.94833472074905240.15325740991057340.3619251771577340.5744389257109015INDEX(IPCC[Sector_description], MATCH($C146, IPCC[Sector_code], 0))Land Use, Land-Use Change and Forestry-1.7798396847837301-1.82479539999999912.54955773611735295.93354498809666719.21650986046446812.25076871367588713.95720677334367114.25995556026195713.27359157043060912.03013906507903911.5564204706898676INDEX(IPCC[Sector_description], MATCH($C147, IPCC[Sector_code], 0))Waste22.86022958161920122.92116676803920723.09392787614039822.81766412516062622.13682056035613921.70927203736318121.73260939612979622.04709337234633522.55837940341774223.23988902165140424.0612778341521297INDEX(IPCC[Sector_description], MATCH($C148, IPCC[Sector_code], 0))Other00000000001038INDEX(IPCC[Sector_description], MATCH($C149, IPCC[Sector_code], 0))International Aviation and Shipping42.52436000000000146.42980628721121447.64135264200255254.99931657704922862.41869553623436766.41490228910771570.66423869037031174.62149586462017278.08389624749753581.3743731122300685.3501419499995961039INDEX(IPCC[Sector_description], MATCH($C150, IPCC[Sector_code], 0))Bioenergy creditSUMIFS(INDIRECT("'"&H$4&"'!Year.Emissions"), INDIRECT("'"&H$4&"'!Year.IPCC"), $C150)-9.295304656359205-11.009694790820538-14.210925911557627-18.892878237717021-23.188337555032817-25.025906836079326-27.053387485500931-29.26569505249299-30.517025070422793-31.8480182305682221066INDEX(IPCC[Sector_description], MATCH($C151, IPCC[Sector_code], 0))Carbon capture00-2.8350150827586207-6.6784588169491528-6.5380486852173911-6.4034602662713631-6.2743369608870951-6.2601214982142848-6.1365795991071419-6.017852256923077SUM(F142:F149)680.95897200766774SUM(H142:H151)653.62094617437845SUM(I142:I151)660.02903571684806647.49912925630008631.79976518560306608.51868539679151594.54990637503704608.51189662601348622.30785040593696638.73498747747431652.480165266842391394F152-F149638.43461200766774H152-H149607.1911398871672612.38768307484554592.49981267925091569.38106964936867542.10378310768374523.88566768466671533.89040076139327544.22395415843948557.36061436524426567.13002331684277168216881689168816901687168316841685168616862020203020501521777.117669999999980.2*$F159155.423534000000020.66*$F159512.897662200000011393(31.401/2+6.768)22.468499999999999K161*H131159.91723400000001L161*H131527.7268722148F159+F160799.586169999999920.2*$F161159.917234000000010.66*$F161527.7268722H161/$F$131187.77578959575553I161/$F$131619.66010566599323K131/$H1310.96661493008066246M131/$H1310.90962492841595421Q131/$H1310.9982546751076248916690.20.20.20.20.20.20.20.20.20.2184900000000001459C23N.01Nuclear fission0163.244476830450620163.91620313701554160.70999999999998134.9963999999999977.14080000000002725.71360000000001425.7136000000000140000R.01Solar00.5360591477000000701.700604E-22.8059966000000006E-21.3604831999999999E-20000000R.02Wind06.978861884782586105.962752417600000914.44067009999999829.34287009999999945.35726511600000857.69377964000000248.16934531999999132.30288531999999415.2091853199999968.7835319999996164E-28.7835319999996164E-2R.03Tidal00005.0034246575342495E-32.0013698630136998E-25.0034246575342486E-20.125085616438356080.125085616438356080000R.04Wave000003.0020547945205484E-30.15844178082191770.396104452054793830.396104452054793830000R.05Geothermal0000000000000R.06Hydro05.088394340000000704.11440099400000045.32972800000000115.32972800000000115.32972800000000115.32972800000000115.32972800000000115.32972800000000115.32972800000000115.32972800000000115.3297280000000011Y.02Electricity oversupply (imports)0MAX(F30, 0)5.2145242500000002MAX(G30, 0)05.2145242500000002005.6843418860808015E-141.1368683772161603E-1300000C32R.07Environmental heat00000000000002361E36098.508799656823257071.12018465708976685.545855997902791120.37247263588579162.74380215430369183.87733855335472197.37526121973241212.02261011309614227.79711376395164239.00089639025438250.82361230759255D39CoalE390MAX(F39,0)475.40217731177438MAX(G39,0)0447.07681842357545451.8001503436634367.53109521886472259.781454085794114.6853460591009100000202E430906.6229987389180876.26471958222328870.78004661795956860.20992219944139863.13392330212298838.25812465070658812.5490041764632817.67466522076472819.25039275173344825.22225089217834.03309439549957D46Natural gas01048.92980329694840972.40019353148637985.200039508801641053.41749817339771146.69389357773621280.3337846129321423.08348365710621531.0815663571681616.74099583040651704.58182560384721768.6738397458844Total Primary Supply0SUM(F168:F180)2710.5260954573969SUM(G168:G180)02546.08680303299022573.83955395898472571.23660691301442560.38934226335412506.41289158458772512.7416124417952598.41145501102892684.32741566609182774.22253620627182858.94810976897682373MAX(0,F30)+MAX(0,F35)+MAX(0,F37)+MAX(0,F41)+MAX(0,F44)+F23818.93686653573695MAX(0,G30)+MAX(0,G35)+MAX(0,G37)+MAX(0,G41)+MAX(0,G44)0MAX(0,H30)+MAX(0,H35)+MAX(0,H37)+MAX(0,H41)+MAX(0,H44)+H23629.40372028940578894.50201001004121121.51198210352321292.96236993894541406.14312803890151674.99322701707961882.89897583578752065.75524529557972235.42976687658352368.49849589453153054Q182/Q1810.82845102637624402156F18+F52+F532707.9903243745525G18+G52+G5302546.08680303299022573.83955395898472571.23660691301392560.3893422633552506.41289158458682509.39677018947172565.06742088808012639.85455538090222723.17930317690392801.2281326639754302545IF(All.Vectors.And.Emissions[[#This Row],[Vector]]="GHG","Total greenhouse gas emissions",INDEX(Vectors[Description], MATCH($C189, Vectors[Code], 0)))Electricity (delivered to end user)2007201020152020202520302035204020452050Preferences.EnergyUnitsTWh969INDEX(Modules[Module], MATCH($C191, Modules[Code], 0))H2 Production for Transport-INDEX(INDIRECT($C191&".Outputs["&H$189&"]"),MATCH($C$189,INDIRECT($C191&".Outputs[Vector]"),0))0-INDEX(INDIRECT($C191&".Outputs["&I$189&"]"),MATCH($C$189,INDIRECT($C191&".Outputs[Vector]"),0))04.0701435957967548E-32.4117534050395649E-23.0770479412075686E-23.8868136798278725E-24.8936332951927848E-26.1032234703565995E-27.6017691508025981E-29.4783444922061477E-2912INDEX(Modules[Module], MATCH($C192, Modules[Code], 0))Agriculture and land use-INDEX(INDIRECT($C192&".Outputs["&H$189&"]"),MATCH($C$189,INDIRECT($C192&".Outputs[Vector]"),0))4.17284400000000044.2590025036288294.28560678382700114.31239368743153764.33936524963755144.3665235283208114.39387060429050454.42140858154480924.44913958752932094.47706577339835031317INDEX(Modules[Module], MATCH($C193, Modules[Code], 0))Distributed solar thermal0000000000825INDEX(Modules[Module], MATCH($C194, Modules[Code], 0))Domestic space heating and hot water31.00854652988846633.62212764331329136.35581759637216939.66099604918416343.09955738422205946.67431376844265949.44377127728531552.63198031767566956.32520222386598660.658172984497028933INDEX(Modules[Module], MATCH($C195, Modules[Code], 0))Commercial heating and cooling28.55169789024786231.40903797859883935.1694648501225835.54150777930459532.07362685653363630.34501678409565929.868502684481330.27589459268899931.30305504536294932.767588468647652938INDEX(Modules[Module], MATCH($C196, Modules[Code], 0))Domestic lighting, appliances, and cooking86.72500023805649587.3777078175062289.478519858330591.46434104552872793.16411259292250794.56743589111148796.68001200867188198.82343859522426101.062380337744103.40155946528074939INDEX(Modules[Module], MATCH($C197, Modules[Code], 0))Commercial lighting, appliances, and catering72.63487907969960173.04774088939819975.15818753192958577.34780373251102579.61979665666068281.97751212457892284.42444092846184886.96422544894558489.60066658521830692.33773101406193888INDEX(Modules[Module], MATCH($C198, Modules[Code], 0))Industrial processes114.37233546157294115.0871896982415116.39812479199203117.85894016911062119.47044692164093121.23372528582432123.15012245970406125.22125096386554127.44898753350859129.83547253124902891INDEX(Modules[Module], MATCH($C199, Modules[Code], 0))Domestic passenger transport8.58039245713454698.08144012199091588.13599113498759338.312353757411697710.44488528815617612.42373326989164914.57565242658013516.68530550964976918.54272572060476420.620614709478314904INDEX(Modules[Module], MATCH($C200, Modules[Code], 0))Domestic freight0.101200000000000010.102595991850850010.108462459682662010.114328927514475020.120195395346288010.12606186317810.1319283310099130.137794798841724990.143661266673538010.14952773450535101950INDEX(Modules[Module], MATCH($C201, Modules[Code], 0))Geosequestration0000000000959INDEX(Modules[Module], MATCH($C202, Modules[Code], 0))Petroleum refineries6.86481613512663196.49422302341310786.16594016359187875.86867631517141595.63254208141261445.44496671142013525.2959645152211965.17760326942971725.08358194046483285.0088952451600477977INDEX(Modules[Module], MATCH($C203, Modules[Code], 0))Indigenous fossil-fuel production1.54341221880345581.45127225822105271.36461431073228321.28614455760305151.22381139759428811.17429648666702691.13496386814119041.1037196459235311.0789005146636771.05918521267271591326INDEX(Modules[Module], MATCH($C204, Modules[Code], 0))District heating effective demand-INDEX(INDIRECT($C204&".Outputs["&H$189&"]"),MATCH("V.02",INDIRECT($C204&".Outputs[Vector]"),0))1.2590275909415456-INDEX(INDIRECT($C204&".Outputs["&I$189&"]"),MATCH("V.02",INDIRECT($C204&".Outputs[Vector]"),0))1.25996000033655141.26756374418339691.27718684609223471.2893425489837721.30383077150672481.32049746885454171.33922569842331091.35992852467866741.3825433860017822148SUM(H191:H204)355.81415160147162SUM(I191:I204)362.19229792649935373.89236336934744383.06879040091388390.50845285252257399.6762846218358410.46866290565384422.84287965691652436.47424697182271451.79313996987497260SUM(H199:H200,H191)8.6815924571345473SUM(I199:I200,I191)8.18403611384176528.24852373826605328.450800218976567610.59585116291453812.58866326986802714.75651709054197616.88413254319506218.76240467878632520.86492588890572743SUM(H201:H203,H198,H192)126.95340781550303SUM(I201:I203,I198,I192)127.2916874835045128.21428605014319129.32615472931661130.66616565028536132.21951201223229133.97492144735696135.9239824607636138.0606095761664140.380618762480141621SUM(H193:H195,H204)60.819272011077871SUM(I193:I195,I204)66.29112562224867172.79284619067813476.47969067458099376.46252678973945678.32316132404504680.63277143062114884.24710060878797488.98818579390760494.80830483914645930SUM(H196:H197)159.35987931775611SUM(I196:I197)160.42544870690443164.63670739026009168.81214477803974172.78390924958319176.54494801569041181.10445293713371185.78766404416984190.66304692296231195.73929047934269148SUM(H207:H210)355.81415160147156SUM(I207:I210)362.19229792649935373.89236336934744383.06879040091388390.50845285252251399.67628462183575410.46866290565379422.84287965691647436.47424697182265451.79313996987503106030262007201020152020202520302035204020452050740INDEX(Modules[Module], MATCH($C216, Modules[Code], 0))Biomass/Coal powerINDIRECT($C216&".Emissions[[#Totals],["&H$214&"]]")196.83195724050691INDIRECT($C216&".Emissions[[#Totals],["&I$214&"]]")201.99152243713169189.42701967582249173.32615233921882153.12244281326781140.41581540385872150.60705163512031162.05504732224273173.26543143677665179.45840965547268869INDEX(Modules[Module], MATCH($C217, Modules[Code], 0))Carbon Capture Storage (CCS)INDIRECT($C217&".Emissions[[#Totals],["&H$214&"]]")000.344037544213861680.821599897810827430.804291515276091220.787701930811399720.771787059512952570.770141850195894760.7549125664753360.740277742135667442912INDEX(Modules[Module], MATCH($C218, Modules[Code], 0))CHP used for domestic space heating and hot water00000000002912INDEX(Modules[Module], MATCH($C219, Modules[Code], 0))CHP used for domestic space heating and hot water0000000000148SUM(H216:H219)196.83195724050691SUM(I216:I219)201.99152243713169189.77105722003637174.14775223702964153.92673432854389141.20351733467012151.37883869463326162.82518917243863174.02034400325198180.1986873976083530291851303030042704INDEX(Vectors[Description],MATCH($C232,Vectors[Code],0))UK Land area2007201020152020202520302035204020452050Preferences.AreaUnitskm^21709INDEX(INDIRECT($C234&".Info[Information type]"),MATCH($C$232,INDIRECT($C234&".Info[Vector]"),0))onshore wind if 8 Wpeak/m2INDEX(INDIRECT($C234&".Info["&H$232&"]"),MATCH($C$232,INDIRECT($C234&".Info[Vector]"),0))250.00799999999998INDEX(INDIRECT($C234&".Info["&I$232&"]"),MATCH($C$232,INDIRECT($C234&".Info[Vector]"),0))470.80799999999982800.807999999999771130.80799999999981321.6079999999997994.00799999999958664.0079999999997334.007999999999754.00799999999982414.0079999999998241799INDEX(INDIRECT($C235&".Info[Information type]"),MATCH($C$232,INDIRECT($C235&".Info[Vector]"),0))hydroelectric resevoir assuming similar to Loch SloyINDEX(INDIRECT($C235&".Info["&H$232&"]"),MATCH($C$232,INDIRECT($C235&".Info[Vector]"),0))42.31636363636361952.36363636363635352.36363636363635352.36363636363635352.36363636363635352.36363636363635352.36363636363635352.36363636363635352.36363636363635352.363636363636353964solar PV if 20% efficient8.8181818181818167E-20.145499999999999997.0545454545454536E-200000001317solar thermal panels if 50% efficient00000000001582micro wind if 2 Wpeak/m200000000003118Area of biocrops3639.41120142017202020232026202920322035203117Area of forest24369.69999999999724414.63999999999924776.23999999999825137.8425499.43999999999925861.03999999999726222.63999999999926584.23999999999826945.83999999999727307.4400000000022764INDEX(Vectors[Description],MATCH($C242,Vectors[Code],0))UK Sea area2007201020152020202520302035204020452050Preferences.AreaUnitskm^21710INDEX(INDIRECT($C244&".Info[Information type]"),MATCH($C$242,INDIRECT($C244&".Info[Vector]"),0))offshore wind if 8 Wpeak/m2INDEX(INDIRECT($C244&".Info["&H$232&"]"),MATCH($C$242,INDIRECT($C244&".Info[Vector]"),0))47.255999999999986INDEX(INDIRECT($C244&".Info["&I$232&"]"),MATCH($C$242,INDIRECT($C244&".Info[Vector]"),0))161.25600000000009461.25600000000003761.25599999999997983.25599999999997839.99999999999989539.99999999999989239.99999999999994002634INDEX(INDIRECT($C245&".Info[Information type]"),MATCH($C$242,INDIRECT($C245&".Info[Vector]"),0))tidal stream devices if >1m/s tidesINDEX(INDIRECT($C245&".Info["&H$232&"]"),MATCH($C$242,INDIRECT($C245&".Info[Vector]"),0))00.105699306612548660.422797226450194631.05699306612548652.64248266531371322.642482665313713200002635INDEX(INDIRECT($C246&".Info[Information type]"),MATCH($C$242,INDIRECT($C246&".Info[Vector]"),0))tidal impoundment if >Xm tidal range00000000002227INDEX(INDIRECT($C247&".Info[Information type]"),MATCH($C$242,INDIRECT($C247&".Info[Vector]"),0))algae if 0.9W/m2 efficient00000000003010INDEX(Vectors[Description],MATCH($C249,Vectors[Code],0))Land area overseas2007201020152020202520302035204020452050Preferences.AreaUnitskm^21674INDEX(INDIRECT($C251&".Info[Information type]"),MATCH($C$249,INDIRECT($C251&".Info[Vector]"),0))biocrops overseas if 0.6W/m2 productivityINDEX(INDIRECT($C251&".Info["&H$232&"]"),MATCH($C$249,INDIRECT($C251&".Info[Vector]"),0))760.65100007605122INDEX(INDIRECT($C251&".Info["&I$232&"]"),MATCH($C$249,INDIRECT($C251&".Info[Vector]"),0))707.58232565214064619.13453494562305530.68674423910545442.23895353258791353.79116282607032265.34337211955273176.8955814130351688.447790706517580772INDEX(INDIRECT($C252&".Info[Information type]"),MATCH($C$249,INDIRECT($C252&".Info[Vector]"),0))solar devices overseas assuming 15W/m2 INDEX(INDIRECT($C252&".Info["&H$232&"]"),MATCH($C$249,INDIRECT($C252&".Info[Vector]"),0))46.6555206613788510000000003012INDEX(Vectors[Description],MATCH($C254,Vectors[Code],0))Length of wave front200720102015202020252030203520402045205013682633INDEX(INDIRECT($C256&".Info[Information type]"),MATCH($C$254,INDIRECT($C256&".Info[Vector]"),0))wave energy convertors if 25% efficientINDEX(INDIRECT($C256&".Info["&H$232&"]"),MATCH($C$254,INDIRECT($C256&".Info[Vector]"),0))0INDEX(INDIRECT($C256&".Info["&I$232&"]"),MATCH($C$254,INDIRECT($C256&".Info[Vector]"),0))03.8051750380517509E-22.00828682563842255.02071706409605065.020717064096050600002711INDEX(Vectors[Description],MATCH($C258,Vectors[Code],0))Number of units20072010201520202025203020352040204520502929740INDEX(INDIRECT($C260&".Info[Information type]"),MATCH($C$258,INDIRECT($C260&".Info[Vector]"),0))2 GW thermal power stationsINDEX(INDIRECT($C260&".Info["&H$232&"]"),MATCH($C$258,INDIRECT($C260&".Info[Vector]"),0))31.037804893601908INDEX(INDIRECT($C260&".Info["&I$232&"]"),MATCH($C$258,INDIRECT($C260&".Info[Vector]"),0))29.88540237544717527.44499081180905627.54895520798894627.93476682902075229.02304380901056331.90181638741096734.37666632633335736.80014893406700338.138958991754933869INDEX(INDIRECT($C261&".Info[Information type]"),MATCH($C$258,INDIRECT($C261&".Info[Vector]"),0))1.2 GW CCS power stationsINDEX(INDIRECT($C261&".Info["&H$232&"]"),MATCH($C$258,INDIRECT($C261&".Info[Vector]"),0))000.708333333333333481.4166666666666671.41666666666666671.41666666666666671.41666666666666671.41666666666666671.41666666666666671.4166666666666667754INDEX(INDIRECT($C262&".Info[Information type]"),MATCH($C$258,INDIRECT($C262&".Info[Vector]"),0))3 GW nuclear power station complexes3.66666666666666653.33333333333333352.41.20000000000000020.400000000000000190.400000000000000190000805INDEX(INDIRECT($C263&".Info[Information type]"),MATCH($C$258,INDIRECT($C263&".Info[Vector]"),0))0.05 GW geothermal power stations0000000000792INDEX(INDIRECT($C264&".Info[Information type]"),MATCH($C$258,INDIRECT($C264&".Info[Vector]"),0))1 GW standby generators0000000000205030523105Preferences.EnergyUnitsTWh310631073109310831103111990$Q$38124.395445838479871413037SUMIF($H$271:$H$361,$N271,$I$271:$I$361)37.42321810680604SUMIF($J$271:$J$361,$N271,$I$271:$I$361)0O271-P27137.42321810680604IF(Q271=0,"ok",IF(ABS(Q271)=SUM(O271:P271),"ok","error"))ok3031MAX(Q37,0)0141188011.192664433495876O272-P272-11.192664433495876IF(Q272=0,"ok",IF(ABS(Q272)=SUM(O272:P272),"ok","error"))ok991Q40132.625269939065162023036152.73058294116822152.730582941168250ok3032MAX(Q41,0)701.407824456434352023050000ok1013Q45101.583168307787530333039000ok3034MAX(Q44,0)1667.090671438096930333051000ok3035VI.a!O395+VI.a!O39617.6672996133445473036141124.39544583847987124.395445838479870ok2226VI.c!O56030363031000ok3037VI.a!O397+VI.a!O39837.423218106806043036990124.395445838479870124.39544583847987ok3038SUM(VI.b!O269:O271)97.64006522101766430368449.67780370201247569.67780370201247560ok3038VI.b!O26898.0930293664243181443944014.785449092646568-14.785449092646568ok3039V.b!O72014433040484.18230491441142484.182304914411470ok3050V.b!O73023055000ok141SUM(I271:I272)124.395445838479871443141834.69415269233971834.69415269233970ok202SUM(I273:I274)834.0330943954995723030341667.090671438096901667.0906714380969ok3033SUM(I275:I276)1768.6738397458844141013101.58316830778750101.5831683077875ok15IV.a!O71068453000ok68I287030403000ok15IV.b!O64030419147.2983252589987335E-27.2983252589987335E-20ok30439.4783444922061477E-29.4783444922061477E-20ok3036V.a!O19857.675549207546602144330460174.26990618059699-174.26990618059699ok3036V.a!O1997.744845969984377923030450585.99639826953421-585.99639826953421ok3036V.a!O20066.02031294645530614195.329728000000001105.3297280000000011ok3036V.a!O20621.28987481718195358430522.25468841170687-522.25468841170687ok1443MAX(-Q37,0)182.1154229434806130449430206.26698515563612-206.26698515563612ok230MAX(-Q41,0)030449560128.69-128.69ok14MAX(-Q44,0)0304430480101.39066503541156-101.39066503541156ok1443-I.a!O185-I.b!O19632.828670000000002304230470111.43620774985737-111.43620774985737ok230-I.a!O18603042230841.7779403654838841.777940365483910ok14-I.a!O187-I.b!O197952.483128120196973042580572.10497641817233-572.10497641817233ok0-II.a!O117030422226000ok3042XVII.a!O389.6778037020124756844185022.496144870285519-22.496144870285519ok3042I.a!O184+I.b!O195+II.a!O116+XVII.a!O39478.7647415944114830403033SUMIF($H$271:$H$361,$N303,$I$271:$I$361)1768.6738397458844SUMIF($J$271:$J$361,$N303,$I$271:$I$361)1768.67383974588440ok3042XVII.a!O40+I.a!O188+I.a!O189+I.b!O198+I.b!O199+II.a!O118+II.a!O119496.86925282377297580000ok1443-IX.a!O674-IX.c!O37903051202834.03309439549957834.033094395499570ok230-IX.a!O675-IX.c!O380030513032701.407824456434350701.40782445643435ok14-IX.a!O676-IX.c!O38103051991132.625269939065160132.62526993906516ok3051IX.a!O673+IX.c!O378030403038195.7330945874420195.733094587442ok3051IX.a!O681+IX.c!O38505830440182.11542294348061-182.11542294348061ok55VII.a!O59030403049000ok1III.a.1!O88+III.a.2!O928.7835319999996164E-230401008014.422595081474668-14.422595081474668ok70III.c!O157+III.c!O1650304010070335.92145196515742-335.92145196515742ok2III.c!O1490304015000ok3III.d!O640304068000ok19III.b!O775.329728000000001130403041000ok3040-VIII.a!O629.4783444922061477E-230431443280.16402441245077280.164024412450830ok3040MAX(-'2050'!T104,0)030443042985.31179812019695985.311798120196950ok3040VII.b!O3933.7717083305382035870000ok14-VIII.a!O6303043303517.667299613344547017.667299613344547ok3043VIII.a!O647.2983252589987335E-29142000ok3043VIII.a!O652.1800192332074142E-25818.7835319999996164E-208.7835319999996164E-2ok3041-IX.a!O69403045914-XII.a!O3457.2983252589987335E-210073049-IX.a!O695030453049-IX.c!O397030463051IX.a!O680030453051IX.c!O38403046844-IX.a!O69303045844-IX.c!O39603046844-XI.a!O217-XV.a!O1049.677803702012475643844I302-SUM(I328:I330)0583040-IX.a!O65760.65817298449702830451443-IX.a!O6592.3509560280439053045230-IX.a!O6602.1085894272146364304514-IX.a!O661520.8786798297786630453040-IX.c!O36332.76758846864765230461443-IX.c!O36503046230-IX.c!O3660.52296340154565946304614-IX.c!O367140.9793543104036630463040-X.a!O100103.40155946528074304714-X.a!O1018.034648284576636730473040-X.b!O9192.33773101406193304814-X.b!O929.05293402134962330483040-XI.a!O213-XV.a!O101-XV.b!O75135.90355298908176431443-XI.a!O214-XV.b!O7661.97356228624662643230-XI.a!O215-XV.a!O102133.713307805043294314-XI.a!O216-XV.a!O103-XV.b!O77180.98646162932269433040-VI.a!O3904.47706577339835031881443-VI.a!O3910.89541315467966998188230-VI.a!O3923.693579263053638618814-VI.a!O3932.1266062423642161883040-XII.a!O344-XII.b!O14513.8301380162672131007230-XII.a!O343-XII.b!O146322.0183306963002110073040-XII.a!O353-XII.b!O1536.94000442771645171008230-XII.a!O352-XII.b!O1547.48259065375821561008230-XII.a!O36114.785449092646568944230-XII.b!O16122.496144870285519185230-XII.c!O62206.26698515563612943230-XII.e!O61128.699563040-XIV.a!O71045314XVI.a!O6420.15234025434706358