Skip to content

Prepare your data

Download the WaMDaM Workbook

Templates for Input Data to prepare your data into it. Each dataset into one workbook

Download Use it for
WaMDaM Workbook Template Download Generic template for any data source to WaMDaM

Data Preparation Utility

Download Use it for
Prepre shapefile template Download Transform the shapefile columns into WaMDaM sheets
Prepare time series template Download Transform time series data into WaMDaM sheets
Prepare seasonal data template Download Transform seasonal data into WaMDaM sheets

Why Excel?

We chose Excel as a generic input data medium with a custom Excel workbook that has 17 sheets with fixed column headers for the main tables of input data in WaMDaM. Each dataset is prepared to a single workbook one-at-a-time. The sheets are related with each other through dropdown lists to help users for example to relate metadata elements to the attributes and data values

The Wizard maps all the bridge tables’ complex relationships and users do not need to know anything about primary or foreign keys.

Preprare data order

First: Load the controlled vocabulary or leave them blank.
Controlled vocabulary are available in the template workbook and users can update them in a button on the workbook’s homepage sheet. The button calls the online registry application user interface and updates the list of vocabularies in the sheet. Then the CVs are available as dropdown lists in each sheet where they apply.

Second: Define metadata that will be used for the Attributes and Instances.

Third: Define the data structure of Object Types and Attributes.

Fourth: Add the master network, scenario, and nodes and links.

Fifth: Load data values to each attribute of each Instance.

Simple case

Users have to populate at least six sheets for any dataset and they can populate more as the complexity of the dataset increases. In a simple case, the three sheets of Organizations&People, Sources&Methods, Networks&Scenarios can be populated with only two rows each.