Create statistical accounts
You can manually create your statistical accounts as models, add model lines, and incorporate them into your budget from the Statistical Accounts section of the Inputs > Model tab.
You can customize and reorganize your lines to improve both readability and the manner in which you work with models and statistical accounts. For more information, see Customize your model lines.
Manually create statistical accounts
To manually create statistical account models and model groups:
-
From Inputs > Model, in the Statistical accounts section that appears in the navigation pane, click the plus icon
.
-
Select one of the following:
-
Add new - Adds a new model
-
Add new group - Adds a group of models
-
-
Type a name for the statistical model or model group.
-
If you chose Add new, a new model is added to the navigation pane under the Statistical Accounts section.
Do the following:
-
Click + Add assumption to add your assumptions, values, and comments.
-
Click + Add model line. A flyout window opens where you can name, define, and customize your model line. Click Save and Close when you're finished.
-
Add dimension values to the Dimensions sections and click Save.
-
-
If you chose Add new group, the + Add Model button and Dimensions sections appear.
Do the following:
-
Click + Add Model. The models you add appear in a preview pane of the model group window with the model lines they contain.
-
Add assumptions and model lines from the model window as follows:
-
Click + Add assumption to add your assumptions, values, and comments.
-
Click + Add model line. A flyout window opens where you can name, define, and customize your model line. Click Save and Close when you're finished.
-
-
Add dimension values to the Dimensions sections and click Save.
Dimensions values you define at the group level are automatically inherited by the models you add to the model group.
-
Manually add a model line to a statistical account
To manually add a model line to a statistical account model:
-
Select a model in the Statistical accounts section and click + Add Model Line. A flyout window opens where you can name, define and customize your model line.
-
Click Save and Close.
The model line is added to your model.
Incorporate statistical accounts to your budget
To base your model line calculation on a statistical account and add it to your budget:
-
From the model in the Statistical accounts section of the navigation pane, click the model line you want to include in your budget. A flyout window opens.
-
In the Amount field, click the function icon
to display the formula editor, or press the equals key (=) on your keyboard.
In the formula editor window, you first see the model section with their assumptions and model lines available in your current model (the model that you’re working in, or “this model”), and then the statistical accounts section.The amount field must be in a currency format to add it to your budget.
-
Click the statistical account labels to incorporate them into your formula and click Done.
-
Green checkmark
- Shows that your formula is valid
-
Grey checkmark
- Shows that your formula is invalid
-
Click the X to delete the equation
-
-
Click Add to budget. The Add model line to budget window opens.
-
Select where in the budget tree you want to create your new budget line and click Confirm. In Inputs > Main, your new budget line now appears in the budget tree.
To learn more about how to use the formula editor to calculate values in assumptions and amounts in model lines, see Use the formula editor in models.
In this topic