# coding: utf-8
# V.b
class Sheet31 < Spreadsheet
  def a2; "V.b"; end
  def e7; @e7 ||= sheet5.ab25; end
  def f14; "2007"; end
  def g14; "2010"; end
  def h14; "2015"; end
  def i14; "2020"; end
  def j14; "2025"; end
  def k14; "2030"; end
  def l14; "2035"; end
  def m14; "2040"; end
  def n14; "2045"; end
  def o14; "2050"; end
  def c15; "V.03"; end
  def f15; @f15 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),15.0); end
  def g15; @g15 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),15.0); end
  def h15; @h15 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),15.0); end
  def i15; @i15 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),15.0); end
  def j15; @j15 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),15.0); end
  def k15; @k15 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),15.0); end
  def l15; @l15 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),15.0); end
  def m15; @m15 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),15.0); end
  def n15; @n15 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),15.0); end
  def o15; @o15 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),15.0); end
  def c16; "V.04"; end
  def f16; @f16 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),16.0); end
  def g16; @g16 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),16.0); end
  def h16; @h16 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),16.0); end
  def i16; @i16 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),16.0); end
  def j16; @j16 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),16.0); end
  def k16; @k16 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),16.0); end
  def l16; @l16 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),16.0); end
  def m16; @m16 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),16.0); end
  def n16; @n16 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),16.0); end
  def o16; @o16 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),16.0); end
  def c17; "V.05"; end
  def f17; @f17 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),17.0); end
  def g17; @g17 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),17.0); end
  def h17; @h17 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),17.0); end
  def i17; @i17 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),17.0); end
  def j17; @j17 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),17.0); end
  def k17; @k17 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),17.0); end
  def l17; @l17 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),17.0); end
  def m17; @m17 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),17.0); end
  def n17; @n17 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),17.0); end
  def o17; @o17 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),17.0); end
  def f25; 4.39614; end
  def g25; 4.089432558139535; end
  def h25; 3.578253488372093; end
  def i25; 3.0670744186046512; end
  def j25; 2.5558953488372094; end
  def k25; 2.0447162790697675; end
  def l25; 1.5335372093023256; end
  def m25; 1.0223581395348837; end
  def n25; 0.5111790697674419; end
  def o25; 0.0; end
  def f26; 4.39614; end
  def g26; 6.531293023255814; end
  def h26; 10.089881395348836; end
  def i26; 13.64846976744186; end
  def j26; 17.207058139534883; end
  def k26; 20.765646511627907; end
  def l26; 24.32423488372093; end
  def m26; 27.882823255813953; end
  def n26; 31.441411627906977; end
  def o26; 35.0; end
  def f27; 4.39614; end
  def g27; 8.973153488372093; end
  def h27; 16.60150930232558; end
  def i27; 24.22986511627907; end
  def j27; 31.858220930232555; end
  def k27; 39.486576744186046; end
  def l27; 47.114932558139536; end
  def m27; 54.743288372093026; end
  def n27; 62.37164418604651; end
  def o27; 70.0; end
  def f28; 4.39614; end
  def g28; 13.85687441860465; end
  def h28; 29.624765116279068; end
  def i28; 45.39265581395349; end
  def j28; 61.160546511627906; end
  def k28; 76.92843720930233; end
  def l28; 92.69632790697675; end
  def m28; 108.46421860465117; end
  def n28; 124.23210930232558; end
  def o28; 140.0; end
  def f29; @f29 ||= (index(a('f25','f28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('f25','f28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def g29; @g29 ||= (index(a('g25','g28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('g25','g28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def h29; @h29 ||= (index(a('h25','h28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('h25','h28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def i29; @i29 ||= (index(a('i25','i28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('i25','i28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def j29; @j29 ||= (index(a('j25','j28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('j25','j28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def k29; @k29 ||= (index(a('k25','k28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('k25','k28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def l29; @l29 ||= (index(a('l25','l28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('l25','l28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def m29; @m29 ||= (index(a('m25','m28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('m25','m28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def n29; @n29 ||= (index(a('n25','n28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('n25','n28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def o29; @o29 ||= (index(a('o25','o28'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('o25','o28'),roundup(e7,0.0))*mod(e7,1.0)); end
  def f34; -0.39542; end
  def g34; -0.36783255813953486; end
  def h34; -0.32185348837209304; end
  def i34; -0.2758744186046512; end
  def j34; -0.2298953488372093; end
  def k34; -0.18391627906976743; end
  def l34; -0.13793720930232556; end
  def m34; -0.09195813953488369; end
  def n34; -0.04597906976744187; end
  def o34; 0.0; end
  def f35; -0.39542; end
  def g35; 2.0740279069767444; end
  def h35; 6.189774418604652; end
  def i35; 10.305520930232559; end
  def j35; 14.421267441860467; end
  def k35; 18.537013953488373; end
  def l35; 22.65276046511628; end
  def m35; 26.768506976744188; end
  def n35; 30.884253488372096; end
  def o35; 35.0; end
  def f36; -0.39542; end
  def g36; 4.515888372093023; end
  def h36; 12.701402325581396; end
  def i36; 20.886916279069766; end
  def j36; 29.07243023255814; end
  def k36; 37.257944186046515; end
  def l36; 45.44345813953488; end
  def m36; 53.62897209302326; end
  def n36; 61.81448604651163; end
  def o36; 70.0; end
  def f37; -0.39542; end
  def g37; 9.399609302325581; end
  def h37; 25.72465813953488; end
  def i37; 42.04970697674418; end
  def j37; 58.374755813953485; end
  def k37; 74.6998046511628; end
  def l37; 91.02485348837209; end
  def m37; 107.34990232558138; end
  def n37; 123.67495116279069; end
  def o37; 140.0; end
  def f38; @f38 ||= (index(a('f34','f37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('f34','f37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def g38; @g38 ||= (index(a('g34','g37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('g34','g37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def h38; @h38 ||= (index(a('h34','h37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('h34','h37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def i38; @i38 ||= (index(a('i34','i37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('i34','i37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def j38; @j38 ||= (index(a('j34','j37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('j34','j37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def k38; @k38 ||= (index(a('k34','k37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('k34','k37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def l38; @l38 ||= (index(a('l34','l37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('l34','l37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def m38; @m38 ||= (index(a('m34','m37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('m34','m37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def n38; @n38 ||= (index(a('n34','n37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('n34','n37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def o38; @o38 ||= (index(a('o34','o37'),rounddown(e7,0.0))*(1.0-mod(e7,1.0)))+(index(a('o34','o37'),roundup(e7,0.0))*mod(e7,1.0)); end
  def f43; 0.0006000000000000001; end
  def f64; @f64 ||= f29; end
  def g64; @g64 ||= g29; end
  def h64; @h64 ||= h29; end
  def i64; @i64 ||= i29; end
  def j64; @j64 ||= j29; end
  def k64; @k64 ||= k29; end
  def l64; @l64 ||= l29; end
  def m64; @m64 ||= m29; end
  def n64; @n64 ||= n29; end
  def o64; @o64 ||= o29; end
  def f65; @f65 ||= f38; end
  def g65; @g65 ||= g38; end
  def h65; @h65 ||= h38; end
  def i65; @i65 ||= i38; end
  def j65; @j65 ||= j38; end
  def k65; @k65 ||= k38; end
  def l65; @l65 ||= l38; end
  def m65; @m65 ||= m38; end
  def n65; @n65 ||= n38; end
  def o65; @o65 ||= o38; end
  def f68; @f68 ||= min(f64,-f15); end
  def g68; @g68 ||= min(g64,-g15); end
  def h68; @h68 ||= min(h64,-h15); end
  def i68; @i68 ||= min(i64,-i15); end
  def j68; @j68 ||= min(j64,-j15); end
  def k68; @k68 ||= min(k64,-k15); end
  def l68; @l68 ||= min(l64,-l15); end
  def m68; @m68 ||= min(m64,-m15); end
  def n68; @n68 ||= min(n64,-n15); end
  def o68; @o68 ||= min(o64,-o15); end
  def f69; @f69 ||= min(f65,-f16); end
  def g69; @g69 ||= min(g65,-g16); end
  def h69; @h69 ||= min(h65,-h16); end
  def i69; @i69 ||= min(i65,-i16); end
  def j69; @j69 ||= min(j65,-j16); end
  def k69; @k69 ||= min(k65,-k16); end
  def l69; @l69 ||= min(l65,-l16); end
  def m69; @m69 ||= min(m65,-m16); end
  def n69; @n69 ||= min(n65,-n16); end
  def o69; @o69 ||= min(o65,-o16); end
  def f70; @f70 ||= min(0.0,-f17); end
  def g70; @g70 ||= min(0.0,-g17); end
  def h70; @h70 ||= min(0.0,-h17); end
  def i70; @i70 ||= min(0.0,-i17); end
  def j70; @j70 ||= min(0.0,-j17); end
  def k70; @k70 ||= min(0.0,-k17); end
  def l70; @l70 ||= min(0.0,-l17); end
  def m70; @m70 ||= min(0.0,-m17); end
  def n70; @n70 ||= min(0.0,-n17); end
  def o70; @o70 ||= min(0.0,-o17); end
  def b73; "V.03"; end
  def f73; @f73 ||= excel_if((min(f68,-f15)>0.0),min(f68,-f15),0.0); end
  def g73; @g73 ||= excel_if((min(g68,-g15)>0.0),min(g68,-g15),0.0); end
  def h73; @h73 ||= excel_if((min(h68,-h15)>0.0),min(h68,-h15),0.0); end
  def i73; @i73 ||= excel_if((min(i68,-i15)>0.0),min(i68,-i15),0.0); end
  def j73; @j73 ||= excel_if((min(j68,-j15)>0.0),min(j68,-j15),0.0); end
  def k73; @k73 ||= excel_if((min(k68,-k15)>0.0),min(k68,-k15),0.0); end
  def l73; @l73 ||= excel_if((min(l68,-l15)>0.0),min(l68,-l15),0.0); end
  def m73; @m73 ||= excel_if((min(m68,-m15)>0.0),min(m68,-m15),0.0); end
  def n73; @n73 ||= excel_if((min(n68,-n15)>0.0),min(n68,-n15),0.0); end
  def o73; @o73 ||= excel_if((min(o68,-o15)>0.0),min(o68,-o15),0.0); end
  def b74; "V.04"; end
  def f74; @f74 ||= excel_if((min(f69,-f16)>0.0),min(f69,-f16),0.0); end
  def g74; @g74 ||= excel_if((min(g69,-g16)>0.0),min(g69,-g16),0.0); end
  def h74; @h74 ||= excel_if((min(h69,-h16)>0.0),min(h69,-h16),0.0); end
  def i74; @i74 ||= excel_if((min(i69,-i16)>0.0),min(i69,-i16),0.0); end
  def j74; @j74 ||= excel_if((min(j69,-j16)>0.0),min(j69,-j16),0.0); end
  def k74; @k74 ||= excel_if((min(k69,-k16)>0.0),min(k69,-k16),0.0); end
  def l74; @l74 ||= excel_if((min(l69,-l16)>0.0),min(l69,-l16),0.0); end
  def m74; @m74 ||= excel_if((min(m69,-m16)>0.0),min(m69,-m16),0.0); end
  def n74; @n74 ||= excel_if((min(n69,-n16)>0.0),min(n69,-n16),0.0); end
  def o74; @o74 ||= excel_if((min(o69,-o16)>0.0),min(o69,-o16),0.0); end
  def f77; @f77 ||= sum(m(a('f73','f74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def g77; @g77 ||= sum(m(a('g73','g74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def h77; @h77 ||= sum(m(a('h73','h74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def i77; @i77 ||= sum(m(a('i73','i74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def j77; @j77 ||= sum(m(a('j73','j74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def k77; @k77 ||= sum(m(a('k73','k74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def l77; @l77 ||= sum(m(a('l73','l74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def m77; @m77 ||= sum(m(a('m73','m74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def n77; @n77 ||= sum(m(a('n73','n74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def o77; @o77 ||= sum(m(a('o73','o74'),m(a('b73','b74')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end
  def f79; @f79 ||= sum(a('f68','f70'))*sheet11.e58/f43; end
  def g79; @g79 ||= sum(a('g68','g70'))*sheet11.e58/f43; end
  def h79; @h79 ||= sum(a('h68','h70'))*sheet11.e58/f43; end
  def i79; @i79 ||= sum(a('i68','i70'))*sheet11.e58/f43; end
  def j79; @j79 ||= sum(a('j68','j70'))*sheet11.e58/f43; end
  def k79; @k79 ||= sum(a('k68','k70'))*sheet11.e58/f43; end
  def l79; @l79 ||= sum(a('l68','l70'))*sheet11.e58/f43; end
  def m79; @m79 ||= sum(a('m68','m70'))*sheet11.e58/f43; end
  def n79; @n79 ||= sum(a('n68','n70'))*sheet11.e58/f43; end
  def o79; @o79 ||= sum(a('o68','o70'))*sheet11.e58/f43; end
  def c98; "V.03"; end
  def f98; @f98 ||= f68; end
  def g98; @g98 ||= g68; end
  def h98; @h98 ||= h68; end
  def i98; @i98 ||= i68; end
  def j98; @j98 ||= j68; end
  def k98; @k98 ||= k68; end
  def l98; @l98 ||= l68; end
  def m98; @m98 ||= m68; end
  def n98; @n98 ||= n68; end
  def o98; @o98 ||= o68; end
  def c99; "V.04"; end
  def f99; @f99 ||= f69; end
  def g99; @g99 ||= g69; end
  def h99; @h99 ||= h69; end
  def i99; @i99 ||= i69; end
  def j99; @j99 ||= j69; end
  def k99; @k99 ||= k69; end
  def l99; @l99 ||= l69; end
  def m99; @m99 ||= m69; end
  def n99; @n99 ||= n69; end
  def o99; @o99 ||= o69; end
  def c100; "V.05"; end
  def f100; @f100 ||= f70; end
  def g100; @g100 ||= g70; end
  def h100; @h100 ||= h70; end
  def i100; @i100 ||= i70; end
  def j100; @j100 ||= j70; end
  def k100; @k100 ||= k70; end
  def l100; @l100 ||= l70; end
  def m100; @m100 ||= m70; end
  def n100; @n100 ||= n70; end
  def o100; @o100 ||= o70; end
  def c101; "Y.01"; end
  def f101; @f101 ||= -(f68+f69+f70); end
  def g101; @g101 ||= -(g68+g69+g70); end
  def h101; @h101 ||= -(h68+h69+h70); end
  def i101; @i101 ||= -(i68+i69+i70); end
  def j101; @j101 ||= -(j68+j69+j70); end
  def k101; @k101 ||= -(k68+k69+k70); end
  def l101; @l101 ||= -(l68+l69+l70); end
  def m101; @m101 ||= -(m68+m69+m70); end
  def n101; @n101 ||= -(n68+n69+n70); end
  def o101; @o101 ||= -(o68+o69+o70); end
  def c110; "CO2"; end
  def d110; "X2"; end
  def f110; @f110 ||= -f77; end
  def g110; @g110 ||= -g77; end
  def h110; @h110 ||= -h77; end
  def i110; @i110 ||= -i77; end
  def j110; @j110 ||= -j77; end
  def k110; @k110 ||= -k77; end
  def l110; @l110 ||= -l77; end
  def m110; @m110 ||= -m77; end
  def n110; @n110 ||= -n77; end
  def o110; @o110 ||= -o77; end
  def c119; "B.05"; end
  def f119; @f119 ||= f79; end
  def g119; @g119 ||= g79; end
  def h119; @h119 ||= h79; end
  def i119; @i119 ||= i79; end
  def j119; @j119 ||= j79; end
  def k119; @k119 ||= k79; end
  def l119; @l119 ||= l79; end
  def m119; @m119 ||= m79; end
  def n119; @n119 ||= n79; end
  def o119; @o119 ||= o79; end
end