CS WorkHub ← Back to the site

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:

  1. kpi-load-template.csv: one row per KPI, with the monthly actuals in columns.
  2. 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

  1. Make a copy of each template. Never fill in the originals.
  2. Open the copy in Excel. Delete the rows whose kpi_code starts with EXAMPLE-.
  3. Fill one row per KPI (see the columns below).
  4. If a target changes during the year, add a row to the target-changes file.
  5. 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

ColumnWhat to putExample
kpi_codeShort code, unique, no spacesOTD
kpi_nameFull nameOn-time delivery to customer
unit%, count, or any unit%
better_whenhigher or lowerhigher
responsibleName of the responsible, exactly as in the responsible listLogistics
targetInitial target for the year (a number)95
jan to decActual for each month. Leave empty if there is no data yet96

File 2: kpi-target-changes-template.csv

ColumnWhat to putExample
kpi_codeThe KPI, same code as in file 1OTD
from_monthMonth number 1 to 12 from which the new target applies7
new_targetThe 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

Common mistakes

Open points