{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Employees","Groups"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,1,4,4],[11,4,12,4],[19,4,20,4],[22,1,22,4]]}
[]
[]
[null,"&frankly"]
[]
[null,"This template should be used to perform a one-time/first import of users and groups into a newly created &frankly account. \n\nPlease follow the instructions below in order to populate the necessary data. If you only wish to import users (no groups), you can perform only step 1, but make sure you remove example data for groups."]
[]
[null,"1. Add all employees you want to import in the Employees sheet, by adding the following data on each row:"]
[]
[null,null,"First name",null,"Employee's first name, e.g. \"Anders\""]
[null,null,"Last name",null,"Employee's last name, e.g. \"Svensson\""]
[null,null,"Email",null,"Employee's email address (used to login with), e.g. \"anders.svensson@company.com\""]
[null,null,"Role",null,"The role that the employee should have in &frankly: User, Manager or Administrator.\nUsers can answer questions and see own results, and results they receive access to. Managers can create & schedule questions for groups they are responsible for, and see group results. Administrators can create & schedule questions for all groups, and see all results."]
[]
[]
[null,"2. Add the groups you want to add in the Groups sheet, by adding the following data on each row:"]
[]
[null,null,"Group name",null,"Name of the group"]
[null,null,"Description",null,"(optional) Description of the group"]
[null,null,"Parent group",null,"(optional) Group that this group should be placed under in the hirearchy"]
[null,null,"Manager of group",null,"(optional) Email address of the user that should be made admin/responsible for this group. Must be a user added in the Employees table and that is also a Manager."]
[]
[]
[null,"3. Update the users in the Employees sheet and set (up to 5) groups that each member should be member of, from the list of groups that was added on the Groups sheet."]
[]
[null,"5. Done! Send the filled in template to your contact person at &frankly. "]

{"sheet":"Employees","index":1,"n_rows":303,"n_cols":8,"rows_kept":303,"cut":false,"hidden":false,"merged":[[1,7,2,10]]}
[]
[null,"Step 1",null,null,null,null,"Step 3","Note: Only set groups that the user is a direct member. I.e. if Team A is a subgroup of Department 1, then adding the user to Team A  will also make him a member of Department 1, so there is no need to also add the user to the Department 1 group. "]
[]
[]
[null,"First name","Last name","Email","&frankly role",null,"Group memberships"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]
[null,null,null,null,"User"]

{"sheet":"Groups","index":2,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Step 2"]
[]
[null,"Group name","Description","Parent group","Manager of group",null,null,"Resulting group structure in &frankly:"]