Tindra Industrier AS: fake workforce and answer sheet
=====================================================

Everything in these files is fake. The company does not exist. The names,
addresses, phone numbers and bank accounts are random, so some will match
real ones by coincidence. Please do not call or use them.

Files
-----
1_departments.xlsx      13 departments
2_designations.xlsx     46 job titles
3_branches.xlsx         5 locations
4_employees.xlsx        433 employees
5_reporting_lines.xlsx  who reports to whom
answer_key.xlsx         the 127 planted errors, the 11 decoys, and what
                        happened at import

Built for Frappe HR version 16 (Frappe 16.56, ERPNext 16.55, Frappe HR 16.53).

Before importing
----------------
1. In the setup wizard choose English, Norway and NOK.
   Company name: Tindra Industrier AS
   Abbreviation: TIA
   The department names in the employee file end in "- TIA", so the
   abbreviation has to match.
2. In HR Settings set "Employee Naming By" to "Employee Number".

Import order
------------
Use Data Import with "Insert New Records" for files 1 to 4, in this order:
Department, Designation, Branch, Employee.

Then run Data Import on Employee again with "Update Existing Records"
and file 5.

What to expect
--------------
File 4: Frappe refuses four employees (TI-0004, TI-0034, TI-0223, TI-0258)
because their salaries are written with a space or a dot between the
thousands. Skip those four rows. 429 employees go in: 394 active, 35 left.

File 5: 422 of 427 rows update. Five fail: the four skipped employees,
and TI-0197, a manager who has left and still has people reporting to her.
That last one is a planted error.

The answer sheet is version 2. It describes the 429 employees that are in
the system after these steps.
