{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Basic Details New Members","Basic Details Existing Members","Service History Crib Sheet","Service History","Salary Details","Pay History","Home Address","Office Address","Pensionable Bonus","Pensionable Allowance","Part Time Hours","Short Time Hours","Short Time Hours (accum)","WPS Rate History","AVC History","Beneficiary Details","Event Details","Other Benefits","Remarks","Contribution Rate","Allowance Codes","Bonus Codes","Grade Codes","Validation Report","Valid Pick Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":22,"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":"Basic Details New Members","index":0,"n_rows":1,"n_cols":32,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Surname","Name1","Name2","Name3","Title","Sex","Marital Status","Date of Birth","Ill Health Exlcusion","Other Name","Spouse Date of Birth","NRD Override","Employer","Paypoint","Location","Age Evidence","Decoration","Date marriage ceased","Bank Sort Code","A/C Number","Date first joined CS","Account Type","Multiple Appt Ind","Contractual Rtmt Date","Bldg Soc Roll No","Cabinet Office Approval Ind","EPA Restart Ind","EPA Restart Date","Error Message"]

{"sheet":"Basic Details Existing Members","index":1,"n_rows":1,"n_cols":32,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Surname","Name1","Name2","Name3","Title","Sex","Marital Status","Date of Birth","Ill Health Exlcusion","Other Name","Spouse Date of Birth","NRD Override Date","Employer","Paypoint","Location","Age Evidence","Decoration","Date marriage ceased","Bank Sort Code","A/C Number","Date first joined CS","Account Type","Multiple Appt Ind","Contractual Rtmt Date","Bldg Soc Roll No","Cabinet Office Approval Ind","EPA Restart Ind","EPA Restart Date","Error Message"]

{"sheet":"Service History Crib Sheet","index":2,"n_rows":158,"n_cols":23,"rows_kept":158,"cut":false,"hidden":false,"merged":[]}
["Absence Type","Compendia Start Reason","Scheme ","Scheme Category","Status"]
["Start of break Opted Out (Unknown break reason)","B","PCS","N","BO"]
["Start of break (Unknown reason)","B","PCS","N","B"]
["Unpaid absence (Industrial Action - Classic) ","BIA","PCS","N","B"]
["Unpaid absence (Industrial Action - Premium) ","BIA","PCS","N","B"]
["Unpaid absence (Industrial Action - Nuvos)","BIA","PCS","N","B"]
["Unpaid absence (Industrial Action - Partnership - Scottish Widows)","BIA","PCS","N1","BS"]
["Unpaid absence (Industrial Action - Partnership - Standard Life)","BIA","PCS","N2","BS"]
["Unpaid absence (Industrial Action - Partnership - AMP/NPI)","BIA","PCS","N3","BS"]
["Unpaid absence (Industrial Action - Partnership - Prudential)","BIA","PCS","N4","BS"]
["Unauthorised absence (Unpaid - Classic)","BUA","PCS","N","B"]
["Unauthorised absence (Unpaid - Premium)","BUA","PCS","N","B"]
["Unauthorised absence (Unpaid - Nuvos)","BUA","PCS","N","B"]
["Unauthorised absence (Unpaid - Partnership - Scottish Widows)","BUA","PCS","N1","BS"]
["Unauthorised absence (Unpaid - Partnership - Standard Life)","BUA","PCS","N2","BS"]
["Unauthorised absence (Unpaid - Partnership - AMP/NPI)","BUA","PCS","N3","BS"]
["Unauthorised absence (Unpaid - Partnership - Prudential)","BUA","PCS","N4","BS"]
["Change of circumstances (Classic)","C","PCS","P","A"]
["Change of circumstances (Premium)","C","PCS","P2","A"]
["Change of circumstances (Nuvos)","C","PCS","C","A"]
["Change of circumstances (Partnership - Scottish Widows)","C","PCS","S1","AS"]
["Change of circumstances (Partnership - Standard Life)","C","PCS","S2","AS"]
["Change of circumstances (Partnership - AMP/NPI)","C","PCS","S3","AS"]
["Change of circumstances (Partnership - Prudential)","C","PCS","S4","AS"]
["Special leave without pay (Classic)","LN","PCS","Q","B"]
["Special leave without pay (Premium)","LN","PCS","Q","B"]
["Special leave without pay (Nuvos)","LN","PCS","Q","B"]
["Special leave without pay (Partnership - Scottish Widows)","LN","PCS","Q1","BS"]
["Special leave without pay (Partnership - Standard Life)","LN","PCS","Q2","BS"]
["Special leave without pay (Partnership - AMP/NPI)","LN","PCS","Q3","BS"]
["Special leave without pay (Partnership - Prudential)","LN","PCS","Q4","BS"]
["Maternity/Shared Parental leave (Full Pay - Classic)","MF","PCS","P","A"]
["Maternity/Shared Parental leave (Full Pay - Premium)","MF","PCS","P2","A"]
["Maternity/Shared Parental leave (Full Pay - Nuvos)","MF","PCS","C","A"]
["Maternity/Shared Parental leave (Full Pay - Partnership - Scottish Widows)","MF","PCS","S1","AS"]
["Maternity/Shared Parental leave (Full Pay - Partnership - Standard Life)","MF","PCS","S2","AS"]
["Maternity/Shared Parental leave (Full Pay - Partnership - AMP/NPI)","MF","PCS","S3","AS"]
["Maternity/Shared Parental leave (Full Pay - Partnership - Prudential)","MF","PCS","S4","AS"]
["Maternity/Shared Parental leave (Unpaid - Classic)","MN","PCS","Q","B"]
["Maternity/Shared Parental leave (Unpaid - Premium)","MN","PCS","Q","B"]
["Maternity/Shared Parental leave (Unpaid - Nuvos)","MN","PCS","Q","B"]
["Maternity/Shared Parental leave (Unpaid - Partnership - Scottish Widows)","MN","PCS","Q1","BS"]
["Maternity/Shared Parental leave (Unpaid - Partnership - Standard Life)","MN","PCS","Q2","BS"]
["Maternity/Shared Parental leave (Unpaid - Partnership - AMP/NPI)","MN","PCS","Q3","BS"]
["Maternity/Shared Parental leave (Unpaid - Partnership - Prudential)","MN","PCS","Q4","BS"]
["Maternity/Shared Parental leave (Statutory Maternity/Shared Parental Pay - Classic)","MS","PCS","P","A"]
["Maternity/Shared Parental leave (Statutory Maternity/Shared Parental Pay - Premium)","MS","PCS","P2","A"]
["Maternity/Shared Parental leave (Statutory Maternity/Shared Parental Pay - Nuvos)","MS","PCS","C","A"]
["Maternity/Shared Parental leave (Statutory Maternity/Shared Parental Pay - Partnership - Scottish Widows)","MS","PCS","S1","AS"]
["Maternity/Shared Parental leave (Statutory Maternity/Shared Parental Pay - Partnership - Standard Life)","MS","PCS","S2","AS"]
["Maternity/Shared Parental leave (Statutory Maternity/Shared Parental Pay -  Partnership - AMP/NPI)","MS","PCS","S3","AS"]
["Maternity/Shared Parental leave (Statutory Maternity/Shared Parental Pay - Partnership - Prudential)","MS","PCS","S4","AS"]
["New joiner - Casual Service (Classic)","N","PCS","P","C"]
["New joiner - Casual Service (Premium)","N","PCS","P2","C"]
["New joiner - Casual Service (Nuvos)","N","PCS","C","C"]
["New joiner - Casual Service (Partnership - Scottish Widows)","N","PCS","S1","CS"]
["New joiner - Casual Service (Partnership - Standard Life)","N","PCS","S2","CS"]
["New joiner - Casual Service (Partnership - AMP/NPI)","N","PCS","S3","CS"]
["New joiner - Casual Service (Partnership - Prudential)","N","PCS","S4","CS"]
["New joiner - Fixed term appointment (Classic)","N","PCS","P","F"]
["New joiner - Fixed term appointment (Premium)","N","PCS","P2","F"]
["New joiner - Fixed term appointment (Nuvos)","N","PCS","C","F"]
["New joiner - Fixed term appointment (Partnership - Scottish Widows)","N","PCS","S1","FS"]
["New joiner - Fixed term appointment (Partnership - Standard Life)","N","PCS","S2","FS"]
["New joiner - Fixed term appointment (Partnership - AMP/NPI)","N","PCS","S3","FS"]
["New joiner - Fixed term appointment (Partnership - Prudential)","N","PCS","S4","FS"]
["New joiner (Classic)","N","PCS","P","A"]
["New joiner (Premium)","N","PCS","P2","A"]
["New joiner (Nuvos)","N","PCS","C","A"]
["New joiner (Partnership - Scottish Widows)","N","PCS","S1","AS"]
["New joiner (Partnership - Standard Life)","N","PCS","S2","AS"]
["New joiner (Partnership - AMP/NPI)","N","PCS","S3","AS"]
["New joiner (Partnership - Prudential)","N","PCS","S4","AS"]
["Opting in (Classic)","OI","PCS","P","A"]
["Opting in (Premium)","OI","PCS","P2","A"]
["Opting in (Nuvos)","OI","PCS","C","A"]
["Opting in (Partnership - Scottish Widows)","OI","PCS","S1","AS"]
["Opting in (Partnership - Standard Life)","OI","PCS","S2","AS"]
["Opting in (Partnership - AMP/NPI)","OI","PCS","S3","AS"]
["Opting in (Partnership - Prudential)","OI","PCS","S4","AS"]
["Opting out","OO","PCS","N","AO"]
["Return from break (Classic)","RB","PCS","P","A"]
["Return from break (Premium)","RB","PCS","P2","A"]
["Return from break (Nuvos)","RB","PCS","C","A"]
["Return from break (Partnership - Scottish Widows)","RB","PCS","S1","AS"]
["Return from break (Partnership - Standard Life)","RB","PCS","S2","AS"]
["Return from break (Partnership - AMP/NPI)","RB","PCS","S3","AS"]
["Return from break (Partnership - Prudential)","RB","PCS","S4","AS"]
["Sick leave (Half Pay - Classic)","SH","PCS","P","H"]
["Sick leave (Half Pay - Premium)","SH","PCS","P2","H"]
["Sick leave (Half Pay - Nuvos)","SH","PCS","C","H"]
["Sick leave (Half Pay - Partnership - Scottish Widows)","SH","PCS","S1","HS"]
["Sick leave (Half Pay - Partnership - Standard Life)","SH","PCS","S2","HS"]
["Sick leave (Half Pay - Partnership - AMP/NPI)","SH","PCS","S3","HS"]
["Sick leave (Half Pay - Partnership - Prudential)","SH","PCS","S4","HS"]
["Sick leave (Half Pay - Opted Out)","SH","PCS","N","HO"]
["Sick leave (Unpaid)","SN","PCS","QS","B"]
["Transfer to Partnership Scheme - Scottish Widows","TS","PCS","S1","AS"]
["Transfer to Partnership Scheme - Standard Life","TS","PCS","S2","AS"]
["Transfer to Partnership Scheme - AMP/NPI","TS","PCS","S3","AS"]
["Transfer to Partnership Scheme - Prudential","TS","PCS","S4","AS"]
["Unpaid leave (Classic)","VN","PCS","Q","B"]
["Unpaid leave (Premium)","VN","PCS","Q","B"]
["Unpaid leave (Nuvos)","VN","PCS","Q","B"]
["Unpaid leave (Partnership - Scottish Widows)","VN","PCS","Q1","B"]
["Unpaid leave (Partnership - Standard Life)","VN","PCS","Q2","B"]
["Unpaid leave (Partnership - AMP/NPI)","VN","PCS","Q3","B"]
["Unpaid leave (Partnership - Prudential)","VN","PCS","Q4","B"]
["Suspension without pay (Classic)","XN","PCS","Q","B"]
["Suspension without pay (Premium)","XN","PCS","Q","B"]
["Suspension without pay (Nuvos)","XN","PCS","Q","B"]
["Suspension without pay (Partnership - Scottish Widows)","XN","PCS","Q1","B"]
["Suspension without pay (Partnership - Standard Life)","XN","PCS","Q2","B"]
["Suspension without pay (Partnership - AMP/NPI)","XN","PCS","Q3","B"]
["Suspension without pay (Partnership - Prudential)","XN","PCS","Q4","B"]
["Adoption Leave (Full Pay - alpha)","AF","CSO","A","A"]
["Start of break (Unpaid break Opted Out)","B","CSO","N","BO"]
["Unpaid absence (Industrial Action - alpha)","BIA","CSO","N","B"]
["Unauthorised absence (Unpaid - alpha)","BUA","CSO","N","B"]
["Change of circumstances (alpha)","C","CSO","A","A"]
["Special leave without pay (alpha)","LN","CSO","Q","B"]
["Maternity/Shared Parental leave (Full Pay - alpha)","MF","CSO","A","A"]
["Maternity/Shared Parental leave (Unpaid - alpha)","MN","CSO","Q","B"]
["Maternity/Shared Parental leave (Statutory Maternity/Shared Parental Pay - alpha)","MS","CSO","A","A"]
["Casual Service (alpha)","N","CSO","A","C"]
["Fixed term appointment (alpha)","N","CSO","A","F"]
["New joiner (alpha)","N","CSO","A","A"]
["Opting in (alpha)","OI","CSO","A","A"]
["Opting out","OO","CSO","N","AO"]
["Paternity Leave (Full Pay – alpha)","PF","CSO","A","A"]
["Return from break (alpha)","RB","CSO","A","A"]
["Sick leave (Half Pay - alpha)","SH","CSO","A","H"]
["Sick leave (Unpaid alpha)","SN","CSO","QS","B"]
["Sick leave (Unpaid No SSP - alpha)","SNN","CSO","QS","B"]
["Sick leave (Unpaid SSP - alpha)","SNS","CSO","QS","B"]
["Sick leave (Pension Rate - alpha)","SP","CSO","QS","B"]
["Sick leave (Pension Rate No SSP - alpha)","SPN","CSO","QS","B"]
["Sick leave (Pension Rate SSP Paid - alpha)","SPS","CSO","QS","B"]
["Transition to Alpha","T","CSO","A","A"]
["Transition to Alpha (for optant out)","T","CSO","N","AO"]
["Transition to Alpha (for Casual Service)","T","CSO","A","C"]
["Transition to Alpha (for fixed term appointment)","T","CSO","A","F"]
["Transition to Alpha (Non reckonable qualifying - alpha)","T","CSO","Q","B"]
["Transition to Alpha (Non reckonable non qualifying - alpha)","T","CSO","N","B"]
["Transition to Alpha (Unpaid Break (Opted Out) - alpha)","T","CSO","N","BO"]
["Transition to Alpha (Sick leave (Half Pay) - alpha)","T","CSO","A","H"]
["Transition to Alpha (Sick leave unpaid - alpha)","T","CSO","QS","B"]
["Unpaid leave (alpha)","VN","CSO","Q","B"]
["Suspension without pay (alpha)","XN","CSO","Q","B"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AC4:AC156))","v":45}]

