In most cases you will need to import data into your Balanced Scorecard from an external file, such as an MS Excel spreadsheet. Here are instructions for how to import values into a Balanced Scorecard project.
Here is the source project file:
For testing purposes you can download this Excel file.
To start import for many indicators, select "Import values" option in KPIs menu.
If you need to import data for a specific indicator:
Then select the source for your data, which could be an CSV file, MS Excel file or data that you will enter manually (copy and paste from your data source). If you enter data manually, you will be able to specify some custom delimiters for telling the program how to parse these data.
For the next step you will need to tell BSC Designer the meaning of columns in the data that you are importing.
BSC Designer will show you a preview of the imported data:
When you finish the import process, you will see the imported indicators in BSC Designer. Click on the dates in the calendar to make sure that the right data were imported for the right dates: