The Worksheet name in the Excel spreadsheet must be called Personnel.
Mandatory
|
Column Name |
Description |
Example |
YES |
Employee No |
Employee number to uniquely identify the person |
001 |
|
Title |
Title of the person |
Mr |
|
First Name |
First name of the person |
John |
|
Last Name |
Last name of the person |
Smith |
|
Job Title |
Their official Job Title |
Sales Manager |
|
Department Level 1 |
Department structure supports 4 levels in the tree |
Sales |
|
Department Level 2 |
|
North West |
|
Department Level 3 |
|
Greater Manchester |
|
Department Level 4 |
|
|
|
HAV EAV |
HAV monitoring points before their EAV is exceeded |
100 |
|
HAV ELV |
HAV monitoring points before their ELV is exceeded |
400 |
HAVmeter only allows up to 16 characters for Employee No.