Change log

Version 1.4.1

• Change the color of documentation group with a drop-down menu in the group header in the model map. Initially limited to 5 predefined colors.
• Excel Tables that are connected to Excel Output components now check the space around them (below and to the right) and will not update if there's not enough empty cells to expand. This comes with a warning message to the user.

• Validate component displays a message if no data quality check is available, i.e. when no dimension is selected.
• Excel Input Assumption component now has the same data quality checks as the Validate component.

• Added tutorial for using River data in Excel.
• Added reference article for structured references in Excel formulas.

• Added option for verbose logging to the Engine, writing the contents and schema of all tables to the log after each operation, to help with debugging. Enabling this option is only available in code for debugging for now.
• Added engine error message to the data quality checks error message in the UI in case they fail in the engine.

Version 1.4

• Filter component now includes Expression editor similar to the Formula component, with syntax highlighting, error highlighting and auto-complete for column names.
• Window component no longer requires an expression to be provided
• Output tables in Excel now do not apply sampling

• Header above tables display data limit if applied (shown in red)
• Sampled data displays header in orange
• Configuration check added to ExcelOutputSelectNodeViewModel to ensure at least one column is selected

• Configuration errors computed and displayed consistently across all components in the configuration panel

• Theme update:
  • Flow editor interface restyled
  • Updated colors for nodes to identify inputs, assumptions and outputs
  • Group colors updated
• Renamed "Cumulative Formulas" to "Cumulative Aggregations"
• Consistent UI layout for configuration of all components using grid controls.

• Added sampling information in Tutorial 4
• Added undo-redo information in Tutorial 1
• Minor inconsistencies in documentation.

Version 1.3.2

Version 1.3.1

• Dark theme: fixed issue causing Excel crashes when switching from a component to another in the configuration panel.

Version 1.3

Visual improvements

Features

Data sampling and row count

Information on the model map

Usability improvements

- Batches updates to Excel Tables before running the model (150ms interval) to avoid multiple refreshes when making several changes in a short period of time.
- Auto resize columns only on temporary sheets, not output sheets, to keep formatting stable in output sheets.

Fixes

Version 1.2.1

Features

• Added tutorial files to help users get started with River for Excel

Fixes

• Components are marked as Invalid if an upstream component's status is Initialized (i.e. not connected or properly configured) for consistency.

Version 1.2

Features

New components

• Excel Output Select, which becomes the default Excel Output component in River for Excel:

  • Allows to select and order columns before output, keeps the position of columns fixed unless user changes them
  • Button to sync output with input columns if output column list is empty
• Sort: sort a table using a prioritized list of columns, where sorting can be ascending or descending.
• Transpose: select a column whose values will be pivoted to become the column headers, and select columns which will be unpivoted into rows
• Valuation: calculates NPV using a cashflow, date and discount rate inputs, with an option to set the horizon start.

Usability improvements

• Formula:

  • Expand column and expression boxes automatically
  • Implement undo
  • Show list of identifiers ordered by column name and show column identifier without quotes
  • Formula boxes keep focus when inserting a column from the autocomplete window
  • Update formula editor syntax color scheme
  • Allow autocomplete window to size to show the full identifier name
• Forecast: if dimensions exist in the input, it will use their combined unique values to generate future rows. Future rows will be generated by looking at unique values in the base year only.
• Lookup, Breakdown (all components using a JoinNode) now remove their joining columns from their output by default. LEFT joins (the default) and INNER joins exclude the right joining columns, where RIGHT joins exclude the left joining columns.
• Components are now pasted by default in the middle of the model map window
• Summarize: now detect naming conflicts only with aggregation columns (allows to overwrite an input column)
• Add a "Trace dependents" highlight feature via right-click menu
• Scenarios: add a "bring into view" feature by clicking on the assumption name

Excel integration

• Add setting to hide unused columns in output. Setting currently works on Formula, Lookup and Breakdown nodes. Add omitted columns in temporary table headers
• Add setting to hide or display inputs in temp sheet views
• For input, outputs and assumption nodes, Ribbon buttons allow to create a new sheet or insert a Table in an existing sheet

Visuals

• Update text and visuals in configuration panel for clarity
• Make documentation group header/comment borders disappear when not selected or hovered to enhance clarity
• Move connection data in a hover tooltip
• Default Zoom level set to 1.0
• Zoom level and graph position in the model map now saved in the model
• Lookup, Breakdown, Excel Output, Forecast horizon, Sort and Transpose use new UI to display configuration errors

Backend

• Move application temporary data path to Local (instead of Roaming)

Fixes

• Paste connected nodes restored after XML connection structure changes
• Breakdown and Lookup "Non matches" check state (enabled/disabled) is now saved
• Now prevent a refresh of all components when a component is pasted
• Now runs new components once on creation to ensure validation errors are shown
• Undo/Redo for nodes works correctly in Excel
• Temp sheet now picks a different name if name already exists
• Properly reconnect Excel Tables when loading a model from XML in Excel
• Refresh scenarios when a Scenario component is added after an assumption component and if an assumption component is deleted
• Assumption components would be confused if using their option column name was the same
• Changing option for assumptions caused dropdown to show empty in some cases

Version 1.1.4

Visual improvements

• Hide "Dimensions" and "Master Dimensions" in Validate summary templates if no column is selected with these settings
• Hide "New dimensions" in summary templates for Lookup and Breakdown
• In zoomed out mode, nodes in error state show a red border with red semi-transparent background

Fixes

• Creating a new Excel Table, which triggers creation of an ExcelInputValidate node, now triggers an initial data load
• "New Dimensions" summary text in Lookup and Breakdown now refresh on node run
• If a temp sheet name conflicts with an existing sheet, it chooses a non-conflicting name

Version 1.1.3

Features

• Undo/Redo functionality, currently limited to model map actions.

  • Covers adding, deleting, moving components, resizing groups, adding/removing connections, and editing group comments/headers.
  • Undo/Redo buttons in the ribbon.
• Added export map to PDF functionality accessible from the ribbon, display the full map details even if zoomed out

• Updated components

  • Unpivot: category column is automatically a dimension
  • Scenarios: clicking the Scenarios button in the ribbon opens the Scenarios panel, even if the component is not selected in the model map
  • Formula: upgrade formula edit boxes with syntax highlighting, auto-complete column names with auto-quoting, error highlighting, and explicit save/cancel and buttons better documentation

• New components

  • Combine scenarios: runs the model once for each scenario and assemple all versions of a table with a union.
  • Forecast horizon: adds a forecast horizon column to a time series table and adds base values for the whole period.
  • Excel Input Validate: combines Excel Input and Validate in a single component, with columns selected by default.

Bug Fixes

• Union: output columns are now properly set based on the result of the union operation.
• In some cases, reloading a model from file didn't reconnect some Excel Tables properly.
• Deactivated auto-selection of column in Validate (when clicking the dimension checkbox) and Assumptions (when clicking Assumption or Set point checkboxes) to avoid issues when reloading a model from file.
• Data quality checks on column names with special characters are now working.
• Each component now triggers a full calculation (a SELECT in the database) so that all errors are now propagated to the UI (at the cost of slightly slower speed).

Visual Improvements

• Temporary sheets reset view to top left when opened.
• Display zoomed out node in red if error, otherwise display node category color as in footer if zoomed in.