Link KPI Value to Certain Cell in Excel File

BSC Designer allows you to link KPI value to the certain cell value in Excel file:

  1. Go to the "KPIs" tab in BSC Designer and select KPI that you want to link
  2. Click "Data Source" button Data source button next to "Value" field
  3. Select "Link to MS Excel"
  4. Select Excel file to import from
  5. Select below the way you want BSC Designer to use to understand where the cell is located

There are several options suggested:

Important notes about importing value from Excel in this way: