Natural step by step computation

  • Cells can hold the result and is stepwise by nature.
  • The intermediate result can be referenced by row and column numbers. This is much simpler than the
    traditional scripts.
  • Stepwise computation is not supported in SQL, and thus the computation complexity is increased.
1 =db.query(“select * from Employee”)
Male employees
Employees born in and after 1970
Male employees born in and after 1970
       In the expression”Male”) of cell A2, you can use A1 to directly reference the result of previous step. In the expression A2^A3 of cell A4, the A2 and A3 is directly referenced with the cell name.