{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["New User","Amend Existing User","Drop down lists"],"not_rendered":{"charts":0,"images":2,"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":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,1,3,6],[2,2,2,5],[43,2,44,6],[45,2,45,6],[46,2,46,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[34,2,35,6],[36,2,36,6],[37,2,38,6],[39,2,39,6],[18,3,18,5],[9,0,9,6],[5,1,5,2],[23,0,25,5],[13,3,13,5],[13,1,13,2],[34,0,35,0],[31,1,33,1],[14,1,14,2],[15,1,15,2],[16,1,16,2],[23,6,25,6],[43,0,44,0],[27,0,27,6],[28,0,28,6],[43,1,44,1],[34,1,35,1],[30,2,30,6],[26,0,26,6],[20,1,20,2],[22,0,22,5],[0,0,0,6],[1,0,1,6],[11,0,11,2],[21,1,21,2],[11,3,11,5],[12,3,12,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[21,3,21,5],[10,3,10,6],[19,3,19,5],[10,0,10,2],[20,3,20,5],[18,1,18,2],[7,1,7,2],[2,0,2,1],[40,1,41,1],[36,1,39,1],[40,0,41,0],[29,0,29,6],[31,0,33,0],[19,1,19,2],[36,0,39,0],[4,3,4,6],[5,3,8,4],[8,1,8,2],[6,1,6,2],[17,1,17,2]]}
["Unit4 ERP"]
["New User Request Form"]
[null,null,"                                 **NEW USERS ONLY**"]
["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"]
[false,"Same access as existing user 2",null,null,null,null,"Provide username of existing user"]
[false,"Posting Invoices (SCHOOLS ONLY)"]
[false,"Enquiries (includes budget manager reports)"]
[false,"Raising Requisitions 3",null,null,null,null,"E-mail address for orders and delivery address 3"]
[false,"Approving requisitions and invoices 4",null,null,null,null,"Provide codes & workflow details"]
[false,"Invoice Checker ",null,null,null,null,"Provide codes & workflow details"]
[false,"Raising Debtors Invoices 5"]
[false,"Approving Debtors Invoices 4",null,null,null,null,"Provide codes & workflow details"]
[false,"Timesheets (Property and Civil Engineering ONLY) 6",null,null,null,null,"Start date, hourly rate & approver "]
[false,"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"]
[]
[]
[]
["This form needs to be emailed to CR Finance Systems by the Authorising Officer 7  *Must be line manager or equivalent"]
["* Please email all completed forms to CRFinanceSystems@carmarthenshire.gov.uk *"]
["If you require any assistance, please contact the Systems department on the above e-mail address"]
["Guidance Notes"]
["Access","Note","Information"]
["New user details",1,"All fields are mandatory. "]
[null,null,"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,"Please provide full external telephone number."]
["Same as existing user",2,"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,"Users cannot be a requisitioner as well as an approver. "]
[null,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,"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,"Users must be listed on the Authority's Authorised Signatory List to be an approver. "]
[null,null,"Users cannot be an approver as well as a requisitioner. "]
["Debtor invoices",5,"Authorisation will be obtained from the Debtors section before access will be granted."]
["Timesheets",6,"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,"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,"We require this form to be sent directly from the authorising officer as a form of authorisation"]

{"sheet":"Amend Existing User","index":1,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[52,2,52,7],[49,2,50,7],[51,2,51,7],[35,2,35,7],[46,0,47,0],[22,4,22,5],[31,0,31,7],[32,0,32,7],[49,1,50,1],[37,2,40,7],[41,2,41,7],[42,2,44,7],[37,0,40,0],[46,1,47,1],[41,1,45,1],[37,1,40,1],[41,0,45,0],[33,0,33,7],[45,2,45,7],[46,2,47,7],[22,0,22,2],[20,0,20,2],[14,0,14,2],[23,0,23,2],[19,0,19,2],[18,0,18,2],[13,0,13,2],[17,0,17,2],[16,0,16,2],[15,0,15,2],[21,0,21,2],[24,0,27,5],[24,6,27,7],[29,0,29,7],[12,0,12,3],[0,0,0,7],[1,0,1,7],[4,1,4,2],[6,1,6,2],[8,0,8,7],[9,0,9,7],[10,0,10,2],[10,3,10,7],[11,0,11,2],[11,3,11,5],[2,2,2,7],[23,4,23,5]]}
["Unit4 ERP"]
["Existing 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."]
["Department "]
["User Details"]
["Full name",null,null,null,null,"Unit4 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,false,false,{"$f":"IF(ISBLANK(H14),\"Provide username of existing user here\",H14)","v":"Provide username of existing user here"}]
["Posting Invoices (SCHOOLS ONLY)",null,null,null,false,false]
["Enquiries (includes budget manager reports)",null,null,null,false,false]
["Raising Requisitions 3",null,null,null,false,false,{"$f":"IF(ISBLANK(H17),\"Provide an e-mail address and delivery address for orders here\",H17)","v":"Provide an e-mail address and delivery address for orders here"}]
["Approving requisitions and invoices 4",null,null,null,false,false,{"$f":"IF(ISBLANK(H18),\"Provide cost codes that user should authorise\",H18)","v":"Provide cost codes that user should authorise"}]
["Invoice Checker ",null,null,null,false,false,{"$f":"IF(ISBLANK(H19),\"Provide cost codes that user should authorise\",H19)","v":"Provide cost codes that user should authorise"}]
["Raising sales orders (debtors invoices) 5",null,null,null,false,false]
["Approving sales orders (debtors invoices) 4",null,null,null,false,false,{"$f":"IF(ISBLANK(H21),\"Please see Guidence notes for further information requirements\",H21)","v":"Please see Guidence notes for further information requirements"}]
["Timesheets (Property and Civil Engineering ONLY) 6",null,null,null,false,false,{"$f":"IF(ISBLANK(H22),\"Provide Start date, hourly rate & approver here\",H22)","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 ",null,null,null,false]
["Additional information/comments",null,null,null,null,null,"Designated Substitute (Checker & Approver ONLY)8"]
[]
[]
[]
[]
["This form needs to be emailed to CR Finance Systems by the Authorising Officer 7  *Must be line manager or equivalent"]
[]
["* Please email 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"]
[]
["Access","Note","Information"]
[]
["Same as existing user",2,"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,"User cannot be a requisitioner as well as an approver. "]
[null,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,"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,"Users must be listed on the Authorised Signatory List to be an approver. Please provide what cost codes user should be approving"]
[]
["Debtor invoices",5,"#"]
["Timesheets",6,"PROPERTY DESIGN and CIVIL ENGINEERING ONLY. Please ensure that you have provided the users COSTCAT (hourly rate), timesheet entry start date and which manager will be authorising their charges."]
[]
["Designated Substitute/s",8,"A substitute must have equal authorisation rights as the user they are substituting for on the Authorised Signatory List and the same access 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."]
["REOPEN USER AND REINSTATE PREVIOUS ACCESS",null,"If a user has be parked recently due to inactivity, you may select to just reinstate previous access. Please note if you have not had access to the system for more 6 months, you are required to complete the form fully."]
["Authorising Officer",7,"This form must be emailed to us directly from the authorising officer as a form of authorisation"]

{"sheet":"Drop down lists","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"Department"]
[null,"Chief Executive "]
[null,"Children Services"]
[null,"Communities "]
[null,"Corporate Services"]
[null,"Education Leisure & PP"]
[null,"Place Infrastructure&Economic Dev"]
[null,"Regeneration"]
[null,"Dyfed - Superannuation Fund "]
[null,"Other (Please provide further details)"]