{"sheet":"Service History","index":3,"n_rows":195,"n_cols":27,"rows_kept":195,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Start Date","Start Reason","End Date","End Reason","Scheme","Scheme Category","Status","Employer","Assumed Pay Code","EPA Suspension Code","AP Suspension Code","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,{"$f":"198-(COUNTBLANK(AG2:AG193))","v":6}]

{"sheet":"Salary Details","index":4,"n_rows":188,"n_cols":25,"rows_kept":188,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Salary Start Date ","Employer","Paypoint","Notional Pay","Contract","End Date ","Substantive Grade","Salary / Wage Flag","Actual Pay","Actual London Weighting","Actual Mark Time"," Actual Reduced Pay","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AE2:AE186))","v":13}]

{"sheet":"Pay History","index":5,"n_rows":1,"n_cols":33,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number ","Altkey","Start Date","Period Number","End Date","Employer","Paypoint","NI Category","Total CO Earnings ","WPS Contributions","Added Years Contributions","Money Purchase Conts","Scheme","GNI Conts","Cat'y E CO Earnings","Added Years Family Benefit Conts","Pre 78/88 WPS Conts","Scheme Conts","Employer Conts (P'ship)","Employee Conts (P'ship)","Earnings","Added Pension AVCs","Added Pension AVC (Member Only)","Added Pensions AVC - alpha","Added Pensions AVC - alpha (Member only)","EPA AVC","Filler1","Filler2","Filler3","EPA Employee Contribution Rate ","Filler4","Error Message"]

{"sheet":"Home Address","index":6,"n_rows":190,"n_cols":24,"rows_kept":190,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number ","Altkey","Address Line 1","Address Line 2","Address Line 3","Address Line 4","AddressLine 5","Postcode","Country","Addressee Name","Tel No 1","Tel No 2","Effective Date","Mail Sort Code","Email Address","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AD2:AD188))","v":11}]

