Spreadsheet: 530116d1501125011-statutory-redundancy-pay-out-redundancy-calculation-bw-v2
Sheet: Sheet1

Employee | DOB | Age | YoS | Ann$ | W$ | EOD | Location | Entitled YoS | W Entitled (0.5, 1,1.5) | W$ (with Caps) | Total payout (with Caps) | [NAME] | From Website given | Link |  | Age | Rate
O | 1960-02-18 00:00:00 | 57 | 32 | 22260 | 428 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 11984 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/57/32/428.0 |  | 18
P | 1956-05-24 00:00:00 | 61 | 27 | 22382 | 430 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  | 12900 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/61/27/430.0 |  | 19
Q | 1962-12-21 00:00:00 | 54 | 27 | 22740 | 437 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  | 11580.5 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/54/27/437.0 |  | 20
R | 1964-08-19 00:00:00 | 52 | 32 | 23090 | 444 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  | 11322 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/52/32/444.0 |  | 21
S | 1959-10-27 00:00:00 | 57 | 32 | 23304 | 448 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 12544 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/57/32/448.0 |  | 22
T | 1963-05-30 00:00:00 | 54 | 38 | 29740 | 572 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 12693.5 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/54/38/572.0 |  | 23
U | 1963-11-08 00:00:00 | 53 | 30 | 30000 | 577 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 12454 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/53/30/577.0 |  | 24
V | 1959-02-03 00:00:00 | 58 | 37 | 30210 | 581 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 13651.5 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/58/37/581.0 |  | 25
W | 1962-03-03 00:00:00 | 55 | 32 | 30220 | 581 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 12933 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/55/32/581.0 |  | 26
X | 1963-07-14 00:00:00 | 53 | 35 | 30250 | 582 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 12454 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/53/35/582.0 |  | 27
Y | 1969-05-10 00:00:00 | 48 | 27 | 31270 | 601 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 11256.5 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/48/27/601.0 |  | 28
Z | 1968-11-27 00:00:00 | 48 | 30 | 31290 | 602 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  | 11750 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/48/30/602.0 |  | 29
B | 1979-04-01 00:00:00 | 38 | 5 | 6950 | 134 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 670 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/38/5/134.0 |  | 30
C | 1981-12-14 00:00:00 | 35 | 4 | 9230 | 178 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 712 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/35/4/178.0 |  | 31
D | 1963-08-03 00:00:00 | 53 | 8 | 9900 | 190 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 2280 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/53/8/190.0 |  | 32
E | 1986-04-20 00:00:00 | 31 | 10 | 10200 | 196 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 1862 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/31/10/196.0 |  | 33
F | 1975-05-29 00:00:00 | 42 | 4 | 11030 | 212 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 954 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/42/4/212.0 |  | 34
G | 1975-08-08 00:00:00 | 41 | 7 | 12124 | 233 | 2016-12-31 00:00:00 | England |  |  |  |  |  | 1631 | https://www.gov.uk/calculate-your-redundancy-pay/y/2016-12-31/41/7/233.0 |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82