ValQ - Plan
FormulaProductChangelogStart Trial
  • Introduction to ValQ
    • Get ValQ
    • The ValQ Workflow
  • Model
    • Get Data
    • Create Model
      • Dynamic Model
      • Custom Model
      • Import a Model
    • Model Editor
      • Node Operations
      • Editor Features
    • Node Settings
    • Templates
      • Apply Template
      • Manage Template Nodes
      • Import Template
      • Export Template
    • Formula Functions
      • Logical Functions
        • IF
        • SWITCH
        • AND
        • OR
        • NOT
        • XOR
        • IFNAN
      • Math Functions
        • SUM
        • SUBTRACT
        • PRODUCT
        • DIVISION
        • AVERAGE
        • AVERAGEEXZERO
        • AVERAGEEXNEG
        • AVERAGEEXZERONEG
        • COUNT
        • ABS
        • MIN
        • MAX
        • POWER
        • SQRT
        • EXP
        • LOG
        • ROUND
        • FLOOR
        • CEILING
      • Finance Functions
        • IRR
        • NPV
        • PMT
        • IPMT
        • FV
        • PV
        • CUMIPMT
        • CUMPRINC
        • RATE
      • Range Functions
        • RANGE
        • LastNPeriods
        • Get
        • ForEach
        • findByTitle
        • GETCURRENTRANGE
        • GETROWVALUE
        • THIS_SOURCE_KEY
        • PERIOD_LOOKUP
        • PRIOR_SERIES_PERIOD_LOOKUP
      • Static Identifiers
        • THIS/ME
        • CURRENT_SERIES*
        • CURRENT_SERIES_ID*
        • CURRENT_PERIOD_INDEX
        • CURRENT_NODE_VALUES
        • DS.SERIES
      • Node Properties
        • Node Properties Explanation
    • Global Settings
  • Plan
    • Create New Plan
    • Time Series Forecasting
    • Allocation Features
      • Goal Seek
      • Distribute
      • Copy to Periods
    • Driver Based Planning
      • Enabling Driver Based Plan
      • Configuring Driver Inputs
      • Bulk Configuration of Drivers
    • Plan Interface
  • Simulate
    • Create a Scenario
    • Perform Simulations
    • Manage Scenarios
    • Simulation Interface
    • Add Notes
    • Compare Scenarios
    • Scenario Analysis by Node
    • Create Initiatives in a Scenario
      • Steps to create initiatives
    • Create your Presentation
    • Understanding the Node Components
  • Report
    • Variance Analysis Report
  • ValQ Premium FAQs
  • Glossary
  • Resources
  • Release Notes
Powered by GitBook
On this page
  • 1. Create a Scenario
  • 2. Views
  • 1.1. Tree View
  • 1.2. Table View
  • 3. Manage View
  1. Simulate

Create a Scenario

PreviousSimulateNextPerform Simulations

Last updated 1 year ago

Scenarios are particularly useful when you want to perform what-if analysis on the model, and you can save each instance as an individual scenario. This way, you have multiple scenarios to analyze and conduct scenario analysis.

A scenario can have a single driver node or multiple driver nodes simulated at once.

To simulate multiple combinations of drivers and evaluate their possible outcomes by adding, removing, or combining the required combinations, you can use initiatives within a scenario. To learn more, click

1. Create a Scenario

On opening the Simulate tab, the default scenario named Scenario 1 is available without any simulations performed on it.

To create a new scenario, click on the + Add New Scenario option.

This opens the Create New Scenario pop-up window where you can enter a title for your scenario and select the baseline series on which the simulations will be performed. Click Create which opens the new scenario.

A plan series can however be simulated on the Simulate tab as a baseline or as a comparison.

2. Views

With ValQ, you can build a model of your business process and view it in the form of a tree as well as a table.

Toggle between the below icons present on the top right corner of the canvas to change the view.

1.1. Tree View

The tree is presented in a horizontal format as a visual. Its structure begins with a single node called Top node/ Root node and this node then branches out to other nodes as children/ descendants.

In the below image, the model is segmented into levels starting from level 1 with the Top node named 'Total Net Profit'. The nodes share a parent-child relationship at each level. For example, the 'Total Net Profit' node is the Parent node while 'US' node, 'Asia' node and 'Europe' node are its child nodes. Similarly, the 'US' node is the parent of 'Clothing' and 'Beverages' nodes and so on.

Click on > to expand and < collapse levels. Following are the options available to search and drill through the model.

  • Go to level option to navigate between different levels.

  • Search option to search and get to a particular node.

  • Zoom icon to zoom in/out of the canvas.

  • Full or minimal view option for the nodes.

1.2. Table View

The same information can be viewed in tabular form as seen in the image below. The total value of a node can be simulated on the Table view to view the results. This view is preferred if you want to see more details about the nodes especially the simulation impact and the variances at the period level.

Table View also has Search and Filter options to search for and filter the required nodes.

3. Manage View

In both tree and table views, you can display or hide a few details like variance, variance%, simulation impact%, trendlines, conditional formatting, secondary KPIs, etc. using the Manage View option at the top of the toolbar.

In the next section, we'll see how to simulate the scenarios.

You can now perform your desired simulations here. To learn more about managing the scenarios that you have created, click .

Scenarios are not stored as data series that can be used for further planning and analysis. Use the Tab for such cases.

Click on the table icon to go to the Table View. Observe the simulation slider available on Total cell of 'Other Income' node.

You can also view the simulation results for the full year or the simulation period from this menu. Click to learn more about it.

If you want to understand the components present in the node, you can refer to this section:

here
Plan
Understanding the Node Components.
here.
here
Create a Scenario
Click 'Create'
Scenario 2 is created
Click the required icon to switch between the views
Click this for Table View
Click this for Tree View
Tree Model
Display Options & Navigating to the Nodes
Table View
Search and Filter
Manage View - Tree View
Manage View - Table View
Create a Scenario
Scenario 2 is created
Click the required icon to switch between the views
Display Options & Navigating to the Nodes
Table View