# coding: utf-8 # I.a class Sheet17 < Spreadsheet def a2; "I.a"; end def e7; @e7 ||= sheet3.z10; 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.01"; end def f15; @f15 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),13.0); end def g15; @g15 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),13.0); end def h15; @h15 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),13.0); end def i15; @i15 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),13.0); end def j15; @j15 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),13.0); end def k15; @k15 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),13.0); end def l15; @l15 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),13.0); end def m15; @m15 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),13.0); end def n15; @n15 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),13.0); end def o15; @o15 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),13.0); end def c16; "V.02"; end def f16; @f16 ||= index(sheet55.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet55.a('c6','c110'),0.0),14.0); end def g16; @g16 ||= index(sheet56.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet56.a('c6','c110'),0.0),14.0); end def h16; @h16 ||= index(sheet57.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet57.a('c6','c110'),0.0),14.0); end def i16; @i16 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),14.0); end def j16; @j16 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),14.0); end def k16; @k16 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),14.0); end def l16; @l16 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),14.0); end def m16; @m16 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),14.0); end def n16; @n16 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),14.0); end def o16; @o16 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),14.0); end def g23; 2010.0; end def h23; 2015.0; end def i23; 2020.0; end def j23; 2025.0; end def k23; 2030.0; end def l23; 2035.0; end def m23; 2040.0; end def n23; 2045.0; end def o23; 2050.0; end def c24; 1.0; end def g24; 0.6; end def h24; 0.6; end def i24; 0.6; end def j24; 0.6; end def k24; 0.6; end def l24; 0.6; end def m24; 0.6; end def n24; 0.6; end def o24; 0.6; end def c25; 2.0; end def g25; 0.6; end def h25; 1.5; end def i25; 2.4; end def j25; 3.3; end def k25; 4.2; end def l25; 5.1; end def m25; 6.0; end def n25; 6.9; end def o25; 7.8; end def c26; 3.0; end def g26; 0.6; end def h26; 2.1; end def i26; 3.6; end def j26; 5.1; end def k26; 6.6; end def l26; 8.1; end def m26; 9.6; end def n26; 11.1; end def o26; 12.6; end def c27; 4.0; end def g27; 0.6; end def h27; 3.35; end def i27; 6.1; end def j27; 8.85; end def k27; 11.6; end def l27; 14.35; end def m27; 17.1; end def n27; 19.85; end def o27; 22.6; end def g31; 2010.0; end def h31; 2015.0; end def i31; 2020.0; end def j31; 2025.0; end def k31; 2030.0; end def l31; 2035.0; end def m31; 2040.0; end def n31; 2045.0; end def o31; 2050.0; end def c32; 1.0; end def g32; 0.0; end def h32; 0.0; end def i32; 0.0; end def j32; 0.0; end def k32; 0.0; end def l32; 0.0; end def m32; 0.0; end def n32; 0.0; end def o32; 0.0; end def c33; 2.0; end def g33; 0.0; end def h33; -0.5; end def i33; -0.5; end def j33; -0.5; end def k33; -0.5; end def l33; -0.5; end def m33; -0.5; end def n33; -0.5; end def o33; -0.5; end def c34; 3.0; end def g34; 0.0; end def h34; -0.5; end def i34; -1.0; end def j34; -1.0; end def k34; -1.0; end def l34; -1.0; end def m34; -1.0; end def n34; -1.0; end def o34; -1.0; end def c35; 4.0; end def g35; 0.0; end def h35; -0.5; end def i35; -1.0; end def j35; -2.0; end def k35; -2.0; end def l35; -2.0; end def m35; -2.0; end def n35; -2.0; end def o35; -2.0; end def f49; 0.05349757651979259; end def g49; 0.05; end def h49; 0.05; end def i49; 0.05; end def j49; 0.05; end def k49; 0.05; end def l49; 0.05; end def m49; 0.05; end def n49; 0.05; end def o49; 0.05; end def f51; 0.019761196093076236; end def g51; 0.02; end def h51; 0.02; end def i51; 0.02; end def j51; 0.02; end def k51; 0.02; end def l51; 0.02; end def m51; 0.02; end def n51; 0.02; end def o51; 0.02; end def f64; 0.632; end def g64; 0.7; end def h64; 0.7; end def i64; 0.7; end def j64; 0.7; end def k64; 0.7; end def l64; 0.7; end def m64; 0.7; end def n64; 0.7; end def o64; 0.7; end def d68; 0.6; end def d69; 0.9; end def h74; 22.822; end def i74; 16.455000000000002; end def j74; 8.012; end def k74; 1.2; end def f80; 0.8599271238174099; end def g80; 0.8599271238174099; end def h80; 0.8599271238174099; end def i80; 0.8599271238174099; end def j80; 0.8599271238174099; end def f85; 2.0; end def g101; 2010.0; end def h101; 2015.0; end def i101; 2020.0; end def j101; 2025.0; end def k101; 2030.0; end def l101; 2035.0; end def m101; 2040.0; end def n101; 2045.0; end def o101; 2050.0; end def g102; 27.537999999999997; end def h102; @h102 ||= h74+index(a('g32','o35'),match(e7,a('c32','c35'),0.0),2.0); end def i102; @i102 ||= i74+index(a('g32','o35'),match(e7,a('c32','c35'),0.0),3.0); end def j102; @j102 ||= j74+index(a('g32','o35'),match(e7,a('c32','c35'),0.0),4.0); end def k102; @k102 ||= excel_if((k74+index(a('g32','o35'),match(e7,a('c32','c35'),0.0),5.0))>0.0,k74+index(a('g32','o35'),match(e7,a('c32','c35'),0.0),5.0),0.0); end def f103; 0.6; end def g103; @g103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),1.0); end def h103; @h103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),2.0); end def i103; @i103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),3.0); end def j103; @j103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),4.0); end def k103; @k103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),5.0); end def l103; @l103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),6.0); end def m103; @m103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),7.0); end def n103; @n103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),8.0); end def o103; @o103 ||= index(a('g24','o27'),match(e7,a('c24','c27'),0.0),9.0); end def f108; 28.137999999999998; end def g108; 28.137999999999998; end def h108; @h108 ||= h102+h103; end def i108; @i108 ||= i102+i103; end def j108; @j108 ||= j102+j103; end def k108; @k108 ||= k102+k103; end def l108; @l108 ||= l102+l103; end def m108; @m108 ||= m102+m103; end def n108; @n108 ||= n102+n103; end def o108; @o108 ||= o102+o103; end def g115; @g115 ||= ((g103*d69)+(g102*d68))/g108; end def h115; @h115 ||= ((h103*d69)+(h102*d68))/h108; end def i115; @i115 ||= ((i103*d69)+(i102*d68))/i108; end def j115; @j115 ||= ((j103*d69)+(j102*d68))/j108; end def k115; @k115 ||= ((k103*d69)+(k102*d68))/k108; end def l115; @l115 ||= ((l103*d69)+(l102*d68))/l108; end def m115; @m115 ||= ((m103*d69)+(m102*d68))/m108; end def n115; @n115 ||= ((n103*d69)+(n102*d68))/n108; end def o115; @o115 ||= ((o103*d69)+(o102*d68))/o108; end def f131; 2.16721818; end def g131; 2.133714528; end def h131; 0.0; end def i131; 0.0; end def j131; 0.0; end def k131; 0.0; end def l131; 0.0; end def m131; 0.0; end def n131; 0.0; end def o131; 0.0; end def f132; 0.4395370201498217; end def g132; 0.42674290560000006; end def h132; 0.0; end def i132; 0.0; end def j132; 0.0; end def k132; 0.0; end def l132; 0.0; end def m132; 0.0; end def n132; 0.0; end def o132; 0.0; end def f133; 2.6067552001498218; end def g133; 2.5604574336; end def h133; 0.0; end def i133; 0.0; end def j133; 0.0; end def k133; 0.0; end def l133; 0.0; end def m133; 0.0; end def n133; 0.0; end def o133; 0.0; end def f135; 9.479109818726624; end def g135; 8.534858112; end def h135; 0.0; end def i135; 0.0; end def j135; 0.0; end def k135; 0.0; end def l135; 0.0; end def m135; 0.0; end def n135; 0.0; end def o135; 0.0; end def f138; @f138 ||= max(-sum(sheet17.a('f15','f16'))-f131,0.0); end def g138; @g138 ||= max(-sum(sheet17.a('g15','g16'))-g131,0.0); end def h138; @h138 ||= max(-sum(sheet17.a('h15','h16'))-h131,0.0); end def i138; @i138 ||= max(-sum(sheet17.a('i15','i16'))-i131,0.0); end def j138; @j138 ||= max(-sum(sheet17.a('j15','j16'))-j131,0.0); end def k138; @k138 ||= max(-sum(sheet17.a('k15','k16'))-k131,0.0); end def l138; @l138 ||= max(-sum(sheet17.a('l15','l16'))-l131,0.0); end def m138; @m138 ||= max(-sum(sheet17.a('m15','m16'))-m131,0.0); end def n138; @n138 ||= max(-sum(sheet17.a('n15','n16'))-n131,0.0); end def o138; @o138 ||= max(-sum(sheet17.a('o15','o16'))-o131,0.0); end def f141; @f141 ||= excel_if(excel_and(f138==0.0,e7==1.0),0.0,f108); end def g141; @g141 ||= excel_if(excel_and(g138==0.0,e7==1.0),0.0,g108); end def h141; @h141 ||= excel_if(excel_and(h138==0.0,e7==1.0),0.0,h108); end def i141; @i141 ||= excel_if(excel_and(i138==0.0,e7==1.0),0.0,i108); end def j141; @j141 ||= excel_if(excel_and(j138==0.0,e7==1.0),0.0,j108); end def k141; @k141 ||= excel_if(excel_and(k138==0.0,e7==1.0),0.0,k108); end def l141; @l141 ||= excel_if(excel_and(l138==0.0,e7==1.0),0.0,l108); end def m141; @m141 ||= excel_if(excel_and(m138==0.0,e7==1.0),0.0,m108); end def n141; @n141 ||= excel_if(excel_and(n138==0.0,e7==1.0),0.0,n108); end def o141; @o141 ||= excel_if(excel_and(o138==0.0,e7==1.0),0.0,o108); end def f142; 0.6063970431445019; end def g142; @g142 ||= g115; end def h142; @h142 ||= h115; end def i142; @i142 ||= i115; end def j142; @j142 ||= j115; end def k142; @k142 ||= k115; end def l142; @l142 ||= l115; end def m142; @m142 ||= m115; end def n142; @n142 ||= n115; end def o142; @o142 ||= o115; end def f143; @f143 ||= f141*f142; end def g143; @g143 ||= g141*g142; end def h143; @h143 ||= h141*h142; end def i143; @i143 ||= i141*i142; end def j143; @j143 ||= j141*j142; end def k143; @k143 ||= k141*k142; end def l143; @l143 ||= l141*l142; end def m143; @m143 ||= m141*m142; end def n143; @n143 ||= n141*n142; end def o143; @o143 ||= o141*o142; end def f145; @f145 ||= f143*sheet5.f5*sheet9.f36/sheet5.f3; end def g145; @g145 ||= g143*sheet5.f5*sheet9.f36/sheet5.f3; end def h145; @h145 ||= h143*sheet5.f5*sheet9.f36/sheet5.f3; end def i145; @i145 ||= i143*sheet5.f5*sheet9.f36/sheet5.f3; end def j145; @j145 ||= j143*sheet5.f5*sheet9.f36/sheet5.f3; end def k145; @k145 ||= k143*sheet5.f5*sheet9.f36/sheet5.f3; end def l145; @l145 ||= l143*sheet5.f5*sheet9.f36/sheet5.f3; end def m145; @m145 ||= m143*sheet5.f5*sheet9.f36/sheet5.f3; end def n145; @n145 ||= n143*sheet5.f5*sheet9.f36/sheet5.f3; end def o145; @o145 ||= o143*sheet5.f5*sheet9.f36/sheet5.f3; end def f148; @f148 ||= f138*f80/(1.0+f80); end def g148; @g148 ||= g138*g80/(1.0+g80); end def h148; @h148 ||= h138*h80/(1.0+h80); end def i148; @i148 ||= i138*i80/(1.0+i80); end def j148; @j148 ||= j138*j80/(1.0+j80); end def f150; @f150 ||= excel_if(min(f145,f148)==0.0,(f103*d69*sheet5.f5*sheet9.f36/sheet5.f3),min(f145,f148)); end def g150; @g150 ||= excel_if(min(g145,g148)==0.0,(g103*d69*sheet5.f5*sheet9.f36/sheet5.f3),min(g145,g148)); end def h150; @h150 ||= excel_if(min(h145,h148)==0.0,(h103*d69*sheet5.f5*sheet9.f36/sheet5.f3),min(h145,h148)); end def i150; @i150 ||= excel_if(min(i145,i148)==0.0,(i103*d69*sheet5.f5*sheet9.f36/sheet5.f3),min(i145,i148)); end def j150; @j150 ||= excel_if(min(j145,j148)==0.0,(j103*d69*sheet5.f5*sheet9.f36/sheet5.f3),min(j145,j148)); end def k150; @k150 ||= k145; end def l150; @l150 ||= l145; end def m150; @m150 ||= m145; end def n150; @n150 ||= n145; end def o150; @o150 ||= o145; end def f151; @f151 ||= f49*f150; end def g151; @g151 ||= g49*g150; end def h151; @h151 ||= h49*h150; end def i151; @i151 ||= i49*i150; end def j151; @j151 ||= j49*j150; end def k151; @k151 ||= k49*k150; end def l151; @l151 ||= l49*l150; end def m151; @m151 ||= m49*m150; end def n151; @n151 ||= n49*n150; end def o151; @o151 ||= o49*o150; end def f152; @f152 ||= f150+f151; end def g152; @g152 ||= g150+g151; end def h152; @h152 ||= h150+h151; end def i152; @i152 ||= i150+i151; end def j152; @j152 ||= j150+j151; end def k152; @k152 ||= k150+k151; end def l152; @l152 ||= l150+l151; end def m152; @m152 ||= m150+m151; end def n152; @n152 ||= n150+n151; end def o152; @o152 ||= o150+o151; end def f153; 0.357; end def g153; 0.35; end def h153; 0.35; end def i153; 0.35; end def j153; 0.35; end def k153; 0.35; end def l153; 0.35; end def m153; 0.35; end def n153; 0.35; end def o153; 0.35; end def f154; @f154 ||= f152/f153; end def g154; @g154 ||= g152/g153; end def h154; @h154 ||= h152/h153; end def i154; @i154 ||= i152/i153; end def j154; @j154 ||= j152/j153; end def k154; @k154 ||= k152/k153; end def l154; @l154 ||= l152/l153; end def m154; @m154 ||= m152/m153; end def n154; @n154 ||= n152/n153; end def o154; @o154 ||= o152/o153; end def f158; @f158 ||= f138-f150; end def g158; @g158 ||= g138-g150; end def h158; @h158 ||= h138-h150; end def i158; @i158 ||= i138-i150; end def j158; @j158 ||= j138-j150; end def k158; @k158 ||= k138-k150; end def l158; @l158 ||= l138-l150; end def m158; @m158 ||= m138-m150; end def n158; @n158 ||= n138-n150; end def o158; @o158 ||= o138-o150; end def f160; @f160 ||= excel_if(f158>0.0,f158,0.0); end def g160; @g160 ||= excel_if(g158>0.0,g158,0.0); end def h160; @h160 ||= excel_if(h158>0.0,h158,0.0); end def i160; @i160 ||= excel_if(i158>0.0,i158,0.0); end def j160; @j160 ||= excel_if(j158>0.0,j158,0.0); end def k160; @k160 ||= excel_if(k158>0.0,k158,0.0); end def l160; @l160 ||= excel_if(l158>0.0,l158,0.0); end def m160; @m160 ||= excel_if(m158>0.0,m158,0.0); end def n160; @n160 ||= excel_if(n158>0.0,n158,0.0); end def o160; @o160 ||= excel_if(o158>0.0,o158,0.0); end def f161; @f161 ||= f51*f160; end def g161; @g161 ||= g51*g160; end def h161; @h161 ||= h51*h160; end def i161; @i161 ||= i51*i160; end def j161; @j161 ||= j51*j160; end def k161; @k161 ||= k51*k160; end def l161; @l161 ||= l51*l160; end def m161; @m161 ||= m51*m160; end def n161; @n161 ||= n51*n160; end def o161; @o161 ||= o51*o160; end def f162; @f162 ||= f160+f161; end def g162; @g162 ||= g160+g161; end def h162; @h162 ||= h160+h161; end def i162; @i162 ||= i160+i161; end def j162; @j162 ||= j160+j161; end def k162; @k162 ||= k160+k161; end def l162; @l162 ||= l160+l161; end def m162; @m162 ||= m160+m161; end def n162; @n162 ||= n160+n161; end def o162; @o162 ||= o160+o161; end def f163; 0.489; end def g163; 0.5; end def h163; 0.5; end def i163; 0.5; end def j163; 0.5; end def k163; 0.5; end def l163; 0.5; end def m163; 0.5; end def n163; 0.5; end def o163; 0.5; end def f164; @f164 ||= f162/f163; end def g164; @g164 ||= g162/g163; end def h164; @h164 ||= h162/h163; end def i164; @i164 ||= i162/i163; end def j164; @j164 ||= j162/j163; end def k164; @k164 ||= k162/k163; end def l164; @l164 ||= l162/l163; end def m164; @m164 ||= m162/m163; end def n164; @n164 ||= n162/n163; end def o164; @o164 ||= o162/o163; end def f167; @f167 ||= f135*sheet12.d43+f154*sheet12.d42+f164*sheet12.d44; end def g167; @g167 ||= g135*sheet12.d43+g154*sheet12.d42+g164*sheet12.d44; end def h167; @h167 ||= h135*sheet12.d43+h154*sheet12.d42+h164*sheet12.d44; end def i167; @i167 ||= i135*sheet12.d43+i154*sheet12.d42+i164*sheet12.d44; end def j167; @j167 ||= j135*sheet12.d43+j154*sheet12.d42+j164*sheet12.d44; end def k167; @k167 ||= k135*sheet12.d43+k154*sheet12.d42+k164*sheet12.d44; end def l167; @l167 ||= l135*sheet12.d43+l154*sheet12.d42+l164*sheet12.d44; end def m167; @m167 ||= m135*sheet12.d43+m154*sheet12.d42+m164*sheet12.d44; end def n167; @n167 ||= n135*sheet12.d43+n154*sheet12.d42+n164*sheet12.d44; end def o167; @o167 ||= o135*sheet12.d43+o154*sheet12.d42+o164*sheet12.d44; end def f168; @f168 ||= f135*sheet12.e43+f154*sheet12.e42+f164*sheet12.e44; end def g168; @g168 ||= g135*sheet12.e43+g154*sheet12.e42+g164*sheet12.e44; end def h168; @h168 ||= h135*sheet12.e43+h154*sheet12.e42+h164*sheet12.e44; end def i168; @i168 ||= i135*sheet12.e43+i154*sheet12.e42+i164*sheet12.e44; end def j168; @j168 ||= j135*sheet12.e43+j154*sheet12.e42+j164*sheet12.e44; end def k168; @k168 ||= k135*sheet12.e43+k154*sheet12.e42+k164*sheet12.e44; end def l168; @l168 ||= l135*sheet12.e43+l154*sheet12.e42+l164*sheet12.e44; end def m168; @m168 ||= m135*sheet12.e43+m154*sheet12.e42+m164*sheet12.e44; end def n168; @n168 ||= n135*sheet12.e43+n154*sheet12.e42+n164*sheet12.e44; end def o168; @o168 ||= o135*sheet12.e43+o154*sheet12.e42+o164*sheet12.e44; end def f169; @f169 ||= f135*sheet12.f43+f154*sheet12.f42+f164*sheet12.f44; end def g169; @g169 ||= g135*sheet12.f43+g154*sheet12.f42+g164*sheet12.f44; end def h169; @h169 ||= h135*sheet12.f43+h154*sheet12.f42+h164*sheet12.f44; end def i169; @i169 ||= i135*sheet12.f43+i154*sheet12.f42+i164*sheet12.f44; end def j169; @j169 ||= j135*sheet12.f43+j154*sheet12.f42+j164*sheet12.f44; end def k169; @k169 ||= k135*sheet12.f43+k154*sheet12.f42+k164*sheet12.f44; end def l169; @l169 ||= l135*sheet12.f43+l154*sheet12.f42+l164*sheet12.f44; end def m169; @m169 ||= m135*sheet12.f43+m154*sheet12.f42+m164*sheet12.f44; end def n169; @n169 ||= n135*sheet12.f43+n154*sheet12.f42+n164*sheet12.f44; end def o169; @o169 ||= o135*sheet12.f43+o154*sheet12.f42+o164*sheet12.f44; end def f173; 4.1; end def g173; 4.0568; end def h173; 0.0; end def i173; 0.0; end def j173; 0.0; end def k173; 0.0; end def l173; 0.0; end def m173; 0.0; end def n173; 0.0; end def o173; 0.0; end def f174; @f174 ||= f141; end def g174; @g174 ||= g141; end def h174; @h174 ||= h141; end def i174; @i174 ||= i141; end def j174; @j174 ||= j141; end def k174; @k174 ||= k141; end def l174; @l174 ||= l141; end def m174; @m174 ||= m141; end def n174; @n174 ||= n141; end def o174; @o174 ||= o141; end def f175; @f175 ||= f160*sheet5.f3/(sheet5.f5*sheet9.f36*f64); end def g175; @g175 ||= g160*sheet5.f3/(sheet5.f5*sheet9.f36*g64); end def h175; @h175 ||= h160*sheet5.f3/(sheet5.f5*sheet9.f36*h64); end def i175; @i175 ||= i160*sheet5.f3/(sheet5.f5*sheet9.f36*i64); end def j175; @j175 ||= j160*sheet5.f3/(sheet5.f5*sheet9.f36*j64); end def k175; @k175 ||= k160*sheet5.f3/(sheet5.f5*sheet9.f36*k64); end def l175; @l175 ||= l160*sheet5.f3/(sheet5.f5*sheet9.f36*l64); end def m175; @m175 ||= m160*sheet5.f3/(sheet5.f5*sheet9.f36*m64); end def n175; @n175 ||= n160*sheet5.f3/(sheet5.f5*sheet9.f36*n64); end def o175; @o175 ||= o160*sheet5.f3/(sheet5.f5*sheet9.f36*o64); end def c184; "V.02"; end def f184; @f184 ||= f131+f150+f160; end def g184; @g184 ||= g131+g150+g160; end def h184; @h184 ||= h131+h150+h160; end def i184; @i184 ||= i131+i150+i160; end def j184; @j184 ||= j131+j150+j160; end def k184; @k184 ||= k131+k150+k160; end def l184; @l184 ||= l131+l150+l160; end def m184; @m184 ||= m131+m150+m160; end def n184; @n184 ||= n131+n150+n160; end def o184; @o184 ||= o131+o150+o160; end def c185; "V.03"; end def f185; @f185 ||= -f154; end def g185; @g185 ||= -g154; end def h185; @h185 ||= -h154; end def i185; @i185 ||= -i154; end def j185; @j185 ||= -j154; end def k185; @k185 ||= -k154; end def l185; @l185 ||= -l154; end def m185; @m185 ||= -m154; end def n185; @n185 ||= -n154; end def o185; @o185 ||= -o154; end def c186; "V.04"; end def f186; -9.479109818726624; end def g186; -8.534858112; end def h186; 0.0; end def i186; 0.0; end def j186; 0.0; end def k186; 0.0; end def l186; 0.0; end def m186; 0.0; end def n186; 0.0; end def o186; 0.0; end def c187; "V.05"; end def f187; @f187 ||= -f164; end def g187; @g187 ||= -g164; end def h187; @h187 ||= -h164; end def i187; @i187 ||= -i164; end def j187; @j187 ||= -j164; end def k187; @k187 ||= -k164; end def l187; @l187 ||= -l164; end def m187; @m187 ||= -m164; end def n187; @n187 ||= -n164; end def o187; @o187 ||= -o164; end def c188; "X.01"; end def f188; @f188 ||= (f154+f164)-(f152+f162)+(f135-f133); end def g188; @g188 ||= (g154+g164)-(g152+g162)+(g135-g133); end def h188; @h188 ||= (h154+h164)-(h152+h162)+(h135-h133); end def i188; @i188 ||= (i154+i164)-(i152+i162)+(i135-i133); end def j188; @j188 ||= (j154+j164)-(j152+j162)+(j135-j133); end def k188; @k188 ||= (k154+k164)-(k152+k162)+(k135-k133); end def l188; @l188 ||= (l154+l164)-(l152+l162)+(l135-l133); end def m188; @m188 ||= (m154+m164)-(m152+m162)+(m135-m133); end def n188; @n188 ||= (n154+n164)-(n152+n162)+(n135-n133); end def o188; @o188 ||= (o154+o164)-(o152+o162)+(o135-o133); end def c189; "X.02"; end def f189; @f189 ||= f132+f151+f161; end def g189; @g189 ||= g132+g151+g161; end def h189; @h189 ||= h132+h151+h161; end def i189; @i189 ||= i132+i151+i161; end def j189; @j189 ||= j132+j151+j161; end def k189; @k189 ||= k132+k151+k161; end def l189; @l189 ||= l132+l151+l161; end def m189; @m189 ||= m132+m151+m161; end def n189; @n189 ||= n132+n151+n161; end def o189; @o189 ||= o132+o151+o161; end def c198; "CO2"; end def d198; "1A"; end def f198; @f198 ||= f167; end def g198; @g198 ||= g167; end def h198; @h198 ||= h167; end def i198; @i198 ||= i167; end def j198; @j198 ||= j167; end def k198; @k198 ||= k167; end def l198; @l198 ||= l167; end def m198; @m198 ||= m167; end def n198; @n198 ||= n167; end def o198; @o198 ||= o167; end def c199; "CH4"; end def d199; "1A"; end def f199; @f199 ||= f168; end def g199; @g199 ||= g168; end def h199; @h199 ||= h168; end def i199; @i199 ||= i168; end def j199; @j199 ||= j168; end def k199; @k199 ||= k168; end def l199; @l199 ||= l168; end def m199; @m199 ||= m168; end def n199; @n199 ||= n168; end def o199; @o199 ||= o168; end def c200; "N2O"; end def d200; "1A"; end def f200; @f200 ||= f169; end def g200; @g200 ||= g169; end def h200; @h200 ||= h169; end def i200; @i200 ||= i169; end def j200; @j200 ||= j169; end def k200; @k200 ||= k169; end def l200; @l200 ||= l169; end def m200; @m200 ||= m169; end def n200; @n200 ||= n169; end def o200; @o200 ||= o169; end def f201; @f201 ||= subtotal(109.0,sheet17.a('f198','f200')); end def g201; @g201 ||= subtotal(109.0,sheet17.a('g198','g200')); end def h201; @h201 ||= subtotal(109.0,sheet17.a('h198','h200')); end def i201; @i201 ||= subtotal(109.0,sheet17.a('i198','i200')); end def j201; @j201 ||= subtotal(109.0,sheet17.a('j198','j200')); end def k201; @k201 ||= subtotal(109.0,sheet17.a('k198','k200')); end def l201; @l201 ||= subtotal(109.0,sheet17.a('l198','l200')); end def m201; @m201 ||= subtotal(109.0,sheet17.a('m198','m200')); end def n201; @n201 ||= subtotal(109.0,sheet17.a('n198','n200')); end def o201; @o201 ||= subtotal(109.0,sheet17.a('o198','o200')); end def c210; "B.02"; end def f210; @f210 ||= sum(a('f173','f175')); end def g210; @g210 ||= sum(a('g173','g175')); end def h210; @h210 ||= sum(a('h173','h175')); end def i210; @i210 ||= sum(a('i173','i175')); end def j210; @j210 ||= sum(a('j173','j175')); end def k210; @k210 ||= sum(a('k173','k175')); end def l210; @l210 ||= sum(a('l173','l175')); end def m210; @m210 ||= sum(a('m173','m175')); end def n210; @n210 ||= sum(a('n173','n175')); end def o210; @o210 ||= sum(a('o173','o175')); end def c211; "B.03"; end def f211; @f211 ||= f210/f85; end def g211; @g211 ||= g210/f85; end def h211; @h211 ||= h210/f85; end def i211; @i211 ||= i210/f85; end def j211; @j211 ||= j210/f85; end def k211; @k211 ||= k210/f85; end def l211; @l211 ||= l210/f85; end def m211; @m211 ||= m210/f85; end def n211; @n211 ||= n210/f85; end def o211; @o211 ||= o210/f85; end def balancing_boostable_capacity; sheet17.a('f175','o175'); end end