How to build performance formula with BSC Designer

ShareTweet about this on Twitter0Share on Facebook5Share on Google+1Share on LinkedIn0Pin on Pinterest0
  • Below is an old video about calculating performance and progress in BSC Designer. There is a new version of the video that explains all the details about KPIs, including the difference between performance and the progress.

BSC Designer calculates the performance of indicator according to its current value and the performance function.

After the installation BSC Designer offers two performance functions: maximization (when higher “value” means higher performance) and minimization (when lower “value” mean higher performance) both are linear.

When designing KPIs business professional might need some sophisticated, non-linear functions for the performance. Performance formulas in BSC Designer can be customized with Formula Editor.

Formula builder

To access Formula Builder:

  1. Run BSC Designer. Create new indicator or select existent one.
  2. Find “Optimization” field at the bottom and click Performance Editor button: Performance Editor
  3. Formula Builder dialog will appear

Let’s look at every element that could be used in this builder.

Variables

There are 5 variables in BSC Designer that can be used in formulas:

  • Min value = mn (builder syntax);
  • Max value = mx (builder syntax);
  • Target  value = target (builder syntax);
  • Baseline value = baseline (builder syntax);
  • Score Value = value (builder syntax).

BSC Designer Manual – Indicator Details

Operations

Formula Builder supports Basic mathematical operations: “+”, “-”, “*”, “/”.

Functions

Click the button “Function” in the Formula Builder to have a list of supported mathematical functions:

  • Sin (a) – The sine trigonometry function.
  • Cos (a) – The cosine trigonometry function.
  • Tan (a) - The tangent trigonometry function.
  • Power (a, b) – Exponentiation with the base of “a” and the exponent of “b”.

For example: power (2, 4) = 16;

  • Exp (a) – Exponentiation with the base of “e”-number and the exponent of “a”.
  • Sqrt (a) – Square root. Exponentiation with the base of “a” and the exponent of “0.5”.
  • Pi – the function returns the value of pi-number.
  • Min (a, b) – The function selects the smallest among two numbers.
  • Max (a, b) – The function selects the biggest among two numbers.

For example: Min (3, 5) = 3; Max (3, 5) = 5;

Customizing Formula

By default the formula field contains linear formula of maximization ((Score – mn) / (mx – mn)) or minimization ((mx – Score) / (mx – mn)). The formula can be modified and might contain any combination of available functions and variables. Some examples are listed below:

Default maximization formula: ((value- mn) / (mx – mn))


(sin(value/mx*2.5) – mn) / (mx – mn)



tan( ((value) – sqrt(mn)) / (mx – mn) )


min((exp(value)*exp(mx)), Power( sqrt(score), Pi)*0.9)

Conditions in the performance formula

There are also special conditions available for the variable called “value”. User can define different optimization functions for different intervals of the “value”. To define function for the certain interval:

  1. Run “Formula Builder”.
  2. Click on “Add Condition” button.
  3. Enter new function.
  4. Define the interval for this function below.

Setting up the special function for the values greater than 45. Below is the resulted graph for these conditions.


The performance graph for this function (after score riches 45 and more the graph begins to fluctuate)

For more information:

ShareTweet about this on Twitter0Share on Facebook5Share on Google+1Share on LinkedIn0Pin on Pinterest0
Posted in Features
Tags: , , , , ,
Video ManualMore videos for BSC Designer.

Call me back

Do you have any questions? Let us know the best time to call you.

BSC Designer users say

BSC Designer

Get the latest version of the BSC Designer - professional balanced scorecard software.

Introduction to the Balanced Scorecard

BSC Lessons

We are not going to leave you alone with our software and books about the Balanced Scorecard.
  • We are going to follow up with you with lessons about the Balanced Scorecard.
  • Our goal is to teach you key ideas and
  • Show you how these ideas can be automated.
Download BSC Designer and get your first BSC lesson or subscribe to BSC lessons directly: