# coding: utf-8 # VII.b class Sheet36 < Spreadsheet def a2; "VII.b"; end def f8; "2007"; end def g8; "2010"; end def h8; "2015"; end def i8; "2020"; end def j8; "2025"; end def k8; "2030"; end def l8; "2035"; end def m8; "2040"; end def n8; "2045"; end def o8; "2050"; end def c9; "V.01"; end def f9; @f9 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),13.0); end def g9; @g9 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),13.0); end def h9; @h9 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),13.0); end def i9; @i9 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),13.0); end def j9; @j9 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),13.0); end def k9; @k9 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),13.0); end def l9; @l9 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),13.0); end def m9; @m9 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),13.0); end def n9; @n9 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),13.0); end def o9; @o9 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),13.0); end def f41; @f41 ||= -sheet36.a('f9','f9'); end def g41; @g41 ||= -sheet36.a('g9','g9'); end def h41; @h41 ||= -sheet36.a('h9','h9'); end def i41; @i41 ||= -sheet36.a('i9','i9'); end def j41; @j41 ||= -sheet36.a('j9','j9'); end def k41; @k41 ||= -sheet36.a('k9','k9'); end def l41; @l41 ||= -sheet36.a('l9','l9'); end def m41; @m41 ||= -sheet36.a('m9','m9'); end def n41; @n41 ||= -sheet36.a('n9','n9'); end def o41; @o41 ||= -sheet36.a('o9','o9'); end def f42; 0.9302500153604167; end def g42; 0.9302500153604167; end def h42; 0.9302500153604167; end def i42; 0.9302500153604167; end def j42; 0.9302500153604167; end def k42; 0.9302500153604167; end def l42; 0.9302500153604167; end def m42; 0.9302500153604167; end def n42; 0.9302500153604167; end def o42; 0.9302500153604167; end def f43; @f43 ||= f41/f42; end def g43; @g43 ||= g41/g42; end def h43; @h43 ||= h41/h42; end def i43; @i43 ||= i41/i42; end def j43; @j43 ||= j41/j42; end def k43; @k43 ||= k41/k42; end def l43; @l43 ||= l41/l42; end def m43; @m43 ||= m41/m42; end def n43; @n43 ||= n41/n42; end def o43; @o43 ||= o41/o42; end def f44; 0.06974998463958323; end def g44; 0.06974998463958323; end def h44; 0.06974998463958323; end def i44; 0.06974998463958323; end def j44; 0.06974998463958323; end def k44; 0.06974998463958323; end def l44; 0.06974998463958323; end def m44; 0.06974998463958323; end def n44; 0.06974998463958323; end def o44; 0.06974998463958323; end def f45; @f45 ||= f43*f44; end def g45; @g45 ||= g43*g44; end def h45; @h45 ||= h43*h44; end def i45; @i45 ||= i43*i44; end def j45; @j45 ||= j43*j44; end def k45; @k45 ||= k43*k44; end def l45; @l45 ||= l43*l44; end def m45; @m45 ||= m43*m44; end def n45; @n45 ||= n43*n44; end def o45; @o45 ||= o43*o44; end def c79; "V.01"; end def f79; 0.0; end def g79; 0.0; end def h79; 0.0; end def i79; 0.0; end def j79; 0.0; end def k79; 0.0; end def l79; 0.0; end def m79; 0.0; end def n79; 0.0; end def o79; 0.0; end def c80; "V.02"; end def f80; @f80 ||= -(f43-f41); end def g80; @g80 ||= -(g43-g41); end def h80; @h80 ||= -(h43-h41); end def i80; @i80 ||= -(i43-i41); end def j80; @j80 ||= -(j43-j41); end def k80; @k80 ||= -(k43-k41); end def l80; @l80 ||= -(l43-l41); end def m80; @m80 ||= -(m43-m41); end def n80; @n80 ||= -(n43-n41); end def o80; @o80 ||= -(o43-o41); end def c81; "X.02"; end def f81; @f81 ||= f45; end def g81; @g81 ||= g45; end def h81; @h81 ||= h45; end def i81; @i81 ||= i45; end def j81; @j81 ||= j45; end def k81; @k81 ||= k45; end def l81; @l81 ||= l45; end def m81; @m81 ||= m45; end def n81; @n81 ||= n45; end def o81; @o81 ||= o45; end end