# coding: utf-8 # V.b class Sheet29 < Spreadsheet def a2; "V.b"; end def e7; @e7 ||= sheet3.z23; 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(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),15.0); end def g15; @g15 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),15.0); end def h15; @h15 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),15.0); end def i15; @i15 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),15.0); end def j15; @j15 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),15.0); end def k15; @k15 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),15.0); end def l15; @l15 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),15.0); end def m15; @m15 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),15.0); end def n15; @n15 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),15.0); end def o15; @o15 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),15.0); end def c16; "V.04"; end def f16; @f16 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),16.0); end def g16; @g16 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),16.0); end def h16; @h16 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),16.0); end def i16; @i16 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),16.0); end def j16; @j16 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),16.0); end def k16; @k16 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),16.0); end def l16; @l16 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),16.0); end def m16; @m16 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),16.0); end def n16; @n16 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),16.0); end def o16; @o16 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),16.0); end def c17; "V.05"; end def f17; @f17 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),17.0); end def g17; @g17 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),17.0); end def h17; @h17 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),17.0); end def i17; @i17 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),17.0); end def j17; @j17 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),17.0); end def k17; @k17 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),17.0); end def l17; @l17 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),17.0); end def m17; @m17 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),17.0); end def n17; @n17 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),17.0); end def o17; @o17 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),17.0); end def c25; 1.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 c26; 2.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 c27; 3.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 c28; 4.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 c33; 1.0; end def f33; -0.39542; end def g33; -0.36783255813953486; end def h33; -0.32185348837209304; end def i33; -0.2758744186046512; end def j33; -0.2298953488372093; end def k33; -0.18391627906976743; end def l33; -0.13793720930232556; end def m33; -0.09195813953488369; end def n33; -0.04597906976744187; end def o33; 0.0; end def c34; 2.0; end def f34; -0.39542; end def g34; 2.0740279069767444; end def h34; 6.189774418604652; end def i34; 10.305520930232559; end def j34; 14.421267441860467; end def k34; 18.537013953488373; end def l34; 22.65276046511628; end def m34; 26.768506976744188; end def n34; 30.884253488372096; end def o34; 35.0; end def c35; 3.0; end def f35; -0.39542; end def g35; 4.515888372093023; end def h35; 12.701402325581396; end def i35; 20.886916279069766; end def j35; 29.07243023255814; end def k35; 37.257944186046515; end def l35; 45.44345813953488; end def m35; 53.62897209302326; end def n35; 61.81448604651163; end def o35; 70.0; end def c36; 4.0; end def f36; -0.39542; end def g36; 9.399609302325581; end def h36; 25.72465813953488; end def i36; 42.04970697674418; end def j36; 58.374755813953485; end def k36; 74.6998046511628; end def l36; 91.02485348837209; end def m36; 107.34990232558138; end def n36; 123.67495116279069; end def o36; 140.0; end def f41; 0.0006000000000000001; end def f54; @f54 ||= index(a('f25','f28'),match(e7,a('c25','c28'),0.0)); end def g54; @g54 ||= index(a('g25','g28'),match(e7,a('c25','c28'),0.0)); end def h54; @h54 ||= index(a('h25','h28'),match(e7,a('c25','c28'),0.0)); end def i54; @i54 ||= index(a('i25','i28'),match(e7,a('c25','c28'),0.0)); end def j54; @j54 ||= index(a('j25','j28'),match(e7,a('c25','c28'),0.0)); end def k54; @k54 ||= index(a('k25','k28'),match(e7,a('c25','c28'),0.0)); end def l54; @l54 ||= index(a('l25','l28'),match(e7,a('c25','c28'),0.0)); end def m54; @m54 ||= index(a('m25','m28'),match(e7,a('c25','c28'),0.0)); end def n54; @n54 ||= index(a('n25','n28'),match(e7,a('c25','c28'),0.0)); end def o54; @o54 ||= index(a('o25','o28'),match(e7,a('c25','c28'),0.0)); end def f55; @f55 ||= index(a('f33','f36'),match(e7,a('c33','c36'),0.0)); end def g55; @g55 ||= index(a('g33','g36'),match(e7,a('c33','c36'),0.0)); end def h55; @h55 ||= index(a('h33','h36'),match(e7,a('c33','c36'),0.0)); end def i55; @i55 ||= index(a('i33','i36'),match(e7,a('c33','c36'),0.0)); end def j55; @j55 ||= index(a('j33','j36'),match(e7,a('c33','c36'),0.0)); end def k55; @k55 ||= index(a('k33','k36'),match(e7,a('c33','c36'),0.0)); end def l55; @l55 ||= index(a('l33','l36'),match(e7,a('c33','c36'),0.0)); end def m55; @m55 ||= index(a('m33','m36'),match(e7,a('c33','c36'),0.0)); end def n55; @n55 ||= index(a('n33','n36'),match(e7,a('c33','c36'),0.0)); end def o55; @o55 ||= index(a('o33','o36'),match(e7,a('c33','c36'),0.0)); end def b58; "V.03"; end def f58; @f58 ||= min(f54,-f15); end def g58; @g58 ||= min(g54,-g15); end def h58; @h58 ||= min(h54,-h15); end def i58; @i58 ||= min(i54,-i15); end def j58; @j58 ||= min(j54,-j15); end def k58; @k58 ||= min(k54,-k15); end def l58; @l58 ||= min(l54,-l15); end def m58; @m58 ||= min(m54,-m15); end def n58; @n58 ||= min(n54,-n15); end def o58; @o58 ||= min(o54,-o15); end def b59; "V.04"; end def f59; @f59 ||= min(f55,-f16); end def g59; @g59 ||= min(g55,-g16); end def h59; @h59 ||= min(h55,-h16); end def i59; @i59 ||= min(i55,-i16); end def j59; @j59 ||= min(j55,-j16); end def k59; @k59 ||= min(k55,-k16); end def l59; @l59 ||= min(l55,-l16); end def m59; @m59 ||= min(m55,-m16); end def n59; @n59 ||= min(n55,-n16); end def o59; @o59 ||= min(o55,-o16); end def f60; @f60 ||= min(0.0,-f17); end def g60; @g60 ||= min(0.0,-g17); end def h60; @h60 ||= min(0.0,-h17); end def i60; @i60 ||= min(0.0,-i17); end def j60; @j60 ||= min(0.0,-j17); end def k60; @k60 ||= min(0.0,-k17); end def l60; @l60 ||= min(0.0,-l17); end def m60; @m60 ||= min(0.0,-m17); end def n60; @n60 ||= min(0.0,-n17); end def o60; @o60 ||= min(0.0,-o17); end def f62; @f62 ||= sum(m(a('f58','f59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g62; @g62 ||= sum(m(a('g58','g59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h62; @h62 ||= sum(m(a('h58','h59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i62; @i62 ||= sum(m(a('i58','i59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j62; @j62 ||= sum(m(a('j58','j59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k62; @k62 ||= sum(m(a('k58','k59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l62; @l62 ||= sum(m(a('l58','l59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m62; @m62 ||= sum(m(a('m58','m59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n62; @n62 ||= sum(m(a('n58','n59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o62; @o62 ||= sum(m(a('o58','o59'),m(a('b58','b59')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def f64; @f64 ||= sum(a('f58','f60'))*sheet9.e54/f41; end def g64; @g64 ||= sum(a('g58','g60'))*sheet9.e54/f41; end def h64; @h64 ||= sum(a('h58','h60'))*sheet9.e54/f41; end def i64; @i64 ||= sum(a('i58','i60'))*sheet9.e54/f41; end def j64; @j64 ||= sum(a('j58','j60'))*sheet9.e54/f41; end def k64; @k64 ||= sum(a('k58','k60'))*sheet9.e54/f41; end def l64; @l64 ||= sum(a('l58','l60'))*sheet9.e54/f41; end def m64; @m64 ||= sum(a('m58','m60'))*sheet9.e54/f41; end def n64; @n64 ||= sum(a('n58','n60'))*sheet9.e54/f41; end def o64; @o64 ||= sum(a('o58','o60'))*sheet9.e54/f41; end def c72; "V.03"; end def f72; @f72 ||= f58; end def g72; @g72 ||= g58; end def h72; @h72 ||= h58; end def i72; @i72 ||= i58; end def j72; @j72 ||= j58; end def k72; @k72 ||= k58; end def l72; @l72 ||= l58; end def m72; @m72 ||= m58; end def n72; @n72 ||= n58; end def o72; @o72 ||= o58; end def c73; "V.04"; end def f73; @f73 ||= f59; end def g73; @g73 ||= g59; end def h73; @h73 ||= h59; end def i73; @i73 ||= i59; end def j73; @j73 ||= j59; end def k73; @k73 ||= k59; end def l73; @l73 ||= l59; end def m73; @m73 ||= m59; end def n73; @n73 ||= n59; end def o73; @o73 ||= o59; end def c74; "V.05"; end def f74; @f74 ||= f60; end def g74; @g74 ||= g60; end def h74; @h74 ||= h60; end def i74; @i74 ||= i60; end def j74; @j74 ||= j60; end def k74; @k74 ||= k60; end def l74; @l74 ||= l60; end def m74; @m74 ||= m60; end def n74; @n74 ||= n60; end def o74; @o74 ||= o60; end def c75; "Y.01"; end def f75; @f75 ||= -(f58+f59+f60); end def g75; @g75 ||= -(g58+g59+g60); end def h75; @h75 ||= -(h58+h59+h60); end def i75; @i75 ||= -(i58+i59+i60); end def j75; @j75 ||= -(j58+j59+j60); end def k75; @k75 ||= -(k58+k59+k60); end def l75; @l75 ||= -(l58+l59+l60); end def m75; @m75 ||= -(m58+m59+m60); end def n75; @n75 ||= -(n58+n59+n60); end def o75; @o75 ||= -(o58+o59+o60); end def c84; "CO2"; end def d84; "X2"; end def f84; @f84 ||= -f62; end def g84; @g84 ||= -g62; end def h84; @h84 ||= -h62; end def i84; @i84 ||= -i62; end def j84; @j84 ||= -j62; end def k84; @k84 ||= -k62; end def l84; @l84 ||= -l62; end def m84; @m84 ||= -m62; end def n84; @n84 ||= -n62; end def o84; @o84 ||= -o62; end def c93; "B.05"; end def f93; @f93 ||= f64; end def g93; @g93 ||= g64; end def h93; @h93 ||= h64; end def i93; @i93 ||= i64; end def j93; @j93 ||= j64; end def k93; @k93 ||= k64; end def l93; @l93 ||= l64; end def m93; @m93 ||= m64; end def n93; @n93 ||= n64; end def o93; @o93 ||= o64; end end