Rules. (Required fields are marked with a Red background color)
| Cells | Description | Rules | Exception Handling | Values to be placed | Default Values | Field Type |
| A2 and above | This is the date (and time if applicable) of the KPI value captured. | This field will be captured in a Date and Time format. | If the date is not captured the KPI record will not be imported. It is important that the date is captured for the KPI. If a KPI tracking value has two dates but does not have two times associated with it, the system will still import the data. | 2013-11-14 15:43:30 | Date and time of import | Date time (YYYY-MM-DD HH:MM: SS) |
| Columns B1 and greater (C1, D1) | This is the unique KPI code associated with the KPI. Each KPI will have a KPI code associated with it. | The KPI code must be the same as the KPI code. This is how the KPI information will be linked to each other. The KPI code will consist of a choice of up to 30 alphanumeric characters. | If the KPI code is not captured within the import sheet, the record will not be imported. It is imperative that the KPI code is captured. | N/A | N/A | Variable Character (10) |
| B2/C2/B3/C7 Etc | These are the values of the KPI and will contain the data captured for the KPI. | This field will be numeric. Any previous Baseline Value for the specified date will be overwritten | Only numeric fields will be accepted. Non-numeric characters will cause the record to not be uploaded. | Any numeric number | N/A | N/A |