{"sheet":"Office Address","index":7,"n_rows":202,"n_cols":24,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number ","Altkey","Address Line 1","Address Line 2","Address Line 3","Address Line 4","AddressLine 5","Postcode","Country","Addressee Name","Tel No 1","Tel No 2","Effective Date","Mail Sort Code","Email Address","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AD3:AD200))","v":0}]

{"sheet":"Pensionable Bonus","index":8,"n_rows":202,"n_cols":24,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Effective date ","Paypoint","Bonus Code","Employer","Amount","Pensionable Flag","Industrial Flag","Pre 75 Reckonable","Basic Pay Reckonable","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AD3:AD200))","v":0}]

{"sheet":"Pensionable Allowance","index":9,"n_rows":202,"n_cols":26,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Start Date","Paypoint","Employer","Allowance Code","Pensionable Flag","End Date","Allowance Rate","Industrial Flag","Pre 75 Reckonable","Basic Pay Reckonable","% Shift Allowance","Actual Rate of Allowance","Reduced Notional Rate","Reduced Actual Rate","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,{"$f":"198-(COUNTBLANK(AF3:AF200))","v":0}]

{"sheet":"Part Time Hours","index":10,"n_rows":201,"n_cols":24,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Start Date","Employer","End Date","Part-time hours","Full-time hours","Hours type","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AD2:AD199))","v":0}]

