Layout

Description

Simple

Each row within the worksheet represents an element. Each column represents a field value that will be given to that element. A single Excel spreadsheet can contain any number of simple tables.

Hierarchy

This format lets you import data that has a hierarchical structure. The structure is reproduced within the element tree.

Hierarchy &
Metric Grid

The hierarchy & metric grid format combines the individual formats to allow more complex worksheets to be interpreted.

Metric Grid

This format lets you import data that is structured as identifiable primary elements with a grid of data against each.

Multi Tab

This is essentially the same as the Simple layout, except that the data structure is replicated across more than one tab in the source spreadsheet.

Multi Tab &
Metric Grid

The multiple tab & metric grid format combines the individual formats to allow more complex worksheets to be interpreted.

Detail Columns

The detail format allows two tables to be laid out side by side where a relationship exists between them based upon the positioning of the records.

Matrix Import

The matrix import format allows a previously exported MooD matrix to be re-imported. The format is configured to automatically recognize the MooD matrix layout and correctly identify hierarchies of items.

Link Table

The Link Table format allows a simple table containing just two columns to be imported.
The two columns can contain duplicate values, which makes it ideal for importing relationships between different records.

Self to Self
Link Table

The link table self to self format allows the import of a table in which the first two columns represent the two end points of a relationship, where the end points are of the same type.
Further columns can specify qualities of the relationship.

Epoch Grid

The epoch grid format allows a table of epoch data to be imported.
The table of epochs are compressed into two columns: 'Epochs', and 'Values', providing a row of data per epoch value.

MooD Measure Instances

This layout lets you import measures. It creates a record description that you can use with the Measure Instances target.

Parent and Child

The parent child format allows two tables to be laid out side by side, where one table dictates the parents and the other the children. This allows for different element types to be created within MooD.

Denormalized

The Denormalized format allows multiple tables of data to be combined in non-contiguous ranges. Ideal for handling data from a database.