Spreadsheet Inputs (Deprecated)

Warning

Spreadsheet nodes are deprecated functionality and will be removed in a later release of Akumen. This node type can only be used with the v3 calculation engine and is not supported in calculation engine v4.

The SpreadSheet Input node takes values from other nodes in the Driver Model and pushes them into a spreadsheet. It can take any value from any node and transport it into the spreadsheet.

There are two types of ways to put values into the sheet:

  • Fixed; or
  • Timestep.

Input Settings Input Settings

Info

A Spreadsheet Input node will not take any input values until it is connected to a Spreadsheet node. Only once connected will users be able to set where input values go in the spreadsheet.

A Fixed value means that the value does not change over time. The value is set into a cell in the spreadsheet and that it does not populate the other cell values.

A Timestep value is one where a new value can be obtained over a number of time periods. They work best when a Timeseries node is attached to the Driver Model.

The purpose of the Spreadsheet Input node though is to take inputs and push them through to a spreadsheet. You cannot edit the spreadsheet in this node, only supply where inputs need t go into the spreadsheet.

To step up a Spreadsheet Input node:

  1. Drag a Spreadsheet Input node using the symbol onto the workspace. Spreadsheet Input Node Spreadsheet Input Node
  2. Attach your input to the Spreadsheet input node.
  3. Double click on NaN on the bottom left of the node.
  4. The input spreadsheet will open. Spreadsheet Input Spreadsheet Spreadsheet Input Spreadsheet

If the input is a fixed value:

  1. Select Fixed at the top of the spreadsheet.
  2. Select the cell on the spreadsheet you wish you enter your value into.
  3. Click the Set button.
  4. The fixed value will now be set to that cell. Fixed Value Fixed Value

If the value is a timestep value:

  1. Select timestep at the top of the spreadsheet.
  2. A list of options will appear. Timestep Options Timestep Options
  3. Select a cell on the spreadsheet where you want your starting value to be set.
  4. Select from the three options:
    • Not Set
    • Left to Right
    • Top to Bottom
  5. Then Select Set.
  6. The timestep values will then be assigned to that selected row or column. Timestep Input Timestep Input
  7. Use the timeslider at the bottom of the screen to step through time - the calculated values for each timestep will populate the cells. Timestep values Timestep values