Academy

Join the Intrafocus Academy

If you like our free strategy resources then join the Intrafocus Academy for additional material

Strategy Workshop

A three-session workshop based on the Intrafocus Strategic Planning Process (SPP)

Balanced Scorecard Certification

A five-day master class and certificate as a Balanced Scorecard Professional

Strategic Plan Audit/Review

Let us take a look at your strategic plan to check it contains all the elements needed in a good plan

Resources

Strategy & KPI Resources

A library of resources for anyone interested in strategic planning and KPI management

Strategic Planning Process (SPP)

Our next generation Strategic Planning Process based on the Balanced Scorecard Methodology

Blog - Intrafocus Insight

New articles published every two weeks, join our mailing list and keep up

Our Customers

Don’t take our word for it, see what the Intrafocus customers have to say.

Software

Spider Impact KPI Software

Intrafocus is the only EMEA authorised reseller of Spider Impact® from Spider Strategies®.

Spider Impact Video & User Guides

From getting started all the way through to integrating into back-end systems.

My5 KPIs - The Mobile App

Keep your key performance indicators to hand with the My5 KPIs mobile application

My5 KPIs - User Guides

How to create a set of up to 25 KPIs and then import data to the My5 KPIs mobile app.

Contact and Help Desk

If you have any questions or need some help or guidance, you can contact us at any time.

My5 – Upload structure from a spreadsheet

My5 - Import spreadsheet

Upload dashboard and KPI structure settings from a spreadsheet

This is a one-off process to build your dashboards and add your KPIs.

WARNING: This function will overwrite any existing dashboard and KPI settings. Only use this function if you want to build your system from scratch or rebuild an existing system.

First, you need to prepare a spreadsheet. 

We suggest you perform this operation from a Mac or PC. You can use your phone, but you might find it easier to manipulate the spreadsheet on a Mac or PC!

Click on the setting cog at the top-right of the screen and select Import Spreadsheets. 

My5 - Blank KPI details

Import source

Select the source, click on the Upload Dashboard Structure panel.

Go to the next step.

 

 

My5 - Download sample structure

Download the sample spreadsheet

When uploading a spreadsheet it has to be in the correct format.

Click on Download Example Spreadsheet to obtain a copy of a spreadsheet in the correct format. You can use this as a template for your upload.

Go to the next step.

 

 

Sample spreadsheet

My5 - Sample Structure Spreadsheet

The Upload Dashboard Structure spreadsheet format is fixed. The column names data that can be included are as follows:

1. Dashboard Name – You can call your dashboards anything up to a maximum of 20 characters. Notice that the dashboard name has to appear in every row where you have a KPI as shown with labels 8 and 9. You can have a maximum of 5 dashboards. In this example, we have 3.

2. KPI Name – Your KPIs can have any name up to a maximum of 22 characters. Try to keep the names meaningful and unique. You can have a maximum of 25 KPIs, 5 per dashboard.

3. Target – The target is the point at which your KPI will turn green. This can be an increasing target, for example, Deliveries on Time. Or a decreasing target, for example, Percentage Returns. Increasing or decreasing is determined by the value of the Red Flag.

4. Red Flag – The red flag is the point at which your KPI will turn Red. If the value of your KPI is between the Target and the Red Flag, it will turn amber.

Important Note: do not use signs in the spreadsheet, for example, %. The sign is determined by the KPI Type. 

5. Type – The KPI can be a Number, Percentage or Currency. If you select a currency, you will need to add a currency symbol in the Currency Symbol column. 

6. Update Frequency – You can update KPI actual values as many times as you like. The value in the update frequency column will determine which KPI value to display. For example, if the update frequency is set to Monthly, the display will default to the last day of the month and show the last KPI value added during a given month. Suppose the update frequency is set to Weekly. In that case, the display will default to the last Saturday in the week and display the last value added during any given week.

7. Currency Symbol – If you have selected Type as Currency, then you can add the currency symbol here. The app will make every effort to display your currency symbol correctly.

8 & 9. Dashboard Names – to remind you, dashboard names have to be present in every row where you have a KPI.

My5 - Choose file

Choose your file

Once you have created your Dashboard Structure file, please save it to an accessible place.

Go back to the Upload Dashboard Structure screen, click on Click here to choose a file and select the file you have just created. 

Click on Upload File

You will be given a final warning!

Don’t forget, this operation will blitz your existing system. It will not be recoverable. If you want to continue, click on ‘I understand, proceed with the import’ and go to the next step.

 

 

My5 - upload success

Return to dashboard

If your upload succeeds, you will see this message:

Your spreadsheet has been uploaded successfully. We will import your settings and send you an e-mail when it is complete

If the upload does not succeed, you will receive an e-mail suggesting a fix.

It might take a minute or two for the upload to process.

Have a cup of coffee and go to the next step.

 

 

My5 - Dashboard view

The result

Go to your dashboards by clicking on the Home button on the top-left of the screen (or tap the return button twice).

The result of our upload looks like this.
Notice that you can still add another two because we only added three dashboards.

Click on any dashboard to see your KPIs. The next task is to add some KPI Actual Values.

 

 

My5 - KPI Overview - no data

The result – KPIs

The example shows the Overview dashboard with the KPIs defined, but the KPI daily, weekly or monthly Actual Values have not been added.

You can add KPI actual values in three ways:

  1. Manually, by clicking on the KPI
  2. Uploading via a spreadsheet
  3. Linking to Google Sheets

Important Note: The actual values will be uploaded automatically every evening if you link to Google Sheets. This is by far the most efficient way to use the App.

 

Go to one of the update methods shown above.