In This Article
How do you activate the feature?
How does the feature affect the KPI, Variable and Constant Node?
How does the calculation work?
Overview
The Idea/Initiative VDT features different views for specific analytical purposes: the Baseline View displays annual benefits or improvement of an idea/initiative, while Variance and Benefit Views focus on monthly metrics. We have added the ability to convert monthly default values to annual format within the Baseline View for KPI and Variable, ensuring seamless analysis across both timeframes. This new annualization feature ensures you the flexibility to analyze your data from both monthly and annual viewpoints as needed.
Why Use This Feature
- This enhancement ensures consistency by allowing users to convert monthly default values on KPI nodes to an annual format, as well as apply this conversion to monthly Constant Nodes if needed.
- Facilitate strategic planning by easily comparing and assessing the overall impact of initiatives on an annual basis
- Enhance decision-making with accurate, long-term performance insights that align with business planning cycles
- Meet industry expectations for annual performance assessment and reporting standards
- Gain flexibility in data presentation, ensuring your analysis meets the specific needs of different stakeholders and use cases
How do you activate the feature?
The VDT Baseline Annualization feature is activated internally by the WiredUp team. To activate the feature, kindly contact support at support@wiredup.global
Once the feature has been activated, a site administrator can activate the site setting by selecting any of these options mentioned below:
- For PMO users, the site setting is located on Portfolios > Site Configuration > Settings > VDT > Annualize VDT Baseline View
- For CI users, the site setting is located on Organisation Structure > Site Configuration > Settings > VDT > Annualize VDT Baseline View
There are 3 settings available for the Annualize VDT Baseline View:
- Annualize: when enabled, this will convert all monthly default baseline and target values on KPI and Variable nodes to annualized values in the Baseline View. The value on the Constant nodes will be Annualized as well.
- Do not annualize: the KPI and Variable Baseline and Target values will continue to be displayed as monthly values in the Baseline view. The Constant node value will continue to be displayed as is.
- Enable Annualization Option on VDT: this setting gives users the option to annualize or not annualize their baseline and target values of KPI and Variable nodes in the Baseline view. The option is also applicable to the values on the Constant nodes as well. The setting is enabled on each VDT by activating or deactivating the Annualize Baseline View on each VDT's settings
How does the feature affect the KPI, Variable and Constant Node?
Once the feature has been activated either through the Annualize setting or the Enable Annualization Option on VDT setting, On the VDT, the "(Annualized)" label appears next to the Baseline option in the VDT view dropdown.
In addition, the following updates will occur on the KPI and Constant nodes in the Baseline view:
KPI and Variable Node
- A new "Baseline (Annualized)" field is added next to the current Baseline field on the KPI node. This new field value read-only and also includes a field help icon to explain the calculation.
- A new "Target (Annualized)" field is added next to the current Target field on the KPI node. This new field value is read-only and also includes a field help icon to explain the calculation.
- The values shown on a saved KPI node are the Annualized Baseline and Annualized Target values
Constant Node
- A new checkbox labeled "Annualize Values?" has been added as well as a field help to serve as a guide. This checkbox is deselected by default
- Once the checkbox has been enabled, the Annualized Value of the constant node will be displayed as read only
- The values shown on a saved Constant node are the Annualized Baseline and Annualized Target values
The option to Annualize each variable value of the constant node is also made available when the 'Allow Variable Values' setting is enabled on a Constant node.How does the calculation work?
The formula for the VDT Baseline Annualization includes a parameter for Days in Month. The Days in Month are the standard number of days in month for the Annualization formula. This setting must be specified by the site administrator in the site settings before proceeding with the VDT Baseline Annualization calculation:
- For PMO users, the site setting is located on Portfolios > Site Configuration > Settings > VDT > Days in Month for Annualization
- For CI users, the site setting is located on Organisation Structure > Site Configuration > Settings > VDT > Days in Month for Annualization
The VDT Baseline Annualization calculation is calculated as follows:
KPI and Variable Node:
Annualized Baseline Value =
Default Baseline Value (sourced from the KPI) / Days in Month (from site setting) * total days from today rolling forward 12 months.
E.g: 10000 / 28 * 365 = 130357.14
Annualized Target Value =
Default Target Value (sourced from the KPI) / Days in Month (from site setting) * total days from today rolling forward 12 months.
E.g: 20000 / 28 * 365 = 260714,29
Constant Node:
Annualized Constant =
Constant Value / Days in Month (from site setting) * total days from today rolling forward 12 months.
E.g: 120000 / 28 * 365 = 1564285.61
Affected Areas
When the Annualization Site Setting has been set to 'Enable Annualize Option on VDT' or 'Annualize', the Annualization of the Baseline values from the VDT will affect the following areas within the WiredUp system:
- Idea/Initiative Overview: the new Improvement value from the VDT will be displayed
- Idea/Initiative Pipeline List and Card view: the new Improvement value will be displayed in the Value columns of the List view as well as on the drop-down in the content bar of the List and Card view to allow the user to change the view to either display Annualized or Not Annualized (default) values.
- Idea/Initiative List Excel Download: added a column next to the initial Financial Improvement Value and each Non-Financial Improvement Value, which will show the corresponding Annualized Value
- Idea/Initiative List PDF Download: the download will show both the initial (Default) Improvement Value and Annualized Improvement Value
- Idea/Initiative Export: renamed the current "Annualized Value" column to "Value" and added a new "Annualized Value" column displaying the Improvement value as calculated in the VDT baseline view
- Ideas Bulk API: ensured that the 'annualizedValue' field in the API, sources the correct value based on the VDT Baseline Annualization feature on the UI
- RAR Ideas/Initiatives List/Card view: added a "Showing" label and a new drop-down in the content bar for "Values" to allow the user to change the view to either display Annualized or Not Annualized (default) values
- Forecast Export: next to the 'Value' column, we added a new "Annualized Value" column on the Forecast export Excel file, displaying the Improvement value as calculated in the VDT baseline view
- Portfolio Idea/Initiative List and Card view: added a "Showing" label and a new drop-down in the content bar for "Values" to allow the user to change the view to either display Annualized or Not Annualized (default) values
- Top 25 Dashboard widget: Add a ' Display Values' dropdown on the Top 25 widget to show either initial (default) Improvement Values or calculated Annualized Values
- Portfolio Value Dashboard Widget: added a new 'Display Initiative Total' drop down to the portfolio configuration widget, that will allow the 'Initiative Total' to either show Initial (default) Improvement Values or Annualized Values. The display of the new dropdown is dependent on the 'Value' field being set to the option "Initiative Total"
- Pending & Outstanding Approvals Widget: a 'Display Values' dropdown is added to the Pending & Outstanding Approvals Widget configuration. This drop-down offers two options:
- Not Annualized: which will display the original improvement values
- Annualized: which will display the calculated annualized values
- Emissions Initiative Impact Table: added a 'Values' dropdown that will allow the user to view either the initial (default) Emissions Improvement Value or the Emissions Annualized Value
- Emissions MACC Table: added a 'Values' dropdown that will allow the user to view either the initial (default) Emissions Improvement Value or the Emissions Annualized Value
- Cumulative Benefit Excel Download: renamed the current "Annualized Value" column to "Value" and added a new "Annualized Value" column displaying the Annualized value as calculated in the VDT baseline view. This change was made in the following sheets from the Cumulative Benefits Excel Download:
- Benefit Calculation
- Forecasts
- Actuals
- Year-to-Date
- Cumulative Pipeline Report: added a new filter option to either show initiatives that are not annualized or that are Annualized
- Benefit Contribution Report: added a new filter option to either show initiatives that are not annualized or that are Annualized