Organizing Spreadsheets

Create a new spreadsheet group

Description	Illustration
Create a new group by right clicking on the root node or an existing group, and select Add New Group from the context menu. The new group is created as a subgroup under the group that was selected.
The new group will by default be called the name of the parent + subgroup + then number of subgroups. The new group will initially be editable and you can type an appropriate name.

Rename a group

Description	Illustration
The model group name becomes now editable, and a new name can be entered.
The group name becomes now editable, and a new name can be entered.

Create and Import Spreadsheets

New spreadsheets can be created within the MIKE Workbench as well as be imported from files (e.g. Excel format files).

Create a new spreadsheet

Description	Illustration
Right-click the root node or a group node and select “Add New Spreadsheet”
The spreadsheet is created in the database and added as a sub-node to the active group. When created the name of the sheet is editable allowing the default name to be changed.

Import a spreadsheet

Description	Illustration
Right-click the root node or a group node and select “Add New Spreadsheet”
A standard File Open dialog appears for selection of th file. Three standard formats are supported. Select the file and click Open.
Upon successful import the spreadsheet in the MIKE Workbench is named after the file and represented by an new node in the active group.

Rename a spreadsheet

Description	Illustration
Right-click the spreadsheet to rename and select “Rename”.
The text in the node becomes editable. Change the text and press enter. To cancel editing press Esc.
After changing the name the node is placed alphabetically within the group.

Copy a spreadsheet

Description	Illustration
Right-click the spreadsheet and press “Copy”. Alternatively selected the node and press keys Ctrl+C. This will put the spreadsheet into the clipboard. Copy can be performed on multiple spreadsheets at a time as well as on a group or groups.
Right-click a group node and select “Paste”. Alternatively select the group and press keys Ctrl+V. This will insert the spreadsheet in the clipboard into the selected group. The option is only available if a spreadsheet is available in the clipboard.
If the group is new – or collapsed – the new spreadsheet node will be ‘hidden’. Click the plus-sign (‘+’) next to the node to reveal the content of the group.
The group unfolds.
An automatic ally created unique name simply adds a counter to the original name.
Copying a group (or groups) is similar – only then the whole branch (or branches) are copied to the new location.

Move a spreadsheet

The moving of a spreadsheet between groups is carried out as a combination of Cut and Paste operation.

Description	Illustration
Right-click the spreadsheet and press “Cut”. Alternatively selected the node and press keys Ctrl+X. This will put the spreadsheet into the clipboard. Cut can be performed on multiple spreadsheets at a time. The Cut-option is only available if all the selected spreadsheets are not open.
Right-click a group and select “Paste”. Alternatively select a group and press keys Ctrl+V. This will insert the spreadsheet in the clipboard into the selected group. The option is only available if a spreadsheet is available in the clipboard. Note the spreadsheet that was cut is indicated with a dimmed grey font. From here on the behavior is similar to that of the Copy Spreadsheet action.

Delete a spreadsheet

Description	Illustration
Select a group, multiple groups or multiple spreadsheets. Right-click and select “Delete”. All the selected objects will be deleted from the database and removed from the explorer. Only group(s) at same level can be selected together.
The delete operation must to be confirmed via a pop-up dialog.

Working with Spreadsheets

Opening a spreadsheet

Description	Illustration
Right-click a spreadsheet and select “Open” - or simply double-click the spreadsheet in the Explorer
The spreadsheet opens

MIKE Workbench spreadsheet menu and toolbar

An open spreadsheet can be manipulated through tools available from toolbar above the spreadsheet.

The buttons and menus in the toolbar are:

Description	Illustration
Save It saves the spreadsheet to the database.
Cut/Copy/Paste These standard actions work on selected items in the spreadsheet, e.g. text, formulas, cells, formats, plots.
Functions This button is a quick access to the most common spreadsheet functions to insert into a cell. The “Mode functions…” option opens a standard search dialog for available functions where they are grouped in different ways.
Format The Format button gives access to various options for formatting cells, rows, colums, sheet. “Cells…” and “Conditions…” both give access to a general formatting dialog.
Chart The chart button quickly generates a chart from the data in selected cells and the choice of Chart. Once created the chart can be modified/customized via the Chart Explorer accessible via a righ-click menu on the chart.
To Database The “To Database” button allows the values of a proper formatted range of cells to be stored in the database as a new time series. The option enters a wizard for: Selecting the range of cells Specifying the group path and time series name in the database Specifying the time series type and unit ending with a confirmation page.

SpreadsheetGear menus

The special spreadsheet functionality is available through some right-click. menus.

Cell or Range

Description	Illustration
Right-click a cell This will open a general menu for manipulation of the selected cell.
Choosing the “Workbook Explorer…” menu item (or double clicking the tab-section of the spreadsheet)
Choosing the “Range Explorer…” menu item will open a dialog for manipulating the details of the selected range of cells

Chart

Description	Illustration
Right-click a chart This will open a menu for manipulating the chart object.
Choosing the Chart Explorer Opens a dialog giving access to properties of the chart details.

MIKE Workbench scripts

Scripts build with the Script Manager will appear as functions accessible to the spreadsheet as the buil-in SpreadsheetGear functions and the MIKE Workbench functions.

A script defined as shown below in the Script Manager defined a function named “MyFunction”. It simply returns the value 23.5

In a spreadsheet the function appears when typing the equal sign “=” followed by the initial letters of the function name in a cell:

Selecting the function with the mouse

The function call is completed with the end-parenthesis (no arguments are required in the function call). Pressing enter evaluates the function

Saving spreadsheets

A modified spreadsheet is indicated by the asterix next to the title in the Tab. Closing the sheet by pressing the “x” (or right click on the tab choosing Close or pressing Ctrl+Shift+C) will pop-up in a confirmation dialog as this:

The same will happen if you close the MIKE Workbench entirely with open modified spreadsheets.

Exporting a spreadsheet

Spreadsheets can be exported into external files.

Description	Illustration
Right-click a spreadsheet in the explorer and select “Export spreadsheet…”
A “Save As” dialog is shown and a filename must be specified. The spreadsheet can be saved in various formats which must be selected.