# coding: utf-8 # Outputs class Sheet1 < Spreadsheet def a1; "Result"; end def b1; @b1 ||= sheet2.a1; end def a2; "Input"; end def b2; @b2 ||= sheet3.a1; end def b3; @b3 ||= sheet2.c9; end def b4; "Doesn't depend on an input"; end def a6; "Indirect value:"; end def b6; @b6 ||= sheet2.a17; end def a8; "Indirect table"; end def b8; @b8 ||= sheet2.a('c22','c22'); end def a9; "table1"; end def b11; "B"; end def a13; "Indirect table 2"; end end