{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Guidance","CILON Calculator","Calcs_hide","SPD Calculations_hide","Factors_hide"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":168,"comments":2,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Guidance","index":0,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,1,14,12],[1,2,1,9],[5,1,5,12],[8,1,8,12],[10,1,10,12],[13,1,13,12]]}
[]
[null,null,"alpha CILON Calculator"]
[]
[]
[null,"Who is this CILON calculator for?"]
[null,"This calculator is for use by employers. It calculates the amount due for loss of pension benefits for members in the alpha scheme."]
[]
[null,"What is CILON?"]
[null,"Where the notice period is not worked compensation in lieu of notice (CILON) is payable on the unworked balance of the notice period. There is no change in the way CILON will be calculated but employers will have access to a calculator so they can calculate the loss of pension benefits. "]
[]
[null,"The CILON calculator will provide the amount due for loss of pension benefits within the unworked period of the notice period. CILON must be paid via the employer's payroll and will be subject to tax and National Insurance. "]
[]
[null,"Where can I find more information relating to CILON?"]
[null,"For loss of pension benefits during the unworked notice period for those with a partnership pension account please see paragraph 9.b of Annex 6F of section 6 of the EPG. "]
[null,"www.civilservicepensionscheme.org.uk/employers/employer-pension-guide/"]
[]
[null,null,null,"If you encounter any problems please contact MyCSP: ","www.civilservicepensionscheme.org.uk/contact-us/"]
[]
[]
[null,"© 2015 MyCSP CILON_v1.0.2_13102023"]

{"sheet":"CILON Calculator","index":1,"n_rows":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,2,1,9],[36,1,36,12],[4,1,4,12],[23,1,23,3],[15,5,15,10],[17,5,17,10],[19,5,19,10],[21,5,21,10],[23,5,23,10],[15,1,15,3],[3,2,3,9],[11,5,11,10],[7,1,7,3],[9,1,9,3],[11,1,11,3],[13,1,13,3],[47,1,47,12],[19,1,19,3],[21,1,21,3],[30,1,30,3],[32,1,32,3],[43,1,43,12],[45,1,45,12],[40,1,40,9],[38,1,38,12],[39,1,39,12],[17,1,17,3],[46,1,46,12],[13,5,13,10],[44,1,44,12],[28,1,28,3]],"read":"row_number_cap"}
[]
[null,null,"alpha CILON Calculator"]
[]
[null,null,"** For use where the departure date is 1 April 2015 or later **"]
[null,"This tool is for employers to use for active members of the alpha scheme."]
[]
[null,"About the employee"]
[null,"What the employee's name? ",null,null,null,{"$f":"IF(uistrName=\"\",\"Enter name.\",\"\")","v":"Enter name."},null,null,null,null,null,null,null,null,"uistrName","erruistrName"]
[]
[null,"What the employee's National Insurance number? ",null,null,null,{"$f":"IF(uistrNINO=\"\",\"Enter National Insurance number.\",\"\")","v":"Enter National Insurance number."},null,null,null,null,null,null,null,null,"uistrNINO","erruistrNINO"]
[]
[null,"What is the employee's date of birth? ",null,null,null,{"$f":"IF(uidayDOB=\"\",\"Enter date of birth.\",\"\")","v":"Enter date of birth."},null,null,null,null,null,null,null,null,"uidayDOB","erruidayDOB"]
[]
[null,"What is the employee's departure date? ",null,null,null,{"$f":"IF(uidayDepDate=\"\",\"Enter departure date.\",\"\")","v":"Enter departure date."},null,null,null,null,null,null,null,null,"uidayDepDate","erruidayDepDate"]
[]
[null,"What date does the employee's notice period end? ",null,null,null,{"$f":"IF(uidayDoNE=\"\",\"Enter notice end date.\",\nIF(uidayDoNE<uidayDepDate,\"Notice end date must be after departure date.  \",\nIF(uidayDepDate+365<uidayDoNE,\"Notice end date must be within 365 days of departure date.\",\"\")))","v":"Enter notice end date."},null,null,null,null,null,null,null,null,"uidayDoNE,erruidayDoNE"]
[]
[null,"What are the employee's pensionable earnings for unexpired notice period? ",null,null,null,{"$f":"IF(uidPenEarn=\"\",\"Enter pensionable earnings for unexpired notice period.\",\"\")","v":"Enter pensionable earnings for unexpired notice period."},null,null,null,null,null,null,null,null,"uidNonPenEarn","erruidPenEarn"]
[]
[null,"What are the employee's non-pensionable earnings for unexpired notice period? ",null,null,null,{"$f":"IF(uidNonPenEarn=\"\",\"Enter non-pensionable earnings for unexpired notice period.\",\"\")","v":"Enter non-pensionable earnings for unexpired notice period."},null,null,null,null,null,null,null,null,"uidNonPenEarn","erruidNonPenEarn"]
[]
[null,{"$f":"\"What basic alpha pension contribution rate would employee be paying on departure date - \"&TEXT(dayDepDate,\"dd/mm/yyyy\")&\" (%)? \"","v":"What basic alpha pension contribution rate would employee be paying on departure date - 00/01/1900 (%)? "},null,null,null,{"$f":"IF(OR(uidContRate=\"\",uidContRate=\" \"),\"Enter contribution rate.\",\nIF(uidContRate=msgNoContRate,\"No contribution rates available, check departure date.\",\nIF(ISERROR(VLOOKUP(uidContRate,tabPreContTable,1,FALSE)),\"Enter valid contribution rate.\",\"\")))","v":"Enter contribution rate."},null,{"$f":"IF(uidContRate=\"\",\"Enter contribtuion rate.\",\"\")","v":"Enter contribtuion rate."},null,null,null,null,null,null,"uidContRate","erruidContRate"]
[]
[null,{"$f":"\"What  basic alpha pension contribution rate would the employee be paying after 1 April \"&TEXT(dayDepDate,\"yyyy\")&\" (%)?\"","v":"What  basic alpha pension contribution rate would the employee be paying after 1 April 1900 (%)?"},null,null,null,{"$f":"IF(AND(AND(uidContRateNextYear<>\"\",uidContRateNextYear<>\" \"),Q24=FALSE),\"Remove value\",\n         IF(Q24,IF(OR(uidContRateNextYear=\"\",uidContRateNextYear=\" \"),\"Enter contribution rate.\",\n         IF(uidContRateNextYear=msgNoContRate,\"No contribution rates available, check departure date.\",\n         IF(ISERROR(VLOOKUP(uidContRateNextYear,tabPostContTable,1,FALSE)),\"Enter valid contribution rate.\",\"\"))),\"\"))","v":""},null,{"$f":"IF(uidContRate=\"\",\"Enter contribtuion rate.\",\"\")","v":"Enter contribtuion rate."},null,null,null,null,null,null,"uidContRateNextYear","erruidContRateNextYear",{"$f":"bPostContRate","v":false}]
[]
[]
[null,"Results"]
[]
[null,"The date you will reach your Normal Pension Age (NPA) is:",null,null,{"$f":"resSPD","v":"Error"},null,null,null,null,null,null,null,null,null,"uiSPD"]
[]
[null,"Compensation for loss of pension: ",null,null,{"$f":"dCompLossOfPension","v":"Error"},null,null,null,null,null,null,null,null,null,"uiCompLossOfPension"]
[]
[null,"Total CILON amount: ",null,null,{"$f":"dTotalCilon","v":"Error"},null,null,null,null,null,null,null,null,null,"uiTotalCILON"]
[]
[]
[null,"Error messages"]
[null,{"$f":"_errOverall","v":"Check Inputs.  "}]
[]
[]
[null,"Legal Caveats"]
[null,"While every effort has been made to ensure that this tool is correct, it is reliant on the data that has been input and factors provided by the Scheme Actuary. MyCSP Limited therefore, to the maximum extent permitted by law, disclaims all liability and responsibility arising from any reliance placed on the information provided."]
[]
[null,"Audit"]
[null,{"$f":"msgPrint","v":"15:09,  03 Feb 2025.  "}]
[null,{"$f":"msgFileName","v":"Filename : \\\\MCCLPRDFSSM385\\XDrive\\Systems Support\\Application Team\\Calculators 2024 updates\\CILON Calculator\\[cilon-calculator-protected (4).xlsm"}]
[null,{"$f":"msgVersionNumber","v":"Version number : 101.  "}]
[null,{"$f":"msgExpiration","v":"Tool expires on 01/04/2099.  "}]
[null,{"$f":"msgPDFSaveLocation","v":"PDF saved to : TBC"}]

