# coding: utf-8
# Intermediate output
class Sheet7 < Spreadsheet
  def b2; "Energy source / use charts"; end
  def d4; "TWh / year"; end
  def f4; "2007 (Consistent)"; end
  def h4; 2007.0; end
  def i4; 2010.0; end
  def j4; 2015.0; end
  def k4; 2020.0; end
  def l4; 2025.0; end
  def m4; 2030.0; end
  def n4; 2035.0; end
  def o4; 2040.0; end
  def p4; 2045.0; end
  def q4; 2050.0; end
  def c6; "Use"; end
  def c7; "T.01"; end
  def d7; "Road transport"; end
  def f7; 502.50552967076953; end
  def h7; @h7 ||= sheet55.j109; end
  def i7; @i7 ||= sheet56.j109; end
  def j7; @j7 ||= sheet57.j109; end
  def k7; @k7 ||= sheet58.j109; end
  def l7; @l7 ||= sheet59.j109; end
  def m7; @m7 ||= sheet60.j109; end
  def n7; @n7 ||= sheet61.j109; end
  def o7; @o7 ||= sheet62.j109; end
  def p7; @p7 ||= sheet63.j109; end
  def q7; @q7 ||= sheet64.j109; end
  def c8; "T.02"; end
  def d8; "Rail transport"; end
  def f8; 16.24699816643595; end
  def h8; @h8 ||= sheet55.k109; end
  def i8; @i8 ||= sheet56.k109; end
  def j8; @j8 ||= sheet57.k109; end
  def k8; @k8 ||= sheet58.k109; end
  def l8; @l8 ||= sheet59.k109; end
  def m8; @m8 ||= sheet60.k109; end
  def n8; @n8 ||= sheet61.k109; end
  def o8; @o8 ||= sheet62.k109; end
  def p8; @p8 ||= sheet63.k109; end
  def q8; @q8 ||= sheet64.k109; end
  def c9; "T.03"; end
  def d9; "Domestic aviation"; end
  def f9; 8.73469387755102; end
  def h9; @h9 ||= sheet55.l109; end
  def i9; @i9 ||= sheet56.l109; end
  def j9; @j9 ||= sheet57.l109; end
  def k9; @k9 ||= sheet58.l109; end
  def l9; @l9 ||= sheet59.l109; end
  def m9; @m9 ||= sheet60.l109; end
  def n9; @n9 ||= sheet61.l109; end
  def o9; @o9 ||= sheet62.l109; end
  def p9; @p9 ||= sheet63.l109; end
  def q9; @q9 ||= sheet64.l109; end
  def c10; "T.04"; end
  def d10; "National navigation"; end
  def f10; 18.81937240536579; end
  def h10; @h10 ||= sheet55.m109; end
  def i10; @i10 ||= sheet56.m109; end
  def j10; @j10 ||= sheet57.m109; end
  def k10; @k10 ||= sheet58.m109; end
  def l10; @l10 ||= sheet59.m109; end
  def m10; @m10 ||= sheet60.m109; end
  def n10; @n10 ||= sheet61.m109; end
  def o10; @o10 ||= sheet62.m109; end
  def p10; @p10 ||= sheet63.m109; end
  def q10; @q10 ||= sheet64.m109; end
  def c11; "T.05"; end
  def d11; "International aviation"; end
  def f11; 152.99167541479133; end
  def h11; @h11 ||= sheet55.n109; end
  def i11; @i11 ||= sheet56.n109; end
  def j11; @j11 ||= sheet57.n109; end
  def k11; @k11 ||= sheet58.n109; end
  def l11; @l11 ||= sheet59.n109; end
  def m11; @m11 ||= sheet60.n109; end
  def n11; @n11 ||= sheet61.n109; end
  def o11; @o11 ||= sheet62.n109; end
  def p11; @p11 ||= sheet63.n109; end
  def q11; @q11 ||= sheet64.n109; end
  def c12; "T.06"; end
  def d12; "International shipping"; end
  def f12; 29.222291428230907; end
  def h12; @h12 ||= sheet55.o109; end
  def i12; @i12 ||= sheet56.o109; end
  def j12; @j12 ||= sheet57.o109; end
  def k12; @k12 ||= sheet58.o109; end
  def l12; @l12 ||= sheet59.o109; end
  def m12; @m12 ||= sheet60.o109; end
  def n12; @n12 ||= sheet61.o109; end
  def o12; @o12 ||= sheet62.o109; end
  def p12; @p12 ||= sheet63.o109; end
  def q12; @q12 ||= sheet64.o109; end
  def d13; "Transport"; end
  def f13; 728.5205609631445; end
  def h13; @h13 ||= sum(a('h7','h12')); end
  def i13; @i13 ||= sum(a('i7','i12')); end
  def j13; @j13 ||= sum(a('j7','j12')); end
  def k13; @k13 ||= sum(a('k7','k12')); end
  def l13; @l13 ||= sum(a('l7','l12')); end
  def m13; @m13 ||= sum(a('m7','m12')); end
  def n13; @n13 ||= sum(a('n7','n12')); end
  def o13; @o13 ||= sum(a('o7','o12')); end
  def p13; @p13 ||= sum(a('p7','p12')); end
  def q13; @q13 ||= sum(a('q7','q12')); end
  def c14; "I.01"; end
  def d14; "Industry"; end
  def f14; 443.27401323896316; end
  def h14; @h14 ||= sheet55.i109; end
  def i14; @i14 ||= sheet56.i109; end
  def j14; @j14 ||= sheet57.i109; end
  def k14; @k14 ||= sheet58.i109; end
  def l14; @l14 ||= sheet59.i109; end
  def m14; @m14 ||= sheet60.i109; end
  def n14; @n14 ||= sheet61.i109; end
  def o14; @o14 ||= sheet62.i109; end
  def p14; @p14 ||= sheet63.i109; end
  def q14; @q14 ||= sheet64.i109; end
  def c15; "H.01"; end
  def d15; "Heating and cooling"; end
  def f15; 544.7437698912538; end
  def h15; @h15 ||= sheet55.g109; end
  def i15; @i15 ||= sheet56.g109; end
  def j15; @j15 ||= sheet57.g109; end
  def k15; @k15 ||= sheet58.g109; end
  def l15; @l15 ||= sheet59.g109; end
  def m15; @m15 ||= sheet60.g109; end
  def n15; @n15 ||= sheet61.g109; end
  def o15; @o15 ||= sheet62.g109; end
  def p15; @p15 ||= sheet63.g109; end
  def q15; @q15 ||= sheet64.g109; end
  def c16; "L.01"; end
  def d16; "Lighting & appliances"; end
  def f16; 183.9950104721941; end
  def h16; @h16 ||= sheet55.h109; end
  def i16; @i16 ||= sheet56.h109; end
  def j16; @j16 ||= sheet57.h109; end
  def k16; @k16 ||= sheet58.h109; end
  def l16; @l16 ||= sheet59.h109; end
  def m16; @m16 ||= sheet60.h109; end
  def n16; @n16 ||= sheet61.h109; end
  def o16; @o16 ||= sheet62.h109; end
  def p16; @p16 ||= sheet63.h109; end
  def q16; @q16 ||= sheet64.h109; end
  def c17; "F.01"; end
  def d17; "Food consumption [UNUSED]"; end
  def f17; 59.09063200000001; end
  def h17; @h17 ||= sheet55.p109; end
  def i17; @i17 ||= sheet56.p109; end
  def j17; @j17 ||= sheet57.p109; end
  def k17; @k17 ||= sheet58.p109; end
  def l17; @l17 ||= sheet59.p109; end
  def m17; @m17 ||= sheet60.p109; end
  def n17; @n17 ||= sheet61.p109; end
  def o17; @o17 ||= sheet62.p109; end
  def p17; @p17 ||= sheet63.p109; end
  def q17; @q17 ||= sheet64.p109; end
  def d18; "Total Use"; end
  def f18; 1959.6239865655555; end
  def h18; @h18 ||= h13+h14+h15+h16+h17; end
  def i18; @i18 ||= i13+i14+i15+i16+i17; end
  def j18; @j18 ||= j13+j14+j15+j16+j17; end
  def k18; @k18 ||= k13+k14+k15+k16+k17; end
  def l18; @l18 ||= l13+l14+l15+l16+l17; end
  def m18; @m18 ||= m13+m14+m15+m16+m17; end
  def n18; @n18 ||= n13+n14+n15+n16+n17; end
  def o18; @o18 ||= o13+o14+o15+o16+o17; end
  def p18; @p18 ||= p13+p14+p15+p16+p17; end
  def q18; @q18 ||= q13+q14+q15+q16+q17; end
  def d20; "Dummy for charting uses"; end
  def h20; @h20 ||= max(0.0,h47-h18); end
  def i20; @i20 ||= max(0.0,i47-i18); end
  def j20; @j20 ||= max(0.0,j47-j18); end
  def k20; @k20 ||= max(0.0,k47-k18); end
  def l20; @l20 ||= max(0.0,l47-l18); end
  def m20; @m20 ||= max(0.0,m47-m18); end
  def n20; @n20 ||= max(0.0,n47-n18); end
  def o20; @o20 ||= max(0.0,o47-o18); end
  def p20; @p20 ||= max(0.0,p47-p18); end
  def q20; @q20 ||= max(0.0,q47-q18); end
  def c22; "Source"; end
  def c23; "N.01"; end
  def d23; "Nuclear fission"; end
  def f23; 163.24447683045062; end
  def h23; @h23 ||= -sheet55.av109; end
  def i23; @i23 ||= -sheet56.av109; end
  def j23; @j23 ||= -sheet57.av109; end
  def k23; @k23 ||= -sheet58.av109; end
  def l23; @l23 ||= -sheet59.av109; end
  def m23; @m23 ||= -sheet60.av109; end
  def n23; @n23 ||= -sheet61.av109; end
  def o23; @o23 ||= -sheet62.av109; end
  def p23; @p23 ||= -sheet63.av109; end
  def q23; @q23 ||= -sheet64.av109; end
  def c24; "R.01"; end
  def d24; "Solar"; end
  def f24; 0.5360591477000001; end
  def h24; @h24 ||= -sheet55.aw109; end
  def i24; @i24 ||= -sheet56.aw109; end
  def j24; @j24 ||= -sheet57.aw109; end
  def k24; @k24 ||= -sheet58.aw109; end
  def l24; @l24 ||= -sheet59.aw109; end
  def m24; @m24 ||= -sheet60.aw109; end
  def n24; @n24 ||= -sheet61.aw109; end
  def o24; @o24 ||= -sheet62.aw109; end
  def p24; @p24 ||= -sheet63.aw109; end
  def q24; @q24 ||= -sheet64.aw109; end
  def c25; "R.02"; end
  def d25; "Wind"; end
  def f25; 6.978861884782586; end
  def h25; @h25 ||= -sheet55.ax109; end
  def i25; @i25 ||= -sheet56.ax109; end
  def j25; @j25 ||= -sheet57.ax109; end
  def k25; @k25 ||= -sheet58.ax109; end
  def l25; @l25 ||= -sheet59.ax109; end
  def m25; @m25 ||= -sheet60.ax109; end
  def n25; @n25 ||= -sheet61.ax109; end
  def o25; @o25 ||= -sheet62.ax109; end
  def p25; @p25 ||= -sheet63.ax109; end
  def q25; @q25 ||= -sheet64.ax109; end
  def c26; "R.03"; end
  def d26; "Tidal"; end
  def f26; 0.0; end
  def h26; @h26 ||= -sheet55.ay109; end
  def i26; @i26 ||= -sheet56.ay109; end
  def j26; @j26 ||= -sheet57.ay109; end
  def k26; @k26 ||= -sheet58.ay109; end
  def l26; @l26 ||= -sheet59.ay109; end
  def m26; @m26 ||= -sheet60.ay109; end
  def n26; @n26 ||= -sheet61.ay109; end
  def o26; @o26 ||= -sheet62.ay109; end
  def p26; @p26 ||= -sheet63.ay109; end
  def q26; @q26 ||= -sheet64.ay109; end
  def c27; "R.04"; end
  def d27; "Wave"; end
  def f27; 0.0; end
  def h27; @h27 ||= -sheet55.az109; end
  def i27; @i27 ||= -sheet56.az109; end
  def j27; @j27 ||= -sheet57.az109; end
  def k27; @k27 ||= -sheet58.az109; end
  def l27; @l27 ||= -sheet59.az109; end
  def m27; @m27 ||= -sheet60.az109; end
  def n27; @n27 ||= -sheet61.az109; end
  def o27; @o27 ||= -sheet62.az109; end
  def p27; @p27 ||= -sheet63.az109; end
  def q27; @q27 ||= -sheet64.az109; end
  def c28; "R.05"; end
  def d28; "Geothermal"; end
  def f28; 0.0; end
  def h28; @h28 ||= -sheet55.ba109; end
  def i28; @i28 ||= -sheet56.ba109; end
  def j28; @j28 ||= -sheet57.ba109; end
  def k28; @k28 ||= -sheet58.ba109; end
  def l28; @l28 ||= -sheet59.ba109; end
  def m28; @m28 ||= -sheet60.ba109; end
  def n28; @n28 ||= -sheet61.ba109; end
  def o28; @o28 ||= -sheet62.ba109; end
  def p28; @p28 ||= -sheet63.ba109; end
  def q28; @q28 ||= -sheet64.ba109; end
  def c29; "R.06"; end
  def d29; "Hydro"; end
  def f29; 5.088394340000001; end
  def h29; @h29 ||= -sheet55.bb109; end
  def i29; @i29 ||= -sheet56.bb109; end
  def j29; @j29 ||= -sheet57.bb109; end
  def k29; @k29 ||= -sheet58.bb109; end
  def l29; @l29 ||= -sheet59.bb109; end
  def m29; @m29 ||= -sheet60.bb109; end
  def n29; @n29 ||= -sheet61.bb109; end
  def o29; @o29 ||= -sheet62.bb109; end
  def p29; @p29 ||= -sheet63.bb109; end
  def q29; @q29 ||= -sheet64.bb109; end
  def c30; "Y.02"; end
  def d30; "Electricity oversupply (imports)"; end
  def f30; 5.21452425; end
  def h30; @h30 ||= -sheet55.aq109; end
  def i30; @i30 ||= -sheet56.aq109; end
  def j30; @j30 ||= -sheet57.aq109; end
  def k30; @k30 ||= -sheet58.aq109; end
  def l30; @l30 ||= -sheet59.aq109; end
  def m30; @m30 ||= -sheet60.aq109; end
  def n30; @n30 ||= -sheet61.aq109; end
  def o30; @o30 ||= -sheet62.aq109; end
  def p30; @p30 ||= -sheet63.aq109; end
  def q30; @q30 ||= -sheet64.aq109; end
  def d31; "Primary electricity, solar, marine, and net imports"; end
  def f31; 181.06231645293323; end
  def h31; @h31 ||= sum(a('h23','h30')); end
  def i31; @i31 ||= sum(a('i23','i30')); end
  def j31; @j31 ||= sum(a('j23','j30')); end
  def k31; @k31 ||= sum(a('k23','k30')); end
  def l31; @l31 ||= sum(a('l23','l30')); end
  def m31; @m31 ||= sum(a('m23','m30')); end
  def n31; @n31 ||= sum(a('n23','n30')); end
  def o31; @o31 ||= sum(a('o23','o30')); end
  def p31; @p31 ||= sum(a('p23','p30')); end
  def q31; @q31 ||= sum(a('q23','q30')); end
  def c32; "R.07"; end
  def d32; "Environmental heat"; end
  def f32; 0.0; end
  def h32; @h32 ||= -sheet55.bc109; end
  def i32; @i32 ||= -sheet56.bc109; end
  def j32; @j32 ||= -sheet57.bc109; end
  def k32; @k32 ||= -sheet58.bc109; end
  def l32; @l32 ||= -sheet59.bc109; end
  def m32; @m32 ||= -sheet60.bc109; end
  def n32; @n32 ||= -sheet61.bc109; end
  def o32; @o32 ||= -sheet62.bc109; end
  def p32; @p32 ||= -sheet63.bc109; end
  def q32; @q32 ||= -sheet64.bc109; end
  def c33; "W.01"; end
  def d33; "Waste"; end
  def f33; 14.240524277899516; end
  def h33; @h33 ||= -sheet55.be109; end
  def i33; @i33 ||= -sheet56.be109; end
  def j33; @j33 ||= -sheet57.be109; end
  def k33; @k33 ||= -sheet58.be109; end
  def l33; @l33 ||= -sheet59.be109; end
  def m33; @m33 ||= -sheet60.be109; end
  def n33; @n33 ||= -sheet61.be109; end
  def o33; @o33 ||= -sheet62.be109; end
  def p33; @p33 ||= -sheet63.be109; end
  def q33; @q33 ||= -sheet64.be109; end
  def c34; "A.01"; end
  def d34; "Agriculture"; end
  def f34; 58.005772267812624; end
  def h34; @h34 ||= -sheet55.bd109; end
  def i34; @i34 ||= -sheet56.bd109; end
  def j34; @j34 ||= -sheet57.bd109; end
  def k34; @k34 ||= -sheet58.bd109; end
  def l34; @l34 ||= -sheet59.bd109; end
  def m34; @m34 ||= -sheet60.bd109; end
  def n34; @n34 ||= -sheet61.bd109; end
  def o34; @o34 ||= -sheet62.bd109; end
  def p34; @p34 ||= -sheet63.bd109; end
  def q34; @q34 ||= -sheet64.bd109; end
  def c35; "Y.01"; end
  def d35; "Biomass oversupply (imports)"; end
  def f35; 26.262503111111116; end
  def h35; @h35 ||= -sheet55.ap109; end
  def i35; @i35 ||= -sheet56.ap109; end
  def j35; @j35 ||= -sheet57.ap109; end
  def k35; @k35 ||= -sheet58.ap109; end
  def l35; @l35 ||= -sheet59.ap109; end
  def m35; @m35 ||= -sheet60.ap109; end
  def n35; @n35 ||= -sheet61.ap109; end
  def o35; @o35 ||= -sheet62.ap109; end
  def p35; @p35 ||= -sheet63.ap109; end
  def q35; @q35 ||= -sheet64.ap109; end
  def d36; "Agriculture, waste, and biomatter imports"; end
  def f36; 98.50879965682326; end
  def h36; @h36 ||= sum(a('h33','h35')); end
  def i36; @i36 ||= sum(a('i33','i35')); end
  def j36; @j36 ||= sum(a('j33','j35')); end
  def k36; @k36 ||= sum(a('k33','k35')); end
  def l36; @l36 ||= sum(a('l33','l35')); end
  def m36; @m36 ||= sum(a('m33','m35')); end
  def n36; @n36 ||= sum(a('n33','n35')); end
  def o36; @o36 ||= sum(a('o33','o35')); end
  def p36; @p36 ||= sum(a('p33','p35')); end
  def q36; @q36 ||= sum(a('q33','q35')); end
  def c37; "Y.04"; end
  def d37; "Coal oversupply (imports)"; end
  def f37; 329.602732356217; end
  def h37; @h37 ||= -sheet55.as109; end
  def i37; @i37 ||= -sheet56.as109; end
  def j37; @j37 ||= -sheet57.as109; end
  def k37; @k37 ||= -sheet58.as109; end
  def l37; @l37 ||= -sheet59.as109; end
  def m37; @m37 ||= -sheet60.as109; end
  def n37; @n37 ||= -sheet61.as109; end
  def o37; @o37 ||= -sheet62.as109; end
  def p37; @p37 ||= -sheet63.as109; end
  def q37; @q37 ||= -sheet64.as109; end
  def c38; "Q.01"; end
  def d38; "Coal reserves"; end
  def f38; 145.79944495555736; end
  def h38; @h38 ||= -sheet55.am109; end
  def i38; @i38 ||= -sheet56.am109; end
  def j38; @j38 ||= -sheet57.am109; end
  def k38; @k38 ||= -sheet58.am109; end
  def l38; @l38 ||= -sheet59.am109; end
  def m38; @m38 ||= -sheet60.am109; end
  def n38; @n38 ||= -sheet61.am109; end
  def o38; @o38 ||= -sheet62.am109; end
  def p38; @p38 ||= -sheet63.am109; end
  def q38; @q38 ||= -sheet64.am109; end
  def d39; "Coal"; end
  def f39; 475.4021773117744; end
  def h39; @h39 ||= sum(a('h37','h38')); end
  def i39; @i39 ||= sum(a('i37','i38')); end
  def j39; @j39 ||= sum(a('j37','j38')); end
  def k39; @k39 ||= sum(a('k37','k38')); end
  def l39; @l39 ||= sum(a('l37','l38')); end
  def m39; @m39 ||= sum(a('m37','m38')); end
  def n39; @n39 ||= sum(a('n37','n38')); end
  def o39; @o39 ||= sum(a('o37','o38')); end
  def p39; @p39 ||= sum(a('p37','p38')); end
  def q39; @q39 ||= sum(a('q37','q38')); end
  def c40; "Q.02"; end
  def d40; "Oil reserves"; end
  def f40; 887.460075730032; end
  def h40; @h40 ||= -sheet55.an109; end
  def i40; @i40 ||= -sheet56.an109; end
  def j40; @j40 ||= -sheet57.an109; end
  def k40; @k40 ||= -sheet58.an109; end
  def l40; @l40 ||= -sheet59.an109; end
  def m40; @m40 ||= -sheet60.an109; end
  def n40; @n40 ||= -sheet61.an109; end
  def o40; @o40 ||= -sheet62.an109; end
  def p40; @p40 ||= -sheet63.an109; end
  def q40; @q40 ||= -sheet64.an109; end
  def c41; "Y.05"; end
  def d41; "Oil and petroleum products oversupply (imports)"; end
  def f41; 79.74397690520158; end
  def h41; @h41 ||= -sheet55.at109; end
  def i41; @i41 ||= -sheet56.at109; end
  def j41; @j41 ||= -sheet57.at109; end
  def k41; @k41 ||= -sheet58.at109; end
  def l41; @l41 ||= -sheet59.at109; end
  def m41; @m41 ||= -sheet60.at109; end
  def n41; @n41 ||= -sheet61.at109; end
  def o41; @o41 ||= -sheet62.at109; end
  def p41; @p41 ||= -sheet63.at109; end
  def q41; @q41 ||= -sheet64.at109; end
  def c42; "Y.03"; end
  def d42; "Petroleum products oversupply"; end
  def f42; -60.58105389631571; end
  def h42; @h42 ||= -sheet55.ar109; end
  def i42; @i42 ||= -sheet56.ar109; end
  def j42; @j42 ||= -sheet57.ar109; end
  def k42; @k42 ||= -sheet58.ar109; end
  def l42; @l42 ||= -sheet59.ar109; end
  def m42; @m42 ||= -sheet60.ar109; end
  def n42; @n42 ||= -sheet61.ar109; end
  def o42; @o42 ||= -sheet62.ar109; end
  def p42; @p42 ||= -sheet63.ar109; end
  def q42; @q42 ||= -sheet64.ar109; end
  def d43; "Oil and petroleum products"; end
  def f43; 906.622998738918; end
  def h43; @h43 ||= sum(a('h40','h42')); end
  def i43; @i43 ||= sum(a('i40','i42')); end
  def j43; @j43 ||= sum(a('j40','j42')); end
  def k43; @k43 ||= sum(a('k40','k42')); end
  def l43; @l43 ||= sum(a('l40','l42')); end
  def m43; @m43 ||= sum(a('m40','m42')); end
  def n43; @n43 ||= sum(a('n40','n42')); end
  def o43; @o43 ||= sum(a('o40','o42')); end
  def p43; @p43 ||= sum(a('p40','p42')); end
  def q43; @q43 ||= sum(a('q40','q42')); end
  def c44; "Y.06"; end
  def d44; "Gas oversupply (imports)"; end
  def f44; 214.86865308275657; end
  def h44; @h44 ||= -sheet55.au109; end
  def i44; @i44 ||= -sheet56.au109; end
  def j44; @j44 ||= -sheet57.au109; end
  def k44; @k44 ||= -sheet58.au109; end
  def l44; @l44 ||= -sheet59.au109; end
  def m44; @m44 ||= -sheet60.au109; end
  def n44; @n44 ||= -sheet61.au109; end
  def o44; @o44 ||= -sheet62.au109; end
  def p44; @p44 ||= -sheet63.au109; end
  def q44; @q44 ||= -sheet64.au109; end
  def c45; "Q.03"; end
  def d45; "Gas reserves"; end
  def f45; 834.0611502141918; end
  def h45; @h45 ||= -sheet55.ao109; end
  def i45; @i45 ||= -sheet56.ao109; end
  def j45; @j45 ||= -sheet57.ao109; end
  def k45; @k45 ||= -sheet58.ao109; end
  def l45; @l45 ||= -sheet59.ao109; end
  def m45; @m45 ||= -sheet60.ao109; end
  def n45; @n45 ||= -sheet61.ao109; end
  def o45; @o45 ||= -sheet62.ao109; end
  def p45; @p45 ||= -sheet63.ao109; end
  def q45; @q45 ||= -sheet64.ao109; end
  def d46; "Natural gas"; end
  def f46; 1048.9298032969484; end
  def h46; @h46 ||= sum(a('h44','h45')); end
  def i46; @i46 ||= sum(a('i44','i45')); end
  def j46; @j46 ||= sum(a('j44','j45')); end
  def k46; @k46 ||= sum(a('k44','k45')); end
  def l46; @l46 ||= sum(a('l44','l45')); end
  def m46; @m46 ||= sum(a('m44','m45')); end
  def n46; @n46 ||= sum(a('n44','n45')); end
  def o46; @o46 ||= sum(a('o44','o45')); end
  def p46; @p46 ||= sum(a('p44','p45')); end
  def q46; @q46 ||= sum(a('q44','q45')); end
  def d47; "Total Primary Supply"; end
  def f47; 2710.526095457397; end
  def h47; @h47 ||= h31+h32+h36+h39+h43+h46; end
  def i47; @i47 ||= i31+i32+i36+i39+i43+i46; end
  def j47; @j47 ||= j31+j32+j36+j39+j43+j46; end
  def k47; @k47 ||= k31+k32+k36+k39+k43+k46; end
  def l47; @l47 ||= l31+l32+l36+l39+l43+l46; end
  def m47; @m47 ||= m31+m32+m36+m39+m43+m46; end
  def n47; @n47 ||= n31+n32+n36+n39+n43+n46; end
  def o47; @o47 ||= o31+o32+o36+o39+o43+o46; end
  def p47; @p47 ||= p31+p32+p36+p39+p43+p46; end
  def q47; @q47 ||= q31+q32+q36+q39+q43+q46; end
  def d49; "Dummy for charting supply"; end
  def h49; @h49 ||= max(0.0,-(h47-h18)); end
  def i49; @i49 ||= max(0.0,-(i47-i18)); end
  def j49; @j49 ||= max(0.0,-(j47-j18)); end
  def k49; @k49 ||= max(0.0,-(k47-k18)); end
  def l49; @l49 ||= max(0.0,-(l47-l18)); end
  def m49; @m49 ||= max(0.0,-(m47-m18)); end
  def n49; @n49 ||= max(0.0,-(n47-n18)); end
  def o49; @o49 ||= max(0.0,-(o47-o18)); end
  def p49; @p49 ||= max(0.0,-(p47-p18)); end
  def q49; @q49 ||= max(0.0,-(q47-q18)); end
  def c51; "Conversion losses, distribution, and own use"; end
  def c52; "X.01"; end
  def d52; "Conversion losses"; end
  def f52; 561.4193024884444; end
  def h52; @h52 ||= sheet55.bh109; end
  def i52; @i52 ||= sheet56.bh109; end
  def j52; @j52 ||= sheet57.bh109; end
  def k52; @k52 ||= sheet58.bh109; end
  def l52; @l52 ||= sheet59.bh109; end
  def m52; @m52 ||= sheet60.bh109; end
  def n52; @n52 ||= sheet61.bh109; end
  def o52; @o52 ||= sheet62.bh109; end
  def p52; @p52 ||= sheet63.bh109; end
  def q52; @q52 ||= sheet64.bh109; end
  def c53; "X.02"; end
  def d53; "Distribution losses and own use"; end
  def f53; 186.94703532055274; end
  def h53; @h53 ||= sheet55.bi109; end
  def i53; @i53 ||= sheet56.bi109; end
  def j53; @j53 ||= sheet57.bi109; end
  def k53; @k53 ||= sheet58.bi109; end
  def l53; @l53 ||= sheet59.bi109; end
  def m53; @m53 ||= sheet60.bi109; end
  def n53; @n53 ||= sheet61.bi109; end
  def o53; @o53 ||= sheet62.bi109; end
  def p53; @p53 ||= sheet63.bi109; end
  def q53; @q53 ||= sheet64.bi109; end
  def d54; "Supply net of losses"; end
  def f54; 1962.1597576483998; end
  def h54; @h54 ||= h47-sum(a('h52','h53')); end
  def i54; @i54 ||= i47-sum(a('i52','i53')); end
  def j54; @j54 ||= j47-sum(a('j52','j53')); end
  def k54; @k54 ||= k47-sum(a('k52','k53')); end
  def l54; @l54 ||= l47-sum(a('l52','l53')); end
  def m54; @m54 ||= m47-sum(a('m52','m53')); end
  def n54; @n54 ||= n47-sum(a('n52','n53')); end
  def o54; @o54 ||= o47-sum(a('o52','o53')); end
  def p54; @p54 ||= p47-sum(a('p52','p53')); end
  def q54; @q54 ||= q47-sum(a('q52','q53')); end
  def c56; "Supply / demand not accounted for"; end
  def c58; "C.01"; end
  def d58; "Coal and fossil waste"; end
  def f58; 0.4668835385115244; end
  def h58; @h58 ||= sheet55.x109; end
  def i58; @i58 ||= sheet56.x109; end
  def j58; @j58 ||= sheet57.x109; end
  def k58; @k58 ||= sheet58.x109; end
  def l58; @l58 ||= sheet59.x109; end
  def m58; @m58 ||= sheet60.x109; end
  def n58; @n58 ||= sheet61.x109; end
  def o58; @o58 ||= sheet62.x109; end
  def p58; @p58 ||= sheet63.x109; end
  def q58; @q58 ||= sheet64.x109; end
  def c59; "C.02"; end
  def d59; "Oil and petroleum products"; end
  def f59; 35.99412042466514; end
  def h59; @h59 ||= sheet55.y109; end
  def i59; @i59 ||= sheet56.y109; end
  def j59; @j59 ||= sheet57.y109; end
  def k59; @k59 ||= sheet58.y109; end
  def l59; @l59 ||= sheet59.y109; end
  def m59; @m59 ||= sheet60.y109; end
  def n59; @n59 ||= sheet61.y109; end
  def o59; @o59 ||= sheet62.y109; end
  def p59; @p59 ||= sheet63.y109; end
  def q59; @q59 ||= sheet64.y109; end
  def c60; "C.03"; end
  def d60; "Natural gas"; end
  def f60; -10.228142999999932; end
  def h60; @h60 ||= sheet55.z109; end
  def i60; @i60 ||= sheet56.z109; end
  def j60; @j60 ||= sheet57.z109; end
  def k60; @k60 ||= sheet58.z109; end
  def l60; @l60 ||= sheet59.z109; end
  def m60; @m60 ||= sheet60.z109; end
  def n60; @n60 ||= sheet61.z109; end
  def o60; @o60 ||= sheet62.z109; end
  def p60; @p60 ||= sheet63.z109; end
  def q60; @q60 ||= sheet64.z109; end
  def c61; "V.03"; end
  def d61; "Solid hydrocarbons"; end
  def f61; 0.0; end
  def h61; @h61 ||= sheet55.u109; end
  def i61; @i61 ||= sheet56.u109; end
  def j61; @j61 ||= sheet57.u109; end
  def k61; @k61 ||= sheet58.u109; end
  def l61; @l61 ||= sheet59.u109; end
  def m61; @m61 ||= sheet60.u109; end
  def n61; @n61 ||= sheet61.u109; end
  def o61; @o61 ||= sheet62.u109; end
  def p61; @p61 ||= sheet63.u109; end
  def q61; @q61 ||= sheet64.u109; end
  def c62; "V.04"; end
  def d62; "Liquid hydrocarbons"; end
  def f62; -40.98525046434433; end
  def h62; @h62 ||= sheet55.v109; end
  def i62; @i62 ||= sheet56.v109; end
  def j62; @j62 ||= sheet57.v109; end
  def k62; @k62 ||= sheet58.v109; end
  def l62; @l62 ||= sheet59.v109; end
  def m62; @m62 ||= sheet60.v109; end
  def n62; @n62 ||= sheet61.v109; end
  def o62; @o62 ||= sheet62.v109; end
  def p62; @p62 ||= sheet63.v109; end
  def q62; @q62 ||= sheet64.v109; end
  def c63; "V.05"; end
  def d63; "Gaseous hydrocarbons"; end
  def f63; 15.047768550745332; end
  def h63; @h63 ||= sheet55.w109; end
  def i63; @i63 ||= sheet56.w109; end
  def j63; @j63 ||= sheet57.w109; end
  def k63; @k63 ||= sheet58.w109; end
  def l63; @l63 ||= sheet59.w109; end
  def m63; @m63 ||= sheet60.w109; end
  def n63; @n63 ||= sheet61.w109; end
  def o63; @o63 ||= sheet62.w109; end
  def p63; @p63 ||= sheet63.w109; end
  def q63; @q63 ||= sheet64.w109; end
  def c64; "V.06"; end
  def d64; "Blast furnace gas"; end
  def f64; -0.11045622230000071; end
  def h64; @h64 ||= sheet55.aa109; end
  def i64; @i64 ||= sheet56.aa109; end
  def j64; @j64 ||= sheet57.aa109; end
  def k64; @k64 ||= sheet58.aa109; end
  def l64; @l64 ||= sheet59.aa109; end
  def m64; @m64 ||= sheet60.aa109; end
  def n64; @n64 ||= sheet61.aa109; end
  def o64; @o64 ||= sheet62.aa109; end
  def p64; @p64 ||= sheet63.aa109; end
  def q64; @q64 ||= sheet64.aa109; end
  def c65; "V.08"; end
  def d65; "Edible biomass"; end
  def f65; 0.0; end
  def h65; @h65 ||= sheet55.ac109; end
  def i65; @i65 ||= sheet56.ac109; end
  def j65; @j65 ||= sheet57.ac109; end
  def k65; @k65 ||= sheet58.ac109; end
  def l65; @l65 ||= sheet59.ac109; end
  def m65; @m65 ||= sheet60.ac109; end
  def n65; @n65 ||= sheet61.ac109; end
  def o65; @o65 ||= sheet62.ac109; end
  def p65; @p65 ||= sheet63.ac109; end
  def q65; @q65 ||= sheet64.ac109; end
  def c66; "V.07"; end
  def d66; "Heat transport"; end
  def f66; 0.0029616599999983118; end
  def h66; @h66 ||= sheet55.ab109; end
  def i66; @i66 ||= sheet56.ab109; end
  def j66; @j66 ||= sheet57.ab109; end
  def k66; @k66 ||= sheet58.ab109; end
  def l66; @l66 ||= sheet59.ab109; end
  def m66; @m66 ||= sheet60.ab109; end
  def n66; @n66 ||= sheet61.ab109; end
  def o66; @o66 ||= sheet62.ab109; end
  def p66; @p66 ||= sheet63.ab109; end
  def q66; @q66 ||= sheet64.ab109; end
  def c67; "V.09"; end
  def d67; "Dry biomass and waste"; end
  def f67; -0.3409880345172063; end
  def h67; @h67 ||= sheet55.af109; end
  def i67; @i67 ||= sheet56.af109; end
  def j67; @j67 ||= sheet57.af109; end
  def k67; @k67 ||= sheet58.af109; end
  def l67; @l67 ||= sheet59.af109; end
  def m67; @m67 ||= sheet60.af109; end
  def n67; @n67 ||= sheet61.af109; end
  def o67; @o67 ||= sheet62.af109; end
  def p67; @p67 ||= sheet63.af109; end
  def q67; @q67 ||= sheet64.af109; end
  def c68; "V.10"; end
  def d68; "Wet biomass and waste"; end
  def f68; 0.0; end
  def h68; @h68 ||= sheet55.ag109; end
  def i68; @i68 ||= sheet56.ag109; end
  def j68; @j68 ||= sheet57.ag109; end
  def k68; @k68 ||= sheet58.ag109; end
  def l68; @l68 ||= sheet59.ag109; end
  def m68; @m68 ||= sheet60.ag109; end
  def n68; @n68 ||= sheet61.ag109; end
  def o68; @o68 ||= sheet62.ag109; end
  def p68; @p68 ||= sheet63.ag109; end
  def q68; @q68 ||= sheet64.ag109; end
  def c69; "V.11"; end
  def d69; "Domestic solar thermal"; end
  def f69; 0.0; end
  def h69; @h69 ||= sheet55.ai109; end
  def i69; @i69 ||= sheet56.ai109; end
  def j69; @j69 ||= sheet57.ai109; end
  def k69; @k69 ||= sheet58.ai109; end
  def l69; @l69 ||= sheet59.ai109; end
  def m69; @m69 ||= sheet60.ai109; end
  def n69; @n69 ||= sheet61.ai109; end
  def o69; @o69 ||= sheet62.ai109; end
  def p69; @p69 ||= sheet63.ai109; end
  def q69; @q69 ||= sheet64.ai109; end
  def c70; "V.12"; end
  def d70; "H2"; end
  def f70; 0.0; end
  def h70; @h70 ||= sheet55.aj109; end
  def i70; @i70 ||= sheet56.aj109; end
  def j70; @j70 ||= sheet57.aj109; end
  def k70; @k70 ||= sheet58.aj109; end
  def l70; @l70 ||= sheet59.aj109; end
  def m70; @m70 ||= sheet60.aj109; end
  def n70; @n70 ||= sheet61.aj109; end
  def o70; @o70 ||= sheet62.aj109; end
  def p70; @p70 ||= sheet63.aj109; end
  def q70; @q70 ||= sheet64.aj109; end
  def c71; "V.13"; end
  def d71; "Energy crops (second generation)"; end
  def f71; 0.0; end
  def h71; @h71 ||= sheet55.ad109; end
  def i71; @i71 ||= sheet56.ad109; end
  def j71; @j71 ||= sheet57.ad109; end
  def k71; @k71 ||= sheet58.ad109; end
  def l71; @l71 ||= sheet59.ad109; end
  def m71; @m71 ||= sheet60.ad109; end
  def n71; @n71 ||= sheet61.ad109; end
  def o71; @o71 ||= sheet62.ad109; end
  def p71; @p71 ||= sheet63.ad109; end
  def q71; @q71 ||= sheet64.ad109; end
  def d72; "Total unnaccounted supply / demand"; end
  def f72; -0.15310354723947603; end
  def h72; @h72 ||= sum(a('h58','h71')); end
  def i72; @i72 ||= sum(a('i58','i71')); end
  def j72; @j72 ||= sum(a('j58','j71')); end
  def k72; @k72 ||= sum(a('k58','k71')); end
  def l72; @l72 ||= sum(a('l58','l71')); end
  def m72; @m72 ||= sum(a('m58','m71')); end
  def n72; @n72 ||= sum(a('n58','n71')); end
  def o72; @o72 ||= sum(a('o58','o71')); end
  def p72; @p72 ||= sum(a('p58','p71')); end
  def q72; @q72 ||= sum(a('q58','q71')); end
  def d74; "Supply, Demand, and Unaccounted supply"; end
  def f74; -2.688874630083825; end
  def h74; @h74 ||= h18-h54+h72; end
  def i74; @i74 ||= i18-i54+i72; end
  def j74; @j74 ||= j18-j54+j72; end
  def k74; @k74 ||= k18-k54+k72; end
  def l74; @l74 ||= l18-l54+l72; end
  def m74; @m74 ||= m18-m54+m72; end
  def n74; @n74 ||= n18-n54+n72; end
  def o74; @o74 ||= o18-o54+o72; end
  def p74; @p74 ||= p18-p54+p72; end
  def q74; @q74 ||= q18-q54+q72; end
  def b78; "Electricity grid (net of distribution losses)"; end
  def c80; "V.01"; end
  def d80; "Electricity (delivered to end user)"; end
  def f80; -352.03495223253594; end
  def h80; @h80 ||= sheet55.s109; end
  def i80; @i80 ||= sheet56.s109; end
  def j80; @j80 ||= sheet57.s109; end
  def k80; @k80 ||= sheet58.s109; end
  def l80; @l80 ||= sheet59.s109; end
  def m80; @m80 ||= sheet60.s109; end
  def n80; @n80 ||= sheet61.s109; end
  def o80; @o80 ||= sheet62.s109; end
  def p80; @p80 ||= sheet63.s109; end
  def q80; @q80 ||= sheet64.s109; end
  def c81; "V.02"; end
  def d81; "Electricity (supplied to grid)"; end
  def f81; 354.72382686261983; end
  def h81; @h81 ||= sheet55.t109; end
  def i81; @i81 ||= sheet56.t109; end
  def j81; @j81 ||= sheet57.t109; end
  def k81; @k81 ||= sheet58.t109; end
  def l81; @l81 ||= sheet59.t109; end
  def m81; @m81 ||= sheet60.t109; end
  def n81; @n81 ||= sheet61.t109; end
  def o81; @o81 ||= sheet62.t109; end
  def p81; @p81 ||= sheet63.t109; end
  def q81; @q81 ||= sheet64.t109; end
  def d82; "Total electricity grid"; end
  def f82; 2.6888746300838875; end
  def h82; @h82 ||= sum(a('h80','h81')); end
  def i82; @i82 ||= sum(a('i80','i81')); end
  def j82; @j82 ||= sum(a('j80','j81')); end
  def k82; @k82 ||= sum(a('k80','k81')); end
  def l82; @l82 ||= sum(a('l80','l81')); end
  def m82; @m82 ||= sum(a('m80','m81')); end
  def n82; @n82 ||= sum(a('n80','n81')); end
  def o82; @o82 ||= sum(a('o80','o81')); end
  def p82; @p82 ||= sum(a('p80','p81')); end
  def q82; @q82 ||= sum(a('q80','q81')); end
  def c84; "V.02"; end
  def d84; "Losses"; end
  def h84; @h84 ||= sheet55.t91; end
  def i84; @i84 ||= sheet56.t91; end
  def j84; @j84 ||= sheet57.t91; end
  def k84; @k84 ||= sheet58.t91; end
  def l84; @l84 ||= sheet59.t91; end
  def m84; @m84 ||= sheet60.t91; end
  def n84; @n84 ||= sheet61.t91; end
  def o84; @o84 ||= sheet62.t91; end
  def p84; @p84 ||= sheet63.t91; end
  def q84; @q84 ||= sheet64.t91; end
  def d85; "Demand (for charting)"; end
  def h85; @h85 ||= -h80-h84; end
  def i85; @i85 ||= -i80-i84; end
  def j85; @j85 ||= -j80-j84; end
  def k85; @k85 ||= -k80-k84; end
  def l85; @l85 ||= -l80-l84; end
  def m85; @m85 ||= -m80-m84; end
  def n85; @n85 ||= -n80-n84; end
  def o85; @o85 ||= -o80-o84; end
  def p85; @p85 ||= -p80-p84; end
  def q85; @q85 ||= -q80-q84; end
  def d86; "Dummy for charting"; end
  def h86; @h86 ||= h111; end
  def i86; @i86 ||= i111; end
  def j86; @j86 ||= j111; end
  def k86; @k86 ||= k111; end
  def l86; @l86 ||= l111; end
  def m86; @m86 ||= m111; end
  def n86; @n86 ||= n111; end
  def o86; @o86 ||= o111; end
  def p86; @p86 ||= p111; end
  def q86; @q86 ||= q111; end
  def c89; "Z.01"; end
  def d89; "Unallocated"; end
  def f89; 0.0; end
  def h89; @h89 ||= sheet55.bl109; end
  def i89; @i89 ||= sheet56.bl109; end
  def j89; @j89 ||= sheet57.bl109; end
  def k89; @k89 ||= sheet58.bl109; end
  def l89; @l89 ||= sheet59.bl109; end
  def m89; @m89 ||= sheet60.bl109; end
  def n89; @n89 ||= sheet61.bl109; end
  def o89; @o89 ||= sheet62.bl109; end
  def p89; @p89 ||= sheet63.bl109; end
  def q89; @q89 ||= sheet64.bl109; end
  def d91; "Net balance (should be zero!)"; end
  def f91; 6.261657858885883e-14; end
  def h91; @h91 ||= h74+h82+h89; end
  def i91; @i91 ||= i74+i82+i89; end
  def j91; @j91 ||= j74+j82+j89; end
  def k91; @k91 ||= k74+k82+k89; end
  def l91; @l91 ||= l74+l82+l89; end
  def m91; @m91 ||= m74+m82+m89; end
  def n91; @n91 ||= n74+n82+n89; end
  def o91; @o91 ||= o74+o82+o89; end
  def p91; @p91 ||= p74+p82+p89; end
  def q91; @q91 ||= q74+q82+q89; end
  def b93; "Electricity Generation"; end
  def c95; "V.02"; end
  def h95; 2007.0; end
  def i95; 2010.0; end
  def j95; 2015.0; end
  def k95; 2020.0; end
  def l95; 2025.0; end
  def m95; 2030.0; end
  def n95; 2035.0; end
  def o95; 2040.0; end
  def p95; 2045.0; end
  def q95; 2050.0; end
  def c96; "I.a"; end
  def d96; "Biomass/Coal power"; end
  def f96; 276.53401618322465; end
  def h96; @h96 ||= sheet55.t81; end
  def i96; @i96 ||= sheet56.t81; end
  def j96; @j96 ||= sheet57.t81; end
  def k96; @k96 ||= sheet58.t81; end
  def l96; @l96 ||= sheet59.t81; end
  def m96; @m96 ||= sheet60.t81; end
  def n96; @n96 ||= sheet61.t81; end
  def o96; @o96 ||= sheet62.t81; end
  def p96; @p96 ||= sheet63.t81; end
  def q96; @q96 ||= sheet64.t81; end
  def c97; "IX.a"; end
  def d97; "Domestic space heating and hot water"; end
  def f97; 0.0; end
  def h97; @h97 ||= sheet55.t9; end
  def i97; @i97 ||= sheet56.t9; end
  def j97; @j97 ||= sheet57.t9; end
  def k97; @k97 ||= sheet58.t9; end
  def l97; @l97 ||= sheet59.t9; end
  def m97; @m97 ||= sheet60.t9; end
  def n97; @n97 ||= sheet61.t9; end
  def o97; @o97 ||= sheet62.t9; end
  def p97; @p97 ||= sheet63.t9; end
  def q97; @q97 ||= sheet64.t9; end
  def c98; "IX.c"; end
  def d98; "Commercial heating and cooling"; end
  def f98; 0.0; end
  def h98; @h98 ||= sheet55.t12; end
  def i98; @i98 ||= sheet56.t12; end
  def j98; @j98 ||= sheet57.t12; end
  def k98; @k98 ||= sheet58.t12; end
  def l98; @l98 ||= sheet59.t12; end
  def m98; @m98 ||= sheet60.t12; end
  def n98; @n98 ||= sheet61.t12; end
  def o98; @o98 ||= sheet62.t12; end
  def p98; @p98 ||= sheet63.t12; end
  def q98; @q98 ||= sheet64.t12; end
  def d99; "Unabated thermal generation"; end
  def f99; 276.53401618322465; end
  def g99; 0.0; end
  def h99; @h99 ||= h96+h97+h98; end
  def i99; @i99 ||= i96+i97+i98; end
  def j99; @j99 ||= j96+j97+j98; end
  def k99; @k99 ||= k96+k97+k98; end
  def l99; @l99 ||= l96+l97+l98; end
  def m99; @m99 ||= m96+m97+m98; end
  def n99; @n99 ||= n96+n97+n98; end
  def o99; @o99 ||= o96+o97+o98; end
  def p99; @p99 ||= p96+p97+p98; end
  def q99; @q99 ||= q96+q97+q98; end
  def c100; "I.b"; end
  def d100; "Carbon Capture Storage (CCS)"; end
  def f100; 0.0; end
  def h100; @h100 ||= sheet55.t79; end
  def i100; @i100 ||= sheet56.t79; end
  def j100; @j100 ||= sheet57.t79; end
  def k100; @k100 ||= sheet58.t79; end
  def l100; @l100 ||= sheet59.t79; end
  def m100; @m100 ||= sheet60.t79; end
  def n100; @n100 ||= sheet61.t79; end
  def o100; @o100 ||= sheet62.t79; end
  def p100; @p100 ||= sheet63.t79; end
  def q100; @q100 ||= sheet64.t79; end
  def c101; "II.a"; end
  def d101; "Nuclear power"; end
  def f101; 57.248895000000005; end
  def h101; @h101 ||= sheet55.t75; end
  def i101; @i101 ||= sheet56.t75; end
  def j101; @j101 ||= sheet57.t75; end
  def k101; @k101 ||= sheet58.t75; end
  def l101; @l101 ||= sheet59.t75; end
  def m101; @m101 ||= sheet60.t75; end
  def n101; @n101 ||= sheet61.t75; end
  def o101; @o101 ||= sheet62.t75; end
  def p101; @p101 ||= sheet63.t75; end
  def q101; @q101 ||= sheet64.t75; end
  def c102; "III.a.1"; end
  def d102; "Onshore wind"; end
  def f102; 4.4912823; end
  def h102; @h102 ||= sheet55.t57; end
  def i102; @i102 ||= sheet56.t57; end
  def j102; @j102 ||= sheet57.t57; end
  def k102; @k102 ||= sheet58.t57; end
  def l102; @l102 ||= sheet59.t57; end
  def m102; @m102 ||= sheet60.t57; end
  def n102; @n102 ||= sheet61.t57; end
  def o102; @o102 ||= sheet62.t57; end
  def p102; @p102 ||= sheet63.t57; end
  def q102; @q102 ||= sheet64.t57; end
  def c103; "III.a.2"; end
  def d103; "Offshore wind"; end
  def f103; 0.7825523999999999; end
  def h103; @h103 ||= sheet55.t58; end
  def i103; @i103 ||= sheet56.t58; end
  def j103; @j103 ||= sheet57.t58; end
  def k103; @k103 ||= sheet58.t58; end
  def l103; @l103 ||= sheet59.t58; end
  def m103; @m103 ||= sheet60.t58; end
  def n103; @n103 ||= sheet61.t58; end
  def o103; @o103 ||= sheet62.t58; end
  def p103; @p103 ||= sheet63.t58; end
  def q103; @q103 ||= sheet64.t58; end
  def c104; "III.b"; end
  def d104; "Hydroelectric"; end
  def f104; 4.1137551000000006; end
  def h104; @h104 ||= sheet55.t59; end
  def i104; @i104 ||= sheet56.t59; end
  def j104; @j104 ||= sheet57.t59; end
  def k104; @k104 ||= sheet58.t59; end
  def l104; @l104 ||= sheet59.t59; end
  def m104; @m104 ||= sheet60.t59; end
  def n104; @n104 ||= sheet61.t59; end
  def o104; @o104 ||= sheet62.t59; end
  def p104; @p104 ||= sheet63.t59; end
  def q104; @q104 ||= sheet64.t59; end
  def c105; "III.c"; end
  def d105; "Wave and Tidal"; end
  def f105; 0.0; end
  def h105; @h105 ||= sheet55.t60; end
  def i105; @i105 ||= sheet56.t60; end
  def j105; @j105 ||= sheet57.t60; end
  def k105; @k105 ||= sheet58.t60; end
  def l105; @l105 ||= sheet59.t60; end
  def m105; @m105 ||= sheet60.t60; end
  def n105; @n105 ||= sheet61.t60; end
  def o105; @o105 ||= sheet62.t60; end
  def p105; @p105 ||= sheet63.t60; end
  def q105; @q105 ||= sheet64.t60; end
  def c106; "III.d"; end
  def d106; "Geothermal"; end
  def f106; 0.0; end
  def h106; @h106 ||= sheet55.t61; end
  def i106; @i106 ||= sheet56.t61; end
  def j106; @j106 ||= sheet57.t61; end
  def k106; @k106 ||= sheet58.t61; end
  def l106; @l106 ||= sheet59.t61; end
  def m106; @m106 ||= sheet60.t61; end
  def n106; @n106 ||= sheet61.t61; end
  def o106; @o106 ||= sheet62.t61; end
  def p106; @p106 ||= sheet63.t61; end
  def q106; @q106 ||= sheet64.t61; end
  def c107; "III.e"; end
  def d107; "Tidal [UNUSED - See III.c]"; end
  def f107; 0.0; end
  def h107; @h107 ||= sheet55.t62; end
  def i107; @i107 ||= sheet56.t62; end
  def j107; @j107 ||= sheet57.t62; end
  def k107; @k107 ||= sheet58.t62; end
  def l107; @l107 ||= sheet59.t62; end
  def m107; @m107 ||= sheet60.t62; end
  def n107; @n107 ||= sheet61.t62; end
  def o107; @o107 ||= sheet62.t62; end
  def p107; @p107 ||= sheet63.t62; end
  def q107; @q107 ||= sheet64.t62; end
  def c108; "IV.a"; end
  def d108; "Distributed solar PV"; end
  def f108; 0.0; end
  def h108; @h108 ||= sheet55.t65; end
  def i108; @i108 ||= sheet56.t65; end
  def j108; @j108 ||= sheet57.t65; end
  def k108; @k108 ||= sheet58.t65; end
  def l108; @l108 ||= sheet59.t65; end
  def m108; @m108 ||= sheet60.t65; end
  def n108; @n108 ||= sheet61.t65; end
  def o108; @o108 ||= sheet62.t65; end
  def p108; @p108 ||= sheet63.t65; end
  def q108; @q108 ||= sheet64.t65; end
  def d109; "Non-thermal renewable generation"; end
  def f109; 9.3875898; end
  def h109; @h109 ||= sum(a('h102','h108')); end
  def i109; @i109 ||= sum(a('i102','i108')); end
  def j109; @j109 ||= sum(a('j102','j108')); end
  def k109; @k109 ||= sum(a('k102','k108')); end
  def l109; @l109 ||= sum(a('l102','l108')); end
  def m109; @m109 ||= sum(a('m102','m108')); end
  def n109; @n109 ||= sum(a('n102','n108')); end
  def o109; @o109 ||= sum(a('o102','o108')); end
  def p109; @p109 ||= sum(a('p102','p108')); end
  def q109; @q109 ||= sum(a('q102','q108')); end
  def c110; "VII.a"; end
  def d110; "Electricity imports / exports"; end
  def f110; 5.21452425; end
  def h110; @h110 ||= sheet55.t89; end
  def i110; @i110 ||= sheet56.t89; end
  def j110; @j110 ||= sheet57.t89; end
  def k110; @k110 ||= sheet58.t89; end
  def l110; @l110 ||= sheet59.t89; end
  def m110; @m110 ||= sheet60.t89; end
  def n110; @n110 ||= sheet61.t89; end
  def o110; @o110 ||= sheet62.t89; end
  def p110; @p110 ||= sheet63.t89; end
  def q110; @q110 ||= sheet64.t89; end
  def d111; "Total generation"; end
  def f111; 348.38502523322467; end
  def h111; @h111 ||= h99+h100+h101+h109+h110; end
  def i111; @i111 ||= i99+i100+i101+i109+i110; end
  def j111; @j111 ||= j99+j100+j101+j109+j110; end
  def k111; @k111 ||= k99+k100+k101+k109+k110; end
  def l111; @l111 ||= l99+l100+l101+l109+l110; end
  def m111; @m111 ||= m99+m100+m101+m109+m110; end
  def n111; @n111 ||= n99+n100+n101+n109+n110; end
  def o111; @o111 ||= o99+o100+o101+o109+o110; end
  def p111; @p111 ||= p99+p100+p101+p109+p110; end
  def q111; @q111 ||= q99+q100+q101+q109+q110; end
  def b115; "Emissions"; end
  def c117; "Emissions as % of base year, adjusted so that 2007 matches actuals"; end
  def d118; "IPCC Sector"; end
  def f118; "2007 Actuals, GHG Inv."; end
  def h118; 2007.0; end
  def i118; 2010.0; end
  def j118; 2015.0; end
  def k118; 2020.0; end
  def l118; 2025.0; end
  def m118; 2030.0; end
  def n118; 2035.0; end
  def o118; 2040.0; end
  def p118; 2045.0; end
  def q118; 2050.0; end
  def c119; "1A"; end
  def d119; "Fuel Combustion"; end
  def c120; "1B"; end
  def d120; "Fugitive Emissions from Fuels"; end
  def c121; 1.0; end
  def d121; "Fuel Combustion"; end
  def f121; 0.6828579138027161; end
  def h121; @h121 ||= h142*h135/f161; end
  def i121; @i121 ||= i142*h135/f161; end
  def j121; @j121 ||= j142*h135/f161; end
  def k121; @k121 ||= k142*h135/f161; end
  def l121; @l121 ||= l142*h135/f161; end
  def m121; @m121 ||= m142*h135/f161; end
  def n121; @n121 ||= n142*h135/f161; end
  def o121; @o121 ||= o142*h135/f161; end
  def p121; @p121 ||= p142*h135/f161; end
  def q121; @q121 ||= q142*h135/f161; end
  def c122; 2.0; end
  def d122; "Industrial Processes"; end
  def f122; 0.034882184192791134; end
  def h122; @h122 ||= h143*h135/f161; end
  def i122; @i122 ||= i143*h135/f161; end
  def j122; @j122 ||= j143*h135/f161; end
  def k122; @k122 ||= k143*h135/f161; end
  def l122; @l122 ||= l143*h135/f161; end
  def m122; @m122 ||= m143*h135/f161; end
  def n122; @n122 ||= n143*h135/f161; end
  def o122; @o122 ||= o143*h135/f161; end
  def p122; @p122 ||= p143*h135/f161; end
  def q122; @q122 ||= q143*h135/f161; end
  def c123; 3.0; end
  def d123; "Solvent and Other Product Use"; end
  def f123; 0.0; end
  def h123; @h123 ||= h144*h135/f161; end
  def i123; @i123 ||= i144*h135/f161; end
  def j123; @j123 ||= j144*h135/f161; end
  def k123; @k123 ||= k144*h135/f161; end
  def l123; @l123 ||= l144*h135/f161; end
  def m123; @m123 ||= m144*h135/f161; end
  def n123; @n123 ||= n144*h135/f161; end
  def o123; @o123 ||= o144*h135/f161; end
  def p123; @p123 ||= p144*h135/f161; end
  def q123; @q123 ||= q144*h135/f161; end
  def c124; 4.0; end
  def d124; "Agriculture"; end
  def f124; 0.05435207327207761; end
  def h124; @h124 ||= h145*h135/f161; end
  def i124; @i124 ||= i145*h135/f161; end
  def j124; @j124 ||= j145*h135/f161; end
  def k124; @k124 ||= k145*h135/f161; end
  def l124; @l124 ||= l145*h135/f161; end
  def m124; @m124 ||= m145*h135/f161; end
  def n124; @n124 ||= n145*h135/f161; end
  def o124; @o124 ||= o145*h135/f161; end
  def p124; @p124 ||= p145*h135/f161; end
  def q124; @q124 ||= q145*h135/f161; end
  def c125; 5.0; end
  def d125; "Land Use, Land-Use Change and Forestry"; end
  def f125; -0.002225951062639978; end
  def h125; @h125 ||= h146*h135/f161; end
  def i125; @i125 ||= i146*h135/f161; end
  def j125; @j125 ||= j146*h135/f161; end
  def k125; @k125 ||= k146*h135/f161; end
  def l125; @l125 ||= l146*h135/f161; end
  def m125; @m125 ||= m146*h135/f161; end
  def n125; @n125 ||= n146*h135/f161; end
  def o125; @o125 ||= o146*h135/f161; end
  def p125; @p125 ||= p146*h135/f161; end
  def q125; @q125 ||= q146*h135/f161; end
  def c126; 6.0; end
  def d126; "Waste"; end
  def f126; 0.028590076266100505; end
  def h126; @h126 ||= h147*h135/f161; end
  def i126; @i126 ||= i147*h135/f161; end
  def j126; @j126 ||= j147*h135/f161; end
  def k126; @k126 ||= k147*h135/f161; end
  def l126; @l126 ||= l147*h135/f161; end
  def m126; @m126 ||= m147*h135/f161; end
  def n126; @n126 ||= n147*h135/f161; end
  def o126; @o126 ||= o147*h135/f161; end
  def p126; @p126 ||= p147*h135/f161; end
  def q126; @q126 ||= q147*h135/f161; end
  def c127; 7.0; end
  def d127; "Other"; end
  def f127; 0.0; end
  def h127; @h127 ||= h148*h135/f161; end
  def i127; @i127 ||= i148*h135/f161; end
  def j127; @j127 ||= j148*h135/f161; end
  def k127; @k127 ||= k148*h135/f161; end
  def l127; @l127 ||= l148*h135/f161; end
  def m127; @m127 ||= m148*h135/f161; end
  def n127; @n127 ||= n148*h135/f161; end
  def o127; @o127 ||= o148*h135/f161; end
  def p127; @p127 ||= p148*h135/f161; end
  def q127; @q127 ||= q148*h135/f161; end
  def c128; "X1"; end
  def d128; "International Aviation and Shipping"; end
  def f128; 0.05318296088087667; end
  def h128; @h128 ||= h149*h135/f161; end
  def i128; @i128 ||= i149*h135/f161; end
  def j128; @j128 ||= j149*h135/f161; end
  def k128; @k128 ||= k149*h135/f161; end
  def l128; @l128 ||= l149*h135/f161; end
  def m128; @m128 ||= m149*h135/f161; end
  def n128; @n128 ||= n149*h135/f161; end
  def o128; @o128 ||= o149*h135/f161; end
  def p128; @p128 ||= p149*h135/f161; end
  def q128; @q128 ||= q149*h135/f161; end
  def c129; "X2"; end
  def d129; "Bioenergy credit"; end
  def h129; @h129 ||= h150*h135/f161; end
  def i129; @i129 ||= i150*h135/f161; end
  def j129; @j129 ||= j150*h135/f161; end
  def k129; @k129 ||= k150*h135/f161; end
  def l129; @l129 ||= l150*h135/f161; end
  def m129; @m129 ||= m150*h135/f161; end
  def n129; @n129 ||= n150*h135/f161; end
  def o129; @o129 ||= o150*h135/f161; end
  def p129; @p129 ||= p150*h135/f161; end
  def q129; @q129 ||= q150*h135/f161; end
  def c130; "X3"; end
  def d130; "Carbon capture"; end
  def h130; @h130 ||= h151*h135/f161; end
  def i130; @i130 ||= i151*h135/f161; end
  def j130; @j130 ||= j151*h135/f161; end
  def k130; @k130 ||= k151*h135/f161; end
  def l130; @l130 ||= l151*h135/f161; end
  def m130; @m130 ||= m151*h135/f161; end
  def n130; @n130 ||= n151*h135/f161; end
  def o130; @o130 ||= o151*h135/f161; end
  def p130; @p130 ||= p151*h135/f161; end
  def q130; @q130 ||= q151*h135/f161; end
  def d131; "Total"; end
  def f131; 0.851639257351922; end
  def h131; @h131 ||= sum(a('h121','h130')); end
  def i131; @i131 ||= sum(a('i121','i130')); end
  def j131; @j131 ||= sum(a('j121','j130')); end
  def k131; @k131 ||= sum(a('k121','k130')); end
  def l131; @l131 ||= sum(a('l121','l130')); end
  def m131; @m131 ||= sum(a('m121','m130')); end
  def n131; @n131 ||= sum(a('n121','n130')); end
  def o131; @o131 ||= sum(a('o121','o130')); end
  def p131; @p131 ||= sum(a('p121','p130')); end
  def q131; @q131 ||= sum(a('q121','q130')); end
  def c133; "Excluding international bunkers"; end
  def f133; 0.8215417518529308; end
  def h133; @h133 ||= (h154/f159)*h135; end
  def i133; @i133 ||= (i154/f159)*h135; end
  def j133; @j133 ||= (j154/f159)*h135; end
  def k133; @k133 ||= (k154/f159)*h135; end
  def l133; @l133 ||= (l154/f159)*h135; end
  def m133; @m133 ||= (m154/f159)*h135; end
  def n133; @n133 ||= (n154/f159)*h135; end
  def o133; @o133 ||= (o154/f159)*h135; end
  def p133; @p133 ||= (p154/f159)*h135; end
  def q133; @q133 ||= (q154/f159)*h135; end
  def e135; "Adjustment factor:"; end
  def h135; @h135 ||= f152/h152; end
  def p135; "% reduction 1990-2050"; end
  def q135; @q135 ||= 1.0-q131; end
  def c137; "Modelled emissions"; end
  def d139; "IPCC Sector"; end
  def f139; "Actuals, GHG Inv."; end
  def q139; "Mt CO2e"; end
  def c140; "1A"; end
  def d140; "Fuel Combustion"; end
  def f140; 532.6387375112939; end
  def h140; @h140 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c140); end
  def i140; @i140 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c140); end
  def j140; @j140 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c140); end
  def k140; @k140 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c140); end
  def l140; @l140 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c140); end
  def m140; @m140 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c140); end
  def n140; @n140 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c140); end
  def o140; @o140 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c140); end
  def p140; @p140 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c140); end
  def q140; @q140 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c140); end
  def c141; "1B"; end
  def d141; "Fugitive Emissions from Fuels"; end
  def f141; 13.3650064404099; end
  def h141; @h141 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c141); end
  def i141; @i141 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c141); end
  def j141; @j141 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c141); end
  def k141; @k141 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c141); end
  def l141; @l141 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c141); end
  def m141; @m141 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c141); end
  def n141; @n141 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c141); end
  def o141; @o141 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c141); end
  def p141; @p141 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c141); end
  def q141; @q141 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c141); end
  def c142; 1.0; end
  def d142; "Fuel Combustion"; end
  def f142; 546.0037439517039; end
  def h142; @h142 ||= h140+h141; end
  def i142; @i142 ||= i140+i141; end
  def j142; @j142 ||= j140+j141; end
  def k142; @k142 ||= k140+k141; end
  def l142; @l142 ||= l140+l141; end
  def m142; @m142 ||= m140+m141; end
  def n142; @n142 ||= n140+n141; end
  def o142; @o142 ||= o140+o141; end
  def p142; @p142 ||= p140+p141; end
  def q142; @q142 ||= q140+q141; end
  def c143; 2.0; end
  def d143; "Industrial Processes"; end
  def f143; 27.8913120599484; end
  def h143; @h143 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c143); end
  def i143; @i143 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c143); end
  def j143; @j143 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c143); end
  def k143; @k143 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c143); end
  def l143; @l143 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c143); end
  def m143; @m143 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c143); end
  def n143; @n143 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c143); end
  def o143; @o143 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c143); end
  def p143; @p143 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c143); end
  def q143; @q143 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c143); end
  def c144; 3.0; end
  def d144; "Solvent and Other Product Use"; end
  def f144; 0.0; end
  def h144; @h144 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c144); end
  def i144; @i144 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c144); end
  def j144; @j144 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c144); end
  def k144; @k144 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c144); end
  def l144; @l144 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c144); end
  def m144; @m144 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c144); end
  def n144; @n144 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c144); end
  def o144; @o144 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c144); end
  def p144; @p144 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c144); end
  def q144; @q144 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c144); end
  def c145; 4.0; end
  def d145; "Agriculture"; end
  def f145; 43.4591660991799; end
  def h145; @h145 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c145); end
  def i145; @i145 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c145); end
  def j145; @j145 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c145); end
  def k145; @k145 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c145); end
  def l145; @l145 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c145); end
  def m145; @m145 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c145); end
  def n145; @n145 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c145); end
  def o145; @o145 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c145); end
  def p145; @p145 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c145); end
  def q145; @q145 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c145); end
  def c146; 5.0; end
  def d146; "Land Use, Land-Use Change and Forestry"; end
  def f146; -1.7798396847837301; end
  def h146; @h146 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c146); end
  def i146; @i146 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c146); end
  def j146; @j146 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c146); end
  def k146; @k146 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c146); end
  def l146; @l146 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c146); end
  def m146; @m146 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c146); end
  def n146; @n146 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c146); end
  def o146; @o146 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c146); end
  def p146; @p146 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c146); end
  def q146; @q146 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c146); end
  def c147; 6.0; end
  def d147; "Waste"; end
  def f147; 22.8602295816192; end
  def h147; @h147 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c147); end
  def i147; @i147 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c147); end
  def j147; @j147 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c147); end
  def k147; @k147 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c147); end
  def l147; @l147 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c147); end
  def m147; @m147 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c147); end
  def n147; @n147 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c147); end
  def o147; @o147 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c147); end
  def p147; @p147 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c147); end
  def q147; @q147 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c147); end
  def c148; 7.0; end
  def d148; "Other"; end
  def h148; @h148 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c148); end
  def i148; @i148 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c148); end
  def j148; @j148 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c148); end
  def k148; @k148 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c148); end
  def l148; @l148 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c148); end
  def m148; @m148 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c148); end
  def n148; @n148 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c148); end
  def o148; @o148 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c148); end
  def p148; @p148 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c148); end
  def q148; @q148 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c148); end
  def c149; "X1"; end
  def d149; "International Aviation and Shipping"; end
  def f149; 42.52436; end
  def h149; @h149 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c149); end
  def i149; @i149 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c149); end
  def j149; @j149 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c149); end
  def k149; @k149 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c149); end
  def l149; @l149 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c149); end
  def m149; @m149 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c149); end
  def n149; @n149 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c149); end
  def o149; @o149 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c149); end
  def p149; @p149 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c149); end
  def q149; @q149 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c149); end
  def c150; "X2"; end
  def d150; "Bioenergy credit"; end
  def h150; @h150 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c150); end
  def i150; @i150 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c150); end
  def j150; @j150 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c150); end
  def k150; @k150 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c150); end
  def l150; @l150 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c150); end
  def m150; @m150 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c150); end
  def n150; @n150 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c150); end
  def o150; @o150 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c150); end
  def p150; @p150 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c150); end
  def q150; @q150 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c150); end
  def c151; "X3"; end
  def d151; "Carbon capture"; end
  def h151; @h151 ||= sumifs(sheet55.a('bo109','df109'),sheet55.a('bo5','df5'),c151); end
  def i151; @i151 ||= sumifs(sheet56.a('bo109','df109'),sheet56.a('bo5','df5'),c151); end
  def j151; @j151 ||= sumifs(sheet57.a('bo109','df109'),sheet57.a('bo5','df5'),c151); end
  def k151; @k151 ||= sumifs(sheet58.a('bo109','df109'),sheet58.a('bo5','df5'),c151); end
  def l151; @l151 ||= sumifs(sheet59.a('bo109','df109'),sheet59.a('bo5','df5'),c151); end
  def m151; @m151 ||= sumifs(sheet60.a('bo109','df109'),sheet60.a('bo5','df5'),c151); end
  def n151; @n151 ||= sumifs(sheet61.a('bo109','df109'),sheet61.a('bo5','df5'),c151); end
  def o151; @o151 ||= sumifs(sheet62.a('bo109','df109'),sheet62.a('bo5','df5'),c151); end
  def p151; @p151 ||= sumifs(sheet63.a('bo109','df109'),sheet63.a('bo5','df5'),c151); end
  def q151; @q151 ||= sumifs(sheet64.a('bo109','df109'),sheet64.a('bo5','df5'),c151); end
  def f152; 680.9589720076677; end
  def h152; @h152 ||= sum(a('h142','h151')); end
  def i152; @i152 ||= sum(a('i142','i151')); end
  def j152; @j152 ||= sum(a('j142','j151')); end
  def k152; @k152 ||= sum(a('k142','k151')); end
  def l152; @l152 ||= sum(a('l142','l151')); end
  def m152; @m152 ||= sum(a('m142','m151')); end
  def n152; @n152 ||= sum(a('n142','n151')); end
  def o152; @o152 ||= sum(a('o142','o151')); end
  def p152; @p152 ||= sum(a('p142','p151')); end
  def q152; @q152 ||= sum(a('q142','q151')); end
  def c154; "Excluding international bunkers"; end
  def f154; 638.4346120076677; end
  def h154; @h154 ||= h152-h149; end
  def i154; @i154 ||= i152-i149; end
  def j154; @j154 ||= j152-j149; end
  def k154; @k154 ||= k152-k149; end
  def l154; @l154 ||= l152-l149; end
  def m154; @m154 ||= m152-m149; end
  def n154; @n154 ||= n152-n149; end
  def o154; @o154 ||= o152-o149; end
  def p154; @p154 ||= p152-p149; end
  def q154; @q154 ||= q152-q149; end
  def c157; "Targets"; end
  def h157; "2050 target"; end
  def i157; "2020 target "; end
  def k157; "2050 target"; end
  def l157; "2020 target"; end
  def n157; "Actuals, as % of 2007, modelled"; end
  def f158; "Base year (1990)"; end
  def h158; "(20% of base)"; end
  def i158; "(66% of base)"; end
  def k158; "% of 2007"; end
  def l158; "% of 2007"; end
  def o158; 2020.0; end
  def p158; 2030.0; end
  def q158; 2050.0; end
  def d159; "Kyoto agreed sectors"; end
  def f159; 777.11767; end
  def h159; 155.42353400000002; end
  def i159; 512.8976622; end
  def d160; "International bunkers (CO2 only)"; end
  def f160; 22.4685; end
  def k160; @k160 ||= k161*h131; end
  def l160; @l160 ||= l161*h131; end
  def d161; "Total"; end
  def f161; 799.5861699999999; end
  def h161; 159.917234; end
  def i161; 527.7268722; end
  def k161; 187.77578959575553; end
  def l161; 619.6601056659932; end
  def o161; @o161 ||= k131/h131; end
  def p161; @p161 ||= m131/h131; end
  def q161; @q161 ||= q131/h131; end
  def d162; "Target, for chart"; end
  def h162; 0.2; end
  def i162; 0.2; end
  def j162; 0.2; end
  def k162; 0.2; end
  def l162; 0.2; end
  def m162; 0.2; end
  def n162; 0.2; end
  def o162; 0.2; end
  def p162; 0.2; end
  def q162; 0.2; end
  def d163; "Dummy, for chart"; end
  def h163; 0.0; end
  def i163; 0.0; end
  def j163; 0.0; end
  def k163; 0.0; end
  def l163; 0.0; end
  def m163; 0.0; end
  def n163; 0.0; end
  def o163; 0.0; end
  def p163; 0.0; end
  def q163; 0.0; end
  def b166; "Primary supply, format for web-based interface"; end
  def c168; "N.01"; end
  def d168; "Nuclear fission"; end
  def e168; 0.0; end
  def f168; 163.24447683045062; end
  def g168; 0.0; end
  def h168; @h168 ||= h23; end
  def i168; @i168 ||= i23; end
  def j168; @j168 ||= j23; end
  def k168; @k168 ||= k23; end
  def l168; @l168 ||= l23; end
  def m168; @m168 ||= m23; end
  def n168; @n168 ||= n23; end
  def o168; @o168 ||= o23; end
  def p168; @p168 ||= p23; end
  def q168; @q168 ||= q23; end
  def c169; "R.01"; end
  def d169; "Solar"; end
  def e169; 0.0; end
  def f169; 0.5360591477000001; end
  def g169; 0.0; end
  def h169; @h169 ||= h24; end
  def i169; @i169 ||= i24; end
  def j169; @j169 ||= j24; end
  def k169; @k169 ||= k24; end
  def l169; @l169 ||= l24; end
  def m169; @m169 ||= m24; end
  def n169; @n169 ||= n24; end
  def o169; @o169 ||= o24; end
  def p169; @p169 ||= p24; end
  def q169; @q169 ||= q24; end
  def c170; "R.02"; end
  def d170; "Wind"; end
  def e170; 0.0; end
  def f170; 6.978861884782586; end
  def g170; 0.0; end
  def h170; @h170 ||= h25; end
  def i170; @i170 ||= i25; end
  def j170; @j170 ||= j25; end
  def k170; @k170 ||= k25; end
  def l170; @l170 ||= l25; end
  def m170; @m170 ||= m25; end
  def n170; @n170 ||= n25; end
  def o170; @o170 ||= o25; end
  def p170; @p170 ||= p25; end
  def q170; @q170 ||= q25; end
  def c171; "R.03"; end
  def d171; "Tidal"; end
  def e171; 0.0; end
  def f171; 0.0; end
  def g171; 0.0; end
  def h171; @h171 ||= h26; end
  def i171; @i171 ||= i26; end
  def j171; @j171 ||= j26; end
  def k171; @k171 ||= k26; end
  def l171; @l171 ||= l26; end
  def m171; @m171 ||= m26; end
  def n171; @n171 ||= n26; end
  def o171; @o171 ||= o26; end
  def p171; @p171 ||= p26; end
  def q171; @q171 ||= q26; end
  def c172; "R.04"; end
  def d172; "Wave"; end
  def e172; 0.0; end
  def f172; 0.0; end
  def g172; 0.0; end
  def h172; @h172 ||= h27; end
  def i172; @i172 ||= i27; end
  def j172; @j172 ||= j27; end
  def k172; @k172 ||= k27; end
  def l172; @l172 ||= l27; end
  def m172; @m172 ||= m27; end
  def n172; @n172 ||= n27; end
  def o172; @o172 ||= o27; end
  def p172; @p172 ||= p27; end
  def q172; @q172 ||= q27; end
  def c173; "R.05"; end
  def d173; "Geothermal"; end
  def e173; 0.0; end
  def f173; 0.0; end
  def g173; 0.0; end
  def h173; @h173 ||= h28; end
  def i173; @i173 ||= i28; end
  def j173; @j173 ||= j28; end
  def k173; @k173 ||= k28; end
  def l173; @l173 ||= l28; end
  def m173; @m173 ||= m28; end
  def n173; @n173 ||= n28; end
  def o173; @o173 ||= o28; end
  def p173; @p173 ||= p28; end
  def q173; @q173 ||= q28; end
  def c174; "R.06"; end
  def d174; "Hydro"; end
  def e174; 0.0; end
  def f174; 5.088394340000001; end
  def g174; 0.0; end
  def h174; @h174 ||= h29; end
  def i174; @i174 ||= i29; end
  def j174; @j174 ||= j29; end
  def k174; @k174 ||= k29; end
  def l174; @l174 ||= l29; end
  def m174; @m174 ||= m29; end
  def n174; @n174 ||= n29; end
  def o174; @o174 ||= o29; end
  def p174; @p174 ||= p29; end
  def q174; @q174 ||= q29; end
  def c175; "Y.02"; end
  def d175; "Electricity oversupply (imports)"; end
  def e175; 0.0; end
  def f175; 5.21452425; end
  def g175; 0.0; end
  def h175; @h175 ||= max(h30,0.0); end
  def i175; @i175 ||= max(i30,0.0); end
  def j175; @j175 ||= max(j30,0.0); end
  def k175; @k175 ||= max(k30,0.0); end
  def l175; @l175 ||= max(l30,0.0); end
  def m175; @m175 ||= max(m30,0.0); end
  def n175; @n175 ||= max(n30,0.0); end
  def o175; @o175 ||= max(o30,0.0); end
  def p175; @p175 ||= max(p30,0.0); end
  def q175; @q175 ||= max(q30,0.0); end
  def c176; "R.07"; end
  def d176; "Environmental heat"; end
  def e176; 0.0; end
  def f176; 0.0; end
  def g176; 0.0; end
  def h176; @h176 ||= h32; end
  def i176; @i176 ||= i32; end
  def j176; @j176 ||= j32; end
  def k176; @k176 ||= k32; end
  def l176; @l176 ||= l32; end
  def m176; @m176 ||= m32; end
  def n176; @n176 ||= n32; end
  def o176; @o176 ||= o32; end
  def p176; @p176 ||= p32; end
  def q176; @q176 ||= q32; end
  def d177; "Bioenergy"; end
  def e177; 0.0; end
  def f177; 98.50879965682326; end
  def g177; 0.0; end
  def h177; @h177 ||= h36; end
  def i177; @i177 ||= i36; end
  def j177; @j177 ||= j36; end
  def k177; @k177 ||= k36; end
  def l177; @l177 ||= l36; end
  def m177; @m177 ||= m36; end
  def n177; @n177 ||= n36; end
  def o177; @o177 ||= o36; end
  def p177; @p177 ||= p36; end
  def q177; @q177 ||= q36; end
  def d178; "Coal"; end
  def e178; 0.0; end
  def f178; 475.4021773117744; end
  def g178; 0.0; end
  def h178; @h178 ||= max(h39,0.0); end
  def i178; @i178 ||= max(i39,0.0); end
  def j178; @j178 ||= max(j39,0.0); end
  def k178; @k178 ||= max(k39,0.0); end
  def l178; @l178 ||= max(l39,0.0); end
  def m178; @m178 ||= max(m39,0.0); end
  def n178; @n178 ||= max(n39,0.0); end
  def o178; @o178 ||= max(o39,0.0); end
  def p178; @p178 ||= max(p39,0.0); end
  def q178; @q178 ||= max(q39,0.0); end
  def d179; "Oil"; end
  def e179; 0.0; end
  def f179; 906.622998738918; end
  def g179; 0.0; end
  def h179; @h179 ||= h43; end
  def i179; @i179 ||= i43; end
  def j179; @j179 ||= j43; end
  def k179; @k179 ||= k43; end
  def l179; @l179 ||= l43; end
  def m179; @m179 ||= m43; end
  def n179; @n179 ||= n43; end
  def o179; @o179 ||= o43; end
  def p179; @p179 ||= p43; end
  def q179; @q179 ||= q43; end
  def d180; "Natural gas"; end
  def e180; 0.0; end
  def f180; 1048.9298032969484; end
  def g180; 0.0; end
  def h180; @h180 ||= h46; end
  def i180; @i180 ||= i46; end
  def j180; @j180 ||= j46; end
  def k180; @k180 ||= k46; end
  def l180; @l180 ||= l46; end
  def m180; @m180 ||= m46; end
  def n180; @n180 ||= n46; end
  def o180; @o180 ||= o46; end
  def p180; @p180 ||= p46; end
  def q180; @q180 ||= q46; end
  def d181; "Total Primary Supply"; end
  def e181; 0.0; end
  def f181; 2710.526095457397; end
  def g181; 0.0; end
  def h181; @h181 ||= sum(a('h168','h180')); end
  def i181; @i181 ||= sum(a('i168','i180')); end
  def j181; @j181 ||= sum(a('j168','j180')); end
  def k181; @k181 ||= sum(a('k168','k180')); end
  def l181; @l181 ||= sum(a('l168','l180')); end
  def m181; @m181 ||= sum(a('m168','m180')); end
  def n181; @n181 ||= sum(a('n168','n180')); end
  def o181; @o181 ||= sum(a('o168','o180')); end
  def p181; @p181 ||= sum(a('p168','p180')); end
  def q181; @q181 ||= sum(a('q168','q180')); end
  def d182; "Imported energy"; end
  def f182; 818.936866535737; end
  def g182; 0.0; end
  def h182; @h182 ||= max(0.0,h30)+max(0.0,h35)+max(0.0,h37)+max(0.0,h41)+max(0.0,h44)+h23; end
  def i182; @i182 ||= max(0.0,i30)+max(0.0,i35)+max(0.0,i37)+max(0.0,i41)+max(0.0,i44)+i23; end
  def j182; @j182 ||= max(0.0,j30)+max(0.0,j35)+max(0.0,j37)+max(0.0,j41)+max(0.0,j44)+j23; end
  def k182; @k182 ||= max(0.0,k30)+max(0.0,k35)+max(0.0,k37)+max(0.0,k41)+max(0.0,k44)+k23; end
  def l182; @l182 ||= max(0.0,l30)+max(0.0,l35)+max(0.0,l37)+max(0.0,l41)+max(0.0,l44)+l23; end
  def m182; @m182 ||= max(0.0,m30)+max(0.0,m35)+max(0.0,m37)+max(0.0,m41)+max(0.0,m44)+m23; end
  def n182; @n182 ||= max(0.0,n30)+max(0.0,n35)+max(0.0,n37)+max(0.0,n41)+max(0.0,n44)+n23; end
  def o182; @o182 ||= max(0.0,o30)+max(0.0,o35)+max(0.0,o37)+max(0.0,o41)+max(0.0,o44)+o23; end
  def p182; @p182 ||= max(0.0,p30)+max(0.0,p35)+max(0.0,p37)+max(0.0,p41)+max(0.0,p44)+p23; end
  def q182; @q182 ||= max(0.0,q30)+max(0.0,q35)+max(0.0,q37)+max(0.0,q41)+max(0.0,q44)+q23; end
  def p183; "% imported"; end
  def q183; @q183 ||= q182/q181; end
  def d184; "Primary demand"; end
  def f184; 2707.9903243745525; end
  def g184; 0.0; end
  def h184; @h184 ||= h18+h52+h53; end
  def i184; @i184 ||= i18+i52+i53; end
  def j184; @j184 ||= j18+j52+j53; end
  def k184; @k184 ||= k18+k52+k53; end
  def l184; @l184 ||= l18+l52+l53; end
  def m184; @m184 ||= m18+m52+m53; end
  def n184; @n184 ||= n18+n52+n53; end
  def o184; @o184 ||= o18+o52+o53; end
  def p184; @p184 ||= p18+p52+p53; end
  def q184; @q184 ||= q18+q52+q53; end
  def b187; "Electricity, format for web-based interface"; end
  def c189; "V.01"; end
  def d189; "Electricity (delivered to end user)"; end
  def h189; 2007.0; end
  def i189; 2010.0; end
  def j189; 2015.0; end
  def k189; 2020.0; end
  def l189; 2025.0; end
  def m189; 2030.0; end
  def n189; 2035.0; end
  def o189; 2040.0; end
  def p189; 2045.0; end
  def q189; 2050.0; end
  def r189; "TWh"; end
  def c191; "VIII.a"; end
  def d191; "H2 Production for Transport"; end
  def h191; @h191 ||= -sheet37.f62; end
  def i191; @i191 ||= -sheet37.g62; end
  def j191; @j191 ||= -sheet37.h62; end
  def k191; @k191 ||= -sheet37.i62; end
  def l191; @l191 ||= -sheet37.j62; end
  def m191; @m191 ||= -sheet37.k62; end
  def n191; @n191 ||= -sheet37.l62; end
  def o191; @o191 ||= -sheet37.m62; end
  def p191; @p191 ||= -sheet37.n62; end
  def q191; @q191 ||= -sheet37.o62; end
  def c192; "VI.a"; end
  def d192; "Agriculture and land use"; end
  def h192; @h192 ||= -sheet30.f390; end
  def i192; @i192 ||= -sheet30.g390; end
  def j192; @j192 ||= -sheet30.h390; end
  def k192; @k192 ||= -sheet30.i390; end
  def l192; @l192 ||= -sheet30.j390; end
  def m192; @m192 ||= -sheet30.k390; end
  def n192; @n192 ||= -sheet30.l390; end
  def o192; @o192 ||= -sheet30.m390; end
  def p192; @p192 ||= -sheet30.n390; end
  def q192; @q192 ||= -sheet30.o390; end
  def c193; "IV.b"; end
  def d193; "Distributed solar thermal"; end
  def h193; @h193 ||= -sheet26.f66; end
  def i193; @i193 ||= -sheet26.g66; end
  def j193; @j193 ||= -sheet26.h66; end
  def k193; @k193 ||= -sheet26.i66; end
  def l193; @l193 ||= -sheet26.j66; end
  def m193; @m193 ||= -sheet26.k66; end
  def n193; @n193 ||= -sheet26.l66; end
  def o193; @o193 ||= -sheet26.m66; end
  def p193; @p193 ||= -sheet26.n66; end
  def q193; @q193 ||= -sheet26.o66; end
  def c194; "IX.a"; end
  def d194; "Domestic space heating and hot water"; end
  def h194; @h194 ||= -sheet38.f688; end
  def i194; @i194 ||= -sheet38.g688; end
  def j194; @j194 ||= -sheet38.h688; end
  def k194; @k194 ||= -sheet38.i688; end
  def l194; @l194 ||= -sheet38.j688; end
  def m194; @m194 ||= -sheet38.k688; end
  def n194; @n194 ||= -sheet38.l688; end
  def o194; @o194 ||= -sheet38.m688; end
  def p194; @p194 ||= -sheet38.n688; end
  def q194; @q194 ||= -sheet38.o688; end
  def c195; "IX.c"; end
  def d195; "Commercial heating and cooling"; end
  def h195; @h195 ||= -sheet39.f391; end
  def i195; @i195 ||= -sheet39.g391; end
  def j195; @j195 ||= -sheet39.h391; end
  def k195; @k195 ||= -sheet39.i391; end
  def l195; @l195 ||= -sheet39.j391; end
  def m195; @m195 ||= -sheet39.k391; end
  def n195; @n195 ||= -sheet39.l391; end
  def o195; @o195 ||= -sheet39.m391; end
  def p195; @p195 ||= -sheet39.n391; end
  def q195; @q195 ||= -sheet39.o391; end
  def c196; "X.a"; end
  def d196; "Domestic lighting, appliances, and cooking"; end
  def h196; @h196 ||= -sheet40.f100; end
  def i196; @i196 ||= -sheet40.g100; end
  def j196; @j196 ||= -sheet40.h100; end
  def k196; @k196 ||= -sheet40.i100; end
  def l196; @l196 ||= -sheet40.j100; end
  def m196; @m196 ||= -sheet40.k100; end
  def n196; @n196 ||= -sheet40.l100; end
  def o196; @o196 ||= -sheet40.m100; end
  def p196; @p196 ||= -sheet40.n100; end
  def q196; @q196 ||= -sheet40.o100; end
  def c197; "X.b"; end
  def d197; "Commercial lighting, appliances, and catering"; end
  def h197; @h197 ||= -sheet41.f91; end
  def i197; @i197 ||= -sheet41.g91; end
  def j197; @j197 ||= -sheet41.h91; end
  def k197; @k197 ||= -sheet41.i91; end
  def l197; @l197 ||= -sheet41.j91; end
  def m197; @m197 ||= -sheet41.k91; end
  def n197; @n197 ||= -sheet41.l91; end
  def o197; @o197 ||= -sheet41.m91; end
  def p197; @p197 ||= -sheet41.n91; end
  def q197; @q197 ||= -sheet41.o91; end
  def c198; "XI.a"; end
  def d198; "Industrial processes"; end
  def h198; 114.37233546157294; end
  def i198; @i198 ||= -sheet42.g213; end
  def j198; @j198 ||= -sheet42.h213; end
  def k198; @k198 ||= -sheet42.i213; end
  def l198; @l198 ||= -sheet42.j213; end
  def m198; @m198 ||= -sheet42.k213; end
  def n198; @n198 ||= -sheet42.l213; end
  def o198; @o198 ||= -sheet42.m213; end
  def p198; @p198 ||= -sheet42.n213; end
  def q198; @q198 ||= -sheet42.o213; end
  def c199; "XII.a"; end
  def d199; "Domestic passenger transport"; end
  def h199; @h199 ||= -sheet43.f335; end
  def i199; @i199 ||= -sheet43.g335; end
  def j199; @j199 ||= -sheet43.h335; end
  def k199; @k199 ||= -sheet43.i335; end
  def l199; @l199 ||= -sheet43.j335; end
  def m199; @m199 ||= -sheet43.k335; end
  def n199; @n199 ||= -sheet43.l335; end
  def o199; @o199 ||= -sheet43.m335; end
  def p199; @p199 ||= -sheet43.n335; end
  def q199; @q199 ||= -sheet43.o335; end
  def c200; "XII.b"; end
  def d200; "Domestic freight"; end
  def h200; @h200 ||= -sheet44.f137; end
  def i200; @i200 ||= -sheet44.g137; end
  def j200; @j200 ||= -sheet44.h137; end
  def k200; @k200 ||= -sheet44.i137; end
  def l200; @l200 ||= -sheet44.j137; end
  def m200; @m200 ||= -sheet44.k137; end
  def n200; @n200 ||= -sheet44.l137; end
  def o200; @o200 ||= -sheet44.m137; end
  def p200; @p200 ||= -sheet44.n137; end
  def q200; @q200 ||= -sheet44.o137; end
  def c201; "XIV.a"; end
  def d201; "Geosequestration"; end
  def h201; @h201 ||= -sheet48.f71; end
  def i201; @i201 ||= -sheet48.g71; end
  def j201; @j201 ||= -sheet48.h71; end
  def k201; @k201 ||= -sheet48.i71; end
  def l201; @l201 ||= -sheet48.j71; end
  def m201; @m201 ||= -sheet48.k71; end
  def n201; @n201 ||= -sheet48.l71; end
  def o201; @o201 ||= -sheet48.m71; end
  def p201; @p201 ||= -sheet48.n71; end
  def q201; @q201 ||= -sheet48.o71; end
  def c202; "XV.a"; end
  def d202; "Petroleum refineries"; end
  def h202; @h202 ||= -sheet49.f101; end
  def i202; @i202 ||= -sheet49.g101; end
  def j202; @j202 ||= -sheet49.h101; end
  def k202; @k202 ||= -sheet49.i101; end
  def l202; @l202 ||= -sheet49.j101; end
  def m202; @m202 ||= -sheet49.k101; end
  def n202; @n202 ||= -sheet49.l101; end
  def o202; @o202 ||= -sheet49.m101; end
  def p202; @p202 ||= -sheet49.n101; end
  def q202; @q202 ||= -sheet49.o101; end
  def c203; "XV.b"; end
  def d203; "Indigenous fossil-fuel production"; end
  def h203; 1.5434122188034558; end
  def i203; 1.4512722582210527; end
  def j203; 1.3646143107322832; end
  def k203; 1.2861445576030515; end
  def l203; 1.2238113975942881; end
  def m203; 1.174296486667027; end
  def n203; 1.1349638681411904; end
  def o203; 1.103719645923531; end
  def p203; 1.078900514663677; end
  def q203; 1.059185212672716; end
  def c204; "XVII.a"; end
  def d204; "District heating effective demand"; end
  def h204; @h204 ||= -sheet52.f39; end
  def i204; @i204 ||= -sheet52.g39; end
  def j204; @j204 ||= -sheet52.h39; end
  def k204; @k204 ||= -sheet52.i39; end
  def l204; @l204 ||= -sheet52.j39; end
  def m204; @m204 ||= -sheet52.k39; end
  def n204; @n204 ||= -sheet52.l39; end
  def o204; @o204 ||= -sheet52.m39; end
  def p204; @p204 ||= -sheet52.n39; end
  def q204; @q204 ||= -sheet52.o39; end
  def d205; "Total"; end
  def h205; @h205 ||= sum(a('h191','h204')); end
  def i205; @i205 ||= sum(a('i191','i204')); end
  def j205; @j205 ||= sum(a('j191','j204')); end
  def k205; @k205 ||= sum(a('k191','k204')); end
  def l205; @l205 ||= sum(a('l191','l204')); end
  def m205; @m205 ||= sum(a('m191','m204')); end
  def n205; @n205 ||= sum(a('n191','n204')); end
  def o205; @o205 ||= sum(a('o191','o204')); end
  def p205; @p205 ||= sum(a('p191','p204')); end
  def q205; @q205 ||= sum(a('q191','q204')); end
  def d207; "Transport"; end
  def h207; @h207 ||= sum(a('h199','h200'),h191); end
  def i207; @i207 ||= sum(a('i199','i200'),i191); end
  def j207; @j207 ||= sum(a('j199','j200'),j191); end
  def k207; @k207 ||= sum(a('k199','k200'),k191); end
  def l207; @l207 ||= sum(a('l199','l200'),l191); end
  def m207; @m207 ||= sum(a('m199','m200'),m191); end
  def n207; @n207 ||= sum(a('n199','n200'),n191); end
  def o207; @o207 ||= sum(a('o199','o200'),o191); end
  def p207; @p207 ||= sum(a('p199','p200'),p191); end
  def q207; @q207 ||= sum(a('q199','q200'),q191); end
  def d208; "Industry"; end
  def h208; @h208 ||= sum(a('h201','h203'),h198,h192); end
  def i208; @i208 ||= sum(a('i201','i203'),i198,i192); end
  def j208; @j208 ||= sum(a('j201','j203'),j198,j192); end
  def k208; @k208 ||= sum(a('k201','k203'),k198,k192); end
  def l208; @l208 ||= sum(a('l201','l203'),l198,l192); end
  def m208; @m208 ||= sum(a('m201','m203'),m198,m192); end
  def n208; @n208 ||= sum(a('n201','n203'),n198,n192); end
  def o208; @o208 ||= sum(a('o201','o203'),o198,o192); end
  def p208; @p208 ||= sum(a('p201','p203'),p198,p192); end
  def q208; @q208 ||= sum(a('q201','q203'),q198,q192); end
  def d209; "Heating and cooling"; end
  def h209; @h209 ||= sum(a('h193','h195'),h204); end
  def i209; @i209 ||= sum(a('i193','i195'),i204); end
  def j209; @j209 ||= sum(a('j193','j195'),j204); end
  def k209; @k209 ||= sum(a('k193','k195'),k204); end
  def l209; @l209 ||= sum(a('l193','l195'),l204); end
  def m209; @m209 ||= sum(a('m193','m195'),m204); end
  def n209; @n209 ||= sum(a('n193','n195'),n204); end
  def o209; @o209 ||= sum(a('o193','o195'),o204); end
  def p209; @p209 ||= sum(a('p193','p195'),p204); end
  def q209; @q209 ||= sum(a('q193','q195'),q204); end
  def d210; "Lighting & appliances"; end
  def h210; @h210 ||= sum(a('h196','h197')); end
  def i210; @i210 ||= sum(a('i196','i197')); end
  def j210; @j210 ||= sum(a('j196','j197')); end
  def k210; @k210 ||= sum(a('k196','k197')); end
  def l210; @l210 ||= sum(a('l196','l197')); end
  def m210; @m210 ||= sum(a('m196','m197')); end
  def n210; @n210 ||= sum(a('n196','n197')); end
  def o210; @o210 ||= sum(a('o196','o197')); end
  def p210; @p210 ||= sum(a('p196','p197')); end
  def q210; @q210 ||= sum(a('q196','q197')); end
  def d211; "Total"; end
  def h211; @h211 ||= sum(a('h207','h210')); end
  def i211; @i211 ||= sum(a('i207','i210')); end
  def j211; @j211 ||= sum(a('j207','j210')); end
  def k211; @k211 ||= sum(a('k207','k210')); end
  def l211; @l211 ||= sum(a('l207','l210')); end
  def m211; @m211 ||= sum(a('m207','m210')); end
  def n211; @n211 ||= sum(a('n207','n210')); end
  def o211; @o211 ||= sum(a('o207','o210')); end
  def p211; @p211 ||= sum(a('p207','p210')); end
  def q211; @q211 ||= sum(a('q207','q210')); end
  def c214; "GHG"; end
  def d214; "Greenhouse gas emissions from electricity generation"; end
  def h214; 2007.0; end
  def i214; 2010.0; end
  def j214; 2015.0; end
  def k214; 2020.0; end
  def l214; 2025.0; end
  def m214; 2030.0; end
  def n214; 2035.0; end
  def o214; 2040.0; end
  def p214; 2045.0; end
  def q214; 2050.0; end
  def c216; "I.a"; end
  def d216; "Biomass/Coal power"; end
  def h216; @h216 ||= sheet17.f201; end
  def i216; @i216 ||= sheet17.g201; end
  def j216; @j216 ||= sheet17.h201; end
  def k216; @k216 ||= sheet17.i201; end
  def l216; @l216 ||= sheet17.j201; end
  def m216; @m216 ||= sheet17.k201; end
  def n216; @n216 ||= sheet17.l201; end
  def o216; @o216 ||= sheet17.m201; end
  def p216; @p216 ||= sheet17.n201; end
  def q216; @q216 ||= sheet17.o201; end
  def c217; "I.b"; end
  def d217; "Carbon Capture Storage (CCS)"; end
  def h217; 0.0; end
  def i217; 0.0; end
  def j217; @j217 ||= sheet18.h212; end
  def k217; @k217 ||= sheet18.i212; end
  def l217; @l217 ||= sheet18.j212; end
  def m217; @m217 ||= sheet18.k212; end
  def n217; @n217 ||= sheet18.l212; end
  def o217; @o217 ||= sheet18.m212; end
  def p217; @p217 ||= sheet18.n212; end
  def q217; @q217 ||= sheet18.o212; end
  def c218; "IX.a.CHP"; end
  def d218; "CHP used for domestic space heating and hot water"; end
  def h218; @h218 ||= sheet38.f718; end
  def i218; @i218 ||= sheet38.g718; end
  def j218; @j218 ||= sheet38.h718; end
  def k218; @k218 ||= sheet38.i718; end
  def l218; @l218 ||= sheet38.j718; end
  def m218; @m218 ||= sheet38.k718; end
  def n218; @n218 ||= sheet38.l718; end
  def o218; @o218 ||= sheet38.m718; end
  def p218; @p218 ||= sheet38.n718; end
  def q218; @q218 ||= sheet38.o718; end
  def c219; "IX.a.CHP"; end
  def d219; "CHP used for domestic space heating and hot water"; end
  def h219; @h219 ||= sheet38.f718; end
  def i219; @i219 ||= sheet38.g718; end
  def j219; @j219 ||= sheet38.h718; end
  def k219; @k219 ||= sheet38.i718; end
  def l219; @l219 ||= sheet38.j718; end
  def m219; @m219 ||= sheet38.k718; end
  def n219; @n219 ||= sheet38.l718; end
  def o219; @o219 ||= sheet38.m718; end
  def p219; @p219 ||= sheet38.n718; end
  def q219; @q219 ||= sheet38.o718; end
  def d220; "Total"; end
  def h220; @h220 ||= sum(a('h216','h219')); end
  def i220; @i220 ||= sum(a('i216','i219')); end
  def j220; @j220 ||= sum(a('j216','j219')); end
  def k220; @k220 ||= sum(a('k216','k219')); end
  def l220; @l220 ||= sum(a('l216','l219')); end
  def m220; @m220 ||= sum(a('m216','m219')); end
  def n220; @n220 ||= sum(a('n216','n219')); end
  def o220; @o220 ||= sum(a('o216','o219')); end
  def p220; @p220 ||= sum(a('p216','p219')); end
  def q220; @q220 ||= sum(a('q216','q219')); end
  def d222; "To fix:"; end
  def d223; "Bioenergy credit"; end
  def d224; "Allocation of some of CHP emissions to heat"; end
  def b230; "Data for web-based interface map view"; end
  def c232; "B.01"; end
  def d232; "UK Land area"; end
  def h232; 2007.0; end
  def i232; 2010.0; end
  def j232; 2015.0; end
  def k232; 2020.0; end
  def l232; 2025.0; end
  def m232; 2030.0; end
  def n232; 2035.0; end
  def o232; 2040.0; end
  def p232; 2045.0; end
  def q232; 2050.0; end
  def r232; "km^2"; end
  def c234; "III.a.1"; end
  def d234; "onshore wind if 8 Wpeak/m2"; end
  def h234; 250.00799999999998; end
  def i234; @i234 ||= sheet20.g98; end
  def j234; @j234 ||= sheet20.h98; end
  def k234; @k234 ||= sheet20.i98; end
  def l234; @l234 ||= sheet20.j98; end
  def m234; @m234 ||= sheet20.k98; end
  def n234; @n234 ||= sheet20.l98; end
  def o234; @o234 ||= sheet20.m98; end
  def p234; @p234 ||= sheet20.n98; end
  def q234; @q234 ||= sheet20.o98; end
  def c235; "III.b"; end
  def d235; "hydroelectric resevoir assuming similar to Loch Sloy"; end
  def h235; @h235 ||= sheet23.f88; end
  def i235; @i235 ||= sheet23.g88; end
  def j235; @j235 ||= sheet23.h88; end
  def k235; @k235 ||= sheet23.i88; end
  def l235; @l235 ||= sheet23.j88; end
  def m235; @m235 ||= sheet23.k88; end
  def n235; @n235 ||= sheet23.l88; end
  def o235; @o235 ||= sheet23.m88; end
  def p235; @p235 ||= sheet23.n88; end
  def q235; @q235 ||= sheet23.o88; end
  def c236; "IV.a"; end
  def d236; "solar PV if 20% efficient"; end
  def h236; @h236 ||= sheet25.f81; end
  def i236; @i236 ||= sheet25.g81; end
  def j236; @j236 ||= sheet25.h81; end
  def k236; @k236 ||= sheet25.i81; end
  def l236; @l236 ||= sheet25.j81; end
  def m236; @m236 ||= sheet25.k81; end
  def n236; @n236 ||= sheet25.l81; end
  def o236; @o236 ||= sheet25.m81; end
  def p236; @p236 ||= sheet25.n81; end
  def q236; @q236 ||= sheet25.o81; end
  def c237; "IV.b"; end
  def d237; "solar thermal panels if 50% efficient"; end
  def h237; @h237 ||= sheet26.f76; end
  def i237; @i237 ||= sheet26.g76; end
  def j237; @j237 ||= sheet26.h76; end
  def k237; @k237 ||= sheet26.i76; end
  def l237; @l237 ||= sheet26.j76; end
  def m237; @m237 ||= sheet26.k76; end
  def n237; @n237 ||= sheet26.l76; end
  def o237; @o237 ||= sheet26.m76; end
  def p237; @p237 ||= sheet26.n76; end
  def q237; @q237 ||= sheet26.o76; end
  def c238; "IV.c"; end
  def d238; "micro wind if 2 Wpeak/m2"; end
  def h238; @h238 ||= sheet27.f81; end
  def i238; @i238 ||= sheet27.g81; end
  def j238; @j238 ||= sheet27.h81; end
  def k238; @k238 ||= sheet27.i81; end
  def l238; @l238 ||= sheet27.j81; end
  def m238; @m238 ||= sheet27.k81; end
  def n238; @n238 ||= sheet27.l81; end
  def o238; @o238 ||= sheet27.m81; end
  def p238; @p238 ||= sheet27.n81; end
  def q238; @q238 ||= sheet27.o81; end
  def c239; "VI.a.biocrop"; end
  def d239; "Area of biocrops"; end
  def h239; @h239 ||= sheet30.f423; end
  def i239; @i239 ||= sheet30.g423; end
  def j239; @j239 ||= sheet30.h423; end
  def k239; @k239 ||= sheet30.i423; end
  def l239; @l239 ||= sheet30.j423; end
  def m239; @m239 ||= sheet30.k423; end
  def n239; @n239 ||= sheet30.l423; end
  def o239; @o239 ||= sheet30.m423; end
  def p239; @p239 ||= sheet30.n423; end
  def q239; @q239 ||= sheet30.o423; end
  def c240; "VI.a.Forestry"; end
  def d240; "Area of forest"; end
  def h240; @h240 ||= sheet30.f428; end
  def i240; @i240 ||= sheet30.g428; end
  def j240; @j240 ||= sheet30.h428; end
  def k240; @k240 ||= sheet30.i428; end
  def l240; @l240 ||= sheet30.j428; end
  def m240; @m240 ||= sheet30.k428; end
  def n240; @n240 ||= sheet30.l428; end
  def o240; @o240 ||= sheet30.m428; end
  def p240; @p240 ||= sheet30.n428; end
  def q240; @q240 ||= sheet30.o428; end
  def c242; "B.04"; end
  def d242; "UK Sea area"; end
  def h242; 2007.0; end
  def i242; 2010.0; end
  def j242; 2015.0; end
  def k242; 2020.0; end
  def l242; 2025.0; end
  def m242; 2030.0; end
  def n242; 2035.0; end
  def o242; 2040.0; end
  def p242; 2045.0; end
  def q242; 2050.0; end
  def r242; "km^2"; end
  def c244; "III.a.2"; end
  def d244; "offshore wind if 8 Wpeak/m2"; end
  def h244; 47.255999999999986; end
  def i244; @i244 ||= sheet21.g102; end
  def j244; @j244 ||= sheet21.h102; end
  def k244; @k244 ||= sheet21.i102; end
  def l244; @l244 ||= sheet21.j102; end
  def m244; @m244 ||= sheet21.k102; end
  def n244; @n244 ||= sheet21.l102; end
  def o244; @o244 ||= sheet21.m102; end
  def p244; @p244 ||= sheet21.n102; end
  def q244; @q244 ||= sheet21.o102; end
  def c245; "III.c.TidalStream"; end
  def d245; "tidal stream devices if >1m/s tides"; end
  def h245; @h245 ||= sheet22.f183; end
  def i245; @i245 ||= sheet22.g183; end
  def j245; @j245 ||= sheet22.h183; end
  def k245; @k245 ||= sheet22.i183; end
  def l245; @l245 ||= sheet22.j183; end
  def m245; @m245 ||= sheet22.k183; end
  def n245; @n245 ||= sheet22.l183; end
  def o245; @o245 ||= sheet22.m183; end
  def p245; @p245 ||= sheet22.n183; end
  def q245; @q245 ||= sheet22.o183; end
  def c246; "III.c.TidalRange"; end
  def d246; "tidal impoundment if >Xm tidal range"; end
  def h246; @h246 ||= sheet22.f190; end
  def i246; @i246 ||= sheet22.g190; end
  def j246; @j246 ||= sheet22.h190; end
  def k246; @k246 ||= sheet22.i190; end
  def l246; @l246 ||= sheet22.j190; end
  def m246; @m246 ||= sheet22.k190; end
  def n246; @n246 ||= sheet22.l190; end
  def o246; @o246 ||= sheet22.m190; end
  def p246; @p246 ||= sheet22.n190; end
  def q246; @q246 ||= sheet22.o190; end
  def c247; "VI.c"; end
  def d247; "algae if 0.9W/m2 efficient"; end
  def h247; @h247 ||= sheet32.f66; end
  def i247; @i247 ||= sheet32.g66; end
  def j247; @j247 ||= sheet32.h66; end
  def k247; @k247 ||= sheet32.i66; end
  def l247; @l247 ||= sheet32.j66; end
  def m247; @m247 ||= sheet32.k66; end
  def n247; @n247 ||= sheet32.l66; end
  def o247; @o247 ||= sheet32.m66; end
  def p247; @p247 ||= sheet32.n66; end
  def q247; @q247 ||= sheet32.o66; end
  def c249; "B.05"; end
  def d249; "Land area overseas"; end
  def h249; 2007.0; end
  def i249; 2010.0; end
  def j249; 2015.0; end
  def k249; 2020.0; end
  def l249; 2025.0; end
  def m249; 2030.0; end
  def n249; 2035.0; end
  def o249; 2040.0; end
  def p249; 2045.0; end
  def q249; 2050.0; end
  def r249; "km^2"; end
  def c251; "V.b"; end
  def d251; "biocrops overseas if 0.6W/m2 productivity"; end
  def h251; @h251 ||= sheet29.f93; end
  def i251; @i251 ||= sheet29.g93; end
  def j251; @j251 ||= sheet29.h93; end
  def k251; @k251 ||= sheet29.i93; end
  def l251; @l251 ||= sheet29.j93; end
  def m251; @m251 ||= sheet29.k93; end
  def n251; @n251 ||= sheet29.l93; end
  def o251; @o251 ||= sheet29.m93; end
  def p251; @p251 ||= sheet29.n93; end
  def q251; @q251 ||= sheet29.o93; end
  def c252; "VII.a"; end
  def d252; "solar devices overseas assuming 15W/m2 "; end
  def h252; @h252 ||= sheet33.f69; end
  def i252; @i252 ||= sheet33.g69; end
  def j252; @j252 ||= sheet33.h69; end
  def k252; @k252 ||= sheet33.i69; end
  def l252; @l252 ||= sheet33.j69; end
  def m252; @m252 ||= sheet33.k69; end
  def n252; @n252 ||= sheet33.l69; end
  def o252; @o252 ||= sheet33.m69; end
  def p252; @p252 ||= sheet33.n69; end
  def q252; @q252 ||= sheet33.o69; end
  def c254; "B.06"; end
  def d254; "Length of wave front"; end
  def h254; 2007.0; end
  def i254; 2010.0; end
  def j254; 2015.0; end
  def k254; 2020.0; end
  def l254; 2025.0; end
  def m254; 2030.0; end
  def n254; 2035.0; end
  def o254; 2040.0; end
  def p254; 2045.0; end
  def q254; 2050.0; end
  def r254; "km"; end
  def c256; "III.c.Wave"; end
  def d256; "wave energy convertors if 25% efficient"; end
  def h256; @h256 ||= sheet22.f176; end
  def i256; @i256 ||= sheet22.g176; end
  def j256; @j256 ||= sheet22.h176; end
  def k256; @k256 ||= sheet22.i176; end
  def l256; @l256 ||= sheet22.j176; end
  def m256; @m256 ||= sheet22.k176; end
  def n256; @n256 ||= sheet22.l176; end
  def o256; @o256 ||= sheet22.m176; end
  def p256; @p256 ||= sheet22.n176; end
  def q256; @q256 ||= sheet22.o176; end
  def c258; "B.03"; end
  def d258; "Number of units"; end
  def h258; 2007.0; end
  def i258; 2010.0; end
  def j258; 2015.0; end
  def k258; 2020.0; end
  def l258; 2025.0; end
  def m258; 2030.0; end
  def n258; 2035.0; end
  def o258; 2040.0; end
  def p258; 2045.0; end
  def q258; 2050.0; end
  def r258; "#"; end
  def c260; "I.a"; end
  def d260; "2 GW thermal power stations"; end
  def h260; @h260 ||= sheet17.f211; end
  def i260; @i260 ||= sheet17.g211; end
  def j260; @j260 ||= sheet17.h211; end
  def k260; @k260 ||= sheet17.i211; end
  def l260; @l260 ||= sheet17.j211; end
  def m260; @m260 ||= sheet17.k211; end
  def n260; @n260 ||= sheet17.l211; end
  def o260; @o260 ||= sheet17.m211; end
  def p260; @p260 ||= sheet17.n211; end
  def q260; @q260 ||= sheet17.o211; end
  def c261; "I.b"; end
  def d261; "1.2 GW CCS power stations"; end
  def h261; 0.0; end
  def i261; @i261 ||= sheet18.g221; end
  def j261; @j261 ||= sheet18.h221; end
  def k261; @k261 ||= sheet18.i221; end
  def l261; @l261 ||= sheet18.j221; end
  def m261; @m261 ||= sheet18.k221; end
  def n261; @n261 ||= sheet18.l221; end
  def o261; @o261 ||= sheet18.m221; end
  def p261; @p261 ||= sheet18.n221; end
  def q261; @q261 ||= sheet18.o221; end
  def c262; "II.a"; end
  def d262; "3 GW nuclear power station complexes"; end
  def h262; 3.6666666666666665; end
  def i262; @i262 ||= sheet19.g129; end
  def j262; @j262 ||= sheet19.h129; end
  def k262; @k262 ||= sheet19.i129; end
  def l262; @l262 ||= sheet19.j129; end
  def m262; @m262 ||= sheet19.k129; end
  def n262; @n262 ||= sheet19.l129; end
  def o262; @o262 ||= sheet19.m129; end
  def p262; @p262 ||= sheet19.n129; end
  def q262; @q262 ||= sheet19.o129; end
  def c263; "III.d"; end
  def d263; "0.05 GW geothermal power stations"; end
  def h263; @h263 ||= sheet24.f74; end
  def i263; @i263 ||= sheet24.g74; end
  def j263; @j263 ||= sheet24.h74; end
  def k263; @k263 ||= sheet24.i74; end
  def l263; @l263 ||= sheet24.j74; end
  def m263; @m263 ||= sheet24.k74; end
  def n263; @n263 ||= sheet24.l74; end
  def o263; @o263 ||= sheet24.m74; end
  def p263; @p263 ||= sheet24.n74; end
  def q263; @q263 ||= sheet24.o74; end
  def c264; "VII.c"; end
  def d264; "1 GW standby generators"; end
  def h264; @h264 ||= sheet35.f434; end
  def i264; @i264 ||= sheet35.g434; end
  def j264; @j264 ||= sheet35.h434; end
  def k264; @k264 ||= sheet35.i434; end
  def l264; @l264 ||= sheet35.j434; end
  def m264; @m264 ||= sheet35.k434; end
  def n264; @n264 ||= sheet35.l434; end
  def o264; @o264 ||= sheet35.m434; end
  def p264; @p264 ||= sheet35.n434; end
  def q264; @q264 ||= sheet35.o434; end
  def i269; 2050.0; end
  def d270; "This is the data used for the sankey diagram in the web tool"; end
  def h270; "From"; end
  def i270; "TWh"; end
  def j270; "To"; end
  def n270; "Box"; end
  def o270; "Out"; end
  def p270; "In"; end
  def q270; "Delta"; end
  def r270; "Problem"; end
  def h271; "Coal reserves"; end
  def i271; @i271 ||= q38; end
  def j271; "Coal"; end
  def n271; "Agricultural 'waste'"; end
  def o271; @o271 ||= sumif(a('h271','h361'),n271,a('i271','i361')); end
  def p271; @p271 ||= sumif(a('j271','j361'),n271,a('i271','i361')); end
  def q271; @q271 ||= o271-p271; end
  def r271; @r271 ||= excel_if(q271==0.0,"ok",excel_if(abs(q271)==sum(a('o271','p271')),"ok","error")); end
  def h272; "Coal imports"; end
  def i272; @i272 ||= max(q37,0.0); end
  def j272; "Coal"; end
  def n272; "Agriculture"; end
  def o272; @o272 ||= sumif(a('h271','h361'),n272,a('i271','i361')); end
  def p272; @p272 ||= sumif(a('j271','j361'),n272,a('i271','i361')); end
  def q272; @q272 ||= o272-p272; end
  def r272; @r272 ||= excel_if(q272==0.0,"ok",excel_if(abs(q272)==sum(a('o272','p272')),"ok","error")); end
  def h273; "Oil reserves"; end
  def i273; @i273 ||= q40; end
  def j273; "Oil"; end
  def n273; "Bio-conversion"; end
  def o273; @o273 ||= sumif(a('h271','h361'),n273,a('i271','i361')); end
  def p273; @p273 ||= sumif(a('j271','j361'),n273,a('i271','i361')); end
  def q273; @q273 ||= o273-p273; end
  def r273; @r273 ||= excel_if(q273==0.0,"ok",excel_if(abs(q273)==sum(a('o273','p273')),"ok","error")); end
  def h274; "Oil imports"; end
  def i274; @i274 ||= max(q41,0.0); end
  def j274; "Oil"; end
  def n274; "Biofuel imports"; end
  def o274; @o274 ||= sumif(a('h271','h361'),n274,a('i271','i361')); end
  def p274; @p274 ||= sumif(a('j271','j361'),n274,a('i271','i361')); end
  def q274; @q274 ||= o274-p274; end
  def r274; @r274 ||= excel_if(q274==0.0,"ok",excel_if(abs(q274)==sum(a('o274','p274')),"ok","error")); end
  def h275; "Gas reserves"; end
  def i275; @i275 ||= q45; end
  def j275; "Ngas"; end
  def n275; "Biomass imports"; end
  def o275; @o275 ||= sumif(a('h271','h361'),n275,a('i271','i361')); end
  def p275; @p275 ||= sumif(a('j271','j361'),n275,a('i271','i361')); end
  def q275; @q275 ||= o275-p275; end
  def r275; @r275 ||= excel_if(q275==0.0,"ok",excel_if(abs(q275)==sum(a('o275','p275')),"ok","error")); end
  def h276; "Gas imports"; end
  def i276; @i276 ||= max(q44,0.0); end
  def j276; "Ngas"; end
  def n276; "CHP"; end
  def o276; @o276 ||= sumif(a('h271','h361'),n276,a('i271','i361')); end
  def p276; @p276 ||= sumif(a('j271','j361'),n276,a('i271','i361')); end
  def q276; @q276 ||= o276-p276; end
  def r276; @r276 ||= excel_if(q276==0.0,"ok",excel_if(abs(q276)==sum(a('o276','p276')),"ok","error")); end
  def h277; "UK land based bioenergy"; end
  def i277; @i277 ||= sheet30.o395+sheet30.o396; end
  def j277; "Bio-conversion"; end
  def n277; "Coal"; end
  def o277; @o277 ||= sumif(a('h271','h361'),n277,a('i271','i361')); end
  def p277; @p277 ||= sumif(a('j271','j361'),n277,a('i271','i361')); end
  def q277; @q277 ||= o277-p277; end
  def r277; @r277 ||= excel_if(q277==0.0,"ok",excel_if(abs(q277)==sum(a('o277','p277')),"ok","error")); end
  def h278; "Marine algae"; end
  def i278; @i278 ||= sheet32.o56; end
  def j278; "Bio-conversion"; end
  def n278; "Coal imports"; end
  def o278; @o278 ||= sumif(a('h271','h361'),n278,a('i271','i361')); end
  def p278; @p278 ||= sumif(a('j271','j361'),n278,a('i271','i361')); end
  def q278; @q278 ||= o278-p278; end
  def r278; @r278 ||= excel_if(q278==0.0,"ok",excel_if(abs(q278)==sum(a('o278','p278')),"ok","error")); end
  def h279; "Agricultural 'waste'"; end
  def i279; @i279 ||= sheet30.o397+sheet30.o398; end
  def j279; "Bio-conversion"; end
  def n279; "Coal reserves"; end
  def o279; @o279 ||= sumif(a('h271','h361'),n279,a('i271','i361')); end
  def p279; @p279 ||= sumif(a('j271','j361'),n279,a('i271','i361')); end
  def q279; @q279 ||= o279-p279; end
  def r279; @r279 ||= excel_if(q279==0.0,"ok",excel_if(abs(q279)==sum(a('o279','p279')),"ok","error")); end
  def h280; "Other waste"; end
  def i280; @i280 ||= sum(sheet31.a('o269','o271')); end
  def j280; "Bio-conversion"; end
  def n280; "District heating"; end
  def o280; @o280 ||= sumif(a('h271','h361'),n280,a('i271','i361')); end
  def p280; @p280 ||= sumif(a('j271','j361'),n280,a('i271','i361')); end
  def q280; @q280 ||= o280-p280; end
  def r280; @r280 ||= excel_if(q280==0.0,"ok",excel_if(abs(q280)==sum(a('o280','p280')),"ok","error")); end
  def h281; "Other waste"; end
  def i281; @i281 ||= sheet31.o268; end
  def j281; "Solid"; end
  def n281; "Domestic aviation"; end
  def o281; @o281 ||= sumif(a('h271','h361'),n281,a('i271','i361')); end
  def p281; @p281 ||= sumif(a('j271','j361'),n281,a('i271','i361')); end
  def q281; @q281 ||= o281-p281; end
  def r281; @r281 ||= excel_if(q281==0.0,"ok",excel_if(abs(q281)==sum(a('o281','p281')),"ok","error")); end
  def h282; "Biomass imports"; end
  def i282; @i282 ||= sheet29.o72; end
  def j282; "Solid"; end
  def n282; "Electricity grid"; end
  def o282; @o282 ||= sumif(a('h271','h361'),n282,a('i271','i361')); end
  def p282; @p282 ||= sumif(a('j271','j361'),n282,a('i271','i361')); end
  def q282; @q282 ||= o282-p282; end
  def r282; @r282 ||= excel_if(q282==0.0,"ok",excel_if(abs(q282)==sum(a('o282','p282')),"ok","error")); end
  def h283; "Biofuel imports"; end
  def i283; @i283 ||= sheet29.o73; end
  def j283; "Liquid"; end
  def n283; "Electricity imports"; end
  def o283; @o283 ||= sumif(a('h271','h361'),n283,a('i271','i361')); end
  def p283; @p283 ||= sumif(a('j271','j361'),n283,a('i271','i361')); end
  def q283; @q283 ||= o283-p283; end
  def r283; @r283 ||= excel_if(q283==0.0,"ok",excel_if(abs(q283)==sum(a('o283','p283')),"ok","error")); end
  def h284; "Coal"; end
  def i284; @i284 ||= sum(a('i271','i272')); end
  def j284; "Solid"; end
  def n284; "Gas"; end
  def o284; @o284 ||= sumif(a('h271','h361'),n284,a('i271','i361')); end
  def p284; @p284 ||= sumif(a('j271','j361'),n284,a('i271','i361')); end
  def q284; @q284 ||= o284-p284; end
  def r284; @r284 ||= excel_if(q284==0.0,"ok",excel_if(abs(q284)==sum(a('o284','p284')),"ok","error")); end
  def h285; "Oil"; end
  def i285; @i285 ||= sum(a('i273','i274')); end
  def j285; "Liquid"; end
  def n285; "Gas imports"; end
  def o285; @o285 ||= sumif(a('h271','h361'),n285,a('i271','i361')); end
  def p285; @p285 ||= sumif(a('j271','j361'),n285,a('i271','i361')); end
  def q285; @q285 ||= o285-p285; end
  def r285; @r285 ||= excel_if(q285==0.0,"ok",excel_if(abs(q285)==sum(a('o285','p285')),"ok","error")); end
  def h286; "Ngas"; end
  def i286; @i286 ||= sum(a('i275','i276')); end
  def j286; "Gas"; end
  def n286; "Gas reserves"; end
  def o286; @o286 ||= sumif(a('h271','h361'),n286,a('i271','i361')); end
  def p286; @p286 ||= sumif(a('j271','j361'),n286,a('i271','i361')); end
  def q286; @q286 ||= o286-p286; end
  def r286; @r286 ||= excel_if(q286==0.0,"ok",excel_if(abs(q286)==sum(a('o286','p286')),"ok","error")); end
  def h287; "Solar"; end
  def i287; @i287 ||= sheet25.o71; end
  def j287; "Solar PV"; end
  def n287; "Geosequestration"; end
  def o287; @o287 ||= sumif(a('h271','h361'),n287,a('i271','i361')); end
  def p287; @p287 ||= sumif(a('j271','j361'),n287,a('i271','i361')); end
  def q287; @q287 ||= o287-p287; end
  def r287; @r287 ||= excel_if(q287==0.0,"ok",excel_if(abs(q287)==sum(a('o287','p287')),"ok","error")); end
  def h288; "Solar PV"; end
  def i288; @i288 ||= i287; end
  def j288; "Electricity grid"; end
  def n288; "Geothermal"; end
  def o288; @o288 ||= sumif(a('h271','h361'),n288,a('i271','i361')); end
  def p288; @p288 ||= sumif(a('j271','j361'),n288,a('i271','i361')); end
  def q288; @q288 ||= o288-p288; end
  def r288; @r288 ||= excel_if(q288==0.0,"ok",excel_if(abs(q288)==sum(a('o288','p288')),"ok","error")); end
  def h289; "Solar"; end
  def i289; @i289 ||= sheet26.o64; end
  def j289; "Solar Thermal"; end
  def n289; "H2"; end
  def o289; @o289 ||= sumif(a('h271','h361'),n289,a('i271','i361')); end
  def p289; @p289 ||= sumif(a('j271','j361'),n289,a('i271','i361')); end
  def q289; @q289 ||= o289-p289; end
  def r289; @r289 ||= excel_if(q289==0.0,"ok",excel_if(abs(q289)==sum(a('o289','p289')),"ok","error")); end
  def n290; "H2 conversion"; end
  def o290; @o290 ||= sumif(a('h271','h361'),n290,a('i271','i361')); end
  def p290; @p290 ||= sumif(a('j271','j361'),n290,a('i271','i361')); end
  def q290; @q290 ||= o290-p290; end
  def r290; @r290 ||= excel_if(q290==0.0,"ok",excel_if(abs(q290)==sum(a('o290','p290')),"ok","error")); end
  def h291; "Bio-conversion"; end
  def i291; @i291 ||= sheet28.o198; end
  def j291; "Solid"; end
  def n291; "Heating and cooling - commercial"; end
  def o291; @o291 ||= sumif(a('h271','h361'),n291,a('i271','i361')); end
  def p291; @p291 ||= sumif(a('j271','j361'),n291,a('i271','i361')); end
  def q291; @q291 ||= o291-p291; end
  def r291; @r291 ||= excel_if(q291==0.0,"ok",excel_if(abs(q291)==sum(a('o291','p291')),"ok","error")); end
  def h292; "Bio-conversion"; end
  def i292; @i292 ||= sheet28.o199; end
  def j292; "Liquid"; end
  def n292; "Heating and cooling - homes"; end
  def o292; @o292 ||= sumif(a('h271','h361'),n292,a('i271','i361')); end
  def p292; @p292 ||= sumif(a('j271','j361'),n292,a('i271','i361')); end
  def q292; @q292 ||= o292-p292; end
  def r292; @r292 ||= excel_if(q292==0.0,"ok",excel_if(abs(q292)==sum(a('o292','p292')),"ok","error")); end
  def h293; "Bio-conversion"; end
  def i293; @i293 ||= sheet28.o200; end
  def j293; "Gas"; end
  def n293; "Hydro"; end
  def o293; @o293 ||= sumif(a('h271','h361'),n293,a('i271','i361')); end
  def p293; @p293 ||= sumif(a('j271','j361'),n293,a('i271','i361')); end
  def q293; @q293 ||= o293-p293; end
  def r293; @r293 ||= excel_if(q293==0.0,"ok",excel_if(abs(q293)==sum(a('o293','p293')),"ok","error")); end
  def h294; "Bio-conversion"; end
  def i294; @i294 ||= sheet28.o206; end
  def j294; "Losses"; end
  def n294; "Industry"; end
  def o294; @o294 ||= sumif(a('h271','h361'),n294,a('i271','i361')); end
  def p294; @p294 ||= sumif(a('j271','j361'),n294,a('i271','i361')); end
  def q294; @q294 ||= o294-p294; end
  def r294; @r294 ||= excel_if(q294==0.0,"ok",excel_if(abs(q294)==sum(a('o294','p294')),"ok","error")); end
  def h295; "Solid"; end
  def i295; @i295 ||= max(-q37,0.0); end
  def j295; "Over generation / exports"; end
  def n295; "International aviation"; end
  def o295; @o295 ||= sumif(a('h271','h361'),n295,a('i271','i361')); end
  def p295; @p295 ||= sumif(a('j271','j361'),n295,a('i271','i361')); end
  def q295; @q295 ||= o295-p295; end
  def r295; @r295 ||= excel_if(q295==0.0,"ok",excel_if(abs(q295)==sum(a('o295','p295')),"ok","error")); end
  def h296; "Liquid"; end
  def i296; @i296 ||= max(-q41,0.0); end
  def j296; "Over generation / exports"; end
  def n296; "International shipping"; end
  def o296; @o296 ||= sumif(a('h271','h361'),n296,a('i271','i361')); end
  def p296; @p296 ||= sumif(a('j271','j361'),n296,a('i271','i361')); end
  def q296; @q296 ||= o296-p296; end
  def r296; @r296 ||= excel_if(q296==0.0,"ok",excel_if(abs(q296)==sum(a('o296','p296')),"ok","error")); end
  def h297; "Gas"; end
  def i297; @i297 ||= max(-q44,0.0); end
  def j297; "Over generation / exports"; end
  def n297; "Lighting & appliances - commercial"; end
  def o297; @o297 ||= sumif(a('h271','h361'),n297,a('i271','i361')); end
  def p297; @p297 ||= sumif(a('j271','j361'),n297,a('i271','i361')); end
  def q297; @q297 ||= o297-p297; end
  def r297; @r297 ||= excel_if(q297==0.0,"ok",excel_if(abs(q297)==sum(a('o297','p297')),"ok","error")); end
  def h298; "Solid"; end
  def i298; @i298 ||= -sheet17.o185-sheet18.o196; end
  def j298; "Thermal generation"; end
  def n298; "Lighting & appliances - homes"; end
  def o298; @o298 ||= sumif(a('h271','h361'),n298,a('i271','i361')); end
  def p298; @p298 ||= sumif(a('j271','j361'),n298,a('i271','i361')); end
  def q298; @q298 ||= o298-p298; end
  def r298; @r298 ||= excel_if(q298==0.0,"ok",excel_if(abs(q298)==sum(a('o298','p298')),"ok","error")); end
  def h299; "Liquid"; end
  def i299; 0.0; end
  def j299; "Thermal generation"; end
  def n299; "Liquid"; end
  def o299; @o299 ||= sumif(a('h271','h361'),n299,a('i271','i361')); end
  def p299; @p299 ||= sumif(a('j271','j361'),n299,a('i271','i361')); end
  def q299; @q299 ||= o299-p299; end
  def r299; @r299 ||= excel_if(q299==0.0,"ok",excel_if(abs(q299)==sum(a('o299','p299')),"ok","error")); end
  def h300; "Gas"; end
  def i300; @i300 ||= -sheet17.o187-sheet18.o197; end
  def j300; "Thermal generation"; end
  def n300; "Losses"; end
  def o300; @o300 ||= sumif(a('h271','h361'),n300,a('i271','i361')); end
  def p300; @p300 ||= sumif(a('j271','j361'),n300,a('i271','i361')); end
  def q300; @q300 ||= o300-p300; end
  def r300; @r300 ||= excel_if(q300==0.0,"ok",excel_if(abs(q300)==sum(a('o300','p300')),"ok","error")); end
  def h301; "Nuclear"; end
  def i301; @i301 ||= -sheet19.o117; end
  def j301; "Thermal generation"; end
  def n301; "Marine algae"; end
  def o301; @o301 ||= sumif(a('h271','h361'),n301,a('i271','i361')); end
  def p301; @p301 ||= sumif(a('j271','j361'),n301,a('i271','i361')); end
  def q301; @q301 ||= o301-p301; end
  def r301; @r301 ||= excel_if(q301==0.0,"ok",excel_if(abs(q301)==sum(a('o301','p301')),"ok","error")); end
  def h302; "Thermal generation"; end
  def i302; @i302 ||= sheet52.o38; end
  def j302; "District heating"; end
  def n302; "National navigation"; end
  def o302; @o302 ||= sumif(a('h271','h361'),n302,a('i271','i361')); end
  def p302; @p302 ||= sumif(a('j271','j361'),n302,a('i271','i361')); end
  def q302; @q302 ||= o302-p302; end
  def r302; @r302 ||= excel_if(q302==0.0,"ok",excel_if(abs(q302)==sum(a('o302','p302')),"ok","error")); end
  def h303; "Thermal generation"; end
  def i303; @i303 ||= sheet17.o184+sheet18.o195+sheet19.o116+sheet52.o39; end
  def j303; "Electricity grid"; end
  def n303; "Ngas"; end
  def o303; @o303 ||= sumif(a('h271','h361'),n303,a('i271','i361')); end
  def p303; @p303 ||= sumif(a('j271','j361'),n303,a('i271','i361')); end
  def q303; @q303 ||= o303-p303; end
  def r303; @r303 ||= excel_if(q303==0.0,"ok",excel_if(abs(q303)==sum(a('o303','p303')),"ok","error")); end
  def h304; "Thermal generation"; end
  def i304; @i304 ||= sheet52.o40+sheet17.o188+sheet17.o189+sheet18.o198+sheet18.o199+sheet19.o118+sheet19.o119; end
  def j304; "Losses"; end
  def n304; "Nuclear"; end
  def o304; @o304 ||= sumif(a('h271','h361'),n304,a('i271','i361')); end
  def p304; @p304 ||= sumif(a('j271','j361'),n304,a('i271','i361')); end
  def q304; @q304 ||= o304-p304; end
  def r304; @r304 ||= excel_if(q304==0.0,"ok",excel_if(abs(q304)==sum(a('o304','p304')),"ok","error")); end
  def h305; "Solid"; end
  def i305; @i305 ||= -sheet38.o674-sheet39.o379; end
  def j305; "CHP"; end
  def n305; "Oil"; end
  def o305; @o305 ||= sumif(a('h271','h361'),n305,a('i271','i361')); end
  def p305; @p305 ||= sumif(a('j271','j361'),n305,a('i271','i361')); end
  def q305; @q305 ||= o305-p305; end
  def r305; @r305 ||= excel_if(q305==0.0,"ok",excel_if(abs(q305)==sum(a('o305','p305')),"ok","error")); end
  def h306; "Liquid"; end
  def i306; @i306 ||= -sheet38.o675-sheet39.o380; end
  def j306; "CHP"; end
  def n306; "Oil imports"; end
  def o306; @o306 ||= sumif(a('h271','h361'),n306,a('i271','i361')); end
  def p306; @p306 ||= sumif(a('j271','j361'),n306,a('i271','i361')); end
  def q306; @q306 ||= o306-p306; end
  def r306; @r306 ||= excel_if(q306==0.0,"ok",excel_if(abs(q306)==sum(a('o306','p306')),"ok","error")); end
  def h307; "Gas"; end
  def i307; @i307 ||= -sheet38.o676-sheet39.o381; end
  def j307; "CHP"; end
  def n307; "Oil reserves"; end
  def o307; @o307 ||= sumif(a('h271','h361'),n307,a('i271','i361')); end
  def p307; @p307 ||= sumif(a('j271','j361'),n307,a('i271','i361')); end
  def q307; @q307 ||= o307-p307; end
  def r307; @r307 ||= excel_if(q307==0.0,"ok",excel_if(abs(q307)==sum(a('o307','p307')),"ok","error")); end
  def h308; "CHP"; end
  def i308; @i308 ||= sheet38.o673+sheet39.o378; end
  def j308; "Electricity grid"; end
  def n308; "Other waste"; end
  def o308; @o308 ||= sumif(a('h271','h361'),n308,a('i271','i361')); end
  def p308; @p308 ||= sumif(a('j271','j361'),n308,a('i271','i361')); end
  def q308; @q308 ||= o308-p308; end
  def r308; @r308 ||= excel_if(q308==0.0,"ok",excel_if(abs(q308)==sum(a('o308','p308')),"ok","error")); end
  def h309; "CHP"; end
  def i309; @i309 ||= sheet38.o681+sheet39.o385; end
  def j309; "Losses"; end
  def n309; "Over generation / exports"; end
  def o309; @o309 ||= sumif(a('h271','h361'),n309,a('i271','i361')); end
  def p309; @p309 ||= sumif(a('j271','j361'),n309,a('i271','i361')); end
  def q309; @q309 ||= o309-p309; end
  def r309; @r309 ||= excel_if(q309==0.0,"ok",excel_if(abs(q309)==sum(a('o309','p309')),"ok","error")); end
  def h310; "Electricity imports"; end
  def i310; @i310 ||= sheet33.o59; end
  def j310; "Electricity grid"; end
  def n310; "Pumped heat"; end
  def o310; @o310 ||= sumif(a('h271','h361'),n310,a('i271','i361')); end
  def p310; @p310 ||= sumif(a('j271','j361'),n310,a('i271','i361')); end
  def q310; @q310 ||= o310-p310; end
  def r310; @r310 ||= excel_if(q310==0.0,"ok",excel_if(abs(q310)==sum(a('o310','p310')),"ok","error")); end
  def h311; "Wind"; end
  def i311; @i311 ||= sheet20.o88+sheet21.o92; end
  def j311; "Electricity grid"; end
  def n311; "Rail transport"; end
  def o311; @o311 ||= sumif(a('h271','h361'),n311,a('i271','i361')); end
  def p311; @p311 ||= sumif(a('j271','j361'),n311,a('i271','i361')); end
  def q311; @q311 ||= o311-p311; end
  def r311; @r311 ||= excel_if(q311==0.0,"ok",excel_if(abs(q311)==sum(a('o311','p311')),"ok","error")); end
  def h312; "Tidal"; end
  def i312; @i312 ||= sheet22.o157+sheet22.o165; end
  def j312; "Electricity grid"; end
  def n312; "Road transport"; end
  def o312; @o312 ||= sumif(a('h271','h361'),n312,a('i271','i361')); end
  def p312; @p312 ||= sumif(a('j271','j361'),n312,a('i271','i361')); end
  def q312; @q312 ||= o312-p312; end
  def r312; @r312 ||= excel_if(q312==0.0,"ok",excel_if(abs(q312)==sum(a('o312','p312')),"ok","error")); end
  def h313; "Wave"; end
  def i313; @i313 ||= sheet22.o149; end
  def j313; "Electricity grid"; end
  def n313; "Solar"; end
  def o313; @o313 ||= sumif(a('h271','h361'),n313,a('i271','i361')); end
  def p313; @p313 ||= sumif(a('j271','j361'),n313,a('i271','i361')); end
  def q313; @q313 ||= o313-p313; end
  def r313; @r313 ||= excel_if(q313==0.0,"ok",excel_if(abs(q313)==sum(a('o313','p313')),"ok","error")); end
  def h314; "Geothermal"; end
  def i314; @i314 ||= sheet24.o64; end
  def j314; "Electricity grid"; end
  def n314; "Solar PV"; end
  def o314; @o314 ||= sumif(a('h271','h361'),n314,a('i271','i361')); end
  def p314; @p314 ||= sumif(a('j271','j361'),n314,a('i271','i361')); end
  def q314; @q314 ||= o314-p314; end
  def r314; @r314 ||= excel_if(q314==0.0,"ok",excel_if(abs(q314)==sum(a('o314','p314')),"ok","error")); end
  def h315; "Hydro"; end
  def i315; @i315 ||= sheet23.o77; end
  def j315; "Electricity grid"; end
  def n315; "Solar Thermal"; end
  def o315; @o315 ||= sumif(a('h271','h361'),n315,a('i271','i361')); end
  def p315; @p315 ||= sumif(a('j271','j361'),n315,a('i271','i361')); end
  def q315; @q315 ||= o315-p315; end
  def r315; @r315 ||= excel_if(q315==0.0,"ok",excel_if(abs(q315)==sum(a('o315','p315')),"ok","error")); end
  def h316; "Electricity grid"; end
  def i316; @i316 ||= -sheet37.o62; end
  def j316; "H2 conversion"; end
  def n316; "Solid"; end
  def o316; @o316 ||= sumif(a('h271','h361'),n316,a('i271','i361')); end
  def p316; @p316 ||= sumif(a('j271','j361'),n316,a('i271','i361')); end
  def q316; @q316 ||= o316-p316; end
  def r316; @r316 ||= excel_if(q316==0.0,"ok",excel_if(abs(q316)==sum(a('o316','p316')),"ok","error")); end
  def h317; "Electricity grid"; end
  def i317; @i317 ||= max(-sheet64.t104,0.0); end
  def j317; "Over generation / exports"; end
  def n317; "Thermal generation"; end
  def o317; @o317 ||= sumif(a('h271','h361'),n317,a('i271','i361')); end
  def p317; @p317 ||= sumif(a('j271','j361'),n317,a('i271','i361')); end
  def q317; @q317 ||= o317-p317; end
  def r317; @r317 ||= excel_if(q317==0.0,"ok",excel_if(abs(q317)==sum(a('o317','p317')),"ok","error")); end
  def h318; "Electricity grid"; end
  def i318; @i318 ||= sheet34.o39; end
  def j318; "Losses"; end
  def n318; "Tidal"; end
  def o318; @o318 ||= sumif(a('h271','h361'),n318,a('i271','i361')); end
  def p318; @p318 ||= sumif(a('j271','j361'),n318,a('i271','i361')); end
  def q318; @q318 ||= o318-p318; end
  def r318; @r318 ||= excel_if(q318==0.0,"ok",excel_if(abs(q318)==sum(a('o318','p318')),"ok","error")); end
  def h319; "Gas"; end
  def i319; @i319 ||= -sheet37.o63; end
  def j319; "H2 conversion"; end
  def n319; "UK land based bioenergy"; end
  def o319; @o319 ||= sumif(a('h271','h361'),n319,a('i271','i361')); end
  def p319; @p319 ||= sumif(a('j271','j361'),n319,a('i271','i361')); end
  def q319; @q319 ||= o319-p319; end
  def r319; @r319 ||= excel_if(q319==0.0,"ok",excel_if(abs(q319)==sum(a('o319','p319')),"ok","error")); end
  def h320; "H2 conversion"; end
  def i320; @i320 ||= sheet37.o64; end
  def j320; "H2"; end
  def n320; "Wave"; end
  def o320; @o320 ||= sumif(a('h271','h361'),n320,a('i271','i361')); end
  def p320; @p320 ||= sumif(a('j271','j361'),n320,a('i271','i361')); end
  def q320; @q320 ||= o320-p320; end
  def r320; @r320 ||= excel_if(q320==0.0,"ok",excel_if(abs(q320)==sum(a('o320','p320')),"ok","error")); end
  def h321; "H2 conversion"; end
  def i321; @i321 ||= sheet37.o65; end
  def j321; "Losses"; end
  def n321; "Wind"; end
  def o321; @o321 ||= sumif(a('h271','h361'),n321,a('i271','i361')); end
  def p321; @p321 ||= sumif(a('j271','j361'),n321,a('i271','i361')); end
  def q321; @q321 ||= o321-p321; end
  def r321; @r321 ||= excel_if(q321==0.0,"ok",excel_if(abs(q321)==sum(a('o321','p321')),"ok","error")); end
  def h322; "Solar Thermal"; end
  def i322; @i322 ||= -sheet38.o694; end
  def j322; "Heating and cooling - homes"; end
  def h323; "H2"; end
  def i323; @i323 ||= -sheet43.o345; end
  def j323; "Road transport"; end
  def h324; "Pumped heat"; end
  def i324; @i324 ||= -sheet38.o695; end
  def j324; "Heating and cooling - homes"; end
  def h325; "Pumped heat"; end
  def i325; @i325 ||= -sheet39.o397; end
  def j325; "Heating and cooling - commercial"; end
  def h326; "CHP"; end
  def i326; @i326 ||= sheet38.o680; end
  def j326; "Heating and cooling - homes"; end
  def h327; "CHP"; end
  def i327; @i327 ||= sheet39.o384; end
  def j327; "Heating and cooling - commercial"; end
  def h328; "District heating"; end
  def i328; @i328 ||= -sheet38.o693; end
  def j328; "Heating and cooling - homes"; end
  def h329; "District heating"; end
  def i329; @i329 ||= -sheet39.o396; end
  def j329; "Heating and cooling - commercial"; end
  def h330; "District heating"; end
  def i330; @i330 ||= -sheet42.o217-sheet49.o104; end
  def j330; "Industry"; end
  def h331; "District heating"; end
  def i331; @i331 ||= i302-sum(a('i328','i330')); end
  def j331; "Losses"; end
  def h332; "Electricity grid"; end
  def i332; @i332 ||= -sheet38.o657; end
  def j332; "Heating and cooling - homes"; end
  def h333; "Solid"; end
  def i333; @i333 ||= -sheet38.o659; end
  def j333; "Heating and cooling - homes"; end
  def h334; "Liquid"; end
  def i334; @i334 ||= -sheet38.o660; end
  def j334; "Heating and cooling - homes"; end
  def h335; "Gas"; end
  def i335; @i335 ||= -sheet38.o661; end
  def j335; "Heating and cooling - homes"; end
  def h336; "Electricity grid"; end
  def i336; @i336 ||= -sheet39.o363; end
  def j336; "Heating and cooling - commercial"; end
  def h337; "Solid"; end
  def i337; @i337 ||= -sheet39.o365; end
  def j337; "Heating and cooling - commercial"; end
  def h338; "Liquid"; end
  def i338; @i338 ||= -sheet39.o366; end
  def j338; "Heating and cooling - commercial"; end
  def h339; "Gas"; end
  def i339; @i339 ||= -sheet39.o367; end
  def j339; "Heating and cooling - commercial"; end
  def h340; "Electricity grid"; end
  def i340; @i340 ||= -sheet40.o100; end
  def j340; "Lighting & appliances - homes"; end
  def h341; "Gas"; end
  def i341; @i341 ||= -sheet40.o101; end
  def j341; "Lighting & appliances - homes"; end
  def h342; "Electricity grid"; end
  def i342; @i342 ||= -sheet41.o91; end
  def j342; "Lighting & appliances - commercial"; end
  def h343; "Gas"; end
  def i343; @i343 ||= -sheet41.o92; end
  def j343; "Lighting & appliances - commercial"; end
  def h344; "Electricity grid"; end
  def i344; @i344 ||= -sheet42.o213-sheet49.o101-sheet50.o75; end
  def j344; "Industry"; end
  def h345; "Solid"; end
  def i345; @i345 ||= -sheet42.o214-sheet50.o76; end
  def j345; "Industry"; end
  def h346; "Liquid"; end
  def i346; @i346 ||= -sheet42.o215-sheet49.o102; end
  def j346; "Industry"; end
  def h347; "Gas"; end
  def i347; @i347 ||= -sheet42.o216-sheet49.o103-sheet50.o77; end
  def j347; "Industry"; end
  def h348; "Electricity grid"; end
  def i348; @i348 ||= -sheet30.o390; end
  def j348; "Agriculture"; end
  def h349; "Solid"; end
  def i349; @i349 ||= -sheet30.o391; end
  def j349; "Agriculture"; end
  def h350; "Liquid"; end
  def i350; @i350 ||= -sheet30.o392; end
  def j350; "Agriculture"; end
  def h351; "Gas"; end
  def i351; @i351 ||= -sheet30.o393; end
  def j351; "Agriculture"; end
  def h352; "Electricity grid"; end
  def i352; @i352 ||= -sheet43.o344-sheet44.o145; end
  def j352; "Road transport"; end
  def h353; "Liquid"; end
  def i353; @i353 ||= -sheet43.o343-sheet44.o146; end
  def j353; "Road transport"; end
  def h354; "Electricity grid"; end
  def i354; @i354 ||= -sheet43.o353-sheet44.o153; end
  def j354; "Rail transport"; end
  def h355; "Liquid"; end
  def i355; @i355 ||= -sheet43.o352-sheet44.o154; end
  def j355; "Rail transport"; end
  def h356; "Liquid"; end
  def i356; @i356 ||= -sheet43.o361; end
  def j356; "Domestic aviation"; end
  def h357; "Liquid"; end
  def i357; @i357 ||= -sheet44.o161; end
  def j357; "National navigation"; end
  def h358; "Liquid"; end
  def i358; @i358 ||= -sheet45.o62; end
  def j358; "International aviation"; end
  def h359; "Liquid"; end
  def i359; @i359 ||= -sheet46.o61; end
  def j359; "International shipping"; end
  def h360; "Electricity grid"; end
  def i360; @i360 ||= -sheet48.o71; end
  def j360; "Geosequestration"; end
  def h361; "Gas"; end
  def i361; @i361 ||= sheet51.o64; end
  def j361; "Losses"; end
  def _xlnm__filter_database; sheet7.a('h270','h452'); end
  def _xlnm_extract; sheet7.n270; end
end