# coding: utf-8 # XVII.a class Sheet54 < Spreadsheet def a2; "XVII.a"; 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.07"; end def f9; @f9 ||= index(sheet58.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet58.a('c6','c110'),0.0),22.0); end def g9; @g9 ||= index(sheet59.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet59.a('c6','c110'),0.0),22.0); end def h9; @h9 ||= index(sheet60.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet60.a('c6','c110'),0.0),22.0); end def i9; @i9 ||= index(sheet61.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet61.a('c6','c110'),0.0),22.0); end def j9; @j9 ||= index(sheet62.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet62.a('c6','c110'),0.0),22.0); end def k9; @k9 ||= index(sheet63.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet63.a('c6','c110'),0.0),22.0); end def l9; @l9 ||= index(sheet64.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet64.a('c6','c110'),0.0),22.0); end def m9; @m9 ||= index(sheet65.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet65.a('c6','c110'),0.0),22.0); end def n9; @n9 ||= index(sheet66.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet66.a('c6','c110'),0.0),22.0); end def o9; @o9 ||= index(sheet67.a('g6','bl110'),match("Subtotal."+a2.to_s,sheet67.a('c6','c110'),0.0),22.0); end def f40; @f40 ||= -sheet54.a('f9','f9'); end def g40; @g40 ||= -sheet54.a('g9','g9'); end def h40; @h40 ||= -sheet54.a('h9','h9'); end def i40; @i40 ||= -sheet54.a('i9','i9'); end def j40; @j40 ||= -sheet54.a('j9','j9'); end def k40; @k40 ||= -sheet54.a('k9','k9'); end def l40; @l40 ||= -sheet54.a('l9','l9'); end def m40; @m40 ||= -sheet54.a('m9','m9'); end def n40; @n40 ||= -sheet54.a('n9','n9'); end def o40; @o40 ||= -sheet54.a('o9','o9'); end def f41; 7.0; end def g41; 7.0; end def h41; 7.0; end def i41; 7.0; end def j41; 7.0; end def k41; 7.0; end def l41; 7.0; end def m41; 7.0; end def n41; 7.0; end def o41; 7.0; end def f42; @f42 ||= f40/f41; end def g42; @g42 ||= g40/g41; end def h42; @h42 ||= h40/h41; end def i42; @i42 ||= i40/i41; end def j42; @j42 ||= j40/j41; end def k42; @k42 ||= k40/k41; end def l42; @l42 ||= l40/l41; end def m42; @m42 ||= m40/m41; end def n42; @n42 ||= n40/n41; end def o42; @o42 ||= o40/o41; end def f43; @f43 ||= f40-f42; end def g43; @g43 ||= g40-g42; end def h43; @h43 ||= h40-h42; end def i43; @i43 ||= i40-i42; end def j43; @j43 ||= j40-j42; end def k43; @k43 ||= k40-k42; end def l43; @l43 ||= l40-l42; end def m43; @m43 ||= m40-m42; end def n43; @n43 ||= n40-n42; end def o43; @o43 ||= o40-o42; end def c66; "V.07"; end def f66; @f66 ||= f40; end def g66; @g66 ||= g40; end def h66; @h66 ||= h40; end def i66; @i66 ||= i40; end def j66; @j66 ||= j40; end def k66; @k66 ||= k40; end def l66; @l66 ||= l40; end def m66; @m66 ||= m40; end def n66; @n66 ||= n40; end def o66; @o66 ||= o40; end def c67; "V.02"; end def f67; @f67 ||= -f42; end def g67; @g67 ||= -g42; end def h67; @h67 ||= -h42; end def i67; @i67 ||= -i42; end def j67; @j67 ||= -j42; end def k67; @k67 ||= -k42; end def l67; @l67 ||= -l42; end def m67; @m67 ||= -m42; end def n67; @n67 ||= -n42; end def o67; @o67 ||= -o42; end def c68; "X.01"; end def f68; @f68 ||= -f43; end def g68; @g68 ||= -g43; end def h68; @h68 ||= -h43; end def i68; @i68 ||= -i43; end def j68; @j68 ||= -j43; end def k68; @k68 ||= -k43; end def l68; @l68 ||= -l43; end def m68; @m68 ||= -m43; end def n68; @n68 ||= -n43; end def o68; @o68 ||= -o43; end end