{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guidance","Inputs and results","Statutory Redundancy","Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":39,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guidance","index":0,"n_rows":66,"n_cols":1,"rows_kept":66,"cut":false,"hidden":false,"merged":[[2,0,2,13]]}
["Civil Service Compensation Scheme (CSCS)"]
[]
["If you have been admitted to the pension scheme through New Fair Deal, the Civil Service Compensation Scheme may not apply to you."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["V3.6 April 2025"]

{"sheet":"Inputs and results","index":1,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,0,2,10],[18,4,19,7],[13,3,14,6],[15,3,15,6],[34,1,34,6],[16,4,17,7]]}
["Civil Service Compensation Scheme (CSCS)"]
[]
["If you have been admitted to the pension scheme through New Fair Deal, the Civil Service Compensation Scheme may not apply to you."]
[]
[]
[null,"Name"]
[]
[null,"NINo"]
[]
[null,"Date of birth"]
[]
[null,"First day of current continuous service"]
[]
[null,"Expected last day of service",null,"Use this link to find your State Pension Age (alpha scheme only) : "]
[]
[null,"Normal Pension Date, date of your normal pension age in the scheme (State Pension Age)",null,"http://www.gov.uk/state-pension-age/y/age"]
[null,null,null,null,{"$f":"IF(('Inputs and results'!D30=\"YES\"),\"Continuous service (as would be used for Statutory Redundancy calculation)\",\"\")","v":"Continuous service (as would be used for Statutory Redundancy calculation)"}]
[null,"Current reckonable service (as at last day of service)"]
[null,null,null,null,{"$f":"IF((D30=\"YES\"),\"(Includes any TUPE-transferred service and treats part-time and full-time service the same)\",\"\")","v":"(Includes any TUPE-transferred service and treats part-time and full-time service the same)"}]
[null,"Basic salary (as at last day of service)"]
[null,"Permanent pensionable allowances"]
[]
[null,"Part-time in last 3 years of service?","NO",{"$f":"IF((ynPartTime=\"YES\"),\"Lower maximum compensation limit applies\",\"\")","v":""}]
[null,"     If yes, current weekly part-time hours",null,{"$f":"IF((ynPartTime=\"YES\"),\"You must complete this field\",\"\")","v":""}]
[null,"     Weekly full-time equivalent hours",null,{"$f":"IF((ynPartTime=\"YES\"),\"You must complete this field\",\"\")","v":""}]
[null,"     Current reckonable service as if full-time for all service",null,{"$f":"IF((ynPartTime=\"YES\"),\"You must complete this field\",\"\")","v":""}]
[]
[null,"Multiple of standard tariff (voluntary exits only)",1,{"$f":"IF((MultStdTarrVE<1),\"will need to carry out statutory redundancy test\",\"\")","v":""}]
[null,"Does lower paid underpin apply? (voluntary exits only)","YES"]
[null,null,null,"YES"]
[null,{"$f":"IF(('Statutory Redundancy'!D16=\"NO\"),\"Voluntary exit (\"&MultStdTarrVE&\" x standard tariff)\",\"Statutory redundancy amount\")","v":"Voluntary exit (1 x standard tariff)"},{"$f":"IF(('Statutory Redundancy'!D16=\"NO\"),'Statutory Redundancy'!D15,'Statutory Redundancy'!D14)","v":0},{"$f":"IF((Calculation!B31<2),\"Payment at employer discretion\",\"\")","v":"Payment at employer discretion"}]
[null,"Voluntary redundancy",{"$f":"IF((C23=\"Yes\"),Calculation!F10,Calculation!F9)","v":0},{"$f":"IF((Calculation!B31<2),\"Payment at employer discretion\",\"\")","v":"Payment at employer discretion"}]
[null,"Compulsory redundancy",{"$f":"IF((C23=\"Yes\"),Calculation!F24,Calculation!F23)","v":0},{"$f":"IF((Calculation!B31<2),\"No payment as less than 2 years qualifying service\",\"\")","v":"No payment as less than 2 years qualifying service"}]
[]
[null,"The figures provided by this calculator are for illustration purposes only. To obtain an accurate estimate, please ensure you have entered the correct information regarding your employment history. You should not enter into any financial commitments based on the figures provided by this calculator as the actual quote/award of compensation may differ, depending on the employment history confirmed by your employer."]
[]
[null,"V3.6 April 2025"]

