ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Version 1.2
2
Your Calculator for value can take up as many tabs as you like, but the last 3 tabs are the format you will use to create a model in the VisualizeROI Platform
3
4
Sheet Descriptions
5
SheetDefinitions
6
VROI_INPUTSVariables that will be inputs to your model. General these come as either pick lists, user selected numerical values, open text fields, orfields set by salesforce, 3rd party data sets, or assumptions that are likely to change over time. Many inputs to the model may not be editable in the UI, but are still inputs for the math to work
7
8
VROI_OUTPUTSThese are numerically calculated fields that must be driven from the the values column in the VROI_INPUTS sheet or value columns in the VROI_OUTPUTS.
9
10
VROI_ENUMSEnumerated variables are simply picklist where each item has a corresponding value. The format for the enum upload is
"item name 0,0##item name 1,1##item name 3,3"
11
12
13
14
Field Details
15
VROI_INPUTSColumn in SheetDescriptionBest Practice
16
VariableName of the Variable Use an descriptive easy to understand name, this will make your model easier to understand and manage
17
ValueThe Default value of the variableSet the default a number you use in your sample model to make QA the VROI_OUTPUT equations easier for you
18
Tab TagThe UI Horizontal Menu Tab in the VIsualizeROI UIYou can change this later in the UI, but if you plan this well after uploading your model you will have a functional prototype UI immediately available for testing
19
Section TagThe Top Level Vetical Nav in UIYou can change this later in the UI, but if you plan this well after uploading your model you will have a functional prototype UI immediately available for testing
20
Category TagThe lower level vertical Nav in UIYou can change this later in the UI, but if you plan this well after uploading your model you will have a functional prototype UI immediately available for testing
21
Tooltipinstructions to a user of the system optional tooltip for the variable, this will only automatically work in the prototype UI
22
Variable TypePick list: Number, String, Enum
23
FormatAmount, Currency, Percentageonly used when Variable Type = Number
24
Decimalthe number of decimal places for the variableUse 0 for the default for any numbers, if the Format is Percentage 99% would have 0 decimals, whule 99.9% would have 1 decimal
25
Minthe min valuerequired for numbers, generally this value is 0
26
Maxthe max valuerequired for numbers, for decimals it is is generally 100, but can be higher if the input can go over 100%
27
Sliderif you want the input to be a slider1 = TRUE make it a slider, 0 = FALSE don't make it a slider
28
Frequency
29
Error Checkused to highlight common errors in the sheetif this field is red, heed the instructions to fix the row
30
31
32
VROI_OUTPUTSColumn in SheetDescriptionBest Practice
33
Variable
34
Value
35
Tab Tag
36
Section Tag
37
Category Tag
38
Tooltip
39
Variable Type
40
Format
41
Decimal
42
Frequency
43
Error Checkused to highlight common errors in the sheetif this field is red, heed the instructions to fix the row
44
45
46
VROI_ENUMSColumn in SheetDescriptionBest Practice
47
Name
48
Descriptionoptional
49
ElementsThe picklist text and cooresponding numerical value (for use in any logic or decisioning). The format uses "," [commas] to separate the text and value, with 2 "##" between pick list items
50
Values
51
Error Check
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100