Hierarchical Spreadsheets
Hierarchical spreadsheets are sets of data cells that are organized into a hierarchy instead of a table of rows and columns. Standard spreadsheets have a table of rows and columns of cells. Hierarchical spreadsheets have a grid of cells for each diagram statement. The cells within a level are like a column in a standard spreadsheet. Their values are used to calculate the value of the cell at next level. 
Features
  • Cell values are calculated using simple arithmetic expressions.
  • Cell types: boolean, currency, date, number, percent, text, time and timespan.
  • Scalar Functions: Abs, Exp, If, Ln, Log, Power, Sqrt,
  • Array functions: Sum, Mul, Min, Max, Or, And, Cnt, SumExpr
  • Statistical functions: Average, Median, Mode, Stdev
  • Time & Date functions: StartDate, EndDate, Duration, Day, Month, Today, Year
  • Grid setup templates