Spreadsheet: 530606d1501289060-statutory-redundancy-pay-out-uk-statutory-redundancy-payout
Sheet: Final

 | STATUTORY REDUNDANCY PAYOUT
 | Name | DOB | [NAME] | In Srv. | Annual Pay | Weekly Stat. Rate | Redundancy Date | Country | Completed Years of Service | Qualification Based on Min. Years of Service | Years in Service during Age Period |  |  |  |  | [NAME] on [NAME]. Years of Service |  |  |  |  | Week's Pay Entitlement |  |  |  | Weekly Pay Cap | Computed Payout | Actual Subject to [NAME] |  | Minimum Year of Service |  |  | [NAME] |  | <-- Before 06/04/17 --> |  | <--On or after 06/04/17 -->
 |  |  |  |  |  |  |  |  |  |  | < 22 | 22 to 40 | [NAME] 41 | Total | Check = 0 | < 22 | 22 to 40 | [NAME] 41 | Total | Check = 0 | 0.5 | 1 | 1.5 | Total |  |  |  |  | Location | Year of Service |  | Location | Year of Service | Weekly Pay1 | Payout1 | Weekly Pay2 | Payout2
 | O | 1960-02-18 00:00:00 | 57 | 32 | 22260 | 428 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | England | 2 |  | England | 20 |  |  | 489 | 14670
 | P | 1956-05-24 00:00:00 | 61 | 27 | 22382 | 430 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Northern Ireland | 2 |  | Northern Ireland | 20 | 500 | 15000 | 500 | 15000
 | Q | 1962-12-21 00:00:00 | 54 | 27 | 22740 | 437 | 2016-12-31 00:00:00 | Northern Ireland
 | R | 1964-08-19 00:00:00 | 52 | 32 | 23090 | 444 | 2016-12-31 00:00:00 | Northern Ireland
 | S | 1959-10-27 00:00:00 | 57 | 32 | 23304 | 448 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Redundancy pay:
 | T | 1963-05-30 00:00:00 | 54 | 38 | 29740 | 572 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.gov.uk/redundant-your-rights/redundancy-pay
 | U | 1963-11-08 00:00:00 | 53 | 30 | 30000 | 577 | 2016-12-31 00:00:00 | England
 | V | 1959-02-03 00:00:00 | 58 | 37 | 30210 | 581 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculate your statutory redundancy pay:
 | W | 1962-03-03 00:00:00 | 55 | 32 | 30220 | 581 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.gov.uk/calculate-your-redundancy-pay
 | X | 1963-07-14 00:00:00 | 53 | 35 | 30250 | 582 | 2016-12-31 00:00:00 | England
 | Y | 1969-05-10 00:00:00 | 48 | 27 | 31270 | 601 | 2016-12-31 00:00:00 | England
 | Z | 1968-11-27 00:00:00 | 48 | 30 | 31290 | 602 | 2016-12-31 00:00:00 | Northern Ireland
 | B | 1979-04-01 00:00:00 | 38 | 5 | 6950 | 134 | 2016-12-31 00:00:00 | England
 | C | 1981-12-14 00:00:00 | 35 | 4 | 9230 | 178 | 2016-12-31 00:00:00 | England
 | D | 1963-08-03 00:00:00 | 53 | 8 | 9900 | 190 | 2016-12-31 00:00:00 | England
 | E | 1986-04-20 00:00:00 | 31 | 10 | 10200 | 196 | 2016-12-31 00:00:00 | England
 | F | 1975-05-29 00:00:00 | 42 | 4 | 11030 | 212 | 2016-12-31 00:00:00 | England
 | G | 1975-08-08 00:00:00 | 41 | 7 | 12124 | 233 | 2016-12-31 00:00:00 | England
 | H | 1984-05-25 00:00:00 | 32 | 1 | 12540 | 241 | 2016-12-31 00:00:00 | England | 1
 | I | 1996-10-06 00:00:00 | 20 | 1 | 15200 | 292 | 2016-12-31 00:00:00 | England | 1
 | J | 1991-01-07 00:00:00 | 25 | 1 | 16160 | 311 | 2016-12-31 00:00:00 | England | 1
 | K | 1998-03-16 00:00:00 | 18 | 1 | 16460 | 317 | 2016-12-31 00:00:00 | England | 1
 | L | 1990-11-26 00:00:00 | 26 | 1 | 16690 | 321 | 2016-12-31 00:00:00 | England | 1
 | M | 1992-07-23 00:00:00 | 24 | 1 | 17190 | 331 | 2016-12-31 00:00:00 | England | 1
 | N | 1994-05-30 00:00:00 | 22 | 1 | 17220 | 331 | 2016-12-31 00:00:00 | England | 1