Time grid

The time grid attribute is useful for financial planning. For example, you can use it to calculate costs and revenue for a business case.
Using time grid attribute, you can:

A time grid attribute consists of one or more sheets with individual time lines. Each sheet displays a grid with its time line as column headings and a common set of row titles.

Time grid sheet
Each sheet is configured for a specific scenario, with a name, time interval (month, quarter, or year), start date, and end date. A time grid attribute can have multiple sheets, each with an individual time line and cell values. The cells can be empty or can contain a number or an expression. You can use numbers, and expression for time grid cells. You can reference the first and the last column with date attributes.

The time grid attribute can initially be configured with summary rows, headings, and locked rows. Summary rows are headings that display the sum of the cell values of all of the rows below the heading until the next heading is displayed. The summary rows are always locked.
Tips:
  • Avoid configuring a time grid attribute with the summary row that is placed as the last row. Summary row is used to sum the values of rows below the row until the next header row. The rows that are above the summary row are not considered.
  • A time grid displays entire time intervals, even if the start and end dates of a sheet are in the middle of the interval. For example, if a sheet is configured to display quarters and the end date is 2 April, the entire time period (in this case the quarter) is displayed in the sheet.
  • You can select a number of cells in a sheet and paste them into a spreadsheet application or in another position in the current time grid sheet.

Time grid limitations

The time grid attribute has the following limitations:

Feedback