{"sheet":"Calcs_hide","index":2,"n_rows":198,"n_cols":9,"rows_kept":198,"cut":false,"hidden":true,"merged":[[16,1,16,6],[3,2,3,6],[4,2,4,6],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,6]]}
[null,null,{"$f":"strToolName","v":"alpha CILON"}]
[]
[]
[null,"Description","This calculator is shows the calculations and intermediate stages behind CILON calculations.  This sheet is intended to be used by ADMINISTRATION staff as a backend tool.  It is not expected that this will be exposed to the public users.  \nFactors from documents ‘CILON factors (for Cabinet Office)-alpha-30Mar15.xlsx’ and ‘alpha compensation in lieu of notice (CILON) factors and guidance DRAFT -30Mar15.pdf’"]
[null,"Schemes","alpha"]
[]
[]
[]
[null,null,{"$f":"$C$1&\" - Instructions\"","v":"alpha CILON - Instructions"},null,null,null,null,"Key to cell colours:"]
[null,null,null,null,null,null,null,"Data from data sheet (yellow)"]
[null,null,null,null,null,null,null,"Work Variable (orange)"]
[null,"How to use this CILON Tool and exceptions",null,null,null,null,null,"Output (green)"]
[null,"Please provide all details in the input section, these inputs are fed in from the 'Inputs and Results' sheet",null,null,null,null,null,"Messages (pink)"]
[null,null,null,null,null,null,null,"System Tables Values (blue)"]
[null,null,null,null,null,null,null,"System Variable (dark green)"]
[null,null,null,null,null,null,null,"Error In Cell (red)"]
[]
[]
[null,null,{"$f":"strToolName&\" - Version Control\"","v":"alpha CILON - Version Control"}]
[]
[]
[null,"Version Number, tabVersionNumber","Work Carried out","By","Date","Checked by","Date","NOTES"]
[null,0.08,"See version control document","MyCSP","2015-01-26"]
[null,0.11,"See version control document","MyCSP","2015-03-17"]
[null,0.15,"See version control document"]
[null,0.16,"See version control document","MyCSP","2015-04-07"]
[null,0.21,"See version control document","MyCSP","2015-04-08"]
[null,0.22,"See version control document","MyCSP"]
[null,0.23,"See version control document","MyCSP","2015-04-15"]
[null,100,"See version control document","MyCSP","2015-04-15"]
[null,101,"See version control document","MyCSP","2015-04-16"]
[]
[]
[]
[]
[null,null,{"$f":"$C$1&\" - Inputs\"","v":"alpha CILON - Inputs"}]
[]
[]
[null,"Inputs from UI"]
[null,"Date of Birth",{"$f":"uidayDOB","v":"00:00:00"},"dayDOBA"]
[null,"Date of departure",{"$f":"uidayDepDate","v":"00:00:00"},"dayDepDate"]
[null,"Date notice period ends",{"$f":"uidayDoNE","v":"00:00:00"},"dayDoNE"]
[null,"Scheme","alpha","strScheme","HARD CODED"]
[null,"Contribution rate (%)",{"$f":"uidContRate","v":0},"dContRate"]
[null,"Contribution Rate for next year if applicable",{"$f":"uidContRateNextYear","v":0},"dContRateNextYear"]
[null,"Pensionable earnings for unexpired notice period",{"$f":"uidPenEarn","v":0},"dPenEarn"]
[null,"Non-pensionable earnings for unexpired notice period",{"$f":"uidNonPenEarn","v":0},"dNonPenEarn"]
[null,"Taper date","2015-04-01","dayTaperDate","HARD CODED"]
[]
[]
[null,null,{"$f":"$C$1&\" - Calculations\"","v":"alpha CILON - Calculations"}]
[]
[]
[null,"Notice period splits and conditions"]
[null,"CILON service split logic"]
[null,"Logic based on 'Part1 and alpha service split flow chart.vsdx"]
[null,"DOL",{"$f":"dayDepDate","v":"00:00:00"},"=dayDepDate"]
[null,"Taper Date",{"$f":"dayTaperDate","v":"2015-04-01"},"TaperDate"]
[null,"Date notice period ends",{"$f":"dayDoNE","v":"00:00:00"},"=dayDoNE"]
[null,"Did member leave before  31/3?"]
[null,"Next 31/3 after DOL",{"$f":"DATE(YEAR(DOL)+IF(MONTH(DOL)>3,1,0),3,31)","v":"1900-03-31"},"NextEOSY_DOL"]
[null,"Condition B (DOL<31/3<DoNE)",{"$f":"IF(AND(DOL<=NextEOSY_DOL,dayDoNE>NextEOSY_DOL),TRUE,FALSE)","v":false},"bCondB"]
[null,"Outcome number",{"$f":"IF(bCondB,1,\nIF(NOT(bCondB),2,\n))","v":2},"iOutcome","This will be only 1 or 2"]
[null,"Display 2nd contribution rate",{"$f":"IF(OR(iOutcome=1),TRUE,FALSE)","v":false},"bPostContRate"]
[null,"contribution Table Look up year (EOY) pre",{"$f":"IF(OR(YEAR(NextEOSY_DOL)=2019,YEAR(NextEOSY_DOL)=2018),2017,YEAR(NextEOSY_DOL))","v":1900},"yearContTablePre"]
[null,"contribution Table Look up year (EOY) post",{"$f":"C65+1","v":1901},"yearContTablePost",{"$f":"YEAR(NextEOSY_DOL)","v":1900}]
[]
[null,"Contribution Rate Table Data"]
[null,null,"tabPreContTable","tabPostContTable"]
[null,null,"Pre End Of Scheme Year Cont Rates, yy-1","Post End Of Scheme Year Cont Rates, yy"]
[null,null,{"$f":"yearContTablePre","v":1900},{"$f":"yearContTablePost","v":1901}]
[null,1,{"$f":"IFERROR(IF(INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B72)=0,\" \",INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B72)),msgNoContRate)","v":"No contribution rate"},{"$f":"IFERROR(IF(INDEX(INDIRECT(\"tabContRates\"&yearContTablePost,0),B72)=0,\" \",INDEX(INDIRECT(\"tabContRates\"&yearContTablePost,0),B72)),msgNoContRate)","v":"No contribution rate"}]
[null,2,{"$f":"IFERROR(IF(INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B73)=0,\" \",INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B73)),\" \")","v":" "},{"$f":"IFERROR(IF(INDEX(INDIRECT(\"tabContRates\"&yearContTablePost,0),B73)=0,\" \",INDEX(INDIRECT(\"tabContRates\"&yearContTablePost,0),B73)),\" \")","v":" "}]
[null,3,{"$f":"IFERROR(IF(INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B74)=0,\" \",INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B74)),\" \")","v":" "}," "]
[null,4,{"$f":"IFERROR(IF(INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B75)=0,\" \",INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B75)),\" \")","v":" "}," "]
[null,5,{"$f":"IFERROR(IF(INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B76)=0,\" \",INDEX(INDIRECT(\"tabContRates\"&yearContTablePre,0),B76)),\" \")","v":" "}," "]
[null,6," "," "]
[null,7," "," "]
[null,8," "," "]
[null,9," "," "]
[null,10," "," "]
[null,11," "," "]
[null,12," "," "]
[null,13," "," "]
[null,14," "," "]
[]
[null,"Scheme and Contriution rate to use","Rate","Scheme methodology"]
[null,"DOL to 31/3/yy",{"$f":"VLOOKUP(iOutcome,tabOutcomes,1+1)","v":"yy-1"},{"$f":"VLOOKUP(iOutcome,tabOutcomes,1+2)","v":"alpha"}]
[null,"1/4/yy to TaperDate -1",{"$f":"VLOOKUP(iOutcome,tabOutcomes,1+3)","v":"yy-1"},{"$f":"VLOOKUP(iOutcome,tabOutcomes,1+4)","v":"alpha"}]
[null,"TaperDate to DoNE ",{"$f":"VLOOKUP(iOutcome,tabOutcomes,1+5)","v":"yy-1"},{"$f":"VLOOKUP(iOutcome,tabOutcomes,1+6)","v":"alpha"}]
[]
[null,"Notice Period Calcs"]
[null,"Total Notice Period",{"$f":"dayDoNE-DOL","v":0},"Notice_Days","Assumes COP on DOL"]
[null,"Cross 1 April?",{"$f":"IF((DOL+Notice_Days)>DATE(IF(MONTH(DOL>3),YEAR(DOL)+1,YEAR(DOL)),4,1),\"Y\",\"N\")","v":"N"},"April_Ind"]
[null,"1 April Cross",{"$f":"IF(April_Ind=\"Y\",DATE(IF(MONTH(DOL)>3,YEAR(DOL)+1,YEAR(DOL)),4,1))","v":false},"April_Cross"]
[null,"Post April Notice",{"$f":"IF(April_Ind=\"Y\",dayDoNE-April_Cross+1,0)","v":0},"Pst_April_Notice_Days"]
[null,"Pre April Notice",{"$f":"Notice_Days-Pst_April_Notice_Days","v":0},"Pre_April_Notice_Days"]
[null,"Leap yr post 1/4",{"$f":"IF((IF(MONTH(DOL)>3,YEAR(DOL)+2,YEAR(DOL)+1)/4)-ROUND((IF(MONTH(DOL)>3,YEAR(DOL)+2,YEAR(DOL)+1)/4),0)=0,\"Y\",\"N\")","v":"N"},"LeapyrPost"]
[null,"Leap yr pre 1/4",{"$f":"IF((IF(MONTH(DOL)>3,YEAR(DOL)+1,YEAR(DOL))/4)-ROUND((IF(MONTH(DOL)>3,YEAR(DOL)+1,YEAR(DOL))/4),0)=0,\"Y\",\"N\")","v":"Y"},"LeapyrPre"]
[null,"Total Post April Notice fraction",{"$f":"Pst_April_Notice_Days/IF(LeapyrPost=\"Y\",366,365)","v":0},"Pst_April_Notice_Frac"]
[null,"Total Pre April Notice fraction",{"$f":"Pre_April_Notice_Days/IF(LeapyrPre=\"Y\",366,365)","v":0},"Pre_April_Notice_Frac"]
[]
[null,"Day calculations based on Outcome number ()"]
[null,"Total Notice Period",{"$f":"dayDoNE-dayDepDate+1","v":1},"o"]
[null,"Days DOL to next 31/3 (1,3,7)",{"$f":"IF(OR(iOutcome=1),NextEOSY_DOL-dayDepDate,0)","v":0},"o"]
[null,"Days 1/4 to DoNE (1,4,7)",{"$f":"IF(OR(iOutcome=1),dayDoNE-(NextEOSY_DOL+1)+1,0)","v":0},"o"]
[null,"Days DOL to DoNe (2,6)",{"$f":"IF(OR(iOutcome=2),dayDoNE-dayDepDate+1,0)","v":1},"o"]
[null,"Days 1/4 to Taper (3)",{"$f":"IF(OR(iOutcome=3),(TaperDate-1)-NextEOSY_DOL,0)","v":0},"o","Will always be zero"]
[null,"Days Taper to DoNE (3,5)",{"$f":"IF(OR(iOutcome=3,iOutcome=5),dayDoNE-TaperDate+1,0)","v":0},"o"]
[null,"Days Dol to Taper-1 (5,4)",{"$f":"IF(OR(iOutcome=5,iOutcome=4),(dayTaperDate-1)-dayDepDate+1,0)","v":0},"o","Will always be zero"]
[null,"Days Taper to 31/3 (4)",{"$f":"IF(OR(iOutcome=4),NextEOSY_DOL-TaperDate+1,0)","v":0},"o"]
[null,"Service splits check",{"$f":"IF(SUM(C105:C111)-C104<>0,FALSE,TRUE)","v":true},"bServiceSplits"]
[]
[null,"General Calculations"]
[null,"Complete years at DoL",{"$f":"ROUNDDOWN((DOL-dayDOBA)/365.25,0)","v":0},"Age_CY"]
[]
[null,"Alpha CILON Rate "]
[null,"* Note that pre and post 1/4 service is calculated here whether it is used or not.  All conditional summation is carried out in the overall rate section"]
[null,null,"Scheme Year End, yy-1","Scheme Year End, yy"]
[null,"End of Scheme Year",{"$f":"yearContTablePre","v":1900},{"$f":"yearContTablePost","v":1901}]
[null,"Alpha NPA (SPA) in complete months",{"$f":"'SPD Calculations_hide'!resdSPA_CYM","v":0},{"$f":"'SPD Calculations_hide'!resdSPA_CYM","v":0},"AlphaNPAcm"]
[null,"NPA Rounded down",{"$f":"INT(C121)","v":0},{"$f":"INT(D121)","v":0},"NPA_rddwn"]
[null,"NPA Rounded up",{"$f":"ROUNDUP(C121,0)","v":0},{"$f":"ROUNDUP(D121,0)","v":0},"NPA_rdup"]
[null,"Interpolation Months",{"$f":"(C121-C122)*12","v":0},{"$f":"(D121-D122)*12","v":0},"Interpmths","PreP2CIL1Fac,PostP2CIL1Fac"]
[null,"NPA rounded down factor",{"$f":"IFERROR(INDEX(INDIRECT(\"tabP2CIL1\"&yearContTablePre,0)*1,IF(Age_CY-19 <0,1,Age_CY-19),C122-63),msgNoCILONRate)","v":"No CILON factor"},{"$f":"IFERROR(INDEX(INDIRECT(\"tabP2CIL1\"&yearContTablePost,0)*1,IF(Age_CY-19 <0,1,Age_CY-19),D122-63),msgNoCILONRate)","v":"No CILON factor"},"CILONfac_rddwn"]
[null,"NPA rounded up factor",{"$f":"IFERROR(INDEX(INDIRECT(\"tabP2CIL1\"&yearContTablePre,0)*1,IF(Age_CY-19 <0,1,Age_CY-19),C123-63),msgNoCILONRate)","v":"No CILON factor"},{"$f":"IFERROR(INDEX(INDIRECT(\"tabP2CIL1\"&yearContTablePost,0)*1,IF(Age_CY-19 <0,1,Age_CY-19),D123-63),msgNoCILONRate)","v":"No CILON factor"},"CILONfac_rdup"]
[null,"Overall Factor",{"$f":"IFERROR(C126*(C124/12)+C125*((12-C124)/12),msgNoCILONRate)","v":"No CILON factor"},{"$f":"IFERROR(D126*(D124/12)+D125*((12-D124)/12),msgNoCILONRate)","v":"No CILON factor"},"CILONfac"]
[null,"Contribution rate for scheme year",{"$f":"dContRate/100","v":0},{"$f":"dContRateNextYear/100","v":0}]
[null,"alpha CILON Factor - Cont Rate",{"$f":"IFERROR(C127-C128,0)","v":0},{"$f":"IFERROR(D127-D128,0)","v":0}]
[]
[null,"Actual days In Scheme year alpha at rate ",{"$f":"C105+C107+C109+C111","v":1},{"$f":"C106+C109","v":0}]
[null,"Pen Earn Splits",{"$f":"IF(SUM(C131:D131)=0,0,dPenEarn*C131/SUM(C131:D131))","v":0},{"$f":"IF(SUM(C131:D131)=0,0,dPenEarn*D131/SUM(C131:D131))","v":0},"dPenEarnPre,dPenEarnPost"]
[null,"Compensation for loss of pension pre/post",{"$f":"dPenEarnPre*(C129)","v":0},{"$f":"dPenEarnPost*(D129)","v":0},"dCompLossOfPensionpre,dCompLossOfPensionPost"]
[null,"Summary of compensation, aplying earnings"]
[null,"Compensation for loss of pension",{"$f":"ROUND(dCompLossOfPensionPre+dCompLossOfPensionPost,2)","v":0},"dCompLossOfPensionCALC","=dCompLossOfPensionPre+dCompLossOfPensionPost"]
[null,"Total CILON amount",{"$f":"ROUND(dPenEarn+dNonPenEarn+dCompLossOfPensionCALC,2)","v":0},"dTotalCILONCALC","=dPenEarn+dNonPenEarn+dCompLoassOfPensionCALC"]
[]
[]
[]
[null,null,{"$f":"$C$1&\" - Results\"","v":"alpha CILON - Results"}]
[]
[null,"Results"]
[null,"State pension Date",{"$f":"IF(bOverallError,errError,resdaySPD)","v":"Error"},"resSPD"]
[null,"Compensation for loss of pension",{"$f":"IF(bOverallError,errError,dCompLossOfPensionCALC)","v":"Error"},"dCompLossOfPension"]
[null,"Total CILON amount",{"$f":"IF(bOverallError,errError,dTotalCilonCALC)","v":"Error"},"dTotalCILON"]
[]
[]
[]
[null,null,{"$f":"$C$1&\" - System Variables\"","v":"alpha CILON - System Variables"}]
[]
[]
[null,"Version Number",101,"dVersionNumber"]
[null,"Security Classification","Unclassified","strSecurityClassification"]
[null,"Tool Name","alpha CILON","strToolName"]
[null,"Today's Date",{"$f":"TODAY()","v":"2025-02-03"},"dayToday"]
[null,"Tool Expiry Date","2099-04-01","dayExpiry"]
[]
[]
[null,null,{"$f":"strToolName&\" - Errors and Messages\"","v":"alpha CILON - Errors and Messages"}]
[]
[]
[null,"Errors"]
[null,{"$f":"IF(bVersionError,\"Check Version Number.  \",\"\")","v":""},null,null,null,null,null,null,"_errVersion"]
[null,{"$f":"IF(bExpiryError,\"Tool expired on \"&TEXT(dayExpiry,\"dd/mm/yyyy\")&\" please contact MyCSP for a new copy.  \",\"\")","v":""},null,null,null,null,null,null,"_errExpiration"]
[null,{"$f":"IF(bUIError,\"Check Inputs.  \",\"\")","v":"Check Inputs.  "},null,null,null,null,null,null,"errUIError"]
[]
[]
[]
[]
[null,{"$f":"IF(bOverallError,\nerrUIError&_errVersion&_errExpiration,\nmsgNoErrors)","v":"Check Inputs.  "},null,null,null,null,null,null,"_errOverall"]
[]
[null,"Messages"]
[null,{"$f":"\"\" &TEXT(NOW(),\"hh:mm,  dd mmm yyyy\")&\".  \"","v":"15:09,  03 Feb 2025.  "},null,null,null,null,null,null,"msgPrint"]
[null,{"$f":"\"Version number : \"&(TEXT(dVersionNumber,\"0\"))&\".  \"","v":"Version number : 101.  "},null,null,null,null,null,null,"msgVersionNumber"]
[null,{"$f":"\"Filename : \"&LEFT(CELL(\"filename\",strToolName),FIND(\"]\",CELL(\"filename\",strToolName))-1)","v":"Filename : \\\\MCCLPRDFSSM385\\XDrive\\Systems Support\\Application Team\\Calculators 2024 updates\\CILON Calculator\\[cilon-calculator-protected (4).xlsm"},null,null,null,null,null,null,"msgFileName"]
[null,"PDF saved to : TBC",null,null,null,null,null,null,"msgPDFSaveLocation"]
[null,{"$f":"\"Tool expires on \"&TEXT(dayExpiry,\"dd/mm/yyyy\")&\".  \"","v":"Tool expires on 01/04/2099.  "},null,null,null,null,null,null,"msgExpiration"]
[null,"Error",null,null,null,null,null,null,"errError"]
[{"$f":"IF(bVersionError,\"Check Version Number.  \",\"\")","v":""},{"$f":"\"Table value not found\"","v":"Table value not found"},null,null,null,null,null,null,"errTableValueNotFound"]
[null,{"$f":"\"Error\"","v":"Error"},null,null,null,null,null,null,"_errOverallShort"]
[null,"No contribution rate",null,null,null,null,null,null,"msgNoContRate"]
[null,"No CILON factor",null,null,null,null,null,null,"msgNoCILONRate"]
[null,"No Errors Found",null,null,null,null,null,null,"msgNoErrors"]
[]
[]
[]
[]
[null,null,{"$f":"strToolName&\" - Error Checking\"","v":"alpha CILON - Error Checking"}]
[]
[]
[]
[]
[]
[null,"Error Checking"]
[null,"UI Error",{"$f":"IF(AND(erruistrName=\"\",erruistrNINO=\"\",erruidayDOB=\"\",erruidayDepDate=\"\",erruidPenEarn=\"\",erruidNonPenEarn=\"\",erruidContRate=\"\",erruidayDoNE=\"\",erruidContRateNextYear=\"\"),FALSE,TRUE)","v":true},"bUIError"]
[null,"Expiration error",{"$f":"IF(dayExpiry<dayToday,TRUE,FALSE)","v":false},"bExpiryError"]
[null,"Version (FALSE=OK)",{"$f":"IF(MAX(tabVersionNumber)<>dVersionNumber,TRUE,FALSE)","v":false},"bVersionError"]
[null,"Overall Error (FALSE=OK)",{"$f":"IF(OR(bUIError,bExpiryError,bVersionError),TRUE,FALSE)","v":true},"bOverallError"]