{"sheet":"Statutory Redundancy","index":2,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,0,2,10],[16,1,16,5]]}
["Civil Service Compensation Scheme (CSCS)"]
[]
["If you have been admitted to the pension scheme through New Fair Deal, the Civil Service Compensation Scheme will not apply to you."]
[]
[]
[null,"Statutory redundancy rate",719]
[]
[null,"Statutory redundancy calc"]
[null,"total years for statutory",{"$f":"MIN(20,C26)","v":0}]
[null,"years over 41",{"$f":"MAX(0,INT(MIN((C22-41),C9)))","v":0},{"$f":"C10*1.5","v":0}]
[null,"years over 22",{"$f":"MAX(0,INT(MIN(C22-22,C9-C10)))","v":0},{"$f":"C11*1","v":0}]
[null,"years under 22",{"$f":"MAX(0,INT(MIN(C9-22,C9-C10-C11)))","v":0},{"$f":"C12*0.5","v":0}]
[null,null,null,{"$f":"SUM(D10:D12)","v":0}]
[null,"Statutory redundancy amount",null,{"$f":"D13*MIN(C24,StatRate)","v":0}]
[null,null,null,{"$f":"IF((ynPartTime=\"Yes\"),Calculation!F17,Calculation!F16)","v":0}]
[null,null,null,{"$f":"IF((D15<D14),\"YES\",\"NO\")","v":"NO"}]
[null,"The figures provided by this calculator are for illustration purposes only. To obtain an accurate estimate, please ensure you have entered the correct information regarding your employment history. You should not enter into any financial commitments based on the figures provided by this calculator as the actual quote/award of compensation may differ, depending on the employment history confirmed by your employer."]
[]
[]
[]
[null,"V3.6 April 2025"]
[null,"age at LDS",{"$f":"ROUND(YEAR(dayLDS)-YEAR(dayDOB)+(dayLDS-DATE(YEAR(dayLDS),MONTH(dayDOB),DAY(dayDOB)))/365,4)","v":0}]
[]
[null,"Actual weekly pay (52)",{"$f":"ROUND((BasicSal+Allow)/52*IF((ynPartTime=\"YES\"),(PTHours/FTHours),1),2)","v":0}]
[]
[null,"Continuous actual service ",{"$f":"IF(('Inputs and results'!D30=\"YES\"),'Inputs and results'!E21,0)","v":0}]
[]
[]
[]
[null,"Pay",null,{"$f":"IF((SUM(C24*52)=0),LowerPayThreshold,SUM(C24*52))","v":23000}]
[null,"Closeness to PA",null,{"$f":"SUM(dayNPD-dayLDS)","v":0}]

