# coding: utf-8 # I class Sheet5 < Spreadsheet def a1; "I"; end def b1; @b1 ||= sheet4.c8; end def b3; "工业"; end def c4; @c4 ||= sheet1.c5; end def c7; 2010.0; end def d7; 2015.0; end def e7; 2020.0; end def f7; 2025.0; end def g7; 2030.0; end def h7; 2035.0; end def i7; 2040.0; end def j7; 2045.0; end def k7; 2050.0; end def b8; 1.0; end def c8; 1.0; end def d8; 1.0; end def e8; 1.0; end def f8; 1.0; end def g8; 1.0; end def h8; 1.0; end def i8; 1.0; end def j8; 1.0; end def k8; 1.0; end def b9; 2.0; end def c9; 10.0; end def d9; 10.0; end def e9; 10.0; end def f9; 10.0; end def g9; 10.0; end def h9; 10.0; end def i9; 10.0; end def j9; 10.0; end def k9; 10.0; end def b10; 3.0; end def c10; 100.0; end def d10; 100.0; end def e10; 100.0; end def f10; 100.0; end def g10; 100.0; end def h10; 100.0; end def i10; 100.0; end def j10; 100.0; end def k10; 100.0; end def b11; 4.0; end def c11; 1000.0; end def d11; 1000.0; end def e11; 1000.0; end def f11; 1000.0; end def g11; 1000.0; end def h11; 1000.0; end def i11; 1000.0; end def j11; 1000.0; end def k11; 1000.0; end def b17; "选择"; end def c19; 2010.0; end def d19; 2015.0; end def e19; 2020.0; end def f19; 2025.0; end def g19; 2030.0; end def h19; 2035.0; end def i19; 2040.0; end def j19; 2045.0; end def k19; 2050.0; end def b20; @b20 ||= c4; end def c20; @c20 ||= index(a('c8','c11'),match(c4,a('b8','b11'),0.0)); end def d20; @d20 ||= index(a('d8','d11'),match(c4,a('b8','b11'),0.0)); end def e20; @e20 ||= index(a('e8','e11'),match(c4,a('b8','b11'),0.0)); end def f20; @f20 ||= index(a('f8','f11'),match(c4,a('b8','b11'),0.0)); end def g20; @g20 ||= index(a('g8','g11'),match(c4,a('b8','b11'),0.0)); end def h20; @h20 ||= index(a('h8','h11'),match(c4,a('b8','b11'),0.0)); end def i20; @i20 ||= index(a('i8','i11'),match(c4,a('b8','b11'),0.0)); end def j20; @j20 ||= index(a('j8','j11'),match(c4,a('b8','b11'),0.0)); end def k20; @k20 ||= index(a('k8','k11'),match(c4,a('b8','b11'),0.0)); end def b25; "结果"; end def c26; @c26 ||= c20*sheet3.c5; end def d26; @d26 ||= d20*sheet3.c5; end def e26; @e26 ||= e20*sheet3.c5; end def f26; @f26 ||= f20*sheet3.c5; end def g26; @g26 ||= g20*sheet3.c5; end def h26; @h26 ||= h20*sheet3.c5; end def i26; @i26 ||= i20*sheet3.c5; end def j26; @j26 ||= j20*sheet3.c5; end def k26; @k26 ||= k20*sheet3.c5; end def b31; "编号"; end def c31; "2010"; end def d31; "2015"; end def e31; "2020"; end def f31; "2025"; end def g31; "2030"; end def h31; "2035"; end def i31; "2040"; end def j31; "2045"; end def k31; "2050"; end def b32; "T.1"; end def c32; @c32 ||= c26; end def d32; @d32 ||= d26; end def e32; @e32 ||= e26; end def f32; @f32 ||= f26; end def g32; @g32 ||= g26; end def h32; @h32 ||= h26; end def i32; @i32 ||= i26; end def j32; @j32 ||= j26; end def k32; @k32 ||= k26; end def b33; "合计"; end def c33; @c33 ||= subtotal(109.0,sheet5.a('c32','c32')); end def d33; @d33 ||= subtotal(109.0,sheet5.a('d32','d32')); end def e33; @e33 ||= subtotal(109.0,sheet5.a('e32','e32')); end def f33; @f33 ||= subtotal(109.0,sheet5.a('f32','f32')); end def g33; @g33 ||= subtotal(109.0,sheet5.a('g32','g32')); end def h33; @h33 ||= subtotal(109.0,sheet5.a('h32','h32')); end def i33; @i33 ||= subtotal(109.0,sheet5.a('i32','i32')); end def j33; @j33 ||= subtotal(109.0,sheet5.a('j32','j32')); end def k33; @k33 ||= subtotal(109.0,sheet5.a('k32','k32')); end end