{"sheet":"Short Time Hours","index":11,"n_rows":201,"n_cols":24,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Effective Date ","Hours variation ","Employer","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AD2:AD199))","v":0}]

{"sheet":"Short Time Hours (accum)","index":12,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Start Date ","End Date","Hours variation ","Employer","Error Message"]

{"sheet":"WPS Rate History","index":13,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Start Date ","Percent","End Date","Error Message"]

{"sheet":"AVC History","index":14,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","AVC Provider Code","Start Date ","Contract Start Date ","Scheme","Employee's AVC Conts","Employer's AVC Conts","Employee's AVC %","Employer's AVC %","Contract Cont Rate","Contribution Frequency","AVC Membership Number","Fund Value","Valuation Date","AVC Conts End Date","End Reason","Extra Life Cover","Claim Date","Claim Code","Added Years","Family Benefits Indicator","Family Benefits %","Immediate Pension","Error Message"]

{"sheet":"Beneficiary Details","index":15,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Title","Surname","Forename1","Forename2","Forename3","Payee Information","Sex","Date of Birth","(Beneficiary) NI Number","Name Code","Nomination Date","Decoration","Other Name","Error Message"]

{"sheet":"Event Details","index":16,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Event Date","Type","Action Date","Code","Description","Amount","Error Message"]

{"sheet":"Other Benefits","index":17,"n_rows":202,"n_cols":36,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Scheme","Benefit Type","Transfer Ind","Service Start Date","End Date","Qualifying Service","Added Service","Pension","Date Received","Transfer Source","Amount Received","Employee Conts Included","Pre 6/4/75 Employee Conts","Post 6/4/88 Employee Conts","Inland Revenue Cash","Inland Revenue Remuneration","Paid up Sum Assured","EPB Included","Payment in lieu","Final Salary Pension","Post 85 Pension","Deferred Cash","Post 97 Tfr Value","Post 97 Period","Post 97 Fxd Pension","Post 97 Cash","Inc. Divorce","NI Mod exempt","Family Benefit flag","Uncapped Transfer","Amount for Family Benefit","Deemed Date","Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AD3:AD200))","v":0}]

{"sheet":"Remarks","index":18,"n_rows":202,"n_cols":24,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Remark No","Usage","Remark",null,null,null,"Error Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"198-(COUNTBLANK(AD3:AD200))","v":0}]

{"sheet":"Contribution Rate","index":19,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","NI Number","Altkey","Start Date ","Percent","Error Message"]

{"sheet":"Allowance Codes","index":20,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Code","Description","Pensionable Indicator","Spread Bonus Indicator","Industrial Indicator","Basic Pay Reckonable Indicator","Basic Pay Reckonable Indicator"]

{"sheet":"Bonus Codes","index":21,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Code","Description","Pensionable Flag","Industrial Flag","Basic Pay Indicator","Pre 75 Basic Indicator "]

{"sheet":"Grade Codes","index":22,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Code","Description","Uniformed Grade","Industrial Flag"]

{"sheet":"Validation Report","index":23,"n_rows":50,"n_cols":70,"rows_kept":50,"cut":false,"hidden":false,"merged":[[37,69,37,70],[27,1,27,2],[30,5,31,6],[33,5,34,6],[36,69,36,70]]}
["Sheet Name","Basic Details New Members","Basic Details Existing Members","Service History","Salary Details","Pay History","Home Address","Office Address","Pensionable Bonus","Pensionable Allowance","Part Time Hours","Short Time Hours","Short Time Hours (accum)","WPS Rate History","AVC History","Beneficiary Details","Event Details","Other Benefits","Remarks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
["Madatory Fields","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ","NI Number, ",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,{"$f":"IF(AS2 > 0,'Validation Report'!B22 & AR2,\" \")","v":" "},{"$f":"IF(AZ2 > 0,'Validation Report'!B23 & AY2,\" \")","v":" "}]
[null,"Payroll Number, ",null,"Start Date, ","Salary Start Date, ","Start Date, ","Address Line 1, ","Address Line 1, ","Effective date,  ","Start Date, ","Start Date, ","Effective Date, ","Start Date, ","Start Date, ","AVC Provider Code, ","Name Code, ","Event Date, ","Scheme, ","Remark No, "]
[null,"Surname, ",null,"Start Reason, ","Employer, ","Period Number, ",null,null,"Paypoint, ","Paypoint, ","Part-time hours, ","Hours variation, ","End Date, ","Percent, ","Start Date, ","Nomination Date, ","Type, ","Benefit Type, ","Usage, "]
[null,"Name1, ",null,"Scheme, ","Paypoint, ","End Date, ",null,null,"Bonus Code, ","Employer, ","Full-time hours, ","Employer, ","Hours variation, ",null,"Contribution Frequency, ",null,null,null,"Remark, "]
[null,"Title, ",null,"Scheme Category, ","Notional Pay, ","Employer, ",null,null,"Employer, ","Allowance Code, ",null,null,"Employer, "]
[null,"Sex, ",null,"Status, ",null,"Paypoint, ",null,null,"Amount, ","Allowance Rate, "]
[null,"Marital Status, ",null,"Employer, ",null,"Scheme, "]
[null,"Date of Birth, "]
[]
[]
[]
["Date Fields","Date of Birth, ","Date of Birth, ","Start Date, ","Salary Start Date, ","Start Date, ","Effective Date, ","Effective Date, ","Effective date,  ","Start Date, ","Start Date, ","Effective Date, ","Start Date, ","Start Date, ","Contract Start Date,  ","Date of Birth, ","Event Date,","Service Start Date,"]
[null,"Spouse Date of Birth, ","Spouse Date of Birth, ","End Date, ","End Date, ","End Date, ",null,null,null,"End Date, ","End Date, ",null,null,null,"Valuation Date, ","Nomination Date, ","Action Date, ","End Date, "]
[null,"Date marriage ceased, ","NRD Override Date, ",null,null,null,null,null,null,null,null,null,null,null,"AVC Conts End Date, ",null,null,"Date Received, "]
[null,"Date first joined CS, ","Date marriage ceased, ",null,null,null,null,null,null,null,null,null,null,null,"Claim Date, ",null,null,"Deemed Date, "]
[null,"Contractual Rtmt Date, ","Contractual Rtmt Date, "]
[]
[]
[]
[]
["Error Messages"]
[]
[]
[]
[]
[]
[null,"Validation Report",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,null,null,null,null,null,null,null,null,null,null,"ADMIN CONTROLS"]
[]
[null,null,"WorkSheet Name","Number of Members with Errors"]
[null,null,{"$f":"B1","v":"Basic Details New Members"},0]
[null,null,{"$f":"C1","v":"Basic Details Existing Members"},0]
[null,null,{"$f":"D1","v":"Service History"},0]
[null,null,{"$f":"E1","v":"Salary Details"},0]
[null,null,{"$f":"F1","v":"Pay History"},0]
[null,null,{"$f":"G1","v":"Home Address"},0]
[null,null,{"$f":"H1","v":"Office Address"},0,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,null,null,null,null,null,null,null,"Validation Run",null,true]
[null,null,{"$f":"I1","v":"Pensionable Bonus"},0,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,null,null,null,null,null,null,null,"Number of Errors",null,0]
[null,null,{"$f":"J1","v":"Pensionable Allowance"},0]
[null,null,{"$f":"K1","v":"Part Time Hours"},0,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,null,null,null,null,null,null,null,null,null,false]
[null,null,{"$f":"L1","v":"Short Time Hours"},0]
[null,null,{"$f":"M1","v":"Short Time Hours (accum)"},0]
[null,null,{"$f":"N1","v":"WPS Rate History"},0]
[null,null,{"$f":"O1","v":"AVC History"},0]
[null,null,{"$f":"P1","v":"Beneficiary Details"},0]
[null,null,{"$f":"Q1","v":"Event Details"},0]
[null,null,{"$f":"R1","v":"Other Benefits"},0]
[null,null,{"$f":"S1","v":"Remarks"},0]
[null,null,"Contribution Rate",0]
[null,null,"Total",{"$f":"SUM(D31:D49)","v":0}]

{"sheet":"Valid Pick Lists","index":24,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Scheme","Scheme Catagory","Schemes"]
["PCS","C","CSO"]
["PCS","P","PCS"]
["PCS","P2","N"]
["PCS","N"]
["PCS","Q"]
["PCS","QS"]
["PCS","N1"]
["PCS","N2"]
["PCS","N3"]
["PCS","N4"]
["PCS","Q1"]
["PCS","Q2"]
["PCS","Q3"]
["PCS","Q4"]
["PCS","S1"]
["PCS","S2"]
["PCS","S3"]
["PCS","S4"]
["CSO","A"]
["CSO","N"]
["CSO","Q"]
["CSO","QS"]
["N","N"]