{"sheet":"Calculation","index":3,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,0,2,5],[25,0,25,5]]}
["Civil Service Compensation Scheme (CSCS)"]
[]
["If you have been admitted to the pension scheme through New Fair Deal, the Civil Service Compensation Scheme will not apply to you."]
[]
["Data",null,null,null,"Voluntary redundancy"]
["Months to pension age",{"$f":"IF((SUM((B24*12)+C24+D25)<0),0,SUM((B24*12)+C24+D25))","v":0},null,null,"Standard tariff",{"$f":"ROUND((PayUsed*RSCurr/12),2)","v":0},"VR_Standard"]
["Compensation pay",{"$f":"BasicSal+Allow","v":0},null,null,"Max limit (f/t)",{"$f":"ROUND(\n(MIN(MonthToPA+6,VRMaxCapMonths)/12)*PayUsed,2)","v":11500},"VR_Max_FT",null,{"$f":"MIN(VRMaxCapMonths*(RSCurr/RSCurrPT),J8)","v":{"$error":"#DIV/0!"}}]
["Higher pay threshold",149820,null,null,"Max limit (p/t)",{"$f":"ROUND((PayUsed/12)*H8,2)","v":{"$error":"#DIV/0!"}},"VR_Max_PT",{"$f":"IF((dayLDS<dayNPD),I7,(6*(RSCurr/RSCurrPT)))","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND((J9*(PTHours/FTHours))+(6*(RSCurr/RSCurrPT)),0)","v":{"$error":"#DIV/0!"}}]
["Lower pay threshold",23000,null,null,"Std tar payment (f/t)",{"$f":"IF((VR_Standard>VR_Max_FT),VR_Max_FT,VR_Standard)","v":0},"VR_Std_FT",null,null,{"$f":"SUM((B24*12)+C24+(D24/H28))","v":0}]
["Pay used for calculation",{"$f":"MAX(MIN(HigherPayThreshold,BasicSal+Allow),LowerPayThreshold)","v":23000},null,null,"Std tar payment (p/t)",{"$f":"IF((VR_Standard>VR_Max_PT),VR_Max_PT,VR_Standard)","v":{"$error":"#DIV/0!"}},"VR_Std_PT"]
[]
[null,null,null,null,"Voluntary exit"]
[null,null,null,null,{"$f":"MultStdTarrVE&\" x standard tariff\"","v":"1 x standard tariff"},{"$f":"ROUND((H16*RSCurr*(MultStdTarrVE/12)),2)","v":0},"VE_Standard",null,{"$f":"MIN(VEMaxCapMonths*(RSCurr/RSCurrPT),J8)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Max limit (f/t)",{"$f":"ROUND(((MIN(MonthToPA+6,VEMaxCapMonths)/12)*H16),2)","v":11500},"VE_Max_FT"]
[null,null,null,null,"Max limit (p/t)",{"$f":"ROUND((H16/12)*H15,2)","v":{"$error":"#DIV/0!"}},"VE_Max_PT",{"$f":"IF((dayLDS<dayNPD),I13,(6*(RSCurr/RSCurrPT)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"MultStdTarrVE&\" x std tar payment (f/t)\"","v":"1 x std tar payment (f/t)"},{"$f":"IF((VE_Standard>VE_Max_FT),VE_Max_FT,VE_Standard)","v":0},"VE_Std_FT",{"$f":"IF((ynUnderpin=\"NO\"),MAX(MIN(HigherPayThreshold,BasicSal+Allow),0),PayUsed)","v":23000}]
[null,null,null,null,{"$f":"MultStdTarrVE&\" x std tar payment (p/t)\"","v":"1 x std tar payment (p/t)"},{"$f":"IF((F13>F15),F15,F13)","v":{"$error":"#DIV/0!"}},"VE_Std_PT"]
[]
[null,"Year","Month","Day","Compulsory redundancy"]
["Leap Year Adjustment",null,{"$f":"IF((INT(YEAR(dayNPD)/4)=YEAR(dayNPD)/4),29,28)","v":29},null,"Basic amount",{"$f":"ROUND((PayUsed*RSCurr/12),2)","v":0},"CR_Basic"]
[null,null,null,null,"Max limit (f/t)",{"$f":"ROUND(((MIN(MonthToPA+6,CRMaxCapMonths)/12)*PayUsed),2)","v":11500},"CR_Max_FT",null,{"$f":"MIN(CRMaxCapMonths*(RSCurr/RSCurrPT),J22)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"DAY(dayLDS)","v":0},"Max limit (p/t)",{"$f":"ROUND(((H22/12)*PayUsed),2)","v":{"$error":"#DIV/0!"}},"CR_Max_PT",{"$f":"IF((dayLDS<dayNPD),I21,(6*(RSCurr/RSCurrPT)))","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND((J23*(PTHours/FTHours))+(6*(RSCurr/RSCurrPT)),0)","v":{"$error":"#DIV/0!"}}]
["LDS to Pension Data - Diff (simple)",{"$f":"SUM(YEAR(dayNPD)-YEAR(dayLDS))","v":0},{"$f":"SUM(MONTH(dayNPD)-MONTH(dayLDS)-IF((D23<1),1,0))","v":-1},{"$f":"DAY(dayNPD)-DAY(dayLDS)","v":0},"Comp payment (f/t)",{"$f":"IF((B31<2),0,IF((CR_Basic>CR_Max_FT),CR_Max_FT,CR_Basic))","v":0},"CR_Std_FT",null,null,{"$f":"SUM((B24*12)+C24+(D24/H28))","v":0}]
["LDS to Pension Data - Diff (clarified)",{"$f":"IF((C23<0),(B23-1),B23)","v":-1},{"$f":"IF((C23<0),(C23+12),C23)","v":11},{"$f":"IF((D23<1),D23+I28,D23)","v":31},"Comp payment (p/t)",{"$f":"IF((B31<2),0,IF((CR_Basic>CR_Max_PT),CR_Max_PT,CR_Basic))","v":0},"CR_Std_PT"]
[null,null,null,{"$f":"ROUND((D24/H28),0)","v":1}]
["The figures provided by this calculator are for illustration purposes only. To obtain an accurate estimate, please ensure you have entered the correct information regarding your employment history. You should not enter into any financial commitments based on the figures provided by this calculator as the actual quote/award of compensation may differ, depending on the employment history confirmed by your employer.",null,null,null,null,null,null,{"$f":"IF((D23<1),(MONTH(dayNPD)-1),MONTH(dayNPD))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H26=4,30,IF(H26=6,30,IF(H26=9,30,IF(H26=11,30,IF(H26=2,C20)))))","v":false}]
["V3.1 May 2020",{"$f":"YEAR(dayLDS+1)","v":1900},{"$f":"MONTH(dayLDS+1)","v":1},{"$f":"DAY(dayLDS+1)","v":1},null,null,null,{"$f":"IF((H27=FALSE),31,H27)","v":31},{"$f":"IF((DAY(dayLDS)>H28),DAY(dayLDS),H28)","v":31}]
["Start date",{"$f":"YEAR(dayStart)","v":1900},{"$f":"MONTH(dayStart)","v":1},{"$f":"DAY(dayStart)","v":0}]
[null,{"$f":"SUM(B28-B29)","v":0},{"$f":"SUM(C28-C29)","v":0},{"$f":"SUM(D28-D29)","v":1}]
[null,{"$f":"IF((C31<0),(B30-1),B30)","v":0},{"$f":"IF((D30<0),(C30-1),C30)","v":0}]
[]
[]
[]
["Work Variables"]
["Voluntary Exit Max Cap Months",21,"VEMaxCapMonths"]
["Voluntary Redundancy Max Cap Months",21,"VRMaxCapMonths"]
["Compulsory Redundnacy Max Cap Months",12,"CRMaxCapMonths"]
["Day Post Nov 2017 is valid from","2016-11-09","dayValidFrom"]