# coding: utf-8 # X.b class Sheet42 < Spreadsheet def e8; @e8 ||= sheet5.ab49; end def e9; @e9 ||= min(sheet5.ab50,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 f73; 2007.0; end def g73; 2010.0; end def h73; 2015.0; end def i73; 2020.0; end def j73; 2025.0; end def k73; 2030.0; end def l73; 2035.0; end def m73; 2040.0; end def n73; 2045.0; end def o73; 2050.0; end def c74; "V.01"; end def f74; 0.6; end def g74; @g74 ||= f74+(o74-f74)/(o73-f73)*(g73-f73); end def h74; @h74 ||= f74+(o74-f74)/(o73-f73)*(h73-f73); end def i74; @i74 ||= f74+(o74-f74)/(o73-f73)*(i73-f73); end def j74; @j74 ||= f74+(o74-f74)/(o73-f73)*(j73-f73); end def k74; @k74 ||= f74+(o74-f74)/(o73-f73)*(k73-f73); end def l74; @l74 ||= f74+(o74-f74)/(o73-f73)*(l73-f73); end def m74; @m74 ||= f74+(o74-f74)/(o73-f73)*(m73-f73); end def n74; @n74 ||= f74+(o74-f74)/(o73-f73)*(n73-f73); end def o74; @o74 ||= index(a('g33','h34'),match(e9,a('c33','c34'),0.0),1.0); end def c75; "V.05"; end def f75; 0.4; end def g75; @g75 ||= f75+(o75-f75)/(o73-f73)*(g73-f73); end def h75; @h75 ||= f75+(o75-f75)/(o73-f73)*(h73-f73); end def i75; @i75 ||= f75+(o75-f75)/(o73-f73)*(i73-f73); end def j75; @j75 ||= f75+(o75-f75)/(o73-f73)*(j73-f73); end def k75; @k75 ||= f75+(o75-f75)/(o73-f73)*(k73-f73); end def l75; @l75 ||= f75+(o75-f75)/(o73-f73)*(l73-f73); end def m75; @m75 ||= f75+(o75-f75)/(o73-f73)*(m73-f73); end def n75; @n75 ||= f75+(o75-f75)/(o73-f73)*(n73-f73); end def o75; @o75 ||= index(a('g33','h34'),match(e9,a('c33','c34'),0.0),2.0); end def f81; @f81 ||= index(a('f25','f28'),match(e8,a('c25','c28'),0.0)); end def g81; @g81 ||= index(a('g25','g28'),match(e8,a('c25','c28'),0.0)); end def h81; @h81 ||= index(a('h25','h28'),match(e8,a('c25','c28'),0.0)); end def i81; @i81 ||= index(a('i25','i28'),match(e8,a('c25','c28'),0.0)); end def j81; @j81 ||= index(a('j25','j28'),match(e8,a('c25','c28'),0.0)); end def k81; @k81 ||= index(a('k25','k28'),match(e8,a('c25','c28'),0.0)); end def l81; @l81 ||= index(a('l25','l28'),match(e8,a('c25','c28'),0.0)); end def m81; @m81 ||= index(a('m25','m28'),match(e8,a('c25','c28'),0.0)); end def n81; @n81 ||= index(a('n25','n28'),match(e8,a('c25','c28'),0.0)); end def o81; @o81 ||= index(a('o25','o28'),match(e8,a('c25','c28'),0.0)); end def f82; @f82 ||= f81*f74; end def g82; @g82 ||= g81*g74; end def h82; @h82 ||= h81*h74; end def i82; @i82 ||= i81*i74; end def j82; @j82 ||= j81*j74; end def k82; @k82 ||= k81*k74; end def l82; @l82 ||= l81*l74; end def m82; @m82 ||= m81*m74; end def n82; @n82 ||= n81*n74; end def o82; @o82 ||= o81*o74; end def f83; @f83 ||= f81*f75; end def g83; @g83 ||= g81*g75; end def h83; @h83 ||= h81*h75; end def i83; @i83 ||= i81*i75; end def j83; @j83 ||= j81*j75; end def k83; @k83 ||= k81*k75; end def l83; @l83 ||= l81*l75; end def m83; @m83 ||= m81*m75; end def n83; @n83 ||= n81*n75; end def o83; @o83 ||= o81*o75; end def f88; @f88 ||= index(a('f17','f20'),match(e8,a('c17','c20'),0.0)); end def g88; @g88 ||= index(a('g17','g20'),match(e8,a('c17','c20'),0.0)); end def h88; @h88 ||= index(a('h17','h20'),match(e8,a('c17','c20'),0.0)); end def i88; @i88 ||= index(a('i17','i20'),match(e8,a('c17','c20'),0.0)); end def j88; @j88 ||= index(a('j17','j20'),match(e8,a('c17','c20'),0.0)); end def k88; @k88 ||= index(a('k17','k20'),match(e8,a('c17','c20'),0.0)); end def l88; @l88 ||= index(a('l17','l20'),match(e8,a('c17','c20'),0.0)); end def m88; @m88 ||= index(a('m17','m20'),match(e8,a('c17','c20'),0.0)); end def n88; @n88 ||= index(a('n17','n20'),match(e8,a('c17','c20'),0.0)); end def o88; @o88 ||= index(a('o17','o20'),match(e8,a('c17','c20'),0.0)); end def f89; @f89 ||= f88; end def g89; @g89 ||= g88; end def h89; @h89 ||= h88; end def i89; @i89 ||= i88; end def j89; @j89 ||= j88; end def k89; @k89 ||= k88; end def l89; @l89 ||= l88; end def m89; @m89 ||= m88; end def n89; @n89 ||= n88; end def o89; @o89 ||= o88; end def b93; "V.01"; end def f93; @f93 ||= f82+f89; end def g93; @g93 ||= g82+g89; end def h93; @h93 ||= h82+h89; end def i93; @i93 ||= i82+i89; end def j93; @j93 ||= j82+j89; end def k93; @k93 ||= k82+k89; end def l93; @l93 ||= l82+l89; end def m93; @m93 ||= m82+m89; end def n93; @n93 ||= n82+n89; end def o93; @o93 ||= o82+o89; end def b94; "V.05"; end def f94; @f94 ||= f83; end def g94; @g94 ||= g83; end def h94; @h94 ||= h83; end def i94; @i94 ||= i83; end def j94; @j94 ||= j83; end def k94; @k94 ||= k83; end def l94; @l94 ||= l83; end def m94; @m94 ||= m83; end def n94; @n94 ||= n83; end def o94; @o94 ||= o83; end def f98; @f98 ||= sum(m(a('f93','f94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g98; @g98 ||= sum(m(a('g93','g94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h98; @h98 ||= sum(m(a('h93','h94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i98; @i98 ||= sum(m(a('i93','i94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j98; @j98 ||= sum(m(a('j93','j94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k98; @k98 ||= sum(m(a('k93','k94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l98; @l98 ||= sum(m(a('l93','l94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m98; @m98 ||= sum(m(a('m93','m94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n98; @n98 ||= sum(m(a('n93','n94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o98; @o98 ||= sum(m(a('o93','o94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def f99; @f99 ||= sum(m(a('f93','f94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g99; @g99 ||= sum(m(a('g93','g94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h99; @h99 ||= sum(m(a('h93','h94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i99; @i99 ||= sum(m(a('i93','i94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j99; @j99 ||= sum(m(a('j93','j94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k99; @k99 ||= sum(m(a('k93','k94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l99; @l99 ||= sum(m(a('l93','l94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m99; @m99 ||= sum(m(a('m93','m94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n99; @n99 ||= sum(m(a('n93','n94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o99; @o99 ||= sum(m(a('o93','o94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('e5','e50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def f100; @f100 ||= sum(m(a('f93','f94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g100; @g100 ||= sum(m(a('g93','g94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h100; @h100 ||= sum(m(a('h93','h94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i100; @i100 ||= sum(m(a('i93','i94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j100; @j100 ||= sum(m(a('j93','j94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k100; @k100 ||= sum(m(a('k93','k94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l100; @l100 ||= sum(m(a('l93','l94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m100; @m100 ||= sum(m(a('m93','m94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n100; @n100 ||= sum(m(a('n93','n94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o100; @o100 ||= sum(m(a('o93','o94'),m(a('b93','b94')) { |r1| sumifs(sheet14.a('f5','f50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def c128; "L.01"; end def f128; @f128 ||= f93+f94; end def g128; @g128 ||= g93+g94; end def h128; @h128 ||= h93+h94; end def i128; @i128 ||= i93+i94; end def j128; @j128 ||= j93+j94; end def k128; @k128 ||= k93+k94; end def l128; @l128 ||= l93+l94; end def m128; @m128 ||= m93+m94; end def n128; @n128 ||= n93+n94; end def o128; @o128 ||= o93+o94; end def c129; "V.01"; end def f129; @f129 ||= -f93; end def g129; @g129 ||= -g93; end def h129; @h129 ||= -h93; end def i129; @i129 ||= -i93; end def j129; @j129 ||= -j93; end def k129; @k129 ||= -k93; end def l129; @l129 ||= -l93; end def m129; @m129 ||= -m93; end def n129; @n129 ||= -n93; end def o129; @o129 ||= -o93; end def c130; "V.05"; end def f130; @f130 ||= -f94; end def g130; @g130 ||= -g94; end def h130; @h130 ||= -h94; end def i130; @i130 ||= -i94; end def j130; @j130 ||= -j94; end def k130; @k130 ||= -k94; end def l130; @l130 ||= -l94; end def m130; @m130 ||= -m94; end def n130; @n130 ||= -n94; end def o130; @o130 ||= -o94; end def c139; "CO2"; end def d139; "1A"; end def f139; @f139 ||= f98; end def g139; @g139 ||= g98; end def h139; @h139 ||= h98; end def i139; @i139 ||= i98; end def j139; @j139 ||= j98; end def k139; @k139 ||= k98; end def l139; @l139 ||= l98; end def m139; @m139 ||= m98; end def n139; @n139 ||= n98; end def o139; @o139 ||= o98; end def c140; "CH4"; end def d140; "1A"; end def f140; @f140 ||= f99; end def g140; @g140 ||= g99; end def h140; @h140 ||= h99; end def i140; @i140 ||= i99; end def j140; @j140 ||= j99; end def k140; @k140 ||= k99; end def l140; @l140 ||= l99; end def m140; @m140 ||= m99; end def n140; @n140 ||= n99; end def o140; @o140 ||= o99; end def c141; "N2O"; end def d141; "1A"; end def f141; @f141 ||= f100; end def g141; @g141 ||= g100; end def h141; @h141 ||= h100; end def i141; @i141 ||= i100; end def j141; @j141 ||= j100; end def k141; @k141 ||= k100; end def l141; @l141 ||= l100; end def m141; @m141 ||= m100; end def n141; @n141 ||= n100; end def o141; @o141 ||= o100; end end