{"sheet":"SPD Calculations_hide","index":3,"n_rows":222,"n_cols":19,"rows_kept":222,"cut":false,"hidden":true,"merged":[[33,1,33,2],[1,2,1,6],[19,4,19,12],[20,4,20,12],[21,4,21,12],[22,4,22,15],[32,3,32,5]]}
[null,null,"SPD"]
[null,"Description","Calculates state pension date, state pension Age in Y, YM and age as string based on In force policy.  This is a MyCSP administration tool and is not for public use.  This page can be used in it's entirety as an SPA tool in other calculation  tools, however these must be kept up to date if this tool changes."]
[]
[]
[null,null,{"$f":"C1&\" -  Inputs\"","v":"SPD -  Inputs"}]
[]
[]
[null,"Inputs"]
[]
[null,"Date of Birth",{"$f":"dayDOBA","v":"00:00:00"},"dayDOB"]
[]
[null,"Sex","Male","strSex","Assume always Male as females will not have DOB < 5/12/53 in alpha"]
[]
[]
[null,null,{"$f":"C1&\" - Results\"","v":"SPD - Results"}]
[]
[]
[null,"Results",null,null,"Audit"]
[]
[null,"State Pension Age as string as per .Gov site",{"$f":"IF(OR(ISERROR(strSPA),bSPDOverallError),_errSPDOverall,strSPA)","v":""},"resstrSPA",{"$f":"msgPrint","v":"Calculation Date :15:09,  03 Feb 2025 .  "}]
[null,"State Pension  Date",{"$f":"IF(OR(bSPDOverallError,daySPD=0),_errSPDOverall,daySPD)","v":""},"resdaySPD"]
[null,"State Pension Age In Complete Years (YY)",{"$f":"IF(bSPDOverallError,_errSPDOverall,dSPA_CY)","v":0},"resdSPA_CY"]
[null,"State Pension Age In Complete Years and Months (YY+MM/12)",{"$f":"IF(bSPDOverallError,_errSPDOverall,dSPA_CYM)","v":0},"resdSPA_CYM","This SPA tool is based on the following in force Pensions Acts  95, 2007, 2011, 2014."]
[null,"SPA  in decimal",{"$f":"IF(bSPDOverallError,_errSPDOverall,dSPAdec)","v":0},"resdSPAdec"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,{"$f":"C1&\" - Calculations\"","v":"SPD - Calculations"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\nIF(DAY(DATE(YEAR(I29+0)-YEAR(dayDOB),MONTH(I29+0)-MONTH(dayDOB)+1,DAY(I29+0)-DAY(dayDOB)+1))-1=0,\n    0,\n     DAY(DATE(YEAR(I29+0)-YEAR(dayDOB),MONTH(I29+0)-MONTH(dayDOB)+1,DAY(I29+0)-DAY(dayDOB)+1))-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"daySPD","dSPA_CY","dSPA_CYM","strSPA","dSPAdec"]
[null,"The data in this table (columns B to F) has been taken from the inforce pension acts.  For more information about the source of data refer to the MyCSP SPA Calculator Tool sheet 'BackgroundStats'.",null,null,null,null,null,null,null,null,null,null,"Results lookups : ",null,{"$f":"MAX(O35:O182)","v":"00:00:00"},{"$f":"MAX(P35:P182)","v":0},{"$f":"MAX(Q35:Q182)","v":0},{"$f":"VLOOKUP(dSPA_CYM,Q35:R123,2,0)","v":{"$error":"#N/A"}},{"$f":"MAX(S35:S182)","v":0}]
[]
[null,null,null,"SPA is either defined as to an Age or Date, If age known complete age, if date known complete date.  All Ages YY+MM, where MM is m/12",null,null,null,"Intermediate Calculations",null,null,null,null,null,null,"Lookups"]
[null,"Period within which DOB falls",null,"Day pensionable age attained","Males SPA","Females SPA",null,"Use Date Or Age","State Pension Date (Calc)","SPA Year","SPA Month","SPA Day","SPA as string",null,"SPD Lookup","SPA Lookup Complete Years","SPA Lookup Complete Years And Months","SPA as String Lookup","SPA as decimal"]
[null,"1900-01-01","1950-04-05",null,65,60,null,{"$f":"IF(LEFT(LOWER(strSEX))=\"m\",IF(E35=\"\",\"Date\",\"Age\"), IF(LEFT(LOWER(strSEX))=\"f\",IF(F35=\"\",\"Date\",\"Age\"),\"N/A\"))","v":"Age"},{"$f":"IF(H35=\"Age\",DATE(YEAR(dayDOB)+INT(IF(strSEX=\"Male\",E35,F35)),MONTH(dayDOB)+(IF(strSEX=\"Male\",(E35-INT(E35))*12,(F35-INT(F35))*12)),DAY(dayDOB)),D35)","v":"1964-12-31"},{"$f":"YEAR(DATE(YEAR(I35+0)-YEAR(dayDOB),MONTH(I35+0)-MONTH(dayDOB)+1,DAY(I35+0)-DAY(dayDOB)+1))-1900","v":65},{"$f":"MONTH(DATE(YEAR(I35+0)-YEAR(dayDOB),MONTH(I35+0)-MONTH(dayDOB)+1,DAY(I35+0)-DAY(dayDOB)+1))-1","v":0},{"$f":"I35-DATE(YEAR(dayDOB)+J35,MONTH(dayDOB)+K35,DAY(dayDOB))-0","v":0},{"$f":"J35&\" Years \"&K35\n&\" Months \"&L35&\" Days\"","v":"65 Years 0 Months 0 Days"},null,{"$f":"IF(AND(dayDOB>=B35,dayDOB<=C35),I35,\"\")","v":""},{"$f":"IF(O35<>\"\",J35,\"\")","v":""},{"$f":"IF(O35<>\"\",J35+K35/12,\"\")","v":""},{"$f":"IF(P35<>\"\",M35,\"\")","v":""},{"$f":"IF(O35<>\"\",Q35+(L35/365),\"\")","v":""}]
[null,"1950-04-06","1950-05-05","2010-05-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1950-05-06","1950-06-05","2010-07-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1950-06-06","1950-07-05","2010-09-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1950-07-06","1950-08-05","2010-11-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1950-08-06","1950-09-05","2011-01-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1950-09-06","1950-10-05","2011-03-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1950-10-06","1950-11-05","2011-05-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1950-11-06","1950-12-05","2011-07-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1950-12-06","1951-01-05","2011-09-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-01-06","1951-02-05","2011-11-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-02-06","1951-03-05","2012-01-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-03-06","1951-04-05","2012-03-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-04-06","1951-05-05","2012-05-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-05-06","1951-06-05","2012-07-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-06-06","1951-07-05","2012-09-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-07-06","1951-08-05","2012-11-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-08-06","1951-09-05","2013-01-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-09-06","1951-10-05","2013-03-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-10-06","1951-11-05","2013-05-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-11-06","1951-12-05","2013-07-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1951-12-06","1952-01-05","2013-09-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-01-06","1952-02-05","2013-11-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-02-06","1952-03-05","2014-01-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-03-06","1952-04-05","2014-03-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-04-06","1952-05-05","2014-05-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-05-06","1952-06-05","2014-07-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-06-06","1952-07-05","2014-09-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-07-06","1952-08-05","2014-11-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-08-06","1952-09-05","2015-01-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-09-06","1952-10-05","2015-03-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-10-06","1952-11-05","2015-05-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1952-11-06","1952-12-05","2015-07-06",65,null,null,{"$f":"IF(LEFT(LOWER(strSEX))=\"m\",IF(E67=\"\",\"Date\",\"Age\"), IF(LEFT(LOWER(strSEX))=\"f\",IF(F67=\"\",\"Date\",\"Age\"),\"N/A\"))","v":"Age"},{"$f":"IF(H67=\"Age\",DATE(YEAR(dayDOB)+INT(IF(strSEX=\"Male\",E67,F67)),MONTH(dayDOB)+(IF(strSEX=\"Male\",(E67-INT(E67))*12,(F67-INT(F67))*12)),DAY(dayDOB)),D67)","v":"1964-12-31"},{"$f":"YEAR(DATE(YEAR(I67+0)-YEAR(dayDOB),MONTH(I67+0)-MONTH(dayDOB)+1,DAY(I67+0)-DAY(dayDOB)+1))-1900","v":65},{"$f":"MONTH(DATE(YEAR(I67+0)-YEAR(dayDOB),MONTH(I67+0)-MONTH(dayDOB)+1,DAY(I67+0)-DAY(dayDOB)+1))-1","v":0},{"$f":"I67-DATE(YEAR(dayDOB)+J67,MONTH(dayDOB)+K67,DAY(dayDOB))-0","v":0},{"$f":"J67&\" Years \"&K67\n&\" Months \"&L67&\" Days\"","v":"65 Years 0 Months 0 Days"},null,{"$f":"IF(AND(dayDOB>=B67,dayDOB<=C67),I67,\"\")","v":""},{"$f":"IF(O67<>\"\",J67,\"\")","v":""},{"$f":"IF(O67<>\"\",J67+K67/12,\"\")","v":""},{"$f":"IF(P67<>\"\",M67,\"\")","v":""},{"$f":"IF(O67<>\"\",Q67+(L67/365),\"\")","v":""}]
[null,"1952-12-06","1953-01-05","2015-09-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-01-06","1953-02-05","2015-11-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-02-06","1953-03-05","2016-01-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-03-06","1953-04-05","2016-03-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-04-06","1953-05-05","2016-07-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-05-06","1953-06-05","2016-11-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-06-06","1953-07-05","2017-03-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-07-06","1953-08-05","2017-07-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-08-06","1953-09-05","2017-11-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-09-06","1953-10-05","2018-03-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-10-06","1953-11-05","2018-07-06",65,null,null,"Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-11-06","1953-12-05","2018-11-06",65,null,"XXX","Age","1964-12-31",65,0,0,"65 Years 0 Months 0 Days",null,"","","","",""]
[null,"1953-12-06","1954-01-05","2019-03-06",null,null,null,"Date","2019-03-06",119,2,6,"119 Years 2 Months 6 Days",null,"","","","",""]
[null,"1954-01-06","1954-02-05","2019-05-06",null,null,null,"Date","2019-05-06",119,4,6,"119 Years 4 Months 6 Days",null,"","","","",""]
[null,"1954-02-06","1954-03-05","2019-07-06",null,null,null,"Date","2019-07-06",119,6,6,"119 Years 6 Months 6 Days",null,"","","","",""]
[null,"1954-03-06","1954-04-05","2019-09-06",null,null,null,"Date","2019-09-06",119,8,6,"119 Years 8 Months 6 Days",null,"","","","",""]
[null,"1954-04-06","1954-05-05","2019-11-06",null,null,null,"Date","2019-11-06",119,10,6,"119 Years 10 Months 6 Days",null,"","","","",""]
[null,"1954-05-06","1954-06-05","2020-01-06",null,null,null,"Date","2020-01-06",120,0,6,"120 Years 0 Months 6 Days",null,"","","","",""]
[null,"1954-06-06","1954-07-05","2020-03-06",null,null,null,"Date","2020-03-06",120,2,6,"120 Years 2 Months 6 Days",null,"","","","",""]
[null,"1954-07-06","1954-08-05","2020-05-06",null,null,null,"Date","2020-05-06",120,4,6,"120 Years 4 Months 6 Days",null,"","","","",""]
[null,"1954-08-06","1954-09-05","2020-07-06",null,null,null,"Date","2020-07-06",120,6,6,"120 Years 6 Months 6 Days",null,"","","","",""]
[null,"1954-09-06","1954-10-05","2020-09-06",null,null,null,"Date","2020-09-06",120,8,6,"120 Years 8 Months 6 Days",null,"","","","",""]
[null,"1954-10-06","1960-04-05",null,66,66,null,"Age","1965-12-31",66,0,0,"66 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-04-06","1960-05-05",null,66.083333333333329,66.083333333333329,null,"Age","1966-01-31",66,1,0,"66 Years 1 Months 0 Days",null,"","","","",""]
[null,"1960-05-06","1960-06-05",null,66.166666666666671,66.166666666666671,null,"Age","1966-02-28",66,2,0,"66 Years 2 Months 0 Days",null,"","","","",""]
[null,"1960-06-06","1960-07-05",null,66.25,66.25,null,"Age","1966-03-31",66,3,0,"66 Years 3 Months 0 Days",null,"","","","",""]
[null,"1960-07-06","1960-07-30",null,66.3333333333333,66.333333333333329,null,"Age","1966-04-30",66,4,0,"66 Years 4 Months 0 Days",null,"","","","",""]
[null,"1960-07-31","1960-07-31","2026-11-30",null,null,null,"Date","2026-11-30",66,4,0,"66 Years 4 Months 0 Days",null,"","","","",""]
[null,"1960-08-01","1960-08-05",null,66.333333333333329,66.333333333333329,null,"Age","1966-04-30",{"$f":"YEAR(DATE(YEAR(I96+0)-YEAR(dayDOB),MONTH(I96+0)-MONTH(dayDOB)+1,DAY(I96+0)-DAY(dayDOB)+1))-1900","v":66},{"$f":"MONTH(DATE(YEAR(I96+0)-YEAR(dayDOB),MONTH(I96+0)-MONTH(dayDOB)+1,DAY(I96+0)-DAY(dayDOB)+1))-1","v":4},{"$f":"I96-DATE(YEAR(dayDOB)+J96,MONTH(dayDOB)+K96,DAY(dayDOB))-0","v":0},"66 Years 4 Months 0 Days",null,"","","","",""]
[null,"1960-08-06","1960-09-05",null,66.416666666666671,66.416666666666671,null,"Age","1966-05-31",66,5,0,"66 Years 5 Months 0 Days",null,"","","","",""]
[null,"1960-09-06","1960-10-05",null,66.5,66.5,null,"Age","1966-06-30",66,6,0,"66 Years 6 Months 0 Days",null,"","","","",""]
[null,"1960-10-06","1960-11-05",null,66.583333333333329,66.583333333333329,null,{"$f":"IF(LEFT(LOWER(strSEX))=\"m\",IF(E99=\"\",\"Date\",\"Age\"), IF(LEFT(LOWER(strSEX))=\"f\",IF(F99=\"\",\"Date\",\"Age\"),\"N/A\"))","v":"Age"},{"$f":"IF(H99=\"Age\",DATE(YEAR(dayDOB)+INT(IF(strSEX=\"Male\",E99,F99)),MONTH(dayDOB)+(IF(strSEX=\"Male\",(E99-INT(E99))*12,(F99-INT(F99))*12)),DAY(dayDOB)),D99)","v":"1966-07-31"},66,7,0,{"$f":"J99&\" Years \"&K99\n&\" Months \"&L99&\" Days\"","v":"66 Years 7 Months 0 Days"},null,{"$f":"IF(AND(dayDOB>=B99,dayDOB<=C99),I99,\"\")","v":""},{"$f":"IF(O99<>\"\",J99,\"\")","v":""},{"$f":"IF(O99<>\"\",J99+K99/12,\"\")","v":""},{"$f":"IF(P99<>\"\",M99,\"\")","v":""},{"$f":"IF(O99<>\"\",Q99+(L99/365),\"\")","v":""}]
[null,"1960-11-06","1960-12-05",null,66.666666666666671,66.666666666666671,null,"Age","1966-08-31",66,8,0,"66 Years 8 Months 0 Days",null,"","","","",""]
[null,"1960-12-06","1960-12-30",null,66.75,66.75,null,"Age","1966-09-30",66,9,0,"66 Years 9 Months 0 Days",null,"","","","",""]
[null,"1960-12-31","1960-12-31","2027-09-30",null,null,null,"Date","2027-09-30",66,9,0,"66 Years 9 Months 0 Days",null,"","","","",""]
[null,"1961-01-01","1961-01-05",null,66.75,66.75,null,"Age","1966-09-30",{"$f":"YEAR(DATE(YEAR(I103+0)-YEAR(dayDOB),MONTH(I103+0)-MONTH(dayDOB)+1,DAY(I103+0)-DAY(dayDOB)+1))-1900","v":66},{"$f":"MONTH(DATE(YEAR(I103+0)-YEAR(dayDOB),MONTH(I103+0)-MONTH(dayDOB)+1,DAY(I103+0)-DAY(dayDOB)+1))-1","v":9},{"$f":"I103-DATE(YEAR(dayDOB)+J103,MONTH(dayDOB)+K103,DAY(dayDOB))-0","v":0},"66 Years 9 Months 0 Days",null,"","","","",""]
[null,"1961-01-06","1961-01-30",null,66.833333333333329,66.833333333333329,null,"Age","1966-10-31",{"$f":"YEAR(DATE(YEAR(I104+0)-YEAR(dayDOB),MONTH(I104+0)-MONTH(dayDOB)+1,DAY(I104+0)-DAY(dayDOB)+1))-1900","v":66},{"$f":"MONTH(DATE(YEAR(I104+0)-YEAR(dayDOB),MONTH(I104+0)-MONTH(dayDOB)+1,DAY(I104+0)-DAY(dayDOB)+1))-1","v":10},{"$f":"I104-DATE(YEAR(dayDOB)+J104,MONTH(dayDOB)+K104,DAY(dayDOB))-0","v":0},"66 Years 10 Months 0 Days",null,"","","","",""]
[null,"1961-01-31","1961-01-31","2027-11-30",null,null,null,"Date","2027-11-30",66,10,0,"66 Years 10 Months 0 Days",null,"","","","",""]
[null,"1961-02-01","1961-02-05",null,66.833333333333329,66.833333333333329,null,"Age","1966-10-31",{"$f":"YEAR(DATE(YEAR(I106+0)-YEAR(dayDOB),MONTH(I106+0)-MONTH(dayDOB)+1,DAY(I106+0)-DAY(dayDOB)+1))-1900","v":66},{"$f":"MONTH(DATE(YEAR(I106+0)-YEAR(dayDOB),MONTH(I106+0)-MONTH(dayDOB)+1,DAY(I106+0)-DAY(dayDOB)+1))-1","v":10},{"$f":"I106-DATE(YEAR(dayDOB)+J106,MONTH(dayDOB)+K106,DAY(dayDOB))-0","v":0},"66 Years 10 Months 0 Days",null,"","","","",""]
[null,"1961-02-06","1961-03-05",null,66.916666666666671,66.916666666666671,null,"Age","1966-11-30",66,11,0,"66 Years 11 Months 0 Days",null,"","","","",""]
[null,"1961-03-06","1961-04-05",null,67,67,null,"Age","1966-12-31",67,0,0,"67 Years 0 Months 0 Days",null,"","","","",""]
[null,"1961-04-06","1969-04-05",null,67,67,null,"Age","1966-12-31",67,0,0,"67 Years 0 Months 0 Days",null,"","","","",""]
[null,"1969-04-06","1977-04-05",null,67,67,null,"Age","1966-12-31",67,0,0,"67 Years 0 Months 0 Days",null,"","","","",""]
[null,"1977-04-06","1977-05-05","2044-05-06",null,null,null,"Date","2044-05-06",144,4,6,"144 Years 4 Months 6 Days",null,"","","","",""]
[null,"1977-05-06","1977-06-05","2044-07-06",null,null,null,"Date","2044-07-06",144,6,6,"144 Years 6 Months 6 Days",null,"","","","",""]
[null,"1977-06-06","1977-07-05","2044-09-06",null,null,null,"Date","2044-09-06",144,8,6,"144 Years 8 Months 6 Days",null,"","","","",""]
[null,"1977-07-06","1977-08-05","2044-11-06",null,null,null,"Date","2044-11-06",144,10,6,"144 Years 10 Months 6 Days",null,"","","","",""]
[null,"1977-08-06","1977-09-05","2045-01-06",null,null,null,"Date","2045-01-06",145,0,6,"145 Years 0 Months 6 Days",null,"","","","",""]
[null,"1977-09-06","1977-10-05","2045-03-06",null,null,null,"Date","2045-03-06",145,2,6,"145 Years 2 Months 6 Days",null,"","","","",""]
[null,"1977-10-06","1977-11-05","2045-05-06",null,null,null,"Date","2045-05-06",145,4,6,"145 Years 4 Months 6 Days",null,"","","","",""]
[null,"1977-11-06","1977-12-05","2045-07-06",null,null,null,"Date","2045-07-06",145,6,6,"145 Years 6 Months 6 Days",null,"","","","",""]
[null,"1977-12-06","1978-01-05","2045-09-06",null,null,null,"Date","2045-09-06",145,8,6,"145 Years 8 Months 6 Days",null,"","","","",""]
[null,"1978-01-06","1978-02-05","2045-11-06",null,null,null,"Date","2045-11-06",145,10,6,"145 Years 10 Months 6 Days",null,"","","","",""]
[null,"1978-02-06","1978-03-05","2046-01-06",null,null,null,"Date","2046-01-06",146,0,6,"146 Years 0 Months 6 Days",null,"","","","",""]
[null,"1978-03-06","1978-04-05","2046-03-06",null,null,null,"Date","2046-03-06",146,2,6,"146 Years 2 Months 6 Days",null,"","","","",""]
[null,"1978-04-06","2999-12-31",null,68,68,null,"Age","1967-12-31",68,0,0,"68 Years 0 Months 0 Days",null,"","","","",""]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(H126=\"Age\",DATE(YEAR(dayDOB)+IF(strSEX=\"Male\",E126,F126),MONTH(dayDOB),DAY(dayDOB)),D126)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H158=\"Age\",DATE(YEAR(dayDOB)+IF(strSEX=\"Male\",E158,F158),MONTH(dayDOB),DAY(dayDOB)),D158)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SPD - Errors and Messages"]
[]
[]
[null,"Error and other messages"]
[null,"General"]
[null,{"$f":"IF(bSPDOverallError,\"SPA ERROR :\"&errSex,\"\")","v":""},null,null,null,null,null,null,"_errSPDOverall"]
[null,{"$f":"\"Calculation Date :\" &TEXT(NOW(),\"hh:mm,  dd mmm yyyy \")&\".  \"","v":"Calculation Date :15:09,  03 Feb 2025 .  "},null,null,null,null,null,null,"msgPrint"]
[null,{"$f":"IF(bSPDSexError,\"Sex Incorrect\",\"\")","v":""},null,null,null,null,null,null,"_errSex"]
[]
[]
[null,null,{"$f":"$C$1&\" - Error Checking\"","v":"SPD - Error Checking"}]
[]
[]
[null,"Error Checking"]
[]
[null,"Sex Error (FALSE=OK)",{"$f":"IF(OR(LEFT(LOWER(strSEX))=\"m\",LEFT(LOWER(strSEX))=\"f\"),FALSE,TRUE)","v":false},"bSPDSexError"]
[null,"Overall Error (FALSE=OK)",{"$f":"IF(OR(bSPDSexError),TRUE,FALSE)","v":false},"bSPDOverallError"]

{"sheet":"Factors_hide","index":4,"n_rows":122,"n_cols":76,"rows_kept":122,"cut":false,"hidden":true,"merged":[[10,74,10,75],[4,12,4,15],[4,69,4,72],[4,17,4,20],[4,22,4,25],[10,70,10,71],[10,72,10,73]]}
[]
[null,null,null,{"$f":"\"CILON\"&\" - Tables\"","v":"CILON - Tables"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"From documents ‘CILON factors (for Cabinet Office)-alpha-30Mar15.xlsx’ and ‘alpha compensation in lieu of notice (CILON) factors and guidance DRAFT -30Mar15.pdf’",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part1 and alpha service split flow chart v0.2 17032015.vsdx"]
[null,null,null,null,null,null,null,null,null,null,null,null,"tabP2CIL12016",null,null,null,null,"tabP2CIL12017",null,null,null,null,"tabP2CIL12018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tabOutcomes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Table Number","CILON factors (unisex)",null,null,null,"Table Number","CILON factors (unisex)",null,null,null,"Table Number","CILON factors (unisex)",null,null,null,"Table Number","CILON factors (unisex)",null,null,null,"Table Number","CILON factors (unisex)",null,null,null,"Table Number","CILON factors (unisex)",null,null,null,"Table Number",null,null,null,null,"Table Number",null,null,null,null,"Table Number",null,null,null,null,"Table Number",null,null,null,null,"Table Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,"P2CIL1 2015/2016",null,null,null,null,"P2CIL1 2016/2017",null,null,null,null,"P2CIL1 2017/2018",null,null,null,null,"P2CIL1 2018/2019",null,null,null,null,"P2CIL1 2019/2020",null,null,null,null,"P2CIL1 2020/2021",null,null,null,null,"P2CIL1 2021/2022",null,null,null,null,"P2CIL1 2022/2023",null,null,null,null,"P2CIL1 2023/2024",null,null,null,null,"P2CIL1 2024/2025",null,null,null,null,"P2CIL1 2025/2026"]
[null,"tabContRates2016","tabContRates2017","tabContRates2018","tabContRates2020","tabContRates2021","tabContRates2022","tabContRates2023","tabContRates2024","tabContRates2025","tabContRates2026",null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor",null,null,null,null,"CILON factor"]
[null,"2015/16","2016/17","2017/18","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26",null,"Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68",null,null,"Outcomes of service splits"]
[null,3,3,null,null,null,null,null,null,null,null,null,"20 and under",0.123,0.11700000000000001,0.111,0.106,"20 and under",0.13600000000000001,0.129,0.122,0.11700000000000001,"20 and under",0.13600000000000001,0.129,0.122,0.11700000000000001,"20 and under",0.13600000000000001,0.129,0.122,0.11700000000000001,"20 and under",0.16400000000000001,0.156,0.14799999999999999,0.14099999999999999,"20 and under",0.16400000000000001,0.156,0.14799999999999999,0.14099999999999999,"20 and under",0.16400000000000001,0.156,0.14799999999999999,0.14099999999999999,"20 and under",0.16400000000000001,0.156,0.14799999999999999,0.14099999999999999,"\\",0.246,0.23599999999999999,0.22700000000000001,0.218,"\\",0.246,0.23599999999999999,0.22700000000000001,0.218,"\\",0.246,0.23599999999999999,0.22700000000000001,0.218,null,null,null,"DOL to 31/3/yy",null,"1/4/yy to Taper -1",null,"TaperDate to DoNE "]
[null,3.8,3.8,null,null,null,null,null,null,null,null,null,21,0.126,0.12,0.114,0.109,21,0.13900000000000001,0.13200000000000001,0.125,0.12,21,0.13900000000000001,0.13200000000000001,0.125,0.12,21,0.13900000000000001,0.13200000000000001,0.125,0.12,21,0.16700000000000001,0.159,0.151,0.14399999999999999,21,0.16700000000000001,0.159,0.151,0.14399999999999999,21,0.16700000000000001,0.159,0.151,0.14399999999999999,21,0.16700000000000001,0.159,0.151,0.14399999999999999,21,0.249,0.24,0.23,0.221,21,0.249,0.24,0.23,0.221,21,0.249,0.24,0.23,0.221,null,null,"Outcome","Rate","Scheme methodology","Rate","Scheme methodology","Rate","Scheme methodology"]
[null,4.5999999999999996,4.5999999999999996,4.5999999999999996,4.5999999999999996,4.5999999999999996,4.5999999999999996,4.5999999999999996,4.5999999999999996,4.5999999999999996,4.5999999999999996,null,22,0.129,0.123,0.11799999999999999,0.112,22,0.14199999999999999,0.13500000000000001,0.13,0.123,22,0.14199999999999999,0.13500000000000001,0.13,0.123,22,0.14199999999999999,0.13500000000000001,0.13,0.123,22,0.17,0.16200000000000001,0.155,0.14799999999999999,22,0.17,0.16200000000000001,0.155,0.14799999999999999,22,0.17,0.16200000000000001,0.155,0.14799999999999999,22,0.17,0.16200000000000001,0.155,0.14799999999999999,22,0.253,0.24299999999999999,0.23300000000000001,0.224,22,0.253,0.24299999999999999,0.23300000000000001,0.224,22,0.253,0.24299999999999999,0.23300000000000001,0.224,null,null,1,"yy-1","alpha","yy","alpha","yy","alpha"]
[null,5.45,5.45,5.45,5.45,5.45,5.45,5.45,5.45,5.45,5.45,null,23,0.13300000000000001,0.127,0.121,0.115,23,0.14599999999999999,0.13900000000000001,0.13300000000000001,0.126,23,0.14599999999999999,0.13900000000000001,0.13300000000000001,0.126,23,0.14599999999999999,0.13900000000000001,0.13300000000000001,0.126,23,0.17399999999999999,0.16600000000000001,0.158,0.151,23,0.17399999999999999,0.16600000000000001,0.158,0.151,23,0.17399999999999999,0.16600000000000001,0.158,0.151,23,0.17399999999999999,0.16600000000000001,0.158,0.151,23,0.25700000000000001,0.247,0.23699999999999999,0.22700000000000001,23,0.25700000000000001,0.247,0.23699999999999999,0.22700000000000001,23,0.25700000000000001,0.247,0.23699999999999999,0.22700000000000001,null,null,2,"yy-1","alpha","yy-1","alpha","yy-1","alpha"]
[null,7.35,7.35,7.35,7.35,7.35,7.35,7.35,7.35,7.35,7.35,null,24,0.13700000000000001,0.13,0.124,0.11799999999999999,24,0.15,0.14199999999999999,0.13600000000000001,0.129,24,0.15,0.14199999999999999,0.13600000000000001,0.129,24,0.15,0.14199999999999999,0.13600000000000001,0.129,24,0.17799999999999999,0.16900000000000001,0.161,0.154,24,0.17799999999999999,0.16900000000000001,0.161,0.154,24,0.17799999999999999,0.16900000000000001,0.161,0.154,24,0.17799999999999999,0.16900000000000001,0.161,0.154,24,0.26,0.25,0.24,0.23,24,0.26,0.25,0.24,0.23,24,0.26,0.25,0.24,0.23,null,null,3,"yy-1","part 1","yy","part 1","yy","alpha"]
[null,8.0500000000000007,8.0500000000000007,8.0500000000000007,8.0500000000000007,8.0500000000000007,8.0500000000000007,8.0500000000000007,8.0500000000000007,8.0500000000000007,8.0500000000000007,null,25,0.14000000000000001,0.13400000000000001,0.127,0.121,25,0.153,0.14599999999999999,0.13900000000000001,0.13200000000000001,25,0.153,0.14599999999999999,0.13900000000000001,0.13200000000000001,25,0.153,0.14599999999999999,0.13900000000000001,0.13200000000000001,25,0.18099999999999999,0.17299999999999999,0.16400000000000001,0.157,25,0.18099999999999999,0.17299999999999999,0.16400000000000001,0.157,25,0.18099999999999999,0.17299999999999999,0.16400000000000001,0.157,25,0.18099999999999999,0.17299999999999999,0.16400000000000001,0.157,25,0.26400000000000001,0.254,0.24399999999999999,0.23400000000000001,25,0.26400000000000001,0.254,0.24399999999999999,0.23400000000000001,25,0.26400000000000001,0.254,0.24399999999999999,0.23400000000000001,null,null,4,"yy-1","part 1","yy-1","part 1","yy","alpha"]
[null,null,null,null,null,null,null,null,null,null,null,null,26,0.14499999999999999,0.13800000000000001,0.13200000000000001,0.125,26,0.158,0.15,0.14399999999999999,0.13600000000000001,26,0.158,0.15,0.14399999999999999,0.13600000000000001,26,0.158,0.15,0.14399999999999999,0.13600000000000001,26,0.186,0.17699999999999999,0.17,0.161,26,0.186,0.17699999999999999,0.17,0.161,26,0.186,0.17699999999999999,0.17,0.161,26,0.186,0.17699999999999999,0.17,0.161,26,0.26800000000000002,0.25700000000000001,0.247,0.23699999999999999,26,0.26800000000000002,0.25700000000000001,0.247,0.23699999999999999,26,0.26800000000000002,0.25700000000000001,0.247,0.23699999999999999,null,null,5,"yy-1","part 1","yy-1","part 1","yy-1","alpha"]
[null,null,null,null,null,null,null,null,null,null,null,null,27,0.15,0.14299999999999999,0.13600000000000001,0.129,27,0.16300000000000001,0.156,0.14799999999999999,0.14000000000000001,27,0.16300000000000001,0.156,0.14799999999999999,0.14000000000000001,27,0.16300000000000001,0.156,0.14799999999999999,0.14000000000000001,27,0.192,0.183,0.17399999999999999,0.16500000000000001,27,0.192,0.183,0.17399999999999999,0.16500000000000001,27,0.192,0.183,0.17399999999999999,0.16500000000000001,27,0.192,0.183,0.17399999999999999,0.16500000000000001,27,0.27200000000000002,0.26100000000000001,0.251,0.24,27,0.27200000000000002,0.26100000000000001,0.251,0.24,27,0.27200000000000002,0.26100000000000001,0.251,0.24,null,null,6,"yy-1","part 1","yy-1","part 1","yy-1","part 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,28,0.154,0.14699999999999999,0.14000000000000001,0.13300000000000001,28,0.16700000000000001,0.16,0.152,0.14399999999999999,28,0.16700000000000001,0.16,0.152,0.14399999999999999,28,0.16700000000000001,0.16,0.152,0.14399999999999999,28,0.19500000000000001,0.187,0.17799999999999999,0.16900000000000001,28,0.19500000000000001,0.187,0.17799999999999999,0.16900000000000001,28,0.19500000000000001,0.187,0.17799999999999999,0.16900000000000001,28,0.19500000000000001,0.187,0.17799999999999999,0.16900000000000001,28,0.27600000000000002,0.26500000000000001,0.254,0.24399999999999999,28,0.27600000000000002,0.26500000000000001,0.254,0.24399999999999999,28,0.27600000000000002,0.26500000000000001,0.254,0.24399999999999999,null,null,7,"yy-1","part 1","yy","part 1","yy","part 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,29,0.158,0.151,0.14399999999999999,0.13700000000000001,29,0.17100000000000001,0.16400000000000001,0.156,0.14799999999999999,29,0.17100000000000001,0.16400000000000001,0.156,0.14799999999999999,29,0.17100000000000001,0.16400000000000001,0.156,0.14799999999999999,29,0.19900000000000001,0.191,0.182,0.17299999999999999,29,0.19900000000000001,0.191,0.182,0.17299999999999999,29,0.19900000000000001,0.191,0.182,0.17299999999999999,29,0.19900000000000001,0.191,0.182,0.17299999999999999,29,0.28000000000000003,0.26900000000000002,0.25800000000000001,0.247,29,0.28000000000000003,0.26900000000000002,0.25800000000000001,0.247,29,0.28000000000000003,0.26900000000000002,0.25800000000000001,0.247]
[null,null,null,null,null,null,null,null,null,null,null,null,30,0.16300000000000001,0.156,0.14799999999999999,0.14099999999999999,30,0.17599999999999999,0.16900000000000001,0.16,0.152,30,0.17599999999999999,0.16900000000000001,0.16,0.152,30,0.17599999999999999,0.16900000000000001,0.16,0.152,30,0.20399999999999999,0.19600000000000001,0.186,0.17699999999999999,30,0.20399999999999999,0.19600000000000001,0.186,0.17699999999999999,30,0.20399999999999999,0.19600000000000001,0.186,0.17699999999999999,30,0.20399999999999999,0.19600000000000001,0.186,0.17699999999999999,30,0.28399999999999997,0.27200000000000002,0.26100000000000001,0.251,30,0.28399999999999997,0.27200000000000002,0.26100000000000001,0.251,30,0.28399999999999997,0.27200000000000002,0.26100000000000001,0.251]
[null,null,null,null,null,null,null,null,null,null,null,null,31,0.16800000000000001,0.16,0.153,0.14499999999999999,31,0.18099999999999999,0.17299999999999999,0.16500000000000001,0.157,31,0.18099999999999999,0.17299999999999999,0.16500000000000001,0.157,31,0.18099999999999999,0.17299999999999999,0.16500000000000001,0.157,31,0.20899999999999999,0.2,0.191,0.18099999999999999,31,0.20899999999999999,0.2,0.191,0.18099999999999999,31,0.20899999999999999,0.2,0.191,0.18099999999999999,31,0.20899999999999999,0.2,0.191,0.18099999999999999,31,0.28799999999999998,0.27600000000000002,0.26500000000000001,0.254,31,0.28799999999999998,0.27600000000000002,0.26500000000000001,0.254,31,0.28799999999999998,0.27600000000000002,0.26500000000000001,0.254]
[null,null,null,null,null,null,null,null,null,null,null,null,32,0.17299999999999999,0.16500000000000001,0.157,0.15,32,0.186,0.17799999999999999,0.16900000000000001,0.16200000000000001,32,0.186,0.17799999999999999,0.16900000000000001,0.16200000000000001,32,0.186,0.17799999999999999,0.16900000000000001,0.16200000000000001,32,0.214,0.20499999999999999,0.19500000000000001,0.186,32,0.214,0.20499999999999999,0.19500000000000001,0.186,32,0.214,0.20499999999999999,0.19500000000000001,0.186,32,0.214,0.20499999999999999,0.19500000000000001,0.186,32,0.29199999999999998,0.28000000000000003,0.26900000000000002,0.25800000000000001,32,0.29199999999999998,0.28000000000000003,0.26900000000000002,0.25800000000000001,32,0.29199999999999998,0.28000000000000003,0.26900000000000002,0.25800000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,33,0.17799999999999999,0.17,0.16200000000000001,0.154,33,0.191,0.183,0.17399999999999999,0.16600000000000001,33,0.191,0.183,0.17399999999999999,0.16600000000000001,33,0.191,0.183,0.17399999999999999,0.16600000000000001,33,0.219,0.21,0.2,0.19,33,0.219,0.21,0.2,0.19,33,0.219,0.21,0.2,0.19,33,0.219,0.21,0.2,0.19,33,0.29599999999999999,0.28399999999999997,0.27200000000000002,0.26100000000000001,33,0.29599999999999999,0.28399999999999997,0.27200000000000002,0.26100000000000001,33,0.29599999999999999,0.28399999999999997,0.27200000000000002,0.26100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,34,0.183,0.17499999999999999,0.16700000000000001,0.159,34,0.19600000000000001,0.188,0.17899999999999999,0.17100000000000001,34,0.19600000000000001,0.188,0.17899999999999999,0.17100000000000001,34,0.19600000000000001,0.188,0.17899999999999999,0.17100000000000001,34,0.224,0.215,0.20499999999999999,0.19500000000000001,34,0.224,0.215,0.20499999999999999,0.19500000000000001,34,0.224,0.215,0.20499999999999999,0.19500000000000001,34,0.224,0.215,0.20499999999999999,0.19500000000000001,34,0.3,0.28799999999999998,0.27600000000000002,0.26500000000000001,34,0.3,0.28799999999999998,0.27600000000000002,0.26500000000000001,34,0.3,0.28799999999999998,0.27600000000000002,0.26500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,35,0.189,0.18,0.17100000000000001,0.16300000000000001,35,0.20200000000000001,0.193,0.183,0.17499999999999999,35,0.20200000000000001,0.193,0.183,0.17499999999999999,35,0.20200000000000001,0.193,0.183,0.17499999999999999,35,0.23,0.219,0.20899999999999999,0.19900000000000001,35,0.23,0.219,0.20899999999999999,0.19900000000000001,35,0.23,0.219,0.20899999999999999,0.19900000000000001,35,0.23,0.219,0.20899999999999999,0.19900000000000001,35,0.30399999999999999,0.29199999999999998,0.28000000000000003,0.26800000000000002,35,0.30399999999999999,0.29199999999999998,0.28000000000000003,0.26800000000000002,35,0.30399999999999999,0.29199999999999998,0.28000000000000003,0.26800000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,36,0.19400000000000001,0.185,0.17599999999999999,0.16800000000000001,36,0.20699999999999999,0.19800000000000001,0.188,0.18,36,0.20699999999999999,0.19800000000000001,0.188,0.18,36,0.20699999999999999,0.19800000000000001,0.188,0.18,36,0.23499999999999999,0.224,0.21299999999999999,0.20399999999999999,36,0.23499999999999999,0.224,0.21299999999999999,0.20399999999999999,36,0.23499999999999999,0.224,0.21299999999999999,0.20399999999999999,36,0.23499999999999999,0.224,0.21299999999999999,0.20399999999999999,36,0.309,0.29599999999999999,0.28399999999999997,0.27200000000000002,36,0.309,0.29599999999999999,0.28399999999999997,0.27200000000000002,36,0.309,0.29599999999999999,0.28399999999999997,0.27200000000000002]
[null,"2015/16","2016/17 TEST FACTORS",null,null,null,null,null,null,null,null,null,37,0.19900000000000001,0.19,0.18099999999999999,0.17299999999999999,37,0.21199999999999999,0.20300000000000001,0.193,0.185,37,0.21199999999999999,0.20300000000000001,0.193,0.185,37,0.21199999999999999,0.20300000000000001,0.193,0.185,37,0.24,0.22900000000000001,0.218,0.20899999999999999,37,0.24,0.22900000000000001,0.218,0.20899999999999999,37,0.24,0.22900000000000001,0.218,0.20899999999999999,37,0.24,0.22900000000000001,0.218,0.20899999999999999,37,0.313,0.3,0.28799999999999998,0.27600000000000002,37,0.313,0.3,0.28799999999999998,0.27600000000000002,37,0.313,0.3,0.28799999999999998,0.27600000000000002]
[null,3,3.72,null,null,null,null,null,null,null,null,null,38,0.20499999999999999,0.19600000000000001,0.186,0.17799999999999999,38,0.218,0.20899999999999999,0.19800000000000001,0.19,38,0.218,0.20899999999999999,0.19800000000000001,0.19,38,0.218,0.20899999999999999,0.19800000000000001,0.19,38,0.245,0.23499999999999999,0.223,0.21299999999999999,38,0.245,0.23499999999999999,0.223,0.21299999999999999,38,0.245,0.23499999999999999,0.223,0.21299999999999999,38,0.245,0.23499999999999999,0.223,0.21299999999999999,38,0.317,0.30399999999999999,0.29199999999999998,0.27900000000000003,38,0.317,0.30399999999999999,0.29199999999999998,0.27900000000000003,38,0.317,0.30399999999999999,0.29199999999999998,0.27900000000000003]
[null,4.5999999999999996,5.7039999999999997,null,null,null,null,null,null,null,null,null,39,0.21099999999999999,0.20100000000000001,0.192,0.183,39,0.224,0.214,0.20399999999999999,0.19400000000000001,39,0.224,0.214,0.20399999999999999,0.19400000000000001,39,0.224,0.214,0.20399999999999999,0.19400000000000001,39,0.251,0.23899999999999999,0.22900000000000001,0.218,39,0.251,0.23899999999999999,0.22900000000000001,0.218,39,0.251,0.23899999999999999,0.22900000000000001,0.218,39,0.251,0.23899999999999999,0.22900000000000001,0.218,39,0.32100000000000001,0.308,0.29499999999999998,0.28299999999999997,39,0.32100000000000001,0.308,0.29499999999999998,0.28299999999999997,39,0.32100000000000001,0.308,0.29499999999999998,0.28299999999999997]
[null,5.45,6.758,null,null,null,null,null,null,null,null,null,40,0.217,0.20699999999999999,0.19700000000000001,0.188,40,0.23,0.219,0.20899999999999999,0.19900000000000001,40,0.23,0.219,0.20899999999999999,0.19900000000000001,40,0.23,0.219,0.20899999999999999,0.19900000000000001,40,0.25700000000000001,0.245,0.23300000000000001,0.223,40,0.25700000000000001,0.245,0.23300000000000001,0.223,40,0.25700000000000001,0.245,0.23300000000000001,0.223,40,0.25700000000000001,0.245,0.23300000000000001,0.223,40,0.32600000000000001,0.312,0.29899999999999999,0.28699999999999998,40,0.32600000000000001,0.312,0.29899999999999999,0.28699999999999998,40,0.32600000000000001,0.312,0.29899999999999999,0.28699999999999998]
[null,7.35,9.1140000000000008,null,null,null,null,null,null,null,null,null,41,0.223,0.21299999999999999,0.20300000000000001,0.193,41,0.23599999999999999,0.22500000000000001,0.215,0.20399999999999999,41,0.23599999999999999,0.22500000000000001,0.215,0.20399999999999999,41,0.23599999999999999,0.22500000000000001,0.215,0.20399999999999999,41,0.26200000000000001,0.251,0.23899999999999999,0.22700000000000001,41,0.26200000000000001,0.251,0.23899999999999999,0.22700000000000001,41,0.26200000000000001,0.251,0.23899999999999999,0.22700000000000001,41,0.26200000000000001,0.251,0.23899999999999999,0.22700000000000001,41,0.33,0.317,0.30299999999999999,0.29099999999999998,41,0.33,0.317,0.30299999999999999,0.29099999999999998,41,0.33,0.317,0.30299999999999999,0.29099999999999998]
[null,8.0500000000000007,9.9819999999999993,null,null,null,null,null,null,null,null,null,42,0.22900000000000001,0.218,0.20799999999999999,0.19800000000000001,42,0.24199999999999999,0.23,0.22,0.20899999999999999,42,0.24199999999999999,0.23,0.22,0.20899999999999999,42,0.24199999999999999,0.23,0.22,0.20899999999999999,42,0.26800000000000002,0.255,0.24399999999999999,0.23200000000000001,42,0.26800000000000002,0.255,0.24399999999999999,0.23200000000000001,42,0.26800000000000002,0.255,0.24399999999999999,0.23200000000000001,42,0.26800000000000002,0.255,0.24399999999999999,0.23200000000000001,42,0.33500000000000002,0.32100000000000001,0.307,0.29399999999999998,42,0.33500000000000002,0.32100000000000001,0.307,0.29399999999999998,42,0.33500000000000002,0.32100000000000001,0.307,0.29399999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,43,0.23599999999999999,0.22500000000000001,0.214,0.20399999999999999,43,0.249,0.23699999999999999,0.22600000000000001,0.215,43,0.249,0.23699999999999999,0.22600000000000001,0.215,43,0.249,0.23699999999999999,0.22600000000000001,0.215,43,0.27400000000000002,0.26200000000000001,0.249,0.23799999999999999,43,0.27400000000000002,0.26200000000000001,0.249,0.23799999999999999,43,0.27400000000000002,0.26200000000000001,0.249,0.23799999999999999,43,0.27400000000000002,0.26200000000000001,0.249,0.23799999999999999,43,0.33900000000000002,0.32500000000000001,0.312,0.29799999999999999,43,0.33900000000000002,0.32500000000000001,0.312,0.29799999999999999,43,0.33900000000000002,0.32500000000000001,0.312,0.29799999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,44,0.24199999999999999,0.23100000000000001,0.22,0.21,44,0.255,0.24299999999999999,0.23200000000000001,0.221,44,0.255,0.24299999999999999,0.23200000000000001,0.221,44,0.255,0.24299999999999999,0.23200000000000001,0.221,44,0.28000000000000003,0.26700000000000002,0.255,0.24299999999999999,44,0.28000000000000003,0.26700000000000002,0.255,0.24299999999999999,44,0.28000000000000003,0.26700000000000002,0.255,0.24299999999999999,44,0.28000000000000003,0.26700000000000002,0.255,0.24299999999999999,44,0.34399999999999997,0.33,0.316,0.30199999999999999,44,0.34399999999999997,0.33,0.316,0.30199999999999999,44,0.34399999999999997,0.33,0.316,0.30199999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,45,0.249,0.23799999999999999,0.22600000000000001,0.216,45,0.26100000000000001,0.25,0.23699999999999999,0.22700000000000001,45,0.26100000000000001,0.25,0.23699999999999999,0.22700000000000001,45,0.26100000000000001,0.25,0.23699999999999999,0.22700000000000001,45,0.28599999999999998,0.27400000000000002,0.26,0.249,45,0.28599999999999998,0.27400000000000002,0.26,0.249,45,0.28599999999999998,0.27400000000000002,0.26,0.249,45,0.28599999999999998,0.27400000000000002,0.26,0.249,45,0.34899999999999998,0.33400000000000002,0.32,0.30599999999999999,45,0.34899999999999998,0.33400000000000002,0.32,0.30599999999999999,45,0.34899999999999998,0.33400000000000002,0.32,0.30599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,46,0.25600000000000001,0.24399999999999999,0.23300000000000001,0.222,46,0.26800000000000002,0.25600000000000001,0.24399999999999999,0.23300000000000001,46,0.26800000000000002,0.25600000000000001,0.24399999999999999,0.23300000000000001,46,0.26800000000000002,0.25600000000000001,0.24399999999999999,0.23300000000000001,46,0.29199999999999998,0.27900000000000003,0.26600000000000001,0.254,46,0.29199999999999998,0.27900000000000003,0.26600000000000001,0.254,46,0.29199999999999998,0.27900000000000003,0.26600000000000001,0.254,46,0.29199999999999998,0.27900000000000003,0.26600000000000001,0.254,46,0.35299999999999998,0.33800000000000002,0.32400000000000001,0.31,46,0.35299999999999998,0.33800000000000002,0.32400000000000001,0.31,46,0.35299999999999998,0.33800000000000002,0.32400000000000001,0.31]
[null,null,null,null,null,null,null,null,null,null,null,null,47,0.26400000000000001,0.251,0.24,0.22800000000000001,47,0.27600000000000002,0.26300000000000001,0.251,0.23899999999999999,47,0.27600000000000002,0.26300000000000001,0.251,0.23899999999999999,47,0.27600000000000002,0.26300000000000001,0.251,0.23899999999999999,47,0.3,0.28499999999999998,0.27300000000000002,0.25900000000000001,47,0.3,0.28499999999999998,0.27300000000000002,0.25900000000000001,47,0.3,0.28499999999999998,0.27300000000000002,0.25900000000000001,47,0.3,0.28499999999999998,0.27300000000000002,0.25900000000000001,47,0.35799999999999998,0.34300000000000003,0.32800000000000001,0.314,47,0.35799999999999998,0.34300000000000003,0.32800000000000001,0.314,47,0.35799999999999998,0.34300000000000003,0.32800000000000001,0.314]
[null,null,null,null,null,null,null,null,null,null,null,null,48,0.27100000000000002,0.25900000000000001,0.247,0.23499999999999999,48,0.28299999999999997,0.27,0.25800000000000001,0.245,48,0.28299999999999997,0.27,0.25800000000000001,0.245,48,0.28299999999999997,0.27,0.25800000000000001,0.245,48,0.30599999999999999,0.29299999999999998,0.27900000000000003,0.26600000000000001,48,0.30599999999999999,0.29299999999999998,0.27900000000000003,0.26600000000000001,48,0.30599999999999999,0.29299999999999998,0.27900000000000003,0.26600000000000001,48,0.30599999999999999,0.29299999999999998,0.27900000000000003,0.26600000000000001,48,0.36299999999999999,0.34699999999999998,0.33200000000000002,0.318,48,0.36299999999999999,0.34699999999999998,0.33200000000000002,0.318,48,0.36299999999999999,0.34699999999999998,0.33200000000000002,0.318]
[null,null,null,null,null,null,null,null,null,null,null,null,49,0.27900000000000003,0.26600000000000001,0.254,0.24199999999999999,49,0.29099999999999998,0.27700000000000002,0.26500000000000001,0.252,49,0.29099999999999998,0.27700000000000002,0.26500000000000001,0.252,49,0.29099999999999998,0.27700000000000002,0.26500000000000001,0.252,49,0.313,0.29899999999999999,0.28499999999999998,0.27200000000000002,49,0.313,0.29899999999999999,0.28499999999999998,0.27200000000000002,49,0.313,0.29899999999999999,0.28499999999999998,0.27200000000000002,49,0.313,0.29899999999999999,0.28499999999999998,0.27200000000000002,49,0.36799999999999999,0.35199999999999998,0.33700000000000002,0.32200000000000001,49,0.36799999999999999,0.35199999999999998,0.33700000000000002,0.32200000000000001,49,0.36799999999999999,0.35199999999999998,0.33700000000000002,0.32200000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,50,0.28699999999999998,0.27400000000000002,0.26100000000000001,0.249,50,0.29799999999999999,0.28499999999999998,0.27100000000000002,0.25900000000000001,50,0.29799999999999999,0.28499999999999998,0.27100000000000002,0.25900000000000001,50,0.29799999999999999,0.28499999999999998,0.27100000000000002,0.25900000000000001,50,0.32,0.30599999999999999,0.29199999999999998,0.27800000000000002,50,0.32,0.30599999999999999,0.29199999999999998,0.27800000000000002,50,0.32,0.30599999999999999,0.29199999999999998,0.27800000000000002,50,0.32,0.30599999999999999,0.29199999999999998,0.27800000000000002,50,0.373,0.35699999999999998,0.34100000000000003,0.32600000000000001,50,0.373,0.35699999999999998,0.34100000000000003,0.32600000000000001,50,0.373,0.35699999999999998,0.34100000000000003,0.32600000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,51,0.29499999999999998,0.28199999999999997,0.26800000000000002,0.25600000000000001,51,0.30599999999999999,0.29299999999999998,0.27800000000000002,0.26600000000000001,51,0.30599999999999999,0.29299999999999998,0.27800000000000002,0.26600000000000001,51,0.30599999999999999,0.29299999999999998,0.27800000000000002,0.26600000000000001,51,0.32700000000000001,0.313,0.29799999999999999,0.28399999999999997,51,0.32700000000000001,0.313,0.29799999999999999,0.28399999999999997,51,0.32700000000000001,0.313,0.29799999999999999,0.28399999999999997,51,0.32700000000000001,0.313,0.29799999999999999,0.28399999999999997,51,0.378,0.36099999999999999,0.34599999999999997,0.33,51,0.378,0.36099999999999999,0.34599999999999997,0.33,51,0.378,0.36099999999999999,0.34599999999999997,0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,52,0.30399999999999999,0.28999999999999998,0.27600000000000002,0.26300000000000001,52,0.315,0.3,0.28599999999999998,0.27300000000000002,52,0.315,0.3,0.28599999999999998,0.27300000000000002,52,0.315,0.3,0.28599999999999998,0.27300000000000002,52,0.33500000000000002,0.32,0.30499999999999999,0.29099999999999998,52,0.33500000000000002,0.32,0.30499999999999999,0.29099999999999998,52,0.33500000000000002,0.32,0.30499999999999999,0.29099999999999998,52,0.33500000000000002,0.32,0.30499999999999999,0.29099999999999998,52,0.38300000000000001,0.36599999999999999,0.35,0.33400000000000002,52,0.38300000000000001,0.36599999999999999,0.35,0.33400000000000002,52,0.38300000000000001,0.36599999999999999,0.35,0.33400000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,53,0.312,0.29799999999999999,0.28399999999999997,0.27100000000000002,53,0.32200000000000001,0.308,0.29399999999999998,0.28000000000000003,53,0.32200000000000001,0.308,0.29399999999999998,0.28000000000000003,53,0.32200000000000001,0.308,0.29399999999999998,0.28000000000000003,53,0.34200000000000003,0.32700000000000001,0.312,0.29799999999999999,53,0.34200000000000003,0.32700000000000001,0.312,0.29799999999999999,53,0.34200000000000003,0.32700000000000001,0.312,0.29799999999999999,53,0.34200000000000003,0.32700000000000001,0.312,0.29799999999999999,53,0.38800000000000001,0.371,0.35399999999999998,0.33800000000000002,53,0.38800000000000001,0.371,0.35399999999999998,0.33800000000000002,53,0.38800000000000001,0.371,0.35399999999999998,0.33800000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,54,0.32100000000000001,0.30599999999999999,0.29199999999999998,0.27800000000000002,54,0.33100000000000002,0.316,0.30099999999999999,0.28699999999999998,54,0.33100000000000002,0.316,0.30099999999999999,0.28699999999999998,54,0.33100000000000002,0.316,0.30099999999999999,0.28699999999999998,54,0.35,0.33400000000000002,0.31900000000000001,0.30399999999999999,54,0.35,0.33400000000000002,0.31900000000000001,0.30399999999999999,54,0.35,0.33400000000000002,0.31900000000000001,0.30399999999999999,54,0.35,0.33400000000000002,0.31900000000000001,0.30399999999999999,54,0.39300000000000002,0.376,0.35899999999999999,0.34300000000000003,54,0.39300000000000002,0.376,0.35899999999999999,0.34300000000000003,54,0.39300000000000002,0.376,0.35899999999999999,0.34300000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,55,0.33,0.315,0.3,0.28599999999999998,55,0.34,0.32400000000000001,0.309,0.29499999999999998,55,0.34,0.32400000000000001,0.309,0.29499999999999998,55,0.34,0.32400000000000001,0.309,0.29499999999999998,55,0.35799999999999998,0.34200000000000003,0.32600000000000001,0.311,55,0.35799999999999998,0.34200000000000003,0.32600000000000001,0.311,55,0.35799999999999998,0.34200000000000003,0.32600000000000001,0.311,55,0.35799999999999998,0.34200000000000003,0.32600000000000001,0.311,55,0.39900000000000002,0.38100000000000001,0.36399999999999999,0.34699999999999998,55,0.39900000000000002,0.38100000000000001,0.36399999999999999,0.34699999999999998,55,0.39900000000000002,0.38100000000000001,0.36399999999999999,0.34699999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,56,0.33900000000000002,0.32300000000000001,0.308,0.29399999999999998,56,0.34799999999999998,0.33200000000000002,0.317,0.30199999999999999,56,0.34799999999999998,0.33200000000000002,0.317,0.30199999999999999,56,0.34799999999999998,0.33200000000000002,0.317,0.30199999999999999,56,0.36499999999999999,0.34799999999999998,0.33200000000000002,0.317,56,0.36499999999999999,0.34799999999999998,0.33200000000000002,0.317,56,0.36499999999999999,0.34799999999999998,0.33200000000000002,0.317,56,0.36499999999999999,0.34799999999999998,0.33200000000000002,0.317,56,0.40400000000000003,0.38600000000000001,0.36799999999999999,0.35099999999999998,56,0.40400000000000003,0.38600000000000001,0.36799999999999999,0.35099999999999998,56,0.40400000000000003,0.38600000000000001,0.36799999999999999,0.35099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,57,0.34799999999999998,0.33200000000000002,0.317,0.30199999999999999,57,0.35699999999999998,0.34100000000000003,0.32500000000000001,0.31,57,0.35699999999999998,0.34100000000000003,0.32500000000000001,0.31,57,0.35699999999999998,0.34100000000000003,0.32500000000000001,0.31,57,0.373,0.35599999999999998,0.34,0.32400000000000001,57,0.373,0.35599999999999998,0.34,0.32400000000000001,57,0.373,0.35599999999999998,0.34,0.32400000000000001,57,0.373,0.35599999999999998,0.34,0.32400000000000001,57,0.41,0.39100000000000001,0.373,0.35599999999999998,57,0.41,0.39100000000000001,0.373,0.35599999999999998,57,0.41,0.39100000000000001,0.373,0.35599999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,58,0.35699999999999998,0.34100000000000003,0.32500000000000001,0.31,58,0.36499999999999999,0.34899999999999998,0.33300000000000002,0.317,58,0.36499999999999999,0.34899999999999998,0.33300000000000002,0.317,58,0.36499999999999999,0.34899999999999998,0.33300000000000002,0.317,58,0.38,0.36399999999999999,0.34699999999999998,0.33100000000000002,58,0.38,0.36399999999999999,0.34699999999999998,0.33100000000000002,58,0.38,0.36399999999999999,0.34699999999999998,0.33100000000000002,58,0.38,0.36399999999999999,0.34699999999999998,0.33100000000000002,58,0.41499999999999998,0.39600000000000002,0.378,0.36,58,0.41499999999999998,0.39600000000000002,0.378,0.36,58,0.41499999999999998,0.39600000000000002,0.378,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,59,0.36599999999999999,0.35,0.33400000000000002,0.318,59,0.374,0.35799999999999998,0.34100000000000003,0.32500000000000001,59,0.374,0.35799999999999998,0.34100000000000003,0.32500000000000001,59,0.374,0.35799999999999998,0.34100000000000003,0.32500000000000001,59,0.38800000000000001,0.371,0.35399999999999998,0.33700000000000002,59,0.38800000000000001,0.371,0.35399999999999998,0.33700000000000002,59,0.38800000000000001,0.371,0.35399999999999998,0.33700000000000002,59,0.38800000000000001,0.371,0.35399999999999998,0.33700000000000002,59,0.42099999999999999,0.40200000000000002,0.38300000000000001,0.36499999999999999,59,0.42099999999999999,0.40200000000000002,0.38300000000000001,0.36499999999999999,59,0.42099999999999999,0.40200000000000002,0.38300000000000001,0.36499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,60,0.376,0.35899999999999999,0.34200000000000003,0.32600000000000001,60,0.38300000000000001,0.36599999999999999,0.34899999999999998,0.33300000000000002,60,0.38300000000000001,0.36599999999999999,0.34899999999999998,0.33300000000000002,60,0.38300000000000001,0.36599999999999999,0.34899999999999998,0.33300000000000002,60,0.39600000000000002,0.378,0.36099999999999999,0.34399999999999997,60,0.39600000000000002,0.378,0.36099999999999999,0.34399999999999997,60,0.39600000000000002,0.378,0.36099999999999999,0.34399999999999997,60,0.39600000000000002,0.378,0.36099999999999999,0.34399999999999997,60,0.42699999999999999,0.40799999999999997,0.38800000000000001,0.37,60,0.42699999999999999,0.40799999999999997,0.38800000000000001,0.37,60,0.42699999999999999,0.40799999999999997,0.38800000000000001,0.37]
[null,null,null,null,null,null,null,null,null,null,null,null,61,0.38500000000000001,0.36799999999999999,0.35099999999999998,0.33400000000000002,61,0.39200000000000002,0.375,0.35699999999999998,0.34,61,0.39200000000000002,0.375,0.35699999999999998,0.34,61,0.39200000000000002,0.375,0.35699999999999998,0.34,61,0.40300000000000002,0.38500000000000001,0.36799999999999999,0.35,61,0.40300000000000002,0.38500000000000001,0.36799999999999999,0.35,61,0.40300000000000002,0.38500000000000001,0.36799999999999999,0.35,61,0.40300000000000002,0.38500000000000001,0.36799999999999999,0.35,61,0.434,0.41399999999999998,0.39400000000000002,0.375,61,0.434,0.41399999999999998,0.39400000000000002,0.375,61,0.434,0.41399999999999998,0.39400000000000002,0.375]
[null,null,null,null,null,null,null,null,null,null,null,null,62,0.39500000000000002,0.377,0.36,0.34300000000000003,62,0.40100000000000002,0.38300000000000001,0.36599999999999999,0.34899999999999998,62,0.40100000000000002,0.38300000000000001,0.36599999999999999,0.34899999999999998,62,0.40100000000000002,0.38300000000000001,0.36599999999999999,0.34899999999999998,62,0.41099999999999998,0.39300000000000002,0.375,0.35799999999999998,62,0.41099999999999998,0.39300000000000002,0.375,0.35799999999999998,62,0.41099999999999998,0.39300000000000002,0.375,0.35799999999999998,62,0.41099999999999998,0.39300000000000002,0.375,0.35799999999999998,62,0.441,0.42,0.4,0.38,62,0.441,0.42,0.4,0.38,62,0.441,0.42,0.4,0.38]
[null,null,null,null,null,null,null,null,null,null,null,null,63,0.40600000000000003,0.38700000000000001,0.36899999999999999,0.35199999999999998,63,0.41199999999999998,0.39200000000000002,0.374,0.35699999999999998,63,0.41199999999999998,0.39200000000000002,0.374,0.35699999999999998,63,0.41199999999999998,0.39200000000000002,0.374,0.35699999999999998,63,0.42,0.40100000000000002,0.38200000000000001,0.36499999999999999,63,0.42,0.40100000000000002,0.38200000000000001,0.36499999999999999,63,0.42,0.40100000000000002,0.38200000000000001,0.36499999999999999,63,0.42,0.40100000000000002,0.38200000000000001,0.36499999999999999,63,0.44800000000000001,0.42599999999999999,0.40500000000000003,0.38500000000000001,63,0.44800000000000001,0.42599999999999999,0.40500000000000003,0.38500000000000001,63,0.44800000000000001,0.42599999999999999,0.40500000000000003,0.38500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,64,0.41699999999999998,0.39700000000000002,0.378,0.36,64,0.42199999999999999,0.40200000000000002,0.38300000000000001,0.36399999999999999,64,0.42199999999999999,0.40200000000000002,0.38300000000000001,0.36399999999999999,64,0.42199999999999999,0.40200000000000002,0.38300000000000001,0.36399999999999999,64,0.42899999999999999,0.40899999999999997,0.39,0.371,64,0.42899999999999999,0.40899999999999997,0.39,0.371,64,0.42899999999999999,0.40899999999999997,0.39,0.371,64,0.42899999999999999,0.40899999999999997,0.39,0.371,64,0.45500000000000002,0.433,0.41199999999999998,0.39100000000000001,64,0.45500000000000002,0.433,0.41199999999999998,0.39100000000000001,64,0.45500000000000002,0.433,0.41199999999999998,0.39100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,65,0.41799999999999998,0.40799999999999997,0.38800000000000001,0.36899999999999999,65,0.41799999999999998,0.41199999999999998,0.39200000000000002,0.373,65,0.41799999999999998,0.41199999999999998,0.39200000000000002,0.373,65,0.41799999999999998,0.41199999999999998,0.39200000000000002,0.373,65,0.42399999999999999,0.41799999999999998,0.39800000000000002,0.378,65,0.42399999999999999,0.41799999999999998,0.39800000000000002,0.378,65,0.42399999999999999,0.41799999999999998,0.39800000000000002,0.378,65,0.42399999999999999,0.41799999999999998,0.39800000000000002,0.378,65,0.45200000000000001,0.44,0.41799999999999998,0.39700000000000002,65,0.45200000000000001,0.44,0.41799999999999998,0.39700000000000002,65,0.45200000000000001,0.44,0.41799999999999998,0.39700000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,66,0.40899999999999997,0.40899999999999997,0.39800000000000002,0.379,66,0.40899999999999997,0.40899999999999997,0.40100000000000002,0.38200000000000001,66,0.40899999999999997,0.40899999999999997,0.40100000000000002,0.38200000000000001,66,0.40899999999999997,0.40899999999999997,0.40100000000000002,0.38200000000000001,66,0.41299999999999998,0.41299999999999998,0.40600000000000003,0.38600000000000001,66,0.41299999999999998,0.41299999999999998,0.40600000000000003,0.38600000000000001,66,0.41299999999999998,0.41299999999999998,0.40600000000000003,0.38600000000000001,66,0.41299999999999998,0.41299999999999998,0.40600000000000003,0.38600000000000001,66,0.437,0.437,0.42599999999999999,0.40400000000000003,66,0.437,0.437,0.42599999999999999,0.40400000000000003,66,0.437,0.437,0.42599999999999999,0.40400000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,67,0.39900000000000002,0.39900000000000002,0.39900000000000002,0.38900000000000001,67,0.39900000000000002,0.39900000000000002,0.39900000000000002,0.39100000000000001,67,0.39900000000000002,0.39900000000000002,0.39900000000000002,0.39100000000000001,67,0.39900000000000002,0.39900000000000002,0.39900000000000002,0.39100000000000001,67,0.40200000000000002,0.40200000000000002,0.40200000000000002,0.39400000000000002,67,0.40200000000000002,0.40200000000000002,0.40200000000000002,0.39400000000000002,67,0.40200000000000002,0.40200000000000002,0.40200000000000002,0.39400000000000002,67,0.40200000000000002,0.40200000000000002,0.40200000000000002,0.39400000000000002,67,0.42199999999999999,0.42199999999999999,0.42199999999999999,0.41099999999999998,67,0.42199999999999999,0.42199999999999999,0.42199999999999999,0.41099999999999998,67,0.42199999999999999,0.42199999999999999,0.42199999999999999,0.41099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,68,0.39,0.39,0.39,0.39,68,0.39,0.39,0.39,0.39,68,0.39,0.39,0.39,0.39,68,0.39,0.39,0.39,0.39,68,0.39200000000000002,0.39200000000000002,0.39200000000000002,0.39200000000000002,68,0.39200000000000002,0.39200000000000002,0.39200000000000002,0.39200000000000002,68,0.39200000000000002,0.39200000000000002,0.39200000000000002,0.39200000000000002,68,0.39200000000000002,0.39200000000000002,0.39200000000000002,0.39200000000000002,68,0.40699999999999997,0.40699999999999997,0.40699999999999997,0.40699999999999997,68,0.40699999999999997,0.40699999999999997,0.40699999999999997,0.40699999999999997,68,0.40699999999999997,0.40699999999999997,0.40699999999999997,0.40699999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,69,0.38100000000000001,0.38100000000000001,0.38100000000000001,0.38100000000000001,69,0.38100000000000001,0.38100000000000001,0.38100000000000001,0.38100000000000001,69,0.38100000000000001,0.38100000000000001,0.38100000000000001,0.38100000000000001,69,0.38100000000000001,0.38100000000000001,0.38100000000000001,0.38100000000000001,69,0.38100000000000001,0.38100000000000001,0.38100000000000001,0.38100000000000001,69,0.38100000000000001,0.38100000000000001,0.38100000000000001,0.38100000000000001,69,0.38100000000000001,0.38100000000000001,0.38100000000000001,0.38100000000000001,69,0.38100000000000001,0.38100000000000001,0.38100000000000001,0.38100000000000001,69,0.39200000000000002,0.39200000000000002,0.39200000000000002,0.39200000000000002,69,0.39200000000000002,0.39200000000000002,0.39200000000000002,0.39200000000000002,69,0.39200000000000002,0.39200000000000002,0.39200000000000002,0.39200000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,70,0.371,0.371,0.371,0.371,70,0.371,0.371,0.371,0.371,70,0.371,0.371,0.371,0.371,70,0.371,0.371,0.371,0.371,70,0.37,0.37,0.37,0.37,70,0.37,0.37,0.37,0.37,70,0.37,0.37,0.37,0.37,70,0.37,0.37,0.37,0.37,70,0.377,0.377,0.377,0.377,70,0.377,0.377,0.377,0.377,70,0.377,0.377,0.377,0.377]
[null,null,null,null,null,null,null,null,null,null,null,null,71,0.36099999999999999,0.36099999999999999,0.36099999999999999,0.36099999999999999,71,0.36099999999999999,0.36099999999999999,0.36099999999999999,0.36099999999999999,71,0.36099999999999999,0.36099999999999999,0.36099999999999999,0.36099999999999999,71,0.36099999999999999,0.36099999999999999,0.36099999999999999,0.36099999999999999,71,0.35899999999999999,0.35899999999999999,0.35899999999999999,0.35899999999999999,71,0.35899999999999999,0.35899999999999999,0.35899999999999999,0.35899999999999999,71,0.35899999999999999,0.35899999999999999,0.35899999999999999,0.35899999999999999,71,0.35899999999999999,0.35899999999999999,0.35899999999999999,0.35899999999999999,71,0.36199999999999999,0.36199999999999999,0.36199999999999999,0.36199999999999999,71,0.36199999999999999,0.36199999999999999,0.36199999999999999,0.36199999999999999,71,0.36199999999999999,0.36199999999999999,0.36199999999999999,0.36199999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,72,0.35199999999999998,0.35199999999999998,0.35199999999999998,0.35199999999999998,72,0.35199999999999998,0.35199999999999998,0.35199999999999998,0.35199999999999998,72,0.35199999999999998,0.35199999999999998,0.35199999999999998,0.35199999999999998,72,0.35199999999999998,0.35199999999999998,0.35199999999999998,0.35199999999999998,72,0.34899999999999998,0.34899999999999998,0.34899999999999998,0.34899999999999998,72,0.34899999999999998,0.34899999999999998,0.34899999999999998,0.34899999999999998,72,0.34899999999999998,0.34899999999999998,0.34899999999999998,0.34899999999999998,72,0.34899999999999998,0.34899999999999998,0.34899999999999998,0.34899999999999998,72,0.34799999999999998,0.34799999999999998,0.34799999999999998,0.34799999999999998,72,0.34799999999999998,0.34799999999999998,0.34799999999999998,0.34799999999999998,72,0.34799999999999998,0.34799999999999998,0.34799999999999998,0.34799999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,73,0.34300000000000003,0.34300000000000003,0.34300000000000003,0.34300000000000003,73,0.34300000000000003,0.34300000000000003,0.34300000000000003,0.34300000000000003,73,0.34300000000000003,0.34300000000000003,0.34300000000000003,0.34300000000000003,73,0.34300000000000003,0.34300000000000003,0.34300000000000003,0.34300000000000003,73,0.33900000000000002,0.33900000000000002,0.33900000000000002,0.33900000000000002,73,0.33900000000000002,0.33900000000000002,0.33900000000000002,0.33900000000000002,73,0.33900000000000002,0.33900000000000002,0.33900000000000002,0.33900000000000002,73,0.33900000000000002,0.33900000000000002,0.33900000000000002,0.33900000000000002,73,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,73,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,73,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,74,0.33400000000000002,0.33400000000000002,0.33400000000000002,0.33400000000000002,74,0.33400000000000002,0.33400000000000002,0.33400000000000002,0.33400000000000002,74,0.33400000000000002,0.33400000000000002,0.33400000000000002,0.33400000000000002,74,0.33400000000000002,0.33400000000000002,0.33400000000000002,0.33400000000000002,74,0.32800000000000001,0.32800000000000001,0.32800000000000001,0.32800000000000001,74,0.32800000000000001,0.32800000000000001,0.32800000000000001,0.32800000000000001,74,0.32800000000000001,0.32800000000000001,0.32800000000000001,0.32800000000000001,74,0.32800000000000001,0.32800000000000001,0.32800000000000001,0.32800000000000001,74,0.31900000000000001,0.31900000000000001,0.31900000000000001,0.31900000000000001,74,0.31900000000000001,0.31900000000000001,0.31900000000000001,0.31900000000000001,74,0.31900000000000001,0.31900000000000001,0.31900000000000001,0.31900000000000001]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Age (years) on last day of service","NPA 65","NPA 66","NPA 67","NPA68","<< TEST FACTORS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 and under",0.1353,0.12870000000000001,0.12210000000000001,0.11660000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0.1386,0.13200000000000001,0.12540000000000001,0.11990000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0.14190000000000003,0.1353,0.1298,0.12320000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0.14630000000000001,0.13970000000000002,0.1331,0.12650000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0.15070000000000003,0.14300000000000002,0.13640000000000002,0.1298]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0.15400000000000003,0.14740000000000003,0.13970000000000002,0.1331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0.1595,0.15180000000000002,0.14520000000000002,0.13750000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0.16500000000000001,0.1573,0.14960000000000001,0.14190000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0.16940000000000002,0.16170000000000001,0.15400000000000003,0.14630000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0.17380000000000001,0.1661,0.15840000000000001,0.15070000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0.17930000000000001,0.1716,0.1628,0.15509999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0.18480000000000002,0.17600000000000002,0.16830000000000001,0.1595]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0.1903,0.18150000000000002,0.17270000000000002,0.16500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0.1958,0.18700000000000003,0.17820000000000003,0.16940000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0.20130000000000001,0.1925,0.18370000000000003,0.17490000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0.20790000000000003,0.19800000000000001,0.18810000000000002,0.17930000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0.21340000000000003,0.20350000000000001,0.19359999999999999,0.18480000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0.21890000000000004,0.20900000000000002,0.1991,0.1903]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0.22550000000000001,0.21560000000000001,0.2046,0.1958]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0.2321,0.22110000000000002,0.21120000000000003,0.20130000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.23870000000000002,0.22770000000000001,0.21670000000000003,0.20680000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0.24530000000000002,0.23430000000000001,0.22330000000000003,0.21230000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0.25190000000000001,0.23980000000000001,0.2288,0.21780000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0.2596,0.24750000000000003,0.23540000000000003,0.22440000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0.26619999999999999,0.25410000000000005,0.24200000000000002,0.23100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0.27390000000000003,0.26180000000000003,0.24860000000000002,0.23760000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0.28160000000000002,0.26840000000000003,0.25630000000000003,0.24420000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0.29040000000000005,0.27610000000000001,0.26400000000000001,0.25080000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0.29810000000000003,0.28490000000000004,0.2717,0.25850000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0.30690000000000006,0.29260000000000003,0.27940000000000004,0.26619999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.31569999999999998,0.30140000000000006,0.28710000000000002,0.27390000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0.32450000000000001,0.31019999999999998,0.29480000000000006,0.28160000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0.33440000000000003,0.31900000000000001,0.30360000000000004,0.28930000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0.34320000000000001,0.32780000000000004,0.31240000000000001,0.29810000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0.35310000000000002,0.33660000000000001,0.32119999999999999,0.30580000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0.36300000000000004,0.34650000000000003,0.33,0.31459999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0.37290000000000006,0.35530000000000006,0.33880000000000005,0.32340000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0.38280000000000003,0.36520000000000002,0.34870000000000001,0.3322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0.39269999999999999,0.37510000000000004,0.35750000000000004,0.34100000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0.40260000000000001,0.38500000000000001,0.36740000000000006,0.34980000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.41360000000000002,0.39490000000000003,0.37620000000000003,0.35860000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0.42350000000000004,0.40480000000000005,0.3861,0.36740000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0.43450000000000005,0.41470000000000001,0.39600000000000002,0.37730000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0.44660000000000005,0.42570000000000002,0.40590000000000004,0.38719999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0.4587,0.43670000000000003,0.41580000000000006,0.39600000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0.45980000000000004,0.44880000000000003,0.42680000000000007,0.40590000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,0.44990000000000002,0.44990000000000002,0.43780000000000008,0.41690000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.43890000000000007,0.43890000000000007,0.43890000000000007,0.42790000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,0.42900000000000005,0.42900000000000005,0.42900000000000005,0.42900000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,0.41910000000000003,0.41910000000000003,0.41910000000000003,0.41910000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,0.40810000000000002,0.40810000000000002,0.40810000000000002,0.40810000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,0.39710000000000001,0.39710000000000001,0.39710000000000001,0.39710000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,0.38719999999999999,0.38719999999999999,0.38719999999999999,0.38719999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,0.37730000000000008,0.37730000000000008,0.37730000000000008,0.37730000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,0.36740000000000006,0.36740000000000006,0.36740000000000006,0.36740000000000006]