# coding: utf-8 # X.b class Sheet41 < Spreadsheet def e8; @e8 ||= sheet3.z48; end def e9; @e9 ||= min(sheet3.z49,2.0); end def c17; 1.0; end def f17; 59.15675387354639; end def g17; 59.56715455067834; end def h17; 61.66528878761917; end def i17; 63.842581337154726; end def j17; 66.10223935453223; end def k17; 68.44760864967166; end def l17; 70.88218000447945; end def m17; 73.40959578929251; end def n17; 76.03365689299055; end def o17; 78.7583299820375; end def c18; 2.0; end def f18; 59.15675387354639; end def g18; 59.326035085761674; end def h18; 60.19760945876334; end def i18; 61.11246277563778; end def j18; 62.07248961327111; end def k18; 63.15121661376528; end def l18; 64.49562657424639; end def m18; 65.97248871574666; end def n18; 67.51330994716889; end def o18; 69.1212814500725; end def c19; 3.0; end def f19; 59.15675387354639; end def g19; 58.904714666052776; end def h19; 57.73902956818028; end def i19; 56.72483426309306; end def j19; 55.854812205070836; end def k19; 55.232950156787226; end def l19; 55.04655623204945; end def m19; 55.06525589478417; end def n19; 55.18024710347611; end def o19; 55.39318298923445; end def c20; 4.0; end def f20; 59.15675387354639; end def g20; 58.39411997376584; end def h20; 54.88029507107723; end def i20; 51.83167050493889; end def j20; 49.206442584387496; end def k20; 46.96753939301528; end def l20; 45.082118257987226; end def m20; 43.521121219303055; end def n20; 42.258881702626674; end def o20; 41.2727764299025; end def c25; 1.0; end def f25; 22.46354201025536; end def g25; 22.467643897866445; end def h25; 22.488164573850696; end def i25; 22.508703992260504; end def j25; 22.529262170214086; end def k25; 22.54983912484542; end def l25; 22.570434873304; end def m25; 22.591049432755113; end def n25; 22.611682820379585; end def o25; 22.632335053374057; end def c26; 2.0; end def f26; 22.46354201025536; end def g26; 22.423701550102166; end def h26; 22.225556638535032; end def i26; 22.029162615682306; end def j26; 21.834504009982002; end def k26; 21.641565486585087; end def l26; 21.45033184614739; end def m26; 21.260788023632447; end def n26; 21.072919087124472; end def o26; 20.886710236652114; end def c27; 3.0; end def f27; 22.46354201025536; end def g27; 22.185694710532168; end def h27; 20.847165526245945; end def i27; 19.58939380304275; end def j27; 18.407507202241334; end def k27; 17.51354912241514; end def l27; 17.51354912241514; end def m27; 17.51354912241514; end def n27; 17.51354912241514; end def o27; 17.51354912241514; end def c28; 4.0; end def f28; 22.46354201025536; end def g28; 22.306475199363472; end def h28; 21.537461718864947; end def i28; 20.79495990046914; end def j28; 20.078055757301637; end def k28; 19.38586681209317; end def l28; 18.717541010889306; end def m28; 18.07225567420964; end def n28; 17.449216484365806; end def o28; 16.84765650769153; end def g32; "V.01"; end def h32; "V.05"; end def c33; 1.0; end def g33; 0.6; end def h33; 0.4; end def c34; 2.0; end def g34; 1.0; end def h34; 0.0; end def f55; 2007.0; end def g55; 2010.0; end def h55; 2015.0; end def i55; 2020.0; end def j55; 2025.0; end def k55; 2030.0; end def l55; 2035.0; end def m55; 2040.0; end def n55; 2045.0; end def o55; 2050.0; end def c56; "V.01"; end def f56; 0.6; end def g56; @g56 ||= f56+(o56-f56)/(o55-f55)*(g55-f55); end def h56; @h56 ||= f56+(o56-f56)/(o55-f55)*(h55-f55); end def i56; @i56 ||= f56+(o56-f56)/(o55-f55)*(i55-f55); end def j56; @j56 ||= f56+(o56-f56)/(o55-f55)*(j55-f55); end def k56; @k56 ||= f56+(o56-f56)/(o55-f55)*(k55-f55); end def l56; @l56 ||= f56+(o56-f56)/(o55-f55)*(l55-f55); end def m56; @m56 ||= f56+(o56-f56)/(o55-f55)*(m55-f55); end def n56; @n56 ||= f56+(o56-f56)/(o55-f55)*(n55-f55); end def o56; @o56 ||= index(a('g33','h34'),match(e9,a('c33','c34'),0.0),1.0); end def c57; "V.05"; end def f57; 0.4; end def g57; @g57 ||= f57+(o57-f57)/(o55-f55)*(g55-f55); end def h57; @h57 ||= f57+(o57-f57)/(o55-f55)*(h55-f55); end def i57; @i57 ||= f57+(o57-f57)/(o55-f55)*(i55-f55); end def j57; @j57 ||= f57+(o57-f57)/(o55-f55)*(j55-f55); end def k57; @k57 ||= f57+(o57-f57)/(o55-f55)*(k55-f55); end def l57; @l57 ||= f57+(o57-f57)/(o55-f55)*(l55-f55); end def m57; @m57 ||= f57+(o57-f57)/(o55-f55)*(m55-f55); end def n57; @n57 ||= f57+(o57-f57)/(o55-f55)*(n55-f55); end def o57; @o57 ||= index(a('g33','h34'),match(e9,a('c33','c34'),0.0),2.0); end def f63; @f63 ||= index(a('f25','f28'),match(e8,a('c25','c28'),0.0)); end def g63; @g63 ||= index(a('g25','g28'),match(e8,a('c25','c28'),0.0)); end def h63; @h63 ||= index(a('h25','h28'),match(e8,a('c25','c28'),0.0)); end def i63; @i63 ||= index(a('i25','i28'),match(e8,a('c25','c28'),0.0)); end def j63; @j63 ||= index(a('j25','j28'),match(e8,a('c25','c28'),0.0)); end def k63; @k63 ||= index(a('k25','k28'),match(e8,a('c25','c28'),0.0)); end def l63; @l63 ||= index(a('l25','l28'),match(e8,a('c25','c28'),0.0)); end def m63; @m63 ||= index(a('m25','m28'),match(e8,a('c25','c28'),0.0)); end def n63; @n63 ||= index(a('n25','n28'),match(e8,a('c25','c28'),0.0)); end def o63; @o63 ||= index(a('o25','o28'),match(e8,a('c25','c28'),0.0)); end def f64; @f64 ||= f63*f56; end def g64; @g64 ||= g63*g56; end def h64; @h64 ||= h63*h56; end def i64; @i64 ||= i63*i56; end def j64; @j64 ||= j63*j56; end def k64; @k64 ||= k63*k56; end def l64; @l64 ||= l63*l56; end def m64; @m64 ||= m63*m56; end def n64; @n64 ||= n63*n56; end def o64; @o64 ||= o63*o56; end def f65; @f65 ||= f63*f57; end def g65; @g65 ||= g63*g57; end def h65; @h65 ||= h63*h57; end def i65; @i65 ||= i63*i57; end def j65; @j65 ||= j63*j57; end def k65; @k65 ||= k63*k57; end def l65; @l65 ||= l63*l57; end def m65; @m65 ||= m63*m57; end def n65; @n65 ||= n63*n57; end def o65; @o65 ||= o63*o57; end def f70; @f70 ||= index(a('f17','f20'),match(e8,a('c17','c20'),0.0)); end def g70; @g70 ||= index(a('g17','g20'),match(e8,a('c17','c20'),0.0)); end def h70; @h70 ||= index(a('h17','h20'),match(e8,a('c17','c20'),0.0)); end def i70; @i70 ||= index(a('i17','i20'),match(e8,a('c17','c20'),0.0)); end def j70; @j70 ||= index(a('j17','j20'),match(e8,a('c17','c20'),0.0)); end def k70; @k70 ||= index(a('k17','k20'),match(e8,a('c17','c20'),0.0)); end def l70; @l70 ||= index(a('l17','l20'),match(e8,a('c17','c20'),0.0)); end def m70; @m70 ||= index(a('m17','m20'),match(e8,a('c17','c20'),0.0)); end def n70; @n70 ||= index(a('n17','n20'),match(e8,a('c17','c20'),0.0)); end def o70; @o70 ||= index(a('o17','o20'),match(e8,a('c17','c20'),0.0)); end def f71; @f71 ||= f70; end def g71; @g71 ||= g70; end def h71; @h71 ||= h70; end def i71; @i71 ||= i70; end def j71; @j71 ||= j70; end def k71; @k71 ||= k70; end def l71; @l71 ||= l70; end def m71; @m71 ||= m70; end def n71; @n71 ||= n70; end def o71; @o71 ||= o70; end def b75; "V.01"; end def f75; @f75 ||= f64+f71; end def g75; @g75 ||= g64+g71; end def h75; @h75 ||= h64+h71; end def i75; @i75 ||= i64+i71; end def j75; @j75 ||= j64+j71; end def k75; @k75 ||= k64+k71; end def l75; @l75 ||= l64+l71; end def m75; @m75 ||= m64+m71; end def n75; @n75 ||= n64+n71; end def o75; @o75 ||= o64+o71; end def b76; "V.05"; end def f76; @f76 ||= f65; end def g76; @g76 ||= g65; end def h76; @h76 ||= h65; end def i76; @i76 ||= i65; end def j76; @j76 ||= j65; end def k76; @k76 ||= k65; end def l76; @l76 ||= l65; end def m76; @m76 ||= m65; end def n76; @n76 ||= n65; end def o76; @o76 ||= o65; end def f80; @f80 ||= sum(m(a('f75','f76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g80; @g80 ||= sum(m(a('g75','g76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h80; @h80 ||= sum(m(a('h75','h76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i80; @i80 ||= sum(m(a('i75','i76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j80; @j80 ||= sum(m(a('j75','j76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k80; @k80 ||= sum(m(a('k75','k76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l80; @l80 ||= sum(m(a('l75','l76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m80; @m80 ||= sum(m(a('m75','m76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n80; @n80 ||= sum(m(a('n75','n76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o80; @o80 ||= sum(m(a('o75','o76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def f81; @f81 ||= sum(m(a('f75','f76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g81; @g81 ||= sum(m(a('g75','g76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h81; @h81 ||= sum(m(a('h75','h76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i81; @i81 ||= sum(m(a('i75','i76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j81; @j81 ||= sum(m(a('j75','j76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k81; @k81 ||= sum(m(a('k75','k76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l81; @l81 ||= sum(m(a('l75','l76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m81; @m81 ||= sum(m(a('m75','m76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n81; @n81 ||= sum(m(a('n75','n76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o81; @o81 ||= sum(m(a('o75','o76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('e5','e50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def f82; @f82 ||= sum(m(a('f75','f76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g82; @g82 ||= sum(m(a('g75','g76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h82; @h82 ||= sum(m(a('h75','h76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i82; @i82 ||= sum(m(a('i75','i76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j82; @j82 ||= sum(m(a('j75','j76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k82; @k82 ||= sum(m(a('k75','k76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l82; @l82 ||= sum(m(a('l75','l76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m82; @m82 ||= sum(m(a('m75','m76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n82; @n82 ||= sum(m(a('n75','n76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o82; @o82 ||= sum(m(a('o75','o76'),m(a('b75','b76')) { |r1| sumifs(sheet12.a('f5','f50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def c90; "L.01"; end def f90; @f90 ||= f75+f76; end def g90; @g90 ||= g75+g76; end def h90; @h90 ||= h75+h76; end def i90; @i90 ||= i75+i76; end def j90; @j90 ||= j75+j76; end def k90; @k90 ||= k75+k76; end def l90; @l90 ||= l75+l76; end def m90; @m90 ||= m75+m76; end def n90; @n90 ||= n75+n76; end def o90; @o90 ||= o75+o76; end def c91; "V.01"; end def f91; @f91 ||= -f75; end def g91; @g91 ||= -g75; end def h91; @h91 ||= -h75; end def i91; @i91 ||= -i75; end def j91; @j91 ||= -j75; end def k91; @k91 ||= -k75; end def l91; @l91 ||= -l75; end def m91; @m91 ||= -m75; end def n91; @n91 ||= -n75; end def o91; @o91 ||= -o75; end def c92; "V.05"; end def f92; @f92 ||= -f76; end def g92; @g92 ||= -g76; end def h92; @h92 ||= -h76; end def i92; @i92 ||= -i76; end def j92; @j92 ||= -j76; end def k92; @k92 ||= -k76; end def l92; @l92 ||= -l76; end def m92; @m92 ||= -m76; end def n92; @n92 ||= -n76; end def o92; @o92 ||= -o76; end def c101; "CO2"; end def d101; "1A"; end def f101; @f101 ||= f80; end def g101; @g101 ||= g80; end def h101; @h101 ||= h80; end def i101; @i101 ||= i80; end def j101; @j101 ||= j80; end def k101; @k101 ||= k80; end def l101; @l101 ||= l80; end def m101; @m101 ||= m80; end def n101; @n101 ||= n80; end def o101; @o101 ||= o80; end def c102; "CH4"; end def d102; "1A"; end def f102; @f102 ||= f81; end def g102; @g102 ||= g81; end def h102; @h102 ||= h81; end def i102; @i102 ||= i81; end def j102; @j102 ||= j81; end def k102; @k102 ||= k81; end def l102; @l102 ||= l81; end def m102; @m102 ||= m81; end def n102; @n102 ||= n81; end def o102; @o102 ||= o81; end def c103; "N2O"; end def d103; "1A"; end def f103; @f103 ||= f82; end def g103; @g103 ||= g82; end def h103; @h103 ||= h82; end def i103; @i103 ||= i82; end def j103; @j103 ||= j82; end def k103; @k103 ||= k82; end def l103; @l103 ||= l82; end def m103; @m103 ||= m82; end def n103; @n103 ||= n82; end def o103; @o103 ||= o82; end end