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
  • Action Menu Bar
  • 1. Standard Plan/Driver Based Plan
  • 2. Forecast
  • 3. Copy to Periods
  • 4. Distribute
  • 5. Goal Seek
  • 6. Lock/Unlock Cell
  • 7. Number Formatting
  • 8. Reset
  • 9. Logs
  • 10. Notes
  • 11. Export to Excel
  • 12. Refresh Data
  • 13. Settings
  • 14. Search
  • 15. Filter
  • 16. Autofit
  • 17. Display Settings
  • 18. Formula Bar
  • Actions Column
  • Bottom Pane
  1. Plan

Plan Interface

PreviousBulk Configuration of DriversNextSimulate

Last updated 1 year ago

The Plan tab consists of 3 sections - Action Menu bar at the top, data table grid and the bottom pane.

Allocation features available on the data grid and driver-based planning have been explained in the previous sections. Let's now explore the Action menu bar and the bottom pane which has additional options to fine-tune your plan series.

Action Menu Bar

1. Standard Plan/Driver Based Plan

Switch between standard planning and driver-based planning using this menu option.

Allocation features used for a standard plan as well as the driver based planning have been explained in the previous sections.

2. Forecast

3. Copy to Periods

4. Distribute

5. Goal Seek

6. Lock/Unlock Cell

Click on any cell, row, or column that you want to lock. Then click the Lock option in the menu bar. Locked cells do not get affected by any of the allocation methods.

In this example, US node is locked which is indicated by its graying out and lock symbol. US node and all its children would be unaffected by any allocations that would be done in the future.

To unlock, simply click on the locked cells and select Unlock.

You can also lock or unlock by clicking the lock icon in the action column as highlighted in the below image.

7. Number Formatting

It is used for changing the scale and to increase or decrease decimals for nodes whose Scale property is set as User selected.

8. Reset

Reset is used to undo the last change made. Click Reset and a confirmation to revoke the last made change appears which you can confirm or cancel.

Use the drop-down arrow next to it to click Reset All which clears all the performed changes and resets to the initial state of the plan series.

9. Logs

It preserves a log of all the changes made to the table along with the date and time of change.

Click Logs to open the logs. You can search, view, select and highlight, or delete the specific changes in the log. Click on Clear Logs to clear all the logs.

10. Notes

Select any cell and click Notes to add new notes. After adding a note, click Save to save it.

Cells with added notes are distinguished from other cells by a triangular mark at the top right corner as shown below. On hovering your mouse over the cell, you can view, edit or delete the notes.

To view all the added notes at once, click the Show All Notes option from the Notes menu.

Here, you can search, edit, or delete the added notes.

11. Export to Excel

12. Refresh Data

In case of any changes to the input data, Refresh Data can be used to update the plan report as that of the source data. On refresh, the plan gets updated and the allocation performed on the plan gets re-applied to the recent data.

On clicking Refresh Data, a confirmation pop-up appears.

Click Confirm to re-run the calculations on the recent data.

Refresh Data option is available only when the user chooses to keep the source data in the report (Checked 'Keep Source Data in Report' option).

13. Settings

Click on this option to update the closed period. This option lets the user update the actuals, close the current period and update the active/open periods.

14. Search

Search for any node on the model by clicking the Search bar. After clicking, enter the text using which you want to search the nodes. The search result nodes are highlighted and the results dropdown displays the results which navigates to the highlighted nodes.

15. Filter

Disable All can be used to toggle between the states of filter and no filter. Clear All will delete all the applied filters.

16. Autofit

You can auto-size the tabular columns to fit the visual window size for a better view by clicking on the Auto Fit icon.

17. Display Settings

It has options to hide/unhide the Actions column as well as hidden nodes.

18. Formula Bar

It shows the formula or the number contained in the selected cell.

Actions Column

Some of the frequently used actions like viewing node properties, log, node preview, lock/unlock, edit node, add and delete node options are available in this column beside each node that pops up when you hover your mouse over it.

Bottom Pane

It contains the information about the total number of nodes, last applied change, tab container with all the plan series tabs and + (Add New Series) icon to add new plan series.

It is used to perform as explained in the previous sections.

This is explained under .

You can distribute total value to periods and/or dependencies equally/ by weights. Check to know more.

Goal Seek is already explained in the section: .

Export the plan series to Excel using this option .

The Filter icon can be used to perform a condition-based search on the model. Multiple filter criteria can be provided by the user to perform advanced searches across different node properties. To add multiple criteria, click the Add Filter option and choose between AND or OR conditions.

Time Series Forecasting
this section
Goal Seek
Allocation Features
Action Menu Bar
Standard Plan/Driver Based Plan
Forecast
Copy to Periods
Distribute
Goal Seek
Click 'Lock'
Locked cells are greyed out
Unlock Cells
Number Formatting
Reset Last Change
Reset All
Logs window
Add Note
View, edit or delete notes
Show All Notes
All Notes - window
Export
Click 'Refresh Data'
Confirm Refresh Data source
Settings
Search
Filter
Auto-fit
Display Settings
Formula Bar
Actions Column
Bottom Pane