Its possible to create decisions and tables in spreadsheet format and then import them directly into BizVR.

To do this, the spreadsheets need to be in a specific format.

Here's an example

• There must be one sheet for each decision table. The sheet name will be used as the decision table name
• (maybe the name should start with DT so its clear which are decision tables and which are other stuff)
• row 1 must contain the names of the variables and no extra row for allowable values
• rows 1 thru n must contain the values of the conditions and actions.
• row n+1 column A should contain the word Input to signify the end of the table
• strings need to be in single quotes eg 'red' (note Excel won't display the initial quote)
• VV will still work without the quotes but it may think the string is the name of a variable rather than a literal value and flag an error)
• Discussion point: do we need the quotes (VV needs to distinguish literal string from variable names)
• no merged cells
• ranges as [x..y]
• must use >=, <=, <> (not the excel condensed symbols)
• don't care conditions should be indicated by an empty cell not -
• other should be used instead of otherwise (to indicate any value not explicitly mentions in the rule
• Cells must be color coded to indicate what they represent: (green E2EFDA for conditions, orange FFFFC000 for actions)
• There must be one sheet named "Input-Output" that lists all the decision inputs and outputs and their data types.
• Intermediate attributes do not need to be listed (unless they are to also be decision outputs)
• Grey (informational columns should come AFTER the green and orange table definition (DMN standard)
• The first grey column after an orange column will mark the end of that rule definition