# coding: utf-8 # V.a class Sheet30 < Spreadsheet def a2; "V.a"; end def e7; @e7 ||= sheet5.ab24; 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.09"; end def f15; @f15 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),26.0); end def g15; @g15 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),26.0); end def h15; @h15 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),26.0); end def i15; @i15 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),26.0); end def j15; @j15 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),26.0); end def k15; @k15 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),26.0); end def l15; @l15 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),26.0); end def m15; @m15 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),26.0); end def n15; @n15 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),26.0); end def o15; @o15 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),26.0); end def c16; "V.10"; end def f16; @f16 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),27.0); end def g16; @g16 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),27.0); end def h16; @h16 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),27.0); end def i16; @i16 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),27.0); end def j16; @j16 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),27.0); end def k16; @k16 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),27.0); end def l16; @l16 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),27.0); end def m16; @m16 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),27.0); end def n16; @n16 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),27.0); end def o16; @o16 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),27.0); end def c17; "V.15"; end def f17; @f17 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),28.0); end def g17; @g17 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),28.0); end def h17; @h17 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),28.0); end def i17; @i17 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),28.0); end def j17; @j17 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),28.0); end def k17; @k17 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),28.0); end def l17; @l17 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),28.0); end def m17; @m17 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),28.0); end def n17; @n17 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),28.0); end def o17; @o17 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),28.0); end def c18; "V.13"; end def f18; @f18 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),24.0); end def g18; @g18 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),24.0); end def h18; @h18 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),24.0); end def i18; @i18 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),24.0); end def j18; @j18 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),24.0); end def k18; @k18 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),24.0); end def l18; @l18 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),24.0); end def m18; @m18 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),24.0); end def n18; @n18 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),24.0); end def o18; @o18 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),24.0); end def c19; "V.14"; end def f19; @f19 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),25.0); end def g19; @g19 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),25.0); end def h19; @h19 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),25.0); end def i19; @i19 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),25.0); end def j19; @j19 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),25.0); end def k19; @k19 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),25.0); end def l19; @l19 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),25.0); end def m19; @m19 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),25.0); end def n19; @n19 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),25.0); end def o19; @o19 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),25.0); end def f23; "2007"; end def g23; "2010"; end def h23; "2015"; end def i23; "2020"; end def j23; "2025"; end def k23; "2030"; end def l23; "2035"; end def m23; "2040"; end def n23; "2045"; end def o23; "2050"; end def c24; "V.03"; end def f24; @f24 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),15.0); end def g24; @g24 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),15.0); end def h24; @h24 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),15.0); end def i24; @i24 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),15.0); end def j24; @j24 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),15.0); end def k24; @k24 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),15.0); end def l24; @l24 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),15.0); end def m24; @m24 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),15.0); end def n24; @n24 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),15.0); end def o24; @o24 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),15.0); end def c25; "V.04"; end def f25; @f25 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),16.0); end def g25; @g25 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),16.0); end def h25; @h25 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),16.0); end def i25; @i25 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),16.0); end def j25; @j25 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),16.0); end def k25; @k25 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),16.0); end def l25; @l25 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),16.0); end def m25; @m25 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),16.0); end def n25; @n25 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),16.0); end def o25; @o25 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),16.0); end def c26; "V.05"; end def f26; @f26 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),17.0); end def g26; @g26 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),17.0); end def h26; @h26 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),17.0); end def i26; @i26 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),17.0); end def j26; @j26 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),17.0); end def k26; @k26 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),17.0); end def l26; @l26 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),17.0); end def m26; @m26 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),17.0); end def n26; @n26 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),17.0); end def o26; @o26 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),17.0); end def f34; 1.0; end def g34; 2.0; end def h34; 3.0; end def i34; 4.0; end def c35; "V.09"; end def e35; "Solid"; end def f35; 1.0; end def g35; 1.0; end def h35; 0.0; end def i35; 0.0; end def c36; "V.09"; end def e36; "Liquid"; end def f36; 0.0; end def g36; 0.0; end def h36; 1.0; end def i36; 0.0; end def c37; "V.09"; end def e37; "Gas"; end def f37; 0.0; end def g37; 0.0; end def h37; 0.0; end def i37; 1.0; end def c38; "V.10"; end def e38; "Solid"; end def f38; 0.0; end def g38; 0.0; end def h38; 0.0; end def i38; 0.0; end def c39; "V.10"; end def e39; "Liquid"; end def f39; 0.0; end def g39; 0.0; end def h39; 1.0; end def i39; 0.0; end def c40; "V.10"; end def e40; "Gas"; end def f40; 1.0; end def g40; 1.0; end def h40; 0.0; end def i40; 1.0; end def c41; "V.13"; end def e41; "Solid"; end def f41; 0.0; end def g41; 1.0; end def h41; 0.0; end def i41; 0.0; end def c42; "V.13"; end def e42; "Liquid"; end def f42; 1.0; end def g42; 0.0; end def h42; 1.0; end def i42; 0.0; end def c43; "V.13"; end def e43; "Gas"; end def f43; 0.0; end def g43; 0.0; end def h43; 0.0; end def i43; 1.0; end def c44; "V.14"; end def e44; "Solid"; end def f44; 0.0; end def g44; 0.0; end def h44; 0.0; end def i44; 0.0; end def c45; "V.14"; end def e45; "Liquid"; end def f45; 1.0; end def g45; 1.0; end def h45; 1.0; end def i45; 1.0; end def c46; "V.14"; end def e46; "Gas"; end def f46; 0.0; end def g46; 0.0; end def h46; 0.0; end def i46; 0.0; end def c47; "V.15"; end def e47; "Solid"; end def f47; 0.0; end def g47; 0.0; end def h47; 0.0; end def i47; 0.0; end def c48; "V.15"; end def e48; "Liquid"; end def f48; 0.0; end def g48; 0.0; end def h48; 0.0; end def i48; 0.0; end def c49; "V.15"; end def e49; "Gas"; end def f49; 1.0; end def g49; 1.0; end def h49; 1.0; end def i49; 1.0; end def c118; "V.09"; end def f118; @f118 ||= f15; end def g118; @g118 ||= g15; end def h118; @h118 ||= h15; end def i118; @i118 ||= i15; end def j118; @j118 ||= j15; end def k118; @k118 ||= k15; end def l118; @l118 ||= l15; end def m118; @m118 ||= m15; end def n118; @n118 ||= n15; end def o118; @o118 ||= o15; end def d119; "Solid"; end def f119; @f119 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c118,a('e35','e49'),d119); end def f120; 0.9; end def g120; 0.9; end def h120; 0.9; end def i120; 0.9; end def j120; 0.95; end def k120; 0.95; end def l120; 0.95; end def m120; 0.95; end def n120; 0.95; end def o120; 0.95; end def f121; @f121 ||= f118*f119*f120; end def g121; @g121 ||= g118*f119*g120; end def h121; @h121 ||= h118*f119*h120; end def i121; @i121 ||= i118*f119*i120; end def j121; @j121 ||= j118*f119*j120; end def k121; @k121 ||= k118*f119*k120; end def l121; @l121 ||= l118*f119*l120; end def m121; @m121 ||= m118*f119*m120; end def n121; @n121 ||= n118*f119*n120; end def o121; @o121 ||= o118*f119*o120; end def d123; "Liquid"; end def f123; @f123 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c118,a('e35','e49'),d123); end def f124; 0.37; end def g124; 0.37; end def h124; 0.37; end def i124; 0.37; end def j124; 0.45; end def k124; 0.45; end def l124; 0.45; end def m124; 0.45; end def n124; 0.45; end def o124; 0.45; end def f125; @f125 ||= f118*f123*f124; end def g125; @g125 ||= g118*f123*g124; end def h125; @h125 ||= h118*f123*h124; end def i125; @i125 ||= i118*f123*i124; end def j125; @j125 ||= j118*f123*j124; end def k125; @k125 ||= k118*f123*k124; end def l125; @l125 ||= l118*f123*l124; end def m125; @m125 ||= m118*f123*m124; end def n125; @n125 ||= n118*f123*n124; end def o125; @o125 ||= o118*f123*o124; end def d127; "Gas"; end def f127; @f127 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c118,a('e35','e49'),d127); end def f128; 0.585; end def g128; 0.585; end def h128; 0.585; end def i128; 0.585; end def j128; 0.662; end def k128; 0.662; end def l128; 0.662; end def m128; 0.662; end def n128; 0.662; end def o128; 0.662; end def f129; @f129 ||= f118*f127*f128; end def g129; @g129 ||= g118*f127*g128; end def h129; @h129 ||= h118*f127*h128; end def i129; @i129 ||= i118*f127*i128; end def j129; @j129 ||= j118*f127*j128; end def k129; @k129 ||= k118*f127*k128; end def l129; @l129 ||= l118*f127*l128; end def m129; @m129 ||= m118*f127*m128; end def n129; @n129 ||= n118*f127*n128; end def o129; @o129 ||= o118*f127*o128; end def c132; "V.10"; end def f132; @f132 ||= f16; end def g132; @g132 ||= g16; end def h132; @h132 ||= h16; end def i132; @i132 ||= i16; end def j132; @j132 ||= j16; end def k132; @k132 ||= k16; end def l132; @l132 ||= l16; end def m132; @m132 ||= m16; end def n132; @n132 ||= n16; end def o132; @o132 ||= o16; end def d133; "Solid"; end def f133; @f133 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c132,a('e35','e49'),d133); end def f134; 0.0; end def g134; 0.0; end def h134; 0.0; end def i134; 0.0; end def j134; 0.0; end def k134; 0.0; end def l134; 0.0; end def m134; 0.0; end def n134; 0.0; end def o134; 0.0; end def f135; @f135 ||= f132*f133*f134; end def g135; @g135 ||= g132*f133*g134; end def h135; @h135 ||= h132*f133*h134; end def i135; @i135 ||= i132*f133*i134; end def j135; @j135 ||= j132*f133*j134; end def k135; @k135 ||= k132*f133*k134; end def l135; @l135 ||= l132*f133*l134; end def m135; @m135 ||= m132*f133*m134; end def n135; @n135 ||= n132*f133*n134; end def o135; @o135 ||= o132*f133*o134; end def d137; "Liquid"; end def f137; @f137 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c132,a('e35','e49'),d137); end def f138; 0.318; end def g138; 0.318; end def h138; 0.318; end def i138; 0.318; end def j138; 0.382; end def k138; 0.382; end def l138; 0.382; end def m138; 0.382; end def n138; 0.382; end def o138; 0.382; end def f139; @f139 ||= f132*f137*f138; end def g139; @g139 ||= g132*f137*g138; end def h139; @h139 ||= h132*f137*h138; end def i139; @i139 ||= i132*f137*i138; end def j139; @j139 ||= j132*f137*j138; end def k139; @k139 ||= k132*f137*k138; end def l139; @l139 ||= l132*f137*l138; end def m139; @m139 ||= m132*f137*m138; end def n139; @n139 ||= n132*f137*n138; end def o139; @o139 ||= o132*f137*o138; end def d141; "Gas"; end def f141; @f141 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c132,a('e35','e49'),d141); end def f142; 0.75; end def g142; 0.75; end def h142; 0.75; end def i142; 0.75; end def j142; 0.85; end def k142; 0.85; end def l142; 0.85; end def m142; 0.85; end def n142; 0.85; end def o142; 0.85; end def f143; @f143 ||= f132*f141*f142; end def g143; @g143 ||= g132*f141*g142; end def h143; @h143 ||= h132*f141*h142; end def i143; @i143 ||= i132*f141*i142; end def j143; @j143 ||= j132*f141*j142; end def k143; @k143 ||= k132*f141*k142; end def l143; @l143 ||= l132*f141*l142; end def m143; @m143 ||= m132*f141*m142; end def n143; @n143 ||= n132*f141*n142; end def o143; @o143 ||= o132*f141*o142; end def c146; "V.13"; end def f146; @f146 ||= f18; end def g146; @g146 ||= g18; end def h146; @h146 ||= h18; end def i146; @i146 ||= i18; end def j146; @j146 ||= j18; end def k146; @k146 ||= k18; end def l146; @l146 ||= l18; end def m146; @m146 ||= m18; end def n146; @n146 ||= n18; end def o146; @o146 ||= o18; end def d147; "Solid"; end def f147; @f147 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c146,a('e35','e49'),d147); end def f148; 0.9; end def g148; 0.9; end def h148; 0.9; end def i148; 0.9; end def j148; 0.95; end def k148; 0.95; end def l148; 0.95; end def m148; 0.95; end def n148; 0.95; end def o148; 0.95; end def f149; @f149 ||= f146*f147*f148; end def g149; @g149 ||= g146*f147*g148; end def h149; @h149 ||= h146*f147*h148; end def i149; @i149 ||= i146*f147*i148; end def j149; @j149 ||= j146*f147*j148; end def k149; @k149 ||= k146*f147*k148; end def l149; @l149 ||= l146*f147*l148; end def m149; @m149 ||= m146*f147*m148; end def n149; @n149 ||= n146*f147*n148; end def o149; @o149 ||= o146*f147*o148; end def d151; "Liquid"; end def f151; @f151 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c146,a('e35','e49'),d151); end def f152; 0.37; end def g152; 0.37; end def h152; 0.37; end def i152; 0.37; end def j152; 0.45; end def k152; 0.45; end def l152; 0.45; end def m152; 0.45; end def n152; 0.45; end def o152; 0.45; end def f153; @f153 ||= f146*f151*f152; end def g153; @g153 ||= g146*f151*g152; end def h153; @h153 ||= h146*f151*h152; end def i153; @i153 ||= i146*f151*i152; end def j153; @j153 ||= j146*f151*j152; end def k153; @k153 ||= k146*f151*k152; end def l153; @l153 ||= l146*f151*l152; end def m153; @m153 ||= m146*f151*m152; end def n153; @n153 ||= n146*f151*n152; end def o153; @o153 ||= o146*f151*o152; end def d155; "Gas"; end def f155; @f155 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c146,a('e35','e49'),d155); end def f156; 0.585; end def g156; 0.585; end def h156; 0.585; end def i156; 0.585; end def j156; 0.662; end def k156; 0.662; end def l156; 0.662; end def m156; 0.662; end def n156; 0.662; end def o156; 0.662; end def f157; @f157 ||= f146*f155*f156; end def g157; @g157 ||= g146*f155*g156; end def h157; @h157 ||= h146*f155*h156; end def i157; @i157 ||= i146*f155*i156; end def j157; @j157 ||= j146*f155*j156; end def k157; @k157 ||= k146*f155*k156; end def l157; @l157 ||= l146*f155*l156; end def m157; @m157 ||= m146*f155*m156; end def n157; @n157 ||= n146*f155*n156; end def o157; @o157 ||= o146*f155*o156; end def c159; "V.14"; end def f159; @f159 ||= f19; end def g159; @g159 ||= g19; end def h159; @h159 ||= h19; end def i159; @i159 ||= i19; end def j159; @j159 ||= j19; end def k159; @k159 ||= k19; end def l159; @l159 ||= l19; end def m159; @m159 ||= m19; end def n159; @n159 ||= n19; end def o159; @o159 ||= o19; end def d160; "Solid"; end def f160; @f160 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c159,a('e35','e49'),d160); end def f161; 0.0; end def f162; @f162 ||= f159*f160*f161; end def g162; @g162 ||= g159*f160*f161; end def h162; @h162 ||= h159*f160*f161; end def i162; @i162 ||= i159*f160*f161; end def j162; @j162 ||= j159*f160*f161; end def k162; @k162 ||= k159*f160*f161; end def l162; @l162 ||= l159*f160*f161; end def m162; @m162 ||= m159*f160*f161; end def n162; @n162 ||= n159*f160*f161; end def o162; @o162 ||= o159*f160*f161; end def d164; "Liquid"; end def f164; @f164 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c159,a('e35','e49'),d164); end def f165; 0.31; end def g165; 0.31; end def h165; 0.31; end def i165; 0.31; end def j165; 0.316; end def k165; 0.316; end def l165; 0.316; end def m165; 0.316; end def n165; 0.316; end def o165; 0.316; end def f166; @f166 ||= f159*f164*f165; end def g166; @g166 ||= g159*f164*g165; end def h166; @h166 ||= h159*f164*h165; end def i166; @i166 ||= i159*f164*i165; end def j166; @j166 ||= j159*f164*j165; end def k166; @k166 ||= k159*f164*k165; end def l166; @l166 ||= l159*f164*l165; end def m166; @m166 ||= m159*f164*m165; end def n166; @n166 ||= n159*f164*n165; end def o166; @o166 ||= o159*f164*o165; end def d168; "Gas"; end def f168; @f168 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c159,a('e35','e49'),d168); end def f169; 0.0; end def f170; @f170 ||= f159*f168*f169; end def g170; @g170 ||= g159*f168*f169; end def h170; @h170 ||= h159*f168*f169; end def i170; @i170 ||= i159*f168*f169; end def j170; @j170 ||= j159*f168*f169; end def k170; @k170 ||= k159*f168*f169; end def l170; @l170 ||= l159*f168*f169; end def m170; @m170 ||= m159*f168*f169; end def n170; @n170 ||= n159*f168*f169; end def o170; @o170 ||= o159*f168*f169; end def c173; "V.15"; end def f173; @f173 ||= f17; end def g173; @g173 ||= g17; end def h173; @h173 ||= h17; end def i173; @i173 ||= i17; end def j173; @j173 ||= j17; end def k173; @k173 ||= k17; end def l173; @l173 ||= l17; end def m173; @m173 ||= m17; end def n173; @n173 ||= n17; end def o173; @o173 ||= o17; end def d174; "Solid"; end def f174; @f174 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c173,a('e35','e49'),d174); end def f175; 0.0; end def g175; 0.0; end def h175; 0.0; end def i175; 0.0; end def j175; 0.0; end def k175; 0.0; end def l175; 0.0; end def m175; 0.0; end def n175; 0.0; end def o175; 0.0; end def f176; @f176 ||= f173*f174*f175; end def g176; @g176 ||= g173*f174*g175; end def h176; @h176 ||= h173*f174*h175; end def i176; @i176 ||= i173*f174*i175; end def j176; @j176 ||= j173*f174*j175; end def k176; @k176 ||= k173*f174*k175; end def l176; @l176 ||= l173*f174*l175; end def m176; @m176 ||= m173*f174*m175; end def n176; @n176 ||= n173*f174*n175; end def o176; @o176 ||= o173*f174*o175; end def d178; "Liquid"; end def f178; @f178 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c173,a('e35','e49'),d178); end def d182; "Gas"; end def f182; @f182 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c173,a('e35','e49'),d182); end def f183; 1.0; end def g183; 1.0; end def h183; 1.0; end def i183; 1.0; end def j183; 1.0; end def k183; 1.0; end def l183; 1.0; end def m183; 1.0; end def n183; 1.0; end def o183; 1.0; end def f184; @f184 ||= f173*f182*f183; end def g184; @g184 ||= g173*f182*g183; end def h184; @h184 ||= h173*f182*h183; end def i184; @i184 ||= i173*f182*i183; end def j184; @j184 ||= j173*f182*j183; end def k184; @k184 ||= k173*f182*k183; end def l184; @l184 ||= l173*f182*l183; end def m184; @m184 ||= m173*f182*m183; end def n184; @n184 ||= n173*f182*n183; end def o184; @o184 ||= o173*f182*o183; end def f190; @f190 ||= f121+f135+f149+f162+f176; end def g190; @g190 ||= g121+g135+g149+g162+g176; end def h190; @h190 ||= h121+h135+h149+h162+h176; end def i190; @i190 ||= i121+i135+i149+i162+i176; end def j190; @j190 ||= j121+j135+j149+j162+j176; end def k190; @k190 ||= k121+k135+k149+k162+k176; end def l190; @l190 ||= l121+l135+l149+l162+l176; end def m190; @m190 ||= m121+m135+m149+m162+m176; end def n190; @n190 ||= n121+n135+n149+n162+n176; end def o190; @o190 ||= o121+o135+o149+o162+o176; end def f191; @f191 ||= f125+f139+f153+f166+f178; end def g191; @g191 ||= g125+g139+g153+g166+g178; end def h191; @h191 ||= h125+h139+h153+h166+h178; end def i191; @i191 ||= i125+i139+i153+i166+i178; end def j191; @j191 ||= j125+j139+j153+j166+j178; end def k191; @k191 ||= k125+k139+k153+k166+k178; end def l191; @l191 ||= l125+l139+l153+l166+l178; end def m191; @m191 ||= m125+m139+m153+m166+m178; end def n191; @n191 ||= n125+n139+n153+n166+n178; end def o191; @o191 ||= o125+o139+o153+o166+o178; end def f192; @f192 ||= f129+f143+f157+f170+f184; end def g192; @g192 ||= g129+g143+g157+g170+g184; end def h192; @h192 ||= h129+h143+h157+h170+h184; end def i192; @i192 ||= i129+i143+i157+i170+i184; end def j192; @j192 ||= j129+j143+j157+j170+j184; end def k192; @k192 ||= k129+k143+k157+k170+k184; end def l192; @l192 ||= l129+l143+l157+l170+l184; end def m192; @m192 ||= m129+m143+m157+m170+m184; end def n192; @n192 ||= n129+n143+n157+n170+n184; end def o192; @o192 ||= o129+o143+o157+o170+o184; end def b195; "V.03"; end def f195; @f195 ||= max(min(f190,-f24),0.0); end def g195; @g195 ||= max(min(g190,-g24),0.0); end def h195; @h195 ||= max(min(h190,-h24),0.0); end def i195; @i195 ||= max(min(i190,-i24),0.0); end def j195; @j195 ||= max(min(j190,-j24),0.0); end def k195; @k195 ||= max(min(k190,-k24),0.0); end def l195; @l195 ||= max(min(l190,-l24),0.0); end def m195; @m195 ||= max(min(m190,-m24),0.0); end def n195; @n195 ||= max(min(n190,-n24),0.0); end def o195; @o195 ||= max(min(o190,-o24),0.0); end def b196; "V.04"; end def f196; @f196 ||= max(min(f191,-f25),0.0); end def g196; @g196 ||= max(min(g191,-g25),0.0); end def h196; @h196 ||= max(min(h191,-h25),0.0); end def i196; @i196 ||= max(min(i191,-i25),0.0); end def j196; @j196 ||= max(min(j191,-j25),0.0); end def k196; @k196 ||= max(min(k191,-k25),0.0); end def l196; @l196 ||= max(min(l191,-l25),0.0); end def m196; @m196 ||= max(min(m191,-m25),0.0); end def n196; @n196 ||= max(min(n191,-n25),0.0); end def o196; @o196 ||= max(min(o191,-o25),0.0); end def b197; "V.05"; end def f197; @f197 ||= max(min(f192,-f26),0.0); end def g197; @g197 ||= max(min(g192,-g26),0.0); end def h197; @h197 ||= max(min(h192,-h26),0.0); end def i197; @i197 ||= max(min(i192,-i26),0.0); end def j197; @j197 ||= max(min(j192,-j26),0.0); end def k197; @k197 ||= max(min(k192,-k26),0.0); end def l197; @l197 ||= max(min(l192,-l26),0.0); end def m197; @m197 ||= max(min(m192,-m26),0.0); end def n197; @n197 ||= max(min(n192,-n26),0.0); end def o197; @o197 ||= max(min(o192,-o26),0.0); end def f206; @f206 ||= sum(m(a('f195','f197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g206; @g206 ||= sum(m(a('g195','g197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h206; @h206 ||= sum(m(a('h195','h197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i206; @i206 ||= sum(m(a('i195','i197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j206; @j206 ||= sum(m(a('j195','j197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k206; @k206 ||= sum(m(a('k195','k197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l206; @l206 ||= sum(m(a('l195','l197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m206; @m206 ||= sum(m(a('m195','m197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n206; @n206 ||= sum(m(a('n195','n197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o206; @o206 ||= sum(m(a('o195','o197'),m(a('b195','b197')) { |r1| sumifs(sheet14.a('d5','d50'),sheet14.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def c262; "V.03"; end def f262; @f262 ||= f190; end def g262; @g262 ||= g190; end def h262; @h262 ||= h190; end def i262; @i262 ||= i190; end def j262; @j262 ||= j190; end def k262; @k262 ||= k190; end def l262; @l262 ||= l190; end def m262; @m262 ||= m190; end def n262; @n262 ||= n190; end def o262; @o262 ||= o190; end def c263; "V.04"; end def f263; @f263 ||= f191; end def g263; @g263 ||= g191; end def h263; @h263 ||= h191; end def i263; @i263 ||= i191; end def j263; @j263 ||= j191; end def k263; @k263 ||= k191; end def l263; @l263 ||= l191; end def m263; @m263 ||= m191; end def n263; @n263 ||= n191; end def o263; @o263 ||= o191; end def c264; "V.05"; end def f264; @f264 ||= f192; end def g264; @g264 ||= g192; end def h264; @h264 ||= h192; end def i264; @i264 ||= i192; end def j264; @j264 ||= j192; end def k264; @k264 ||= k192; end def l264; @l264 ||= l192; end def m264; @m264 ||= m192; end def n264; @n264 ||= n192; end def o264; @o264 ||= o192; end def c265; "V.09"; end def f265; @f265 ||= -f15; end def g265; @g265 ||= -g15; end def h265; @h265 ||= -h15; end def i265; @i265 ||= -i15; end def j265; @j265 ||= -j15; end def k265; @k265 ||= -k15; end def l265; @l265 ||= -l15; end def m265; @m265 ||= -m15; end def n265; @n265 ||= -n15; end def o265; @o265 ||= -o15; end def c266; "V.10"; end def f266; @f266 ||= -f16; end def g266; @g266 ||= -g16; end def h266; @h266 ||= -h16; end def i266; @i266 ||= -i16; end def j266; @j266 ||= -j16; end def k266; @k266 ||= -k16; end def l266; @l266 ||= -l16; end def m266; @m266 ||= -m16; end def n266; @n266 ||= -n16; end def o266; @o266 ||= -o16; end def c267; "V.15"; end def f267; @f267 ||= -f17; end def g267; @g267 ||= -g17; end def h267; @h267 ||= -h17; end def i267; @i267 ||= -i17; end def j267; @j267 ||= -j17; end def k267; @k267 ||= -k17; end def l267; @l267 ||= -l17; end def m267; @m267 ||= -m17; end def n267; @n267 ||= -n17; end def o267; @o267 ||= -o17; end def c268; "V.13"; end def f268; @f268 ||= -f18; end def g268; @g268 ||= -g18; end def h268; @h268 ||= -h18; end def i268; @i268 ||= -i18; end def j268; @j268 ||= -j18; end def k268; @k268 ||= -k18; end def l268; @l268 ||= -l18; end def m268; @m268 ||= -m18; end def n268; @n268 ||= -n18; end def o268; @o268 ||= -o18; end def c269; "V.14"; end def f269; @f269 ||= -f19; end def g269; @g269 ||= -g19; end def h269; @h269 ||= -h19; end def i269; @i269 ||= -i19; end def j269; @j269 ||= -j19; end def k269; @k269 ||= -k19; end def l269; @l269 ||= -l19; end def m269; @m269 ||= -m19; end def n269; @n269 ||= -n19; end def o269; @o269 ||= -o19; end def c270; "X.01"; end def f270; @f270 ||= sum(sheet30.a('f15','f19'))-sum(a('f190','f192')); end def g270; @g270 ||= sum(sheet30.a('g15','g19'))-sum(a('g190','g192')); end def h270; @h270 ||= sum(sheet30.a('h15','h19'))-sum(a('h190','h192')); end def i270; @i270 ||= sum(sheet30.a('i15','i19'))-sum(a('i190','i192')); end def j270; @j270 ||= sum(sheet30.a('j15','j19'))-sum(a('j190','j192')); end def k270; @k270 ||= sum(sheet30.a('k15','k19'))-sum(a('k190','k192')); end def l270; @l270 ||= sum(sheet30.a('l15','l19'))-sum(a('l190','l192')); end def m270; @m270 ||= sum(sheet30.a('m15','m19'))-sum(a('m190','m192')); end def n270; @n270 ||= sum(sheet30.a('n15','n19'))-sum(a('n190','n192')); end def o270; @o270 ||= sum(sheet30.a('o15','o19'))-sum(a('o190','o192')); end def c279; "CO2"; end def d279; "X2"; end def f279; @f279 ||= -f206; end def g279; @g279 ||= -g206; end def h279; @h279 ||= -h206; end def i279; @i279 ||= -i206; end def j279; @j279 ||= -j206; end def k279; @k279 ||= -k206; end def l279; @l279 ||= -l206; end def m279; @m279 ||= -m206; end def n279; @n279 ||= -n206; end def o279; @o279 ||= -o206; end end