{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guidance Notes","End of Year Cert 23-24","Staff List","NHS Pensions Only"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guidance Notes","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"End of Year Cert 23-24","index":1,"n_rows":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[[5,0,5,6],[9,0,9,3],[8,0,8,3],[29,0,29,6],[84,0,84,3],[64,0,64,5],[66,0,66,6],[67,0,67,6],[83,0,83,3],[83,5,83,6],[81,0,81,6],[82,0,82,6],[77,0,77,6],[78,0,78,6],[79,0,79,6],[80,0,80,6],[75,0,75,6],[76,0,76,6],[71,0,71,6],[74,0,74,6],[72,0,72,6],[73,0,73,6],[43,0,43,5],[37,0,37,4],[59,0,59,3],[38,0,38,4],[41,0,41,3],[40,0,40,3],[0,0,0,5],[61,0,61,5],[24,2,24,6],[26,0,26,3],[3,0,3,6],[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[21,2,21,6],[22,2,22,6],[27,0,27,1],[33,0,33,4],[31,0,31,4],[32,0,32,4],[34,0,34,4],[70,0,70,6],[1,0,1,6],[2,0,2,6],[23,2,23,6],[13,2,13,6],[14,2,14,6],[19,2,19,6],[8,5,8,6],[9,5,9,6],[12,2,12,6],[4,0,4,6],[6,0,6,6],[68,0,68,6],[69,0,69,6],[35,0,35,4],[36,0,36,4]]}
[]
["Independent Provider (IP) Employing Authority (EA)"]
["2023/24 End of Year Certificate"]
["Please refer to the guidance notes when completing each part of the Certificate."]
["If you would like to password protect this document please provide a contact name and telephone number in your covering email to: pensionsfinancereporting@nhsbsa.nhs.uk and we shall contact you."]
["An IP that has NHS Employing Authority status MUST submit a fully completed 2023/24 Certificate to NHS Pensions before 31/05/2024.  An IP that ceased to be an EA on or before 31/03/2024 must submit a fully completed Certificate to NHS Pensions within two months of ceasing to be an EA."]
["All IPs must ALSO ensure that they have provided NHS Pensions with accurate individual member pension data no later than 31/05/2024. By this date, the member records must also be fully updated. If you have any issues updating member records, please contact datamanagement@nhsbsa.nhs.uk"]
["Part 1: Employing Authority Status"]
["1.1 Please confirm your NHSPS Independent Provider Employing Authority Code.  "]
["1.2 Please declare the date your organisation became an NHSPS IP Employing Authority.  "]
["Part 2: Contact details  "]
["2.1. Full name, business address and registered company number of the IP:     "]
["Name of Employer / Organisation: "]
["Address  "]
[]
[]
["Postcode"]
["Email Address "]
["Telephone"]
["Registered Company Number"]
["2.2. Full name and title of the IP's responsible officer (i.e. Chief Executive) "]
["Full Name"]
["Job Title"]
["Email Address "]
["Telephone"]
["Part 3: NHSPS access"]
["3.1 Please confirm access type (i.e.) ‘Closed’ or ‘Open’ when the IP first became an EA."]
["3.2 Please confirm the type of NHSPS access at 31/03/2024."]
["3.3 If the type of access changed between 01/04/2023 and 31/03/2024, please confirm date of change. "]
["If you have been awarded additional qualifying contracts that have not been approved for access then please contact the Scheme Access Team at schemeaccess@nhsbsa.nhs.uk."]
["Part 4: Number of staff, pay, and contributions"]
["4.1 Declare the total number of employed staff who were members of the NHSPS during 2023/24. This must balance to the total number of staff added to the Staff List tab."]
["4.2 Declare the total NHS pensionable earnings in 2023/24 for the staff stated at 4.1. This must balance to the Total Pensionable Pay (TPP) added to the Staff List tab."]
["4.3 Declare the total NHS Employee contributions payable in 2023/24 for the staff stated at 4.1. This must balance to column I of the Staff List tab. If not, please provide an explanation separately."]
["4.4 Declare the total NHSPS Employer contributions payable in 2023/24 for the staff stated at 4.1.  "]
["4.5 Declare the total NHSPS Added Years contributions payable in 2023/24 for the staff stated at 4.1.  "]
["4.6 Declare the total NHSPS Additional Pension contributions payable in 2023/24 for the staff stated in 4.1. "]
["4.7 Declare the total NHSPS Early Retirement Buy Out contributions payable in 2023/24 for the staff stated in 4.1. "]
["You must complete the Staff List tab within this workbook in full. Supply the information for each scheme member who contributed to the Scheme under your organisation in 2023/24."]
["Part 5: Employees not members"]
["5.1 Employees that met the more than 50% criteria but opted out or were not eligible NHSPS members in 2023/24.                                                                         "]
["5.2 Declare the total earnings in 2023/24 of the staff stated at 5.1                                                                        "]
["Part 6: Contribution expenditure"]
["6.1: Please enter all monthly periods in the table below on an accruals basis"]
["Contribution Month","Employer Contributions","Employee Contributions","Added Years (AVC)","Added Pension Purchase (AP)","Early Retirement Reduction Buy Out (ERRBO)","Total Contributions"]
["2023-04-01",null,null,null,null,null,{"$f":"SUM(B46:F46)","v":0}]
["2023-05-01",null,null,null,null,null,{"$f":"SUM(B47:F47)","v":0}]
["2023-06-01",null,null,null,null,null,0]
["2023-07-01",null,null,null,null,null,0]
["2023-08-01",null,null,null,null,null,0]
["2023-09-01",null,null,null,null,null,0]
["2023-10-01",null,null,null,null,null,0]
["2023-11-01",null,null,null,null,null,0]
["2023-12-01",null,null,null,null,null,0]
["2024-01-01",null,null,null,null,null,0]
["2024-02-01",null,null,null,null,null,0]
["2024-03-01",null,null,null,null,null,0]
["Total ",{"$f":"SUM(B46:B57)","v":0},0,0,0,0,0]
["Part 7: The 2023/24 pensionable earnings ceiling  "]
["7.1 Please insert the total value of contracts as an IP Employing Authority in 2023/24 (NHS Standard Sub Contracts, APMS, local authority contracts and Network Contract DES Sub-Contracts)."]
["7.2 Declare total earnings in 2023/24 that counts towards the pensionable earnings ceiling."]
["7.3 Check the calculated percentage: This is the pensionable earnings ceiling reached in 2023/24. Where the maximum 75% threshold has been exceeded, please provide the reasons why separately.",null,null,null,null,null,{"$f":"IF(G60=\"\",\"\",(G61/G60))","v":""}]
["Part 8: Introduction of Scheme Administration Levy"]
["As from 01/04/2017, all employers will pay an additional 0.08% in employer contributions per member to cover the administration costs of the Scheme."]
["9.1 I declare that this organisation has implemented the employer contributions rate increase and is paying the additional 0.08% for administration costs."]
["Part 9: Declaration"]
["• I declare that only staff who are to spend more than 50% of their basic working hours on approved qualifying contracts have joined the NHSPS. Where a dispute arises as to a person’s eligibility this organisation shall undertake an internal review and provide a written response to that person."]
["• I declare that this organisation shall co-operate in full with NHS Pensions and The Department of Health and Social Care including any ‘spot’ (i.e. audit) checks."]
["• I declare that I have read the Independent Provider Guidance material and other associated NHS Pension Scheme Guidance on the NHSBSA website for NHS Employing Authorities and I am aware of my legal responsibilities. "]
["• I declare that this organisation has and shall provide any information as requested (including this IP end of year certificate) to the NHSBSA in accordance with the statutory NHSPS Regulations and other overarching pension legislation, and pay over NHSPS contributions (of any type) by the required deadlines. "]
["• I declare that this organisation shall provide due notice to NHS Pensions if it elects to change from closed to open NHSPS access or vice versa.  \n"]
["• I declare that if this organisation elects to voluntarily withdraw from the NHSPS it shall provide six months written notice to its staff and NHS Pensions.  \n"]
["• I declare that this organisation shall, within two calendar months of the end of the NHSPS year, provide to the NHSBSA detailed information (including names and roles) of the staff that joined the NHSPS.\n"]
["• I declare that this organisation has provided a summary of those staff who satisfied the more than 50% criteria but who did not join the NHSPS."]
["• I declare that if the 75% pensionable earning ceiling has been exceeded the organisation shall pay the relevant levy in accordance with the NHSPS Regulations. "]
["• I declare that this organisation shall pay any relevant capitalisation cost in a one off payment where pensionable pay for a member of the 1995 section of the NHSPS increases significantly.  \n"]
["• I declare that where a NHSPS member has access to the NHSPS redundancy/compensation pension this is clearly stated on their contract of service; i.e. contract of employment."]
["• I declare that where an employee qualifies for the NHSPS redundancy/compensation pension the organisation shall pay all capitalisation costs prior to the pension being awarded and any further capitalisation costs arising from a change to the pension benefits.  "]
["• I declare that I have notified NHS Pensions of any contracts which have ended in year."]
["• I declare that all contribution payments are correct and a full breakdown of monthly payments is provided at Part 6."]
["• I declare that the membership NHSPS records have been updated for the Scheme year 2023/24 by 31/05/2024."]
["• I understand that if this organisation acts in breach of statutory pension legislation or fails to co-operate with the NHSBSA it may be expelled from the NHSPS and reported to regulatory bodies; i.e. The Pensions Regulator. "]
["• I declare that I have notified employees and NHS Pensions where this organisation no longer employs any person working more than 50% on the contract(s) shown."]
["Print name of the senior responsible officer:"]
["Date"]

{"sheet":"Staff List","index":2,"n_rows":1620,"n_cols":9,"rows_kept":1620,"cut":false,"hidden":false,"merged":[[1,0,1,8],[3,0,3,8]]}
[]
["NHSPS Members"]
[]
["Complete this list in full. Do not include staff who fall under New Fair Deal / Closed Direction or Determination "]
[]
["No.","Forename","Surname","NHSPS SD ref no. (eg: 81123456)","Job title ","Date NHSPS membership commenced","Actual NHS pensionable pay as at 31/03/2024                 £'s","Employee contribution rate as at 31/03/2024                    % (eg: 7.7 not 7.7%)","Total employee contributions paid £'s"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]
[1001]
[1002]
[1003]
[1004]
[1005]
[1006]
[1007]
[1008]
[1009]
[1010]
[1011]
[1012]
[1013]
[1014]
[1015]
[1016]
[1017]
[1018]
[1019]
[1020]
[1021]
[1022]
[1023]
[1024]
[1025]
[1026]
[1027]
[1028]
[1029]
[1030]
[1031]
[1032]
[1033]
[1034]
[1035]
[1036]
[1037]
[1038]
[1039]
[1040]
[1041]
[1042]
[1043]
[1044]
[1045]
[1046]
[1047]
[1048]
[1049]
[1050]
[1051]
[1052]
[1053]
[1054]
[1055]
[1056]
[1057]
[1058]
[1059]
[1060]
[1061]
[1062]
[1063]
[1064]
[1065]
[1066]
[1067]
[1068]
[1069]
[1070]
[1071]
[1072]
[1073]
[1074]
[1075]
[1076]
[1077]
[1078]
[1079]
[1080]
[1081]
[1082]
[1083]
[1084]
[1085]
[1086]
[1087]
[1088]
[1089]
[1090]
[1091]
[1092]
[1093]
[1094]
[1095]
[1096]
[1097]
[1098]
[1099]
[1100]
[1101]
[1102]
[1103]
[1104]
[1105]
[1106]
[1107]
[1108]
[1109]
[1110]
[1111]
[1112]
[1113]
[1114]
[1115]
[1116]
[1117]
[1118]
[1119]
[1120]
[1121]
[1122]
[1123]
[1124]
[1125]
[1126]
[1127]
[1128]
[1129]
[1130]
[1131]
[1132]
[1133]
[1134]
[1135]
[1136]
[1137]
[1138]
[1139]
[1140]
[1141]
[1142]
[1143]
[1144]
[1145]
[1146]
[1147]
[1148]
[1149]
[1150]
[1151]
[1152]
[1153]
[1154]
[1155]
[1156]
[1157]
[1158]
[1159]
[1160]
[1161]
[1162]
[1163]
[1164]
[1165]
[1166]
[1167]
[1168]
[1169]
[1170]
[1171]
[1172]
[1173]
[1174]
[1175]
[1176]
[1177]
[1178]
[1179]
[1180]
[1181]
[1182]
[1183]
[1184]
[1185]
[1186]
[1187]
[1188]
[1189]
[1190]
[1191]
[1192]
[1193]
[1194]
[1195]
[1196]
[1197]
[1198]
[1199]
[1200]
[1201]
[1202]
[1203]
[1204]
[1205]
[1206]
[1207]
[1208]
[1209]
[1210]
[1211]
[1212]
[1213]
[1214]
[1215]
[1216]
[1217]
[1218]
[1219]
[1220]
[1221]
[1222]
[1223]
[1224]
[1225]
[1226]
[1227]
[1228]
[1229]
[1230]
[1231]
[1232]
[1233]
[1234]
[1235]
[1236]
[1237]
[1238]
[1239]
[1240]
[1241]
[1242]
[1243]
[1244]
[1245]
[1246]
[1247]
[1248]
[1249]
[1250]
[1251]
[1252]
[1253]
[1254]
[1255]
[1256]
[1257]
[1258]
[1259]
[1260]
[1261]
[1262]
[1263]
[1264]
[1265]
[1266]
[1267]
[1268]
[1269]
[1270]
[1271]
[1272]
[1273]
[1274]
[1275]
[1276]
[1277]
[1278]
[1279]
[1280]
[1281]
[1282]
[1283]
[1284]
[1285]
[1286]
[1287]
[1288]
[1289]
[1290]
[1291]
[1292]
[1293]
[1294]
[1295]
[1296]
[1297]
[1298]
[1299]
[1300]
[1301]
[1302]
[1303]
[1304]
[1305]
[1306]
[1307]
[1308]
[1309]
[1310]
[1311]
[1312]
[1313]
[1314]
[1315]
[1316]
[1317]
[1318]
[1319]
[1320]
[1321]
[1322]
[1323]
[1324]
[1325]
[1326]
[1327]
[1328]
[1329]
[1330]
[1331]
[1332]
[1333]
[1334]
[1335]
[1336]
[1337]
[1338]
[1339]
[1340]
[1341]
[1342]
[1343]
[1344]
[1345]
[1346]
[1347]
[1348]
[1349]
[1350]
[1351]
[1352]
[1353]
[1354]
[1355]
[1356]
[1357]
[1358]
[1359]
[1360]
[1361]
[1362]
[1363]
[1364]
[1365]
[1366]
[1367]
[1368]
[1369]
[1370]
[1371]
[1372]
[1373]
[1374]
[1375]
[1376]
[1377]
[1378]
[1379]
[1380]
[1381]
[1382]
[1383]
[1384]
[1385]
[1386]
[1387]
[1388]
[1389]
[1390]
[1391]
[1392]
[1393]
[1394]
[1395]
[1396]
[1397]
[1398]
[1399]
[1400]
[1401]
[1402]
[1403]
[1404]
[1405]
[1406]
[1407]
[1408]
[1409]
[1410]
[1411]
[1412]
[1413]
[1414]
[1415]
[1416]
[1417]
[1418]
[1419]
[1420]
[1421]
[1422]
[1423]
[1424]
[1425]
[1426]
[1427]
[1428]
[1429]
[1430]
[1431]
[1432]
[1433]
[1434]
[1435]
[1436]
[1437]
[1438]
[1439]
[1440]
[1441]
[1442]
[1443]
[1444]
[1445]
[1446]
[1447]
[1448]
[1449]
[1450]
[1451]
[1452]
[1453]
[1454]
[1455]
[1456]
[1457]
[1458]
[1459]
[1460]
[1461]
[1462]
[1463]
[1464]
[1465]
[1466]
[1467]
[1468]
[1469]
[1470]
[1471]
[1472]
[1473]
[1474]
[1475]
[1476]
[1477]
[1478]
[1479]
[1480]
[1481]
[1482]
[1483]
[1484]
[1485]
[1486]
[1487]
[1488]
[1489]
[1490]
[1491]
[1492]
[1493]
[1494]
[1495]
[1496]
[1497]
[1498]
[1499]
[1500]
[1501]
[1502]
[1503]
[1504]
[1505]
[1506]
[1507]
[1508]
[1509]
[1510]
[1511]
[1512]
[1513]
[1514]
[1515]
[1516]
[1517]
[1518]
[1519]
[1520]
[1521]
[1522]
[1523]
[1524]
[1525]
[1526]
[1527]
[1528]
[1529]
[1530]
[1531]
[1532]
[1533]
[1534]
[1535]
[1536]
[1537]
[1538]
[1539]
[1540]
[1541]
[1542]
[1543]
[1544]
[1545]
[1546]
[1547]
[1548]
[1549]
[1550]
[1551]
[1552]
[1553]
[1554]
[1555]
[1556]
[1557]
[1558]
[1559]
[1560]
[1561]
[1562]
[1563]
[1564]
[1565]
[1566]
[1567]
[1568]
[1569]
[1570]
[1571]
[1572]
[1573]
[1574]
[1575]
[1576]
[1577]
[1578]
[1579]
[1580]
[1581]
[1582]
[1583]
[1584]
[1585]
[1586]
[1587]
[1588]
[1589]
[1590]
[1591]
[1592]
[1593]
[1594]
[1595]
[1596]
[1597]
[1598]
[1599]
[1600]
[1601]
[1602]
[1603]
[1604]
[1605]
[1606]
[1607]
[1608]
[1609]
[1610]
[1611]
[1612]
[1613]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I7:I506)","v":0}]

