Spreadsheet: 84308d1284375094-updating-formula-automatically-over-several-worksheets-master-calculator-test-
Sheet: Master

Employee No | Redundancy STATUS | Redundancy Status Review Date | Emp'ee Title | Emp'ee Surname | Emp'ee Forename | Emp'ee Preferred Name | Emp'ee Project | Emp'ee Department | Emp'ee Working Job Title | Start date of Consultation | End Date of Consultation | Last Day of Employment (LDE) | Redundancy rationale | Date of Business Announcement | Location of Business Announcement | Name & Job Title of Person carrying out  Announcement | Joint Consultation with | Address 1 | Address 2 | Address 3 | Address 4 | Address 5 | Post Code | Start Date | Date of Birth | Assignment Grade | Benefit Grade | Annual Salary | Employment category | Advance Type | Monies Owing (£) | Car Funding (£pa) | Car Cost (£ pa) | Car Deduction (£ pa) | In Preference (Yes / No) | Current BUPA Cover selected | Pension Scheme | Employer Pension % | Employer pension scheme contributions in lieu of notice (£) | Employee contributions to Pension Fund (£) | LATEST date to serve notice | Completed Years' Service at  Last Day of Employment (LDE) | Contract termination Date for Calculation of Notice (PILON) and [NAME] | Age at PILON end date | Completed Years' Service at PILON end date | Total Notice due (months) at PILON end date | Notice being worked (Months) at PILON end date | Notice paid in Lieu (Months) at PILON end date | [NAME] in lieu of notice (£) at PILON end date | Car Allowance in lieu of notice (£)  at PILON end date | Statutory Redundancy Pay (£/week)  at PILON end date | Statutory Redundancy Pay (Weeks )  at PILON end date | Statutory Redundancy Pay (£ [NAME])  at PILON end date | PMI (BUPA) eligibility | Annual value (£) of company-provided PMI cover | Extension of Company provided BUPA cover to BLL Date (£) | Annual value (£) of employee selected PMI cover | Employee Contribution to Extension of BUPA cover (£) | TOTAL Statutory & Contractual Payments (£) | TOTAL LESS  Employee Contribution to Extension of BUPA cover and Employee contributions to Pension Fund (£) | TOTAL Non Taxable payment (£) | Payments in excess of £30,000 (£) | 1st Meeting Date | 1st Meeting Time | 1st Meeting Location | 1st Meeting Manager [NAME] | 1st Meeting Manager [NAME] | 1st Meeting HR Rep name | 1st Meeting HR Rep Title | SEND 1st Meeting invitation letter  (HRM) | 1st Meeting Invite Letter sent (ESC) | Name of additional attendee (e.g. Employee rep) Otherwise please leave blank | 1st Meeting Comments | SEND Confirm At Risk Letter  (HRM) | Confirm At Risk Meeting Letter SENT (ESC) | REASON for Extension | Most recent Extension (Assignment) | Most Recent Extension (Start Date) | Most Recent Extension (Expected End Date) | SEND Confirm Most recent Extension  (HRM) | Most Recent Extension  Letter Date SENT | Most recent On Trial (Assignment) | Most Recent On Trial (Start Date) | Most Recent On Trial (Expected End Date) | SEND Confirm Most recent On Trial  (HRM) | Most Recent On Trial  Letter Date SENT | Date of Final Meeting | Time of Final Consultation Meeting | Name of Line Manager conducting Final  Meeting | Role of LM conducting Final Meeting | HR person present at Final Meeting | Role of HR person present at Final Meeting | Venue for Final Meeting | SEND Confirm Final Meeting Invite  (HRM) | Final Meeting invitation date [NAME]  (ESC) | Name of additional attendee (e.g. Employee rep) Otherwise please leave blank | Final Meeting Comments | Notice period start date | SEND Confirm redundant and termination letter (HRM) | Confirm Redundant and Termination Letter SENT (ESC) | Any special / additional payments on termination (instructions) inc. Compromise Agreement Payments (HRM) | Special / Additional Payments (£Value) inc. Compromise Agreement Payments (ESC) | Holiday days carried over (days) | Holiday Days owing in lieu (days) | Holiday days taken in current year (days) | Company Car retained until (Date) | [NAME] | BLL Leaving Date YEAR | Holiday YEAR | Holiday Year START | Holiday Year WEEKS 01/04 (OR Start date) to BLL Leaving Date | DAYS Holidays accrued to PILON end date | DAYS holiday to be paid | VALUE (£) of days holidays to be paid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00