# coding: utf-8 # V.a class Sheet28 < Spreadsheet def a2; "V.a"; end def e7; @e7 ||= sheet3.z17; 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(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),26.0); end def g15; @g15 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),26.0); end def h15; @h15 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),26.0); end def i15; @i15 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),26.0); end def j15; @j15 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),26.0); end def k15; @k15 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),26.0); end def l15; @l15 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),26.0); end def m15; @m15 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),26.0); end def n15; @n15 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),26.0); end def o15; @o15 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),26.0); end def c16; "V.10"; end def f16; @f16 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),27.0); end def g16; @g16 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),27.0); end def h16; @h16 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),27.0); end def i16; @i16 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),27.0); end def j16; @j16 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),27.0); end def k16; @k16 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),27.0); end def l16; @l16 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),27.0); end def m16; @m16 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),27.0); end def n16; @n16 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),27.0); end def o16; @o16 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),27.0); end def c17; "V.15"; end def f17; @f17 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),28.0); end def g17; @g17 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),28.0); end def h17; @h17 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),28.0); end def i17; @i17 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),28.0); end def j17; @j17 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),28.0); end def k17; @k17 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),28.0); end def l17; @l17 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),28.0); end def m17; @m17 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),28.0); end def n17; @n17 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),28.0); end def o17; @o17 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),28.0); end def c18; "V.13"; end def f18; @f18 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),24.0); end def g18; @g18 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),24.0); end def h18; @h18 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),24.0); end def i18; @i18 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),24.0); end def j18; @j18 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),24.0); end def k18; @k18 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),24.0); end def l18; @l18 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),24.0); end def m18; @m18 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),24.0); end def n18; @n18 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),24.0); end def o18; @o18 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),24.0); end def c19; "V.14"; end def f19; @f19 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),25.0); end def g19; @g19 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),25.0); end def h19; @h19 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),25.0); end def i19; @i19 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),25.0); end def j19; @j19 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),25.0); end def k19; @k19 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),25.0); end def l19; @l19 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),25.0); end def m19; @m19 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),25.0); end def n19; @n19 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),25.0); end def o19; @o19 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.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(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),15.0); end def g24; @g24 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),15.0); end def h24; @h24 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),15.0); end def i24; @i24 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),15.0); end def j24; @j24 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),15.0); end def k24; @k24 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),15.0); end def l24; @l24 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),15.0); end def m24; @m24 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),15.0); end def n24; @n24 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),15.0); end def o24; @o24 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),15.0); end def c25; "V.04"; end def f25; @f25 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),16.0); end def g25; @g25 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),16.0); end def h25; @h25 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),16.0); end def i25; @i25 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),16.0); end def j25; @j25 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),16.0); end def k25; @k25 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),16.0); end def l25; @l25 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),16.0); end def m25; @m25 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),16.0); end def n25; @n25 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),16.0); end def o25; @o25 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),16.0); end def c26; "V.05"; end def f26; @f26 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),17.0); end def g26; @g26 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),17.0); end def h26; @h26 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),17.0); end def i26; @i26 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),17.0); end def j26; @j26 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),17.0); end def k26; @k26 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),17.0); end def l26; @l26 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),17.0); end def m26; @m26 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),17.0); end def n26; @n26 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),17.0); end def o26; @o26 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.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 c102; "V.09"; end def f102; @f102 ||= f15; end def g102; @g102 ||= g15; end def h102; @h102 ||= h15; end def i102; @i102 ||= i15; end def j102; @j102 ||= j15; end def k102; @k102 ||= k15; end def l102; @l102 ||= l15; end def m102; @m102 ||= m15; end def n102; @n102 ||= n15; end def o102; @o102 ||= o15; end def d103; "Solid"; end def f103; @f103 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c102,a('e35','e49'),d103); end def f104; 0.9; end def g104; 0.9; end def h104; 0.9; end def i104; 0.9; end def j104; 0.95; end def k104; 0.95; end def l104; 0.95; end def m104; 0.95; end def n104; 0.95; end def o104; 0.95; end def f105; @f105 ||= f102*f103*f104; end def g105; @g105 ||= g102*f103*g104; end def h105; @h105 ||= h102*f103*h104; end def i105; @i105 ||= i102*f103*i104; end def j105; @j105 ||= j102*f103*j104; end def k105; @k105 ||= k102*f103*k104; end def l105; @l105 ||= l102*f103*l104; end def m105; @m105 ||= m102*f103*m104; end def n105; @n105 ||= n102*f103*n104; end def o105; @o105 ||= o102*f103*o104; end def d107; "Liquid"; end def f107; @f107 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c102,a('e35','e49'),d107); end def f108; 0.37; end def g108; 0.37; end def h108; 0.37; end def i108; 0.37; end def j108; 0.45; end def k108; 0.45; end def l108; 0.45; end def m108; 0.45; end def n108; 0.45; end def o108; 0.45; end def f109; @f109 ||= f102*f107*f108; end def g109; @g109 ||= g102*f107*g108; end def h109; @h109 ||= h102*f107*h108; end def i109; @i109 ||= i102*f107*i108; end def j109; @j109 ||= j102*f107*j108; end def k109; @k109 ||= k102*f107*k108; end def l109; @l109 ||= l102*f107*l108; end def m109; @m109 ||= m102*f107*m108; end def n109; @n109 ||= n102*f107*n108; end def o109; @o109 ||= o102*f107*o108; end def d111; "Gas"; end def f111; @f111 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c102,a('e35','e49'),d111); end def f112; 0.585; end def g112; 0.585; end def h112; 0.585; end def i112; 0.585; end def j112; 0.662; end def k112; 0.662; end def l112; 0.662; end def m112; 0.662; end def n112; 0.662; end def o112; 0.662; end def f113; @f113 ||= f102*f111*f112; end def g113; @g113 ||= g102*f111*g112; end def h113; @h113 ||= h102*f111*h112; end def i113; @i113 ||= i102*f111*i112; end def j113; @j113 ||= j102*f111*j112; end def k113; @k113 ||= k102*f111*k112; end def l113; @l113 ||= l102*f111*l112; end def m113; @m113 ||= m102*f111*m112; end def n113; @n113 ||= n102*f111*n112; end def o113; @o113 ||= o102*f111*o112; end def c116; "V.10"; end def f116; @f116 ||= f16; end def g116; @g116 ||= g16; end def h116; @h116 ||= h16; end def i116; @i116 ||= i16; end def j116; @j116 ||= j16; end def k116; @k116 ||= k16; end def l116; @l116 ||= l16; end def m116; @m116 ||= m16; end def n116; @n116 ||= n16; end def o116; @o116 ||= o16; end def d117; "Solid"; end def f117; @f117 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c116,a('e35','e49'),d117); end def f118; 0.0; end def g118; 0.0; end def h118; 0.0; end def i118; 0.0; end def j118; 0.0; end def k118; 0.0; end def l118; 0.0; end def m118; 0.0; end def n118; 0.0; end def o118; 0.0; end def f119; @f119 ||= f116*f117*f118; end def g119; @g119 ||= g116*f117*g118; end def h119; @h119 ||= h116*f117*h118; end def i119; @i119 ||= i116*f117*i118; end def j119; @j119 ||= j116*f117*j118; end def k119; @k119 ||= k116*f117*k118; end def l119; @l119 ||= l116*f117*l118; end def m119; @m119 ||= m116*f117*m118; end def n119; @n119 ||= n116*f117*n118; end def o119; @o119 ||= o116*f117*o118; end def d121; "Liquid"; end def f121; @f121 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c116,a('e35','e49'),d121); end def f122; 0.318; end def g122; 0.318; end def h122; 0.318; end def i122; 0.318; end def j122; 0.382; end def k122; 0.382; end def l122; 0.382; end def m122; 0.382; end def n122; 0.382; end def o122; 0.382; end def f123; @f123 ||= f116*f121*f122; end def g123; @g123 ||= g116*f121*g122; end def h123; @h123 ||= h116*f121*h122; end def i123; @i123 ||= i116*f121*i122; end def j123; @j123 ||= j116*f121*j122; end def k123; @k123 ||= k116*f121*k122; end def l123; @l123 ||= l116*f121*l122; end def m123; @m123 ||= m116*f121*m122; end def n123; @n123 ||= n116*f121*n122; end def o123; @o123 ||= o116*f121*o122; end def d125; "Gas"; end def f125; @f125 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c116,a('e35','e49'),d125); end def f126; 0.75; end def g126; 0.75; end def h126; 0.75; end def i126; 0.75; end def j126; 0.85; end def k126; 0.85; end def l126; 0.85; end def m126; 0.85; end def n126; 0.85; end def o126; 0.85; end def f127; @f127 ||= f116*f125*f126; end def g127; @g127 ||= g116*f125*g126; end def h127; @h127 ||= h116*f125*h126; end def i127; @i127 ||= i116*f125*i126; end def j127; @j127 ||= j116*f125*j126; end def k127; @k127 ||= k116*f125*k126; end def l127; @l127 ||= l116*f125*l126; end def m127; @m127 ||= m116*f125*m126; end def n127; @n127 ||= n116*f125*n126; end def o127; @o127 ||= o116*f125*o126; end def c130; "V.13"; end def f130; @f130 ||= f18; end def g130; @g130 ||= g18; end def h130; @h130 ||= h18; end def i130; @i130 ||= i18; end def j130; @j130 ||= j18; end def k130; @k130 ||= k18; end def l130; @l130 ||= l18; end def m130; @m130 ||= m18; end def n130; @n130 ||= n18; end def o130; @o130 ||= o18; end def d131; "Solid"; end def f131; @f131 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c130,a('e35','e49'),d131); end def f132; 0.9; end def g132; 0.9; end def h132; 0.9; end def i132; 0.9; end def j132; 0.95; end def k132; 0.95; end def l132; 0.95; end def m132; 0.95; end def n132; 0.95; end def o132; 0.95; end def f133; @f133 ||= f130*f131*f132; end def g133; @g133 ||= g130*f131*g132; end def h133; @h133 ||= h130*f131*h132; end def i133; @i133 ||= i130*f131*i132; end def j133; @j133 ||= j130*f131*j132; end def k133; @k133 ||= k130*f131*k132; end def l133; @l133 ||= l130*f131*l132; end def m133; @m133 ||= m130*f131*m132; end def n133; @n133 ||= n130*f131*n132; end def o133; @o133 ||= o130*f131*o132; end def d135; "Liquid"; end def f135; @f135 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c130,a('e35','e49'),d135); end def f136; 0.37; end def g136; 0.37; end def h136; 0.37; end def i136; 0.37; end def j136; 0.45; end def k136; 0.45; end def l136; 0.45; end def m136; 0.45; end def n136; 0.45; end def o136; 0.45; end def f137; @f137 ||= f130*f135*f136; end def g137; @g137 ||= g130*f135*g136; end def h137; @h137 ||= h130*f135*h136; end def i137; @i137 ||= i130*f135*i136; end def j137; @j137 ||= j130*f135*j136; end def k137; @k137 ||= k130*f135*k136; end def l137; @l137 ||= l130*f135*l136; end def m137; @m137 ||= m130*f135*m136; end def n137; @n137 ||= n130*f135*n136; end def o137; @o137 ||= o130*f135*o136; end def d139; "Gas"; end def f139; @f139 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c130,a('e35','e49'),d139); end def f140; 0.585; end def g140; 0.585; end def h140; 0.585; end def i140; 0.585; end def j140; 0.662; end def k140; 0.662; end def l140; 0.662; end def m140; 0.662; end def n140; 0.662; end def o140; 0.662; end def f141; @f141 ||= f130*f139*f140; end def g141; @g141 ||= g130*f139*g140; end def h141; @h141 ||= h130*f139*h140; end def i141; @i141 ||= i130*f139*i140; end def j141; @j141 ||= j130*f139*j140; end def k141; @k141 ||= k130*f139*k140; end def l141; @l141 ||= l130*f139*l140; end def m141; @m141 ||= m130*f139*m140; end def n141; @n141 ||= n130*f139*n140; end def o141; @o141 ||= o130*f139*o140; end def c143; "V.14"; end def f143; @f143 ||= f19; end def g143; @g143 ||= g19; end def h143; @h143 ||= h19; end def i143; @i143 ||= i19; end def j143; @j143 ||= j19; end def k143; @k143 ||= k19; end def l143; @l143 ||= l19; end def m143; @m143 ||= m19; end def n143; @n143 ||= n19; end def o143; @o143 ||= o19; end def d144; "Solid"; end def f144; @f144 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c143,a('e35','e49'),d144); end def f145; 0.0; end def f146; @f146 ||= f143*f144*f145; end def g146; @g146 ||= g143*f144*f145; end def h146; @h146 ||= h143*f144*f145; end def i146; @i146 ||= i143*f144*f145; end def j146; @j146 ||= j143*f144*f145; end def k146; @k146 ||= k143*f144*f145; end def l146; @l146 ||= l143*f144*f145; end def m146; @m146 ||= m143*f144*f145; end def n146; @n146 ||= n143*f144*f145; end def o146; @o146 ||= o143*f144*f145; end def d148; "Liquid"; end def f148; @f148 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c143,a('e35','e49'),d148); end def f149; 0.31; end def g149; 0.31; end def h149; 0.31; end def i149; 0.31; end def j149; 0.316; end def k149; 0.316; end def l149; 0.316; end def m149; 0.316; end def n149; 0.316; end def o149; 0.316; end def f150; @f150 ||= f143*f148*f149; end def g150; @g150 ||= g143*f148*g149; end def h150; @h150 ||= h143*f148*h149; end def i150; @i150 ||= i143*f148*i149; end def j150; @j150 ||= j143*f148*j149; end def k150; @k150 ||= k143*f148*k149; end def l150; @l150 ||= l143*f148*l149; end def m150; @m150 ||= m143*f148*m149; end def n150; @n150 ||= n143*f148*n149; end def o150; @o150 ||= o143*f148*o149; end def d152; "Gas"; end def f152; @f152 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c143,a('e35','e49'),d152); end def f153; 0.0; end def f154; @f154 ||= f143*f152*f153; end def g154; @g154 ||= g143*f152*f153; end def h154; @h154 ||= h143*f152*f153; end def i154; @i154 ||= i143*f152*f153; end def j154; @j154 ||= j143*f152*f153; end def k154; @k154 ||= k143*f152*f153; end def l154; @l154 ||= l143*f152*f153; end def m154; @m154 ||= m143*f152*f153; end def n154; @n154 ||= n143*f152*f153; end def o154; @o154 ||= o143*f152*f153; end def c157; "V.15"; end def f157; @f157 ||= f17; end def g157; @g157 ||= g17; end def h157; @h157 ||= h17; end def i157; @i157 ||= i17; end def j157; @j157 ||= j17; end def k157; @k157 ||= k17; end def l157; @l157 ||= l17; end def m157; @m157 ||= m17; end def n157; @n157 ||= n17; end def o157; @o157 ||= o17; end def d158; "Solid"; end def f158; @f158 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c157,a('e35','e49'),d158); end def f159; 0.0; end def g159; 0.0; end def h159; 0.0; end def i159; 0.0; end def j159; 0.0; end def k159; 0.0; end def l159; 0.0; end def m159; 0.0; end def n159; 0.0; end def o159; 0.0; end def f160; @f160 ||= f157*f158*f159; end def g160; @g160 ||= g157*f158*g159; end def h160; @h160 ||= h157*f158*h159; end def i160; @i160 ||= i157*f158*i159; end def j160; @j160 ||= j157*f158*j159; end def k160; @k160 ||= k157*f158*k159; end def l160; @l160 ||= l157*f158*l159; end def m160; @m160 ||= m157*f158*m159; end def n160; @n160 ||= n157*f158*n159; end def o160; @o160 ||= o157*f158*o159; end def d162; "Liquid"; end def f162; @f162 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c157,a('e35','e49'),d162); end def d166; "Gas"; end def f166; @f166 ||= sumifs(index(a('f35','i49'),0.0,match(e7,a('f34','i34'),0.0)),a('c35','c49'),c157,a('e35','e49'),d166); end def f167; 1.0; end def g167; 1.0; end def h167; 1.0; end def i167; 1.0; end def j167; 1.0; end def k167; 1.0; end def l167; 1.0; end def m167; 1.0; end def n167; 1.0; end def o167; 1.0; end def f168; @f168 ||= f157*f166*f167; end def g168; @g168 ||= g157*f166*g167; end def h168; @h168 ||= h157*f166*h167; end def i168; @i168 ||= i157*f166*i167; end def j168; @j168 ||= j157*f166*j167; end def k168; @k168 ||= k157*f166*k167; end def l168; @l168 ||= l157*f166*l167; end def m168; @m168 ||= m157*f166*m167; end def n168; @n168 ||= n157*f166*n167; end def o168; @o168 ||= o157*f166*o167; end def f174; @f174 ||= f105+f119+f133+f146+f160; end def g174; @g174 ||= g105+g119+g133+g146+g160; end def h174; @h174 ||= h105+h119+h133+h146+h160; end def i174; @i174 ||= i105+i119+i133+i146+i160; end def j174; @j174 ||= j105+j119+j133+j146+j160; end def k174; @k174 ||= k105+k119+k133+k146+k160; end def l174; @l174 ||= l105+l119+l133+l146+l160; end def m174; @m174 ||= m105+m119+m133+m146+m160; end def n174; @n174 ||= n105+n119+n133+n146+n160; end def o174; @o174 ||= o105+o119+o133+o146+o160; end def f175; @f175 ||= f109+f123+f137+f150+f162; end def g175; @g175 ||= g109+g123+g137+g150+g162; end def h175; @h175 ||= h109+h123+h137+h150+h162; end def i175; @i175 ||= i109+i123+i137+i150+i162; end def j175; @j175 ||= j109+j123+j137+j150+j162; end def k175; @k175 ||= k109+k123+k137+k150+k162; end def l175; @l175 ||= l109+l123+l137+l150+l162; end def m175; @m175 ||= m109+m123+m137+m150+m162; end def n175; @n175 ||= n109+n123+n137+n150+n162; end def o175; @o175 ||= o109+o123+o137+o150+o162; end def f176; @f176 ||= f113+f127+f141+f154+f168; end def g176; @g176 ||= g113+g127+g141+g154+g168; end def h176; @h176 ||= h113+h127+h141+h154+h168; end def i176; @i176 ||= i113+i127+i141+i154+i168; end def j176; @j176 ||= j113+j127+j141+j154+j168; end def k176; @k176 ||= k113+k127+k141+k154+k168; end def l176; @l176 ||= l113+l127+l141+l154+l168; end def m176; @m176 ||= m113+m127+m141+m154+m168; end def n176; @n176 ||= n113+n127+n141+n154+n168; end def o176; @o176 ||= o113+o127+o141+o154+o168; end def b179; "V.03"; end def f179; @f179 ||= max(min(f174,-f24),0.0); end def g179; @g179 ||= max(min(g174,-g24),0.0); end def h179; @h179 ||= max(min(h174,-h24),0.0); end def i179; @i179 ||= max(min(i174,-i24),0.0); end def j179; @j179 ||= max(min(j174,-j24),0.0); end def k179; @k179 ||= max(min(k174,-k24),0.0); end def l179; @l179 ||= max(min(l174,-l24),0.0); end def m179; @m179 ||= max(min(m174,-m24),0.0); end def n179; @n179 ||= max(min(n174,-n24),0.0); end def o179; @o179 ||= max(min(o174,-o24),0.0); end def b180; "V.04"; end def f180; @f180 ||= max(min(f175,-f25),0.0); end def g180; @g180 ||= max(min(g175,-g25),0.0); end def h180; @h180 ||= max(min(h175,-h25),0.0); end def i180; @i180 ||= max(min(i175,-i25),0.0); end def j180; @j180 ||= max(min(j175,-j25),0.0); end def k180; @k180 ||= max(min(k175,-k25),0.0); end def l180; @l180 ||= max(min(l175,-l25),0.0); end def m180; @m180 ||= max(min(m175,-m25),0.0); end def n180; @n180 ||= max(min(n175,-n25),0.0); end def o180; @o180 ||= max(min(o175,-o25),0.0); end def b181; "V.05"; end def f181; @f181 ||= max(min(f176,-f26),0.0); end def g181; @g181 ||= max(min(g176,-g26),0.0); end def h181; @h181 ||= max(min(h176,-h26),0.0); end def i181; @i181 ||= max(min(i176,-i26),0.0); end def j181; @j181 ||= max(min(j176,-j26),0.0); end def k181; @k181 ||= max(min(k176,-k26),0.0); end def l181; @l181 ||= max(min(l176,-l26),0.0); end def m181; @m181 ||= max(min(m176,-m26),0.0); end def n181; @n181 ||= max(min(n176,-n26),0.0); end def o181; @o181 ||= max(min(o176,-o26),0.0); end def f190; @f190 ||= sum(m(a('f179','f181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def g190; @g190 ||= sum(m(a('g179','g181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def h190; @h190 ||= sum(m(a('h179','h181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def i190; @i190 ||= sum(m(a('i179','i181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def j190; @j190 ||= sum(m(a('j179','j181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def k190; @k190 ||= sum(m(a('k179','k181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def l190; @l190 ||= sum(m(a('l179','l181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def m190; @m190 ||= sum(m(a('m179','m181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def n190; @n190 ||= sum(m(a('n179','n181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def o190; @o190 ||= sum(m(a('o179','o181'),m(a('b179','b181')) { |r1| sumifs(sheet12.a('d5','d50'),sheet12.a('b5','b50'),r1) }) { |r1,r2| r1*r2 }); end def c198; "V.03"; end def f198; @f198 ||= f174; end def g198; @g198 ||= g174; end def h198; @h198 ||= h174; end def i198; @i198 ||= i174; end def j198; @j198 ||= j174; end def k198; @k198 ||= k174; end def l198; @l198 ||= l174; end def m198; @m198 ||= m174; end def n198; @n198 ||= n174; end def o198; @o198 ||= o174; end def c199; "V.04"; end def f199; @f199 ||= f175; end def g199; @g199 ||= g175; end def h199; @h199 ||= h175; end def i199; @i199 ||= i175; end def j199; @j199 ||= j175; end def k199; @k199 ||= k175; end def l199; @l199 ||= l175; end def m199; @m199 ||= m175; end def n199; @n199 ||= n175; end def o199; @o199 ||= o175; end def c200; "V.05"; end def f200; @f200 ||= f176; end def g200; @g200 ||= g176; end def h200; @h200 ||= h176; end def i200; @i200 ||= i176; end def j200; @j200 ||= j176; end def k200; @k200 ||= k176; end def l200; @l200 ||= l176; end def m200; @m200 ||= m176; end def n200; @n200 ||= n176; end def o200; @o200 ||= o176; end def c201; "V.09"; end def f201; @f201 ||= -f15; end def g201; @g201 ||= -g15; end def h201; @h201 ||= -h15; end def i201; @i201 ||= -i15; end def j201; @j201 ||= -j15; end def k201; @k201 ||= -k15; end def l201; @l201 ||= -l15; end def m201; @m201 ||= -m15; end def n201; @n201 ||= -n15; end def o201; @o201 ||= -o15; end def c202; "V.10"; end def f202; @f202 ||= -f16; end def g202; @g202 ||= -g16; end def h202; @h202 ||= -h16; end def i202; @i202 ||= -i16; end def j202; @j202 ||= -j16; end def k202; @k202 ||= -k16; end def l202; @l202 ||= -l16; end def m202; @m202 ||= -m16; end def n202; @n202 ||= -n16; end def o202; @o202 ||= -o16; end def c203; "V.15"; end def f203; @f203 ||= -f17; end def g203; @g203 ||= -g17; end def h203; @h203 ||= -h17; end def i203; @i203 ||= -i17; end def j203; @j203 ||= -j17; end def k203; @k203 ||= -k17; end def l203; @l203 ||= -l17; end def m203; @m203 ||= -m17; end def n203; @n203 ||= -n17; end def o203; @o203 ||= -o17; end def c204; "V.13"; end def f204; @f204 ||= -f18; end def g204; @g204 ||= -g18; end def h204; @h204 ||= -h18; end def i204; @i204 ||= -i18; end def j204; @j204 ||= -j18; end def k204; @k204 ||= -k18; end def l204; @l204 ||= -l18; end def m204; @m204 ||= -m18; end def n204; @n204 ||= -n18; end def o204; @o204 ||= -o18; end def c205; "V.14"; end def f205; @f205 ||= -f19; end def g205; @g205 ||= -g19; end def h205; @h205 ||= -h19; end def i205; @i205 ||= -i19; end def j205; @j205 ||= -j19; end def k205; @k205 ||= -k19; end def l205; @l205 ||= -l19; end def m205; @m205 ||= -m19; end def n205; @n205 ||= -n19; end def o205; @o205 ||= -o19; end def c206; "X.01"; end def f206; @f206 ||= sum(sheet28.a('f15','f19'))-sum(a('f174','f176')); end def g206; @g206 ||= sum(sheet28.a('g15','g19'))-sum(a('g174','g176')); end def h206; @h206 ||= sum(sheet28.a('h15','h19'))-sum(a('h174','h176')); end def i206; @i206 ||= sum(sheet28.a('i15','i19'))-sum(a('i174','i176')); end def j206; @j206 ||= sum(sheet28.a('j15','j19'))-sum(a('j174','j176')); end def k206; @k206 ||= sum(sheet28.a('k15','k19'))-sum(a('k174','k176')); end def l206; @l206 ||= sum(sheet28.a('l15','l19'))-sum(a('l174','l176')); end def m206; @m206 ||= sum(sheet28.a('m15','m19'))-sum(a('m174','m176')); end def n206; @n206 ||= sum(sheet28.a('n15','n19'))-sum(a('n174','n176')); end def o206; @o206 ||= sum(sheet28.a('o15','o19'))-sum(a('o174','o176')); end def c215; "CO2"; end def d215; "X2"; end def f215; @f215 ||= -sum(a('f190','f191')); end def g215; @g215 ||= -sum(a('g190','g191')); end def h215; @h215 ||= -sum(a('h190','h191')); end def i215; @i215 ||= -sum(a('i190','i191')); end def j215; @j215 ||= -sum(a('j190','j191')); end def k215; @k215 ||= -sum(a('k190','k191')); end def l215; @l215 ||= -sum(a('l190','l191')); end def m215; @m215 ||= -sum(a('m190','m191')); end def n215; @n215 ||= -sum(a('n190','n191')); end def o215; @o215 ||= -sum(a('o190','o191')); end end