{"sheet":"NHS Pensions Only","index":3,"n_rows":56,"n_cols":95,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["End_Of_Year_certificate","1.1 EA code ref","1.2 IP Date","2_1Name_of_Employer__Organisation_","2_1Address1","2_1Address2","2_1Address3","2_1Postcode","2_1Email_Address","2_1Telephone","2_1Registered_Company_Number","2_2Full_Name","2_2Job_Title","2_2Email_Address_","2_2Telephone","3.1 type of access at start","3_2_level_of_NHSPS_access_at_31_March_2019","3_3_level_changed_date","4.1 total__number_of_employed_staff","4.2 total_pensionable_earnings_for_the_staff_stated_at_5_1","4.3 total_conts_payable_for_the_staff_stated_at_5_1","4.4 total_NHSPS_employer_contributions","4.5 total_NHSPS_added_years_contributions_payable_","4.6 total_NHSPS_additional_pension_contributions_","4.7 total_NHSPS_ERRBO","5.1 Emp_more_than_50%_criteria","5.2 total_of_staff_at_6_1","2401_ER","2402_ER","2403_ER","2404_ER","2405_ER","2406_ER","2407_ER","2408_ER","2409_ER","2410_ER","2411_ER","2412_ER","2401_EE","2402_EE","2403_EE","2404_EE","2405_EE","2406_EE","2407_EE","2408_EE","2409_EE","2410_EE","2411_EE","2412_EE","2401_AV","2402AV","2403AV","2404_AV","2405_AV","2406_AV","2407_AV","2408_AV","2409_AV","2410_AV","2411_AV","2412_AV","2401_AP","2402_AP","2403_AP","2404_AP","2405_AP","2406_AP","2407_AP","2408_AP","2409_AP","2410_AP","2411_AP","2412_AP","2401_ERRBO","2402_ERRBO","2403_ERRBO","2404_ERRBO","2405_ERRBO","2406_ERRBO","2407_ERRBO","2408_ERRBO","2409_ERRBO","2410_ERRBO","2411_ERRBO","2412_ERRBO","7_1_Value_of_contracts","7_2_Declare_pensionable_earnings","7_3_75%_Threshold","8_1_Guarantee_Amount_1_","8_1_Guarantee_Amount_2","8_1_14_38%_Admin_Levy_","9_0_declaration_name","9_0_declaration_date"]
[null,{"$f":"IF('End of Year Cert 23-24'!$F$9=\"\",\"\",'End of Year Cert 23-24'!$F$9)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$10=\"\",\"\",'End of Year Cert 23-24'!$F$10)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$13=\"\",\"\",'End of Year Cert 23-24'!$C$13)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$14=\"\",\"\",'End of Year Cert 23-24'!$C$14)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$15=\"\",\"\",'End of Year Cert 23-24'!$C$15)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$16=\"\",\"\",'End of Year Cert 23-24'!$C$16)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$17=\"\",\"\",'End of Year Cert 23-24'!$C$17)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$18=\"\",\"\",'End of Year Cert 23-24'!$C$18)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$19=\"\",\"\",'End of Year Cert 23-24'!$C$19)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$20=\"\",\"\",'End of Year Cert 23-24'!$C$20)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$22=\"\",\"\",'End of Year Cert 23-24'!$C$22)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$23=\"\",\"\",'End of Year Cert 23-24'!$C$23)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$24=\"\",\"\",'End of Year Cert 23-24'!$C$24)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$25=\"\",\"\",'End of Year Cert 23-24'!$C$25)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$27=\"\",\"\",'End of Year Cert 23-24'!$G$27)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$28=\"\",\"\",'End of Year Cert 23-24'!$G$28)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$29=\"\",\"\",'End of Year Cert 23-24'!$G$29)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$32=\"\",\"\",'End of Year Cert 23-24'!$G$32)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$33=\"\",\"\",'End of Year Cert 23-24'!$G$33)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$34=\"\",\"\",'End of Year Cert 23-24'!$G$34)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$35=\"\",\"\",'End of Year Cert 23-24'!$G$35)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$36=\"\",\"\",'End of Year Cert 23-24'!$G$36)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$37=\"\",\"\",'End of Year Cert 23-24'!$G$37)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$38=\"\",\"\",'End of Year Cert 23-24'!$G$38)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$41=\"\",\"\",'End of Year Cert 23-24'!$G$41)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$42=\"\",\"\",'End of Year Cert 23-24'!$G$42)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$46=\"\",\"\",'End of Year Cert 23-24'!$B$46)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$47=\"\",\"\",'End of Year Cert 23-24'!$B$47)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$48=\"\",\"\",'End of Year Cert 23-24'!$B$48)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$49=\"\",\"\",'End of Year Cert 23-24'!$B$49)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$50=\"\",\"\",'End of Year Cert 23-24'!$B$50)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$51=\"\",\"\",'End of Year Cert 23-24'!$B$51)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$52=\"\",\"\",'End of Year Cert 23-24'!$B$52)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$53=\"\",\"\",'End of Year Cert 23-24'!$B$53)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$54=\"\",\"\",'End of Year Cert 23-24'!$B$54)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$55=\"\",\"\",'End of Year Cert 23-24'!$B$55)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$56=\"\",\"\",'End of Year Cert 23-24'!$B$56)","v":""},{"$f":"IF('End of Year Cert 23-24'!$B$57=\"\",\"\",'End of Year Cert 23-24'!$B$57)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$46=\"\",\"\",'End of Year Cert 23-24'!$C$46)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$47=\"\",\"\",'End of Year Cert 23-24'!$C$47)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$48=\"\",\"\",'End of Year Cert 23-24'!$C$48)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$49=\"\",\"\",'End of Year Cert 23-24'!$C$49)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$50=\"\",\"\",'End of Year Cert 23-24'!$C$50)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$51=\"\",\"\",'End of Year Cert 23-24'!$C$51)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$52=\"\",\"\",'End of Year Cert 23-24'!$C$52)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$53=\"\",\"\",'End of Year Cert 23-24'!$C$53)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$54=\"\",\"\",'End of Year Cert 23-24'!$C$54)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$55=\"\",\"\",'End of Year Cert 23-24'!$C$55)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$56=\"\",\"\",'End of Year Cert 23-24'!$C$56)","v":""},{"$f":"IF('End of Year Cert 23-24'!$C$57=\"\",\"\",'End of Year Cert 23-24'!$C$57)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$46=\"\",\"\",'End of Year Cert 23-24'!$D$46)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$47=\"\",\"\",'End of Year Cert 23-24'!$D$47)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$48=\"\",\"\",'End of Year Cert 23-24'!$D$48)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$49=\"\",\"\",'End of Year Cert 23-24'!$D$49)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$50=\"\",\"\",'End of Year Cert 23-24'!$D$50)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$51=\"\",\"\",'End of Year Cert 23-24'!$D$51)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$52=\"\",\"\",'End of Year Cert 23-24'!$D$52)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$53=\"\",\"\",'End of Year Cert 23-24'!$D$53)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$54=\"\",\"\",'End of Year Cert 23-24'!$D$54)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$55=\"\",\"\",'End of Year Cert 23-24'!$D$55)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$56=\"\",\"\",'End of Year Cert 23-24'!$D$56)","v":""},{"$f":"IF('End of Year Cert 23-24'!$D$57=\"\",\"\",'End of Year Cert 23-24'!$D$57)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$46=\"\",\"\",'End of Year Cert 23-24'!$E$46)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$47=\"\",\"\",'End of Year Cert 23-24'!$E$47)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$48=\"\",\"\",'End of Year Cert 23-24'!$E$48)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$49=\"\",\"\",'End of Year Cert 23-24'!$E$49)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$50=\"\",\"\",'End of Year Cert 23-24'!$E$50)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$51=\"\",\"\",'End of Year Cert 23-24'!$E$51)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$52=\"\",\"\",'End of Year Cert 23-24'!$E$52)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$53=\"\",\"\",'End of Year Cert 23-24'!$E$53)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$54=\"\",\"\",'End of Year Cert 23-24'!$E$54)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$55=\"\",\"\",'End of Year Cert 23-24'!$E$55)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$56=\"\",\"\",'End of Year Cert 23-24'!$E$56)","v":""},{"$f":"IF('End of Year Cert 23-24'!$E$57=\"\",\"\",'End of Year Cert 23-24'!$E$57)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$46=\"\",\"\",'End of Year Cert 23-24'!$F$46)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$47=\"\",\"\",'End of Year Cert 23-24'!$F$47)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$48=\"\",\"\",'End of Year Cert 23-24'!$F$48)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$49=\"\",\"\",'End of Year Cert 23-24'!$F$49)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$50=\"\",\"\",'End of Year Cert 23-24'!$F$50)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$51=\"\",\"\",'End of Year Cert 23-24'!$F$51)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$52=\"\",\"\",'End of Year Cert 23-24'!$F$52)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$53=\"\",\"\",'End of Year Cert 23-24'!$F$53)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$54=\"\",\"\",'End of Year Cert 23-24'!$F$54)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$55=\"\",\"\",'End of Year Cert 23-24'!$F$55)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$56=\"\",\"\",'End of Year Cert 23-24'!$F$56)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$57=\"\",\"\",'End of Year Cert 23-24'!$F$57)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$60=\"\",\"\",'End of Year Cert 23-24'!$G$60)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$61=\"\",\"\",'End of Year Cert 23-24'!$G$61)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$62=\"\",\"\",'End of Year Cert 23-24'!$G$62)","v":""},null,null,{"$f":"IF('End of Year Cert 23-24'!$G$65=\"\",\"\",'End of Year Cert 23-24'!$G$65)","v":""},{"$f":"IF('End of Year Cert 23-24'!$F$84=\"\",\"\",'End of Year Cert 23-24'!$F$84)","v":""},{"$f":"IF('End of Year Cert 23-24'!$G$85=\"\",\"\",'End of Year Cert 23-24'!$G$85)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Yes"]
[null,null,null,"No"]