{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["1. Information","2. Scoring","3. General Requirements","4. Organisation Structure","5. Employee details","6. Onboarding & Recruitment","7. Absence & Leave","8. Self Service","9. CPD & Training","10. Reporting","11. Payroll","12. Expenses","13. System Security","14. Demonstration","15. System View Specifications","16. Total Score Achieved"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"1. Information","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,1,5,2],[10,1,10,2],[9,0,9,2],[4,0,4,2],[2,0,3,2]]}
["Hull College Tender Document for Integrated HR and Payroll System"]
[]
["Providers must ensure that they give a detailed response as to how they will provide the required services. \n\nIf the Provider is unable to comply with the specification of any item or aspect, they must clearly state the manner in which their offer deviates from the specification or requirement.  "]
[]
["The following section specifies the functional requirements for each system module, in the format of a Statement of Requirements table.  Against each requirement a priority has been assigned as follows:"]
["Ranking","Description"]
[1,"Mandatory","The functionality is absolutely necessary in the new system.  A supplier will not be considered further if either the functionality or a suitable work around is not available."]
[2,"Important","Ideally, the functionality should be available, however, if it is not, and a suitable alternative cannot be found, then the supplier is not precluded from further participation in the selection process."]
[3,"Desirable","It would be a bonus if this functionality was available but it is not a key requirement."]
["Hull College will provide a response to each requirement by entering a code using the criteria listed below and by the information provided in the table column entitled ‘Bidders Response’ to support each response:"]
["Code of Response","Description"]
["A","Fully Met","The requirement can be met fully by the standard system."]
["B","Partially Met","The requirement can be met partially by the system – in this case please give details or an alternative solution."]
["C","Bespoke Modification","The requirement can be met after bespoke modifications to the software – in this case please provide costs."]
["D","Future Release","The requirement can be met in a future release of the system – in this case please give release dates where available."]
["E","Cannot be Met","The requirement cannot be met by the system and there are no plans to include the required functionality."]

{"sheet":"2. Scoring","index":1,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[31,1,31,5],[28,0,28,6],[45,0,45,6],[27,0,27,1],[4,0,4,5],[8,2,9,2],[13,0,13,2],[8,0,9,0],[8,1,9,1],[17,0,18,0],[24,0,24,2],[17,1,18,1],[17,2,18,2],[19,0,20,0],[19,1,20,1],[19,2,20,2]]}
["SCORING"]
[]
["Please note that items ranked as “Mandatory” (1) must be \"Fully Met\" (A) in all cases. A supplier will not be considered further if any \"Mandatory\" item cannot be \"Fully Met\""]
[]
["Items ranked as “Important” (2) or “Desirable” (3) will be scored. \n\nThe scores from the compliance of tabs 3 - 13 will contribute 40% of the total score.\n\nThe scores from the compliance of tab 14 will contribute 30% of the total score. \n\nThe Total Whole Life Costs based on 5-year lifespan (Appendix B) will contribute 30% of the total score. Please see tables below:"]
["The tender process will be conducted over 2 phases, phase 1 making up 70% of the final scoring prccess, and will be based on the specification questions and anwers. Phase 2 will be added into the phase 1 and will make up 30% of the final score."]
["Phase 1"]
["Overall Award Criteria","Sub Criteria","Sub Criteria Weighting"]
["Quality – Compliance with Specification\n(40%)","Compliance with Specification \n(tabs 3 - 13)",100]
[]
[]
["Contract Price \n(30%)","Total Whole Life Costs based on 5-year lifespan",100]
[null,null,100]
["Total 70%"]
[]
["Phase 2"]
["Overall Award Criteria","Sub Criteria","Sub Criteria Weighting"]
["Quality – Compliance with Specification\n(40%)","Compliance with Specification \n(tabs 3 - 13)",100,"Carried forward from phase 1 "]
[]
["Quality – Demonstrations \n(30%)","Compliance with Specification \n(tab 14)",100]
[null,null,null,"Please note: A maximum of 5 bidders will be shortlisted for the demonstration / presentation meetings"]
[]
["Contract Price \n(30%)","Total Whole Life Costs based on 5-year lifespan",100,"Carried forward from phase 1"]
[null,null,100]
["Total 100%"]
[]
[]
["Compliance with Specification Rankings & Scores"]
["The total scores achieved from tabs 3-13 (inclusive) will be added together. The grand total will then be awarded a % in line with the table below:"]
[]
["Rank","Code A","Code B","Code C","Code D","Code E","Pass/Fail"]
[1,null,null,null,null,null,"Pass/Fail"]
[2,"Score 5","Score 4","Score 3","Score 2","Score 0"]
[3,"Score 4","Score 3","Score 2","Score 1","Score 0"]
[]
["Total Score Achieved","% Awarded"]
["551-629",0.4]
["441-550",0.3]
["331-440",0.2]
["221-330",0.1]
["111-220",0.05]
["0-110",0]
[]
[]
["Demonstration - Rankings & Scores"]
["The total score achieved from tab 14 will be awarded a % in line with the table below:"]
[]
["Rank","Code A","Code B","Code C","Code D","Code E","Pass/Fail"]
[1,null,null,null,null,null,"Pass/Fail"]
[2,"Score 5","Score 4","Score 3","Score 2","Score 0"]
[]
["Total Score Achieved","% Awarded"]
[15,0.3]
["10-14",0.2]
["5-9",0.1]
["1-4",0.05]
[0,0]

{"sheet":"3. General Requirements","index":2,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[1,"HR / Payroll System – General Requirements"]
[1.1000000000000001,"The HR/Payroll data must operate on a single database.  Data in any common field entered into any screen in any module of the system is immediately automatically updated in all other modules or parts of the system.",1]
[1.2,"The System must be HMRC Accredited. ",1]
[1.3,"The ability to interface/populate other College systems (specifically ProSolution, Xledger and other student systems via Microsoft TSQL, ) and link directly with Microsoft Office Products  e.g. the creation of email, network user accounts etc when a staff member is first appointed.  ",1]
[1.4,"The College currently runs an on premise HR & Payroll system Juniper/Jane.  Please state whether your software provides data conversion routines, detailing the processes involved.",1]
[1.5,"The ability to upload/scan/attach relevant documentation against employees within the appropriate section / All HR file information held on the system.",1]
[2,"HR / Payroll System – General Requirements"]
[2.1,"The applications software must allow user customisations to better enable them to address their operating requirements.\n\nPlease state in detail, outlining the tools / development language (s) involved, how the software provides the following:\n\na)    User customisation of screens and menus\n\nb)    User creation of additional fields and/or tables",2]
[2.2000000000000002,"Please detail what procedures you employ when interfacing your software with other systems, giving appropriate examples.",2]
[2.2999999999999998,"Please indicate any automatic procedures for data handling between systems. ",2,null,null,null," "]
[2.4,"An interface with a Microsoft T-SQL database with a live feed update from HR system to a database with the fields indicated within tab 15. System View Specifications",2]
[2.5,"We would need to be able to update the HR/Payroll system with a staff members internal email address once this has been generated by the college IT system. This is currently stored within a Microsoft T-SQL database.",2]
[2.6,"An interface with a Microsoft T-SQL database with a live feed update from HR system to a database from all areas of the system.",3]
[3,"General Requirements"]
[3.1,"The system should include the following modules:\n\n- Payroll\n- HR, including absence, appraisal, probation, ER issues and induction monitoring\n- Employee Self Service\n- Manager Self Service\n- Expenses\n- SCR\n- CPD Records/ Training Log\n- Ticketing System for Staff queries\n-Applicant tracking including reference request, offer letter and contrct issue.",2]
[3.2,"The system must be able to accommodate:\na) Multiple roles\nb) Multiple pension schemes (Teachers Pension, LGPS and People's Pension, NEST)\nc) User defined multiple pay scales\nd) hourly paid employees\ne) Reference numbers with at least 9 digits\nf) Differences in Sick Pay entitlement based on contracts and service\ng) Different Annual Leave entitlements based on contracts \nh) Two companies with two PAYE numbers\ni) Digital signing of relevant documents to specified groups of staff",1]
[3.3,"Please describe how the system handles multiple users accessing the same record at the same time.",1]
[3.4,"Please describe how the system handles multiple roles, multiple pension schemes and part time hourly paid staff.",1]
[3.5,"The system should provide a facility for both real time and batch updates of records.  Please outline the facilities provided for batch input of data.",1]
[3.6,"The system must offer the facility for validation of both real time and batch transactions.  ",1]
[3.7,"The system must allow for workflow processes to be developed.   ",1]
[3.8,"The system should have the ability to accumulate hours and pay for a range of part time hourly paid staff from and to specific dates.",2]
[4,"General Requirements"]
[4.0999999999999996,"The system must have full context sensitive help screens available within all areas of the system which can be customised for the user.",3]
[4.2,"Error messages must be clear and understandable to a non-technical user, indicating the error and appropriate action required.",2]
[4.3,"The system must provide a test environment where any changes to the system can be tested before being applied to the live environment.",2]
[4.4000000000000004,"Customer service, e.g. SLA for support, dedicated account manager for swift escalation of any technical issues",1]
[5,"Personnel Administration – Organisational Structure"]
[5.0999999999999996,"The system must have the facility to create, maintain, view and store organisational structures.",2]
[5.2,"The system should allow amendments to the organisational structure to include “what if” scenarios on amendments to pay to be done in a test environment prior to updating the live system.",3]
[5.3,"The system should allow future dated changes to the organisational structure and pay to be entered and only actioned at the appropriate time.",3]
[5.4,"When making changes to the organisation structure prior to updating the live environment, the system should indicate the volume of changes and to which units they apply.",3]
[5.5,"The system should have the facility to generate organisational charts that can be viewed on-line and printed.",3]
[5.6,"The system should validate cost codes at time of entry against a file of valid codes held on the finance system",1]
[5.7,"The system should allow the entry of multiple cost codes per post, with the ability to split costs between multiple costs codes",2]
[5.7,"The system should maintain a full history of each post, identifying the date the post was created, all post holders (with dates), periods when the post was vacant",2]
[6,"Employee in Post"]
[6.1,"If an employee has more than one post and they leave the primary post, the system should automatically make the secondary post primary.",1]
[6.2,"The system should have the facility to record temporary variations to the post, and the period for which the variation is effective e.g acting up",2]
[6.3,"The system should allow an employee to temporarily occupy another post e.g. secondment, whilst retaining details of both the substantive post held and the temporary post.",2]
[6.4,"Where an employee is not occupying a post permanently (temporary, fixed term etc) the system should allow the date on which an employee is due to move from the post and an earlier date of when the warning needs to be given of any specific contractual change, to be specified.",2]
[7,"Employee"]
[7.1,"The system should allow changes to an employee record that relate to a future date.",2]
[7.2,"The system should allow global changes to staff records where groups of staff meet the relevant criteria.",2]
[7.3,"The system should flag up and alert users to employment events associated with the employee and prompt for the required action e.g. end of temporary fixed term, end of probationary period, mandatory training due, expiry of RTW check etc.",2]
[7.4,"The system should have the facility to store employee photographs.",2]
[7.5,"The system should have the facility for a reminder to be attached to the employee record that alerts the user at the relevant time to request the probation report from the employee’s line manager.",2]
[7.6,"The system should have the facility to produce probation review forms and induction checklists for the line managers to complete.",2]
[7.7,"The system should be capable of holding probation review forms and induction checklists electronically with employee records.",2]
[7.8,"The system should be capable of holding disciplinary/ capability outcome information. E.g. level of warning, start date of warning and expiry date. ",2]
[8,"AI Capability "]
[8.1,"The tenderer is required to provide a detailed outline of the AI functionality currently available within their products. This should include specific features, capabilities, and case studies where AI is utilised.",2]
[8.1999999999999993,"Additionally, the tenderer must outline any planned future AI developments, including a clear roadmap with estimated timescales for implementation.",2]

{"sheet":"4. Organisation Structure","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[8,"Organisational Structure"]
[8.1,"The system must have the facility to create an organisational hierarchy by making one organisational unit accountable to another.",1]
[8.1999999999999993,"The system must be flexible enough to define common coding structures defined within the College.  Please describe the facility.",1]
[8.3000000000000007,"The system must allow all levels of organisational structure or any combination of levels to be used for reporting purposes.",1]
[8.4,"The system should ensure that an effective date of change is stored against any organisation structure change to ensure that there is accurate point in time reporting.  This means that if the organisational structure changes on a particular date it must be possible to produce reports based on the data before, on and after the effective date.",1]
[8.5,"Where modifications are made to the organisational structure the system must automatically update all underlying data, e.g. global pay awards, with the ability to specify criteria of %, minimum salary or set monetary value of increase; or change to staff reporting structures. Please detail processes for each.",1]
[8.6,"The system must have facilities to carry out the following:\na) Create a new organisational department\nb) Delete or amend an existing department\nc) Move a department\nd) Move posts / employee records between departments\ne) Rename departments\n",1]
[8.6999999999999993,"The system should have facilities to create, amend and delete all posts within the organisational structure.",1]
[8.8000000000000007,"The system must identify posts with a unique number.",3]
[8.9,"The post number format should be user-definable.",3]
["8.10","The system must have the facility to allow each post to be assigned to an organisational department.",1]
[8.11,"The system should allow a hierarchy of posts to be created within an organisational department.",1]
[8.1199999999999992,"The system should allow one or more cost codes to be input against a post, together with the percentage split of costs which applies to each code.",1]
[8.1300000000000008,"The system should hold the budgeted cost for each cost code associated with the post.  It should be possible to input the cost directly, or calculate it based upon the projected salary cost of staff in post.",1]
[8.14,"The system should hold the following key attributes against each staff member:\n\na) Payroll number\nb) Date post commenced/ ends / change to post details (historic, current and future with reasons for change)\nc) Post status e.g. live, suspended, terminated\nd) School/ department, section\ne) Job title\nf) Job code e.g. teaching, assessor, etc. (and ability to crecte new ones) salary grade\ng) FTE (Full time equivalent) hours for post\nh) Contracted hours and weeks per year\ni) Paid hours (calculated field)\nj) Paid weeks per year (term time)\nk) Salary details e.g. min/max bands column point with values\nl) Class of employment (permanent, fixed term, etc)\nm) Conditions of service\nn) Salaried/ fractional salaried/part time hourly paid / term time /volunteers/visiting lecturer/ governors\no) Staff category (e.g. academic, business support, manual, management) update \np) Ethnic group, gender and disability (update all E&D protected characteristic\nq) Qualifications achieved and mandatory and tracking system (eg teachers quals, \nr) DBS and identity checks (expand section)\ns) Probationary, induction,  and appraisal details and period tracker\nt) Absence record with details of sickness, special leave, unpaid leave, paternity, maternity leave and holiday leave\nu) Job families - assign to different posts - clusters\nv) Pension details\nw) Variable working patterns",1]
[8.15,"It must be possible for a post to be occupied by more than one person at a time e.g. job share.",3]
[8.16,"The system should provide flexible manpower planning including:\n\nEmployee audit, staff turnover and/or stability.",1]
[8.17,"Ability for reporting lines for all staff to be updated easily - i.e one record change and applies across the board.  notifications to suggest changes in these instances. ",2]
[8.18,"Fields to be tied - i.e if job title is a lecturer then the lecturer scale is available to select salary point from.",2]

{"sheet":"5. Employee details","index":4,"n_rows":89,"n_cols":6,"rows_kept":89,"cut":false,"hidden":false,"merged":[[19,0,46,0],[47,5,69,5],[47,3,69,3],[47,0,69,0],[47,2,69,2],[19,2,46,2],[19,3,46,3],[19,4,46,4],[47,4,69,4],[19,5,46,5],[70,6,78,6],[81,0,87,0],[81,2,87,2],[81,6,87,6],[81,5,87,5],[81,3,87,3],[70,3,78,3],[70,5,78,5],[70,0,78,0],[70,2,78,2],[70,4,78,4],[81,4,87,4],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,6,9,6],[8,3,9,3],[8,5,9,5],[8,4,9,4]]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[9,"Employee in Post"]
[9.1,"The system must hold all historical post details for an employee with all post details, including history, viewable from within the employee record. ",1]
[9.1999999999999993,"The system must allow ‘Multiple Employment Contracts’ to be held (with differing conditions of service, salary etc).",1]
[9.3000000000000007,"The system must hold a common personal details record for employees with more than one post.",1]
[9.4,"The system should flag clearly if an employee has more than one contract and must also clearly identify which is the primary contract and reporting Line Manager.",1]
[9.5,"The system should be able to report an employee who has multiple posts from being counted more than once in a headcount report.",1]
[9.6,"Any changes to employee post details must hold an effective date of change against the employee’s career history and indicate the reason for change e.g. internal transfer, re-grading etc.",1]
[9.6999999999999993,"The system must allow the normal or default values attached to a post to be overridden on appointment e.g. grade, staff group, job title etc.",1]
[]
[9.8000000000000007,"The system must allow a writeback for an email address created in Microsoft 365 or alternative system",1]
[10,"Employee"]
[10.1,"The system must allow an employee record to be created in the following ways:\na) Via direct entry\nb) Via data transfer\nAn individual response is required to all of the above.",1]
[10.199999999999999,"The system should allow for each transfer of employee from one post to another, i.e. without going through a termination and rehire process.",1]
[10.3,"The system must uniquely identify each employee by an employee number - to accomodate at least 9 digits",1]
[10.4,"The system should have the facility to automatically allocate a staff number. ",1]
["10.5.","The system should allow an easy search for an employee to be restricted to current employees only, leavers only, or a combination of both.",1]
[10.6,"The systems must clearly distinguish between current staff and leavers.",1]
[10.7,"The system should convert contracted hours per week into a FTE figure based on system defined standard full time working hours and taking into account the number of working weeks and variable hours i.e. for term time only and part time hourly paid workers.",1]
[10.8,"As a minimum the system must maintain the following fields of data: ",1]
[null,"Employee:"]
[null,"a)    Staff number"]
[null,"b)    Title"]
[null,"c)     Initials"]
[null,"d)    Forenames"]
[null,"e)     Surname"]
[null,"f)       Previous name"]
[null,"g)     Known as name"]
[null,"h)     Home address"]
[null,"i)       Home phone number"]
[null,"j)       Mobile number"]
[null,"k)     Gender"]
[null,"l)       Personal e-mail address"]
[null,"m)   Date of birth"]
[null,"n)     Continuous service date"]
[null,"o)     Number of years’ service"]
[null,"p)    Category of staff: salaried/part time, Teaching/ Business Support "]
[null,"q)    Annual leave entitlement (calculation of pro rata efficiency days/ bank holidays etc) "]
[null,"r)       Notice period"]
[null,"s)      Qualifications –  level, qualification, subject, result"]
[null,"t)      Professional body membership – date, level, name of body, letters"]
[null,"u)     Details of next of kin / Emergency Contact"]
[null,"v)     National insurance number"]
[null,"w)    ID checks, Work permit details / date"]
[null,"x)      DBS Check conducted"]
[null,"y)     Grievance and disciplinary"]
[null,"z) Preferred pronouns"]
[10.9,"Contract / Post:",1]
[null,"a)    Payroll group"]
[null,"b)    Date joined College"]
[null,"c)     Date started present post"]
[null,"d)    Contract end date"]
[null,"e)     Probation period and end date"]
[null,"f)       Leaving date"]
[null,"g)     Reason for leaving"]
[null,"h)     Nature of contract"]
[null,"i)       Full / part time / term time / fixed term indicator"]
[null,"j)       FTE & hours for post"]
[null,"k)     Working Pattern i.e. days of week/hours "]
[null,"l)       Paid / average hours (calculated field)"]
[null,"m)   Paid weeks per year"]
[null,"n)     FTE (calculated field)"]
[null,"o)     Salary details e.g. min, current and max spinal column point with values"]
[null,"p)    Incremental details / date"]
[null,"q)    Post number"]
[null,"r)       Job title"]
[null,"s)      Faculty / departmental budget area"]
[null,"t)      School/Department"]
[null,"u)     Grade"]
[null,"v)     Teaching/Business Support /Manual classification"]
[10.1,"Equal Opportunities Data:",1]
[null,"The system must comply with all relevant NI EO legislation, for example, covering monitoring of recruitment (internal and external candidates), leavers, and grievance."]
[null,"a)    Gender"]
[null,"b)    Ethnic origin"]
[null,"c)     Marital status"]
[null,"d)    Disability status"]
[null,"e)     Nationality"]
[null,"f)       Sexual Orientation"]
[null,"g)     Religion"]
[10.11,"The system must have the facility to control access to certain screens e.g. EO screens and provide data on EO for analysis purposes.",1]
[11,"Leavers"]
[11.1,"As a minimum the system should maintain the following fields of data:",1]
[null,"a)    Leave date and last working day"]
[null,"b)    Annual leave entitlement recalculated up to the date of leaving"]
[null,"c)     Untaken annual leave"]
[null,"d)    Reason for leaving"]
[null,"e)   Exit interview data"]
[]
[11.2,"The system should link data relating to leavers (such as leaving date) to the payroll module in order to facilitate the calculation of part month salary entitlements where applicable.  This should include a facility to calculate accrued leave for leavers.",1]

{"sheet":"6. Onboarding & Recruitment","index":5,"n_rows":107,"n_cols":6,"rows_kept":107,"cut":false,"hidden":false,"merged":[[53,0,75,0],[53,2,75,2],[53,5,75,5],[53,6,75,6],[77,0,87,0],[77,2,87,2],[77,5,87,5],[77,6,87,6],[53,3,75,3],[77,3,87,3],[53,4,75,4],[77,4,87,4],[21,0,39,0],[21,2,39,2],[21,5,39,5],[21,6,39,6],[40,0,48,0],[40,2,48,2],[40,5,48,5],[40,6,48,6],[21,3,39,3],[40,3,48,3],[21,4,39,4],[40,4,48,4]]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[12,"Recruitment - General Requirements"]
[12.1,"The system should provide facilities for job applicants to apply for posts on-line via the internet.",1]
[12.2,"The system should allow the applicant to fill in the online forms at one go or in part at a time and return at a later date (without losing earlier information) and check details prior to submission and to apply for multiple posts. ",1]
[12.3,"The system should retain profile information in order that they can be accessed by the applicant to ease the process of applying for multiple roles",1]
[12.4,"Applicant tracking system - talent pool, ability to track applicants, store data, shortlist, schedule interviews, ",2]
[12.5,"Different levels of access per user: HR, recruiting manager, applicant, administrator etc",1]
[12.6,"On closing, all applications sent automatically to manager on date specified.  Ability for manager to online shortlist, input interview details, send unsuccessful emails and request offer.  Ability for HR user to view, and over-ride. ",2]
[12.7,"The system must support the production of correspondence to applicants, referees etc at all stages of the recruitment process to include:\n\na) Information packs\nb) Application forms\nc) Reference request\nd) Invitations to interview and other events\ne) Notification of decisions\nf)  Letters of appointment\nh) Contracts of employment\ni) Employment forms\nj) Induction pack - mandatory training information and links to policies etc.",1]
[12.8,"The system should store dates against the candidate record/checklist for all correspondence that has been sent/docs applicable returned.",1]
[12.9,"The system should have a diary facility to alert the user. ",2]
[12.1,"It must be possible to commence, terminate and recommence the recruitment process at any stage.",1]
[13,"Recruitment System Processes"]
[13.1,"The system must have the facility to allow the systems administrator to define and set up recruitment processes and stages to suit College requirements.",1]
[13.2,"The system should:\na)    Identify vacancy against post;\nb)    Approve recruitment of post via appropriate levels of authorisation;\nc)    Record applicant (including internal);\nd)    Regularly update status of applicants throughout process;\ne)    Allow confirmation that all checks are completed i.e. medical, references etc.\nf)    Job offer;\ng)   Confirm all paperwork has been received\nh)    Attach appointed applicant to payroll ",2]
[13.3,"The system must allow for all recruitment paperwork to be attached to the vacancy i.e. adverts, job description etc.",1]
[13.4,"The system must be able to integrate with external job boards",1]
[14,"Vacancy Record"]
[14.1,"The system should provide a mechanism for the authorisation of a new post, potentially through the work flow process.",2]
[14.2,"The system must produce a report to shortlist candidates accessible by multiple users",1]
[14.3,"The system should have the facility to produce a progress report against each vacancy.",2]
[14.4,"The system should have the facility to hold data against each vacancy as below.",2]
[null,"a)    Vacancy reference number"]
[null,"b)    Vacancy status"]
[null,"c)    Post number"]
[null,"d)    Job title"]
[null,"e)    Post type"]
[null,"f)     Grade"]
[null,"g)    Salary – min and max"]
[null,"h)    Department/Cost centre"]
[null,"i)      Date advertised"]
[null,"j)      Closing date"]
[null,"k)    Interview date"]
[null,"l)      Names of applicants"]
[null,"m)   E and D stats to include gender, ethnicity etc"]
[null,"n)    Informal contact details"]
[null,"o)    Media details and costs"]
[null,"p)    Interview panel details"]
[null,"q)    Vacancy authorisation / approval details"]
[null,"r)     Date authorised / approved"]
[14.5,"For each vacancy the following key dates should be available to assist in the monitoring processes:",2]
[null,"a)    Date post approved"]
[null,"b)    Date post advertised"]
[null,"c)    Closing date for applications"]
[null,"d)    Interview dates"]
[null,"e)    Date written offer made"]
[null,"f)     Regret notification"]
[null,"g)    Reserves"]
[null,"h)    Commencement date\ni)     Shortlisting Date\nj)     Date all appointment info received from hiring manager\nk)    Date references requested \nl)     Date(s) references received\n\n"]
[15,"Applicant record"]
[15.1,"The system must distinguish between internal and external candidates.",1]
[15.2,"The system should link internal candidates with their full data records.",2]
[15.3,"The system must clearly flag at what stage the candidate is at within the recruitment and selection process e.g. applied, interview, offer etc. ",1]
[15.4,"The system should hold the following fields of data against each applicant:",2]
[null,"a)     Post number applied for"]
[null,"b)    Post title"]
[null,"c)    Title"]
[null,"d)    Initials"]
[null,"e)    Forenames"]
[null,"f)     Surname"]
[null,"g)    Address"]
[]
[]
[null,"j)      Preferred telephone number"]
[null,"k)    Date of birth"]
[null,"l)     Age  (automatically derived from dob)"]
[]
[null,"n)    Ethnic origin"]
[null,"o)    Gender"]
[null,"p)    Disability"]
[null,"q)    Professional registration"]
[null,"r)     Previous employment history"]
[null,"s)     Educational qualifications (must specify level of Maths, English and Teaching Qual)"]
[null,"t)     Reference details"]
[null,"u)    Work permit details"]
[]
[16,"Contract Details"]
[16.100000000000001,"In addition to information held on the applicant record, the system should hold the following information to enable contracts to be produced:",2]
[null,"a) Contracted hours"]
[null,"b) Start date"]
[null,"c)    Leaving date (if applicable i.e. for fixed term contracts)"]
[null,"d)    Continuous service date"]
[null,"e)    Starting salary"]
[null,"f)     Department/ Cost centre"]
[null,"g)    Pension"]
[null,"h)    Notice period"]
[null,"i)      Annual leave entitlement – automatically calculated"]
[null,"j)      Probation details"]
[16.2,"The system must allow contracts to be easily adapted e.g. fixed term contracts.",1]
[16.3,"The system must have the capacity to hold standard templates - offer letters, contracts and be editable",1]
[17,"Onboarding"]
[17.100000000000001,"Onboarding portal - allows new starters to view key information about the College, e.g. maps, videos, org charts, manager and team info, contacts, policies, benefits etc before they commence employment",2]
[17.2,"User ability to use Onboarding module from multiple devices (i.e. smartphone friendly)",2]
[17.3,"All applicant details to be populated to onboarding portal and relevant forms",2]
[17.399999999999999,"The portal should allow new starter to view onboarding checklist, upload certificates/files, complete forms electronically and view progress. ",2]
[17.5,"Able to store documents and new starters ability to digitally sign policies and contracts etc",2]
[17.600000000000001,"Ability to store key documents and flag expiry dates e.g. RTW documentation",1]
[17.7,"Onboarding checklist to be customisable by HR team with editable due dates and flags",1]
[17.8,"References - pull out fields from application and email requests. automatic reminders sent if response not received and flags for HR user ",2]
[17.899999999999999,"Populate data to HR / payroll record, IT, Staff Development, customer service team etc\n",1]
[17.100000000000001,"New starters checklist - include mandatory training, induction etc and be accessed by different levels of user",2]
[17.11,"Managers to be able to view status of onboarding and new starter checklists",2]
[17.12,"Reporting feature to extract information at all stages, current and past staff and on boarders including E & D, recruitment data, ",1]
[17.13,"The portal should allow individuals to complete online enhanced DBS check ",2]
[17.14,"The ability to create and share an Induction schedule with new starters and their managers",2]
[17.149999999999999,"Ability to onboard canidates that maybe haven't applied through typical process, i.e. freelance/consultants",2]
[null,null,null,null,{"$f":"SUM(E3:E104)","v":0}]

{"sheet":"7. Absence & Leave","index":6,"n_rows":84,"n_cols":6,"rows_kept":84,"cut":false,"hidden":false,"merged":[[34,0,40,0],[34,2,40,2],[34,5,40,5],[34,6,40,6],[44,0,48,0],[44,2,48,2],[44,5,48,5],[44,6,48,6],[34,3,40,3],[44,3,48,3],[34,4,40,4],[44,4,48,4],[77,0,81,0],[77,2,81,2],[77,5,81,5],[77,6,81,6],[77,3,81,3],[77,4,81,4]]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[18,"Absence / Leave - General requirements"]
[18.100000000000001,"All absence / leave must be entered onto the system using the same function and categorised accordingly.",1]
[18.2,"The system must hold and express absence / leave in different units of time to include days, half days and hours (for holidays).",1]
[18.3,"The system must hold a complete historical record for year to year comparisons of all absence / leave against an employee by date",1]
[18.399999999999999,"The system must hold a complete historical record of all absence/leave against a post, by date so that when an employee transfers to a different department the absence they accrued in their old department still shows.",1]
[18.5,"The system should hold work patterns and identify rest days, bank holidays or weekends within an absence / leave period.",1]
[18.600000000000001,"Ability for managers/staff to record absences through the self service module with line manager level of authorisation.  Can tenderers please provide details.",1]
[19,"Sickness Absence"]
[19.100000000000001,"The system must allow absence records to be input or amended retrospectively including leavers.",1]
[19.2,"As a minimum the system must record the following details:\na) First and last day of absence including year\nb) Day of the week\nc) Certification type, e.g. self, doctors\nd) Reason for sickness\ne) Sick note details (including flag for sicknote expiry)\nf) Workplace injury indicator",1]
[19.3,"The system should have the facility to automatically calculate Statutory Sick Pay with an appropriate link to the Payroll module for payment.  The payroll user should have the ability to override the calculation.",1]
[19.399999999999999,"The system should have a facility to automatically calculate College Occupational Sick Pay based on different scheme rules for salaried and part time staff both with an appropriate link to the payroll module for payment adjustments as a result of half and no pay entitlements.  The payroll user should have the ability to override the calculation.",1]
[19.5,"Absence notification - over 7 days - fit note - to managers\nOver 14 days, Over 28 days\nReturn to work - shows absence history summary with days\nOccasion trigger and advice on action to Manager\nSick pay notifications - half pay / no pay approaching - to employee and employer\nPhased return - with impact on sick entitlement",1]
[20,"Maternity , Paternity and Adoption Leave "]
[20.100000000000001,"The system should hold all relevant dates associated with each type of leave.",1]
[20.2,"Ability to calculate outstanding leave based on maternity leave start date and leave accrued whilst on maternity leave. taking into account BH and local holidays in line with policy (custom & practice).  ",2]
[20.3,"Automatic reminder for managers to either end absence or confirm they are in touch with employee. ",2]
[21,"Annual leave"]
[21.1,"The system should allow the allocation of annual leave based on different combinations for staff categories.",1]
[21.2,"It should be possible to globally update employee leave entitlements in advance in readiness for the start of the leave year.",1]
[21.3,"The system should have the facility to alter the number of days leave for an employee.",1]
[21.4,"As a minimum the system should hold the following fields of data:\na) First and last day of absence including year\nb) Unit of time e.g. days, half days, hours.",1]
[21.5,"The system should hold details to show if leave is paid or unpaid with the corresponding link to the payroll module as appropriate.",1]
[21.6,"The system should have the facility for employees to book leave on-line and have it authorised by their line manager on-line with the details automatically updated on their personal record and email notifications sent back to the staff.",1]
[22,"Special Leave"]
[22.1,"As a minimum the system must have the facilities to store the following categories of special leave:\na) Career break\nb) Life Events\nc) BereavementCompassionate\nd) Jury service\ne) Training with reserve and cadet forces\nf) Crisis Leave\ng) Other – with notes\nh) Carers Leave paid and unpaid",1]
[22.2,"As a minimum the system should hold the following fields of data:\na) First and last day of absence including year\nb) Unit of time e.g. days, half days, hours.\nc) Reason for leave",1]
[23,"Parental Leave"]
[23.1,"As a minimum the system must have the facility to store the following:\na) Parental leave taken with previous employers\nb) Parental leave taken during the employees employment at the College ",1]
[23.2,"As a minimum the system must hold the following fields of data:\na) First and last day of absence including year\nb) Unit of time, e.g. days, hours",1]
[23.3,"Where appropriate the system should hold the leave entitlement and calculate what leave is remaining. ",1]
[24,"Disciplinary"]
[24.1,"The system should allow details of disciplinary / capability procedures to be maintained and recorded against an employee record.",1]
[24.2,"As a minimum the system should hold the following fields of data:",1]
[null,"a)    Date"]
[null,"b)    Disciplinary Stage – informal /formal "]
[null,"c)    Reason"]
[null,"d)    Comments"]
[null,"e)    Review date"]
[null,"f)     Expiry date\ng)   Reccomendations"]
[24.3,"The system should prompt and flag up review dates and expiry date.",2]
[25,"Grievance"]
[25.1,"The system should allow details of employee grievances to be maintained and recorded against an employee record.",1]
[25.2,"As a minimum the system should hold the following fields of data:",1]
[null,"a)    Date and nature of grievance"]
[null,"b)    Parties involved"]
[null,"c)    Log of actions taken"]
[null,"d)    Comments"]
[25.3,"The system should prompt and flag up review dates.",2]
[26,"Leavers"]
[26.1,"The system should allow a leaver to be re-instated with a new pay reference number and flag fields that need to be updated or confirmed as accurate such as bank details.",2]
[26.2,"The system should allow leaver records to be amended.",2]
[26.3,"The system should provide the facility to create an on-line leavers exit interview /questionnaire that can be completed by the departing employee and held on their record for future analysis.",2]
[27,"Absence / Leave - General requirements"]
[27.1,"The system should have warning prompts to highlight where a period of absence / leave exceeds a user-defined absence trigger of time or other user-defined criteria e.g entitlement to full and half pay. ",2]
[27.2,"The system should have a summarised planner facility to show all absence / leave against an employee or organisational department.",2]
[27.3,"The system should have the option to display absence graphically and analyse data in terms of short term, long term and by reason and staff category with historical information.",2]
[27.4,"The system must allow categories of leave to be established with user defined absence reasons attached to each category.  ",2]
[27.5,"The system must hold a summarised sickness absence record by user defined year against an employee showing: total hours/day sick, total episodes of sickness, % absence.",2]
[27.6,"The system should have facilities to identify pattern of sickness absence based on user defined criteria.",2]
[27.7,"The system should have facilities to cost absence based upon corresponding payroll costs.",2]
[27.8,"The systems provide alerts such as when a self cert is required or fit note and when a fit note expires.",2]
[28,"Maternity Leave"]
[28.1,"The system should enable production of standard letters at appropriate points during the maternity leave period",2]
[28.2,"The system should have the facility to automatically calculate Statutory Maternity Pay with an appropriate link to the Payroll module for payment.",2]
[28.3,"The system should have a facility to automatically calculate Occupational Maternity Pay with the appropriate link to the payroll module for payment.  The payroll user should have the ability to override the calculation.  ",2]
[28.4,"Maternity, key date notifications, MatB1, start date of mat leave,  reminder to notify when baby born, letter to congratulate, changes to mat pay, notice reminder if wish to return early, prompts to mangers to contact employee while on mat leave, KIT day info for manager and employee and KIT day recording that notify's payroll, return to work info (shared with manager)",2]
[29,"Adoption Leave"]
[29.1,"The system should enable production of standard letters at appropriate points during the adoption leave period ",2]
[29.2,"The system should have the facility to automatically calculate Statutory Adoption Pay with an appropriate link to the Payroll module for payment.",2]
[29.3,"The system should have a facility to automatically calculate Occupational Adoption Pay with the appropriate link to the payroll module for payment.  The payroll user should have the ability to override the calculation.  ",2]
[30,"Paternity Leave"]
[30.1,"The system should enable production of standard letters at appropriate points during the paternity leave period",2]
[30.2,"The system should have the facility to automatically calculate Statutory Paternity Pay with an appropriate link to the Payroll module for payment.",2]
[30.3,"The system should have a facility to automatically calculate Occupational Paternity Pay with the appropriate link to the payroll module for payment.  The payroll user should have the ability to override the calculation.  ",2]
[31,"Annual leave"]
[31.1,"The system should show a summarised record of annual leave against specific criteria (e.g. tax year, financial, academic or calendar year) against the employee record to include:",2]
[null,"a)    Annual leave entitlement"]
[null,"b)    Total leave taken – calculated automatically"]
[null,"c)    Leave carried forward"]
[null,"d)    Leave remaining – calculated automatically"]
[31.2,"The system should facilitate additional leave types to be added where necessary.",2]
[31.3,"Where an employee has multiple posts the system only requests authorisation for the Manager where leave is falling on working days for each job not all Managers notified of all requests",2]

{"sheet":"8. Self Service","index":7,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,7,0],[2,2,7,2],[2,5,7,5],[2,3,7,3],[6,1,7,1],[2,4,7,4]]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[32,"Self Service"]
[32.1,"Please provide details of the self service facilities supplied with your software.",1]
[]
[null,"Particular attention should be given to:"]
[null,"i) employee and manager self-service for all absences and other functions"]
[null,"ii) self-service for  part time variable pay by  submission of hours worked (timesheets) against planned hours, variance, exception reports and authorisation process, overtime claims, small number of hours worked in another area with different coding and different rates of pay"]
[]
[32.200000000000003,"Please outline in detail how your self service module(s) could interface with the current software used by the College - Teams, Outlook, Finance, MIS",1]
[32.299999999999997,"The system should provide automated emails triggered by employee/manager input.",1]
[32.4,"Ability for employee's to access parts of HR file eg. job descriptions, contracts, application form, offer letters etc.",2]
[32.5,"Ability for employee's to access all current and historical payslips and P60's.",2]
[32.6,"Ability for managers and employees to review leave records in a calendar format",3]
[33,"Time & Attendance"]
[33.1,"The system should hold working patterns for staff and self-service for absence monitoring.",1]
[33.200000000000003,"The working patterns should be customisable by HR/Payroll users, and must be able to show a repetition on a weekly, fortnightly, 10 days, monthly or annual basis.",1]
[33.299999999999997,"Working patterns should be definable to an accuracy of 15 minutes.",1]
[33.4,"Working patterns should be integrated with both holiday booking and absence booking to calculate actual absence and holiday allowances against the working pattern.",1]
[33.5,"Pro-rata of bank holidays and local holidays as defined by the College and determined by the working pattern ",1]
[33.6,"Facility to record flexi-time and Lieu Time",2]

{"sheet":"9. CPD & Training","index":8,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[34,"Staff Training"]
[34.1,"Facilitate the identification of training needs",2]
[34.200000000000003,"Create an internal programme of training events, with registers that links to CPD records",2]
[34.299999999999997,"Enable staff to enrol/unenrol onto the internal programme of training events",2]
[34.4,"Maintains a history of training acitivity by year",2]
[34.5,"Monitor training, part time pay, travel and accommodation budgets by organisation, department and staff member",2]
[34.6,"Produce comprehensive reports on training acitivity by staff member or department",2]
[34.700000000000003,"Enrolment of internal training events to integrate with outlook calendars",2]
[35,"CPD"]
[35.1,"Recording of CPD to allow staff to reflect and evaluate impact over time",2]
[35.200000000000003,"Ability to remind staff to record CPD to reflect on training",2]
[35.299999999999997,"Enable to assign/unassign staff to managers for development reviews and maintain accurate training records",2]
[35.4,"Enable the evaluation of training to take place and monitor CPD hours",2]
[35.5,"Allow for certificate, notes etc to be uploaded onto CPD records",2]
[35.6,"Online CV with qualification tracker to enable a central information bank on staff qualifications for external compliance, course approvals, validations and knowledge/skills mapping.  Individuals should be able to update their own area and should have the capacity for multiple inputs.  Should be searchable and reportable to identify skills and expertise at an individual, deparmental and organisational level.",2]
[36,"Progress Development Review"]
[36.1,"Reflect multiple times a year -  reflect, development progress, forward targets",2]
[36.200000000000003,"Link reflection to CPD record",2]
[37,"Performance Development Plans (Informal and Formal)"]
[37.1,"The ability to create and store performance plans against employee records, viewable by both manager and employee",2]
[37.200000000000003,"The ability to report on number of staff on any stage of performance plan",2]
[38,"One to One records"]
[38.1,"The ability to create and store one to one documentation within the system",2]

{"sheet":"10. Reporting","index":9,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[15,0,29,0],[15,2,29,2],[15,5,29,5],[18,1,19,1],[15,3,29,3],[15,4,29,4]]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[37,"Reporting"]
[37.1,"The system must have common report writing tool(s) that are used across all modules of the system. ",2]
[37.200000000000003,"The report writing tool(s) must be capable of being used by non-technical users, in terms of both running reports that have already been defined and developing new reports and should be flexible enough to write complex ad hoc reports. \n\nSupport/help line facility readily available if required",1]
[37.299999999999997,"The system must have the ability to output all reports into a spreadsheet format where necessary for amending and formatting standard fixed reports.",1]
[37.4,"Please describe in detail the reporting facilities provided by the system.",1]
[37.5,"Please indicate what ‘ad-hoc’ reporting tools are supplied / recommended with the system.  Are there any additional costs / licensing issues associated with these tools? ",1]
[37.6,"Please outline any standard reports supplied with the system.  ",1]
[37.700000000000003,"The system must allow reporting on both current and historical data.",1]
[37.799999999999997,"When reporting on historical data the system should take full account of any staff changes e.g. recreating the profile of the college at a specified point in time and between specific dates.\n\nPlease outline the systems ability to provide a complete data driven history of core data including from and to dates.",1]
[37.9,"The system must allow all reports to be run as a point in time query or between date ranges.",1]
[]
[37.1,"The system should allow all reports to be broken down and grouped by any data item stored within the system e.g. organisational level, grade, job title etc.",1]
[37.11,"Facility to output data from reports directly into MS office applications - Excel, Word for mail merges etc.",1]
[37.119999999999997,"Absence reporting - total available work days, days lost, absence % rates, cost of absence split down by department and job category",1]
[37.130000000000003,"An individual response is required to all of the points below.",3]
[null,"The reporting tool must offer:"]
[null,"a)    Display reports in a graphical format"]
[null,"b)    Create report prompts so that on opening a report the user is prompted to amend the variables."]
[]
[null,"d)    Calculate user defined sub totals (eg on change in field x, insert subtotal) and grand totals"]
[null,"e)     Perform mathematical formula on report data "]
[null,"f)    Sort report data in ascending or descending order by columns"]
[null,"g)    Group report data on one or more columns"]
[null,"h)      Search on the report data eg using a find option"]
[null,"i)      Parameters for the selection of report data should include operators such as: and, or, not, like, <, >, +, -, etc and also allow a ‘wildcard’ selection"]
[null,"j)    Store standard report filters (including calculation formula) that can be accessed for inclusion in new reports."]
[null,"k)      Direct report output to a local or network printer, to the screen or another output device"]
[null,"l)   Format reports using page breaks, headers and footers, margins, font etc"]
[null,"m)    Provide statistical run information eg number of records processed, number of records extracted, number which failed extraction criteria."]
[38,"Staff Individualised Record (SIR)"]
[38.1,"The system must be continually updated to take into account any changes as required for the return of the SIR.  https://www.gov.uk/government/publications/further-education-workforce-data-collection",1]
[39,"Establishment reporting"]
[39.1,"The system should have the facility to identify the budgeted establishment against actual for salaried and part time pay.",1]
[39.200000000000003,"The system should provide facilities for the on-screen display of information relating to establishment, actual staff in post.",1]
[39.299999999999997,"Orgaisation Charts - facility to produce organisation charts and to isolate sections to view eg. within business areas, management teams and departments.",1]
[40,"Single Central Record"]
[40.1,"The system should have the facility for live reporting on the checks held by the College in line with Ofted requirments for the SCR",1]
[41,"Gender Pay Gap Reporting"]
[41.1,"The system should have the facility to report on Gender Pay Gap",1]
[42,"Staff Turnover Reporting"]
[42.1,"The system should have the facility to report on Staff Turnover in line with the AOC formula",1]
[43,"Facility Time Reporting"]
[43.1,"The system should have the facility to report on Union activity",1]

{"sheet":"11. Payroll","index":10,"n_rows":170,"n_cols":6,"rows_kept":170,"cut":false,"hidden":false,"merged":[[157,0,158,0],[157,1,158,1],[157,2,158,2],[157,5,158,5],[157,6,158,6],[157,3,158,3],[157,4,158,4],[125,0,127,0],[125,2,127,2],[125,5,127,5],[125,6,127,6],[142,0,144,0],[142,2,144,2],[142,5,144,5],[142,6,144,6],[125,3,127,3],[142,3,144,3],[125,4,127,4],[142,4,144,4],[117,0,118,0],[117,2,118,2],[117,5,118,5],[117,6,118,6],[119,0,121,0],[119,2,121,2],[119,5,121,5],[119,6,121,6],[117,3,118,3],[119,3,121,3],[117,4,118,4],[119,4,121,4],[94,0,105,0],[94,2,105,2],[94,5,105,5],[94,6,105,6],[107,0,114,0],[107,2,114,2],[107,5,114,5],[107,6,114,6],[113,1,114,1],[94,3,105,3],[107,3,114,3],[94,4,105,4],[107,4,114,4],[52,0,56,0],[52,2,56,2],[52,5,56,5],[52,6,56,6],[57,0,68,0],[57,2,68,2],[57,5,68,5],[57,6,68,6],[52,3,56,3],[57,3,68,3],[52,4,56,4],[57,4,68,4],[35,0,46,0],[35,2,46,2],[35,5,46,5],[35,6,46,6],[47,0,51,0],[47,2,51,2],[47,5,51,5],[47,6,51,6],[35,3,46,3],[47,3,51,3],[35,4,46,4],[47,4,51,4],[4,0,6,0],[4,2,6,2],[4,5,6,5],[4,6,6,6],[21,0,24,0],[21,2,24,2],[21,5,24,5],[21,6,24,6],[4,1,5,1],[4,3,6,3],[21,3,24,3],[4,4,6,4],[21,4,24,4]]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[40,"Payroll - General Requirements"]
[40.1,"The payroll system must comprise payroll and fully integrated HR and pension functions",1]
[{"$f":"A3+0.1","v":40.200000000000003},"The system must be capable of supporting a large number of employees 1,000 +",1]
[{"$f":"A4+0.1","v":40.300000000000004},"The system must comply with all current and future statutory government legislation for the United Kingdom including:  RTI, auto enrolment within approved pension schemes (LGPS and TP), and have achieved Inland Revenue ‘Payroll a standard’ or other independent system accreditation (valid for the latest recommended release of software and current tax year).",1]
[]
[null,"Please specify how auto enrolment procedures for identification of eligible and entitled employees, communication procedures and reports will be dealt with.  In particular how part time, hourly paid variable hours contracts and multiple contracts within the same scheme(s) will be managed to meet legislative requirements. Procedures must include ongoing and tri-annual duties."]
[{"$f":"A5+0.1","v":40.400000000000006},"The system must be capable of handling a variety of contracts and complex roles where employees have multiple roles  with different rates of pay and pension schemes",1]
[40.5,"The system must facilitate both import and export of data. This should include a timesheet module/facility (desirable). If you have a timesheet module, please specify the procedure from end to end.",1]
[40.6,"The system must maintain a payroll calendar for each tax year.",1]
[40.700000000000003,"Gross to net, net to gross calculations, incorporating all statutory and non-statutory processes.",1]
[40.799999999999997,"NIC limits, percentages and table values.",1]
[40.9,"SSP, SMP, SAP, SPP values and formula.",1]
[40.1,"Attachment of Earning Orders values and formula. ",1]
[40.11," Loan values and formula.",1]
[40.119999999999997,"Capable of automatically apportioning NI calculation over a specified number of pay periods and recording the number of pay periods involved against that pay period’s pay or NI details. (i.e New Staretrs).",1]
[40.130000000000003,"Facility to recalculate NIC where there is a back date spread of NI and pay back NI and pension contributions over paid. ",1]
[40.14,"Automatically validate data input for statutory items such as Tax Code, NIC letter, NI number against employee information to ensure compliance with obligations to Inland Revenue.",1]
[40.15,"Tax year end returns.",1]
[40.159999999999997,"Monthly Pension Returns for Teachers Pension - Monthly Contributions Reconciliation (MCR) and the Local Government Pension Scheme ",1]
[40.17,"Arrears calculations – gross pay and permanent additions. ",1]
[40.18,"Pension calculations for a number of schemes and it must take into account changes in the LGPS and TP in line with contribution banding.",1]
[]
[]
[null,"Please state how this will be calculated for each scheme.  For example, how would it calacualte Members in TP with 1 contract/2 rates of pay  (Role ID's) or Multiple Contracts with multiple rates . "]
[40.19,"Allow for the transfer of individuals between payrolls, ensuring that all cumulative, permanent and statutory details for the individual for the current tax year are carried forward and the old figures zeroised.",1]
[40.200000000000003,"The system must be able to process payrolls in a new tax year while the year-end data is still being amended, by way of a facility to create a copy payroll.",1]
[40.21,"Facility to manually override current cumulative totals for e.g. tax, national insurance, pension contributions etc.",1]
[40.22,"Allow for the suspension of employees from the current or set number of future pay cycles and allow non-payment adjustments / updates to be made during suspension e.g. NI no, Pay cumulative etc.",1]
[40.229999999999997,"Maintain full pay history for each employee.",1]
[40.24,"Ability to enter batch changes to central tables e.g. rates, allowances, deductions etc, and simultaneously update all affected contracts automatically.",1]
[40.25,"Timesheet module  with costings and approval facilities etc.",2]
[40.26,"Allow for payments to be made to leavers even if in previous tax year e.g. retrospective payment of arrears.",1]
[41,"Pay and Deduction Elements"]
[41.1,"The system must allow the user to create and update an unlimited number of defined pay elements with values that are positive or negative and payable per annum, cyclic period, week, day, hour, and other time period with minimal user effort.",1]
[41.2,"It must be possible to update pay elements by individual or specified group.",1]
[]
[null,"As a minimum, the user must be able to define pay elements as follows:"]
[null,"a)    Input in various formats e.g. cash, time, hours etc"]
[null,"b)    Attach formula for the calculation of the element e.g. overtime at various rates"]
[null,"c)    Define each element as Taxable or Non Taxable"]
[null,"d)    Define each element as Pensionable or Non Pensionable"]
[null,"e)    Hold individual period and cumulative increasing or decreasing balances for each element to include part time pay"]
[null,"f)     Definable as a benefit i.e. is taken into consideration for the calculation of NI/Tax/Pension contributions but is not actually paid"]
[null,"g)     Define each element for Gender Pay Gap Report"]
[null,"h)     Define each element for NLW/NMW check"]
[null,"i)    Ability to create notional components to produce charges to journals, charges to departments etc "]
[41.3,"The system must allow pay elements to be both permanently and / or temporarily attached to an employee’s record.  ",1]
[]
[null,"Payment should be calculated based on the employee pay frequency and take due consideration of holiday periods where input for permanent pay elements and any calculations rules attached to the element. "]
[]
[null,"Permanent pay elements should be date terminated and should allow for temporary overrides / adjustment in any given pay period."]
[41.4,"The system must be capable of automatically calculating components of gross pay to produce multi, full and part period values as follows:",1]
[null,"a)    Pro rata calculation of permanent pay elements for mid-period new starter and leaver records"]
[null,"b)    Application of pay elements with annual values by equal periodic values"]
[null,"c)    Pro rata calculation of elements for part time staff based on ‘contract hours’ or FTE equivalents or percentage"]
[null,"d)    Payment of hourly overtime rates based on a multiple of the basic hourly rate and average overtime pay for regular paid overtime when holiday is taken. Please state how this would be calcualated and detailed on the payslip. (Currently, we show the current overtime payment and the holiday overtime payment sepearatley.)"]
[41.5,"The system must provide the ability to create and update user defined deduction elements with values that are deducted based on payroll frequency, with minimal effort.",1]
[]
[null,"As a minimum, it must be possible to define deduction elements as follows:"]
[null,"a)    Input in various formats e.g. cash, time hours etc."]
[null,"b)    Attach formula for the calculation of the element e.g. overtime at various rates"]
[null,"c)    Deduction may be defined as before or after tax"]
[null,"d)    Hold individual period and cumulative increasing or decreasing balances"]
[null,"e)    Ability to terminate permanent deductions by date or balance total"]
[null,"f)     Partial deduction / payment allowable in final pay period (e.g. balance was £150, £20 deducted per month, therefore in month 8 will take £10 only)"]
[null,"g)    Reclaim of outstanding balances for leavers"]
[]
[null,"The system must allow for the input and calculation of salary sacrifice, e.g. cycle to work, childcare vouchers and hold individual employee records and accumulative totals by reference to tables where applicable."]
[41.6,"The system must allow deduction elements to be defined as both permanent or temporary",1]
[41.7,"The system must allow temporary override or adjustment to permanent deduction elements.",1]
[42,"Payroll Reporting"]
[42.1,"Net pay report – including numbers of employees / payment method within user defined groups for the current payroll period.",1]
[42.2,"Pay group summary report – basic pay, taxable additions, non-taxable additions, deductions etc.",1]
[42.3,"The system must provide a data file in BACS form for electronic exchange of data to BACS each pay cycle.",1]
[42.4,"Ability to email and print and export P45’s for publishing (i.e. Paydashboard) NB: NI Number will be blocked by our email systems rules if sent outside the college. Preference to publish and leavers have access to payslips/documents for a period after leaving).",1]
[42.5,"New starters and leavers.",1]
[42.6,"Pay awards – current month and back dated.",1]
[42.7,"Exceptions – to include reports of any aborted functions during processing.",1]
[42.8,"National Insurance analysis / cumulative",1]
[42.9,"Pensions analysis / cumulative, including auto enrolment criteria in line with legal requirements.",1]
[42.1,"Cumulative pay analysis.",1]
[42.11,"Monthly permanent / temporary additions analysis / cumulative.",1]
[42.12,"Each pay period the system must be capable of producing output of all pay and deduction elements making up each individual employee’s current pay and to date totals.",1]
[42.13,"Reports of all BACS payments – individual names, bank sort code and account number.",1]
[42.14,"The system must provide facilities to produce additional clear, accurate stationery, P45’s, P60’s, tabulations and reports.",1]
[42.15,"The system must provide the facility for payslips and P60’s to be sorted in user defined order.",1]
[42.16,"The system should provide facilities for payslips and P60’s to be available to employees online via the web or email.  _ Paydashboard Portal for staff is our preferred method.  Please indicate if your system will generate necassary pdf's for publishing.",1]
[42.17,"The system should provide facilities for individual employees to view and print historical and current payslips via web browser access.",1]
[42.18,"The system must provide the facility to produce cumulative reports by both tax year and date specified. ",1]
[42.19,"The system must provide the facility to write our own payroll reports or create customised/ad hoc reports. ",1]
[42.2,"The system must provide a Journal and be capable of producing costing reports for use by Finance.",1]
[42.2,"The system be capable of producing a Gender Pay Gap Report",1]
[43,"Absence Recording – Payroll"]
[43.1,"The system must have the facility to record and calculate payments due for all absences / leave against an employee including:",1]
[null,"a)    Contractual leave entitlement"]
[null,"b)    Occupational sick pay"]
[null,"c)    Statutory sick pay"]
[null,"d)    Occupational maternity pay"]
[null,"e)    Statutory maternity pay & Shared parental pay"]
[null,"f)     Statutory maternity pay reclaim "]
[null,"g)    Statutory paternity pay"]
[null,"h)    Statutory adoptive pay"]
[null,"i)    Statutory neonatal pay"]
[null,"J) Staturory Parental Bereavement Pay"]
[null,"j)   Approved unpaid leave and reason e.g. career break, secondment, annual leave entitlement expired."]
[44,"Pension Schemes and AVC’s"]
[44.1,"The system must provide facilities to create and update a number of user defined occupational pension, and AVC schemes.",1]
[null,"Supports both Teachers Pension and LGPS Requirements"]
[]
[null,"As a minimum requirement the system must be capable of defining a pension scheme as follows:"]
[null,"a)    Employee and employer contributions to be based on cash, percentage or formula calculation and the ability to select /include multiple pensionable pay elements"]
[null,"b)    Hold individual period and cumulative pensionable pay and contribution balances for reconciliation purposes."]
[null,"c)    Facility to override / adjust system calculations"]
[]
[44.2,"The system should provide the facility for employees with more than one post to be members of the same or a different pension scheme in each post.  The pension scheme applicable will be dependent on the particular post.",1]
[44.3,"The system must provide the option to update changes to EE and ER pension deduction rates / percentages with minimal user effort and requiring no additional programming.",1]
[44.4,"The College administers  AVC  deductions that are linked to the Occupational Pension Schemes available to College employees and contributions are paid over to the AVC provider associated with their main pension. ",1]
[null,"The system must therefore provide facilities for employees who are members of one of the main occupational schemes (TP, LGPS) to be in a scheme related AVC that is payable to the AVC providers of that scheme."]
[44.5,"The system must maintain separate balances for employees who have contributed to more than one Occupational Pension Scheme during:",1]
[null,"a)    A tax year "]
[null,"b)    A pension year (TPS) "]
[44.6,"The system must hold ‘end dates’ for additional pension contributions.",1]
[44.7,"Facility to calculate and pay refund of contributions and link to NI code change and NI contributions recalculation.",1]
[44.8,"Facility to calculate pension contributions from date driven entry.",1]
[44.9,"Implement and manage auto-enrolment & tri annual enrolment, including eligible, non-eligible and entitled employees. in line with the pensions regulations.",1]
[null,"Please provide full details of the system and processes to include assessment, communication and tracking procedures"]
[null,"The system must flag relevant auto-enrolment eligibility/entitlement"]
[44.1,"Manage opt out notices and new employees as part of the auto-enrolment process. ",1]
[44.11,"Maintain accurate records and a complete audit trail that logs changes with full traceability.",1]
[45,"Pay Spines, Awards and Salary Changes"]
[45.1,"The system must provide for a number of user defined pay spines and related pay grades and a number of pay points within each grade and spine.  The system must provide for a number of user defined pay grades and pay points within each pay grade. Please refere to HR spec for further details.",1]
[45.2,"The system must be capable of maintaining a full history by date of past pay grades and related pay points",1]
[45.3,"The system should facilitate the automatic review / update of grades and pay points for pay awards with minimal user effort.",1]
[45.4,"In additon to maintianing a full history (45.2),The facility to add a description/comments is desirable to include FTE% contracted hours and weeks per year",2]
[46,"Period End Reconciliation and Payments"]
[46.1,"The system must provide facilities to summarise all additions and deductions (excel statutory deductions) by user defined pay group and payroll for each pay period. ",1]
[46.2,"The system must provide facilities to summarise all elements of pay within individual pay records, by pay  period and total into a summary report for the whole payroll (including brought forward / carried forward totals), to facilitate payment to payroll creditors such as the Inland Revenue, pension scheme administrators etc.",1]
[47,"Year End Reconciliations and Payments "]
[47.1,"The system must provide the facility to continue input after year end to correct cumulative figures for submission to the Inland Revenue without jeopardising subsequent pay runs in the next tax year.  Tenderers must detail how this is handled by the proposed system.",1]
[47.2,"The system must provide facilities to produce cumulative summaries each pay period, of gross pay, each statutory deduction / payment type, live pay records, leaver records and new records, building up to the year end for the purpose of balancing P35 schedules.",1]
[47.3,"The system must provide facilities to validate gross pay against statutory deductions, and identify / summarise non-feasible conditions in employee payroll files that will cause rejection of PAYE/NIC/SSP/SMP/SAP/SPP data submitted to HMRCC e.g. due to negative values, out of balance or, exceeding maximum values etc.",1]
[47.4,"The system must provide facilities to produce files for the exchange of contribution / pay data to our pension administrators, and HMRC each month.",1]
[]
[null,"Please specify process for monthly HMRC and pension submissions - RTI(HMRC), MCR(TPS), LGPS (csv)"]
[48,"Costings"]
[48.1,"The system must be capable of holding a cost code up to 20 characters long with alphanumeric or blank in any position.",1]
[48.2,"The system must be capable of apportioning gross costs (incl ER NIC and ER Pension) against multiple cost codes, attached to both permanent and temporary elements, by individual employee.  Automatically split costs based on pay coding. Desirable would be the additional of £ FTE %",1]
[49,"Payroll - General Requirements"]
[49.1,"The system must allow for on-line ‘dummy/test’ gross to net calculation to be carried out for an individual or group without impacting on the normal processing cycle.",2]
[49.2,"Reversal of gross to net calculation for an individual or group with automatic adjustment of employee period, cumulative figures and costings and the effect of the reversal reflected in payslip history and payslip display screen.",3]
[49.3,"Facilitate supplementary payments / deductions after payroll run.",3]
[49.4,"Provide a payslip history to be accessible by payroll users to include drill down facilities showing individual pay / deduction elements (including statutory deductions) for the current pay period and cumulative figures to date.",3]
[49.5,"Hold incremental dates and calculate payments according to due date",3]
[49.6,"Facility to input temporary figures and calculate future pay awards ",3]
[49.7,"Facility to handle more than one payroll for different organisations. Please note that we currently have one payroll/organisation.  However, this may change in the future and therefore the system must be capable of multi payrolls and/or organisations.",3]
[50,"Payroll Reporting"]
[50.1,"Incremental reports.",2]
[]
[50.2,"Prompt / warning messages e.g. employee paid more than (say) £10,000 in one month, negative gross pay, no net pay, net pay  more or less then 25% v previous period etc. this should also be able to be exported as a report for checking before final pay run.",1]
[50.3,"In the event of a reversal of gross to net taking place, the system should automatically generate a report / file to allow contra items to be posted to the general ledger after validation by the finance team.",3]
[50.4,"Notepad screens for both individual and global messages.",3]
[51,"Pay Spines, Awards and Salary Changes"]
[51.1,"The system must be capable of linking an individual employee’s grade, grade point and incremental date to the appropriate spinal pay rate (monthly, hourly etc) and provide for automatic incremental progression, based on individual increment date, taking due account of ‘Top of the Scale’, ‘Spot’ and ‘Discretionary’ points.",2]
[51.2,"The system must provide the ability to produce retrospective calculation of pay arrears for an individual or for all eligible staff as a result of updates to pay rates and / or pay elements and insert individual values to staff pay records for payment in a prescribed pay cycle.  Provide review ‘draft’ list prior to confirmation.",3]
[52,"Costings"]
[52.1,"The system should maintain a historical cost file that would allow users to easily interrogate historical costing information. ",2]
[53,"Time & Attendance"]
[53.1,"The systems should be able to calculate OSP/SSP and SMP/SPP allowances and flag to Payroll users when individuals become eligible for these allowances, in accordance with the College’s policies, based on the working patterns and absence dates.",2]
[null,null,null,null,{"$f":"SUM(E3:E169)","v":0}]

{"sheet":"12. Expenses","index":11,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,13,0],[2,2,13,2],[2,5,13,5],[2,3,13,3],[2,4,13,4]]}
["Item","Requirement","Rank","Code","Score","Details"]
[54,"Expenses"]
[54.1,"Expenses to be integrated with the HR/Payroll System with the following facilities:",3]
[null,"Expense Codes:"]
[null,"a)    user defined expense codes e.g. travel(car mileage/public transport) and subsistence, Ability to attach individual cost codes to each expense item"]
[null,"b)    Ability to store the VAT portion and rate, where applicable, of any expense item."]
[null,"c)    Historical storage of expenses"]
[]
[null,"Expenses processing:"]
[null,"d)    Expenses data entered via self-service by employee, by payroll or finance staff   into the system but not processed until authorised by the relevant line manager and member of the payroll or finance staff."]
[null,"e)    Facility to process expenses via payroll at end of each  month"]
[null,"f)     Travel expense claim system to be linked to standard method of calculating mileage e.g Google maps, standard journeys etc. "]
[]
[null,"Please specify system used to calculate mileage."]
[null,null,null,null,{"$f":"SUM(E3)","v":0}]

{"sheet":"13. System Security","index":12,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[22,6,37,6]]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[55,"System Security"]
[55.1,"Tenderers should provide full details of their system access and security provisions.  They should identify which of the  security and audit functions outlined are provided by the system software and which applications the software provides.",1]
[55.2,"There must be varying levels of security for different types of user.",1]
[55.3,"The system must allow flexible access groups to be defined including grouping of system users.",1]
[55.4,"Screens must be able to be tailored in such a way as to allow restricted access to functions / data depending on individual user authorisation.",1]
[55.5,"It must be possible to have “read only” access where required.",1]
[55.6,"Please detail the audit function of your system.",1]
[55.7,"The system must support a unique access identifier and password for each user.",1]
[55.8,"The system must ensure all passwords are encrypted.",1]
[55.9,"System must support MFA and or Passkeys/Fido2",1]
[55.1,"Tenderers must demonstrate a strong track record of implementing and adhering to security best practices. Provide a clear and detailed plan for incident response and data breach management, including procedures for detection, containment, mitigation, and notification.",1]
[55.11,"Local accounts and MFA for fallback access would be beneficial ",2]
[56,"System Security"]
[56.1,"Please state who manages security, how and from where.",2]
[56.2,"The system must maintain an audit trail of all transactions concerned with creating, amending and deleting database/web based records.  This trail should have a reporting facility giving information on before and after values as well as time and user data.",2]
[56.3,"Tenderers must provide full details of their GDPR compliance measures, including how personal data is processed, stored, and protected. Additionally, they must specify the physical and/or cloud locations where data is stored, along with any applicable data residency regulations.",1]
[56.4,"Tenderers must provide detailed information on the frequency and methodology of penetration testing conducted on their cloud-based systems and software. This should include evidence of testing schedules, results, and any remediation actions taken to address identified vulnerabilities.",1]
[56.4,"Tenderers must specify the system development methodology used that incorporates Secure by Design principles.",1]
[]
[]
[null,null,null,null,null,null,"  "]

{"sheet":"14. Demonstration","index":13,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Item","Requirement","Rank","Code","Score","Bidders Response"]
[57,"Demonstration - HR"]
[57.1,"Usability of the interface for making HR changes and new employee records by HR",1]
[57.2,"Usability of online interface for applications and vacancies",1]
[57.3,"Usability of the interface for employees and managers to view their details and employees’ details",1]
[57.4,"Ease of creating training and development records",2]
[57.5,"The ability to reconfigure screens to allow for bespoke fields to be added, if required",1]
[57.6,"Well designed software which is easy to use on a day-to-day basis",2]
[57.7,"Ease of Report writing",1]
[57.7,"Ease of intergration with other systems",1]
[57.8,"Feedback from reference education sites",1]
[58,"Demonstration - Payroll"]
[58.1,"Usability of the interface for making payroll changes and submissions by HR",1]
[58.2,"Usability of the interface for employees to view payroll details such as payslips and P60’s",1]
[58.3,"Ease of submitting payroll returns and bulk payslips to staff",1]
[58.4,"The ability to reconfigure screens to allow for bespoke fields to be added, if required",1]
[58.5,"Well designed software which is easy to use on a day-to-day basis",2]
[58.6,"Ease of Report writing",1]
[58.7,"Ease of intergration with other systems",1]
[58.8,"Feedback from reference education sites",1]
[null,null,null,null,{"$f":"SUM(E4:E19)","v":0}]

{"sheet":"15. System View Specifications","index":14,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
["Simple Name","Field Name"]
["EmpID","emp_id"]
["Employee_Name","knownas"]
["Employee_Email","mail"]
["Employee_Forename","forename"]
["Employee_Surname","surname"]
["Employee_Start_Date","org_date_start"]
["Employee_Leaving_Date","org_date_left"]
["Date Start","date_start"]
["Leaving Date","date_left"]
["Date Of Birth","date_birth"]
["Sex","sex_id"]
["Title","title_id"]
["ITAccountDisabled","hazard_cond"]
["SiteID","colour_id"]
["SiteDesc","description"]
["Post_Status","StatusID"]
["Start_Date","org_start_date"]
["End_Date","org_end_date"]
["Job Start Date","start_date"]
["Job End Date","end_date"]
["Occupation_ID","job_id"]
["Occupation","description"]
["PSContractFlag","inc_generated"]
["parent_job_id","parent_job_id"]
["ParentJobDescription","description"]
["Post_Title","description"]
["ContractTypeID","con_type_id"]
["ContractType","description"]
["EmploymentTypeID","emp_type"]
["EmploymentType","description"]
["JaneWTE","wte_id"]
["WTEDescription","description"]
["WTEWeeks","wte_percent"]
["WTEHours","wte_factor"]
["FractionOfFulltime","PROP_WTE_FACTOR"]
["ContractRef","Ref_ID"]
["TempSourceID","Analysis_id"]
["TempSourceDescription","description"]
["EmploymentStatusID","employ_id"]
["EmploymentStatusDescription","description"]
["SalaryGradeType","sal_grd_id"]
["ScalePoint","scale_point"]
["Hours Per Week","hours_per_week"]
["Weeks Per Year","act_weeks_per_year"]
["JobFraction","job_fraction"]
["Manager_ID","man_id"]
["Manager_Name","knownas"]
["Manager_Email","mail"]
["Dept_ID","dept_id"]
["Department","description"]
["Activity_Type_ID","soc_id"]
["Activity_Type","description"]
["Activity_Group_ID","job_group_id"]
["Activity_Group","description"]
["Directorate_ID","emp_status_id"]
["Directorate","description"]
["Old_ID","sort_id"]
["seq_id","seq_id"]

{"sheet":"16. Total Score Achieved","index":15,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Score","Score"]
[null,null,null,5,4]
[]
[null,"Tab","Area","Total entries Code A each rank",null,"Maximum score available","Score achieved"]
[null,null,null,"Rank 2","Rank 3"]
[null,3,"General Requirements",25,6,{"$f":"SUM(D6*$D$2)+(E6*$E$2)","v":149}]
[null,4,"Organisation Structure",2,3,22]
[null,5,"Employee Details",0,0,0]
[null,6,"Onboarding & Recruitment",22,0,110]
[null,7,"Absence & Leave",28,0,140]
[null,8,"Self Service",3,1,19]
[null,9,"CPD & Training",18,0,90]
[null,10,"Reporting",1,1,9]
[null,11,"Payroll",7,9,71]
[null,12,"Expenses",0,1,4]
[null,13,"System Security",3,0,{"$f":"SUM(D16*$D$2)+(E16*$E$2)","v":15}]
[null,14,"Demonstration",3,0,15]
[null,null,null,null,null,{"$f":"SUM(F6:F17)","v":644},{"$f":"SUM(G6:G17)","v":0}]