Spreadsheet: 131014d1322691191-removing-extracting-characters-from-a-string-remove-characters
Sheet: RPF calcs

Male or [NAME]? | Male
62 or 65 NRD? | 62 |  |  | 50.97 | 0.648
Date of Birth | 1953-04-07 00:00:00
Date of Retirement | 2012-06-01 00:00:00
Date of Leaving | 2004-06-01 00:00:00
Age |  |  | Age at DOL
 |  |  |  |  |  | Age | Active | Deferred | VFM
Active ERF |  |  | Active ERF for Postponed calc |  |  | 50 | 0.625 | 0.497 | 0.319
Deferred ERF |  |  |  |  |  | 51 | 0.65 | 0.527 | 0.35
VFM ERF |  |  |  |  |  | 52 | 0.676 | 0.558 | 0.386
 |  |  |  |  |  | 53 | 0.703 | 0.592 | 0.424
 |  |  |  |  |  | 54 | 0.731 | 0.627 | 0.467
 |  |  |  |  |  | 55 | 0.76 | 0.665 | 0.513
Pre 97 CCF |  |  |  |  |  | 56 | 0.79 | 0.705 | 0.564
Post 97 CCF |  |  |  |  |  | 57 | 0.822 | 0.747 | 0.621
Post 05 CCF |  |  |  |  |  | 58 | 0.855 | 0.792 | 0.683
 |  |  |  |  |  | 59 | 0.889 | 0.84 | 0.751
 |  |  |  |  |  | 60 | 0.925 | 0.89 | 0.826
 |  |  |  |  |  | 61 | 0.962 | 0.943 | 0.909
 |  |  |  |  |  | 62 | 1 | 1 | 1
 |  |  |  |  |  | Age | Active | Deferred | VFM
 |  |  |  |  |  | 50 | 0.555 | 0.417 | 0.239
 |  |  |  |  |  | 51 | 0.577 | 0.442 | 0.263
 |  |  |  |  |  | 52 | 0.601 | 0.469 | 0.29
 |  |  |  |  |  | 53 | 0.625 | 0.497 | 0.319
 |  |  |  |  |  | 54 | 0.65 | 0.527 | 0.35
 |  |  |  |  |  | 55 | 0.676 | 0.558 | 0.386
 |  |  |  |  |  | 56 | 0.703 | 0.592 | 0.424
 |  |  |  |  |  | 57 | 0.731 | 0.627 | 0.467
 |  |  |  |  |  | 58 | 0.76 | 0.665 | 0.513
 |  |  |  |  |  | 59 | 0.79 | 0.705 | 0.564
 |  |  |  |  |  | 60 | 0.822 | 0.747 | 0.621
 |  |  |  |  |  | 61 | 0.855 | 0.792 | 0.683
 |  |  |  |  |  | 62 | 0.889 | 0.84 | 0.751
 |  |  |  |  |  | 63 | 0.925 | 0.89 | 0.826
 |  |  |  |  |  | 64 | 0.962 | 0.943 | 0.909
 |  |  |  |  |  | 65 | 1 | 1 | 1
 |  |  |  |  |  |  | Factor for pension earned before 1997 |  | Factor for pension earned between 1997 and 2005 |  | Factor for pension earned after 2005
 |  |  |  |  |  | Age | Pre 97 Male | Pre 97 Female | Post 97 Male | Post 97 Female | Post 05 Male | Post 05 Female
 |  |  |  |  |  | 40 | 15.8 | 15.97 | 27.04 | 27.47 | 22.28 | 22.57
 |  |  |  |  |  | 41 | 15.72 | 15.9 | 26.72 | 27.18 | 22.08 | 22.39
 |  |  |  |  |  | 42 | 15.64 | 15.83 | 26.39 | 26.88 | 21.87 | 22.2
 |  |  |  |  |  | 43 | 15.55 | 15.76 | 26.06 | 26.57 | 21.66 | 22.01
 |  |  |  |  |  | 44 | 15.45 | 15.67 | 25.71 | 26.25 | 21.43 | 21.8
 |  |  |  |  |  | 45 | 15.36 | 15.59 | 25.36 | 25.92 | 21.2 | 21.59
 |  |  |  |  |  | 46 | 15.25 | 15.5 | 25 | 25.59 | 20.96 | 21.38
 |  |  |  |  |  | 47 | 15.14 | 15.4 | 24.63 | 25.24 | 20.71 | 21.15
 |  |  |  |  |  | 48 | 15.03 | 15.3 | 24.25 | 24.89 | 20.46 | 20.92
 |  |  |  |  |  | 49 | 14.9 | 15.2 | 23.86 | 24.53 | 20.19 | 20.67
 |  |  |  |  |  | 50 | 14.78 | 15.09 | 23.46 | 24.16 | 19.91 | 20.42
 |  |  |  |  |  | 51 | 14.64 | 14.97 | 23.05 | 23.78 | 19.63 | 20.17
 |  |  |  |  |  | 52 | 14.5 | 14.85 | 22.63 | 23.4 | 19.33 | 19.9
 |  |  |  |  |  | 53 | 14.35 | 14.72 | 22.2 | 23 | 19.03 | 19.62
 |  |  |  |  |  | 54 | 14.19 | 14.58 | 21.76 | 22.6 | 18.72 | 19.34
 |  |  |  |  |  | 55 | 14.03 | 14.44 | 21.32 | 22.18 | 18.4 | 19.05
 |  |  |  |  |  | 56 | 13.85 | 14.29 | 20.87 | 21.76 | 18.06 | 18.75
 |  |  |  |  |  | 57 | 13.67 | 14.14 | 20.41 | 21.33 | 17.72 | 18.44
 |  |  |  |  |  | 58 | 13.49 | 13.97 | 19.94 | 20.9 | 17.38 | 18.12
 |  |  |  |  |  | 59 | 13.29 | 13.8 | 19.46 | 20.45 | 17.02 | 17.79
 |  |  |  |  |  | 60 | 13.08 | 13.62 | 18.98 | 19.99 | 16.66 | 17.45
 |  |  |  |  |  | 61 | 12.87 | 13.44 | 18.5 | 19.53 | 16.29 | 17.1
 |  |  |  |  |  | 62 | 12.65 | 13.25 | 18.01 | 19.06 | 15.91 | 16.75
 |  |  |  |  |  | 63 | 12.42 | 13.05 | 17.52 | 18.59 | 15.53 | 16.38
 |  |  |  |  |  | 64 | 12.18 | 12.84 | 17.02 | 18.11 | 15.14 | 16.01
 |  |  |  |  |  | 65 | 11.93 | 12.62 | 16.53 | 17.62 | 14.75 | 15.63
 |  |  |  |  |  | 66 | 11.68 | 12.4 | 16.03 | 17.12 | 14.36 | 15.25
 |  |  |  |  |  | 67 | 11.42 | 12.17 | 15.53 | 16.63 | 13.96 | 14.86
 |  |  |  |  |  | 68 | 11.15 | 11.93 | 15.02 | 16.13 | 13.55 | 14.46
 |  |  |  |  |  | 69 | 10.88 | 11.68 | 14.52 | 15.62 | 13.14 | 14.06
 |  |  |  |  |  | 70 | 10.6 | 11.43 | 14.01 | 15.12 | 12.72 | 13.65
 |  |  |  |  |  | 71 | 10.31 | 11.17 | 13.5 | 14.61 | 12.3 | 13.24
 |  |  |  |  |  | 72 | 10.02 | 10.9 | 12.99 | 14.1 | 11.88 | 12.82
 |  |  |  |  |  | 73 | 9.72 | 10.62 | 12.49 | 13.59 | 11.46 | 12.4
 |  |  |  |  |  | 74 | 9.41 | 10.34 | 11.99 | 13.09 | 11.04 | 11.98
 |  |  |  |  |  | 75 | 9.11 | 10.05 | 11.49 | 12.58 | 10.62 | 11.55