Create a Simple Flattened Excel

Overview

A flat file has a table-like structure and consists of rows and columns where data is stored as plain text. Each row represents a single record while each column represents the different attributes of that particular record.

Compared to creating a generic Excel, creating a flattened Excel is a laborious process and is possible only if you have full details as found in research reports, studies, etc.

Step-by-Step Guide

Open an Excel document create four sheets and name them VROI_INPUTS, VROI_OUTPUTS, VROI_ENUMS, and VROI_VLOOKUP respectively.
Provide all input values under the different fields in the VROI_INPUTS sheet as seen in the Instruction sheet in the VROI Flat File Model.

Insert the column Code Reference just after the Variable Column to provide an identification code for the variable. The format of the code is ''name of the variable - IN2'' where IN refers to Input while 2 refers to the second row.
Enter calculations in the VROI_OUTPUTS sheet.
Add ENUMS and VLOOKUP, if required.
To upload the flat file, follow the steps to Upload your Model/Create a Visualizer Type.

Note:

Ensure to provide your variables with names that are unique, short and clear.
Avoid characters =, <, >, and + when naming variables as it will cause an error in the Blockly.
Avoid special characters like & and abbreviations like etc. when naming variables.