Spreadsheet: 529918d1501065104-statutory-redundancy-pay-out-redundancy-calculation-bw
Sheet: Sheet1

 |  |  |  |  |  |  |  | Entitled Year of service | Year Entitle |  |  | Pay (with Caps) |  |  | Sum payout (with Caps)
 |  |  |  |  |  |  |  |  | >41 | 22-41 | <22 | >41 | 22-41 | <22
O | 1960-02-18 00:00:00 | 57 | 32 | 22260 | 428 | 2016-12-31 00:00:00 | England
P | 1956-05-24 00:00:00 | 61 | 27 | 22382 | 430 | 2016-12-31 00:00:00 | Northern Ireland
Q | 1962-12-21 00:00:00 | 54 | 27 | 22740 | 437 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  |  |  |  |  |  |  |  | 21
R | 1964-08-19 00:00:00 | 52 | 32 | 23090 | 444 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  |  |  |  |  |  |  |  | 22
S | 1959-10-27 00:00:00 | 57 | 32 | 23304 | 448 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  | 23
T | 1963-05-30 00:00:00 | 54 | 38 | 29740 | 572 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  | 24
U | 1963-11-08 00:00:00 | 53 | 30 | 30000 | 577 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  | 25
V | 1959-02-03 00:00:00 | 58 | 37 | 30210 | 581 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  | 26
W | 1962-03-03 00:00:00 | 55 | 32 | 30220 | 581 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  | 27
X | 1963-07-14 00:00:00 | 53 | 35 | 30250 | 582 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  | 28
Y | 1969-05-10 00:00:00 | 48 | 27 | 31270 | 601 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  |  |  |  |  | 29
Z | 1968-11-27 00:00:00 | 48 | 30 | 31290 | 602 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62