{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["New User","Amend Existing User","Drop down lists"],"not_rendered":{"charts":0,"images":25,"macros":1,"external_links":0,"defined_names":5,"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":"New User","index":0,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[[62,2,63,2],[62,1,63,1],[57,1,61,1],[62,0,63,0],[45,0,45,6],[61,4,61,6],[58,2,61,2],[47,4,47,6],[49,3,51,3],[49,0,51,0],[51,4,51,6],[0,0,0,6],[1,0,1,6],[36,1,36,2],[16,0,16,2],[27,1,27,2],[16,3,16,5],[18,3,18,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[23,3,23,5],[27,3,27,5],[15,3,15,6],[25,3,25,5],[26,3,26,5],[24,1,24,2],[25,1,25,2],[4,1,4,2],[14,0,14,6],[28,0,28,6],[57,0,61,0],[10,1,10,2],[19,3,19,5],[19,1,19,2],[2,2,2,5],[53,0,56,0],[49,1,51,1],[49,4,50,6],[49,2,51,2],[53,4,56,6],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[15,0,15,2],[17,0,17,6],[26,1,26,2],[24,3,24,5],[13,0,13,6],[8,1,8,2],[67,4,67,6],[68,4,68,6],[31,0,33,5],[30,0,30,5],[31,6,33,6],[65,0,66,0],[40,0,40,6],[41,0,41,6],[65,1,66,1],[65,2,66,2],[65,4,66,6],[58,4,60,6],[53,1,56,1],[53,2,56,2],[57,4,57,6],[62,4,63,6]]}
["Unit4 ERP"]
["New User Request Form"]
[null,null,"**NEW USERS ONLY**"]
[]
["Organisation",null,null,null,null,"Department "]
[]
[]
["New user details 1","All fields are mandatory"]
["Full name",null,null,null,null,"Employee number "]
[]
["E-mail address",null,null,null,null,"Telephone number"]
[]
[]
["Access requirements    Please see guidance notes below"]
[]
["Type of access ",null,null,"Additional information"]
["Select all that apply",null,null,"Complete where applicable",null,null,"Required"]
[]
[null,"Same access as existing user 2",null,null,null,null,"Provide username of existing user"]
[null,"Posting Invoices (SCHOOLS ONLY)"]
[null,"Enquiries (includes budget manager reports)"]
[null,"Raising Requisitions 3",null,null,null,null,"E-mail address for orders and delivery address 3"]
[null,"Approving requisitions and invoices 4",null,null,null,null,"Provide codes & workflow details"]
[null,"Invoice Checker ",null,null,null,null,"Provide codes & workflow details"]
[null,"Raising sales orders (debtors invoices) 5"]
[null,"Approving sales orders (debtors invoices) 4",null,null,null,null,"Provide codes & workflow details"]
[null,"Timesheets 6",null,null,null,null,"Start date, hourly rate & approver "]
[null,"Other",null,null,null,null,"Please specify (use the box below if needed)"]
[]
[]
["Additional information/comments",null,null,null,null,null,"Appropriate Substitute (Checkers and Approvers ONLY) 8"]
[]
[]
[]
[]
["Authorising Officer 7  *Must be line manager or equivalent"]
["Full name",null,null,null,null,"Date"]
[]
[]
[]
["* Please return all completed forms to CRFinanceSystems@carmarthenshire.gov.uk *"]
["If you require any assistance, please contact the Systems department on the above e-mail address or on 01267 224460 (ext. 4460)"]
[]
[]
[]
["Guidance Notes"]
[]
["Requirements","Note","Organisation",null,"Information"]
[]
["New user details",1,"ALL",null,"All fields are mandatory. Accounts are created based on the users' initials and the last three digits of the employee number. Where there is no employee number please state N/A."]
[]
[null,null,null,null,"Please provide full external telephone number."]
[]
["Same as existing user",2,"ALL",null,"If this option is selected, you do not need to complete any of the other fields on the form. If applicable, please state in the additional information/comments box whether the same workflow permissions should also be applied to the new user. "]
[]
[]
[]
["Raising Requisitions",3,"CCC",null,"User cannot be a requisitioner as well as an approver. "]
[null,null,"ALL",null,"Once requisitions are approved, the purchase order will be e-mailed to the specified e-mail address. If purchase orders need to go to a different e-mail address such as a central mailbox, please specify the e-mail address. "]
[]
[]
[null,null,null,null,"If a specific delivery address is to be allocated to the user, please specify in the additional information/comments box the full address as it should appear on purchase orders. This address will show as the default delivery address in the Requisition standard screen. "]
["Approving Requisitions & Invoices",4,"CCC",null,"Officer must be listed on the Authority's Authorised Signatory List to be an approver. "]
[]
["Debtor invoices",5,"CCC",null,"Authorisation will be obtained from the Debtors section before access will be granted."]
["Timesheets",6,"CCC",null,"Timesheets will be generated from the start date specified and using the hourly rate. The timesheets will go to the approver specified for first stage approval. "]
[]
["Substitutes",8,"CCC",null,"A substitute must be equal with the person they are substituting for on the Authorised Signatory List and must have the same data roles as what is on Unit4. \nThis includes what is in the notes of on the ASL. If the substitute has anything missing, e.g. isn’t authorised to approve the raising of sales orders, they can not be the persons substitute. In general, substitutes should go up not down in delegation."]
["Authorising Officer",7,"CCC",null,"Electronic signatures are accepted but we also accept emails directly from the authorising officer  "]

{"sheet":"Amend Existing User","index":1,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[15,0,15,3],[0,0,0,7],[1,0,1,7],[4,1,4,2],[8,1,8,2],[11,0,11,7],[12,0,12,7],[13,0,13,2],[13,3,13,7],[14,0,14,2],[14,3,14,5],[2,2,2,7],[27,0,27,7],[48,0,51,0],[57,1,58,1],[52,1,56,1],[48,1,51,1],[48,2,51,2],[48,4,51,7],[52,0,56,0],[52,4,52,7],[53,2,56,2],[53,4,55,7],[56,4,56,7],[45,4,45,7],[43,0,43,7],[26,4,26,5],[16,0,16,2],[20,0,20,2],[19,0,19,2],[18,0,18,2],[24,0,24,2],[25,0,25,2],[23,0,23,2],[17,0,17,2],[26,0,26,2],[22,0,22,2],[21,0,21,2],[25,4,25,5],[62,4,62,7],[28,0,28,5],[29,0,30,5],[29,7,30,7],[57,2,58,2],[57,4,58,7],[57,0,58,0],[34,1,34,2],[38,0,38,7],[39,0,39,7],[60,1,61,1],[60,2,61,2],[60,4,61,7]]}
["Unit4 ERP"]
["User Amendment Request Form"]
[null,null,"                                          **AMENDMENTS ONLY**"]
[null,null,null,null,"You do not need to fill in this form if you wish to close a user's account."]
["Organisation",null,null,null,null,"Department "]
[]
[]
["User Details"]
["Full name",null,null,null,null,"Unit 4 Username"]
[]
[]
["Access requirements    Please see guidance notes below"]
[]
["Type of access ",null,null,"Additional information"]
["Select all that apply",null,null,"Complete where applicable",null,null,null,"Provide additional information below"]
[null,null,null,null,"ADD ACCESS","REMOVE ACCESS"]
["Same as existing user 2",null,null,null,null,null,{"$f":"IF(ISBLANK(H17),\"Provide username of existing user here\",H17)","v":"Provide username of existing user here"}]
["Posting Invoices (SCHOOLS ONLY)"]
["Enquiries (includes budget manager reports)"]
["Raising Requisitions 3",null,null,null,null,null,{"$f":"IF(ISBLANK(H20),\"Provide an e-mail address and delivery address for orders here\",H20)","v":"Provide an e-mail address and delivery address for orders here"}]
["Approving requisitions and invoices 4",null,null,null,null,null,{"$f":"IF(ISBLANK(H21),\"We will contact you for further information\",H21)","v":"We will contact you for further information"}]
["Invoice Checker ",null,null,null,null,null,{"$f":"IF(ISBLANK(H22),\"We will contact you for further information\",H22)","v":"We will contact you for further information"}]
["Raising sales orders (debtors invoices) 5"]
["Approving sales orders (debtors invoices) 4",null,null,null,null,null,{"$f":"IF(ISBLANK(H24),\"We will contact you for further information\",H24)","v":"We will contact you for further information"}]
["Timesheets 6",null,null,null,null,null,{"$f":"IF(ISBLANK(H25),\"Provide Start date, hourly rate & approver here\",H25)","v":"Provide Start date, hourly rate & approver here"}]
["Other",null,null,null,null,null,null,"Use Additional information box below"]
["REOPEN USER AND REINSTATE PREVIOUS ACCESS"]
[]
["Additional information/comments",null,null,null,null,null,null,"Designated Substitute (Checker & Approver ONLY)8"]
[]
[]
[]
[]
["Authorising Officer 7  Must be line manager or equivalent"]
["Full name",null,null,null,null,"Date"]
[]
[]
[]
["* Please return all completed forms to CRFinanceSystems@carmarthenshire.gov.uk *"]
["If you require any assistance, please contact the Systems department on the above e-mail address or on 01267 224460 (ext. 4460)"]
[]
[]
[]
["Guidance Notes"]
[]
["Requirements","Note","Organisation",null,"Information"]
[]
[]
["Same as existing user",2,"ALL",null,"If this option is selected, you do not need to complete any of the other fields as the new user account will reflect the existing users' account. If applicable, please state in the additional information/comments box whether the same workflow permissions should also be applied to the new user. "]
[]
[]
[]
["Raising Requisitions",3,"CCC",null,"User cannot be a requisitioner as well as an approver. "]
[null,null,"ALL",null,"Once requisitions are approved, the purchase order will be e-mailed to the specified e-mail address. If purchase orders need to go to a different e-mail address such as a central mailbox, please specify the e-mail address. "]
[]
[]
[null,null,null,null,"If a specific delivery address is to be allocated to the user, please specify in the additional information/comments box the full address as it should appear on purchase orders. This address will show as the default delivery address in the Requisition standard screen. "]
["Approving Requisitions & Invoices",4,"CCC",null,"Officer must be listed on the Authority's Authorised Signatory List to be an approver. We will contact you for further information regarding cost codes"]
[]
["Debtor invoices",5,"CCC",null,"Authorisation will be obtained from the Debtors section before access will be granted."]
["Timesheets",6,"CCC",null,"Timesheets will be generated from the start date specified and using the hourly rate. The timesheets will go to the approver specified for first stage approval. "]
[]
["Subtitutes",8,"CCC",null,"A substitute must be equal with the person they are substituting for on the Authorised Signatory List and must have the same data roles as what is on Unit4. \nThis includes what is in the notes of on the ASL. If the substitute has anything missing, e.g. isn’t authorised to approve the raising of sales orders, they can not be the persons substitute. In general, substitutes should go up not down in delegation."]
["Authorising Officer",7,"CCC",null,"Electronic signatures are accepted but we also accept an email directly from the authorising officer "]

{"sheet":"Drop down lists","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Organisation",null,"Department",null,"Citrix "]
["Carmarthenshire County Council (CC)",null,"Chief Executive ",null,"Yes"]
["Brecon Beacons National Park Authority (BB)",null,"Communities ",null,"No"]
["Dyfed-Powys Police (DP)",null,"Corporate Services"]
["Mid and West Wales Fire and Rescue Service (FB)",null,"Education "]
["Llesiant Delta Wellbeing (DW)",null,"Environmental Services "]
["Cartrefi Croeso (HC)",null,"Regeneration"]
[null,null,"Dyfed - Superannuation Fund "]
[null,null,"Other (Please provide further details)"]