How to fill the KPI load templates
Two files load the real KPIs into CS WorkHub. Each one can be an Excel workbook (.xlsx, only the first sheet is read) or a CSV file:
kpi-load-template.csv: one row per KPI, with the monthly actuals in columns.kpi-target-changes-template.csv: optional, one row per target change during the year.
Nothing is loaded by filling these files. They only prepare the data.
Steps
- Make a copy of each template. Never fill in the originals.
- Open the copy in Excel. Delete the rows whose
kpi_codestarts withEXAMPLE-. - Fill one row per KPI (see the columns below).
- If a target changes during the year, add a row to the target-changes file.
- Save it as an Excel workbook (.xlsx), or as CSV UTF-8 (Comma delimited). The old .xls format cannot be read. Keep the column names of the first row exactly as in the template, on the first sheet.
File 1: kpi-load-template.csv
| Column | What to put | Example |
|---|---|---|
| kpi_code | Short code, unique, no spaces | OTD |
| kpi_name | Full name | On-time delivery to customer |
| unit | %, count, or any unit | % |
| better_when | higher or lower | higher |
| responsible | Name of the responsible, exactly as in the responsible list | Logistics |
| target | Initial target for the year (a number) | 95 |
| jan to dec | Actual for each month. Leave empty if there is no data yet | 96 |
File 2: kpi-target-changes-template.csv
| Column | What to put | Example |
|---|---|---|
| kpi_code | The KPI, same code as in file 1 | OTD |
| from_month | Month number 1 to 12 from which the new target applies | 7 |
| new_target | The new target (a number) | 97 |
The target stays the same every month until a new one is defined. The new target replaces the old one from that month through December. Earlier months keep their target.
Rules the loader will check
kpi_codeis unique and appears in no other row.better_whenis exactlyhigherorlower.responsiblealready exists in the responsible list. Spelling must match.- Targets and actuals are numbers only: no units, no text. In a CSV file, no % and a dot for decimals (96.5). In an Excel file, number cells are read as Excel stores them, so a decimal comma is fine, and a cell formatted as a percentage is read as the number shown (95% becomes 95). Text typed as "95%" is still refused.
from_monthis a whole number from 1 to 12.- Every
kpi_codein file 2 exists in file 1. - If any row fails, nothing is loaded. The loader reports the row number and the problem.
Common mistakes
- Opening a CSV on a computer with Spanish regional settings can show everything in one column. If that happens, use Data > From Text/CSV and choose comma as the delimiter, or simply load the Excel workbook instead.
- Typing
95%instead of95. - Using a comma as the decimal separator (96,5). Use a dot.
- Leaving the EXAMPLE rows in the file.
- Misspelling the responsible name.
Open points
- The list of responsible names is not final until the real KPIs are defined.
- Whether a single KPI can have several responsibles is not decided (currently one).